DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on FND_MSG_PUB

Line 1499: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);

1495: EXCEPTION
1496: WHEN fnd_api.g_exc_error THEN
1497: x_return_status := fnd_api.g_ret_sts_error;
1498: ROLLBACK TO next_task_inquiry;
1499: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1500: IF (l_debug = 1) THEN
1501: mydebug('Error ! SQL Code : '|| SQLCODE, l_api_name);
1502: END IF;
1503: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1506: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);

1502: END IF;
1503: WHEN fnd_api.g_exc_unexpected_error THEN
1504: x_return_status := fnd_api.g_ret_sts_unexp_error;
1505: ROLLBACK TO next_task_inquiry;
1506: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1507: IF (l_debug = 1) THEN
1508: mydebug('Unexpected Error ! SQL Code : '|| SQLCODE, l_api_name);
1509: END IF;
1510: WHEN OTHERS THEN

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

1510: WHEN OTHERS THEN
1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512: ROLLBACK TO next_task_inquiry;
1513:
1514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1515: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1516: END IF;
1517:
1518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);

Line 1515: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');

1511: x_return_status := fnd_api.g_ret_sts_unexp_error;
1512: ROLLBACK TO next_task_inquiry;
1513:
1514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1515: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1516: END IF;
1517:
1518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1519: IF (l_debug = 1) THEN

Line 1518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);

1514: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1515: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1516: END IF;
1517:
1518: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1519: IF (l_debug = 1) THEN
1520: mydebug('Other Error ! SQL Code : '|| SQLCODE, l_api_name);
1521: END IF;
1522: END get_next_task_info;

Line 2209: fnd_msg_pub.ADD;

2205: END IF;
2206:
2207: l_mmtt_rowcnt := 0;
2208: fnd_message.set_name('WMS', 'WMS_INVALID_PICKID');
2209: fnd_msg_pub.ADD;
2210: RAISE fnd_api.g_exc_error;
2211: END;
2212:
2213: IF (l_debug = 1) THEN

Line 2239: fnd_msg_pub.ADD;

2235: mydebug('MANUAL_PICK: Task has been assigned to somebody else', 'MANUAL_PICK');
2236: END IF;
2237:
2238: fnd_message.set_name('WMS', 'WMS_TASK_UNAVAIL');
2239: fnd_msg_pub.ADD;
2240: RAISE fnd_api.g_exc_error;
2241: ELSE
2242: BEGIN --bug#5157839.Start fix
2243: SELECT wdt.status INTO l_status FROM wms_dispatched_tasks wdt

Line 2251: fnd_msg_pub.ADD;

2247: IF (l_debug = 1) THEN
2248: mydebug('MANUAL_PICK: The WDT has status other than 1 or 2 ', 'MANUAL_PICK');
2249: END IF;
2250: fnd_message.set_name('WMS', 'WMS_INVALID_PICKID');
2251: fnd_msg_pub.ADD;
2252: RAISE fnd_api.g_exc_error;
2253: END IF;
2254: EXCEPTION
2255: WHEN NO_DATA_FOUND THEN

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

2479: x_return_status := fnd_api.g_ret_sts_success;
2480: EXCEPTION
2481: WHEN fnd_api.g_exc_error THEN
2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2484: WHEN OTHERS THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2487: END manual_pick;

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

2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2484: WHEN OTHERS THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2487: END manual_pick;
2488:
2489:
2490: PROCEDURE get_next_task_in_group

Line 2885: fnd_msg_pub.delete_msg;

2881: mydebug('Need to check if the period is open', l_api_name);
2882: END IF;
2883:
2884: -- Clear the message stack
2885: fnd_msg_pub.delete_msg;
2886:
2887: -- Check if the period is open
2888: -- TODO: Cache this
2889: IF g_period_id IS NULL THEN

Line 2902: fnd_msg_pub.ADD;

2898: mydebug('Period is invalid', l_api_name);
2899: END IF;
2900:
2901: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2902: fnd_msg_pub.ADD;
2903: RAISE fnd_api.g_exc_unexpected_error;
2904: END IF;
2905:
2906: -- Ignore devices if multiple device signon and task methods not in

Line 3464: fnd_msg_pub.ADD;

3460: mydebug('ERROR...This task has been dispatched to some other user.', l_api_name);
3461: END IF;
3462:
3463: fnd_message.set_name('WMS', 'WMS_TASK_LOCKED');
3464: fnd_msg_pub.ADD;
3465: RAISE fnd_api.g_exc_unexpected_error;
3466: END IF;
3467: --Bug#5599049 .Fix ends.
3468:

Line 3718: fnd_msg_pub.ADD;

3714:
3715:
3716: ELSIF x_return_status = 'U' THEN
3717: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
3718: fnd_msg_pub.ADD;
3719: RAISE fnd_api.g_exc_unexpected_error;
3720: ELSIF x_return_status = 'E' THEN
3721: IF (l_debug = 1) THEN
3722: mydebug('Setting status as S', l_api_name);

Line 3787: fnd_msg_pub.ADD;

3783: mydebug('get_next_task_info returned: ' || x_return_status, l_api_name);
3784:
3785: IF x_return_status <> 'S' THEN
3786: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
3787: fnd_msg_pub.ADD;
3788: RAISE fnd_api.g_exc_unexpected_error;
3789: END IF;
3790:
3791: l_request_id := NULL;

Line 3963: fnd_msg_pub.ADD;

3959: mydebug('sqlerrm' || SQLERRM, 'split_mmtt_lpn');
3960: mydebug('sqlcode ' || SQLCODE, 'split_mmtt_lpn');
3961: END IF;
3962: --fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3963: fnd_msg_pub.ADD;
3964: END split_mmtt_lpn;
3965:
3966: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3967: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,

Line 4302: fnd_msg_pub.ADD;

4298: END IF;
4299: x_return_status := 'E';
4300: ROLLBACK TO wms_split_task;
4301: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
4302: fnd_msg_pub.ADD;
4303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4304: x_return_status := 'E';
4305: IF g_debug = 1 THEN
4306: mydebug( 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM, 'split_task');

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

4299: x_return_status := 'E';
4300: ROLLBACK TO wms_split_task;
4301: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
4302: fnd_msg_pub.ADD;
4303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4304: x_return_status := 'E';
4305: IF g_debug = 1 THEN
4306: mydebug( 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM, 'split_task');
4307: END IF;