91:
92: BEGIN
93:
94: x_msg_count := 0;
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: IF g_debug_mode = 'Y' THEN
98: pa_debug.set_curr_function( p_function => 'validate',
99: p_debug_mode => g_debug_mode );
150:
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153:
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: l_msg_count := FND_MSG_PUB.count_msg;
156:
157: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
158: PA_INTERFACE_UTILS_PUB.get_messages
155: l_msg_count := FND_MSG_PUB.count_msg;
156:
157: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
158: PA_INTERFACE_UTILS_PUB.get_messages
159: (p_encoded => FND_API.G_TRUE
160: ,p_msg_index => 1
161: ,p_msg_count => l_msg_count
162: ,p_msg_data => l_msg_data
163: ,p_data => l_data
175: RETURN;
176:
177: WHEN OTHERS THEN
178:
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: x_msg_count := 1;
181: x_msg_data := SQLERRM;
182:
183: FND_MSG_PUB.add_exc_msg
220: BEGIN
221: NULL;
222:
223: x_msg_count := 0;
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: IF g_debug_mode = 'Y' THEN
227: pa_debug.set_curr_function( p_function => 'validate',
228: p_debug_mode => g_debug_mode );
258:
259: EXCEPTION
260: WHEN NO_DATA_FOUND THEN
261:
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: l_msg_count := FND_MSG_PUB.count_msg;
264:
265: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
266: PA_INTERFACE_UTILS_PUB.get_messages
263: l_msg_count := FND_MSG_PUB.count_msg;
264:
265: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
266: PA_INTERFACE_UTILS_PUB.get_messages
267: (p_encoded => FND_API.G_TRUE
268: ,p_msg_index => 1
269: ,p_msg_count => l_msg_count
270: ,p_msg_data => l_msg_data
271: ,p_data => l_data
283: RAISE NO_DATA_FOUND;
284:
285: WHEN OTHERS THEN
286:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: x_msg_count := 1;
289: x_msg_data := SQLERRM;
290:
291: FND_MSG_PUB.add_exc_msg
362: X_Msg_Count => l_Msg_Count );
363:
364: WHEN OTHERS THEN
365:
366: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: l_msg_count := 1;
368: l_msg_data := SQLERRM;
369:
370: FND_MSG_PUB.add_exc_msg