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_ESTABLISHMENT_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Querying establishment details ' ); END IF;

32: )IS
33: l_safety_establishment_rec EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type;
34:
35: BEGIN
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Querying establishment details ' ); END IF;
37:
38: SELECT
39: iso.establishment_id
40: ,iso.establishment_source

Line 144: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

140: FROM EAM_ESTABLISHMENT_DETAILS iso
141: WHERE iso.establishment_id = p_establishment_id
142: AND iso.organization_id = p_organization_id;
143:
144: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
145: x_safety_establishment_rec := l_safety_establishment_rec;
146:
147: EXCEPTION
148: WHEN NO_DATA_FOUND THEN

Line 149: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

145: x_safety_establishment_rec := l_safety_establishment_rec;
146:
147: EXCEPTION
148: WHEN NO_DATA_FOUND THEN
149: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
150: x_safety_establishment_rec := l_safety_establishment_rec;
151:
152: WHEN OTHERS THEN
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 171: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Isolation Establishment record for ' || p_safety_establishment_rec.establishment_id); END IF;

167: ) IS
168:
169: BEGIN
170:
171: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Isolation Establishment record for ' || p_safety_establishment_rec.establishment_id); END IF;
172:
173: INSERT INTO EAM_ESTABLISHMENT_DETAILS(
174: establishment_id
175: ,establishment_source

Line 304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Isolation establishment rec for ' || p_safety_establishment_rec.establishment_id); END IF;

300: ) IS
301:
302: BEGIN
303:
304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Isolation establishment rec for ' || p_safety_establishment_rec.establishment_id); END IF;
305:
306:
307: UPDATE EAM_ESTABLISHMENT_DETAILS
308: SET

Line 378: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deletiing establishment details ' ); END IF;

374: , p_organization_id IN NUMBER
375: , x_return_Status OUT NOCOPY VARCHAR2
376: ) IS
377: BEGIN
378: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deletiing establishment details ' ); END IF;
379:
380: DELETE FROM EAM_ESTABLISHMENT_DETAILS
381: WHERE establishment_id =p_safety_establishment_rec.establishment_id
382: AND organization_id = p_organization_id;

Line 407: IF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

403: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
404:
405: BEGIN
406:
407: IF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
408: THEN
409: Insert_Row
410: ( p_safety_establishment_rec => p_safety_establishment_rec
411: , x_return_Status => l_return_status

Line 414: ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

410: ( p_safety_establishment_rec => p_safety_establishment_rec
411: , x_return_Status => l_return_status
412: );
413:
414: ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
415: THEN
416: Update_Row
417: ( p_safety_establishment_rec => p_safety_establishment_rec
418: , x_mesg_token_Tbl => x_mesg_token_Tbl

Line 421: ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

417: ( p_safety_establishment_rec => p_safety_establishment_rec
418: , x_mesg_token_Tbl => x_mesg_token_Tbl
419: , x_return_Status => l_return_status
420: );
421: ELSIF p_safety_establishment_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
422: THEN
423: DELETE_ROW
424: ( p_safety_establishment_rec => p_safety_establishment_rec
425: , p_organization_id => p_safety_establishment_rec.ORGANIZATION_ID

Line 453: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Isolation . . . '); END IF;

449: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
450: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
451: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
452: BEGIN
453: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Isolation . . . '); END IF;
454: x_return_status:= FND_API.G_RET_STS_SUCCESS;
455: IF p_safety_establishment_rec.ESTABLISHMENT_ID IS NULL THEN
456: l_out_mesg_token_tbl := l_mesg_token_tbl;
457: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (