APPS.PY_ROLLBACK_PKG dependencies on PAY_MESSAGE_LINES

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

1028: --
1029: end undo_bal_adjust;
1030: --
1031: /*
1032: * Delete all messages (from pay_message_lines) as specified
1033: * by the source_type. in other words:
1034: * P : payroll_action_id
1035: * A : assignment_action_id
1036: */

Line 1039: delete from pay_message_lines pml

1035: * A : assignment_action_id
1036: */
1037: procedure remove_messages(p_info in rollback_rec, p_source_type in varchar2) is
1038: begin
1039: delete from pay_message_lines pml
1040: where pml.source_type = p_source_type
1041: and pml.source_id =
1042: decode(p_source_type,
1043: 'P', p_info.pact_id,

Line 1175: l_line_text pay_message_lines.line_text%type;

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

Line 1179: l_source_type pay_message_lines.source_type%type;

1175: l_line_text pay_message_lines.line_text%type;
1176: l_line_sequence number;
1177: l_payroll_id number;
1178: l_source_id number;
1179: l_source_type pay_message_lines.source_type%type;
1180: l_action_name hr_lookups.meaning%type;
1181: begin
1182: g_debug := hr_utility.debug_enabled;
1183: if g_debug then

Line 1246: insert into pay_message_lines (

1242: -- Write message into message lines table.
1243: if g_debug then
1244: hr_utility.set_location(c_indent, 10);
1245: end if;
1246: insert into pay_message_lines (
1247: line_sequence,
1248: payroll_id,
1249: message_level,
1250: source_id,

Line 1253: values (pay_message_lines_s.nextval,

1249: message_level,
1250: source_id,
1251: source_type,
1252: line_text)
1253: values (pay_message_lines_s.nextval,
1254: l_payroll_id,
1255: 'I', -- information.
1256: l_source_id,
1257: l_source_type,

Line 2438: message_text pay_message_lines.line_text%type;

2434: */
2435: procedure assact_error(p_info in rollback_rec,
2436: error_code in number, error_message in varchar2) is
2437: c_indent varchar2(40);
2438: message_text pay_message_lines.line_text%type;
2439: begin
2440: if g_debug then
2441: c_indent := 'py_rollback_pkg.assact_error';
2442: hr_utility.set_location(c_indent, 10);

Line 2461: insert into pay_message_lines (

2457: -- we can now insert the messge to message lines.
2458: if g_debug then
2459: hr_utility.set_location(c_indent, 10);
2460: end if;
2461: insert into pay_message_lines (
2462: line_sequence,
2463: payroll_id,
2464: message_level,
2465: source_id,

Line 2468: values (pay_message_lines_s.nextval,

2464: message_level,
2465: source_id,
2466: source_type,
2467: line_text)
2468: values (pay_message_lines_s.nextval,
2469: p_info.payroll_id,
2470: 'F', -- it's a fatal message.
2471: p_info.assact_id,
2472: 'A', -- assignment action level.