DBA Data[Home] [Help]

APPS.EAM_RES_USAGE_VALIDATE_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

21: ***************************************************************************/
22:
23: G_Pkg_Name VARCHAR2(30) := 'EAM_RES_USAGE_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26: g_dummy NUMBER;
27:
28: /********************************************************************
29: * Procedure : Check_Attributes

Line 41: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

37:
38: PROCEDURE Check_Attributes
39: ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type
40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
42: )
43: IS
44: l_err_text VARCHAR2(2000) := NULL;
45: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 45: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

41: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
42: )
43: IS
44: l_err_text VARCHAR2(2000) := NULL;
45: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
46: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
47: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
48:
49: BEGIN

Line 46: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

42: )
43: IS
44: l_err_text VARCHAR2(2000) := NULL;
45: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
46: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
47: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
48:
49: BEGIN
50:

Line 47: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

43: IS
44: l_err_text VARCHAR2(2000) := NULL;
45: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
46: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
47: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
48:
49: BEGIN
50:
51:

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

50:
51:
52: -- operation_seq_num
53:
54: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
55:
56: begin
57:
58: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 78: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

74: l_token_tbl(1).token_name := 'OP_SEQ_NUM';
75: l_token_tbl(1).token_value := p_eam_res_usage_rec.operation_seq_num;
76:
77: l_out_mesg_token_tbl := l_mesg_token_tbl;
78: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
79: ( p_message_name => 'EAM_RU_OP_SEQ_INVALID'
80: , p_token_tbl => l_token_tbl
81: , p_mesg_token_tbl => l_mesg_token_tbl
82: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

91:
92:
93: -- resource_seq_num
94:
95: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;
96:
97: begin
98:
99: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 120: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

116: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
117: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
118:
119: l_out_mesg_token_tbl := l_mesg_token_tbl;
120: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
121: ( p_message_name => 'EAM_RU_RES_SEQ_INVALID'
122: , p_token_tbl => l_token_tbl
123: , p_mesg_token_tbl => l_mesg_token_tbl
124: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

132: end;
133:
134:
135: -- instance_id
136: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating instance_id . . . '); END IF;
137:
138: begin
139:
140: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 159: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

155: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
156: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
157:
158: l_out_mesg_token_tbl := l_mesg_token_tbl;
159: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
160: ( p_message_name => 'EAM_RU_INSTANCE_INVALID'
161: , p_token_tbl => l_token_tbl
162: , p_mesg_token_tbl => l_mesg_token_tbl
163: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

172:
173:
174:
175: -- serial_number
176: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;
177:
178: begin
179:
180: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 205: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

201: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
202: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
203:
204: l_out_mesg_token_tbl := l_mesg_token_tbl;
205: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
206: ( p_message_name => 'EAM_RU_SERIAL_NUMBER_INVALID'
207: , p_token_tbl => l_token_tbl
208: , p_mesg_token_tbl => l_mesg_token_tbl
209: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

217: end;
218:
219:
220: -- start_date
221: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
222:
223: begin
224:
225: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 242: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

238: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
239: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
240:
241: l_out_mesg_token_tbl := l_mesg_token_tbl;
242: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
243: ( p_message_name => 'EAM_RU_START_DATE_INVALID'
244: , p_token_tbl => l_token_tbl
245: , p_mesg_token_tbl => l_mesg_token_tbl
246: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

254: end;
255:
256:
257: -- assigned_units
258: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating assigned_units . . . '); END IF;
259:
260: begin
261:
262: if (p_eam_res_usage_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 279: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

275: l_token_tbl(1).token_name := 'RES_SEQ_NUM';
276: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
277:
278: l_out_mesg_token_tbl := l_mesg_token_tbl;
279: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
280: ( p_message_name => 'EAM_RU_ASSIGNED_UNIT_INVALID'
281: , p_token_tbl => l_token_tbl
282: , p_mesg_token_tbl => l_mesg_token_tbl
283: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

292:
293:
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Check Attributes . . . '); END IF;
297:
298:
299: END Check_Attributes;
300:

Line 312: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

308:
309: PROCEDURE Check_Required
310: ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type
311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
313: )
314: IS
315: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
316: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 315: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

311: , x_return_status OUT NOCOPY VARCHAR2
312: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
313: )
314: IS
315: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
316: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
317: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
318: BEGIN
319:

Line 316: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

312: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
313: )
314: IS
315: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
316: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
317: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
318: BEGIN
319:
320: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 317: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

313: )
314: IS
315: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
316: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
317: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
318: BEGIN
319:
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321:

Line 329: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

325: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
326: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
327:
328: l_out_mesg_token_tbl := l_mesg_token_tbl;
329: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
330: ( p_message_name => 'EAM_RU_ENTITY_ID_REQUIRED'
331: , p_token_tbl => l_Token_tbl
332: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
333: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 348: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

344: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
345: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
346:
347: l_out_mesg_token_tbl := l_mesg_token_tbl;
348: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
349: ( p_message_name => 'EAM_RU_ORG_REQUIRED'
350: , p_token_tbl => l_Token_tbl
351: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
352: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 367: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

363: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
364: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
365:
366: l_out_mesg_token_tbl := l_mesg_token_tbl;
367: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
368: ( p_message_name => 'EAM_RU_OP_SEQ_REQUIRED'
369: , p_token_tbl => l_Token_tbl
370: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
371: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 386: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

382: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
383: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
384:
385: l_out_mesg_token_tbl := l_mesg_token_tbl;
386: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
387: ( p_message_name => 'EAM_RU_RES_SEQ_REQUIRED'
388: , p_token_tbl => l_Token_tbl
389: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
390: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 405: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

401: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
402: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
403:
404: l_out_mesg_token_tbl := l_mesg_token_tbl;
405: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
406: ( p_message_name => 'EAM_RU_START_DATE_REQUIRED'
407: , p_token_tbl => l_Token_tbl
408: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
409: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 424: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

420: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
421: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
422:
423: l_out_mesg_token_tbl := l_mesg_token_tbl;
424: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
425: ( p_message_name => 'EAM_RU_COMPL_DATE_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 443: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

439: l_token_tbl(1).token_name := 'RESOURCE_SEQ_NUM';
440: l_token_tbl(1).token_value := p_eam_res_usage_rec.resource_seq_num;
441:
442: l_out_mesg_token_tbl := l_mesg_token_tbl;
443: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
444: ( p_message_name => 'EAM_RU_ASSIGNED_UNIT_REQUIRED'
445: , p_token_tbl => l_Token_tbl
446: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
447: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl