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 3357: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');

3353: fnd_msg_pub.initialize;
3354: END IF;
3355:
3356: IF p_task_name IS NULL THEN
3357: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');
3358: fnd_msg_pub.ADD;
3359: RAISE fnd_api.g_exc_unexpected_error;
3360: END IF;
3361:

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

3360: END IF;
3361:
3362: IF p_task_split_flag IS NOT NULL THEN
3363: IF NOT p_task_split_flag IN('M', 'D', fnd_api.g_miss_char) THEN
3364: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3365: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
3366: fnd_msg_pub.ADD;
3367: RAISE fnd_api.g_exc_unexpected_error;
3368: END IF;

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

3361:
3362: IF p_task_split_flag IS NOT NULL THEN
3363: IF NOT p_task_split_flag IN('M', 'D', fnd_api.g_miss_char) THEN
3364: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3365: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task split flag');
3366: fnd_msg_pub.ADD;
3367: RAISE fnd_api.g_exc_unexpected_error;
3368: END IF;
3369: END IF;

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

3368: END IF;
3369: END IF;
3370:
3371: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
3372: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3373: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
3374: fnd_msg_pub.ADD;
3375: RAISE fnd_api.g_exc_unexpected_error;
3376: END IF;

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

3369: END IF;
3370:
3371: IF NOT p_task_confirmation_status IN('N', 'C', 'R', fnd_api.g_miss_char) THEN
3372: fnd_message.set_name('JTF', 'JTF_TASK_CONSTRUCT_ID');
3373: fnd_message.set_token('%P_SHITF_CONSTRUCT_ID', 'task confirmation status');
3374: fnd_msg_pub.ADD;
3375: RAISE fnd_api.g_exc_unexpected_error;
3376: END IF;
3377:

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

3378: OPEN c_task;
3379: FETCH c_task INTO tasks;
3380: IF c_task%NOTFOUND THEN
3381: CLOSE c_task;
3382: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3383: fnd_message.set_token('P_TASK_ID', p_task_id);
3384: fnd_msg_pub.ADD;
3385: x_return_status := fnd_api.g_ret_sts_unexp_error;
3386: RAISE fnd_api.g_exc_unexpected_error;

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

3379: FETCH c_task INTO tasks;
3380: IF c_task%NOTFOUND THEN
3381: CLOSE c_task;
3382: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3383: fnd_message.set_token('P_TASK_ID', p_task_id);
3384: fnd_msg_pub.ADD;
3385: x_return_status := fnd_api.g_ret_sts_unexp_error;
3386: RAISE fnd_api.g_exc_unexpected_error;
3387: END IF;

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

3966: FETCH task_ass_orig INTO task_ass_orig_rec;
3967: IF ((task_ass_orig%NOTFOUND) OR(task_ass_orig_rec.assignee_role <> 'OWNER')) THEN
3968: CLOSE task_ass_orig; -- Fix a missing CLOSE on 4/18/2002
3969:
3970: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');
3971: fnd_msg_pub.ADD;
3972: x_return_status := fnd_api.g_ret_sts_unexp_error;
3973: RAISE fnd_api.g_exc_unexpected_error;
3974: END IF;

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

4031: CLOSE task_ass_orig;
4032:
4033: CLOSE task_ass_u; -- Fix a missing CLOSE on 4/18/2002
4034:
4035: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER_ASG');
4036: fnd_msg_pub.ADD;
4037: x_return_status := fnd_api.g_ret_sts_unexp_error;
4038: RAISE fnd_api.g_exc_unexpected_error;
4039: END IF;

Line 4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');

4170: l_booking_start_date),
4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4172: END IF;
4173:
4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
4175: fnd_message.set_token ('RES', l_name );
4176: fnd_message.set_token ('DATE', l_date);
4177:
4178: fnd_msg_pub.add;

Line 4175: fnd_message.set_token ('RES', l_name );

4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4172: END IF;
4173:
4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
4175: fnd_message.set_token ('RES', l_name );
4176: fnd_message.set_token ('DATE', l_date);
4177:
4178: fnd_msg_pub.add;
4179: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4176: fnd_message.set_token ('DATE', l_date);

4172: END IF;
4173:
4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
4175: fnd_message.set_token ('RES', l_name );
4176: fnd_message.set_token ('DATE', l_date);
4177:
4178: fnd_msg_pub.add;
4179: x_return_status := fnd_api.g_ret_sts_unexp_error;
4180:

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

4307: , x_return_status => x_event_return_status
4308: );
4309:
4310: IF (x_event_return_status = 'WARNING') THEN
4311: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4312: fnd_message.set_token('P_TASK_ID', l_task_id);
4313: fnd_msg_pub.ADD;
4314: ELSIF(x_event_return_status = 'ERROR') THEN
4315: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

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

4308: );
4309:
4310: IF (x_event_return_status = 'WARNING') THEN
4311: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4312: fnd_message.set_token('P_TASK_ID', l_task_id);
4313: fnd_msg_pub.ADD;
4314: ELSIF(x_event_return_status = 'ERROR') THEN
4315: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4316: fnd_message.set_token('P_TASK_ID', l_task_id);

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

4311: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4312: fnd_message.set_token('P_TASK_ID', l_task_id);
4313: fnd_msg_pub.ADD;
4314: ELSIF(x_event_return_status = 'ERROR') THEN
4315: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4316: fnd_message.set_token('P_TASK_ID', l_task_id);
4317: fnd_msg_pub.ADD;
4318: x_return_status := fnd_api.g_ret_sts_unexp_error;
4319: RAISE fnd_api.g_exc_unexpected_error;

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

4312: fnd_message.set_token('P_TASK_ID', l_task_id);
4313: fnd_msg_pub.ADD;
4314: ELSIF(x_event_return_status = 'ERROR') THEN
4315: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4316: fnd_message.set_token('P_TASK_ID', l_task_id);
4317: fnd_msg_pub.ADD;
4318: x_return_status := fnd_api.g_ret_sts_unexp_error;
4319: RAISE fnd_api.g_exc_unexpected_error;
4320: END IF;

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

4326: x_return_status := fnd_api.g_ret_sts_unexp_error;
4327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4328: WHEN OTHERS THEN
4329: ROLLBACK TO update_task_pvt;
4330: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4331: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4332: fnd_msg_pub.ADD;
4333: x_return_status := fnd_api.g_ret_sts_unexp_error;
4334: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4328: WHEN OTHERS THEN
4329: ROLLBACK TO update_task_pvt;
4330: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4331: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4332: fnd_msg_pub.ADD;
4333: x_return_status := fnd_api.g_ret_sts_unexp_error;
4334: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4335: END; ---- End of private Update Task

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

4386: x_return_status := fnd_api.g_ret_sts_unexp_error;
4387: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4388: WHEN OTHERS THEN
4389: ROLLBACK TO delete_task_pvt2;
4390: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4391: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4392: fnd_msg_pub.ADD;
4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4387: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4388: WHEN OTHERS THEN
4389: ROLLBACK TO delete_task_pvt2;
4390: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4391: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4392: fnd_msg_pub.ADD;
4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4395: END;

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

4677: OPEN c_parent_child(l_date_selected);
4678: FETCH c_parent_child into l_parent_child_count;
4679:
4680: IF l_parent_child_count>0 THEN
4681: fnd_message.set_name('JTF', 'JTF_TASK_DELETING_PARENT_CHILD');
4682: fnd_msg_pub.ADD;
4683: x_return_status := fnd_api.g_ret_sts_unexp_error;
4684: RAISE fnd_api.g_exc_unexpected_error;
4685: END IF;

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

4876: , object_changed_date = SYSDATE
4877: WHERE task_id = l_task_id;
4878:
4879: IF SQL%NOTFOUND THEN
4880: fnd_message.set_name('JTF', 'JTF_TASK_ERROR_DELETING_TASK');
4881: fnd_msg_pub.ADD;
4882: x_return_status := fnd_api.g_ret_sts_unexp_error;
4883: RAISE fnd_api.g_exc_unexpected_error;
4884: END IF;

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

4909: jtf_task_wf_events_pvt.publish_delete_task(p_task_rec => l_task_rec_type
4910: , x_return_status => x_event_return_status);
4911:
4912: IF (x_event_return_status = 'WARNING') THEN
4913: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4914: fnd_message.set_token('P_TASK_ID', l_task_id);
4915: fnd_msg_pub.ADD;
4916: ELSIF(x_event_return_status = 'ERROR') THEN
4917: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');

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

4910: , x_return_status => x_event_return_status);
4911:
4912: IF (x_event_return_status = 'WARNING') THEN
4913: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4914: fnd_message.set_token('P_TASK_ID', l_task_id);
4915: fnd_msg_pub.ADD;
4916: ELSIF(x_event_return_status = 'ERROR') THEN
4917: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4918: fnd_message.set_token('P_TASK_ID', l_task_id);

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

4913: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_WARNING');
4914: fnd_message.set_token('P_TASK_ID', l_task_id);
4915: fnd_msg_pub.ADD;
4916: ELSIF(x_event_return_status = 'ERROR') THEN
4917: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4918: fnd_message.set_token('P_TASK_ID', l_task_id);
4919: fnd_msg_pub.ADD;
4920: x_return_status := fnd_api.g_ret_sts_unexp_error;
4921: RAISE fnd_api.g_exc_unexpected_error;

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

4914: fnd_message.set_token('P_TASK_ID', l_task_id);
4915: fnd_msg_pub.ADD;
4916: ELSIF(x_event_return_status = 'ERROR') THEN
4917: fnd_message.set_name('JTF', 'JTF_TASK_EVENT_ERROR');
4918: fnd_message.set_token('P_TASK_ID', l_task_id);
4919: fnd_msg_pub.ADD;
4920: x_return_status := fnd_api.g_ret_sts_unexp_error;
4921: RAISE fnd_api.g_exc_unexpected_error;
4922: END IF;

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

4996: x_return_status := fnd_api.g_ret_sts_unexp_error;
4997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4998: WHEN OTHERS THEN
4999: ROLLBACK TO delete_task_pvt;
5000: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
5001: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
5002: fnd_msg_pub.ADD;
5003: x_return_status := fnd_api.g_ret_sts_unexp_error;
5004: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4998: WHEN OTHERS THEN
4999: ROLLBACK TO delete_task_pvt;
5000: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
5001: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
5002: fnd_msg_pub.ADD;
5003: x_return_status := fnd_api.g_ret_sts_unexp_error;
5004: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5005: END;

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

6050:
6051: IF (c_get_date%NOTFOUND) THEN
6052: CLOSE c_get_date;
6053:
6054: fnd_message.set_name('JTF', 'JTF_TK_NO_DATE');
6055: fnd_msg_pub.ADD;
6056: RAISE fnd_api.g_exc_error;
6057: ELSE
6058: CLOSE c_get_date;