[Home] [Help]
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: );
68: --
371: END IF;
372: CLOSE business_group_csr;
373: EXCEPTION
374: WHEN app_exception.application_exception THEN
375: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.BUSINESS_GROUP_ID') THEN
376: RAISE;
377: END IF;
378: END chk_business_group_id;
379:
413: END IF;
414: CLOSE set_of_books_id_csr;
415: EXCEPTION
416: WHEN app_exception.application_exception THEN
417: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.SET_OF_BOOKS_ID') THEN
418: RAISE;
419: END IF;
420: END chk_set_of_books_id;
421:
472: END IF;
473: CLOSE person_id_csr;
474: EXCEPTION
475: WHEN app_exception.application_exception THEN
476: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.PERSON_ID') THEN
477: RAISE;
478: END IF;
479: END chk_person_id;
480:
544: END IF;
545: CLOSE assignment_id_csr;
546: EXCEPTION
547: WHEN app_exception.application_exception THEN
548: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.ASSIGNMENT_ID') THEN
549: RAISE;
550: END IF;
551: END chk_assignment_id;
552:
600: END IF;
601: CLOSE currency_csr;
602: EXCEPTION
603: WHEN app_exception.application_exception THEN
604: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.CURRENCY_CODE') THEN
605: RAISE;
606: END IF;
607: END chk_currency;
608:
633: hr_utility.raise_error;
634: END IF;
635: EXCEPTION
636: WHEN app_exception.application_exception THEN
637: IF hr_multi_message.exception_add() THEN
638: RAISE;
639: END IF;
640: END chk_ptaoe_gl_combination;
641:
678: END IF;
679: CLOSE gl_code_combination_csr;
680: EXCEPTION
681: WHEN app_exception.application_exception THEN
682: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.GL_CODE_COMBINATION') THEN
683: RAISE;
684: END IF;
685: END chk_gl_code_combination;
686:
729: END IF;
730: CLOSE project_id_csr;
731: EXCEPTION
732: WHEN app_exception.application_exception THEN
733: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.PROJECT_ID') THEN
734: RAISE;
735: END IF;
736: END chk_project_id;
737:
779: END IF;
780: CLOSE task_id_csr;
781: EXCEPTION
782: WHEN app_exception.application_exception THEN
783: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.TASK_ID') THEN
784: RAISE;
785: END IF;
786: END chk_task_id;
787:
829: END IF;
830: CLOSE award_id_csr;
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.AWARD_ID') THEN
834: RAISE;
835: END IF;
836: END chk_award_id;
837:
880: END IF;
881: CLOSE expenditure_organization_csr;
882: EXCEPTION
883: WHEN app_exception.application_exception THEN
884: IF hr_multi_message.exception_add(p_associated_column1 => 'PSP_EFFORT_INTERFACE.expenditure_organization_id') THEN
885: RAISE;
886: END IF;
887: END chk_exp_org_id;
888:
1299: -- After validating the set of important attributes,
1300: -- if Multiple Message detection is enabled and at least
1301: -- one error has been found then abort further validation.
1302: --
1303: hr_multi_message.end_validation_set;
1304: --
1305: -- Validate Dependent Attributes
1306: --
1307: --
1389: -- After validating the set of important attributes,
1390: -- if Multiple Message detection is enabled and at least
1391: -- one error has been found then abort further validation.
1392: --
1393: hr_multi_message.end_validation_set;
1394: --
1395: -- Validate Dependent Attributes
1396: --
1397: --