DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_PROFILE

Line 94: l_cur_mfg_org_id := TO_NUMBER(FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'));

90: pa_expenditure_org := NULL;
91:
92: -- bug 4662395 set the profile mfg_organization_id so
93: -- the call to PJM_PROJECTS_ALL_V will return data.
94: l_cur_mfg_org_id := TO_NUMBER(FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'));
95:
96: IF ( (pa_expenditure_org_id IS NOT NULL) AND
97: ( (l_cur_mfg_org_id IS NULL) OR
98: (l_cur_mfg_org_id IS NOT NULL AND l_cur_mfg_org_id <> FND_API.G_MISS_NUM)

Line 101: FND_PROFILE.put('MFG_ORGANIZATION_ID',pa_expenditure_org_id);

97: ( (l_cur_mfg_org_id IS NULL) OR
98: (l_cur_mfg_org_id IS NOT NULL AND l_cur_mfg_org_id <> FND_API.G_MISS_NUM)
99: )
100: ) THEN
101: FND_PROFILE.put('MFG_ORGANIZATION_ID',pa_expenditure_org_id);
102: END IF;
103:
104:
105: if ( source_project_id IS NOT NULL ) then

Line 820: FND_PROFILE.put('MFG_ORGANIZATION_ID',v_org_id);

816:
817: -- bug 4662395 set the profile mfg_organization_id so
818: -- the call to MTL_PROJECT_V will return data.
819:
820: FND_PROFILE.put('MFG_ORGANIZATION_ID',v_org_id);
821:
822: select project_number
823: into v_out_project
824: from mtl_project_v

Line 1023: if ( nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0) = 1 ) then

1019: -- fnd_client_info.set_org_context(to_char(l_org_id));
1020: end if;
1021:
1022: -- bugfix 4643461 added debug message
1023: if ( nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0) = 1 ) then
1024: inv_log_util.trace('set client context : '||l_org_id, 'INV_PROJECT', 9);
1025: inv_log_util.trace('g_organization_id : '||g_organization_id, 'INV_PROJECT', 9);
1026: end if;
1027:

Line 1056: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));

1052: BEGIN
1053:
1054: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1055:
1056: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));
1057:
1058: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);
1059:
1060: -- MOAC replace fnd_client_info.set_org_context

Line 1058: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);

1054: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1055:
1056: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));
1057:
1058: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);
1059:
1060: -- MOAC replace fnd_client_info.set_org_context
1061: -- with MO_GLOBAL.init
1062: MO_GLOBAL.init('INV');

Line 1250: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1246: L_CONCAT VARCHAR2(1000);
1247: L_DELIM VARCHAR2(1);
1248: L_FIRST_TIME BOOLEAN := TRUE;
1249:
1250: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1251: BEGIN
1252:
1253: OPEN CUR_SEG;
1254: LOOP

Line 1321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1317: FUNCTION GET_PROJECT_COLUMN RETURN VARCHAR2 IS
1318: X_RETURN_STATUS VARCHAR2(1);
1319: X_MSG_DATA VARCHAR2(1000);
1320: X_MSG_COUNT NUMBER;
1321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1322: BEGIN
1323: IF (l_debug = 1) THEN
1324: MYDEBUG('GET_PROJECT_COLUMN: G_DISPLAYED_SEGMENTS: '||G_DISPLAYED_SEGMENTS);
1325: END IF;

Line 1350: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1346: FUNCTION GET_TASK_COLUMN RETURN VARCHAR2 IS
1347: X_RETURN_STATUS VARCHAR2(1);
1348: X_MSG_DATA VARCHAR2(1000);
1349: X_MSG_COUNT NUMBER;
1350: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1351: BEGIN
1352: IF (l_debug = 1) THEN
1353: MYDEBUG('GET_TASK_COLUMN: G_DISPLAYED_SEGMENTS: '||G_DISPLAYED_SEGMENTS);
1354: END IF;

Line 1399: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1395: X_RETURN_STATUS VARCHAR2(1);
1396: X_MSG_DATA VARCHAR2(1000);
1397: X_MSG_COUNT NUMBER;
1398:
1399: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1400: BEGIN
1401: IF (l_debug = 1) THEN
1402: MYDEBUG('FETCH_COMBINATION: P_LOCATOR_ID: P_ORG_ID: '||P_LOCATOR_ID||' : '||P_ORG_ID);
1403: END IF;

Line 1516: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1512: * given Locator Id and Organization Id
1513: */
1514: FUNCTION GET_LOCSEGS(P_LOCATOR_ID IN NUMBER,
1515: P_ORG_ID IN NUMBER) RETURN VARCHAR2 IS
1516: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1517: BEGIN
1518:
1519: IF (l_debug = 1) THEN
1520: MYDEBUG('GET_LOCSEGS: P_LOCATOR_ID: P_ORG_ID: '||P_LOCATOR_ID||':'||P_ORG_ID);

Line 1544: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1540: * This function returns the Project Number of the Project Id passed
1541: * Does not use FND API's.
1542: */
1543: FUNCTION GET_PROJECT_NUMBER(p_project_id IN NUMBER) RETURN VARCHAR2 IS
1544: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1545: BEGIN
1546:
1547: /* The below code is commented because it uses pjm_projects_mtll_v
1548: which requrires mfg_organization_id profile value needs to be set

Line 1570: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1566: END GET_PROJECT_NUMBER;
1567:
1568: FUNCTION GET_TASK_NUMBER(P_TASK_ID IN NUMBER) RETURN VARCHAR2 IS
1569: L_TASK_NUMBER VARCHAR2(100);
1570: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1571: BEGIN
1572:
1573: /* SELECT TASK_NUMBER
1574: INTO L_TASK_NUMBER

Line 1667: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1663: L_DELIM VARCHAR2(1);
1664: L_FIRST_TIME BOOLEAN := TRUE;
1665: L_BSLASH_DELIM VARCHAR2(2); -- For Bug# 7623167
1666:
1667: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1668: BEGIN
1669:
1670:
1671: SELECT CONCATENATED_SEGMENT_DELIMITER

Line 1775: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1771: X_MSG_DATA VARCHAR2(1000);
1772: X_MSG_COUNT NUMBER;
1773: L_CONCATED_LOCATOR VARCHAR2(400);
1774:
1775: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1776: BEGIN
1777:
1778: IF (l_debug = 1) THEN
1779: MYDEBUG('GET_LOCATOR: P_LOCATOR_ID: P_ORG_ID: '||P_LOCATOR_ID||' : '||P_ORG_ID);