DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on WIP_OSP

Line 1793: wip_osp.updatePOReqQuantity(

1789: FROM wip_parameters
1790: WHERE organization_id = l_rs_txn.org_id;
1791:
1792: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
1793: wip_osp.updatePOReqQuantity(
1794: p_job_id => l_rs_txn.wip_id,
1795: p_repetitive_id => l_rsa(1).scheID,
1796: p_org_id => l_rs_txn.org_id,
1797: p_changed_qty => l_rs_txn.oc_pri_qty,

Line 1805: l_errMsg := 'wip_osp.updatePOReqQuantity failed';

1801: p_fm_op => l_rs_txn.fm_op,
1802: x_return_status => x_returnStatus);
1803:
1804: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
1805: l_errMsg := 'wip_osp.updatePOReqQuantity failed';
1806: raise fnd_api.g_exc_unexpected_error;
1807: END IF; -- l_return_status
1808: END IF; -- l_propagate_job_change_to_po = WIP_CONSTANTS.YES
1809: END IF; -- l_rs_txn.oc_pri_qty <> 0 and customer have PO FPJ

Line 2527: wip_osp.updatePOReqQuantity(

2523: FROM wip_parameters
2524: WHERE organization_id = l_dj_txn.org_id;
2525:
2526: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
2527: wip_osp.updatePOReqQuantity(
2528: p_job_id => l_dj_txn.wip_id,
2529: p_org_id => l_dj_txn.org_id,
2530: p_changed_qty => l_dj_txn.oc_pri_qty,
2531: /* Fix for Bug#4746495. PO linked to current Operation should

Line 2538: l_errMsg := 'wip_osp.updatePOReqQuantity failed';

2534: p_fm_op => l_dj_txn.fm_op,
2535: x_return_status => x_returnStatus);
2536:
2537: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
2538: l_errMsg := 'wip_osp.updatePOReqQuantity failed';
2539: raise fnd_api.g_exc_unexpected_error;
2540: END IF; -- x_returnStatus
2541: END IF; -- l_propagate_job_change_to_po = WIP_CONSTANTS.YES
2542: END IF; -- l_dj_txn.oc_pri_qty <> 0 and customer have PO FPJ

Line 6850: wip_osp.create_additional_req

6846: LOOP
6847: FETCH c_additional_reqs INTO l_additional_reqs;
6848: EXIT WHEN c_additional_reqs%NOTFOUND;
6849: -- call PL/SQL API to create additional_req
6850: wip_osp.create_additional_req
6851: (p_wip_entity_id => l_additional_reqs.wip_id,
6852: p_organization_id => l_additional_reqs.org_id,
6853: p_repetitive_schedule_id => l_additional_reqs.rep_sched_id,
6854: p_added_quantity => l_additional_reqs.oc_qty,

Line 7005: wip_osp_shp_i_wf.StartWFProcess

7001: where ORGANIZATION_ID = l_org_id
7002: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
7003: FND_REQUEST.SET_ORG_ID (l_ou_id);
7004:
7005: wip_osp_shp_i_wf.StartWFProcess
7006: (p_itemtype => 'WIPISHPW',
7007: p_itemkey => l_itemkey,
7008: p_workflow_process => 'INTERMEDIATE_SHIP',
7009: p_wip_entity_id => l_wmti_txn.wip_id,

Line 7036: /*Bug 13768020: Do not launch "Req Import" when there is po receipt resource and profile WIP_OSP_REQ is set to No.*/

7032: END IF;
7033:
7034: END LOOP;
7035:
7036: /*Bug 13768020: Do not launch "Req Import" when there is po receipt resource and profile WIP_OSP_REQ is set to No.*/
7037: IF( l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN
7039: l_launch_req_import := WIP_CONSTANTS.NO;
7040: END IF;

Line 7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN

7034: END LOOP;
7035:
7036: /*Bug 13768020: Do not launch "Req Import" when there is po receipt resource and profile WIP_OSP_REQ is set to No.*/
7037: IF( l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN
7039: l_launch_req_import := WIP_CONSTANTS.NO;
7040: END IF;
7041:
7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/

Line 7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/

7038: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) THEN
7039: l_launch_req_import := WIP_CONSTANTS.NO;
7040: END IF;
7041:
7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/
7043: IF(l_launch_req_import = WIP_CONSTANTS.NO AND
7044: l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND
7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN

Line 7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND

7041:
7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/
7043: IF(l_launch_req_import = WIP_CONSTANTS.NO AND
7044: l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND
7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN
7047: l_launch_req_import := WIP_CONSTANTS.YES;
7048: END IF;
7049:

Line 7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN

7042: /*Bug 13768020: Launch "Req Import" when there is po receipt resource, worflow is diabled and WIP_OSP_REQ is set to Yes*/
7043: IF(l_launch_req_import = WIP_CONSTANTS.NO AND
7044: l_po_receipt_exsit = WIP_CONSTANTS.YES AND
7045: fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.YES AND
7046: fnd_profile.value('WIP_OSP_WF') = WIP_CONSTANTS.NO) THEN
7047: l_launch_req_import := WIP_CONSTANTS.YES;
7048: END IF;
7049:
7050: -- If OSP item exists, and there is no workflow launch yet, we have to launch

Line 7074: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

7070: WHEN NO_DATA_FOUND THEN
7071: raise fnd_api.g_exc_unexpected_error;
7072: END;
7073: /*ER 4276433*/
7074: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
7075: l_init_reqappr := 'N';
7076: else
7077: l_init_reqappr := 'Y';
7078: end if;

Line 8552: wip_osp.cancelPOReq(

8548: AND organization_id = l_update_po.org_id
8549: AND autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT, WIP_CONSTANTS.PO_MOVE);
8550:
8551: IF(l_update_po_qty = 0 AND l_update_po.fm_op < l_osp_op_seq_num) then
8552: wip_osp.cancelPOReq(
8553: p_job_id => l_update_po.job_id,
8554: p_org_id => l_update_po.org_id,
8555: x_return_status => x_returnStatus);
8556: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 8557: l_errMsg := 'wip_osp.cancelPOReq failed';

8553: p_job_id => l_update_po.job_id,
8554: p_org_id => l_update_po.org_id,
8555: x_return_status => x_returnStatus);
8556: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
8557: l_errMsg := 'wip_osp.cancelPOReq failed';
8558: raise fnd_api.g_exc_unexpected_error;
8559: END IF;
8560: ELSE
8561: /* end of fix 6607192 */

Line 8563: wip_osp.updatePOReqQuantity(

8559: END IF;
8560: ELSE
8561: /* end of fix 6607192 */
8562:
8563: wip_osp.updatePOReqQuantity(
8564: p_job_id => l_update_po.job_id,
8565: p_repetitive_id => l_update_po.rep_id,
8566: p_org_id => l_update_po.org_id,
8567: p_changed_qty => l_update_po.changed_qty,

Line 8574: l_errMsg := 'wip_osp.updatePOReqQuantity failed';

8570: p_is_scrap_txn => WIP_CONSTANTS.YES,
8571: x_return_status => x_returnStatus);
8572:
8573: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
8574: l_errMsg := 'wip_osp.updatePOReqQuantity failed';
8575: raise fnd_api.g_exc_unexpected_error;
8576: END IF;
8577: END IF;
8578: