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

Line 39: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Isolation'); END IF;

35: l_return_status VARCHAR2(1);
36: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
37: BEGIN
38:
39: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Isolation'); END IF;
40:
41: EAM_ISOLATION_UTILITY_PVT.QUERY_ROW (
42: p_isolation_id => p_iso_header_rec.ISOLATION_ID ,
43: p_organization_id => p_iso_header_rec.organization_id ,

Line 47: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status);

43: p_organization_id => p_iso_header_rec.organization_id ,
44: x_isolation_header_rec => l_isolation_header_rec ,
45: x_Return_status => l_return_status );
46:
47: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status);
48: END IF;
49:
50: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
51:

Line 50: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

46:
47: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status);
48: END IF;
49:
50: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
51:
52:
53: l_out_mesg_token_tbl := l_mesg_token_tbl;
54: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 62: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_iso_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN

58: p_token_tbl => l_token_tbl );
59: l_mesg_token_tbl := l_out_mesg_token_tbl;
60: l_return_status := FND_API.G_RET_STS_ERROR;
61:
62: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_iso_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN
63: l_token_tbl(1).token_name := 'SAFETY_NAME';
64: l_token_tbl(1).token_value := p_iso_header_rec.ISOLATION_NAME;
65:
66: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 110: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Isolation Check Attributes . . . '); END IF;

106: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
107: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
108: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
109: BEGIN
110: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Isolation Check Attributes . . . '); END IF;
111:
112: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id of Isolation (EAM enabled) . . . ');
113: END IF;
114: BEGIN

Line 112: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id of Isolation (EAM enabled) . . . ');

108: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
109: BEGIN
110: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Isolation Check Attributes . . . '); END IF;
111:
112: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id of Isolation (EAM enabled) . . . ');
113: END IF;
114: BEGIN
115: SELECT 1
116: INTO g_dummy

Line 137: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID already exists for create . . . '); END IF;

133: x_mesg_token_tbl := l_mesg_token_tbl ;
134: RETURN;
135: END;
136:
137: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID already exists for create . . . '); END IF;
138: DECLARE
139: l_count NUMBER;
140: BEGIN
141: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN

Line 141: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN

137: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID already exists for create . . . '); END IF;
138: DECLARE
139: l_count NUMBER;
140: BEGIN
141: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
142: SELECT COUNT(*)
143: INTO l_count
144: FROM EAM_ISOLATIONS
145: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID

Line 166: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID exists for update . . . '); END IF;

162: x_mesg_token_tbl := l_mesg_token_tbl ;
163: RETURN;
164: END;
165:
166: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID exists for update . . . '); END IF;
167: DECLARE
168: l_count NUMBER;
169: BEGIN
170: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN

Line 170: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN

166: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Isolation ID exists for update . . . '); END IF;
167: DECLARE
168: l_count NUMBER;
169: BEGIN
170: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
171: SELECT COUNT(*)
172: INTO l_count
173: FROM EAM_ISOLATIONS
174: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID

Line 196: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation Name . . . '); END IF;

192: x_mesg_token_tbl := l_mesg_token_tbl ;
193: RETURN;
194: END;
195:
196: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation Name . . . '); END IF;
197: DECLARE
198: l_count NUMBER;
199: BEGIN
200: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN

Line 200: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN

196: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation Name . . . '); END IF;
197: DECLARE
198: l_count NUMBER;
199: BEGIN
200: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
201: SELECT COUNT(*)
202: INTO l_count
203: FROM EAM_ISOLATIONS
204: WHERE ISOLATION_NAME = p_iso_header_rec.ISOLATION_NAME

Line 226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;

222: RETURN;
223: END;
224:
225: -- status_type
226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN

Line 228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN

224:
225: -- status_type
226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;

Line 230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN

226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: EXCEPTION

Line 249: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type for cancelled. . . '); END IF;

245: x_mesg_token_tbl := l_mesg_token_tbl ;
246: RETURN;
247: END;
248:
249: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type for cancelled. . . '); END IF;
250: BEGIN
251: IF (p_iso_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
252: p_iso_header_rec.SYSTEM_STATUS = wip_constants.cancelled OR
253: p_iso_header_rec.ISOLATION_NAME <> p_old_iso_header_rec.ISOLATION_NAME OR

Line 251: IF (p_iso_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND

247: END;
248:
249: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type for cancelled. . . '); END IF;
250: BEGIN
251: IF (p_iso_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
252: p_iso_header_rec.SYSTEM_STATUS = wip_constants.cancelled OR
253: p_iso_header_rec.ISOLATION_NAME <> p_old_iso_header_rec.ISOLATION_NAME OR
254: p_iso_header_rec.DESCRIPTION <> p_old_iso_header_rec.DESCRIPTION OR
255: p_iso_header_rec.ORGANIZATION_ID <> p_old_iso_header_rec.ORGANIZATION_ID OR

Line 315: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating user_id . . . '); END IF;

311: RETURN;
312: END; */
313:
314: -- user_id
315: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating user_id . . . '); END IF;
316: BEGIN
317: IF (p_iso_header_rec.user_id IS NOT NULL) THEN
318: SELECT 1
319: INTO g_dummy

Line 340: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating responsibility_id . . . '); END IF;

336: RETURN;
337: END;
338:
339: -- responsibility_id
340: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating responsibility_id . . . '); END IF;
341: BEGIN
342: IF (p_iso_header_rec.responsibility_id IS NOT NULL) THEN
343: SELECT 1
344: INTO g_dummy

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

375: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
376: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
377: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
378: BEGIN
379: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Isolation . . . '); END IF;
380: x_return_status:= FND_API.G_RET_STS_SUCCESS;
381: IF p_iso_header_rec.ISOLATION_ID IS NULL THEN
382:
383: l_out_mesg_token_tbl := l_mesg_token_tbl;