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_PROCESS_WO_PVT

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 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 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 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 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 138: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE

134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
136: END IF;
137:
138: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE
139: THEN
140: SELECT shutdown_type into l_shutdown_type
141: FROM wip_discrete_jobs
142: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;

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 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 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 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 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 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 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 445: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

441: RETURN;
442: END;
443:
444:
445: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
446: BEGIN
447: SELECT shutdown_type
448: INTO l_shutdown_type
449: FROM wip_operations

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 484: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN

480: RETURN;
481: END;
482: END IF;
483:
484: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
485: BEGIN
486: open CON1;
487: fetch CON1 into l_prev_uncomplete;
488: if (CON1%NOTFOUND) then

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 522: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

518: RETURN;
519: END;
520: END IF;
521:
522: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
523: BEGIN
524: open CON;
525: fetch CON into l_prev_uncomplete;
526: if (CON%NOTFOUND) then

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 560: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN

556: RETURN;
557: END;
558: END IF;
559:
560: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
561: begin
562: SELECT status_type
563: INTO l_job_status
564: FROM wip_discrete_jobs

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 595: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN

591: RETURN;
592: END;
593: END IF;
594:
595: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
596: BEGIN
597: open CON3;
598: fetch CON3 into l_max_prior_end_date;
599: close CON3;

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;