eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RETRO_PRC_PKG dependencies on FND_LOG

Line 90: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

86: ln_re_tax_amount NUMBER;
87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
88: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
89: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
90: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
91: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
92: BEGIN
93: --logging for debug
94: IF (ln_proc_level >= ln_dbg_level)

Line 91: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

87: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
88: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
89: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
90: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
91: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
92: BEGIN
93: --logging for debug
94: IF (ln_proc_level >= ln_dbg_level)
95: THEN

Line 96: FND_LOG.STRING( ln_proc_level

92: BEGIN
93: --logging for debug
94: IF (ln_proc_level >= ln_dbg_level)
95: THEN
96: FND_LOG.STRING( ln_proc_level
97: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
98: , 'Enter procedure'
99: );
100: END IF; --l_proc_level>=l_dbg_level

Line 118: FND_LOG.STRING( ln_proc_level

114:
115: IF (ln_proc_level >= ln_dbg_level)
116: THEN
117:
118: FND_LOG.STRING( ln_proc_level
119: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_tax_amount'
120: , 'pn_tax_amount :' || pn_tax_amount
121: );
122:

Line 123: FND_LOG.STRING( ln_proc_level

119: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_tax_amount'
120: , 'pn_tax_amount :' || pn_tax_amount
121: );
122:
123: FND_LOG.STRING( ln_proc_level
124: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.ln_mod_cr_percent'
125: , 'ln_mod_cr_percent :' || ln_mod_cr_percent
126: );
127:

Line 128: FND_LOG.STRING( ln_proc_level

124: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.ln_mod_cr_percent'
125: , 'ln_mod_cr_percent :' || ln_mod_cr_percent
126: );
127:
128: FND_LOG.STRING( ln_proc_level
129: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_conver_rate'
130: , 'pn_conver_rate :' || pn_conver_rate
131: );
132:

Line 133: FND_LOG.STRING( ln_proc_level

129: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_conver_rate'
130: , 'pn_conver_rate :' || pn_conver_rate
131: );
132:
133: FND_LOG.STRING( ln_proc_level
134: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
135: , 'ln_re_tax_amount' || ln_re_tax_amount
136: );
137:

Line 138: FND_LOG.STRING( ln_proc_level

134: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
135: , 'ln_re_tax_amount' || ln_re_tax_amount
136: );
137:
138: FND_LOG.STRING( ln_proc_level
139: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
140: , 'Exit procedure'
141: );
142: END IF; --l_proc_level>=l_dbg_level

Line 148: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

144:
145: RETURN NVL(ln_re_tax_amount,0) ;
146: EXCEPTION
147: WHEN OTHERS THEN
148: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
149: THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
151: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
152: , Sqlcode||Sqlerrm);

Line 150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

146: EXCEPTION
147: WHEN OTHERS THEN
148: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
149: THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
151: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
152: , Sqlcode||Sqlerrm);
153: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
154: RAISE;

Line 153: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

149: THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
151: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
152: , Sqlcode||Sqlerrm);
153: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
154: RAISE;
155: END Get_Recoverable_Amount;
156:
157: --==========================================================================

Line 204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

200: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
203: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
205: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
206: BEGIN
207: --logging for debug
208: IF (ln_proc_level >= ln_dbg_level)

Line 205: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

201: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
202: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
203: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
204: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
205: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
206: BEGIN
207: --logging for debug
208: IF (ln_proc_level >= ln_dbg_level)
209: THEN

Line 210: FND_LOG.STRING( ln_proc_level

206: BEGIN
207: --logging for debug
208: IF (ln_proc_level >= ln_dbg_level)
209: THEN
210: FND_LOG.STRING( ln_proc_level
211: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
212: , 'Enter procedure'
213: );
214: END IF; --l_proc_level>=l_dbg_level

Line 231: FND_LOG.STRING( ln_proc_level

227:
228: --logging for debug
229: IF (ln_proc_level >= ln_dbg_level)
230: THEN
231: FND_LOG.STRING( ln_proc_level
232: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
233: , 'Exit procedure'
234: );
235: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 240: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

236:
237: RETURN NVL(ln_nr_tax_amount,0) ;
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
241: THEN
242: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
243: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
244: , Sqlcode||Sqlerrm);

Line 242: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

238: EXCEPTION
239: WHEN OTHERS THEN
240: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
241: THEN
242: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
243: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
244: , Sqlcode||Sqlerrm);
245: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
246: RAISE;

Line 245: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

241: THEN
242: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
243: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
244: , Sqlcode||Sqlerrm);
245: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
246: RAISE;
247: END Get_NonRecoverable_Amount;
248:
249: --==========================================================================

Line 294: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

290: ln_tot_modif_nr_tax_amt NUMBER :=0; --eric added for bug 6957519/6958938/6968839 on Apr 10,2008
291: ln_tot_diff_nr_tax_amt NUMBER :=0; --eric added for bug 6957519/6958938/6968839 on Apr 10,2008
292:
293: lv_procedure_name VARCHAR2(40):='Get_Tot_NonRe_Tax_Amount';
294: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
295: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
296: BEGIN
297: --logging for debug
298: IF (ln_proc_level >= ln_dbg_level)

Line 295: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

291: ln_tot_diff_nr_tax_amt NUMBER :=0; --eric added for bug 6957519/6958938/6968839 on Apr 10,2008
292:
293: lv_procedure_name VARCHAR2(40):='Get_Tot_NonRe_Tax_Amount';
294: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
295: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
296: BEGIN
297: --logging for debug
298: IF (ln_proc_level >= ln_dbg_level)
299: THEN

Line 300: FND_LOG.STRING( ln_proc_level

296: BEGIN
297: --logging for debug
298: IF (ln_proc_level >= ln_dbg_level)
299: THEN
300: FND_LOG.STRING( ln_proc_level
301: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
302: , 'Enter procedure'
303: );
304: FND_LOG.STRING( ln_proc_level

Line 304: FND_LOG.STRING( ln_proc_level

300: FND_LOG.STRING( ln_proc_level
301: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
302: , 'Enter procedure'
303: );
304: FND_LOG.STRING( ln_proc_level
305: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
306: , 'pn_line_change_id :'|| pn_line_change_id
307: );
308: END IF; --l_proc_level>=l_dbg_level

Line 338: FND_LOG.STRING( ln_proc_level

334:
335: --logging for debug
336: IF (ln_proc_level >= ln_dbg_level)
337: THEN
338: FND_LOG.STRING( ln_proc_level
339: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
340: , 'ln_tot_modif_nr_tax_amt :'|| ln_tot_modif_nr_tax_amt
341: );
342:

Line 343: FND_LOG.STRING( ln_proc_level

339: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
340: , 'ln_tot_modif_nr_tax_amt :'|| ln_tot_modif_nr_tax_amt
341: );
342:
343: FND_LOG.STRING( ln_proc_level
344: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
345: , 'ln_tot_org_nr_tax_amt :'|| ln_tot_org_nr_tax_amt
346: );
347:

Line 348: FND_LOG.STRING( ln_proc_level

344: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
345: , 'ln_tot_org_nr_tax_amt :'|| ln_tot_org_nr_tax_amt
346: );
347:
348: FND_LOG.STRING( ln_proc_level
349: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
350: , 'ln_tot_diff_nr_tax_amt :'|| ln_tot_diff_nr_tax_amt
351: );
352:

Line 353: FND_LOG.STRING( ln_proc_level

349: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
350: , 'ln_tot_diff_nr_tax_amt :'|| ln_tot_diff_nr_tax_amt
351: );
352:
353: FND_LOG.STRING( ln_proc_level
354: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
355: , 'Exit procedure'
356: );
357: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 366: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

362: ---------------------------------------------
363: --eric deleted for bug 6957519/6958938/6968839 on Apr 10,2008,end
364: EXCEPTION
365: WHEN OTHERS THEN
366: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
367: THEN
368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
369: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
370: , Sqlcode||Sqlerrm);

Line 368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

364: EXCEPTION
365: WHEN OTHERS THEN
366: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
367: THEN
368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
369: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
370: , Sqlcode||Sqlerrm);
371: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
372: RAISE;

Line 371: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

367: THEN
368: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
369: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
370: , Sqlcode||Sqlerrm);
371: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
372: RAISE;
373: END Get_Tot_NonRe_Tax_Amount;
374:
375: --==========================================================================

Line 458: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

454: ln_tot_re_vat_amt NUMBER :=0;
455: ln_modif_tot_re_vat_amt NUMBER :=0;
456:
457: lv_procedure_name VARCHAR2(40):='Get_Vat_CenVat_Amount';
458: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
459: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
460:
461:
462: BEGIN

Line 459: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

455: ln_modif_tot_re_vat_amt NUMBER :=0;
456:
457: lv_procedure_name VARCHAR2(40):='Get_Vat_CenVat_Amount';
458: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
459: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
460:
461:
462: BEGIN
463:

Line 467: FND_LOG.STRING( ln_proc_level

463:
464: --logging for debug
465: IF (ln_proc_level >= ln_dbg_level)
466: THEN
467: FND_LOG.STRING( ln_proc_level
468: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
469: , 'Enter procedure'
470: );
471: END IF; --l_proc_level>=l_dbg_level

Line 507: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

503: xn_diff_re_vat_amount := ln_modif_tot_re_vat_amt - ln_tot_re_vat_amt;
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
508: THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
510: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
511: , Sqlcode||Sqlerrm);

Line 509: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

505: EXCEPTION
506: WHEN OTHERS THEN
507: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
508: THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
510: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
511: , Sqlcode||Sqlerrm);
512: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
513: RAISE;

Line 512: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

508: THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
510: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
511: , Sqlcode||Sqlerrm);
512: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
513: RAISE;
514: END Get_Vat_CenVat_Amount;
515:
516: --==========================================================================

Line 553: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

549: ln_nonmod_problem_amt NUMBER;
550: ln_apportion_factor NUMBER;
551:
552: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Breakup';
553: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
554: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
555: BEGIN
556: --This procedure returns excise amounts as per transaction quantity
557: --If p_breakup_type is RG23D, then total tax amount should be added to excise amount instead of taking

Line 554: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

550: ln_apportion_factor NUMBER;
551:
552: lv_procedure_name VARCHAR2(40):='Get_Tax_Amount_Breakup';
553: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
554: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
555: BEGIN
556: --This procedure returns excise amounts as per transaction quantity
557: --If p_breakup_type is RG23D, then total tax amount should be added to excise amount instead of taking
558: --mod_cr_percentage into consideration

Line 700: FND_LOG.STRING( ln_proc_level

696: END LOOP;
697: --logging for debug
698: IF (ln_proc_level >= ln_dbg_level)
699: THEN
700: FND_LOG.STRING( ln_proc_level
701: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
702: , 'Exit procedure'
703: );
704: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 707: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

703: );
704: END IF; -- (ln_proc_level>=ln_dbg_level)
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
708: THEN
709: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
710: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
711: , Sqlcode||Sqlerrm);

Line 709: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

705: EXCEPTION
706: WHEN OTHERS THEN
707: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
708: THEN
709: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
710: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
711: , Sqlcode||Sqlerrm);
712: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
713: RAISE;

Line 712: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

708: THEN
709: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
710: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
711: , Sqlcode||Sqlerrm);
712: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
713: RAISE;
714: END Get_Tax_Amount_Breakup;
715:
716: --==========================================================================

Line 755: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

751:
752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
753:
754: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
755: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
756: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
757:
758: BEGIN
759: --logging for debug

Line 756: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
753:
754: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
755: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
756: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
757:
758: BEGIN
759: --logging for debug
760: IF (ln_proc_level >= ln_dbg_level)

Line 762: FND_LOG.STRING( ln_proc_level

758: BEGIN
759: --logging for debug
760: IF (ln_proc_level >= ln_dbg_level)
761: THEN
762: FND_LOG.STRING( ln_proc_level
763: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
764: , 'Enter procedure'
765: );
766: END IF; --l_proc_level>=l_dbg_level

Line 776: FND_LOG.STRING( ln_proc_level

772:
773: --logging for debug
774: IF (ln_proc_level >= ln_dbg_level)
775: THEN
776: FND_LOG.STRING( ln_proc_level
777: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
778: , 'Exit procedure'
779: );
780: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 784: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

780: END IF; -- (ln_proc_level>=ln_dbg_level)
781: RETURN jai_rcv_transactions_rec;
782: EXCEPTION
783: WHEN OTHERS THEN
784: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
785: THEN
786: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
787: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
788: , Sqlcode||Sqlerrm);

Line 786: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

782: EXCEPTION
783: WHEN OTHERS THEN
784: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
785: THEN
786: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
787: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
788: , Sqlcode||Sqlerrm);
789: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: RAISE;

Line 789: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

785: THEN
786: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
787: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
788: , Sqlcode||Sqlerrm);
789: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: RAISE;
791: END Get_Jai_Rcv_Trans_Record;
792:
793: --==========================================================================

Line 831: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

827:
828: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
829:
830: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
831: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
832: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
833: BEGIN
834: --logging for debug
835: IF (ln_proc_level >= ln_dbg_level)

Line 832: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

828: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
829:
830: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
831: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
832: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
833: BEGIN
834: --logging for debug
835: IF (ln_proc_level >= ln_dbg_level)
836: THEN

Line 837: FND_LOG.STRING( ln_proc_level

833: BEGIN
834: --logging for debug
835: IF (ln_proc_level >= ln_dbg_level)
836: THEN
837: FND_LOG.STRING( ln_proc_level
838: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
839: , 'Enter procedure'
840: );
841: END IF; --l_proc_level>=l_dbg_level

Line 851: FND_LOG.STRING( ln_proc_level

847:
848: --logging for debug
849: IF (ln_proc_level >= ln_dbg_level)
850: THEN
851: FND_LOG.STRING( ln_proc_level
852: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
853: , 'Exit procedure'
854: );
855: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 939: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

935: lv_period_name gl_periods.period_name%TYPE;
936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
937: ln_user_id NUMBER := fnd_global.user_id;
938: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
939: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
940: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
941: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/
942: BEGIN
943: --logging for debug

Line 940: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
937: ln_user_id NUMBER := fnd_global.user_id;
938: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
939: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
940: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
941: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/
942: BEGIN
943: --logging for debug
944: IF (ln_proc_level >= ln_dbg_level)

Line 946: FND_LOG.STRING( ln_proc_level

942: BEGIN
943: --logging for debug
944: IF (ln_proc_level >= ln_dbg_level)
945: THEN
946: FND_LOG.STRING( ln_proc_level
947: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
948: , 'Enter procedure'
949: );
950: END IF; --l_proc_level>=l_dbg_level

Line 1360: FND_LOG.STRING( ln_proc_level

1356:
1357: --logging for debug
1358: IF (ln_proc_level >= ln_dbg_level)
1359: THEN
1360: FND_LOG.STRING( ln_proc_level
1361: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1362: , 'Exit procedure'
1363: );
1364: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1368: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1364: END IF; -- (ln_proc_level>=ln_dbg_level)
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1369: THEN
1370: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1371: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1372: , Sqlcode||Sqlerrm);

Line 1370: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1369: THEN
1370: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1371: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1372: , Sqlcode||Sqlerrm);
1373: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1374: RAISE;

Line 1373: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1369: THEN
1370: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1371: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1372: , Sqlcode||Sqlerrm);
1373: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1374: RAISE;
1375: END Do_Unclaim;
1376:
1377:

Line 1442: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1438: lv_process_message VARCHAR2(4000);
1439: lv_process_status VARCHAR2(4000);
1440:
1441: lv_procedure_name VARCHAR2(40):='Do_Accounting';
1442: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1443: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1444:
1445:
1446: BEGIN

Line 1443: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1439: lv_process_status VARCHAR2(4000);
1440:
1441: lv_procedure_name VARCHAR2(40):='Do_Accounting';
1442: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1443: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1444:
1445:
1446: BEGIN
1447:

Line 1451: FND_LOG.STRING( ln_proc_level

1447:
1448: --logging for debug
1449: IF (ln_proc_level >= ln_dbg_level)
1450: THEN
1451: FND_LOG.STRING( ln_proc_level
1452: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1453: , 'Enter procedure'
1454: );
1455: END IF; --l_proc_level>=l_dbg_level

Line 1699: FND_LOG.STRING( ln_proc_level

1695: END IF;
1696: --logging for debug
1697: IF (ln_proc_level >= ln_dbg_level)
1698: THEN
1699: FND_LOG.STRING( ln_proc_level
1700: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1701: , 'Exit procedure'
1702: );
1703: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1702: );
1703: END IF; -- (ln_proc_level>=ln_dbg_level)
1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1707: THEN
1708: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1709: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1710: , Sqlcode||Sqlerrm);

Line 1708: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1704: EXCEPTION
1705: WHEN OTHERS THEN
1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1707: THEN
1708: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1709: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1710: , Sqlcode||Sqlerrm);
1711: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1712: RAISE;

Line 1711: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1707: THEN
1708: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1709: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1710: , Sqlcode||Sqlerrm);
1711: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1712: RAISE;
1713: END Do_Accounting;
1714:
1715: --==========================================================================

Line 1874: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1870: AND jrrl.shipment_line_id = jrl.shipment_line_id
1871: AND jrrl.regime_code = jrd.regime_code;
1872:
1873: lv_procedure_name VARCHAR2(40):='Do_Vat_Claim';
1874: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1875: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1876:
1877: BEGIN
1878: --logging for debug

Line 1875: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1871: AND jrrl.regime_code = jrd.regime_code;
1872:
1873: lv_procedure_name VARCHAR2(40):='Do_Vat_Claim';
1874: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1875: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1876:
1877: BEGIN
1878: --logging for debug
1879: IF (ln_proc_level >= ln_dbg_level)

Line 1881: FND_LOG.STRING( ln_proc_level

1877: BEGIN
1878: --logging for debug
1879: IF (ln_proc_level >= ln_dbg_level)
1880: THEN
1881: FND_LOG.STRING( ln_proc_level
1882: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1883: , 'Enter procedure'
1884: );
1885: END IF; --l_proc_level>=l_dbg_level

Line 2183: FND_LOG.STRING( ln_proc_level

2179:
2180: --logging for debug
2181: IF (ln_proc_level >= ln_dbg_level)
2182: THEN
2183: FND_LOG.STRING( ln_proc_level
2184: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
2185: , 'Exit procedure'
2186: );
2187: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

Line 2191: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2187: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
2188: EXCEPTION
2189: WHEN OTHERS
2190: THEN
2191: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2192: THEN
2193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2194: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2195: , Sqlcode||Sqlerrm);

Line 2193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2189: WHEN OTHERS
2190: THEN
2191: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2192: THEN
2193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2194: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2195: , Sqlcode||Sqlerrm);
2196: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2197: RAISE;

Line 2196: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2192: THEN
2193: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2194: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2195: , Sqlcode||Sqlerrm);
2196: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2197: RAISE;
2198: END Do_Vat_Claim;
2199:
2200: --==========================================================================

Line 2271: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2267:
2268: jai_transaction_rec get_jai_transaction_cur%ROWTYPE;
2269:
2270: lv_procedure_name VARCHAR2(40):='Do_Cenvat_Claim';
2271: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2272: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2273: lv_amount_register VARCHAR2(15);/*added by rchandan*/
2274: ln_cenvat_claimed_ptg NUMBER;/*added by rchandan*/
2275:

Line 2272: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2268: jai_transaction_rec get_jai_transaction_cur%ROWTYPE;
2269:
2270: lv_procedure_name VARCHAR2(40):='Do_Cenvat_Claim';
2271: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2272: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2273: lv_amount_register VARCHAR2(15);/*added by rchandan*/
2274: ln_cenvat_claimed_ptg NUMBER;/*added by rchandan*/
2275:
2276: --added by eric for bug 6918495 and bug 6914567 on Mar 28, 2008,begin

Line 2287: FND_LOG.STRING( ln_proc_level

2283: BEGIN
2284: --logging for debug
2285: IF (ln_proc_level >= ln_dbg_level)
2286: THEN
2287: FND_LOG.STRING( ln_proc_level
2288: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2289: , 'Enter procedure'
2290: );
2291: END IF; --l_proc_level>=l_dbg_level

Line 2525: FND_LOG.STRING( ln_proc_level

2521:
2522: --logging for debug
2523: IF (ln_proc_level >= ln_dbg_level)
2524: THEN
2525: FND_LOG.STRING( ln_proc_level
2526: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
2527: , 'Exit procedure'
2528: );
2529: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

Line 2532: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2528: );
2529: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2533: THEN
2534: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2535: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2536: , Sqlcode||Sqlerrm);

Line 2534: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2533: THEN
2534: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2535: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2536: , Sqlcode||Sqlerrm);
2537: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2538: RAISE;

Line 2537: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2533: THEN
2534: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2535: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2536: , Sqlcode||Sqlerrm);
2537: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2538: RAISE;
2539: END Do_Cenvat_Claim;
2540: --==========================================================================
2541: -- PROCEDURE NAME:

Line 2700: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2696: FROM jai_retro_line_changes a
2697: WHERE a.line_location_id = jrlc.line_location_id
2698: ) ;
2699: lv_procedure_name VARCHAR2(40):='Process_Retroactive_Update';
2700: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2701: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2702:
2703: BEGIN
2704: --logging for debug

Line 2701: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2697: WHERE a.line_location_id = jrlc.line_location_id
2698: ) ;
2699: lv_procedure_name VARCHAR2(40):='Process_Retroactive_Update';
2700: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2701: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2702:
2703: BEGIN
2704: --logging for debug
2705: IF (ln_proc_level >= ln_dbg_level)

Line 2707: FND_LOG.STRING( ln_proc_level

2703: BEGIN
2704: --logging for debug
2705: IF (ln_proc_level >= ln_dbg_level)
2706: THEN
2707: FND_LOG.STRING( ln_proc_level
2708: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2709: , 'Enter procedure'
2710: );
2711: END IF; --l_proc_level>=l_dbg_level

Line 3246: FND_LOG.STRING( ln_proc_level

3242: END IF ;
3243: --logging for debug
3244: IF (ln_proc_level >= ln_dbg_level)
3245: THEN
3246: FND_LOG.STRING( ln_proc_level
3247: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
3248: , 'Exit procedure'
3249: );
3250: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

Line 3253: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3249: );
3250: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
3251: EXCEPTION
3252: WHEN OTHERS THEN
3253: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3254: THEN
3255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3256: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3257: , Sqlcode||Sqlerrm);

Line 3255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

3251: EXCEPTION
3252: WHEN OTHERS THEN
3253: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3254: THEN
3255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3256: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3257: , Sqlcode||Sqlerrm);
3258: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3259: retcode := 2;

Line 3258: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3254: THEN
3255: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3256: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3257: , Sqlcode||Sqlerrm);
3258: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3259: retcode := 2;
3260: errbuf := Sqlerrm;
3261: --RAISE; BUG #6788048
3262: RETURN;