APPS.OKL_VENDORMERGE_GRP dependencies on FND_LOG

Line 4: L_MODULE FND_LOG_MESSAGES.MODULE%TYPE;

1: PACKAGE BODY OKL_VENDORMERGE_GRP AS
2: /* $Header: OKLRVMAB.pls 120.5 2007/09/10 15:34:35 pagarg noship $ */
3:
4: L_MODULE FND_LOG_MESSAGES.MODULE%TYPE;
5: L_DEBUG_ENABLED VARCHAR2(10);
6: IS_DEBUG_PROCEDURE_ON BOOLEAN;
7: IS_DEBUG_STATEMENT_ON BOOLEAN;
8: ------------------------------------------------------------------------------

Line 199: ,fnd_log.level_procedure);

195: l_last_update_date := TRUNC(SYSDATE);
196: l_last_update_login := FND_GLOBAL.LOGIN_ID;
197:
198: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
199: ,fnd_log.level_procedure);
200:
201: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
202: okl_debug_pub.log_debug(fnd_log.level_procedure
203: ,l_module

Line 202: okl_debug_pub.log_debug(fnd_log.level_procedure

198: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
199: ,fnd_log.level_procedure);
200:
201: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
202: okl_debug_pub.log_debug(fnd_log.level_procedure
203: ,l_module
204: ,'start debug okl_vendormerge_grp.merge_vendor');
205: END IF; -- check for logging on STATEMENT level
206: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 207: ,fnd_log.level_statement);

203: ,l_module
204: ,'start debug okl_vendormerge_grp.merge_vendor');
205: END IF; -- check for logging on STATEMENT level
206: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
207: ,fnd_log.level_statement);
208: -- call START_ACTIVITY to create savepoint, check compatibility
209: -- and initialize message list
210: l_return_status := okl_api.start_activity(p_api_name => l_api_name
211: ,p_pkg_name => G_PKG_NAME

Line 542: FND_LOG.LEVEL_PROCEDURE

538:
539: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
540: THEN
541: OKL_DEBUG_PUB.LOG_DEBUG(
542: FND_LOG.LEVEL_PROCEDURE
543: ,L_MODULE
544: ,'begin debug call OKL_KPL_PVT.DELETE_ROW');
545: END IF;
546:

Line 560: FND_LOG.LEVEL_PROCEDURE

556:
557: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
558: THEN
559: OKL_DEBUG_PUB.LOG_DEBUG(
560: FND_LOG.LEVEL_PROCEDURE
561: ,L_MODULE
562: ,'end debug call OKL_KPL_PVT.DELETE_ROW');
563: END IF;
564:

Line 568: FND_LOG.LEVEL_STATEMENT

564:
565: -- write to log
566: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
567: OKL_DEBUG_PUB.LOG_DEBUG(
568: FND_LOG.LEVEL_STATEMENT
569: ,L_MODULE || ' Result of OKL_KPL_PVT.DELETE_ROW'
570: ,'l_return_status ' || l_return_status);
571: END IF; -- end of statement level debug
572:

Line 582: FND_LOG.LEVEL_PROCEDURE

578:
579: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
580: THEN
581: OKL_DEBUG_PUB.LOG_DEBUG(
582: FND_LOG.LEVEL_PROCEDURE
583: ,L_MODULE
584: ,'begin debug call OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE');
585: END IF;
586:

Line 600: FND_LOG.LEVEL_PROCEDURE

596:
597: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
598: THEN
599: OKL_DEBUG_PUB.LOG_DEBUG(
600: FND_LOG.LEVEL_PROCEDURE
601: ,L_MODULE
602: ,'end debug call OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE');
603: END IF;
604:

Line 608: FND_LOG.LEVEL_STATEMENT

604:
605: -- write to log
606: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
607: OKL_DEBUG_PUB.LOG_DEBUG(
608: FND_LOG.LEVEL_STATEMENT
609: ,L_MODULE || ' Result of OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE'
610: ,'l_return_status ' || l_return_status);
611: END IF; -- end of statement level debug
612:

Line 678: FND_LOG.LEVEL_PROCEDURE

674: --contract level then remove the party role for source vendor
675: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
676: THEN
677: OKL_DEBUG_PUB.LOG_DEBUG(
678: FND_LOG.LEVEL_PROCEDURE
679: ,L_MODULE
680: ,'begin debug call OKL_JTOT_CONTACT_EXTRACT_PUB.DELETE_PARTY');
681: END IF;
682:

Line 696: FND_LOG.LEVEL_PROCEDURE

692:
693: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
694: THEN
695: OKL_DEBUG_PUB.LOG_DEBUG(
696: FND_LOG.LEVEL_PROCEDURE
697: ,L_MODULE
698: ,'end debug call OKL_JTOT_CONTACT_EXTRACT_PUB.DELETE_PARTY');
699: END IF;
700:

Line 704: FND_LOG.LEVEL_STATEMENT

700:
701: -- write to log
702: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
703: OKL_DEBUG_PUB.LOG_DEBUG(
704: FND_LOG.LEVEL_STATEMENT
705: ,L_MODULE || ' Result of OKL_JTOT_CONTACT_EXTRACT_PUB.DELETE_PARTY'
706: ,'l_return_status ' || l_return_status);
707: END IF; -- end of statement level debug
708:

Line 775: okl_debug_pub.log_debug(fnd_log.level_procedure

771: ,x_msg_data => p_msg_data);
772:
773: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on)
774: THEN
775: okl_debug_pub.log_debug(fnd_log.level_procedure
776: ,l_module
777: ,'end debug okl_vendormerge_grp.merge_vendor');
778: END IF;
779: EXCEPTION