285: wf_core.context(G_PKG_NAME, l_api_name,
286: itemtype, itemkey, to_char(actid), funcmode);
287: -- Bug 3199488
288: IF ( g_unexp_level >= g_debug_level ) THEN
289: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
290: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
291: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
292: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
293: END IF;
286: itemtype, itemkey, to_char(actid), funcmode);
287: -- Bug 3199488
288: IF ( g_unexp_level >= g_debug_level ) THEN
289: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
290: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
291: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
292: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
293: END IF;
294: -- Bug 3199488
287: -- Bug 3199488
288: IF ( g_unexp_level >= g_debug_level ) THEN
289: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
290: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
291: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
292: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
293: END IF;
294: -- Bug 3199488
295: RAISE ;
413: wf_core.context(G_PKG_NAME, l_api_name,
414: itemtype, itemkey, to_char(actid), funcmode);
415: -- Bug 3199488
416: IF ( g_unexp_level >= g_debug_level ) THEN
417: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
418: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
419: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
420: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
421: END IF;
414: itemtype, itemkey, to_char(actid), funcmode);
415: -- Bug 3199488
416: IF ( g_unexp_level >= g_debug_level ) THEN
417: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
418: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
419: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
420: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
421: END IF;
422: -- Bug 3199488
415: -- Bug 3199488
416: IF ( g_unexp_level >= g_debug_level ) THEN
417: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
418: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
419: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
420: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
421: END IF;
422: -- Bug 3199488
423: RAISE ;
508: wf_core.context(G_PKG_NAME, l_api_name,
509: itemtype, itemkey, to_char(actid), funcmode);
510: -- Bug 3199488
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
509: itemtype, itemkey, to_char(actid), funcmode);
510: -- Bug 3199488
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
517: -- Bug 3199488
510: -- Bug 3199488
511: IF ( g_unexp_level >= g_debug_level ) THEN
512: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
513: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
514: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
515: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
516: END IF;
517: -- Bug 3199488
518: RAISE ;
606: wf_core.context(G_PKG_NAME, l_api_name,
607: itemtype, itemkey, to_char(actid), funcmode);
608: -- Bug 3199488
609: IF ( g_unexp_level >= g_debug_level ) THEN
610: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
614: END IF;
607: itemtype, itemkey, to_char(actid), funcmode);
608: -- Bug 3199488
609: IF ( g_unexp_level >= g_debug_level ) THEN
610: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
614: END IF;
615: -- Bug 3199488
608: -- Bug 3199488
609: IF ( g_unexp_level >= g_debug_level ) THEN
610: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
614: END IF;
615: -- Bug 3199488
616: RAISE ;
704: wf_core.context(G_PKG_NAME, l_api_name,
705: itemtype, itemkey, to_char(actid), funcmode);
706: -- Bug 3199488
707: IF ( g_unexp_level >= g_debug_level ) THEN
708: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
709: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
710: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
711: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
712: END IF;
705: itemtype, itemkey, to_char(actid), funcmode);
706: -- Bug 3199488
707: IF ( g_unexp_level >= g_debug_level ) THEN
708: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
709: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
710: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
711: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
712: END IF;
713: -- Bug 3199488
706: -- Bug 3199488
707: IF ( g_unexp_level >= g_debug_level ) THEN
708: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
709: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
710: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
711: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
712: END IF;
713: -- Bug 3199488
714: RAISE ;
871: wf_core.context(G_PKG_NAME, l_api_name,
872: itemtype, itemkey, to_char(actid), funcmode);
873: -- Bug 3199488
874: IF ( g_unexp_level >= g_debug_level ) THEN
875: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
876: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
877: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
878: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
879: END IF;
872: itemtype, itemkey, to_char(actid), funcmode);
873: -- Bug 3199488
874: IF ( g_unexp_level >= g_debug_level ) THEN
875: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
876: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
877: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
878: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
879: END IF;
880: -- Bug 3199488
873: -- Bug 3199488
874: IF ( g_unexp_level >= g_debug_level ) THEN
875: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
876: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
877: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
878: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
879: END IF;
880: -- Bug 3199488
881: RAISE ;
968: wf_core.context(G_PKG_NAME, l_api_name,
969: itemtype, itemkey, to_char(actid), funcmode);
970: -- Bug 3199488
971: IF ( g_unexp_level >= g_debug_level ) THEN
972: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
973: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
974: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
975: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
976: END IF;
969: itemtype, itemkey, to_char(actid), funcmode);
970: -- Bug 3199488
971: IF ( g_unexp_level >= g_debug_level ) THEN
972: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
973: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
974: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
975: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
976: END IF;
977: -- Bug 3199488
970: -- Bug 3199488
971: IF ( g_unexp_level >= g_debug_level ) THEN
972: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
973: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
974: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
975: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
976: END IF;
977: -- Bug 3199488
978: RAISE ;
1066: wf_core.context(G_PKG_NAME, l_api_name,
1067: itemtype, itemkey, to_char(actid), funcmode);
1068: -- Bug 3199488
1069: IF ( g_unexp_level >= g_debug_level ) THEN
1070: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1071: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1072: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1073: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1074: END IF;
1067: itemtype, itemkey, to_char(actid), funcmode);
1068: -- Bug 3199488
1069: IF ( g_unexp_level >= g_debug_level ) THEN
1070: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1071: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1072: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1073: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1074: END IF;
1075: -- Bug 3199488
1068: -- Bug 3199488
1069: IF ( g_unexp_level >= g_debug_level ) THEN
1070: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1071: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1072: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1073: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1074: END IF;
1075: -- Bug 3199488
1076: RAISE ;
1341: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1342: p_data => x_msg_data );
1343: -- Bug 3199488
1344: IF ( g_unexp_level >= g_debug_level ) THEN
1345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1349: END IF;
1342: p_data => x_msg_data );
1343: -- Bug 3199488
1344: IF ( g_unexp_level >= g_debug_level ) THEN
1345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1349: END IF;
1350: -- Bug 3199488
1343: -- Bug 3199488
1344: IF ( g_unexp_level >= g_debug_level ) THEN
1345: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1346: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1347: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1348: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1349: END IF;
1350: -- Bug 3199488
1351:
1592: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1593: END IF;
1594: -- Bug 3199488
1595: IF ( g_unexp_level >= g_debug_level ) THEN
1596: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1597: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1598: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1599: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1600: END IF;
1593: END IF;
1594: -- Bug 3199488
1595: IF ( g_unexp_level >= g_debug_level ) THEN
1596: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1597: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1598: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1599: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1600: END IF;
1601: -- Bug 3199488
1594: -- Bug 3199488
1595: IF ( g_unexp_level >= g_debug_level ) THEN
1596: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1597: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1598: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1599: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1600: END IF;
1601: -- Bug 3199488
1602:
1703: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1704: END IF;
1705: -- Bug 3199488
1706: IF ( g_unexp_level >= g_debug_level ) THEN
1707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1711: END IF;
1704: END IF;
1705: -- Bug 3199488
1706: IF ( g_unexp_level >= g_debug_level ) THEN
1707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1711: END IF;
1712: -- Bug 3199488
1705: -- Bug 3199488
1706: IF ( g_unexp_level >= g_debug_level ) THEN
1707: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1708: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1709: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1710: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1711: END IF;
1712: -- Bug 3199488
1713:
1820: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1821: END IF;
1822: -- Bug 3199488
1823: IF ( g_unexp_level >= g_debug_level ) THEN
1824: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1825: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1826: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1827: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1828: END IF;
1821: END IF;
1822: -- Bug 3199488
1823: IF ( g_unexp_level >= g_debug_level ) THEN
1824: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1825: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1826: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1827: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1828: END IF;
1829: -- Bug 3199488
1822: -- Bug 3199488
1823: IF ( g_unexp_level >= g_debug_level ) THEN
1824: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1825: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1826: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1827: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1828: END IF;
1829: -- Bug 3199488
1830:
2076: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2077: END IF;
2078: -- Bug 3199488
2079: IF ( g_unexp_level >= g_debug_level ) THEN
2080: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2081: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2082: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2083: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2084: END IF;
2077: END IF;
2078: -- Bug 3199488
2079: IF ( g_unexp_level >= g_debug_level ) THEN
2080: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2081: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2082: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2083: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2084: END IF;
2085: -- Bug 3199488
2078: -- Bug 3199488
2079: IF ( g_unexp_level >= g_debug_level ) THEN
2080: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2081: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2082: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2083: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2084: END IF;
2085: -- Bug 3199488
2086:
2163: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2164: END IF;
2165: -- Bug 3199488
2166: IF ( g_unexp_level >= g_debug_level ) THEN
2167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2171: END IF;
2164: END IF;
2165: -- Bug 3199488
2166: IF ( g_unexp_level >= g_debug_level ) THEN
2167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2171: END IF;
2172: -- Bug 3199488
2165: -- Bug 3199488
2166: IF ( g_unexp_level >= g_debug_level ) THEN
2167: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2168: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2169: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2170: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2171: END IF;
2172: -- Bug 3199488
2173:
2240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2241: END IF;
2242: -- Bug 3199488
2243: IF ( g_unexp_level >= g_debug_level ) THEN
2244: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2245: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2246: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2247: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2248: END IF;
2241: END IF;
2242: -- Bug 3199488
2243: IF ( g_unexp_level >= g_debug_level ) THEN
2244: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2245: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2246: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2247: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2248: END IF;
2249: -- Bug 3199488
2242: -- Bug 3199488
2243: IF ( g_unexp_level >= g_debug_level ) THEN
2244: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2245: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2246: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2247: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2248: END IF;
2249: -- Bug 3199488
2250:
2354: END IF;
2355:
2356: -- Bug 3199488
2357: IF ( g_unexp_level >= g_debug_level ) THEN
2358: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2359: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2360: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2361: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2362: END IF;
2355:
2356: -- Bug 3199488
2357: IF ( g_unexp_level >= g_debug_level ) THEN
2358: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2359: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2360: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2361: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2362: END IF;
2363: -- Bug 3199488
2356: -- Bug 3199488
2357: IF ( g_unexp_level >= g_debug_level ) THEN
2358: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2359: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2360: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2361: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2362: END IF;
2363: -- Bug 3199488
2364:
2470: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2471: END IF;
2472: -- Bug 3199488
2473: IF ( g_unexp_level >= g_debug_level ) THEN
2474: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2475: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2476: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2477: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2478: END IF;
2471: END IF;
2472: -- Bug 3199488
2473: IF ( g_unexp_level >= g_debug_level ) THEN
2474: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2475: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2476: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2477: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2478: END IF;
2479: -- Bug 3199488
2472: -- Bug 3199488
2473: IF ( g_unexp_level >= g_debug_level ) THEN
2474: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2475: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2476: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2477: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2478: END IF;
2479: -- Bug 3199488
2480:
2559: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2560: END IF;
2561: -- Bug 3199488
2562: IF ( g_unexp_level >= g_debug_level ) THEN
2563: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2564: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2565: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2566: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2567: END IF;
2560: END IF;
2561: -- Bug 3199488
2562: IF ( g_unexp_level >= g_debug_level ) THEN
2563: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2564: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2565: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2566: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2567: END IF;
2568: -- Bug 3199488
2561: -- Bug 3199488
2562: IF ( g_unexp_level >= g_debug_level ) THEN
2563: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2564: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2565: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2566: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2567: END IF;
2568: -- Bug 3199488
2569:
2671: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2672: END IF;
2673: -- Bug 3199488
2674: IF ( g_unexp_level >= g_debug_level ) THEN
2675: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2676: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2677: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2678: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2679: END IF;
2672: END IF;
2673: -- Bug 3199488
2674: IF ( g_unexp_level >= g_debug_level ) THEN
2675: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2676: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2677: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2678: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2679: END IF;
2680: -- Bug 3199488
2673: -- Bug 3199488
2674: IF ( g_unexp_level >= g_debug_level ) THEN
2675: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2676: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2677: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2678: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2679: END IF;
2680: -- Bug 3199488
2681:
2789: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2790: END IF;
2791: -- Bug 3199488
2792: IF ( g_unexp_level >= g_debug_level ) THEN
2793: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2794: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2795: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2796: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2797: END IF;
2790: END IF;
2791: -- Bug 3199488
2792: IF ( g_unexp_level >= g_debug_level ) THEN
2793: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2794: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2795: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2796: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2797: END IF;
2798: -- Bug 3199488
2791: -- Bug 3199488
2792: IF ( g_unexp_level >= g_debug_level ) THEN
2793: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2794: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2795: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2796: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2797: END IF;
2798: -- Bug 3199488
2799:
3030: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3031: END IF;
3032: -- Bug 3199488
3033: IF ( g_unexp_level >= g_debug_level ) THEN
3034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3038: END IF;
3031: END IF;
3032: -- Bug 3199488
3033: IF ( g_unexp_level >= g_debug_level ) THEN
3034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3038: END IF;
3039: -- Bug 3199488
3032: -- Bug 3199488
3033: IF ( g_unexp_level >= g_debug_level ) THEN
3034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3038: END IF;
3039: -- Bug 3199488
3040:
3743: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3744: END IF;
3745: -- Bug 3199488
3746: IF ( g_unexp_level >= g_debug_level ) THEN
3747: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3748: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3749: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3750: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3751: END IF;
3744: END IF;
3745: -- Bug 3199488
3746: IF ( g_unexp_level >= g_debug_level ) THEN
3747: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3748: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3749: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3750: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3751: END IF;
3752: -- Bug 3199488
3745: -- Bug 3199488
3746: IF ( g_unexp_level >= g_debug_level ) THEN
3747: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3748: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3749: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3750: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3751: END IF;
3752: -- Bug 3199488
3753:
4030: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
4031: END IF;
4032: -- Bug 3199488
4033: IF ( g_unexp_level >= g_debug_level ) THEN
4034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4038: END IF;
4031: END IF;
4032: -- Bug 3199488
4033: IF ( g_unexp_level >= g_debug_level ) THEN
4034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4038: END IF;
4039: -- Bug 3199488
4032: -- Bug 3199488
4033: IF ( g_unexp_level >= g_debug_level ) THEN
4034: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
4035: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
4036: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
4037: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
4038: END IF;
4039: -- Bug 3199488
4040: