DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 5823: * PO_REQUISITIONS_INTERFACE_ALL

5819:
5820: /*****************************************************************************
5821: * This procedure is equivalent to witpspr_po_req in wiltps4.ppc
5822: * This procedure is used to insert purchase order requisition into
5823: * PO_REQUISITIONS_INTERFACE_ALL
5824: * NOTES:
5825: * IF the purchase item lead time falls outside of BOM_CALENDAR_DATES
5826: * THEN no PO req will be created
5827: ****************************************************************************/

Line 5946: | Insert into PO_REQUISITIONS_INTERFACE_ALL table for per item for jobs

5942: x_returnStatus => l_returnStatus);
5943: END IF;
5944:
5945: /*------------------------------------------------------------+
5946: | Insert into PO_REQUISITIONS_INTERFACE_ALL table for per item for jobs
5947: +------------------------------------------------------------*/
5948: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
5949: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5950:

Line 5951: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of

5947: +------------------------------------------------------------*/
5948: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
5949: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5950:
5951: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
5952: -- po_requisitions_interface as part of MOAC change.
5953: INSERT INTO po_requisitions_interface_all
5954: (last_update_date,
5955: last_updated_by,

Line 5953: INSERT INTO po_requisitions_interface_all

5949: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5950:
5951: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
5952: -- po_requisitions_interface as part of MOAC change.
5953: INSERT INTO po_requisitions_interface_all
5954: (last_update_date,
5955: last_updated_by,
5956: creation_date,
5957: created_by,

Line 6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6158: -- IF debug message level = 2, write statement below to log file
6159: IF (l_logLevel <= wip_constants.full_logging) THEN
6160: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6161: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6162: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6163: l_msg := fnd_message.get;
6164: wip_logger.log(p_msg => l_msg,
6165: x_returnStatus => l_returnStatus);
6166: END IF;

Line 6175: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of

6171: |Insert into po_req interface table for per item for schedule
6172: +------------------------------------------------------------*/
6173: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6174: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
6175: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6176: -- po_requisitions_interface as part of MOAC change.
6177: INSERT INTO po_requisitions_interface_all
6178: (last_update_date,
6179: last_updated_by,

Line 6177: INSERT INTO po_requisitions_interface_all

6173: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6174: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
6175: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6176: -- po_requisitions_interface as part of MOAC change.
6177: INSERT INTO po_requisitions_interface_all
6178: (last_update_date,
6179: last_updated_by,
6180: creation_date,
6181: created_by,

Line 6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6358: -- IF debug message level = 2, write statement below to log file
6359: IF (l_logLevel <= wip_constants.full_logging) THEN
6360: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6361: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6362: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6363: l_msg := fnd_message.get;
6364: wip_logger.log(p_msg => l_msg,
6365: x_returnStatus => l_returnStatus);
6366: END IF;

Line 6375: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of

6371: | Insert into po_req interface table for per lot for job
6372: +------------------------------------------------------------*/
6373: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
6374: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6375: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6376: -- po_requisitions_interface as part of MOAC change.
6377: INSERT INTO po_requisitions_interface_all
6378: (last_update_date,
6379: last_updated_by,

Line 6377: INSERT INTO po_requisitions_interface_all

6373: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
6374: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6375: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6376: -- po_requisitions_interface as part of MOAC change.
6377: INSERT INTO po_requisitions_interface_all
6378: (last_update_date,
6379: last_updated_by,
6380: creation_date,
6381: created_by,

Line 6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6600: -- IF debug message level = 2, write statement below to log file
6601: IF (l_logLevel <= wip_constants.full_logging) THEN
6602: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6603: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6604: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6605: l_msg := fnd_message.get;
6606: wip_logger.log(p_msg => l_msg,
6607: x_returnStatus => l_returnStatus);
6608: END IF;

Line 6617: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of

6613: | Insert into po_req interface table for per lot for schedule
6614: +------------------------------------------------------------*/
6615: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6616: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6617: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6618: -- po_requisitions_interface as part of MOAC change.
6619: INSERT INTO po_requisitions_interface_all
6620: (last_update_date,
6621: last_updated_by,

Line 6619: INSERT INTO po_requisitions_interface_all

6615: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6616: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6617: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6618: -- po_requisitions_interface as part of MOAC change.
6619: INSERT INTO po_requisitions_interface_all
6620: (last_update_date,
6621: last_updated_by,
6622: creation_date,
6623: created_by,

Line 6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');

6828: -- IF debug message level = 2, write statement below to log file
6829: IF (l_logLevel <= wip_constants.full_logging) THEN
6830: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6831: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6832: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6833: l_msg := fnd_message.get;
6834: wip_logger.log(p_msg => l_msg,
6835: x_returnStatus => l_returnStatus);
6836: END IF;

Line 9754: -- IF PO installed and PO, insert PO info into PO_REQUISITIONS_INTERFACE_ALL

9750: l_errMsg := 'wip_movProc_priv.release_cost_txn failed';
9751: raise fnd_api.g_exc_unexpected_error;
9752: END IF; -- check return status
9753:
9754: -- IF PO installed and PO, insert PO info into PO_REQUISITIONS_INTERFACE_ALL
9755: l_po := fnd_installation.get_app_info
9756: (application_short_name => 'PO',
9757: status => l_poStatus,
9758: industry => l_poIndustry,