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

Line 16: --following variables added for bug 3199481: fnd logging changes: sdixit

12:
13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
14:
15: -- End of Bug 1058426
16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;

Line 17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13: p_interface_context varchar2(80) := fnd_profile.value('IGI_STP_INTERFACE_CONTEXT');
14:
15: -- End of Bug 1058426
16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 18: l_state_level number := FND_LOG.LEVEL_STATEMENT;

14:
15: -- End of Bug 1058426
16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

15: -- End of Bug 1058426
16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;
23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 20: l_event_level number := FND_LOG.LEVEL_EVENT;

16: --following variables added for bug 3199481: fnd logging changes: sdixit
17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;
23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
24:

Line 21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

17: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;
23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
24:
25:

Line 22: l_error_level number := FND_LOG.LEVEL_ERROR;

18: l_state_level number := FND_LOG.LEVEL_STATEMENT;
19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;
23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
24:
25:
26:

Line 23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

19: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
20: l_event_level number := FND_LOG.LEVEL_EVENT;
21: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
22: l_error_level number := FND_LOG.LEVEL_ERROR;
23: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
24:
25:
26:
27:

Line 377: --bug 3199481 fnd logging changes: sdixit

373: (select batch_id
374: from igi_stp_control
375: where control_id = p_net_batch_id);
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);

Line 383: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg1',TRUE);

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
387: THEN

Line 399: --bug 3199481 fnd logging changes: sdixit

395: from igi_stp_control
396: where control_id = p_net_batch_id);
397:
398: commit;
399: --bug 3199481 fnd logging changes: sdixit
400: --standard way to handle when-others as per FND logging guidelines
401: --not setting seeded message as hardcoded message is being passed
402:
403: IF ( l_unexp_level >= l_debug_level ) THEN

Line 400: --standard way to handle when-others as per FND logging guidelines

396: where control_id = p_net_batch_id);
397:
398: commit;
399: --bug 3199481 fnd logging changes: sdixit
400: --standard way to handle when-others as per FND logging guidelines
401: --not setting seeded message as hardcoded message is being passed
402:
403: IF ( l_unexp_level >= l_debug_level ) THEN
404:

Line 408: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.IGIRSTPT.Create_Ra_Interface.msg2',TRUE);

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:
412: END Create_Ra_Interface;

Line 643: --bug 3199481 fnd logging changes: sdixit

639: from igi_stp_control
640: where control_id = p_net_batch_id);
641: commit;
642:
643: --bug 3199481 fnd logging changes: sdixit
644: --not setting seeded message as hardcoded message is being passed
645:
646: IF ( l_excep_level >= l_debug_level ) THEN
647:

Line 651: FND_LOG.MESSAGE ( l_excep_level,'igi.pls.igistpdb.IGIRSTPT.Create_Ap_interface.msg1',TRUE);

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
655: THEN l_message := substr(sqlerrm,1,120)

Line 668: --bug 3199481 fnd logging changes: sdixit

664: where control_id = p_net_batch_id);
665:
666: commit;
667:
668: --bug 3199481 fnd logging changes: sdixit
669: --not setting seeded message as hardcoded message is being passed
670:
671: IF ( l_unexp_level >= l_debug_level ) THEN
672:

Line 676: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Create_Ap_Interface.msg2',TRUE);

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:
680: END Create_Ap_Interface;

Line 788: --bug 3199481 fnd logging changes: sdixit

784: WHERE batch_id in (select batch_id
785: from igi_stp_control
786: where control_id = p_net_batch_id);
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;

Line 789: --standard way to handle when-others as per FND logging guidelines

785: from igi_stp_control
786: where control_id = p_net_batch_id);
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;

Line 800: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg1',TRUE);

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
804: --bug 3199481 fnd logging changes: sdixit

Line 804: --bug 3199481 fnd logging changes: sdixit

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
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;

Line 805: --standard way to handle when-others as per FND logging guidelines

801: END IF;
802: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);
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;

Line 816: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interface.msg2',TRUE);

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;
820: WHEN OTHERS THEN

Line 828: --bug 3199481 fnd logging changes: sdixit

824: WHERE batch_id in (select batch_id
825: from igi_stp_control
826: where control_id = p_net_batch_id);
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;

Line 829: --standard way to handle when-others as per FND logging guidelines

825: from igi_stp_control
826: where control_id = p_net_batch_id);
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;

Line 840: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg3',TRUE);

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
844: raise;

Line 845: --bug 3199481 fnd logging changes: sdixit

841: END IF;
842: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);
843: else
844: raise;
845: --bug 3199481 fnd logging changes: sdixit
846: --standard way to handle when-others as per FND logging guidelines
847:
848: IF ( l_unexp_level >= l_debug_level ) THEN
849:

Line 846: --standard way to handle when-others as per FND logging guidelines

842: raise_application_error(-20000, 'Procedure Populate_Interfaces failed '||SQLERRM);
843: else
844: raise;
845: --bug 3199481 fnd logging changes: sdixit
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');

Line 853: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Populate_Interfaces.msg4',TRUE);

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:
857: END Populate_Interfaces;

Line 1075: --bug 3199481 fnd logging changes: sdixit

1071: where control_id
1072: = p_net_batch_id);
1073: COMMIT;
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;

Line 1076: --standard way to handle when-others as per FND logging guidelines

1072: = p_net_batch_id);
1073: COMMIT;
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;

Line 1087: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Interface_Batches',TRUE);

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:
1091: ELSE

Line 1259: --bug 3199481 fnd logging changes: sdixit

1255: where control_id = p_net_batch_id);
1256:
1257: COMMIT;
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;

Line 1260: --standard way to handle when-others as per FND logging guidelines

1256:
1257: COMMIT;
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;

Line 1271: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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);
1275:

Line 1397: --bug 3199481 fnd logging changes: sdixit

1393: WHERE batch_id in (select batch_id
1394: from igi_stp_control
1395: where control_id = p_net_batch_id);
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;

Line 1398: --standard way to handle when-others as per FND logging guidelines

1394: from igi_stp_control
1395: where control_id = p_net_batch_id);
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;

Line 1409: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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
1413: UPDATE igi_stp_batches

Line 1419: --bug 3199481 fnd logging changes: sdixit

1415: WHERE batch_id in (select batch_id
1416: from igi_stp_control
1417: where control_id = p_net_batch_id);
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;

Line 1420: --standard way to handle when-others as per FND logging guidelines

1416: from igi_stp_control
1417: where control_id = p_net_batch_id);
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;

Line 1431: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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
1435: raise;

Line 1445: --bug 3199481 fnd logging changes: sdixit

1441: WHERE batch_id in (select batch_id
1442: from igi_stp_control
1443: where control_id = p_net_batch_id);
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;

Line 1446: --standard way to handle when-others as per FND logging guidelines

1442: from igi_stp_control
1443: where control_id = p_net_batch_id);
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;

Line 1457: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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
1461: UPDATE igi_stp_batches

Line 1467: --bug 3199481 fnd logging changes: sdixit

1463: WHERE batch_id in (select batch_id
1464: from igi_stp_control
1465: where control_id = p_net_batch_id);
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;

Line 1468: --standard way to handle when-others as per FND logging guidelines

1464: from igi_stp_control
1465: where control_id = p_net_batch_id);
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;

Line 1479: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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
1483: --bug 3199481 fnd logging changes: sdixit

Line 1483: --bug 3199481 fnd logging changes: sdixit

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
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;

Line 1484: --standard way to handle when-others as per FND logging guidelines

1480: END IF;
1481: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
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;

Line 1495: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);

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;
1499: