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_YEP_PROCESS_PKG dependencies on IGC_CC_PROCESS_EXCEPTIONS

Line 88: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;

84: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;
85: l_Last_Updated_By NUMBER := FND_GLOBAL.USER_ID;
86: l_Last_Update_Login NUMBER := FND_GLOBAL.LOGIN_ID;
87: l_Created_By NUMBER := FND_GLOBAL.USER_ID;
88: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
89: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE:= NULL;
90: l_CC_ENCMBRNC_STATUS IGC_CC_HEADERS.CC_ENCMBRNC_STATUS%TYPE;
91:
92: l_func_amt NUMBER;

Line 246: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

242: IF(g_excep_level >= g_debug_level) THEN
243: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
244: END IF;
245: l_EXCEPTION := FND_MESSAGE.GET;
246: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
247: (PROCESS_TYPE,
248: PROCESS_PHASE,
249: CC_HEADER_ID,
250: CC_ACCT_LINE_ID,

Line 353: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

349: END IF;
350: l_EXCEPTION := FND_MESSAGE.GET;
351:
352:
353: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
354: (PROCESS_TYPE,
355: PROCESS_PHASE,
356: CC_HEADER_ID,
357: CC_ACCT_LINE_ID,

Line 467: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

463: END IF;
464: l_EXCEPTION := FND_MESSAGE.GET;
465:
466:
467: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
468: (PROCESS_TYPE,
469: PROCESS_PHASE,
470: CC_HEADER_ID,
471: CC_ACCT_LINE_ID,

Line 574: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

570: END IF;
571: l_EXCEPTION := FND_MESSAGE.GET;
572:
573:
574: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
575: (PROCESS_TYPE,
576: PROCESS_PHASE,
577: CC_HEADER_ID,
578: CC_ACCT_LINE_ID,

Line 675: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

671: END IF;
672: l_EXCEPTION := FND_MESSAGE.GET;
673:
674:
675: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
676: (PROCESS_TYPE,
677: PROCESS_PHASE,
678: CC_HEADER_ID,
679: CC_ACCT_LINE_ID,

Line 800: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

796: END IF;
797: l_EXCEPTION := FND_MESSAGE.GET;
798:
799:
800: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
801: (PROCESS_TYPE,
802: PROCESS_PHASE,
803: CC_HEADER_ID,
804: CC_ACCT_LINE_ID,

Line 873: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

869: END IF;
870: l_EXCEPTION := FND_MESSAGE.GET;
871:
872:
873: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
874: (PROCESS_TYPE,
875: PROCESS_PHASE,
876: CC_HEADER_ID,
877: CC_ACCT_LINE_ID,

Line 1100: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;

1096: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(12000);
1100: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;
1101: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
1102: l_error_text VARCHAR2(12000);
1103: l_CC_NUM IGC_CC_HEADERS.CC_NUM%TYPE;
1104: l_invalid_counter NUMBER;

Line 1101: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;

1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(12000);
1100: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;
1101: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;
1102: l_error_text VARCHAR2(12000);
1103: l_CC_NUM IGC_CC_HEADERS.CC_NUM%TYPE;
1104: l_invalid_counter NUMBER;
1105:

Line 1215: igc_cc_process_exceptions

1211:
1212: IF (l_budg_status = FALSE) AND (l_usr_msg IS NOT NULL)
1213: THEN
1214: INSERT INTO
1215: igc_cc_process_exceptions
1216: (process_type,
1217: process_phase,
1218: cc_header_id,
1219: cc_acct_line_id,

Line 1445: DELETE FROM IGC_CC_PROCESS_EXCEPTIONS B

1441: /* Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id */
1442: AND A.ORG_ID = l_org_id
1443: AND A.SET_OF_BOOKS_ID = l_sob_id;
1444:
1445: DELETE FROM IGC_CC_PROCESS_EXCEPTIONS B
1446: WHERE B.PROCESS_TYPE = 'Y'
1447: /* Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id */
1448: AND B.ORG_ID = l_org_id
1449: AND B.SET_OF_BOOKS_ID = l_sob_id;

Line 1517: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1513: END IF;
1514: l_EXCEPTION := FND_MESSAGE.GET;
1515:
1516:
1517: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1518: (PROCESS_TYPE,
1519: PROCESS_PHASE,
1520: CC_HEADER_ID,
1521: CC_ACCT_LINE_ID,

Line 1711: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1707: END IF;
1708: l_EXCEPTION := FND_MESSAGE.GET;
1709:
1710:
1711: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1712: (PROCESS_TYPE,
1713: PROCESS_PHASE,
1714: CC_HEADER_ID,
1715: CC_ACCT_LINE_ID,

Line 1755: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1751: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
1752: END IF;
1753: l_EXCEPTION := FND_MESSAGE.GET;
1754:
1755: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1756: (PROCESS_TYPE,
1757: PROCESS_PHASE,
1758: CC_HEADER_ID,
1759: CC_ACCT_LINE_ID,

Line 1815: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1811: END IF;
1812: l_EXCEPTION := FND_MESSAGE.GET;
1813:
1814:
1815: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1816: (PROCESS_TYPE,
1817: PROCESS_PHASE,
1818: CC_HEADER_ID,
1819: CC_ACCT_LINE_ID,

Line 1855: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1851: END IF;
1852: l_EXCEPTION := FND_MESSAGE.GET;
1853:
1854:
1855: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1856: (PROCESS_TYPE,
1857: PROCESS_PHASE,
1858: CC_HEADER_ID,
1859: CC_ACCT_LINE_ID,

Line 1898: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1894: END IF;
1895: l_EXCEPTION := FND_MESSAGE.GET;
1896:
1897:
1898: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1899: (PROCESS_TYPE,
1900: PROCESS_PHASE,
1901: CC_HEADER_ID,
1902: CC_ACCT_LINE_ID,

Line 1938: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1934: END IF;
1935: l_EXCEPTION := FND_MESSAGE.GET;
1936:
1937:
1938: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1939: (PROCESS_TYPE,
1940: PROCESS_PHASE,
1941: CC_HEADER_ID,
1942: CC_ACCT_LINE_ID,

Line 1980: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

1976: END IF;
1977: l_EXCEPTION := FND_MESSAGE.GET;
1978:
1979:
1980: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
1981: (PROCESS_TYPE,
1982: PROCESS_PHASE,
1983: CC_HEADER_ID,
1984: CC_ACCT_LINE_ID,

Line 2014: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2010: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2011: END IF;
2012: l_EXCEPTION := FND_MESSAGE.GET;
2013:
2014: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2015: (PROCESS_TYPE,
2016: PROCESS_PHASE,
2017: CC_HEADER_ID,
2018: CC_ACCT_LINE_ID,

Line 2057: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2053: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2054: END IF;
2055: l_EXCEPTION := FND_MESSAGE.GET;
2056:
2057: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2058: (PROCESS_TYPE,
2059: PROCESS_PHASE,
2060: CC_HEADER_ID,
2061: CC_ACCT_LINE_ID,

Line 2091: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2087: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2088: END IF;
2089: l_EXCEPTION := FND_MESSAGE.GET;
2090:
2091: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2092: (PROCESS_TYPE,
2093: PROCESS_PHASE,
2094: CC_HEADER_ID,
2095: CC_ACCT_LINE_ID,

Line 2500: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2496: END IF;
2497: l_EXCEPTION := FND_MESSAGE.GET;
2498:
2499:
2500: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2501: (PROCESS_TYPE,
2502: PROCESS_PHASE,
2503: CC_HEADER_ID,
2504: CC_ACCT_LINE_ID,

Line 2629: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2625: FND_LOG.MESSAGE(g_excep_level, l_full_path, FALSE);
2626: END IF;
2627: l_EXCEPTION := FND_MESSAGE.GET;
2628:
2629: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2630: (PROCESS_TYPE,
2631: PROCESS_PHASE,
2632: CC_HEADER_ID,
2633: CC_ACCT_LINE_ID,

Line 2704: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

2700: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_VALIDATE_ALL');
2701: l_EXCEPTION := FND_MESSAGE.GET;
2702:
2703:
2704: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
2705: (PROCESS_TYPE,
2706: PROCESS_PHASE,
2707: CC_HEADER_ID,
2708: CC_ACCT_LINE_ID,