APPS.CSM_SETUP_PROFILE dependencies on FND_PROFILE

Line 130: jtmProfileValue := fnd_profile.VALUE_SPECIFIC(

126: profileTable(11).profileUserName := 'Server Timezone' ;
127: profileTable(12).profileName := 'CLIENT_TIMEZONE_ID' ;
128: profileTable(12).profileUserName := 'Client Timezone' ;
129:
130: jtmProfileValue := fnd_profile.VALUE_SPECIFIC(
131: 'JTM_MOB_APPS_ENABLED', null, null, 874); -- JTM
132:
133: BEGIN
134: select responsibility_id

Line 144: csmProfileValue := fnd_profile.VALUE_SPECIFIC(

140: exception
141: WHEN NO_DATA_FOUND THEN
142: null ;
143: END ;
144: csmProfileValue := fnd_profile.VALUE_SPECIFIC(
145: 'JTM_MOB_APPS_ENABLED', null, respId, 883); --Field Service Palm resp
146:
147: IF (jtmProfileValue = 'Y') and (csmProfileValue = 'Y') then
148: reportStr := 'Profile option values set Yes for profile JTM: Mobile Applications Enabled' ;

Line 159: fnd_profile.get(profileTable(i).profileName,profileValue) ;

155: isFatal := 'FALSE';
156: END IF;
157: FOR i IN 1..profileTable.COUNT LOOP
158: profileValue := null ;
159: fnd_profile.get(profileTable(i).profileName,profileValue) ;
160: IF profileValue IS NOT NULL then
161: if reportStr is null then
162: reportStr := 'Profile option value set for profile ' || profileTable(i).profileUserName || ' as '|| profileValue ;
163: else

Line 186: fnd_profile.get(itemCatProfName,itemCatProf) ;

182: isFatal := 'FALSE';
183: END IF;
184: END LOOP ;
185: -- Check for Item Category and Item Category Set
186: fnd_profile.get(itemCatProfName,itemCatProf) ;
187: fnd_profile.get(itemCatSetProfName,itemCatSetProf) ;
188: IF (itemCatProf IS NULL AND itemCatSetProf IS NULL) then
189: reportStr := ' Profile option value not set for profile ' || itemCatProfUser || ' and '|| itemCatSetProfUser || '.' ;
190: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

Line 187: fnd_profile.get(itemCatSetProfName,itemCatSetProf) ;

183: END IF;
184: END LOOP ;
185: -- Check for Item Category and Item Category Set
186: fnd_profile.get(itemCatProfName,itemCatProf) ;
187: fnd_profile.get(itemCatSetProfName,itemCatSetProf) ;
188: IF (itemCatProf IS NULL AND itemCatSetProf IS NULL) then
189: reportStr := ' Profile option value not set for profile ' || itemCatProfUser || ' and '|| itemCatSetProfUser || '.' ;
190: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
191: if statusStr is null or statusStr = 'SUCCESS' then