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_SETUPPQVALUES_PUB dependencies on OKL_SETUPPQVALUES_PUB

Line 1: PACKAGE BODY OKL_SETUPPQVALUES_PUB AS

1: PACKAGE BODY OKL_SETUPPQVALUES_PUB AS
2: /* $Header: OKLPSUVB.pls 120.3 2007/09/26 08:22:34 rajnisku ship $ */
3: -- Start of wraper code generated automatically by Debug code generator
4: L_MODULE VARCHAR2(40) := 'LEASE.SETUP.PRODUCTS';
5: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 152: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');

148:
149: WHEN OTHERS THEN
150: -- notify caller of an UNEXPECTED error
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
153:
154: -- store SQL error message on message stack for caller
155: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
156: p_count => x_msg_count,

Line 252: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');

248:
249: WHEN OTHERS THEN
250: -- notify caller of an UNEXPECTED error
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
253:
254: -- store SQL error message on message stack for caller
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
256: p_count => x_msg_count,

Line 287: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues

283:
284:
285:
286: -- call process api to insert dqualitys
287: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
288: IF(L_DEBUG_ENABLED='Y') THEN
289: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
290: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
291: END IF;

Line 294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');

290: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
291: END IF;
292: IF(IS_DEBUG_PROCEDURE_ON) THEN
293: BEGIN
294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');
295: END;
296: END IF;
297: OKL_SETUPPQVALUES_PVT.insert_pqvalues(p_api_version => p_api_version, p_init_msg_list => p_init_msg_list,
298: x_return_status => l_return_status,

Line 307: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');

303: p_pqvv_tbl => l_pqvv_tbl,
304: x_pqvv_tbl => x_pqvv_tbl);
305: IF(IS_DEBUG_PROCEDURE_ON) THEN
306: BEGIN
307: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');
308: END;
309: END IF;
310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
311:

Line 310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues

306: BEGIN
307: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.insert_pqvalues ');
308: END;
309: END IF;
310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
311:
312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 348: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');

344:
345: WHEN OTHERS THEN
346: -- notify caller of an UNEXPECTED error
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
349:
350: -- store SQL error message on message stack for caller
351: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
352: p_count => x_msg_count,

Line 383: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues

379:
380:
381:
382: -- call process api to insert dqualitys
383: -- Start of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
384: IF(L_DEBUG_ENABLED='Y') THEN
385: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
386: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
387: END IF;

Line 390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.update_pqvalues ');

386: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
387: END IF;
388: IF(IS_DEBUG_PROCEDURE_ON) THEN
389: BEGIN
390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.update_pqvalues ');
391: END;
392: END IF;
393: OKL_SETUPPQVALUES_PVT.update_pqvalues(p_api_version => p_api_version, p_init_msg_list => p_init_msg_list,
394: x_return_status => l_return_status,

Line 403: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.update_pqvalues ');

399: p_pqvv_tbl => l_pqvv_tbl,
400: x_pqvv_tbl => x_pqvv_tbl);
401: IF(IS_DEBUG_PROCEDURE_ON) THEN
402: BEGIN
403: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.update_pqvalues ');
404: END;
405: END IF;
406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
407:

Line 406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues

402: BEGIN
403: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSUVB.pls call OKL_SETUPPQVALUES_PUB.update_pqvalues ');
404: END;
405: END IF;
406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
407:
408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 444: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');

440:
441: WHEN OTHERS THEN
442: -- notify caller of an UNEXPECTED error
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
445:
446: -- store SQL error message on message stack for caller
447: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
448: p_count => x_msg_count,

Line 453: END OKL_SETUPPQVALUES_PUB;

449: p_data => x_msg_data);
450: END update_pqvalues;
451:
452:
453: END OKL_SETUPPQVALUES_PUB;