eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_ATO_JOBS_PRIV dependencies on FND_FILE

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

115: -- Initialize API return status to success
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117:
118: select userenv('SESSIONID') into l_audsid from dual;
119: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
120:
121: fnd_message.set_name('FND', 'CONC-PARAMETERS');
122: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);
123:

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

118: select userenv('SESSIONID') into l_audsid from dual;
119: -- fnd_file.log('AUDSID of current session: ' || l_audsid);
120:
121: fnd_message.set_name('FND', 'CONC-PARAMETERS');
122: fnd_file.put_line(which => fnd_file.log, buff => 'AUDSID of current session: ' || l_audsid);
123:
124: IF (fnd_profile.value('MRP_DEBUG') = 'Y') THEN
125: DEBUG_FLAG := TRUE;
126: ELSE

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 133: fnd_file.put_line(fnd_file.log, 'Logging......');

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 ';
137: l_params(2).paramValue := P_DUMMY_FIELD ;

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 170: fnd_file.get_names(log_file, output_file);

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
174: wip_logger.log('ORDER_NUMBER = '||P_ORDER_NUMBER , l_returnStatus);

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

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:
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

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:
643: l_status := CTO_WIP_WRAPPER.get_order_lines(
644: l_org_id,

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

657: l_wip_group_id,
658: l_message_name,
659: l_message_text);
660:
661: fnd_file.put_line(which => fnd_file.log, buff => 'Return status from CTO_WIP_WRAPPER.get_order_lines:'|| l_status);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Group_Id from CTO_WIP_WRAPPER.get_order_lines: '|| l_wip_group_id);
663:
664: --p_wei_group_id := l_wip_group_id;
665: --p_orders_to_load := l_orders_loaded; /* order lines */

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

658: l_message_name,
659: l_message_text);
660:
661: fnd_file.put_line(which => fnd_file.log, buff => 'Return status from CTO_WIP_WRAPPER.get_order_lines:'|| l_status);
662: fnd_file.put_line(which => fnd_file.log, buff => 'Group_Id from CTO_WIP_WRAPPER.get_order_lines: '|| l_wip_group_id);
663:
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;

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

679: else
680: if (L_orders_loaded = 0) then
681: --start bugfix 4865485
682: p_all_success_ptr := -1;
683: fnd_file.put_line(which => fnd_file.log, buff => 'L_orders_loaded=> '|| l_orders_loaded);
684: RETCODE := 1;--for warning
685: RETURN false;
686: --end bugfix 4865485
687: null; --goto done;

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

694: | jobs for records loaded into the interface table. |
695: | |
696: | Calling MASSLOAD PL/SQL Routine |
697: +---------------------------------------------------------+*/
698: fnd_file.put_line(which => fnd_file.log, buff => 'Calling wip_massload_pub.massLoadJobs with group Id: '|| l_wip_group_id);
699:
700: wip_massload_pub.massLoadJobs(
701: p_groupID => l_wip_group_id,
702: p_validationLevel => 2,

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

703: p_commitFlag => 1, --commit in Massload
704: x_returnStatus => retCode,
705: x_errorMsg => errBuf);
706:
707: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
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:

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

706:
707: fnd_file.put_line(which => fnd_file.log, buff => 'Returned from wip_massload_pub.massLoadJobs:');
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;

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

715:
716: APP_EXCEPTION.RAISE_EXCEPTION;
717: END IF;
718:
719: fnd_file.put_line(which => fnd_file.log, buff => 'Returned successfully from wip_massload_pub.massLoadJobs.');
720:
721: END IF; /* end of logic skipped when failed_req_id <> -1 */
722:
723: /*================================================================+

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

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

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

826: ||'; P_qty_precision='||precision_profile, l_returnStatus);
827: END IF;
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

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

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 :=
845: FND_REQUEST.SUBMIT_REQUEST('WIP','WIPDJATO',
846: '',

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

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
875: wip_logger.log('Could not execute report.', l_returnStatus);
876: END IF;

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

881:
882: /* wait for report to finish */
883: WAIT_CONC_PROGRAM(report_status,ERRBUF,report_retcode);
884:
885: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assemble to Order Massload Report return code : '||report_retcode);
886: /* report returns with error or waning */
887: if (report_retcode <> -1 ) then
888: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report has errored or has a warning');
889: errbuf := fnd_message.get;

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

884:
885: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assemble to Order Massload Report return code : '||report_retcode);
886: /* report returns with error or waning */
887: if (report_retcode <> -1 ) 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

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

919: if (L_FAILED_REQ_ID = -1) THEN
920: if (l_orders_loaded = 0) THEN
921: FND_MESSAGE.SET_NAME('WIP', 'WIP_NO_ORDERS_TO_LOAD');
922: ERRBUF := FND_MESSAGE.GET;
923: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);
924: END IF;
925: if (l_orders_in_interface = 0) THEN
926: FND_MESSAGE.SET_NAME ('WIP', 'WIP_NO_ORDERS_IN_INTERFACE');
927: ERRBUF := FND_MESSAGE.GET;

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

924: END IF;
925: if (l_orders_in_interface = 0) THEN
926: FND_MESSAGE.SET_NAME ('WIP', 'WIP_NO_ORDERS_IN_INTERFACE');
927: ERRBUF := FND_MESSAGE.GET;
928: fnd_file.put_line(FND_FILE.OUTPUT,errbuf);
929: END IF;
930: END IF;
931:
932: