APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_MESSAGE_LINES

Line 324: -- First delete any messages relating to this batch from pay_message_lines

320: --
321: -- Only purge header message if it is has been called by outside of the PYUGEN.
322: --
323: if p_asg_action_id is null then
324: -- First delete any messages relating to this batch from pay_message_lines
325: purge_rollback_messages(p_batch_header_id,'H');
326: end if;
327:
328: if (l_check_batch_id = 'Y') or (l_check_batch_id = 'N' and p_asg_action_id is not null) then

Line 869: l_line_text pay_message_lines.line_text%type;

865: p_severity in varchar2,
866: p_fail in boolean
867: ) is
868:
869: l_line_text pay_message_lines.line_text%type;
870: l_payroll_id number;
871:
872: begin
873: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);

Line 948: insert into pay_message_lines(

944: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',10);
945:
946: for i in 1..g_message_count loop
947: if g_message_tbl(i) is not null and g_message_id_tbl(i) is not null then
948: insert into pay_message_lines(
949: line_sequence,
950: message_level,
951: source_id,
952: source_type,

Line 955: pay_message_lines_s.nextval,

951: source_id,
952: source_type,
953: line_text)
954: values(
955: pay_message_lines_s.nextval,
956: g_message_severity_tbl(i),
957: g_message_id_tbl(i),
958: g_message_level_tbl(i),
959: g_message_tbl(i));

Line 988: delete from pay_message_lines

984:
985: begin
986: hr_utility.set_location('pay_mix_rollback_pkg.purge_rollback_messages',10);
987:
988: delete from pay_message_lines
989: where source_id = p_source_id
990: and source_type = p_msg_type;
991:
992: -- commit;