106:
107: BEGIN
108:
109: x_msg_count := 0;
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
112:
113: IF l_debug_mode = 'Y' THEN
114: pa_debug.set_curr_function( p_function => 'validate',
226:
227: EXCEPTION
228: WHEN NO_DATA_FOUND THEN
229:
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: l_msg_count := FND_MSG_PUB.count_msg;
232:
233: IF l_msg_count = 1 and x_msg_data IS NULL THEN
234: PA_INTERFACE_UTILS_PUB.get_messages
231: l_msg_count := FND_MSG_PUB.count_msg;
232:
233: IF l_msg_count = 1 and x_msg_data IS NULL THEN
234: PA_INTERFACE_UTILS_PUB.get_messages
235: (p_encoded => FND_API.G_TRUE
236: ,p_msg_index => 1
237: ,p_msg_count => l_msg_count
238: ,p_msg_data => l_msg_data
239: ,p_data => l_data
251: RETURN;
252:
253: WHEN others THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: x_msg_count := 1;
257: x_msg_data := SQLERRM;
258:
259: FND_MSG_PUB.add_exc_msg
309:
310: BEGIN
311:
312: x_msg_count := 0;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
315:
316: IF l_debug_mode = 'Y' THEN
317: pa_debug.set_curr_function( p_function => 'validate',
377:
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: l_msg_count := FND_MSG_PUB.count_msg;
383:
384: IF l_msg_count = 1 and x_msg_data IS NULL THEN
385: PA_INTERFACE_UTILS_PUB.get_messages
382: l_msg_count := FND_MSG_PUB.count_msg;
383:
384: IF l_msg_count = 1 and x_msg_data IS NULL THEN
385: PA_INTERFACE_UTILS_PUB.get_messages
386: (p_encoded => FND_API.G_TRUE
387: ,p_msg_index => 1
388: ,p_msg_count => l_msg_count
389: ,p_msg_data => l_msg_data
390: ,p_data => l_data
402: RAISE NO_DATA_FOUND;
403:
404: WHEN others THEN
405:
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_msg_count := 1;
408: x_msg_data := SQLERRM;
409:
410: FND_MSG_PUB.add_exc_msg
521: X_Msg_Count => l_Msg_Count );
522:
523: WHEN others THEN
524:
525: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: l_msg_count := 1;
527: l_msg_data := SQLERRM;
528:
529: FND_MSG_PUB.add_exc_msg