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 649: FND_MESSAGE.SET_NAME('PSP','PSP_INVALID_PERIOD');

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

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

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

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

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

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

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

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

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

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

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

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

1038: WHERE person_id = l_person_id
1039: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1040: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1041: l_table := 'HR_ORGANIZATION_UNITS';
1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1039: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1040: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1041: l_table := 'HR_ORGANIZATION_UNITS';
1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);
1047: fnd_msg_pub.add;

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

1040: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1041: l_table := 'HR_ORGANIZATION_UNITS';
1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);
1047: fnd_msg_pub.add;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1041: l_table := 'HR_ORGANIZATION_UNITS';
1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);
1047: fnd_msg_pub.add;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;

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

1042: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1043: fnd_message.set_token('VALUE', l_value);
1044: fnd_message.set_token('TABLE', l_table);
1045: fnd_message.set_token('BATCH_NAME', NULL);
1046: fnd_message.set_token('PERSON_NAME', l_employee_name);
1047: fnd_msg_pub.add;
1048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1049: END IF;
1050: CLOSE exp_org_cur;

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

1058: WHERE person_id = l_person_id
1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);
1067: fnd_msg_pub.add;

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

1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);
1067: fnd_msg_pub.add;
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1061: l_table := 'PA_PROJECTS_ALL';
1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);
1067: fnd_msg_pub.add;
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: END IF;

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

1062: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1063: fnd_message.set_token('VALUE',l_value);
1064: fnd_message.set_token('TABLE',l_table);
1065: fnd_message.set_token('BATCH_NAME', NULL);
1066: fnd_message.set_token('PERSON_NAME', l_employee_name);
1067: fnd_msg_pub.add;
1068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1069: END IF;
1070: CLOSE project_id_cur;

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

1078: WHERE person_id = l_person_id
1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);
1087: fnd_msg_pub.add;

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

1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);
1087: fnd_msg_pub.add;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1081: l_table := 'PA_PROJECTS_ALL';
1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);
1087: fnd_msg_pub.add;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;

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

1082: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
1083: fnd_message.set_token('VALUE',l_value);
1084: fnd_message.set_token('TABLE',l_table);
1085: fnd_message.set_token('BATCH_NAME', NULL);
1086: fnd_message.set_token('PERSON_NAME', l_employee_name);
1087: fnd_msg_pub.add;
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: CLOSE org_id_cur;

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

1098: WHERE person_id = l_person_id
1099: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1100: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1101: l_table := 'PA_TASKS';
1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1099: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1100: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1101: l_table := 'PA_TASKS';
1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);
1107: fnd_msg_pub.add;

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

1100: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1101: l_table := 'PA_TASKS';
1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);
1107: fnd_msg_pub.add;
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1101: l_table := 'PA_TASKS';
1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);
1107: fnd_msg_pub.add;
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: END IF;

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

1102: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1103: fnd_message.set_token('VALUE',l_value);
1104: fnd_message.set_token('TABLE',l_table);
1105: fnd_message.set_token('BATCH_NAME', NULL);
1106: fnd_message.set_token('PERSON_NAME', l_employee_name);
1107: fnd_msg_pub.add;
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: END IF;
1110: CLOSE task_id_cur;

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

1119: WHERE person_id = l_person_id
1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);
1128: fnd_msg_pub.add;

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

1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);
1128: fnd_msg_pub.add;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);
1128: fnd_msg_pub.add;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;

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

1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);
1127: fnd_message.set_token('PERSON_NAME', l_employee_name);
1128: fnd_msg_pub.add;
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;
1131: CLOSE award_id_cur;

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

1140: WHERE person_id = l_person_id
1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);

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

1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);
1149: fnd_msg_pub.add;

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

1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;

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

1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);
1148: fnd_message.set_token('PERSON_NAME', l_employee_name);
1149: fnd_msg_pub.add;
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152: CLOSE expenditure_type_cur;

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

1394: X_GL_CCID => l_gl_ccid);
1395:
1396: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1397: l_error_api_name := 'GET_GL_CCID : ';
1398: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then

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

