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_ERROR_MESSAGE_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 281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

277: PROCEDURE Attribute_Defaulting
278: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
279: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
280: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
281: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
282: , x_return_status OUT NOCOPY VARCHAR2
283: )
284: IS
285: l_err_text VARCHAR2(2000) := NULL;

Line 288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

284: IS
285: l_err_text VARCHAR2(2000) := NULL;
286: l_return_status VARCHAR2(2);
287: l_msg_count NUMBER;
288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
290: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
291: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
292: l_job_type NUMBER := 1;

Line 289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

285: l_err_text VARCHAR2(2000) := NULL;
286: l_return_status VARCHAR2(2);
287: l_msg_count NUMBER;
288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
290: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
291: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
292: l_job_type NUMBER := 1;
293:

Line 291: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

287: l_msg_count NUMBER;
288: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
289: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
290: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
291: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
292: l_job_type NUMBER := 1;
293:
294: l_owning_department NUMBER;
295: l_priority NUMBER;

Line 330: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : Start================');

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
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');

Line 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');

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(
338: p_wip_entity_id => p_eam_wo_rec.wip_entity_id

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 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 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 535: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New shutdown_type : ' || x_eam_wo_rec.shutdown_type);

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:
539: WIP_EAMWORKORDER_PVT.Get_EAM_Notification_Default

Line 561: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New notification_required : ' || x_eam_wo_rec.notification_required);

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:
565: WIP_EAMWORKORDER_PVT.Get_EAM_Tagout_Default

Line 587: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New tagout_default : ' || x_eam_wo_rec.tagout_required);

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*/
591:

Line 614: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New work_order_type : ' || x_eam_wo_rec.work_order_type);

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:
618: WIP_EAMWORKORDER_PVT.Get_EAM_ACT_Planner_Default

Line 640: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New PLANNER_TYPE : ' || x_eam_wo_rec.PLANNER_TYPE);

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:
644: WIP_EAMWORKORDER_PVT.Get_EAM_ACT_Firm_Default

Line 666: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New firm_flag : ' || x_eam_wo_rec.firm_planned_flag);

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:
670: WIP_EAMWORKORDER_PVT.Get_EAM_ACT_Planned_Default

Line 693: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_DEFAULT_PVT.Attribute_Defaulting : New PLAN_MAINTENANCE : ' || x_eam_wo_rec.PLAN_MAINTENANCE);

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:
697:

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 812: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810:
811: l_out_mesg_token_tbl := l_mesg_token_tbl;
812: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
813: ( p_message_name => 'EAM_WO_ASSET_ACTIVITY_ASSOC'
814: , p_token_tbl => l_token_tbl
815: , p_mesg_token_tbl => l_mesg_token_tbl
816: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 824: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

820: x_return_status := FND_API.G_RET_STS_ERROR;
821: x_mesg_token_tbl := l_mesg_token_tbl ;
822:
823: WHEN OTHERS THEN
824: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
825: ( p_message_name => NULL
826: , p_message_text => G_PKG_NAME || SQLERRM
827: , x_mesg_token_Tbl => x_mesg_token_tbl
828: );

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 969: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

965: EXCEPTION
966: WHEN NO_DATA_FOUND THEN
967:
968: l_out_mesg_token_tbl := l_mesg_token_tbl;
969: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
970: ( p_message_name => 'EAM_WO_CLASS_CODE'
971: , p_token_tbl => l_token_tbl
972: , p_mesg_token_tbl => l_mesg_token_tbl
973: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 981: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

977: x_return_status := FND_API.G_RET_STS_ERROR;
978: x_mesg_token_tbl := l_mesg_token_tbl ;
979:
980: WHEN OTHERS THEN
981: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
982: ( p_message_name => NULL
983: , p_message_text => G_PKG_NAME || SQLERRM
984: , x_mesg_token_Tbl => x_mesg_token_tbl
985: );

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 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 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');

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
1186: ( p_eam_wo_rec => x_eam_wo_rec

Line 1192: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Attribute_Defaulting : End================');

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
1196: WHEN OTHERS THEN

Line 1197: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1193: END IF;
1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1198: ( p_message_name => NULL
1199: , p_message_text => G_PKG_NAME || SQLERRM
1200: , x_mesg_token_Tbl => x_mesg_token_tbl
1201: );

Line 1213: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

1209:
1210: PROCEDURE Conditional_Defaulting
1211: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
1212: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
1213: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
1214: , x_return_status OUT NOCOPY VARCHAR2
1215: )
1216: IS
1217:

Line 1224: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Conditional_Defaulting : Start================');

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;
1228: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1263: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Conditional_Defaulting : End================');

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
1267: WHEN OTHERS THEN

Line 1269: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268:
1269: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1270: ( p_message_name => NULL
1271: , p_message_text => G_PKG_NAME || SQLERRM
1272: , x_mesg_token_Tbl => x_mesg_token_tbl
1273: );

Line 1299: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Populate_Null_Columns : Start================');

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;
1303: 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 2007: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.Populate_Null_Columns : End================');

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:
2011: END Populate_Null_Columns;