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

Line 24: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

20: --End of comments
21: --------------------------------------------------------------------------------
22: Procedure Validate_Cancel_Contract
23: (p_api_version IN NUMBER,
24: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_contract_id IN NUMBER) is

Line 79: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

75: WHERE otcr.id = otra.rct_id_details
76: AND otcr.receipt_type = 'ADV'
77: AND otra.khr_id = p_contract_id;
78:
79: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
80: l_api_name CONSTANT varchar2(30) := 'VALIDATE_CANCEL_CONTRACTS';
81: l_api_version CONSTANT NUMBER := 1.0;
82: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
83: l_sts_code OKC_K_HEADERS_V.sts_code%TYPE := NULL;

Line 92: x_return_status := OKL_API.G_RET_STS_SUCCESS;

88: l_billing_invoice_status VARCHAR2(1) := '?';
89: l_advance_receipt_status VARCHAR2(1) := '?';
90:
91: begin
92: x_return_status := OKL_API.G_RET_STS_SUCCESS;
93: -- Call start_activity to create savepoint, check compatibility
94: -- and initialize message list
95: x_return_status := OKL_API.START_ACTIVITY (
96: l_api_name

Line 95: x_return_status := OKL_API.START_ACTIVITY (

91: begin
92: x_return_status := OKL_API.G_RET_STS_SUCCESS;
93: -- Call start_activity to create savepoint, check compatibility
94: -- and initialize message list
95: x_return_status := OKL_API.START_ACTIVITY (
96: l_api_name
97: ,p_init_msg_list
98: ,'_PVT'
99: ,x_return_status);

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

97: ,p_init_msg_list
98: ,'_PVT'
99: ,x_return_status);
100: -- Check if activity started successfully
101: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;

Line 102: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

98: ,'_PVT'
99: ,x_return_status);
100: -- Check if activity started successfully
101: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;
106:

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

99: ,x_return_status);
100: -- Check if activity started successfully
101: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;
106:
107: -- Get Contract Number from Original Contract

Line 104: RAISE OKL_API.G_EXCEPTION_ERROR;

100: -- Check if activity started successfully
101: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
102: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
103: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
104: RAISE OKL_API.G_EXCEPTION_ERROR;
105: END IF;
106:
107: -- Get Contract Number from Original Contract
108: OPEN contract_csr(p_contract_id);

Line 112: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

108: OPEN contract_csr(p_contract_id);
109: FETCH contract_csr INTO l_contract_number;
110:
111: IF contract_csr%NOTFOUND THEN
112: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
113: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
114: p_msg_name => G_LLA_CHR_ID);
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: END IF;

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

109: FETCH contract_csr INTO l_contract_number;
110:
111: IF contract_csr%NOTFOUND THEN
112: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
113: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
114: p_msg_name => G_LLA_CHR_ID);
115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
116: END IF;
117:

Line 133: x_return_status := OKL_API.G_RET_STS_ERROR;

129: p_token1 => G_CONTRACT_NUMBER_TOKEN,
130: p_token1_value => l_contract_number,
131: p_token2 => G_STATUS_CODE_TOKEN,
132: p_token2_value => l_sts_code);
133: x_return_status := OKL_API.G_RET_STS_ERROR;
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:
137: OPEN contract_status_csr(p_contract_id);

Line 134: RAISE OKL_API.G_EXCEPTION_ERROR;

130: p_token1_value => l_contract_number,
131: p_token2 => G_STATUS_CODE_TOKEN,
132: p_token2_value => l_sts_code);
133: x_return_status := OKL_API.G_RET_STS_ERROR;
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136:
137: OPEN contract_status_csr(p_contract_id);
138: FETCH contract_status_csr INTO l_sts_code;

Line 153: x_return_status := OKL_API.G_RET_STS_ERROR;

149: p_token1 => G_CONTRACT_NUMBER_TOKEN,
150: p_token1_value => l_contract_number,
151: p_token2 => G_STATUS_CODE_TOKEN,
152: p_token2_value => l_sts_code);
153: x_return_status := OKL_API.G_RET_STS_ERROR;
154: RAISE OKL_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: OPEN funding_disb_txn_csr(p_contract_id);

Line 154: RAISE OKL_API.G_EXCEPTION_ERROR;

150: p_token1_value => l_contract_number,
151: p_token2 => G_STATUS_CODE_TOKEN,
152: p_token2_value => l_sts_code);
153: x_return_status := OKL_API.G_RET_STS_ERROR;
154: RAISE OKL_API.G_EXCEPTION_ERROR;
155: END IF;
156:
157: OPEN funding_disb_txn_csr(p_contract_id);
158: FETCH funding_disb_txn_csr INTO l_funding_type_code;

Line 178: RAISE OKL_API.G_EXCEPTION_ERROR;

174: p_token2 => G_CONTRACT_NUMBER_TOKEN,
175: p_token2_value => l_contract_number);
176:
177: x_return_status := OKC_API.G_RET_STS_ERROR;
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: OPEN Billing_invoice_status_csr(p_contract_id);
182: FETCH Billing_invoice_status_csr INTO l_Billing_invoice_status;

Line 196: RAISE OKL_API.G_EXCEPTION_ERROR;

192: p_token1 => G_CONTRACT_NUMBER_TOKEN,
193: p_token1_value => l_contract_number);
194:
195: x_return_status := OKC_API.G_RET_STS_ERROR;
196: RAISE OKL_API.G_EXCEPTION_ERROR;
197: END IF;
198:
199: OPEN Advance_receipt_csr(p_contract_id);
200: FETCH Advance_receipt_csr INTO l_advance_receipt_status;

Line 214: RAISE OKL_API.G_EXCEPTION_ERROR;

210: p_token1 => G_CONTRACT_NUMBER_TOKEN,
211: p_token1_value => l_contract_number);
212:
213: x_return_status := OKC_API.G_RET_STS_ERROR;
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
217: EXCEPTION
218: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

212:
213: x_return_status := OKC_API.G_RET_STS_ERROR;
214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
217: EXCEPTION
218: WHEN OKL_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
220: l_api_name,

Line 218: WHEN OKL_API.G_EXCEPTION_ERROR THEN

214: RAISE OKL_API.G_EXCEPTION_ERROR;
215: END IF;
216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
217: EXCEPTION
218: WHEN OKL_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
220: l_api_name,
221: G_PKG_NAME,
222: 'OKL_API.G_RET_STS_ERROR',

Line 219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

215: END IF;
216: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
217: EXCEPTION
218: WHEN OKL_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
220: l_api_name,
221: G_PKG_NAME,
222: 'OKL_API.G_RET_STS_ERROR',
223: x_msg_count,

Line 222: 'OKL_API.G_RET_STS_ERROR',

218: WHEN OKL_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
220: l_api_name,
221: G_PKG_NAME,
222: 'OKL_API.G_RET_STS_ERROR',
223: x_msg_count,
224: x_msg_data,
225: '_PVT');
226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

222: 'OKL_API.G_RET_STS_ERROR',
223: x_msg_count,
224: x_msg_data,
225: '_PVT');
226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
227: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
228: l_api_name,
229: G_PKG_NAME,
230: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 227: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

223: x_msg_count,
224: x_msg_data,
225: '_PVT');
226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
227: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
228: l_api_name,
229: G_PKG_NAME,
230: 'OKL_API.G_RET_STS_UNEXP_ERROR',
231: x_msg_count,

Line 230: 'OKL_API.G_RET_STS_UNEXP_ERROR',

226: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
227: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
228: l_api_name,
229: G_PKG_NAME,
230: 'OKL_API.G_RET_STS_UNEXP_ERROR',
231: x_msg_count,
232: x_msg_data,
233: '_PVT');
234: WHEN OTHERS THEN

Line 235: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

231: x_msg_count,
232: x_msg_data,
233: '_PVT');
234: WHEN OTHERS THEN
235: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
236: l_api_name,
237: G_PKG_NAME,
238: 'OTHERS',
239: x_msg_count,

Line 246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

242: end validate_cancel_contract;
243:
244: -- Added for bug #5944260/5981076(Forward R12 cklee) -- start
245: PROCEDURE cancel_funding_request(p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS

Line 271: x_return_status := OKL_API.G_RET_STS_SUCCESS;

267: r_tap c_tap%ROWTYPE;
268:
269: BEGIN
270:
271: x_return_status := OKL_API.G_RET_STS_SUCCESS;
272: -- Call start_activity to create savepoint, check compatibility
273: -- and initialize message list
274: x_return_status := OKL_API.START_ACTIVITY (
275: l_api_name,

Line 274: x_return_status := OKL_API.START_ACTIVITY (

270:
271: x_return_status := OKL_API.G_RET_STS_SUCCESS;
272: -- Call start_activity to create savepoint, check compatibility
273: -- and initialize message list
274: x_return_status := OKL_API.START_ACTIVITY (
275: l_api_name,
276: p_init_msg_list,
277: '_PVT',
278: x_return_status);

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

276: p_init_msg_list,
277: '_PVT',
278: x_return_status);
279: -- Check if activity started successfully
280: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_ERROR;
284: END IF;

Line 281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

277: '_PVT',
278: x_return_status);
279: -- Check if activity started successfully
280: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_ERROR;
284: END IF;
285:

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

278: x_return_status);
279: -- Check if activity started successfully
280: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_ERROR;
284: END IF;
285:
286: -- Get the internal invoice Details

Line 283: RAISE OKL_API.G_EXCEPTION_ERROR;

279: -- Check if activity started successfully
280: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_ERROR;
284: END IF;
285:
286: -- Get the internal invoice Details
287: OPEN c_tap(p_funding_id);

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

304: x_msg_data => x_msg_data,
305: p_tapv_rec => l_tapv_rec,
306: x_tapv_rec => x_tapv_rec);
307:
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;

Line 309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

305: p_tapv_rec => l_tapv_rec,
306: x_tapv_rec => x_tapv_rec);
307:
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:

Line 310: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

306: x_tapv_rec => x_tapv_rec);
307:
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314:

Line 311: RAISE OKL_API.G_EXCEPTION_ERROR;

307:
308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314:
315: OKL_API.END_ACTIVITY (x_msg_count,

Line 315: OKL_API.END_ACTIVITY (x_msg_count,

311: RAISE OKL_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314:
315: OKL_API.END_ACTIVITY (x_msg_count,
316: x_msg_data );
317:
318:
319:

Line 321: WHEN OKL_API.G_EXCEPTION_ERROR THEN

317:
318:
319:
320: EXCEPTION
321: WHEN OKL_API.G_EXCEPTION_ERROR THEN
322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
323: l_api_name,
324: G_PKG_NAME,
325: 'OKL_API.G_RET_STS_ERROR',

Line 322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

318:
319:
320: EXCEPTION
321: WHEN OKL_API.G_EXCEPTION_ERROR THEN
322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
323: l_api_name,
324: G_PKG_NAME,
325: 'OKL_API.G_RET_STS_ERROR',
326: x_msg_count,

Line 325: 'OKL_API.G_RET_STS_ERROR',

321: WHEN OKL_API.G_EXCEPTION_ERROR THEN
322: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
323: l_api_name,
324: G_PKG_NAME,
325: 'OKL_API.G_RET_STS_ERROR',
326: x_msg_count,
327: x_msg_data,
328: '_PVT');
329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

325: 'OKL_API.G_RET_STS_ERROR',
326: x_msg_count,
327: x_msg_data,
328: '_PVT');
329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
330: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
331: l_api_name,
332: G_PKG_NAME,
333: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 330: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

326: x_msg_count,
327: x_msg_data,
328: '_PVT');
329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
330: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
331: l_api_name,
332: G_PKG_NAME,
333: 'OKL_API.G_RET_STS_UNEXP_ERROR',
334: x_msg_count,

Line 333: 'OKL_API.G_RET_STS_UNEXP_ERROR',

329: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
330: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
331: l_api_name,
332: G_PKG_NAME,
333: 'OKL_API.G_RET_STS_UNEXP_ERROR',
334: x_msg_count,
335: x_msg_data,
336: '_PVT');
337: WHEN OTHERS THEN

Line 338: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

334: x_msg_count,
335: x_msg_data,
336: '_PVT');
337: WHEN OTHERS THEN
338: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
339: l_api_name,
340: G_PKG_NAME,
341: 'OTHERS',
342: x_msg_count,

Line 356: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

352: --End of comments
353: --------------------------------------------------------------------------------
354: Procedure confirm_cancel_contract
355: (p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
357: x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2,
360: p_contract_id IN NUMBER,

Line 363: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

359: x_msg_data OUT NOCOPY VARCHAR2,
360: p_contract_id IN NUMBER,
361: p_new_contract_number IN VARCHAR2) is
362:
363: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
364: l_api_name CONSTANT varchar2(30) := 'CONVERT_FA_AMOUNTS';
365: l_api_version CONSTANT NUMBER := 1.0;
366: l_seq_no NUMBER;
367: l_orig_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 386: x_return_status := OKL_API.G_RET_STS_SUCCESS;

382: WHERE khr_id = p_contract_id
383: AND trx_status_code not in ('CANCELED','SUBMITTED', 'APPROVED', 'PROCESSED');
384: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End
385: Begin
386: x_return_status := OKL_API.G_RET_STS_SUCCESS;
387: -- Call start_activity to create savepoint, check compatibility
388: -- and initialize message list
389: x_return_status := OKL_API.START_ACTIVITY (
390: l_api_name

Line 389: x_return_status := OKL_API.START_ACTIVITY (

385: Begin
386: x_return_status := OKL_API.G_RET_STS_SUCCESS;
387: -- Call start_activity to create savepoint, check compatibility
388: -- and initialize message list
389: x_return_status := OKL_API.START_ACTIVITY (
390: l_api_name
391: ,p_init_msg_list
392: ,'_PVT'
393: ,x_return_status);

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

391: ,p_init_msg_list
392: ,'_PVT'
393: ,x_return_status);
394: -- Check if activity started successfully
395: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;

Line 396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

392: ,'_PVT'
393: ,x_return_status);
394: -- Check if activity started successfully
395: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;
400:

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

393: ,x_return_status);
394: -- Check if activity started successfully
395: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;
400:
401: Validate_Cancel_Contract

Line 398: RAISE OKL_API.G_EXCEPTION_ERROR;

394: -- Check if activity started successfully
395: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
397: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;
400:
401: Validate_Cancel_Contract
402: (p_api_version => 1.0,

Line 408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data,
406: p_contract_id => p_contract_id);
407:
408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
411: RAISE Okl_Api.G_EXCEPTION_ERROR;
412: END IF;

Line 409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

405: x_msg_data => x_msg_data,
406: p_contract_id => p_contract_id);
407:
408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
411: RAISE Okl_Api.G_EXCEPTION_ERROR;
412: END IF;
413:

Line 410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

406: p_contract_id => p_contract_id);
407:
408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
411: RAISE Okl_Api.G_EXCEPTION_ERROR;
412: END IF;
413:
414: -- Get Contract Number from Original Contract

Line 411: RAISE Okl_Api.G_EXCEPTION_ERROR;

407:
408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
411: RAISE Okl_Api.G_EXCEPTION_ERROR;
412: END IF;
413:
414: -- Get Contract Number from Original Contract
415: OPEN orig_csr(p_contract_id);

Line 419: okl_api.set_message(

415: OPEN orig_csr(p_contract_id);
416: FETCH orig_csr INTO l_orig_contract_number, l_orig_system_source_code, l_orig_system_id1;
417:
418: IF orig_csr%NOTFOUND THEN
419: okl_api.set_message(
420: G_APP_NAME,
421: G_LLA_CHR_ID
422: );
423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 433: p_init_msg_list => OKL_API.G_FALSE,

429: IF (l_orig_system_source_code = 'OKL_LEASE_APP') THEN
430:
431: OKL_LEASE_APP_PVT.revert_leaseapp
432: ( p_api_version => 1.0,
433: p_init_msg_list => OKL_API.G_FALSE,
434: p_leaseapp_id => l_orig_system_id1,
435: x_return_status => x_return_status,
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data );

Line 439: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

435: x_return_status => x_return_status,
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data );
438:
439: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
442: RAISE Okl_Api.G_EXCEPTION_ERROR;
443: END IF;

Line 440: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 441: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

437: x_msg_data => x_msg_data );
438:
439: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
442: RAISE Okl_Api.G_EXCEPTION_ERROR;
443: END IF;
444:
445: END IF;

Line 442: RAISE Okl_Api.G_EXCEPTION_ERROR;

438:
439: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
440: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
441: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
442: RAISE Okl_Api.G_EXCEPTION_ERROR;
443: END IF;
444:
445: END IF;
446:

Line 469: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,
467: p_funding_id => l_funding_id);
468:
469: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: RAISE Okl_Api.G_EXCEPTION_ERROR;
473: END IF;

Line 470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

466: x_msg_data => x_msg_data,
467: p_funding_id => l_funding_id);
468:
469: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: RAISE Okl_Api.G_EXCEPTION_ERROR;
473: END IF;
474: End loop;

Line 471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

467: p_funding_id => l_funding_id);
468:
469: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: RAISE Okl_Api.G_EXCEPTION_ERROR;
473: END IF;
474: End loop;
475: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End

Line 472: RAISE Okl_Api.G_EXCEPTION_ERROR;

468:
469: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: RAISE Okl_Api.G_EXCEPTION_ERROR;
473: END IF;
474: End loop;
475: -- Added for bug #5944260/5981076(Forward R12 cklee) -- End
476: -- Update the status of the header

Line 489: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

485: UPDATE okc_k_lines_b
486: SET sts_code = 'ABANDONED'
487: WHERE dnz_chr_id = p_contract_id;
488:
489: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
490: EXCEPTION
491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
493: l_api_name,

Line 491: WHEN OKL_API.G_EXCEPTION_ERROR THEN

487: WHERE dnz_chr_id = p_contract_id;
488:
489: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
490: EXCEPTION
491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
493: l_api_name,
494: G_PKG_NAME,
495: 'OKL_API.G_RET_STS_ERROR',

Line 492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

488:
489: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
490: EXCEPTION
491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
493: l_api_name,
494: G_PKG_NAME,
495: 'OKL_API.G_RET_STS_ERROR',
496: x_msg_count,

Line 495: 'OKL_API.G_RET_STS_ERROR',

491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
493: l_api_name,
494: G_PKG_NAME,
495: 'OKL_API.G_RET_STS_ERROR',
496: x_msg_count,
497: x_msg_data,
498: '_PVT');
499: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 499: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

495: 'OKL_API.G_RET_STS_ERROR',
496: x_msg_count,
497: x_msg_data,
498: '_PVT');
499: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
501: l_api_name,
502: G_PKG_NAME,
503: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

496: x_msg_count,
497: x_msg_data,
498: '_PVT');
499: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
501: l_api_name,
502: G_PKG_NAME,
503: 'OKL_API.G_RET_STS_UNEXP_ERROR',
504: x_msg_count,

Line 503: 'OKL_API.G_RET_STS_UNEXP_ERROR',

499: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
500: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
501: l_api_name,
502: G_PKG_NAME,
503: 'OKL_API.G_RET_STS_UNEXP_ERROR',
504: x_msg_count,
505: x_msg_data,
506: '_PVT');
507: WHEN OTHERS THEN

Line 508: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

504: x_msg_count,
505: x_msg_data,
506: '_PVT');
507: WHEN OTHERS THEN
508: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
509: l_api_name,
510: G_PKG_NAME,
511: 'OTHERS',
512: x_msg_count,