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_AS_TRNCMT_LGCY_PUB dependencies on FND_API

Line 83: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);

79: || (reverse chronological order - newest change first)
80: ******************************************************************************/
81: IS
82:
83: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
84: l_dummy VARCHAR2(30);
85:
86: CURSOR cur_lookup_code(p_lookup_code igs_lookup_values.lookup_code%TYPE) IS
87: SELECT 'x'

Line 105: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

101: -- nullify the values inappropriate for the current comment_type_code
102: nullify_inappropriate_fields(p_lgcy_trncmt_rec);
103:
104: IF p_lgcy_trncmt_rec.comment_type_code IS NULL THEN
105: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
106: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_NULL');
107: FND_MSG_PUB.ADD;
108: END IF;
109:

Line 111: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

107: FND_MSG_PUB.ADD;
108: END IF;
109:
110: IF p_lgcy_trncmt_rec.comment_txt IS NULL THEN
111: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
112: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_NULL');
113: FND_MSG_PUB.ADD;
114: END IF;
115:

Line 117: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

113: FND_MSG_PUB.ADD;
114: END IF;
115:
116: IF p_lgcy_trncmt_rec.person_number IS NULL THEN
117: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
118: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PER_NUM_NULL');
119: FND_MSG_PUB.ADD;
120: END IF;
121:

Line 126: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

122: IF p_lgcy_trncmt_rec.comment_type_code IS NOT NULL THEN
123: OPEN cur_lookup_code(p_lgcy_trncmt_rec.comment_type_code);
124: FETCH cur_lookup_code INTO l_dummy;
125: IF cur_lookup_code%NOTFOUND THEN
126: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
127: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_CMNT_TYP_INVALID');
128: FND_MSG_PUB.ADD;
129: RETURN l_return_value ;
130: END IF;

Line 139: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

135: p_lgcy_trncmt_rec.comment_type_code = 'CAREER_BASIS' OR
136: p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' ) AND
137: p_lgcy_trncmt_rec.program_type IS NULL
138: THEN
139: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
140: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
141: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_type');
142: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
143: FND_MSG_PUB.ADD;

Line 153: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

149: p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' OR
150: p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_AWARD' ) AND
151: p_lgcy_trncmt_rec.program_cd IS NULL
152: THEN
153: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
155: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'program_cd');
156: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
157: FND_MSG_PUB.ADD;

Line 163: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

159:
160: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_AWARD' AND
161: p_lgcy_trncmt_rec.award_cd IS NULL
162: THEN
163: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
164: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
165: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'award_cd');
166: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
167: FND_MSG_PUB.ADD;

Line 173: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

169:
170: IF p_lgcy_trncmt_rec.comment_type_code = 'CAREER_TERM' AND
171: p_lgcy_trncmt_rec.load_cal_alternate_cd IS NULL
172: THEN
173: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
174: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
175: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'load_cal_alternate_cd');
176: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
177: FND_MSG_PUB.ADD;

Line 182: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

178: END IF;
179:
180: IF p_lgcy_trncmt_rec.comment_type_code = 'PROGRAM_YEAR' THEN
181: IF p_lgcy_trncmt_rec.unit_set_cd IS NULL THEN
182: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
183: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
184: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_set_cd');
185: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
186: FND_MSG_PUB.ADD;

Line 189: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

185: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
186: FND_MSG_PUB.ADD;
187: END IF;
188: IF p_lgcy_trncmt_rec.us_version_number IS NULL THEN
189: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
191: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'us_version_number');
192: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
193: FND_MSG_PUB.ADD;

Line 199: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

195: END IF;
196:
197: IF p_lgcy_trncmt_rec.comment_type_code = 'UNIT_ATTEMPT' THEN
198: IF p_lgcy_trncmt_rec.unit_cd IS NULL THEN
199: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
200: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
201: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_cd');
202: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
203: FND_MSG_PUB.ADD;

Line 206: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

202: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
203: FND_MSG_PUB.ADD;
204: END IF;
205: IF p_lgcy_trncmt_rec.version_number IS NULL THEN
206: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
207: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
208: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'version_number');
209: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
210: FND_MSG_PUB.ADD;

Line 213: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

209: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
210: FND_MSG_PUB.ADD;
211: END IF;
212: IF p_lgcy_trncmt_rec.teach_cal_alternate_cd IS NULL THEN
213: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
214: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
215: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'teach_cal_alternate_cd');
216: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
217: FND_MSG_PUB.ADD;

Line 220: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

216: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
217: FND_MSG_PUB.ADD;
218: END IF;
219: IF p_lgcy_trncmt_rec.location_cd IS NULL THEN
220: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
221: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
222: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'location_cd');
223: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
224: FND_MSG_PUB.ADD;

Line 227: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

223: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
224: FND_MSG_PUB.ADD;
225: END IF;
226: IF p_lgcy_trncmt_rec.unit_class IS NULL THEN
227: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
228: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
229: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'unit_class');
230: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
231: FND_MSG_PUB.ADD;

Line 263: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);

259: || (reverse chronological order - newest change first)
260: ****************************************************************************/
261: IS
262:
263: l_return_value BOOLEAN := FND_API.TO_BOOLEAN(FND_API.G_TRUE);
264: l_message VARCHAR2(2000);
265: l_start_dt DATE ;
266: l_end_dt DATE ;
267: l_teach_cal_type igs_ca_inst.cal_type%TYPE;

Line 294: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

