80: fetch csr_time_period into p_period_start_date, p_period_end_date;
81: if (csr_time_period%NOTFOUND)
82: or not (p_upload_date between p_period_start_date and p_period_end_date) then
83: close csr_time_period;
84: fnd_message.set_name('PAY', 'PAY_JP_BEE_UTIL_INV_UPLD_DATE');
85: fnd_message.set_token('UPLOAD_DATE', fnd_date.date_to_chardate(p_upload_date));
86: fnd_message.set_token('PERIOD_START_DATE', fnd_date.date_to_chardate(p_period_start_date));
87: fnd_message.set_token('PERIOD_END_DATE', fnd_date.date_to_chardate(p_period_end_date));
88: fnd_message.raise_error;
81: if (csr_time_period%NOTFOUND)
82: or not (p_upload_date between p_period_start_date and p_period_end_date) then
83: close csr_time_period;
84: fnd_message.set_name('PAY', 'PAY_JP_BEE_UTIL_INV_UPLD_DATE');
85: fnd_message.set_token('UPLOAD_DATE', fnd_date.date_to_chardate(p_upload_date));
86: fnd_message.set_token('PERIOD_START_DATE', fnd_date.date_to_chardate(p_period_start_date));
87: fnd_message.set_token('PERIOD_END_DATE', fnd_date.date_to_chardate(p_period_end_date));
88: fnd_message.raise_error;
89: end if;
82: or not (p_upload_date between p_period_start_date and p_period_end_date) then
83: close csr_time_period;
84: fnd_message.set_name('PAY', 'PAY_JP_BEE_UTIL_INV_UPLD_DATE');
85: fnd_message.set_token('UPLOAD_DATE', fnd_date.date_to_chardate(p_upload_date));
86: fnd_message.set_token('PERIOD_START_DATE', fnd_date.date_to_chardate(p_period_start_date));
87: fnd_message.set_token('PERIOD_END_DATE', fnd_date.date_to_chardate(p_period_end_date));
88: fnd_message.raise_error;
89: end if;
90: close csr_time_period;
83: close csr_time_period;
84: fnd_message.set_name('PAY', 'PAY_JP_BEE_UTIL_INV_UPLD_DATE');
85: fnd_message.set_token('UPLOAD_DATE', fnd_date.date_to_chardate(p_upload_date));
86: fnd_message.set_token('PERIOD_START_DATE', fnd_date.date_to_chardate(p_period_start_date));
87: fnd_message.set_token('PERIOD_END_DATE', fnd_date.date_to_chardate(p_period_end_date));
88: fnd_message.raise_error;
89: end if;
90: close csr_time_period;
91: --
84: fnd_message.set_name('PAY', 'PAY_JP_BEE_UTIL_INV_UPLD_DATE');
85: fnd_message.set_token('UPLOAD_DATE', fnd_date.date_to_chardate(p_upload_date));
86: fnd_message.set_token('PERIOD_START_DATE', fnd_date.date_to_chardate(p_period_start_date));
87: fnd_message.set_token('PERIOD_END_DATE', fnd_date.date_to_chardate(p_period_end_date));
88: fnd_message.raise_error;
89: end if;
90: close csr_time_period;
91: --
92: hr_utility.set_location('Leaving : ' || l_proc, 20);
512: p_value in varchar2)
513: is
514: begin
515: if p_token is not null then
516: fnd_message.set_token(p_token, p_value);
517: end if;
518: end set_token;
519: begin
520: --
537: g_num_of_logs := g_num_of_logs + 1;
538: --
539: -- Derive message text from fnd_new_messages
540: --
541: fnd_message.set_name(p_application_short_name, p_message_name);
542: set_token(p_token1, p_value1);
543: set_token(p_token2, p_value2);
544: set_token(p_token3, p_value3);
545: set_token(p_token4, p_value4);
543: set_token(p_token2, p_value2);
544: set_token(p_token3, p_value3);
545: set_token(p_token4, p_value4);
546: set_token(p_token5, p_value5);
547: l_message_text := fnd_message.get;
548: --
549: -- Write message text
550: --
551: fnd_file.put_line(fnd_file.log,