1345:
1346: -- do we need to check for GDF changes???
1347:
1348: -- IF PG_DEBUG = 'Y' THEN
1349: arp_util_tax.debug('p_inventory_item_changed : '||
1350: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1351: arp_util_tax.debug('p_memo_line_changed : '||
1352: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1353: arp_util_tax.debug('p_quantity_changed : '||
1347:
1348: -- IF PG_DEBUG = 'Y' THEN
1349: arp_util_tax.debug('p_inventory_item_changed : '||
1350: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1351: arp_util_tax.debug('p_memo_line_changed : '||
1352: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1353: arp_util_tax.debug('p_quantity_changed : '||
1354: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1349: arp_util_tax.debug('p_inventory_item_changed : '||
1350: arp_trx_util.boolean_to_varchar2(l_inventory_item_changed));
1351: arp_util_tax.debug('p_memo_line_changed : '||
1352: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1353: arp_util_tax.debug('p_quantity_changed : '||
1354: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1351: arp_util_tax.debug('p_memo_line_changed : '||
1352: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1353: arp_util_tax.debug('p_quantity_changed : '||
1354: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1352: arp_trx_util.boolean_to_varchar2(l_memo_line_changed));
1353: arp_util_tax.debug('p_quantity_changed : '||
1354: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1353: arp_util_tax.debug('p_quantity_changed : '||
1354: arp_trx_util.boolean_to_varchar2(l_quantity_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1361: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1355: arp_util_tax.debug('p_extended_amount_changed : ' ||
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1361: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1362: arp_util_tax.debug('p_warehouse_flag_changed : '||
1363: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1356: arp_trx_util.boolean_to_varchar2(l_extended_amount_changed )); arp_util_tax.debug('p_tax_exempt_flag_changed : ' ||
1357: arp_trx_util.boolean_to_varchar2(l_tax_exempt_flag_changed )); arp_util_tax.debug('p_tax_exempt_reason_changed : ' ||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1361: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1362: arp_util_tax.debug('p_warehouse_flag_changed : '||
1363: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1364: arp_util_tax.debug('p_ship_to_changed : '||
1358: arp_trx_util.boolean_to_varchar2(l_tax_exempt_reason_changed ));
1359: arp_util_tax.debug('p_tax_exempt_cert_changed : ' ||
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1361: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1362: arp_util_tax.debug('p_warehouse_flag_changed : '||
1363: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1364: arp_util_tax.debug('p_ship_to_changed : '||
1365: arp_trx_util.boolean_to_varchar2(l_ship_to_changed));
1366: -- END IF;
1360: arp_trx_util.boolean_to_varchar2(l_tax_exempt_cert_changed )); arp_util_tax.debug('p_tax_code_changed : '||
1361: arp_trx_util.boolean_to_varchar2(l_tax_code_changed));
1362: arp_util_tax.debug('p_warehouse_flag_changed : '||
1363: arp_trx_util.boolean_to_varchar2(l_warehouse_flag_changed));
1364: arp_util_tax.debug('p_ship_to_changed : '||
1365: arp_trx_util.boolean_to_varchar2(l_ship_to_changed));
1366: -- END IF;
1367:
1368: p_inventory_item_changed := l_inventory_item_changed;
1445: EXCEPTION
1446: WHEN OTHERS
1447: THEN
1448: IF PG_DEBUG = 'Y' THEN
1449: arp_util_tax.debug( 'EXCEPTION: arp_etax_services_pkg.delete_tax_f_ctl_id()');
1450: END IF;
1451: RAISE;
1452:
1453: END delete_tax_f_ctl_id;