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 FND_API

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

59:
60: -- Define Procedure GET_MR_AFFECTED_ITEMS --
61: PROCEDURE GET_MR_AFFECTED_ITEMS(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,

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

60: -- Define Procedure GET_MR_AFFECTED_ITEMS --
61: PROCEDURE GET_MR_AFFECTED_ITEMS(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,

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

61: PROCEDURE GET_MR_AFFECTED_ITEMS(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64: p_commit IN VARCHAR2 := FND_API.G_FALSE,
65: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2,
69: p_mr_header_id IN NUMBER,

Line 684: IF FND_API.to_boolean(p_init_msg_list) THEN

680: IF l_debug = 'Y' THEN
681: AHL_DEBUG_PUB.enable_debug;
682: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
683: END IF;
684: IF FND_API.to_boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687: x_return_status := 'S';
688: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 688: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

684: IF FND_API.to_boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687: x_return_status := 'S';
688: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
689: p_api_version,
690: l_api_name,
691: G_PKG_NAME)
692: THEN

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689: p_api_version,
690: l_api_name,
691: G_PKG_NAME)
692: THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: -- Check whether the mr_header_id exists --
696: AHL_DEBUG_PUB.debug(' Phase 1');
697:

Line 707: RAISE FND_API.G_EXC_ERROR;

703: IF check_mr_exists%NOTFOUND THEN
704: CLOSE check_mr_exists;
705: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709: CLOSE check_mr_exists;
710: AHL_DEBUG_PUB.debug(' Phase 2');
711:

Line 724: p_init_msg_list =>FND_API.G_FALSE,

720: THEN
721: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
722: (
723: p_api_version =>p_api_version,
724: p_init_msg_list =>FND_API.G_FALSE,
725: p_commit =>FND_API.G_FALSE,
726: p_validation_level=>p_validation_level,
727: p_position_id =>l_mr_effect.relationship_id,
728: x_return_status =>l_return_Status,

Line 725: p_commit =>FND_API.G_FALSE,

721: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
722: (
723: p_api_version =>p_api_version,
724: p_init_msg_list =>FND_API.G_FALSE,
725: p_commit =>FND_API.G_FALSE,
726: p_validation_level=>p_validation_level,
727: p_position_id =>l_mr_effect.relationship_id,
728: x_return_status =>l_return_Status,
729: x_msg_count =>l_msg_count,

Line 752: RAISE FND_API.G_EXC_ERROR;

748: END LOOP;
749: CLOSE check_mr_effect;
750: IF L_ERROR_FLAG='Y'
751: THEN
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754: AHL_DEBUG_PUB.debug(' Phase 3 relation...' ||l_mr_effect.relationship_id);
755:
756: -- To avoid being in the same database session when refreshing or table navigating

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

991: END IF;
992: END IF;
993:
994: --DBMS_OUTPUT.put_line('API1: Just before commit and l_index= '||l_index);
995: --IF FND_API.TO_BOOLEAN(p_commit) THEN
996: -- COMMIT;
997: --END IF;
998: IF l_debug = 'Y' THEN
999: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');

Line 1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

998: IF l_debug = 'Y' THEN
999: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1000: AHL_DEBUG_PUB.disable_debug;
1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1000: AHL_DEBUG_PUB.disable_debug;
1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data);
1008: IF l_debug = 'Y' THEN

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

1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data);
1008: IF l_debug = 'Y' THEN
1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 1014: WHEN FND_API.G_EXC_ERROR THEN

1010: 'UNEXPECTED ERROR IN PRIVATE:' );
1011: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
1012: AHL_DEBUG_PUB.disable_debug;
1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: AHL_DEBUG_PUB.disable_debug;
1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: IF l_debug = 'Y' THEN

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

1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: IF l_debug = 'Y' THEN
1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024: AHL_DEBUG_PUB.disable_debug;
1025: END IF;
1026: WHEN OTHERS THEN
1027: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1030: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1031: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1032: p_error_text => SUBSTR(SQLERRM,1,240));

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

1030: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1031: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1032: p_error_text => SUBSTR(SQLERRM,1,240));
1033: END IF;
1034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);
1037: IF l_debug = 'Y' THEN
1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

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

1045: -- This API is revamped to fix Bug 6266738
1046: -- Define procedure GET_APPLICABLE_MRS --
1047: PROCEDURE GET_APPLICABLE_MRS(
1048: p_api_version IN NUMBER,
1049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1050: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,

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

1046: -- Define procedure GET_APPLICABLE_MRS --
1047: PROCEDURE GET_APPLICABLE_MRS(
1048: p_api_version IN NUMBER,
1049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1050: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,
1054: x_msg_data OUT NOCOPY VARCHAR2,

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

1047: PROCEDURE GET_APPLICABLE_MRS(
1048: p_api_version IN NUMBER,
1049: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1050: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1051: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,
1054: x_msg_data OUT NOCOPY VARCHAR2,
1055: p_item_instance_id IN NUMBER,

Line 1833: IF FND_API.to_boolean(p_init_msg_list) THEN

1829: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt);
1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;
1832:
1833: IF FND_API.to_boolean(p_init_msg_list) THEN
1834: FND_MSG_PUB.initialize;
1835: END IF;
1836:
1837: x_return_status := 'S';

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

1835: END IF;
1836:
1837: x_return_status := 'S';
1838:
1839: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
1840: l_api_name, G_PKG_NAME)
1841: THEN
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END IF;

Line 1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1838:
1839: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
1840: l_api_name, G_PKG_NAME)
1841: THEN
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END IF;
1844:
1845: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
1846: THEN

Line 1845: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)

1841: THEN
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END IF;
1844:
1845: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
1846: THEN
1847: -- validate input instance.
1848: OPEN check_instance_exists(p_item_instance_id);
1849: FETCH check_instance_exists INTO l_item_instance_id;

Line 1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1851: CLOSE check_instance_exists;
1852: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
1853: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
1854: FND_MSG_PUB.ADD;
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857: CLOSE check_instance_exists;
1858: END IF;
1859:

Line 1929: p_init_msg_list => fnd_api.g_false,

1925: -- for input instance.
1926: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1927: (
1928: p_api_version => 1.0,
1929: p_init_msg_list => fnd_api.g_false,
1930: p_commit => fnd_api.g_false,
1931: p_validation_level => p_validation_level,
1932: p_csi_item_instance_id => p_item_instance_id,
1933: x_return_status => l_return_status,

Line 1930: p_commit => fnd_api.g_false,

1926: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1927: (
1928: p_api_version => 1.0,
1929: p_init_msg_list => fnd_api.g_false,
1930: p_commit => fnd_api.g_false,
1931: p_validation_level => p_validation_level,
1932: p_csi_item_instance_id => p_item_instance_id,
1933: x_return_status => l_return_status,
1934: x_msg_count => l_msg_count,

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

1935: x_msg_data => x_msg_data
1936: );
1937:
1938: -- Raise errors if exceptions occur
1939: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1940: RAISE FND_API.G_EXC_ERROR;
1941: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1943: END IF;

Line 1940: RAISE FND_API.G_EXC_ERROR;

1936: );
1937:
1938: -- Raise errors if exceptions occur
1939: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1940: RAISE FND_API.G_EXC_ERROR;
1941: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1943: END IF;
1944:

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

1937:
1938: -- Raise errors if exceptions occur
1939: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1940: RAISE FND_API.G_EXC_ERROR;
1941: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1943: END IF;
1944:
1945: IF (p_components_flag = 'Y') THEN

Line 1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1938: -- Raise errors if exceptions occur
1939: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1940: RAISE FND_API.G_EXC_ERROR;
1941: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1943: END IF;
1944:
1945: IF (p_components_flag = 'Y') THEN
1946: IF l_debug = 'Y' THEN

Line 1959: p_init_msg_list => fnd_api.g_false,

1955: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
1956: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1957: (
1958: p_api_version => 1.0,
1959: p_init_msg_list => fnd_api.g_false,
1960: p_commit => fnd_api.g_false,
1961: p_validation_level => p_validation_level,
1962: p_csi_item_instance_id => l_subj_id_tbl(j),
1963: x_return_status => l_return_status,

Line 1960: p_commit => fnd_api.g_false,

1956: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1957: (
1958: p_api_version => 1.0,
1959: p_init_msg_list => fnd_api.g_false,
1960: p_commit => fnd_api.g_false,
1961: p_validation_level => p_validation_level,
1962: p_csi_item_instance_id => l_subj_id_tbl(j),
1963: x_return_status => l_return_status,
1964: x_msg_count => l_msg_count,

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

1964: x_msg_count => l_msg_count,
1965: x_msg_data => x_msg_data
1966: );
1967: -- Raise errors if exceptions occur
1968: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1969: RAISE FND_API.G_EXC_ERROR;
1970: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF;

Line 1969: RAISE FND_API.G_EXC_ERROR;

1965: x_msg_data => x_msg_data
1966: );
1967: -- Raise errors if exceptions occur
1968: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1969: RAISE FND_API.G_EXC_ERROR;
1970: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF;
1973:

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

1966: );
1967: -- Raise errors if exceptions occur
1968: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1969: RAISE FND_API.G_EXC_ERROR;
1970: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF;
1973:
1974: END LOOP;

Line 1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1967: -- Raise errors if exceptions occur
1968: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1969: RAISE FND_API.G_EXC_ERROR;
1970: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972: END IF;
1973:
1974: END LOOP;
1975: l_subj_id_tbl.DELETE;

Line 2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2178: IF get_mr_attri%NOTFOUND THEN
2179: CLOSE get_mr_attri;
2180: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
2181: FND_MSG_PUB.add;
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: ELSE
2184: l_prev_mr_header_id := l_mr_header_id_tbl(i);
2185: CLOSE get_mr_attri;
2186: END IF; -- get_mr_attri%NOTFOUND

Line 2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2271:
2272:
2273: EXCEPTION
2274:
2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2276: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,

Line 2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2273: EXCEPTION
2274:
2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2276: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281: IF l_debug = 'Y' THEN

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

2274:
2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2276: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281: IF l_debug = 'Y' THEN
2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 2288: WHEN FND_API.G_EXC_ERROR THEN

2284: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_APPLICABLE_MRS');
2285: AHL_DEBUG_PUB.disable_debug;
2286: END IF;
2287:
2288: WHEN FND_API.G_EXC_ERROR THEN
2289: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2292: p_count => x_msg_count,

Line 2290: x_return_status := FND_API.G_RET_STS_ERROR;

2286: END IF;
2287:
2288: WHEN FND_API.G_EXC_ERROR THEN
2289: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2292: p_count => x_msg_count,
2293: p_data => x_msg_data);
2294: IF l_debug = 'Y' THEN

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

2287:
2288: WHEN FND_API.G_EXC_ERROR THEN
2289: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2292: p_count => x_msg_count,
2293: p_data => x_msg_data);
2294: IF l_debug = 'Y' THEN
2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2299: END IF;
2300:
2301: WHEN OTHERS THEN
2302: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
2306: p_procedure_name => 'GET_APPLICABLE_MRS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));

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

2305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
2306: p_procedure_name => 'GET_APPLICABLE_MRS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));
2308: END IF;
2309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count,
2311: p_data => x_msg_data);
2312: IF l_debug = 'Y' THEN
2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2705: CLOSE get_inst_attributes;
2706: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
2707: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
2708: FND_MSG_PUB.add;
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: RETURN match_dtl;
2711: END IF;
2712: CLOSE get_inst_attributes;
2713: --DBMS_OUTPUT.PUT_LINE('In check effectivity detail function and before the loop');

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

2946: END check_sn_outside;
2947:
2948: PROCEDURE GET_PM_APPLICABLE_MRS (
2949: p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2951: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2952: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2953: x_return_status OUT NOCOPY VARCHAR2,
2954: x_msg_count OUT NOCOPY NUMBER,

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

2947:
2948: PROCEDURE GET_PM_APPLICABLE_MRS (
2949: p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2951: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2952: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2953: x_return_status OUT NOCOPY VARCHAR2,
2954: x_msg_count OUT NOCOPY NUMBER,
2955: x_msg_data OUT NOCOPY VARCHAR2,

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

2948: PROCEDURE GET_PM_APPLICABLE_MRS (
2949: p_api_version IN NUMBER,
2950: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2951: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2952: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2953: x_return_status OUT NOCOPY VARCHAR2,
2954: x_msg_count OUT NOCOPY NUMBER,
2955: x_msg_data OUT NOCOPY VARCHAR2,
2956: p_item_instance_id IN NUMBER,

Line 3016: IF FND_API.to_boolean(p_init_msg_list) THEN

3012: AHL_DEBUG_PUB.enable_debug;
3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3014: AHL_DEBUG_PUB.debug('');
3015: END IF;
3016: IF FND_API.to_boolean(p_init_msg_list) THEN
3017: FND_MSG_PUB.initialize;
3018: END IF;
3019: x_return_status := 'S';
3020: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,

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

3016: IF FND_API.to_boolean(p_init_msg_list) THEN
3017: FND_MSG_PUB.initialize;
3018: END IF;
3019: x_return_status := 'S';
3020: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3021: l_api_name, G_PKG_NAME)
3022: THEN
3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3024: END IF;

Line 3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3019: x_return_status := 'S';
3020: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3021: l_api_name, G_PKG_NAME)
3022: THEN
3023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3024: END IF;
3025:
3026: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3027: IF l_appln_code <> 'PM' THEN

Line 3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3026: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3027: IF l_appln_code <> 'PM' THEN
3028: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3029: FND_MSG_PUB.add;
3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3031: END IF;
3032:
3033: OPEN check_instance_exists(p_item_instance_id);
3034: FETCH check_instance_exists INTO l_item_instance_id;

Line 3040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3036: CLOSE check_instance_exists;
3037: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3038: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
3039: FND_MSG_PUB.ADD;
3040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3041: END IF;
3042: CLOSE check_instance_exists;
3043:
3044: OPEN get_inventory_item(p_item_instance_id);

Line 3051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3047: CLOSE get_inventory_item;
3048: FND_MESSAGE.set_name('AHL', 'AHL_FMP_ITEM_NOT_EXISTS');
3049: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3050: FND_MSG_PUB.add;
3051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3052: END IF;
3053: CLOSE get_inventory_item;
3054:
3055: IF l_debug = 'Y' THEN

Line 3079: p_init_msg_list => FND_API.G_TRUE,

3075: l_inp_rec.sort_key := NULL;
3076:
3077: OKS_PM_ENTITLEMENTS_PUB.get_pm_contracts
3078: ( p_api_version => 1.0,
3079: p_init_msg_list => FND_API.G_TRUE,
3080: p_inp_rec => l_inp_rec,
3081: x_return_status => l_return_status,
3082: x_msg_count => l_msg_count,
3083: x_msg_data => l_msg_data,

Line 3089: RAISE FND_API.G_EXC_ERROR;

3085: x_pm_activities => l_pm_activities );
3086: IF l_msg_count > 0 THEN
3087: FND_MESSAGE.set_name('AHL', 'AHL_FMP_CALLING_OKS_API_ERROR');
3088: FND_MSG_PUB.add;
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091:
3092: IF l_debug = 'Y' THEN
3093: AHL_DEBUG_PUB.debug('Count on ent_contracts:' || l_ent_contracts.count);

Line 3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3188: IF get_mr_attri%NOTFOUND THEN
3189: CLOSE get_mr_attri;
3190: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
3191: FND_MSG_PUB.add;
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSE
3194: x_applicable_activities_tbl(i).repetitive_flag := l_get_mr_attri.repetitive_flag;
3195: x_applicable_activities_tbl(i).show_repetitive_code := l_get_mr_attri.show_repetitive_code;
3196: x_applicable_activities_tbl(i).whichever_first_code := l_get_mr_attri.whichever_first_code;

Line 3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3204: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3205: AHL_DEBUG_PUB.disable_debug;
3206: END IF;
3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,

Line 3210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3206: END IF;
3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data);
3214: IF l_debug = 'Y' THEN

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

3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data);
3214: IF l_debug = 'Y' THEN
3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 3220: WHEN FND_API.G_EXC_ERROR THEN

3216: 'UNEXPECTED ERROR IN PRIVATE:' );
3217: AHL_DEBUG_PUB.debug('AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3218: AHL_DEBUG_PUB.disable_debug;
3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3224: p_count => x_msg_count,

Line 3222: x_return_status := FND_API.G_RET_STS_ERROR;

3218: AHL_DEBUG_PUB.disable_debug;
3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: IF l_debug = 'Y' THEN

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

3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: IF l_debug = 'Y' THEN
3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3230: AHL_DEBUG_PUB.disable_debug;
3231: END IF;
3232: WHEN OTHERS THEN
3233: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3236: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3237: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3236: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3237: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));
3239: END IF;
3240: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data);
3243: IF l_debug = 'Y' THEN
3244:

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

3252:
3253:
3254: PROCEDURE get_visit_applicable_mrs (
3255: p_api_version IN NUMBER,
3256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3259: x_return_status OUT NOCOPY VARCHAR2,
3260: x_msg_count OUT NOCOPY NUMBER,

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

3253:
3254: PROCEDURE get_visit_applicable_mrs (
3255: p_api_version IN NUMBER,
3256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3259: x_return_status OUT NOCOPY VARCHAR2,
3260: x_msg_count OUT NOCOPY NUMBER,
3261: x_msg_data OUT NOCOPY VARCHAR2,

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

3254: PROCEDURE get_visit_applicable_mrs (
3255: p_api_version IN NUMBER,
3256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3259: x_return_status OUT NOCOPY VARCHAR2,
3260: x_msg_count OUT NOCOPY NUMBER,
3261: x_msg_data OUT NOCOPY VARCHAR2,
3262: p_item_instance_id IN NUMBER,

Line 3277: p_init_msg_list => FND_API.G_FALSE,

3273:
3274: -- call api to fetch all applicable mrs for ASO installation.
3275: AHL_FMP_PVT.get_applicable_mrs(
3276: p_api_version => l_api_version,
3277: p_init_msg_list => FND_API.G_FALSE,
3278: p_commit => FND_API.G_FALSE,
3279: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3280: x_return_status => x_return_status,
3281: x_msg_count => x_msg_count,

Line 3278: p_commit => FND_API.G_FALSE,

3274: -- call api to fetch all applicable mrs for ASO installation.
3275: AHL_FMP_PVT.get_applicable_mrs(
3276: p_api_version => l_api_version,
3277: p_init_msg_list => FND_API.G_FALSE,
3278: p_commit => FND_API.G_FALSE,
3279: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3280: x_return_status => x_return_status,
3281: x_msg_count => x_msg_count,
3282: x_msg_data => x_msg_data,

Line 3279: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3275: AHL_FMP_PVT.get_applicable_mrs(
3276: p_api_version => l_api_version,
3277: p_init_msg_list => FND_API.G_FALSE,
3278: p_commit => FND_API.G_FALSE,
3279: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3280: x_return_status => x_return_status,
3281: x_msg_count => x_msg_count,
3282: x_msg_data => x_msg_data,
3283: p_item_instance_id => p_item_instance_id,

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

3286: p_visit_type_code => p_visit_type_code,
3287: x_applicable_mr_tbl => l_appl_mrs_tbl);
3288:
3289: -- Raise errors if exceptions occur
3290: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3291: RAISE FND_API.G_EXC_ERROR;
3292: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3294: END IF;

Line 3291: RAISE FND_API.G_EXC_ERROR;

3287: x_applicable_mr_tbl => l_appl_mrs_tbl);
3288:
3289: -- Raise errors if exceptions occur
3290: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3291: RAISE FND_API.G_EXC_ERROR;
3292: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3294: END IF;
3295:

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

3288:
3289: -- Raise errors if exceptions occur
3290: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3291: RAISE FND_API.G_EXC_ERROR;
3292: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3294: END IF;
3295:
3296:

Line 3293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3289: -- Raise errors if exceptions occur
3290: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3291: RAISE FND_API.G_EXC_ERROR;
3292: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3294: END IF;
3295:
3296:
3297:

Line 3354: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3350: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
3351:
3352:
3353:
3354: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3358: p_count => x_msg_count,

Line 3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3352:
3353:
3354: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3358: p_count => x_msg_count,
3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN

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

3353:
3354: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3358: p_count => x_msg_count,
3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

Line 3360: WHEN FND_API.G_EXC_ERROR THEN

3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3358: p_count => x_msg_count,
3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3362: x_return_status := FND_API.G_RET_STS_ERROR;
3363: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,

Line 3362: x_return_status := FND_API.G_RET_STS_ERROR;

3358: p_count => x_msg_count,
3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3362: x_return_status := FND_API.G_RET_STS_ERROR;
3363: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,
3365: p_data => x_msg_data);
3366: WHEN OTHERS THEN

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

3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3362: x_return_status := FND_API.G_RET_STS_ERROR;
3363: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,
3365: p_data => x_msg_data);
3366: WHEN OTHERS THEN
3367: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

Line 3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3364: p_count => x_msg_count,
3365: p_data => x_msg_data);
3366: WHEN OTHERS THEN
3367: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3370: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3371: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3372: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3370: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3371: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3372: p_error_text => SUBSTRB(SQLERRM,1,240));
3373: END IF;
3374: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3375: p_count => x_msg_count,
3376: p_data => x_msg_data);
3377: END GET_VISIT_APPLICABLE_MRS;
3378: