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

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

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

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

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

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

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

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

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

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

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

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

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

484: end if;
485: end if;
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||') '||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

548: 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,
549: p_we_id => l_wip_time_intf_tbl(l_counter).wip_entity_id,
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||') '||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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