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.PA_MC_CURRENCY_PKG dependencies on PA_MC_TXN_INTERFACE_ALL

Line 945: x_err_stage := ' Select from pa_mc_txn_interface_all';

941:
942: l_old_stack := x_err_stack;
943: x_err_code := 0;
944: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_imported_rates';
945: x_err_stage := ' Select from pa_mc_txn_interface_all';
946:
947: SELECT mc.raw_cost,
948: mc.raw_cost_rate,
949: mc.burdened_cost,

Line 961: FROM pa_mc_txn_interface_all mc,

957: x_burden_cost_rate,
958: x_exchange_rate,
959: x_exchange_date,
960: x_exchange_rate_type
961: FROM pa_mc_txn_interface_all mc,
962: pa_transaction_interface_all txn
963: WHERE mc.txn_interface_id = txn.txn_interface_id
964: AND txn.expenditure_item_id = x_exp_item_id
965: AND mc.set_of_books_id = x_set_of_books_id;

Line 1536: /* This procedure will populate the Pa_mc_txn_interface_all table for a invoice */

1532:
1533: -------------------------------------------------------------
1534:
1535: /*------------------------------ ins_mc_txn_interface_all ----------------------*/
1536: /* This procedure will populate the Pa_mc_txn_interface_all table for a invoice */
1537: /* distribution line pulled over from AP . First it will look for the data in */
1538: /* the AP MRC sub-table otherwise it will get the rates from GL based on the */
1539: /* Invoice Date and compute the amounts and populate the pa_mc_txn_interface_all*/
1540: /* table */

Line 1539: /* Invoice Date and compute the amounts and populate the pa_mc_txn_interface_all*/

1535: /*------------------------------ ins_mc_txn_interface_all ----------------------*/
1536: /* This procedure will populate the Pa_mc_txn_interface_all table for a invoice */
1537: /* distribution line pulled over from AP . First it will look for the data in */
1538: /* the AP MRC sub-table otherwise it will get the rates from GL based on the */
1539: /* Invoice Date and compute the amounts and populate the pa_mc_txn_interface_all*/
1540: /* table */
1541: /*------------------------------------------------------------------------------*/
1542:
1543: /* Changed the IN parameter names and local variables

Line 1609: PAAPIMP_PKG.G_err_stage := ' Insert into pa_mc_txn_interface_all';

1605:
1606: l_old_stack := PAAPIMP_PKG.G_err_stack;
1607: PAAPIMP_PKG.G_err_code := 0;
1608: PAAPIMP_PKG.G_err_stack := PAAPIMP_PKG.G_err_stack||'->PA_MC_CURRENCY_PKG.ins_mc_txn_interface_all';
1609: PAAPIMP_PKG.G_err_stage := ' Insert into pa_mc_txn_interface_all';
1610:
1611: PAAPIMP_PKG.write_log(LOG, PAAPIMP_PKG.G_err_stack);
1612: PAAPIMP_PKG.write_log(LOG, 'Inserting transaction source: '||p_transaction_source||
1613: 'system_ref2 : ' ||p_system_reference2||

Line 1616: ' into pa_mc_txn_interface_all......');

1612: PAAPIMP_PKG.write_log(LOG, 'Inserting transaction source: '||p_transaction_source||
1613: 'system_ref2 : ' ||p_system_reference2||
1614: 'system_ref3 : ' ||p_system_reference3 ||
1615: 'system_ref4: ' ||p_system_reference4||
1616: ' into pa_mc_txn_interface_all......');
1617:
1618: PAAPIMP_PKG.G_err_stage := 'GET ORG_ID IN INS_MC_TXN_INTERFACE';
1619: --select NVL(org_id,-99)
1620: select org_id

Line 1905: PAAPIMP_PKG.write_log(LOG,'before inserting into pa_mc_txn_interface_all table');

1901: END IF;
1902:
1903: END IF;
1904:
1905: PAAPIMP_PKG.write_log(LOG,'before inserting into pa_mc_txn_interface_all table');
1906:
1907: PAAPIMP_PKG.G_err_stage := 'INSERT RECORD INTO PA_MC_TXN_INTERFACE_ALL';
1908: PAAPIMP_PKG.write_log(LOG,'insert SOBID:'||g_rsob_tab(i).rsob_id||
1909: 'insert txn_interface_id:'||l_txn_interface_id||

Line 1907: PAAPIMP_PKG.G_err_stage := 'INSERT RECORD INTO PA_MC_TXN_INTERFACE_ALL';

1903: END IF;
1904:
1905: PAAPIMP_PKG.write_log(LOG,'before inserting into pa_mc_txn_interface_all table');
1906:
1907: PAAPIMP_PKG.G_err_stage := 'INSERT RECORD INTO PA_MC_TXN_INTERFACE_ALL';
1908: PAAPIMP_PKG.write_log(LOG,'insert SOBID:'||g_rsob_tab(i).rsob_id||
1909: 'insert txn_interface_id:'||l_txn_interface_id||
1910: 'insert raw_cost:'||l_raw_cost||
1911: 'exchange rate:'||l_exchange_rate);

Line 1913: INSERT INTO pa_mc_txn_interface_all (

1909: 'insert txn_interface_id:'||l_txn_interface_id||
1910: 'insert raw_cost:'||l_raw_cost||
1911: 'exchange rate:'||l_exchange_rate);
1912:
1913: INSERT INTO pa_mc_txn_interface_all (
1914: set_of_books_id ,
1915: txn_interface_id ,
1916: raw_cost ,
1917: raw_cost_rate ,

Line 1948: ' into pa_mc_txn_interface_all failed in stage: ' || PAAPIMP_PKG.G_err_stage);

1944: PAAPIMP_PKG.G_TRANSACTION_STATUS_CODE := 'R';
1945: PAAPIMP_PKG.G_TRANSACTION_REJECTION_CODE := 'PA_INSERT_MRC_FAILED';
1946: PAAPIMP_PKG.write_log(LOG, 'Inserting system reference2: ' || to_char(p_system_reference2) ||
1947: ' system reference3: ' || to_char(p_system_reference3) ||
1948: ' into pa_mc_txn_interface_all failed in stage: ' || PAAPIMP_PKG.G_err_stage);
1949: PAAPIMP_PKG.write_log(LOG, substr(SQLERRM, 1, 200));
1950:
1951: END ins_mc_txn_interface_all;
1952: -------------------------------------------------------------------------------