eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IMC_RECENT_OBJECT_ACCESS_PUB dependencies on FND_API

Line 22: RAISE FND_API.G_EXC_ERROR;

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);
26: FND_MSG_PUB.ADD;

Line 27: 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);
31: FND_MSG_PUB.ADD;

Line 32: 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);
36: FND_MSG_PUB.ADD;

Line 37: 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...');
41:

Line 61: WHEN FND_API.G_EXC_ERROR THEN

57: EXCEPTION
58: WHEN NO_DATA_FOUND THEN
59: RETURN 'N';
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62: RETURN FND_API.G_RET_STS_ERROR;
63:
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

Line 62: RETURN FND_API.G_RET_STS_ERROR;

58: WHEN NO_DATA_FOUND THEN
59: RETURN 'N';
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62: RETURN FND_API.G_RET_STS_ERROR;
63:
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
66:

Line 64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

60:
61: WHEN FND_API.G_EXC_ERROR THEN
62: RETURN FND_API.G_RET_STS_ERROR;
63:
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
66:
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('IMC', g_recent_api_others_ex);

Line 65: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

61: WHEN FND_API.G_EXC_ERROR THEN
62: RETURN FND_API.G_RET_STS_ERROR;
63:
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
66:
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('IMC', g_recent_api_others_ex);
69: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

Line 71: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

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:
75: /*=======================================================================*/

Line 105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),

101: UPDATE IMC_RECENT_ACCESSED_OBJ SET
102: ACCESS_ID = p_new_access_id,
103: OBJECT_TYPE = p_object_type,
104: OBJECT_ID = p_object_id,
105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),

Line 106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),

102: ACCESS_ID = p_new_access_id,
103: OBJECT_TYPE = p_object_type,
104: OBJECT_ID = p_object_id,
105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),

Line 108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),

104: OBJECT_ID = p_object_id,
105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),

Line 109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),

105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
113: OBJECT_VERSION_NUMBER = p_object_version_number,

Line 110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),

106: APPLICATION_ID = DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
113: OBJECT_VERSION_NUMBER = p_object_version_number,
114: CREATED_BY = p_created_by,

Line 111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),

107: DATE_CREATED = p_date_created,
108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
113: OBJECT_VERSION_NUMBER = p_object_version_number,
114: CREATED_BY = p_created_by,
115: CREATION_DATE = p_creation_date,

Line 112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),

108: ADDITIONAL_VALUE1 = DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
109: ADDITIONAL_VALUE2 = DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
110: ADDITIONAL_VALUE3 = DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
111: ADDITIONAL_VALUE4 = DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
112: ADDITIONAL_VALUE5 = DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
113: OBJECT_VERSION_NUMBER = p_object_version_number,
114: CREATED_BY = p_created_by,
115: CREATION_DATE = p_creation_date,
116: LAST_UPDATED_BY = p_last_updated_by,

Line 178: DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),

174: p_access_id,
175: p_user_id,
176: p_object_type,
177: p_object_id,
178: DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),

Line 179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),

175: p_user_id,
176: p_object_type,
177: p_object_id,
178: DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),

Line 181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),

177: p_object_id,
178: DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),

Line 182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),

178: DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),
179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
186: p_object_version_number,

Line 183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),

179: DECODE(p_application_id, FND_API.G_MISS_NUM, NULL, p_application_id),
180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
186: p_object_version_number,
187: p_created_by,

Line 184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),

180: p_date_created,
181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
186: p_object_version_number,
187: p_created_by,
188: p_creation_date,

Line 185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),

181: DECODE(p_additional_value1, FND_API.G_MISS_CHAR, NULL, p_additional_value1),
182: DECODE(p_additional_value2, FND_API.G_MISS_CHAR, NULL, p_additional_value2),
183: DECODE(p_additional_value3, FND_API.G_MISS_CHAR, NULL, p_additional_value3),
184: DECODE(p_additional_value4, FND_API.G_MISS_CHAR, NULL, p_additional_value4),
185: DECODE(p_additional_value5, FND_API.G_MISS_CHAR, NULL, p_additional_value5),
186: p_object_version_number,
187: p_created_by,
188: p_creation_date,
189: p_last_updated_by,

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: SYSDATE, /* Last update date */
288: l_last_update_login /* Last update login */
289: );
290:
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: ELSIF (l_exists = 'N') THEN
293: /* Record doesn't exist; Create */
294:
295: /* init access_id */

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

384: END IF;
385:
386: CLOSE records_for_this_user;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389: ELSE
390: -- dbms_output.put_line('Going to insert record...');
391:
392: Insert_Record (

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: l_last_update_login /* Last update login */
411: );
412: END IF;
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: ELSIF (l_exists = FND_API.G_RET_STS_ERROR) THEN
416: /* Error */
417: RAISE FND_API.G_EXC_ERROR;
418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 415: ELSIF (l_exists = FND_API.G_RET_STS_ERROR) THEN

411: );
412: END IF;
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: ELSIF (l_exists = FND_API.G_RET_STS_ERROR) THEN
416: /* Error */
417: RAISE FND_API.G_EXC_ERROR;
418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN
419: /* Unexpected error */

Line 417: RAISE FND_API.G_EXC_ERROR;

413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: ELSIF (l_exists = FND_API.G_RET_STS_ERROR) THEN
416: /* Error */
417: RAISE FND_API.G_EXC_ERROR;
418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN
419: /* Unexpected error */
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;

Line 418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN

414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: ELSIF (l_exists = FND_API.G_RET_STS_ERROR) THEN
416: /* Error */
417: RAISE FND_API.G_EXC_ERROR;
418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN
419: /* Unexpected error */
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: /* Error */
417: RAISE FND_API.G_EXC_ERROR;
418: ELSIF (l_exists = FND_API.G_RET_STS_UNEXP_ERROR) THEN
419: /* Unexpected error */
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422:
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN

Line 424: WHEN FND_API.G_EXC_ERROR THEN

420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
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,

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: END IF;
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

Line 427: p_encoded => FND_API.G_FALSE,

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: );
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
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,

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

428: p_count => x_msg_count,
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

Line 434: p_encoded => FND_API.G_FALSE,

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: );
438: WHEN OTHERS THEN

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: p_count => x_msg_count,
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

Line 441: p_encoded => FND_API.G_FALSE,

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: );
445:

Line 473: RAISE FND_API.G_EXC_ERROR;

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 ';
477:

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

503: l_query := l_query || l_where_clause || l_order_by_clause;
504:
505: OPEN x_object_info FOR l_query;
506:
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508: END IF;
509:
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS;

508: END IF;
509:
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,

Line 516: p_encoded => FND_API.G_FALSE,

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: );
520: WHEN FND_API.G_EXC_ERROR THEN

Line 520: WHEN FND_API.G_EXC_ERROR THEN

516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
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,

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

517: p_count => x_msg_count,
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

Line 523: p_encoded => FND_API.G_FALSE,

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: );
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
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,

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: p_count => x_msg_count,
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

Line 530: p_encoded => FND_API.G_FALSE,

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: );
534: WHEN OTHERS THEN

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

531: p_count => x_msg_count,
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

Line 537: p_encoded => FND_API.G_FALSE,

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: );
541:

Line 572: RAISE FND_API.G_EXC_ERROR;

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);
576: x_flush_count := 0;

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583: WHERE USER_ID = p_user_id;
584:
585: IF l_curr_count <= l_max_records THEN
586: /* Nothing to do */
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: ELSE
589: l_num_to_delete := l_curr_count - l_max_records;
590:
591: WHILE x_flush_count < l_num_to_delete LOOP

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: END IF;
611:
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,

Line 618: p_encoded => FND_API.G_FALSE,

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: );
622: WHEN FND_API.G_EXC_ERROR THEN

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
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,

Line 623: x_return_status := FND_API.G_RET_STS_ERROR;

619: p_count => x_msg_count,
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

Line 625: p_encoded => FND_API.G_FALSE,

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: );
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
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,

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: p_count => x_msg_count,
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

Line 632: p_encoded => FND_API.G_FALSE,

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: );
636: WHEN OTHERS THEN

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

633: p_count => x_msg_count,
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

Line 639: p_encoded => FND_API.G_FALSE,

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: );
643: