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 39: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_id : Start ================'); END IF;

35: IS
36: l_wip_entity_id NUMBER := NULL;
37: BEGIN
38:
39: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_id : Start ================'); END IF;
40:
41: SELECT wip_entities_s.nextval
42: INTO l_wip_entity_id
43: FROM dual;

Line 45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_id : End wip_entity_id: '||l_wip_entity_id||' ================'); END IF;

41: SELECT wip_entities_s.nextval
42: INTO l_wip_entity_id
43: FROM dual;
44:
45: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_id : End wip_entity_id: '||l_wip_entity_id||' ================'); END IF;
46:
47: RETURN l_wip_entity_id;
48:
49: EXCEPTION

Line 72: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : Start ================'); END IF;

68: IS
69: l_wip_entity_name_prefix VARCHAR2(30) := NULL;
70: BEGIN
71:
72: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : Start ================'); END IF;
73:
74: SELECT work_order_prefix
75: INTO l_wip_entity_name_prefix
76: FROM wip_eam_parameters

Line 79: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : End wip_entity_name prefix: '||l_wip_entity_name_prefix||' =============='); END IF;

75: INTO l_wip_entity_name_prefix
76: FROM wip_eam_parameters
77: WHERE organization_id = p_organization_id;
78:
79: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : End wip_entity_name prefix: '||l_wip_entity_name_prefix||' =============='); END IF;
80:
81: RETURN l_wip_entity_name_prefix;
82:
83: EXCEPTION

Line 104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_pm_wip_entity_prefix : Start ================'); END IF;

100: RETURN VARCHAR2
101: IS
102: l_pm_wip_entity_prefix VARCHAR2(30) := NULL;
103: BEGIN
104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_pm_wip_entity_prefix : Start ================'); END IF;
105:
106: SELECT PM_WORK_ORDER_PREFIX
107: INTO l_pm_wip_entity_prefix
108: FROM wip_eam_parameters

Line 113: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_pm_wip_entity_prefix : End PM_wip_entity_name prefix: '||l_pm_wip_entity_prefix||' =============='); END IF;

109: WHERE organization_id = p_organization_id;
110:
111: --l_pm_wip_entity_prefix := 'PM_PREFIX';
112:
113: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_pm_wip_entity_prefix : End PM_wip_entity_name prefix: '||l_pm_wip_entity_prefix||' =============='); END IF;
114:
115: RETURN l_pm_wip_entity_prefix;
116:
117: EXCEPTION

Line 138: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name: Start =============='); END IF;

134: l_wip_entity_name VARCHAR2(240) := NULL;
135: l_wip_entity_count NUMBER :=0;
136: l_wip_entity_name_prefix VARCHAR2(30) := NULL;
137: BEGIN
138: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name: Start =============='); END IF;
139:
140: -- ER 11884444
141: -- PM Work Order prefix for WO generation
142: IF nvl(p_plan_maintenance,'N') <> 'Y' THEN

Line 170: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name: End l_wip_entity_name : '||l_wip_entity_name ||' =============='); END IF;

166:
167: EXIT WHEN l_wip_entity_count=0;
168: END LOOP;
169:
170: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name: End l_wip_entity_name : '||l_wip_entity_name ||' =============='); END IF;
171:
172: RETURN l_wip_entity_name;
173: EXCEPTION
174: WHEN OTHERS THEN

Line 193: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_flex_eam_wo: Start =============='); END IF;

189: )
190: IS
191: BEGIN
192:
193: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_flex_eam_wo: Start =============='); END IF;
194:
195: -- In the future call Flex APIs for defaults
196: x_eam_wo_rec := p_eam_wo_rec;
197:

Line 262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_flex_eam_wo: End =============='); END IF;

258: IF p_eam_wo_rec.attribute15 = FND_API.G_MISS_CHAR THEN
259: x_eam_wo_rec.attribute15 := NULL;
260: END IF;
261:
262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_flex_eam_wo: End =============='); END IF;
263:
264: END get_flex_eam_wo;
265:
266:

Line 329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

325: l_firm_flag NUMBER;
326: l_plan_maintenance VARCHAR2(1);
327:
328: BEGIN
329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
330: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Start================');
331: END IF;
332:
333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

329: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
330: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Start================');
331: END IF;
332:
333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
334: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Calling EAM_WO_UTILITY_PVT.Query_Row');
335: END IF;
336:
337: EAM_WO_UTILITY_PVT.Query_Row(

Line 353: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New wip_entity_id : ' || to_char(x_eam_wo_rec.wip_entity_id)); END IF;

349: p_eam_wo_rec.wip_entity_id = FND_API.G_MISS_NUM
350: THEN
351: x_eam_wo_rec.wip_entity_id :=get_wip_entity_id;
352:
353: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New wip_entity_id : ' || to_char(x_eam_wo_rec.wip_entity_id)); END IF;
354:
355: END IF;
356:
357: IF p_eam_wo_rec.wip_entity_name IS NULL OR

Line 364: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New wip_entity_name : ' || x_eam_wo_rec.wip_entity_name); END IF;

360: x_eam_wo_rec.wip_entity_name := get_wip_entity_name(p_eam_wo_rec.organization_id,p_eam_wo_rec.plan_maintenance,p_eam_wo_rec.source_code);
361:
362:
363:
364: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New wip_entity_name : ' || x_eam_wo_rec.wip_entity_name); END IF;
365:
366: END IF;
367:
368: -- Finding out whether Asset or Rebuild WO

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

377: END IF;
378: END IF;
379:
380:
381: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
382: AND p_eam_wo_rec.class_code is null )
383: THEN
384: WIP_EAM_UTILS.DEFAULT_ACC_CLASS(
385: p_org_id => p_eam_wo_rec.organization_id,

Line 404: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New class_code : ' || x_eam_wo_rec.class_code); END IF;

400: THEN
401: -- Default the WIP ACC Class
402: x_eam_wo_rec.class_code := l_class_code;
403:
404: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New class_code : ' || x_eam_wo_rec.class_code); END IF;
405: END IF;
406:
407: END IF;
408:

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

410:
411: /* Defaulting logic of work order description from activity description for bug# 3418828 */
412:
413: IF ( p_eam_wo_rec.description IS NULL
414: and p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE )
415: THEN
416: begin
417: SELECT description
418: INTO l_activity_description

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

431: END IF;
432:
433: /* end of fix */
434:
435: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /*OR
436: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
437: 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
438:
439: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default

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

432:
433: /* end of fix */
434:
435: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /*OR
436: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
437: 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
438:
439: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Cause_Default
440: (p_api_version => 1,

Line 461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_cause : ' || x_eam_wo_rec.activity_cause); END IF;

457: p_eam_wo_rec.activity_cause IS NULL /* Added for BUG#5609642 */
458: THEN
459: x_eam_wo_rec.activity_cause := l_activity_cause;
460:
461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_cause : ' || x_eam_wo_rec.activity_cause); END IF;
462: END IF;
463:
464: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Type_Default
465: (p_api_version => 1,

Line 485: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_type : ' || x_eam_wo_rec.activity_type); END IF;

481: l_activity_type <> FND_API.G_MISS_CHAR AND
482: p_eam_wo_rec.activity_type IS NULL /* Added for BUG#5609642 */
483: THEN
484: x_eam_wo_rec.activity_type := l_activity_type;
485: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_type : ' || x_eam_wo_rec.activity_type); END IF;
486: END IF;
487:
488: WIP_EAMWORKORDER_PVT.Get_EAM_Act_Source_Default
489: (p_api_version => 1,

Line 510: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_source : ' || x_eam_wo_rec.activity_source); END IF;

506: p_eam_wo_rec.activity_source IS NULL /* Added for BUG#5609642 */
507: THEN
508: x_eam_wo_rec.activity_source := l_activity_source;
509:
510: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New activity_source : ' || x_eam_wo_rec.activity_source); END IF;
511: END IF;
512:
513: WIP_EAMWORKORDER_PVT.Get_EAM_Shutdown_Default
514: (p_api_version => 1,

Line 534: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

530: l_shutdown_type <> FND_API.G_MISS_CHAR AND
531: p_eam_wo_rec.shutdown_type IS NULL /* Added for BUG#5609642 */
532: THEN
533: x_eam_wo_rec.shutdown_type := l_shutdown_type;
534: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
535: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New shutdown_type : ' || x_eam_wo_rec.shutdown_type);
536: END IF;
537: END IF;
538:

Line 560: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

556: l_notification_required <> FND_API.G_MISS_CHAR AND
557: p_eam_wo_rec.notification_required IS NULL /* Added for BUG#5609642 */
558: THEN
559: x_eam_wo_rec.notification_required := l_notification_required;
560: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
561: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New notification_required : ' || x_eam_wo_rec.notification_required);
562: END IF;
563: END IF;
564:

Line 586: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

582: l_tagout_required <> FND_API.G_MISS_CHAR AND
583: p_eam_wo_rec.tagout_required IS NULL /* Added for BUG#5609642 */
584: THEN
585: x_eam_wo_rec.tagout_required := l_tagout_required;
586: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
587: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New tagout_default : ' || x_eam_wo_rec.tagout_required);
588: END IF;
589: END IF;
590: /*WO Defaults ER 16094794*/

Line 613: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

609: l_work_order_type <> FND_API.G_MISS_NUM AND
610: p_eam_wo_rec.work_order_type IS NULL
611: THEN
612: x_eam_wo_rec.work_order_type := l_work_order_type;
613: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
614: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New work_order_type : ' || x_eam_wo_rec.work_order_type);
615: END IF;
616: END IF;
617:

Line 639: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

635: l_planner_maintenance <> FND_API.G_MISS_NUM AND
636: p_eam_wo_rec.PLANNER_TYPE IS NULL
637: THEN
638: x_eam_wo_rec.PLANNER_TYPE := l_planner_maintenance;
639: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
640: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New PLANNER_TYPE : ' || x_eam_wo_rec.PLANNER_TYPE);
641: END IF;
642: END IF;
643:

Line 665: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

661: l_firm_flag <> FND_API.G_MISS_NUM AND
662: p_eam_wo_rec.FIRM_PLANNED_FLAG IS NULL
663: THEN
664: x_eam_wo_rec.FIRM_PLANNED_FLAG := l_firm_flag;
665: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
666: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New firm_flag : ' || x_eam_wo_rec.firm_planned_flag);
667: END IF;
668: END IF;
669:

Line 692: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

688: l_plan_maintenance <> FND_API.G_MISS_CHAR AND
689: p_eam_wo_rec.PLAN_MAINTENANCE IS NULL
690: THEN
691: x_eam_wo_rec.PLAN_MAINTENANCE := l_plan_maintenance;
692: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
693: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New PLAN_MAINTENANCE : ' || x_eam_wo_rec.PLAN_MAINTENANCE);
694: END IF;
695: END IF;
696:

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

701: END IF; -- End if for 'IF asset_activity_id_id is not null'
702:
703:
704:
705: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting owning department, priority, etc'); END IF;
706:
707: -- Defaulting Owning Dept, Priority.
708:
709: 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 713: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR

709: IF p_eam_wo_rec.asset_activity_id IS NOT NULL AND p_eam_wo_rec.asset_activity_id <> FND_API.G_MISS_NUM
710: THEN
711: -- WO with Activity
712:
713: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR
714: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
715: 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
716: BEGIN
717:

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

710: THEN
711: -- WO with Activity
712:
713: IF ( p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE /* OR
714: (p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND
715: 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
716: BEGIN
717:
718: IF p_eam_wo_rec.maintenance_object_type = 3

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

918: -- end bug 15984843
919: END IF;
920:
921:
922: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting accounts'); END IF;
923:
924:
925: -- Defaulting Accounts
926: BEGIN

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

985: );
986:
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: END;
989: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting USER_DEFINED_STATUS_ID'); END IF;
990:
991:
992: --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
993: --Then also set the User_defined_status to the seeded status mapped to the System status

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

992: --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
993: --Then also set the User_defined_status to the seeded status mapped to the System status
994: IF( p_eam_wo_rec.user_defined_status_id IS NULL --create and user_defined_staus not provided
995: OR
996: ( p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UPDATE --workorder updated
997: AND (p_eam_wo_rec.status_type <> p_old_eam_wo_rec.status_type) --system status updated
998: --netiher the user_defined_status nor the pending flag are modfied
999: 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')))
1000: )

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

1002: 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
1003:
1004: END IF; --end of check for defaulting user_defined_status
1005:
1006: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting ISSUE_ZERO_COST_FLAG'); END IF;
1007:
1008: -- Defaulting ISSUE_ZERO_COST_FLAG
1009: IF p_eam_wo_rec.issue_zero_cost_flag IS NULL OR
1010: p_eam_wo_rec.issue_zero_cost_flag = FND_API.G_MISS_CHAR

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

1016: WHERE organization_id = p_eam_wo_rec.organization_id;
1017:
1018: END IF;
1019:
1020: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : PO creation time'); END IF;
1021:
1022: -- Defaulting PO creation time
1023: IF p_eam_wo_rec.po_creation_time IS NULL OR
1024: p_eam_wo_rec.po_creation_time = FND_API.G_MISS_NUM

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

1030: WHERE organization_id = p_eam_wo_rec.organization_id;
1031:
1032: END IF;
1033:
1034: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting firm planned flag'); END IF;
1035:
1036: -- Defaulting Firm Planned Flag
1037: /*after WO defaults ER: firm flag defaults from activity assoc defaults: WIP_EAMWORKORDER_PVT.Get_EAM_ACT_Firm_Default
1038: and this takes precedence hence added below x_eam_wo_rec.firm_planned_flag null check */

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

1106:
1107: END IF;
1108:
1109:
1110: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting scheduled start date and completion date from the PM Suggested Dates'); END IF;
1111:
1112: -- Defaulting Scheduled Dates from the PM Suggested Dates
1113:
1114: IF (p_eam_wo_rec.pm_suggested_start_date IS NOT NULL AND

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

1120: x_eam_wo_rec.due_date := p_eam_wo_rec.pm_suggested_end_date;
1121:
1122: END IF;
1123:
1124: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting scheduled start date and completion date'); END IF;
1125:
1126:
1127: -- Defaulting Requested Start Date
1128:

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

1136: x_eam_wo_rec.requested_start_date := p_eam_wo_rec.scheduled_start_date;
1137:
1138: END IF;
1139:
1140: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Defaulting material_issue_by_mo flag'); END IF;
1141:
1142: -- Defaulting the MATERIAL_ISSUE_BY_MO flag
1143:
1144: IF p_eam_wo_rec.material_issue_by_mo IS NULL OR

Line 1181: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1177:
1178:
1179: l_out_eam_wo_rec := x_eam_wo_rec;
1180:
1181: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1182: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting :Calling get_flex_eam_wo');
1183: END IF;
1184:
1185: get_flex_eam_wo

Line 1191: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1187: , x_eam_wo_rec => l_out_eam_wo_rec
1188: );
1189: x_eam_wo_rec := l_out_eam_wo_rec;
1190:
1191: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1192: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : End================');
1193: END IF;
1194:
1195: EXCEPTION

Line 1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1219: l_inventory_item_id number;
1220: l_eam_item_type number;
1221:
1222: BEGIN
1223: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1224: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Conditional_Defaulting : Start================');
1225: END IF;
1226:
1227: x_eam_wo_rec := p_eam_wo_rec;

Line 1262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1258: and rownum = 1;
1259:
1260: end if;
1261:
1262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1263: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Conditional_Defaulting : End================');
1264: END IF;
1265:
1266: EXCEPTION

Line 1298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1294: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1295: )
1296: IS
1297: BEGIN
1298: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1299: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Populate_Null_Columns : Start================');
1300: END IF;
1301:
1302: x_eam_wo_rec := p_eam_wo_rec;

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

1301:
1302: x_eam_wo_rec := p_eam_wo_rec;
1303: x_eam_wo_rec := p_eam_wo_rec;
1304:
1305: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
1306:
1307:
1308: IF p_eam_wo_rec.wip_entity_name IS NULL OR
1309: p_eam_wo_rec.wip_entity_name = FND_API.G_MISS_CHAR

Line 2004: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('DEAM_WO_DEFAULT_PVT.Populate_Null_Columns : one processing null columns prior update'); END IF;

2000: x_eam_wo_rec.failure_code_required := 'N'; -- As NULL Is same as 'N'
2001: END IF;
2002:
2003:
2004: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('DEAM_WO_DEFAULT_PVT.Populate_Null_Columns : one processing null columns prior update'); END IF;
2005:
2006: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
2007: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Populate_Null_Columns : End================');
2008: END IF;

Line 2006: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

2002:
2003:
2004: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('DEAM_WO_DEFAULT_PVT.Populate_Null_Columns : one processing null columns prior update'); END IF;
2005:
2006: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
2007: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Populate_Null_Columns : End================');
2008: END IF;
2009:
2010: