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 FND_MESSAGE

Line 195: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');

191: BEGIN
192: RETURN TO_DATE(X_date, G_date_format);
193: EXCEPTION
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;

Line 196: FND_MESSAGE.set_token('DATE', X_date);

192: RETURN TO_DATE(X_date, G_date_format);
193: EXCEPTION
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:

Line 197: FND_MESSAGE.set_token('FORMAT', G_date_format);

193: EXCEPTION
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:

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 207: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');

203: BEGIN
204: RETURN TO_DATE(X_date, G_date_format || ' ' || G_timestamp_format);
205: EXCEPTION
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;

Line 208: FND_MESSAGE.set_token('DATE', X_date);

204: RETURN TO_DATE(X_date, G_date_format || ' ' || G_timestamp_format);
205: EXCEPTION
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:

Line 209: FND_MESSAGE.set_token('FORMAT', G_date_format);

205: EXCEPTION
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:

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 605: cep_standard.debug(FND_MESSAGE.get);

601: '','','','','','','','','','',
602: '','','','','','','','','','');
603: IF l_request_id = 0 THEN
604: IF l_DEBUG in ('Y', 'C') THEN
605: cep_standard.debug(FND_MESSAGE.get);
606: cep_standard.debug('EXCEPTION: Fail to submit cuncurrent request for '|| l_program_name);
607: END IF;
608: RAISE ldr_exception;
609: END IF;

Line 611: FND_MESSAGE.set_name('CE', 'CE_ERROR_EXIST');

607: END IF;
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

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 1402: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');

1398:
1399: l_cnt NUMBER;
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;

Line 1403: FND_MESSAGE.set_token('FIELD', 'BANK_ACCOUNT_NUM');

1399: l_cnt NUMBER;
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;

Line 1405: G_rec_no, fnd_message.get, 'E');

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:
1409: SELECT count(*)

Line 1417: FND_MESSAGE.set_name('CE', 'CE_BANK_ACCNT_NOT_DEFINED');

1413: and NVL(ACCOUNT_CLASSIFICATION,'DUMMY') = 'INTERNAL'; -- Bug 6511845
1414: --and NVL(ACCOUNT_TYPE,'DUMMY') = 'INTERNAL'; -- Bug 3368534 added this line.
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.

Line 1418: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);

1414: --and NVL(ACCOUNT_TYPE,'DUMMY') = 'INTERNAL'; -- Bug 3368534 added this line.
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');

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 1422: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');

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);
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

Line 1423: 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);
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;

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 1506: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

1502: END IF;
1503: EXCEPTION
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));

Line 1507: FND_MESSAGE.set_token('ERR', to_char(l_err));

1503: EXCEPTION
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;

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 1878: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

1874: END IF;
1875: EXCEPTION -- Bug 3608257 added this EXCEPTION section
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;

Line 1879: FND_MESSAGE.set_token('ERR', to_char(l_err));

1875: EXCEPTION -- Bug 3608257 added this EXCEPTION section
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:

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 1943: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

1939: END IF;
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;

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 1952: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

1948: Init_Line_Rec;
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

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 1975: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');

1971: cep_standard.debug('G_statement_date = '|| G_statement_date);
1972: END IF;
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;

Line 1976: FND_MESSAGE.set_token('FIELD', 'STATEMENT_NUMBER');

1972: END IF;
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;

Line 1978: C_rec.rec_no, fnd_message.get);

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:
1982: IF G_statement_date IS NULL THEN

Line 1983: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');

1979: EXIT;
1980: END IF;
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;

Line 1984: FND_MESSAGE.set_token('FIELD', 'STATEMENT_DATE');

1980: END IF;
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;

Line 1986: C_rec.rec_no, fnd_message.get);

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:
1990: l_statement_date := G_statement_date;

Line 2203: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');

2199: l_rec_cnt := l_rec_cnt + 1;
2200: l_line_cnt := 0;
2201:
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;

Line 2204: FND_MESSAGE.set_token('GIVEN', C_rec.col2);

2200: l_line_cnt := 0;
2201:
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:

Line 2205: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));

2201:
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);

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 2220: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

2216: Init_Hdr_Rec;
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:

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 2336: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

2332: END IF;
2333: EXCEPTION
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));

Line 2337: FND_MESSAGE.set_token('ERR', to_char(l_err));

2333: EXCEPTION
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;

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 2406: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

2402: END IF;
2403: EXCEPTION
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));

Line 2407: FND_MESSAGE.set_token('ERR', to_char(l_err));

2403: EXCEPTION
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;

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 2603: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');

2599: ELSIF l_hdr_or_line = 'B' THEN
2600: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 2604: FND_MESSAGE.set_token('RECID', C_rec.rec_id_no);

2600: IF l_DEBUG in ('Y', 'C') THEN
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;

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 2980: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');

2976: END IF;
2977: Delete_Orphaned_Lines;
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

Line 2981: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));

2977: Delete_Orphaned_Lines;
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');

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 2985: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_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));
2987: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
2988: END IF;
2989:

Line 2986: FND_MESSAGE.set_token('CNT', to_char(G_total_line_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));
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);

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 3003: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');

2999: WHEN SQL_LOADER_ERROR THEN
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');

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 3007: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');

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);
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

Line 3008: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);

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);
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;

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