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

157: ELSIF(l_number = 125) THEN
158: l_amount:=substr(amount,1,Length(amount)-1)||'0';
159: RETURN (To_Number(l_amount)*-1);
160: ELSE --8911035
161: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');
162: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
163: RETURN NULL;
164: END IF;
165: ELSE

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

158: l_amount:=substr(amount,1,Length(amount)-1)||'0';
159: RETURN (To_Number(l_amount)*-1);
160: ELSE --8911035
161: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');
162: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
163: RETURN NULL;
164: END IF;
165: ELSE
166: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');

Line 166: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');

162: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
163: RETURN NULL;
164: END IF;
165: ELSE
166: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');
167: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
168: RETURN NULL;
169: END IF; --8911035
170: -- If the amount is Numeric return the amount

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

163: RETURN NULL;
164: END IF;
165: ELSE
166: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT_AMOUNT');
167: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'W');
168: RETURN NULL;
169: END IF; --8911035
170: -- If the amount is Numeric return the amount
171: ELSIF(l_number=1) THEN

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

352: BEGIN
353: RETURN TO_DATE(X_date, G_date_format);
354: EXCEPTION
355: WHEN OTHERS THEN
356: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
357: FND_MESSAGE.set_token('DATE', X_date);
358: FND_MESSAGE.set_token('FORMAT', G_date_format);
359: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
360: END;

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

353: RETURN TO_DATE(X_date, G_date_format);
354: EXCEPTION
355: WHEN OTHERS THEN
356: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
357: FND_MESSAGE.set_token('DATE', X_date);
358: FND_MESSAGE.set_token('FORMAT', G_date_format);
359: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
360: END;
361:

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

354: EXCEPTION
355: WHEN OTHERS THEN
356: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
357: FND_MESSAGE.set_token('DATE', X_date);
358: FND_MESSAGE.set_token('FORMAT', G_date_format);
359: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
360: END;
361:
362:

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

355: WHEN OTHERS THEN
356: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
357: FND_MESSAGE.set_token('DATE', X_date);
358: FND_MESSAGE.set_token('FORMAT', G_date_format);
359: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
360: END;
361:
362:
363: FUNCTION CONV_TIMESTAMP(X_date VARCHAR2) RETURN DATE IS

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

364: BEGIN
365: RETURN TO_DATE(X_date, G_date_format || ' ' || G_timestamp_format);
366: EXCEPTION
367: WHEN OTHERS THEN
368: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
369: FND_MESSAGE.set_token('DATE', X_date);
370: FND_MESSAGE.set_token('FORMAT', G_date_format);
371: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
372: END;

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

365: RETURN TO_DATE(X_date, G_date_format || ' ' || G_timestamp_format);
366: EXCEPTION
367: WHEN OTHERS THEN
368: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
369: FND_MESSAGE.set_token('DATE', X_date);
370: FND_MESSAGE.set_token('FORMAT', G_date_format);
371: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
372: END;
373:

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

366: EXCEPTION
367: WHEN OTHERS THEN
368: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
369: FND_MESSAGE.set_token('DATE', X_date);
370: FND_MESSAGE.set_token('FORMAT', G_date_format);
371: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
372: END;
373:
374:

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

367: WHEN OTHERS THEN
368: FND_MESSAGE.set_name('CE', 'CE_CANNOT_CONVERT_DATE');
369: FND_MESSAGE.set_token('DATE', X_date);
370: FND_MESSAGE.set_token('FORMAT', G_date_format);
371: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(G_rec_no, 0), fnd_message.get, 'E');
372: END;
373:
374:
375: FUNCTION Is_Number (X_string VARCHAR2) RETURN BOOLEAN IS

Line 745: cep_standard.debug(FND_MESSAGE.get);

741: '','','','','','','','','','',
742: '','','','','','','','','','',
743: '','','','','','','','','','');
744: IF l_request_id = 0 THEN
745: cep_standard.debug(FND_MESSAGE.get);
746: cep_standard.debug('EXCEPTION: Fail to submit cuncurrent request for '|| l_program_name);
747: RAISE ldr_exception;
748: END IF;
749: ELSE

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

