DBA Data[Home] [Help]

APPS.PSP_PEE_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'EXTERNAL_EFFORT_LINE_ID')
67: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

Line 319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

315: IF NOT psp_pee_shd.api_updating
316: (p_external_effort_line_id => p_rec.external_effort_line_id
317: ,p_object_version_number => p_rec.object_version_number
318: ) THEN
319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
320: fnd_message.set_token('PROCEDURE ', l_proc);
321: fnd_message.set_token('STEP ', '5');
322: fnd_message.raise_error;
323: END IF;

Line 320: fnd_message.set_token('PROCEDURE ', l_proc);

316: (p_external_effort_line_id => p_rec.external_effort_line_id
317: ,p_object_version_number => p_rec.object_version_number
318: ) THEN
319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
320: fnd_message.set_token('PROCEDURE ', l_proc);
321: fnd_message.set_token('STEP ', '5');
322: fnd_message.raise_error;
323: END IF;
324: --

Line 321: fnd_message.set_token('STEP ', '5');

317: ,p_object_version_number => p_rec.object_version_number
318: ) THEN
319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
320: fnd_message.set_token('PROCEDURE ', l_proc);
321: fnd_message.set_token('STEP ', '5');
322: fnd_message.raise_error;
323: END IF;
324: --
325: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 322: fnd_message.raise_error;

318: ) THEN
319: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
320: fnd_message.set_token('PROCEDURE ', l_proc);
321: fnd_message.set_token('STEP ', '5');
322: fnd_message.raise_error;
323: END IF;
324: --
325: -- EDIT_HERE: Add checks to ensure non-updateable args have
326: -- not been updated.

Line 411: fnd_message.set_token('SET_OF_BOOKS_ID',l_set_of_books_id);

407: FETCH set_of_books_id_csr INTO l_set_of_books_id;
408: if set_of_books_id_csr%notfound then
409: CLOSE set_of_books_id_csr;
410: hr_utility.set_message(8403, 'PSP_ER_INVALID_SET_OF_BOOKS');
411: fnd_message.set_token('SET_OF_BOOKS_ID',l_set_of_books_id);
412: hr_utility.raise_error;
413: END IF;
414: CLOSE set_of_books_id_csr;
415: EXCEPTION

Line 470: fnd_message.set_token('PERSON_ID',l_person_id);

466: FETCH person_id_csr INTO l_person_id;
467: if person_id_csr%notfound then
468: CLOSE person_id_csr;
469: hr_utility.set_message(8403, 'PSP_ER_INVALID_PERSON');
470: fnd_message.set_token('PERSON_ID',l_person_id);
471: hr_utility.raise_error;
472: END IF;
473: CLOSE person_id_csr;
474: EXCEPTION

Line 542: fnd_message.set_token('ASSIGNMENT_ID',l_assignment_id);

538: FETCH assignment_id_csr INTO l_assignment_id;
539: if assignment_id_csr%notfound then
540: CLOSE assignment_id_csr;
541: hr_utility.set_message(8403, 'PSP_ER_INVALID_ASSIGNMENT');
542: fnd_message.set_token('ASSIGNMENT_ID',l_assignment_id);
543: hr_utility.raise_error;
544: END IF;
545: CLOSE assignment_id_csr;
546: EXCEPTION

Line 598: fnd_message.set_token('CURRENCY_CODE',l_currency_code);

594: FETCH currency_csr INTO l_currency_code;
595: if currency_csr%notfound then
596: CLOSE currency_csr;
597: hr_utility.set_message(8403, 'PSP_ER_INVALID_CURRENCY');
598: fnd_message.set_token('CURRENCY_CODE',l_currency_code);
599: hr_utility.raise_error;
600: END IF;
601: CLOSE currency_csr;
602: EXCEPTION

Line 676: fnd_message.set_token('GL_CODE_COMBINATION_ID',l_gl_code_combination_id);

672: FETCH gl_code_combination_csr INTO l_gl_code_combination_id;
673: IF gl_code_combination_csr%notfound then
674: CLOSE gl_code_combination_csr;
675: hr_utility.set_message(8403, 'PSP_ER_INVALID_GLCC');
676: fnd_message.set_token('GL_CODE_COMBINATION_ID',l_gl_code_combination_id);
677: hr_utility.raise_error;
678: END IF;
679: CLOSE gl_code_combination_csr;
680: EXCEPTION

Line 727: fnd_message.set_token('PROJECT_ID',l_project_id);

723: FETCH project_id_csr INTO l_project_id;
724: if project_id_csr%notfound then
725: CLOSE project_id_csr;
726: hr_utility.set_message(8403, 'PSP_ER_INVALID_PROJECT_ID');
727: fnd_message.set_token('PROJECT_ID',l_project_id);
728: hr_utility.raise_error;
729: END IF;
730: CLOSE project_id_csr;
731: EXCEPTION

Line 777: fnd_message.set_token('TASK_ID',l_task_id);

773: FETCH task_id_csr INTO l_task_id;
774: if task_id_csr%notfound then
775: CLOSE task_id_csr;
776: hr_utility.set_message(8403, 'PSP_ER_INVALID_TASK_ID');
777: fnd_message.set_token('TASK_ID',l_task_id);
778: hr_utility.raise_error;
779: END IF;
780: CLOSE task_id_csr;
781: EXCEPTION

Line 827: fnd_message.set_token('AWARD_ID',l_award_id);

823: FETCH award_id_csr INTO l_award_id;
824: if award_id_csr%notfound then
825: CLOSE award_id_csr;
826: hr_utility.set_message(8403, 'PSP_ER_INVALID_AWARD_ID');
827: fnd_message.set_token('AWARD_ID',l_award_id);
828: hr_utility.raise_error;
829: END IF;
830: CLOSE award_id_csr;
831: EXCEPTION

Line 878: fnd_message.set_token('EXP_ORG_ID',l_expenditure_organization_id);

874: FETCH expenditure_organization_csr INTO l_expenditure_organization_id;
875: if expenditure_organization_csr%notfound then
876: CLOSE expenditure_organization_csr;
877: hr_utility.set_message(8403, 'PSP_ER_INVALID_EXP_ORG_ID');
878: fnd_message.set_token('EXP_ORG_ID',l_expenditure_organization_id);
879: hr_utility.raise_error;
880: END IF;
881: CLOSE expenditure_organization_csr;
882: EXCEPTION

Line 947: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');

943: END IF;
944: END IF;
945: EXCEPTION
946: WHEN person_effort_report_exist THEN
947: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
948: fnd_message.set_token('PERSON_ID',p_person_id);
949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN

Line 948: fnd_message.set_token('PERSON_ID',p_person_id);

944: END IF;
945: EXCEPTION
946: WHEN person_effort_report_exist THEN
947: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
948: fnd_message.set_token('PERSON_ID',p_person_id);
949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');

Line 949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);

945: EXCEPTION
946: WHEN person_effort_report_exist THEN
947: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
948: fnd_message.set_token('PERSON_ID',p_person_id);
949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);

Line 950: fnd_message.raise_error;

946: WHEN person_effort_report_exist THEN
947: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
948: fnd_message.set_token('PERSON_ID',p_person_id);
949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);

Line 952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');

948: fnd_message.set_token('PERSON_ID',p_person_id);
949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);
955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
956: fnd_message.raise_error;

Line 953: fnd_message.set_token('PERSON_ID',p_person_id);

949: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);
955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
956: fnd_message.raise_error;
957: END chk_existing_eff_report;

Line 954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);

950: fnd_message.raise_error;
951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);
955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
956: fnd_message.raise_error;
957: END chk_existing_eff_report;
958:

Line 955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);

951: WHEN assignment_effort_report_exist THEN
952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);
955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
956: fnd_message.raise_error;
957: END chk_existing_eff_report;
958:
959: --

Line 956: fnd_message.raise_error;

952: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
953: fnd_message.set_token('PERSON_ID',p_person_id);
954: fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id);
955: fnd_message.set_token('DISTRIBUTION_DATE',p_distribution_date);
956: fnd_message.raise_error;
957: END chk_existing_eff_report;
958:
959: --
960: -- ----------------------------------------------------------------------------

Line 1219: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');

1215:
1216: EXCEPTION
1217: /*
1218: WHEN person_effort_report_exist THEN
1219: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN

Line 1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);

1216: EXCEPTION
1217: /*
1218: WHEN person_effort_report_exist THEN
1219: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');

Line 1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);

1217: /*
1218: WHEN person_effort_report_exist THEN
1219: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);

Line 1222: fnd_message.raise_error;

1218: WHEN person_effort_report_exist THEN
1219: fnd_message.set_name('PSP', 'PSP_ER_PERSON_EFF_REPORT_EXIST');
1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);

Line 1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');

1220: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);
1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;

Line 1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);

1221: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);
1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;
1229: */

Line 1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);

1222: fnd_message.raise_error;
1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);
1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;
1229: */
1230: WHEN invalid_business_group THEN

Line 1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);

1223: WHEN assignment_effort_report_exist THEN
1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);
1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;
1229: */
1230: WHEN invalid_business_group THEN
1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');

Line 1228: fnd_message.raise_error;

1224: fnd_message.set_name('PSP', 'PSP_ER_ASSGN_EFF_REPORT_EXIST');
1225: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1226: fnd_message.set_token('ASSIGNMENt_ID',p_rec.assignment_id);
1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;
1229: */
1230: WHEN invalid_business_group THEN
1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');
1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);

Line 1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');

1227: fnd_message.set_token('DISTRIBUTION_DATE',p_rec.distribution_date);
1228: fnd_message.raise_error;
1229: */
1230: WHEN invalid_business_group THEN
1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');
1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);
1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');

Line 1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);

1228: fnd_message.raise_error;
1229: */
1230: WHEN invalid_business_group THEN
1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');
1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);
1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);

Line 1233: fnd_message.raise_error;

1229: */
1230: WHEN invalid_business_group THEN
1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');
1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);
1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;

Line 1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');

1231: fnd_message.set_name('PSP', 'PSP_ER_INVALID_BUSINESS_GROUP');
1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);
1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');

Line 1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);

1232: fnd_message.set_token('BUSINESS_GROUP_ID',p_rec.business_group_id);
1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);

Line 1237: fnd_message.raise_error;

1233: fnd_message.raise_error;
1234: WHEN invalid_set_of_books THEN
1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;

Line 1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');

1235: fnd_message.set_name('PSP', 'PSP_ER_INVALID_SET_OF_BOOKS');
1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');

Line 1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);

1236: fnd_message.set_token('SET_OF_BOOKS_ID',p_rec.set_of_books_id);
1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);

Line 1241: fnd_message.raise_error;

1237: fnd_message.raise_error;
1238: WHEN invalid_person THEN
1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;

Line 1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');

1239: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PERSON');
1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');

Line 1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);

1240: fnd_message.set_token('PERSON_ID',p_rec.person_id);
1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);

Line 1245: fnd_message.raise_error;

1241: fnd_message.raise_error;
1242: WHEN invalid_assignment THEN
1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;

Line 1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');

1243: fnd_message.set_name('PSP', 'PSP_ER_INVALID_ASSIGNMENT');
1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');

Line 1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);

1244: fnd_message.set_token('ASSIGNMENT_ID',p_rec.assignment_id);
1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);

Line 1249: fnd_message.raise_error;

1245: fnd_message.raise_error;
1246: WHEN invalid_currency THEN
1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;

Line 1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');

1247: fnd_message.set_name('PSP', 'PSP_ER_INVALID_CURRENCY');
1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');

Line 1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);

1248: fnd_message.set_token('CURRENCY_CODE',p_rec.currency_code);
1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);

Line 1253: fnd_message.raise_error;

1249: fnd_message.raise_error;
1250: WHEN invalid_project THEN
1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;

Line 1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');

1251: fnd_message.set_name('PSP', 'PSP_ER_INVALID_PROJECT');
1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');

Line 1256: fnd_message.set_token('TASK_ID',p_rec.task_id);

1252: fnd_message.set_token('PROJECT_ID',p_rec.project_id);
1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);

Line 1257: fnd_message.raise_error;

1253: fnd_message.raise_error;
1254: WHEN invalid_task THEN
1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;

Line 1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');

1255: fnd_message.set_name('PSP', 'PSP_ER_INVALID_TASK');
1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');

Line 1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);

1256: fnd_message.set_token('TASK_ID',p_rec.task_id);
1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);

Line 1261: fnd_message.raise_error;

1257: fnd_message.raise_error;
1258: WHEN invalid_award THEN
1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;

Line 1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');

1259: fnd_message.set_name('PSP', 'PSP_ER_INVALID_AWARD');
1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');

Line 1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);

1260: fnd_message.set_token('AWARD_ID',p_rec.award_id);
1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);

Line 1265: fnd_message.raise_error;

1261: fnd_message.raise_error;
1262: WHEN invalid_exp_org THEN
1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;

Line 1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');

1263: fnd_message.set_name('PSP', 'PSP_ER_INVALID_EXP_ORG');
1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;
1270: WHEN no_charging_instruction THEN
1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');

Line 1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);

1264: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;
1270: WHEN no_charging_instruction THEN
1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');
1272: fnd_message.raise_error;

Line 1269: fnd_message.raise_error;

1265: fnd_message.raise_error;
1266: WHEN extra_charging_instruction THEN
1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;
1270: WHEN no_charging_instruction THEN
1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');
1272: fnd_message.raise_error;
1273: END chk_record_validity;

Line 1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');

1267: fnd_message.set_name('PSP', 'PSP_ER_EXTRA_CI');
1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;
1270: WHEN no_charging_instruction THEN
1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');
1272: fnd_message.raise_error;
1273: END chk_record_validity;
1274:
1275:

Line 1272: fnd_message.raise_error;

1268: fnd_message.set_token('EXPENDITURE_ORGANIZATION_ID',p_rec.expenditure_organization_id);
1269: fnd_message.raise_error;
1270: WHEN no_charging_instruction THEN
1271: fnd_message.set_name('PSP', 'PSP_POETA_GL');
1272: fnd_message.raise_error;
1273: END chk_record_validity;
1274:
1275:
1276: