DBA Data[Home] [Help]

APPS.INV_PROJECT dependencies on FND_PROFILE

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

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

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

92: ( (l_cur_mfg_org_id IS NULL) OR
93: (l_cur_mfg_org_id IS NOT NULL AND l_cur_mfg_org_id <> FND_API.G_MISS_NUM)
94: )
95: ) THEN
96: FND_PROFILE.put('MFG_ORGANIZATION_ID',pa_expenditure_org_id);
97: END IF;
98:
99:
100: if ( source_project_id IS NOT NULL ) then

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

811:
812: -- bug 4662395 set the profile mfg_organization_id so
813: -- the call to MTL_PROJECT_V will return data.
814:
815: FND_PROFILE.put('MFG_ORGANIZATION_ID',v_org_id);
816:
817: select project_number
818: into v_out_project
819: from mtl_project_v

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

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

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

1047: BEGIN
1048:
1049: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1050:
1051: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));
1052:
1053: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);
1054:
1055: -- MOAC replace fnd_client_info.set_org_context

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

1049: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1050:
1051: FND_PROFILE.PUT('MFG_ORGANIZATION_ID', TO_CHAR(P_ORGANIZATION_ID));
1052:
1053: FND_PROFILE.GET('ORG_ID', L_OPERATING_UNIT);
1054:
1055: -- MOAC replace fnd_client_info.set_org_context
1056: -- with MO_GLOBAL.init
1057: MO_GLOBAL.init('INV');

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

1241: L_CONCAT VARCHAR2(1000);
1242: L_DELIM VARCHAR2(1);
1243: L_FIRST_TIME BOOLEAN := TRUE;
1244:
1245: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1246: BEGIN
1247:
1248: OPEN CUR_SEG;
1249: LOOP

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

1312: FUNCTION GET_PROJECT_COLUMN RETURN VARCHAR2 IS
1313: X_RETURN_STATUS VARCHAR2(1);
1314: X_MSG_DATA VARCHAR2(1000);
1315: X_MSG_COUNT NUMBER;
1316: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1317: BEGIN
1318: IF (l_debug = 1) THEN
1319: MYDEBUG('GET_PROJECT_COLUMN: G_DISPLAYED_SEGMENTS: '||G_DISPLAYED_SEGMENTS);
1320: END IF;

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

1341: FUNCTION GET_TASK_COLUMN RETURN VARCHAR2 IS
1342: X_RETURN_STATUS VARCHAR2(1);
1343: X_MSG_DATA VARCHAR2(1000);
1344: X_MSG_COUNT NUMBER;
1345: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1346: BEGIN
1347: IF (l_debug = 1) THEN
1348: MYDEBUG('GET_TASK_COLUMN: G_DISPLAYED_SEGMENTS: '||G_DISPLAYED_SEGMENTS);
1349: END IF;

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

1390: X_RETURN_STATUS VARCHAR2(1);
1391: X_MSG_DATA VARCHAR2(1000);
1392: X_MSG_COUNT NUMBER;
1393:
1394: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1395: BEGIN
1396: IF (l_debug = 1) THEN
1397: MYDEBUG('FETCH_COMBINATION: P_LOCATOR_ID: P_ORG_ID: '||P_LOCATOR_ID||' : '||P_ORG_ID);
1398: END IF;

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

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

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

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

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

1561: END GET_PROJECT_NUMBER;
1562:
1563: FUNCTION GET_TASK_NUMBER(P_TASK_ID IN NUMBER) RETURN VARCHAR2 IS
1564: L_TASK_NUMBER VARCHAR2(100);
1565: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1566: BEGIN
1567:
1568: /* SELECT TASK_NUMBER
1569: INTO L_TASK_NUMBER

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

1656: L_VALIDATION_TYPE VARCHAR2(1);
1657: L_CONCAT VARCHAR2(1000);
1658: L_DELIM VARCHAR2(1);
1659: L_FIRST_TIME BOOLEAN := TRUE;
1660: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1661: BEGIN
1662:
1663:
1664: SELECT CONCATENATED_SEGMENT_DELIMITER

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

1749: X_MSG_DATA VARCHAR2(1000);
1750: X_MSG_COUNT NUMBER;
1751: L_CONCATED_LOCATOR VARCHAR2(400);
1752:
1753: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1754: BEGIN
1755:
1756: IF (l_debug = 1) THEN
1757: MYDEBUG('GET_LOCATOR: P_LOCATOR_ID: P_ORG_ID: '||P_LOCATOR_ID||' : '||P_ORG_ID);