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_DA_TRNS_IMP dependencies on FND_PROFILE

Line 123: IF fnd_profile.VALUE ('OSS_COUNTRY_CODE') <> 'GB'

119:
120: --1. Institution Code
121: IF person_history_rec.prev_institution_code IS NOT NULL
122: THEN
123: IF fnd_profile.VALUE ('OSS_COUNTRY_CODE') <> 'GB'
124: THEN
125: OPEN c_val_inst_cd_non_uk_cur;
126: FETCH c_val_inst_cd_non_uk_cur INTO c_val_inst_cd_rec;
127: CLOSE c_val_inst_cd_non_uk_cur;

Line 214: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') =

210: BEGIN
211: l_msg_at_index := igs_ge_msg_stack.count_msg;
212: SAVEPOINT before_create_hist;
213:
214: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') =
215: 'EXTERNAL'
216: )
217: THEN
218: write_message ('***** IGS_AD_ACAD_HISTORY_PKG.INSERT_ROW *****'

Line 589: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'

585: SAVEPOINT before_create_transcript;
586: prc_pe_acad_hist (p_trans_record);
587: l_msg_at_index := igs_ge_msg_stack.count_msg;
588:
589: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
590: )
591: THEN
592: OPEN c_source;
593: FETCH c_source INTO l_transcript_source;

Line 606: x_entered_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'

602: x_transcript_source => l_transcript_source,
603: x_date_of_receipt => TRUNC (SYSDATE
604: ),
605: x_entered_gpa => NULL,
606: x_entered_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'
607: ),
608: x_conv_gpa => NULL,
609: x_conv_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'
610: ),

Line 609: x_conv_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'

605: x_entered_gpa => NULL,
606: x_entered_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'
607: ),
608: x_conv_gpa => NULL,
609: x_conv_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'
610: ),
611: x_term_type => p_trans_record.term_type,
612: x_rank_in_class => NULL,
613: x_class_size => NULL,

Line 728: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

724: CLOSE c_dup_cur;
725: l_msg_at_index := igs_ge_msg_stack.count_msg;
726: SAVEPOINT before_update_transcript;
727:
728: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
729: THEN
730: OPEN c_source;
731: FETCH c_source INTO l_source;
732: CLOSE c_source;

Line 743: x_entered_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'

739: x_transcript_source => l_source,
740: x_date_of_receipt => TRUNC (SYSDATE
741: ),
742: x_entered_gpa => p_trans_record.unit_grade_points,
743: x_entered_gs_id => fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE'
744: ),
745: x_conv_gpa => dup_cur_rec.conv_gpa,
746: x_conv_gs_id => dup_cur_rec.conv_gs_id,
747: x_term_type => p_trans_record.term_type,

Line 840: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

836: CLOSE c_dup_cur;
837: l_msg_at_index := igs_ge_msg_stack.count_msg;
838: SAVEPOINT before_update_unit;
839:
840: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
841: THEN
842: igs_ad_term_unitdtls_pkg.update_row (x_rowid => dup_cur_rec.ROWID,
843: x_unit_details_id => dup_cur_rec.unit_details_id,
844: x_term_details_id => dup_cur_rec.term_details_id,

Line 933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

929: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_UNIT_DETAILS');
930: l_msg_at_index := igs_ge_msg_stack.count_msg;
931: SAVEPOINT before_create_unit;
932:
933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
934: THEN
935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',
936: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
937: );

Line 1035: AND (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'

1031: OPEN c_dup_cur;
1032: FETCH c_dup_cur INTO dup_cur_rec;
1033:
1034: IF c_dup_cur%NOTFOUND
1035: AND (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1036: )
1037: THEN
1038: write_log ('Entering create_term_unit_details',
1039: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'

Line 1042: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1038: write_log ('Entering create_term_unit_details',
1039: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1040: );
1041: l_unit_details_id := create_term_unit_details (p_trans_cur_rec);
1042: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1043: THEN
1044: write_log ('Entering update_term_unit_details',
1045: 'igs.plsql.igs_da_trns_imp.process_term_unit_details'
1046: );

Line 1095: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1091: ecx_debug.push ('IGS_DA_TRNS_IMP.CREATE_TERM_DETAILS');
1092: l_msg_at_index := igs_ge_msg_stack.count_msg;
1093: SAVEPOINT before_create_term;
1094:
1095: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1096: THEN
1097: write_message ( 'got p_term_dtls_record.transcript_id '
1098: || p_term_dtls_record.transcript_id
1099: );

Line 1203: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1199: CLOSE c_dup_cur;
1200: l_msg_at_index := igs_ge_msg_stack.count_msg;
1201: SAVEPOINT before_update_term;
1202:
1203: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1204: THEN
1205: igs_ad_term_details_pkg.update_row (x_rowid => dup_cur_rec.ROWID,
1206: x_term_details_id => dup_cur_rec.term_details_id,
1207: x_transcript_id => dup_cur_rec.transcript_id,

Line 1306: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'

1302: OPEN c_dup_cur;
1303: FETCH c_dup_cur INTO dup_cur_rec;
1304:
1305: IF c_dup_cur%NOTFOUND
1306: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1307: THEN
1308: create_term_details (p_trans_cur_rec);
1309: ELSIF NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1310: THEN

Line 1309: ELSIF NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'

1305: IF c_dup_cur%NOTFOUND
1306: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1307: THEN
1308: create_term_details (p_trans_cur_rec);
1309: ELSIF NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1310: THEN
1311: p_trans_cur_rec.term_details_id := dup_cur_rec.term_details_id;
1312: update_term_details (p_trans_cur_rec);
1313: ELSIF c_dup_cur%FOUND

Line 1401: AND entered_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')

1397: FROM igs_ad_code_classes
1398: WHERE CLASS = 'TRANSCRIPT_SOURCE'
1399: AND closed_ind = 'N'
1400: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL')
1401: AND entered_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')
1402: AND conv_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')
1403: AND term_type = l_trans_cur_rec.term_type
1404: AND transcript_type = 'OFFICIAL'
1405: ORDER BY last_update_date DESC;

Line 1402: AND conv_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')

1398: WHERE CLASS = 'TRANSCRIPT_SOURCE'
1399: AND closed_ind = 'N'
1400: AND system_status = 'THIRD_PARTY_TRANSFER_EVAL')
1401: AND entered_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')
1402: AND conv_gs_id = fnd_profile.VALUE ('IGS_AD_INST_GRAD_SCALE')
1403: AND term_type = l_trans_cur_rec.term_type
1404: AND transcript_type = 'OFFICIAL'
1405: ORDER BY last_update_date DESC;
1406:

Line 1520: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'

1516: OPEN c_dup_cur;
1517: FETCH c_dup_cur INTO dup_cur_rec;
1518:
1519: IF ( (l_trans_cur_rec.education_id IS NULL OR c_dup_cur%NOTFOUND)
1520: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL'
1521: )
1522: THEN
1523: write_log ('Calling create_new_transcript_details',
1524: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

Line 1527: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1523: write_log ('Calling create_new_transcript_details',
1524: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1525: );
1526: create_new_transcript_details (l_trans_cur_rec);
1527: ELSIF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1528: THEN
1529: write_log ( 'Calling update_transcript_details for transcript_id='
1530: || dup_cur_rec.transcript_id,
1531: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'

Line 1545: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') <>

1541: );
1542: END IF;
1543:
1544: IF ( c_dup_cur%FOUND
1545: AND NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') <>
1546: 'EXTERNAL'
1547: )
1548: THEN
1549: l_trans_cur_rec.transcript_id := dup_cur_rec.transcript_id;

Line 1557: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1553: write_log ('Before c_transcript_id',
1554: 'igs.plsql.igs_da_trns_imp.create_acad_hist_rec'
1555: );
1556:
1557: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1558: THEN
1559: OPEN c_transcript_id;
1560: FETCH c_transcript_id INTO l_trans_cur_rec.transcript_id;
1561: CLOSE c_transcript_id;

Line 1631: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

1627: l_automatic_grant VARCHAR2 (5);
1628: BEGIN
1629: ecx_debug.push ('IGS_DA_TRNS_IMP.GET_ADV_STND_GRANTING_STATUS');
1630:
1631: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1632: THEN
1633: RETURN 'GRANTED';
1634: ELSE
1635: -- check if autmatically grant adv stnd is checked

Line 2350: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

2346: l_grant_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE;
2347: BEGIN
2348: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_UNIT');
2349:
2350: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
2351: THEN
2352: l_grant_status := 'GRANTED';
2353: ELSE
2354: l_grant_status := get_adv_stnd_granting_status (p_batch_id);

Line 2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');

2715: IS
2716: SELECT hz_parties.party_id
2717: FROM hz_parties, fnd_user
2718: WHERE fnd_user.customer_id = hz_parties.party_id
2719: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
2720:
2721:
2722:
2723: l_adv_stnd_unt c_adv_stnd_unt%ROWTYPE;

Line 3048: IF (nvl(fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'INTERNAL') THEN

3044: x_grd_sch_version_number => rec_unitcd_ver.grd_schm_version_number
3045: );
3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: IF (nvl(fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'INTERNAL') THEN
3049: RETURN;
3050: END IF;
3051: END;
3052: CLOSE c_unitcd_ver;

Line 3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');

3340: IS
3341: SELECT hz_parties.party_id
3342: FROM hz_parties, fnd_user
3343: WHERE fnd_user.customer_id = hz_parties.party_id
3344: AND fnd_user.user_id = fnd_profile.VALUE ('IGS_DA_WF_ADMIN');
3345:
3346: l_request_type_id igs_da_cnfg_req_typ.request_type_id%TYPE;
3347: l_batch_id igs_da_rqst.batch_id%TYPE;
3348: l_person_id hz_parties.party_id%TYPE;

Line 3387: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')

3383: write_message ( 'create_or_get_batch_id : Got person ID as '
3384: || l_person_id
3385: );
3386:
3387: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
3388: THEN
3389: write_message ('create_or_get_batch_id : Source is External');
3390: OPEN c_stdnts_batch (l_person_id);
3391: FETCH c_stdnts_batch INTO v_dummy;

Line 3502: AND (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') =

3498: p_out_batch_id := p_batch_id;
3499: END IF;
3500:
3501: IF UPPER (transaction_sub_type) = UPPER ('NoRequest')
3502: AND (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') =
3503: 'EXTERNAL'
3504: )
3505: AND l_batch_id IS NOT NULL
3506: THEN