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

Line 26: RAISE FND_API.G_EXC_ERROR;

22: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
23: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
24: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
25: IGS_GE_MSG_STACK.ADD;
26: RAISE FND_API.G_EXC_ERROR;
27:
28:
29: ELSIF l_col_length.column_type ='N' AND p_param_length > (l_col_length.precision - l_col_length.scale) THEN
30: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');

Line 38: RAISE FND_API.G_EXC_ERROR;

34: ELSE
35: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision );
36: END IF;
37: IGS_GE_MSG_STACK.ADD;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
41:
42: END check_length;

Line 48: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

44: --API
45: PROCEDURE RECORD_ACADEMIC_INDEX(
46: --Standard Parameters Start
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
49: p_commit IN VARCHAR2 default FND_API.G_FALSE,
50: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

Line 49: p_commit IN VARCHAR2 default FND_API.G_FALSE,

45: PROCEDURE RECORD_ACADEMIC_INDEX(
46: --Standard Parameters Start
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
49: p_commit IN VARCHAR2 default FND_API.G_FALSE,
50: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,

Line 50: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

46: --Standard Parameters Start
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
49: p_commit IN VARCHAR2 default FND_API.G_FALSE,
50: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: --Standard parameter ends

Line 108: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

104: BEGIN
105: l_msg_index := 0;
106: SAVEPOINT RECORD_ACADEMIC_INDEX_pub;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 109: RAISE FND_API.G_EXC_ERROR;

105: l_msg_index := 0;
106: SAVEPOINT RECORD_ACADEMIC_INDEX_pub;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

109: RAISE FND_API.G_EXC_ERROR;
110: END IF;
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116: l_msg_index := igs_ge_msg_stack.count_msg;
117:

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: -- END OF PARAMETER VALIDATIONS.
132:
133:
134: -- Initialize API return status to success
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137:
138: OPEN C_ACAI(p_person_id,
139: p_admission_appl_number,

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144:
145: IF c_acai%NOTFOUND THEN --If no application instance exists for this application
146: --with s_adm_outcome_status = 'PENDING'
147: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_NO_APPL');
150: IGS_GE_MSG_STACK.ADD;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF c_acai%FOUND THEN

Line 151: RAISE FND_API.G_EXC_ERROR;

147: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_NO_APPL');
150: IGS_GE_MSG_STACK.ADD;
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF c_acai%FOUND THEN
153: ------------------------------
154: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE
155: -------------------------------

Line 156: IF p_academic_index = FND_API.G_MISS_CHAR THEN

152: ELSIF c_acai%FOUND THEN
153: ------------------------------
154: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE
155: -------------------------------
156: IF p_academic_index = FND_API.G_MISS_CHAR THEN
157: l_academic_index := NULL;
158: ELSE
159: l_academic_index := NVL(p_academic_index, l_appl_inst_rec.academic_index);
160: END IF;

Line 162: IF p_predicted_gpa = FND_API.G_MISS_NUM THEN

158: ELSE
159: l_academic_index := NVL(p_academic_index, l_appl_inst_rec.academic_index);
160: END IF;
161:
162: IF p_predicted_gpa = FND_API.G_MISS_NUM THEN
163: l_predicted_gpa := NULL;
164: ELSE
165: l_predicted_gpa := NVL(p_predicted_gpa, l_appl_inst_rec.predicted_gpa);
166: END IF;

Line 168: IF p_calculation_date = FND_API.G_MISS_DATE THEN

164: ELSE
165: l_predicted_gpa := NVL(p_predicted_gpa, l_appl_inst_rec.predicted_gpa);
166: END IF;
167:
168: IF p_calculation_date = FND_API.G_MISS_DATE THEN
169: l_calculation_date := NULL;
170: ELSE
171: l_calculation_date := NVL(p_calculation_date, l_appl_inst_rec.idx_calc_date);
172: END IF;

Line 320: -- x_return_status := FND_API.G_RET_STS_ERROR;

316: -- END;
317: -- ELSIF c_doc_status%NOTFOUND THEN -- DOC STATUS
318: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'C: No record found with SATISFIED STATUS');
319: -- ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
320: -- x_return_status := FND_API.G_RET_STS_ERROR;
321: -- FND_MESSAGE.SET_NAME('IGS','IGS_AD_DOC_STATUS_INCORRECT');
322: -- IGS_GE_MSG_STACK.ADD;
323: -- RAISE FND_API.G_EXC_ERROR;
324: -- END IF;--IF c_doc_status%NOTFOUND THEN

Line 323: -- RAISE FND_API.G_EXC_ERROR;

319: -- ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
320: -- x_return_status := FND_API.G_RET_STS_ERROR;
321: -- FND_MESSAGE.SET_NAME('IGS','IGS_AD_DOC_STATUS_INCORRECT');
322: -- IGS_GE_MSG_STACK.ADD;
323: -- RAISE FND_API.G_EXC_ERROR;
324: -- END IF;--IF c_doc_status%NOTFOUND THEN
325: -- IF c_doc_status%ISOPEN THEN
326: -- CLOSE c_doc_status;
327: -- END IF ;

Line 334: IF FND_API.To_Boolean( p_commit ) THEN

330: -- IF c_doc_status%ISOPEN THEN
331: -- CLOSE c_doc_status;
332: -- END IF ;
333: -- Standard check of p_commit.
334: IF FND_API.To_Boolean( p_commit ) THEN
335: COMMIT WORK;
336: END IF;
337: -- Standard call to get message count and if count is 1, get message info.
338: EXCEPTION

Line 339: WHEN FND_API.G_EXC_ERROR THEN

335: COMMIT WORK;
336: END IF;
337: -- Standard call to get message count and if count is 1, get message info.
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342: igs_ad_gen_016.extract_msg_from_stack (
343: p_msg_at_index => l_msg_index,

Line 341: x_return_status := FND_API.G_RET_STS_ERROR ;

337: -- Standard call to get message count and if count is 1, get message info.
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO RECORD_ACADEMIC_INDEX_pub;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342: igs_ad_gen_016.extract_msg_from_stack (
343: p_msg_at_index => l_msg_index,
344: p_return_status => l_return_status,
345: p_msg_count => x_msg_count,

Line 350: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);

346: p_msg_data => x_msg_data,
347: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
348: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-2).text;
349: x_msg_count := x_msg_count-1;
350: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);
351: IF c_acai%ISOPEN THEN
352: CLOSE c_acai;
353: END IF;
354: -- IF c_doc_status%ISOPEN THEN

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: -- IF c_doc_status%ISOPEN THEN
355: -- CLOSE c_doc_status;
356: -- END IF ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO RECORD_ACADEMIC_INDEX_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
362: p_data => x_msg_data);

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: -- END IF ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO RECORD_ACADEMIC_INDEX_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
362: p_data => x_msg_data);
363:
364: WHEN OTHERS THEN

Line 373: x_return_status := FND_API.G_RET_STS_ERROR ;

369: p_msg_count => x_msg_count,
370: p_msg_data => x_msg_data,
371: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
372: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
373: x_return_status := FND_API.G_RET_STS_ERROR ;
374: ELSE
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: END IF;
377: IF c_acai%ISOPEN THEN

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
372: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
373: x_return_status := FND_API.G_RET_STS_ERROR ;
374: ELSE
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: END IF;
377: IF c_acai%ISOPEN THEN
378: CLOSE c_acai;
379: END IF;

Line 389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

385:
386:
387:
388: PROCEDURE Record_Outcome_AdmApplication(p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
391: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
392:
393: p_person_id NUMBER,

Line 390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

386:
387:
388: PROCEDURE Record_Outcome_AdmApplication(p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
391: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
392:
393: p_person_id NUMBER,
394: p_admission_appl_number NUMBER,

Line 391: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

387:
388: PROCEDURE Record_Outcome_AdmApplication(p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
390: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
391: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
392:
393: p_person_id NUMBER,
394: p_admission_appl_number NUMBER,
395: p_nominated_program_cd VARCHAR2,

Line 530: IF FND_API.to_Boolean(p_init_msg_list) THEN

526: SAVEPOINT Record_Outcome_AdmAppl_pub;
527: l_msg_index := igs_ge_msg_stack.count_msg;
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean(p_init_msg_list) THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:
534: -- Standard call to check for call compatibility.

Line 535: IF NOT FND_API.Compatible_API_Call(l_api_version,

531: FND_MSG_PUB.initialize;
532: END IF;
533:
534: -- Standard call to check for call compatibility.
535: IF NOT FND_API.Compatible_API_Call(l_api_version,
536: p_api_version,
537: l_api_name,
538: G_PKG_NAME) THEN
539: RAISE FND_API.G_EXC_ERROR;

Line 539: RAISE FND_API.G_EXC_ERROR;

535: IF NOT FND_API.Compatible_API_Call(l_api_version,
536: p_api_version,
537: l_api_name,
538: G_PKG_NAME) THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541:
542:
543: -- Validate all the parameters for their length

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571: check_length('REQ_FOR_RECONSIDERATION_IND', 'IGS_AD_PS_APPL', length(p_reconsider_flag));
572:
573:
574: -- Initialize API return status to success
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: -- API body
577:
578: -- Check whether any application is available in OSS to update outcome status
579: -- if the corresponding application is not there , then update the interface record with appropriate error code

Line 593: RAISE FND_API.G_EXC_ERROR;

589:
590: IF l_c_aplinst_cur.person_id IS NULL THEN
591: fnd_message.set_name('IGS', 'IGS_AD_DECISION_DTLS_INVALID');
592: IGS_GE_MSG_STACK.ADD;
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: ---------------------------------------------------------------
596: -- Start Code to Check and assign the Missing Fields/ Nullified Filelds
597: ---------------------------------------------------------------

Line 598: IF p_adm_outcome_status = FND_API.G_MISS_CHAR OR p_adm_outcome_status IS NULL THEN

594: END IF;
595: ---------------------------------------------------------------
596: -- Start Code to Check and assign the Missing Fields/ Nullified Filelds
597: ---------------------------------------------------------------
598: IF p_adm_outcome_status = FND_API.G_MISS_CHAR OR p_adm_outcome_status IS NULL THEN
599: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
601: IGS_GE_MSG_STACK.ADD;
602: RAISE FND_API.G_EXC_ERROR;

Line 602: RAISE FND_API.G_EXC_ERROR;

598: IF p_adm_outcome_status = FND_API.G_MISS_CHAR OR p_adm_outcome_status IS NULL THEN
599: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OUTCOME_STATUS'));
601: IGS_GE_MSG_STACK.ADD;
602: RAISE FND_API.G_EXC_ERROR;
603: ELSE
604: l_adm_outcome_status := p_adm_outcome_status;
605: END IF;
606: l_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status);

Line 608: IF p_decision_maker_id = FND_API.G_MISS_NUM THEN

604: l_adm_outcome_status := p_adm_outcome_status;
605: END IF;
606: l_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(l_adm_outcome_status);
607:
608: IF p_decision_maker_id = FND_API.G_MISS_NUM THEN
609: l_decision_make_id := null;
610: ELSE
611: l_decision_make_id := NVL( p_decision_maker_id, l_c_aplinst_cur.decision_make_id);
612: END IF;

Line 613: IF p_decision_date = FND_API.G_MISS_DATE THEN

609: l_decision_make_id := null;
610: ELSE
611: l_decision_make_id := NVL( p_decision_maker_id, l_c_aplinst_cur.decision_make_id);
612: END IF;
613: IF p_decision_date = FND_API.G_MISS_DATE THEN
614: l_decision_date := null;
615: ELSE
616: l_decision_date := NVL( p_decision_date, l_c_aplinst_cur.decision_date);
617: END IF;

Line 618: IF p_decision_reason_id = FND_API.G_MISS_NUM THEN

614: l_decision_date := null;
615: ELSE
616: l_decision_date := NVL( p_decision_date, l_c_aplinst_cur.decision_date);
617: END IF;
618: IF p_decision_reason_id = FND_API.G_MISS_NUM THEN
619: l_decision_reason_id := null;
620: ELSE
621: l_decision_reason_id := NVL( p_decision_reason_id, l_c_aplinst_cur.decision_reason_id);
622: END IF;

Line 623: IF p_pending_reason_id = FND_API.G_MISS_NUM THEN

619: l_decision_reason_id := null;
620: ELSE
621: l_decision_reason_id := NVL( p_decision_reason_id, l_c_aplinst_cur.decision_reason_id);
622: END IF;
623: IF p_pending_reason_id = FND_API.G_MISS_NUM THEN
624: l_pending_reason_id := null;
625: ELSE
626: l_pending_reason_id := NVL( p_pending_reason_id, l_c_aplinst_cur.pending_reason_id);
627: END IF;

Line 629: IF p_offer_dt = FND_API.G_MISS_DATE THEN

625: ELSE
626: l_pending_reason_id := NVL( p_pending_reason_id, l_c_aplinst_cur.pending_reason_id);
627: END IF;
628:
629: IF p_offer_dt = FND_API.G_MISS_DATE THEN
630: l_offer_dt := null;
631: ELSIF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
632: l_offer_dt := NVL (NVL( p_offer_dt, l_c_aplinst_cur.offer_dt), SYSDATE);
633: END IF;

Line 634: IF p_offer_response_dt = FND_API.G_MISS_DATE THEN

630: l_offer_dt := null;
631: ELSIF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
632: l_offer_dt := NVL (NVL( p_offer_dt, l_c_aplinst_cur.offer_dt), SYSDATE);
633: END IF;
634: IF p_offer_response_dt = FND_API.G_MISS_DATE THEN
635: l_offer_response_dt := null;
636: ELSE
637: l_offer_response_dt := NVL( p_offer_response_dt, l_c_aplinst_cur.offer_response_dt);
638: END IF;

Line 641: IF p_reconsider_flag = FND_API.G_MISS_CHAR OR p_reconsider_flag NOT IN ('Y', 'N') THEN

637: l_offer_response_dt := NVL( p_offer_response_dt, l_c_aplinst_cur.offer_response_dt);
638: END IF;
639:
640:
641: IF p_reconsider_flag = FND_API.G_MISS_CHAR OR p_reconsider_flag NOT IN ('Y', 'N') THEN
642: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_RECONS_IND'));
644: IGS_GE_MSG_STACK.ADD;
645: RAISE FND_API.G_EXC_ERROR;

Line 645: RAISE FND_API.G_EXC_ERROR;

641: IF p_reconsider_flag = FND_API.G_MISS_CHAR OR p_reconsider_flag NOT IN ('Y', 'N') THEN
642: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_RECONS_IND'));
644: IGS_GE_MSG_STACK.ADD;
645: RAISE FND_API.G_EXC_ERROR;
646: ELSE
647: l_reconsider_flag := NVL(p_reconsider_flag, l_c_aplinst_cur.req_for_reconsideration_ind);
648: END IF;
649:

Line 650: IF p_prpsd_commencement_date = FND_API.G_MISS_DATE OR l_s_adm_outcome_status NOT IN ('OFFER', 'COND-OFFER')THEN

646: ELSE
647: l_reconsider_flag := NVL(p_reconsider_flag, l_c_aplinst_cur.req_for_reconsideration_ind);
648: END IF;
649:
650: IF p_prpsd_commencement_date = FND_API.G_MISS_DATE OR l_s_adm_outcome_status NOT IN ('OFFER', 'COND-OFFER')THEN
651: l_prpsd_commencement_date := NULL;
652: ELSE
653: l_prpsd_commencement_date := NVL(p_prpsd_commencement_date, l_c_aplinst_cur.prpsd_commencement_dt);
654: END IF;

Line 655: IF p_adm_cndtnl_offer_status = FND_API.G_MISS_CHAR THEN

651: l_prpsd_commencement_date := NULL;
652: ELSE
653: l_prpsd_commencement_date := NVL(p_prpsd_commencement_date, l_c_aplinst_cur.prpsd_commencement_dt);
654: END IF;
655: IF p_adm_cndtnl_offer_status = FND_API.G_MISS_CHAR THEN
656: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
658: IGS_GE_MSG_STACK.ADD;
659: RAISE FND_API.G_EXC_ERROR;

Line 659: RAISE FND_API.G_EXC_ERROR;

655: IF p_adm_cndtnl_offer_status = FND_API.G_MISS_CHAR THEN
656: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_COND_OFR_STATUS'));
658: IGS_GE_MSG_STACK.ADD;
659: RAISE FND_API.G_EXC_ERROR;
660: ELSE
661: l_adm_cndtl_offer_status := p_adm_cndtnl_offer_status;
662: END IF;
663:

Line 664: IF p_cndtnl_offer_cndtn = FND_API.G_MISS_CHAR THEN

660: ELSE
661: l_adm_cndtl_offer_status := p_adm_cndtnl_offer_status;
662: END IF;
663:
664: IF p_cndtnl_offer_cndtn = FND_API.G_MISS_CHAR THEN
665: l_cndtnl_offer_cndtn := NULL;
666: ELSE
667: l_cndtnl_offer_cndtn := NVL(p_cndtnl_offer_cndtn, l_c_aplinst_cur.cndtnl_offer_cndtn);
668: END IF;

Line 670: IF p_cndtl_offer_must_stsfd_ind = FND_API.G_MISS_CHAR

666: ELSE
667: l_cndtnl_offer_cndtn := NVL(p_cndtnl_offer_cndtn, l_c_aplinst_cur.cndtnl_offer_cndtn);
668: END IF;
669:
670: IF p_cndtl_offer_must_stsfd_ind = FND_API.G_MISS_CHAR
671: OR p_cndtl_offer_must_stsfd_ind NOT IN ('Y', 'N') THEN
672:
673: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));

Line 676: RAISE FND_API.G_EXC_ERROR;

672:
673: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE_WITH_CTXT');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_CND_OFR_STSFD_IND'));
675: IGS_GE_MSG_STACK.ADD;
676: RAISE FND_API.G_EXC_ERROR;
677: ELSE
678: l_cndtl_offer_must_stsfd_ind :=
679: NVL(p_cndtl_offer_must_stsfd_ind, l_c_aplinst_cur.cndtnl_offer_must_be_stsfd_ind);
680: END IF;

Line 683: IF p_cndtnl_offer_satisfied_dt = FND_API.G_MISS_DATE THEN

679: NVL(p_cndtl_offer_must_stsfd_ind, l_c_aplinst_cur.cndtnl_offer_must_be_stsfd_ind);
680: END IF;
681:
682:
683: IF p_cndtnl_offer_satisfied_dt = FND_API.G_MISS_DATE THEN
684: l_cndtnl_offer_satisfied_dt := NULL;
685: ELSE
686: l_cndtnl_offer_satisfied_dt :=
687: NVL(p_cndtnl_offer_satisfied_dt, l_c_aplinst_cur.cndtnl_offer_satisfied_dt);

Line 690: IF p_adm_outcome_status_auth_dt = FND_API.G_MISS_DATE THEN

686: l_cndtnl_offer_satisfied_dt :=
687: NVL(p_cndtnl_offer_satisfied_dt, l_c_aplinst_cur.cndtnl_offer_satisfied_dt);
688: END IF;
689:
690: IF p_adm_outcome_status_auth_dt = FND_API.G_MISS_DATE THEN
691: l_adm_outcome_status_auth_dt := NULL;
692: ELSE
693: l_adm_outcome_status_auth_dt :=
694: NVL(p_adm_outcome_status_auth_dt, l_c_aplinst_cur.adm_outcome_status_auth_dt);

Line 698: IF p_adm_otcm_status_auth_per_id = FND_API.G_MISS_NUM THEN

694: NVL(p_adm_outcome_status_auth_dt, l_c_aplinst_cur.adm_outcome_status_auth_dt);
695: END IF;
696:
697:
698: IF p_adm_otcm_status_auth_per_id = FND_API.G_MISS_NUM THEN
699: l_adm_otcm_status_auth_per_id := NULL;
700: ELSE
701: l_adm_otcm_status_auth_per_id :=
702: NVL(p_adm_otcm_status_auth_per_id, l_c_aplinst_cur.adm_otcm_status_auth_person_id);

Line 705: IF p_adm_outcome_status_reason = FND_API.G_MISS_CHAR THEN

701: l_adm_otcm_status_auth_per_id :=
702: NVL(p_adm_otcm_status_auth_per_id, l_c_aplinst_cur.adm_otcm_status_auth_person_id);
703: END IF;
704:
705: IF p_adm_outcome_status_reason = FND_API.G_MISS_CHAR THEN
706: l_adm_outcome_status_reason := NULL;
707: ELSE
708: l_adm_outcome_status_reason := NVL(p_adm_outcome_status_reason, l_c_aplinst_cur.adm_outcome_status_reason);
709: END IF;

Line 723: RAISE FND_API.G_EXC_ERROR;

719: l_c_appl_cur.adm_appl_status,
720: v_message_name) = FALSE AND l_reconsider_flag = 'N' THEN
721: FND_MESSAGE.SET_NAME('IGS',v_message_name);
722: IGS_GE_MSG_STACK.ADD;
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725:
726: */
727:

Line 731: <> FND_API.G_MISS_DATE THEN

727:
728: IF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
729: IF l_offer_response_dt IS NULL AND
730: NVL(p_offer_response_dt, TRUNC(SYSDATE) )
731: <> FND_API.G_MISS_DATE THEN
732: l_offer_response_dt := IGS_AD_GEN_007.ADMP_GET_RESP_DT(l_c_aplinst_cur.nominated_course_cd,
733: l_c_aplinst_cur.crv_version_number,
734: l_c_appl_cur.acad_cal_type,
735: l_c_aplinst_cur.location_cd,

Line 749: RAISE FND_API.G_EXC_ERROR;

745:
746: IF l_offer_response_dt IS NULL THEN
747: fnd_message.set_name('IGS', 'IGS_AD_OFR_RESPDT_SET_ODR_ADM');
748: IGS_GE_MSG_STACK.ADD;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751: END IF;
752: END IF;
753:

Line 808: IF (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN

804: APP_EXCEPTION.RAISE_EXCEPTION;
805: END IF;
806:
807: IF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
808: IF (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN
809: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
810: IGS_GE_MSG_STACK.ADD;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF ;

Line 811: RAISE FND_API.G_EXC_ERROR;

807: IF l_s_adm_outcome_status IN ('OFFER', 'COND-OFFER') THEN
808: IF (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN
809: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
810: IGS_GE_MSG_STACK.ADD;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF ;
813: l_pending_reason_id := NULL;
814: ELSIF l_s_adm_outcome_status IN ('PENDING') THEN
815: -- p_offer_dt, p_offer_response_dt, p_decision_maker_id or p_decision_date

Line 817: IF (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)

813: l_pending_reason_id := NULL;
814: ELSIF l_s_adm_outcome_status IN ('PENDING') THEN
815: -- p_offer_dt, p_offer_response_dt, p_decision_maker_id or p_decision_date
816: -- cannot be specified when l_s_adm_outcome_status = PENDING
817: IF (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
818: OR
819: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
820: OR
821: (p_decision_maker_id IS NOT NULL AND NVL(p_decision_maker_id, -1 ) <> FND_API.G_MISS_NUM )

Line 819: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )

815: -- p_offer_dt, p_offer_response_dt, p_decision_maker_id or p_decision_date
816: -- cannot be specified when l_s_adm_outcome_status = PENDING
817: IF (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
818: OR
819: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
820: OR
821: (p_decision_maker_id IS NOT NULL AND NVL(p_decision_maker_id, -1 ) <> FND_API.G_MISS_NUM )
822: OR
823: (p_decision_date IS NOT NULL AND NVL( p_decision_date, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE) THEN

Line 821: (p_decision_maker_id IS NOT NULL AND NVL(p_decision_maker_id, -1 ) <> FND_API.G_MISS_NUM )

817: IF (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
818: OR
819: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
820: OR
821: (p_decision_maker_id IS NOT NULL AND NVL(p_decision_maker_id, -1 ) <> FND_API.G_MISS_NUM )
822: OR
823: (p_decision_date IS NOT NULL AND NVL( p_decision_date, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE) THEN
824: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
825: IGS_GE_MSG_STACK.ADD;

Line 823: (p_decision_date IS NOT NULL AND NVL( p_decision_date, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE) THEN

819: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
820: OR
821: (p_decision_maker_id IS NOT NULL AND NVL(p_decision_maker_id, -1 ) <> FND_API.G_MISS_NUM )
822: OR
823: (p_decision_date IS NOT NULL AND NVL( p_decision_date, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE) THEN
824: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
825: IGS_GE_MSG_STACK.ADD;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;

Line 826: RAISE FND_API.G_EXC_ERROR;

822: OR
823: (p_decision_date IS NOT NULL AND NVL( p_decision_date, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE) THEN
824: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
825: IGS_GE_MSG_STACK.ADD;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828: l_offer_dt := NULL;
829: l_offer_response_dt := NULL;
830: l_decision_reason_id := NULL;

Line 837: (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)

833: ELSE
834: IF
835: -- p_offer_dt, p_offer_response_dt or p_pending_reason_id cannot be specified when
836: -- l_s_adm_outcome_status NOT IN PENDING , OFFER , COND-OFFER
837: (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
838: OR
839: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
840: OR
841: (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN

Line 839: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )

835: -- p_offer_dt, p_offer_response_dt or p_pending_reason_id cannot be specified when
836: -- l_s_adm_outcome_status NOT IN PENDING , OFFER , COND-OFFER
837: (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
838: OR
839: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
840: OR
841: (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN
842: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
843: IGS_GE_MSG_STACK.ADD;

Line 841: (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN

837: (p_offer_dt IS NOT NULL AND NVL(p_offer_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE)
838: OR
839: (p_offer_response_dt IS NOT NULL AND NVL(p_offer_response_dt, TRUNC(SYSDATE) ) <> FND_API.G_MISS_DATE )
840: OR
841: (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN
842: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
843: IGS_GE_MSG_STACK.ADD;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;

Line 844: RAISE FND_API.G_EXC_ERROR;

840: OR
841: (p_pending_reason_id IS NOT NULL AND NVL(p_pending_reason_id, -1) <> FND_API.G_MISS_NUM ) THEN
842: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
843: IGS_GE_MSG_STACK.ADD;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846: l_offer_dt := NULL;
847: l_offer_response_dt := NULL;
848: l_pending_reason_id := NULL;

Line 889: RAISE FND_API.G_EXC_ERROR;

885: IF p_adm_cndtnl_offer_status IS NOT NULL AND
886: igs_ad_gen_007.Admp_Get_Sacos (p_adm_cndtnl_offer_status) <> 'NOT-APPLIC' THEN
887: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
888: IGS_GE_MSG_STACK.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: l_adm_cndtl_offer_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');
892: ELSIF NVL(l_s_adm_outcome_status, 'NONE') = 'COND-OFFER' AND
893: NVL(IGS_AD_GEN_007.ADMP_GET_SACOS(l_adm_cndtl_offer_status),

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR;

1130: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1131:
1132: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1133:
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: ELSE
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: END IF;
1138: RETURN;

Line 1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1132: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1133:
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: ELSE
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: END IF;
1138: RETURN;
1139: END;
1140:

Line 1188: RAISE FND_API.G_EXC_ERROR;

1184: 'Y', -- Perform eligibility check indicator.
1185: v_message_name) = FALSE THEN
1186: FND_MESSAGE.SET_NAME('IGS', v_message_name);
1187: IGS_GE_MSG_STACK.ADD;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190:
1191: -- if we need to run the pre enrollment process for this application,
1192: -- we need to check the apc step and run the pre enrollment process

Line 1211: RAISE FND_API.G_EXC_ERROR;

1207: v_message_name) = FALSE THEN
1208: FND_MESSAGE.SET_NAME('IGS', v_message_name);
1209: IGS_GE_MSG_STACK.ADD;
1210:
1211: RAISE FND_API.G_EXC_ERROR;
1212: END IF;
1213: END IF;
1214:
1215: -- Application Decision got imported successfully

Line 1230: IF FND_API.To_Boolean(p_commit) THEN

1226: p_new_outcome_status => l_adm_outcome_status);
1227: END IF;
1228: -- End of API body.
1229: -- Standard check of p_commit.
1230: IF FND_API.To_Boolean(p_commit) THEN
1231: COMMIT WORK;
1232: END IF;
1233: -- Standard call to get message count and if count is 1, get message info.
1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1236: WHEN FND_API.G_EXC_ERROR THEN

1232: END IF;
1233: -- Standard call to get message count and if count is 1, get message info.
1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,
1240: p_return_status => x_return_status,

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: igs_ad_gen_016.extract_msg_from_stack(p_msg_at_index => l_msg_index,
1240: p_return_status => x_return_status,
1241: p_msg_count => x_msg_count,
1242: p_msg_data => x_msg_data,

Line 1246: x_return_status := FND_API.G_RET_STS_ERROR;

1242: p_msg_data => x_msg_data,
1243: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1244:
1245: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: ELSE
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: END IF;
1250:

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244:
1245: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: ELSE
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: END IF;
1250:
1251: x_msg_data := l_hash_msg_name_text_type_tab( x_msg_count - 2).text;
1252: x_msg_count := x_msg_count - 1;

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1250:
1251: x_msg_data := l_hash_msg_name_text_type_tab( x_msg_count - 2).text;
1252: x_msg_count := x_msg_count - 1;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1258: p_data => x_msg_data);

Line 1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1252: x_msg_count := x_msg_count - 1;
1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1258: p_data => x_msg_data);
1259: WHEN OTHERS THEN
1260: ROLLBACK TO Record_Outcome_AdmAppl_pub;

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: p_msg_data => x_msg_data,
1265: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1266:
1267: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: ELSE
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: END IF;
1272:

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1266:
1267: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: ELSE
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: END IF;
1272:
1273: END Record_Outcome_AdmApplication;
1274:

Line 1694: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1690:
1691: PROCEDURE RECORD_OFFER_RESPONSE(
1692: --Standard Parameters Start
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1695: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1696: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
1697: x_return_status OUT NOCOPY VARCHAR2,
1698: x_msg_count OUT NOCOPY NUMBER,

Line 1695: p_commit IN VARCHAR2 default FND_API.G_FALSE,

1691: PROCEDURE RECORD_OFFER_RESPONSE(
1692: --Standard Parameters Start
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1695: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1696: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
1697: x_return_status OUT NOCOPY VARCHAR2,
1698: x_msg_count OUT NOCOPY NUMBER,
1699: x_msg_data OUT NOCOPY VARCHAR2,

Line 1696: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

1692: --Standard Parameters Start
1693: p_api_version IN NUMBER,
1694: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1695: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1696: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
1697: x_return_status OUT NOCOPY VARCHAR2,
1698: x_msg_count OUT NOCOPY NUMBER,
1699: x_msg_data OUT NOCOPY VARCHAR2,
1700: --Standard parameter ends

Line 1750: x_return_status := FND_API.G_RET_STS_SUCCESS;

1746: x_dummy VARCHAR2(2000);
1747: BEGIN
1748: SAVEPOINT S_RECORD_OFFER_RESPONSE_PUB;
1749: -- Initialize API return status to success
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:
1752: l_msg_index := 0;
1753: --All the standard functionality
1754: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1754: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:
1752: l_msg_index := 0;
1753: --All the standard functionality
1754: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1755: RAISE FND_API.G_EXC_ERROR;

1751:
1752: l_msg_index := 0;
1753: --All the standard functionality
1754: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: -- Initialize message list if p_init_msg_list is set to TRUE.
1759: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1759: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
1758: -- Initialize message list if p_init_msg_list is set to TRUE.
1759: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1760: FND_MSG_PUB.initialize;
1761: END IF;
1762: l_msg_index := igs_ge_msg_stack.count_msg;
1763: --Assign all defaul values

Line 1789: IF p_adm_offer_resp_status = FND_API.G_MISS_CHAR OR p_adm_offer_resp_status IS NULL THEN

1785: p_sequence_number);
1786: FETCH cur_ad_ps_appl_inst INTO cur_ad_ps_appl_inst_rec;
1787: CLOSE cur_ad_ps_appl_inst;
1788:
1789: IF p_adm_offer_resp_status = FND_API.G_MISS_CHAR OR p_adm_offer_resp_status IS NULL THEN
1790: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1791: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
1792: IGS_GE_MSG_STACK.ADD;
1793: RAISE FND_API.G_EXC_ERROR;

Line 1793: RAISE FND_API.G_EXC_ERROR;

1789: IF p_adm_offer_resp_status = FND_API.G_MISS_CHAR OR p_adm_offer_resp_status IS NULL THEN
1790: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1791: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_OFFER_RESP_STATUS'));
1792: IGS_GE_MSG_STACK.ADD;
1793: RAISE FND_API.G_EXC_ERROR;
1794: END IF;
1795:
1796: IF p_actual_response_dt = FND_API.G_MISS_DATE THEN
1797: l_calc_actual_response_dt := null;

Line 1796: IF p_actual_response_dt = FND_API.G_MISS_DATE THEN

1792: IGS_GE_MSG_STACK.ADD;
1793: RAISE FND_API.G_EXC_ERROR;
1794: END IF;
1795:
1796: IF p_actual_response_dt = FND_API.G_MISS_DATE THEN
1797: l_calc_actual_response_dt := null;
1798: END IF;
1799:
1800: IF p_response_comments = FND_API.G_MISS_CHAR THEN

Line 1800: IF p_response_comments = FND_API.G_MISS_CHAR THEN

1796: IF p_actual_response_dt = FND_API.G_MISS_DATE THEN
1797: l_calc_actual_response_dt := null;
1798: END IF;
1799:
1800: IF p_response_comments = FND_API.G_MISS_CHAR THEN
1801: l_response_comments := NULL;
1802: ELSE
1803: l_response_comments := NVL(p_response_comments, cur_ad_ps_appl_inst_rec.applicant_acptnce_cndtn );
1804: END IF;

Line 1806: IF p_def_acad_cal_type = FND_API.G_MISS_CHAR THEN

1802: ELSE
1803: l_response_comments := NVL(p_response_comments, cur_ad_ps_appl_inst_rec.applicant_acptnce_cndtn );
1804: END IF;
1805:
1806: IF p_def_acad_cal_type = FND_API.G_MISS_CHAR THEN
1807: l_def_acad_cal_type := NULL;
1808: ELSE
1809: l_def_acad_cal_type := NVL(p_def_acad_cal_type, cur_ad_ps_appl_inst_rec.def_acad_cal_type );
1810: END IF;

Line 1812: IF p_def_acad_ci_sequence_num = FND_API.G_MISS_NUM THEN

1808: ELSE
1809: l_def_acad_cal_type := NVL(p_def_acad_cal_type, cur_ad_ps_appl_inst_rec.def_acad_cal_type );
1810: END IF;
1811:
1812: IF p_def_acad_ci_sequence_num = FND_API.G_MISS_NUM THEN
1813: l_def_acad_ci_sequence_num := NULL;
1814: ELSE
1815: l_def_acad_ci_sequence_num := NVL(p_def_acad_ci_sequence_num, cur_ad_ps_appl_inst_rec.def_acad_ci_sequence_num );
1816: END IF;

Line 1818: IF p_def_adm_cal_type = FND_API.G_MISS_CHAR THEN

1814: ELSE
1815: l_def_acad_ci_sequence_num := NVL(p_def_acad_ci_sequence_num, cur_ad_ps_appl_inst_rec.def_acad_ci_sequence_num );
1816: END IF;
1817:
1818: IF p_def_adm_cal_type = FND_API.G_MISS_CHAR THEN
1819: l_def_adm_cal_type := NULL;
1820: ELSE
1821: l_def_adm_cal_type := NVL(p_def_adm_cal_type, cur_ad_ps_appl_inst_rec.deferred_adm_cal_type );
1822: END IF;

Line 1824: IF p_def_adm_ci_sequence_num = FND_API.G_MISS_NUM THEN

1820: ELSE
1821: l_def_adm_cal_type := NVL(p_def_adm_cal_type, cur_ad_ps_appl_inst_rec.deferred_adm_cal_type );
1822: END IF;
1823:
1824: IF p_def_adm_ci_sequence_num = FND_API.G_MISS_NUM THEN
1825: l_def_adm_ci_sequence_num := NULL;
1826: ELSE
1827: l_def_adm_ci_sequence_num := NVL(p_def_adm_ci_sequence_num, cur_ad_ps_appl_inst_rec.deferred_adm_ci_sequence_num );
1828: END IF;

Line 1830: IF p_decline_ofr_reason = FND_API.G_MISS_CHAR THEN

1826: ELSE
1827: l_def_adm_ci_sequence_num := NVL(p_def_adm_ci_sequence_num, cur_ad_ps_appl_inst_rec.deferred_adm_ci_sequence_num );
1828: END IF;
1829:
1830: IF p_decline_ofr_reason = FND_API.G_MISS_CHAR THEN
1831: l_decline_ofr_reason := NULL;
1832: ELSE
1833: l_decline_ofr_reason := NVL(p_decline_ofr_reason, cur_ad_ps_appl_inst_rec.decline_ofr_reason );
1834: END IF;

Line 1836: IF p_attent_other_inst_cd = FND_API.G_MISS_CHAR THEN

1832: ELSE
1833: l_decline_ofr_reason := NVL(p_decline_ofr_reason, cur_ad_ps_appl_inst_rec.decline_ofr_reason );
1834: END IF;
1835:
1836: IF p_attent_other_inst_cd = FND_API.G_MISS_CHAR THEN
1837: l_attent_other_inst_cd := NULL;
1838: ELSE
1839: l_attent_other_inst_cd := NVL(p_attent_other_inst_cd, cur_ad_ps_appl_inst_rec.attent_other_inst_cd );
1840: END IF;

Line 2038: RAISE FND_API.G_EXC_ERROR;

2034: 'Y', -- Perform eligibility check indicator.
2035: l_enrl_message_name) = FALSE THEN
2036: FND_MESSAGE.SET_NAME('IGS',l_enrl_message_name);
2037: IGS_GE_MSG_STACK.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040: END IF;
2041:
2042: IF FND_API.To_Boolean( p_commit ) THEN

Line 2042: IF FND_API.To_Boolean( p_commit ) THEN

2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040: END IF;
2041:
2042: IF FND_API.To_Boolean( p_commit ) THEN
2043: COMMIT;
2044: END IF;
2045: ELSE
2046: RAISE FND_API.G_EXC_ERROR;

Line 2046: RAISE FND_API.G_EXC_ERROR;

2042: IF FND_API.To_Boolean( p_commit ) THEN
2043: COMMIT;
2044: END IF;
2045: ELSE
2046: RAISE FND_API.G_EXC_ERROR;
2047: END IF;
2048: --check the outcome status
2049: EXCEPTION
2050: WHEN FND_API.G_EXC_ERROR THEN

Line 2050: WHEN FND_API.G_EXC_ERROR THEN

2046: RAISE FND_API.G_EXC_ERROR;
2047: END IF;
2048: --check the outcome status
2049: EXCEPTION
2050: WHEN FND_API.G_EXC_ERROR THEN
2051:
2052: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2053: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2052: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);

2048: --check the outcome status
2049: EXCEPTION
2050: WHEN FND_API.G_EXC_ERROR THEN
2051:
2052: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2053: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: igs_ad_gen_016.extract_msg_from_stack (
2056: p_msg_at_index => l_msg_index,

Line 2054: x_return_status := FND_API.G_RET_STS_ERROR ;

2050: WHEN FND_API.G_EXC_ERROR THEN
2051:
2052: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2053: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: igs_ad_gen_016.extract_msg_from_stack (
2056: p_msg_at_index => l_msg_index,
2057: p_return_status => l_return_status,
2058: p_msg_count => x_msg_count,

Line 2067: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);

2063: IF cur_ad_ps_appl_inst%ISOPEN THEN
2064: CLOSE cur_ad_ps_appl_inst;
2065: END IF;
2066: WHEN OTHERS THEN
2067: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2068: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2069: x_return_status := FND_API.G_RET_STS_ERROR ;
2070: igs_ad_gen_016.extract_msg_from_stack (
2071: p_msg_at_index => l_msg_index,

Line 2069: x_return_status := FND_API.G_RET_STS_ERROR ;

2065: END IF;
2066: WHEN OTHERS THEN
2067: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in API: FND_API.G_EXC_ERROR : '||SQLERRM);
2068: ROLLBACK TO s_RECORD_OFFER_RESPONSE_pub;
2069: x_return_status := FND_API.G_RET_STS_ERROR ;
2070: igs_ad_gen_016.extract_msg_from_stack (
2071: p_msg_at_index => l_msg_index,
2072: p_return_status => l_return_status,
2073: p_msg_count => x_msg_count,

Line 2084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

2080: END RECORD_OFFER_RESPONSE;
2081:
2082: PROCEDURE RECORD_QUALIFICATION_CODE(
2083: p_api_version IN NUMBER ,
2084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2085: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_validation_level IN NUMBER :=
2087: FND_API.G_VALID_LEVEL_FULL ,
2088: p_person_id IN NUMBER,

Line 2085: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2081:
2082: PROCEDURE RECORD_QUALIFICATION_CODE(
2083: p_api_version IN NUMBER ,
2084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2085: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_validation_level IN NUMBER :=
2087: FND_API.G_VALID_LEVEL_FULL ,
2088: p_person_id IN NUMBER,
2089: p_admission_appl_number IN NUMBER,

Line 2087: FND_API.G_VALID_LEVEL_FULL ,

2083: p_api_version IN NUMBER ,
2084: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
2085: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2086: p_validation_level IN NUMBER :=
2087: FND_API.G_VALID_LEVEL_FULL ,
2088: p_person_id IN NUMBER,
2089: p_admission_appl_number IN NUMBER,
2090: p_nominated_course_cd IN VARCHAR2,
2091: p_sequence_number IN NUMBER,

Line 2158: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

2154: BEGIN
2155: l_msg_index := 0;
2156: SAVEPOINT RECORD_QUALIFICATION_CODE_pub;
2157: -- Standard call to check for call compatibility.
2158: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161:
2162: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2159: RAISE FND_API.G_EXC_ERROR;

2155: l_msg_index := 0;
2156: SAVEPOINT RECORD_QUALIFICATION_CODE_pub;
2157: -- Standard call to check for call compatibility.
2158: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161:
2162: -- Initialize message list if p_init_msg_list is set to TRUE.
2163: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2163: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161:
2162: -- Initialize message list if p_init_msg_list is set to TRUE.
2163: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2164: FND_MSG_PUB.initialize;
2165: END IF;
2166: l_msg_index := igs_ge_msg_stack.count_msg;
2167:

Line 2185: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN

2181: -- P_QUALIFYING_VALUE
2182: check_length('QUALIFYING_VALUE', 'IGS_AD_APPQUAL_CODE', length(p_qualifying_value));
2183: -- END OF PARAMETER VALIDATIONS.
2184:
2185: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
2186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_PERSON_ID');
2188: IGS_GE_MSG_STACK.ADD;
2189: RAISE FND_API.G_EXC_ERROR;

Line 2189: RAISE FND_API.G_EXC_ERROR;

2185: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
2186: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_PERSON_ID');
2188: IGS_GE_MSG_STACK.ADD;
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF;
2191:
2192: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2193: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2192: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN

2188: IGS_GE_MSG_STACK.ADD;
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF;
2191:
2192: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2193: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ADMISSION_APPL_NUMBER');
2195: IGS_GE_MSG_STACK.ADD;
2196: RAISE FND_API.G_EXC_ERROR;

Line 2196: RAISE FND_API.G_EXC_ERROR;

2192: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2193: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ADMISSION_APPL_NUMBER');
2195: IGS_GE_MSG_STACK.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;
2198:
2199: IF p_nominated_course_cd = FND_API.G_MISS_CHAR OR p_nominated_course_cd IS NULL THEN
2200: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2199: IF p_nominated_course_cd = FND_API.G_MISS_CHAR OR p_nominated_course_cd IS NULL THEN

2195: IGS_GE_MSG_STACK.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: END IF;
2198:
2199: IF p_nominated_course_cd = FND_API.G_MISS_CHAR OR p_nominated_course_cd IS NULL THEN
2200: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2201: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_NOMINATED_COURSE_CD');
2202: IGS_GE_MSG_STACK.ADD;
2203: RAISE FND_API.G_EXC_ERROR;

Line 2203: RAISE FND_API.G_EXC_ERROR;

2199: IF p_nominated_course_cd = FND_API.G_MISS_CHAR OR p_nominated_course_cd IS NULL THEN
2200: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2201: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_NOMINATED_COURSE_CD');
2202: IGS_GE_MSG_STACK.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;
2205:
2206: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2206: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN

2202: IGS_GE_MSG_STACK.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;
2205:
2206: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_SEQUENCE_NUMBER');
2209: IGS_GE_MSG_STACK.ADD;
2210: RAISE FND_API.G_EXC_ERROR;

Line 2210: RAISE FND_API.G_EXC_ERROR;

2206: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2207: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2208: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_SEQUENCE_NUMBER');
2209: IGS_GE_MSG_STACK.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END IF;
2212:
2213: IF p_qualifying_type_code = FND_API.G_MISS_CHAR OR p_qualifying_type_code IS NULL THEN
2214: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2213: IF p_qualifying_type_code = FND_API.G_MISS_CHAR OR p_qualifying_type_code IS NULL THEN

2209: IGS_GE_MSG_STACK.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: END IF;
2212:
2213: IF p_qualifying_type_code = FND_API.G_MISS_CHAR OR p_qualifying_type_code IS NULL THEN
2214: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_QUALIFYING_TYPE_CODE');
2216: IGS_GE_MSG_STACK.ADD;
2217: RAISE FND_API.G_EXC_ERROR;

Line 2217: RAISE FND_API.G_EXC_ERROR;

2213: IF p_qualifying_type_code = FND_API.G_MISS_CHAR OR p_qualifying_type_code IS NULL THEN
2214: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_QUALIFYING_TYPE_CODE');
2216: IGS_GE_MSG_STACK.ADD;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;
2219: -- Initialize API return status to success
2220: x_return_status := FND_API.G_RET_STS_SUCCESS;
2221:

Line 2220: x_return_status := FND_API.G_RET_STS_SUCCESS;

2216: IGS_GE_MSG_STACK.ADD;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;
2219: -- Initialize API return status to success
2220: x_return_status := FND_API.G_RET_STS_SUCCESS;
2221:
2222: /* OPEN C_ACAI(p_person_id,
2223: p_admission_appl_number,
2224: p_nominated_course_cd,

Line 2230: x_return_status := FND_API.G_RET_STS_ERROR;

2226: FETCH c_acai INTO l_appl_inst_rec;
2227: IF c_acai%NOTFOUND THEN --If no application instance exists for this application
2228: --with s_adm_outcome_status = 'PENDING'
2229: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_NO_APPL');
2232: IGS_GE_MSG_STACK.ADD;
2233: RAISE FND_API.G_EXC_ERROR;
2234: ELSIF c_acai%FOUND THEN */

Line 2233: RAISE FND_API.G_EXC_ERROR;

2229: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2230: x_return_status := FND_API.G_RET_STS_ERROR;
2231: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ACDX_NO_APPL');
2232: IGS_GE_MSG_STACK.ADD;
2233: RAISE FND_API.G_EXC_ERROR;
2234: ELSIF c_acai%FOUND THEN */
2235: ------------------------------
2236: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE
2237: -------------------------------

Line 2238: IF p_qualifying_type_code = FND_API.G_MISS_CHAR THEN

2234: ELSIF c_acai%FOUND THEN */
2235: ------------------------------
2236: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE
2237: -------------------------------
2238: IF p_qualifying_type_code = FND_API.G_MISS_CHAR THEN
2239: l_qualifying_type_code := NULL;
2240: ELSE
2241: l_qualifying_type_code := p_qualifying_type_code;
2242: END IF;

Line 2244: IF p_qualifying_code = FND_API.G_MISS_CHAR THEN

2240: ELSE
2241: l_qualifying_type_code := p_qualifying_type_code;
2242: END IF;
2243:
2244: IF p_qualifying_code = FND_API.G_MISS_CHAR THEN
2245: l_qualifying_code := NULL;
2246: ELSE
2247: l_qualifying_code := p_qualifying_code;
2248: END IF;

Line 2250: IF p_qualifying_value = FND_API.G_MISS_CHAR THEN

2246: ELSE
2247: l_qualifying_code := p_qualifying_code;
2248: END IF;
2249:
2250: IF p_qualifying_value = FND_API.G_MISS_CHAR THEN
2251: l_qualifying_value := NULL;
2252: ELSE
2253: l_qualifying_value := p_qualifying_value;
2254: END IF;

Line 2270: RAISE FND_API.G_EXC_ERROR;

2266: CLOSE c_qualtype;
2267: FND_MESSAGE.SET_NAME('IGS','IGS_AD_QUAL_TYPE_ERROR');
2268: FND_MESSAGE.SET_TOKEN('QUALIFYING_TYPE',l_qualifying_type_code);
2269: IGS_GE_MSG_STACK.ADD;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272: CLOSE c_qualtype;
2273:
2274: --Check if any qual code is there for current qual type and user is trying to pass qual value.

Line 2278: RAISE FND_API.G_EXC_ERROR;

2274: --Check if any qual code is there for current qual type and user is trying to pass qual value.
2275: IF l_qualifying_value IS NOT NULL AND l_qualifying_code IS NOT NULL THEN
2276: FND_MESSAGE.SET_NAME('IGS','IGS_AD_QUAL_CODE_VAL');
2277: IGS_GE_MSG_STACK.ADD;
2278: RAISE FND_API.G_EXC_ERROR;
2279: END IF;
2280:
2281:
2282: --Check if any qual code is there for current qual type and user is trying to pass qual value.

Line 2288: RAISE FND_API.G_EXC_ERROR;

2284: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DUP_QUAL_CODE');
2285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1','QUALIFYING CODE');
2286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE2','QUALIFYING VALUE');
2287: IGS_GE_MSG_STACK.ADD;
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:
2291: --Check if any qual value is there for current qual type and user is trying to pass qual code.
2292: IF l_qualifying_code IS NOT NULL AND l_qualtype.QUALIFYING_VALUE IS NOT NULL THEN

Line 2297: RAISE FND_API.G_EXC_ERROR;

2293: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DUP_QUAL_CODE');
2294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1','QUALIFYING VALUE');
2295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE2','QUALIFYING CODE');
2296: IGS_GE_MSG_STACK.ADD;
2297: RAISE FND_API.G_EXC_ERROR;
2298: END IF;
2299: --will be done in TBH
2300: IF l_qualifying_code IS NOT NULL THEN
2301: OPEN c_qualcode(l_qualifying_code,l_qualifying_type_code);

Line 2308: RAISE FND_API.G_EXC_ERROR;

2304: IF l_qualcode.code_id IS NULL THEN
2305: FND_MESSAGE.SET_NAME('IGS','IGS_AD_QUAL_CODE_ERROR');
2306: FND_MESSAGE.SET_TOKEN('QUALIFYING_CODE',l_qualifying_code);
2307: IGS_GE_MSG_STACK.ADD;
2308: RAISE FND_API.G_EXC_ERROR;
2309: ELSE
2310: l_code_id := l_qualcode.code_id;
2311: END IF;
2312: END IF;

Line 2319: RAISE FND_API.G_EXC_ERROR;

2315: IF l_code_id = l_qualtype.qualifying_code_id THEN
2316: FND_MESSAGE.SET_NAME('IGS','IGS_AD_QUAL_EXISTS');
2317: FND_MESSAGE.SET_TOKEN('QUALIFYING_CODE',l_qualifying_code);
2318: IGS_GE_MSG_STACK.ADD;
2319: RAISE FND_API.G_EXC_ERROR;
2320: END IF;
2321:
2322: --Check if any qual code is already exists.
2323: IF l_qualifying_value = l_qualtype.qualifying_value THEN

Line 2327: RAISE FND_API.G_EXC_ERROR;

2323: IF l_qualifying_value = l_qualtype.qualifying_value THEN
2324: FND_MESSAGE.SET_NAME('IGS','IGS_AD_QUAL_VAL_EXISTS');
2325: FND_MESSAGE.SET_TOKEN('QUALIFYING_VALUE',l_qualifying_value);
2326: IGS_GE_MSG_STACK.ADD;
2327: RAISE FND_API.G_EXC_ERROR;
2328: END IF;
2329: --Call TBH
2330: igs_ad_appqual_code_pkg.UPDATE_ROW(
2331: x_rowid => l_qualtype.rowid,

Line 2342: IF FND_API.To_Boolean( p_commit ) THEN

2338: x_qualifying_value => l_qualifying_value,
2339: x_mode => 'R'
2340: );
2341:
2342: IF FND_API.To_Boolean( p_commit ) THEN
2343: COMMIT WORK;
2344: END IF;
2345: -- Standard call to get message count and if count is 1, get message info.
2346: EXCEPTION

Line 2347: WHEN FND_API.G_EXC_ERROR THEN

2343: COMMIT WORK;
2344: END IF;
2345: -- Standard call to get message count and if count is 1, get message info.
2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: igs_ad_gen_016.extract_msg_from_stack (
2351: p_msg_at_index => l_msg_index,

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR ;

2345: -- Standard call to get message count and if count is 1, get message info.
2346: EXCEPTION
2347: WHEN FND_API.G_EXC_ERROR THEN
2348: ROLLBACK TO RECORD_QUALIFICATION_CODE_pub;
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: igs_ad_gen_016.extract_msg_from_stack (
2351: p_msg_at_index => l_msg_index,
2352: p_return_status => l_return_status,
2353: p_msg_count => x_msg_count,

Line 2370: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);

2366: FND_MSG_PUB.ADD;
2367: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count - 1).text;
2368: END IF;
2369:
2370: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);
2371: IF c_acai%ISOPEN THEN
2372: CLOSE c_acai;
2373: END IF;
2374:

Line 2375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2371: IF c_acai%ISOPEN THEN
2372: CLOSE c_acai;
2373: END IF;
2374:
2375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2376: ROLLBACK TO RECORD_QUALIFICATION_CODE_PUB;
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2379: p_data => x_msg_data);

Line 2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2373: END IF;
2374:
2375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2376: ROLLBACK TO RECORD_QUALIFICATION_CODE_PUB;
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: WHEN OTHERS THEN

Line 2390: x_return_status := FND_API.G_RET_STS_ERROR ;

2386: p_msg_count => x_msg_count,
2387: p_msg_data => x_msg_data,
2388: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2389: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
2390: x_return_status := FND_API.G_RET_STS_ERROR ;
2391: ELSE
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: END IF;
2394: IF c_acai%ISOPEN THEN

Line 2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2388: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2389: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
2390: x_return_status := FND_API.G_RET_STS_ERROR ;
2391: ELSE
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2393: END IF;
2394: IF c_acai%ISOPEN THEN
2395: CLOSE c_acai;
2396: END IF;

Line 2403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2399:
2400: PROCEDURE UPDATE_ENTRY_QUAL_STATUS(
2401: --Standard Parameters Start
2402: p_api_version IN NUMBER,
2403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,

Line 2404: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2400: PROCEDURE UPDATE_ENTRY_QUAL_STATUS(
2401: --Standard Parameters Start
2402: p_api_version IN NUMBER,
2403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,
2408: x_msg_data OUT NOCOPY VARCHAR2,

Line 2405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2401: --Standard Parameters Start
2402: p_api_version IN NUMBER,
2403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2406: x_return_status OUT NOCOPY VARCHAR2,
2407: x_msg_count OUT NOCOPY NUMBER,
2408: x_msg_data OUT NOCOPY VARCHAR2,
2409: --Standard parameter ends

Line 2461: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

2457: l_msg_index := 0;
2458: SAVEPOINT UPDATE_ENTRY_QUAL_STATUS_SAVE;
2459:
2460: -- Standard call to check for call compatibility.
2461: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF;
2464: -- Initialize message list if p_init_msg_list is set to TRUE.
2465: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2462: RAISE FND_API.G_EXC_ERROR;

2458: SAVEPOINT UPDATE_ENTRY_QUAL_STATUS_SAVE;
2459:
2460: -- Standard call to check for call compatibility.
2461: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF;
2464: -- Initialize message list if p_init_msg_list is set to TRUE.
2465: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2466: FND_MSG_PUB.initialize;

Line 2465: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2461: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
2462: RAISE FND_API.G_EXC_ERROR;
2463: END IF;
2464: -- Initialize message list if p_init_msg_list is set to TRUE.
2465: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2466: FND_MSG_PUB.initialize;
2467: END IF;
2468: l_msg_index := igs_ge_msg_stack.count_msg;
2469:

Line 2491: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN

2487: -- end of parameter validations.
2488:
2489: -- Show appropriate message when the parameter values are missing
2490:
2491: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
2492: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_PERSON_ID');
2494: IGS_GE_MSG_STACK.ADD;
2495: RAISE FND_API.G_EXC_ERROR;

Line 2495: RAISE FND_API.G_EXC_ERROR;

2491: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
2492: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_PERSON_ID');
2494: IGS_GE_MSG_STACK.ADD;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497:
2498: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2499: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2498: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN

2494: IGS_GE_MSG_STACK.ADD;
2495: RAISE FND_API.G_EXC_ERROR;
2496: END IF;
2497:
2498: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2499: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2500: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ADMISSION_APPL_NUMBER');
2501: IGS_GE_MSG_STACK.ADD;
2502: RAISE FND_API.G_EXC_ERROR;

Line 2502: RAISE FND_API.G_EXC_ERROR;

2498: IF p_admission_appl_number = FND_API.G_MISS_NUM OR p_admission_appl_number IS NULL THEN
2499: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2500: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ADMISSION_APPL_NUMBER');
2501: IGS_GE_MSG_STACK.ADD;
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2505: IF p_nominated_program_cd = FND_API.G_MISS_CHAR OR p_nominated_program_cd IS NULL THEN
2506: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2505: IF p_nominated_program_cd = FND_API.G_MISS_CHAR OR p_nominated_program_cd IS NULL THEN

2501: IGS_GE_MSG_STACK.ADD;
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2505: IF p_nominated_program_cd = FND_API.G_MISS_CHAR OR p_nominated_program_cd IS NULL THEN
2506: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2507: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_NOMINATED_PROGRAM_CD');
2508: IGS_GE_MSG_STACK.ADD;
2509: RAISE FND_API.G_EXC_ERROR;

Line 2509: RAISE FND_API.G_EXC_ERROR;

2505: IF p_nominated_program_cd = FND_API.G_MISS_CHAR OR p_nominated_program_cd IS NULL THEN
2506: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2507: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_NOMINATED_PROGRAM_CD');
2508: IGS_GE_MSG_STACK.ADD;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511:
2512: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2513: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2512: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN

2508: IGS_GE_MSG_STACK.ADD;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511:
2512: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2513: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_SEQUENCE_NUMBER');
2515: IGS_GE_MSG_STACK.ADD;
2516: RAISE FND_API.G_EXC_ERROR;

Line 2516: RAISE FND_API.G_EXC_ERROR;

2512: IF p_sequence_number = FND_API.G_MISS_NUM OR p_sequence_number IS NULL THEN
2513: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_SEQUENCE_NUMBER');
2515: IGS_GE_MSG_STACK.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: IF p_entry_qual_status = FND_API.G_MISS_CHAR OR p_entry_qual_status IS NULL THEN
2520: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

Line 2519: IF p_entry_qual_status = FND_API.G_MISS_CHAR OR p_entry_qual_status IS NULL THEN

2515: IGS_GE_MSG_STACK.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: IF p_entry_qual_status = FND_API.G_MISS_CHAR OR p_entry_qual_status IS NULL THEN
2520: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ENTRY_QUAL_STATUS');
2522: IGS_GE_MSG_STACK.ADD;
2523: RAISE FND_API.G_EXC_ERROR;

Line 2523: RAISE FND_API.G_EXC_ERROR;

2519: IF p_entry_qual_status = FND_API.G_MISS_CHAR OR p_entry_qual_status IS NULL THEN
2520: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
2521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_ENTRY_QUAL_STATUS');
2522: IGS_GE_MSG_STACK.ADD;
2523: RAISE FND_API.G_EXC_ERROR;
2524: END IF;
2525:
2526:
2527: -- Initialize API return status to success

Line 2528: x_return_status := FND_API.G_RET_STS_SUCCESS;

2524: END IF;
2525:
2526:
2527: -- Initialize API return status to success
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529:
2530:
2531: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE
2532: l_entry_qual_status := p_entry_qual_status;

Line 2543: RAISE FND_API.G_EXC_ERROR;

2539:
2540: IF l_appl_inst_rec.person_id IS NULL THEN
2541: fnd_message.set_name('IGS', 'IGS_AD_INVALID_PARAM_COMB');
2542: IGS_GE_MSG_STACK.ADD;
2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF ;
2545:
2546: -- Open the cursor c_appl to fetch the system admission process type for the application
2547: OPEN c_appl(p_person_id, p_admission_appl_number);

Line 2560: RAISE FND_API.G_EXC_ERROR;

2556: l_s_admission_process_type,
2557: v_message_name) = FALSE THEN
2558: fnd_message.set_name('IGS', v_message_name);
2559: IGS_GE_MSG_STACK.ADD;
2560: RAISE FND_API.G_EXC_ERROR;
2561: END IF;
2562:
2563: -- Update the application instance record with the new value of entry qualification status
2564: igs_ad_ps_appl_inst_pkg.UPDATE_ROW (

Line 2698: IF FND_API.To_Boolean( p_commit ) THEN

2694: x_ais_reason => l_appl_inst_rec.ais_reason,
2695: x_decline_ofr_reason => l_appl_inst_rec.decline_ofr_reason);
2696:
2697: -- Standard check of p_commit.
2698: IF FND_API.To_Boolean( p_commit ) THEN
2699: COMMIT WORK;
2700: END IF;
2701:
2702:

Line 2704: WHEN FND_API.G_EXC_ERROR THEN

2700: END IF;
2701:
2702:
2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705:
2706: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708:

Line 2707: x_return_status := FND_API.G_RET_STS_ERROR;

2703: EXCEPTION
2704: WHEN FND_API.G_EXC_ERROR THEN
2705:
2706: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708:
2709: igs_ad_gen_016.extract_msg_from_stack (
2710: p_msg_at_index => l_msg_index,
2711: p_return_status => l_return_status,

Line 2731: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);

2727: FND_MSG_PUB.ADD;
2728: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count - 1).text;
2729: END IF;
2730:
2731: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'aFTER STACK Exception in API: FND_API.G_EXC_ERROR : '|| l_hash_msg_name_text_type_tab(x_msg_count-2).text);
2732: IF c_acai%ISOPEN THEN
2733: CLOSE c_acai;
2734: END IF;
2735:

Line 2741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2737: CLOSE c_acai;
2738: END IF;
2739:
2740:
2741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2742:
2743: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2740:
2741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2742:
2743: ROLLBACK TO UPDATE_ENTRY_QUAL_STATUS_SAVE;
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2746:
2747:
2748: WHEN OTHERS THEN

Line 2759: x_return_status := FND_API.G_RET_STS_ERROR ;

2755: p_msg_data => x_msg_data,
2756: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2757:
2758: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
2759: x_return_status := FND_API.G_RET_STS_ERROR ;
2760: ELSE
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: END IF;
2763:

Line 2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2757:
2758: IF l_hash_msg_name_text_type_tab(x_msg_count-1).name <> 'ORA' THEN
2759: x_return_status := FND_API.G_RET_STS_ERROR ;
2760: ELSE
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: END IF;
2763:
2764: IF c_acai%ISOPEN THEN
2765: CLOSE c_acai;