DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_PUB dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.Initialize;

91:
92: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
93: IF FND_API.To_boolean(P_INIT_MSG_LIST)
94: THEN
95: FND_MSG_PUB.Initialize;
96: END IF;
97:
98: --GET USER ID AND SYSDATE
99: l_date := sysdate;

Line 111: FND_MSG_PUB.add;

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

Line 126: FND_MSG_PUB.add;

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

Line 140: FND_MSG_PUB.add;

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;
144:

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

174: COMMIT WORK;
175: END IF;
176:
177:
178: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
179:
180: EXCEPTION
181: WHEN fnd_api.g_exc_unexpected_error
182: THEN

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

181: WHEN fnd_api.g_exc_unexpected_error
182: THEN
183: ROLLBACK TO GROUP_RELATE_SP;
184: x_return_status := fnd_api.g_ret_sts_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');

Line 193: FND_MSG_PUB.add;

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:
197:

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

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:
197:
198:
199: END create_resource_group_relate;

Line 259: FND_MSG_PUB.Initialize;

255:
256: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
257: IF FND_API.To_boolean(P_INIT_MSG_LIST)
258: THEN
259: FND_MSG_PUB.Initialize;
260: END IF;
261:
262: --GET USER ID AND SYSDATE
263: l_date := sysdate;

Line 273: FND_MSG_PUB.add;

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;
277:

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

305: COMMIT WORK;
306: END IF;
307:
308:
309: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
310:
311: EXCEPTION
312: WHEN fnd_api.g_exc_unexpected_error
313: THEN

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

312: WHEN fnd_api.g_exc_unexpected_error
313: THEN
314: ROLLBACK TO GROUP_RELATE_SP;
315: x_return_status := fnd_api.g_ret_sts_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');

Line 324: FND_MSG_PUB.add;

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:
328:

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

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:
328:
329:
330: END update_resource_group_relate;

Line 390: FND_MSG_PUB.Initialize;

386:
387: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
388: IF FND_API.To_boolean(P_INIT_MSG_LIST)
389: THEN
390: FND_MSG_PUB.Initialize;
391: END IF;
392:
393: --GET USER ID AND SYSDATE
394: l_date := sysdate;

Line 404: FND_MSG_PUB.add;

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;
408:

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

432: COMMIT WORK;
433: END IF;
434:
435:
436: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
437:
438: EXCEPTION
439: WHEN fnd_api.g_exc_unexpected_error
440: THEN

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

439: WHEN fnd_api.g_exc_unexpected_error
440: THEN
441: ROLLBACK TO GROUP_RELATE_SP;
442: x_return_status := fnd_api.g_ret_sts_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');

Line 451: FND_MSG_PUB.add;

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:
455:

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

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:
455:
456:
457: END delete_resource_group_relate;