APPS.INV_RMA_SERIAL_PVT dependencies on OE_LOT_SERIAL_NUMBERS

Line 11: -- No serials were found in oe_lot_serial_numbers

7: --Return values for API
8: --1) x_return_status = S, x_errorcode = 0
9: -- Serial numbers were populated in temp table
10: --2) x_return_status = E, x_errorcode = 1
11: -- No serials were found in oe_lot_serial_numbers
12: --3) x_return_status = E, x_errorcode > 100
13: -- There was some problem with the serial numbers entered
14: --4) x_return_status = U
15: -- Unexpected error

Line 58: FROM oe_lot_serial_numbers

54: l_serial_number VARCHAR2(30);
55:
56: CURSOR oe_lot_serials(p_line_id IN NUMBER) IS
57: SELECT lot_number, from_serial_number, to_serial_number
58: FROM oe_lot_serial_numbers
59: WHERE line_id = p_line_id;
60:
61: BEGIN
62:

Line 100: -- use line_id to join to oe_lot_serial_numbers.

96: --Get the line id from oe_order_lines_all
97: --Logic Used
98: --1) Normal Case
99: -- split_from_line_id is null in oe_order_lines_all
100: -- use line_id to join to oe_lot_serial_numbers.
101: --2) Split Case
102: -- split_from_line_id is not null in oe_order_lines_all
103: -- get line_set_id from oe_order_lines_all to join to
104: -- oe_lot_serial_numbers.

Line 104: -- oe_lot_serial_numbers.

100: -- use line_id to join to oe_lot_serial_numbers.
101: --2) Split Case
102: -- split_from_line_id is not null in oe_order_lines_all
103: -- get line_set_id from oe_order_lines_all to join to
104: -- oe_lot_serial_numbers.
105:
106: /* Commented the below code and added the new select statement to get
107: * correct value in l_orig_line_id i.e to get always line_id of parent RMA line
108: * from which subsequent lines got split. For bug 5144099 */

Line 135: --Check if there are rows in the oe_lot_serial_numbers

131: CONNECT BY PRIOR split_from_line_id = line_id;
132:
133: /* End of fix for bug 5144099*/
134:
135: --Check if there are rows in the oe_lot_serial_numbers
136: --table before opening cursor
137: SELECT count(*)
138: INTO l_count
139: FROM oe_lot_serial_numbers

Line 139: FROM oe_lot_serial_numbers

135: --Check if there are rows in the oe_lot_serial_numbers
136: --table before opening cursor
137: SELECT count(*)
138: INTO l_count
139: FROM oe_lot_serial_numbers
140: WHERE line_id = l_orig_line_id;
141:
142: --IF count=0 then set x_errorcode=1
143: --and throw G_EXC_ERROR.