DBA Data[Home] [Help]

APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on FND_LOG

Line 147: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

143: l_api_name,
144: G_PKG_NAME )) THEN
145: g_debug_msg := 'CC Open API Main Incorrect Version...';
146: IF(g_excep_level >= g_debug_level) THEN
147: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
148: END IF;
149: -- Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
150: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
151: END IF;

Line 194: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

190: WHEN NO_DATA_FOUND THEN
191: g_debug_msg := 'CC Open API Main Unable to get functional currency...';
192: -- Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
193: IF(g_excep_level >= g_debug_level) THEN
194: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
195: END IF;
196:
197: -- Bug 3199488
198: IF ( g_excep_level >= g_debug_level ) THEN

Line 199: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');

195: END IF;
196:
197: -- Bug 3199488
198: IF ( g_excep_level >= g_debug_level ) THEN
199: FND_LOG.STRING (g_excep_level,l_full_path,'NO_DATA_FOUND Exception Raised');
200: END IF;
201: -- Bug 3199488
202: NULL;
203: END;

Line 240: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

236: IF g_debug_mode = 'Y'
237: THEN
238: g_debug_msg := 'CC Open API Main Header Validation Not Successful...';
239: IF(g_excep_level >= g_debug_level) THEN
240: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
241: END IF;
242: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
243: END IF;
244:

Line 343: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

339: x_msg_count := 1;
340: g_debug_msg := 'CC Open API Main Header Record Insert Row Not Successful...'||l_msg_data;
341: -- Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
342: IF(g_excep_level >= g_debug_level) THEN
343: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
344: END IF;
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346:
347: ELSE

Line 379: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

375: x_msg_count := 1;
376:
377: -- Bug 3199488
378: IF ( g_excep_level >= g_debug_level ) THEN
379: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
380: END IF;
381: -- Bug 3199488
382: RETURN;
383:

Line 394: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

390: IF ( g_unexp_level >= g_debug_level ) THEN
391: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
392: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
393: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
394: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
395: END IF;
396: -- Bug 3199488
397: RETURN;
398:

Line 549: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

545: IF g_debug_mode = 'Y'
546: THEN
547: g_debug_msg := 'CC Open API Validate Org Id is Not Found...';
548: IF(g_excep_level >= g_debug_level) THEN
549: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
550: END IF;
551: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
552: END IF;
553:

Line 604: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

600: IF g_debug_mode = 'Y'
601: THEN
602: g_debug_msg := 'CC Open API Validate SOB Id is Not Found...';
603: IF(g_excep_level >= g_debug_level) THEN
604: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
605: END IF;
606: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
607: END IF;
608: END IF;

Line 632: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

628: IF g_debug_mode = 'Y'
629: THEN
630: g_debug_msg := 'CC Open API Validate Set of books ID and Org ID Combo Failed...';
631: IF(g_excep_level >= g_debug_level) THEN
632: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
633: END IF;
634: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
635: END IF;
636: END IF;

Line 676: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

672: IF g_debug_mode = 'Y'
673: THEN
674: g_debug_msg := 'CC Open API Validate Numbering method not found...';
675: IF(g_excep_level >= g_debug_level) THEN
676: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
677: END IF;
678: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
679: END IF;
680: -- Bug 3199488

Line 685: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

681: IF ( g_unexp_level >= g_debug_level ) THEN
682: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
683: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
684: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
685: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
686: END IF;
687: -- Bug 3199488
688: END;
689:

Line 701: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

697: IF g_debug_mode = 'Y'
698: THEN
699: g_debug_msg := 'CC Open API Validate CC Reference Number failure is NULL...';
700: IF(g_excep_level >= g_debug_level) THEN
701: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
702: END IF;
703: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
704: END IF;
705: END IF;

Line 723: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

719: IF g_debug_mode = 'Y'
720: THEN
721: g_debug_msg := 'CC Open API Validate CC Number failure with auto numbering on...';
722: IF(g_excep_level >= g_debug_level) THEN
723: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
724: END IF;
725: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
726: END IF;
727:

Line 756: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

752: IF g_debug_mode = 'Y'
753: THEN
754: g_debug_msg := 'CC Open API Validate Numbering method not found...';
755: IF(g_excep_level >= g_debug_level) THEN
756: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
757: END IF;
758: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
759: END IF;
760:

Line 773: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

769: IF g_debug_mode = 'Y'
770: THEN
771: g_debug_msg := 'CC Open API Validate CC Number failure with Manual numbering on and CC num NULL...';
772: IF(g_excep_level >= g_debug_level) THEN
773: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
774: END IF;
775: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
776: END IF;
777:

Line 813: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

809: IF g_debug_mode = 'Y'
810: THEN
811: g_debug_msg := 'CC Open API Validate CC Number failure with auto numbering on...';
812: IF(g_excep_level >= g_debug_level) THEN
813: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
814: END IF;
815: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
816: END IF;
817:

Line 839: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

835: l_error_count := l_error_count + 1;
836: g_debug_msg := 'CC Open API Validate CC Number Unable to Validate...';
837: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
838: IF(g_excep_level >= g_debug_level) THEN
839: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
840: END IF;
841: -- Bug 3199488
842: IF ( g_unexp_level >= g_debug_level ) THEN
843: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 846: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

842: IF ( g_unexp_level >= g_debug_level ) THEN
843: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
844: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
845: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
846: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
847: END IF;
848: -- Bug 3199488
849:
850:

Line 883: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

879: l_error_count := l_error_count + 1;
880: g_debug_msg := 'CC Open API Validate CC Reference Number Unable to Validate...';
881: IF g_debug_mode = 'Y' THEN
882: IF(g_excep_level >= g_debug_level) THEN
883: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
884: END IF;
885: END IF;
886: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
887: -- Bug 3199488

Line 892: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

888: IF ( g_unexp_level >= g_debug_level ) THEN
889: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
890: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
891: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
892: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
893: END IF;
894: -- Bug 3199488
895: END;
896:

Line 925: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

921: IF g_debug_mode = 'Y'
922: THEN
923: g_debug_msg := 'CC Open API Validate Parent Header Id Null...';
924: IF(g_excep_level >= g_debug_level) THEN
925: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
926: END IF;
927: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
928: END IF;
929:

Line 944: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

940: IF g_debug_mode = 'Y'
941: THEN
942: g_debug_msg := 'CC Open API Validate Parent Header State and Status invalid...';
943: IF(g_excep_level >= g_debug_level) THEN
944: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
945: END IF;
946: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
947: END IF;
948: END IF;

Line 975: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

971: IF g_debug_mode = 'Y'
972: THEN
973: g_debug_msg := 'CC Open API Validate Invalid Cover Details...';
974: IF(g_excep_level >= g_debug_level) THEN
975: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
976: END IF;
977: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
978: END IF;
979: END;

Line 993: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

989: IF g_debug_mode = 'Y'
990: THEN
991: g_debug_msg := 'CC Open API Validate Parent Header Id Must be Null...';
992: IF(g_excep_level >= g_debug_level) THEN
993: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
994: END IF;
995: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
996: END IF;
997: END IF;

Line 1022: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1018: IF g_debug_mode = 'Y'
1019: THEN
1020: g_debug_msg := 'CC Open API Validate Check Budgetary Control Not Successful...';
1021: IF(g_excep_level >= g_debug_level) THEN
1022: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1023: END IF;
1024: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1025: END IF;
1026: END IF;

Line 1061: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1057: IF g_debug_mode = 'Y'
1058: THEN
1059: g_debug_msg := 'CC Open API Validate CC for start date Not Successful...';
1060: IF(g_excep_level >= g_debug_level) THEN
1061: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1062: END IF;
1063: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1064: END IF;
1065: END IF;

Line 1100: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1096: IF g_debug_mode = 'Y'
1097: THEN
1098: g_debug_msg := 'CC Open API Validate CC for end date Not Successful...';
1099: IF(g_excep_level >= g_debug_level) THEN
1100: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1101: END IF;
1102: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1103: END IF;
1104: END IF;

Line 1133: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1129: IF g_debug_mode = 'Y'
1130: THEN
1131: g_debug_msg := 'CC Open API Validate Vendor Info Not Successful...';
1132: IF(g_excep_level >= g_debug_level) THEN
1133: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1134: END IF;
1135: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1136: END IF;
1137: END;

Line 1173: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1169: IF g_debug_mode = 'Y'
1170: THEN
1171: g_debug_msg := 'CC Open API Validate Vendor Site Info Not Successful...';
1172: IF(g_excep_level >= g_debug_level) THEN
1173: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1174: END IF;
1175: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1176: END IF;
1177: END;

Line 1203: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1199: IF g_debug_mode = 'Y'
1200: THEN
1201: g_debug_msg := 'CC Open API Validate Vendor Contact and Vendor Validation Not Successful...';
1202: IF(g_excep_level >= g_debug_level) THEN
1203: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1204: END IF;
1205: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1206: END IF;
1207:

Line 1229: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1225: IF g_debug_mode = 'Y'
1226: THEN
1227: g_debug_msg := 'CC Open API Validate Vendor Contact Not Successful...';
1228: IF(g_excep_level >= g_debug_level) THEN
1229: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1230: END IF;
1231: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1232: END IF;
1233: END;

Line 1261: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1257: IF g_debug_mode = 'Y'
1258: THEN
1259: g_debug_msg := 'CC Open API Validate Term Not Successful...';
1260: IF(g_excep_level >= g_debug_level) THEN
1261: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1262: END IF;
1263: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1264: END IF;
1265: END;

Line 1292: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1288: IF g_debug_mode = 'Y'
1289: THEN
1290: g_debug_msg := 'CC Open API Validate Vendor and Location Valdiation Not Successful...';
1291: IF(g_excep_level >= g_debug_level) THEN
1292: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1293: END IF;
1294: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1295: END IF;
1296: ELSE

Line 1316: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1312: IF g_debug_mode = 'Y'
1313: THEN
1314: g_debug_msg := 'CC Open API Validate Location Not Successful...';
1315: IF(g_excep_level >= g_debug_level) THEN
1316: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1317: END IF;
1318: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1319: END IF;
1320: END;

Line 1382: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1378: IF g_debug_mode = 'Y'
1379: THEN
1380: g_debug_msg := 'CC Open API Validate Owner Not Successful...';
1381: IF(g_excep_level >= g_debug_level) THEN
1382: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1383: END IF;
1384: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1385: END IF;
1386: END;

Line 1439: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1435: IF g_debug_mode = 'Y'
1436: THEN
1437: g_debug_msg := 'CC Open API Validate Preparer Not Successful...';
1438: IF(g_excep_level >= g_debug_level) THEN
1439: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1440: END IF;
1441: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1442: END IF;
1443: END;

Line 1484: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1480: THEN
1481: g_debug_msg := 'CC Open API Validate Currency cannot be null...';
1482: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1483: IF(g_excep_level >= g_debug_level) THEN
1484: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1485: END IF;
1486: END IF;
1487: ELSE
1488: x_currency_code := p_func_currency_code;

Line 1519: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1515: IF g_debug_mode = 'Y'
1516: THEN
1517: g_debug_msg := 'CC Open API Validate Currency Invalid...';
1518: IF(g_excep_level >= g_debug_level) THEN
1519: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1520: END IF;
1521: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1522: END IF;
1523: END;

Line 1560: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1556: IF g_debug_mode = 'Y'
1557: THEN
1558: g_debug_msg := 'CC Open API Validate No default rate type defined...';
1559: IF(g_excep_level >= g_debug_level) THEN
1560: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1561: END IF;
1562: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1563: END IF;
1564: -- Bug 3199488

Line 1569: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

1565: IF ( g_unexp_level >= g_debug_level ) THEN
1566: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1567: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1568: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1569: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1570: END IF;
1571: -- Bug 3199488
1572:
1573: END;

Line 1590: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1586: IF g_debug_mode = 'Y'
1587: THEN
1588: g_debug_msg := 'CC Open API Validate Invalid Currency Code defined...';
1589: IF(g_excep_level >= g_debug_level) THEN
1590: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1591: END IF;
1592: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1593: END IF;
1594: -- Bug 3199488

Line 1599: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

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:
1603: END;

Line 1620: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1616: IF g_debug_mode = 'Y'
1617: THEN
1618: g_debug_msg := 'CC Open API Validate Cover and Release currency does not match...';
1619: IF(g_excep_level >= g_debug_level) THEN
1620: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1621: END IF;
1622: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1623: END IF;
1624: END IF;

Line 1679: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1675: IF g_debug_mode = 'Y'
1676: THEN
1677: g_debug_msg := 'CC Open API Validate Rate and Date required...';
1678: IF(g_excep_level >= g_debug_level) THEN
1679: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1680: END IF;
1681: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1682: END IF;
1683:

Line 1716: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1712: IF g_debug_mode = 'Y'
1713: THEN
1714: g_debug_msg := 'CC Open API Validate Get RATE is could not be obtained...';
1715: IF(g_excep_level >= g_debug_level) THEN
1716: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1717: END IF;
1718: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1719: END IF;
1720: -- Bug 3199488

Line 1725: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

1721: IF ( g_unexp_level >= g_debug_level ) THEN
1722: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1723: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1724: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1725: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1726: END IF;
1727: -- Bug 3199488
1728:
1729: END;

Line 1748: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1744: IF g_debug_mode = 'Y'
1745: THEN
1746: g_debug_msg := 'CC Open API Validate Rate NOT required...';
1747: IF(g_excep_level >= g_debug_level) THEN
1748: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1749: END IF;
1750: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1751: END IF;
1752:

Line 1771: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1767: IF g_debug_mode = 'Y'
1768: THEN
1769: g_debug_msg := 'CC Open API Validate Conversion type, rate, date not required...';
1770: IF(g_excep_level >= g_debug_level) THEN
1771: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1772: END IF;
1773: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1774: END IF;
1775: END IF;

Line 1801: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1797: IF g_debug_mode = 'Y'
1798: THEN
1799: g_debug_msg := 'CC Open API Validate Invalid Created By...';
1800: IF(g_excep_level >= g_debug_level) THEN
1801: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1802: END IF;
1803: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1804: END IF;
1805: END;

Line 1817: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1813: IF g_debug_mode = 'Y'
1814: THEN
1815: g_debug_msg := 'CC Open API Validate Invalid Created By is NULL...';
1816: IF(g_excep_level >= g_debug_level) THEN
1817: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1818: END IF;
1819: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1820: END IF;
1821:

Line 1846: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1842: IF g_debug_mode = 'Y'
1843: THEN
1844: g_debug_msg := 'CC Open API Validate Invalid Last Updated By...';
1845: IF(g_excep_level >= g_debug_level) THEN
1846: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1847: END IF;
1848: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1849: END IF;
1850: END;

Line 1861: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1857: IF g_debug_mode = 'Y'
1858: THEN
1859: g_debug_msg := 'CC Open API Validate Invalid Last Updated By is NULL...';
1860: IF(g_excep_level >= g_debug_level) THEN
1861: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1862: END IF;
1863: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1864: END IF;
1865:

Line 1876: FROM fnd_logins

1872:
1873: BEGIN
1874: SELECT login_id
1875: INTO l_login_id
1876: FROM fnd_logins
1877: WHERE login_id = p_cc_header_rec.last_update_login;
1878:
1879: EXCEPTION
1880:

Line 1890: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1886: IF g_debug_mode = 'Y'
1887: THEN
1888: g_debug_msg := 'CC Open API Validate Invalid Last Update Login...';
1889: IF(g_excep_level >= g_debug_level) THEN
1890: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1891: END IF;
1892: -- Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1893: END IF;
1894: END;

Line 1906: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

1902: IF g_debug_mode = 'Y'
1903: THEN
1904: g_debug_msg := 'CC Open API Validate Invalid Last Update Login is NULL...';
1905: IF(g_excep_level >= g_debug_level) THEN
1906: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
1907: END IF;
1908: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
1909: END IF;
1910:

Line 1979: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

1975: IF ( g_unexp_level >= g_debug_level ) THEN
1976: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
1977: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1978: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1979: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
1980: END IF;
1981: -- Bug 3199488
1982: RETURN;
1983:

Line 2019: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

2015: IF ( g_unexp_level >= g_debug_level ) THEN
2016: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
2017: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
2018: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
2019: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
2020: END IF;
2021: -- Bug 3199488
2022: RETURN;
2023:

Line 2159: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2155: THEN
2156: g_debug_msg := 'CC Update APi Incorrect version...';
2157: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2158: IF(g_excep_level >= g_debug_level) THEN
2159: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2160: END IF;
2161: END IF;
2162: raise FND_API.G_EXC_UNEXPECTED_ERROR ;
2163: END IF;

Line 2214: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2210: IF g_debug_mode = 'Y'
2211: THEN
2212: g_debug_msg := 'CC Update API Validate Set of books ID and Org ID Combo Failed...';
2213: IF(g_excep_level >= g_debug_level) THEN
2214: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2215: END IF;
2216: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2217: END IF;
2218: RAISE E_CC_NOT_FOUND;

Line 2239: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2235: IF g_debug_mode = 'Y'
2236: THEN
2237: g_debug_msg := 'CC Update APi CC Found or not...'||x_msg_data;
2238: IF(g_excep_level >= g_debug_level) THEN
2239: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2240: END IF;
2241: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2242: END IF;
2243: RAISE E_CC_NOT_FOUND;

Line 2264: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2260: IF g_debug_mode = 'Y'
2261: THEN
2262: g_debug_msg := 'CC Update APi CC Found or not...'||x_msg_data;
2263: IF(g_excep_level >= g_debug_level) THEN
2264: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2265: END IF;
2266: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2267: END IF;
2268: RAISE E_CC_NOT_FOUND;

Line 2286: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2282: IF g_debug_mode = 'Y'
2283: THEN
2284: g_debug_msg := 'CC Update APi CC Found or not approved / confirmed...'||x_msg_data;
2285: IF(g_excep_level >= g_debug_level) THEN
2286: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2287: END IF;
2288: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2289: END IF;
2290: RAISE E_CC_NOT_FOUND;

Line 2303: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2299: IF g_debug_mode = 'Y'
2300: THEN
2301: g_debug_msg := 'CC Update APi Action Not Allowed...'||x_msg_data;
2302: IF(g_excep_level >= g_debug_level) THEN
2303: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2304: END IF;
2305: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2306: END IF;
2307: RAISE E_INVALID_ACTION;

Line 2332: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2328: IF g_debug_mode = 'Y'
2329: THEN
2330: g_debug_msg := 'CC Update APi Invalid Action Code...'||x_msg_data;
2331: IF(g_excep_level >= g_debug_level) THEN
2332: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2333: END IF;
2334: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2335: END IF;
2336: RAISE E_INVALID_ACTION;

Line 2347: FROM fnd_logins

2343:
2344: BEGIN
2345: SELECT login_id
2346: INTO l_login_id
2347: FROM fnd_logins
2348: WHERE login_id = l_current_login_id;
2349:
2350: EXCEPTION
2351:

Line 2363: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2359: IF g_debug_mode = 'Y'
2360: THEN
2361: g_debug_msg := 'CC Update API Validate Invalid Last Update Login...';
2362: IF(g_excep_level >= g_debug_level) THEN
2363: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2364: END IF;
2365: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2366: END IF;
2367: RAISE E_CC_NOT_FOUND;

Line 2382: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2378: IF g_debug_mode = 'Y'
2379: THEN
2380: g_debug_msg := 'CC Update API Validate Invalid Last Update Login is NULL...';
2381: IF(g_excep_level >= g_debug_level) THEN
2382: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2383: END IF;
2384: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2385: END IF;
2386: RAISE E_CC_NOT_FOUND;

Line 2414: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2410: IF g_debug_mode = 'Y'
2411: THEN
2412: g_debug_msg := 'CC Update API Validate Invalid Last Updated By...';
2413: IF(g_excep_level >= g_debug_level) THEN
2414: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2415: END IF;
2416: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2417: END IF;
2418: RAISE E_CC_NOT_FOUND;

Line 2432: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2428: IF g_debug_mode = 'Y'
2429: THEN
2430: g_debug_msg := 'CC Update API Validate Invalid Last Updated By is NULL...';
2431: IF(g_excep_level >= g_debug_level) THEN
2432: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2433: END IF;
2434: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2435: END IF;
2436: RAISE E_CC_NOT_FOUND;

Line 2461: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2457: IF g_debug_mode = 'Y'
2458: THEN
2459: g_debug_msg := 'CC Update APi Invalid Control Status ...'||x_msg_data;
2460: IF(g_excep_level >= g_debug_level) THEN
2461: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2462: END IF;
2463: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2464: END IF;
2465: RAISE E_INVALID_ACTION;

Line 2486: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2482: IF g_debug_mode = 'Y'
2483: THEN
2484: g_debug_msg := 'CC Update APi '||p_action_code||' Action not allowed ...'||x_msg_data;
2485: IF(g_excep_level >= g_debug_level) THEN
2486: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2487: END IF;
2488: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2489: END IF;
2490: RAISE E_INVALID_ACTION;

Line 2508: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2504: IF g_debug_mode = 'Y'
2505: THEN
2506: g_debug_msg := 'CC Update APi '||p_action_code||' Action not allowed ...'||x_msg_data;
2507: IF(g_excep_level >= g_debug_level) THEN
2508: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2509: END IF;
2510: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2511: END IF;
2512: RAISE E_INVALID_ACTION;

Line 2530: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2526: IF g_debug_mode = 'Y'
2527: THEN
2528: g_debug_msg := 'CC Update APi '||p_action_code||' Action not allowed ...'||x_msg_data;
2529: IF(g_excep_level >= g_debug_level) THEN
2530: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2531: END IF;
2532: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2533: END IF;
2534: RAISE E_INVALID_ACTION;

Line 2552: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2548: IF g_debug_mode = 'Y'
2549: THEN
2550: g_debug_msg := 'CC Update APi '||p_action_code||' Action not allowed ...'||x_msg_data;
2551: IF(g_excep_level >= g_debug_level) THEN
2552: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2553: END IF;
2554: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2555: END IF;
2556: RAISE E_INVALID_ACTION;

Line 2587: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2583: IF g_debug_mode = 'Y'
2584: THEN
2585: g_debug_msg := 'CC Update APi Invalid Action Code...'||x_msg_data;
2586: IF(g_excep_level >= g_debug_level) THEN
2587: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2588: END IF;
2589: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2590: END IF;
2591: RAISE E_INVALID_ACTION;

Line 2624: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2620: IF g_debug_mode = 'Y'
2621: THEN
2622: g_debug_msg := 'CC Update APi Check Budgetary Control Not Successful...'||x_msg_data;
2623: IF(g_excep_level >= g_debug_level) THEN
2624: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2625: END IF;
2626: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2627: END IF;
2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2670: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2666: IF g_debug_mode = 'Y'
2667: THEN
2668: g_debug_msg := 'CC Update APi Validate CC Not Successful...'||x_msg_data;
2669: IF(g_excep_level >= g_debug_level) THEN
2670: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2671: END IF;
2672: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2673: END IF;
2674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2708: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2704: IF g_debug_mode = 'Y'
2705: THEN
2706: g_debug_msg := 'CC Update APi Incorrect Update ...';
2707: IF(g_excep_level >= g_debug_level) THEN
2708: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2709: END IF;
2710: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2711: END IF;
2712:

Line 2762: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2758: IF g_debug_mode = 'Y'
2759: THEN
2760: g_debug_msg := 'CC Update APi Action History Insertion Not Successful...'||l_msg_data;
2761: IF(g_excep_level >= g_debug_level) THEN
2762: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2763: END IF;
2764: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2765: END IF;
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2811: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2807: IF g_debug_mode = 'Y'
2808: THEN
2809: g_debug_msg := 'CC Update APi Preparer Can Approve Not Successful...'||x_msg_data;
2810: IF(g_excep_level >= g_debug_level) THEN
2811: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2812: END IF;
2813: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2814: END IF;
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2911: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2907: IF g_debug_mode = 'Y'
2908: THEN
2909: g_debug_msg := 'CC Update APi Incorrect Update...'||x_msg_data;
2910: IF(g_excep_level >= g_debug_level) THEN
2911: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2912: END IF;
2913: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2914: END IF;
2915:

Line 2938: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2934: IF g_debug_mode = 'Y'
2935: THEN
2936: g_debug_msg := 'CC Update APi Update PO Approved Flag Not Successful...'||x_msg_data;
2937: IF(g_excep_level >= g_debug_level) THEN
2938: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2939: END IF;
2940: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2941: END IF;
2942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2985: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );

2981: IF g_debug_mode = 'Y'
2982: THEN
2983: g_debug_msg := 'CC Update APi Action History Insertion Not Successful...'||l_msg_data;
2984: IF(g_excep_level >= g_debug_level) THEN
2985: FND_LOG.STRING(g_excep_level, l_full_path,g_debug_msg );
2986: END IF;
2987: --Output_Debug( l_full_path,p_debug_msg => g_debug_msg);
2988: END IF;
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 3048: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

3044: CLOSE c_validate_sob_org_combo;
3045: END IF;
3046: -- Bug 3199488
3047: IF ( g_excep_level >= g_debug_level ) THEN
3048: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
3049: END IF;
3050: -- Bug 3199488
3051: RETURN;
3052:

Line 3072: FND_LOG.STRING (g_excep_level,l_full_path,'E_INVALID_ACTION Exception Raised');

3068: CLOSE c_validate_sob_org_combo;
3069: END IF;
3070: -- Bug 3199488
3071: IF ( g_excep_level >= g_debug_level ) THEN
3072: FND_LOG.STRING (g_excep_level,l_full_path,'E_INVALID_ACTION Exception Raised');
3073: END IF;
3074: -- Bug 3199488
3075: RETURN;
3076:

Line 3096: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND Exception Raised');

3092: CLOSE c_validate_sob_org_combo;
3093: END IF;
3094: -- Bug 3199488
3095: IF ( g_excep_level >= g_debug_level ) THEN
3096: FND_LOG.STRING (g_excep_level,l_full_path,'E_CC_NOT_FOUND Exception Raised');
3097: END IF;
3098: -- Bug 3199488
3099: RETURN;
3100:

Line 3125: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3121: IF ( g_unexp_level >= g_debug_level ) THEN
3122: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3123: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3124: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3125: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3126: END IF;
3127: -- Bug 3199488
3128: RETURN;
3129:

Line 3169: FND_LOG.STRING(g_state_level,p_path, p_debug_msg);

3165: raise FND_API.G_EXC_ERROR;
3166: END IF;
3167: */
3168: IF(g_state_level >= g_debug_level) THEN
3169: FND_LOG.STRING(g_state_level,p_path, p_debug_msg);
3170: END IF;
3171: RETURN;
3172:
3173: -- --------------------------------------------------------------------

Line 3359: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3355: IF ( g_unexp_level >= g_debug_level ) THEN
3356: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3357: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3358: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3359: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3360: END IF;
3361: -- Bug 3199488
3362: RETURN;
3363:

Line 3608: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

3604: IF ( g_unexp_level >= g_debug_level ) THEN
3605: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
3606: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
3607: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
3608: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
3609: END IF;
3610: -- Bug 3199488
3611: RETURN;
3612:

Line 3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3843: --Added by svaithil for GSCC warnings on 20/05/2004
3844: begin
3845: G_PKG_NAME := 'IGC_CC_OPN_UPD_GET_LNK_PUB';
3846: g_debug_msg := NULL;
3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;

Line 3848: g_state_level := FND_LOG.LEVEL_STATEMENT;

3844: begin
3845: G_PKG_NAME := 'IGC_CC_OPN_UPD_GET_LNK_PUB';
3846: g_debug_msg := NULL;
3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;

Line 3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;

3845: G_PKG_NAME := 'IGC_CC_OPN_UPD_GET_LNK_PUB';
3846: g_debug_msg := NULL;
3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;
3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

Line 3850: g_event_level := FND_LOG.LEVEL_EVENT;

3846: g_debug_msg := NULL;
3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;
3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
3854: g_path := 'IGC.PLSQL.IGCOUGLB.IGC_CC_OPN_UPD_GET_LNK_PUB.';

Line 3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;

3847: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;
3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
3854: g_path := 'IGC.PLSQL.IGCOUGLB.IGC_CC_OPN_UPD_GET_LNK_PUB.';
3855: g_debug_mode := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 3852: g_error_level := FND_LOG.LEVEL_ERROR;

3848: g_state_level := FND_LOG.LEVEL_STATEMENT;
3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;
3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
3854: g_path := 'IGC.PLSQL.IGCOUGLB.IGC_CC_OPN_UPD_GET_LNK_PUB.';
3855: g_debug_mode := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
3856:

Line 3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

3849: g_proc_level := FND_LOG.LEVEL_PROCEDURE;
3850: g_event_level := FND_LOG.LEVEL_EVENT;
3851: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
3852: g_error_level := FND_LOG.LEVEL_ERROR;
3853: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
3854: g_path := 'IGC.PLSQL.IGCOUGLB.IGC_CC_OPN_UPD_GET_LNK_PUB.';
3855: g_debug_mode := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
3856:
3857: