APPS.IBY_EXT_BANKACCT_VALIDATIONS dependencies on CE_VALIDATE_BANKINFO

Line 59: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AT (

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

Line 72: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AT(

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

Line 125: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AU(

121: END IF;
122: x_valid := FALSE;
123:
124: -- Validate Bank Account Information
125: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_AU(
126: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
127: Xi_CURRENCY_CODE => p_ext_bank_acct_rec.currency);
128:
129: IF (foreign_payment_flag) THEN

Line 132: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_AU(

128:
129: IF (foreign_payment_flag) THEN
130:
131: -- Validate Bank Bank
132: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_AU(
133: Xi_BANK_NUMBER => l_bank_num);
134:
135: /*
136: -- Validate Bank Branch

Line 137: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AU(

133: Xi_BANK_NUMBER => l_bank_num);
134:
135: /*
136: -- Validate Bank Branch
137: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_AU(
138: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
139: Xi_BANK_ID => p_ext_bank_rec.bank_id,
140: Xi_PASS_MAND_CHECK => 'P');
141: */

Line 147: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

143: -- Validate Bank Branch
144: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
145: print_debuginfo('Calling bank branch validation CE API');
146: END IF;
147: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
148: Xi_COUNTRY => 'AU',
149: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
150: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
151: Xo_VALUE_OUT => l_bank_branch_num);

Line 201: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_BE(

197:
198: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
199:
200: -- Validate Bank Account Information
201: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_BE(
202: Xi_ACCOUNT_NUMBER => l_bank_account_num,
203: Xi_PASS_MAND_CHECK => 'P');
204:
205:

Line 292: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DE (

288:
289: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
290:
291: -- Validate Bank Account Information
292: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DE (
293: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
294: Xo_VALUE_OUT => l_bank_account_num);
295:
296: p_ext_bank_acct_rec.bank_account_num :=

Line 302: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_DE(

298:
299: IF (foreign_payment_flag) THEN
300:
301: -- Validate Bank Bank
302: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_DE(
303: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
304:
305: /*
306: -- Validate Bank Branch

Line 307: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_DE(

303: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
304:
305: /*
306: -- Validate Bank Branch
307: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_DE(
308: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
309: Xi_BANK_ID => p_ext_bank_rec.bank_id);
310: */
311:

Line 316: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

312: -- Validate Bank Branch
313: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
314: print_debuginfo('Calling bank branch validation CE API');
315: END IF;
316: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
317: Xi_COUNTRY => 'DE',
318: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
319: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
320: Xo_VALUE_OUT => l_bank_branch_num);

Line 324: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_DE(

320: Xo_VALUE_OUT => l_bank_branch_num);
321: END IF;
322:
323: -- Validate Check Digit
324: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_DE(
325: Xi_CD => p_ext_bank_acct_rec.check_digits,
326: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
327:
328: x_valid := TRUE;

Line 374: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DK (

370:
371: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
372:
373: -- Validate Bank Account Information
374: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_DK (
375: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
376: Xi_PASS_MAND_CHECK => 'P',
377: Xo_VALUE_OUT => l_bank_account_num);
378:

Line 421: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FI (

417: END IF;
418: x_valid := FALSE;
419:
420: -- Validate Bank Account Information
421: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FI (
422: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
423: Xi_PASS_MAND_CHECK => 'P');
424:
425:

Line 472: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FR (

468:
469: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
470:
471: -- Validate Bank Account Information
472: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_FR (
473: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
474: Xi_PASS_MAND_CHECK => 'P',
475: Xo_VALUE_OUT => l_bank_account_num);
476:

Line 485: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_FR(

481:
482: l_bank_num := p_ext_bank_rec.bank_number;
483:
484: -- Validate Bank
485: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_FR(
486: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
487: Xi_PASS_MAND_CHECK => 'P',
488: Xo_VALUE_OUT => l_bank_num);
489:

Line 496: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_FR(

492:
493: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
494:
495: -- Validate Bank Branch
496: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_FR(
497: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
498: Xi_PASS_MAND_CHECK => 'P',
499: Xo_VALUE_OUT => l_bank_branch_num);
500:

Line 507: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_FR(

503:
504: END IF;
505:
506: -- Validate Check Digits
507: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_FR(
508: Xi_CD => p_ext_bank_acct_rec.check_digits,
509: Xi_PASS_MAND_CHECK => 'P',
510: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
511: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 556: -- 16506399 CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB CALL NEEDS TO BE MODIFIED L

552: x_valid := FALSE;
553:
554: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
555:
556: -- 16506399 CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB CALL NEEDS TO BE MODIFIED L
557: -- Validate Bank Account Information
558: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB (
559: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
560: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 558: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB (

554: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
555:
556: -- 16506399 CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB CALL NEEDS TO BE MODIFIED L
557: -- Validate Bank Account Information
558: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GB (
559: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
560: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
561: Xo_VALUE_OUT => l_bank_account_num);
562:

Line 569: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GB(

565:
566: IF (foreign_payment_flag) THEN
567:
568: -- Validate Bank Bank
569: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GB(
570: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
571:
572: /*
573: -- Validate Bank Branch

Line 574: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GB(

570: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
571:
572: /*
573: -- Validate Bank Branch
574: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GB(
575: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
576: Xi_BANK_ID => p_ext_bank_rec.bank_id);
577: */
578:

Line 583: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

579: -- Validate Bank Branch
580: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
581: print_debuginfo('Calling bank branch validation CE API');
582: END IF;
583: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
584: Xi_COUNTRY => 'GB',
585: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
586: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
587: Xo_VALUE_OUT => l_bank_branch_num);

Line 637: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GR (

633:
634: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
635:
636: -- Validate Bank Account Information
637: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_GR (
638: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
639: Xo_VALUE_OUT => l_bank_account_num);
640:
641: p_ext_bank_acct_rec.bank_account_num :=

Line 647: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(

643:
644: IF (foreign_payment_flag) THEN
645:
646: -- Validate Bank Bank
647: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(
648: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
649:
650: -- Validate Bank Branch
651: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(

Line 651: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(

647: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_GR(
648: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
649:
650: -- Validate Bank Branch
651: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_GR(
652: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number);
653:
654: END IF;
655:

Line 657: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_GR(

653:
654: END IF;
655:
656: -- Validate Check Digits
657: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_GR(
658: Xi_CD => p_ext_bank_acct_rec.check_digits,
659: Xi_PASS_MAND_CHECK => 'P',
660: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
661: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 751: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IL (

747: END IF;
748: x_valid := FALSE;
749:
750: -- Validate Bank Account Information
751: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IL (
752: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
753:
754: IF (foreign_payment_flag) THEN
755:

Line 757: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IL(

753:
754: IF (foreign_payment_flag) THEN
755:
756: -- Validate Bank
757: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IL(
758: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
759: Xi_PASS_MAND_CHECK => 'P');
760:
761: -- Validate Bank Branch

Line 762: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IL(

758: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
759: Xi_PASS_MAND_CHECK => 'P');
760:
761: -- Validate Bank Branch
762: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IL(
763: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
764: Xi_PASS_MAND_CHECK => 'P');
765:
766: END IF;

Line 813: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IE (

809: print_debuginfo('ENTER ' || l_module_name);
810: END IF;
811: x_valid := FALSE;
812:
813: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IE (
814: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
815:
816: IF (foreign_payment_flag) THEN
817:

Line 819: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IE(

815:
816: IF (foreign_payment_flag) THEN
817:
818: -- Validate Bank
819: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_IE(
820: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
821:
822: /*
823: -- Validate Bank Branch

Line 824: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IE(

820: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
821:
822: /*
823: -- Validate Bank Branch
824: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IE(
825: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
826: Xi_BANK_ID => p_ext_bank_rec.bank_id);
827: */
828:

Line 833: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

829: -- Validate Bank Branch
830: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
831: print_debuginfo('Calling bank branch validation CE API');
832: END IF;
833: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
834: Xi_COUNTRY => 'IE',
835: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
836: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
837: Xo_VALUE_OUT => l_bank_branch_num);

Line 885: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IS (

881:
882: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
883:
884: -- Validate Bank Account Information
885: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IS (
886: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
887: Xo_VALUE_OUT => l_bank_account_num);
888:
889: p_ext_bank_acct_rec.bank_account_num :=

Line 898: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IS(

894: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
895:
896: /*
897: -- Validate Bank Branch
898: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IS(
899: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
900: Xi_BANK_ID => p_ext_bank_rec.bank_id,
901: Xo_VALUE_OUT => l_bank_branch_num);
902: */

Line 908: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

904: -- Validate Bank Branch
905: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
906: print_debuginfo('Calling bank branch validation CE API');
907: END IF;
908: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
909: Xi_COUNTRY => 'IS',
910: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
911: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
912: Xo_VALUE_OUT => l_bank_branch_num);

Line 920: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IS(

916:
917: END IF;
918:
919: -- Validate Check Digits
920: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IS(
921: Xi_CD => p_ext_bank_acct_rec.check_digits,
922: Xi_X_ACCOUNT_NUMBER => translate(p_ext_bank_acct_rec.bank_account_num,
923: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
924: '123456789123456789234567890'));

Line 971: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IT (

967:
968: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
969:
970: -- Validate Bank Account Information
971: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_IT (
972: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
973: Xo_VALUE_OUT => l_bank_account_num);
974:
975: p_ext_bank_acct_rec.bank_account_num :=

Line 981: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IT(

977:
978: IF (foreign_payment_flag) THEN
979:
980: -- Validate Bank Branch
981: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_IT(
982: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
983: Xi_PASS_MAND_CHECK => 'P');
984:
985: END IF;

Line 988: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IT(

984:
985: END IF;
986:
987: -- Validate Check Digits
988: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_IT(
989: Xi_CD => p_ext_bank_acct_rec.check_digits,
990: Xi_PASS_MAND_CHECK => 'P',
991: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
992: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 1038: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_JP(

1034: END IF;
1035: x_valid := FALSE;
1036:
1037: -- Validate Bank Account Information
1038: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_JP(
1039: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1040: Xi_ACCOUNT_TYPE => p_ext_bank_acct_rec.acct_type);
1041:
1042:

Line 1046: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_JP(

1042:
1043: IF (foreign_payment_flag) THEN
1044:
1045: -- Validate Bank Bank
1046: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_JP(
1047: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1048: Xi_BANK_NAME_ALT => p_ext_bank_rec.bank_alt_name,
1049: Xi_PASS_MAND_CHECK => 'P');
1050:

Line 1052: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_JP(

1048: Xi_BANK_NAME_ALT => p_ext_bank_rec.bank_alt_name,
1049: Xi_PASS_MAND_CHECK => 'P');
1050:
1051: -- Validate Bank Branch
1052: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_JP(
1053: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1054: Xi_BRANCH_NAME_ALT => p_ext_bank_branch_rec.alternate_branch_name,
1055: Xi_PASS_MAND_CHECK => 'P');
1056:

Line 1103: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_LU (

1099: END IF;
1100: x_valid := FALSE;
1101:
1102: -- Validate Bank Account Information
1103: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_LU (
1104: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1105:
1106: IF (foreign_payment_flag) THEN
1107:

Line 1109: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_LU(

1105:
1106: IF (foreign_payment_flag) THEN
1107:
1108: -- Validate Bank Bank
1109: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_LU(
1110: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1111:
1112: /*
1113: -- Validate Bank Branch

Line 1114: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_LU(

1110: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1111:
1112: /*
1113: -- Validate Bank Branch
1114: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_LU(
1115: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1116: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1117: */
1118:

Line 1123: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1119: -- Validate Bank Branch
1120: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1121: print_debuginfo('Calling bank branch validation CE API');
1122: END IF;
1123: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1124: Xi_COUNTRY => 'LU',
1125: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1126: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1127: Xo_VALUE_OUT => l_bank_branch_num);

Line 1132: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_LU(

1128:
1129: END IF;
1130:
1131: -- Validate Check Digits
1132: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_LU(
1133: Xi_CD => p_ext_bank_acct_rec.check_digits,
1134: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1135: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1136: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);

Line 1180: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NL (

1176: print_debuginfo('ENTER ' || l_module_name);
1177:
1178: END IF;
1179: -- Validate Bank Account Information
1180: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NL (
1181: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1182: Xi_PASS_MAND_CHECK => 'P');
1183:
1184: x_valid := TRUE;

Line 1226: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NZ (

1222: END IF;
1223: x_valid := FALSE;
1224:
1225: -- Validate Bank Account Information
1226: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NZ (
1227: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1228: Xi_ACCOUNT_SUFFIX => p_ext_bank_acct_rec.acct_suffix);
1229:
1230: IF (foreign_payment_flag) THEN

Line 1233: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_NZ(

1229:
1230: IF (foreign_payment_flag) THEN
1231:
1232: -- Validate Bank
1233: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_NZ(
1234: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1235: Xi_PASS_MAND_CHECK => 'P');
1236:
1237:

Line 1239: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_NZ(

1235: Xi_PASS_MAND_CHECK => 'P');
1236:
1237:
1238: -- Validate Bank Branch
1239: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_NZ(
1240: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1241: Xi_PASS_MAND_CHECK => 'P');
1242:
1243: END IF;

Line 1288: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NO (

1284: END IF;
1285: x_valid := FALSE;
1286:
1287: -- Validate Bank Account Information
1288: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_NO (
1289: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1290: Xi_PASS_MAND_CHECK => 'P');
1291:
1292: x_valid := TRUE;

Line 1335: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PL (

1331: END IF;
1332: x_valid := FALSE;
1333:
1334: -- Validate Bank Account Information
1335: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PL (
1336: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1337:
1338:
1339: IF (foreign_payment_flag) THEN

Line 1342: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PL(

1338:
1339: IF (foreign_payment_flag) THEN
1340:
1341: -- Validate Bank
1342: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PL(
1343: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1344:
1345: /*
1346: -- Validate Bank Branch

Line 1347: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PL(

1343: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1344:
1345: /*
1346: -- Validate Bank Branch
1347: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PL(
1348: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1349: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1350: */
1351:

Line 1356: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1352: -- Validate Bank Branch
1353: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1354: print_debuginfo('Calling bank branch validation CE API');
1355: END IF;
1356: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1357: Xi_COUNTRY => 'PL',
1358: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1359: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1360: Xo_VALUE_OUT => l_bank_branch_num);

Line 1408: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PT (

1404:
1405: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
1406:
1407: -- Validate Bank Account Information
1408: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_PT (
1409: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1410: Xi_PASS_MAND_CHECK => 'P',
1411: Xo_VALUE_OUT => l_bank_account_num);
1412:

Line 1419: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PT(

1415:
1416: IF (foreign_payment_flag) THEN
1417:
1418: -- Validate Bank
1419: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_PT(
1420: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1421: Xi_PASS_MAND_CHECK => 'P');
1422:
1423: -- Validate Bank Branch

Line 1424: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PT(

1420: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1421: Xi_PASS_MAND_CHECK => 'P');
1422:
1423: -- Validate Bank Branch
1424: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_PT(
1425: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1426: Xi_PASS_MAND_CHECK => 'P');
1427:
1428: END IF;

Line 1431: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_PT(

1427:
1428: END IF;
1429:
1430: -- Validate Check Digits
1431: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_PT(
1432: Xi_CD => p_ext_bank_acct_rec.check_digits,
1433: Xi_PASS_MAND_CHECK => 'P',
1434: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1435: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 1527: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_ES (

1523:
1524: l_bank_account_num := p_ext_bank_acct_rec.bank_account_num;
1525:
1526: -- Validate Bank Account Information
1527: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_ES (
1528: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num,
1529: Xi_PASS_MAND_CHECK => 'P',
1530: Xo_VALUE_OUT => l_bank_account_num);
1531:

Line 1540: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_ES(

1536:
1537: l_bank_num := p_ext_bank_rec.bank_number;
1538:
1539: -- Validate Bank
1540: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_ES(
1541: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number,
1542: Xi_PASS_MAND_CHECK => 'P',
1543: Xo_VALUE_OUT => l_bank_num);
1544:

Line 1551: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_ES(

1547:
1548: l_bank_branch_num := p_ext_bank_branch_rec.branch_number;
1549:
1550: -- Validate Bank Branch
1551: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_ES(
1552: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1553: Xi_PASS_MAND_CHECK => 'P',
1554: Xo_VALUE_OUT => l_bank_branch_num);
1555:

Line 1562: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_ES(

1558:
1559: END IF;
1560:
1561: -- Validate Check Digits
1562: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_ES(
1563: Xi_CD => p_ext_bank_acct_rec.check_digits,
1564: Xi_PASS_MAND_CHECK => 'P',
1565: Xi_X_BANK_NUMBER => p_ext_bank_rec.bank_number,
1566: Xi_X_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,

Line 1608: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_SE (

1604: END IF;
1605: x_valid := FALSE;
1606:
1607: -- Validate Bank Account Information
1608: CE_VALIDATE_BANKINFO.CE_VALIDATE_ACCOUNT_SE (
1609: Xi_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1610:
1611: IF (foreign_payment_flag) THEN
1612:

Line 1614: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_SE(

1610:
1611: IF (foreign_payment_flag) THEN
1612:
1613: -- Validate Bank
1614: CE_VALIDATE_BANKINFO.CE_VALIDATE_BANK_SE(
1615: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1616:
1617: /*
1618: -- Validate Bank Branch

Line 1619: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_SE(

1615: Xi_BANK_NUMBER => p_ext_bank_rec.bank_number);
1616:
1617: /*
1618: -- Validate Bank Branch
1619: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_SE(
1620: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1621: Xi_BANK_ID => p_ext_bank_rec.bank_id);
1622: */
1623:

Line 1628: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(

1624: -- Validate Bank Branch
1625: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1626: print_debuginfo('Calling bank branch validation CE API');
1627: END IF;
1628: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_BANK(
1629: Xi_COUNTRY => 'SE',
1630: Xi_BRANCH_NUM => p_ext_bank_branch_rec.branch_number,
1631: Xi_BANK_NUM => p_ext_bank_rec.bank_number,
1632: Xo_VALUE_OUT => l_bank_branch_num);

Line 1638: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_SE(

1634:
1635: x_valid := TRUE;
1636:
1637: -- Validate Check Digit
1638: CE_VALIDATE_BANKINFO.CE_VALIDATE_CD_SE(
1639: Xi_CD => p_ext_bank_acct_rec.check_digits,
1640: Xi_X_ACCOUNT_NUMBER => p_ext_bank_acct_rec.bank_account_num);
1641:
1642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1691: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_US(

1687:
1688: l_bank_branch_num := p_ext_bank_branch_rec.branch_name;
1689:
1690: -- Validate Bank Branch
1691: CE_VALIDATE_BANKINFO.CE_VALIDATE_BRANCH_US(
1692: Xi_BRANCH_NUMBER => p_ext_bank_branch_rec.branch_number,
1693: Xi_PASS_MAND_CHECK => 'P',
1694: Xo_VALUE_OUT => l_bank_branch_num);
1695:

Line 2011: ce_validate_bankinfo.ce_validate_bank(p_ext_bank_rec.country_code,

2007: -- check_mandatory(IBY_BANK_NUM_FIELD, p_ext_bank_rec.bank_number);
2008:
2009: -- call CE validate bank api to validate bank
2010: -- country specific validation API call here
2011: ce_validate_bankinfo.ce_validate_bank(p_ext_bank_rec.country_code,
2012: p_ext_bank_rec.bank_number,
2013: p_ext_bank_rec.bank_name,
2014: p_ext_bank_rec.bank_alt_name,
2015: p_ext_bank_rec.tax_payer_id,

Line 2129: ce_validate_bankinfo.ce_validate_branch(l_country,

2125: END IF;
2126: CLOSE c_bank;
2127:
2128: -- country specific validation API call here
2129: ce_validate_bankinfo.ce_validate_branch(l_country,
2130: l_bank_number,
2131: p_ext_bank_branch_rec.branch_number,
2132: l_bank_name,
2133: p_ext_bank_branch_rec.branch_name,