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.CE_BANK_STATEMENT_LOADER dependencies on CE_SQLLDR_ERRORS_PKG

Line 198: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');

194: WHEN OTHERS THEN
195: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
196: FND_MESSAGE.set_token('DATE', X_date);
197: FND_MESSAGE.set_token('FORMAT', G_date_format);
198: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
199: END;
200:
201:
202: FUNCTION CONV_TIMESTAMP(X_date VARCHAR2) RETURN DATE IS

Line 210: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');

206: WHEN OTHERS THEN
207: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
208: FND_MESSAGE.set_token('DATE', X_date);
209: FND_MESSAGE.set_token('FORMAT', G_date_format);
210: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
211: END;
212:
213:
214: FUNCTION Is_Number (X_string VARCHAR2) RETURN BOOLEAN IS

Line 612: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'W');

608: RAISE ldr_exception;
609: END IF;
610: ELSE
611: FND_MESSAGE.set_name('CE', 'CE_ERROR_EXIST');
612: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'W');
613: END IF;
614:
615: -- END IF; --org_id
616: END IF;

Line 1404: CE_SQLLDR_ERRORS_PKG.insert_row(NVL(G_statement_number, 'XXXXXXXXXXX'), NVL(G_bank_account_num, 'XXXXXXXXXXX'),

1400: BEGIN
1401: IF G_bank_account_num IS NULL THEN
1402: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
1403: FND_MESSAGE.set_token('FIELD', 'BANK_ACCOUNT_NUM');
1404: CE_SQLLDR_ERRORS_PKG.insert_row(NVL(G_statement_number, 'XXXXXXXXXXX'), NVL(G_bank_account_num, 'XXXXXXXXXXX'),
1405: G_rec_no, fnd_message.get, 'E');
1406: RETURN FALSE;
1407: END IF;
1408:

Line 1419: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');

1415:
1416: IF l_cnt = 0 THEN -- Bank account is not setup.
1417: FND_MESSAGE.set_name('CE', 'CE_BANK_ACCNT_NOT_DEFINED');
1418: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1419: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');
1420: RETURN FALSE;
1421: ELSIF l_cnt > 1 THEN -- There are more than one bank with this account number.
1422: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');
1423: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);

Line 1424: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');

1420: RETURN FALSE;
1421: ELSIF l_cnt > 1 THEN -- There are more than one bank with this account number.
1422: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');
1423: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1424: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
1425: ELSE
1426: IF ( G_bank_name IS NULL OR G_bank_branch_name IS NULL OR G_hdr_currency_code IS NULL) THEN
1427: OPEN C_bank;
1428: FETCH C_bank INTO G_bank_name, G_bank_branch_name, G_sub_branch_id, G_sub_account_id, G_hdr_currency_code; --, G_org_id;

Line 1508: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

1504: WHEN OTHERS THEN
1505: l_err := SQLCODE;
1506: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
1507: FND_MESSAGE.set_token('ERR', to_char(l_err));
1508: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
1509: IF l_DEBUG in ('Y', 'C') THEN
1510: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_BAI - '|| to_char(l_err));
1511: END IF;
1512: END Decode_Line_BAI;

Line 1880: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

1876: WHEN OTHERS THEN
1877: l_err := SQLCODE;
1878: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
1879: FND_MESSAGE.set_token('ERR', to_char(l_err));
1880: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
1881: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_BAI - '|| to_char(l_err));
1882: END Decode_Hdr_BAI;
1883:
1884: /* ---------------------------------------------------------------------

Line 1944: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

1940:
1941: IF ( G_rec_no = 1 AND
1942: C_rec.rec_id_no <> '01' ) THEN
1943: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
1944: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
1945: EXIT;
1946: ELSIF C_rec.rec_id_no = '01' THEN
1947: Init_Hdr_Rec;
1948: Init_Line_Rec;

Line 1953: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

1949: l_line_cnt := 0;
1950: l_last_rid := '1';
1951: IF nvl(C_rec.col8,'X') <> '2' THEN
1952: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
1953: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
1954: EXIT;
1955: END IF;
1956: ELSIF C_rec.rec_id_no = '02' THEN
1957:

Line 1977: CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),

1973:
1974: IF G_statement_number IS NULL THEN
1975: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
1976: FND_MESSAGE.set_token('FIELD', 'STATEMENT_NUMBER');
1977: CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),
1978: C_rec.rec_no, fnd_message.get);
1979: EXIT;
1980: END IF;
1981:

Line 1985: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),

1981:
1982: IF G_statement_date IS NULL THEN
1983: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
1984: FND_MESSAGE.set_token('FIELD', 'STATEMENT_DATE');
1985: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),
1986: C_rec.rec_no, fnd_message.get);
1987: EXIT;
1988: END IF;
1989:

Line 2206: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);

2202: IF (nvl(to_number(C_rec.col2), l_rec_cnt) <> l_rec_cnt) THEN
2203: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');
2204: FND_MESSAGE.set_token('GIVEN', C_rec.col2);
2205: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));
2206: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);
2207: END IF;
2208:
2209: G_statement_date := nvl(G_statement_date, l_statement_date);
2210: /* 2643505 Added the IF Condition */

Line 2221: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');

2217: l_control_total_cr := 0;
2218: l_control_total_dr := 0;
2219: ELSIF C_rec.rec_id_no NOT IN ('98', '99') THEN
2220: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2221: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2222: EXIT;
2223: END IF;
2224:
2225: END LOOP;

Line 2338: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

2334: WHEN OTHERS THEN
2335: l_err := SQLCODE;
2336: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2337: FND_MESSAGE.set_token('ERR', to_char(l_err));
2338: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2339: IF l_DEBUG in ('Y', 'C') THEN
2340: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_Other - '|| to_char(l_err));
2341: END IF;
2342: END Decode_Hdr_Other;

Line 2408: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);

2404: WHEN OTHERS THEN
2405: l_err := SQLCODE;
2406: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2407: FND_MESSAGE.set_token('ERR', to_char(l_err));
2408: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2409: IF l_DEBUG in ('Y', 'C') THEN
2410: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_Other - '||to_char(l_err));
2411: END IF;
2412: END Decode_Line_Other;

Line 2605: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');

2601: cep_standard.debug('This rec_id '|| C_rec.rec_id_no ||' is assigned for both header and line');
2602: END IF;
2603: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');
2604: FND_MESSAGE.set_token('RECID', C_rec.rec_id_no);
2605: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');
2606: EXIT;
2607: END IF;
2608: END LOOP;
2609:

Line 2982: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);

2978:
2979: IF ( nvl(G_total_hdr_deleted, 0) <> 0 ) THEN
2980: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');
2981: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));
2982: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
2983: END IF;
2984: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
2985: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
2986: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));

Line 2987: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);

2983: END IF;
2984: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
2985: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
2986: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));
2987: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
2988: END IF;
2989:
2990: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
2991:

Line 3004: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');

3000: IF l_DEBUG in ('Y', 'C') THEN
3001: cep_standard.debug('EXCEPTION: Load_Bank_Statement - Sql*Loader was not finished');
3002: END IF;
3003: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');
3004: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3005: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3006: WHEN INVALID_DATA_FILE THEN
3007: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3008: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);

Line 3009: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');

3005: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3006: WHEN INVALID_DATA_FILE THEN
3007: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3008: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);
3009: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3010: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3011: WHEN OTHERS THEN
3012: l_err := SQLCODE;
3013: IF l_DEBUG in ('Y', 'C') THEN