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_WO_DEFAULT_PVT dependencies on EAM_PROCESS_WO_PVT

Line 280: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new wip_entity_id : ' || to_char(x_eam_wo_rec.wip_entity_id)); END IF;

276: p_eam_wo_rec.wip_entity_id = FND_API.G_MISS_NUM
277: THEN
278: x_eam_wo_rec.wip_entity_id :=get_wip_entity_id;
279:
280: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new wip_entity_id : ' || to_char(x_eam_wo_rec.wip_entity_id)); END IF;
281:
282: END IF;
283:
284: IF p_eam_wo_rec.wip_entity_name IS NULL OR

Line 291: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new wip_entity_name : ' || x_eam_wo_rec.wip_entity_name); END IF;

287: x_eam_wo_rec.wip_entity_name := get_wip_entity_name(p_eam_wo_rec.organization_id,p_eam_wo_rec.plan_maintenance);
288:
289:
290:
291: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new wip_entity_name : ' || x_eam_wo_rec.wip_entity_name); END IF;
292:
293: END IF;
294:
295: -- Finding out whether Asset or Rebuild WO

Line 308: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

304: END IF;
305: END IF;
306:
307:
308: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
309: AND p_eam_wo_rec.class_code is null )
310: THEN
311: WIP_EAM_UTILS.DEFAULT_ACC_CLASS(
312: p_org_id => p_eam_wo_rec.organization_id,

Line 331: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new class_code : ' || x_eam_wo_rec.class_code); END IF;

327: THEN
328: -- Default the WIP ACC Class
329: x_eam_wo_rec.class_code := l_class_code;
330:
331: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new class_code : ' || x_eam_wo_rec.class_code); END IF;
332: END IF;
333:
334: END IF;
335:

Line 341: and p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE )

337:
338: /* Defaulting logic of work order description from activity description for bug# 3418828 */
339:
340: IF ( p_eam_wo_rec.description IS NULL
341: and p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE )
342: THEN
343: begin
344: SELECT description
345: INTO l_activity_description

Line 362: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /*OR

358: END IF;
359:
360: /* end of fix */
361:
362: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /*OR
363: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
364: NVL(p_eam_wo_rec.asset_activity_id,-1) <> NVL(l_old_eam_wo_rec.asset_activity_id,-1)) commented for BUG#5609642 */ ) THEN --default if new workorder or activity is changed
365:
366: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default

Line 363: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND

359:
360: /* end of fix */
361:
362: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /*OR
363: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
364: NVL(p_eam_wo_rec.asset_activity_id,-1) <> NVL(l_old_eam_wo_rec.asset_activity_id,-1)) commented for BUG#5609642 */ ) THEN --default if new workorder or activity is changed
365:
366: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default
367: (p_api_version => 1,

Line 388: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_cause : ' || x_eam_wo_rec.activity_cause); END IF;

384: p_eam_wo_rec.activity_cause IS NULL /* Added for BUG#5609642 */
385: THEN
386: x_eam_wo_rec.activity_cause := l_activity_cause;
387:
388: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_cause : ' || x_eam_wo_rec.activity_cause); END IF;
389: END IF;
390:
391: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Type_Default
392: (p_api_version => 1,

Line 412: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_type : ' || x_eam_wo_rec.activity_type); END IF;

408: l_activity_type <> FND_API.G_MISS_CHAR AND
409: p_eam_wo_rec.activity_source IS NULL /* Added for BUG#5609642 */
410: THEN
411: x_eam_wo_rec.activity_type := l_activity_type;
412: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_type : ' || x_eam_wo_rec.activity_type); END IF;
413: END IF;
414:
415: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Source_Default
416: (p_api_version => 1,

Line 436: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_source : ' || x_eam_wo_rec.activity_source); END IF;

432: l_activity_source <> FND_API.G_MISS_CHAR AND
433: p_eam_wo_rec.activity_source IS NULL /* Added for BUG#5609642 */
434: THEN
435: x_eam_wo_rec.activity_source := l_activity_source;
436: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new activity_source : ' || x_eam_wo_rec.activity_source); END IF;
437: END IF;
438:
439: WIP_EAMWORKORDER_PVT.Get_EAM_Shutdown_Default
440: (p_api_version => 1,

Line 460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new shutdown_type : ' || x_eam_wo_rec.shutdown_type); END IF;

456: l_shutdown_type <> FND_API.G_MISS_CHAR AND
457: p_eam_wo_rec.shutdown_type IS NULL /* Added for BUG#5609642 */
458: THEN
459: x_eam_wo_rec.shutdown_type := l_shutdown_type;
460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new shutdown_type : ' || x_eam_wo_rec.shutdown_type); END IF;
461: END IF;
462:
463: WIP_EAMWORKORDER_PVT.Get_EAM_Notification_Default
464: (p_api_version => 1,

Line 484: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new notification_required : ' || x_eam_wo_rec.notification_required); END IF;

480: l_notification_required <> FND_API.G_MISS_CHAR AND
481: p_eam_wo_rec.notification_required IS NULL /* Added for BUG#5609642 */
482: THEN
483: x_eam_wo_rec.notification_required := l_notification_required;
484: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new notification_required : ' || x_eam_wo_rec.notification_required); END IF;
485: END IF;
486:
487: WIP_EAMWORKORDER_PVT.Get_EAM_Tagout_Default
488: (p_api_version => 1,

Line 508: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new tagout_default : ' || x_eam_wo_rec.tagout_required); END IF;

504: l_tagout_required <> FND_API.G_MISS_CHAR AND
505: p_eam_wo_rec.tagout_required IS NULL /* Added for BUG#5609642 */
506: THEN
507: x_eam_wo_rec.tagout_required := l_tagout_required;
508: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('new tagout_default : ' || x_eam_wo_rec.tagout_required); END IF;
509: END IF;
510: END IF; --end of check for activity changed or workorder created
511: END IF; -- End if for 'IF asset_activity_id_id is not null'
512:

Line 515: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting owning department, priority, etc'); END IF;

511: END IF; -- End if for 'IF asset_activity_id_id is not null'
512:
513:
514:
515: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting owning department, priority, etc'); END IF;
516:
517: -- Defaulting Owning Dept, Priority.
518:
519: IF p_eam_wo_rec.asset_activity_id IS NOT NULL AND p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM

Line 523: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR

519: IF p_eam_wo_rec.asset_activity_id IS NOT NULL AND p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM
520: THEN
521: -- WO with Activity
522:
523: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR
524: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
525: NVL(p_eam_wo_rec.asset_activity_id,-1) <> NVL(l_old_eam_wo_rec.asset_activity_id,-1))Commented for BUG#5609642 */ ) THEN --default if new workorder or activity is changed
526: BEGIN
527:

Line 524: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND

520: THEN
521: -- WO with Activity
522:
523: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR
524: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
525: NVL(p_eam_wo_rec.asset_activity_id,-1) <> NVL(l_old_eam_wo_rec.asset_activity_id,-1))Commented for BUG#5609642 */ ) THEN --default if new workorder or activity is changed
526: BEGIN
527:
528: IF p_eam_wo_rec.maintenance_object_type = 3

Line 683: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting accounts'); END IF;

679: END IF;
680: END IF;
681:
682:
683: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting accounts'); END IF;
684:
685:
686: -- Defaulting Accounts
687: BEGIN

Line 750: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;

746: );
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: END;
750: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;
751:
752: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;
753:
754: --Default the User_Defined_Status_Id if it is not passed when creating a workorder. OR if system status is modified and neither the user_defined_status nor the pending flag are modfied

Line 752: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;

748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: END;
750: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;
751:
752: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting USER_DEFINED_STATUS_ID'); END IF;
753:
754: --Default the User_Defined_Status_Id if it is not passed when creating a workorder. OR if system status is modified and neither the user_defined_status nor the pending flag are modfied
755: --Then also set the User_defined_status to the seeded status mapped to the System status
756: IF( p_eam_wo_rec.user_defined_status_id IS NULL --create and user_defined_staus not provided

Line 758: ( p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UPDATE --workorder updated

754: --Default the User_Defined_Status_Id if it is not passed when creating a workorder. OR if system status is modified and neither the user_defined_status nor the pending flag are modfied
755: --Then also set the User_defined_status to the seeded status mapped to the System status
756: IF( p_eam_wo_rec.user_defined_status_id IS NULL --create and user_defined_staus not provided
757: OR
758: ( p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UPDATE --workorder updated
759: AND (p_eam_wo_rec.status_type <> p_old_eam_wo_rec.status_type) --system status updated
760: --netiher the user_defined_status nor the pending flag are modfied
761: AND NOT((p_eam_wo_rec.user_defined_status_id <> p_old_eam_wo_rec.user_defined_status_id) OR (NVL(p_eam_wo_rec.pending_flag,'N') <> NVL(p_old_eam_wo_rec.pending_flag,'N')))
762: )

Line 768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting ISSUE_ZERO_COST_FLAG'); END IF;

764: x_eam_wo_rec.user_defined_status_id := p_eam_wo_rec.status_type; --set the user_defined_status_id to status_type since status_id for seeded statuses will be same as status_type
765:
766: END IF; --end of check for defaulting user_defined_status
767:
768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting ISSUE_ZERO_COST_FLAG'); END IF;
769:
770: -- Defaulting ISSUE_ZERO_COST_FLAG
771: IF p_eam_wo_rec.issue_zero_cost_flag IS NULL OR
772: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR

Line 782: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('PO creation time'); END IF;

778: WHERE organization_id = p_eam_wo_rec.organization_id;
779:
780: END IF;
781:
782: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('PO creation time'); END IF;
783:
784: -- Defaulting PO creation time
785: IF p_eam_wo_rec.po_creation_time IS NULL OR
786: p_eam_wo_rec.po_creation_time = FND_API.G_MISS_NUM

Line 796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting firm planned flag'); END IF;

792: WHERE organization_id = p_eam_wo_rec.organization_id;
793:
794: END IF;
795:
796: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting firm planned flag'); END IF;
797:
798: -- Defaulting Firm Planned Flag
799:
800: IF p_eam_wo_rec.firm_planned_flag IS NULL OR

Line 866: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting scheduled start date and completion date from the PM Suggested Dates'); END IF;

862:
863: END IF;
864:
865:
866: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting scheduled start date and completion date from the PM Suggested Dates'); END IF;
867:
868: -- Defaulting Scheduled Dates from the PM Suggested Dates
869:
870: IF (p_eam_wo_rec.pm_suggested_start_date IS NOT NULL AND

Line 880: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting scheduled start date and completion date'); END IF;

876: x_eam_wo_rec.due_date := p_eam_wo_rec.pm_suggested_end_date;
877:
878: END IF;
879:
880: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting scheduled start date and completion date'); END IF;
881:
882:
883: -- Defaulting Requested Start Date
884:

Line 896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting material_issue_by_mo flag'); END IF;

892: x_eam_wo_rec.requested_start_date := p_eam_wo_rec.scheduled_start_date;
893:
894: END IF;
895:
896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Defaulting material_issue_by_mo flag'); END IF;
897:
898: -- Defaulting the MATERIAL_ISSUE_BY_MO flag
899:
900: IF p_eam_wo_rec.material_issue_by_mo IS NULL OR

Line 1042: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;

1038: BEGIN
1039: x_eam_wo_rec := p_eam_wo_rec;
1040: x_eam_wo_rec := p_eam_wo_rec;
1041:
1042: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
1043:
1044:
1045: IF p_eam_wo_rec.wip_entity_name IS NULL OR
1046: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR

Line 1730: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Done processing null columns prior update'); END IF;

1726: x_eam_wo_rec.failure_code_required := 'N'; -- As NULL Is same as 'N'
1727: END IF;
1728:
1729:
1730: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Done processing null columns prior update'); END IF;
1731:
1732: END Populate_Null_Columns;
1733:
1734: END EAM_WO_DEFAULT_PVT;