11: IS
12: begin
13:
14: if( p_serial_number is not null) then
15: fnd_message.SET_NAME('WIP', 'WIP_WS_INSTANCE_NAME');
16: fnd_message.SET_TOKEN('INSTANCE', p_instance_name);
17: fnd_message.SET_TOKEN('SERIAL', p_serial_number);
18: return fnd_message.GET;
19: else
12: begin
13:
14: if( p_serial_number is not null) then
15: fnd_message.SET_NAME('WIP', 'WIP_WS_INSTANCE_NAME');
16: fnd_message.SET_TOKEN('INSTANCE', p_instance_name);
17: fnd_message.SET_TOKEN('SERIAL', p_serial_number);
18: return fnd_message.GET;
19: else
20: return p_instance_name;
13:
14: if( p_serial_number is not null) then
15: fnd_message.SET_NAME('WIP', 'WIP_WS_INSTANCE_NAME');
16: fnd_message.SET_TOKEN('INSTANCE', p_instance_name);
17: fnd_message.SET_TOKEN('SERIAL', p_serial_number);
18: return fnd_message.GET;
19: else
20: return p_instance_name;
21: end if;
14: if( p_serial_number is not null) then
15: fnd_message.SET_NAME('WIP', 'WIP_WS_INSTANCE_NAME');
16: fnd_message.SET_TOKEN('INSTANCE', p_instance_name);
17: fnd_message.SET_TOKEN('SERIAL', p_serial_number);
18: return fnd_message.GET;
19: else
20: return p_instance_name;
21: end if;
22: end;
123:
124: function get_jobop_name(p_job_name varchar2, p_op_seq number) return varchar2
125: is
126: begin
127: fnd_message.SET_NAME('WIP', 'WIP_WS_JOBOP_FORMAT');
128: fnd_message.SET_TOKEN('JOB', p_job_name);
129: fnd_message.SET_TOKEN('OP', p_op_seq);
130: return fnd_message.GET;
131:
124: function get_jobop_name(p_job_name varchar2, p_op_seq number) return varchar2
125: is
126: begin
127: fnd_message.SET_NAME('WIP', 'WIP_WS_JOBOP_FORMAT');
128: fnd_message.SET_TOKEN('JOB', p_job_name);
129: fnd_message.SET_TOKEN('OP', p_op_seq);
130: return fnd_message.GET;
131:
132: end get_jobop_name;
125: is
126: begin
127: fnd_message.SET_NAME('WIP', 'WIP_WS_JOBOP_FORMAT');
128: fnd_message.SET_TOKEN('JOB', p_job_name);
129: fnd_message.SET_TOKEN('OP', p_op_seq);
130: return fnd_message.GET;
131:
132: end get_jobop_name;
133:
126: begin
127: fnd_message.SET_NAME('WIP', 'WIP_WS_JOBOP_FORMAT');
128: fnd_message.SET_TOKEN('JOB', p_job_name);
129: fnd_message.SET_TOKEN('OP', p_op_seq);
130: return fnd_message.GET;
131:
132: end get_jobop_name;
133:
134:
211: select to_char(l_c_end_date, 'HH24:MI:SS')
212: into l_c_to_time
213: from dual;
214:
215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);
218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);
219:
212: into l_c_to_time
213: from dual;
214:
215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);
218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);
219:
220: x_shift_string := fnd_message.GET;
213: from dual;
214:
215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);
218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);
219:
220: x_shift_string := fnd_message.GET;
221:
214:
215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);
218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);
219:
220: x_shift_string := fnd_message.GET;
221:
222: --exception when others then
216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);
217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_time);
218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);
219:
220: x_shift_string := fnd_message.GET;
221:
222: --exception when others then
223: -- null;
224: End retrieve_first_shift;
494: else
495: l_from_date := l_start_date;
496: l_to_date := l_end_date;
497: end if;
498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
499: fnd_message.SET_TOKEN('NUM', p_shift_num);
500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_date) );
501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_date) );
502: l_info := fnd_message.GET;
495: l_from_date := l_start_date;
496: l_to_date := l_end_date;
497: end if;
498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
499: fnd_message.SET_TOKEN('NUM', p_shift_num);
500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_date) );
501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_date) );
502: l_info := fnd_message.GET;
503: else
496: l_to_date := l_end_date;
497: end if;
498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
499: fnd_message.SET_TOKEN('NUM', p_shift_num);
500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_date) );
501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_date) );
502: l_info := fnd_message.GET;
503: else
504: l_info := null;
497: end if;
498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
499: fnd_message.SET_TOKEN('NUM', p_shift_num);
500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_date) );
501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_date) );
502: l_info := fnd_message.GET;
503: else
504: l_info := null;
505: end if;
498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
499: fnd_message.SET_TOKEN('NUM', p_shift_num);
500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_date) );
501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_date) );
502: l_info := fnd_message.GET;
503: else
504: l_info := null;
505: end if;
506:
541: where wo.department_id = bd.department_id
542: and wo.wip_entity_id = p_wip_entity_id
543: and wo.operation_seq_num = p_op_seq;
544:
545: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
542: and wo.wip_entity_id = p_wip_entity_id
543: and wo.operation_seq_num = p_op_seq;
544:
545: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
543: and wo.operation_seq_num = p_op_seq;
544:
545: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
544:
545: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
545: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
546: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
547: fnd_message.SET_TOKEN('DATE', l_date_str);
548: fnd_message.set_token('OP', p_op_seq);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
549: fnd_message.set_token('DEPT', l_dept_code);
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
556: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
557: l_header := fnd_message.GET;
550: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
556: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
557: l_header := fnd_message.GET;
558:
551: l_header := fnd_message.GET;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
556: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
557: l_header := fnd_message.GET;
558:
559: end if;
552: else
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
556: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
557: l_header := fnd_message.GET;
558:
559: end if;
560:
553: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
554: fnd_message.SET_token('EMP', l_emp_name);
555: fnd_message.SET_TOKEN('DATE', l_date_str);
556: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
557: l_header := fnd_message.GET;
558:
559: end if;
560:
561: return l_header;