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 130: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'

126: ELSE
127: DEBUG_FLAG := FALSE;
128: END IF;
129:
130: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
131: ||wip_constants.trace_logging);
132: if (l_logLevel <= wip_constants.trace_logging) then
133: fnd_file.put_line(fnd_file.log, 'Logging......');
134: l_params(1).paramName := 'P_ORDER_NUMBER ';

Line 131: ||wip_constants.trace_logging);

127: DEBUG_FLAG := FALSE;
128: END IF;
129:
130: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
131: ||wip_constants.trace_logging);
132: if (l_logLevel <= wip_constants.trace_logging) then
133: fnd_file.put_line(fnd_file.log, 'Logging......');
134: l_params(1).paramName := 'P_ORDER_NUMBER ';
135: l_params(1).paramValue := P_ORDER_NUMBER ;

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

128: END IF;
129:
130: fnd_file.put_line(fnd_file.log, 'l_logLevel :'||l_logLevel ||'; wip_constants.trace_logging:'
131: ||wip_constants.trace_logging);
132: if (l_logLevel <= wip_constants.trace_logging) then
133: fnd_file.put_line(fnd_file.log, 'Logging......');
134: l_params(1).paramName := 'P_ORDER_NUMBER ';
135: l_params(1).paramValue := P_ORDER_NUMBER ;
136: l_params(2).paramName := 'P_DUMMY_FIELD ';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

533: DEBUG_FLAG := FALSE;
534: END IF;
535:
536:
537: if (l_logLevel <= wip_constants.trace_logging) then
538: l_params(1).paramName := 'P_ORDER_NUMBER ';
539: l_params(1).paramValue := P_ORDER_NUMBER ;
540: l_params(2).paramName := 'P_DUMMY_FIELD ';
541: l_params(2).paramValue := P_DUMMY_FIELD ;

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

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

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

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

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

664: --p_wei_group_id := l_wip_group_id;
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);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

888: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
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;

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

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

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

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

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

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

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

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

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

992: DEBUG_FLAG := FALSE;
993: END IF;
994:
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,

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

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

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

1029: * non-problem records while in debug mode hopefully represents the
1030: * final fix for bug 775437 and its predecessors.
1031: */
1032:
1033: if (l_logLevel <= wip_constants.full_logging) then
1034:
1035: /* bugfix 4289455 : Remove the records from WIE since we are deleting WJSI record
1036: with process phase and process status COMPLETE else these may remain orphan */
1037: DELETE FROM WIP_INTERFACE_ERRORS

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

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

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

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

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

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