[Home] [Help]
42: END check_length;
43:
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,
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
55: p_person_id IN NUMBER,
56: p_admission_appl_number IN NUMBER,
57: p_nominated_program_cd IN VARCHAR2,
58: p_sequence_number IN NUMBER,
103: l_calculation_date DATE;
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:
329: CLOSE c_acai;
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.
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
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 ;
521:
522:
523: BEGIN
524:
525: -- Standard Start of API savepoint
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.
535: IF NOT FND_API.Compatible_API_Call(l_api_version,
536: p_api_version,
537: l_api_name,
538: G_PKG_NAME) THEN
1225: p_old_outcome_status => l_c_aplinst_cur.adm_outcome_status,
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.
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);
1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: ROLLBACK TO Record_Outcome_AdmAppl_pub;
1688: END IF;
1689: END validate_off_resp_dtls;
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,
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
1701: p_person_id IN NUMBER,
1702: p_admission_appl_number IN NUMBER,
1703: p_nominated_program_cd IN VARCHAR2,
1704: p_sequence_number IN NUMBER,
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
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF;
1757:
2153:
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:
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
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 ;
2397: END RECORD_QUALIFICATION_CODE;
2398:
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,
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
2410: p_person_id IN NUMBER,
2411: p_admission_appl_number IN NUMBER,
2412: p_nominated_program_cd IN VARCHAR2,
2413: p_sequence_number IN NUMBER,
2456: BEGIN
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.
2693: x_appl_inst_status => l_appl_inst_rec.appl_inst_status,
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: