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

Line 637: IF (l_old_request_complete = FND_API.G_TRUE) THEN

633: );
634:
635: d_position := 20;
636:
637: IF (l_old_request_complete = FND_API.G_TRUE) THEN
638: l_tmp_intf_tbl.EXTEND;
639: l_tmp_intf_tbl(l_tmp_intf_tbl.COUNT) := x_intf_header_id_tbl(i);
640: END IF;
641:

Line 751: p_cascade => FND_API.G_TRUE);

747: d_position := 30;
748: PO_PDOI_UTL.reject_headers_intf
749: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
750: p_id_tbl => l_reject_tbl,
751: p_cascade => FND_API.G_TRUE);
752:
753: IF (PO_LOG.d_proc) THEN
754: PO_LOG.proc_end (d_module);
755: END IF;

Line 913: p_cascade => FND_API.G_TRUE

909: -- For records that cannot derive vendor id, reject header and its children
910: PO_PDOI_UTL.reject_headers_intf
911: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
912: p_id_tbl => l_reject_list,
913: p_cascade => FND_API.G_TRUE
914: );
915:
916: IF (PO_LOG.d_proc) THEN
917: PO_LOG.proc_end (d_module);

Line 998: l_valid := FND_API.G_TRUE;

994: END IF;
995:
996: d_position := 20;
997: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
998: l_valid := FND_API.G_TRUE;
999:
1000: IF (PO_LOG.d_stmt) THEN
1001: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
1002: l_interface_header_id_tbl(i));

Line 1018: l_valid := FND_API.G_FALSE;

1014: p_token1_name => 'COLUMN_NAME',
1015: p_token1_value => 'START_DATE'
1016: );
1017:
1018: l_valid := FND_API.G_FALSE;
1019: END IF;
1020:
1021: d_position := 40;
1022: -- start date has to be greater than end date

Line 1034: l_valid := FND_API.G_FALSE;

1030: p_token1_name => 'VALUE',
1031: p_token1_value => l_start_date_tbl(i)
1032: );
1033:
1034: l_valid := FND_API.G_FALSE;
1035: END IF;
1036:
1037: d_position := 50;
1038:

Line 1039: IF (l_valid = FND_API.G_TRUE) THEN

1035: END IF;
1036:
1037: d_position := 50;
1038:
1039: IF (l_valid = FND_API.G_TRUE) THEN
1040:
1041: IF (PO_PDOI_PARAMS.g_request.document_type =
1042: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
1043:

Line 1132: l_valid := FND_API.G_FALSE;

1128: p_token1_name => 'DOC_NUMBER',
1129: p_token1_value => l_vendor_doc_num_tbl(i)
1130: );
1131: l_index_for_replacement := NULL; -- no id to replace
1132: l_valid := FND_API.G_FALSE;
1133: END IF;
1134: END IF;
1135:
1136: IF (l_index_for_replacement IS NOT NULL) THEN

Line 1162: IF (l_valid = FND_API.G_TRUE) THEN

1158: );
1159: END IF;
1160: END IF;
1161:
1162: IF (l_valid = FND_API.G_TRUE) THEN
1163: d_position := 130;
1164:
1165: IF (PO_LOG.d_stmt) THEN
1166: PO_LOG.stmt(d_module, d_position, 'Release date check passed');

Line 1196: p_cascade => FND_API.G_TRUE

1192: -- propagate errors to lower level
1193: PO_PDOI_UTL.reject_headers_intf
1194: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1195: p_id_tbl => l_reject_list,
1196: p_cascade => FND_API.G_TRUE
1197: );
1198:
1199: IF (PO_LOG.d_proc) THEN
1200: PO_LOG.proc_end (d_module);

Line 1231: -- FND_API.G_TRUE if the this validation passes

1227: --p_new_doc_start_date
1228: -- proposed start date of the document
1229: --IN OUT:
1230: --x_valid
1231: -- FND_API.G_TRUE if the this validation passes
1232: -- FND_API.G_FALSE otherwise
1233: --OUT:
1234: --End of Comments
1235: ------------------------------------------------------------------------

Line 1232: -- FND_API.G_FALSE otherwise

1228: -- proposed start date of the document
1229: --IN OUT:
1230: --x_valid
1231: -- FND_API.G_TRUE if the this validation passes
1232: -- FND_API.G_FALSE otherwise
1233: --OUT:
1234: --End of Comments
1235: ------------------------------------------------------------------------
1236: PROCEDURE check_release_dates

Line 1282: x_valid := FND_API.G_FALSE;

1278: p_column_name => 'EFFECTIVE_DATE',
1279: p_column_value => p_new_doc_start_date
1280: );
1281:
1282: x_valid := FND_API.G_FALSE;
1283: END IF;
1284:
1285: ELSE
1286: d_position := 20;

Line 1305: x_valid := FND_API.G_FALSE;

1301: p_column_name => 'EFFECTIVE_DATE',
1302: p_column_value => p_new_doc_start_date
1303: );
1304:
1305: x_valid := FND_API.G_FALSE;
1306: END IF;
1307: END IF;
1308:
1309: IF (PO_LOG.d_proc) THEN

Line 1411: l_skip_cat_upload_chk := FND_API.G_TRUE;

1407: END IF;
1408:
1409: IF (PO_PDOI_PARAMS.g_request.calling_module =
1410: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1411: l_skip_cat_upload_chk := FND_API.G_TRUE;
1412: ELSE
1413: l_skip_cat_upload_chk := FND_API.G_FALSE;
1414: END IF;
1415:

Line 1413: l_skip_cat_upload_chk := FND_API.G_FALSE;

1409: IF (PO_PDOI_PARAMS.g_request.calling_module =
1410: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1411: l_skip_cat_upload_chk := FND_API.G_TRUE;
1412: ELSE
1413: l_skip_cat_upload_chk := FND_API.G_FALSE;
1414: END IF;
1415:
1416: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1417: l_valid := FND_API.g_TRUE;

Line 1417: l_valid := FND_API.g_TRUE;

1413: l_skip_cat_upload_chk := FND_API.G_FALSE;
1414: END IF;
1415:
1416: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1417: l_valid := FND_API.g_TRUE;
1418:
1419: IF (PO_LOG.d_stmt) THEN
1420: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
1421: l_interface_header_id_tbl(i));

Line 1449: l_valid := FND_API.g_FALSE;

1445: PO_LOG.stmt(d_module, d_position, 'po header id does not exist or' ||
1446: ' document type does not match');
1447: END IF;
1448:
1449: l_valid := FND_API.g_FALSE;
1450: END IF;
1451:
1452: d_position := 30;
1453:

Line 1454: IF (l_valid = FND_API.g_TRUE) THEN

1450: END IF;
1451:
1452: d_position := 30;
1453:
1454: IF (l_valid = FND_API.g_TRUE) THEN
1455: IF (PO_PDOI_PARAMS.g_request.document_type IN
1456: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1457: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1458:

Line 1479: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

1475: x_po_status_rec => l_status_rec,
1476: x_return_status => l_return_status
1477: );
1478:
1479: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1480: d_position := 50;
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSE
1483: d_position := 60;

Line 1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1477: );
1478:
1479: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1480: d_position := 50;
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSE
1483: d_position := 60;
1484: IF (l_status_rec.updatable_flag(1) = 'N') THEN
1485: l_valid := FND_API.g_FALSE;

Line 1485: l_valid := FND_API.g_FALSE;

1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSE
1483: d_position := 60;
1484: IF (l_status_rec.updatable_flag(1) = 'N') THEN
1485: l_valid := FND_API.g_FALSE;
1486: END IF;
1487: END IF;
1488: END IF;
1489: END IF;

Line 1491: IF (l_valid <> FND_API.g_TRUE) THEN

1487: END IF;
1488: END IF;
1489: END IF;
1490:
1491: IF (l_valid <> FND_API.g_TRUE) THEN
1492: d_position := 70;
1493:
1494: IF (PO_PDOI_PARAMS.g_request.document_type =
1495: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

Line 1518: l_valid := FND_API.g_FALSE;

1514: p_column_value => l_po_header_id_tbl(i),
1515: p_token1_name => 'DOC_NUMBER',
1516: p_token1_value => l_doc_num_for_msg_dsp
1517: );
1518: l_valid := FND_API.g_FALSE;
1519:
1520: l_reject_list.extend;
1521: l_reject_list(l_reject_list.COUNT) := l_interface_header_id_tbl(i);
1522: END IF;

Line 1600: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =

1596: INTO l_orig_po_header_id_tbl,
1597: l_orig_consumption_flag_tbl
1598: FROM po_headers POH
1599: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1600: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1601: NVL(l_vendor_doc_num_tbl(i),
1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1603: AND POH.segment1 = l_document_num_tbl(i)
1604: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))

1598: FROM po_headers POH
1599: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1600: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1601: NVL(l_vendor_doc_num_tbl(i),
1602: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1603: AND POH.segment1 = l_document_num_tbl(i)
1604: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1605: AND (POH.type_lookup_code = 'STANDARD'
1606: OR

Line 1625: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =

1621: INTO l_orig_po_header_id_tbl,
1622: l_orig_consumption_flag_tbl
1623: FROM po_headers POH
1624: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1625: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1626: NVL(l_vendor_doc_num_tbl(i),
1627: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))
1628: AND POH.segment1 = l_document_num_tbl(i)
1629: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

Line 1627: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))

1623: FROM po_headers POH
1624: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1625: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1626: NVL(l_vendor_doc_num_tbl(i),
1627: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))
1628: AND POH.segment1 = l_document_num_tbl(i)
1629: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1630: AND POH.type_lookup_code = 'QUOTATION'
1631: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=

Line 1684: l_valid := FND_API.g_FALSE;

1680: p_column_value => l_col_value,
1681: p_token1_name => l_token_name,
1682: p_token1_value => l_token_value
1683: );
1684: l_valid := FND_API.g_FALSE;
1685: END IF;
1686:
1687: IF (l_valid = FND_API.g_TRUE) THEN
1688: IF (PO_PDOI_PARAMS.g_request.document_type IN

Line 1687: IF (l_valid = FND_API.g_TRUE) THEN

1683: );
1684: l_valid := FND_API.g_FALSE;
1685: END IF;
1686:
1687: IF (l_valid = FND_API.g_TRUE) THEN
1688: IF (PO_PDOI_PARAMS.g_request.document_type IN
1689: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1690: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1691:

Line 1712: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN

1708: x_po_status_rec => l_status_rec,
1709: x_return_status => l_return_status
1710: );
1711:
1712: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1713: d_position := 150;
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: ELSE
1716: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR

Line 1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1710: );
1711:
1712: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1713: d_position := 150;
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: ELSE
1716: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1717: l_status_rec.updatable_flag(1) = 'N') THEN
1718:

Line 1737: l_valid := FND_API.g_FALSE;

1733: p_token1_name => l_token_name,
1734: p_token1_value => l_token_value
1735: );
1736:
1737: l_valid := FND_API.g_FALSE;
1738: END IF;
1739: END IF;
1740: END IF;
1741: END IF;

Line 1744: IF (l_valid = FND_API.g_TRUE) THEN

1740: END IF;
1741: END IF;
1742:
1743: d_position := 170;
1744: IF (l_valid = FND_API.g_TRUE) THEN
1745: l_final_intf_header_id_tbl.extend;
1746: l_final_intf_header_id_tbl(l_final_intf_header_id_tbl.COUNT) :=
1747: l_interface_header_id_tbl(i);
1748:

Line 1772: p_cascade => FND_API.G_TRUE

1768: -- propagate rejection status to lower level
1769: PO_PDOI_UTL.reject_headers_intf
1770: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1771: p_id_tbl => l_reject_list,
1772: p_cascade => FND_API.G_TRUE
1773: );
1774:
1775: IF (PO_LOG.d_proc) THEN
1776: PO_LOG.proc_end (d_module);

Line 1890: p_cascade => FND_API.G_TRUE

1886: -- rejected
1887: PO_PDOI_UTL.reject_headers_intf
1888: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1889: p_id_tbl => l_reject_list,
1890: p_cascade => FND_API.G_TRUE
1891: );
1892:
1893: IF (PO_LOG.d_proc) THEN
1894: PO_LOG.proc_end (d_module);

Line 3247: p_cascade => FND_API.G_TRUE

3243:
3244: PO_PDOI_UTL.reject_headers_intf
3245: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
3246: p_id_tbl => l_reject_list,
3247: p_cascade => FND_API.G_TRUE
3248: );
3249:
3250: EXCEPTION
3251: WHEN OTHERS THEN