DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on WIP_OSP

Line 1: PACKAGE BODY WIP_OSP AS

1: PACKAGE BODY WIP_OSP AS
2: /* $Header: wipospvb.pls 120.26.12020000.8 2013/02/01 11:47:42 akuppa ship $ */
3:
4: Additional_Quantity NUMBER := 0;
5:

Line 101: if(fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) then

97: BEGIN
98:
99: /* Bug 13768020: if the 'WIP:Launch Requisition Import for PO Receipt' is set to 'N'
100: do not launch Requistion Import for PO Receipt resource*/
101: if(fnd_profile.value('WIP_OSP_REQ') = WIP_CONSTANTS.NO) then
102: l_req_enabled := FALSE;
103: else
104: l_req_enabled := TRUE;
105: end if;

Line 174: wip_osp_shp_i_wf.StartWFProcess(

170: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
171:
172: FND_REQUEST.SET_ORG_ID (l_ou_id);
173:
174: wip_osp_shp_i_wf.StartWFProcess(
175: p_itemtype => 'WIPISHPW',
176: p_itemkey => l_itemkey,
177: p_workflow_process => 'INTERMEDIATE_SHIP',
178: p_wip_entity_id => P_Wip_Entity_Id,

Line 294: wip_osp_shp_i_wf.StartWFProcess(

290: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
291:
292: FND_REQUEST.SET_ORG_ID (l_ou_id);
293:
294: wip_osp_shp_i_wf.StartWFProcess(
295: p_itemtype => 'WIPISHPW',
296: p_itemkey => l_itemkey,
297: p_workflow_process => 'INTERMEDIATE_SHIP',
298: p_wip_entity_id => P_Wip_Entity_Id,

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

365: raise fnd_api.g_exc_unexpected_error;
366: END;
367:
368: /*ER 4276433*/
369: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
370: l_init_reqappr := 'N';
371: else
372: l_init_reqappr := 'Y';
373: end if;

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

910: raise fnd_api.g_exc_unexpected_error;
911: END;
912:
913: /*ER 4276433*/
914: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
915: l_init_reqappr := 'N';
916: else
917: l_init_reqappr := 'Y';
918: end if;

Line 1204: l_qty := WIP_OSP.ConvertToPrimaryMoveQty(

1200: and wor.operation_seq_num = P_WipOperationSeqNum
1201: and wor.organization_id = P_OrganizationId
1202: and wor.resource_seq_num = P_ResourceSeqNum;
1203:
1204: l_qty := WIP_OSP.ConvertToPrimaryMoveQty(
1205: p_item_id => P_ItemId,
1206: p_organization_id => P_OrganizationId,
1207: p_quantity => P_AssemblyItemId,
1208: p_uom_code => P_Uom,

Line 1620: wip_osp.updatePOReqNBD (

1616: OR
1617: l_new_NBD.new_need_by_date >
1618: l_po_req.old_need_by_date + l_late_nbd)) THEN
1619:
1620: wip_osp.updatePOReqNBD (
1621: p_po_header_id => l_po_req.po_header_id,
1622: p_po_release_id => l_po_req.po_release_id,
1623: p_po_line_location_id => l_po_req.po_line_location_id,
1624: p_req_header_id => l_po_req.req_header_id,

Line 1691: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',

1687: l_params(8).paramName := 'p_new_NBD';
1688: l_params(8).paramValue := p_new_NBD;
1689: l_params(9).paramName := 'p_ou_id';
1690: l_params(9).paramValue := p_ou_id;
1691: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',
1692: p_params => l_params,
1693: x_returnStatus => l_returnStatus);
1694: END IF;
1695:

Line 1780: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1776: END IF;
1777: END IF; -- PO or Requisition
1778: -- write to the log file
1779: IF (l_logLevel <= wip_constants.trace_logging) THEN
1780: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1781: p_procReturnStatus => x_return_status,
1782: p_msg => 'procedure complete',
1783: x_returnStatus => l_returnStatus);
1784: END IF;

Line 1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1786: WHEN fnd_api.g_exc_unexpected_error THEN
1787: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789: IF (l_logLevel <= wip_constants.trace_logging) THEN
1790: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1791: p_procReturnStatus => x_return_status,
1792: p_msg => l_errMsg,
1793: x_returnStatus => l_returnStatus);
1794: END IF;

Line 1801: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',

1797: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1798: x_return_status := fnd_api.g_ret_sts_unexp_error;
1799: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1800: IF (l_logLevel <= wip_constants.trace_logging) THEN
1801: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1802: p_procReturnStatus => x_return_status,
1803: p_msg => l_errMsg,
1804: x_returnStatus => l_returnStatus);
1805: END IF;

Line 2177: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2173: l_params(4).paramName := 'p_changed_qty';
2174: l_params(4).paramValue := p_changed_qty;
2175: l_params(5).paramName := 'p_fm_op';
2176: l_params(5).paramValue := p_fm_op;
2177: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2178: p_params => l_params,
2179: x_returnStatus => l_returnStatus);
2180: END IF;
2181:

Line 2378: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2374: END IF;
2375:
2376: -- write to the log file
2377: IF (l_logLevel <= wip_constants.trace_logging) THEN
2378: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2379: p_procReturnStatus => x_return_status,
2380: p_msg => 'procedure complete',
2381: x_returnStatus => l_returnStatus);
2382: END IF;

Line 2391: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2387: CLOSE c_multiple_po;
2388: END IF;
2389: x_return_status := fnd_api.g_ret_sts_unexp_error;
2390: IF (l_logLevel <= wip_constants.trace_logging) THEN
2391: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2392: p_procReturnStatus => x_return_status,
2393: p_msg => l_errMsg,
2394: x_returnStatus => l_returnStatus);
2395: END IF;

Line 2405: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',

2401: END IF;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2404: IF (l_logLevel <= wip_constants.trace_logging) THEN
2405: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2406: p_procReturnStatus => x_return_status,
2407: p_msg => l_errMsg,
2408: x_returnStatus => l_returnStatus);
2409: END IF;

Line 2537: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',

2533: l_params(3).paramName := 'p_org_id';
2534: l_params(3).paramValue := p_org_id;
2535: l_params(4).paramName := 'p_op_seq_num';
2536: l_params(4).paramValue := p_op_seq_num;
2537: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',
2538: p_params => l_params,
2539: x_returnStatus => l_returnStatus);
2540: END IF;
2541:

Line 2649: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',

2645: END IF;
2646: END IF;
2647: -- write to the log file
2648: IF (l_logLevel <= wip_constants.trace_logging) THEN
2649: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2650: p_procReturnStatus => x_return_status,
2651: p_msg => 'procedure complete',
2652: x_returnStatus => l_returnStatus);
2653: END IF;

Line 2659: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',

2655: WHEN others THEN
2656: x_return_status := fnd_api.g_ret_sts_unexp_error;
2657: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2658: IF (l_logLevel <= wip_constants.trace_logging) THEN
2659: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2660: p_procReturnStatus => x_return_status,
2661: p_msg => l_errMsg,
2662: x_returnStatus => l_returnStatus);
2663: END IF;

Line 2816: END WIP_OSP;

2812: and operation_seq_num = p_op_seq_num)))
2813: and rownum = 1;
2814: return l_count;
2815: END IS_BACK_TO_BACK_OSP;
2816: END WIP_OSP;
2817: