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

Line 165: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(+) ');

161: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
162: begin
163:
164: IF PG_DEBUG = 'Y' THEN
165: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(+) ');
166: arp_util_tax.debug(' Before inserting into AR_LOCATION_VALUES_OLD ');
167: END IF;
168:
169: -- MOAC

Line 166: arp_util_tax.debug(' Before inserting into AR_LOCATION_VALUES_OLD ');

162: begin
163:
164: IF PG_DEBUG = 'Y' THEN
165: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(+) ');
166: arp_util_tax.debug(' Before inserting into AR_LOCATION_VALUES_OLD ');
167: END IF;
168:
169: -- MOAC
170: -- need to select org_id

Line 247: arp_util_tax.debug(' After inserting into AR_LOCATION_VALUES_OLD ');

243: X_PROGRAM_UPDATE_DATE,
244: X_ORG_ID
245: );
246: IF PG_DEBUG = 'Y' THEN
247: arp_util_tax.debug(' After inserting into AR_LOCATION_VALUES_OLD ');
248: END IF;
249:
250: /* MOAC
251: Commented out as X_ORG_ID is passed from UI as part of the parameter.

Line 268: arp_util_tax.debug(' Before inserting into AR_LOCATION_ACCOUNTS ');

264:
265:
266: if X_TAX_ACCOUNT_CCID is not null then
267: IF PG_DEBUG = 'Y' THEN
268: arp_util_tax.debug(' Before inserting into AR_LOCATION_ACCOUNTS ');
269: END IF;
270: insert into AR_LOCATION_ACCOUNTS_ALL (
271: LOCATION_VALUE_ACCOUNT_ID,
272: LOCATION_SEGMENT_ID,

Line 318: arp_util_tax.debug(' After inserting into AR_LOCATION_ACCOUNTS ');

314: X_PROGRAM_ID,
315: X_PROGRAM_UPDATE_DATE,
316: X_ORG_ID);
317: IF PG_DEBUG = 'Y' THEN
318: arp_util_tax.debug(' After inserting into AR_LOCATION_ACCOUNTS ');
319: END IF;
320:
321: org_id_tab.delete;
322: loc_structure_id_tab.delete;

Line 429: arp_util_tax.debug('Before inserting into AR_LOCATION_ACCOUNTS ('||to_char(organization_id_tab(i))||')' );

425:
426: if organization_id_tab(i) <> X_ORG_ID then
427:
428: IF PG_DEBUG = 'Y' THEN
429: arp_util_tax.debug('Before inserting into AR_LOCATION_ACCOUNTS ('||to_char(organization_id_tab(i))||')' );
430: END IF;
431: insert into ar_location_accounts_all
432: ( location_value_account_id,
433: location_segment_id,

Line 478: arp_util_tax.debug('After inserting into AR_LOCATION_ACCOUNTS ');

474: program_update_date_tab(i),
475: last_update_login_tab(i),
476: organization_id_tab(i) );
477: IF PG_DEBUG = 'Y' THEN
478: arp_util_tax.debug('After inserting into AR_LOCATION_ACCOUNTS ');
479: END IF;
480: end if;
481: end loop;
482: end if;

Line 493: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(-) ');

489: end if;
490: close c;
491:
492: IF PG_DEBUG = 'Y' THEN
493: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(-) ');
494: END IF;
495:
496: end INSERT_ROW;
497:

Line 619: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(+) ');

615: acctinfo c1%rowtype;
616: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
617: begin
618: IF PG_DEBUG = 'Y' THEN
619: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(+) ');
620: END IF;
621: open c;
622: fetch c into recinfo;
623: if (c%notfound) then

Line 626: arp_util_tax.debug(' No record found for AR_LOCATION_VALUES_OLD ');

622: fetch c into recinfo;
623: if (c%notfound) then
624: close c;
625: IF PG_DEBUG = 'Y' THEN
626: arp_util_tax.debug(' No record found for AR_LOCATION_VALUES_OLD ');
627: END IF;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: app_exception.raise_exception;
630: end if;

Line 694: arp_util_tax.debug(' No record found for AR_LOCATION_ACCOUNTS ');

690: -- Bugfix 1712826: Do not raise exception, because there will be a row
691: -- in AR_LOCATION_ACCOUNTS only for one out of State/County/CITY
692: -- app_exception.raise_exception;
693: IF PG_DEBUG = 'Y' THEN
694: arp_util_tax.debug(' No record found for AR_LOCATION_ACCOUNTS ');
695: END IF;
696: else
697: close c1;
698: if ( (acctinfo.LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID)

Line 747: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(-) ');

743: end if;
744: end if; -- c1%notfound
745:
746: IF PG_DEBUG = 'Y' THEN
747: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(-) ');
748: END IF;
749: return;
750: end LOCK_ROW;
751:

Line 800: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(+) ');

796: ) is
797: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
798: begin
799: IF PG_DEBUG = 'Y' THEN
800: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(+) ');
801: END IF;
802: IF PG_DEBUG = 'Y' THEN
803: arp_util_tax.debug(' Before updating AR_LOCATION_VALUES_OLD ');
804: END IF;

Line 803: arp_util_tax.debug(' Before updating AR_LOCATION_VALUES_OLD ');

799: IF PG_DEBUG = 'Y' THEN
800: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(+) ');
801: END IF;
802: IF PG_DEBUG = 'Y' THEN
803: arp_util_tax.debug(' Before updating AR_LOCATION_VALUES_OLD ');
804: END IF;
805: /* -- for bug #4561754
806: update AR_LOCATION_VALUES set
807: LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID,

Line 842: arp_util_tax.debug(' After updating AR_LOCATION_VALUES_OLD ');

838: PROGRAM_ID = X_PROGRAM_ID,
839: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
840: where LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
841: IF PG_DEBUG = 'Y' THEN
842: arp_util_tax.debug(' After updating AR_LOCATION_VALUES_OLD ');
843: END IF;
844:
845: if (sql%notfound) then
846: IF PG_DEBUG = 'Y' THEN

Line 847: arp_util_tax.debug('updating AR_LOCATION_VALUES_OLD: No Data Found !! ');

843: END IF;
844:
845: if (sql%notfound) then
846: IF PG_DEBUG = 'Y' THEN
847: arp_util_tax.debug('updating AR_LOCATION_VALUES_OLD: No Data Found !! ');
848: END IF;
849: raise no_data_found;
850: end if;
851: */

Line 854: arp_util_tax.debug(' Before updating AR_LOCATION_ACCOUNTS ');

850: end if;
851: */
852: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
853: IF PG_DEBUG = 'Y' THEN
854: arp_util_tax.debug(' Before updating AR_LOCATION_ACCOUNTS ');
855: END IF;
856: UPDATE AR_LOCATION_ACCOUNTS_ALL set
857: LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID,
858: LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID,

Line 882: arp_util_tax.debug(' After updating AR_LOCATION_ACCOUNTS ');

878: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
879: WHERE LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;
880:
881: IF PG_DEBUG = 'Y' THEN
882: arp_util_tax.debug(' After updating AR_LOCATION_ACCOUNTS ');
883: END IF;
884: end if;
885: /*
886: if (sql%notfound) then

Line 888: arp_util_tax.debug('updating AR_LOCATION_ACCOUNTS: No Data Found!! ');

884: end if;
885: /*
886: if (sql%notfound) then
887: IF PG_DEBUG = 'Y' THEN
888: arp_util_tax.debug('updating AR_LOCATION_ACCOUNTS: No Data Found!! ');
889: END IF;
890: raise no_data_found;
891: end if;
892: */

Line 894: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(-) ');

890: raise no_data_found;
891: end if;
892: */
893: IF PG_DEBUG = 'Y' THEN
894: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(-) ');
895: END IF;
896: end UPDATE_ROW;
897:
898: procedure DELETE_ROW (

Line 906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');

902: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
903: begin
904:
905: IF PG_DEBUG = 'Y' THEN
906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');
907: END IF;
908: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
909: IF PG_DEBUG = 'Y' THEN
910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');

Line 910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');

906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');
907: END IF;
908: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
909: IF PG_DEBUG = 'Y' THEN
910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');
911: END IF;
912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL
913: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
914: AND LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;

Line 916: arp_util_tax.debug(' After deleting AR_LOCATION_ACCOUNTS ');

912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL
913: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
914: AND LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;
915: IF PG_DEBUG = 'Y' THEN
916: arp_util_tax.debug(' After deleting AR_LOCATION_ACCOUNTS ');
917: END IF;
918: end if;
919:
920: if (sql%notfound) then

Line 926: arp_util_tax.debug(' Before deleting AR_LOCATION_VALUES_OLD ');

922: end if;
923:
924: if X_LOCATION_SEGMENT_ID is not null then
925: IF PG_DEBUG = 'Y' THEN
926: arp_util_tax.debug(' Before deleting AR_LOCATION_VALUES_OLD ');
927: END IF;
928: DELETE FROM AR_LOCATION_VALUES_OLD
929: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
930: IF PG_DEBUG = 'Y' THEN

Line 931: arp_util_tax.debug(' After deleting AR_LOCATION_VALUES_OLD ');

927: END IF;
928: DELETE FROM AR_LOCATION_VALUES_OLD
929: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
930: IF PG_DEBUG = 'Y' THEN
931: arp_util_tax.debug(' After deleting AR_LOCATION_VALUES_OLD ');
932: END IF;
933: end if;
934:
935: if (sql%notfound) then

Line 940: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(-) ');

936: raise no_data_found;
937: end if;
938:
939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(-) ');
941: END IF;
942: end DELETE_ROW;
943:
944: end AR_LOCVS_PKG;