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_PARTY_PAYMENTS_PVT dependencies on OKL_API

Line 21: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

17: x_cpl_id OUT NOCOPY NUMBER
18: ) IS
19: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EVGRN_PARTY_ROLES';
20: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
21: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
22:
23: CURSOR chr_party_role_csr (p_chr_id IN NUMBER, p_vendor_id IN NUMBER) IS
24: SELECT '1'
25: FROM okc_k_party_roles_b cpl

Line 61: p_init_msg_list => Okl_Api.G_FALSE,

57: -- okc_k_party_roles_b and okl_k_party_roles
58: /*
59: Okl_Okc_Migration_Pvt.create_k_party_role(
60: p_api_version => 1.0,
61: p_init_msg_list => Okl_Api.G_FALSE,
62: x_return_status => x_return_status,
63: x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data,
65: p_cplv_rec => l_cplv_rec,

Line 72: p_init_msg_list => Okl_Api.G_FALSE,

68: */
69:
70: okl_k_party_roles_pvt.create_k_party_role(
71: p_api_version => 1.0,
72: p_init_msg_list => Okl_Api.G_FALSE,
73: x_return_status => x_return_status,
74: x_msg_count => x_msg_count,
75: x_msg_data => x_msg_data,
76: p_cplv_rec => l_cplv_rec,

Line 81: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

77: x_cplv_rec => x_cplv_rec,
78: p_kplv_rec => l_kplv_rec,
79: x_kplv_rec => x_kplv_rec);
80:
81: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
82: RAISE Okl_Api.G_EXCEPTION_ERROR;
83: END IF;
84: END IF;
85: x_cpl_id := x_cplv_rec.id;

Line 82: RAISE Okl_Api.G_EXCEPTION_ERROR;

78: p_kplv_rec => l_kplv_rec,
79: x_kplv_rec => x_kplv_rec);
80:
81: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
82: RAISE Okl_Api.G_EXCEPTION_ERROR;
83: END IF;
84: END IF;
85: x_cpl_id := x_cplv_rec.id;
86:

Line 131: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

127: x_cle_tbl OUT NOCOPY evg_cle_tbl_type
128: ) IS
129: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EVGRN_PARTY_ROLES';
130: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
131: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
132: i NUMBER := 0;
133: lx_cle_tbl evg_cle_tbl_type;
134:
135: CURSOR chr_party_role_csr (p_chr_id IN NUMBER, p_vendor_id IN NUMBER) IS

Line 199: p_init_msg_list => Okl_Api.G_FALSE,

195: -- okc_k_party_roles_b and okl_k_party_roles
196: /*
197: Okl_Okc_Migration_Pvt.create_k_party_role(
198: p_api_version => 1.0,
199: p_init_msg_list => Okl_Api.G_FALSE,
200: x_return_status => x_return_status,
201: x_msg_count => x_msg_count,
202: x_msg_data => x_msg_data,
203: p_cplv_rec => l_cplv_rec,

Line 210: p_init_msg_list => Okl_Api.G_FALSE,

206: */
207:
208: okl_k_party_roles_pvt.create_k_party_role(
209: p_api_version => 1.0,
210: p_init_msg_list => Okl_Api.G_FALSE,
211: x_return_status => x_return_status,
212: x_msg_count => x_msg_count,
213: x_msg_data => x_msg_data,
214: p_cplv_rec => l_cplv_rec,

Line 219: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

215: x_cplv_rec => x_cplv_rec,
216: p_kplv_rec => l_kplv_rec,
217: x_kplv_rec => x_kplv_rec);
218:
219: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
220: RAISE Okl_Api.G_EXCEPTION_ERROR;
221: END IF;
222: END IF;
223:

Line 220: RAISE Okl_Api.G_EXCEPTION_ERROR;

216: p_kplv_rec => l_kplv_rec,
217: x_kplv_rec => x_kplv_rec);
218:
219: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
220: RAISE Okl_Api.G_EXCEPTION_ERROR;
221: END IF;
222: END IF;
223:
224: -- Find out service lines for the contract --

Line 255: p_init_msg_list => Okl_Api.G_FALSE,

251: -- okc_k_party_roles_b and okl_k_party_roles
252: /*
253: Okl_Okc_Migration_Pvt.create_k_party_role(
254: p_api_version => 1.0,
255: p_init_msg_list => Okl_Api.G_FALSE,
256: x_return_status => x_return_status,
257: x_msg_count => x_msg_count,
258: x_msg_data => x_msg_data,
259: p_cplv_rec => l_cplv_rec,

Line 266: p_init_msg_list => Okl_Api.G_FALSE,

262: */
263:
264: okl_k_party_roles_pvt.create_k_party_role(
265: p_api_version => 1.0,
266: p_init_msg_list => Okl_Api.G_FALSE,
267: x_return_status => x_return_status,
268: x_msg_count => x_msg_count,
269: x_msg_data => x_msg_data,
270: p_cplv_rec => l_cplv_rec,

Line 279: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

275: lx_cle_tbl(i).cle_id := x_cplv_rec.cle_id;
276: lx_cle_tbl(i).cpl_id := x_cplv_rec.id;
277: lx_cle_tbl(i).cle_start_date := l_line_tbl(i).start_date;
278:
279: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
280: RAISE Okl_Api.G_EXCEPTION_ERROR;
281: END IF;
282: ELSE
283: lx_cle_tbl(i).cle_id := l_line_tbl(i).id;

Line 280: RAISE Okl_Api.G_EXCEPTION_ERROR;

276: lx_cle_tbl(i).cpl_id := x_cplv_rec.id;
277: lx_cle_tbl(i).cle_start_date := l_line_tbl(i).start_date;
278:
279: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
280: RAISE Okl_Api.G_EXCEPTION_ERROR;
281: END IF;
282: ELSE
283: lx_cle_tbl(i).cle_id := l_line_tbl(i).id;
284: lx_cle_tbl(i).cpl_id := l_cpl_id;

Line 342: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,

338: BEGIN
339: x_return_status := l_return_status;
340: IF (p_pphv_rec.passthru_term = 'BASE' ) THEN
341: IF (p_pphv_rec.payout_basis NOT IN ('BILLING','DUE_DATE','PARTIAL_RECEIPT','FULL_RECEIPT')) THEN
342: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
343: G_COL_NAME_TOKEN,'Payout Basis');
344: x_return_status := Okl_Api.G_RET_STS_ERROR;
345: RAISE G_EXCEPTION_HALT_VALIDATION;
346: END IF;

Line 344: x_return_status := Okl_Api.G_RET_STS_ERROR;

340: IF (p_pphv_rec.passthru_term = 'BASE' ) THEN
341: IF (p_pphv_rec.payout_basis NOT IN ('BILLING','DUE_DATE','PARTIAL_RECEIPT','FULL_RECEIPT')) THEN
342: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
343: G_COL_NAME_TOKEN,'Payout Basis');
344: x_return_status := Okl_Api.G_RET_STS_ERROR;
345: RAISE G_EXCEPTION_HALT_VALIDATION;
346: END IF;
347:
348: IF (p_pphv_rec.passthru_start_date IS NULL) THEN

Line 349: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Start Date');

345: RAISE G_EXCEPTION_HALT_VALIDATION;
346: END IF;
347:
348: IF (p_pphv_rec.passthru_start_date IS NULL) THEN
349: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Start Date');
350: x_return_status := Okl_Api.G_RET_STS_ERROR;
351: RAISE G_EXCEPTION_HALT_VALIDATION;
352: END IF;
353:

Line 350: x_return_status := Okl_Api.G_RET_STS_ERROR;

346: END IF;
347:
348: IF (p_pphv_rec.passthru_start_date IS NULL) THEN
349: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Start Date');
350: x_return_status := Okl_Api.G_RET_STS_ERROR;
351: RAISE G_EXCEPTION_HALT_VALIDATION;
352: END IF;
353:
354: END IF;

Line 359: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,

355:
356: IF (p_pphv_rec.passthru_term = 'EVERGREEN') THEN
357:
358: IF (p_pphv_rec.payout_basis NOT IN ('BILLING','FORMULA','PARTIAL_RECEIPT','FULL_RECEIPT')) THEN
359: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
360: G_COL_NAME_TOKEN,'Payout Basis');
361: x_return_status := Okl_Api.G_RET_STS_ERROR;
362: RAISE G_EXCEPTION_HALT_VALIDATION;
363: END IF;

Line 361: x_return_status := Okl_Api.G_RET_STS_ERROR;

357:
358: IF (p_pphv_rec.payout_basis NOT IN ('BILLING','FORMULA','PARTIAL_RECEIPT','FULL_RECEIPT')) THEN
359: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
360: G_COL_NAME_TOKEN,'Payout Basis');
361: x_return_status := Okl_Api.G_RET_STS_ERROR;
362: RAISE G_EXCEPTION_HALT_VALIDATION;
363: END IF;
364:
365: IF (p_pphv_rec.payout_basis = 'FORMULA') THEN

Line 367: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Stream Type');

363: END IF;
364:
365: IF (p_pphv_rec.payout_basis = 'FORMULA') THEN
366: IF (p_pphv_rec.passthru_stream_type_id IS NULL) THEN
367: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Stream Type');
368: x_return_status := Okl_Api.G_RET_STS_ERROR;
369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: END IF;
371:

Line 368: x_return_status := Okl_Api.G_RET_STS_ERROR;

364:
365: IF (p_pphv_rec.payout_basis = 'FORMULA') THEN
366: IF (p_pphv_rec.passthru_stream_type_id IS NULL) THEN
367: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Passthru Stream Type');
368: x_return_status := Okl_Api.G_RET_STS_ERROR;
369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: END IF;
371:
372: IF (p_pphv_rec.payout_basis_formula IS NULL) THEN

Line 373: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payout Basis Formula');

369: RAISE G_EXCEPTION_HALT_VALIDATION;
370: END IF;
371:
372: IF (p_pphv_rec.payout_basis_formula IS NULL) THEN
373: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payout Basis Formula');
374: x_return_status := Okl_Api.G_RET_STS_ERROR;
375: RAISE G_EXCEPTION_HALT_VALIDATION;
376: END IF;
377: END IF;

Line 374: x_return_status := Okl_Api.G_RET_STS_ERROR;

370: END IF;
371:
372: IF (p_pphv_rec.payout_basis_formula IS NULL) THEN
373: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payout Basis Formula');
374: x_return_status := Okl_Api.G_RET_STS_ERROR;
375: RAISE G_EXCEPTION_HALT_VALIDATION;
376: END IF;
377: END IF;
378: END IF;

Line 384: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

380: EXCEPTION
381: WHEN G_EXCEPTION_HALT_VALIDATION THEN
382: NULL;
383: WHEN OTHERS THEN
384: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
385: ,p_msg_name => G_UNEXPECTED_ERROR
386: ,p_token1 => G_SQLCODE_TOKEN
387: ,p_token1_value => SQLCODE
388: ,p_token2 => G_SQLERRM_TOKEN

Line 390: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

386: ,p_token1 => G_SQLCODE_TOKEN
387: ,p_token1_value => SQLCODE
388: ,p_token2 => G_SQLERRM_TOKEN
389: ,p_token2_value => SQLERRM);
390: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
391: END validate_hdr_record;
392:
393: PROCEDURE create_party_payment_hdr(
394: p_api_version IN NUMBER,

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

447: x_msg_count => x_msg_count,
448: x_msg_data => x_msg_data,
449: p_cle_id => p_pphv_rec.cle_id);
450:
451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;

Line 452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

448: x_msg_data => x_msg_data,
449: p_cle_id => p_pphv_rec.cle_id);
450:
451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456: END IF;

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

449: p_cle_id => p_pphv_rec.cle_id);
450:
451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456: END IF;
457: --Bug# 4959361

Line 454: RAISE OKL_API.G_EXCEPTION_ERROR;

450:
451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
454: RAISE OKL_API.G_EXCEPTION_ERROR;
455: END IF;
456: END IF;
457: --Bug# 4959361
458:

Line 469: x_return_status := Okl_Api.G_RET_STS_ERROR;

465: IF (l_exist IS NOT NULL) THEN
466: Okc_Api.SET_MESSAGE( p_app_name => g_app_name,
467: p_msg_name => 'OKL_PPM_PASSTHRU_TERM_EXISTS'
468: );
469: x_return_status := Okl_Api.G_RET_STS_ERROR;
470: RAISE G_EXCEPTION_HALT_VALIDATION;
471: END IF;
472:
473: -- Defaulting effective_from from contract start date--

Line 489: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

485: x_msg_data,
486: l_pphv_rec,
487: x_pphv_rec);
488:
489: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
492: RAISE Okl_Api.G_EXCEPTION_ERROR;
493: END IF;

Line 490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

486: l_pphv_rec,
487: x_pphv_rec);
488:
489: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
492: RAISE Okl_Api.G_EXCEPTION_ERROR;
493: END IF;
494:

Line 491: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

487: x_pphv_rec);
488:
489: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
492: RAISE Okl_Api.G_EXCEPTION_ERROR;
493: END IF;
494:
495: validate_hdr_record(x_return_status, x_pphv_rec);

Line 492: RAISE Okl_Api.G_EXCEPTION_ERROR;

488:
489: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
490: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
491: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
492: RAISE Okl_Api.G_EXCEPTION_ERROR;
493: END IF;
494:
495: validate_hdr_record(x_return_status, x_pphv_rec);
496:

Line 497: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

493: END IF;
494:
495: validate_hdr_record(x_return_status, x_pphv_rec);
496:
497: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
498: l_return_status := x_return_status;
499: RAISE Okc_Api.G_EXCEPTION_ERROR;
500: END IF;
501: x_return_status := l_return_status;

Line 514: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,
512: p_chr_id => l_pphv_rec.dnz_chr_id);
513:
514: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
515: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
517: raise OKL_API.G_EXCEPTION_ERROR;
518: End If;

Line 515: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

511: x_msg_data => x_msg_data,
512: p_chr_id => l_pphv_rec.dnz_chr_id);
513:
514: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
515: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
517: raise OKL_API.G_EXCEPTION_ERROR;
518: End If;
519: -- Bug 4917691: fmiao end

Line 516: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

512: p_chr_id => l_pphv_rec.dnz_chr_id);
513:
514: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
515: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
517: raise OKL_API.G_EXCEPTION_ERROR;
518: End If;
519: -- Bug 4917691: fmiao end
520:

Line 517: raise OKL_API.G_EXCEPTION_ERROR;

513:
514: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
515: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
516: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
517: raise OKL_API.G_EXCEPTION_ERROR;
518: End If;
519: -- Bug 4917691: fmiao end
520:
521: Okc_Api.END_ACTIVITY (x_msg_count

Line 562: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

558: x_pphv_tbl OUT NOCOPY pphv_tbl_type
559: ) IS
560: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY_PAYMENT_HDR';
561: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
562: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
563: i NUMBER;
564: BEGIN
565:
566: IF p_pphv_tbl.COUNT > 0 THEN

Line 577: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

573: x_msg_count,
574: x_msg_data,
575: p_pphv_tbl(i),
576: x_pphv_tbl(i));
577: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
578: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
579: l_overall_status := x_return_status;
580: END IF;
581: END IF;

Line 578: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

574: x_msg_data,
575: p_pphv_tbl(i),
576: x_pphv_tbl(i));
577: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
578: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
579: l_overall_status := x_return_status;
580: END IF;
581: END IF;
582:

Line 591: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

587: -- return overall status
588: x_return_status := l_overall_status;
589: END IF;
590:
591: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
592: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
594: RAISE Okl_Api.G_EXCEPTION_ERROR;
595: END IF;

Line 592: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

588: x_return_status := l_overall_status;
589: END IF;
590:
591: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
592: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
594: RAISE Okl_Api.G_EXCEPTION_ERROR;
595: END IF;
596:

Line 593: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

589: END IF;
590:
591: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
592: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
594: RAISE Okl_Api.G_EXCEPTION_ERROR;
595: END IF;
596:
597: EXCEPTION

Line 594: RAISE Okl_Api.G_EXCEPTION_ERROR;

590:
591: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
592: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
593: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
594: RAISE Okl_Api.G_EXCEPTION_ERROR;
595: END IF;
596:
597: EXCEPTION
598: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 656: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

652: x_msg_count,
653: x_msg_data,
654: p_pphv_rec);
655:
656: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;

Line 657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

653: x_msg_data,
654: p_pphv_rec);
655:
656: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661:

Line 658: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

654: p_pphv_rec);
655:
656: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661:
662: Okc_Api.END_ACTIVITY (x_msg_count

Line 659: RAISE Okl_Api.G_EXCEPTION_ERROR;

655:
656: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
657: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
658: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
659: RAISE Okl_Api.G_EXCEPTION_ERROR;
660: END IF;
661:
662: Okc_Api.END_ACTIVITY (x_msg_count
663: ,x_msg_data );

Line 702: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

698: p_pphv_tbl IN pphv_tbl_type
699: ) IS
700: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY_PAYMENT_HDR';
701: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
702: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
703: i NUMBER;
704: BEGIN
705:
706: IF p_pphv_tbl.COUNT > 0 THEN

Line 716: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

712: x_return_status,
713: x_msg_count,
714: x_msg_data,
715: p_pphv_tbl(i));
716: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
717: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
718: l_overall_status := x_return_status;
719: END IF;
720: END IF;

Line 717: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

713: x_msg_count,
714: x_msg_data,
715: p_pphv_tbl(i));
716: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
717: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
718: l_overall_status := x_return_status;
719: END IF;
720: END IF;
721:

Line 730: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

726: -- return overall status
727: x_return_status := l_overall_status;
728: END IF;
729:
730: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
731: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
732: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
733: RAISE Okl_Api.G_EXCEPTION_ERROR;
734: END IF;

Line 731: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

727: x_return_status := l_overall_status;
728: END IF;
729:
730: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
731: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
732: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
733: RAISE Okl_Api.G_EXCEPTION_ERROR;
734: END IF;
735:

Line 732: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

728: END IF;
729:
730: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
731: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
732: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
733: RAISE Okl_Api.G_EXCEPTION_ERROR;
734: END IF;
735:
736: EXCEPTION

Line 733: RAISE Okl_Api.G_EXCEPTION_ERROR;

729:
730: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
731: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
732: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
733: RAISE Okl_Api.G_EXCEPTION_ERROR;
734: END IF;
735:
736: EXCEPTION
737: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

808: x_msg_count => x_msg_count,
809: x_msg_data => x_msg_data,
810: p_cle_id => l_pph_rec.cle_id);
811:
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;

Line 813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

809: x_msg_data => x_msg_data,
810: p_cle_id => l_pph_rec.cle_id);
811:
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: END IF;

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

810: p_cle_id => l_pph_rec.cle_id);
811:
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: END IF;
818: --Bug# 4959361

Line 815: RAISE OKL_API.G_EXCEPTION_ERROR;

811:
812: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
813: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
814: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816: END IF;
817: END IF;
818: --Bug# 4959361
819:

Line 827: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

823: x_msg_count,
824: x_msg_data,
825: p_pphv_rec);
826:
827: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
828: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
830: RAISE Okl_Api.G_EXCEPTION_ERROR;
831: END IF;

Line 828: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

824: x_msg_data,
825: p_pphv_rec);
826:
827: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
828: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
830: RAISE Okl_Api.G_EXCEPTION_ERROR;
831: END IF;
832:

Line 829: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

825: p_pphv_rec);
826:
827: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
828: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
830: RAISE Okl_Api.G_EXCEPTION_ERROR;
831: END IF;
832:
833: Okc_Api.END_ACTIVITY (x_msg_count

Line 830: RAISE Okl_Api.G_EXCEPTION_ERROR;

826:
827: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
828: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
829: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
830: RAISE Okl_Api.G_EXCEPTION_ERROR;
831: END IF;
832:
833: Okc_Api.END_ACTIVITY (x_msg_count
834: ,x_msg_data );

Line 873: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

869: p_pphv_tbl IN pphv_tbl_type
870: ) IS
871: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PAYMENT_HDR';
872: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
873: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
874: i NUMBER;
875: BEGIN
876:
877: IF p_pphv_tbl.COUNT > 0 THEN

Line 887: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

883: x_return_status,
884: x_msg_count,
885: x_msg_data,
886: p_pphv_tbl(i));
887: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
888: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
889: l_overall_status := x_return_status;
890: END IF;
891: END IF;

Line 888: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

884: x_msg_count,
885: x_msg_data,
886: p_pphv_tbl(i));
887: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
888: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
889: l_overall_status := x_return_status;
890: END IF;
891: END IF;
892:

Line 901: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

897: -- return overall status
898: x_return_status := l_overall_status;
899: END IF;
900:
901: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
903: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
904: RAISE Okl_Api.G_EXCEPTION_ERROR;
905: END IF;

Line 902: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

898: x_return_status := l_overall_status;
899: END IF;
900:
901: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
903: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
904: RAISE Okl_Api.G_EXCEPTION_ERROR;
905: END IF;
906:

Line 903: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

899: END IF;
900:
901: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
903: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
904: RAISE Okl_Api.G_EXCEPTION_ERROR;
905: END IF;
906:
907: EXCEPTION

Line 904: RAISE Okl_Api.G_EXCEPTION_ERROR;

900:
901: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
903: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
904: RAISE Okl_Api.G_EXCEPTION_ERROR;
905: END IF;
906:
907: EXCEPTION
908: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

980: x_msg_count => x_msg_count,
981: x_msg_data => x_msg_data,
982: p_cle_id => l_pph_rec.cle_id);
983:
984: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: END IF;

Line 985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

981: x_msg_data => x_msg_data,
982: p_cle_id => l_pph_rec.cle_id);
983:
984: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: END IF;
989: END IF;

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

982: p_cle_id => l_pph_rec.cle_id);
983:
984: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: END IF;
989: END IF;
990: --Bug# 4959361

Line 987: RAISE OKL_API.G_EXCEPTION_ERROR;

983:
984: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
986: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
987: RAISE OKL_API.G_EXCEPTION_ERROR;
988: END IF;
989: END IF;
990: --Bug# 4959361
991:

Line 1000: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

996: x_msg_data,
997: p_pphv_rec,
998: x_pphv_rec);
999:
1000: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1003: RAISE Okl_Api.G_EXCEPTION_ERROR;
1004: END IF;

Line 1001: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

997: p_pphv_rec,
998: x_pphv_rec);
999:
1000: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1003: RAISE Okl_Api.G_EXCEPTION_ERROR;
1004: END IF;
1005:

Line 1002: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

998: x_pphv_rec);
999:
1000: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1003: RAISE Okl_Api.G_EXCEPTION_ERROR;
1004: END IF;
1005:
1006: validate_hdr_record(x_return_status, x_pphv_rec);

Line 1003: RAISE Okl_Api.G_EXCEPTION_ERROR;

999:
1000: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1001: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1002: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1003: RAISE Okl_Api.G_EXCEPTION_ERROR;
1004: END IF;
1005:
1006: validate_hdr_record(x_return_status, x_pphv_rec);
1007:

Line 1008: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1004: END IF;
1005:
1006: validate_hdr_record(x_return_status, x_pphv_rec);
1007:
1008: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1009: l_return_status := x_return_status;
1010: RAISE Okc_Api.G_EXCEPTION_ERROR;
1011: END IF;
1012:

Line 1024: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1020: x_msg_count => x_msg_count,
1021: x_msg_data => x_msg_data,
1022: p_chr_id => x_pphv_rec.dnz_chr_id);
1023:
1024: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1025: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1027: raise OKL_API.G_EXCEPTION_ERROR;
1028: End If;

Line 1025: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1021: x_msg_data => x_msg_data,
1022: p_chr_id => x_pphv_rec.dnz_chr_id);
1023:
1024: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1025: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1027: raise OKL_API.G_EXCEPTION_ERROR;
1028: End If;
1029: -- Bug 4917691: fmiao end

Line 1026: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1022: p_chr_id => x_pphv_rec.dnz_chr_id);
1023:
1024: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1025: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1027: raise OKL_API.G_EXCEPTION_ERROR;
1028: End If;
1029: -- Bug 4917691: fmiao end
1030:

Line 1027: raise OKL_API.G_EXCEPTION_ERROR;

1023:
1024: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1025: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1027: raise OKL_API.G_EXCEPTION_ERROR;
1028: End If;
1029: -- Bug 4917691: fmiao end
1030:
1031: Okc_Api.END_ACTIVITY (x_msg_count

Line 1072: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1068: x_pphv_tbl OUT NOCOPY pphv_tbl_type
1069: ) IS
1070: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PAYMENT_HDR';
1071: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1072: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1073: i NUMBER;
1074:
1075: BEGIN
1076:

Line 1088: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1084: x_msg_count,
1085: x_msg_data,
1086: p_pphv_tbl(i),
1087: x_pphv_tbl(i));
1088: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1089: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1090: l_overall_status := x_return_status;
1091: END IF;
1092: END IF;

Line 1089: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1085: x_msg_data,
1086: p_pphv_tbl(i),
1087: x_pphv_tbl(i));
1088: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1089: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1090: l_overall_status := x_return_status;
1091: END IF;
1092: END IF;
1093:

Line 1102: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1098: -- return overall status
1099: x_return_status := l_overall_status;
1100: END IF;
1101:
1102: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1105: RAISE Okl_Api.G_EXCEPTION_ERROR;
1106: END IF;

Line 1103: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1099: x_return_status := l_overall_status;
1100: END IF;
1101:
1102: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1105: RAISE Okl_Api.G_EXCEPTION_ERROR;
1106: END IF;
1107:

Line 1104: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

1100: END IF;
1101:
1102: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1105: RAISE Okl_Api.G_EXCEPTION_ERROR;
1106: END IF;
1107:
1108: EXCEPTION

Line 1105: RAISE Okl_Api.G_EXCEPTION_ERROR;

1101:
1102: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1103: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1105: RAISE Okl_Api.G_EXCEPTION_ERROR;
1106: END IF;
1107:
1108: EXCEPTION
1109: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1163: x_msg_count,
1164: x_msg_data,
1165: p_pphv_rec);
1166:
1167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1170: RAISE Okl_Api.G_EXCEPTION_ERROR;
1171: END IF;

Line 1168: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1164: x_msg_data,
1165: p_pphv_rec);
1166:
1167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1170: RAISE Okl_Api.G_EXCEPTION_ERROR;
1171: END IF;
1172:

Line 1169: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

1165: p_pphv_rec);
1166:
1167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1170: RAISE Okl_Api.G_EXCEPTION_ERROR;
1171: END IF;
1172:
1173: Okc_Api.END_ACTIVITY (x_msg_count

Line 1170: RAISE Okl_Api.G_EXCEPTION_ERROR;

1166:
1167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1170: RAISE Okl_Api.G_EXCEPTION_ERROR;
1171: END IF;
1172:
1173: Okc_Api.END_ACTIVITY (x_msg_count
1174: ,x_msg_data );

Line 1213: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1209: p_pphv_tbl IN pphv_tbl_type
1210: ) IS
1211: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PARTY_PAYMENT_HDR';
1212: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1213: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1214: i NUMBER;
1215: BEGIN
1216:
1217: IF p_pphv_tbl.COUNT > 0 THEN

Line 1227: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1223: x_return_status,
1224: x_msg_count,
1225: x_msg_data,
1226: p_pphv_tbl(i));
1227: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1228: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1229: l_overall_status := x_return_status;
1230: END IF;
1231: END IF;

Line 1228: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1224: x_msg_count,
1225: x_msg_data,
1226: p_pphv_tbl(i));
1227: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1228: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1229: l_overall_status := x_return_status;
1230: END IF;
1231: END IF;
1232:

Line 1241: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1237: -- return overall status
1238: x_return_status := l_overall_status;
1239: END IF;
1240:
1241: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1244: RAISE Okl_Api.G_EXCEPTION_ERROR;
1245: END IF;

Line 1242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1238: x_return_status := l_overall_status;
1239: END IF;
1240:
1241: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1244: RAISE Okl_Api.G_EXCEPTION_ERROR;
1245: END IF;
1246:

Line 1243: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

1239: END IF;
1240:
1241: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1244: RAISE Okl_Api.G_EXCEPTION_ERROR;
1245: END IF;
1246:
1247: EXCEPTION

Line 1244: RAISE Okl_Api.G_EXCEPTION_ERROR;

1240:
1241: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1242: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
1244: RAISE Okl_Api.G_EXCEPTION_ERROR;
1245: END IF;
1246:
1247: EXCEPTION
1248: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1672: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1668: EXCEPTION
1669: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1670: NULL;
1671: WHEN OTHERS THEN
1672: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1673: ,p_msg_name => G_UNEXPECTED_ERROR
1674: ,p_token1 => G_SQLCODE_TOKEN
1675: ,p_token1_value => SQLCODE
1676: ,p_token2 => G_SQLERRM_TOKEN

Line 1678: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1674: ,p_token1 => G_SQLCODE_TOKEN
1675: ,p_token1_value => SQLCODE
1676: ,p_token2 => G_SQLERRM_TOKEN
1677: ,p_token2_value => SQLERRM);
1678: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1679: END get_passthru_parameters;
1680:
1681: ----------------------------------------------------------
1682: -- Validate detail record before insert/update

Line 1720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');

1716:
1717: -- check for required columns --
1718: x_return_status := l_return_status;
1719: IF( p_ppydv_rec.pay_site_id IS NULL) THEN
1720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');
1721: x_return_status := Okl_Api.G_RET_STS_ERROR;
1722: RAISE G_EXCEPTION_HALT_VALIDATION;
1723: END IF;
1724: IF( p_ppydv_rec.payment_term_id IS NULL) THEN

Line 1721: x_return_status := Okl_Api.G_RET_STS_ERROR;

1717: -- check for required columns --
1718: x_return_status := l_return_status;
1719: IF( p_ppydv_rec.pay_site_id IS NULL) THEN
1720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');
1721: x_return_status := Okl_Api.G_RET_STS_ERROR;
1722: RAISE G_EXCEPTION_HALT_VALIDATION;
1723: END IF;
1724: IF( p_ppydv_rec.payment_term_id IS NULL) THEN
1725: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');

Line 1725: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');

1721: x_return_status := Okl_Api.G_RET_STS_ERROR;
1722: RAISE G_EXCEPTION_HALT_VALIDATION;
1723: END IF;
1724: IF( p_ppydv_rec.payment_term_id IS NULL) THEN
1725: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');
1726: x_return_status := Okl_Api.G_RET_STS_ERROR;
1727: RAISE G_EXCEPTION_HALT_VALIDATION;
1728: END IF;
1729: IF( p_ppydv_rec.pay_group_code IS NULL) THEN

Line 1726: x_return_status := Okl_Api.G_RET_STS_ERROR;

1722: RAISE G_EXCEPTION_HALT_VALIDATION;
1723: END IF;
1724: IF( p_ppydv_rec.payment_term_id IS NULL) THEN
1725: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');
1726: x_return_status := Okl_Api.G_RET_STS_ERROR;
1727: RAISE G_EXCEPTION_HALT_VALIDATION;
1728: END IF;
1729: IF( p_ppydv_rec.pay_group_code IS NULL) THEN
1730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Group Code');

Line 1730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Group Code');

1726: x_return_status := Okl_Api.G_RET_STS_ERROR;
1727: RAISE G_EXCEPTION_HALT_VALIDATION;
1728: END IF;
1729: IF( p_ppydv_rec.pay_group_code IS NULL) THEN
1730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Group Code');
1731: x_return_status := Okl_Api.G_RET_STS_ERROR;
1732: RAISE G_EXCEPTION_HALT_VALIDATION;
1733: END IF;
1734:

Line 1731: x_return_status := Okl_Api.G_RET_STS_ERROR;

1727: RAISE G_EXCEPTION_HALT_VALIDATION;
1728: END IF;
1729: IF( p_ppydv_rec.pay_group_code IS NULL) THEN
1730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Group Code');
1731: x_return_status := Okl_Api.G_RET_STS_ERROR;
1732: RAISE G_EXCEPTION_HALT_VALIDATION;
1733: END IF;
1734:
1735: IF (p_ppydv_rec.payment_hdr_id IS NULL) THEN

Line 1736: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Header Id');

1732: RAISE G_EXCEPTION_HALT_VALIDATION;
1733: END IF;
1734:
1735: IF (p_ppydv_rec.payment_hdr_id IS NULL) THEN
1736: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Header Id');
1737: x_return_status := Okl_Api.G_RET_STS_ERROR;
1738: RAISE G_EXCEPTION_HALT_VALIDATION;
1739: ELSE
1740: --find out whether header exists

Line 1737: x_return_status := Okl_Api.G_RET_STS_ERROR;

1733: END IF;
1734:
1735: IF (p_ppydv_rec.payment_hdr_id IS NULL) THEN
1736: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Header Id');
1737: x_return_status := Okl_Api.G_RET_STS_ERROR;
1738: RAISE G_EXCEPTION_HALT_VALIDATION;
1739: ELSE
1740: --find out whether header exists
1741: l_exists := 'N';

Line 1752: x_return_status := Okl_Api.G_RET_STS_ERROR;

1748: IF l_exists = 'N' THEN
1749: Okc_Api.SET_MESSAGE( p_app_name => g_app_name
1750: , p_msg_name => 'OKL_PPM_HEADER_MISSING'
1751: );
1752: x_return_status := Okl_Api.G_RET_STS_ERROR;
1753: RAISE G_EXCEPTION_HALT_VALIDATION;
1754: END IF;
1755:
1756: END IF;

Line 1759: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Basis');

1755:
1756: END IF;
1757:
1758: IF (p_ppydv_rec.payment_basis IS NULL) THEN
1759: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Basis');
1760: x_return_status := Okl_Api.G_RET_STS_ERROR;
1761: RAISE G_EXCEPTION_HALT_VALIDATION;
1762: END IF;
1763: IF (p_ppydv_rec.disbursement_basis IS NULL) THEN

Line 1760: x_return_status := Okl_Api.G_RET_STS_ERROR;

1756: END IF;
1757:
1758: IF (p_ppydv_rec.payment_basis IS NULL) THEN
1759: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Basis');
1760: x_return_status := Okl_Api.G_RET_STS_ERROR;
1761: RAISE G_EXCEPTION_HALT_VALIDATION;
1762: END IF;
1763: IF (p_ppydv_rec.disbursement_basis IS NULL) THEN
1764: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Basis');

Line 1764: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Basis');

1760: x_return_status := Okl_Api.G_RET_STS_ERROR;
1761: RAISE G_EXCEPTION_HALT_VALIDATION;
1762: END IF;
1763: IF (p_ppydv_rec.disbursement_basis IS NULL) THEN
1764: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Basis');
1765: x_return_status := Okl_Api.G_RET_STS_ERROR;
1766: RAISE G_EXCEPTION_HALT_VALIDATION;
1767: END IF;
1768:

Line 1765: x_return_status := Okl_Api.G_RET_STS_ERROR;

1761: RAISE G_EXCEPTION_HALT_VALIDATION;
1762: END IF;
1763: IF (p_ppydv_rec.disbursement_basis IS NULL) THEN
1764: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Basis');
1765: x_return_status := Okl_Api.G_RET_STS_ERROR;
1766: RAISE G_EXCEPTION_HALT_VALIDATION;
1767: END IF;
1768:
1769: --can be done from UI--

Line 1782: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Fixed Amount');

1778: END IF;
1779: --Validate Disbursement Fixed Amount
1780: IF (p_ppydv_rec.disbursement_basis = 'AMOUNT' AND
1781: p_ppydv_rec.disbursement_fixed_amount IS NULL) THEN
1782: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Fixed Amount');
1783: x_return_status := Okl_Api.G_RET_STS_ERROR;
1784: RAISE G_EXCEPTION_HALT_VALIDATION;
1785: END IF;
1786: --Validate Disbursement Percent

Line 1783: x_return_status := Okl_Api.G_RET_STS_ERROR;

1779: --Validate Disbursement Fixed Amount
1780: IF (p_ppydv_rec.disbursement_basis = 'AMOUNT' AND
1781: p_ppydv_rec.disbursement_fixed_amount IS NULL) THEN
1782: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Fixed Amount');
1783: x_return_status := Okl_Api.G_RET_STS_ERROR;
1784: RAISE G_EXCEPTION_HALT_VALIDATION;
1785: END IF;
1786: --Validate Disbursement Percent
1787: IF (p_ppydv_rec.disbursement_basis = 'PERCENT' AND

Line 1789: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Percent');

1785: END IF;
1786: --Validate Disbursement Percent
1787: IF (p_ppydv_rec.disbursement_basis = 'PERCENT' AND
1788: p_ppydv_rec.disbursement_percent IS NULL) THEN
1789: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Percent');
1790: x_return_status := Okl_Api.G_RET_STS_ERROR;
1791: RAISE G_EXCEPTION_HALT_VALIDATION;
1792: END IF;
1793: --Validate Processing fee fixed Amount

Line 1790: x_return_status := Okl_Api.G_RET_STS_ERROR;

1786: --Validate Disbursement Percent
1787: IF (p_ppydv_rec.disbursement_basis = 'PERCENT' AND
1788: p_ppydv_rec.disbursement_percent IS NULL) THEN
1789: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Disbursement Percent');
1790: x_return_status := Okl_Api.G_RET_STS_ERROR;
1791: RAISE G_EXCEPTION_HALT_VALIDATION;
1792: END IF;
1793: --Validate Processing fee fixed Amount
1794: IF (p_ppydv_rec.processing_fee_basis = 'AMOUNT' AND

Line 1796: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Fixed Amount');

1792: END IF;
1793: --Validate Processing fee fixed Amount
1794: IF (p_ppydv_rec.processing_fee_basis = 'AMOUNT' AND
1795: p_ppydv_rec.processing_fee_fixed_amount IS NULL) THEN
1796: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Fixed Amount');
1797: x_return_status := Okl_Api.G_RET_STS_ERROR;
1798: RAISE G_EXCEPTION_HALT_VALIDATION;
1799: END IF;
1800: --Validate Processing fee Percent

Line 1797: x_return_status := Okl_Api.G_RET_STS_ERROR;

1793: --Validate Processing fee fixed Amount
1794: IF (p_ppydv_rec.processing_fee_basis = 'AMOUNT' AND
1795: p_ppydv_rec.processing_fee_fixed_amount IS NULL) THEN
1796: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Fixed Amount');
1797: x_return_status := Okl_Api.G_RET_STS_ERROR;
1798: RAISE G_EXCEPTION_HALT_VALIDATION;
1799: END IF;
1800: --Validate Processing fee Percent
1801: IF (p_ppydv_rec.processing_fee_basis = 'PERCENT' AND

Line 1803: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Percent');

1799: END IF;
1800: --Validate Processing fee Percent
1801: IF (p_ppydv_rec.processing_fee_basis = 'PERCENT' AND
1802: p_ppydv_rec.processing_fee_percent IS NULL) THEN
1803: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Percent');
1804: x_return_status := Okl_Api.G_RET_STS_ERROR;
1805: RAISE G_EXCEPTION_HALT_VALIDATION;
1806: END IF;
1807: --Validate Processing fee Formula

Line 1804: x_return_status := Okl_Api.G_RET_STS_ERROR;

1800: --Validate Processing fee Percent
1801: IF (p_ppydv_rec.processing_fee_basis = 'PERCENT' AND
1802: p_ppydv_rec.processing_fee_percent IS NULL) THEN
1803: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Percent');
1804: x_return_status := Okl_Api.G_RET_STS_ERROR;
1805: RAISE G_EXCEPTION_HALT_VALIDATION;
1806: END IF;
1807: --Validate Processing fee Formula
1808: /*

Line 1811: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Formula');

1807: --Validate Processing fee Formula
1808: /*
1809: IF (p_ppydv_rec.processing_fee_basis = 'FORMULA' AND
1810: p_ppydv_rec.processing_fee_formula IS NULL) THEN
1811: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Formula');
1812: x_return_status := OKL_API.G_RET_STS_ERROR;
1813: RAISE G_EXCEPTION_HALT_VALIDATION;
1814: End If; */
1815: --the above can be done from UI--

Line 1812: x_return_status := OKL_API.G_RET_STS_ERROR;

1808: /*
1809: IF (p_ppydv_rec.processing_fee_basis = 'FORMULA' AND
1810: p_ppydv_rec.processing_fee_formula IS NULL) THEN
1811: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Processing Fee Formula');
1812: x_return_status := OKL_API.G_RET_STS_ERROR;
1813: RAISE G_EXCEPTION_HALT_VALIDATION;
1814: End If; */
1815: --the above can be done from UI--
1816:

Line 1827: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,

1823: NULL;
1824: END IF;
1825: CLOSE l_cplb_csr;
1826: IF l_exists = 'N' THEN
1827: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
1828: G_COL_NAME_TOKEN,'Vendor_Id');
1829: x_return_status := Okl_Api.G_RET_STS_ERROR;
1830: RAISE G_EXCEPTION_HALT_VALIDATION;
1831: END IF;

Line 1829: x_return_status := Okl_Api.G_RET_STS_ERROR;

1825: CLOSE l_cplb_csr;
1826: IF l_exists = 'N' THEN
1827: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,
1828: G_COL_NAME_TOKEN,'Vendor_Id');
1829: x_return_status := Okl_Api.G_RET_STS_ERROR;
1830: RAISE G_EXCEPTION_HALT_VALIDATION;
1831: END IF;
1832:
1833: -- Velidation based on payment basis --

Line 1889: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

1885: END IF;
1886: END IF;
1887:
1888: -- raise the exception if status is not s
1889: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1890: l_return_status := x_return_status;
1891: RAISE G_EXCEPTION_HALT_VALIDATION;
1892: END IF;
1893: --x_return_status := l_return_status;

Line 1898: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

1894: EXCEPTION
1895: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1896: NULL;
1897: WHEN OTHERS THEN
1898: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
1899: ,p_msg_name => G_UNEXPECTED_ERROR
1900: ,p_token1 => G_SQLCODE_TOKEN
1901: ,p_token1_value => SQLCODE
1902: ,p_token2 => G_SQLERRM_TOKEN

Line 1904: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1900: ,p_token1 => G_SQLCODE_TOKEN
1901: ,p_token1_value => SQLCODE
1902: ,p_token2 => G_SQLERRM_TOKEN
1903: ,p_token2_value => SQLERRM);
1904: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1905: END validate_dtls_record;
1906:
1907: PROCEDURE create_party_payment_dtls(
1908: p_api_version IN NUMBER,

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

1970: x_msg_count => x_msg_count,
1971: x_msg_data => x_msg_data,
1972: p_cle_id => l_pph_rec.cle_id);
1973:
1974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1977: RAISE OKL_API.G_EXCEPTION_ERROR;
1978: END IF;

Line 1975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1971: x_msg_data => x_msg_data,
1972: p_cle_id => l_pph_rec.cle_id);
1973:
1974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1977: RAISE OKL_API.G_EXCEPTION_ERROR;
1978: END IF;
1979: END IF;

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

1972: p_cle_id => l_pph_rec.cle_id);
1973:
1974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1977: RAISE OKL_API.G_EXCEPTION_ERROR;
1978: END IF;
1979: END IF;
1980: --Bug# 4959361

Line 1977: RAISE OKL_API.G_EXCEPTION_ERROR;

1973:
1974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1977: RAISE OKL_API.G_EXCEPTION_ERROR;
1978: END IF;
1979: END IF;
1980: --Bug# 4959361
1981:

Line 1991: x_return_status := Okl_Api.G_RET_STS_ERROR;

1987: IF (l_exist IS NOT NULL) THEN
1988: Okc_Api.SET_MESSAGE( p_app_name => g_app_name,
1989: p_msg_name => 'OKL_PPM_VENDOR_EXISTS'
1990: );
1991: x_return_status := Okl_Api.G_RET_STS_ERROR;
1992: RAISE G_EXCEPTION_HALT_VALIDATION;
1993: END IF;
1994:
1995: Okl_Pyd_Pvt.insert_row(p_api_version,

Line 2003: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1999: x_msg_data,
2000: p_ppydv_rec,
2001: x_ppydv_rec);
2002:
2003: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2004: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2006: RAISE Okl_Api.G_EXCEPTION_ERROR;
2007: END IF;

Line 2004: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2000: p_ppydv_rec,
2001: x_ppydv_rec);
2002:
2003: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2004: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2006: RAISE Okl_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008:

Line 2005: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2001: x_ppydv_rec);
2002:
2003: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2004: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2006: RAISE Okl_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008:
2009: validate_dtls_record(x_return_status, x_ppydv_rec);

Line 2006: RAISE Okl_Api.G_EXCEPTION_ERROR;

2002:
2003: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2004: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2006: RAISE Okl_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008:
2009: validate_dtls_record(x_return_status, x_ppydv_rec);
2010:

Line 2011: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

2007: END IF;
2008:
2009: validate_dtls_record(x_return_status, x_ppydv_rec);
2010:
2011: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2012: l_return_status := x_return_status;
2013: RAISE Okc_Api.G_EXCEPTION_ERROR;
2014: END IF;
2015: x_return_status := l_return_status;

Line 2033: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

2029: x_msg_count => x_msg_count,
2030: x_msg_data => x_msg_data,
2031: p_chr_id => l_chr_id);
2032:
2033: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2034: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2035: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: End If;

Line 2034: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2030: x_msg_data => x_msg_data,
2031: p_chr_id => l_chr_id);
2032:
2033: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2034: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2035: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: End If;
2038: END IF;

Line 2035: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

2031: p_chr_id => l_chr_id);
2032:
2033: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2034: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2035: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: End If;
2038: END IF;
2039: -- Bug 4917691: fmiao end

Line 2036: raise OKL_API.G_EXCEPTION_ERROR;

2032:
2033: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2034: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2035: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2036: raise OKL_API.G_EXCEPTION_ERROR;
2037: End If;
2038: END IF;
2039: -- Bug 4917691: fmiao end
2040:

Line 2082: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2078: x_ppydv_tbl OUT NOCOPY ppydv_tbl_type
2079: ) IS
2080: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY_PAYMENT_DTLS';
2081: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2082: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2083: i NUMBER;
2084: BEGIN
2085:
2086: IF p_ppydv_tbl.COUNT > 0 THEN

Line 2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2093: x_msg_count,
2094: x_msg_data,
2095: p_ppydv_tbl(i),
2096: x_ppydv_tbl(i));
2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2098: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2099: l_overall_status := x_return_status;
2100: END IF;
2101: END IF;

Line 2098: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2094: x_msg_data,
2095: p_ppydv_tbl(i),
2096: x_ppydv_tbl(i));
2097: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2098: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2099: l_overall_status := x_return_status;
2100: END IF;
2101: END IF;
2102:

Line 2111: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2107: -- return overall status
2108: x_return_status := l_overall_status;
2109: END IF;
2110:
2111: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2112: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2114: RAISE Okl_Api.G_EXCEPTION_ERROR;
2115: END IF;

Line 2112: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2108: x_return_status := l_overall_status;
2109: END IF;
2110:
2111: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2112: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2114: RAISE Okl_Api.G_EXCEPTION_ERROR;
2115: END IF;
2116:

Line 2113: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2109: END IF;
2110:
2111: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2112: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2114: RAISE Okl_Api.G_EXCEPTION_ERROR;
2115: END IF;
2116:
2117: EXCEPTION

Line 2114: RAISE Okl_Api.G_EXCEPTION_ERROR;

2110:
2111: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2112: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2114: RAISE Okl_Api.G_EXCEPTION_ERROR;
2115: END IF;
2116:
2117: EXCEPTION
2118: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2172: x_msg_count,
2173: x_msg_data,
2174: p_ppydv_rec);
2175:
2176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;

Line 2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2173: x_msg_data,
2174: p_ppydv_rec);
2175:
2176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:

Line 2178: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2174: p_ppydv_rec);
2175:
2176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: Okc_Api.END_ACTIVITY (x_msg_count

Line 2179: RAISE Okl_Api.G_EXCEPTION_ERROR;

2175:
2176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2179: RAISE Okl_Api.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: Okc_Api.END_ACTIVITY (x_msg_count
2183: ,x_msg_data );

Line 2222: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2218: p_ppydv_tbl IN ppydv_tbl_type
2219: ) IS
2220: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_PARTY_PAYMENT_DTLS';
2221: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2222: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2223: i NUMBER;
2224: BEGIN
2225:
2226: IF p_ppydv_tbl.COUNT > 0 THEN

Line 2236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2232: x_return_status,
2233: x_msg_count,
2234: x_msg_data,
2235: p_ppydv_tbl(i));
2236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2237: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2238: l_overall_status := x_return_status;
2239: END IF;
2240: END IF;

Line 2237: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2233: x_msg_count,
2234: x_msg_data,
2235: p_ppydv_tbl(i));
2236: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2237: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2238: l_overall_status := x_return_status;
2239: END IF;
2240: END IF;
2241:

Line 2250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2246: -- return overall status
2247: x_return_status := l_overall_status;
2248: END IF;
2249:
2250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2252: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2253: RAISE Okl_Api.G_EXCEPTION_ERROR;
2254: END IF;

Line 2251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2247: x_return_status := l_overall_status;
2248: END IF;
2249:
2250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2252: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2253: RAISE Okl_Api.G_EXCEPTION_ERROR;
2254: END IF;
2255:

Line 2252: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2248: END IF;
2249:
2250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2252: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2253: RAISE Okl_Api.G_EXCEPTION_ERROR;
2254: END IF;
2255:
2256: EXCEPTION

Line 2253: RAISE Okl_Api.G_EXCEPTION_ERROR;

2249:
2250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2252: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2253: RAISE Okl_Api.G_EXCEPTION_ERROR;
2254: END IF;
2255:
2256: EXCEPTION
2257: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

2330: x_msg_count => x_msg_count,
2331: x_msg_data => x_msg_data,
2332: p_cle_id => l_pyd_rec.cle_id);
2333:
2334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2337: RAISE OKL_API.G_EXCEPTION_ERROR;
2338: END IF;

Line 2335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2331: x_msg_data => x_msg_data,
2332: p_cle_id => l_pyd_rec.cle_id);
2333:
2334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2337: RAISE OKL_API.G_EXCEPTION_ERROR;
2338: END IF;
2339: END IF;

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

2332: p_cle_id => l_pyd_rec.cle_id);
2333:
2334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2337: RAISE OKL_API.G_EXCEPTION_ERROR;
2338: END IF;
2339: END IF;
2340: --Bug# 4959361

Line 2337: RAISE OKL_API.G_EXCEPTION_ERROR;

2333:
2334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2337: RAISE OKL_API.G_EXCEPTION_ERROR;
2338: END IF;
2339: END IF;
2340: --Bug# 4959361
2341:

Line 2349: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2345: x_msg_count,
2346: x_msg_data,
2347: p_ppydv_rec);
2348:
2349: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2352: RAISE Okl_Api.G_EXCEPTION_ERROR;
2353: END IF;

Line 2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2346: x_msg_data,
2347: p_ppydv_rec);
2348:
2349: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2352: RAISE Okl_Api.G_EXCEPTION_ERROR;
2353: END IF;
2354:

Line 2351: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2347: p_ppydv_rec);
2348:
2349: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2352: RAISE Okl_Api.G_EXCEPTION_ERROR;
2353: END IF;
2354:
2355: Okc_Api.END_ACTIVITY (x_msg_count

Line 2352: RAISE Okl_Api.G_EXCEPTION_ERROR;

2348:
2349: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2351: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2352: RAISE Okl_Api.G_EXCEPTION_ERROR;
2353: END IF;
2354:
2355: Okc_Api.END_ACTIVITY (x_msg_count
2356: ,x_msg_data );

Line 2395: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2391: p_ppydv_tbl IN ppydv_tbl_type
2392: ) IS
2393: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PARTY_PAYMENT_DTLS';
2394: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2395: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2396: i NUMBER;
2397: BEGIN
2398:
2399: IF p_ppydv_tbl.COUNT > 0 THEN

Line 2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2405: x_return_status,
2406: x_msg_count,
2407: x_msg_data,
2408: p_ppydv_tbl(i));
2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2410: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2411: l_overall_status := x_return_status;
2412: END IF;
2413: END IF;

Line 2410: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2406: x_msg_count,
2407: x_msg_data,
2408: p_ppydv_tbl(i));
2409: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2410: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2411: l_overall_status := x_return_status;
2412: END IF;
2413: END IF;
2414:

Line 2423: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2419: -- return overall status
2420: x_return_status := l_overall_status;
2421: END IF;
2422:
2423: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2424: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2425: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2426: RAISE Okl_Api.G_EXCEPTION_ERROR;
2427: END IF;

Line 2424: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2420: x_return_status := l_overall_status;
2421: END IF;
2422:
2423: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2424: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2425: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2426: RAISE Okl_Api.G_EXCEPTION_ERROR;
2427: END IF;
2428:

Line 2425: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2421: END IF;
2422:
2423: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2424: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2425: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2426: RAISE Okl_Api.G_EXCEPTION_ERROR;
2427: END IF;
2428:
2429: EXCEPTION

Line 2426: RAISE Okl_Api.G_EXCEPTION_ERROR;

2422:
2423: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2424: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2425: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2426: RAISE Okl_Api.G_EXCEPTION_ERROR;
2427: END IF;
2428:
2429: EXCEPTION
2430: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

2514: x_msg_count => x_msg_count,
2515: x_msg_data => x_msg_data,
2516: p_cle_id => l_pyd_rec.cle_id);
2517:
2518: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_ERROR;
2522: END IF;

Line 2519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2515: x_msg_data => x_msg_data,
2516: p_cle_id => l_pyd_rec.cle_id);
2517:
2518: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: END IF;

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

2516: p_cle_id => l_pyd_rec.cle_id);
2517:
2518: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: END IF;
2524: --Bug# 4959361

Line 2521: RAISE OKL_API.G_EXCEPTION_ERROR;

2517:
2518: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2520: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_ERROR;
2522: END IF;
2523: END IF;
2524: --Bug# 4959361
2525:

Line 2534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2530: x_msg_data,
2531: p_ppydv_rec,
2532: x_ppydv_rec);
2533:
2534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2537: RAISE Okl_Api.G_EXCEPTION_ERROR;
2538: END IF;

Line 2535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2531: p_ppydv_rec,
2532: x_ppydv_rec);
2533:
2534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2537: RAISE Okl_Api.G_EXCEPTION_ERROR;
2538: END IF;
2539:

Line 2536: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2532: x_ppydv_rec);
2533:
2534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2537: RAISE Okl_Api.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: validate_dtls_record(x_return_status, x_ppydv_rec);

Line 2537: RAISE Okl_Api.G_EXCEPTION_ERROR;

2533:
2534: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2535: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2537: RAISE Okl_Api.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: validate_dtls_record(x_return_status, x_ppydv_rec);
2541: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 2541: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

2537: RAISE Okl_Api.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: validate_dtls_record(x_return_status, x_ppydv_rec);
2541: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2542: l_return_status := x_return_status;
2543: RAISE Okc_Api.G_EXCEPTION_ERROR;
2544: END IF;
2545:

Line 2562: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

2558: x_msg_count => x_msg_count,
2559: x_msg_data => x_msg_data,
2560: p_chr_id => l_chr_id);
2561:
2562: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2563: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2565: raise OKL_API.G_EXCEPTION_ERROR;
2566: End If;

Line 2563: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2559: x_msg_data => x_msg_data,
2560: p_chr_id => l_chr_id);
2561:
2562: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2563: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2565: raise OKL_API.G_EXCEPTION_ERROR;
2566: End If;
2567: END IF;

Line 2564: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

2560: p_chr_id => l_chr_id);
2561:
2562: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2563: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2565: raise OKL_API.G_EXCEPTION_ERROR;
2566: End If;
2567: END IF;
2568: -- Bug 4917691: fmiao end

Line 2565: raise OKL_API.G_EXCEPTION_ERROR;

2561:
2562: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2563: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2564: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2565: raise OKL_API.G_EXCEPTION_ERROR;
2566: End If;
2567: END IF;
2568: -- Bug 4917691: fmiao end
2569:

Line 2612: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2608: x_ppydv_tbl OUT NOCOPY ppydv_tbl_type
2609: ) IS
2610: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PAYMENT_DTLS';
2611: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2612: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2613: i NUMBER;
2614:
2615: BEGIN
2616:

Line 2628: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2624: x_msg_count,
2625: x_msg_data,
2626: p_ppydv_tbl(i),
2627: x_ppydv_tbl(i));
2628: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2629: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2630: l_overall_status := x_return_status;
2631: END IF;
2632: END IF;

Line 2629: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2625: x_msg_data,
2626: p_ppydv_tbl(i),
2627: x_ppydv_tbl(i));
2628: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2629: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2630: l_overall_status := x_return_status;
2631: END IF;
2632: END IF;
2633:

Line 2642: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2638: -- return overall status
2639: x_return_status := l_overall_status;
2640: END IF;
2641:
2642: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2645: RAISE Okl_Api.G_EXCEPTION_ERROR;
2646: END IF;

Line 2643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2639: x_return_status := l_overall_status;
2640: END IF;
2641:
2642: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2645: RAISE Okl_Api.G_EXCEPTION_ERROR;
2646: END IF;
2647:

Line 2644: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2640: END IF;
2641:
2642: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2645: RAISE Okl_Api.G_EXCEPTION_ERROR;
2646: END IF;
2647:
2648: EXCEPTION

Line 2645: RAISE Okl_Api.G_EXCEPTION_ERROR;

2641:
2642: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2644: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2645: RAISE Okl_Api.G_EXCEPTION_ERROR;
2646: END IF;
2647:
2648: EXCEPTION
2649: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2707: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2703: x_msg_count,
2704: x_msg_data,
2705: p_ppydv_rec);
2706:
2707: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2708: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2709: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2710: RAISE Okl_Api.G_EXCEPTION_ERROR;
2711: END IF;

Line 2708: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2704: x_msg_data,
2705: p_ppydv_rec);
2706:
2707: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2708: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2709: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2710: RAISE Okl_Api.G_EXCEPTION_ERROR;
2711: END IF;
2712:

Line 2709: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2705: p_ppydv_rec);
2706:
2707: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2708: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2709: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2710: RAISE Okl_Api.G_EXCEPTION_ERROR;
2711: END IF;
2712:
2713: Okc_Api.END_ACTIVITY (x_msg_count

Line 2710: RAISE Okl_Api.G_EXCEPTION_ERROR;

2706:
2707: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2708: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2709: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2710: RAISE Okl_Api.G_EXCEPTION_ERROR;
2711: END IF;
2712:
2713: Okc_Api.END_ACTIVITY (x_msg_count
2714: ,x_msg_data );

Line 2753: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2749: p_ppydv_tbl IN ppydv_tbl_type
2750: ) IS
2751: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_PARTY_PAYMENT_DTLS';
2752: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2753: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2754: i NUMBER;
2755: BEGIN
2756:
2757: IF p_ppydv_tbl.COUNT > 0 THEN

Line 2767: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2763: x_return_status,
2764: x_msg_count,
2765: x_msg_data,
2766: p_ppydv_tbl(i));
2767: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2768: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2769: l_overall_status := x_return_status;
2770: END IF;
2771: END IF;

Line 2768: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2764: x_msg_count,
2765: x_msg_data,
2766: p_ppydv_tbl(i));
2767: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2768: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2769: l_overall_status := x_return_status;
2770: END IF;
2771: END IF;
2772:

Line 2781: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2777: -- return overall status
2778: x_return_status := l_overall_status;
2779: END IF;
2780:
2781: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2784: RAISE Okl_Api.G_EXCEPTION_ERROR;
2785: END IF;

Line 2782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2778: x_return_status := l_overall_status;
2779: END IF;
2780:
2781: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2784: RAISE Okl_Api.G_EXCEPTION_ERROR;
2785: END IF;
2786:

Line 2783: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN

2779: END IF;
2780:
2781: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2784: RAISE Okl_Api.G_EXCEPTION_ERROR;
2785: END IF;
2786:
2787: EXCEPTION

Line 2784: RAISE Okl_Api.G_EXCEPTION_ERROR;

2780:
2781: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2782: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2783: ELSIF x_return_status = Okl_Api.G_RET_STS_ERROR THEN
2784: RAISE Okl_Api.G_EXCEPTION_ERROR;
2785: END IF;
2786:
2787: EXCEPTION
2788: WHEN Okc_Api.G_EXCEPTION_ERROR THEN