eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_010 dependencies on IGS_AD_EDUGOAL

Line 299: l_error_code igs_ad_edugoal_int.error_code%TYPE;

295: l_prog_label VARCHAR2(100);
296: l_label VARCHAR2(100);
297: l_debug_str VARCHAR2(2000);
298: l_request_id NUMBER;
299: l_error_code igs_ad_edugoal_int.error_code%TYPE;
300: l_records_processed NUMBER := 0;
301:
302: --
303: -- Start of Local Procedure create_applicant_edu_goals

Line 308: CURSOR c_igs_ad_edugoal_int IS

304: --
305: PROCEDURE create_applicant_edu_goals(
306: p_interface_run_id IN NUMBER ) IS
307:
308: CURSOR c_igs_ad_edugoal_int IS
309: SELECT cst_insert dmlmode, rowid, a.*
310: FROM igs_ad_edugoal_int a
311: WHERE interface_run_id = p_interface_run_id
312: AND status = cst_s_val_2;

Line 310: FROM igs_ad_edugoal_int a

306: p_interface_run_id IN NUMBER ) IS
307:
308: CURSOR c_igs_ad_edugoal_int IS
309: SELECT cst_insert dmlmode, rowid, a.*
310: FROM igs_ad_edugoal_int a
311: WHERE interface_run_id = p_interface_run_id
312: AND status = cst_s_val_2;
313:
314: l_rowid ROWID;

Line 315: l_post_edugoal_id igs_ad_edugoal.post_edugoal_id%TYPE;

311: WHERE interface_run_id = p_interface_run_id
312: AND status = cst_s_val_2;
313:
314: l_rowid ROWID;
315: l_post_edugoal_id igs_ad_edugoal.post_edugoal_id%TYPE;
316: l_msg_at_index NUMBER := 0;
317: l_return_status VARCHAR2(1);
318: l_error_text VARCHAR2(2000);
319: l_msg_count NUMBER ;

Line 339: FOR edugoal_rec IN c_igs_ad_edugoal_int

335: END IF;
336:
337: l_records_processed := 0;
338:
339: FOR edugoal_rec IN c_igs_ad_edugoal_int
340: LOOP
341: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => edugoal_rec.admission_application_type,
342: p_admission_cat => l_admission_cat,
343: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN

Line 352: UPDATE igs_ad_edugoal_int

348: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
349: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
350: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
351: l_error_text := FND_MESSAGE.GET;
352: UPDATE igs_ad_edugoal_int
353: SET
354: status = cst_s_val_3
355: , error_code = cst_ec_val_E701
356: , error_text = l_error_text

Line 364: igs_ad_edugoal_pkg.insert_row

360: BEGIN
361: SAVEPOINT before_create;
362: l_msg_at_index := igs_ge_msg_stack.count_msg;
363:
364: igs_ad_edugoal_pkg.insert_row
365: (
366: X_ROWID => l_rowid,
367: X_POST_EDUGOAL_ID => l_post_edugoal_id,
368: X_PERSON_ID => edugoal_rec.person_id,

Line 375: UPDATE igs_ad_edugoal_int

371: X_SEQUENCE_NUMBER => edugoal_rec.sequence_number,
372: X_EDU_GOAL_ID => edugoal_rec.edu_goal_id,
373: X_MODE => 'R'
374: );
375: UPDATE igs_ad_edugoal_int
376: SET status = cst_s_val_1
377: WHERE rowid = edugoal_rec.rowid;
378:
379: l_records_processed := l_records_processed + 1;

Line 402: igs_ad_imp_001.logerrormessage(edugoal_rec.interface_edugoal_id,l_msg_data,'IGS_AD_EDUGOAL_INT');

398: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
399:
400: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
401: IF p_enable_log = 'Y' THEN
402: igs_ad_imp_001.logerrormessage(edugoal_rec.interface_edugoal_id,l_msg_data,'IGS_AD_EDUGOAL_INT');
403: END IF;
404: ELSE
405: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
406: l_label := 'igs.plsql.igs_ad_imp_010.prcs_applnt_edu_goal_dtls.create_applicant_edu_goals.for_loop.execption'||l_error_code;

Line 418: UPDATE igs_ad_edugoal_int

414: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
415: END IF;
416: END IF;
417:
418: UPDATE igs_ad_edugoal_int
419: SET status = cst_s_val_3
420: ,error_code = l_error_code
421: ,error_text = l_error_text
422: WHERE rowid = edugoal_rec.rowid;

Line 431: UPDATE igs_ad_edugoal_int

427: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
428: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
429: FND_MESSAGE.SET_TOKEN ('APPLTYPE', edugoal_rec.admission_application_type);
430: l_error_text := FND_MESSAGE.GET;
431: UPDATE igs_ad_edugoal_int
432: SET
433: status = cst_s_val_3
434: , error_code = cst_ec_val_E701
435: , error_text = l_error_text

Line 467: UPDATE igs_ad_edugoal_int in_rec

463: END IF;
464:
465: -- Set STATUS to 3 when duplicate record is found
466:
467: UPDATE igs_ad_edugoal_int in_rec
468: SET status = cst_s_val_3
469: ,error_code = cst_ec_val_E678
470: ,error_text = cst_et_val_E678
471: WHERE interface_run_id = p_interface_run_id

Line 474: FROM igs_ad_edugoal mn_rec

470: ,error_text = cst_et_val_E678
471: WHERE interface_run_id = p_interface_run_id
472: AND status = cst_s_val_2
473: AND EXISTS ( SELECT 1
474: FROM igs_ad_edugoal mn_rec
475: WHERE mn_rec.person_id = in_rec.person_id
476: AND mn_rec.admission_appl_number = in_rec.admission_appl_number
477: AND mn_rec.nominated_course_cd = in_rec.nominated_course_cd
478: AND mn_rec.edu_goal_id = in_rec.edu_goal_id