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_CLEARANCE_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_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
28: , x_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_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_clearance_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_clearance_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_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_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_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
37:

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_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
37:
38: BEGIN

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

35: l_return_status VARCHAR2(1);
36: l_work_clearance_header_rec EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type;
37:
38: BEGIN
39: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Clearance'); END IF;
40:
41: EAM_CLEARANCE_UTILITY_PVT.QUERY_ROW (
42: p_work_clearance_id => p_work_clearance_header_rec.work_clearance_id ,
43: p_organization_id => p_work_clearance_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_work_clearance_header_rec.organization_id ,
44: x_work_clearance_header_rec => l_work_clearance_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: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
50: l_out_mesg_token_tbl := l_mesg_token_tbl;
51: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 51: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
50: l_out_mesg_token_tbl := l_mesg_token_tbl;
51: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
52: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
53: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
54: p_message_name => 'EAM_SAFETY_ALREADY_EXISTS' ,
55: p_token_tbl => l_token_tbl );

Line 63: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

59: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_work_clearance_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN
60: l_token_tbl(1).token_name := 'SAFETY_NAME';
61: l_token_tbl(1).token_value := p_work_clearance_header_rec.work_clearance_name;
62: l_out_mesg_token_tbl := l_mesg_token_tbl;
63: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
64: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
65: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
66: p_message_name => 'EAM_SAFETY_EXISTENCE_ERROR' ,
67: p_token_tbl => l_token_tbl );

Line 73: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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

Line 97: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

93: *********************************************************************/
94: PROCEDURE CHECK_ATTRIBUTES
95: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
96: , p_old_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
97: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
98: , x_return_Status OUT NOCOPY VARCHAR2
99: ) IS
100:
101: l_err_text VARCHAR2(2000) := NULL;

Line 102: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

98: , x_return_Status OUT NOCOPY VARCHAR2
99: ) IS
100:
101: l_err_text VARCHAR2(2000) := NULL;
102: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
103: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
104: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
105: l_work_clearance_id number;
106: BEGIN

Line 103: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

99: ) IS
100:
101: l_err_text VARCHAR2(2000) := NULL;
102: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
103: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
104: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
105: l_work_clearance_id number;
106: BEGIN
107:

Line 104: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

100:
101: l_err_text VARCHAR2(2000) := NULL;
102: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
103: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
104: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
105: l_work_clearance_id number;
106: BEGIN
107:
108: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Clearance Check Attributes . . . '); END IF;

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

104: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
105: l_work_clearance_id number;
106: BEGIN
107:
108: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Clearance Check Attributes . . . '); END IF;
109: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id (EAM enabled) . . . ');
110: END IF;
111:
112: BEGIN

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

105: l_work_clearance_id number;
106: BEGIN
107:
108: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Clearance Check Attributes . . . '); END IF;
109: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id (EAM enabled) . . . ');
110: END IF;
111:
112: BEGIN
113: SELECT 1

Line 124: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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

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

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

Line 156: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

152: WHEN fnd_api.g_exc_unexpected_error THEN
153: l_token_tbl(1).token_name := 'SAFETY_NAME';
154: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;
155: l_out_mesg_token_tbl := l_mesg_token_tbl;
156: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
157: p_message_name => 'EAM_SAFETY_ID_EXISTS' ,
158: p_token_tbl => l_token_tbl ,
159: p_mesg_token_tbl => l_mesg_token_tbl ,
160: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

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

Line 187: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

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

Line 205: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in create. . . '); END IF;

201: l_count NUMBER;
202: BEGIN
203: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
204:
205: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in create. . . '); END IF;
206:
207: SELECT COUNT(*)
208: INTO l_count
209: FROM EAM_WORK_CLEARANCES

Line 222: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in Update '); END IF;

218:
219: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
220: BEGIN
221:
222: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in Update '); END IF;
223:
224: SELECT WORK_CLEARANCE_ID
225: INTO l_work_clearance_id
226: FROM EAM_WORK_CLEARANCES

Line 243: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: l_out_mesg_token_tbl := l_mesg_token_tbl;
243: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
244: p_message_name => 'EAM_SAFETY_NAME' ,
245: p_token_tbl => l_token_tbl ,
246: p_mesg_token_tbl => l_mesg_token_tbl ,
247: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

251: RETURN;
252: END;
253:
254: -- status_type
255: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating status_type. . . '); END IF;
256:
257: BEGIN
258: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.draft)) THEN
259: raise fnd_api.g_exc_unexpected_error;

Line 267: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: EXCEPTION
265: WHEN fnd_api.g_exc_unexpected_error THEN
266: l_out_mesg_token_tbl := l_mesg_token_tbl;
267: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
268: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,
269: p_token_tbl => l_token_tbl ,
270: p_mesg_token_tbl => l_mesg_token_tbl ,
271: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

274: x_mesg_token_tbl := l_mesg_token_tbl ;
275: RETURN;
276: END;
277:
278: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating status_type for cancelled. . . '); END IF;
279: BEGIN
280: IF (p_work_clearance_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
281: p_work_clearance_header_rec.status_type = wip_constants.cancelled OR
282: p_work_clearance_header_rec.PERMIT_NAME <> p_old_work_permit_header_rec.PERMIT_NAME OR

Line 316: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

312: WHEN fnd_api.g_exc_unexpected_error THEN
313: l_token_tbl(1).token_name := 'SAFETY_NAME';
314: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;
315: -- l_out_mesg_token_tbl := l_mesg_token_tbl;
316: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
317: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,
318: p_token_tbl => l_token_tbl ,
319: p_mesg_token_tbl => l_mesg_token_tbl ,
320: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

324: RETURN;
325: END; */
326:
327: -- user_id
328: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating user_id . . . '); END IF;
329:
330: BEGIN
331: IF (p_work_clearance_header_rec.user_id IS NOT NULL) THEN
332: SELECT 1

Line 341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

337: END IF;
338: EXCEPTION
339: WHEN no_data_found THEN
340: l_out_mesg_token_tbl := l_mesg_token_tbl;
341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
342: p_message_name => 'EAM_SAFETY_USER' ,
343: p_token_tbl => l_token_tbl ,
344: p_mesg_token_tbl => l_mesg_token_tbl ,
345: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

349: RETURN;
350: END;
351:
352: -- responsibility_id
353: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating responsibility_id . . . '); END IF;
354:
355: BEGIN
356: IF (p_work_clearance_header_rec.responsibility_id IS NOT NULL) THEN
357: SELECT 1

Line 366: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

362: END IF;
363: EXCEPTION
364: WHEN no_data_found THEN
365: l_out_mesg_token_tbl := l_mesg_token_tbl;
366: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
367: p_message_name => 'EAM_SAFETY_RESPONSIBILITY' ,
368: p_token_tbl => l_token_tbl ,
369: p_mesg_token_tbl => l_mesg_token_tbl ,
370: x_mesg_token_tbl => l_out_mesg_token_tbl );

Line 387: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

383: of mandatory attributes.
384: *********************************************************************/
385: PROCEDURE CHECK_REQUIRED
386: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
387: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
388: , x_return_Status OUT NOCOPY VARCHAR2
389: )IS
390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

386: ( p_work_clearance_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_clearance_header_rec_type
387: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
388: , x_return_Status OUT NOCOPY VARCHAR2
389: )IS
390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
393: BEGIN
394: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Clearance . . . '); END IF;

Line 391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

387: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
388: , x_return_Status OUT NOCOPY VARCHAR2
389: )IS
390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
393: BEGIN
394: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Clearance . . . '); END IF;
395:

Line 392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

388: , x_return_Status OUT NOCOPY VARCHAR2
389: )IS
390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
393: BEGIN
394: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Clearance . . . '); END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

390: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
393: BEGIN
394: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Clearance . . . '); END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: IF p_work_clearance_header_rec.WORK_CLEARANCE_ID IS NULL THEN

Line 401: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

397:
398: IF p_work_clearance_header_rec.WORK_CLEARANCE_ID IS NULL THEN
399:
400: l_out_mesg_token_tbl := l_mesg_token_tbl;
401: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
402: p_message_name => 'EAM_SAFETY_ID_REQUIRED' ,
403: p_token_tbl => l_Token_tbl ,
404: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
405: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 412: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

408: END IF;
409: IF p_work_clearance_header_rec.WORK_CLEARANCE_NAME IS NULL THEN
410:
411: l_out_mesg_token_tbl := l_mesg_token_tbl;
412: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
413: p_message_name => 'EAM_SAFETY_NAME_REQUIRED' ,
414: p_token_tbl => l_Token_tbl ,
415: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
416: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 424: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

420:
421: IF p_work_clearance_header_rec.ORGANIZATION_ID IS NULL THEN
422:
423: l_out_mesg_token_tbl := l_mesg_token_tbl;
424: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
425: p_message_name => 'EAM_SAFETY_ORG_REQUIRED' ,
426: p_token_tbl => l_Token_tbl ,
427: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
428: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 435: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

431: END IF;
432:
433: IF p_work_clearance_header_rec.SYSTEM_STATUS IS NULL THEN
434: l_out_mesg_token_tbl := l_mesg_token_tbl;
435: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
436: p_message_name => 'EAM_CLEARANCE_STATUS_REQUIRED' ,
437: p_token_tbl => l_Token_tbl ,
438: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
439: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 450: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

446: (p_work_clearance_header_rec.SCHEDULED_REESTAB_START_DATE IS NULL) OR
447: (p_work_clearance_header_rec.SCHEDULED_REESTAB_END_DATE IS NULL)
448: THEN
449: l_out_mesg_token_tbl := l_mesg_token_tbl;
450: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
451: p_message_name => 'EAM_CLEARANCE_DATES_REQUIRED' ,
452: p_token_tbl => l_Token_tbl ,
453: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
454: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 462: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

458:
459: IF p_work_clearance_header_rec.USER_ID IS NULL
460: THEN
461: l_out_mesg_token_tbl := l_mesg_token_tbl;
462: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
463: ( p_message_name => 'EAM_SAFETY_USERID_REQUIRED'
464: , p_token_tbl => l_Token_tbl
465: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
466: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 475: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

471:
472: IF p_work_clearance_header_rec.RESPONSIBILITY_ID IS NULL
473: THEN
474: l_out_mesg_token_tbl := l_mesg_token_tbl;
475: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
476: ( p_message_name => 'EAM_SAFETY_RESPID_REQUIRED'
477: , p_token_tbl => l_Token_tbl
478: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
479: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl