APPS.CLN_SYNCITEM_PKG dependencies on FND_PROFILE

Line 3: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

1: PACKAGE BODY CLN_SYNCITEM_PKG AS
2: /* $Header: CLNSYITB.pls 120.4 2006/11/02 10:56:05 slattupa noship $ */
3: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
4: g_party_id VARCHAR2(40);
5:
6: -- Package
7: -- CLN_SYNCITEM_PKG

Line 300: l_profile_value := fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY');

296: cln_debug_pub.Add('Checking for the users choice ....',1);
297: END IF;
298:
299:
300: l_profile_value := fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY');
301:
302: IF (l_Debug_Level <= 1) THEN
303: cln_debug_pub.Add('profile value for - CLN_ITEM_SEND_CUST_XREF_ONLY -'||l_profile_value,1);
304: END IF;

Line 340: ( ( NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'),'N') = 'Y' AND mci.customer_item_number IS NOT NULL ) OR

336: ARL.ENABLED_FLAG(+) = 'Y' AND
337: ARL.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY' AND
338: TRUNC(SYSDATE) BETWEEN NVL(TRUNC((ARL.START_DATE_ACTIVE(+))),SYSDATE) AND
339: NVL(TRUNC((ARL.END_DATE_ACTIVE(+))), SYSDATE) AND
340: ( ( NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'),'N') = 'Y' AND mci.customer_item_number IS NOT NULL ) OR
341: NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'), 'N') ='N' ) AND
342: ( p_category_set_id IS NULL OR p_category_set_id IN
343: ( SELECT mcsvc.category_set_id
344: FROM mtl_item_categories mic,

Line 341: NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'), 'N') ='N' ) AND

337: ARL.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY' AND
338: TRUNC(SYSDATE) BETWEEN NVL(TRUNC((ARL.START_DATE_ACTIVE(+))),SYSDATE) AND
339: NVL(TRUNC((ARL.END_DATE_ACTIVE(+))), SYSDATE) AND
340: ( ( NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'),'N') = 'Y' AND mci.customer_item_number IS NOT NULL ) OR
341: NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'), 'N') ='N' ) AND
342: ( p_category_set_id IS NULL OR p_category_set_id IN
343: ( SELECT mcsvc.category_set_id
344: FROM mtl_item_categories mic,
345: mtl_category_set_valid_cats mcsvc

Line 712: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

708: and eep.transaction_id = et.transaction_id and et.transaction_type = 'CLN'
709: and et.transaction_subtype = 'SYNCITEMDELO' and eep.direction = 'OUT';
710:
711: BEGIN
712: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
713:
714: x_progress := '000';
715: transaction_type := 'CLN';
716: transaction_subtype := 'SYNCITEMDELO';

Line 732: select FND_PROFILE.VALUE('ORG_ID')

728: cln_debug_pub.Add('Failure point ' || x_progress, 1);
729: end if;
730:
731: -- get organization ID
732: select FND_PROFILE.VALUE('ORG_ID')
733: into l_organization_id
734: from dual;
735:
736: -- Retrieve Activity Attributes

Line 1010: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

1006: BEGIN
1007:
1008:
1009: resultout := 'COMPLETE:T';
1010: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
1011: x_progress := 'CLN_SYNCITEM_PKG.Archive_Deleted_Items : Entered Procedure';
1012: if (l_debug_level <= 1) then
1013: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1014: end if;

Line 1079: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

1075:
1076: BEGIN
1077: /* Commented the code for deletion for fixing bug 3875383*/
1078: /******
1079: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
1080: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : Entered Procedure';
1081: if (l_debug_level <= 1) then
1082: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1083: end if;