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 95: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

91: ln_re_tax_amount NUMBER;
92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
93: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
94: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
95: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
97: BEGIN
98: --logging for debug
99: IF (ln_proc_level >= ln_dbg_level)

Line 96: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

92: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
93: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
94: lv_procedure_name VARCHAR2(40):='Get_Recoverable_Amount';
95: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
96: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
97: BEGIN
98: --logging for debug
99: IF (ln_proc_level >= ln_dbg_level)
100: THEN

Line 101: FND_LOG.STRING( ln_proc_level

97: BEGIN
98: --logging for debug
99: IF (ln_proc_level >= ln_dbg_level)
100: THEN
101: FND_LOG.STRING( ln_proc_level
102: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
103: , 'Enter procedure'
104: );
105: END IF; --l_proc_level>=l_dbg_level

Line 123: FND_LOG.STRING( ln_proc_level

119:
120: IF (ln_proc_level >= ln_dbg_level)
121: THEN
122:
123: FND_LOG.STRING( ln_proc_level
124: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_tax_amount'
125: , 'pn_tax_amount :' || pn_tax_amount
126: );
127:

Line 128: FND_LOG.STRING( ln_proc_level

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

Line 133: FND_LOG.STRING( ln_proc_level

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

Line 138: FND_LOG.STRING( ln_proc_level

134: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.pn_conver_rate'
135: , 'pn_conver_rate :' || pn_conver_rate
136: );
137:
138: FND_LOG.STRING( ln_proc_level
139: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
140: , 'ln_re_tax_amount' || ln_re_tax_amount
141: );
142:

Line 143: FND_LOG.STRING( ln_proc_level

139: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
140: , 'ln_re_tax_amount' || ln_re_tax_amount
141: );
142:
143: FND_LOG.STRING( ln_proc_level
144: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
145: , 'Exit procedure'
146: );
147: END IF; --l_proc_level>=l_dbg_level

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

149:
150: RETURN NVL(ln_re_tax_amount,0) ;
151: EXCEPTION
152: WHEN OTHERS THEN
153: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
154: THEN
155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
156: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
157: , Sqlcode||Sqlerrm);

Line 155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

151: EXCEPTION
152: WHEN OTHERS THEN
153: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
154: THEN
155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
156: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
157: , Sqlcode||Sqlerrm);
158: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
159: RAISE;

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

154: THEN
155: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
156: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
157: , Sqlcode||Sqlerrm);
158: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
159: RAISE;
160: END Get_Recoverable_Amount;
161:
162: --==========================================================================

Line 209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

205: ln_nr_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
208: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
210: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
211: BEGIN
212: --logging for debug
213: IF (ln_proc_level >= ln_dbg_level)

Line 210: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

206: ln_mod_cr_percent jai_cmn_taxes_all.MOD_CR_PERCENTAGE%TYPE;
207: ln_rounding_factor jai_cmn_taxes_all.rounding_factor%TYPE;
208: lv_procedure_name VARCHAR2(40):='Get_NonRecoverable_Amount';
209: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
210: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
211: BEGIN
212: --logging for debug
213: IF (ln_proc_level >= ln_dbg_level)
214: THEN

Line 215: FND_LOG.STRING( ln_proc_level

211: BEGIN
212: --logging for debug
213: IF (ln_proc_level >= ln_dbg_level)
214: THEN
215: FND_LOG.STRING( ln_proc_level
216: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
217: , 'Enter procedure'
218: );
219: END IF; --l_proc_level>=l_dbg_level

Line 236: FND_LOG.STRING( ln_proc_level

232:
233: --logging for debug
234: IF (ln_proc_level >= ln_dbg_level)
235: THEN
236: FND_LOG.STRING( ln_proc_level
237: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
238: , 'Exit procedure'
239: );
240: END IF; -- (ln_proc_level>=ln_dbg_level)

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

241:
242: RETURN NVL(ln_nr_tax_amount,0) ;
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
246: THEN
247: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
248: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
249: , Sqlcode||Sqlerrm);

Line 247: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

243: EXCEPTION
244: WHEN OTHERS THEN
245: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
246: THEN
247: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
248: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
249: , Sqlcode||Sqlerrm);
250: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
251: RAISE;

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

246: THEN
247: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
248: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
249: , Sqlcode||Sqlerrm);
250: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
251: RAISE;
252: END Get_NonRecoverable_Amount;
253:
254: --==========================================================================

Line 299: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 300: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

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

Line 305: FND_LOG.STRING( ln_proc_level

301: BEGIN
302: --logging for debug
303: IF (ln_proc_level >= ln_dbg_level)
304: THEN
305: FND_LOG.STRING( ln_proc_level
306: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
307: , 'Enter procedure'
308: );
309: FND_LOG.STRING( ln_proc_level

Line 309: FND_LOG.STRING( ln_proc_level

305: FND_LOG.STRING( ln_proc_level
306: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
307: , 'Enter procedure'
308: );
309: FND_LOG.STRING( ln_proc_level
310: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
311: , 'pn_line_change_id :'|| pn_line_change_id
312: );
313: END IF; --l_proc_level>=l_dbg_level

Line 343: FND_LOG.STRING( ln_proc_level

339:
340: --logging for debug
341: IF (ln_proc_level >= ln_dbg_level)
342: THEN
343: FND_LOG.STRING( ln_proc_level
344: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
345: , 'ln_tot_modif_nr_tax_amt :'|| ln_tot_modif_nr_tax_amt
346: );
347:

Line 348: FND_LOG.STRING( ln_proc_level

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

Line 353: FND_LOG.STRING( ln_proc_level

349: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
350: , 'ln_tot_org_nr_tax_amt :'|| ln_tot_org_nr_tax_amt
351: );
352:
353: FND_LOG.STRING( ln_proc_level
354: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
355: , 'ln_tot_diff_nr_tax_amt :'|| ln_tot_diff_nr_tax_amt
356: );
357:

Line 358: FND_LOG.STRING( ln_proc_level

354: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.parameter'
355: , 'ln_tot_diff_nr_tax_amt :'|| ln_tot_diff_nr_tax_amt
356: );
357:
358: FND_LOG.STRING( ln_proc_level
359: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
360: , 'Exit procedure'
361: );
362: END IF; -- (ln_proc_level>=ln_dbg_level)

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

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

Line 373: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

369: EXCEPTION
370: WHEN OTHERS THEN
371: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
372: THEN
373: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
374: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
375: , Sqlcode||Sqlerrm);
376: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
377: RAISE;

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

372: THEN
373: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
374: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
375: , Sqlcode||Sqlerrm);
376: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
377: RAISE;
378: END Get_Tot_NonRe_Tax_Amount;
379:
380: --==========================================================================

Line 463: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

459: ln_tot_re_vat_amt NUMBER :=0;
460: ln_modif_tot_re_vat_amt NUMBER :=0;
461:
462: lv_procedure_name VARCHAR2(40):='Get_Vat_CenVat_Amount';
463: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
464: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
465:
466:
467: BEGIN

Line 464: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

460: ln_modif_tot_re_vat_amt NUMBER :=0;
461:
462: lv_procedure_name VARCHAR2(40):='Get_Vat_CenVat_Amount';
463: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
464: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
465:
466:
467: BEGIN
468:

Line 472: FND_LOG.STRING( ln_proc_level

468:
469: --logging for debug
470: IF (ln_proc_level >= ln_dbg_level)
471: THEN
472: FND_LOG.STRING( ln_proc_level
473: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
474: , 'Enter procedure'
475: );
476: END IF; --l_proc_level>=l_dbg_level

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

508: xn_diff_re_vat_amount := ln_modif_tot_re_vat_amt - ln_tot_re_vat_amt;
509:
510: EXCEPTION
511: WHEN OTHERS THEN
512: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
513: THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
515: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
516: , Sqlcode||Sqlerrm);

Line 514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

510: EXCEPTION
511: WHEN OTHERS THEN
512: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
513: THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
515: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
516: , Sqlcode||Sqlerrm);
517: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: RAISE;

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

513: THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
515: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
516: , Sqlcode||Sqlerrm);
517: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: RAISE;
519: END Get_Vat_CenVat_Amount;
520:
521: --==========================================================================

Line 558: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 559: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

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

Line 705: FND_LOG.STRING( ln_proc_level

701: END LOOP;
702: --logging for debug
703: IF (ln_proc_level >= ln_dbg_level)
704: THEN
705: FND_LOG.STRING( ln_proc_level
706: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
707: , 'Exit procedure'
708: );
709: END IF; -- (ln_proc_level>=ln_dbg_level)

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

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

Line 714: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

710: EXCEPTION
711: WHEN OTHERS THEN
712: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
713: THEN
714: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
715: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
716: , Sqlcode||Sqlerrm);
717: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
718: RAISE;

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

713: THEN
714: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
715: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
716: , Sqlcode||Sqlerrm);
717: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
718: RAISE;
719: END Get_Tax_Amount_Breakup;
720:
721: --==========================================================================

Line 760: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

756:
757: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
758:
759: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
760: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
761: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
762:
763: BEGIN
764: --logging for debug

Line 761: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

757: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
758:
759: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
760: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
761: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
762:
763: BEGIN
764: --logging for debug
765: IF (ln_proc_level >= ln_dbg_level)

Line 767: FND_LOG.STRING( ln_proc_level

763: BEGIN
764: --logging for debug
765: IF (ln_proc_level >= ln_dbg_level)
766: THEN
767: FND_LOG.STRING( ln_proc_level
768: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
769: , 'Enter procedure'
770: );
771: END IF; --l_proc_level>=l_dbg_level

Line 781: FND_LOG.STRING( ln_proc_level

777:
778: --logging for debug
779: IF (ln_proc_level >= ln_dbg_level)
780: THEN
781: FND_LOG.STRING( ln_proc_level
782: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
783: , 'Exit procedure'
784: );
785: END IF; -- (ln_proc_level>=ln_dbg_level)

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

785: END IF; -- (ln_proc_level>=ln_dbg_level)
786: RETURN jai_rcv_transactions_rec;
787: EXCEPTION
788: WHEN OTHERS THEN
789: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN
791: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
792: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
793: , Sqlcode||Sqlerrm);

Line 791: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

787: EXCEPTION
788: WHEN OTHERS THEN
789: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN
791: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
792: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
793: , Sqlcode||Sqlerrm);
794: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
795: RAISE;

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

790: THEN
791: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
792: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
793: , Sqlcode||Sqlerrm);
794: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
795: RAISE;
796: END Get_Jai_Rcv_Trans_Record;
797:
798: --==========================================================================

Line 836: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

832:
833: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
834:
835: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
836: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
837: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
838: BEGIN
839: --logging for debug
840: IF (ln_proc_level >= ln_dbg_level)

Line 837: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

833: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
834:
835: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
836: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
837: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
838: BEGIN
839: --logging for debug
840: IF (ln_proc_level >= ln_dbg_level)
841: THEN

Line 842: FND_LOG.STRING( ln_proc_level

838: BEGIN
839: --logging for debug
840: IF (ln_proc_level >= ln_dbg_level)
841: THEN
842: FND_LOG.STRING( ln_proc_level
843: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
844: , 'Enter procedure'
845: );
846: END IF; --l_proc_level>=l_dbg_level

Line 856: FND_LOG.STRING( ln_proc_level

852:
853: --logging for debug
854: IF (ln_proc_level >= ln_dbg_level)
855: THEN
856: FND_LOG.STRING( ln_proc_level
857: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
858: , 'Exit procedure'
859: );
860: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 944: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 945: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

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

Line 951: FND_LOG.STRING( ln_proc_level

947: BEGIN
948: --logging for debug
949: IF (ln_proc_level >= ln_dbg_level)
950: THEN
951: FND_LOG.STRING( ln_proc_level
952: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
953: , 'Enter procedure'
954: );
955: END IF; --l_proc_level>=l_dbg_level

Line 1365: FND_LOG.STRING( ln_proc_level

1361:
1362: --logging for debug
1363: IF (ln_proc_level >= ln_dbg_level)
1364: THEN
1365: FND_LOG.STRING( ln_proc_level
1366: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1367: , 'Exit procedure'
1368: );
1369: END IF; -- (ln_proc_level>=ln_dbg_level)

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

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

Line 1375: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1371: EXCEPTION
1372: WHEN OTHERS THEN
1373: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1374: THEN
1375: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1376: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1377: , Sqlcode||Sqlerrm);
1378: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1379: RAISE;

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

1374: THEN
1375: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1376: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1377: , Sqlcode||Sqlerrm);
1378: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1379: RAISE;
1380: END Do_Unclaim;
1381:
1382:

Line 1447: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1443: lv_process_message VARCHAR2(4000);
1444: lv_process_status VARCHAR2(4000);
1445:
1446: lv_procedure_name VARCHAR2(40):='Do_Accounting';
1447: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1448: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1449:
1450:
1451: BEGIN

Line 1448: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1444: lv_process_status VARCHAR2(4000);
1445:
1446: lv_procedure_name VARCHAR2(40):='Do_Accounting';
1447: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1448: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1449:
1450:
1451: BEGIN
1452:

Line 1456: FND_LOG.STRING( ln_proc_level

1452:
1453: --logging for debug
1454: IF (ln_proc_level >= ln_dbg_level)
1455: THEN
1456: FND_LOG.STRING( ln_proc_level
1457: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1458: , 'Enter procedure'
1459: );
1460: END IF; --l_proc_level>=l_dbg_level

Line 1704: FND_LOG.STRING( ln_proc_level

1700: END IF;
1701: --logging for debug
1702: IF (ln_proc_level >= ln_dbg_level)
1703: THEN
1704: FND_LOG.STRING( ln_proc_level
1705: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1706: , 'Exit procedure'
1707: );
1708: END IF; -- (ln_proc_level>=ln_dbg_level)

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

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

Line 1713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1712: THEN
1713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1714: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1715: , Sqlcode||Sqlerrm);
1716: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1717: RAISE;

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

1712: THEN
1713: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1714: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
1715: , Sqlcode||Sqlerrm);
1716: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1717: RAISE;
1718: END Do_Accounting;
1719:
1720: --==========================================================================

Line 1879: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1875: AND jrrl.shipment_line_id = jrl.shipment_line_id
1876: AND jrrl.regime_code = jrd.regime_code;
1877:
1878: lv_procedure_name VARCHAR2(40):='Do_Vat_Claim';
1879: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1880: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1881:
1882: BEGIN
1883: --logging for debug

Line 1880: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1876: AND jrrl.regime_code = jrd.regime_code;
1877:
1878: lv_procedure_name VARCHAR2(40):='Do_Vat_Claim';
1879: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1880: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1881:
1882: BEGIN
1883: --logging for debug
1884: IF (ln_proc_level >= ln_dbg_level)

Line 1886: FND_LOG.STRING( ln_proc_level

1882: BEGIN
1883: --logging for debug
1884: IF (ln_proc_level >= ln_dbg_level)
1885: THEN
1886: FND_LOG.STRING( ln_proc_level
1887: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1888: , 'Enter procedure'
1889: );
1890: END IF; --l_proc_level>=l_dbg_level

Line 2192: FND_LOG.STRING( ln_proc_level

2188:
2189: --logging for debug
2190: IF (ln_proc_level >= ln_dbg_level)
2191: THEN
2192: FND_LOG.STRING( ln_proc_level
2193: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
2194: , 'Exit procedure'
2195: );
2196: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

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

2196: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
2197: EXCEPTION
2198: WHEN OTHERS
2199: THEN
2200: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2201: THEN
2202: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2203: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2204: , Sqlcode||Sqlerrm);

Line 2202: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2198: WHEN OTHERS
2199: THEN
2200: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2201: THEN
2202: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2203: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2204: , Sqlcode||Sqlerrm);
2205: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2206: RAISE;

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

2201: THEN
2202: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2203: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2204: , Sqlcode||Sqlerrm);
2205: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2206: RAISE;
2207: END Do_Vat_Claim;
2208:
2209: --==========================================================================

Line 2280: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2276:
2277: jai_transaction_rec get_jai_transaction_cur%ROWTYPE;
2278:
2279: lv_procedure_name VARCHAR2(40):='Do_Cenvat_Claim';
2280: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2281: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2282: lv_amount_register VARCHAR2(15);/*added by rchandan*/
2283: ln_cenvat_claimed_ptg NUMBER;/*added by rchandan*/
2284:

Line 2281: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2277: jai_transaction_rec get_jai_transaction_cur%ROWTYPE;
2278:
2279: lv_procedure_name VARCHAR2(40):='Do_Cenvat_Claim';
2280: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2281: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2282: lv_amount_register VARCHAR2(15);/*added by rchandan*/
2283: ln_cenvat_claimed_ptg NUMBER;/*added by rchandan*/
2284:
2285: --added by eric for bug 6918495 and bug 6914567 on Mar 28, 2008,begin

Line 2296: FND_LOG.STRING( ln_proc_level

2292: BEGIN
2293: --logging for debug
2294: IF (ln_proc_level >= ln_dbg_level)
2295: THEN
2296: FND_LOG.STRING( ln_proc_level
2297: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2298: , 'Enter procedure'
2299: );
2300: END IF; --l_proc_level>=l_dbg_level

Line 2534: FND_LOG.STRING( ln_proc_level

2530:
2531: --logging for debug
2532: IF (ln_proc_level >= ln_dbg_level)
2533: THEN
2534: FND_LOG.STRING( ln_proc_level
2535: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
2536: , 'Exit procedure'
2537: );
2538: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

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

2537: );
2538: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2542: THEN
2543: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2544: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2545: , Sqlcode||Sqlerrm);

Line 2543: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2542: THEN
2543: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2544: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2545: , Sqlcode||Sqlerrm);
2546: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2547: RAISE;

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

2542: THEN
2543: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2544: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
2545: , Sqlcode||Sqlerrm);
2546: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2547: RAISE;
2548: END Do_Cenvat_Claim;
2549: --==========================================================================
2550: -- PROCEDURE NAME:

Line 2713: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2709: FROM jai_retro_line_changes a
2710: WHERE a.line_location_id = jrlc.line_location_id
2711: ) ;
2712: lv_procedure_name VARCHAR2(40):='Process_Retroactive_Update';
2713: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2714: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2715:
2716: BEGIN
2717: --logging for debug

Line 2714: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2710: WHERE a.line_location_id = jrlc.line_location_id
2711: ) ;
2712: lv_procedure_name VARCHAR2(40):='Process_Retroactive_Update';
2713: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2714: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2715:
2716: BEGIN
2717: --logging for debug
2718: IF (ln_proc_level >= ln_dbg_level)

Line 2720: FND_LOG.STRING( ln_proc_level

2716: BEGIN
2717: --logging for debug
2718: IF (ln_proc_level >= ln_dbg_level)
2719: THEN
2720: FND_LOG.STRING( ln_proc_level
2721: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2722: , 'Enter procedure'
2723: );
2724: END IF; --l_proc_level>=l_dbg_level

Line 3291: FND_LOG.STRING( ln_proc_level

3287: END IF ;
3288: --logging for debug
3289: IF (ln_proc_level >= ln_dbg_level)
3290: THEN
3291: FND_LOG.STRING( ln_proc_level
3292: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
3293: , 'Exit procedure'
3294: );
3295: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug

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

3294: );
3295: END IF; -- (ln_proc_level>=ln_dbg_level) --logging for debug
3296: EXCEPTION
3297: WHEN OTHERS THEN
3298: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3299: THEN
3300: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3301: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3302: , Sqlcode||Sqlerrm);

Line 3300: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

3296: EXCEPTION
3297: WHEN OTHERS THEN
3298: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3299: THEN
3300: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3301: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3302: , Sqlcode||Sqlerrm);
3303: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3304: retcode := 2;

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

3299: THEN
3300: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3301: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.Other_Exception '
3302: , Sqlcode||Sqlerrm);
3303: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3304: retcode := 2;
3305: errbuf := Sqlerrm;
3306: --RAISE; BUG #6788048
3307: RETURN;