APPS.PO_PDOI_PREPROC_PVT dependencies on STANDARD

Line 74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

70:
71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
72:
73: IF (PO_PDOI_PARAMS.g_request.document_type <>
74: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
75: AND
76: PO_PDOI_PARAMS.g_request.process_code =
77: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED) THEN
78:

Line 476: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

472: END IF;
473:
474: d_position := 70;
475: IF (PO_PDOI_PARAMS.g_request.document_type =
476: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
477: FORALL i IN 1..l_intf_line_id_tbl.COUNT
478: UPDATE po_distributions_interface
479: SET processing_id = PO_PDOI_PARAMS.g_processing_id
480: WHERE interface_line_id = l_intf_line_id_tbl(i);

Line 490: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

486: END IF;
487:
488: d_position := 80;
489: IF (PO_PDOI_PARAMS.g_request.document_type <>
490: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
491:
492: d_position := 90;
493: FORALL i IN 1..l_intf_line_id_tbl.COUNT
494: UPDATE po_attr_values_interface

Line 666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND

662: PO_PDOI_CONSTANTS.g_ACTION_ADD,
663: PO_PDOI_CONSTANTS.g_ACTION_REPLACE,
664: PO_PDOI_CONSTANTS.g_ACTION_UPDATE))
665: OR
666: (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD AND
667: action NOT IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
668: PO_PDOI_CONSTANTS.g_ACTION_ADD,
669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:

Line 679: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD

675: l_reject_tbl.COUNT);
676: END IF;
677:
678: FOR i IN 1..l_reject_tbl.COUNT LOOP
679: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
680: AND
681: l_action_tbl(i) = PO_PDOI_CONSTANTS.g_ACTION_REPLACE) THEN
682:
683: l_message_name := 'PO_PDOI_STD_ACTION';

Line 1375: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

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:
1377: d_position := 40;
1378:
1379: PO_PDOI_UTL.get_processing_doctype_info

Line 1413: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

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
1414: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1415: ELSE
1416: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1417: END IF;

Line 1455: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1451: IF (l_vendor_doc_num_tbl(i) IS NOT NULL) THEN
1452: -- Definitely need to match vendor doc num. Matching document num
1453: -- will be performed, if provided
1454: IF (PO_PDOI_PARAMS.g_request.document_type IN
1455: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1456: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1457:
1458: d_position := 90;
1459: SELECT POH.po_header_id,

Line 1469: AND (POH.type_lookup_code = 'STANDARD'

1465: WHERE POH.vendor_id = l_vendor_id_tbl(i)
1466: AND POH.vendor_order_num = l_vendor_doc_num_tbl(i)
1467: AND POH.segment1 = NVL(l_document_num_tbl(i), POH.segment1)
1468: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type
1469: AND (POH.type_lookup_code = 'STANDARD'
1470: OR
1471: (POH.type_lookup_code = 'BLANKET'
1472: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1473: TRUNC(NVL(POH.start_date, SYSDATE))

Line 1508: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,

1504: -- Definitely need to match document num. Matching vendor doc num
1505: -- will be performed, if provided
1506:
1507: IF (PO_PDOI_PARAMS.g_request.document_type IN
1508: (PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
1509: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET)) THEN
1510:
1511: SELECT POH.po_header_id,
1512: NVL(POH.consigned_consumption_flag, 'N')

Line 1523: AND (POH.type_lookup_code = 'STANDARD'

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
1525: (POH.type_lookup_code = 'BLANKET'
1526: AND TRUNC(NVL(l_start_date_tbl(i), SYSDATE)) >=
1527: TRUNC(NVL(POH.start_date, SYSDATE))

Line 1577: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1573:
1574: IF (l_orig_po_header_id_tbl.COUNT <> 1) THEN
1575: IF (l_orig_po_header_id_tbl.COUNT = 0) THEN
1576: IF (PO_PDOI_PARAMS.g_request.document_type =
1577: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1578: l_message_name := 'PO_PDOI_INVALID_ORIG_STD_PO';
1579: ELSE
1580: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1581: END IF;

Line 1584: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1580: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1581: END IF;
1582: ELSE
1583: IF (PO_PDOI_PARAMS.g_request.document_type =
1584: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1585: l_message_name := 'PO_PDOI_MULTIPLE_STD_PO';
1586: ELSE
1587: l_message_name := 'PO_PDOI_INVALID_MULT_ORIG_CATG';
1588: END IF;

Line 1608: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD)) THEN

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:
1610: d_position := 140;
1611:
1612: PO_PDOI_UTL.get_processing_doctype_info

Line 1638: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN

1634: IF (l_orig_consumption_flag_tbl(1) = 'Y' OR
1635: l_status_rec.updatable_flag(1) = 'N') THEN
1636:
1637: IF (PO_PDOI_PARAMS.g_request.document_type =
1638: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD) THEN
1639: l_message_name := 'PO_PDOI_STD_PO_INVALID_STATUS';
1640: ELSE
1641: l_message_name := 'PO_PDOI_INVALID_ORIG_CATALOG';
1642: END IF;