APPS.GMI_INVENTORY_CLOSE_CONC dependencies on GMI_CLOS_WAREHOUSES

Line 24: gmi_clos_warehouses

20: IS
21:
22: Cursor Get_Whse IS
23: Select whse_code from
24: gmi_clos_warehouses
25: where inventory_close_id = P_sequence
26: order by whse_code;
27:
28: x_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;

Line 73: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for */

69: IF (Get_Whse%NOTFOUND) THEN
70: CLOSE Get_Whse;
71: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'No Warehouse selected for Close');
72: /*BEGIN BUG#2589255 James Bernard */
73: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for */
74: /*whse row being processed */
75: RAISE x_exception;
76: /*END BUG#2589255 */
77: RETURN;

Line 107: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for

103: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
104: X_msg := FND_MESSAGE.GET;
105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
106: /*BEGIN BUG#2589255 James Bernard */
107: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for
108: whse row being processed */
109: RAISE x_exception;
110: /*END BUG#2589255 */
111: RETURN;

Line 147: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for

143: x_start_date,
144: x_end_date);
145: IF (x_close_err = 1) THEN
146: /*BEGIN BUG#2589255 James Bernard */
147: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for
148: whse row being processed */
149: RAISE x_exception;
150: /*END BUG#2589255 */
151: RETURN;

Line 186: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for

182: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
183: X_msg := FND_MESSAGE.GET;
184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
185: /*BEGIN BUG#2589255 James Bernard */
186: /*Raising x_exception as GMI_CLOS_WAREHOUSES table has to be cleaned for
187: whse row being processed */
188: RAISE x_exception;
189: /*END BUG#2589255 */
190: RETURN;

Line 204: DELETE gmi_clos_warehouses

200: x_prev_time := x_cur_time;
201: /***********************************************
202: Clean up database for whse row processed.
203: **********************************************/
204: DELETE gmi_clos_warehouses
205: where inventory_close_id = P_sequence AND
206: whse_code = x_whse_code;
207: IF (SQLCODE <> 0) THEN
208: FND_MESSAGE.SET_NAME('GMI','IC_DELETE_CLOSE_ERROR');

Line 275: DELETE gmi_clos_warehouses

271: WHEN x_exception then
272: /***********************************************
273: Clean up GMI_CLOS_WAREHOUSE for whse row processed.
274: **********************************************/
275: DELETE gmi_clos_warehouses
276: where inventory_close_id = P_sequence AND
277: whse_code = x_whse_code;
278: COMMIT;
279: IF (SQL%ROWCOUNT = 0) THEN

Line 292: DELETE gmi_clos_warehouses

288:
289: /***********************************************
290: Clean up GMI_CLOS_WAREHOUSE for whse row processed.
291: **********************************************/
292: DELETE gmi_clos_warehouses
293: where inventory_close_id = P_sequence AND
294: whse_code = x_whse_code;
295: COMMIT;
296: IF (SQL%ROWCOUNT = 0) THEN

Line 309: DELETE gmi_clos_warehouses

305:
306: /***********************************************
307: Clean up GMI_CLOS_WAREHOUSE for whse row processed.
308: **********************************************/
309: DELETE gmi_clos_warehouses
310: where inventory_close_id = P_sequence AND
311: whse_code = x_whse_code;
312: COMMIT;
313: IF (SQL%ROWCOUNT = 0) THEN