APPS.PA_UTILS2 dependencies on FND_PROFILE

Line 581: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/

577: );
578: l_stage := 25;
579: END IF ;
580:
581: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/
582: THEN
583: l_stage := 30;
584: /*
585: * If the profile option is set,

Line 857: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468 */

853: -- so, check the provider_cache and return pa_date accordingly.
854:
855: IF ( p_ei_date BETWEEN g_prvdr_pa_start_date AND g_prvdr_pa_end_date )
856: THEN
857: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468 */
858: THEN
859: return ( p_ei_date ) ;
860: ELSE
861: return ( g_prvdr_pa_end_date ) ;

Line 864: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/

860: ELSE
861: return ( g_prvdr_pa_end_date ) ;
862: END IF; -- profile
863: ELSE
864: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/
865: THEN
866: IF ( p_ei_date <= g_p_earliest_pa_start_date )
867: THEN
868: g_prvdr_pa_start_date := g_p_earliest_pa_start_date;

Line 907: g_profile_value := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'); /*For Bug 5391468*/

903: RETURN DATE IS
904: l_return_date DATE;
905: BEGIN
906: IF g_profile_cache_first_time = 'Y' THEN
907: g_profile_value := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'); /*For Bug 5391468*/
908: g_profile_cache_first_time :='N' ;
909: END IF;
910:
911: SELECT decode(nvl(g_profile_value,'N'),

Line 924: g_profile_value := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION');/*For Bug 5391468*/

920: RETURN VARCHAR2 IS
921: l_return_name varchar2(25);
922: BEGIN
923: IF g_profile_cache_first_time = 'Y' THEN
924: g_profile_value := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION');/*For Bug 5391468*/
925: g_profile_cache_first_time :='N' ;
926: END IF;
927:
928: SELECT decode(nvl(g_profile_value,'N'),

Line 992: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /* For Bug 5391468 */

988:
989: IF ( p_ei_date BETWEEN g_recvr_pa_start_date AND g_recvr_pa_end_date )
990: THEN
991: l_stage := 400;
992: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /* For Bug 5391468 */
993: THEN
994: l_stage := 500;
995: return ( p_ei_date ) ;
996: ELSE

Line 1002: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468 */

998: return ( g_recvr_pa_end_date ) ;
999: END IF ; -- profile
1000: ELSE
1001: l_stage := 700;
1002: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468 */
1003: THEN
1004: l_stage := 800;
1005: IF ( p_ei_date <= g_r_earliest_pa_start_date )
1006: THEN

Line 1045: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/

1041: g_recvr_pa_start_date := g_prvdr_pa_start_date ;
1042: g_recvr_pa_end_date := g_prvdr_pa_end_date ;
1043: g_recvr_pa_period_name := g_prvdr_pa_period_name ;
1044:
1045: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/
1046: THEN
1047: l_stage := 1300;
1048: return ( p_ei_date ) ;
1049: ELSE

Line 1055: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/

1051: return ( g_recvr_pa_end_date ) ;
1052: END IF ; -- profile
1053: ELSE
1054: l_stage := 1500;
1055: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'Y' ) /*For Bug 5391468*/
1056: THEN
1057: l_stage := 1600;
1058: IF (p_ei_date <= g_p_earliest_pa_start_date )
1059: THEN

Line 1802: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'N' ) /*For Bug 5391468*/

1798: g_r_earliest_gl_period_name := l_earliest_period_name ;
1799: END IF;
1800: END IF ;
1801:
1802: IF ( fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') = 'N' ) /*For Bug 5391468*/
1803: THEN
1804: /*
1805: * The profile option is NOT set,(Gldate is based on the pa_date)
1806: * -- the gl date should equal the end date (if the pa date falls in a open

Line 1966: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/

1962: return date
1963: IS
1964: l_prof_new_gldate_derivation varchar2(1);
1965: BEGIN
1966: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/
1967:
1968: /*
1969: * Validate the input parameters.
1970: * If the essential input parameters have NULL values, set the global variables

Line 2055: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/

2051: return date
2052: IS
2053: l_prof_new_gldate_derivation VARCHAR2(1) := 'N';
2054: BEGIN
2055: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/
2056:
2057: /*
2058: * Validate the input parameters.
2059: * If the essential input parameters have NULL values,

Line 2350: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/

2346: IS
2347: l_prof_new_gldate_derivation VARCHAR2(1) := 'N';
2348: BEGIN
2349:
2350: l_prof_new_gldate_derivation := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ; /*For Bug 5391468*/
2351:
2352: IF ( p_set_of_books_id = g_prvdr_set_of_books_id )
2353: THEN
2354: -- if sob is not the same, we HAVE to hit the DB.

Line 2495: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

2491: l_use_same_pa_gl_period_recvr VARCHAR2(1) := 'N' ;
2492: BEGIN
2493:
2494: x_return_status := -1 ;
2495: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2496: l_debug_mode := NVL(l_debug_mode, 'N');
2497: l_stage := 100;
2498: IF (l_debug_mode = 'Y') THEN
2499: pa_debug.init_err_stack('pa_utils2.get_period_information');

Line 2506: l_prof_new_gldate_derivation := nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') ; /*For Bug 5391468*/

2502: pa_debug.write_file(pa_debug.g_err_stage);
2503: END IF;
2504:
2505: if g_prof_new_gldate_derivation IS NULL then
2506: l_prof_new_gldate_derivation := nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') ; /*For Bug 5391468*/
2507: g_prof_new_gldate_derivation := l_prof_new_gldate_derivation;
2508: else
2509: l_prof_new_gldate_derivation := g_prof_new_gldate_derivation;
2510: end if;

Line 3016: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3012: l_calling_module VARCHAR2(30) := NULL ;
3013: BEGIN
3014: pa_debug.init_err_stack('pa_utils2.get_ou_period_information');
3015:
3016: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3017: l_debug_mode := NVL(l_debug_mode, 'N');
3018:
3019: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3020:

Line 3231: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3227: x_pa_period_name := NULL;
3228: x_return_status := FND_API.G_RET_STS_SUCCESS;
3229: x_error_code := NULL;
3230:
3231: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3232: l_debug_mode := NVL(l_debug_mode, 'N');
3233:
3234: IF ( l_debug_mode = 'Y' ) THEN
3235: pa_debug.g_err_stage := 'get_accrual_pa_dt_per dt - '||to_char(p_ei_date);

Line 3551: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3547: ---Initialize the out variables.
3548: x_gl_period_name := NULL;
3549: x_return_status := FND_API.G_RET_STS_SUCCESS;
3550: x_error_code := NULL;
3551: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3552: l_debug_mode := NVL(l_debug_mode, 'N');
3553:
3554:
3555: pa_debug.g_err_stage := 'get_rev_accrual_date() for ref dt- ['||to_char(p_reference_date)||']';

Line 3748: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

3744: x_gl_accr_period_name := NULL;
3745: x_gl_accr_dt := NULL;
3746: x_return_status := FND_API.G_RET_STS_SUCCESS;
3747: x_error_code := NULL;
3748: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3749: l_debug_mode := NVL(l_debug_mode, 'N');
3750:
3751: pa_debug.g_err_stage := 'get_accrual_gl_dt_period() for ref dt- ['||to_char(p_reference_date)||']';
3752: IF ( l_debug_mode = 'Y' ) THEN

Line 4061: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

4057: BEGIN
4058:
4059:
4060:
4061: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4062: l_debug_mode := NVL(l_debug_mode, 'N');
4063: pa_debug.g_err_stage :='From get_accrual_period_information';
4064: IF(l_debug_mode = 'Y') THEN
4065: pa_debug.init_err_stack('pa_utils2.get_accrual_period_information');

Line 4072: l_prof_new_gldate_derivation := nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') ; /*For Bug 5391468*/

4068: pa_debug.write_file(pa_debug.g_err_stage);
4069: END IF;
4070:
4071: if g_prof_new_gldate_derivation IS NULL then
4072: l_prof_new_gldate_derivation := nvl(fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION'),'N') ; /*For Bug 5391468*/
4073: g_prof_new_gldate_derivation := l_prof_new_gldate_derivation;
4074: else
4075: l_prof_new_gldate_derivation := g_prof_new_gldate_derivation;
4076: end if;

Line 4988: IF ( NVL(fnd_profile.value('PA_ENHANCED_BURDENING'),'N') = 'Y' )

4984: RETURN VARCHAR2
4985: IS
4986: BEGIN
4987:
4988: IF ( NVL(fnd_profile.value('PA_ENHANCED_BURDENING'),'N') = 'Y' )
4989: THEN
4990: IF (PA_GMS_API.vert_install)
4991: THEN
4992: RETURN 'N';

Line 5032: l_epp_flag := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ;

5028:
5029: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Entering procedure');
5030:
5031: /* Changed from value_specific to value for bug 5472333 */
5032: l_epp_flag := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ;
5033:
5034: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: EPP Flag status: ' || l_epp_flag);
5035:
5036: l_application_id := l_gl_app_id ;