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_004 dependencies on IGS_AD_APPL

Line 42: l_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE ;

38:
39: /***************************Status,Discrepancy Rule, Match Indicators, Error Codes*******************/
40:
41: -- Initialize Application Status , Fee status
42: l_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE ;
43: l_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE ;
44: l_Late_Adm_Fee_Status IGS_AD_FEE_STAT.adm_fee_status%TYPE ;
45: l_cndnl_ofr_must_be_stsfd_ind IGS_AD_PS_APPL_INST.cndtnl_offer_must_be_stsfd_ind%TYPE ;
46: l_adm_pending_outcome_status VARCHAR2(127) ;

Line 50: l_admission_application_type IGS_AD_APPL.application_type%TYPE ;

46: l_adm_pending_outcome_status VARCHAR2(127) ;
47: l_adm_cndtnl_offer_status VARCHAR2(127) ;
48: l_adm_offer_resp_status VARCHAR2(127) ;
49: l_adm_offer_dfrmnt_status VARCHAR2(127) ;
50: l_admission_application_type IGS_AD_APPL.application_type%TYPE ;
51: l_admission_cat IGS_AD_APPL.admission_cat%TYPE ;
52: l_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE ;
53: l_adm_doc_status igs_ad_ps_appl_inst.adm_doc_status%TYPE;
54:

Line 51: l_admission_cat IGS_AD_APPL.admission_cat%TYPE ;

47: l_adm_cndtnl_offer_status VARCHAR2(127) ;
48: l_adm_offer_resp_status VARCHAR2(127) ;
49: l_adm_offer_dfrmnt_status VARCHAR2(127) ;
50: l_admission_application_type IGS_AD_APPL.application_type%TYPE ;
51: l_admission_cat IGS_AD_APPL.admission_cat%TYPE ;
52: l_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE ;
53: l_adm_doc_status igs_ad_ps_appl_inst.adm_doc_status%TYPE;
54:
55: l_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE ;

Line 52: l_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE ;

48: l_adm_offer_resp_status VARCHAR2(127) ;
49: l_adm_offer_dfrmnt_status VARCHAR2(127) ;
50: l_admission_application_type IGS_AD_APPL.application_type%TYPE ;
51: l_admission_cat IGS_AD_APPL.admission_cat%TYPE ;
52: l_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE ;
53: l_adm_doc_status igs_ad_ps_appl_inst.adm_doc_status%TYPE;
54:
55: l_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE ;
56: l_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE ;

Line 74: PROCEDURE populate_apc_columns(p_admission_application_type IGS_AD_APPL.APPLICATION_TYPE%TYPE) IS

70: l_pref_allowed VARCHAR2(1);
71: l_comp_yr_allowed VARCHAR2(1);
72: l_edu_goal_allowed VARCHAR2(1);
73:
74: PROCEDURE populate_apc_columns(p_admission_application_type IGS_AD_APPL.APPLICATION_TYPE%TYPE) IS
75: v_description VARCHAr2(2000);
76: l_appl_type_valid VARCHAR2(10);
77: /*---------------------------------------------------------------------------------------------------------
78: Check the APC allows following attribute if not and user provides values in columns error out.

Line 258: l_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

254: p_enable_log VARCHAR2,
255: p_legacy_ind IN VARCHAR2) AS
256:
257: l_request_id NUMBER ;
258: l_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
259:
260: CURSOR
261: appl_cur IS
262: SELECT cst_insert dmlmode, api.rowid, api.*

Line 313: IGS_AD_APPL appl_oss

309: CURSOR c_dup_cur(appl_rec appl_cur%ROWTYPE) IS
310: SELECT
311: appl_oss.rowid, appl_oss.*
312: FROM
313: IGS_AD_APPL appl_oss
314: WHERE person_id = appl_Rec.person_id
315: AND admission_Appl_number = appl_rec.update_adm_appl_number;
316:
317: CURSOR dup_applinst_cur(applinst_rec applinst_cur%ROWTYPE,

Line 319: p_admission_appl_number IGS_AD_APPL.admission_Appl_number%TYPE

315: AND admission_Appl_number = appl_rec.update_adm_appl_number;
316:
317: CURSOR dup_applinst_cur(applinst_rec applinst_cur%ROWTYPE,
318: p_person_id hz_parties.party_id%TYPE,
319: p_admission_appl_number IGS_AD_APPL.admission_Appl_number%TYPE
320: ) IS
321: SELECT
322: acai.rowid,acai.*
323: FROM

Line 358: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

354: l_error_code := 'E322';
355: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
356: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
357: IF p_enable_log = 'Y' THEN
358: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
359: END IF;
360: RETURN FALSE;
361: END IF;
362:

Line 372: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

368: l_error_code := 'E322';
369: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
370: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
371: IF p_enable_log = 'Y' THEN
372: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
373: END IF;
374: RETURN FALSE;
375: END IF;
376:

Line 386: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

382: l_error_code := 'E322';
383: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
384: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
385: IF p_enable_log = 'Y' THEN
386: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
387: END IF;
388: RETURN FALSE;
389: END IF;
390:

Line 400: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

396: l_error_text := FND_MESSAGE.GET;
397: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
398: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
399: IF p_enable_log = 'Y' THEN
400: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
401: END IF;
402: RETURN FALSE;
403: END IF;
404:

Line 414: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

410: l_error_code := 'E322';
411: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
412: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
413: IF p_enable_log = 'Y' THEN
414: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
415: END IF;
416: RETURN FALSE;
417: END IF;
418:

Line 428: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

424: l_error_text := FND_MESSAGE.GET;
425: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
426: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
427: IF p_enable_log = 'Y' THEN
428: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
429: END IF;
430: RETURN FALSE;
431: END IF;
432:

Line 442: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

438: l_error_code := 'E322';
439: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
440: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
441: IF p_enable_log = 'Y' THEN
442: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
443: END IF;
444: RETURN FALSE;
445: END IF;
446:

Line 456: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

452: l_error_code := 'E322';
453: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
454: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
455: IF p_enable_log = 'Y' THEN
456: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
457: END IF;
458: RETURN FALSE;
459: END IF;
460:

Line 468: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

464: l_error_code := 'E322';
465: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
466: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
467: IF p_enable_log = 'Y' THEN
468: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
469: END IF;
470: RETURN FALSE;
471: END IF;
472:

Line 482: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

478: l_error_code := 'E322';
479: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
480: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
481: IF p_enable_log = 'Y' THEN
482: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
483: END IF;
484: RETURN FALSE;
485: END IF;
486:

Line 496: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

492: l_error_code := 'E322';
493: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
494: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
495: IF p_enable_log = 'Y' THEN
496: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
497: END IF;
498: RETURN FALSE;
499: END IF;
500:

Line 510: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

506: l_error_code := 'E322';
507: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
508: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
509: IF p_enable_log = 'Y' THEN
510: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
511: END IF;
512: RETURN FALSE;
513: END IF;
514: RETURN TRUE;

Line 519: p_admission_appl_number OUT NOCOPY IGS_AD_APPL.admission_Appl_number%TYPE,

515: END validate_apc_steps;
516: ---------------------------------------------------------------------------------------------------------
517:
518: PROCEDURE create_application_details ( p_appl_rec appl_cur%ROWTYPE,
519: p_admission_appl_number OUT NOCOPY IGS_AD_APPL.admission_Appl_number%TYPE,
520: p_status OUT NOCOPY VARCHAR2) IS
521: /*-----------------------------------------------------------------------------------------
522: Created By: pbondugu
523: Date Created : 24-Nov-2003

Line 531: FROM IGS_AD_APPL

527: Who When What
528: -----------------------------------------------------------------------------------------*/
529: CURSOR c_aa IS
530: SELECT NVL(MAX(admission_appl_number),0) + 1
531: FROM IGS_AD_APPL
532: WHERE person_id = p_appl_rec.person_id;
533:
534: l_rowid VARCHAR2(25);
535: l_status VARCHAR2(1);

Line 536: l_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

532: WHERE person_id = p_appl_rec.person_id;
533:
534: l_rowid VARCHAR2(25);
535: l_status VARCHAR2(1);
536: l_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
537: l_msg_at_index NUMBER ;
538: l_return_status VARCHAR2(1);
539: l_msg_count NUMBER ;
540: l_msg_data VARCHAR2(2000);

Line 553: IGS_AD_APPL_PKG.insert_row (

549: BEGIN
550: p_status := 'S';
551: SAVEPOINT before_insert_appl;
552: l_msg_at_index := igs_ge_msg_stack.count_msg;
553: IGS_AD_APPL_PKG.insert_row (
554: X_Mode => 'R',
555: X_RowId => l_rowid,
556: X_Person_Id => p_appl_rec.Person_Id,
557: X_Admission_Appl_Number => l_adm_appl_number,

Line 639: l_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;

635: Change History
636: Who When What
637: -----------------------------------------------------------------------------------------*/
638: l_rowid VARCHAR2(25);
639: l_adm_appl_number IGS_AD_APPL.admission_appl_number%TYPE;
640: l_msg_at_index NUMBER ;
641: l_return_status VARCHAR2(1);
642: l_msg_count NUMBER ;
643: l_msg_data VARCHAR2(2000);

Line 652: IGS_AD_APPL_PKG.update_row (

648: BEGIN
649: BEGIN
650: l_msg_at_index := igs_ge_msg_stack.count_msg;
651: SAVEPOINT before_update_appl;
652: IGS_AD_APPL_PKG.update_row (
653: X_Mode => 'R',
654: X_RowId => dup_cur_rec.rowid,
655: X_Person_Id => p_appl_rec.Person_Id,
656: X_admission_appl_Number => p_appl_rec.update_adm_appl_number,

Line 741: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,

737: END update_application_details;
738: --Declaration of create_single_appl_instance
739: PROCEDURE create_single_appl_instance(p_applinst_rec applinst_cur%ROWTYPE,
740: p_person_id hz_parties.party_id%TYPE,
741: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
742: p_appl_rec appl_cur%ROWTYPE,
743: p_Status OUT NOCOPY VARCHAR2) ;
744:
745: PROCEDURE create_application_instance(p_interface_appl_id IGS_AD_APL_INT.interface_appl_id%TYPE,

Line 747: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,

743: p_Status OUT NOCOPY VARCHAR2) ;
744:
745: PROCEDURE create_application_instance(p_interface_appl_id IGS_AD_APL_INT.interface_appl_id%TYPE,
746: p_person_id hz_parties.party_id%TYPE,
747: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
748: p_appl_rec appl_cur%ROWTYPE,
749: p_Status_instance OUT NOCOPY VARCHAR2) IS
750: --------------------------------------------------------------------------
751: -- Created By : pbondugu

Line 790: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,

786:
787:
788: PROCEDURE create_single_appl_instance(p_applinst_rec applinst_cur%ROWTYPE,
789: p_person_id hz_parties.party_id%TYPE,
790: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
791: p_appl_rec appl_cur%ROWTYPE,
792: p_Status OUT NOCOPY VARCHAR2) IS
793: --------------------------------------------------------------------------
794: -- Created By : pbondugu

Line 819: FROM igs_Ad_appl_all

815:
816: CURSOR c_session_info(cp_person_id IGS_AD_PS_APPL.person_id%TYPE,
817: cp_appl_no IGS_AD_PS_APPL.admission_appl_number%TYPE) IS
818: SELECT adm_cal_type, adm_ci_sequence_number, acad_cal_type , s_admission_process_type
819: FROM igs_Ad_appl_all
820: WHERE person_id = cp_person_id
821: AND admission_Appl_number = cp_appl_no;
822:
823: CURSOR c_nxt_acai_seq_num IS

Line 987: p_desc_flex_name => 'IGS_AD_APPL_INST_FLEX'

983: p_attribute37 => p_applinst_rec.attribute37,
984: p_attribute38 => p_applinst_rec.attribute38,
985: p_attribute39 => p_applinst_rec.attribute39,
986: p_attribute40 => p_applinst_rec.attribute40,
987: p_desc_flex_name => 'IGS_AD_APPL_INST_FLEX'
988: ) THEN
989: FND_MESSAGE.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
990: l_error_text := FND_MESSAGE.get;
991: p_status := '3';

Line 996: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

992: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
993: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => 'E322');
994:
995: IF p_enable_log = 'Y' THEN
996: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
997: END IF;
998: RETURN;
999: END IF;
1000:

Line 1239: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

1235: l_error_text := l_msg_data;
1236: l_error_code := 'E322';
1237:
1238: IF p_enable_log = 'Y' THEN
1239: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
1240: END IF;
1241: ELSE
1242: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1243: l_error_code := 'E518';

Line 1502: igs_ad_imp_001.logerrormessage(applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

1498: l_error_text := l_msg_data;
1499: l_error_code := NULL;
1500:
1501: IF p_enable_log = 'Y' THEN
1502: igs_ad_imp_001.logerrormessage(applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');
1503: END IF;
1504: ELSE
1505: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1506: l_error_code := 'E518';

Line 1666: AND NOT EXISTS ( SELECT 1 FROM IGS_AD_APPL appl_oss

1662: error_code = 'E523',
1663: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E523', 8405)
1664: WHERE interface_run_id = p_interface_run_id
1665: AND update_adm_appl_number IS NOT NULL
1666: AND NOT EXISTS ( SELECT 1 FROM IGS_AD_APPL appl_oss
1667: WHERE person_id = api.person_id
1668: AND admission_Appl_number =
1669: NVL(api.update_adm_appl_number, appl_oss.admission_Appl_number)
1670: ) ;

Line 1825: AND EXISTS ( SELECT 1 FROM IGS_AD_APPL appl_oss

1821: , admission_appl_number = api.update_adm_appl_number
1822: WHERE interface_run_id = p_interface_run_id
1823: AND status = '2'
1824: AND NVL (match_ind, '15') = '15'
1825: AND EXISTS ( SELECT 1 FROM IGS_AD_APPL appl_oss
1826: WHERE person_id = api.person_id
1827: AND admission_appl_number = api.update_adm_appl_number
1828: AND TRUNC(appl_dt) = TRUNC(api.appl_dt)
1829: AND tac_appl_ind = api.tac_appl_ind