eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 967: x_return_status := fnd_api.g_ret_sts_success;

963: , x_return_status OUT NOCOPY VARCHAR2) IS
964:
965: l_api_name VARCHAR2(30) := 'bulk_pick';
966: BEGIN
967: x_return_status := fnd_api.g_ret_sts_success;
968: mydebug('FlexibleLotAlloc: Inside insert mtlt',l_api_name );
969: INSERT INTO mtl_transaction_lots_temp
970: (
971: transaction_temp_id

Line 1135: x_return_status := fnd_api.g_ret_sts_error;

1131: AND mln.organization_id = p_organization_id);
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: x_return_status := fnd_api.g_ret_sts_error;
1136: mydebug(' Insert mtlt returns exception' ,l_api_name);
1137: mydebug ('Others exception while updating From LPN context: ' || SQLCODE,l_api_name);
1138: END insert_mtlt;
1139: --End Added for 14699845 (Flexible Lot Allocation)

Line 1402: x_return_status := fnd_api.g_ret_sts_success;

1398: l_lot_alloc_exist VARCHAR2(1) := 'N'; -- Added for 14699845 (Flexible Lot Allocation)
1399: l_primary_qty NUMBER;
1400:
1401: BEGIN
1402: x_return_status := fnd_api.g_ret_sts_success;
1403:
1404: IF l_debug = 1 THEN
1405: mydebug('Dispatching Bulk Pick Tasks for TxnHdrID = ' || p_txn_hdr_id || ' : TxnTempID = ' || p_temp_id,l_api_name);
1406: mydebug('p_multiple_pick:'||p_multiple_pick,l_api_name);

Line 2241: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2237: , x_msg_count => x_msg_count
2238: , x_msg_data => x_msg_data
2239: );
2240:
2241: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2242: IF l_debug = 1 THEN
2243: mydebug('BULK_PICK: Error occurred while calling cleanup tasK ',l_api_name);
2244: END IF;
2245: RAISE fnd_api.g_exc_error;

Line 2245: RAISE fnd_api.g_exc_error;

2241: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2242: IF l_debug = 1 THEN
2243: mydebug('BULK_PICK: Error occurred while calling cleanup tasK ',l_api_name);
2244: END IF;
2245: RAISE fnd_api.g_exc_error;
2246: END IF;
2247:
2248:
2249: END IF;

Line 2253: x_return_status := fnd_api.g_ret_sts_unexp_error;

2249: END IF;
2250:
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2255:
2256: IF (l_debug = 1) THEN
2257: mydebug('Unexpected Error occurred - ' || SQLERRM,l_api_name);