APPS.OKC_STATUS_CHANGE_PVT dependencies on OKC_API

Line 98: x_return_status := OKC_API.G_RET_STS_SUCCESS;

94: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
95: BEGIN
96:
97: -- initialize return status
98: x_return_status := OKC_API.G_RET_STS_SUCCESS;
99:
100: -- assign/populate contract header id
101: l_cvmv_rec.chr_id := p_chr_id;
102: OKC_CVM_PVT.update_row(

Line 115: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

111: return (x_return_status);
112: EXCEPTION
113: when OTHERS then
114: -- notify caller of an error
115: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
116:
117: -- store SQL error message on message stack
118: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
119: p_msg_name => g_unexpected_error,

Line 118: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

114: -- notify caller of an error
115: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
116:
117: -- store SQL error message on message stack
118: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
119: p_msg_name => g_unexpected_error,
120: p_token1 => g_sqlcode_token,
121: p_token1_value => sqlcode,
122: p_token2 => g_sqlerrm_token,

Line 137: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
135: x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type) IS
136:
137: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
138:
139: BEGIN
140: x_return_status := OKC_API.G_RET_STS_SUCCESS;
141: x_chrv_rec := p_chrv_rec;

Line 140: x_return_status := OKC_API.G_RET_STS_SUCCESS;

136:
137: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
138:
139: BEGIN
140: x_return_status := OKC_API.G_RET_STS_SUCCESS;
141: x_chrv_rec := p_chrv_rec;
142: UPDATE OKC_K_HEADERS_B
143: SET STS_CODE = p_chrv_rec.sts_code,
144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 160: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

156:
157: OKC_CTC_PVT.update_contact_stecode(p_chr_id => p_chrv_rec.id,
158: x_return_status=>l_return_status);
159:
160: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF;
164:

Line 161: RAISE OKC_API.G_EXCEPTION_ERROR;

157: OKC_CTC_PVT.update_contact_stecode(p_chr_id => p_chrv_rec.id,
158: x_return_status=>l_return_status);
159:
160: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
161: RAISE OKC_API.G_EXCEPTION_ERROR;
162: END IF;
163: END IF;
164:
165:

Line 194: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

190: p_k_pre_sts_type => p_chrv_rec.old_ste_code,
191: p_k_source_system_code => p_chrv_rec.ORIG_SYSTEM_SOURCE_CODE);
192: End If;
193: -- Update minor version
194: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
195: x_return_status := Update_Minor_Version(p_chrv_rec.id);
196:
197: End If;
198: exception

Line 201: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

197: End If;
198: exception
199: when OTHERS then
200: -- store SQL error message on message stack
201: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
202: p_msg_name => g_unexpected_error,
203: p_token1 => g_sqlcode_token,
204: p_token1_value => sqlcode,
205: p_token2 => g_sqlerrm_token,

Line 209: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

205: p_token2 => g_sqlerrm_token,
206: p_token2_value => sqlerrm);
207:
208: -- notify caller of an UNEXPETED error
209: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
210: END update_contract_header;
211:
212: PROCEDURE update_contract_line(
213: p_api_version IN NUMBER,

Line 228: x_return_status := OKC_API.G_RET_STS_SUCCESS;

224: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contract_Line';
225:
226: BEGIN
227:
228: x_return_status := OKC_API.G_RET_STS_SUCCESS;
229: x_clev_rec := p_clev_rec;
230: UPDATE OKC_K_LINES_B
231: SET STS_CODE = p_clev_rec.sts_code,
232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 270: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then

266: p_kl_source_system_code => p_clev_rec.ORIG_SYSTEM_SOURCE_CODE);
267: End If;
268:
269: -- Update minor version
270: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
271: If p_update_minor_version ='Y' Then
272: x_return_status := Update_Minor_Version(p_clev_rec.dnz_chr_id);
273:
274: End If;

Line 280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

276: exception
277: when OTHERS then
278:
279: -- store SQL error message on message stack
280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
281: p_msg_name => g_unexpected_error,
282: p_token1 => g_sqlcode_token,
283: p_token1_value => sqlcode,
284: p_token2 => g_sqlerrm_token,

Line 288: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

284: p_token2 => g_sqlerrm_token,
285: p_token2_value => sqlerrm);
286:
287: -- notify caller of an UNEXPETED error
288: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
289: END update_contract_line;
290: -----------------------------------------------------------------
291: -- Begin LINE Status change procedure
292: -----------------------------------------------------------------

Line 354: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

350: C number := 0;
351:
352: l_knum_and_mod VARCHAR2(240) := p_k_num||' '||p_k_num_mod;
353: l_line_number VARCHAR2(150);
354: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
355: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
356: x_msg_count NUMBER := okc_api.g_miss_num;
357: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
358:

Line 355: p_init_msg_list VARCHAR2(200) := okc_api.g_true;

351:
352: l_knum_and_mod VARCHAR2(240) := p_k_num||' '||p_k_num_mod;
353: l_line_number VARCHAR2(150);
354: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
355: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
356: x_msg_count NUMBER := okc_api.g_miss_num;
357: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
358:
359: l_cle_rec okc_contract_pub.clev_rec_type;

Line 356: x_msg_count NUMBER := okc_api.g_miss_num;

352: l_knum_and_mod VARCHAR2(240) := p_k_num||' '||p_k_num_mod;
353: l_line_number VARCHAR2(150);
354: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
355: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
356: x_msg_count NUMBER := okc_api.g_miss_num;
357: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
358:
359: l_cle_rec okc_contract_pub.clev_rec_type;
360: x_cle_rec okc_contract_pub.clev_rec_type;

Line 357: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;

353: l_line_number VARCHAR2(150);
354: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
355: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
356: x_msg_count NUMBER := okc_api.g_miss_num;
357: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
358:
359: l_cle_rec okc_contract_pub.clev_rec_type;
360: x_cle_rec okc_contract_pub.clev_rec_type;
361:

Line 1129: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1125: c := 0;
1126: end if;
1127: savepoint H_STATUS;
1128: p_line_count:= p_line_count + 1;
1129: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1130: l_knum_and_mod := p_term_line_rec.contract_number||' '||p_term_line_rec.contract_number_modifier;
1131: l_new_status := null;
1132: l_new_status_m := null;
1133: l_line_number := p_term_line_rec.line_number;

Line 1173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1169: x_msg_count => x_msg_count,
1170: x_msg_data => x_msg_data,
1171: p_clev_rec => l_cle_rec);
1172:
1173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: raise OKC_API.G_EXCEPTION_ERROR;
1177: END IF;

Line 1174: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1170: x_msg_data => x_msg_data,
1171: p_clev_rec => l_cle_rec);
1172:
1173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: raise OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:

Line 1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1171: p_clev_rec => l_cle_rec);
1172:
1173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: raise OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: update_contract_line (

Line 1176: raise OKC_API.G_EXCEPTION_ERROR;

1172:
1173: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: raise OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: update_contract_line (
1180: p_api_version => 1.0,

Line 1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1187: x_msg_data => x_msg_data,
1188: p_clev_rec => l_cle_rec,
1189: x_clev_rec => x_cle_rec);
1190:
1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1192: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1194: raise OKC_API.G_EXCEPTION_ERROR;
1195: END IF;

Line 1192: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1188: p_clev_rec => l_cle_rec,
1189: x_clev_rec => x_cle_rec);
1190:
1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1192: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1194: raise OKC_API.G_EXCEPTION_ERROR;
1195: END IF;
1196:

Line 1193: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1189: x_clev_rec => x_cle_rec);
1190:
1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1192: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1194: raise OKC_API.G_EXCEPTION_ERROR;
1195: END IF;
1196:
1197:

Line 1194: raise OKC_API.G_EXCEPTION_ERROR;

1190:
1191: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1192: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1193: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1194: raise OKC_API.G_EXCEPTION_ERROR;
1195: END IF;
1196:
1197:
1198: OKC_KL_TERM_ASMBLR_PVT.acn_assemble(

Line 1215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1211: p_k_subclass => p_scs_code,
1212: P_KL_STATUS_CODE => p_term_line_rec.STS_CODE,
1213: p_estimated_amount => p_term_line_rec.price_negotiated );
1214: --
1215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1216: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1218: raise OKC_API.G_EXCEPTION_ERROR;
1219: END IF;

Line 1216: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1212: P_KL_STATUS_CODE => p_term_line_rec.STS_CODE,
1213: p_estimated_amount => p_term_line_rec.price_negotiated );
1214: --
1215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1216: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1218: raise OKC_API.G_EXCEPTION_ERROR;
1219: END IF;
1220:

Line 1217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1213: p_estimated_amount => p_term_line_rec.price_negotiated );
1214: --
1215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1216: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1218: raise OKC_API.G_EXCEPTION_ERROR;
1219: END IF;
1220:
1221: OKC_TIME_RES_PUB.res_time_termnt_k(

Line 1218: raise OKC_API.G_EXCEPTION_ERROR;

1214: --
1215: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1216: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1217: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1218: raise OKC_API.G_EXCEPTION_ERROR;
1219: END IF;
1220:
1221: OKC_TIME_RES_PUB.res_time_termnt_k(
1222: P_CHR_ID => NULL,

Line 1229: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1225: P_API_VERSION => 1.0 ,
1226: p_init_msg_list => p_init_msg_list,
1227: x_return_status => l_return_status
1228: );
1229: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1230: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1232: raise OKC_API.G_EXCEPTION_ERROR;
1233: END IF;

Line 1230: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1226: p_init_msg_list => p_init_msg_list,
1227: x_return_status => l_return_status
1228: );
1229: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1230: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1232: raise OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: --

Line 1231: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1227: x_return_status => l_return_status
1228: );
1229: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1230: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1232: raise OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: --
1235: if p_kid is NULL then

Line 1232: raise OKC_API.G_EXCEPTION_ERROR;

1228: );
1229: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1230: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1232: raise OKC_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: --
1235: if p_kid is NULL then
1236: c := c+1;

Line 1248: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1244: end if;
1245:
1246:
1247: EXCEPTION
1248: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1249: line_message(p_knum_and_mod =>l_knum_and_mod,
1250: p_line_number=>l_line_number,
1251: p_old_status =>p_term_line_rec.meaning,
1252: p_status =>l_new_status,

Line 1256: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1252: p_status =>l_new_status,
1253: p_msg_data => x_msg_data,
1254: p_type =>'U');
1255: p_line_errors := p_line_errors +1 ;
1256: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1257: rollback to H_STATUS;
1258: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1259: line_message(p_knum_and_mod =>l_knum_and_mod,
1260: p_line_number=>l_line_number,

Line 1258: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1254: p_type =>'U');
1255: p_line_errors := p_line_errors +1 ;
1256: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1257: rollback to H_STATUS;
1258: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1259: line_message(p_knum_and_mod =>l_knum_and_mod,
1260: p_line_number=>l_line_number,
1261: p_old_status =>p_term_line_rec.meaning,
1262: p_status =>l_new_status,

Line 1266: x_return_status := OKC_API.G_RET_STS_ERROR;

1262: p_status =>l_new_status,
1263: p_msg_data => x_msg_data,
1264: p_type =>'E');
1265: p_line_errors := p_line_errors +1 ;
1266: x_return_status := OKC_API.G_RET_STS_ERROR;
1267: rollback to H_STATUS;
1268: WHEN OTHERS then
1269: line_message(p_knum_and_mod =>l_knum_and_mod,
1270: p_line_number=>l_line_number,

Line 1276: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1272: p_status =>l_new_status,
1273: p_msg_data => x_msg_data,
1274: p_type =>'U');
1275: p_line_errors := p_line_errors +1 ;
1276: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1277: rollback to H_STATUS;
1278: END line_terminate;
1279:
1280: PROCEDURE line_expire(p_exp_line_rec IN line_rec_type) IS

Line 1289: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1285: c := 0;
1286: end if;
1287: savepoint H_STATUS;
1288: p_line_count:= p_line_count + 1;
1289: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1290: l_knum_and_mod := p_exp_line_rec.contract_number||' '||p_exp_line_rec.contract_number_modifier;
1291: l_new_status := null;
1292: l_new_status_m := null;
1293:

Line 1335: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1331: x_msg_data => x_msg_data,
1332: p_clev_rec => l_cle_rec);
1333:
1334:
1335: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1338: raise OKC_API.G_EXCEPTION_ERROR;
1339: END IF;

Line 1336: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1332: p_clev_rec => l_cle_rec);
1333:
1334:
1335: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1338: raise OKC_API.G_EXCEPTION_ERROR;
1339: END IF;
1340: --

Line 1337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1333:
1334:
1335: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1338: raise OKC_API.G_EXCEPTION_ERROR;
1339: END IF;
1340: --
1341:

Line 1338: raise OKC_API.G_EXCEPTION_ERROR;

1334:
1335: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1336: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1337: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1338: raise OKC_API.G_EXCEPTION_ERROR;
1339: END IF;
1340: --
1341:
1342: update_contract_line(

Line 1355: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1351: p_clev_rec => l_cle_rec,
1352: x_clev_rec => x_cle_rec);
1353:
1354:
1355: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1356: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1358: raise OKC_API.G_EXCEPTION_ERROR;
1359: END IF;

Line 1356: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1352: x_clev_rec => x_cle_rec);
1353:
1354:
1355: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1356: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1358: raise OKC_API.G_EXCEPTION_ERROR;
1359: END IF;
1360: --

Line 1357: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1353:
1354:
1355: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1356: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1358: raise OKC_API.G_EXCEPTION_ERROR;
1359: END IF;
1360: --
1361: if p_kid is NULL then

Line 1358: raise OKC_API.G_EXCEPTION_ERROR;

1354:
1355: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1356: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1357: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1358: raise OKC_API.G_EXCEPTION_ERROR;
1359: END IF;
1360: --
1361: if p_kid is NULL then
1362: c := c+1;

Line 1374: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1370: p_type =>'S');
1371: end if;
1372:
1373: EXCEPTION
1374: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1375: line_message(p_knum_and_mod =>l_knum_and_mod,
1376: p_line_number=>l_line_number,
1377: p_status =>l_new_status,
1378: p_old_status =>p_exp_line_rec.meaning,

Line 1382: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1378: p_old_status =>p_exp_line_rec.meaning,
1379: p_msg_data => x_msg_data,
1380: p_type =>'U');
1381: p_line_errors := p_line_errors +1 ;
1382: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1383: rollback to H_STATUS;
1384: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1385: line_message(p_knum_and_mod =>l_knum_and_mod,
1386: p_line_number=>l_line_number,

Line 1384: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1380: p_type =>'U');
1381: p_line_errors := p_line_errors +1 ;
1382: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1383: rollback to H_STATUS;
1384: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1385: line_message(p_knum_and_mod =>l_knum_and_mod,
1386: p_line_number=>l_line_number,
1387: p_status =>l_new_status,
1388: p_old_status =>p_exp_line_rec.meaning,

Line 1392: x_return_status := OKC_API.G_RET_STS_ERROR;

1388: p_old_status =>p_exp_line_rec.meaning,
1389: p_msg_data => x_msg_data,
1390: p_type =>'E');
1391: p_line_errors := p_line_errors +1 ;
1392: x_return_status := OKC_API.G_RET_STS_ERROR;
1393: rollback to H_STATUS;
1394: WHEN OTHERS then
1395: line_message(p_knum_and_mod =>l_knum_and_mod,
1396: p_line_number=>l_line_number,

Line 1402: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1398: p_old_status =>p_exp_line_rec.meaning,
1399: p_msg_data => x_msg_data,
1400: p_type =>'U');
1401: p_line_errors := p_line_errors +1 ;
1402: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1403: rollback to H_STATUS;
1404: END line_expire;
1405:
1406: PROCEDURE line_active(p_active_line_rec IN line_rec_type) IS

Line 1416: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1412: c := 0;
1413: end if;
1414: savepoint H_STATUS;
1415: p_line_count:= p_line_count + 1;
1416: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1417: l_knum_and_mod := p_active_line_rec.contract_number||' '||p_active_line_rec.contract_number_modifier;
1418: l_new_status := null;
1419: l_new_status_m := null;
1420:

Line 1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1458: x_msg_data => x_msg_data,
1459: p_clev_rec => l_cle_rec);
1460:
1461:
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: raise OKC_API.G_EXCEPTION_ERROR;
1466: END IF;

Line 1463: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1459: p_clev_rec => l_cle_rec);
1460:
1461:
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: raise OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: --

Line 1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1460:
1461:
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: raise OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: --
1468:

Line 1465: raise OKC_API.G_EXCEPTION_ERROR;

1461:
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: raise OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: --
1468:
1469: update_contract_line (

Line 1482: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1478: p_clev_rec => l_cle_rec,
1479: x_clev_rec => x_cle_rec);
1480:
1481:
1482: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1483: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1485: raise OKC_API.G_EXCEPTION_ERROR;
1486: END IF;

Line 1483: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1479: x_clev_rec => x_cle_rec);
1480:
1481:
1482: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1483: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1485: raise OKC_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: --

Line 1484: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1480:
1481:
1482: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1483: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1485: raise OKC_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: --
1488: if p_kid is NULL then

Line 1485: raise OKC_API.G_EXCEPTION_ERROR;

1481:
1482: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1483: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1484: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1485: raise OKC_API.G_EXCEPTION_ERROR;
1486: END IF;
1487: --
1488: if p_kid is NULL then
1489: c := c+1;

Line 1500: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1496: end if;
1497:
1498:
1499: EXCEPTION
1500: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1501: line_message(p_knum_and_mod =>l_knum_and_mod,
1502: p_line_number=>l_line_number,
1503: p_status =>l_new_status,
1504: p_old_status =>p_active_line_rec.meaning,

Line 1508: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1504: p_old_status =>p_active_line_rec.meaning,
1505: p_msg_data => x_msg_data,
1506: p_type =>'U');
1507: p_line_errors := p_line_errors +1 ;
1508: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1509: rollback to H_STATUS;
1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1511: line_message(p_knum_and_mod =>l_knum_and_mod,
1512: p_line_number=>l_line_number,

Line 1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1506: p_type =>'U');
1507: p_line_errors := p_line_errors +1 ;
1508: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1509: rollback to H_STATUS;
1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1511: line_message(p_knum_and_mod =>l_knum_and_mod,
1512: p_line_number=>l_line_number,
1513: p_status =>l_new_status,
1514: p_old_status =>p_active_line_rec.meaning,

Line 1518: x_return_status := OKC_API.G_RET_STS_ERROR;

1514: p_old_status =>p_active_line_rec.meaning,
1515: p_msg_data => x_msg_data,
1516: p_type =>'E');
1517: p_line_errors := p_line_errors +1 ;
1518: x_return_status := OKC_API.G_RET_STS_ERROR;
1519: rollback to H_STATUS;
1520: WHEN OTHERS then
1521: line_message(p_knum_and_mod =>l_knum_and_mod,
1522: p_line_number=>l_line_number,

Line 1528: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1524: p_old_status =>p_active_line_rec.meaning,
1525: p_msg_data => x_msg_data,
1526: p_type =>'U');
1527: p_line_errors := p_line_errors +1 ;
1528: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1529: rollback to H_STATUS;
1530: END line_active;
1531:
1532: --bug 5930684

Line 1543: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1539: c := 0;
1540: end if;
1541: savepoint H_STATUS;
1542: p_line_count:= p_line_count + 1;
1543: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1544: l_knum_and_mod := p_signed_line_rec.contract_number||' '||p_signed_line_rec.contract_number_modifier;
1545: l_new_status := null;
1546: l_new_status_m := null;
1547:

Line 1589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1585: x_msg_data => x_msg_data,
1586: p_clev_rec => l_cle_rec);
1587:
1588:
1589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1590: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1592: raise OKC_API.G_EXCEPTION_ERROR;
1593: END IF;

Line 1590: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1586: p_clev_rec => l_cle_rec);
1587:
1588:
1589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1590: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1592: raise OKC_API.G_EXCEPTION_ERROR;
1593: END IF;
1594: --

Line 1591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1587:
1588:
1589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1590: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1592: raise OKC_API.G_EXCEPTION_ERROR;
1593: END IF;
1594: --
1595:

Line 1592: raise OKC_API.G_EXCEPTION_ERROR;

1588:
1589: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1590: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1591: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1592: raise OKC_API.G_EXCEPTION_ERROR;
1593: END IF;
1594: --
1595:
1596: update_contract_line (

Line 1609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1605: p_clev_rec => l_cle_rec,
1606: x_clev_rec => x_cle_rec);
1607:
1608:
1609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1610: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1612: raise OKC_API.G_EXCEPTION_ERROR;
1613: END IF;

Line 1610: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1606: x_clev_rec => x_cle_rec);
1607:
1608:
1609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1610: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1612: raise OKC_API.G_EXCEPTION_ERROR;
1613: END IF;
1614: --

Line 1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1607:
1608:
1609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1610: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1612: raise OKC_API.G_EXCEPTION_ERROR;
1613: END IF;
1614: --
1615: if p_kid is NULL then

Line 1612: raise OKC_API.G_EXCEPTION_ERROR;

1608:
1609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1610: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1612: raise OKC_API.G_EXCEPTION_ERROR;
1613: END IF;
1614: --
1615: if p_kid is NULL then
1616: c := c+1;

Line 1627: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1623: end if;
1624:
1625:
1626: EXCEPTION
1627: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1628: line_message(p_knum_and_mod =>l_knum_and_mod,
1629: p_line_number=>l_line_number,
1630: p_status =>l_new_status,
1631: p_old_status =>p_signed_line_rec.meaning,

Line 1635: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1631: p_old_status =>p_signed_line_rec.meaning,
1632: p_msg_data => x_msg_data,
1633: p_type =>'U');
1634: p_line_errors := p_line_errors +1 ;
1635: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1636: rollback to H_STATUS;
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1638: line_message(p_knum_and_mod =>l_knum_and_mod,
1639: p_line_number=>l_line_number,

Line 1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1633: p_type =>'U');
1634: p_line_errors := p_line_errors +1 ;
1635: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1636: rollback to H_STATUS;
1637: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1638: line_message(p_knum_and_mod =>l_knum_and_mod,
1639: p_line_number=>l_line_number,
1640: p_status =>l_new_status,
1641: p_old_status =>p_signed_line_rec.meaning,

Line 1645: x_return_status := OKC_API.G_RET_STS_ERROR;

1641: p_old_status =>p_signed_line_rec.meaning,
1642: p_msg_data => x_msg_data,
1643: p_type =>'E');
1644: p_line_errors := p_line_errors +1 ;
1645: x_return_status := OKC_API.G_RET_STS_ERROR;
1646: rollback to H_STATUS;
1647: WHEN OTHERS then
1648: line_message(p_knum_and_mod =>l_knum_and_mod,
1649: p_line_number=>l_line_number,

Line 1655: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1651: p_old_status =>p_signed_line_rec.meaning,
1652: p_msg_data => x_msg_data,
1653: p_type =>'U');
1654: p_line_errors := p_line_errors +1 ;
1655: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1656: rollback to H_STATUS;
1657: END line_signed;
1658: -- end of bug 5930684
1659:

Line 1685: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1681:
1682: BEGIN
1683:
1684:
1685: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1686: --added for bug fix 5285247
1687: Savepoint H_STATUS;
1688: l_new_status := null;
1689: l_new_status_m := null;

Line 1972: l_return_status := OKC_API.G_RET_STS_SUCCESS;

1968: ---------------------------------------------------------------------------------
1969: --Added for bug 5402421
1970: Savepoint H_STATUS;
1971:
1972: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1973: -- From ACTIVE/SIGNED to Expired
1974: IF (h_status = 'EXPIRED') OR (h_status IS NULL) THEN
1975: IF p_kid IS NULL THEN
1976: /* Commented for Bug #3967643.

Line 2326: l_return_status := OKC_API.G_RET_STS_SUCCESS;

2322: END LOOP;
2323: END IF;
2324: END IF;
2325: END IF; --
2326: l_return_status := OKC_API.G_RET_STS_SUCCESS;
2327: l_new_status := null;
2328: l_new_status_m := null;
2329: l_knum_and_mod := null;
2330: l_line_number := null;

Line 2689: l_return_status := OKC_API.G_RET_STS_SUCCESS;

2685: END IF;
2686:
2687: Savepoint H_STATUS;
2688:
2689: l_return_status := OKC_API.G_RET_STS_SUCCESS;
2690: l_new_status := null;
2691: l_new_status_m := null;
2692: l_knum_and_mod := null;
2693: l_line_number := null;

Line 2955: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2951: p_msg_data => x_msg_data,
2952: p_type =>'U');
2953: p_line_errors := p_line_errors +1 ;
2954: rollback to H_STATUS;
2955: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2956: return;
2957:
2958: END; -- procedure line_status_change
2959: -- BUG 4285665 --

Line 3078: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

3074: p_debug IN VARCHAR2 ,
3075: p_last_rundate IN VARCHAR2 ) IS
3076: L_K_N_W_M VARCHAR2(240); -- contract number conactinated with contract number modifier.
3077: C number := 0;
3078: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
3079: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
3080: x_msg_count NUMBER := okc_api.g_miss_num;
3081: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
3082: l_chr_rec okc_contract_pub.chrv_rec_type;

Line 3079: p_init_msg_list VARCHAR2(200) := okc_api.g_true;

3075: p_last_rundate IN VARCHAR2 ) IS
3076: L_K_N_W_M VARCHAR2(240); -- contract number conactinated with contract number modifier.
3077: C number := 0;
3078: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
3079: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
3080: x_msg_count NUMBER := okc_api.g_miss_num;
3081: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
3082: l_chr_rec okc_contract_pub.chrv_rec_type;
3083: i_chr_rec okc_contract_pub.chrv_rec_type;

Line 3080: x_msg_count NUMBER := okc_api.g_miss_num;

3076: L_K_N_W_M VARCHAR2(240); -- contract number conactinated with contract number modifier.
3077: C number := 0;
3078: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
3079: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
3080: x_msg_count NUMBER := okc_api.g_miss_num;
3081: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
3082: l_chr_rec okc_contract_pub.chrv_rec_type;
3083: i_chr_rec okc_contract_pub.chrv_rec_type;
3084: p_error_from_line VARCHAR2(1) := 'N';

Line 3081: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;

3077: C number := 0;
3078: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
3079: p_init_msg_list VARCHAR2(200) := okc_api.g_true;
3080: x_msg_count NUMBER := okc_api.g_miss_num;
3081: x_msg_data VARCHAR2(2000) := okc_api.g_miss_char;
3082: l_chr_rec okc_contract_pub.chrv_rec_type;
3083: i_chr_rec okc_contract_pub.chrv_rec_type;
3084: p_error_from_line VARCHAR2(1) := 'N';
3085:

Line 3955: l_return_status := OKC_API.G_RET_STS_SUCCESS;

3951: c := 0;
3952: end if;
3953: savepoint H_STATUS;
3954: p_hdr_count:= p_hdr_count + 1;
3955: l_return_status := OKC_API.G_RET_STS_SUCCESS;
3956: L_K_N_W_M := r_terminated.K_N_W_M;
3957:
3958: l_new_status := null;
3959: l_new_status_m := null;

Line 3984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3980: x_return_status => l_return_status,
3981: x_msg_count => x_msg_count,
3982: x_msg_data => x_msg_data,
3983: p_chrv_rec => l_chr_rec);
3984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3985: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3987: raise OKC_API.G_EXCEPTION_ERROR;
3988: END IF;

Line 3985: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3981: x_msg_count => x_msg_count,
3982: x_msg_data => x_msg_data,
3983: p_chrv_rec => l_chr_rec);
3984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3985: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3987: raise OKC_API.G_EXCEPTION_ERROR;
3988: END IF;
3989: --

Line 3986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

3982: x_msg_data => x_msg_data,
3983: p_chrv_rec => l_chr_rec);
3984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3985: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3987: raise OKC_API.G_EXCEPTION_ERROR;
3988: END IF;
3989: --
3990: --

Line 3987: raise OKC_API.G_EXCEPTION_ERROR;

3983: p_chrv_rec => l_chr_rec);
3984: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3985: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3986: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
3987: raise OKC_API.G_EXCEPTION_ERROR;
3988: END IF;
3989: --
3990: --
3991: update_contract_header (

Line 4000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3996: x_msg_data => x_msg_data,
3997: p_chrv_rec => l_chr_rec,
3998: x_chrv_rec => i_chr_rec);
3999:
4000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4001: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4002: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4003: raise OKC_API.G_EXCEPTION_ERROR;
4004: END IF;

Line 4001: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3997: p_chrv_rec => l_chr_rec,
3998: x_chrv_rec => i_chr_rec);
3999:
4000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4001: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4002: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4003: raise OKC_API.G_EXCEPTION_ERROR;
4004: END IF;
4005:

Line 4002: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

3998: x_chrv_rec => i_chr_rec);
3999:
4000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4001: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4002: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4003: raise OKC_API.G_EXCEPTION_ERROR;
4004: END IF;
4005:
4006: OKC_K_TERM_ASMBLR_PVT.acn_assemble(

Line 4003: raise OKC_API.G_EXCEPTION_ERROR;

3999:
4000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4001: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4002: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4003: raise OKC_API.G_EXCEPTION_ERROR;
4004: END IF;
4005:
4006: OKC_K_TERM_ASMBLR_PVT.acn_assemble(
4007: p_api_version => 1.0 ,

Line 4024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4020: p_term_reason => r_terminated.termination_reason);
4021:
4022:
4023: --
4024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4025: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4027: raise OKC_API.G_EXCEPTION_ERROR;
4028: END IF;

Line 4025: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4021:
4022:
4023: --
4024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4025: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4027: raise OKC_API.G_EXCEPTION_ERROR;
4028: END IF;
4029: OKC_TIME_RES_PUB.res_time_termnt_k(

Line 4026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4022:
4023: --
4024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4025: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4027: raise OKC_API.G_EXCEPTION_ERROR;
4028: END IF;
4029: OKC_TIME_RES_PUB.res_time_termnt_k(
4030: P_CHR_ID => r_terminated.id,

Line 4027: raise OKC_API.G_EXCEPTION_ERROR;

4023: --
4024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4025: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4027: raise OKC_API.G_EXCEPTION_ERROR;
4028: END IF;
4029: OKC_TIME_RES_PUB.res_time_termnt_k(
4030: P_CHR_ID => r_terminated.id,
4031: P_CLE_ID => NULL,

Line 4039: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4035: x_return_status => l_return_status
4036: );
4037:
4038:
4039: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4040: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4041: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4042: raise OKC_API.G_EXCEPTION_ERROR;
4043: END IF;

Line 4040: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4036: );
4037:
4038:
4039: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4040: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4041: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4042: raise OKC_API.G_EXCEPTION_ERROR;
4043: END IF;
4044: --

Line 4041: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4037:
4038:
4039: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4040: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4041: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4042: raise OKC_API.G_EXCEPTION_ERROR;
4043: END IF;
4044: --
4045: --+

Line 4042: raise OKC_API.G_EXCEPTION_ERROR;

4038:
4039: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4040: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4041: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4042: raise OKC_API.G_EXCEPTION_ERROR;
4043: END IF;
4044: --
4045: --+
4046: --+ remember header status for lines to follow it, not default

Line 4062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4058: x_return_status => l_return_status);
4059:
4060:
4061:
4062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4063: p_error_from_line := 'Y';
4064: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4066: p_error_from_line := 'Y';

Line 4064: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4060:
4061:
4062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4063: p_error_from_line := 'Y';
4064: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4066: p_error_from_line := 'Y';
4067: raise OKC_API.G_EXCEPTION_ERROR;
4068: END IF;

Line 4065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4061:
4062: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4063: p_error_from_line := 'Y';
4064: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4066: p_error_from_line := 'Y';
4067: raise OKC_API.G_EXCEPTION_ERROR;
4068: END IF;
4069: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4067: raise OKC_API.G_EXCEPTION_ERROR;

4063: p_error_from_line := 'Y';
4064: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4065: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4066: p_error_from_line := 'Y';
4067: raise OKC_API.G_EXCEPTION_ERROR;
4068: END IF;
4069: header_message(p_knum_and_mod =>L_K_N_W_M,
4070: p_old_status =>r_terminated.meaning,
4071: p_status =>h_new_status_m,

Line 4075: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4071: p_status =>h_new_status_m,
4072: p_type =>'S');
4073: c:= c+1;
4074: EXCEPTION
4075: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4076: header_message(p_knum_and_mod =>L_K_N_W_M,
4077: p_status =>h_new_status_m,
4078: p_old_status =>r_terminated.meaning,
4079: p_msg_data => x_msg_data,

Line 4087: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4083: else
4084: p_error_from_line := 'N';
4085: end if;
4086: rollback to H_STATUS;
4087: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4088: header_message(p_knum_and_mod =>L_K_N_W_M,
4089: p_status =>h_new_status_m,
4090: p_old_status =>r_terminated.meaning,
4091: p_msg_data => x_msg_data,

Line 4130: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4126: end if;
4127:
4128: savepoint H_STATUS;
4129: p_hdr_count:= p_hdr_count + 1;
4130: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4131: L_K_N_W_M := r_expired.K_N_W_M;
4132: l_new_status := null;
4133: l_new_status_m := null;
4134: h_status := null;

Line 4156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4152: x_return_status => l_return_status,
4153: x_msg_count => x_msg_count,
4154: x_msg_data => x_msg_data,
4155: p_chrv_rec => l_chr_rec);
4156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4159: raise OKC_API.G_EXCEPTION_ERROR;
4160: END IF;

Line 4157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4153: x_msg_count => x_msg_count,
4154: x_msg_data => x_msg_data,
4155: p_chrv_rec => l_chr_rec);
4156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4159: raise OKC_API.G_EXCEPTION_ERROR;
4160: END IF;
4161: --

Line 4158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4154: x_msg_data => x_msg_data,
4155: p_chrv_rec => l_chr_rec);
4156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4159: raise OKC_API.G_EXCEPTION_ERROR;
4160: END IF;
4161: --
4162: update_contract_header (

Line 4159: raise OKC_API.G_EXCEPTION_ERROR;

4155: p_chrv_rec => l_chr_rec);
4156: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4157: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4158: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4159: raise OKC_API.G_EXCEPTION_ERROR;
4160: END IF;
4161: --
4162: update_contract_header (
4163: p_api_version => 1.0,

Line 4170: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4166: x_msg_count => x_msg_count,
4167: x_msg_data => x_msg_data,
4168: p_chrv_rec => l_chr_rec,
4169: x_chrv_rec => i_chr_rec);
4170: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4172: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4173: raise OKC_API.G_EXCEPTION_ERROR;
4174: END IF;

Line 4171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4167: x_msg_data => x_msg_data,
4168: p_chrv_rec => l_chr_rec,
4169: x_chrv_rec => i_chr_rec);
4170: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4172: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4173: raise OKC_API.G_EXCEPTION_ERROR;
4174: END IF;
4175: --+

Line 4172: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4168: p_chrv_rec => l_chr_rec,
4169: x_chrv_rec => i_chr_rec);
4170: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4172: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4173: raise OKC_API.G_EXCEPTION_ERROR;
4174: END IF;
4175: --+
4176: --+ remember header status for lines to follow it, not default

Line 4173: raise OKC_API.G_EXCEPTION_ERROR;

4169: x_chrv_rec => i_chr_rec);
4170: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4171: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4172: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4173: raise OKC_API.G_EXCEPTION_ERROR;
4174: END IF;
4175: --+
4176: --+ remember header status for lines to follow it, not default
4177: --+

Line 4187: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4183: p_k_num => r_expired.contract_number,
4184: p_k_num_mod => r_expired.contract_number_modifier,
4185: p_update_minor_version =>'N',
4186: x_return_status => l_return_status);
4187: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4188: p_error_from_line := 'Y';
4189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4191: p_error_from_line := 'Y';

Line 4189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4185: p_update_minor_version =>'N',
4186: x_return_status => l_return_status);
4187: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4188: p_error_from_line := 'Y';
4189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4191: p_error_from_line := 'Y';
4192: raise OKC_API.G_EXCEPTION_ERROR;
4193: END IF;

Line 4190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4186: x_return_status => l_return_status);
4187: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4188: p_error_from_line := 'Y';
4189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4191: p_error_from_line := 'Y';
4192: raise OKC_API.G_EXCEPTION_ERROR;
4193: END IF;
4194: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4192: raise OKC_API.G_EXCEPTION_ERROR;

4188: p_error_from_line := 'Y';
4189: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4190: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4191: p_error_from_line := 'Y';
4192: raise OKC_API.G_EXCEPTION_ERROR;
4193: END IF;
4194: header_message(p_knum_and_mod =>L_K_N_W_M,
4195: p_status =>h_new_status_m,
4196: p_old_status =>r_expired.meaning,

Line 4201: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4197: p_type =>'S');
4198:
4199: c := c + 1;
4200: EXCEPTION
4201: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4202: header_message(p_knum_and_mod =>L_K_N_W_M,
4203: p_status =>h_new_status_m,
4204: p_old_status =>r_expired.meaning,
4205: p_msg_data => x_msg_data,

Line 4213: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4209: else
4210: p_error_from_line := 'N';
4211: end if;
4212: rollback to H_STATUS;
4213: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4214: header_message(p_knum_and_mod =>L_K_N_W_M,
4215: p_status =>h_new_status_m,
4216: p_old_status =>r_expired.meaning,
4217: p_msg_data => x_msg_data,

Line 4253: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4249: c := 0;
4250: end if;
4251: savepoint H_STATUS;
4252: p_hdr_count:= p_hdr_count + 1;
4253: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4254: L_K_N_W_M := r_active.K_N_W_M;
4255:
4256: l_new_status := null;
4257: l_new_status_m := null;

Line 4279: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4275: x_msg_count => x_msg_count,
4276: x_msg_data => x_msg_data,
4277: p_chrv_rec => l_chr_rec);
4278:
4279: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4280: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4282: raise OKC_API.G_EXCEPTION_ERROR;
4283: END IF;

Line 4280: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4276: x_msg_data => x_msg_data,
4277: p_chrv_rec => l_chr_rec);
4278:
4279: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4280: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4282: raise OKC_API.G_EXCEPTION_ERROR;
4283: END IF;
4284: --

Line 4281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4277: p_chrv_rec => l_chr_rec);
4278:
4279: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4280: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4282: raise OKC_API.G_EXCEPTION_ERROR;
4283: END IF;
4284: --
4285: update_contract_header (

Line 4282: raise OKC_API.G_EXCEPTION_ERROR;

4278:
4279: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4280: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4281: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4282: raise OKC_API.G_EXCEPTION_ERROR;
4283: END IF;
4284: --
4285: update_contract_header (
4286: p_api_version => 1.0,

Line 4294: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4290: x_msg_data => x_msg_data,
4291: p_chrv_rec => l_chr_rec,
4292: x_chrv_rec => i_chr_rec);
4293:
4294: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4295: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4296: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4297: raise OKC_API.G_EXCEPTION_ERROR;
4298: END IF;

Line 4295: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4291: p_chrv_rec => l_chr_rec,
4292: x_chrv_rec => i_chr_rec);
4293:
4294: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4295: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4296: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4297: raise OKC_API.G_EXCEPTION_ERROR;
4298: END IF;
4299: --+

Line 4296: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4292: x_chrv_rec => i_chr_rec);
4293:
4294: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4295: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4296: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4297: raise OKC_API.G_EXCEPTION_ERROR;
4298: END IF;
4299: --+
4300: --+ remember header status for lines to follow it, not default

Line 4297: raise OKC_API.G_EXCEPTION_ERROR;

4293:
4294: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4295: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4296: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4297: raise OKC_API.G_EXCEPTION_ERROR;
4298: END IF;
4299: --+
4300: --+ remember header status for lines to follow it, not default
4301: --+

Line 4313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4309: p_k_num_mod => r_active.contract_number_modifier,
4310: p_update_minor_version =>'N',
4311: x_return_status => l_return_status);
4312:
4313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4314: p_error_from_line := 'Y';
4315: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4317: p_error_from_line := 'Y';

Line 4315: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4311: x_return_status => l_return_status);
4312:
4313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4314: p_error_from_line := 'Y';
4315: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4317: p_error_from_line := 'Y';
4318: raise OKC_API.G_EXCEPTION_ERROR;
4319: END IF;

Line 4316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4312:
4313: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4314: p_error_from_line := 'Y';
4315: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4317: p_error_from_line := 'Y';
4318: raise OKC_API.G_EXCEPTION_ERROR;
4319: END IF;
4320: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4318: raise OKC_API.G_EXCEPTION_ERROR;

4314: p_error_from_line := 'Y';
4315: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4316: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4317: p_error_from_line := 'Y';
4318: raise OKC_API.G_EXCEPTION_ERROR;
4319: END IF;
4320: header_message(p_knum_and_mod =>L_K_N_W_M,
4321: p_status =>h_new_status_m,
4322: p_old_status =>r_active.meaning,

Line 4326: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4322: p_old_status =>r_active.meaning,
4323: p_type =>'S');
4324: c := c+1;
4325: EXCEPTION
4326: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4327: header_message(p_knum_and_mod =>L_K_N_W_M,
4328: p_status =>h_new_status_m,
4329: p_old_status =>r_active.meaning,
4330: p_msg_data => x_msg_data,

Line 4338: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4334: else
4335: p_error_from_line := 'N';
4336: end if;
4337: rollback to H_STATUS;
4338: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4339: header_message(p_knum_and_mod =>L_K_N_W_M,
4340: p_status =>h_new_status_m,
4341: p_old_status =>r_active.meaning,
4342: p_msg_data => x_msg_data,

Line 4381: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4377: c := 0;
4378: end if;
4379: savepoint H_STATUS;
4380: p_hdr_count:= p_hdr_count + 1;
4381: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4382: L_K_N_W_M := r_signed.K_N_W_M;
4383:
4384: l_new_status := null;
4385: l_new_status_m := null;

Line 4407: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4403: x_msg_count => x_msg_count,
4404: x_msg_data => x_msg_data,
4405: p_chrv_rec => l_chr_rec);
4406:
4407: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4408: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4410: raise OKC_API.G_EXCEPTION_ERROR;
4411: END IF;

Line 4408: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4404: x_msg_data => x_msg_data,
4405: p_chrv_rec => l_chr_rec);
4406:
4407: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4408: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4410: raise OKC_API.G_EXCEPTION_ERROR;
4411: END IF;
4412: --

Line 4409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4405: p_chrv_rec => l_chr_rec);
4406:
4407: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4408: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4410: raise OKC_API.G_EXCEPTION_ERROR;
4411: END IF;
4412: --
4413: update_contract_header (

Line 4410: raise OKC_API.G_EXCEPTION_ERROR;

4406:
4407: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4408: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4409: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4410: raise OKC_API.G_EXCEPTION_ERROR;
4411: END IF;
4412: --
4413: update_contract_header (
4414: p_api_version => 1.0,

Line 4422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4418: x_msg_data => x_msg_data,
4419: p_chrv_rec => l_chr_rec,
4420: x_chrv_rec => i_chr_rec);
4421:
4422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4423: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4425: raise OKC_API.G_EXCEPTION_ERROR;
4426: END IF;

Line 4423: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4419: p_chrv_rec => l_chr_rec,
4420: x_chrv_rec => i_chr_rec);
4421:
4422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4423: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4425: raise OKC_API.G_EXCEPTION_ERROR;
4426: END IF;
4427: --+

Line 4424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4420: x_chrv_rec => i_chr_rec);
4421:
4422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4423: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4425: raise OKC_API.G_EXCEPTION_ERROR;
4426: END IF;
4427: --+
4428: --+ remember header status for lines to follow it, not default

Line 4425: raise OKC_API.G_EXCEPTION_ERROR;

4421:
4422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4423: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4425: raise OKC_API.G_EXCEPTION_ERROR;
4426: END IF;
4427: --+
4428: --+ remember header status for lines to follow it, not default
4429: --+

Line 4441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4437: p_k_num_mod => r_signed.contract_number_modifier,
4438: p_update_minor_version =>'N',
4439: x_return_status => l_return_status);
4440:
4441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4442: p_error_from_line := 'Y';
4443: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4445: p_error_from_line := 'Y';

Line 4443: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4439: x_return_status => l_return_status);
4440:
4441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4442: p_error_from_line := 'Y';
4443: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4445: p_error_from_line := 'Y';
4446: raise OKC_API.G_EXCEPTION_ERROR;
4447: END IF;

Line 4444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4440:
4441: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4442: p_error_from_line := 'Y';
4443: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4445: p_error_from_line := 'Y';
4446: raise OKC_API.G_EXCEPTION_ERROR;
4447: END IF;
4448: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4446: raise OKC_API.G_EXCEPTION_ERROR;

4442: p_error_from_line := 'Y';
4443: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4445: p_error_from_line := 'Y';
4446: raise OKC_API.G_EXCEPTION_ERROR;
4447: END IF;
4448: header_message(p_knum_and_mod =>L_K_N_W_M,
4449: p_status =>h_new_status_m,
4450: p_old_status =>r_signed.meaning,

Line 4454: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4450: p_old_status =>r_signed.meaning,
4451: p_type =>'S');
4452: c := c+1;
4453: EXCEPTION
4454: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4455: header_message(p_knum_and_mod =>L_K_N_W_M,
4456: p_status =>h_new_status_m,
4457: p_old_status =>r_signed.meaning,
4458: p_msg_data => x_msg_data,

Line 4466: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4462: else
4463: p_error_from_line := 'N';
4464: end if;
4465: rollback to H_STATUS;
4466: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4467: header_message(p_knum_and_mod =>L_K_N_W_M,
4468: p_status =>h_new_status_m,
4469: p_old_status =>r_signed.meaning,
4470: p_msg_data => x_msg_data,

Line 4513: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4509: c := 0;
4510: end if;
4511: savepoint H_STATUS;
4512: p_hdr_count:= p_hdr_count + 1;
4513: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4514: L_K_N_W_M := r_terminated.K_N_W_M;
4515:
4516: l_new_status := null;
4517: l_new_status_m := null;

Line 4542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4538: x_return_status => l_return_status,
4539: x_msg_count => x_msg_count,
4540: x_msg_data => x_msg_data,
4541: p_chrv_rec => l_chr_rec);
4542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4545: raise OKC_API.G_EXCEPTION_ERROR;
4546: END IF;

Line 4543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4539: x_msg_count => x_msg_count,
4540: x_msg_data => x_msg_data,
4541: p_chrv_rec => l_chr_rec);
4542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4545: raise OKC_API.G_EXCEPTION_ERROR;
4546: END IF;
4547: --

Line 4544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4540: x_msg_data => x_msg_data,
4541: p_chrv_rec => l_chr_rec);
4542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4545: raise OKC_API.G_EXCEPTION_ERROR;
4546: END IF;
4547: --
4548: --

Line 4545: raise OKC_API.G_EXCEPTION_ERROR;

4541: p_chrv_rec => l_chr_rec);
4542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4545: raise OKC_API.G_EXCEPTION_ERROR;
4546: END IF;
4547: --
4548: --
4549: update_contract_header (

Line 4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4555: p_chrv_rec => l_chr_rec,
4556: x_chrv_rec => i_chr_rec);
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
4558:
4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4562: raise OKC_API.G_EXCEPTION_ERROR;
4563: END IF;

Line 4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4556: x_chrv_rec => i_chr_rec);
4557: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
4558:
4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4562: raise OKC_API.G_EXCEPTION_ERROR;
4563: END IF;
4564:

Line 4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4557: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
4558:
4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4562: raise OKC_API.G_EXCEPTION_ERROR;
4563: END IF;
4564:
4565: OKC_K_TERM_ASMBLR_PVT.acn_assemble(

Line 4562: raise OKC_API.G_EXCEPTION_ERROR;

4558:
4559: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4560: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4561: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4562: raise OKC_API.G_EXCEPTION_ERROR;
4563: END IF;
4564:
4565: OKC_K_TERM_ASMBLR_PVT.acn_assemble(
4566: p_api_version => 1.0 ,

Line 4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4579: p_term_reason => r_terminated.termination_reason);
4580: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
4581:
4582: --
4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4586: raise OKC_API.G_EXCEPTION_ERROR;
4587: END IF;

Line 4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4580: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
4581:
4582: --
4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4586: raise OKC_API.G_EXCEPTION_ERROR;
4587: END IF;
4588: OKC_TIME_RES_PUB.res_time_termnt_k(

Line 4585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4581:
4582: --
4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4586: raise OKC_API.G_EXCEPTION_ERROR;
4587: END IF;
4588: OKC_TIME_RES_PUB.res_time_termnt_k(
4589: P_CHR_ID => r_terminated.id,

Line 4586: raise OKC_API.G_EXCEPTION_ERROR;

4582: --
4583: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4584: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4585: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4586: raise OKC_API.G_EXCEPTION_ERROR;
4587: END IF;
4588: OKC_TIME_RES_PUB.res_time_termnt_k(
4589: P_CHR_ID => r_terminated.id,
4590: P_CLE_ID => NULL,

Line 4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4595: );
4596:
4597: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
4598:
4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4602: raise OKC_API.G_EXCEPTION_ERROR;
4603: END IF;

Line 4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4596:
4597: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
4598:
4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4602: raise OKC_API.G_EXCEPTION_ERROR;
4603: END IF;
4604: --

Line 4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4597: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
4598:
4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4602: raise OKC_API.G_EXCEPTION_ERROR;
4603: END IF;
4604: --
4605: --+

Line 4602: raise OKC_API.G_EXCEPTION_ERROR;

4598:
4599: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4600: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4601: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4602: raise OKC_API.G_EXCEPTION_ERROR;
4603: END IF;
4604: --
4605: --+
4606: --+ remember header status for lines to follow it, not default

Line 4622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4618: x_return_status => l_return_status);
4619: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
4620:
4621:
4622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4623: p_error_from_line := 'Y';
4624: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4626: p_error_from_line := 'Y';

Line 4624: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4620:
4621:
4622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4623: p_error_from_line := 'Y';
4624: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4626: p_error_from_line := 'Y';
4627: raise OKC_API.G_EXCEPTION_ERROR;
4628: END IF;

Line 4625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4621:
4622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4623: p_error_from_line := 'Y';
4624: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4626: p_error_from_line := 'Y';
4627: raise OKC_API.G_EXCEPTION_ERROR;
4628: END IF;
4629: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4627: raise OKC_API.G_EXCEPTION_ERROR;

4623: p_error_from_line := 'Y';
4624: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4625: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4626: p_error_from_line := 'Y';
4627: raise OKC_API.G_EXCEPTION_ERROR;
4628: END IF;
4629: header_message(p_knum_and_mod =>L_K_N_W_M,
4630: p_old_status =>r_terminated.meaning,
4631: p_status =>h_new_status_m,

Line 4635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4631: p_status =>h_new_status_m,
4632: p_type =>'S');
4633: c:= c+1;
4634: EXCEPTION
4635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4636: header_message(p_knum_and_mod =>L_K_N_W_M,
4637: p_status =>h_new_status_m,
4638: p_old_status =>r_terminated.meaning,
4639: p_msg_data => x_msg_data,

Line 4647: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4643: else
4644: p_error_from_line := 'N';
4645: end if;
4646: rollback to H_STATUS;
4647: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4648: header_message(p_knum_and_mod =>L_K_N_W_M,
4649: p_status =>h_new_status_m,
4650: p_old_status =>r_terminated.meaning,
4651: p_msg_data => x_msg_data,

Line 4690: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4686: end if;
4687:
4688: savepoint H_STATUS;
4689: p_hdr_count:= p_hdr_count + 1;
4690: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4691: L_K_N_W_M := r_expired.K_N_W_M;
4692: l_new_status := null;
4693: l_new_status_m := null;
4694: h_status := null;

Line 4716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4712: x_return_status => l_return_status,
4713: x_msg_count => x_msg_count,
4714: x_msg_data => x_msg_data,
4715: p_chrv_rec => l_chr_rec);
4716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4717: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4719: raise OKC_API.G_EXCEPTION_ERROR;
4720: END IF;

Line 4717: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4713: x_msg_count => x_msg_count,
4714: x_msg_data => x_msg_data,
4715: p_chrv_rec => l_chr_rec);
4716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4717: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4719: raise OKC_API.G_EXCEPTION_ERROR;
4720: END IF;
4721: --

Line 4718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4714: x_msg_data => x_msg_data,
4715: p_chrv_rec => l_chr_rec);
4716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4717: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4719: raise OKC_API.G_EXCEPTION_ERROR;
4720: END IF;
4721: --
4722: update_contract_header (

Line 4719: raise OKC_API.G_EXCEPTION_ERROR;

4715: p_chrv_rec => l_chr_rec);
4716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4717: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4719: raise OKC_API.G_EXCEPTION_ERROR;
4720: END IF;
4721: --
4722: update_contract_header (
4723: p_api_version => 1.0,

Line 4730: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4726: x_msg_count => x_msg_count,
4727: x_msg_data => x_msg_data,
4728: p_chrv_rec => l_chr_rec,
4729: x_chrv_rec => i_chr_rec);
4730: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4731: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4732: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4733: raise OKC_API.G_EXCEPTION_ERROR;
4734: END IF;

Line 4731: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4727: x_msg_data => x_msg_data,
4728: p_chrv_rec => l_chr_rec,
4729: x_chrv_rec => i_chr_rec);
4730: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4731: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4732: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4733: raise OKC_API.G_EXCEPTION_ERROR;
4734: END IF;
4735: --+

Line 4732: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4728: p_chrv_rec => l_chr_rec,
4729: x_chrv_rec => i_chr_rec);
4730: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4731: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4732: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4733: raise OKC_API.G_EXCEPTION_ERROR;
4734: END IF;
4735: --+
4736: --+ remember header status for lines to follow it, not default

Line 4733: raise OKC_API.G_EXCEPTION_ERROR;

4729: x_chrv_rec => i_chr_rec);
4730: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4731: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4732: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4733: raise OKC_API.G_EXCEPTION_ERROR;
4734: END IF;
4735: --+
4736: --+ remember header status for lines to follow it, not default
4737: --+

Line 4747: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4743: p_k_num => r_expired.contract_number,
4744: p_k_num_mod => r_expired.contract_number_modifier,
4745: p_update_minor_version =>'N',
4746: x_return_status => l_return_status);
4747: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4748: p_error_from_line := 'Y';
4749: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4751: p_error_from_line := 'Y';

Line 4749: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4745: p_update_minor_version =>'N',
4746: x_return_status => l_return_status);
4747: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4748: p_error_from_line := 'Y';
4749: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4751: p_error_from_line := 'Y';
4752: raise OKC_API.G_EXCEPTION_ERROR;
4753: END IF;

Line 4750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4746: x_return_status => l_return_status);
4747: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4748: p_error_from_line := 'Y';
4749: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4751: p_error_from_line := 'Y';
4752: raise OKC_API.G_EXCEPTION_ERROR;
4753: END IF;
4754: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4752: raise OKC_API.G_EXCEPTION_ERROR;

4748: p_error_from_line := 'Y';
4749: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4750: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4751: p_error_from_line := 'Y';
4752: raise OKC_API.G_EXCEPTION_ERROR;
4753: END IF;
4754: header_message(p_knum_and_mod =>L_K_N_W_M,
4755: p_status =>h_new_status_m,
4756: p_old_status =>r_expired.meaning,

Line 4761: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4757: p_type =>'S');
4758:
4759: c := c + 1;
4760: EXCEPTION
4761: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4762: header_message(p_knum_and_mod =>L_K_N_W_M,
4763: p_status =>h_new_status_m,
4764: p_old_status =>r_expired.meaning,
4765: p_msg_data => x_msg_data,

Line 4773: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4769: else
4770: p_error_from_line := 'N';
4771: end if;
4772: rollback to H_STATUS;
4773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4774: header_message(p_knum_and_mod =>L_K_N_W_M,
4775: p_status =>h_new_status_m,
4776: p_old_status =>r_expired.meaning,
4777: p_msg_data => x_msg_data,

Line 4813: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4809: c := 0;
4810: end if;
4811: savepoint H_STATUS;
4812: p_hdr_count:= p_hdr_count + 1;
4813: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4814: L_K_N_W_M := r_active.K_N_W_M;
4815:
4816: l_new_status := null;
4817: l_new_status_m := null;

Line 4839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4835: x_msg_count => x_msg_count,
4836: x_msg_data => x_msg_data,
4837: p_chrv_rec => l_chr_rec);
4838:
4839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4840: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4842: raise OKC_API.G_EXCEPTION_ERROR;
4843: END IF;

Line 4840: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4836: x_msg_data => x_msg_data,
4837: p_chrv_rec => l_chr_rec);
4838:
4839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4840: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4842: raise OKC_API.G_EXCEPTION_ERROR;
4843: END IF;
4844: --

Line 4841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4837: p_chrv_rec => l_chr_rec);
4838:
4839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4840: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4842: raise OKC_API.G_EXCEPTION_ERROR;
4843: END IF;
4844: --
4845: update_contract_header (

Line 4842: raise OKC_API.G_EXCEPTION_ERROR;

4838:
4839: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4840: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4841: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4842: raise OKC_API.G_EXCEPTION_ERROR;
4843: END IF;
4844: --
4845: update_contract_header (
4846: p_api_version => 1.0,

Line 4854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4850: x_msg_data => x_msg_data,
4851: p_chrv_rec => l_chr_rec,
4852: x_chrv_rec => i_chr_rec);
4853:
4854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4855: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4857: raise OKC_API.G_EXCEPTION_ERROR;
4858: END IF;

Line 4855: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4851: p_chrv_rec => l_chr_rec,
4852: x_chrv_rec => i_chr_rec);
4853:
4854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4855: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4857: raise OKC_API.G_EXCEPTION_ERROR;
4858: END IF;
4859: --+

Line 4856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4852: x_chrv_rec => i_chr_rec);
4853:
4854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4855: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4857: raise OKC_API.G_EXCEPTION_ERROR;
4858: END IF;
4859: --+
4860: --+ remember header status for lines to follow it, not default

Line 4857: raise OKC_API.G_EXCEPTION_ERROR;

4853:
4854: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4855: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4856: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4857: raise OKC_API.G_EXCEPTION_ERROR;
4858: END IF;
4859: --+
4860: --+ remember header status for lines to follow it, not default
4861: --+

Line 4873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4869: p_k_num_mod => r_active.contract_number_modifier,
4870: p_update_minor_version =>'N',
4871: x_return_status => l_return_status);
4872:
4873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4874: p_error_from_line := 'Y';
4875: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4877: p_error_from_line := 'Y';

Line 4875: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4871: x_return_status => l_return_status);
4872:
4873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4874: p_error_from_line := 'Y';
4875: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4877: p_error_from_line := 'Y';
4878: raise OKC_API.G_EXCEPTION_ERROR;
4879: END IF;

Line 4876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4872:
4873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4874: p_error_from_line := 'Y';
4875: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4877: p_error_from_line := 'Y';
4878: raise OKC_API.G_EXCEPTION_ERROR;
4879: END IF;
4880: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 4878: raise OKC_API.G_EXCEPTION_ERROR;

4874: p_error_from_line := 'Y';
4875: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4876: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4877: p_error_from_line := 'Y';
4878: raise OKC_API.G_EXCEPTION_ERROR;
4879: END IF;
4880: header_message(p_knum_and_mod =>L_K_N_W_M,
4881: p_status =>h_new_status_m,
4882: p_old_status =>r_active.meaning,

Line 4886: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4882: p_old_status =>r_active.meaning,
4883: p_type =>'S');
4884: c := c+1;
4885: EXCEPTION
4886: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4887: header_message(p_knum_and_mod =>L_K_N_W_M,
4888: p_status =>h_new_status_m,
4889: p_old_status =>r_active.meaning,
4890: p_msg_data => x_msg_data,

Line 4898: WHEN OKC_API.G_EXCEPTION_ERROR THEN

4894: else
4895: p_error_from_line := 'N';
4896: end if;
4897: rollback to H_STATUS;
4898: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4899: header_message(p_knum_and_mod =>L_K_N_W_M,
4900: p_status =>h_new_status_m,
4901: p_old_status =>r_active.meaning,
4902: p_msg_data => x_msg_data,

Line 4940: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4936: c := 0;
4937: end if;
4938: savepoint H_STATUS;
4939: p_hdr_count:= p_hdr_count + 1;
4940: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4941: L_K_N_W_M := r_signed.K_N_W_M;
4942:
4943: l_new_status := null;
4944: l_new_status_m := null;

Line 4966: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4962: x_msg_count => x_msg_count,
4963: x_msg_data => x_msg_data,
4964: p_chrv_rec => l_chr_rec);
4965:
4966: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4967: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4968: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4969: raise OKC_API.G_EXCEPTION_ERROR;
4970: END IF;

Line 4967: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4963: x_msg_data => x_msg_data,
4964: p_chrv_rec => l_chr_rec);
4965:
4966: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4967: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4968: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4969: raise OKC_API.G_EXCEPTION_ERROR;
4970: END IF;
4971: --

Line 4968: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4964: p_chrv_rec => l_chr_rec);
4965:
4966: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4967: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4968: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4969: raise OKC_API.G_EXCEPTION_ERROR;
4970: END IF;
4971: --
4972: update_contract_header (

Line 4969: raise OKC_API.G_EXCEPTION_ERROR;

4965:
4966: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4967: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4968: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4969: raise OKC_API.G_EXCEPTION_ERROR;
4970: END IF;
4971: --
4972: update_contract_header (
4973: p_api_version => 1.0,

Line 4981: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4977: x_msg_data => x_msg_data,
4978: p_chrv_rec => l_chr_rec,
4979: x_chrv_rec => i_chr_rec);
4980:
4981: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4982: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4984: raise OKC_API.G_EXCEPTION_ERROR;
4985: END IF;

Line 4982: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4978: p_chrv_rec => l_chr_rec,
4979: x_chrv_rec => i_chr_rec);
4980:
4981: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4982: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4984: raise OKC_API.G_EXCEPTION_ERROR;
4985: END IF;
4986: --+

Line 4983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4979: x_chrv_rec => i_chr_rec);
4980:
4981: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4982: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4984: raise OKC_API.G_EXCEPTION_ERROR;
4985: END IF;
4986: --+
4987: --+ remember header status for lines to follow it, not default

Line 4984: raise OKC_API.G_EXCEPTION_ERROR;

4980:
4981: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4982: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4983: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
4984: raise OKC_API.G_EXCEPTION_ERROR;
4985: END IF;
4986: --+
4987: --+ remember header status for lines to follow it, not default
4988: --+

Line 5000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4996: p_k_num_mod => r_signed.contract_number_modifier,
4997: p_update_minor_version =>'N',
4998: x_return_status => l_return_status);
4999:
5000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5001: p_error_from_line := 'Y';
5002: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5004: p_error_from_line := 'Y';

Line 5002: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4998: x_return_status => l_return_status);
4999:
5000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5001: p_error_from_line := 'Y';
5002: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5004: p_error_from_line := 'Y';
5005: raise OKC_API.G_EXCEPTION_ERROR;
5006: END IF;

Line 5003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

4999:
5000: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5001: p_error_from_line := 'Y';
5002: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5004: p_error_from_line := 'Y';
5005: raise OKC_API.G_EXCEPTION_ERROR;
5006: END IF;
5007: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5005: raise OKC_API.G_EXCEPTION_ERROR;

5001: p_error_from_line := 'Y';
5002: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5003: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5004: p_error_from_line := 'Y';
5005: raise OKC_API.G_EXCEPTION_ERROR;
5006: END IF;
5007: header_message(p_knum_and_mod =>L_K_N_W_M,
5008: p_status =>h_new_status_m,
5009: p_old_status =>r_signed.meaning,

Line 5013: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5009: p_old_status =>r_signed.meaning,
5010: p_type =>'S');
5011: c := c+1;
5012: EXCEPTION
5013: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5014: header_message(p_knum_and_mod =>L_K_N_W_M,
5015: p_status =>h_new_status_m,
5016: p_old_status =>r_signed.meaning,
5017: p_msg_data => x_msg_data,

Line 5025: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5021: else
5022: p_error_from_line := 'N';
5023: end if;
5024: rollback to H_STATUS;
5025: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5026: header_message(p_knum_and_mod =>L_K_N_W_M,
5027: p_status =>h_new_status_m,
5028: p_old_status =>r_signed.meaning,
5029: p_msg_data => x_msg_data,

Line 5074: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5070: c := 0;
5071: end if;
5072: savepoint H_STATUS;
5073: p_hdr_count:= p_hdr_count + 1;
5074: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5075: L_K_N_W_M := r_terminated.K_N_W_M;
5076:
5077: l_new_status := null;
5078: l_new_status_m := null;

Line 5103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5099: x_return_status => l_return_status,
5100: x_msg_count => x_msg_count,
5101: x_msg_data => x_msg_data,
5102: p_chrv_rec => l_chr_rec);
5103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5104: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5106: raise OKC_API.G_EXCEPTION_ERROR;
5107: END IF;

Line 5104: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5100: x_msg_count => x_msg_count,
5101: x_msg_data => x_msg_data,
5102: p_chrv_rec => l_chr_rec);
5103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5104: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5106: raise OKC_API.G_EXCEPTION_ERROR;
5107: END IF;
5108: --

Line 5105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5101: x_msg_data => x_msg_data,
5102: p_chrv_rec => l_chr_rec);
5103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5104: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5106: raise OKC_API.G_EXCEPTION_ERROR;
5107: END IF;
5108: --
5109: --

Line 5106: raise OKC_API.G_EXCEPTION_ERROR;

5102: p_chrv_rec => l_chr_rec);
5103: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5104: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5105: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5106: raise OKC_API.G_EXCEPTION_ERROR;
5107: END IF;
5108: --
5109: --
5110: update_contract_header (

Line 5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5116: p_chrv_rec => l_chr_rec,
5117: x_chrv_rec => i_chr_rec);
5118: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5119:
5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5123: raise OKC_API.G_EXCEPTION_ERROR;
5124: END IF;

Line 5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5117: x_chrv_rec => i_chr_rec);
5118: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5119:
5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5123: raise OKC_API.G_EXCEPTION_ERROR;
5124: END IF;
5125:

Line 5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5118: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5119:
5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5123: raise OKC_API.G_EXCEPTION_ERROR;
5124: END IF;
5125:
5126: OKC_K_TERM_ASMBLR_PVT.acn_assemble(

Line 5123: raise OKC_API.G_EXCEPTION_ERROR;

5119:
5120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5121: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5123: raise OKC_API.G_EXCEPTION_ERROR;
5124: END IF;
5125:
5126: OKC_K_TERM_ASMBLR_PVT.acn_assemble(
5127: p_api_version => 1.0 ,

Line 5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5140: p_term_reason => r_terminated.termination_reason);
5141: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5142:
5143: --
5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5147: raise OKC_API.G_EXCEPTION_ERROR;
5148: END IF;

Line 5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5141: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5142:
5143: --
5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5147: raise OKC_API.G_EXCEPTION_ERROR;
5148: END IF;
5149: OKC_TIME_RES_PUB.res_time_termnt_k(

Line 5146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5142:
5143: --
5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5147: raise OKC_API.G_EXCEPTION_ERROR;
5148: END IF;
5149: OKC_TIME_RES_PUB.res_time_termnt_k(
5150: P_CHR_ID => r_terminated.id,

Line 5147: raise OKC_API.G_EXCEPTION_ERROR;

5143: --
5144: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5145: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5146: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5147: raise OKC_API.G_EXCEPTION_ERROR;
5148: END IF;
5149: OKC_TIME_RES_PUB.res_time_termnt_k(
5150: P_CHR_ID => r_terminated.id,
5151: P_CLE_ID => NULL,

Line 5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5156: );
5157:
5158: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5159:
5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5163: raise OKC_API.G_EXCEPTION_ERROR;
5164: END IF;

Line 5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5157:
5158: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5159:
5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5163: raise OKC_API.G_EXCEPTION_ERROR;
5164: END IF;
5165: --

Line 5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5158: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5159:
5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5163: raise OKC_API.G_EXCEPTION_ERROR;
5164: END IF;
5165: --
5166: --+

Line 5163: raise OKC_API.G_EXCEPTION_ERROR;

5159:
5160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5161: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5163: raise OKC_API.G_EXCEPTION_ERROR;
5164: END IF;
5165: --
5166: --+
5167: --+ remember header status for lines to follow it, not default

Line 5183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5179: x_return_status => l_return_status);
5180: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
5181:
5182:
5183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5184: p_error_from_line := 'Y';
5185: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5187: p_error_from_line := 'Y';

Line 5185: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5181:
5182:
5183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5184: p_error_from_line := 'Y';
5185: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5187: p_error_from_line := 'Y';
5188: raise OKC_API.G_EXCEPTION_ERROR;
5189: END IF;

Line 5186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5182:
5183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5184: p_error_from_line := 'Y';
5185: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5187: p_error_from_line := 'Y';
5188: raise OKC_API.G_EXCEPTION_ERROR;
5189: END IF;
5190: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5188: raise OKC_API.G_EXCEPTION_ERROR;

5184: p_error_from_line := 'Y';
5185: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5186: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5187: p_error_from_line := 'Y';
5188: raise OKC_API.G_EXCEPTION_ERROR;
5189: END IF;
5190: header_message(p_knum_and_mod =>L_K_N_W_M,
5191: p_old_status =>r_terminated.meaning,
5192: p_status =>h_new_status_m,

Line 5196: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5192: p_status =>h_new_status_m,
5193: p_type =>'S');
5194: c:= c+1;
5195: EXCEPTION
5196: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5197: header_message(p_knum_and_mod =>L_K_N_W_M,
5198: p_status =>h_new_status_m,
5199: p_old_status =>r_terminated.meaning,
5200: p_msg_data => x_msg_data,

Line 5208: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5204: else
5205: p_error_from_line := 'N';
5206: end if;
5207: rollback to H_STATUS;
5208: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5209: header_message(p_knum_and_mod =>L_K_N_W_M,
5210: p_status =>h_new_status_m,
5211: p_old_status =>r_terminated.meaning,
5212: p_msg_data => x_msg_data,

Line 5251: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5247: end if;
5248:
5249: savepoint H_STATUS;
5250: p_hdr_count:= p_hdr_count + 1;
5251: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5252: L_K_N_W_M := r_expired.K_N_W_M;
5253: l_new_status := null;
5254: l_new_status_m := null;
5255: h_status := null;

Line 5277: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5273: x_return_status => l_return_status,
5274: x_msg_count => x_msg_count,
5275: x_msg_data => x_msg_data,
5276: p_chrv_rec => l_chr_rec);
5277: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: raise OKC_API.G_EXCEPTION_ERROR;
5281: END IF;

Line 5278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5274: x_msg_count => x_msg_count,
5275: x_msg_data => x_msg_data,
5276: p_chrv_rec => l_chr_rec);
5277: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: raise OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --

Line 5279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5275: x_msg_data => x_msg_data,
5276: p_chrv_rec => l_chr_rec);
5277: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: raise OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --
5283: update_contract_header (

Line 5280: raise OKC_API.G_EXCEPTION_ERROR;

5276: p_chrv_rec => l_chr_rec);
5277: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: raise OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --
5283: update_contract_header (
5284: p_api_version => 1.0,

Line 5291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5287: x_msg_count => x_msg_count,
5288: x_msg_data => x_msg_data,
5289: p_chrv_rec => l_chr_rec,
5290: x_chrv_rec => i_chr_rec);
5291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5292: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5294: raise OKC_API.G_EXCEPTION_ERROR;
5295: END IF;

Line 5292: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5288: x_msg_data => x_msg_data,
5289: p_chrv_rec => l_chr_rec,
5290: x_chrv_rec => i_chr_rec);
5291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5292: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5294: raise OKC_API.G_EXCEPTION_ERROR;
5295: END IF;
5296: --+

Line 5293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5289: p_chrv_rec => l_chr_rec,
5290: x_chrv_rec => i_chr_rec);
5291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5292: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5294: raise OKC_API.G_EXCEPTION_ERROR;
5295: END IF;
5296: --+
5297: --+ remember header status for lines to follow it, not default

Line 5294: raise OKC_API.G_EXCEPTION_ERROR;

5290: x_chrv_rec => i_chr_rec);
5291: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5292: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5293: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5294: raise OKC_API.G_EXCEPTION_ERROR;
5295: END IF;
5296: --+
5297: --+ remember header status for lines to follow it, not default
5298: --+

Line 5308: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5304: p_k_num => r_expired.contract_number,
5305: p_k_num_mod => r_expired.contract_number_modifier,
5306: p_update_minor_version =>'N',
5307: x_return_status => l_return_status);
5308: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: p_error_from_line := 'Y';
5310: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5311: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5312: p_error_from_line := 'Y';

Line 5310: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5306: p_update_minor_version =>'N',
5307: x_return_status => l_return_status);
5308: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: p_error_from_line := 'Y';
5310: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5311: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5312: p_error_from_line := 'Y';
5313: raise OKC_API.G_EXCEPTION_ERROR;
5314: END IF;

Line 5311: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5307: x_return_status => l_return_status);
5308: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: p_error_from_line := 'Y';
5310: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5311: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5312: p_error_from_line := 'Y';
5313: raise OKC_API.G_EXCEPTION_ERROR;
5314: END IF;
5315: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5313: raise OKC_API.G_EXCEPTION_ERROR;

5309: p_error_from_line := 'Y';
5310: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5311: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5312: p_error_from_line := 'Y';
5313: raise OKC_API.G_EXCEPTION_ERROR;
5314: END IF;
5315: header_message(p_knum_and_mod =>L_K_N_W_M,
5316: p_status =>h_new_status_m,
5317: p_old_status =>r_expired.meaning,

Line 5322: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5318: p_type =>'S');
5319:
5320: c := c + 1;
5321: EXCEPTION
5322: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5323: header_message(p_knum_and_mod =>L_K_N_W_M,
5324: p_status =>h_new_status_m,
5325: p_old_status =>r_expired.meaning,
5326: p_msg_data => x_msg_data,

Line 5334: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5330: else
5331: p_error_from_line := 'N';
5332: end if;
5333: rollback to H_STATUS;
5334: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5335: header_message(p_knum_and_mod =>L_K_N_W_M,
5336: p_status =>h_new_status_m,
5337: p_old_status =>r_expired.meaning,
5338: p_msg_data => x_msg_data,

Line 5374: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5370: c := 0;
5371: end if;
5372: savepoint H_STATUS;
5373: p_hdr_count:= p_hdr_count + 1;
5374: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5375: L_K_N_W_M := r_active.K_N_W_M;
5376:
5377: l_new_status := null;
5378: l_new_status_m := null;

Line 5400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5396: x_msg_count => x_msg_count,
5397: x_msg_data => x_msg_data,
5398: p_chrv_rec => l_chr_rec);
5399:
5400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5401: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5403: raise OKC_API.G_EXCEPTION_ERROR;
5404: END IF;

Line 5401: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5397: x_msg_data => x_msg_data,
5398: p_chrv_rec => l_chr_rec);
5399:
5400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5401: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5403: raise OKC_API.G_EXCEPTION_ERROR;
5404: END IF;
5405: --

Line 5402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5398: p_chrv_rec => l_chr_rec);
5399:
5400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5401: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5403: raise OKC_API.G_EXCEPTION_ERROR;
5404: END IF;
5405: --
5406: update_contract_header (

Line 5403: raise OKC_API.G_EXCEPTION_ERROR;

5399:
5400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5401: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5403: raise OKC_API.G_EXCEPTION_ERROR;
5404: END IF;
5405: --
5406: update_contract_header (
5407: p_api_version => 1.0,

Line 5415: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5411: x_msg_data => x_msg_data,
5412: p_chrv_rec => l_chr_rec,
5413: x_chrv_rec => i_chr_rec);
5414:
5415: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5416: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5417: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5418: raise OKC_API.G_EXCEPTION_ERROR;
5419: END IF;

Line 5416: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5412: p_chrv_rec => l_chr_rec,
5413: x_chrv_rec => i_chr_rec);
5414:
5415: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5416: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5417: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5418: raise OKC_API.G_EXCEPTION_ERROR;
5419: END IF;
5420: --+

Line 5417: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5413: x_chrv_rec => i_chr_rec);
5414:
5415: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5416: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5417: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5418: raise OKC_API.G_EXCEPTION_ERROR;
5419: END IF;
5420: --+
5421: --+ remember header status for lines to follow it, not default

Line 5418: raise OKC_API.G_EXCEPTION_ERROR;

5414:
5415: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5416: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5417: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5418: raise OKC_API.G_EXCEPTION_ERROR;
5419: END IF;
5420: --+
5421: --+ remember header status for lines to follow it, not default
5422: --+

Line 5434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5430: p_k_num_mod => r_active.contract_number_modifier,
5431: p_update_minor_version =>'N',
5432: x_return_status => l_return_status);
5433:
5434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5435: p_error_from_line := 'Y';
5436: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5438: p_error_from_line := 'Y';

Line 5436: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5432: x_return_status => l_return_status);
5433:
5434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5435: p_error_from_line := 'Y';
5436: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5438: p_error_from_line := 'Y';
5439: raise OKC_API.G_EXCEPTION_ERROR;
5440: END IF;

Line 5437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5433:
5434: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5435: p_error_from_line := 'Y';
5436: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5438: p_error_from_line := 'Y';
5439: raise OKC_API.G_EXCEPTION_ERROR;
5440: END IF;
5441: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5439: raise OKC_API.G_EXCEPTION_ERROR;

5435: p_error_from_line := 'Y';
5436: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5437: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5438: p_error_from_line := 'Y';
5439: raise OKC_API.G_EXCEPTION_ERROR;
5440: END IF;
5441: header_message(p_knum_and_mod =>L_K_N_W_M,
5442: p_status =>h_new_status_m,
5443: p_old_status =>r_active.meaning,

Line 5447: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5443: p_old_status =>r_active.meaning,
5444: p_type =>'S');
5445: c := c+1;
5446: EXCEPTION
5447: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5448: header_message(p_knum_and_mod =>L_K_N_W_M,
5449: p_status =>h_new_status_m,
5450: p_old_status =>r_active.meaning,
5451: p_msg_data => x_msg_data,

Line 5459: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5455: else
5456: p_error_from_line := 'N';
5457: end if;
5458: rollback to H_STATUS;
5459: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5460: header_message(p_knum_and_mod =>L_K_N_W_M,
5461: p_status =>h_new_status_m,
5462: p_old_status =>r_active.meaning,
5463: p_msg_data => x_msg_data,

Line 5501: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5497: c := 0;
5498: end if;
5499: savepoint H_STATUS;
5500: p_hdr_count:= p_hdr_count + 1;
5501: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5502: L_K_N_W_M := r_signed.K_N_W_M;
5503:
5504: l_new_status := null;
5505: l_new_status_m := null;

Line 5527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5523: x_msg_count => x_msg_count,
5524: x_msg_data => x_msg_data,
5525: p_chrv_rec => l_chr_rec);
5526:
5527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5528: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5530: raise OKC_API.G_EXCEPTION_ERROR;
5531: END IF;

Line 5528: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5524: x_msg_data => x_msg_data,
5525: p_chrv_rec => l_chr_rec);
5526:
5527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5528: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5530: raise OKC_API.G_EXCEPTION_ERROR;
5531: END IF;
5532: --

Line 5529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5525: p_chrv_rec => l_chr_rec);
5526:
5527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5528: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5530: raise OKC_API.G_EXCEPTION_ERROR;
5531: END IF;
5532: --
5533: update_contract_header (

Line 5530: raise OKC_API.G_EXCEPTION_ERROR;

5526:
5527: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5528: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5529: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5530: raise OKC_API.G_EXCEPTION_ERROR;
5531: END IF;
5532: --
5533: update_contract_header (
5534: p_api_version => 1.0,

Line 5542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5538: x_msg_data => x_msg_data,
5539: p_chrv_rec => l_chr_rec,
5540: x_chrv_rec => i_chr_rec);
5541:
5542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5545: raise OKC_API.G_EXCEPTION_ERROR;
5546: END IF;

Line 5543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5539: p_chrv_rec => l_chr_rec,
5540: x_chrv_rec => i_chr_rec);
5541:
5542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5545: raise OKC_API.G_EXCEPTION_ERROR;
5546: END IF;
5547: --+

Line 5544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5540: x_chrv_rec => i_chr_rec);
5541:
5542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5545: raise OKC_API.G_EXCEPTION_ERROR;
5546: END IF;
5547: --+
5548: --+ remember header status for lines to follow it, not default

Line 5545: raise OKC_API.G_EXCEPTION_ERROR;

5541:
5542: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5543: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5544: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5545: raise OKC_API.G_EXCEPTION_ERROR;
5546: END IF;
5547: --+
5548: --+ remember header status for lines to follow it, not default
5549: --+

Line 5561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5557: p_k_num_mod => r_signed.contract_number_modifier,
5558: p_update_minor_version =>'N',
5559: x_return_status => l_return_status);
5560:
5561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5562: p_error_from_line := 'Y';
5563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5565: p_error_from_line := 'Y';

Line 5563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5559: x_return_status => l_return_status);
5560:
5561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5562: p_error_from_line := 'Y';
5563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5565: p_error_from_line := 'Y';
5566: raise OKC_API.G_EXCEPTION_ERROR;
5567: END IF;

Line 5564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5560:
5561: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5562: p_error_from_line := 'Y';
5563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5565: p_error_from_line := 'Y';
5566: raise OKC_API.G_EXCEPTION_ERROR;
5567: END IF;
5568: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5566: raise OKC_API.G_EXCEPTION_ERROR;

5562: p_error_from_line := 'Y';
5563: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5564: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5565: p_error_from_line := 'Y';
5566: raise OKC_API.G_EXCEPTION_ERROR;
5567: END IF;
5568: header_message(p_knum_and_mod =>L_K_N_W_M,
5569: p_status =>h_new_status_m,
5570: p_old_status =>r_signed.meaning,

Line 5574: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5570: p_old_status =>r_signed.meaning,
5571: p_type =>'S');
5572: c := c+1;
5573: EXCEPTION
5574: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5575: header_message(p_knum_and_mod =>L_K_N_W_M,
5576: p_status =>h_new_status_m,
5577: p_old_status =>r_signed.meaning,
5578: p_msg_data => x_msg_data,

Line 5586: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5582: else
5583: p_error_from_line := 'N';
5584: end if;
5585: rollback to H_STATUS;
5586: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5587: header_message(p_knum_and_mod =>L_K_N_W_M,
5588: p_status =>h_new_status_m,
5589: p_old_status =>r_signed.meaning,
5590: p_msg_data => x_msg_data,

Line 5634: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5630: c := 0;
5631: end if;
5632: savepoint H_STATUS;
5633: p_hdr_count:= p_hdr_count + 1;
5634: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5635: L_K_N_W_M := r_terminated.K_N_W_M;
5636:
5637: l_new_status := null;
5638: l_new_status_m := null;

Line 5663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5659: x_return_status => l_return_status,
5660: x_msg_count => x_msg_count,
5661: x_msg_data => x_msg_data,
5662: p_chrv_rec => l_chr_rec);
5663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5664: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5666: raise OKC_API.G_EXCEPTION_ERROR;
5667: END IF;

Line 5664: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5660: x_msg_count => x_msg_count,
5661: x_msg_data => x_msg_data,
5662: p_chrv_rec => l_chr_rec);
5663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5664: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5666: raise OKC_API.G_EXCEPTION_ERROR;
5667: END IF;
5668: --

Line 5665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5661: x_msg_data => x_msg_data,
5662: p_chrv_rec => l_chr_rec);
5663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5664: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5666: raise OKC_API.G_EXCEPTION_ERROR;
5667: END IF;
5668: --
5669: --

Line 5666: raise OKC_API.G_EXCEPTION_ERROR;

5662: p_chrv_rec => l_chr_rec);
5663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5664: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5665: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5666: raise OKC_API.G_EXCEPTION_ERROR;
5667: END IF;
5668: --
5669: --
5670: update_contract_header (

Line 5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5676: p_chrv_rec => l_chr_rec,
5677: x_chrv_rec => i_chr_rec);
5678: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5679:
5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5683: raise OKC_API.G_EXCEPTION_ERROR;
5684: END IF;

Line 5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5677: x_chrv_rec => i_chr_rec);
5678: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5679:
5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5683: raise OKC_API.G_EXCEPTION_ERROR;
5684: END IF;
5685:

Line 5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5678: FND_FILE.PUT_LINE(FND_FILE.LOG,'update_contract_header ' || l_return_status);
5679:
5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5683: raise OKC_API.G_EXCEPTION_ERROR;
5684: END IF;
5685:
5686: OKC_K_TERM_ASMBLR_PVT.acn_assemble(

Line 5683: raise OKC_API.G_EXCEPTION_ERROR;

5679:
5680: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5681: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5682: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5683: raise OKC_API.G_EXCEPTION_ERROR;
5684: END IF;
5685:
5686: OKC_K_TERM_ASMBLR_PVT.acn_assemble(
5687: p_api_version => 1.0 ,

Line 5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5700: p_term_reason => r_terminated.termination_reason);
5701: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5702:
5703: --
5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5707: raise OKC_API.G_EXCEPTION_ERROR;
5708: END IF;

Line 5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5701: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKC_K_TERM_ASMBLR_PVT ' || l_return_status);
5702:
5703: --
5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5707: raise OKC_API.G_EXCEPTION_ERROR;
5708: END IF;
5709: OKC_TIME_RES_PUB.res_time_termnt_k(

Line 5706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5702:
5703: --
5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5707: raise OKC_API.G_EXCEPTION_ERROR;
5708: END IF;
5709: OKC_TIME_RES_PUB.res_time_termnt_k(
5710: P_CHR_ID => r_terminated.id,

Line 5707: raise OKC_API.G_EXCEPTION_ERROR;

5703: --
5704: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5705: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5706: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5707: raise OKC_API.G_EXCEPTION_ERROR;
5708: END IF;
5709: OKC_TIME_RES_PUB.res_time_termnt_k(
5710: P_CHR_ID => r_terminated.id,
5711: P_CLE_ID => NULL,

Line 5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5716: );
5717:
5718: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5719:
5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: raise OKC_API.G_EXCEPTION_ERROR;
5724: END IF;

Line 5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5717:
5718: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5719:
5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: raise OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725: --

Line 5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5718: FND_FILE.PUT_LINE(FND_FILE.LOG,'res_time_termnt_k ' || l_return_status);
5719:
5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: raise OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725: --
5726: --+

Line 5723: raise OKC_API.G_EXCEPTION_ERROR;

5719:
5720: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5721: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5722: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5723: raise OKC_API.G_EXCEPTION_ERROR;
5724: END IF;
5725: --
5726: --+
5727: --+ remember header status for lines to follow it, not default

Line 5743: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5739: x_return_status => l_return_status);
5740: FND_FILE.PUT_LINE(FND_FILE.LOG,'line_status_change ' || l_return_status);
5741:
5742:
5743: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5744: p_error_from_line := 'Y';
5745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5747: p_error_from_line := 'Y';

Line 5745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5741:
5742:
5743: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5744: p_error_from_line := 'Y';
5745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5747: p_error_from_line := 'Y';
5748: raise OKC_API.G_EXCEPTION_ERROR;
5749: END IF;

Line 5746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5742:
5743: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5744: p_error_from_line := 'Y';
5745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5747: p_error_from_line := 'Y';
5748: raise OKC_API.G_EXCEPTION_ERROR;
5749: END IF;
5750: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5748: raise OKC_API.G_EXCEPTION_ERROR;

5744: p_error_from_line := 'Y';
5745: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5746: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5747: p_error_from_line := 'Y';
5748: raise OKC_API.G_EXCEPTION_ERROR;
5749: END IF;
5750: header_message(p_knum_and_mod =>L_K_N_W_M,
5751: p_old_status =>r_terminated.meaning,
5752: p_status =>h_new_status_m,

Line 5756: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5752: p_status =>h_new_status_m,
5753: p_type =>'S');
5754: c:= c+1;
5755: EXCEPTION
5756: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5757: header_message(p_knum_and_mod =>L_K_N_W_M,
5758: p_status =>h_new_status_m,
5759: p_old_status =>r_terminated.meaning,
5760: p_msg_data => x_msg_data,

Line 5768: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5764: else
5765: p_error_from_line := 'N';
5766: end if;
5767: rollback to H_STATUS;
5768: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5769: header_message(p_knum_and_mod =>L_K_N_W_M,
5770: p_status =>h_new_status_m,
5771: p_old_status =>r_terminated.meaning,
5772: p_msg_data => x_msg_data,

Line 5811: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5807: end if;
5808:
5809: savepoint H_STATUS;
5810: p_hdr_count:= p_hdr_count + 1;
5811: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5812: L_K_N_W_M := r_expired.K_N_W_M;
5813: l_new_status := null;
5814: l_new_status_m := null;
5815: h_status := null;

Line 5837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5833: x_return_status => l_return_status,
5834: x_msg_count => x_msg_count,
5835: x_msg_data => x_msg_data,
5836: p_chrv_rec => l_chr_rec);
5837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5838: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5840: raise OKC_API.G_EXCEPTION_ERROR;
5841: END IF;

Line 5838: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5834: x_msg_count => x_msg_count,
5835: x_msg_data => x_msg_data,
5836: p_chrv_rec => l_chr_rec);
5837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5838: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5840: raise OKC_API.G_EXCEPTION_ERROR;
5841: END IF;
5842: --

Line 5839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5835: x_msg_data => x_msg_data,
5836: p_chrv_rec => l_chr_rec);
5837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5838: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5840: raise OKC_API.G_EXCEPTION_ERROR;
5841: END IF;
5842: --
5843: update_contract_header (

Line 5840: raise OKC_API.G_EXCEPTION_ERROR;

5836: p_chrv_rec => l_chr_rec);
5837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5838: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5840: raise OKC_API.G_EXCEPTION_ERROR;
5841: END IF;
5842: --
5843: update_contract_header (
5844: p_api_version => 1.0,

Line 5851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5847: x_msg_count => x_msg_count,
5848: x_msg_data => x_msg_data,
5849: p_chrv_rec => l_chr_rec,
5850: x_chrv_rec => i_chr_rec);
5851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5854: raise OKC_API.G_EXCEPTION_ERROR;
5855: END IF;

Line 5852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5848: x_msg_data => x_msg_data,
5849: p_chrv_rec => l_chr_rec,
5850: x_chrv_rec => i_chr_rec);
5851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5854: raise OKC_API.G_EXCEPTION_ERROR;
5855: END IF;
5856: --+

Line 5853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5849: p_chrv_rec => l_chr_rec,
5850: x_chrv_rec => i_chr_rec);
5851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5854: raise OKC_API.G_EXCEPTION_ERROR;
5855: END IF;
5856: --+
5857: --+ remember header status for lines to follow it, not default

Line 5854: raise OKC_API.G_EXCEPTION_ERROR;

5850: x_chrv_rec => i_chr_rec);
5851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5852: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5854: raise OKC_API.G_EXCEPTION_ERROR;
5855: END IF;
5856: --+
5857: --+ remember header status for lines to follow it, not default
5858: --+

Line 5868: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5864: p_k_num => r_expired.contract_number,
5865: p_k_num_mod => r_expired.contract_number_modifier,
5866: p_update_minor_version =>'N',
5867: x_return_status => l_return_status);
5868: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5869: p_error_from_line := 'Y';
5870: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5871: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5872: p_error_from_line := 'Y';

Line 5870: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5866: p_update_minor_version =>'N',
5867: x_return_status => l_return_status);
5868: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5869: p_error_from_line := 'Y';
5870: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5871: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5872: p_error_from_line := 'Y';
5873: raise OKC_API.G_EXCEPTION_ERROR;
5874: END IF;

Line 5871: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5867: x_return_status => l_return_status);
5868: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5869: p_error_from_line := 'Y';
5870: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5871: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5872: p_error_from_line := 'Y';
5873: raise OKC_API.G_EXCEPTION_ERROR;
5874: END IF;
5875: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5873: raise OKC_API.G_EXCEPTION_ERROR;

5869: p_error_from_line := 'Y';
5870: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5871: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5872: p_error_from_line := 'Y';
5873: raise OKC_API.G_EXCEPTION_ERROR;
5874: END IF;
5875: header_message(p_knum_and_mod =>L_K_N_W_M,
5876: p_status =>h_new_status_m,
5877: p_old_status =>r_expired.meaning,

Line 5882: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5878: p_type =>'S');
5879:
5880: c := c + 1;
5881: EXCEPTION
5882: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5883: header_message(p_knum_and_mod =>L_K_N_W_M,
5884: p_status =>h_new_status_m,
5885: p_old_status =>r_expired.meaning,
5886: p_msg_data => x_msg_data,

Line 5894: WHEN OKC_API.G_EXCEPTION_ERROR THEN

5890: else
5891: p_error_from_line := 'N';
5892: end if;
5893: rollback to H_STATUS;
5894: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5895: header_message(p_knum_and_mod =>L_K_N_W_M,
5896: p_status =>h_new_status_m,
5897: p_old_status =>r_expired.meaning,
5898: p_msg_data => x_msg_data,

Line 5934: l_return_status := OKC_API.G_RET_STS_SUCCESS;

5930: c := 0;
5931: end if;
5932: savepoint H_STATUS;
5933: p_hdr_count:= p_hdr_count + 1;
5934: l_return_status := OKC_API.G_RET_STS_SUCCESS;
5935: L_K_N_W_M := r_active.K_N_W_M;
5936:
5937: l_new_status := null;
5938: l_new_status_m := null;

Line 5960: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5956: x_msg_count => x_msg_count,
5957: x_msg_data => x_msg_data,
5958: p_chrv_rec => l_chr_rec);
5959:
5960: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5962: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5963: raise OKC_API.G_EXCEPTION_ERROR;
5964: END IF;

Line 5961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5957: x_msg_data => x_msg_data,
5958: p_chrv_rec => l_chr_rec);
5959:
5960: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5962: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5963: raise OKC_API.G_EXCEPTION_ERROR;
5964: END IF;
5965: --

Line 5962: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5958: p_chrv_rec => l_chr_rec);
5959:
5960: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5962: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5963: raise OKC_API.G_EXCEPTION_ERROR;
5964: END IF;
5965: --
5966: update_contract_header (

Line 5963: raise OKC_API.G_EXCEPTION_ERROR;

5959:
5960: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5961: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5962: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5963: raise OKC_API.G_EXCEPTION_ERROR;
5964: END IF;
5965: --
5966: update_contract_header (
5967: p_api_version => 1.0,

Line 5975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5971: x_msg_data => x_msg_data,
5972: p_chrv_rec => l_chr_rec,
5973: x_chrv_rec => i_chr_rec);
5974:
5975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5976: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5978: raise OKC_API.G_EXCEPTION_ERROR;
5979: END IF;

Line 5976: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5972: p_chrv_rec => l_chr_rec,
5973: x_chrv_rec => i_chr_rec);
5974:
5975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5976: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5978: raise OKC_API.G_EXCEPTION_ERROR;
5979: END IF;
5980: --+

Line 5977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5973: x_chrv_rec => i_chr_rec);
5974:
5975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5976: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5978: raise OKC_API.G_EXCEPTION_ERROR;
5979: END IF;
5980: --+
5981: --+ remember header status for lines to follow it, not default

Line 5978: raise OKC_API.G_EXCEPTION_ERROR;

5974:
5975: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5976: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5977: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5978: raise OKC_API.G_EXCEPTION_ERROR;
5979: END IF;
5980: --+
5981: --+ remember header status for lines to follow it, not default
5982: --+

Line 5994: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5990: p_k_num_mod => r_active.contract_number_modifier,
5991: p_update_minor_version =>'N',
5992: x_return_status => l_return_status);
5993:
5994: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5995: p_error_from_line := 'Y';
5996: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5998: p_error_from_line := 'Y';

Line 5996: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5992: x_return_status => l_return_status);
5993:
5994: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5995: p_error_from_line := 'Y';
5996: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5998: p_error_from_line := 'Y';
5999: raise OKC_API.G_EXCEPTION_ERROR;
6000: END IF;

Line 5997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

5993:
5994: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5995: p_error_from_line := 'Y';
5996: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5998: p_error_from_line := 'Y';
5999: raise OKC_API.G_EXCEPTION_ERROR;
6000: END IF;
6001: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 5999: raise OKC_API.G_EXCEPTION_ERROR;

5995: p_error_from_line := 'Y';
5996: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5997: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5998: p_error_from_line := 'Y';
5999: raise OKC_API.G_EXCEPTION_ERROR;
6000: END IF;
6001: header_message(p_knum_and_mod =>L_K_N_W_M,
6002: p_status =>h_new_status_m,
6003: p_old_status =>r_active.meaning,

Line 6007: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

6003: p_old_status =>r_active.meaning,
6004: p_type =>'S');
6005: c := c+1;
6006: EXCEPTION
6007: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6008: header_message(p_knum_and_mod =>L_K_N_W_M,
6009: p_status =>h_new_status_m,
6010: p_old_status =>r_active.meaning,
6011: p_msg_data => x_msg_data,

Line 6019: WHEN OKC_API.G_EXCEPTION_ERROR THEN

6015: else
6016: p_error_from_line := 'N';
6017: end if;
6018: rollback to H_STATUS;
6019: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6020: header_message(p_knum_and_mod =>L_K_N_W_M,
6021: p_status =>h_new_status_m,
6022: p_old_status =>r_active.meaning,
6023: p_msg_data => x_msg_data,

Line 6061: l_return_status := OKC_API.G_RET_STS_SUCCESS;

6057: c := 0;
6058: end if;
6059: savepoint H_STATUS;
6060: p_hdr_count:= p_hdr_count + 1;
6061: l_return_status := OKC_API.G_RET_STS_SUCCESS;
6062: L_K_N_W_M := r_signed.K_N_W_M;
6063:
6064: l_new_status := null;
6065: l_new_status_m := null;

Line 6087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6083: x_msg_count => x_msg_count,
6084: x_msg_data => x_msg_data,
6085: p_chrv_rec => l_chr_rec);
6086:
6087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6088: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6090: raise OKC_API.G_EXCEPTION_ERROR;
6091: END IF;

Line 6088: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6084: x_msg_data => x_msg_data,
6085: p_chrv_rec => l_chr_rec);
6086:
6087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6088: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6090: raise OKC_API.G_EXCEPTION_ERROR;
6091: END IF;
6092: --

Line 6089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

6085: p_chrv_rec => l_chr_rec);
6086:
6087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6088: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6090: raise OKC_API.G_EXCEPTION_ERROR;
6091: END IF;
6092: --
6093: update_contract_header (

Line 6090: raise OKC_API.G_EXCEPTION_ERROR;

6086:
6087: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6088: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6089: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6090: raise OKC_API.G_EXCEPTION_ERROR;
6091: END IF;
6092: --
6093: update_contract_header (
6094: p_api_version => 1.0,

Line 6102: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6098: x_msg_data => x_msg_data,
6099: p_chrv_rec => l_chr_rec,
6100: x_chrv_rec => i_chr_rec);
6101:
6102: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6103: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6105: raise OKC_API.G_EXCEPTION_ERROR;
6106: END IF;

Line 6103: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6099: p_chrv_rec => l_chr_rec,
6100: x_chrv_rec => i_chr_rec);
6101:
6102: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6103: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6105: raise OKC_API.G_EXCEPTION_ERROR;
6106: END IF;
6107: --+

Line 6104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

6100: x_chrv_rec => i_chr_rec);
6101:
6102: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6103: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6105: raise OKC_API.G_EXCEPTION_ERROR;
6106: END IF;
6107: --+
6108: --+ remember header status for lines to follow it, not default

Line 6105: raise OKC_API.G_EXCEPTION_ERROR;

6101:
6102: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6103: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6104: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6105: raise OKC_API.G_EXCEPTION_ERROR;
6106: END IF;
6107: --+
6108: --+ remember header status for lines to follow it, not default
6109: --+

Line 6121: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

6117: p_k_num_mod => r_signed.contract_number_modifier,
6118: p_update_minor_version =>'N',
6119: x_return_status => l_return_status);
6120:
6121: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6122: p_error_from_line := 'Y';
6123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6125: p_error_from_line := 'Y';

Line 6123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

6119: x_return_status => l_return_status);
6120:
6121: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6122: p_error_from_line := 'Y';
6123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6125: p_error_from_line := 'Y';
6126: raise OKC_API.G_EXCEPTION_ERROR;
6127: END IF;

Line 6124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

6120:
6121: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
6122: p_error_from_line := 'Y';
6123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6125: p_error_from_line := 'Y';
6126: raise OKC_API.G_EXCEPTION_ERROR;
6127: END IF;
6128: header_message(p_knum_and_mod =>L_K_N_W_M,

Line 6126: raise OKC_API.G_EXCEPTION_ERROR;

6122: p_error_from_line := 'Y';
6123: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6124: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
6125: p_error_from_line := 'Y';
6126: raise OKC_API.G_EXCEPTION_ERROR;
6127: END IF;
6128: header_message(p_knum_and_mod =>L_K_N_W_M,
6129: p_status =>h_new_status_m,
6130: p_old_status =>r_signed.meaning,

Line 6134: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

6130: p_old_status =>r_signed.meaning,
6131: p_type =>'S');
6132: c := c+1;
6133: EXCEPTION
6134: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
6135: header_message(p_knum_and_mod =>L_K_N_W_M,
6136: p_status =>h_new_status_m,
6137: p_old_status =>r_signed.meaning,
6138: p_msg_data => x_msg_data,

Line 6146: WHEN OKC_API.G_EXCEPTION_ERROR THEN

6142: else
6143: p_error_from_line := 'N';
6144: end if;
6145: rollback to H_STATUS;
6146: WHEN OKC_API.G_EXCEPTION_ERROR THEN
6147: header_message(p_knum_and_mod =>L_K_N_W_M,
6148: p_status =>h_new_status_m,
6149: p_old_status =>r_signed.meaning,
6150: p_msg_data => x_msg_data,