APPS.PSP_PEE_BUS dependencies on APP_EXCEPTION

Line 374: WHEN app_exception.application_exception THEN

370: hr_utility.raise_error;
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;

Line 416: WHEN app_exception.application_exception THEN

412: hr_utility.raise_error;
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;

Line 475: WHEN app_exception.application_exception THEN

471: hr_utility.raise_error;
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;

Line 547: WHEN app_exception.application_exception THEN

543: hr_utility.raise_error;
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;

Line 603: WHEN app_exception.application_exception THEN

599: hr_utility.raise_error;
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;

Line 636: WHEN app_exception.application_exception THEN

632: hr_utility.set_message(8403, 'PSP_ER_EXTRA_CI');
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;

Line 681: WHEN app_exception.application_exception THEN

677: hr_utility.raise_error;
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;

Line 732: WHEN app_exception.application_exception THEN

728: hr_utility.raise_error;
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;

Line 782: WHEN app_exception.application_exception THEN

778: hr_utility.raise_error;
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;

Line 832: WHEN app_exception.application_exception THEN

828: hr_utility.raise_error;
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;

Line 883: WHEN app_exception.application_exception THEN

879: hr_utility.raise_error;
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;