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

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

7:
8: --Global Variables
9: G_INIT_NUMBER NUMBER := -9999;
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PPD_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14: PROCEDURE validate_parameters(
15: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 62: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

58: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
59: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_parameters ...x_msg_count='||x_msg_count);
60: END IF;
61: IF (p_chr_id is null) THEN
62: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
63: fnd_message.set_token('API_NAME', l_api_name);
64: fnd_message.set_token('MISSING_PARAM', 'p_chr_id');
65: x_msg_count:= x_msg_count + 1;
66: l_missing_parameters := TRUE;

Line 71: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

67: fnd_msg_pub.add;
68: END IF;
69:
70: IF ((p_kle_tbl is null) or (p_kle_tbl.COUNT=0)) THEN
71: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
72: fnd_message.set_token('API_NAME', l_api_name);
73: fnd_message.set_token('MISSING_PARAM', 'p_kle_tbl');
74: x_msg_count:= x_msg_count + 1;
75: l_missing_parameters := TRUE;

Line 80: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

76: fnd_msg_pub.add;
77: END IF;
78:
79: IF (p_transaction_date is null) THEN
80: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
81: fnd_message.set_token('API_NAME', l_api_name);
82: fnd_message.set_token('MISSING_PARAM', 'p_transaction_date');
83: x_msg_count:= x_msg_count + 1;
84: l_missing_parameters := TRUE;

Line 89: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

85: fnd_msg_pub.add;
86: END IF;
87:
88: IF (p_ppd_amount is null) THEN
89: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
90: fnd_message.set_token('API_NAME', l_api_name);
91: fnd_message.set_token('MISSING_PARAM', 'p_ppd_amount');
92: x_msg_count:= x_msg_count + 1;
93: l_missing_parameters := TRUE;

Line 98: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

94: fnd_msg_pub.add;
95: END IF;
96:
97: IF (p_ppd_reason_code is null) THEN
98: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
99: fnd_message.set_token('API_NAME', l_api_name);
100: fnd_message.set_token('MISSING_PARAM', 'p_ppd_reason_code');
101: x_msg_count:= x_msg_count + 1;
102: l_missing_parameters := TRUE;

Line 107: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');

103: fnd_msg_pub.add;
104: END IF;
105:
106: IF (p_payment_struc is null) or (p_payment_struc.COUNT=0) THEN
107: fnd_message.set_name('OKL', 'OKL_API_ALL_MISSING_PARAM');
108: fnd_message.set_token('API_NAME', l_api_name);
109: fnd_message.set_token('MISSING_PARAM', 'p_payment_struc');
110: x_msg_count:= x_msg_count + 1;
111: l_missing_parameters := TRUE;

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

226: l_api_version CONSTANT NUMBER := 1;
227: l_api_name VARCHAR2(35) := 'apply_ppd';
228: l_proc_name VARCHAR2(35) := 'APPLY_PPD';
229: l_ppd_txn_id NUMBER;
230: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
231: l_mass_rebook_trx_id NUMBER;
232: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
233: l_msg_index_out number;
234: BEGIN

Line 242: x_return_status := OKL_API.START_ACTIVITY(

238: END IF;
239: -- DEBUG
240: -- call START_ACTIVITY to create savepoint, check compatibility
241: -- and initialize message list
242: x_return_status := OKL_API.START_ACTIVITY(
243: p_api_name => l_api_name,
244: p_pkg_name => G_PKG_NAME,
245: p_init_msg_list => p_init_msg_list,
246: l_api_version => l_api_version,

Line 252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

248: p_api_type => G_API_TYPE,
249: x_return_status => x_return_status);
250:
251: -- check if activity started successfully
252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: END IF;

Line 253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

249: x_return_status => x_return_status);
250:
251: -- check if activity started successfully
252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: END IF;
257:

Line 254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

250:
251: -- check if activity started successfully
252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: END IF;
257:
258: begin

Line 255: raise OKL_API.G_EXCEPTION_ERROR;

251: -- check if activity started successfully
252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: END IF;
257:
258: begin
259: x_msg_count := 0;

Line 293: if (x_return_status <> OKL_API.G_RET_STS_SUCCESS) then

289: p_reason_code => p_ppd_reason_code,
290: x_tcnv_rec => l_tcnv_rec
291: );
292:
293: if (x_return_status <> OKL_API.G_RET_STS_SUCCESS) then
294: okl_debug_pub.logmessage('Error occurred from okl_transaction_pvt.create_ppd_transaction');
295: okl_debug_pub.logmessage('x_msg_data=' || x_msg_data);
296: end if;
297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

Line 297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

293: if (x_return_status <> OKL_API.G_RET_STS_SUCCESS) then
294: okl_debug_pub.logmessage('Error occurred from okl_transaction_pvt.create_ppd_transaction');
295: okl_debug_pub.logmessage('x_msg_data=' || x_msg_data);
296: end if;
297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
298: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
300: raise OKL_API.G_EXCEPTION_ERROR;
301: END IF;

Line 298: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

294: okl_debug_pub.logmessage('Error occurred from okl_transaction_pvt.create_ppd_transaction');
295: okl_debug_pub.logmessage('x_msg_data=' || x_msg_data);
296: end if;
297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
298: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
300: raise OKL_API.G_EXCEPTION_ERROR;
301: END IF;
302: */

Line 299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

295: okl_debug_pub.logmessage('x_msg_data=' || x_msg_data);
296: end if;
297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
298: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
300: raise OKL_API.G_EXCEPTION_ERROR;
301: END IF;
302: */
303:

Line 300: raise OKL_API.G_EXCEPTION_ERROR;

296: end if;
297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
298: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
300: raise OKL_API.G_EXCEPTION_ERROR;
301: END IF;
302: */
303:
304: --x_ppd_txn_id := l_tcnv_rec.id;

Line 332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

328:
329: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKLRPPNB:After apply_mass_rebook: x_return_status=' || x_return_status);
331: END IF;
332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
333: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
335: raise OKL_API.G_EXCEPTION_ERROR;
336: END IF;

Line 333: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

329: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKLRPPNB:After apply_mass_rebook: x_return_status=' || x_return_status);
331: END IF;
332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
333: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
335: raise OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337:

Line 334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKLRPPNB:After apply_mass_rebook: x_return_status=' || x_return_status);
331: END IF;
332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
333: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
335: raise OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337:
338: EXCEPTION

Line 335: raise OKL_API.G_EXCEPTION_ERROR;

331: END IF;
332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
333: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
335: raise OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337:
338: EXCEPTION
339: when OKL_API.G_EXCEPTION_ERROR then

Line 339: when OKL_API.G_EXCEPTION_ERROR then

335: raise OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337:
338: EXCEPTION
339: when OKL_API.G_EXCEPTION_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

336: END IF;
337:
338: EXCEPTION
339: when OKL_API.G_EXCEPTION_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
344: x_msg_count => x_msg_count,

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

339: when OKL_API.G_EXCEPTION_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
344: x_msg_count => x_msg_count,
345: x_msg_data => x_msg_data,
346: p_api_type => G_API_TYPE);
347:

Line 348: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

344: x_msg_count => x_msg_count,
345: x_msg_data => x_msg_data,
346: p_api_type => G_API_TYPE);
347:
348: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
350: p_api_name => l_api_name,
351: p_pkg_name => G_PKG_NAME,
352: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

345: x_msg_data => x_msg_data,
346: p_api_type => G_API_TYPE);
347:
348: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
350: p_api_name => l_api_name,
351: p_pkg_name => G_PKG_NAME,
352: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
353: x_msg_count => x_msg_count,

Line 352: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

348: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
350: p_api_name => l_api_name,
351: p_pkg_name => G_PKG_NAME,
352: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
353: x_msg_count => x_msg_count,
354: x_msg_data => x_msg_data,
355: p_api_type => G_API_TYPE);
356:

Line 358: x_return_status := OKL_API.G_RET_STS_ERROR;

354: x_msg_data => x_msg_data,
355: p_api_type => G_API_TYPE);
356:
357: when missing_parameters then
358: x_return_status := OKL_API.G_RET_STS_ERROR;
359:
360: /* okl_debug_pub.logmessage('apply_ppd:x_msg_count=' || x_msg_count);
361: IF (x_msg_count > 0 ) THEN
362: FOR i in 1..x_msg_count

Line 383: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

379: END IF;
380: raise;
381:
382: when OTHERS then
383: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
384: p_api_name => l_api_name,
385: p_pkg_name => G_PKG_NAME,
386: p_exc_name => 'OTHERS',
387: x_msg_count => x_msg_count,