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

294: * Purpose : Procedure will perform an update on the table
295: *********************************************************************/
296: PROCEDURE UPDATE_ROW
297: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
298: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
299: , x_return_Status OUT NOCOPY VARCHAR2
300: ) IS
301:
302: BEGIN

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

395: access to when he/she needs to perform any kind of writes to the table.
396: *********************************************************************/
397: PROCEDURE PERFORM_WRITES
398: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
399: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
400: , x_return_Status OUT NOCOPY VARCHAR2
401: ) IS
402: l_msg_data VARCHAR2(240);
403: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 446: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

442: * Purpose : Check_Required procedure will check the existence of mandatory attributes.
443: *********************************************************************/
444: PROCEDURE CHECK_REQUIRED
445: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
446: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
447: , x_return_Status OUT NOCOPY VARCHAR2
448: )IS
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;

Line 449: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

445: ( p_safety_establishment_rec IN EAM_PROCESS_SAFETY_PUB.eam_establishment_rec_type
446: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
447: , x_return_Status OUT NOCOPY VARCHAR2
448: )IS
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;

Line 450: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

446: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
447: , x_return_Status OUT NOCOPY VARCHAR2
448: )IS
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;

Line 451: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

447: , x_return_Status OUT NOCOPY VARCHAR2
448: )IS
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

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 (

Line 457: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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 (
458: p_message_name => 'EAM_ESTAB_ID_REQUIRED' ,
459: p_token_tbl => l_Token_tbl ,
460: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
461: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 467: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

463: x_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465: IF p_safety_establishment_rec.ESTABLISHMENT_SOURCE IS NULL THEN
466: l_out_mesg_token_tbl := l_mesg_token_tbl;
467: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
468: p_message_name => 'EAM_ESTAB_SOURCE_REQUIRED' ,
469: p_token_tbl => l_Token_tbl ,
470: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
471: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 477: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475: IF p_safety_establishment_rec.SEQUENCE_TYPE IS NULL THEN
476: l_out_mesg_token_tbl := l_mesg_token_tbl;
477: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
478: p_message_name => 'EAM_ESTAB_SEQ_TYPE_REQUIRED' ,
479: p_token_tbl => l_Token_tbl ,
480: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
481: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 488: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

484: END IF;
485:
486: IF p_safety_establishment_rec.SEQUENCE_NUMBER IS NULL THEN
487: l_out_mesg_token_tbl := l_mesg_token_tbl;
488: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
489: p_message_name => 'EAM_ESTAB_SEQ_NUM_REQUIRED' ,
490: p_token_tbl => l_Token_tbl ,
491: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
492: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 500: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

496:
497: IF p_safety_establishment_rec.MAINTENANCE_OBJECT_ID IS NULL
498: THEN
499: l_out_mesg_token_tbl := l_mesg_token_tbl;
500: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
501: ( p_message_name => 'EAM_ESTAB_MAINTID_REQUIRED'
502: , p_token_tbl => l_Token_tbl
503: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
504: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 512: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

508: END IF;
509:
510: IF p_safety_establishment_rec.ORGANIZATION_ID IS NULL THEN
511: l_out_mesg_token_tbl := l_mesg_token_tbl;
512: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
513: p_message_name => 'EAM_ESTAB_ORG_REQUIRED' ,
514: p_token_tbl => l_Token_tbl ,
515: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
516: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );