DBA Data[Home] [Help]

APPS.IGC_CC_REVALUE_PROCESS_PKG dependencies on IGC_CC_PROCESS_EXCEPTIONS

Line 48: l_message igc_cc_process_exceptions.exception_reason%TYPE;

44: IS
45: l_period_status gl_period_statuses.closing_status%TYPE;
46: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;
47: l_rate NUMBER;
48: l_message igc_cc_process_exceptions.exception_reason%TYPE;
49: BEGIN
50:
51: -- IF l_debug_mode = 'Y' THEN
52: -- Output_Debug (' IGCCREPB -- Validate Params begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 105: igc_cc_process_exceptions

101: FND_MESSAGE.SET_TOKEN('RATE',TO_CHAR(p_rate),TRUE);
102: l_message := FND_MESSAGE.GET;
103:
104: INSERT INTO
105: igc_cc_process_exceptions
106: ( process_type,
107: process_phase,
108: cc_header_id,
109: cc_acct_line_id,

Line 178: igc_cc_process_exceptions

174: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
175: l_message := FND_MESSAGE.GET;
176:
177: INSERT INTO
178: igc_cc_process_exceptions
179: ( process_type,
180: process_phase,
181: cc_header_id,
182: cc_acct_line_id,

Line 236: igc_cc_process_exceptions

232: FND_MESSAGE.SET_TOKEN('DATE',to_char(p_rate_date ,'DD-MON-YYYY') ,TRUE);
233: l_message := FND_MESSAGE.GET;
234:
235: INSERT INTO
236: igc_cc_process_exceptions
237: ( process_type,
238: process_phase,
239: cc_header_id,
240: cc_acct_line_id,

Line 287: l_message igc_cc_process_exceptions.exception_reason%TYPE;

283: RETURN BOOLEAN
284: IS
285: l_lock_cc BOOLEAN;
286: l_lock_po BOOLEAN;
287: l_message igc_cc_process_exceptions.exception_reason%TYPE;
288: l_cc_num igc_cc_headers.cc_num%TYPE;
289: BEGIN
290:
291: --GSCC Warnings Fixed

Line 326: INTO igc_cc_process_exceptions

322: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
323: l_message := FND_MESSAGE.GET;
324:
325: INSERT
326: INTO igc_cc_process_exceptions
327: ( process_type,
328: process_phase,
329: cc_header_id,
330: cc_acct_line_id,

Line 364: INTO igc_cc_process_exceptions

360: FND_MESSAGE.SET_TOKEN('CC_NUM', l_cc_num ,TRUE);
361: l_message := FND_MESSAGE.GET;
362:
363: INSERT
364: INTO igc_cc_process_exceptions
365: ( process_type,
366: process_phase,
367: cc_header_id,
368: cc_acct_line_id,

Line 438: l_exception igc_cc_process_exceptions.exception_reason%TYPE;

434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
437:
438: l_exception igc_cc_process_exceptions.exception_reason%TYPE;
439: l_action_hist_msg igc_cc_actions.cc_action_notes%TYPE;
440:
441: CURSOR c_acct_lines(p_cc_header_id NUMBER)
442: IS

Line 1513: l_message igc_cc_process_exceptions.exception_reason%TYPE;

1509: p_sob_id NUMBER,
1510: p_org_id NUMBER,
1511: p_request_id NUMBER)
1512: IS
1513: l_message igc_cc_process_exceptions.exception_reason%TYPE;
1514: BEGIN
1515: /* Update validation_status to 'F' in temporary table for releases */
1516:
1517: -- IF l_debug_mode = 'Y' THEN

Line 1538: INTO igc_cc_process_exceptions

1534: FND_MESSAGE.SET_NAME('IGC','IGC_CC_AVAILABLE_AMT_EXCEEDED');
1535: l_message := FND_MESSAGE.GET;
1536:
1537: INSERT
1538: INTO igc_cc_process_exceptions
1539: (process_type,
1540: process_phase,
1541: cc_header_id,
1542: cc_acct_line_id,

Line 1628: l_message igc_cc_process_exceptions.exception_reason%TYPE;

1624: l_cover_not_found BOOLEAN;
1625: l_cc_not_found BOOLEAN;
1626: l_approval_status VARCHAR2(2);
1627:
1628: l_message igc_cc_process_exceptions.exception_reason%TYPE;
1629: -- l_debug VARCHAR2(1);
1630:
1631: l_currency_code gl_sets_of_books.currency_code%TYPE;
1632: l_sbc_on BOOLEAN;

Line 1651: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;

1647: l_cover_pf_func_amt NUMBER;
1648: l_msg_count NUMBER;
1649: l_msg_data VARCHAR2(12000);
1650: l_error_text VARCHAR2(12000);
1651: l_usr_msg igc_cc_process_exceptions.exception_reason%TYPE;
1652:
1653: -- Bug 2441322
1654: l_rate NUMBER;
1655:

Line 2051: igc_cc_process_exceptions

2047:
2048: IF (l_budg_status = FALSE) AND (l_usr_msg IS NOT NULL)
2049: THEN
2050: INSERT INTO
2051: igc_cc_process_exceptions
2052: (process_type,
2053: process_phase,
2054: cc_header_id,
2055: cc_acct_line_id,

Line 4363: igc_cc_process_exceptions

4359: END IF;
4360: -- bug 3199488, end block
4361:
4362: INSERT INTO
4363: igc_cc_process_exceptions
4364: ( process_type,
4365: process_phase,
4366: cc_header_id,
4367: cc_acct_line_id,

Line 4671: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

4667: -- bug 3199488, end block
4668:
4669: ROLLBACK TO REVALUE5;
4670:
4671: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
4672: (PROCESS_TYPE,
4673: PROCESS_PHASE,
4674: CC_HEADER_ID,
4675: CC_ACCT_LINE_ID,

Line 4800: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

4796: END IF;
4797: -- bug 3199488, end block
4798: ROLLBACK TO REVALUE6;
4799:
4800: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
4801: (PROCESS_TYPE,
4802: PROCESS_PHASE,
4803: CC_HEADER_ID,
4804: CC_ACCT_LINE_ID,

Line 4865: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS

4861: l_message := NULL;
4862: FND_MESSAGE.SET_NAME('IGC','IGC_CC_REP_NO_CC_SELECTED');
4863: l_message := FND_MESSAGE.GET;
4864:
4865: INSERT INTO IGC_CC_PROCESS_EXCEPTIONS
4866: (PROCESS_TYPE,
4867: PROCESS_PHASE,
4868: CC_HEADER_ID,
4869: CC_ACCT_LINE_ID,