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_MSG_PUB

Line 122: fnd_msg_pub.initialize;

118: RAISE fnd_api.g_exc_unexpected_error;
119: END IF;
120:
121: IF fnd_api.to_boolean(p_init_msg_list) THEN
122: fnd_msg_pub.initialize;
123: END IF;
124:
125: -- call new version, passing defaults for new functionality
126: -- Remove the fix of Bug 2152549: call create_task_b which is non-overloading procedure

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

239: IF fnd_api.to_boolean(p_commit) THEN
240: COMMIT WORK;
241: END IF;
242:
243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
244: EXCEPTION
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: ROLLBACK TO create_task_pub2;
247: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

244: EXCEPTION
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: ROLLBACK TO create_task_pub2;
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);

Line 253: fnd_msg_pub.ADD;

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;
257:

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

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;
257:
258: -- Overloaded Version for the Simplex Fix.
259: -- new version without table type parameters

Line 379: fnd_msg_pub.initialize;

375: RAISE fnd_api.g_exc_unexpected_error;
376: END IF;
377:
378: IF fnd_api.to_boolean(p_init_msg_list) THEN
379: fnd_msg_pub.initialize;
380: END IF;
381:
382: -- call new version, passing defaults for new functionality
383: create_task(

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

505: IF fnd_api.to_boolean(p_commit) THEN
506: COMMIT WORK;
507: END IF;
508:
509: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
510: EXCEPTION
511: WHEN fnd_api.g_exc_unexpected_error THEN
512: ROLLBACK TO create_task_pub1;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

510: EXCEPTION
511: WHEN fnd_api.g_exc_unexpected_error THEN
512: ROLLBACK TO create_task_pub1;
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);

Line 519: fnd_msg_pub.ADD;

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;
523:

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

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;
523:
524: -- Overloaded Version for Location Id Enh# 3691788.
525: PROCEDURE create_task(

Line 716: fnd_msg_pub.initialize;

712: RAISE fnd_api.g_exc_unexpected_error;
713: END IF;
714:
715: IF fnd_api.to_boolean(p_init_msg_list) THEN
716: fnd_msg_pub.initialize;
717: END IF;
718:
719: /* Modified by TSINGHAL bug fix Validate task name length 3182170 Start*/
720: l_task_name := check_param_length(p_task_name, 'JTF_TASK_NAME_INVALID_LENGTH', 80);

Line 740: fnd_msg_pub.ADD;

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:
744: -------

Line 763: fnd_msg_pub.ADD;

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:
767: -------

Line 858: fnd_msg_pub.ADD;

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;
862:

Line 865: fnd_msg_pub.ADD;

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:
869: IF l_owner_type_code IS NULL THEN

Line 871: fnd_msg_pub.ADD;

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:
875: -------

Line 1252: fnd_msg_pub.ADD;

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;
1256: END IF;

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

1752: IF fnd_api.to_boolean(p_commit) THEN
1753: COMMIT WORK;
1754: END IF;
1755:
1756: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1757: EXCEPTION
1758: WHEN fnd_api.g_exc_unexpected_error THEN
1759: ROLLBACK TO create_task_pub;
1760: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1757: EXCEPTION
1758: WHEN fnd_api.g_exc_unexpected_error THEN
1759: ROLLBACK TO create_task_pub;
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);

Line 1766: fnd_msg_pub.ADD;

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;
1770:

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

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;
1770:
1771: -- original version including table type parameters
1772: -- Remove the fix of Bug 2152549

Line 1895: fnd_msg_pub.initialize;

1891: RAISE fnd_api.g_exc_unexpected_error;
1892: END IF;
1893:
1894: IF fnd_api.to_boolean(p_init_msg_list) THEN
1895: fnd_msg_pub.initialize;
1896: END IF;
1897:
1898: -- call new version, passing defaults for new functionality
1899: -- Remove the fix of Bug 2152549: call create_task_b which is non-overloading procedure

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

2024: IF fnd_api.to_boolean(p_commit) THEN
2025: COMMIT WORK;
2026: END IF;
2027:
2028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2029: EXCEPTION
2030: WHEN fnd_api.g_exc_unexpected_error THEN
2031: ROLLBACK TO create_task_pub2;
2032: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2029: EXCEPTION
2030: WHEN fnd_api.g_exc_unexpected_error THEN
2031: ROLLBACK TO create_task_pub2;
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);

Line 2038: fnd_msg_pub.ADD;

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;
2042:

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

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;
2042:
2043: -- Old Version
2044: PROCEDURE update_task(

Line 2158: fnd_msg_pub.initialize;

2154: RAISE fnd_api.g_exc_unexpected_error;
2155: END IF;
2156:
2157: IF fnd_api.to_boolean(p_init_msg_list) THEN
2158: fnd_msg_pub.initialize;
2159: END IF;
2160:
2161: update_task
2162: (

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

2275: IF fnd_api.to_boolean(p_commit) THEN
2276: COMMIT WORK;
2277: END IF;
2278:
2279: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2280: EXCEPTION
2281: WHEN fnd_api.g_exc_unexpected_error THEN
2282: ROLLBACK TO update_task_pub1;
2283: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2280: EXCEPTION
2281: WHEN fnd_api.g_exc_unexpected_error THEN
2282: ROLLBACK TO update_task_pub1;
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);

Line 2289: fnd_msg_pub.ADD;

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;
2293:

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

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;
2293:
2294: -- Old Version
2295: PROCEDURE update_task(

Line 2411: fnd_msg_pub.initialize;

2407: RAISE fnd_api.g_exc_unexpected_error;
2408: END IF;
2409:
2410: IF fnd_api.to_boolean(p_init_msg_list) THEN
2411: fnd_msg_pub.initialize;
2412: END IF;
2413:
2414: update_task
2415: (

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

2531: IF fnd_api.to_boolean(p_commit) THEN
2532: COMMIT WORK;
2533: END IF;
2534:
2535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2536: EXCEPTION
2537: WHEN fnd_api.g_exc_unexpected_error THEN
2538: ROLLBACK TO update_task_pub2;
2539: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2536: EXCEPTION
2537: WHEN fnd_api.g_exc_unexpected_error THEN
2538: ROLLBACK TO update_task_pub2;
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);

Line 2545: fnd_msg_pub.ADD;

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;
2549:

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

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;
2549:
2550: -- Old version
2551: PROCEDURE update_task(

Line 2670: fnd_msg_pub.initialize;

2666: RAISE fnd_api.g_exc_unexpected_error;
2667: END IF;
2668:
2669: IF fnd_api.to_boolean(p_init_msg_list) THEN
2670: fnd_msg_pub.initialize;
2671: END IF;
2672:
2673: update_task
2674: (

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

2791: IF fnd_api.to_boolean(p_commit) THEN
2792: COMMIT WORK;
2793: END IF;
2794:
2795: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2796: EXCEPTION
2797: WHEN fnd_api.g_exc_unexpected_error THEN
2798: ROLLBACK TO update_task_pub3;
2799: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2796: EXCEPTION
2797: WHEN fnd_api.g_exc_unexpected_error THEN
2798: ROLLBACK TO update_task_pub3;
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);

Line 2805: fnd_msg_pub.ADD;

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;
2809:

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

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;
2809:
2810: PROCEDURE update_task(
2811: p_api_version IN NUMBER

Line 3208: fnd_msg_pub.initialize;

3204: RAISE fnd_api.g_exc_unexpected_error;
3205: END IF;
3206:
3207: IF fnd_api.to_boolean(p_init_msg_list) THEN
3208: fnd_msg_pub.initialize;
3209: END IF;
3210:
3211: /* Modified by TSINGHAL bug fix Validate task name length 3182170 Start*/
3212: l_task_name :=

Line 3305: fnd_msg_pub.ADD;

3301: ----- Validate Tasks
3302: -----
3303: IF (l_task_id = fnd_api.g_miss_num AND l_task_number = fnd_api.g_miss_char) THEN
3304: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
3305: fnd_msg_pub.ADD;
3306: x_return_status := fnd_api.g_ret_sts_unexp_error;
3307: RAISE fnd_api.g_exc_unexpected_error;
3308: ELSE
3309: SELECT DECODE(l_task_id, fnd_api.g_miss_num, NULL, l_task_id)

Line 3332: fnd_msg_pub.ADD;

3328:
3329: IF l_task_id IS NULL THEN
3330: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
3331: fnd_message.set_token('P_TASK_NUMBER', l_task_number);
3332: fnd_msg_pub.ADD;
3333: x_return_status := fnd_api.g_ret_sts_unexp_error;
3334: RAISE fnd_api.g_exc_unexpected_error;
3335: END IF;
3336: END IF;

Line 3343: fnd_msg_pub.ADD;

3339: ----- Task Name
3340: -----
3341: IF l_task_name IS NULL THEN
3342: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NAME');
3343: fnd_msg_pub.ADD;
3344: x_return_status := fnd_api.g_ret_sts_unexp_error;
3345: RAISE fnd_api.g_exc_unexpected_error;
3346: END IF;
3347:

Line 3361: fnd_msg_pub.ADD;

3357:
3358: IF c_task_update%NOTFOUND THEN
3359: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3360: fnd_message.set_token('P_TASK_ID', l_task_id);
3361: fnd_msg_pub.ADD;
3362: x_return_status := fnd_api.g_ret_sts_unexp_error;
3363: RAISE fnd_api.g_exc_unexpected_error;
3364: END IF;
3365:

Line 3401: fnd_msg_pub.ADD;

3397: END IF;
3398:
3399: IF l_task_type_id IS NULL THEN
3400: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TYPE');
3401: fnd_msg_pub.ADD;
3402: RAISE fnd_api.g_exc_unexpected_error;
3403: END IF;
3404:
3405: -------

Line 3464: fnd_msg_pub.ADD;

3460: END IF;
3461:
3462: IF l_task_status_id IS NULL THEN
3463: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_status');
3464: fnd_msg_pub.ADD;
3465: RAISE fnd_api.g_exc_unexpected_error;
3466: END IF;
3467:
3468: --------

Line 3819: fnd_msg_pub.ADD;

3815: -------
3816: IF (p_percentage_complete <> fnd_api.g_miss_num OR p_percentage_complete IS NULL) THEN
3817: IF p_percentage_complete < 0 OR p_percentage_complete > 100 THEN
3818: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PCT_COMPLETE');
3819: fnd_msg_pub.ADD;
3820: x_return_status := fnd_api.g_ret_sts_unexp_error;
3821: RAISE fnd_api.g_exc_unexpected_error;
3822: END IF;
3823: END IF;

Line 4231: fnd_msg_pub.ADD;

4227: );
4228:
4229: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4230: fnd_message.set_name('JTF', 'INVALID_NOTIFICATION');
4231: fnd_msg_pub.ADD;
4232: x_return_status := fnd_api.g_ret_sts_unexp_error;
4233: RAISE fnd_api.g_exc_unexpected_error;
4234: END IF;
4235: ELSE

Line 4279: fnd_msg_pub.ADD;

4275: );
4276:
4277: IF NOT(x_return_status = fnd_api.g_ret_sts_success) 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;
4283:

Line 4287: fnd_msg_pub.ADD;

4283:
4284: IF l_alarm_fired_count IS NOT NULL THEN
4285: IF l_alarm_fired_count > l_alarm_count THEN
4286: fnd_message.set_name('JTF', 'INVALID_ALARM_PARAM');
4287: fnd_msg_pub.ADD;
4288: x_return_status := fnd_api.g_ret_sts_unexp_error;
4289: RAISE fnd_api.g_exc_unexpected_error;
4290: END IF;
4291: END IF;

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

4553: IF fnd_api.to_boolean(p_commit) THEN
4554: COMMIT WORK;
4555: END IF;
4556:
4557: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4558: EXCEPTION
4559: WHEN fnd_api.g_exc_unexpected_error THEN
4560: ROLLBACK TO update_task_pub;
4561: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4558: EXCEPTION
4559: WHEN fnd_api.g_exc_unexpected_error THEN
4560: ROLLBACK TO update_task_pub;
4561: x_return_status := fnd_api.g_ret_sts_unexp_error;
4562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4563: WHEN NO_DATA_FOUND THEN
4564: ROLLBACK TO update_task_pub;
4565: x_return_status := fnd_api.g_ret_sts_unexp_error;
4566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4563: WHEN NO_DATA_FOUND THEN
4564: ROLLBACK TO update_task_pub;
4565: x_return_status := fnd_api.g_ret_sts_unexp_error;
4566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4567: WHEN OTHERS THEN
4568: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4569: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4570: fnd_msg_pub.ADD;

Line 4570: fnd_msg_pub.ADD;

4566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4567: WHEN OTHERS THEN
4568: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4569: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4570: fnd_msg_pub.ADD;
4571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4572: ROLLBACK TO update_task_pub;
4573: x_return_status := fnd_api.g_ret_sts_unexp_error;
4574: END;

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

4567: WHEN OTHERS THEN
4568: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4569: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4570: fnd_msg_pub.ADD;
4571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4572: ROLLBACK TO update_task_pub;
4573: x_return_status := fnd_api.g_ret_sts_unexp_error;
4574: END;
4575:

Line 4600: fnd_msg_pub.initialize;

4596: RAISE fnd_api.g_exc_unexpected_error;
4597: END IF;
4598:
4599: IF fnd_api.to_boolean(p_init_msg_list) THEN
4600: fnd_msg_pub.initialize;
4601: END IF;
4602:
4603: delete_task(
4604: p_api_version => 1.0

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

4623: IF fnd_api.to_boolean(p_commit) THEN
4624: COMMIT WORK;
4625: END IF;
4626:
4627: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4628: EXCEPTION
4629: WHEN fnd_api.g_exc_unexpected_error THEN
4630: ROLLBACK TO delete_task_pub2;
4631: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4628: EXCEPTION
4629: WHEN fnd_api.g_exc_unexpected_error THEN
4630: ROLLBACK TO delete_task_pub2;
4631: x_return_status := fnd_api.g_ret_sts_unexp_error;
4632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4633: WHEN OTHERS THEN
4634: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4635: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4636: fnd_msg_pub.ADD;

Line 4636: fnd_msg_pub.ADD;

4632: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4633: WHEN OTHERS THEN
4634: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4635: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4636: fnd_msg_pub.ADD;
4637: ROLLBACK TO delete_task_pub2;
4638: x_return_status := fnd_api.g_ret_sts_unexp_error;
4639: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4640: END;

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

4635: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4636: fnd_msg_pub.ADD;
4637: ROLLBACK TO delete_task_pub2;
4638: x_return_status := fnd_api.g_ret_sts_unexp_error;
4639: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4640: END;
4641:
4642: -- New Version
4643: PROCEDURE delete_task(

Line 4670: fnd_msg_pub.initialize;

4666: RAISE fnd_api.g_exc_unexpected_error;
4667: END IF;
4668:
4669: IF fnd_api.to_boolean(p_init_msg_list) THEN
4670: fnd_msg_pub.initialize;
4671: END IF;
4672:
4673: IF (l_task_id IS NULL AND l_task_number IS NULL) THEN
4674: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');

Line 4675: fnd_msg_pub.ADD;

4671: END IF;
4672:
4673: IF (l_task_id IS NULL AND l_task_number IS NULL) THEN
4674: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
4675: fnd_msg_pub.ADD;
4676: x_return_status := fnd_api.g_ret_sts_unexp_error;
4677: RAISE fnd_api.g_exc_unexpected_error;
4678: ELSE
4679: jtf_task_utl.validate_task(

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

4711: IF fnd_api.to_boolean(p_commit) THEN
4712: COMMIT WORK;
4713: END IF;
4714:
4715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4716: EXCEPTION
4717: WHEN fnd_api.g_exc_unexpected_error THEN
4718: ROLLBACK TO delete_task_pub;
4719: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4716: EXCEPTION
4717: WHEN fnd_api.g_exc_unexpected_error THEN
4718: ROLLBACK TO delete_task_pub;
4719: x_return_status := fnd_api.g_ret_sts_unexp_error;
4720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4721: WHEN OTHERS THEN
4722: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4723: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4724: fnd_msg_pub.ADD;

Line 4724: fnd_msg_pub.ADD;

4720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4721: WHEN OTHERS THEN
4722: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4723: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4724: fnd_msg_pub.ADD;
4725: ROLLBACK TO delete_task_pub;
4726: x_return_status := fnd_api.g_ret_sts_unexp_error;
4727: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4728: END;

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

4723: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4724: fnd_msg_pub.ADD;
4725: ROLLBACK TO delete_task_pub;
4726: x_return_status := fnd_api.g_ret_sts_unexp_error;
4727: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4728: END;
4729:
4730: PROCEDURE export_query_task -- INPUT VARIABLES
4731:

Line 4862: fnd_msg_pub.initialize;

4858: END IF;
4859:
4860: -- initialize message list i p_init_msg_list is set to true
4861: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
4862: fnd_msg_pub.initialize;
4863: END IF;
4864:
4865: export_query_task(
4866: p_api_version => p_api_version

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

4928: );
4929: EXCEPTION
4930: WHEN fnd_api.g_exc_error THEN
4931: x_return_status := fnd_api.g_ret_sts_error;
4932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4933: WHEN fnd_api.g_exc_unexpected_error THEN
4934: x_return_status := fnd_api.g_ret_sts_unexp_error;
4935: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4936: WHEN OTHERS THEN

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

4931: x_return_status := fnd_api.g_ret_sts_error;
4932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4933: WHEN fnd_api.g_exc_unexpected_error THEN
4934: x_return_status := fnd_api.g_ret_sts_unexp_error;
4935: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4936: WHEN OTHERS THEN
4937: x_return_status := fnd_api.g_ret_sts_unexp_error;
4938:
4939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4935: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4936: WHEN OTHERS THEN
4937: x_return_status := fnd_api.g_ret_sts_unexp_error;
4938:
4939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4940: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4941: END IF;
4942:
4943: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4940: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4936: WHEN OTHERS THEN
4937: x_return_status := fnd_api.g_ret_sts_unexp_error;
4938:
4939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4940: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4941: END IF;
4942:
4943: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4944: END export_query_task;

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

4939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4940: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4941: END IF;
4942:
4943: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4944: END export_query_task;
4945:
4946: PROCEDURE export_query_task -- INPUT VARIABLES
4947:

Line 5080: fnd_msg_pub.initialize;

5076: END IF;
5077:
5078: -- initialize message list i p_init_msg_list is set to true
5079: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
5080: fnd_msg_pub.initialize;
5081: END IF;
5082:
5083: query_task(
5084: p_api_version

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

5156: );
5157: EXCEPTION
5158: WHEN fnd_api.g_exc_error THEN
5159: x_return_status := fnd_api.g_ret_sts_error;
5160: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5161: WHEN fnd_api.g_exc_unexpected_error THEN
5162: x_return_status := fnd_api.g_ret_sts_unexp_error;
5163: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5164: WHEN OTHERS THEN

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

5159: x_return_status := fnd_api.g_ret_sts_error;
5160: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5161: WHEN fnd_api.g_exc_unexpected_error THEN
5162: x_return_status := fnd_api.g_ret_sts_unexp_error;
5163: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5164: WHEN OTHERS THEN
5165: x_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5167: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 5167: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

5163: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5164: WHEN OTHERS THEN
5165: x_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5167: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5168: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5169: END IF;
5170:
5171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5168: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

5164: WHEN OTHERS THEN
5165: x_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5167: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5168: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5169: END IF;
5170:
5171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5172: END export_query_task;

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

5167: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5168: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5169: END IF;
5170:
5171: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5172: END export_query_task;
5173:
5174: PROCEDURE export_file(
5175: p_api_version IN NUMBER

Line 5202: fnd_msg_pub.initialize;

5198: END IF;
5199:
5200: -- initialize message list i p_init_msg_list is set to true
5201: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
5202: fnd_msg_pub.initialize;
5203: END IF;
5204:
5205: -- required parameters to control records returned
5206:

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

5221: EXCEPTION
5222: WHEN fnd_api.g_exc_error THEN
5223: ROLLBACK TO query_next_task;
5224: x_return_status := fnd_api.g_ret_sts_error;
5225: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5226: WHEN fnd_api.g_exc_unexpected_error THEN
5227: ROLLBACK TO query_next_task;
5228: x_return_status := fnd_api.g_ret_sts_unexp_error;
5229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5225: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5226: WHEN fnd_api.g_exc_unexpected_error THEN
5227: ROLLBACK TO query_next_task;
5228: x_return_status := fnd_api.g_ret_sts_unexp_error;
5229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5230: WHEN OTHERS THEN
5231: ROLLBACK TO query_next_task;
5232: x_return_status := fnd_api.g_ret_sts_unexp_error;
5233:

Line 5234: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

5230: WHEN OTHERS THEN
5231: ROLLBACK TO query_next_task;
5232: x_return_status := fnd_api.g_ret_sts_unexp_error;
5233:
5234: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5235: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5236: END IF;
5237:
5238: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5235: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

5231: ROLLBACK TO query_next_task;
5232: x_return_status := fnd_api.g_ret_sts_unexp_error;
5233:
5234: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5235: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5236: END IF;
5237:
5238: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5239: END export_file;

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

5234: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5235: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5236: END IF;
5237:
5238: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5239: END export_file;
5240:
5241: PROCEDURE val_task(
5242: v_task_id IN OUT NOCOPY jtf_tasks_v.task_id%TYPE

Line 5270: fnd_msg_pub.ADD;

5266: CLOSE c_task_number;
5267:
5268: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
5269: fnd_message.set_token('P_TASK_NUMBER', p_task_number);
5270: fnd_msg_pub.ADD;
5271: RAISE fnd_api.g_exc_error;
5272: ELSE
5273: CLOSE c_task_number;
5274: END IF;

Line 5285: fnd_msg_pub.ADD;

5281: IF c_task_name%NOTFOUND THEN
5282: CLOSE c_task_name;
5283:
5284: fnd_message.set_name('JTF', 'JTF_TASK_INV_TK_NAME');
5285: fnd_msg_pub.ADD;
5286: RAISE fnd_api.g_exc_error;
5287: ELSE
5288: CLOSE c_task_name;
5289: END IF;

Line 5312: fnd_msg_pub.ADD;

5308: CLOSE c_task_id;
5309:
5310: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
5311: fnd_message.set_token('P_TASK_ID', p_task_id);
5312: fnd_msg_pub.ADD;
5313: RAISE fnd_api.g_exc_error;
5314: ELSE
5315: CLOSE c_task_id;
5316: END IF;

Line 5326: fnd_msg_pub.ADD;

5322: IF (p_start IS NOT NULL) AND(p_end IS NOT NULL) THEN
5323: IF (p_end < p_start) THEN
5324: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_DATES');
5325: fnd_message.set_token('P_DATE_TAG', p_start);
5326: fnd_msg_pub.ADD;
5327: RAISE fnd_api.g_exc_error;
5328: END IF;
5329: END IF;
5330: END val_dates;

Line 5353: fnd_msg_pub.ADD;

5349: IF c_assigned_by_name%NOTFOUND THEN
5350: CLOSE c_assigned_by_name;
5351:
5352: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');
5353: fnd_msg_pub.ADD;
5354: RAISE fnd_api.g_exc_error;
5355: ELSE
5356: CLOSE c_assigned_by_name;
5357: END IF;

Line 5383: fnd_msg_pub.ADD;

5379: CLOSE c_object_type_name;
5380:
5381: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
5382: fnd_message.set_token('P_object_type_code', p_object_name);
5383: fnd_msg_pub.ADD;
5384: RAISE fnd_api.g_exc_error;
5385: ELSE
5386: CLOSE c_object_type_name;
5387: END IF;

Line 5417: fnd_msg_pub.ADD;

5413: CLOSE c2;
5414:
5415: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NUMBER');
5416: fnd_message.set_token('P_customer_number', p_customer_number);
5417: fnd_msg_pub.ADD;
5418: RAISE fnd_api.g_exc_error;
5419: ELSE
5420: CLOSE c2;
5421: END IF;

Line 5433: fnd_msg_pub.ADD;

5429: CLOSE c1;
5430:
5431: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_NAME');
5432: fnd_message.set_token('P_customer_name', p_customer_name);
5433: fnd_msg_pub.ADD;
5434: RAISE fnd_api.g_exc_error;
5435: ELSE
5436: CLOSE c1;
5437: END IF;

Line 5461: fnd_msg_pub.ADD;

5457: CLOSE c1;
5458:
5459: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM');
5460: fnd_message.set_token('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);
5461: fnd_msg_pub.ADD;
5462: RAISE fnd_api.g_exc_error;
5463: ELSE
5464: CLOSE c1;
5465: END IF;

Line 5491: fnd_msg_pub.ADD;

5487: CLOSE c_task_priority_name;
5488:
5489: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');
5490: fnd_message.set_token('P_TASK_PRIORITY_NAME', p_task_priority_name);
5491: fnd_msg_pub.ADD;
5492: RAISE fnd_api.g_exc_error;
5493: ELSE
5494: CLOSE c_task_priority_name;
5495: END IF;

Line 5625: fnd_msg_pub.initialize;

5621: END IF;
5622:
5623: -- initialize message list i p_init_msg_list is set to true
5624: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
5625: fnd_msg_pub.initialize;
5626: END IF;
5627:
5628: query_task(
5629: p_api_version => p_api_version

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

5691: EXCEPTION
5692: WHEN fnd_api.g_exc_error THEN
5693: ROLLBACK TO query_task_pub1;
5694: x_return_status := fnd_api.g_ret_sts_error;
5695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5696: WHEN fnd_api.g_exc_unexpected_error THEN
5697: ROLLBACK TO query_task_pub1;
5698: x_return_status := fnd_api.g_ret_sts_unexp_error;
5699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5696: WHEN fnd_api.g_exc_unexpected_error THEN
5697: ROLLBACK TO query_task_pub1;
5698: x_return_status := fnd_api.g_ret_sts_unexp_error;
5699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5700: WHEN OTHERS THEN
5701: ROLLBACK TO query_task_pub1;
5702: x_return_status := fnd_api.g_ret_sts_unexp_error;
5703:

Line 5704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

5700: WHEN OTHERS THEN
5701: ROLLBACK TO query_task_pub1;
5702: x_return_status := fnd_api.g_ret_sts_unexp_error;
5703:
5704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5705: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5706: END IF;
5707:
5708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 5705: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

5701: ROLLBACK TO query_task_pub1;
5702: x_return_status := fnd_api.g_ret_sts_unexp_error;
5703:
5704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5705: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5706: END IF;
5707:
5708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5709: END query_task;

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

5704: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5705: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5706: END IF;
5707:
5708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5709: END query_task;
5710:
5711: PROCEDURE query_task -- possible query variables which are named after fields in jtf_tasks_v
5712:

Line 5847: fnd_msg_pub.initialize;

5843: END IF;
5844:
5845: -- initialize message list i p_init_msg_list is set to true
5846: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
5847: fnd_msg_pub.initialize;
5848: END IF;
5849:
5850: -- required parameters to control records returned
5851:

Line 5856: fnd_msg_pub.ADD;

5852: -- p_ref_object_type_code or p_ref object_id is not null then both must exist
5853: IF (p_ref_object_type_code IS NOT NULL) OR(p_ref_object_id IS NOT NULL) THEN
5854: IF (p_ref_object_type_code IS NULL) OR(p_ref_object_id IS NULL) THEN
5855: fnd_message.set_name('JTF', 'JTF_TK_OBJECT_TYPE_ID_RQD');
5856: fnd_msg_pub.ADD;
5857: RAISE fnd_api.g_exc_error;
5858: END IF;
5859: END IF;
5860:

Line 5864: fnd_msg_pub.ADD;

5860:
5861: -- p_query_or_next_code should be Q or N
5862: IF (p_query_or_next_code NOT IN('Q', 'N')) OR(p_query_or_next_code IS NULL) THEN
5863: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');
5864: fnd_msg_pub.ADD;
5865: RAISE fnd_api.g_exc_error;
5866: END IF;
5867:
5868: -- p_show_all should be Y or N

Line 5871: fnd_msg_pub.ADD;

5867:
5868: -- p_show_all should be Y or N
5869: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN
5870: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');
5871: fnd_msg_pub.ADD;
5872: RAISE fnd_api.g_exc_error;
5873: END IF;
5874:
5875: IF (p_show_all = 'N') THEN

Line 5878: fnd_msg_pub.ADD;

5874:
5875: IF (p_show_all = 'N') THEN
5876: IF (p_start_pointer IS NULL) THEN
5877: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');
5878: fnd_msg_pub.ADD;
5879: RAISE fnd_api.g_exc_error;
5880: END IF;
5881:
5882: IF (p_rec_wanted IS NULL) THEN

Line 5884: fnd_msg_pub.ADD;

5880: END IF;
5881:
5882: IF (p_rec_wanted IS NULL) THEN
5883: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');
5884: fnd_msg_pub.ADD;
5885: RAISE fnd_api.g_exc_error;
5886: END IF;
5887: END IF;
5888:

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

6073: EXCEPTION
6074: WHEN fnd_api.g_exc_error THEN
6075: ROLLBACK TO query_task_pub2;
6076: x_return_status := fnd_api.g_ret_sts_error;
6077: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6078: WHEN fnd_api.g_exc_unexpected_error THEN
6079: ROLLBACK TO query_task_pub2;
6080: x_return_status := fnd_api.g_ret_sts_unexp_error;
6081: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6077: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6078: WHEN fnd_api.g_exc_unexpected_error THEN
6079: ROLLBACK TO query_task_pub2;
6080: x_return_status := fnd_api.g_ret_sts_unexp_error;
6081: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6082: WHEN OTHERS THEN
6083: ROLLBACK TO query_task_pub2;
6084: x_return_status := fnd_api.g_ret_sts_unexp_error;
6085:

Line 6086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6082: WHEN OTHERS THEN
6083: ROLLBACK TO query_task_pub2;
6084: x_return_status := fnd_api.g_ret_sts_unexp_error;
6085:
6086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6088: END IF;
6089:
6090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 6087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6083: ROLLBACK TO query_task_pub2;
6084: x_return_status := fnd_api.g_ret_sts_unexp_error;
6085:
6086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6088: END IF;
6089:
6090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6091: END query_task;

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

6086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6088: END IF;
6089:
6090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6091: END query_task;
6092:
6093: PROCEDURE query_next_task -- INPUT VARIABLES
6094:

Line 6163: fnd_msg_pub.initialize;

6159: END IF;
6160:
6161: -- initialize message list i p_init_msg_list is set to true
6162: IF (fnd_api.to_boolean(p_init_msg_list)) THEN
6163: fnd_msg_pub.initialize;
6164: END IF;
6165:
6166: -- required parameters to control records returned
6167:

Line 6171: fnd_msg_pub.ADD;

6167:
6168: -- p_query_or_next_code should be Q or N
6169: IF (p_query_or_next_code NOT IN('Q', 'N')) OR(p_query_or_next_code IS NULL) THEN
6170: fnd_message.set_name('JTF', 'JTF_TK_INV_QRY_NXT');
6171: fnd_msg_pub.ADD;
6172: RAISE fnd_api.g_exc_error;
6173: END IF;
6174:
6175: -- p_show_all should be Y or N

Line 6178: fnd_msg_pub.ADD;

6174:
6175: -- p_show_all should be Y or N
6176: IF (p_show_all NOT IN('Y', 'N')) OR(p_show_all IS NULL) THEN
6177: fnd_message.set_name('JTF', 'JTF_TK_INV_SHOW_ALL');
6178: fnd_msg_pub.ADD;
6179: RAISE fnd_api.g_exc_error;
6180: END IF;
6181:
6182: IF (p_show_all = 'N') THEN

Line 6185: fnd_msg_pub.ADD;

6181:
6182: IF (p_show_all = 'N') THEN
6183: IF (p_start_pointer IS NULL) THEN
6184: fnd_message.set_name('JTF', 'JTF_TK_NULL_STRT_PTR');
6185: fnd_msg_pub.ADD;
6186: RAISE fnd_api.g_exc_error;
6187: END IF;
6188:
6189: IF (p_rec_wanted IS NULL) THEN

Line 6191: fnd_msg_pub.ADD;

6187: END IF;
6188:
6189: IF (p_rec_wanted IS NULL) THEN
6190: fnd_message.set_name('JTF', 'JTF_TK_NULL_REC_WANT');
6191: fnd_msg_pub.ADD;
6192: RAISE fnd_api.g_exc_error;
6193: END IF;
6194: END IF;
6195:

Line 6199: fnd_msg_pub.ADD;

6195:
6196: -- parameters to control querying
6197: IF (l_query_type NOT IN('DEPENDENCY', 'ASSIGNED', 'OWNER')) THEN
6198: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_QRY_TYP');
6199: fnd_msg_pub.ADD;
6200: RAISE fnd_api.g_exc_error;
6201: ELSE
6202: -- check date_type and date_start_or_end
6203: IF (l_date_type NOT IN('SCHEDULED', 'PLANNED', 'ACTUAL')) THEN

Line 6205: fnd_msg_pub.ADD;

6201: ELSE
6202: -- check date_type and date_start_or_end
6203: IF (l_date_type NOT IN('SCHEDULED', 'PLANNED', 'ACTUAL')) THEN
6204: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_DT_TYPE');
6205: fnd_msg_pub.ADD;
6206: RAISE fnd_api.g_exc_error;
6207: END IF;
6208:
6209: IF (l_date_start_or_end NOT IN('END', 'START')) THEN

Line 6211: fnd_msg_pub.ADD;

6207: END IF;
6208:
6209: IF (l_date_start_or_end NOT IN('END', 'START')) THEN
6210: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_INV_STRT_END_DT');
6211: fnd_msg_pub.ADD;
6212: RAISE fnd_api.g_exc_error;
6213: END IF;
6214:
6215: IF (l_query_type = 'ASSIGNED') THEN

Line 6218: fnd_msg_pub.ADD;

6214:
6215: IF (l_query_type = 'ASSIGNED') THEN
6216: IF (p_assigned_by IS NULL) THEN
6217: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_ASGND_BY');
6218: fnd_msg_pub.ADD;
6219: RAISE fnd_api.g_exc_error;
6220: END IF;
6221: ELSIF(l_query_type = 'OWNER') THEN
6222: IF (p_owner_type_code IS NULL OR p_owner_id IS NULL) THEN

Line 6224: fnd_msg_pub.ADD;

6220: END IF;
6221: ELSIF(l_query_type = 'OWNER') THEN
6222: IF (p_owner_type_code IS NULL OR p_owner_id IS NULL) THEN
6223: fnd_message.set_name('JTF', 'JTF_TK_QRY_NXT_NUL_OWNER');
6224: fnd_msg_pub.ADD;
6225: RAISE fnd_api.g_exc_error;
6226: END IF;
6227: END IF;
6228: END IF;

Line 6235: fnd_msg_pub.ADD;

6231:
6232: -- task id should not be null
6233: IF (p_task_id IS NULL) THEN
6234: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK');
6235: fnd_msg_pub.ADD;
6236: RAISE fnd_api.g_exc_error;
6237: END IF;
6238:
6239: -- check for valid task_id

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

6263: EXCEPTION
6264: WHEN fnd_api.g_exc_error THEN
6265: ROLLBACK TO query_next_task;
6266: x_return_status := fnd_api.g_ret_sts_error;
6267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6268: WHEN fnd_api.g_exc_unexpected_error THEN
6269: ROLLBACK TO query_next_task;
6270: x_return_status := fnd_api.g_ret_sts_unexp_error;
6271: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6268: WHEN fnd_api.g_exc_unexpected_error THEN
6269: ROLLBACK TO query_next_task;
6270: x_return_status := fnd_api.g_ret_sts_unexp_error;
6271: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6272: WHEN OTHERS THEN
6273: ROLLBACK TO query_next_task;
6274: x_return_status := fnd_api.g_ret_sts_unexp_error;
6275:

Line 6276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6272: WHEN OTHERS THEN
6273: ROLLBACK TO query_next_task;
6274: x_return_status := fnd_api.g_ret_sts_unexp_error;
6275:
6276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6277: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6278: END IF;
6279:
6280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 6277: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6273: ROLLBACK TO query_next_task;
6274: x_return_status := fnd_api.g_ret_sts_unexp_error;
6275:
6276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6277: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6278: END IF;
6279:
6280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6281: END query_next_task;

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

6276: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6277: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6278: END IF;
6279:
6280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6281: END query_next_task;
6282:
6283: -----------
6284: ----------- Copy Task

Line 6609: fnd_msg_pub.initialize;

6605: RAISE fnd_api.g_exc_unexpected_error;
6606: END IF;
6607:
6608: IF fnd_api.to_boolean(p_init_msg_list) THEN
6609: fnd_msg_pub.initialize;
6610: END IF;
6611:
6612: IF l_source_task_id IS NULL THEN
6613: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6615: fnd_msg_pub.ADD;

6611:
6612: IF l_source_task_id IS NULL THEN
6613: x_return_status := fnd_api.g_ret_sts_unexp_error;
6614: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_TASK_ID');
6615: fnd_msg_pub.ADD;
6616: RAISE fnd_api.g_exc_unexpected_error;
6617: END IF;
6618:
6619: jtf_task_utl.validate_task(

Line 6637: fnd_msg_pub.ADD;

6633: IF c_task%NOTFOUND THEN
6634: x_return_status := fnd_api.g_ret_sts_unexp_error;
6635: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
6636: fnd_message.set_token('P_TASK_ID', l_source_task_id);
6637: fnd_msg_pub.ADD;
6638: RAISE fnd_api.g_exc_unexpected_error;
6639: CLOSE c_task;
6640: END IF;
6641:

Line 7182: fnd_msg_pub.ADD;

7178: WHEN NO_DATA_FOUND THEN
7179: x_return_status := fnd_api.g_ret_sts_unexp_error;
7180: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7181: fnd_message.set_token('P_TASK_ID', l_source_task_id);
7182: fnd_msg_pub.ADD;
7183: RAISE fnd_api.g_exc_unexpected_error;
7184: WHEN OTHERS THEN
7185: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7186: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

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

7184: WHEN OTHERS THEN
7185: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7186: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7187: x_return_status := fnd_api.g_ret_sts_unexp_error;
7188: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7189: RAISE fnd_api.g_exc_unexpected_error;
7190: END;
7191:
7192: IF l_recurrence_rule_id IS NOT NULL THEN

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

7324: IF fnd_api.to_boolean(p_commit) THEN
7325: COMMIT WORK;
7326: END IF;
7327:
7328: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7329: EXCEPTION
7330: WHEN fnd_api.g_exc_unexpected_error THEN
7331: ROLLBACK TO copy_task;
7332: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7329: EXCEPTION
7330: WHEN fnd_api.g_exc_unexpected_error THEN
7331: ROLLBACK TO copy_task;
7332: x_return_status := fnd_api.g_ret_sts_unexp_error;
7333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7334:
7335: IF c_task%ISOPEN THEN
7336: CLOSE c_task;
7337: END IF;

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

7375: ROLLBACK TO copy_task;
7376: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7377: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7378: x_return_status := fnd_api.g_ret_sts_unexp_error;
7379: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7380:
7381: IF c_task%ISOPEN THEN
7382: CLOSE c_task;
7383: END IF;

Line 7494: fnd_msg_pub.initialize;

7490: RAISE fnd_api.g_exc_unexpected_error;
7491: END IF;
7492:
7493: IF fnd_api.to_boolean(p_init_msg_list) THEN
7494: fnd_msg_pub.initialize;
7495: END IF;
7496:
7497: -- call new version, passing defaults for new functionality
7498: create_task_from_template(

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

7565: IF fnd_api.to_boolean(p_commit) THEN
7566: COMMIT WORK;
7567: END IF;
7568:
7569: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7570: EXCEPTION
7571: WHEN fnd_api.g_exc_unexpected_error THEN
7572: ROLLBACK TO create_task_from_template_pub1;
7573: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7570: EXCEPTION
7571: WHEN fnd_api.g_exc_unexpected_error THEN
7572: ROLLBACK TO create_task_from_template_pub1;
7573: x_return_status := fnd_api.g_ret_sts_unexp_error;
7574: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7575: WHEN OTHERS THEN
7576: ROLLBACK TO create_task_from_template_pub1;
7577: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7578: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

Line 7579: fnd_msg_pub.ADD;

7575: WHEN OTHERS THEN
7576: ROLLBACK TO create_task_from_template_pub1;
7577: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7578: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7579: fnd_msg_pub.ADD;
7580: x_return_status := fnd_api.g_ret_sts_unexp_error;
7581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7582: END;
7583:

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

7577: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7578: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7579: fnd_msg_pub.ADD;
7580: x_return_status := fnd_api.g_ret_sts_unexp_error;
7581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7582: END;
7583:
7584: -- New Version...
7585: PROCEDURE create_task_from_template(

Line 7661: fnd_msg_pub.initialize;

7657: RAISE fnd_api.g_exc_unexpected_error;
7658: END IF;
7659:
7660: IF fnd_api.to_boolean(p_init_msg_list) THEN
7661: fnd_msg_pub.initialize;
7662: END IF;
7663:
7664: l_task_template_group_info.task_template_group_id := p_task_template_group_id;
7665: l_task_template_group_info.owner_type_code := p_owner_type_code;

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

7735: IF fnd_api.to_boolean(p_commit) THEN
7736: COMMIT WORK;
7737: END IF;
7738:
7739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7740: EXCEPTION
7741: WHEN fnd_api.g_exc_unexpected_error THEN
7742: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7743: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7740: EXCEPTION
7741: WHEN fnd_api.g_exc_unexpected_error THEN
7742: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7743: x_return_status := fnd_api.g_ret_sts_unexp_error;
7744: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7745: WHEN OTHERS THEN
7746: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7747: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7748: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

Line 7749: fnd_msg_pub.ADD;

7745: WHEN OTHERS THEN
7746: ROLLBACK TO create_task_from_template_pub; -- Fix Bug 2896377
7747: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7748: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7749: fnd_msg_pub.ADD;
7750: x_return_status := fnd_api.g_ret_sts_unexp_error;
7751: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7752: END;
7753:

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

7747: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7748: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7749: fnd_msg_pub.ADD;
7750: x_return_status := fnd_api.g_ret_sts_unexp_error;
7751: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7752: END;
7753:
7754: PROCEDURE lock_task(
7755: p_api_version IN NUMBER

Line 7777: fnd_msg_pub.initialize;

7773: RAISE fnd_api.g_exc_unexpected_error;
7774: END IF;
7775:
7776: IF fnd_api.to_boolean(p_init_msg_list) THEN
7777: fnd_msg_pub.initialize;
7778: END IF;
7779:
7780: x_return_status := fnd_api.g_ret_sts_success;
7781: jtf_tasks_pkg.lock_row(x_task_id => p_task_id

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

7779:
7780: x_return_status := fnd_api.g_ret_sts_success;
7781: jtf_tasks_pkg.lock_row(x_task_id => p_task_id
7782: , x_object_version_number => p_object_version_number);
7783: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7784: EXCEPTION
7785: WHEN resource_locked THEN
7786: ROLLBACK TO lock_tasks_pub;
7787: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');

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

7786: ROLLBACK TO lock_tasks_pub;
7787: fnd_message.set_name('JTF', 'JTF_TASK_RESOURCE_LOCKED');
7788: fnd_message.set_token('P_LOCKED_RESOURCE', 'Task');
7789: x_return_status := fnd_api.g_ret_sts_unexp_error;
7790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7791: WHEN fnd_api.g_exc_unexpected_error THEN
7792: ROLLBACK TO lock_tasks_pub;
7793: x_return_status := fnd_api.g_ret_sts_unexp_error;
7794: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

7790: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7791: WHEN fnd_api.g_exc_unexpected_error THEN
7792: ROLLBACK TO lock_tasks_pub;
7793: x_return_status := fnd_api.g_ret_sts_unexp_error;
7794: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7795: WHEN OTHERS THEN
7796: ROLLBACK TO lock_tasks_pub;
7797: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7798: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

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

7796: ROLLBACK TO lock_tasks_pub;
7797: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7798: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7799: x_return_status := fnd_api.g_ret_sts_unexp_error;
7800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7801: END;
7802:
7803: ------
7804: ------ This procedure updates the Task record with the source object

Line 7834: fnd_msg_pub.initialize;

7830: RAISE fnd_api.g_exc_unexpected_error;
7831: END IF;
7832:
7833: IF fnd_api.to_boolean(p_init_msg_list) THEN
7834: fnd_msg_pub.initialize;
7835: END IF;
7836:
7837: -------
7838: ------- Check for truncation of source object name

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

7893: IF fnd_api.to_boolean(p_commit) THEN
7894: COMMIT WORK;
7895: END IF;
7896:
7897: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7898: EXCEPTION
7899: WHEN fnd_api.g_exc_unexpected_error THEN
7900: ROLLBACK TO update_task_source;
7901: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

7898: EXCEPTION
7899: WHEN fnd_api.g_exc_unexpected_error THEN
7900: ROLLBACK TO update_task_source;
7901: x_return_status := fnd_api.g_ret_sts_unexp_error;
7902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7903: WHEN OTHERS THEN
7904: ROLLBACK TO update_task_source;
7905: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7906: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);

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

7904: ROLLBACK TO update_task_source;
7905: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
7906: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
7907: x_return_status := fnd_api.g_ret_sts_unexp_error;
7908: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7909: END;
7910:
7911: -- Function to check parameter length and throw error if length not in allowed limit bug # 3182170 Start
7912: FUNCTION check_param_length(

Line 7921: fnd_msg_pub.ADD;

7917: RETURN VARCHAR2 IS
7918: BEGIN
7919: IF LENGTH(p_task_name) > p_length THEN
7920: fnd_message.set_name('JTF', p_message_name);
7921: fnd_msg_pub.ADD;
7922: RAISE fnd_api.g_exc_unexpected_error;
7923: ELSE
7924: RETURN p_task_name;
7925: END IF;

Line 7984: fnd_msg_pub.initialize;

7980: RAISE fnd_api.g_exc_unexpected_error;
7981: END IF;
7982:
7983: IF fnd_api.to_boolean(p_init_msg_list) THEN
7984: fnd_msg_pub.initialize;
7985: END IF;
7986:
7987: OPEN c_task_validate(p_task_id);
7988:

Line 7995: fnd_msg_pub.ADD;

7991:
7992: IF c_task_validate%NOTFOUND THEN
7993: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
7994: fnd_message.set_token('P_TASK_ID', p_task_id);
7995: fnd_msg_pub.ADD;
7996: RAISE fnd_api.g_exc_unexpected_error;
7997: END IF;
7998:
7999: CLOSE c_task_validate;

Line 8003: fnd_msg_pub.ADD;

7999: CLOSE c_task_validate;
8000:
8001: IF (p_task_split_flag IS NULL) THEN
8002: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NULL');
8003: fnd_msg_pub.ADD;
8004: RAISE fnd_api.g_exc_unexpected_error;
8005: END IF;
8006:
8007: IF (task_val.task_split_flag IS NULL) THEN

Line 8009: fnd_msg_pub.ADD;

8005: END IF;
8006:
8007: IF (task_val.task_split_flag IS NULL) THEN
8008: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_EXIST');
8009: fnd_msg_pub.ADD;
8010: RAISE fnd_api.g_exc_unexpected_error;
8011: END IF;
8012:
8013: IF (task_val.task_split_flag <> 'D' OR task_val.task_split_flag <> 'M') THEN

Line 8017: fnd_msg_pub.ADD;

8013: IF (task_val.task_split_flag <> 'D' OR task_val.task_split_flag <> 'M') THEN
8014: fnd_message.set_name('JTF', 'JTF_TASK_SPLIT_FLAG_NOT_VALID');
8015: fnd_message.set_token('P_TASK_ID', p_task_id);
8016: fnd_message.set_token('P_TASK_SPLIT_FLAG', task_val.task_split_flag);
8017: fnd_msg_pub.ADD;
8018: RAISE fnd_api.g_exc_unexpected_error;
8019: END IF;
8020:
8021: IF (task_val.task_split_flag <> p_task_split_flag) THEN

Line 8025: fnd_msg_pub.ADD;

8021: IF (task_val.task_split_flag <> p_task_split_flag) THEN
8022: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_SPLIT_FLAG');
8023: fnd_message.set_token('P_TASK_SPLIT_FLAG', p_task_split_flag);
8024: fnd_message.set_token('P_TASK_ID', p_task_id);
8025: fnd_msg_pub.ADD;
8026: RAISE fnd_api.g_exc_unexpected_error;
8027: END IF;
8028:
8029: IF (p_task_split_flag = 'D') THEN

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

8122: IF fnd_api.to_boolean(p_commit) THEN
8123: COMMIT WORK;
8124: END IF;
8125:
8126: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8127: END IF;
8128: EXCEPTION
8129: WHEN fnd_api.g_exc_unexpected_error THEN
8130: ROLLBACK TO delete_split_tasks_pub;

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

8128: EXCEPTION
8129: WHEN fnd_api.g_exc_unexpected_error THEN
8130: ROLLBACK TO delete_split_tasks_pub;
8131: x_return_status := fnd_api.g_ret_sts_unexp_error;
8132: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8133: WHEN OTHERS THEN
8134: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
8135: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
8136: fnd_msg_pub.ADD;

Line 8136: fnd_msg_pub.ADD;

8132: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8133: WHEN OTHERS THEN
8134: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
8135: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
8136: fnd_msg_pub.ADD;
8137: ROLLBACK TO delete_split_tasks_pub;
8138: x_return_status := fnd_api.g_ret_sts_unexp_error;
8139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8140: END;

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

8135: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
8136: fnd_msg_pub.ADD;
8137: ROLLBACK TO delete_split_tasks_pub;
8138: x_return_status := fnd_api.g_ret_sts_unexp_error;
8139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8140: END;
8141: END;