eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_PERMIT_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 122: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

118: FROM EAM_WORK_PERMITS ewp
119: WHERE ewp.permit_id = p_work_permit_id
120: AND ewp.organization_id = p_organization_id;
121:
122: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
123: x_work_permit_header_rec := l_work_permit_header_rec;
124:
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN

Line 127: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

123: x_work_permit_header_rec := l_work_permit_header_rec;
124:
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
128: x_work_permit_header_rec := l_work_permit_header_rec;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 148: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;

144: IS
145:
146: BEGIN
147:
148: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;
149:
150:
151: INSERT INTO EAM_WORK_PERMITS(
152: PERMIT_ID

Line 272: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;

268: ) IS
269:
270: BEGIN
271:
272: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Permit rec for ' || p_work_permit_header_rec.PERMIT_NAME); END IF;
273:
274:
275: UPDATE EAM_WORK_PERMITS
276: SET

Line 344: IF p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

340: l_msg_data VARCHAR2(240);
341: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
342: BEGIN
343:
344: IF p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
345: THEN
346: Insert_Row
347: ( p_work_permit_header_rec => p_work_permit_header_rec
348: , x_return_Status => l_return_status

Line 351: ELSIF p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

347: ( p_work_permit_header_rec => p_work_permit_header_rec
348: , x_return_Status => l_return_status
349: );
350:
351: ELSIF p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
352: THEN
353: Update_Row
354: ( p_work_permit_header_rec => p_work_permit_header_rec
355: , x_mesg_token_Tbl => x_mesg_token_Tbl

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

397: BEGIN
398:
399: SAVEPOINT CHANGE_WORK_PERMIT_STATUS;
400:
401: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside CHANGE_WORK_PERMIT_STATUS '); END IF;
402:
403: l_permit_id := p_permit_id;
404: l_organization_id := p_organization_id;
405: l_to_status_type := p_to_status_type;

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

405: l_to_status_type := p_to_status_type;
406: l_user_id := p_user_id;
407: l_responsibility_id := p_responsibility_id;
408:
409: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
410: -- Validate status_id
411:
412: IF l_to_status_type NOT IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
413: WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.DRAFT)

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

417:
418: END IF;
419:
420: -- Update status in permits table
421: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in permits table'); END IF;
422:
423: BEGIN
424:
425: UPDATE EAM_WORK_PERMITS

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

460: , x_return_Status OUT NOCOPY VARCHAR2
461: )IS
462: BEGIN
463:
464: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside INSERT_PERMIT_HISTORY_ROW '); END IF;
465:
466: END INSERT_PERMIT_HISTORY_ROW;
467:
468: