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

Line 53: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.PERMIT_CLEARANCE_ASSOCIATION'); end if;

49:
50: BEGIN
51:
52: SAVEPOINT PERMIT_CLEARANCE_ASSOCIATION;
53: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.PERMIT_CLEARANCE_ASSOCIATION'); end if;
54:
55: IF p_permit_clearance_asso_tbl.COUNT > 0 THEN
56: FOR i in p_permit_clearance_asso_tbl.FIRST..p_permit_clearance_asso_tbl.LAST LOOP
57:

Line 60: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;

56: FOR i in p_permit_clearance_asso_tbl.FIRST..p_permit_clearance_asso_tbl.LAST LOOP
57:
58: l_safety_assoc_rec := p_permit_clearance_asso_tbl(i);
59:
60: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;
61:
62: SELECT COUNT(*)
63: INTO l_count
64: FROM EAM_WORK_CLEARANCES

Line 74: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;

70: RAISE G_SAFETY_EXISTENCE_ERROR;
71: END IF;
72:
73:
74: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;
75:
76: SELECT COUNT(*)
77: INTO l_count
78: FROM EAM_WORK_PERMITS

Line 98: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;

94: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
95: RAISE G_SAFETY_TRANSACTION_ERROR;
96: END IF;
97:
98: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
99: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
100: SELECT COUNT(*)
101: INTO l_count
102: FROM EAM_SAFETY_ASSOCIATIONS

Line 99: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

95: RAISE G_SAFETY_TRANSACTION_ERROR;
96: END IF;
97:
98: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
99: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
100: SELECT COUNT(*)
101: INTO l_count
102: FROM EAM_SAFETY_ASSOCIATIONS
103: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID

Line 113: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes within PERMIT_CLEARANCE_ASSOCIATION'); end if;

109: RAISE G_SAFETY_DUPLICATE_ASSO_ERROR;
110: END IF;
111: END IF;
112:
113: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes within PERMIT_CLEARANCE_ASSOCIATION'); end if;
114:
115: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
116: OPEN C2;
117: FETCH C2 INTO l_safety_assoc_id;

Line 115: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

111: END IF;
112:
113: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes within PERMIT_CLEARANCE_ASSOCIATION'); end if;
114:
115: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
116: OPEN C2;
117: FETCH C2 INTO l_safety_assoc_id;
118: CLOSE C2;
119: l_safety_assoc_rec.SAFETY_ASSOCIATION_ID :=l_safety_assoc_id;

Line 244: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.CLEARANCE_WO_ASSOCIATION'); end if;

240: BEGIN
241:
242: SAVEPOINT CLEARANCE_WO_ASSOCIATION;
243:
244: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.CLEARANCE_WO_ASSOCIATION'); end if;
245:
246: IF p_clearance_workorder_asso_tbl.COUNT > 0 THEN
247: FOR i in p_clearance_workorder_asso_tbl.FIRST..p_clearance_workorder_asso_tbl.LAST LOOP
248:

Line 251: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;

247: FOR i in p_clearance_workorder_asso_tbl.FIRST..p_clearance_workorder_asso_tbl.LAST LOOP
248:
249: l_safety_assoc_rec := p_clearance_workorder_asso_tbl(i);
250:
251: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking clearance existence'); end if;
252:
253: SELECT COUNT(*)
254: INTO l_count
255: FROM EAM_WORK_CLEARANCES

Line 265: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;

261: RAISE G_SAFETY_EXISTENCE_ERROR;
262: END IF;
263: -- END IF;
264:
265: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;
266:
267: SELECT COUNT(*)
268: INTO l_count
269: FROM WIP_ENTITIES

Line 289: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;

285: RAISE G_SAFETY_TRANSACTION_ERROR;
286: END IF;
287:
288:
289: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
290: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
291: SELECT COUNT(*)
292: INTO l_count
293: FROM EAM_SAFETY_ASSOCIATIONS

Line 290: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

286: END IF;
287:
288:
289: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
290: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
291: SELECT COUNT(*)
292: INTO l_count
293: FROM EAM_SAFETY_ASSOCIATIONS
294: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID

Line 304: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within CLEARANCE_WO_ASSOCIATION'); end if;

300: RAISE G_SAFETY_DUPLICATE_ASSO_ERROR;
301: END IF;
302: END IF;
303:
304: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within CLEARANCE_WO_ASSOCIATION'); end if;
305:
306: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
307: OPEN C1;
308: FETCH C1 INTO l_safety_assoc_id;

Line 306: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

302: END IF;
303:
304: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within CLEARANCE_WO_ASSOCIATION'); end if;
305:
306: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
307: OPEN C1;
308: FETCH C1 INTO l_safety_assoc_id;
309: CLOSE C1;
310: l_safety_assoc_rec.SAFETY_ASSOCIATION_ID :=l_safety_assoc_id;

Line 459: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.PERMIT_WORK_ORDER_ASSOCIATION'); end if;

455:
456: BEGIN
457:
458: SAVEPOINT PERMIT_WORK_ORDER_ASSOCIATION;
459: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.PERMIT_WORK_ORDER_ASSOCIATION'); end if;
460:
461: IF p_permit_wo_association_tbl.COUNT > 0 THEN
462: FOR i in p_permit_wo_association_tbl.FIRST..p_permit_wo_association_tbl.LAST LOOP
463:

Line 466: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;

462: FOR i in p_permit_wo_association_tbl.FIRST..p_permit_wo_association_tbl.LAST LOOP
463:
464: l_safety_assoc_rec := p_permit_wo_association_tbl(i);
465:
466: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking permit existence'); end if;
467:
468: SELECT COUNT(*)
469: INTO l_count
470: FROM EAM_WORK_PERMITS

Line 480: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;

476: THEN
477: RAISE G_SAFETY_EXISTENCE_ERROR;
478: END IF;
479:
480: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking wo existence'); end if;
481:
482: SELECT COUNT(*)
483: INTO l_count
484: FROM WIP_ENTITIES

Line 504: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;

500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
501: RAISE G_SAFETY_TRANSACTION_ERROR;
502: END IF;
503:
504: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
505: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
506: SELECT COUNT(*)
507: INTO l_count
508: FROM EAM_SAFETY_ASSOCIATIONS

Line 505: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

501: RAISE G_SAFETY_TRANSACTION_ERROR;
502: END IF;
503:
504: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
505: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
506: SELECT COUNT(*)
507: INTO l_count
508: FROM EAM_SAFETY_ASSOCIATIONS
509: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID

Line 519: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within PERMIT_WORK_ORDER_ASSOCIATION'); end if;

515: RAISE G_SAFETY_DUPLICATE_ASSO_ERROR;
516: END IF;
517: END IF;
518:
519: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within PERMIT_WORK_ORDER_ASSOCIATION'); end if;
520: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
521: OPEN C;
522: FETCH C INTO l_safety_assoc_id;
523: CLOSE C;

Line 520: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

516: END IF;
517: END IF;
518:
519: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within PERMIT_WORK_ORDER_ASSOCIATION'); end if;
520: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
521: OPEN C;
522: FETCH C INTO l_safety_assoc_id;
523: CLOSE C;
524: l_safety_assoc_rec.SAFETY_ASSOCIATION_ID :=l_safety_assoc_id;

Line 647: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.ASSET_ISOLATION_ASSOCIATION'); end if;

643: l_count NUMBER;
644: BEGIN
645:
646: SAVEPOINT ASSET_ISOLATION_ASSOCIATION;
647: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.ASSET_ISOLATION_ASSOCIATION'); end if;
648:
649: IF p_isolated_assets_tbl.COUNT > 0 THEN
650: FOR i in p_isolated_assets_tbl.FIRST..p_isolated_assets_tbl.LAST LOOP
651:

Line 652: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating transaction type '); END IF;

648:
649: IF p_isolated_assets_tbl.COUNT > 0 THEN
650: FOR i in p_isolated_assets_tbl.FIRST..p_isolated_assets_tbl.LAST LOOP
651:
652: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating transaction type '); END IF;
653:
654: l_safety_assoc_rec := p_isolated_assets_tbl(i);
655:
656: VALIDATE_TRANSACTION_TYPE

Line 667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;

663: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: RAISE G_SAFETY_TRANSACTION_ERROR;
665: END IF;
666:
667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
668: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
669: SELECT COUNT(*)
670: INTO l_count
671: FROM EAM_SAFETY_ASSOCIATIONS

Line 668: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

664: RAISE G_SAFETY_TRANSACTION_ERROR;
665: END IF;
666:
667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Checking for duplicate association'); end if;
668: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
669: SELECT COUNT(*)
670: INTO l_count
671: FROM EAM_SAFETY_ASSOCIATIONS
672: WHERE SOURCE_ID = l_safety_assoc_rec.SOURCE_ID

Line 682: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within ASSET_ISOLATION_ASSOCIATION'); end if;

678: RAISE G_SAFETY_DUPLICATE_ASSO_ERROR;
679: END IF;
680: END IF;
681:
682: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within ASSET_ISOLATION_ASSOCIATION'); end if;
683: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
684: OPEN C;
685: FETCH C INTO l_safety_assoc_id;
686: CLOSE C;

Line 683: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

679: END IF;
680: END IF;
681:
682: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Calling Perform_Writes from within ASSET_ISOLATION_ASSOCIATION'); end if;
683: IF l_safety_assoc_rec.TRANSACTION_TYPE = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
684: OPEN C;
685: FETCH C INTO l_safety_assoc_id;
686: CLOSE C;
687: l_safety_assoc_rec.SAFETY_ASSOCIATION_ID :=l_safety_assoc_id;

Line 794: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.VALIDATE_TRANSACTION_TYPE'); end if;

790: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
791: )IS
792: BEGIN
793:
794: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.VALIDATE_TRANSACTION_TYPE'); end if;
795:
796: IF (p_entity = 'ASSOCIATION') THEN
797: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)
798: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

Line 797: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)

793:
794: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.VALIDATE_TRANSACTION_TYPE'); end if;
795:
796: IF (p_entity = 'ASSOCIATION') THEN
797: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)
798: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
799: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_DELETE)then
800:
801: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 798: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

794: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug(' Inside EAM_SAFETY_ASSOCIATION_PVT.VALIDATE_TRANSACTION_TYPE'); end if;
795:
796: IF (p_entity = 'ASSOCIATION') THEN
797: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)
798: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
799: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_DELETE)then
800:
801: x_return_status := FND_API.G_RET_STS_SUCCESS;
802:

Line 799: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_DELETE)then

795:
796: IF (p_entity = 'ASSOCIATION') THEN
797: IF (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_CREATE)
798: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
799: OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_DELETE)then
800:
801: x_return_status := FND_API.G_RET_STS_SUCCESS;
802:
803: ELSE