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.ZX_JG_EXTRACT_PKG dependencies on FND_LOG

Line 41: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

37: g_acct_seg_desc_tbl t_acct_seg_desc_tbl;
38:
39: PG_DEBUG VARCHAR2(1);
40: g_current_runtime_level NUMBER ;
41: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
42: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
43: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
44: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45: g_error_buffer VARCHAR2(100);

Line 42: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

38:
39: PG_DEBUG VARCHAR2(1);
40: g_current_runtime_level NUMBER ;
41: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
42: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
43: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
44: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45: g_error_buffer VARCHAR2(100);
46:

Line 43: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

39: PG_DEBUG VARCHAR2(1);
40: g_current_runtime_level NUMBER ;
41: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
42: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
43: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
44: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45: g_error_buffer VARCHAR2(100);
46:
47:

Line 44: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

40: g_current_runtime_level NUMBER ;
41: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
42: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
43: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
44: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
45: g_error_buffer VARCHAR2(100);
46:
47:
48:

Line 139: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()+',

135:
136: BEGIN
137:
138: IF (g_level_procedure >= g_current_runtime_level ) THEN
139: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()+',
140: 'prorate_tax');
141: END IF;
142:
143: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',

140: 'prorate_tax');
141: END IF;
142:
143: IF (g_level_procedure >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
145: 'prorate_tax='||To_char(p_tax_total)||', Acctd tax='||To_char(p_tax_funcl_curr_total));
146: END IF;
147:
148: IF p_current_line = p_last_line THEN

Line 161: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',

157: alloc_tax_funcl_curr := 0;
158:
159: FOR i IN p_current_line..p_last_line-1 LOOP
160: IF (g_level_procedure >= g_current_runtime_level ) THEN
161: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
162: 'Percent='||To_char(Round(p_percent_tbl(i)*100, 3))||
163: ', Precision='||To_char(p_precision_tbl(i))||
164: ', Mimimum Accountable Unit='||To_char(p_minimum_accountable_unit_tbl(i)));
165: END IF;

Line 182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',

178: p_tax_amt_tbl(i) := currency_round(full_tax, p_precision_tbl(i), p_minimum_accountable_unit_tbl(i));
179: p_tax_amt_funcl_curr_tbl(i) := currency_round(full_tax_funcl_curr, p_func_precision, p_func_min_account_unit);
180:
181: IF (g_level_procedure >= g_current_runtime_level ) THEN
182: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
183: 'Tax Amount='||To_char(p_tax_amt_tbl(i))||', Acctd Tax Amount='||To_char(p_tax_amt_funcl_curr_tbl(i)));
184: END IF;
185:
186: rounderr := full_tax - p_tax_amt_tbl(i);

Line 198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',

194: p_tax_amt_tbl(p_last_line) := p_tax_total - alloc_tax;
195: p_tax_amt_funcl_curr_tbl(p_last_line) := p_tax_funcl_curr_total - alloc_tax_funcl_curr;
196:
197: IF (g_level_procedure >= g_current_runtime_level ) THEN
198: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
199: 'Tax Amount='||To_char(p_tax_amt_tbl(p_last_line))||', Acctd Tax Amount='||To_char(p_tax_amt_funcl_curr_tbl(p_last_line)));
200: END IF;
201:
202: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 203: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()-',

199: 'Tax Amount='||To_char(p_tax_amt_tbl(p_last_line))||', Acctd Tax Amount='||To_char(p_tax_amt_funcl_curr_tbl(p_last_line)));
200: END IF;
201:
202: IF (g_level_procedure >= g_current_runtime_level ) THEN
203: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()-',
204: 'prorate_tax');
205: END IF;
206:
207: END prorate_tax;

Line 240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',

236:
237: BEGIN
238:
239: IF (g_level_procedure >= g_current_runtime_level ) THEN
240: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
241: 'insert_row API call ');
242: END IF;
243:
244: j := 0;

Line 255: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',

251: */
252: FOR i in p_detail_tax_line_id_tbl.first..p_detail_tax_line_id_tbl.last LOOP
253:
254: /* IF (g_level_procedure >= g_current_runtime_level ) THEN
255: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
256: 'For Loop : ');
257: END IF;
258: */
259: -- IF g_balancing_seg = g_bal_seg_tbl(p_ccid_tbl(i)) AND

Line 263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',

259: -- IF g_balancing_seg = g_bal_seg_tbl(p_ccid_tbl(i)) AND
260: -- g_acct_seg_tbl(p_ccid_tbl(i)) BETWEEN g_acct_seg_from AND g_acct_seg_to THEN
261:
262: /* IF (g_level_procedure >= g_current_runtime_level ) THEN
263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
264: 'g_balancing_seg : ');
265: END IF;
266: */
267: /* INSERT INTO ZX_REP_ACTG_EXT_T

Line 341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',

337: -- END IF;
338: END LOOP;
339:
340: IF (g_level_procedure >= g_current_runtime_level ) THEN
341: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',
342: 'insert_row()-: ');
343: END IF;
344:
345: EXCEPTION

Line 349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',

345: EXCEPTION
346: WHEN OTHERS THEN
347:
348: IF (g_level_procedure >= g_current_runtime_level ) THEN
349: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',
350: 'insert_row(EXCEPTION)- ');
351: END IF;
352: RAISE;
353:

Line 804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()+',

800:
801: BEGIN
802:
803: IF (g_level_procedure >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()+',
805: 'get_ap_taxable : ');
806: END IF;
807:
808:

Line 815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

811:
812: FOR i in c_detail_tax_line_id_tbl.first..c_detail_tax_line_id_tbl.last LOOP
813:
814: IF (g_level_procedure >= g_current_runtime_level ) THEN
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
816: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
818: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

813:
814: IF (g_level_procedure >= g_current_runtime_level ) THEN
815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
816: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
818: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
820: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

815: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
816: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
818: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
820: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
822: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

817: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
818: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
820: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
822: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
824: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

819: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
820: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
822: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
824: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
826: 'c_ledger_id_tbl(i) : '|| to_char(c_ledger_id_tbl(i)));
827: END IF;

Line 825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

821: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
822: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
823: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
824: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
825: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
826: 'c_ledger_id_tbl(i) : '|| to_char(c_ledger_id_tbl(i)));
827: END IF;
828:
829: FOR crow_ap IN c_ap(c_detail_tax_line_id_tbl(i), c_trx_id_tbl(i), c_trx_line_id_tbl(i),

Line 834: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

830: c_tax_line_id_tbl(i), c_tax_dist_id_tbl(i), c_ledger_id_tbl(i))
831:
832: LOOP
833: IF (g_level_procedure >= g_current_runtime_level ) THEN
834: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
835: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
836: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
837: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
838: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 836: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

832: LOOP
833: IF (g_level_procedure >= g_current_runtime_level ) THEN
834: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
835: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
836: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
837: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
838: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
839: 'crow_ap.taxable_amt: '||to_char(crow_ap.taxable_amt));
840: END IF;

Line 838: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

834: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
835: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
836: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
837: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
838: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
839: 'crow_ap.taxable_amt: '||to_char(crow_ap.taxable_amt));
840: END IF;
841:
842: -- k:= to_number(to_char(c_trx_id_tbl(i))||to_char(c_trx_line_id_tbl(i)));

Line 854: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

850: END IF;
851: END IF;
852:
853: IF (g_level_procedure >= g_current_runtime_level ) THEN
854: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
855: 'K : '||to_char(k));
856: END IF;
857:
858: j := j+1;

Line 872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

868: t_taxable_amt_tbl(j) := 0;
869: k_taxable_amt_tbl(k) := 0;
870: t_taxable_amt_funcl_curr_tbl(j) := 0;
871: IF (g_level_procedure >= g_current_runtime_level ) THEN
872: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
873: 'k value test IF: ');
874: END IF;
875: ELSE
876: t_taxable_amt_tbl(j) :=crow_ap.taxable_amt;

Line 881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

877: k_taxable_amt_tbl(k) :=crow_ap.taxable_amt;
878: t_taxable_amt_funcl_curr_tbl(j) := crow_ap.taxable_amt_funcl_curr;
879:
880: IF (g_level_procedure >= g_current_runtime_level ) THEN
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
882: 'k value test else: ');
883: END IF;
884: END IF;
885:

Line 887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

883: END IF;
884: END IF;
885:
886: IF (g_level_procedure >= g_current_runtime_level ) THEN
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
888: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
890: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

Line 889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

885:
886: IF (g_level_procedure >= g_current_runtime_level ) THEN
887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
888: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
890: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
892: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
893: END IF;

Line 891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

887: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
888: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
889: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
890: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
891: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
892: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
893: END IF;
894:
895: END LOOP;

Line 901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()-',

897: END LOOP;
898:
899:
900: IF (g_level_procedure >= g_current_runtime_level ) THEN
901: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()-',
902: 'get_ap_taxable : ');
903: END IF;
904:
905: END get_ap_taxable_obsolete;

Line 989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',

985:
986: BEGIN
987:
988: IF (g_level_procedure >= g_current_runtime_level ) THEN
989: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',
990: 'get_ar_taxable : ');
991: END IF;
992:
993: /* --------------------------------------------------------- *

Line 1022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',

1018: l_ra_customer_trx_lines := 'ra_customer_trx_lines_all';
1019:
1020: ELSE
1021: IF (g_level_procedure >= g_current_runtime_level ) THEN
1022: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',
1023: 'Unable to specify if the Book is Reporting Book or Not ');
1024: END IF;
1025: END IF;
1026:

Line 1327: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',

1323:
1324: FOR i in c_event_class_code_tbl.first..c_event_class_code_tbl.last LOOP
1325: IF c_event_class_code_tbl(i) IN ('INVOICE', 'CREDIT_MEMO', 'DEBIT_MEMO') THEN
1326: IF (g_level_procedure >= g_current_runtime_level ) THEN
1327: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',
1328: 'Getting INV/CM/DM : ');
1329: END IF;
1330:
1331: /*FOR c_ar_inv_row IN c_ar_inv(c_detail_tax_line_id_tbl(i),

Line 1364: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

1360: IF t_taxable_amt_tbl.EXISTS(k) THEN
1361: t_taxable_amt_tbl(j) := 0;
1362: t_taxable_amt_funcl_curr_tbl(j) := 0;
1363: IF (g_level_procedure >= g_current_runtime_level ) THEN
1364: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
1365: 'Inside IF: ');
1366: END IF;
1367: ELSE
1368: t_taxable_amt_tbl(j) := c_taxable_amt_tbl(i);

Line 1371: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

1367: ELSE
1368: t_taxable_amt_tbl(j) := c_taxable_amt_tbl(i);
1369: t_taxable_amt_funcl_curr_tbl(j) := c_taxable_amt_funcl_curr_tbl(i);
1370: IF (g_level_procedure >= g_current_runtime_level ) THEN
1371: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
1372: 'Inside else: ');
1373: END IF;
1374: END IF;
1375:

Line 1377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1373: END IF;
1374: END IF;
1375:
1376: IF (g_level_procedure >= g_current_runtime_level ) THEN
1377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1378: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1380: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1375:
1376: IF (g_level_procedure >= g_current_runtime_level ) THEN
1377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1378: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1380: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1382: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
1383: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1377: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1378: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1380: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1382: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
1383: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1384: 't_taxable_amt_funcl_curr_tbl(j): '||to_char(t_taxable_amt_funcl_curr_tbl(j)));
1385: END IF;

Line 1383: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1379: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1380: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1381: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1382: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
1383: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1384: 't_taxable_amt_funcl_curr_tbl(j): '||to_char(t_taxable_amt_funcl_curr_tbl(j)));
1385: END IF;
1386:
1387: END LOOP;

Line 1392: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1388:
1389: ELSIF c_event_class_code_tbl(i) IN ('ADJ') THEN
1390:
1391: IF (g_level_procedure >= g_current_runtime_level ) THEN
1392: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1393: 'Getting ADJ:' );
1394: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1395: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1394: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1390:
1391: IF (g_level_procedure >= g_current_runtime_level ) THEN
1392: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1393: 'Getting ADJ:' );
1394: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1395: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1397: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1398: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1392: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1393: 'Getting ADJ:' );
1394: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1395: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1397: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1398: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1399: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1400: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1398: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1394: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1395: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1397: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1398: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1399: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1400: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1401: 'c_tax_rate_id_tbl(i):'||to_char(c_taxable_amt_tbl(i)));
1402: END IF;

Line 1400: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1396: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1397: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1398: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1399: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1400: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1401: 'c_tax_rate_id_tbl(i):'||to_char(c_taxable_amt_tbl(i)));
1402: END IF;
1403:
1404: l_first_line := j+1;

Line 1421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1417: l_precision_tbl(j+1),
1418: l_minimum_accountable_unit_tbl(j+1);
1419: EXIT WHEN c_row%NOTFOUND;
1420: IF (g_level_procedure >= g_current_runtime_level ) THEN
1421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1422: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1423: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1424: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1423: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1419: EXIT WHEN c_row%NOTFOUND;
1420: IF (g_level_procedure >= g_current_runtime_level ) THEN
1421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1422: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1423: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1424: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'l_cur_aradj : t_taxable_amt_funcl_curr_tbl(j): '||to_char(t_taxable_amt_funcl_curr_tbl(j+1)));
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1421: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1422: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1423: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1424: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'l_cur_aradj : t_taxable_amt_funcl_curr_tbl(j): '||to_char(t_taxable_amt_funcl_curr_tbl(j+1)));
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1428: 'l_cur_aradj : j: '||to_char(j));
1429: END IF;

Line 1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1423: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1424: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'l_cur_aradj : t_taxable_amt_funcl_curr_tbl(j): '||to_char(t_taxable_amt_funcl_curr_tbl(j+1)));
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1428: 'l_cur_aradj : j: '||to_char(j));
1429: END IF;
1430: j := j+1;
1431: END LOOP;

Line 1435: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1431: END LOOP;
1432: CLOSE c_row;
1433:
1434: IF (g_level_procedure >= g_current_runtime_level ) THEN
1435: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1436: 'l_cur_aradj : prorate_tax call: ');
1437: END IF;
1438:
1439: prorate_tax(c_tax_amt_tbl(i),

Line 1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1489:
1490: ELSIF c_event_class_code_tbl(i) IN ('EDISC', 'UNEDISC', 'APP') THEN
1491:
1492: IF (g_level_procedure >= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1494: 'Getting DISC/APP' );
1495: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1496: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1495: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1491:
1492: IF (g_level_procedure >= g_current_runtime_level ) THEN
1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1494: 'Getting DISC/APP' );
1495: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1496: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1498: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1499: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1493: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1494: 'Getting DISC/APP' );
1495: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1496: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1498: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1499: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1500: 'c_taxable_amt_tbl(i):'||to_char(c_taxable_amt_tbl(i)));
1501: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

Line 1499: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1495: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1496: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1498: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1499: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1500: 'c_taxable_amt_tbl(i):'||to_char(c_taxable_amt_tbl(i)));
1501: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1502: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1503: END IF;

Line 1501: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1497: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1498: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1499: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1500: 'c_taxable_amt_tbl(i):'||to_char(c_taxable_amt_tbl(i)));
1501: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1502: 'c_trx_line_id_tbl(i):'||to_char(c_trx_line_id_tbl(i)));
1503: END IF;
1504:
1505: l_first_line := j+1;

Line 1542: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1538: );
1539:
1540: ELSE
1541: IF (g_level_procedure >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1543: 'Unknown Trx_Class_Code' );
1544: END IF;
1545:
1546: app_exception.raise_exception;

Line 1550: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

1546: app_exception.raise_exception;
1547:
1548: END IF;
1549: IF (g_level_procedure >= g_current_runtime_level ) THEN
1550: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1551: 'dtl cursor loop :');
1552: END IF;
1553: END LOOP;
1554:

Line 1556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable.END',

1552: END IF;
1553: END LOOP;
1554:
1555: IF (g_level_procedure >= g_current_runtime_level ) THEN
1556: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable.END',
1557: 'zx_jg_extract.get_ar_taxable()-');
1558: END IF;
1559:
1560: END get_ar_taxable;

Line 1632: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1628: AND extract_source_ledger = c_source_ledger;
1629:
1630: BEGIN
1631:
1632: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1633: IF (g_level_procedure >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.BEGIN',
1635: 'zx_jg_extract.get_taxable()+');
1636: END IF;

Line 1634: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.BEGIN',

1630: BEGIN
1631:
1632: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1633: IF (g_level_procedure >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.BEGIN',
1635: 'zx_jg_extract.get_taxable()+');
1636: END IF;
1637:
1638: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 1643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

1639:
1640: IF p_trl_global_variables_rec.report_name = 'ZXJGTAX' THEN
1641:
1642: IF (g_level_procedure >= g_current_runtime_level ) THEN
1643: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1644: 'initialize Call '||p_trl_global_variables_rec.report_name);
1645: END IF;
1646:
1647: -- Set values from TRL global variables

Line 1655: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

1651: l_func_min_account_unit,
1652: l_sob_type);
1653:
1654: IF (g_level_procedure >= g_current_runtime_level ) THEN
1655: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1656: 'Get gl taxable transactions ');
1657: END IF;
1658:
1659: -- 8411005 : commenting out the loop by loop execution

Line 1772: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

1768: );
1769:
1770: -- For AP transactions
1771: IF (g_level_procedure >= g_current_runtime_level ) THEN
1772: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1773: 'Get AP taxable transactions ');
1774: END IF;
1775:
1776: -- 8247493 : commenting out the loop by loop execution

Line 1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

1792: p_ledger_id_tbl;
1793: CLOSE c_trl_itf;
1794:
1795: IF (g_level_procedure >= g_current_runtime_level ) THEN
1796: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1797: 'Rows fetched from c_trl_itf :'||to_char(p_detail_tax_line_id_tbl.count));
1798: END IF;
1799:
1800: IF p_detail_tax_line_id_tbl.count > 0 THEN

Line 2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

2010: AND asd.enabled_flag = 'Y'
2011: );
2012:
2013: IF (g_level_procedure >= g_current_runtime_level ) THEN
2014: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
2015: 'Get AR taxable transactions ');
2016: END IF;
2017:
2018: -- For AR Transactions

Line 2037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

2033: p_ledger_id_tbl;
2034: CLOSE c_trl_itf;
2035:
2036: IF (g_level_procedure >= g_current_runtime_level ) THEN
2037: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
2038: 'After c_trl_itf Cursor Call for AR taxable transactions ');
2039: END IF;
2040:
2041: IF p_detail_tax_line_id_tbl.count > 0 THEN

Line 2068: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',

2064: --set_accounting_info(l_ccid_tbl);
2065:
2066: -- Insert accounting infor and prorated amount into TRL interface table
2067: IF (g_level_procedure >= g_current_runtime_level ) THEN
2068: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
2069: 'insert_row API call ');
2070: END IF;
2071:
2072: insert_row(l_detail_tax_line_id_tbl,

Line 2082: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.END',

2078: END IF; -- IF p_detail_tax_line_id_tbl.count > 0
2079:
2080: END IF; -- IF report_name = ..
2081: IF (g_level_procedure >= g_current_runtime_level ) THEN
2082: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.END',
2083: 'zx_jg_extract_pkg.get_taxable()- ');
2084: END IF;
2085:
2086: END get_taxable;