DBA Data[Home] [Help]

APPS.PER_GB_TAX_BEN_PKG dependencies on FND_DATE

Line 94: p_effective_date=> fnd_date.canonical_to_date (p_effective_date),

90: l_file_handle :=
91: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
92: -- Create the Batch header
93: create_tax_ben_batch_header (
94: p_effective_date=> fnd_date.canonical_to_date (p_effective_date),
95: p_name=> NVL (
96: p_batch_name,
97: 'TAXBEN_'
98: || TO_CHAR (SYSDATE, 'dd_mm_yyyy_hh24miss')

Line 155: p_session_date=> fnd_date.canonical_to_date (p_effective_date),

151: -- Break the line up in its fields.
152: -- The fields will be stored in l_batch_line record structure.
153: break_up_line (
154: p_line=> l_line_read,
155: p_session_date=> fnd_date.canonical_to_date (p_effective_date),
156: p_batch_id=> l_batch_id,
157: p_batch_seq=> l_batch_seq,
158: p_delimiter=> p_delimiter,
159: p_bg_id=> p_business_group_id,

Line 243: --hr_utility.set_message_token (800,'FORMAT',fnd_date.user_mask);

239: hr_utility.set_message (800, 'PER_GB_P11D_78058_ASG_ERR_MSG');
240: hr_utility.set_message_token (800, 'TEXT', 'Error at line' || l_batch_seq || ' : Wrong date format');
241: --hr_utility.set_message (800, 'HR_78036_WRONG_DATE_FORMAT');
242: --hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
243: --hr_utility.set_message_token (800,'FORMAT',fnd_date.user_mask);
244: --hr_utility.set_message_token (800, 'LINE', l_line_read);
245: -- Write the message to log file, do not raise an application error but continue
246: -- (with next line)
247: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 439: fnd_date.chardate_to_date (

435: -- First field in file is the session_date, this should be NULL
436: BEGIN
437: p_batch_line.session_date :=
438: NVL (
439: fnd_date.chardate_to_date (
440: get_field (p_line => l_line, p_delimiter => p_delimiter)
441: ),
442: p_session_date
443: );

Line 476: fnd_date.chardate_to_date (

472: -- Third field in file is the session_date, this should be NULL
473: BEGIN
474: p_batch_line.session_date :=
475: NVL (
476: fnd_date.chardate_to_date (
477: get_field (p_line => l_line, p_delimiter => p_delimiter)
478: ),
479: p_session_date
480: );

Line 560: fnd_date.chardate_to_date (

556: BEGIN
557: -- We will default this later. This is to fix bug 2058082.
558: -- Field 29 contains the effective_date
559: p_batch_line.effective_date :=
560: fnd_date.chardate_to_date (
561: get_field (p_line => l_line, p_delimiter => p_delimiter)
562: );
563: EXCEPTION
564: WHEN OTHERS

Line 593: fnd_date.chardate_to_date (

589: -- Field 30 contains the effective_start_date, if empty default to start of UK Tax Year
590: -- or the start date of the assignment
591: p_batch_line.effective_start_date :=
592: NVL (
593: fnd_date.chardate_to_date (
594: get_field (
595: p_line=> l_line,
596: p_delimiter=> p_delimiter
597: )

Line 611: fnd_date.chardate_to_date (

607: -- In that case we should use the date provided (or end of tax year).
608: -- By setting it to EOT when NULL, LEAST will always evaluate to the other value
609: p_batch_line.effective_end_date :=
610: NVL (
611: fnd_date.chardate_to_date (
612: get_field (
613: p_line=> l_line,
614: p_delimiter=> p_delimiter
615: )