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_GROUP_RELATE_AUD_PVT dependencies on JTF_RS_GRP_RELATE_AUD

Line 33: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;

29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2 )
31: IS
32:
33: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;
34: l_row_id varchar2(24) := null;
35:
36: --other variables
37: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_GROUP_RELATE';

Line 67: select jtf_rs_grp_relate_aud_s.nextval

63: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
64: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
65:
66:
67: select jtf_rs_grp_relate_aud_s.nextval
68: into l_group_relate_aud_id
69: from dual;
70:
71: /* CALL TABLE HANDLER */

Line 72: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (

68: into l_group_relate_aud_id
69: from dual;
70:
71: /* CALL TABLE HANDLER */
72: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (
73: X_ROWID => l_row_id,
74: X_group_RELATE_AUDIT_ID => l_group_relate_aud_id,
75: X_group_RELATE_ID => p_group_relate_id,
76: X_NEW_GROUP_ID => p_group_id,

Line 106: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

102: EXCEPTION
103: WHEN fnd_api.g_exc_unexpected_error
104: THEN
105: ROLLBACK TO group_relate_audit;
106: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
107: FND_MSG_PUB.add;
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110: WHEN OTHERS

Line 113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

109: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
110: WHEN OTHERS
111: THEN
112: ROLLBACK TO group_relate_audit;
113: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
114: FND_MSG_PUB.add;
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
117:

Line 177: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;

173:
174:
175:
176: rr_old_rec rr_old_cur%rowtype;
177: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;
178: l_row_id varchar2(24) := null;
179:
180: --other variables
181: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GROUP_RELATE';

Line 254: select jtf_rs_grp_relate_aud_s.nextval

250: l_object_version_number_n := p_object_version_number;
251: end if;
252:
253:
254: select jtf_rs_grp_relate_aud_s.nextval
255: into l_group_relate_aud_id
256: from dual;
257:
258: /* CALL TABLE HANDLER */

Line 259: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (

255: into l_group_relate_aud_id
256: from dual;
257:
258: /* CALL TABLE HANDLER */
259: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (
260: X_ROWID => l_row_id,
261: X_group_RELATE_AUDIT_ID => l_group_relate_aud_id,
262: X_group_RELATE_ID => p_group_relate_id,
263: X_NEW_group_ID => l_group_id_n,

Line 297: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

293: EXCEPTION
294: WHEN fnd_api.g_exc_unexpected_error
295: THEN
296: ROLLBACK TO group_relate_audit;
297: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301: WHEN OTHERS

Line 304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301: WHEN OTHERS
302: THEN
303: ROLLBACK TO group_relate_audit;
304: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
305: FND_MSG_PUB.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
308:

Line 348: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;

344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
345:
346:
347: rr_old_rec rr_old_cur%rowtype;
348: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;
349: l_row_id varchar2(24) := null;
350:
351: --other variables
352: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_RELATE';

Line 399: select jtf_rs_grp_relate_aud_s.nextval

395:
396:
397:
398:
399: select jtf_rs_grp_relate_aud_s.nextval
400: into l_group_relate_aud_id
401: from dual;
402:
403: /* CALL TABLE HANDLER */

Line 404: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (

400: into l_group_relate_aud_id
401: from dual;
402:
403: /* CALL TABLE HANDLER */
404: JTF_RS_GRP_RELATE_AUD_PKG.INSERT_ROW (
405: X_ROWID => l_row_id,
406: X_group_RELATE_AUDIT_ID => l_group_relate_aud_id,
407: X_group_RELATE_ID => p_group_relate_id,
408: X_NEW_group_ID =>null,

Line 442: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

438: EXCEPTION
439: WHEN fnd_api.g_exc_unexpected_error
440: THEN
441: ROLLBACK TO group_relate_audit;
442: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
443: FND_MSG_PUB.add;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS

Line 449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

445: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS
447: THEN
448: ROLLBACK TO group_relate_audit;
449: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
450: FND_MSG_PUB.add;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
453: