DBA Data[Home] [Help]

APPS.IMC_RECENT_OBJECT_ACCESS_PUB dependencies on FND_MSG_PUB

Line 21: FND_MSG_PUB.ADD;

17: /* Required Params Validation */
18: IF p_user_id IS NULL THEN
19: /* user id is invalid */
20: FND_MESSAGE.SET_NAME('IMC', g_invalid_user_id);
21: FND_MSG_PUB.ADD;
22: RAISE FND_API.G_EXC_ERROR;
23: ELSIF p_object_type IS NULL THEN
24: /* object type is invalid */
25: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_type);

Line 26: FND_MSG_PUB.ADD;

22: RAISE FND_API.G_EXC_ERROR;
23: ELSIF p_object_type IS NULL THEN
24: /* object type is invalid */
25: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_type);
26: FND_MSG_PUB.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28: ELSIF p_object_id IS NULL THEN
29: /* object id is invalid */
30: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_id);

Line 31: FND_MSG_PUB.ADD;

27: RAISE FND_API.G_EXC_ERROR;
28: ELSIF p_object_id IS NULL THEN
29: /* object id is invalid */
30: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_id);
31: FND_MSG_PUB.ADD;
32: RAISE FND_API.G_EXC_ERROR;
33: ELSIF p_object_name IS NULL THEN
34: /* object name is invalid */
35: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_name);

Line 36: FND_MSG_PUB.ADD;

32: RAISE FND_API.G_EXC_ERROR;
33: ELSIF p_object_name IS NULL THEN
34: /* object name is invalid */
35: FND_MESSAGE.SET_NAME('IMC', g_invalid_object_name);
36: FND_MSG_PUB.ADD;
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39:
40: -- dbms_output.put_line('Inside record_exists...');

Line 70: FND_MSG_PUB.ADD;

66:
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('IMC', g_recent_api_others_ex);
69: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
70: FND_MSG_PUB.ADD;
71: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
72:
73: END Record_Exists;
74:

Line 426: FND_MSG_PUB.Count_And_Get (

422:
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MSG_PUB.Count_And_Get (
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data
430: );

Line 433: FND_MSG_PUB.Count_And_Get (

429: p_data => x_msg_data
430: );
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: FND_MSG_PUB.Count_And_Get (
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
436: p_data => x_msg_data
437: );

Line 440: FND_MSG_PUB.Count_And_Get (

436: p_data => x_msg_data
437: );
438: WHEN OTHERS THEN
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.Count_And_Get (
441: p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data
444: );

Line 472: FND_MSG_PUB.ADD;

468: /* Required Params Validation */
469: IF p_user_id IS NULL THEN
470: /* user id is invalid */
471: FND_MESSAGE.SET_NAME('IMC', g_invalid_user_id);
472: FND_MSG_PUB.ADD;
473: RAISE FND_API.G_EXC_ERROR;
474: ELSE
475: l_query := 'SELECT object_type, object_id, object_name, date_created ' ||
476: 'FROM IMC_RECENT_ACCESSED_OBJ ';

Line 514: FND_MSG_PUB.ADD;

510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513: FND_MESSAGE.SET_NAME('IMC', g_no_objs_recently_accessed);
514: FND_MSG_PUB.ADD;
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data

Line 515: FND_MSG_PUB.Count_And_Get (

511: WHEN NO_DATA_FOUND THEN
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513: FND_MESSAGE.SET_NAME('IMC', g_no_objs_recently_accessed);
514: FND_MSG_PUB.ADD;
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );

Line 522: FND_MSG_PUB.Count_And_Get (

518: p_data => x_msg_data
519: );
520: WHEN FND_API.G_EXC_ERROR THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );

Line 529: FND_MSG_PUB.Count_And_Get (

525: p_data => x_msg_data
526: );
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MSG_PUB.Count_And_Get (
530: p_encoded => FND_API.G_FALSE,
531: p_count => x_msg_count,
532: p_data => x_msg_data
533: );

Line 536: FND_MSG_PUB.Count_And_Get (

532: p_data => x_msg_data
533: );
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 571: FND_MSG_PUB.ADD;

567: /* Required Params Validation */
568: IF p_user_id IS NULL THEN
569: /* user id is invalid */
570: FND_MESSAGE.SET_NAME('IMC', g_invalid_user_id);
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_ERROR;
573: ELSE
574: -- l_max_records := NVL(FND_PROFILE.value(g_store_max_profile), g_default_max_store);
575: l_max_records := NVL(FND_PROFILE.value(g_display_max_profile), g_default_max_display);

Line 616: FND_MSG_PUB.ADD;

612: EXCEPTION
613: WHEN NO_DATA_FOUND THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MESSAGE.SET_NAME('IMC', g_could_not_delete_entry);
616: FND_MSG_PUB.ADD;
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data

Line 617: FND_MSG_PUB.Count_And_Get (

613: WHEN NO_DATA_FOUND THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: FND_MESSAGE.SET_NAME('IMC', g_could_not_delete_entry);
616: FND_MSG_PUB.ADD;
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );

Line 624: FND_MSG_PUB.Count_And_Get (

620: p_data => x_msg_data
621: );
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );

Line 631: FND_MSG_PUB.Count_And_Get (

627: p_data => x_msg_data
628: );
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.Count_And_Get (
632: p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data
635: );

Line 638: FND_MSG_PUB.Count_And_Get (

634: p_data => x_msg_data
635: );
636: WHEN OTHERS THEN
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: FND_MSG_PUB.Count_And_Get (
639: p_encoded => FND_API.G_FALSE,
640: p_count => x_msg_count,
641: p_data => x_msg_data
642: );