290: p_person_id := igs_ge_gen_003.get_person_id(p_lgcy_trncmt_rec.person_number);
291: IF p_person_id IS NULL THEN
292: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
293: FND_MSG_PUB.ADD;
294: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
295: RETURN l_return_value;
296: END IF;
297:
298: --Get load calendar info

Line 310: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

306: l_message) ;
307: IF p_load_cal_type IS NULL OR p_load_sequence_number IS NULL THEN
308: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
309: FND_MSG_PUB.ADD;
310: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
311: RETURN l_return_value;
312: END IF;
313: END IF;
314:

Line 327: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

323: l_message) ;
324: IF l_teach_cal_type IS NULL OR l_teach_sequence_number IS NULL THEN
325: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
326: FND_MSG_PUB.ADD;
327: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
328: RETURN l_return_value;
329: END IF;
330: END IF;
331:

Line 343: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

339: p_lgcy_trncmt_rec.location_cd,
340: p_lgcy_trncmt_rec.unit_class);
341: FETCH cur_uoo_id INTO p_uoo_id;
342: IF cur_uoo_id%NOTFOUND THEN
343: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
344: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AS_TRNS_CMTS_NULL_CHK');
345: FND_MESSAGE.SET_TOKEN('INT_FIELD', 'uoo_id');
346: FND_MESSAGE.SET_TOKEN('CMNT_TYPE', p_lgcy_trncmt_rec.comment_type_code);
347: FND_MSG_PUB.ADD;

Line 424: l_return_value VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;

420: AND course_cd = cp_course_cd
421: AND unit_set_cd = cp_unit_set_cd;
422:
423: l_dummy VARCHAR2(30);
424: l_return_value VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
425:
426: BEGIN
427: -- Unique key validation
428: IF igs_as_stu_trn_cmts_pkg.get_uk_for_validation(

Line 592: IF NOT FND_API.COMPATIBLE_API_CALL(

588: --Standard start of API savepoint
589: SAVEPOINT create_trncmt;
590:
591: --Standard call to check for call compatibility.
592: IF NOT FND_API.COMPATIBLE_API_CALL(
593: l_api_version,
594: p_api_version,
595: l_api_name,
596: G_PKG_NAME)

Line 598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

594: p_api_version,
595: l_api_name,
596: G_PKG_NAME)
597: THEN
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: --Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 602: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599: END IF;
600:
601: --Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
603: FND_MSG_PUB.INITIALIZE;
604: END IF;
605:
606: --Initialize API return status to success.

Line 607: x_return_status := FND_API.G_RET_STS_SUCCESS;

603: FND_MSG_PUB.INITIALIZE;
604: END IF;
605:
606: --Initialize API return status to success.
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608:
609:
610: --Validate the params passed to this API
611: IF NOT validate_parameters(p_lgcy_trncmt_rec) THEN

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608:
609:
610: --Validate the params passed to this API
611: IF NOT validate_parameters(p_lgcy_trncmt_rec) THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: --Derive trancript comment data

Line 613: RAISE FND_API.G_EXC_ERROR;

609:
610: --Validate the params passed to this API
611: IF NOT validate_parameters(p_lgcy_trncmt_rec) THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: --Derive trancript comment data
617: IF NOT derive_trncmt_data(

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: p_load_cal_type => l_load_cal_type,
621: p_load_sequence_number => l_load_sequence_number,
622: p_uoo_id => l_uoo_id
623: ) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627:
628: --Validate trancript comments for db constraints

Line 625: RAISE FND_API.G_EXC_ERROR;

621: p_load_sequence_number => l_load_sequence_number,
622: p_uoo_id => l_uoo_id
623: ) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627:
628: --Validate trancript comments for db constraints
629: l_return_value := validate_trncmt_db_cons (

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: p_uoo_id => l_uoo_id,
634: p_lgcy_trncmt_rec => p_lgcy_trncmt_rec
635: );
636: IF l_return_value = 'E' THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: RAISE FND_API.G_EXC_ERROR;
639: ELSIF l_return_value = 'W' THEN
640: RAISE WARN_TYPE_ERR; --Error handling Goes here
641: END IF;

Line 638: RAISE FND_API.G_EXC_ERROR;

634: p_lgcy_trncmt_rec => p_lgcy_trncmt_rec
635: );
636: IF l_return_value = 'E' THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: RAISE FND_API.G_EXC_ERROR;
639: ELSIF l_return_value = 'W' THEN
640: RAISE WARN_TYPE_ERR; --Error handling Goes here
641: END IF;
642:

Line 691: IF FND_API.to_Boolean(p_commit) THEN

687: );
688:
689:
690: --Standard check of p_commit.
691: IF FND_API.to_Boolean(p_commit) THEN
692: commit;
693: END IF;
694:
695: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);

Line 703: WHEN FND_API.G_EXC_ERROR THEN

699: WHEN WARN_TYPE_ERR THEN
700: ROLLBACK TO create_trncmt;
701: x_return_status := 'W';
702: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_trncmt;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
707:

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: x_return_status := 'W';
702: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
703: WHEN FND_API.G_EXC_ERROR THEN
704: ROLLBACK TO create_trncmt;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO create_trncmt;

Line 708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

704: ROLLBACK TO create_trncmt;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO create_trncmt;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO create_trncmt;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_trncmt;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_trncmt;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
716: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
717: FND_MSG_PUB.ADD;
718: FND_MSG_PUB.COUNT_AND_GET(p_count => x_msg_count, p_data => x_msg_data);