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 40: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

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

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

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

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

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

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

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

142:
143: BEGIN
144:
145: IF (g_level_procedure >= g_current_runtime_level ) THEN
146: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()+',
147: 'prorate_tax');
148: END IF;
149:
150: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

147: 'prorate_tax');
148: END IF;
149:
150: IF (g_level_procedure >= g_current_runtime_level ) THEN
151: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
152: 'prorate_tax='||To_char(p_tax_total)||', Acctd tax='||To_char(p_tax_funcl_curr_total));
153: END IF;
154:
155:

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

165: alloc_tax_funcl_curr := 0;
166:
167: FOR i IN p_current_line..p_last_line-1 LOOP
168: IF (g_level_procedure >= g_current_runtime_level ) THEN
169: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
170: 'Percent='||To_char(Round(p_percent_tbl(i)*100, 3))||
171: ', Precision='||To_char(p_precision_tbl(i))||
172: ', Mimimum Accountable Unit='||To_char(p_minimum_accountable_unit_tbl(i)));
173: END IF;

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

193: p_tax_amt_tbl(i) := currency_round(full_tax, p_precision_tbl(i), p_minimum_accountable_unit_tbl(i));
194: p_tax_amt_funcl_curr_tbl(i) := currency_round(full_tax_funcl_curr, p_func_precision, p_func_min_account_unit);
195:
196: IF (g_level_procedure >= g_current_runtime_level ) THEN
197: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
198: 'Tax Amount='||To_char(p_tax_amt_tbl(i))||', Acctd Tax Amount='||To_char(p_tax_amt_funcl_curr_tbl(i)));
199: END IF;
200:
201:

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

210: p_tax_amt_tbl(p_last_line) := p_tax_total - alloc_tax;
211: p_tax_amt_funcl_curr_tbl(p_last_line) := p_tax_funcl_curr_total - alloc_tax_funcl_curr;
212:
213: IF (g_level_procedure >= g_current_runtime_level ) THEN
214: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax',
215: '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)));
216: END IF;
217:
218: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

215: '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)));
216: END IF;
217:
218: IF (g_level_procedure >= g_current_runtime_level ) THEN
219: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.prorate_tax()-',
220: 'prorate_tax');
221: END IF;
222:
223: END prorate_tax;

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

255:
256: BEGIN
257:
258: IF (g_level_procedure >= g_current_runtime_level ) THEN
259: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
260: 'insert_row API call ');
261: END IF;
262:
263: j := 0;

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

270: */
271: FOR i in p_detail_tax_line_id_tbl.first..p_detail_tax_line_id_tbl.last LOOP
272:
273: IF (g_level_procedure >= g_current_runtime_level ) THEN
274: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
275: 'For Loop : ');
276: END IF;
277:
278: -- IF g_balancing_seg = g_bal_seg_tbl(p_ccid_tbl(i)) AND

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

278: -- IF g_balancing_seg = g_bal_seg_tbl(p_ccid_tbl(i)) AND
279: -- g_acct_seg_tbl(p_ccid_tbl(i)) BETWEEN g_acct_seg_from AND g_acct_seg_to THEN
280:
281: IF (g_level_procedure >= g_current_runtime_level ) THEN
282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
283: 'g_balancing_seg : ');
284: END IF;
285:
286: /* INSERT INTO ZX_REP_ACTG_EXT_T

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

358: -- END IF;
359: END LOOP;
360:
361: IF (g_level_procedure >= g_current_runtime_level ) THEN
362: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',
363: 'insert_row()-: ');
364: END IF;
365:
366: EXCEPTION

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

366: EXCEPTION
367: WHEN OTHERS THEN
368:
369: IF (g_level_procedure >= g_current_runtime_level ) THEN
370: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()-',
371: 'insert_row(EXCEPTION)- ');
372: END IF;
373: RAISE;
374:

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

856:
857: BEGIN
858:
859: IF (g_level_procedure >= g_current_runtime_level ) THEN
860: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()+',
861: 'get_ap_taxable : ');
862: END IF;
863:
864:

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

867:
868: FOR i in c_detail_tax_line_id_tbl.first..c_detail_tax_line_id_tbl.last LOOP
869:
870: IF (g_level_procedure >= g_current_runtime_level ) THEN
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
872: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
874: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

869:
870: IF (g_level_procedure >= g_current_runtime_level ) THEN
871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
872: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
874: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
876: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

871: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
872: 'c_detail_tax_line_id_tbl : '|| to_char(c_detail_tax_line_id_tbl(i)));
873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
874: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
876: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
878: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

873: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
874: 'c_trx_line_id_tbl(i) : '|| to_char(c_trx_line_id_tbl(i)));
875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
876: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
878: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
880: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
876: 'c_trx_id_tbl(i) : '|| to_char(c_trx_id_tbl(i)));
877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
878: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
880: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
882: 'c_ledger_id_tbl(i) : '|| to_char(c_ledger_id_tbl(i)));
883: END IF;

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

877: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
878: 'c_tax_line_id_tbl(i) : '|| to_char(c_tax_line_id_tbl(i)));
879: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
880: 'c_tax_dist_id_tbl(i) : '|| to_char(c_tax_dist_id_tbl(i)));
881: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
882: 'c_ledger_id_tbl(i) : '|| to_char(c_ledger_id_tbl(i)));
883: END IF;
884:
885: 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 890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

886: c_tax_line_id_tbl(i), c_tax_dist_id_tbl(i), c_ledger_id_tbl(i))
887:
888: LOOP
889: IF (g_level_procedure >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
891: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
893: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
894: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

888: LOOP
889: IF (g_level_procedure >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
891: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
893: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
894: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
895: 'crow_ap.taxable_amt: '||to_char(crow_ap.taxable_amt));
896: END IF;

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

890: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
891: 't_detail_tax_line_id_tbl(j): '||to_char(crow_ap.detail_tax_line_id));
892: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
893: 't_ccid_tbl(j): '||to_char(crow_ap.code_combination_id));
894: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
895: 'crow_ap.taxable_amt: '||to_char(crow_ap.taxable_amt));
896: END IF;
897:
898: k:= to_number(to_char(c_trx_id_tbl(i))||to_char(c_trx_line_id_tbl(i)));

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

898: k:= to_number(to_char(c_trx_id_tbl(i))||to_char(c_trx_line_id_tbl(i)));
899:
900:
901: IF (g_level_procedure >= g_current_runtime_level ) THEN
902: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
903: 'K : '||to_char(k));
904: END IF;
905:
906: j := j+1;

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

917: k_taxable_amt_tbl(k) := 0;
918: t_taxable_amt_funcl_curr_tbl(j) := 0;
919:
920: IF (g_level_procedure >= g_current_runtime_level ) THEN
921: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
922: 'k value test IF: ');
923: END IF;
924: ELSE
925: t_taxable_amt_tbl(j) :=crow_ap.taxable_amt;

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

926: k_taxable_amt_tbl(k) :=crow_ap.taxable_amt;
927: t_taxable_amt_funcl_curr_tbl(j) := crow_ap.taxable_amt_funcl_curr;
928:
929: IF (g_level_procedure >= g_current_runtime_level ) THEN
930: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
931: 'k value test else: ');
932: END IF;
933:
934: END IF;

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

933:
934: END IF;
935:
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
938: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
940: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',

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

935:
936: IF (g_level_procedure >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
938: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
940: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
942: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
943: END IF;

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

937: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
938: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
939: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
940: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
941: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable',
942: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
943: END IF;
944:
945: END LOOP;

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

947: END LOOP;
948:
949:
950: IF (g_level_procedure >= g_current_runtime_level ) THEN
951: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ap_taxable()-',
952: 'get_ap_taxable : ');
953: END IF;
954:
955:

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

1099:
1100: BEGIN
1101:
1102: IF (g_level_procedure >= g_current_runtime_level ) THEN
1103: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',
1104: 'get_ar_taxable : ');
1105: END IF;
1106:
1107:

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

1381:
1382: IF c_event_class_code_tbl(i) IN ('INVOICE', 'CREDIT_MEMO', 'DEBIT_MEMO') THEN
1383:
1384: IF (g_level_procedure >= g_current_runtime_level ) THEN
1385: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable()+',
1386: 'Getting INV/CM/DM : ');
1387: END IF;
1388:
1389:

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

1407: --t_tax_amt_tbl(j) := c_ar_inv_row.tax_amt;
1408: --t_tax_amt_funcl_curr_tbl(j) := c_ar_inv_row.tax_amt_funcl_curr;
1409:
1410: IF (g_level_procedure >= g_current_runtime_level ) THEN
1411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1412: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1414: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

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

1409:
1410: IF (g_level_procedure >= g_current_runtime_level ) THEN
1411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1412: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1414: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1416: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
1417: END IF;

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

1411: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1412: 't_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j)));
1413: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1414: 't_ccid_tbl(j): '||to_char(t_ccid_tbl(j)));
1415: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1416: 't_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j)));
1417: END IF;
1418:
1419:

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

1421:
1422: ELSIF c_event_class_code_tbl(i) IN ('ADJ') THEN
1423:
1424: IF (g_level_procedure >= g_current_runtime_level ) THEN
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'Getting ADJ:' );
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1428: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1429: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

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

1423:
1424: IF (g_level_procedure >= g_current_runtime_level ) THEN
1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'Getting ADJ:' );
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1428: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1429: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1430: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1431:

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

1425: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1426: 'Getting ADJ:' );
1427: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1428: 'c_trx_id_tbl(i):'||to_char(c_trx_id_tbl(i)));
1429: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1430: 'c_tax_rate_id_tbl(i):'||to_char(c_tax_rate_id_tbl(i)));
1431:
1432: END IF;
1433:

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

1451: t_acct_date_tbl(j+1);
1452:
1453: EXIT WHEN c_row%NOTFOUND;
1454: IF (g_level_procedure >= g_current_runtime_level ) THEN
1455: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1456: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1457: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1458: 'l_cur_aradj : t_ccid_tbl(j): '||to_char(t_ccid_tbl(j+1)));
1459: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

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

1453: EXIT WHEN c_row%NOTFOUND;
1454: IF (g_level_procedure >= g_current_runtime_level ) THEN
1455: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1456: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1457: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1458: 'l_cur_aradj : t_ccid_tbl(j): '||to_char(t_ccid_tbl(j+1)));
1459: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1460: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1461: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',

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

1455: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1456: 'l_cur_aradj : t_detail_tax_line_id_tbl(j): '||to_char(t_detail_tax_line_id_tbl(j+1)));
1457: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1458: 'l_cur_aradj : t_ccid_tbl(j): '||to_char(t_ccid_tbl(j+1)));
1459: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1460: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1461: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1462: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(j));
1463: END IF;

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

1457: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1458: 'l_cur_aradj : t_ccid_tbl(j): '||to_char(t_ccid_tbl(j+1)));
1459: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1460: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(t_taxable_amt_tbl(j+1)));
1461: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1462: 'l_cur_aradj : t_taxable_amt_tbl(j): '||to_char(j));
1463: END IF;
1464:
1465:

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

1470:
1471: CLOSE c_row;
1472:
1473: IF (g_level_procedure >= g_current_runtime_level ) THEN
1474: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1475: 'l_cur_aradj : prorate_tax call: ');
1476: END IF;
1477:
1478: prorate_tax(-1*c_tax_amt_tbl(i),

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

1588: app_exception.raise_exception;
1589:
1590: END IF;
1591: IF (g_level_procedure >= g_current_runtime_level ) THEN
1592: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable',
1593: 'dtl cursor loop :');
1594: END IF;
1595: END LOOP;
1596:

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

1594: END IF;
1595: END LOOP;
1596:
1597: IF (g_level_procedure >= g_current_runtime_level ) THEN
1598: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_ar_taxable.END',
1599: 'zx_jg_extract.get_ar_taxable()-');
1600: END IF;
1601:
1602: END get_ar_taxable;

Line 1676: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1672: AND extract_source_ledger = c_source_ledger;
1673:
1674: BEGIN
1675:
1676: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1677: IF (g_level_procedure >= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.BEGIN',
1679: 'zx_jg_extract.get_taxable()+');
1680: END IF;

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

1674: BEGIN
1675:
1676: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1677: IF (g_level_procedure >= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.BEGIN',
1679: 'zx_jg_extract.get_taxable()+');
1680: END IF;
1681:
1682: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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

1683:
1684:
1685: IF p_trl_global_variables_rec.report_name = 'ZXJGTAX' THEN
1686: IF (g_level_procedure >= g_current_runtime_level ) THEN
1687: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1688: 'initialize Call '||p_trl_global_variables_rec.report_name);
1689: END IF;
1690:
1691: -- Set values from TRL global variables

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

1695: l_func_min_account_unit,
1696: l_sob_type);
1697:
1698: IF (g_level_procedure >= g_current_runtime_level ) THEN
1699: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1700: 'Get gl taxable transactions ');
1701: END IF;
1702:
1703: -- For GL transactions

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

1771:
1772: -- For AP transactions
1773:
1774: IF (g_level_procedure >= g_current_runtime_level ) THEN
1775: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1776: 'Get AP taxable transactions ');
1777: END IF;
1778:
1779: OPEN c_trl_itf(p_trl_global_variables_rec.request_id, 'AP');

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:

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

1848: l_acct_date_tbl);
1849: END IF;
1850:
1851: IF (g_level_procedure >= g_current_runtime_level ) THEN
1852: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1853: 'Get AR taxable transactions ');
1854: END IF;
1855:
1856: -- For AR Transactions

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

1871: p_ledger_id_tbl;
1872: CLOSE c_trl_itf;
1873:
1874: IF (g_level_procedure >= g_current_runtime_level ) THEN
1875: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1876: 'After c_trl_itf Cursor Call for AR taxable transactions ');
1877: END IF;
1878:
1879: IF p_detail_tax_line_id_tbl.count > 0 THEN

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

1903: --set_accounting_info(l_ccid_tbl);
1904:
1905: -- Insert accounting infor and prorated amount into TRL interface table
1906: IF (g_level_procedure >= g_current_runtime_level ) THEN
1907: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable',
1908: 'insert_row API call ');
1909: END IF;
1910:
1911: insert_row(l_detail_tax_line_id_tbl,

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

1919: END IF; -- IF p_detail_tax_line_id_tbl.count > 0
1920:
1921: END IF; -- IF report_name = ..
1922: IF (g_level_procedure >= g_current_runtime_level ) THEN
1923: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.get_taxable.END',
1924: 'zx_jg_extract_pkg.get_taxable()- ');
1925: END IF;
1926:
1927: END get_taxable;