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_ERROR_MESSAGE_PVT

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 266: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

262: *********************************************************************/
263:
264: PROCEDURE UPDATE_ROW
265: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
266: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
267: , x_return_Status OUT NOCOPY VARCHAR2
268: ) IS
269:
270: BEGIN

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 337: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

333: *********************************************************************/
334:
335: PROCEDURE PERFORM_WRITES
336: ( p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type
337: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
338: , x_return_Status OUT NOCOPY VARCHAR2
339: )IS
340: l_msg_data VARCHAR2(240);
341: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 382: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

378: , p_user_id IN NUMBER
379: , p_responsibility_id IN NUMBER
380: , p_transaction_type IN NUMBER
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
383: )IS
384:
385: l_permit_id NUMBER := 0;
386: l_current_status NUMBER := 0;

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 459: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

455: , p_event IN VARCHAR2
456: , p_status IN VARCHAR2
457: , p_details IN VARCHAR2
458: , p_user_id IN NUMBER
459: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
460: , x_return_Status OUT NOCOPY VARCHAR2
461: )IS
462: BEGIN
463:

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: