APPS.IGS_AD_IMP_003 dependencies on IGS_AD_ACADINT_INT

Line 65: FROM igs_ad_acadint_int a

61: AS
62:
63: CURSOR c_acadint IS
64: SELECT rowid,a.*
65: FROM igs_ad_acadint_int a
66: WHERE interface_run_id = p_interface_run_id
67: AND status = '2';
68:
69: l_acadint_rec c_acadint%ROWTYPE;

Line 116: UPDATE igs_ad_acadint_int a

112: END IF;
113:
114: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
115:
116: UPDATE igs_ad_acadint_int a
117: SET status = '3',
118: error_code = 'E678',
119: error_text = l_error_text1
120: WHERE

Line 130: UPDATE igs_ad_acadint_int a

126: AND b.field_of_study = a.field_of_study );
127:
128: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E420', 8405);
129:
130: UPDATE igs_ad_acadint_int a
131: SET status = '3',
132: error_code = 'E420',
133: error_text = l_error_text1
134: WHERE interface_run_id = p_interface_run_id

Line 161: UPDATE igs_ad_acadint_int

157:
158: l_error_text := FND_MESSAGE.GET;
159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
160:
161: UPDATE igs_ad_acadint_int
162: SET status = cst_s_val_3,
163: error_code = cst_ec_val_E701,
164: error_text = NVL(l_error_text,l_error_text1)
165: WHERE rowid = c_acadint_rec.rowid;

Line 196: UPDATE igs_ad_acadint_int

192: END IF;
193:
194: IF l_type = 'E' THEN
195: ROLLBACK TO acadint_save;
196: UPDATE igs_ad_acadint_int
197: SET status = cst_s_val_3,
198: error_code = cst_ec_val_E322,
199: error_text = l_error_text
200: WHERE rowid = c_acadint_rec.rowid;

Line 207: UPDATE igs_ad_acadint_int

203: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);
204: END IF;
205:
206: ELSIF l_type = 'S' THEN
207: UPDATE igs_ad_acadint_int
208: SET status = cst_s_val_4,
209: error_code = cst_ec_val_E702,
210: error_text = l_error_text
211: WHERE rowid = c_acadint_rec.rowid;

Line 218: UPDATE igs_ad_acadint_int

214: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);
215: END IF;
216:
217: ELSIF l_type IS NULL THEN
218: UPDATE igs_ad_acadint_int
219: SET status = cst_s_val_1,
220: error_code = NULL,
221: error_text = NULL
222: WHERE rowid = c_acadint_rec.rowid;

Line 239: UPDATE igs_ad_acadint_int

235:
236: l_error_text := FND_MESSAGE.GET;
237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
238:
239: UPDATE igs_ad_acadint_int
240: SET status = cst_s_val_3,
241: error_code = cst_ec_val_E701,
242: error_text = NVL(l_error_text,l_error_text1)
243: WHERE rowid = c_acadint_rec.rowid;

Line 288: UPDATE igs_ad_acadint_int

284: END IF;
285:
286: ROLLBACK TO acadint_save;
287:
288: UPDATE igs_ad_acadint_int
289: SET status = cst_s_val_3,
290: error_code = l_error_code ,
291: error_text = l_error_text
292: WHERE rowid = c_acadint_rec.rowid;