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 49: fnd_message.set_name('CE', 'CE_BRANCH_END_DATE');

45: WHERE NVL(end_date,Xi_BRANCH_END_DATE+1) > Xi_BRANCH_END_DATE
46: AND branch_id = Xi_BRANCH_ID;
47: cep_standard.debug( 'Number of active external bankaccounts = '||l_count_ext);
48: IF (l_count_int > 0 OR l_count_ext > 0) THEN
49: fnd_message.set_name('CE', 'CE_BRANCH_END_DATE');
50: FND_MESSAGE.set_token('FIELD1', l_count_int, true);
51: FND_MESSAGE.set_token('FIELD2', l_count_ext, true);
52: fnd_msg_pub.add;
53: END IF;

Line 50: FND_MESSAGE.set_token('FIELD1', l_count_int, true);

46: AND branch_id = Xi_BRANCH_ID;
47: cep_standard.debug( 'Number of active external bankaccounts = '||l_count_ext);
48: IF (l_count_int > 0 OR l_count_ext > 0) THEN
49: fnd_message.set_name('CE', 'CE_BRANCH_END_DATE');
50: FND_MESSAGE.set_token('FIELD1', l_count_int, true);
51: FND_MESSAGE.set_token('FIELD2', l_count_ext, true);
52: fnd_msg_pub.add;
53: END IF;
54: cep_standard.debug('<

Line 51: FND_MESSAGE.set_token('FIELD2', l_count_ext, true);

47: cep_standard.debug( 'Number of active external bankaccounts = '||l_count_ext);
48: IF (l_count_int > 0 OR l_count_ext > 0) THEN
49: fnd_message.set_name('CE', 'CE_BRANCH_END_DATE');
50: FND_MESSAGE.set_token('FIELD1', l_count_int, true);
51: FND_MESSAGE.set_token('FIELD2', l_count_ext, true);
52: fnd_msg_pub.add;
53: END IF;
54: cep_standard.debug('< 55: END;

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

114: l_string := nvl(translate(l_bic,'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890','0'),'0');
115: l_string := nvl(length(ltrim(rtrim(replace(l_string, '0', ' ')))),'0') ;
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

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

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;
125: x_return_status := fnd_api.g_ret_sts_error;
126: END IF ;
127:

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

178: ELSE
179: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
180: 'Bank number and branch number does not match'||
181: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
182: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
183: fnd_msg_pub.add;
184: END IF;
185:
186: ELSE

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

223: THEN
224: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||
225: 'Bank number and branch number does not match'||
226: 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
227: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUM_NOT_MATCHED');
228: fnd_msg_pub.add;
229: END IF;
230: END IF;
231: ELSIF (bank_count > 1)

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

230: END IF;
231: ELSIF (bank_count > 1)
232: THEN
233: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' ||'EXCEPTION: More than one bank match ');
234: fnd_message.set_name('CE', 'CE_MANY_BANKS');
235: fnd_msg_pub.add;
236:
237: ELSIF (bank_count = 0)
238: THEN

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

236:
237: ELSIF (bank_count = 0)
238: THEN
239: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' CE_BANK_DOES_NOT_EXISTS');
240: fnd_message.set_name ('CE', 'CE_BANK_DOES_NOT_EXISTS');
241: fnd_msg_pub.add;
242:
243: ELSE
244: cep_standard.debug('COMPARE_BANK_AND_BRANCH_NUM: ' || ' passed_check');

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

249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: cep_standard.debug('CE_VALIDATE_BANKINFO.COMPARE_BANK_AND_BRANCH_NUM: Exception ' );
253: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
254: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.compare_bank_and_branch_num');
255: fnd_msg_pub.add;
256: RAISE;
257: END COMPARE_BANK_AND_BRANCH_NUM;

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

250: EXCEPTION
251: WHEN OTHERS THEN
252: cep_standard.debug('CE_VALIDATE_BANKINFO.COMPARE_BANK_AND_BRANCH_NUM: Exception ' );
253: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
254: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.compare_bank_and_branch_num');
255: fnd_msg_pub.add;
256: RAISE;
257: END COMPARE_BANK_AND_BRANCH_NUM;
258:

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

288: IF (acct_cd <> Xi_CD) THEN
289: cep_standard.debug('COMPARE_ACCOUNT_NUM_AND_CD: ' || 'CD does not match'||
290: 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
291:
292: fnd_message.set_name('CE', 'CE_ACCT_NUM_AND_CD_NOT_MATCHED');
293: fnd_msg_pub.add;
294: RETURN FALSE;
295: ELSE
296: cep_standard.debug('COMPARE_ACCOUNT_NUM_AND_CD: ' || 'CD match');

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

635: cep_standard.debug('CE_UNIQUE_BRANCH_NAME - temp_name: ' ||temp_name);
636:
637: IF (nvl(temp_name,0) > 0) THEN
638: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_EXISTS');
639: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_EXISTS');
640: fnd_msg_pub.add;
641: END IF;
642:
643: cep_standard.debug('<

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

713: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_UNIQUE_BRANCH_NUMBER - temp_number: ' ||temp_number);
714:
715: IF (nvl(temp_number,0) > 0) THEN
716: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NUMBER_EXISTS');
717: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NUMBER_EXISTS');
718: fnd_msg_pub.add;
719: END IF;
720:
721: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || '<

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

787: cep_standard.debug('CE_UNIQUE_BRANCH_NAME_ALT - temp_name_alt: ' ||temp_name_alt);
788:
789: IF (nvl(temp_name_alt,0) > 0) THEN
790: cep_standard.debug('CE_UNIQUE_BRANCH_NAME: ' || 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
791: fnd_message.set_name('CE', 'CE_BANK_BRANCH_NAME_ALT_EXISTS');
792: fnd_msg_pub.add;
793: END IF;
794:
795: cep_standard.debug('<

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

829:
830: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'temp_name: '||temp_name);
831:
832: IF (nvl(temp_name,0) > 0) THEN
833: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NAME_EXISTS');
834: fnd_msg_pub.add;
835: cep_standard.debug('CE_UNIQUE_ACCOUNT_NAME: ' || 'CE_BANK_ACCOUNT_NAME_EXISTS');
836: END IF;
837:

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

983: EXCEPTION
984: WHEN OTHERS THEN
985: cep_standard.debug('Exception: CE_VALIDATE_BANKINFO.ce_validate_cd ' ||X_COUNTRY_NAME );
986:
987: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
988: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_cd');
989: fnd_msg_pub.add;
990: RAISE;
991: END CE_VALIDATE_CD;

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

984: WHEN OTHERS THEN
985: cep_standard.debug('Exception: CE_VALIDATE_BANKINFO.ce_validate_cd ' ||X_COUNTRY_NAME );
986:
987: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
988: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_cd');
989: fnd_msg_pub.add;
990: RAISE;
991: END CE_VALIDATE_CD;
992:

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

1270:
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: cep_standard.debug('EXCEPTION: ce_validate_branch ' ||X_COUNTRY_NAME );
1274: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1275: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_branch');
1276: fnd_msg_pub.add;
1277: RAISE;
1278: END CE_VALIDATE_BRANCH;

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

1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: cep_standard.debug('EXCEPTION: ce_validate_branch ' ||X_COUNTRY_NAME );
1274: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1275: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_branch');
1276: fnd_msg_pub.add;
1277: RAISE;
1278: END CE_VALIDATE_BRANCH;
1279:

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

1494: cep_standard.debug('< 1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: cep_standard.debug('EXCEPTION: CE_FORMAT_ELECTRONIC_NUM ' ||X_COUNTRY_NAME );
1498: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1499: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
1500: fnd_msg_pub.add;
1501: RAISE;
1502: END CE_FORMAT_ELECTRONIC_NUM;

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

1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: cep_standard.debug('EXCEPTION: CE_FORMAT_ELECTRONIC_NUM ' ||X_COUNTRY_NAME );
1498: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1499: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.CE_FORMAT_ELECTRONIC_NUM');
1500: fnd_msg_pub.add;
1501: RAISE;
1502: END CE_FORMAT_ELECTRONIC_NUM;
1503:

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

1813: cep_standard.debug('< 1814: EXCEPTION
1815: WHEN OTHERS THEN
1816: cep_standard.debug('EXCEPTION: ce_validate_account ' ||X_COUNTRY_NAME );
1817: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1818: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.ce_validate_account');
1819: fnd_msg_pub.add;
1820: RAISE;
1821: END CE_VALIDATE_ACCOUNT;

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

1814: EXCEPTION
1815: WHEN OTHERS THEN
1816: cep_standard.debug('EXCEPTION: ce_validate_account ' ||X_COUNTRY_NAME );
1817: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1818: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.ce_validate_account');
1819: fnd_msg_pub.add;
1820: RAISE;
1821: END CE_VALIDATE_ACCOUNT;
1822:

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

2045:
2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank ' ||X_COUNTRY_NAME );
2049: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2050: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_bank');
2051: fnd_msg_pub.add;
2052: RAISE;
2053: END CE_VALIDATE_BANK;

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

2046: EXCEPTION
2047: WHEN OTHERS THEN
2048: cep_standard.debug('CE_VALIDATE_BANKINFO.ce_validate_bank ' ||X_COUNTRY_NAME );
2049: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
2050: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_bank');
2051: fnd_msg_pub.add;
2052: RAISE;
2053: END CE_VALIDATE_BANK;
2054:

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

2079: | PRIVATE PROCEDURE |
2080: | CE_FAILED_CHECK |
2081: | |
2082: | DESCRIPTION |
2083: | This procedure populates the FND message queue with the appropriate |
2084: | error message for any country-specific validation failure |
2085: | |
2086: | CALLED BY |
2087: | CE_VALIDATE_BANK_* for each country |

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

2114: END IF;
2115:
2116: cep_standard.debug('field_token = '||field_token);
2117: -- Get field name from values stored in FND_NEW_MESSAGES --
2118: field_name := fnd_message.get_string('CE',field_token);
2119: cep_standard.debug('field_name = '||field_name);
2120:
2121: -- Setting the error message name as per call --
2122: IF p_Error = 'LENGTH' THEN mesg_name := 'CE_FIELD_INVALID_LEN';

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

2131: END IF;
2132:
2133: cep_standard.debug('mesg_name = '||mesg_name);
2134: -- set the value for the tokens and add message to FND_MSG_PUB --
2135: FND_MESSAGE.set_name('CE', mesg_name);
2136: FND_MESSAGE.set_token('FIELD', field_name, true);
2137:
2138: -- For length related errors, need to populate the VALUE token --
2139: IF p_Token IS NOT NULL

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

2132:
2133: cep_standard.debug('mesg_name = '||mesg_name);
2134: -- set the value for the tokens and add message to FND_MSG_PUB --
2135: FND_MESSAGE.set_name('CE', mesg_name);
2136: FND_MESSAGE.set_token('FIELD', field_name, true);
2137:
2138: -- For length related errors, need to populate the VALUE token --
2139: IF p_Token IS NOT NULL
2140: THEN

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

2149: WHEN NO_DATA_FOUND THEN
2150: length_val := NULL;
2151: END;
2152: -- set the token --
2153: FND_MESSAGE.set_token('VALUE', length_val, true);
2154: END IF;
2155:
2156: -- populate the message queue
2157: FND_MSG_PUB.add;

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

2163: | PRIVATE PROCEDURE |
2164: | CE_FAILED_MANDATORY |
2165: | |
2166: | DESCRIPTION |
2167: | This procedure populates the FND message queue with the appropriate |
2168: | error message for any country-specific validation field value not |
2169: | entered. |
2170: | |
2171: | CALLED BY |

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

2193: END IF;
2194:
2195: cep_standard.debug('mesg_name = '||mesg_name);
2196:
2197: FND_MESSAGE.set_name('CE', mesg_name);
2198: FND_MSG_PUB.add;
2199:
2200: cep_standard.debug('< 2201: END CE_FAILED_MANDATORY;

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

6033: cep_standard.debug('l_bank : '|| l_bank );
6034:
6035: IF (l_supp = 'bk3' OR l_cust= 'bk2' OR l_comp = 'bk1')
6036: THEN
6037: FND_MESSAGE.SET_NAME('CE','CE_TAXID_EXIST');
6038: fnd_msg_pub.add;
6039: END IF;
6040: IF (l_supp = 'bk5')
6041: THEN

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

6038: fnd_msg_pub.add;
6039: END IF;
6040: IF (l_supp = 'bk5')
6041: THEN
6042: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_SUPP');
6043: fnd_msg_pub.add;
6044: END IF;
6045: IF (l_cust = 'bk4')
6046: THEN

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

6043: fnd_msg_pub.add;
6044: END IF;
6045: IF (l_cust = 'bk4')
6046: THEN
6047: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');
6048: fnd_msg_pub.add;
6049: END IF;
6050: IF (l_comp = 'bk6') THEN
6051: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');

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

6047: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_CUST');
6048: fnd_msg_pub.add;
6049: END IF;
6050: IF (l_comp = 'bk6') THEN
6051: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
6052: fnd_msg_pub.add;
6053: END IF;
6054: IF ce_tax_id_check_algorithm(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE'
6055: THEN

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

6055: THEN
6056: ce_failed_check('TAX_PAYER_ID','CD_FAILED');
6057: END IF; /* end of check digit validation */
6058: ELSE
6059: fnd_message.set_name ('CE', 'CE_TAX_PAYER_ID_NOT_UNIQUE');
6060: fnd_msg_pub.add;
6061: END IF; /* end of unique check */
6062: ELSE
6063: ce_failed_check('TAX_PAYER_ID','NUMERIC');

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

6367: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: '||temp_number);
6368:
6369: IF (nvl(temp_number,0) > 0) THEN
6370: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6371: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6372: fnd_msg_pub.add;
6373: END IF;
6374:
6375: -- unique combination -> bank_branch_id, bank account name

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

6405:
6406: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: '||temp_number);
6407:
6408: IF (nvl(temp_number,0) > 0) THEN
6409: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6410: fnd_msg_pub.add;
6411: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6412: END IF;
6413:

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

6447: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'temp_number: ' || temp_number);
6448:
6449: IF (nvl(temp_number,0) > 0) THEN
6450: cep_standard.debug('CE_VALIDATE_UNIQUE_ACCOUNT: ' || 'CE_BANK_ACCOUNT_NUM_EXISTS');
6451: fnd_message.set_name('CE', 'CE_BANK_ACCOUNT_NUM_EXISTS');
6452: fnd_msg_pub.add;
6453: END IF;
6454:
6455: -- unique combination -> bank_branch_id, bank account name

Line 6532: fnd_message.set_name('CE', 'CE_BANK_BRANCH_EXISTS');

6528: cep_standard.debug('already existing branches='||l_temp_number);
6529:
6530: IF (nvl(l_temp_number,0) > 0) THEN
6531: cep_standard.debug('Branch already exists');
6532: fnd_message.set_name('CE', 'CE_BANK_BRANCH_EXISTS');
6533: fnd_msg_pub.add;
6534: END IF;
6535:
6536:

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

6625: cep_standard.debug('CE_VALIDATE_UNIQUE_BANK_JP - temp_name_alt: ' ||temp_name_alt);
6626:
6627: IF (nvl(temp_name_alt,0) > 0) THEN
6628: cep_standard.debug('CE_VALIDATE_UNIQUE_BANK_JP: ' || 'CE_BANK_NAME_ALT_EXISTS');
6629: fnd_message.set_name('CE', 'CE_BANK_NAME_ALT_EXISTS');
6630: fnd_msg_pub.add;
6631: END IF;
6632:
6633: cep_standard.debug('<

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

6651: numeric_result VARCHAR2(40);
6652:
6653: procedure fail_mandatory is
6654: begin
6655: fnd_message.set_name ('CE', 'CE_ENTER_EFT_NUMBER');
6656: fnd_msg_pub.add;
6657: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_ENTER_EFT_NUMBER');
6658: end fail_mandatory;
6659:

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

6658: end fail_mandatory;
6659:
6660: procedure fail_check is
6661: begin
6662: fnd_message.set_name ('CE', 'CE_INVALID_EFT_NUMBER');
6663: fnd_msg_pub.add;
6664: cep_standard.debug('CE_VALIDATE_MISC_EFT_NUM: ' || 'CE_INVALID_EFT_NUMBER');
6665: end fail_check;
6666:

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

6719:
6720: EXCEPTION
6721: WHEN OTHERS THEN
6722: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM ' ||X_COUNTRY_NAME );
6723: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6724: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_eft_num');
6725: fnd_msg_pub.add;
6726: RAISE;
6727: END CE_VALIDATE_MISC_EFT_NUM;

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

6720: EXCEPTION
6721: WHEN OTHERS THEN
6722: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_EFT_NUM ' ||X_COUNTRY_NAME );
6723: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6724: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_eft_num');
6725: fnd_msg_pub.add;
6726: RAISE;
6727: END CE_VALIDATE_MISC_EFT_NUM;
6728:

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

6742: numeric_result VARCHAR2(40);
6743:
6744: procedure fail_mandatory is
6745: begin
6746: fnd_message.set_name ('CE', 'CE_ENTER_ACCOUNT_HOLDER_ALT');
6747: fnd_msg_pub.add;
6748: cep_standard.debug('CE_VALIDATE_MISC_ACCT_HLDR_ALT: ' || 'CE_ENTER_ACCOUNT_HOLDER_ALT');
6749: end fail_mandatory;
6750:

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

6791: cep_standard.debug('< 6792: EXCEPTION
6793: WHEN OTHERS THEN
6794: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT ' ||X_COUNTRY_NAME );
6795: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6796: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_acct_hldr_alt');
6797: fnd_msg_pub.add;
6798: RAISE;
6799: END CE_VALIDATE_MISC_ACCT_HLDR_ALT;

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

6792: EXCEPTION
6793: WHEN OTHERS THEN
6794: cep_standard.debug('CE_VALIDATE_BANKINFO.CE_VALIDATE_MISC_ACCT_HLDR_ALT ' ||X_COUNTRY_NAME );
6795: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6796: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.cd_validate_misc_acct_hldr_alt');
6797: fnd_msg_pub.add;
6798: RAISE;
6799: END CE_VALIDATE_MISC_ACCT_HLDR_ALT;
6800:

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

6865: X_PASS_MAND_CHECK VARCHAR2(1);
6866:
6867: procedure fail_mandatory is
6868: begin
6869: fnd_message.set_name ('CE', 'CE_ENTER_BRANCH_NUM');
6870: fnd_msg_pub.add;
6871: cep_standard.debug('GET_BRANCH_NUM_FORMAT: ' || 'CE_ENTER_BRANCH_NUM');
6872: end fail_mandatory;
6873:

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

6951:
6952: EXCEPTION
6953: WHEN OTHERS THEN
6954: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT ' ||X_COUNTRY_NAME );
6955: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6956: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
6957: fnd_msg_pub.add;
6958: RAISE;
6959: END GET_BRANCH_NUM_FORMAT;

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

6952: EXCEPTION
6953: WHEN OTHERS THEN
6954: cep_standard.debug('CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT ' ||X_COUNTRY_NAME );
6955: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
6956: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.GET_BRANCH_NUM_FORMAT');
6957: fnd_msg_pub.add;
6958: RAISE;
6959: END GET_BRANCH_NUM_FORMAT;
6960:

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

7131: cep_standard.debug('< 7132: EXCEPTION
7133: WHEN OTHERS THEN
7134: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique ' ||X_COUNTRY_NAME );
7135: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7136: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_unique');
7137: fnd_msg_pub.add;
7138: RAISE;
7139: END UPD_BANK_UNIQUE;

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

7132: EXCEPTION
7133: WHEN OTHERS THEN
7134: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_bank_unique ' ||X_COUNTRY_NAME );
7135: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7136: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_unique');
7137: fnd_msg_pub.add;
7138: RAISE;
7139: END UPD_BANK_UNIQUE;
7140:

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

7351: cep_standard.debug('< 7352: EXCEPTION
7353: WHEN OTHERS THEN
7354: cep_standard.debug('EXCEPTION: upd_bank_validate' ||X_COUNTRY_NAME );
7355: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7356: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_validate');
7357: fnd_msg_pub.add;
7358: RAISE;
7359: END UPD_BANK_VALIDATE;

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

7352: EXCEPTION
7353: WHEN OTHERS THEN
7354: cep_standard.debug('EXCEPTION: upd_bank_validate' ||X_COUNTRY_NAME );
7355: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7356: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_bank_validate');
7357: fnd_msg_pub.add;
7358: RAISE;
7359: END UPD_BANK_VALIDATE;
7360:

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

7457:
7458: EXCEPTION
7459: WHEN OTHERS THEN
7460: cep_standard.debug('EXCEPTION: upd_branch_unique ' ||X_COUNTRY_NAME );
7461: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7462: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_unique');
7463: fnd_msg_pub.add;
7464: RAISE;
7465: END UPD_BRANCH_UNIQUE;

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

7458: EXCEPTION
7459: WHEN OTHERS THEN
7460: cep_standard.debug('EXCEPTION: upd_branch_unique ' ||X_COUNTRY_NAME );
7461: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7462: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_unique');
7463: fnd_msg_pub.add;
7464: RAISE;
7465: END UPD_BRANCH_UNIQUE;
7466:

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

7701:
7702: EXCEPTION
7703: WHEN OTHERS THEN
7704: cep_standard.debug('EXCEPTION: upd_branch_validate ' ||X_COUNTRY_NAME );
7705: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7706: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_validate');
7707: fnd_msg_pub.add;
7708: RAISE;
7709: END UPD_BRANCH_VALIDATE;

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

7702: EXCEPTION
7703: WHEN OTHERS THEN
7704: cep_standard.debug('EXCEPTION: upd_branch_validate ' ||X_COUNTRY_NAME );
7705: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7706: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_branch_validate');
7707: fnd_msg_pub.add;
7708: RAISE;
7709: END UPD_BRANCH_VALIDATE;
7710:

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

7798: cep_standard.debug('< 7799: EXCEPTION
7800: WHEN OTHERS THEN
7801: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique ' ||X_COUNTRY_NAME );
7802: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7803: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_unique');
7804: fnd_msg_pub.add;
7805: RAISE;
7806: END UPD_ACCOUNT_UNIQUE;

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

7799: EXCEPTION
7800: WHEN OTHERS THEN
7801: cep_standard.debug('CE_VALIDATE_BANKINFO.upd_account_unique ' ||X_COUNTRY_NAME );
7802: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
7803: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_unique');
7804: fnd_msg_pub.add;
7805: RAISE;
7806: END UPD_ACCOUNT_UNIQUE;
7807:

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

8081: cep_standard.debug('< 8082: EXCEPTION
8083: WHEN OTHERS THEN
8084: cep_standard.debug('EXCEPTION: upd_account_validate ' ||X_COUNTRY_NAME );
8085: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
8086: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_validate');
8087: fnd_msg_pub.add;
8088: RAISE;
8089: END UPD_ACCOUNT_VALIDATE;

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

8082: EXCEPTION
8083: WHEN OTHERS THEN
8084: cep_standard.debug('EXCEPTION: upd_account_validate ' ||X_COUNTRY_NAME );
8085: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
8086: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO.upd_account_validate');
8087: fnd_msg_pub.add;
8088: RAISE;
8089: END UPD_ACCOUNT_VALIDATE;
8090:

Line 8095: | All errors are stored in the FND message stack |

8091: /* 10172325 - Validation wrapper functions added for Fusion Migration */
8092: /* -------------------------------------------------------------------
8093: | Public Function: IS_IBAN_VALID |
8094: | Description: This function can be used to validate an IBAN value|
8095: | All errors are stored in the FND message stack |
8096: | Calls: CE_BANK_AND_ACCOUNT_VALIDATION.validate_iban |
8097: | Parameters: p_in_IBAN - IBAN value to be validated |
8098: | Returns: 'Y' - IBAN is valid |
8099: | 'N' - IBAN is not valid |

Line 8121: | All errors are stored in the FND message stack |

8117:
8118: /* -------------------------------------------------------------------
8119: | Public Function: IS_BIC_VALID |
8120: | Description: This function can be used to validate a BIC Value |
8121: | All errors are stored in the FND message stack |
8122: | Calls: CE_VALIDATE_BANKINFO.ce_validate_bic |
8123: | Parameters: p_in_BIC - BIC value to be validated |
8124: | Returns: 'Y' - BIC is valid |
8125: | 'N' - BIC is not valid |