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: l_stmt_num := 60;

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

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

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

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

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

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

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

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

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

458: Scheduled Available Hours */
459: 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
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

620: l_stmt_num :=160;
621: else
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;

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

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

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

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

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

671: end if;
672:
673: l_stmt_num :=200;
674: <>
675: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
676: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
677: select wip_resource_actual_times_s.nextval
678: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
679: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;

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

672:
673: l_stmt_num :=200;
674: <>
675: if l_wip_time_intf_tbl(l_counter).process_status = wip_constants.running or
676: l_wip_time_intf_tbl(l_counter).process_status = wip_constants.warning then
677: select wip_resource_actual_times_s.nextval
678: into v_wip_res_actual_times(ins_counter).time_entry_id from dual;
679: v_wip_res_actual_times(ins_counter).organization_id := l_wip_time_intf_tbl(l_counter).organization_id;
680: v_wip_res_actual_times(ins_counter).wip_entity_id := l_wip_time_intf_tbl(l_counter).wip_entity_id;

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

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

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

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

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

730: -- update back wip_time_entry_interface table
731: forall upd_index in v_interface_id.first..v_interface_id.last
732: update wip_time_entry_interface set
733: process_status = decode(v_process_status(upd_index),
734: wip_constants.running,wip_constants.completed,v_process_status(upd_index) ),
735: error = v_error(upd_index),
736: last_update_date = sysdate
737: where interface_id = v_interface_id(upd_index);
738:

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

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

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

813: into l_count
814: from wip_discrete_jobs wdj
815: where wdj.organization_id = p_org_id
816: and wdj.wip_entity_id = p_we_id
817: and wdj.status_type in (wip_constants.released,wip_constants.comp_chrg,wip_constants.hold);
818:
819: if l_count = 0 then
820: return true;
821: else