DBA Data[Home] [Help]

APPS.EAM_OP_NETWORK_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_OP_NETWORK_VALIDATE_PVT';
24:
25: g_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
26: g_dummy NUMBER;
27:
28: /*******************************************************************
29: * Procedure : Check_Existence

Line 49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

45:
46: PROCEDURE Check_Existence
47: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
48: , x_old_eam_op_network_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_network_rec_type
49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

Line 53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

49: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN

Line 54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

50: , x_return_status OUT NOCOPY VARCHAR2
51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:

Line 55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

51: )
52: IS
53: l_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
54: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Operation Network'); END IF;

Line 59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Operation Network'); END IF;

55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Operation Network'); END IF;
60:
61: EAM_OP_NETWORK_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_op_network_rec.wip_entity_id
63: , p_organization_id => p_eam_op_network_rec.organization_id

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

66: , x_eam_op_network_rec => x_old_eam_op_network_rec
67: , x_Return_status => l_return_status
68: );
69:
70: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
71:
72: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
73: p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
74: THEN

Line 79: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

75: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
76: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
77:
78: l_out_mesg_token_tbl := l_mesg_token_tbl;
79: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
80: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
81: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
82: , p_message_name => 'EAM_OPN_ALREADY_EXISTS'
83: , p_token_tbl => l_token_tbl

Line 97: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

93: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
94: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
95:
96: l_out_mesg_token_tbl := l_mesg_token_tbl;
97: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
98: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
99: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
100: , p_message_name => 'EAM_OPN_DOESNOT_EXISTS'
101: , p_token_tbl => l_token_tbl

Line 110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;
110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
111: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl
112: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
113: , p_message_name => NULL
114: , p_message_text => 'Unexpected error while existence verification of ' || 'Operation Network '|| p_eam_op_network_rec.prior_operation , p_token_tbl => l_token_tbl

Line 151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

147: PROCEDURE Check_Attributes
148: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
149: , p_old_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

151: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158:
159: BEGIN

Line 156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

152: )
153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158:
159: BEGIN
160:

Line 157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

153: IS
154: l_err_text VARCHAR2(2000) := NULL;
155: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
156: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
157: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
158:
159: BEGIN
160:
161:

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

161:
162:
163: -- prior_operation
164:
165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating prior_operation . . . '); END IF;
166:
167: begin
168:
169: if (p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 190: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

186: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
187: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
188:
189: l_out_mesg_token_tbl := l_mesg_token_tbl;
190: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
191: ( p_message_name => 'EAM_OPN_PRIOR_OP_INVALID'
192: , p_token_tbl => l_token_tbl
193: , p_mesg_token_tbl => l_mesg_token_tbl
194: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

203:
204:
205: -- next_operation
206:
207: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating next_operation . . . '); END IF;
208:
209: begin
210:
211: if (p_eam_op_network_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) then

Line 232: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

228: l_token_tbl(1).token_name := 'NEXT_OPERATION';
229: l_token_tbl(1).token_value := p_eam_op_network_rec.next_operation;
230:
231: l_out_mesg_token_tbl := l_mesg_token_tbl;
232: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
233: ( p_message_name => 'EAM_OPN_NEXT_OP_INVALID'
234: , p_token_tbl => l_token_tbl
235: , p_mesg_token_tbl => l_mesg_token_tbl
236: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 248: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Operation Network Check Attributes . . . '); END IF;

244: end;
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Operation Network Check Attributes . . . '); END IF;
249:
250:
251: END Check_Attributes;
252:

Line 264: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

260:
261: PROCEDURE Check_Required
262: ( p_eam_op_network_rec IN EAM_PROCESS_WO_PUB.eam_op_network_rec_type
263: , x_return_status OUT NOCOPY VARCHAR2
264: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
265: )
266: IS
267: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 267: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

263: , x_return_status OUT NOCOPY VARCHAR2
264: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
265: )
266: IS
267: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
269: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
270: BEGIN
271:

Line 268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

264: , x_Mesg_Token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
265: )
266: IS
267: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
269: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
270: BEGIN
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 269: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

265: )
266: IS
267: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
268: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
269: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
270: BEGIN
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:

Line 281: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

277: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
278: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
279:
280: l_out_mesg_token_tbl := l_mesg_token_tbl;
281: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
282: ( p_message_name => 'EAM_OPN_ENTITY_ID_REQUIRED'
283: , p_token_tbl => l_Token_tbl
284: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
285: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 300: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

296: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
297: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
298:
299: l_out_mesg_token_tbl := l_mesg_token_tbl;
300: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
301: ( p_message_name => 'EAM_OPN_ORG_REQUIRED'
302: , p_token_tbl => l_Token_tbl
303: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
304: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 319: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

315: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
316: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
317:
318: l_out_mesg_token_tbl := l_mesg_token_tbl;
319: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
320: ( p_message_name => 'EAM_OPN_PRIOR_OP_REQUIRED'
321: , p_token_tbl => l_Token_tbl
322: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
323: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 338: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

334: l_token_tbl(1).token_name := 'PRIOR_OPERATION';
335: l_token_tbl(1).token_value := p_eam_op_network_rec.prior_operation;
336:
337: l_out_mesg_token_tbl := l_mesg_token_tbl;
338: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
339: ( p_message_name => 'EAM_OPN_NEXT_OP_REQUIRED'
340: , p_token_tbl => l_Token_tbl
341: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
342: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl