APPS.IGR_IMP_001 dependencies on IGS_AD_INTERFACE_ALL

Line 38: into IGS_AD_INTERFACE_ALL,IGS_AD_STAT_INT,IGS_PE_CITIZEN_INT and

34: SELECT igs_ad_interface_s.nextval FROM dual;
35:
36: /* This Main Cursor retrieves all the Person and Inquiry Details,
37: with Status 'I' or 'U' which are then inserted
38: into IGS_AD_INTERFACE_ALL,IGS_AD_STAT_INT,IGS_PE_CITIZEN_INT and
39: IGS_AD_INQ_APPL_INT after all the validations are successfull
40: */
41:
42: CURSOR inq_per_cur IS

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

505: CLOSE interface_id_cur;
506:
507: SAVEPOINT inqsavepoint ;
508: completed_flag := 'Y'; /* this flag is set to 'N' when any of the validation fails */
509: /* Validate the data in Self Service table for not null before inseting into igs_ad_interface_all */
510: validate_interface(inq_rec, l_status,l_batch_id,l_interface_id,l_tokenstr);
511:
512: IF l_status = 1 THEN /* Validation Successful */
513: BEGIN

Line 514: INSERT INTO igs_ad_interface_all /* Insert valid record into this interface table */

510: validate_interface(inq_rec, l_status,l_batch_id,l_interface_id,l_tokenstr);
511:
512: IF l_status = 1 THEN /* Validation Successful */
513: BEGIN
514: INSERT INTO igs_ad_interface_all /* Insert valid record into this interface table */
515: (
516: org_id,
517: interface_id,
518: batch_id,

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

632: null
633: );
634: EXCEPTION WHEN OTHERS THEN
635: l_status:=0;
636: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_INTERFACE_ALL failed '||SQLERRM);
637: RAISE;
638: END;
639:
640: BEGIN

Line 738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');

734: END;
735:
736: ELSE /* l_status = 0 ie Validation failed*/
737: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
738: fnd_message.set_token('TABLE_NAME','igs_ad_interface_all');
739: fnd_message.set_token('COL_NAMES',l_tokenstr);
740: fnd_message.set_token('ID',inq_rec.inq_person_id);
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: RAISE null_validation_fails;