DBA Data[Home] [Help]

APPS.WMS_BULK_PICK dependencies on FND_API

Line 59: l_return_status := fnd_api.g_ret_sts_success;

55:
56: BEGIN
57:
58: -- Initialize API return status to success
59: l_return_status := fnd_api.g_ret_sts_success;
60: -- Start API body
61:
62: IF l_debug=1 THEN
63: mydebug('Input parameters:' ||g_newline||

Line 99: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

95: ,p_move_order_header_id => -1 -- -1 to indicate this is come from bulk concurrent program
96: ,p_disable_cartonization => 'Y'
97: ,p_transaction_header_id => 0 -- default
98: ,p_input_for_bulk => l_bulk_input);
99: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
100: ret := fnd_concurrent.set_completion_status('NORMAL', l_msg_data);
101: retcode := 0;
102: ELSE
103: ret := fnd_concurrent.set_completion_status('ERROR', l_msg_data);

Line 112: WHEN fnd_api.g_exc_error THEN

108: -- Standard call to get message count and if count is 1,
109: -- get message info.
110: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO concurrent_bulk_process;
114: l_return_status := fnd_api.g_ret_sts_error;
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN

Line 114: l_return_status := fnd_api.g_ret_sts_error;

110: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO concurrent_bulk_process;
114: l_return_status := fnd_api.g_ret_sts_error;
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN
117: ROLLBACK TO concurrent_bulk_process;
118: l_return_status := fnd_api.g_ret_sts_unexp_error;

Line 116: WHEN fnd_api.g_exc_unexpected_error THEN

112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO concurrent_bulk_process;
114: l_return_status := fnd_api.g_ret_sts_error;
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN
117: ROLLBACK TO concurrent_bulk_process;
118: l_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
120: WHEN OTHERS THEN

Line 118: l_return_status := fnd_api.g_ret_sts_unexp_error;

114: l_return_status := fnd_api.g_ret_sts_error;
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN
117: ROLLBACK TO concurrent_bulk_process;
118: l_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
120: WHEN OTHERS THEN
121: ROLLBACK TO concurrent_bulk_process;
122: l_return_status := fnd_api.g_ret_sts_unexp_error;

Line 122: l_return_status := fnd_api.g_ret_sts_unexp_error;

118: l_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
120: WHEN OTHERS THEN
121: ROLLBACK TO concurrent_bulk_process;
122: l_return_status := fnd_api.g_ret_sts_unexp_error;
123:
124: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
125: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
126: END IF;

Line 1111: x_return_status := fnd_api.g_ret_sts_success;

1107: l_search_sequence NUMBER;
1108: l_temp_id NUMBER;
1109:
1110: BEGIN
1111: x_return_status := fnd_api.g_ret_sts_success;
1112:
1113: IF l_debug = 1 THEN
1114: mydebug('Dispatching Bulk Pick Tasks for TxnHdrID = ' || p_txn_hdr_id || ' : TxnTempID = ' || p_temp_id,l_api_name);
1115: mydebug('p_multiple_pick:'||p_multiple_pick,l_api_name);

Line 1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1604: , x_msg_count => x_msg_count
1605: , x_msg_data => x_msg_data
1606: );
1607:
1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1609: IF l_debug = 1 THEN
1610: mydebug('BULK_PICK: Error occurred while calling cleanup tasK ',l_api_name);
1611: END IF;
1612: RAISE fnd_api.g_exc_error;

Line 1612: RAISE fnd_api.g_exc_error;

1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1609: IF l_debug = 1 THEN
1610: mydebug('BULK_PICK: Error occurred while calling cleanup tasK ',l_api_name);
1611: END IF;
1612: RAISE fnd_api.g_exc_error;
1613: END IF;
1614:
1615:
1616: END IF;

Line 1620: x_return_status := fnd_api.g_ret_sts_unexp_error;

1616: END IF;
1617:
1618: EXCEPTION
1619: WHEN OTHERS THEN
1620: x_return_status := fnd_api.g_ret_sts_unexp_error;
1621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1622:
1623: IF (l_debug = 1) THEN
1624: mydebug('Unexpected Error occurred - ' || SQLERRM,l_api_name);