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_ACTIVITYASSOCIATION_PVT dependencies on FND_LOG

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

75: l_shutdown_type_code VARCHAR2(30);
76:
77: --log variables
78: l_module varchar2(200);
79: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
80: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
81: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
82: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
83:

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

76:
77: --log variables
78: l_module varchar2(200);
79: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
80: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
81: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
82: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
83:
84: CURSOR l_act_assoc_cur (

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

77: --log variables
78: l_module varchar2(200);
79: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
80: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
81: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
82: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
83:
84: CURSOR l_act_assoc_cur (
85: p_source_org_id NUMBER,

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

78: l_module varchar2(200);
79: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
80: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
81: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
82: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
83:
84: CURSOR l_act_assoc_cur (
85: p_source_org_id NUMBER,
86: p_source_activity_id NUMBER,

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

135:
136: -- API body
137:
138: -- ============================================================
139: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
140: '========== Entering EAM_ActivityAssociation_PVT.Create_Association =========='
141: || 'p_target_org_id=' || p_target_org_id
142: || 'p_target_activity_id=' || p_target_activity_id
143: || 'p_wip_entity_id=' || p_wip_entity_id

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

178:
179: -- After this point l_source_activity_id and l_source_org_id are defined,
180: -- should use them instead of p_source_activity_id and p_source_org_id.
181:
182: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
183: 'l_source_org_id=' || l_source_org_id
184: || 'l_source_activity_id=' || l_source_activity_id
185: || 'l_wo_maint_id=' || l_wo_maint_id
186: || 'l_wo_maint_type=' || l_wo_maint_id);

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

196: l_wo_item_is_serialized := EAM_ActivityUtilities_PVT.Is_Item_Serialized(l_source_org_id, l_wo_maint_id, l_wo_maint_type);
197:
198: IF l_wo_item_is_serialized = TRUE THEN
199:
200: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
201: 'l_wo_item_is_serialized=TRUE');
202: end if;
203:
204: ELSIF l_wo_item_is_serialized = FALSE THEN

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

202: end if;
203:
204: ELSIF l_wo_item_is_serialized = FALSE THEN
205:
206: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
207: 'l_wo_item_is_serialized=FALSE');
208: end if;
209:
210: ELSE

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

207: 'l_wo_item_is_serialized=FALSE');
208: end if;
209:
210: ELSE
211: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
212: 'l_wo_item_is_serialized=');
213: end if;
214:
215: END IF;

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

231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233: END;
234:
235: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
236: 'l_activity_cause_code=' || l_activity_cause_code
237: || 'l_activity_type_code=' || l_activity_type_code
238: || 'l_tagging_required_flag=' || l_tagging_required_flag
239: || 'l_shutdown_type_code=' || l_shutdown_type_code

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

313: l_cur_tmpl_flag := NULL;
314:
315: ELSE
316: -- shouldn't be here.
317: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
318: 'Copy CURRENT: unexpected Work Order Item/Serial Number inputs.');
319: end if;
320:
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

361: l_cur_maintenance_object_type := NULL;
362:
363: ELSE
364: -- shouldn't be here.
365: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
366: 'Copy ALL: unexpected Work Order Item/Serial Number inputs.');
367: end if;
368:
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

370: END IF;
371:
372: ELSE
373: -- copy option outside of valid range, shouldn't be here.
374: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
375: 'Create_Association: unexpected Association Copy Option');
376: end if;
377:
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

382:
383: -- Copy associations from Cursor to table
384: l_act_assoc_tbl_index := NVL(l_activity_association_tbl.LAST, 0) + 1;
385:
386: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
387: 'l_cur_source_org_id=' || l_cur_source_org_id
388: || 'l_cur_source_activity_id=' || l_cur_source_activity_id
389: || 'l_cur_maintenance_object_id=' || l_cur_maintenance_object_id
390: || 'l_cur_maintenance_object_type=' || l_cur_maintenance_object_type

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

444: l_act_assoc_tbl_index := l_act_assoc_tbl_index + 1;
445:
446: END LOOP;
447:
448: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
449: 'l_act_assoc_tbl_index=' || l_act_assoc_tbl_index);
450: end if;
451:
452: -- assign outputs

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

462: p_activity_association_tbl => l_activity_association_tbl,
463: x_activity_association_tbl => l_x_activity_association_tbl
464: );
465:
466: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
467: 'l_x_assoc_return_status=' || l_x_assoc_return_status
468: || 'l_x_assoc_msg_count=' || l_x_assoc_msg_count
469: || 'l_x_assoc_msg_data' || l_x_assoc_msg_data);
470: end if;

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

505: AND object_type in (40, 60) AND organization_id = p_target_org_id;
506:
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
510: 'EAM_ActivityAssociation_PVT.Create_Association: unexpected error.'
511: || 'p_wip_entity_id=' || p_wip_entity_id);
512: end if;
513:

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

515: END;
516:
517: END IF;
518:
519: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
520: '========== Exiting EAM_ActivityAssociation_PVT.Create_Association ==========');
521: end if;
522:
523: -- ============================================================

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

601: l_failed BOOLEAN;
602:
603: --log variables
604: l_module varchar2(200) ;
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:

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

602:
603: --log variables
604: l_module varchar2(200) ;
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN

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

603: --log variables
604: l_module varchar2(200) ;
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN
611: if(l_ulog) then

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

604: l_module varchar2(200) ;
605: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
606: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
607: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
608: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
609:
610: BEGIN
611: if(l_ulog) then
612: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;

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

633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- API body
636: -- ============================================================
637: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
638: '========== Entering EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc =========='
639: || 'p_activity_association_tbl.COUNT=' || p_activity_association_tbl.COUNT);
640: end if;
641:

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

648:
649: WHILE l_act_assoc_tbl_index IS NOT NULL
650: LOOP
651:
652: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
653: 'l_act_assoc_tbl_index=' || l_act_assoc_tbl_index ||
654: '; Organization_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id ||
655: '; Asset_Activity_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_Id ||
656: '; instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||

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

656: '; instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||
657: '; Inventory_Item_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Inventory_Item_Id ||
658: '; Serial_Number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Serial_Number);
659:
660: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
661: 'Maintenance_Object_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id ||
662: '; Maintenance_Object_Type=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type);
663: end if;
664:

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

671: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ORG_ID');
673: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
674:
675: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
676: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
677:
678: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
679: 'Organization_Id='

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

674:
675: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
676: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
677:
678: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
679: 'Organization_Id='
680: || l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id);
681: end if;
682:

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

696: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACTIVITY_ID');
697: -- FND_MESSAGE.SET_ENCODED('Invalid Activity 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: 'Asset_Activity_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: 'Asset_Activity_Id='
705: || l_act_assoc_tbl(l_act_assoc_tbl_index).Asset_Activity_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_START_END_DATE');
722: -- FND_MESSAGE.SET_ENCODED('End Date cannot be before Start Date.');
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: || 'Start_Date_Active=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Start_Date_Active ||
732: '; End_Date_Active=' || l_act_assoc_tbl(l_act_assoc_tbl_index).End_Date_Active);

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

754: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_PRI_CODE');
755: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Priority Code.');
756: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
757:
758: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
759: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
760:
761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
762: 'Priority_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code);

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

757:
758: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
759: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
760:
761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
762: 'Priority_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Priority_Code);
763: end if;
764:
765: l_failed := TRUE;

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

781: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_OWN_DEPT_ID');
782: -- FND_MESSAGE.SET_ENCODED('Invalid Owning Department Id.');
783: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
784:
785: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
786: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
787:
788: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
789: 'Owning_Department_Id=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id);

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

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

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

810: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_TYPE_CODE');
811: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Type Code.');
812: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
813:
814: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
815: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
816:
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
818: 'Activity_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code);

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

813:
814: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
815: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
816:
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
818: 'Activity_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Type_Code);
819: end if;
820:
821: l_failed := TRUE;

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

838: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_CAUSE_CODE');
839: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Cause Code.');
840: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
841:
842: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
843: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
844:
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
846: 'Activity_Cause_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code);

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

841:
842: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
843: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
844:
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
846: 'Activity_Cause_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Cause_Code);
847: end if;
848:
849: l_failed := TRUE;

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

866: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_ACT_SRC_CODE');
867: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Source Code.');
868: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
869:
870: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
871: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
872:
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
874: 'Activity_Source_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code);

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

869:
870: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
871: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
872:
873: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
874: 'Activity_Source_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Activity_Source_Code);
875: end if;
876:
877: l_failed := TRUE;

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

894: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_SHUTDOWN_CODE');
895: -- FND_MESSAGE.SET_ENCODED('Invalid Activity Shutdown Type Code.');
896: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
897:
898: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
899: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
900:
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
902: 'Shutdown_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code);

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

897:
898: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
899: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
900:
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
902: 'Shutdown_Type_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Shutdown_Type_Code);
903: end if;
904:
905: l_failed := TRUE;

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

920: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
921: -- FND_MESSAGE.SET_ENCODED('Invalid Wip Accounting Class Code.');
922: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
923:
924: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
925: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
926:
927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
928: 'Class_Code=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Class_Code);

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

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

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

942: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TAG_REQ_FLAG');
943: -- FND_MESSAGE.SET_ENCODED('Tagging Required Flag should be either Y, N, or NULL.');
944: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
945:
946: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
947: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
948:
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
950: 'Tagging_Required_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag);

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

945:
946: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
947: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
948:
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
950: 'Tagging_Required_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tagging_Required_Flag);
951: end if;
952:
953: l_failed := TRUE;

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

976: l_act_assoc_tbl(l_act_assoc_tbl_index).maintenance_object_type := l_maintenance_object_type;
977:
978: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
979:
980: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
981: 'Failed Validate Serial Number: Instance_number, or Inventory_Item_Id + Serial_Number'
982: || 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||
983: '; Error_Mesg=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg
984: || 'Instance_number=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Instance_number ||

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

999: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1000: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Type should be 1 or 2.');
1001: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1002:
1003: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1004: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1005:
1006: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1007: 'Maintenance_Object_Type=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Type);

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

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

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

1032: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_GEN_OBJ_ID');
1033: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid gen_object_id.');
1034: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1035:
1036: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1037: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1038:
1039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1040: 'Maintenance_Object_Id=' ||

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

1035:
1036: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1037: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1038:
1039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1040: 'Maintenance_Object_Id=' ||
1041: l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id);
1042: end if;
1043:

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

1060: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVLD_MT_ITM_OBJ_ID');
1061: -- FND_MESSAGE.SET_ENCODED('Maintenance Object Id should be a valid inventory_item_id.');
1062: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1063:
1064: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1065: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1066:
1067: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1068: 'Maintenance_Object_Id=' ||

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

1063:
1064: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1065: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1066:
1067: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1068: 'Maintenance_Object_Id=' ||
1069: l_act_assoc_tbl(l_act_assoc_tbl_index).Maintenance_Object_Id);
1070: end if;
1071:

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

1075: ELSE
1076: -- Shouldn't be here
1077: l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status := FND_API.G_RET_STS_ERROR;
1078:
1079: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1080: 'Maintenance_Object_Type is neither 1 nor 2');
1081: end if;
1082:
1083: l_failed := TRUE;

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

1094: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_INVALID_TMPL_FLAG');
1095: -- FND_MESSAGE.SET_ENCODED('Tmpl Flag should be Y, N, or NULL.');
1096: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1097:
1098: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1099: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1100:
1101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1102: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

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

1097:
1098: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1099: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1100:
1101: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1102: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1103: end if;
1104:
1105: l_failed := TRUE;

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

1116: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1117: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1118: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1119:
1120: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1121: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1122:
1123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1124: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

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

1119:
1120: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1121: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1122:
1123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1124: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1125: end if;
1126:
1127: l_failed := TRUE;

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

1137: FND_MESSAGE.SET_NAME('EAM', 'EAM_NON_SERIAL_REBUILD_ASSOC');
1138: -- FND_MESSAGE.SET_ENCODED('Cannot assoicate Non-Serialized Rebuildables to Templates.');
1139: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1140:
1141: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1142: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1143:
1144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1145: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

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

1140:
1141: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1142: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1143:
1144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1145: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1146: end if;
1147:
1148: l_failed := TRUE;

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

1162: FND_MESSAGE.SET_NAME('EAM', 'EAM_IAA_INV_TEML_FLAG');
1163: -- FND_MESSAGE.SET_ENCODED(' Invalid Template flag value.');
1164: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1165:
1166: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1167: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1168:
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1170: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);

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

1165:
1166: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1167: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1168:
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1170: 'Tmpl_Flag=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Tmpl_Flag);
1171: end if;
1172:
1173: l_failed := TRUE;

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

1211: fnd_message.set_name('EAM','EAM_DUPLICATE_ASSET_ACTIVITIES');
1212: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1213:
1214:
1215: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1216: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1217:
1218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1219: 'l_count=' || l_count);

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

1214:
1215: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1216: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1217:
1218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1219: 'l_count=' || l_count);
1220: end if;
1221:
1222: l_failed := TRUE;

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

1239: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_ACT_ASSOC_ID');
1240: -- FND_MESSAGE.SET_ENCODED('Error creating Activity_Association_Id.');
1241: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg := FND_MESSAGE.GET;
1242:
1243: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1244: l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1245: end if;
1246:
1247: 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_INSERT_ASSOC');
1321: -- FND_MESSAGE.SET_ENCODED('Error inserting Activity Association record.');
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 1361: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1357:
1358:
1359: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1360:
1361: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1362: 'Failed during insert in EOMD' ||
1363: 'Return_Status=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Return_Status ||
1364: '; Error_Mesg=' || l_act_assoc_tbl(l_act_assoc_tbl_index).Error_Mesg);
1365: end if;

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

1384: ELSE
1385: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1386: END IF;
1387:
1388: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1389: 'l_x_return_status=' || l_x_return_status ||
1390: '========== Exiting EAM_ActivityAssociation_PVT.Create_AssetNumberAssoc ==========');
1391: end if;
1392:

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

1480: l_owning_department_id NUMBER;
1481:
1482: --log variables
1483: l_module varchar2(200);
1484: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1485: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1486: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1487: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1488: l_count number;

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

1481:
1482: --log variables
1483: l_module varchar2(200);
1484: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1485: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1486: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1487: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1488: l_count number;
1489: CURSOR asset_activity_cur(

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

1482: --log variables
1483: l_module varchar2(200);
1484: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1485: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1486: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1487: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1488: l_count number;
1489: CURSOR asset_activity_cur(
1490: p_maintenance_object_id IN NUMBER,

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

1483: l_module varchar2(200);
1484: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
1485: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level ;
1486: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
1487: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
1488: l_count number;
1489: CURSOR asset_activity_cur(
1490: p_maintenance_object_id IN NUMBER,
1491: p_organization_id IN NUMBER

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

1518: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1519: end if;
1520: l_date_insert := l_current_date;
1521:
1522: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1523: '==================== Entered EAM_ActivityAssociation_PVT.Inst_Activity_Template ===================='
1524: || 'p_maintenance_object_id=' || p_maintenance_object_id
1525: || 'p_maintenance_object_type=' || p_maintenance_object_type);
1526: end if;

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

1573: END IF;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END;
1576:
1577: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1578: 'l_inventory_item_id=' || l_inventory_item_id);
1579: end if;
1580:
1581: -- II: Pick out the templates defined for this item

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

1595: END IF;
1596: RAISE FND_API.G_EXC_ERROR;
1597: END;
1598:
1599: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1600: 'l_next_association_id=' || l_next_association_id);
1601: end if;
1602:
1603: --Bug 5137572

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

1762: );
1763:
1764: x_msg_data := substr(x_msg_data,1,4000);
1765:
1766: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1767: '==================== Exiting EAM_ActivityAssociation_PVT.Inst_Activity_Template ====================');
1768: end if;
1769:
1770: