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.GMI_INVENTORY_CLOSE_CONC dependencies on FND_FILE

Line 49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');

45: x_close_err := 0;
46: /********************************************************************
47: Debugging Information.
48: *******************************************************************/
49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');
50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);

Line 50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);

46: /********************************************************************
47: Debugging Information.
48: *******************************************************************/
49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');
50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);

Line 51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);

47: Debugging Information.
48: *******************************************************************/
49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');
50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);

Line 52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);

48: *******************************************************************/
49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');
50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);

Line 53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);

49: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'INPUT PARAMETERS');
50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);

Line 54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);

50: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'SEQUENCE - '||P_sequence);
51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);
58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);

Line 55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);

51: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'FISCAL YEAR- '||p_fiscal_year);
52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);
58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);
59:

Line 56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);

52: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD - '||p_period);
53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);
58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);
59:
60: /* Debugging statements - Bug 3684980 */

Line 57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);

53: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'PERIOD ID - '||p_period_id);
54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);
58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);
59:
60: /* Debugging statements - Bug 3684980 */
61: x_cur_time := sysdate;

Line 58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);

54: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'START DATE - '||P_start_date);
55: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'END DATE - '||P_end_date);
56: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'OP CODE - '||P_op_code);
57: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'ORGN CODE - '||P_orgn_code);
58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);
59:
60: /* Debugging statements - Bug 3684980 */
61: x_cur_time := sysdate;
62: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Start of the Close process (ver 3)- '||

Line 62: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Start of the Close process (ver 3)- '||

58: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'CLOSE IND - '||P_close_ind);
59:
60: /* Debugging statements - Bug 3684980 */
61: x_cur_time := sysdate;
62: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Start of the Close process (ver 3)- '||
63: to_char(x_cur_time, 'hh24:mi:ss') );
64: x_prev_time := x_cur_time;
65:
66:

Line 71: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'No Warehouse selected for Close');

67: OPEN Get_Whse;
68: FETCH Get_Whse into x_whse_code;
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;

Line 81: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ');

77: RETURN;
78: END IF;
79:
80: LOOP
81: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ');
82: /* Debugging statements - Bug 3684980 */
83: x_cur_time := sysdate;
84: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Warehouse '||x_whse_code || ' - '||
85: to_char(x_cur_time, 'hh24:mi:ss') );

Line 84: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Warehouse '||x_whse_code || ' - '||

80: LOOP
81: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ');
82: /* Debugging statements - Bug 3684980 */
83: x_cur_time := sysdate;
84: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Processing Warehouse '||x_whse_code || ' - '||
85: to_char(x_cur_time, 'hh24:mi:ss') );
86: x_prev_time := x_cur_time;
87:
88: /**********************************************************

Line 97: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );

93: FND_MESSAGE.set_name('GMI', 'ICCAL_DELETE_PERD_MSG');
94: FND_MESSAGE.set_token('WHSE', x_whse_code);
95: X_msg := FND_MESSAGE.GET;
96: x_cur_time := sysdate;
97: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );
98: x_prev_time := x_cur_time;
99:
100: l_iret := GMICCAL.delete_ic_perd_bal(P_fiscal_year, P_period, x_whse_code);
101: IF (l_iret < 0) THEN

Line 105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

101: IF (l_iret < 0) THEN
102: FND_MESSAGE.SET_NAME('GMI','IC_PERD_BAL_DELETE_ERR');
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;

Line 115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||

111: RETURN;
112: END IF;
113: /* Debugging statements - Bug 3684980 */
114: x_cur_time := sysdate;
115: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||
116: to_char(x_cur_time, 'hh24:mi:ss') );
117: x_prev_time := x_cur_time;
118: /***********************************************************
119: Insert into ic_perd_bal for this warehouse.

Line 127: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '||

123: FND_MESSAGE.set_token('WHSE', x_whse_code);
124: X_msg := FND_MESSAGE.GET;
125: /* Debugging statements - Bug 3684980 */
126: x_cur_time := sysdate;
127: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '||
128: to_char(x_cur_time, 'hh24:mi:ss') );
129: x_prev_time := x_cur_time;
130:
131:

Line 158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||

154: FND_MESSAGE.set_name('GMI', 'ICCAL_CREATE_PERD_MSG');
155: FND_MESSAGE.set_token('WHSE', x_whse_code);
156: X_msg := FND_MESSAGE.GET;
157: x_cur_time := sysdate;
158: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||
159: to_char(x_cur_time, 'hh24:mi:ss') );
160: x_prev_time := x_cur_time;
161: /**********************************************************
162: Calculate Costs --BUG#2230683 - removed calculate cost logic.

Line 174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );

170: FND_MESSAGE.set_name('GMI', 'ICCAL_UPDATEWHSE_STS_MSG');
171: FND_MESSAGE.set_token('WHSE', x_whse_code);
172: X_msg := FND_MESSAGE.GET;
173: x_cur_time := sysdate;
174: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );
175: x_prev_time := x_cur_time;
176:
177: l_iret := -1;
178: l_iret := GMICCAL.whse_status_update(x_whse_code, P_fiscal_year,

Line 184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

180: IF (l_iret < 0) THEN
181: FND_MESSAGE.SET_NAME('GMI','IC_WHSE_STATUS_UPDATE_ERR');
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;

Line 198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||

194: FND_MESSAGE.set_name('GMI', 'ICCAL_UPDATEWHSE_STS_MSG');
195: FND_MESSAGE.set_token('WHSE', x_whse_code);
196: X_msg := FND_MESSAGE.GET;
197: x_cur_time := sysdate;
198: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '||
199: to_char(x_cur_time, 'hh24:mi:ss') );
200: x_prev_time := x_cur_time;
201: /***********************************************
202: Clean up database for whse row processed.

Line 211: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

207: IF (SQLCODE <> 0) THEN
208: FND_MESSAGE.SET_NAME('GMI','IC_DELETE_CLOSE_ERROR');
209: FND_MESSAGE.set_token('ERRORCODE', TO_CHAR(SQLCODE));
210: X_msg := FND_MESSAGE.GET;
211: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
212: RETURN;
213: END IF;
214:
215:

Line 233: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );

229: FND_MESSAGE.set_name('GMI', 'ICCAL_UPDATE_PERIOD_MSG');
230: FND_MESSAGE.set_token('WHSE', x_whse_code);
231: X_msg := FND_MESSAGE.GET;
232: x_cur_time := sysdate;
233: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );
234: x_prev_time := x_cur_time;
235:
236: l_iret := -1;
237: l_iret := GMICCAL.period_status_update(P_orgn_code, p_fiscal_year,

Line 244: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

240: IF(l_iret < 0) THEN
241: FND_MESSAGE.SET_NAME('GMI','IC_WHSE_STATUS_UPDATE_ERR');
242: FND_MESSAGE.set_token('ERRNO', TO_CHAR(l_iret));
243: X_msg := FND_MESSAGE.GET;
244: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
245: RETURN;
246: END IF;
247:
248: FND_MESSAGE.set_name('GMI', 'ICCAL_UPDATE_PERIOD_MSG');

Line 252: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );

248: FND_MESSAGE.set_name('GMI', 'ICCAL_UPDATE_PERIOD_MSG');
249: FND_MESSAGE.set_token('WHSE', x_whse_code);
250: /* Debugging statements - Bug 3684980 */
251: x_cur_time := sysdate;
252: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Completed '||X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );
253: x_prev_time := x_cur_time;
254:
255: /***********************************************
256: If all is well, commit and give final message.

Line 264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );

260: FND_MESSAGE.SET_NAME('GMI','ICCAL_CLOSE_SUCCESS_MSG');
261: X_msg := FND_MESSAGE.GET;
262: /* Debugging statements - Bug 3684980 */
263: x_cur_time := sysdate;
264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg || ' - '|| to_char(x_cur_time, 'hh24:mi:ss') );
265: x_prev_time := x_cur_time;
266: RETURN;
267:
268: /*BEGIN BUG#2589255 James Bernard */

Line 283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

279: IF (SQL%ROWCOUNT = 0) THEN
280: FND_MESSAGE.SET_NAME('GMI','IC_DELETE_CLOSE_ERROR');
281: FND_MESSAGE.set_token('ERRORCODE', TO_CHAR(SQLCODE));
282: X_msg := FND_MESSAGE.GET;
283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
284: RETURN;
285: END IF;
286:
287: WHEN fnd_file.utl_file_error THEN

Line 287: WHEN fnd_file.utl_file_error THEN

283: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
284: RETURN;
285: END IF;
286:
287: WHEN fnd_file.utl_file_error THEN
288:
289: /***********************************************
290: Clean up GMI_CLOS_WAREHOUSE for whse row processed.
291: **********************************************/

Line 300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

296: IF (SQL%ROWCOUNT = 0) THEN
297: FND_MESSAGE.SET_NAME('GMI','IC_DELETE_CLOSE_ERROR');
298: FND_MESSAGE.set_token('ERRORCODE', TO_CHAR(SQLCODE));
299: X_msg := FND_MESSAGE.GET;
300: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
301: RETURN;
302: END IF;
303:
304: WHEN others THEN

Line 317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

313: IF (SQL%ROWCOUNT = 0) THEN
314: FND_MESSAGE.SET_NAME('GMI','IC_DELETE_CLOSE_ERROR');
315: FND_MESSAGE.set_token('ERRORCODE', TO_CHAR(SQLCODE));
316: X_msg := FND_MESSAGE.GET;
317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
318: RETURN;
319: END IF;
320:
321: /*END BUG#2589255 */

Line 491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before opening get_loct_onhand cursor - '||

487: COMMIT;
488: EXECUTE IMMEDIATE 'set transaction read only';
489: /* Debugging statements - Bug 3684980 */
490: x_cur_time := sysdate;
491: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before opening get_loct_onhand cursor - '||
492: to_char(x_cur_time, 'hh24:mi:ss') );
493: x_prev_time := x_cur_time;
494:
495: open get_loct_onhand;

Line 499: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After opening get_loct_onhand cursor - '||

495: open get_loct_onhand;
496:
497: /* Debugging statements - Bug 3684980 */
498: x_cur_time := sysdate;
499: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After opening get_loct_onhand cursor - '||
500: to_char(x_cur_time, 'hh24:mi:ss') );
501: x_prev_time := x_cur_time;
502:
503: select sysdate into l_log_end_date from dual;

Line 508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before opening get_trans cursor - '||

504: uwhse_code := UPPER(pwhse_code);
505:
506: /* Debugging statements - Bug 3684980 */
507: x_cur_time := sysdate;
508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before opening get_trans cursor - '||
509: to_char(x_cur_time, 'hh24:mi:ss') );
510: x_prev_time := x_cur_time;
511:
512: open get_trans;

Line 516: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After opening get_trans cursor - '||

512: open get_trans;
513:
514: /* Debugging statements - Bug 3684980 */
515: x_cur_time := sysdate;
516: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After opening get_trans cursor - '||
517: to_char(x_cur_time, 'hh24:mi:ss') );
518: x_prev_time := x_cur_time;
519: COMMIT;
520:

Line 523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before insert into ic_perd_bal - '||

519: COMMIT;
520:
521: /* Debugging statements - Bug 3684980 */
522: x_cur_time := sysdate;
523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before insert into ic_perd_bal - '||
524: to_char(x_cur_time, 'hh24:mi:ss') );
525: x_prev_time := x_cur_time;
526:
527: LOOP

Line 562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After insert into ic_perd_bal - '||

558: END LOOP;
559: CLOSE get_loct_onhand;
560: /* Debugging statements - Bug 3684980 */
561: x_cur_time := sysdate;
562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After insert into ic_perd_bal - '||
563: to_char(x_cur_time, 'hh24:mi:ss') );
564: x_prev_time := x_cur_time;
565:
566: /***********************************************

Line 580: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

576:
577: FND_MESSAGE.set_name('GMI','ICCAL_PERD_MSG');
578: FND_MESSAGE.set_token('WHSE',pwhse_code);
579: X_msg := FND_MESSAGE.GET;
580: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
581:
582: FETCH get_trans INTO
583: l_item_id, l_lot_id, l_whse_code,
584: l_location, l_doc_type, l_line_type,

Line 598: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before Updating ic_perd_bal with transaction quantities - '||

594: l_prev_location := l_location;
595:
596: /* Debugging statements - Bug 3684980 */
597: x_cur_time := sysdate;
598: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' Before Updating ic_perd_bal with transaction quantities - '||
599: to_char(x_cur_time, 'hh24:mi:ss') );
600: x_prev_time := x_cur_time;
601:
602: LOOP

Line 737: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After Updating ic_perd_bal with transaction quantities - '||

733:
734: CLOSE get_trans;
735: /* Debugging statements - Bug 3684980 */
736: x_cur_time := sysdate;
737: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' After Updating ic_perd_bal with transaction quantities - '||
738: to_char(x_cur_time, 'hh24:mi:ss') );
739: x_prev_time := x_cur_time;
740:
741: END IF;

Line 748: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);

744: WHEN OTHERS THEN
745: FND_MESSAGE.SET_NAME('GMI','IC_CLOSE_GENERAL_ERROR');
746: FND_MESSAGE.SET_TOKEN('ERRNO',TO_CHAR(SQLCODE));
747: X_msg := FND_MESSAGE.GET;
748: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
749: X_errmsg := SUBSTR(SQLERRM,1,159);
750: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_errmsg);
751: x_close_err := 1;
752: RETURN;

Line 750: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_errmsg);

746: FND_MESSAGE.SET_TOKEN('ERRNO',TO_CHAR(SQLCODE));
747: X_msg := FND_MESSAGE.GET;
748: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_msg);
749: X_errmsg := SUBSTR(SQLERRM,1,159);
750: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,X_errmsg);
751: x_close_err := 1;
752: RETURN;
753:
754: END inventory_close;