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 932: l_line_text pay_message_lines.line_text%type;

928: p_severity in varchar2,
929: p_fail in boolean
930: ) is
931:
932: l_line_text pay_message_lines.line_text%type;
933: l_payroll_id number;
934:
935: begin
936: hr_utility.set_location('pay_mix_rollback_pkg.insert_rollback_message',10);

Line 1011: insert into pay_message_lines(

1007: hr_utility.set_location('pay_mix_rollback_pkg.commit_messages',10);
1008:
1009: for i in 1..g_message_count loop
1010: if g_message_tbl(i) is not null and g_message_id_tbl(i) is not null then
1011: insert into pay_message_lines(
1012: line_sequence,
1013: message_level,
1014: source_id,
1015: source_type,

Line 1018: pay_message_lines_s.nextval,

1014: source_id,
1015: source_type,
1016: line_text)
1017: values(
1018: pay_message_lines_s.nextval,
1019: g_message_severity_tbl(i),
1020: g_message_id_tbl(i),
1021: g_message_level_tbl(i),
1022: g_message_tbl(i));

Line 1051: delete from pay_message_lines

1047:
1048: begin
1049: hr_utility.set_location('pay_mix_rollback_pkg.purge_rollback_messages',10);
1050:
1051: delete from pay_message_lines
1052: where source_id = p_source_id
1053: and source_type = p_msg_type;
1054:
1055: -- commit;