[Home] [Help]
355:
356: /********************************************************************************
357: -- This procedure populates the message saying
358: -- 'Multiple Run types exists for this Pay Advice' into
359: -- pay_message_lines table for the assignment which have more than one
360: -- Run type for the current payment.
361: -- This is the seeded message.
362: ********************************************************************************/
363:
383: l_message_text := fnd_message.get;
384:
385: if g_debug then
386: hr_utility.trace(' l_message_text..:'||l_message_text);
387: hr_utility.trace(' Inserting the multiple run types message into PAY_MESSAGE_LINES table');
388: end if;
389:
390: INSERT INTO pay_message_lines(line_sequence,
391: payroll_id,
386: hr_utility.trace(' l_message_text..:'||l_message_text);
387: hr_utility.trace(' Inserting the multiple run types message into PAY_MESSAGE_LINES table');
388: end if;
389:
390: INSERT INTO pay_message_lines(line_sequence,
391: payroll_id,
392: message_level,
393: source_id,
394: source_type,
677: -- archive_leave_balances : archives the anuual leave information
678: and also the accrual plan information
679: -- archive_employee_other_info : archive other info like KR job title,
680: KR Grade and KR Seniority.
681: -- populate_multiple_runtypes_msg: Inserts the message into pay_message_lines
682: if there are more then one run type exists
683: for the current payment.
684: -- pay_apac_payslip_archive.
685: archive_user_elements : This is the APAC common package is used to
776: -- cursor to fetch the sequence_number for populating the message
777: -- for multiple run types
778: CURSOR csr_msg_sequence
779: IS
780: SELECT pay_message_lines_s.nextval
781: FROM dual;
782:
783: l_run_type_id NUMBER:=0;
784: l_run_type_count NUMBER:=0;