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_AND_ACCOUNT_VALIDATION dependencies on CE_BANK_AND_ACCOUNT_VALIDATION

Line 1: PACKAGE BODY CE_BANK_AND_ACCOUNT_VALIDATION AS

1: PACKAGE BODY CE_BANK_AND_ACCOUNT_VALIDATION AS
2: /*$Header: cebavalb.pls 120.18.12010000.2 2009/02/06 06:33:06 talapati ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: --l_DEBUG varchar2(1) := 'Y';

Line 185: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank (+)');

181: AND BankParty.party_id <> p_temp_id;
182: */
183:
184: BEGIN
185: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank (+)');
186:
187: /***** Fetching the bank country *****/
188: OPEN c_country;
189: FETCH c_country INTO l_country;

Line 338: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');

334: /********** Bug 6742860/6642215: code commented ends **************/
335: EXCEPTION
336: WHEN OTHERS THEN
337: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
338: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');
339: fnd_msg_pub.add;
340: RAISE;
341: END validate_bank;
342:

Line 400: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_org (+)');

396: l_pos NUMBER;
397: l_org_id_str VARCHAR2(30);
398: l_found VARCHAR2(1);
399: BEGIN
400: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_org (+)');
401: x_out := 1;
402: l_found := 'N';
403:
404: l_org_list := MO_UTILS.get_org_list(p_security_profile_id, p_org_classification);

Line 436: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');

432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
436: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');
437: fnd_msg_pub.add;
438: RAISE;
439: END validate_org;
440: */

Line 462: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');

458: FROM fnd_currencies fc
459: WHERE fc.currency_code = p_currency_code;
460: l_dummy NUMBER := 0;
461: BEGIN
462: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');
463:
464: -- initialize API return status to success.
465: x_return_status := fnd_api.g_ret_sts_success;
466:

Line 512: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');

508: AND bank_account_id <> NVL(p_account_id, -1);
509: --AND (rowid <> l_rowid OR l_rowid IS NULL);
510:
511: BEGIN
512: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');
513:
514: -- initialize API return status to success.
515: x_return_status := fnd_api.g_ret_sts_success;
516: /*

Line 533: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
533: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');
534: fnd_msg_pub.add;
535:
536: END validate_account_name;
537:

Line 568: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');

564: l_str1_2 VARCHAR2(4);
565: l_str3_4 VARCHAR2(40);
566: new_IBAN VARCHAR2(100);
567: BEGIN
568: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');
569:
570: -- initialize API return status to success.
571: x_return_status := fnd_api.g_ret_sts_success;
572:

Line 692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

688: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
689:
690:
691: BEGIN
692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
693: -- initialize API return status to success.
694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);

Line 715: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');

711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
715: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');
716: fnd_msg_pub.add;
717:
718: END validate_account_use;
719:

Line 737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

733: p_xtr IN VARCHAR2,
734: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
735:
736: BEGIN
737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
738: -- initialize API return status to success.
739: x_return_status := fnd_api.g_ret_sts_success;
740: cep_standard.debug('p_short_account_name='||p_short_account_name);
741: cep_standard.debug('p_xtr='||p_xtr);

Line 754: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');

750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
754: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');
755: fnd_msg_pub.add;
756:
757: END validate_short_account_name;
758:

Line 775: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');

771: p_end_date IN DATE,
772: x_return_status IN OUT NOCOPY VARCHAR2) IS
773:
774: BEGIN
775: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');
776: -- initialize API return status to success.
777: x_return_status := fnd_api.g_ret_sts_success;
778:
779:

Line 792: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');

788:
789: EXCEPTION
790: WHEN OTHERS THEN
791: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
792: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');
793: fnd_msg_pub.add;
794: x_return_status := fnd_api.g_ret_sts_error;
795:
796: END validate_end_date;

Line 883: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type (+)');

879:
880: BEGIN
881:
882: BEGIN
883: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type (+)');
884:
885: --/* 1/13/05 no bg
886: OPEN bg;
887:

Line 967: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code (+)');

963: AND organization_id = p_org_id;
964:
965: BEGIN
966: BEGIN
967: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code (+)');
968:
969: OPEN bg;
970:
971: FETCH bg INTO bg_org;

Line 1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

1035:
1036: org_type VARCHAR2(240);
1037:
1038: BEGIN
1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);

Line 1084: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');

1080:
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1084: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');
1085: fnd_msg_pub.add;
1086:
1087: END validate_account_access_org;
1088:

Line 1158: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');

1154: EXCEPTION
1155: WHEN OTHERS THEN
1156:
1157: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1158: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');
1159: fnd_msg_pub.add;
1160: RAISE;
1161:
1162: END VALIDATE_ALC;

Line 1193: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_country.');

1189: WHERE ft.territory_code = p_country_code;
1190: l_dummy NUMBER(1) := 0;
1191: BEGIN
1192: IF l_DEBUG in ('Y', 'C') THEN
1193: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_country.');
1194: END IF;
1195:
1196: OPEN c_country;
1197: FETCH c_country INTO l_dummy;

Line 1206: cep_standard.debug('<

1202: END IF;
1203: CLOSE c_country;
1204:
1205: IF l_DEBUG in ('Y', 'C') THEN
1206: cep_standard.debug('< 1207: END IF;
1208: END validate_country;
1209:
1210: /*=======================================================================+

Line 1254: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');

1250: p_cur varchar2(5);
1251: p_ap_def number;
1252: p_xtr_def number;
1253: BEGIN
1254: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1255: -- initialize API return status to success.
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1327: cep_standard.debug('<

1323: --IF l_DEBUG in ('Y', 'C') THEN
1324: cep_standard.debug(' P_COUNT: '|| x_msg_count);
1325:
1326:
1327: cep_standard.debug('< 1328: --END IF;
1329:
1330: EXCEPTION
1331: WHEN OTHERS THEN

Line 1334: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');

1330: EXCEPTION
1331: WHEN OTHERS THEN
1332:
1333: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1334: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1335: fnd_msg_pub.add;
1336: RAISE;
1337:
1338: END validate_def_settlement;

Line 1393: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');

1389: RETURN(masked_account_num);
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1393: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');
1394: fnd_msg_pub.add;
1395: RAISE;
1396: END get_masked_account_num;
1397: */

Line 1433: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');

1429: AND NVL(org_id, legal_entity_id) = p_org_le_id
1430: AND bank_acct_use_id <> NVL(p_acct_use_id, -1);
1431:
1432: BEGIN
1433: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');
1434:
1435: -- initialize API return status to success.
1436: x_return_status := fnd_api.g_ret_sts_success;
1437:

Line 1450: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');

1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1450: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');
1451: fnd_msg_pub.add;
1452:
1453: END validate_unique_org_access;
1454:

Line 1486: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');

1482: p_pay_doc_count number;
1483: p_ap_doc_cat_count number;
1484:
1485: BEGIN
1486: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1487: cep_standard.debug('P_PAYMENT_DOCUMENT_ID=' ||P_PAYMENT_DOCUMENT_ID
1488: ||', P_PAYMENT_METHOD_CODE='||P_PAYMENT_METHOD_CODE
1489: ||', P_BANK_ACCT_USE_ID='||P_BANK_ACCT_USE_ID );
1490:

Line 1547: cep_standard.debug('<

1543: END IF;
1544:
1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1546:
1547: cep_standard.debug('< 1548:
1549: EXCEPTION
1550: WHEN NO_DATA_FOUND THEN
1551: cep_standard.debug('no data found');

Line 1558: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');

1554: cep_standard.debug('too_many_rows');
1555: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1556: WHEN OTHERS THEN
1557: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1558: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1559: fnd_msg_pub.add;
1560:
1561: END get_pay_doc_cat;
1562:

Line 1603: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code_isetup (+)');

1599: and oi.organization_id = p_org_id;
1600:
1601: BEGIN
1602: BEGIN
1603: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code_isetup (+)');
1604:
1605: OPEN bg;
1606:
1607: FETCH bg INTO bg_org;

Line 1640: END CE_BANK_AND_ACCOUNT_VALIDATION;

1636: cep_standard.debug('EXCEPTION: Get_Org_Type_Code_Isetup');
1637: RAISE;
1638: END Get_Org_Type_Code_Isetup;
1639:
1640: END CE_BANK_AND_ACCOUNT_VALIDATION;