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.AHL_FLEET_FORECAST_PVT dependencies on AHL_DEBUG_PUB

Line 4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_FLEET_FORECAST_PVT AS
2: /*$Header: AHLVFLTB.pls 120.0.12020000.3 2012/12/15 04:15:40 viagrawa noship $*/
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_FLEET_FORECAST_PVT';
4: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
5: ------------------------------------
6: -- Common constants and variables --
7: ------------------------------------
8: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

Line 248: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );

244: -- Call the process_reconfig_mrs to Close the SRS which are already created
245: FOR l_close_sr IN get_fleet_unit_asss(p_fleet_id)
246: LOOP
247: IF G_DEBUG = 'Y' THEN
248: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
249: END IF;
250: process_reconfig_mrs
251: (
252: p_api_version => 1.0,

Line 269: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );

265:
266: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
267: THEN
268: IF G_DEBUG = 'Y' THEN
269: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
270: END IF;
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273: END LOOP;

Line 563: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );

559:
560: BEGIN
561:
562: IF G_DEBUG = 'Y' THEN
563: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Begin private API:' );
564: END IF;
565:
566: -- Initialize API return status to success
567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 590: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Input Parameters::' );

586: FND_MSG_PUB.initialize;
587: END IF;
588:
589: IF G_DEBUG = 'Y' THEN
590: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Input Parameters::' );
591: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_fleet_id::'||p_fleet_id||'::p_unit_config_id::'||p_unit_config_id );
592: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'p_fleet_unit_asso_id::'||p_fleet_unit_asso_id||'::p_delete_sr_flag::'||p_delete_sr_flag );
593: END IF;
594:

Line 591: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_fleet_id::'||p_fleet_id||'::p_unit_config_id::'||p_unit_config_id );

587: END IF;
588:
589: IF G_DEBUG = 'Y' THEN
590: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Input Parameters::' );
591: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_fleet_id::'||p_fleet_id||'::p_unit_config_id::'||p_unit_config_id );
592: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'p_fleet_unit_asso_id::'||p_fleet_unit_asso_id||'::p_delete_sr_flag::'||p_delete_sr_flag );
593: END IF;
594:
595: -- This Condition will be executed if the API is called when fleet - unit association is removed

Line 592: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'p_fleet_unit_asso_id::'||p_fleet_unit_asso_id||'::p_delete_sr_flag::'||p_delete_sr_flag );

588:
589: IF G_DEBUG = 'Y' THEN
590: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Input Parameters::' );
591: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::p_fleet_id::'||p_fleet_id||'::p_unit_config_id::'||p_unit_config_id );
592: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || 'p_fleet_unit_asso_id::'||p_fleet_unit_asso_id||'::p_delete_sr_flag::'||p_delete_sr_flag );
593: END IF;
594:
595: -- This Condition will be executed if the API is called when fleet - unit association is removed
596: -- and p_delete_sr_flag should be passed as 'Y'

Line 654: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::MRS for delete associations to Close SR Count for SR ::'|| l_nr_task_rec.incident_id||'-- is::'|| l_mr_sr_assoc_tbl.count);

650: i := i+1;
651: END LOOP;
652:
653: IF G_DEBUG = 'Y' THEN
654: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::MRS for delete associations to Close SR Count for SR ::'|| l_nr_task_rec.incident_id||'-- is::'|| l_mr_sr_assoc_tbl.count);
655: END IF;
656:
657: -- Call Process Associations
658: IF(l_mr_sr_assoc_tbl.count >0)

Line 664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );

660: /** Input Table Params to Process -MR Associations */
661: IF G_DEBUG = 'Y' THEN
662: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
663: LOOP
664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);

Line 665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);

661: IF G_DEBUG = 'Y' THEN
662: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
663: LOOP
664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
669: END LOOP;

Line 666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);

662: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
663: LOOP
664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
669: END LOOP;
670: END IF;

Line 667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);

663: LOOP
664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
669: END LOOP;
670: END IF;
671:

Line 668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);

664: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
665: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
666: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
667: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
668: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
669: END LOOP;
670: END IF;
671:
672: AHL_UMP_SR_PVT.Process_SR_MR_Associations

Line 692: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations for Delete is Failed' );

688:
689: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
690: THEN
691: IF G_DEBUG = 'Y' THEN
692: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations for Delete is Failed' );
693: END IF;
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: END IF;

Line 699: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before Call to AHL_UMP_NONROUTINES_PVT.Update_SR for Closing' );

695: END IF;
696: END IF;
697:
698: IF G_DEBUG = 'Y' THEN
699: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before Call to AHL_UMP_NONROUTINES_PVT.Update_SR for Closing' );
700: END IF;
701:
702: AHL_UMP_NONROUTINES_PVT.Update_SR
703: (

Line 719: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );

715:
716: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
717: THEN
718: IF G_DEBUG = 'Y' THEN
719: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
720: END IF;
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: END IF;

Line 781: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Uc_ID::'||l_fleet_unit_asso_rec.unit_config_header_id );

777: END IF;
778: CLOSE get_prev_opstype;
779:
780: IF G_DEBUG = 'Y' THEN
781: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Uc_ID::'||l_fleet_unit_asso_rec.unit_config_header_id );
782: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Item Instance ID::'||l_cur_item_instance_det.csi_item_instance_id );
783: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Previous Operations Type::'||l_prev_opstype );
784: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet Id::'|| l_fleet_unit_asso_rec.fleet_header_id );
785: END IF;

Line 782: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Item Instance ID::'||l_cur_item_instance_det.csi_item_instance_id );

778: CLOSE get_prev_opstype;
779:
780: IF G_DEBUG = 'Y' THEN
781: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Uc_ID::'||l_fleet_unit_asso_rec.unit_config_header_id );
782: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Item Instance ID::'||l_cur_item_instance_det.csi_item_instance_id );
783: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Previous Operations Type::'||l_prev_opstype );
784: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet Id::'|| l_fleet_unit_asso_rec.fleet_header_id );
785: END IF;
786:

Line 783: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Previous Operations Type::'||l_prev_opstype );

779:
780: IF G_DEBUG = 'Y' THEN
781: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Uc_ID::'||l_fleet_unit_asso_rec.unit_config_header_id );
782: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Item Instance ID::'||l_cur_item_instance_det.csi_item_instance_id );
783: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Previous Operations Type::'||l_prev_opstype );
784: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet Id::'|| l_fleet_unit_asso_rec.fleet_header_id );
785: END IF;
786:
787: -- Strore mr_header_id as index for reconfig mr table(l_temp_reconfig_mr_id_tbl)

Line 784: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet Id::'|| l_fleet_unit_asso_rec.fleet_header_id );

780: IF G_DEBUG = 'Y' THEN
781: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Uc_ID::'||l_fleet_unit_asso_rec.unit_config_header_id );
782: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Item Instance ID::'||l_cur_item_instance_det.csi_item_instance_id );
783: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Previous Operations Type::'||l_prev_opstype );
784: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet Id::'|| l_fleet_unit_asso_rec.fleet_header_id );
785: END IF;
786:
787: -- Strore mr_header_id as index for reconfig mr table(l_temp_reconfig_mr_id_tbl)
788: -- Compliance_lead_time as a value

Line 833: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::In For Loop of create ::'||l_temp_reconfig_mr_id_tbl(i) );

829: THEN
830: FOR i IN l_temp_reconfig_mr_id_tbl.FIRST..l_temp_reconfig_mr_id_tbl.LAST
831: LOOP
832: IF G_DEBUG = 'Y' THEN
833: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::In For Loop of create ::'||l_temp_reconfig_mr_id_tbl(i) );
834: END IF;
835:
836: --Clear l_applicable_mr_tbl before call GET_APPLICABLE_MRS
837: l_applicable_mr_tbl.delete;

Line 861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );

857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
859: THEN
860: IF G_DEBUG = 'Y' THEN
861: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_FMP_PVT.GET_APPLICABLE_MRS is Failed' );
862: END IF;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 871: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Effective Reconfig MR '||'::Reconfig MR::'||i||':::' || l_applicable_mr_tbl.count );

867: RAISE FND_API.G_EXC_ERROR;
868: END IF;
869:
870: IF G_DEBUG = 'Y' THEN
871: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Effective Reconfig MR '||'::Reconfig MR::'||i||':::' || l_applicable_mr_tbl.count );
872: END IF;
873:
874: IF(l_applicable_mr_tbl.count > 0)
875: THEN

Line 877: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Applicable MR ::'||i||':::'|| l_temp_reconfig_mr_id_tbl(i) );

873:
874: IF(l_applicable_mr_tbl.count > 0)
875: THEN
876: IF G_DEBUG = 'Y' THEN
877: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Applicable MR ::'||i||':::'|| l_temp_reconfig_mr_id_tbl(i) );
878: END IF;
879: -- Copy to New Reconfig MRs Table
880: l_new_reconfig_mr_id_tbl(indx) := l_temp_reconfig_mr_id_tbl(i);
881:

Line 895: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After Filtering with GET_APPLICABLE_MRS New Reconfiguration MRs count is:: '|| l_new_reconfig_mr_id_tbl.COUNT );

891: END LOOP;
892: END IF;
893:
894: IF G_DEBUG = 'Y' THEN
895: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After Filtering with GET_APPLICABLE_MRS New Reconfiguration MRs count is:: '|| l_new_reconfig_mr_id_tbl.COUNT );
896: END IF;
897:
898: -- Resolution Date for SR is l_max_compliance_lead_time (days) ahead of unit association Start date
899: l_resoultion_date := l_fleet_unit_asso_rec.association_start - l_max_compliance_lead_time;

Line 909: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfiguration MRS count is After Filtering '|| l_new_reconfig_mr_id_tbl.COUNT );

905:
906: IF(l_fleet_unit_asso_rec.reconfig_sr_id IS NULL)
907: THEN
908: IF G_DEBUG = 'Y' THEN
909: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfiguration MRS count is After Filtering '|| l_new_reconfig_mr_id_tbl.COUNT );
910: END IF;
911:
912: -- If atleast one reconfiguration MR exist then create Service Request
913: IF(l_new_reconfig_mr_id_tbl.count > 0)

Line 930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );

926: l_nr_task_rec.incident_date := SYSDATE;
927: l_nr_task_rec.expected_resolution_date := l_resoultion_date;
928:
929: IF G_DEBUG = 'Y' THEN
930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);

Line 931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);

927: l_nr_task_rec.expected_resolution_date := l_resoultion_date;
928:
929: IF G_DEBUG = 'Y' THEN
930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );

Line 932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);

928:
929: IF G_DEBUG = 'Y' THEN
930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );
936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);

Line 933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);

929: IF G_DEBUG = 'Y' THEN
930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );
936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);
937: END IF;

Line 934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);

930: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Create_SR Input Params::' );
931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );
936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);
937: END IF;
938: -- Call Create SR

Line 935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );

931: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::inventory_item_id::' || l_nr_task_rec.inventory_item_id || '::serial_number::'|| l_nr_task_rec.serial_number);
932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );
936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);
937: END IF;
938: -- Call Create SR
939: AHL_UMP_NONROUTINES_PVT.Create_SR

Line 936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);

932: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::csi_item_instance_id::' || l_nr_task_rec.instance_id ||'::instance_number::'|| l_nr_task_rec.instance_number);
933: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Service Type ::'||l_nr_task_rec.type_id||'::customer_type::' || l_nr_task_rec.customer_type);
934: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Customer_id ::'||l_nr_task_rec.customer_id||'::severity_id::' || l_nr_task_rec.severity_id);
935: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Summary ::' ||l_nr_task_rec.problem_summary||'::uc_id::'||l_nr_task_rec.unit_config_header_id );
936: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_date ::' ||l_nr_task_rec.incident_date||'::expected_resolution_date::'||l_nr_task_rec.expected_resolution_date);
937: END IF;
938: -- Call Create SR
939: AHL_UMP_NONROUTINES_PVT.Create_SR
940: (

Line 956: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Create_SR is Failed' );

952:
953: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
954: THEN
955: IF G_DEBUG = 'Y' THEN
956: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Create_SR is Failed' );
957: END IF;
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:

Line 975: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations:: l_new_reconfig_mr_id_tbl Count:: ' || l_new_reconfig_mr_id_tbl.count );

971: CLOSE get_sr_details;
972:
973: -- Copy Inputs from l_new_reconfig_mr_id_tbl to l_mr_sr_assoc_tbl
974: IF G_DEBUG = 'Y' THEN
975: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations:: l_new_reconfig_mr_id_tbl Count:: ' || l_new_reconfig_mr_id_tbl.count );
976: END IF;
977: indx := 1 ;
978: FOR i IN l_new_reconfig_mr_id_tbl.FIRST..l_new_reconfig_mr_id_tbl.LAST
979: LOOP

Line 985: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations:: MR Header ID ' || l_mr_sr_assoc_tbl(i).mr_header_id );

981: l_mr_sr_assoc_tbl(indx).operation_flag := 'C';
982: l_mr_sr_assoc_tbl(indx).csi_instance_id := l_nr_task_rec.instance_id;
983:
984: IF G_DEBUG = 'Y' THEN
985: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations:: MR Header ID ' || l_mr_sr_assoc_tbl(i).mr_header_id );
986: END IF;
987:
988: indx := indx +1;
989: END LOOP;

Line 992: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );

988: indx := indx +1;
989: END LOOP;
990:
991: IF G_DEBUG = 'Y' THEN
992: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );
993: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to l_mr_sr_assoc_tbl Count:: ' || l_mr_sr_assoc_tbl.count );
994: END IF;
995: -- Call Process Associations
996: AHL_UMP_SR_PVT.Process_SR_MR_Associations

Line 993: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to l_mr_sr_assoc_tbl Count:: ' || l_mr_sr_assoc_tbl.count );

989: END LOOP;
990:
991: IF G_DEBUG = 'Y' THEN
992: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );
993: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to l_mr_sr_assoc_tbl Count:: ' || l_mr_sr_assoc_tbl.count );
994: END IF;
995: -- Call Process Associations
996: AHL_UMP_SR_PVT.Process_SR_MR_Associations
997: (

Line 1016: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );

1012:
1013: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1014: THEN
1015: IF G_DEBUG = 'Y' THEN
1016: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1017: END IF;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:

Line 1040: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet - Unit Assocition is Updated with SR_ID::'||l_nr_task_rec.incident_id );

1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: IF G_DEBUG = 'Y' THEN
1040: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Fleet - Unit Assocition is Updated with SR_ID::'||l_nr_task_rec.incident_id );
1041: END IF;
1042:
1043: fnd_file.put_line(FND_FILE.LOG, 'SR created for Unit ::'||l_cur_item_instance_det.name);
1044: fnd_file.put_line(FND_FILE.LOG, 'SR created for Fleet ::'||l_fleet_unit_asso_rec.name);

Line 1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );

1086: -- Get the resolution date for existing SR if it is not same as new resoultion date then update SR
1087: IF(l_cur_sr_details.expected_resolution_date <> l_resoultion_date OR l_nr_task_rec.type_id <> l_cur_sr_details.incident_type_id )
1088: THEN
1089: IF G_DEBUG = 'Y' THEN
1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );
1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );

Line 1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);

1087: IF(l_cur_sr_details.expected_resolution_date <> l_resoultion_date OR l_nr_task_rec.type_id <> l_cur_sr_details.incident_type_id )
1088: THEN
1089: IF G_DEBUG = 'Y' THEN
1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );
1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );
1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);

Line 1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);

1088: THEN
1089: IF G_DEBUG = 'Y' THEN
1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );
1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );
1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);
1096: END IF;

Line 1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );

1089: IF G_DEBUG = 'Y' THEN
1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );
1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );
1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);
1096: END IF;
1097: l_nr_task_rec.type_id := l_cur_sr_details.incident_type_id ;

Line 1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );

1090: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Update_SR Input Params::' );
1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );
1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);
1096: END IF;
1097: l_nr_task_rec.type_id := l_cur_sr_details.incident_type_id ;
1098:

Line 1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);

1091: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.incident_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1092: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id ::'||l_nr_task_rec.status_id||'::severity_id::' || l_nr_task_rec.severity_id);
1093: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::problem_summary ::' ||l_nr_task_rec.problem_summary||'::instance_id::'||l_nr_task_rec.instance_id );
1094: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::expected_resolution_date ::' ||l_nr_task_rec.expected_resolution_date||'::instance_type_id::'||l_nr_task_rec.type_id );
1095: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Reconfig MRs Count ::' ||l_new_reconfig_mr_id_tbl.count);
1096: END IF;
1097: l_nr_task_rec.type_id := l_cur_sr_details.incident_type_id ;
1098:
1099: AHL_UMP_NONROUTINES_PVT.Update_SR

Line 1116: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );

1112:
1113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1114: THEN
1115: IF G_DEBUG = 'Y' THEN
1116: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1117: END IF;
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119: END IF;
1120: END IF;

Line 1128: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Already Added MRS Count to SR::'|| l_nr_task_rec.incident_id||':: is ::'|| l_temp_reconfig_mr_id_tbl.count);

1124: FETCH get_sr_mr_headers BULK COLLECT INTO l_temp_reconfig_mr_id_tbl, l_temp_reconfig_mr_ue_ovn;
1125: CLOSE get_sr_mr_headers;
1126:
1127: IF G_DEBUG = 'Y' THEN
1128: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Already Added MRS Count to SR::'|| l_nr_task_rec.incident_id||':: is ::'|| l_temp_reconfig_mr_id_tbl.count);
1129: END IF;
1130: -- Copy all the existing Reconfig MRS in to l_old_recon_mr_id_tbl
1131: IF(l_temp_reconfig_mr_id_tbl.count > 0)
1132: THEN

Line 1145: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Existing UES count to SR::'|| l_nr_task_rec.incident_id||':::'|| l_old_recon_mr_id_tbl.count);

1141: l_old_recon_mr_id_tbl(i) := l_temp_reconfig_mr_id_tbl(i);
1142: l_reconfig_mr_ue_ovn(l_temp_reconfig_mr_id_tbl(i)) := l_temp_reconfig_mr_ue_ovn(i);
1143: END LOOP;
1144: IF G_DEBUG = 'Y' THEN
1145: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Existing UES count to SR::'|| l_nr_task_rec.incident_id||':::'|| l_old_recon_mr_id_tbl.count);
1146: END IF;
1147: ELSE
1148: -- If There are no old UEs reset the table
1149: l_old_recon_mr_id_tbl.delete;

Line 1158: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After extending size of reconfig mrs:::::'|| l_new_recon_mr_id_tbl.count);

1154: l_size := l_new_reconfig_mr_id_tbl.count - 1;
1155: l_new_recon_mr_id_tbl.EXTEND(l_size,1);
1156:
1157: IF G_DEBUG = 'Y' THEN
1158: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After extending size of reconfig mrs:::::'|| l_new_recon_mr_id_tbl.count);
1159: END IF;
1160:
1161: FOR indx IN l_new_reconfig_mr_id_tbl.FIRST..l_new_reconfig_mr_id_tbl.LAST
1162: LOOP

Line 1168: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before NEW MR - OLD MR::MRs count:::::'|| l_new_recon_mr_id_tbl.count);

1164: j := j +1;
1165: END LOOP;
1166:
1167: IF G_DEBUG = 'Y' THEN
1168: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before NEW MR - OLD MR::MRs count:::::'|| l_new_recon_mr_id_tbl.count);
1169: END IF;
1170:
1171: -- NEW Reconfig MR LIST - OLD MR headers from UE table = 'C'
1172: l_tmp_recon_mr_id_tbl := l_new_recon_mr_id_tbl MULTISET EXCEPT l_old_recon_mr_id_tbl;

Line 1175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::for Create::Before Copy to Asso Table ::::'|| l_tmp_recon_mr_id_tbl.count);

1171: -- NEW Reconfig MR LIST - OLD MR headers from UE table = 'C'
1172: l_tmp_recon_mr_id_tbl := l_new_recon_mr_id_tbl MULTISET EXCEPT l_old_recon_mr_id_tbl;
1173:
1174: IF G_DEBUG = 'Y' THEN
1175: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::for Create::Before Copy to Asso Table ::::'|| l_tmp_recon_mr_id_tbl.count);
1176: END IF;
1177:
1178: j := 1;
1179: IF(l_tmp_recon_mr_id_tbl.count >0 )

Line 1192: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);

1188: END LOOP;
1189: END IF;
1190:
1191: IF G_DEBUG = 'Y' THEN
1192: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);
1193: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before OLD MR - NEW MR::MRs count::l_old_recon_mr_id_tbl::'|| l_old_recon_mr_id_tbl.count);
1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::before OLD MR - NEW MR::MRs count:::l_new_recon_mr_id_tbl :::'|| l_new_recon_mr_id_tbl.count);
1195: END IF;
1196:

Line 1193: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before OLD MR - NEW MR::MRs count::l_old_recon_mr_id_tbl::'|| l_old_recon_mr_id_tbl.count);

1189: END IF;
1190:
1191: IF G_DEBUG = 'Y' THEN
1192: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);
1193: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before OLD MR - NEW MR::MRs count::l_old_recon_mr_id_tbl::'|| l_old_recon_mr_id_tbl.count);
1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::before OLD MR - NEW MR::MRs count:::l_new_recon_mr_id_tbl :::'|| l_new_recon_mr_id_tbl.count);
1195: END IF;
1196:
1197: IF G_DEBUG = 'Y' THEN

Line 1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::before OLD MR - NEW MR::MRs count:::l_new_recon_mr_id_tbl :::'|| l_new_recon_mr_id_tbl.count);

1190:
1191: IF G_DEBUG = 'Y' THEN
1192: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After NEW MR - OLD MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);
1193: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Before OLD MR - NEW MR::MRs count::l_old_recon_mr_id_tbl::'|| l_old_recon_mr_id_tbl.count);
1194: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::before OLD MR - NEW MR::MRs count:::l_new_recon_mr_id_tbl :::'|| l_new_recon_mr_id_tbl.count);
1195: END IF;
1196:
1197: IF G_DEBUG = 'Y' THEN
1198: IF(l_old_recon_mr_id_tbl.count > 0)

Line 1202: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_old_recon_mr_id_tbl('||i||').mr_header_id::' || l_old_recon_mr_id_tbl(i));

1198: IF(l_old_recon_mr_id_tbl.count > 0)
1199: THEN
1200: FOR i IN l_old_recon_mr_id_tbl.FIRST..l_old_recon_mr_id_tbl.LAST
1201: LOOP
1202: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_old_recon_mr_id_tbl('||i||').mr_header_id::' || l_old_recon_mr_id_tbl(i));
1203: END LOOP;
1204: END IF;
1205:
1206: IF(l_new_recon_mr_id_tbl.count > 0)

Line 1210: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_new_recon_mr_id_tbl('||i||').mr_header_id::' || l_new_recon_mr_id_tbl(i));

1206: IF(l_new_recon_mr_id_tbl.count > 0)
1207: THEN
1208: FOR i IN l_new_recon_mr_id_tbl.FIRST..l_new_recon_mr_id_tbl.LAST
1209: LOOP
1210: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_new_recon_mr_id_tbl('||i||').mr_header_id::' || l_new_recon_mr_id_tbl(i));
1211: END LOOP;
1212: END IF;
1213: END IF;
1214:

Line 1221: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After OLD MR - NEW MR::MRs count::for Delete::Before Copy to Asso Table ::::'|| l_tmp_recon_mr_id_tbl.count);

1217: -- OLD MR headers from UE table - NEW Reconfig MR LIST = 'D'
1218: l_tmp_recon_mr_id_tbl := l_old_recon_mr_id_tbl MULTISET EXCEPT l_new_recon_mr_id_tbl;
1219:
1220: IF G_DEBUG = 'Y' THEN
1221: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After OLD MR - NEW MR::MRs count::for Delete::Before Copy to Asso Table ::::'|| l_tmp_recon_mr_id_tbl.count);
1222: END IF;
1223:
1224: IF(l_tmp_recon_mr_id_tbl.count >0 )
1225: THEN

Line 1234: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After OLD MR - NEW MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl(j).mr_header_id);

1230: l_mr_sr_assoc_tbl(j).object_version_number := l_reconfig_mr_ue_ovn(l_tmp_recon_mr_id_tbl(i));
1231: l_mr_sr_assoc_tbl(j).csi_instance_id := l_nr_task_rec.instance_id;
1232:
1233: IF G_DEBUG = 'Y' THEN
1234: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::After OLD MR - NEW MR::MRs count::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl(j).mr_header_id);
1235: END IF;
1236:
1237: j := j +1;
1238: END LOOP;

Line 1242: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Final MRs count for both Create and Delete::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);

1238: END LOOP;
1239: END IF;
1240:
1241: IF G_DEBUG = 'Y' THEN
1242: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Final MRs count for both Create and Delete::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);
1243: END IF;
1244:
1245: IF G_DEBUG = 'Y' THEN
1246: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );

Line 1246: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );

1242: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Final MRs count for both Create and Delete::After Copy to Asso Table :::'|| l_mr_sr_assoc_tbl.count);
1243: END IF;
1244:
1245: IF G_DEBUG = 'Y' THEN
1246: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Before Call to Process_SR_MR_Associations ' );
1247: END IF;
1248:
1249: -- Call Process Associations
1250: IF(l_mr_sr_assoc_tbl.count >0)

Line 1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );

1252: /** Input Table Params to Process -MR Associations */
1253: IF G_DEBUG = 'Y' THEN
1254: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
1255: LOOP
1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);

Line 1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);

1253: IF G_DEBUG = 'Y' THEN
1254: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
1255: LOOP
1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
1261: END LOOP;

Line 1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);

1254: FOR i IN l_mr_sr_assoc_tbl.FIRST..l_mr_sr_assoc_tbl.LAST
1255: LOOP
1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
1261: END LOOP;
1262: END IF;

Line 1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);

1255: LOOP
1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
1261: END LOOP;
1262: END IF;
1263:

Line 1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);

1256: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':: Association Table Parameter Values:: ' );
1257: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').mr_header_id::' || l_mr_sr_assoc_tbl(i).mr_header_id);
1258: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').operation_flag::' || l_mr_sr_assoc_tbl(i).operation_flag);
1259: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').object_version_number::' || l_mr_sr_assoc_tbl(i).object_version_number);
1260: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::l_mr_sr_assoc_tbl('||i||').csi_instance_id::' || l_mr_sr_assoc_tbl(i).csi_instance_id);
1261: END LOOP;
1262: END IF;
1263:
1264: AHL_UMP_SR_PVT.Process_SR_MR_Associations

Line 1284: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );

1280:
1281: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1282: THEN
1283: IF G_DEBUG = 'Y' THEN
1284: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1285: END IF;
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: END IF;

Line 1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Close/Cancel_SR Input Params::' );

1294: ELSE
1295: --l_nr_task_rec.status_id := 1178; -- Status Id for Cancelled
1296: l_nr_task_rec.status_id := 2; -- Status Id for Closed
1297: IF G_DEBUG = 'Y' THEN
1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Close/Cancel_SR Input Params::' );
1299: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.instance_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1300: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id::' || l_nr_task_rec.status_id );
1301: END IF;
1302:

Line 1299: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.instance_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);

1295: --l_nr_task_rec.status_id := 1178; -- Status Id for Cancelled
1296: l_nr_task_rec.status_id := 2; -- Status Id for Closed
1297: IF G_DEBUG = 'Y' THEN
1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Close/Cancel_SR Input Params::' );
1299: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.instance_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1300: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id::' || l_nr_task_rec.status_id );
1301: END IF;
1302:
1303: -- Call process Associations and delete the associations for already created SR

Line 1300: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id::' || l_nr_task_rec.status_id );

1296: l_nr_task_rec.status_id := 2; -- Status Id for Closed
1297: IF G_DEBUG = 'Y' THEN
1298: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Close/Cancel_SR Input Params::' );
1299: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::incident_id::' || l_nr_task_rec.instance_id || '::incident_object_version_number::'|| l_nr_task_rec.incident_object_version_number);
1300: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::status_id::' || l_nr_task_rec.status_id );
1301: END IF;
1302:
1303: -- Call process Associations and delete the associations for already created SR
1304: -- and then call update_st with closed status

Line 1317: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Already Added MRS Count to SR::'|| l_nr_task_rec.incident_id||':::'|| l_temp_reconfig_mr_id_tbl.count);

1313: FETCH get_sr_mr_headers BULK COLLECT INTO l_temp_reconfig_mr_id_tbl, l_temp_reconfig_mr_ue_ovn;
1314: CLOSE get_sr_mr_headers;
1315:
1316: IF G_DEBUG = 'Y' THEN
1317: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Already Added MRS Count to SR::'|| l_nr_task_rec.incident_id||':::'|| l_temp_reconfig_mr_id_tbl.count);
1318: END IF;
1319: -- Copy all the Reconfig MRS for which already SR is created
1320: IF(l_temp_reconfig_mr_id_tbl.count > 0)
1321: THEN

Line 1330: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::MRS list for delete associations to Close SR::'|| l_nr_task_rec.incident_id||':::'|| l_mr_sr_assoc_tbl.count);

1326: l_mr_sr_assoc_tbl(i).object_version_number := l_temp_reconfig_mr_ue_ovn(i);
1327: l_mr_sr_assoc_tbl(i).csi_instance_id := l_nr_task_rec.instance_id;
1328: END LOOP;
1329: IF G_DEBUG = 'Y' THEN
1330: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::MRS list for delete associations to Close SR::'|| l_nr_task_rec.incident_id||':::'|| l_mr_sr_assoc_tbl.count);
1331: END IF;
1332: END IF;
1333:
1334: -- Call Process Associations

Line 1357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );

1353:
1354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1355: THEN
1356: IF G_DEBUG = 'Y' THEN
1357: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Process_SR_MR_Associations is Failed' );
1358: END IF;
1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361: END IF;

Line 1380: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );

1376:
1377: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1378: THEN
1379: IF G_DEBUG = 'Y' THEN
1380: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || '::Call to AHL_UMP_NONROUTINES_PVT.Update_SR is Failed' );
1381: END IF;
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: END IF;
1384:

Line 1431: AHL_DEBUG_PUB.Debug('Err message-'||j||':' || substr(l_msg_data,1,240));

1427: p_msg_index_out => j );
1428:
1429: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||j||':' || l_msg_data);
1430: IF G_DEBUG = 'Y' THEN
1431: AHL_DEBUG_PUB.Debug('Err message-'||j||':' || substr(l_msg_data,1,240));
1432: END IF;
1433: END LOOP;
1434: fnd_file.put_line(FND_FILE.LOG, 'End of Warning messages');
1435:

Line 1450: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');

1446: COMMIT WORK;
1447: END IF;
1448:
1449: IF (G_DEBUG = 'Y') THEN
1450: AHL_DEBUG_PUB.debug('END - Successfully completion of '||G_PKG_NAME||'.'||l_api_name||' API ');
1451: END IF;
1452:
1453: -- Count and Get messages
1454: FND_MSG_PUB.count_and_get

Line 1462: AHL_DEBUG_PUB.disable_debug;

1458: );
1459:
1460: -- Disable debug (if enabled)
1461: IF (G_DEBUG = 'Y') THEN
1462: AHL_DEBUG_PUB.disable_debug;
1463: END IF;
1464:
1465: EXCEPTION
1466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN