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_SR_PVT dependencies on AHL_UMP_UTIL_PKG

Line 530: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_uc_hdr_id,nvl(l_exp_resolution_date,l_occurred_date),null)

526: X_LAST_UPDATE_DATE => sysdate,
527: X_LAST_UPDATED_BY => fnd_global.user_id,
528: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
529: -- BACHANDR - NR project start
530: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_uc_hdr_id,nvl(l_exp_resolution_date,l_occurred_date),null)
531: -- BACHANDR - NR project end
532: );
533:
534: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');

2038: CLOSE get_app_mr_table_count_csr;
2039: IF (l_temp_count > 0) THEN
2040: -- AHL_APPLICABLE_MRS is already populated. No need to Call Populate_Appl_MRs
2041: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');
2043: END IF;
2044: ELSE
2045: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);

Line 2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);

2042: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count || '. Not calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs.');
2043: END IF;
2044: ELSE
2045: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);
2047: END IF;
2048: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
2049: x_return_status => l_temp_return_status,
2050: x_msg_count => l_temp_msg_count,

Line 2048: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,

2044: ELSE
2045: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MRS is zero. Calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs with p_csi_ii_id = ' || p_csi_instance_id);
2047: END IF;
2048: AHL_UMP_UTIL_PKG.Populate_Appl_MRs(p_csi_ii_id => p_csi_instance_id,
2049: x_return_status => l_temp_return_status,
2050: x_msg_count => l_temp_msg_count,
2051: x_msg_data => l_temp_msg_data);
2052: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2067: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'After calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs, Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count);

2063: OPEN get_app_mr_table_count_csr;
2064: FETCH get_app_mr_table_count_csr INTO l_temp_count;
2065: CLOSE get_app_mr_table_count_csr;
2066: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'After calling AHL_UMP_UTIL_PKG.Populate_Appl_MRs, Number of records in AHL_APPLICABLE_MRS: ' || l_temp_count);
2068: END IF;
2069: END IF; -- AHL_APPLICABLE_MRS temp table is empty
2070:
2071: -- Call process_Group_MR_Instance

Line 2077: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_UMP_UTIL_PKG.process_Group_MR_Instance with p_top_mr_id = ' ||

2073: FETCH get_relns_table_count_csr INTO l_temp_count;
2074: CLOSE get_relns_table_count_csr;
2075: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2076: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS before processing: ' || l_temp_count);
2077: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_UMP_UTIL_PKG.process_Group_MR_Instance with p_top_mr_id = ' ||
2078: p_mr_header_id || ' and p_top_item_instance_id = ' || p_csi_instance_id);
2079: END IF;*/
2080: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(p_top_mr_id => p_mr_header_id,
2081: p_top_item_instance_id => p_csi_instance_id,

Line 2080: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(p_top_mr_id => p_mr_header_id,

2076: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS before processing: ' || l_temp_count);
2077: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_UMP_UTIL_PKG.process_Group_MR_Instance with p_top_mr_id = ' ||
2078: p_mr_header_id || ' and p_top_item_instance_id = ' || p_csi_instance_id);
2079: END IF;*/
2080: AHL_UMP_UTIL_PKG.process_Group_MR_Instance(p_top_mr_id => p_mr_header_id,
2081: p_top_item_instance_id => p_csi_instance_id,
2082: p_init_temp_table => G_YES_FLAG); -- To clean up temp table first
2083: /*OPEN get_relns_table_count_csr;
2084: FETCH get_relns_table_count_csr INTO l_temp_count;

Line 2087: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS after calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance: ' || l_temp_count);

2083: /*OPEN get_relns_table_count_csr;
2084: FETCH get_relns_table_count_csr INTO l_temp_count;
2085: CLOSE get_relns_table_count_csr;
2086: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Number of records in AHL_APPLICABLE_MR_RELNS after calling AHL_UMP_UTIL_PKG.process_Group_MR_Instance: ' || l_temp_count);
2088: END IF;*/
2089:
2090: -- Check for duplicates
2091: OPEN get_duplicate_mrs_csr(p_sr_ue_id => p_sr_ue_id);

Line 2318: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_curr_ue_rec.UNIT_CONFIG_HEADER_ID,p_new_due_date,null)

2314: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2315: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2316: X_LAST_UPDATE_LOGIN => fnd_global.login_id, -- Updated
2317: -- BACHANDR - NR project start
2318: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_curr_ue_rec.UNIT_CONFIG_HEADER_ID,p_new_due_date,null)
2319: -- BACHANDR - NR project end
2320: );
2321: l_temp_count := l_temp_count + 1;
2322: END LOOP;

Line 2418: AHL_UMP_UTIL_PKG.Get_Visit_Details(p_unit_effectivity_id => p_sr_ue_id,

2414: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Effectivity ' || p_sr_ue_id || ' has been assigned to a visit.');
2415: END IF;
2416: x_assigned_to_visit_flag := TRUE;
2417: -- Get the Visit Start Date
2418: AHL_UMP_UTIL_PKG.Get_Visit_Details(p_unit_effectivity_id => p_sr_ue_id,
2419: x_visit_Start_date => l_visit_start_date,
2420: x_visit_End_date => l_visit_end_date,
2421: x_visit_Assign_code => l_visit_assign_code);
2422: IF (p_new_due_date is not null and l_visit_start_date is not null and (l_visit_start_date > p_new_due_date)) THEN

Line 2518: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_curr_ue_rec.UNIT_CONFIG_HEADER_ID,nvl(l_temp_due_date,l_occurred_date),null)

2514: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2515: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2516: X_LAST_UPDATE_LOGIN => fnd_global.login_id, -- Updated
2517: -- BACHANDR - NR project start
2518: X_FLEET_HEADER_ID => AHL_UMP_UTIL_PKG.Get_Associated_Fleet(l_curr_ue_rec.UNIT_CONFIG_HEADER_ID,nvl(l_temp_due_date,l_occurred_date),null)
2519: -- BACHANDR - NR project end
2520: );
2521: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Effectivity ' || p_sr_ue_id || ' has been updated.');