DBA Data[Home] [Help]

APPS.IGIRSTPT dependencies on FND_MESSAGE

Line 380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

376: commit;
377: --bug 3199481 fnd logging changes: sdixit
378:
379: IF ( l_excep_level >= l_debug_level ) THEN
380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
383: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg1',TRUE);
384: END IF;

Line 381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

377: --bug 3199481 fnd logging changes: sdixit
378:
379: IF ( l_excep_level >= l_debug_level ) THEN
380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
383: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg1',TRUE);
384: END IF;
385: raise_application_error(-20000, 'Procedure Create_Ra_Interface failed '||SQLERRM);

Line 382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

378:
379: IF ( l_excep_level >= l_debug_level ) THEN
380: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
381: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
382: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
383: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg1',TRUE);
384: END IF;
385: raise_application_error(-20000, 'Procedure Create_Ra_Interface failed '||SQLERRM);
386: WHEN OTHERS

Line 405: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

401: --not setting seeded message as hardcoded message is being passed
402:
403: IF ( l_unexp_level >= l_debug_level ) THEN
404:
405: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
406: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
407: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
408: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg2',TRUE);
409: END IF;

Line 406: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

402:
403: IF ( l_unexp_level >= l_debug_level ) THEN
404:
405: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
406: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
407: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
408: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg2',TRUE);
409: END IF;
410: raise_application_error(-20000, 'Procedure Create_Ra_Interface failed '||SQLERRM);

Line 407: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

403: IF ( l_unexp_level >= l_debug_level ) THEN
404:
405: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
406: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
407: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
408: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg2',TRUE);
409: END IF;
410: raise_application_error(-20000, 'Procedure Create_Ra_Interface failed '||SQLERRM);
411:

Line 648: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

644: --not setting seeded message as hardcoded message is being passed
645:
646: IF ( l_excep_level >= l_debug_level ) THEN
647:
648: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
649: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
650: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
651: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.igistpdb.IGIRSTPT.Create_Ap_interface.msg1',TRUE);
652: END IF;

Line 649: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

645:
646: IF ( l_excep_level >= l_debug_level ) THEN
647:
648: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
649: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
650: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
651: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.igistpdb.IGIRSTPT.Create_Ap_interface.msg1',TRUE);
652: END IF;
653: raise_application_error(-20000, 'Procedure Create_AP_Interface failed '||SQLERRM);

Line 650: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

646: IF ( l_excep_level >= l_debug_level ) THEN
647:
648: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
649: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
650: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
651: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.igistpdb.IGIRSTPT.Create_Ap_interface.msg1',TRUE);
652: END IF;
653: raise_application_error(-20000, 'Procedure Create_AP_Interface failed '||SQLERRM);
654: WHEN OTHERS

Line 673: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

669: --not setting seeded message as hardcoded message is being passed
670:
671: IF ( l_unexp_level >= l_debug_level ) THEN
672:
673: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
674: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
675: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
676: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Create_Ap_Interface.msg2',TRUE);
677: END IF;

Line 674: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

670:
671: IF ( l_unexp_level >= l_debug_level ) THEN
672:
673: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
674: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
675: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
676: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Create_Ap_Interface.msg2',TRUE);
677: END IF;
678: raise_application_error(-20000, 'Procedure Create_AP_Interface failed '||SQLERRM);

Line 675: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

671: IF ( l_unexp_level >= l_debug_level ) THEN
672:
673: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
674: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
675: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
676: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Create_Ap_Interface.msg2',TRUE);
677: END IF;
678: raise_application_error(-20000, 'Procedure Create_AP_Interface failed '||SQLERRM);
679:

Line 791: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

787: commit;
788: --bug 3199481 fnd logging changes: sdixit
789: --standard way to handle when-others as per FND logging guidelines
790: --not setting seeded message as hardcoded message is being passed
791: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
792: --retcode := 2;
793: --errbuf := Fnd_message.get;
794:
795: IF ( l_excep_level >= l_debug_level ) THEN

Line 793: --errbuf := Fnd_message.get;

789: --standard way to handle when-others as per FND logging guidelines
790: --not setting seeded message as hardcoded message is being passed
791: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
792: --retcode := 2;
793: --errbuf := Fnd_message.get;
794:
795: IF ( l_excep_level >= l_debug_level ) THEN
796:
797: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 797: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

793: --errbuf := Fnd_message.get;
794:
795: IF ( l_excep_level >= l_debug_level ) THEN
796:
797: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
798: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
799: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
800: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg1',TRUE);
801: END IF;

Line 798: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

794:
795: IF ( l_excep_level >= l_debug_level ) THEN
796:
797: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
798: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
799: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
800: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg1',TRUE);
801: END IF;
802: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);

Line 799: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

795: IF ( l_excep_level >= l_debug_level ) THEN
796:
797: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
798: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
799: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
800: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg1',TRUE);
801: END IF;
802: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);
803: else

Line 807: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

803: else
804: --bug 3199481 fnd logging changes: sdixit
805: --standard way to handle when-others as per FND logging guidelines
806: --not setting seeded message as hardcoded message is being passed
807: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
808: --retcode := 2;
809: --errbuf := Fnd_message.get;
810:
811: IF ( l_unexp_level >= l_debug_level ) THEN

Line 809: --errbuf := Fnd_message.get;

805: --standard way to handle when-others as per FND logging guidelines
806: --not setting seeded message as hardcoded message is being passed
807: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
808: --retcode := 2;
809: --errbuf := Fnd_message.get;
810:
811: IF ( l_unexp_level >= l_debug_level ) THEN
812:
813: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 813: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

809: --errbuf := Fnd_message.get;
810:
811: IF ( l_unexp_level >= l_debug_level ) THEN
812:
813: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
814: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
815: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
816: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg2',TRUE);
817: END IF;

Line 814: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

810:
811: IF ( l_unexp_level >= l_debug_level ) THEN
812:
813: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
814: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
815: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
816: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg2',TRUE);
817: END IF;
818: raise;

Line 815: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

811: IF ( l_unexp_level >= l_debug_level ) THEN
812:
813: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
814: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
815: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
816: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg2',TRUE);
817: END IF;
818: raise;
819: end if;

Line 831: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

827: commit;
828: --bug 3199481 fnd logging changes: sdixit
829: --standard way to handle when-others as per FND logging guidelines
830: --not setting seeded message as hardcoded message is being passed
831: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
832: --retcode := 2;
833: --errbuf := Fnd_message.get;
834:
835: IF ( l_unexp_level >= l_debug_level ) THEN

Line 833: --errbuf := Fnd_message.get;

829: --standard way to handle when-others as per FND logging guidelines
830: --not setting seeded message as hardcoded message is being passed
831: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
832: --retcode := 2;
833: --errbuf := Fnd_message.get;
834:
835: IF ( l_unexp_level >= l_debug_level ) THEN
836:
837: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 837: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

833: --errbuf := Fnd_message.get;
834:
835: IF ( l_unexp_level >= l_debug_level ) THEN
836:
837: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
838: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
839: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
840: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg3',TRUE);
841: END IF;

Line 838: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

834:
835: IF ( l_unexp_level >= l_debug_level ) THEN
836:
837: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
838: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
839: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
840: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg3',TRUE);
841: END IF;
842: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);

Line 839: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

835: IF ( l_unexp_level >= l_debug_level ) THEN
836:
837: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
838: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
839: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
840: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg3',TRUE);
841: END IF;
842: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);
843: else

Line 850: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

846: --standard way to handle when-others as per FND logging guidelines
847:
848: IF ( l_unexp_level >= l_debug_level ) THEN
849:
850: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
851: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
852: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
853: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg4',TRUE);
854: END IF;

Line 851: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

847:
848: IF ( l_unexp_level >= l_debug_level ) THEN
849:
850: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
851: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
852: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
853: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg4',TRUE);
854: END IF;
855: end if;

Line 852: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

848: IF ( l_unexp_level >= l_debug_level ) THEN
849:
850: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
851: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
852: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
853: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg4',TRUE);
854: END IF;
855: end if;
856:

Line 1078: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1074:
1075: --bug 3199481 fnd logging changes: sdixit
1076: --standard way to handle when-others as per FND logging guidelines
1077: --not setting seeded message as hardcoded message is being passed
1078: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1079: --retcode := 2;
1080: --errbuf := Fnd_message.get;
1081:
1082: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1080: --errbuf := Fnd_message.get;

1076: --standard way to handle when-others as per FND logging guidelines
1077: --not setting seeded message as hardcoded message is being passed
1078: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1079: --retcode := 2;
1080: --errbuf := Fnd_message.get;
1081:
1082: IF ( l_unexp_level >= l_debug_level ) THEN
1083:
1084: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1084: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1080: --errbuf := Fnd_message.get;
1081:
1082: IF ( l_unexp_level >= l_debug_level ) THEN
1083:
1084: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1085: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1086: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1087: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Interface_Batches',TRUE);
1088: END IF;

Line 1085: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1081:
1082: IF ( l_unexp_level >= l_debug_level ) THEN
1083:
1084: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1085: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1086: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1087: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Interface_Batches',TRUE);
1088: END IF;
1089: raise_application_error(-20003, 'Invoice Import failed for the batch :'||l_batch_source_name);

Line 1086: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1082: IF ( l_unexp_level >= l_debug_level ) THEN
1083:
1084: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1085: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1086: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1087: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Interface_Batches',TRUE);
1088: END IF;
1089: raise_application_error(-20003, 'Invoice Import failed for the batch :'||l_batch_source_name);
1090:

Line 1262: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1258:
1259: --bug 3199481 fnd logging changes: sdixit
1260: --standard way to handle when-others as per FND logging guidelines
1261: --not setting seeded message as hardcoded message is being passed
1262: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1263: --retcode := 2;
1264: --errbuf := Fnd_message.get;
1265:
1266: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1264: --errbuf := Fnd_message.get;

1260: --standard way to handle when-others as per FND logging guidelines
1261: --not setting seeded message as hardcoded message is being passed
1262: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1263: --retcode := 2;
1264: --errbuf := Fnd_message.get;
1265:
1266: IF ( l_unexp_level >= l_debug_level ) THEN
1267:
1268: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1268: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1264: --errbuf := Fnd_message.get;
1265:
1266: IF ( l_unexp_level >= l_debug_level ) THEN
1267:
1268: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1269: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1270: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1271: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1272: END IF;

Line 1269: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1265:
1266: IF ( l_unexp_level >= l_debug_level ) THEN
1267:
1268: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1269: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1270: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1271: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1272: END IF;
1273: raise_application_error(-20002, ' Auto Invoice not submitted : batch source '||to_char(l_batch_source_id)||' is not found in RA_BATCH_SOURCES');

Line 1270: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1266: IF ( l_unexp_level >= l_debug_level ) THEN
1267:
1268: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1269: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1270: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1271: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1272: END IF;
1273: raise_application_error(-20002, ' Auto Invoice not submitted : batch source '||to_char(l_batch_source_id)||' is not found in RA_BATCH_SOURCES');
1274: raise_application_error(-20000, 'Procedure IGIRSTPN.INITIATE_INTERFACES failed '||SQLERRM);

Line 1400: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1396: commit;
1397: --bug 3199481 fnd logging changes: sdixit
1398: --standard way to handle when-others as per FND logging guidelines
1399: --not setting seeded message as hardcoded message is being passed
1400: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1401: --retcode := 2;
1402: --errbuf := Fnd_message.get;
1403:
1404: IF ( l_excep_level >= l_debug_level ) THEN

Line 1402: --errbuf := Fnd_message.get;

1398: --standard way to handle when-others as per FND logging guidelines
1399: --not setting seeded message as hardcoded message is being passed
1400: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1401: --retcode := 2;
1402: --errbuf := Fnd_message.get;
1403:
1404: IF ( l_excep_level >= l_debug_level ) THEN
1405:
1406: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1406: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1402: --errbuf := Fnd_message.get;
1403:
1404: IF ( l_excep_level >= l_debug_level ) THEN
1405:
1406: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1409: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1410: END IF;

Line 1407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1403:
1404: IF ( l_excep_level >= l_debug_level ) THEN
1405:
1406: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1409: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1410: END IF;
1411: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);

Line 1408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1404: IF ( l_excep_level >= l_debug_level ) THEN
1405:
1406: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1407: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1408: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1409: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1410: END IF;
1411: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1412: elsif l_flag = 'R' then

Line 1422: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1418: commit;
1419: --bug 3199481 fnd logging changes: sdixit
1420: --standard way to handle when-others as per FND logging guidelines
1421: --not setting seeded message as hardcoded message is being passed
1422: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1423: --retcode := 2;
1424: --errbuf := Fnd_message.get;
1425:
1426: IF ( l_excep_level >= l_debug_level ) THEN

Line 1424: --errbuf := Fnd_message.get;

1420: --standard way to handle when-others as per FND logging guidelines
1421: --not setting seeded message as hardcoded message is being passed
1422: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1423: --retcode := 2;
1424: --errbuf := Fnd_message.get;
1425:
1426: IF ( l_excep_level >= l_debug_level ) THEN
1427:
1428: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1428: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1424: --errbuf := Fnd_message.get;
1425:
1426: IF ( l_excep_level >= l_debug_level ) THEN
1427:
1428: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1429: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1430: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1431: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1432: END IF;

Line 1429: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1425:
1426: IF ( l_excep_level >= l_debug_level ) THEN
1427:
1428: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1429: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1430: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1431: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1432: END IF;
1433: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);

Line 1430: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1426: IF ( l_excep_level >= l_debug_level ) THEN
1427:
1428: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1429: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1430: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1431: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1432: END IF;
1433: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1434: else

Line 1448: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1444: commit;
1445: --bug 3199481 fnd logging changes: sdixit
1446: --standard way to handle when-others as per FND logging guidelines
1447: --not setting seeded message as hardcoded message is being passed
1448: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1449: --retcode := 2;
1450: --errbuf := Fnd_message.get;
1451:
1452: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1450: --errbuf := Fnd_message.get;

1446: --standard way to handle when-others as per FND logging guidelines
1447: --not setting seeded message as hardcoded message is being passed
1448: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1449: --retcode := 2;
1450: --errbuf := Fnd_message.get;
1451:
1452: IF ( l_unexp_level >= l_debug_level ) THEN
1453:
1454: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1454: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1450: --errbuf := Fnd_message.get;
1451:
1452: IF ( l_unexp_level >= l_debug_level ) THEN
1453:
1454: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1455: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1456: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1457: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1458: END IF;

Line 1455: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1451:
1452: IF ( l_unexp_level >= l_debug_level ) THEN
1453:
1454: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1455: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1456: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1457: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1458: END IF;
1459: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);

Line 1456: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1452: IF ( l_unexp_level >= l_debug_level ) THEN
1453:
1454: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1455: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1456: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1457: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1458: END IF;
1459: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1460: elsif l_flag = 'R' then

Line 1470: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1466: commit;
1467: --bug 3199481 fnd logging changes: sdixit
1468: --standard way to handle when-others as per FND logging guidelines
1469: --not setting seeded message as hardcoded message is being passed
1470: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1471: --retcode := 2;
1472: --errbuf := Fnd_message.get;
1473:
1474: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1472: --errbuf := Fnd_message.get;

1468: --standard way to handle when-others as per FND logging guidelines
1469: --not setting seeded message as hardcoded message is being passed
1470: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1471: --retcode := 2;
1472: --errbuf := Fnd_message.get;
1473:
1474: IF ( l_unexp_level >= l_debug_level ) THEN
1475:
1476: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1476: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1472: --errbuf := Fnd_message.get;
1473:
1474: IF ( l_unexp_level >= l_debug_level ) THEN
1475:
1476: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1477: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1478: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1479: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1480: END IF;

Line 1477: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1473:
1474: IF ( l_unexp_level >= l_debug_level ) THEN
1475:
1476: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1477: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1478: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1479: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1480: END IF;
1481: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);

Line 1478: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1474: IF ( l_unexp_level >= l_debug_level ) THEN
1475:
1476: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1477: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1478: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1479: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1480: END IF;
1481: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1482: else

Line 1486: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

1482: else
1483: --bug 3199481 fnd logging changes: sdixit
1484: --standard way to handle when-others as per FND logging guidelines
1485: --not setting seeded message as hardcoded message is being passed
1486: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1487: --retcode := 2;
1488: --errbuf := Fnd_message.get;
1489:
1490: IF ( l_unexp_level >= l_debug_level ) THEN

Line 1488: --errbuf := Fnd_message.get;

1484: --standard way to handle when-others as per FND logging guidelines
1485: --not setting seeded message as hardcoded message is being passed
1486: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1487: --retcode := 2;
1488: --errbuf := Fnd_message.get;
1489:
1490: IF ( l_unexp_level >= l_debug_level ) THEN
1491:
1492: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

Line 1492: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

1488: --errbuf := Fnd_message.get;
1489:
1490: IF ( l_unexp_level >= l_debug_level ) THEN
1491:
1492: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1493: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1494: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1495: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1496: END IF;

Line 1493: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

1489:
1490: IF ( l_unexp_level >= l_debug_level ) THEN
1491:
1492: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1493: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1494: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1495: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1496: END IF;
1497: raise;

Line 1494: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

1490: IF ( l_unexp_level >= l_debug_level ) THEN
1491:
1492: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1493: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1494: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1495: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1496: END IF;
1497: raise;
1498: end if;