APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_MESSAGE_LINES

Line 6436: INTO pay_message_lines

6432: BEGIN
6433: hr_utility.set_location(' Entering: populate_run_msg',111);
6434:
6435: INSERT
6436: INTO pay_message_lines
6437: (
6438: line_sequence,
6439: payroll_id,
6440: message_level,

Line 6447: pay_message_lines_s.nextval ,

6443: line_text
6444: )
6445: VALUES
6446: (
6447: pay_message_lines_s.nextval ,
6448: 100 ,
6449: p_message_level, --'F' ,
6450: p_assignment_action_id ,
6451: 'A' ,

Line 13234: FROM pay_message_lines

13230: --CURSOR csr_err_msg(asg_action_id NUMBER)
13231: CURSOR csr_prepay_err_msg(asg_action_id NUMBER)
13232: IS
13233: SELECT DISTINCT line_text
13234: FROM pay_message_lines
13235: WHERE source_id = asg_action_id --9919881 --asg_action_id
13236: AND message_level <> 'W'-- p_message_level
13237: AND line_text like '%Pre payment is not run%'
13238: AND payroll_id = 100;

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

13440: )
13441:
13442: ORDER BY end_date DESC;
13443:
13444: -- Cursor to fetch error Messages from pay_message lines table
13445: --CURSOR csr_err_msg(asg_action_id NUMBER)
13446: CURSOR csr_err_msg(asg_action_id NUMBER)
13447: IS
13448: SELECT DISTINCT line_text

Line 13449: FROM pay_message_lines

13445: --CURSOR csr_err_msg(asg_action_id NUMBER)
13446: CURSOR csr_err_msg(asg_action_id NUMBER)
13447: IS
13448: SELECT DISTINCT line_text
13449: FROM pay_message_lines
13450: WHERE source_id = asg_action_id
13451: AND message_level <> 'W'-- p_message_level
13452: AND payroll_id = 100;
13453:

Line 13458: FROM pay_message_lines

13454: --CURSOR csr_warn_msg(asg_action_id NUMBER)
13455: CURSOR csr_warn_msg(asg_action_id NUMBER)
13456: IS
13457: SELECT DISTINCT line_text
13458: FROM pay_message_lines
13459: WHERE source_id = asg_action_id
13460: AND message_level = 'W'
13461: AND payroll_id = 100;
13462:

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

13505:
13506: OPEN csr_err_msg(action_id.asg_action_id);
13507: FETCH csr_err_msg INTO err_msg;
13508: if csr_err_msg%notfound then
13509: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id and rownum <=1;
13510: end if;
13511:
13512: l_error_flag := 'Y';
13513:

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

13552:
13553: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
13554:
13555: /* if csr_err_msg%notfound then
13556: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id
13557: AND MESSAGE_LEVEL = 'W' and rownum <=1;
13558: end if;
13559: */
13560: