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.IBY_EXT_BANKACCT_VALIDATIONS dependencies on CE_VALIDATE_BANKINFO

Line 56: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AT (

52:
53: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
54:
55: -- Validate Bank Account Information
56: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AT (
57: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
58: Xi_PASS_MAND_CHECK => 'P',
59: Xo_VALUE_OUT => l_bank_account_num);
60:

Line 69: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AT(

65:
66: l_bank_branch_num := p_ext_bank_branch_rec.branch_number;
67:
68: -- Validate Bank Branch
69: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AT(
70: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
71: Xi_PASS_MAND_CHECK => 'P',
72: Xo_VALUE_OUT => l_bank_branch_num);
73:

Line 118: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AU(

114: print_debuginfo('ENTER ' || l_module_name);
115: x_valid := FALSE;
116:
117: -- Validate Bank Account Information
118: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AU(
119: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
120: Xi_CURRENCY_CODE => p_ext_bank_acct_rec.currency);
121:
122: IF (foreign_payment_flag) THEN

Line 125: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_AU(

121:
122: IF (foreign_payment_flag) THEN
123:
124: -- Validate Bank Bank
125: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_AU(
126: Xi_BANK_NUMBER => l_bank_num);
127:
128: /*
129: -- Validate Bank Branch

Line 130: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AU(

126: Xi_BANK_NUMBER => l_bank_num);
127:
128: /*
129: -- Validate Bank Branch
130: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AU(
131: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
132: Xi_BANK_ID => p_ext_bank_rec.bank_id,
133: Xi_PASS_MAND_CHECK => 'P');
134: */

Line 138: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

134: */
135:
136: -- Validate Bank Branch
137: print_debuginfo('Calling bank branch validation CE API');
138: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
139: Xi_COUNTRY => 'AU',
140: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
141: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
142: Xo_VALUE_OUT => l_bank_branch_num);

Line 186: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_BE(

182: print_debuginfo('ENTER ' || l_module_name);
183: x_valid := FALSE;
184:
185: -- Validate Bank Account Information
186: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_BE(
187: Xi_ACCOUNT_NUMBER => l_bank_account_num,
188: Xi_PASS_MAND_CHECK => 'P');
189:
190:

Line 269: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DE (

265:
266: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
267:
268: -- Validate Bank Account Information
269: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DE (
270: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
271: Xo_VALUE_OUT => l_bank_account_num);
272:
273: p_ext_bank_acct_rec.bank_account_num :=

Line 279: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_DE(

275:
276: IF (foreign_payment_flag) THEN
277:
278: -- Validate Bank Bank
279: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_DE(
280: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
281:
282: /*
283: -- Validate Bank Branch

Line 284: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_DE(

280: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
281:
282: /*
283: -- Validate Bank Branch
284: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_DE(
285: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
286: Xi_BANK_ID => p_ext_bank_rec.bank_id);
287: */
288:

Line 291: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

287: */
288:
289: -- Validate Bank Branch
290: print_debuginfo('Calling bank branch validation CE API');
291: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
292: Xi_COUNTRY => 'DE',
293: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
294: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
295: Xo_VALUE_OUT => l_bank_branch_num);

Line 299: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_DE(

295: Xo_VALUE_OUT => l_bank_branch_num);
296: END IF;
297:
298: -- Validate Check Digit
299: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_DE(
300: Xi_CD => p_ext_bank_acct_rec.check_digits,
301: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
302:
303: x_valid := TRUE;

Line 345: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DK (

341:
342: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
343:
344: -- Validate Bank Account Information
345: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DK (
346: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
347: Xi_PASS_MAND_CHECK => 'P',
348: Xo_VALUE_OUT => l_bank_account_num);
349:

Line 390: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FI (

386: print_debuginfo('ENTER ' || l_module_name);
387: x_valid := FALSE;
388:
389: -- Validate Bank Account Information
390: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FI (
391: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
392: Xi_PASS_MAND_CHECK => 'P');
393:
394:

Line 437: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FR (

433:
434: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
435:
436: -- Validate Bank Account Information
437: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FR (
438: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
439: Xi_PASS_MAND_CHECK => 'P',
440: Xo_VALUE_OUT => l_bank_account_num);
441:

Line 450: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_FR(

446:
447: l_bank_num := p_ext_bank_rec.bank_number;
448:
449: -- Validate Bank
450: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_FR(
451: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
452: Xi_PASS_MAND_CHECK => 'P',
453: Xo_VALUE_OUT => l_bank_num);
454:

Line 461: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_FR(

457:
458: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
459:
460: -- Validate Bank Branch
461: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_FR(
462: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
463: Xi_PASS_MAND_CHECK => 'P',
464: Xo_VALUE_OUT => l_bank_branch_num);
465:

Line 472: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_FR(

468:
469: END IF;
470:
471: -- Validate Check Digits
472: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_FR(
473: Xi_CD => p_ext_bank_acct_rec.check_digits,
474: Xi_PASS_MAND_CHECK => 'P',
475: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
476: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 520: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB (

516:
517: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
518:
519: -- Validate Bank Account Information
520: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB (
521: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
522: Xo_VALUE_OUT => l_bank_account_num);
523:
524: p_ext_bank_acct_rec.bank_account_num :=

Line 530: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GB(

526:
527: IF (foreign_payment_flag) THEN
528:
529: -- Validate Bank Bank
530: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GB(
531: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
532:
533: /*
534: -- Validate Bank Branch

Line 535: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GB(

531: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
532:
533: /*
534: -- Validate Bank Branch
535: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GB(
536: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
537: Xi_BANK_ID => p_ext_bank_rec.bank_id);
538: */
539:

Line 542: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

538: */
539:
540: -- Validate Bank Branch
541: print_debuginfo('Calling bank branch validation CE API');
542: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
543: Xi_COUNTRY => 'GB',
544: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
545: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
546: Xo_VALUE_OUT => l_bank_branch_num);

Line 592: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GR (

588:
589: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
590:
591: -- Validate Bank Account Information
592: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GR (
593: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
594: Xo_VALUE_OUT => l_bank_account_num);
595:
596: p_ext_bank_acct_rec.bank_account_num :=

Line 602: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(

598:
599: IF (foreign_payment_flag) THEN
600:
601: -- Validate Bank Bank
602: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(
603: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
604:
605: -- Validate Bank Branch
606: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(

Line 606: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(

602: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(
603: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
604:
605: -- Validate Bank Branch
606: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(
607: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number);
608:
609: END IF;
610:

Line 612: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_GR(

608:
609: END IF;
610:
611: -- Validate Check Digits
612: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_GR(
613: Xi_CD => p_ext_bank_acct_rec.check_digits,
614: Xi_PASS_MAND_CHECK => 'P',
615: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
616: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 698: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IL (

694: print_debuginfo('ENTER ' || l_module_name);
695: x_valid := FALSE;
696:
697: -- Validate Bank Account Information
698: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IL (
699: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
700:
701: IF (foreign_payment_flag) THEN
702:

Line 704: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IL(

700:
701: IF (foreign_payment_flag) THEN
702:
703: -- Validate Bank
704: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IL(
705: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
706: Xi_PASS_MAND_CHECK => 'P');
707:
708: -- Validate Bank Branch

Line 709: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IL(

705: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
706: Xi_PASS_MAND_CHECK => 'P');
707:
708: -- Validate Bank Branch
709: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IL(
710: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
711: Xi_PASS_MAND_CHECK => 'P');
712:
713: END IF;

Line 756: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IE (

752:
753: print_debuginfo('ENTER ' || l_module_name);
754: x_valid := FALSE;
755:
756: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IE (
757: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
758:
759: IF (foreign_payment_flag) THEN
760:

Line 762: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IE(

758:
759: IF (foreign_payment_flag) THEN
760:
761: -- Validate Bank
762: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IE(
763: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
764:
765: /*
766: -- Validate Bank Branch

Line 767: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IE(

763: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
764:
765: /*
766: -- Validate Bank Branch
767: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IE(
768: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
769: Xi_BANK_ID => p_ext_bank_rec.bank_id);
770: */
771:

Line 774: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

770: */
771:
772: -- Validate Bank Branch
773: print_debuginfo('Calling bank branch validation CE API');
774: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
775: Xi_COUNTRY => 'IE',
776: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
777: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
778: Xo_VALUE_OUT => l_bank_branch_num);

Line 822: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IS (

818:
819: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
820:
821: -- Validate Bank Account Information
822: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IS (
823: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
824: Xo_VALUE_OUT => l_bank_account_num);
825:
826: p_ext_bank_acct_rec.bank_account_num :=

Line 835: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IS(

831: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
832:
833: /*
834: -- Validate Bank Branch
835: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IS(
836: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
837: Xi_BANK_ID => p_ext_bank_rec.bank_id,
838: Xo_VALUE_OUT => l_bank_branch_num);
839: */

Line 843: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

839: */
840:
841: -- Validate Bank Branch
842: print_debuginfo('Calling bank branch validation CE API');
843: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
844: Xi_COUNTRY => 'IS',
845: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
846: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
847: Xo_VALUE_OUT => l_bank_branch_num);

Line 855: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IS(

851:
852: END IF;
853:
854: -- Validate Check Digits
855: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IS(
856: Xi_CD => p_ext_bank_acct_rec.check_digits,
857: Xi_X_ACCOUNT_NUMBER => translate(p_ext_bank_acct_rec.bank_account_num,
858: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
859: '123456789123456789234567890'));

Line 902: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IT (

898:
899: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
900:
901: -- Validate Bank Account Information
902: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IT (
903: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
904: Xo_VALUE_OUT => l_bank_account_num);
905:
906: p_ext_bank_acct_rec.bank_account_num :=

Line 912: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IT(

908:
909: IF (foreign_payment_flag) THEN
910:
911: -- Validate Bank Branch
912: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IT(
913: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
914: Xi_PASS_MAND_CHECK => 'P');
915:
916: END IF;

Line 919: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IT(

915:
916: END IF;
917:
918: -- Validate Check Digits
919: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IT(
920: Xi_CD => p_ext_bank_acct_rec.check_digits,
921: Xi_PASS_MAND_CHECK => 'P',
922: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
923: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 965: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_JP(

961: print_debuginfo('ENTER ' || l_module_name);
962: x_valid := FALSE;
963:
964: -- Validate Bank Account Information
965: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_JP(
966: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
967: Xi_ACCOUNT_TYPE => p_ext_bank_acct_rec.acct_type);
968:
969:

Line 973: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_JP(

969:
970: IF (foreign_payment_flag) THEN
971:
972: -- Validate Bank Bank
973: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_JP(
974: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
975: Xi_BANK_NAME_ALT => p_ext_bank_rec.bank_alt_name,
976: Xi_PASS_MAND_CHECK => 'P');
977:

Line 979: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_JP(

975: Xi_BANK_NAME_ALT => p_ext_bank_rec.bank_alt_name,
976: Xi_PASS_MAND_CHECK => 'P');
977:
978: -- Validate Bank Branch
979: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_JP(
980: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
981: Xi_BRANCH_NAME_ALT => p_ext_bank_branch_rec.alternate_branch_name,
982: Xi_PASS_MAND_CHECK => 'P');
983:

Line 1026: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_LU (

1022: print_debuginfo('ENTER ' || l_module_name);
1023: x_valid := FALSE;
1024:
1025: -- Validate Bank Account Information
1026: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_LU (
1027: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1028:
1029: IF (foreign_payment_flag) THEN
1030:

Line 1032: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_LU(

1028:
1029: IF (foreign_payment_flag) THEN
1030:
1031: -- Validate Bank Bank
1032: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_LU(
1033: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1034:
1035: /*
1036: -- Validate Bank Branch

Line 1037: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_LU(

1033: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1034:
1035: /*
1036: -- Validate Bank Branch
1037: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_LU(
1038: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1039: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1040: */
1041:

Line 1044: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1040: */
1041:
1042: -- Validate Bank Branch
1043: print_debuginfo('Calling bank branch validation CE API');
1044: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1045: Xi_COUNTRY => 'LU',
1046: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1047: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1048: Xo_VALUE_OUT => l_bank_branch_num);

Line 1053: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_LU(

1049:
1050: END IF;
1051:
1052: -- Validate Check Digits
1053: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_LU(
1054: Xi_CD => p_ext_bank_acct_rec.check_digits,
1055: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1056: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1057: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);

Line 1097: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NL (

1093:
1094: print_debuginfo('ENTER ' || l_module_name);
1095:
1096: -- Validate Bank Account Information
1097: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NL (
1098: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1099: Xi_PASS_MAND_CHECK => 'P');
1100:
1101: x_valid := TRUE;

Line 1139: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NZ (

1135: print_debuginfo('ENTER ' || l_module_name);
1136: x_valid := FALSE;
1137:
1138: -- Validate Bank Account Information
1139: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NZ (
1140: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1141: Xi_ACCOUNT_SUFFIX => p_ext_bank_acct_rec.acct_suffix);
1142:
1143: IF (foreign_payment_flag) THEN

Line 1146: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_NZ(

1142:
1143: IF (foreign_payment_flag) THEN
1144:
1145: -- Validate Bank
1146: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_NZ(
1147: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1148: Xi_PASS_MAND_CHECK => 'P');
1149:
1150:

Line 1152: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_NZ(

1148: Xi_PASS_MAND_CHECK => 'P');
1149:
1150:
1151: -- Validate Bank Branch
1152: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_NZ(
1153: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1154: Xi_PASS_MAND_CHECK => 'P');
1155:
1156: END IF;

Line 1197: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NO (

1193: print_debuginfo('ENTER ' || l_module_name);
1194: x_valid := FALSE;
1195:
1196: -- Validate Bank Account Information
1197: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NO (
1198: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1199: Xi_PASS_MAND_CHECK => 'P');
1200:
1201: x_valid := TRUE;

Line 1240: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PL (

1236: print_debuginfo('ENTER ' || l_module_name);
1237: x_valid := FALSE;
1238:
1239: -- Validate Bank Account Information
1240: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PL (
1241: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1242:
1243:
1244: IF (foreign_payment_flag) THEN

Line 1247: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PL(

1243:
1244: IF (foreign_payment_flag) THEN
1245:
1246: -- Validate Bank
1247: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PL(
1248: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1249:
1250: /*
1251: -- Validate Bank Branch

Line 1252: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PL(

1248: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1249:
1250: /*
1251: -- Validate Bank Branch
1252: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PL(
1253: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1254: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1255: */
1256:

Line 1259: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1255: */
1256:
1257: -- Validate Bank Branch
1258: print_debuginfo('Calling bank branch validation CE API');
1259: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1260: Xi_COUNTRY => 'PL',
1261: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1262: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1263: Xo_VALUE_OUT => l_bank_branch_num);

Line 1307: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PT (

1303:
1304: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
1305:
1306: -- Validate Bank Account Information
1307: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PT (
1308: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1309: Xi_PASS_MAND_CHECK => 'P',
1310: Xo_VALUE_OUT => l_bank_account_num);
1311:

Line 1318: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PT(

1314:
1315: IF (foreign_payment_flag) THEN
1316:
1317: -- Validate Bank
1318: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PT(
1319: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1320: Xi_PASS_MAND_CHECK => 'P');
1321:
1322: -- Validate Bank Branch

Line 1323: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PT(

1319: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1320: Xi_PASS_MAND_CHECK => 'P');
1321:
1322: -- Validate Bank Branch
1323: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PT(
1324: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1325: Xi_PASS_MAND_CHECK => 'P');
1326:
1327: END IF;

Line 1330: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_PT(

1326:
1327: END IF;
1328:
1329: -- Validate Check Digits
1330: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_PT(
1331: Xi_CD => p_ext_bank_acct_rec.check_digits,
1332: Xi_PASS_MAND_CHECK => 'P',
1333: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1334: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 1418: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_ES (

1414:
1415: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
1416:
1417: -- Validate Bank Account Information
1418: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_ES (
1419: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1420: Xi_PASS_MAND_CHECK => 'P',
1421: Xo_VALUE_OUT => l_bank_account_num);
1422:

Line 1431: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_ES(

1427:
1428: l_bank_num := p_ext_bank_rec.bank_number;
1429:
1430: -- Validate Bank
1431: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_ES(
1432: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1433: Xi_PASS_MAND_CHECK => 'P',
1434: Xo_VALUE_OUT => l_bank_num);
1435:

Line 1442: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_ES(

1438:
1439: l_bank_branch_num := p_ext_bank_branch_rec.branch_number;
1440:
1441: -- Validate Bank Branch
1442: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_ES(
1443: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1444: Xi_PASS_MAND_CHECK => 'P',
1445: Xo_VALUE_OUT => l_bank_branch_num);
1446:

Line 1453: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_ES(

1449:
1450: END IF;
1451:
1452: -- Validate Check Digits
1453: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_ES(
1454: Xi_CD => p_ext_bank_acct_rec.check_digits,
1455: Xi_PASS_MAND_CHECK => 'P',
1456: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1457: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 1497: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_SE (

1493: print_debuginfo('ENTER ' || l_module_name);
1494: x_valid := FALSE;
1495:
1496: -- Validate Bank Account Information
1497: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_SE (
1498: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1499:
1500: IF (foreign_payment_flag) THEN
1501:

Line 1503: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_SE(

1499:
1500: IF (foreign_payment_flag) THEN
1501:
1502: -- Validate Bank
1503: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_SE(
1504: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1505:
1506: /*
1507: -- Validate Bank Branch

Line 1508: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_SE(

1504: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1505:
1506: /*
1507: -- Validate Bank Branch
1508: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_SE(
1509: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1510: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1511: */
1512:

Line 1515: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1511: */
1512:
1513: -- Validate Bank Branch
1514: print_debuginfo('Calling bank branch validation CE API');
1515: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1516: Xi_COUNTRY => 'SE',
1517: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1518: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1519: Xo_VALUE_OUT => l_bank_branch_num);

Line 1525: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_SE(

1521:
1522: x_valid := TRUE;
1523:
1524: -- Validate Check Digit
1525: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_SE(
1526: Xi_CD => p_ext_bank_acct_rec.check_digits,
1527: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1528:
1529: print_debuginfo('RETURN ' || l_module_name);

Line 1574: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_US(

1570:
1571: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
1572:
1573: -- Validate Bank Branch
1574: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_US(
1575: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1576: Xi_PASS_MAND_CHECK => 'P',
1577: Xo_VALUE_OUT => l_bank_branch_num);
1578:

Line 1800: ce_validate_bankinfo.ce_validate_bank(p_ext_bank_rec.country_code,

1796: -- check_mandatory('Bank Number', p_ext_bank_rec.bank_number);
1797:
1798: -- call CE validate bank api to validate bank
1799: -- country specific validation API call here
1800: ce_validate_bankinfo.ce_validate_bank(p_ext_bank_rec.country_code,
1801: p_ext_bank_rec.bank_number,
1802: p_ext_bank_rec.bank_name,
1803: p_ext_bank_rec.bank_alt_name,
1804: p_ext_bank_rec.tax_payer_id,

Line 1914: ce_validate_bankinfo.ce_validate_branch(l_country,

1910: END IF;
1911: CLOSE c_bank;
1912:
1913: -- country specific validation API call here
1914: ce_validate_bankinfo.ce_validate_branch(l_country,
1915: l_bank_number,
1916: p_ext_bank_branch_rec.branch_number,
1917: l_bank_name,
1918: p_ext_bank_branch_rec.branch_name,