APPS.PAY_GB_RTI_FPS dependencies on PAY_MESSAGE_LINES

Line 5806: INTO pay_message_lines

5802: BEGIN
5803: hr_utility.set_location(' Entering: populate_run_msg',111);
5804:
5805: INSERT
5806: INTO pay_message_lines
5807: (
5808: line_sequence,
5809: payroll_id,
5810: message_level,

Line 5817: pay_message_lines_s.nextval ,

5813: line_text
5814: )
5815: VALUES
5816: (
5817: pay_message_lines_s.nextval ,
5818: 100 ,
5819: p_message_level, --'F' ,
5820: p_assignment_action_id ,
5821: 'A' ,

Line 12479: FROM pay_message_lines

12475: --CURSOR csr_err_msg(asg_action_id NUMBER)
12476: CURSOR csr_prepay_err_msg(asg_action_id NUMBER)
12477: IS
12478: SELECT DISTINCT line_text
12479: FROM pay_message_lines
12480: WHERE source_id = asg_action_id --9919881 --asg_action_id
12481: AND message_level <> 'W'-- p_message_level
12482: AND line_text like '%Pre payment is not run%'
12483: AND payroll_id = 100;

Line 12689: -- Cursor to fetch error Messages from pay_message lines table

12685: )
12686:
12687: ORDER BY end_date DESC;
12688:
12689: -- Cursor to fetch error Messages from pay_message lines table
12690: --CURSOR csr_err_msg(asg_action_id NUMBER)
12691: CURSOR csr_err_msg(asg_action_id NUMBER)
12692: IS
12693: SELECT DISTINCT line_text

Line 12694: FROM pay_message_lines

12690: --CURSOR csr_err_msg(asg_action_id NUMBER)
12691: CURSOR csr_err_msg(asg_action_id NUMBER)
12692: IS
12693: SELECT DISTINCT line_text
12694: FROM pay_message_lines
12695: WHERE source_id = asg_action_id
12696: AND message_level <> 'W'-- p_message_level
12697: AND payroll_id = 100;
12698:

Line 12703: FROM pay_message_lines

12699: --CURSOR csr_warn_msg(asg_action_id NUMBER)
12700: CURSOR csr_warn_msg(asg_action_id NUMBER)
12701: IS
12702: SELECT DISTINCT line_text
12703: FROM pay_message_lines
12704: WHERE source_id = asg_action_id
12705: AND message_level = 'W'
12706: AND payroll_id = 100;
12707:

Line 12754: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;

12750:
12751: OPEN csr_err_msg(action_id.asg_action_id);
12752: FETCH csr_err_msg INTO err_msg;
12753: if csr_err_msg%notfound then
12754: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;
12755: end if;
12756:
12757: l_error_flag := 'Y';
12758:

Line 12801: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id

12797:
12798: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
12799:
12800: /* if csr_err_msg%notfound then
12801: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id
12802: AND MESSAGE_LEVEL = 'W' and rownum <=1;
12803: end if;
12804: */
12805: