DBA Data[Home] [Help]

APPS.ARP_STAX_MINUS99 dependencies on FND_PROFILE

Line 41: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

37: tax_exempt_info_tbl tax_exempt_info_rec_tbl;
38:
39: pg_max_index BINARY_INTEGER :=0;
40:
41: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
42: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
43:
44: /*-------------------------------------------------------------------------+
45: | PUBLIC FUNCTION |

Line 42: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

38:
39: pg_max_index BINARY_INTEGER :=0;
40:
41: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
42: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
43:
44: /*-------------------------------------------------------------------------+
45: | PUBLIC FUNCTION |
46: | ins_sales_tax |

Line 110: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

106: sales_tax_id NUMBER;
107:
108:
109: BEGIN
110: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
111: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
112: IF PG_DEBUG = 'Y' THEN
113: arp_util_tax.debug( '>> INS_SALES_TAX' );
114: END IF;

Line 111: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

107:
108:
109: BEGIN
110: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
111: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
112: IF PG_DEBUG = 'Y' THEN
113: arp_util_tax.debug( '>> INS_SALES_TAX' );
114: END IF;
115:

Line 248: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

244: ccids NUMBER := 0;
245: do_transfer_flag BOOLEAN;
246: BEGIN
247:
248: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
249: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
250:
251: IF PG_DEBUG = 'Y' THEN
252: arp_util_tax.debug( '>> IMPLEMENT_TRANSFER_RATES' );

Line 249: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

245: do_transfer_flag BOOLEAN;
246: BEGIN
247:
248: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
249: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
250:
251: IF PG_DEBUG = 'Y' THEN
252: arp_util_tax.debug( '>> IMPLEMENT_TRANSFER_RATES' );
253: END IF;

Line 436: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

432: and NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99);
433:
434: cc sel_cc%ROWTYPE;
435: BEGIN
436: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
437: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
438: IF PG_DEBUG = 'Y' THEN
439: arp_util_tax.debug( '>> SITE_USE_SALES_TAX( ' || address_id || ' )' );
440: END IF;

Line 437: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

433:
434: cc sel_cc%ROWTYPE;
435: BEGIN
436: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
437: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
438: IF PG_DEBUG = 'Y' THEN
439: arp_util_tax.debug( '>> SITE_USE_SALES_TAX( ' || address_id || ' )' );
440: END IF;
441:

Line 500: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

496:
497:
498: PROCEDURE Initialise_Transfer_Rates is
499: BEGIN
500: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
501: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
502: if transfer_rates_initialised
503: then
504: arp_standard.fnd_message( 'AR_TRIG_ALREADY_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );

Line 501: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

497:
498: PROCEDURE Initialise_Transfer_Rates is
499: BEGIN
500: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
501: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
502: if transfer_rates_initialised
503: then
504: arp_standard.fnd_message( 'AR_TRIG_ALREADY_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );
505:

Line 700: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

696: --
697: dummy varchar2(30);
698: --
699: BEGIN
700: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
701: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
702: IF PG_DEBUG = 'Y' THEN
703: arp_util_tax.debug( '>> POPULATE_SALES_TAX ( ' || statement_type || ', '
704: || location_ccid || ' )' );

Line 701: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

697: dummy varchar2(30);
698: --
699: BEGIN
700: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
701: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
702: IF PG_DEBUG = 'Y' THEN
703: arp_util_tax.debug( '>> POPULATE_SALES_TAX ( ' || statement_type || ', '
704: || location_ccid || ' )' );
705: END IF;

Line 936: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

932:
933:
934: PROCEDURE propogate_sales_tax IS
935: BEGIN
936: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
937: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
938:
939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug( '>> PROPOGATE_SALES_TAX' );

Line 937: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

933:
934: PROCEDURE propogate_sales_tax IS
935: BEGIN
936: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
937: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
938:
939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug( '>> PROPOGATE_SALES_TAX' );
941: END IF;

Line 985: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

981: --
982: dummy varchar2(30);
983: --
984: BEGIN
985: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
986: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
987: ARP_UTIL_TAX.DEBUG( '>> PURGE_SALES_TAX' );
988:
989: FOR tax in sel_rates_c

Line 986: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

982: dummy varchar2(30);
983: --
984: BEGIN
985: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
986: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
987: ARP_UTIL_TAX.DEBUG( '>> PURGE_SALES_TAX' );
988:
989: FOR tax in sel_rates_c
990: LOOP

Line 1073: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

1069: previous_parent_line_id number := 0;
1070: new_line_number number := 0;
1071:
1072: BEGIN
1073: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1074: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1075:
1076: for trx_line in c_tax_lines( customer_trx_id, trx_type )
1077: Loop

Line 1074: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1070: new_line_number number := 0;
1071:
1072: BEGIN
1073: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1074: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1075:
1076: for trx_line in c_tax_lines( customer_trx_id, trx_type )
1077: Loop
1078: if trx_line.link_to_cust_trx_line_id <> previous_parent_line_id

Line 1128: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

1124: and g.set_of_books_id = p.set_of_books_id
1125: and g.accounted_period_type = p.period_type;
1126:
1127: begin
1128: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1129: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1130:
1131:
1132: IF PG_DEBUG = 'Y' THEN

Line 1129: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1125: and g.accounted_period_type = p.period_type;
1126:
1127: begin
1128: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1129: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1130:
1131:
1132: IF PG_DEBUG = 'Y' THEN
1133: arp_util_tax.debug('period_date_range ( '||to_char(trx_date)||')');

Line 1418: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

1414: dummy dual.dummy%type;
1415: l_display_order NUMBER;
1416:
1417: BEGIN
1418: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1419: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1420:
1421: ARP_UTIL_TAX.DEBUG( '>> FIND_TAX_EXEMPTION_ID: ' || bill_to_customer_id || ', ' ||
1422: ship_to_site_id || ', ' || tax_code || ', ' ||

Line 1419: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1415: l_display_order NUMBER;
1416:
1417: BEGIN
1418: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1419: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1420:
1421: ARP_UTIL_TAX.DEBUG( '>> FIND_TAX_EXEMPTION_ID: ' || bill_to_customer_id || ', ' ||
1422: ship_to_site_id || ', ' || tax_code || ', ' ||
1423: inventory_item_id || ', ' || to_char(trx_date, 'DD-MON-YYYY') || ', ' ||

Line 1996: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

1992: begin
1993: ARP_STAX_MINUS99.loc_rate := ARP_STAX_MINUS99.loc_rate + 1;
1994: ARP_STAX_MINUS99.location_segment_id(ARP_STAX_MINUS99.loc_rate) :=
1995: loc_segment_id;
1996: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1997: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1998:
1999: end populate_segment_array;
2000:

Line 1997: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1993: ARP_STAX_MINUS99.loc_rate := ARP_STAX_MINUS99.loc_rate + 1;
1994: ARP_STAX_MINUS99.location_segment_id(ARP_STAX_MINUS99.loc_rate) :=
1995: loc_segment_id;
1996: -- PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
1997: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1998:
1999: end populate_segment_array;
2000:
2001: END ARP_STAX_MINUS99;