DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on JAI_CMN_DEBUG_CONTEXTS_PKG

Line 131: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

127: begin
128: lv_src_type_rtr := 'RETURN TO RECEIVING'; --bgowrava for Bug#6452772
129: lv_member_name := 'GET_NONREC_TAX_AMOUNT';
130: set_debug_context;
131: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
132: , pn_reg_id => ln_reg_id
133: );
134: if pn_currency_conv_rate is null or pn_currency_conv_rate = 0 then
135: ln_currency_conv_rate := 1;

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

137: ln_currency_conv_rate := nvl(pn_currency_conv_rate, 1);
138: end if;
139: lv_currency_of_return_tax_amt := nvl(pv_currency_of_return_tax_amt, gv_transaction_currency);
140:
141: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_currency_of_return_tax_amt='||lv_currency_of_return_tax_amt );
142:
143: /* this logic is to avoid recalculation of amounts if called multiple times for the same transaction dtls consecutively*/
144: if gv_trx_source = pv_transaction_source
145: and gv_line_type = pv_line_type

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

163:
164: /* calculate the non recoverable tax */
165: /* this should consider currency, recoverable percentage and apportion factor when calculating the tax */
166:
167: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'pv_line_type='||pv_line_type || ', pv_transaction_source='||pv_transaction_source);
168:
169: if pv_transaction_source = JAI_PA_COSTING_PKG.gv_src_oracle_purchasing then
170:
171: /* 1 - REQUISITONS */

Line 237: 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 );

233: open c_get_reqn_line_dtl(r_get_reqn_dist_dtl.requisition_line_id);
234: fetch c_get_reqn_line_dtl into r_get_reqn_line_dtl;
235: close c_get_reqn_line_dtl;
236:
237: 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 );
238:
239: if pn_transaction_qty is not null
240: and pn_transaction_qty <> 0
241: and r_get_reqn_line_dtl.quantity is not null

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

246: else
247: ln_apportion_factor := 1;
248: end if;
249:
250: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
251:
252: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
253: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
254:

Line 325: 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);

321: open c_get_po_line_loc_dtl(r_get_po_dist_dtl.line_location_id);
322: fetch c_get_po_line_loc_dtl into r_get_po_line_loc_dtl;
323: close c_get_po_line_loc_dtl;
324:
325: 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);
326:
327: if pn_transaction_qty is not null
328: and pn_transaction_qty <> 0
329: and r_get_po_line_loc_dtl.quantity is not null

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

334: else
335: ln_apportion_factor := 1;
336: end if;
337:
338: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
339:
340: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
341: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
342:

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

481: -- Bug# 6321215
482: -- Changed pn_transaction_qty to r_ja_in_receive_trx.quantity. This is done because in R12 PA populates amount
483: -- for quantity column if expenditure_type is not rate enabled. Hence refering to DELIVER quantity to determine the
484: -- apportion factor
485: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_ja_in_deliver_trx.quantity='||r_ja_in_deliver_trx.quantity ||
486: ', r_ja_in_receive_trx.quantity='||r_ja_in_receive_trx.quantity ||
487: ', pn_transaction_qty =' || pn_transaction_qty
488: );
489:

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

499: ln_apportion_factor := 1;
500: end if;
501: -- End Bug 6321215
502:
503: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_apportion_factor='||ln_apportion_factor);
504:
505: ln_func_nonreco_tax_amt := ln_func_nonreco_tax_amt * ln_apportion_factor;
506: ln_trx_nonreco_tax_amt := ln_trx_nonreco_tax_amt * ln_apportion_factor;
507:

Line 606: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

602:
603: begin <>
604: lv_member_name := 'PRE_PROCESS';
605: set_debug_context;
606: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
607: , pn_reg_id => ln_reg_id
608: );
609:
610: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

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

606: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
607: , pn_reg_id => ln_reg_id
608: );
609:
610: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
611: 'p_transaction_source='|| p_transaction_source ||fnd_global.local_chr(10) ||
612: 'p_batch ='|| p_batch ||fnd_global.local_chr(10) ||
613: 'p_xface_id ='|| p_xface_id ||fnd_global.local_chr(10) ||
614: 'p_user_id ='|| p_user_id

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

