DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on FND_PROFILE

Line 36: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

32: g_global_calendar_id NUMBER :=-99;
33: g_input_calendar_type VARCHAR2(1) :=' ';
34: g_input_calendar_id NUMBER := -99;
35:
36: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
37: g_proc NUMBER :=5;
38:
39: PROCEDURE Add_Message (p_app_short_name VARCHAR2
40: , p_msg_name VARCHAR2

Line 716: WHERE period_set_name = Fnd_Profile.VALUE( 'BIS_ENTERPRISE_CALENDAR' )

712: /*
713: SELECT calendar_id
714: INTO g_global_calendar_id
715: FROM fii_time_cal_name
716: WHERE period_set_name = Fnd_Profile.VALUE( 'BIS_ENTERPRISE_CALENDAR' )
717: AND period_type = Fnd_Profile.VALUE( 'BIS_PERIOD_TYPE' );
718: */
719: --Bug 5593229
720: -- x_calendar_type := g_global_calendar_type;

Line 717: AND period_type = Fnd_Profile.VALUE( 'BIS_PERIOD_TYPE' );

713: SELECT calendar_id
714: INTO g_global_calendar_id
715: FROM fii_time_cal_name
716: WHERE period_set_name = Fnd_Profile.VALUE( 'BIS_ENTERPRISE_CALENDAR' )
717: AND period_type = Fnd_Profile.VALUE( 'BIS_PERIOD_TYPE' );
718: */
719: --Bug 5593229
720: -- x_calendar_type := g_global_calendar_type;
721: x_calendar_type := NVL(Fnd_Profile.value('PJI_DEF_RPT_CAL_TYPE'), 'E');

Line 721: x_calendar_type := NVL(Fnd_Profile.value('PJI_DEF_RPT_CAL_TYPE'), 'E');

717: AND period_type = Fnd_Profile.VALUE( 'BIS_PERIOD_TYPE' );
718: */
719: --Bug 5593229
720: -- x_calendar_type := g_global_calendar_type;
721: x_calendar_type := NVL(Fnd_Profile.value('PJI_DEF_RPT_CAL_TYPE'), 'E');
722:
723: Derive_Pa_Calendar_Info(p_project_id
724: ,x_calendar_type
725: ,x_calendar_id

Line 1310: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN

1306: x_currency_type:='G';
1307: x_currency_code:=Pji_Utils.get_global_primary_currency;
1308: */
1309:
1310: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1311: x_currency_record_type:= 1;
1312: x_currency_type:= 'G';
1313: x_currency_code:= Pji_Utils.get_global_primary_currency;
1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN

Line 1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN

1310: IF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'GLOBAL_CURRENCY') THEN
1311: x_currency_record_type:= 1;
1312: x_currency_type:= 'G';
1313: x_currency_code:= Pji_Utils.get_global_primary_currency;
1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1315: x_currency_record_type:= 2;
1316: x_currency_type:= 'G';
1317: x_currency_code:= Pji_Utils.get_global_secondary_currency;
1318: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'PROJ_CURRENCY') THEN

Line 1318: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'PROJ_CURRENCY') THEN

1314: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'SEC_GLOBAL_CURRENCY') THEN
1315: x_currency_record_type:= 2;
1316: x_currency_type:= 'G';
1317: x_currency_code:= Pji_Utils.get_global_secondary_currency;
1318: ELSIF (Fnd_Profile.value('PJI_DEF_RPT_CUR_TYPE') = 'PROJ_CURRENCY') THEN
1319: x_currency_record_type:= 8;
1320: x_currency_type:= 'P';
1321: x_currency_code:= g_proj_currency_code;
1322: ELSE

Line 3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3491:
3492: BEGIN
3493: x_msg_count := 0;
3494: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3495: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3496:
3497: IF l_debug_mode = 'Y' THEN
3498: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_PARAM_CONSISTENCY',
3499: p_debug_mode => l_debug_mode );

Line 3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3668:
3669: BEGIN
3670: x_msg_count := 0;
3671: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3672: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3673:
3674: IF l_debug_mode = 'Y' THEN
3675: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_CURRENCY_CONSISTENCY',
3676: p_debug_mode => l_debug_mode );

Line 3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3776:
3777: BEGIN
3778: x_msg_count := 0;
3779: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3780: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3781:
3782: IF l_debug_mode = 'Y' THEN
3783: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_MARGIN_CONSISTENCY',
3784: p_debug_mode => l_debug_mode );

Line 3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3869:
3870: BEGIN
3871: x_msg_count := 0;
3872: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3873: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3874:
3875: IF l_debug_mode = 'Y' THEN
3876: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_STATUS_CONSISTENCY',
3877: p_debug_mode => l_debug_mode );

Line 3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

3965:
3966: BEGIN
3967: x_msg_count := 0;
3968: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3969: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
3970:
3971: IF l_debug_mode = 'Y' THEN
3972: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_TIME_CONSISTENCY',
3973: p_debug_mode => l_debug_mode );

Line 4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4074:
4075: BEGIN
4076: x_msg_count := 0;
4077: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4078: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4079:
4080: IF l_debug_mode = 'Y' THEN
4081: Pa_Debug.set_curr_function( p_function => 'CHECK_WP_RBS_CONSISTENCY',
4082: p_debug_mode => l_debug_mode );

Line 4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4724:
4725: BEGIN
4726: x_msg_count := 0;
4727: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4728: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4729:
4730: IF l_debug_mode = 'Y' THEN
4731: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Cal_Consistency',
4732: p_debug_mode => l_debug_mode );

Line 4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');

4818:
4819: BEGIN
4820: x_msg_count := 0;
4821: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
4822: l_debug_mode := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
4823:
4824: IF l_debug_mode = 'Y' THEN
4825: Pa_Debug.set_curr_function( p_function => 'Check_Perf_Curr_Consistency',
4826: p_debug_mode => l_debug_mode );