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.JTF_RS_ROLE_RELATE_PUB dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.Initialize;

87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)
90: THEN
91: FND_MSG_PUB.Initialize;
92: END IF;
93:
94: --fetch the role resoure types and validate whether correct role_resource_type has been sent in as in param
95: FOR role_relate_type_rec IN role_relate_type_cur

Line 109: FND_MSG_PUB.add;

105:
106: IF l_role_resource_type = 'X'
107: THEN
108: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
109: FND_MSG_PUB.add;
110: RAISE fnd_api.g_exc_error;
111: ELSE
112:
113: --call procedure to check whether id exists for the object

Line 133: FND_MSG_PUB.add;

129: IF NOT(l_found)
130: --if the id is not found then raise error
131: THEN
132: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RR_RESOURCE');
133: FND_MSG_PUB.add;
134: RAISE fnd_api.g_exc_error;
135: END IF;
136: END IF;
137:

Line 149: FND_MSG_PUB.add;

145: FETCH role_cur INTO role_rec;
146: IF (role_cur%NOTFOUND)
147: THEN
148: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ROLE');
149: FND_MSG_PUB.add;
150: RAISE fnd_api.g_exc_error;
151: ELSE
152: l_role_id := role_rec.role_id;
153: END IF;

Line 158: FND_MSG_PUB.add;

154: CLOSE role_cur;
155: ELSE
156: --if both role id and role code is null then raise error
157: fnd_message.set_name ('JTF', 'JTF_RS_ROLE');
158: FND_MSG_PUB.add;
159: RAISE fnd_api.g_exc_error;
160:
161: END IF;
162:

Line 215: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

211: COMMIT WORK;
212: END IF;
213:
214:
215: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
216:
217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK TO ROLE_RELATE_SP;

Line 221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

217: EXCEPTION
218: WHEN fnd_api.g_exc_error THEN
219: ROLLBACK TO ROLE_RELATE_SP;
220: x_return_status := fnd_api.g_ret_sts_error;
221: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
222: p_data => x_msg_data);
223: WHEN fnd_api.g_exc_unexpected_error THEN
224: ROLLBACK TO ROLE_RELATE_SP;
225: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 226: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

222: p_data => x_msg_data);
223: WHEN fnd_api.g_exc_unexpected_error THEN
224: ROLLBACK TO ROLE_RELATE_SP;
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
227: p_data => x_msg_data);
228: WHEN OTHERS THEN
229: ROLLBACK TO ROLE_RELATE_SP;
230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 234: FND_MSG_PUB.add;

230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
237: p_data => x_msg_data);
238:

Line 236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: END create_resource_role_relate;
240:

Line 296: FND_MSG_PUB.Initialize;

292:
293: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
294: IF FND_API.To_boolean(P_INIT_MSG_LIST)
295: THEN
296: FND_MSG_PUB.Initialize;
297: END IF;
298:
299: open role_relate_cur(l_role_relate_id);
300: fetch role_relate_cur into role_relate_rec;

Line 336: FND_MSG_PUB.add;

332: END IF;
333: END IF;
334: ELSE
335: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339: END IF;
340:

Line 348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

344: COMMIT WORK;
345: END IF;
346:
347:
348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349:
350: EXCEPTION
351: WHEN fnd_api.g_exc_error THEN
352: ROLLBACK TO ROLE_RELATE_SP;

Line 354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

350: EXCEPTION
351: WHEN fnd_api.g_exc_error THEN
352: ROLLBACK TO ROLE_RELATE_SP;
353: x_return_status := fnd_api.g_ret_sts_error;
354: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
355: p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO ROLE_RELATE_SP;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 359: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

355: p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO ROLE_RELATE_SP;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
360: p_data => x_msg_data);
361: WHEN OTHERS THEN
362: ROLLBACK TO ROLE_RELATE_SP;
363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 367: FND_MSG_PUB.add;

363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
370: p_data => x_msg_data);
371:

Line 369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
370: p_data => x_msg_data);
371:
372: END UPDATE_RESOURCE_ROLE_RELATE;
373:

Line 425: FND_MSG_PUB.Initialize;

421:
422: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
423: IF FND_API.To_boolean(P_INIT_MSG_LIST)
424: THEN
425: FND_MSG_PUB.Initialize;
426: END IF;
427:
428: open role_relate_cur(l_role_relate_id);
429: fetch role_relate_cur into role_relate_rec;

Line 461: FND_MSG_PUB.add;

457: END IF;
458: END IF;
459: ELSE
460: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
461: FND_MSG_PUB.add;
462: RAISE fnd_api.g_exc_error;
463: END IF;
464: END IF;
465:

Line 473: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

469: COMMIT WORK;
470: END IF;
471:
472:
473: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
474:
475: EXCEPTION
476: WHEN fnd_api.g_exc_error THEN
477: ROLLBACK TO ROLE_RELATE_SP;

Line 479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

475: EXCEPTION
476: WHEN fnd_api.g_exc_error THEN
477: ROLLBACK TO ROLE_RELATE_SP;
478: x_return_status := fnd_api.g_ret_sts_error;
479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
480: p_data => x_msg_data);
481: WHEN fnd_api.g_exc_unexpected_error THEN
482: ROLLBACK TO ROLE_RELATE_SP;
483: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 484: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

480: p_data => x_msg_data);
481: WHEN fnd_api.g_exc_unexpected_error THEN
482: ROLLBACK TO ROLE_RELATE_SP;
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
485: p_data => x_msg_data);
486: WHEN OTHERS THEN
487: ROLLBACK TO ROLE_RELATE_SP;
488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 492: FND_MSG_PUB.add;

488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
495: p_data => x_msg_data);
496:

Line 494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
495: p_data => x_msg_data);
496:
497: END delete_resource_role_relate;
498: