APPS.INV_LOT_SERIAL_UPGRADE dependencies on FND_API

Line 56: x_return_status := fnd_api.g_ret_sts_success ;

52: END IF;
53:
54: l_lot_count := 0;
55: l_upgrade_count := 0;
56: x_return_status := fnd_api.g_ret_sts_success ;
57:
58: l_previous_item_id := -1;
59: l_previous_org_id := -1;
60: FOR v_lot IN c_lot(p_organization_id) LOOP

Line 140: x_return_status := fnd_api.g_ret_sts_error;

136: WHEN others THEN
137: IF (l_debug = 1) THEN
138: trace('Error in UPGRADE_LOT ');
139: END IF;
140: x_return_status := fnd_api.g_ret_sts_error;
141: END UPGRADE_LOT;
142:
143: /* Private API to upgrade the serial numbers*/
144: PROCEDURE UPGRADE_SERIAL(

Line 180: x_return_status := fnd_api.g_ret_sts_success ;

176: -- || ',' || p_inventory_item_id);
177:
178: l_serial_count := 0;
179: l_upgrade_count := 0;
180: x_return_status := fnd_api.g_ret_sts_success ;
181:
182: l_previous_item_id := -1;
183: l_previous_org_id := -1;
184: FOR v_serial IN c_serial(p_organization_id) LOOP

Line 265: x_return_status := fnd_api.g_ret_sts_error;

261: WHEN others THEN
262: IF (l_debug = 1) THEN
263: trace('Error in UPGRADE_SERIAL ');
264: END IF;
265: x_return_status := fnd_api.g_ret_sts_error;
266: END UPGRADE_SERIAL;
267:
268: /**************************
269: * Public API *

Line 300: x_return_status := fnd_api.g_ret_sts_success ;

296: --trace(' ' || p_lot_serial_option || ',' || p_organization_id
297: -- ||','|| p_inventory_item_id || ',' || p_lot_serial_number
298: -- ||','|| p_attributes.count);
299:
300: x_return_status := fnd_api.g_ret_sts_success ;
301:
302: -- Construct the update statement
303: l_update_stmt := 'UPDATE ';
304: IF p_lot_serial_option = OPTION_LOT THEN

Line 355: RAISE fnd_api.g_exc_error;

351: IF (l_debug = 1) THEN
352: trace(' No rows updated , error in update lot/serial ' ||p_lot_serial_number
353: || ',org:'||p_organization_id ||',item:'||p_inventory_item_id);
354: END IF;
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: -- Close the cursor
359: DBMS_SQL.CLOSE_CURSOR(l_update_cur);

Line 368: x_return_status := fnd_api.g_ret_sts_error;

364: IF (l_debug = 1) THEN
365: trace('Error in update lot/serial '|| p_lot_serial_number
366: || ',org:'||p_organization_id ||',item:'||p_inventory_item_id);
367: END IF;
368: x_return_status := fnd_api.g_ret_sts_error;
369:
370: END UPDATE_LOT_SERIAL_ATTR;
371:
372: /* Upgrade procedure to be called by the concurrent program