APPS.PY_ROLLBACK_PKG dependencies on PAY_MESSAGE_LINES

Line 1037: * Delete all messages (from pay_message_lines) as specified

1033: --
1034: end undo_bal_adjust;
1035: --
1036: /*
1037: * Delete all messages (from pay_message_lines) as specified
1038: * by the source_type. in other words:
1039: * P : payroll_action_id
1040: * A : assignment_action_id
1041: */

Line 1044: delete from pay_message_lines pml

1040: * A : assignment_action_id
1041: */
1042: procedure remove_messages(p_info in rollback_rec, p_source_type in varchar2) is
1043: begin
1044: delete from pay_message_lines pml
1045: where pml.source_type = p_source_type
1046: and pml.source_id =
1047: decode(p_source_type,
1048: 'P', p_info.pact_id,

Line 1180: l_line_text pay_message_lines.line_text%type;

1176: * is used for both assignment and payroll action rollback.
1177: */
1178: procedure ins_rollback_message(p_info in rollback_rec, p_level in varchar2) is
1179: c_indent varchar2(40);
1180: l_line_text pay_message_lines.line_text%type;
1181: l_line_sequence number;
1182: l_payroll_id number;
1183: l_source_id number;
1184: l_source_type pay_message_lines.source_type%type;

Line 1184: l_source_type pay_message_lines.source_type%type;

1180: l_line_text pay_message_lines.line_text%type;
1181: l_line_sequence number;
1182: l_payroll_id number;
1183: l_source_id number;
1184: l_source_type pay_message_lines.source_type%type;
1185: l_action_name hr_lookups.meaning%type;
1186: begin
1187: g_debug := hr_utility.debug_enabled;
1188: if g_debug then

Line 1251: insert into pay_message_lines (

1247: -- Write message into message lines table.
1248: if g_debug then
1249: hr_utility.set_location(c_indent, 10);
1250: end if;
1251: insert into pay_message_lines (
1252: line_sequence,
1253: payroll_id,
1254: message_level,
1255: source_id,

Line 1258: values (pay_message_lines_s.nextval,

1254: message_level,
1255: source_id,
1256: source_type,
1257: line_text)
1258: values (pay_message_lines_s.nextval,
1259: l_payroll_id,
1260: 'I', -- information.
1261: l_source_id,
1262: l_source_type,

Line 2526: message_text pay_message_lines.line_text%type;

2522: */
2523: procedure assact_error(p_info in rollback_rec,
2524: error_code in number, error_message in varchar2) is
2525: c_indent varchar2(40);
2526: message_text pay_message_lines.line_text%type;
2527: begin
2528: if g_debug then
2529: c_indent := 'py_rollback_pkg.assact_error';
2530: hr_utility.set_location(c_indent, 10);

Line 2549: insert into pay_message_lines (

2545: -- we can now insert the messge to message lines.
2546: if g_debug then
2547: hr_utility.set_location(c_indent, 10);
2548: end if;
2549: insert into pay_message_lines (
2550: line_sequence,
2551: payroll_id,
2552: message_level,
2553: source_id,

Line 2556: values (pay_message_lines_s.nextval,

2552: message_level,
2553: source_id,
2554: source_type,
2555: line_text)
2556: values (pay_message_lines_s.nextval,
2557: p_info.payroll_id,
2558: 'F', -- it's a fatal message.
2559: p_info.assact_id,
2560: 'A', -- assignment action level.