DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_REQ_SPLIT_LINES_GT

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

1182:
1183: d_progress := 30;
1184:
1185: IF PO_LOG.d_stmt THEN
1186: PO_LOG.stmt(d_module_base,d_progress,'Inserting values into po_req_split_lines_gt');
1187: END IF;
1188:
1189: -- Performance fix for bug 4930487
1190: -- Prevented FTS on po_requisition_lines_all by adding an exists clause

Line 1191: INSERT INTO po_req_split_lines_gt

1187: END IF;
1188:
1189: -- Performance fix for bug 4930487
1190: -- Prevented FTS on po_requisition_lines_all by adding an exists clause
1191: INSERT INTO po_req_split_lines_gt
1192: (requisition_header_id,
1193: requisition_line_id,
1194: allocated_qty,
1195: new_req_line_id,

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

1213:
1214:
1215: IF SQL%ROWCOUNT < 1 THEN
1216: IF PO_LOG.d_stmt THEN
1217: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1218: END IF;
1219:
1220: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1221: FND_MSG_PUB.add;

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

1216: IF PO_LOG.d_stmt THEN
1217: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1218: END IF;
1219:
1220: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1221: FND_MSG_PUB.add;
1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224: