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

Line 125: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

121: l_mr_header_id NUMBER;
122: l_index NUMBER;
123: i NUMBER;
124: l_inst_attri get_inst_attri%ROWTYPE;
125: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
126: l_error_flag VARCHAR2(1) :='N';
127: --check whether the given mr exists
128: CURSOR check_mr_exists(c_mr_header_id number)
129: IS

Line 773: AHL_DEBUG_PUB.enable_debug;

769: l_counter number;
770: BEGIN
771: SAVEPOINT GET_MR_AFFECTED_ITEMS_PVT;
772: IF l_debug = 'Y' THEN
773: AHL_DEBUG_PUB.enable_debug;
774: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
775: END IF;
776: IF FND_API.to_boolean(p_init_msg_list) THEN
777: FND_MSG_PUB.initialize;

Line 774: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

770: BEGIN
771: SAVEPOINT GET_MR_AFFECTED_ITEMS_PVT;
772: IF l_debug = 'Y' THEN
773: AHL_DEBUG_PUB.enable_debug;
774: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
775: END IF;
776: IF FND_API.to_boolean(p_init_msg_list) THEN
777: FND_MSG_PUB.initialize;
778: END IF;

Line 788: AHL_DEBUG_PUB.debug(' Phase 1');

784: THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787: -- Check whether the mr_header_id exists --
788: AHL_DEBUG_PUB.debug(' Phase 1');
789:
790: DELETE FROM ahl_mr_instances_temp;
791: DELETE FROM ahl_applicable_instances;
792:

Line 802: AHL_DEBUG_PUB.debug(' Phase 2');

798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801: CLOSE check_mr_exists;
802: AHL_DEBUG_PUB.debug(' Phase 2');
803:
804: -- Check whether the mr_effectivity_id exists and if it does, check whether it
805: -- belongs to the mr_header_id
806: OPEN check_mr_effect(p_mr_effectivity_id,p_mr_header_id);

Line 826: AHL_DEBUG_PUB.debug(' After Call to MC path positions');

822: x_msg_data =>l_msg_data
823: );
824:
825: IF l_debug = 'Y' THEN
826: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
827: Select count(*) into l_counter
828: from ahl_applicable_instances;
829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
830: END IF;

Line 829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);

825: IF l_debug = 'Y' THEN
826: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
827: Select count(*) into l_counter
828: from ahl_applicable_instances;
829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
830: END IF;
831: END IF;
832: l_mr_header_id := l_mr_effect.mr_header_id;
833:

Line 846: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);

842: IF L_ERROR_FLAG='Y'
843: THEN
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);
847:
848: -- To avoid being in the same database session when refreshing or table navigating
849: -- the same page due to using the global temporary table.
850: AHL_DEBUG_PUB.debug(' Phase 4');

Line 850: AHL_DEBUG_PUB.debug(' Phase 4');

846: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);
847:
848: -- To avoid being in the same database session when refreshing or table navigating
849: -- the same page due to using the global temporary table.
850: AHL_DEBUG_PUB.debug(' Phase 4');
851: l_index :=1;
852:
853: -- apattark changes for SB start
854: OPEN get_terminating_mr_csr(p_mr_header_id);

Line 863: AHL_DEBUG_PUB.debug(' Phase 8');

859: FOR l_mr_effect IN get_mr_effect(p_mr_header_id, p_mr_effectivity_id)
860: LOOP
861: IF (l_mr_effect.inventory_item_id IS NOT NULL AND l_mr_effect.relationship_id IS NULL
862: AND l_mr_effect.pc_node_id IS NULL) THEN
863: AHL_DEBUG_PUB.debug(' Phase 8');
864: --DBMS_OUTPUT.put_line('API1: Come here in case 1B and l_index is: '||l_index);
865: FOR l_get_inst1 IN get_inst1(l_mr_effect.inventory_item_id)
866: LOOP
867: AHL_DEBUG_PUB.debug(' Phase 9, l_mr_effect.inventory_item_id = '||l_mr_effect.inventory_item_id);

Line 867: AHL_DEBUG_PUB.debug(' Phase 9, l_mr_effect.inventory_item_id = '||l_mr_effect.inventory_item_id);

863: AHL_DEBUG_PUB.debug(' Phase 8');
864: --DBMS_OUTPUT.put_line('API1: Come here in case 1B and l_index is: '||l_index);
865: FOR l_get_inst1 IN get_inst1(l_mr_effect.inventory_item_id)
866: LOOP
867: AHL_DEBUG_PUB.debug(' Phase 9, l_mr_effect.inventory_item_id = '||l_mr_effect.inventory_item_id);
868: IF (check_effectivity_details(l_get_inst1.instance_id, l_mr_effect.mr_effectivity_id )
869: AND check_effectivity_ext_details(l_get_inst1.instance_id, l_mr_effect.mr_effectivity_id )) THEN
870: x_mr_item_inst_tbl(l_index).item_instance_id := l_get_inst1.instance_id;
871: x_mr_item_inst_tbl(l_index).mr_effectivity_id := l_mr_effect.mr_effectivity_id;

Line 874: AHL_DEBUG_PUB.debug(' Phase 10, l_get_inst1.instance_id = '||l_get_inst1.instance_id);

870: x_mr_item_inst_tbl(l_index).item_instance_id := l_get_inst1.instance_id;
871: x_mr_item_inst_tbl(l_index).mr_effectivity_id := l_mr_effect.mr_effectivity_id;
872: l_index := l_index+1;
873: END IF;
874: AHL_DEBUG_PUB.debug(' Phase 10, l_get_inst1.instance_id = '||l_get_inst1.instance_id);
875: END LOOP;
876: ELSIF (l_mr_effect.relationship_id IS NOT NULL
877: AND l_mr_effect.inventory_item_id IS NULL
878: AND l_mr_effect.pc_node_id IS NULL)

Line 1012: AHL_DEBUG_PUB.debug(' l_fleet_header_id = ' || l_fleet_header_id|| ' and uc_header_id = '||x_mr_item_inst_tbl(i).uc_header_id || ' and item_instance_id = ' || x_mr_item_inst_tbl(i).item_instance_id);

1008: FETCH get_fleet_header_id into l_fleet_header_id;
1009: CLOSE get_fleet_header_id;
1010:
1011: IF(l_fleet_header_id IS NOT NULL) THEN
1012: AHL_DEBUG_PUB.debug(' l_fleet_header_id = ' || l_fleet_header_id|| ' and uc_header_id = '||x_mr_item_inst_tbl(i).uc_header_id || ' and item_instance_id = ' || x_mr_item_inst_tbl(i).item_instance_id);
1013: IF(x_mr_item_inst_tbl(i).uc_header_id IS NOT NULL) THEN
1014:
1015: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(x_mr_item_inst_tbl(i).uc_header_id,p_flt_range_calc_date,null),-1)) THEN
1016: AHL_DEBUG_PUB.debug(' Not Found , x_mr_item_inst_tbl(i).mr_effectivity_id = ' ||x_mr_item_inst_tbl(i).mr_effectivity_id);

Line 1016: AHL_DEBUG_PUB.debug(' Not Found , x_mr_item_inst_tbl(i).mr_effectivity_id = ' ||x_mr_item_inst_tbl(i).mr_effectivity_id);

1012: AHL_DEBUG_PUB.debug(' l_fleet_header_id = ' || l_fleet_header_id|| ' and uc_header_id = '||x_mr_item_inst_tbl(i).uc_header_id || ' and item_instance_id = ' || x_mr_item_inst_tbl(i).item_instance_id);
1013: IF(x_mr_item_inst_tbl(i).uc_header_id IS NOT NULL) THEN
1014:
1015: IF(l_fleet_header_id <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(x_mr_item_inst_tbl(i).uc_header_id,p_flt_range_calc_date,null),-1)) THEN
1016: AHL_DEBUG_PUB.debug(' Not Found , x_mr_item_inst_tbl(i).mr_effectivity_id = ' ||x_mr_item_inst_tbl(i).mr_effectivity_id);
1017: x_mr_item_inst_tbl.DELETE(i);
1018: END IF;
1019:
1020: ELSE

Line 1182: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1178: --IF FND_API.TO_BOOLEAN(p_commit) THEN
1179: -- COMMIT;
1180: --END IF;
1181: IF l_debug = 'Y' THEN
1182: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1183: AHL_DEBUG_PUB.disable_debug;
1184: END IF;
1185: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1183: AHL_DEBUG_PUB.disable_debug;

1179: -- COMMIT;
1180: --END IF;
1181: IF l_debug = 'Y' THEN
1182: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1183: AHL_DEBUG_PUB.disable_debug;
1184: END IF;
1185: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1192: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1188: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,
1190: p_data => x_msg_data);
1191: IF l_debug = 'Y' THEN
1192: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1193: 'UNEXPECTED ERROR IN PRIVATE:' );
1194: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1195: AHL_DEBUG_PUB.disable_debug;
1196: END IF;

Line 1194: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1190: p_data => x_msg_data);
1191: IF l_debug = 'Y' THEN
1192: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1193: 'UNEXPECTED ERROR IN PRIVATE:' );
1194: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1195: AHL_DEBUG_PUB.disable_debug;
1196: END IF;
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1195: AHL_DEBUG_PUB.disable_debug;

1191: IF l_debug = 'Y' THEN
1192: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1193: 'UNEXPECTED ERROR IN PRIVATE:' );
1194: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1195: AHL_DEBUG_PUB.disable_debug;
1196: END IF;
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1199: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1204: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

1200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,
1202: p_data => x_msg_data);
1203: IF l_debug = 'Y' THEN
1204: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1205: 'ERROR IN PRIVATE:' );
1206: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1207: AHL_DEBUG_PUB.disable_debug;
1208: END IF;

Line 1206: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1202: p_data => x_msg_data);
1203: IF l_debug = 'Y' THEN
1204: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1205: 'ERROR IN PRIVATE:' );
1206: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1207: AHL_DEBUG_PUB.disable_debug;
1208: END IF;
1209: WHEN OTHERS THEN
1210: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;

Line 1207: AHL_DEBUG_PUB.disable_debug;

1203: IF l_debug = 'Y' THEN
1204: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
1205: 'ERROR IN PRIVATE:' );
1206: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1207: AHL_DEBUG_PUB.disable_debug;
1208: END IF;
1209: WHEN OTHERS THEN
1210: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1221: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

1217: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,
1219: p_data => x_msg_data);
1220: IF l_debug = 'Y' THEN
1221: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1222: 'OTHER ERROR IN PRIVATE:' );
1223: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1224: AHL_DEBUG_PUB.disable_debug;
1225: END IF;

Line 1223: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

1219: p_data => x_msg_data);
1220: IF l_debug = 'Y' THEN
1221: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1222: 'OTHER ERROR IN PRIVATE:' );
1223: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1224: AHL_DEBUG_PUB.disable_debug;
1225: END IF;
1226: END GET_MR_AFFECTED_ITEMS;
1227:

Line 1224: AHL_DEBUG_PUB.disable_debug;

1220: IF l_debug = 'Y' THEN
1221: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
1222: 'OTHER ERROR IN PRIVATE:' );
1223: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1224: AHL_DEBUG_PUB.disable_debug;
1225: END IF;
1226: END GET_MR_AFFECTED_ITEMS;
1227:
1228: -- This API is revamped to fix Bug 6266738

Line 1258: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

1254: l_api_version CONSTANT NUMBER := 1.0;
1255: l_msg_count NUMBER;
1256: l_return_status VARCHAR2(1);
1257: l_item_instance_id NUMBER;
1258: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
1259: l_debug_prefix VARCHAR2(30) := 'AHL_FMP_PVT.GET_APPLICABLE_MRS';
1260:
1261: --Get inst_relation_rec for top node of UC
1262: CURSOR uc_top_inst(c_item_instance_id NUMBER) IS

Line 2277: AHL_DEBUG_PUB.enable_debug;

2273: BEGIN
2274: SAVEPOINT GET_APPLICABLE_MRS_PVT;
2275:
2276: IF l_debug = 'Y' THEN
2277: AHL_DEBUG_PUB.enable_debug;
2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);

Line 2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

2274: SAVEPOINT GET_APPLICABLE_MRS_PVT;
2275:
2276: IF l_debug = 'Y' THEN
2277: AHL_DEBUG_PUB.enable_debug;
2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);

Line 2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);

2275:
2276: IF l_debug = 'Y' THEN
2277: AHL_DEBUG_PUB.enable_debug;
2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);

Line 2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);

2276: IF l_debug = 'Y' THEN
2277: AHL_DEBUG_PUB.enable_debug;
2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);
2284: END IF;

Line 2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);

2277: AHL_DEBUG_PUB.enable_debug;
2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);
2284: END IF;
2285:

Line 2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);

2278: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);
2284: END IF;
2285:
2286: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);

2279: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
2280: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
2281: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
2282: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);
2284: END IF;
2285:
2286: IF FND_API.to_boolean(p_init_msg_list) THEN
2287: FND_MSG_PUB.initialize;

Line 2314: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id, l_debug_prefix);

2310: CLOSE check_instance_exists;
2311: END IF;
2312:
2313: IF l_debug = 'Y' THEN
2314: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id, l_debug_prefix);
2315: END IF;
2316:
2317: /* -- commenting as this is not required.
2318: -- get root instance.

Line 2337: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);

2333: -- start processing. First populate temp table ahl_applicable_instances by calling
2334: -- MC api to map instance (and components) to path positions.
2335:
2336: IF l_debug = 'Y' THEN
2337: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);
2338: END IF;
2339:
2340: -- initialize temp table.
2341: -- added to fix bug# 9434441.

Line 2347: AHL_DEBUG_PUB.debug('populating Config components..', l_debug_prefix);

2343:
2344: -- populate temp table with config components
2345: --IF (p_components_flag = 'Y') THEN -- commented out as part of fix for bug# 9434441 as the pc_node_id validation needs the configuration to be populated.
2346: IF l_debug = 'Y' THEN
2347: AHL_DEBUG_PUB.debug('populating Config components..', l_debug_prefix);
2348: END IF;
2349: Populate_Config_Components(p_item_instance_id);
2350: --END IF;
2351:

Line 2394: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);

2390:
2391: IF (l_path_posn_flag) THEN
2392:
2393: IF l_debug = 'Y' THEN
2394: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);
2395: END IF;
2396:
2397: DELETE FROM ahl_applicable_instances;
2398: -- for input instance.

Line 2420: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..', l_debug_prefix);

2416: END IF;
2417:
2418: IF (p_components_flag = 'Y') THEN
2419: IF l_debug = 'Y' THEN
2420: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..', l_debug_prefix);
2421: END IF;
2422:
2423: OPEN get_config_tree_csr(p_item_instance_id);
2424: LOOP

Line 2466: AHL_DEBUG_PUB.debug('Processing Inventory Items..', l_debug_prefix);

2462:
2463: END IF; -- l_path_posn_flag
2464:
2465: IF l_debug = 'Y' THEN
2466: AHL_DEBUG_PUB.debug('Processing Inventory Items..', l_debug_prefix);
2467: END IF;
2468:
2469: l_index := 1;
2470: l_bulk_insert_idx := 0;

Line 2504: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..', l_debug_prefix);

2500: ELSE
2501: OPEN get_comp_vst_inv_csr(p_item_instance_id, p_visit_type_code);
2502: END IF;
2503: IF l_debug = 'Y' THEN
2504: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..', l_debug_prefix);
2505: END IF;
2506:
2507: ELSIF (l_process_loop = 3) THEN
2508: -- get eff based on positions

Line 2520: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..', l_debug_prefix);

2516: OPEN get_posn_vst_csr(p_visit_type_code);
2517: END IF;
2518:
2519: IF l_debug = 'Y' THEN
2520: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..', l_debug_prefix);
2521: END IF;
2522: END IF;
2523:
2524: LOOP

Line 2586: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count, l_debug_prefix);

2582:
2583: EXIT WHEN (l_mr_header_id_tbl.count = 0);
2584:
2585: IF l_debug = 'Y' THEN
2586: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count, l_debug_prefix);
2587: END IF;
2588:
2589: -- process retrieved effectivity IDs.
2590: FOR i IN l_mr_effectivity_id_tbl.FIRST..l_mr_effectivity_id_tbl.LAST LOOP

Line 2594: AHL_DEBUG_PUB.debug('Now processing MR ID:EFF ID:INST ID:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i));

2590: FOR i IN l_mr_effectivity_id_tbl.FIRST..l_mr_effectivity_id_tbl.LAST LOOP
2591:
2592: /*
2593: IF l_debug = 'Y' THEN
2594: AHL_DEBUG_PUB.debug('Now processing MR ID:EFF ID:INST ID:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_instance_id_tbl(i));
2595: END IF;
2596: */
2597:
2598: -- to begin with, set effectivity as valid.

Line 2712: AHL_DEBUG_PUB.debug('Considering Fleet Effectivity for fleet = ' || l_fleet_id_tbl(i)|| ' and UC = ' || l_uc_header_id || ' and p_flt_range_calc_date = ' || p_flt_range_calc_date);

2708: x_ucHeaderID => l_uc_header_id,
2709: x_unitName => l_uc_name);
2710:
2711: IF l_debug = 'Y' THEN
2712: AHL_DEBUG_PUB.debug('Considering Fleet Effectivity for fleet = ' || l_fleet_id_tbl(i)|| ' and UC = ' || l_uc_header_id || ' and p_flt_range_calc_date = ' || p_flt_range_calc_date);
2713: END IF;
2714:
2715: IF(l_fleet_id_tbl(i) <> nvl(AHL_UMP_ProcessUnit_PVT.get_fleet_from_unit_asso(l_uc_header_id,p_flt_range_calc_date,null),-1)) THEN
2716: l_valid_mr_flag := 'N';

Line 2726: AHL_DEBUG_PUB.debug('MR ID:Valid Flag:Term-MR:' || l_mr_header_id_tbl(i) || ':' || l_valid_mr_flag || ':' || get_terminating_mr_rec.mr_header_id, l_debug_prefix);

2722: l_terminate_flag := 'N';
2723: FOR get_terminating_mr_rec IN get_terminating_mr_csr(l_mr_header_id_tbl(i))
2724: LOOP
2725: IF l_debug = 'Y' THEN
2726: AHL_DEBUG_PUB.debug('MR ID:Valid Flag:Term-MR:' || l_mr_header_id_tbl(i) || ':' || l_valid_mr_flag || ':' || get_terminating_mr_rec.mr_header_id, l_debug_prefix);
2727: END IF;
2728: ahl_ump_util_pkg.get_last_accomplishment(p_csi_item_instance_id => l_instance_id_tbl(i),
2729: p_mr_header_id => get_terminating_mr_rec.mr_header_id,
2730: x_unit_effectivity_id => l_accom_ue_id,

Line 2749: AHL_DEBUG_PUB.debug('MR ID:EFF ID:PC NODE ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' ||

2745: l_valid_mr_flag := 'N';
2746: END IF;
2747:
2748: IF l_debug = 'Y' THEN
2749: AHL_DEBUG_PUB.debug('MR ID:EFF ID:PC NODE ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' ||
2750: l_mr_pc_node_id_tbl(i) || ':' || l_instance_id_tbl(i) || ':' || l_valid_mr_flag || 'terminate flag' || l_terminate_flag, l_debug_prefix);
2751: END IF;
2752: -- apattark Changes for SB end
2753:

Line 2790: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||

2786: x_applicable_mr_tbl(l_index).relationship_code := l_get_mr_attri.relationship_code;
2787: x_applicable_mr_tbl(l_index).start_mr_header_id := l_get_mr_attri.start_mr_header_id;
2788: x_applicable_mr_tbl(l_index).sequence_number := l_get_mr_attri.sequence_number;
2789: IF l_debug = 'Y' THEN
2790: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2791: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
2792: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
2793: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
2794: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||

Line 2859: AHL_DEBUG_PUB.debug('l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');

2855: 1 -- default
2856: );
2857:
2858: IF l_debug = 'Y' THEN
2859: AHL_DEBUG_PUB.debug('l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');
2860: END IF;
2861:
2862: -- reset
2863: l_bulk_insert_idx := 0;

Line 2880: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||

2876: l_bulk_seq_num_tbl.delete;
2877: END IF; -- l_bulk_insert_idx
2878:
2879: IF l_debug = 'Y' THEN
2880: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2881: l_mr_header_id_tbl(i) || ' mr_effectivity_id ' ||
2882: l_mr_effectivity_id_tbl(i) || ' item_instance_id ' ||
2883: l_instance_id_tbl(i) || ' repetitive_flag ' ||
2884: l_get_mr_attri.repetitive_flag || ' show_repetitive_code ' ||

Line 3001: AHL_DEBUG_PUB.debug('Leftover:l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');

2997: 1 -- default
2998: );
2999:
3000: IF l_debug = 'Y' THEN
3001: AHL_DEBUG_PUB.debug('Leftover:l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');
3002: END IF;
3003:
3004: END IF; -- l_bulk_insert_idx
3005:

Line 3011: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

3007: DELETE FROM ahl_applicable_instances;
3008:
3009: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
3010: IF l_debug = 'Y' THEN
3011: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3012: AHL_DEBUG_PUB.disable_debug;
3013: END IF;
3014:
3015:

Line 3012: AHL_DEBUG_PUB.disable_debug;

3008:
3009: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
3010: IF l_debug = 'Y' THEN
3011: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3012: AHL_DEBUG_PUB.disable_debug;
3013: END IF;
3014:
3015:
3016: EXCEPTION

Line 3025: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

3021: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3022: p_count => x_msg_count,
3023: p_data => x_msg_data);
3024: IF l_debug = 'Y' THEN
3025: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3026: 'UNEXPECTED ERROR IN PRIVATE:' );
3027: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3028: AHL_DEBUG_PUB.disable_debug;
3029: END IF;

Line 3027: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

3023: p_data => x_msg_data);
3024: IF l_debug = 'Y' THEN
3025: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3026: 'UNEXPECTED ERROR IN PRIVATE:' );
3027: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3028: AHL_DEBUG_PUB.disable_debug;
3029: END IF;
3030:
3031: WHEN FND_API.G_EXC_ERROR THEN

Line 3028: AHL_DEBUG_PUB.disable_debug;

3024: IF l_debug = 'Y' THEN
3025: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3026: 'UNEXPECTED ERROR IN PRIVATE:' );
3027: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3028: AHL_DEBUG_PUB.disable_debug;
3029: END IF;
3030:
3031: WHEN FND_API.G_EXC_ERROR THEN
3032: ROLLBACK TO GET_APPLICABLE_MRS_PVT;

Line 3038: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

3034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3035: p_count => x_msg_count,
3036: p_data => x_msg_data);
3037: IF l_debug = 'Y' THEN
3038: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3039: 'ERROR IN PRIVATE:' );
3040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3041: AHL_DEBUG_PUB.disable_debug;
3042: END IF;

Line 3040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

3036: p_data => x_msg_data);
3037: IF l_debug = 'Y' THEN
3038: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3039: 'ERROR IN PRIVATE:' );
3040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3041: AHL_DEBUG_PUB.disable_debug;
3042: END IF;
3043:
3044: WHEN OTHERS THEN

Line 3041: AHL_DEBUG_PUB.disable_debug;

3037: IF l_debug = 'Y' THEN
3038: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
3039: 'ERROR IN PRIVATE:' );
3040: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3041: AHL_DEBUG_PUB.disable_debug;
3042: END IF;
3043:
3044: WHEN OTHERS THEN
3045: ROLLBACK TO GET_APPLICABLE_MRS_PVT;

Line 3056: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3053: p_count => x_msg_count,
3054: p_data => x_msg_data);
3055: IF l_debug = 'Y' THEN
3056: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3057: 'OTHER ERROR IN PRIVATE:' );
3058: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3059: AHL_DEBUG_PUB.disable_debug;
3060: END IF;

Line 3058: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

3054: p_data => x_msg_data);
3055: IF l_debug = 'Y' THEN
3056: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3057: 'OTHER ERROR IN PRIVATE:' );
3058: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3059: AHL_DEBUG_PUB.disable_debug;
3060: END IF;
3061: END GET_APPLICABLE_MRS;
3062:

Line 3059: AHL_DEBUG_PUB.disable_debug;

3055: IF l_debug = 'Y' THEN
3056: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
3057: 'OTHER ERROR IN PRIVATE:' );
3058: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);
3059: AHL_DEBUG_PUB.disable_debug;
3060: END IF;
3061: END GET_APPLICABLE_MRS;
3062:
3063: -- Define procedure get_ucHeader, get the unit_config_header_id and unit name for

Line 3097: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

3093: AND trunc(nvl(active_end_date, SYSDATE+1));
3094:
3095: l_get_unit_name_com get_unit_name_com%ROWTYPE;
3096: l_get_unit_name_top get_unit_name_top%ROWTYPE;
3097: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3098: BEGIN
3099: --Check for top node.
3100: OPEN get_unit_name_top(p_item_instance_id);
3101: FETCH get_unit_name_top INTO l_get_unit_name_top;

Line 3157: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

3153: WHERE instance_id = p_item_instance_id
3154: AND sysdate between trunc(nvl(active_start_date,sysdate))
3155: AND trunc(nvl(active_end_date, SYSDATE+1));
3156:
3157: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3158: l_top_instance_id NUMBER;
3159: BEGIN
3160: --Check for top node.
3161: OPEN get_instance_top(p_item_instance_id);

Line 3637: -- AHL_DEBUG_PUB.debug('Matched exiting - for include');

3633: FOR j IN inst_ext_dtl_rec.a_Code_tbl.FIRST..inst_ext_dtl_rec.a_Code_tbl.LAST LOOP
3634:
3635: IF(inst_ext_dtl_rec.a_Code_tbl(j) = eff_ext_dtl_rec.a_Code_tbl(i) AND
3636: inst_ext_dtl_rec.a_Val_tbl(j) = eff_ext_dtl_rec.a_Val_tbl(i))THEN
3637: -- AHL_DEBUG_PUB.debug('Matched exiting - for include');
3638: match_dtl := TRUE;
3639: EXIT;
3640: END IF;
3641: END LOOP;

Line 3655: -- AHL_DEBUG_PUB.debug('Matched exiting - for exclude');

3651:
3652: IF(inst_ext_dtl_rec.a_Code_tbl(j) = eff_ext_dtl_rec.a_Code_tbl(i) AND
3653: inst_ext_dtl_rec.a_Val_tbl(j) = eff_ext_dtl_rec.a_Val_tbl(i))THEN
3654: match_dtl := FALSE;
3655: -- AHL_DEBUG_PUB.debug('Matched exiting - for exclude');
3656: EXIT;
3657: END IF;
3658: END LOOP;
3659: IF match_dtl = FALSE THEN

Line 3678: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

3674: x_serial_prefix OUT NOCOPY VARCHAR2,
3675: x_serial_suffix OUT NOCOPY NUMBER
3676: ) IS
3677: i NUMBER := 0;
3678: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3679: BEGIN
3680: LOOP
3681: i := i+1;
3682: EXIT WHEN SUBSTR(p_serial_number,-i,1) NOT IN ('0','1','2','3','4','5','6','7','8','9')

Line 3950: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

3946: AND nvl(active_start_date,sysdate) <= sysdate and
3947: sysdate < NVL(active_end_date,sysdate+1);
3948:
3949: --l_get_mr_attri get_mr_attri%ROWTYPE;
3950: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
3951: l_get_applicable_mrs_rec get_applicable_mrs%ROWTYPE;
3952:
3953: BEGIN
3954: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;

Line 3956: AHL_DEBUG_PUB.enable_debug;

3952:
3953: BEGIN
3954: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3955: IF l_debug = 'Y' THEN
3956: AHL_DEBUG_PUB.enable_debug;
3957: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3958: AHL_DEBUG_PUB.debug('');
3959: END IF;
3960: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3957: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

3953: BEGIN
3954: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3955: IF l_debug = 'Y' THEN
3956: AHL_DEBUG_PUB.enable_debug;
3957: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3958: AHL_DEBUG_PUB.debug('');
3959: END IF;
3960: IF FND_API.to_boolean(p_init_msg_list) THEN
3961: FND_MSG_PUB.initialize;

Line 3958: AHL_DEBUG_PUB.debug('');

3954: SAVEPOINT GET_PM_APPLICABLE_MRS_PVT;
3955: IF l_debug = 'Y' THEN
3956: AHL_DEBUG_PUB.enable_debug;
3957: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3958: AHL_DEBUG_PUB.debug('');
3959: END IF;
3960: IF FND_API.to_boolean(p_init_msg_list) THEN
3961: FND_MSG_PUB.initialize;
3962: END IF;

Line 4002: AHL_DEBUG_PUB.debug('Item instance id:' || l_item_instance_id);

3998: CLOSE get_inventory_item;
3999: */
4000:
4001: IF l_debug = 'Y' THEN
4002: AHL_DEBUG_PUB.debug('Item instance id:' || l_item_instance_id);
4003: END IF;
4004:
4005: -- Call OKS API to get program_ids
4006: l_inp_rec.contract_number := NULL;

Line 4039: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);

4035: RAISE FND_API.G_EXC_ERROR;
4036: END IF;
4037:
4038: IF l_debug = 'Y' THEN
4039: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);
4040: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );
4041: END IF;
4042:
4043: iap := 1;

Line 4040: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );

4036: END IF;
4037:
4038: IF l_debug = 'Y' THEN
4039: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);
4040: AHL_DEBUG_PUB.debug('Count on pm_activities:' || l_pm_activities.count );
4041: END IF;
4042:
4043: iap := 1;
4044: iaa := 1;

Line 4049: -- AHL_DEBUG_PUB.debug('Appl MR found:' || l_get_applicable_mrs.mr_header_id);

4045: -- iap_u := 1;
4046: -- l_prior_mr_header_id := -1;
4047: --FOR l_get_applicable_mrs IN get_applicable_mrs(l_inventory_item_id) LOOP
4048: --IF l_debug = 'Y' THEN
4049: -- AHL_DEBUG_PUB.debug('Appl MR found:' || l_get_applicable_mrs.mr_header_id);
4050: --END IF;
4051:
4052: IF l_ent_contracts.COUNT > 0 THEN
4053: FOR i IN l_ent_contracts.FIRST..l_ent_contracts.LAST LOOP

Line 4060: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);

4056: IF (get_applicable_mrs%FOUND) THEN
4057: --IF l_ent_contracts(i).pm_program_id = l_get_applicable_mrs.mr_header_id THEN
4058:
4059: IF l_debug = 'Y' THEN
4060: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
4061: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
4062: AHL_DEBUG_PUB.debug('---------------------------');
4063: END IF;
4064:

Line 4061: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);

4057: --IF l_ent_contracts(i).pm_program_id = l_get_applicable_mrs.mr_header_id THEN
4058:
4059: IF l_debug = 'Y' THEN
4060: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
4061: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
4062: AHL_DEBUG_PUB.debug('---------------------------');
4063: END IF;
4064:
4065: x_applicable_programs_tbl(iap).contract_id := l_ent_contracts(i).contract_id;

Line 4062: AHL_DEBUG_PUB.debug('---------------------------');

4058:
4059: IF l_debug = 'Y' THEN
4060: AHL_DEBUG_PUB.debug('Contract Number found:' || l_ent_contracts(i).contract_number);
4061: AHL_DEBUG_PUB.debug('Service Line ID:' || l_ent_contracts(i).service_line_id);
4062: AHL_DEBUG_PUB.debug('---------------------------');
4063: END IF;
4064:
4065: x_applicable_programs_tbl(iap).contract_id := l_ent_contracts(i).contract_id;
4066: x_applicable_programs_tbl(iap).contract_number := l_ent_contracts(i).contract_number;

Line 4168: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

4164: END LOOP;
4165: END IF;
4166: */
4167: IF l_debug = 'Y' THEN
4168: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4169: AHL_DEBUG_PUB.disable_debug;
4170: END IF;
4171:
4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4169: AHL_DEBUG_PUB.disable_debug;

4165: END IF;
4166: */
4167: IF l_debug = 'Y' THEN
4168: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4169: AHL_DEBUG_PUB.disable_debug;
4170: END IF;
4171:
4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4173: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 4179: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

4175: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4176: p_count => x_msg_count,
4177: p_data => x_msg_data);
4178: IF l_debug = 'Y' THEN
4179: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4180: 'UNEXPECTED ERROR IN PRIVATE:' );
4181: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4182: AHL_DEBUG_PUB.disable_debug;
4183: END IF;

Line 4181: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

4177: p_data => x_msg_data);
4178: IF l_debug = 'Y' THEN
4179: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4180: 'UNEXPECTED ERROR IN PRIVATE:' );
4181: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4182: AHL_DEBUG_PUB.disable_debug;
4183: END IF;
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 4182: AHL_DEBUG_PUB.disable_debug;

4178: IF l_debug = 'Y' THEN
4179: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4180: 'UNEXPECTED ERROR IN PRIVATE:' );
4181: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4182: AHL_DEBUG_PUB.disable_debug;
4183: END IF;
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4186: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4191: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

4187: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4188: p_count => x_msg_count,
4189: p_data => x_msg_data);
4190: IF l_debug = 'Y' THEN
4191: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4192: 'ERROR IN PRIVATE:' );
4193: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4194: AHL_DEBUG_PUB.disable_debug;
4195: END IF;

Line 4193: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

4189: p_data => x_msg_data);
4190: IF l_debug = 'Y' THEN
4191: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4192: 'ERROR IN PRIVATE:' );
4193: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4194: AHL_DEBUG_PUB.disable_debug;
4195: END IF;
4196: WHEN OTHERS THEN
4197: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;

Line 4194: AHL_DEBUG_PUB.disable_debug;

4190: IF l_debug = 'Y' THEN
4191: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
4192: 'ERROR IN PRIVATE:' );
4193: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4194: AHL_DEBUG_PUB.disable_debug;
4195: END IF;
4196: WHEN OTHERS THEN
4197: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4209: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

4205: p_count => x_msg_count,
4206: p_data => x_msg_data);
4207: IF l_debug = 'Y' THEN
4208:
4209: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
4210: 'OTHER ERROR IN PRIVATE:' );
4211: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4212: AHL_DEBUG_PUB.disable_debug;
4213: END IF;

Line 4211: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');

4207: IF l_debug = 'Y' THEN
4208:
4209: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
4210: 'OTHER ERROR IN PRIVATE:' );
4211: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4212: AHL_DEBUG_PUB.disable_debug;
4213: END IF;
4214:
4215: END GET_PM_APPLICABLE_MRS;

Line 4212: AHL_DEBUG_PUB.disable_debug;

4208:
4209: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
4210: 'OTHER ERROR IN PRIVATE:' );
4211: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
4212: AHL_DEBUG_PUB.disable_debug;
4213: END IF;
4214:
4215: END GET_PM_APPLICABLE_MRS;
4216:

Line 4537: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;

4533: l_api_version CONSTANT NUMBER := 1.0;
4534: l_msg_count NUMBER;
4535: l_return_status VARCHAR2(1);
4536: l_item_instance_id NUMBER;
4537: l_debug VARCHAR2(1) :=AHL_DEBUG_PUB.is_log_enabled;
4538: l_debug_prefix VARCHAR2(40) := 'AHL_FMP_PVT.GET_MR_APPLICABILITY';
4539:
4540:
4541: -- Get valid pc nodes for an instance

Line 4789: AHL_DEBUG_PUB.enable_debug;

4785:
4786: BEGIN
4787:
4788: IF l_debug = 'Y' THEN
4789: AHL_DEBUG_PUB.enable_debug;
4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);

Line 4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);

4786: BEGIN
4787:
4788: IF l_debug = 'Y' THEN
4789: AHL_DEBUG_PUB.enable_debug;
4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);

Line 4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);

4787:
4788: IF l_debug = 'Y' THEN
4789: AHL_DEBUG_PUB.enable_debug;
4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
4795: END IF;

Line 4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);

4788: IF l_debug = 'Y' THEN
4789: AHL_DEBUG_PUB.enable_debug;
4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
4795: END IF;
4796:

Line 4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);

4789: AHL_DEBUG_PUB.enable_debug;
4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
4795: END IF;
4796:
4797: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);

4790: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
4791: AHL_DEBUG_PUB.debug('Input p_item_instance_id:' || p_item_instance_id, l_debug_prefix);
4792: AHL_DEBUG_PUB.debug('Input p_mr_header_id:' || p_mr_header_id, l_debug_prefix);
4793: AHL_DEBUG_PUB.debug('Input p_components_flag:' || p_components_flag, l_debug_prefix);
4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
4795: END IF;
4796:
4797: IF FND_API.to_boolean(p_init_msg_list) THEN
4798: FND_MSG_PUB.initialize;

Line 4825: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id, l_debug_prefix);

4821: CLOSE check_instance_exists;
4822: END IF;
4823:
4824: IF l_debug = 'Y' THEN
4825: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id, l_debug_prefix);
4826: END IF;
4827:
4828: -- start processing. First populate temp table ahl_applicable_instances by calling
4829: -- MC api to map instance (and components) to path positions.

Line 4832: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);

4828: -- start processing. First populate temp table ahl_applicable_instances by calling
4829: -- MC api to map instance (and components) to path positions.
4830:
4831: IF l_debug = 'Y' THEN
4832: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);
4833: END IF;
4834:
4835: -- initialize temp table.
4836: -- added to fix bug# 9434441.

Line 4842: AHL_DEBUG_PUB.debug('populating Config components..', l_debug_prefix);

4838:
4839: -- populate temp table with config components
4840: --IF (p_components_flag = 'Y') THEN -- commented out as part of fix for bug# 9434441 as the pc_node_id validation needs the configuration to be populated.
4841: IF l_debug = 'Y' THEN
4842: AHL_DEBUG_PUB.debug('populating Config components..', l_debug_prefix);
4843: END IF;
4844: Populate_Config_Components(p_item_instance_id);
4845: --END IF;
4846:

Line 4865: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);

4861:
4862: IF (l_path_posn_flag) THEN
4863:
4864: IF l_debug = 'Y' THEN
4865: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);
4866: END IF;
4867:
4868: DELETE FROM ahl_applicable_instances;
4869: -- for input instance.

Line 4891: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..', l_debug_prefix);

4887: END IF;
4888:
4889: IF (p_components_flag = 'Y') THEN
4890: IF l_debug = 'Y' THEN
4891: AHL_DEBUG_PUB.debug('Processing Component MC Relationships..', l_debug_prefix);
4892: END IF;
4893:
4894: OPEN get_config_tree_csr(p_item_instance_id);
4895: LOOP

Line 4937: AHL_DEBUG_PUB.debug('Processing Inventory Items..', l_debug_prefix);

4933:
4934: END IF; -- l_path_posn_flag
4935:
4936: IF l_debug = 'Y' THEN
4937: AHL_DEBUG_PUB.debug('Processing Inventory Items..', l_debug_prefix);
4938: END IF;
4939:
4940: l_index := 1;
4941:

Line 4958: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..', l_debug_prefix);

4954: ELSIF (l_process_loop = 2) THEN
4955: -- get eff for components.
4956: OPEN get_comp_mr_inv_csr(p_item_instance_id,p_mr_header_id);
4957: IF l_debug = 'Y' THEN
4958: AHL_DEBUG_PUB.debug('Processing Component Effectivities based on Inventory Items..', l_debug_prefix);
4959: END IF;
4960:
4961: ELSIF (l_process_loop = 3) THEN
4962: -- get eff based on positions

Line 4966: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..', l_debug_prefix);

4962: -- get eff based on positions
4963: OPEN get_posn_mr_csr(p_mr_header_id);
4964:
4965: IF l_debug = 'Y' THEN
4966: AHL_DEBUG_PUB.debug('Processing Effectivities based on MC Positions..', l_debug_prefix);
4967: END IF;
4968: END IF;
4969:
4970: LOOP

Line 4990: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count, l_debug_prefix);

4986:
4987: EXIT WHEN (l_mr_header_id_tbl.count = 0);
4988:
4989: IF l_debug = 'Y' THEN
4990: AHL_DEBUG_PUB.debug('Count of l_mr_header_id_tbl:' || l_mr_header_id_tbl.count, l_debug_prefix);
4991: END IF;
4992:
4993: -- process retrieved effectivity IDs.
4994: FOR i IN l_mr_effectivity_id_tbl.FIRST..l_mr_effectivity_id_tbl.LAST LOOP

Line 5072: AHL_DEBUG_PUB.debug('MR ID:EFF ID:PC NODE ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_mr_pc_node_id_tbl(i) || ':' || l_instance_id_tbl(i) || ':' || l_valid_mr_flag, l_debug_prefix);

5068: END IF;
5069: --amsriniv End
5070:
5071: IF l_debug = 'Y' THEN
5072: AHL_DEBUG_PUB.debug('MR ID:EFF ID:PC NODE ID:INST ID:Valid Flag:' || l_mr_header_id_tbl(i) || ':' || l_mr_effectivity_id_tbl(i) || ':' || l_mr_pc_node_id_tbl(i) || ':' || l_instance_id_tbl(i) || ':' || l_valid_mr_flag, l_debug_prefix);
5073: END IF;
5074:
5075: -- add row to x_applicable_mr_tbl
5076: IF (l_valid_mr_flag = 'Y') THEN

Line 5106: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||

5102: x_applicable_mr_tbl(l_index).copy_accomplishment_flag := l_get_mr_attri.copy_accomplishment_flag;
5103: x_applicable_mr_tbl(l_index).implement_status_code := l_get_mr_attri.implement_status_code;
5104: x_applicable_mr_tbl(l_index).descendent_count := l_get_mr_attri.descendent_count;
5105: IF l_debug = 'Y' THEN
5106: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
5107: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
5108: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
5109: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
5110: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||

Line 5172: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);

5168:
5169: DELETE FROM ahl_applicable_instances;
5170:
5171: IF l_debug = 'Y' THEN
5172: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5173: AHL_DEBUG_PUB.disable_debug;
5174: END IF;
5175:
5176:

Line 5173: AHL_DEBUG_PUB.disable_debug;

5169: DELETE FROM ahl_applicable_instances;
5170:
5171: IF l_debug = 'Y' THEN
5172: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5173: AHL_DEBUG_PUB.disable_debug;
5174: END IF;
5175:
5176:
5177: EXCEPTION

Line 5185: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

5181: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5182: p_count => x_msg_count,
5183: p_data => x_msg_data);
5184: IF l_debug = 'Y' THEN
5185: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5186: 'UNEXPECTED ERROR IN PRIVATE:' );
5187: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5188: AHL_DEBUG_PUB.disable_debug;
5189: END IF;

Line 5187: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);

5183: p_data => x_msg_data);
5184: IF l_debug = 'Y' THEN
5185: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5186: 'UNEXPECTED ERROR IN PRIVATE:' );
5187: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5188: AHL_DEBUG_PUB.disable_debug;
5189: END IF;
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN

Line 5188: AHL_DEBUG_PUB.disable_debug;

5184: IF l_debug = 'Y' THEN
5185: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5186: 'UNEXPECTED ERROR IN PRIVATE:' );
5187: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5188: AHL_DEBUG_PUB.disable_debug;
5189: END IF;
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5197: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

5193: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5194: p_count => x_msg_count,
5195: p_data => x_msg_data);
5196: IF l_debug = 'Y' THEN
5197: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5198: 'ERROR IN PRIVATE:' );
5199: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5200: AHL_DEBUG_PUB.disable_debug;
5201: END IF;

Line 5199: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);

5195: p_data => x_msg_data);
5196: IF l_debug = 'Y' THEN
5197: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5198: 'ERROR IN PRIVATE:' );
5199: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5200: AHL_DEBUG_PUB.disable_debug;
5201: END IF;
5202:
5203: WHEN OTHERS THEN

Line 5200: AHL_DEBUG_PUB.disable_debug;

5196: IF l_debug = 'Y' THEN
5197: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,
5198: 'ERROR IN PRIVATE:' );
5199: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5200: AHL_DEBUG_PUB.disable_debug;
5201: END IF;
5202:
5203: WHEN OTHERS THEN
5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5214: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

5210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5211: p_count => x_msg_count,
5212: p_data => x_msg_data);
5213: IF l_debug = 'Y' THEN
5214: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
5215: 'OTHER ERROR IN PRIVATE:' );
5216: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5217: AHL_DEBUG_PUB.disable_debug;
5218: END IF;

Line 5216: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);

5212: p_data => x_msg_data);
5213: IF l_debug = 'Y' THEN
5214: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
5215: 'OTHER ERROR IN PRIVATE:' );
5216: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5217: AHL_DEBUG_PUB.disable_debug;
5218: END IF;
5219: END GET_MR_APPLICABILITY;
5220:

Line 5217: AHL_DEBUG_PUB.disable_debug;

5213: IF l_debug = 'Y' THEN
5214: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,
5215: 'OTHER ERROR IN PRIVATE:' );
5216: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5217: AHL_DEBUG_PUB.disable_debug;
5218: END IF;
5219: END GET_MR_APPLICABILITY;
5220:
5221: