DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on FND_FILE

Line 64: fnd_file.put_line(fnd_file.log, 'Starting Import Inventory Lot Transactions with following parameters.. ');

60: /*BA#IIIP*/
61: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
62: /*EA#IIIP*/
63:
64: fnd_file.put_line(fnd_file.log, 'Starting Import Inventory Lot Transactions with following parameters.. ');
65: fnd_file.put_line(fnd_file.log, 'Group Id : '||p_group_id||
66: ', Header Id : '||p_header_id||
67: ', Mode : '||p_mode);
68: -- 2449452: added if clause

Line 65: fnd_file.put_line(fnd_file.log, 'Group Id : '||p_group_id||

61: g_debug := FND_PROFILE.VALUE('MRP_DEBUG');
62: /*EA#IIIP*/
63:
64: fnd_file.put_line(fnd_file.log, 'Starting Import Inventory Lot Transactions with following parameters.. ');
65: fnd_file.put_line(fnd_file.log, 'Group Id : '||p_group_id||
66: ', Header Id : '||p_header_id||
67: ', Mode : '||p_mode);
68: -- 2449452: added if clause
69: if g_debug = 'Y' then

Line 70: fnd_file.put_line(fnd_file.log, 'Debug ENABLED.');

66: ', Header Id : '||p_header_id||
67: ', Mode : '||p_mode);
68: -- 2449452: added if clause
69: if g_debug = 'Y' then
70: fnd_file.put_line(fnd_file.log, 'Debug ENABLED.');
71: else
72: fnd_file.put_line(fnd_file.log, 'Debug DISABLED.');
73: end if;
74:

Line 72: fnd_file.put_line(fnd_file.log, 'Debug DISABLED.');

68: -- 2449452: added if clause
69: if g_debug = 'Y' then
70: fnd_file.put_line(fnd_file.log, 'Debug ENABLED.');
71: else
72: fnd_file.put_line(fnd_file.log, 'Debug DISABLED.');
73: end if;
74:
75: /*BA#IIIP*/
76:

Line 103: fnd_file.put_line(fnd_file.log,o_err_message);

99: EXCEPTION
100: WHEN wsm_worker_failed THEN
101: CONC_STATUS :=
102: FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',o_err_message);
103: fnd_file.put_line(fnd_file.log,o_err_message);
104:
105: /*BA#IIIP*/
106:
107: writeToLog(requestId => FND_GLOBAL.conc_request_id

Line 232: fnd_file.put_line(fnd_file.log, 'p_group_id IS NULL');

228: --
229: if (p_group_id IS NULL ) then
230:
231: if (g_debug = 'Y') then
232: fnd_file.put_line(fnd_file.log, 'p_group_id IS NULL');
233: end if;
234:
235: open no_grp_id_rows;
236: loop

Line 247: fnd_file.put_line(fnd_file.log, 'Updated group_id to '||l_group_id||

243: RETURNING group_id INTO l_group_id;
244:
245: IF (g_debug = 'Y') then
246: IF sql%found THEN
247: fnd_file.put_line(fnd_file.log, 'Updated group_id to '||l_group_id||
248: ' for header_id:'||l_header_id);
249: ELSE
250: fnd_file.put_line(fnd_file.log, 'Failed to Update group_id for header_id: '||l_header_id);
251: END IF;

Line 250: fnd_file.put_line(fnd_file.log, 'Failed to Update group_id for header_id: '||l_header_id);

246: IF sql%found THEN
247: fnd_file.put_line(fnd_file.log, 'Updated group_id to '||l_group_id||
248: ' for header_id:'||l_header_id);
249: ELSE
250: fnd_file.put_line(fnd_file.log, 'Failed to Update group_id for header_id: '||l_header_id);
251: END IF;
252: END IF;
253:
254: commit;

Line 263: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');

259: end if;
260:
261: FOR txn in txns LOOP
262: IF (g_debug = 'Y') THEN
263: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Header Id : ' || txn.header_Id );
265: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
266: END IF;
267:

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Header Id : ' || txn.header_Id );

260:
261: FOR txn in txns LOOP
262: IF (g_debug = 'Y') THEN
263: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Header Id : ' || txn.header_Id );
265: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
266: END IF;
267:
268: x_continue := TRUE;

Line 265: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');

261: FOR txn in txns LOOP
262: IF (g_debug = 'Y') THEN
263: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing Header Id : ' || txn.header_Id );
265: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------');
266: END IF;
267:
268: x_continue := TRUE;
269:

Line 577: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');

573: IF p_mode = CONCURRENT AND x_success_rows > 0 THEN
574:
575: --bugfix 2449452. added these debug stmts
576: IF (g_debug = 'Y') THEN
577: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Inventory Worker to process records for txn header id '||
579: x_header_id1);
580: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
581: END IF;

Line 578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Inventory Worker to process records for txn header id '||

574:
575: --bugfix 2449452. added these debug stmts
576: IF (g_debug = 'Y') THEN
577: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Inventory Worker to process records for txn header id '||
579: x_header_id1);
580: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
581: END IF;
582:

Line 580: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');

576: IF (g_debug = 'Y') THEN
577: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
578: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling Inventory Worker to process records for txn header id '||
579: x_header_id1);
580: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------------------');
581: END IF;
582:
583: lProcLocation := 150;
584: worker_success := Launch_Worker(x_header_id1, x_message);

Line 590: fnd_file.put_line(fnd_file.log,

586:
587: /*BA#IIIP*/
588:
589: If worker_success THEN
590: fnd_file.put_line(fnd_file.log,
591: 'Inventory Worker returned success.');
592: showProgress(
593: processingMode => p_mode
594: , headerId => -9999

Line 3664: fnd_file.put_line(fnd_file.log,l_err_msg);

3660: l_copy_inv_attr:=FALSE;
3661: else
3662: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3663: l_err_msg:=fnd_message.get;
3664: fnd_file.put_line(fnd_file.log,l_err_msg);
3665: l_copy_inv_attr:=TRUE;
3666: l_copy_from_src:=FALSE;
3667:
3668: end if;

Line 3714: fnd_file.put_line(fnd_file.log,l_err_msg);

3710: l_copy_inv_attr:=FALSE;
3711: else
3712: fnd_message.set_name('WSM', 'WSM_LOT_CONTEXT_DIFF');
3713: l_err_msg:=fnd_message.get;
3714: fnd_file.put_line(fnd_file.log,l_err_msg);
3715: l_copy_inv_attr:=TRUE;
3716: l_copy_from_src:=FALSE;
3717: end if;
3718:

Line 5085: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '

5081: /*Added for Bug 3733798*/
5082: req_id := FND_REQUEST.submit_request
5083: ('INV', 'INCTCW', NULL, NULL, FALSE,
5084: to_char(x_header_id1), '4', NULL, NULL);
5085: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
5086: ||to_char(req_id));
5087: fnd_file.put_line(fnd_file.log,'Material Transaction temp_header_id is '
5088: ||to_char(x_header_id1));
5089:

Line 5087: fnd_file.put_line(fnd_file.log,'Material Transaction temp_header_id is '

5083: ('INV', 'INCTCW', NULL, NULL, FALSE,
5084: to_char(x_header_id1), '4', NULL, NULL);
5085: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
5086: ||to_char(req_id));
5087: fnd_file.put_line(fnd_file.log,'Material Transaction temp_header_id is '
5088: ||to_char(x_header_id1));
5089:
5090: /* You must COMMIT to submit the request */
5091: COMMIT;

Line 5111: fnd_file.put_line(fnd_file.log,

5107: dev_phase => devphase,
5108: dev_status => devstatus,
5109: message => message);
5110:
5111: fnd_file.put_line(fnd_file.log,
5112: 'Inventory Transaction Worker status is '
5113: ||status);
5114: fnd_file.put_line(fnd_file.log,
5115: 'Inventory Transaction Worker Completion Message: '

Line 5114: fnd_file.put_line(fnd_file.log,

5110:
5111: fnd_file.put_line(fnd_file.log,
5112: 'Inventory Transaction Worker status is '
5113: ||status);
5114: fnd_file.put_line(fnd_file.log,
5115: 'Inventory Transaction Worker Completion Message: '
5116: ||message);
5117:
5118: -- Confirmed that this condition statement is correct.

Line 5562: fnd_file.put_line(fnd_file.log,x_message_buffer);

5558: || '; '
5559: || showMessage
5560: ), 1, 2000);
5561:
5562: fnd_file.put_line(fnd_file.log,x_message_buffer);
5563:
5564: End If;
5565: return;
5566:

Line 5590: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');

5586:
5587: Begin
5588: --bugfix 2449452. added these debug stmts
5589:
5590: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5592: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5593:
5594: For wie_record in wie_cursor Loop

Line 5591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');

5587: Begin
5588: --bugfix 2449452. added these debug stmts
5589:
5590: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5592: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5593:
5594: For wie_record in wie_cursor Loop
5595:

Line 5592: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');

5588: --bugfix 2449452. added these debug stmts
5589:
5590: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5591: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5592: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5593:
5594: For wie_record in wie_cursor Loop
5595:
5596: If wie_record.message_type = Message_Type_Warning Then

Line 5610: fnd_file.put_line(fnd_file.log, x_error_message);

5606: ' has error.';
5607:
5608: End If;
5609:
5610: fnd_file.put_line(fnd_file.log, x_error_message);
5611:
5612: x_error_message := substr(
5613: ('('
5614: || wie_record.header_id

Line 5619: fnd_file.put_line(fnd_file.log, x_error_message);

5615: || ') '
5616: || wie_record.message
5617: ), 1, 2000);
5618:
5619: fnd_file.put_line(fnd_file.log, x_error_message);
5620:
5621: x_error_message := NULL;
5622:
5623: End Loop; -- Cursor Loop

Line 5628: fnd_file.put_line(fnd_file.log, x_error_message);

5624:
5625: x_error_message := 'End of Log for Request Id: '||
5626: requestId;
5627:
5628: fnd_file.put_line(fnd_file.log, x_error_message);
5629:
5630: End writeToLog;
5631: /*EA#IIIP*/
5632: ------------------------------------------------------------------