DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 220: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

216: PROCEDURE Attribute_Defaulting
217: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
218: , p_old_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
219: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
220: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
221: , x_return_status OUT NOCOPY VARCHAR2
222: )
223: IS
224: l_err_text VARCHAR2(2000) := NULL;

Line 227: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

223: IS
224: l_err_text VARCHAR2(2000) := NULL;
225: l_return_status VARCHAR2(2);
226: l_msg_count NUMBER;
227: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
228: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
229: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
230: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
231: l_job_type NUMBER := 1;

Line 228: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

224: l_err_text VARCHAR2(2000) := NULL;
225: l_return_status VARCHAR2(2);
226: l_msg_count NUMBER;
227: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
228: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
229: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
230: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
231: l_job_type NUMBER := 1;
232:

Line 230: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

226: l_msg_count NUMBER;
227: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
228: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
229: l_out_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
230: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
231: l_job_type NUMBER := 1;
232:
233: l_owning_department NUMBER;
234: l_priority NUMBER;

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

618: EXCEPTION
619: WHEN NO_DATA_FOUND THEN
620:
621: l_out_mesg_token_tbl := l_mesg_token_tbl;
622: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
623: ( p_message_name => 'EAM_WO_ASSET_ACTIVITY_ASSOC'
624: , p_token_tbl => l_token_tbl
625: , p_mesg_token_tbl => l_mesg_token_tbl
626: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 634: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

630: x_return_status := FND_API.G_RET_STS_ERROR;
631: x_mesg_token_tbl := l_mesg_token_tbl ;
632:
633: WHEN OTHERS THEN
634: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
635: ( p_message_name => NULL
636: , p_message_text => G_PKG_NAME || SQLERRM
637: , x_mesg_token_Tbl => x_mesg_token_tbl
638: );

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

726: EXCEPTION
727: WHEN NO_DATA_FOUND THEN
728:
729: l_out_mesg_token_tbl := l_mesg_token_tbl;
730: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
731: ( p_message_name => 'EAM_WO_CLASS_CODE'
732: , p_token_tbl => l_token_tbl
733: , p_mesg_token_tbl => l_mesg_token_tbl
734: , x_mesg_token_tbl => l_out_mesg_token_tbl

Line 742: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

738: x_return_status := FND_API.G_RET_STS_ERROR;
739: x_mesg_token_tbl := l_mesg_token_tbl ;
740:
741: WHEN OTHERS THEN
742: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
743: ( p_message_name => NULL
744: , p_message_text => G_PKG_NAME || SQLERRM
745: , x_mesg_token_Tbl => x_mesg_token_tbl
746: );

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

941:
942:
943: EXCEPTION
944: WHEN OTHERS THEN
945: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
946: ( p_message_name => NULL
947: , p_message_text => G_PKG_NAME || SQLERRM
948: , x_mesg_token_Tbl => x_mesg_token_tbl
949: );

Line 961: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

957:
958: PROCEDURE Conditional_Defaulting
959: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
960: , x_eam_wo_rec OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_rec_type
961: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
962: , x_return_status OUT NOCOPY VARCHAR2
963: )
964: IS
965:

Line 1010: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

1006:
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009:
1010: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
1011: ( p_message_name => NULL
1012: , p_message_text => G_PKG_NAME || SQLERRM
1013: , x_mesg_token_Tbl => x_mesg_token_tbl
1014: );

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;