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 589: IF (l_old_request_complete = FND_API.G_TRUE) THEN

585: );
586:
587: d_position := 20;
588:
589: IF (l_old_request_complete = FND_API.G_TRUE) THEN
590: l_tmp_intf_tbl.EXTEND;
591: l_tmp_intf_tbl(l_tmp_intf_tbl.COUNT) := x_intf_header_id_tbl(i);
592: END IF;
593:

Line 703: p_cascade => FND_API.G_TRUE);

699: d_position := 30;
700: PO_PDOI_UTL.reject_headers_intf
701: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
702: p_id_tbl => l_reject_tbl,
703: p_cascade => FND_API.G_TRUE);
704:
705: IF (PO_LOG.d_proc) THEN
706: PO_LOG.proc_end (d_module);
707: END IF;

Line 832: p_cascade => FND_API.G_TRUE

828: -- For records that cannot derive vendor id, reject header and its children
829: PO_PDOI_UTL.reject_headers_intf
830: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
831: p_id_tbl => l_reject_list,
832: p_cascade => FND_API.G_TRUE
833: );
834:
835: IF (PO_LOG.d_proc) THEN
836: PO_LOG.proc_end (d_module);

Line 917: l_valid := FND_API.G_TRUE;

913: END IF;
914:
915: d_position := 20;
916: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
917: l_valid := FND_API.G_TRUE;
918:
919: IF (PO_LOG.d_stmt) THEN
920: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
921: l_interface_header_id_tbl(i));

Line 937: l_valid := FND_API.G_FALSE;

933: p_token1_name => 'COLUMN_NAME',
934: p_token1_value => 'START_DATE'
935: );
936:
937: l_valid := FND_API.G_FALSE;
938: END IF;
939:
940: d_position := 40;
941: -- start date has to be greater than end date

Line 953: l_valid := FND_API.G_FALSE;

949: p_token1_name => 'VALUE',
950: p_token1_value => l_start_date_tbl(i)
951: );
952:
953: l_valid := FND_API.G_FALSE;
954: END IF;
955:
956: d_position := 50;
957:

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

954: END IF;
955:
956: d_position := 50;
957:
958: IF (l_valid = FND_API.G_TRUE) THEN
959:
960: IF (PO_PDOI_PARAMS.g_request.document_type =
961: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN
962:

Line 1050: l_valid := FND_API.G_FALSE;

1046: p_token1_name => 'DOC_NUMBER',
1047: p_token1_value => l_vendor_doc_num_tbl(i)
1048: );
1049: l_index_for_replacement := NULL; -- no id to replace
1050: l_valid := FND_API.G_FALSE;
1051: END IF;
1052: END IF;
1053:
1054: IF (l_index_for_replacement IS NOT NULL) THEN

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

1076: );
1077: END IF;
1078: END IF;
1079:
1080: IF (l_valid = FND_API.G_TRUE) THEN
1081: d_position := 130;
1082:
1083: IF (PO_LOG.d_stmt) THEN
1084: PO_LOG.stmt(d_module, d_position, 'Release date check passed');

Line 1114: p_cascade => FND_API.G_TRUE

1110: -- propagate errors to lower level
1111: PO_PDOI_UTL.reject_headers_intf
1112: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1113: p_id_tbl => l_reject_list,
1114: p_cascade => FND_API.G_TRUE
1115: );
1116:
1117: IF (PO_LOG.d_proc) THEN
1118: PO_LOG.proc_end (d_module);

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

1145: --p_new_doc_start_date
1146: -- proposed start date of the document
1147: --IN OUT:
1148: --x_valid
1149: -- FND_API.G_TRUE if the this validation passes
1150: -- FND_API.G_FALSE otherwise
1151: --OUT:
1152: --End of Comments
1153: ------------------------------------------------------------------------

Line 1150: -- FND_API.G_FALSE otherwise

1146: -- proposed start date of the document
1147: --IN OUT:
1148: --x_valid
1149: -- FND_API.G_TRUE if the this validation passes
1150: -- FND_API.G_FALSE otherwise
1151: --OUT:
1152: --End of Comments
1153: ------------------------------------------------------------------------
1154: PROCEDURE check_release_dates

Line 1200: x_valid := FND_API.G_FALSE;

1196: p_column_name => 'EFFECTIVE_DATE',
1197: p_column_value => p_new_doc_start_date
1198: );
1199:
1200: x_valid := FND_API.G_FALSE;
1201: END IF;
1202:
1203: ELSE
1204: d_position := 20;

Line 1223: x_valid := FND_API.G_FALSE;

1219: p_column_name => 'EFFECTIVE_DATE',
1220: p_column_value => p_new_doc_start_date
1221: );
1222:
1223: x_valid := FND_API.G_FALSE;
1224: END IF;
1225: END IF;
1226:
1227: IF (PO_LOG.d_proc) THEN

Line 1329: l_skip_cat_upload_chk := FND_API.G_TRUE;

1325: END IF;
1326:
1327: IF (PO_PDOI_PARAMS.g_request.calling_module =
1328: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1329: l_skip_cat_upload_chk := FND_API.G_TRUE;
1330: ELSE
1331: l_skip_cat_upload_chk := FND_API.G_FALSE;
1332: END IF;
1333:

Line 1331: l_skip_cat_upload_chk := FND_API.G_FALSE;

1327: IF (PO_PDOI_PARAMS.g_request.calling_module =
1328: PO_PDOI_CONSTANTS.g_call_mod_CATALOG_UPLOAD) THEN
1329: l_skip_cat_upload_chk := FND_API.G_TRUE;
1330: ELSE
1331: l_skip_cat_upload_chk := FND_API.G_FALSE;
1332: END IF;
1333:
1334: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1335: l_valid := FND_API.g_TRUE;

Line 1335: l_valid := FND_API.g_TRUE;

1331: l_skip_cat_upload_chk := FND_API.G_FALSE;
1332: END IF;
1333:
1334: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1335: l_valid := FND_API.g_TRUE;
1336:
1337: IF (PO_LOG.d_stmt) THEN
1338: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
1339: l_interface_header_id_tbl(i));

Line 1367: l_valid := FND_API.g_FALSE;

1363: PO_LOG.stmt(d_module, d_position, 'po header id does not exist or' ||
1364: ' document type does not match');
1365: END IF;
1366:
1367: l_valid := FND_API.g_FALSE;
1368: END IF;
1369:
1370: d_position := 30;
1371:

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

1368: END IF;
1369:
1370: d_position := 30;
1371:
1372: IF (l_valid = FND_API.g_TRUE) THEN
1373: IF (PO_PDOI_PARAMS.g_request.document_type IN
1374: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1375: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1376:

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

1393: x_po_status_rec => l_status_rec,
1394: x_return_status => l_return_status
1395: );
1396:
1397: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1398: d_position := 50;
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSE
1401: d_position := 60;

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: );
1396:
1397: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1398: d_position := 50;
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSE
1401: d_position := 60;
1402: IF (l_status_rec.updatable_flag(1) = 'N') THEN
1403: l_valid := FND_API.g_FALSE;

Line 1403: l_valid := FND_API.g_FALSE;

1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: ELSE
1401: d_position := 60;
1402: IF (l_status_rec.updatable_flag(1) = 'N') THEN
1403: l_valid := FND_API.g_FALSE;
1404: END IF;
1405: END IF;
1406: END IF;
1407: END IF;

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

1405: END IF;
1406: END IF;
1407: END IF;
1408:
1409: IF (l_valid <> FND_API.g_TRUE) THEN
1410: d_position := 70;
1411:
1412: IF (PO_PDOI_PARAMS.g_request.document_type =
1413: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

Line 1436: l_valid := FND_API.g_FALSE;

1432: p_column_value => l_po_header_id_tbl(i),
1433: p_token1_name => 'DOC_NUMBER',
1434: p_token1_value => l_doc_num_for_msg_dsp
1435: );
1436: l_valid := FND_API.g_FALSE;
1437:
1438: l_reject_list.extend;
1439: l_reject_list(l_reject_list.COUNT) := l_interface_header_id_tbl(i);
1440: END IF;

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

1514: INTO l_orig_po_header_id_tbl,
1515: l_orig_consumption_flag_tbl
1516: FROM po_headers POH
1517: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1518: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1519: NVL(l_vendor_doc_num_tbl(i),
1520: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1521: AND POH.segment1 = l_document_num_tbl(i)
1522: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

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

1516: FROM po_headers POH
1517: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1518: AND NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR) =
1519: NVL(l_vendor_doc_num_tbl(i),
1520: NVL(POH.vendor_order_num, FND_API.G_MISS_CHAR))
1521: AND POH.segment1 = l_document_num_tbl(i)
1522: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1523: AND (POH.type_lookup_code = 'STANDARD'
1524: OR

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

1539: INTO l_orig_po_header_id_tbl,
1540: l_orig_consumption_flag_tbl
1541: FROM po_headers POH
1542: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1543: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1544: NVL(l_vendor_doc_num_tbl(i),
1545: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))
1546: AND POH.segment1 = l_document_num_tbl(i)
1547: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type

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

1541: FROM po_headers POH
1542: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1543: AND NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR) =
1544: NVL(l_vendor_doc_num_tbl(i),
1545: NVL(POH.quote_vendor_quote_number, FND_API.G_MISS_CHAR))
1546: AND POH.segment1 = l_document_num_tbl(i)
1547: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1548: AND POH.type_lookup_code = 'QUOTATION'
1549: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=

Line 1602: l_valid := FND_API.g_FALSE;

1598: p_column_value => l_col_value,
1599: p_token1_name => l_token_name,
1600: p_token1_value => l_token_value
1601: );
1602: l_valid := FND_API.g_FALSE;
1603: END IF;
1604:
1605: IF (l_valid = FND_API.g_TRUE) THEN
1606: IF (PO_PDOI_PARAMS.g_request.document_type IN

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

1601: );
1602: l_valid := FND_API.g_FALSE;
1603: END IF;
1604:
1605: IF (l_valid = FND_API.g_TRUE) THEN
1606: IF (PO_PDOI_PARAMS.g_request.document_type IN
1607: (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
1608: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN
1609:

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

1626: x_po_status_rec => l_status_rec,
1627: x_return_status => l_return_status
1628: );
1629:
1630: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1631: d_position := 150;
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSE
1634: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: );
1629:
1630: IF (l_return_status <> FND_API.g_RET_STS_SUCCESS) THEN
1631: d_position := 150;
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSE
1634: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1635: l_status_rec.updatable_flag(1) = 'N') THEN
1636:

Line 1655: l_valid := FND_API.g_FALSE;

1651: p_token1_name => l_token_name,
1652: p_token1_value => l_token_value
1653: );
1654:
1655: l_valid := FND_API.g_FALSE;
1656: END IF;
1657: END IF;
1658: END IF;
1659: END IF;

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

1658: END IF;
1659: END IF;
1660:
1661: d_position := 170;
1662: IF (l_valid = FND_API.g_TRUE) THEN
1663: l_final_intf_header_id_tbl.extend;
1664: l_final_intf_header_id_tbl(l_final_intf_header_id_tbl.COUNT) :=
1665: l_interface_header_id_tbl(i);
1666:

Line 1690: p_cascade => FND_API.G_TRUE

1686: -- propagate rejection status to lower level
1687: PO_PDOI_UTL.reject_headers_intf
1688: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1689: p_id_tbl => l_reject_list,
1690: p_cascade => FND_API.G_TRUE
1691: );
1692:
1693: IF (PO_LOG.d_proc) THEN
1694: PO_LOG.proc_end (d_module);

Line 1808: p_cascade => FND_API.G_TRUE

1804: -- rejected
1805: PO_PDOI_UTL.reject_headers_intf
1806: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
1807: p_id_tbl => l_reject_list,
1808: p_cascade => FND_API.G_TRUE
1809: );
1810:
1811: IF (PO_LOG.d_proc) THEN
1812: PO_LOG.proc_end (d_module);