DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on JAI_CMN_DEBUG_CONTEXTS_PKG

Line 154: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

150: begin
151: lv_src_type_rtr := 'RETURN TO RECEIVING'; --bgowrava for Bug#6452772
152: lv_member_name := 'GET_NONREC_TAX_AMOUNT';
153: set_debug_context;
154: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
155: , pn_reg_id => ln_reg_id
156: );
157: if pn_currency_conv_rate is null or pn_currency_conv_rate = 0 then
158: ln_currency_conv_rate := 1;

Line 164: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_currency_of_return_tax_amt='||lv_currency_of_return_tax_amt );

160: ln_currency_conv_rate := nvl(pn_currency_conv_rate, 1);
161: end if;
162: lv_currency_of_return_tax_amt := nvl(pv_currency_of_return_tax_amt, gv_transaction_currency);
163:
164: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_currency_of_return_tax_amt='||lv_currency_of_return_tax_amt );
165:
166: /* this logic is to avoid recalculation of amounts if called multiple times for the same transaction dtls consecutively*/
167: if gv_trx_source = pv_transaction_source
168: and gv_line_type = pv_line_type

Line 190: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pv_line_type='||pv_line_type || ', pv_transaction_source='||pv_transaction_source);

186:
187: /* calculate the non recoverable tax */
188: /* this should consider currency, recoverable percentage and apportion factor when calculating the tax */
189:
190: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pv_line_type='||pv_line_type || ', pv_transaction_source='||pv_transaction_source);
191:
192: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
193:
194: /* 1 - REQUISITONS */

Line 260: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pn_transaction_qty='||pn_transaction_qty ||',r_get_reqn_line_dtl.quantity='||r_get_reqn_line_dtl.quantity );

256: open c_get_reqn_line_dtl(r_get_reqn_dist_dtl.requisition_line_id);
257: fetch c_get_reqn_line_dtl into r_get_reqn_line_dtl;
258: close c_get_reqn_line_dtl;
259:
260: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pn_transaction_qty='||pn_transaction_qty ||',r_get_reqn_line_dtl.quantity='||r_get_reqn_line_dtl.quantity );
261:
262: if pn_transaction_qty is not null
263: and pn_transaction_qty <> 0
264: and r_get_reqn_line_dtl.quantity is not null

Line 273: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);

269: else
270: ln_apportion_factor := 1;
271: end if;
272:
273: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
274:
275: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
276: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
277:

Line 348: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pn_transaction_qty='||pn_transaction_qty ||',r_get_po_line_loc_dtl.quantity='||r_get_po_line_loc_dtl.quantity);

344: open c_get_po_line_loc_dtl(r_get_po_dist_dtl.line_location_id);
345: fetch c_get_po_line_loc_dtl into r_get_po_line_loc_dtl;
346: close c_get_po_line_loc_dtl;
347:
348: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pn_transaction_qty='||pn_transaction_qty ||',r_get_po_line_loc_dtl.quantity='||r_get_po_line_loc_dtl.quantity);
349:
350: if pn_transaction_qty is not null
351: and pn_transaction_qty <> 0
352: and r_get_po_line_loc_dtl.quantity is not null

Line 361: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);

357: else
358: ln_apportion_factor := 1;
359: end if;
360:
361: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
362:
363: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
364: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
365:

Line 508: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_ja_in_deliver_trx.quantity='||r_ja_in_deliver_trx.quantity ||

504: -- Bug# 6321215
505: -- Changed pn_transaction_qty to r_ja_in_receive_trx.quantity. This is done because in R12 PA populates amount
506: -- for quantity column if expenditure_type is not rate enabled. Hence refering to DELIVER quantity to determine the
507: -- apportion factor
508: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_ja_in_deliver_trx.quantity='||r_ja_in_deliver_trx.quantity ||
509: ', r_ja_in_receive_trx.quantity='||r_ja_in_receive_trx.quantity ||
510: ', pn_transaction_qty =' || pn_transaction_qty
511: );
512:

Line 526: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);

522: ln_apportion_factor := 1;
523: end if;
524: -- End Bug 6321215
525:
526: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
527:
528: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
529: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
530:

Line 629: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

625:
626: begin <>
627: lv_member_name := 'PRE_PROCESS';
628: set_debug_context;
629: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
630: , pn_reg_id => ln_reg_id
631: );
632:
633: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

Line 633: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

629: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
630: , pn_reg_id => ln_reg_id
631: );
632:
633: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
634: 'p_transaction_source='|| p_transaction_source ||fnd_global.local_chr(10) ||
635: 'p_batch ='|| p_batch ||fnd_global.local_chr(10) ||
636: 'p_xface_id ='|| p_xface_id ||fnd_global.local_chr(10) ||
637: 'p_user_id ='|| p_user_id

Line 654: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_process_flag='||lv_process_flag ||',Message='||lv_process_message);

650: , p_process_flag => lv_process_flag
651: , p_process_message => lv_process_message
652: );
653: if lv_process_flag <> jai_constants.SUCCESSFUL then
654: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_process_flag='||lv_process_flag ||',Message='||lv_process_message);
655: return;
656: end if;
657: /** Deregister procedure and return*/
658: <>

Line 659: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

655: return;
656: end if;
657: /** Deregister procedure and return*/
658: <>
659: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
660:
661: exception
662: when others then
663: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

Line 663: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

659: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
660:
661: exception
662: when others then
663: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
664: jai_cmn_debug_contexts_pkg.print_stack;
665:
666: end pre_process;
667:

Line 664: jai_cmn_debug_contexts_pkg.print_stack;

660:
661: exception
662: when others then
663: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
664: jai_cmn_debug_contexts_pkg.print_stack;
665:
666: end pre_process;
667:
668:

Line 714: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

710: begin
711:
712: lv_member_name := 'POST_PROCESS';
713: set_debug_context;
714: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
715: , pn_reg_id => ln_reg_id
716: );
717:
718: FND_FILE.put_line(FND_FILE.log, 'Post Process Parameters: ' || p_transaction_source || ':' || p_batch || ':' || p_xface_id);

Line 720: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' ||

716: );
717:
718: FND_FILE.put_line(FND_FILE.log, 'Post Process Parameters: ' || p_transaction_source || ':' || p_batch || ':' || p_xface_id);
719:
720: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' ||
721: ' p_transaction_source='|| p_transaction_source ||
722: ' p_batch ='|| p_batch ||
723: ' p_xface_id ='|| p_xface_id ||
724: ' p_user_id ='|| p_user_id

Line 769: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

765: and interface_id = p_xface_id;
766:
767: /** Deregister procedure and return*/
768: <>
769: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
770:
771: exception
772: when others then
773: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

Line 773: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

769: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
770:
771: exception
772: when others then
773: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
774: jai_cmn_debug_contexts_pkg.print_stack;
775:
776: end post_process;
777: ----------------------------------------------------------------------------------------------------------------

Line 774: jai_cmn_debug_contexts_pkg.print_stack;

770:
771: exception
772: when others then
773: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
774: jai_cmn_debug_contexts_pkg.print_stack;
775:
776: end post_process;
777: ----------------------------------------------------------------------------------------------------------------
778: -- Added by Jia for FP Bug#9863751, End

Line 928: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);

924:
925: lv_member_name := 'UPDATE_INTERFACE_COSTS';
926: set_debug_context;
927:
928: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
929: for r_po_rcpt in c_pa_trx_xface_records
930: loop
931:
932: ln_apportioned_func_tax_amt := 0;

Line 937: jai_cmn_debug_contexts_pkg.print

933: ln_apportioned_txn_tax_amt := 0;
934:
935: /*Commented for Bug 8400140*/
936: /*
937: jai_cmn_debug_contexts_pkg.print
938: ( ln_reg_id
939: , 'r_po_rcpt.cdl_system_reference4 (rcv_transaction_id)='||r_po_rcpt.cdl_system_reference4 || fnd_global.local_chr(10) ||
940: 'r_po_rcpt.unit_of_measure='||r_po_rcpt.unit_of_measure|| fnd_global.local_chr(10) ||
941: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||

Line 966: jai_cmn_debug_contexts_pkg.print

962: , pn_transaction_qty => r_po_rcpt.quantity
963: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
964: );
965:
966: jai_cmn_debug_contexts_pkg.print
967: ( ln_reg_id
968: , 'ln_apportioned_txn_tax_amt='||ln_apportioned_txn_tax_amt
969: ||', ln_apportioned_func_tax_amt='||ln_apportioned_func_tax_amt
970: );

Line 972: jai_cmn_debug_contexts_pkg.print

968: , 'ln_apportioned_txn_tax_amt='||ln_apportioned_txn_tax_amt
969: ||', ln_apportioned_func_tax_amt='||ln_apportioned_func_tax_amt
970: );
971:
972: jai_cmn_debug_contexts_pkg.print
973: ( ln_reg_id
974: ,'Before update pa_transaction_interface_all'
975: );
976: */

Line 1250: jai_cmn_debug_contexts_pkg.print

1246: );
1247:
1248: END IF; -- Added for Bug 8400140
1249:
1250: jai_cmn_debug_contexts_pkg.print
1251: ( ln_reg_id
1252: , 'Number of rows updated='||sql%rowcount
1253: );
1254:

Line 1499: jai_cmn_debug_contexts_pkg.print

1495: 'N'
1496: );
1497: END IF;
1498:
1499: jai_cmn_debug_contexts_pkg.print
1500: ( ln_reg_id
1501: , 'Number of rows updated='||sql%rowcount
1502: );
1503:

Line 1766: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

1762:
1763:
1764: /** Deregister procedure and return*/
1765: <>
1766: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
1767:
1768: exception
1769: when others then
1770: p_process_flag := jai_constants.UNEXPECTED_ERROR;

Line 1772: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

1768: exception
1769: when others then
1770: p_process_flag := jai_constants.UNEXPECTED_ERROR;
1771: p_process_message := sqlerrm;
1772: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1773: jai_cmn_debug_contexts_pkg.print_stack;
1774:
1775: end update_interface_costs;
1776:

Line 1773: jai_cmn_debug_contexts_pkg.print_stack;

1769: when others then
1770: p_process_flag := jai_constants.UNEXPECTED_ERROR;
1771: p_process_message := sqlerrm;
1772: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1773: jai_cmn_debug_contexts_pkg.print_stack;
1774:
1775: end update_interface_costs;
1776:
1777: