DBA Data[Home] [Help]

APPS.ZX_MIG_GL_TAX_OPTIONS_PKG dependencies on ARP_UTIL_TAX

Line 53: arp_util_tax.debug('zx_sync_gl_tax_options(+)');

49: P_Account_Segment_Value IN VARCHAR2,
50: P_Tax_Type_Code IN VARCHAR2) is
51: BEGIN
52: IF PG_DEBUG = 'Y' THEN
53: arp_util_tax.debug('zx_sync_gl_tax_options(+)');
54: END IF;
55:
56: if(P_Account_Segment_Value is NULL and p_tax_type_code is NULL ) then
57: zx_mig_gl_tax_options_header(P_Ledger_Id,P_Org_id);

Line 70: arp_util_tax.debug('zx_sync_gl_tax_options(-)');

66: end if;
67: end if;
68:
69: IF PG_DEBUG = 'Y' THEN
70: arp_util_tax.debug('zx_sync_gl_tax_options(-)');
71: END IF;
72: EXCEPTION
73: WHEN OTHERS THEN
74: IF PG_DEBUG = 'Y' THEN

Line 75: arp_util_tax.debug('EXCEPTION: zx_sync_gl_tax_options ');

71: END IF;
72: EXCEPTION
73: WHEN OTHERS THEN
74: IF PG_DEBUG = 'Y' THEN
75: arp_util_tax.debug('EXCEPTION: zx_sync_gl_tax_options ');
76: arp_util_tax.debug(sqlerrm);
77: arp_util_tax.debug('zx_sync_gl_tax_options(-)');
78: END IF;
79: app_exception.raise_exception;

Line 76: arp_util_tax.debug(sqlerrm);

72: EXCEPTION
73: WHEN OTHERS THEN
74: IF PG_DEBUG = 'Y' THEN
75: arp_util_tax.debug('EXCEPTION: zx_sync_gl_tax_options ');
76: arp_util_tax.debug(sqlerrm);
77: arp_util_tax.debug('zx_sync_gl_tax_options(-)');
78: END IF;
79: app_exception.raise_exception;
80: End zx_sync_gl_tax_options;

Line 77: arp_util_tax.debug('zx_sync_gl_tax_options(-)');

73: WHEN OTHERS THEN
74: IF PG_DEBUG = 'Y' THEN
75: arp_util_tax.debug('EXCEPTION: zx_sync_gl_tax_options ');
76: arp_util_tax.debug(sqlerrm);
77: arp_util_tax.debug('zx_sync_gl_tax_options(-)');
78: END IF;
79: app_exception.raise_exception;
80: End zx_sync_gl_tax_options;
81:

Line 106: arp_util_tax.debug('zx_mig_gl_tax_options(+)');

102:
103: PROCEDURE zx_mig_gl_tax_options is
104: BEGIN
105: IF PG_DEBUG = 'Y' THEN
106: arp_util_tax.debug('zx_mig_gl_tax_options(+)');
107: END IF;
108:
109: zx_mig_gl_tax_options_header(NULL,NULL);
110:

Line 122: arp_util_tax.debug('zx_mig_gl_tax_options(-)');

118: zx_mig_gl_tax_options_ar(NULL,NULL,NULL);
119: END IF;
120:
121: IF PG_DEBUG = 'Y' THEN
122: arp_util_tax.debug('zx_mig_gl_tax_options(-)');
123: END IF;
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF PG_DEBUG = 'Y' THEN

Line 127: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options ');

123: END IF;
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF PG_DEBUG = 'Y' THEN
127: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options ');
128: arp_util_tax.debug(sqlerrm);
129: arp_util_tax.debug('zx_mig_gl_tax_options(-)');
130: END IF;
131: app_exception.raise_exception;

Line 128: arp_util_tax.debug(sqlerrm);

124: EXCEPTION
125: WHEN OTHERS THEN
126: IF PG_DEBUG = 'Y' THEN
127: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options ');
128: arp_util_tax.debug(sqlerrm);
129: arp_util_tax.debug('zx_mig_gl_tax_options(-)');
130: END IF;
131: app_exception.raise_exception;
132: END zx_mig_gl_tax_options;

Line 129: arp_util_tax.debug('zx_mig_gl_tax_options(-)');

125: WHEN OTHERS THEN
126: IF PG_DEBUG = 'Y' THEN
127: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options ');
128: arp_util_tax.debug(sqlerrm);
129: arp_util_tax.debug('zx_mig_gl_tax_options(-)');
130: END IF;
131: app_exception.raise_exception;
132: END zx_mig_gl_tax_options;
133:

Line 158: arp_util_tax.debug('zx_mig_gl_tax_options_header(+)');

154:
155: PROCEDURE zx_mig_gl_tax_options_header(P_Ledger_Id number,P_Org_id number) is
156: BEGIN
157: IF PG_DEBUG = 'Y' THEN
158: arp_util_tax.debug('zx_mig_gl_tax_options_header(+)');
159: END IF;
160:
161: Insert ALL
162: Into zx_account_rates_tmp

Line 299: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');

295: and account_segment_value is null
296: and tax_class is NULL );
297:
298: IF PG_DEBUG = 'Y' THEN
299: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');
300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF PG_DEBUG = 'Y' THEN

Line 304: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_header ');

300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF PG_DEBUG = 'Y' THEN
304: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_header ');
305: arp_util_tax.debug(sqlerrm);
306: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');
307: END IF;
308: app_exception.raise_exception;

Line 305: arp_util_tax.debug(sqlerrm);

301: EXCEPTION
302: WHEN OTHERS THEN
303: IF PG_DEBUG = 'Y' THEN
304: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_header ');
305: arp_util_tax.debug(sqlerrm);
306: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');
307: END IF;
308: app_exception.raise_exception;
309: END zx_mig_gl_tax_options_header;

Line 306: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');

302: WHEN OTHERS THEN
303: IF PG_DEBUG = 'Y' THEN
304: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_header ');
305: arp_util_tax.debug(sqlerrm);
306: arp_util_tax.debug('zx_mig_gl_tax_options_header(-)');
307: END IF;
308: app_exception.raise_exception;
309: END zx_mig_gl_tax_options_header;
310:

Line 336: arp_util_tax.debug('zx_mig_gl_tax_options_nt(+)');

332:
333: PROCEDURE zx_mig_gl_tax_options_nt(P_Ledger_Id number,P_Org_id number,P_Account_Segment_Value varchar2) is
334: BEGIN
335: IF PG_DEBUG = 'Y' THEN
336: arp_util_tax.debug('zx_mig_gl_tax_options_nt(+)');
337: END IF;
338:
339: Insert ALL
340: Into zx_account_rates_tmp

Line 482: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');

478: and account_segment_value = accounts.account_segment_value
479: and tax_class = 'NON_TAXABLE' );
480:
481: IF PG_DEBUG = 'Y' THEN
482: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');
483: END IF;
484: EXCEPTION
485: WHEN OTHERS THEN
486: IF PG_DEBUG = 'Y' THEN

Line 487: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_nt ');

483: END IF;
484: EXCEPTION
485: WHEN OTHERS THEN
486: IF PG_DEBUG = 'Y' THEN
487: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_nt ');
488: arp_util_tax.debug(sqlerrm);
489: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');
490: END IF;
491: app_exception.raise_exception;

Line 488: arp_util_tax.debug(sqlerrm);

484: EXCEPTION
485: WHEN OTHERS THEN
486: IF PG_DEBUG = 'Y' THEN
487: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_nt ');
488: arp_util_tax.debug(sqlerrm);
489: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');
490: END IF;
491: app_exception.raise_exception;
492: END zx_mig_gl_tax_options_nt;

Line 489: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');

485: WHEN OTHERS THEN
486: IF PG_DEBUG = 'Y' THEN
487: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_nt ');
488: arp_util_tax.debug(sqlerrm);
489: arp_util_tax.debug('zx_mig_gl_tax_options_nt(-)');
490: END IF;
491: app_exception.raise_exception;
492: END zx_mig_gl_tax_options_nt;
493:

Line 518: arp_util_tax.debug('zx_mig_gl_tax_options_ap(+)');

514:
515: PROCEDURE zx_mig_gl_tax_options_ap(P_Ledger_Id number,P_Org_id number,P_Account_Segment_Value varchar2) is
516: BEGIN
517: IF PG_DEBUG = 'Y' THEN
518: arp_util_tax.debug('zx_mig_gl_tax_options_ap(+)');
519: END IF;
520:
521: Insert ALL
522: Into zx_account_rates_tmp

Line 874: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');

870: and account_segment_value = accounts.account_segment_value
871: and tax_class = 'INPUT' );
872:
873: IF PG_DEBUG = 'Y' THEN
874: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');
875: END IF;
876: EXCEPTION
877: WHEN OTHERS THEN
878: IF PG_DEBUG = 'Y' THEN

Line 879: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ap ');

875: END IF;
876: EXCEPTION
877: WHEN OTHERS THEN
878: IF PG_DEBUG = 'Y' THEN
879: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ap ');
880: arp_util_tax.debug(sqlerrm);
881: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');
882: END IF;
883: app_exception.raise_exception;

Line 880: arp_util_tax.debug(sqlerrm);

876: EXCEPTION
877: WHEN OTHERS THEN
878: IF PG_DEBUG = 'Y' THEN
879: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ap ');
880: arp_util_tax.debug(sqlerrm);
881: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');
882: END IF;
883: app_exception.raise_exception;
884: END zx_mig_gl_tax_options_ap;

Line 881: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');

877: WHEN OTHERS THEN
878: IF PG_DEBUG = 'Y' THEN
879: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ap ');
880: arp_util_tax.debug(sqlerrm);
881: arp_util_tax.debug('zx_mig_gl_tax_options_ap(-)');
882: END IF;
883: app_exception.raise_exception;
884: END zx_mig_gl_tax_options_ap;
885:

Line 909: arp_util_tax.debug('zx_mig_gl_tax_options_ar(+)');

905:
906: PROCEDURE zx_mig_gl_tax_options_ar(P_Ledger_Id number,P_Org_id number,P_Account_Segment_Value varchar2) is
907: BEGIN
908: IF PG_DEBUG = 'Y' THEN
909: arp_util_tax.debug('zx_mig_gl_tax_options_ar(+)');
910: END IF;
911:
912: Insert ALL
913: Into zx_account_rates_tmp

Line 1268: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');

1264: and account_segment_value = accounts.account_segment_value
1265: and tax_class = 'OUTPUT' );
1266:
1267: IF PG_DEBUG = 'Y' THEN
1268: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');
1269: END IF;
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF PG_DEBUG = 'Y' THEN

Line 1273: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ar ');

1269: END IF;
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF PG_DEBUG = 'Y' THEN
1273: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ar ');
1274: arp_util_tax.debug(sqlerrm);
1275: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');
1276: END IF;
1277: app_exception.raise_exception;

Line 1274: arp_util_tax.debug(sqlerrm);

1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: IF PG_DEBUG = 'Y' THEN
1273: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ar ');
1274: arp_util_tax.debug(sqlerrm);
1275: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');
1276: END IF;
1277: app_exception.raise_exception;
1278: END zx_mig_gl_tax_options_ar;

Line 1275: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');

1271: WHEN OTHERS THEN
1272: IF PG_DEBUG = 'Y' THEN
1273: arp_util_tax.debug('EXCEPTION: zx_mig_gl_tax_options_ar ');
1274: arp_util_tax.debug(sqlerrm);
1275: arp_util_tax.debug('zx_mig_gl_tax_options_ar(-)');
1276: END IF;
1277: app_exception.raise_exception;
1278: END zx_mig_gl_tax_options_ar;
1279:

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

1285:
1286: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
1287:
1288: IF L_ORG_ID IS NULL THEN
1289: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
1290: END IF;
1291: ELSE
1292: L_ORG_ID := NULL;
1293: END IF;

Line 1299: arp_util_tax.debug('Exception in constructor of GL Tax Options Code '||sqlerrm);

1295:
1296:
1297: EXCEPTION
1298: WHEN OTHERS THEN
1299: arp_util_tax.debug('Exception in constructor of GL Tax Options Code '||sqlerrm);
1300: END zx_mig_gl_tax_options_pkg;