eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_LABOR_DIST dependencies on FND_MESSAGE

Line 637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');

633: WHEN OTHERS THEN
634: ROLLBACK;
635:
636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
639: fnd_msg_pub.add;
640: retcode := 2;
641: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);

634: ROLLBACK;
635:
636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
639: fnd_msg_pub.add;
640: retcode := 2;
641: psp_message_s.print_error(p_mode => FND_FILE.LOG,
642: p_print_header => FND_API.G_TRUE);

Line 755: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');

751: END;
752:
753: END LOOP;
754:
755: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
756: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
757: -- l_dist_message := fnd_message.get;
758: -- return success to the concurrent program
759: -- errbuf := SUBSTR(g_msg || chr(10) || l_dist_message,1,230);

Line 756: fnd_message.set_token('NUMB_BATCHES',l_batch_count);

752:
753: END LOOP;
754:
755: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
756: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
757: -- l_dist_message := fnd_message.get;
758: -- return success to the concurrent program
759: -- errbuf := SUBSTR(g_msg || chr(10) || l_dist_message,1,230);
760: retcode := 0;

Line 757: -- l_dist_message := fnd_message.get;

753: END LOOP;
754:
755: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
756: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
757: -- l_dist_message := fnd_message.get;
758: -- return success to the concurrent program
759: -- errbuf := SUBSTR(g_msg || chr(10) || l_dist_message,1,230);
760: retcode := 0;
761: /*********************************************************************

Line 771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');

767: EXCEPTION
768: WHEN EXCESS_SALARY_FOUND THEN
769: ROLLBACK;
770: g_error_api_path := SUBSTR('CREATE_LINES 1:'||g_error_api_path,1,230);
771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');
772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);

Line 772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);

768: WHEN EXCESS_SALARY_FOUND THEN
769: ROLLBACK;
770: g_error_api_path := SUBSTR('CREATE_LINES 1:'||g_error_api_path,1,230);
771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');
772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);
776: fnd_message.set_token('END_DATE',l_sub_end_dt);

Line 773: fnd_message.set_token('EMP_NAME',l_emp_name);

769: ROLLBACK;
770: g_error_api_path := SUBSTR('CREATE_LINES 1:'||g_error_api_path,1,230);
771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');
772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);
776: fnd_message.set_token('END_DATE',l_sub_end_dt);
777: /*********************************************************************

Line 774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);

770: g_error_api_path := SUBSTR('CREATE_LINES 1:'||g_error_api_path,1,230);
771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');
772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);
776: fnd_message.set_token('END_DATE',l_sub_end_dt);
777: /*********************************************************************
778: ** Added by Bijoy - 08/06/99 to display error in consurrent log

Line 775: fnd_message.set_token('START_DATE',l_sub_start_dt);

771: fnd_message.set_name('PSP','PSP_EXCESS_SALARY_FOUND');
772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);
776: fnd_message.set_token('END_DATE',l_sub_end_dt);
777: /*********************************************************************
778: ** Added by Bijoy - 08/06/99 to display error in consurrent log
779: *******************************************************************/

Line 776: fnd_message.set_token('END_DATE',l_sub_end_dt);

772: fnd_message.set_token('EXCESS_SAL',l_excess_sal);
773: fnd_message.set_token('EMP_NAME',l_emp_name);
774: fnd_message.set_token('SOURCE_DESC',l_source_type_desc);
775: fnd_message.set_token('START_DATE',l_sub_start_dt);
776: fnd_message.set_token('END_DATE',l_sub_end_dt);
777: /*********************************************************************
778: ** Added by Bijoy - 08/06/99 to display error in consurrent log
779: *******************************************************************/
780: fnd_msg_pub.add;

Line 784: -- l_dist_message := fnd_message.get;

780: fnd_msg_pub.add;
781: retcode := 2;
782: psp_message_s.print_error(p_mode => FND_FILE.LOG,
783: p_print_header => FND_API.G_TRUE);
784: -- l_dist_message := fnd_message.get;
785:
786: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);
787: raise; --- for nih sal cap 4304623
788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 799: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');

795: p_encoded => FND_API.G_FALSE,
796: p_data => l_msg_data,
797: p_msg_index_out => l_msg_count); */
798:
799: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
800: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
801: fnd_msg_pub.add;
802: -- l_dist_message := fnd_message.get;
803:

Line 800: fnd_message.set_token('NUMB_BATCHES',l_batch_count);

796: p_data => l_msg_data,
797: p_msg_index_out => l_msg_count); */
798:
799: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
800: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
801: fnd_msg_pub.add;
802: -- l_dist_message := fnd_message.get;
803:
804: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);

Line 802: -- l_dist_message := fnd_message.get;

798:
799: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
800: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
801: fnd_msg_pub.add;
802: -- l_dist_message := fnd_message.get;
803:
804: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);
805: retcode := 2;
806: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 819: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');

815: p_encoded => FND_API.G_FALSE,
816: p_data => l_msg_data,
817: p_msg_index_out => l_msg_count); */
818:
819: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
820: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
821: fnd_msg_pub.add;
822: -- l_dist_message := fnd_message.get;
823:

Line 820: fnd_message.set_token('NUMB_BATCHES',l_batch_count);

816: p_data => l_msg_data,
817: p_msg_index_out => l_msg_count); */
818:
819: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
820: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
821: fnd_msg_pub.add;
822: -- l_dist_message := fnd_message.get;
823:
824: /* errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230); */

Line 822: -- l_dist_message := fnd_message.get;

818:
819: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
820: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
821: fnd_msg_pub.add;
822: -- l_dist_message := fnd_message.get;
823:
824: /* errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230); */
825: retcode := 2;
826: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 995: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');

991: Get_assign_number(p_assignment_id
992: ,p_payroll_start_date
993: ,g_assignment_number
994: ,g_employee_number);--Bug 2374680
995: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

Line 996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

992: ,p_payroll_start_date
993: ,g_assignment_number
994: ,g_employee_number);--Bug 2374680
995: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

Line 997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680

993: ,g_assignment_number
994: ,g_employee_number);--Bug 2374680
995: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1001: fnd_msg_pub.add;

Line 999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

995: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1001: fnd_msg_pub.add;
1002: -- Commented for bug fix 2267098 (return status set in exception)
1003: -- p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

996: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1001: fnd_msg_pub.add;
1002: -- Commented for bug fix 2267098 (return status set in exception)
1003: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
1004: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098

Line 1526: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');

1522: Get_assign_number(p_assignment_id
1523: ,p_payroll_start_date
1524: ,g_assignment_number
1525: ,g_employee_number);--Bug 2374680
1526: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

Line 1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

1523: ,p_payroll_start_date
1524: ,g_assignment_number
1525: ,g_employee_number);--Bug 2374680
1526: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

Line 1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680

1524: ,g_assignment_number
1525: ,g_employee_number);--Bug 2374680
1526: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1532: fnd_msg_pub.add;

Line 1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

1526: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1532: fnd_msg_pub.add;
1533: -- Commented for bug fix 2267098 (return status set in exception)
1534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

1527: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1532: fnd_msg_pub.add;
1533: -- Commented for bug fix 2267098 (return status set in exception)
1534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
1535: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098

Line 2072: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');

2068: Get_assign_number(p_assignment_id
2069: ,p_payroll_start_date
2070: ,g_assignment_number
2071: ,g_employee_number);--Bug 2374680
2072: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

Line 2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

2069: ,p_payroll_start_date
2070: ,g_assignment_number
2071: ,g_employee_number);--Bug 2374680
2072: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

Line 2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680

2070: ,g_assignment_number
2071: ,g_employee_number);--Bug 2374680
2072: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2078: fnd_msg_pub.add;

Line 2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

2072: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2078: fnd_msg_pub.add;
2079: -- Commented for bug fix 2267098 (return status set in exception)
2080: -- p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

2073: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2078: fnd_msg_pub.add;
2079: -- Commented for bug fix 2267098 (return status set in exception)
2080: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
2081: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098

Line 2652: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');

2648: Get_assign_number(p_assignment_id
2649: ,p_payroll_start_date
2650: ,g_assignment_number
2651: ,g_employee_number);--Bug 2374680
2652: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

Line 2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

2649: ,p_payroll_start_date
2650: ,g_assignment_number
2651: ,g_employee_number);--Bug 2374680
2652: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

Line 2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680

2650: ,g_assignment_number
2651: ,g_employee_number);--Bug 2374680
2652: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2658: fnd_msg_pub.add;

Line 2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

2652: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2658: fnd_msg_pub.add;
2659: -- Commented for bug fix 2267098 (return status set in exception)
2660: -- p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

2653: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2658: fnd_msg_pub.add;
2659: -- Commented for bug fix 2267098 (return status set in exception)
2660: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
2661: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098

Line 3199: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');

3195: Get_assign_number(p_assignment_id
3196: ,p_payroll_start_date
3197: ,g_assignment_number
3198: ,g_employee_number);--Bug 2374680
3199: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

Line 3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

3196: ,p_payroll_start_date
3197: ,g_assignment_number
3198: ,g_employee_number);--Bug 2374680
3199: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

Line 3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680

3197: ,g_assignment_number
3198: ,g_employee_number);--Bug 2374680
3199: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
3205: fnd_msg_pub.add;

Line 3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);

3199: fnd_message.set_name('PSP','PSP_LD_PERCENT_GREATER_100');
3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
3205: fnd_msg_pub.add;
3206: -- Commented for bug fix 2267098 (return status set in exception)
3207: -- p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);

3200: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
3205: fnd_msg_pub.add;
3206: -- Commented for bug fix 2267098 (return status set in exception)
3207: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
3208: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098

Line 3965: fnd_message.set_name('PSP','PSP_LD_DEFAULT_AC_NOT_SET_UP');

3961: p_return_status := fnd_api.g_ret_sts_unexp_error;
3962:
3963: WHEN DEFAULT_AC_NOT_FOUND THEN
3964: g_error_api_path := SUBSTR('DEFAULT_ACCOUNT:'||g_error_api_path,1,230);
3965: fnd_message.set_name('PSP','PSP_LD_DEFAULT_AC_NOT_SET_UP');
3966: fnd_msg_pub.add;
3967: g_msg := SUBSTR(fnd_message.get,1,230);
3968: --- Next line added by Abhijit as a patch on 7/24/98.
3969: p_proc_executed := 'FALSE';

Line 3967: g_msg := SUBSTR(fnd_message.get,1,230);

3963: WHEN DEFAULT_AC_NOT_FOUND THEN
3964: g_error_api_path := SUBSTR('DEFAULT_ACCOUNT:'||g_error_api_path,1,230);
3965: fnd_message.set_name('PSP','PSP_LD_DEFAULT_AC_NOT_SET_UP');
3966: fnd_msg_pub.add;
3967: g_msg := SUBSTR(fnd_message.get,1,230);
3968: --- Next line added by Abhijit as a patch on 7/24/98.
3969: p_proc_executed := 'FALSE';
3970: p_return_status := fnd_api.g_ret_sts_success;
3971:

Line 4552: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

4548: p_return_status := fnd_api.g_ret_sts_unexp_error;
4549:
4550: WHEN NO_PROFILE_EXISTS THEN
4551: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4552: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4553: fnd_msg_pub.add;
4554: p_return_status := fnd_api.g_ret_sts_unexp_error;
4555:
4556: WHEN NO_VAL_DATE_MATCHES THEN

Line 4558: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

4554: p_return_status := fnd_api.g_ret_sts_unexp_error;
4555:
4556: WHEN NO_VAL_DATE_MATCHES THEN
4557: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4558: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4559: fnd_message.set_token('ORG_NAME',l_organization_name);
4560: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4561: fnd_msg_pub.add;
4562: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4559: fnd_message.set_token('ORG_NAME',l_organization_name);

4555:
4556: WHEN NO_VAL_DATE_MATCHES THEN
4557: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4558: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4559: fnd_message.set_token('ORG_NAME',l_organization_name);
4560: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4561: fnd_msg_pub.add;
4562: p_return_status := fnd_api.g_ret_sts_unexp_error;
4563:

Line 4560: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

4556: WHEN NO_VAL_DATE_MATCHES THEN
4557: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4558: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4559: fnd_message.set_token('ORG_NAME',l_organization_name);
4560: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4561: fnd_msg_pub.add;
4562: p_return_status := fnd_api.g_ret_sts_unexp_error;
4563:
4564: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 4566: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

4562: p_return_status := fnd_api.g_ret_sts_unexp_error;
4563:
4564: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4565: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4566: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4567: fnd_message.set_token('ORG_NAME',l_organization_name);
4568: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4569: fnd_msg_pub.add;
4570: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4567: fnd_message.set_token('ORG_NAME',l_organization_name);

4563:
4564: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4565: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4566: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4567: fnd_message.set_token('ORG_NAME',l_organization_name);
4568: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4569: fnd_msg_pub.add;
4570: p_return_status := fnd_api.g_ret_sts_unexp_error;
4571:

Line 4568: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);

4564: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4565: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4566: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4567: fnd_message.set_token('ORG_NAME',l_organization_name);
4568: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4569: fnd_msg_pub.add;
4570: p_return_status := fnd_api.g_ret_sts_unexp_error;
4571:
4572: WHEN NO_REC_IN_GMS_AWARDS_V THEN

Line 4574: fnd_message.set_name('PSP','PSP_NO_REC_IN_GMS_AWARDS_V');

4570: p_return_status := fnd_api.g_ret_sts_unexp_error;
4571:
4572: WHEN NO_REC_IN_GMS_AWARDS_V THEN
4573: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4574: fnd_message.set_name('PSP','PSP_NO_REC_IN_GMS_AWARDS_V');
4575: fnd_msg_pub.add;
4576: p_return_status := fnd_api.g_ret_sts_unexp_error;
4577:
4578: WHEN PROJECT_AWARD_NOT_LNKD THEN

Line 4580: fnd_message.set_name('PSP','PSP_PROJECT_AWARD_NOT_LINKED');

4576: p_return_status := fnd_api.g_ret_sts_unexp_error;
4577:
4578: WHEN PROJECT_AWARD_NOT_LNKD THEN
4579: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4580: fnd_message.set_name('PSP','PSP_PROJECT_AWARD_NOT_LINKED');
4581: fnd_message.set_token('PROJECT_NAME',to_char(l_project_id));
4582: fnd_message.set_token('AWARD_NAME',to_char(l_award_id));
4583: fnd_msg_pub.add;
4584: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4581: fnd_message.set_token('PROJECT_NAME',to_char(l_project_id));

4577:
4578: WHEN PROJECT_AWARD_NOT_LNKD THEN
4579: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4580: fnd_message.set_name('PSP','PSP_PROJECT_AWARD_NOT_LINKED');
4581: fnd_message.set_token('PROJECT_NAME',to_char(l_project_id));
4582: fnd_message.set_token('AWARD_NAME',to_char(l_award_id));
4583: fnd_msg_pub.add;
4584: p_return_status := fnd_api.g_ret_sts_unexp_error;
4585:

Line 4582: fnd_message.set_token('AWARD_NAME',to_char(l_award_id));

4578: WHEN PROJECT_AWARD_NOT_LNKD THEN
4579: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4580: fnd_message.set_name('PSP','PSP_PROJECT_AWARD_NOT_LINKED');
4581: fnd_message.set_token('PROJECT_NAME',to_char(l_project_id));
4582: fnd_message.set_token('AWARD_NAME',to_char(l_award_id));
4583: fnd_msg_pub.add;
4584: p_return_status := fnd_api.g_ret_sts_unexp_error;
4585:
4586: WHEN SUSPENSE_AC_INVALID THEN

Line 4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');

4589: FETCH employee_name_cur INTO l_employee_name;
4590: CLOSE employee_name_cur;
4591:
4592: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
4594: fnd_message.set_token('ORG_NAME',l_organization_name);
4595: fnd_message.set_token('PATC_STATUS',l_patc_status);
4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
4597: fnd_msg_pub.add;

Line 4594: fnd_message.set_token('ORG_NAME',l_organization_name);

4590: CLOSE employee_name_cur;
4591:
4592: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
4594: fnd_message.set_token('ORG_NAME',l_organization_name);
4595: fnd_message.set_token('PATC_STATUS',l_patc_status);
4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
4597: fnd_msg_pub.add;
4598: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4595: fnd_message.set_token('PATC_STATUS',l_patc_status);

4591:
4592: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
4594: fnd_message.set_token('ORG_NAME',l_organization_name);
4595: fnd_message.set_token('PATC_STATUS',l_patc_status);
4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
4597: fnd_msg_pub.add;
4598: p_return_status := fnd_api.g_ret_sts_unexp_error;
4599:

Line 4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611

4592: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
4594: fnd_message.set_token('ORG_NAME',l_organization_name);
4595: fnd_message.set_token('PATC_STATUS',l_patc_status);
4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
4597: fnd_msg_pub.add;
4598: p_return_status := fnd_api.g_ret_sts_unexp_error;
4599:
4600: WHEN OTHERS THEN

Line 7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');

7305: open get_person_name(l_person_id);
7306: fetch get_person_name into l_full_name;
7307: close get_person_name;
7308:
7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');
7310: fnd_message.set_token('ENAME',l_full_name);
7311: fnd_message.set_token('ASGNUM',l_asg_number);
7312: fnd_message.set_token('DISTDATE',t_dist_date(i));
7313: fnd_msg_pub.add;

Line 7310: fnd_message.set_token('ENAME',l_full_name);

7306: fetch get_person_name into l_full_name;
7307: close get_person_name;
7308:
7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');
7310: fnd_message.set_token('ENAME',l_full_name);
7311: fnd_message.set_token('ASGNUM',l_asg_number);
7312: fnd_message.set_token('DISTDATE',t_dist_date(i));
7313: fnd_msg_pub.add;
7314: raise no_excess_account;

Line 7311: fnd_message.set_token('ASGNUM',l_asg_number);

7307: close get_person_name;
7308:
7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');
7310: fnd_message.set_token('ENAME',l_full_name);
7311: fnd_message.set_token('ASGNUM',l_asg_number);
7312: fnd_message.set_token('DISTDATE',t_dist_date(i));
7313: fnd_msg_pub.add;
7314: raise no_excess_account;
7315: end if;

Line 7312: fnd_message.set_token('DISTDATE',t_dist_date(i));

7308:
7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');
7310: fnd_message.set_token('ENAME',l_full_name);
7311: fnd_message.set_token('ASGNUM',l_asg_number);
7312: fnd_message.set_token('DISTDATE',t_dist_date(i));
7313: fnd_msg_pub.add;
7314: raise no_excess_account;
7315: end if;
7316: close generic_excess_act;

Line 8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');

8120: t_task_id(i),
8121: t_award_id(i),
8122: t_expenditure_organization_id(i),
8123: t_expenditure_type(i));
8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

Line 8125: fnd_message.set_token('ORG_NAME',l_organization_name);

8121: t_award_id(i),
8122: t_expenditure_organization_id(i),
8123: t_expenditure_type(i));
8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

Line 8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);

8122: t_expenditure_organization_id(i),
8123: t_expenditure_type(i));
8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);

Line 8127: fnd_message.set_token('ASG_NUM',l_asg_num);

8123: t_expenditure_type(i));
8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);
8131: fnd_msg_pub.add;

Line 8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

8124: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);
8131: fnd_msg_pub.add;
8132: raise suspense_autopop_fail;

Line 8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

8125: fnd_message.set_token('ORG_NAME',l_organization_name);
8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);
8131: fnd_msg_pub.add;
8132: raise suspense_autopop_fail;
8133: else

Line 8130: fnd_message.set_token('EFF_DATE',l_effective_date);

8126: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name);
8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);
8131: fnd_msg_pub.add;
8132: raise suspense_autopop_fail;
8133: else
8134: suspense_account(

Line 8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');

8209: ---fnd_file.put_line(fnd_file.log,'failure in _autopop code='||l_auto_status||' person_id, asgid, edate='||
8210: ---t_person_id(i)||' , '|| t_assignment_id(i)||' , '|| l_effective_date);
8211:
8212: if p_schedule_type = 'SUSPENSE' then
8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
8214: fnd_message.set_token('ORG_NAME',l_organization_name);
8215: fnd_message.set_token('PATC_STATUS',l_patc_status);
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;

Line 8214: fnd_message.set_token('ORG_NAME',l_organization_name);

8210: ---t_person_id(i)||' , '|| t_assignment_id(i)||' , '|| l_effective_date);
8211:
8212: if p_schedule_type = 'SUSPENSE' then
8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
8214: fnd_message.set_token('ORG_NAME',l_organization_name);
8215: fnd_message.set_token('PATC_STATUS',l_patc_status);
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;
8218: raise suspense_autopop_fail;

Line 8215: fnd_message.set_token('PATC_STATUS',l_patc_status);

8211:
8212: if p_schedule_type = 'SUSPENSE' then
8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
8214: fnd_message.set_token('ORG_NAME',l_organization_name);
8215: fnd_message.set_token('PATC_STATUS',l_patc_status);
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;
8218: raise suspense_autopop_fail;
8219: else

Line 8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611

8212: if p_schedule_type = 'SUSPENSE' then
8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
8214: fnd_message.set_token('ORG_NAME',l_organization_name);
8215: fnd_message.set_token('PATC_STATUS',l_patc_status);
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;
8218: raise suspense_autopop_fail;
8219: else
8220: update psp_distribution_lines

Line 8573: fnd_message.set_name('PSP','PSP_SET_GEN_EXCESS_ORG');

8569: l_gen_excess_org_id := -- 4744285
8570: psp_general.get_configuration_option_value(g_business_group_id,
8571: 'PSP_GENERIC_EXCESS_ACCT_ORG');
8572: if l_gen_excess_org_id is null then
8573: fnd_message.set_name('PSP','PSP_SET_GEN_EXCESS_ORG');
8574: fnd_msg_pub.add;
8575: l_error_flag := 'Y';
8576: else
8577:

Line 8583: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');

8579: fetch check_generic_excess into l_count;
8580: close check_generic_excess;
8581:
8582: if l_count = 0 then
8583: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8584: fnd_message.set_token('BDATE',l_begin_dist_date);
8585: fnd_msg_pub.add;
8586: l_error_flag := 'Y';
8587: else

Line 8584: fnd_message.set_token('BDATE',l_begin_dist_date);

8580: close check_generic_excess;
8581:
8582: if l_count = 0 then
8583: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8584: fnd_message.set_token('BDATE',l_begin_dist_date);
8585: fnd_msg_pub.add;
8586: l_error_flag := 'Y';
8587: else
8588: open check_generic_excess(l_end_dist_date, l_gen_excess_org_id, g_business_group_id);

Line 8593: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');

8589: fetch check_generic_excess into l_count;
8590: close check_generic_excess;
8591:
8592: if l_count = 0 then
8593: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8594: fnd_message.set_token('BDATE',l_end_dist_date);
8595: fnd_msg_pub.add;
8596: l_error_flag := 'Y';
8597: end if;

Line 8594: fnd_message.set_token('BDATE',l_end_dist_date);

8590: close check_generic_excess;
8591:
8592: if l_count = 0 then
8593: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8594: fnd_message.set_token('BDATE',l_end_dist_date);
8595: fnd_msg_pub.add;
8596: l_error_flag := 'Y';
8597: end if;
8598: end if;

Line 8617: fnd_message.set_name('PSP', 'PSP_MAP_SAL_CAP_SPONSOR');

8613: l_sponsor_id := psp_general.get_configuration_option_value(g_business_group_id,
8614: 'PSP_SET_SPONSORS_FOR_CAPPING', l_sponsor_code);
8615: if l_sponsor_id is null then
8616: l_error_flag := 'Y';
8617: fnd_message.set_name('PSP', 'PSP_MAP_SAL_CAP_SPONSOR');
8618: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8619: fnd_msg_pub.add;
8620: end if;
8621:

Line 8618: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);

8614: 'PSP_SET_SPONSORS_FOR_CAPPING', l_sponsor_code);
8615: if l_sponsor_id is null then
8616: l_error_flag := 'Y';
8617: fnd_message.set_name('PSP', 'PSP_MAP_SAL_CAP_SPONSOR');
8618: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8619: fnd_msg_pub.add;
8620: end if;
8621:
8622: open check_salary_cap_exists(l_sponsor_code, l_begin_dist_date);

Line 8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');

8622: open check_salary_cap_exists(l_sponsor_code, l_begin_dist_date);
8623: fetch check_salary_cap_exists into l_count;
8624: if check_salary_cap_exists%notfound then
8625: l_error_flag := 'Y';
8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);

Line 8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);

8623: fetch check_salary_cap_exists into l_count;
8624: if check_salary_cap_exists%notfound then
8625: l_error_flag := 'Y';
8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);
8631: fnd_msg_pub.add;

Line 8628: fnd_message.set_token('XDATE', l_begin_dist_date);

8624: if check_salary_cap_exists%notfound then
8625: l_error_flag := 'Y';
8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);
8631: fnd_msg_pub.add;
8632: close check_salary_cap_exists;

Line 8629: fnd_message.set_token('BDATE', l_begin_dist_date);

8625: l_error_flag := 'Y';
8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);
8631: fnd_msg_pub.add;
8632: close check_salary_cap_exists;
8633: else

Line 8630: fnd_message.set_token('EDATE', l_end_dist_date);

8626: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);
8631: fnd_msg_pub.add;
8632: close check_salary_cap_exists;
8633: else
8634: close check_salary_cap_exists;

Line 8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');

8635: open check_salary_cap_exists(l_sponsor_code, l_end_dist_date);
8636: fetch check_salary_cap_exists into l_count;
8637: if check_salary_cap_exists%notfound then
8638: l_error_flag := 'Y';
8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);

Line 8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);

8636: fetch check_salary_cap_exists into l_count;
8637: if check_salary_cap_exists%notfound then
8638: l_error_flag := 'Y';
8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);
8644: fnd_msg_pub.add;

Line 8641: fnd_message.set_token('XDATE', l_end_dist_date);

8637: if check_salary_cap_exists%notfound then
8638: l_error_flag := 'Y';
8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);
8644: fnd_msg_pub.add;
8645: end if;

Line 8642: fnd_message.set_token('BDATE', l_begin_dist_date);

8638: l_error_flag := 'Y';
8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);
8644: fnd_msg_pub.add;
8645: end if;
8646: close check_salary_cap_exists;

Line 8643: fnd_message.set_token('EDATE', l_end_dist_date);

8639: fnd_message.set_name('PSP', 'PSP_NO_SALARY_CAP_DATA');
8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);
8644: fnd_msg_pub.add;
8645: end if;
8646: close check_salary_cap_exists;
8647: end if;