APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_LOOKUPS_VIEW_PKG

Line 1501: ckasu 27-NOV-2005 Added logic inorder toby pass validation IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION

1497: PROCEDURE Check_Parent_Existance AS
1498: BEGIN
1499:
1500: /* WHO WHEN WHAT
1501: ckasu 27-NOV-2005 Added logic inorder toby pass validation IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION
1502: when IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN' since Plaaning Sheet Records
1503: are created in 'PLANNED' Status which is not a looup value as a part of bug#4666102
1504:
1505: */

Line 1596: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION('UNIT_ATTEMPT_STATUS',

1592: IF (((old_references.unit_attempt_status = new_references.unit_attempt_status)) OR
1593: ((new_references.unit_attempt_status IS NULL)) OR (IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop IS NOT NULL
1594: AND IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop = 'PLAN') ) THEN
1595: NULL;
1596: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION('UNIT_ATTEMPT_STATUS',
1597: new_references.unit_attempt_status) THEN
1598: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
1599: IGS_GE_MSG_STACK.ADD;
1600: APP_EXCEPTION.RAISE_EXCEPTION;