eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASKS_PVT dependencies on FND_MESSAGE

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

235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
237: WHEN OTHERS THEN
238: ROLLBACK TO create_task_pvt2;
239: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
240: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
241: fnd_msg_pub.ADD;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

236: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
237: WHEN OTHERS THEN
238: ROLLBACK TO create_task_pvt2;
239: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
240: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
241: fnd_msg_pub.ADD;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
244: END;

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

473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
475: WHEN OTHERS THEN
476: ROLLBACK TO create_task_pvt3;
477: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
478: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
479: fnd_msg_pub.ADD;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

474: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
475: WHEN OTHERS THEN
476: ROLLBACK TO create_task_pvt3;
477: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
478: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
479: fnd_msg_pub.ADD;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
482: END;

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

710: x_return_status := fnd_api.g_ret_sts_unexp_error;
711: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_task_pvt1;
714: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
716: fnd_msg_pub.ADD;
717: x_return_status := fnd_api.g_ret_sts_unexp_error;
718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

711: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_task_pvt1;
714: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
716: fnd_msg_pub.ADD;
717: x_return_status := fnd_api.g_ret_sts_unexp_error;
718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
719: END;

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

956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
958: WHEN OTHERS THEN
959: ROLLBACK TO create_task_pvt4;
960: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
961: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
962: fnd_msg_pub.ADD;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

957: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
958: WHEN OTHERS THEN
959: ROLLBACK TO create_task_pvt4;
960: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
961: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
962: fnd_msg_pub.ADD;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
965: END;

Line 1149: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');

1145: RAISE fnd_api.g_exc_unexpected_error;
1146: END IF;
1147:
1148: IF p_task_name IS NULL THEN
1149: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');
1150: fnd_msg_pub.ADD;
1151: RAISE fnd_api.g_exc_unexpected_error;
1152: END IF;
1153:

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

1152: END IF;
1153:
1154: IF p_task_split_flag IS NOT NULL THEN
1155: IF NOT p_task_split_flag IN('M', 'D') THEN
1156: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
1157: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
1158: fnd_msg_pub.ADD;
1159: RAISE fnd_api.g_exc_unexpected_error;
1160: END IF;

Line 1157: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');

1153:
1154: IF p_task_split_flag IS NOT NULL THEN
1155: IF NOT p_task_split_flag IN('M', 'D') THEN
1156: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
1157: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
1158: fnd_msg_pub.ADD;
1159: RAISE fnd_api.g_exc_unexpected_error;
1160: END IF;
1161: END IF;

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

1160: END IF;
1161: END IF;
1162:
1163: IF NOT p_task_confirmation_status IN('N', 'R', 'C') THEN
1164: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
1165: fnd_message.set_token('P_SHITF_CONSTRUCT_ID', 'task confirmation status');
1166: fnd_msg_pub.ADD;
1167: RAISE fnd_api.g_exc_unexpected_error;
1168: END IF;

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

1161: END IF;
1162:
1163: IF NOT p_task_confirmation_status IN('N', 'R', 'C') THEN
1164: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
1165: fnd_message.set_token('P_SHITF_CONSTRUCT_ID', 'task confirmation status');
1166: fnd_msg_pub.ADD;
1167: RAISE fnd_api.g_exc_unexpected_error;
1168: END IF;
1169:

Line 1180: fnd_message.set_name('JTF', 'JTF_TASK_OUT_OF_RANGE');

1176: END IF;
1177:
1178: IF p_task_id IS NOT NULL THEN
1179: IF p_task_id > jtf_task_utl_ext.get_last_number('JTF_TASKS_S') AND p_task_id < 1e+12 THEN
1180: fnd_message.set_name('JTF', 'JTF_TASK_OUT_OF_RANGE');
1181: fnd_msg_pub.ADD;
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183: RAISE fnd_api.g_exc_unexpected_error;
1184: END IF;

Line 1191: fnd_message.set_name('JTF', 'JTF_TASK_DUPLICATE_TASK_ID');

1187: FETCH c_jtf_tasks INTO l_task_id_duplicate;
1188: CLOSE c_jtf_tasks;
1189:
1190: IF l_task_id_duplicate = 'Y' THEN
1191: fnd_message.set_name('JTF', 'JTF_TASK_DUPLICATE_TASK_ID');
1192: fnd_message.set_token('P_TASK_ID', p_task_id);
1193: fnd_msg_pub.ADD;
1194: x_return_status := fnd_api.g_ret_sts_unexp_error;
1195: RAISE fnd_api.g_exc_unexpected_error;

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

1188: CLOSE c_jtf_tasks;
1189:
1190: IF l_task_id_duplicate = 'Y' THEN
1191: fnd_message.set_name('JTF', 'JTF_TASK_DUPLICATE_TASK_ID');
1192: fnd_message.set_token('P_TASK_ID', p_task_id);
1193: fnd_msg_pub.ADD;
1194: x_return_status := fnd_api.g_ret_sts_unexp_error;
1195: RAISE fnd_api.g_exc_unexpected_error;
1196: END IF;

Line 1639: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');

1635: , x_return_status => x_event_return_status
1636: );
1637:
1638: IF (x_event_return_status = 'WARNING') THEN
1639: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
1640: fnd_message.set_token('P_TASK_ID', x_task_id);
1641: fnd_msg_pub.ADD;
1642: ELSIF(x_event_return_status = 'ERROR') THEN
1643: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

Line 1640: fnd_message.set_token('P_TASK_ID', x_task_id);

1636: );
1637:
1638: IF (x_event_return_status = 'WARNING') THEN
1639: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
1640: fnd_message.set_token('P_TASK_ID', x_task_id);
1641: fnd_msg_pub.ADD;
1642: ELSIF(x_event_return_status = 'ERROR') THEN
1643: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
1644: fnd_message.set_token('P_TASK_ID', x_task_id);

Line 1643: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

1639: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
1640: fnd_message.set_token('P_TASK_ID', x_task_id);
1641: fnd_msg_pub.ADD;
1642: ELSIF(x_event_return_status = 'ERROR') THEN
1643: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
1644: fnd_message.set_token('P_TASK_ID', x_task_id);
1645: fnd_msg_pub.ADD;
1646: x_return_status := fnd_api.g_ret_sts_unexp_error;
1647: RAISE fnd_api.g_exc_unexpected_error;

Line 1644: fnd_message.set_token('P_TASK_ID', x_task_id);

1640: fnd_message.set_token('P_TASK_ID', x_task_id);
1641: fnd_msg_pub.ADD;
1642: ELSIF(x_event_return_status = 'ERROR') THEN
1643: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
1644: fnd_message.set_token('P_TASK_ID', x_task_id);
1645: fnd_msg_pub.ADD;
1646: x_return_status := fnd_api.g_ret_sts_unexp_error;
1647: RAISE fnd_api.g_exc_unexpected_error;
1648: END IF;

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

1690: x_return_status := fnd_api.g_ret_sts_unexp_error;
1691: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1692: WHEN OTHERS THEN
1693: ROLLBACK TO create_task_pvt;
1694: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1695: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1696: fnd_msg_pub.ADD;
1697: x_return_status := fnd_api.g_ret_sts_unexp_error;
1698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1691: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1692: WHEN OTHERS THEN
1693: ROLLBACK TO create_task_pvt;
1694: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1695: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1696: fnd_msg_pub.ADD;
1697: x_return_status := fnd_api.g_ret_sts_unexp_error;
1698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1699: END;

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

1913: x_return_status := fnd_api.g_ret_sts_unexp_error;
1914: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1915: WHEN OTHERS THEN
1916: ROLLBACK TO update_task_pvt1;
1917: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1918: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1919: fnd_msg_pub.ADD;
1920: x_return_status := fnd_api.g_ret_sts_unexp_error;
1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1914: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1915: WHEN OTHERS THEN
1916: ROLLBACK TO update_task_pvt1;
1917: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1918: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1919: fnd_msg_pub.ADD;
1920: x_return_status := fnd_api.g_ret_sts_unexp_error;
1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1922: END;

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

2136: x_return_status := fnd_api.g_ret_sts_unexp_error;
2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN OTHERS THEN
2139: ROLLBACK TO update_task_pvt2;
2140: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2141: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2142: fnd_msg_pub.ADD;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2138: WHEN OTHERS THEN
2139: ROLLBACK TO update_task_pvt2;
2140: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2141: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2142: fnd_msg_pub.ADD;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2145: END;

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

2360: x_return_status := fnd_api.g_ret_sts_unexp_error;
2361: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2362: WHEN OTHERS THEN
2363: ROLLBACK TO update_task_pvt3;
2364: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2365: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2366: fnd_msg_pub.ADD;
2367: x_return_status := fnd_api.g_ret_sts_unexp_error;
2368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2361: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2362: WHEN OTHERS THEN
2363: ROLLBACK TO update_task_pvt3;
2364: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2365: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2366: fnd_msg_pub.ADD;
2367: x_return_status := fnd_api.g_ret_sts_unexp_error;
2368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2369: END;

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

2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN
2594: ROLLBACK TO update_task_pvt4;
2595: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2596: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2597: fnd_msg_pub.ADD;
2598: x_return_status := fnd_api.g_ret_sts_unexp_error;
2599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2593: WHEN OTHERS THEN
2594: ROLLBACK TO update_task_pvt4;
2595: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2596: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2597: fnd_msg_pub.ADD;
2598: x_return_status := fnd_api.g_ret_sts_unexp_error;
2599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2600: END;

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

2827: x_return_status := fnd_api.g_ret_sts_unexp_error;
2828: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2829: WHEN OTHERS THEN
2830: ROLLBACK TO update_task_pvt5;
2831: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2832: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2833: fnd_msg_pub.ADD;
2834: x_return_status := fnd_api.g_ret_sts_unexp_error;
2835: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2828: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2829: WHEN OTHERS THEN
2830: ROLLBACK TO update_task_pvt5;
2831: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2832: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2833: fnd_msg_pub.ADD;
2834: x_return_status := fnd_api.g_ret_sts_unexp_error;
2835: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2836: END;

Line 3342: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');

3338: fnd_msg_pub.initialize;
3339: END IF;
3340:
3341: IF p_task_name IS NULL THEN
3342: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');
3343: fnd_msg_pub.ADD;
3344: RAISE fnd_api.g_exc_unexpected_error;
3345: END IF;
3346:

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

3345: END IF;
3346:
3347: IF p_task_split_flag IS NOT NULL THEN
3348: IF NOT p_task_split_flag IN('M', 'D', fnd_api.g_miss_char) THEN
3349: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3350: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
3351: fnd_msg_pub.ADD;
3352: RAISE fnd_api.g_exc_unexpected_error;
3353: END IF;

Line 3350: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');

3346:
3347: IF p_task_split_flag IS NOT NULL THEN
3348: IF NOT p_task_split_flag IN('M', 'D', fnd_api.g_miss_char) THEN
3349: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3350: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
3351: fnd_msg_pub.ADD;
3352: RAISE fnd_api.g_exc_unexpected_error;
3353: END IF;
3354: END IF;

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

3353: END IF;
3354: END IF;
3355:
3356: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
3357: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3358: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: END IF;

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

3354: END IF;
3355:
3356: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
3357: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3358: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: END IF;
3362:

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

3363: OPEN c_task;
3364: FETCH c_task INTO tasks;
3365: IF c_task%NOTFOUND THEN
3366: CLOSE c_task;
3367: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3368: fnd_message.set_token('P_TASK_ID', p_task_id);
3369: fnd_msg_pub.ADD;
3370: x_return_status := fnd_api.g_ret_sts_unexp_error;
3371: RAISE fnd_api.g_exc_unexpected_error;

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

3364: FETCH c_task INTO tasks;
3365: IF c_task%NOTFOUND THEN
3366: CLOSE c_task;
3367: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3368: fnd_message.set_token('P_TASK_ID', p_task_id);
3369: fnd_msg_pub.ADD;
3370: x_return_status := fnd_api.g_ret_sts_unexp_error;
3371: RAISE fnd_api.g_exc_unexpected_error;
3372: END IF;

Line 3933: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');

3929: FETCH task_ass_orig INTO task_ass_orig_rec;
3930: IF ((task_ass_orig%NOTFOUND) OR(task_ass_orig_rec.assignee_role <> 'OWNER')) THEN
3931: CLOSE task_ass_orig; -- Fix a missing CLOSE on 4/18/2002
3932:
3933: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');
3934: fnd_msg_pub.ADD;
3935: x_return_status := fnd_api.g_ret_sts_unexp_error;
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END IF;

Line 3998: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');

3994: CLOSE task_ass_orig;
3995:
3996: CLOSE task_ass_u; -- Fix a missing CLOSE on 4/18/2002
3997:
3998: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');
3999: fnd_msg_pub.ADD;
4000: x_return_status := fnd_api.g_ret_sts_unexp_error;
4001: RAISE fnd_api.g_exc_unexpected_error;
4002: END IF;

Line 4230: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');

4226: , x_return_status => x_event_return_status
4227: );
4228:
4229: IF (x_event_return_status = 'WARNING') THEN
4230: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4231: fnd_message.set_token('P_TASK_ID', l_task_id);
4232: fnd_msg_pub.ADD;
4233: ELSIF(x_event_return_status = 'ERROR') THEN
4234: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

Line 4231: fnd_message.set_token('P_TASK_ID', l_task_id);

4227: );
4228:
4229: IF (x_event_return_status = 'WARNING') THEN
4230: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4231: fnd_message.set_token('P_TASK_ID', l_task_id);
4232: fnd_msg_pub.ADD;
4233: ELSIF(x_event_return_status = 'ERROR') THEN
4234: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4235: fnd_message.set_token('P_TASK_ID', l_task_id);

Line 4234: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

4230: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4231: fnd_message.set_token('P_TASK_ID', l_task_id);
4232: fnd_msg_pub.ADD;
4233: ELSIF(x_event_return_status = 'ERROR') THEN
4234: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4235: fnd_message.set_token('P_TASK_ID', l_task_id);
4236: fnd_msg_pub.ADD;
4237: x_return_status := fnd_api.g_ret_sts_unexp_error;
4238: RAISE fnd_api.g_exc_unexpected_error;

Line 4235: fnd_message.set_token('P_TASK_ID', l_task_id);

4231: fnd_message.set_token('P_TASK_ID', l_task_id);
4232: fnd_msg_pub.ADD;
4233: ELSIF(x_event_return_status = 'ERROR') THEN
4234: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4235: fnd_message.set_token('P_TASK_ID', l_task_id);
4236: fnd_msg_pub.ADD;
4237: x_return_status := fnd_api.g_ret_sts_unexp_error;
4238: RAISE fnd_api.g_exc_unexpected_error;
4239: END IF;

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

4245: x_return_status := fnd_api.g_ret_sts_unexp_error;
4246: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4247: WHEN OTHERS THEN
4248: ROLLBACK TO update_task_pvt;
4249: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4250: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4251: fnd_msg_pub.ADD;
4252: x_return_status := fnd_api.g_ret_sts_unexp_error;
4253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4246: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4247: WHEN OTHERS THEN
4248: ROLLBACK TO update_task_pvt;
4249: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4250: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4251: fnd_msg_pub.ADD;
4252: x_return_status := fnd_api.g_ret_sts_unexp_error;
4253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4254: END; ---- End of private Update Task

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

4305: x_return_status := fnd_api.g_ret_sts_unexp_error;
4306: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4307: WHEN OTHERS THEN
4308: ROLLBACK TO delete_task_pvt2;
4309: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4310: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4311: fnd_msg_pub.ADD;
4312: x_return_status := fnd_api.g_ret_sts_unexp_error;
4313: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4306: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4307: WHEN OTHERS THEN
4308: ROLLBACK TO delete_task_pvt2;
4309: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4310: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4311: fnd_msg_pub.ADD;
4312: x_return_status := fnd_api.g_ret_sts_unexp_error;
4313: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4314: END;

Line 4600: fnd_message.set_name('JTF', 'JTF_TASK_DELETING_PARENT_CHILD');

4596: OPEN c_parent_child(l_date_selected);
4597: FETCH c_parent_child into l_parent_child_count;
4598:
4599: IF l_parent_child_count>0 THEN
4600: fnd_message.set_name('JTF', 'JTF_TASK_DELETING_PARENT_CHILD');
4601: fnd_msg_pub.ADD;
4602: x_return_status := fnd_api.g_ret_sts_unexp_error;
4603: RAISE fnd_api.g_exc_unexpected_error;
4604: END IF;

Line 4799: fnd_message.set_name('JTF', 'JTF_TASK_ERROR_DELETING_TASK');

4795: , object_changed_date = SYSDATE
4796: WHERE task_id = l_task_id;
4797:
4798: IF SQL%NOTFOUND THEN
4799: fnd_message.set_name('JTF', 'JTF_TASK_ERROR_DELETING_TASK');
4800: fnd_msg_pub.ADD;
4801: x_return_status := fnd_api.g_ret_sts_unexp_error;
4802: RAISE fnd_api.g_exc_unexpected_error;
4803: END IF;

Line 4832: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');

4828: jtf_task_wf_events_pvt.publish_delete_task(p_task_rec => l_task_rec_type
4829: , x_return_status => x_event_return_status);
4830:
4831: IF (x_event_return_status = 'WARNING') THEN
4832: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4833: fnd_message.set_token('P_TASK_ID', l_task_id);
4834: fnd_msg_pub.ADD;
4835: ELSIF(x_event_return_status = 'ERROR') THEN
4836: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

Line 4833: fnd_message.set_token('P_TASK_ID', l_task_id);

4829: , x_return_status => x_event_return_status);
4830:
4831: IF (x_event_return_status = 'WARNING') THEN
4832: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4833: fnd_message.set_token('P_TASK_ID', l_task_id);
4834: fnd_msg_pub.ADD;
4835: ELSIF(x_event_return_status = 'ERROR') THEN
4836: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4837: fnd_message.set_token('P_TASK_ID', l_task_id);

Line 4836: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

4832: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4833: fnd_message.set_token('P_TASK_ID', l_task_id);
4834: fnd_msg_pub.ADD;
4835: ELSIF(x_event_return_status = 'ERROR') THEN
4836: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4837: fnd_message.set_token('P_TASK_ID', l_task_id);
4838: fnd_msg_pub.ADD;
4839: x_return_status := fnd_api.g_ret_sts_unexp_error;
4840: RAISE fnd_api.g_exc_unexpected_error;

Line 4837: fnd_message.set_token('P_TASK_ID', l_task_id);

4833: fnd_message.set_token('P_TASK_ID', l_task_id);
4834: fnd_msg_pub.ADD;
4835: ELSIF(x_event_return_status = 'ERROR') THEN
4836: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4837: fnd_message.set_token('P_TASK_ID', l_task_id);
4838: fnd_msg_pub.ADD;
4839: x_return_status := fnd_api.g_ret_sts_unexp_error;
4840: RAISE fnd_api.g_exc_unexpected_error;
4841: END IF;

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

4915: x_return_status := fnd_api.g_ret_sts_unexp_error;
4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4917: WHEN OTHERS THEN
4918: ROLLBACK TO delete_task_pvt;
4919: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4920: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4921: fnd_msg_pub.ADD;
4922: x_return_status := fnd_api.g_ret_sts_unexp_error;
4923: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4917: WHEN OTHERS THEN
4918: ROLLBACK TO delete_task_pvt;
4919: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4920: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4921: fnd_msg_pub.ADD;
4922: x_return_status := fnd_api.g_ret_sts_unexp_error;
4923: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4924: END;

Line 5973: fnd_message.set_name('JTF', 'JTF_TK_NO_DATE');

5969:
5970: IF (c_get_date%NOTFOUND) THEN
5971: CLOSE c_get_date;
5972:
5973: fnd_message.set_name('JTF', 'JTF_TK_NO_DATE');
5974: fnd_msg_pub.ADD;
5975: RAISE fnd_api.g_exc_error;
5976: ELSE
5977: CLOSE c_get_date;