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

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

18: -- Declare variables required by APIs
19: ------------------------------------------------------------
20: l_api_version CONSTANT NUMBER := 1;
21: l_api_name CONSTANT VARCHAR2(30) := 'MANUAL_ENTRY';
22: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
23:
24: -----------------------------------------------------------------
25: -- Declare Process Variable
26: -----------------------------------------------------------------

Line 94: x_return_status := OKL_API.G_RET_STS_SUCCESS;

90: ------------------------------------------------------------
91: -- Start processing
92: ------------------------------------------------------------
93:
94: x_return_status := OKL_API.G_RET_STS_SUCCESS;
95:
96: l_return_status := OKL_API.START_ACTIVITY (
97: p_api_name => l_api_name,
98: p_pkg_name => g_pkg_name,

Line 96: l_return_status := OKL_API.START_ACTIVITY (

92: ------------------------------------------------------------
93:
94: x_return_status := OKL_API.G_RET_STS_SUCCESS;
95:
96: l_return_status := OKL_API.START_ACTIVITY (
97: p_api_name => l_api_name,
98: p_pkg_name => g_pkg_name,
99: p_init_msg_list => p_init_msg_list,
100: l_api_version => l_api_version,

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

101: p_api_version => p_api_version,
102: p_api_type => '_PVT',
103: x_return_status => x_return_status);
104:
105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;

Line 106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

102: p_api_type => '_PVT',
103: x_return_status => x_return_status);
104:
105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:

Line 107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

103: x_return_status => x_return_status);
104:
105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: IF (p_man_inv_rec.vendor_id IS NULL OR

Line 108: RAISE OKL_API.G_EXCEPTION_ERROR;

104:
105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: IF (p_man_inv_rec.vendor_id IS NULL OR
112: p_man_inv_rec.khr_id IS NULL OR

Line 116: OKL_Api.SET_MESSAGE

112: p_man_inv_rec.khr_id IS NULL OR
113: p_man_inv_rec.sty_id IS NULL OR
114: p_man_inv_rec.invoice_date IS NULL OR
115: p_man_inv_rec.amount IS NULL) THEN
116: OKL_Api.SET_MESSAGE
117: ( p_app_name => 'OKL',
118: p_msg_name => 'OKL_ENTER_REQD_FIELDS'
119: ) ;
120: x_return_status := OKL_Api.G_RET_STS_ERROR;

Line 120: x_return_status := OKL_Api.G_RET_STS_ERROR;

116: OKL_Api.SET_MESSAGE
117: ( p_app_name => 'OKL',
118: p_msg_name => 'OKL_ENTER_REQD_FIELDS'
119: ) ;
120: x_return_status := OKL_Api.G_RET_STS_ERROR;
121: RAISE G_EXCEPTION_HALT_VALIDATION;
122: END IF;
123:
124: ------------------------------------------------------------

Line 150: OR p_man_inv_rec.Vendor_Invoice_Number = OKL_API.G_MISS_CHAR THEN

146: -- Derive Invoice Number
147: ------------------------------------------------------------
148:
149: IF p_man_inv_rec.Vendor_Invoice_Number IS NULL
150: OR p_man_inv_rec.Vendor_Invoice_Number = OKL_API.G_MISS_CHAR THEN
151:
152: lp_tapv_rec.invoice_number := NULL;
153:
154: lp_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence

Line 305: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

301: ,x_tplv_tbl => lx_tplv_tbl);
302:
303: /* ankushar end changes */
304:
305: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
306:
307: --------------------------------------------
308: -- Populate inserted record details back
309: --------------------------------------------

Line 326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

322: ------------------------------------------------------------
323:
324: WHEN G_EXCEPTION_HALT_VALIDATION THEN
325: null;
326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
327: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
328: p_api_name => l_api_name,
329: p_pkg_name => G_PKG_NAME,
330: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 327: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

323:
324: WHEN G_EXCEPTION_HALT_VALIDATION THEN
325: null;
326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
327: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
328: p_api_name => l_api_name,
329: p_pkg_name => G_PKG_NAME,
330: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
331: x_msg_count => x_msg_count,

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

326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
327: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
328: p_api_name => l_api_name,
329: p_pkg_name => G_PKG_NAME,
330: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_api_type => '_PVT');
334:

Line 335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_api_type => '_PVT');
334:
335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
337: p_api_name => l_api_name,
338: p_pkg_name => G_PKG_NAME,
339: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 336: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

332: x_msg_data => x_msg_data,
333: p_api_type => '_PVT');
334:
335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
337: p_api_name => l_api_name,
338: p_pkg_name => G_PKG_NAME,
339: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
340: x_msg_count => x_msg_count,

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

335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
337: p_api_name => l_api_name,
338: p_pkg_name => G_PKG_NAME,
339: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
340: x_msg_count => x_msg_count,
341: x_msg_data => x_msg_data,
342: p_api_type => '_PVT');
343:

Line 345: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

341: x_msg_data => x_msg_data,
342: p_api_type => '_PVT');
343:
344: WHEN OTHERS THEN
345: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
346: p_api_name => l_api_name,
347: p_pkg_name => G_PKG_NAME,
348: p_exc_name => 'OTHERS',
349: x_msg_count => x_msg_count,

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

365: ,x_man_inv_tbl OUT NOCOPY man_inv_tbl_type) IS
366:
367: l_api_version CONSTANT NUMBER := 1;
368: l_api_name CONSTANT VARCHAR2(30) := 'MANUAL_ENTRY';
369: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
370: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
371: i NUMBER := 0;
372:
373: BEGIN

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

366:
367: l_api_version CONSTANT NUMBER := 1;
368: l_api_name CONSTANT VARCHAR2(30) := 'MANUAL_ENTRY';
369: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
370: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
371: i NUMBER := 0;
372:
373: BEGIN
374:

Line 386: p_init_msg_list => OKL_API.G_FALSE,

382: LOOP
383:
384: manual_entry (
385: p_api_version => l_api_version,
386: p_init_msg_list => OKL_API.G_FALSE,
387: x_return_status => x_return_status,
388: x_msg_count => x_msg_count,
389: x_msg_data => x_msg_data,
390: p_man_inv_rec => p_man_inv_tbl(i),

Line 393: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

389: x_msg_data => x_msg_data,
390: p_man_inv_rec => p_man_inv_tbl(i),
391: x_man_inv_rec => x_man_inv_tbl(i));
392:
393: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
394: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
395: l_overall_status := x_return_status;
396: END IF;
397: END IF;

Line 394: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

390: p_man_inv_rec => p_man_inv_tbl(i),
391: x_man_inv_rec => x_man_inv_tbl(i));
392:
393: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
394: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
395: l_overall_status := x_return_status;
396: END IF;
397: END IF;
398: