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.CLN_NTFYINVC_PKG dependencies on CLN_AP_INVOICE_REJECTION_ARCH

Line 1394: FROM CLN_AP_INVOICE_REJECTION_ARCH

1390:
1391: BEGIN
1392: SELECT REJECT_REASON_STRING
1393: INTO l_error_reject_string
1394: FROM CLN_AP_INVOICE_REJECTION_ARCH
1395: WHERE invoice_id = l_invoice_id;
1396: EXCEPTION
1397: WHEN NO_DATA_FOUND then
1398: --NO ERRORS stored in acrival table

Line 1403: cln_debug_pub.Add(' l_error_reject_string from CLN_AP_INVOICE_REJECTION_ARCH : ' || l_error_reject_string, 1);

1399: l_error_reject_string := null;
1400: END;
1401:
1402: IF (l_Debug_Level <= 1) THEN
1403: cln_debug_pub.Add(' l_error_reject_string from CLN_AP_INVOICE_REJECTION_ARCH : ' || l_error_reject_string, 1);
1404: END IF;
1405:
1406: IF l_error_reject_string is null THEN
1407: --If no errors found in CLN_AP_INVOICE_REJECTION_ARCH try to scan the interface table again

Line 1407: --If no errors found in CLN_AP_INVOICE_REJECTION_ARCH try to scan the interface table again

1403: cln_debug_pub.Add(' l_error_reject_string from CLN_AP_INVOICE_REJECTION_ARCH : ' || l_error_reject_string, 1);
1404: END IF;
1405:
1406: IF l_error_reject_string is null THEN
1407: --If no errors found in CLN_AP_INVOICE_REJECTION_ARCH try to scan the interface table again
1408: l_error_reject_string := GET_AR_REJECTIONS_STRING(l_invoice_id);
1409: END IF;
1410:
1411: IF (l_Debug_Level <= 1) THEN

Line 1793: cln_debug_pub.Add('Before inserting data into CLN_AP_INVOICE_REJECTION_ARCH', 1);

1789: FROM ap_invoices_interface
1790: WHERE invoice_id = p_invoice_id;
1791:
1792: IF (l_Debug_Level <= 1) THEN
1793: cln_debug_pub.Add('Before inserting data into CLN_AP_INVOICE_REJECTION_ARCH', 1);
1794: END IF;
1795:
1796: IF (l_Debug_Level <= 1) THEN
1797: cln_debug_pub.Add('l_invoice_number : ' || l_invoice_number, 1);

Line 1803: INSERT INTO CLN_AP_INVOICE_REJECTION_ARCH(

1799: cln_debug_pub.Add('l_invoice_amount : ' || l_invoice_amount, 1);
1800: cln_debug_pub.Add('l_po_number : ' || l_po_number, 1);
1801: END IF;
1802:
1803: INSERT INTO CLN_AP_INVOICE_REJECTION_ARCH(
1804: invoice_id,
1805: xmlg_internal_control_number,
1806: invoice_number,
1807: reference_id,

Line 1867: cln_debug_pub.Add('rows not available in ap_invoices_interface. Querying CLN_AP_INVOICE_REJECTION_ARCH',1);

1863: WHERE invoice_id = p_invoice_id;
1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: IF (l_debug_level <= 1) THEN
1867: cln_debug_pub.Add('rows not available in ap_invoices_interface. Querying CLN_AP_INVOICE_REJECTION_ARCH',1);
1868: END IF;
1869: --The following query should not error out... If it errors out, Its an exception condition
1870: SELECT invoice_number, po_number, invoice_amount, invoice_date
1871: INTO x_invoice_num, x_po_num, x_invoice_amt, x_invoice_date

Line 1872: FROM CLN_AP_INVOICE_REJECTION_ARCH

1868: END IF;
1869: --The following query should not error out... If it errors out, Its an exception condition
1870: SELECT invoice_number, po_number, invoice_amount, invoice_date
1871: INTO x_invoice_num, x_po_num, x_invoice_amt, x_invoice_date
1872: FROM CLN_AP_INVOICE_REJECTION_ARCH
1873: WHERE invoice_id = p_invoice_id;
1874: END;
1875:
1876: