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_TIME_ENTRY_PUB dependencies on WIP_WS_UTIL

Line 52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);

48: into l_org_code
49: from mtl_parameters
50: where organization_id = p_organization_id;
51:
52: wip_ws_util.trace_log('Launching Import Time Entry Records for Organization: '||l_org_code);
53:
54: g_user_id := fnd_global.user_id;
55: g_user_login_id := fnd_global.login_id;
56: g_program_appl_id := fnd_global.prog_appl_id;

Line 100: wip_ws_util.trace_log(l_err_msg);

96: where mp.organization_id = p_organization_id));
97:
98: l_status := sql%rowcount;
99: if l_status>0 then
100: wip_ws_util.trace_log(l_err_msg);
101: end if;
102:
103: when no_data_found then
104: l_valid_shift_pref := true;

Line 145: wip_ws_util.trace_log(l_err_msg);

141:
142: l_count := sql%rowcount;
143: l_status := l_status+l_count;
144: if l_count >0 then
145: wip_ws_util.trace_log(l_err_msg);
146: end if;
147:
148: when no_data_found then
149: l_valid_clock_pref := true;

Line 184: wip_ws_util.trace_log(l_err_msg);

180:
181: l_count := sql%rowcount;
182: l_status := l_status+l_count;
183: if l_count >0 then
184: wip_ws_util.trace_log(l_err_msg);
185: end if;
186:
187: end if;
188: l_stmt_num := 40;

Line 215: wip_ws_util.trace_log(l_err_msg);

211:
212: l_count := sql%rowcount;
213: l_status := l_status+l_count;
214: if l_count >0 then
215: wip_ws_util.trace_log(l_err_msg);
216: end if;
217:
218: end if;
219: l_stmt_num := 50;

Line 266: wip_ws_util.trace_log('Launching Process to import the records');

262:
263: l_stmt_num := 70;
264:
265: if (g_logLevel <= wip_constants.trace_logging) then
266: wip_ws_util.trace_log('Launching Process to import the records');
267: end if;
268:
269: process( p_wip_time_intf_tbl => v_wip_time_intf,
270: x_ret_status => l_return_status);

Line 275: wip_ws_util.trace_log('Returned from Process after importing the records');

271:
272: l_stmt_num := 80;
273:
274: if (g_logLevel <= wip_constants.trace_logging) then
275: wip_ws_util.trace_log('Returned from Process after importing the records');
276: end if;
277:
278: commit;
279:

Line 283: wip_ws_util.trace_log(errbuf);

279:
280: if l_return_status = 1 and l_status =0 then
281: retcode :=1;
282: errbuf := 'The Import program successfully imported all records';
283: wip_ws_util.trace_log(errbuf);
284: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',errbuf);
285: else
286: retcode := 1;
287: errbuf := 'The Import program marked at least one row as errored';

Line 288: wip_ws_util.trace_log(errbuf);

284: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',errbuf);
285: else
286: retcode := 1;
287: errbuf := 'The Import program marked at least one row as errored';
288: wip_ws_util.trace_log(errbuf);
289: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
290: end if;
291:
292: exception

Line 296: wip_ws_util.trace_log(errbuf);

292: exception
293: when e_null_org_id then
294: retcode := -1;
295: errbuf := 'Organization parameter cannot be null';
296: wip_ws_util.trace_log(errbuf);
297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
298: when others then
299: retcode := -1;
300: errbuf := 'Errors encountered in interface txn, please check the log file.';

Line 301: wip_ws_util.trace_log(errbuf);

297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
298: when others then
299: retcode := -1;
300: errbuf := 'Errors encountered in interface txn, please check the log file.';
301: wip_ws_util.trace_log(errbuf);
302: wip_ws_util.trace_log(sqlerrm(sqlcode));
303: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
304: end process_interface_records;
305:

Line 302: wip_ws_util.trace_log(sqlerrm(sqlcode));

298: when others then
299: retcode := -1;
300: errbuf := 'Errors encountered in interface txn, please check the log file.';
301: wip_ws_util.trace_log(errbuf);
302: wip_ws_util.trace_log(sqlerrm(sqlcode));
303: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
304: end process_interface_records;
305:
306: procedure get_time_preferences(p_organization_id IN NUMBER default null,

Line 439: wip_ws_util.trace_log('Beginning to process interface records');

435: ins_counter := 1;
436: l_stmt_num :=20;
437:
438: if (g_logLevel <= wip_constants.trace_logging) then
439: wip_ws_util.trace_log('Beginning to process interface records');
440: end if;
441:
442: while l_counter is not null loop
443: if l_wip_time_intf_tbl(l_counter).actual_start_date is null or

Line 451: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

447: fnd_message.set_name('WIP','WIP_TIME_IMPORT_DATE_NULL');
448: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
449: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
450: l_error_count := l_error_count +1;
451: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
452: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
453: goto skip_validations;
454: end if;
455: l_stmt_num :=35;

Line 464: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

460: fnd_message.set_name('WIP','WIP_SAH_ONLY_ADJUSTMENT');
461: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
462: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
463: l_error_count := l_error_count +1;
464: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
465: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
466: goto skip_validations;
467: end if;
468:

Line 482: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

478: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
479: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.warning;
480: l_error_count := l_error_count +1;
481: if (g_logLevel <= wip_constants.trace_logging) then
482: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
483: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
484: end if;
485: end if;
486: l_stmt_num :=50;

Line 492: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

488: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');
489: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
490: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
491: l_error_count := l_error_count +1;
492: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
493: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
494: goto skip_validations;
495: end if;
496: l_stmt_num :=60;

Line 505: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

501: fnd_message.set_name('WIP','WIP_INVALID_EMP_DETAILS');
502: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
503: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
504: l_error_count := l_error_count +1;
505: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
506: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
507: goto skip_validations;
508: end if;
509: l_stmt_num :=70;

Line 518: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

514: fnd_message.set_name('WIP','WIP_NO_JOB_DETAILS');
515: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
516: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
517: l_error_count := l_error_count +1;
518: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
519: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
520: goto skip_validations;
521: elsif l_wip_time_intf_tbl(l_counter).wip_entity_id is null and
522: l_wip_time_intf_tbl(l_counter).job_name is not null then

Line 533: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

529: fnd_message.set_name('WIP','WIP_INVALID_JOB_DETAILS');
530: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
531: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
532: l_error_count := l_error_count +1;
533: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
534: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
535: goto skip_validations;
536: end if;
537: l_stmt_num :=100;

Line 543: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

539: fnd_message.set_name('WIP','WIP_JOB_OP_NULL');
540: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
541: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
542: l_error_count := l_error_count +1;
543: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
544: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
545: goto skip_validations;
546: else
547: l_stmt_num :=110;

Line 556: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

552: fnd_message.set_name('WIP','WIP_INVALID_JOB_OP');
553: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
554: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
555: l_error_count := l_error_count +1;
556: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
557: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
558: goto skip_validations;
559: end if;
560: end if;

Line 569: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

565: fnd_message.set_name('WIP','WIP_NO_RES_DETAILS');
566: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
567: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
568: l_error_count := l_error_count +1;
569: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
570: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
571: goto skip_validations;
572: elsif l_wip_time_intf_tbl(l_counter).resource_id is null and
573: l_wip_time_intf_tbl(l_counter).resource_code is not null and

Line 593: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

589: fnd_message.set_name('WIP','WIP_INVALID_RES_DETAILS');
590: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
591: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
592: l_error_count := l_error_count +1;
593: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
594: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
595: goto skip_validations;
596: end if;
597: l_stmt_num :=140;

Line 603: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

599: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');
600: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
601: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
602: l_error_count := l_error_count +1;
603: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
604: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
605: goto skip_validations;
606: end if;
607: l_stmt_num :=150;

Line 616: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

612: fnd_message.set_name('WIP','WIP_INVALID_EMP_DETAILS');
613: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
614: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
615: l_error_count := l_error_count +1;
616: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
617: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
618: goto skip_validations;
619: end if;
620: l_stmt_num :=160;

Line 626: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

622: fnd_message.set_name('WIP','WIP_INVALID_TIME_TYPE');
623: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
624: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
625: l_error_count := l_error_count +1;
626: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
627: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
628: goto skip_validations;
629: end if;
630: l_stmt_num :=180;

Line 641: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||

637: fnd_message.set_name('WIP','WIP_INVALID_TIME_UOM');
638: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
639: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
640: l_error_count := l_error_count +1;
641: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
642: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
643: goto skip_validations;
644: end if;
645:

Line 670: wip_ws_util.trace_log('Completed validations for record in Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);

666: l_wip_time_intf_tbl(l_counter).uom_code := l_bom_hr_uom;
667: end if;
668:
669: if (g_logLevel <= wip_constants.trace_logging) then
670: wip_ws_util.trace_log('Completed validations for record in Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
671: end if;
672:
673: l_stmt_num :=200;
674: <>

Line 719: wip_ws_util.trace_log('Before Inserting records in Actual Times Table');

715: l_counter := l_wip_time_intf_tbl.next(l_counter);
716: end loop;
717:
718: if (g_logLevel <= wip_constants.trace_logging) then
719: wip_ws_util.trace_log('Before Inserting records in Actual Times Table');
720: end if;
721:
722: -- insert into wip_resource_actual_times table
723: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last

Line 727: wip_ws_util.trace_log('After Inserting records in Actual Times Table');

723: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
724: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
725:
726: if (g_logLevel <= wip_constants.trace_logging) then
727: wip_ws_util.trace_log('After Inserting records in Actual Times Table');
728: end if;
729:
730: -- update back wip_time_entry_interface table
731: forall upd_index in v_interface_id.first..v_interface_id.last

Line 740: wip_ws_util.trace_log('After Updating status for records in Interface Table');

736: last_update_date = sysdate
737: where interface_id = v_interface_id(upd_index);
738:
739: if (g_logLevel <= wip_constants.trace_logging) then
740: wip_ws_util.trace_log('After Updating status for records in Interface Table');
741: end if;
742:
743: if l_error_count > 0 then
744: x_ret_status := -1;

Line 897: l_value := wip_ws_util.get_preference_value_code(p_pref_id => 26,

893: into l_org_id
894: from wip_entities
895: where wip_entity_id = p_wip_entity_id;
896:
897: l_value := wip_ws_util.get_preference_value_code(p_pref_id => 26,
898: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
899: p_org_id => l_org_id,
900: p_dept_id => null);
901: l_shift_value := to_number(l_value)/10;

Line 898: p_resp_key => WIP_WS_UTIL.get_current_resp_key,

894: from wip_entities
895: where wip_entity_id = p_wip_entity_id;
896:
897: l_value := wip_ws_util.get_preference_value_code(p_pref_id => 26,
898: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
899: p_org_id => l_org_id,
900: p_dept_id => null);
901: l_shift_value := to_number(l_value)/10;
902: if l_shift_value >= 2 then