APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_MESSAGE_LINES

Line 591: insert into pay_message_lines (

587: IF c_chk_archive_state_code%NOTFOUND THEN
588: --State Tax rules have not been defined
589: /* message to user -- State Tax rules not defined for the state ') */
590: message_text := 'State Tax Rules not Defind for GRE ' || to_char(l_gre) || ' for ' || P_state_abbrev;
591: insert into pay_message_lines (
592: line_sequence,
593: payroll_id,
594: message_level,
595: source_id,

Line 598: values (pay_message_lines_s.nextval,

594: message_level,
595: source_id,
596: source_type,
597: line_text)
598: values (pay_message_lines_s.nextval,
599: NULL,
600: 'F', -- it's a fatal message.
601: p_pactid,
602: 'P', -- payroll action level.

Line 698: insert into pay_message_lines (

694: IF c_chk_archive_state_code%NOTFOUND THEN
695: --State Tax rules have not been defined
696: /* message to user -- State Tax rules not defined for the state ') */
697: message_text := 'GRE_id ' || to_char(l_gre) || 'not archived- STR State ' || P_state_abbrev;
698: insert into pay_message_lines (
699: line_sequence,
700: payroll_id,
701: message_level,
702: source_id,

Line 705: values (pay_message_lines_s.nextval,

701: message_level,
702: source_id,
703: source_type,
704: line_text)
705: values (pay_message_lines_s.nextval,
706: NULL,
707: 'F', -- it's a fatal message.
708: p_pactid,
709: 'P', -- payroll action level.