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_VALIDATE_BANKINFO dependencies on FND_API

Line 105: IF FND_API.to_Boolean(p_init_msg_list) THEN

101:
102: BEGIN
103: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bic');
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF FND_API.to_Boolean(p_init_msg_list) THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108: -- initialize API return status to success.
109: x_return_status := fnd_api.g_ret_sts_success;

Line 109: x_return_status := fnd_api.g_ret_sts_success;

105: IF FND_API.to_Boolean(p_init_msg_list) THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108: -- initialize API return status to success.
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: l_bic := upper(X_BIC_CODE) ;
112:
113: IF LENGTH(l_bic) IN ( 8,11 ) THEN

Line 120: x_return_status := fnd_api.g_ret_sts_error;

116:
117: IF TO_NUMBER(l_string) > 0 THEN
118: fnd_message.set_name('CE', 'CE_INVALID_BIC_CODE');
119: fnd_msg_pub.add;
120: x_return_status := fnd_api.g_ret_sts_error;
121: END IF ;
122: ELSE
123: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
124: fnd_msg_pub.add;

Line 125: x_return_status := fnd_api.g_ret_sts_error;

121: END IF ;
122: ELSE
123: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_error;
126: END IF ;
127:
128: FND_MSG_PUB.Count_And_Get(
129: p_encoded => FND_API.G_FALSE,

Line 129: p_encoded => FND_API.G_FALSE,

125: x_return_status := fnd_api.g_ret_sts_error;
126: END IF ;
127:
128: FND_MSG_PUB.Count_And_Get(
129: p_encoded => FND_API.G_FALSE,
130: p_count => x_msg_count,
131: p_data => x_msg_data);
132:
133: END CE_VALIDATE_BIC;

Line 872: x_return_status := fnd_api.g_ret_sts_success;

868: BEGIN
869: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_cd');
870:
871: -- initialize API return status to success.
872: x_return_status := fnd_api.g_ret_sts_success;
873: COUNTRY_NAME := X_COUNTRY_NAME;
874:
875: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd - COUNTRY_NAME: '|| COUNTRY_NAME||
876: 'CE_VALIDATE_BANKINFO.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 879: IF FND_API.to_Boolean(p_init_msg_list) THEN

875: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd - COUNTRY_NAME: '|| COUNTRY_NAME||
876: 'CE_VALIDATE_BANKINFO.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
877:
878: -- Initialize message list if p_init_msg_list is set to TRUE.
879: IF FND_API.to_Boolean(p_init_msg_list) THEN
880: x_init_count := 0;
881: FND_MSG_PUB.initialize;
882: ELSE
883: -- bug 7460921 Capturing the message stack count into the variable x_init_count

Line 885: p_encoded => FND_API.G_FALSE,

881: FND_MSG_PUB.initialize;
882: ELSE
883: -- bug 7460921 Capturing the message stack count into the variable x_init_count
884: FND_MSG_PUB.Count_And_Get(
885: p_encoded => FND_API.G_FALSE,
886: p_count => x_init_count,
887: p_data => x_msg_data);
888: END IF;
889:

Line 971: p_encoded => FND_API.G_FALSE,

967: END IF; */
968: END IF; -- End Bug 6632733
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data);
974:
975: IF x_msg_count > x_init_count THEN -- bug 7460921

Line 976: x_return_status := fnd_api.g_ret_sts_error;

972: p_count => x_msg_count,
973: p_data => x_msg_data);
974:
975: IF x_msg_count > x_init_count THEN -- bug 7460921
976: x_return_status := fnd_api.g_ret_sts_error;
977: END IF;
978:
979: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd - P_COUNT: '|| x_msg_count);
980:

Line 1036: x_return_status := fnd_api.g_ret_sts_success;

1032: BEGIN
1033: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_branch');
1034:
1035: -- initialize API return status to success.
1036: x_return_status := fnd_api.g_ret_sts_success;
1037:
1038: COUNTRY_NAME := X_COUNTRY_NAME;
1039: l_value_out := X_BRANCH_NUMBER;
1040:

Line 1045: IF FND_API.to_Boolean(p_init_msg_list) THEN

1041: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);
1042: cep_standard.debug('l_value_out: '|| l_value_out);
1043:
1044: -- Initialize message list if p_init_msg_list is set to TRUE.
1045: IF FND_API.to_Boolean(p_init_msg_list) THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049: /* We must validate the Bank Branch Number */

Line 1182: l_usr_valid := fnd_api.g_ret_sts_success;

1178: -- custom validations as they might modify the branch number.
1179:
1180: -- 9250566 ADDED 1/6 START -------------------------
1181: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1182: l_usr_valid := fnd_api.g_ret_sts_success;
1183:
1184: -- Call to custom validation routines
1185: cep_standard.debug('Calling custom validation hooks');
1186: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 1237: IF l_usr_valid = fnd_api.g_ret_sts_error

1233: -- end country unique check for branch --
1234: -- Bug 14242293: code change (1/2) ends
1235:
1236: -- Check return status
1237: IF l_usr_valid = fnd_api.g_ret_sts_error
1238: THEN
1239: cep_standard.debug('Custom validations done - failure');
1240: IF l_count_after_custom = 0 THEN
1241: cep_standard.debug('No custom error message set');

Line 1258: p_encoded => FND_API.G_FALSE,

1254: END IF;
1255: -- 9250566 ADDED 1/6 END --------------------------
1256:
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data);
1261:
1262: cep_standard.debug('P_COUNT: '|| x_msg_count);

Line 1265: x_return_status := fnd_api.g_ret_sts_error;

1261:
1262: cep_standard.debug('P_COUNT: '|| x_msg_count);
1263:
1264: IF x_msg_count > 0 THEN
1265: x_return_status := fnd_api.g_ret_sts_error;
1266: END IF;
1267:
1268: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);
1269: cep_standard.debug('<

Line 1436: x_return_status := fnd_api.g_ret_sts_success;

1432: country_name VARCHAR2(2);
1433: BEGIN
1434: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
1435: -- initialize API return status to success.
1436: x_return_status := fnd_api.g_ret_sts_success;
1437:
1438: COUNTRY_NAME := X_COUNTRY_NAME;
1439: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;
1440:

Line 1449: IF FND_API.to_Boolean(p_init_msg_list) THEN

1445: IF CE_DISABLE_VALIDATION THEN
1446: cep_standard.debug('Validations are Disabled.No formatting done.');
1447: ELSE
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean(p_init_msg_list) THEN
1450: FND_MSG_PUB.initialize;
1451: END IF;
1452: IF (COUNTRY_NAME = 'BE') THEN
1453: CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM_BE(

Line 1485: p_encoded => FND_API.G_FALSE,

1481: X_ELECTRONIC_ACCT_NUM);
1482:
1483: END IF;
1484: FND_MSG_PUB.Count_And_Get(
1485: p_encoded => FND_API.G_FALSE,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488: END IF;--Bug number 13096191 added
1489: IF x_msg_count > 0 THEN

Line 1490: x_return_status := fnd_api.g_ret_sts_error;

1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488: END IF;--Bug number 13096191 added
1489: IF x_msg_count > 0 THEN
1490: x_return_status := fnd_api.g_ret_sts_error;
1491: END IF;
1492:
1493: cep_standard.debug('P_COUNT: '|| x_msg_count);
1494: cep_standard.debug('<

Line 1550: x_return_status := fnd_api.g_ret_sts_success;

1546:
1547: BEGIN
1548: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_account');
1549: -- initialize API return status to success.
1550: x_return_status := fnd_api.g_ret_sts_success;
1551:
1552: COUNTRY_NAME := X_COUNTRY_NAME;
1553: l_value_out := X_ACCOUNT_NUMBER;
1554: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;

Line 1559: IF FND_API.to_Boolean(p_init_msg_list) THEN

1555:
1556: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||', l_value_out: '|| l_value_out);
1557:
1558: -- Initialize message list if p_init_msg_list is set to TRUE.
1559: IF FND_API.to_Boolean(p_init_msg_list) THEN
1560: FND_MSG_PUB.initialize;
1561: END IF;
1562:
1563: /* We must validate the Bank Account Number */

Line 1750: l_usr_valid := fnd_api.g_ret_sts_success;

1746: cep_standard.debug('CE_VALIDATE_ACCOUNT: X_ELECTRONIC_ACCT_NUM: '|| X_ELECTRONIC_ACCT_NUM);
1747:
1748: -- 9250566 ADDED 2/6 START -------------------------
1749: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1750: l_usr_valid := fnd_api.g_ret_sts_success;
1751:
1752: -- Call to custom validation routines
1753: cep_standard.debug('Calling custom validation hooks');
1754: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 1782: IF l_usr_valid = fnd_api.g_ret_sts_error

1778: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
1779: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);
1780:
1781: -- Check return status
1782: IF l_usr_valid = fnd_api.g_ret_sts_error
1783: THEN
1784: cep_standard.debug('Custom validations done - failure');
1785: IF l_count_after_custom = 0 THEN
1786: cep_standard.debug('No custom error message set');

Line 1803: p_encoded => FND_API.G_FALSE,

1799: END IF;
1800: -- 9250566 2/6 ADDED END --------------------------
1801:
1802: FND_MSG_PUB.Count_And_Get(
1803: p_encoded => FND_API.G_FALSE,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data);
1806:
1807: IF x_msg_count > 0 THEN

Line 1808: x_return_status := fnd_api.g_ret_sts_error;

1804: p_count => x_msg_count,
1805: p_data => x_msg_data);
1806:
1807: IF x_msg_count > 0 THEN
1808: x_return_status := fnd_api.g_ret_sts_error;
1809: END IF;
1810: cep_standard.debug('CE_VALIDATE_ACCOUNT: P_COUNT: '|| x_msg_count);
1811: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);
1812:

Line 1860: x_return_status := fnd_api.g_ret_sts_success;

1856:
1857: BEGIN
1858: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');
1859: -- initialize API return status to success.
1860: x_return_status := fnd_api.g_ret_sts_success;
1861:
1862: COUNTRY_NAME := X_COUNTRY_NAME;
1863: l_value_out := X_BANK_NUMBER;
1864:

Line 1869: IF FND_API.to_Boolean(p_init_msg_list) THEN

1865: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||
1866: ', l_value_out: '|| l_value_out);
1867:
1868: -- Initialize message list if p_init_msg_list is set to TRUE.
1869: IF FND_API.to_Boolean(p_init_msg_list) THEN
1870: FND_MSG_PUB.initialize;
1871: END IF;
1872:
1873: /* We must validate the Bank Number */

Line 1991: l_usr_valid := fnd_api.g_ret_sts_success;

1987: END IF; /* country unique check for bank */
1988:
1989: -- 9250566 ADDED 3/6 START -------------------------
1990: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
1991: l_usr_valid := fnd_api.g_ret_sts_success;
1992:
1993: -- Call to custom validation routines
1994: cep_standard.debug('Calling custom validation hooks');
1995: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 2013: IF l_usr_valid = fnd_api.g_ret_sts_error

2009:
2010: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
2011: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);
2012: -- Check return status
2013: IF l_usr_valid = fnd_api.g_ret_sts_error
2014: THEN
2015: cep_standard.debug('Custom validations done - failure');
2016: IF l_count_after_custom = 0 THEN
2017: cep_standard.debug('No custom error message set');

Line 2034: p_encoded => FND_API.G_FALSE,

2030: END IF;
2031: -- 9250566 ADDED 3/6 END --------------------------
2032:
2033: FND_MSG_PUB.Count_And_Get(
2034: p_encoded => FND_API.G_FALSE,
2035: p_count => x_msg_count,
2036: p_data => x_msg_data);
2037:
2038: IF X_MSG_COUNT > 0 THEN

Line 2039: x_return_status := fnd_api.g_ret_sts_error;

2035: p_count => x_msg_count,
2036: p_data => x_msg_data);
2037:
2038: IF X_MSG_COUNT > 0 THEN
2039: x_return_status := fnd_api.g_ret_sts_error;
2040: END IF;
2041:
2042: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank - P_COUNT: '||X_MSG_COUNT);
2043: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 5015: l_return_status := fnd_api.g_ret_sts_success; ---- Bug16234978

5011: RETURN;
5012: END IF;
5013:
5014: -- initialize API return status to success.
5015: l_return_status := fnd_api.g_ret_sts_success; ---- Bug16234978
5016:
5017: account_value := upper(replace(Xi_ACCOUNT_NUMBER,' ',''));
5018: account_value := replace(account_value,'-','');
5019: IF length(account_value) <= 8

Line 5035: IF l_return_status = fnd_api.g_ret_sts_error THEN

5031: Xi_SORT_CODE => branch_num,
5032: Xo_RETURN_STATUS => l_return_status);
5033: END IF;
5034: cep_standard.debug('l_return_status = '||l_return_status);
5035: IF l_return_status = fnd_api.g_ret_sts_error THEN
5036: ce_failed_check('ACCOUNT_NUM', 'CD_FAILED');
5037: ELSE
5038: ce_passed_check('ACCOUNT','GB');
5039: END IF;

Line 6675: x_return_status := fnd_api.g_ret_sts_success;

6671: BEGIN
6672: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM');
6673:
6674: -- initialize API return status to success.
6675: x_return_status := fnd_api.g_ret_sts_success;
6676:
6677: COUNTRY_NAME := X_COUNTRY_NAME;
6678: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM - COUNTRY_NAME: '|| COUNTRY_NAME);
6679:

Line 6681: IF FND_API.to_Boolean(p_init_msg_list) THEN

6677: COUNTRY_NAME := X_COUNTRY_NAME;
6678: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM - COUNTRY_NAME: '|| COUNTRY_NAME);
6679:
6680: -- Initialize message list if p_init_msg_list is set to TRUE.
6681: IF FND_API.to_Boolean(p_init_msg_list) THEN
6682: FND_MSG_PUB.initialize;
6683: END IF;
6684:
6685: EFT_NUM_VALUE := upper(replace(X_EFT_NUMBER,' ',''));

Line 6709: p_encoded => FND_API.G_FALSE,

6705: pass_check;
6706: END IF; -- end of country_name
6707:
6708: FND_MSG_PUB.Count_And_Get(
6709: p_encoded => FND_API.G_FALSE,
6710: p_count => x_msg_count,
6711: p_data => x_msg_data);
6712:
6713: IF x_msg_count > 0 THEN

Line 6714: x_return_status := fnd_api.g_ret_sts_error;

6710: p_count => x_msg_count,
6711: p_data => x_msg_data);
6712:
6713: IF x_msg_count > 0 THEN
6714: x_return_status := fnd_api.g_ret_sts_error;
6715: END IF;
6716:
6717: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_eft_num - P_COUNT: '|| x_msg_count);
6718: cep_standard.debug('<

Line 6760: x_return_status := fnd_api.g_ret_sts_success;

6756: BEGIN
6757: cep_standard.debug('>>CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT');
6758:
6759: -- initialize API return status to success.
6760: x_return_status := fnd_api.g_ret_sts_success;
6761:
6762: COUNTRY_NAME := X_COUNTRY_NAME;
6763: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT - COUNTRY_NAME: '|| COUNTRY_NAME);
6764:

Line 6766: IF FND_API.to_Boolean(p_init_msg_list) THEN

6762: COUNTRY_NAME := X_COUNTRY_NAME;
6763: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT - COUNTRY_NAME: '|| COUNTRY_NAME);
6764:
6765: -- Initialize message list if p_init_msg_list is set to TRUE.
6766: IF FND_API.to_Boolean(p_init_msg_list) THEN
6767: FND_MSG_PUB.initialize;
6768: END IF;
6769:
6770: ACCOUNT_HOLDER_ALT := X_ACCOUNT_HOLDER_ALT;

Line 6782: p_encoded => FND_API.G_FALSE,

6778: pass_check;
6779: END IF; -- end of country_name
6780:
6781: FND_MSG_PUB.Count_And_Get(
6782: p_encoded => FND_API.G_FALSE,
6783: p_count => x_msg_count,
6784: p_data => x_msg_data);
6785:
6786: IF x_msg_count > 0 THEN

Line 6787: x_return_status := fnd_api.g_ret_sts_error;

6783: p_count => x_msg_count,
6784: p_data => x_msg_data);
6785:
6786: IF x_msg_count > 0 THEN
6787: x_return_status := fnd_api.g_ret_sts_error;
6788: END IF;
6789: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_misc_acct_hldr_alt - P_COUNT: '|| x_msg_count);
6790:
6791: cep_standard.debug('<

Line 6878: x_return_status := fnd_api.g_ret_sts_success;

6874: BEGIN
6875: cep_standard.debug('>>CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
6876:
6877: -- initialize API return status to success.
6878: x_return_status := fnd_api.g_ret_sts_success;
6879:
6880: COUNTRY_NAME := X_COUNTRY_NAME;
6881: X_VALUE_OUT := X_BRANCH_NUMBER;
6882: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);

Line 6886: IF FND_API.to_Boolean(p_init_msg_list) THEN

6882: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);
6883: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);
6884:
6885: -- Initialize message list if p_init_msg_list is set to TRUE.
6886: IF FND_API.to_Boolean(p_init_msg_list) THEN
6887: FND_MSG_PUB.initialize;
6888: END IF;
6889:
6890: /* We must validate the Bank Branch Number */

Line 6940: p_encoded => FND_API.G_FALSE,

6936: fail_mandatory;
6937: END IF;
6938:
6939: FND_MSG_PUB.Count_And_Get(
6940: p_encoded => FND_API.G_FALSE,
6941: p_count => x_msg_count,
6942: p_data => x_msg_data);
6943:
6944: IF x_msg_count > 0 THEN

Line 6945: x_return_status := fnd_api.g_ret_sts_error;

6941: p_count => x_msg_count,
6942: p_data => x_msg_data);
6943:
6944: IF x_msg_count > 0 THEN
6945: x_return_status := fnd_api.g_ret_sts_error;
6946: END IF;
6947:
6948: cep_standard.debug('P_COUNT: '|| x_msg_count );
6949: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 7089: x_return_status := fnd_api.g_ret_sts_success;

7085: X_PASS_MAND_CHECK VARCHAR2(1);
7086: BEGIN
7087: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_bank_unique');
7088: -- initialize API return status to success.
7089: x_return_status := fnd_api.g_ret_sts_success;
7090:
7091: COUNTRY_NAME := X_COUNTRY_NAME;
7092: X_VALUE_OUT := X_BANK_NUMBER;
7093:

Line 7098: IF FND_API.to_Boolean(p_init_msg_list) THEN

7094: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME ||
7095: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7096:
7097: -- Initialize message list if p_init_msg_list is set to TRUE.
7098: IF FND_API.to_Boolean(p_init_msg_list) THEN
7099: FND_MSG_PUB.initialize;
7100: END IF;
7101:
7102: cep_standard.debug('P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 7121: p_encoded => FND_API.G_FALSE,

7117: END IF; /* country unique check for bank */
7118: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
7119:
7120: FND_MSG_PUB.Count_And_Get(
7121: p_encoded => FND_API.G_FALSE,
7122: p_count => x_msg_count,
7123: p_data => x_msg_data);
7124:
7125: IF x_msg_count > 0 THEN

Line 7126: x_return_status := fnd_api.g_ret_sts_error;

7122: p_count => x_msg_count,
7123: p_data => x_msg_data);
7124:
7125: IF x_msg_count > 0 THEN
7126: x_return_status := fnd_api.g_ret_sts_error;
7127: END IF;
7128:
7129: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique - P_COUNT: '|| x_msg_count);
7130: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 7176: x_return_status := fnd_api.g_ret_sts_success;

7172: BEGIN
7173: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bank');
7174:
7175: -- initialize API return status to success.
7176: x_return_status := fnd_api.g_ret_sts_success;
7177:
7178: COUNTRY_NAME := X_COUNTRY_NAME;
7179: l_value_out := X_BANK_NUMBER;
7180:

Line 7185: IF FND_API.to_Boolean(p_init_msg_list) THEN

7181: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||
7182: ', l_value_out: '|| l_value_out);
7183:
7184: -- Initialize message list if p_init_msg_list is set to TRUE.
7185: IF FND_API.to_Boolean(p_init_msg_list) THEN
7186: FND_MSG_PUB.initialize;
7187: END IF;
7188:
7189: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 7296: l_usr_valid := fnd_api.g_ret_sts_success;

7292: END IF; /* country check for bank */
7293:
7294: -- 9250566 ADDED 4/6 START -------------------------
7295: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
7296: l_usr_valid := fnd_api.g_ret_sts_success;
7297:
7298: -- Call to custom validation routines
7299: cep_standard.debug('Calling custom validation hooks');
7300: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 7319: IF l_usr_valid = fnd_api.g_ret_sts_error

7315: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
7316: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);
7317:
7318: -- Check return status
7319: IF l_usr_valid = fnd_api.g_ret_sts_error
7320: THEN
7321: cep_standard.debug('Custom validations done - failure');
7322: IF l_count_after_custom = 0 THEN
7323: cep_standard.debug('No custom error message set');

Line 7341: p_encoded => FND_API.G_FALSE,

7337: -- 9250566 ADDED 4/6 END --------------------------
7338:
7339:
7340: FND_MSG_PUB.Count_And_Get(
7341: p_encoded => FND_API.G_FALSE,
7342: p_count => x_msg_count,
7343: p_data => x_msg_data);
7344:
7345: IF x_msg_count > 0 THEN

Line 7346: x_return_status := fnd_api.g_ret_sts_error;

7342: p_count => x_msg_count,
7343: p_data => x_msg_data);
7344:
7345: IF x_msg_count > 0 THEN
7346: x_return_status := fnd_api.g_ret_sts_error;
7347: END IF;
7348:
7349: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate - P_COUNT: '|| x_msg_count);
7350: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 7393: x_return_status := fnd_api.g_ret_sts_success;

7389:
7390: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_unique');
7391:
7392: -- initialize API return status to success.
7393: x_return_status := fnd_api.g_ret_sts_success;
7394:
7395: COUNTRY_NAME := X_COUNTRY_NAME;
7396: X_VALUE_OUT := X_BRANCH_NUMBER;
7397:

Line 7402: IF FND_API.to_Boolean(p_init_msg_list) THEN

7398: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_unique - COUNTRY_NAME: '|| COUNTRY_NAME||
7399: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7400:
7401: -- Initialize message list if p_init_msg_list is set to TRUE.
7402: IF FND_API.to_Boolean(p_init_msg_list) THEN
7403: FND_MSG_PUB.initialize;
7404: END IF;
7405:
7406: /* UNIQUE VALIDATION CHECK for branch */

Line 7446: p_encoded => FND_API.G_FALSE,

7442: END IF;
7443: /* end country unique check for branch */
7444:
7445: FND_MSG_PUB.Count_And_Get(
7446: p_encoded => FND_API.G_FALSE,
7447: p_count => x_msg_count,
7448: p_data => x_msg_data);
7449:
7450: IF x_msg_count > 0 THEN

Line 7451: x_return_status := fnd_api.g_ret_sts_error;

7447: p_count => x_msg_count,
7448: p_data => x_msg_data);
7449:
7450: IF x_msg_count > 0 THEN
7451: x_return_status := fnd_api.g_ret_sts_error;
7452: END IF;
7453:
7454: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_unique - P_COUNT: '|| x_msg_count||
7455: ' X_VALUE_OUT: '|| X_VALUE_OUT||

Line 7508: x_return_status := fnd_api.g_ret_sts_success;

7504:
7505: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_branch_validate');
7506:
7507: -- initialize API return status to success.
7508: x_return_status := fnd_api.g_ret_sts_success;
7509:
7510: COUNTRY_NAME := X_COUNTRY_NAME;
7511: l_value_out := X_BRANCH_NUMBER;
7512:

Line 7517: IF FND_API.to_Boolean(p_init_msg_list) THEN

7513: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);
7514: cep_standard.debug('l_value_out: '|| l_value_out);
7515:
7516: -- Initialize message list if p_init_msg_list is set to TRUE.
7517: IF FND_API.to_Boolean(p_init_msg_list) THEN
7518: FND_MSG_PUB.initialize;
7519: END IF;
7520:
7521: /* We must validate the Bank Branch Number */

Line 7642: l_usr_valid := fnd_api.g_ret_sts_success;

7638: END IF;
7639:
7640: -- 9250566 ADDED 5/6 START -------------------------
7641: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
7642: l_usr_valid := fnd_api.g_ret_sts_success;
7643:
7644: -- Call to custom validation routines
7645: cep_standard.debug('Calling custom validation hooks');
7646: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 7669: IF l_usr_valid = fnd_api.g_ret_sts_error

7665: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
7666: X_VALUE_OUT := l_value_out_custom;
7667:
7668: -- Check return status
7669: IF l_usr_valid = fnd_api.g_ret_sts_error
7670: THEN
7671: cep_standard.debug('Custom validations done - failure');
7672: IF l_count_after_custom = 0 THEN
7673: cep_standard.debug('No custom error message set');

Line 7690: p_encoded => FND_API.G_FALSE,

7686: END IF;
7687: -- 9250566 5/6 ADDED END --------------------------
7688:
7689: FND_MSG_PUB.Count_And_Get(
7690: p_encoded => FND_API.G_FALSE,
7691: p_count => x_msg_count,
7692: p_data => x_msg_data);
7693:
7694: IF x_msg_count > 0 THEN

Line 7695: x_return_status := fnd_api.g_ret_sts_error;

7691: p_count => x_msg_count,
7692: p_data => x_msg_data);
7693:
7694: IF x_msg_count > 0 THEN
7695: x_return_status := fnd_api.g_ret_sts_error;
7696: END IF;
7697:
7698: cep_standard.debug('P_COUNT: '|| x_msg_count);
7699: cep_standard.debug(' X_VALUE_OUT: '|| X_VALUE_OUT);

Line 7744: x_return_status := fnd_api.g_ret_sts_success;

7740: BEGIN
7741: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_unique');
7742:
7743: -- initialize API return status to success.
7744: x_return_status := fnd_api.g_ret_sts_success;
7745:
7746: COUNTRY_NAME := X_COUNTRY_NAME;
7747: X_VALUE_OUT := X_ACCOUNT_NUMBER;
7748:

Line 7753: IF FND_API.to_Boolean(p_init_msg_list) THEN

7749: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||
7750: ', X_VALUE_OUT: '|| X_VALUE_OUT);
7751:
7752: -- Initialize message list if p_init_msg_list is set to TRUE.
7753: IF FND_API.to_Boolean(p_init_msg_list) THEN
7754: FND_MSG_PUB.initialize;
7755: END IF;
7756:
7757: /* UNIQUE VALIDATION CHECK for account */

Line 7788: p_encoded => FND_API.G_FALSE,

7784: END IF;
7785: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
7786:
7787: FND_MSG_PUB.Count_And_Get(
7788: p_encoded => FND_API.G_FALSE,
7789: p_count => x_msg_count,
7790: p_data => x_msg_data);
7791:
7792: IF x_msg_count > 0 THEN

Line 7793: x_return_status := fnd_api.g_ret_sts_error;

7789: p_count => x_msg_count,
7790: p_data => x_msg_data);
7791:
7792: IF x_msg_count > 0 THEN
7793: x_return_status := fnd_api.g_ret_sts_error;
7794: END IF;
7795:
7796: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique - P_COUNT: '|| x_msg_count);
7797: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 7851: x_return_status := fnd_api.g_ret_sts_success;

7847:
7848: BEGIN
7849: cep_standard.debug('>>CE_VALIDATE_BANKINFO.upd_account_validate');
7850: -- initialize API return status to success.
7851: x_return_status := fnd_api.g_ret_sts_success;
7852:
7853: COUNTRY_NAME := X_COUNTRY_NAME;
7854: l_value_out := X_ACCOUNT_NUMBER;
7855: X_ELECTRONIC_ACCT_NUM := X_ACCOUNT_NUMBER;

Line 7861: --IF FND_API.to_Boolean(p_init_msg_list) THEN

7857: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME||
7858: ', l_value_out: '|| l_value_out);
7859:
7860: -- Initialize message list if p_init_msg_list is set to TRUE.
7861: --IF FND_API.to_Boolean(p_init_msg_list) THEN
7862: FND_MSG_PUB.initialize;
7863: --END IF;
7864:
7865: /* We must validate the Bank Account Number */

Line 8018: l_usr_valid := fnd_api.g_ret_sts_success;

8014: x_return_status );
8015:
8016: -- 9250566 ADDED 6/6 START -------------------------
8017: l_count_before_custom := Nvl(FND_MSG_PUB.count_msg,0);
8018: l_usr_valid := fnd_api.g_ret_sts_success;
8019:
8020: -- Call to custom validation routines
8021: cep_standard.debug('Calling custom validation hooks');
8022: cep_standard.debug('l_count_before=' ||l_count_before_custom);

Line 8050: IF l_usr_valid = fnd_api.g_ret_sts_error

8046: cep_standard.debug('l_value_out_custom='||l_value_out_custom);
8047: X_VALUE_OUT := NVL(l_value_out_custom,l_value_out);
8048:
8049: -- Check return status
8050: IF l_usr_valid = fnd_api.g_ret_sts_error
8051: THEN
8052: cep_standard.debug('Custom validations done - failure');
8053: IF l_count_after_custom = 0 THEN
8054: cep_standard.debug('No custom error message set');

Line 8071: p_encoded => FND_API.G_FALSE,

8067: END IF;
8068: -- 9250566 6/6 ADDED END --------------------------
8069:
8070: FND_MSG_PUB.Count_And_Get(
8071: p_encoded => FND_API.G_FALSE,
8072: p_count => x_msg_count,
8073: p_data => x_msg_data);
8074:
8075: IF x_msg_count > 0 THEN

Line 8076: x_return_status := fnd_api.g_ret_sts_error;

8072: p_count => x_msg_count,
8073: p_data => x_msg_data);
8074:
8075: IF x_msg_count > 0 THEN
8076: x_return_status := fnd_api.g_ret_sts_error;
8077: END IF;
8078:
8079: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_validate - P_COUNT: '|| x_msg_count);
8080: cep_standard.debug('X_VALUE_OUT: '|| X_VALUE_OUT);

Line 8134: l_return_status := fnd_api.g_ret_sts_success;

8130: l_msg_data VARCHAR2(240);
8131: l_return_status VARCHAR2(10);
8132:
8133: BEGIN
8134: l_return_status := fnd_api.g_ret_sts_success;
8135:
8136: CE_VALIDATE_BANKINFO.ce_validate_bic(
8137: X_bic_code => p_in_BIC
8138: ,P_init_msg_list => FND_API.g_false

Line 8138: ,P_init_msg_list => FND_API.g_false

8134: l_return_status := fnd_api.g_ret_sts_success;
8135:
8136: CE_VALIDATE_BANKINFO.ce_validate_bic(
8137: X_bic_code => p_in_BIC
8138: ,P_init_msg_list => FND_API.g_false
8139: ,X_msg_count => l_msg_count
8140: ,X_msg_data => l_msg_data
8141: ,X_return_status => l_return_status
8142: );

Line 8297: Xo_return_status := fnd_api.g_ret_sts_success;

8293:
8294: begin
8295: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_mod_gb');
8296: -- initialize API return status to success.
8297: Xo_return_status := fnd_api.g_ret_sts_success;
8298:
8299: open c_modulus_checks(xi_sort_code);
8300: fetch c_modulus_checks bulk collect into t_modulus_checks;
8301: close c_modulus_checks;

Line 8537: Xo_return_status := fnd_api.g_ret_sts_success;

8533: end if; -- check required
8534: end loop;
8535: if(l_acct_valid)
8536: then
8537: Xo_return_status := fnd_api.g_ret_sts_success;
8538: cep_standard.debug('Account #'||xi_account_number||' is valid.');
8539: else
8540: Xo_return_status := fnd_api.g_ret_sts_error;
8541: cep_standard.debug('Account #'||xi_account_number||' is invalid.');

Line 8540: Xo_return_status := fnd_api.g_ret_sts_error;

8536: then
8537: Xo_return_status := fnd_api.g_ret_sts_success;
8538: cep_standard.debug('Account #'||xi_account_number||' is valid.');
8539: else
8540: Xo_return_status := fnd_api.g_ret_sts_error;
8541: cep_standard.debug('Account #'||xi_account_number||' is invalid.');
8542: end if;
8543: cep_standard.debug('< 8544: END CE_VALIDATE_MOD_GB;