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_PUB dependencies on FND_MESSAGE

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

247: x_return_status := fnd_api.g_ret_sts_unexp_error;
248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO create_task_pub2;
251: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
252: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
253: fnd_msg_pub.ADD;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
249: WHEN OTHERS THEN
250: ROLLBACK TO create_task_pub2;
251: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
252: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
253: fnd_msg_pub.ADD;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
256: END;

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

513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
515: WHEN OTHERS THEN
516: ROLLBACK TO create_task_pub1;
517: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
518: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
519: fnd_msg_pub.ADD;
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

514: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
515: WHEN OTHERS THEN
516: ROLLBACK TO create_task_pub1;
517: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
518: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
519: fnd_msg_pub.ADD;
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
522: END;

Line 739: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_TYPE');

735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;
737:
738: IF l_task_type_id IS NULL THEN
739: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_TYPE');
740: fnd_msg_pub.ADD;
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:

Line 762: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_STATUS');

758: , x_task_status_id => l_task_status_id
759: );
760:
761: IF l_task_status_id IS NULL THEN
762: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_STATUS');
763: fnd_msg_pub.ADD;
764: RAISE fnd_api.g_exc_unexpected_error;
765: END IF;
766:

Line 857: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER');

853: , x_owner_type_code => l_owner_type_code
854: );
855:
856: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
857: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_OWNER');
858: fnd_msg_pub.ADD;
859: x_return_status := fnd_api.g_ret_sts_unexp_error;
860: RAISE fnd_api.g_exc_unexpected_error;
861: END IF;

Line 864: fnd_message.set_name('JTF', 'JTF_TASK_OWNER');

860: RAISE fnd_api.g_exc_unexpected_error;
861: END IF;
862:
863: IF l_owner_id IS NULL THEN
864: fnd_message.set_name('JTF', 'JTF_TASK_OWNER');
865: fnd_msg_pub.ADD;
866: RAISE fnd_api.g_exc_unexpected_error;
867: END IF;
868:

Line 870: fnd_message.set_name('JTF', 'JTF_TASK_OWNER_TYPE_CODE');

866: RAISE fnd_api.g_exc_unexpected_error;
867: END IF;
868:
869: IF l_owner_type_code IS NULL THEN
870: fnd_message.set_name('JTF', 'JTF_TASK_OWNER_TYPE_CODE');
871: fnd_msg_pub.ADD;
872: RAISE fnd_api.g_exc_unexpected_error;
873: END IF;
874:

Line 1251: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PCT_COMPLETE');

1247: ------- Validate Percentage Complete
1248: -------
1249: IF p_percentage_complete IS NOT NULL THEN
1250: IF p_percentage_complete < 0 OR p_percentage_complete > 100 THEN
1251: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PCT_COMPLETE');
1252: fnd_msg_pub.ADD;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: RAISE fnd_api.g_exc_unexpected_error;
1255: END IF;

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

1760: x_return_status := fnd_api.g_ret_sts_unexp_error;
1761: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1762: WHEN OTHERS THEN
1763: ROLLBACK TO create_task_pub;
1764: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1765: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1766: fnd_msg_pub.ADD;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1761: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1762: WHEN OTHERS THEN
1763: ROLLBACK TO create_task_pub;
1764: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1765: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1766: fnd_msg_pub.ADD;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1769: END;

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

2032: x_return_status := fnd_api.g_ret_sts_unexp_error;
2033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2034: WHEN OTHERS THEN
2035: ROLLBACK TO create_task_pub2;
2036: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2037: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2038: fnd_msg_pub.ADD;
2039: x_return_status := fnd_api.g_ret_sts_unexp_error;
2040: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2034: WHEN OTHERS THEN
2035: ROLLBACK TO create_task_pub2;
2036: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2037: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2038: fnd_msg_pub.ADD;
2039: x_return_status := fnd_api.g_ret_sts_unexp_error;
2040: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2041: END;

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

2283: x_return_status := fnd_api.g_ret_sts_unexp_error;
2284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2285: WHEN OTHERS THEN
2286: ROLLBACK TO update_task_pub1;
2287: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2288: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2289: fnd_msg_pub.ADD;
2290: x_return_status := fnd_api.g_ret_sts_unexp_error;
2291: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2285: WHEN OTHERS THEN
2286: ROLLBACK TO update_task_pub1;
2287: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2288: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2289: fnd_msg_pub.ADD;
2290: x_return_status := fnd_api.g_ret_sts_unexp_error;
2291: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2292: END;

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

2539: x_return_status := fnd_api.g_ret_sts_unexp_error;
2540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2541: WHEN OTHERS THEN
2542: ROLLBACK TO update_task_pub2;
2543: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2544: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2545: fnd_msg_pub.ADD;
2546: x_return_status := fnd_api.g_ret_sts_unexp_error;
2547: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2541: WHEN OTHERS THEN
2542: ROLLBACK TO update_task_pub2;
2543: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2544: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2545: fnd_msg_pub.ADD;
2546: x_return_status := fnd_api.g_ret_sts_unexp_error;
2547: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2548: END;

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