1395:
1396: IF l_gl_ccid = 0 or l_gl_ccid IS NULL then
1397: l_error_api_name := 'GET_GL_CCID : ';
1398: fnd_message.set_name('PSP','PSP_NO_GL_FOR_COSTING');
1399: fnd_message.set_token('COST_ID', g_pay_costs_rec.cost_allocation_keyflex_id);
1400: fnd_msg_pub.add;
1401: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);

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

1402: ELSIF l_gl_ccid <> l_clearing_account then
1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);

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

1403: l_gl_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_gl_ccid);
1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

1404: l_clearing_account_value := psp_general.get_gl_values(l_resp_set_of_books_id, l_clearing_account);
1405: l_error_api_name := 'GET_GL_CCID : ';
1406: fnd_message.set_name('PSP','PSP_CLEARING_ACCT_MISMATCH');
1407: fnd_message.set_token('GL_ACCOUNT', l_gl_value);
1408: fnd_message.set_token('CLEARING', l_clearing_account_value);
1409: fnd_msg_pub.add;
1410: hr_utility.trace(' fail kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1411: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;

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

1444: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1445:
1446: hr_utility.trace('Am i successful');
1447:
1448: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1449: FND_MESSAGE.set_token('Employee',l_employee_name);
1450: FND_MSG_PUB.ADD;
1451: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1452: END IF;

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

1445:
1446: hr_utility.trace('Am i successful');
1447:
1448: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1449: FND_MESSAGE.set_token('Employee',l_employee_name);
1450: FND_MSG_PUB.ADD;
1451: g_non_active_flag := 'E'; --ERROR, skip this assg, bcos not a single day it is active
1452: END IF;
1453: END IF;

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

1883: */
1884:
1885: hr_utility.trace('-inside exception 10-');
1886:
1887: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1888: FND_MESSAGE.set_token('Employee',l_employee_name);
1889: FND_MSG_PUB.ADD;
1890:
1891: retcode:= FND_API.G_RET_STS_SUCCESS;

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

1884:
1885: hr_utility.trace('-inside exception 10-');
1886:
1887: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_COSTING_EMP');
1888: FND_MESSAGE.set_token('Employee',l_employee_name);
1889: FND_MSG_PUB.ADD;
1890:
1891: retcode:= FND_API.G_RET_STS_SUCCESS;
1892:

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

1951: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1952: END IF;
1953:
1954: IF l_total_num_rec=0 then
1955: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
1956: fnd_msg_pub.add;
1957:
1958: ELSE
1959:

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

1974: /* added by subha to always print the success message when the program terminates successfully */
1975:
1976: fnd_file.put_line(fnd_file.log,'********************************************************');
1977:
1978: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
1979: fnd_msg_pub.add;
1980: retcode:= FND_API.G_RET_STS_SUCCESS;
1981:
1982: COMMIT;

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

2045:
2046: EXCEPTION
2047: WHEN NO_DATA_FOUND then
2048: close get_payroll_assig_actions_csr;
2049: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
2050: fnd_msg_pub.add;
2051: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
2052: fnd_msg_pub.add;
2053: retcode:= FND_API.G_RET_STS_SUCCESS;

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

2047: WHEN NO_DATA_FOUND then
2048: close get_payroll_assig_actions_csr;
2049: fnd_message.set_name('PSP','PSP_PI_NO_PAYROLL_TRXN');
2050: fnd_msg_pub.add;
2051: fnd_message.set_name('PSP','PSP_PROGRAM_SUCCESS') ;
2052: fnd_msg_pub.add;
2053: retcode:= FND_API.G_RET_STS_SUCCESS;
2054:
2055:

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

2068:
2069: return;
2070: /* Added Exceptions for bug 2056877 */
2071: WHEN NO_PROFILE_EXISTS THEN
2072: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2073: fnd_msg_pub.add;
2074: psp_message_s.print_error(p_mode=>FND_FILE.log,
2075: p_print_header=>FND_API.G_TRUE);
2076: retcode := 2;

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

2076: retcode := 2;
2077:
2078:
2079: WHEN NO_VAL_DATE_MATCHES THEN
2080: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2081: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2082: fnd_msg_pub.add;
2083: psp_message_s.print_error(p_mode=>FND_FILE.log,
2084: p_print_header=>FND_API.G_TRUE);

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

2077:
2078:
2079: WHEN NO_VAL_DATE_MATCHES THEN
2080: fnd_message.set_name('PSP','PSP_IMP_NO_VAL_DATE_MATCHES');
2081: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2082: fnd_msg_pub.add;
2083: psp_message_s.print_error(p_mode=>FND_FILE.log,
2084: p_print_header=>FND_API.G_TRUE);
2085: retcode := 2;

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

2088: -- commented the below line and replaced it with the next line, fix done is fixing the gscc warning on not to use chr(x)
2089: -- instead use fnd_global.local_chr(x)
2090: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2091: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2092: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2093: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2094: fnd_msg_pub.add;
2095: psp_message_s.print_error(p_mode=>FND_FILE.log,
2096: p_print_header=>FND_API.G_TRUE);

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

2089: -- instead use fnd_global.local_chr(x)
2090: --errbuf := l_error_api_name || chr(10) || l_msg_data || chr(10);
2091: errbuf := l_error_api_name || fnd_global.local_chr(10) || l_msg_data || fnd_global.local_chr(10);
2092: fnd_message.set_name('PSP','PSP_IMP_NO_GLOBAL_ACCT_EXISTS');
2093: fnd_message.set_token('PAYROLL_DATE',l_end_date);
2094: fnd_msg_pub.add;
2095: psp_message_s.print_error(p_mode=>FND_FILE.log,
2096: p_print_header=>FND_API.G_TRUE);
2097: retcode := 2; --End of Modification for Bug 2056877.

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

2571: --dbms_output.PUT_LINE(' open get_proposal_csr; ' );
2572: fetch get_no_per_fiscal_year_csr into l_no_fiscal_year;
2573: --dbms_output.PUT_LINE(' Just entered... ' );
2574: if get_no_per_fiscal_year_csr%NOTFOUND then
2575: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2576: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2577: FND_MSG_PUB.Add;
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: end if;

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

2572: fetch get_no_per_fiscal_year_csr into l_no_fiscal_year;
2573: --dbms_output.PUT_LINE(' Just entered... ' );
2574: if get_no_per_fiscal_year_csr%NOTFOUND then
2575: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_NO_PERIOD_TYPES');
2576: FND_MESSAGE.Set_Token('TIME_PERIOD_ID',x_time_period_id);
2577: FND_MSG_PUB.Add;
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: end if;
2580: close get_no_per_fiscal_year_csr;

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

3003: hr_utility.trace(' X_Payroll_line_id ...' || to_char(x_payroll_line_id));
3004: open get_payroll_line_csr;
3005: fetch get_payroll_line_csr into g_payroll_line_rec;
3006: if get_payroll_line_csr%NOTFOUND then
3007: fnd_message.set_name('PSP', 'PSP_NO_PAYROLL_LINES');
3008: fnd_msg_pub.add;
3009: close get_payroll_line_csr;
3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011: end if;

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

8873: ------dbms_output.put_line('Check_zero_work_days.....'||x_assignment_id||' '||x_costed_value);
8874: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8876: assignment_id=x_assignment_id);
8877: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8879: fnd_message.set_token('LINE_AMT',x_costed_value );
8880: fnd_msg_pub.add;
8881:

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

8874: select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8876: assignment_id=x_assignment_id);
8877: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8879: fnd_message.set_token('LINE_AMT',x_costed_value );
8880: fnd_msg_pub.add;
8881:
8882: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);

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

8875: and effective_start_date=(select max(effective_start_date) from per_assignments_f where
8876: assignment_id=x_assignment_id);
8877: fnd_message.set_name('PSP','PSP_ZERO_WORK_DAYS');
8878: fnd_message.set_token('ASSIGNMENT_NO',l_assignment_number);
8879: fnd_message.set_token('LINE_AMT',x_costed_value );
8880: fnd_msg_pub.add;
8881:
8882: -- fnd_msg_pub.add_exc_msg('PSP-PAYTRN','CHECK_ZERO_WORK_DAYS','Assg_ID '||x_assignment_id||' Amt '||x_costed_value);
8883: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;