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

Line 101: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in parent CREATE_JOBS.');

97: P_BATCH_ID);
98:
99: EXCEPTION
100: WHEN OTHERS THEN
101: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in parent CREATE_JOBS.');
102: RETCODE := 1;
103:
104: END CREATE_JOBS;
105:

Line 175: -- fnd_file.log('AUDSID of current session: ' || l_audsid);

171: -- Initialize API return status to success
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: select userenv('SESSIONID') into l_audsid from dual;
175: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
176:
177: fnd_message.set_name('FND', 'CONC-PARAMETERS');
178: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);
179:

Line 178: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);

174: select userenv('SESSIONID') into l_audsid from dual;
175: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
176:
177: fnd_message.set_name('FND', 'CONC-PARAMETERS');
178: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);
179:
180: IF (fnd_profile.value('MRP_DEBUG') = 'Y') THEN
181: DEBUG_FLAG := TRUE;
182: ELSE

Line 186: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'

182: ELSE
183: DEBUG_FLAG := FALSE;
184: END IF;
185:
186: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
187: ||wip_constants.trace_logging);
188: if (l_logLevel <= wip_constants.trace_logging) then
189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);

Line 189: fnd_file.put_line(fnd_file.log, 'Logging......');

185:
186: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
187: ||wip_constants.trace_logging);
188: if (l_logLevel <= wip_constants.trace_logging) then
189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);

Line 190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);

186: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
187: ||wip_constants.trace_logging);
188: if (l_logLevel <= wip_constants.trace_logging) then
189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);

Line 191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);

187: ||wip_constants.trace_logging);
188: if (l_logLevel <= wip_constants.trace_logging) then
189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);

Line 192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);

188: if (l_logLevel <= wip_constants.trace_logging) then
189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);

Line 193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);

189: fnd_file.put_line(fnd_file.log, 'Logging......');
190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);
197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);

Line 194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);

190: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);
197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);
198:

Line 195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);

191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);
192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);
197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);
198:
199: l_params(1).paramName := 'P_ORDER_NUMBER ';

Line 196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);

192: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || P_ORG_ID);
193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);
197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);
198:
199: l_params(1).paramName := 'P_ORDER_NUMBER ';
200: l_params(1).paramValue := P_ORDER_NUMBER ;

Line 197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);

193: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || P_LOAD_TYPE);
194: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || P_CLASS_CODE);
195: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || P_STATUS_TYPE);
196: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || P_CREATE_FLOW_SCHEDULES);
197: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || P_ORDER_LINE_ID);
198:
199: l_params(1).paramName := 'P_ORDER_NUMBER ';
200: l_params(1).paramValue := P_ORDER_NUMBER ;
201: l_params(2).paramName := 'P_DUMMY_FIELD ';

Line 233: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);

229: end if;
230:
231:
232: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
233: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
234: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
235: fnd_file.get_names(log_file, output_file);
236:
237: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);

Line 234: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);

230:
231:
232: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
233: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
234: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
235: fnd_file.get_names(log_file, output_file);
236:
237: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
238: if (l_logLevel <= wip_constants.full_logging) then

Line 235: fnd_file.get_names(log_file, output_file);

231:
232: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
233: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
234: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
235: fnd_file.get_names(log_file, output_file);
236:
237: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
238: if (l_logLevel <= wip_constants.full_logging) then
239: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);

Line 253: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators

249: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
250: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
251: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);
252:
253: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators
254: end if;
255:
256: -- Standard call to check for call compatibility.
257: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');

352: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
353: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
354: end if;
355:
356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');
357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);

Line 357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);

353: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
354: end if;
355:
356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');
357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);

Line 358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);

354: end if;
355:
356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');
357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);

Line 359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);

355:
356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');
357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);

Line 360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);

356: fnd_file.put_line(which => fnd_file.log, buff => 'After checks...........');
357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);

Line 361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);

357: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:org_id = '|| l_org_id);
358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);
365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);

Line 362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);

358: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:offset_days = '|| l_offset_days);
359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);
365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);
366:

Line 363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);

359: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:load_type = ' || l_load_type);
360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);
365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);
366:
367:

Line 364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);

360: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:class_code = ' || P_class_code);
361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);
365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);
366:
367:
368: /*--------------------------------------------------------+

Line 365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);

361: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:status_type = '|| l_status_type);
362: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:failed_req_id = '|| l_failed_req_id);
363: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_number = ' || l_order_number);
364: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:order_line_id = '|| l_order_line_id);
365: fnd_file.put_line(which => fnd_file.log, buff => 'Dbg:create_flow_schedules = '|| l_create_flow_schedules);
366:
367:
368: /*--------------------------------------------------------+
369: | Call LOAD_ORDERS, to load orders and do all the work. |

Line 659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');

655:
656: wip_logger.log('Inside Load_Orders.....', l_returnStatus);
657:
658: --Flow ER 14595064
659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');
660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);

Line 660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');

656: wip_logger.log('Inside Load_Orders.....', l_returnStatus);
657:
658: --Flow ER 14595064
659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');
660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);

Line 661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);

657:
658: --Flow ER 14595064
659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');
660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);

Line 662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);

658: --Flow ER 14595064
659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');
660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);

Line 663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);

659: fnd_file.put_line(which => fnd_file.log, buff => 'Inside Load_Orders');
660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);

Line 664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);

660: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);
668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);

Line 665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);

661: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || P_ORDER_NUMBER);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);
668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);
669:

Line 666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);

662: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || p_OFFSET_DAYS);
663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);
668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);
669:
670: /*---------------------------------------------------------------+

Line 667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);

663: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || p_ORG_ID);
664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);
668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);
669:
670: /*---------------------------------------------------------------+
671: | Print out values in argument stucture if in debug mode |

Line 668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);

664: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || p_LOAD_TYPE);
665: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || p_CLASS_CODE);
666: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || p_status_type);
667: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || p_create_flow_schedules);
668: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || p_order_line_id);
669:
670: /*---------------------------------------------------------------+
671: | Print out values in argument stucture if in debug mode |
672: +---------------------------------------------------------------+*/

Line 741: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');

737: l_create_flow_schedules := p_create_flow_schedules;
738:
739: wip_logger.log('Before CTO, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
740:
741: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');
742: --Flow ER 14595064
743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);

Line 743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');

739: wip_logger.log('Before CTO, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
740:
741: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');
742: --Flow ER 14595064
743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);

Line 744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);

740:
741: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');
742: --Flow ER 14595064
743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);

Line 745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);

741: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');
742: --Flow ER 14595064
743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);

Line 746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);

742: --Flow ER 14595064
743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);

Line 747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);

743: fnd_file.put_line(which => fnd_file.log, buff => 'Passing Parameters:');
744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);
751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);

Line 748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);

744: fnd_file.put_line(which => fnd_file.log, buff => 'Order Number: ' || l_order_number);
745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);
751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);
752:

Line 749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);

745: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || l_offset_days);
746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);
751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);
752:
753:

Line 750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);

746: fnd_file.put_line(which => fnd_file.log, buff => 'Organization: ' || l_org_id);
747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);
751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);
752:
753:
754: l_status := CTO_WIP_WRAPPER.get_order_lines(

Line 751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);

747: fnd_file.put_line(which => fnd_file.log, buff => 'Load Type: ' || l_load_type);
748: fnd_file.put_line(which => fnd_file.log, buff => 'Class Code: ' || l_class_code);
749: fnd_file.put_line(which => fnd_file.log, buff => 'Status Type: ' || l_status_type);
750: fnd_file.put_line(which => fnd_file.log, buff => 'Create Flow Schedules: ' || l_create_flow_schedules);
751: fnd_file.put_line(which => fnd_file.log, buff => 'Order Line Number: ' || l_order_line_id);
752:
753:
754: l_status := CTO_WIP_WRAPPER.get_order_lines(
755: l_org_id,

Line 774: fnd_file.put_line(which => fnd_file.log, buff => 'Return status from CTO_WIP_WRAPPER.get_order_lines:'|| l_status);

770: l_wip_group_id,
771: l_message_name,
772: l_message_text);
773:
774: fnd_file.put_line(which => fnd_file.log, buff => 'Return status from CTO_WIP_WRAPPER.get_order_lines:'|| l_status);
775: fnd_file.put_line(which => fnd_file.log, buff => 'Group_Id from CTO_WIP_WRAPPER.get_order_lines: '|| l_wip_group_id);
776:
777: --p_wei_group_id := l_wip_group_id;
778: --p_orders_to_load := l_orders_loaded; /* order lines */

Line 775: fnd_file.put_line(which => fnd_file.log, buff => 'Group_Id from CTO_WIP_WRAPPER.get_order_lines: '|| l_wip_group_id);

771: l_message_name,
772: l_message_text);
773:
774: fnd_file.put_line(which => fnd_file.log, buff => 'Return status from CTO_WIP_WRAPPER.get_order_lines:'|| l_status);
775: fnd_file.put_line(which => fnd_file.log, buff => 'Group_Id from CTO_WIP_WRAPPER.get_order_lines: '|| l_wip_group_id);
776:
777: --p_wei_group_id := l_wip_group_id;
778: --p_orders_to_load := l_orders_loaded; /* order lines */
779: L_orders_in_interface := l_orders_loaded;

Line 796: fnd_file.put_line(which => fnd_file.log, buff => 'L_orders_loaded=> '|| l_orders_loaded);

792: else
793: if (L_orders_loaded = 0) then
794: --start bugfix 4865485
795: p_all_success_ptr := -1;
796: fnd_file.put_line(which => fnd_file.log, buff => 'L_orders_loaded=> '|| l_orders_loaded);
797: RETCODE := 1;--for warning
798: RETURN false;
799: --end bugfix 4865485
800: null; --goto done;

Line 811: fnd_file.put_line(which => fnd_file.log, buff => 'Calling wip_massload_pub.massLoadJobs with group Id: '|| l_wip_group_id);

807: | jobs for records loaded into the interface table. |
808: | |
809: | Calling MASSLOAD PL/SQL Routine |
810: +---------------------------------------------------------+*/
811: fnd_file.put_line(which => fnd_file.log, buff => 'Calling wip_massload_pub.massLoadJobs with group Id: '|| l_wip_group_id);
812:
813: wip_massload_pub.massLoadJobs(
814: p_groupID => l_wip_group_id,
815: p_validationLevel => 2,

Line 820: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');

816: p_commitFlag => 1, --commit in Massload
817: x_returnStatus => retCode,
818: x_errorMsg => errBuf);
819:
820: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
821:
822: IF (retCode <> fnd_api.g_ret_sts_success) THEN
823: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');
824:

Line 823: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');

819:
820: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
821:
822: IF (retCode <> fnd_api.g_ret_sts_success) THEN
823: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');
824:
825: if (l_logLevel <= wip_constants.full_logging) then
826: wip_logger.log( 'Dbg:Failed in wip_massload_pub.massLoadJobs', l_returnStatus);
827: END IF;

Line 834: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs returned with status retCode:'||retCode);

830: -- are created for jobs created with warnings.In case when the status
831: -- returned is error, the reservation api will not pick the record to
832: -- create reservation.pdube
833: -- APP_EXCEPTION.RAISE_EXCEPTION;
834: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs returned with status retCode:'||retCode);
835:
836: --Begin Bugfix 11818437
837: --Check if there are any records that got completed either successfully or in warning
838: begin

Line 856: fnd_file.put_line(which => fnd_file.log, buff => 'Some work orders got created. Setting the return code to Warning.');

852: end;
853:
854: if l_line_count = 1 then
855: if DEBUG_FLAG then
856: fnd_file.put_line(which => fnd_file.log, buff => 'Some work orders got created. Setting the return code to Warning.');
857: end if;
858: retcode := 1;
859: elsif l_line_count = 0 then
860: --Nothing created a job

Line 862: fnd_file.put_line(which => fnd_file.log, buff => 'No work orders were created. Raising the exception.');

858: retcode := 1;
859: elsif l_line_count = 0 then
860: --Nothing created a job
861: if DEBUG_FLAG then
862: fnd_file.put_line(which => fnd_file.log, buff => 'No work orders were created. Raising the exception.');
863: end if;
864: APP_EXCEPTION.RAISE_EXCEPTION;
865: end if;
866: --End Bugfix 11818437

Line 870: fnd_file.put_line(which => fnd_file.log, buff => 'Returned successfully from wip_massload_pub.massLoadJobs.');

866: --End Bugfix 11818437
867:
868: END IF;
869:
870: fnd_file.put_line(which => fnd_file.log, buff => 'Returned successfully from wip_massload_pub.massLoadJobs.');
871:
872: END IF; /* end of logic skipped when failed_req_id <> -1 */
873:
874: /*================================================================+

Line 980: fnd_file.new_line(FND_FILE.LOG);

976: wip_logger.log('P_group_id='||l_wip_group_id
977: ||'; P_qty_precision='||precision_profile, l_returnStatus);
978: END IF;
979:
980: fnd_file.new_line(FND_FILE.LOG);
981: fnd_file.get_names(log_file, output_file);
982:
983: wip_logger.log('Before Report Submit, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
984:

Line 981: fnd_file.get_names(log_file, output_file);

977: ||'; P_qty_precision='||precision_profile, l_returnStatus);
978: END IF;
979:
980: fnd_file.new_line(FND_FILE.LOG);
981: fnd_file.get_names(log_file, output_file);
982:
983: wip_logger.log('Before Report Submit, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
984:
985: --Since context has been changed in OE_Order_Context_GRP.Set_Created_By_Context

Line 993: fnd_file.put_line(which => fnd_file.log, buff => 'Calling WIPDJATO Report with group id:'|| l_wip_group_id||' and precision_profile:'||precision_profile);

989: ,resp_id => l_resp_id
990: ,resp_appl_id => l_resp_appl_id);
991: wip_logger.log('Before Report, After context setup; Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
992:
993: fnd_file.put_line(which => fnd_file.log, buff => 'Calling WIPDJATO Report with group id:'|| l_wip_group_id||' and precision_profile:'||precision_profile);
994:
995: report_status :=
996: FND_REQUEST.SUBMIT_REQUEST('WIP','WIPDJATO',
997: '',

Line 1023: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);

1019: if(report_status = 0 ) then
1020:
1021: wip_logger.log(errbuf, l_returnStatus);
1022:
1023: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
1024: wip_logger.log('==========================================', l_returnStatus);
1025: if (l_logLevel <= wip_constants.full_logging) then
1026: wip_logger.log('Could not execute report.', l_returnStatus);
1027: END IF;

Line 1036: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assemble to Order Massload Report return code : '||report_retcode);

1032:
1033: /* wait for report to finish */
1034: WAIT_CONC_PROGRAM(report_status,ERRBUF,report_retcode);
1035:
1036: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assemble to Order Massload Report return code : '||report_retcode);
1037: /* report returns with error or waning */
1038: if (report_retcode <> -1 ) then
1039: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1040: errbuf := fnd_message.get;

Line 1039: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');

1035:
1036: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assemble to Order Massload Report return code : '||report_retcode);
1037: /* report returns with error or waning */
1038: if (report_retcode <> -1 ) then
1039: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
1040: errbuf := fnd_message.get;
1041: raise FND_API.G_EXC_ERROR ;
1042: else
1043: if (l_logLevel <= wip_constants.full_logging) then

Line 1074: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);

1070: if (L_FAILED_REQ_ID = -1) THEN
1071: if (l_orders_loaded = 0) THEN
1072: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ORDERS_TO_LOAD');
1073: ERRBUF := FND_MESSAGE.GET;
1074: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);
1075: END IF;
1076: if (l_orders_in_interface = 0) THEN
1077: FND_MESSAGE.SET_NAME ('WIP', 'WIP_NO_ORDERS_IN_INTERFACE');
1078: ERRBUF := FND_MESSAGE.GET;

Line 1079: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);

1075: END IF;
1076: if (l_orders_in_interface = 0) THEN
1077: FND_MESSAGE.SET_NAME ('WIP', 'WIP_NO_ORDERS_IN_INTERFACE');
1078: ERRBUF := FND_MESSAGE.GET;
1079: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);
1080: END IF;
1081: END IF;
1082:
1083:

Line 1200: fnd_file.put_line(which => fnd_file.log, buff => 'Deleted from wie:' || sql%rowcount);

1196: WHERE GROUP_ID = wei_group_id
1197: AND PROCESS_PHASE = WIP_ML_COMPLETE
1198: AND PROCESS_STATUS = WCOMPLETED);
1199:
1200: fnd_file.put_line(which => fnd_file.log, buff => 'Deleted from wie:' || sql%rowcount);
1201:
1202: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE I
1203: WHERE I.GROUP_ID = wei_group_id
1204: AND I.PROCESS_PHASE = WIP_ML_COMPLETE

Line 1207: fnd_file.put_line(which => fnd_file.log, buff => 'Deleted from wjsi:' || sql%rowcount);

1203: WHERE I.GROUP_ID = wei_group_id
1204: AND I.PROCESS_PHASE = WIP_ML_COMPLETE
1205: AND I.PROCESS_STATUS = WCOMPLETED;
1206:
1207: fnd_file.put_line(which => fnd_file.log, buff => 'Deleted from wjsi:' || sql%rowcount);
1208:
1209: /* bugfix 4289455 : Remove the record from WJSI if process phase and
1210: process status is COMPLETE. If left as it is, we may encounter bug 2433627.
1211: AND 0 = (SELECT COUNT(*)

Line 1218: fnd_file.put_line(which => fnd_file.log, buff => 'MRP debug is ON. Not deleting anything.');

1214: */
1215:
1216: else
1217: --Bugfix 10636184: If MRP: Debug is ON, do not remove any records from the interface table.
1218: fnd_file.put_line(which => fnd_file.log, buff => 'MRP debug is ON. Not deleting anything.');
1219: /*
1220: DELETE FROM WIP_INTERFACE_ERRORS
1221: WHERE INTERFACE_ID IN
1222: (SELECT INTERFACE_ID