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 PAAPIMP_PKG

Line 1606: l_old_stack := PAAPIMP_PKG.G_err_stack;

1602: l_inv_pay_id NUMBER;
1603:
1604: BEGIN
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:

Line 1607: PAAPIMP_PKG.G_err_code := 0;

1603:
1604: BEGIN
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);

Line 1608: PAAPIMP_PKG.G_err_stack := PAAPIMP_PKG.G_err_stack||'->PA_MC_CURRENCY_PKG.ins_mc_txn_interface_all';

1604: BEGIN
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||

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 1611: PAAPIMP_PKG.write_log(LOG, 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||
1614: 'system_ref3 : ' ||p_system_reference3 ||
1615: 'system_ref4: ' ||p_system_reference4||

Line 1612: PAAPIMP_PKG.write_log(LOG, 'Inserting transaction source: '||p_transaction_source||

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||
1614: 'system_ref3 : ' ||p_system_reference3 ||
1615: 'system_ref4: ' ||p_system_reference4||
1616: ' into pa_mc_txn_interface_all......');

Line 1618: PAAPIMP_PKG.G_err_stage := 'GET ORG_ID IN INS_MC_TXN_INTERFACE';

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
1621: into l_org_id
1622: from pa_implementations;

Line 1626: PAAPIMP_PKG.G_err_stage := 'CALLING FUNCTIONAL_CURRENCY IN INS_MC_TXN_INTERFACE';

1622: from pa_implementations;
1623:
1624: /**
1625:
1626: PAAPIMP_PKG.G_err_stage := 'CALLING FUNCTIONAL_CURRENCY IN INS_MC_TXN_INTERFACE';
1627: l_currency := pa_mc_currency_pkg.functional_currency(l_org_id);
1628: **/
1629:
1630: PAAPIMP_PKG.G_err_stage := 'CALLING SET_OF_BOOKS IN INS_MC_TXN_INTERFACE';

Line 1630: PAAPIMP_PKG.G_err_stage := 'CALLING SET_OF_BOOKS IN INS_MC_TXN_INTERFACE';

1626: PAAPIMP_PKG.G_err_stage := 'CALLING FUNCTIONAL_CURRENCY IN INS_MC_TXN_INTERFACE';
1627: l_currency := pa_mc_currency_pkg.functional_currency(l_org_id);
1628: **/
1629:
1630: PAAPIMP_PKG.G_err_stage := 'CALLING SET_OF_BOOKS IN INS_MC_TXN_INTERFACE';
1631: l_sob := pa_mc_currency_pkg.set_of_books();
1632:
1633: PAAPIMP_PKG.G_err_stage := 'GET TXN_INTERFACE_ID and BURDEN_COST IN INS_MC_TXN_INTERFACE';
1634:

Line 1633: PAAPIMP_PKG.G_err_stage := 'GET TXN_INTERFACE_ID and BURDEN_COST IN INS_MC_TXN_INTERFACE';

1629:
1630: PAAPIMP_PKG.G_err_stage := 'CALLING SET_OF_BOOKS IN INS_MC_TXN_INTERFACE';
1631: l_sob := pa_mc_currency_pkg.set_of_books();
1632:
1633: PAAPIMP_PKG.G_err_stage := 'GET TXN_INTERFACE_ID and BURDEN_COST IN INS_MC_TXN_INTERFACE';
1634:
1635: -- change the IF conditions to be based on p_system_refernce4
1636: -- IF p_invoice_payment_id IS NULL THEN
1637:

Line 1640: PAAPIMP_PKG.write_log (LOG,'getting denom information for invoices IN INS_MC_TXN_INTERFACE');

1636: -- IF p_invoice_payment_id IS NULL THEN
1637:
1638: IF p_system_reference4 IS NULL THEN
1639:
1640: PAAPIMP_PKG.write_log (LOG,'getting denom information for invoices IN INS_MC_TXN_INTERFACE');
1641:
1642: SELECT txn_interface_id,
1643: denom_burdened_cost,
1644: denom_raw_cost,

Line 1666: PAAPIMP_PKG.write_log (LOG,'getting denom information for non-invoices IN INS_MC_TXN_INTERFACE');

1662: --ELSIF p_invoice_payment_id IS NOT NULL THEN
1663:
1664: ELSIF p_system_reference4 IS NOT NULL THEN
1665:
1666: PAAPIMP_PKG.write_log (LOG,'getting denom information for non-invoices IN INS_MC_TXN_INTERFACE');
1667:
1668: SELECT txn_interface_id,
1669: denom_burdened_cost,
1670: denom_raw_cost,

Line 1686: PAAPIMP_PKG.write_log(LOG,'txn interface id is:'||l_txn_interface_id||

1682: and transaction_source||''= p_transaction_source;
1683:
1684: END IF;
1685:
1686: PAAPIMP_PKG.write_log(LOG,'txn interface id is:'||l_txn_interface_id||
1687: 'denom_burdened_cost is:'||l_burdened_cost||
1688: 'denom_raw_cost is:'||l_txn_raw_cost||
1689: 'denom_currency_code is:'||l_currency);
1690:

Line 1702: PAAPIMP_PKG.G_err_stage := 'CALLING GET_AP_RATE IN INS_MC_TXN_INTERFACE';

1698: --instead of using invoice_payment_id, use system_reference4
1699: IF (p_system_reference4 IS NULL or
1700: p_transaction_source='AP VARIANCE') THEN
1701:
1702: PAAPIMP_PKG.G_err_stage := 'CALLING GET_AP_RATE IN INS_MC_TXN_INTERFACE';
1703:
1704: pa_mc_currency_pkg.get_ap_rate(x_invoice_id => p_system_reference2,
1705: x_line_num => p_system_reference3,
1706: x_system_reference4 => p_system_reference4,

Line 1713: x_err_stack => PAAPIMP_PKG.G_err_stack,

1709: x_exchange_rate => l_ap_exchange_rate,
1710: x_exchange_date => l_ap_exchange_date,
1711: x_exchange_rate_type => l_ap_exchange_rate_type,
1712: x_amount => l_raw_cost,
1713: x_err_stack => PAAPIMP_PKG.G_err_stack,
1714: x_err_stage => PAAPIMP_PKG.G_err_stage,
1715: x_err_code => l_err_code);
1716:
1717: END IF;

Line 1714: x_err_stage => PAAPIMP_PKG.G_err_stage,

1710: x_exchange_date => l_ap_exchange_date,
1711: x_exchange_rate_type => l_ap_exchange_rate_type,
1712: x_amount => l_raw_cost,
1713: x_err_stack => PAAPIMP_PKG.G_err_stack,
1714: x_err_stage => PAAPIMP_PKG.G_err_stage,
1715: x_err_code => l_err_code);
1716:
1717: END IF;
1718:

Line 1730: PAAPIMP_PKG.G_err_stage := 'CALLING GET_PO_RATE IN INS_MC_TXN_INTERFACE';

1726: IF (p_system_reference4 IS NOT NULL AND
1727: p_transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX', 'PO RECEIPT PRICE ADJ'
1728: ,'PO RECEIPT NRTAX PRICE ADJ')) THEN -- pricing changes
1729:
1730: PAAPIMP_PKG.G_err_stage := 'CALLING GET_PO_RATE IN INS_MC_TXN_INTERFACE';
1731:
1732: pa_mc_currency_pkg.get_po_rate(x_po_dist_id => p_system_reference3,
1733: x_rcv_txn_id => p_system_reference4,
1734: x_transaction_source => p_transaction_source,

Line 1740: x_err_stack => PAAPIMP_PKG.G_err_stack,

1736: x_exchange_rate => l_po_exchange_rate,
1737: x_exchange_date => l_po_exchange_date,
1738: x_exchange_rate_type => l_po_exchange_rate_type,
1739: x_amount => l_raw_cost,
1740: x_err_stack => PAAPIMP_PKG.G_err_stack,
1741: x_err_stage => PAAPIMP_PKG.G_err_stage,
1742: x_err_code => l_err_code,
1743: x_acct_evt_id => p_acct_evt_id);
1744:

Line 1741: x_err_stage => PAAPIMP_PKG.G_err_stage,

1737: x_exchange_date => l_po_exchange_date,
1738: x_exchange_rate_type => l_po_exchange_rate_type,
1739: x_amount => l_raw_cost,
1740: x_err_stack => PAAPIMP_PKG.G_err_stack,
1741: x_err_stage => PAAPIMP_PKG.G_err_stage,
1742: x_err_code => l_err_code,
1743: x_acct_evt_id => p_acct_evt_id);
1744:
1745: END IF;

Line 1758: PAAPIMP_PKG.G_err_stage := 'GET EXCHANGE_DATE and INVOICE_DATE IN INS_MC_TXN_INTERFACE';

1754: IF ( l_err_code = -1403 OR l_err_code = 100 OR p_transaction_source='AP DISCOUNTS')
1755:
1756: THEN -- if no AP MRC rates then get rates from GL based on invoice date
1757:
1758: PAAPIMP_PKG.G_err_stage := 'GET EXCHANGE_DATE and INVOICE_DATE IN INS_MC_TXN_INTERFACE';
1759: PAAPIMP_PKG.write_log(LOG,'getting exchange date for transaction_source: '||p_transaction_source);
1760: PAAPIMP_PKG.write_log(LOG,'sys_ref2 is: '||p_system_reference2||
1761: 'sys_ref3 is: '||p_system_reference3||
1762: 'sys_ref4 is: '||p_system_reference4);

Line 1759: PAAPIMP_PKG.write_log(LOG,'getting exchange date for transaction_source: '||p_transaction_source);

1755:
1756: THEN -- if no AP MRC rates then get rates from GL based on invoice date
1757:
1758: PAAPIMP_PKG.G_err_stage := 'GET EXCHANGE_DATE and INVOICE_DATE IN INS_MC_TXN_INTERFACE';
1759: PAAPIMP_PKG.write_log(LOG,'getting exchange date for transaction_source: '||p_transaction_source);
1760: PAAPIMP_PKG.write_log(LOG,'sys_ref2 is: '||p_system_reference2||
1761: 'sys_ref3 is: '||p_system_reference3||
1762: 'sys_ref4 is: '||p_system_reference4);
1763:

Line 1760: PAAPIMP_PKG.write_log(LOG,'sys_ref2 is: '||p_system_reference2||

1756: THEN -- if no AP MRC rates then get rates from GL based on invoice date
1757:
1758: PAAPIMP_PKG.G_err_stage := 'GET EXCHANGE_DATE and INVOICE_DATE IN INS_MC_TXN_INTERFACE';
1759: PAAPIMP_PKG.write_log(LOG,'getting exchange date for transaction_source: '||p_transaction_source);
1760: PAAPIMP_PKG.write_log(LOG,'sys_ref2 is: '||p_system_reference2||
1761: 'sys_ref3 is: '||p_system_reference3||
1762: 'sys_ref4 is: '||p_system_reference4);
1763:
1764: IF (p_system_reference4 IS NULL OR p_transaction_source = 'AP VARIANCE') THEN

Line 1806: PAAPIMP_PKG.write_log(LOG,'primaray set of books id: '||l_sob||

1802: AND a.transaction_id = l_rcv_txn_id;
1803:
1804: END IF;
1805:
1806: PAAPIMP_PKG.write_log(LOG,'primaray set of books id: '||l_sob||
1807: 'reporting set of books id: '||g_rsob_tab(i).rsob_id||
1808: 'exchange date: '||l_exchange_date||
1809: 'currency: '||l_currency||
1810: 'exchange type: '||l_exchange_rate_type||

Line 1814: PAAPIMP_PKG.G_err_stage := 'CALLING GET_RATE IN INS_MC_TXN_INTERFACE 1';

1810: 'exchange type: '||l_exchange_rate_type||
1811: 'exchange rate: '||l_exchange_rate);
1812:
1813:
1814: PAAPIMP_PKG.G_err_stage := 'CALLING GET_RATE IN INS_MC_TXN_INTERFACE 1';
1815: gl_mc_currency_pkg.get_rate( p_primary_set_of_books_id => l_sob,
1816: p_reporting_set_of_books_id => g_rsob_tab(i).rsob_id,
1817: p_trans_date => l_exchange_date,
1818: p_trans_currency_code => l_currency,

Line 1830: PAAPIMP_PKG.write_log(LOG,'after get rate from GL');

1826: p_je_category_name => NULL,
1827: p_result_code => l_result_code,
1828: p_denominator_rate => l_denominator_rate,
1829: p_numerator_rate => l_numerator_rate);
1830: PAAPIMP_PKG.write_log(LOG,'after get rate from GL');
1831:
1832: PAAPIMP_PKG.G_err_stage := 'CALLING CURRROUND IN INS_MC_TXN_INTERFACE PROCEDURE';
1833: IF (l_exchange_rate_type = 'User') THEN
1834:

Line 1832: PAAPIMP_PKG.G_err_stage := 'CALLING CURRROUND IN INS_MC_TXN_INTERFACE PROCEDURE';

1828: p_denominator_rate => l_denominator_rate,
1829: p_numerator_rate => l_numerator_rate);
1830: PAAPIMP_PKG.write_log(LOG,'after get rate from GL');
1831:
1832: PAAPIMP_PKG.G_err_stage := 'CALLING CURRROUND IN INS_MC_TXN_INTERFACE PROCEDURE';
1833: IF (l_exchange_rate_type = 'User') THEN
1834:
1835: l_burdened_cost := pa_mc_currency_pkg.CurrRound
1836: ((l_burdened_cost *l_exchange_rate), g_rsob_tab(i).rcurrency_code);

Line 1873: PAAPIMP_PKG.G_err_stage := 'CALLING GET_RATE IN INS_MC_TXN_INTERFACE 2';

1869: l_exchange_date := l_po_exchange_date;
1870:
1871: END IF;
1872:
1873: PAAPIMP_PKG.G_err_stage := 'CALLING GET_RATE IN INS_MC_TXN_INTERFACE 2';
1874: gl_mc_currency_pkg.get_rate(p_primary_set_of_books_id => l_sob,
1875: p_reporting_set_of_books_id => g_rsob_tab(i).rsob_id,
1876: p_trans_date => l_exchange_date,
1877: p_trans_currency_code => l_currency,

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 1908: PAAPIMP_PKG.write_log(LOG,'insert SOBID:'||g_rsob_tab(i).rsob_id||

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

Line 1936: PAAPIMP_PKG.write_log(LOG,'after inserting');

1932: l_exchange_date );
1933:
1934: END;
1935: END LOOP; -- End of Loop for the cursor c_reporting_sob
1936: PAAPIMP_PKG.write_log(LOG,'after inserting');
1937:
1938: PAAPIMP_PKG.G_err_stack := l_old_stack;
1939:
1940: EXCEPTION

Line 1938: PAAPIMP_PKG.G_err_stack := l_old_stack;

1934: END;
1935: END LOOP; -- End of Loop for the cursor c_reporting_sob
1936: PAAPIMP_PKG.write_log(LOG,'after inserting');
1937:
1938: PAAPIMP_PKG.G_err_stack := l_old_stack;
1939:
1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: PAAPIMP_PKG.G_err_stack := l_old_stack;

Line 1942: PAAPIMP_PKG.G_err_stack := l_old_stack;

1938: PAAPIMP_PKG.G_err_stack := l_old_stack;
1939:
1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: PAAPIMP_PKG.G_err_stack := l_old_stack;
1943: PAAPIMP_PKG.G_err_code := SQLCODE;
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) ||

Line 1943: PAAPIMP_PKG.G_err_code := SQLCODE;

1939:
1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: PAAPIMP_PKG.G_err_stack := l_old_stack;
1943: PAAPIMP_PKG.G_err_code := SQLCODE;
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) ||

Line 1944: PAAPIMP_PKG.G_TRANSACTION_STATUS_CODE := 'R';

1940: EXCEPTION
1941: WHEN OTHERS THEN
1942: PAAPIMP_PKG.G_err_stack := l_old_stack;
1943: PAAPIMP_PKG.G_err_code := SQLCODE;
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);

Line 1945: PAAPIMP_PKG.G_TRANSACTION_REJECTION_CODE := 'PA_INSERT_MRC_FAILED';

1941: WHEN OTHERS THEN
1942: PAAPIMP_PKG.G_err_stack := l_old_stack;
1943: PAAPIMP_PKG.G_err_code := SQLCODE;
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));

Line 1946: PAAPIMP_PKG.write_log(LOG, 'Inserting system reference2: ' || to_char(p_system_reference2) ||

1942: PAAPIMP_PKG.G_err_stack := l_old_stack;
1943: PAAPIMP_PKG.G_err_code := SQLCODE;
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:

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: -------------------------------------------------------------------------------

Line 1949: PAAPIMP_PKG.write_log(LOG, substr(SQLERRM, 1, 200));

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: -------------------------------------------------------------------------------
1953: