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_CONSTANTS

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 187: ||wip_constants.trace_logging);

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);
191: fnd_file.put_line(which => fnd_file.log, buff => 'Offset Days: ' || P_OFFSET_DAYS);

Line 188: if (l_logLevel <= wip_constants.trace_logging) then

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);
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);

Line 238: if (l_logLevel <= wip_constants.full_logging) then

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);
242: wip_logger.log('P_LOAD_TYPE = '||P_LOAD_TYPE , l_returnStatus);

Line 314: if (l_logLevel <= wip_constants.full_logging) then

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);
317: else
318: wip_logger.log( 'BATCH STR = '||L_BATCH_ID||'.', l_returnStatus);

Line 337: if (l_logLevel <= wip_constants.full_logging) then

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 */
340: if (batch_mode_flag = true) then
341: wip_logger.log('Currently in Batch Mode. Failed_req_id contains the batch_id.', l_returnStatus);

Line 396: if (l_logLevel <= wip_constants.full_logging) then

392: /*-------------------------------------+
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;

Line 407: if (l_logLevel <= wip_constants.full_logging) then

403: if (l_all_records_success <> -1) then
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

Line 411: if (l_logLevel <= wip_constants.full_logging) then

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(
413: 'Dbg:Exiting Sales Order Loaded w/warning', l_returnStatus);
414: end if;
415: --Put Warnings in Error Buffer

Line 422: IF (l_logLevel <= wip_constants.trace_logging) THEN

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

Line 454: IF (l_logLevel <= wip_constants.trace_logging) THEN

450: IF(ERRBUF IS NULL) THEN
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,

Line 623: if (l_logLevel <= wip_constants.trace_logging) then

619: DEBUG_FLAG := FALSE;
620: END IF;
621:
622:
623: if (l_logLevel <= wip_constants.trace_logging) then
624: l_params(1).paramName := 'P_ORDER_NUMBER ';
625: l_params(1).paramValue := P_ORDER_NUMBER ;
626: l_params(2).paramName := 'P_DUMMY_FIELD ';
627: l_params(2).paramValue := P_DUMMY_FIELD ;

Line 673: if (l_logLevel <= wip_constants.full_logging) then

669:
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);

Line 714: if (l_logLevel <= wip_constants.full_logging) then

710: | wip_job_schedule_interface. Just perform the feedback loop. |
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;

Line 781: if (l_logLevel <= wip_constants.full_logging) then

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;
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);

Line 825: if (l_logLevel <= wip_constants.full_logging) then

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;
828:
829: -- Bug 9314772.Should not raise exception here so that reservations

Line 846: and process_phase = WIP_CONSTANTS.ML_COMPLETE

842: where exists
843: ( select source_line_id
844: from wip_job_schedule_interface
845: where group_id = l_wip_group_id
846: and process_phase = WIP_CONSTANTS.ML_COMPLETE
847: and process_status in (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
848: );
849: exception
850: when others then

Line 847: and process_status in (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)

843: ( select source_line_id
844: from wip_job_schedule_interface
845: where group_id = l_wip_group_id
846: and process_phase = WIP_CONSTANTS.ML_COMPLETE
847: and process_status in (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
848: );
849: exception
850: when others then
851: l_line_count := 0;

Line 896: if (l_logLevel <= wip_constants.full_logging) then

892: +===============================================================+*/
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 */

Line 904: if (l_logLevel <= wip_constants.full_logging) then

900: END IF; /* End of Logic for Clean up Mode */
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,

Line 912: if (l_logLevel <= wip_constants.full_logging) then

908: l_status := CTO_WIP_WRAPPER.reserve_wo_to_so(l_wip_group_id,
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

Line 945: if (l_logLevel <= wip_constants.full_logging) then

941: if (num_error_records > 0) THEN
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');

Line 975: if (l_logLevel <= wip_constants.full_logging) then

971:
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:

Line 1025: if (l_logLevel <= wip_constants.full_logging) then

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;
1029:

Line 1043: if (l_logLevel <= wip_constants.full_logging) 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
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;

Line 1054: if (l_logLevel <= wip_constants.full_logging) then

1050:
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;

Line 1064: if (l_logLevel <= wip_constants.full_logging) then

1060:
1061: /*--------------------------------------------------------+
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;

Line 1085: IF (l_logLevel <= wip_constants.trace_logging) THEN

1081: END IF;
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);

Line 1105: if (l_logLevel <= wip_constants.full_logging) then

1101:
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;

Line 1147: if (l_logLevel <= wip_constants.trace_logging) then

1143: DEBUG_FLAG := FALSE;
1144: END IF;
1145:
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,

Line 1165: if (l_logLevel <= wip_constants.full_logging) then

1161:
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;

Line 1185: --if (l_logLevel <= wip_constants.full_logging) then

1181: * final fix for bug 775437 and its predecessors.
1182: */
1183:
1184: --Bugfix 10636184: Controlling the delete by MRP profile instead of FND profile
1185: --if (l_logLevel <= wip_constants.full_logging) then
1186: IF (NOT DEBUG_FLAG) THEN
1187: --Bugfix 10636184: If MRP: Debug is OFF, then remove only successfully completed records
1188: --from the interface table.
1189:

Line 1234: if (l_logLevel <= wip_constants.full_logging) then

1230:
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 ;

Line 1252: IF (l_logLevel <= wip_constants.trace_logging) THEN

1248: 'Dbg:Success in delete_interface_orders', l_returnStatus);
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);

Line 1264: if (l_logLevel <= wip_constants.full_logging) then

1260:
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: