DBA Data[Home] [Help]

APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on FND_LOG

Line 93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

89: l_shutdown_type_code VARCHAR2(30);
90:
91: --log variables
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:

Line 94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

90:
91: --log variables
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98: CURSOR l_act_assoc_cur (

Line 95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

91: --log variables
92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98: CURSOR l_act_assoc_cur (
99: p_source_org_id NUMBER,

Line 96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

92: l_module varchar2(200);
93: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
94: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98: CURSOR l_act_assoc_cur (
99: p_source_org_id NUMBER,
100: p_source_activity_id NUMBER,

Line 156: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

152:
153: -- API body
154:
155: -- ============================================================
156: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
157: '========== Entering EAM_ActivityAssociation_PVT.Create_Association =========='
158: || 'p_target_org_id=' || p_target_org_id
159: || 'p_target_activity_id=' || p_target_activity_id
160: || 'p_wip_entity_id=' || p_wip_entity_id

Line 199: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

195:
196: -- After this point l_source_activity_id and l_source_org_id are defined,
197: -- should use them instead of p_source_activity_id and p_source_org_id.
198:
199: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
200: 'l_source_org_id=' || l_source_org_id
201: || 'l_source_activity_id=' || l_source_activity_id
202: || 'l_wo_maint_id=' || l_wo_maint_id
203: || 'l_wo_maint_type=' || l_wo_maint_id);

Line 217: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

213: l_wo_item_is_serialized := EAM_ActivityUtilities_PVT.Is_Item_Serialized(l_source_org_id, l_wo_maint_id, l_wo_maint_type);
214:
215: IF l_wo_item_is_serialized = TRUE THEN
216:
217: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
218: 'l_wo_item_is_serialized=TRUE');
219: end if;
220:
221: ELSIF l_wo_item_is_serialized = FALSE THEN

Line 223: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

219: end if;
220:
221: ELSIF l_wo_item_is_serialized = FALSE THEN
222:
223: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
224: 'l_wo_item_is_serialized=FALSE');
225: end if;
226:
227: ELSE

Line 228: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

224: 'l_wo_item_is_serialized=FALSE');
225: end if;
226:
227: ELSE
228: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
229: 'l_wo_item_is_serialized=');
230: end if;
231:
232: END IF;

Line 252: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

248: END IF;
249: RAISE FND_API.G_EXC_ERROR;
250: END;
251:
252: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
253: 'l_activity_cause_code=' || l_activity_cause_code
254: || 'l_activity_type_code=' || l_activity_type_code
255: || 'l_tagging_required_flag=' || l_tagging_required_flag
256: || 'l_shutdown_type_code=' || l_shutdown_type_code

Line 334: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

330: l_cur_tmpl_flag := NULL;
331:
332: ELSE
333: -- shouldn't be here.
334: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
335: 'Copy CURRENT: unexpected Work Order Item/Serial Number inputs.');
336: end if;
337:
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 382: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

378: l_cur_maintenance_object_type := NULL;
379:
380: ELSE
381: -- shouldn't be here.
382: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
383: 'Copy ALL: unexpected Work Order Item/Serial Number inputs.');
384: end if;
385:
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 391: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

387: END IF;
388:
389: ELSE
390: -- copy option outside of valid range, shouldn't be here.
391: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
392: 'Create_Association: unexpected Association Copy Option');
393: end if;
394:
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 403: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

399:
400: -- Copy associations from Cursor to table
401: l_act_assoc_tbl_index := NVL(l_activity_association_tbl.LAST, 0) + 1;
402:
403: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
404: 'l_cur_source_org_id=' || l_cur_source_org_id
405: || 'l_cur_source_activity_id=' || l_cur_source_activity_id
406: || 'l_cur_maintenance_object_id=' || l_cur_maintenance_object_id
407: || 'l_cur_maintenance_object_type=' || l_cur_maintenance_object_type

Line 473: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

469: l_act_assoc_tbl_index := l_act_assoc_tbl_index + 1;
470:
471: END LOOP;
472:
473: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
474: 'l_act_assoc_tbl_index=' || l_act_assoc_tbl_index);
475: end if;
476:
477: -- assign outputs

Line 491: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

487: p_activity_association_tbl => l_activity_association_tbl,
488: x_activity_association_tbl => l_x_activity_association_tbl
489: );
490:
491: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
492: 'l_x_assoc_return_status=' || l_x_assoc_return_status
493: || 'l_x_assoc_msg_count=' || l_x_assoc_msg_count
494: || 'l_x_assoc_msg_data' || l_x_assoc_msg_data);
495: end if;

Line 534: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

530: AND object_type in (40, 60) AND organization_id = p_target_org_id;
531:
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
535: 'EAM_ActivityAssociation_PVT.Create_Association: unexpected error.'
536: || 'p_wip_entity_id=' || p_wip_entity_id);
537: end if;
538:

Line 544: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

540: END;
541:
542: END IF;
543:
544: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
545: '========== Exiting EAM_ActivityAssociation_PVT.Create_Association ==========');
546: end if;
547:
548: -- ============================================================

Line 630: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

626: l_failed BOOLEAN;
627:
628: --log variables
629: l_module varchar2(200) ;
630: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
631: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
632: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
633: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
634:

Line 631: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

627:
628: --log variables
629: l_module varchar2(200) ;
630: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
631: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
632: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
633: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
634:
635: BEGIN

Line 632: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

628: --log variables
629: l_module varchar2(200) ;
630: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
631: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
632: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
633: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
634:
635: BEGIN
636: if(l_ulog) then

Line 633: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

629: l_module varchar2(200) ;
630: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
631: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
632: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
633: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
634:
635: BEGIN
636: if(l_ulog) then
637: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;

Line 662: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659:
660: -- API body
661: -- ============================================================
662: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
663: '========== Entering EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc =========='
664: || 'p_activity_association_tbl.COUNT=' || p_activity_association_tbl.COUNT);
665: end if;
666:

Line 677: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

673:
674: WHILE l_act_assoc_tbl_index IS NOT NULL
675: LOOP
676:
677: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
678: 'l_act_assoc_tbl_index=' || l_act_assoc_tbl_index ||
679: '; Organization_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id ||
680: '; Asset_Activity_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id ||
681: '; instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||

Line 685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

681: '; instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||
682: '; Inventory_Item_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Inventory_Item_Id ||
683: '; Serial_Number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Serial_Number);
684:
685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
686: 'Maintenance_Object_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id ||
687: '; Maintenance_Object_Type=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type);
688: end if;
689:

Line 700: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

696: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
697: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
698: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
699:
700: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
701: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
702:
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
704: 'Organization_Id='

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

699:
700: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
701: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
702:
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
704: 'Organization_Id='
705: || l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id);
706: end if;
707:

Line 725: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

721: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACTIVITY_ID');
722: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Id.');
723: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
724:
725: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
726: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
727:
728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
729: 'Asset_Activity_Id='

Line 728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

724:
725: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
726: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
727:
728: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
729: 'Asset_Activity_Id='
730: || l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id);
731: end if;
732:

Line 750: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

746: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_START_END_DATE');
747: -- FND_MESSAGE.SET_ENCODED('End Date cannot be before Start Date.');
748: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
749:
750: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
751: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
752:
753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
754: 'Asset_Activity_Id='

Line 753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

749:
750: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
751: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
752:
753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
754: 'Asset_Activity_Id='
755: || l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id
756: || 'Start_Date_Active=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Start_Date_Active ||
757: '; End_Date_Active=' || l_act_assoc_tbl(l_act_assoc_tbl_index).End_Date_Active);

Line 783: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

779: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_PRI_CODE');
780: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Priority Code.');
781: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
782:
783: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
784: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
785:
786: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
787: 'Priority_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code);

Line 786: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

782:
783: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
784: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
785:
786: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
787: 'Priority_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code);
788: end if;
789:
790: l_failed := TRUE;

Line 810: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

806: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_OWN_DEPT_ID');
807: -- FND_MESSAGE.SET_ENCODED('Invalid Owning Department Id.');
808: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
809:
810: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
811: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
812:
813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
814: 'Owning_Department_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id);

Line 813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

809:
810: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
811: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
812:
813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
814: 'Owning_Department_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id);
815: end if;
816:
817: l_failed := TRUE;

Line 839: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

835: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_TYPE_CODE');
836: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Type Code.');
837: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
838:
839: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
840: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
841:
842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
843: 'Activity_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code);

Line 842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

838:
839: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
840: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
841:
842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
843: 'Activity_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code);
844: end if;
845:
846: l_failed := TRUE;

Line 867: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

863: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_CAUSE_CODE');
864: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Cause Code.');
865: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
866:
867: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
868: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
869:
870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
871: 'Activity_Cause_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code);

Line 870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

866:
867: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
868: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
869:
870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
871: 'Activity_Cause_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code);
872: end if;
873:
874: l_failed := TRUE;

Line 895: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

891: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_SRC_CODE');
892: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Source Code.');
893: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
894:
895: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
896: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
897:
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
899: 'Activity_Source_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code);

Line 898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

894:
895: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
896: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
897:
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
899: 'Activity_Source_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code);
900: end if;
901:
902: l_failed := TRUE;

Line 923: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

919: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
920: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_WO_TYPE_CODE');
921: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
922:
923: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
924: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
925:
926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
927: 'Work_Order_Type = ' || l_act_assoc_tbl(l_act_assoc_tbl_index).Work_Order_Type);

Line 926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

922:
923: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
924: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
925:
926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
927: 'Work_Order_Type = ' || l_act_assoc_tbl(l_act_assoc_tbl_index).Work_Order_Type);
928: end if;
929:
930: l_failed := TRUE;

Line 950: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

946: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
947: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_PLANNER_CODE');
948: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
949:
950: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
951: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
952:
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
954: 'Planner = ' || l_act_assoc_tbl(l_act_assoc_tbl_index).Planner);

Line 953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

949:
950: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
951: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
952:
953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
954: 'Planner = ' || l_act_assoc_tbl(l_act_assoc_tbl_index).Planner);
955: end if;
956:
957: l_failed := TRUE;

Line 979: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

975: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_SHUTDOWN_CODE');
976: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Shutdown Type Code.');
977: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
978:
979: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
980: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
981:
982: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
983: 'Shutdown_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code);

Line 982: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

978:
979: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
980: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
981:
982: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
983: 'Shutdown_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code);
984: end if;
985:
986: l_failed := TRUE;

Line 1005: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1001: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
1002: -- FND_MESSAGE.SET_ENCODED('Invalid Wip Accounting Class Code.');
1003: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1004:
1005: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1006: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1007:
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1009: 'Class_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Class_Code);

Line 1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1004:
1005: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1006: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1007:
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1009: 'Class_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Class_Code);
1010: end if;
1011:
1012: l_failed := TRUE;

Line 1027: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1023: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TAG_REQ_FLAG');
1024: -- FND_MESSAGE.SET_ENCODED('Tagging Required Flag should be either Y, N, or NULL.');
1025: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1026:
1027: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1028: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1029:
1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1031: 'Tagging_Required_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag);

Line 1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1026:
1027: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1028: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1029:
1030: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1031: 'Tagging_Required_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag);
1032: end if;
1033:
1034: l_failed := TRUE;

Line 1061: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1057: l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_type := l_maintenance_object_type;
1058:
1059: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1060:
1061: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1062: 'Failed Validate Serial Number: Instance_number, or Inventory_Item_Id + Serial_Number'
1063: || 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||
1064: '; Error_Mesg=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg
1065: || 'Instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||

Line 1084: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1080: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1081: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Type should be 1 or 2.');
1082: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1083:
1084: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1085: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1086:
1087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1088: 'Maintenance_Object_Type=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type);

Line 1087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1083:
1084: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1085: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1086:
1087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1088: 'Maintenance_Object_Type=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type);
1089: end if;
1090:
1091: l_failed := TRUE;

Line 1117: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1113: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_GEN_OBJ_ID');
1114: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid gen_object_id.');
1115: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1116:
1117: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1118: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1119:
1120: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1121: 'Maintenance_Object_Id=' ||

Line 1120: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1116:
1117: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1118: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1119:
1120: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1121: 'Maintenance_Object_Id=' ||
1122: l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id);
1123: end if;
1124:

Line 1145: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1141: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_ITM_OBJ_ID');
1142: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid inventory_item_id.');
1143: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1144:
1145: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1146: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1147:
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1149: 'Maintenance_Object_Id=' ||

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1144:
1145: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1146: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1147:
1148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1149: 'Maintenance_Object_Id=' ||
1150: l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id);
1151: end if;
1152:

Line 1160: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1156: ELSE
1157: -- Shouldn't be here
1158: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1159:
1160: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1161: 'Maintenance_Object_Type is neither 1 nor 2');
1162: end if;
1163:
1164: l_failed := TRUE;

Line 1179: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1175: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TMPL_FLAG');
1176: -- FND_MESSAGE.SET_ENCODED('Tmpl Flag should be Y, N, or NULL.');
1177: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1178:
1179: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1180: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1181:
1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1183: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

Line 1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1178:
1179: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1180: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1181:
1182: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1183: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1184: end if;
1185:
1186: l_failed := TRUE;

Line 1201: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1197: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1198: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1199: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1200:
1201: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1202: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1203:
1204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1205: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

Line 1204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1200:
1201: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1202: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1203:
1204: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1205: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1206: end if;
1207:
1208: l_failed := TRUE;

Line 1222: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1218: FND_MESSAGE.SET_NAME('EAM', 'EAM_NON_SERIAL_REBUILD_ASSOC');
1219: -- FND_MESSAGE.SET_ENCODED('Cannot assoicate Non-Serialized Rebuildables to Templates.');
1220: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1221:
1222: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1223: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1224:
1225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1226: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

Line 1225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1221:
1222: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1223: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1224:
1225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1226: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1227: end if;
1228:
1229: l_failed := TRUE;

Line 1247: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1243: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1244: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1245: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1246:
1247: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1248: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1249:
1250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1251: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

Line 1250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1246:
1247: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1248: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1249:
1250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1251: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1252: end if;
1253:
1254: l_failed := TRUE;

Line 1296: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1292: fnd_message.set_name('EAM','EAM_DUPLICATE_ASSET_ACTIVITIES');
1293: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1294:
1295:
1296: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1297: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1298:
1299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1300: 'l_count=' || l_count);

Line 1299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1295:
1296: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1297: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1298:
1299: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1300: 'l_count=' || l_count);
1301: end if;
1302:
1303: l_failed := TRUE;

Line 1324: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1320: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_ASSOC_ID');
1321: -- FND_MESSAGE.SET_ENCODED('Error creating Activity_Association_Id.');
1322: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1323:
1324: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1325: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1326: end if;
1327:
1328: l_failed := TRUE;

Line 1405: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1401: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INSERT_ASSOC');
1402: -- FND_MESSAGE.SET_ENCODED('Error inserting Activity Association record.');
1403: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1404:
1405: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1406: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1407: end if;
1408:
1409: l_failed := TRUE;

Line 1447: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1443:
1444:
1445: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1446:
1447: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1448: 'Failed during insert in EOMD' ||
1449: 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||
1450: '; Error_Mesg=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1451: end if;

Line 1474: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1470: ELSE
1471: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1472: END IF;
1473:
1474: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1475: 'l_x_return_status=' || l_x_return_status ||
1476: '========== Exiting EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc ==========');
1477: end if;
1478:

Line 1570: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

1566: l_owning_department_id NUMBER;
1567:
1568: --log variables
1569: l_module varchar2(200);
1570: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1571: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1572: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1574: l_count number;

Line 1571: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;

1567:
1568: --log variables
1569: l_module varchar2(200);
1570: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1571: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1572: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1574: l_count number;
1575: CURSOR asset_activity_cur(

Line 1572: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

1568: --log variables
1569: l_module varchar2(200);
1570: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1571: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1572: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1574: l_count number;
1575: CURSOR asset_activity_cur(
1576: p_maintenance_object_id IN NUMBER,

Line 1573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

1569: l_module varchar2(200);
1570: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1571: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1572: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1573: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1574: l_count number;
1575: CURSOR asset_activity_cur(
1576: p_maintenance_object_id IN NUMBER,
1577: p_organization_id IN NUMBER

Line 1610: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1606: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1607: end if;
1608: l_date_insert := l_current_date;
1609:
1610: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1611: '==================== Entered EAM_ActivityAssociation_PVT.Inst_Activity_Template ===================='
1612: || 'p_maintenance_object_id=' || p_maintenance_object_id
1613: || 'p_maintenance_object_type=' || p_maintenance_object_type);
1614: end if;

Line 1665: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1661: END IF;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END;
1664:
1665: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1666: 'l_inventory_item_id=' || l_inventory_item_id);
1667: end if;
1668:
1669: -- II: Pick out the templates defined for this item

Line 1687: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1683: END IF;
1684: RAISE FND_API.G_EXC_ERROR;
1685: END;
1686:
1687: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1688: 'l_next_association_id=' || l_next_association_id);
1689: end if;
1690:
1691: --Bug 5137572

Line 1859: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1855: );
1856:
1857: x_msg_data := substr(x_msg_data,1,4000);
1858:
1859: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1860: '==================== Exiting EAM_ActivityAssociation_PVT.Inst_Activity_Template ====================');
1861: end if;
1862:
1863: