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

Line 28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

24: PROCEDURE Check_Required
25: (
26: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB.eam_op_comp_rec_type
27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30:
31: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 31: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

27: , x_return_status OUT NOCOPY VARCHAR2
28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30:
31: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
34: l_shutdown_type varchar2(30);
35: BEGIN

Line 32: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

28: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
29: )IS
30:
31: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
34: l_shutdown_type varchar2(30);
35: BEGIN
36:

Line 33: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

29: )IS
30:
31: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
32: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
34: l_shutdown_type varchar2(30);
35: BEGIN
36:
37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Populate null columns'); END IF;

Line 37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Populate null columns'); END IF;

33: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
34: l_shutdown_type varchar2(30);
35: BEGIN
36:
37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Populate null columns'); END IF;
38:
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41:

Line 44: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : operation_seq_num ...'); END IF;

40:
41:
42: IF p_eam_op_comp_rec.operation_seq_num IS NULL
43: THEN
44: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : operation_seq_num ...'); END IF;
45: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
46: l_token_tbl(1).token_value := p_eam_op_comp_rec.wip_entity_id;
47:
48: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 49: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

45: l_token_tbl(1).token_name := 'WIP_ENTITY_ID';
46: l_token_tbl(1).token_value := p_eam_op_comp_rec.wip_entity_id;
47:
48: l_out_mesg_token_tbl := l_mesg_token_tbl;
49: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
50: ( p_message_name => 'EAM_OPCL_OP_REQUIRED'
51: , p_token_tbl => l_Token_tbl
52: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
53: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 63: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : actual_start_date ...'); END IF;

59: END IF;
60:
61: IF p_eam_op_comp_rec.actual_start_date IS NULL
62: THEN
63: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : actual_start_date ...'); END IF;
64: l_token_tbl(1).token_name := 'OP_SEQ_NO';
65: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
66:
67: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 68: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

64: l_token_tbl(1).token_name := 'OP_SEQ_NO';
65: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
66:
67: l_out_mesg_token_tbl := l_mesg_token_tbl;
68: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
69: ( p_message_name => 'EAM_OPCL_ACTSTD_REQUIRED'
70: , p_token_tbl => l_Token_tbl
71: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
72: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 82: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : Actual end date ...'); END IF;

78: END IF;
79:
80: IF p_eam_op_comp_rec.actual_end_date IS NULL
81: THEN
82: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : Actual end date ...'); END IF;
83: l_token_tbl(1).token_name := 'OP_SEQ_NO';
84: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
85:
86: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 87: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

83: l_token_tbl(1).token_name := 'OP_SEQ_NO';
84: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
85:
86: l_out_mesg_token_tbl := l_mesg_token_tbl;
87: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
88: ( p_message_name => 'EAM_OPCL_ACTEND_REQUIRED'
89: , p_token_tbl => l_Token_tbl
90: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
91: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : Actual duration ...'); END IF;

97: END IF;
98:
99: IF p_eam_op_comp_rec.actual_duration IS NULL
100: THEN
101: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : Actual duration ...'); END IF;
102: l_token_tbl(1).token_name := 'OP_SEQ_NO';
103: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
104:
105: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 106: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

102: l_token_tbl(1).token_name := 'OP_SEQ_NO';
103: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
104:
105: l_out_mesg_token_tbl := l_mesg_token_tbl;
106: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
107: ( p_message_name => 'EAM_OPCL_ACTDUR_REQUIRED'
108: , p_token_tbl => l_Token_tbl
109: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
110: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 121: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : transaction_type ...'); END IF;

117:
118:
119: IF p_eam_op_comp_rec.transaction_type IS NULL
120: THEN
121: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : transaction_type ...'); END IF;
122: l_token_tbl(1).token_name := 'OP_SEQ_NO';
123: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
124:
125: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 126: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

122: l_token_tbl(1).token_name := 'OP_SEQ_NO';
123: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
124:
125: l_out_mesg_token_tbl := l_mesg_token_tbl;
126: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
127: ( p_message_name => 'EAM_OPCL_TRANX_REQUIRED'
128: , p_token_tbl => l_Token_tbl
129: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
130: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : shutdown information ...'); END IF;

151: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
152:
153: IF nvl(to_number(l_shutdown_type),1) = 2 THEN
154: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
155: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : shutdown information ...'); END IF;
156:
157: l_token_tbl(1).token_name := 'OP_SEQ_NO';
158: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
159:

Line 161: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

157: l_token_tbl(1).token_name := 'OP_SEQ_NO';
158: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
159:
160: l_out_mesg_token_tbl := l_mesg_token_tbl;
161: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
162: ( p_message_name => 'EAM_OPCL_SHUTDOWN_REQUIRED'
163: , p_token_tbl => l_Token_tbl
164: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
165: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 182: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

178: PROCEDURE Check_Attributes
179: (
180: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB. eam_op_comp_rec_type
181: , x_return_status OUT NOCOPY VARCHAR2
182: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
183: )IS
184: l_err_text VARCHAR2(2000) := NULL;
185: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
186: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 185: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

181: , x_return_status OUT NOCOPY VARCHAR2
182: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
183: )IS
184: l_err_text VARCHAR2(2000) := NULL;
185: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
186: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
187: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
188: l_open_acct_per_date DATE;
189: l_reconciliation_code VARCHAR2(30);

Line 186: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

182: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
183: )IS
184: l_err_text VARCHAR2(2000) := NULL;
185: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
186: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
187: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
188: l_open_acct_per_date DATE;
189: l_reconciliation_code VARCHAR2(30);
190: l_prev_uncomplete NUMBER := 0;

Line 187: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

183: )IS
184: l_err_text VARCHAR2(2000) := NULL;
185: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
186: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
187: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
188: l_open_acct_per_date DATE;
189: l_reconciliation_code VARCHAR2(30);
190: l_prev_uncomplete NUMBER := 0;
191: l_prev_completed_after NUMBER := 0;

Line 241: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;

237: );
238:
239: BEGIN
240:
241: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;

Line 245: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;

241: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
246: BEGIN
247: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
248: raise fnd_api.g_exc_unexpected_error;
249: END IF;

Line 259: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

255: l_token_tbl(1).token_name := 'OP_SEQ_NO';
256: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
257:
258: l_out_mesg_token_tbl := l_mesg_token_tbl;
259: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
260: ( p_message_name => 'EAM_OPCMPL_DATE_BAD'
261: , p_token_tbl => l_token_tbl
262: , p_mesg_token_tbl => l_mesg_token_tbl
263: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;

269: RETURN;
270: END;
271:
272: BEGIN
273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
274: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
275: raise fnd_api.g_exc_unexpected_error;
276: END IF;
277:

Line 286: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

282: l_token_tbl(1).token_name := 'OP_SEQ_NO';
283: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
284:
285: l_out_mesg_token_tbl := l_mesg_token_tbl;
286: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
287: ( p_message_name => 'EAM_OP_SHUTDOWN_DATE_BAD'
288: , p_token_tbl => l_token_tbl
289: , p_mesg_token_tbl => l_mesg_token_tbl
290: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 299: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual duration ...'); END IF;

295: x_mesg_token_tbl := l_mesg_token_tbl ;
296: RETURN;
297: END;
298:
299: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual duration ...'); END IF;
300: BEGIN
301: IF p_eam_op_comp_rec.actual_duration < 0 THEN
302: raise fnd_api.g_exc_unexpected_error;
303: END IF;

Line 313: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

309: l_token_tbl(1).token_name := 'OP_SEQ_NO';
310: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
311:
312: l_out_mesg_token_tbl := l_mesg_token_tbl;
313: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
314: ( p_message_name => 'EAM_OP_COMP_DURATION_BAD'
315: , p_token_tbl => l_token_tbl
316: , p_mesg_token_tbl => l_mesg_token_tbl
317: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual end date ...'); END IF;

322: x_mesg_token_tbl := l_mesg_token_tbl ;
323: RETURN;
324: END;
325:
326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual end date ...'); END IF;
327: BEGIN
328: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
329: raise fnd_api.g_exc_unexpected_error;
330: END IF;

Line 341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

337: l_token_tbl(1).token_name := 'OP_SEQ_NO';
338: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
339:
340: l_out_mesg_token_tbl := l_mesg_token_tbl;
341: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
342: ( p_message_name => 'EAM_OP_END_LATER_THAN_TODAY'
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 369: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

365: l_token_tbl(1).token_name := 'OP_SEQ_NO';
366: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
367:
368: l_out_mesg_token_tbl := l_mesg_token_tbl;
369: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
370: ( p_message_name => 'EAM_SHUTDOWN_DATE_IN_FUTURE'
371: , p_token_tbl => l_token_tbl
372: , p_mesg_token_tbl => l_mesg_token_tbl
373: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 385: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking open period ...'); END IF;

381:
382: --end of code as part of bug 5476770
383:
384:
385: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking open period ...'); END IF;
386: BEGIN
387: SELECT NVL(MIN(period_start_date), sysdate+1)
388: INTO l_open_acct_per_date
389: FROM org_acct_periods

Line 406: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

402: l_token_tbl(1).token_name := 'OP_SEQ_NO';
403: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
404:
405: l_out_mesg_token_tbl := l_mesg_token_tbl;
406: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
407: ( p_message_name => 'EAM_OP_TRANSACTION_DATE_INVALID'
408: , p_token_tbl => l_token_tbl
409: , p_mesg_token_tbl => l_mesg_token_tbl
410: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 419: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking reconciliation code ...'); END IF;

415: x_mesg_token_tbl := l_mesg_token_tbl ;
416: RETURN;
417: END;
418:
419: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking reconciliation code ...'); END IF;
420: BEGIN
421: IF p_eam_op_comp_rec.reconciliation_code IS NOT NULL THEN
422:
423: SELECT ml.lookup_code

Line 440: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

436: l_token_tbl(1).token_name := 'OP_SEQ_NO';
437: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
438:
439: l_out_mesg_token_tbl := l_mesg_token_tbl;
440: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
441: ( p_message_name => 'EAM_OP_RECONCILIATION_CODE'
442: , p_token_tbl => l_token_tbl
443: , p_mesg_token_tbl => l_mesg_token_tbl
444: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 462: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;

458: FROM wip_operations
459: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id
460: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
461:
462: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
463:
464: IF l_shutdown_type IS NOT NULL AND to_number(l_shutdown_type) = 2 THEN
465: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
466: raise fnd_api.g_exc_unexpected_error;

Line 479: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

475: l_token_tbl(1).token_name := 'OP_SEQ_NO';
476: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
477:
478: l_out_mesg_token_tbl := l_mesg_token_tbl;
479: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
480: ( p_message_name => 'EAM_OP_SHUTDOWN_DATE_MISS'
481: , p_token_tbl => l_token_tbl
482: , p_mesg_token_tbl => l_mesg_token_tbl
483: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 502: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;

498: l_prev_uncomplete := 0;
499: end if;
500: close CON1;
501:
502: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
503: IF l_prev_uncomplete > 0 THEN
504: raise fnd_api.g_exc_unexpected_error;
505: END IF;
506:

Line 517: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

513: --l_token_tbl(1).token_name := 'OP_SEQ_NO';
514: --l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
515:
516: l_out_mesg_token_tbl := l_mesg_token_tbl;
517: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
518: ( p_message_name => 'EAM_NEXT_OP_COMPLETED'
519: , p_token_tbl => l_token_tbl
520: , p_mesg_token_tbl => l_mesg_token_tbl
521: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 539: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;

535: if (CON%NOTFOUND) then
536: l_prev_uncomplete := 0;
537: end if;
538: close CON;
539: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
540:
541: IF l_prev_uncomplete > 0 THEN
542: raise fnd_api.g_exc_unexpected_error;
543: END IF;

Line 555: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

551: --l_token_tbl(1).token_name := 'OP_SEQ_NO';
552: --l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
553:
554: l_out_mesg_token_tbl := l_mesg_token_tbl;
555: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
556: ( p_message_name => 'EAM_PREV_OP_NOT_COMPLETED'
557: , p_token_tbl => l_token_tbl
558: , p_mesg_token_tbl => l_mesg_token_tbl
559: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 575: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;

571: SELECT status_type
572: INTO l_job_status
573: FROM wip_discrete_jobs
574: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
575: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
576:
577: IF (l_job_status = 4 ) THEN
578: raise fnd_api.g_exc_unexpected_error;
579: END IF;

Line 590: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

586: l_token_tbl(1).token_name := 'OP_SEQ_NO';
587: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
588:
589: l_out_mesg_token_tbl := l_mesg_token_tbl;
590: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
591: ( p_message_name => 'EAM_OP_COMP_WOCOMP_TEST'
592: , p_token_tbl => l_token_tbl
593: , p_mesg_token_tbl => l_mesg_token_tbl
594: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 609: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start date and max_prior_end_date ...'); END IF;

605: BEGIN
606: open CON3;
607: fetch CON3 into l_max_prior_end_date;
608: close CON3;
609: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start date and max_prior_end_date ...'); END IF;
610:
611: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
612: raise fnd_api.g_exc_unexpected_error;
613: end if;

Line 623: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

619: l_token_tbl(1).token_name := 'MIN_START_DATE';
620: l_token_tbl(1).token_value := TO_CHAR(l_max_prior_end_date,'dd-MON-yyyy HH24:MI:SS');
621:
622: l_out_mesg_token_tbl := l_mesg_token_tbl;
623: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
624: ( p_message_name => 'EAM_PRIOR_OP_COMPLETED_AFTER'
625: , p_token_tbl => l_token_tbl
626: , p_mesg_token_tbl => l_mesg_token_tbl
627: , x_mesg_token_tbl => l_out_mesg_token_tbl