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 4917: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '

4913: /*Added for Bug 3733798*/
4914: req_id := FND_REQUEST.submit_request
4915: ('INV', 'INCTCW', NULL, NULL, FALSE,
4916: to_char(x_header_id1), '4', NULL, NULL);
4917: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
4918: ||to_char(req_id));
4919: fnd_file.put_line(fnd_file.log,'Material Transaction temp_header_id is '
4920: ||to_char(x_header_id1));
4921:

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

4915: ('INV', 'INCTCW', NULL, NULL, FALSE,
4916: to_char(x_header_id1), '4', NULL, NULL);
4917: fnd_file.put_line(fnd_file.log,'Inventory Transaction Worker request_id is '
4918: ||to_char(req_id));
4919: fnd_file.put_line(fnd_file.log,'Material Transaction temp_header_id is '
4920: ||to_char(x_header_id1));
4921:
4922: /* You must COMMIT to submit the request */
4923: COMMIT;

Line 4943: fnd_file.put_line(fnd_file.log,

4939: dev_phase => devphase,
4940: dev_status => devstatus,
4941: message => message);
4942:
4943: fnd_file.put_line(fnd_file.log,
4944: 'Inventory Transaction Worker status is '
4945: ||status);
4946: fnd_file.put_line(fnd_file.log,
4947: 'Inventory Transaction Worker Completion Message: '

Line 4946: fnd_file.put_line(fnd_file.log,

4942:
4943: fnd_file.put_line(fnd_file.log,
4944: 'Inventory Transaction Worker status is '
4945: ||status);
4946: fnd_file.put_line(fnd_file.log,
4947: 'Inventory Transaction Worker Completion Message: '
4948: ||message);
4949:
4950: -- Confirmed that this condition statement is correct.

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

5390: || '; '
5391: || showMessage
5392: ), 1, 2000);
5393:
5394: fnd_file.put_line(fnd_file.log,x_message_buffer);
5395:
5396: End If;
5397: return;
5398:

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

5418:
5419: Begin
5420: --bugfix 2449452. added these debug stmts
5421:
5422: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5424: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5425:
5426: For wie_record in wie_cursor Loop

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

5419: Begin
5420: --bugfix 2449452. added these debug stmts
5421:
5422: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5424: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5425:
5426: For wie_record in wie_cursor Loop
5427:

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

5420: --bugfix 2449452. added these debug stmts
5421:
5422: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5423: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERRORS ENCOUNTERED..');
5424: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------');
5425:
5426: For wie_record in wie_cursor Loop
5427:
5428: If wie_record.message_type = Message_Type_Warning Then

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

5438: ' has error.';
5439:
5440: End If;
5441:
5442: fnd_file.put_line(fnd_file.log, x_error_message);
5443:
5444: x_error_message := substr(
5445: ('('
5446: || wie_record.header_id

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

5447: || ') '
5448: || wie_record.message
5449: ), 1, 2000);
5450:
5451: fnd_file.put_line(fnd_file.log, x_error_message);
5452:
5453: x_error_message := NULL;
5454:
5455: End Loop; -- Cursor Loop

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

5456:
5457: x_error_message := 'End of Log for Request Id: '||
5458: requestId;
5459:
5460: fnd_file.put_line(fnd_file.log, x_error_message);
5461:
5462: End writeToLog;
5463: /*EA#IIIP*/
5464: ------------------------------------------------------------------