DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_CONSTANTS

Line 54: ,p_to_status_type IN NUMBER := wip_constants.unreleased

50: ,p_commit IN VARCHAR2 := fnd_api.g_false
51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52: ,p_wip_entity_id IN NUMBER
53: ,p_organization_id IN NUMBER
54: ,p_to_status_type IN NUMBER := wip_constants.unreleased
55: ,p_user_id IN NUMBER := null
56: ,p_responsibility_id IN NUMBER := null
57: ,p_date_released IN DATE := sysdate
58: , p_report_type IN NUMBER := null

Line 189: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,

185:
186: -- Validate status_id
187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Validating Status'); END IF;
188:
189: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
190: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
191: THEN
192:
193: raise fnd_api.g_exc_unexpected_error;

Line 190: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)

186: -- Validate status_id
187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Validating Status'); END IF;
188:
189: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
190: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
191: THEN
192:
193: raise fnd_api.g_exc_unexpected_error;
194:

Line 301: p_to_status_type = wip_constants.unreleased

297: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Changing to Unreleased Status'); END IF;
298:
299:
300: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
301: p_to_status_type = wip_constants.unreleased
302: THEN
303: EAM_ASSET_LOG_PVT.INSERT_ROW
304: (
305: p_api_version => 1.0,

Line 501: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN

497: -- Create Requisitions for OSP
498: IF ((l_to_status_type in (3)) AND (l_current_status in (1,6,17))) THEN
499:
500: --IF po_creation_time for workorder is at_job_schedule_release then only create requisitions
501: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN
502: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Creating osp req at release and po_creation_time correct'); END IF;
503: create_osp_req_at_rel(
504: p_wip_entity_id => l_wip_entity_id,
505: p_organization_id => l_organization_id); -- for Bug 8594830

Line 600: ( p_to_status_type = wip_constants.released)

596: null;
597: END;
598:
599: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
600: ( p_to_status_type = wip_constants.released)
601: THEN
602: EAM_ASSET_LOG_PVT.INSERT_ROW
603: (
604: p_api_version => 1.0,

Line 1082: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT

1078: AND WO.ORGANIZATION_ID = p_organization_id
1079: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1080: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
1081: AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
1082: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT
1083: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;
1084: l_call_req_import VARCHAR2(10);
1085: l_request_id number;
1086: l_ou_id number;

Line 1083: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;

1079: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1080: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
1081: AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
1082: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT
1083: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;
1084: l_call_req_import VARCHAR2(10);
1085: l_request_id number;
1086: l_ou_id number;
1087: l_wip_error_flag Number := 0; /*Added for FP 6814440*/