DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_REQ_SPLIT_LINES_GT

Line 1659: PO_LOG.stmt(d_module_base,d_progress,'Inserting values into po_req_split_lines_gt');

1655:
1656: d_progress := 30;
1657:
1658: IF PO_LOG.d_stmt THEN
1659: PO_LOG.stmt(d_module_base,d_progress,'Inserting values into po_req_split_lines_gt');
1660: END IF;
1661:
1662: -- Performance fix for bug 4930487
1663: -- Prevented FTS on po_requisition_lines_all by adding an exists clause

Line 1664: INSERT INTO po_req_split_lines_gt

1660: END IF;
1661:
1662: -- Performance fix for bug 4930487
1663: -- Prevented FTS on po_requisition_lines_all by adding an exists clause
1664: INSERT INTO po_req_split_lines_gt
1665: (requisition_header_id,
1666: requisition_line_id,
1667: allocated_qty,
1668: new_req_line_id,

Line 1690: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');

1686:
1687:
1688: IF SQL%ROWCOUNT < 1 THEN
1689: IF PO_LOG.d_stmt THEN
1690: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1691: END IF;
1692:
1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1694: FND_MSG_PUB.add;

Line 1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);

1689: IF PO_LOG.d_stmt THEN
1690: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1691: END IF;
1692:
1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1694: FND_MSG_PUB.add;
1695: RAISE FND_API.g_exc_unexpected_error;
1696: END IF;
1697: