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_BANK_AND_ACCOUNT_VALIDATION dependencies on CEP_STANDARD

Line 185: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank (+)');

181: AND BankParty.party_id <> p_temp_id;
182: */
183:
184: BEGIN
185: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_bank (+)');
186:
187: /***** Fetching the bank country *****/
188: OPEN c_country;
189: FETCH c_country INTO l_country;

Line 400: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_org (+)');

396: l_pos NUMBER;
397: l_org_id_str VARCHAR2(30);
398: l_found VARCHAR2(1);
399: BEGIN
400: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_org (+)');
401: x_out := 1;
402: l_found := 'N';
403:
404: l_org_list := MO_UTILS.get_org_list(p_security_profile_id, p_org_classification);

Line 462: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');

458: FROM fnd_currencies fc
459: WHERE fc.currency_code = p_currency_code;
460: l_dummy NUMBER := 0;
461: BEGIN
462: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_currency (+)');
463:
464: -- initialize API return status to success.
465: x_return_status := fnd_api.g_ret_sts_success;
466:

Line 512: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');

508: AND bank_account_id <> NVL(p_account_id, -1);
509: --AND (rowid <> l_rowid OR l_rowid IS NULL);
510:
511: BEGIN
512: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_name (+)');
513:
514: -- initialize API return status to success.
515: x_return_status := fnd_api.g_ret_sts_success;
516: /*

Line 568: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');

564: l_str1_2 VARCHAR2(4);
565: l_str3_4 VARCHAR2(40);
566: new_IBAN VARCHAR2(100);
567: BEGIN
568: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_IBAN (+)');
569:
570: -- initialize API return status to success.
571: x_return_status := fnd_api.g_ret_sts_success;
572:

Line 579: cep_standard.debug('p_IBAN='||p_IBAN);

575:
576: new_IBAN :=rtrim(ltrim(p_IBAN,' '),' ');
577: p_IBAN_OUT := null;
578:
579: cep_standard.debug('p_IBAN='||p_IBAN);
580: cep_standard.debug('new_IBAN='||new_IBAN);
581: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
582:
583: l_var := '9';

Line 580: cep_standard.debug('new_IBAN='||new_IBAN);

576: new_IBAN :=rtrim(ltrim(p_IBAN,' '),' ');
577: p_IBAN_OUT := null;
578:
579: cep_standard.debug('p_IBAN='||p_IBAN);
580: cep_standard.debug('new_IBAN='||new_IBAN);
581: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
582:
583: l_var := '9';
584: l_len := LENGTH(new_IBAN);

Line 581: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);

577: p_IBAN_OUT := null;
578:
579: cep_standard.debug('p_IBAN='||p_IBAN);
580: cep_standard.debug('new_IBAN='||new_IBAN);
581: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
582:
583: l_var := '9';
584: l_len := LENGTH(new_IBAN);
585:

Line 592: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');

588: IF l_len > 34 THEN
589: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
590: fnd_msg_pub.add;
591: x_return_status := fnd_api.g_ret_sts_error;
592: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
593: END IF;
594:
595: -- step 3
596: -- bug 4350134

Line 602: cep_standard.debug('l_str1_2='||l_str1_2);

598: -- 2) The third and fourth characters are numbers
599: l_str1_2 := SUBSTR(new_IBAN, 1, 2);
600: l_str3_4 := upper(SUBSTR(new_IBAN, 3, 2));
601:
602: cep_standard.debug('l_str1_2='||l_str1_2);
603: cep_standard.debug('l_str3_4='||l_str3_4);
604:
605: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

Line 603: cep_standard.debug('l_str3_4='||l_str3_4);

599: l_str1_2 := SUBSTR(new_IBAN, 1, 2);
600: l_str3_4 := upper(SUBSTR(new_IBAN, 3, 2));
601:
602: cep_standard.debug('l_str1_2='||l_str1_2);
603: cep_standard.debug('l_str3_4='||l_str3_4);
604:
605: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
607: fnd_msg_pub.add;

Line 609: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str1_2= '||l_str1_2);

605: IF (TRANSLATE(l_str1_2, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', '99999999999999999999999999') <> '99') THEN
606: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
607: fnd_msg_pub.add;
608: x_return_status := fnd_api.g_ret_sts_error;
609: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str1_2= '||l_str1_2);
610: END IF;
611:
612: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN
613: fnd_message.set_name('CE', 'CE_INVALID_IBAN');

Line 616: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str3_4= '||l_str3_4);

612: IF (TRANSLATE(l_str3_4, '0123456789', '9999999999') <> '99') THEN
613: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
614: fnd_msg_pub.add;
615: x_return_status := fnd_api.g_ret_sts_error;
616: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN l_str3_4= '||l_str3_4);
617: END IF;
618:
619: --
620: IF TRANSLATE(new_IBAN, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',

Line 626: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_FORMAT');

622: <> RPAD(l_var, l_len, '9') THEN
623: fnd_message.set_name('CE', 'CE_INVALID_IBAN_FORMAT');
624: fnd_msg_pub.add;
625: x_return_status := fnd_api.g_ret_sts_error;
626: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN_FORMAT');
627: ELSE
628: --
629: l_temp1 := SUBSTR(new_IBAN, 1, 4);
630: l_temp2 := SUBSTR(new_IBAN, 5, l_len);

Line 652: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');

648: IF l_mod <> 1 THEN
649: fnd_message.set_name('CE', 'CE_INVALID_IBAN');
650: fnd_msg_pub.add;
651: x_return_status := fnd_api.g_ret_sts_error;
652: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
653: ELSE
654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562
655: cep_standard.debug('new_IBAN <> p_IBAN');
656: p_IBAN_OUT := new_IBAN;

Line 655: cep_standard.debug('new_IBAN <> p_IBAN');

651: x_return_status := fnd_api.g_ret_sts_error;
652: cep_standard.debug('validate_IBAN: CE_INVALID_IBAN');
653: ELSE
654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562
655: cep_standard.debug('new_IBAN <> p_IBAN');
656: p_IBAN_OUT := new_IBAN;
657: cep_standard.debug('p_IBAN='||p_IBAN);
658: cep_standard.debug('new_IBAN='||new_IBAN);
659: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);

Line 657: cep_standard.debug('p_IBAN='||p_IBAN);

653: ELSE
654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562
655: cep_standard.debug('new_IBAN <> p_IBAN');
656: p_IBAN_OUT := new_IBAN;
657: cep_standard.debug('p_IBAN='||p_IBAN);
658: cep_standard.debug('new_IBAN='||new_IBAN);
659: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
660: -- END IF;
661: END IF;

Line 658: cep_standard.debug('new_IBAN='||new_IBAN);

654: -- IF (new_IBAN <> p_IBAN) then Bug 6658562
655: cep_standard.debug('new_IBAN <> p_IBAN');
656: p_IBAN_OUT := new_IBAN;
657: cep_standard.debug('p_IBAN='||p_IBAN);
658: cep_standard.debug('new_IBAN='||new_IBAN);
659: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
660: -- END IF;
661: END IF;
662: END IF;

Line 659: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);

655: cep_standard.debug('new_IBAN <> p_IBAN');
656: p_IBAN_OUT := new_IBAN;
657: cep_standard.debug('p_IBAN='||p_IBAN);
658: cep_standard.debug('new_IBAN='||new_IBAN);
659: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
660: -- END IF;
661: END IF;
662: END IF;
663:

Line 664: cep_standard.debug('end');

660: -- END IF;
661: END IF;
662: END IF;
663:
664: cep_standard.debug('end');
665:
666: cep_standard.debug('p_IBAN='||p_IBAN);
667: cep_standard.debug('new_IBAN='||new_IBAN);
668: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);

Line 666: cep_standard.debug('p_IBAN='||p_IBAN);

662: END IF;
663:
664: cep_standard.debug('end');
665:
666: cep_standard.debug('p_IBAN='||p_IBAN);
667: cep_standard.debug('new_IBAN='||new_IBAN);
668: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
669:
670: END validate_IBAN;

Line 667: cep_standard.debug('new_IBAN='||new_IBAN);

663:
664: cep_standard.debug('end');
665:
666: cep_standard.debug('p_IBAN='||p_IBAN);
667: cep_standard.debug('new_IBAN='||new_IBAN);
668: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
669:
670: END validate_IBAN;
671:

Line 668: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);

664: cep_standard.debug('end');
665:
666: cep_standard.debug('p_IBAN='||p_IBAN);
667: cep_standard.debug('new_IBAN='||new_IBAN);
668: cep_standard.debug('p_IBAN_OUT='||p_IBAN_OUT);
669:
670: END validate_IBAN;
671:
672: /*=======================================================================+

Line 692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

688: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
689:
690:
691: BEGIN
692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
693: -- initialize API return status to success.
694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);

Line 696: cep_standard.debug('p_ap='||p_ap);

692: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
693: -- initialize API return status to success.
694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);
697: cep_standard.debug('p_ar='||p_ar);
698: cep_standard.debug('p_pay='||p_pay);
699: cep_standard.debug('p_xtr='||p_xtr);
700:

Line 697: cep_standard.debug('p_ar='||p_ar);

693: -- initialize API return status to success.
694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);
697: cep_standard.debug('p_ar='||p_ar);
698: cep_standard.debug('p_pay='||p_pay);
699: cep_standard.debug('p_xtr='||p_xtr);
700:
701:

Line 698: cep_standard.debug('p_pay='||p_pay);

694: x_return_status := fnd_api.g_ret_sts_success;
695:
696: cep_standard.debug('p_ap='||p_ap);
697: cep_standard.debug('p_ar='||p_ar);
698: cep_standard.debug('p_pay='||p_pay);
699: cep_standard.debug('p_xtr='||p_xtr);
700:
701:
702: IF (p_ap IS NULL OR p_ap = 'N') AND

Line 699: cep_standard.debug('p_xtr='||p_xtr);

695:
696: cep_standard.debug('p_ap='||p_ap);
697: cep_standard.debug('p_ar='||p_ar);
698: cep_standard.debug('p_pay='||p_pay);
699: cep_standard.debug('p_xtr='||p_xtr);
700:
701:
702: IF (p_ap IS NULL OR p_ap = 'N') AND
703: (p_ar IS NULL OR p_ar = 'N') AND

Line 737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

733: p_xtr IN VARCHAR2,
734: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
735:
736: BEGIN
737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
738: -- initialize API return status to success.
739: x_return_status := fnd_api.g_ret_sts_success;
740: cep_standard.debug('p_short_account_name='||p_short_account_name);
741: cep_standard.debug('p_xtr='||p_xtr);

Line 740: cep_standard.debug('p_short_account_name='||p_short_account_name);

736: BEGIN
737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
738: -- initialize API return status to success.
739: x_return_status := fnd_api.g_ret_sts_success;
740: cep_standard.debug('p_short_account_name='||p_short_account_name);
741: cep_standard.debug('p_xtr='||p_xtr);
742:
743:
744: IF (p_short_account_name IS NULL) AND (p_xtr IS NOT NULL) AND (p_xtr <> 'N') THEN

Line 741: cep_standard.debug('p_xtr='||p_xtr);

737: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
738: -- initialize API return status to success.
739: x_return_status := fnd_api.g_ret_sts_success;
740: cep_standard.debug('p_short_account_name='||p_short_account_name);
741: cep_standard.debug('p_xtr='||p_xtr);
742:
743:
744: IF (p_short_account_name IS NULL) AND (p_xtr IS NOT NULL) AND (p_xtr <> 'N') THEN
745: fnd_message.set_name('CE', 'CE_SHORT_ACCOUNT_NAME_REQUIRED');

Line 775: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');

771: p_end_date IN DATE,
772: x_return_status IN OUT NOCOPY VARCHAR2) IS
773:
774: BEGIN
775: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_end_date (+)');
776: -- initialize API return status to success.
777: x_return_status := fnd_api.g_ret_sts_success;
778:
779:

Line 883: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type (+)');

879:
880: BEGIN
881:
882: BEGIN
883: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type (+)');
884:
885: --/* 1/13/05 no bg
886: OPEN bg;
887:

Line 889: cep_standard.debug('bg_org='||bg_org);

885: --/* 1/13/05 no bg
886: OPEN bg;
887:
888: FETCH bg INTO bg_org;
889: cep_standard.debug('bg_org='||bg_org);
890: IF bg%NOTFOUND THEN
891: bg_org := null;
892: END IF;
893: CLOSE bg;

Line 899: cep_standard.debug('le_org='||le_org);

895:
896: /* 3/24/05 no le
897: OPEN le;
898: FETCH le INTO le_org;
899: cep_standard.debug('le_org='||le_org);
900: IF le%NOTFOUND THEN
901: le_org := null;
902: END IF;
903: CLOSE le;

Line 907: cep_standard.debug('ou_org='||ou_org);

903: CLOSE le;
904: */
905: OPEN ou;
906: FETCH ou INTO ou_org;
907: cep_standard.debug('ou_org='||ou_org);
908: IF ou%NOTFOUND THEN
909: ou_org := null;
910: END IF;
911: CLOSE ou;

Line 919: cep_standard.debug('org_type='||org_type);

915: org_type1 := bg_org || ou_org;
916:
917: org_type := substr(org_type1,1,(length(org_type1)-2));
918:
919: cep_standard.debug('org_type='||org_type);
920:
921: EXCEPTION
922: WHEN no_data_found THEN
923: org_type := NULL;

Line 931: cep_standard.debug('EXCEPTION: Get_Org_Type');

927: RETURN org_type;
928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: cep_standard.debug('EXCEPTION: Get_Org_Type');
932: RAISE;
933: END Get_Org_Type;
934:
935:

Line 967: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code (+)');

963: AND organization_id = p_org_id;
964:
965: BEGIN
966: BEGIN
967: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code (+)');
968:
969: OPEN bg;
970:
971: FETCH bg INTO bg_org;

Line 972: cep_standard.debug('bg_org='||bg_org);

968:
969: OPEN bg;
970:
971: FETCH bg INTO bg_org;
972: cep_standard.debug('bg_org='||bg_org);
973: IF bg%NOTFOUND THEN
974: bg_org := null;
975: END IF;
976: CLOSE bg;

Line 980: cep_standard.debug('ou_org='||ou_org);

976: CLOSE bg;
977:
978: OPEN ou;
979: FETCH ou INTO ou_org;
980: cep_standard.debug('ou_org='||ou_org);
981: IF ou%NOTFOUND THEN
982: ou_org := null;
983: END IF;
984: CLOSE ou;

Line 990: cep_standard.debug('org_type='||org_type);

986: org_type := bg_org || ou_org;
987:
988: --org_type := substr(org_type1,1,(length(org_type1)-2));
989:
990: cep_standard.debug('org_type='||org_type);
991:
992: EXCEPTION
993: WHEN no_data_found THEN
994: org_type := NULL;

Line 1002: cep_standard.debug('EXCEPTION: Get_Org_Type_Code');

998: RETURN org_type;
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: cep_standard.debug('EXCEPTION: Get_Org_Type_Code');
1003: RAISE;
1004: END Get_Org_Type_Code;
1005:
1006:

Line 1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');

1035:
1036: org_type VARCHAR2(240);
1037:
1038: BEGIN
1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);

Line 1043: cep_standard.debug('p_ap='||p_ap);

1039: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_account_use (+)');
1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);
1046: cep_standard.debug('p_xtr='||p_xtr);
1047: cep_standard.debug('p_org_id='||p_org_id);

Line 1044: cep_standard.debug('p_ar='||p_ar);

1040: -- initialize API return status to success.
1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);
1046: cep_standard.debug('p_xtr='||p_xtr);
1047: cep_standard.debug('p_org_id='||p_org_id);
1048:

Line 1045: cep_standard.debug('p_pay='||p_pay);

