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_CLEARANCE_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 163: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

159: * Purpose : Procedure will perfrom an insert into the table
160: *********************************************************************/
161: PROCEDURE INSERT_ROW
162: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
163: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
164: , x_return_Status OUT NOCOPY VARCHAR2
165: )IS
166:
167: BEGIN

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

288: * Purpose : Procedure will perform an update on the table
289: *********************************************************************/
290: PROCEDURE UPDATE_ROW
291: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB. eam_clearance_header_rec_type
292: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
293: , x_return_Status OUT NOCOPY VARCHAR2
294: )IS
295:
296: BEGIN

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

365: writes to the table.
366: *********************************************************************/
367: PROCEDURE PERFORM_WRITES
368: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
369: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
370: , x_return_Status OUT NOCOPY VARCHAR2
371: )IS
372: l_msg_data VARCHAR2(240);
373: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 416: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

412: , p_user_id IN NUMBER
413: , p_responsibility_id IN NUMBER
414: , p_transaction_type IN NUMBER
415: , x_return_status OUT NOCOPY VARCHAR2
416: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
417: )IS
418:
419: l_clearance_id NUMBER := 0;
420: l_current_status NUMBER := 0;

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

Line 489: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

485: , p_permit_status IN VARCHAR2
486: , p_event_desc IN VARCHAR2
487: , p_user_id IN NUMBER,
488: , p_event_date IN DATE
489: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
490: , x_return_Status OUT NOCOPY VARCHAR2
491: );*/
492: --Insert Work Clearance History record in to EAM_SAFETY_HISTORY table.
493: