APPS.PAY_BALANCE_UPLOAD dependencies on PAY_MESSAGE_LINES

Line 110: put into pay_message_lines. This was done

106: named by the legislation
107: 115.31 A.Logue 23-DEC-2002 Bug 2628014 - Enhanced load_latest_asg_balances
108: to handle exceptions raised. Affected lines
109: are now set to Errored, and a message is
110: put into pay_message_lines. This was done
111: by passing batch_line_list and num_lines
112: to the procedure. This avoids the scenario
113: where some lines were being set as Valid, and
114: others as Transferred - and the batch has been

Line 187: to fit into pay_message_lines.

183: also passing batch_line_id to
184: include_adjustment.
185: 115.16 A.Logue 13-JAN-2000 Ensure that error messages fetched from
186: hr_utility.get_message are of max length 240
187: to fit into pay_message_lines.
188: 115.14 A.Logue 07-OCT-1999 Pass batch_line_status to dim_expiry_date so that
189: it does not call the legislative expiry_date
190: procedure if the line is to be discarded (ie not 'V').
191: This should give an improvement of performance.

Line 566: delete from pay_message_lines

562: --
563: -- Remove the messages
564: --
565: for pmlrec in pml(p_batch_id) loop
566: delete from pay_message_lines
567: where source_type = 'L'
568: and source_id = pmlrec.batch_line_id;
569: end loop;
570: --

Line 572: delete from pay_message_lines

568: and source_id = pmlrec.batch_line_id;
569: end loop;
570: --
571: hr_utility.set_location('pay_balance_upload.remove_messages',10);
572: delete from pay_message_lines
573: where source_type = 'H'
574: and source_id = p_batch_id;
575: --
576: hr_utility.trace('Exiting pay_balance_upload.remove_messages');

Line 930: insert into pay_message_lines

926: -- Create new message line.
927: --
928: hr_utility.trace(l_message_text);
929: --
930: insert into pay_message_lines
931: (line_sequence
932: ,message_level
933: ,source_id
934: ,source_type

Line 937: (pay_message_lines_s.nextval

933: ,source_id
934: ,source_type
935: ,line_text)
936: values
937: (pay_message_lines_s.nextval
938: ,'F' -- 'F'atal
939: ,decode(p_meesage_level, HEADER, p_batch_id, LINE, p_batch_line_id)
940: ,decode(p_meesage_level, HEADER, 'H' , LINE, 'L')
941: ,substr(l_message_text, 1, 240));

Line 5526: delete from pay_message_lines ML

5522: --
5523: -- Delete batch line messages.
5524: --
5525: for errline in csr_get_err_lines(p_glbl_data_rec.batch_id) loop
5526: delete from pay_message_lines ML
5527: where ML.message_level = 'F'
5528: and ML.source_type = 'L'
5529: and ML.source_id = errline.batch_line_id;
5530: end loop;

Line 5534: delete from pay_message_lines ML

5530: end loop;
5531: --
5532: -- Delete batch header messages.
5533: --
5534: delete from pay_message_lines ML
5535: where ML.message_level = 'F'
5536: and ML.source_type = 'H'
5537: and ML.source_id = p_glbl_data_rec.batch_id;
5538: --