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_MIGRATE_REP_ENTITIES_PKG dependencies on ARP_UTIL_TAX

Line 111: arp_util_tax.debug('CREATE_ZX_REPORTING_ASSOC(+)');

107:
108: l_reporting_type_id apps.zx_reporting_types_b.reporting_type_id%TYPE ;
109:
110: BEGIN
111: arp_util_tax.debug('CREATE_ZX_REPORTING_ASSOC(+)');
112:
113: IF Zx_Migrate_Util.IS_INSTALLED('AP') = 'Y' THEN
114: CREATE_ZX_REPORTING_ASSOC_AP(p_tax_id);
115: END IF;

Line 182: arp_util_tax.debug('CREATE_ZX_REPORTING_ASSOC(-)');

178: END ;
179:
180:
181:
182: arp_util_tax.debug('CREATE_ZX_REPORTING_ASSOC(-)');
183:
184: END CREATE_ZX_REPORTING_ASSOC;
185:
186:

Line 216: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(+)');

212: l_lookup_code ZX_REPORTING_CODES_B.REPORTING_CODE_CHAR_VALUE%TYPE ; -- Bug 4936036
213: BEGIN
214:
215: IF PG_DEBUG = 'Y' THEN
216: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(+)');
217: END IF;
218:
219: -- If AP Installed then
220: IF Zx_Migrate_Util.IS_INSTALLED('AP') = 'Y' THEN

Line 622: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

618: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
619: )
620: );
621:
622: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
623:
624: INSERT INTO ZX_REPORTING_CODES_TL(
625: REPORTING_CODE_ID ,
626: LANGUAGE ,

Line 845: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');

841: and T.LANGUAGE = L.LANGUAGE_CODE);
842:
843:
844: IF PG_DEBUG = 'Y' THEN
845: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');
846: END IF;
847:
848: EXCEPTION
849: WHEN OTHERS THEN

Line 851: arp_util_tax.debug('EXCEPTION: CREATE_ZX_REP_TYPE_CODES ');

847:
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF PG_DEBUG = 'Y' THEN
851: arp_util_tax.debug('EXCEPTION: CREATE_ZX_REP_TYPE_CODES ');
852: arp_util_tax.debug(sqlerrm);
853: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');
854: END IF;
855: app_exception.raise_exception;

Line 852: arp_util_tax.debug(sqlerrm);

848: EXCEPTION
849: WHEN OTHERS THEN
850: IF PG_DEBUG = 'Y' THEN
851: arp_util_tax.debug('EXCEPTION: CREATE_ZX_REP_TYPE_CODES ');
852: arp_util_tax.debug(sqlerrm);
853: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');
854: END IF;
855: app_exception.raise_exception;
856:

Line 853: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');

849: WHEN OTHERS THEN
850: IF PG_DEBUG = 'Y' THEN
851: arp_util_tax.debug('EXCEPTION: CREATE_ZX_REP_TYPE_CODES ');
852: arp_util_tax.debug(sqlerrm);
853: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES(-)');
854: END IF;
855: app_exception.raise_exception;
856:
857: END CREATE_ZX_REP_TYPE_CODES;

Line 873: arp_util_tax.debug('CREATE_REPORTING_TYPE_AR(+)');

869: IS
870:
871: BEGIN
872:
873: arp_util_tax.debug('CREATE_REPORTING_TYPE_AR(+)');
874: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
875: INSERT ALL
876: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
877: where reporting_type_code= p_reporting_type_code

Line 874: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);

870:
871: BEGIN
872:
873: arp_util_tax.debug('CREATE_REPORTING_TYPE_AR(+)');
874: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
875: INSERT ALL
876: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
877: where reporting_type_code= p_reporting_type_code
878: and tax_regime_code = l_tax_regime_code)

Line 944: arp_util_tax.debug('CREATE_REPORTING_TYPE_AR(-)');

940: AND vat_tax.vat_tax_id = nvl(p_tax_id, vat_tax.vat_tax_id)
941: GROUP BY
942: zx_rates.tax_regime_code;
943:
944: arp_util_tax.debug('CREATE_REPORTING_TYPE_AR(-)');
945:
946: END CREATE_REPORTING_TYPE_AR;
947:
948:

Line 962: arp_util_tax.debug('CREATE_REPORTING_TYPE_AP(+)');

958: IS
959:
960: BEGIN
961:
962: arp_util_tax.debug('CREATE_REPORTING_TYPE_AP(+)');
963: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
964: INSERT ALL
965: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
966: where reporting_type_code= p_reporting_type_code

Line 963: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);

959:
960: BEGIN
961:
962: arp_util_tax.debug('CREATE_REPORTING_TYPE_AP(+)');
963: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
964: INSERT ALL
965: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
966: where reporting_type_code= p_reporting_type_code
967: and tax_regime_code = l_tax_regime_code)

Line 1034: arp_util_tax.debug('CREATE_REPORTING_TYPE_AP(-)');

1030:
1031: GROUP BY
1032: zx_rates.tax_regime_code;
1033:
1034: arp_util_tax.debug('CREATE_REPORTING_TYPE_AP(-)');
1035:
1036: END CREATE_REPORTING_TYPE_AP;
1037:
1038:

Line 1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

1043: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
1044: ) IS
1045:
1046: BEGIN
1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
1048: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
1049: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
1050: INSERT
1051: INTO ZX_REPORTING_CODES_B(

Line 1048: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);

1044: ) IS
1045:
1046: BEGIN
1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
1048: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
1049: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
1050: INSERT
1051: INTO ZX_REPORTING_CODES_B(
1052: REPORTING_CODE_ID ,

Line 1049: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);

1045:
1046: BEGIN
1047: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
1048: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
1049: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
1050: INSERT
1051: INTO ZX_REPORTING_CODES_B(
1052: REPORTING_CODE_ID ,
1053: EXCEPTION_CODE ,

Line 1114: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

1110: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
1111: )
1112: );
1113:
1114: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
1115:
1116: INSERT INTO ZX_REPORTING_CODES_TL(
1117: REPORTING_CODE_ID ,
1118: LANGUAGE ,

Line 1164: arp_util_tax.debug('CREATE_REPORTING_CODES(-)');

1160: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
1161: and T.LANGUAGE = L.LANGUAGE_CODE);
1162:
1163:
1164: arp_util_tax.debug('CREATE_REPORTING_CODES(-)');
1165:
1166: END CREATE_REPORTING_CODES;
1167:
1168:

Line 1176: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');

1172: l_status fnd_module_installations.status%TYPE;
1173: l_db_status fnd_module_installations.DB_STATUS%TYPE;
1174:
1175: BEGIN
1176: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(+)');
1177: -- Verify Argentina Installation
1178: BEGIN
1179: SELECT STATUS, DB_STATUS
1180: INTO l_status, l_db_status

Line 1187: arp_util_tax.debug('Error in verification of argentina installation ');

1183: And MODULE_SHORT_NAME = 'jlarloc';
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: IF PG_DEBUG = 'Y' THEN
1187: arp_util_tax.debug('Error in verification of argentina installation ');
1188: END IF;
1189: END;
1190:
1191: IF (nvl(l_status,'N') in ('I','S') or

Line 1198: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');

1194:
1195: -- Code for Reporting Code Association. Bug # 3594759
1196: -- Insert the Fiscal Printer Codes into Association table
1197: IF PG_DEBUG = 'Y' THEN
1198: arp_util_tax.debug('Entering into zx_report_codes_assoc insert statement');
1199: END IF;
1200: --Bug 5247324
1201: /*
1202: INSERT INTO ZX_REPORT_CODES_ASSOC(

Line 1952: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(-)');

1948: and entity_id = rates.tax_rate_id
1949: and reporting_type_id =
1950: report_codes.reporting_type_id);
1951:
1952: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AP(-)');
1953:
1954: END CREATE_ZX_REPORTING_ASSOC_AP;
1955:
1956:

Line 1968: arp_util_tax.debug('ZX_REPORTING_ASSOC_AR(+)');

1964: BEGIN
1965:
1966: /* Create the Reporting Code association*/
1967: --Association for Reporting Type Code PT_ANL_TAX_BOX
1968: arp_util_tax.debug('ZX_REPORTING_ASSOC_AR(+)');
1969: INSERT
1970: INTO ZX_REPORT_CODES_ASSOC(
1971: REPORTING_CODE_ASSOC_ID,
1972: ENTITY_CODE ,

Line 2902: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AR(-)');

2898:
2899:
2900:
2901:
2902: arp_util_tax.debug(' CREATE_ZX_REPORTING_ASSOC_AR(-)');
2903: END CREATE_ZX_REPORTING_ASSOC_AR;
2904:
2905:
2906: /* Used to create the reporting type and code for AP */

Line 2912: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AP(+)');

2908: PROCEDURE CREATE_ZX_REP_TYPE_CODES_AP(p_tax_id IN NUMBER ) IS
2909: BEGIN
2910:
2911: IF PG_DEBUG = 'Y' THEN
2912: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AP(+)');
2913: END IF;
2914:
2915: INSERT ALL
2916: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4057: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AP(-)');

4053: );
4054:
4055:
4056: IF PG_DEBUG = 'Y' THEN
4057: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AP(-)');
4058: END IF;
4059:
4060: END CREATE_ZX_REP_TYPE_CODES_AP;
4061:

Line 4071: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(+)');

4067: l_exists_cnt NUMBER ; --Bug 5344337
4068: BEGIN
4069:
4070: IF PG_DEBUG = 'Y' THEN
4071: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(+)');
4072: END IF;
4073:
4074: -- Call a common procedure to create a reporting types.
4075: CREATE_REPORTING_TYPE_AR('CL_BILLS_OF_EXCH_TAX','YES_NO','N', 'JL.CL.ARXSUVAT.VAT_TAX', p_tax_id);

Line 5829: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(-)');

5825: entity_code = 'ZX_RATES_B' );
5826: */
5827:
5828: IF PG_DEBUG = 'Y' THEN
5829: arp_util_tax.debug('CREATE_ZX_REP_TYPE_CODES_AR(-)');
5830: END IF;
5831:
5832:
5833:

Line 5876: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(+)');

5872:
5873: IS
5874:
5875: BEGIN
5876: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(+)');
5877: arp_util_tax.debug('p_rep_type_info='||p_rep_type_info);
5878:
5879: INSERT INTO ZX_REPORT_CODES_ASSOC(
5880: REPORTING_CODE_ASSOC_ID,

Line 5877: arp_util_tax.debug('p_rep_type_info='||p_rep_type_info);

5873: IS
5874:
5875: BEGIN
5876: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(+)');
5877: arp_util_tax.debug('p_rep_type_info='||p_rep_type_info);
5878:
5879: INSERT INTO ZX_REPORT_CODES_ASSOC(
5880: REPORTING_CODE_ASSOC_ID,
5881: ENTITY_CODE,

Line 5924: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(-)');

5920: AND RCA.ENTITY_ID = p_ptp_id
5921: AND RCA.REPORTING_CODE_CHAR_VALUE = p_rep_type_info);
5922:
5923:
5924: arp_util_tax.debug('ZX_CREATE_REP_ASSOCIATION_PTP(-)');
5925: END ZX_CREATE_REP_ASSOCIATION_PTP;
5926:
5927:
5928: /*=========================================================================+

Line 5962: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

5958: IS
5959:
5960: BEGIN
5961:
5962: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
5963: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);
5964:
5965: INSERT
5966: INTO ZX_REPORTING_TYPES_B(

Line 5963: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);

5959:
5960: BEGIN
5961:
5962: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
5963: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);
5964:
5965: INSERT
5966: INTO ZX_REPORTING_TYPES_B(
5967: REPORTING_TYPE_ID ,

Line 6023: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

6019: where reporting_type_code= p_reporting_type_code
6020: and tax_regime_code IS NULL);
6021:
6022:
6023: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
6024: END CREATE_REPORT_TYPE_PTP;
6025:
6026: /*=========================================================================+
6027: | PROCEDURE |

Line 6060: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

6056: IS
6057:
6058: BEGIN
6059:
6060: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
6061: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);
6062:
6063: INSERT
6064: INTO ZX_REPORTING_TYPES_B(

Line 6061: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);

6057:
6058: BEGIN
6059:
6060: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
6061: arp_util_tax.debug('p_reporting_type_code='||p_reporting_type_code);
6062:
6063: INSERT
6064: INTO ZX_REPORTING_TYPES_B(
6065: REPORTING_TYPE_ID ,

Line 6211: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');

6207: from ZX_REPORTING_TYPES_TL T
6208: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
6209: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
6210:
6211: arp_util_tax.debug('CREATE_REPORT_TYPE_PTP(+)');
6212:
6213: END CREATE_REPORT_TYPE_SEED;
6214:
6215: /*=========================================================================+

Line 6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');

6241: P_lookup_type IN FND_LOOKUPS.LOOKUP_TYPE%TYPE
6242: ) IS
6243:
6244: BEGIN
6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
6246: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
6247: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
6248: INSERT
6249: INTO ZX_REPORTING_CODES_B(

Line 6246: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);

6242: ) IS
6243:
6244: BEGIN
6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
6246: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
6247: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
6248: INSERT
6249: INTO ZX_REPORTING_CODES_B(
6250: REPORTING_CODE_ID ,

Line 6247: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);

6243:
6244: BEGIN
6245: arp_util_tax.debug('CREATE_REPORTING_CODES(+)');
6246: arp_util_tax.debug('p_reporting_type_code = '||p_reporting_type_code);
6247: arp_util_tax.debug('p_lookup_type = '||p_lookup_type);
6248: INSERT
6249: INTO ZX_REPORTING_CODES_B(
6250: REPORTING_CODE_ID ,
6251: EXCEPTION_CODE ,

Line 6312: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

6308: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6309: )
6310: );
6311:
6312: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6313:
6314: INSERT INTO ZX_REPORTING_CODES_TL(
6315: REPORTING_CODE_ID ,
6316: LANGUAGE ,

Line 6362: arp_util_tax.debug('CREATE_REPORTING_CODES(-)');

6358: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
6359: and T.LANGUAGE = L.LANGUAGE_CODE);
6360:
6361:
6362: arp_util_tax.debug('CREATE_REPORTING_CODES(-)');
6363:
6364: END CREATE_REPORTING_CODES_SEED;
6365:
6366: /*=========================================================================+

Line 6732: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

6728: REPORTING_CODE_CHAR_VALUE=lookups.LOOKUP_CODE
6729: )
6730: );
6731:
6732: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
6733:
6734: INSERT INTO ZX_REPORTING_CODES_TL(
6735: REPORTING_CODE_ID ,
6736: LANGUAGE ,

Line 6948: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(+)');

6944:
6945: PROCEDURE CREATE_REPORTING_TYPE_EMEA
6946: IS
6947: BEGIN
6948: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(+)');
6949: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
6950: INSERT
6951: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
6952: where reporting_type_code= 'EMEA_VAT_REPORTING_TYPE'

Line 6949: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');

6945: PROCEDURE CREATE_REPORTING_TYPE_EMEA
6946: IS
6947: BEGIN
6948: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(+)');
6949: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
6950: INSERT
6951: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
6952: where reporting_type_code= 'EMEA_VAT_REPORTING_TYPE'
6953: and tax_regime_code is NULL)

Line 7014: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');

7010: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7011: 'IT','KP','KR','NO','PL','PT','SK')
7012: AND zx_rates.record_type_code = 'MIGRATED';
7013:
7014: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table');
7015:
7016: INSERT INTO ZX_REPORTING_TYPES_TL(
7017: REPORTING_TYPE_ID ,
7018: LANGUAGE ,

Line 7056: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(-)');

7052: from ZX_REPORTING_TYPES_TL T
7053: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7054: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7055:
7056: arp_util_tax.debug('CREATE_REPORTING_TYPE_EMEA(-)');
7057:
7058: END CREATE_REPORTING_TYPE_EMEA;
7059:
7060: /*==========================================================================+

Line 7077: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(+)');

7073:
7074: PROCEDURE CREATE_REPORT_TYP_USAGES_EMEA
7075: IS
7076: BEGIN
7077: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(+)');
7078:
7079: INSERT INTO ZX_REPORT_TYPES_USAGES(
7080: REPORTING_TYPE_USAGE_ID,
7081: REPORTING_TYPE_ID ,

Line 7110: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(-)');

7106: AND NOT EXISTS ( select 1 from zx_report_types_usages
7107: where reporting_type_id = types.reporting_type_id
7108: and entity_code = 'ZX_RATES');
7109:
7110: arp_util_tax.debug('CREATE_REPORT_TYP_USAGES_EMEA(-)');
7111:
7112: END CREATE_REPORT_TYP_USAGES_EMEA;
7113:
7114: /*==========================================================================+

Line 7132: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');

7128:
7129: PROCEDURE CREATE_REPORTING_CODES_EMEA
7130: IS
7131: BEGIN
7132: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');
7133: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7134: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');
7135: INSERT
7136: INTO ZX_REPORTING_CODES_B(

Line 7133: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');

7129: PROCEDURE CREATE_REPORTING_CODES_EMEA
7130: IS
7131: BEGIN
7132: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');
7133: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7134: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');
7135: INSERT
7136: INTO ZX_REPORTING_CODES_B(
7137: REPORTING_CODE_ID ,

Line 7134: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');

7130: IS
7131: BEGIN
7132: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(+)');
7133: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7134: arp_util_tax.debug('p_lookup_type = '||'ZX_TAX_TYPE_CATEGORY');
7135: INSERT
7136: INTO ZX_REPORTING_CODES_B(
7137: REPORTING_CODE_ID ,
7138: EXCEPTION_CODE ,

Line 7214: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');

7210: UPPER(lookups.lookup_code))
7211: )
7212: );
7213:
7214: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table');
7215:
7216: INSERT INTO ZX_REPORTING_CODES_TL(
7217: REPORTING_CODE_ID ,
7218: LANGUAGE ,

Line 7269: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(-)');

7265: from ZX_REPORTING_CODES_TL T
7266: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7267: and T.LANGUAGE = L.LANGUAGE_CODE);
7268:
7269: arp_util_tax.debug('CREATE_REPORTING_CODES_EMEA(-)');
7270:
7271: END CREATE_REPORTING_CODES_EMEA;
7272:
7273: /*==========================================================================+

Line 7291: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');

7287:
7288: PROCEDURE CREATE_REP_CODE_ASSOC_EMEA
7289: IS
7290: BEGIN
7291: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');
7292: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7293:
7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7295:

Line 7292: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');

7288: PROCEDURE CREATE_REP_CODE_ASSOC_EMEA
7289: IS
7290: BEGIN
7291: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');
7292: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7293:
7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7295:
7296: INSERT

Line 7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');

7290: BEGIN
7291: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(+)');
7292: arp_util_tax.debug('p_reporting_type_code = '||'EMEA_VAT_REPORTING_TYPE');
7293:
7294: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AP tax codes');
7295:
7296: INSERT
7297: INTO ZX_REPORT_CODES_ASSOC(
7298: REPORTING_CODE_ASSOC_ID,

Line 7366: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');

7362: and entity_id = rates.tax_rate_id
7363: and reporting_type_id =
7364: report_codes.reporting_type_id);
7365:
7366: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table for AR tax codes');
7367:
7368: INSERT
7369: INTO ZX_REPORT_CODES_ASSOC(
7370: REPORTING_CODE_ASSOC_ID,

Line 7434: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(-)');

7430: where entity_code = 'ZX_RATES'
7431: and entity_id = rates.tax_rate_id
7432: and reporting_type_id = report_codes.reporting_type_id);
7433:
7434: arp_util_tax.debug('CREATE_REP_CODE_ASSOC_EMEA(-)');
7435:
7436: END CREATE_REP_CODE_ASSOC_EMEA;
7437:
7438: /*===========================================================================+

Line 7455: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(+)');

7451:
7452: PROCEDURE CREATE_REP_ENT_REVERSE_VAT
7453: IS
7454: BEGIN
7455: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(+)');
7456: arp_util_tax.debug('p_reporting_type_code = '||'REVERSE_CHARGE_VAT');
7457:
7458: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_B table...');
7459:

Line 7456: arp_util_tax.debug('p_reporting_type_code = '||'REVERSE_CHARGE_VAT');

7452: PROCEDURE CREATE_REP_ENT_REVERSE_VAT
7453: IS
7454: BEGIN
7455: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(+)');
7456: arp_util_tax.debug('p_reporting_type_code = '||'REVERSE_CHARGE_VAT');
7457:
7458: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_B table...');
7459:
7460: INSERT WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 7458: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_B table...');

7454: BEGIN
7455: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(+)');
7456: arp_util_tax.debug('p_reporting_type_code = '||'REVERSE_CHARGE_VAT');
7457:
7458: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_B table...');
7459:
7460: INSERT WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
7461: where reporting_type_code = l_reporting_type_code
7462: and tax_regime_code = l_tax_regime_code

Line 7527: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');

7523: AND codes.tax_type = 'REVERSE_CHARGE_VAT'
7524: AND rates.record_type_code = 'MIGRATED'
7525: GROUP BY rates.tax_regime_code, rates.tax;
7526:
7527: arp_util_tax.debug('Inserting into ZX_REPORTING_TYPES_TL table...');
7528:
7529: INSERT INTO ZX_REPORTING_TYPES_TL(
7530: REPORTING_TYPE_ID ,
7531: LANGUAGE ,

Line 7568: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');

7564: from ZX_REPORTING_TYPES_TL T
7565: where T.REPORTING_TYPE_ID = TYPES.REPORTING_TYPE_ID
7566: and T.LANGUAGE = TYPES.LANGUAGE_CODE);
7567:
7568: arp_util_tax.debug('Inserting into ZX_REPORT_TYPES_USAGES table...');
7569:
7570: INSERT INTO ZX_REPORT_TYPES_USAGES(
7571: REPORTING_TYPE_USAGE_ID,
7572: REPORTING_TYPE_ID ,

Line 7601: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');

7597: AND NOT EXISTS ( select 1 from zx_report_types_usages
7598: where reporting_type_id = types.reporting_type_id
7599: and entity_code = 'ZX_RATES');
7600:
7601: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_B table...');
7602:
7603: INSERT
7604: INTO ZX_REPORTING_CODES_B(
7605: REPORTING_CODE_ID ,

Line 7670: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');

7666: AND REPORTING_CODE_CHAR_VALUE = UPPER(lookups.lookup_code)
7667: )
7668: );
7669:
7670: arp_util_tax.debug('Inserting into ZX_REPORTING_CODES_TL table...');
7671:
7672: INSERT INTO ZX_REPORTING_CODES_TL(
7673: REPORTING_CODE_ID ,
7674: LANGUAGE ,

Line 7719: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');

7715: from ZX_REPORTING_CODES_TL T
7716: where T.REPORTING_CODE_ID = CODES.REPORTING_CODE_ID
7717: and T.LANGUAGE = L.LANGUAGE_CODE);
7718:
7719: arp_util_tax.debug('Inserting into ZX_REPORT_CODES_ASSOC table...');
7720:
7721: INSERT
7722: INTO ZX_REPORT_CODES_ASSOC(
7723: REPORTING_CODE_ASSOC_ID,

Line 7778: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(-)');

7774: where entity_code = 'ZX_RATES'
7775: and entity_id = rates.tax_rate_id
7776: and reporting_type_id = report_codes.reporting_type_id);
7777:
7778: arp_util_tax.debug('CREATE_REP_ENT_REVERSE_VAT(-)');
7779:
7780: END CREATE_REP_ENT_REVERSE_VAT;
7781:
7782: /*===========================================================================+

Line 7800: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(+) ' );

7796: PROCEDURE ZX_MIGRATE_REP_ENTITIES_MAIN IS
7797:
7798: BEGIN
7799:
7800: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(+) ' );
7801:
7802: arp_util_tax.debug('Now calling Reporting Type Code...' );
7803:
7804: CREATE_ZX_REP_TYPE_CODES(null);

Line 7802: arp_util_tax.debug('Now calling Reporting Type Code...' );

7798: BEGIN
7799:
7800: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(+) ' );
7801:
7802: arp_util_tax.debug('Now calling Reporting Type Code...' );
7803:
7804: CREATE_ZX_REP_TYPE_CODES(null);
7805:
7806: arp_util_tax.debug('Now calling Reporting Association...' );

Line 7806: arp_util_tax.debug('Now calling Reporting Association...' );

7802: arp_util_tax.debug('Now calling Reporting Type Code...' );
7803:
7804: CREATE_ZX_REP_TYPE_CODES(null);
7805:
7806: arp_util_tax.debug('Now calling Reporting Association...' );
7807:
7808: CREATE_ZX_REPORTING_ASSOC(null);
7809:
7810: arp_util_tax.debug('Now calling Usages...' );

Line 7810: arp_util_tax.debug('Now calling Usages...' );

7806: arp_util_tax.debug('Now calling Reporting Association...' );
7807:
7808: CREATE_ZX_REPORTING_ASSOC(null);
7809:
7810: arp_util_tax.debug('Now calling Usages...' );
7811:
7812: CREATE_REPORT_TYPES_USAGES;
7813:
7814:

Line 7816: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(+) ' );

7812: CREATE_REPORT_TYPES_USAGES;
7813:
7814:
7815: /* Calling the procedures for EMEA VAT reporting type */
7816: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(+) ' );
7817:
7818: arp_util_tax.debug('Now calling Reporting Type Code for EMEA...' );
7819:
7820: CREATE_REPORTING_TYPE_EMEA;

Line 7818: arp_util_tax.debug('Now calling Reporting Type Code for EMEA...' );

7814:
7815: /* Calling the procedures for EMEA VAT reporting type */
7816: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(+) ' );
7817:
7818: arp_util_tax.debug('Now calling Reporting Type Code for EMEA...' );
7819:
7820: CREATE_REPORTING_TYPE_EMEA;
7821:
7822: arp_util_tax.debug('Now calling Usages for EMEA...' );

Line 7822: arp_util_tax.debug('Now calling Usages for EMEA...' );

7818: arp_util_tax.debug('Now calling Reporting Type Code for EMEA...' );
7819:
7820: CREATE_REPORTING_TYPE_EMEA;
7821:
7822: arp_util_tax.debug('Now calling Usages for EMEA...' );
7823:
7824: CREATE_REPORT_TYP_USAGES_EMEA;
7825:
7826: arp_util_tax.debug('Now calling Reporting Codes for EMEA...' );

Line 7826: arp_util_tax.debug('Now calling Reporting Codes for EMEA...' );

7822: arp_util_tax.debug('Now calling Usages for EMEA...' );
7823:
7824: CREATE_REPORT_TYP_USAGES_EMEA;
7825:
7826: arp_util_tax.debug('Now calling Reporting Codes for EMEA...' );
7827:
7828: CREATE_REPORTING_CODES_EMEA;
7829:
7830: arp_util_tax.debug('Now calling Reporting Association...' );

Line 7830: arp_util_tax.debug('Now calling Reporting Association...' );

7826: arp_util_tax.debug('Now calling Reporting Codes for EMEA...' );
7827:
7828: CREATE_REPORTING_CODES_EMEA;
7829:
7830: arp_util_tax.debug('Now calling Reporting Association...' );
7831:
7832: CREATE_REP_CODE_ASSOC_EMEA;
7833:
7834: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(-) ' );

Line 7834: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(-) ' );

7830: arp_util_tax.debug('Now calling Reporting Association...' );
7831:
7832: CREATE_REP_CODE_ASSOC_EMEA;
7833:
7834: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(-) ' );
7835:
7836: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(+) ' );
7837:
7838: CREATE_REP_ENT_REVERSE_VAT;

Line 7836: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(+) ' );

7832: CREATE_REP_CODE_ASSOC_EMEA;
7833:
7834: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_FOR_EMEA(-) ' );
7835:
7836: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(+) ' );
7837:
7838: CREATE_REP_ENT_REVERSE_VAT;
7839:
7840: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(-) ' );

Line 7840: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(-) ' );

7836: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(+) ' );
7837:
7838: CREATE_REP_ENT_REVERSE_VAT;
7839:
7840: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(-) ' );
7841:
7842: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(-) ');
7843:
7844:

Line 7842: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(-) ');

7838: CREATE_REP_ENT_REVERSE_VAT;
7839:
7840: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_REVERSE_VAT(-) ' );
7841:
7842: arp_util_tax.debug('ZX_MIGRATE_REP_ENTITIES_MAIN(-) ');
7843:
7844:
7845: END ZX_MIGRATE_REP_ENTITIES_MAIN;
7846:

Line 7857: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');

7853:
7854: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
7855:
7856: IF L_ORG_ID IS NULL THEN
7857: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
7858: END IF;
7859: ELSE
7860: L_ORG_ID := NULL;
7861: END IF;

Line 7867: arp_util_tax.debug('Exception in constructor of Reporting Types Codes and Associations '||sqlerrm);

7863:
7864:
7865: EXCEPTION
7866: WHEN OTHERS THEN
7867: arp_util_tax.debug('Exception in constructor of Reporting Types Codes and Associations '||sqlerrm);
7868:
7869: END ZX_MIGRATE_REP_ENTITIES_PKG ;