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

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

1: PACKAGE BODY IGI_STP_TABLE_HANDLER_PKG AS
2: -- $Header: igistpab.pls 120.11.12000000.8 2007/10/09 06:05:00 gkumares ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
4: l_debug_level number;
5: l_state_level number;
6: l_proc_level number;
7: l_event_level number;

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

559: FETCH C INTO RecAddr;
560: IF (C%NOTFOUND) THEN
561: CLOSE C;
562: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
563: --bug 3199481 fnd logging changes: sdixit
564: IF (l_excep_level >= l_debug_level ) THEN
565: FND_LOG.MESSAGE (l_excep_level ,
566: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row.msg1',
567: FALSE);

Line 565: FND_LOG.MESSAGE (l_excep_level ,

561: CLOSE C;
562: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
563: --bug 3199481 fnd logging changes: sdixit
564: IF (l_excep_level >= l_debug_level ) THEN
565: FND_LOG.MESSAGE (l_excep_level ,
566: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row.msg1',
567: FALSE);
568: END IF;
569: APP_EXCEPTION.RAISE_EXCEPTION;

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

574: FETCH C1 INTO RecAddr1;
575: IF (C1%NOTFOUND) THEN
576: CLOSE C1;
577: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
578: --bug 3199481 fnd logging changes: sdixit
579: IF (l_excep_level >= l_debug_level ) THEN
580: FND_LOG.MESSAGE (l_excep_level ,
581: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row.msg2',
582: FALSE);

Line 580: FND_LOG.MESSAGE (l_excep_level ,

576: CLOSE C1;
577: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
578: --bug 3199481 fnd logging changes: sdixit
579: IF (l_excep_level >= l_debug_level ) THEN
580: FND_LOG.MESSAGE (l_excep_level ,
581: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row.msg2',
582: FALSE);
583: END IF;
584: APP_EXCEPTION.RAISE_EXCEPTION;

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

648: return;
649: ELSE
650:
651: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
652: --bug 3199481 fnd logging changes: sdixit
653: IF (l_excep_level >= l_debug_level ) THEN
654: FND_LOG.MESSAGE (l_excep_level ,
655: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row',
656: FALSE);

Line 654: FND_LOG.MESSAGE (l_excep_level ,

650:
651: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
652: --bug 3199481 fnd logging changes: sdixit
653: IF (l_excep_level >= l_debug_level ) THEN
654: FND_LOG.MESSAGE (l_excep_level ,
655: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Address_Lock_Row',
656: FALSE);
657: END IF;
658: APP_EXCEPTION.Raise_Exception;

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

1061: FETCH C INTO RecSite;
1062: IF (C%NOTFOUND) THEN
1063: CLOSE C;
1064: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1065: --bug 3199481 fnd logging changes: sdixit
1066: IF (l_excep_level >= l_debug_level ) THEN
1067: FND_LOG.MESSAGE (l_excep_level ,
1068: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Site_Lock_Row',FALSE);
1069: END IF;

Line 1067: FND_LOG.MESSAGE (l_excep_level ,

1063: CLOSE C;
1064: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1065: --bug 3199481 fnd logging changes: sdixit
1066: IF (l_excep_level >= l_debug_level ) THEN
1067: FND_LOG.MESSAGE (l_excep_level ,
1068: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Site_Lock_Row',FALSE);
1069: END IF;
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071: END IF;

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

1130: ) THEN
1131: return;
1132: ELSE
1133: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1134: --bug 3199481 fnd logging changes: sdixit
1135: IF (l_excep_level >= l_debug_level ) THEN
1136: FND_LOG.MESSAGE (l_excep_level ,
1137: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Site_Lock_Row',
1138: FALSE);

Line 1136: FND_LOG.MESSAGE (l_excep_level ,

1132: ELSE
1133: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1134: --bug 3199481 fnd logging changes: sdixit
1135: IF (l_excep_level >= l_debug_level ) THEN
1136: FND_LOG.MESSAGE (l_excep_level ,
1137: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Site_Lock_Row',
1138: FALSE);
1139: END IF;
1140: APP_EXCEPTION.Raise_Exception;

Line 1206: --fnd_log.string(1,'IGI_STP','In Customer Insert');

1202:
1203: l_gen_cust_num varchar2(1);
1204: l_profile_value varchar2(100); -- For capturing the value returned by fnd_profile.get
1205: BEGIN
1206: --fnd_log.string(1,'IGI_STP','In Customer Insert');
1207:
1208: l_party_rec.party_id := X_party_id;
1209:
1210:

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

1501: FETCH C INTO RecCust;
1502: IF (C%NOTFOUND) THEN
1503: CLOSE C;
1504: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1505: --bug 3199481 fnd logging changes: sdixit
1506: IF (l_excep_level >= l_debug_level ) THEN
1507: FND_LOG.MESSAGE (l_excep_level ,
1508: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1509: FALSE);

Line 1507: FND_LOG.MESSAGE (l_excep_level ,

1503: CLOSE C;
1504: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1505: --bug 3199481 fnd logging changes: sdixit
1506: IF (l_excep_level >= l_debug_level ) THEN
1507: FND_LOG.MESSAGE (l_excep_level ,
1508: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1509: FALSE);
1510: END IF;
1511: APP_EXCEPTION.RAISE_EXCEPTION;

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

1516: FETCH C1 INTO RecCust1;
1517: IF (C1%NOTFOUND) THEN
1518: CLOSE C1;
1519: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1520: --bug 3199481 fnd logging changes: sdixit
1521: IF (l_excep_level >= l_debug_level ) THEN
1522: FND_LOG.MESSAGE (l_excep_level ,
1523: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1524: FALSE);

Line 1522: FND_LOG.MESSAGE (l_excep_level ,

1518: CLOSE C1;
1519: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1520: --bug 3199481 fnd logging changes: sdixit
1521: IF (l_excep_level >= l_debug_level ) THEN
1522: FND_LOG.MESSAGE (l_excep_level ,
1523: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1524: FALSE);
1525: END IF;
1526: APP_EXCEPTION.RAISE_EXCEPTION;

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

1557: return;
1558: ELSE
1559:
1560: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1561: --bug 3199481 fnd logging changes: sdixit
1562: IF (l_excep_level >= l_debug_level ) THEN
1563: FND_LOG.MESSAGE (l_excep_level ,
1564: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1565: FALSE);

Line 1563: FND_LOG.MESSAGE (l_excep_level ,

1559:
1560: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1561: --bug 3199481 fnd logging changes: sdixit
1562: IF (l_excep_level >= l_debug_level ) THEN
1563: FND_LOG.MESSAGE (l_excep_level ,
1564: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Customer_Lock_Row',
1565: FALSE);
1566: END IF;
1567: APP_EXCEPTION.Raise_Exception;

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

1874: FETCH C INTO RecSupp;
1875: IF (C%NOTFOUND) THEN
1876: CLOSE C;
1877: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1878: --bug 3199481 fnd logging changes: sdixit
1879: IF (l_excep_level >= l_debug_level ) THEN
1880: FND_LOG.MESSAGE (l_excep_level ,
1881: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row.msg1',
1882: FALSE);

Line 1880: FND_LOG.MESSAGE (l_excep_level ,

1876: CLOSE C;
1877: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1878: --bug 3199481 fnd logging changes: sdixit
1879: IF (l_excep_level >= l_debug_level ) THEN
1880: FND_LOG.MESSAGE (l_excep_level ,
1881: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row.msg1',
1882: FALSE);
1883: END IF;
1884: APP_EXCEPTION.RAISE_EXCEPTION;

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

1888: FETCH C1 INTO RecSupp1;
1889: IF (C1%NOTFOUND) THEN
1890: CLOSE C1;
1891: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1892: --bug 3199481 fnd logging changes: sdixit
1893: IF (l_excep_level >= l_debug_level ) THEN
1894: FND_LOG.MESSAGE (l_excep_level ,
1895: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row.msg2',
1896: FALSE);

Line 1894: FND_LOG.MESSAGE (l_excep_level ,

1890: CLOSE C1;
1891: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1892: --bug 3199481 fnd logging changes: sdixit
1893: IF (l_excep_level >= l_debug_level ) THEN
1894: FND_LOG.MESSAGE (l_excep_level ,
1895: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row.msg2',
1896: FALSE);
1897: END IF;
1898: APP_EXCEPTION.RAISE_EXCEPTION;

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

1925: ) THEN
1926: return;
1927: ELSE
1928: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1929: --bug 3199481 fnd logging changes: sdixit
1930: IF (l_excep_level >= l_debug_level ) THEN
1931: FND_LOG.MESSAGE (l_excep_level ,
1932: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row',
1933: FALSE);

Line 1931: FND_LOG.MESSAGE (l_excep_level ,

1927: ELSE
1928: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1929: --bug 3199481 fnd logging changes: sdixit
1930: IF (l_excep_level >= l_debug_level ) THEN
1931: FND_LOG.MESSAGE (l_excep_level ,
1932: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Supplier_Lock_Row',
1933: FALSE);
1934: END IF;
1935: APP_EXCEPTION.Raise_Exception;

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

1991: FETCH C INTO Recinfo;
1992: IF (C%NOTFOUND) THEN
1993: CLOSE C;
1994: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1995: --bug 3199481 fnd logging changes: sdixit
1996: IF (l_excep_level >= l_debug_level ) THEN
1997: FND_LOG.MESSAGE (l_excep_level ,
1998: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Package_Lock_Row',
1999: FALSE);

Line 1997: FND_LOG.MESSAGE (l_excep_level ,

1993: CLOSE C;
1994: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1995: --bug 3199481 fnd logging changes: sdixit
1996: IF (l_excep_level >= l_debug_level ) THEN
1997: FND_LOG.MESSAGE (l_excep_level ,
1998: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Package_Lock_Row',
1999: FALSE);
2000: END IF;
2001: APP_EXCEPTION.RAISE_EXCEPTION;

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

2035: )then
2036: return;
2037: ELSE
2038: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2039: --bug 3199481 fnd logging changes: sdixit
2040: IF (l_excep_level >= l_debug_level ) THEN
2041: FND_LOG.MESSAGE (l_excep_level ,
2042: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Package_Lock_Row',
2043: FALSE);

Line 2041: FND_LOG.MESSAGE (l_excep_level ,

2037: ELSE
2038: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
2039: --bug 3199481 fnd logging changes: sdixit
2040: IF (l_excep_level >= l_debug_level ) THEN
2041: FND_LOG.MESSAGE (l_excep_level ,
2042: 'igi.pls.igistpab.IGI_STP_TABLE_HANDLER_PKG.Package_Lock_Row',
2043: FALSE);
2044: END IF;
2045: APP_EXCEPTION.Raise_Exception;

Line 2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2047:
2048: END Package_Lock_Row;
2049: BEGIN
2050: -- Bug 3902175 GSCC warnings fixed
2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

Line 2052: l_state_level := FND_LOG.LEVEL_STATEMENT;

2048: END Package_Lock_Row;
2049: BEGIN
2050: -- Bug 3902175 GSCC warnings fixed
2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;

Line 2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;

2049: BEGIN
2050: -- Bug 3902175 GSCC warnings fixed
2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;
2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

Line 2054: l_event_level := FND_LOG.LEVEL_EVENT;

2050: -- Bug 3902175 GSCC warnings fixed
2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;
2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
2058:

Line 2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

2051: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;
2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
2058:
2059: END IGI_STP_TABLE_HANDLER_PKG;

Line 2056: l_error_level := FND_LOG.LEVEL_ERROR;

2052: l_state_level := FND_LOG.LEVEL_STATEMENT;
2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;
2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
2058:
2059: END IGI_STP_TABLE_HANDLER_PKG;

Line 2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

2053: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
2054: l_event_level := FND_LOG.LEVEL_EVENT;
2055: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
2056: l_error_level := FND_LOG.LEVEL_ERROR;
2057: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
2058:
2059: END IGI_STP_TABLE_HANDLER_PKG;