APPS.EAM_CLEARANCE_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

137: FROM EAM_WORK_CLEARANCES ewc
138: WHERE ewc.WORK_CLEARANCE_ID = p_work_clearance_id
139: AND ewc.organization_id = p_organization_id;
140:
141: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
142: x_work_clearance_header_rec:= l_work_clearance_header_rec;
143:
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN

Line 146: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

142: x_work_clearance_header_rec:= l_work_clearance_header_rec;
143:
144: EXCEPTION
145: WHEN NO_DATA_FOUND THEN
146: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
147: x_work_clearance_header_rec:= l_work_clearance_header_rec;
148:
149: WHEN OTHERS THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 169: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing clearance rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;

165: )IS
166:
167: BEGIN
168:
169: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing clearance rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;
170:
171:
172: INSERT INTO EAM_WORK_CLEARANCES(
173: WORK_CLEARANCE_ID

Line 298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;

294: )IS
295:
296: BEGIN
297:
298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_clearance_header_rec.WORK_CLEARANCE_NAME); END IF;
299:
300: --Note : double check which of these columns are updeatable.
301:
302: UPDATE EAM_WORK_CLEARANCES

Line 376: IF p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

372: l_msg_data VARCHAR2(240);
373: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
374: BEGIN
375:
376: IF p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
377: THEN
378: Insert_Row
379: ( p_work_clearance_header_rec => p_work_clearance_header_rec
380: , x_mesg_token_Tbl => x_mesg_token_Tbl

Line 384: ELSIF p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

380: , x_mesg_token_Tbl => x_mesg_token_Tbl
381: , x_return_Status => l_return_status
382: );
383:
384: ELSIF p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
385: THEN
386: Update_Row
387: ( p_work_clearance_header_rec => p_work_clearance_header_rec
388: , x_mesg_token_Tbl => x_mesg_token_Tbl

Line 431: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside CHANGE_CLEARANCE_STATUS '); END IF;

427: BEGIN
428:
429: SAVEPOINT CHANGE_CLEARANCE_STATUS;
430:
431: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside CHANGE_CLEARANCE_STATUS '); END IF;
432:
433: l_clearance_id := p_clearance_id;
434: l_organization_id := p_organization_id;
435: l_to_status_type := p_to_status_type;

Line 439: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;

435: l_to_status_type := p_to_status_type;
436: l_user_id := p_user_id;
437: l_responsibility_id := p_responsibility_id;
438:
439: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
440: -- Validate status_id
441:
442: IF l_to_status_type NOT IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG,
443: WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.DRAFT)

Line 450: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in clearance table'); END IF;

446: raise fnd_api.g_exc_unexpected_error;
447:
448: END IF;
449: -- Update status in clearance table
450: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in clearance table'); END IF;
451: BEGIN
452:
453: UPDATE EAM_WORK_CLEARANCES
454: SET STATUS_TYPE = l_to_status_type