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.16.12010000.3 2008/10/07 22:05:55 hliew ship $ */
3:
4: Additional_Quantity NUMBER := 0;
5:

Line 162: wip_osp_shp_i_wf.StartWFProcess(

158: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
159:
160: FND_REQUEST.SET_ORG_ID (l_ou_id);
161:
162: wip_osp_shp_i_wf.StartWFProcess(
163: p_itemtype => 'WIPISHPW',
164: p_itemkey => l_itemkey,
165: p_workflow_process => 'INTERMEDIATE_SHIP',
166: p_wip_entity_id => P_Wip_Entity_Id,

Line 281: wip_osp_shp_i_wf.StartWFProcess(

277: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
278:
279: FND_REQUEST.SET_ORG_ID (l_ou_id);
280:
281: wip_osp_shp_i_wf.StartWFProcess(
282: p_itemtype => 'WIPISHPW',
283: p_itemkey => l_itemkey,
284: p_workflow_process => 'INTERMEDIATE_SHIP',
285: p_wip_entity_id => P_Wip_Entity_Id,

Line 1118: l_qty := WIP_OSP.ConvertToPrimaryMoveQty(

1114: and wor.operation_seq_num = P_WipOperationSeqNum
1115: and wor.organization_id = P_OrganizationId
1116: and wor.resource_seq_num = P_ResourceSeqNum;
1117:
1118: l_qty := WIP_OSP.ConvertToPrimaryMoveQty(
1119: p_item_id => P_ItemId,
1120: p_organization_id => P_OrganizationId,
1121: p_quantity => P_AssemblyItemId,
1122: p_uom_code => P_Uom,

Line 1527: wip_osp.updatePOReqNBD (

1523: OR
1524: l_new_NBD.new_need_by_date >
1525: l_po_req.old_need_by_date + l_late_nbd)) THEN
1526:
1527: wip_osp.updatePOReqNBD (
1528: p_po_header_id => l_po_req.po_header_id,
1529: p_po_release_id => l_po_req.po_release_id,
1530: p_po_line_location_id => l_po_req.po_line_location_id,
1531: p_req_header_id => l_po_req.req_header_id,

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

1594: l_params(8).paramName := 'p_new_NBD';
1595: l_params(8).paramValue := p_new_NBD;
1596: l_params(9).paramName := 'p_ou_id';
1597: l_params(9).paramValue := p_ou_id;
1598: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqNBD',
1599: p_params => l_params,
1600: x_returnStatus => l_returnStatus);
1601: END IF;
1602:

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

1683: END IF;
1684: END IF; -- PO or Requisition
1685: -- write to the log file
1686: IF (l_logLevel <= wip_constants.trace_logging) THEN
1687: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1688: p_procReturnStatus => x_return_status,
1689: p_msg => 'procedure complete',
1690: x_returnStatus => l_returnStatus);
1691: END IF;

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

1693: WHEN fnd_api.g_exc_unexpected_error THEN
1694: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1695: x_return_status := fnd_api.g_ret_sts_unexp_error;
1696: IF (l_logLevel <= wip_constants.trace_logging) THEN
1697: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1698: p_procReturnStatus => x_return_status,
1699: p_msg => l_errMsg,
1700: x_returnStatus => l_returnStatus);
1701: END IF;

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

1704: ROLLBACK TO SAVEPOINT s_update_po_nbd;
1705: x_return_status := fnd_api.g_ret_sts_unexp_error;
1706: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
1707: IF (l_logLevel <= wip_constants.trace_logging) THEN
1708: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqNBD',
1709: p_procReturnStatus => x_return_status,
1710: p_msg => l_errMsg,
1711: x_returnStatus => l_returnStatus);
1712: END IF;

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

2047: l_params(4).paramName := 'p_changed_qty';
2048: l_params(4).paramValue := p_changed_qty;
2049: l_params(5).paramName := 'p_fm_op';
2050: l_params(5).paramValue := p_fm_op;
2051: wip_logger.entryPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2052: p_params => l_params,
2053: x_returnStatus => l_returnStatus);
2054: END IF;
2055:

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

2214: END IF;
2215:
2216: -- write to the log file
2217: IF (l_logLevel <= wip_constants.trace_logging) THEN
2218: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2219: p_procReturnStatus => x_return_status,
2220: p_msg => 'procedure complete',
2221: x_returnStatus => l_returnStatus);
2222: END IF;

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

2227: CLOSE c_multiple_po;
2228: END IF;
2229: x_return_status := fnd_api.g_ret_sts_unexp_error;
2230: IF (l_logLevel <= wip_constants.trace_logging) THEN
2231: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2232: p_procReturnStatus => x_return_status,
2233: p_msg => l_errMsg,
2234: x_returnStatus => l_returnStatus);
2235: END IF;

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

2241: END IF;
2242: x_return_status := fnd_api.g_ret_sts_unexp_error;
2243: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2244: IF (l_logLevel <= wip_constants.trace_logging) THEN
2245: wip_logger.exitPoint(p_procName => 'wip_osp.updatePOReqQuantity',
2246: p_procReturnStatus => x_return_status,
2247: p_msg => l_errMsg,
2248: x_returnStatus => l_returnStatus);
2249: END IF;

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

2372: l_params(3).paramName := 'p_org_id';
2373: l_params(3).paramValue := p_org_id;
2374: l_params(4).paramName := 'p_op_seq_num';
2375: l_params(4).paramValue := p_op_seq_num;
2376: wip_logger.entryPoint(p_procName => 'wip_osp.cancelPOReq',
2377: p_params => l_params,
2378: x_returnStatus => l_returnStatus);
2379: END IF;
2380:

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

2483: END IF;
2484: END IF;
2485: -- write to the log file
2486: IF (l_logLevel <= wip_constants.trace_logging) THEN
2487: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2488: p_procReturnStatus => x_return_status,
2489: p_msg => 'procedure complete',
2490: x_returnStatus => l_returnStatus);
2491: END IF;

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

2493: WHEN others THEN
2494: x_return_status := fnd_api.g_ret_sts_unexp_error;
2495: l_errMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
2496: IF (l_logLevel <= wip_constants.trace_logging) THEN
2497: wip_logger.exitPoint(p_procName => 'wip_osp.cancelPOReq',
2498: p_procReturnStatus => x_return_status,
2499: p_msg => l_errMsg,
2500: x_returnStatus => l_returnStatus);
2501: END IF;

Line 2613: END WIP_OSP;

2609: END IF; -- End check POs and REQs
2610: END PO_REQ_CREATED;
2611: /* End of fix for Bug 4446607. */
2612:
2613: END WIP_OSP;
2614: