eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_COPY_CONTRACT_PVT dependencies on OKL_API

Line 23: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

19: --Procedure copy_governances - Makes a copy of the okc_governances.
20: --------------------------------------------------------------------------
21: PROCEDURE copy_governances(
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_count OUT NOCOPY NUMBER,
26: x_msg_data OUT NOCOPY VARCHAR2,
27: p_from_chr_id IN NUMBER,

Line 32: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

28: p_to_chr_id IN NUMBER) IS
29:
30: l_gvev_rec gvev_rec_type;
31: x_gvev_rec gvev_rec_type;
32: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
33:
34: CURSOR c_governances IS
35: SELECT id
36: FROM okc_governances_v

Line 46: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

42: ----------------------------------------------------------------------------
43: FUNCTION get_gvev_rec(p_gve_id IN NUMBER,
44: x_gvev_rec OUT NOCOPY gvev_rec_type)
45: RETURN VARCHAR2 IS
46: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
47: l_no_data_found BOOLEAN := TRUE;
48:
49: CURSOR c_gvev_rec IS
50: SELECT DNZ_CHR_ID,

Line 73: l_return_status := OKL_API.G_RET_STS_ERROR;

69:
70: l_no_data_found := c_gvev_rec%NOTFOUND;
71: CLOSE c_gvev_rec;
72: IF l_no_data_found THEN
73: l_return_status := OKL_API.G_RET_STS_ERROR;
74: return(l_return_status);
75: ELSE
76: return(l_return_status);
77: END IF;

Line 81: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

77: END IF;
78: EXCEPTION
79: WHEN OTHERS THEN
80: -- store SQL error message on message stack for caller
81: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
82: p_msg_name => g_unexpected_error,
83: p_token1 => g_sqlcode_token,
84: p_token1_value => SQLCODE,
85: p_token2 => g_sqlerrm_token,

Line 89: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

85: p_token2 => g_sqlerrm_token,
86: p_token2_value => SQLERRM);
87:
88: -- notify caller of an UNEXPECTED error
89: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
90: return(l_return_status);
91:
92: END get_gvev_rec;
93: BEGIN

Line 100: IF(l_return_status = OKL_API.G_RET_STS_SUCCESS)THEN

96: l_return_status := get_gvev_rec( p_gve_id => l_c_governances.id,
97: x_gvev_rec => l_gvev_rec);
98: l_gvev_rec.chr_id := p_to_chr_id;
99: l_gvev_rec.dnz_chr_id := p_to_chr_id;
100: IF(l_return_status = OKL_API.G_RET_STS_SUCCESS)THEN
101: OKC_CONTRACT_PUB.create_governance(
102: p_api_version => p_api_version,
103: p_init_msg_list => p_init_msg_list,
104: x_return_status => l_return_status,

Line 109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_gvev_rec => l_gvev_rec,
108: x_gvev_rec => x_gvev_rec);
109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: x_return_status := l_return_status;
112: RAISE G_EXCEPTION_HALT_VALIDATION;
113: ELSE

Line 110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

106: x_msg_data => x_msg_data,
107: p_gvev_rec => l_gvev_rec,
108: x_gvev_rec => x_gvev_rec);
109: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
110: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
111: x_return_status := l_return_status;
112: RAISE G_EXCEPTION_HALT_VALIDATION;
113: ELSE
114: x_return_status := l_return_status;

Line 125: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

121: WHEN G_EXCEPTION_HALT_VALIDATION THEN
122: NULL;
123: WHEN OTHERS THEN
124: -- store SQL error message on message stack for caller
125: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
126: p_msg_name => g_unexpected_error,
127: p_token1 => g_sqlcode_token,
128: p_token1_value => SQLCODE,
129: p_token2 => g_sqlerrm_token,

Line 133: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

129: p_token2 => g_sqlerrm_token,
130: p_token2_value => SQLERRM);
131:
132: -- notify caller of an UNEXPECTED error
133: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
134:
135: END copy_governances;
136:
137:

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

178: END is_copy_allowed;
179:
180:
181: PROCEDURE copy_contract(p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_copy_rec IN copy_header_rec_type,

Line 203: l2_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

199: l_from_agreement_number varchar2(120);
200: l_to_agreement_number varchar2(120);
201: l_template_yn varchar2(3);
202: l1_return_status varchar2(3);
203: l2_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
204: l_dummy VARCHAR2(1);
205: l_found BOOLEAN;
206: l_process_id NUMBER;
207:

Line 307: x_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name

303: i NUMBER;
304: j NUMBER;
305:
306: BEGIN
307: x_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name
308: ,p_init_msg_list => p_init_msg_list
309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );

Line 312: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

308: ,p_init_msg_list => p_init_msg_list
309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );
312: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;

Line 313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

309: ,p_api_type => '_PVT'
310: ,x_return_status => x_return_status
311: );
312: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:

Line 314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

310: ,x_return_status => x_return_status
311: );
312: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 315: RAISE OKL_API.G_EXCEPTION_ERROR;

311: );
312: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:

Line 318: x_return_status := OKL_API.G_RET_STS_SUCCESS;

314: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
315: RAISE OKL_API.G_EXCEPTION_ERROR;
316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:
320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN
321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');
322: x_return_status :=okl_api.g_ret_sts_error;

Line 320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN

316: END IF;
317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:
320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN
321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');
322: x_return_status :=okl_api.g_ret_sts_error;
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;

Line 321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');

317:
318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:
320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN
321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');
322: x_return_status :=okl_api.g_ret_sts_error;
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:

Line 322: x_return_status :=okl_api.g_ret_sts_error;

318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
319:
320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN
321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');
322: x_return_status :=okl_api.g_ret_sts_error;
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: l_contract_id :=p_copy_rec.p_id;

Line 323: RAISE OKL_API.G_EXCEPTION_ERROR;

319:
320: IF((p_copy_rec.p_to_agreement_number = OKL_API.G_MISS_CHAR) OR (p_copy_rec.p_to_agreement_number IS NULL)) THEN
321: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_COPY_TO_NO_REQD');
322: x_return_status :=okl_api.g_ret_sts_error;
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: l_contract_id :=p_copy_rec.p_id;
327: l_to_agreement_number :=p_copy_rec.p_to_agreement_number;

Line 341: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

337: l_found := l_chr_csr2%FOUND;
338: close l_chr_csr2;
339:
340: If (l_found) Then
341: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
342: p_msg_name => 'OKL_VP_CONTRACT_EXISTS',
343: p_token1 => 'NUMBER',
344: p_token1_value => p_copy_rec.p_to_agreement_number
345: );

Line 346: RAISE OKL_API.G_EXCEPTION_ERROR;

342: p_msg_name => 'OKL_VP_CONTRACT_EXISTS',
343: p_token1 => 'NUMBER',
344: p_token1_value => p_copy_rec.p_to_agreement_number
345: );
346: RAISE OKL_API.G_EXCEPTION_ERROR;
347: end if;
348:
349: l_copy_allowed :=is_copy_allowed(l_contract_id,l_sts_code);
350:

Line 368: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

364: p_to_template_yn => l_template_yn,
365: p_renew_ref_yn => 'N',
366: p_override_org => 'Y',
367: x_chr_id => l_chr_id);
368: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;

Line 369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

365: p_renew_ref_yn => 'N',
366: p_override_org => 'Y',
367: x_chr_id => l_chr_id);
368: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373:

Line 370: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

366: p_override_org => 'Y',
367: x_chr_id => l_chr_id);
368: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: --abhsxen bug 6487870 start

Line 371: RAISE OKL_API.G_EXCEPTION_ERROR;

367: x_chr_id => l_chr_id);
368: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: --abhsxen bug 6487870 start
375:

Line 380: OKL_API.set_message(p_app_name => g_app_name,

376: OPEN cur_k_party_roles(l_chr_id);
377: FETCH cur_k_party_roles INTO l_party_id;
378: IF (cur_k_party_roles%NOTFOUND) THEN
379: CLOSE cur_k_party_roles;
380: OKL_API.set_message(p_app_name => g_app_name,
381: p_msg_name => 'OKL_JTOT_CODE_NOT_FOUND'
382: );
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;

Line 383: RAISE OKL_API.G_EXCEPTION_ERROR;

379: CLOSE cur_k_party_roles;
380: OKL_API.set_message(p_app_name => g_app_name,
381: p_msg_name => 'OKL_JTOT_CODE_NOT_FOUND'
382: );
383: RAISE OKL_API.G_EXCEPTION_ERROR;
384: END IF;
385: CLOSE cur_k_party_roles;
386:
387: l_kplv_rec.ID :=l_party_id;

Line 398: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

394: x_msg_data => x_msg_data,
395: p_kplv_rec => l_kplv_rec,
396: x_kplv_rec => x_kplv_rec);
397:
398: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
401: RAISE OKL_API.G_EXCEPTION_ERROR;
402: END IF;

Line 399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

395: p_kplv_rec => l_kplv_rec,
396: x_kplv_rec => x_kplv_rec);
397:
398: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
401: RAISE OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403: --abhsxen bug 6487870 end

Line 400: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

396: x_kplv_rec => x_kplv_rec);
397:
398: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
401: RAISE OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403: --abhsxen bug 6487870 end
404:

Line 401: RAISE OKL_API.G_EXCEPTION_ERROR;

397:
398: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
400: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
401: RAISE OKL_API.G_EXCEPTION_ERROR;
402: END IF;
403: --abhsxen bug 6487870 end
404:
405: -- copy governances

Line 415: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

411: ,x_msg_data => x_msg_data
412: ,p_from_chr_id => l_contract_id
413: ,p_to_chr_id => l_chr_id
414: );
415: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
417: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;

Line 416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

412: ,p_from_chr_id => l_contract_id
413: ,p_to_chr_id => l_chr_id
414: );
415: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
417: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420:

Line 417: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

413: ,p_to_chr_id => l_chr_id
414: );
415: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
417: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420:
421: -- fmiao copy pa associations --

Line 418: RAISE OKL_API.G_EXCEPTION_ERROR;

414: );
415: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
416: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
417: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420:
421: -- fmiao copy pa associations --
422: OPEN copy_pa_assoc_csr (l_contract_id);

Line 474: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

470: ,p_cpl_id => l_cpl_id
471: ,p_rrd_id => l_rrd_id
472: ,p_rgr_tbl => l_rgr_tbl_type
473: );
474: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_ERROR;
478: END IF;

Line 475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

471: ,p_rrd_id => l_rrd_id
472: ,p_rgr_tbl => l_rgr_tbl_type
473: );
474: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_ERROR;
478: END IF;
479: END IF;

Line 476: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

472: ,p_rgr_tbl => l_rgr_tbl_type
473: );
474: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_ERROR;
478: END IF;
479: END IF;
480: -- end rules group updation --

Line 477: RAISE OKL_API.G_EXCEPTION_ERROR;

473: );
474: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
476: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
477: RAISE OKL_API.G_EXCEPTION_ERROR;
478: END IF;
479: END IF;
480: -- end rules group updation --
481:

Line 499: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

495: ,x_ecl_tbl => lx_ecl_tbl
496: ,x_ecv_tbl => lx_ecv_tbl
497: );
498:
499: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;

Line 500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

496: ,x_ecv_tbl => lx_ecv_tbl
497: );
498:
499: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504:

Line 501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

497: );
498:
499: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504:
505: IF(lx_ecl_tbl.count > 0)THEN

Line 502: RAISE OKL_API.G_EXCEPTION_ERROR;

498:
499: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504:
505: IF(lx_ecl_tbl.count > 0)THEN
506: -- set the eligibility criteria headers id to the original agreement id

Line 542: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

538: ,p_ech_rec => lx_ech_rec -- IN
539: ,p_ecl_tbl => lx_ecl_tbl -- IN
540: ,p_ecv_tbl => lx_ecv_tbl -- IN
541: );
542: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;

Line 543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

539: ,p_ecl_tbl => lx_ecl_tbl -- IN
540: ,p_ecv_tbl => lx_ecv_tbl -- IN
541: );
542: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: END IF;

Line 544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

540: ,p_ecv_tbl => lx_ecv_tbl -- IN
541: );
542: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: END IF;
548: -- abindal end copy eligibility criteria --

Line 545: RAISE OKL_API.G_EXCEPTION_ERROR;

541: );
542: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547: END IF;
548: -- abindal end copy eligibility criteria --
549:

Line 552: IF(x_return_status = OKL_API.G_RET_STS_SUCCESS) Then

548: -- abindal end copy eligibility criteria --
549:
550:
551: -- Murthy commented out code for count governances
552: IF(x_return_status = OKL_API.G_RET_STS_SUCCESS) Then
553: x_new_contract_id :=l_chr_id;
554: -- updating to set new contract to status NEW
555:
556: l1_header_rec.id := l_chr_id;

Line 564: p_init_msg_list => OKL_API.G_TRUE,

560:
561: OKC_CONTRACT_PUB.update_contract_header(
562: p_api_version => l_api_version,
563: x_return_status => x_return_status,
564: p_init_msg_list => OKL_API.G_TRUE,
565: x_msg_count => x_msg_count,
566: x_msg_data => x_msg_data,
567: p_restricted_update => OKL_API.G_FALSE,
568: p_chrv_rec => l1_header_rec,

Line 567: p_restricted_update => OKL_API.G_FALSE,

563: x_return_status => x_return_status,
564: p_init_msg_list => OKL_API.G_TRUE,
565: x_msg_count => x_msg_count,
566: x_msg_data => x_msg_data,
567: p_restricted_update => OKL_API.G_FALSE,
568: p_chrv_rec => l1_header_rec,
569: x_chrv_rec => l2_header_rec);
570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

566: x_msg_data => x_msg_data,
567: p_restricted_update => OKL_API.G_FALSE,
568: p_chrv_rec => l1_header_rec,
569: x_chrv_rec => l2_header_rec);
570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
573: RAISE OKL_API.G_EXCEPTION_ERROR;
574: END IF;

Line 571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

567: p_restricted_update => OKL_API.G_FALSE,
568: p_chrv_rec => l1_header_rec,
569: x_chrv_rec => l2_header_rec);
570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
573: RAISE OKL_API.G_EXCEPTION_ERROR;
574: END IF;
575:

Line 572: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

568: p_chrv_rec => l1_header_rec,
569: x_chrv_rec => l2_header_rec);
570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
573: RAISE OKL_API.G_EXCEPTION_ERROR;
574: END IF;
575:
576: IF (l_template_yn = 'Y') THEN

Line 573: RAISE OKL_API.G_EXCEPTION_ERROR;

569: x_chrv_rec => l2_header_rec);
570: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
571: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
572: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
573: RAISE OKL_API.G_EXCEPTION_ERROR;
574: END IF;
575:
576: IF (l_template_yn = 'Y') THEN
577: -- If template is yes, do not create workflow process. Since it

Line 594: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data,
592: p_cpsv_rec => l_cpsv_rec);
593: -- okl delete contract process api failed
594: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;

Line 595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

591: x_msg_data => x_msg_data,
592: p_cpsv_rec => l_cpsv_rec);
593: -- okl delete contract process api failed
594: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599: END IF;

Line 596: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

592: p_cpsv_rec => l_cpsv_rec);
593: -- okl delete contract process api failed
594: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599: END IF;
600: END IF;

Line 597: RAISE OKL_API.G_EXCEPTION_ERROR;

593: -- okl delete contract process api failed
594: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599: END IF;
600: END IF;
601: ELSE

Line 603: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

599: END IF;
600: END IF;
601: ELSE
602: -- okl copy contract api failed
603: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;

Line 604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

600: END IF;
601: ELSE
602: -- okl copy contract api failed
603: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608: END IF;

Line 605: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

601: ELSE
602: -- okl copy contract api failed
603: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608: END IF;
609: ELSE

Line 606: RAISE OKL_API.G_EXCEPTION_ERROR;

602: -- okl copy contract api failed
603: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
606: RAISE OKL_API.G_EXCEPTION_ERROR;
607: END IF;
608: END IF;
609: ELSE
610: -- copy is not allowed as it is a template

Line 611: x_return_status :=OKL_API.G_RET_STS_ERROR;

607: END IF;
608: END IF;
609: ELSE
610: -- copy is not allowed as it is a template
611: x_return_status :=OKL_API.G_RET_STS_ERROR;
612: OKC_API.SET_MESSAGE('OKL','OKL_INVALID_TEMPLATE');
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: CLOSE cur_k_header;

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609: ELSE
610: -- copy is not allowed as it is a template
611: x_return_status :=OKL_API.G_RET_STS_ERROR;
612: OKC_API.SET_MESSAGE('OKL','OKL_INVALID_TEMPLATE');
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615: CLOSE cur_k_header;
616: ELSE
617: NULL;

Line 620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count ,x_msg_data => x_msg_data );

616: ELSE
617: NULL;
618: CLOSE cur_k_header;
619: END IF;
620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count ,x_msg_data => x_msg_data );
621:
622: EXCEPTION
623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 623: WHEN OKL_API.G_EXCEPTION_ERROR THEN

619: END IF;
620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count ,x_msg_data => x_msg_data );
621:
622: EXCEPTION
623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
625: (p_api_name => l_api_name
626: ,p_pkg_name => G_PKG_NAME
627: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

Line 624: x_return_status := OKL_API.HANDLE_EXCEPTIONS

620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count ,x_msg_data => x_msg_data );
621:
622: EXCEPTION
623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
625: (p_api_name => l_api_name
626: ,p_pkg_name => G_PKG_NAME
627: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
628: ,x_msg_count => x_msg_count

Line 627: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
624: x_return_status := OKL_API.HANDLE_EXCEPTIONS
625: (p_api_name => l_api_name
626: ,p_pkg_name => G_PKG_NAME
627: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
628: ,x_msg_count => x_msg_count
629: ,x_msg_data => x_msg_data
630: ,p_api_type => '_PVT'
631: );

Line 633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

629: ,x_msg_data => x_msg_data
630: ,p_api_type => '_PVT'
631: );
632:
633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
635: ,g_pkg_name
636: ,'OKL_API.G_RET_STS_ERROR'
637: ,x_msg_count

Line 634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

630: ,p_api_type => '_PVT'
631: );
632:
633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
635: ,g_pkg_name
636: ,'OKL_API.G_RET_STS_ERROR'
637: ,x_msg_count
638: ,x_msg_data

Line 636: ,'OKL_API.G_RET_STS_ERROR'

632:
633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
635: ,g_pkg_name
636: ,'OKL_API.G_RET_STS_ERROR'
637: ,x_msg_count
638: ,x_msg_data
639: ,'_PVT'
640: );

Line 642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

638: ,x_msg_data
639: ,'_PVT'
640: );
641: WHEN OTHERS THEN
642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
643: ,g_pkg_name
644: ,'OTHERS'
645: ,x_msg_count
646: ,x_msg_data