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_ERROR_MESSAGE_PVT

Line 29: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

25: *********************************************************************/
26: PROCEDURE CHECK_EXISTENCE
27: ( p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
28: , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
29: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30: , x_return_Status OUT NOCOPY VARCHAR2
31: )IS
32: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 32: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

28: , x_iso_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
29: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30: , x_return_Status OUT NOCOPY VARCHAR2
31: )IS
32: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
34: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
35: l_return_status VARCHAR2(1);
36: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;

Line 33: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

29: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30: , x_return_Status OUT NOCOPY VARCHAR2
31: )IS
32: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
34: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
35: l_return_status VARCHAR2(1);
36: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
37: BEGIN

Line 34: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

30: , x_return_Status OUT NOCOPY VARCHAR2
31: )IS
32: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
34: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
35: l_return_status VARCHAR2(1);
36: l_isolation_header_rec EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type;
37: BEGIN
38:

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 54: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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 (
55: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
56: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
57: p_message_name => 'EAM_SAFETY_ALREADY_EXISTS' ,
58: p_token_tbl => l_token_tbl );

Line 67: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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;
67: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
68: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
69: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
70: p_message_name => 'EAM_SAFETY_EXISTENCE_ERROR' ,
71: p_token_tbl => l_token_tbl );

Line 77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

73: l_return_status := FND_API.G_RET_STS_ERROR;
74:
75: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
76: l_out_mesg_token_tbl := l_mesg_token_tbl;
77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
78: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
79: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
80: p_message_name => NULL ,
81: p_message_text => 'Unexpected error' );

Line 101: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

97: *********************************************************************/
98: PROCEDURE CHECK_ATTRIBUTES
99: ( p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
100: , p_old_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
101: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
102: , x_return_Status OUT NOCOPY VARCHAR2
103: )IS
104:
105: l_err_text VARCHAR2(2000) := NULL;

Line 106: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

102: , x_return_Status OUT NOCOPY VARCHAR2
103: )IS
104:
105: l_err_text VARCHAR2(2000) := NULL;
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;

Line 107: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

103: )IS
104:
105: l_err_text VARCHAR2(2000) := NULL;
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:

Line 108: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

104:
105: l_err_text VARCHAR2(2000) := NULL;
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) . . . ');

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 126: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123: EXCEPTION
124: WHEN no_data_found THEN
125: l_out_mesg_token_tbl := l_mesg_token_tbl;
126: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
127: p_message_name => 'EAM_SAFETY_ORG_EAM_ENABLED' ,
128: p_token_tbl => l_token_tbl ,
129: p_mesg_token_tbl => l_mesg_token_tbl ,
130: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 155: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION
153: WHEN fnd_api.g_exc_unexpected_error THEN
154: l_out_mesg_token_tbl := l_mesg_token_tbl;
155: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
156: p_message_name => 'EAM_SAFETY_ID_EXISTS' ,
157: p_token_tbl => l_token_tbl ,
158: p_mesg_token_tbl => l_mesg_token_tbl ,
159: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 185: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: EXCEPTION
183: WHEN fnd_api.g_exc_unexpected_error THEN
184: l_out_mesg_token_tbl := l_mesg_token_tbl;
185: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
186: p_message_name => 'EAM_SAFETY_ID_NOT_EXIST' ,
187: p_token_tbl => l_token_tbl ,
188: p_mesg_token_tbl => l_mesg_token_tbl ,
189: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 214: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: EXCEPTION
212: WHEN fnd_api.g_exc_unexpected_error THEN
213: l_out_mesg_token_tbl := l_mesg_token_tbl;
214: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
215: p_message_name => 'EAM_SAFETY_NAME' ,
216: p_token_tbl => l_token_tbl ,
217: p_mesg_token_tbl => l_mesg_token_tbl ,
218: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 238: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

234: EXCEPTION
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: l_out_mesg_token_tbl := l_mesg_token_tbl;
238: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
239: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,
240: p_token_tbl => l_token_tbl ,
241: p_mesg_token_tbl => l_mesg_token_tbl ,
242: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 303: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

299: WHEN fnd_api.g_exc_unexpected_error THEN
300: l_token_tbl(1).token_name := 'SAFETY_NAME';
301: l_token_tbl(1).token_value := p_iso_header_rec.ISOLATION_NAME;
302: l_out_mesg_token_tbl := l_mesg_token_tbl;
303: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
304: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,
305: p_token_tbl => l_token_tbl ,
306: p_mesg_token_tbl => l_mesg_token_tbl ,
307: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 328: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

324: EXCEPTION
325: WHEN no_data_found THEN
326:
327: l_out_mesg_token_tbl := l_mesg_token_tbl;
328: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
329: p_message_name => 'EAM_SAFETY_USER' ,
330: p_token_tbl => l_token_tbl ,
331: p_mesg_token_tbl => l_mesg_token_tbl ,
332: x_mesg_token_tbl => l_out_mesg_token_tbl );

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 353: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

349: EXCEPTION
350: WHEN no_data_found THEN
351:
352: l_out_mesg_token_tbl := l_mesg_token_tbl;
353: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
354: p_message_name => 'EAM_SAFETY_RESPONSIBILITY' ,
355: p_token_tbl => l_token_tbl ,
356: p_mesg_token_tbl => l_mesg_token_tbl ,
357: x_mesg_token_tbl => l_out_mesg_token_tbl );

Line 372: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

368: * Purpose : Check_Required procedure will check the existence of mandatory attributes.
369: *********************************************************************/
370: PROCEDURE CHECK_REQUIRED
371: ( p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
372: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
373: , x_return_Status OUT NOCOPY VARCHAR2
374: )IS
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;

Line 375: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

371: ( p_iso_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_iso_header_rec_type
372: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
373: , x_return_Status OUT NOCOPY VARCHAR2
374: )IS
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;

Line 376: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

372: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
373: , x_return_Status OUT NOCOPY VARCHAR2
374: )IS
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;

Line 377: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

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

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;

Line 384: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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;
384: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
385: p_message_name => 'EAM_SAFETY_ID_REQUIRED' ,
386: p_token_tbl => l_Token_tbl ,
387: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
388: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 395: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

391: END IF;
392: IF p_iso_header_rec.ISOLATION_NAME IS NULL THEN
393:
394: l_out_mesg_token_tbl := l_mesg_token_tbl;
395: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
396: p_message_name => 'EAM_SAFETY_NAME_REQUIRED' ,
397: p_token_tbl => l_Token_tbl ,
398: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
399: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 406: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

402: END IF;
403: IF p_iso_header_rec.ISOLATION_TYPE IS NULL THEN
404:
405: l_out_mesg_token_tbl := l_mesg_token_tbl;
406: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
407: p_message_name => 'EAM_ISO_TYPE_REQUIRED' ,
408: p_token_tbl => l_Token_tbl ,
409: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
410: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 417: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

413: END IF;
414: IF p_iso_header_rec.ORGANIZATION_ID IS NULL THEN
415:
416: l_out_mesg_token_tbl := l_mesg_token_tbl;
417: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
418: p_message_name => 'EAM_SAFETY_ORG_REQUIRED' ,
419: p_token_tbl => l_Token_tbl ,
420: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
421: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 428: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

424: END IF;
425: IF p_iso_header_rec.SYSTEM_STATUS IS NULL THEN
426:
427: l_out_mesg_token_tbl := l_mesg_token_tbl;
428: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
429: p_message_name => 'EAM_ISOLATION_STATUS_REQUIRED' ,
430: p_token_tbl => l_Token_tbl ,
431: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
432: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 440: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

436:
437: IF p_iso_header_rec.USER_ID IS NULL THEN
438:
439: l_out_mesg_token_tbl := l_mesg_token_tbl;
440: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
441: ( p_message_name => 'EAM_SAFETY_USERID_REQUIRED'
442: , p_token_tbl => l_Token_tbl
443: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
444: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 452: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

448: END IF;
449: IF p_iso_header_rec.RESPONSIBILITY_ID IS NULL THEN
450:
451: l_out_mesg_token_tbl := l_mesg_token_tbl;
452: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
453: ( p_message_name => 'EAM_SAFETY_RESPID_REQUIRED'
454: , p_token_tbl => l_Token_tbl
455: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
456: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl