APPS.HRASSACT dependencies on PAY_MESSAGE_LINES

Line 405: inserted into pay_message_lines

401: service row to exist when
402: processing a balance adjustment
403: action. This is for OAB.
404: 13-JAN-2000 alogue 115.13 Ensure that error_messages
405: inserted into pay_message_lines
406: are at max 240 in length.
407: 16-NOV-1999 nbristow 115.12 Now reversals and balance
408: adjustments populate
409: pay_action_contexts.

Line 757: from pay_message_lines

753: from pay_run_results
754: where assignment_action_id = p_assact_id)
755: or exists
756: (select null -- check for any MESSAGEs
757: from pay_message_lines
758: where source_type = 'A'
759: and source_id = p_assact_id)
760: -- or exists -- check for any latest balances
761: -- (select null

Line 786: from pay_message_lines

782: where assignment_action_id = p_assact_id
783: and status <> 'B')
784: or exists
785: (select null -- check for any MESSAGEs
786: from pay_message_lines
787: where source_type = 'A'
788: and source_id = p_assact_id)
789: -- or exists -- check for any latest balances
790: -- (select null

Line 860: from pay_message_lines

856: from pay_assignment_actions
857: where payroll_action_id = p_pact_id)
858: or exists
859: (select null -- check for any MESSAGEs
860: from pay_message_lines
861: where source_type = 'P'
862: and source_id = p_pact_id);
863: begin
864: g_debug := hr_utility.debug_enabled;

Line 1827: delete from pay_message_lines ML

1823: -- delete any messages associated with the assignment action.
1824: if g_debug then
1825: hr_utility.set_location('hrassact.do_assact_rollback',140);
1826: end if;
1827: delete from pay_message_lines ML
1828: where ML.source_type = 'A'
1829: and ML.source_id = p_assact_rec.assact_id;
1830: --
1831: if(p_pact_rec.action_type in ('P','U')) then

Line 1860: mesg_text pay_message_lines.line_text%type;

1856: -- Write a message to payroll action level to indicate
1857: -- that the action has been rolled back.
1858: --
1859: declare
1860: mesg_text pay_message_lines.line_text%type;
1861: begin
1862: hr_utility.set_message (801, 'HR_ACTION_ASACT_ROLLOK');
1863: hr_utility.set_message_token
1864: ('ASG_NUMBER',p_assact_rec.assignment_number);

Line 1876: insert into pay_message_lines

1872: -- want to spit out the asssignment's current Payroll ID as well.
1873: if g_debug then
1874: hr_utility.set_location('hrassact.do_assact_rollback',160);
1875: end if;
1876: insert into pay_message_lines
1877: (line_sequence,
1878: payroll_id,
1879: message_level,
1880: source_id,

Line 1885: (pay_message_lines_s.nextval,

1881: source_type,
1882: line_text
1883: )
1884: values
1885: (pay_message_lines_s.nextval,
1886: p_assact_rec.payroll_id,
1887: 'I', -- Information level
1888: p_pact_rec.pact_id,
1889: 'P',

Line 2114: delete from pay_message_lines ML

2110: -- trash messages
2111: if g_debug then
2112: hr_utility.set_location(c_indent,60);
2113: end if;
2114: delete from pay_message_lines ML
2115: where ML.source_type = 'P'
2116: and ML.source_id = p_payroll_action_id;
2117: --
2118: -- now trash the payroll action itself if the user so desires (and if

Line 2151: mesg_text pay_message_lines.line_text%type;

2147: --
2148: -- We now need to set up the message, depending on whether
2149: -- the payroll_id is null or not.
2150: declare
2151: mesg_text pay_message_lines.line_text%type;
2152: begin
2153: if(l_pact_rec.payroll_name is null) then
2154: -- Set up message for no payroll case.
2155: hr_utility.set_message(801,'HR_ACTION_PACT_ROLLNOPAY');

Line 2175: insert into pay_message_lines (

2171: --
2172: if g_debug then
2173: hr_utility.set_location(c_indent,100);
2174: end if;
2175: insert into pay_message_lines (
2176: line_sequence,
2177: payroll_id,
2178: message_level,
2179: source_id,

Line 2182: select pay_message_lines_s.nextval,

2178: message_level,
2179: source_id,
2180: source_type,
2181: line_text)
2182: select pay_message_lines_s.nextval,
2183: pac.payroll_id,
2184: 'I', -- information.
2185: pac.business_group_id,
2186: 'B',