DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on FND_MESSAGE

Line 15: fnd_message.SET_NAME('WIP', 'WIP_WS_INSTANCE_NAME');

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

Line 16: fnd_message.SET_TOKEN('INSTANCE', p_instance_name);

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;

Line 17: fnd_message.SET_TOKEN('SERIAL', p_serial_number);

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;

Line 18: return fnd_message.GET;

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;

Line 127: fnd_message.SET_NAME('WIP', 'WIP_WS_JOBOP_FORMAT');

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:

Line 128: fnd_message.SET_TOKEN('JOB', p_job_name);

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;

Line 129: fnd_message.SET_TOKEN('OP', p_op_seq);

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:

Line 130: return fnd_message.GET;

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:

Line 215: fnd_message.SET_NAME('WIP', 'WIP_WS_SHIFT_INFO');

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:

Line 216: fnd_message.SET_TOKEN('SHIFT_NUM', x_shift_num);

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;

Line 217: fnd_message.SET_TOKEN('FROM_TIME', l_c_from_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;
221:

Line 218: fnd_message.SET_TOKEN('TO_TIME', l_c_to_time);

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

Line 220: x_shift_string := fnd_message.GET;

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;

Line 539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');

535: else
536: l_from_date := l_start_date;
537: l_to_date := l_end_date;
538: end if;
539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
540: fnd_message.SET_TOKEN('NUM', p_shift_num);
541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );
542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );
543: l_info := fnd_message.GET;

Line 540: fnd_message.SET_TOKEN('NUM', p_shift_num);

536: l_from_date := l_start_date;
537: l_to_date := l_end_date;
538: end if;
539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
540: fnd_message.SET_TOKEN('NUM', p_shift_num);
541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );
542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );
543: l_info := fnd_message.GET;
544: else

Line 541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );

537: l_to_date := l_end_date;
538: end if;
539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
540: fnd_message.SET_TOKEN('NUM', p_shift_num);
541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );
542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );
543: l_info := fnd_message.GET;
544: else
545: l_info := null;

Line 542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );

538: end if;
539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
540: fnd_message.SET_TOKEN('NUM', p_shift_num);
541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );
542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );
543: l_info := fnd_message.GET;
544: else
545: l_info := null;
546: end if;

Line 543: l_info := fnd_message.GET;

539: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');
540: fnd_message.SET_TOKEN('NUM', p_shift_num);
541: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(dateval => l_from_date,calendar_aware => 2) );
542: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(dateval => l_to_date,calendar_aware => 2) );
543: l_info := fnd_message.GET;
544: else
545: l_info := null;
546: end if;
547:

Line 586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');

582: where wo.department_id = bd.department_id
583: and wo.wip_entity_id = p_wip_entity_id
584: and wo.operation_seq_num = p_op_seq;
585:
586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);

Line 587: fnd_message.SET_token('EMP', l_emp_name);

583: and wo.wip_entity_id = p_wip_entity_id
584: and wo.operation_seq_num = p_op_seq;
585:
586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);

Line 588: fnd_message.SET_TOKEN('DATE', l_date_str);

584: and wo.operation_seq_num = p_op_seq;
585:
586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;

Line 589: fnd_message.set_token('OP', p_op_seq);

585:
586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else

Line 590: fnd_message.set_token('DEPT', l_dept_code);

586: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR');
587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');

Line 591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);

587: fnd_message.SET_token('EMP', l_emp_name);
588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);

Line 592: l_header := fnd_message.GET;

588: fnd_message.SET_TOKEN('DATE', l_date_str);
589: fnd_message.set_token('OP', p_op_seq);
590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);

Line 594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');

590: fnd_message.set_token('DEPT', l_dept_code);
591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);
597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
598: l_header := fnd_message.GET;

Line 595: fnd_message.SET_token('EMP', l_emp_name);

591: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);
597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
598: l_header := fnd_message.GET;
599:

Line 596: fnd_message.SET_TOKEN('DATE', l_date_str);

592: l_header := fnd_message.GET;
593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);
597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
598: l_header := fnd_message.GET;
599:
600: end if;

Line 597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);

593: else
594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);
597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
598: l_header := fnd_message.GET;
599:
600: end if;
601:

Line 598: l_header := fnd_message.GET;

594: fnd_message.set_name('WIP', 'WIP_WS_JOB_NOTE_HDR_JOB');
595: fnd_message.SET_token('EMP', l_emp_name);
596: fnd_message.SET_TOKEN('DATE', l_date_str);
597: fnd_message.set_token('TZ', fnd_timezones.get_client_timezone_code);
598: l_header := fnd_message.GET;
599:
600: end if;
601:
602: return l_header;