DBA Data[Home] [Help]

APPS.MSC_WF_ALLOC_ATP dependencies on FND_PROFILE

Line 4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

1: PACKAGE BODY MSC_WF_ALLOC_ATP AS -- package body
2: /* $Header: MSCWFATB.pls 120.4 2008/05/26 10:25:07 arrsubra ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
5:
6: -- ================= Procedures ====================
7:
8: --ATP Debug Workflow

Line 16: PG_DEBUG_SRC varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

12: p_session_loc_des IN VARCHAR2,
13: p_trace_loc_des IN VARCHAR2,
14: p_spid_des IN NUMBER
15: ) IS
16: PG_DEBUG_SRC varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
17: DEBUG_LOC_SRC varchar2(100);
18: SPID_SRC NUMBER;
19: l_process VARCHAR2(30) := 'ATP_DEBUG_NOTIFY';
20: l_itemtype VARCHAR2(30) := 'MSCDBG';

Line 224: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');

220: AND pl.planner_code = sys.planner_code;
221: BEGIN
222: -- Check if the profile has been set for workflow to be installed
223: -- and activated.
224: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');
225: IF PG_DEBUG in ('Y', 'C') THEN
226: msc_sch_wb.atp_debug('start_mscalloc_wf: ' || 'WF Profile:' || l_profile);
227: END IF;
228:

Line 550: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');

546: AND pl.planner_code = sys.planner_code;
547: BEGIN
548: -- Check if the profile has been set for workflow to be installed
549: -- and activated.
550: l_profile := fnd_profile.value('MSC_ALLOCATED_ATP_WORKFLOW');
551: IF PG_DEBUG in ('Y', 'C') THEN
552: msc_sch_wb.atp_debug('start_mscatp_wf: ' || 'WF Profile:' || l_profile);
553: END IF;
554: