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_UPG dependencies on CE_VALIDATE_BANKINFO_UPG

Line 1: package body CE_VALIDATE_BANKINFO_UPG as

1: package body CE_VALIDATE_BANKINFO_UPG as
2: /* $Header: cevlbkub.pls 120.4 2005/08/23 21:52:35 lkwan noship $ */
3:
4:
5: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

Line 71: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');

67: BANK_NUM varchar2(60);
68: bank_count number;
69: BEGIN
70: IF l_DEBUG in ('Y', 'C') THEN
71: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');
72: END IF;
73:
74: select count(*) into bank_count
75: From CE_UPG_BANK_REC PartyBank

Line 134: cep_standard.debug('<

130:
131: END IF;
132:
133: /*IF l_DEBUG in ('Y', 'C') THEN
134: cep_standard.debug('< 135: END IF;
136: */
137: EXCEPTION
138: WHEN OTHERS THEN

Line 140: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM ' );

136: */
137: EXCEPTION
138: WHEN OTHERS THEN
139: IF l_DEBUG in ('Y', 'C') THEN
140: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM ' );
141: END IF;
142:
143: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
144: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');

Line 144: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');

140: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM ' );
141: END IF;
142:
143: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
144: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.compare_bank_and_branch_num');
145: fnd_msg_pub.add;
146: RAISE;
147:
148: END COMPARE_BANK_AND_BRANCH_NUM;

Line 185: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD');

181:
182:
183: BEGIN
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD');
186: END IF;
187:
188: cd_position := (length(Xi_account_num) - Xi_CD_pos_from_right);
189: acct_cd := substr(Xi_account_num, cd_position, Xi_CD_length);

Line 210: cep_standard.debug('<

206: END IF;
207:
208: /*
209: IF l_DEBUG in ('Y', 'C') THEN
210: cep_standard.debug('< 211: END IF;
212: */
213: END COMPARE_ACCOUNT_NUM_AND_CD;
214:

Line 242: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VAL_UNIQUE_TAX_PAYER_ID');

238: l_taxid VARCHAR2(30);
239:
240: BEGIN
241: IF l_DEBUG in ('Y', 'C') THEN
242: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VAL_UNIQUE_TAX_PAYER_ID');
243: END IF;
244:
245: OPEN CHECK_UNIQUE_TAXID_BK;
246: FETCH CHECK_UNIQUE_TAXID_BK INTO l_taxid;

Line 259: cep_standard.debug('<

255: END IF;
256: CLOSE CHECK_UNIQUE_TAXID_BK;
257: /*
258: IF l_DEBUG in ('Y', 'C') THEN
259: cep_standard.debug('< 260: END IF;
261: */
262: END CE_VAL_UNIQUE_TAX_PAYER_ID;
263:

Line 326: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_check_cross_module_tax_id'||

322: l_entity_name VARCHAR2(80);
323:
324: BEGIN
325: IF l_DEBUG in ('Y', 'C') THEN
326: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_check_cross_module_tax_id'||
327: ' p_taxpayer_id: ' || p_taxpayer_id );
328: END IF;
329:
330: -- Checking cross module Banks/Customers

Line 442: cep_standard.debug('<

438: p_return_bk:='NA';
439:
440: /*
441: IF l_DEBUG in ('Y', 'C') THEN
442: cep_standard.debug('< 443: END IF;
444: */
445: END ce_check_cross_module_tax_id;
446: /* --------------------------------------------------------------------

Line 469: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_TAX_ID_CHECK_ALGORITHM '||p_COUNTRY );

465: l_mod_value NUMBER(2);
466: BEGIN
467:
468: IF l_DEBUG in ('Y', 'C') THEN
469: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_TAX_ID_CHECK_ALGORITHM '||p_COUNTRY );
470: END IF;
471:
472: -- Check the Taxpayer ID Valdiation digit for Colombia
473:

Line 520: cep_standard.debug('<

516:
517: END IF;
518: /*
519: IF l_DEBUG in ('Y', 'C') THEN
520: cep_standard.debug('< 521: END IF;
522: */
523: END ce_tax_id_check_algorithm;
524:

Line 554: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd X_COUNTRY_NAME: ' ||X_COUNTRY_NAME);

550: X_PASS_MAND_CHECK VARCHAR2(1);
551:
552: BEGIN
553: IF l_DEBUG in ('Y', 'C') THEN
554: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd X_COUNTRY_NAME: ' ||X_COUNTRY_NAME);
555: END IF;
556:
557: COUNTRY_NAME := X_COUNTRY_NAME;
558:

Line 565: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||

561:
562: /*
563: IF l_DEBUG in ('Y', 'C') THEN
564: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);
565: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
566: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
567: END IF;
568: */
569: /* removed 9/2/03

Line 566: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

562: /*
563: IF l_DEBUG in ('Y', 'C') THEN
564: cep_standard.debug('COUNTRY_NAME: '|| COUNTRY_NAME);
565: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
566: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
567: END IF;
568: */
569: /* removed 9/2/03
570: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 594: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_FR(X_CD,

590: END IF;
591:
592: IF (COUNTRY_NAME = 'FR') then
593:
594: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_FR(X_CD,
595: X_PASS_MAND_CHECK,
596: X_BANK_NUMBER,
597: X_BRANCH_NUMBER,
598: translate(X_ACCOUNT_NUMBER,

Line 604: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_ES(X_CD,

600: '123456789123456789234567890') );
601:
602: ELSIF (COUNTRY_NAME = 'ES') then
603:
604: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_ES(X_CD,
605: X_PASS_MAND_CHECK,
606: X_BANK_NUMBER,
607: X_BRANCH_NUMBER,
608: translate(X_ACCOUNT_NUMBER,

Line 614: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_PT(X_CD,

610: '123456789123456789234567890') );
611:
612: ELSIF (COUNTRY_NAME = 'PT') then
613:
614: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_PT(X_CD,
615: X_PASS_MAND_CHECK,
616: X_BANK_NUMBER,
617: X_BRANCH_NUMBER,
618: translate(X_ACCOUNT_NUMBER,

Line 626: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_DE(X_CD,

622: -- added 5/14/02
623:
624: ELSIF (COUNTRY_NAME = 'DE') then
625:
626: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_DE(X_CD,
627: X_ACCOUNT_NUMBER);
628:
629: ELSIF (COUNTRY_NAME = 'GR') then
630:

Line 631: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_GR(X_CD,

627: X_ACCOUNT_NUMBER);
628:
629: ELSIF (COUNTRY_NAME = 'GR') then
630:
631: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_GR(X_CD,
632: X_PASS_MAND_CHECK,
633: X_BANK_NUMBER,
634: X_BRANCH_NUMBER,
635: translate(X_ACCOUNT_NUMBER,

Line 641: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_IS(X_CD,

637: '123456789123456789234567890') );
638:
639: ELSIF (COUNTRY_NAME = 'IS') then
640:
641: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_IS(X_CD,
642: translate(X_ACCOUNT_NUMBER,
643: 'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
644: '123456789123456789234567890') );
645:

Line 648: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_IT(X_CD,

644: '123456789123456789234567890') );
645:
646: ELSIF (COUNTRY_NAME = 'IT') then
647:
648: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_IT(X_CD,
649: X_PASS_MAND_CHECK,
650: X_BANK_NUMBER,
651: X_BRANCH_NUMBER,
652: translate(X_ACCOUNT_NUMBER,

Line 658: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_LU(X_CD,

654: '123456789123456789234567890') );
655:
656: ELSIF (COUNTRY_NAME = 'LU') then
657:
658: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_LU(X_CD,
659: X_BANK_NUMBER,
660: X_BRANCH_NUMBER,
661: X_ACCOUNT_NUMBER);
662: -- X_VALUE_OUT);

Line 666: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_SE(X_CD,

662: -- X_VALUE_OUT);
663:
664: ELSIF (COUNTRY_NAME = 'SE') then
665:
666: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_SE(X_CD,
667: X_ACCOUNT_NUMBER);
668:
669:
670: END IF;

Line 679: --cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_COUNT: '|| x_msg_count|| '----------' ||

675: p_count => x_msg_count,
676: p_data => x_msg_data);
677: */
678: IF l_DEBUG in ('Y', 'C') THEN
679: --cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_COUNT: '|| x_msg_count|| '----------' ||
680: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_DATA: '|| x_msg_data|| '----------' ||
681: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
682: cep_standard.debug('< 683: END IF;

Line 680: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_DATA: '|| x_msg_data|| '----------' ||

676: p_data => x_msg_data);
677: */
678: IF l_DEBUG in ('Y', 'C') THEN
679: --cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_COUNT: '|| x_msg_count|| '----------' ||
680: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_DATA: '|| x_msg_data|| '----------' ||
681: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
682: cep_standard.debug('< 683: END IF;
684: EXCEPTION

Line 681: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||

677: */
678: IF l_DEBUG in ('Y', 'C') THEN
679: --cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_COUNT: '|| x_msg_count|| '----------' ||
680: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_DATA: '|| x_msg_data|| '----------' ||
681: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
682: cep_standard.debug('< 683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN

Line 682: cep_standard.debug('<

678: IF l_DEBUG in ('Y', 'C') THEN
679: --cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_COUNT: '|| x_msg_count|| '----------' ||
680: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - P_DATA: '|| x_msg_data|| '----------' ||
681: --'CE_VALIDATE_BANKINFO_UPG.ce_validate_cd - X_VALUE_OUT: '|| X_VALUE_OUT|| '----------' ||
682: cep_standard.debug('< 683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN
686: IF l_DEBUG in ('Y', 'C') THEN

Line 687: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd ' ||X_COUNTRY_NAME );

683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN
686: IF l_DEBUG in ('Y', 'C') THEN
687: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd ' ||X_COUNTRY_NAME );
688: END IF;
689:
690: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
691: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_cd');

Line 691: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_cd');

687: cep_standard.debug('CE_VALIDATE_BANKINFO_UPG.ce_validate_cd ' ||X_COUNTRY_NAME );
688: END IF;
689:
690: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
691: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_cd');
692: fnd_msg_pub.add;
693: RAISE;
694:
695:

Line 745: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch');

741:
742:
743: BEGIN
744: IF l_DEBUG in ('Y', 'C') THEN
745: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch');
746: END IF;
747:
748:
749: COUNTRY_NAME := X_COUNTRY_NAME;

Line 793: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_AT(X_BRANCH_NUMBER,

789: -- VALIDATION TYPE: KEY, ALL
790:
791: IF (COUNTRY_NAME = 'AT')
792: THEN
793: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_AT(X_BRANCH_NUMBER,
794: X_PASS_MAND_CHECK,
795: X_VALUE_OUT);
796:
797: ELSIF (COUNTRY_NAME = 'ES')

Line 799: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_ES(X_BRANCH_NUMBER,

795: X_VALUE_OUT);
796:
797: ELSIF (COUNTRY_NAME = 'ES')
798: then
799: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_ES(X_BRANCH_NUMBER,
800: X_PASS_MAND_CHECK,
801: X_VALUE_OUT);
802:
803: ELSIF (COUNTRY_NAME = 'FR')

Line 805: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_FR(X_BRANCH_NUMBER,

801: X_VALUE_OUT);
802:
803: ELSIF (COUNTRY_NAME = 'FR')
804: then
805: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_FR(X_BRANCH_NUMBER,
806: X_PASS_MAND_CHECK,
807: X_VALUE_OUT);
808:
809: ELSIF (COUNTRY_NAME = 'PT')

Line 811: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_PT(X_BRANCH_NUMBER,

807: X_VALUE_OUT);
808:
809: ELSIF (COUNTRY_NAME = 'PT')
810: then
811: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_PT(X_BRANCH_NUMBER,
812: X_PASS_MAND_CHECK);
813:
814: ELSIF (COUNTRY_NAME = 'BR')
815: then

Line 816: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_BR(X_BRANCH_NUMBER,

812: X_PASS_MAND_CHECK);
813:
814: ELSIF (COUNTRY_NAME = 'BR')
815: then
816: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_BR(X_BRANCH_NUMBER,
817: X_PASS_MAND_CHECK,
818: X_VALUE_OUT);
819:
820: -- added 5/14/02

Line 824: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_DE(X_BRANCH_NUMBER,

820: -- added 5/14/02
821:
822: ELSIF (COUNTRY_NAME = 'DE')
823: then
824: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_DE(X_BRANCH_NUMBER,
825: X_BANK_ID);
826:
827: ELSIF (COUNTRY_NAME = 'GR')
828: then

Line 829: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_GR(X_BRANCH_NUMBER);

825: X_BANK_ID);
826:
827: ELSIF (COUNTRY_NAME = 'GR')
828: then
829: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_GR(X_BRANCH_NUMBER);
830:
831: ELSIF (COUNTRY_NAME = 'IS')
832: then
833: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IS(X_BRANCH_NUMBER,

Line 833: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IS(X_BRANCH_NUMBER,

829: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_GR(X_BRANCH_NUMBER);
830:
831: ELSIF (COUNTRY_NAME = 'IS')
832: then
833: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IS(X_BRANCH_NUMBER,
834: X_BANK_ID,
835: X_VALUE_OUT);
836:
837: ELSIF (COUNTRY_NAME = 'IE')

Line 839: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IE(X_BRANCH_NUMBER,

835: X_VALUE_OUT);
836:
837: ELSIF (COUNTRY_NAME = 'IE')
838: then
839: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IE(X_BRANCH_NUMBER,
840: X_BANK_ID);
841:
842: ELSIF (COUNTRY_NAME = 'IT')
843: then

Line 844: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IT(X_BRANCH_NUMBER,

840: X_BANK_ID);
841:
842: ELSIF (COUNTRY_NAME = 'IT')
843: then
844: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_IT(X_BRANCH_NUMBER,
845: X_PASS_MAND_CHECK);
846:
847: ELSIF (COUNTRY_NAME = 'LU')
848: then

Line 849: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_LU(X_BRANCH_NUMBER,

845: X_PASS_MAND_CHECK);
846:
847: ELSIF (COUNTRY_NAME = 'LU')
848: then
849: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_LU(X_BRANCH_NUMBER,
850: X_BANK_ID);
851:
852: ELSIF (COUNTRY_NAME = 'PL')
853: then

Line 854: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_PL(X_BRANCH_NUMBER,

850: X_BANK_ID);
851:
852: ELSIF (COUNTRY_NAME = 'PL')
853: then
854: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_PL(X_BRANCH_NUMBER,
855: X_BANK_ID);
856:
857: ELSIF (COUNTRY_NAME = 'SE')
858: then

Line 859: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_SE(X_BRANCH_NUMBER,

855: X_BANK_ID);
856:
857: ELSIF (COUNTRY_NAME = 'SE')
858: then
859: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_SE(X_BRANCH_NUMBER,
860: X_BANK_ID);
861:
862: ELSIF (COUNTRY_NAME = 'CH')
863: then

Line 864: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_CH(X_BRANCH_NUMBER,

860: X_BANK_ID);
861:
862: ELSIF (COUNTRY_NAME = 'CH')
863: then
864: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_CH(X_BRANCH_NUMBER,
865: X_BANK_ID);
866:
867: ELSIF (COUNTRY_NAME = 'GB')
868: then

Line 869: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_GB(X_BRANCH_NUMBER,

865: X_BANK_ID);
866:
867: ELSIF (COUNTRY_NAME = 'GB')
868: then
869: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_GB(X_BRANCH_NUMBER,
870: X_BANK_ID);
871:
872: ELSIF (COUNTRY_NAME = 'US')
873: then

Line 874: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_US(X_BRANCH_NUMBER,

870: X_BANK_ID);
871:
872: ELSIF (COUNTRY_NAME = 'US')
873: then
874: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BRANCH_US(X_BRANCH_NUMBER,
875: X_PASS_MAND_CHECK,
876: X_VALUE_OUT);
877: -- added 10/19/04
878:

Line 912: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE' );

908: END IF;
909:
910: IF (COUNTRY_NAME = 'DE') THEN
911: IF l_DEBUG in ('Y', 'C') THEN
912: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE' );
913: END IF;
914:
915: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE(X_BRANCH_NUMBER,
916: X_BRANCH_NAME,

Line 915: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE(X_BRANCH_NUMBER,

911: IF l_DEBUG in ('Y', 'C') THEN
912: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE' );
913: END IF;
914:
915: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_DE(X_BRANCH_NUMBER,
916: X_BRANCH_NAME,
917: X_BANK_ID,
918: X_BRANCH_ID);
919:

Line 922: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US' );

918: X_BRANCH_ID);
919:
920: ELSIF (COUNTRY_NAME = 'US') THEN
921: IF l_DEBUG in ('Y', 'C') THEN
922: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US' );
923: END IF;
924:
925: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US(X_BRANCH_NUMBER,
926: X_BRANCH_NAME,

Line 925: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US(X_BRANCH_NUMBER,

921: IF l_DEBUG in ('Y', 'C') THEN
922: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US' );
923: END IF;
924:
925: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_US(X_BRANCH_NUMBER,
926: X_BRANCH_NAME,
927: X_BANK_ID,
928: X_BRANCH_ID);
929:

Line 932: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP' );

928: X_BRANCH_ID);
929:
930: ELSIF (COUNTRY_NAME = 'JP') THEN
931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP' );
933: END IF;
934:
935: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP(X_COUNTRY_NAME,
936: X_BRANCH_NUMBER,

Line 935: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP(X_COUNTRY_NAME,

931: IF l_DEBUG in ('Y', 'C') THEN
932: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP' );
933: END IF;
934:
935: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH_JP(X_COUNTRY_NAME,
936: X_BRANCH_NUMBER,
937: X_BRANCH_NAME,
938: X_BRANCH_NAME_ALT,
939: X_BANK_ID,

Line 943: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH' );

939: X_BANK_ID,
940: X_BRANCH_ID);
941: ELSE
942: IF l_DEBUG in ('Y', 'C') THEN
943: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH' );
944: END IF;
945: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH(X_COUNTRY_NAME,
946: X_BRANCH_NUMBER,
947: X_BRANCH_NAME,

Line 945: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH(X_COUNTRY_NAME,

941: ELSE
942: IF l_DEBUG in ('Y', 'C') THEN
943: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH' );
944: END IF;
945: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BRANCH(X_COUNTRY_NAME,
946: X_BRANCH_NUMBER,
947: X_BRANCH_NAME,
948: X_BANK_ID,
949: X_BRANCH_ID);

Line 990: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch - X_VALUE_OUT: '|| X_VALUE_OUT);

986: IF l_DEBUG in ('Y', 'C') THEN
987: cep_standard.debug('< 988: || x_msg_count ||' X_VALUE_OUT: '|| X_VALUE_OUT );
989: --cep_standard.debug('P_DATA: '|| x_msg_data );
990: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch - X_VALUE_OUT: '|| X_VALUE_OUT);
991: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || '< 992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN

Line 991: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || '<

987: cep_standard.debug('< 988: || x_msg_count ||' X_VALUE_OUT: '|| X_VALUE_OUT );
989: --cep_standard.debug('P_DATA: '|| x_msg_data );
990: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch - X_VALUE_OUT: '|| X_VALUE_OUT);
991: --cep_standard.debug('CE_VALIDATE_BRANCH: ' || '< 992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN
995: IF l_DEBUG in ('Y', 'C') THEN

Line 996: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch ' ||X_COUNTRY_NAME );

992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN
995: IF l_DEBUG in ('Y', 'C') THEN
996: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch ' ||X_COUNTRY_NAME );
997: END IF;
998:
999: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1000: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_branch');

Line 1000: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_branch');

996: cep_standard.debug('CE_VALIDATE_BRANCH: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_branch ' ||X_COUNTRY_NAME );
997: END IF;
998:
999: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1000: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_branch');
1001: fnd_msg_pub.add;
1002: RAISE;
1003:
1004: END CE_VALIDATE_BRANCH;

Line 1057: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account');

1053:
1054:
1055: BEGIN
1056: IF l_DEBUG in ('Y', 'C') THEN
1057: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account');
1058: END IF;
1059:
1060: COUNTRY_NAME := X_COUNTRY_NAME;
1061: X_VALUE_OUT := X_ACCOUNT_NUMBER;

Line 1098: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_AT(X_ACCOUNT_NUMBER,

1094: -- VALIDATION TYPE: KEY, ALL
1095:
1096: IF (COUNTRY_NAME = 'AT')
1097: then
1098: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_AT(X_ACCOUNT_NUMBER,
1099: X_PASS_MAND_CHECK,
1100: X_VALUE_OUT);
1101:
1102: ELSIF (COUNTRY_NAME = 'DK')

Line 1104: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DK(X_ACCOUNT_NUMBER,

1100: X_VALUE_OUT);
1101:
1102: ELSIF (COUNTRY_NAME = 'DK')
1103: then
1104: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DK(X_ACCOUNT_NUMBER,
1105: X_PASS_MAND_CHECK,
1106: X_VALUE_OUT);
1107:
1108: ELSIF (COUNTRY_NAME = 'NO')

Line 1110: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_NO(X_ACCOUNT_NUMBER,

1106: X_VALUE_OUT);
1107:
1108: ELSIF (COUNTRY_NAME = 'NO')
1109: then
1110: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_NO(X_ACCOUNT_NUMBER,
1111: X_PASS_MAND_CHECK);
1112:
1113: ELSIF (COUNTRY_NAME = 'ES')
1114: then

Line 1116: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_ES(X_ACCOUNT_NUMBER,

1112:
1113: ELSIF (COUNTRY_NAME = 'ES')
1114: then
1115:
1116: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_ES(X_ACCOUNT_NUMBER,
1117: X_PASS_MAND_CHECK,
1118: X_VALUE_OUT);
1119:
1120:

Line 1124: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_NL(X_ACCOUNT_NUMBER,

1120:
1121: ELSIF (COUNTRY_NAME = 'NL')
1122: then
1123:
1124: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_NL(X_ACCOUNT_NUMBER,
1125: X_PASS_MAND_CHECK);
1126:
1127: ELSIF (COUNTRY_NAME = 'FR')
1128: then

Line 1130: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_FR(X_ACCOUNT_NUMBER,

1126:
1127: ELSIF (COUNTRY_NAME = 'FR')
1128: then
1129:
1130: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_FR(X_ACCOUNT_NUMBER,
1131: X_PASS_MAND_CHECK,
1132: X_VALUE_OUT);
1133:
1134:

Line 1138: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_BE(X_ACCOUNT_NUMBER,

1134:
1135: ELSIF (COUNTRY_NAME = 'BE')
1136: then
1137:
1138: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_BE(X_ACCOUNT_NUMBER,
1139: X_PASS_MAND_CHECK);
1140:
1141:
1142: ELSIF (COUNTRY_NAME = 'PT')

Line 1145: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_PT(X_ACCOUNT_NUMBER,

1141:
1142: ELSIF (COUNTRY_NAME = 'PT')
1143: then
1144:
1145: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_PT(X_ACCOUNT_NUMBER,
1146: X_PASS_MAND_CHECK,
1147: X_VALUE_OUT);
1148:
1149: ELSIF (COUNTRY_NAME = 'FI')

Line 1153: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_FI(X_ACCOUNT_NUMBER,

1149: ELSIF (COUNTRY_NAME = 'FI')
1150: AND (X_BRANCH_NUMBER='LMP')
1151: then
1152:
1153: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_FI(X_ACCOUNT_NUMBER,
1154: X_PASS_MAND_CHECK);
1155:
1156: -- added 5/14/02
1157:

Line 1161: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DE(X_ACCOUNT_NUMBER,

1157:
1158: ELSIF (COUNTRY_NAME = 'DE')
1159: then
1160:
1161: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DE(X_ACCOUNT_NUMBER,
1162: X_VALUE_OUT );
1163:
1164: ELSIF (COUNTRY_NAME = 'GR')
1165: then

Line 1167: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GR(X_ACCOUNT_NUMBER,

1163:
1164: ELSIF (COUNTRY_NAME = 'GR')
1165: then
1166:
1167: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GR(X_ACCOUNT_NUMBER,
1168: X_VALUE_OUT);
1169:
1170: ELSIF (COUNTRY_NAME = 'IS')
1171: then

Line 1173: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IS(X_ACCOUNT_NUMBER,

1169:
1170: ELSIF (COUNTRY_NAME = 'IS')
1171: then
1172:
1173: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IS(X_ACCOUNT_NUMBER,
1174: X_VALUE_OUT );
1175:
1176:
1177: ELSIF (COUNTRY_NAME = 'IE')

Line 1180: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IE(X_ACCOUNT_NUMBER);

1176:
1177: ELSIF (COUNTRY_NAME = 'IE')
1178: then
1179:
1180: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IE(X_ACCOUNT_NUMBER);
1181:
1182: ELSIF (COUNTRY_NAME = 'IT')
1183: then
1184: IF l_DEBUG in ('Y', 'C') THEN

Line 1189: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IT(X_ACCOUNT_NUMBER,

1185: cep_standard.debug('X_ACCOUNT_NUMBER : '|| X_ACCOUNT_NUMBER||
1186: ' X_VALUE_OUT : '|| X_VALUE_OUT);
1187: END IF;
1188:
1189: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_IT(X_ACCOUNT_NUMBER,
1190: X_VALUE_OUT);
1191:
1192: ELSIF (COUNTRY_NAME = 'LU')
1193: then

Line 1195: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_LU(X_ACCOUNT_NUMBER);

1191:
1192: ELSIF (COUNTRY_NAME = 'LU')
1193: then
1194:
1195: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_LU(X_ACCOUNT_NUMBER);
1196:
1197:
1198: ELSIF (COUNTRY_NAME = 'PL')
1199: then

Line 1201: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_PL(X_ACCOUNT_NUMBER);

1197:
1198: ELSIF (COUNTRY_NAME = 'PL')
1199: then
1200:
1201: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_PL(X_ACCOUNT_NUMBER);
1202:
1203:
1204: ELSIF (COUNTRY_NAME = 'SE')
1205: then

Line 1207: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_SE(X_ACCOUNT_NUMBER);

1203:
1204: ELSIF (COUNTRY_NAME = 'SE')
1205: then
1206:
1207: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_SE(X_ACCOUNT_NUMBER);
1208:
1209:
1210: ELSIF (COUNTRY_NAME = 'CH')
1211: then

Line 1213: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_CH(X_ACCOUNT_NUMBER,

1209:
1210: ELSIF (COUNTRY_NAME = 'CH')
1211: then
1212:
1213: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_CH(X_ACCOUNT_NUMBER,
1214: X_ACCOUNT_TYPE,
1215: X_VALIDATION_TYPE );
1216:
1217: ELSIF (COUNTRY_NAME = 'GB')

Line 1220: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GB(X_ACCOUNT_NUMBER,

1216:
1217: ELSIF (COUNTRY_NAME = 'GB')
1218: then
1219:
1220: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GB(X_ACCOUNT_NUMBER,
1221: X_VALUE_OUT);
1222:
1223: -- added 10/19/04
1224: ELSIF (COUNTRY_NAME = 'AU')

Line 1254: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_BR(X_ACCOUNT_NUMBER,

1250:
1251: IF (COUNTRY_NAME = 'BR')
1252: then
1253:
1254: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_BR(X_ACCOUNT_NUMBER,
1255: X_SECONDARY_ACCOUNT_REFERENCE);
1256: END IF;
1257:
1258: END IF;

Line 1262: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD(X_COUNTRY_NAME,

1258: END IF;
1259:
1260: IF (X_VALIDATION_TYPE in ('KEY', 'ALL')) THEN
1261:
1262: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD(X_COUNTRY_NAME,
1263: X_CD ,
1264: X_BANK_NUMBER ,
1265: X_BRANCH_NUMBER ,
1266: X_ACCOUNT_NUMBER);

Line 1280: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT_JP(X_ACCOUNT_NUMBER,

1276: cep_standard.debug('UNIQUE_VALIDATION CHECK for account');
1277: END IF;
1278:
1279: IF (COUNTRY_NAME = 'JP') THEN
1280: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT_JP(X_ACCOUNT_NUMBER,
1281: X_CURRENCY_CODE,
1282: X_ACCOUNT_TYPE,
1283: X_ACCOUNT_NAME,
1284: X_BRANCH_ID,

Line 1288: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT_NZ(X_ACCOUNT_NUMBER,

1284: X_BRANCH_ID,
1285: X_ACCOUNT_ID);
1286:
1287: ELSIF (COUNTRY_NAME = 'NZ') THEN
1288: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT_NZ(X_ACCOUNT_NUMBER,
1289: X_CURRENCY_CODE,
1290: X_ACCOUNT_SUFFIX,
1291: X_ACCOUNT_NAME,
1292: X_BRANCH_ID,

Line 1296: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT' );

1292: X_BRANCH_ID,
1293: X_ACCOUNT_ID);
1294: ELSE
1295: IF l_DEBUG in ('Y', 'C') THEN
1296: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT' );
1297: END IF;
1298: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT(
1299: X_ACCOUNT_NUMBER,
1300: X_CURRENCY_CODE,

Line 1298: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT(

1294: ELSE
1295: IF l_DEBUG in ('Y', 'C') THEN
1296: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT' );
1297: END IF;
1298: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_ACCOUNT(
1299: X_ACCOUNT_NUMBER,
1300: X_CURRENCY_CODE,
1301: X_ACCOUNT_NAME,
1302: X_BRANCH_ID,

Line 1335: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account - X_VALUE_OUT: '|| X_VALUE_OUT);

1331: IF l_DEBUG in ('Y', 'C') THEN
1332: cep_standard.debug('< 1333: ' P_COUNT: '|| x_msg_count || ' X_VALUE_OUT: '|| X_VALUE_OUT);
1334: --cep_standard.debug('P_DATA: '|| x_msg_data );
1335: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account - X_VALUE_OUT: '|| X_VALUE_OUT);
1336: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || '< 1337: END IF;
1338: EXCEPTION
1339: WHEN OTHERS THEN

Line 1336: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || '<

1332: cep_standard.debug('< 1333: ' P_COUNT: '|| x_msg_count || ' X_VALUE_OUT: '|| X_VALUE_OUT);
1334: --cep_standard.debug('P_DATA: '|| x_msg_data );
1335: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account - X_VALUE_OUT: '|| X_VALUE_OUT);
1336: --cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || '< 1337: END IF;
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340:

Line 1342: cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account ' ||X_COUNTRY_NAME );

1338: EXCEPTION
1339: WHEN OTHERS THEN
1340:
1341: IF l_DEBUG in ('Y', 'C') THEN
1342: cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account ' ||X_COUNTRY_NAME );
1343: END IF;
1344: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1345: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_account');
1346: fnd_msg_pub.add;

Line 1345: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_account');

1341: IF l_DEBUG in ('Y', 'C') THEN
1342: cep_standard.debug('CE_VALIDATE_ACCOUNT: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_account ' ||X_COUNTRY_NAME );
1343: END IF;
1344: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1345: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_account');
1346: fnd_msg_pub.add;
1347: RAISE;
1348:
1349: END CE_VALIDATE_ACCOUNT;

Line 1393: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank');

1389: l_app_short_name varchar2(20);
1390:
1391: BEGIN
1392: IF l_DEBUG in ('Y', 'C') THEN
1393: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank');
1394: END IF;
1395:
1396: COUNTRY_NAME := X_COUNTRY_NAME;
1397: X_VALUE_OUT := X_BANK_NUMBER;

Line 1431: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_ES(X_BANK_NUMBER,

1427: -- VALIDATION TYPE: KEY, ALL
1428:
1429: IF (COUNTRY_NAME = 'ES')
1430: then
1431: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_ES(X_BANK_NUMBER,
1432: X_PASS_MAND_CHECK,
1433: X_VALUE_OUT);
1434:
1435: ELSIF (COUNTRY_NAME = 'FR')

Line 1437: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_FR(X_BANK_NUMBER,

1433: X_VALUE_OUT);
1434:
1435: ELSIF (COUNTRY_NAME = 'FR')
1436: then
1437: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_FR(X_BANK_NUMBER,
1438: X_PASS_MAND_CHECK,
1439: X_VALUE_OUT);
1440:
1441: ELSIF (COUNTRY_NAME = 'PT')

Line 1443: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_PT(X_BANK_NUMBER,

1439: X_VALUE_OUT);
1440:
1441: ELSIF (COUNTRY_NAME = 'PT')
1442: then
1443: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_PT(X_BANK_NUMBER,
1444: X_PASS_MAND_CHECK);
1445:
1446: ELSIF (COUNTRY_NAME = 'BR')
1447: then

Line 1448: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_BR(X_BANK_NUMBER,

1444: X_PASS_MAND_CHECK);
1445:
1446: ELSIF (COUNTRY_NAME = 'BR')
1447: then
1448: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_BR(X_BANK_NUMBER,
1449: X_PASS_MAND_CHECK,
1450: X_VALUE_OUT);
1451:
1452: -- Added 5/14/02

Line 1457: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_DE(X_BANK_NUMBER);

1453:
1454:
1455: ELSIF (COUNTRY_NAME = 'DE')
1456: then
1457: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_DE(X_BANK_NUMBER);
1458:
1459: ELSIF (COUNTRY_NAME = 'GR')
1460: then
1461: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GR(X_BANK_NUMBER);

Line 1461: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GR(X_BANK_NUMBER);

1457: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_DE(X_BANK_NUMBER);
1458:
1459: ELSIF (COUNTRY_NAME = 'GR')
1460: then
1461: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GR(X_BANK_NUMBER);
1462:
1463: ELSIF (COUNTRY_NAME = 'IS')
1464: then
1465: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IS(X_BANK_NUMBER,

Line 1465: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IS(X_BANK_NUMBER,

1461: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GR(X_BANK_NUMBER);
1462:
1463: ELSIF (COUNTRY_NAME = 'IS')
1464: then
1465: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IS(X_BANK_NUMBER,
1466: X_VALUE_OUT);
1467:
1468: ELSIF (COUNTRY_NAME = 'IE')
1469: then

Line 1470: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IE(X_BANK_NUMBER);

1466: X_VALUE_OUT);
1467:
1468: ELSIF (COUNTRY_NAME = 'IE')
1469: then
1470: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IE(X_BANK_NUMBER);
1471:
1472: ELSIF (COUNTRY_NAME = 'IT')
1473: then
1474: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IT(X_BANK_NUMBER,

Line 1474: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IT(X_BANK_NUMBER,

1470: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IE(X_BANK_NUMBER);
1471:
1472: ELSIF (COUNTRY_NAME = 'IT')
1473: then
1474: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_IT(X_BANK_NUMBER,
1475: X_PASS_MAND_CHECK);
1476:
1477: ELSIF (COUNTRY_NAME = 'LU')
1478: then

Line 1479: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_LU(X_BANK_NUMBER);

1475: X_PASS_MAND_CHECK);
1476:
1477: ELSIF (COUNTRY_NAME = 'LU')
1478: then
1479: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_LU(X_BANK_NUMBER);
1480:
1481:
1482: ELSIF (COUNTRY_NAME = 'PL')
1483: then

Line 1484: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_PL(X_BANK_NUMBER);

1480:
1481:
1482: ELSIF (COUNTRY_NAME = 'PL')
1483: then
1484: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_PL(X_BANK_NUMBER);
1485:
1486: ELSIF (COUNTRY_NAME = 'SE')
1487: then
1488: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_SE(X_BANK_NUMBER);

Line 1488: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_SE(X_BANK_NUMBER);

1484: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_PL(X_BANK_NUMBER);
1485:
1486: ELSIF (COUNTRY_NAME = 'SE')
1487: then
1488: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_SE(X_BANK_NUMBER);
1489:
1490: ELSIF (COUNTRY_NAME = 'CH')
1491: then
1492: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CH(X_BANK_NUMBER);

Line 1492: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CH(X_BANK_NUMBER);

1488: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_SE(X_BANK_NUMBER);
1489:
1490: ELSIF (COUNTRY_NAME = 'CH')
1491: then
1492: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CH(X_BANK_NUMBER);
1493:
1494: ELSIF (COUNTRY_NAME = 'GB')
1495: then
1496: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GB(X_BANK_NUMBER);

Line 1496: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GB(X_BANK_NUMBER);

1492: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CH(X_BANK_NUMBER);
1493:
1494: ELSIF (COUNTRY_NAME = 'GB')
1495: then
1496: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_GB(X_BANK_NUMBER);
1497:
1498: -- Added 10/19/04
1499:
1500: ELSIF (COUNTRY_NAME = 'AU')

Line 1527: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CO(X_COUNTRY_NAME,

1523:
1524: IF (X_VALIDATION_TYPE = 'ALL') THEN
1525: IF (COUNTRY_NAME = 'CO')
1526: then
1527: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CO(X_COUNTRY_NAME,
1528: X_BANK_NAME ,
1529: X_TAX_PAYER_ID);
1530: END IF;
1531: END IF;

Line 1546: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP' );

1542: END IF;
1543:
1544: IF (COUNTRY_NAME = 'JP') THEN
1545: IF l_DEBUG in ('Y', 'C') THEN
1546: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP' );
1547: END IF;
1548:
1549: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP(X_COUNTRY_NAME,
1550: X_BANK_NUMBER ,

Line 1549: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP(X_COUNTRY_NAME,

1545: IF l_DEBUG in ('Y', 'C') THEN
1546: cep_standard.debug('call CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP' );
1547: END IF;
1548:
1549: CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_UNIQUE_BANK_JP(X_COUNTRY_NAME,
1550: X_BANK_NUMBER ,
1551: X_BANK_NAME ,
1552: X_BANK_NAME_ALT,
1553: X_BANK_ID);

Line 1586: --cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank - X_VALUE_OUT: '|| X_VALUE_OUT );

1582: IF l_DEBUG in ('Y', 'C') THEN
1583: cep_standard.debug('< 1584: ||' P_COUNT: '|| x_msg_count || ' X_VALUE_OUT: '|| X_VALUE_OUT );
1585: --cep_standard.debug('P_DATA: '|| x_msg_data );
1586: --cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank - X_VALUE_OUT: '|| X_VALUE_OUT );
1587: --cep_standard.debug('CE_VALIDATE_BANK: ' || '< 1588: END IF;
1589: EXCEPTION
1590: WHEN OTHERS THEN

Line 1587: --cep_standard.debug('CE_VALIDATE_BANK: ' || '<

1583: cep_standard.debug('< 1584: ||' P_COUNT: '|| x_msg_count || ' X_VALUE_OUT: '|| X_VALUE_OUT );
1585: --cep_standard.debug('P_DATA: '|| x_msg_data );
1586: --cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank - X_VALUE_OUT: '|| X_VALUE_OUT );
1587: --cep_standard.debug('CE_VALIDATE_BANK: ' || '< 1588: END IF;
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: IF l_DEBUG in ('Y', 'C') THEN

Line 1592: cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank ' ||X_COUNTRY_NAME );

1588: END IF;
1589: EXCEPTION
1590: WHEN OTHERS THEN
1591: IF l_DEBUG in ('Y', 'C') THEN
1592: cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank ' ||X_COUNTRY_NAME );
1593: END IF;
1594:
1595: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1596: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_bank');

Line 1596: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_bank');

1592: cep_standard.debug('CE_VALIDATE_BANK: ' || 'CE_VALIDATE_BANKINFO_UPG.ce_validate_bank ' ||X_COUNTRY_NAME );
1593: END IF;
1594:
1595: FND_MESSAGE.set_name('CE', 'CE_UNHANDLED_EXCEPTION');
1596: fnd_message.set_token('PROCEDURE', 'CE_VALIDATE_BANKINFO_UPG.cd_validate_bank');
1597: fnd_msg_pub.add;
1598: RAISE;
1599:
1600:

Line 1670: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_pt');

1666: /* MAIN SECTION */
1667: /****************/
1668: BEGIN
1669: IF l_DEBUG in ('Y', 'C') THEN
1670: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_pt');
1671: END IF;
1672:
1673: CD_VALUE := upper(replace(Xi_CD,' ',''));
1674: bk_value := upper(replace(Xi_X_BANK_NUMBER,' ',''));

Line 1746: cep_standard.debug('<

1742: END IF; /* end of mandatory check */
1743:
1744: /*
1745: IF l_DEBUG in ('Y', 'C') THEN
1746: cep_standard.debug('< 1747: END IF;
1748: */
1749: END CE_VALIDATE_CD_PT;
1750:

Line 1813: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_es');

1809: /* MAIN SECTION */
1810: /****************/
1811: BEGIN
1812: IF l_DEBUG in ('Y', 'C') THEN
1813: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_es');
1814: END IF;
1815:
1816: CD_VALUE := upper(Xi_CD);
1817: bk_value := upper(Xi_X_BANK_NUMBER);

Line 1892: cep_standard.debug('<

1888:
1889: END IF; /* end of mandatory check */
1890: /*
1891: IF l_DEBUG in ('Y', 'C') THEN
1892: cep_standard.debug('< 1893: END IF;
1894: */
1895: END CE_VALIDATE_CD_ES;
1896:

Line 1949: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_fr');

1945: /* MAIN SECTION */
1946: /****************/
1947: BEGIN
1948: IF l_DEBUG in ('Y', 'C') THEN
1949: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_fr');
1950: END IF;
1951:
1952: CD_VALUE := upper(Xi_CD);
1953: bk_value := upper(Xi_X_BANK_NUMBER);

Line 2000: cep_standard.debug('<

1996: END IF; /* end of mandatory check */
1997:
1998: /*
1999: IF l_DEBUG in ('Y', 'C') THEN
2000: cep_standard.debug('< 2001: END IF;
2002: */
2003: END CE_VALIDATE_CD_FR;
2004:

Line 2047: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_DE');

2043: /* MAIN SECTION */
2044: /****************/
2045: BEGIN
2046: IF l_DEBUG in ('Y', 'C') THEN
2047: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_CD_DE');
2048: END IF;
2049:
2050: CD_VALUE := upper(Xi_CD);
2051:

Line 2061: if (CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD(Xi_X_ACCOUNT_NUMBER, CD_VALUE, 1, 0)) then

2057: IF length(CD_VALUE) = 1 then
2058: numeric_result_cd := ce_check_numeric(CD_VALUE,1,length(CD_VALUE));
2059:
2060: IF numeric_result_cd = '0' then
2061: if (CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD(Xi_X_ACCOUNT_NUMBER, CD_VALUE, 1, 0)) then
2062: pass_check;
2063: end if;
2064: ELSE
2065: fail_check;

Line 2076: cep_standard.debug('<

2072: END IF;
2073:
2074: /*
2075: IF l_DEBUG in ('Y', 'C') THEN
2076: cep_standard.debug('< 2077: END IF;
2078: */
2079: END CE_VALIDATE_CD_DE;
2080:

Line 2183: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_is');

2179: /* MAIN SECTION */
2180: /****************/
2181: BEGIN
2182: IF l_DEBUG in ('Y', 'C') THEN
2183: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_is');
2184: END IF;
2185:
2186: CD_VALUE := upper(replace(Xi_CD,' ',''));
2187: ac_value := upper(replace(Xi_X_ACCOUNT_NUMBER,' ',''));

Line 2205: if (CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD(ac_value, CD_VALUE, 1,1)) then

2201: IF numeric_result_cd = '0' then
2202: IF l_DEBUG in ('Y', 'C') THEN
2203: cep_standard.debug('CE_VALIDATE_CD: ' || 'cd is numeric');
2204: END IF;
2205: if (CE_VALIDATE_BANKINFO_UPG.COMPARE_ACCOUNT_NUM_AND_CD(ac_value, CD_VALUE, 1,1)) then
2206: pass_check;
2207: IF l_DEBUG in ('Y', 'C') THEN
2208: cep_standard.debug('cd_value = cal_cd');
2209: END IF;

Line 2234: cep_standard.debug('<

2230: END IF;
2231:
2232: /*
2233: IF l_DEBUG in ('Y', 'C') THEN
2234: cep_standard.debug('< 2235: END IF;
2236: */
2237: END CE_VALIDATE_CD_IS;
2238:

Line 2488: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_it'||

2484: /****************/
2485: BEGIN
2486:
2487: IF l_DEBUG in ('Y', 'C') THEN
2488: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_it'||
2489: ' Xi_X_ACCOUNT_NUMBER: '||Xi_X_ACCOUNT_NUMBER);
2490: END IF;
2491:
2492: CD_VALUE := upper(replace(Xi_CD,' ',''));

Line 2621: cep_standard.debug('<

2617: END IF;
2618:
2619: /*
2620: IF l_DEBUG in ('Y', 'C') THEN
2621: cep_standard.debug('< 2622: END IF;
2623: */
2624: END CE_VALIDATE_CD_IT;
2625:

Line 2668: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_lu');

2664: /* MAIN SECTION */
2665: /****************/
2666: BEGIN
2667: IF l_DEBUG in ('Y', 'C') THEN
2668: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_lu');
2669: END IF;
2670:
2671: ACCOUNT_VALUE := lpad(Xi_X_ACCOUNT_NUMBER,12,0);
2672:

Line 2709: cep_standard.debug('<

2705: END IF;
2706:
2707: /*
2708: IF l_DEBUG in ('Y', 'C') THEN
2709: cep_standard.debug('< 2710: END IF;
2711: */
2712: END CE_VALIDATE_CD_LU;
2713:

Line 2752: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_se');

2748: /* MAIN SECTION */
2749: /****************/
2750: BEGIN
2751: IF l_DEBUG in ('Y', 'C') THEN
2752: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_cd_se');
2753: END IF;
2754:
2755: CD_VALUE := upper(Xi_CD);
2756: account_value := upper(replace(Xi_X_ACCOUNT_NUMBER ,' ',''));

Line 2778: cep_standard.debug('<

2774: pass_check;
2775: END IF;
2776: /*
2777: IF l_DEBUG in ('Y', 'C') THEN
2778: cep_standard.debug('< 2779: END IF;
2780: */
2781: END CE_VALIDATE_CD_SE;
2782:

Line 2845: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_at');

2841: /* MAIN SECTION */
2842: /****************/
2843: BEGIN
2844: IF l_DEBUG in ('Y', 'C') THEN
2845: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_at');
2846: END IF;
2847:
2848: BRANCH_VALUE := upper(Xi_BRANCH_NUMBER );
2849: Xo_VALUE_OUT := BRANCH_VALUE;

Line 2881: cep_standard.debug('<

2877:
2878: END IF; /* end of mandatory check */
2879: /*
2880: IF l_DEBUG in ('Y', 'C') THEN
2881: cep_standard.debug('< 2882: END IF;
2883: */
2884: END CE_VALIDATE_BRANCH_AT;
2885:

Line 2929: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_pt');

2925: /* MAIN SECTION */
2926: /****************/
2927: BEGIN
2928: IF l_DEBUG in ('Y', 'C') THEN
2929: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_pt');
2930: END IF;
2931:
2932: BRANCH_VALUE := upper(Xi_BRANCH_NUMBER );
2933:

Line 2962: cep_standard.debug('<

2958: END IF; /* end of length check */
2959: END IF; /* end of mandatory check */
2960: /*
2961: IF l_DEBUG in ('Y', 'C') THEN
2962: cep_standard.debug('< 2963: END IF;
2964: */
2965: END CE_VALIDATE_BRANCH_PT;
2966:

Line 3008: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_fr');

3004: /* MAIN SECTION */
3005: /****************/
3006: BEGIN
3007: IF l_DEBUG in ('Y', 'C') THEN
3008: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_fr');
3009: END IF;
3010:
3011: BRANCH_VALUE := upper(Xi_BRANCH_NUMBER );
3012: Xo_VALUE_OUT := BRANCH_VALUE;

Line 3045: cep_standard.debug('<

3041: END IF; /* end of length check */
3042: END IF; /* end of mandatory check */
3043: /*
3044: IF l_DEBUG in ('Y', 'C') THEN
3045: cep_standard.debug('< 3046: END IF;
3047: */
3048: END CE_VALIDATE_BRANCH_FR;
3049:

Line 3099: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_es');

3095: /* MAIN SECTION */
3096: /****************/
3097: BEGIN
3098: IF l_DEBUG in ('Y', 'C') THEN
3099: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_es');
3100: END IF;
3101:
3102: BRANCH_VALUE := upper(Xi_BRANCH_NUMBER );
3103: Xo_VALUE_OUT := BRANCH_VALUE;

Line 3136: cep_standard.debug('<

3132: END IF; /* end of length check */
3133: END IF; /* end of mandatory check */
3134: /*
3135: IF l_DEBUG in ('Y', 'C') THEN
3136: cep_standard.debug('< 3137: END IF;
3138: */
3139: END CE_VALIDATE_BRANCH_ES;
3140:

Line 3184: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_br');

3180: /* MAIN SECTION */
3181: /****************/
3182: BEGIN
3183: IF l_DEBUG in ('Y', 'C') THEN
3184: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_br');
3185: END IF;
3186:
3187: BRANCH_VALUE := upper(Xi_BRANCH_NUMBER );
3188: Xo_VALUE_OUT := BRANCH_VALUE;

Line 3222: cep_standard.debug('<

3218:
3219: END IF; /* end of mandatory check */
3220: /*
3221: IF l_DEBUG in ('Y', 'C') THEN
3222: cep_standard.debug('< 3223: END IF;
3224: */
3225: END CE_VALIDATE_BRANCH_BR;
3226:

Line 3265: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_de');

3261: /* MAIN SECTION */
3262: /****************/
3263: BEGIN
3264: IF l_DEBUG in ('Y', 'C') THEN
3265: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_de');
3266: END IF;
3267:
3268: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3269:

Line 3279: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3275:
3276: IF numeric_result = '0' then /* its numeric so continue */
3277: -- Bank number and branch number should be the same
3278:
3279: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3280:
3281: ELSE
3282: fail_check;
3283: END IF; /* end of numeric check */

Line 3298: cep_standard.debug('<

3294:
3295: END IF;
3296:
3297: IF l_DEBUG in ('Y', 'C') THEN
3298: cep_standard.debug('< 3299: END IF;
3300:
3301: END CE_VALIDATE_BRANCH_DE;
3302:

Line 3338: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_gr');

3334: /* MAIN SECTION */
3335: /****************/
3336: BEGIN
3337: IF l_DEBUG in ('Y', 'C') THEN
3338: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_gr');
3339: END IF;
3340:
3341: BRANCH_VALUE := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3342:

Line 3375: cep_standard.debug('<

3371:
3372: END IF;
3373: /*
3374: IF l_DEBUG in ('Y', 'C') THEN
3375: cep_standard.debug('< 3376: END IF;
3377: */
3378: END CE_VALIDATE_BRANCH_GR;
3379:

Line 3417: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_is');

3413: /* MAIN SECTION */
3414: /****************/
3415: BEGIN
3416: IF l_DEBUG in ('Y', 'C') THEN
3417: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_is');
3418: END IF;
3419:
3420: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3421:

Line 3434: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3430:
3431: Xo_value_out := lpad(BRANCH_NUM,4,0);
3432: BRANCH_NUM := lpad(BRANCH_NUM,4,0);
3433:
3434: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3435:
3436: ELSE
3437: IF l_DEBUG in ('Y', 'C') THEN
3438: cep_standard.debug('branch_is fail numeric check');

Line 3457: cep_standard.debug('<

3453: END IF; /* end of length check */
3454:
3455: /*
3456: IF l_DEBUG in ('Y', 'C') THEN
3457: cep_standard.debug('< 3458: END IF;
3459: */
3460: END CE_VALIDATE_BRANCH_IS;
3461:

Line 3498: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_ie');

3494: /* MAIN SECTION */
3495: /****************/
3496: BEGIN
3497: IF l_DEBUG in ('Y', 'C') THEN
3498: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_ie');
3499: END IF;
3500:
3501: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3502:

Line 3512: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3508:
3509: IF numeric_result = '0' then /* its numeric so continue */
3510: -- Bank number and branch number should be the same
3511:
3512: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3513:
3514: ELSE
3515: fail_check;
3516: END IF; /* end of numeric check */

Line 3529: cep_standard.debug('<

3525: END IF;
3526:
3527: /*
3528: IF l_DEBUG in ('Y', 'C') THEN
3529: cep_standard.debug('< 3530: END IF;
3531: */
3532: END CE_VALIDATE_BRANCH_IE;
3533:

Line 3579: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_it');

3575: /* MAIN SECTION */
3576: /****************/
3577: BEGIN
3578: IF l_DEBUG in ('Y', 'C') THEN
3579: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_it');
3580: END IF;
3581:
3582: BRANCH_VALUE := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3583:

Line 3616: cep_standard.debug('<

3612: END IF; /* end of length check */
3613: END IF; /* end of mandatory check */
3614: /*
3615: IF l_DEBUG in ('Y', 'C') THEN
3616: cep_standard.debug('< 3617: END IF;
3618: */
3619: END CE_VALIDATE_BRANCH_IT;
3620:

Line 3657: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_lu');

3653: /* MAIN SECTION */
3654: /****************/
3655: BEGIN
3656: IF l_DEBUG in ('Y', 'C') THEN
3657: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_lu');
3658: END IF;
3659:
3660: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3661:

Line 3671: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3667:
3668: IF numeric_result = '0' then /* its numeric so continue */
3669: -- Bank number and branch number should be the same
3670:
3671: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3672:
3673: ELSE
3674: fail_check;
3675: END IF; /* end of numeric check */

Line 3688: cep_standard.debug('<

3684: END IF;
3685:
3686: /*
3687: IF l_DEBUG in ('Y', 'C') THEN
3688: cep_standard.debug('< 3689: END IF;
3690: */
3691:
3692: END CE_VALIDATE_BRANCH_LU;

Line 3732: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_pl');

3728: /* MAIN SECTION */
3729: /****************/
3730: BEGIN
3731: IF l_DEBUG in ('Y', 'C') THEN
3732: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_pl');
3733: END IF;
3734:
3735: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3736:

Line 3747: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3743:
3744: IF numeric_result = '0' then /* its numeric so continue */
3745: -- Bank number and branch number should be the same
3746:
3747: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3748:
3749: -- Modulus 10
3750:
3751: cal_cd1 := 10 - mod(((to_number(substr(BRANCH_NUM,1,1)) * 1)

Line 3783: cep_standard.debug('<

3779: END IF;
3780:
3781: /*
3782: IF l_DEBUG in ('Y', 'C') THEN
3783: cep_standard.debug('< 3784: END IF;
3785: */
3786: END CE_VALIDATE_BRANCH_PL;
3787:

Line 3824: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_se');

3820: /* MAIN SECTION */
3821: /****************/
3822: BEGIN
3823: IF l_DEBUG in ('Y', 'C') THEN
3824: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_se');
3825: END IF;
3826:
3827: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3828:

Line 3838: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3834:
3835: IF numeric_result = '0' then /* its numeric so continue */
3836: -- Bank number and branch number should be the same
3837:
3838: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3839:
3840: ELSE
3841: fail_check;
3842: END IF; /* end of numeric check */

Line 3854: cep_standard.debug('<

3850:
3851: END IF;
3852: /*
3853: IF l_DEBUG in ('Y', 'C') THEN
3854: cep_standard.debug('< 3855: END IF;
3856: */
3857:
3858: END CE_VALIDATE_BRANCH_SE;

Line 3897: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_ch');

3893: /* MAIN SECTION */
3894: /****************/
3895: BEGIN
3896: IF l_DEBUG in ('Y', 'C') THEN
3897: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_ch');
3898: END IF;
3899:
3900: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3901:

Line 3911: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3907:
3908: IF numeric_result = '0' then /* its numeric so continue */
3909: -- Bank number and branch number should be the same
3910:
3911: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3912:
3913: ELSE
3914: IF l_DEBUG in ('Y', 'C') THEN
3915: cep_standard.debug('ce_validate_branch_ch fail numeric check');

Line 3933: cep_standard.debug('<

3929:
3930: END IF;
3931: /*
3932: IF l_DEBUG in ('Y', 'C') THEN
3933: cep_standard.debug('< 3934: END IF;
3935: */
3936:
3937: END CE_VALIDATE_BRANCH_CH;

Line 3975: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_gb');

3971: /* MAIN SECTION */
3972: /****************/
3973: BEGIN
3974: IF l_DEBUG in ('Y', 'C') THEN
3975: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_gb');
3976: END IF;
3977: BRANCH_NUM := upper(replace(Xi_BRANCH_NUMBER,' ',''));
3978:
3979: BRANCH_NUM := replace(BRANCH_NUM,'-','');

Line 3988: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);

3984:
3985: IF numeric_result = '0' then /* its numeric so continue */
3986: -- Bank number and branch number should be the same
3987:
3988: CE_VALIDATE_BANKINFO_UPG.COMPARE_BANK_AND_BRANCH_NUM(branch_num, Xi_BANK_ID);
3989:
3990: ELSE
3991: fail_check;
3992: END IF; /* end of numeric check */

Line 4004: cep_standard.debug('<

4000:
4001: END IF;
4002: /*
4003: IF l_DEBUG in ('Y', 'C') THEN
4004: cep_standard.debug('< 4005: END IF;
4006: */
4007:
4008: END CE_VALIDATE_BRANCH_GB;

Line 4060: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_us');

4056: /* MAIN SECTION */
4057: /****************/
4058: BEGIN
4059: IF l_DEBUG in ('Y', 'C') THEN
4060: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_branch_us');
4061: END IF;
4062:
4063: BRANCH_VALUE := upper(replace(Xi_BRANCH_NUMBER,' ',''));
4064:

Line 4155: cep_standard.debug('<

4151: END IF; /* end of mandatory check */
4152:
4153: /*
4154: IF l_DEBUG in ('Y', 'C') THEN
4155: cep_standard.debug('< 4156: END IF;
4157: */
4158: END CE_VALIDATE_BRANCH_US;
4159:

Line 4590: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_at');

4586: /* MAIN SECTION */
4587: /****************/
4588: BEGIN
4589: IF l_DEBUG in ('Y', 'C') THEN
4590: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_at');
4591: END IF;
4592:
4593: account_value := upper(Xi_ACCOUNT_NUMBER );
4594: Xo_VALUE_OUT := account_value;

Line 4617: cep_standard.debug('<

4613:
4614: END IF; /* end of length check */
4615: /*
4616: IF l_DEBUG in ('Y', 'C') THEN
4617: cep_standard.debug('< 4618: END IF;
4619: */
4620: END CE_VALIDATE_ACCOUNT_AT;
4621:

Line 4660: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_pt');

4656: /* MAIN SECTION */
4657: /****************/
4658: BEGIN
4659: IF l_DEBUG in ('Y', 'C') THEN
4660: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_pt');
4661: END IF;
4662:
4663: ACCOUNT_VALUE := upper(Xi_ACCOUNT_NUMBER );
4664: ACCOUNT_VALUE := replace(ACCOUNT_VALUE,' ','');

Line 4686: cep_standard.debug('<

4682:
4683: END IF; /* end of length check */
4684: /*
4685: IF l_DEBUG in ('Y', 'C') THEN
4686: cep_standard.debug('< 4687: END IF;
4688: */
4689: END CE_VALIDATE_ACCOUNT_PT;
4690:

Line 4731: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_be');

4727: /* MAIN SECTION */
4728: /****************/
4729: BEGIN
4730: IF l_DEBUG in ('Y', 'C') THEN
4731: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_be');
4732: END IF;
4733:
4734: ACCOUNT_VALUE := upper(substr(Xi_ACCOUNT_NUMBER ,1,14));
4735: BANK_CODE := substr(ACCOUNT_VALUE,1,3);

Line 4775: cep_standard.debug('<

4771:
4772: END IF; /* end of length check */
4773: /*
4774: IF l_DEBUG in ('Y', 'C') THEN
4775: cep_standard.debug('< 4776: END IF;
4777: */
4778:
4779: END CE_VALIDATE_ACCOUNT_BE;

Line 4821: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_dk');

4817: /* MAIN SECTION */
4818: /****************/
4819: BEGIN
4820: IF l_DEBUG in ('Y', 'C') THEN
4821: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_dk');
4822: END IF;
4823:
4824: account_value := upper(Xi_ACCOUNT_NUMBER );
4825: Xo_VALUE_OUT := account_value;

Line 4849: cep_standard.debug('<

4845:
4846: END IF; /* end of length check */
4847: /*
4848: IF l_DEBUG in ('Y', 'C') THEN
4849: cep_standard.debug('< 4850: END IF;
4851: */
4852: END CE_VALIDATE_ACCOUNT_DK;
4853:

Line 4892: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_fr');

4888: /* MAIN SECTION */
4889: /****************/
4890: BEGIN
4891: IF l_DEBUG in ('Y', 'C') THEN
4892: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_fr');
4893: END IF;
4894:
4895: ACCOUNT_VALUE := upper(Xi_ACCOUNT_NUMBER );
4896: Xo_VALUE_OUT := ACCOUNT_VALUE;

Line 4922: cep_standard.debug('<

4918: END IF; /* end of length check */
4919:
4920: /*
4921: IF l_DEBUG in ('Y', 'C') THEN
4922: cep_standard.debug('< 4923: END IF;
4924: */
4925: END CE_VALIDATE_ACCOUNT_FR;
4926:

Line 4984: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_nl');

4980: /* MAIN SECTION */
4981: /****************/
4982: BEGIN
4983: IF l_DEBUG in ('Y', 'C') THEN
4984: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_nl');
4985: END IF;
4986:
4987: multiplied_number := 0;
4988: multiplied_sum := 0;

Line 5061: cep_standard.debug('<

5057: END IF;
5058:
5059: /*
5060: IF l_DEBUG in ('Y', 'C') THEN
5061: cep_standard.debug('< 5062: END IF;
5063: */
5064: END CE_VALIDATE_ACCOUNT_NL;
5065:

Line 5109: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_es');

5105: /* MAIN SECTION */
5106: /****************/
5107: BEGIN
5108: IF l_DEBUG in ('Y', 'C') THEN
5109: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_es');
5110: END IF;
5111:
5112: ACCOUNT_VALUE := upper(Xi_ACCOUNT_NUMBER );
5113: Xo_VALUE_OUT := ACCOUNT_VALUE;

Line 5139: cep_standard.debug('<

5135:
5136: END IF; /* end of length check */
5137: /*
5138: IF l_DEBUG in ('Y', 'C') THEN
5139: cep_standard.debug('< 5140: END IF;
5141: */
5142: END CE_VALIDATE_ACCOUNT_ES;
5143:

Line 5184: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_no');

5180: /* MAIN SECTION */
5181: /****************/
5182: BEGIN
5183: IF l_DEBUG in ('Y', 'C') THEN
5184: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_no');
5185: END IF;
5186:
5187: ACCOUNT_VALUE := upper(Xi_ACCOUNT_NUMBER );
5188:

Line 5266: cep_standard.debug('<

5262:
5263: END IF;
5264: /*
5265: IF l_DEBUG in ('Y', 'C') THEN
5266: cep_standard.debug('< 5267: END IF;
5268: */
5269: END CE_VALIDATE_ACCOUNT_NO;
5270:

Line 5312: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_fi');

5308: /* MAIN SECTION */
5309: /****************/
5310: BEGIN
5311: IF l_DEBUG in ('Y', 'C') THEN
5312: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_fi');
5313: END IF;
5314:
5315: ACCOUNT_VALUE := upper(Xi_ACCOUNT_NUMBER );
5316:

Line 5393: cep_standard.debug('<

5389: END IF;
5390: pass_check;
5391: /*
5392: IF l_DEBUG in ('Y', 'C') THEN
5393: cep_standard.debug('< 5394: END IF;
5395: */
5396: END CE_VALIDATE_ACCOUNT_FI;
5397:

Line 5436: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DE');

5432: /* MAIN SECTION */
5433: /****************/
5434: BEGIN
5435: IF l_DEBUG in ('Y', 'C') THEN
5436: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_DE');
5437: END IF;
5438:
5439: account_value := upper(Xi_ACCOUNT_NUMBER );
5440: Xo_VALUE_OUT := account_value;

Line 5465: cep_standard.debug('<

5461: END IF; /* end of length check */
5462:
5463: /*
5464: IF l_DEBUG in ('Y', 'C') THEN
5465: cep_standard.debug('< 5466: END IF;
5467: */
5468: END CE_VALIDATE_ACCOUNT_DE;
5469:

Line 5506: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GR');

5502: /* MAIN SECTION */
5503: /****************/
5504: BEGIN
5505: IF l_DEBUG in ('Y', 'C') THEN
5506: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_ACCOUNT_GR');
5507: END IF;
5508:
5509: account_value := upper(replace(Xi_ACCOUNT_NUMBER,' ',''));
5510: account_value := replace(account_value,'-','');

Line 5537: cep_standard.debug('<

5533:
5534: END IF; /* end of length check */
5535: /*
5536: IF l_DEBUG in ('Y', 'C') THEN
5537: cep_standard.debug('< 5538: END IF;
5539: */
5540: END CE_VALIDATE_ACCOUNT_GR;
5541:

Line 5585: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_is');

5581: /* MAIN SECTION */
5582: /****************/
5583: BEGIN
5584: IF l_DEBUG in ('Y', 'C') THEN
5585: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_is');
5586: END IF;
5587:
5588: ac_value := upper(Xi_ACCOUNT_NUMBER );
5589:

Line 5656: cep_standard.debug('<

5652: fail_check;
5653: END IF; /* end of length check */
5654: /*
5655: IF l_DEBUG in ('Y', 'C') THEN
5656: cep_standard.debug('< 5657: END IF;
5658: */
5659: END CE_VALIDATE_ACCOUNT_IS;
5660:

Line 5695: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_ie');

5691: /* MAIN SECTION */
5692: /****************/
5693: BEGIN
5694: IF l_DEBUG in ('Y', 'C') THEN
5695: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_ie');
5696: END IF;
5697:
5698: account_value := upper(Xi_ACCOUNT_NUMBER );
5699:

Line 5718: cep_standard.debug('<

5714: fail_check;
5715: END IF; /* end of length check */
5716: /*
5717: IF l_DEBUG in ('Y', 'C') THEN
5718: cep_standard.debug('< 5719: END IF;
5720: */
5721: END CE_VALIDATE_ACCOUNT_IE;
5722:

Line 5760: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_it');

5756: /* MAIN SECTION */
5757: /****************/
5758: BEGIN
5759: IF l_DEBUG in ('Y', 'C') THEN
5760: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_it');
5761: END IF;
5762:
5763: account_value := upper(replace(Xi_ACCOUNT_NUMBER,' ',''));
5764: account_value := replace(account_value,'-','');

Line 5781: cep_standard.debug('<

5777:
5778: END IF; /* end of length check */
5779: /*
5780: IF l_DEBUG in ('Y', 'C') THEN
5781: cep_standard.debug('< 5782: END IF;
5783: */
5784: END CE_VALIDATE_ACCOUNT_IT;
5785:

Line 5820: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_lu');

5816: /* MAIN SECTION */
5817: /****************/
5818: BEGIN
5819: IF l_DEBUG in ('Y', 'C') THEN
5820: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_lu');
5821: END IF;
5822:
5823: account_value := upper(Xi_ACCOUNT_NUMBER );
5824:

Line 5843: cep_standard.debug('<

5839: fail_check;
5840: END IF; /* end of length check */
5841: /*
5842: IF l_DEBUG in ('Y', 'C') THEN
5843: cep_standard.debug('< 5844: END IF;
5845: */
5846: END CE_VALIDATE_ACCOUNT_LU;
5847:

Line 5882: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_pl');

5878: /* MAIN SECTION */
5879: /****************/
5880: BEGIN
5881: IF l_DEBUG in ('Y', 'C') THEN
5882: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_pl');
5883: END IF;
5884:
5885: account_value := upper(Xi_ACCOUNT_NUMBER );
5886:

Line 5899: cep_standard.debug('<

5895: fail_check;
5896: END IF; /* end of length check */
5897: /*
5898: IF l_DEBUG in ('Y', 'C') THEN
5899: cep_standard.debug('< 5900: END IF;
5901: */
5902: END CE_VALIDATE_ACCOUNT_PL;
5903:

Line 5938: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_se');

5934: /* MAIN SECTION */
5935: /****************/
5936: BEGIN
5937: IF l_DEBUG in ('Y', 'C') THEN
5938: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_se');
5939: END IF;
5940:
5941: account_value := upper(replace(Xi_ACCOUNT_NUMBER ,' ',''));
5942: account_value := replace(account_value,'-','');

Line 5958: cep_standard.debug('<

5954: fail_check;
5955: END IF; /* end of length check */
5956: /*
5957: IF l_DEBUG in ('Y', 'C') THEN
5958: cep_standard.debug('< 5959: END IF;
5960: */
5961: END CE_VALIDATE_ACCOUNT_SE;
5962:

Line 6009: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_ch');

6005: /* MAIN SECTION */
6006: /****************/
6007: BEGIN
6008: IF l_DEBUG in ('Y', 'C') THEN
6009: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_ch');
6010: END IF;
6011:
6012: account_value := upper(replace(Xi_ACCOUNT_NUMBER,' ',''));
6013:

Line 6031: cep_standard.debug('<

6027: END if;
6028:
6029: /*
6030: IF l_DEBUG in ('Y', 'C') THEN
6031: cep_standard.debug('< 6032: END IF;
6033: */
6034: END CE_VALIDATE_ACCOUNT_CH;
6035:

Line 6071: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_gb');

6067: /* MAIN SECTION */
6068: /****************/
6069: BEGIN
6070: IF l_DEBUG in ('Y', 'C') THEN
6071: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_gb');
6072: END IF;
6073:
6074: Xo_VALUE_OUT := account_value;
6075:

Line 6096: cep_standard.debug('<

6092:
6093: END IF; /* end of length check */
6094: /*
6095: IF l_DEBUG in ('Y', 'C') THEN
6096: cep_standard.debug('< 6097: END IF;
6098: */
6099: END CE_VALIDATE_ACCOUNT_GB;
6100:

Line 6137: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_br');

6133: /****************/
6134: BEGIN
6135:
6136: IF l_DEBUG in ('Y', 'C') THEN
6137: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_br');
6138: END IF;
6139:
6140: account_ref := upper(replace(Xi_SECONDARY_ACCOUNT_REFERENCE,' ',''));
6141:

Line 6167: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_br');

6163:
6164: END IF; /* end of not null check */
6165:
6166: IF l_DEBUG in ('Y', 'C') THEN
6167: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_account_br');
6168: END IF;
6169:
6170: END CE_VALIDATE_ACCOUNT_BR;
6171:

Line 6519: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_es');

6515: /* MAIN SECTION */
6516: /****************/
6517: BEGIN
6518: IF l_DEBUG in ('Y', 'C') THEN
6519: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_es');
6520: END IF;
6521:
6522: BANK_VALUE := upper(Xi_BANK_NUMBER );
6523: Xo_VALUE_OUT := BANK_VALUE;

Line 6556: cep_standard.debug('<

6552: END IF; /* end of length check */
6553: END IF; /* end of mandatory check */
6554: /*
6555: IF l_DEBUG in ('Y', 'C') THEN
6556: cep_standard.debug('< 6557: END IF;
6558: */
6559: END CE_VALIDATE_BANK_ES;
6560:

Line 6610: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_fr');

6606: /* MAIN SECTION */
6607: /****************/
6608: BEGIN
6609: IF l_DEBUG in ('Y', 'C') THEN
6610: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_fr');
6611: END IF;
6612:
6613: BANK_VALUE := upper(Xi_BANK_NUMBER );
6614: Xo_VALUE_OUT := BANK_VALUE;

Line 6647: cep_standard.debug('<

6643: END IF; /* end of length check */
6644: END IF; /* end of mandatory check */
6645: /*
6646: IF l_DEBUG in ('Y', 'C') THEN
6647: cep_standard.debug('< 6648: END IF;
6649: */
6650: END CE_VALIDATE_BANK_FR;
6651:

Line 6698: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pt');

6694: /* MAIN SECTION */
6695: /****************/
6696: BEGIN
6697: IF l_DEBUG in ('Y', 'C') THEN
6698: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pt');
6699: END IF;
6700:
6701:
6702: BANK_VALUE := upper(Xi_BANK_NUMBER );

Line 6731: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pt');

6727:
6728: END IF; /* end of length check */
6729: END IF; /* end of mandatory check */
6730: IF l_DEBUG in ('Y', 'C') THEN
6731: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pt');
6732: END IF;
6733:
6734: END CE_VALIDATE_BANK_PT;
6735:

Line 6782: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_br');

6778: /* MAIN SECTION */
6779: /****************/
6780: BEGIN
6781: IF l_DEBUG in ('Y', 'C') THEN
6782: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_br');
6783: END IF;
6784:
6785: BANK_VALUE := upper(Xi_BANK_NUMBER );
6786: Xo_VALUE_OUT := BANK_VALUE;

Line 6820: cep_standard.debug('<

6816:
6817: END IF; /* end of mandatory check */
6818: /*
6819: IF l_DEBUG in ('Y', 'C') THEN
6820: cep_standard.debug('< 6821: END IF;
6822: */
6823: END CE_VALIDATE_BANK_BR;
6824:

Line 6862: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_de');

6858: /* MAIN SECTION */
6859: /****************/
6860: BEGIN
6861: IF l_DEBUG in ('Y', 'C') THEN
6862: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_de');
6863: END IF;
6864:
6865: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
6866:

Line 6896: cep_standard.debug('<

6892:
6893: END IF; /* end of length check */
6894: /*
6895: IF l_DEBUG in ('Y', 'C') THEN
6896: cep_standard.debug('< 6897: END IF;
6898: */
6899: END CE_VALIDATE_BANK_DE;
6900:

Line 6936: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_gr');

6932: /* MAIN SECTION */
6933: /****************/
6934: BEGIN
6935: IF l_DEBUG in ('Y', 'C') THEN
6936: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_gr');
6937: END IF;
6938:
6939: BANK_VALUE := upper(replace(Xi_BANK_NUMBER,' ',''));
6940:

Line 6968: cep_standard.debug('<

6964:
6965: END IF;
6966: /*
6967: IF l_DEBUG in ('Y', 'C') THEN
6968: cep_standard.debug('< 6969: END IF;
6970: */
6971: END CE_VALIDATE_BANK_GR;
6972:

Line 7009: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_is');

7005: /* MAIN SECTION */
7006: /****************/
7007: BEGIN
7008: IF l_DEBUG in ('Y', 'C') THEN
7009: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_is');
7010: END IF;
7011:
7012: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7013:

Line 7039: cep_standard.debug('<

7035:
7036: END IF;
7037: /*
7038: IF l_DEBUG in ('Y', 'C') THEN
7039: cep_standard.debug('< 7040: END IF;
7041: */
7042: END CE_VALIDATE_BANK_IS;
7043:

Line 7079: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_ie');

7075: /* MAIN SECTION */
7076: /****************/
7077: BEGIN
7078: IF l_DEBUG in ('Y', 'C') THEN
7079: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_ie');
7080: END IF;
7081:
7082: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7083:

Line 7107: cep_standard.debug('<

7103:
7104: END IF;
7105: /*
7106: IF l_DEBUG in ('Y', 'C') THEN
7107: cep_standard.debug('< 7108: END IF;
7109: */
7110: END CE_VALIDATE_BANK_IE;
7111:

Line 7158: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_it');

7154: /* MAIN SECTION */
7155: /****************/
7156: BEGIN
7157: IF l_DEBUG in ('Y', 'C') THEN
7158: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_it');
7159: END IF;
7160:
7161: BANK_VALUE := upper(replace(Xi_BANK_NUMBER,' ',''));
7162:

Line 7198: cep_standard.debug('<

7194: END IF; /* end of mandatory check */
7195:
7196: /*
7197: IF l_DEBUG in ('Y', 'C') THEN
7198: cep_standard.debug('< 7199: END IF;
7200: */
7201: END CE_VALIDATE_BANK_IT;
7202:

Line 7238: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_lu');

7234: /* MAIN SECTION */
7235: /****************/
7236: BEGIN
7237: IF l_DEBUG in ('Y', 'C') THEN
7238: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_lu');
7239: END IF;
7240:
7241: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7242:

Line 7266: cep_standard.debug('<

7262:
7263: END IF;
7264: /*
7265: IF l_DEBUG in ('Y', 'C') THEN
7266: cep_standard.debug('< 7267: END IF;
7268: */
7269: END CE_VALIDATE_BANK_LU;
7270:

Line 7307: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pl');

7303: /* MAIN SECTION */
7304: /****************/
7305: BEGIN
7306: IF l_DEBUG in ('Y', 'C') THEN
7307: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_pl');
7308: END IF;
7309:
7310: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7311:

Line 7355: cep_standard.debug('<

7351:
7352: END IF;
7353: /*
7354: IF l_DEBUG in ('Y', 'C') THEN
7355: cep_standard.debug('< 7356: END IF;
7357: */
7358: END CE_VALIDATE_BANK_PL;
7359:

Line 7395: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_se');

7391: /* MAIN SECTION */
7392: /****************/
7393: BEGIN
7394: IF l_DEBUG in ('Y', 'C') THEN
7395: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_se');
7396: END IF;
7397:
7398: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7399:

Line 7423: cep_standard.debug('<

7419:
7420: END IF;
7421: /*
7422: IF l_DEBUG in ('Y', 'C') THEN
7423: cep_standard.debug('< 7424: END IF;
7425: */
7426: END CE_VALIDATE_BANK_SE;
7427:

Line 7463: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_ch');

7459: /* MAIN SECTION */
7460: /****************/
7461: BEGIN
7462: IF l_DEBUG in ('Y', 'C') THEN
7463: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_ch');
7464: END IF;
7465:
7466: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7467:

Line 7491: cep_standard.debug('<

7487:
7488: END IF;
7489: /*
7490: IF l_DEBUG in ('Y', 'C') THEN
7491: cep_standard.debug('< 7492: END IF;
7493: */
7494: END CE_VALIDATE_BANK_CH;
7495:

Line 7531: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_gb');

7527: /* MAIN SECTION */
7528: /****************/
7529: BEGIN
7530: IF l_DEBUG in ('Y', 'C') THEN
7531: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.ce_validate_bank_gb');
7532: END IF;
7533:
7534: BANK_NUM := upper(replace(Xi_BANK_NUMBER,' ',''));
7535:

Line 7559: cep_standard.debug('<

7555:
7556: END IF;
7557: /*
7558: IF l_DEBUG in ('Y', 'C') THEN
7559: cep_standard.debug('< 7560: END IF;
7561: */
7562: END CE_VALIDATE_BANK_GB;
7563:

Line 7633: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CO');

7629: /****************/
7630: BEGIN
7631:
7632: IF l_DEBUG in ('Y', 'C') THEN
7633: cep_standard.debug('>>CE_VALIDATE_BANKINFO_UPG.CE_VALIDATE_BANK_CO');
7634: END IF;
7635:
7636: -- the last digit of tax payer id is the check digits
7637:

Line 7656: if CE_VALIDATE_BANKINFO_UPG.CE_VAL_UNIQUE_TAX_PAYER_ID(Xi_COUNTRY_NAME,TAX_ID) = 'FALSE' then

7652: numeric_result := ce_check_numeric(tax_id,1,length(tax_id));
7653:
7654: IF numeric_result = '0'
7655: then /* its numeric so continue */
7656: if CE_VALIDATE_BANKINFO_UPG.CE_VAL_UNIQUE_TAX_PAYER_ID(Xi_COUNTRY_NAME,TAX_ID) = 'FALSE' then
7657: IF l_DEBUG in ('Y', 'C') THEN
7658: cep_standard.debug('failed CE_VAL_UNIQUE_TAX_PAYER_ID' );
7659: END IF;
7660: fail_check_unique;

Line 7662: CE_VALIDATE_BANKINFO_UPG.CE_CHECK_CROSS_MODULE_TAX_ID(Xi_COUNTRY_NAME,

7658: cep_standard.debug('failed CE_VAL_UNIQUE_TAX_PAYER_ID' );
7659: END IF;
7660: fail_check_unique;
7661: else
7662: CE_VALIDATE_BANKINFO_UPG.CE_CHECK_CROSS_MODULE_TAX_ID(Xi_COUNTRY_NAME,
7663: Xi_BANK_NAME,
7664: TAX_ID,
7665: l_cust,
7666: l_supp,

Line 7696: IF CE_VALIDATE_BANKINFO_UPG.CE_TAX_ID_CHECK_ALGORITHM(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE' then

7692: --FND_MESSAGE.SET_NAME('JG','JG_ZZ_TAXID_BANK_EXIST_AS_COMP');
7693: FND_MESSAGE.SET_NAME('CE','CE_TAXID_BANK_EXIST_AS_COMP');
7694: fnd_msg_pub.add;
7695: END IF;
7696: IF CE_VALIDATE_BANKINFO_UPG.CE_TAX_ID_CHECK_ALGORITHM(TAX_ID,Xi_COUNTRY_NAME,TAX_ID_CD) = 'FALSE' then
7697: IF l_DEBUG in ('Y', 'C') THEN
7698: cep_standard.debug('failed CE_TAX_ID_CHECK_ALGORITHM' );
7699: END IF;
7700: fail_check;

Line 7719: cep_standard.debug('<

7715: END IF;
7716:
7717: /*
7718: IF l_DEBUG in ('Y', 'C') THEN
7719: cep_standard.debug('< 7720: END IF;
7721: */
7722: END CE_VALIDATE_BANK_CO;
7723:

Line 8310: END CE_VALIDATE_BANKINFO_UPG;

8306: RAISE;
8307:
8308: END CE_VALIDATE_MISC_ACCT_HLDR_ALT;
8309:
8310: END CE_VALIDATE_BANKINFO_UPG;