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_PAYTRN dependencies on FND_MESSAGE

Line 647: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_PERIOD');

643:
644: fetch get_payroll_id_csr into l_start_date, l_end_date, l_payroll_id;
645:
646: if get_payroll_id_csr%NOTFOUND then
647: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_PERIOD');
648: fnd_msg_pub.add;
649: close get_payroll_id_csr;
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: end if;

Line 666: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_NO_OF_BOOKS');

662: fetch get_set_of_books_csr into l_resp_set_of_books_id ,l_resp_business_group_id;
663: EXIT WHEN get_set_of_books_csr%NOTFOUND ;
664: l_record_count := l_record_count + 1;
665: if l_record_count > 1 then
666: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_NO_OF_BOOKS');
667: fnd_msg_pub.add;
668: close get_set_of_books_csr;
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: end if;

Line 677: FND_MESSAGE.SET_NAME('PSP','PSP_NO_SET_OF_BOOKS');

673:
674: open get_set_of_books_csr ;
675: fetch get_set_of_books_csr into l_resp_set_of_books_id ,l_resp_business_group_id;
676: if get_set_of_books_csr%NOTFOUND then
677: FND_MESSAGE.SET_NAME('PSP','PSP_NO_SET_OF_BOOKS');
678: fnd_msg_pub.add;
679: close get_set_of_books_csr;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: elsif NVL(l_resp_set_of_books_id, 0) = 0 then

Line 682: FND_MESSAGE.SET_NAME('PSP','PSP_PI_NO_SOB_FOR_PAYROLL');

678: fnd_msg_pub.add;
679: close get_set_of_books_csr;
680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
681: elsif NVL(l_resp_set_of_books_id, 0) = 0 then
682: FND_MESSAGE.SET_NAME('PSP','PSP_PI_NO_SOB_FOR_PAYROLL');
683: fnd_msg_pub.add;
684: close get_set_of_books_csr;
685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
686: end if;

Line 736: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');

732:
733: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_column_count ='||l_column_count );
734:
735: IF (l_column_count > 1) AND (l_column_count < 4) THEN
736: fnd_message.set_name('PSP', 'PSP_EE_INCOMPLETE_CI');
737: fnd_msg_pub.add;
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:

Line 767: FND_MESSAGE.SET_NAME('PSP','PSP_NO_CLEARING_ACCOUNT');

763:
764: open get_clearing_account_csr;
765: fetch get_clearing_account_csr into l_clearing_account;
766: if get_clearing_account_csr%NOTFOUND or l_clearing_account = 0 then
767: FND_MESSAGE.SET_NAME('PSP','PSP_NO_CLEARING_ACCOUNT');
768: fnd_msg_pub.add;
769: close get_clearing_account_csr;
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: end if;

Line 1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1005: WHERE person_id = l_person_id
1006: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1007: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1008: l_table := 'HR_ORGANIZATION_UNITS';
1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1010: fnd_message.set_token('VALUE', l_value);

1006: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1007: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1008: l_table := 'HR_ORGANIZATION_UNITS';
1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);
1014: fnd_msg_pub.add;

Line 1011: fnd_message.set_token('TABLE', l_table);

1007: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1008: l_table := 'HR_ORGANIZATION_UNITS';
1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);
1014: fnd_msg_pub.add;
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1012: fnd_message.set_token('BATCH_NAME', NULL);

1008: l_table := 'HR_ORGANIZATION_UNITS';
1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);
1014: fnd_msg_pub.add;
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END IF;

Line 1013: fnd_message.set_token('PERSON_NAME', l_employee_name);

1009: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1010: fnd_message.set_token('VALUE', l_value);
1011: fnd_message.set_token('TABLE', l_table);
1012: fnd_message.set_token('BATCH_NAME', NULL);
1013: fnd_message.set_token('PERSON_NAME', l_employee_name);
1014: fnd_msg_pub.add;
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END IF;
1017: CLOSE exp_org_cur;

Line 1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1025: WHERE person_id = l_person_id
1026: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1027: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1028: l_table := 'PA_PROJECTS_ALL';
1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1030: fnd_message.set_token('VALUE',l_value);

1026: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1027: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1028: l_table := 'PA_PROJECTS_ALL';
1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);
1034: fnd_msg_pub.add;

Line 1031: fnd_message.set_token('TABLE',l_table);

1027: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1028: l_table := 'PA_PROJECTS_ALL';
1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);
1034: fnd_msg_pub.add;
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1032: fnd_message.set_token('BATCH_NAME', NULL);

1028: l_table := 'PA_PROJECTS_ALL';
1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);
1034: fnd_msg_pub.add;
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;

Line 1033: fnd_message.set_token('PERSON_NAME', l_employee_name);

1029: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1030: fnd_message.set_token('VALUE',l_value);
1031: fnd_message.set_token('TABLE',l_table);
1032: fnd_message.set_token('BATCH_NAME', NULL);
1033: fnd_message.set_token('PERSON_NAME', l_employee_name);
1034: fnd_msg_pub.add;
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037: CLOSE project_id_cur;

Line 1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');

1045: WHERE person_id = l_person_id
1046: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1047: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1048: l_table := 'PA_PROJECTS_ALL';
1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1050: fnd_message.set_token('VALUE',l_value);

1046: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1047: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1048: l_table := 'PA_PROJECTS_ALL';
1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);
1054: fnd_msg_pub.add;

Line 1051: fnd_message.set_token('TABLE',l_table);

1047: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1048: l_table := 'PA_PROJECTS_ALL';
1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);
1054: fnd_msg_pub.add;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1052: fnd_message.set_token('BATCH_NAME', NULL);

1048: l_table := 'PA_PROJECTS_ALL';
1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);
1054: fnd_msg_pub.add;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;

Line 1053: fnd_message.set_token('PERSON_NAME', l_employee_name);

1049: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1050: fnd_message.set_token('VALUE',l_value);
1051: fnd_message.set_token('TABLE',l_table);
1052: fnd_message.set_token('BATCH_NAME', NULL);
1053: fnd_message.set_token('PERSON_NAME', l_employee_name);
1054: fnd_msg_pub.add;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057: CLOSE org_id_cur;

Line 1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1065: WHERE person_id = l_person_id
1066: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1067: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1068: l_table := 'PA_TASKS';
1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1070: fnd_message.set_token('VALUE',l_value);

1066: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1067: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1068: l_table := 'PA_TASKS';
1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);
1074: fnd_msg_pub.add;

Line 1071: fnd_message.set_token('TABLE',l_table);

1067: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1068: l_table := 'PA_TASKS';
1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);
1074: fnd_msg_pub.add;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1072: fnd_message.set_token('BATCH_NAME', NULL);

1068: l_table := 'PA_TASKS';
1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);
1074: fnd_msg_pub.add;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;

Line 1073: fnd_message.set_token('PERSON_NAME', l_employee_name);

1069: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1070: fnd_message.set_token('VALUE',l_value);
1071: fnd_message.set_token('TABLE',l_table);
1072: fnd_message.set_token('BATCH_NAME', NULL);
1073: fnd_message.set_token('PERSON_NAME', l_employee_name);
1074: fnd_msg_pub.add;
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077: CLOSE task_id_cur;

Line 1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1086: WHERE person_id = l_person_id
1087: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1088: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1089: l_table := 'GMS_AWARDS_ALL';
1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1091: fnd_message.set_token('VALUE',l_value);

1087: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1088: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1089: l_table := 'GMS_AWARDS_ALL';
1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);
1095: fnd_msg_pub.add;

Line 1092: fnd_message.set_token('TABLE',l_table);

1088: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1089: l_table := 'GMS_AWARDS_ALL';
1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);
1095: fnd_msg_pub.add;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1093: fnd_message.set_token('BATCH_NAME', NULL);

1089: l_table := 'GMS_AWARDS_ALL';
1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);
1095: fnd_msg_pub.add;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;

Line 1094: fnd_message.set_token('PERSON_NAME', l_employee_name);

1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);
1094: fnd_message.set_token('PERSON_NAME', l_employee_name);
1095: fnd_msg_pub.add;
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098: CLOSE award_id_cur;

Line 1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1107: WHERE person_id = l_person_id
1108: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1109: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1110: l_table := 'PA_EXPENDITURE_TYPES';
1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);

Line 1112: fnd_message.set_token('VALUE',l_value);

1108: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1109: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1110: l_table := 'PA_EXPENDITURE_TYPES';
1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);
1116: fnd_msg_pub.add;

Line 1113: fnd_message.set_token('TABLE',l_table);

1109: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1110: l_table := 'PA_EXPENDITURE_TYPES';
1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);
1116: fnd_msg_pub.add;
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1114: fnd_message.set_token('BATCH_NAME', NULL);

1110: l_table := 'PA_EXPENDITURE_TYPES';
1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);
1116: fnd_msg_pub.add;
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1118: END IF;

Line 1115: fnd_message.set_token('PERSON_NAME', l_employee_name);

1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);
1115: fnd_message.set_token('PERSON_NAME', l_employee_name);
1116: fnd_msg_pub.add;
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1118: END IF;
1119: CLOSE expenditure_type_cur;

Line 1359: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');

1355: X_GL_CCID => l_gl_ccid);
1356:
1357: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1358: l_error_api_name := 'GET_GL_CCID : ';
1359: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1360: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1361: fnd_msg_pub.add;
1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_gl_ccid <> l_clearing_account then

Line 1360: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);

1356:
1357: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1358: l_error_api_name := 'GET_GL_CCID : ';
1359: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1360: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1361: fnd_msg_pub.add;
1362: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_gl_ccid <> l_clearing_account then
1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);

Line 1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');

1363: ELSIF l_gl_ccid <> l_clearing_account then
1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

Line 1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);

1364: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1369: fnd_message.set_token('CLEARING', l_clearing_account_value);

1365: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1366: l_error_api_name := 'GET_GL_CCID : ';
1367: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1368: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1369: fnd_message.set_token('CLEARING', l_clearing_account_value);
1370: fnd_msg_pub.add;
1371: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;

Line 1392: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');

1388: into l_employee_name
1389: from per_people_f
1390: where person_id = l_person_id and
1391: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1392: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1393: FND_MESSAGE.set_token('Employee',l_employee_name);
1394: FND_MSG_PUB.ADD;
1395: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1396: END IF;

Line 1393: FND_MESSAGE.set_token('Employee',l_employee_name);

1389: from per_people_f
1390: where person_id = l_person_id and
1391: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1392: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1393: FND_MESSAGE.set_token('Employee',l_employee_name);
1394: FND_MSG_PUB.ADD;
1395: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1396: END IF;
1397: END IF;

Line 1815: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');

1811:
1812:
1813: sysdate between effective_start_date and effective_end_date;
1814: */
1815: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1816: FND_MESSAGE.set_token('Employee',l_employee_name);
1817: FND_MSG_PUB.ADD;
1818:
1819: retcode:= FND_API.G_RET_STS_SUCCESS;

Line 1816: FND_MESSAGE.set_token('Employee',l_employee_name);

1812:
1813: sysdate between effective_start_date and effective_end_date;
1814: */
1815: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1816: FND_MESSAGE.set_token('Employee',l_employee_name);
1817: FND_MSG_PUB.ADD;
1818:
1819: retcode:= FND_API.G_RET_STS_SUCCESS;
1820:

Line 1881: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');

1877: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1878: END IF;
1879:
1880: IF l_total_num_rec=0 then
1881: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1882: fnd_msg_pub.add;
1883:
1884: ELSE
1885:

Line 1904: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;

1900: /* added by subha to always print the success message when the program terminates successfully */
1901:
1902: fnd_file.put_line(fnd_file.log,'********************************************************');
1903:
1904: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1905: fnd_msg_pub.add;
1906: retcode:= FND_API.G_RET_STS_SUCCESS;
1907:
1908: COMMIT;

Line 1975: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');

1971:
1972: EXCEPTION
1973: WHEN NO_DATA_FOUND then
1974: close get_payroll_assig_actions_csr;
1975: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1976: fnd_msg_pub.add;
1977: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1978: fnd_msg_pub.add;
1979: retcode:= FND_API.G_RET_STS_SUCCESS;

Line 1977: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;

1973: WHEN NO_DATA_FOUND then
1974: close get_payroll_assig_actions_csr;
1975: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1976: fnd_msg_pub.add;
1977: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1978: fnd_msg_pub.add;
1979: retcode:= FND_API.G_RET_STS_SUCCESS;
1980:
1981:

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

1994:
1995: return;
1996: /* Added Exceptions for bug 2056877 */
1997: WHEN NO_PROFILE_EXISTS THEN
1998: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
1999: fnd_msg_pub.add;
2000: psp_message_s.print_error(p_mode=>FND_FILE.log,
2001: p_print_header=>FND_API.G_TRUE);
2002: retcode := 2;

Line 2006: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');

2002: retcode := 2;
2003:
2004:
2005: WHEN NO_VAL_DATE_MATCHES THEN
2006: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2007: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2008: fnd_msg_pub.add;
2009: psp_message_s.print_error(p_mode=>FND_FILE.log,
2010: p_print_header=>FND_API.G_TRUE);

Line 2007: fnd_message.set_token('PAYROLL_DATE',l_end_date);

2003:
2004:
2005: WHEN NO_VAL_DATE_MATCHES THEN
2006: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2007: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2008: fnd_msg_pub.add;
2009: psp_message_s.print_error(p_mode=>FND_FILE.log,
2010: p_print_header=>FND_API.G_TRUE);
2011: retcode := 2;

Line 2018: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');

2014: -- commented the below line and replaced it with the next line, fix done is fixing the gscc warning on not to use chr(x)
2015: -- instead use fnd_global.local_chr(x)
2016: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2017: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2018: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2019: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2020: fnd_msg_pub.add;
2021: psp_message_s.print_error(p_mode=>FND_FILE.log,
2022: p_print_header=>FND_API.G_TRUE);

Line 2019: fnd_message.set_token('PAYROLL_DATE',l_end_date);

2015: -- instead use fnd_global.local_chr(x)
2016: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2017: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2018: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2019: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2020: fnd_msg_pub.add;
2021: psp_message_s.print_error(p_mode=>FND_FILE.log,
2022: p_print_header=>FND_API.G_TRUE);
2023: retcode := 2; --End of Modification for Bug 2056877.

Line 2501: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');

2497: --dbms_output.PUT_LINE(' open get_proposal_csr; ' );
2498: fetch get_no_per_fiscal_year_csr into l_no_fiscal_year;
2499: --dbms_output.PUT_LINE(' Just entered... ' );
2500: if get_no_per_fiscal_year_csr%NOTFOUND then
2501: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2502: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2503: FND_MSG_PUB.Add;
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: end if;

Line 2502: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);

2498: fetch get_no_per_fiscal_year_csr into l_no_fiscal_year;
2499: --dbms_output.PUT_LINE(' Just entered... ' );
2500: if get_no_per_fiscal_year_csr%NOTFOUND then
2501: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2502: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2503: FND_MSG_PUB.Add;
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: end if;
2506: close get_no_per_fiscal_year_csr;

Line 2933: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');

2929: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
2930: open get_payroll_line_csr;
2931: fetch get_payroll_line_csr into g_payroll_line_rec;
2932: if get_payroll_line_csr%NOTFOUND then
2933: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
2934: fnd_msg_pub.add;
2935: close get_payroll_line_csr;
2936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2937: end if;

Line 8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');

8799: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8800: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8801: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8805: fnd_message.set_token('LINE_AMT',x_costed_value );
8806: fnd_msg_pub.add;
8807:

Line 8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);

8800: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8801: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8805: fnd_message.set_token('LINE_AMT',x_costed_value );
8806: fnd_msg_pub.add;
8807:
8808: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);

Line 8805: fnd_message.set_token('LINE_AMT',x_costed_value );

8801: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8802: assignment_id=x_assignment_id);
8803: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8804: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8805: fnd_message.set_token('LINE_AMT',x_costed_value );
8806: fnd_msg_pub.add;
8807:
8808: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);
8809: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;