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 99: --variables for WIP_logger

95:
96: log_file VARCHAR2(255);
97: output_file VARCHAR2(255);
98:
99: --variables for WIP_logger
100: l_params wip_logger.param_tbl_t;
101: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
102: l_returnStatus VARCHAR2(1);
103: l_audsid NUMBER;

Line 100: l_params wip_logger.param_tbl_t;

96: log_file VARCHAR2(255);
97: output_file VARCHAR2(255);
98:
99: --variables for WIP_logger
100: l_params wip_logger.param_tbl_t;
101: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
102: l_returnStatus VARCHAR2(1);
103: l_audsid NUMBER;
104:

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

153: l_params(10).paramValue := P_BATCH_ID ;
154: l_params(11).paramName := 'P_API_VERSION ';
155: l_params(11).paramValue := P_API_VERSION ;
156:
157: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
158: p_params => l_params,
159: x_returnStatus => x_return_status);
160:
161: if(x_return_status <> fnd_api.g_ret_sts_success) then

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

163: end if;
164: end if;
165:
166:
167: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
168: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
169: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
170: fnd_file.get_names(log_file, output_file);
171:

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

164: end if;
165:
166:
167: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
168: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
169: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
170: fnd_file.get_names(log_file, output_file);
171:
172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);

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

165:
166:
167: wip_logger.log('WIP Autocreate Final Assembly Orders [PL/SQL]-Start', l_returnStatus);
168: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
169: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
170: fnd_file.get_names(log_file, output_file);
171:
172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
173: if (l_logLevel <= wip_constants.full_logging) then

Line 172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);

168: wip_logger.log( 'Value of fnd_file.log:'|| fnd_file.log, l_returnStatus);
169: wip_logger.log('Value of fnd_file.output:'|| fnd_file.output, l_returnStatus);
170: fnd_file.get_names(log_file, output_file);
171:
172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
173: if (l_logLevel <= wip_constants.full_logging) then
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);

Line 174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);

170: fnd_file.get_names(log_file, output_file);
171:
172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
173: if (l_logLevel <= wip_constants.full_logging) then
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);

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

171:
172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
173: if (l_logLevel <= wip_constants.full_logging) then
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);

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

172: wip_logger.log('Log File Name:'|| log_file|| '; Output file name:'|| output_file, l_returnStatus);
173: if (l_logLevel <= wip_constants.full_logging) then
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);

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

173: if (l_logLevel <= wip_constants.full_logging) then
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);

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

174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);
175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);

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

175: wip_logger.log('DUMMY_FIELD = '||P_DUMMY_FIELD , l_returnStatus);
176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);

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

176: wip_logger.log('OFFSET_DAYS = '||P_OFFSET_DAYS , l_returnStatus);
177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);

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

177: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);
178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);

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

178: wip_logger.log('P_STATUS_TYPE = '||P_STATUS_TYPE , l_returnStatus);
179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
186: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);

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

179: wip_logger.log('P_ORG_ID = '||P_ORG_ID , l_returnStatus);
180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
186: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);
187:

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

180: wip_logger.log('P_CLASS_CODE = '||P_CLASS_CODE , l_returnStatus);
181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
186: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);
187:
188: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators

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

181: wip_logger.log('P_FAILED_REQ_ID = '||P_FAILED_REQ_ID , l_returnStatus);
182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
186: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);
187:
188: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators
189: end if;

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

182: wip_logger.log('ORDER_LINE_ID = '||P_ORDER_LINE_ID , l_returnStatus);
183: wip_logger.log('BATCH_ID = '||P_BATCH_ID , l_returnStatus);
184: wip_logger.log('P_API_VERSION = '||P_API_VERSION , l_returnStatus);
185: wip_logger.log('P_INIT_MSG_LIST = '||P_INIT_MSG_LIST , l_returnStatus);
186: wip_logger.log('P_COMMIT = '||P_COMMIT , l_returnStatus);
187:
188: fnd_file.new_line(FND_FIlE.LOG,3); --put new line as separators
189: end if;
190:

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

197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200:
201: wip_logger.log('************* WIP Autocreate Final Assembly Orders *************', l_returnStatus);
202:
203:
204:
205: /*---------------------------------------------------------------+

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

242: L_BATCH_ID := TO_NUMBER(P_BATCH_ID);
243: end if;
244: /* END Validating parameters*/
245:
246: wip_logger.log('Parameters Validated.', l_returnStatus);
247:
248: if (l_logLevel <= wip_constants.full_logging) then
249: if (L_BATCH_ID = -1) then
250: wip_logger.log( 'No Batch id.', l_returnStatus);

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

246: wip_logger.log('Parameters Validated.', l_returnStatus);
247:
248: if (l_logLevel <= wip_constants.full_logging) then
249: if (L_BATCH_ID = -1) then
250: wip_logger.log( 'No Batch id.', l_returnStatus);
251: else
252: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);
253: end if;
254: end if;

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

248: if (l_logLevel <= wip_constants.full_logging) then
249: if (L_BATCH_ID = -1) then
250: wip_logger.log( 'No Batch id.', l_returnStatus);
251: else
252: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);
253: end if;
254: end if;
255:
256: if ( (L_BATCH_ID<>0) and (L_FAILED_REQ_ID = -1) ) then

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

265: batch_mode_flag := TRUE;
266: L_failed_req_id := L_BATCH_ID;
267: end if;
268:
269: wip_logger.log('Debug Profile Value:'|| fnd_profile.value('MRP_DEBUG') , l_returnStatus);
270:
271: if (l_logLevel <= wip_constants.full_logging) then
272:
273: /* NS add the fact that it is running in batch mode */

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

271: if (l_logLevel <= wip_constants.full_logging) then
272:
273: /* NS add the fact that it is running in batch mode */
274: if (batch_mode_flag = true) then
275: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
276: end if;
277:
278: wip_logger.log('After checks...........', l_returnStatus);
279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);

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

274: if (batch_mode_flag = true) then
275: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
276: end if;
277:
278: wip_logger.log('After checks...........', l_returnStatus);
279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);

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

275: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);
276: end if;
277:
278: wip_logger.log('After checks...........', l_returnStatus);
279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);

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

276: end if;
277:
278: wip_logger.log('After checks...........', l_returnStatus);
279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);

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

278: wip_logger.log('After checks...........', l_returnStatus);
279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);

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

279: wip_logger.log('Dbg:org_id = '|| l_org_id , l_returnStatus);
280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
287: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);

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

280: wip_logger.log('Dbg:offset_days = '|| l_offset_days, l_returnStatus);
281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
287: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
288: end if;

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

281:
282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
287: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
288: end if;
289:

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

282: wip_logger.log('Dbg:load_type = ' || l_load_type, l_returnStatus);
283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
287: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
288: end if;
289:
290:

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

283: wip_logger.log('Dbg:class_code = ' || P_class_code, l_returnStatus);
284: wip_logger.log('Dbg:status_type = '|| l_status_type, l_returnStatus);
285: wip_logger.log('Dbg:failed_req_id = '|| l_failed_req_id, l_returnStatus);
286: wip_logger.log('Dbg:order_number = ' || l_order_number, l_returnStatus);
287: wip_logger.log('Dbg:order_line_id = '|| l_order_line_id, l_returnStatus);
288: end if;
289:
290:
291: /*--------------------------------------------------------+

Line 318: wip_logger.log(

314: | Program completion with problem. |
315: | Handle failure of program |
316: +------------------------------------+*/
317: if (l_logLevel <= wip_constants.full_logging) then
318: wip_logger.log(
319: 'Dbg:Exiting Sales Order Loaded w/errors', l_returnStatus);
320: end if;
321: APP_EXCEPTION.RAISE_EXCEPTION;
322:

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

325: /*--------------------------------------------------------+
326: | Program completion with no major problems |
327: +--------------------------------------------------------+*/
328: if (l_logLevel <= wip_constants.full_logging) then
329: wip_logger.log( 'Dbg:Exiting Sales Order Loaded w/success', l_returnStatus);
330: end if;
331: else
332: if (l_logLevel <= wip_constants.full_logging) then
333: wip_logger.log(

Line 333: wip_logger.log(

329: wip_logger.log( 'Dbg:Exiting Sales Order Loaded w/success', l_returnStatus);
330: end if;
331: else
332: if (l_logLevel <= wip_constants.full_logging) then
333: wip_logger.log(
334: 'Dbg:Exiting Sales Order Loaded w/warning', l_returnStatus);
335: end if;
336: --Put Warnings in Error Buffer
337: --Log Warnings

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

340: end if;
341:
342: -- write to the log file
343: IF (l_logLevel <= wip_constants.trace_logging) THEN
344: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.CREATE_JOBS',
345: p_procReturnStatus => x_return_Status,
346: p_msg => 'PROCEDURE COMPLETE.',
347: x_returnStatus => l_returnStatus);
348: END IF;

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

372: ERRBUF := 'No error message found in the stack';
373: END IF;
374:
375: IF (l_logLevel <= wip_constants.trace_logging) THEN
376: wip_logger.log(ERRBUF, l_returnStatus);
377: wip_logger.exitPoint(p_procName =>'WIP_ATO_JOBS.CREATE_JOBS',
378: p_procReturnStatus => x_return_status,
379: p_msg => ERRBUF,
380: x_returnStatus => l_returnStatus);

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

373: END IF;
374:
375: IF (l_logLevel <= wip_constants.trace_logging) THEN
376: wip_logger.log(ERRBUF, l_returnStatus);
377: wip_logger.exitPoint(p_procName =>'WIP_ATO_JOBS.CREATE_JOBS',
378: p_procReturnStatus => x_return_status,
379: p_msg => ERRBUF,
380: x_returnStatus => l_returnStatus);
381: END IF;

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

379: p_msg => ERRBUF,
380: x_returnStatus => l_returnStatus);
381: END IF;
382: -- close log file
383: wip_logger.cleanUp(x_returnStatus => l_returnStatus);
384:
385: END CREATE_JOBS;
386: /*------------------------------------------------------------------+
387: | End CREATE_JOBS |

Line 519: --variables for WIP_logger

515: desname VARCHAR2(80);
516: destype VARCHAR2(10);
517: desformat VARCHAR2(10);
518:
519: --variables for WIP_logger
520: l_params wip_logger.param_tbl_t;
521: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
522: l_returnStatus VARCHAR2(1);
523:

Line 520: l_params wip_logger.param_tbl_t;

516: destype VARCHAR2(10);
517: desformat VARCHAR2(10);
518:
519: --variables for WIP_logger
520: l_params wip_logger.param_tbl_t;
521: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
522: l_returnStatus VARCHAR2(1);
523:
524: report_retcode number;

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

557: l_params(10).paramValue := P_BATCH_ID ;
558: l_params(11).paramName := 'p_all_success_ptr';
559: l_params(11).paramValue := p_all_success_ptr ;
560:
561: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
562: p_params => l_params,
563: x_returnStatus => l_returnStatus);
564:
565: if(l_returnStatus <> fnd_api.g_ret_sts_success) then

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

566: raise fnd_api.g_exc_unexpected_error;
567: end if;
568: end if;
569:
570: wip_logger.log('Inside Load_Orders.....', l_returnStatus);
571:
572: /*---------------------------------------------------------------+
573: | Print out values in argument stucture if in debug mode |
574: +---------------------------------------------------------------+*/

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

572: /*---------------------------------------------------------------+
573: | Print out values in argument stucture if in debug mode |
574: +---------------------------------------------------------------+*/
575: if (l_logLevel <= wip_constants.full_logging) then
576: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
577: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);

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

573: | Print out values in argument stucture if in debug mode |
574: +---------------------------------------------------------------+*/
575: if (l_logLevel <= wip_constants.full_logging) then
576: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
577: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);

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

575: if (l_logLevel <= wip_constants.full_logging) then
576: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
577: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);

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

576: wip_logger.log('Dbg:org_id = '||p_org_id , l_returnStatus);
577: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);

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

577: wip_logger.log('Dbg:offset_days = '||p_offset_days, l_returnStatus);
578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
585:

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

578:
579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
585:
586: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);

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

579: wip_logger.log('Dbg:load_type = '||p_load_type, l_returnStatus);
580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
585:
586: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
587:

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

580: wip_logger.log('Dbg:class_code = '||p_class_code, l_returnStatus);
581: wip_logger.log('Dbg:status_type = '||p_status_type, l_returnStatus);
582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
585:
586: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
587:
588: END IF;

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

582: wip_logger.log('Dbg:failed_req_id = '||p_failed_req_id, l_returnStatus);
583: wip_logger.log('Dbg:order_number = '||P_ORDER_NUMBER, l_returnStatus);
584: wip_logger.log('Dbg:order_line_id = '||p_order_line_id, l_returnStatus);
585:
586: wip_logger.log('Dbg:all_success_rec = '||p_all_success_ptr, l_returnStatus);
587:
588: END IF;
589:
590: if (p_all_success_ptr = -25) then

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

591: /* Now we are back to previous version code */
592: p_all_success_ptr := 1; /* i.e. TRUE */
593: batch_id := L_FAILED_REQ_ID;
594: L_FAILED_REQ_ID := -1;
595: wip_logger.log('Setting Batch Flag... All_Success==-25', l_returnStatus);
596: batch_flag:=1;
597: END IF;
598:
599: /* As mentioned in CREATE_JOBS, we added a batch_id parameter

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

613: +===============================================================+*/
614: if (L_FAILED_REQ_ID = -1) then
615:
616: if (l_logLevel <= wip_constants.full_logging) then
617: wip_logger.log('Dbg: OM Installed: Enter get_order_lines.', l_returnStatus);
618: END IF;
619:
620: l_org_id := p_org_id;
621: l_offset_days := p_offset_days;

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

634: --to later reset context to original values
635: l_resp_id := FND_GLOBAL.RESP_ID;
636: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
637:
638: wip_logger.log('Before CTO, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
639:
640: fnd_file.put_line(which => fnd_file.log, buff => 'Calling CTO_WIP_WRAPPER.get_order_lines');
641:
642:

Line 669: wip_logger.log(

665: --p_orders_to_load := l_orders_loaded; /* order lines */
666: L_orders_in_interface := l_orders_loaded;
667:
668: if (l_logLevel <= wip_constants.full_logging) then
669: wip_logger.log(
670: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
671: wip_logger.log(
672: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
673: wip_logger.log(

Line 671: wip_logger.log(

667:
668: if (l_logLevel <= wip_constants.full_logging) then
669: wip_logger.log(
670: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
671: wip_logger.log(
672: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
673: wip_logger.log(
674: 'Dbg: Orders Loaded = '||l_orders_loaded, l_returnStatus);
675: END IF;

Line 673: wip_logger.log(

669: wip_logger.log(
670: 'Dbg: Exited get_order_lines with status '||l_status, l_returnStatus);
671: wip_logger.log(
672: 'Dbg: wei_group_id = '||l_wip_group_id, l_returnStatus);
673: wip_logger.log(
674: 'Dbg: Orders Loaded = '||l_orders_loaded, l_returnStatus);
675: END IF;
676:
677: if (l_status <> 1) then

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

709: IF (retCode <> fnd_api.g_ret_sts_success) THEN
710: fnd_file.put_line(which => fnd_file.log, buff => 'Failed in wip_massload_pub.massLoadJobs.');
711:
712: if (l_logLevel <= wip_constants.full_logging) then
713: wip_logger.log( 'Dbg:Failed in wip_massload_pub.massLoadJobs', l_returnStatus);
714: END IF;
715:
716: APP_EXCEPTION.RAISE_EXCEPTION;
717: END IF;

Line 746: wip_logger.log(

742: if (L_FAILED_REQ_ID <> -1) THEN
743:
744: /* OM Installed - No Clean-up Mode Code Yet */
745: if (l_logLevel <= wip_constants.full_logging) then
746: wip_logger.log(
747: 'Dbg: OM Installed: No Clean-Up Mode', l_returnStatus);
748: END IF;
749: END IF; /* End of Logic for Clean up Mode */
750:

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

750:
751:
752: /* OM Installed */
753: if (l_logLevel <= wip_constants.full_logging) then
754: wip_logger.log( 'Dbg: OM Installed: Enter reserve_work_order.', l_returnStatus);
755: END IF;
756:
757: l_status := CTO_WIP_WRAPPER.reserve_wo_to_so(l_wip_group_id,
758: l_message_name,

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

758: l_message_name,
759: l_message_text);
760:
761: if (l_logLevel <= wip_constants.full_logging) then
762: wip_logger.log('Dbg: Exited reserve_wo_to_so with status '||l_status, l_returnStatus);
763: END IF;
764:
765: if (l_status <> 1) THEN
766: APP_EXCEPTION.RAISE_EXCEPTION;

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

791: all_success_ptr := -1;
792: END IF;
793:
794: if (l_logLevel <= wip_constants.full_logging) then
795: wip_logger.log(num_error_records||'records failed to process', l_returnStatus);
796: END IF;
797:
798: FND_MESSAGE.SET_NAME('WIP','WIP_WARNING_REPORT');
799: FND_MSG_PUB.Add;

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

821: /*---------------------------------------------------+
822: | Run report. |
823: +---------------------------------------------------+*/
824: if (l_logLevel <= wip_constants.full_logging) then
825: wip_logger.log('P_group_id='||l_wip_group_id
826: ||'; P_qty_precision='||precision_profile, l_returnStatus);
827: END IF;
828:
829: fnd_file.new_line(FND_FILE.LOG);

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

828:
829: fnd_file.new_line(FND_FILE.LOG);
830: fnd_file.get_names(log_file, output_file);
831:
832: wip_logger.log('Before Report Submit, Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
833:
834: --Since context has been changed in OE_Order_Context_GRP.Set_Created_By_Context
835: --Reset Context back to current
836: FND_GLOBAL.Apps_Initialize

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

836: FND_GLOBAL.Apps_Initialize
837: (user_id => l_user_id
838: ,resp_id => l_resp_id
839: ,resp_appl_id => l_resp_appl_id);
840: wip_logger.log('Before Report, After context setup; Fnd_Global values: user_id:' || fnd_global.user_id, l_returnStatus);
841:
842: fnd_file.put_line(which => fnd_file.log, buff => 'Calling WIPDJATO Report with group id:'|| l_wip_group_id||' and precision_profile:'||precision_profile);
843:
844: report_status :=

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

857: '', '', '', '', '', '', '', '', '', '');
858:
859: commit;
860:
861: wip_logger.log('Conc Request no:'||report_status, l_returnStatus);
862:
863: IF (report_status = 0) THEN
864: report_retcode := 2;
865: END IF;

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

866:
867: /* if report didn't launch*/
868: if(report_status = 0 ) then
869:
870: wip_logger.log(errbuf, l_returnStatus);
871:
872: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
873: wip_logger.log('==========================================', l_returnStatus);
874: if (l_logLevel <= wip_constants.full_logging) then

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

869:
870: wip_logger.log(errbuf, l_returnStatus);
871:
872: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
873: wip_logger.log('==========================================', l_returnStatus);
874: if (l_logLevel <= wip_constants.full_logging) then
875: wip_logger.log('Could not execute report.', l_returnStatus);
876: END IF;
877: all_success_ptr := -1;

Line 875: wip_logger.log('Could not execute report.', l_returnStatus);

871:
872: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
873: wip_logger.log('==========================================', l_returnStatus);
874: if (l_logLevel <= wip_constants.full_logging) then
875: wip_logger.log('Could not execute report.', l_returnStatus);
876: END IF;
877: all_success_ptr := -1;
878:
879: /* if report launched succesfully*/

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

889: errbuf := fnd_message.get;
890: raise FND_API.G_EXC_ERROR ;
891: else
892: if (l_logLevel <= wip_constants.full_logging) then
893: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
894: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);
895: END IF;
896: end if;
897:

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

890: raise FND_API.G_EXC_ERROR ;
891: else
892: if (l_logLevel <= wip_constants.full_logging) then
893: wip_logger.log('Report: Assemble To Order Mass Load Report ran successfully ', l_returnStatus);
894: wip_logger.log('Check Output and Log file for Conc Request Number:'|| report_status, l_returnStatus);
895: END IF;
896: end if;
897:
898: END IF;

Line 904: wip_logger.log(

900:
901: if ( delete_interface_orders(p_wei_group_id => l_wip_group_id) = false )
902: THEN
903: if (l_logLevel <= wip_constants.full_logging) then
904: wip_logger.log(
905: 'Dbg:Failed in delete_interface_orders', l_returnStatus);
906: END IF;
907: APP_EXCEPTION.RAISE_EXCEPTION;
908: END IF;

Line 915: wip_logger.log(

911: | Program completion with no major problems |
912: +--------------------------------------------------------+*/
913: if (l_logLevel <= wip_constants.full_logging) then
914: /* OM Installed */
915: wip_logger.log(
916: 'Dbg:Exiting Filter Order Lines w/success', l_returnStatus);
917: END IF;
918:
919: if (L_FAILED_REQ_ID = -1) THEN

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

931:
932:
933: -- write to the log file
934: IF (l_logLevel <= wip_constants.trace_logging) THEN
935: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.LOAD_ORDERS',
936: p_procReturnStatus => l_returnStatus,
937: p_msg => 'PROCEDURE COMPLETE.',
938: x_returnStatus => l_returnStatus);
939: END IF;

Line 955: wip_logger.log(

951: EXCEPTION
952:
953: WHEN OTHERS THEN
954: if (l_logLevel <= wip_constants.full_logging) then
955: wip_logger.log(
956: 'Dbg:Exiting Sales Order Loader w/errors', l_returnStatus);
957: END IF;
958: return FALSE;
959:

Line 980: --variables for WIP_logger

976:
977: wei_group_id NUMBER;
978: n_undeleted_records NUMBER ;
979:
980: --variables for WIP_logger
981: l_params wip_logger.param_tbl_t;
982: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
983: l_returnStatus VARCHAR2(1);
984: x_return_status VARCHAR2(255);

Line 981: l_params wip_logger.param_tbl_t;

977: wei_group_id NUMBER;
978: n_undeleted_records NUMBER ;
979:
980: --variables for WIP_logger
981: l_params wip_logger.param_tbl_t;
982: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
983: l_returnStatus VARCHAR2(1);
984: x_return_status VARCHAR2(255);
985:

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

995:
996: if (l_logLevel <= wip_constants.trace_logging) then
997: l_params(1).paramName := 'p_wei_group_id ';
998: l_params(1).paramValue := p_wei_group_id ;
999: wip_logger.entryPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1000: p_params => l_params,
1001: x_returnStatus => x_return_status);
1002:
1003: if(x_return_status <> fnd_api.g_ret_sts_success) then

Line 1015: wip_logger.log(

1011: /*-------------------------------------------+
1012: | If in debug mode, print out parameters |
1013: +-------------------------------------------+*/
1014: if (l_logLevel <= wip_constants.full_logging) then
1015: wip_logger.log(
1016: 'Dbg: In delete_interface_orders function', l_returnStatus);
1017: wip_logger.log( 'Dbg:wei_group_id = '||wei_group_id, l_returnStatus);
1018: END IF;
1019:

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

1013: +-------------------------------------------+*/
1014: if (l_logLevel <= wip_constants.full_logging) then
1015: wip_logger.log(
1016: 'Dbg: In delete_interface_orders function', l_returnStatus);
1017: wip_logger.log( 'Dbg:wei_group_id = '||wei_group_id, l_returnStatus);
1018: END IF;
1019:
1020: /*
1021: * Clean up the interface table and interface errors table.

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

1068: END IF;
1069:
1070:
1071: if (l_logLevel <= wip_constants.full_logging) then
1072: wip_logger.log('Dbg:'||SQL%ROWCOUNT||' records deleted from interface', l_returnStatus);
1073:
1074: SELECT COUNT(*) INTO n_undeleted_records
1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1076:

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

1074: SELECT COUNT(*) INTO n_undeleted_records
1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;

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

1075: FROM WIP_JOB_SCHEDULE_INTERFACE WHERE GROUP_ID = wei_group_id ;
1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083:

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

1076:
1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083:
1084: wip_logger.log(

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

1077: if(n_undeleted_records <> 0) THEN
1078: wip_logger.log('Dbg:Note: '||n_undeleted_records||' error/unprocessed records remain', l_returnStatus);
1079: wip_logger.log('Dbg:for WIP_JOB_SCHEDULE_INTERFACE.GROUP_ID='||wei_group_id||'.', l_returnStatus);
1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083:
1084: wip_logger.log(
1085: 'Dbg:Success in delete_interface_orders', l_returnStatus);

Line 1084: wip_logger.log(

1080: wip_logger.log('Dbg:Join on INTERFACE_ID with WIP_INTERFACE_ERRORS', l_returnStatus);
1081: wip_logger.log('Dbg:for details.', l_returnStatus);
1082: END IF;
1083:
1084: wip_logger.log(
1085: 'Dbg:Success in delete_interface_orders', l_returnStatus);
1086: END IF;
1087:
1088: -- write to the log file

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

1086: END IF;
1087:
1088: -- write to the log file
1089: IF (l_logLevel <= wip_constants.trace_logging) THEN
1090: wip_logger.exitPoint(p_procName => 'WIP_ATO_JOBS_PRIV.DELETE_INTERFACE_ORDERS',
1091: p_procReturnStatus => l_returnStatus,
1092: p_msg => 'PROCEDURE COMPLETE.',
1093: x_returnStatus => l_returnStatus);
1094: END IF;

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

1098:
1099: EXCEPTION
1100: WHEN OTHERS THEN
1101: if (l_logLevel <= wip_constants.full_logging) then
1102: wip_logger.log( 'Dbg:SQL error in delete_interface_orders', l_returnStatus);
1103: END IF;
1104: return(FALSE);
1105:
1106: /* end of delete_interface_orders */