APPS.IGS_AD_IMP_002 dependencies on IGS_AD_STAT_INT_ALL

Line 184: FROM IGS_AD_STAT_INT_all SI, IGS_AD_INTERFACE_all I

180: l_app VARCHAR2(50);
181:
182: CURSOR STAT_cur (lnInterfaceID NUMBER) IS
183: SELECT SI.*
184: FROM IGS_AD_STAT_INT_all SI, IGS_AD_INTERFACE_all I
185: WHERE si.interface_id = lnInterfaceID
186: AND I.INTERFACE_ID = SI.INTERFACE_ID
187: AND SI.STATUS = '2'
188: AND I.STATUS IN ('1','4'); --4035277, if address errors out, it sets status =4 for ad_interface

Line 656: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E205','IGS_AD_STAT_INT_ALL');

652: IF NOT
653: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_RELIGION',stat_rec.religion_cd,8405))
654: THEN
655: IF l_enable_log = 'Y' THEN
656: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E205','IGS_AD_STAT_INT_ALL');
657: END IF;
658: l_error_code := 'E205' ;
659: RAISE NO_DATA_FOUND;
660: END IF;

Line 669: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E206','IGS_AD_STAT_INT_ALL');

665: IF NOT
666: (igs_pe_pers_imp_001.validate_lookup_type_code('MARITAL_STATUS',stat_rec.MARITAL_STATUS,222))
667: THEN
668: IF l_enable_log = 'Y' THEN
669: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E206','IGS_AD_STAT_INT_ALL');
670: END IF;
671: l_error_code :='E206';
672: RAISE NO_DATA_FOUND;
673: END IF;

Line 695: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E277','IGS_AD_STAT_INT_ALL');

691: END IF;
692: EXCEPTION
693: WHEN NO_DATA_FOUND THEN
694: IF l_enable_log = 'Y' THEN
695: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E277','IGS_AD_STAT_INT_ALL');
696: END IF;
697: l_error_code :='E277';
698: RAISE NO_DATA_FOUND;
699: END;

Line 709: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E207','IGS_AD_STAT_INT_ALL');

705: IF NOT
706: (igs_pe_pers_imp_001.validate_lookup_type_code('IGS_ETHNIC_ORIGIN',stat_rec.ETHNIC_ORIGIN,8405))
707: THEN
708: IF l_enable_log = 'Y' THEN
709: igs_ad_imp_001.logerrormessage(stat_rec.INTERFACE_STAT_ID,'E207','IGS_AD_STAT_INT_ALL');
710: END IF;
711: l_error_code := 'E207' ;
712: RAISE NO_DATA_FOUND;
713: END IF;

Line 808: UPDATE IGS_AD_STAT_INT_ALL

804: );
805:
806: IF l_return_status IN ('E','U') THEN
807: ROLLBACK TO before_insert_stats;
808: UPDATE IGS_AD_STAT_INT_ALL
809: SET STATUS = '3',
810: ERROR_CODE = 'E005'
811: WHERE INTERFACE_STAT_ID = stat_rec.INTERFACE_STAT_ID;
812:

Line 837: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

833: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
834: END IF;
835:
836: IF l_enable_log = 'Y' THEN
837: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
838: END IF;
839:
840: ELSE
841: UPDATE IGS_AD_STAT_INT_ALL

Line 841: UPDATE IGS_AD_STAT_INT_ALL

837: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
838: END IF;
839:
840: ELSE
841: UPDATE IGS_AD_STAT_INT_ALL
842: SET STATUS = '1',
843: ERROR_CODE = NULL, --ssomani, added this 3/15/01
844: PERSON_ID = P_PERSON_ID
845: WHERE INTERFACE_STAT_ID = stat_rec.INTERFACE_STAT_ID;

Line 854: UPDATE IGS_AD_STAT_INT_ALL

850: EXCEPTION
851: WHEN NO_DATA_FOUND THEN
852: ROLLBACK TO before_insert_stats;
853: L_MSG_DATA := SQLERRM;
854: UPDATE IGS_AD_STAT_INT_ALL
855: SET status = '3',
856: error_code = l_error_code
857: WHERE INTERFACE_STAT_ID = stat_rec.INTERFACE_STAT_ID;
858:

Line 868: UPDATE IGS_AD_STAT_INT_ALL

864: WHEN OTHERS THEN
865: L_MSG_DATA := SQLERRM;
866: ROLLBACK TO before_insert_stats;
867:
868: UPDATE IGS_AD_STAT_INT_ALL
869: SET STATUS = '3',
870: ERROR_CODE = 'E005'
871: WHERE INTERFACE_STAT_ID = stat_rec.INTERFACE_STAT_ID;
872:

Line 897: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');

893: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
894: END IF;
895:
896: IF l_enable_log = 'Y' THEN
897: igs_ad_imp_001.logerrormessage(stat_rec.interface_stat_id,'E005','IGS_AD_STAT_INT_ALL');
898: END IF;
899:
900: END;
901: END IF;