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.ZX_TRN_VALIDATION_PKG dependencies on ZX_TRN_VALIDATION_PKG

Line 1: package body ZX_TRN_VALIDATION_PKG AS

1: package body ZX_TRN_VALIDATION_PKG AS
2: /* $Header: zxctaxregnb.pls 120.32.12010000.5 2008/12/16 11:36:28 ssanka ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'ZX.PLSQL.ZX_TRN_VALIDATION_PKG.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'ZX.PLSQL.ZX_TRN_VALIDATION_PKG.';
13: -- Logging Infra
14:
15: FUNCTION common_check_numeric(p_check_value IN VARCHAR2,
16: p_from IN NUMBER,

Line 848: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AT(l_trn,

844: --
845: IF (l_country_code = 'AT') THEN -- f3
846: /* if the country name is Austria check the Tax Registration Number */
847: --
848: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AT(l_trn,
849: l_trn_type,
850: l_pass_unique_check,
851: p_return_status,
852: p_error_buffer);

Line 857: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BE(l_trn,

853: --
854: ELSIF (l_country_code = 'BE') THEN
855: /* if the country name is Belgium check the Tax Registration Number */
856: --
857: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BE(l_trn,
858: l_trn_type,
859: l_pass_unique_check,
860: p_return_status,
861: p_error_buffer);

Line 866: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DK(l_trn,

862: --
863: ELSIF (l_country_code= 'DK') THEN
864: /* if the country name is Denmark check the Tax Registration Number */
865: --
866: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DK(l_trn,
867: l_trn_type,
868: l_pass_unique_check,
869: p_return_status,
870: p_error_buffer);

Line 875: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_EE(l_trn,

871: --
872: ELSIF (l_country_code = 'EE') THEN
873: /* if the country name is Estonia check the Tax Registration Number */
874: --
875: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_EE(l_trn,
876: l_trn_type,
877: l_pass_unique_check,
878: p_return_status,
879: p_error_buffer);

Line 884: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FI(l_trn,

880: --
881: ELSIF (l_country_code = 'FI') THEN
882: /* if the country name is Finland check the Tax Registration Number */
883: --
884: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FI(l_trn,
885: l_trn_type,
886: l_pass_unique_check,
887: p_return_status,
888: p_error_buffer);

Line 893: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FR(l_trn,

889: --
890: ELSIF (l_country_code = 'FR') THEN
891: /* if the country name is France check the Tax Registration Number */
892: --
893: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FR(l_trn,
894: l_trn_type,
895: l_pass_unique_check,
896: p_return_status,
897: p_error_buffer);

Line 902: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DE(l_trn,

898: --
899: ELSIF (l_country_code = 'DE') THEN
900: /* if the country name is Germany check the Tax Registration Number */
901: --
902: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DE(l_trn,
903: l_trn_type,
904: l_pass_unique_check,
905: p_return_status,
906: p_error_buffer);

Line 911: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GR(l_trn,

907: --
908: ELSIF (l_country_code = 'GR') THEN
909: /* if the country name is GREECE check the Tax Registration Number */
910: --
911: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GR(l_trn,
912: l_trn_type,
913: l_pass_unique_check,
914: p_return_status,
915: p_error_buffer);

Line 920: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IE(l_trn,

916: --
917: ELSIF (l_country_code = 'IE') THEN
918: /* if the country name is IRELAND check the Tax Registration Number */
919: --
920: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IE(l_trn,
921: l_trn_type,
922: l_pass_unique_check,
923: p_return_status,
924: p_error_buffer);

Line 929: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IT(l_trn,

925: --
926: ELSIF (l_country_code = 'IT') THEN
927: /* if the country name is Italy check the Tax Registration Number */
928: --
929: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IT(l_trn,
930: l_trn_type,
931: l_pass_unique_check,
932: p_return_status,
933: p_error_buffer);

Line 938: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LU(l_trn,

934: --
935: ELSIF (l_country_code = 'LU') THEN
936: /* if the country name is Luxembourg check the Tax Registration Number */
937: --
938: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LU(l_trn,
939: l_trn_type,
940: l_pass_unique_check,
941: p_return_status,
942: p_error_buffer);

Line 947: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_NL(l_trn,

943: --
944: ELSIF (l_country_code = 'NL') THEN
945: /* if the country name is Netherlands check the Tax Registration Number */
946: --
947: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_NL(l_trn,
948: l_trn_type,
949: l_pass_unique_check,
950: p_return_status,
951: p_error_buffer);

Line 956: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PL(l_trn,

952: --
953: ELSIF (l_country_code = 'PL') THEN
954: /* if the country name is Poland check the Tax Registration Number */
955: --
956: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PL(l_trn,
957: l_trn_type,
958: l_pass_unique_check,
959: p_return_status,
960: p_error_buffer);

Line 965: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PT(l_trn,

961: --
962: ELSIF (l_country_code = 'PT') THEN
963: /* if the country name is Portugal check the Tax Registration Number */
964: --
965: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PT(l_trn,
966: l_trn_type,
967: l_pass_unique_check,
968: p_return_status,
969: p_error_buffer);

Line 974: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SK(l_trn,

970: --
971: ELSIF (l_country_code = 'SK') THEN
972: /* if the country name is Slovakia check the Tax Registration Number */
973: --
974: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SK(l_trn,
975: l_trn_type,
976: l_pass_unique_check,
977: p_return_status,
978: p_error_buffer);

Line 983: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_ES(l_trn,

979: --
980: ELSIF (l_country_code = 'ES') THEN
981: /* if the country name is Spain check the Tax Registration Number */
982: --
983: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_ES(l_trn,
984: l_trn_type,
985: l_pass_unique_check,
986: p_return_status,
987: p_error_buffer);

Line 992: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SE(l_trn,

988: --
989: ELSIF (l_country_code = 'SE') THEN
990: /* if the country name is Sweden check the Tax Registration Number */
991: --
992: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SE(l_trn,
993: l_trn_type,
994: l_pass_unique_check,
995: p_return_status,
996: p_error_buffer);

Line 1001: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CH(l_trn,

997: --
998: ELSIF (l_country_code = 'CH') THEN
999: /* if the country name is Swizerland check the Tax Registration Number */
1000: --
1001: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CH(l_trn,
1002: l_trn_type,
1003: l_pass_unique_check,
1004: p_return_status,
1005: p_error_buffer);

Line 1010: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GB(l_trn,

1006: --
1007: ELSIF (l_country_code = 'GB') THEN
1008: /* if the country name is United Kingdom check the Tax Registration Number */
1009: --
1010: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GB(l_trn,
1011: l_trn_type,
1012: l_pass_unique_check,
1013: p_return_status,
1014: p_error_buffer);

Line 1019: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_RU(l_trn,

1015: --
1016: ELSIF (l_country_code = 'RU') THEN
1017: /* if the country name is Russia check the Tax Registration Number */
1018: --
1019: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_RU(l_trn,
1020: l_trn_type,
1021: l_pass_unique_check,
1022: p_return_status,
1023: p_error_buffer);

Line 1028: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_HU(l_trn,

1024: --
1025: ELSIF (l_country_code = 'HU') THEN
1026: /* if the country name is Hungary check the Tax Registration Number */
1027: --
1028: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_HU(l_trn,
1029: l_trn_type,
1030: l_pass_unique_check,
1031: p_return_status,
1032: p_error_buffer);

Line 1037: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AR(l_trn,

1033: --
1034: ELSIF (l_country_code = 'AR') THEN
1035: /* if the country name is Argentina check the Tax Registration Number */
1036: --
1037: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AR(l_trn,
1038: l_trn_type,
1039: p_return_status,
1040: p_error_buffer);
1041: --

Line 1045: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CL(l_trn,

1041: --
1042: ELSIF (l_country_code = 'CL') THEN
1043: /* if the country name is Chile check the Tax Registration Number */
1044: --
1045: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CL(l_trn,
1046: p_return_status,
1047: p_error_buffer);
1048: --
1049: ELSIF (l_country_code = 'CO') THEN

Line 1052: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CO(l_trn,

1048: --
1049: ELSIF (l_country_code = 'CO') THEN
1050: /* if the country name is Colombia check the Tax Registration Number */
1051: --
1052: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CO(l_trn,
1053: p_return_status,
1054: p_error_buffer);
1055: --
1056: ELSIF (l_country_code = 'TW') THEN

Line 1059: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_TW(l_trn,

1055: --
1056: ELSIF (l_country_code = 'TW') THEN
1057: /* if the country name is Taiwan check the Tax Registration Number */
1058: --
1059: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_TW(l_trn,
1060: p_return_status,
1061: p_error_buffer);
1062: --
1063: ELSIF (l_country_code = 'BR') THEN

Line 1066: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BR(l_trn,

1062: --
1063: ELSIF (l_country_code = 'BR') THEN
1064: /* if the country name is Brazil check the Tax Registration Number */
1065: --
1066: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BR(l_trn,
1067: l_trn_type,
1068: p_return_status,
1069: p_error_buffer);
1070: --

Line 1074: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_MT(l_trn,

1070: --
1071: ELSIF (l_country_code = 'MT') THEN
1072: /* if the country name is Malta check the Tax Registration Number */
1073: --
1074: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_MT(l_trn,
1075: l_trn_type,
1076: l_pass_unique_check,
1077: p_return_status,
1078: p_error_buffer);

Line 1083: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CY(l_trn,

1079: --
1080: ELSIF (l_country_code = 'CY') THEN
1081: /* if the country name is Cyprus check the Tax Registration Number */
1082: --
1083: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CY(l_trn,
1084: l_trn_type,
1085: l_pass_unique_check,
1086: p_return_status,
1087: p_error_buffer);

Line 1092: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LV(l_trn,

1088: --
1089: ELSIF (l_country_code = 'LV') THEN
1090: /* if the country name is Latvia check the Tax Registration Number */
1091: --
1092: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LV(l_trn,
1093: l_trn_type,
1094: l_pass_unique_check,
1095: p_return_status,
1096: p_error_buffer);

Line 1101: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LT(l_trn,

1097: --
1098: ELSIF (l_country_code = 'LT') THEN
1099: /* if the country name is Lithuania check the Tax Registration Number */
1100: --
1101: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LT(l_trn,
1102: l_trn_type,
1103: l_pass_unique_check,
1104: p_return_status,
1105: p_error_buffer);

Line 1110: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SI(l_trn,

1106: --
1107: ELSIF (l_country_code = 'SI') THEN
1108: /* if the country name is Slovenia check the Tax Registration Number */
1109: --
1110: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SI(l_trn,
1111: l_trn_type,
1112: l_pass_unique_check,
1113: p_return_status,
1114: p_error_buffer);

Line 6046: END ZX_TRN_VALIDATION_PKG;

6042:
6043: /* *********** End VALIDATE_TRN_CY ****************** */
6044:
6045:
6046: END ZX_TRN_VALIDATION_PKG;