100: l_requested_quantity NUMBER := null;
101: l_completed_quantity NUMBER := null;
102:
103: BEGIN
104: -- Standard start of API savepoint
105: SAVEPOINT GET_AVAILABLE_SUPP_DMND_GRP;
106:
107: -- Initialize return status to success before any code logic/validation
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: -- Initialize return status to success before any code logic/validation
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: -- Standard call to check for call compatibility
111: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
278: THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: -- Standard call to get message count and if count is 1, get message info
283: FND_MSG_PUB.count_and_get
284: (
285: p_count => x_msg_count,
286: p_data => x_msg_data,
426: l_scheduled_material_id NUMBER := null;
427: --sukhwsin::Marshling enhancements - added local variable to hold job status check
428: l_job_exists VARCHAR2(1) := null;
429: BEGIN
430: -- Standard start of API savepoint
431: SAVEPOINT VALIDATE_SUPPLY_DEMAND_GRP;
432:
433: -- Initialize return status to success before any code logic/validation
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
432:
433: -- Initialize return status to success before any code logic/validation
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435:
436: -- Standard call to check for call compatibility
437: IF NOT FND_API.COMPATIBLE_API_CALL (l_api_version, p_api_version_number, l_api_name, G_PKG_NAME)
438: THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
713: THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: -- Standard call to get message count and if count is 1, get message info
718: FND_MSG_PUB.count_and_get
719: (
720: p_count => x_msg_count,
721: p_data => x_msg_data,