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: );
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: --
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
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;
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: --
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
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.
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
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
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
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
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
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
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
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
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
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
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');
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);
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);
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;
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;
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:
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: --
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: -- ----------------------------------------------------------------------------
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
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');
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);
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);
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;
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: */
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
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');
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);
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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);
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;
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');
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;
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;
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:
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: