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_MESSAGE

Line 83: fnd_message.set_name('CE', 'CE_INVALID_BIC_CODE');

79: l_string := nvl(translate(l_bic,'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890','0'),'0');
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

Line 88: fnd_message.set_name('CE', 'CE_INVALID_BIC_LENGTH');

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');
89: fnd_msg_pub.add;
90: x_return_status := fnd_api.g_ret_sts_error;
91: End If ;
92:

Line 154: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');

150: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
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:

Line 204: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');

200: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
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)

Line 214: fnd_message.set_name('CE', 'CE_MANY_BANKS');

210: IF l_DEBUG in ('Y', 'C') THEN
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

Line 222: fnd_message.set_name ('CE', 'CE_BANK_DOES_NOT_EXISTS');

218: THEN
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

Line 242: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

238: IF l_DEBUG in ('Y', 'C') THEN
239: cep_standard.debug('CE_VALIDATE_BANKINFO.COMPARE_BANK_AND_BRANCH_NUM ' );
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:

Line 243: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.compare_bank_and_branch_num');

239: cep_standard.debug('CE_VALIDATE_BANKINFO.COMPARE_BANK_AND_BRANCH_NUM ' );
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;

Line 300: fnd_message.set_name('CE', 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');

296: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 719: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_EXISTS');

715: IF (nvl(temp_name,0) > 0) then
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

Line 802: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUMBER_EXISTS');

798: IF (nvl(temp_number,0) > 0) then
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:

Line 886: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_ALT_EXISTS');

882: IF (nvl(temp_name_alt,0) > 0) then
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:

Line 952: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NAME_EXISTS');

948: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'temp_name: '||temp_name);
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;

Line 1151: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1147: IF l_DEBUG in ('Y', 'C') THEN
1148: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd ' ||X_COUNTRY_NAME );
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:

Line 1152: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_cd');

1148: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_cd ' ||X_COUNTRY_NAME );
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:

Line 1428: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1424: IF l_DEBUG in ('Y', 'C') THEN
1425: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_branch ' ||X_COUNTRY_NAME );
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:

Line 1429: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_branch');

1425: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_branch ' ||X_COUNTRY_NAME );
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;

Line 1565: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1561: IF l_DEBUG in ('Y', 'C') THEN
1562: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_unique ' ||X_COUNTRY_NAME );
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;

Line 1566: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_unique');

1562: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_unique ' ||X_COUNTRY_NAME );
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:

Line 1773: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

1769: IF l_DEBUG in ('Y', 'C') THEN
1770: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_validate ' ||X_COUNTRY_NAME );
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;

Line 1774: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_validate');

1770: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_branch_validate ' ||X_COUNTRY_NAME );
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:

Line 2066: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

2062:
2063: IF l_DEBUG in ('Y', 'C') THEN
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:

Line 2067: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');

2063: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 2397: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

2393:
2394: IF l_DEBUG in ('Y', 'C') THEN
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:

Line 2398: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.ce_validate_account');

2394: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 2522: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

2518:
2519: IF l_DEBUG in ('Y', 'C') THEN
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:

Line 2523: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_unique');

2519: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 2802: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

2798:
2799: IF l_DEBUG in ('Y', 'C') THEN
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;

Line 2803: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_validate');

2799: IF l_DEBUG in ('Y', 'C') THEN
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:

Line 3021: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

3017: IF l_DEBUG in ('Y', 'C') THEN
3018: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank ' ||X_COUNTRY_NAME );
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:

Line 3022: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_bank');

3018: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank ' ||X_COUNTRY_NAME );
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:

Line 3127: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

3123: IF l_DEBUG in ('Y', 'C') THEN
3124: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique ' ||X_COUNTRY_NAME );
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:

Line 3128: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_unique');

3124: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique ' ||X_COUNTRY_NAME );
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;

Line 3315: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

3311: IF l_DEBUG in ('Y', 'C') THEN
3312: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate' ||X_COUNTRY_NAME );
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:

Line 3316: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_validate');

3312: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_validate' ||X_COUNTRY_NAME );
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;

Line 3351: | This procedure populates the FND message queue with the appropriate |

3347: | PRIVATE PROCEDURE |
3348: | CE_FAILED_CHECK |
3349: | |
3350: | DESCRIPTION |
3351: | This procedure populates the FND message queue with the appropriate |
3352: | error message for any country-specific validation failure |
3353: | |
3354: | CALLED BY |
3355: | CE_VALIDATE_BANK_* for each country |

Line 3386: field_name := fnd_message.get_string('CE',field_token);

3382: ELSIF p_Field = 'TAX_PAYER_ID' THEN field_token := 'CE_TOKEN_TAX_PAYER_ID';
3383: ELSIF p_Field = 'ROUTE_NUM' THEN field_token := 'CE_TOKEN_BRANCH_NUM_US';
3384: END IF;
3385: -- Get field name from values stored in FND_NEW_MESSAGES --
3386: field_name := fnd_message.get_string('CE',field_token);
3387:
3388: -- Setting the error message name as per call --
3389: IF p_Error = 'LENGTH' THEN mesg_name := 'CE_FIELD_INVALID_LEN';
3390: ELSIF p_Error = 'LENGTH_MAX' THEN mesg_name := 'CE_FIELD_INVALID_MAX_LEN';

Line 3400: FND_MESSAGE.set_name('CE', mesg_name);

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 --
3404: IF p_Token IS NOT NULL

Line 3401: FND_MESSAGE.set_token('FIELD', field_name, true);

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 --
3404: IF p_Token IS NOT NULL
3405: THEN

Line 3418: FND_MESSAGE.set_token('VALUE', length_val, true);

3414: WHEN NO_DATA_FOUND THEN
3415: length_val := NULL;
3416: END;
3417: -- set the token --
3418: FND_MESSAGE.set_token('VALUE', length_val, true);
3419: END IF;
3420:
3421: -- populate the message queue
3422: FND_MSG_PUB.add;

Line 3434: | This procedure populates the FND message queue with the appropriate |

3430: | PRIVATE PROCEDURE |
3431: | CE_FAILED_MANDATORY |
3432: | |
3433: | DESCRIPTION |
3434: | This procedure populates the FND message queue with the appropriate |
3435: | error message for any country-specific validation field value not |
3436: | entered. |
3437: | |
3438: | CALLED BY |

Line 3464: FND_MESSAGE.set_name('CE', mesg_name);

3460: ELSIF p_Field = 'ACCOUNT_TYPE' THEN mesg_name := 'CE_ENTER_ACCOUNT_TYPE';
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('<

Line 7000: FND_MESSAGE.SET_NAME('CE','CE_TAXID_EXIST');

6996: END IF;
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

Line 7005: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');

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');
7006: fnd_msg_pub.add;
7007: END IF;
7008: IF (l_cust = 'bk4')
7009: THEN

Line 7010: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');

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');
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');

Line 7014: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');

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;
7016: END IF;
7017: IF ce_tax_id_check_algorithm(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE'
7018: THEN

Line 7022: fnd_message.set_name ('CE', 'CE_TAX_PAYER_ID_NOT_UNIQUE');

7018: THEN
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');

Line 7305: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');

7301: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: '||temp_number);
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;

Line 7372: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');

7368: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: '||temp_number);
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;

Line 7426: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');

7422: IF (nvl(temp_number,0) > 0) then
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:

Line 7606: fnd_message.set_name('CE', 'CE_BANK_NAME_ALT_EXISTS');

7602: IF (nvl(temp_name_alt,0) > 0) then
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

Line 7636: fnd_message.set_name ('CE', 'CE_ENTER_EFT_NUMBER');

7632: numeric_result varchar2(40);
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;

Line 7645: fnd_message.set_name ('CE', 'CE_INVALID_EFT_NUMBER');

7641: end fail_mandatory;
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;

Line 7742: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

7738: IF l_DEBUG in ('Y', 'C') THEN
7739: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM ' ||X_COUNTRY_NAME );
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;

Line 7743: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_eft_num');

7739: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM ' ||X_COUNTRY_NAME );
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:

Line 7764: fnd_message.set_name ('CE', 'CE_ENTER_ACCOUNT_HOLDER_ALT');

7760: numeric_result varchar2(40);
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;

Line 7843: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

7839: IF l_DEBUG in ('Y', 'C') THEN
7840: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT ' ||X_COUNTRY_NAME );
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:

Line 7844: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_acct_hldr_alt');

7840: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT ' ||X_COUNTRY_NAME );
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;

Line 7920: fnd_message.set_name ('CE', 'CE_ENTER_BRANCH_NUM');

7916: X_PASS_MAND_CHECK VARCHAR2(1);
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;

Line 8031: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');

8027: IF l_DEBUG in ('Y', 'C') THEN
8028: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT ' ||X_COUNTRY_NAME );
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:

Line 8032: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');

8028: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT ' ||X_COUNTRY_NAME );
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;