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_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_DEBUG_PUB

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

2: /* $Header: AHLVUMEB.pls 120.8.12020000.3 2013/04/01 02:57:44 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_ProcessUnit_EXTN_PVT';
5: G_APPLN_USAGE_CODE CONSTANT VARCHAR2(30) := LTRIM(RTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
6: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
7:
8: -- number table.
9: TYPE nbr_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10:

Line 412: AHL_DEBUG_PUB.Debug('Start Flush from Temporary Table, p_uc_header_id = '||p_uc_header_id);

408: */
409: BEGIN
410:
411: IF G_DEBUG = 'Y' THEN
412: AHL_DEBUG_PUB.Debug('Start Flush from Temporary Table, p_uc_header_id = '||p_uc_header_id);
413: END IF;
414:
415: -- JKJain, NR Analysis and Forecasting
416: G_UC_HEADER_ID := p_uc_header_id;

Line 424: AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');

420:
421:
422: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N') THEN
423: IF G_DEBUG = 'Y' THEN
424: AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');
425: END IF;
426:
427: -- Process deferral and SR records.
428: Flush_Unit_SR_Deferrals;

Line 431: AHL_DEBUG_PUB.Debug('End Deferral-SR Processing');

427: -- Process deferral and SR records.
428: Flush_Unit_SR_Deferrals;
429:
430: IF G_DEBUG = 'Y' THEN
431: AHL_DEBUG_PUB.Debug('End Deferral-SR Processing');
432: END IF;
433: END IF;
434:
435: -- Read temporary table.

Line 729: AHL_DEBUG_PUB.Debug('End Process of all MRs from temp table');

725:
726: END LOOP; /* for temp_individual_mrs_csr */
727:
728: IF G_DEBUG = 'Y' THEN
729: AHL_DEBUG_PUB.Debug('End Process of all MRs from temp table');
730: END IF;
731:
732: -- bypass processing preceding_ue_ids and deferrals for Preventive Maintenance.
733: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N') THEN

Line 850: AHL_DEBUG_PUB.Debug('End Preceding MR processing');

846: CLOSE preceding_mr_csr;
847: END LOOP;
848:
849: IF G_DEBUG = 'Y' THEN
850: AHL_DEBUG_PUB.Debug('End Preceding MR processing');
851: --AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');
852: AHL_DEBUG_PUB.Debug('Start Update of Terminating MR..');
853: END IF;
854:

Line 851: --AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');

847: END LOOP;
848:
849: IF G_DEBUG = 'Y' THEN
850: AHL_DEBUG_PUB.Debug('End Preceding MR processing');
851: --AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');
852: AHL_DEBUG_PUB.Debug('Start Update of Terminating MR..');
853: END IF;
854:
855: -- Added for SB Enhancements for accomplishment trigger type = TERMINATED_BY

Line 852: AHL_DEBUG_PUB.Debug('Start Update of Terminating MR..');

848:
849: IF G_DEBUG = 'Y' THEN
850: AHL_DEBUG_PUB.Debug('End Preceding MR processing');
851: --AHL_DEBUG_PUB.Debug('Start Deferral-SR Processing');
852: AHL_DEBUG_PUB.Debug('Start Update of Terminating MR..');
853: END IF;
854:
855: -- Added for SB Enhancements for accomplishment trigger type = TERMINATED_BY
856: BEGIN

Line 869: AHL_DEBUG_PUB.Debug('Updating for MR:CSI:TERM_MR:' || l_mr_id_tbl(i) || ':' || l_ii_id_tbl(i) || ':' || l_term_mr_id_tbl(i));

865:
866: IF (l_term_mr_id_tbl.count > 0) THEN
867: FOR i IN l_term_mr_id_tbl.first..l_term_mr_id_tbl.last LOOP
868: IF G_DEBUG = 'Y' THEN
869: AHL_DEBUG_PUB.Debug('Updating for MR:CSI:TERM_MR:' || l_mr_id_tbl(i) || ':' || l_ii_id_tbl(i) || ':' || l_term_mr_id_tbl(i));
870: END IF;
871:
872: BEGIN
873:

Line 908: AHL_DEBUG_PUB.Debug('End Update of Terminating MR..');

