DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_PUB dependencies on FND_MESSAGE

Line 110: fnd_message.set_name ('JTF', 'JTF_RS_GRP_NOTFOUND_ERR');

106: FETCH grp_cur INTO grp_rec;
107: IF(grp_cur%NOTFOUND)
108: THEN
109: x_return_status := fnd_api.g_ret_sts_unexp_error;
110: fnd_message.set_name ('JTF', 'JTF_RS_GRP_NOTFOUND_ERR');
111: FND_MSG_PUB.add;
112: RAISE fnd_api.g_exc_unexpected_error;
113: ELSE
114: l_group_id := grp_rec.group_id;

Line 125: fnd_message.set_name ('JTF', 'JTF_RS_REL_GRP_NOTFOUND_ERR');

121: FETCH grp_cur INTO grp_rec;
122: IF(grp_cur%NOTFOUND)
123: THEN
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125: fnd_message.set_name ('JTF', 'JTF_RS_REL_GRP_NOTFOUND_ERR');
126: FND_MSG_PUB.add;
127: RAISE fnd_api.g_exc_unexpected_error;
128: ELSE
129: l_related_group_id := grp_rec.group_id;

Line 139: fnd_message.set_name ('JTF', 'JTF_RS_REL_TYP_NOTFOUND_ERR');

135: FETCH chk_rel_cur INTO chk_rel_rec;
136: IF(chk_rel_cur%NOTFOUND)
137: THEN
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: fnd_message.set_name ('JTF', 'JTF_RS_REL_TYP_NOTFOUND_ERR');
140: FND_MSG_PUB.add;
141: RAISE fnd_api.g_exc_unexpected_error;
142: END IF;
143: CLOSE chk_rel_cur;

Line 189: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

185: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
186: WHEN OTHERS
187: THEN
188: ROLLBACK TO GROUP_RELATE_SP;
189: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
190: fnd_message.set_token('P_SQLCODE',SQLCODE);
191: fnd_message.set_token('P_SQLERRM',SQLERRM);
192: fnd_message.set_token('P_API_NAME', l_api_name);
193: FND_MSG_PUB.add;

Line 190: fnd_message.set_token('P_SQLCODE',SQLCODE);

186: WHEN OTHERS
187: THEN
188: ROLLBACK TO GROUP_RELATE_SP;
189: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
190: fnd_message.set_token('P_SQLCODE',SQLCODE);
191: fnd_message.set_token('P_SQLERRM',SQLERRM);
192: fnd_message.set_token('P_API_NAME', l_api_name);
193: FND_MSG_PUB.add;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 191: fnd_message.set_token('P_SQLERRM',SQLERRM);

187: THEN
188: ROLLBACK TO GROUP_RELATE_SP;
189: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
190: fnd_message.set_token('P_SQLCODE',SQLCODE);
191: fnd_message.set_token('P_SQLERRM',SQLERRM);
192: fnd_message.set_token('P_API_NAME', l_api_name);
193: FND_MSG_PUB.add;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 192: fnd_message.set_token('P_API_NAME', l_api_name);

188: ROLLBACK TO GROUP_RELATE_SP;
189: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
190: fnd_message.set_token('P_SQLCODE',SQLCODE);
191: fnd_message.set_token('P_SQLERRM',SQLERRM);
192: fnd_message.set_token('P_API_NAME', l_api_name);
193: FND_MSG_PUB.add;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
196:

Line 272: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_NOTFOUND_ERR');

268: FETCH val_grp_rel_cur INTO dummy;
269: IF(val_grp_rel_cur%NOTFOUND)
270: THEN
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_NOTFOUND_ERR');
273: FND_MSG_PUB.add;
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;
276: CLOSE val_grp_rel_cur;

Line 320: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

316: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
317: WHEN OTHERS
318: THEN
319: ROLLBACK TO GROUP_RELATE_SP;
320: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
321: fnd_message.set_token('P_SQLCODE',SQLCODE);
322: fnd_message.set_token('P_SQLERRM',SQLERRM);
323: fnd_message.set_token('P_API_NAME', l_api_name);
324: FND_MSG_PUB.add;

Line 321: fnd_message.set_token('P_SQLCODE',SQLCODE);

317: WHEN OTHERS
318: THEN
319: ROLLBACK TO GROUP_RELATE_SP;
320: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
321: fnd_message.set_token('P_SQLCODE',SQLCODE);
322: fnd_message.set_token('P_SQLERRM',SQLERRM);
323: fnd_message.set_token('P_API_NAME', l_api_name);
324: FND_MSG_PUB.add;
325: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 322: fnd_message.set_token('P_SQLERRM',SQLERRM);

318: THEN
319: ROLLBACK TO GROUP_RELATE_SP;
320: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
321: fnd_message.set_token('P_SQLCODE',SQLCODE);
322: fnd_message.set_token('P_SQLERRM',SQLERRM);
323: fnd_message.set_token('P_API_NAME', l_api_name);
324: FND_MSG_PUB.add;
325: x_return_status := fnd_api.g_ret_sts_unexp_error;
326: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 323: fnd_message.set_token('P_API_NAME', l_api_name);

319: ROLLBACK TO GROUP_RELATE_SP;
320: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
321: fnd_message.set_token('P_SQLCODE',SQLCODE);
322: fnd_message.set_token('P_SQLERRM',SQLERRM);
323: fnd_message.set_token('P_API_NAME', l_api_name);
324: FND_MSG_PUB.add;
325: x_return_status := fnd_api.g_ret_sts_unexp_error;
326: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
327:

Line 403: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_NOTFOUND_ERR');

399: FETCH val_grp_rel_cur INTO dummy;
400: IF(val_grp_rel_cur%NOTFOUND)
401: THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_NOTFOUND_ERR');
404: FND_MSG_PUB.add;
405: RAISE fnd_api.g_exc_unexpected_error;
406: END IF;
407: CLOSE val_grp_rel_cur;

Line 447: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

443: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
444: WHEN OTHERS
445: THEN
446: ROLLBACK TO GROUP_RELATE_SP;
447: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
448: fnd_message.set_token('P_SQLCODE',SQLCODE);
449: fnd_message.set_token('P_SQLERRM',SQLERRM);
450: fnd_message.set_token('P_API_NAME', l_api_name);
451: FND_MSG_PUB.add;

Line 448: fnd_message.set_token('P_SQLCODE',SQLCODE);

444: WHEN OTHERS
445: THEN
446: ROLLBACK TO GROUP_RELATE_SP;
447: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
448: fnd_message.set_token('P_SQLCODE',SQLCODE);
449: fnd_message.set_token('P_SQLERRM',SQLERRM);
450: fnd_message.set_token('P_API_NAME', l_api_name);
451: FND_MSG_PUB.add;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 449: fnd_message.set_token('P_SQLERRM',SQLERRM);

445: THEN
446: ROLLBACK TO GROUP_RELATE_SP;
447: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
448: fnd_message.set_token('P_SQLCODE',SQLCODE);
449: fnd_message.set_token('P_SQLERRM',SQLERRM);
450: fnd_message.set_token('P_API_NAME', l_api_name);
451: FND_MSG_PUB.add;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 450: fnd_message.set_token('P_API_NAME', l_api_name);

446: ROLLBACK TO GROUP_RELATE_SP;
447: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
448: fnd_message.set_token('P_SQLCODE',SQLCODE);
449: fnd_message.set_token('P_SQLERRM',SQLERRM);
450: fnd_message.set_token('P_API_NAME', l_api_name);
451: FND_MSG_PUB.add;
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: