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.AR_GTA_ARTRX_PROC dependencies on FND_LOG

Line 211: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

207: PROCEDURE log(p_level IN VARCHAR2,
208: p_module IN VARCHAR2,
209: p_message IN VARCHAR2) IS
210: BEGIN
211: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: fnd_log.STRING(LOG_LEVEL => p_level,
213: MODULE => p_module,
214: MESSAGE => p_message);
215: END IF;

Line 212: fnd_log.STRING(LOG_LEVEL => p_level,

208: p_module IN VARCHAR2,
209: p_message IN VARCHAR2) IS
210: BEGIN
211: IF (p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: fnd_log.STRING(LOG_LEVEL => p_level,
213: MODULE => p_module,
214: MESSAGE => p_message);
215: END IF;
216: END;

Line 249: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;

245: l_procedure_name VARCHAR2(30) := 'transfer_AR_to_GTA';
246: l_gta_trx_tbl_4ar ar_gta_trx_util.trx_tbl_type := ar_gta_trx_util.trx_tbl_type();
247: l_gta_trx_tbl_4gta ar_gta_trx_util.trx_tbl_type := ar_gta_trx_util.trx_tbl_type();
248: BEGIN
249: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;
250:
251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
253: G_MODULE_PREFIX || l_procedure_name,

Line 251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

247: l_gta_trx_tbl_4gta ar_gta_trx_util.trx_tbl_type := ar_gta_trx_util.trx_tbl_type();
248: BEGIN
249: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;
250:
251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
253: G_MODULE_PREFIX || l_procedure_name,
254: 'Begin Procedure. ');
255: END IF;

Line 252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

248: BEGIN
249: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;
250:
251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
253: G_MODULE_PREFIX || l_procedure_name,
254: 'Begin Procedure. ');
255: END IF;
256:

Line 262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

258: p_transfer_id => p_transfer_id,
259: p_conc_parameters => p_conc_parameters,
260: x_GTA_TRX_Tbl => l_GTA_trx_tbl_4AR);
261:
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: log(FND_LOG.LEVEL_PROCEDURE,
264: G_MODULE_PREFIX || l_procedure_name,
265: 'End Retrive_valid_ar_trx......');
266: log(FND_LOG.LEVEL_PROCEDURE,

Line 263: log(FND_LOG.LEVEL_PROCEDURE,

259: p_conc_parameters => p_conc_parameters,
260: x_GTA_TRX_Tbl => l_GTA_trx_tbl_4AR);
261:
262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: log(FND_LOG.LEVEL_PROCEDURE,
264: G_MODULE_PREFIX || l_procedure_name,
265: 'End Retrive_valid_ar_trx......');
266: log(FND_LOG.LEVEL_PROCEDURE,
267: G_MODULE_PREFIX || l_procedure_name,

Line 266: log(FND_LOG.LEVEL_PROCEDURE,

262: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
263: log(FND_LOG.LEVEL_PROCEDURE,
264: G_MODULE_PREFIX || l_procedure_name,
265: 'End Retrive_valid_ar_trx......');
266: log(FND_LOG.LEVEL_PROCEDURE,
267: G_MODULE_PREFIX || l_procedure_name,
268: 'l_gta_trx_tbl_4ar.count:' || l_GTA_trx_tbl_4AR.COUNT);
269: END IF;
270:

Line 275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

271: ar_gta_split_trx_proc.split_Transactions(p_org_id => p_org_id,
272: p_transfer_id => p_transfer_id,
273: p_gta_trx_tbl => l_gta_trx_tbl_4ar,
274: x_gta_trx_tbl => l_gta_trx_tbl_4gta);
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: log(FND_LOG.LEVEL_PROCEDURE,
277: G_MODULE_PREFIX || l_procedure_name,
278: 'End Split_transactions......' || l_gta_trx_tbl_4gta.COUNT);
279: END IF;

Line 276: log(FND_LOG.LEVEL_PROCEDURE,

272: p_transfer_id => p_transfer_id,
273: p_gta_trx_tbl => l_gta_trx_tbl_4ar,
274: x_gta_trx_tbl => l_gta_trx_tbl_4gta);
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: log(FND_LOG.LEVEL_PROCEDURE,
277: G_MODULE_PREFIX || l_procedure_name,
278: 'End Split_transactions......' || l_gta_trx_tbl_4gta.COUNT);
279: END IF;
280:

Line 283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

279: END IF;
280:
281: ar_gta_trx_util.create_TRXs(p_gta_trxs => l_gta_trx_tbl_4gta);
282:
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: log(FND_LOG.LEVEL_PROCEDURE,
285: G_MODULE_PREFIX || l_procedure_name,
286: 'End Create_trxs......');
287: END IF;

Line 284: log(FND_LOG.LEVEL_PROCEDURE,

280:
281: ar_gta_trx_util.create_TRXs(p_gta_trxs => l_gta_trx_tbl_4gta);
282:
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: log(FND_LOG.LEVEL_PROCEDURE,
285: G_MODULE_PREFIX || l_procedure_name,
286: 'End Create_trxs......');
287: END IF;
288:

Line 295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

291: generate_XML_output(p_org_id => p_org_id,
292: p_transfer_id => p_transfer_id,
293: p_conc_parameters => p_conc_parameters);
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: log(FND_LOG.LEVEL_PROCEDURE,
297: G_MODULE_PREFIX || l_procedure_name,
298: 'End generate_XML_output......');
299: END IF;

Line 296: log(FND_LOG.LEVEL_PROCEDURE,

292: p_transfer_id => p_transfer_id,
293: p_conc_parameters => p_conc_parameters);
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: log(FND_LOG.LEVEL_PROCEDURE,
297: G_MODULE_PREFIX || l_procedure_name,
298: 'End generate_XML_output......');
299: END IF;
300:

Line 301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

297: G_MODULE_PREFIX || l_procedure_name,
298: 'End generate_XML_output......');
299: END IF;
300:
301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.String(fnd_log.LEVEL_PROCEDURE,
303: G_MODULE_PREFIX || l_procedure_name,
304: 'END procedure. ');
305: END IF;

Line 302: FND_LOG.String(fnd_log.LEVEL_PROCEDURE,

298: 'End generate_XML_output......');
299: END IF;
300:
301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
302: FND_LOG.String(fnd_log.LEVEL_PROCEDURE,
303: G_MODULE_PREFIX || l_procedure_name,
304: 'END procedure. ');
305: END IF;
306:

Line 309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

305: END IF;
306:
307: EXCEPTION
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
311: G_MODULE_PREFIX || l_procedure_name ||
312: '. UNEXPECTED_ERROR',
313: 'Unexpected error' || SQLCODE || SQLERRM);

Line 310: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,

306:
307: EXCEPTION
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
310: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
311: G_MODULE_PREFIX || l_procedure_name ||
312: '. UNEXPECTED_ERROR',
313: 'Unexpected error' || SQLCODE || SQLERRM);
314: END IF;

Line 318: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

314: END IF;
315: RAISE;
316:
317: WHEN OTHERS THEN
318: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
320: G_MODULE_PREFIX || l_procedure_name ||
321: '. OTHER_EXCEPTION ',
322: 'Unknown error' || SQLCODE || SQLERRM);

Line 319: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

315: RAISE;
316:
317: WHEN OTHERS THEN
318: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
320: G_MODULE_PREFIX || l_procedure_name ||
321: '. OTHER_EXCEPTION ',
322: 'Unknown error' || SQLCODE || SQLERRM);
323:

Line 478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

474: --12/04/2006 Jogen Hu bug 5144561
475:
476: BEGIN
477:
478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
480: G_MODULE_PREFIX || l_procedure_name,
481: 'Begin Procedure. ');
482: END IF;

Line 479: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

475:
476: BEGIN
477:
478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
480: G_MODULE_PREFIX || l_procedure_name,
481: 'Begin Procedure. ');
482: END IF;
483:

Line 498: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

494: WHERE rule.rule_header_id = p_transfer_id;
495: EXCEPTION
496: WHEN no_data_found THEN
497:
498: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
500: G_MODULE_PREFIX || l_procedure_name,
501: 'No data found ');
502: END IF;

Line 499: fnd_log.String(fnd_log.LEVEL_EXCEPTION,

495: EXCEPTION
496: WHEN no_data_found THEN
497:
498: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
500: G_MODULE_PREFIX || l_procedure_name,
501: 'No data found ');
502: END IF;
503: RAISE;

Line 518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

514:
515: EXCEPTION
516: WHEN no_data_found THEN
517:
518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
520: G_MODULE_PREFIX || l_procedure_name,
521: 'No data found ');
522: END IF;

Line 519: fnd_log.String(fnd_log.LEVEL_EXCEPTION,

515: EXCEPTION
516: WHEN no_data_found THEN
517:
518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
519: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
520: G_MODULE_PREFIX || l_procedure_name,
521: 'No data found ');
522: END IF;
523: RAISE;

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

579: EXCEPTION
580: WHEN OTHERS THEN
581: fnd_file.PUT_LINE(fnd_file.log,'|||----333----||'||l_transaction_id);
582:
583: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
584: THEN
585: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
586: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
587: , 'Unknown error'||SQLCODE||SQLERRM);

Line 585: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

581: fnd_file.PUT_LINE(fnd_file.log,'|||----333----||'||l_transaction_id);
582:
583: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
584: THEN
585: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
586: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
587: , 'Unknown error'||SQLCODE||SQLERRM);
588:
589: END IF;

Line 742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

738:
739: -- concurrent output
740: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
741:
742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
743: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
744: END IF;
745:
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

742: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
743: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
744: END IF;
745:
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: fnd_log.String(fnd_log.LEVEL_PROCEDURE,
748: G_MODULE_PREFIX || l_procedure_name,
749: 'END procedure. ');
750: END IF;

Line 747: fnd_log.String(fnd_log.LEVEL_PROCEDURE,

743: AR_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
744: END IF;
745:
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: fnd_log.String(fnd_log.LEVEL_PROCEDURE,
748: G_MODULE_PREFIX || l_procedure_name,
749: 'END procedure. ');
750: END IF;
751:

Line 754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

750: END IF;
751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
756: G_MODULE_PREFIX || l_procedure_name ||
757: '. OTHER_EXCEPTION ',
758: 'Unknown error' || SQLCODE || SQLERRM);

Line 755: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,

751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
756: G_MODULE_PREFIX || l_procedure_name ||
757: '. OTHER_EXCEPTION ',
758: 'Unknown error' || SQLCODE || SQLERRM);
759:

Line 799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

795: l_gta_trx_tbl ar_gta_trx_util.trx_tbl_type := ar_gta_trx_util.trx_tbl_type();
796: l_invoice_type_code VARCHAR2(1);
797: BEGIN
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,
801: G_MODULE_PREFIX || l_procedure_name,
802: 'Begin Procedure. ');
803: END IF;

Line 800: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,

796: l_invoice_type_code VARCHAR2(1);
797: BEGIN
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,
801: G_MODULE_PREFIX || l_procedure_name,
802: 'Begin Procedure. ');
803: END IF;
804:

Line 805: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

801: G_MODULE_PREFIX || l_procedure_name,
802: 'Begin Procedure. ');
803: END IF;
804:
805: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: log(FND_LOG.LEVEL_PROCEDURE,
807: G_MODULE_PREFIX || l_procedure_name,
808: 'Begin Retrive_valid_ar_trx......');
809: END IF;

Line 806: log(FND_LOG.LEVEL_PROCEDURE,

802: 'Begin Procedure. ');
803: END IF;
804:
805: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: log(FND_LOG.LEVEL_PROCEDURE,
807: G_MODULE_PREFIX || l_procedure_name,
808: 'Begin Retrive_valid_ar_trx......');
809: END IF;
810:

Line 820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

816: x_flex_parameter => l_flex_parameter,
817: x_other_parameter => l_other_parameter,
818: x_currency_code => l_currency_code);
819:
820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: log(FND_LOG.LEVEL_PROCEDURE,
822: G_MODULE_PREFIX || l_procedure_name,
823: 'End get AR sql......');
824: END IF;

Line 821: log(FND_LOG.LEVEL_PROCEDURE,

817: x_other_parameter => l_other_parameter,
818: x_currency_code => l_currency_code);
819:
820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: log(FND_LOG.LEVEL_PROCEDURE,
822: G_MODULE_PREFIX || l_procedure_name,
823: 'End get AR sql......');
824: END IF;
825:

Line 835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

831: p_other_query_para => l_other_parameter,
832: p_currency_code => l_currency_code,
833: x_GTA_TRX_TBL => x_GTA_TRX_Tbl);
834:
835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: log(FND_LOG.LEVEL_PROCEDURE,
837: G_MODULE_PREFIX || l_procedure_name,
838: 'End retrieve_ar_trxs......');
839: log(FND_LOG.LEVEL_PROCEDURE,

Line 836: log(FND_LOG.LEVEL_PROCEDURE,

832: p_currency_code => l_currency_code,
833: x_GTA_TRX_TBL => x_GTA_TRX_Tbl);
834:
835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: log(FND_LOG.LEVEL_PROCEDURE,
837: G_MODULE_PREFIX || l_procedure_name,
838: 'End retrieve_ar_trxs......');
839: log(FND_LOG.LEVEL_PROCEDURE,
840: G_MODULE_PREFIX || l_procedure_name,

Line 839: log(FND_LOG.LEVEL_PROCEDURE,

835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: log(FND_LOG.LEVEL_PROCEDURE,
837: G_MODULE_PREFIX || l_procedure_name,
838: 'End retrieve_ar_trxs......');
839: log(FND_LOG.LEVEL_PROCEDURE,
840: G_MODULE_PREFIX || l_procedure_name,
841: 'l_GTA_TRX_Tbl:' || x_GTA_TRX_Tbl.COUNT);
842: END IF;
843:

Line 854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

850: ,
851: p_gta_trx_tbl => l_gta_Trx_tbl,
852: x_gta_Trx_tbl => x_gta_trx_tbl);
853: -- recovered by Yao Zhang for bug 7644235 end
854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: log(FND_LOG.LEVEL_PROCEDURE,
856: G_MODULE_PREFIX || l_procedure_name,
857: 'End filter_credit_memo......');
858: END IF;

Line 855: log(FND_LOG.LEVEL_PROCEDURE,

851: p_gta_trx_tbl => l_gta_Trx_tbl,
852: x_gta_Trx_tbl => x_gta_trx_tbl);
853: -- recovered by Yao Zhang for bug 7644235 end
854: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: log(FND_LOG.LEVEL_PROCEDURE,
856: G_MODULE_PREFIX || l_procedure_name,
857: 'End filter_credit_memo......');
858: END IF;
859:

Line 860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

856: G_MODULE_PREFIX || l_procedure_name,
857: 'End filter_credit_memo......');
858: END IF;
859:
860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,
862: G_MODULE_PREFIX || l_procedure_name,
863: 'END procedure. ');
864: END IF;

Line 861: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,

857: 'End filter_credit_memo......');
858: END IF;
859:
860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING(fnd_log.LEVEL_PROCEDURE,
862: G_MODULE_PREFIX || l_procedure_name,
863: 'END procedure. ');
864: END IF;
865:

Line 868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

864: END IF;
865:
866: EXCEPTION
867: WHEN OTHERS THEN
868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
870: G_MODULE_PREFIX || l_procedure_name ||
871: '. OTHER_EXCEPTION ',
872: 'Unknown error' || SQLCODE || SQLERRM);

Line 869: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

865:
866: EXCEPTION
867: WHEN OTHERS THEN
868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
870: G_MODULE_PREFIX || l_procedure_name ||
871: '. OTHER_EXCEPTION ',
872: 'Unknown error' || SQLCODE || SQLERRM);
873: END IF;

Line 926: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

922: l_procedure_name VARCHAR2(30) := 'Get_AR_SQL';
923:
924: BEGIN
925:
926: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
928: G_MODULE_PREFIX || l_procedure_name,
929: 'Begin Procedure. ');
930: END IF;

Line 927: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

923:
924: BEGIN
925:
926: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
928: G_MODULE_PREFIX || l_procedure_name,
929: 'Begin Procedure. ');
930: END IF;
931:

Line 932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

928: G_MODULE_PREFIX || l_procedure_name,
929: 'Begin Procedure. ');
930: END IF;
931:
932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: log(FND_LOG.LEVEL_PROCEDURE,
934: G_MODULE_PREFIX || l_procedure_name,
935: 'Begin get AR sql......');
936: log(FND_LOG.LEVEL_PROCEDURE,

Line 933: log(FND_LOG.LEVEL_PROCEDURE,

929: 'Begin Procedure. ');
930: END IF;
931:
932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: log(FND_LOG.LEVEL_PROCEDURE,
934: G_MODULE_PREFIX || l_procedure_name,
935: 'Begin get AR sql......');
936: log(FND_LOG.LEVEL_PROCEDURE,
937: G_MODULE_PREFIX || l_procedure_name,

Line 936: log(FND_LOG.LEVEL_PROCEDURE,

932: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: log(FND_LOG.LEVEL_PROCEDURE,
934: G_MODULE_PREFIX || l_procedure_name,
935: 'Begin get AR sql......');
936: log(FND_LOG.LEVEL_PROCEDURE,
937: G_MODULE_PREFIX || l_procedure_name,
938: 'P_ORG_ID: ' || P_ORG_ID);
939: log(FND_LOG.LEVEL_PROCEDURE,
940: G_MODULE_PREFIX || l_procedure_name,

Line 939: log(FND_LOG.LEVEL_PROCEDURE,

935: 'Begin get AR sql......');
936: log(FND_LOG.LEVEL_PROCEDURE,
937: G_MODULE_PREFIX || l_procedure_name,
938: 'P_ORG_ID: ' || P_ORG_ID);
939: log(FND_LOG.LEVEL_PROCEDURE,
940: G_MODULE_PREFIX || l_procedure_name,
941: 'p_transfer_id: ' || p_transfer_id);
942: END IF;
943:

Line 981: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

977: p_transfer_id => p_transfer_id,
978: x_condition_sql => l_TRX_TYPE_condition,
979: x_query_parameter => x_trxtype_parameter);
980:
981: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
982: log(FND_LOG.LEVEL_PROCEDURE,
983: G_MODULE_PREFIX || l_procedure_name,
984: 'End GET_AR_TRXTYPE_COND......');
985: log(FND_LOG.LEVEL_PROCEDURE,

Line 982: log(FND_LOG.LEVEL_PROCEDURE,

978: x_condition_sql => l_TRX_TYPE_condition,
979: x_query_parameter => x_trxtype_parameter);
980:
981: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
982: log(FND_LOG.LEVEL_PROCEDURE,
983: G_MODULE_PREFIX || l_procedure_name,
984: 'End GET_AR_TRXTYPE_COND......');
985: log(FND_LOG.LEVEL_PROCEDURE,
986: G_MODULE_PREFIX || l_procedure_name,

Line 985: log(FND_LOG.LEVEL_PROCEDURE,

981: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
982: log(FND_LOG.LEVEL_PROCEDURE,
983: G_MODULE_PREFIX || l_procedure_name,
984: 'End GET_AR_TRXTYPE_COND......');
985: log(FND_LOG.LEVEL_PROCEDURE,
986: G_MODULE_PREFIX || l_procedure_name,
987: 'l_TRX_TYPE_condition:' || l_TRX_TYPE_condition);
988: END IF;
989:

Line 996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

992: p_transfer_id => p_transfer_id,
993: x_condition_sql => l_flex_condition,
994: x_query_parameter => x_flex_parameter);
995:
996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: log(FND_LOG.LEVEL_PROCEDURE,
998: G_MODULE_PREFIX || l_procedure_name,
999: 'End GET_AR_FLEX_COND......');
1000: log(FND_LOG.LEVEL_PROCEDURE,

Line 997: log(FND_LOG.LEVEL_PROCEDURE,

993: x_condition_sql => l_flex_condition,
994: x_query_parameter => x_flex_parameter);
995:
996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: log(FND_LOG.LEVEL_PROCEDURE,
998: G_MODULE_PREFIX || l_procedure_name,
999: 'End GET_AR_FLEX_COND......');
1000: log(FND_LOG.LEVEL_PROCEDURE,
1001: G_MODULE_PREFIX || l_procedure_name,

Line 1000: log(FND_LOG.LEVEL_PROCEDURE,

996: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: log(FND_LOG.LEVEL_PROCEDURE,
998: G_MODULE_PREFIX || l_procedure_name,
999: 'End GET_AR_FLEX_COND......');
1000: log(FND_LOG.LEVEL_PROCEDURE,
1001: G_MODULE_PREFIX || l_procedure_name,
1002: 'l_flex_condition:' || l_flex_condition);
1003: END IF;
1004:

Line 1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1008: p_conc_parameters => p_conc_parameters,
1009: x_condition_sql => l_other_condition,
1010: x_query_parameter => x_other_parameter);
1011:
1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1013: log(FND_LOG.LEVEL_PROCEDURE,
1014: G_MODULE_PREFIX || l_procedure_name,
1015: 'End GET_param_COND......');
1016: log(FND_LOG.LEVEL_PROCEDURE,

Line 1013: log(FND_LOG.LEVEL_PROCEDURE,

1009: x_condition_sql => l_other_condition,
1010: x_query_parameter => x_other_parameter);
1011:
1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1013: log(FND_LOG.LEVEL_PROCEDURE,
1014: G_MODULE_PREFIX || l_procedure_name,
1015: 'End GET_param_COND......');
1016: log(FND_LOG.LEVEL_PROCEDURE,
1017: G_MODULE_PREFIX || l_procedure_name,

Line 1016: log(FND_LOG.LEVEL_PROCEDURE,

1012: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1013: log(FND_LOG.LEVEL_PROCEDURE,
1014: G_MODULE_PREFIX || l_procedure_name,
1015: 'End GET_param_COND......');
1016: log(FND_LOG.LEVEL_PROCEDURE,
1017: G_MODULE_PREFIX || l_procedure_name,
1018: 'l_other_condition:' || l_other_condition);
1019: END IF;
1020:

Line 1027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1023: p_transfer_id => p_transfer_id,
1024: x_condition_sql => l_currency_condition,
1025: x_currency_code => x_currency_code);
1026:
1027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: log(FND_LOG.LEVEL_PROCEDURE,
1029: G_MODULE_PREFIX || l_procedure_name,
1030: 'End Get_AR_Currency_Cond......');
1031: log(FND_LOG.LEVEL_PROCEDURE,

Line 1028: log(FND_LOG.LEVEL_PROCEDURE,

1024: x_condition_sql => l_currency_condition,
1025: x_currency_code => x_currency_code);
1026:
1027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: log(FND_LOG.LEVEL_PROCEDURE,
1029: G_MODULE_PREFIX || l_procedure_name,
1030: 'End Get_AR_Currency_Cond......');
1031: log(FND_LOG.LEVEL_PROCEDURE,
1032: G_MODULE_PREFIX || l_procedure_name,

Line 1031: log(FND_LOG.LEVEL_PROCEDURE,

1027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1028: log(FND_LOG.LEVEL_PROCEDURE,
1029: G_MODULE_PREFIX || l_procedure_name,
1030: 'End Get_AR_Currency_Cond......');
1031: log(FND_LOG.LEVEL_PROCEDURE,
1032: G_MODULE_PREFIX || l_procedure_name,
1033: 'l_currency_condition:' || l_currency_condition);
1034: END IF;
1035:

Line 1042: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1038: Get_Invoice_Type(p_ORG_ID => p_org_id,
1039: p_transfer_id => p_transfer_id,
1040: x_condition_sql => l_invoice_type_condition);
1041: */
1042: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: log(FND_LOG.LEVEL_PROCEDURE,
1044: G_MODULE_PREFIX || l_procedure_name,
1045: 'End Get_Invoice_Type......');
1046: log(FND_LOG.LEVEL_PROCEDURE,

Line 1043: log(FND_LOG.LEVEL_PROCEDURE,

1039: p_transfer_id => p_transfer_id,
1040: x_condition_sql => l_invoice_type_condition);
1041: */
1042: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: log(FND_LOG.LEVEL_PROCEDURE,
1044: G_MODULE_PREFIX || l_procedure_name,
1045: 'End Get_Invoice_Type......');
1046: log(FND_LOG.LEVEL_PROCEDURE,
1047: G_MODULE_PREFIX || l_procedure_name,

Line 1046: log(FND_LOG.LEVEL_PROCEDURE,

1042: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1043: log(FND_LOG.LEVEL_PROCEDURE,
1044: G_MODULE_PREFIX || l_procedure_name,
1045: 'End Get_Invoice_Type......');
1046: log(FND_LOG.LEVEL_PROCEDURE,
1047: G_MODULE_PREFIX || l_procedure_name,
1048: 'l_invoice_type_condition:' || l_invoice_type_condition);
1049: END IF;
1050:

Line 1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1075: END IF;
1076:
1077: x_query_sql := l_select_sql;
1078:
1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: log(FND_LOG.LEVEL_PROCEDURE,
1081: G_MODULE_PREFIX || l_procedure_name,
1082: 'l_select_sql:' || l_select_sql);
1083: END IF;

Line 1080: log(FND_LOG.LEVEL_PROCEDURE,

1076:
1077: x_query_sql := l_select_sql;
1078:
1079: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1080: log(FND_LOG.LEVEL_PROCEDURE,
1081: G_MODULE_PREFIX || l_procedure_name,
1082: 'l_select_sql:' || l_select_sql);
1083: END IF;
1084:

Line 1086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1082: 'l_select_sql:' || l_select_sql);
1083: END IF;
1084:
1085: -- log output the ar sql
1086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1088: G_MODULE_PREFIX || l_procedure_name,
1089: l_select_sql);
1090: END IF;

Line 1087: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1083: END IF;
1084:
1085: -- log output the ar sql
1086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1088: G_MODULE_PREFIX || l_procedure_name,
1089: l_select_sql);
1090: END IF;
1091:

Line 1092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1088: G_MODULE_PREFIX || l_procedure_name,
1089: l_select_sql);
1090: END IF;
1091:
1092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1094: G_MODULE_PREFIX || l_procedure_name,
1095: 'END procedure. ');
1096: END IF;

Line 1093: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1089: l_select_sql);
1090: END IF;
1091:
1092: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1094: G_MODULE_PREFIX || l_procedure_name,
1095: 'END procedure. ');
1096: END IF;
1097:

Line 1100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1102: G_MODULE_PREFIX || l_procedure_name ||
1103: '. OTHER_EXCEPTION ',
1104: 'Unknown error' || SQLCODE || SQLERRM);

Line 1101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1102: G_MODULE_PREFIX || l_procedure_name ||
1103: '. OTHER_EXCEPTION ',
1104: 'Unknown error' || SQLCODE || SQLERRM);
1105:

Line 1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1136: l_transaction_type_cnt NUMBER;
1137:
1138: BEGIN
1139:
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1142: G_MODULE_PREFIX || l_procedure_name,
1143: 'Begin Procedure. ');
1144: END IF;

Line 1141: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1137:
1138: BEGIN
1139:
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1142: G_MODULE_PREFIX || l_procedure_name,
1143: 'Begin Procedure. ');
1144: END IF;
1145:

Line 1146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1142: G_MODULE_PREFIX || l_procedure_name,
1143: 'Begin Procedure. ');
1144: END IF;
1145:
1146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: log(FND_LOG.LEVEL_PROCEDURE,
1148: G_MODULE_PREFIX || l_procedure_name,
1149: 'Begin Get_Invoice_Type......');
1150: log(FND_LOG.LEVEL_PROCEDURE,

Line 1147: log(FND_LOG.LEVEL_PROCEDURE,

1143: 'Begin Procedure. ');
1144: END IF;
1145:
1146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: log(FND_LOG.LEVEL_PROCEDURE,
1148: G_MODULE_PREFIX || l_procedure_name,
1149: 'Begin Get_Invoice_Type......');
1150: log(FND_LOG.LEVEL_PROCEDURE,
1151: G_MODULE_PREFIX || l_procedure_name,

Line 1150: log(FND_LOG.LEVEL_PROCEDURE,

1146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: log(FND_LOG.LEVEL_PROCEDURE,
1148: G_MODULE_PREFIX || l_procedure_name,
1149: 'Begin Get_Invoice_Type......');
1150: log(FND_LOG.LEVEL_PROCEDURE,
1151: G_MODULE_PREFIX || l_procedure_name,
1152: 'p_org_id:' || p_org_id || ' ' || 'p_transfer_id:' ||
1153: p_transfer_id);
1154: END IF;

Line 1178: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1174: '||l_error_string
1175: ||'
1176: ');
1177:
1178: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1180: ,G_MODULE_PREFIX || l_procedure_name
1181: , 'no data found when select invoice_type.');
1182: END IF;

Line 1179: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1175: ||'
1176: ');
1177:
1178: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1179: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1180: ,G_MODULE_PREFIX || l_procedure_name
1181: , 'no data found when select invoice_type.');
1182: END IF;
1183: RAISE;

Line 1222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1218: l_error_string ||
1219: '
1220: '); --Modified by Yao Zhang for bug 7667709
1221:
1222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1224: G_MODULE_PREFIX || l_procedure_name,
1225: 'no data found when select invoice_type.');
1226: END IF;

Line 1223: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

1219: '
1220: '); --Modified by Yao Zhang for bug 7667709
1221:
1222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1224: G_MODULE_PREFIX || l_procedure_name,
1225: 'no data found when select invoice_type.');
1226: END IF;
1227: RAISE;

Line 1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1242: END IF; /*l_invoice_type_code = 'A'*/
1243:
1244: END IF; /*l_invoice_type_code IS NOT NULL*/
1245:
1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1248: G_MODULE_PREFIX || l_procedure_name,
1249: 'END procedure. ');
1250: END IF;

Line 1247: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1243:
1244: END IF; /*l_invoice_type_code IS NOT NULL*/
1245:
1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1248: G_MODULE_PREFIX || l_procedure_name,
1249: 'END procedure. ');
1250: END IF;
1251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1247: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1248: G_MODULE_PREFIX || l_procedure_name,
1249: 'END procedure. ');
1250: END IF;
1251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1252: log(FND_LOG.LEVEL_PROCEDURE,
1253: G_MODULE_PREFIX || l_procedure_name,
1254: 'End Get_Invoice_Type......');
1255: END IF;

Line 1252: log(FND_LOG.LEVEL_PROCEDURE,

1248: G_MODULE_PREFIX || l_procedure_name,
1249: 'END procedure. ');
1250: END IF;
1251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1252: log(FND_LOG.LEVEL_PROCEDURE,
1253: G_MODULE_PREFIX || l_procedure_name,
1254: 'End Get_Invoice_Type......');
1255: END IF;
1256: EXCEPTION

Line 1258: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1254: 'End Get_Invoice_Type......');
1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1260: G_MODULE_PREFIX || l_procedure_name ||
1261: '. OTHER_EXCEPTION ',
1262: 'Unknown error' || SQLCODE || SQLERRM);

Line 1259: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1260: G_MODULE_PREFIX || l_procedure_name ||
1261: '. OTHER_EXCEPTION ',
1262: 'Unknown error' || SQLCODE || SQLERRM);
1263:

Line 1313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1309: AND l.condition_rule = 'E';
1310:
1311: BEGIN
1312:
1313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1314: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1315: G_MODULE_PREFIX || l_procedure_name,
1316: 'Begin Procedure. ');
1317: END IF;

Line 1314: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1310:
1311: BEGIN
1312:
1313: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1314: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1315: G_MODULE_PREFIX || l_procedure_name,
1316: 'Begin Procedure. ');
1317: END IF;
1318:

Line 1319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1315: G_MODULE_PREFIX || l_procedure_name,
1316: 'Begin Procedure. ');
1317: END IF;
1318:
1319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1320: log(FND_LOG.LEVEL_PROCEDURE,
1321: G_MODULE_PREFIX || l_procedure_name,
1322: 'Begin Get_AR_TrxType_Cond......');
1323: END IF;

Line 1320: log(FND_LOG.LEVEL_PROCEDURE,

1316: 'Begin Procedure. ');
1317: END IF;
1318:
1319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1320: log(FND_LOG.LEVEL_PROCEDURE,
1321: G_MODULE_PREFIX || l_procedure_name,
1322: 'Begin Get_AR_TrxType_Cond......');
1323: END IF;
1324:

Line 1364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1360: END IF;
1361:
1362: CLOSE trx_type_cond_i;
1363:
1364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1365: log(FND_LOG.LEVEL_PROCEDURE,
1366: G_MODULE_PREFIX || l_procedure_name,
1367: 'End trx_type_cond_i......');
1368: END IF;

Line 1365: log(FND_LOG.LEVEL_PROCEDURE,

1361:
1362: CLOSE trx_type_cond_i;
1363:
1364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1365: log(FND_LOG.LEVEL_PROCEDURE,
1366: G_MODULE_PREFIX || l_procedure_name,
1367: 'End trx_type_cond_i......');
1368: END IF;
1369:

Line 1385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1381: l_parameter_suffix := l_parameter_suffix + 1;
1382: END LOOP;
1383: CLOSE trx_type_cond_e;
1384:
1385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1387: G_MODULE_PREFIX || l_procedure_name,
1388: 'END procedure. ');
1389: END IF;

Line 1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1382: END LOOP;
1383: CLOSE trx_type_cond_e;
1384:
1385: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1387: G_MODULE_PREFIX || l_procedure_name,
1388: 'END procedure. ');
1389: END IF;
1390:

Line 1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1389: END IF;
1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1395: G_MODULE_PREFIX || l_procedure_name ||
1396: '. OTHER_EXCEPTION ',
1397: 'Unknown error' || SQLCODE || SQLERRM);

Line 1394: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1394: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1395: G_MODULE_PREFIX || l_procedure_name ||
1396: '. OTHER_EXCEPTION ',
1397: 'Unknown error' || SQLCODE || SQLERRM);
1398:

Line 1454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1450: AND l.condition_rule = 'E';
1451:
1452: BEGIN
1453:
1454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1455: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1456: G_MODULE_PREFIX || l_procedure_name,
1457: 'Begin Procedure. ');
1458: END IF;

Line 1455: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1451:
1452: BEGIN
1453:
1454: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1455: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1456: G_MODULE_PREFIX || l_procedure_name,
1457: 'Begin Procedure. ');
1458: END IF;
1459:

Line 1460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1456: G_MODULE_PREFIX || l_procedure_name,
1457: 'Begin Procedure. ');
1458: END IF;
1459:
1460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: log(FND_LOG.LEVEL_PROCEDURE,
1462: G_MODULE_PREFIX || l_procedure_name,
1463: 'begin get_ar_flex......');
1464: END IF;

Line 1461: log(FND_LOG.LEVEL_PROCEDURE,

1457: 'Begin Procedure. ');
1458: END IF;
1459:
1460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: log(FND_LOG.LEVEL_PROCEDURE,
1462: G_MODULE_PREFIX || l_procedure_name,
1463: 'begin get_ar_flex......');
1464: END IF;
1465:

Line 1537: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1533: END LOOP;
1534:
1535: CLOSE flex_cond_e;
1536:
1537: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1538: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1539: G_MODULE_PREFIX || l_procedure_name,
1540: 'END procedure. ');
1541: END IF;

Line 1538: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1534:
1535: CLOSE flex_cond_e;
1536:
1537: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1538: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1539: G_MODULE_PREFIX || l_procedure_name,
1540: 'END procedure. ');
1541: END IF;
1542:

Line 1543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1539: G_MODULE_PREFIX || l_procedure_name,
1540: 'END procedure. ');
1541: END IF;
1542:
1543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: log(FND_LOG.LEVEL_PROCEDURE,
1545: G_MODULE_PREFIX || l_procedure_name,
1546: 'End get_ar_flex......');
1547: END IF;

Line 1544: log(FND_LOG.LEVEL_PROCEDURE,

1540: 'END procedure. ');
1541: END IF;
1542:
1543: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: log(FND_LOG.LEVEL_PROCEDURE,
1545: G_MODULE_PREFIX || l_procedure_name,
1546: 'End get_ar_flex......');
1547: END IF;
1548:

Line 1551: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1547: END IF;
1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1553: G_MODULE_PREFIX || l_procedure_name ||
1554: '. OTHER_EXCEPTION ',
1555: 'Unknown error');

Line 1552: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1548:
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1553: G_MODULE_PREFIX || l_procedure_name ||
1554: '. OTHER_EXCEPTION ',
1555: 'Unknown error');
1556:

Line 1596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1592: l_parameter_suffix NUMBER;
1593:
1594: BEGIN
1595:
1596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1597: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1598: G_MODULE_PREFIX || l_procedure_name,
1599: 'Begin Procedure. ');
1600: END IF;

Line 1597: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1593:
1594: BEGIN
1595:
1596: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1597: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1598: G_MODULE_PREFIX || l_procedure_name,
1599: 'Begin Procedure. ');
1600: END IF;
1601:

Line 1602: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1598: G_MODULE_PREFIX || l_procedure_name,
1599: 'Begin Procedure. ');
1600: END IF;
1601:
1602: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1603: log(FND_LOG.LEVEL_PROCEDURE,
1604: G_MODULE_PREFIX || l_procedure_name,
1605: 'begin get_param_cond......');
1606: END IF;

Line 1603: log(FND_LOG.LEVEL_PROCEDURE,

1599: 'Begin Procedure. ');
1600: END IF;
1601:
1602: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1603: log(FND_LOG.LEVEL_PROCEDURE,
1604: G_MODULE_PREFIX || l_procedure_name,
1605: 'begin get_param_cond......');
1606: END IF;
1607:

Line 1748: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1744: (l_parameter_suffix + 2);
1745:
1746: END IF;
1747:
1748: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1749: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1750: G_MODULE_PREFIX || l_procedure_name,
1751: 'END procedure. ');
1752: END IF;

Line 1749: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1745:
1746: END IF;
1747:
1748: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1749: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1750: G_MODULE_PREFIX || l_procedure_name,
1751: 'END procedure. ');
1752: END IF;
1753:

Line 1754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1750: G_MODULE_PREFIX || l_procedure_name,
1751: 'END procedure. ');
1752: END IF;
1753:
1754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1755: log(FND_LOG.LEVEL_PROCEDURE,
1756: G_MODULE_PREFIX || l_procedure_name,
1757: 'End get_ar_flex......');
1758: END IF;

Line 1755: log(FND_LOG.LEVEL_PROCEDURE,

1751: 'END procedure. ');
1752: END IF;
1753:
1754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1755: log(FND_LOG.LEVEL_PROCEDURE,
1756: G_MODULE_PREFIX || l_procedure_name,
1757: 'End get_ar_flex......');
1758: END IF;
1759:

Line 1762: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1758: END IF;
1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1763:
1764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1765: G_MODULE_PREFIX || l_procedure_name ||
1766: '.OTHER_EXCEPTION.',

Line 1764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1763:
1764: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1765: G_MODULE_PREFIX || l_procedure_name ||
1766: '.OTHER_EXCEPTION.',
1767: '.Unknown .error.' || SQLCODE || SQLERRM);
1768:

Line 1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1815: -- then the rule is transfer AR trx which currency code is specific.
1816: l_gta_currency_option ar_gta_rule_headers_all.currency_option%TYPE;
1817: BEGIN
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1821: G_MODULE_PREFIX || l_procedure_name,
1822: 'Begin Procedure. ');
1823: END IF;

Line 1820: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1816: l_gta_currency_option ar_gta_rule_headers_all.currency_option%TYPE;
1817: BEGIN
1818:
1819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1820: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1821: G_MODULE_PREFIX || l_procedure_name,
1822: 'Begin Procedure. ');
1823: END IF;
1824:

Line 1825: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1821: G_MODULE_PREFIX || l_procedure_name,
1822: 'Begin Procedure. ');
1823: END IF;
1824:
1825: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1826: log(FND_LOG.LEVEL_PROCEDURE,
1827: G_MODULE_PREFIX || l_procedure_name,
1828: 'Begin Get_AR_Currency_Cond......');
1829: log(FND_LOG.LEVEL_PROCEDURE,

Line 1826: log(FND_LOG.LEVEL_PROCEDURE,

1822: 'Begin Procedure. ');
1823: END IF;
1824:
1825: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1826: log(FND_LOG.LEVEL_PROCEDURE,
1827: G_MODULE_PREFIX || l_procedure_name,
1828: 'Begin Get_AR_Currency_Cond......');
1829: log(FND_LOG.LEVEL_PROCEDURE,
1830: G_MODULE_PREFIX || l_procedure_name,

Line 1829: log(FND_LOG.LEVEL_PROCEDURE,

1825: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1826: log(FND_LOG.LEVEL_PROCEDURE,
1827: G_MODULE_PREFIX || l_procedure_name,
1828: 'Begin Get_AR_Currency_Cond......');
1829: log(FND_LOG.LEVEL_PROCEDURE,
1830: G_MODULE_PREFIX || l_procedure_name,
1831: 'p_org_id:' || p_org_id || ' ' || 'p_transfer_id:' ||
1832: p_transfer_id);
1833: END IF;

Line 1857: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1853: l_error_string ||
1854: '
1855: '); --Modified by Yao Zhang for bug 7667709
1856:
1857: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1859: G_MODULE_PREFIX || l_procedure_name,
1860: 'no data found when select sales_list_flag.');
1861: END IF;

Line 1858: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

1854: '
1855: '); --Modified by Yao Zhang for bug 7667709
1856:
1857: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1859: G_MODULE_PREFIX || l_procedure_name,
1860: 'no data found when select sales_list_flag.');
1861: END IF;
1862:

Line 1889: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1885: l_error_string ||
1886: '
1887: '); --Modified By Yao Zhang for bug 7667709
1888:
1889: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1890: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1891: G_MODULE_PREFIX || l_procedure_name,
1892: 'no data found when select sales_list_flag.');
1893: END IF;

Line 1890: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

1886: '
1887: '); --Modified By Yao Zhang for bug 7667709
1888:
1889: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1890: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
1891: G_MODULE_PREFIX || l_procedure_name,
1892: 'no data found when select sales_list_flag.');
1893: END IF;
1894:

Line 1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1912: x_currency_code := l_specific_currency_code;
1913: END IF;
1914: END IF;
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1918: G_MODULE_PREFIX || l_procedure_name,
1919: 'END procedure. ');
1920: END IF;

Line 1917: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

1913: END IF;
1914: END IF;
1915:
1916: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1917: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
1918: G_MODULE_PREFIX || l_procedure_name,
1919: 'END procedure. ');
1920: END IF;
1921:

Line 1922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1918: G_MODULE_PREFIX || l_procedure_name,
1919: 'END procedure. ');
1920: END IF;
1921:
1922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: log(FND_LOG.LEVEL_PROCEDURE,
1924: G_MODULE_PREFIX || l_procedure_name,
1925: 'End Get_AR_Currency_Cond......');
1926: END IF;

Line 1923: log(FND_LOG.LEVEL_PROCEDURE,

1919: 'END procedure. ');
1920: END IF;
1921:
1922: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1923: log(FND_LOG.LEVEL_PROCEDURE,
1924: G_MODULE_PREFIX || l_procedure_name,
1925: 'End Get_AR_Currency_Cond......');
1926: END IF;
1927:

Line 1930: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1926: END IF;
1927:
1928: EXCEPTION
1929: WHEN OTHERS THEN
1930: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1932: G_MODULE_PREFIX || l_procedure_name ||
1933: '. OTHER_EXCEPTION ',
1934: 'Unknown error' || SQLCODE || SQLERRM);

Line 1931: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

1927:
1928: EXCEPTION
1929: WHEN OTHERS THEN
1930: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
1932: G_MODULE_PREFIX || l_procedure_name ||
1933: '. OTHER_EXCEPTION ',
1934: 'Unknown error' || SQLCODE || SQLERRM);
1935:

Line 2212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2208: AND opa.list_line_type_code = 'DIS';
2209:
2210: BEGIN
2211:
2212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2213: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
2214: G_MODULE_PREFIX || l_procedure_name,
2215: 'Begin Procedure. ');
2216: END IF;

Line 2213: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

2209:
2210: BEGIN
2211:
2212: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2213: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
2214: G_MODULE_PREFIX || l_procedure_name,
2215: 'Begin Procedure. ');
2216: END IF;
2217:

Line 2222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2218: -- init x_GTA_TRX_TBL
2219: x_GTA_TRX_TBL := AR_GTA_TRX_UTIL.TRX_TBL_TYPE();
2220:
2221: l_log_str := p_query_sql;
2222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2224: G_MODULE_PREFIX || l_procedure_name || '.DYNAMIC SQL ',
2225: l_log_str);
2226: END IF;

Line 2223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2219: x_GTA_TRX_TBL := AR_GTA_TRX_UTIL.TRX_TBL_TYPE();
2220:
2221: l_log_str := p_query_sql;
2222: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2223: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2224: G_MODULE_PREFIX || l_procedure_name || '.DYNAMIC SQL ',
2225: l_log_str);
2226: END IF;
2227:

Line 2228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2224: G_MODULE_PREFIX || l_procedure_name || '.DYNAMIC SQL ',
2225: l_log_str);
2226: END IF;
2227:
2228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2229: log(FND_LOG.LEVEL_PROCEDURE,
2230: G_MODULE_PREFIX || l_procedure_name,
2231: 'Begin Retrieve_AR_TRXs......');
2232: END IF;

Line 2229: log(FND_LOG.LEVEL_PROCEDURE,

2225: l_log_str);
2226: END IF;
2227:
2228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2229: log(FND_LOG.LEVEL_PROCEDURE,
2230: G_MODULE_PREFIX || l_procedure_name,
2231: 'Begin Retrieve_AR_TRXs......');
2232: END IF;
2233:

Line 2284: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2280: l_error_string ||
2281: '
2282: '); --Modified By Yao Zhang for bug 7667709
2283:
2284: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2285: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
2286: G_MODULE_PREFIX || l_procedure_name,
2287: l_error_string);
2288: END IF;

Line 2285: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

2281: '
2282: '); --Modified By Yao Zhang for bug 7667709
2283:
2284: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2285: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
2286: G_MODULE_PREFIX || l_procedure_name,
2287: l_error_string);
2288: END IF;
2289:

Line 2316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2312: l_error_string ||
2313: '
2314: '); --Modified By Yao Zhang for bug 7667709
2315:
2316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2317: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
2318: G_MODULE_PREFIX || l_procedure_name,
2319: 'no data found when select sales_list_flag.');
2320: END IF;

Line 2317: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

2313: '
2314: '); --Modified By Yao Zhang for bug 7667709
2315:
2316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2317: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
2318: G_MODULE_PREFIX || l_procedure_name,
2319: 'no data found when select sales_list_flag.');
2320: END IF;
2321: RAISE;

Line 2373: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2369:
2370: --EXECUTE!
2371: l_sql_exec_ret := dbms_sql.EXECUTE(l_cursor);
2372:
2373: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2374: log(FND_LOG.LEVEL_PROCEDURE,
2375: G_MODULE_PREFIX || l_procedure_name,
2376: 'Begin cursor loop......');
2377: END IF;

Line 2374: log(FND_LOG.LEVEL_PROCEDURE,

2370: --EXECUTE!
2371: l_sql_exec_ret := dbms_sql.EXECUTE(l_cursor);
2372:
2373: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2374: log(FND_LOG.LEVEL_PROCEDURE,
2375: G_MODULE_PREFIX || l_procedure_name,
2376: 'Begin cursor loop......');
2377: END IF;
2378:

Line 2406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2402:
2403: -- get customer_trx_id of the AR_trx_header
2404: dbms_sql.column_value(l_cursor, 1, l_customer_trx_id);
2405:
2406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2407: log(FND_LOG.LEVEL_PROCEDURE,
2408: G_MODULE_PREFIX || l_procedure_name,
2409: '****************************************');
2410: log(FND_LOG.LEVEL_PROCEDURE,

Line 2407: log(FND_LOG.LEVEL_PROCEDURE,

2403: -- get customer_trx_id of the AR_trx_header
2404: dbms_sql.column_value(l_cursor, 1, l_customer_trx_id);
2405:
2406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2407: log(FND_LOG.LEVEL_PROCEDURE,
2408: G_MODULE_PREFIX || l_procedure_name,
2409: '****************************************');
2410: log(FND_LOG.LEVEL_PROCEDURE,
2411: G_MODULE_PREFIX || l_procedure_name,

Line 2410: log(FND_LOG.LEVEL_PROCEDURE,

2406: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2407: log(FND_LOG.LEVEL_PROCEDURE,
2408: G_MODULE_PREFIX || l_procedure_name,
2409: '****************************************');
2410: log(FND_LOG.LEVEL_PROCEDURE,
2411: G_MODULE_PREFIX || l_procedure_name,
2412: 'l_customer_trx_id : ' || l_customer_trx_id);
2413: log(FND_LOG.LEVEL_PROCEDURE,
2414: G_MODULE_PREFIX || l_procedure_name,

Line 2413: log(FND_LOG.LEVEL_PROCEDURE,

2409: '****************************************');
2410: log(FND_LOG.LEVEL_PROCEDURE,
2411: G_MODULE_PREFIX || l_procedure_name,
2412: 'l_customer_trx_id : ' || l_customer_trx_id);
2413: log(FND_LOG.LEVEL_PROCEDURE,
2414: G_MODULE_PREFIX || l_procedure_name,
2415: '****************************************');
2416: END IF;
2417:

Line 2521: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2517: AND h.customer_trx_id = l_customer_trx_id;
2518:
2519: EXCEPTION
2520: WHEN no_data_found THEN
2521: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2523: G_MODULE_PREFIX || l_procedure_name,
2524: 'no date found when select header info');
2525: END IF;

Line 2522: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

2518:
2519: EXCEPTION
2520: WHEN no_data_found THEN
2521: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2523: G_MODULE_PREFIX || l_procedure_name,
2524: 'no date found when select header info');
2525: END IF;
2526: RAISE;

Line 2565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2561: AND RAA_BILL_LOC.COUNTRY = FT_BILL.TERRITORY_CODE(+)
2562: AND h.customer_trx_id = l_customer_trx_id;
2563: EXCEPTION
2564: WHEN no_data_found THEN
2565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2566: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2567: G_MODULE_PREFIX || l_procedure_name,
2568: 'no date found when select l_raa_bill_to_concat_address');
2569: END IF;

Line 2566: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

2562: AND h.customer_trx_id = l_customer_trx_id;
2563: EXCEPTION
2564: WHEN no_data_found THEN
2565: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2566: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2567: G_MODULE_PREFIX || l_procedure_name,
2568: 'no date found when select l_raa_bill_to_concat_address');
2569: END IF;
2570: --modified by subba for R12.1

Line 2624: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2620: AND h.customer_trx_id = l_customer_trx_id;
2621:
2622: EXCEPTION
2623: WHEN no_data_found THEN
2624: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2625: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2626: G_MODULE_PREFIX || l_procedure_name,
2627: 'no date found when select phone number');
2628: END IF;

Line 2625: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

2621:
2622: EXCEPTION
2623: WHEN no_data_found THEN
2624: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2625: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2626: G_MODULE_PREFIX || l_procedure_name,
2627: 'no date found when select phone number');
2628: END IF;
2629:

Line 2659: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2655: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id;
2656:
2657: EXCEPTION
2658: WHEN no_data_found THEN
2659: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2660: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2661: G_MODULE_PREFIX || l_procedure_name,
2662: 'no data found when select rac information');
2663: END IF;

Line 2660: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

2656:
2657: EXCEPTION
2658: WHEN no_data_found THEN
2659: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2660: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
2661: G_MODULE_PREFIX || l_procedure_name,
2662: 'no data found when select rac information');
2663: END IF;
2664: RAISE;

Line 2677: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2673:
2674: -- Modified by brian for bug 7591365
2675: /*IF l_ctt_class = 'CM' THEN
2676:
2677: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2678: THEN
2679: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2680: || l_procedure_name,
2681: '****************************************');

Line 2679: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX

2675: /*IF l_ctt_class = 'CM' THEN
2676:
2677: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2678: THEN
2679: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2680: || l_procedure_name,
2681: '****************************************');
2682: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2683: || l_procedure_name,

Line 2682: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX

2678: THEN
2679: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2680: || l_procedure_name,
2681: '****************************************');
2682: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2683: || l_procedure_name,
2684: 'is CM');
2685: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2686: || l_procedure_name,

Line 2685: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX

2681: '****************************************');
2682: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2683: || l_procedure_name,
2684: 'is CM');
2685: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX
2686: || l_procedure_name,
2687: '****************************************');
2688: END IF;
2689: --checking whether CM is associated with AR invoice or not

Line 2880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2876: WHEN no_data_found THEN
2877: l_discount_on_invoice := 'N'; --Modified for bug10257355
2878: --Yao add END for bug10243486
2879: WHEN OTHERS THEN
2880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2882: G_MODULE_PREFIX || l_procedure_name ||
2883: '. Exception from OM: OE_DISCOUNT_DETAILS_ON_INVOICE',
2884: 'Unknown error' || SQLCODE || SQLERRM);

Line 2881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2877: l_discount_on_invoice := 'N'; --Modified for bug10257355
2878: --Yao add END for bug10243486
2879: WHEN OTHERS THEN
2880: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2881: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2882: G_MODULE_PREFIX || l_procedure_name ||
2883: '. Exception from OM: OE_DISCOUNT_DETAILS_ON_INVOICE',
2884: 'Unknown error' || SQLCODE || SQLERRM);
2885: END IF;

Line 2972: IF (FND_LOG.LEVEL_UNEXPECTED >=

2968: EXCEPTION
2969: WHEN no_data_found THEN
2970: NULL;
2971: WHEN OTHERS THEN
2972: IF (FND_LOG.LEVEL_UNEXPECTED >=
2973: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2975: G_MODULE_PREFIX || l_procedure_name ||
2976: '. OTHER_EXCEPTION ',

Line 2973: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2969: WHEN no_data_found THEN
2970: NULL;
2971: WHEN OTHERS THEN
2972: IF (FND_LOG.LEVEL_UNEXPECTED >=
2973: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2975: G_MODULE_PREFIX || l_procedure_name ||
2976: '. OTHER_EXCEPTION ',
2977: 'Unknown error' || SQLCODE || SQLERRM);

Line 2974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

2970: NULL;
2971: WHEN OTHERS THEN
2972: IF (FND_LOG.LEVEL_UNEXPECTED >=
2973: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
2975: G_MODULE_PREFIX || l_procedure_name ||
2976: '. OTHER_EXCEPTION ',
2977: 'Unknown error' || SQLCODE || SQLERRM);
2978: END IF;

Line 3007: IF (FND_LOG.LEVEL_PROCEDURE >=

3003: l_discount_tax_rate * l_tax_amount) > 0.01 THEN
3004: fnd_message.SET_NAME('AR', 'AR_GTA_DIF_DIS_RATE');
3005: l_error_string := fnd_message.GET();
3006: -- begin log
3007: IF (FND_LOG.LEVEL_PROCEDURE >=
3008: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3009: log(FND_LOG.LEVEL_PROCEDURE,
3010: G_MODULE_PREFIX || l_procedure_name,
3011: 'AR_GTA_INCONSISTANT_DISCOUNT_RATE');

Line 3008: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3004: fnd_message.SET_NAME('AR', 'AR_GTA_DIF_DIS_RATE');
3005: l_error_string := fnd_message.GET();
3006: -- begin log
3007: IF (FND_LOG.LEVEL_PROCEDURE >=
3008: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3009: log(FND_LOG.LEVEL_PROCEDURE,
3010: G_MODULE_PREFIX || l_procedure_name,
3011: 'AR_GTA_INCONSISTANT_DISCOUNT_RATE');
3012: END IF; /*(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/

Line 3009: log(FND_LOG.LEVEL_PROCEDURE,

3005: l_error_string := fnd_message.GET();
3006: -- begin log
3007: IF (FND_LOG.LEVEL_PROCEDURE >=
3008: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3009: log(FND_LOG.LEVEL_PROCEDURE,
3010: G_MODULE_PREFIX || l_procedure_name,
3011: 'AR_GTA_INCONSISTANT_DISCOUNT_RATE');
3012: END IF; /*(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3013: CLOSE c_ra_lines;

Line 3012: END IF; /(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

3008: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3009: log(FND_LOG.LEVEL_PROCEDURE,
3010: G_MODULE_PREFIX || l_procedure_name,
3011: 'AR_GTA_INCONSISTANT_DISCOUNT_RATE');
3012: END IF; /*(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3013: CLOSE c_ra_lines;
3014: RAISE l_normal_exception;
3015: END IF; /*l_discount_rate<>l_discount_tax_rate*/
3016: END IF; /*(l_interface_line_context='ORDER ENTRY' and l_price_adjustment_id=0)*/

Line 3060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3056: --fnd_message.set_token('NUM', l_customer_trx_line_id);
3057: l_error_string := fnd_message.GET();
3058:
3059: -- begin log
3060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3061: THEN
3062: log(FND_LOG.LEVEL_PROCEDURE,
3063: G_MODULE_PREFIX || l_procedure_name,
3064: 'AR_GTA_MISSING_FIELD');

Line 3062: log(FND_LOG.LEVEL_PROCEDURE,

3058:
3059: -- begin log
3060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3061: THEN
3062: log(FND_LOG.LEVEL_PROCEDURE,
3063: G_MODULE_PREFIX || l_procedure_name,
3064: 'AR_GTA_MISSING_FIELD');
3065: END IF;
3066: -- end log

Line 3068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3064: 'AR_GTA_MISSING_FIELD');
3065: END IF;
3066: -- end log
3067:
3068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3069: THEN
3070: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3071: G_MODULE_PREFIX || l_procedure_name,
3072: l_error_string);

Line 3070: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3066: -- end log
3067:
3068: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3069: THEN
3070: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3071: G_MODULE_PREFIX || l_procedure_name,
3072: l_error_string);
3073: END IF;
3074: CLOSE c_ra_lines;

Line 3097: IF (FND_LOG.LEVEL_PROCEDURE >=

3093:
3094: BEGIN
3095:
3096: -- begin log
3097: IF (FND_LOG.LEVEL_PROCEDURE >=
3098: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: log(FND_LOG.LEVEL_PROCEDURE,
3100: G_MODULE_PREFIX || l_procedure_name,
3101: '************************************');

Line 3098: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3094: BEGIN
3095:
3096: -- begin log
3097: IF (FND_LOG.LEVEL_PROCEDURE >=
3098: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: log(FND_LOG.LEVEL_PROCEDURE,
3100: G_MODULE_PREFIX || l_procedure_name,
3101: '************************************');
3102: log(FND_LOG.LEVEL_PROCEDURE,

Line 3099: log(FND_LOG.LEVEL_PROCEDURE,

3095:
3096: -- begin log
3097: IF (FND_LOG.LEVEL_PROCEDURE >=
3098: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: log(FND_LOG.LEVEL_PROCEDURE,
3100: G_MODULE_PREFIX || l_procedure_name,
3101: '************************************');
3102: log(FND_LOG.LEVEL_PROCEDURE,
3103: G_MODULE_PREFIX || l_procedure_name,

Line 3102: log(FND_LOG.LEVEL_PROCEDURE,

3098: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3099: log(FND_LOG.LEVEL_PROCEDURE,
3100: G_MODULE_PREFIX || l_procedure_name,
3101: '************************************');
3102: log(FND_LOG.LEVEL_PROCEDURE,
3103: G_MODULE_PREFIX || l_procedure_name,
3104: 'l_customer_trx_line_id:' || l_customer_trx_line_id); --exception 05
3105: log(FND_LOG.LEVEL_PROCEDURE,
3106: G_MODULE_PREFIX || l_procedure_name,

Line 3105: log(FND_LOG.LEVEL_PROCEDURE,

3101: '************************************');
3102: log(FND_LOG.LEVEL_PROCEDURE,
3103: G_MODULE_PREFIX || l_procedure_name,
3104: 'l_customer_trx_line_id:' || l_customer_trx_line_id); --exception 05
3105: log(FND_LOG.LEVEL_PROCEDURE,
3106: G_MODULE_PREFIX || l_procedure_name,
3107: '************************************');
3108: END IF;
3109: -- end log

Line 3132: IF (FND_LOG.LEVEL_PROCEDURE >=

3128: x_status => l_status,
3129: x_error_buffer => l_proce_error_buffer);
3130:
3131: -- begin log
3132: IF (FND_LOG.LEVEL_PROCEDURE >=
3133: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3134: log(FND_LOG.LEVEL_PROCEDURE,
3135: G_MODULE_PREFIX || l_procedure_name,
3136: 'ebtax p_org_id:' || p_org_id);

Line 3133: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3129: x_error_buffer => l_proce_error_buffer);
3130:
3131: -- begin log
3132: IF (FND_LOG.LEVEL_PROCEDURE >=
3133: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3134: log(FND_LOG.LEVEL_PROCEDURE,
3135: G_MODULE_PREFIX || l_procedure_name,
3136: 'ebtax p_org_id:' || p_org_id);
3137: log(FND_LOG.LEVEL_PROCEDURE,

Line 3134: log(FND_LOG.LEVEL_PROCEDURE,

3130:
3131: -- begin log
3132: IF (FND_LOG.LEVEL_PROCEDURE >=
3133: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3134: log(FND_LOG.LEVEL_PROCEDURE,
3135: G_MODULE_PREFIX || l_procedure_name,
3136: 'ebtax p_org_id:' || p_org_id);
3137: log(FND_LOG.LEVEL_PROCEDURE,
3138: G_MODULE_PREFIX || l_procedure_name,

Line 3137: log(FND_LOG.LEVEL_PROCEDURE,

3133: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3134: log(FND_LOG.LEVEL_PROCEDURE,
3135: G_MODULE_PREFIX || l_procedure_name,
3136: 'ebtax p_org_id:' || p_org_id);
3137: log(FND_LOG.LEVEL_PROCEDURE,
3138: G_MODULE_PREFIX || l_procedure_name,
3139: 'ebtax l_customer_trx_id:' || l_customer_trx_id);
3140: log(FND_LOG.LEVEL_PROCEDURE,
3141: G_MODULE_PREFIX || l_procedure_name,

Line 3140: log(FND_LOG.LEVEL_PROCEDURE,

3136: 'ebtax p_org_id:' || p_org_id);
3137: log(FND_LOG.LEVEL_PROCEDURE,
3138: G_MODULE_PREFIX || l_procedure_name,
3139: 'ebtax l_customer_trx_id:' || l_customer_trx_id);
3140: log(FND_LOG.LEVEL_PROCEDURE,
3141: G_MODULE_PREFIX || l_procedure_name,
3142: 'ebtax l_customer_trx_line_id:' ||
3143: l_customer_trx_line_id);
3144: log(FND_LOG.LEVEL_PROCEDURE,

Line 3144: log(FND_LOG.LEVEL_PROCEDURE,

3140: log(FND_LOG.LEVEL_PROCEDURE,
3141: G_MODULE_PREFIX || l_procedure_name,
3142: 'ebtax l_customer_trx_line_id:' ||
3143: l_customer_trx_line_id);
3144: log(FND_LOG.LEVEL_PROCEDURE,
3145: G_MODULE_PREFIX || l_procedure_name,
3146: 'ebtax l_vat_tax_type:' || l_vat_tax_type);
3147: log(FND_LOG.LEVEL_PROCEDURE,
3148: G_MODULE_PREFIX || l_procedure_name,

Line 3147: log(FND_LOG.LEVEL_PROCEDURE,

3143: l_customer_trx_line_id);
3144: log(FND_LOG.LEVEL_PROCEDURE,
3145: G_MODULE_PREFIX || l_procedure_name,
3146: 'ebtax l_vat_tax_type:' || l_vat_tax_type);
3147: log(FND_LOG.LEVEL_PROCEDURE,
3148: G_MODULE_PREFIX || l_procedure_name,
3149: 'ebtax l_tax_amount_func_curr:' ||
3150: l_tax_amount_func_curr);
3151: log(FND_LOG.LEVEL_PROCEDURE,

Line 3151: log(FND_LOG.LEVEL_PROCEDURE,

3147: log(FND_LOG.LEVEL_PROCEDURE,
3148: G_MODULE_PREFIX || l_procedure_name,
3149: 'ebtax l_tax_amount_func_curr:' ||
3150: l_tax_amount_func_curr);
3151: log(FND_LOG.LEVEL_PROCEDURE,
3152: G_MODULE_PREFIX || l_procedure_name,
3153: 'ebtax l_taxable_amount_func_curr:' ||
3154: l_taxable_amount_func_curr);
3155: log(FND_LOG.LEVEL_PROCEDURE,

Line 3155: log(FND_LOG.LEVEL_PROCEDURE,

3151: log(FND_LOG.LEVEL_PROCEDURE,
3152: G_MODULE_PREFIX || l_procedure_name,
3153: 'ebtax l_taxable_amount_func_curr:' ||
3154: l_taxable_amount_func_curr);
3155: log(FND_LOG.LEVEL_PROCEDURE,
3156: G_MODULE_PREFIX || l_procedure_name,
3157: 'ebtax l_line_quantity:' || l_line_quantity);
3158: log(FND_LOG.LEVEL_PROCEDURE,
3159: G_MODULE_PREFIX || l_procedure_name,

Line 3158: log(FND_LOG.LEVEL_PROCEDURE,

3154: l_taxable_amount_func_curr);
3155: log(FND_LOG.LEVEL_PROCEDURE,
3156: G_MODULE_PREFIX || l_procedure_name,
3157: 'ebtax l_line_quantity:' || l_line_quantity);
3158: log(FND_LOG.LEVEL_PROCEDURE,
3159: G_MODULE_PREFIX || l_procedure_name,
3160: 'ebtax l_tax_rate:' || l_tax_rate);
3161: log(FND_LOG.LEVEL_PROCEDURE,
3162: G_MODULE_PREFIX || l_procedure_name,

Line 3161: log(FND_LOG.LEVEL_PROCEDURE,

3157: 'ebtax l_line_quantity:' || l_line_quantity);
3158: log(FND_LOG.LEVEL_PROCEDURE,
3159: G_MODULE_PREFIX || l_procedure_name,
3160: 'ebtax l_tax_rate:' || l_tax_rate);
3161: log(FND_LOG.LEVEL_PROCEDURE,
3162: G_MODULE_PREFIX || l_procedure_name,
3163: 'ebtax l_unit_price:' || l_unit_price);
3164: log(FND_LOG.LEVEL_PROCEDURE,
3165: G_MODULE_PREFIX || l_procedure_name,

Line 3164: log(FND_LOG.LEVEL_PROCEDURE,

3160: 'ebtax l_tax_rate:' || l_tax_rate);
3161: log(FND_LOG.LEVEL_PROCEDURE,
3162: G_MODULE_PREFIX || l_procedure_name,
3163: 'ebtax l_unit_price:' || l_unit_price);
3164: log(FND_LOG.LEVEL_PROCEDURE,
3165: G_MODULE_PREFIX || l_procedure_name,
3166: 'ebtax l_fp_registration_number:' ||
3167: l_fp_registration_number);
3168: log(FND_LOG.LEVEL_PROCEDURE,

Line 3168: log(FND_LOG.LEVEL_PROCEDURE,

3164: log(FND_LOG.LEVEL_PROCEDURE,
3165: G_MODULE_PREFIX || l_procedure_name,
3166: 'ebtax l_fp_registration_number:' ||
3167: l_fp_registration_number);
3168: log(FND_LOG.LEVEL_PROCEDURE,
3169: G_MODULE_PREFIX || l_procedure_name,
3170: 'ebtax l_tp_registration_number:' ||
3171: l_tp_registration_number);
3172: log(FND_LOG.LEVEL_PROCEDURE,

Line 3172: log(FND_LOG.LEVEL_PROCEDURE,

3168: log(FND_LOG.LEVEL_PROCEDURE,
3169: G_MODULE_PREFIX || l_procedure_name,
3170: 'ebtax l_tp_registration_number:' ||
3171: l_tp_registration_number);
3172: log(FND_LOG.LEVEL_PROCEDURE,
3173: G_MODULE_PREFIX || l_procedure_name,
3174: 'ebtax l_status:' || l_status);
3175: log(FND_LOG.LEVEL_PROCEDURE,
3176: G_MODULE_PREFIX || l_procedure_name,

Line 3175: log(FND_LOG.LEVEL_PROCEDURE,

3171: l_tp_registration_number);
3172: log(FND_LOG.LEVEL_PROCEDURE,
3173: G_MODULE_PREFIX || l_procedure_name,
3174: 'ebtax l_status:' || l_status);
3175: log(FND_LOG.LEVEL_PROCEDURE,
3176: G_MODULE_PREFIX || l_procedure_name,
3177: 'ebtax l_proce_error_buffer:' || l_proce_error_buffer);
3178: END IF;
3179: -- end log

Line 3213: IF (FND_LOG.LEVEL_EXCEPTION >=

3209: l_cm_warn2 := FALSE;
3210: l_pre_cus_trxid := null;
3211: l_ar_invoice_count := 0;
3212: l_gt_invoice_count := 0;
3213: IF (FND_LOG.LEVEL_EXCEPTION >=
3214: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3215: log(FND_LOG.LEVEL_PROCEDURE,
3216: G_MODULE_PREFIX || l_procedure_name,
3217: '****************************************');

Line 3214: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3210: l_pre_cus_trxid := null;
3211: l_ar_invoice_count := 0;
3212: l_gt_invoice_count := 0;
3213: IF (FND_LOG.LEVEL_EXCEPTION >=
3214: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3215: log(FND_LOG.LEVEL_PROCEDURE,
3216: G_MODULE_PREFIX || l_procedure_name,
3217: '****************************************');
3218: log(FND_LOG.LEVEL_PROCEDURE,

Line 3215: log(FND_LOG.LEVEL_PROCEDURE,

3211: l_ar_invoice_count := 0;
3212: l_gt_invoice_count := 0;
3213: IF (FND_LOG.LEVEL_EXCEPTION >=
3214: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3215: log(FND_LOG.LEVEL_PROCEDURE,
3216: G_MODULE_PREFIX || l_procedure_name,
3217: '****************************************');
3218: log(FND_LOG.LEVEL_PROCEDURE,
3219: G_MODULE_PREFIX || l_procedure_name,

Line 3218: log(FND_LOG.LEVEL_PROCEDURE,

3214: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3215: log(FND_LOG.LEVEL_PROCEDURE,
3216: G_MODULE_PREFIX || l_procedure_name,
3217: '****************************************');
3218: log(FND_LOG.LEVEL_PROCEDURE,
3219: G_MODULE_PREFIX || l_procedure_name,
3220: 'is CM');
3221: log(FND_LOG.LEVEL_PROCEDURE,
3222: G_MODULE_PREFIX || l_procedure_name,

Line 3221: log(FND_LOG.LEVEL_PROCEDURE,

3217: '****************************************');
3218: log(FND_LOG.LEVEL_PROCEDURE,
3219: G_MODULE_PREFIX || l_procedure_name,
3220: 'is CM');
3221: log(FND_LOG.LEVEL_PROCEDURE,
3222: G_MODULE_PREFIX || l_procedure_name,
3223: '****************************************');
3224: END IF; /*(l_invoice_type = '2' and l_ctt_class = 'CM')*/
3225: --checking whether CM is associated with AR invoice or not

Line 3289: IF (FND_LOG.LEVEL_UNEXPECTED >=

3285: --if credit memo not associated with any AR inv or associated with multi AR inv
3286: IF l_cm_warn = TRUE THEN
3287: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_DES_NULL');
3288: l_error_string := fnd_message.GET();
3289: IF (FND_LOG.LEVEL_UNEXPECTED >=
3290: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3291: log(FND_LOG.LEVEL_PROCEDURE,
3292: G_MODULE_PREFIX || l_procedure_name,
3293: 'AR_GTA_CRMEMO_DES_NULL');

Line 3290: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3286: IF l_cm_warn = TRUE THEN
3287: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_DES_NULL');
3288: l_error_string := fnd_message.GET();
3289: IF (FND_LOG.LEVEL_UNEXPECTED >=
3290: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3291: log(FND_LOG.LEVEL_PROCEDURE,
3292: G_MODULE_PREFIX || l_procedure_name,
3293: 'AR_GTA_CRMEMO_DES_NULL');
3294: END IF;

Line 3291: log(FND_LOG.LEVEL_PROCEDURE,

3287: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_DES_NULL');
3288: l_error_string := fnd_message.GET();
3289: IF (FND_LOG.LEVEL_UNEXPECTED >=
3290: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3291: log(FND_LOG.LEVEL_PROCEDURE,
3292: G_MODULE_PREFIX || l_procedure_name,
3293: 'AR_GTA_CRMEMO_DES_NULL');
3294: END IF;
3295: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3295: IF (FND_LOG.LEVEL_EXCEPTION >=

3291: log(FND_LOG.LEVEL_PROCEDURE,
3292: G_MODULE_PREFIX || l_procedure_name,
3293: 'AR_GTA_CRMEMO_DES_NULL');
3294: END IF;
3295: IF (FND_LOG.LEVEL_EXCEPTION >=
3296: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3298: G_MODULE_PREFIX || l_procedure_name,
3299: l_error_string);

Line 3296: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3292: G_MODULE_PREFIX || l_procedure_name,
3293: 'AR_GTA_CRMEMO_DES_NULL');
3294: END IF;
3295: IF (FND_LOG.LEVEL_EXCEPTION >=
3296: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3298: G_MODULE_PREFIX || l_procedure_name,
3299: l_error_string);
3300: END IF;

Line 3297: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3293: 'AR_GTA_CRMEMO_DES_NULL');
3294: END IF;
3295: IF (FND_LOG.LEVEL_EXCEPTION >=
3296: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3298: G_MODULE_PREFIX || l_procedure_name,
3299: l_error_string);
3300: END IF;
3301: END IF; --l_cm_warn = TRUE

Line 3306: IF (FND_LOG.LEVEL_UNEXPECTED >=

3302:
3303: IF l_cm_warn2 = TRUE THEN
3304: fnd_message.SET_NAME('AR', 'AR_GTA_TRS_NO_GT_INV');
3305: l_error_string := fnd_message.GET();
3306: IF (FND_LOG.LEVEL_UNEXPECTED >=
3307: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3308: log(FND_LOG.LEVEL_PROCEDURE,
3309: G_MODULE_PREFIX || l_procedure_name,
3310: 'AR_GTA_TRS_NO_GT_INV');

Line 3307: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3303: IF l_cm_warn2 = TRUE THEN
3304: fnd_message.SET_NAME('AR', 'AR_GTA_TRS_NO_GT_INV');
3305: l_error_string := fnd_message.GET();
3306: IF (FND_LOG.LEVEL_UNEXPECTED >=
3307: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3308: log(FND_LOG.LEVEL_PROCEDURE,
3309: G_MODULE_PREFIX || l_procedure_name,
3310: 'AR_GTA_TRS_NO_GT_INV');
3311: END IF;

Line 3308: log(FND_LOG.LEVEL_PROCEDURE,

3304: fnd_message.SET_NAME('AR', 'AR_GTA_TRS_NO_GT_INV');
3305: l_error_string := fnd_message.GET();
3306: IF (FND_LOG.LEVEL_UNEXPECTED >=
3307: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3308: log(FND_LOG.LEVEL_PROCEDURE,
3309: G_MODULE_PREFIX || l_procedure_name,
3310: 'AR_GTA_TRS_NO_GT_INV');
3311: END IF;
3312: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3312: IF (FND_LOG.LEVEL_EXCEPTION >=

3308: log(FND_LOG.LEVEL_PROCEDURE,
3309: G_MODULE_PREFIX || l_procedure_name,
3310: 'AR_GTA_TRS_NO_GT_INV');
3311: END IF;
3312: IF (FND_LOG.LEVEL_EXCEPTION >=
3313: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3315: G_MODULE_PREFIX || l_procedure_name,
3316: l_error_string);

Line 3313: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3309: G_MODULE_PREFIX || l_procedure_name,
3310: 'AR_GTA_TRS_NO_GT_INV');
3311: END IF;
3312: IF (FND_LOG.LEVEL_EXCEPTION >=
3313: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3315: G_MODULE_PREFIX || l_procedure_name,
3316: l_error_string);
3317: END IF;

Line 3314: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3310: 'AR_GTA_TRS_NO_GT_INV');
3311: END IF;
3312: IF (FND_LOG.LEVEL_EXCEPTION >=
3313: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3315: G_MODULE_PREFIX || l_procedure_name,
3316: l_error_string);
3317: END IF;
3318: END IF; --l_cm_warn2 = TRUE

Line 3360: IF (FND_LOG.LEVEL_UNEXPECTED >=

3356: --if credit memo associated with AR and in GTA but not VAT generated for non-common VAT
3357: --rasie correspoding AR transation not in GT warning.
3358: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_MISSING_GTINV');
3359: l_error_string := fnd_message.GET();
3360: IF (FND_LOG.LEVEL_UNEXPECTED >=
3361: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3362: log(FND_LOG.LEVEL_PROCEDURE,
3363: G_MODULE_PREFIX || l_procedure_name,
3364: 'AR_GTA_CRMEMO_MISSING_GTINV');

Line 3361: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3357: --rasie correspoding AR transation not in GT warning.
3358: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_MISSING_GTINV');
3359: l_error_string := fnd_message.GET();
3360: IF (FND_LOG.LEVEL_UNEXPECTED >=
3361: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3362: log(FND_LOG.LEVEL_PROCEDURE,
3363: G_MODULE_PREFIX || l_procedure_name,
3364: 'AR_GTA_CRMEMO_MISSING_GTINV');
3365: END IF;

Line 3362: log(FND_LOG.LEVEL_PROCEDURE,

3358: fnd_message.SET_NAME('AR', 'AR_GTA_CRMEMO_MISSING_GTINV');
3359: l_error_string := fnd_message.GET();
3360: IF (FND_LOG.LEVEL_UNEXPECTED >=
3361: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3362: log(FND_LOG.LEVEL_PROCEDURE,
3363: G_MODULE_PREFIX || l_procedure_name,
3364: 'AR_GTA_CRMEMO_MISSING_GTINV');
3365: END IF;
3366: IF (FND_LOG.LEVEL_EXCEPTION >=

Line 3366: IF (FND_LOG.LEVEL_EXCEPTION >=

3362: log(FND_LOG.LEVEL_PROCEDURE,
3363: G_MODULE_PREFIX || l_procedure_name,
3364: 'AR_GTA_CRMEMO_MISSING_GTINV');
3365: END IF;
3366: IF (FND_LOG.LEVEL_EXCEPTION >=
3367: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3368: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3369: G_MODULE_PREFIX || l_procedure_name,
3370: l_error_string);

Line 3367: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3363: G_MODULE_PREFIX || l_procedure_name,
3364: 'AR_GTA_CRMEMO_MISSING_GTINV');
3365: END IF;
3366: IF (FND_LOG.LEVEL_EXCEPTION >=
3367: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3368: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3369: G_MODULE_PREFIX || l_procedure_name,
3370: l_error_string);
3371: END IF;

Line 3368: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3364: 'AR_GTA_CRMEMO_MISSING_GTINV');
3365: END IF;
3366: IF (FND_LOG.LEVEL_EXCEPTION >=
3367: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3368: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3369: G_MODULE_PREFIX || l_procedure_name,
3370: l_error_string);
3371: END IF;
3372: CLOSE c_ra_lines;

Line 3384: IF (FND_LOG.LEVEL_EXCEPTION >=

3380: IF (l_invoice_type <> '2') THEN
3381: --If invoice type is not common VAT
3382: IF (l_cust_addr_excep = 'true') THEN
3383: --if customer address is null
3384: IF (FND_LOG.LEVEL_EXCEPTION >=
3385: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3386: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3387: G_MODULE_PREFIX || l_procedure_name,
3388: 'no data found when select cust address for non-common VAT invoice');

Line 3385: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3381: --If invoice type is not common VAT
3382: IF (l_cust_addr_excep = 'true') THEN
3383: --if customer address is null
3384: IF (FND_LOG.LEVEL_EXCEPTION >=
3385: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3386: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3387: G_MODULE_PREFIX || l_procedure_name,
3388: 'no data found when select cust address for non-common VAT invoice');
3389: END IF;

Line 3386: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3382: IF (l_cust_addr_excep = 'true') THEN
3383: --if customer address is null
3384: IF (FND_LOG.LEVEL_EXCEPTION >=
3385: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3386: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3387: G_MODULE_PREFIX || l_procedure_name,
3388: 'no data found when select cust address for non-common VAT invoice');
3389: END IF;
3390: l_error_string := 'no data found when select cust address for non-common VAT invoice';

Line 3396: IF (FND_LOG.LEVEL_EXCEPTION >=

3392: RAISE l_normal_exception;
3393: END IF; -- IF (l_cust_addr_excep = 'true') THEN
3394: IF (l_cust_phone_exp = 'true') THEN
3395: --if customer phone is null
3396: IF (FND_LOG.LEVEL_EXCEPTION >=
3397: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3398: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3399: G_MODULE_PREFIX || l_procedure_name,
3400: 'no data found when select customer phone number for non-common VAT invoice');

Line 3397: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3393: END IF; -- IF (l_cust_addr_excep = 'true') THEN
3394: IF (l_cust_phone_exp = 'true') THEN
3395: --if customer phone is null
3396: IF (FND_LOG.LEVEL_EXCEPTION >=
3397: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3398: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3399: G_MODULE_PREFIX || l_procedure_name,
3400: 'no data found when select customer phone number for non-common VAT invoice');
3401: END IF;

Line 3398: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3394: IF (l_cust_phone_exp = 'true') THEN
3395: --if customer phone is null
3396: IF (FND_LOG.LEVEL_EXCEPTION >=
3397: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3398: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3399: G_MODULE_PREFIX || l_procedure_name,
3400: 'no data found when select customer phone number for non-common VAT invoice');
3401: END IF;
3402: l_error_string := 'no data found when select customer phone number for non-common VAT invoice';

Line 3410: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3406: END IF; /*IF (l_cust_phone_exp = 'true')*/
3407: --Yao Zhang Commented for bug 7629877 there is no necessary to check cm for non-common invoice
3408: /*IF (l_ar_inv_excep = 'true') THEN --if credit memo not associated with any AR inv for NON-Common VAT
3409:
3410: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3411: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3412: , G_MODULE_PREFIX || l_procedure_name
3413: , l_error_string);
3414: END IF;

Line 3411: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3407: --Yao Zhang Commented for bug 7629877 there is no necessary to check cm for non-common invoice
3408: /*IF (l_ar_inv_excep = 'true') THEN --if credit memo not associated with any AR inv for NON-Common VAT
3409:
3410: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3411: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3412: , G_MODULE_PREFIX || l_procedure_name
3413: , l_error_string);
3414: END IF;
3415:

Line 3428: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3424:
3425:
3426: l_error_string := 'There is no corresponding VAT invoice in workbench to process this credit memo';
3427: -- begin log
3428: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3429: THEN
3430: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX ||
3431: l_procedure_name,
3432: 'AR_GTA_CRMEMO_MISSING_GTAINV');

Line 3430: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX ||

3426: l_error_string := 'There is no corresponding VAT invoice in workbench to process this credit memo';
3427: -- begin log
3428: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3429: THEN
3430: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX ||
3431: l_procedure_name,
3432: 'AR_GTA_CRMEMO_MISSING_GTAINV');
3433: END IF;
3434: -- end log

Line 3436: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3432: 'AR_GTA_CRMEMO_MISSING_GTAINV');
3433: END IF;
3434: -- end log
3435:
3436: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3437: THEN
3438: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3439: , G_MODULE_PREFIX || l_procedure_name
3440: , l_error_string);

Line 3438: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3434: -- end log
3435:
3436: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3437: THEN
3438: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3439: , G_MODULE_PREFIX || l_procedure_name
3440: , l_error_string);
3441: END IF;
3442:

Line 3482: IF (FND_LOG.LEVEL_PROCEDURE >=

3478: --fnd_message.set_token('TAX_REG_NUM',
3479: -- l_fp_registration_number);
3480: l_error_string := fnd_message.GET();
3481: -- begin log
3482: IF (FND_LOG.LEVEL_PROCEDURE >=
3483: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3484: log(FND_LOG.LEVEL_PROCEDURE,
3485: G_MODULE_PREFIX || l_procedure_name,
3486: 'exception missing transaction type association' ||

Line 3483: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3479: -- l_fp_registration_number);
3480: l_error_string := fnd_message.GET();
3481: -- begin log
3482: IF (FND_LOG.LEVEL_PROCEDURE >=
3483: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3484: log(FND_LOG.LEVEL_PROCEDURE,
3485: G_MODULE_PREFIX || l_procedure_name,
3486: 'exception missing transaction type association' ||
3487: l_proce_error_buffer);

Line 3484: log(FND_LOG.LEVEL_PROCEDURE,

3480: l_error_string := fnd_message.GET();
3481: -- begin log
3482: IF (FND_LOG.LEVEL_PROCEDURE >=
3483: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3484: log(FND_LOG.LEVEL_PROCEDURE,
3485: G_MODULE_PREFIX || l_procedure_name,
3486: 'exception missing transaction type association' ||
3487: l_proce_error_buffer);
3488: END IF;

Line 3494: IF (FND_LOG.LEVEL_PROCEDURE >=

3490: ELSIF l_proce_error_buffer = 'AR_GTA_TAX_ERROR_RECYCLE' THEN
3491: fnd_message.SET_NAME('AR', l_proce_error_buffer);
3492: l_error_string := fnd_message.GET();
3493: -- begin log
3494: IF (FND_LOG.LEVEL_PROCEDURE >=
3495: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3496: log(FND_LOG.LEVEL_PROCEDURE,
3497: G_MODULE_PREFIX || l_procedure_name,
3498: 'exception tax rate and tax amount for Recycle Invoice Type' ||

Line 3495: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3491: fnd_message.SET_NAME('AR', l_proce_error_buffer);
3492: l_error_string := fnd_message.GET();
3493: -- begin log
3494: IF (FND_LOG.LEVEL_PROCEDURE >=
3495: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3496: log(FND_LOG.LEVEL_PROCEDURE,
3497: G_MODULE_PREFIX || l_procedure_name,
3498: 'exception tax rate and tax amount for Recycle Invoice Type' ||
3499: l_proce_error_buffer);

Line 3496: log(FND_LOG.LEVEL_PROCEDURE,

3492: l_error_string := fnd_message.GET();
3493: -- begin log
3494: IF (FND_LOG.LEVEL_PROCEDURE >=
3495: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3496: log(FND_LOG.LEVEL_PROCEDURE,
3497: G_MODULE_PREFIX || l_procedure_name,
3498: 'exception tax rate and tax amount for Recycle Invoice Type' ||
3499: l_proce_error_buffer);
3500: END IF;

Line 3509: IF (FND_LOG.LEVEL_PROCEDURE >=

3505: fnd_message.set_token('TAXTYPE', l_vat_tax_type);
3506: l_error_string := fnd_message.GET();
3507:
3508: -- begin log
3509: IF (FND_LOG.LEVEL_PROCEDURE >=
3510: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: log(FND_LOG.LEVEL_PROCEDURE,
3512: G_MODULE_PREFIX || l_procedure_name,
3513: 'exception registration number' ||

Line 3510: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3506: l_error_string := fnd_message.GET();
3507:
3508: -- begin log
3509: IF (FND_LOG.LEVEL_PROCEDURE >=
3510: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: log(FND_LOG.LEVEL_PROCEDURE,
3512: G_MODULE_PREFIX || l_procedure_name,
3513: 'exception registration number' ||
3514: l_proce_error_buffer);

Line 3511: log(FND_LOG.LEVEL_PROCEDURE,

3507:
3508: -- begin log
3509: IF (FND_LOG.LEVEL_PROCEDURE >=
3510: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: log(FND_LOG.LEVEL_PROCEDURE,
3512: G_MODULE_PREFIX || l_procedure_name,
3513: 'exception registration number' ||
3514: l_proce_error_buffer);
3515: END IF;

Line 3519: IF (FND_LOG.LEVEL_EXCEPTION >=

3515: END IF;
3516: -- end log
3517: END IF;
3518:
3519: IF (FND_LOG.LEVEL_EXCEPTION >=
3520: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3521: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3522: G_MODULE_PREFIX || l_procedure_name,
3523: l_error_string);

Line 3520: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3516: -- end log
3517: END IF;
3518:
3519: IF (FND_LOG.LEVEL_EXCEPTION >=
3520: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3521: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3522: G_MODULE_PREFIX || l_procedure_name,
3523: l_error_string);
3524: END IF;

Line 3521: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3517: END IF;
3518:
3519: IF (FND_LOG.LEVEL_EXCEPTION >=
3520: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3521: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3522: G_MODULE_PREFIX || l_procedure_name,
3523: l_error_string);
3524: END IF;
3525: CLOSE c_ra_lines;

Line 3534: IF (FND_LOG.LEVEL_PROCEDURE >=

3530: l_fp_registration_number);
3531: l_error_string := fnd_message.get();
3532:
3533: -- begin log
3534: IF (FND_LOG.LEVEL_PROCEDURE >=
3535: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3536: log(FND_LOG.LEVEL_PROCEDURE,
3537: G_MODULE_PREFIX || l_procedure_name,
3538: 'AR_GTA_SYS_CONFIG_MISSING');

Line 3535: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3531: l_error_string := fnd_message.get();
3532:
3533: -- begin log
3534: IF (FND_LOG.LEVEL_PROCEDURE >=
3535: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3536: log(FND_LOG.LEVEL_PROCEDURE,
3537: G_MODULE_PREFIX || l_procedure_name,
3538: 'AR_GTA_SYS_CONFIG_MISSING');
3539: log(FND_LOG.LEVEL_PROCEDURE,

Line 3536: log(FND_LOG.LEVEL_PROCEDURE,

3532:
3533: -- begin log
3534: IF (FND_LOG.LEVEL_PROCEDURE >=
3535: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3536: log(FND_LOG.LEVEL_PROCEDURE,
3537: G_MODULE_PREFIX || l_procedure_name,
3538: 'AR_GTA_SYS_CONFIG_MISSING');
3539: log(FND_LOG.LEVEL_PROCEDURE,
3540: G_MODULE_PREFIX || l_procedure_name,

Line 3539: log(FND_LOG.LEVEL_PROCEDURE,

3535: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3536: log(FND_LOG.LEVEL_PROCEDURE,
3537: G_MODULE_PREFIX || l_procedure_name,
3538: 'AR_GTA_SYS_CONFIG_MISSING');
3539: log(FND_LOG.LEVEL_PROCEDURE,
3540: G_MODULE_PREFIX || l_procedure_name,
3541: 'First Party tax registartion number is not exist in System Option');
3542: END IF;
3543: -- end log

Line 3594: IF (FND_LOG.LEVEL_PROCEDURE >=

3590: l_customer_trx_line_number);
3591: l_error_string := fnd_message.GET();
3592:
3593: -- begin log
3594: IF (FND_LOG.LEVEL_PROCEDURE >=
3595: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: log(FND_LOG.LEVEL_PROCEDURE,
3597: G_MODULE_PREFIX || l_procedure_name,
3598: 'AR_GTA_UNITPRICE_EXCEED');

Line 3595: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3591: l_error_string := fnd_message.GET();
3592:
3593: -- begin log
3594: IF (FND_LOG.LEVEL_PROCEDURE >=
3595: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: log(FND_LOG.LEVEL_PROCEDURE,
3597: G_MODULE_PREFIX || l_procedure_name,
3598: 'AR_GTA_UNITPRICE_EXCEED');
3599: END IF;

Line 3596: log(FND_LOG.LEVEL_PROCEDURE,

3592:
3593: -- begin log
3594: IF (FND_LOG.LEVEL_PROCEDURE >=
3595: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: log(FND_LOG.LEVEL_PROCEDURE,
3597: G_MODULE_PREFIX || l_procedure_name,
3598: 'AR_GTA_UNITPRICE_EXCEED');
3599: END IF;
3600: -- end log

Line 3602: IF (FND_LOG.LEVEL_EXCEPTION >=

3598: 'AR_GTA_UNITPRICE_EXCEED');
3599: END IF;
3600: -- end log
3601:
3602: IF (FND_LOG.LEVEL_EXCEPTION >=
3603: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3604: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3605: G_MODULE_PREFIX || l_procedure_name,
3606: l_error_string);

Line 3603: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3599: END IF;
3600: -- end log
3601:
3602: IF (FND_LOG.LEVEL_EXCEPTION >=
3603: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3604: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3605: G_MODULE_PREFIX || l_procedure_name,
3606: l_error_string);
3607: END IF;

Line 3604: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3600: -- end log
3601:
3602: IF (FND_LOG.LEVEL_EXCEPTION >=
3603: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3604: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3605: G_MODULE_PREFIX || l_procedure_name,
3606: l_error_string);
3607: END IF;
3608: CLOSE c_ra_lines;

Line 3615: IF (FND_LOG.LEVEL_UNEXPECTED >=

3611: END IF; /*(l_unit_price_split_flag IS NOT NULL) OR l_unit_price_split_flag = 'N'*/
3612:
3613: EXCEPTION
3614: WHEN no_data_found THEN
3615: IF (FND_LOG.LEVEL_UNEXPECTED >=
3616: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3617: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3618: G_MODULE_PREFIX || l_procedure_name,
3619: 'no data found');

Line 3616: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3612:
3613: EXCEPTION
3614: WHEN no_data_found THEN
3615: IF (FND_LOG.LEVEL_UNEXPECTED >=
3616: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3617: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3618: G_MODULE_PREFIX || l_procedure_name,
3619: 'no data found');
3620: END IF;

Line 3617: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

3613: EXCEPTION
3614: WHEN no_data_found THEN
3615: IF (FND_LOG.LEVEL_UNEXPECTED >=
3616: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3617: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3618: G_MODULE_PREFIX || l_procedure_name,
3619: 'no data found');
3620: END IF;
3621: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');

Line 3623: IF (FND_LOG.LEVEL_UNEXPECTED >=

3619: 'no data found');
3620: END IF;
3621: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
3622:
3623: IF (FND_LOG.LEVEL_UNEXPECTED >=
3624: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3625: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3626: G_MODULE_PREFIX || l_procedure_name,
3627: fnd_message.get());

Line 3624: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3620: END IF;
3621: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
3622:
3623: IF (FND_LOG.LEVEL_UNEXPECTED >=
3624: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3625: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3626: G_MODULE_PREFIX || l_procedure_name,
3627: fnd_message.get());
3628:

Line 3625: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

3621: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
3622:
3623: IF (FND_LOG.LEVEL_UNEXPECTED >=
3624: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3625: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
3626: G_MODULE_PREFIX || l_procedure_name,
3627: fnd_message.get());
3628:
3629: END IF;

Line 3649: IF (FND_LOG.LEVEL_PROCEDURE >=

3645: l_trx_header.gta_trx_header_id);
3646: l_error_string := fnd_message.get();
3647:
3648: -- begin log
3649: IF (FND_LOG.LEVEL_PROCEDURE >=
3650: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3651: log(FND_LOG.LEVEL_PROCEDURE,
3652: G_MODULE_PREFIX || l_procedure_name,
3653: 'AR_GTA_MISSING_FIELD');

Line 3650: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3646: l_error_string := fnd_message.get();
3647:
3648: -- begin log
3649: IF (FND_LOG.LEVEL_PROCEDURE >=
3650: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3651: log(FND_LOG.LEVEL_PROCEDURE,
3652: G_MODULE_PREFIX || l_procedure_name,
3653: 'AR_GTA_MISSING_FIELD');
3654: END IF;

Line 3651: log(FND_LOG.LEVEL_PROCEDURE,

3647:
3648: -- begin log
3649: IF (FND_LOG.LEVEL_PROCEDURE >=
3650: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3651: log(FND_LOG.LEVEL_PROCEDURE,
3652: G_MODULE_PREFIX || l_procedure_name,
3653: 'AR_GTA_MISSING_FIELD');
3654: END IF;
3655: -- end log

Line 3657: IF (FND_LOG.LEVEL_EXCEPTION >=

3653: 'AR_GTA_MISSING_FIELD');
3654: END IF;
3655: -- end log
3656:
3657: IF (FND_LOG.LEVEL_EXCEPTION >=
3658: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3659: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3660: G_MODULE_PREFIX || l_procedure_name,
3661: l_error_string);

Line 3658: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3654: END IF;
3655: -- end log
3656:
3657: IF (FND_LOG.LEVEL_EXCEPTION >=
3658: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3659: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3660: G_MODULE_PREFIX || l_procedure_name,
3661: l_error_string);
3662: END IF;

Line 3659: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3655: -- end log
3656:
3657: IF (FND_LOG.LEVEL_EXCEPTION >=
3658: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3659: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3660: G_MODULE_PREFIX || l_procedure_name,
3661: l_error_string);
3662: END IF;
3663:

Line 3692: IF (fnd_log.level_exception >=

3688: fnd_message.set_token('NUM',
3689: l_customer_trx_line_number);
3690: l_error_string := fnd_message.get();
3691: -- log
3692: IF (fnd_log.level_exception >=
3693: fnd_log.g_current_runtime_level) THEN
3694: fnd_log.STRING(fnd_log.level_exception,
3695: g_module_prefix || l_procedure_name,
3696: l_error_string);

Line 3693: fnd_log.g_current_runtime_level) THEN

3689: l_customer_trx_line_number);
3690: l_error_string := fnd_message.get();
3691: -- log
3692: IF (fnd_log.level_exception >=
3693: fnd_log.g_current_runtime_level) THEN
3694: fnd_log.STRING(fnd_log.level_exception,
3695: g_module_prefix || l_procedure_name,
3696: l_error_string);
3697: END IF;

Line 3694: fnd_log.STRING(fnd_log.level_exception,

3690: l_error_string := fnd_message.get();
3691: -- log
3692: IF (fnd_log.level_exception >=
3693: fnd_log.g_current_runtime_level) THEN
3694: fnd_log.STRING(fnd_log.level_exception,
3695: g_module_prefix || l_procedure_name,
3696: l_error_string);
3697: END IF;
3698: CLOSE c_ra_lines;

Line 3750: IF (FND_LOG.LEVEL_EXCEPTION >=

3746: l_customer_trx_line_number);
3747: l_error_string := fnd_message.get();
3748:
3749: -- log
3750: IF (FND_LOG.LEVEL_EXCEPTION >=
3751: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3752: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3753: G_MODULE_PREFIX || l_procedure_name,
3754: l_error_string);

Line 3751: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3747: l_error_string := fnd_message.get();
3748:
3749: -- log
3750: IF (FND_LOG.LEVEL_EXCEPTION >=
3751: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3752: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3753: G_MODULE_PREFIX || l_procedure_name,
3754: l_error_string);
3755: END IF;

Line 3752: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3748:
3749: -- log
3750: IF (FND_LOG.LEVEL_EXCEPTION >=
3751: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3752: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3753: G_MODULE_PREFIX || l_procedure_name,
3754: l_error_string);
3755: END IF;
3756:

Line 3768: IF (FND_LOG.LEVEL_EXCEPTION >=

3764: fnd_message.SET_TOKEN('NUM',
3765: l_customer_trx_line_number);
3766: l_error_string := fnd_message.get();
3767: -- log
3768: IF (FND_LOG.LEVEL_EXCEPTION >=
3769: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3770: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3771: G_MODULE_PREFIX || l_procedure_name,
3772: l_error_string);

Line 3769: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3765: l_customer_trx_line_number);
3766: l_error_string := fnd_message.get();
3767: -- log
3768: IF (FND_LOG.LEVEL_EXCEPTION >=
3769: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3770: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3771: G_MODULE_PREFIX || l_procedure_name,
3772: l_error_string);
3773: END IF;

Line 3770: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3766: l_error_string := fnd_message.get();
3767: -- log
3768: IF (FND_LOG.LEVEL_EXCEPTION >=
3769: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3770: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3771: G_MODULE_PREFIX || l_procedure_name,
3772: l_error_string);
3773: END IF;
3774: CLOSE c_ra_lines;

Line 3790: IF (FND_LOG.LEVEL_EXCEPTION >=

3786: fnd_message.SET_TOKEN('NUM',
3787: l_customer_trx_line_number);
3788: l_error_string := fnd_message.get();
3789: -- log
3790: IF (FND_LOG.LEVEL_EXCEPTION >=
3791: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3792: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3793: G_MODULE_PREFIX ||
3794: l_procedure_name,

Line 3791: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3787: l_customer_trx_line_number);
3788: l_error_string := fnd_message.get();
3789: -- log
3790: IF (FND_LOG.LEVEL_EXCEPTION >=
3791: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3792: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3793: G_MODULE_PREFIX ||
3794: l_procedure_name,
3795: l_error_string);

Line 3792: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3788: l_error_string := fnd_message.get();
3789: -- log
3790: IF (FND_LOG.LEVEL_EXCEPTION >=
3791: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3792: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3793: G_MODULE_PREFIX ||
3794: l_procedure_name,
3795: l_error_string);
3796: END IF;

Line 3817: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3813: fnd_message.set_token('NUM', l_customer_trx_line_number);
3814: l_error_string := fnd_message.get;
3815:
3816: -- log
3817: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3818: THEN
3819: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3820: , G_MODULE_PREFIX || l_procedure_name
3821: , l_error_string);

Line 3819: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3815:
3816: -- log
3817: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3818: THEN
3819: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3820: , G_MODULE_PREFIX || l_procedure_name
3821: , l_error_string);
3822: END IF;
3823:

Line 3848: IF (FND_LOG.LEVEL_EXCEPTION >=

3844: fnd_message.set_token('ITEM', l_inventory_item_name);
3845: l_error_string := fnd_message.get();
3846:
3847: -- log
3848: IF (FND_LOG.LEVEL_EXCEPTION >=
3849: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3850: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3851: G_MODULE_PREFIX || l_procedure_name,
3852: l_error_string);

Line 3849: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3845: l_error_string := fnd_message.get();
3846:
3847: -- log
3848: IF (FND_LOG.LEVEL_EXCEPTION >=
3849: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3850: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3851: G_MODULE_PREFIX || l_procedure_name,
3852: l_error_string);
3853: END IF;

Line 3850: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3846:
3847: -- log
3848: IF (FND_LOG.LEVEL_EXCEPTION >=
3849: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3850: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3851: G_MODULE_PREFIX || l_procedure_name,
3852: l_error_string);
3853: END IF;
3854:

Line 3867: IF (FND_LOG.LEVEL_EXCEPTION >=

3863: fnd_message.set_token('ITEM', l_inventory_item_name);
3864: l_error_string := fnd_message.get;
3865:
3866: -- log
3867: IF (FND_LOG.LEVEL_EXCEPTION >=
3868: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3870: G_MODULE_PREFIX || l_procedure_name,
3871: l_error_string);

Line 3868: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3864: l_error_string := fnd_message.get;
3865:
3866: -- log
3867: IF (FND_LOG.LEVEL_EXCEPTION >=
3868: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3870: G_MODULE_PREFIX || l_procedure_name,
3871: l_error_string);
3872: END IF;

Line 3869: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3865:
3866: -- log
3867: IF (FND_LOG.LEVEL_EXCEPTION >=
3868: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3869: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3870: G_MODULE_PREFIX || l_procedure_name,
3871: l_error_string);
3872: END IF;
3873:

Line 3892: IF (FND_LOG.LEVEL_PROCEDURE >=

3888: fnd_message.set_token('NUM', l_customer_trx_line_number);
3889: fnd_message.set_token('ITEM', l_inventory_item_name);
3890: l_error_string := fnd_message.get();
3891: -- log
3892: IF (FND_LOG.LEVEL_PROCEDURE >=
3893: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3894: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
3895: G_MODULE_PREFIX || l_procedure_name,
3896: l_error_string);

Line 3893: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3889: fnd_message.set_token('ITEM', l_inventory_item_name);
3890: l_error_string := fnd_message.get();
3891: -- log
3892: IF (FND_LOG.LEVEL_PROCEDURE >=
3893: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3894: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
3895: G_MODULE_PREFIX || l_procedure_name,
3896: l_error_string);
3897: END IF;

Line 3894: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

3890: l_error_string := fnd_message.get();
3891: -- log
3892: IF (FND_LOG.LEVEL_PROCEDURE >=
3893: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3894: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
3895: G_MODULE_PREFIX || l_procedure_name,
3896: l_error_string);
3897: END IF;
3898: CLOSE c_ra_lines;

Line 3926: IF (FND_LOG.LEVEL_PROCEDURE >=

3922: get_ra_item_model(p_ra_line_id => l_customer_trx_line_id,
3923: p_attribute_column => l_ra_model_attribute_column,
3924: x_attribute_value => l_trx_line.item_model);
3925: -- begin log
3926: IF (FND_LOG.LEVEL_PROCEDURE >=
3927: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3928: log(FND_LOG.LEVEL_PROCEDURE,
3929: G_MODULE_PREFIX || l_procedure_name,
3930: 'item_model:' || l_trx_line.item_model);

Line 3927: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3923: p_attribute_column => l_ra_model_attribute_column,
3924: x_attribute_value => l_trx_line.item_model);
3925: -- begin log
3926: IF (FND_LOG.LEVEL_PROCEDURE >=
3927: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3928: log(FND_LOG.LEVEL_PROCEDURE,
3929: G_MODULE_PREFIX || l_procedure_name,
3930: 'item_model:' || l_trx_line.item_model);
3931: END IF;

Line 3928: log(FND_LOG.LEVEL_PROCEDURE,

3924: x_attribute_value => l_trx_line.item_model);
3925: -- begin log
3926: IF (FND_LOG.LEVEL_PROCEDURE >=
3927: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3928: log(FND_LOG.LEVEL_PROCEDURE,
3929: G_MODULE_PREFIX || l_procedure_name,
3930: 'item_model:' || l_trx_line.item_model);
3931: END IF;
3932: -- end log

Line 3943: IF (FND_LOG.LEVEL_EXCEPTION >=

3939: l_customer_trx_line_number);
3940: fnd_message.set_token('ITEM', l_inventory_item_name);
3941: l_error_string := fnd_message.get();
3942: -- log
3943: IF (FND_LOG.LEVEL_EXCEPTION >=
3944: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3945: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3946: G_MODULE_PREFIX || l_procedure_name,
3947: l_error_string);

Line 3944: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3940: fnd_message.set_token('ITEM', l_inventory_item_name);
3941: l_error_string := fnd_message.get();
3942: -- log
3943: IF (FND_LOG.LEVEL_EXCEPTION >=
3944: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3945: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3946: G_MODULE_PREFIX || l_procedure_name,
3947: l_error_string);
3948: END IF;

Line 3945: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3941: l_error_string := fnd_message.get();
3942: -- log
3943: IF (FND_LOG.LEVEL_EXCEPTION >=
3944: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3945: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3946: G_MODULE_PREFIX || l_procedure_name,
3947: l_error_string);
3948: END IF;
3949: CLOSE c_ra_lines;

Line 3971: IF (FND_LOG.LEVEL_PROCEDURE >=

3967: l_trx_line.item_tax_denomination := '0';
3968: END IF;
3969: --End Enhancement 12424456
3970: -- begin log
3971: IF (FND_LOG.LEVEL_PROCEDURE >=
3972: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3973: log(FND_LOG.LEVEL_PROCEDURE,
3974: G_MODULE_PREFIX || l_procedure_name,
3975: 'item_tax_denomination:' ||

Line 3972: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3968: END IF;
3969: --End Enhancement 12424456
3970: -- begin log
3971: IF (FND_LOG.LEVEL_PROCEDURE >=
3972: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3973: log(FND_LOG.LEVEL_PROCEDURE,
3974: G_MODULE_PREFIX || l_procedure_name,
3975: 'item_tax_denomination:' ||
3976: l_trx_line.item_tax_denomination);

Line 3973: log(FND_LOG.LEVEL_PROCEDURE,

3969: --End Enhancement 12424456
3970: -- begin log
3971: IF (FND_LOG.LEVEL_PROCEDURE >=
3972: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3973: log(FND_LOG.LEVEL_PROCEDURE,
3974: G_MODULE_PREFIX || l_procedure_name,
3975: 'item_tax_denomination:' ||
3976: l_trx_line.item_tax_denomination);
3977: END IF;

Line 3992: IF (FND_LOG.LEVEL_EXCEPTION >=

3988: fnd_message.set_token('NUM', l_customer_trx_line_number);
3989: fnd_message.set_token('ITEM', l_inventory_item_name);
3990: l_error_string := fnd_message.get();
3991: -- log
3992: IF (FND_LOG.LEVEL_EXCEPTION >=
3993: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3994: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3995: G_MODULE_PREFIX || l_procedure_name,
3996: l_error_string);

Line 3993: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3989: fnd_message.set_token('ITEM', l_inventory_item_name);
3990: l_error_string := fnd_message.get();
3991: -- log
3992: IF (FND_LOG.LEVEL_EXCEPTION >=
3993: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3994: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3995: G_MODULE_PREFIX || l_procedure_name,
3996: l_error_string);
3997: END IF;

Line 3994: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

3990: l_error_string := fnd_message.get();
3991: -- log
3992: IF (FND_LOG.LEVEL_EXCEPTION >=
3993: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3994: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
3995: G_MODULE_PREFIX || l_procedure_name,
3996: l_error_string);
3997: END IF;
3998: CLOSE c_ra_lines;

Line 4034: IF (FND_LOG.LEVEL_UNEXPECTED >=

4030: fnd_message.set_token('NUM', l_customer_trx_line_number);
4031: fnd_message.set_token('ITEM', l_inventory_item_name);
4032: l_error_string := fnd_message.get();
4033: -- log
4034: IF (FND_LOG.LEVEL_UNEXPECTED >=
4035: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4036: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4037: G_MODULE_PREFIX || l_procedure_name,
4038: l_error_string);

Line 4035: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4031: fnd_message.set_token('ITEM', l_inventory_item_name);
4032: l_error_string := fnd_message.get();
4033: -- log
4034: IF (FND_LOG.LEVEL_UNEXPECTED >=
4035: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4036: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4037: G_MODULE_PREFIX || l_procedure_name,
4038: l_error_string);
4039: END IF;

Line 4036: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

4032: l_error_string := fnd_message.get();
4033: -- log
4034: IF (FND_LOG.LEVEL_UNEXPECTED >=
4035: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4036: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4037: G_MODULE_PREFIX || l_procedure_name,
4038: l_error_string);
4039: END IF;
4040: CLOSE c_ra_lines;

Line 4050: IF (FND_LOG.LEVEL_UNEXPECTED >=

4046: fnd_message.SET_NAME('AR', 'AR_GTA_MISSING_CROSS_REF');
4047: fnd_message.set_token('NUM', l_customer_trx_line_number);
4048: l_error_string := fnd_message.get();
4049: -- log
4050: IF (FND_LOG.LEVEL_UNEXPECTED >=
4051: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4052: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4053: G_MODULE_PREFIX || l_procedure_name,
4054: l_error_string);

Line 4051: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4047: fnd_message.set_token('NUM', l_customer_trx_line_number);
4048: l_error_string := fnd_message.get();
4049: -- log
4050: IF (FND_LOG.LEVEL_UNEXPECTED >=
4051: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4052: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4053: G_MODULE_PREFIX || l_procedure_name,
4054: l_error_string);
4055: END IF;

Line 4052: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

4048: l_error_string := fnd_message.get();
4049: -- log
4050: IF (FND_LOG.LEVEL_UNEXPECTED >=
4051: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4052: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4053: G_MODULE_PREFIX || l_procedure_name,
4054: l_error_string);
4055: END IF;
4056: CLOSE c_ra_lines;

Line 4068: IF (FND_LOG.LEVEL_PROCEDURE >=

4064: p_item_master_org_id => l_master_org, --yao zhang changed fix bug 7829039
4065: x_inventory_item_code => l_trx_line.item_number);
4066:
4067: -- begin log
4068: IF (FND_LOG.LEVEL_PROCEDURE >=
4069: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: log(FND_LOG.LEVEL_PROCEDURE,
4071: G_MODULE_PREFIX || l_procedure_name,
4072: 'get_inventory_item_number end ');

Line 4069: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4065: x_inventory_item_code => l_trx_line.item_number);
4066:
4067: -- begin log
4068: IF (FND_LOG.LEVEL_PROCEDURE >=
4069: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: log(FND_LOG.LEVEL_PROCEDURE,
4071: G_MODULE_PREFIX || l_procedure_name,
4072: 'get_inventory_item_number end ');
4073: END IF;

Line 4070: log(FND_LOG.LEVEL_PROCEDURE,

4066:
4067: -- begin log
4068: IF (FND_LOG.LEVEL_PROCEDURE >=
4069: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4070: log(FND_LOG.LEVEL_PROCEDURE,
4071: G_MODULE_PREFIX || l_procedure_name,
4072: 'get_inventory_item_number end ');
4073: END IF;
4074: -- end log

Line 4136: IF (FND_LOG.LEVEL_PROCEDURE >=

4132: --Qiong add for bug 10396722 end
4133: l_trx_line.last_update_login := fnd_global.CONC_LOGIN_ID();
4134:
4135: -- begin log
4136: IF (FND_LOG.LEVEL_PROCEDURE >=
4137: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4138: log(FND_LOG.LEVEL_PROCEDURE,
4139: G_MODULE_PREFIX || l_procedure_name,
4140: 'Add a new line !!' || l_customer_trx_line_id);

Line 4137: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4133: l_trx_line.last_update_login := fnd_global.CONC_LOGIN_ID();
4134:
4135: -- begin log
4136: IF (FND_LOG.LEVEL_PROCEDURE >=
4137: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4138: log(FND_LOG.LEVEL_PROCEDURE,
4139: G_MODULE_PREFIX || l_procedure_name,
4140: 'Add a new line !!' || l_customer_trx_line_id);
4141: END IF;

Line 4138: log(FND_LOG.LEVEL_PROCEDURE,

4134:
4135: -- begin log
4136: IF (FND_LOG.LEVEL_PROCEDURE >=
4137: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4138: log(FND_LOG.LEVEL_PROCEDURE,
4139: G_MODULE_PREFIX || l_procedure_name,
4140: 'Add a new line !!' || l_customer_trx_line_id);
4141: END IF;
4142: -- end log

Line 4150: IF (FND_LOG.LEVEL_UNEXPECTED >=

4146: -- end insert data into trx_line
4147:
4148: EXCEPTION
4149: WHEN l_no_tax_line_exception THEN
4150: IF (FND_LOG.LEVEL_UNEXPECTED >=
4151: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4153: G_MODULE_PREFIX || l_procedure_name,
4154: 'this line' || l_customer_trx_line_id ||

Line 4151: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4147:
4148: EXCEPTION
4149: WHEN l_no_tax_line_exception THEN
4150: IF (FND_LOG.LEVEL_UNEXPECTED >=
4151: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4153: G_MODULE_PREFIX || l_procedure_name,
4154: 'this line' || l_customer_trx_line_id ||
4155: 'have not one tax line');

Line 4152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4148: EXCEPTION
4149: WHEN l_no_tax_line_exception THEN
4150: IF (FND_LOG.LEVEL_UNEXPECTED >=
4151: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4153: G_MODULE_PREFIX || l_procedure_name,
4154: 'this line' || l_customer_trx_line_id ||
4155: 'have not one tax line');
4156: log(FND_LOG.LEVEL_PROCEDURE,

Line 4156: log(FND_LOG.LEVEL_PROCEDURE,

4152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4153: G_MODULE_PREFIX || l_procedure_name,
4154: 'this line' || l_customer_trx_line_id ||
4155: 'have not one tax line');
4156: log(FND_LOG.LEVEL_PROCEDURE,
4157: G_MODULE_PREFIX || l_procedure_name,
4158: 'This line have not one tax line');
4159: END IF;
4160: END;

Line 4234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4230: l_error_string,
4231: NULL
4232: FROM dual;
4233: WHEN l_repeat_exception THEN
4234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4236: G_MODULE_PREFIX || l_procedure_name,
4237: '. REPEAT_EXCEPTION ' || l_customer_trx_id);
4238: END IF;

Line 4235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4231: NULL
4232: FROM dual;
4233: WHEN l_repeat_exception THEN
4234: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4235: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4236: G_MODULE_PREFIX || l_procedure_name,
4237: '. REPEAT_EXCEPTION ' || l_customer_trx_id);
4238: END IF;
4239:

Line 4251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4247:
4248: -- close dynamic sql cursor
4249: dbms_sql.close_cursor(l_cursor);
4250:
4251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4253: G_MODULE_PREFIX || l_procedure_name,
4254: 'END procedure. ');
4255: END IF;

Line 4252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4248: -- close dynamic sql cursor
4249: dbms_sql.close_cursor(l_cursor);
4250:
4251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4252: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4253: G_MODULE_PREFIX || l_procedure_name,
4254: 'END procedure. ');
4255: END IF;
4256:

Line 4259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4255: END IF;
4256:
4257: EXCEPTION
4258: WHEN OTHERS THEN
4259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4261: G_MODULE_PREFIX || l_procedure_name ||
4262: '. OTHER_EXCEPTION',
4263: Sqlcode || Sqlerrm);

Line 4260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4256:
4257: EXCEPTION
4258: WHEN OTHERS THEN
4259: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4260: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4261: G_MODULE_PREFIX || l_procedure_name ||
4262: '. OTHER_EXCEPTION',
4263: Sqlcode || Sqlerrm);
4264: END IF;

Line 4328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4324: l_inventory_attribute30 mtl_system_items_b.attribute15%TYPE;
4325:
4326: BEGIN
4327:
4328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4330: G_MODULE_PREFIX || l_procedure_name,
4331: 'Begin Procedure. ');
4332: END IF;

Line 4329: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4325:
4326: BEGIN
4327:
4328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4330: G_MODULE_PREFIX || l_procedure_name,
4331: 'Begin Procedure. ');
4332: END IF;
4333:

Line 4335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4331: 'Begin Procedure. ');
4332: END IF;
4333:
4334: -- begin log
4335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4336: log(FND_LOG.LEVEL_PROCEDURE,
4337: G_MODULE_PREFIX || l_procedure_name,
4338: 'Begin get_inv_item_model');
4339: log(FND_LOG.LEVEL_PROCEDURE,

Line 4336: log(FND_LOG.LEVEL_PROCEDURE,

4332: END IF;
4333:
4334: -- begin log
4335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4336: log(FND_LOG.LEVEL_PROCEDURE,
4337: G_MODULE_PREFIX || l_procedure_name,
4338: 'Begin get_inv_item_model');
4339: log(FND_LOG.LEVEL_PROCEDURE,
4340: G_MODULE_PREFIX || l_procedure_name,

Line 4339: log(FND_LOG.LEVEL_PROCEDURE,

4335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4336: log(FND_LOG.LEVEL_PROCEDURE,
4337: G_MODULE_PREFIX || l_procedure_name,
4338: 'Begin get_inv_item_model');
4339: log(FND_LOG.LEVEL_PROCEDURE,
4340: G_MODULE_PREFIX || l_procedure_name,
4341: 'p_item_master_org_id:' || p_item_master_org_id);
4342: log(FND_LOG.LEVEL_PROCEDURE,
4343: G_MODULE_PREFIX || l_procedure_name,

Line 4342: log(FND_LOG.LEVEL_PROCEDURE,

4338: 'Begin get_inv_item_model');
4339: log(FND_LOG.LEVEL_PROCEDURE,
4340: G_MODULE_PREFIX || l_procedure_name,
4341: 'p_item_master_org_id:' || p_item_master_org_id);
4342: log(FND_LOG.LEVEL_PROCEDURE,
4343: G_MODULE_PREFIX || l_procedure_name,
4344: 'p_inventory_item_id:' || p_inventory_item_id);
4345: log(FND_LOG.LEVEL_PROCEDURE,
4346: G_MODULE_PREFIX || l_procedure_name,

Line 4345: log(FND_LOG.LEVEL_PROCEDURE,

4341: 'p_item_master_org_id:' || p_item_master_org_id);
4342: log(FND_LOG.LEVEL_PROCEDURE,
4343: G_MODULE_PREFIX || l_procedure_name,
4344: 'p_inventory_item_id:' || p_inventory_item_id);
4345: log(FND_LOG.LEVEL_PROCEDURE,
4346: G_MODULE_PREFIX || l_procedure_name,
4347: 'p_attribute_column:' || p_attribute_column);
4348: END IF;
4349: -- end log

Line 4419: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4415: WHERE organization_id = p_item_master_org_id --yao zhang modified for bug 7829039
4416: AND inventory_item_id = p_inventory_item_id;
4417: EXCEPTION
4418: WHEN no_data_found THEN
4419: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4420: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
4421: G_MODULE_PREFIX || l_procedure_name,
4422: 'no date found ');
4423: END IF;

Line 4420: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

4416: AND inventory_item_id = p_inventory_item_id;
4417: EXCEPTION
4418: WHEN no_data_found THEN
4419: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4420: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
4421: G_MODULE_PREFIX || l_procedure_name,
4422: 'no date found ');
4423: END IF;
4424: RAISE;

Line 4429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4425: END;
4426:
4427: ELSE
4428: -- return null
4429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4430: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4431: G_MODULE_PREFIX || l_procedure_name,
4432: 'The item id is null ');
4433: log(FND_LOG.LEVEL_PROCEDURE,

Line 4430: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4426:
4427: ELSE
4428: -- return null
4429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4430: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4431: G_MODULE_PREFIX || l_procedure_name,
4432: 'The item id is null ');
4433: log(FND_LOG.LEVEL_PROCEDURE,
4434: G_MODULE_PREFIX || l_procedure_name,

Line 4433: log(FND_LOG.LEVEL_PROCEDURE,

4429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4430: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4431: G_MODULE_PREFIX || l_procedure_name,
4432: 'The item id is null ');
4433: log(FND_LOG.LEVEL_PROCEDURE,
4434: G_MODULE_PREFIX || l_procedure_name,
4435: l_procedure_name || ' The item id is null');
4436: END IF;
4437:

Line 4502: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4498: ELSIF p_attribute_column = 'ATTRIBUTE30' THEN
4499: x_attribute_value := l_inventory_attribute30;
4500: ELSE
4501:
4502: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4503: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4504: G_MODULE_PREFIX || l_procedure_name,
4505: 'not found data in get_inv_item_model');
4506: END IF;

Line 4503: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

4499: x_attribute_value := l_inventory_attribute30;
4500: ELSE
4501:
4502: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4503: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4504: G_MODULE_PREFIX || l_procedure_name,
4505: 'not found data in get_inv_item_model');
4506: END IF;
4507: END IF;

Line 4510: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4506: END IF;
4507: END IF;
4508:
4509: -- begin log
4510: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4511: log(FND_LOG.LEVEL_PROCEDURE,
4512: G_MODULE_PREFIX || l_procedure_name,
4513: 'x_attribute_value:' || x_attribute_value);
4514: log(FND_LOG.LEVEL_PROCEDURE,

Line 4511: log(FND_LOG.LEVEL_PROCEDURE,

4507: END IF;
4508:
4509: -- begin log
4510: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4511: log(FND_LOG.LEVEL_PROCEDURE,
4512: G_MODULE_PREFIX || l_procedure_name,
4513: 'x_attribute_value:' || x_attribute_value);
4514: log(FND_LOG.LEVEL_PROCEDURE,
4515: G_MODULE_PREFIX || l_procedure_name,

Line 4514: log(FND_LOG.LEVEL_PROCEDURE,

4510: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4511: log(FND_LOG.LEVEL_PROCEDURE,
4512: G_MODULE_PREFIX || l_procedure_name,
4513: 'x_attribute_value:' || x_attribute_value);
4514: log(FND_LOG.LEVEL_PROCEDURE,
4515: G_MODULE_PREFIX || l_procedure_name,
4516: 'End get_inv_item_model');
4517: END IF;
4518: -- end log

Line 4520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4516: 'End get_inv_item_model');
4517: END IF;
4518: -- end log
4519:
4520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4521: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4522: G_MODULE_PREFIX || l_procedure_name,
4523: 'END procedure. ');
4524: END IF;

Line 4521: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4517: END IF;
4518: -- end log
4519:
4520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4521: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4522: G_MODULE_PREFIX || l_procedure_name,
4523: 'END procedure. ');
4524: END IF;
4525:

Line 4528: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4524: END IF;
4525:
4526: EXCEPTION
4527: WHEN OTHERS THEN
4528: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4529: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4530: G_MODULE_PREFIX || l_procedure_name ||
4531: '. OTHER_EXCEPTION ',
4532: Sqlcode || Sqlerrm);

Line 4529: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4525:
4526: EXCEPTION
4527: WHEN OTHERS THEN
4528: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4529: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4530: G_MODULE_PREFIX || l_procedure_name ||
4531: '. OTHER_EXCEPTION ',
4532: Sqlcode || Sqlerrm);
4533: END IF;

Line 4619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4615: l_global_attribute20 ra_customer_trx_lines_all.global_attribute20%TYPE;
4616:
4617: BEGIN
4618:
4619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4620: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4621: G_MODULE_PREFIX || l_procedure_name,
4622: 'Begin Procedure. ');
4623: END IF;

Line 4620: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4616:
4617: BEGIN
4618:
4619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4620: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4621: G_MODULE_PREFIX || l_procedure_name,
4622: 'Begin Procedure. ');
4623: END IF;
4624:

Line 4626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4622: 'Begin Procedure. ');
4623: END IF;
4624:
4625: -- begin log
4626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4627: log(FND_LOG.LEVEL_PROCEDURE,
4628: G_MODULE_PREFIX || l_procedure_name,
4629: 'Begin Get_Ra_Item_Model');
4630: log(FND_LOG.LEVEL_PROCEDURE,

Line 4627: log(FND_LOG.LEVEL_PROCEDURE,

4623: END IF;
4624:
4625: -- begin log
4626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4627: log(FND_LOG.LEVEL_PROCEDURE,
4628: G_MODULE_PREFIX || l_procedure_name,
4629: 'Begin Get_Ra_Item_Model');
4630: log(FND_LOG.LEVEL_PROCEDURE,
4631: G_MODULE_PREFIX || l_procedure_name,

Line 4630: log(FND_LOG.LEVEL_PROCEDURE,

4626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4627: log(FND_LOG.LEVEL_PROCEDURE,
4628: G_MODULE_PREFIX || l_procedure_name,
4629: 'Begin Get_Ra_Item_Model');
4630: log(FND_LOG.LEVEL_PROCEDURE,
4631: G_MODULE_PREFIX || l_procedure_name,
4632: 'p_ra_line_id:' || p_ra_line_id);
4633: log(FND_LOG.LEVEL_PROCEDURE,
4634: G_MODULE_PREFIX || l_procedure_name,

Line 4633: log(FND_LOG.LEVEL_PROCEDURE,

4629: 'Begin Get_Ra_Item_Model');
4630: log(FND_LOG.LEVEL_PROCEDURE,
4631: G_MODULE_PREFIX || l_procedure_name,
4632: 'p_ra_line_id:' || p_ra_line_id);
4633: log(FND_LOG.LEVEL_PROCEDURE,
4634: G_MODULE_PREFIX || l_procedure_name,
4635: 'p_attribute_column:' || p_attribute_column);
4636: END IF;
4637: -- end log

Line 4746: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4742: WHERE l.customer_trx_line_id = p_ra_line_id;
4743:
4744: EXCEPTION
4745: WHEN no_data_found THEN
4746: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4747: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
4748: G_MODULE_PREFIX || l_procedure_name,
4749: 'no date found ');
4750: END IF;

Line 4747: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,

4743:
4744: EXCEPTION
4745: WHEN no_data_found THEN
4746: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4747: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION,
4748: G_MODULE_PREFIX || l_procedure_name,
4749: 'no date found ');
4750: END IF;
4751: RAISE;

Line 4859: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4855: ELSE
4856: -- report a error
4857: x_attribute_value := NULL;
4858:
4859: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4860: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4861: G_MODULE_PREFIX || l_procedure_name,
4862: 'no data found in get_ra_item_model');
4863: END IF;

Line 4860: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,

4856: -- report a error
4857: x_attribute_value := NULL;
4858:
4859: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4860: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED,
4861: G_MODULE_PREFIX || l_procedure_name,
4862: 'no data found in get_ra_item_model');
4863: END IF;
4864: END IF;

Line 4866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4862: 'no data found in get_ra_item_model');
4863: END IF;
4864: END IF;
4865:
4866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4867: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4868: G_MODULE_PREFIX || l_procedure_name,
4869: 'END procedure. ');
4870: END IF;

Line 4867: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4863: END IF;
4864: END IF;
4865:
4866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4867: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4868: G_MODULE_PREFIX || l_procedure_name,
4869: 'END procedure. ');
4870: END IF;
4871:

Line 4873: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4869: 'END procedure. ');
4870: END IF;
4871:
4872: -- begin log
4873: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4874: log(FND_LOG.LEVEL_PROCEDURE,
4875: G_MODULE_PREFIX || l_procedure_name,
4876: 'End Get_Ra_Item_Model');
4877: END IF;

Line 4874: log(FND_LOG.LEVEL_PROCEDURE,

4870: END IF;
4871:
4872: -- begin log
4873: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4874: log(FND_LOG.LEVEL_PROCEDURE,
4875: G_MODULE_PREFIX || l_procedure_name,
4876: 'End Get_Ra_Item_Model');
4877: END IF;
4878: -- end log

Line 4882: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4878: -- end log
4879:
4880: EXCEPTION
4881: WHEN OTHERS THEN
4882: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4884: G_MODULE_PREFIX || l_procedure_name ||
4885: '. OTHER_EXCEPTION ',
4886: Sqlcode || Sqlerrm);

Line 4883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4879:
4880: EXCEPTION
4881: WHEN OTHERS THEN
4882: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4883: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4884: G_MODULE_PREFIX || l_procedure_name ||
4885: '. OTHER_EXCEPTION ',
4886: Sqlcode || Sqlerrm);
4887: END IF;

Line 4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4913: l_inventory_item_code MTL_SYSTEM_ITEMS_B_KFV.concatenated_segments%TYPE;
4914: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4915: BEGIN
4916:
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4919: G_MODULE_PREFIX || l_procedure_name,
4920: 'Begin procedure. ');
4921: END IF;

Line 4918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4914: l_procedure_name VARCHAR2(50) := 'get_inventory_item_number';
4915: BEGIN
4916:
4917: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4919: G_MODULE_PREFIX || l_procedure_name,
4920: 'Begin procedure. ');
4921: END IF;
4922:

Line 4924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4920: 'Begin procedure. ');
4921: END IF;
4922:
4923: -- begin log
4924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4925: log(FND_LOG.LEVEL_PROCEDURE,
4926: G_MODULE_PREFIX || l_procedure_name,
4927: 'Begin get_inventory_item_number');
4928: END IF;

Line 4925: log(FND_LOG.LEVEL_PROCEDURE,

4921: END IF;
4922:
4923: -- begin log
4924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4925: log(FND_LOG.LEVEL_PROCEDURE,
4926: G_MODULE_PREFIX || l_procedure_name,
4927: 'Begin get_inventory_item_number');
4928: END IF;
4929: -- end log

Line 4941: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4937: WHERE msv.inventory_item_id = p_inventory_item_id --yao zhang changed fix bug 7829039
4938: AND msv.organization_id = p_item_master_org_id;
4939:
4940: -- begin log
4941: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4942: log(FND_LOG.LEVEL_PROCEDURE,
4943: G_MODULE_PREFIX || l_procedure_name,
4944: 'l_inventory_item_code:' || l_inventory_item_code);
4945: END IF;

Line 4942: log(FND_LOG.LEVEL_PROCEDURE,

4938: AND msv.organization_id = p_item_master_org_id;
4939:
4940: -- begin log
4941: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4942: log(FND_LOG.LEVEL_PROCEDURE,
4943: G_MODULE_PREFIX || l_procedure_name,
4944: 'l_inventory_item_code:' || l_inventory_item_code);
4945: END IF;
4946: -- end log

Line 4951: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4947:
4948: x_inventory_item_code := l_inventory_item_code;
4949: END IF;
4950:
4951: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4952: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4953: G_MODULE_PREFIX || l_procedure_name,
4954: 'END procedure. ');
4955: END IF;

Line 4952: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

4948: x_inventory_item_code := l_inventory_item_code;
4949: END IF;
4950:
4951: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4952: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
4953: G_MODULE_PREFIX || l_procedure_name,
4954: 'END procedure. ');
4955: END IF;
4956:

Line 4958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4954: 'END procedure. ');
4955: END IF;
4956:
4957: -- begin log
4958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4959: log(FND_LOG.LEVEL_PROCEDURE,
4960: G_MODULE_PREFIX || l_procedure_name,
4961: 'End get_inventory_item_number');
4962: END IF;

Line 4959: log(FND_LOG.LEVEL_PROCEDURE,

4955: END IF;
4956:
4957: -- begin log
4958: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4959: log(FND_LOG.LEVEL_PROCEDURE,
4960: G_MODULE_PREFIX || l_procedure_name,
4961: 'End get_inventory_item_number');
4962: END IF;
4963: -- end log

Line 4967: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4963: -- end log
4964:
4965: EXCEPTION
4966: WHEN no_data_found THEN
4967: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4969: G_MODULE_PREFIX || l_procedure_name ||
4970: '. OTHER_EXCEPTION ',
4971: 'item_code not be found ' || Sqlcode || Sqlerrm);

Line 4968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4964:
4965: EXCEPTION
4966: WHEN no_data_found THEN
4967: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4968: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4969: G_MODULE_PREFIX || l_procedure_name ||
4970: '. OTHER_EXCEPTION ',
4971: 'item_code not be found ' || Sqlcode || Sqlerrm);
4972: END IF;

Line 4974: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4970: '. OTHER_EXCEPTION ',
4971: 'item_code not be found ' || Sqlcode || Sqlerrm);
4972: END IF;
4973: WHEN OTHERS THEN
4974: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4975: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4976: G_MODULE_PREFIX || l_procedure_name ||
4977: '. OTHER_EXCEPTION ',
4978: Sqlcode || Sqlerrm);

Line 4975: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

4971: 'item_code not be found ' || Sqlcode || Sqlerrm);
4972: END IF;
4973: WHEN OTHERS THEN
4974: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4975: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
4976: G_MODULE_PREFIX || l_procedure_name ||
4977: '. OTHER_EXCEPTION ',
4978: Sqlcode || Sqlerrm);
4979: END IF;

Line 5006: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5002: x_uom_name OUT NOCOPY VARCHAR2) IS
5003: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
5004: l_procedure_name VARCHAR2(30) := 'get_uom_name';
5005: BEGIN
5006: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5007: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
5008: G_MODULE_PREFIX || l_procedure_name,
5009: 'Begin procedure. ');
5010: END IF;

Line 5007: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

5003: l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
5004: l_procedure_name VARCHAR2(30) := 'get_uom_name';
5005: BEGIN
5006: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5007: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
5008: G_MODULE_PREFIX || l_procedure_name,
5009: 'Begin procedure. ');
5010: END IF;
5011:

Line 5021: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5017: AND uom.LANGUAGE = userenv('LANG');
5018:
5019: EXCEPTION
5020: WHEN no_data_found THEN
5021: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5022: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION,
5023: G_MODULE_PREFIX || l_procedure_name,
5024: 'no data found when select receiving_routing_id by line_location_id' ||
5025: SQLCODE || SQLERRM);

Line 5022: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION,

5018:
5019: EXCEPTION
5020: WHEN no_data_found THEN
5021: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5022: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION,
5023: G_MODULE_PREFIX || l_procedure_name,
5024: 'no data found when select receiving_routing_id by line_location_id' ||
5025: SQLCODE || SQLERRM);
5026: END IF;

Line 5032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5028: END;
5029:
5030: x_uom_name := l_unit_of_measure;
5031:
5032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5033: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
5034: G_MODULE_PREFIX || l_procedure_name,
5035: 'END procedure. ');
5036: END IF;

Line 5033: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

5029:
5030: x_uom_name := l_unit_of_measure;
5031:
5032: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5033: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
5034: G_MODULE_PREFIX || l_procedure_name,
5035: 'END procedure. ');
5036: END IF;
5037:

Line 5041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5037:
5038: EXCEPTION
5039:
5040: WHEN OTHERS THEN
5041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5043: G_MODULE_PREFIX || l_procedure_name ||
5044: '. OTHER_EXCEPTION ',
5045: Sqlcode || Sqlerrm);

Line 5042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,

5038: EXCEPTION
5039:
5040: WHEN OTHERS THEN
5041: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5042: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
5043: G_MODULE_PREFIX || l_procedure_name ||
5044: '. OTHER_EXCEPTION ',
5045: Sqlcode || Sqlerrm);
5046: END IF;