22:
23: PROCEDURE CHECK_REQUIRED
24: ( p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_request_rec_type
25: , x_return_status OUT NOCOPY VARCHAR2
26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27: )
28: IS
29:
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
26: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
27: )
28: IS
29:
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: BEGIN
34:
27: )
28: IS
29:
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: BEGIN
34:
35: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Required'); END IF;
28: IS
29:
30: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: BEGIN
34:
35: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Required'); END IF;
36:
31: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
33: BEGIN
34:
35: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Required'); END IF;
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: IF p_eam_request_rec.organization_id IS NULL
41: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
42: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
43:
44: l_out_mesg_token_tbl := l_mesg_token_tbl;
45: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
46: ( p_message_name => 'EAM_WRSR_ORG_REQUIRED'
47: , p_token_tbl => l_Token_tbl
48: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
49: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
58: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
59: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
60:
61: l_out_mesg_token_tbl := l_mesg_token_tbl;
62: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
63: ( p_message_name => 'EAM_WRSR_REQTYPE_REQUIRED'
64: , p_token_tbl => l_Token_tbl
65: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
66: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
75: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
76: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
77:
78: l_out_mesg_token_tbl := l_mesg_token_tbl;
79: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
80: ( p_message_name => 'EAM_WRSR_REQID_REQUIRED'
81: , p_token_tbl => l_Token_tbl
82: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
83: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
91:
92: PROCEDURE CHECK_ATTRIBUTES
93: ( p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_request_rec_type
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
96: )
97: IS
98: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
99: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
96: )
97: IS
98: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
99: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
100: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
101: g_dummy NUMBER;
102: BEGIN
95: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
96: )
97: IS
98: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
99: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
100: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
101: g_dummy NUMBER;
102: BEGIN
103:
96: )
97: IS
98: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
99: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
100: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
101: g_dummy NUMBER;
102: BEGIN
103:
104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Attributes'); END IF;
100: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
101: g_dummy NUMBER;
102: BEGIN
103:
104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request/Service Request processing Check Attributes'); END IF;
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: IF p_eam_request_rec.request_number IS NULL
110: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
111: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
112:
113: l_out_mesg_token_tbl := l_mesg_token_tbl;
114: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
115: ( p_message_name => 'EAM_WRSR_REQNUM_REQUIRED'
116: , p_token_tbl => l_Token_tbl
117: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
118: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
127: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
128: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
129:
130: l_out_mesg_token_tbl := l_mesg_token_tbl;
131: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
132: ( p_message_name => 'EAM_WRSR_REQID_REQUIRED'
133: , p_token_tbl => l_Token_tbl
134: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
135: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
167: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
168: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
169:
170: l_out_mesg_token_tbl := l_mesg_token_tbl;
171: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
172: ( p_message_name => 'EAM_WRSR_INVALID_ORGID'
173: , p_token_tbl => l_token_tbl
174: , p_mesg_token_tbl => l_mesg_token_tbl
175: , x_mesg_token_tbl => l_out_mesg_token_tbl
200: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
201: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
202:
203: l_out_mesg_token_tbl := l_mesg_token_tbl;
204: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
205: ( p_message_name => 'EAM_WRSR_EAMINVALID_ORGID'
206: , p_token_tbl => l_token_tbl
207: , p_mesg_token_tbl => l_mesg_token_tbl
208: , x_mesg_token_tbl => l_out_mesg_token_tbl
230: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
231: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
232:
233: l_out_mesg_token_tbl := l_mesg_token_tbl;
234: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
235: ( p_message_name => 'EAM_WR_INVALID_WORKORDER'
236: , p_token_tbl => l_token_tbl
237: , p_mesg_token_tbl => l_mesg_token_tbl
238: , x_mesg_token_tbl => l_out_mesg_token_tbl
262: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
263: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
264:
265: l_out_mesg_token_tbl := l_mesg_token_tbl;
266: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
267: ( p_message_name => 'EAM_WO_NOT_ASSOC_WR'
268: , p_token_tbl => l_token_tbl
269: , p_mesg_token_tbl => l_mesg_token_tbl
270: , x_mesg_token_tbl => l_out_mesg_token_tbl
293: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
294: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
295:
296: l_out_mesg_token_tbl := l_mesg_token_tbl;
297: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
298: ( p_message_name => 'EAM_WO_REQID_INVALID'
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
329: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
330: l_token_tbl(1).token_value := p_eam_request_rec.wip_entity_id;
331:
332: l_out_mesg_token_tbl := l_mesg_token_tbl;
333: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
334: ( p_message_name => 'EAM_SR_REQ_ID_NOT_OPEN'
335: , p_token_tbl => l_token_tbl
336: , p_mesg_token_tbl => l_mesg_token_tbl
337: , x_mesg_token_tbl => l_out_mesg_token_tbl
356: l_token_tbl(1).token_name := 'REQUEST_ID';
357: l_token_tbl(1).token_value := p_eam_request_rec.request_id;
358:
359: l_out_mesg_token_tbl := l_mesg_token_tbl;
360: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
361: ( p_message_name => 'EAM_WR_ALD_ASSO_WO'
362: , p_token_tbl => l_token_tbl
363: , p_mesg_token_tbl => l_mesg_token_tbl
364: , x_mesg_token_tbl => l_out_mesg_token_tbl
388: l_token_tbl(1).token_name := 'REQUEST_ID';
389: l_token_tbl(1).token_value := p_eam_request_rec.request_id;
390:
391: l_out_mesg_token_tbl := l_mesg_token_tbl;
392: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
393: ( p_message_name => 'EAM_SR_ALD_ASS_WO'
394: , p_token_tbl => l_token_tbl
395: , p_mesg_token_tbl => l_mesg_token_tbl
396: , x_mesg_token_tbl => l_out_mesg_token_tbl