627: , p_process_flag => lv_process_flag
628: , p_process_message => lv_process_message
629: );
630: if lv_process_flag <> jai_constants.SUCCESSFUL then
631: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_process_flag='||lv_process_flag ||',Message='||lv_process_message);
632: return;
633: end if;
634: /** Deregister procedure and return*/
635: <>

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

632: return;
633: end if;
634: /** Deregister procedure and return*/
635: <>
636: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
637:
638: exception
639: when others then
640: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

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

636: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
637:
638: exception
639: when others then
640: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
641: jai_cmn_debug_contexts_pkg.print_stack;
642:
643: end pre_process;
644:

Line 641: jai_cmn_debug_contexts_pkg.print_stack;

637:
638: exception
639: when others then
640: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
641: jai_cmn_debug_contexts_pkg.print_stack;
642:
643: end pre_process;
644:
645: /*------------------------------------------------------------------------------------------------------------*/

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

670:
671: lv_member_name := 'UPDATE_INTERFACE_COSTS';
672: set_debug_context;
673:
674: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
675: for r_po_rcpt in c_pa_trx_xface_records
676: loop
677:
678: ln_apportioned_func_tax_amt := 0;

Line 682: jai_cmn_debug_contexts_pkg.print

678: ln_apportioned_func_tax_amt := 0;
679: ln_apportioned_txn_tax_amt := 0;
680:
681:
682: jai_cmn_debug_contexts_pkg.print
683: ( ln_reg_id
684: , 'r_po_rcpt.cdl_system_reference4 (rcv_transaction_id)='||r_po_rcpt.cdl_system_reference4 || fnd_global.local_chr(10) ||
685: 'r_po_rcpt.unit_of_measure='||r_po_rcpt.unit_of_measure|| fnd_global.local_chr(10) ||
686: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||

Line 711: jai_cmn_debug_contexts_pkg.print

707: , pn_transaction_qty => r_po_rcpt.quantity
708: , pn_currency_conv_rate => r_po_rcpt.receipt_exchange_rate
709: );
710:
711: jai_cmn_debug_contexts_pkg.print
712: ( ln_reg_id
713: , 'ln_apportioned_txn_tax_amt='||ln_apportioned_txn_tax_amt
714: ||', ln_apportioned_func_tax_amt='||ln_apportioned_func_tax_amt
715: );

Line 717: jai_cmn_debug_contexts_pkg.print

713: , 'ln_apportioned_txn_tax_amt='||ln_apportioned_txn_tax_amt
714: ||', ln_apportioned_func_tax_amt='||ln_apportioned_func_tax_amt
715: );
716:
717: jai_cmn_debug_contexts_pkg.print
718: ( ln_reg_id
719: ,'Before update pa_transaction_interface_all'
720: );
721:

Line 929: jai_cmn_debug_contexts_pkg.print

925: r_po_rcpt.WIP_RESOURCE_ID ,
926: r_po_rcpt.UNIT_OF_MEASURE
927: );
928:
929: jai_cmn_debug_contexts_pkg.print
930: ( ln_reg_id
931: , 'Number of rows updated='||sql%rowcount
932: );
933:

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

935: end loop;
936:
937: /** Deregister procedure and return*/
938: <>
939: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
940:
941: exception
942: when others then
943: p_process_flag := jai_constants.UNEXPECTED_ERROR;

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

941: exception
942: when others then
943: p_process_flag := jai_constants.UNEXPECTED_ERROR;
944: p_process_message := sqlerrm;
945: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
946: jai_cmn_debug_contexts_pkg.print_stack;
947:
948: end update_interface_costs;
949:

Line 946: jai_cmn_debug_contexts_pkg.print_stack;

942: when others then
943: p_process_flag := jai_constants.UNEXPECTED_ERROR;
944: p_process_message := sqlerrm;
945: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
946: jai_cmn_debug_contexts_pkg.print_stack;
947:
948: end update_interface_costs;
949:
950: end jai_pa_costing_pkg;