[Home] [Help]
170: and uc_status_code IN ('COMPLETE', 'INCOMPLETE')
171: */
172:
173: BEGIN
174: -- Standard start of API savepoint
175: SAVEPOINT Search_Unit_Schedules_SP;
176:
177: -- Standard call to check for call compatibility
178: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
173: BEGIN
174: -- Standard start of API savepoint
175: SAVEPOINT Search_Unit_Schedules_SP;
176:
177: -- Standard call to check for call compatibility
178: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
179: THEN
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
695:
696: -- Commit by default
697: COMMIT WORK;
698:
699: -- Standard call to get message count and if count is 1, get message info
700: FND_MSG_PUB.count_and_get
701: (
702: p_count => x_msg_count,
703: p_data => x_msg_data,
853:
854:
855: BEGIN
856:
857: -- Standard call to check for call compatibility
858: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
859: THEN
860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
1362: THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:
1366: -- Standard call to get message count and if count is 1, get message info
1367: FND_MSG_PUB.count_and_get
1368: (
1369: p_count => x_msg_count,
1370: p_data => x_msg_data,
2059: -- fix for bug #5528416 - must include quarantined units
2060: and ahl_util_uc_pkg.get_uc_status_code (p_unit_config_id) NOT IN ('DRAFT', 'EXPIRED');
2061:
2062: BEGIN
2063: -- Standard call to check for call compatibility
2064: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
2065: THEN
2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2193: THEN
2194: RAISE FND_API.G_EXC_ERROR;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info
2198: FND_MSG_PUB.count_and_get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,