APPS.IGS_AD_IMP_010 dependencies on IGS_AD_NOTES_INT

Line 73: l_error_code igs_ad_notes_int.error_code%TYPE;

69: l_prog_label VARCHAR2(100);
70: l_label VARCHAR2(100);
71: l_debug_str VARCHAR2(2000);
72: l_request_id NUMBER;
73: l_error_code igs_ad_notes_int.error_code%TYPE;
74: l_records_processed NUMBER := 0;
75:
76: -- local procedure
77: PROCEDURE crt_apcnt_notes(

Line 81: CURSOR c_igs_ad_notes_int IS

77: PROCEDURE crt_apcnt_notes(
78: p_interface_run_id IN NUMBER ) IS
79:
80:
81: CURSOR c_igs_ad_notes_int IS
82: SELECT cst_insert dmlmode, rowid, a.*
83: FROM igs_ad_notes_int a
84: WHERE interface_run_id = p_interface_run_id
85: AND status = cst_s_val_2;

Line 83: FROM igs_ad_notes_int a

79:
80:
81: CURSOR c_igs_ad_notes_int IS
82: SELECT cst_insert dmlmode, rowid, a.*
83: FROM igs_ad_notes_int a
84: WHERE interface_run_id = p_interface_run_id
85: AND status = cst_s_val_2;
86:
87: l_Appl_Notes_Id NUMBER;

Line 116: FOR notes_rec IN c_igs_ad_notes_int

112: END IF;
113:
114: l_records_processed := 0;
115:
116: FOR notes_rec IN c_igs_ad_notes_int
117: LOOP
118: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => notes_rec.admission_application_type,
119: p_admission_cat => l_admission_cat,
120: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN

Line 129: UPDATE igs_ad_notes_int

125: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
126: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
127: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
128: l_error_text := FND_MESSAGE.GET;
129: UPDATE igs_ad_notes_int
130: SET
131: status = cst_s_val_3
132: , error_code = cst_ec_val_E701
133: , error_text = l_error_text

Line 144: UPDATE igs_ad_notes_int

140: x_closed_ind => 'N') THEN
141: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_PK_UK_NOT_FOUND_CLOSED');
142: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE', FND_MESSAGE.GET_STRING('IGS','IGS_AD_NOTE_TYPE'));
143: l_error_text := FND_MESSAGE.GET;
144: UPDATE igs_ad_notes_int
145: SET
146: status = cst_s_val_3
147: , error_code = cst_ec_val_E701
148: , error_text = l_error_text

Line 173: UPDATE igs_ad_notes_int

169: X_REFERENCE_NUMBER => l_Ref_Notes_Id,
170: X_S_NOTE_FORMAT_TYPE => 'TEXT',
171: X_NOTE_TEXT => notes_rec.notes,
172: X_MODE => 'R');
173: UPDATE igs_ad_notes_int
174: SET
175: status = cst_s_val_1
176: WHERE rowid = notes_rec.rowid;
177: l_records_processed := l_records_processed + 1;

Line 198: igs_ad_imp_001.logerrormessage(notes_rec.interface_notes_id,l_msg_data,'IGS_AD_NOTES_INT');

194: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
195:
196: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
197: IF p_enable_log = 'Y' THEN
198: igs_ad_imp_001.logerrormessage(notes_rec.interface_notes_id,l_msg_data,'IGS_AD_NOTES_INT');
199: END IF;
200: ELSE
201: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
202:

Line 219: UPDATE igs_ad_notes_int

215: END IF;
216:
217:
218:
219: UPDATE igs_ad_notes_int
220: SET status = cst_s_val_3
221: , error_code = l_error_code
222: , error_text = l_error_text
223: WHERE rowid = notes_rec.rowid;

Line 234: UPDATE igs_ad_notes_int

230: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
231: FND_MESSAGE.SET_TOKEN ('APPLTYPE', notes_rec.admission_application_type);
232: l_error_text := FND_MESSAGE.GET;
233:
234: UPDATE igs_ad_notes_int
235: SET status = cst_s_val_3
236: , error_code = cst_ec_val_E701
237: , error_text = l_error_text
238: WHERE rowid = notes_rec.rowid;

Line 269: UPDATE igs_ad_notes_int in_rec

265: END IF;
266:
267: -- Set STATUS to 3 when duplicate record is found
268:
269: UPDATE igs_ad_notes_int in_rec
270: SET
271: status = cst_s_val_3
272: , error_code = cst_ec_val_E678
273: , error_text = cst_et_val_E678