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_UC_QUAL_DETS_IMP_PKG dependencies on IGS_UC_QUAL_DETS

Line 1: PACKAGE BODY igs_uc_qual_dets_imp_pkg AS

1: PACKAGE BODY igs_uc_qual_dets_imp_pkg AS
2: /* $Header: IGSUC28B.pls 120.3 2006/05/29 04:18:27 jbaber noship $ */
3:
4: PROCEDURE igs_uc_qual_dets_imp (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER ) AS

Line 4: PROCEDURE igs_uc_qual_dets_imp (errbuf OUT NOCOPY VARCHAR2,

1: PACKAGE BODY igs_uc_qual_dets_imp_pkg AS
2: /* $Header: IGSUC28B.pls 120.3 2006/05/29 04:18:27 jbaber noship $ */
3:
4: PROCEDURE igs_uc_qual_dets_imp (errbuf OUT NOCOPY VARCHAR2,
5: retcode OUT NOCOPY NUMBER ) AS
6: /*************************************************************
7: Created By : rgopalan
8: Date Created On : 2002/02/22

Line 22: ayedubat 07-MAR-03 For the Bug,2824978 the column x_imported_date in Igs_uc_qual_dets_pkg.insert_row

18: smaddali Modified cursor cur_del_rec to delete the unique record being inserted ,
19: identified by unique key fields for bug 2450449 , also modified call to htis cursor
20: bayadav 08-JAN-03 Modified Cur_person_id cursor to cehck for EBL_AMMENDED_RESULT first then EBL_RESULT
21: while fetching value for approved result
22: ayedubat 07-MAR-03 For the Bug,2824978 the column x_imported_date in Igs_uc_qual_dets_pkg.insert_row
23: call is populated with SYSDATE.
24: For the Bug, 2825034 the existing qualifications are deleted first and importing all
25: the qualifications in the UCAS Interface table again.
26: For the Bug, 2825118 a validation is added to check the parent existence of the

Line 59: FROM IGS_UC_QUAL_DETS uqd

55:
56: /* Fetch all the Qualifications Imported from UCAS for deletion */
57: CURSOR cur_del_qual_dets IS
58: SELECT uqd.ROWID, uqd.qual_dets_id, uqd.person_id, uqd.exam_level, uqd.subject_code, uqd.year, uqd.sitting, uqd.awarding_body, uqd.approved_result
59: FROM IGS_UC_QUAL_DETS uqd
60: WHERE imported_flag = 'Y' ;
61:
62: /* this is to check whether the record is unique in igs_uc_qual_dets table */
63: --smaddali 27-jun-2002 added parameter l_approved_result as this field also is part of the unique key

Line 62: /* this is to check whether the record is unique in igs_uc_qual_dets table */

58: SELECT uqd.ROWID, uqd.qual_dets_id, uqd.person_id, uqd.exam_level, uqd.subject_code, uqd.year, uqd.sitting, uqd.awarding_body, uqd.approved_result
59: FROM IGS_UC_QUAL_DETS uqd
60: WHERE imported_flag = 'Y' ;
61:
62: /* this is to check whether the record is unique in igs_uc_qual_dets table */
63: --smaddali 27-jun-2002 added parameter l_approved_result as this field also is part of the unique key
64: -- also added NVL condition for fields which are nullable for bug 2430139
65: --smaddali 18-jul-02 interchanged position of parameters exam_level and subject_code for bug 2430139
66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,

Line 66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,

62: /* this is to check whether the record is unique in igs_uc_qual_dets table */
63: --smaddali 27-jun-2002 added parameter l_approved_result as this field also is part of the unique key
64: -- also added NVL condition for fields which are nullable for bug 2430139
65: --smaddali 18-jul-02 interchanged position of parameters exam_level and subject_code for bug 2430139
66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,
67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,

Line 67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,

63: --smaddali 27-jun-2002 added parameter l_approved_result as this field also is part of the unique key
64: -- also added NVL condition for fields which are nullable for bug 2430139
65: --smaddali 18-jul-02 interchanged position of parameters exam_level and subject_code for bug 2430139
66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,
67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,

Line 68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,

64: -- also added NVL condition for fields which are nullable for bug 2430139
65: --smaddali 18-jul-02 interchanged position of parameters exam_level and subject_code for bug 2430139
66: CURSOR Cur_check_uniqueness ( l_person_id igs_uc_qual_dets.person_id%TYPE,
67: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS

Line 72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS

68: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
69: l_year igs_uc_com_ebl_subj.year%TYPE,
70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
73: SELECT imported_flag
74: FROM igs_uc_qual_dets
75: WHERE person_id = l_person_id
76: AND Exam_level = l_exam_level

Line 74: FROM igs_uc_qual_dets

70: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
71: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE ,
72: l_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
73: SELECT imported_flag
74: FROM igs_uc_qual_dets
75: WHERE person_id = l_person_id
76: AND Exam_level = l_exam_level
77: AND ((subject_code = l_subject_code) OR (subject_code IS NULL AND l_subject_code IS NULL))
78: AND ((year = l_year) OR (year IS NULL AND l_year IS NULL))

Line 101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */

97: SELECT Map2 FROM Igs_he_code_map_val
98: WHERE Association_code = 'UCAS_OSS_AWD_ASSOC'
99: AND Map1 = l_exam_level;
100:
101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */
102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,

Line 102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,

98: WHERE Association_code = 'UCAS_OSS_AWD_ASSOC'
99: AND Map1 = l_exam_level;
100:
101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */
102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,

Line 103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,

99: AND Map1 = l_exam_level;
100:
101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */
102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS

Line 104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,

100:
101: /* this is to get values from igs_uc_qual_dets table for updation when manually entered */
102: CURSOR Cur_qual_dets (l_person_id igs_uc_qual_dets.person_id%TYPE,
103: l_exam_level igs_uc_qual_dets.exam_level%TYPE,
104: l_subject_code igs_uc_qual_dets.subject_code%TYPE,
105: l_year igs_uc_com_ebl_subj.year%TYPE,
106: l_sitting igs_uc_com_ebl_subj.sitting%TYPE,
107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
108: SELECT ROWID, Qual_dets_id, Person_id, Exam_level, Subject_code, Year, Sitting, Awarding_body,

Line 111: FROM igs_uc_qual_dets

107: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE) IS
108: SELECT ROWID, Qual_dets_id, Person_id, Exam_level, Subject_code, Year, Sitting, Awarding_body,
109: Grading_schema_cd, Version_number, Predicted_result, Approved_result, Claimed_result,
110: UCAS_tariff, Imported_flag, Imported_date
111: FROM igs_uc_qual_dets
112: WHERE person_id = l_person_id
113: AND Exam_level = l_exam_level
114: AND Subject_code = l_subject_code
115: AND Year = l_year

Line 128: CURSOR cur_adv_std_exists(cp_qual_dets_id igs_uc_qual_dets.qual_dets_id%TYPE) IS

124: WHERE award_cd = cp_award_cd ;
125: c_grad_sch_rec c_grad_sch%ROWTYPE ;
126:
127: --Check if Advanced standing details exists for the qualification or not.
128: CURSOR cur_adv_std_exists(cp_qual_dets_id igs_uc_qual_dets.qual_dets_id%TYPE) IS
129: SELECT 'X'
130: FROM igs_av_stnd_unit_lvl_all
131: WHERE qual_dets_id = cp_qual_dets_id;
132:

Line 140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,

136: FROM igs_pe_person_base_v
137: WHERE person_id = cp_person_id;
138:
139: --To Identify whether the qualification is valid or not
140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,
141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,

Line 141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,

137: WHERE person_id = cp_person_id;
138:
139: --To Identify whether the qualification is valid or not
140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,
141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,

Line 142: cp_year igs_uc_qual_dets.year%TYPE,

138:
139: --To Identify whether the qualification is valid or not
140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,
141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS

Line 143: cp_sitting igs_uc_qual_dets.sitting%TYPE,

139: --To Identify whether the qualification is valid or not
140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,
141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS
147: SELECT 'X'

Line 144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,

140: CURSOR cur_qual_valid ( cp_person_id igs_uc_qual_dets.person_id%TYPE,
141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS
147: SELECT 'X'
148: FROM igs_uc_app_results apr

Line 145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,

141: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS
147: SELECT 'X'
148: FROM igs_uc_app_results apr
149: WHERE apr.app_no IN ( SELECT app_no

Line 146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS

142: cp_year igs_uc_qual_dets.year%TYPE,
143: cp_sitting igs_uc_qual_dets.sitting%TYPE,
144: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
145: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
146: cp_approved_result igs_uc_qual_dets.approved_result%TYPE) IS
147: SELECT 'X'
148: FROM igs_uc_app_results apr
149: WHERE apr.app_no IN ( SELECT app_no
150: FROM igs_uc_applicants

Line 176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;

172: AND ( (NVL(UPPER(TRIM(apr.ebl_amended_result)),UPPER(TRIM(apr.ebl_result))) = cp_approved_result)
173: OR (cp_approved_result IS NULL AND apr.ebl_amended_result IS NULL AND apr.ebl_result IS NULL)
174: );
175:
176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;
177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;

Line 177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;

173: OR (cp_approved_result IS NULL AND apr.ebl_amended_result IS NULL AND apr.ebl_result IS NULL)
174: );
175:
176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;
177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;

Line 178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;

174: );
175:
176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;
177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;

Line 179: l_person_id igs_uc_qual_dets.person_id%TYPE;

175:
176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;
177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;

Line 180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;

176: l_oss_awarding_body igs_uc_qual_dets.Awarding_body%TYPE;
177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;

Line 181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;

177: l_oss_subject_code igs_uc_qual_dets.subject_code%TYPE;
178: l_oss_exam_level igs_uc_qual_dets.exam_level%TYPE;
179: l_person_id igs_uc_qual_dets.person_id%TYPE;
180: l_exam_level igs_uc_qual_dets.exam_level%TYPE;
181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;

Line 185: l_imported igs_uc_qual_dets.imported_flag%TYPE;

181: l_subject_code igs_uc_qual_dets.subject_code%TYPE;
182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;
186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;
187: igs_uc_he_not_enabled_excep EXCEPTION;
188:
189: l_records_updated NUMBER;

Line 186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;

182: l_year igs_uc_com_ebl_subj.year%TYPE;
183: l_sitting igs_uc_com_ebl_subj.sitting%TYPE;
184: l_awarding_body igs_uc_com_ebl_subj.awarding_body%TYPE;
185: l_imported igs_uc_qual_dets.imported_flag%TYPE;
186: l_qual_dets_id igs_uc_qual_dets.Qual_dets_id%TYPE;
187: igs_uc_he_not_enabled_excep EXCEPTION;
188:
189: l_records_updated NUMBER;
190: l_records_inserted NUMBER;

Line 218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');

214: RAISE igs_uc_he_not_enabled_excep; /* user defined exception */
215: END IF;
216:
217: -- Displays log message "Deleting the existing qualifications that are imported from UCAS and not having Advanced standing details associated with it.".
218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');
219: fnd_file.put_line(fnd_file.log, fnd_message.get);
220: fnd_file.put_line(fnd_file.log,' ' );
221:
222: -- Deleting All the existing Qualifications Records Imported from UCAS

Line 244: --Check if the record exists in IGS_UC_APP_RESULTS for the Qualification Details exists in the IGS_UC_QUAL_DETS table.

240: FETCH cur_per_no INTO l_person_number;
241: CLOSE cur_per_no;
242:
243: l_rec_found := NULL;
244: --Check if the record exists in IGS_UC_APP_RESULTS for the Qualification Details exists in the IGS_UC_QUAL_DETS table.
245: OPEN cur_qual_valid (cur_del_qual_dets_rec.person_id,
246: cur_del_qual_dets_rec.subject_code,
247: cur_del_qual_dets_rec.year,
248: cur_del_qual_dets_rec.sitting,

Line 270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');

266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);

Line 284: igs_uc_qual_dets_pkg.delete_row( x_rowid => cur_del_qual_dets_rec.ROWID );

280: END IF;
281:
282: ELSE
283: --Delete the existing imported Qualification when advanced standing details doesn't exists.
284: igs_uc_qual_dets_pkg.delete_row( x_rowid => cur_del_qual_dets_rec.ROWID );
285: l_records_deleted := l_records_deleted + 1;
286: END IF;
287:
288: END LOOP ;

Line 320: /* getting the associated person id for inserting in to igs_uc_qual_dets table */

316: FETCH Cur_Awarding_body INTO l_oss_awarding_body;
317: CLOSE Cur_Awarding_body;
318:
319:
320: /* getting the associated person id for inserting in to igs_uc_qual_dets table */
321: FOR J IN cur_person_id (I.subject_id) LOOP
322: BEGIN
323:
324: l_msg_count := igs_ge_msg_stack.count_msg;

Line 338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');

334: IF l_imported = 'Y' THEN
335:
336: --Diplays message "the record is already imported.
337: --so nothing should happen in this case i.e., not considered for import".
338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);

Line 409: igs_uc_qual_dets_pkg.Update_row ( x_mode => 'R',

405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:
407: ELSE
408:
409: igs_uc_qual_dets_pkg.Update_row ( x_mode => 'R',
410: x_rowid => Cur_qual_dets_val.ROWID,
411: x_Qual_dets_id => Cur_qual_dets_val.Qual_dets_id,
412: x_Person_id => Cur_qual_dets_val.person_id,
413: x_Exam_level => Cur_qual_dets_val.Exam_level,

Line 504: /* Inserting record in to igs_uc_qual_dets table thru TBH */

500: END IF ;
501:
502: IF l_validation_status = TRUE THEN
503:
504: /* Inserting record in to igs_uc_qual_dets table thru TBH */
505: Igs_uc_qual_dets_pkg.Insert_row ( x_mode => 'R',
506: x_rowid => l_rowid,
507: x_Qual_dets_id => l_Qual_dets_id,
508: x_Person_id => J.person_id,

Line 505: Igs_uc_qual_dets_pkg.Insert_row ( x_mode => 'R',

501:
502: IF l_validation_status = TRUE THEN
503:
504: /* Inserting record in to igs_uc_qual_dets table thru TBH */
505: Igs_uc_qual_dets_pkg.Insert_row ( x_mode => 'R',
506: x_rowid => l_rowid,
507: x_Qual_dets_id => l_Qual_dets_id,
508: x_Person_id => J.person_id,
509: x_Exam_level => l_oss_exam_level,

Line 555: END LOOP; -- Insert/Update Igs_uc_qual_dets looop

551:
552: fnd_file.put_line(fnd_file.log,' ' );
553: l_msg_count := NULL;
554:
555: END LOOP; -- Insert/Update Igs_uc_qual_dets looop
556:
557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );

Line 589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);

585:
586: WHEN OTHERS THEN
587: ROLLBACK;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);
590: fnd_message.retrieve (Errbuf);
591: retcode := 2;
592: igs_ge_msg_stack.conc_exception_hndl;
593:

Line 594: END igs_uc_qual_dets_imp;

590: fnd_message.retrieve (Errbuf);
591: retcode := 2;
592: igs_ge_msg_stack.conc_exception_hndl;
593:
594: END igs_uc_qual_dets_imp;
595:
596:
597:
598:

Line 840: END igs_uc_qual_dets_imp_pkg;

836: p_error_code := NULL;
837:
838: END validate_pe_qual;
839:
840: END igs_uc_qual_dets_imp_pkg;