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 FND_MESSAGE

Line 76: fnd_message.set_name('WIP','WIP_INVALID_SHIFT_PREF');

72: department_id is null);
73: exception
74: when too_many_rows then
75: l_valid_shift_pref := false;
76: fnd_message.set_name('WIP','WIP_INVALID_SHIFT_PREF');
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

Line 77: fnd_message.set_token('ORG', to_char(l_org_code));

73: exception
74: when too_many_rows then
75: l_valid_shift_pref := false;
76: fnd_message.set_name('WIP','WIP_INVALID_SHIFT_PREF');
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,

Line 78: l_err_msg := fnd_message.get;

74: when too_many_rows then
75: l_valid_shift_pref := false;
76: fnd_message.set_name('WIP','WIP_INVALID_SHIFT_PREF');
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,

Line 120: fnd_message.set_name('WIP','WIP_INVALID_CLOCK_PREF');

116: department_id is null);
117: exception
118: when too_many_rows then
119: l_valid_clock_pref := false;
120: fnd_message.set_name('WIP','WIP_INVALID_CLOCK_PREF');
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

Line 121: fnd_message.set_token('ORG', to_char(l_org_code));

117: exception
118: when too_many_rows then
119: l_valid_clock_pref := false;
120: fnd_message.set_name('WIP','WIP_INVALID_CLOCK_PREF');
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,

Line 122: l_err_msg := fnd_message.get;

118: when too_many_rows then
119: l_valid_clock_pref := false;
120: fnd_message.set_name('WIP','WIP_INVALID_CLOCK_PREF');
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,

Line 160: fnd_message.set_name('WIP','WIP_AAH_IMPORT_NOT_ALLOWED');

156:
157: l_stmt_num := 30;
158: if l_shift_enabled and l_valid_shift_pref then
159:
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,

Line 161: l_err_msg := fnd_message.get;

157: l_stmt_num := 30;
158: if l_shift_enabled and l_valid_shift_pref then
159:
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,

Line 191: fnd_message.set_name('WIP','WIP_DLH_IMPORT_NOT_ALLOWED');

187: end if;
188: l_stmt_num := 40;
189: if l_clock_enabled and l_valid_clock_pref then
190:
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,

Line 192: l_err_msg := fnd_message.get;

188: l_stmt_num := 40;
189: if l_clock_enabled and l_valid_clock_pref then
190:
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,

Line 495: fnd_message.set_name('WIP','WIP_TIME_IMPORT_DATE_NULL');

491: if l_wip_time_intf_tbl(l_counter).actual_start_date is null or
492: (l_wip_time_intf_tbl(l_counter).actual_end_date is null and
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||') '||

Line 496: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

492: (l_wip_time_intf_tbl(l_counter).actual_end_date is null and
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);

Line 508: fnd_message.set_name('WIP','WIP_SAH_ONLY_ADJUSTMENT');

504: if l_wip_time_intf_tbl(l_counter).time_entry_type = 1 or
505: l_wip_time_intf_tbl(l_counter).time_entry_type = 2 then /* Actual Attendance Hours,
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||') '||

Line 509: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

505: l_wip_time_intf_tbl(l_counter).time_entry_type = 2 then /* Actual Attendance Hours,
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);

Line 525: fnd_message.set_name('WIP','WIP_IMP_JOB_IGNORED');

521: l_wip_time_intf_tbl(l_counter).resource_seq_num is not null then
522: l_wip_time_intf_tbl(l_counter).wip_entity_id := null;
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

Line 526: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

522: l_wip_time_intf_tbl(l_counter).wip_entity_id := null;
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||') '||

Line 536: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');

532: end if;
533: end if;
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||') '||

Line 537: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

533: end if;
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);

Line 549: fnd_message.set_name('WIP','WIP_INVALID_EMP_DETAILS');

545: if is_emp_invalid(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
546: p_dep_id => null,
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||') '||

Line 550: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

546: p_dep_id => null,
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);

Line 562: fnd_message.set_name('WIP','WIP_NO_JOB_DETAILS');

558: elsif l_wip_time_intf_tbl(l_counter).time_entry_type = 3 then /* Direct Labor Hours */
559: l_stmt_num :=80;
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||') '||

Line 563: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

559: l_stmt_num :=80;
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);

Line 577: fnd_message.set_name('WIP','WIP_INVALID_JOB_DETAILS');

573: end if;
574: l_stmt_num :=90;
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||') '||

Line 578: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

574: l_stmt_num :=90;
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);

Line 587: fnd_message.set_name('WIP','WIP_JOB_OP_NULL');

583: goto skip_validations;
584: end if;
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||') '||

Line 588: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

584: end if;
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);

Line 600: fnd_message.set_name('WIP','WIP_INVALID_JOB_OP');

596: l_wip_time_intf_tbl(l_counter).department_id := get_op_dept_id(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
597: p_we_id => l_wip_time_intf_tbl(l_counter).wip_entity_id,
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||') '||

Line 601: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

597: p_we_id => l_wip_time_intf_tbl(l_counter).wip_entity_id,
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);

Line 613: fnd_message.set_name('WIP','WIP_NO_RES_DETAILS');

609: l_stmt_num :=120;
610: if l_wip_time_intf_tbl(l_counter).resource_id is null and
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||') '||

Line 614: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

610: if l_wip_time_intf_tbl(l_counter).resource_id is null and
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);

Line 643: fnd_message.set_name('WIP','WIP_INVALID_RES_DETAILS');

639: l_stmt_num :=130;
640: if is_res_invalid(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
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||') '||

Line 644: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

640: if is_res_invalid(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
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);

Line 653: fnd_message.set_name('WIP','WIP_NO_EMP_DETAILS');

649: goto skip_validations;
650: end if;
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||') '||

Line 654: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

650: end if;
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);

Line 666: fnd_message.set_name('WIP','WIP_INVALID_EMP_DETAILS');

662: if is_emp_invalid(p_org_id => l_wip_time_intf_tbl(l_counter).organization_id,
663: p_dep_id => l_wip_time_intf_tbl(l_counter).department_id,
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||') '||

Line 667: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

663: p_dep_id => l_wip_time_intf_tbl(l_counter).department_id,
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);

Line 688: fnd_message.set_name('WIP','WIP_INVALID_TIME_TYPE');

684: l_instance_id := null;
685: End;
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||') '||

Line 689: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

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

Line 703: fnd_message.set_name('WIP','WIP_INVALID_TIME_UOM');

699: l_wip_time_intf_tbl(l_counter).duration is not null)) then
700:
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||') '||

Line 704: l_wip_time_intf_tbl(l_counter).error := fnd_message.get;

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