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

APPS.JTF_TASKS_PVT dependencies on FND_MSG_PUB

Line 116: fnd_msg_pub.initialize;

112: RAISE fnd_api.g_exc_unexpected_error;
113: END IF;
114:
115: IF fnd_api.to_boolean(p_init_msg_list) THEN
116: fnd_msg_pub.initialize;
117: END IF;
118:
119: -- call new version, passing defaults for new functionality
120: create_task(

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

227: IF fnd_api.to_boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230:
231: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
232: EXCEPTION
233: WHEN fnd_api.g_exc_unexpected_error THEN
234: ROLLBACK TO create_task_pvt2;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 241: fnd_msg_pub.ADD;

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

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

239: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
240: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
241: fnd_msg_pub.ADD;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
244: END;
245:
246: -- new version which has a workflow enhancement
247: PROCEDURE create_task(

Line 352: fnd_msg_pub.initialize;

348: RAISE fnd_api.g_exc_unexpected_error;
349: END IF;
350:
351: IF fnd_api.to_boolean(p_init_msg_list) THEN
352: fnd_msg_pub.initialize;
353: END IF;
354:
355: -- call new version, passing defaults for new functionality
356: create_task(

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

465: IF fnd_api.to_boolean(p_commit) THEN
466: COMMIT WORK;
467: END IF;
468:
469: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
470: EXCEPTION
471: WHEN fnd_api.g_exc_unexpected_error THEN
472: ROLLBACK TO create_task_pvt3;
473: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 479: fnd_msg_pub.ADD;

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

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

477: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
478: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
479: fnd_msg_pub.ADD;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
482: END;
483:
484: -- overloaded version to add p_entity and p_free_busy_type..
485: PROCEDURE create_task(

Line 591: fnd_msg_pub.initialize;

587: RAISE fnd_api.g_exc_unexpected_error;
588: END IF;
589:
590: IF fnd_api.to_boolean(p_init_msg_list) THEN
591: fnd_msg_pub.initialize;
592: END IF;
593:
594: -- call new version, passing defaults for new functionality
595: create_task(

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

702: IF fnd_api.to_boolean(p_commit) THEN
703: COMMIT WORK;
704: END IF;
705:
706: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
707: EXCEPTION
708: WHEN fnd_api.g_exc_unexpected_error THEN
709: ROLLBACK TO create_task_pvt1;
710: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 716: fnd_msg_pub.ADD;

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

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

714: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
716: fnd_msg_pub.ADD;
717: x_return_status := fnd_api.g_ret_sts_unexp_error;
718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
719: END;
720:
721: -- Overloaded version for Simplex Changes..
722: PROCEDURE create_task(

Line 835: fnd_msg_pub.initialize;

831: RAISE fnd_api.g_exc_unexpected_error;
832: END IF;
833:
834: IF fnd_api.to_boolean(p_init_msg_list) THEN
835: fnd_msg_pub.initialize;
836: END IF;
837:
838: -- call new version, passing defaults for new functionality
839: create_task(

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

948: IF fnd_api.to_boolean(p_commit) THEN
949: COMMIT WORK;
950: END IF;
951:
952: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
953: EXCEPTION
954: WHEN fnd_api.g_exc_unexpected_error THEN
955: ROLLBACK TO create_task_pvt4;
956: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 962: fnd_msg_pub.ADD;

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

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

960: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
961: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
962: fnd_msg_pub.ADD;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
965: END;
966:
967: -- Overloaded version for Location Id..
968: PROCEDURE create_task(

Line 1141: fnd_msg_pub.initialize;

1137:
1138: x_return_status := fnd_api.g_ret_sts_success;
1139:
1140: IF fnd_api.to_boolean(p_init_msg_list) THEN
1141: fnd_msg_pub.initialize;
1142: END IF;
1143:
1144: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1145: RAISE fnd_api.g_exc_unexpected_error;

Line 1150: fnd_msg_pub.ADD;

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

Line 1158: fnd_msg_pub.ADD;

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

Line 1166: fnd_msg_pub.ADD;

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

Line 1181: fnd_msg_pub.ADD;

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

Line 1193: fnd_msg_pub.ADD;

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

Line 1641: fnd_msg_pub.ADD;

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

Line 1645: fnd_msg_pub.ADD;

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

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

1682: IF fnd_api.to_boolean(p_commit) THEN
1683: COMMIT WORK;
1684: END IF;
1685:
1686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1687: EXCEPTION
1688: WHEN fnd_api.g_exc_unexpected_error THEN
1689: ROLLBACK TO create_task_pvt;
1690: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 1696: fnd_msg_pub.ADD;

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

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

1694: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1695: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1696: fnd_msg_pub.ADD;
1697: x_return_status := fnd_api.g_ret_sts_unexp_error;
1698: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1699: END;
1700:
1701: -----------------
1702: -----------------

Line 1800: fnd_msg_pub.initialize;

1796: SAVEPOINT update_task_pvt1;
1797: x_return_status := fnd_api.g_ret_sts_success;
1798:
1799: IF fnd_api.to_boolean(p_init_msg_list) THEN
1800: fnd_msg_pub.initialize;
1801: END IF;
1802:
1803: -- Call the new version
1804: update_task(

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

1905: IF fnd_api.to_boolean(p_commit) THEN
1906: COMMIT WORK;
1907: END IF;
1908:
1909: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1910: EXCEPTION
1911: WHEN fnd_api.g_exc_unexpected_error THEN
1912: ROLLBACK TO update_task_pvt1;
1913: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 1919: fnd_msg_pub.ADD;

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

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

1917: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1918: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
1919: fnd_msg_pub.ADD;
1920: x_return_status := fnd_api.g_ret_sts_unexp_error;
1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1922: END;
1923:
1924: -- old version
1925: PROCEDURE update_task(

Line 2023: fnd_msg_pub.initialize;

2019: SAVEPOINT update_task_pvt2;
2020: x_return_status := fnd_api.g_ret_sts_success;
2021:
2022: IF fnd_api.to_boolean(p_init_msg_list) THEN
2023: fnd_msg_pub.initialize;
2024: END IF;
2025:
2026: -- Call the new version
2027: update_task(

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

2128: IF fnd_api.to_boolean(p_commit) THEN
2129: COMMIT WORK;
2130: END IF;
2131:
2132: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2133: EXCEPTION
2134: WHEN fnd_api.g_exc_unexpected_error THEN
2135: ROLLBACK TO update_task_pvt2;
2136: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 2142: fnd_msg_pub.ADD;

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

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

2140: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2141: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2142: fnd_msg_pub.ADD;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2145: END;
2146:
2147: -- New version which has a workflow enhancement (p_enable_workflow, p_abort_workflow)
2148: PROCEDURE update_task(

Line 2247: fnd_msg_pub.initialize;

2243: SAVEPOINT update_task_pvt3;
2244: x_return_status := fnd_api.g_ret_sts_success;
2245:
2246: IF fnd_api.to_boolean(p_init_msg_list) THEN
2247: fnd_msg_pub.initialize;
2248: END IF;
2249:
2250: -- Call the new version
2251: update_task(

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

2352: IF fnd_api.to_boolean(p_commit) THEN
2353: COMMIT WORK;
2354: END IF;
2355:
2356: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2357: EXCEPTION
2358: WHEN fnd_api.g_exc_unexpected_error THEN
2359: ROLLBACK TO update_task_pvt3;
2360: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 2366: fnd_msg_pub.ADD;

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

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

2364: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2365: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2366: fnd_msg_pub.ADD;
2367: x_return_status := fnd_api.g_ret_sts_unexp_error;
2368: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2369: END;
2370:
2371: -- New version which has a workflow enhancement (p_enable_workflow, p_abort_workflow)
2372: PROCEDURE update_task(

Line 2472: fnd_msg_pub.initialize;

2468: SAVEPOINT update_task_pvt4;
2469: x_return_status := fnd_api.g_ret_sts_success;
2470:
2471: IF fnd_api.to_boolean(p_init_msg_list) THEN
2472: fnd_msg_pub.initialize;
2473: END IF;
2474:
2475: -- Call the new version
2476: update_task(

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

2583: IF fnd_api.to_boolean(p_commit) THEN
2584: COMMIT WORK;
2585: END IF;
2586:
2587: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2588: EXCEPTION
2589: WHEN fnd_api.g_exc_unexpected_error THEN
2590: ROLLBACK TO update_task_pvt4;
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 2597: fnd_msg_pub.ADD;

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

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

2595: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2596: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2597: fnd_msg_pub.ADD;
2598: x_return_status := fnd_api.g_ret_sts_unexp_error;
2599: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2600: END;
2601:
2602: -- Simplex Changes..
2603: PROCEDURE update_task(

Line 2708: fnd_msg_pub.initialize;

2704: SAVEPOINT update_task_pvt5;
2705: x_return_status := fnd_api.g_ret_sts_success;
2706:
2707: IF fnd_api.to_boolean(p_init_msg_list) THEN
2708: fnd_msg_pub.initialize;
2709: END IF;
2710:
2711: -- Call the new version
2712: update_task(

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

2819: IF fnd_api.to_boolean(p_commit) THEN
2820: COMMIT WORK;
2821: END IF;
2822:
2823: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2824: EXCEPTION
2825: WHEN fnd_api.g_exc_unexpected_error THEN
2826: ROLLBACK TO update_task_pvt5;
2827: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 2833: fnd_msg_pub.ADD;

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

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

2831: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2832: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
2833: fnd_msg_pub.ADD;
2834: x_return_status := fnd_api.g_ret_sts_unexp_error;
2835: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2836: END;
2837:
2838: -- Location Id..
2839: PROCEDURE update_task(

Line 3338: fnd_msg_pub.initialize;

3334: SAVEPOINT update_task_pvt;
3335: x_return_status := fnd_api.g_ret_sts_success;
3336:
3337: IF fnd_api.to_boolean(p_init_msg_list) THEN
3338: fnd_msg_pub.initialize;
3339: END IF;
3340:
3341: IF p_task_name IS NULL THEN
3342: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');

Line 3343: fnd_msg_pub.ADD;

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

Line 3351: fnd_msg_pub.ADD;

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

Line 3359: fnd_msg_pub.ADD;

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

Line 3369: fnd_msg_pub.ADD;

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

Line 3934: fnd_msg_pub.ADD;

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

Line 3999: fnd_msg_pub.ADD;

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

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

4207: END IF;
4208:
4209: -- Increment the object version number to be returned
4210: p_object_version_number := p_object_version_number + 1;
4211: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4212:
4213: --BES enh 2391065
4214: IF (l_entity = 'TASK') THEN
4215: l_task_rec_type_old.source_object_type_code := l_orig_source_object_type_code;

Line 4232: fnd_msg_pub.ADD;

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

Line 4236: fnd_msg_pub.ADD;

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

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

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

Line 4251: fnd_msg_pub.ADD;

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

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

4249: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4250: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4251: fnd_msg_pub.ADD;
4252: x_return_status := fnd_api.g_ret_sts_unexp_error;
4253: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4254: END; ---- End of private Update Task
4255:
4256: -- Old version
4257: PROCEDURE delete_task(

Line 4274: fnd_msg_pub.initialize;

4270: x_return_status := fnd_api.g_ret_sts_success;
4271:
4272: -- Added by lokumar for bug#6598081
4273: IF fnd_api.to_boolean(p_init_msg_list) THEN
4274: fnd_msg_pub.initialize;
4275: END IF;
4276:
4277: -- Call the new version
4278: delete_task(

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

4297: IF fnd_api.to_boolean(p_commit) THEN
4298: COMMIT WORK;
4299: END IF;
4300:
4301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4302: EXCEPTION
4303: WHEN fnd_api.g_exc_unexpected_error THEN
4304: ROLLBACK TO delete_task_pvt2;
4305: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 4311: fnd_msg_pub.ADD;

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

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

4309: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4310: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4311: fnd_msg_pub.ADD;
4312: x_return_status := fnd_api.g_ret_sts_unexp_error;
4313: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4314: END;
4315:
4316: -- New version
4317: PROCEDURE delete_task(

Line 4518: fnd_msg_pub.initialize;

4514: x_return_status := fnd_api.g_ret_sts_success;
4515:
4516: -- Added by lokumar for bug#6598081
4517: IF fnd_api.to_boolean(p_init_msg_list) THEN
4518: fnd_msg_pub.initialize;
4519: END IF;
4520:
4521: -- ------------------------------------------------------------------------
4522: -- Check that the user has the correct security privilege

Line 4601: fnd_msg_pub.ADD;

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

Line 4800: fnd_msg_pub.ADD;

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

Line 4834: fnd_msg_pub.ADD;

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

Line 4838: fnd_msg_pub.ADD;

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

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

4907: IF fnd_api.to_boolean(p_commit) THEN
4908: COMMIT WORK;
4909: END IF;
4910:
4911: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4912: EXCEPTION
4913: WHEN fnd_api.g_exc_unexpected_error THEN
4914: ROLLBACK TO delete_task_pvt;
4915: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 4921: fnd_msg_pub.ADD;

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

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

4919: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4920: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4921: fnd_msg_pub.ADD;
4922: x_return_status := fnd_api.g_ret_sts_unexp_error;
4923: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4924: END;
4925:
4926: PROCEDURE export_file(
4927: p_path IN VARCHAR2

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

5005: UTL_FILE.fclose(v_file);
5006: END IF;
5007:
5008: x_return_status := fnd_api.g_ret_sts_error;
5009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5010: WHEN fnd_api.g_exc_unexpected_error THEN
5011: IF (UTL_FILE.is_open(v_file)) THEN
5012: UTL_FILE.fclose(v_file);
5013: END IF;

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

5012: UTL_FILE.fclose(v_file);
5013: END IF;
5014:
5015: x_return_status := fnd_api.g_ret_sts_unexp_error;
5016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5017: WHEN OTHERS THEN
5018: IF (UTL_FILE.is_open(v_file)) THEN
5019: UTL_FILE.fclose(v_file);
5020: END IF;

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

5020: END IF;
5021:
5022: x_return_status := fnd_api.g_ret_sts_unexp_error;
5023:
5024: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5025: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5026: END IF;
5027:
5028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5021:
5022: x_return_status := fnd_api.g_ret_sts_unexp_error;
5023:
5024: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5025: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5026: END IF;
5027:
5028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5029: END export_file;

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

5024: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5025: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5026: END IF;
5027:
5028: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5029: END export_file;
5030:
5031: PROCEDURE dump_long_line(txt IN VARCHAR2, v_str IN VARCHAR2) IS
5032: LN INTEGER := LENGTH(v_str);

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

5145: );
5146: EXCEPTION
5147: WHEN fnd_api.g_exc_error THEN
5148: x_return_status := fnd_api.g_ret_sts_error;
5149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5150: WHEN fnd_api.g_exc_unexpected_error THEN
5151: x_return_status := fnd_api.g_ret_sts_unexp_error;
5152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5153: WHEN OTHERS THEN

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

5148: x_return_status := fnd_api.g_ret_sts_error;
5149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5150: WHEN fnd_api.g_exc_unexpected_error THEN
5151: x_return_status := fnd_api.g_ret_sts_unexp_error;
5152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5153: WHEN OTHERS THEN
5154: x_return_status := fnd_api.g_ret_sts_unexp_error;
5155:
5156: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5152: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5153: WHEN OTHERS THEN
5154: x_return_status := fnd_api.g_ret_sts_unexp_error;
5155:
5156: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5157: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5158: END IF;
5159:
5160: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5153: WHEN OTHERS THEN
5154: x_return_status := fnd_api.g_ret_sts_unexp_error;
5155:
5156: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5157: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5158: END IF;
5159:
5160: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5161: END query_task;

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

5156: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5157: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5158: END IF;
5159:
5160: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5161: END query_task;
5162:
5163: PROCEDURE query_task(
5164: p_object_version_number IN NUMBER

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

5791: x_total_returned := x_task_table.COUNT;
5792: EXCEPTION
5793: WHEN fnd_api.g_exc_error THEN
5794: x_return_status := fnd_api.g_ret_sts_error;
5795: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5796: WHEN fnd_api.g_exc_unexpected_error THEN
5797: x_return_status := fnd_api.g_ret_sts_unexp_error;
5798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5799: WHEN OTHERS THEN

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

5794: x_return_status := fnd_api.g_ret_sts_error;
5795: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5796: WHEN fnd_api.g_exc_unexpected_error THEN
5797: x_return_status := fnd_api.g_ret_sts_unexp_error;
5798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5799: WHEN OTHERS THEN
5800: x_return_status := fnd_api.g_ret_sts_unexp_error;
5801:
5802: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5799: WHEN OTHERS THEN
5800: x_return_status := fnd_api.g_ret_sts_unexp_error;
5801:
5802: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5803: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5804: END IF;
5805:
5806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5799: WHEN OTHERS THEN
5800: x_return_status := fnd_api.g_ret_sts_unexp_error;
5801:
5802: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5803: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5804: END IF;
5805:
5806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5807: END query_task;

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

5802: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5803: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5804: END IF;
5805:
5806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5807: END query_task;
5808:
5809: PROCEDURE query_next_task(
5810: p_object_version_number IN NUMBER

Line 5974: fnd_msg_pub.ADD;

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

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

6332: x_total_returned := x_task_table.COUNT;
6333: EXCEPTION
6334: WHEN fnd_api.g_exc_error THEN
6335: x_return_status := fnd_api.g_ret_sts_error;
6336: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6337: WHEN fnd_api.g_exc_unexpected_error THEN
6338: x_return_status := fnd_api.g_ret_sts_unexp_error;
6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: WHEN OTHERS THEN

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

6335: x_return_status := fnd_api.g_ret_sts_error;
6336: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6337: WHEN fnd_api.g_exc_unexpected_error THEN
6338: x_return_status := fnd_api.g_ret_sts_unexp_error;
6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: WHEN OTHERS THEN
6341: x_return_status := fnd_api.g_ret_sts_unexp_error;
6342:
6343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: WHEN OTHERS THEN
6341: x_return_status := fnd_api.g_ret_sts_unexp_error;
6342:
6343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6345: END IF;
6346:
6347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6340: WHEN OTHERS THEN
6341: x_return_status := fnd_api.g_ret_sts_unexp_error;
6342:
6343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6345: END IF;
6346:
6347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6348: END query_next_task;

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

6343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6345: END IF;
6346:
6347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6348: END query_next_task;
6349: END;