DBA Data[Home] [Help]

APPS.OKL_CONS_BILL dependencies on OKL_CONS_BILL

Line 1: PACKAGE BODY Okl_Cons_Bill AS

1: PACKAGE BODY Okl_Cons_Bill AS
2: /* $Header: OKLRKONB.pls 120.27.12010000.2 2008/12/12 20:28:19 cklee ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 56: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'

52: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
53: END IF;
54:
55: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
56: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'
57: ,'Process_Break Begin(+)');
58: END IF;
59:
60: -- ------------------------------------

Line 264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'

260: saved_bill_rec.l_commit_cnt := 0;
261: END IF;
262:
263: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'
265: ,'Process_Break End(-)');
266: END IF;
267:
268: EXCEPTION

Line 271: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',

267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
272: 'EXCEPTION (OTHERS) :'||SQLERRM);
273: END IF;
274:
275: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1528: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',

1524: ------------------------------------------------------------
1525:
1526: WHEN OTHERS THEN
1527: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1528: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
1529: 'EXCEPTION :'||'OTHERS');
1530: END IF;
1531:
1532: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'

2120:
2121: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
2122:
2123: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'
2125: ,'Begin(+)');
2126: END IF;
2127:
2128: -- ------------------------

Line 3212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'

3208: END LOOP;
3209: END IF;
3210:
3211: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3212: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_cons_bill'
3213: ,'End(-)');
3214: END IF;
3215:
3216: -- -------------------------------------------

Line 3253: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',

3249: COMMIT;
3250: END IF;
3251:
3252: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3253: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
3254: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_ERROR');
3255: END IF;
3256:
3257: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',

3276: COMMIT;
3277: END IF;
3278:
3279: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3280: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
3281: 'EXCEPTION :'||'Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR');
3282: END IF;
3283:
3284: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3307: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',

3303: COMMIT;
3304: END IF;
3305:
3306: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3307: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_cons_bill',
3308: 'EXCEPTION :'||'OTHERS');
3309: END IF;
3310:
3311: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3324: END Okl_Cons_Bill;

3320: p_api_type => '_PVT');
3321:
3322: END create_cons_bill;
3323:
3324: END Okl_Cons_Bill;