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_MSG_PUB

Line 71: FND_MSG_PUB.initialize;

67: cep_standard.debug('>>CE_VALIDATE_BANKINFO.ce_validate_bic');
68: END IF;
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean(p_init_msg_list) THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73: -- initialize API return status to success.
74: x_return_status := fnd_api.g_ret_sts_success;
75:

Line 84: fnd_msg_pub.add;

80: l_string := nvl(length(ltrim(rtrim(replace(l_string, '0', ' ')))),'0') ;
81:
82: if to_number(l_string) > 0 Then
83: fnd_message.set_name('CE', 'CE_INVALID_BIC_CODE');
84: fnd_msg_pub.add;
85: x_return_status := fnd_api.g_ret_sts_error;
86: End If ;
87: Else
88: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');

Line 89: fnd_msg_pub.add;

85: x_return_status := fnd_api.g_ret_sts_error;
86: End If ;
87: Else
88: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_error;
91: End If ;
92:
93: FND_MSG_PUB.Count_And_Get(

Line 93: FND_MSG_PUB.Count_And_Get(

89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_error;
91: End If ;
92:
93: FND_MSG_PUB.Count_And_Get(
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data);
97:

Line 155: fnd_msg_pub.add;

151: 'Bank number and branch number does not match'||
152: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
153: END IF;
154: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
155: fnd_msg_pub.add;
156:
157: END IF;
158:
159: ELSE

Line 205: fnd_msg_pub.add;

201: 'Bank number and branch number does not match'||
202: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
203: END IF;
204: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
205: fnd_msg_pub.add;
206: END IF;
207: END IF;
208: ELSIF (bank_count > 1)
209: THEN

Line 215: fnd_msg_pub.add;

211: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
212: 'EXCEPTION: More than one bank match ');
213: END IF;
214: fnd_message.set_name('CE', 'CE_MANY_BANKS');
215: fnd_msg_pub.add;
216:
217: ELSIF (bank_count = 0)
218: THEN
219: IF l_DEBUG in ('Y', 'C') THEN

Line 223: fnd_msg_pub.add;

219: IF l_DEBUG in ('Y', 'C') THEN
220: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' CE_BANK_DOES_NOT_EXISTS');
221: END IF;
222: fnd_message.set_name ('CE', 'CE_BANK_DOES_NOT_EXISTS');
223: fnd_msg_pub.add;
224:
225: ELSE
226: IF l_DEBUG in ('Y', 'C') THEN
227: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' passed_check');

Line 244: fnd_msg_pub.add;

240: END IF;
241:
242: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
243: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.compare_bank_and_branch_num');
244: fnd_msg_pub.add;
245: RAISE;
246:
247: END COMPARE_BANK_AND_BRANCH_NUM;
248:

Line 301: fnd_msg_pub.add;

297: cep_standard.debug('COMPARE_ACCOUNT_NUM_AND_CD: ' || 'CD does not match'||
298: 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
299: END IF;
300: fnd_message.set_name('CE', 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
301: fnd_msg_pub.add;
302: return false;
303: ELSE
304: pass_check;
305: return true;

Line 720: fnd_msg_pub.add;

716: IF l_DEBUG in ('Y', 'C') THEN
717: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_EXISTS');
718: END IF;
719: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_EXISTS');
720: fnd_msg_pub.add;
721: END IF;
722:
723: IF l_DEBUG in ('Y', 'C') THEN
724: cep_standard.debug('<

Line 803: fnd_msg_pub.add;

799: IF l_DEBUG in ('Y', 'C') THEN
800: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NUMBER_EXISTS');
801: END IF;
802: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUMBER_EXISTS');
803: fnd_msg_pub.add;
804: END IF;
805:
806:
807: IF l_DEBUG in ('Y', 'C') THEN

Line 887: fnd_msg_pub.add;

883: IF l_DEBUG in ('Y', 'C') THEN
884: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
885: END IF;
886: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
887: fnd_msg_pub.add;
888: END IF;
889:
890:
891: IF l_DEBUG in ('Y', 'C') THEN

Line 953: fnd_msg_pub.add;

949: END IF;
950:
951: IF (nvl(temp_name,0) > 0) then
952: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NAME_EXISTS');
953: fnd_msg_pub.add;
954: IF l_DEBUG in ('Y', 'C') THEN
955: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'CE_BANK_ACCOUNT_NAME_EXISTS');
956: END IF;
957: END IF;

Line 1018: FND_MSG_PUB.initialize;

1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean(p_init_msg_list) THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: /* We must validate the Check Digit
1022: Bug 6632733 Making check digit validation optional so assigning P instead of earlier F */

Line 1130: FND_MSG_PUB.Count_And_Get(

1126: END IF;
1127:
1128: End If ; -- End Bug 6632733
1129:
1130: FND_MSG_PUB.Count_And_Get(
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data);
1134:

Line 1153: fnd_msg_pub.add;

1149: END IF;
1150:
1151: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1152: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_cd');
1153: fnd_msg_pub.add;
1154: RAISE;
1155:
1156:
1157: END CE_VALIDATE_CD;

Line 1215: FND_MSG_PUB.initialize;

1211: END IF;
1212:
1213: -- Initialize message list if p_init_msg_list is set to TRUE.
1214: IF FND_API.to_Boolean(p_init_msg_list) THEN
1215: FND_MSG_PUB.initialize;
1216: END IF;
1217:
1218: IF l_DEBUG in ('Y', 'C') THEN
1219: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_branch - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 1407: FND_MSG_PUB.Count_And_Get(

1403: IF l_DEBUG in ('Y', 'C') THEN
1404: cep_standard.debug('UNIQUE VALIDATION CHECK for branch end' );
1405: END IF;
1406:
1407: FND_MSG_PUB.Count_And_Get(
1408: p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:

Line 1430: fnd_msg_pub.add;

1426: END IF;
1427:
1428: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1429: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_branch');
1430: fnd_msg_pub.add;
1431: RAISE;
1432:
1433: END CE_VALIDATE_BRANCH;
1434:

Line 1485: FND_MSG_PUB.initialize;

1481: END IF;
1482:
1483: -- Initialize message list if p_init_msg_list is set to TRUE.
1484: IF FND_API.to_Boolean(p_init_msg_list) THEN
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487:
1488: /** UNIQUE VALIDATION CHECK for branch **/
1489:

Line 1544: FND_MSG_PUB.Count_And_Get(

1540: END IF;
1541: /** end country unique check for branch **/
1542:
1543:
1544: FND_MSG_PUB.Count_And_Get(
1545: p_encoded => FND_API.G_FALSE,
1546: p_count => x_msg_count,
1547: p_data => x_msg_data);
1548:

Line 1567: fnd_msg_pub.add;

1563: END IF;
1564:
1565: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1566: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_unique');
1567: fnd_msg_pub.add;
1568: RAISE;
1569: END UPD_BRANCH_UNIQUE;
1570:
1571:

Line 1623: FND_MSG_PUB.initialize;

1619: END IF;
1620:
1621: -- Initialize message list if p_init_msg_list is set to TRUE.
1622: IF FND_API.to_Boolean(p_init_msg_list) THEN
1623: FND_MSG_PUB.initialize;
1624: END IF;
1625:
1626: /* We must validate the Bank Branch Number */
1627:

Line 1752: FND_MSG_PUB.Count_And_Get(

1748: X_PASS_MAND_CHECK);
1749:
1750: END IF;
1751:
1752: FND_MSG_PUB.Count_And_Get(
1753: p_encoded => FND_API.G_FALSE,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data);
1756:

Line 1775: fnd_msg_pub.add;

1771: END IF;
1772:
1773: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1774: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_validate');
1775: fnd_msg_pub.add;
1776: RAISE;
1777: END UPD_BRANCH_VALIDATE;
1778:
1779: /* ----------------------------------------------------------------------- */

Line 2005: FND_MSG_PUB.initialize;

2001: END IF;
2002:
2003: -- Initialize message list if p_init_msg_list is set to TRUE.
2004: IF FND_API.to_Boolean(p_init_msg_list) THEN
2005: FND_MSG_PUB.initialize;
2006: END IF;
2007:
2008: IF l_DEBUG in ('Y', 'C') THEN
2009: cep_standard.debug('P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 2047: FND_MSG_PUB.Count_And_Get(

2043: X_ELECTRONIC_ACCT_NUM
2044: );
2045: END IF;
2046:
2047: FND_MSG_PUB.Count_And_Get(
2048: p_encoded => FND_API.G_FALSE,
2049: p_count => x_msg_count,
2050: p_data => x_msg_data);
2051:

Line 2068: fnd_msg_pub.add;

2064: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM ' ||X_COUNTRY_NAME );
2065: END IF;
2066: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2067: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
2068: fnd_msg_pub.add;
2069: RAISE;
2070:
2071: END CE_FORMAT_ELECTRONIC_NUM;
2072:

Line 2134: FND_MSG_PUB.initialize;

2130: END IF;
2131:
2132: -- Initialize message list if p_init_msg_list is set to TRUE.
2133: IF FND_API.to_Boolean(p_init_msg_list) THEN
2134: FND_MSG_PUB.initialize;
2135: END IF;
2136:
2137: IF l_DEBUG in ('Y', 'C') THEN
2138: cep_standard.debug('P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 2376: FND_MSG_PUB.Count_And_Get(

2372: cep_standard.debug('CE_VALIDATE_ACCOUNT: X_ELECTRONIC_ACCT_NUM: '|| X_ELECTRONIC_ACCT_NUM);
2373: END IF;
2374:
2375:
2376: FND_MSG_PUB.Count_And_Get(
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:

Line 2399: fnd_msg_pub.add;

2395: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_account ' ||X_COUNTRY_NAME );
2396: END IF;
2397: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2398: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.ce_validate_account');
2399: fnd_msg_pub.add;
2400: RAISE;
2401:
2402: END CE_VALIDATE_ACCOUNT;
2403:

Line 2456: FND_MSG_PUB.initialize;

2452: END IF;
2453:
2454: -- Initialize message list if p_init_msg_list is set to TRUE.
2455: IF FND_API.to_Boolean(p_init_msg_list) THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;
2458:
2459: IF l_DEBUG in ('Y', 'C') THEN
2460: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 2501: FND_MSG_PUB.Count_And_Get(

2497: IF l_DEBUG in ('Y', 'C') THEN
2498: cep_standard.debug(' UNIQUE_VALIDATION CHECK for account end ');
2499: END IF;
2500:
2501: FND_MSG_PUB.Count_And_Get(
2502: p_encoded => FND_API.G_FALSE,
2503: p_count => x_msg_count,
2504: p_data => x_msg_data);
2505:

Line 2524: fnd_msg_pub.add;

2520: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique ' ||X_COUNTRY_NAME );
2521: END IF;
2522: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2523: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_unique');
2524: fnd_msg_pub.add;
2525: RAISE;
2526:
2527: END UPD_ACCOUNT_UNIQUE;
2528:

Line 2587: FND_MSG_PUB.initialize;

2583: END IF;
2584:
2585: -- Initialize message list if p_init_msg_list is set to TRUE.
2586: --IF FND_API.to_Boolean(p_init_msg_list) THEN
2587: FND_MSG_PUB.initialize;
2588: --END IF;
2589:
2590: IF l_DEBUG in ('Y', 'C') THEN
2591: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_validate - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 2781: FND_MSG_PUB.Count_And_Get(

2777: x_return_status );
2778:
2779:
2780:
2781: FND_MSG_PUB.Count_And_Get(
2782: p_encoded => FND_API.G_FALSE,
2783: p_count => x_msg_count,
2784: p_data => x_msg_data);
2785:

Line 2804: fnd_msg_pub.add;

2800: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_validate ' ||X_COUNTRY_NAME );
2801: END IF;
2802: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2803: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_validate');
2804: fnd_msg_pub.add;
2805: RAISE;
2806: END UPD_ACCOUNT_VALIDATE;
2807:
2808:

Line 2860: FND_MSG_PUB.initialize;

2856:
2857:
2858: -- Initialize message list if p_init_msg_list is set to TRUE.
2859: IF FND_API.to_Boolean(p_init_msg_list) THEN
2860: FND_MSG_PUB.initialize;
2861: END IF;
2862:
2863: IF l_DEBUG in ('Y', 'C') THEN
2864: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 3000: FND_MSG_PUB.Count_And_Get(

2996: IF l_DEBUG in ('Y', 'C') THEN
2997: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
2998: END IF;
2999:
3000: FND_MSG_PUB.Count_And_Get(
3001: p_encoded => FND_API.G_FALSE,
3002: p_count => x_msg_count,
3003: p_data => x_msg_data);
3004:

Line 3023: fnd_msg_pub.add;

3019: END IF;
3020:
3021: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
3022: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_bank');
3023: fnd_msg_pub.add;
3024: RAISE;
3025:
3026:
3027: END CE_VALIDATE_BANK;

Line 3076: FND_MSG_PUB.initialize;

3072:
3073:
3074: -- Initialize message list if p_init_msg_list is set to TRUE.
3075: IF FND_API.to_Boolean(p_init_msg_list) THEN
3076: FND_MSG_PUB.initialize;
3077: END IF;
3078:
3079: IF l_DEBUG in ('Y', 'C') THEN
3080: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 3106: FND_MSG_PUB.Count_And_Get(

3102: IF l_DEBUG in ('Y', 'C') THEN
3103: cep_standard.debug('CE_VALIDATE_CD: ' || 'UNIQUE VALIDATION CHECK for bank end' );
3104: END IF;
3105:
3106: FND_MSG_PUB.Count_And_Get(
3107: p_encoded => FND_API.G_FALSE,
3108: p_count => x_msg_count,
3109: p_data => x_msg_data);
3110:

Line 3129: fnd_msg_pub.add;

3125: END IF;
3126:
3127: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
3128: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_unique');
3129: fnd_msg_pub.add;
3130: RAISE;
3131:
3132: END UPD_BANK_UNIQUE;
3133:

Line 3183: FND_MSG_PUB.initialize;

3179:
3180:
3181: -- Initialize message list if p_init_msg_list is set to TRUE.
3182: IF FND_API.to_Boolean(p_init_msg_list) THEN
3183: FND_MSG_PUB.initialize;
3184: END IF;
3185:
3186: IF l_DEBUG in ('Y', 'C') THEN
3187: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 3294: FND_MSG_PUB.Count_And_Get(

3290: X_PASS_MAND_CHECK);
3291:
3292: END IF; /** country check for bank **/
3293:
3294: FND_MSG_PUB.Count_And_Get(
3295: p_encoded => FND_API.G_FALSE,
3296: p_count => x_msg_count,
3297: p_data => x_msg_data);
3298:

Line 3317: fnd_msg_pub.add;

3313: END IF;
3314:
3315: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
3316: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_validate');
3317: fnd_msg_pub.add;
3318: RAISE;
3319:
3320: END UPD_BANK_VALIDATE;
3321:

Line 3399: -- set the value for the tokens and add message to FND_MSG_PUB --

3395: ELSIF p_Error = 'INVALID_FORMAT' THEN mesg_name := 'CE_FIELD_INVALID_FORMAT';
3396: ELSIF p_Error = 'INVALID_RTN' THEN mesg_name := 'CE_FIELD_INVALID_RTN';
3397: END IF;
3398:
3399: -- set the value for the tokens and add message to FND_MSG_PUB --
3400: FND_MESSAGE.set_name('CE', mesg_name);
3401: FND_MESSAGE.set_token('FIELD', field_name, true);
3402:
3403: -- For length related errors, need to populate the VALUE token --

Line 3422: FND_MSG_PUB.add;

3418: FND_MESSAGE.set_token('VALUE', length_val, true);
3419: END IF;
3420:
3421: -- populate the message queue
3422: FND_MSG_PUB.add;
3423:
3424: IF l_DEBUG in ('Y', 'C') THEN
3425: cep_standard.debug('< 3426: END IF;

Line 3465: FND_MSG_PUB.add;

3461: ELSIF p_Field = 'ACCOUNT_SUFFIX' THEN mesg_name := 'CE_ENTER_ACCOUNT_SUFFIX';
3462: END IF;
3463:
3464: FND_MESSAGE.set_name('CE', mesg_name);
3465: FND_MSG_PUB.add;
3466:
3467: IF l_DEBUG in ('Y', 'C') THEN
3468: cep_standard.debug('< 3469: END IF;

Line 7001: fnd_msg_pub.add;

6997:
6998: IF (l_supp = 'bk3' OR l_cust= 'bk2' OR l_comp = 'bk1')
6999: THEN
7000: FND_MESSAGE.SET_NAME('CE','CE_TAXID_EXIST');
7001: fnd_msg_pub.add;
7002: END IF;
7003: IF (l_supp = 'bk5')
7004: THEN
7005: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');

Line 7006: fnd_msg_pub.add;

7002: END IF;
7003: IF (l_supp = 'bk5')
7004: THEN
7005: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');
7006: fnd_msg_pub.add;
7007: END IF;
7008: IF (l_cust = 'bk4')
7009: THEN
7010: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');

Line 7011: fnd_msg_pub.add;

7007: END IF;
7008: IF (l_cust = 'bk4')
7009: THEN
7010: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');
7011: fnd_msg_pub.add;
7012: END IF;
7013: IF (l_comp = 'bk6') THEN
7014: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
7015: fnd_msg_pub.add;

Line 7015: fnd_msg_pub.add;

7011: fnd_msg_pub.add;
7012: END IF;
7013: IF (l_comp = 'bk6') THEN
7014: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
7015: fnd_msg_pub.add;
7016: END IF;
7017: IF ce_tax_id_check_algorithm(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE'
7018: THEN
7019: ce_failed_check('TAX_PAYER_ID','CD_FAILED');

Line 7023: fnd_msg_pub.add;

7019: ce_failed_check('TAX_PAYER_ID','CD_FAILED');
7020: END IF; /* end of check digit validation */
7021: ELSE
7022: fnd_message.set_name ('CE', 'CE_TAX_PAYER_ID_NOT_UNIQUE');
7023: fnd_msg_pub.add;
7024: END IF; /* end of unique check */
7025: ELSE
7026: ce_failed_check('TAX_PAYER_ID','NUMERIC');
7027: END IF; /* end of numeric check */

Line 7306: fnd_msg_pub.add;

7302: END IF;
7303:
7304: IF (nvl(temp_number,0) > 0) then
7305: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
7306: fnd_msg_pub.add;
7307: IF l_DEBUG in ('Y', 'C') THEN
7308: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
7309: END IF;
7310: END IF;

Line 7373: fnd_msg_pub.add;

7369: END IF;
7370:
7371: IF (nvl(temp_number,0) > 0) then
7372: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
7373: fnd_msg_pub.add;
7374: IF l_DEBUG in ('Y', 'C') THEN
7375: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
7376: END IF;
7377: END IF;

Line 7427: fnd_msg_pub.add;

7423: IF l_DEBUG in ('Y', 'C') THEN
7424: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
7425: END IF;
7426: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
7427: fnd_msg_pub.add;
7428: END IF;
7429:
7430:
7431: -- unique combination -> bank_branch_id, bank account name

Line 7607: fnd_msg_pub.add;

7603: IF l_DEBUG in ('Y', 'C') THEN
7604: cep_standard.debug('CE_VALIDATE_UNIQUE_BANK_JP: ' || 'CE_BANK_NAME_ALT_EXISTS');
7605: END IF;
7606: fnd_message.set_name('CE', 'CE_BANK_NAME_ALT_EXISTS');
7607: fnd_msg_pub.add;
7608: END IF;
7609:
7610: IF l_DEBUG in ('Y', 'C') THEN
7611: cep_standard.debug('<

Line 7637: fnd_msg_pub.add;

7633:
7634: procedure fail_mandatory is
7635: begin
7636: fnd_message.set_name ('CE', 'CE_ENTER_EFT_NUMBER');
7637: fnd_msg_pub.add;
7638: IF l_DEBUG in ('Y', 'C') THEN
7639: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_ENTER_EFT_NUMBER');
7640: END IF;
7641: end fail_mandatory;

Line 7646: fnd_msg_pub.add;

7642:
7643: procedure fail_check is
7644: begin
7645: fnd_message.set_name ('CE', 'CE_INVALID_EFT_NUMBER');
7646: fnd_msg_pub.add;
7647: IF l_DEBUG in ('Y', 'C') THEN
7648: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_INVALID_EFT_NUMBER');
7649: END IF;
7650: end fail_check;

Line 7679: FND_MSG_PUB.initialize;

7675: END IF;
7676:
7677: -- Initialize message list if p_init_msg_list is set to TRUE.
7678: IF FND_API.to_Boolean(p_init_msg_list) THEN
7679: FND_MSG_PUB.initialize;
7680: END IF;
7681:
7682: IF l_DEBUG in ('Y', 'C') THEN
7683: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 7720: FND_MSG_PUB.Count_And_Get(

7716: pass_check;
7717: END IF; -- end of country_name
7718:
7719:
7720: FND_MSG_PUB.Count_And_Get(
7721: p_encoded => FND_API.G_FALSE,
7722: p_count => x_msg_count,
7723: p_data => x_msg_data);
7724:

Line 7744: fnd_msg_pub.add;

7740: END IF;
7741:
7742: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7743: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_eft_num');
7744: fnd_msg_pub.add;
7745: RAISE;
7746: END CE_VALIDATE_MISC_EFT_NUM;
7747:
7748: /* -------------------------------------------------------------------- */

Line 7765: fnd_msg_pub.add;

7761:
7762: procedure fail_mandatory is
7763: begin
7764: fnd_message.set_name ('CE', 'CE_ENTER_ACCOUNT_HOLDER_ALT');
7765: fnd_msg_pub.add;
7766: IF l_DEBUG in ('Y', 'C') THEN
7767: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT: ' || 'CE_ENTER_ACCOUNT_HOLDER_ALT');
7768: END IF;
7769: end fail_mandatory;

Line 7798: FND_MSG_PUB.initialize;

7794: END IF;
7795:
7796: -- Initialize message list if p_init_msg_list is set to TRUE.
7797: IF FND_API.to_Boolean(p_init_msg_list) THEN
7798: FND_MSG_PUB.initialize;
7799: END IF;
7800:
7801: IF l_DEBUG in ('Y', 'C') THEN
7802: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT: P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 7821: FND_MSG_PUB.Count_And_Get(

7817: pass_check;
7818: END IF; -- end of country_name
7819:
7820:
7821: FND_MSG_PUB.Count_And_Get(
7822: p_encoded => FND_API.G_FALSE,
7823: p_count => x_msg_count,
7824: p_data => x_msg_data);
7825:

Line 7845: fnd_msg_pub.add;

7841: END IF;
7842:
7843: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7844: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_acct_hldr_alt');
7845: fnd_msg_pub.add;
7846: RAISE;
7847:
7848: END CE_VALIDATE_MISC_ACCT_HLDR_ALT;
7849:

Line 7921: fnd_msg_pub.add;

7917:
7918: procedure fail_mandatory is
7919: begin
7920: fnd_message.set_name ('CE', 'CE_ENTER_BRANCH_NUM');
7921: fnd_msg_pub.add;
7922: IF l_DEBUG in ('Y', 'C') THEN
7923: cep_standard.debug('GET_BRANCH_NUM_FORMAT: ' || 'CE_ENTER_BRANCH_NUM');
7924: END IF;
7925: end fail_mandatory;

Line 7949: FND_MSG_PUB.initialize;

7945: END IF;
7946:
7947: -- Initialize message list if p_init_msg_list is set to TRUE.
7948: IF FND_API.to_Boolean(p_init_msg_list) THEN
7949: FND_MSG_PUB.initialize;
7950: END IF;
7951:
7952: IF l_DEBUG in ('Y', 'C') THEN
7953: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

Line 8009: FND_MSG_PUB.Count_And_Get(

8005: ELSE
8006: fail_mandatory;
8007: END IF;
8008:
8009: FND_MSG_PUB.Count_And_Get(
8010: p_encoded => FND_API.G_FALSE,
8011: p_count => x_msg_count,
8012: p_data => x_msg_data);
8013:

Line 8033: fnd_msg_pub.add;

8029: END IF;
8030:
8031: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
8032: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
8033: fnd_msg_pub.add;
8034: RAISE;
8035:
8036: END GET_BRANCH_NUM_FORMAT;
8037: