DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on FND_MSG_PUB

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

1235: EXCEPTION
1236: WHEN fnd_api.g_exc_error THEN
1237: x_return_status := fnd_api.g_ret_sts_error;
1238: ROLLBACK TO next_task_inquiry;
1239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1240: IF (l_debug = 1) THEN
1241: mydebug('Error ! SQL Code : '|| SQLCODE, l_api_name);
1242: END IF;
1243: WHEN fnd_api.g_exc_unexpected_error THEN

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

1242: END IF;
1243: WHEN fnd_api.g_exc_unexpected_error THEN
1244: x_return_status := fnd_api.g_ret_sts_unexp_error;
1245: ROLLBACK TO next_task_inquiry;
1246: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1247: IF (l_debug = 1) THEN
1248: mydebug('Unexpected Error ! SQL Code : '|| SQLCODE, l_api_name);
1249: END IF;
1250: WHEN OTHERS THEN

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

1250: WHEN OTHERS THEN
1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: ROLLBACK TO next_task_inquiry;
1253:
1254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1255: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1256: END IF;
1257:
1258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);

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

1251: x_return_status := fnd_api.g_ret_sts_unexp_error;
1252: ROLLBACK TO next_task_inquiry;
1253:
1254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1255: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1256: END IF;
1257:
1258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1259: IF (l_debug = 1) THEN

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

1254: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1255: fnd_msg_pub.add_exc_msg('WMS_PICKING_PKG', 'GET_NEXT_TASK_INFO');
1256: END IF;
1257:
1258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_mesg_count, p_data => x_error_mesg);
1259: IF (l_debug = 1) THEN
1260: mydebug('Other Error ! SQL Code : '|| SQLCODE, l_api_name);
1261: END IF;
1262: END get_next_task_info;

Line 1949: fnd_msg_pub.ADD;

1945: END IF;
1946:
1947: l_mmtt_rowcnt := 0;
1948: fnd_message.set_name('WMS', 'WMS_INVALID_PICKID');
1949: fnd_msg_pub.ADD;
1950: RAISE fnd_api.g_exc_error;
1951: END;
1952:
1953: IF (l_debug = 1) THEN

Line 1979: fnd_msg_pub.ADD;

1975: mydebug('MANUAL_PICK: Task has been assigned to somebody else', 'MANUAL_PICK');
1976: END IF;
1977:
1978: fnd_message.set_name('WMS', 'WMS_TASK_UNAVAIL');
1979: fnd_msg_pub.ADD;
1980: RAISE fnd_api.g_exc_error;
1981: ELSE
1982: BEGIN --bug#5157839.Start fix
1983: SELECT wdt.status INTO l_status FROM wms_dispatched_tasks wdt

Line 1991: fnd_msg_pub.ADD;

1987: IF (l_debug = 1) THEN
1988: mydebug('MANUAL_PICK: The WDT has status other than 1 or 2 ', 'MANUAL_PICK');
1989: END IF;
1990: fnd_message.set_name('WMS', 'WMS_INVALID_PICKID');
1991: fnd_msg_pub.ADD;
1992: RAISE fnd_api.g_exc_error;
1993: END IF;
1994: EXCEPTION
1995: WHEN NO_DATA_FOUND THEN

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

2219: x_return_status := fnd_api.g_ret_sts_success;
2220: EXCEPTION
2221: WHEN fnd_api.g_exc_error THEN
2222: x_return_status := fnd_api.g_ret_sts_error;
2223: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2224: WHEN OTHERS THEN
2225: x_return_status := fnd_api.g_ret_sts_unexp_error;
2226: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2227: END manual_pick;

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

2222: x_return_status := fnd_api.g_ret_sts_error;
2223: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2224: WHEN OTHERS THEN
2225: x_return_status := fnd_api.g_ret_sts_unexp_error;
2226: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2227: END manual_pick;
2228:
2229:
2230: PROCEDURE get_next_task_in_group

Line 2512: fnd_msg_pub.delete_msg;

2508: mydebug('Need to check if the period is open', l_api_name);
2509: END IF;
2510:
2511: -- Clear the message stack
2512: fnd_msg_pub.delete_msg;
2513:
2514: -- Check if the period is open
2515: -- TODO: Cache this
2516: IF g_period_id IS NULL THEN

Line 2529: fnd_msg_pub.ADD;

2525: mydebug('Period is invalid', l_api_name);
2526: END IF;
2527:
2528: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2529: fnd_msg_pub.ADD;
2530: RAISE fnd_api.g_exc_unexpected_error;
2531: END IF;
2532:
2533: -- Ignore devices if multiple device signon and task methods not in

Line 3088: fnd_msg_pub.ADD;

3084: mydebug('ERROR...This task has been dispatched to some other user.', l_api_name);
3085: END IF;
3086:
3087: fnd_message.set_name('WMS', 'WMS_TASK_LOCKED');
3088: fnd_msg_pub.ADD;
3089: RAISE fnd_api.g_exc_unexpected_error;
3090: END IF;
3091: --Bug#5599049 .Fix ends.
3092:

Line 3303: fnd_msg_pub.ADD;

3299:
3300:
3301: ELSIF x_return_status = 'U' THEN
3302: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
3303: fnd_msg_pub.ADD;
3304: RAISE fnd_api.g_exc_unexpected_error;
3305: ELSIF x_return_status = 'E' THEN
3306: IF (l_debug = 1) THEN
3307: mydebug('Setting status as S', l_api_name);

Line 3359: fnd_msg_pub.ADD;

3355: mydebug('get_next_task_info returned: ' || x_return_status, l_api_name);
3356:
3357: IF x_return_status <> 'S' THEN
3358: fnd_message.set_name('WMS', 'WMS_TD_TDENG_ERROR');
3359: fnd_msg_pub.ADD;
3360: RAISE fnd_api.g_exc_unexpected_error;
3361: END IF;
3362:
3363: l_request_id := NULL;

Line 3535: fnd_msg_pub.ADD;

3531: mydebug('sqlerrm' || SQLERRM, 'split_mmtt_lpn');
3532: mydebug('sqlcode ' || SQLCODE, 'split_mmtt_lpn');
3533: END IF;
3534: --fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
3535: fnd_msg_pub.ADD;
3536: END split_mmtt_lpn;
3537:
3538: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3539: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,

Line 3874: fnd_msg_pub.ADD;

3870: END IF;
3871: x_return_status := 'E';
3872: ROLLBACK TO wms_split_task;
3873: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
3874: fnd_msg_pub.ADD;
3875: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3876: x_return_status := 'E';
3877: IF g_debug = 1 THEN
3878: mydebug( 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM, 'split_task');

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

3871: x_return_status := 'E';
3872: ROLLBACK TO wms_split_task;
3873: fnd_message.set_name('WMS', 'WMS_UNEXPECTED_ERROR');
3874: fnd_msg_pub.ADD;
3875: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3876: x_return_status := 'E';
3877: IF g_debug = 1 THEN
3878: mydebug( 'EXCEPTION BLOCK : Error Code : '|| SQLCODE || 'EXCEPTION BLOCK : Error Message :'||SQLERRM, 'split_task');
3879: END IF;