Forms Personlization [message #516412] |
Mon, 18 July 2011 00:14 |
sreerpriya
Messages: 8 Registered: May 2009
|
Junior Member |
|
|
Hi All,
I have the below snippet in FP.
='declare
errbuf varchar2(1000);
retcode number;
XXDC_PAYMENT_METHOD VARCHAR2(50);
XXDC_TOT_PROM_AMT1 NUMBER;
begin
XXDC_TOT_PROM_AMT1 := :global.XXDC_TOT_PROM_AMT;
IF XXDC_TOT_PROM_AMT IS NOT NULL THEN
XXDC_PAYMENT_METHOD := :global.XXDC_MPROM_METH;
ELSE
XXDC_PAYMENT_METHOD := :global.XXDC_SPROM_METH.value;
END IF;
xxdc_iex_pmt_promise_pkg.xxdc_iex_ptp_burst_p
(errbuf, retcode,
'''||${global.XXDC_PROMISE_ID.value}||''',
'''||${global.XXDC_PROMISE_AMOUNT.value}||''' ,
XXDC_PAYMENT_METHOD);
end'
encountering error ORA01008 not all variables bound
please help
Thanks in advance
|
|
|