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 WIP_LOGGER

Line 155: --variables for WIP_logger

151:
152: log_file VARCHAR2(255);
153: output_file VARCHAR2(255);
154:
155: --variables for WIP_logger
156: l_params wip_logger.param_tbl_t;
157: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
158: l_returnStatus VARCHAR2(1);
159: l_audsid NUMBER;

Line 156: l_params wip_logger.param_tbl_t;

152: log_file VARCHAR2(255);
153: output_file VARCHAR2(255);
154:
155: --variables for WIP_logger
156: l_params wip_logger.param_tbl_t;
157: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
158: l_returnStatus VARCHAR2(1);
159: l_audsid NUMBER;
160:

Line 222: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',

218: l_params(10).paramValue := P_BATCH_ID ;
219: l_params(11).paramName := 'P_API_VERSION ';
220: l_params(11).paramValue := P_API_VERSION ;
221:
222: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
223: p_params => l_params,
224: x_returnStatus => x_return_status);
225:
226: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 232: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);

228: end if;
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:

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 237: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, 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);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);

Line 239: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , 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);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);

Line 240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);

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);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);

Line 241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);

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);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);

Line 242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);

238: if (l_logLevel <= wip_constants.full_logging) then
239: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);

Line 243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);

239: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);

Line 244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);

240: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);

Line 245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);

241: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
249: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);

Line 246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);

242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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);

Line 247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);

243: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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);

Line 248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);

244: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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:

Line 249: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);

245: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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

Line 250: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);

246: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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;

Line 251: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);

247: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
248: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
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:

Line 266: wip_logger.log('* WIP Autocreate Final Assembly Orders *', l_returnStatus);

262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:
265:
266: wip_logger.log('************* WIP Autocreate Final Assembly Orders *************', l_returnStatus);
267:
268:
269:
270: /*---------------------------------------------------------------+

Line 312: wip_logger.log('Parameters Validated.', l_returnStatus);

308: end if;
309:
310: /* END Validating parameters*/
311:
312: wip_logger.log('Parameters Validated.', l_returnStatus);
313:
314: if (l_logLevel <= wip_constants.full_logging) then
315: if (L_BATCH_ID = -1) then
316: wip_logger.log( 'No Batch id.', l_returnStatus);

Line 316: wip_logger.log( 'No Batch id.', l_returnStatus);

312: wip_logger.log('Parameters Validated.', l_returnStatus);
313:
314: if (l_logLevel <= wip_constants.full_logging) then
315: if (L_BATCH_ID = -1) then
316: wip_logger.log( 'No Batch id.', l_returnStatus);
317: else
318: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);
319: end if;
320: end if;

Line 318: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);

314: if (l_logLevel <= wip_constants.full_logging) then
315: if (L_BATCH_ID = -1) then
316: wip_logger.log( 'No Batch id.', l_returnStatus);
317: else
318: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);
319: end if;
320: end if;
321:
322: if ( (L_BATCH_ID<>0) and (L_FAILED_REQ_ID = -1) ) then

Line 335: wip_logger.log('Debug Profile Value:'|| fnd_profile.value('MRP_DEBUG') , l_returnStatus);

331: batch_mode_flag := TRUE;
332: L_failed_req_id := L_BATCH_ID;
333: end if;
334:
335: wip_logger.log('Debug Profile Value:'|| fnd_profile.value('MRP_DEBUG') , l_returnStatus);
336:
337: if (l_logLevel <= wip_constants.full_logging) then
338:
339: /* NS add the fact that it is running in batch mode */

Line 341: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);

337: if (l_logLevel <= wip_constants.full_logging) then
338:
339: /* NS add the fact that it is running in batch mode */
340: if (batch_mode_flag = true) then
341: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
342: end if;
343:
344: wip_logger.log('After checks...........', l_returnStatus);
345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);

Line 344: wip_logger.log('After checks...........', l_returnStatus);

340: if (batch_mode_flag = true) then
341: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
342: end if;
343:
344: wip_logger.log('After checks...........', l_returnStatus);
345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);

Line 345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);

341: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
342: end if;
343:
344: wip_logger.log('After checks...........', l_returnStatus);
345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);

Line 346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);

342: end if;
343:
344: wip_logger.log('After checks...........', l_returnStatus);
345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);

Line 348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);

344: wip_logger.log('After checks...........', l_returnStatus);
345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
352: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);

Line 349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);

345: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
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);

Line 350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);

346: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
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;

Line 351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);

347:
348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
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:

Line 352: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);

348: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
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...........');

Line 353: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);

349: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
350: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
351: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
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);

Line 397: wip_logger.log(

393: | Program completion with problem. |
394: | Handle failure of program |
395: +------------------------------------+*/
396: if (l_logLevel <= wip_constants.full_logging) then
397: wip_logger.log(
398: 'Dbg:Exiting Sales Order Loaded w/errors', l_returnStatus);
399: end if;
400: APP_EXCEPTION.RAISE_EXCEPTION;
401:

Line 408: wip_logger.log( 'Dbg:Exiting Sales Order Loaded w/success', l_returnStatus);

404: /*--------------------------------------------------------+
405: | Program completion with no major problems |
406: +--------------------------------------------------------+*/
407: if (l_logLevel <= wip_constants.full_logging) then
408: wip_logger.log( 'Dbg:Exiting Sales Order Loaded w/success', l_returnStatus);
409: end if;
410: else
411: if (l_logLevel <= wip_constants.full_logging) then
412: wip_logger.log(

Line 412: wip_logger.log(

408: wip_logger.log( 'Dbg:Exiting Sales Order Loaded w/success', l_returnStatus);
409: end if;
410: else
411: if (l_logLevel <= wip_constants.full_logging) then
412: wip_logger.log(
413: 'Dbg:Exiting Sales Order Loaded w/warning', l_returnStatus);
414: end if;
415: --Put Warnings in Error Buffer
416: --Log Warnings

Line 423: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',

419: end if;
420:
421: -- write to the log file
422: IF (l_logLevel <= wip_constants.trace_logging) THEN
423: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
424: p_procReturnStatus => x_return_Status,
425: p_msg => 'PROCEDURE COMPLETE.',
426: x_returnStatus => l_returnStatus);
427: END IF;

Line 455: wip_logger.log(ERRBUF, l_returnStatus);

451: ERRBUF := 'No error message found in the stack';
452: END IF;
453:
454: IF (l_logLevel <= wip_constants.trace_logging) THEN
455: wip_logger.log(ERRBUF, l_returnStatus);
456: wip_logger.exitPoint(p_procName =>'WIP_ATO_JOBS.CREATE_JOBS',
457: p_procReturnStatus => x_return_status,
458: p_msg => ERRBUF,
459: x_returnStatus => l_returnStatus);

Line 456: wip_logger.exitPoint(p_procName =>'WIP_ATO_JOBS.CREATE_JOBS',

452: END IF;
453:
454: IF (l_logLevel <= wip_constants.trace_logging) THEN
455: wip_logger.log(ERRBUF, l_returnStatus);
456: wip_logger.exitPoint(p_procName =>'WIP_ATO_JOBS.CREATE_JOBS',
457: p_procReturnStatus => x_return_status,
458: p_msg => ERRBUF,
459: x_returnStatus => l_returnStatus);
460: END IF;

Line 462: wip_logger.cleanUp(x_returnStatus => l_returnStatus);

458: p_msg => ERRBUF,
459: x_returnStatus => l_returnStatus);
460: END IF;
461: -- close log file
462: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
463:
464: END CREATE_JOBS;
465: /*------------------------------------------------------------------+
466: | End CREATE_JOBS |

Line 602: --variables for WIP_logger

598: desname VARCHAR2(80);
599: destype VARCHAR2(10);
600: desformat VARCHAR2(10);
601:
602: --variables for WIP_logger
603: l_params wip_logger.param_tbl_t;
604: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
605: l_returnStatus VARCHAR2(1);
606:

Line 603: l_params wip_logger.param_tbl_t;

599: destype VARCHAR2(10);
600: desformat VARCHAR2(10);
601:
602: --variables for WIP_logger
603: l_params wip_logger.param_tbl_t;
604: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
605: l_returnStatus VARCHAR2(1);
606:
607: report_retcode number;

Line 647: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',

643: l_params(10).paramValue := P_BATCH_ID ;
644: l_params(11).paramName := 'p_all_success_ptr';
645: l_params(11).paramValue := p_all_success_ptr ;
646:
647: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
648: p_params => l_params,
649: x_returnStatus => l_returnStatus);
650:
651: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

Line 656: wip_logger.log('Inside Load_Orders.....', l_returnStatus);

652: raise fnd_api.g_exc_unexpected_error;
653: end if;
654: end if;
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:');

Line 674: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);

670: /*---------------------------------------------------------------+
671: | Print out values in argument stucture if in debug mode |
672: +---------------------------------------------------------------+*/
673: if (l_logLevel <= wip_constants.full_logging) then
674: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);

Line 675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);

671: | Print out values in argument stucture if in debug mode |
672: +---------------------------------------------------------------+*/
673: if (l_logLevel <= wip_constants.full_logging) then
674: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);

Line 677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);

673: if (l_logLevel <= wip_constants.full_logging) then
674: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);

Line 678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);

674: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);

Line 679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);

675: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
683:

Line 680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);

676:
677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
683:
684: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);

Line 681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);

677: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
683:
684: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
685:

Line 682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);

678: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
679: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
683:
684: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
685:
686: END IF;

Line 684: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);

680: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
681: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
682: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
683:
684: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
685:
686: END IF;
687:
688: if (p_all_success_ptr = -25) then

Line 693: wip_logger.log('Setting Batch Flag... All_Success==-25', l_returnStatus);

689: /* Now we are back to previous version code */
690: p_all_success_ptr := 1; /* i.e. TRUE */
691: batch_id := L_FAILED_REQ_ID;
692: L_FAILED_REQ_ID := -1;
693: wip_logger.log('Setting Batch Flag... All_Success==-25', l_returnStatus);
694: batch_flag:=1;
695: END IF;
696:
697: /* As mentioned in CREATE_JOBS, we added a batch_id parameter

Line 715: wip_logger.log('Dbg: OM Installed: Enter get_order_lines.', l_returnStatus);

711: +===============================================================+*/
712: if (L_FAILED_REQ_ID = -1) then
713:
714: if (l_logLevel <= wip_constants.full_logging) then
715: wip_logger.log('Dbg: OM Installed: Enter get_order_lines.', l_returnStatus);
716: END IF;
717:
718: l_org_id := p_org_id;
719: l_offset_days := p_offset_days;

Line 739: wip_logger.log('Before CTO, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);

735:
736: --Flow ER 14595064
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:');

Line 782: wip_logger.log(

778: --p_orders_to_load := l_orders_loaded; /* order lines */
779: L_orders_in_interface := l_orders_loaded;
780:
781: if (l_logLevel <= wip_constants.full_logging) then
782: wip_logger.log(
783: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
784: wip_logger.log(
785: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
786: wip_logger.log(

Line 784: wip_logger.log(

780:
781: if (l_logLevel <= wip_constants.full_logging) then
782: wip_logger.log(
783: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
784: wip_logger.log(
785: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
786: wip_logger.log(
787: 'Dbg: Orders Loaded = '||l_orders_loaded, l_returnStatus);
788: END IF;

Line 786: wip_logger.log(

782: wip_logger.log(
783: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
784: wip_logger.log(
785: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
786: wip_logger.log(
787: 'Dbg: Orders Loaded = '||l_orders_loaded, l_returnStatus);
788: END IF;
789:
790: if (l_status <> 1) then

Line 826: wip_logger.log( 'Dbg:Failed in wip_massload_pub.massLoadJobs', l_returnStatus);

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;
828:
829: -- Bug 9314772.Should not raise exception here so that reservations
830: -- are created for jobs created with warnings.In case when the status

Line 897: wip_logger.log(

893: if (L_FAILED_REQ_ID <> -1) THEN
894:
895: /* OM Installed - No Clean-up Mode Code Yet */
896: if (l_logLevel <= wip_constants.full_logging) then
897: wip_logger.log(
898: 'Dbg: OM Installed: No Clean-Up Mode', l_returnStatus);
899: END IF;
900: END IF; /* End of Logic for Clean up Mode */
901:

Line 905: wip_logger.log( 'Dbg: OM Installed: Enter reserve_work_order.', l_returnStatus);

901:
902:
903: /* OM Installed */
904: if (l_logLevel <= wip_constants.full_logging) then
905: wip_logger.log( 'Dbg: OM Installed: Enter reserve_work_order.', l_returnStatus);
906: END IF;
907:
908: l_status := CTO_WIP_WRAPPER.reserve_wo_to_so(l_wip_group_id,
909: l_message_name,

Line 913: wip_logger.log('Dbg: Exited reserve_wo_to_so with status '||l_status, l_returnStatus);

909: l_message_name,
910: l_message_text);
911:
912: if (l_logLevel <= wip_constants.full_logging) then
913: wip_logger.log('Dbg: Exited reserve_wo_to_so with status '||l_status, l_returnStatus);
914: END IF;
915:
916: if (l_status <> 1) THEN
917: APP_EXCEPTION.RAISE_EXCEPTION;

Line 946: wip_logger.log(num_error_records||'records failed to process', l_returnStatus);

942: all_success_ptr := -1;
943: END IF;
944:
945: if (l_logLevel <= wip_constants.full_logging) then
946: wip_logger.log(num_error_records||'records failed to process', l_returnStatus);
947: END IF;
948:
949: FND_MESSAGE.SET_NAME('WIP','WIP_WARNING_REPORT');
950: FND_MSG_PUB.Add;

Line 976: wip_logger.log('P_group_id='||l_wip_group_id

972: /*---------------------------------------------------+
973: | Run report. |
974: +---------------------------------------------------+*/
975: if (l_logLevel <= wip_constants.full_logging) then
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);

Line 983: wip_logger.log('Before Report Submit, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);

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
986: --Reset Context back to current
987: FND_GLOBAL.Apps_Initialize

Line 991: wip_logger.log('Before Report, After context setup; Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);

987: FND_GLOBAL.Apps_Initialize
988: (user_id => l_user_id
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 :=

Line 1012: wip_logger.log('Conc Request no:'||report_status, l_returnStatus);

1008: '', '', '', '', '', '', '', '', '', '');
1009:
1010: commit;
1011:
1012: wip_logger.log('Conc Request no:'||report_status, l_returnStatus);
1013:
1014: IF (report_status = 0) THEN
1015: report_retcode := 2;
1016: END IF;

Line 1021: wip_logger.log(errbuf, l_returnStatus);

1017:
1018: /* if report didn't launch*/
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

Line 1024: wip_logger.log('==========================================', l_returnStatus);

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;
1028: all_success_ptr := -1;

Line 1026: wip_logger.log('Could not execute report.', 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;
1028: all_success_ptr := -1;
1029:
1030: /* if report launched succesfully*/

Line 1044: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);

1040: errbuf := fnd_message.get;
1041: raise FND_API.G_EXC_ERROR ;
1042: else
1043: if (l_logLevel <= wip_constants.full_logging) then
1044: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
1045: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);
1046: END IF;
1047: end if;
1048:

Line 1045: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);

1041: raise FND_API.G_EXC_ERROR ;
1042: else
1043: if (l_logLevel <= wip_constants.full_logging) then
1044: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
1045: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);
1046: END IF;
1047: end if;
1048:
1049: END IF;

Line 1055: wip_logger.log(

1051:
1052: if ( delete_interface_orders(p_wei_group_id => l_wip_group_id) = false )
1053: THEN
1054: if (l_logLevel <= wip_constants.full_logging) then
1055: wip_logger.log(
1056: 'Dbg:Failed in delete_interface_orders', l_returnStatus);
1057: END IF;
1058: APP_EXCEPTION.RAISE_EXCEPTION;
1059: END IF;

Line 1066: wip_logger.log(

1062: | Program completion with no major problems |
1063: +--------------------------------------------------------+*/
1064: if (l_logLevel <= wip_constants.full_logging) then
1065: /* OM Installed */
1066: wip_logger.log(
1067: 'Dbg:Exiting Filter Order Lines w/success', l_returnStatus);
1068: END IF;
1069:
1070: if (L_FAILED_REQ_ID = -1) THEN

Line 1086: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',

1082:
1083:
1084: -- write to the log file
1085: IF (l_logLevel <= wip_constants.trace_logging) THEN
1086: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
1087: p_procReturnStatus => l_returnStatus,
1088: p_msg => 'PROCEDURE COMPLETE.',
1089: x_returnStatus => l_returnStatus);
1090: END IF;

Line 1106: wip_logger.log(

1102: EXCEPTION
1103:
1104: WHEN OTHERS THEN
1105: if (l_logLevel <= wip_constants.full_logging) then
1106: wip_logger.log(
1107: 'Dbg:Exiting Sales Order Loader w/errors', l_returnStatus);
1108: END IF;
1109: return FALSE;
1110:

Line 1131: --variables for WIP_logger

1127:
1128: wei_group_id NUMBER;
1129: n_undeleted_records NUMBER ;
1130:
1131: --variables for WIP_logger
1132: l_params wip_logger.param_tbl_t;
1133: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1134: l_returnStatus VARCHAR2(1);
1135: x_return_status VARCHAR2(255);

Line 1132: l_params wip_logger.param_tbl_t;

1128: wei_group_id NUMBER;
1129: n_undeleted_records NUMBER ;
1130:
1131: --variables for WIP_logger
1132: l_params wip_logger.param_tbl_t;
1133: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1134: l_returnStatus VARCHAR2(1);
1135: x_return_status VARCHAR2(255);
1136:

Line 1150: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',

1146:
1147: if (l_logLevel <= wip_constants.trace_logging) then
1148: l_params(1).paramName := 'p_wei_group_id ';
1149: l_params(1).paramValue := p_wei_group_id ;
1150: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1151: p_params => l_params,
1152: x_returnStatus => x_return_status);
1153:
1154: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 1166: wip_logger.log(

1162: /*-------------------------------------------+
1163: | If in debug mode, print out parameters |
1164: +-------------------------------------------+*/
1165: if (l_logLevel <= wip_constants.full_logging) then
1166: wip_logger.log(
1167: 'Dbg: In delete_interface_orders function', l_returnStatus);
1168: wip_logger.log( 'Dbg:wei_group_id = '||wei_group_id, l_returnStatus);
1169: END IF;
1170:

Line 1168: wip_logger.log( 'Dbg:wei_group_id = '||wei_group_id, l_returnStatus);

1164: +-------------------------------------------+*/
1165: if (l_logLevel <= wip_constants.full_logging) then
1166: wip_logger.log(
1167: 'Dbg: In delete_interface_orders function', l_returnStatus);
1168: wip_logger.log( 'Dbg:wei_group_id = '||wei_group_id, l_returnStatus);
1169: END IF;
1170:
1171: /*
1172: * Clean up the interface table and interface errors table.

Line 1235: wip_logger.log('Dbg:'||SQL%ROWCOUNT||' records deleted from interface', l_returnStatus);

1231: END IF;
1232:
1233:
1234: if (l_logLevel <= wip_constants.full_logging) then
1235: wip_logger.log('Dbg:'||SQL%ROWCOUNT||' records deleted from interface', l_returnStatus);
1236:
1237: SELECT COUNT(*) INTO n_undeleted_records
1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1239:

Line 1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);

1237: SELECT COUNT(*) INTO n_undeleted_records
1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;

Line 1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);

1238: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246:

Line 1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);

1239:
1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246:
1247: wip_logger.log(

Line 1244: wip_logger.log('Dbg:for details.', l_returnStatus);

1240: if(n_undeleted_records <> 0) THEN
1241: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1242: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246:
1247: wip_logger.log(
1248: 'Dbg:Success in delete_interface_orders', l_returnStatus);

Line 1247: wip_logger.log(

1243: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1244: wip_logger.log('Dbg:for details.', l_returnStatus);
1245: END IF;
1246:
1247: wip_logger.log(
1248: 'Dbg:Success in delete_interface_orders', l_returnStatus);
1249: END IF;
1250:
1251: -- write to the log file

Line 1253: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',

1249: END IF;
1250:
1251: -- write to the log file
1252: IF (l_logLevel <= wip_constants.trace_logging) THEN
1253: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1254: p_procReturnStatus => l_returnStatus,
1255: p_msg => 'PROCEDURE COMPLETE.',
1256: x_returnStatus => l_returnStatus);
1257: END IF;

Line 1265: wip_logger.log( 'Dbg:SQL error in delete_interface_orders', l_returnStatus);

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: if (l_logLevel <= wip_constants.full_logging) then
1265: wip_logger.log( 'Dbg:SQL error in delete_interface_orders', l_returnStatus);
1266: END IF;
1267: return(FALSE);
1268:
1269: /* end of delete_interface_orders */