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 146: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : shutdown information ...'); END IF;

142: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
143:
144: IF l_shutdown_type IS NOT NULL THEN
145: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
146: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Op Comp : shutdown information ...'); END IF;
147:
148: l_token_tbl(1).token_name := 'OP_SEQ_NO';
149: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
150:

Line 152: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

148: l_token_tbl(1).token_name := 'OP_SEQ_NO';
149: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
150:
151: l_out_mesg_token_tbl := l_mesg_token_tbl;
152: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
153: ( p_message_name => 'EAM_OPCL_SHUTDOWN_REQUIRED'
154: , p_token_tbl => l_Token_tbl
155: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
156: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

169: PROCEDURE Check_Attributes
170: (
171: p_eam_op_comp_rec IN EAM_PROCESS_WO_PUB. eam_op_comp_rec_type
172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
174: )IS
175: l_err_text VARCHAR2(2000) := NULL;
176: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
177: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 176: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

172: , x_return_status OUT NOCOPY VARCHAR2
173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
174: )IS
175: l_err_text VARCHAR2(2000) := NULL;
176: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
177: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
179: l_open_acct_per_date DATE;
180: l_reconciliation_code VARCHAR2(30);

Line 177: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

173: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
174: )IS
175: l_err_text VARCHAR2(2000) := NULL;
176: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
177: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
179: l_open_acct_per_date DATE;
180: l_reconciliation_code VARCHAR2(30);
181: l_prev_uncomplete NUMBER := 0;

Line 178: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

174: )IS
175: l_err_text VARCHAR2(2000) := NULL;
176: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
177: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
178: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
179: l_open_acct_per_date DATE;
180: l_reconciliation_code VARCHAR2(30);
181: l_prev_uncomplete NUMBER := 0;
182: l_prev_completed_after NUMBER := 0;

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

228: );
229:
230: BEGIN
231:
232: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;

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

232: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
237: BEGIN
238: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
239: raise fnd_api.g_exc_unexpected_error;
240: END IF;

Line 250: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

246: l_token_tbl(1).token_name := 'OP_SEQ_NO';
247: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
248:
249: l_out_mesg_token_tbl := l_mesg_token_tbl;
250: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
251: ( p_message_name => 'EAM_OPCMPL_DATE_BAD'
252: , p_token_tbl => l_token_tbl
253: , p_mesg_token_tbl => l_mesg_token_tbl
254: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

260: RETURN;
261: END;
262:
263: BEGIN
264: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
265: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
266: raise fnd_api.g_exc_unexpected_error;
267: END IF;
268:

Line 277: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

273: l_token_tbl(1).token_name := 'OP_SEQ_NO';
274: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
275:
276: l_out_mesg_token_tbl := l_mesg_token_tbl;
277: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
278: ( p_message_name => 'EAM_OP_SHUTDOWN_DATE_BAD'
279: , p_token_tbl => l_token_tbl
280: , p_mesg_token_tbl => l_mesg_token_tbl
281: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

286: x_mesg_token_tbl := l_mesg_token_tbl ;
287: RETURN;
288: END;
289:
290: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual duration ...'); END IF;
291: BEGIN
292: IF p_eam_op_comp_rec.actual_duration < 0 THEN
293: raise fnd_api.g_exc_unexpected_error;
294: END IF;

Line 304: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

300: l_token_tbl(1).token_name := 'OP_SEQ_NO';
301: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
302:
303: l_out_mesg_token_tbl := l_mesg_token_tbl;
304: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
305: ( p_message_name => 'EAM_OP_COMP_DURATION_BAD'
306: , p_token_tbl => l_token_tbl
307: , p_mesg_token_tbl => l_mesg_token_tbl
308: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

313: x_mesg_token_tbl := l_mesg_token_tbl ;
314: RETURN;
315: END;
316:
317: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual end date ...'); END IF;
318: BEGIN
319: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
320: raise fnd_api.g_exc_unexpected_error;
321: END IF;

Line 332: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

328: l_token_tbl(1).token_name := 'OP_SEQ_NO';
329: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
330:
331: l_out_mesg_token_tbl := l_mesg_token_tbl;
332: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
333: ( p_message_name => 'EAM_OP_END_LATER_THAN_TODAY'
334: , p_token_tbl => l_token_tbl
335: , p_mesg_token_tbl => l_mesg_token_tbl
336: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 360: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

356: l_token_tbl(1).token_name := 'OP_SEQ_NO';
357: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
358:
359: l_out_mesg_token_tbl := l_mesg_token_tbl;
360: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
361: ( p_message_name => 'EAM_SHUTDOWN_DATE_IN_FUTURE'
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

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

372:
373: --end of code as part of bug 5476770
374:
375:
376: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking open period ...'); END IF;
377: BEGIN
378: SELECT NVL(MIN(period_start_date), sysdate+1)
379: INTO l_open_acct_per_date
380: FROM org_acct_periods

Line 397: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

393: l_token_tbl(1).token_name := 'OP_SEQ_NO';
394: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
395:
396: l_out_mesg_token_tbl := l_mesg_token_tbl;
397: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
398: ( p_message_name => 'EAM_OP_TRANSACTION_DATE_INVALID'
399: , p_token_tbl => l_token_tbl
400: , p_mesg_token_tbl => l_mesg_token_tbl
401: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

406: x_mesg_token_tbl := l_mesg_token_tbl ;
407: RETURN;
408: END;
409:
410: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking reconciliation code ...'); END IF;
411: BEGIN
412: IF p_eam_op_comp_rec.reconciliation_code IS NOT NULL THEN
413:
414: SELECT ml.lookup_code

Line 431: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

427: l_token_tbl(1).token_name := 'OP_SEQ_NO';
428: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
429:
430: l_out_mesg_token_tbl := l_mesg_token_tbl;
431: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
432: ( p_message_name => 'EAM_OP_RECONCILIATION_CODE'
433: , p_token_tbl => l_token_tbl
434: , p_mesg_token_tbl => l_mesg_token_tbl
435: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

449: FROM wip_operations
450: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id
451: AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;
452:
453: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
454:
455: IF l_shutdown_type IS NOT NULL AND to_number(l_shutdown_type) = 2 THEN
456: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
457: raise fnd_api.g_exc_unexpected_error;

Line 470: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

466: l_token_tbl(1).token_name := 'OP_SEQ_NO';
467: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
468:
469: l_out_mesg_token_tbl := l_mesg_token_tbl;
470: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
471: ( p_message_name => 'EAM_OP_SHUTDOWN_DATE_MISS'
472: , p_token_tbl => l_token_tbl
473: , p_mesg_token_tbl => l_mesg_token_tbl
474: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

489: l_prev_uncomplete := 0;
490: end if;
491: close CON1;
492:
493: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
494: IF l_prev_uncomplete > 0 THEN
495: raise fnd_api.g_exc_unexpected_error;
496: END IF;
497:

Line 508: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

504: --l_token_tbl(1).token_name := 'OP_SEQ_NO';
505: --l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
506:
507: l_out_mesg_token_tbl := l_mesg_token_tbl;
508: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
509: ( p_message_name => 'EAM_NEXT_OP_COMPLETED'
510: , p_token_tbl => l_token_tbl
511: , p_mesg_token_tbl => l_mesg_token_tbl
512: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

526: if (CON%NOTFOUND) then
527: l_prev_uncomplete := 0;
528: end if;
529: close CON;
530: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
531:
532: IF l_prev_uncomplete > 0 THEN
533: raise fnd_api.g_exc_unexpected_error;
534: END IF;

Line 546: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

542: --l_token_tbl(1).token_name := 'OP_SEQ_NO';
543: --l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
544:
545: l_out_mesg_token_tbl := l_mesg_token_tbl;
546: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
547: ( p_message_name => 'EAM_PREV_OP_NOT_COMPLETED'
548: , p_token_tbl => l_token_tbl
549: , p_mesg_token_tbl => l_mesg_token_tbl
550: , x_mesg_token_tbl => l_out_mesg_token_tbl

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

562: SELECT status_type
563: INTO l_job_status
564: FROM wip_discrete_jobs
565: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
566: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
567:
568: IF (l_job_status = 4 ) THEN
569: raise fnd_api.g_exc_unexpected_error;
570: END IF;

Line 581: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

577: l_token_tbl(1).token_name := 'OP_SEQ_NO';
578: l_token_tbl(1).token_value := p_eam_op_comp_rec.operation_seq_num;
579:
580: l_out_mesg_token_tbl := l_mesg_token_tbl;
581: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
582: ( p_message_name => 'EAM_OP_COMP_WOCOMP_TEST'
583: , p_token_tbl => l_token_tbl
584: , p_mesg_token_tbl => l_mesg_token_tbl
585: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 600: 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;

596: BEGIN
597: open CON3;
598: fetch CON3 into l_max_prior_end_date;
599: close CON3;
600: 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;
601:
602: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
603: raise fnd_api.g_exc_unexpected_error;
604: end if;

Line 614: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

610: l_token_tbl(1).token_name := 'MIN_START_DATE';
611: l_token_tbl(1).token_value := TO_CHAR(l_max_prior_end_date,'dd-MON-yyyy HH24:MI:SS');
612:
613: l_out_mesg_token_tbl := l_mesg_token_tbl;
614: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
615: ( p_message_name => 'EAM_PRIOR_OP_COMPLETED_AFTER'
616: , p_token_tbl => l_token_tbl
617: , p_mesg_token_tbl => l_mesg_token_tbl
618: , x_mesg_token_tbl => l_out_mesg_token_tbl