APPS.HRASSACT dependencies on PAY_MESSAGE_LINES

Line 373: inserted into pay_message_lines

369: service row to exist when
370: processing a balance adjustment
371: action. This is for OAB.
372: 13-JAN-2000 alogue 115.13 Ensure that error_messages
373: inserted into pay_message_lines
374: are at max 240 in length.
375: 16-NOV-1999 nbristow 115.12 Now reversals and balance
376: adjustments populate
377: pay_action_contexts.

Line 725: from pay_message_lines

721: from pay_run_results
722: where assignment_action_id = p_assact_id)
723: or exists
724: (select null -- check for any MESSAGEs
725: from pay_message_lines
726: where source_type = 'A'
727: and source_id = p_assact_id)
728: -- or exists -- check for any latest balances
729: -- (select null

Line 754: from pay_message_lines

750: where assignment_action_id = p_assact_id
751: and status <> 'B')
752: or exists
753: (select null -- check for any MESSAGEs
754: from pay_message_lines
755: where source_type = 'A'
756: and source_id = p_assact_id)
757: -- or exists -- check for any latest balances
758: -- (select null

Line 828: from pay_message_lines

824: from pay_assignment_actions
825: where payroll_action_id = p_pact_id)
826: or exists
827: (select null -- check for any MESSAGEs
828: from pay_message_lines
829: where source_type = 'P'
830: and source_id = p_pact_id);
831: begin
832: g_debug := hr_utility.debug_enabled;

Line 1795: delete from pay_message_lines ML

1791: -- delete any messages associated with the assignment action.
1792: if g_debug then
1793: hr_utility.set_location('hrassact.do_assact_rollback',140);
1794: end if;
1795: delete from pay_message_lines ML
1796: where ML.source_type = 'A'
1797: and ML.source_id = p_assact_rec.assact_id;
1798: --
1799: if(p_pact_rec.action_type in ('P','U')) then

Line 1828: mesg_text pay_message_lines.line_text%type;

1824: -- Write a message to payroll action level to indicate
1825: -- that the action has been rolled back.
1826: --
1827: declare
1828: mesg_text pay_message_lines.line_text%type;
1829: begin
1830: hr_utility.set_message (801, 'HR_ACTION_ASACT_ROLLOK');
1831: hr_utility.set_message_token
1832: ('ASG_NUMBER',p_assact_rec.assignment_number);

Line 1844: insert into pay_message_lines

1840: -- want to spit out the asssignment's current Payroll ID as well.
1841: if g_debug then
1842: hr_utility.set_location('hrassact.do_assact_rollback',160);
1843: end if;
1844: insert into pay_message_lines
1845: (line_sequence,
1846: payroll_id,
1847: message_level,
1848: source_id,

Line 1853: (pay_message_lines_s.nextval,

1849: source_type,
1850: line_text
1851: )
1852: values
1853: (pay_message_lines_s.nextval,
1854: p_assact_rec.payroll_id,
1855: 'I', -- Information level
1856: p_pact_rec.pact_id,
1857: 'P',

Line 2082: delete from pay_message_lines ML

2078: -- trash messages
2079: if g_debug then
2080: hr_utility.set_location(c_indent,60);
2081: end if;
2082: delete from pay_message_lines ML
2083: where ML.source_type = 'P'
2084: and ML.source_id = p_payroll_action_id;
2085: --
2086: -- now trash the payroll action itself if the user so desires (and if

Line 2119: mesg_text pay_message_lines.line_text%type;

2115: --
2116: -- We now need to set up the message, depending on whether
2117: -- the payroll_id is null or not.
2118: declare
2119: mesg_text pay_message_lines.line_text%type;
2120: begin
2121: if(l_pact_rec.payroll_name is null) then
2122: -- Set up message for no payroll case.
2123: hr_utility.set_message(801,'HR_ACTION_PACT_ROLLNOPAY');

Line 2143: insert into pay_message_lines (

2139: --
2140: if g_debug then
2141: hr_utility.set_location(c_indent,100);
2142: end if;
2143: insert into pay_message_lines (
2144: line_sequence,
2145: payroll_id,
2146: message_level,
2147: source_id,

Line 2150: select pay_message_lines_s.nextval,

2146: message_level,
2147: source_id,
2148: source_type,
2149: line_text)
2150: select pay_message_lines_s.nextval,
2151: pac.payroll_id,
2152: 'I', -- information.
2153: pac.business_group_id,
2154: 'B',