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 203: fnd_msg_pub.initialize;

199: x_return_status := fnd_api.g_ret_sts_success;
200:
201: IF fnd_api.to_boolean (p_init_msg_list)
202: THEN
203: fnd_msg_pub.initialize;
204: END IF;
205:
206: ----------------------------------------------------------
207: -- Check whether the current task_id is the first task_id

Line 248: fnd_msg_pub.add;

244: THEN
245: CLOSE c_recur;
246: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
247: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_add_assignee_rec.recurrence_rule_id);
248: fnd_msg_pub.add;
249:
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: RAISE fnd_api.g_exc_unexpected_error;
252: END IF;

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

384: THEN
385: COMMIT WORK;
386: END IF;
387:
388: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
389: EXCEPTION
390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: ROLLBACK TO add_assignee_pvt;

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

390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: ROLLBACK TO add_assignee_pvt;
393: x_return_status := fnd_api.g_ret_sts_unexp_error;
394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
395: WHEN OTHERS
396: THEN
397: ROLLBACK TO add_assignee_pvt;
398: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 400: fnd_msg_pub.add;

396: THEN
397: ROLLBACK TO add_assignee_pvt;
398: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
399: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
400: fnd_msg_pub.add;
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
403: END add_assignee;
404:

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

398: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
399: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
400: fnd_msg_pub.add;
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
403: END add_assignee;
404:
405: PROCEDURE delete_assignee(
406: p_api_version IN NUMBER,

Line 457: fnd_msg_pub.initialize;

453: x_return_status := fnd_api.g_ret_sts_success;
454:
455: IF fnd_api.to_boolean (p_init_msg_list)
456: THEN
457: fnd_msg_pub.initialize;
458: END IF;
459:
460: ----------------------------------------------------
461: ----------------------------------------------------------

Line 505: fnd_msg_pub.add;

501: THEN
502: CLOSE c_recur;
503: fnd_message.set_name ('JTF', 'JTF_TK_INVALID_RECUR_RULE');
504: fnd_message.set_token ('P_TASK_RECURRENCE_RULE_ID', p_delete_assignee_rec.recurrence_rule_id);
505: fnd_msg_pub.add;
506:
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;

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

637: THEN
638: COMMIT WORK;
639: END IF;
640:
641: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
642: EXCEPTION
643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: ROLLBACK TO delete_assignee_pvt;

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

643: WHEN fnd_api.g_exc_unexpected_error
644: THEN
645: ROLLBACK TO delete_assignee_pvt;
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
648: WHEN OTHERS
649: THEN
650: ROLLBACK TO delete_assignee_pvt;
651: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 653: fnd_msg_pub.add;

649: THEN
650: ROLLBACK TO delete_assignee_pvt;
651: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
652: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
653: fnd_msg_pub.add;
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
656: END delete_assignee;
657:

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

651: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
652: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
653: fnd_msg_pub.add;
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
656: END delete_assignee;
657:
658: END jtf_task_repeat_assignment_pvt;