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_ITEM_RESIDUALS_PVT dependencies on FND_LOG

Line 273: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.get_effective_date';

269: AND ICPV.ID = p_ver_id;
270:
271: l_version_details get_version_dtls%ROWTYPE;
272:
273: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.get_effective_date';
274: l_debug_enabled VARCHAR2(10);
275: is_debug_procedure_on BOOLEAN;
276: is_debug_statement_on BOOLEAN;
277:

Line 280: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

276: is_debug_statement_on BOOLEAN;
277:
278: BEGIN
279: l_debug_enabled := okl_debug_pub.check_log_enabled;
280: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
281: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
282: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call get_effective_date');
283: END IF;
284:

Line 282: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call get_effective_date');

278: BEGIN
279: l_debug_enabled := okl_debug_pub.check_log_enabled;
280: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
281: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
282: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call get_effective_date');
283: END IF;
284:
285: l_return_status := OKL_API.start_activity(l_api_name
286: ,G_PKG_NAME

Line 362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call get_effective_date');

358: x_return_status := l_return_status;
359: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
360:
361: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
362: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call get_effective_date');
363: END IF;
364:
365: EXCEPTION
366: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 425: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_irs';

421: lx_irv_tbl okl_irv_tbl;
422: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
423: lp_irv_tbl okl_irv_tbl := p_irv_tbl;
424:
425: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_irs';
426: l_debug_enabled VARCHAR2(10);
427: is_debug_procedure_on BOOLEAN;
428: is_debug_statement_on BOOLEAN;
429: BEGIN

Line 431: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

427: is_debug_procedure_on BOOLEAN;
428: is_debug_statement_on BOOLEAN;
429: BEGIN
430: l_debug_enabled := okl_debug_pub.check_log_enabled;
431: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
432: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
433: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs');
434: END IF;
435:

Line 433: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs');

429: BEGIN
430: l_debug_enabled := okl_debug_pub.check_log_enabled;
431: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
432: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
433: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs');
434: END IF;
435:
436: l_return_status := OKL_API.start_activity(l_api_name
437: ,G_PKG_NAME

Line 515: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs');

511: x_return_status := l_return_status;
512: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
513:
514: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
515: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs');
516: END IF;
517:
518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 591: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.update_version_irs';

587: l_db_ver_end_date DATE := NULL;
588: j NUMBER := 1;
589: k NUMBER := 1;
590:
591: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.update_version_irs';
592: l_debug_enabled VARCHAR2(10);
593: is_debug_procedure_on BOOLEAN;
594: is_debug_statement_on BOOLEAN;
595:

Line 607: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

603: ICP.ID = p_version_id;
604:
605: BEGIN
606: l_debug_enabled := okl_debug_pub.check_log_enabled;
607: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
608: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
609: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs');
610: END IF;
611:

Line 609: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs');

605: BEGIN
606: l_debug_enabled := okl_debug_pub.check_log_enabled;
607: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
608: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
609: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs');
610: END IF;
611:
612: -- Initialize the OUT records
613: x_irhv_rec := p_irhv_rec;

Line 772: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs');

768: x_return_status := l_return_status;
769: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
770:
771: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
772: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs');
773: END IF;
774:
775: EXCEPTION
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 838: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_version_irs';

834: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
835: lp_irv_tbl okl_irv_tbl := p_irv_tbl;
836: l_new_version_no NUMBER := '1';
837:
838: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_version_irs';
839: l_debug_enabled VARCHAR2(10);
840: is_debug_procedure_on BOOLEAN;
841: is_debug_statement_on BOOLEAN;
842:

Line 845: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

841: is_debug_statement_on BOOLEAN;
842:
843: BEGIN
844: l_debug_enabled := okl_debug_pub.check_log_enabled;
845: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
846: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs');
848: END IF;
849:

Line 847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs');

843: BEGIN
844: l_debug_enabled := okl_debug_pub.check_log_enabled;
845: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
846: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs');
848: END IF;
849:
850: l_return_status := OKL_API.start_activity(l_api_name
851: ,G_PKG_NAME

Line 928: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs');

924:
925: x_return_status := l_return_status;
926: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
927: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
928: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs');
929: END IF;
930:
931: EXCEPTION
932: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1094: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.change_LRS_sts';

1090: OKL_ITM_CAT_RV_PRCS_V
1091: WHERE
1092: ID = p_version_id;
1093:
1094: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.change_LRS_sts';
1095: l_debug_enabled VARCHAR2(10);
1096: is_debug_procedure_on BOOLEAN;
1097: is_debug_statement_on BOOLEAN;
1098:

Line 1101: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1097: is_debug_statement_on BOOLEAN;
1098:
1099: BEGIN
1100: l_debug_enabled := okl_debug_pub.check_log_enabled;
1101: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1102: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1103: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call change_LRS_sts');
1104: END IF;
1105:

Line 1103: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call change_LRS_sts');

1099: BEGIN
1100: l_debug_enabled := okl_debug_pub.check_log_enabled;
1101: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1102: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1103: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call change_LRS_sts');
1104: END IF;
1105:
1106:
1107: l_return_status := OKL_API.start_activity(l_api_name

Line 1207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call change_LRS_sts');

1203: x_return_status := l_return_status;
1204: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1205:
1206: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1207: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call change_LRS_sts');
1208: END IF;
1209:
1210: EXCEPTION
1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1343: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.activate_item_residual';

1339: l_version_rec get_version_rec%ROWTYPE;
1340: l_version_details get_version_details%ROWTYPE;
1341:
1342:
1343: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.activate_item_residual';
1344: l_debug_enabled VARCHAR2(10);
1345: is_debug_procedure_on BOOLEAN;
1346: is_debug_statement_on BOOLEAN;
1347: BEGIN

Line 1349: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1345: is_debug_procedure_on BOOLEAN;
1346: is_debug_statement_on BOOLEAN;
1347: BEGIN
1348: l_debug_enabled := okl_debug_pub.check_log_enabled;
1349: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1350: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call activate_item_residual');
1352: END IF;
1353:

Line 1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call activate_item_residual');

1347: BEGIN
1348: l_debug_enabled := okl_debug_pub.check_log_enabled;
1349: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1350: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call activate_item_residual');
1352: END IF;
1353:
1354: l_return_status := OKL_API.start_activity(l_api_name
1355: ,G_PKG_NAME

Line 1485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls.pls call activate_item_residual');

1481: x_return_status := l_return_status;
1482: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1483:
1484: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1485: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls.pls call activate_item_residual');
1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1539: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.submit_item_residual';

1535: lx_return_status VARCHAR2(1);
1536: l_parameter_list WF_PARAMETER_LIST_T;
1537: l_event_name wf_events.name%TYPE;
1538:
1539: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.submit_item_residual';
1540: l_debug_enabled VARCHAR2(10);
1541: is_debug_procedure_on BOOLEAN;
1542: is_debug_statement_on BOOLEAN;
1543:

Line 1583: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1579: l_rcs_rec check_active_resi_cat_sets%ROWTYPE;
1580:
1581: BEGIN
1582: l_debug_enabled := okl_debug_pub.check_log_enabled;
1583: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1584: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1585: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call submit_item_residual');
1586: END IF;
1587:

Line 1585: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call submit_item_residual');

1581: BEGIN
1582: l_debug_enabled := okl_debug_pub.check_log_enabled;
1583: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1584: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1585: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call submit_item_residual');
1586: END IF;
1587:
1588: lx_return_status := OKL_API.start_activity(l_api_name
1589: ,G_PKG_NAME

Line 1660: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call submit_item_residual');

1656: x_return_status := lx_return_status;
1657: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1658:
1659: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1660: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call submit_item_residual');
1661: END IF;
1662:
1663: EXCEPTION
1664: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1722: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_irs_submit';

1718: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1719:
1720: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
1721:
1722: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_irs_submit';
1723: l_debug_enabled VARCHAR2(10);
1724: is_debug_procedure_on BOOLEAN;
1725: is_debug_statement_on BOOLEAN;
1726:

Line 1729: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1725: is_debug_statement_on BOOLEAN;
1726:
1727: BEGIN
1728: l_debug_enabled := okl_debug_pub.check_log_enabled;
1729: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1730: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1731: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs_submit');
1732: END IF;
1733:

Line 1731: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs_submit');

1727: BEGIN
1728: l_debug_enabled := okl_debug_pub.check_log_enabled;
1729: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1730: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1731: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_irs_submit');
1732: END IF;
1733:
1734: l_return_status := OKL_API.start_activity(l_api_name
1735: ,G_PKG_NAME

Line 1795: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs_submit');

1791: x_return_status := l_return_status;
1792: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1793:
1794: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1795: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_irs_submit');
1796: END IF;
1797:
1798: EXCEPTION
1799: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1857: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.update_version_irs_submit';

1853: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1854:
1855: lp_icpv_rec okl_icpv_rec := p_icpv_rec;
1856:
1857: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.update_version_irs_submit';
1858: l_debug_enabled VARCHAR2(10);
1859: is_debug_procedure_on BOOLEAN;
1860: is_debug_statement_on BOOLEAN;
1861: BEGIN

Line 1863: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

1859: is_debug_procedure_on BOOLEAN;
1860: is_debug_statement_on BOOLEAN;
1861: BEGIN
1862: l_debug_enabled := okl_debug_pub.check_log_enabled;
1863: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1864: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1865: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs_submit');
1866: END IF;
1867:

Line 1865: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs_submit');

1861: BEGIN
1862: l_debug_enabled := okl_debug_pub.check_log_enabled;
1863: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1864: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1865: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call update_version_irs_submit');
1866: END IF;
1867:
1868: l_return_status := OKL_API.start_activity(l_api_name
1869: ,G_PKG_NAME

Line 1933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs_submit');

1929:
1930: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1931:
1932: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1933: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call update_version_irs_submit');
1934: END IF;
1935:
1936: EXCEPTION
1937: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2006: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_version_irs_submit';

2002: WHERE
2003: ITEM_RESIDUAL_ID = p_item_residual_id
2004: AND TO_NUMBER(VERSION_NUMBER) = p_ver_no - 1;
2005:
2006: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.create_version_irs_submit';
2007: l_debug_enabled VARCHAR2(10);
2008: is_debug_procedure_on BOOLEAN;
2009: is_debug_statement_on BOOLEAN;
2010:

Line 2013: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

2009: is_debug_statement_on BOOLEAN;
2010:
2011: BEGIN
2012: l_debug_enabled := okl_debug_pub.check_log_enabled;
2013: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2014: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2015: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs_submit');
2016: END IF;
2017:

Line 2015: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs_submit');

2011: BEGIN
2012: l_debug_enabled := okl_debug_pub.check_log_enabled;
2013: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2014: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2015: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call create_version_irs_submit');
2016: END IF;
2017:
2018: l_return_status := OKL_API.start_activity(l_api_name
2019: ,G_PKG_NAME

Line 2120: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs_submit');

2116:
2117: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2118:
2119: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2120: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call create_version_irs_submit');
2121: END IF;
2122: EXCEPTION
2123: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2124:

Line 2172: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.remove_terms';

2168: l_api_version NUMBER := p_api_version;
2169: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
2170: l_return_status VARCHAR2(1) := x_return_status;
2171:
2172: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_ITEM_RESIDUALS_PVT.remove_terms';
2173: l_debug_enabled VARCHAR2(10);
2174: is_debug_procedure_on BOOLEAN;
2175: is_debug_statement_on BOOLEAN;
2176:

Line 2179: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

2175: is_debug_statement_on BOOLEAN;
2176:
2177: BEGIN
2178: l_debug_enabled := okl_debug_pub.check_log_enabled;
2179: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2180: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2181: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call remove_terms');
2182: END IF;
2183:

Line 2181: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call remove_terms');

2177: BEGIN
2178: l_debug_enabled := okl_debug_pub.check_log_enabled;
2179: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
2180: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2181: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRIRSB.pls call remove_terms');
2182: END IF;
2183:
2184: l_return_status := OKL_API.start_activity(l_api_name
2185: ,G_PKG_NAME

Line 2210: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call remove_terms');

2206:
2207: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2208:
2209: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2210: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRIRSB.pls call remove_terms');
2211: END IF;
2212:
2213: EXCEPTION
2214: WHEN OKL_API.G_EXCEPTION_ERROR THEN