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.22.12020000.5 2013/03/28 06:20:47 anushven ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: --l_DEBUG varchar2(1) := 'Y';

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

125: AND upper(BankParty.party_name) = upper(l_bank_name)
126: AND BankParty.party_id <> p_temp_id;
127:
128: BEGIN
129: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank (+)');
130:
131: -- Fetching the bank country
132: OPEN c_country;
133: FETCH c_country INTO l_country;

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

192: end if;
193: EXCEPTION
194: WHEN OTHERS THEN
195: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
196: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank');
197: fnd_msg_pub.add;
198: RAISE;
199: END validate_bank;
200:

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

252: l_pos NUMBER;
253: l_org_id_str VARCHAR2(30);
254: l_found VARCHAR2(1);
255: BEGIN
256: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_org (+)');
257: x_out := 1;
258: l_found := 'N';
259:
260: l_org_list := MO_UTILS.get_org_list(p_security_profile_id, p_org_classification);

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

288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
292: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_org');
293: fnd_msg_pub.add;
294: RAISE;
295: END validate_org;
296: */

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

314: FROM fnd_currencies fc
315: WHERE fc.currency_code = p_currency_code;
316: l_dummy NUMBER := 0;
317: BEGIN
318: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');
319:
320: -- initialize API return status to success.
321: x_return_status := fnd_api.g_ret_sts_success;
322:

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

364: AND bank_account_id <> NVL(p_account_id, -1);
365: --AND (rowid <> l_rowid OR l_rowid IS NULL);
366:
367: BEGIN
368: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');
369:
370: -- initialize API return status to success.
371: x_return_status := fnd_api.g_ret_sts_success;
372: /*

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

385:
386: EXCEPTION
387: WHEN OTHERS THEN
388: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
389: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name');
390: fnd_msg_pub.add;
391:
392: END validate_account_name;
393:

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

569: l_checkSum NUMBER;
570: l_multiplier NUMBER;
571: l_product NUMBER; -- Bug 10363417
572: BEGIN
573: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');
574: -- initialize API return status to success.
575: x_return_status := fnd_api.g_ret_sts_success;
576:
577: -- step 1: remove spaces from the left and right only for p_IBAN

Line 618: CE_BANK_AND_ACCOUNT_VALIDATION.validate_iban_length(Xi_country_code => l_str1_2,

614: --
615: -- step 3: IBAN length validation
616: --
617: IF (x_return_status = fnd_api.g_ret_sts_success) then
618: CE_BANK_AND_ACCOUNT_VALIDATION.validate_iban_length(Xi_country_code => l_str1_2,
619: Xi_len => l_len,
620: Xo_return_status => x_return_status);
621: END IF;
622:

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

703: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
704:
705:
706: BEGIN
707: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
708: -- initialize API return status to success.
709: x_return_status := fnd_api.g_ret_sts_success;
710:
711: cep_standard.debug('p_ap='||p_ap);

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

726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
730: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use');
731: fnd_msg_pub.add;
732:
733: END validate_account_use;
734:

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

748: p_xtr IN VARCHAR2,
749: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
750:
751: BEGIN
752: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
753: -- initialize API return status to success.
754: x_return_status := fnd_api.g_ret_sts_success;
755: cep_standard.debug('p_short_account_name='||p_short_account_name);
756: cep_standard.debug('p_xtr='||p_xtr);

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

765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
769: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_short_account_name');
770: fnd_msg_pub.add;
771:
772: END validate_short_account_name;
773:

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

786: p_end_date IN DATE,
787: x_return_status IN OUT NOCOPY VARCHAR2) IS
788:
789: BEGIN
790: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');
791: -- initialize API return status to success.
792: x_return_status := fnd_api.g_ret_sts_success;
793:
794:

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

803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
807: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date');
808: fnd_msg_pub.add;
809: x_return_status := fnd_api.g_ret_sts_error;
810:
811: END validate_end_date;

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

894:
895: BEGIN
896:
897: BEGIN
898: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type (+)');
899:
900: --/* 1/13/05 no bg
901: OPEN bg;
902:

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

978: AND organization_id = p_org_id;
979:
980: BEGIN
981: BEGIN
982: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code (+)');
983:
984: OPEN bg;
985:
986: FETCH bg INTO bg_org;

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

1050:
1051: org_type VARCHAR2(240);
1052:
1053: BEGIN
1054: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
1055: -- initialize API return status to success.
1056: x_return_status := fnd_api.g_ret_sts_success;
1057:
1058: cep_standard.debug('p_ap='||p_ap);

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

1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1099: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_access_org');
1100: fnd_msg_pub.add;
1101:
1102: END validate_account_access_org;
1103:

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

1169: EXCEPTION
1170: WHEN OTHERS THEN
1171:
1172: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1173: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_alc');
1174: fnd_msg_pub.add;
1175: RAISE;
1176:
1177: END VALIDATE_ALC;

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

1204: WHERE ft.territory_code = p_country_code;
1205: l_dummy NUMBER(1) := 0;
1206: BEGIN
1207: IF l_DEBUG in ('Y', 'C') THEN
1208: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_country.');
1209: END IF;
1210:
1211: OPEN c_country;
1212: FETCH c_country INTO l_dummy;

Line 1221: cep_standard.debug('<

1217: END IF;
1218: CLOSE c_country;
1219:
1220: IF l_DEBUG in ('Y', 'C') THEN
1221: cep_standard.debug('< 1222: END IF;
1223: END validate_country;
1224:
1225: /*=======================================================================+

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

1265: p_cur varchar2(5);
1266: p_ap_def number;
1267: p_xtr_def number;
1268: BEGIN
1269: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1270: -- initialize API return status to success.
1271: x_return_status := fnd_api.g_ret_sts_success;
1272:
1273: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1342: cep_standard.debug('<

1338: --IF l_DEBUG in ('Y', 'C') THEN
1339: cep_standard.debug(' P_COUNT: '|| x_msg_count);
1340:
1341:
1342: cep_standard.debug('< 1343: --END IF;
1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN

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

1345: EXCEPTION
1346: WHEN OTHERS THEN
1347:
1348: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1349: fnd_message.set_token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1350: fnd_msg_pub.add;
1351: RAISE;
1352:
1353: END validate_def_settlement;

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

1404: RETURN(masked_account_num);
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1408: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_masked_account_num');
1409: fnd_msg_pub.add;
1410: RAISE;
1411: END get_masked_account_num;
1412: */

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

1444: AND NVL(org_id, legal_entity_id) = p_org_le_id
1445: AND bank_acct_use_id <> NVL(p_acct_use_id, -1);
1446:
1447: BEGIN
1448: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');
1449:
1450: -- initialize API return status to success.
1451: x_return_status := fnd_api.g_ret_sts_success;
1452:

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

1461:
1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1465: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access');
1466: fnd_msg_pub.add;
1467:
1468: END validate_unique_org_access;
1469:

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

1497: p_pay_doc_count number;
1498: p_ap_doc_cat_count number;
1499:
1500: BEGIN
1501: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1502: cep_standard.debug('P_PAYMENT_DOCUMENT_ID=' ||P_PAYMENT_DOCUMENT_ID
1503: ||', P_PAYMENT_METHOD_CODE='||P_PAYMENT_METHOD_CODE
1504: ||', P_BANK_ACCT_USE_ID='||P_BANK_ACCT_USE_ID );
1505:

Line 1562: cep_standard.debug('<

1558: END IF;
1559:
1560: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1561:
1562: cep_standard.debug('< 1563:
1564: EXCEPTION
1565: WHEN NO_DATA_FOUND THEN
1566: cep_standard.debug('no data found');

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

1569: cep_standard.debug('too_many_rows');
1570: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1571: WHEN OTHERS THEN
1572: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1573: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1574: fnd_msg_pub.add;
1575:
1576: END get_pay_doc_cat;
1577:

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

1614: and oi.organization_id = p_org_id;
1615:
1616: BEGIN
1617: BEGIN
1618: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code_isetup (+)');
1619:
1620: OPEN bg;
1621:
1622: FETCH bg INTO bg_org;

Line 1655: END CE_BANK_AND_ACCOUNT_VALIDATION;

1651: cep_standard.debug('EXCEPTION: Get_Org_Type_Code_Isetup');
1652: RAISE;
1653: END Get_Org_Type_Code_Isetup;
1654:
1655: END CE_BANK_AND_ACCOUNT_VALIDATION;