DBA Data[Home] [Help]

APPS.PV_ENRL_PREREQ_BINS_PUB dependencies on FND_API

Line 161: x_return_status := FND_API.G_RET_STS_SUCCESS;

157:
158: BEGIN
159: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
160:
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: -- ------------------------------------------------------------------------
164: -- Get partner selection attribute value and append them to the record
165: -- of tables, l_match_attr_rec.

Line 254: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

250: , x_msg_data => x_msg_data
251: );
252: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
253:
254: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
255: Debug('x_return_status <> FND_API.G_RET_STS_SUCCESS');
256: RAISE Fnd_Api.G_EXC_ERROR;
257: END IF;
258: ELSE -- IF l_attr_tbl.count = 0

Line 255: Debug('x_return_status <> FND_API.G_RET_STS_SUCCESS');

251: );
252: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
253:
254: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
255: Debug('x_return_status <> FND_API.G_RET_STS_SUCCESS');
256: RAISE Fnd_Api.G_EXC_ERROR;
257: END IF;
258: ELSE -- IF l_attr_tbl.count = 0
259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 256: RAISE Fnd_Api.G_EXC_ERROR;

252: --FND_MSG_PUB.g_msg_level_threshold := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
253:
254: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
255: Debug('x_return_status <> FND_API.G_RET_STS_SUCCESS');
256: RAISE Fnd_Api.G_EXC_ERROR;
257: END IF;
258: ELSE -- IF l_attr_tbl.count = 0
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260: -- If there is no attribute, l_attr_matched_id_tbl will not be set (will be null)

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255: Debug('x_return_status <> FND_API.G_RET_STS_SUCCESS');
256: RAISE Fnd_Api.G_EXC_ERROR;
257: END IF;
258: ELSE -- IF l_attr_tbl.count = 0
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260: -- If there is no attribute, l_attr_matched_id_tbl will not be set (will be null)
261: -- go to ELSIF (l_attr_matched_id_tbl is null)
262: END IF;
263:

Line 330: WHEN Fnd_Api.G_EXC_ERROR THEN

326:
327: Debug('END get_matched_partners');
328:
329: EXCEPTION
330: WHEN Fnd_Api.G_EXC_ERROR THEN
331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: Fnd_Msg_Pub.Count_And_Get (
334: p_encoded => Fnd_Api.G_FALSE,

Line 331: x_return_status := Fnd_Api.G_RET_STS_ERROR;

327: Debug('END get_matched_partners');
328:
329: EXCEPTION
330: WHEN Fnd_Api.G_EXC_ERROR THEN
331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: Fnd_Msg_Pub.Count_And_Get (
334: p_encoded => Fnd_Api.G_FALSE,
335: p_count => x_msg_count,

Line 334: p_encoded => Fnd_Api.G_FALSE,

330: WHEN Fnd_Api.G_EXC_ERROR THEN
331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
332: -- Standard call to get message count and if count=1, get the message
333: Fnd_Msg_Pub.Count_And_Get (
334: p_encoded => Fnd_Api.G_FALSE,
335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338: WHEN OTHERS THEN

Line 339: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

335: p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338: WHEN OTHERS THEN
339: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
340: -- Standard call to get message count and if count=1, get the message
341: Fnd_Msg_Pub.Count_And_Get (
342: p_encoded => Fnd_Api.G_FALSE,
343: p_count => x_msg_count,

Line 342: p_encoded => Fnd_Api.G_FALSE,

338: WHEN OTHERS THEN
339: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
340: -- Standard call to get message count and if count=1, get the message
341: Fnd_Msg_Pub.Count_And_Get (
342: p_encoded => Fnd_Api.G_FALSE,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: END get_matched_partners;

Line 504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

500: );
501:
502: Debug('get_matched_partners(): x_return_status = ' || l_return_status);
503:
504: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
505: Debug('get_matched_partners failed when program_id = ' || x.program_id);
506: FND_MESSAGE.SET_NAME(application => 'PV',
507: name => 'PV_MATCH_PARTNERS_FAILED');
508: FND_MESSAGE.SET_TOKEN(token => 'P_PROGRAM_ID',

Line 516: RAISE Fnd_Api.G_EXC_ERROR;

512: FND_FILE.NEW_LINE( FND_FILE.LOG, 1 );
513: ELSE
514: FND_MSG_PUB.Add;
515: END IF;
516: RAISE Fnd_Api.G_EXC_ERROR;
517: END IF;
518:
519: IF (l_matched_id_tbl is not null) THEN
520: Debug('l_matched_id_tbl is not null');

Line 607: WHEN Fnd_Api.G_EXC_ERROR THEN

603: ROUND((l_elapsed_time/6000), 2) || ' minutes');
604: Debug('=====================================================================');
605:
606: EXCEPTION
607: WHEN Fnd_Api.G_EXC_ERROR THEN
608: IF l_msg_count > 1 THEN
609: fnd_msg_pub.reset;
610: FOR i IN 1..l_msg_count LOOP
611: Debug(fnd_msg_pub.get(p_encoded => fnd_api.g_false));

Line 611: Debug(fnd_msg_pub.get(p_encoded => fnd_api.g_false));

607: WHEN Fnd_Api.G_EXC_ERROR THEN
608: IF l_msg_count > 1 THEN
609: fnd_msg_pub.reset;
610: FOR i IN 1..l_msg_count LOOP
611: Debug(fnd_msg_pub.get(p_encoded => fnd_api.g_false));
612: END LOOP;
613: ELSE
614: Debug(l_msg_data);
615: END IF;