APPS.IGS_PS_USEC_SCHEDULE dependencies on FND_PROFILE

Line 1633: IF (NVL(FND_PROFILE.VALUE('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN

1629: -- Check for the scheduling software is installed or not
1630: -- Profile name (IGS: Indicates whether Scheduling Software is installed.)
1631: -- Give a message to user if the software is not installed and
1632: -- stop the further processing
1633: IF (NVL(FND_PROFILE.VALUE('IGS_PS_SCH_SOFT_NOT_INSTLD'),'N')) = 'N' THEN
1634: FND_MESSAGE.SET_NAME('IGS','IGS_PS_SCH_SOFT_NOT_INSTLD');
1635: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1636: retcode := 2;
1637: RETURN;

Line 2148: IF FND_PROFILE.VALUE('IGS_WF_ENABLE') = 'Y' THEN

2144: --
2145: DECLARE
2146: l_message VARCHAR2(30);
2147: BEGIN
2148: IF FND_PROFILE.VALUE('IGS_WF_ENABLE') = 'Y' THEN
2149: --
2150: -- raise business event only when workflow is installed
2151: --
2152: igs_ps_wf_event_pkg.wf_create_event(p_uoo_id => p_uoo_id,

Line 2367: l_fndvalue := LTRIM(RTRIM(FND_PROFILE.VALUE('UTL_FILE_OUT')));

2363: WHERE NAME='utl_file_dir';
2364:
2365: BEGIN
2366: p_isthere := 'N';
2367: l_fndvalue := LTRIM(RTRIM(FND_PROFILE.VALUE('UTL_FILE_OUT')));
2368: OPEN c_value ;
2369: FETCH c_value INTO l_dbvalue ;
2370: IF c_value%FOUND AND l_dbvalue IS NOT NULL THEN
2371: l_dbvalue:= LTRIM(RTRIM(l_dbvalue));

Line 2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');

2398: END prof_value_pres_pvt;
2399:
2400: BEGIN
2401: --adding the following code to overcome file.sql.35 warning.
2402: l_path_var := FND_PROFILE.VALUE('UTL_FILE_OUT');
2403: l_prof_val_pres := 'N'; -- to check profile value is present in utl_file_dir of v$parameter
2404:
2405: -- set the multi org id
2406: igs_ge_gen_003.set_org_id (p_org_id);