90:
91: BEGIN
92:
93: l_api_version := 1.0;
94: l_init_msg_list := FND_API.G_FALSE;
95: l_commit := FND_API.G_FALSE;
96: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
97:
98:
91: BEGIN
92:
93: l_api_version := 1.0;
94: l_init_msg_list := FND_API.G_FALSE;
95: l_commit := FND_API.G_FALSE;
96: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
97:
98:
99: -- set the multi org id
92:
93: l_api_version := 1.0;
94: l_init_msg_list := FND_API.G_FALSE;
95: l_commit := FND_API.G_FALSE;
96: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
97:
98:
99: -- set the multi org id
100: igs_ge_gen_003.set_org_id (p_org_id);
134: p_academic_index => c_acai_inst_rec.admission_index,
135: p_calculation_date => c_acai_inst_rec.calculation_date
136: );
137: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '4: just after calling API.Return status :='||l_return_status);
138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: -- error out the record
140: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '5: If Return status ='||FND_API.G_RET_STS_ERROR||l_msg_data);
141: update_int_table('3','E005',c_acai_inst_rec.acadindex_id,l_msg_data);
142: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
136: );
137: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '4: just after calling API.Return status :='||l_return_status);
138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: -- error out the record
140: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '5: If Return status ='||FND_API.G_RET_STS_ERROR||l_msg_data);
141: update_int_table('3','E005',c_acai_inst_rec.acadindex_id,l_msg_data);
142: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '6: If Return status ='||FND_API.G_RET_STS_UNEXP_ERROR);
144: update_int_table('3','E004',c_acai_inst_rec.acadindex_id,'IGS_GE_UNHANDLED_EXCEPTION');
138: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
139: -- error out the record
140: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '5: If Return status ='||FND_API.G_RET_STS_ERROR||l_msg_data);
141: update_int_table('3','E005',c_acai_inst_rec.acadindex_id,l_msg_data);
142: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '6: If Return status ='||FND_API.G_RET_STS_UNEXP_ERROR);
144: update_int_table('3','E004',c_acai_inst_rec.acadindex_id,'IGS_GE_UNHANDLED_EXCEPTION');
145: ELSE -- Delete the successful record from Interface Table
146: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '7: If Return status = success then delete the record');
139: -- error out the record
140: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '5: If Return status ='||FND_API.G_RET_STS_ERROR||l_msg_data);
141: update_int_table('3','E005',c_acai_inst_rec.acadindex_id,l_msg_data);
142: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '6: If Return status ='||FND_API.G_RET_STS_UNEXP_ERROR);
144: update_int_table('3','E004',c_acai_inst_rec.acadindex_id,'IGS_GE_UNHANDLED_EXCEPTION');
145: ELSE -- Delete the successful record from Interface Table
146: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '7: If Return status = success then delete the record');
147: DELETE igs_ad_acad_idx_int_all