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.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_R12_CAT_UPG_UTL

Line 469: PO_R12_CAT_UPG_UTL.add_fatal_error(

465:
466: -- Add error message into INTERFACE_ERRORS table
467: -- ICX_CAT_ERR_IN_GL_CURR_API
468: -- "An error occurred in the call to API_NAME while retrieving the currency conversion rate."
469: PO_R12_CAT_UPG_UTL.add_fatal_error(
470: p_interface_header_id => p_headers_rec.interface_header_id(i),
471: --p_error_message_name => 'PO_CAT_UPG_GL_API1_EXCEPTION',
472: p_error_message_name => 'ICX_CAT_ERR_IN_GL_CURR_API',
473: p_table_name => 'PO_HEADERS_INTERFACE',

Line 530: PO_R12_CAT_UPG_UTL.add_fatal_error(

526: p_headers_rec.has_errors(i) := 'Y';
527: -- Add error message into INTERFACE_ERRORS table
528: -- ICX_CAT_RATE_REQD
529: -- "There is no rate for the rate date and type default combination."
530: PO_R12_CAT_UPG_UTL.add_fatal_error(
531: p_interface_header_id => p_headers_rec.interface_header_id(i),
532: p_error_message_name => 'ICX_CAT_RATE_REQD',
533: p_table_name => 'PO_HEADERS_INTERFACE',
534: p_column_name => 'CURRENCY_CODE',

Line 546: PO_R12_CAT_UPG_UTL.add_fatal_error(

542: p_headers_rec.has_errors(i) := 'Y';
543: -- Add error message into INTERFACE_ERRORS table
544: -- ICX_CAT_INVALID_CURRENCY
545: -- "Default currency code is inactive or invalid."
546: PO_R12_CAT_UPG_UTL.add_fatal_error(
547: p_interface_header_id => p_headers_rec.interface_header_id(i),
548: p_error_message_name => 'ICX_CAT_INVALID_CURRENCY',
549: p_table_name => 'PO_HEADERS_INTERFACE',
550: p_column_name => 'CURRENCY_CODE',

Line 566: PO_R12_CAT_UPG_UTL.add_fatal_error(

562:
563: -- Add error message into INTERFACE_ERRORS table
564: -- ICX_CAT_ERR_IN_GL_CURR_API
565: -- "An error occurred in the call to API_NAME while retrieving the currency conversion rate."
566: PO_R12_CAT_UPG_UTL.add_fatal_error(
567: p_interface_header_id => p_headers_rec.interface_header_id(i),
568: --p_error_message_name => 'PO_CAT_UPG_GL_API2_EXCEPTION',
569: p_error_message_name => 'ICX_CAT_ERR_IN_GL_CURR_API',
570: p_table_name => 'PO_HEADERS_INTERFACE',

Line 659: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(l_size);

655: BEGIN
656: l_progress := '010';
657: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
658:
659: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(l_size);
660:
661: l_progress := '020';
662: -- SQL What: Get vendor related info into session GT table
663: -- SQL Why : It will be used to populate the OUT parameters.

Line 768: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);

764: l_progress := '010';
765:
766: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
767:
768: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);
769:
770: l_progress := '020';
771: -- SQL What: Get the default vendor_site_id if the site_id is NULL in the
772: -- interface table. The site would default only if there is exactly

Line 900: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);

896: l_progress := '010';
897:
898: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
899:
900: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);
901:
902: l_progress := '020';
903: -- SQL What: Get vendor site related info into session GT table
904: -- SQL Why : It will be used to populate the OUT parameters.

Line 1049: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);

1045: BEGIN
1046: l_progress := '010';
1047: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1048:
1049: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_headers_rec.vendor_site_id.COUNT);
1050:
1051: l_progress := '020';
1052: -- SQL What: Get vendor contact id into session GT table
1053: -- SQL Why : It will be used to populate the OUT parameters.

Line 1164: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_headers_rec.po_header_id.COUNT);

1160: BEGIN
1161: l_progress := '010';
1162: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1163:
1164: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_headers_rec.po_header_id.COUNT);
1165:
1166: l_progress := '020';
1167: -- SQL What: Get the buyer from the referenced CPA
1168: -- SQL Why : It will be used to populate the OUT parameters (to default the

Line 1855: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.interface_line_id.COUNT);

1851: BEGIN
1852: l_progress := '010';
1853: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1854:
1855: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.interface_line_id.COUNT);
1856:
1857: l_progress := '030';
1858: -- SQL What: Get the default line type from PSP. If the purchase_basis for
1859: -- this one is not GOODS, default line type to GOODS (seeded

Line 1964: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.line_type_id.COUNT);

1960: BEGIN
1961: l_progress := '010';
1962: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1963:
1964: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.line_type_id.COUNT);
1965:
1966: l_progress := '020';
1967: -- SQL What: Get the line type related info into the session GT table.
1968: -- SQL Why : It will be used to populate the OUT parameters.

Line 2072: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.line_type_id.COUNT);

2068: BEGIN
2069: l_progress := '010';
2070: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2071:
2072: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.line_type_id.COUNT);
2073:
2074: l_progress := '020';
2075: -- SQL What: Default information from item_id into the session GT table.
2076: -- SQL Why : It will be used to populate the OUT parameters.

Line 2179: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_location_ids.COUNT);

2175: BEGIN
2176: l_progress := '010';
2177: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2178:
2179: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_location_ids.COUNT);
2180:
2181: IF (p_location_ids.COUNT > 0) THEN
2182: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_location_ids(1)='||p_location_ids(1)); END IF;
2183: END IF;

Line 2281: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.ship_to_location_id.COUNT);

2277: BEGIN
2278: l_progress := '010';
2279: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2280:
2281: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(x_lines_rec.ship_to_location_id.COUNT);
2282:
2283: l_progress := '020';
2284: -- SQL What: Default hazard_class_id into the session GT table.
2285: -- SQL Why : It will be used to populate the OUT parameters.

Line 2402: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.interface_line_id.COUNT);

2398: BEGIN
2399: l_progress := '010';
2400: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2401:
2402: l_subscript_array := PO_R12_CAT_UPG_UTL.construct_subscript_array(p_lines_rec.interface_line_id.COUNT);
2403:
2404: l_progress := '020';
2405: -- SQL What: Default header related info into the session GT table.
2406: -- SQL Why : It will be used to populate the OUT parameters.