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

Line 295: l_message igc_cc_process_exceptions.exception_reason%TYPE;

291: IS
292: l_period_status gl_period_statuses.closing_status%TYPE;
293: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;
294: l_rate NUMBER;
295: l_message igc_cc_process_exceptions.exception_reason%TYPE;
296: l_cc_num igc_cc_headers.cc_num%TYPE;
297: BEGIN
298:
299: BEGIN

Line 335: igc_cc_process_exceptions

331: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
332: l_message := FND_MESSAGE.GET;
333:
334: INSERT INTO
335: igc_cc_process_exceptions
336: ( process_type,
337: process_phase,
338: cc_header_id,
339: cc_acct_line_id,

Line 407: igc_cc_process_exceptions

403: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
404: l_message := FND_MESSAGE.GET;
405:
406: INSERT INTO
407: igc_cc_process_exceptions
408: ( process_type,
409: process_phase,
410: cc_header_id,
411: cc_acct_line_id,

Line 465: igc_cc_process_exceptions

461: FND_MESSAGE.SET_TOKEN('DATE',to_char( p_revalue_fix_date,'DD-MON-YYYY') ,TRUE);
462: l_message := FND_MESSAGE.GET;
463:
464: INSERT INTO
465: igc_cc_process_exceptions
466: ( process_type,
467: process_phase,
468: cc_header_id,
469: cc_acct_line_id,

Line 507: l_message igc_cc_process_exceptions.exception_reason%TYPE;

503: RETURN BOOLEAN
504: IS
505: l_lock_cc BOOLEAN := TRUE;
506: l_lock_po BOOLEAN := TRUE;
507: l_message igc_cc_process_exceptions.exception_reason%TYPE;
508: l_cc_num igc_cc_headers.cc_num%TYPE;
509: BEGIN
510:
511: SELECT cc_num

Line 531: INTO igc_cc_process_exceptions

527: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
528: l_message := FND_MESSAGE.GET;
529:
530: INSERT
531: INTO igc_cc_process_exceptions
532: ( process_type,
533: process_phase,
534: cc_header_id,
535: cc_acct_line_id,

Line 570: INTO igc_cc_process_exceptions

566: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
567: l_message := FND_MESSAGE.GET;
568:
569: INSERT
570: INTO igc_cc_process_exceptions
571: ( process_type,
572: process_phase,
573: cc_header_id,
574: cc_acct_line_id,

Line 632: l_exception igc_cc_process_exceptions.exception_reason%TYPE;

628: l_cc_headers_rec igc_cc_headers%ROWTYPE;
629: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
630: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
631: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
632: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
633: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
634:
635:
636: CURSOR c_acct_lines(p_cc_header_id NUMBER)

Line 1560: l_message igc_cc_process_exceptions.exception_reason%TYPE;

1556: p_sob_id NUMBER,
1557: p_org_id NUMBER,
1558: p_request_id NUMBER)
1559: IS
1560: l_message igc_cc_process_exceptions.exception_reason%TYPE;
1561: BEGIN
1562: /* Update validation_status to 'F' in temporary table for releases */
1563:
1564: UPDATE igc_cc_process_data a

Line 1574: INTO igc_cc_process_exceptions

1570: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1571: l_message := FND_MESSAGE.GET;
1572:
1573: INSERT
1574: INTO igc_cc_process_exceptions
1575: (process_type,
1576: process_phase,
1577: cc_header_id,
1578: cc_acct_line_id,

Line 1630: l_message igc_cc_process_exceptions.exception_reason%TYPE;

1626: l_reservation_status VARCHAR2(1);
1627: l_processed VARCHAR2(1);
1628: l_validate_only VARCHAR2(1);
1629: l_process_flag VARCHAR2(1);
1630: l_message igc_cc_process_exceptions.exception_reason%TYPE;
1631:
1632: l_cc_count NUMBER := 0;
1633: l_invalid_cc_count NUMBER := 0;
1634: l_po_count NUMBER := 0;

Line 1666: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;

1662: l_cover_pf_func_amt NUMBER := 0;
1663: l_msg_count NUMBER := 0;
1664: l_msg_data VARCHAR2(12000);
1665: l_error_text VARCHAR2(12000);
1666: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;
1667:
1668: l_err_header_id NUMBER;
1669: l_err_acct_line_id NUMBER;
1670: l_err_det_pf_line_id NUMBER;

Line 1965: igc_cc_process_exceptions

1961:
1962: IF (l_budg_status = FALSE) AND (l_usr_msg IS NOT NULL)
1963: THEN
1964: INSERT INTO
1965: igc_cc_process_exceptions
1966: (process_type,
1967: process_phase,
1968: cc_header_id,
1969: cc_acct_line_id,

Line 2948: igc_cc_process_exceptions

2944: FND_MESSAGE.SET_NAME('IGC','IGC_CC_ENCUMBRANCE_FAILURE');
2945: l_message := FND_MESSAGE.GET;
2946:
2947: INSERT INTO
2948: igc_cc_process_exceptions
2949: ( process_type,
2950: process_phase,
2951: cc_header_id,
2952: cc_acct_line_id,

Line 3058: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

3054: IF (l_process_flag = 'F')
3055: THEN
3056: ROLLBACK TO REVALUE5;
3057:
3058: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
3059: (PROCESS_TYPE,
3060: PROCESS_PHASE,
3061: CC_HEADER_ID,
3062: CC_ACCT_LINE_ID,

Line 3112: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

3108: IF (l_process_flag = 'F')
3109: THEN
3110: ROLLBACK TO REVALUE5;
3111:
3112: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
3113: (PROCESS_TYPE,
3114: PROCESS_PHASE,
3115: CC_HEADER_ID,
3116: CC_ACCT_LINE_ID,

Line 3216: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

3212: ROLLBACK TO REVALUE5;
3213:
3214: /* Populate exceptions table */
3215:
3216: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
3217: (PROCESS_TYPE,
3218: PROCESS_PHASE,
3219: CC_HEADER_ID,
3220: CC_ACCT_LINE_ID,

Line 3293: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

3289: ROLLBACK TO REVALUE6;
3290:
3291: /* Populate exceptions table */
3292:
3293: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
3294: (PROCESS_TYPE,
3295: PROCESS_PHASE,
3296: CC_HEADER_ID,
3297: CC_ACCT_LINE_ID,

Line 3351: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

3347: ROLLBACK TO REVALUE6;
3348:
3349: /* Populate exceptions table */
3350:
3351: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
3352: (PROCESS_TYPE,
3353: PROCESS_PHASE,
3354: CC_HEADER_ID,
3355: CC_ACCT_LINE_ID,