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.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.initialize ;

153: -- -------------------------------------------------------------------
154: -- Make sure that if the message stack is to be initialized it is.
155: -- -------------------------------------------------------------------
156: IF (FND_API.to_Boolean ( l_init_msg_list )) THEN
157: FND_MSG_PUB.initialize ;
158: END IF;
159:
160: -- -------------------------------------------------------------------
161: -- Open API starts here.

Line 267: FND_MSG_PUB.ADD;

263: -- --------------------------------------------------------------------
264: -- Failure in retrieving the sequesnce number for the Header ID.
265: -- --------------------------------------------------------------------
266: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_NO_CC_HDR_SEQ');
267: FND_MSG_PUB.ADD;
268: RAISE FND_API.G_EXC_ERROR;
269:
270: ELSE
271:

Line 386: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

382: RETURN;
383:
384: WHEN OTHERS THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
388: END IF;
389: -- Bug 3199488
390: IF ( g_unexp_level >= g_debug_level ) THEN

Line 387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

383:
384: WHEN OTHERS THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
388: END IF;
389: -- Bug 3199488
390: IF ( g_unexp_level >= g_debug_level ) THEN
391: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 511: FND_MSG_PUB.ADD;

507: IF (p_cc_header_rec.org_id <> p_current_org_id) THEN
508: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_ORGID_NO_MATCH');
509: FND_MESSAGE.SET_TOKEN('ORGID', TO_CHAR(p_cc_header_rec.org_id), TRUE);
510: FND_MESSAGE.SET_TOKEN('CURR_ORGID', TO_CHAR(p_current_org_id), TRUE);
511: FND_MSG_PUB.ADD;
512: l_error_count := l_error_count + 1;
513:
514: IF g_debug_mode = 'Y'
515: THEN

Line 522: FND_MSG_PUB.ADD;

518: END IF;
519:
520: IF (p_cc_header_rec.org_id IS NULL) THEN
521: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_NO_ORG_ID');
522: FND_MSG_PUB.ADD;
523: l_error_count := l_error_count + 1;
524:
525: IF g_debug_mode = 'Y'
526: THEN

Line 543: FND_MSG_PUB.ADD;

539: IF (c_validate_org_id%NOTFOUND) THEN
540:
541: FND_MESSAGE.SET_NAME('IGC', 'IGC_ORG_NOT_FOUND');
542: FND_MESSAGE.SET_TOKEN('ORG_ID', TO_CHAR(p_cc_header_rec.org_id),TRUE);
543: FND_MSG_PUB.ADD;
544: l_error_count := l_error_count + 1;
545: IF g_debug_mode = 'Y'
546: THEN
547: g_debug_msg := 'CC Open API Validate Org Id is Not Found...';

Line 566: FND_MSG_PUB.ADD;

562: IF (p_cc_header_rec.set_of_books_id <> p_current_sob_id) THEN
563: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_SOB_NO_MATCH_USER_SOB');
564: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_cc_header_rec.set_of_books_id), TRUE);
565: FND_MESSAGE.SET_TOKEN('CURRENT_SOB_ID', TO_CHAR(p_current_sob_id), TRUE);
566: FND_MSG_PUB.ADD;
567: l_error_count := l_error_count + 1;
568: IF g_debug_mode = 'Y'
569: THEN
570: g_debug_msg := 'CC Open API Validate Set Of Books Id...';

Line 577: FND_MSG_PUB.ADD;

573: END IF;
574:
575: IF (p_cc_header_rec.set_of_books_id IS NULL) THEN
576: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_NO_SOB');
577: FND_MSG_PUB.ADD;
578: l_error_count := l_error_count + 1;
579:
580: IF g_debug_mode = 'Y'
581: THEN

Line 598: FND_MSG_PUB.ADD;

594: IF (c_validate_sob_id%NOTFOUND) THEN
595:
596: FND_MESSAGE.SET_NAME('IGC', 'IGC_SOB_ID_NOT_FOUND');
597: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_cc_header_rec.set_of_books_id));
598: FND_MSG_PUB.ADD;
599: l_error_count := l_error_count + 1;
600: IF g_debug_mode = 'Y'
601: THEN
602: g_debug_msg := 'CC Open API Validate SOB Id is Not Found...';

Line 626: FND_MSG_PUB.ADD;

622: IF (c_validate_sob_org_combo%NOTFOUND) THEN
623: FND_MESSAGE.SET_NAME('IGC', 'IGC_NO_SOB_ORG_COMBO');
624: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_cc_header_rec.set_of_books_id), TRUE);
625: FND_MESSAGE.SET_TOKEN('ORG_ID', TO_CHAR(p_cc_header_rec.org_id), TRUE);
626: FND_MSG_PUB.ADD;
627: l_error_count := l_error_count + 1;
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...';

Line 646: FND_MSG_PUB.ADD;

642: -- -------------------------------------------------------------------
643: IF UPPER(p_cc_header_rec.cc_type) NOT IN ('S', 'C', 'R') THEN
644: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CCTYPE_INVALID');
645: FND_MESSAGE.SET_TOKEN('CC_TYPE', p_cc_header_rec.cc_type, TRUE);
646: FND_MSG_PUB.ADD;
647: l_error_count := l_error_count + 1;
648: IF g_debug_mode = 'Y'
649: THEN
650: g_debug_msg := 'CC Open API Validate CC Type...';

Line 671: FND_MSG_PUB.ADD;

667: EXCEPTION
668: WHEN OTHERS THEN
669: l_error_count := l_error_count + 1;
670: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NUM_METHOD_NOT_DEFINED');
671: FND_MSG_PUB.ADD;
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

Line 695: FND_MSG_PUB.ADD;

691: -- Check to ensure that the CC Reference Number given is NOT NULL.
692: -- -------------------------------------------------------------------
693: IF (p_cc_header_rec.cc_ref_num IS NULL) THEN
694: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_NO_REF_NUM');
695: FND_MSG_PUB.ADD;
696: l_error_count := l_error_count + 1;
697: IF g_debug_mode = 'Y'
698: THEN
699: g_debug_msg := 'CC Open API Validate CC Reference Number failure is NULL...';

Line 717: FND_MSG_PUB.ADD;

713:
714: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_AUTO_NUMBERING_ENABLED');
715: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_header_rec.cc_num);
716: FND_MESSAGE.SET_TOKEN('ORG_ID', p_current_org_id);
717: FND_MSG_PUB.ADD;
718: l_error_count := l_error_count + 1;
719: IF g_debug_mode = 'Y'
720: THEN
721: g_debug_msg := 'CC Open API Validate CC Number failure with auto numbering on...';

Line 748: FND_MSG_PUB.ADD;

744: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
745: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_NUMERIC_CC_NUM');
746: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_header_rec.cc_num);
747: FND_MESSAGE.SET_TOKEN('ORG_ID', p_current_org_id);
748: FND_MSG_PUB.ADD;
749: END IF;
750:
751: l_error_count := l_error_count + 1;
752: IF g_debug_mode = 'Y'

Line 767: FND_MSG_PUB.ADD;

763: ELSIF ((l_cc_num_method = 'M') AND
764: (p_cc_header_rec.cc_num IS NULL)) THEN
765:
766: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_NUM_NULL_FOR_MANUAL');
767: FND_MSG_PUB.ADD;
768: l_error_count := l_error_count + 1;
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...';

Line 806: FND_MSG_PUB.ADD;

802: ELSE
803:
804: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_API_AUTO_CC_NUM_FAIL');
805: FND_MESSAGE.SET_TOKEN('ORG_ID', p_current_org_id);
806: FND_MSG_PUB.ADD;
807: l_error_count := l_error_count + 1;
808:
809: IF g_debug_mode = 'Y'
810: THEN

Line 856: FND_MSG_PUB.ADD;

852:
853: IF (l_count > 0) THEN
854: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DUP_CC_NUMBER');
855: FND_MESSAGE.SET_TOKEN('CC_NUMBER', p_cc_header_rec.cc_num);
856: FND_MSG_PUB.ADD;
857: l_error_count := l_error_count + 1;
858: IF g_debug_mode = 'Y'
859: THEN
860: g_debug_msg := 'CC Open API Validate CC Number...';

Line 900: FND_MSG_PUB.ADD;

896:
897: IF l_count > 0 THEN
898: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DUP_CC_REF_NUM');
899: FND_MESSAGE.SET_TOKEN('CC_REF_NUM', p_cc_header_rec.cc_ref_num);
900: FND_MSG_PUB.ADD;
901: l_error_count := l_error_count + 1;
902: IF g_debug_mode = 'Y'
903: THEN
904: g_debug_msg := 'CC Open API Validate CC Reference Number...';

Line 919: FND_MSG_PUB.ADD;

915:
916: IF p_cc_header_rec.parent_header_Id IS NULL THEN
917:
918: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PARENT_HDR_ID_REQD');
919: FND_MSG_PUB.ADD;
920: l_error_count := l_error_count + 1;
921: IF g_debug_mode = 'Y'
922: THEN
923: g_debug_msg := 'CC Open API Validate Parent Header Id Null...';

Line 938: FND_MSG_PUB.ADD;

934: INTO l_cc_num;
935:
936: IF (c_val_cover_state_stat%NOTFOUND) THEN
937: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PARENT_NOT_VAL_STATE');
938: FND_MSG_PUB.ADD;
939: l_error_count := l_error_count + 1;
940: IF g_debug_mode = 'Y'
941: THEN
942: g_debug_msg := 'CC Open API Validate Parent Header State and Status invalid...';

Line 969: FND_MSG_PUB.ADD;

965:
966: WHEN NO_DATA_FOUND THEN
967: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PARENT_NOT_VALID_OAPI');
968: FND_MESSAGE.SET_TOKEN('PARENT_HEADER_ID', TO_CHAR(p_cc_header_rec.parent_header_id), TRUE);
969: FND_MSG_PUB.ADD;
970: l_error_count := l_error_count + 1;
971: IF g_debug_mode = 'Y'
972: THEN
973: g_debug_msg := 'CC Open API Validate Invalid Cover Details...';

Line 987: FND_MSG_PUB.ADD;

983: ELSE
984:
985: IF p_cc_header_rec.parent_header_id IS NOT NULL THEN
986: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PARENT_ID_NULL_OAPI');
987: FND_MSG_PUB.ADD;
988: l_error_count := l_error_count + 1;
989: IF g_debug_mode = 'Y'
990: THEN
991: g_debug_msg := 'CC Open API Validate Parent Header Id Must be Null...';

Line 1127: FND_MSG_PUB.ADD;

1123:
1124: WHEN NO_DATA_FOUND THEN
1125: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_VENDOR_ID');
1126: FND_MESSAGE.SET_TOKEN('VENDOR_ID', TO_CHAR(p_cc_header_rec.vendor_id), TRUE);
1127: FND_MSG_PUB.ADD;
1128: l_error_count := l_error_count + 1;
1129: IF g_debug_mode = 'Y'
1130: THEN
1131: g_debug_msg := 'CC Open API Validate Vendor Info Not Successful...';

Line 1167: FND_MSG_PUB.ADD;

1163:
1164: WHEN NO_DATA_FOUND THEN
1165: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_VENDOR_SITE_ID');
1166: FND_MESSAGE.SET_TOKEN('VENDOR_SITE_ID', TO_CHAR(p_cc_header_rec.vendor_site_id), TRUE);
1167: FND_MSG_PUB.ADD;
1168: l_error_count := l_error_count + 1;
1169: IF g_debug_mode = 'Y'
1170: THEN
1171: g_debug_msg := 'CC Open API Validate Vendor Site Info Not Successful...';

Line 1197: FND_MSG_PUB.ADD;

1193: IF ((p_cc_header_rec.vendor_site_id IS NULL) OR
1194: (p_cc_header_rec.vendor_id IS NULL)) THEN
1195:
1196: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_VNDR_SITE_CONT_ID_NULL');
1197: FND_MSG_PUB.ADD;
1198: l_error_count := l_error_count + 1;
1199: IF g_debug_mode = 'Y'
1200: THEN
1201: g_debug_msg := 'CC Open API Validate Vendor Contact and Vendor Validation Not Successful...';

Line 1223: FND_MSG_PUB.ADD;

1219:
1220: WHEN NO_DATA_FOUND THEN
1221: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_VEDR_CONTACT_ID');
1222: FND_MESSAGE.SET_TOKEN('VENDOR_CONTACT_ID', TO_CHAR(p_cc_header_rec.vendor_contact_id), TRUE);
1223: FND_MSG_PUB.ADD;
1224: l_error_count := l_error_count + 1;
1225: IF g_debug_mode = 'Y'
1226: THEN
1227: g_debug_msg := 'CC Open API Validate Vendor Contact Not Successful...';

Line 1255: FND_MSG_PUB.ADD;

1251:
1252: WHEN NO_DATA_FOUND THEN
1253: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_TERM_ID');
1254: FND_MESSAGE.SET_TOKEN('TERM_ID', TO_CHAR(p_cc_header_rec.term_id), TRUE);
1255: FND_MSG_PUB.ADD;
1256: l_error_count := l_error_count + 1;
1257: IF g_debug_mode = 'Y'
1258: THEN
1259: g_debug_msg := 'CC Open API Validate Term Not Successful...';

Line 1286: FND_MSG_PUB.ADD;

1282: IF p_cc_header_rec.location_id IS NOT NULL THEN
1283:
1284: IF p_cc_header_rec.vendor_id IS NULL THEN
1285: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_LOCATION_ID_NULL');
1286: FND_MSG_PUB.ADD;
1287: l_error_count := l_error_count + 1;
1288: IF g_debug_mode = 'Y'
1289: THEN
1290: g_debug_msg := 'CC Open API Validate Vendor and Location Valdiation Not Successful...';

Line 1310: FND_MSG_PUB.ADD;

1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LOCATION_ID');
1309: FND_MESSAGE.SET_TOKEN('LOCATION_ID', TO_CHAR(p_cc_header_rec.location_id), TRUE);
1310: FND_MSG_PUB.ADD;
1311: l_error_count := l_error_count + 1;
1312: IF g_debug_mode = 'Y'
1313: THEN
1314: g_debug_msg := 'CC Open API Validate Location Not Successful...';

Line 1376: FND_MSG_PUB.ADD;

1372: EXCEPTION
1373: WHEN NO_DATA_FOUND THEN
1374: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_OWNER_UID_INVALID');
1375: FND_MESSAGE.SET_TOKEN('OWNER_UID', TO_CHAR(p_cc_header_rec.cc_owner_user_id), TRUE);
1376: FND_MSG_PUB.ADD;
1377: l_error_count := l_error_count + 1;
1378: IF g_debug_mode = 'Y'
1379: THEN
1380: g_debug_msg := 'CC Open API Validate Owner Not Successful...';

Line 1433: FND_MSG_PUB.ADD;

1429:
1430: WHEN NO_DATA_FOUND THEN
1431: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_PREPARER_UID_INVALID');
1432: FND_MESSAGE.SET_TOKEN('PREPARER_UID', TO_CHAR(p_cc_header_rec.cc_preparer_user_id), TRUE);
1433: FND_MSG_PUB.ADD;
1434: l_error_count := l_error_count + 1;
1435: IF g_debug_mode = 'Y'
1436: THEN
1437: g_debug_msg := 'CC Open API Validate Preparer Not Successful...';

Line 1477: FND_MSG_PUB.ADD;

1473: IF x_currency_code IS NULL THEN
1474:
1475: IF p_func_currency_code IS NULL THEN
1476: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CURR_CODE_REQD');
1477: FND_MSG_PUB.ADD;
1478: l_error_count := l_error_count + 1;
1479: IF g_debug_mode = 'Y'
1480: THEN
1481: g_debug_msg := 'CC Open API Validate Currency cannot be null...';

Line 1513: FND_MSG_PUB.ADD;

1509:
1510: WHEN NO_DATA_FOUND THEN
1511: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CURR_CODE_INVALID');
1512: FND_MESSAGE.SET_TOKEN('CURR_CODE', x_currency_code, TRUE);
1513: FND_MSG_PUB.ADD;
1514: l_error_count := l_error_count + 1;
1515: IF g_debug_mode = 'Y'
1516: THEN
1517: g_debug_msg := 'CC Open API Validate Currency Invalid...';

Line 1554: FND_MSG_PUB.ADD;

1550: EXCEPTION
1551:
1552: WHEN OTHERS THEN
1553: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CONV_TYPE_RATE_DT_REQD');
1554: FND_MSG_PUB.ADD;
1555: l_error_count := l_error_count + 1;
1556: IF g_debug_mode = 'Y'
1557: THEN
1558: g_debug_msg := 'CC Open API Validate No default rate type defined...';

Line 1584: FND_MSG_PUB.ADD;

1580:
1581: WHEN OTHERS THEN
1582: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CURR_CODE_INVALID');
1583: FND_MESSAGE.SET_TOKEN('CURR_CODE', x_currency_code, TRUE);
1584: FND_MSG_PUB.ADD;
1585: l_error_count := l_error_count + 1;
1586: IF g_debug_mode = 'Y'
1587: THEN
1588: g_debug_msg := 'CC Open API Validate Invalid Currency Code defined...';

Line 1614: FND_MSG_PUB.ADD;

1610: x_conversion_rate <> l_cov_conversion_rate OR
1611: x_conversion_date <> l_cov_conversion_date) THEN
1612:
1613: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CURR_CD_CT_CR_CD_SAME');
1614: FND_MSG_PUB.ADD;
1615: l_error_count := l_error_count + 1;
1616: IF g_debug_mode = 'Y'
1617: THEN
1618: g_debug_msg := 'CC Open API Validate Cover and Release currency does not match...';

Line 1656: FND_MSG_PUB.ADD;

1652:
1653: WHEN NO_DATA_FOUND THEN
1654: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CONV_TYPE_INVALID');
1655: FND_MESSAGE.SET_TOKEN('CONVTYPE', x_conversion_type, TRUE);
1656: FND_MSG_PUB.ADD;
1657: l_error_count := l_error_count + 1;
1658: IF g_debug_mode = 'Y'
1659: THEN
1660: g_debug_msg := 'CC Open API Validate Invalid Conversion Type...';

Line 1673: FND_MSG_PUB.ADD;

1669: (x_conversion_date IS NULL OR
1670: x_conversion_rate IS NULL) THEN
1671:
1672: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CONV_DATE_RATE_REQD');
1673: FND_MSG_PUB.ADD;
1674: l_error_count := l_error_count + 1;
1675: IF g_debug_mode = 'Y'
1676: THEN
1677: g_debug_msg := 'CC Open API Validate Rate and Date required...';

Line 1710: FND_MSG_PUB.ADD;

1706: FND_MESSAGE.SET_NAME('IGC', 'IGC_API_CONV_RATE_FAILURE');
1707: FND_MESSAGE.SET_TOKEN('CONV_TYPE', x_conversion_type, TRUE);
1708: FND_MESSAGE.SET_TOKEN('CONV_DATE', x_conversion_date, TRUE);
1709: FND_MESSAGE.SET_TOKEN('CURR_CODE', x_currency_code, TRUE);
1710: FND_MSG_PUB.ADD;
1711: l_error_count := l_error_count + 1;
1712: IF g_debug_mode = 'Y'
1713: THEN
1714: g_debug_msg := 'CC Open API Validate Get RATE is could not be obtained...';

Line 1742: FND_MSG_PUB.ADD;

1738: FND_MESSAGE.SET_NAME('IGC', 'IGC_API_CONV_RATE_NOT_ALLWD');
1739: FND_MESSAGE.SET_TOKEN('CONV_TYPE', x_conversion_type, TRUE);
1740: FND_MESSAGE.SET_TOKEN('CONV_DATE', x_conversion_date, TRUE);
1741: FND_MESSAGE.SET_TOKEN('CONV_RATE', x_conversion_rate, TRUE);
1742: FND_MSG_PUB.ADD;
1743: l_error_count := l_error_count + 1;
1744: IF g_debug_mode = 'Y'
1745: THEN
1746: g_debug_msg := 'CC Open API Validate Rate NOT required...';

Line 1762: FND_MSG_PUB.ADD;

1758: (x_conversion_type IS NOT NULL OR
1759: x_conversion_date IS NOT NULL OR
1760: x_conversion_rate IS NOT NULL ) THEN
1761: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_CONV_TYPE_RTDT_NULL');
1762: FND_MSG_PUB.ADD;
1763: x_conversion_type := NULL;
1764: x_conversion_date := NULL;
1765: x_conversion_rate := NULL;
1766: l_error_count := l_error_count + 1;

Line 1795: FND_MSG_PUB.ADD;

1791:
1792: WHEN NO_DATA_FOUND THEN
1793: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_CREATED_BY');
1794: FND_MESSAGE.SET_TOKEN('CREATED_BY', TO_CHAR(p_cc_header_rec.created_by), TRUE);
1795: FND_MSG_PUB.ADD;
1796: l_error_count := l_error_count + 1;
1797: IF g_debug_mode = 'Y'
1798: THEN
1799: g_debug_msg := 'CC Open API Validate Invalid Created By...';

Line 1811: FND_MSG_PUB.ADD;

1807: ELSE
1808:
1809: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_CREATED_BY');
1810: FND_MESSAGE.SET_TOKEN('CREATED_BY', TO_CHAR(p_cc_header_rec.created_by), TRUE);
1811: FND_MSG_PUB.ADD;
1812: l_error_count := l_error_count + 1;
1813: IF g_debug_mode = 'Y'
1814: THEN
1815: g_debug_msg := 'CC Open API Validate Invalid Created By is NULL...';

Line 1840: FND_MSG_PUB.ADD;

1836:
1837: WHEN NO_DATA_FOUND THEN
1838: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPDATED_BY');
1839: FND_MESSAGE.SET_TOKEN('LAST_UPDATED_BY', TO_CHAR(p_cc_header_rec.last_updated_by), TRUE);
1840: FND_MSG_PUB.ADD;
1841: l_error_count := l_error_count + 1;
1842: IF g_debug_mode = 'Y'
1843: THEN
1844: g_debug_msg := 'CC Open API Validate Invalid Last Updated By...';

Line 1855: FND_MSG_PUB.ADD;

1851: ELSE
1852:
1853: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPDATED_BY');
1854: FND_MESSAGE.SET_TOKEN('LAST_UPDATED_BY', TO_CHAR(p_cc_header_rec.last_updated_by), TRUE);
1855: FND_MSG_PUB.ADD;
1856: l_error_count := l_error_count + 1;
1857: IF g_debug_mode = 'Y'
1858: THEN
1859: g_debug_msg := 'CC Open API Validate Invalid Last Updated By is NULL...';

Line 1884: FND_MSG_PUB.ADD;

1880:
1881: WHEN NO_DATA_FOUND THEN
1882: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPD_LOGIN');
1883: FND_MESSAGE.SET_TOKEN('LAST_UPDATE_LOGIN', TO_CHAR(p_cc_header_rec.last_update_login), TRUE);
1884: FND_MSG_PUB.ADD;
1885: l_error_count := l_error_count + 1;
1886: IF g_debug_mode = 'Y'
1887: THEN
1888: g_debug_msg := 'CC Open API Validate Invalid Last Update Login...';

Line 1900: FND_MSG_PUB.ADD;

1896: ELSE
1897:
1898: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPD_LOGIN');
1899: FND_MESSAGE.SET_TOKEN('LAST_UPDATE_LOGIN', TO_CHAR(p_cc_header_rec.last_update_login), TRUE);
1900: FND_MSG_PUB.ADD;
1901: l_error_count := l_error_count + 1;
1902: IF g_debug_mode = 'Y'
1903: THEN
1904: g_debug_msg := 'CC Open API Validate Invalid Last Update Login is NULL...';

Line 1971: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

1967: END IF;
1968: IF (c_val_cover_state_stat%ISOPEN) THEN
1969: CLOSE c_val_cover_state_stat;
1970: END IF;
1971: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1972: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1973: END IF;
1974: -- Bug 3199488
1975: IF ( g_unexp_level >= g_debug_level ) THEN

Line 1972: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1968: IF (c_val_cover_state_stat%ISOPEN) THEN
1969: CLOSE c_val_cover_state_stat;
1970: END IF;
1971: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1972: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1973: END IF;
1974: -- Bug 3199488
1975: IF ( g_unexp_level >= g_debug_level ) THEN
1976: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 2011: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2007: EXCEPTION
2008:
2009: WHEN OTHERS THEN
2010: x_header_id := NULL;
2011: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2012: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2013: END IF;
2014: -- Bug 3199488
2015: IF ( g_unexp_level >= g_debug_level ) THEN

Line 2012: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2008:
2009: WHEN OTHERS THEN
2010: x_header_id := NULL;
2011: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2012: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2013: END IF;
2014: -- Bug 3199488
2015: IF ( g_unexp_level >= g_debug_level ) THEN
2016: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 2169: FND_MSG_PUB.initialize ;

2165: -- -------------------------------------------------------------------
2166: -- Make sure that if the message stack is to be initialized it is.
2167: -- -------------------------------------------------------------------
2168: IF (FND_API.to_Boolean ( l_init_msg_list )) THEN
2169: FND_MSG_PUB.initialize ;
2170: END IF;
2171:
2172: -- --------------------------------------------------------------------
2173: -- Update API logic.

Line 2206: FND_MSG_PUB.ADD;

2202: IF (c_validate_sob_org_combo%NOTFOUND) THEN
2203: FND_MESSAGE.SET_NAME('IGC', 'IGC_NO_SOB_ORG_COMBO');
2204: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_set_of_books_id), TRUE);
2205: FND_MESSAGE.SET_TOKEN('ORG_ID', TO_CHAR(p_org_id), TRUE);
2206: FND_MSG_PUB.ADD;
2207: x_msg_data := FND_MESSAGE.GET;
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: x_msg_count := 1;
2210: IF g_debug_mode = 'Y'

Line 2231: FND_MSG_PUB.ADD;

2227:
2228: IF (c_cc_header_exist%NOTFOUND) THEN
2229: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_FOUND');
2230: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num, TRUE);
2231: FND_MSG_PUB.ADD;
2232: x_msg_data := FND_MESSAGE.GET;
2233: x_return_status := FND_API.G_RET_STS_ERROR;
2234: x_msg_count := 1;
2235: IF g_debug_mode = 'Y'

Line 2256: FND_MSG_PUB.ADD;

2252:
2253: IF (c_val_ref_num%NOTFOUND) THEN
2254: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NO_UPD_NO_REF');
2255: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num,TRUE);
2256: FND_MSG_PUB.ADD;
2257: x_msg_data := FND_MESSAGE.GET;
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: x_msg_count := 1;
2260: IF g_debug_mode = 'Y'

Line 2278: FND_MSG_PUB.ADD;

2274:
2275: IF (c_cc_header_state%NOTFOUND) THEN
2276: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_APPRVD_CONFIRMED');
2277: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num, TRUE);
2278: FND_MSG_PUB.ADD;
2279: x_msg_data := FND_MESSAGE.GET;
2280: x_return_status := FND_API.G_RET_STS_ERROR;
2281: x_msg_count := 1;
2282: IF g_debug_mode = 'Y'

Line 2295: FND_MSG_PUB.ADD;

2291: END IF;
2292:
2293: IF l_cc_header_rec.cc_type = 'C' THEN
2294: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_TYPE_NOT_ALWD');
2295: FND_MSG_PUB.ADD;
2296: x_msg_data := FND_MESSAGE.GET;
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: x_msg_count := 1;
2299: IF g_debug_mode = 'Y'

Line 2324: FND_MSG_PUB.ADD;

2320: EXCEPTION
2321: WHEN NO_DATA_FOUND THEN
2322: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_INVALID_ACTION_CODE');
2323: FND_MESSAGE.SET_TOKEN('ACTION_CODE', p_action_code,TRUE);
2324: FND_MSG_PUB.ADD;
2325: x_msg_data := FND_MESSAGE.GET;
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: x_msg_count := 1;
2328: IF g_debug_mode = 'Y'

Line 2355: FND_MSG_PUB.ADD;

2351:
2352: WHEN NO_DATA_FOUND THEN
2353: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPD_LOGIN');
2354: FND_MESSAGE.SET_TOKEN('LAST_UPDATE_LOGIN', TO_CHAR(l_current_login_id), TRUE);
2355: FND_MSG_PUB.ADD;
2356: x_msg_data := FND_MESSAGE.GET;
2357: x_return_status := FND_API.G_RET_STS_ERROR;
2358: x_msg_count := 1;
2359: IF g_debug_mode = 'Y'

Line 2374: FND_MSG_PUB.ADD;

2370: ELSE
2371:
2372: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPD_LOGIN');
2373: FND_MESSAGE.SET_TOKEN('LAST_UPDATE_LOGIN', TO_CHAR(l_current_login_id), TRUE);
2374: FND_MSG_PUB.ADD;
2375: x_msg_data := FND_MESSAGE.GET;
2376: x_return_status := FND_API.G_RET_STS_ERROR;
2377: x_msg_count := 1;
2378: IF g_debug_mode = 'Y'

Line 2406: FND_MSG_PUB.ADD;

2402:
2403: WHEN NO_DATA_FOUND THEN
2404: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPDATED_BY');
2405: FND_MESSAGE.SET_TOKEN('LAST_UPDATED_BY', TO_CHAR(l_current_user_id), TRUE);
2406: FND_MSG_PUB.ADD;
2407: x_msg_data := FND_MESSAGE.GET;
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409: x_msg_count := 1;
2410: IF g_debug_mode = 'Y'

Line 2424: FND_MSG_PUB.ADD;

2420: ELSE
2421:
2422: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_LAST_UPDATED_BY');
2423: FND_MESSAGE.SET_TOKEN('LAST_UPDATED_BY', TO_CHAR(l_current_user_id), TRUE);
2424: FND_MSG_PUB.ADD;
2425: x_msg_data := FND_MESSAGE.GET;
2426: x_return_status := FND_API.G_RET_STS_ERROR;
2427: x_msg_count := 1;
2428: IF g_debug_mode = 'Y'

Line 2453: FND_MSG_PUB.ADD;

2449: EXCEPTION
2450: WHEN NO_DATA_FOUND THEN
2451: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_INVALID_CONTROL_STATUS');
2452: FND_MESSAGE.SET_TOKEN('CTRL_STATUS', l_cc_header_rec.cc_ctrl_status,TRUE);
2453: FND_MSG_PUB.ADD;
2454: x_msg_data := FND_MESSAGE.GET;
2455: x_return_status := FND_API.G_RET_STS_ERROR;
2456: x_msg_count := 1;
2457: IF g_debug_mode = 'Y'

Line 2478: FND_MSG_PUB.ADD;

2474: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_ACTION_NOT_ALLOWED');
2475: FND_MESSAGE.SET_TOKEN('CODE_MEANING', l_action_meaning,TRUE);
2476: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num,TRUE);
2477: FND_MESSAGE.SET_TOKEN('CONT_STATUS', l_control_meaning,TRUE);
2478: FND_MSG_PUB.ADD;
2479: x_msg_data := FND_MESSAGE.GET;
2480: x_return_status := FND_API.G_RET_STS_ERROR;
2481: x_msg_count := 1;
2482: IF g_debug_mode = 'Y'

Line 2500: FND_MSG_PUB.ADD;

2496: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_ACTION_NOT_ALLOWED');
2497: FND_MESSAGE.SET_TOKEN('CODE_MEANING', l_action_meaning,TRUE);
2498: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num,TRUE);
2499: FND_MESSAGE.SET_TOKEN('CONT_STATUS', l_control_meaning,TRUE);
2500: FND_MSG_PUB.ADD;
2501: x_msg_data := FND_MESSAGE.GET;
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503: x_msg_count := 1;
2504: IF g_debug_mode = 'Y'

Line 2522: FND_MSG_PUB.ADD;

2518: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_ACTION_NOT_ALLOWED');
2519: FND_MESSAGE.SET_TOKEN('CODE_MEANING', l_action_meaning,TRUE);
2520: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num,TRUE);
2521: FND_MESSAGE.SET_TOKEN('CONT_STATUS', l_control_meaning,TRUE);
2522: FND_MSG_PUB.ADD;
2523: x_msg_data := FND_MESSAGE.GET;
2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: x_msg_count := 1;
2526: IF g_debug_mode = 'Y'

Line 2544: FND_MSG_PUB.ADD;

2540: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_ACTION_NOT_ALLOWED');
2541: FND_MESSAGE.SET_TOKEN('CODE_MEANING', l_action_meaning,TRUE);
2542: FND_MESSAGE.SET_TOKEN('CC_NUM', p_cc_num,TRUE);
2543: FND_MESSAGE.SET_TOKEN('CONT_STATUS', l_control_meaning,TRUE);
2544: FND_MSG_PUB.ADD;
2545: x_msg_data := FND_MESSAGE.GET;
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: x_msg_count := 1;
2548: IF g_debug_mode = 'Y'

Line 2579: FND_MSG_PUB.ADD;

2575: l_new_apprvl_status := 'RR';
2576: ELSE
2577: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_INVALID_ACTION_CODE');
2578: FND_MESSAGE.SET_TOKEN('ACTION_CODE', p_action_code,TRUE);
2579: FND_MSG_PUB.ADD;
2580: x_msg_data := FND_MESSAGE.GET;
2581: x_return_status := FND_API.G_RET_STS_ERROR;
2582: x_msg_count := 1;
2583: IF g_debug_mode = 'Y'

Line 3117: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3113: END IF;
3114: IF (c_validate_sob_org_combo%ISOPEN) THEN
3115: CLOSE c_validate_sob_org_combo;
3116: END IF;
3117: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3119: END IF;
3120: -- Bug 3199488
3121: IF ( g_unexp_level >= g_debug_level ) THEN

Line 3118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3114: IF (c_validate_sob_org_combo%ISOPEN) THEN
3115: CLOSE c_validate_sob_org_combo;
3116: END IF;
3117: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3118: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3119: END IF;
3120: -- Bug 3199488
3121: IF ( g_unexp_level >= g_debug_level ) THEN
3122: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 3182: /*IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3178: WHEN FND_API.G_EXC_ERROR THEN
3179: RETURN;
3180:
3181: WHEN OTHERS THEN
3182: /*IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3183: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3184: END IF;*/
3185: RETURN;
3186:

Line 3183: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

3179: RETURN;
3180:
3181: WHEN OTHERS THEN
3182: /*IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3183: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
3184: END IF;*/
3185: RETURN;
3186:
3187: END Output_Debug;

Line 3278: FND_MSG_PUB.initialize ;

3274: -- -------------------------------------------------------------------
3275: -- Make sure that if the message stack is to be initialized it is.
3276: -- -------------------------------------------------------------------
3277: IF (FND_API.to_Boolean ( l_init_msg_list )) THEN
3278: FND_MSG_PUB.initialize ;
3279: END IF;
3280:
3281: -- -------------------------------------------------------------------
3282: -- Validate Org ID and set of Books ID Combination.

Line 3293: FND_MSG_PUB.ADD;

3289:
3290: FND_MESSAGE.SET_NAME('IGC', 'IGC_NO_SOB_ORG_COMBO');
3291: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_set_of_books_id), TRUE);
3292: FND_MESSAGE.SET_TOKEN('ORG_ID', TO_CHAR(p_org_id), TRUE);
3293: FND_MSG_PUB.ADD;
3294: x_msg_data := FND_MESSAGE.GET;
3295: x_return_status := FND_API.G_RET_STS_ERROR;
3296: x_msg_count := 1;
3297: x_cc_header_id := NULL;

Line 3315: FND_MSG_PUB.ADD;

3311: IF (c_check_cc_num%NOTFOUND) THEN
3312:
3313: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_FOUND');
3314: FND_MESSAGE.SET_TOKEN ('CC_NUM', p_cc_num);
3315: FND_MSG_PUB.ADD;
3316: x_msg_data := FND_MESSAGE.GET;
3317: x_return_status := FND_API.G_RET_STS_ERROR;
3318: x_msg_count := 1;
3319: x_cc_header_id := NULL;

Line 3350: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3346: END IF;
3347: IF (c_validate_sob_org_combo%ISOPEN) THEN
3348: CLOSE c_validate_sob_org_combo;
3349: END IF;
3350: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3351: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3352: l_api_name);
3353: END IF;
3354: -- Bug 3199488

Line 3351: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

3347: IF (c_validate_sob_org_combo%ISOPEN) THEN
3348: CLOSE c_validate_sob_org_combo;
3349: END IF;
3350: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3351: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3352: l_api_name);
3353: END IF;
3354: -- Bug 3199488
3355: IF ( g_unexp_level >= g_debug_level ) THEN

Line 3467: FND_MSG_PUB.initialize ;

3463: -- --------------------------------------------------------------------
3464: -- Make sure that if the message stack is to be initialized it is.
3465: -- --------------------------------------------------------------------
3466: IF (FND_API.to_Boolean ( l_init_msg_list )) THEN
3467: FND_MSG_PUB.initialize ;
3468: END IF;
3469:
3470: -- -------------------------------------------------------------------
3471: -- Validate Org ID and set of Books ID Combination.

Line 3482: FND_MSG_PUB.ADD;

3478:
3479: FND_MESSAGE.SET_NAME('IGC', 'IGC_NO_SOB_ORG_COMBO');
3480: FND_MESSAGE.SET_TOKEN('SOB_ID', TO_CHAR(p_set_of_books_id), TRUE);
3481: FND_MESSAGE.SET_TOKEN('ORG_ID', TO_CHAR(p_org_id), TRUE);
3482: FND_MSG_PUB.ADD;
3483: x_msg_data := FND_MESSAGE.GET;
3484: x_return_status := FND_API.G_RET_STS_ERROR;
3485: x_msg_count := 1;
3486:

Line 3501: FND_MSG_PUB.ADD;

3497: IF (c_check_cc_num%NOTFOUND) THEN
3498:
3499: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_FOUND');
3500: FND_MESSAGE.SET_TOKEN ('CC_NUM', p_cc_num);
3501: FND_MSG_PUB.ADD;
3502: x_msg_data := FND_MESSAGE.GET;
3503: x_return_status := FND_API.G_RET_STS_ERROR;
3504: x_msg_count := 1;
3505:

Line 3531: FND_MSG_PUB.ADD;

3527: ROLLBACK to CC_Link_API_PT;
3528:
3529: FND_MESSAGE.SET_NAME ('IGC', 'IGC_CC_NOT_FOUND');
3530: FND_MESSAGE.SET_TOKEN ('CC_NUM', p_cc_num);
3531: FND_MSG_PUB.ADD;
3532: x_msg_data := FND_MESSAGE.GET;
3533: x_return_status := FND_API.G_RET_STS_ERROR;
3534: x_msg_count := 1;
3535:

Line 3545: FND_MSG_PUB.ADD;

3541: -- Duplicate Reference numbers not allowed for the same org and SOB
3542: -- --------------------------------------------------------------------
3543: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_DUP_CC_REF_NUM');
3544: FND_MESSAGE.SET_TOKEN('CC_REF_NUM', p_cc_ref_num);
3545: FND_MSG_PUB.ADD;
3546: x_msg_data := FND_MESSAGE.GET;
3547: x_return_status := FND_API.G_RET_STS_ERROR;
3548: x_msg_count := 1;
3549:

Line 3599: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

3595: END IF;
3596:
3597: ROLLBACK to CC_Link_API_PT;
3598:
3599: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3601: l_api_name);
3602: END IF;
3603: -- Bug 3199488

Line 3600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

3596:
3597: ROLLBACK to CC_Link_API_PT;
3598:
3599: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3601: l_api_name);
3602: END IF;
3603: -- Bug 3199488
3604: IF ( g_unexp_level >= g_debug_level ) THEN

Line 3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3671:
3672:
3673: -- Ensure the responsibility id passed is valid
3674: IF p_responsibility_id IS NULL THEN
3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3676: THEN
3677: FND_MESSAGE.SET_NAME('IGC','IGC_RESP_ID_INVALID');
3678: FND_MSG_PUB.add;
3679: END IF;

Line 3678: FND_MSG_PUB.add;

3674: IF p_responsibility_id IS NULL THEN
3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3676: THEN
3677: FND_MESSAGE.SET_NAME('IGC','IGC_RESP_ID_INVALID');
3678: FND_MSG_PUB.add;
3679: END IF;
3680:
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;

Line 3687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3683:
3684: OPEN l_resp_csr;
3685: FETCH l_resp_csr INTO l_dummy;
3686: IF l_resp_csr%NOTFOUND THEN
3687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3688: FND_MESSAGE.SET_NAME('IGC','IGC_RESP_ID_INVALID');
3689: FND_MSG_PUB.add;
3690: END IF;
3691: CLOSE l_resp_csr;

Line 3689: FND_MSG_PUB.add;

3685: FETCH l_resp_csr INTO l_dummy;
3686: IF l_resp_csr%NOTFOUND THEN
3687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3688: FND_MESSAGE.SET_NAME('IGC','IGC_RESP_ID_INVALID');
3689: FND_MSG_PUB.add;
3690: END IF;
3691: CLOSE l_resp_csr;
3692: RAISE FND_API.G_EXC_ERROR;
3693: ELSE

Line 3699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3695: END IF;
3696:
3697: -- Ensure the user id passed is valid
3698: IF p_user_id IS NULL THEN
3699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3700: THEN
3701: FND_MESSAGE.SET_NAME('IGC','IGC_USER_ID_INVALID');
3702: FND_MSG_PUB.add;
3703: END IF;

Line 3702: FND_MSG_PUB.add;

3698: IF p_user_id IS NULL THEN
3699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3700: THEN
3701: FND_MESSAGE.SET_NAME('IGC','IGC_USER_ID_INVALID');
3702: FND_MSG_PUB.add;
3703: END IF;
3704:
3705: RAISE FND_API.G_EXC_ERROR;
3706: END IF;

Line 3712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3708:
3709: OPEN l_user_csr ;
3710: FETCH l_user_csr INTO l_dummy;
3711: IF l_user_csr%NOTFOUND THEN
3712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3713: FND_MESSAGE.SET_NAME('IGC','IGC_USER_ID_INVALID');
3714: FND_MSG_PUB.add;
3715: END IF;
3716: CLOSE l_user_csr;

Line 3714: FND_MSG_PUB.add;

3710: FETCH l_user_csr INTO l_dummy;
3711: IF l_user_csr%NOTFOUND THEN
3712: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3713: FND_MESSAGE.SET_NAME('IGC','IGC_USER_ID_INVALID');
3714: FND_MSG_PUB.add;
3715: END IF;
3716: CLOSE l_user_csr;
3717: RAISE FND_API.G_EXC_ERROR;
3718: ELSE

Line 3739: FND_MSG_PUB.Initialize;

3735:
3736: l_operating_unit_id := GET_VALID_OU(p_operating_unit_id, l_product_code);
3737:
3738: IF l_operating_unit_id IS NULL THEN
3739: FND_MSG_PUB.Initialize;
3740:
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3739: FND_MSG_PUB.Initialize;
3740:
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3744:
3745: FND_MESSAGE.SET_NAME('IGC','IGC_MOAC_PASS_VALID_ORG');
3746: FND_MSG_PUB.add;
3747: FND_MSG_PUB.Count_And_Get

Line 3746: FND_MSG_PUB.add;

3742:
3743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3744:
3745: FND_MESSAGE.SET_NAME('IGC','IGC_MOAC_PASS_VALID_ORG');
3746: FND_MSG_PUB.add;
3747: FND_MSG_PUB.Count_And_Get
3748: ( p_count => x_msg_count ,
3749: p_data => x_msg_data );
3750: END IF;

Line 3747: FND_MSG_PUB.Count_And_Get

3743: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3744:
3745: FND_MESSAGE.SET_NAME('IGC','IGC_MOAC_PASS_VALID_ORG');
3746: FND_MSG_PUB.add;
3747: FND_MSG_PUB.Count_And_Get
3748: ( p_count => x_msg_count ,
3749: p_data => x_msg_data );
3750: END IF;
3751: else

Line 3769: FND_MSG_PUB.Count_And_Get

3765: THEN
3766:
3767: x_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: FND_MSG_PUB.Count_And_Get
3770: ( p_count => x_msg_count ,
3771: p_data => x_msg_data );
3772:
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3777: FND_MSG_PUB.Count_And_Get

3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3774: THEN
3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3776:
3777: FND_MSG_PUB.Count_And_Get
3778: ( p_count => x_msg_count ,
3779: p_data => x_msg_data );
3780:
3781: WHEN OTHERS

Line 3786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3782: THEN
3783:
3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3785:
3786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3787: THEN
3788: FND_MSG_PUB.add_exc_msg
3789: ( p_pkg_name => G_PKG_NAME
3790: , p_procedure_name => l_api_name );

Line 3788: FND_MSG_PUB.add_exc_msg

3784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3785:
3786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3787: THEN
3788: FND_MSG_PUB.add_exc_msg
3789: ( p_pkg_name => G_PKG_NAME
3790: , p_procedure_name => l_api_name );
3791:
3792: END IF;

Line 3794: FND_MSG_PUB.Count_And_Get

3790: , p_procedure_name => l_api_name );
3791:
3792: END IF;
3793:
3794: FND_MSG_PUB.Count_And_Get
3795: ( p_count => x_msg_count ,
3796: p_data => x_msg_data );
3797:
3798: END Set_global_info;