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 498: fnd_message.SET_NAME('WIP', 'WIP_WS_HOME_SHIFT_INFO_F');

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;

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

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

Line 500: fnd_message.SET_TOKEN('FROM', fnd_date.date_to_displayDT(l_from_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
504: l_info := null;

Line 501: fnd_message.SET_TOKEN('TO', fnd_date.date_to_displayDT(l_to_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;
505: end if;

Line 502: l_info := fnd_message.GET;

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:

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

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

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

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

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

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;

Line 548: fnd_message.set_token('OP', 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;
552: else

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

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');

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

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

Line 551: l_header := fnd_message.GET;

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

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

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;

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

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:

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

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;

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

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:

Line 557: l_header := fnd_message.GET;

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;