DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 5694: * PO_REQUISITIONS_INTERFACE_ALL

5690:
5691: /*****************************************************************************
5692: * This procedure is equivalent to witpspr_po_req in wiltps4.ppc
5693: * This procedure is used to insert purchase order requisition into
5694: * PO_REQUISITIONS_INTERFACE_ALL
5695: * NOTES:
5696: * IF the purchase item lead time falls outside of BOM_CALENDAR_DATES
5697: * THEN no PO req will be created
5698: ****************************************************************************/

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

5813: x_returnStatus => l_returnStatus);
5814: END IF;
5815:
5816: /*------------------------------------------------------------+
5817: | Insert into PO_REQUISITIONS_INTERFACE_ALL table for per item for jobs
5818: +------------------------------------------------------------*/
5819: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
5820: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5821:

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

5818: +------------------------------------------------------------*/
5819: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
5820: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5821:
5822: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
5823: -- po_requisitions_interface as part of MOAC change.
5824: INSERT INTO po_requisitions_interface_all
5825: (last_update_date,
5826: last_updated_by,

Line 5824: INSERT INTO po_requisitions_interface_all

5820: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
5821:
5822: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
5823: -- po_requisitions_interface as part of MOAC change.
5824: INSERT INTO po_requisitions_interface_all
5825: (last_update_date,
5826: last_updated_by,
5827: creation_date,
5828: created_by,

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

6022: -- IF debug message level = 2, write statement below to log file
6023: IF (l_logLevel <= wip_constants.full_logging) THEN
6024: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6025: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6026: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6027: l_msg := fnd_message.get;
6028: wip_logger.log(p_msg => l_msg,
6029: x_returnStatus => l_returnStatus);
6030: END IF;

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

6035: |Insert into po_req interface table for per item for schedule
6036: +------------------------------------------------------------*/
6037: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6038: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
6039: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6040: -- po_requisitions_interface as part of MOAC change.
6041: INSERT INTO po_requisitions_interface_all
6042: (last_update_date,
6043: last_updated_by,

Line 6041: INSERT INTO po_requisitions_interface_all

6037: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6038: l_move.poReqItem = WIP_CONSTANTS.YES) THEN
6039: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6040: -- po_requisitions_interface as part of MOAC change.
6041: INSERT INTO po_requisitions_interface_all
6042: (last_update_date,
6043: last_updated_by,
6044: creation_date,
6045: created_by,

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

6215: -- IF debug message level = 2, write statement below to log file
6216: IF (l_logLevel <= wip_constants.full_logging) THEN
6217: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6218: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6219: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6220: l_msg := fnd_message.get;
6221: wip_logger.log(p_msg => l_msg,
6222: x_returnStatus => l_returnStatus);
6223: END IF;

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

6228: | Insert into po_req interface table for per lot for job
6229: +------------------------------------------------------------*/
6230: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
6231: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6232: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6233: -- po_requisitions_interface as part of MOAC change.
6234: INSERT INTO po_requisitions_interface_all
6235: (last_update_date,
6236: last_updated_by,

Line 6234: INSERT INTO po_requisitions_interface_all

6230: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
6231: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6232: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6233: -- po_requisitions_interface as part of MOAC change.
6234: INSERT INTO po_requisitions_interface_all
6235: (last_update_date,
6236: last_updated_by,
6237: creation_date,
6238: created_by,

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

6450: -- IF debug message level = 2, write statement below to log file
6451: IF (l_logLevel <= wip_constants.full_logging) THEN
6452: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6453: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6454: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6455: l_msg := fnd_message.get;
6456: wip_logger.log(p_msg => l_msg,
6457: x_returnStatus => l_returnStatus);
6458: END IF;

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

6463: | Insert into po_req interface table for per lot for schedule
6464: +------------------------------------------------------------*/
6465: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6466: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6467: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6468: -- po_requisitions_interface as part of MOAC change.
6469: INSERT INTO po_requisitions_interface_all
6470: (last_update_date,
6471: last_updated_by,

Line 6469: INSERT INTO po_requisitions_interface_all

6465: IF(l_move.scheTxn = WIP_CONSTANTS.YES AND
6466: l_move.poReqLot = WIP_CONSTANTS.YES) THEN
6467: -- Fixed bug 5144659. Insert into po_requisitions_interface_all instead of
6468: -- po_requisitions_interface as part of MOAC change.
6469: INSERT INTO po_requisitions_interface_all
6470: (last_update_date,
6471: last_updated_by,
6472: creation_date,
6473: created_by,

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

6671: -- IF debug message level = 2, write statement below to log file
6672: IF (l_logLevel <= wip_constants.full_logging) THEN
6673: fnd_message.set_name('WIP', 'WIP_INSERTED_ROWS');
6674: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
6675: fnd_message.set_token('ENTITY2', 'PO_REQUISITIONS_INTERFACE_ALL');
6676: l_msg := fnd_message.get;
6677: wip_logger.log(p_msg => l_msg,
6678: x_returnStatus => l_returnStatus);
6679: END IF;

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

9477: l_errMsg := 'wip_movProc_priv.release_cost_txn failed';
9478: raise fnd_api.g_exc_unexpected_error;
9479: END IF; -- check return status
9480:
9481: -- IF PO installed and PO, insert PO info into PO_REQUISITIONS_INTERFACE_ALL
9482: l_po := fnd_installation.get_app_info
9483: (application_short_name => 'PO',
9484: status => l_poStatus,
9485: industry => l_poIndustry,