116:
117: begin
118:
119: x_msg_count := 0;
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: IF g_debug_mode = 'Y' THEN
123: pa_debug.set_curr_function( p_function => 'validate',
124: p_debug_mode => g_debug_mode );
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
307:
308: begin
309:
310: x_msg_count := 0;
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: IF g_debug_mode = 'Y' THEN
314: pa_debug.set_curr_function( p_function => 'validate',
315: p_debug_mode => g_debug_mode );
365:
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN
368:
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: l_msg_count := FND_MSG_PUB.count_msg;
371:
372: IF l_msg_count = 1 and x_msg_data IS NULL THEN
373: PA_INTERFACE_UTILS_PUB.get_messages
370: l_msg_count := FND_MSG_PUB.count_msg;
371:
372: IF l_msg_count = 1 and x_msg_data IS NULL THEN
373: PA_INTERFACE_UTILS_PUB.get_messages
374: (p_encoded => FND_API.G_TRUE
375: ,p_msg_index => 1
376: ,p_msg_count => l_msg_count
377: ,p_msg_data => l_msg_data
378: ,p_data => l_data
390: RAISE NO_DATA_FOUND;
391:
392: WHEN others THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: x_msg_count := 1;
396: x_msg_data := SQLERRM;
397:
398: FND_MSG_PUB.add_exc_msg
504: );
505:
506: WHEN others THEN
507:
508: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: l_msg_count := 1;
510: l_msg_data := SQLERRM;
511:
512: FND_MSG_PUB.add_exc_msg