746: cep_standard.debug('EXCEPTION: Fail to submit cuncurrent request for '|| l_program_name);
747: RAISE ldr_exception;
748: END IF;
749: ELSE
750: FND_MESSAGE.set_name('CE', 'CE_ERROR_EXIST');
751: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'W');
752: END IF;
753: END IF;
754: END IF;

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

747: RAISE ldr_exception;
748: END IF;
749: ELSE
750: FND_MESSAGE.set_name('CE', 'CE_ERROR_EXIST');
751: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'W');
752: END IF;
753: END IF;
754: END IF;
755: cep_standard.debug('<

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

1542: BEGIN
1543: cep_standard.debug('< 1544: IF G_bank_account_num IS NULL THEN
1545: cep_standard.debug('G_bank_account_num is null');
1546: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
1547: FND_MESSAGE.set_token('FIELD', 'BANK_ACCOUNT_NUM');
1548: CE_SQLLDR_ERRORS_PKG.insert_row(
1549: NVL(G_statement_number, 'XXXXXXXXXXX'),
1550: NVL(G_bank_account_num, 'XXXXXXXXXXX'),

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

1543: cep_standard.debug('< 1544: IF G_bank_account_num IS NULL THEN
1545: cep_standard.debug('G_bank_account_num is null');
1546: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
1547: FND_MESSAGE.set_token('FIELD', 'BANK_ACCOUNT_NUM');
1548: CE_SQLLDR_ERRORS_PKG.insert_row(
1549: NVL(G_statement_number, 'XXXXXXXXXXX'),
1550: NVL(G_bank_account_num, 'XXXXXXXXXXX'),
1551: G_rec_no, fnd_message.get, 'E');

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

1547: FND_MESSAGE.set_token('FIELD', 'BANK_ACCOUNT_NUM');
1548: CE_SQLLDR_ERRORS_PKG.insert_row(
1549: NVL(G_statement_number, 'XXXXXXXXXXX'),
1550: NVL(G_bank_account_num, 'XXXXXXXXXXX'),
1551: G_rec_no, fnd_message.get, 'E');
1552: RETURN FALSE;
1553: END IF;
1554:
1555: cep_standard.debug('Finding unique bank account...');

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

1569:
1570: cep_standard.debug('l_cnt = '||to_char(l_cnt));
1571: IF l_cnt = 0 THEN -- Bank account is not setup.
1572: cep_standard.debug('Bank account is not setup');
1573: FND_MESSAGE.set_name('CE', 'CE_BANK_ACCNT_NOT_DEFINED');
1574: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1575: CE_SQLLDR_ERRORS_PKG.insert_row(
1576: G_statement_number,
1577: G_bank_account_num,

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

1570: cep_standard.debug('l_cnt = '||to_char(l_cnt));
1571: IF l_cnt = 0 THEN -- Bank account is not setup.
1572: cep_standard.debug('Bank account is not setup');
1573: FND_MESSAGE.set_name('CE', 'CE_BANK_ACCNT_NOT_DEFINED');
1574: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1575: CE_SQLLDR_ERRORS_PKG.insert_row(
1576: G_statement_number,
1577: G_bank_account_num,
1578: G_rec_no, fnd_message.get, 'E');

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

1574: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1575: CE_SQLLDR_ERRORS_PKG.insert_row(
1576: G_statement_number,
1577: G_bank_account_num,
1578: G_rec_no, fnd_message.get, 'E');
1579: RETURN FALSE;
1580:
1581: ELSIF l_cnt > 1 THEN -- There are more than one bank with this account number.
1582: cep_standard.debug('There are too many matching bank accounts');

Line 1583: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');

1579: RETURN FALSE;
1580:
1581: ELSIF l_cnt > 1 THEN -- There are more than one bank with this account number.
1582: cep_standard.debug('There are too many matching bank accounts');
1583: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');
1584: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1585: CE_SQLLDR_ERRORS_PKG.insert_row(
1586: G_statement_number,
1587: G_bank_account_num,

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

1580:
1581: ELSIF l_cnt > 1 THEN -- There are more than one bank with this account number.
1582: cep_standard.debug('There are too many matching bank accounts');
1583: FND_MESSAGE.set_name('CE', 'CE_TOO_MANY_BANK_ACCNT');
1584: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1585: CE_SQLLDR_ERRORS_PKG.insert_row(
1586: G_statement_number,
1587: G_bank_account_num,
1588: G_rec_no, fnd_message.get, 'W');

Line 1588: G_rec_no, fnd_message.get, 'W');

1584: FND_MESSAGE.set_token('BANK_ACCNT',G_bank_account_num);
1585: CE_SQLLDR_ERRORS_PKG.insert_row(
1586: G_statement_number,
1587: G_bank_account_num,
1588: G_rec_no, fnd_message.get, 'W');
1589:
1590: ELSE
1591: cep_standard.debug('G_bank_name='||G_bank_name);
1592: cep_standard.debug('G_bank_branch_name='||G_bank_branch_name);

Line 1680: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

1676: END IF;
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: l_err := SQLCODE;
1680: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
1681: FND_MESSAGE.set_token('ERR', to_char(l_err));
1682: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
1683: IF l_DEBUG in ('Y', 'C') THEN
1684: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_BAI - '|| to_char(l_err));

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

1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: l_err := SQLCODE;
1680: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
1681: FND_MESSAGE.set_token('ERR', to_char(l_err));
1682: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
1683: IF l_DEBUG in ('Y', 'C') THEN
1684: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_BAI - '|| to_char(l_err));
1685: END IF;

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

1678: WHEN OTHERS THEN
1679: l_err := SQLCODE;
1680: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
1681: FND_MESSAGE.set_token('ERR', to_char(l_err));
1682: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
1683: IF l_DEBUG in ('Y', 'C') THEN
1684: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_BAI - '|| to_char(l_err));
1685: END IF;
1686: END Decode_Line_BAI;

Line 2173: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

2169: END IF;
2170: EXCEPTION -- Bug 3608257 added this EXCEPTION section
2171: WHEN OTHERS THEN
2172: l_err := SQLCODE;
2173: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2174: FND_MESSAGE.set_token('ERR', to_char(l_err));
2175: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2176: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_BAI - '|| to_char(l_err));
2177: END Decode_Hdr_BAI;

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

2170: EXCEPTION -- Bug 3608257 added this EXCEPTION section
2171: WHEN OTHERS THEN
2172: l_err := SQLCODE;
2173: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2174: FND_MESSAGE.set_token('ERR', to_char(l_err));
2175: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2176: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_BAI - '|| to_char(l_err));
2177: END Decode_Hdr_BAI;
2178:

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

2171: WHEN OTHERS THEN
2172: l_err := SQLCODE;
2173: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2174: FND_MESSAGE.set_token('ERR', to_char(l_err));
2175: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2176: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_BAI - '|| to_char(l_err));
2177: END Decode_Hdr_BAI;
2178:
2179: /* ---------------------------------------------------------------------

Line 2240: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

2236: END IF;
2237:
2238: IF ( G_rec_no = 1 AND
2239: C_rec.rec_id_no <> '01' ) THEN
2240: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2241: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2242: EXIT;
2243: ELSIF C_rec.rec_id_no = '01' THEN
2244: Init_Hdr_Rec;

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

2237:
2238: IF ( G_rec_no = 1 AND
2239: C_rec.rec_id_no <> '01' ) THEN
2240: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2241: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2242: EXIT;
2243: ELSIF C_rec.rec_id_no = '01' THEN
2244: Init_Hdr_Rec;
2245: Init_Line_Rec;

Line 2249: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

2245: Init_Line_Rec;
2246: l_line_cnt := 0;
2247: l_last_rid := '1';
2248: IF nvl(C_rec.col8,'2') <> '2' THEN
2249: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2250: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2251: EXIT;
2252: END IF;
2253: ELSIF C_rec.rec_id_no = '02' THEN

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

2246: l_line_cnt := 0;
2247: l_last_rid := '1';
2248: IF nvl(C_rec.col8,'2') <> '2' THEN
2249: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2250: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2251: EXIT;
2252: END IF;
2253: ELSIF C_rec.rec_id_no = '02' THEN
2254:

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

2268: cep_standard.debug('G_statement_date = '|| G_statement_date);
2269: END IF;
2270:
2271: IF G_statement_number IS NULL THEN
2272: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2273: FND_MESSAGE.set_token('FIELD', 'STATEMENT_NUMBER');
2274: CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2275: C_rec.rec_no, fnd_message.get);
2276: EXIT;

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

2269: END IF;
2270:
2271: IF G_statement_number IS NULL THEN
2272: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2273: FND_MESSAGE.set_token('FIELD', 'STATEMENT_NUMBER');
2274: CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2275: C_rec.rec_no, fnd_message.get);
2276: EXIT;
2277: END IF;

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

2271: IF G_statement_number IS NULL THEN
2272: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2273: FND_MESSAGE.set_token('FIELD', 'STATEMENT_NUMBER');
2274: CE_SQLLDR_ERRORS_PKG.insert_row('XXXXXXXXXXX' , NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2275: C_rec.rec_no, fnd_message.get);
2276: EXIT;
2277: END IF;
2278:
2279: IF G_statement_date IS NULL THEN

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

2276: EXIT;
2277: END IF;
2278:
2279: IF G_statement_date IS NULL THEN
2280: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2281: FND_MESSAGE.set_token('FIELD', 'STATEMENT_DATE');
2282: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2283: C_rec.rec_no, fnd_message.get);
2284: EXIT;

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

2277: END IF;
2278:
2279: IF G_statement_date IS NULL THEN
2280: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2281: FND_MESSAGE.set_token('FIELD', 'STATEMENT_DATE');
2282: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2283: C_rec.rec_no, fnd_message.get);
2284: EXIT;
2285: END IF;

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

2279: IF G_statement_date IS NULL THEN
2280: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISS_REQ_FIELD');
2281: FND_MESSAGE.set_token('FIELD', 'STATEMENT_DATE');
2282: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, NVL(G_bank_account_num, 'XXXXXXXXXXX'),
2283: C_rec.rec_no, fnd_message.get);
2284: EXIT;
2285: END IF;
2286:
2287: l_statement_date := G_statement_date;

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

2629: l_rec_cnt := l_rec_cnt + 1;
2630: l_line_cnt := 0;
2631:
2632: IF (nvl(to_number(C_rec.col2), l_rec_cnt) <> l_rec_cnt) THEN
2633: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');
2634: FND_MESSAGE.set_token('GIVEN', C_rec.col2);
2635: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));
2636: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);
2637: END IF;

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

2630: l_line_cnt := 0;
2631:
2632: IF (nvl(to_number(C_rec.col2), l_rec_cnt) <> l_rec_cnt) THEN
2633: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');
2634: FND_MESSAGE.set_token('GIVEN', C_rec.col2);
2635: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));
2636: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);
2637: END IF;
2638:

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

2631:
2632: IF (nvl(to_number(C_rec.col2), l_rec_cnt) <> l_rec_cnt) THEN
2633: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');
2634: FND_MESSAGE.set_token('GIVEN', C_rec.col2);
2635: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));
2636: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);
2637: END IF;
2638:
2639: G_statement_date := nvl(G_statement_date, l_statement_date);

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

2632: IF (nvl(to_number(C_rec.col2), l_rec_cnt) <> l_rec_cnt) THEN
2633: FND_MESSAGE.set_name('CE', 'CE_SQLLDR_MISSING_RECORD');
2634: FND_MESSAGE.set_token('GIVEN', C_rec.col2);
2635: FND_MESSAGE.set_token('COUNTED', to_char(l_rec_cnt));
2636: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get);
2637: END IF;
2638:
2639: G_statement_date := nvl(G_statement_date, l_statement_date);
2640: /* 2643505 Added the IF Condition */

Line 2650: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');

2646: Init_Hdr_Rec;
2647: l_control_total_cr := 0;
2648: l_control_total_dr := 0;
2649: ELSIF C_rec.rec_id_no NOT IN ('98', '99') THEN
2650: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2651: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2652: EXIT;
2653: END IF;
2654:

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

2647: l_control_total_cr := 0;
2648: l_control_total_dr := 0;
2649: ELSIF C_rec.rec_id_no NOT IN ('98', '99') THEN
2650: FND_MESSAGE.set_name('CE', 'CE_INVALID_BAI2');
2651: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
2652: EXIT;
2653: END IF;
2654:
2655: END LOOP;

Line 2792: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

2788: cep_standard.debug('< 2789: EXCEPTION
2790: WHEN OTHERS THEN
2791: l_err := SQLCODE;
2792: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2793: FND_MESSAGE.set_token('ERR', to_char(l_err));
2794: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2795: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_Other - '|| to_char(l_err));
2796: END Decode_Hdr_Other;

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

2789: EXCEPTION
2790: WHEN OTHERS THEN
2791: l_err := SQLCODE;
2792: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2793: FND_MESSAGE.set_token('ERR', to_char(l_err));
2794: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2795: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_Other - '|| to_char(l_err));
2796: END Decode_Hdr_Other;
2797:

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

2790: WHEN OTHERS THEN
2791: l_err := SQLCODE;
2792: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2793: FND_MESSAGE.set_token('ERR', to_char(l_err));
2794: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2795: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Hdr_Other - '|| to_char(l_err));
2796: END Decode_Hdr_Other;
2797:
2798: /* ---------------------------------------------------------------------

Line 2877: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');

2873: END IF;
2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: l_err := SQLCODE;
2877: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2878: FND_MESSAGE.set_token('ERR', to_char(l_err));
2879: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2880: IF l_DEBUG in ('Y', 'C') THEN
2881: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_Other - '||to_char(l_err));

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

2874: EXCEPTION
2875: WHEN OTHERS THEN
2876: l_err := SQLCODE;
2877: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2878: FND_MESSAGE.set_token('ERR', to_char(l_err));
2879: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2880: IF l_DEBUG in ('Y', 'C') THEN
2881: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_Other - '||to_char(l_err));
2882: END IF;

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

2875: WHEN OTHERS THEN
2876: l_err := SQLCODE;
2877: FND_MESSAGE.set_name('CE', 'CE_RECORD_FAIL');
2878: FND_MESSAGE.set_token('ERR', to_char(l_err));
2879: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, nvl(X_rec_no, 0), fnd_message.get);
2880: IF l_DEBUG in ('Y', 'C') THEN
2881: cep_standard.debug('EXCEPTION: CE_BANK_STATEMENT_LOADER.Decode_Line_Other - '||to_char(l_err));
2882: END IF;
2883: END Decode_Line_Other;

Line 3009: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');

3005: -- If the file not started with record id '01' discard the file processing
3006: IF (G_rec_no=1 AND G_rec_id <> '01' )
3007: THEN
3008: cep_standard.debug('Load_Others: The File Not started with 01 Record id');
3009: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');
3010: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
3011: EXIT;
3012: -- If the file has orphan '05' discard the file processing
3013: ELSIF ( G_rec_id = '05' AND G_prev_rec_id NOT IN ('05','04') )

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

3006: IF (G_rec_no=1 AND G_rec_id <> '01' )
3007: THEN
3008: cep_standard.debug('Load_Others: The File Not started with 01 Record id');
3009: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');
3010: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
3011: EXIT;
3012: -- If the file has orphan '05' discard the file processing
3013: ELSIF ( G_rec_id = '05' AND G_prev_rec_id NOT IN ('05','04') )
3014: THEN

Line 3016: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');

3012: -- If the file has orphan '05' discard the file processing
3013: ELSIF ( G_rec_id = '05' AND G_prev_rec_id NOT IN ('05','04') )
3014: THEN
3015: cep_standard.debug('Load_Others: The File has 05 Record with out Parent 04 Record at Rec no: '||To_Char(G_rec_no));
3016: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');
3017: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
3018: EXIT;
3019: END IF;
3020: END IF;

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

3013: ELSIF ( G_rec_id = '05' AND G_prev_rec_id NOT IN ('05','04') )
3014: THEN
3015: cep_standard.debug('Load_Others: The File has 05 Record with out Parent 04 Record at Rec no: '||To_Char(G_rec_no));
3016: FND_MESSAGE.set_name('CE', 'CE_INVALID_EDIFACT');
3017: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, C_rec.rec_no, fnd_message.get, 'E');
3018: EXIT;
3019: END IF;
3020: END IF;
3021: --Edifact ER

Line 3128: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');

3124: END IF;
3125: ELSIF l_hdr_or_line = 'B'
3126: THEN
3127: cep_standard.debug('This rec_id '|| C_rec.rec_id_no ||' is assigned for both header and line');
3128: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');
3129: FND_MESSAGE.set_token('RECID', C_rec.rec_id_no);
3130: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');
3131: EXIT;
3132: END IF;

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

3125: ELSIF l_hdr_or_line = 'B'
3126: THEN
3127: cep_standard.debug('This rec_id '|| C_rec.rec_id_no ||' is assigned for both header and line');
3128: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');
3129: FND_MESSAGE.set_token('RECID', C_rec.rec_id_no);
3130: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');
3131: EXIT;
3132: END IF;
3133:

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

3126: THEN
3127: cep_standard.debug('This rec_id '|| C_rec.rec_id_no ||' is assigned for both header and line');
3128: FND_MESSAGE.set_name('CE', 'CE_RECID_IN_HDR_LINE');
3129: FND_MESSAGE.set_token('RECID', C_rec.rec_id_no);
3130: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, G_rec_no, fnd_message.get, 'E');
3131: EXIT;
3132: END IF;
3133:
3134: IF (G_format_type='EDIFACT_FR')

Line 3579: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');

3575: END IF;
3576: Delete_Orphaned_Lines;
3577:
3578: IF ( nvl(G_total_hdr_deleted, 0) <> 0 ) THEN
3579: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');
3580: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));
3581: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN

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

3576: Delete_Orphaned_Lines;
3577:
3578: IF ( nvl(G_total_hdr_deleted, 0) <> 0 ) THEN
3579: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');
3580: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));
3581: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');

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

3577:
3578: IF ( nvl(G_total_hdr_deleted, 0) <> 0 ) THEN
3579: FND_MESSAGE.set_name('CE', 'CE_EXIST_HDR_DELETED');
3580: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));
3581: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
3585: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));

Line 3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');

3580: FND_MESSAGE.set_token('CNT', to_char(G_total_hdr_deleted));
3581: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
3585: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));
3586: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3587: END IF;
3588:

Line 3585: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));

3581: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
3585: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));
3586: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3587: END IF;
3588:
3589: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);

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

3582: END IF;
3583: IF ( nvl(G_total_line_deleted, 0) <> 0 ) THEN
3584: FND_MESSAGE.set_name('CE', 'CE_EXIST_LINE_DELETED');
3585: FND_MESSAGE.set_token('CNT', to_char(G_total_line_deleted));
3586: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get);
3587: END IF;
3588:
3589: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3590:

Line 3602: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');

3598: WHEN SQL_LOADER_ERROR THEN
3599: IF l_DEBUG in ('Y', 'C') THEN
3600: cep_standard.debug('EXCEPTION: Load_Bank_Statement - Sql*Loader was not finished');
3601: END IF;
3602: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');
3603: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3604: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3605: WHEN INVALID_DATA_FILE THEN
3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');

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

3599: IF l_DEBUG in ('Y', 'C') THEN
3600: cep_standard.debug('EXCEPTION: Load_Bank_Statement - Sql*Loader was not finished');
3601: END IF;
3602: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');
3603: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3604: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3605: WHEN INVALID_DATA_FILE THEN
3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3607: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);

Line 3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');

3602: FND_MESSAGE.set_name('CE', 'CE_SQLLOADER_FAIL');
3603: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3604: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3605: WHEN INVALID_DATA_FILE THEN
3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3607: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);
3608: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3609: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3610: WHEN OTHERS THEN

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

3603: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3604: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3605: WHEN INVALID_DATA_FILE THEN
3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3607: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);
3608: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3609: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3610: WHEN OTHERS THEN
3611: l_err := SQLCODE;

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

3604: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3605: WHEN INVALID_DATA_FILE THEN
3606: FND_MESSAGE.set_name('CE', 'CE_INVALID_DATA_FILE');
3607: FND_MESSAGE.set_token('DATA_FILE',G_data_file_name);
3608: CE_SQLLDR_ERRORS_PKG.insert_row(G_statement_number, G_bank_account_num, 0, fnd_message.get, 'E');
3609: CE_BANK_STMT_SQL_LDR.Print_Report(G_map_id, G_data_file_name);
3610: WHEN OTHERS THEN
3611: l_err := SQLCODE;
3612: IF l_DEBUG in ('Y', 'C') THEN