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_CONSTANTS

Line 34: where process_status = wip_constants.running

30:
31: cursor running_intf_records(org_id Number) is
32: select *
33: from wip_time_entry_interface
34: where process_status = wip_constants.running
35: and organization_id = org_id;
36:
37: e_null_org_id exception;
38:

Line 81: set process_status = wip_constants.error,

77: fnd_message.set_token('ORG', to_char(l_org_code));
78: l_err_msg := fnd_message.get;
79:
80: update wip_time_entry_interface
81: set process_status = wip_constants.error,
82: error = l_err_msg,
83: request_id = g_request_id,
84: program_id = g_program_id,
85: program_application_id = g_program_appl_id,

Line 92: and process_status = wip_constants.pending

88: last_update_date = sysdate,
89: last_update_login = g_user_login_id
90: where
91: time_entry_type = 1
92: and process_status = wip_constants.pending
93: and (organization_id = p_organization_id or
94: organization_code = (select mp.organization_code
95: from mtl_parameters mp
96: where mp.organization_id = p_organization_id));

Line 125: set process_status = wip_constants.error,

121: fnd_message.set_token('ORG', to_char(l_org_code));
122: l_err_msg := fnd_message.get;
123:
124: update wip_time_entry_interface
125: set process_status = wip_constants.error,
126: error = l_err_msg,
127: request_id = g_request_id,
128: program_id = g_program_id,
129: program_application_id = g_program_appl_id,

Line 136: and process_status = wip_constants.pending

132: last_update_date = sysdate,
133: last_update_login = g_user_login_id
134: where
135: time_entry_type = 3
136: and process_status = wip_constants.pending
137: and (organization_id = p_organization_id or
138: organization_code = (select mp.organization_code
139: from mtl_parameters mp
140: where mp.organization_id = p_organization_id));

Line 164: set process_status = wip_constants.error,

160: fnd_message.set_name('WIP','WIP_AAH_IMPORT_NOT_ALLOWED');
161: l_err_msg := fnd_message.get;
162:
163: update wip_time_entry_interface
164: set process_status = wip_constants.error,
165: error = l_err_msg,
166: request_id = g_request_id,
167: program_id = g_program_id,
168: program_application_id = g_program_appl_id,

Line 175: and process_status = wip_constants.pending

171: last_update_date = sysdate,
172: last_update_login = g_user_login_id
173: where
174: time_entry_type = 1
175: and process_status = wip_constants.pending
176: and (organization_id = p_organization_id or
177: organization_code = (select mp.organization_code
178: from mtl_parameters mp
179: where mp.organization_id = p_organization_id));

Line 195: set process_status = wip_constants.error,

191: fnd_message.set_name('WIP','WIP_DLH_IMPORT_NOT_ALLOWED');
192: l_err_msg := fnd_message.get;
193:
194: update wip_time_entry_interface
195: set process_status = wip_constants.error,
196: error = l_err_msg,
197: request_id = g_request_id,
198: program_id = g_program_id,
199: program_application_id = g_program_appl_id,

Line 206: and process_status = wip_constants.pending

202: last_update_date = sysdate,
203: last_update_login = g_user_login_id
204: where
205: time_entry_type = 3
206: and process_status = wip_constants.pending
207: and (organization_id = p_organization_id or
208: organization_code = (select mp.organization_code
209: from mtl_parameters mp
210: where mp.organization_id = p_organization_id));

Line 222: set process_status = wip_constants.running,

218: end if;
219: l_stmt_num := 50;
220:
221: update wip_time_entry_interface
222: set process_status = wip_constants.running,
223: organization_id = nvl(organization_id,p_organization_id),
224: request_id = fnd_global.conc_request_id,
225: program_id = fnd_global.conc_program_id,
226: program_application_id = fnd_global.prog_appl_id,

Line 232: process_status = wip_constants.pending

228: last_updated_by = fnd_global.user_id,
229: last_update_date = sysdate,
230: last_update_login = fnd_global.login_id
231: where
232: process_status = wip_constants.pending
233: and (organization_id = p_organization_id or
234: organization_code = (select mp.organization_code
235: from mtl_parameters mp
236: where mp.organization_id = p_organization_id));

Line 253: wtei.process_status = wip_constants.running and

249: ),
250: wtei.last_update_date = sysdate
251: where
252: wtei.organization_id = p_organization_id and
253: wtei.process_status = wip_constants.running and
254: wtei.employee_id is null and
255: wtei.badge_id is not null ;
256:
257:

Line 274: wtei.process_status = wip_constants.running and

270: ),
271: wtei.last_update_date = sysdate
272: where
273: wtei.organization_id = p_organization_id and
274: wtei.process_status = wip_constants.running and
275: wtei.employee_id is null and
276: wtei.badge_id is not null and
277: upper(wtei.contingent_flag) = 'Y';
278: */

Line 287: if (g_logLevel <= wip_constants.trace_logging) then

283: close running_intf_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,

Line 296: if (g_logLevel <= wip_constants.trace_logging) then

292: x_ret_status => l_return_status);
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;

Line 485: if (g_logLevel <= wip_constants.trace_logging) then

481: l_counter := l_wip_time_intf_tbl.first;
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

Line 497: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

493: l_wip_time_intf_tbl(l_counter).duration is null) then
494: l_stmt_num :=30;
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;

Line 510: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

506: Scheduled Available Hours */
507: if l_wip_time_intf_tbl(l_counter).time_entry_type = 2 and nvl(l_wip_time_intf_tbl(l_counter).action_flag,-1) not in (1,2) then
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;

Line 527: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.warning;

523: l_wip_time_intf_tbl(l_counter).operation_seq_num := null;
524: l_wip_time_intf_tbl(l_counter).resource_seq_num := null;
525: fnd_message.set_name('WIP','WIP_IMP_JOB_IGNORED');
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);

Line 529: if (g_logLevel <= wip_constants.trace_logging) then

525: fnd_message.set_name('WIP','WIP_IMP_JOB_IGNORED');
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;

Line 538: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

534: l_stmt_num :=50;
535: if l_wip_time_intf_tbl(l_counter).employee_id is null then
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;

Line 551: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

547: p_res_id => null,
548: p_emp_id => l_wip_time_intf_tbl(l_counter).employee_id) then
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;

Line 564: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

560: if l_wip_time_intf_tbl(l_counter).wip_entity_id is null and
561: l_wip_time_intf_tbl(l_counter).job_name is null then
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;

Line 579: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

575: if is_job_invalid(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
576: p_we_id => l_wip_time_intf_tbl(l_counter).wip_entity_id) then
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;

Line 589: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

585: l_stmt_num :=100;
586: if l_wip_time_intf_tbl(l_counter).operation_seq_num is null then
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;

Line 602: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

598: p_op_seq => l_wip_time_intf_tbl(l_counter).operation_seq_num);
599: if l_wip_time_intf_tbl(l_counter).department_id < 0 then
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;

Line 615: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

611: l_wip_time_intf_tbl(l_counter).resource_code is null and
612: l_wip_time_intf_tbl(l_counter).resource_seq_num is null then
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;

Line 645: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

641: p_dep_id => l_wip_time_intf_tbl(l_counter).department_id,
642: p_res_id => l_wip_time_intf_tbl(l_counter).resource_id) then
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;

Line 655: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

651: l_stmt_num :=140;
652: if l_wip_time_intf_tbl(l_counter).employee_id is null then
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;

Line 668: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

664: p_res_id => l_wip_time_intf_tbl(l_counter).resource_id,
665: p_emp_id => l_wip_time_intf_tbl(l_counter).employee_id) then
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;

Line 690: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

686: l_stmt_num :=170;
687: else
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;

Line 705: l_wip_time_intf_tbl(l_counter).process_status := wip_constants.error;

701: if wip_ws_labor_metric_pub.is_time_uom(l_wip_time_intf_tbl(l_counter).uom_code) <> 1 or
702: l_wip_time_intf_tbl(l_counter).uom_code is null then
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;

Line 735: if (g_logLevel <= wip_constants.trace_logging) then

731: l_wip_time_intf_tbl(l_counter).actual_start_date)*24;
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;

Line 743: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or

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.
741: -- Bug 12614160.
742: <>
743: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
744: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
745: select wip_resource_actual_times_s.nextval
746: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
747: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;

Line 744: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then

740: -- Defaulted instance_id for Imported Clock-in records since Labor metrics program relies on instance_id for metrics calculation.
741: -- Bug 12614160.
742: <>
743: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
744: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
745: select wip_resource_actual_times_s.nextval
746: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
747: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;
748: v_wip_res_actual_times(ins_counter).wip_entity_id := l_wip_time_intf_tbl(l_counter).wip_entity_id;

Line 786: if (g_logLevel <= wip_constants.trace_logging) then

782: pop_counter := pop_counter+1;
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

Line 794: if (g_logLevel <= wip_constants.trace_logging) then

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

Line 802: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),

798: -- update back wip_time_entry_interface table
799: forall upd_index in v_interface_id.first..v_interface_id.last
800: update wip_time_entry_interface set
801: process_status = decode(v_process_status(upd_index),
802: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),
803: error = v_error(upd_index),
804: last_update_date = sysdate
805: where interface_id = v_interface_id(upd_index);
806:

Line 807: if (g_logLevel <= wip_constants.trace_logging) then

803: error = v_error(upd_index),
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

Line 885: and wdj.status_type in (wip_constants.released,wip_constants.comp_chrg,wip_constants.hold);

881: into l_count
882: from wip_discrete_jobs wdj
883: where wdj.organization_id = p_org_id
884: and wdj.wip_entity_id = p_we_id
885: and wdj.status_type in (wip_constants.released,wip_constants.comp_chrg,wip_constants.hold);
886:
887: if l_count = 0 then
888: return true;
889: else