eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_WF_PKG dependencies on FND_PROFILE

Line 10: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');

6: -- Globals
7: -- -------------------------------------------------------------------------------------
8:
9: -- To check on, whether to print debug messages in log file or not
10: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');
11:
12: G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
13:
14: -- Bug 5162777 : The l_budget_versions_csr is moved out of the procedure Baseline_Budget.

Line 1713: l_user_profile_value1 := fnd_profile.value_specific(

1709: -- 3. Summarize the Project Budget.
1710:
1711:
1712: -- Bug 2386041
1713: l_user_profile_value1 := fnd_profile.value_specific(
1714: NAME => 'PA_SUPER_PROJECT',
1715: USER_ID => fnd_global.user_id,
1716: RESPONSIBILITY_ID => fnd_global.resp_id,
1717: APPLICATION_ID => fnd_global.resp_appl_id);

Line 1725: FROM fnd_profile_options p,

1721: BEGIN
1722:
1723: SELECT profile_option_value
1724: INTO l_user_profile_value1
1725: FROM fnd_profile_options p,
1726: fnd_profile_option_values v
1727: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
1728: AND v.profile_option_id = p.profile_option_id
1729: AND v.level_id = 10004

Line 1726: fnd_profile_option_values v

1722:
1723: SELECT profile_option_value
1724: INTO l_user_profile_value1
1725: FROM fnd_profile_options p,
1726: fnd_profile_option_values v
1727: WHERE p.profile_option_name = 'PA_SUPER_PROJECT'
1728: AND v.profile_option_id = p.profile_option_id
1729: AND v.level_id = 10004
1730: AND v.level_value = fnd_global.user_id;

Line 1742: l_set_profile_success1 := fnd_profile.save(

1738: l_user_profile_value1 := null;
1739:
1740: END;
1741:
1742: l_set_profile_success1 := fnd_profile.save(
1743: X_NAME => 'PA_SUPER_PROJECT',
1744: X_VALUE => 'Y',
1745: X_LEVEL_NAME => 'USER',
1746: X_LEVEL_VALUE => fnd_global.user_id);

Line 1749: l_user_profile_value2 := fnd_profile.value_specific(

1745: X_LEVEL_NAME => 'USER',
1746: X_LEVEL_VALUE => fnd_global.user_id);
1747: end if;
1748:
1749: l_user_profile_value2 := fnd_profile.value_specific(
1750: NAME => 'PA_SUPER_PROJECT_VIEW',
1751: USER_ID => fnd_global.user_id,
1752: RESPONSIBILITY_ID => fnd_global.resp_id,
1753: APPLICATION_ID => fnd_global.resp_appl_id);

Line 1762: FROM fnd_profile_options p,

1758: BEGIN
1759:
1760: SELECT profile_option_value
1761: INTO l_user_profile_value2
1762: FROM fnd_profile_options p,
1763: fnd_profile_option_values v
1764: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
1765: AND v.profile_option_id = p.profile_option_id
1766: AND v.level_id = 10004

Line 1763: fnd_profile_option_values v

1759:
1760: SELECT profile_option_value
1761: INTO l_user_profile_value2
1762: FROM fnd_profile_options p,
1763: fnd_profile_option_values v
1764: WHERE p.profile_option_name = 'PA_SUPER_PROJECT_VIEW'
1765: AND v.profile_option_id = p.profile_option_id
1766: AND v.level_id = 10004
1767: AND v.level_value = fnd_global.user_id;

Line 1779: l_set_profile_success2 := fnd_profile.save(

1775: l_user_profile_value2 := null;
1776:
1777: END;
1778:
1779: l_set_profile_success2 := fnd_profile.save(
1780: X_NAME => 'PA_SUPER_PROJECT_VIEW',
1781: X_VALUE => 'Y',
1782: X_LEVEL_NAME => 'USER',
1783: X_LEVEL_VALUE => fnd_global.user_id);

Line 1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);

1795:
1796: -- Bug 2386041
1797:
1798: if (l_set_profile_success1 = TRUE) then
1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
1800: end if;
1801:
1802: if (l_set_profile_success2 = TRUE) then
1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);

Line 1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);

1799: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);
1800: end if;
1801:
1802: if (l_set_profile_success2 = TRUE) then
1803: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
1804: end if;
1805: -- Bug 2386041
1806:
1807: if l_return_status <> 'S'

Line 2292: FND_PROFILE.GET('GMS_NOTIFICATION_OFFSET_DAYS',l_offset_days);

2288: -- Start of code added for Bug 1868293
2289: l_offset_days := p_offset_days;
2290:
2291: If l_offset_days IS NULL Then
2292: FND_PROFILE.GET('GMS_NOTIFICATION_OFFSET_DAYS',l_offset_days);
2293:
2294: If l_offset_days IS NULL Then
2295: IF L_DEBUG = 'Y' THEN
2296: gms_error_pkg.gms_debug('Profile GMS_NOTIFICATION_OFFSET_DAYS is undefined', 'C');

Line 2956: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),

2952: l_user_id := to_number(null);
2953: end;
2954: if (display_type=wf_notification.doc_html) then
2955: l_Installment_End_date_text := to_char(l_Installment_End_date,
2956: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2957: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2958: else
2959: l_Installment_End_date_text := to_char(l_Installment_End_date,
2960: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),

Line 2957: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /Added for bug:8974271/

2953: end;
2954: if (display_type=wf_notification.doc_html) then
2955: l_Installment_End_date_text := to_char(l_Installment_End_date,
2956: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2957: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2958: else
2959: l_Installment_End_date_text := to_char(l_Installment_End_date,
2960: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2961: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/

Line 2960: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),

2956: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2957: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2958: else
2959: l_Installment_End_date_text := to_char(l_Installment_End_date,
2960: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2961: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2962: end if;
2963: else
2964: l_Installment_End_date_text := to_char(l_Installment_End_date);

Line 2961: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /Added for bug:8974271/

2957: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2958: else
2959: l_Installment_End_date_text := to_char(l_Installment_End_date,
2960: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',l_user_id),
2961: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || ''''); /*Added for bug:8974271*/
2962: end if;
2963: else
2964: l_Installment_End_date_text := to_char(l_Installment_End_date);
2965: end if;

Line 3310: FND_PROFILE.GET('GMS_NOTIFICATION_OFFSET_DAYS', l_offset_days);

3306: -- If the value of the parameter passed from the concurrent request is null then pick up the value
3307: -- set at profile option
3308:
3309: IF l_offset_days IS NULL THEN
3310: FND_PROFILE.GET('GMS_NOTIFICATION_OFFSET_DAYS', l_offset_days);
3311: END IF;
3312: IF (l_offset_days >= 0) THEN
3313:
3314: -- After a valid offset days is supplied .Open the cursor which returns all the Installments that are going to be ended by offset