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.JAI_PA_COSTING_PKG dependencies on FND_GLOBAL

Line 53: lv_user_id fnd_user.user_id%type default fnd_global.user_id;

49: lv_context jai_cmn_debug_contexts.log_context%type;
50: --
51: -- Global variables used throught the package
52: --
53: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
54: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
55:
56: -- Package constants
57: GV_TRX_SRC_PO_RECEIPT constant varchar2 (30) := 'PO RECEIPT';

Line 54: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;

50: --
51: -- Global variables used throught the package
52: --
53: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
54: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
55:
56: -- Package constants
57: GV_TRX_SRC_PO_RECEIPT constant varchar2 (30) := 'PO RECEIPT';
58: GV_TRX_SRC_PO_RCPT_PRICE_ADJ constant varchar2 (30) := 'PO RECEIPT PRICE ADJ';

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 634: 'p_transaction_source='|| p_transaction_source ||fnd_global.local_chr(10) ||

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
638: );

Line 635: 'p_batch ='|| p_batch ||fnd_global.local_chr(10) ||

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
638: );
639:

Line 636: 'p_xface_id ='|| p_xface_id ||fnd_global.local_chr(10) ||

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
638: );
639:
640: if p_transaction_source not in (GV_TRX_SRC_PO_RECEIPT)

Line 754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());

750:
751: for r_upd_req_id in c_upd_req_id
752: loop
753:
754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());
755:
756: update jai_pa_tax_trxs
757: set request_id = fnd_global.conc_request_id()
758: where current of c_upd_req_id;

Line 757: set request_id = fnd_global.conc_request_id()

753:
754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());
755:
756: update jai_pa_tax_trxs
757: set request_id = fnd_global.conc_request_id()
758: where current of c_upd_req_id;
759: end loop; /*for r_upd_req_id in c_upd_req_id*/
760:
761: update pa_transaction_interface_all

Line 899: and (request_id <> FND_GLOBAL.CONC_REQUEST_ID() or request_id is NULL)

895: from jai_pa_tax_trxs jait
896: where pa_addition_flag = 'N'
897: and expenditure_item_id is NULL
898: and batch_name = nvl(p_batch, batch_name)
899: and (request_id <> FND_GLOBAL.CONC_REQUEST_ID() or request_id is NULL)
900: and not exists
901: ( select 1
902: from pa_transaction_interface_all pti
903: where pti.transaction_source = jait.transaction_source

Line 939: , 'r_po_rcpt.cdl_system_reference4 (rcv_transaction_id)='||r_po_rcpt.cdl_system_reference4 || fnd_global.local_chr(10) ||

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) ||
942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );

Line 940: 'r_po_rcpt.unit_of_measure='||r_po_rcpt.unit_of_measure|| fnd_global.local_chr(10) ||

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) ||
942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );
944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount

Line 941: 'r_po_rcpt.quantity='||r_po_rcpt.quantity || fnd_global.local_chr(10) ||

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) ||
942: 'r_po_rcpt.txn_interface_id='||r_po_rcpt.txn_interface_id
943: );
944: ln_apportioned_txn_tax_amt := JAI_PA_COSTING_PKG.get_nonrec_tax_amount
945: ( pv_transaction_source => JAI_PA_COSTING_PKG.GV_SRC_ORACLE_PURCHASING

Line 1658: FND_GLOBAL.CONC_REQUEST_ID() , /FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE/

1654: R_JAI_PA_TAX_TRXS.EXPENDITURE_COMMENT ,
1655: R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ,
1656: R_JAI_PA_TAX_TRXS.TRANSACTION_REJECTION_CODE ,
1657: R_JAI_PA_TAX_TRXS.EXPENDITURE_ID ,
1658: FND_GLOBAL.CONC_REQUEST_ID() , /*FP Bug#9863751 - Current Request ID must be populated in ORIG_TRANSACTION_REFERENCE*/
1659: R_JAI_PA_TAX_TRXS.ATTRIBUTE_CATEGORY ,
1660: R_JAI_PA_TAX_TRXS.ATTRIBUTE1 ,
1661: R_JAI_PA_TAX_TRXS.ATTRIBUTE2 ,
1662: R_JAI_PA_TAX_TRXS.ATTRIBUTE3 ,

Line 2062: LN_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();

2058: lv_user_transaction_source := 'Oracle Purchasing Receipt Accruals';
2059: lv_transaction_status_code := 'P';
2060: lv_transaction_rejection_code :='';
2061:
2062: LN_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
2063:
2064: FND_FILE.put_line(FND_FILE.log, 'LN_REQUEST_ID '|| LN_REQUEST_ID);
2065:
2066: SELECT org_id