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 288: wip_ws_util.trace_log('Launching Process to import the records');

284:
285: l_stmt_num := 70;
286:
287: if (g_logLevel <= wip_constants.trace_logging) then
288: wip_ws_util.trace_log('Launching Process to import the records');
289: end if;
290:
291: process( p_wip_time_intf_tbl => v_wip_time_intf,
292: x_ret_status => l_return_status);

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

293:
294: l_stmt_num := 80;
295:
296: if (g_logLevel <= wip_constants.trace_logging) then
297: wip_ws_util.trace_log('Returned from Process after importing the records');
298: end if;
299:
300: commit;
301:

Line 305: wip_ws_util.trace_log(errbuf);

301:
302: if l_return_status = 1 and l_status =0 then
303: retcode :=1;
304: errbuf := 'The Import program successfully imported all records';
305: wip_ws_util.trace_log(errbuf);
306: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',errbuf);
307: else
308: retcode := 1;
309: errbuf := 'The Import program marked at least one row as errored';

Line 310: wip_ws_util.trace_log(errbuf);

306: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',errbuf);
307: else
308: retcode := 1;
309: errbuf := 'The Import program marked at least one row as errored';
310: wip_ws_util.trace_log(errbuf);
311: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',errbuf);
312: end if;
313:
314: exception

Line 318: wip_ws_util.trace_log(errbuf);

314: exception
315: when e_null_org_id then
316: retcode := -1;
317: errbuf := 'Organization parameter cannot be null';
318: wip_ws_util.trace_log(errbuf);
319: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
320: when others then
321: retcode := -1;
322: errbuf := 'Errors encountered in interface txn, please check the log file.';

Line 323: wip_ws_util.trace_log(errbuf);

319: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
320: when others then
321: retcode := -1;
322: errbuf := 'Errors encountered in interface txn, please check the log file.';
323: wip_ws_util.trace_log(errbuf);
324: wip_ws_util.trace_log(sqlerrm(sqlcode));
325: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
326: end process_interface_records;
327:

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

320: when others then
321: retcode := -1;
322: errbuf := 'Errors encountered in interface txn, please check the log file.';
323: wip_ws_util.trace_log(errbuf);
324: wip_ws_util.trace_log(sqlerrm(sqlcode));
325: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',errbuf);
326: end process_interface_records;
327:
328: procedure get_time_preferences(p_organization_id IN NUMBER default null,

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

482: ins_counter := 1;
483: l_stmt_num :=20;
484:
485: if (g_logLevel <= wip_constants.trace_logging) then
486: wip_ws_util.trace_log('Beginning to process interface records');
487: end if;
488:
489: while l_counter is not null loop
490: l_instance_id := null;

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

495: fnd_message.set_name('WIP','WIP_TIME_IMPORT_DATE_NULL');
496: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
497: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
498: l_error_count := l_error_count +1;
499: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
500: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
501: goto skip_validations;
502: end if;
503: l_stmt_num :=35;

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

508: fnd_message.set_name('WIP','WIP_SAH_ONLY_ADJUSTMENT');
509: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
510: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
511: l_error_count := l_error_count +1;
512: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
513: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
514: goto skip_validations;
515: end if;
516:

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

526: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
527: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.warning;
528: l_error_count := l_error_count +1;
529: if (g_logLevel <= wip_constants.trace_logging) then
530: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
531: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
532: end if;
533: end if;
534: l_stmt_num :=50;

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

536: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');
537: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
538: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
539: l_error_count := l_error_count +1;
540: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
541: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
542: goto skip_validations;
543: end if;
544: l_stmt_num :=60;

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

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

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

562: fnd_message.set_name('WIP','WIP_NO_JOB_DETAILS');
563: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
564: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
565: l_error_count := l_error_count +1;
566: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
567: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
568: goto skip_validations;
569: elsif l_wip_time_intf_tbl(l_counter).wip_entity_id is null and
570: l_wip_time_intf_tbl(l_counter).job_name is not null then

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

577: fnd_message.set_name('WIP','WIP_INVALID_JOB_DETAILS');
578: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
579: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
580: l_error_count := l_error_count +1;
581: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
582: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
583: goto skip_validations;
584: end if;
585: l_stmt_num :=100;

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

587: fnd_message.set_name('WIP','WIP_JOB_OP_NULL');
588: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
589: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
590: l_error_count := l_error_count +1;
591: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
592: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
593: goto skip_validations;
594: else
595: l_stmt_num :=110;

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

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

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

613: fnd_message.set_name('WIP','WIP_NO_RES_DETAILS');
614: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
615: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
616: l_error_count := l_error_count +1;
617: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
618: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
619: goto skip_validations;
620: elsif l_wip_time_intf_tbl(l_counter).resource_id is null and
621: l_wip_time_intf_tbl(l_counter).resource_code is not null and

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

643: fnd_message.set_name('WIP','WIP_INVALID_RES_DETAILS');
644: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
645: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
646: l_error_count := l_error_count +1;
647: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
648: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
649: goto skip_validations;
650: end if;
651: l_stmt_num :=140;

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

653: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');
654: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
655: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
656: l_error_count := l_error_count +1;
657: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
658: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
659: goto skip_validations;
660: end if;
661: l_stmt_num :=150;

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

666: fnd_message.set_name('WIP','WIP_INVALID_EMP_DETAILS');
667: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
668: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
669: l_error_count := l_error_count +1;
670: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
671: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
672: goto skip_validations;
673: end if;
674: l_stmt_num :=160;

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

688: fnd_message.set_name('WIP','WIP_INVALID_TIME_TYPE');
689: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
690: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
691: l_error_count := l_error_count +1;
692: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
693: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
694: goto skip_validations;
695: end if;
696: l_stmt_num :=180;

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

703: fnd_message.set_name('WIP','WIP_INVALID_TIME_UOM');
704: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;
705: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;
706: l_error_count := l_error_count +1;
707: wip_ws_util.trace_log('Error Importing record '||'( stmt_num: '||l_stmt_num||') '||
708: l_wip_time_intf_tbl(l_counter).error||' for Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
709: goto skip_validations;
710: end if;
711:

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

732: l_wip_time_intf_tbl(l_counter).uom_code := l_bom_hr_uom;
733: end if;
734:
735: if (g_logLevel <= wip_constants.trace_logging) then
736: wip_ws_util.trace_log('Completed validations for record in Intf Id: '||l_wip_time_intf_tbl(l_counter).interface_id);
737: end if;
738:
739: l_stmt_num :=200;
740: -- Defaulted instance_id for Imported Clock-in records since Labor metrics program relies on instance_id for metrics calculation.

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

783: l_counter := l_wip_time_intf_tbl.next(l_counter);
784: end loop;
785:
786: if (g_logLevel <= wip_constants.trace_logging) then
787: wip_ws_util.trace_log('Before Inserting records in Actual Times Table');
788: end if;
789:
790: -- insert into wip_resource_actual_times table
791: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last

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

791: forall ins_index in v_wip_res_actual_times.first..v_wip_res_actual_times.last
792: INSERT into WIP_RESOURCE_ACTUAL_TIMES values v_wip_res_actual_times(ins_index);
793:
794: if (g_logLevel <= wip_constants.trace_logging) then
795: wip_ws_util.trace_log('After Inserting records in Actual Times Table');
796: end if;
797:
798: -- update back wip_time_entry_interface table
799: forall upd_index in v_interface_id.first..v_interface_id.last

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

804: last_update_date = sysdate
805: where interface_id = v_interface_id(upd_index);
806:
807: if (g_logLevel <= wip_constants.trace_logging) then
808: wip_ws_util.trace_log('After Updating status for records in Interface Table');
809: end if;
810:
811: if l_error_count > 0 then
812: x_ret_status := -1;

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

961: into l_org_id
962: from wip_entities
963: where wip_entity_id = p_wip_entity_id;
964:
965: l_value := wip_ws_util.get_preference_value_code(p_pref_id => 26,
966: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
967: p_org_id => l_org_id,
968: p_dept_id => null);
969: l_shift_value := to_number(l_value)/10;

Line 966: p_resp_key => WIP_WS_UTIL.get_current_resp_key,

962: from wip_entities
963: where wip_entity_id = p_wip_entity_id;
964:
965: l_value := wip_ws_util.get_preference_value_code(p_pref_id => 26,
966: p_resp_key => WIP_WS_UTIL.get_current_resp_key,
967: p_org_id => l_org_id,
968: p_dept_id => null);
969: l_shift_value := to_number(l_value)/10;
970: if l_shift_value >= 2 then