DBA Data[Home] [Help]

APPS.JTF_TASK_TEMPLATES_PVT dependencies on FND_MSG_PUB

Line 79: fnd_msg_pub.initialize;

75: END IF;
76:
77: IF fnd_api.to_boolean (p_init_msg_list)
78: THEN
79: fnd_msg_pub.initialize;
80: END IF;
81:
82: jtf_task_templates_pvt.create_task
83: (

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

145: THEN
146: COMMIT WORK;
147: END IF;
148:
149: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO create_task_pvt1;

Line 155: fnd_msg_pub.count_and_get (

151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO create_task_pvt1;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: fnd_msg_pub.count_and_get (
156: p_count => x_msg_count,
157: p_data => x_msg_data
158: );
159: WHEN OTHERS

Line 165: fnd_msg_pub.count_and_get (

161: ROLLBACK TO create_task_pvt1;
162: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
163: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: fnd_msg_pub.count_and_get (
166: p_count => x_msg_count,
167: p_data => x_msg_data
168: );
169: END;

Line 275: fnd_msg_pub.initialize;

271: END IF;
272:
273: IF fnd_api.to_boolean (p_init_msg_list)
274: THEN
275: fnd_msg_pub.initialize;
276: END IF;
277:
278: IF l_task_id IS NOT NULL
279: THEN

Line 283: fnd_msg_pub.add;

279: THEN
280: IF l_task_id < 1e+12
281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_TEMP_OUT_OF_RANGE');
283: fnd_msg_pub.add;
284: x_return_status := fnd_api.g_ret_sts_unexp_error;
285: RAISE fnd_api.g_exc_unexpected_error;
286: END IF;
287:

Line 311: fnd_msg_pub.add;

307: EXCEPTION
308: WHEN NO_DATA_FOUND
309: THEN
310: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
311: fnd_msg_pub.add;
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313: RAISE fnd_api.g_exc_unexpected_error;
314: WHEN TOO_MANY_ROWS
315: THEN

Line 382: fnd_msg_pub.add;

378: IF c_jtf_tasks%NOTFOUND
379: THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATION_TEMP');
382: fnd_msg_pub.add;
383: RAISE fnd_api.g_exc_unexpected_error;
384: ELSE
385: x_task_id := l_task_id;
386: END IF;

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

389: THEN
390: COMMIT WORK;
391: END IF;
392:
393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
394: EXCEPTION
395: WHEN fnd_api.g_exc_unexpected_error
396: THEN
397: ROLLBACK TO create_task_pvt;

Line 399: fnd_msg_pub.count_and_get (

395: WHEN fnd_api.g_exc_unexpected_error
396: THEN
397: ROLLBACK TO create_task_pvt;
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_msg_pub.count_and_get (
400: p_count => x_msg_count,
401: p_data => x_msg_data
402: );
403: WHEN OTHERS

Line 409: fnd_msg_pub.count_and_get (

405: ROLLBACK TO create_task_pvt;
406: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
407: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409: fnd_msg_pub.count_and_get (
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );
413: END;

Line 502: fnd_msg_pub.initialize;

498: END IF;
499:
500: IF fnd_api.to_boolean (p_init_msg_list)
501: THEN
502: fnd_msg_pub.initialize;
503: END IF;
504:
505: jtf_task_templates_pvt.update_task (
506: p_api_version => p_api_version,

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

566: THEN
567: COMMIT WORK;
568: END IF;
569:
570: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571: EXCEPTION
572: WHEN fnd_api.g_exc_unexpected_error
573: THEN
574: ROLLBACK TO update_task_pvt1;

Line 576: fnd_msg_pub.count_and_get (

572: WHEN fnd_api.g_exc_unexpected_error
573: THEN
574: ROLLBACK TO update_task_pvt1;
575: x_return_status := fnd_api.g_ret_sts_unexp_error;
576: fnd_msg_pub.count_and_get (
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580: WHEN OTHERS

Line 586: fnd_msg_pub.count_and_get (

582: ROLLBACK TO update_task_pvt1;
583: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
584: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586: fnd_msg_pub.count_and_get (
587: p_count => x_msg_count,
588: p_data => x_msg_data
589: );
590: END;

Line 873: fnd_msg_pub.add;

869: IF c_task%NOTFOUND
870: THEN
871: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
872: fnd_message.set_token ('JTF_TASK_INVALID_TEMP', p_task_id);
873: fnd_msg_pub.add;
874: x_return_status := fnd_api.g_ret_sts_unexp_error;
875: RAISE fnd_api.g_exc_unexpected_error;
876: END IF;
877:

Line 1051: fnd_msg_pub.add;

1047:
1048: IF SQL%NOTFOUND
1049: THEN
1050: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_DELETING_TEMP');
1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_unexp_error;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055:

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

1057: THEN
1058: COMMIT WORK;
1059: END IF;
1060:
1061: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1062: EXCEPTION
1063: WHEN fnd_api.g_exc_unexpected_error
1064: THEN
1065: ROLLBACK TO delete_task_pvt;

Line 1067: fnd_msg_pub.count_and_get (

1063: WHEN fnd_api.g_exc_unexpected_error
1064: THEN
1065: ROLLBACK TO delete_task_pvt;
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067: fnd_msg_pub.count_and_get (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );
1071: WHEN OTHERS

Line 1076: fnd_msg_pub.count_and_get (

1072: THEN
1073: ROLLBACK TO delete_task_pvt;
1074: x_return_status := fnd_api.g_ret_sts_unexp_error;
1075:
1076: fnd_msg_pub.count_and_get (
1077: p_count => x_msg_count,
1078: p_data => x_msg_data
1079: );
1080: END;