DBA Data[Home] [Help]

APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on FND_MSG_PUB

Line 96: fnd_msg_pub.initialize;

92: x_return_status := fnd_api.g_ret_sts_success;
93:
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN
96: fnd_msg_pub.initialize;
97: END IF;
98:
99: ----------------------------------------------------
100: FOR rec_assignments IN c_assignments(b_recurrence_rule_id => p_response_invitation_rec.recurrence_rule_id

Line 139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

135: THEN
136: COMMIT WORK;
137: END IF;
138:
139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
140: EXCEPTION
141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO response_invitation_pvt;

Line 145: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

141: WHEN fnd_api.g_exc_unexpected_error
142: THEN
143: ROLLBACK TO response_invitation_pvt;
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
146: WHEN OTHERS
147: THEN
148: ROLLBACK TO response_invitation_pvt;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 151: fnd_msg_pub.add;

147: THEN
148: ROLLBACK TO response_invitation_pvt;
149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154: END response_invitation;
155:

Line 153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

149: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
150: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
151: fnd_msg_pub.add;
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
154: END response_invitation;
155:
156: PROCEDURE add_assignee(
157: p_api_version IN NUMBER,

Line 208: fnd_msg_pub.initialize;

204: x_return_status := fnd_api.g_ret_sts_success;
205:
206: IF fnd_api.to_boolean (p_init_msg_list)
207: THEN
208: fnd_msg_pub.initialize;
209: END IF;
210:
211: ----------------------------------------------------------
212: -- Check whether the current task_id is the first task_id

Line 253: fnd_msg_pub.add;

249: THEN
250: CLOSE c_recur;
251: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
252: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
253: fnd_msg_pub.add;
254:
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;

Line 426: fnd_msg_pub.add;

422: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
423: fnd_message.set_token ('RES', l_name );
424: fnd_message.set_token ('DATE', l_date);
425:
426: fnd_msg_pub.add;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: RAISE fnd_api.g_exc_unexpected_error;
430:

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

439: THEN
440: COMMIT WORK;
441: END IF;
442:
443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error
446: THEN
447: ROLLBACK TO add_assignee_pvt;

Line 449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 455: fnd_msg_pub.add;

451: THEN
452: ROLLBACK TO add_assignee_pvt;
453: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
454: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
455: fnd_msg_pub.add;
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
458: END add_assignee;
459:

Line 457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

453: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
454: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
455: fnd_msg_pub.add;
456: x_return_status := fnd_api.g_ret_sts_unexp_error;
457: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
458: END add_assignee;
459:
460: PROCEDURE delete_assignee(
461: p_api_version IN NUMBER,

Line 512: fnd_msg_pub.initialize;

508: x_return_status := fnd_api.g_ret_sts_success;
509:
510: IF fnd_api.to_boolean (p_init_msg_list)
511: THEN
512: fnd_msg_pub.initialize;
513: END IF;
514:
515: ----------------------------------------------------
516: ----------------------------------------------------------

Line 560: fnd_msg_pub.add;

556: THEN
557: CLOSE c_recur;
558: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
559: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
560: fnd_msg_pub.add;
561:
562: x_return_status := fnd_api.g_ret_sts_unexp_error;
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;

Line 696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

692: THEN
693: COMMIT WORK;
694: END IF;
695:
696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
697: EXCEPTION
698: WHEN fnd_api.g_exc_unexpected_error
699: THEN
700: ROLLBACK TO delete_assignee_pvt;

Line 702: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

698: WHEN fnd_api.g_exc_unexpected_error
699: THEN
700: ROLLBACK TO delete_assignee_pvt;
701: x_return_status := fnd_api.g_ret_sts_unexp_error;
702: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
703: WHEN OTHERS
704: THEN
705: ROLLBACK TO delete_assignee_pvt;
706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 708: fnd_msg_pub.add;

704: THEN
705: ROLLBACK TO delete_assignee_pvt;
706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
707: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
708: fnd_msg_pub.add;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
711: END delete_assignee;
712:

Line 710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

706: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
707: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
708: fnd_msg_pub.add;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
711: END delete_assignee;
712:
713: END jtf_task_repeat_assignment_pvt;