2799: x_return_status := fnd_api.g_ret_sts_unexp_error;
2800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2801: WHEN OTHERS THEN
2802: ROLLBACK TO update_task_pub3;
2803: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2804: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2805: fnd_msg_pub.ADD;
2806: x_return_status := fnd_api.g_ret_sts_unexp_error;
2807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2801: WHEN OTHERS THEN
2802: ROLLBACK TO update_task_pub3;
2803: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2804: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2805: fnd_msg_pub.ADD;
2806: x_return_status := fnd_api.g_ret_sts_unexp_error;
2807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2808: END;

Line 3296: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');

3292: -----
3293: ----- Validate Tasks
3294: -----
3295: IF (l_task_id = fnd_api.g_miss_num AND l_task_number = fnd_api.g_miss_char) THEN
3296: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
3297: fnd_msg_pub.ADD;
3298: x_return_status := fnd_api.g_ret_sts_unexp_error;
3299: RAISE fnd_api.g_exc_unexpected_error;
3300: ELSE

Line 3322: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');

3318: RAISE fnd_api.g_exc_unexpected_error;
3319: END IF;
3320:
3321: IF l_task_id IS NULL THEN
3322: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
3323: fnd_message.set_token('P_TASK_NUMBER', l_task_number);
3324: fnd_msg_pub.ADD;
3325: x_return_status := fnd_api.g_ret_sts_unexp_error;
3326: RAISE fnd_api.g_exc_unexpected_error;

Line 3323: fnd_message.set_token('P_TASK_NUMBER', l_task_number);

3319: END IF;
3320:
3321: IF l_task_id IS NULL THEN
3322: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
3323: fnd_message.set_token('P_TASK_NUMBER', l_task_number);
3324: fnd_msg_pub.ADD;
3325: x_return_status := fnd_api.g_ret_sts_unexp_error;
3326: RAISE fnd_api.g_exc_unexpected_error;
3327: END IF;

Line 3334: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NAME');

3330: -----
3331: ----- Task Name
3332: -----
3333: IF l_task_name IS NULL THEN
3334: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NAME');
3335: fnd_msg_pub.ADD;
3336: x_return_status := fnd_api.g_ret_sts_unexp_error;
3337: RAISE fnd_api.g_exc_unexpected_error;
3338: END IF;

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

3347: FETCH c_task_update
3348: INTO task_rec;
3349:
3350: IF c_task_update%NOTFOUND THEN
3351: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3352: fnd_message.set_token('P_TASK_ID', l_task_id);
3353: fnd_msg_pub.ADD;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: RAISE fnd_api.g_exc_unexpected_error;

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

3348: INTO task_rec;
3349:
3350: IF c_task_update%NOTFOUND THEN
3351: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3352: fnd_message.set_token('P_TASK_ID', l_task_id);
3353: fnd_msg_pub.ADD;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: RAISE fnd_api.g_exc_unexpected_error;
3356: END IF;

Line 3392: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TYPE');

3388: RAISE fnd_api.g_exc_unexpected_error;
3389: END IF;
3390:
3391: IF l_task_type_id IS NULL THEN
3392: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TYPE');
3393: fnd_msg_pub.ADD;
3394: RAISE fnd_api.g_exc_unexpected_error;
3395: END IF;
3396:

Line 3455: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_status');

3451: RAISE fnd_api.g_exc_unexpected_error;
3452: END IF;
3453:
3454: IF l_task_status_id IS NULL THEN
3455: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_status');
3456: fnd_msg_pub.ADD;
3457: RAISE fnd_api.g_exc_unexpected_error;
3458: END IF;
3459:

Line 3810: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PCT_COMPLETE');

3806: ------- Validate percentage complete
3807: -------
3808: IF (p_percentage_complete <> fnd_api.g_miss_num OR p_percentage_complete IS NULL) THEN
3809: IF p_percentage_complete < 0 OR p_percentage_complete > 100 THEN
3810: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PCT_COMPLETE');
3811: fnd_msg_pub.ADD;
3812: x_return_status := fnd_api.g_ret_sts_unexp_error;
3813: RAISE fnd_api.g_exc_unexpected_error;
3814: END IF;

Line 4222: fnd_message.set_name('JTF', 'INVALID_NOTIFICATION');

4218: , x_return_status => x_return_status
4219: );
4220:
4221: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4222: fnd_message.set_name('JTF', 'INVALID_NOTIFICATION');
4223: fnd_msg_pub.ADD;
4224: x_return_status := fnd_api.g_ret_sts_unexp_error;
4225: RAISE fnd_api.g_exc_unexpected_error;
4226: END IF;

Line 4270: fnd_message.set_name('JTF', 'INVALID_ALARM_PARAM');

4266: , x_return_status => x_return_status
4267: );
4268:
4269: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4270: fnd_message.set_name('JTF', 'INVALID_ALARM_PARAM');
4271: fnd_msg_pub.ADD;
4272: x_return_status := fnd_api.g_ret_sts_unexp_error;
4273: RAISE fnd_api.g_exc_unexpected_error;
4274: END IF;

Line 4278: fnd_message.set_name('JTF', 'INVALID_ALARM_PARAM');

4274: END IF;
4275:
4276: IF l_alarm_fired_count IS NOT NULL THEN
4277: IF l_alarm_fired_count > l_alarm_count THEN
4278: fnd_message.set_name('JTF', 'INVALID_ALARM_PARAM');
4279: fnd_msg_pub.ADD;
4280: x_return_status := fnd_api.g_ret_sts_unexp_error;
4281: RAISE fnd_api.g_exc_unexpected_error;
4282: END IF;

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

4539: ROLLBACK TO update_task_pub;
4540: x_return_status := fnd_api.g_ret_sts_unexp_error;
4541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4542: WHEN OTHERS THEN
4543: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4544: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4545: fnd_msg_pub.ADD;
4546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4547: ROLLBACK TO update_task_pub;

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

4540: x_return_status := fnd_api.g_ret_sts_unexp_error;
4541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4542: WHEN OTHERS THEN
4543: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4544: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4545: fnd_msg_pub.ADD;
4546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4547: ROLLBACK TO update_task_pub;
4548: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4605: ROLLBACK TO delete_task_pub2;
4606: x_return_status := fnd_api.g_ret_sts_unexp_error;
4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4608: WHEN OTHERS THEN
4609: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4610: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4611: fnd_msg_pub.ADD;
4612: ROLLBACK TO delete_task_pub2;
4613: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4606: x_return_status := fnd_api.g_ret_sts_unexp_error;
4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4608: WHEN OTHERS THEN
4609: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4610: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4611: fnd_msg_pub.ADD;
4612: ROLLBACK TO delete_task_pub2;
4613: x_return_status := fnd_api.g_ret_sts_unexp_error;
4614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4649: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');

4645: fnd_msg_pub.initialize;
4646: END IF;
4647:
4648: IF (l_task_id IS NULL AND l_task_number IS NULL) THEN
4649: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
4650: fnd_msg_pub.ADD;
4651: x_return_status := fnd_api.g_ret_sts_unexp_error;
4652: RAISE fnd_api.g_exc_unexpected_error;
4653: ELSE

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

4693: ROLLBACK TO delete_task_pub;
4694: x_return_status := fnd_api.g_ret_sts_unexp_error;
4695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4696: WHEN OTHERS THEN
4697: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4698: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4699: fnd_msg_pub.ADD;
4700: ROLLBACK TO delete_task_pub;
4701: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4694: x_return_status := fnd_api.g_ret_sts_unexp_error;
4695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4696: WHEN OTHERS THEN
4697: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4698: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4699: fnd_msg_pub.ADD;
4700: ROLLBACK TO delete_task_pub;
4701: x_return_status := fnd_api.g_ret_sts_unexp_error;
4702: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5184: fnd_message.set_name('JTF', 'JTF_TK_EXP_FILE_NAME_NULL');

5180: -- required parameters to control records returned
5181:
5182: -- p_file_name must not be null
5183: IF (p_file_name IS NULL) THEN
5184: fnd_message.set_name('JTF', 'JTF_TK_EXP_FILE_NAME_NULL');
5185: RAISE fnd_api.g_exc_error;
5186: END IF;
5187:
5188: -- l_table_count must be > 0, or no records are in the table

Line 5190: fnd_message.set_name('JTF', 'JTF_TK_EXP_TABLE_EMPTY');

5186: END IF;
5187:
5188: -- l_table_count must be > 0, or no records are in the table
5189: IF (l_tbl_count = 0) THEN
5190: fnd_message.set_name('JTF', 'JTF_TK_EXP_TABLE_EMPTY');
5191: RAISE fnd_api.g_exc_error;
5192: END IF;
5193:
5194: jtf_tasks_pvt.export_file(l_path, p_file_name, p_task_table, x_return_status, x_msg_count

Line 5243: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');

5239:
5240: IF c_task_number%NOTFOUND THEN
5241: CLOSE c_task_number;
5242:
5243: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
5244: fnd_message.set_token('P_TASK_NUMBER', p_task_number);
5245: fnd_msg_pub.ADD;
5246: RAISE fnd_api.g_exc_error;
5247: ELSE

Line 5244: fnd_message.set_token('P_TASK_NUMBER', p_task_number);

5240: IF c_task_number%NOTFOUND THEN
5241: CLOSE c_task_number;
5242:
5243: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
5244: fnd_message.set_token('P_TASK_NUMBER', p_task_number);
5245: fnd_msg_pub.ADD;
5246: RAISE fnd_api.g_exc_error;
5247: ELSE
5248: CLOSE c_task_number;

Line 5259: fnd_message.set_name('JTF', 'JTF_TASK_INV_TK_NAME');

5255:
5256: IF c_task_name%NOTFOUND THEN
5257: CLOSE c_task_name;
5258:
5259: fnd_message.set_name('JTF', 'JTF_TASK_INV_TK_NAME');
5260: fnd_msg_pub.ADD;
5261: RAISE fnd_api.g_exc_error;
5262: ELSE
5263: CLOSE c_task_name;

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

5281:
5282: IF c_task_id%NOTFOUND THEN
5283: CLOSE c_task_id;
5284:
5285: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
5286: fnd_message.set_token('P_TASK_ID', p_task_id);
5287: fnd_msg_pub.ADD;
5288: RAISE fnd_api.g_exc_error;
5289: ELSE

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

5282: IF c_task_id%NOTFOUND THEN
5283: CLOSE c_task_id;
5284:
5285: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
5286: fnd_message.set_token('P_TASK_ID', p_task_id);
5287: fnd_msg_pub.ADD;
5288: RAISE fnd_api.g_exc_error;
5289: ELSE
5290: CLOSE c_task_id;

Line 5299: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_DATES');

5295: PROCEDURE val_dates(p_start IN DATE, p_end IN DATE) IS
5296: BEGIN
5297: IF (p_start IS NOT NULL) AND(p_end IS NOT NULL) THEN
5298: IF (p_end < p_start) THEN
5299: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_DATES');
5300: fnd_message.set_token('P_DATE_TAG', p_start);
5301: fnd_msg_pub.ADD;
5302: RAISE fnd_api.g_exc_error;
5303: END IF;

Line 5300: fnd_message.set_token('P_DATE_TAG', p_start);

5296: BEGIN
5297: IF (p_start IS NOT NULL) AND(p_end IS NOT NULL) THEN
5298: IF (p_end < p_start) THEN
5299: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_DATES');
5300: fnd_message.set_token('P_DATE_TAG', p_start);
5301: fnd_msg_pub.ADD;
5302: RAISE fnd_api.g_exc_error;
5303: END IF;
5304: END IF;

Line 5327: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');

5323:
5324: IF c_assigned_by_name%NOTFOUND THEN
5325: CLOSE c_assigned_by_name;
5326:
5327: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');
5328: fnd_msg_pub.ADD;
5329: RAISE fnd_api.g_exc_error;
5330: ELSE
5331: CLOSE c_assigned_by_name;

Line 5356: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');

5352:
5353: IF c_object_type_name%NOTFOUND THEN
5354: CLOSE c_object_type_name;
5355:
5356: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
5357: fnd_message.set_token('P_object_type_code', p_object_name);
5358: fnd_msg_pub.ADD;
5359: RAISE fnd_api.g_exc_error;
5360: ELSE

Line 5357: fnd_message.set_token('P_object_type_code', p_object_name);

5353: IF c_object_type_name%NOTFOUND THEN
5354: CLOSE c_object_type_name;
5355:
5356: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
5357: fnd_message.set_token('P_object_type_code', p_object_name);
5358: fnd_msg_pub.ADD;
5359: RAISE fnd_api.g_exc_error;
5360: ELSE
5361: CLOSE c_object_type_name;

Line 5390: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NUMBER');

5386:
5387: IF c2%NOTFOUND THEN
5388: CLOSE c2;
5389:
5390: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NUMBER');
5391: fnd_message.set_token('P_customer_number', p_customer_number);
5392: fnd_msg_pub.ADD;
5393: RAISE fnd_api.g_exc_error;
5394: ELSE

Line 5391: fnd_message.set_token('P_customer_number', p_customer_number);

5387: IF c2%NOTFOUND THEN
5388: CLOSE c2;
5389:
5390: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NUMBER');
5391: fnd_message.set_token('P_customer_number', p_customer_number);
5392: fnd_msg_pub.ADD;
5393: RAISE fnd_api.g_exc_error;
5394: ELSE
5395: CLOSE c2;

Line 5406: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NAME');

5402:
5403: IF c1%NOTFOUND THEN
5404: CLOSE c1;
5405:
5406: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NAME');
5407: fnd_message.set_token('P_customer_name', p_customer_name);
5408: fnd_msg_pub.ADD;
5409: RAISE fnd_api.g_exc_error;
5410: ELSE

Line 5407: fnd_message.set_token('P_customer_name', p_customer_name);

5403: IF c1%NOTFOUND THEN
5404: CLOSE c1;
5405:
5406: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NAME');
5407: fnd_message.set_token('P_customer_name', p_customer_name);
5408: fnd_msg_pub.ADD;
5409: RAISE fnd_api.g_exc_error;
5410: ELSE
5411: CLOSE c1;

Line 5434: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM');

5430:
5431: IF c1%NOTFOUND THEN
5432: CLOSE c1;
5433:
5434: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM');
5435: fnd_message.set_token('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);
5436: fnd_msg_pub.ADD;
5437: RAISE fnd_api.g_exc_error;
5438: ELSE

Line 5435: fnd_message.set_token('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);

5431: IF c1%NOTFOUND THEN
5432: CLOSE c1;
5433:
5434: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM');
5435: fnd_message.set_token('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);
5436: fnd_msg_pub.ADD;
5437: RAISE fnd_api.g_exc_error;
5438: ELSE
5439: CLOSE c1;

Line 5464: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');

5460:
5461: IF c_task_priority_name%NOTFOUND THEN
5462: CLOSE c_task_priority_name;
5463:
5464: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');
5465: fnd_message.set_token('P_TASK_PRIORITY_NAME', p_task_priority_name);
5466: fnd_msg_pub.ADD;
5467: RAISE fnd_api.g_exc_error;
5468: ELSE

Line 5465: fnd_message.set_token('P_TASK_PRIORITY_NAME', p_task_priority_name);

5461: IF c_task_priority_name%NOTFOUND THEN
5462: CLOSE c_task_priority_name;
5463:
5464: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');
5465: fnd_message.set_token('P_TASK_PRIORITY_NAME', p_task_priority_name);
5466: fnd_msg_pub.ADD;
5467: RAISE fnd_api.g_exc_error;
5468: ELSE
5469: CLOSE c_task_priority_name;

Line 5830: fnd_message.set_name('JTF', 'JTF_TK_OBJECT_TYPE_ID_RQD');

5826:
5827: -- p_ref_object_type_code or p_ref object_id is not null then both must exist
5828: IF (p_ref_object_type_code IS NOT NULL) OR(p_ref_object_id IS NOT NULL) THEN
5829: IF (p_ref_object_type_code IS NULL) OR(p_ref_object_id IS NULL) THEN
5830: fnd_message.set_name('JTF', 'JTF_TK_OBJECT_TYPE_ID_RQD');
5831: fnd_msg_pub.ADD;
5832: RAISE fnd_api.g_exc_error;
5833: END IF;
5834: END IF;

Line 5838: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');

5834: END IF;
5835:
5836: -- p_query_or_next_code should be Q or N
5837: IF (p_query_or_next_code NOT IN('Q', 'N')) OR(p_query_or_next_code IS NULL) THEN
5838: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');
5839: fnd_msg_pub.ADD;
5840: RAISE fnd_api.g_exc_error;
5841: END IF;
5842:

Line 5845: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');

5841: END IF;
5842:
5843: -- p_show_all should be Y or N
5844: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN
5845: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');
5846: fnd_msg_pub.ADD;
5847: RAISE fnd_api.g_exc_error;
5848: END IF;
5849:

Line 5852: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');

5848: END IF;
5849:
5850: IF (p_show_all = 'N') THEN
5851: IF (p_start_pointer IS NULL) THEN
5852: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');
5853: fnd_msg_pub.ADD;
5854: RAISE fnd_api.g_exc_error;
5855: END IF;
5856:

Line 5858: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');

5854: RAISE fnd_api.g_exc_error;
5855: END IF;
5856:
5857: IF (p_rec_wanted IS NULL) THEN
5858: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');
5859: fnd_msg_pub.ADD;
5860: RAISE fnd_api.g_exc_error;
5861: END IF;
5862: END IF;

Line 6145: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');

6141: -- required parameters to control records returned
6142:
6143: -- p_query_or_next_code should be Q or N
6144: IF (p_query_or_next_code NOT IN('Q', 'N')) OR(p_query_or_next_code IS NULL) THEN
6145: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');
6146: fnd_msg_pub.ADD;
6147: RAISE fnd_api.g_exc_error;
6148: END IF;
6149:

Line 6152: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');

6148: END IF;
6149:
6150: -- p_show_all should be Y or N
6151: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN
6152: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');
6153: fnd_msg_pub.ADD;
6154: RAISE fnd_api.g_exc_error;
6155: END IF;
6156:

Line 6159: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');

6155: END IF;
6156:
6157: IF (p_show_all = 'N') THEN
6158: IF (p_start_pointer IS NULL) THEN
6159: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');
6160: fnd_msg_pub.ADD;
6161: RAISE fnd_api.g_exc_error;
6162: END IF;
6163:

Line 6165: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');

6161: RAISE fnd_api.g_exc_error;
6162: END IF;
6163:
6164: IF (p_rec_wanted IS NULL) THEN
6165: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');
6166: fnd_msg_pub.ADD;
6167: RAISE fnd_api.g_exc_error;
6168: END IF;
6169: END IF;

Line 6173: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_QRY_TYP');

6169: END IF;
6170:
6171: -- parameters to control querying
6172: IF (l_query_type NOT IN('DEPENDENCY', 'ASSIGNED', 'OWNER')) THEN
6173: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_QRY_TYP');
6174: fnd_msg_pub.ADD;
6175: RAISE fnd_api.g_exc_error;
6176: ELSE
6177: -- check date_type and date_start_or_end

Line 6179: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_DT_TYPE');

6175: RAISE fnd_api.g_exc_error;
6176: ELSE
6177: -- check date_type and date_start_or_end
6178: IF (l_date_type NOT IN('SCHEDULED', 'PLANNED', 'ACTUAL')) THEN
6179: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_DT_TYPE');
6180: fnd_msg_pub.ADD;
6181: RAISE fnd_api.g_exc_error;
6182: END IF;
6183:

Line 6185: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_STRT_END_DT');

6181: RAISE fnd_api.g_exc_error;
6182: END IF;
6183:
6184: IF (l_date_start_or_end NOT IN('END', 'START')) THEN
6185: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_STRT_END_DT');
6186: fnd_msg_pub.ADD;
6187: RAISE fnd_api.g_exc_error;
6188: END IF;
6189:

Line 6192: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_ASGND_BY');

6188: END IF;
6189:
6190: IF (l_query_type = 'ASSIGNED') THEN
6191: IF (p_assigned_by IS NULL) THEN
6192: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_ASGND_BY');
6193: fnd_msg_pub.ADD;
6194: RAISE fnd_api.g_exc_error;
6195: END IF;
6196: ELSIF(l_query_type = 'OWNER') THEN

Line 6198: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_OWNER');

6194: RAISE fnd_api.g_exc_error;
6195: END IF;
6196: ELSIF(l_query_type = 'OWNER') THEN
6197: IF (p_owner_type_code IS NULL OR p_owner_id IS NULL) THEN
6198: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_OWNER');
6199: fnd_msg_pub.ADD;
6200: RAISE fnd_api.g_exc_error;
6201: END IF;
6202: END IF;

Line 6209: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');

6205: -- validate query parameters
6206:
6207: -- task id should not be null
6208: IF (p_task_id IS NULL) THEN
6209: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
6210: fnd_msg_pub.ADD;
6211: RAISE fnd_api.g_exc_error;
6212: END IF;
6213:

Line 6589: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_ID');

6585: END IF;
6586:
6587: IF l_source_task_id IS NULL THEN
6588: x_return_status := fnd_api.g_ret_sts_unexp_error;
6589: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_ID');
6590: fnd_msg_pub.ADD;
6591: RAISE fnd_api.g_exc_unexpected_error;
6592: END IF;
6593:

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

6606: OPEN c_task;
6607: FETCH c_task INTO tasks;
6608: IF c_task%NOTFOUND THEN
6609: x_return_status := fnd_api.g_ret_sts_unexp_error;
6610: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
6611: fnd_message.set_token('P_TASK_ID', l_source_task_id);
6612: fnd_msg_pub.ADD;
6613: RAISE fnd_api.g_exc_unexpected_error;
6614: CLOSE c_task;

Line 6611: fnd_message.set_token('P_TASK_ID', l_source_task_id);

6607: FETCH c_task INTO tasks;
6608: IF c_task%NOTFOUND THEN
6609: x_return_status := fnd_api.g_ret_sts_unexp_error;
6610: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
6611: fnd_message.set_token('P_TASK_ID', l_source_task_id);
6612: fnd_msg_pub.ADD;
6613: RAISE fnd_api.g_exc_unexpected_error;
6614: CLOSE c_task;
6615: END IF;

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

7151: WHERE task_id = l_source_task_id;
7152: EXCEPTION
7153: WHEN NO_DATA_FOUND THEN
7154: x_return_status := fnd_api.g_ret_sts_unexp_error;
7155: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7156: fnd_message.set_token('P_TASK_ID', l_source_task_id);
7157: fnd_msg_pub.ADD;
7158: RAISE fnd_api.g_exc_unexpected_error;
7159: WHEN OTHERS THEN

Line 7156: fnd_message.set_token('P_TASK_ID', l_source_task_id);

7152: EXCEPTION
7153: WHEN NO_DATA_FOUND THEN
7154: x_return_status := fnd_api.g_ret_sts_unexp_error;
7155: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7156: fnd_message.set_token('P_TASK_ID', l_source_task_id);
7157: fnd_msg_pub.ADD;
7158: RAISE fnd_api.g_exc_unexpected_error;
7159: WHEN OTHERS THEN
7160: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

7156: fnd_message.set_token('P_TASK_ID', l_source_task_id);
7157: fnd_msg_pub.ADD;
7158: RAISE fnd_api.g_exc_unexpected_error;
7159: WHEN OTHERS THEN
7160: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7161: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7162: x_return_status := fnd_api.g_ret_sts_unexp_error;
7163: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7164: RAISE fnd_api.g_exc_unexpected_error;

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

7157: fnd_msg_pub.ADD;
7158: RAISE fnd_api.g_exc_unexpected_error;
7159: WHEN OTHERS THEN
7160: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7161: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7162: x_return_status := fnd_api.g_ret_sts_unexp_error;
7163: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7164: RAISE fnd_api.g_exc_unexpected_error;
7165: END;

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

7347: CLOSE c_notes;
7348: END IF;
7349: WHEN OTHERS THEN
7350: ROLLBACK TO copy_task;
7351: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7352: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7353: x_return_status := fnd_api.g_ret_sts_unexp_error;
7354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7355:

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

7348: END IF;
7349: WHEN OTHERS THEN
7350: ROLLBACK TO copy_task;
7351: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7352: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7353: x_return_status := fnd_api.g_ret_sts_unexp_error;
7354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7355:
7356: IF c_task%ISOPEN THEN

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

7548: x_return_status := fnd_api.g_ret_sts_unexp_error;
7549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7550: WHEN OTHERS THEN
7551: ROLLBACK TO create_task_from_template_pub1;
7552: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7553: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7554: fnd_msg_pub.ADD;
7555: x_return_status := fnd_api.g_ret_sts_unexp_error;
7556: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

7549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7550: WHEN OTHERS THEN
7551: ROLLBACK TO create_task_from_template_pub1;
7552: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7553: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7554: fnd_msg_pub.ADD;
7555: x_return_status := fnd_api.g_ret_sts_unexp_error;
7556: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7557: END;

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

7718: x_return_status := fnd_api.g_ret_sts_unexp_error;
7719: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7720: WHEN OTHERS THEN
7721: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7722: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7723: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7724: fnd_msg_pub.ADD;
7725: x_return_status := fnd_api.g_ret_sts_unexp_error;
7726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

7719: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7720: WHEN OTHERS THEN
7721: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7722: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7723: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7724: fnd_msg_pub.ADD;
7725: x_return_status := fnd_api.g_ret_sts_unexp_error;
7726: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7727: END;

Line 7762: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');

7758: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7759: EXCEPTION
7760: WHEN resource_locked THEN
7761: ROLLBACK TO lock_tasks_pub;
7762: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');
7763: fnd_message.set_token('P_LOCKED_RESOURCE', 'Task');
7764: x_return_status := fnd_api.g_ret_sts_unexp_error;
7765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7766: WHEN fnd_api.g_exc_unexpected_error THEN

Line 7763: fnd_message.set_token('P_LOCKED_RESOURCE', 'Task');

7759: EXCEPTION
7760: WHEN resource_locked THEN
7761: ROLLBACK TO lock_tasks_pub;
7762: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');
7763: fnd_message.set_token('P_LOCKED_RESOURCE', 'Task');
7764: x_return_status := fnd_api.g_ret_sts_unexp_error;
7765: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7766: WHEN fnd_api.g_exc_unexpected_error THEN
7767: ROLLBACK TO lock_tasks_pub;

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

7768: x_return_status := fnd_api.g_ret_sts_unexp_error;
7769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7770: WHEN OTHERS THEN
7771: ROLLBACK TO lock_tasks_pub;
7772: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7773: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7774: x_return_status := fnd_api.g_ret_sts_unexp_error;
7775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7776: END;

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

7769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7770: WHEN OTHERS THEN
7771: ROLLBACK TO lock_tasks_pub;
7772: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7773: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7774: x_return_status := fnd_api.g_ret_sts_unexp_error;
7775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7776: END;
7777:

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

7876: x_return_status := fnd_api.g_ret_sts_unexp_error;
7877: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7878: WHEN OTHERS THEN
7879: ROLLBACK TO update_task_source;
7880: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7881: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7882: x_return_status := fnd_api.g_ret_sts_unexp_error;
7883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7884: END;

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

7877: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7878: WHEN OTHERS THEN
7879: ROLLBACK TO update_task_source;
7880: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7881: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7882: x_return_status := fnd_api.g_ret_sts_unexp_error;
7883: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7884: END;
7885:

Line 7895: fnd_message.set_name('JTF', p_message_name);

7891: )
7892: RETURN VARCHAR2 IS
7893: BEGIN
7894: IF LENGTH(p_task_name) > p_length THEN
7895: fnd_message.set_name('JTF', p_message_name);
7896: fnd_msg_pub.ADD;
7897: RAISE fnd_api.g_exc_unexpected_error;
7898: ELSE
7899: RETURN p_task_name;

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

7964: FETCH c_task_validate
7965: INTO task_val;
7966:
7967: IF c_task_validate%NOTFOUND THEN
7968: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7969: fnd_message.set_token('P_TASK_ID', p_task_id);
7970: fnd_msg_pub.ADD;
7971: RAISE fnd_api.g_exc_unexpected_error;
7972: END IF;

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

7965: INTO task_val;
7966:
7967: IF c_task_validate%NOTFOUND THEN
7968: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7969: fnd_message.set_token('P_TASK_ID', p_task_id);
7970: fnd_msg_pub.ADD;
7971: RAISE fnd_api.g_exc_unexpected_error;
7972: END IF;
7973:

Line 7977: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NULL');

7973:
7974: CLOSE c_task_validate;
7975:
7976: IF (p_task_split_flag IS NULL) THEN
7977: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NULL');
7978: fnd_msg_pub.ADD;
7979: RAISE fnd_api.g_exc_unexpected_error;
7980: END IF;
7981:

Line 7983: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_EXIST');

7979: RAISE fnd_api.g_exc_unexpected_error;
7980: END IF;
7981:
7982: IF (task_val.task_split_flag IS NULL) THEN
7983: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_EXIST');
7984: fnd_msg_pub.ADD;
7985: RAISE fnd_api.g_exc_unexpected_error;
7986: END IF;
7987:

Line 7989: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_VALID');

7985: RAISE fnd_api.g_exc_unexpected_error;
7986: END IF;
7987:
7988: IF (task_val.task_split_flag <> 'D' OR task_val.task_split_flag <> 'M') THEN
7989: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_VALID');
7990: fnd_message.set_token('P_TASK_ID', p_task_id);
7991: fnd_message.set_token('P_TASK_SPLIT_FLAG', task_val.task_split_flag);
7992: fnd_msg_pub.ADD;
7993: RAISE fnd_api.g_exc_unexpected_error;

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

7986: END IF;
7987:
7988: IF (task_val.task_split_flag <> 'D' OR task_val.task_split_flag <> 'M') THEN
7989: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_VALID');
7990: fnd_message.set_token('P_TASK_ID', p_task_id);
7991: fnd_message.set_token('P_TASK_SPLIT_FLAG', task_val.task_split_flag);
7992: fnd_msg_pub.ADD;
7993: RAISE fnd_api.g_exc_unexpected_error;
7994: END IF;

Line 7991: fnd_message.set_token('P_TASK_SPLIT_FLAG', task_val.task_split_flag);

7987:
7988: IF (task_val.task_split_flag <> 'D' OR task_val.task_split_flag <> 'M') THEN
7989: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_VALID');
7990: fnd_message.set_token('P_TASK_ID', p_task_id);
7991: fnd_message.set_token('P_TASK_SPLIT_FLAG', task_val.task_split_flag);
7992: fnd_msg_pub.ADD;
7993: RAISE fnd_api.g_exc_unexpected_error;
7994: END IF;
7995:

Line 7997: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_SPLIT_FLAG');

7993: RAISE fnd_api.g_exc_unexpected_error;
7994: END IF;
7995:
7996: IF (task_val.task_split_flag <> p_task_split_flag) THEN
7997: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_SPLIT_FLAG');
7998: fnd_message.set_token('P_TASK_SPLIT_FLAG', p_task_split_flag);
7999: fnd_message.set_token('P_TASK_ID', p_task_id);
8000: fnd_msg_pub.ADD;
8001: RAISE fnd_api.g_exc_unexpected_error;

Line 7998: fnd_message.set_token('P_TASK_SPLIT_FLAG', p_task_split_flag);

7994: END IF;
7995:
7996: IF (task_val.task_split_flag <> p_task_split_flag) THEN
7997: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_SPLIT_FLAG');
7998: fnd_message.set_token('P_TASK_SPLIT_FLAG', p_task_split_flag);
7999: fnd_message.set_token('P_TASK_ID', p_task_id);
8000: fnd_msg_pub.ADD;
8001: RAISE fnd_api.g_exc_unexpected_error;
8002: END IF;

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

7995:
7996: IF (task_val.task_split_flag <> p_task_split_flag) THEN
7997: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_SPLIT_FLAG');
7998: fnd_message.set_token('P_TASK_SPLIT_FLAG', p_task_split_flag);
7999: fnd_message.set_token('P_TASK_ID', p_task_id);
8000: fnd_msg_pub.ADD;
8001: RAISE fnd_api.g_exc_unexpected_error;
8002: END IF;
8003:

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

8105: ROLLBACK TO delete_split_tasks_pub;
8106: x_return_status := fnd_api.g_ret_sts_unexp_error;
8107: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8108: WHEN OTHERS THEN
8109: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
8110: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
8111: fnd_msg_pub.ADD;
8112: ROLLBACK TO delete_split_tasks_pub;
8113: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

8106: x_return_status := fnd_api.g_ret_sts_unexp_error;
8107: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8108: WHEN OTHERS THEN
8109: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
8110: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
8111: fnd_msg_pub.ADD;
8112: ROLLBACK TO delete_split_tasks_pub;
8113: x_return_status := fnd_api.g_ret_sts_unexp_error;
8114: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);