APPS.IGS_AD_IMP_002 dependencies on FND_API

Line 111: IF (p_person_rec.felony_convicted_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)

107: l_error_code := 'E174';
108: RAISE validation_failed;
109: END IF;
110: END IF;
111: IF (p_person_rec.felony_convicted_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)
112: AND p_person_rec.felony_convicted_flag IS NOT NULL ) THEN
113: IF l_enable_log = 'Y' THEN
114: igs_ad_imp_001.logerrormessage(P_Person_Rec.Interface_Id,'E164','IGS_AD_INTERFACE_ALL');
115: END IF;

Line 122: IF P_Person_Rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN

118: END IF;
119:
120: IF p_person_rec.felony_convicted_flag IS NOT NULL THEN
121:
122: IF P_Person_Rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN
123: l_felony_validation := igs_pe_gen_004.validate_felony(p_person_id,NULL);
124: ELSE
125: l_felony_validation := igs_pe_gen_004.validate_felony(p_person_id,P_Person_Rec.felony_convicted_flag);
126: END IF;

Line 1448: IF p_person_rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN

1444: OPEN pe_hz_parties_cur(p_person_id);
1445: FETCH pe_hz_parties_cur INTO tlinfo2;
1446: CLOSE pe_hz_parties_cur;
1447:
1448: IF p_person_rec.felony_convicted_flag = FND_API.G_MISS_CHAR THEN
1449: l_felony_convicted_flag := NULL;
1450: ELSE
1451: l_felony_convicted_flag := NVL(p_person_rec.felony_convicted_flag,tlinfo2.felony_convicted_flag);
1452: END IF;