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

Line 4: L_MODULE FND_LOG_MESSAGES.MODULE%TYPE;

1: PACKAGE BODY OKL_PARTY_MERGE_PUB AS
2: /* $Header: OKLPPMGB.pls 120.8.12010000.3 2008/10/21 22:47:54 apaul ship $ */
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 47: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

43: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE';
44:
45: -- check for logging on PROCEDURE level
46: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
47: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
48: -- check for logging on STATEMENT level
49: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
50:
51: -- call START_ACTIVITY to create savepoint, check compatibility

Line 49: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);

45: -- check for logging on PROCEDURE level
46: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
47: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
48: -- check for logging on STATEMENT level
49: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
50:
51: -- call START_ACTIVITY to create savepoint, check compatibility
52: -- and initialize message list
53: l_return_status := OKL_API.START_ACTIVITY(

Line 107: FND_LOG.LEVEL_PROCEDURE

103: --Call the Create Party Site API
104: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
105: THEN
106: OKL_DEBUG_PUB.LOG_DEBUG(
107: FND_LOG.LEVEL_PROCEDURE
108: ,L_MODULE
109: ,'begin debug call HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE');
110: END IF;
111:

Line 124: FND_LOG.LEVEL_PROCEDURE

120:
121: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
122: THEN
123: OKL_DEBUG_PUB.LOG_DEBUG(
124: FND_LOG.LEVEL_PROCEDURE
125: ,L_MODULE
126: ,'end debug call HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE');
127: END IF;
128:

Line 132: FND_LOG.LEVEL_STATEMENT

128:
129: -- write to log
130: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
131: OKL_DEBUG_PUB.LOG_DEBUG(
132: FND_LOG.LEVEL_STATEMENT
133: ,L_MODULE || ' Result of HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'
134: ,'Party Site Number ' || x_party_site_number ||
135: ' New Party Site Id '|| x_new_party_site_id ||
136: ' result status ' || l_return_status ||

Line 216: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

212: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.CREATE_PARTY_SITE_USE';
213:
214: -- check for logging on PROCEDURE level
215: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
216: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
217: -- check for logging on STATEMENT level
218: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
219:
220: -- call START_ACTIVITY to create savepoint, check compatibility

Line 218: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);

214: -- check for logging on PROCEDURE level
215: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
216: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
217: -- check for logging on STATEMENT level
218: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
219:
220: -- call START_ACTIVITY to create savepoint, check compatibility
221: -- and initialize message list
222: l_return_status := OKL_API.START_ACTIVITY(

Line 255: FND_LOG.LEVEL_PROCEDURE

251: --Call the API to create the site use
252: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
253: THEN
254: OKL_DEBUG_PUB.LOG_DEBUG(
255: FND_LOG.LEVEL_PROCEDURE
256: ,L_MODULE
257: ,'begin debug call HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE');
258: END IF;
259:

Line 271: FND_LOG.LEVEL_PROCEDURE

267:
268: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
269: THEN
270: OKL_DEBUG_PUB.LOG_DEBUG(
271: FND_LOG.LEVEL_PROCEDURE
272: ,L_MODULE
273: ,'end debug call HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE');
274: END IF;
275:

Line 279: FND_LOG.LEVEL_STATEMENT

275:
276: -- write to log
277: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
278: OKL_DEBUG_PUB.LOG_DEBUG(
279: FND_LOG.LEVEL_STATEMENT
280: ,L_MODULE || ' Result of HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE'
281: ,' New Party Site Use Id '|| x_new_party_site_use_id ||
282: ' result status ' || l_return_status ||
283: ' x_msg_data ' || x_msg_data);

Line 535: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

531: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.UPDATE_ASSET_LOCATION';
532:
533: -- check for logging on PROCEDURE level
534: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
535: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
536: -- check for logging on STATEMENT level
537: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
538:
539: -- call START_ACTIVITY to create savepoint, check compatibility

Line 537: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);

533: -- check for logging on PROCEDURE level
534: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
535: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
536: -- check for logging on STATEMENT level
537: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
538:
539: -- call START_ACTIVITY to create savepoint, check compatibility
540: -- and initialize message list
541: l_return_status := OKL_API.START_ACTIVITY(

Line 586: FND_LOG.LEVEL_PROCEDURE

582: --Call the Create Party Site API
583: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
584: THEN
585: OKL_DEBUG_PUB.LOG_DEBUG(
586: FND_LOG.LEVEL_PROCEDURE
587: ,L_MODULE
588: ,'begin debug call CREATE_PARTY_SITE');
589: END IF;
590:

Line 603: FND_LOG.LEVEL_PROCEDURE

599:
600: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
601: THEN
602: OKL_DEBUG_PUB.LOG_DEBUG(
603: FND_LOG.LEVEL_PROCEDURE
604: ,L_MODULE
605: ,'end debug call CREATE_PARTY_SITE');
606: END IF;
607:

Line 611: FND_LOG.LEVEL_STATEMENT

607:
608: -- write to log
609: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
610: OKL_DEBUG_PUB.LOG_DEBUG(
611: FND_LOG.LEVEL_STATEMENT
612: ,L_MODULE || ' Result of CREATE_PARTY_SITE'
613: ,' New Party Site Id '|| NEW_PS_ID_LIST(I) ||
614: ' result status ' || l_return_status ||
615: ' x_msg_data ' || x_msg_data);

Line 629: FND_LOG.LEVEL_PROCEDURE

625: --Call the API to create the site use
626: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
627: THEN
628: OKL_DEBUG_PUB.LOG_DEBUG(
629: FND_LOG.LEVEL_PROCEDURE
630: ,L_MODULE
631: ,'begin debug call CREATE_PARTY_SITE_USE');
632: END IF;
633:

Line 646: FND_LOG.LEVEL_PROCEDURE

642:
643: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
644: THEN
645: OKL_DEBUG_PUB.LOG_DEBUG(
646: FND_LOG.LEVEL_PROCEDURE
647: ,L_MODULE
648: ,'end debug call CREATE_PARTY_SITE_USE');
649: END IF;
650:

Line 654: FND_LOG.LEVEL_STATEMENT

650:
651: -- write to log
652: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
653: OKL_DEBUG_PUB.LOG_DEBUG(
654: FND_LOG.LEVEL_STATEMENT
655: ,L_MODULE || ' Result of CREATE_PARTY_SITE_USE'
656: ,' New Party Site Use Id '|| NEW_IS_ID_LIST(I) ||
657: ' result status ' || l_return_status ||
658: ' x_msg_data ' || x_msg_data);

Line 2985: ,fnd_log.level_procedure);

2981: l_count := 0;
2982: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2983: l_debug_enabled := okl_debug_pub.check_log_enabled;
2984: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module
2985: ,fnd_log.level_procedure);
2986: --Log statements for all input parameters and the procedure name
2987: fnd_file.put_line(fnd_file.log, 'OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE');
2988: fnd_file.put_line(fnd_file.log, '****** PARAMETERS ****** ');
2989: fnd_file.put_line(fnd_file.log, 'p_entity_name : '||p_entity_name);

Line 3000: okl_debug_pub.log_debug(fnd_log.level_procedure

2996:
2997: arp_message.set_line('OKL_PARTY_MERGE_PUB.CPL_PARTY_MERGE()+');
2998:
2999: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
3000: okl_debug_pub.log_debug(fnd_log.level_procedure
3001: ,l_module
3002: ,'start debug okl_vendormerge_grp.merge_vendor');
3003: END IF; -- check for logging on STATEMENT level
3004: is_debug_statement_on := okl_debug_pub.check_log_on(l_module

Line 3005: ,fnd_log.level_statement);

3001: ,l_module
3002: ,'start debug okl_vendormerge_grp.merge_vendor');
3003: END IF; -- check for logging on STATEMENT level
3004: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
3005: ,fnd_log.level_statement);
3006: -- call START_ACTIVITY to create savepoint, check compatibility
3007: -- and initialize message list
3008: l_return_status := okl_api.start_activity(p_api_name => l_api_name
3009: ,p_pkg_name => G_PKG_NAME

Line 3115: FND_LOG.LEVEL_PROCEDURE

3111:
3112: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3113: THEN
3114: OKL_DEBUG_PUB.LOG_DEBUG(
3115: FND_LOG.LEVEL_PROCEDURE
3116: ,L_MODULE
3117: ,'begin debug call OKL_KPL_PVT.DELETE_ROW');
3118: END IF;
3119:

Line 3133: FND_LOG.LEVEL_PROCEDURE

3129:
3130: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3131: THEN
3132: OKL_DEBUG_PUB.LOG_DEBUG(
3133: FND_LOG.LEVEL_PROCEDURE
3134: ,L_MODULE
3135: ,'end debug call OKL_KPL_PVT.DELETE_ROW');
3136: END IF;
3137:

Line 3141: FND_LOG.LEVEL_STATEMENT

3137:
3138: -- write to log
3139: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3140: OKL_DEBUG_PUB.LOG_DEBUG(
3141: FND_LOG.LEVEL_STATEMENT
3142: ,L_MODULE || ' Result of OKL_KPL_PVT.DELETE_ROW'
3143: ,'l_return_status ' || l_return_status);
3144: END IF; -- end of statement level debug
3145:

Line 3155: FND_LOG.LEVEL_PROCEDURE

3151:
3152: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3153: THEN
3154: OKL_DEBUG_PUB.LOG_DEBUG(
3155: FND_LOG.LEVEL_PROCEDURE
3156: ,L_MODULE
3157: ,'begin debug call OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE');
3158: END IF;
3159:

Line 3173: FND_LOG.LEVEL_PROCEDURE

3169:
3170: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3171: THEN
3172: OKL_DEBUG_PUB.LOG_DEBUG(
3173: FND_LOG.LEVEL_PROCEDURE
3174: ,L_MODULE
3175: ,'end debug call OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE');
3176: END IF;
3177:

Line 3181: FND_LOG.LEVEL_STATEMENT

3177:
3178: -- write to log
3179: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3180: OKL_DEBUG_PUB.LOG_DEBUG(
3181: FND_LOG.LEVEL_STATEMENT
3182: ,L_MODULE || ' Result of OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE'
3183: ,'l_return_status ' || l_return_status);
3184: END IF; -- end of statement level debug
3185:

Line 3203: okl_debug_pub.log_debug(fnd_log.level_procedure

3199: ,x_msg_data => p_msg_data);
3200:
3201: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on)
3202: THEN
3203: okl_debug_pub.log_debug(fnd_log.level_procedure
3204: ,l_module
3205: ,'end debug okl_vendormerge_grp.merge_vendor');
3206: END IF;
3207:

Line 3462: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

3458: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LOP_ACCOUNT_MERGE';
3459:
3460: -- check for logging on PROCEDURE level
3461: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3462: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
3463: -- check for logging on STATEMENT level
3464: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
3465:
3466: -- call START_ACTIVITY to create savepoint, check compatibility

Line 3464: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);

3460: -- check for logging on PROCEDURE level
3461: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3462: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
3463: -- check for logging on STATEMENT level
3464: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
3465:
3466: -- call START_ACTIVITY to create savepoint, check compatibility
3467: -- and initialize message list
3468: l_return_status := OKL_API.START_ACTIVITY(

Line 3532: FND_LOG.LEVEL_PROCEDURE

3528: THEN
3529: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3530: THEN
3531: OKL_DEBUG_PUB.LOG_DEBUG(
3532: FND_LOG.LEVEL_PROCEDURE
3533: ,L_MODULE
3534: ,'begin debug call CREATE_PARTY_SITE');
3535: END IF;
3536:

Line 3551: FND_LOG.LEVEL_PROCEDURE

3547:
3548: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3549: THEN
3550: OKL_DEBUG_PUB.LOG_DEBUG(
3551: FND_LOG.LEVEL_PROCEDURE
3552: ,L_MODULE
3553: ,'end debug call CREATE_PARTY_SITE');
3554: END IF;
3555:

Line 3559: FND_LOG.LEVEL_STATEMENT

3555:
3556: -- write to log
3557: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3558: OKL_DEBUG_PUB.LOG_DEBUG(
3559: FND_LOG.LEVEL_STATEMENT
3560: ,L_MODULE || ' Result of CREATE_PARTY_SITE'
3561: ,'New Party Site Id '|| PROSPECT_ADDRESS_ID_LIST(I) ||
3562: ' result status ' || l_return_status ||
3563: ' x_msg_data ' || x_msg_data);

Line 3590: FND_LOG.LEVEL_PROCEDURE

3586: THEN
3587: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3588: THEN
3589: OKL_DEBUG_PUB.LOG_DEBUG(
3590: FND_LOG.LEVEL_PROCEDURE
3591: ,L_MODULE
3592: ,'begin debug call CREATE_PARTY_SITE');
3593: END IF;
3594:

Line 3607: FND_LOG.LEVEL_PROCEDURE

3603:
3604: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3605: THEN
3606: OKL_DEBUG_PUB.LOG_DEBUG(
3607: FND_LOG.LEVEL_PROCEDURE
3608: ,L_MODULE
3609: ,'end debug call CREATE_PARTY_SITE');
3610: END IF;
3611:

Line 3615: FND_LOG.LEVEL_STATEMENT

3611:
3612: -- write to log
3613: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3614: OKL_DEBUG_PUB.LOG_DEBUG(
3615: FND_LOG.LEVEL_STATEMENT
3616: ,L_MODULE || ' Result of CREATE_PARTY_SITE'
3617: ,'New Party Site Id '|| l_new_party_site_id ||
3618: ' result status ' || l_return_status ||
3619: ' x_msg_data ' || x_msg_data);

Line 3632: FND_LOG.LEVEL_PROCEDURE

3628:
3629: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3630: THEN
3631: OKL_DEBUG_PUB.LOG_DEBUG(
3632: FND_LOG.LEVEL_PROCEDURE
3633: ,L_MODULE
3634: ,'begin debug call CREATE_PARTY_SITE_USE');
3635: END IF;
3636:

Line 3649: FND_LOG.LEVEL_PROCEDURE

3645:
3646: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3647: THEN
3648: OKL_DEBUG_PUB.LOG_DEBUG(
3649: FND_LOG.LEVEL_PROCEDURE
3650: ,L_MODULE
3651: ,'end debug call CREATE_PARTY_SITE_USE');
3652: END IF;
3653:

Line 3657: FND_LOG.LEVEL_STATEMENT

3653:
3654: -- write to log
3655: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3656: OKL_DEBUG_PUB.LOG_DEBUG(
3657: FND_LOG.LEVEL_STATEMENT
3658: ,L_MODULE || ' Result of CREATE_PARTY_SITE_USE'
3659: ,'New Party Site Use Id '|| IS_ID_LIST(I) ||
3660: ' result status ' || l_return_status ||
3661: ' x_msg_data ' || x_msg_data);

Line 3688: FND_LOG.LEVEL_PROCEDURE

3684: THEN
3685: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3686: THEN
3687: OKL_DEBUG_PUB.LOG_DEBUG(
3688: FND_LOG.LEVEL_PROCEDURE
3689: ,L_MODULE
3690: ,'begin debug call CREATE_PARTY_SITE');
3691: END IF;
3692:

Line 3705: FND_LOG.LEVEL_PROCEDURE

3701:
3702: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3703: THEN
3704: OKL_DEBUG_PUB.LOG_DEBUG(
3705: FND_LOG.LEVEL_PROCEDURE
3706: ,L_MODULE
3707: ,'end debug call CREATE_PARTY_SITE');
3708: END IF;
3709:

Line 3713: FND_LOG.LEVEL_STATEMENT

3709:
3710: -- write to log
3711: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3712: OKL_DEBUG_PUB.LOG_DEBUG(
3713: FND_LOG.LEVEL_STATEMENT
3714: ,L_MODULE || ' Result of CREATE_PARTY_SITE'
3715: ,'New Party Site Id '|| l_new_party_site_id ||
3716: ' result status ' || l_return_status ||
3717: ' x_msg_data ' || x_msg_data);

Line 3730: FND_LOG.LEVEL_PROCEDURE

3726:
3727: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3728: THEN
3729: OKL_DEBUG_PUB.LOG_DEBUG(
3730: FND_LOG.LEVEL_PROCEDURE
3731: ,L_MODULE
3732: ,'begin debug call CREATE_PARTY_SITE_USE');
3733: END IF;
3734:

Line 3747: FND_LOG.LEVEL_PROCEDURE

3743:
3744: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3745: THEN
3746: OKL_DEBUG_PUB.LOG_DEBUG(
3747: FND_LOG.LEVEL_PROCEDURE
3748: ,L_MODULE
3749: ,'end debug call CREATE_PARTY_SITE_USE');
3750: END IF;
3751:

Line 3755: FND_LOG.LEVEL_STATEMENT

3751:
3752: -- write to log
3753: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3754: OKL_DEBUG_PUB.LOG_DEBUG(
3755: FND_LOG.LEVEL_STATEMENT
3756: ,L_MODULE || ' Result of CREATE_PARTY_SITE_USE'
3757: ,'New Party Site Use Id '|| UL_ID_LIST(I) ||
3758: ' result status ' || l_return_status ||
3759: ' x_msg_data ' || x_msg_data);

Line 3775: FND_LOG.LEVEL_PROCEDURE

3771:
3772: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3773: THEN
3774: OKL_DEBUG_PUB.LOG_DEBUG(
3775: FND_LOG.LEVEL_PROCEDURE
3776: ,L_MODULE
3777: ,'begin debug call UPDATE_ASSET_LOCATION');
3778: END IF;
3779:

Line 3796: FND_LOG.LEVEL_PROCEDURE

3792:
3793: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
3794: THEN
3795: OKL_DEBUG_PUB.LOG_DEBUG(
3796: FND_LOG.LEVEL_PROCEDURE
3797: ,L_MODULE
3798: ,'end debug call UPDATE_ASSET_LOCATION');
3799: END IF;
3800:

Line 3804: FND_LOG.LEVEL_STATEMENT

3800:
3801: -- write to log
3802: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
3803: OKL_DEBUG_PUB.LOG_DEBUG(
3804: FND_LOG.LEVEL_STATEMENT
3805: ,L_MODULE || ' Result of UPDATE_ASSET_LOCATION'
3806: ,' result status ' || l_return_status ||
3807: ' x_msg_data ' || x_msg_data);
3808: END IF; -- end of statement level debug

Line 3992: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);

3988: L_MODULE := 'OKL.PLSQL.OKL_PARTY_MERGE_PUB.LAP_ACCOUNT_MERGE';
3989:
3990: -- check for logging on PROCEDURE level
3991: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3992: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
3993: -- check for logging on STATEMENT level
3994: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
3995:
3996: -- call START_ACTIVITY to create savepoint, check compatibility

Line 3994: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);

3990: -- check for logging on PROCEDURE level
3991: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');
3992: IS_DEBUG_PROCEDURE_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_PROCEDURE), FALSE);
3993: -- check for logging on STATEMENT level
3994: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
3995:
3996: -- call START_ACTIVITY to create savepoint, check compatibility
3997: -- and initialize message list
3998: l_return_status := OKL_API.START_ACTIVITY(

Line 4058: FND_LOG.LEVEL_PROCEDURE

4054: THEN
4055: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
4056: THEN
4057: OKL_DEBUG_PUB.LOG_DEBUG(
4058: FND_LOG.LEVEL_PROCEDURE
4059: ,L_MODULE
4060: ,'begin debug call CREATE_PARTY_SITE');
4061: END IF;
4062:

Line 4077: FND_LOG.LEVEL_PROCEDURE

4073:
4074: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
4075: THEN
4076: OKL_DEBUG_PUB.LOG_DEBUG(
4077: FND_LOG.LEVEL_PROCEDURE
4078: ,L_MODULE
4079: ,'end debug call CREATE_PARTY_SITE');
4080: END IF;
4081:

Line 4085: FND_LOG.LEVEL_STATEMENT

4081:
4082: -- write to log
4083: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
4084: OKL_DEBUG_PUB.LOG_DEBUG(
4085: FND_LOG.LEVEL_STATEMENT
4086: ,L_MODULE || ' Result of CREATE_PARTY_SITE'
4087: ,'New Party Site Id '|| PROSPECT_ADDRESS_ID_LIST(I) ||
4088: ' result status ' || l_return_status ||
4089: ' x_msg_data ' || x_msg_data);

Line 4105: FND_LOG.LEVEL_PROCEDURE

4101:
4102: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
4103: THEN
4104: OKL_DEBUG_PUB.LOG_DEBUG(
4105: FND_LOG.LEVEL_PROCEDURE
4106: ,L_MODULE
4107: ,'begin debug call UPDATE_ASSET_LOCATION');
4108: END IF;
4109:

Line 4126: FND_LOG.LEVEL_PROCEDURE

4122:
4123: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
4124: THEN
4125: OKL_DEBUG_PUB.LOG_DEBUG(
4126: FND_LOG.LEVEL_PROCEDURE
4127: ,L_MODULE
4128: ,'end debug call UPDATE_ASSET_LOCATION');
4129: END IF;
4130:

Line 4134: FND_LOG.LEVEL_STATEMENT

4130:
4131: -- write to log
4132: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_STATEMENT_ON) THEN
4133: OKL_DEBUG_PUB.LOG_DEBUG(
4134: FND_LOG.LEVEL_STATEMENT
4135: ,L_MODULE || ' Result of UPDATE_ASSET_LOCATION'
4136: ,' result status ' || l_return_status ||
4137: ' x_msg_data ' || x_msg_data);
4138: END IF; -- end of statement level debug