APPS.AHL_FMP_PVT dependencies on FND_API

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

96:
97: -- Define Procedure GET_MR_AFFECTED_ITEMS --
98: PROCEDURE GET_MR_AFFECTED_ITEMS(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

Line 101: p_commit IN VARCHAR2 := FND_API.G_FALSE,

97: -- Define Procedure GET_MR_AFFECTED_ITEMS --
98: PROCEDURE GET_MR_AFFECTED_ITEMS(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,

Line 102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

98: PROCEDURE GET_MR_AFFECTED_ITEMS(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_mr_header_id IN NUMBER,

Line 724: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;

720: FROM csi_item_instances A
721: WHERE A.inventory_item_id = c_inventory_item_id
722: AND sysdate between trunc(nvl(A.active_start_date,sysdate))
723: and trunc(nvl(A.active_end_date,sysdate+1))
724: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;
725:
726: CURSOR get_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
727: SELECT A.instance_id
728: FROM csi_item_instances A,ahl_applicable_instances api

Line 732: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;

728: FROM csi_item_instances A,ahl_applicable_instances api
729: WHERE A.instance_id = api.csi_item_instance_id
730: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
731: AND api.position_id=c_relationship_id
732: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;
733:
734: CURSOR get_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
735: SELECT A.instance_id
736: FROM csi_item_instances A,ahl_applicable_instances api

Line 741: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;

737: WHERE A.instance_id = api.csi_item_instance_id
738: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
739: AND api.position_id=c_relationship_id
740: AND A.inventory_item_id = c_inventory_item_id
741: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;
742:
743: --added for SB effectivity changes
744: CURSOR get_terminating_mr_csr(c_mr_header_id IN NUMBER) IS
745: SELECT mr_header_id

Line 776: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
779: x_return_status := 'S';
780: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 780: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

776: IF FND_API.to_boolean(p_init_msg_list) THEN
777: FND_MSG_PUB.initialize;
778: END IF;
779: x_return_status := 'S';
780: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
781: p_api_version,
782: l_api_name,
783: G_PKG_NAME)
784: THEN

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: p_api_version,
782: l_api_name,
783: G_PKG_NAME)
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:

Line 799: RAISE FND_API.G_EXC_ERROR;

795: IF check_mr_exists%NOTFOUND THEN
796: CLOSE check_mr_exists;
797: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
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:

Line 816: p_init_msg_list =>FND_API.G_FALSE,

812: THEN
813: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
814: (
815: p_api_version =>p_api_version,
816: p_init_msg_list =>FND_API.G_FALSE,
817: p_commit =>FND_API.G_FALSE,
818: p_validation_level=>p_validation_level,
819: p_position_id =>l_mr_effect.relationship_id,
820: x_return_status =>l_return_Status,

Line 817: p_commit =>FND_API.G_FALSE,

813: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
814: (
815: p_api_version =>p_api_version,
816: p_init_msg_list =>FND_API.G_FALSE,
817: p_commit =>FND_API.G_FALSE,
818: p_validation_level=>p_validation_level,
819: p_position_id =>l_mr_effect.relationship_id,
820: x_return_status =>l_return_Status,
821: x_msg_count =>l_msg_count,

Line 844: RAISE FND_API.G_EXC_ERROR;

840: END LOOP;
841: CLOSE check_mr_effect;
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

Line 1178: --IF FND_API.TO_BOOLEAN(p_commit) THEN

1174: END IF;
1175: END IF;
1176:
1177: --DBMS_OUTPUT.put_line('API1: Just before commit and l_index= '||l_index);
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');

Line 1185: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
1188: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1188: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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;
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,

Line 1197: WHEN FND_API.G_EXC_ERROR THEN

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;
1200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,

Line 1199: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 1200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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;
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,

Line 1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1214: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1215: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1217: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1214: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1215: p_error_text => SUBSTR(SQLERRM,1,240));
1216: END IF;
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,

Line 1233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1229: -- Define procedure GET_APPLICABLE_MRS --
1230: -- JKJain, NR Analysis and Forecasting
1231: PROCEDURE GET_APPLICABLE_MRS(
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: x_return_status OUT NOCOPY VARCHAR2,
1237: x_msg_count OUT NOCOPY NUMBER,

Line 1234: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1230: -- JKJain, NR Analysis and Forecasting
1231: PROCEDURE GET_APPLICABLE_MRS(
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: x_return_status OUT NOCOPY VARCHAR2,
1237: x_msg_count OUT NOCOPY NUMBER,
1238: x_msg_data OUT NOCOPY VARCHAR2,

Line 1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1231: PROCEDURE GET_APPLICABLE_MRS(
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1234: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: x_return_status OUT NOCOPY VARCHAR2,
1237: x_msg_count OUT NOCOPY NUMBER,
1238: x_msg_data OUT NOCOPY VARCHAR2,
1239: p_item_instance_id IN NUMBER,

Line 2286: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
2288: END IF;
2289:
2290: x_return_status := 'S';

Line 2292: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

2288: END IF;
2289:
2290: x_return_status := 'S';
2291:
2292: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
2293: l_api_name, G_PKG_NAME)
2294: THEN
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;

Line 2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2291:
2292: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
2293: l_api_name, G_PKG_NAME)
2294: THEN
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;
2297:
2298: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
2299: THEN

Line 2298: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)

2294: THEN
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296: END IF;
2297:
2298: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
2299: THEN
2300: -- validate input instance.
2301: OPEN check_instance_exists(p_item_instance_id);
2302: FETCH check_instance_exists INTO l_item_instance_id;

Line 2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2304: CLOSE check_instance_exists;
2305: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
2306: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
2307: FND_MSG_PUB.ADD;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: END IF;
2310: CLOSE check_instance_exists;
2311: END IF;
2312:

Line 2402: p_init_msg_list => fnd_api.g_false,

2398: -- for input instance.
2399: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2400: (
2401: p_api_version => 1.0,
2402: p_init_msg_list => fnd_api.g_false,
2403: p_commit => fnd_api.g_false,
2404: p_validation_level => p_validation_level,
2405: p_csi_item_instance_id => p_item_instance_id,
2406: x_return_status => l_return_status,

Line 2403: p_commit => fnd_api.g_false,

2399: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2400: (
2401: p_api_version => 1.0,
2402: p_init_msg_list => fnd_api.g_false,
2403: p_commit => fnd_api.g_false,
2404: p_validation_level => p_validation_level,
2405: p_csi_item_instance_id => p_item_instance_id,
2406: x_return_status => l_return_status,
2407: x_msg_count => l_msg_count,

Line 2412: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2408: x_msg_data => x_msg_data
2409: );
2410:
2411: -- Raise errors if exceptions occur
2412: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2413: RAISE FND_API.G_EXC_ERROR;
2414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: END IF;

Line 2413: RAISE FND_API.G_EXC_ERROR;

2409: );
2410:
2411: -- Raise errors if exceptions occur
2412: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2413: RAISE FND_API.G_EXC_ERROR;
2414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: END IF;
2417:

Line 2414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2410:
2411: -- Raise errors if exceptions occur
2412: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2413: RAISE FND_API.G_EXC_ERROR;
2414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: END IF;
2417:
2418: IF (p_components_flag = 'Y') THEN

Line 2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2411: -- Raise errors if exceptions occur
2412: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2413: RAISE FND_API.G_EXC_ERROR;
2414: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2416: END IF;
2417:
2418: IF (p_components_flag = 'Y') THEN
2419: IF l_debug = 'Y' THEN

Line 2432: p_init_msg_list => fnd_api.g_false,

2428: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
2429: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2430: (
2431: p_api_version => 1.0,
2432: p_init_msg_list => fnd_api.g_false,
2433: p_commit => fnd_api.g_false,
2434: p_validation_level => p_validation_level,
2435: p_csi_item_instance_id => l_subj_id_tbl(j),
2436: x_return_status => l_return_status,

Line 2433: p_commit => fnd_api.g_false,

2429: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2430: (
2431: p_api_version => 1.0,
2432: p_init_msg_list => fnd_api.g_false,
2433: p_commit => fnd_api.g_false,
2434: p_validation_level => p_validation_level,
2435: p_csi_item_instance_id => l_subj_id_tbl(j),
2436: x_return_status => l_return_status,
2437: x_msg_count => l_msg_count,

Line 2441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2437: x_msg_count => l_msg_count,
2438: x_msg_data => x_msg_data
2439: );
2440: -- Raise errors if exceptions occur
2441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2442: RAISE FND_API.G_EXC_ERROR;
2443: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: END IF;

Line 2442: RAISE FND_API.G_EXC_ERROR;

2438: x_msg_data => x_msg_data
2439: );
2440: -- Raise errors if exceptions occur
2441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2442: RAISE FND_API.G_EXC_ERROR;
2443: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: END IF;
2446:

Line 2443: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2439: );
2440: -- Raise errors if exceptions occur
2441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2442: RAISE FND_API.G_EXC_ERROR;
2443: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: END IF;
2446:
2447: END LOOP;

Line 2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2440: -- Raise errors if exceptions occur
2441: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2442: RAISE FND_API.G_EXC_ERROR;
2443: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: END IF;
2446:
2447: END LOOP;
2448: l_subj_id_tbl.DELETE;

Line 2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2761: IF get_mr_attri%NOTFOUND THEN
2762: CLOSE get_mr_attri;
2763: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
2764: FND_MSG_PUB.add;
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSE
2767: l_prev_mr_header_id := l_mr_header_id_tbl(i);
2768: CLOSE get_mr_attri;
2769: END IF; -- get_mr_attri%NOTFOUND

Line 3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3014:
3015:
3016: EXCEPTION
3017:
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3022: p_count => x_msg_count,

Line 3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3016: EXCEPTION
3017:
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 3021: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3017:
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 3031: WHEN FND_API.G_EXC_ERROR THEN

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;
3033: x_return_status := FND_API.G_RET_STS_ERROR;
3034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3035: p_count => x_msg_count,

Line 3033: x_return_status := FND_API.G_RET_STS_ERROR;

3029: END IF;
3030:
3031: WHEN FND_API.G_EXC_ERROR THEN
3032: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3033: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 3034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3030:
3031: WHEN FND_API.G_EXC_ERROR THEN
3032: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3033: x_return_status := FND_API.G_RET_STS_ERROR;
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,

Line 3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3042: END IF;
3043:
3044: WHEN OTHERS THEN
3045: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3049: p_procedure_name => 'GET_APPLICABLE_MRS',
3050: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3049: p_procedure_name => 'GET_APPLICABLE_MRS',
3050: p_error_text => SUBSTRB(SQLERRM,1,240));
3051: END IF;
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,

Line 3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3448: CLOSE get_inst_attributes;
3449: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3450: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3451: FND_MSG_PUB.add;
3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3453: RETURN match_dtl;
3454: END IF;
3455: CLOSE get_inst_attributes;
3456: --DBMS_OUTPUT.PUT_LINE('In check effectivity detail function and before the loop');

Line 3868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3864: END check_sn_outside;
3865:
3866: PROCEDURE GET_PM_APPLICABLE_MRS (
3867: p_api_version IN NUMBER,
3868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3869: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3870: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3871: x_return_status OUT NOCOPY VARCHAR2,
3872: x_msg_count OUT NOCOPY NUMBER,

Line 3869: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3865:
3866: PROCEDURE GET_PM_APPLICABLE_MRS (
3867: p_api_version IN NUMBER,
3868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3869: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3870: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3871: x_return_status OUT NOCOPY VARCHAR2,
3872: x_msg_count OUT NOCOPY NUMBER,
3873: x_msg_data OUT NOCOPY VARCHAR2,

Line 3870: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3866: PROCEDURE GET_PM_APPLICABLE_MRS (
3867: p_api_version IN NUMBER,
3868: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3869: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3870: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3871: x_return_status OUT NOCOPY VARCHAR2,
3872: x_msg_count OUT NOCOPY NUMBER,
3873: x_msg_data OUT NOCOPY VARCHAR2,
3874: p_item_instance_id IN NUMBER,

Line 3960: IF FND_API.to_boolean(p_init_msg_list) 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;
3963: x_return_status := 'S';
3964: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

Line 3964: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

3960: IF FND_API.to_boolean(p_init_msg_list) THEN
3961: FND_MSG_PUB.initialize;
3962: END IF;
3963: x_return_status := 'S';
3964: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3965: l_api_name, G_PKG_NAME)
3966: THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END IF;

Line 3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3963: x_return_status := 'S';
3964: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3965: l_api_name, G_PKG_NAME)
3966: THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END IF;
3969:
3970: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3971: IF l_appln_code <> 'PM' THEN

Line 3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3970: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3971: IF l_appln_code <> 'PM' THEN
3972: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3973: FND_MSG_PUB.add;
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: END IF;
3976:
3977: OPEN check_instance_exists_csr(p_item_instance_id);
3978: FETCH check_instance_exists_csr INTO l_item_instance_id, l_inventory_item_id;

Line 3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3980: CLOSE check_instance_exists_csr;
3981: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3982: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
3983: FND_MSG_PUB.ADD;
3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3985: END IF;
3986: CLOSE check_instance_exists_csr;
3987:
3988: /* combined into the above cursor for performance bug#5093064.

Line 3996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3992: CLOSE get_inventory_item;
3993: FND_MESSAGE.set_name('AHL', 'AHL_FMP_ITEM_NOT_EXISTS');
3994: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3995: FND_MSG_PUB.add;
3996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3997: END IF;
3998: CLOSE get_inventory_item;
3999: */
4000:

Line 4025: p_init_msg_list => FND_API.G_TRUE,

4021: l_inp_rec.sort_key := NULL;
4022:
4023: OKS_PM_ENTITLEMENTS_PUB.get_pm_contracts
4024: ( p_api_version => 1.0,
4025: p_init_msg_list => FND_API.G_TRUE,
4026: p_inp_rec => l_inp_rec,
4027: x_return_status => l_return_status,
4028: x_msg_count => l_msg_count,
4029: x_msg_data => l_msg_data,

Line 4035: RAISE FND_API.G_EXC_ERROR;

4031: x_pm_activities => l_pm_activities );
4032: IF l_msg_count > 0 THEN
4033: FND_MESSAGE.set_name('AHL', 'AHL_FMP_CALLING_OKS_API_ERROR');
4034: FND_MSG_PUB.add;
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);

Line 4156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4152: IF get_mr_attri%NOTFOUND THEN
4153: CLOSE get_mr_attri;
4154: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
4155: FND_MSG_PUB.add;
4156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4157: ELSE
4158: x_applicable_activities_tbl(i).repetitive_flag := l_get_mr_attri.repetitive_flag;
4159: x_applicable_activities_tbl(i).show_repetitive_code := l_get_mr_attri.show_repetitive_code;
4160: x_applicable_activities_tbl(i).whichever_first_code := l_get_mr_attri.whichever_first_code;

Line 4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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;
4174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4175: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4176: p_count => x_msg_count,

Line 4174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4170: END IF;
4171:
4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4173: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 4175: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4171:
4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4173: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 4184: WHEN FND_API.G_EXC_ERROR THEN

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;
4187: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4188: p_count => x_msg_count,

Line 4186: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 4187: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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;
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,

Line 4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
4199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4201: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4202: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4204: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4201: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4202: p_error_text => SUBSTRB(SQLERRM,1,240));
4203: END IF;
4204: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4205: p_count => x_msg_count,
4206: p_data => x_msg_data);
4207: IF l_debug = 'Y' THEN
4208:

Line 4220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4216:
4217:
4218: PROCEDURE get_visit_applicable_mrs (
4219: p_api_version IN NUMBER,
4220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4223: x_return_status OUT NOCOPY VARCHAR2,
4224: x_msg_count OUT NOCOPY NUMBER,

Line 4221: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4217:
4218: PROCEDURE get_visit_applicable_mrs (
4219: p_api_version IN NUMBER,
4220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4223: x_return_status OUT NOCOPY VARCHAR2,
4224: x_msg_count OUT NOCOPY NUMBER,
4225: x_msg_data OUT NOCOPY VARCHAR2,

Line 4222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4218: PROCEDURE get_visit_applicable_mrs (
4219: p_api_version IN NUMBER,
4220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4222: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4223: x_return_status OUT NOCOPY VARCHAR2,
4224: x_msg_count OUT NOCOPY NUMBER,
4225: x_msg_data OUT NOCOPY VARCHAR2,
4226: p_item_instance_id IN NUMBER,

Line 4241: p_init_msg_list => FND_API.G_FALSE,

4237:
4238: -- call api to fetch all applicable mrs for ASO installation.
4239: AHL_FMP_PVT.get_applicable_mrs(
4240: p_api_version => l_api_version,
4241: p_init_msg_list => FND_API.G_FALSE,
4242: p_commit => FND_API.G_FALSE,
4243: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4244: x_return_status => x_return_status,
4245: x_msg_count => x_msg_count,

Line 4242: p_commit => FND_API.G_FALSE,

4238: -- call api to fetch all applicable mrs for ASO installation.
4239: AHL_FMP_PVT.get_applicable_mrs(
4240: p_api_version => l_api_version,
4241: p_init_msg_list => FND_API.G_FALSE,
4242: p_commit => FND_API.G_FALSE,
4243: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4244: x_return_status => x_return_status,
4245: x_msg_count => x_msg_count,
4246: x_msg_data => x_msg_data,

Line 4243: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4239: AHL_FMP_PVT.get_applicable_mrs(
4240: p_api_version => l_api_version,
4241: p_init_msg_list => FND_API.G_FALSE,
4242: p_commit => FND_API.G_FALSE,
4243: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4244: x_return_status => x_return_status,
4245: x_msg_count => x_msg_count,
4246: x_msg_data => x_msg_data,
4247: p_item_instance_id => p_item_instance_id,

Line 4254: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4250: p_visit_type_code => p_visit_type_code,
4251: x_applicable_mr_tbl => l_appl_mrs_tbl);
4252:
4253: -- Raise errors if exceptions occur
4254: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: END IF;

Line 4255: RAISE FND_API.G_EXC_ERROR;

4251: x_applicable_mr_tbl => l_appl_mrs_tbl);
4252:
4253: -- Raise errors if exceptions occur
4254: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: END IF;
4259:

Line 4256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4252:
4253: -- Raise errors if exceptions occur
4254: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: END IF;
4259:
4260:

Line 4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4253: -- Raise errors if exceptions occur
4254: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4255: RAISE FND_API.G_EXC_ERROR;
4256: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4258: END IF;
4259:
4260:
4261:

Line 4318: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4314: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
4315:
4316:
4317:
4318: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4319: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,

Line 4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4316:
4317:
4318: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4319: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN

Line 4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4317:
4318: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4319: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

Line 4324: WHEN FND_API.G_EXC_ERROR THEN

4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4326: x_return_status := FND_API.G_RET_STS_ERROR;
4327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4328: p_count => x_msg_count,

Line 4326: x_return_status := FND_API.G_RET_STS_ERROR;

4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4326: x_return_status := FND_API.G_RET_STS_ERROR;
4327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4328: p_count => x_msg_count,
4329: p_data => x_msg_data);
4330: WHEN OTHERS THEN

Line 4327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4326: x_return_status := FND_API.G_RET_STS_ERROR;
4327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4328: p_count => x_msg_count,
4329: p_data => x_msg_data);
4330: WHEN OTHERS THEN
4331: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

Line 4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4328: p_count => x_msg_count,
4329: p_data => x_msg_data);
4330: WHEN OTHERS THEN
4331: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4335: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4336: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4335: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4336: p_error_text => SUBSTRB(SQLERRM,1,240));
4337: END IF;
4338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4339: p_count => x_msg_count,
4340: p_data => x_msg_data);
4341: END GET_VISIT_APPLICABLE_MRS;
4342:

Line 4402: RETURN FND_API.G_FALSE;

4398: OPEN validate_pc_node_csr(p_item_instance_id,p_pc_node_id);
4399: FETCH validate_pc_node_csr INTO l_junk;
4400: IF(validate_pc_node_csr%NOTFOUND)THEN
4401: CLOSE validate_pc_node_csr;
4402: RETURN FND_API.G_FALSE;
4403: END IF;
4404: CLOSE validate_pc_node_csr;
4405: RETURN FND_API.G_TRUE;
4406: */

Line 4405: RETURN FND_API.G_TRUE;

4401: CLOSE validate_pc_node_csr;
4402: RETURN FND_API.G_FALSE;
4403: END IF;
4404: CLOSE validate_pc_node_csr;
4405: RETURN FND_API.G_TRUE;
4406: */
4407:
4408: -- check for units first.
4409: OPEN validate_unit_node_csr(p_item_instance_id, p_pc_node_id);

Line 4413: RETURN FND_API.G_TRUE;

4409: OPEN validate_unit_node_csr(p_item_instance_id, p_pc_node_id);
4410: FETCH validate_unit_node_csr INTO l_junk;
4411: IF (validate_unit_node_csr%FOUND) THEN
4412: CLOSE validate_unit_node_csr;
4413: RETURN FND_API.G_TRUE;
4414: ELSE
4415: CLOSE validate_unit_node_csr;
4416: -- check for item PCs
4417: OPEN validate_itm_node_csr(p_item_instance_id, p_pc_node_id);

Line 4421: RETURN FND_API.G_TRUE;

4417: OPEN validate_itm_node_csr(p_item_instance_id, p_pc_node_id);
4418: FETCH validate_itm_node_csr INTO l_junk;
4419: IF (validate_itm_node_csr%FOUND) THEN
4420: CLOSE validate_itm_node_csr;
4421: RETURN FND_API.G_TRUE;
4422: END IF;
4423: CLOSE validate_itm_node_csr;
4424: END IF;
4425: RETURN FND_API.G_FALSE;

Line 4425: RETURN FND_API.G_FALSE;

4421: RETURN FND_API.G_TRUE;
4422: END IF;
4423: CLOSE validate_itm_node_csr;
4424: END IF;
4425: RETURN FND_API.G_FALSE;
4426:
4427:
4428: END is_pc_assoc_valid;
4429:

Line 4518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4514: -----------------------------------------
4515: -- get MR applicability even if MR is expired.
4516: PROCEDURE GET_MR_APPLICABILITY(
4517: p_api_version IN NUMBER,
4518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4521: x_return_status OUT NOCOPY VARCHAR2,
4522: x_msg_count OUT NOCOPY NUMBER,

Line 4519: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4515: -- get MR applicability even if MR is expired.
4516: PROCEDURE GET_MR_APPLICABILITY(
4517: p_api_version IN NUMBER,
4518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4521: x_return_status OUT NOCOPY VARCHAR2,
4522: x_msg_count OUT NOCOPY NUMBER,
4523: x_msg_data OUT NOCOPY VARCHAR2,

Line 4520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4516: PROCEDURE GET_MR_APPLICABILITY(
4517: p_api_version IN NUMBER,
4518: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4519: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4520: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4521: x_return_status OUT NOCOPY VARCHAR2,
4522: x_msg_count OUT NOCOPY NUMBER,
4523: x_msg_data OUT NOCOPY VARCHAR2,
4524: p_item_instance_id IN NUMBER,

Line 4797: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
4799: END IF;
4800:
4801: x_return_status := 'S';

Line 4803: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

4799: END IF;
4800:
4801: x_return_status := 'S';
4802:
4803: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
4804: l_api_name, G_PKG_NAME)
4805: THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END IF;

Line 4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4802:
4803: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
4804: l_api_name, G_PKG_NAME)
4805: THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END IF;
4808:
4809: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
4810: THEN

Line 4809: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)

4805: THEN
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END IF;
4808:
4809: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
4810: THEN
4811: -- validate input instance.
4812: OPEN check_instance_exists(p_item_instance_id);
4813: FETCH check_instance_exists INTO l_item_instance_id;

Line 4819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4815: CLOSE check_instance_exists;
4816: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
4817: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
4818: FND_MSG_PUB.ADD;
4819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4820: END IF;
4821: CLOSE check_instance_exists;
4822: END IF;
4823:

Line 4873: p_init_msg_list => fnd_api.g_false,

4869: -- for input instance.
4870: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4871: (
4872: p_api_version => 1.0,
4873: p_init_msg_list => fnd_api.g_false,
4874: p_commit => fnd_api.g_false,
4875: p_validation_level => p_validation_level,
4876: p_csi_item_instance_id => p_item_instance_id,
4877: x_return_status => l_return_status,

Line 4874: p_commit => fnd_api.g_false,

4870: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4871: (
4872: p_api_version => 1.0,
4873: p_init_msg_list => fnd_api.g_false,
4874: p_commit => fnd_api.g_false,
4875: p_validation_level => p_validation_level,
4876: p_csi_item_instance_id => p_item_instance_id,
4877: x_return_status => l_return_status,
4878: x_msg_count => l_msg_count,

Line 4883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

4879: x_msg_data => x_msg_data
4880: );
4881:
4882: -- Raise errors if exceptions occur
4883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4887: END IF;

Line 4884: RAISE FND_API.G_EXC_ERROR;

4880: );
4881:
4882: -- Raise errors if exceptions occur
4883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4887: END IF;
4888:

Line 4885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4881:
4882: -- Raise errors if exceptions occur
4883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4887: END IF;
4888:
4889: IF (p_components_flag = 'Y') THEN

Line 4886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4882: -- Raise errors if exceptions occur
4883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4884: RAISE FND_API.G_EXC_ERROR;
4885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4887: END IF;
4888:
4889: IF (p_components_flag = 'Y') THEN
4890: IF l_debug = 'Y' THEN

Line 4903: p_init_msg_list => fnd_api.g_false,

4899: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
4900: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4901: (
4902: p_api_version => 1.0,
4903: p_init_msg_list => fnd_api.g_false,
4904: p_commit => fnd_api.g_false,
4905: p_validation_level => p_validation_level,
4906: p_csi_item_instance_id => l_subj_id_tbl(j),
4907: x_return_status => l_return_status,

Line 4904: p_commit => fnd_api.g_false,

4900: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4901: (
4902: p_api_version => 1.0,
4903: p_init_msg_list => fnd_api.g_false,
4904: p_commit => fnd_api.g_false,
4905: p_validation_level => p_validation_level,
4906: p_csi_item_instance_id => l_subj_id_tbl(j),
4907: x_return_status => l_return_status,
4908: x_msg_count => l_msg_count,

Line 4912: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

4908: x_msg_count => l_msg_count,
4909: x_msg_data => x_msg_data
4910: );
4911: -- Raise errors if exceptions occur
4912: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4913: RAISE FND_API.G_EXC_ERROR;
4914: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4916: END IF;

Line 4913: RAISE FND_API.G_EXC_ERROR;

4909: x_msg_data => x_msg_data
4910: );
4911: -- Raise errors if exceptions occur
4912: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4913: RAISE FND_API.G_EXC_ERROR;
4914: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4916: END IF;
4917:

Line 4914: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4910: );
4911: -- Raise errors if exceptions occur
4912: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4913: RAISE FND_API.G_EXC_ERROR;
4914: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4916: END IF;
4917:
4918: END LOOP;

Line 4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4911: -- Raise errors if exceptions occur
4912: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4913: RAISE FND_API.G_EXC_ERROR;
4914: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4916: END IF;
4917:
4918: END LOOP;
4919: l_subj_id_tbl.DELETE;

Line 5085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5081: IF get_mr_attri%NOTFOUND THEN
5082: CLOSE get_mr_attri;
5083: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
5084: FND_MSG_PUB.add;
5085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5086: ELSE
5087: l_prev_mr_header_id := l_mr_header_id_tbl(i);
5088: CLOSE get_mr_attri;
5089: END IF; -- get_mr_attri%NOTFOUND

Line 5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5175:
5176:
5177: EXCEPTION
5178:
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 5180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5176:
5177: EXCEPTION
5178:
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 5181: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5177: EXCEPTION
5178:
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 5191: WHEN FND_API.G_EXC_ERROR THEN

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;
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);

Line 5192: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 5193: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5189: END IF;
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: x_return_status := FND_API.G_RET_STS_ERROR;
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,

Line 5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
5205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
5207: p_procedure_name => 'GET_MR_APPLICABILITY',
5208: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
5207: p_procedure_name => 'GET_MR_APPLICABILITY',
5208: p_error_text => SUBSTRB(SQLERRM,1,240));
5209: END IF;
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,