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 3353: fnd_msg_pub.initialize;

3349: SAVEPOINT update_task_pvt;
3350: x_return_status := fnd_api.g_ret_sts_success;
3351:
3352: IF fnd_api.to_boolean(p_init_msg_list) THEN
3353: fnd_msg_pub.initialize;
3354: END IF;
3355:
3356: IF p_task_name IS NULL THEN
3357: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_NAME');

Line 3358: fnd_msg_pub.ADD;

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

Line 3366: fnd_msg_pub.ADD;

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

Line 3374: fnd_msg_pub.ADD;

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

Line 3384: fnd_msg_pub.ADD;

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

Line 3971: fnd_msg_pub.ADD;

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

Line 4036: fnd_msg_pub.ADD;

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

Line 4178: fnd_msg_pub.add;

4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
4175: fnd_message.set_token ('RES', l_name );
4176: fnd_message.set_token ('DATE', l_date);
4177:
4178: fnd_msg_pub.add;
4179: x_return_status := fnd_api.g_ret_sts_unexp_error;
4180:
4181: RAISE fnd_api.g_exc_unexpected_error;
4182:

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

4288: END IF;
4289:
4290: -- Increment the object version number to be returned
4291: p_object_version_number := p_object_version_number + 1;
4292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4293:
4294: --BES enh 2391065
4295: IF (l_entity = 'TASK') THEN
4296: l_task_rec_type_old.source_object_type_code := l_orig_source_object_type_code;

Line 4313: fnd_msg_pub.ADD;

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

Line 4317: fnd_msg_pub.ADD;

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

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

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

Line 4332: fnd_msg_pub.ADD;

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

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

4330: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4331: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4332: fnd_msg_pub.ADD;
4333: x_return_status := fnd_api.g_ret_sts_unexp_error;
4334: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4335: END; ---- End of private Update Task
4336:
4337: -- Old version
4338: PROCEDURE delete_task(

Line 4355: fnd_msg_pub.initialize;

4351: x_return_status := fnd_api.g_ret_sts_success;
4352:
4353: -- Added by lokumar for bug#6598081
4354: IF fnd_api.to_boolean(p_init_msg_list) THEN
4355: fnd_msg_pub.initialize;
4356: END IF;
4357:
4358: -- Call the new version
4359: delete_task(

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

4378: IF fnd_api.to_boolean(p_commit) THEN
4379: COMMIT WORK;
4380: END IF;
4381:
4382: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4383: EXCEPTION
4384: WHEN fnd_api.g_exc_unexpected_error THEN
4385: ROLLBACK TO delete_task_pvt2;
4386: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 4392: fnd_msg_pub.ADD;

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

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

4390: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4391: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
4392: fnd_msg_pub.ADD;
4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4395: END;
4396:
4397: -- New version
4398: PROCEDURE delete_task(

Line 4599: fnd_msg_pub.initialize;

4595: x_return_status := fnd_api.g_ret_sts_success;
4596:
4597: -- Added by lokumar for bug#6598081
4598: IF fnd_api.to_boolean(p_init_msg_list) THEN
4599: fnd_msg_pub.initialize;
4600: END IF;
4601:
4602: -- ------------------------------------------------------------------------
4603: -- Check that the user has the correct security privilege

Line 4682: fnd_msg_pub.ADD;

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

Line 4881: fnd_msg_pub.ADD;

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

Line 4915: fnd_msg_pub.ADD;

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

Line 4919: fnd_msg_pub.ADD;

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

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

4988: IF fnd_api.to_boolean(p_commit) THEN
4989: COMMIT WORK;
4990: END IF;
4991:
4992: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4993: EXCEPTION
4994: WHEN fnd_api.g_exc_unexpected_error THEN
4995: ROLLBACK TO delete_task_pvt;
4996: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 5002: fnd_msg_pub.ADD;

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

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

5000: fnd_message.set_name('JTF', 'JTF_TASK_UNKNOWN_ERROR');
5001: fnd_message.set_token('P_TEXT', SQLCODE || SQLERRM);
5002: fnd_msg_pub.ADD;
5003: x_return_status := fnd_api.g_ret_sts_unexp_error;
5004: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5005: END;
5006:
5007: PROCEDURE export_file(
5008: p_path IN VARCHAR2

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

5086: UTL_FILE.fclose(v_file);
5087: END IF;
5088:
5089: x_return_status := fnd_api.g_ret_sts_error;
5090: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5091: WHEN fnd_api.g_exc_unexpected_error THEN
5092: IF (UTL_FILE.is_open(v_file)) THEN
5093: UTL_FILE.fclose(v_file);
5094: END IF;

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

5093: UTL_FILE.fclose(v_file);
5094: END IF;
5095:
5096: x_return_status := fnd_api.g_ret_sts_unexp_error;
5097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5098: WHEN OTHERS THEN
5099: IF (UTL_FILE.is_open(v_file)) THEN
5100: UTL_FILE.fclose(v_file);
5101: END IF;

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

5101: END IF;
5102:
5103: x_return_status := fnd_api.g_ret_sts_unexp_error;
5104:
5105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5107: END IF;
5108:
5109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5102:
5103: x_return_status := fnd_api.g_ret_sts_unexp_error;
5104:
5105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5107: END IF;
5108:
5109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5110: END export_file;

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

5105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5106: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5107: END IF;
5108:
5109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5110: END export_file;
5111:
5112: PROCEDURE dump_long_line(txt IN VARCHAR2, v_str IN VARCHAR2) IS
5113: LN INTEGER := LENGTH(v_str);

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

5226: );
5227: EXCEPTION
5228: WHEN fnd_api.g_exc_error THEN
5229: x_return_status := fnd_api.g_ret_sts_error;
5230: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5231: WHEN fnd_api.g_exc_unexpected_error THEN
5232: x_return_status := fnd_api.g_ret_sts_unexp_error;
5233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5234: WHEN OTHERS THEN

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

5229: x_return_status := fnd_api.g_ret_sts_error;
5230: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5231: WHEN fnd_api.g_exc_unexpected_error THEN
5232: x_return_status := fnd_api.g_ret_sts_unexp_error;
5233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5234: WHEN OTHERS THEN
5235: x_return_status := fnd_api.g_ret_sts_unexp_error;
5236:
5237: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5234: WHEN OTHERS THEN
5235: x_return_status := fnd_api.g_ret_sts_unexp_error;
5236:
5237: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5238: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5239: END IF;
5240:
5241: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5234: WHEN OTHERS THEN
5235: x_return_status := fnd_api.g_ret_sts_unexp_error;
5236:
5237: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5238: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5239: END IF;
5240:
5241: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5242: END query_task;

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

5237: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5238: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5239: END IF;
5240:
5241: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5242: END query_task;
5243:
5244: PROCEDURE query_task(
5245: p_object_version_number IN NUMBER

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

5872: x_total_returned := x_task_table.COUNT;
5873: EXCEPTION
5874: WHEN fnd_api.g_exc_error THEN
5875: x_return_status := fnd_api.g_ret_sts_error;
5876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5877: WHEN fnd_api.g_exc_unexpected_error THEN
5878: x_return_status := fnd_api.g_ret_sts_unexp_error;
5879: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5880: WHEN OTHERS THEN

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

5875: x_return_status := fnd_api.g_ret_sts_error;
5876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5877: WHEN fnd_api.g_exc_unexpected_error THEN
5878: x_return_status := fnd_api.g_ret_sts_unexp_error;
5879: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5880: WHEN OTHERS THEN
5881: x_return_status := fnd_api.g_ret_sts_unexp_error;
5882:
5883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

5879: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5880: WHEN OTHERS THEN
5881: x_return_status := fnd_api.g_ret_sts_unexp_error;
5882:
5883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5884: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5885: END IF;
5886:
5887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5880: WHEN OTHERS THEN
5881: x_return_status := fnd_api.g_ret_sts_unexp_error;
5882:
5883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5884: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5885: END IF;
5886:
5887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5888: END query_task;

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

5883: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5884: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5885: END IF;
5886:
5887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5888: END query_task;
5889:
5890: PROCEDURE query_next_task(
5891: p_object_version_number IN NUMBER

Line 6055: fnd_msg_pub.ADD;

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

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

6413: x_total_returned := x_task_table.COUNT;
6414: EXCEPTION
6415: WHEN fnd_api.g_exc_error THEN
6416: x_return_status := fnd_api.g_ret_sts_error;
6417: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6418: WHEN fnd_api.g_exc_unexpected_error THEN
6419: x_return_status := fnd_api.g_ret_sts_unexp_error;
6420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6421: WHEN OTHERS THEN

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

6416: x_return_status := fnd_api.g_ret_sts_error;
6417: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6418: WHEN fnd_api.g_exc_unexpected_error THEN
6419: x_return_status := fnd_api.g_ret_sts_unexp_error;
6420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6421: WHEN OTHERS THEN
6422: x_return_status := fnd_api.g_ret_sts_unexp_error;
6423:
6424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

6420: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6421: WHEN OTHERS THEN
6422: x_return_status := fnd_api.g_ret_sts_unexp_error;
6423:
6424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6426: END IF;
6427:
6428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

6421: WHEN OTHERS THEN
6422: x_return_status := fnd_api.g_ret_sts_unexp_error;
6423:
6424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6426: END IF;
6427:
6428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6429: END query_next_task;

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

6424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6426: END IF;
6427:
6428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6429: END query_next_task;
6430: END;