DBA Data[Home] [Help]

APPS.IGIRSTPT dependencies on IGIRSTPT

Line 1: PACKAGE BODY IGIRSTPT AS

1: PACKAGE BODY IGIRSTPT AS
2: -- $Header: igistpdb.pls 120.18 2008/03/05 13:34:07 gkumares ship $
3: l_message varchar2(240) := NULL;
4: l_debug varchar2(5) := NULL;
5: l_variable varchar2(80) := NULL;

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

Line 1534: END IGIRSTPT;

1530:
1531: END Submit_Batch;
1532:
1533:
1534: END IGIRSTPT;