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

Line 25: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');

21: BEGIN
22:
23: x_return_status := l_return_status;
24: If( p_srfvv_rec.pay_site_id IS NULL) Then
25: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');
26: x_return_status := OKL_API.G_RET_STS_ERROR;
27: RAISE G_EXCEPTION_HALT_VALIDATION;
28: End If;
29: /* If( p_srfvv_rec.payment_term_id IS NULL) Then

Line 26: x_return_status := OKL_API.G_RET_STS_ERROR;

22:
23: x_return_status := l_return_status;
24: If( p_srfvv_rec.pay_site_id IS NULL) Then
25: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Pay Site');
26: x_return_status := OKL_API.G_RET_STS_ERROR;
27: RAISE G_EXCEPTION_HALT_VALIDATION;
28: End If;
29: /* If( p_srfvv_rec.payment_term_id IS NULL) Then
30: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');

Line 30: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');

26: x_return_status := OKL_API.G_RET_STS_ERROR;
27: RAISE G_EXCEPTION_HALT_VALIDATION;
28: End If;
29: /* If( p_srfvv_rec.payment_term_id IS NULL) Then
30: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');
31: x_return_status := OKL_API.G_RET_STS_ERROR;
32: RAISE G_EXCEPTION_HALT_VALIDATION;
33: End If;
34: If (p_srfvv_rec.payment_method_code IS NULL) Then

Line 31: x_return_status := OKL_API.G_RET_STS_ERROR;

27: RAISE G_EXCEPTION_HALT_VALIDATION;
28: End If;
29: /* If( p_srfvv_rec.payment_term_id IS NULL) Then
30: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Term');
31: x_return_status := OKL_API.G_RET_STS_ERROR;
32: RAISE G_EXCEPTION_HALT_VALIDATION;
33: End If;
34: If (p_srfvv_rec.payment_method_code IS NULL) Then
35: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Method');

Line 35: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Method');

31: x_return_status := OKL_API.G_RET_STS_ERROR;
32: RAISE G_EXCEPTION_HALT_VALIDATION;
33: End If;
34: If (p_srfvv_rec.payment_method_code IS NULL) Then
35: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Method');
36: x_return_status := OKL_API.G_RET_STS_ERROR;
37: RAISE G_EXCEPTION_HALT_VALIDATION;
38: End If;
39: */

Line 36: x_return_status := OKL_API.G_RET_STS_ERROR;

32: RAISE G_EXCEPTION_HALT_VALIDATION;
33: End If;
34: If (p_srfvv_rec.payment_method_code IS NULL) Then
35: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Payment Method');
36: x_return_status := OKL_API.G_RET_STS_ERROR;
37: RAISE G_EXCEPTION_HALT_VALIDATION;
38: End If;
39: */
40: --validate vendor id

Line 50: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Vendor_Id');

46: Null;
47: end if;
48: close l_cplb_csr;
49: If l_exists = 'N' then
50: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Vendor_Id');
51: x_return_status := OKL_API.G_RET_STS_ERROR;
52: RAISE G_EXCEPTION_HALT_VALIDATION;
53: End If;
54: --end validate vendor id

Line 51: x_return_status := OKL_API.G_RET_STS_ERROR;

47: end if;
48: close l_cplb_csr;
49: If l_exists = 'N' then
50: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Vendor_Id');
51: x_return_status := OKL_API.G_RET_STS_ERROR;
52: RAISE G_EXCEPTION_HALT_VALIDATION;
53: End If;
54: --end validate vendor id
55:

Line 60: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

56: EXCEPTION
57: WHEN G_EXCEPTION_HALT_VALIDATION THEN
58: null;
59: WHEN OTHERS THEN
60: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
61: ,p_msg_name => G_UNEXPECTED_ERROR
62: ,p_token1 => G_SQLCODE_TOKEN
63: ,p_token1_value => SQLCODE
64: ,p_token2 => G_SQLERRM_TOKEN

Line 66: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

62: ,p_token1 => G_SQLCODE_TOKEN
63: ,p_token1_value => SQLCODE
64: ,p_token2 => G_SQLERRM_TOKEN
65: ,p_token2_value => SQLERRM);
66: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
67: END validate_refund_record;
68:
69: PROCEDURE create_refund_dtls(
70: p_api_version IN NUMBER,

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

115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data,
117: p_cle_id => l_cpl_rec.cle_id);
118:
119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123: END IF;

Line 120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

116: x_msg_data => x_msg_data,
117: p_cle_id => l_cpl_rec.cle_id);
118:
119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123: END IF;
124: END IF;

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

117: p_cle_id => l_cpl_rec.cle_id);
118:
119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123: END IF;
124: END IF;
125: --Bug# 4959361

Line 122: RAISE OKL_API.G_EXCEPTION_ERROR;

118:
119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
122: RAISE OKL_API.G_EXCEPTION_ERROR;
123: END IF;
124: END IF;
125: --Bug# 4959361
126:

Line 135: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

131: x_msg_data,
132: p_srfvv_rec,
133: x_srfvv_rec);
134:
135: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
136: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
138: raise OKL_API.G_EXCEPTION_ERROR;
139: End If;

Line 136: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

132: p_srfvv_rec,
133: x_srfvv_rec);
134:
135: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
136: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
138: raise OKL_API.G_EXCEPTION_ERROR;
139: End If;
140:

Line 137: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

133: x_srfvv_rec);
134:
135: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
136: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
138: raise OKL_API.G_EXCEPTION_ERROR;
139: End If;
140:
141: validate_refund_record(x_return_status, x_srfvv_rec);

Line 138: raise OKL_API.G_EXCEPTION_ERROR;

134:
135: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
136: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
137: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
138: raise OKL_API.G_EXCEPTION_ERROR;
139: End If;
140:
141: validate_refund_record(x_return_status, x_srfvv_rec);
142: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 142: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

138: raise OKL_API.G_EXCEPTION_ERROR;
139: End If;
140:
141: validate_refund_record(x_return_status, x_srfvv_rec);
142: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
143: l_return_status := x_return_status;
144: RAISE OKC_API.G_EXCEPTION_ERROR;
145: END IF;
146:

Line 189: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

185: x_srfvv_tbl OUT NOCOPY srfvv_tbl_type
186: ) IS
187: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SUBSIDY_REFUND';
188: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
189: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
190: i NUMBER;
191: BEGIN
192:
193: If p_srfvv_tbl.COUNT > 0 Then

Line 204: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

200: x_msg_count,
201: x_msg_data,
202: p_srfvv_tbl(i),
203: x_srfvv_tbl(i));
204: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
205: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
206: l_overall_status := x_return_status;
207: End If;
208: End If;

Line 205: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

201: x_msg_data,
202: p_srfvv_tbl(i),
203: x_srfvv_tbl(i));
204: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
205: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
206: l_overall_status := x_return_status;
207: End If;
208: End If;
209:

Line 218: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

214: -- return overall status
215: x_return_status := l_overall_status;
216: End If;
217:
218: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
219: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
221: raise OKL_API.G_EXCEPTION_ERROR;
222: End If;

Line 219: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

215: x_return_status := l_overall_status;
216: End If;
217:
218: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
219: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
221: raise OKL_API.G_EXCEPTION_ERROR;
222: End If;
223:

Line 220: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

216: End If;
217:
218: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
219: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
221: raise OKL_API.G_EXCEPTION_ERROR;
222: End If;
223:
224: EXCEPTION

Line 221: raise OKL_API.G_EXCEPTION_ERROR;

217:
218: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
219: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
220: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
221: raise OKL_API.G_EXCEPTION_ERROR;
222: End If;
223:
224: EXCEPTION
225: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 283: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

279: x_msg_count,
280: x_msg_data,
281: p_srfvv_rec);
282:
283: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
284: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
286: raise OKL_API.G_EXCEPTION_ERROR;
287: End If;

Line 284: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

280: x_msg_data,
281: p_srfvv_rec);
282:
283: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
284: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
286: raise OKL_API.G_EXCEPTION_ERROR;
287: End If;
288:

Line 285: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

281: p_srfvv_rec);
282:
283: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
284: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
286: raise OKL_API.G_EXCEPTION_ERROR;
287: End If;
288:
289: OKC_API.END_ACTIVITY (x_msg_count

Line 286: raise OKL_API.G_EXCEPTION_ERROR;

282:
283: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
284: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
285: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
286: raise OKL_API.G_EXCEPTION_ERROR;
287: End If;
288:
289: OKC_API.END_ACTIVITY (x_msg_count
290: ,x_msg_data );

Line 329: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

325: p_srfvv_tbl IN srfvv_tbl_type
326: ) IS
327: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_SUBSIDY_REFUND';
328: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
329: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
330: i NUMBER;
331: BEGIN
332:
333: If p_srfvv_tbl.COUNT > 0 Then

Line 343: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

339: x_return_status,
340: x_msg_count,
341: x_msg_data,
342: p_srfvv_tbl(i));
343: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
344: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
345: l_overall_status := x_return_status;
346: End If;
347: End If;

Line 344: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

340: x_msg_count,
341: x_msg_data,
342: p_srfvv_tbl(i));
343: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
344: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
345: l_overall_status := x_return_status;
346: End If;
347: End If;
348:

Line 357: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

353: -- return overall status
354: x_return_status := l_overall_status;
355: End If;
356:
357: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: End If;

Line 358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

354: x_return_status := l_overall_status;
355: End If;
356:
357: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: End If;
362:

Line 359: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

355: End If;
356:
357: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: End If;
362:
363: EXCEPTION

Line 360: raise OKL_API.G_EXCEPTION_ERROR;

356:
357: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
358: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
359: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
360: raise OKL_API.G_EXCEPTION_ERROR;
361: End If;
362:
363: EXCEPTION
364: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

437: x_msg_count => x_msg_count,
438: x_msg_data => x_msg_data,
439: p_cle_id => l_cpl_rec.cle_id);
440:
441: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
444: RAISE OKL_API.G_EXCEPTION_ERROR;
445: END IF;

Line 442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

438: x_msg_data => x_msg_data,
439: p_cle_id => l_cpl_rec.cle_id);
440:
441: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
444: RAISE OKL_API.G_EXCEPTION_ERROR;
445: END IF;
446: END IF;

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

439: p_cle_id => l_cpl_rec.cle_id);
440:
441: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
444: RAISE OKL_API.G_EXCEPTION_ERROR;
445: END IF;
446: END IF;
447: --Bug# 4959361

Line 444: RAISE OKL_API.G_EXCEPTION_ERROR;

440:
441: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
443: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
444: RAISE OKL_API.G_EXCEPTION_ERROR;
445: END IF;
446: END IF;
447: --Bug# 4959361
448:

Line 456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

452: x_msg_count,
453: x_msg_data,
454: p_srfvv_rec);
455:
456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
459: raise OKL_API.G_EXCEPTION_ERROR;
460: End If;

Line 457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

453: x_msg_data,
454: p_srfvv_rec);
455:
456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
459: raise OKL_API.G_EXCEPTION_ERROR;
460: End If;
461:

Line 458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

454: p_srfvv_rec);
455:
456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
459: raise OKL_API.G_EXCEPTION_ERROR;
460: End If;
461:
462: OKC_API.END_ACTIVITY (x_msg_count

Line 459: raise OKL_API.G_EXCEPTION_ERROR;

455:
456: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
459: raise OKL_API.G_EXCEPTION_ERROR;
460: End If;
461:
462: OKC_API.END_ACTIVITY (x_msg_count
463: ,x_msg_data );

Line 502: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

498: p_srfvv_tbl IN srfvv_tbl_type
499: ) IS
500: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_SUBSIDY_REFUND';
501: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
502: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
503: i NUMBER;
504: BEGIN
505:
506: If p_srfvv_tbl.COUNT > 0 Then

Line 516: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

512: x_return_status,
513: x_msg_count,
514: x_msg_data,
515: p_srfvv_tbl(i));
516: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
517: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
518: l_overall_status := x_return_status;
519: End If;
520: End If;

Line 517: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

513: x_msg_count,
514: x_msg_data,
515: p_srfvv_tbl(i));
516: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
517: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
518: l_overall_status := x_return_status;
519: End If;
520: End If;
521:

Line 530: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

526: -- return overall status
527: x_return_status := l_overall_status;
528: End If;
529:
530: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
531: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
533: raise OKL_API.G_EXCEPTION_ERROR;
534: End If;

Line 531: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

527: x_return_status := l_overall_status;
528: End If;
529:
530: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
531: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
533: raise OKL_API.G_EXCEPTION_ERROR;
534: End If;
535:

Line 532: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

528: End If;
529:
530: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
531: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
533: raise OKL_API.G_EXCEPTION_ERROR;
534: End If;
535:
536: EXCEPTION

Line 533: raise OKL_API.G_EXCEPTION_ERROR;

529:
530: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
531: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
532: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
533: raise OKL_API.G_EXCEPTION_ERROR;
534: End If;
535:
536: EXCEPTION
537: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

609: x_msg_count => x_msg_count,
610: x_msg_data => x_msg_data,
611: p_cle_id => l_cpl_rec.cle_id);
612:
613: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;

Line 614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

610: x_msg_data => x_msg_data,
611: p_cle_id => l_cpl_rec.cle_id);
612:
613: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;

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

611: p_cle_id => l_cpl_rec.cle_id);
612:
613: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;
619: --Bug# 4959361

Line 616: RAISE OKL_API.G_EXCEPTION_ERROR;

612:
613: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;
619: --Bug# 4959361
620:

Line 629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

625: x_msg_data,
626: p_srfvv_rec,
627: x_srfvv_rec);
628:
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;

Line 630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

626: p_srfvv_rec,
627: x_srfvv_rec);
628:
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:

Line 631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

627: x_srfvv_rec);
628:
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: validate_refund_record(x_return_status, x_srfvv_rec);

Line 632: raise OKL_API.G_EXCEPTION_ERROR;

628:
629: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
630: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: validate_refund_record(x_return_status, x_srfvv_rec);
636: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 636: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

632: raise OKL_API.G_EXCEPTION_ERROR;
633: End If;
634:
635: validate_refund_record(x_return_status, x_srfvv_rec);
636: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
637: l_return_status := x_return_status;
638: RAISE OKC_API.G_EXCEPTION_ERROR;
639: END IF;
640:

Line 682: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

678: x_srfvv_tbl OUT NOCOPY srfvv_tbl_type
679: ) IS
680: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SUBSIDY_REFUND';
681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
683: i NUMBER;
684:
685: BEGIN
686:

Line 698: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

694: x_msg_count,
695: x_msg_data,
696: p_srfvv_tbl(i),
697: x_srfvv_tbl(i));
698: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
699: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
700: l_overall_status := x_return_status;
701: End If;
702: End If;

Line 699: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

695: x_msg_data,
696: p_srfvv_tbl(i),
697: x_srfvv_tbl(i));
698: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
699: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
700: l_overall_status := x_return_status;
701: End If;
702: End If;
703:

Line 712: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

708: -- return overall status
709: x_return_status := l_overall_status;
710: End If;
711:
712: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
713: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
715: raise OKL_API.G_EXCEPTION_ERROR;
716: End If;

Line 713: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

709: x_return_status := l_overall_status;
710: End If;
711:
712: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
713: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
715: raise OKL_API.G_EXCEPTION_ERROR;
716: End If;
717:

Line 714: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

710: End If;
711:
712: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
713: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
715: raise OKL_API.G_EXCEPTION_ERROR;
716: End If;
717:
718: EXCEPTION

Line 715: raise OKL_API.G_EXCEPTION_ERROR;

711:
712: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
713: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
714: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
715: raise OKL_API.G_EXCEPTION_ERROR;
716: End If;
717:
718: EXCEPTION
719: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 777: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

773: x_msg_count,
774: x_msg_data,
775: p_srfvv_rec);
776:
777: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;

Line 778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

774: x_msg_data,
775: p_srfvv_rec);
776:
777: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:

Line 779: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

775: p_srfvv_rec);
776:
777: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:
783: OKC_API.END_ACTIVITY (x_msg_count

Line 780: raise OKL_API.G_EXCEPTION_ERROR;

776:
777: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
778: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
779: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
780: raise OKL_API.G_EXCEPTION_ERROR;
781: End If;
782:
783: OKC_API.END_ACTIVITY (x_msg_count
784: ,x_msg_data );

Line 823: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

819: p_srfvv_tbl IN srfvv_tbl_type
820: ) IS
821: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_REFUND';
822: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
823: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
824: i NUMBER;
825: BEGIN
826:
827: If p_srfvv_tbl.COUNT > 0 Then

Line 837: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

833: x_return_status,
834: x_msg_count,
835: x_msg_data,
836: p_srfvv_tbl(i));
837: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
838: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
839: l_overall_status := x_return_status;
840: End If;
841: End If;

Line 838: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

834: x_msg_count,
835: x_msg_data,
836: p_srfvv_tbl(i));
837: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
838: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
839: l_overall_status := x_return_status;
840: End If;
841: End If;
842:

Line 851: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

847: -- return overall status
848: x_return_status := l_overall_status;
849: End If;
850:
851: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
854: raise OKL_API.G_EXCEPTION_ERROR;
855: End If;

Line 852: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: x_return_status := l_overall_status;
849: End If;
850:
851: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
854: raise OKL_API.G_EXCEPTION_ERROR;
855: End If;
856:

Line 853: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

849: End If;
850:
851: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
854: raise OKL_API.G_EXCEPTION_ERROR;
855: End If;
856:
857: EXCEPTION

Line 854: raise OKL_API.G_EXCEPTION_ERROR;

850:
851: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
852: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
854: raise OKL_API.G_EXCEPTION_ERROR;
855: End If;
856:
857: EXCEPTION
858: WHEN OKC_API.G_EXCEPTION_ERROR THEN