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_PDOI_MAINPROC_PVT dependencies on FND_API

Line 131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

127: -- Remove all unprocessed records if error threshold is hit for CATALOG UPLOAD
128: IF (PO_PDOI_PARAMS.g_request.calling_module =
129: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
134: PO_PDOI_PARAMS.g_request.interface_header_id);
135: END IF;

Line 286: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN

282: -- Rejected header records with errors
283: l_rej_intf_header_id_tbl.EXTEND(l_headers.rec_count);
284: FOR i IN 1..l_headers.rec_count
285: LOOP
286: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN
287: IF (PO_LOG.d_stmt) THEN
288: PO_LOG.stmt(d_module, d_position, 'rejected intf header id',
289: l_headers.intf_header_id_tbl(i));
290: END IF;

Line 300: p_cascade => FND_API.g_TRUE

296: PO_PDOI_UTL.reject_headers_intf
297: (
298: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
299: p_id_tbl => l_rej_intf_header_id_tbl,
300: p_cascade => FND_API.g_TRUE
301: );
302: l_rej_intf_header_id_tbl.DELETE;
303:
304: d_position := 70;

Line 549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

545: -- exit immediately if error threshold is hit for CATALOG UPLOAD
546: IF (PO_PDOI_PARAMS.g_request.calling_module =
547: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN
551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
552: ' error threshold is hit for header ',
553: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

575: -- threshold for each batch
576: IF (PO_PDOI_PARAMS.g_request.calling_module =
577: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
582: PO_PDOI_PARAMS.g_request.interface_header_id);
583: END IF;

Line 699: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR

695:
696: -- reject lines with errors
697: FOR i IN 1..l_lines.rec_count
698: LOOP
699: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
701: IF (PO_LOG.d_stmt) THEN
702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));

Line 700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN

696: -- reject lines with errors
697: FOR i IN 1..l_lines.rec_count
698: LOOP
699: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
701: IF (PO_LOG.d_stmt) THEN
702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));
704: PO_LOG.stmt(d_module, d_position, 'reject flag',

Line 718: p_cascade => FND_API.g_TRUE

714: PO_PDOI_UTL.reject_lines_intf
715: (
716: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
717: p_id_tbl => l_rej_intf_line_id_tbl,
718: p_cascade => FND_API.g_TRUE
719: );
720: l_rej_intf_line_id_tbl.DELETE;
721:
722: d_position := 110;

Line 787: p_cascade => FND_API.g_TRUE

783: PO_PDOI_UTL.reject_lines_intf
784: (
785: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
786: p_id_tbl => l_rej_intf_line_id_tbl,
787: p_cascade => FND_API.g_TRUE
788: );
789:
790: d_position := 160;
791:

Line 896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

892: -- exit immediately if error threshold is hit for CATALOG UPLOAD
893: IF (PO_PDOI_PARAMS.g_request.calling_module =
894: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
899: ' error threshold is hit for header ',
900: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

922: -- threshold for the previous batch
923: IF (PO_PDOI_PARAMS.g_request.calling_module =
924: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
925: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
927: d_position := 20;
928:
929: IF (PO_LOG.d_stmt) THEN
930: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

Line 1135: p_cascade => FND_API.g_TRUE

1131: PO_PDOI_UTL.reject_lines_intf
1132: (
1133: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1134: p_id_tbl => l_rej_intf_line_id_tbl,
1135: p_cascade => FND_API.g_TRUE
1136: );
1137:
1138: d_position := 140;
1139:

Line 1304: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR

1300: -- reject lines with errors
1301: l_rej_intf_line_id_tbl.EXTEND(x_lines.rec_count);
1302: FOR i IN 1..x_lines.rec_count
1303: LOOP
1304: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1306: IF (PO_LOG.d_stmt) THEN
1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));

Line 1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN

1301: l_rej_intf_line_id_tbl.EXTEND(x_lines.rec_count);
1302: FOR i IN 1..x_lines.rec_count
1303: LOOP
1304: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1306: IF (PO_LOG.d_stmt) THEN
1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));
1309: PO_LOG.stmt(d_module, d_position, 'reject flag',

Line 1323: p_cascade => FND_API.g_TRUE

1319: PO_PDOI_UTL.reject_lines_intf
1320: (
1321: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1322: p_id_tbl => l_rej_intf_line_id_tbl,
1323: p_cascade => FND_API.g_TRUE
1324: );
1325: l_rej_intf_line_id_tbl.DELETE;
1326:
1327: d_position := 80;

Line 1449: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR

1445: -- set rejected status to lines and lower levels
1446: l_rej_intf_line_id_tbl.EXTEND(x_lines.rec_count);
1447: FOR i IN 1..x_lines.rec_count
1448: LOOP
1449: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1451: IF (PO_LOG.d_stmt) THEN
1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));

Line 1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN

1446: l_rej_intf_line_id_tbl.EXTEND(x_lines.rec_count);
1447: FOR i IN 1..x_lines.rec_count
1448: LOOP
1449: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1451: IF (PO_LOG.d_stmt) THEN
1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));
1454: PO_LOG.stmt(d_module, d_position, 'reject flag',

Line 1468: p_cascade => FND_API.g_TRUE

1464: PO_PDOI_UTL.reject_lines_intf
1465: (
1466: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_ID,
1467: p_id_tbl => l_rej_intf_line_id_tbl,
1468: p_cascade => FND_API.g_TRUE
1469: );
1470: l_rej_intf_line_id_tbl.DELETE;
1471:
1472: IF (PO_LOG.d_proc) THEN

Line 1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

1539: -- exit immediately if error threshold is hit for CATALOG UPLOAD
1540: IF (PO_PDOI_PARAMS.g_request.calling_module =
1541: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1546: ' error threshold is hit for header ',
1547: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

1570: -- threshold for the previous batch
1571: IF (PO_PDOI_PARAMS.g_request.calling_module =
1572: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1573: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1575: d_position := 20;
1576:
1577: IF (PO_LOG.d_stmt) THEN
1578: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

Line 1685: IF (l_line_locs.error_flag_tbl(i) = FND_API.G_TRUE) THEN

1681:
1682: -- set rejected status to line locations and lower levels
1683: FOR i IN 1..l_line_locs.rec_count
1684: LOOP
1685: IF (l_line_locs.error_flag_tbl(i) = FND_API.G_TRUE) THEN
1686: l_rej_intf_line_loc_id_tbl.EXTEND;
1687: l_rej_intf_line_loc_id_tbl(l_rej_intf_line_loc_id_tbl.COUNT) := l_line_locs.intf_line_loc_id_tbl(i);
1688:
1689: -- bug 5215781:

Line 1714: p_cascade => FND_API.g_TRUE

1710: PO_PDOI_UTL.reject_line_locations_intf
1711: (
1712: p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_LINE_LOCATION_ID,
1713: p_id_tbl => l_rej_intf_line_loc_id_tbl,
1714: p_cascade => FND_API.g_TRUE
1715: );
1716: l_rej_intf_line_loc_id_tbl.DELETE;
1717:
1718: d_position := 100;

Line 1725: l_line_locs.error_flag_tbl(i) = FND_API.g_FALSE) THEN

1721: l_count := 0;
1722: FOR i IN 1..l_line_locs.rec_count
1723: LOOP
1724: IF (NOT l_line_ref_tbl.EXISTS(l_line_locs.ln_po_line_id_tbl(i)) AND
1725: l_line_locs.error_flag_tbl(i) = FND_API.g_FALSE) THEN
1726: l_count := l_count + 1;
1727: l_processed_line_id_tbl(l_count) := l_line_locs.ln_po_line_id_tbl(i);
1728: l_processed_draft_id_tbl(l_count) := l_line_locs.draft_id_tbl(i);
1729: l_line_ref_tbl(l_line_locs.ln_po_line_id_tbl(i)) := i;

Line 1955: IF (l_dists.error_flag_tbl(i) = FND_API.G_TRUE) THEN

1951:
1952: -- set rejected status to distributions
1953: FOR i IN 1..l_dists.rec_count
1954: LOOP
1955: IF (l_dists.error_flag_tbl(i) = FND_API.G_TRUE) THEN
1956: l_rej_intf_dist_id_tbl.EXTEND;
1957: l_rej_intf_dist_id_tbl(l_rej_intf_dist_id_tbl.COUNT) := l_dists.intf_dist_id_tbl(i);
1958: END IF;
1959: END LOOP;

Line 1982: AND l_dists.error_flag_tbl(i) = FND_API.g_FALSE;

1978: FORALL i IN 1..l_dists.intf_dist_id_tbl.COUNT
1979: UPDATE po_distributions_interface
1980: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
1981: WHERE interface_distribution_id = l_dists.intf_dist_id_tbl(i)
1982: AND l_dists.error_flag_tbl(i) = FND_API.g_FALSE;
1983:
1984: d_position := 110;
1985:
1986: PO_PDOI_UTL.commit_work;

Line 2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

2087: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2088: IF (PO_PDOI_PARAMS.g_request.calling_module =
2089: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN
2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2094: ' error threshold is hit for header ',
2095: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

2118: -- threshold for the previous batch
2119: IF (PO_PDOI_PARAMS.g_request.calling_module =
2120: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2121: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2123: d_position := 20;
2124:
2125: IF (PO_LOG.d_stmt) THEN
2126: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

Line 2179: IF (l_price_diffs.error_flag_tbl(i) = FND_API.G_TRUE) THEN

2175:
2176: -- set rejected status
2177: FOR i IN 1..l_price_diffs.rec_count
2178: LOOP
2179: IF (l_price_diffs.error_flag_tbl(i) = FND_API.G_TRUE) THEN
2180: l_rej_intf_price_diff_id_tbl.EXTEND;
2181: l_rej_intf_price_diff_id_tbl(l_rej_intf_price_diff_id_tbl.COUNT) := l_price_diffs.intf_price_diff_id_tbl(i);
2182: END IF;
2183: END LOOP;

Line 2204: AND l_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;

2200: FORALL i IN 1..l_price_diffs.intf_price_diff_id_tbl.COUNT
2201: UPDATE po_price_diff_interface
2202: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
2203: WHERE price_diff_interface_id = l_price_diffs.intf_price_diff_id_tbl(i)
2204: AND l_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
2205:
2206: PO_PDOI_UTL.commit_work;
2207:
2208: IF (l_price_diffs.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

Line 2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN

2295: -- exit immediately if error threshold is hit for CATALOG UPLOAD
2296: IF (PO_PDOI_PARAMS.g_request.calling_module =
2297: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN
2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2302: ' error threshold is hit for header ',
2303: PO_PDOI_PARAMS.g_request.interface_header_id);

Line 2484: AND l_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;

2480: FORALL i IN 1..l_attr_values.intf_attr_values_id_tbl.COUNT
2481: UPDATE po_attr_values_interface
2482: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
2483: WHERE interface_attr_values_id = l_attr_values.intf_attr_values_id_tbl(i)
2484: AND l_attr_values.error_flag_tbl(i) = FND_API.g_FALSE;
2485:
2486: PO_PDOI_UTL.commit_work;
2487:
2488: IF (l_attr_values.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN

Line 2675: AND l_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;

2671: FORALL i IN 1..l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT
2672: UPDATE po_attr_values_tlp_interface
2673: SET process_code = PO_PDOI_CONSTANTS.g_PROCESS_CODE_ACCEPTED
2674: WHERE interface_attr_values_tlp_id = l_attr_values_tlp.intf_attr_values_tlp_id_tbl(i)
2675: AND l_attr_values_tlp.error_flag_tbl(i) = FND_API.g_FALSE;
2676:
2677: PO_PDOI_UTL.commit_work;
2678:
2679: IF (l_attr_values_tlp.rec_count < PO_PDOI_CONSTANTS.g_DEF_BATCH_SIZE) THEN