1041: x_return_status := fnd_api.g_ret_sts_success;
1042:
1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);
1046: cep_standard.debug('p_xtr='||p_xtr);
1047: cep_standard.debug('p_org_id='||p_org_id);
1048:
1049: /*// orgType: LE - Legal Entity

Line 1046: cep_standard.debug('p_xtr='||p_xtr);

1042:
1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);
1046: cep_standard.debug('p_xtr='||p_xtr);
1047: cep_standard.debug('p_org_id='||p_org_id);
1048:
1049: /*// orgType: LE - Legal Entity
1050: // BG - Business Group

Line 1047: cep_standard.debug('p_org_id='||p_org_id);

1043: cep_standard.debug('p_ap='||p_ap);
1044: cep_standard.debug('p_ar='||p_ar);
1045: cep_standard.debug('p_pay='||p_pay);
1046: cep_standard.debug('p_xtr='||p_xtr);
1047: cep_standard.debug('p_org_id='||p_org_id);
1048:
1049: /*// orgType: LE - Legal Entity
1050: // BG - Business Group
1051: // OU - Operating Unit

Line 1193: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_country.');

1189: WHERE ft.territory_code = p_country_code;
1190: l_dummy NUMBER(1) := 0;
1191: BEGIN
1192: IF l_DEBUG in ('Y', 'C') THEN
1193: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_country.');
1194: END IF;
1195:
1196: OPEN c_country;
1197: FETCH c_country INTO l_dummy;

Line 1206: cep_standard.debug('<

1202: END IF;
1203: CLOSE c_country;
1204:
1205: IF l_DEBUG in ('Y', 'C') THEN
1206: cep_standard.debug('< 1207: END IF;
1208: END validate_country;
1209:
1210: /*=======================================================================+

Line 1254: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');

1250: p_cur varchar2(5);
1251: p_ap_def number;
1252: p_xtr_def number;
1253: BEGIN
1254: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.validate_def_settlement');
1255: -- initialize API return status to success.
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1263: cep_standard.debug(' P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);

1259: IF FND_API.to_Boolean(p_init_msg_list) THEN
1260: FND_MSG_PUB.initialize;
1261: END IF;
1262: IF l_DEBUG in ('Y', 'C') THEN
1263: cep_standard.debug(' P_INIT_MSG_LIST: '|| P_INIT_MSG_LIST);
1264: END IF;
1265:
1266: IF (p_bank_account_id is not null) then
1267: select currency_code into p_cur

Line 1324: cep_standard.debug(' P_COUNT: '|| x_msg_count);

1320: IF x_msg_count > 0 THEN
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: END IF;
1323: --IF l_DEBUG in ('Y', 'C') THEN
1324: cep_standard.debug(' P_COUNT: '|| x_msg_count);
1325:
1326:
1327: cep_standard.debug('< 1328: --END IF;

Line 1327: cep_standard.debug('<

1323: --IF l_DEBUG in ('Y', 'C') THEN
1324: cep_standard.debug(' P_COUNT: '|| x_msg_count);
1325:
1326:
1327: cep_standard.debug('< 1328: --END IF;
1329:
1330: EXCEPTION
1331: WHEN OTHERS THEN

Line 1433: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');

1429: AND NVL(org_id, legal_entity_id) = p_org_le_id
1430: AND bank_acct_use_id <> NVL(p_acct_use_id, -1);
1431:
1432: BEGIN
1433: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.validate_unique_org_access(+)');
1434:
1435: -- initialize API return status to success.
1436: x_return_status := fnd_api.g_ret_sts_success;
1437:

Line 1486: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');

1482: p_pay_doc_count number;
1483: p_ap_doc_cat_count number;
1484:
1485: BEGIN
1486: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1487: cep_standard.debug('P_PAYMENT_DOCUMENT_ID=' ||P_PAYMENT_DOCUMENT_ID
1488: ||', P_PAYMENT_METHOD_CODE='||P_PAYMENT_METHOD_CODE
1489: ||', P_BANK_ACCT_USE_ID='||P_BANK_ACCT_USE_ID );
1490:

Line 1487: cep_standard.debug('P_PAYMENT_DOCUMENT_ID=' ||P_PAYMENT_DOCUMENT_ID

1483: p_ap_doc_cat_count number;
1484:
1485: BEGIN
1486: cep_standard.debug('>>CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');
1487: cep_standard.debug('P_PAYMENT_DOCUMENT_ID=' ||P_PAYMENT_DOCUMENT_ID
1488: ||', P_PAYMENT_METHOD_CODE='||P_PAYMENT_METHOD_CODE
1489: ||', P_BANK_ACCT_USE_ID='||P_BANK_ACCT_USE_ID );
1490:
1491: P_PAYMENT_DOC_CATEGORY_CODE := '-1';

Line 1498: cep_standard.debug('p_pay_doc_count='||p_pay_doc_count );

1494: select count(*) into p_pay_doc_count
1495: from ce_payment_documents
1496: where PAYMENT_DOCUMENT_ID = P_PAYMENT_DOCUMENT_ID;
1497:
1498: cep_standard.debug('p_pay_doc_count='||p_pay_doc_count );
1499:
1500: if (p_pay_doc_count = 1) then
1501: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1502: into P_PAYMENT_DOC_CATEGORY_CODE

Line 1510: cep_standard.debug('ce_payment_documents P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1506: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1507: end if;
1508: END IF;
1509:
1510: cep_standard.debug('ce_payment_documents P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1511:
1512: IF (P_PAYMENT_DOC_CATEGORY_CODE = '-1') THEN
1513: IF (P_PAYMENT_METHOD_CODE is not null and P_BANK_ACCT_USE_ID is not null) THEN
1514: select count(*) into p_ap_doc_cat_count

Line 1529: cep_standard.debug('ce_ap_pm_doc_categories P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1525: else
1526: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1527: end if;
1528:
1529: cep_standard.debug('ce_ap_pm_doc_categories P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1530:
1531: END IF;
1532: END IF;
1533:

Line 1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1537: select nvl(PAYMENT_DOC_CATEGORY, '-1')
1538: into P_PAYMENT_DOC_CATEGORY_CODE
1539: from ce_bank_acct_uses_all
1540: where BANK_ACCT_USE_ID = P_BANK_ACCT_USE_ID;
1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1542: END IF;
1543: END IF;
1544:
1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

Line 1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );

1541: cep_standard.debug('ce_bank_acct_uses_all P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1542: END IF;
1543: END IF;
1544:
1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1546:
1547: cep_standard.debug('< 1548:
1549: EXCEPTION

Line 1547: cep_standard.debug('<

1543: END IF;
1544:
1545: cep_standard.debug('P_PAYMENT_DOC_CATEGORY_CODE='||P_PAYMENT_DOC_CATEGORY_CODE );
1546:
1547: cep_standard.debug('< 1548:
1549: EXCEPTION
1550: WHEN NO_DATA_FOUND THEN
1551: cep_standard.debug('no data found');

Line 1551: cep_standard.debug('no data found');

1547: cep_standard.debug('< 1548:
1549: EXCEPTION
1550: WHEN NO_DATA_FOUND THEN
1551: cep_standard.debug('no data found');
1552: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1553: WHEN TOO_MANY_ROWS THEN
1554: cep_standard.debug('too_many_rows');
1555: P_PAYMENT_DOC_CATEGORY_CODE := '-1';

Line 1554: cep_standard.debug('too_many_rows');

1550: WHEN NO_DATA_FOUND THEN
1551: cep_standard.debug('no data found');
1552: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1553: WHEN TOO_MANY_ROWS THEN
1554: cep_standard.debug('too_many_rows');
1555: P_PAYMENT_DOC_CATEGORY_CODE := '-1';
1556: WHEN OTHERS THEN
1557: FND_MESSAGE.Set_Name('CE', 'CE_UNHANDLED_EXCEPTION');
1558: FND_MESSAGE.Set_Token('PROCEDURE', 'CE_BANK_AND_ACCOUNT_VALIDATION.get_pay_doc_cat');

Line 1603: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code_isetup (+)');

1599: and oi.organization_id = p_org_id;
1600:
1601: BEGIN
1602: BEGIN
1603: cep_standard.debug('CE_BANK_AND_ACCOUNT_VALIDATION.get_org_type_code_isetup (+)');
1604:
1605: OPEN bg;
1606:
1607: FETCH bg INTO bg_org;

Line 1608: cep_standard.debug('bg_org='||bg_org);

1604:
1605: OPEN bg;
1606:
1607: FETCH bg INTO bg_org;
1608: cep_standard.debug('bg_org='||bg_org);
1609: IF bg%NOTFOUND THEN
1610: bg_org := null;
1611: END IF;
1612: CLOSE bg;

Line 1616: cep_standard.debug('ou_org='||ou_org);

1612: CLOSE bg;
1613:
1614: OPEN ou;
1615: FETCH ou INTO ou_org;
1616: cep_standard.debug('ou_org='||ou_org);
1617: IF ou%NOTFOUND THEN
1618: ou_org := null;
1619: END IF;
1620: CLOSE ou;

Line 1624: cep_standard.debug('org_type='||org_type);

1620: CLOSE ou;
1621:
1622: org_type := bg_org || ou_org;
1623:
1624: cep_standard.debug('org_type='||org_type);
1625:
1626: EXCEPTION
1627: WHEN no_data_found THEN
1628: org_type := NULL;

Line 1636: cep_standard.debug('EXCEPTION: Get_Org_Type_Code_Isetup');

1632: RETURN org_type;
1633:
1634: EXCEPTION
1635: WHEN OTHERS THEN
1636: cep_standard.debug('EXCEPTION: Get_Org_Type_Code_Isetup');
1637: RAISE;
1638: END Get_Org_Type_Code_Isetup;
1639:
1640: END CE_BANK_AND_ACCOUNT_VALIDATION;