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: --commented for bug 12843159
141: /*SELECT shutdown_type into l_shutdown_type
142: FROM wip_discrete_jobs

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

450: RETURN;
451: END;
452:
453:
454: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
455: BEGIN
456: SELECT shutdown_type
457: INTO l_shutdown_type
458: FROM wip_operations

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

489: RETURN;
490: END;
491: END IF;
492:
493: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
494: BEGIN
495: open CON1;
496: fetch CON1 into l_prev_uncomplete;
497: if (CON1%NOTFOUND) then

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

527: RETURN;
528: END;
529: END IF;
530:
531: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
532: BEGIN
533: open CON;
534: fetch CON into l_prev_uncomplete;
535: if (CON%NOTFOUND) then

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

565: RETURN;
566: END;
567: END IF;
568:
569: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
570: begin
571: SELECT status_type
572: INTO l_job_status
573: FROM wip_discrete_jobs

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

600: RETURN;
601: END;
602: END IF;
603:
604: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE THEN
605: BEGIN
606: open CON3;
607: fetch CON3 into l_max_prior_end_date;
608: close CON3;

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;