DBA Data[Home] [Help]

APPS.IGS_FI_CREDITS_PKG dependencies on IGS_LOOKUPS_VIEW_PKG

Line 330: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(

326:
327: IF (((old_references.status = new_references.status)) OR
328: ((new_references.status IS NULL))) THEN
329: NULL;
330: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
331: 'IGS_FI_CREDIT_STATUS',
332: new_references.status
333: )THEN
334: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 358: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(

354:
355: IF (((old_references.credit_instrument = new_references.credit_instrument)) OR
356: ((new_references.credit_instrument IS NULL))) THEN
357: NULL;
358: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
359: 'IGS_FI_CREDIT_INSTRUMENT',
360: new_references.credit_instrument
361: )THEN
362: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 370: ELSIF NOT ( IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_REVERSAL_REASON',new_references.reversal_reason_code)

366: --Added the IGS_FI_WAV_REVERSAL_REASON lookup code validation as a part of Tution Waiver Build.
367: IF (((old_references.reversal_reason_code = new_references.reversal_reason_code)) OR
368: ((new_references.reversal_reason_code IS NULL))) THEN
369: NULL;
370: ELSIF NOT ( IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_REVERSAL_REASON',new_references.reversal_reason_code)
371: OR IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_WAV_REVERSAL_REASON',new_references.reversal_reason_code)
372: )THEN
373: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
374: IGS_GE_MSG_STACK.ADD;

Line 371: OR IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_WAV_REVERSAL_REASON',new_references.reversal_reason_code)

367: IF (((old_references.reversal_reason_code = new_references.reversal_reason_code)) OR
368: ((new_references.reversal_reason_code IS NULL))) THEN
369: NULL;
370: ELSIF NOT ( IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_REVERSAL_REASON',new_references.reversal_reason_code)
371: OR IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_WAV_REVERSAL_REASON',new_references.reversal_reason_code)
372: )THEN
373: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;

Line 428: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(

424: -- Following check of foreign key has been added as part of Deposits Build, Bug# 2584741
425: IF (((old_references.source_transaction_type = new_references.source_transaction_type)) OR
426: ((new_references.source_transaction_type IS NULL))) THEN
427: NULL;
428: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
429: 'IGS_FI_SOURCE_TRANSACTION_REF',
430: new_references.source_transaction_type
431: )THEN
432: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');