APPS.IGR_IMP_001 dependencies on IGS_AD_EXCURR_INT

Line 191: l_sub_interest_type_code igs_ad_excurr_int.sub_interest_type_code%TYPE;

187: lookup_code = cp_interest_type_code AND
188: lookup_type in ( 'ENTERTAINMENT', 'INTEREST_TYPE') AND
189: enabled_flag = 'Y';
190:
191: l_sub_interest_type_code igs_ad_excurr_int.sub_interest_type_code%TYPE;
192:
193: CURSOR inq_per_test_cur(l_person_id igr_is_test.inq_person_id%TYPE) IS
194: SELECT
195: inq_test_id,

Line 1439: /* Validate the data in Self Service table for not null before inseting into igs_ad_excurr_int */

1435: END IF;
1436: END LOOP;
1437:
1438: FOR inq_per_extra_rec IN inq_per_extra_cur(inq_rec.inq_person_id) LOOP
1439: /* Validate the data in Self Service table for not null before inseting into igs_ad_excurr_int */
1440: validate_excurr_act_int(inq_per_extra_rec,l_status,l_tokenstr);
1441: IF l_status = 1 THEN
1442: -- nsinha bug 2733230
1443: l_sub_interest_type_code := NULL;

Line 1451: INSERT INTO igs_ad_excurr_int

1447: FETCH inq_sub_interest_type_cur INTO l_sub_interest_type_code;
1448: CLOSE inq_sub_interest_type_cur;
1449: END IF;
1450: BEGIN
1451: INSERT INTO igs_ad_excurr_int
1452: (
1453: sub_interest_type_code ,
1454: hours_per_week ,
1455: weeks_per_year ,

Line 1491: igs_ad_excurr_int_s.nextval ,

1487: null ,
1488: inq_per_extra_rec.interest_name,
1489: null ,
1490: inq_rec.org_id ,
1491: igs_ad_excurr_int_s.nextval ,
1492: l_interface_id ,
1493: null ,
1494: inq_per_extra_rec.start_date ,
1495: inq_per_extra_rec.end_date ,

Line 1518: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_EXCURR_INT failed '||SQLERRM);

1514: null
1515: );
1516: EXCEPTION WHEN OTHERS THEN
1517: l_status:=0;
1518: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_EXCURR_INT failed '||SQLERRM);
1519: RAISE;
1520: END;
1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

Line 1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');

1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);
1527: fnd_message.set_token('ID',inq_rec.inq_person_id);
1528: fnd_file.put_line(fnd_file.log,fnd_message.get);
1529: RAISE null_validation_fails;