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.ARP_TAX_INTERFACE dependencies on ARP_UTIL_TAX

Line 228: arp_util_tax.debug('ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE('||

224: sel_count binary_integer;
225:
226: BEGIN
227: if pg_debug='Y' then
228: arp_util_tax.debug('ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE('||
229: senior_segment||':'||to_char(default_start_date)||
230: to_char(sysdate, 'YYYY-MON-DD: HH:MI:SS')||')+');
231: end if;
232:

Line 266: arp_util_tax.debug(to_char(l_count)||':'||to_char(l_interface_line_id)||

262: l_parent_location_id := c1.parent_location_id;
263: l_location_value := c1.location_value;
264:
265: if pg_debug='Y' then
266: arp_util_tax.debug(to_char(l_count)||':'||to_char(l_interface_line_id)||
267: ':'||to_char(l_location_segment_id));
268: arp_util_tax.debug('---'||l_segment_qualifier||':'||to_char(l_start_date)||':'||l_from_postal_code);
269: arp_util_tax.debug('---'||l_rate_type||':'||to_char(l_parent_location_id)||':'||l_location_value);
270: end if;

Line 268: arp_util_tax.debug('---'||l_segment_qualifier||':'||to_char(l_start_date)||':'||l_from_postal_code);

264:
265: if pg_debug='Y' then
266: arp_util_tax.debug(to_char(l_count)||':'||to_char(l_interface_line_id)||
267: ':'||to_char(l_location_segment_id));
268: arp_util_tax.debug('---'||l_segment_qualifier||':'||to_char(l_start_date)||':'||l_from_postal_code);
269: arp_util_tax.debug('---'||l_rate_type||':'||to_char(l_parent_location_id)||':'||l_location_value);
270: end if;
271: s_count := 0;
272: for c2 in c_zip_overlap(c1.interface_line_id,

Line 269: arp_util_tax.debug('---'||l_rate_type||':'||to_char(l_parent_location_id)||':'||l_location_value);

265: if pg_debug='Y' then
266: arp_util_tax.debug(to_char(l_count)||':'||to_char(l_interface_line_id)||
267: ':'||to_char(l_location_segment_id));
268: arp_util_tax.debug('---'||l_segment_qualifier||':'||to_char(l_start_date)||':'||l_from_postal_code);
269: arp_util_tax.debug('---'||l_rate_type||':'||to_char(l_parent_location_id)||':'||l_location_value);
270: end if;
271: s_count := 0;
272: for c2 in c_zip_overlap(c1.interface_line_id,
273: c1.segment_qualifier,

Line 288: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);

284:
285: if (l_from_postal_code >= c2.from_postal_code) and
286: (l_to_postal_code <= c2.to_postal_code) then
287: if pg_debug='Y' then
288: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
289: arp_util_tax.debug(' smaller than ');
290: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
291: end if;
292: l_interface_line_id := c2.interface_line_id;

Line 289: arp_util_tax.debug(' smaller than ');

285: if (l_from_postal_code >= c2.from_postal_code) and
286: (l_to_postal_code <= c2.to_postal_code) then
287: if pg_debug='Y' then
288: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
289: arp_util_tax.debug(' smaller than ');
290: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
291: end if;
292: l_interface_line_id := c2.interface_line_id;
293: l_location_segment_id := c2.location_segment_id;

Line 290: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);

286: (l_to_postal_code <= c2.to_postal_code) then
287: if pg_debug='Y' then
288: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
289: arp_util_tax.debug(' smaller than ');
290: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
291: end if;
292: l_interface_line_id := c2.interface_line_id;
293: l_location_segment_id := c2.location_segment_id;
294: l_segment_qualifier := c2.segment_qualifier;

Line 306: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);

302: l_location_value := c2.location_value;
303:
304: else
305: if pg_debug='Y' then
306: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
307: arp_util_tax.debug(' larger than ');
308: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
309: end if;
310: in_clause := in_clause||','||c2.interface_line_id;

Line 307: arp_util_tax.debug(' larger than ');

303:
304: else
305: if pg_debug='Y' then
306: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
307: arp_util_tax.debug(' larger than ');
308: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
309: end if;
310: in_clause := in_clause||','||c2.interface_line_id;
311:

Line 308: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);

304: else
305: if pg_debug='Y' then
306: arp_util_tax.debug('Postal Code current: '||l_from_postal_code||' : '||l_to_postal_code);
307: arp_util_tax.debug(' larger than ');
308: arp_util_tax.debug('Postal Code in: '||c2.from_postal_code||' : '||c2.to_postal_code);
309: end if;
310: in_clause := in_clause||','||c2.interface_line_id;
311:
312: end if;

Line 314: arp_util_tax.debug('************');

310: in_clause := in_clause||','||c2.interface_line_id;
311:
312: end if;
313: if pg_debug='Y' then
314: arp_util_tax.debug('************');
315: end if;
316: end loop;
317:
318: prog_loc := 4;

Line 320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);

316: end loop;
317:
318: prog_loc := 4;
319: if pg_debug='Y' then
320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);
321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');

Line 321: arp_util_tax.debug('Location value is :'||l_location_value);

317:
318: prog_loc := 4;
319: if pg_debug='Y' then
320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);
321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');

Line 322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));

318: prog_loc := 4;
319: if pg_debug='Y' then
320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);
321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');
326: arp_util_tax.debug('');

Line 323: arp_util_tax.debug('Small Count is: '||s_count);

319: if pg_debug='Y' then
320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);
321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');
326: arp_util_tax.debug('');
327: end if;

Line 324: arp_util_tax.debug('');

320: arp_util_tax.debug('Largest Zip Range is : '||l_from_postal_code||' ~~ '||l_to_postal_code);
321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');
326: arp_util_tax.debug('');
327: end if;
328:

Line 325: arp_util_tax.debug('-----------------------------------------------------');

321: arp_util_tax.debug('Location value is :'||l_location_value);
322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');
326: arp_util_tax.debug('');
327: end if;
328:
329: end loop;

Line 326: arp_util_tax.debug('');

322: arp_util_tax.debug('Interface_line_id is :'||to_char(l_interface_line_id));
323: arp_util_tax.debug('Small Count is: '||s_count);
324: arp_util_tax.debug('');
325: arp_util_tax.debug('-----------------------------------------------------');
326: arp_util_tax.debug('');
327: end if;
328:
329: end loop;
330:

Line 342: arp_util_tax.debug('STATUS column of records with following interface_line_id');

338: end_pos := 200;
339:
340: dis_in_clause := substrb(in_clause, start_pos, end_pos);
341: if pg_debug='Y' then
342: arp_util_tax.debug('STATUS column of records with following interface_line_id');
343: arp_util_tax.debug('in ar_tax_interface table, will be updated with IGNORED-NARROWER-ZIP');
344: end if;
345:
346: while dis_in_clause is not null loop

Line 343: arp_util_tax.debug('in ar_tax_interface table, will be updated with IGNORED-NARROWER-ZIP');

339:
340: dis_in_clause := substrb(in_clause, start_pos, end_pos);
341: if pg_debug='Y' then
342: arp_util_tax.debug('STATUS column of records with following interface_line_id');
343: arp_util_tax.debug('in ar_tax_interface table, will be updated with IGNORED-NARROWER-ZIP');
344: end if;
345:
346: while dis_in_clause is not null loop
347: prog_loc := 6;

Line 349: arp_util_tax.debug(dis_in_clause);

345:
346: while dis_in_clause is not null loop
347: prog_loc := 6;
348: if pg_debug='Y' then
349: arp_util_tax.debug(dis_in_clause);
350: end if;
351: start_pos:= start_pos + 200;
352: end_pos := end_pos + 200;
353: dis_in_clause := substrb(in_clause, start_pos, end_pos);

Line 356: arp_util_tax.debug('');

352: end_pos := end_pos + 200;
353: dis_in_clause := substrb(in_clause, start_pos, end_pos);
354: end loop;
355: if pg_debug='Y' then
356: arp_util_tax.debug('');
357: end if;
358:
359: --
360: -- Prepareing Dynamic SQL to update overlapped records.

Line 367: arp_util_tax.debug('Update statement is <><><><><><>');

363: prog_loc := 7;
364: sqlstmt := 'update ar_tax_interface set status =' ||''''||
365: 'IGNORED-NARROWER-ZIP'||''''||' where interface_line_id in ('||in_clause||')';
366: if pg_debug='Y' then
367: arp_util_tax.debug('Update statement is <><><><><><>');
368: arp_util_tax.debug(substrb(sqlstmt, 1, 250));
369: end if;
370:
371: dbms_sql.parse(l_cursor, sqlstmt, dbms_sql.native);

Line 368: arp_util_tax.debug(substrb(sqlstmt, 1, 250));

364: sqlstmt := 'update ar_tax_interface set status =' ||''''||
365: 'IGNORED-NARROWER-ZIP'||''''||' where interface_line_id in ('||in_clause||')';
366: if pg_debug='Y' then
367: arp_util_tax.debug('Update statement is <><><><><><>');
368: arp_util_tax.debug(substrb(sqlstmt, 1, 250));
369: end if;
370:
371: dbms_sql.parse(l_cursor, sqlstmt, dbms_sql.native);
372: prog_loc := 8;

Line 384: arp_util_tax.debug('ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE('||': '||

380: prog_loc := 10;
381:
382: select count(*) into sel_count from ar_tax_interface where status = 'IGNORED-NARROWER-ZIP';
383: if pg_debug='Y' then
384: arp_util_tax.debug('ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE('||': '||
385: to_char(sel_count)||' :'||to_char(sysdate, 'YYYY-MON-DD: HH:MI:SS')||')-');
386: end if;
387: EXCEPTION
388: WHEN OTHERS THEN

Line 390: arp_util_tax.debug('Error Occured in ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE'||to_char(prog_loc));

386: end if;
387: EXCEPTION
388: WHEN OTHERS THEN
389: if pg_debug='Y' then
390: arp_util_tax.debug('Error Occured in ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE'||to_char(prog_loc));
391: arp_util_tax.debug('SQL CODE is :'||to_char(SQLCODE));
392: arp_util_tax.debug('SQL ERRM is :'||SQLERRM);
393: end if;
394:

Line 391: arp_util_tax.debug('SQL CODE is :'||to_char(SQLCODE));

387: EXCEPTION
388: WHEN OTHERS THEN
389: if pg_debug='Y' then
390: arp_util_tax.debug('Error Occured in ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE'||to_char(prog_loc));
391: arp_util_tax.debug('SQL CODE is :'||to_char(SQLCODE));
392: arp_util_tax.debug('SQL ERRM is :'||SQLERRM);
393: end if;
394:
395: if prog_loc in (7, 8) then

Line 392: arp_util_tax.debug('SQL ERRM is :'||SQLERRM);

388: WHEN OTHERS THEN
389: if pg_debug='Y' then
390: arp_util_tax.debug('Error Occured in ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE'||to_char(prog_loc));
391: arp_util_tax.debug('SQL CODE is :'||to_char(SQLCODE));
392: arp_util_tax.debug('SQL ERRM is :'||SQLERRM);
393: end if;
394:
395: if prog_loc in (7, 8) then
396: dbms_sql.close_cursor( l_cursor );

Line 791: arp_util_tax.debug( 'INTERFACE: ' || to_char( interface.level, 0)

787: interface.start_date := trunc( interface.start_date );
788: interface.end_date := arp_standard.ceil( interface.end_date );
789:
790: if pg_debug='Y' then
791: arp_util_tax.debug( 'INTERFACE: ' || to_char( interface.level, 0)
792: || '.' || interface.location_value || ' '
793: || to_char( interface.start_date, 'DD-MON-YYYY HH24:MI:SS') ||
794: ' .. ' || to_char(interface.end_date, 'DD-MON-YYYY HH24:MI:SS' ) ||
795: ' =' || to_char( interface.tax_rate, '990.00' ) );

Line 987: arp_util_tax.debug( 'OVERLAP: ' || to_char( rates.start_date, 'DD-MON-YYYY' ) ||

983:
984: /* Overlapping data Exists */
985:
986: if pg_debug='Y' then
987: arp_util_tax.debug( 'OVERLAP: ' || to_char( rates.start_date, 'DD-MON-YYYY' ) ||
988: ' .. ' || to_char( rates.end_date, 'DD-MON-YYYY' ) ||
989: ' =' || to_char( rates.tax_rate, '990.00' ) );
990:
991: arp_util_tax.debug('');

Line 991: arp_util_tax.debug('');

987: arp_util_tax.debug( 'OVERLAP: ' || to_char( rates.start_date, 'DD-MON-YYYY' ) ||
988: ' .. ' || to_char( rates.end_date, 'DD-MON-YYYY' ) ||
989: ' =' || to_char( rates.tax_rate, '990.00' ) );
990:
991: arp_util_tax.debug('');
992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||

Line 992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));

988: ' .. ' || to_char( rates.end_date, 'DD-MON-YYYY' ) ||
989: ' =' || to_char( rates.tax_rate, '990.00' ) );
990:
991: arp_util_tax.debug('');
992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));

Line 993: arp_util_tax.debug('Value: '||interface.location_value);

989: ' =' || to_char( rates.tax_rate, '990.00' ) );
990:
991: arp_util_tax.debug('');
992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||

Line 994: arp_util_tax.debug('Postal Code Old: '||

990:
991: arp_util_tax.debug('');
992: arp_util_tax.debug('Segment ID: '||to_char(location_id(current_level)));
993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||

Line 997: arp_util_tax.debug('Postal Code New: '||

993: arp_util_tax.debug('Value: '||interface.location_value);
994: arp_util_tax.debug('Postal Code Old: '||
995: nvl(rates.from_postal_code,arp_standard.sysparm.from_postal_code) ||
996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||
1001: ' - '||to_char(trunc(rates.end_date)));

Line 1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||

996: ' - '||nvl(rates.to_postal_code,arp_standard.sysparm.to_postal_code));
997: arp_util_tax.debug('Postal Code New: '||
998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||
1001: ' - '||to_char(trunc(rates.end_date)));
1002: arp_util_tax.debug('Effective Date New: '||to_char(trunc(interface.start_date))||
1003: ' - '||to_char(trunc(interface.end_date)));
1004: end if;

Line 1002: arp_util_tax.debug('Effective Date New: '||to_char(trunc(interface.start_date))||

998: nvl(interface.from_postal_code,arp_standard.sysparm.from_postal_code) ||
999: ' - '||nvl(interface.to_postal_code,arp_standard.sysparm.to_postal_code));
1000: arp_util_tax.debug('Effective Date Old: '||to_char(trunc(rates.start_date))||
1001: ' - '||to_char(trunc(rates.end_date)));
1002: arp_util_tax.debug('Effective Date New: '||to_char(trunc(interface.start_date))||
1003: ' - '||to_char(trunc(interface.end_date)));
1004: end if;
1005:
1006: /* Checking Postal Code Range */

Line 1009: --arp_util_tax.debug('Interface postal code range identical to existing one');

1005:
1006: /* Checking Postal Code Range */
1007: IF ( rates.from_postal_code = interface.from_postal_code ) and
1008: ( rates.to_postal_code = interface.to_postal_code ) THEN
1009: --arp_util_tax.debug('Interface postal code range identical to existing one');
1010:
1011: /* Checking Date Range */
1012: IF ( trunc(rates.start_date) = trunc(interface.start_date) ) and
1013: ( arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) ) THEN

Line 1024: arp_util_tax.debug('Rate is smaller than existing one');

1020: safest amount. */
1021: ACTION := 'ALREADY-EXISTS';
1022:
1023: if pg_debug='Y' then
1024: arp_util_tax.debug('Rate is smaller than existing one');
1025: end if;
1026:
1027: ELSE
1028:

Line 1060: arp_util_tax.debug('Everythings is the same');

1056: ( nvl(rates.override_rate10,-99) = nvl(interface.override_rate10,-99)) THEN
1057:
1058: ACTION := 'ALREADY-EXISTS';
1059: if pg_debug='Y' then
1060: arp_util_tax.debug('Everythings is the same');
1061: end if;
1062: ELSE
1063: ACTION := 'RATE-ADJUST';
1064: rates.tax_rate := interface.tax_rate;

Line 1066: arp_util_tax.debug('Rate is bigger than existing one');

1062: ELSE
1063: ACTION := 'RATE-ADJUST';
1064: rates.tax_rate := interface.tax_rate;
1065: if pg_debug='Y' then
1066: arp_util_tax.debug('Rate is bigger than existing one');
1067: end if;
1068: END IF; -- Checking Tax Rate and it's attributes
1069:
1070: END IF; -- Compare Tax Rates

Line 1079: arp_util_tax.debug('Date ranges are overlapping');

1075: rates.end_date,
1076: interface.start_date,
1077: interface.end_date );
1078: if pg_debug='Y' then
1079: arp_util_tax.debug('Date ranges are overlapping');
1080: end if;
1081:
1082: END IF; -- Checking Date Range
1083:

Line 1088: arp_util_tax.debug('Postal Code Range in interface table is Narrower than existing one.');

1084: ELSIF ( ( interface.from_postal_code >= rates.from_postal_code ) and
1085: ( interface.to_postal_code <= rates.to_postal_code ) ) THEN
1086:
1087: if pg_debug='Y' then
1088: arp_util_tax.debug('Postal Code Range in interface table is Narrower than existing one.');
1089: end if;
1090:
1091: IF trunc(rates.start_date) = trunc(interface.start_date) and
1092: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN

Line 1095: arp_util_tax.debug('Narrower zip range with same geocode and dates same');

1091: IF trunc(rates.start_date) = trunc(interface.start_date) and
1092: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN
1093: ACTION := 'ZIP-RANGE-UPDATED'; -- logic to end date broader range later in the code
1094: if pg_debug='Y' then
1095: arp_util_tax.debug('Narrower zip range with same geocode and dates same');
1096: end if;
1097:
1098: ELSE
1099: ACTION := date_adjust( rates.start_date,

Line 1104: arp_util_tax.debug('Narrower zip range with same geocode and dates different');

1100: rates.end_date,
1101: interface.start_date,
1102: interface.end_date );
1103: if pg_debug='Y' then
1104: arp_util_tax.debug('Narrower zip range with same geocode and dates different');
1105: end if;
1106:
1107:
1108: IF ACTION = 'ALREADY-EXISTS' THEN

Line 1120: arp_util_tax.debug('Postal Code Range in AR_LOCATION_RATES is included in the one in Interface.');

1116: END IF; -- Checking Date Range
1117:
1118: ELSE
1119: if pg_debug='Y' then
1120: arp_util_tax.debug('Postal Code Range in AR_LOCATION_RATES is included in the one in Interface.');
1121: end if;
1122:
1123: /* Checking Date Range */
1124: IF trunc(rates.start_date) = trunc(interface.start_date) and

Line 1129: arp_util_tax.debug('Zip ranges are overlapping');

1125: arp_standard.ceil(rates.end_date) = arp_standard.ceil(interface.end_date) THEN
1126: ACTION := 'ZIP-RANGE-UPDATED';
1127:
1128: if pg_debug='Y' then
1129: arp_util_tax.debug('Zip ranges are overlapping');
1130: end if;
1131:
1132: ELSE
1133: ACTION := date_adjust( rates.start_date,

Line 1138: arp_util_tax.debug('Zip and date ranges are overlapping');

1134: rates.end_date,
1135: interface.start_date,
1136: interface.end_date );
1137: if pg_debug='Y' then
1138: arp_util_tax.debug('Zip and date ranges are overlapping');
1139: end if;
1140: END IF; -- Checking Date Range
1141: END IF; -- Checking Postal Code Range
1142:

Line 1145: arp_util_tax.debug( 'UPDATE old data: ' || rates.location_rate_id || ' ' ||

1141: END IF; -- Checking Postal Code Range
1142:
1143: if action = 'UPDATE-INSERT' then
1144: if pg_debug='Y' then
1145: arp_util_tax.debug( 'UPDATE old data: ' || rates.location_rate_id || ' ' ||
1146: rates.from_postal_code || '->' || rates.to_postal_code || ' ' ||
1147: rates.start_date || '->' || rates.end_date ||
1148: ' = ' || rates.tax_rate );
1149: end if;

Line 1169: arp_util_tax.debug( 'UPDATE RATE-ADJUST old data: ' || rates.location_rate_id || ' ' ||

1165: --exit when true;
1166:
1167: elsif action = 'RATE-ADJUST' then
1168: if pg_debug='Y' then
1169: arp_util_tax.debug( 'UPDATE RATE-ADJUST old data: ' || rates.location_rate_id || ' ' ||
1170: rates.from_postal_code || '->' || rates.to_postal_code || ' ' ||
1171: rates.start_date || '->' || rates.end_date ||
1172: ' = ' || rates.tax_rate );
1173: end if;

Line 1218: arp_util_tax.debug( 'ZIP-RANGE-UPDATED old data: ' || rates.location_rate_id || ' ' ||

1214: /* BUGFIX 1965591 : Continue in loop till all overlapping records handled */
1215: --exit when true;
1216: elsif action = 'ZIP-RANGE-UPDATED' then
1217: if pg_debug='Y' then
1218: arp_util_tax.debug( 'ZIP-RANGE-UPDATED old data: ' || rates.location_rate_id || ' ' ||
1219: rates.from_postal_code || '->' || rates.to_postal_code || ' ' ||
1220: rates.start_date || '->' || rates.end_date ||
1221: ' = ' || rates.tax_rate );
1222:

Line 1274: arp_util_tax.debug('Action: '||action);

1270:
1271: end if;
1272:
1273: if pg_debug='Y' then
1274: arp_util_tax.debug('Action: '||action);
1275: end if;
1276:
1277: if action = 'INSERT' or
1278: action = 'UPDATE-INSERT' or

Line 1282: arp_util_tax.debug( 'Row inserted: ' || location_id(current_level) || ' ' ||

1278: action = 'UPDATE-INSERT' or
1279: action = 'NEW-LOCATION-INSERT' then
1280:
1281: if pg_debug='Y' then
1282: arp_util_tax.debug( 'Row inserted: ' || location_id(current_level) || ' ' ||
1283: interface.from_postal_code || '->' || interface.to_postal_code || ' ' ||
1284: interface.start_date || '->' || interface.end_date );
1285: end if;
1286:

Line 1364: arp_util_tax.debug( 'ACTION: ' || action || ' Location Segment ID = ' || this_location );

1360:
1361: end if;
1362:
1363: if pg_debug='Y' then
1364: arp_util_tax.debug( 'ACTION: ' || action || ' Location Segment ID = ' || this_location );
1365: end if;
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN

Line 1373: arp_util_tax.debug(sqlcode);

1369: BEGIN
1370: error_code := sqlcode;
1371: error_text := sqlerrm;
1372: if pg_debug='Y' then
1373: arp_util_tax.debug(sqlcode);
1374: arp_util_tax.debug(sqlerrm);
1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );
1376: end if;
1377:

Line 1374: arp_util_tax.debug(sqlerrm);

1370: error_code := sqlcode;
1371: error_text := sqlerrm;
1372: if pg_debug='Y' then
1373: arp_util_tax.debug(sqlcode);
1374: arp_util_tax.debug(sqlerrm);
1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );
1376: end if;
1377:
1378: if error_code = arp_standard.ar_error_number then

Line 1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );

1371: error_text := sqlerrm;
1372: if pg_debug='Y' then
1373: arp_util_tax.debug(sqlcode);
1374: arp_util_tax.debug(sqlerrm);
1375: arp_util_tax.debug( 'ERROR: ' || action || ' Location Segment ID = ' || this_location );
1376: end if;
1377:
1378: if error_code = arp_standard.ar_error_number then
1379: error_text := arp_standard.fnd_message( arp_standard.md_msg_text );