DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on FND_MSG_PUB

Line 628: fnd_msg_pub.count_and_get(p_count => msg_cnt, p_data => x_message);

624: IF (l_debug = 1) THEN
625: mydebug(' In exception unload_task x_ret' || x_ret_value);
626: END IF;
627:
628: fnd_msg_pub.count_and_get(p_count => msg_cnt, p_data => x_message);
629: END unload_task;
630:
631: PROCEDURE is_task_processed(x_processed OUT NOCOPY VARCHAR2, p_header_id IN NUMBER) IS
632: l_processed VARCHAR2(1) := 'Y';

Line 1808: fnd_msg_pub.count_and_get

1804: x_trolin_val_tbl => l_trolin_val_tbl
1805: );
1806:
1807:
1808: fnd_msg_pub.count_and_get
1809: ( p_count => l_msg_count
1810: , p_data => l_msg_data
1811: );
1812: IF (l_msg_count = 0) THEN

Line 1826: l_msg_data := fnd_msg_pub.get(I,'F');

1822: IF (l_debug = 1) THEN
1823: mydebug('create_mo: Not Successful2');
1824: END IF;
1825: For I in 1..l_msg_count LOOP
1826: l_msg_data := fnd_msg_pub.get(I,'F');
1827: IF (l_debug = 1) THEN
1828: mydebug('create_mo: ' || replace(l_msg_data,fnd_global.local_chr(0),' '));
1829: END IF;
1830: END LOOP;

Line 1836: FND_MSG_PUB.ADD;

1832:
1833:
1834: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1835: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1836: FND_MSG_PUB.ADD;
1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');

Line 1841: FND_MSG_PUB.ADD;

1837: RAISE FND_API.g_exc_unexpected_error;
1838:
1839: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1840: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF;
1844:
1845:

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

2203: WHEN g_qty_not_avail THEN
2204: ROLLBACK TO generate_next_task;
2205: x_return_status := fnd_api.g_ret_sts_error;
2206: x_ret_code := 'QTY_NOT_AVAIL';
2207: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2208: -- IF (x_msg_count = 0) THEN
2209: -- dbms_output.put_line('Successful');
2210: -- ELSIF (x_msg_count = 1) THEN
2211: -- dbms_output.put_line ('Not Successful');

Line 2216: -- x_msg_data := fnd_msg_pub.get(I,'F');

2212: -- dbms_output.put_line (replace(x_msg_data,chr(0),' '));
2213: -- ELSE
2214: -- dbms_output.put_line ('Not Successful2');
2215: -- For I in 1..x_msg_count LOOP
2216: -- x_msg_data := fnd_msg_pub.get(I,'F');
2217: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
2218: -- END LOOP;
2219: -- END IF;
2220:

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

2220:
2221: WHEN fnd_api.g_exc_error THEN
2222: ROLLBACK TO generate_next_task;
2223: x_return_status := fnd_api.g_ret_sts_error;
2224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2225: -- IF (x_msg_count = 0) THEN
2226: -- dbms_output.put_line('Successful');
2227: -- ELSIF (x_msg_count = 1) THEN
2228: -- dbms_output.put_line ('Not Successful');

Line 2233: -- x_msg_data := fnd_msg_pub.get(I,'F');

2229: -- dbms_output.put_line (replace(x_msg_data,chr(0),' '));
2230: -- ELSE
2231: -- dbms_output.put_line ('Not Successful2');
2232: -- For I in 1..x_msg_count LOOP
2233: -- x_msg_data := fnd_msg_pub.get(I,'F');
2234: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
2235: -- END LOOP;
2236: -- END IF;
2237:

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

2238:
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: ROLLBACK TO generate_next_task;
2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2243: WHEN OTHERS THEN
2244: ROLLBACK TO generate_next_task;
2245: x_return_status := fnd_api.g_ret_sts_unexp_error;
2246:

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

2243: WHEN OTHERS THEN
2244: ROLLBACK TO generate_next_task;
2245: x_return_status := fnd_api.g_ret_sts_unexp_error;
2246:
2247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2248: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2249: END IF;
2250:
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2244: ROLLBACK TO generate_next_task;
2245: x_return_status := fnd_api.g_ret_sts_unexp_error;
2246:
2247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2248: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2249: END IF;
2250:
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2252: END generate_next_task;

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

2247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2248: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2249: END IF;
2250:
2251: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2252: END generate_next_task;
2253:
2254: PROCEDURE cancel_task(
2255: x_return_status OUT NOCOPY VARCHAR2

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

2396: COMMIT;
2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2401: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2402: END IF;
2403: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2404: END cancel_task;

Line 2401: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');

2397: EXCEPTION
2398: WHEN OTHERS THEN
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2401: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2402: END IF;
2403: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2404: END cancel_task;
2405:

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

2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2401: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2402: END IF;
2403: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2404: END cancel_task;
2405:
2406: /*****************************************************************/
2407: --This function is called from the currentTasksFListener on pressing

Line 2485: fnd_msg_pub.ADD;

2481: RETURN 'Y';
2482: END;
2483:
2484: fnd_message.set_name('WMS', 'WMS_LPN_MULTIPLE_ALLOC_ERR');
2485: fnd_msg_pub.ADD;
2486: RETURN 'M';
2487: EXCEPTION
2488: WHEN fnd_api.g_exc_error THEN
2489: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');

Line 2490: fnd_msg_pub.ADD;

2486: RETURN 'M';
2487: EXCEPTION
2488: WHEN fnd_api.g_exc_error THEN
2489: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2490: fnd_msg_pub.ADD;
2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN
2493: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2494: fnd_msg_pub.ADD;

Line 2494: fnd_msg_pub.ADD;

2490: fnd_msg_pub.ADD;
2491: RETURN fnd_api.g_ret_sts_error;
2492: WHEN fnd_api.g_exc_unexpected_error THEN
2493: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2494: fnd_msg_pub.ADD;
2495: RETURN fnd_api.g_ret_sts_unexp_error;
2496: WHEN OTHERS THEN
2497: IF (l_debug = 1) THEN
2498: mydebug('Exception occurred in can_unload api' || SQLERRM);

Line 2502: fnd_msg_pub.ADD;

2498: mydebug('Exception occurred in can_unload api' || SQLERRM);
2499: END IF;
2500:
2501: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2502: fnd_msg_pub.ADD;
2503: RETURN fnd_api.g_ret_sts_unexp_error;
2504: END can_unload;
2505:
2506: /* over loaded the procedure can_unload to resolve the JDBC error */