904: Flush_Unit_SR_Deferrals;
905: */
906:
907: IF G_DEBUG = 'Y' THEN
908: AHL_DEBUG_PUB.Debug('End Update of Terminating MR..');
909: AHL_DEBUG_PUB.Debug('Starting Flush_Loop_Effectivities ...');
910: END IF;
911:
912: -- process trigger type = 'LOOP'

Line 909: AHL_DEBUG_PUB.Debug('Starting Flush_Loop_Effectivities ...');

905: */
906:
907: IF G_DEBUG = 'Y' THEN
908: AHL_DEBUG_PUB.Debug('End Update of Terminating MR..');
909: AHL_DEBUG_PUB.Debug('Starting Flush_Loop_Effectivities ...');
910: END IF;
911:
912: -- process trigger type = 'LOOP'
913: Flush_Loop_Effectivities;

Line 922: --AHL_DEBUG_PUB.Debug('End Deferral-SR processing');

918:
919: END IF; -- IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N')
920:
921: IF G_DEBUG = 'Y' THEN
922: --AHL_DEBUG_PUB.Debug('End Deferral-SR processing');
923:
924: AHL_DEBUG_PUB.Debug('Start Exception Processing');
925: END IF;
926:

Line 924: AHL_DEBUG_PUB.Debug('Start Exception Processing');

920:
921: IF G_DEBUG = 'Y' THEN
922: --AHL_DEBUG_PUB.Debug('End Deferral-SR processing');
923:
924: AHL_DEBUG_PUB.Debug('Start Exception Processing');
925: END IF;
926:
927: -- Now read ahl_unit_effectivities
928: -- for records with date_run < l_startTime.

Line 938: AHL_DEBUG_PUB.Debug('Exception for unit effectivity ID:' || exception_rec.unit_effectivity_id);

934:
935: FOR exception_rec IN ahl_exception_csr(l_csi_item_instance_id, l_start_time) LOOP
936:
937: IF G_DEBUG = 'Y' THEN
938: AHL_DEBUG_PUB.Debug('Exception for unit effectivity ID:' || exception_rec.unit_effectivity_id);
939: END IF;
940:
941: -- Initialize.
942: l_exception_upd_flag := FALSE;

Line 951: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);

947: -- If status code is INIT-DUE mark as exception.
948: IF (exception_rec.status_code = 'INIT-DUE') THEN
949: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
950: IF G_DEBUG = 'Y' THEN
951: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
952: END IF;
953:
954: -- If visit is in released and closed status then, do not mark exception or deletion.
955: IF (l_visit_status_code IS NOT NULL AND l_visit_status_code = 'PLANNING') THEN

Line 960: AHL_DEBUG_PUB.Debug('Exception - Init-Due');

956: l_exception_upd_flag := TRUE;
957: l_exception_code := 'INIT-DUE';
958:
959: IF G_DEBUG = 'Y' THEN
960: AHL_DEBUG_PUB.Debug('Exception - Init-Due');
961: END IF;
962: ELSIF (l_visit_status_code IS NULL) THEN -- not assigned to visit
963: l_delete_flag := TRUE;
964: ELSE -- on shop floor

Line 985: AHL_DEBUG_PUB.Debug('Exception - Init-Accomplished');

981: l_exception_upd_flag := TRUE;
982: l_exception_code := 'INIT-ACCOMPLISHED';
983:
984: IF G_DEBUG = 'Y' THEN
985: AHL_DEBUG_PUB.Debug('Exception - Init-Accomplished');
986: END IF;
987: END IF;
988:
989: ELSIF (exception_rec.status_code = 'DEFERRED') THEN

Line 994: AHL_DEBUG_PUB.Debug('Exception - Deferred');

990: l_exception_upd_flag := TRUE;
991: l_exception_code := 'DEFERRED';
992:
993: IF G_DEBUG = 'Y' THEN
994: AHL_DEBUG_PUB.Debug('Exception - Deferred');
995: END IF;
996:
997: ELSIF (exception_rec.status_code = 'EXCEPTION' AND
998: exception_rec.message_code = 'INIT-DUE'

Line 1012: AHL_DEBUG_PUB.Debug('Exception - Init-Due');

1008: IF (exception_init_due_csr%FOUND) THEN
1009: l_exception_upd_flag := TRUE;
1010: l_exception_code := exception_rec.message_code;
1011: IF G_DEBUG = 'Y' THEN
1012: AHL_DEBUG_PUB.Debug('Exception - Init-Due');
1013: END IF;
1014: END IF;
1015: CLOSE exception_init_due_csr;
1016: END IF;

Line 1024: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);

1020: -- check if assigned to visit if not flagged for exception.
1021: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N') THEN -- AHL Installation.
1022: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
1023: IF G_DEBUG = 'Y' THEN
1024: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
1025: END IF;
1026:
1027: -- If visit is in released and closed status then, do not mark exception or deletion.
1028: IF (l_visit_status_code IS NOT NULL) THEN

Line 1035: AHL_DEBUG_PUB.Debug('Exception - Init-Due');

1031: l_exception_upd_flag := TRUE;
1032: l_exception_code := 'INIT-DUE';
1033:
1034: IF G_DEBUG = 'Y' THEN
1035: AHL_DEBUG_PUB.Debug('Exception - Init-Due');
1036: END IF;
1037:
1038: ELSE
1039: l_exception_upd_flag := TRUE;

Line 1042: AHL_DEBUG_PUB.Debug('Exception - Visit Assign');

1038: ELSE
1039: l_exception_upd_flag := TRUE;
1040: l_exception_code := 'VISIT-ASSIGN';
1041: IF G_DEBUG = 'Y' THEN
1042: AHL_DEBUG_PUB.Debug('Exception - Visit Assign');
1043: END IF;
1044: END IF;
1045:
1046: ELSE

Line 1083: AHL_DEBUG_PUB.Debug('Service request ID-NUM is:' || l_incident_id || '-' || l_incident_number);

1079: l_incident_id,
1080: l_incident_number,
1081: l_scheduled_date);
1082: IF G_DEBUG = 'Y' THEN
1083: AHL_DEBUG_PUB.Debug('Service request ID-NUM is:' || l_incident_id || '-' || l_incident_number);
1084: END IF;
1085:
1086: IF (l_incident_id IS NOT NULL) THEN
1087: l_delete_flag := FALSE;

Line 1097: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN

1093: exception_rec.due_date);
1094: FETCH valid_due_date_csr INTO l_junk;
1095: IF(valid_due_date_csr%FOUND)THEN
1096: l_delete_flag := FALSE;
1097: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1098: AHL_DEBUG_PUB.Debug('Service Line Expired for UE with due date < termination/end date. Will not delete');
1099: END IF;
1100: END IF;
1101: CLOSE valid_due_date_csr;

Line 1098: AHL_DEBUG_PUB.Debug('Service Line Expired for UE with due date < termination/end date. Will not delete');

1094: FETCH valid_due_date_csr INTO l_junk;
1095: IF(valid_due_date_csr%FOUND)THEN
1096: l_delete_flag := FALSE;
1097: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1098: AHL_DEBUG_PUB.Debug('Service Line Expired for UE with due date < termination/end date. Will not delete');
1099: END IF;
1100: END IF;
1101: CLOSE valid_due_date_csr;
1102: END IF; -- exception_rec.due_date IS NOT NULL

Line 1108: AHL_DEBUG_PUB.Debug('Updating exception code..');

1104: END IF; -- AHL Installation.
1105:
1106: IF (l_exception_upd_flag) THEN
1107: IF G_DEBUG = 'Y' THEN
1108: AHL_DEBUG_PUB.Debug('Updating exception code..');
1109: END IF;
1110:
1111: -- added for SB Enh
1112: IF (l_upd_terminate_flag) THEN

Line 1266: AHL_DEBUG_PUB.Debug('Deleting exception code..');

1262:
1263: ELSIF (l_delete_flag) THEN
1264:
1265: IF G_DEBUG = 'Y' THEN
1266: AHL_DEBUG_PUB.Debug('Deleting exception code..');
1267: END IF;
1268:
1269: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP
1270:

Line 1288: AHL_DEBUG_PUB.Debug('Exception - Init-Due');

1284:
1285: IF (exception_rec.status_code = 'INIT-DUE' OR
1286: exception_rec.message_code = 'INIT-DUE') THEN
1287: IF G_DEBUG = 'Y' THEN
1288: AHL_DEBUG_PUB.Debug('Exception - Init-Due');
1289: END IF;
1290:
1291: OPEN exception_init_due_csr (exception_rec.unit_effectivity_id);
1292: FETCH exception_init_due_csr INTO l_unit_deferral_id;

Line 1319: AHL_DEBUG_PUB.Debug('End Flush from temporary table.');

1315: AND status_code = 'ACTIVE'
1316: AND simulation_type = 'UMP';
1317:
1318: IF G_DEBUG = 'Y' THEN
1319: AHL_DEBUG_PUB.Debug('End Flush from temporary table.');
1320: END IF;
1321:
1322:
1323: END Flush_From_Temp_table;

Line 1337: AHL_DEBUG_PUB.Debug('Start Create Record');

1333:
1334: BEGIN
1335:
1336: IF G_DEBUG = 'Y' THEN
1337: AHL_DEBUG_PUB.Debug('Start Create Record');
1338: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_mr_rec.csi_item_instance_id || ',' || p_x_temp_mr_rec.MR_header_id);
1339: END IF;
1340:
1341: -- Default object type and application usage values.

Line 1338: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_mr_rec.csi_item_instance_id || ',' || p_x_temp_mr_rec.MR_header_id);

1334: BEGIN
1335:
1336: IF G_DEBUG = 'Y' THEN
1337: AHL_DEBUG_PUB.Debug('Start Create Record');
1338: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_mr_rec.csi_item_instance_id || ',' || p_x_temp_mr_rec.MR_header_id);
1339: END IF;
1340:
1341: -- Default object type and application usage values.
1342:

Line 1417: AHL_DEBUG_PUB.Debug('End Create Record');

1413: start_lc_ue_id = p_x_temp_mr_rec.start_lc_ue_id
1414: WHERE rowid = l_rowid;
1415:
1416: IF G_DEBUG = 'Y' THEN
1417: AHL_DEBUG_PUB.Debug('End Create Record');
1418: END IF;
1419:
1420:
1421: EXCEPTION

Line 1441: AHL_DEBUG_PUB.Debug('Start Update Record-' || p_mr_rec.unit_effectivity_id);

1437:
1438: BEGIN
1439:
1440: IF G_DEBUG = 'Y' THEN
1441: AHL_DEBUG_PUB.Debug('Start Update Record-' || p_mr_rec.unit_effectivity_id);
1442: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1443: END IF;
1444:
1445: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

Line 1442: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);

1438: BEGIN
1439:
1440: IF G_DEBUG = 'Y' THEN
1441: AHL_DEBUG_PUB.Debug('Start Update Record-' || p_mr_rec.unit_effectivity_id);
1442: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1443: END IF;
1444:
1445: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
1446: X_UNIT_EFFECTIVITY_ID => p_mr_rec.unit_effectivity_id,

Line 1520: AHL_DEBUG_PUB.Debug('End Update Record');

1516: Delete_Sch_Materials(p_mr_rec.unit_effectivity_id);
1517: END IF;
1518:
1519: IF G_DEBUG = 'Y' THEN
1520: AHL_DEBUG_PUB.Debug('End Update Record');
1521: END IF;
1522:
1523: EXCEPTION
1524: -- If any error occurs, then, abort API.

Line 1604: AHL_DEBUG_PUB.Debug('Start Create Group');

1600:
1601: BEGIN
1602:
1603: IF G_DEBUG = 'Y' THEN
1604: AHL_DEBUG_PUB.Debug('Start Create Group');
1605: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_grp_rec.csi_item_instance_id || ',' || p_x_temp_grp_rec.MR_header_id);
1606: END IF;
1607:
1608: -- For top node.

Line 1605: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_grp_rec.csi_item_instance_id || ',' || p_x_temp_grp_rec.MR_header_id);

1601: BEGIN
1602:
1603: IF G_DEBUG = 'Y' THEN
1604: AHL_DEBUG_PUB.Debug('Start Create Group');
1605: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_grp_rec.csi_item_instance_id || ',' || p_x_temp_grp_rec.MR_header_id);
1606: END IF;
1607:
1608: -- For top node.
1609: Create_Record (p_x_temp_grp_rec);

Line 1717: AHL_DEBUG_PUB.Debug('End Create Group');

1713:
1714: END LOOP;
1715:
1716: IF G_DEBUG = 'Y' THEN
1717: AHL_DEBUG_PUB.Debug('End Create Group');
1718: END IF;
1719:
1720: EXCEPTION
1721: -- If any error occurs, then, abort API.

Line 1890: AHL_DEBUG_PUB.Debug('Start Update Group');

1886:
1887: BEGIN
1888:
1889: IF G_DEBUG = 'Y' THEN
1890: AHL_DEBUG_PUB.Debug('Start Update Group');
1891: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1892: END IF;
1893:
1894: -- Set savepoint.

Line 1891: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);

1887: BEGIN
1888:
1889: IF G_DEBUG = 'Y' THEN
1890: AHL_DEBUG_PUB.Debug('Start Update Group');
1891: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1892: END IF;
1893:
1894: -- Set savepoint.
1895: SAVEPOINT update_group;

Line 2127: AHL_DEBUG_PUB.Debug('End Update Group');

2123:
2124: END IF;
2125:
2126: IF G_DEBUG = 'Y' THEN
2127: AHL_DEBUG_PUB.Debug('End Update Group');
2128: END IF;
2129:
2130:
2131: EXCEPTION

Line 2313: AHL_DEBUG_PUB.Debug('Start Unit Sr Deferrals');

2309:
2310: BEGIN
2311:
2312: IF G_DEBUG = 'Y' THEN
2313: AHL_DEBUG_PUB.Debug('Start Unit Sr Deferrals');
2314: END IF;
2315:
2316: FOR unit_sr_def_rec IN ahl_unit_sr_def_csr LOOP
2317: IF G_DEBUG = 'Y' THEN

Line 2318: AHL_DEBUG_PUB.Debug('UE_ID:' || unit_sr_def_rec.unit_effectivity_id);

2314: END IF;
2315:
2316: FOR unit_sr_def_rec IN ahl_unit_sr_def_csr LOOP
2317: IF G_DEBUG = 'Y' THEN
2318: AHL_DEBUG_PUB.Debug('UE_ID:' || unit_sr_def_rec.unit_effectivity_id);
2319: END IF;
2320:
2321: -- JKJain, NR Analysis and Forecasting
2322: l_fleet_header_id := null;

Line 2329: AHL_DEBUG_PUB.Debug('Group flag match');

2325: l_unit_effectivity_rec.fleet_header_id := l_fleet_header_id;
2326: END IF;
2327: IF (unit_sr_def_rec.group_match_flag = 'Y') THEN
2328: IF G_DEBUG = 'Y' THEN
2329: AHL_DEBUG_PUB.Debug('Group flag match');
2330: END IF;
2331:
2332:
2333: -- update unit effectivities with due date and tolerance info.

Line 2353: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);

2349: l_unit_effectivity_rec.counter_id := unit_sr_def_rec.counter_id;
2350:
2351: -- update record.
2352: IF G_DEBUG = 'Y' THEN
2353: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2354: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || unit_sr_def_rec.MR_header_id);
2355: END IF;
2356:
2357: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

Line 2354: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || unit_sr_def_rec.MR_header_id);

2350:
2351: -- update record.
2352: IF G_DEBUG = 'Y' THEN
2353: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2354: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || unit_sr_def_rec.MR_header_id);
2355: END IF;
2356:
2357: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
2358: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,

Line 2446: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);

2442: l_unit_effectivity_rec.counter_id := unit_sr_def_rec.counter_id;
2443:
2444: -- update record.
2445: IF G_DEBUG = 'Y' THEN
2446: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2447: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2448: END IF;
2449:
2450: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

Line 2447: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);

2443:
2444: -- update record.
2445: IF G_DEBUG = 'Y' THEN
2446: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2447: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2448: END IF;
2449:
2450: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
2451: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,

Line 2544: AHL_DEBUG_PUB.Debug('Insert Record-');

2540: l_index := l_index + 1;
2541: l_delete_ue_id_tbl(l_index) := unit_sr_def_rec.unit_effectivity_id;
2542:
2543: IF G_DEBUG = 'Y' THEN
2544: AHL_DEBUG_PUB.Debug('Insert Record-');
2545: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2546: END IF;
2547:
2548: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

Line 2545: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);

2541: l_delete_ue_id_tbl(l_index) := unit_sr_def_rec.unit_effectivity_id;
2542:
2543: IF G_DEBUG = 'Y' THEN
2544: AHL_DEBUG_PUB.Debug('Insert Record-');
2545: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2546: END IF;
2547:
2548: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2549: X_ROWID => l_rowid,

Line 2956: AHL_DEBUG_PUB.Debug('End Unit Sr Deferrals');

2952: END LOOP;
2953: END IF;
2954:
2955: IF G_DEBUG = 'Y' THEN
2956: AHL_DEBUG_PUB.Debug('End Unit Sr Deferrals');
2957: END IF;
2958:
2959: END Flush_Unit_SR_Deferrals;
2960:

Line 2975: AHL_DEBUG_PUB.Debug('Start Delete_Sch_Materials for UE:' || p_unit_effectivity_id,'UMP-ProcessUnit');

2971:
2972: BEGIN
2973:
2974: IF G_DEBUG = 'Y' THEN
2975: AHL_DEBUG_PUB.Debug('Start Delete_Sch_Materials for UE:' || p_unit_effectivity_id,'UMP-ProcessUnit');
2976: END IF;
2977:
2978: FOR sch_material_rec IN ahl_sch_material_csr(p_unit_effectivity_id) LOOP
2979: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => sch_material_rec.scheduled_material_id);

Line 2984: AHL_DEBUG_PUB.Debug('End Delete_Sch_Materials');

2980:
2981: END LOOP;
2982:
2983: IF G_DEBUG = 'Y' THEN
2984: AHL_DEBUG_PUB.Debug('End Delete_Sch_Materials');
2985: END IF;
2986:
2987: END Delete_Sch_Materials;
2988: ------------------------------------------------------------

Line 3110: AHL_DEBUG_PUB.Debug('Starting Flush_Loop_Effectivities ...for:' || l_start_mr_tbl(k));

3106:
3107: FOR k IN l_start_mr_tbl.FIRST..l_start_mr_tbl.LAST LOOP
3108:
3109: IF G_DEBUG = 'Y' THEN
3110: AHL_DEBUG_PUB.Debug('Starting Flush_Loop_Effectivities ...for:' || l_start_mr_tbl(k));
3111: END IF;
3112:
3113: l_upd_ue_cnt := 0;
3114: l_add_ue_cnt := 0;

Line 3362: AHL_DEBUG_PUB.Debug('End Flush_Loop_Effectivities');

3358:
3359: END LOOP; -- next start mr.(k loop)
3360:
3361: IF G_DEBUG = 'Y' THEN
3362: AHL_DEBUG_PUB.Debug('End Flush_Loop_Effectivities');
3363: END IF;
3364:
3365: END Flush_Loop_Effectivities;
3366: -------------------------------------

Line 3511: AHL_DEBUG_PUB.Debug('Starting Flush_Chain_Effectivities ...for:' || l_start_mr_tbl(k));

3507:
3508: FOR k IN l_start_mr_tbl.FIRST..l_start_mr_tbl.LAST LOOP
3509:
3510: IF G_DEBUG = 'Y' THEN
3511: AHL_DEBUG_PUB.Debug('Starting Flush_Chain_Effectivities ...for:' || l_start_mr_tbl(k));
3512: END IF;
3513:
3514: l_upd_ue_cnt := 0;
3515: l_add_ue_cnt := 0;

Line 3775: AHL_DEBUG_PUB.Debug('End Flush_Chain_Effectivities');

3771:
3772: END LOOP; -- next start mr.(k loop)
3773:
3774: IF G_DEBUG = 'Y' THEN
3775: AHL_DEBUG_PUB.Debug('End Flush_Chain_Effectivities');
3776: END IF;
3777:
3778: END Flush_Chain_Effectivities;
3779:

Line 3911: AHL_DEBUG_PUB.Debug('Start Flush_To_Sim_Ue_Table Simulation = ' || p_simulation_plan_id || ' and Unit = '||p_uc_header_id,'Flush_To_Sim_Ue_Table');

3907:
3908: BEGIN
3909:
3910: IF G_DEBUG = 'Y' THEN
3911: AHL_DEBUG_PUB.Debug('Start Flush_To_Sim_Ue_Table Simulation = ' || p_simulation_plan_id || ' and Unit = '||p_uc_header_id,'Flush_To_Sim_Ue_Table');
3912: END IF;
3913: G_UC_HEADER_ID := p_uc_header_id;
3914: G_SIMULATION_PLAN_ID := p_simulation_plan_id;
3915: -- record start time.

Line 4107: AHL_DEBUG_PUB.Debug('End Process Flush_To_Sim_Ue_Table');

4103: SET LAST_BUE_RUN = sysdate
4104: WHERE simulation_plan_id = p_simulation_plan_id;
4105:
4106: IF G_DEBUG = 'Y' THEN
4107: AHL_DEBUG_PUB.Debug('End Process Flush_To_Sim_Ue_Table');
4108: END IF;
4109:
4110:
4111: END Flush_To_Sim_Ue_Table;

Line 4122: AHL_DEBUG_PUB.Debug('Start Create Record in Sim UE Table');

4118: BEGIN
4119:
4120:
4121: IF G_DEBUG = 'Y' THEN
4122: AHL_DEBUG_PUB.Debug('Start Create Record in Sim UE Table');
4123: END IF;
4124:
4125:
4126: INSERT INTO AHL_UE_SIMULATIONS (

Line 4195: AHL_DEBUG_PUB.Debug('End Create Record');

4191: p_x_temp_sim_ue_rec.PARENT_UE_ID
4192: );
4193:
4194: IF G_DEBUG = 'Y' THEN
4195: AHL_DEBUG_PUB.Debug('End Create Record');
4196: END IF;
4197:
4198:
4199:

Line 4282: AHL_DEBUG_PUB.Debug('Start Create Group For Simulation UEs');

4278: BEGIN
4279:
4280:
4281: IF G_DEBUG = 'Y' THEN
4282: AHL_DEBUG_PUB.Debug('Start Create Group For Simulation UEs');
4283: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_sim_ue_rec.csi_item_instance_id || ',' || p_x_temp_sim_ue_rec.MR_header_id);
4284: END IF;
4285:
4286: -- For top node.

Line 4283: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_sim_ue_rec.csi_item_instance_id || ',' || p_x_temp_sim_ue_rec.MR_header_id);

4279:
4280:
4281: IF G_DEBUG = 'Y' THEN
4282: AHL_DEBUG_PUB.Debug('Start Create Group For Simulation UEs');
4283: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_x_temp_sim_ue_rec.csi_item_instance_id || ',' || p_x_temp_sim_ue_rec.MR_header_id);
4284: END IF;
4285:
4286: -- For top node.
4287: create_sim_ue_record (p_x_temp_sim_ue_rec);

Line 4370: AHL_DEBUG_PUB.Debug('End Create Group');

4366:
4367: END LOOP;
4368:
4369: IF G_DEBUG = 'Y' THEN
4370: AHL_DEBUG_PUB.Debug('End Create Group');
4371: END IF;
4372:
4373: EXCEPTION
4374: -- If any error occurs, then, abort API.

Line 4421: AHL_DEBUG_PUB.Debug('Start Create_simue_from_ue_record');

4417: l_temp_sim_ue_rec ahl_ue_simulations%ROWTYPE;
4418: BEGIN
4419:
4420: IF G_DEBUG = 'Y' THEN
4421: AHL_DEBUG_PUB.Debug('Start Create_simue_from_ue_record');
4422: END IF;
4423:
4424: OPEN get_ue_details_csr(p_unit_effectivity_id);
4425: FETCH get_ue_details_csr INTO l_temp_ue_rec;

Line 4483: AHL_DEBUG_PUB.Debug('End Create Record');

4479: END IF;
4480: CLOSE get_ue_details_csr;
4481:
4482: IF G_DEBUG = 'Y' THEN
4483: AHL_DEBUG_PUB.Debug('End Create Record');
4484: END IF;
4485:
4486:
4487: