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 1823: fnd_msg_pub.count_and_get

1819: x_trolin_val_tbl => l_trolin_val_tbl
1820: );
1821:
1822:
1823: fnd_msg_pub.count_and_get
1824: ( p_count => l_msg_count
1825: , p_data => l_msg_data
1826: );
1827: IF (l_msg_count = 0) THEN

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

1837: IF (l_debug = 1) THEN
1838: mydebug('create_mo: Not Successful2');
1839: END IF;
1840: For I in 1..l_msg_count LOOP
1841: l_msg_data := fnd_msg_pub.get(I,'F');
1842: IF (l_debug = 1) THEN
1843: mydebug('create_mo: ' || replace(l_msg_data,fnd_global.local_chr(0),' '));
1844: END IF;
1845: END LOOP;

Line 1851: FND_MSG_PUB.ADD;

1847:
1848:
1849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1850: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR' );
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.g_exc_unexpected_error;
1853:
1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1855: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');

Line 1856: FND_MSG_PUB.ADD;

1852: RAISE FND_API.g_exc_unexpected_error;
1853:
1854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1855: FND_MESSAGE.SET_NAME('WMS','WMS_TD_MO_ERROR');
1856: FND_MSG_PUB.ADD;
1857: RAISE FND_API.G_EXC_ERROR;
1858: END IF;
1859:
1860:

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

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

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

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

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

2235:
2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO generate_next_task;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: -- IF (x_msg_count = 0) THEN
2241: -- dbms_output.put_line('Successful');
2242: -- ELSIF (x_msg_count = 1) THEN
2243: -- dbms_output.put_line ('Not Successful');

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

2244: -- dbms_output.put_line (replace(x_msg_data,chr(0),' '));
2245: -- ELSE
2246: -- dbms_output.put_line ('Not Successful2');
2247: -- For I in 1..x_msg_count LOOP
2248: -- x_msg_data := fnd_msg_pub.get(I,'F');
2249: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
2250: -- END LOOP;
2251: -- END IF;
2252:

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

2253:
2254: WHEN fnd_api.g_exc_unexpected_error THEN
2255: ROLLBACK TO generate_next_task;
2256: x_return_status := fnd_api.g_ret_sts_unexp_error;
2257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2258: WHEN OTHERS THEN
2259: ROLLBACK TO generate_next_task;
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:

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

2258: WHEN OTHERS THEN
2259: ROLLBACK TO generate_next_task;
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2262: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2264: END IF;
2265:
2266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2259: ROLLBACK TO generate_next_task;
2260: x_return_status := fnd_api.g_ret_sts_unexp_error;
2261:
2262: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2264: END IF;
2265:
2266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2267: END generate_next_task;

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

2262: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2263: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2264: END IF;
2265:
2266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2267: END generate_next_task;
2268:
2269: PROCEDURE cancel_task(
2270: x_return_status OUT NOCOPY VARCHAR2

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

2411: COMMIT;
2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2416: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2417: END IF;
2418: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2419: END cancel_task;

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

2412: EXCEPTION
2413: WHEN OTHERS THEN
2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2416: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2417: END IF;
2418: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2419: END cancel_task;
2420:

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

2414: x_return_status := fnd_api.g_ret_sts_unexp_error;
2415: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2416: fnd_msg_pub.add_exc_msg(g_pkg_name, 'CANCEL_TASK');
2417: END IF;
2418: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2419: END cancel_task;
2420:
2421: /*****************************************************************/
2422: --This function is called from the currentTasksFListener on pressing

Line 2500: fnd_msg_pub.ADD;

2496: RETURN 'Y';
2497: END;
2498:
2499: fnd_message.set_name('WMS', 'WMS_LPN_MULTIPLE_ALLOC_ERR');
2500: fnd_msg_pub.ADD;
2501: RETURN 'M';
2502: EXCEPTION
2503: WHEN fnd_api.g_exc_error THEN
2504: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');

Line 2505: fnd_msg_pub.ADD;

2501: RETURN 'M';
2502: EXCEPTION
2503: WHEN fnd_api.g_exc_error THEN
2504: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2505: fnd_msg_pub.ADD;
2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN
2508: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2509: fnd_msg_pub.ADD;

Line 2509: fnd_msg_pub.ADD;

2505: fnd_msg_pub.ADD;
2506: RETURN fnd_api.g_ret_sts_error;
2507: WHEN fnd_api.g_exc_unexpected_error THEN
2508: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2509: fnd_msg_pub.ADD;
2510: RETURN fnd_api.g_ret_sts_unexp_error;
2511: WHEN OTHERS THEN
2512: IF (l_debug = 1) THEN
2513: mydebug('Exception occurred in can_unload api' || SQLERRM);

Line 2517: fnd_msg_pub.ADD;

2513: mydebug('Exception occurred in can_unload api' || SQLERRM);
2514: END IF;
2515:
2516: fnd_message.set_name('WMS', 'WMS_CAN_UNLOAD_ERROR');
2517: fnd_msg_pub.ADD;
2518: RETURN fnd_api.g_ret_sts_unexp_error;
2519: END can_unload;
2520:
2521: /* over loaded the procedure can_unload to resolve the JDBC error */