DBA Data[Home] [Help]

APPS.JTF_TASK_CONFIRMATION_PUB dependencies on FND_MESSAGE

Line 73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');

69: x_return_status := fnd_api.g_ret_sts_unexp_error;
70: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
71: WHEN OTHERS THEN
72: ROLLBACK TO SET_COUNTER_STATUS_1;
73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
75: fnd_msg_pub.ADD;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

70: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
71: WHEN OTHERS THEN
72: ROLLBACK TO SET_COUNTER_STATUS_1;
73: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
74: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
75: fnd_msg_pub.ADD;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
78:

Line 160: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

156: );
157: WHEN OTHERS
158: THEN
159: ROLLBACK TO RESET_COUNTER;
160: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
161: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
162: fnd_msg_pub.add;
163: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: fnd_msg_pub.count_and_get (

Line 161: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

157: WHEN OTHERS
158: THEN
159: ROLLBACK TO RESET_COUNTER;
160: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
161: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
162: fnd_msg_pub.add;
163: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: fnd_msg_pub.count_and_get (
165: p_count => x_msg_count,

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

268: );
269: WHEN OTHERS
270: THEN
271: ROLLBACK TO INCREASE_COUNTER;
272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
273: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
274: fnd_msg_pub.add;
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: fnd_msg_pub.count_and_get (

Line 273: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

269: WHEN OTHERS
270: THEN
271: ROLLBACK TO INCREASE_COUNTER;
272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
273: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
274: fnd_msg_pub.add;
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: fnd_msg_pub.count_and_get (
277: p_count => x_msg_count,

Line 367: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

363: );
364: WHEN OTHERS
365: THEN
366: ROLLBACK TO DECREASE_COUNTER;
367: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
368: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
369: fnd_msg_pub.add;
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371: fnd_msg_pub.count_and_get (

Line 368: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

364: WHEN OTHERS
365: THEN
366: ROLLBACK TO DECREASE_COUNTER;
367: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
368: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
369: fnd_msg_pub.add;
370: x_return_status := fnd_api.g_ret_sts_unexp_error;
371: fnd_msg_pub.count_and_get (
372: p_count => x_msg_count,

Line 462: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

458: );
459: WHEN OTHERS
460: THEN
461: ROLLBACK TO CHANGE_COUNTER_SIGN;
462: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
463: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
464: fnd_msg_pub.add;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (

Line 463: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

459: WHEN OTHERS
460: THEN
461: ROLLBACK TO CHANGE_COUNTER_SIGN;
462: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
463: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
464: fnd_msg_pub.add;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: fnd_msg_pub.count_and_get (
467: p_count => x_msg_count,

Line 550: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

546: );
547: WHEN OTHERS
548: THEN
549: ROLLBACK TO RESET_CONFIRMATION_STATUS_1;
550: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
551: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (

Line 551: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

547: WHEN OTHERS
548: THEN
549: ROLLBACK TO RESET_CONFIRMATION_STATUS_1;
550: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
551: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (
555: p_count => x_msg_count,

Line 640: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

636: );
637: WHEN OTHERS
638: THEN
639: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;
640: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
641: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
642: fnd_msg_pub.add;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: fnd_msg_pub.count_and_get (

Line 641: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

637: WHEN OTHERS
638: THEN
639: ROLLBACK TO SET_CONFIRMATION_REQUIRED_1;
640: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
641: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
642: fnd_msg_pub.add;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: fnd_msg_pub.count_and_get (
645: p_count => x_msg_count,

Line 731: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

727: );
728: WHEN OTHERS
729: THEN
730: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;
731: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
732: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
733: fnd_msg_pub.add;
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: fnd_msg_pub.count_and_get (

Line 732: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

728: WHEN OTHERS
729: THEN
730: ROLLBACK TO SET_CONFIRMATION_CONFIRMED_1;
731: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
732: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
733: fnd_msg_pub.add;
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: fnd_msg_pub.count_and_get (
736: p_count => x_msg_count,

Line 775: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');

771: OPEN c_task;
772: FETCH c_task INTO tasks;
773: IF c_task%NOTFOUND THEN
774: CLOSE c_task;
775: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
776: fnd_message.set_token('P_TASK_ID', p_task_id);
777: fnd_msg_pub.ADD;
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;

Line 776: fnd_message.set_token('P_TASK_ID', p_task_id);

772: FETCH c_task INTO tasks;
773: IF c_task%NOTFOUND THEN
774: CLOSE c_task;
775: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
776: fnd_message.set_token('P_TASK_ID', p_task_id);
777: fnd_msg_pub.ADD;
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780: CLOSE c_task;

Line 783: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');

779: END IF;
780: CLOSE c_task;
781:
782: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
783: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
784: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
785: fnd_msg_pub.ADD;
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;

Line 784: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');

780: CLOSE c_task;
781:
782: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
783: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
784: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
785: fnd_msg_pub.ADD;
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;
788:

Line 916: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

912: );
913: WHEN OTHERS
914: THEN
915: ROLLBACK TO SET_COUNTER_STATUS;
916: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
917: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: fnd_msg_pub.count_and_get (

Line 917: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

913: WHEN OTHERS
914: THEN
915: ROLLBACK TO SET_COUNTER_STATUS;
916: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
917: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
918: fnd_msg_pub.add;
919: x_return_status := fnd_api.g_ret_sts_unexp_error;
920: fnd_msg_pub.count_and_get (
921: p_count => x_msg_count,

Line 1010: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1006: );
1007: WHEN OTHERS
1008: THEN
1009: ROLLBACK TO RESET_CONFIRMATION_STATUS;
1010: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1011: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014: fnd_msg_pub.count_and_get (

Line 1011: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

1007: WHEN OTHERS
1008: THEN
1009: ROLLBACK TO RESET_CONFIRMATION_STATUS;
1010: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1011: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_unexp_error;
1014: fnd_msg_pub.count_and_get (
1015: p_count => x_msg_count,

Line 1104: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1100: );
1101: WHEN OTHERS
1102: THEN
1103: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
1104: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1105: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (

Line 1105: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

1101: WHEN OTHERS
1102: THEN
1103: ROLLBACK TO SET_CONFIRMATION_REQUIRED;
1104: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1105: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: fnd_msg_pub.count_and_get (
1109: p_count => x_msg_count,

Line 1202: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1198: );
1199: WHEN OTHERS
1200: THEN
1201: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
1202: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1203: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1204: fnd_msg_pub.add;
1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_msg_pub.count_and_get (

Line 1203: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

1199: WHEN OTHERS
1200: THEN
1201: ROLLBACK TO SET_CONFIRMATION_CONFIRMED;
1202: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1203: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1204: fnd_msg_pub.add;
1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_msg_pub.count_and_get (
1207: p_count => x_msg_count,