[Home] [Help]
108: named by the legislation
109: 115.31 A.Logue 23-DEC-2002 Bug 2628014 - Enhanced load_latest_asg_balances
110: to handle exceptions raised. Affected lines
111: are now set to Errored, and a message is
112: put into pay_message_lines. This was done
113: by passing batch_line_list and num_lines
114: to the procedure. This avoids the scenario
115: where some lines were being set as Valid, and
116: others as Transferred - and the batch has been
185: also passing batch_line_id to
186: include_adjustment.
187: 115.16 A.Logue 13-JAN-2000 Ensure that error messages fetched from
188: hr_utility.get_message are of max length 240
189: to fit into pay_message_lines.
190: 115.14 A.Logue 07-OCT-1999 Pass batch_line_status to dim_expiry_date so that
191: it does not call the legislative expiry_date
192: procedure if the line is to be discarded (ie not 'V').
193: This should give an improvement of performance.
564: --
565: -- Remove the messages
566: --
567: for pmlrec in pml(p_batch_id) loop
568: delete from pay_message_lines
569: where source_type = 'L'
570: and source_id = pmlrec.batch_line_id;
571: end loop;
572: --
570: and source_id = pmlrec.batch_line_id;
571: end loop;
572: --
573: hr_utility.set_location('pay_balance_upload.remove_messages',10);
574: delete from pay_message_lines
575: where source_type = 'H'
576: and source_id = p_batch_id;
577: --
578: hr_utility.trace('Exiting pay_balance_upload.remove_messages');
928: -- Create new message line.
929: --
930: hr_utility.trace(l_message_text);
931: --
932: insert into pay_message_lines
933: (line_sequence
934: ,message_level
935: ,source_id
936: ,source_type
935: ,source_id
936: ,source_type
937: ,line_text)
938: values
939: (pay_message_lines_s.nextval
940: ,'F' -- 'F'atal
941: ,decode(p_meesage_level, HEADER, p_batch_id, LINE, p_batch_line_id)
942: ,decode(p_meesage_level, HEADER, 'H' , LINE, 'L')
943: ,substr(l_message_text, 1, 240));
5815: --
5816: -- Delete batch line messages.
5817: --
5818: for errline in csr_get_err_lines(p_glbl_data_rec.batch_id) loop
5819: delete from pay_message_lines ML
5820: where ML.message_level = 'F'
5821: and ML.source_type = 'L'
5822: and ML.source_id = errline.batch_line_id;
5823: end loop;
5823: end loop;
5824: --
5825: -- Delete batch header messages.
5826: --
5827: delete from pay_message_lines ML
5828: where ML.message_level = 'F'
5829: and ML.source_type = 'H'
5830: and ML.source_id = p_glbl_data_rec.batch_id;
5831: --