APPS.CLN_UPDTDLVY_PKG dependencies on FND_PROFILE

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

53:
54:
55: BEGIN
56: -- set debug level
57: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
58:
59: if (l_debug_level <= 1) then
60: cln_debug_pub.Add('ENTERING CLN_UPDTDLVY_PKG.Get_UpdateDelivery_Params', 1);
61: cln_debug_pub.Add('With the following parameters:', 1);

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

99: INTO party_id, party_site_id
100: FROM rcv_shipment_headers h
101: WHERE h.shipment_header_id = p_shipment_header_id;
102:
103: select FND_PROFILE.VALUE('ORG_ID')
104: into l_organization_id
105: from dual;
106:
107: if (l_debug_level <= 1) then

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

217: l_error_code NUMBER;
218: l_error_msg VARCHAR2(1000);
219: BEGIN
220: -- init parameters
221: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
222:
223: MsgIdExists := INSTR(ReceiptNumAndMsgId, '-', 1, 1);
224:
225: if(MsgIdExists = 0) then

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

268:
269:
270: BEGIN
271: -- initialize parameters
272: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
273:
274: x_progress := '000';
275: l_update_cln_event := 'oracle.apps.cln.ch.collaboration.add';
276: l_update_cln_parameter_list := wf_parameter_list_t();

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

438: l_error_code NUMBER;
439: l_error_msg VARCHAR2(2000);
440: BEGIN
441: -- initialize parameters
442: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
443: l_org_id := 0;
444:
445: if (l_debug_level <= 1) then
446: cln_debug_pub.Add('ENTERING GET_FROM_ROLE_ORG_ID', 1);