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_PERMIT_VALIDATE_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,

8: *********************************************************************/
9: PROCEDURE CHECK_EXISTENCE(
10: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
11: x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS
15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

11: x_work_permit_header_rec OUT NOCOPY EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS
15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
17: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
18: l_return_status VARCHAR2(1);
19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;

Line 16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

12: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS
15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
17: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
18: l_return_status VARCHAR2(1);
19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
20:

Line 17: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

13: x_return_Status OUT NOCOPY VARCHAR2 )
14: IS
15: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
16: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
17: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
18: l_return_status VARCHAR2(1);
19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
20:
21: BEGIN

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

18: l_return_status VARCHAR2(1);
19: l_work_permit_header_rec EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type;
20:
21: BEGIN
22: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Permit'); END IF;
23: EAM_PERMIT_UTILITY_PVT.QUERY_ROW (
24: p_work_permit_id => p_work_permit_header_rec.PERMIT_ID ,
25: p_organization_id => p_work_permit_header_rec.organization_id ,
26: x_work_permit_header_rec => l_work_permit_header_rec ,

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

25: p_organization_id => p_work_permit_header_rec.organization_id ,
26: x_work_permit_header_rec => l_work_permit_header_rec ,
27: x_Return_status => l_return_status );
28:
29: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status);
30: END IF;
31: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
32: -- l_token_tbl(1).token_name := 'EAM_WO_PERMIT';
33: -- l_token_tbl(1).token_value := p_work_permit_header_rec.direct_item_sequence_id;

Line 35: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

31: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
32: -- l_token_tbl(1).token_name := 'EAM_WO_PERMIT';
33: -- l_token_tbl(1).token_value := p_work_permit_header_rec.direct_item_sequence_id;
34: -- l_out_mesg_token_tbl := l_mesg_token_tbl;
35: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
36: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
37: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
38: p_message_name => 'EAM_PERMIT_ALREADY_EXISTS' ,
39: p_token_tbl => l_token_tbl );

Line 48: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

44: l_token_tbl(1).token_name := 'PERMIT_NAME';
45: l_token_tbl(1).token_value := p_work_permit_header_rec.PERMIT_NAME;
46:
47: l_out_mesg_token_tbl := l_mesg_token_tbl;
48: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
49: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
50: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
51: p_message_name => 'EAM_PERMIT_DOESNOT_EXISTS' ,
52: p_token_tbl => l_token_tbl );

Line 58: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

54: l_return_status := FND_API.G_RET_STS_ERROR;
55:
56: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
57: l_out_mesg_token_tbl := l_mesg_token_tbl;
58: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
59: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
60: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
61: p_message_name => NULL ,
62: p_message_text => 'Unexpected error' );

Line 82: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,

78: *********************************************************************/
79: PROCEDURE CHECK_ATTRIBUTES(
80: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
81: p_old_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
82: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
83: x_return_Status OUT NOCOPY VARCHAR2 )
84: IS
85: l_err_text VARCHAR2(2000) := NULL;
86: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 86: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

82: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
83: x_return_Status OUT NOCOPY VARCHAR2 )
84: IS
85: l_err_text VARCHAR2(2000) := NULL;
86: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
87: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
88: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
89: l_permit_id number;
90:

Line 87: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

83: x_return_Status OUT NOCOPY VARCHAR2 )
84: IS
85: l_err_text VARCHAR2(2000) := NULL;
86: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
87: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
88: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
89: l_permit_id number;
90:
91: BEGIN

Line 88: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

84: IS
85: l_err_text VARCHAR2(2000) := NULL;
86: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
87: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
88: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
89: l_permit_id number;
90:
91: BEGIN
92: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Permit Check Attributes . . . '); END IF;

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

88: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
89: l_permit_id number;
90:
91: BEGIN
92: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Permit Check Attributes . . . '); END IF;
93:
94: /*IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id . . . '); END IF;
95:
96: DECLARE

Line 94: /*IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id . . . '); END IF;

90:
91: BEGIN
92: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Permit Check Attributes . . . '); END IF;
93:
94: /*IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id . . . '); END IF;
95:
96: DECLARE
97: l_disable_date DATE;
98: BEGIN

Line 116: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

112: WHEN fnd_api.g_exc_unexpected_error THEN
113: -- l_token_tbl(1).token_name := 'Organization Id';
114: -- l_token_tbl(1).token_value := p_eam_wo_rec.organization_id;
115: l_out_mesg_token_tbl := l_mesg_token_tbl;
116: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
117: p_message_name => 'EAM_PERMIT_ORGANIZATION_ID' ,
118: p_token_tbl => l_token_tbl ,
119: p_mesg_token_tbl => l_mesg_token_tbl ,
120: x_mesg_token_tbl => l_out_mesg_token_tbl );

Line 129: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

125: WHEN no_data_found THEN
126: -- l_token_tbl(1).token_name := 'Organization Id';
127: -- l_token_tbl(1).token_value := p_eam_wo_rec.organization_id;
128: l_out_mesg_token_tbl := l_mesg_token_tbl;
129: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
130: p_message_name => 'EAM_PERMIT_ORGANIZATION_ID' ,
131: p_token_tbl => l_token_tbl ,
132: p_mesg_token_tbl => l_mesg_token_tbl ,
133: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

136: x_mesg_token_tbl := l_mesg_token_tbl ;
137: RETURN;
138: END;
139:
140: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating organization_id (EAM enabled) . . . ');
141: END IF;
142:
143: BEGIN
144: SELECT 1

Line 157: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

153: WHEN no_data_found THEN
154: -- l_token_tbl(1).token_name := 'Organization Id';
155: -- l_token_tbl(1).token_value := p_work_permit_header_rec.organization_id;
156: l_out_mesg_token_tbl := l_mesg_token_tbl;
157: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
158: p_message_name => 'EAM_PERMIT_ORG_EAM_ENABLED' ,
159: p_token_tbl => l_token_tbl ,
160: p_mesg_token_tbl => l_mesg_token_tbl ,
161: x_mesg_token_tbl => l_out_mesg_token_tbl );

Line 168: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Permit ID already exists for create . . . '); END IF;

164: x_mesg_token_tbl := l_mesg_token_tbl ;
165: RETURN;
166: END;
167:
168: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Permit ID already exists for create . . . '); END IF;
169:
170: DECLARE
171: l_count NUMBER;
172: BEGIN

Line 189: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

185: WHEN fnd_api.g_exc_unexpected_error THEN
186: -- l_token_tbl(1).token_name := 'Wip Entity Name';
187: -- l_token_tbl(1).token_value := p_eam_wo_rec.wip_entity_name;
188: l_out_mesg_token_tbl := l_mesg_token_tbl;
189: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
190: p_message_name => 'EAM_PERMIT_ID' ,
191: p_token_tbl => l_token_tbl ,
192: p_mesg_token_tbl => l_mesg_token_tbl ,
193: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

196: x_mesg_token_tbl := l_mesg_token_tbl ;
197: RETURN;
198: END; */
199:
200: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating if Permit ID exists for update . . . '); END IF;
201: DECLARE
202: l_count NUMBER;
203: BEGIN
204: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN

Line 221: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

217: WHEN fnd_api.g_exc_unexpected_error THEN
218: -- l_token_tbl(1).token_name := 'Wip Entity Name';
219: -- l_token_tbl(1).token_value := p_eam_wo_rec.wip_entity_name;
220: l_out_mesg_token_tbl := l_mesg_token_tbl;
221: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
222: p_message_name => 'EAM_PERMIT_ID_NOT_EXIST' ,
223: p_token_tbl => l_token_tbl ,
224: p_mesg_token_tbl => l_mesg_token_tbl ,
225: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

228: x_mesg_token_tbl := l_mesg_token_tbl ;
229: RETURN;
230: END;
231:
232: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Permit Name . . . '); END IF;
233: DECLARE
234: l_count NUMBER;
235: BEGIN
236: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN

Line 272: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

268: WHEN fnd_api.g_exc_unexpected_error THEN
269: l_token_tbl(1).token_name := 'PERMIT_NAME';
270: l_token_tbl(1).token_value := p_work_permit_header_rec.PERMIT_NAME;
271: l_out_mesg_token_tbl := l_mesg_token_tbl;
272: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
273: p_message_name => 'EAM_PERMIT_NAME' ,
274: p_token_tbl => l_token_tbl ,
275: p_mesg_token_tbl => l_mesg_token_tbl ,
276: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

280: RETURN;
281: END;
282:
283: -- status_type
284: /* IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating status_type. . . '); END IF;
285: BEGIN
286: IF (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_work_permit_header_rec.status_type NOT IN (wip_constants.released, wip_constants.draft)) THEN
287: raise fnd_api.g_exc_unexpected_error;
288: elsif (p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_work_permit_header_rec.status_type NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg )) THEN

Line 297: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

293: WHEN fnd_api.g_exc_unexpected_error THEN
294: -- l_token_tbl(1).token_name := 'Status type';
295: -- l_token_tbl(1).token_value := p_eam_wo_rec.status_type;
296: l_out_mesg_token_tbl := l_mesg_token_tbl;
297: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
298: p_message_name => 'EAM_PERMIT_STATUS_TYPE' ,
299: p_token_tbl => l_token_tbl ,
300: p_mesg_token_tbl => l_mesg_token_tbl ,
301: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

304: x_mesg_token_tbl := l_mesg_token_tbl ;
305: RETURN;
306: END;
307:
308: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating status_type for cancelled. . . '); END IF;
309: BEGIN
310: IF (p_work_permit_header_rec.transaction_type= EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
311: p_work_permit_header_rec.status_type = wip_constants.cancelled OR
312: p_work_permit_header_rec.PERMIT_NAME <> p_old_work_permit_header_rec.PERMIT_NAME OR

Line 346: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

342: WHEN fnd_api.g_exc_unexpected_error THEN
343: -- l_token_tbl(1).token_name := 'Status type';
344: -- l_token_tbl(1).token_value := p_eam_wo_rec.status_type;
345: l_out_mesg_token_tbl := l_mesg_token_tbl;
346: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
347: p_message_name => 'EAM_PERMIT_STATUS_TYPE' ,
348: p_token_tbl => l_token_tbl ,
349: p_mesg_token_tbl => l_mesg_token_tbl ,
350: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

354: RETURN;
355: END;*/
356:
357: -- user_id
358: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating user_id . . . '); END IF;
359: BEGIN
360: IF (p_work_permit_header_rec.user_id IS NOT NULL) THEN
361: SELECT 1
362: INTO g_dummy

Line 372: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

368: WHEN no_data_found THEN
369: --l_token_tbl(1).token_name := 'USER_ID';
370: --l_token_tbl(1).token_value := p_eam_wo_rec.user_id;
371: l_out_mesg_token_tbl := l_mesg_token_tbl;
372: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
373: p_message_name => 'EAM_PERMIT_USER' ,
374: p_token_tbl => l_token_tbl ,
375: p_mesg_token_tbl => l_mesg_token_tbl ,
376: x_mesg_token_tbl => l_out_mesg_token_tbl );

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

380: RETURN;
381: END;
382:
383: -- responsibility_id
384: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating responsibility_id . . . '); END IF;
385: BEGIN
386: IF (p_work_permit_header_rec.responsibility_id IS NOT NULL) THEN
387: SELECT 1
388: INTO g_dummy

Line 398: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

394: WHEN no_data_found THEN
395: -- l_token_tbl(1).token_name := 'RESPONSIBILITY_ID';
396: -- l_token_tbl(1).token_value := p_eam_wo_rec.responsibility_id;
397: l_out_mesg_token_tbl := l_mesg_token_tbl;
398: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
399: p_message_name => 'EAM_PERMIT_RESPONSIBILITY' ,
400: p_token_tbl => l_token_tbl ,
401: p_mesg_token_tbl => l_mesg_token_tbl ,
402: x_mesg_token_tbl => l_out_mesg_token_tbl );

Line 418: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,

414: * Purpose : Check_Required procedure will check the existence of mandatory attributes.
415: *********************************************************************/
416: PROCEDURE CHECK_REQUIRED(
417: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
418: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
419: x_return_Status OUT NOCOPY VARCHAR2 )
420: IS
421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

417: p_work_permit_header_rec IN EAM_PROCESS_SAFETY_PUB.eam_wp_header_rec_type ,
418: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
419: x_return_Status OUT NOCOPY VARCHAR2 )
420: IS
421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
423: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
424:
425: BEGIN

Line 422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

418: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
419: x_return_Status OUT NOCOPY VARCHAR2 )
420: IS
421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
423: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
424:
425: BEGIN
426: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Permit . . . '); END IF;

Line 423: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

419: x_return_Status OUT NOCOPY VARCHAR2 )
420: IS
421: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
423: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
424:
425: BEGIN
426: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Permit . . . '); END IF;
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

422: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
423: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
424:
425: BEGIN
426: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Permit . . . '); END IF;
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428: IF p_work_permit_header_rec.PERMIT_ID IS NULL THEN
429: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
430: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;

Line 432: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

428: IF p_work_permit_header_rec.PERMIT_ID IS NULL THEN
429: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
430: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
431: l_out_mesg_token_tbl := l_mesg_token_tbl;
432: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
433: p_message_name => 'EAM_PERMIT_ID_REQUIRED' ,
434: p_token_tbl => l_Token_tbl ,
435: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
436: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 444: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

440: IF p_work_permit_header_rec.PERMIT_NAME IS NULL THEN
441: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
442: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
443: l_out_mesg_token_tbl := l_mesg_token_tbl;
444: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
445: p_message_name => 'EAM_PERMIT_NAME_REQUIRED' ,
446: p_token_tbl => l_Token_tbl ,
447: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
448: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 456: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

452: IF p_work_permit_header_rec.ORGANIZATION_ID IS NULL THEN
453: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
454: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
455: l_out_mesg_token_tbl := l_mesg_token_tbl;
456: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
457: p_message_name => 'EAM_PERMIT_ORG_REQUIRED' ,
458: p_token_tbl => l_Token_tbl ,
459: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
460: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 468: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

464: IF p_work_permit_header_rec.STATUS_TYPE IS NULL THEN
465: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
466: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
467: l_out_mesg_token_tbl := l_mesg_token_tbl;
468: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
469: p_message_name => 'EAM_PERMIT_STATUS_REQUIRED' ,
470: p_token_tbl => l_Token_tbl ,
471: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
472: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );

Line 482: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

478: THEN
479: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
480: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
481: l_out_mesg_token_tbl := l_mesg_token_tbl;
482: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
483: ( p_message_name => 'EAM_PERMIT_USERID_REQUIRED'
484: , p_token_tbl => l_Token_tbl
485: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
486: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 496: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

492: THEN
493: -- l_token_tbl(1).token_name := 'OPERATION_SEQ_NUM';
494: -- l_token_tbl(1).token_value := p_eam_op_rec.operation_seq_num;
495: l_out_mesg_token_tbl := l_mesg_token_tbl;
496: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
497: ( p_message_name => 'EAM_PERMIT_RESPID_REQUIRED'
498: , p_token_tbl => l_Token_tbl
499: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
500: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl