DBA Data[Home] [Help]

APPS.PAY_VOID_PAYMENTS dependencies on FND_DATE

Line 104: l_effective_date := trunc(fnd_date.canonical_to_date (p_effective_date));

100: hr_utility.set_location ('void_run',1);
101: --------------------------------------------------------------------------------
102: -- Convert date. NB: This will have to change to generic data format in 10.7
103: --------------------------------------------------------------------------------
104: l_effective_date := trunc(fnd_date.canonical_to_date (p_effective_date));
105: --
106: if p_start_assignment is not null then
107: l_start_cheque := null;
108: l_end_cheque := null;

Line 143: fnd_date.date_to_canonical(overlap_row.effective_date);

139: hr_utility.set_location ('void_run',31);
140: IF action_type = 'H' THEN
141: p_errmsg := 'Overlap detected. Cheque #' || overlap_row.cheque_number ||
142: ' already voided in run performed on ' ||
143: fnd_date.date_to_canonical(overlap_row.effective_date);
144: p_errcode := 2; -- Error
145: ELSIF action_type = 'M' THEN
146: p_errmsg := 'Overlap detected. MagTape Assignment Action #' ||
147: overlap_row.assignment_action_id ||

Line 149: fnd_date.date_to_canonical(overlap_row.effective_date);

145: ELSIF action_type = 'M' THEN
146: p_errmsg := 'Overlap detected. MagTape Assignment Action #' ||
147: overlap_row.assignment_action_id ||
148: ' already voided in run performed on ' ||
149: fnd_date.date_to_canonical(overlap_row.effective_date);
150: p_errcode := 2; -- Error
151: END IF;
152: -- bug 9960968
153: fnd_file.put_line( fnd_file.log,' Number of Cheques Successfully Voided : '||l_no_of_chq_processed);