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.INV_CREATE_MOVE_ORDER_PVT dependencies on FND_API

Line 47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

43: l_x_trohdr_rec inv_move_order_pub.trohdr_rec_type;
44: l_x_trolin_tbl inv_move_order_pub.trolin_tbl_type;
45: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
46: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(240);
50: msg VARCHAR2(2000);
51: l_header_id NUMBER := fnd_api.g_miss_num;

Line 51: l_header_id NUMBER := fnd_api.g_miss_num;

47: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(240);
50: msg VARCHAR2(2000);
51: l_header_id NUMBER := fnd_api.g_miss_num;
52: l_line_num NUMBER := 0;
53: l_order_count NUMBER := 1;
54: l_approval NUMBER;
55: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 124: l_trohdr_rec.db_flag := fnd_api.g_true;

120: l_trohdr_rec.status_date := SYSDATE;
121: l_trohdr_rec.to_subinventory_code := p_subinv;
122: l_trohdr_rec.move_order_type := inv_globals.g_move_order_replenishment;
123: l_trohdr_rec.transaction_type_id := inv_globals.g_type_transfer_order_subxfr;
124: l_trohdr_rec.db_flag := fnd_api.g_true;
125: l_trohdr_rec.operation := inv_globals.g_opr_create;
126: l_line_num := l_line_num + 1;
127: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
128: l_trolin_tbl(l_order_count).creation_date := SYSDATE;

Line 135: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;

131: l_trolin_tbl(l_order_count).inventory_item_id := p_item_id;
132: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
133: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
134: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
135: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
136: l_trolin_tbl(l_order_count).line_number := l_line_num;
137: l_trolin_tbl(l_order_count).line_status := l_approval;
138: l_trolin_tbl(l_order_count).organization_id := p_organization_id;
139: l_trolin_tbl(l_order_count).quantity := p_quantity;

Line 148: l_trolin_tbl(l_order_count).db_flag := fnd_api.g_true;

144: l_trolin_tbl(l_order_count).secondary_uom := p_secondary_uom_code; -- INVCONV changes
145: l_trolin_tbl(l_order_count).grade_code := p_grade_code; -- INVCONV changes
146: l_trolin_tbl(l_order_count).transaction_type_id := inv_globals.g_type_transfer_order_subxfr;
147:
148: l_trolin_tbl(l_order_count).db_flag := fnd_api.g_true;
149: l_trolin_tbl(l_order_count).operation := inv_globals.g_opr_create;
150:
151: /*Patchset J:Enhancements:Health Care Project*/
152: IF (inv_control.g_current_release_level >= inv_release.g_j_release_level) THEN

Line 183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

179: IF (l_debug = 1) THEN
180: print_debug('Return status from Process Transfer Order is ' || l_return_status, l_module_name, 9);
181: END IF;
182:
183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
185: RAISE fnd_api.g_exc_error;
186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
187: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');

Line 185: RAISE fnd_api.g_exc_error;

181: END IF;
182:
183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
185: RAISE fnd_api.g_exc_error;
186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
187: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
188: RAISE fnd_api.g_exc_error;
189: END IF;

Line 186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

182:
183: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
185: RAISE fnd_api.g_exc_error;
186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
187: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
188: RAISE fnd_api.g_exc_error;
189: END IF;
190:

Line 188: RAISE fnd_api.g_exc_error;

184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
185: RAISE fnd_api.g_exc_error;
186: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
187: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_move_orders');
188: RAISE fnd_api.g_exc_error;
189: END IF;
190:
191: RETURN l_return_status;
192: EXCEPTION

Line 193: WHEN fnd_api.g_exc_error THEN

189: END IF;
190:
191: RETURN l_return_status;
192: EXCEPTION
193: WHEN fnd_api.g_exc_error THEN
194: RAISE fnd_api.g_exc_error;
195: WHEN OTHERS THEN
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_Move_Orders');

Line 194: RAISE fnd_api.g_exc_error;

190:
191: RETURN l_return_status;
192: EXCEPTION
193: WHEN fnd_api.g_exc_error THEN
194: RAISE fnd_api.g_exc_error;
195: WHEN OTHERS THEN
196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_Move_Orders');
198: END IF;

Line 200: RAISE fnd_api.g_exc_unexpected_error;

196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Create_Move_Orders');
198: END IF;
199:
200: RAISE fnd_api.g_exc_unexpected_error;
201: END create_move_orders;
202: END inv_create_move_order_pvt;