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.

[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on FND_GLOBAL

Line 6: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

2: /* $Header: PAPCPUBB.pls 120.57.12010000.5 2008/09/19 04:55:09 rballamu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROGRESS_PUB';
5:
6: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
7:
8: PROCEDURE UPDATE_TASK_PROGRESS(
9: p_api_version IN NUMBER :=1.0,
10: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

Line 65: l_user_id NUMBER := FND_GLOBAL.USER_ID;

61: l_msg_data VARCHAR2(250);
62: l_data VARCHAR2(250);
63: l_msg_index_out NUMBER;
64: l_error_msg_code VARCHAR2(250);
65: l_user_id NUMBER := FND_GLOBAL.USER_ID;
66: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
67:
68: l_task_id NUMBER;
69: l_project_id NUMBER;

Line 66: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

62: l_data VARCHAR2(250);
63: l_msg_index_out NUMBER;
64: l_error_msg_code VARCHAR2(250);
65: l_user_id NUMBER := FND_GLOBAL.USER_ID;
66: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
67:
68: l_task_id NUMBER;
69: l_project_id NUMBER;
70: l_att_pc_id NUMBER;

Line 3906: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

3902: l_msg_data VARCHAR2(250) ;
3903: l_data VARCHAR2(250) ;
3904: l_msg_index_out NUMBER ;
3905: l_error_msg_code VARCHAR2(250) ;
3906: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
3907: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
3908: g1_debug_mode VARCHAR2(1);
3909:
3910: -- Rollup Cases

Line 3907: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

3903: l_data VARCHAR2(250) ;
3904: l_msg_index_out NUMBER ;
3905: l_error_msg_code VARCHAR2(250) ;
3906: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
3907: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
3908: g1_debug_mode VARCHAR2(1);
3909:
3910: -- Rollup Cases
3911: -- 1. Workplan Publsihed Version Rollup.

Line 3927: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

3923: -- 4. Entire WBS using structure version id.
3924: -- 5. Program Rollup
3925:
3926:
3927: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
3928:
3929: IF g1_debug_mode = 'Y' THEN
3930: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ROLLUP_PROGRESS_PVT');
3931: END IF;

Line 4112: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

4108: l_msg_data VARCHAR2(250) ;
4109: l_data VARCHAR2(250) ;
4110: l_msg_index_out NUMBER ;
4111: l_error_msg_code VARCHAR2(250) ;
4112: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4113: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4114: g1_debug_mode VARCHAR2(1);
4115:
4116: BEGIN

Line 4113: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

4109: l_data VARCHAR2(250) ;
4110: l_msg_index_out NUMBER ;
4111: l_error_msg_code VARCHAR2(250) ;
4112: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4113: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4114: g1_debug_mode VARCHAR2(1);
4115:
4116: BEGIN
4117:

Line 4118: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

4114: g1_debug_mode VARCHAR2(1);
4115:
4116: BEGIN
4117:
4118: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4119:
4120: IF g1_debug_mode = 'Y' THEN
4121: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_ROLLUP_PROGRESS_PVT');
4122: END IF;

Line 4369: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id

4365: ,x_project_id => p_project_id
4366: ,X_OBJECT_TYPE => P_OBJECT_TYPE
4367: ,X_OBJECT_ID => P_OBJECT_ID
4368: ,X_LAST_UPDATE_DATE => SYSDATE
4369: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4370: ,X_CREATION_DATE => SYSDATE
4371: ,X_CREATED_BY => FND_GLOBAL.user_id
4372: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4373: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID

Line 4371: ,X_CREATED_BY => FND_GLOBAL.user_id

4367: ,X_OBJECT_ID => P_OBJECT_ID
4368: ,X_LAST_UPDATE_DATE => SYSDATE
4369: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4370: ,X_CREATION_DATE => SYSDATE
4371: ,X_CREATED_BY => FND_GLOBAL.user_id
4372: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4373: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID
4374: ,X_WQ_ENABLE_FLAG => l_WQ_ENABLE_FLAG
4375: ,X_REMAIN_EFFORT_ENABLE_FLAG => l_REMAIN_EFFORT_ENABLE_FLAG

Line 4372: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

4368: ,X_LAST_UPDATE_DATE => SYSDATE
4369: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4370: ,X_CREATION_DATE => SYSDATE
4371: ,X_CREATED_BY => FND_GLOBAL.user_id
4372: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4373: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID
4374: ,X_WQ_ENABLE_FLAG => l_WQ_ENABLE_FLAG
4375: ,X_REMAIN_EFFORT_ENABLE_FLAG => l_REMAIN_EFFORT_ENABLE_FLAG
4376: ,X_PERCENT_COMP_ENABLE_FLAG => l_PERCENT_COMP_ENABLE_FLAG

Line 4800: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id

4796: ,X_project_id => p_project_id
4797: ,X_OBJECT_TYPE => p_OBJECT_TYPE
4798: ,X_OBJECT_ID => p_OBJECT_ID
4799: ,X_LAST_UPDATE_DATE => SYSDATE
4800: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4801: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4802: ,X_PROGRESS_CYCLE_ID => p_PROGRESS_CYCLE_ID
4803: ,X_WQ_ENABLE_FLAG => p_WQ_ENABLE_FLAG
4804: ,X_REMAIN_EFFORT_ENABLE_FLAG => p_REMAIN_EFFORT_ENABLE_FLAG

Line 4801: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

4797: ,X_OBJECT_TYPE => p_OBJECT_TYPE
4798: ,X_OBJECT_ID => p_OBJECT_ID
4799: ,X_LAST_UPDATE_DATE => SYSDATE
4800: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4801: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4802: ,X_PROGRESS_CYCLE_ID => p_PROGRESS_CYCLE_ID
4803: ,X_WQ_ENABLE_FLAG => p_WQ_ENABLE_FLAG
4804: ,X_REMAIN_EFFORT_ENABLE_FLAG => p_REMAIN_EFFORT_ENABLE_FLAG
4805: ,X_PERCENT_COMP_ENABLE_FLAG => p_PERCENT_COMP_ENABLE_FLAG

Line 5295: l_user_id NUMBER:= fnd_global.user_id;

5291:
5292: L_PROGRESS_ROLLUP_ID NUMBER;
5293: L_PROG_PA_PERIOD_NAME pa_progress_rollup.prog_pa_period_name%TYPE;
5294: L_PROG_GL_PERIOD_NAME pa_progress_rollup.prog_gl_period_name%TYPE;
5295: l_user_id NUMBER:= fnd_global.user_id;
5296: l_login_id NUMBER:= fnd_global.login_id;
5297: -- Bug 3878024 End
5298:
5299: -- Bug 4282618 Begin

Line 5296: l_login_id NUMBER:= fnd_global.login_id;

5292: L_PROGRESS_ROLLUP_ID NUMBER;
5293: L_PROG_PA_PERIOD_NAME pa_progress_rollup.prog_pa_period_name%TYPE;
5294: L_PROG_GL_PERIOD_NAME pa_progress_rollup.prog_gl_period_name%TYPE;
5295: l_user_id NUMBER:= fnd_global.user_id;
5296: l_login_id NUMBER:= fnd_global.login_id;
5297: -- Bug 3878024 End
5298:
5299: -- Bug 4282618 Begin
5300: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)

Line 5317: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

5313:
5314:
5315: BEGIN
5316:
5317: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
5318:
5319: IF g1_debug_mode = 'Y' THEN
5320: pa_debug.init_err_stack ('PA_PROGRESS_PUB.push_down_task_status');
5321: END IF;

Line 6724: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

6720: g1_debug_mode VARCHAR2(1);
6721:
6722: BEGIN
6723:
6724: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
6725:
6726: IF g1_debug_mode = 'Y' THEN
6727: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ROLLUP_FUTURE_PROGRESS_PVT');
6728: END IF;

Line 6843: l_user_id NUMBER := FND_GLOBAL.USER_ID;

6839: )
6840: IS
6841: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
6842: l_api_version CONSTANT NUMBER := p_api_version;
6843: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6845: l_return_status VARCHAR2(1);
6846: l_msg_count NUMBER;
6847: l_msg_data VARCHAR2(250);

Line 6844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

6840: IS
6841: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
6842: l_api_version CONSTANT NUMBER := p_api_version;
6843: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
6845: l_return_status VARCHAR2(1);
6846: l_msg_count NUMBER;
6847: l_msg_data VARCHAR2(250);
6848: l_msg_code VARCHAR2(12000);

Line 7163: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

7159: END IF;
7160:
7161: x_return_status := FND_API.G_RET_STS_SUCCESS;
7162:
7163: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
7164:
7165: IF g1_debug_mode = 'Y' THEN
7166: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV', x_Msg => 'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV Start : Passed Parameters :', x_Log_Level=> 3);
7167: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);

Line 7734: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;

7730: OBJECT_TYPE(l_index2) := l_c1rec.object_type;
7731: AS_OF_DATE(l_index2) := l_as_of_date;
7732: OBJECT_VERSION_ID(l_index2) := l_work_obj_ver_id;
7733: LAST_UPDATE_DATE(l_index2) := sysdate;
7734: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
7735: CREATION_DATE(l_index2) := sysdate;
7736: CREATED_BY(l_index2) := fnd_global.user_id;
7737: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
7738: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

Line 7736: CREATED_BY(l_index2) := fnd_global.user_id;

7732: OBJECT_VERSION_ID(l_index2) := l_work_obj_ver_id;
7733: LAST_UPDATE_DATE(l_index2) := sysdate;
7734: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
7735: CREATION_DATE(l_index2) := sysdate;
7736: CREATED_BY(l_index2) := fnd_global.user_id;
7737: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
7738: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
7739: INCREMENTAL_WORK_QUANTITY(l_index2) := l_c1rec.INCREMENTAL_WORK_QUANTITY;
7740: CUMULATIVE_WORK_QUANTITY(l_index2) := l_c1rec.CUMULATIVE_WORK_QUANTITY;

Line 7738: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

7734: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
7735: CREATION_DATE(l_index2) := sysdate;
7736: CREATED_BY(l_index2) := fnd_global.user_id;
7737: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
7738: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
7739: INCREMENTAL_WORK_QUANTITY(l_index2) := l_c1rec.INCREMENTAL_WORK_QUANTITY;
7740: CUMULATIVE_WORK_QUANTITY(l_index2) := l_c1rec.CUMULATIVE_WORK_QUANTITY;
7741: BASE_PERCENT_COMPLETE(l_index2) := l_c1rec.BASE_PERCENT_COMPLETE;
7742: EFF_ROLLUP_PERCENT_COMP(l_index2) := l_EFF_ROLLUP_PERCENT_COMP;

Line 8439: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8435: )
8436: IS
8437: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WORKING_WP_PROGRESS';
8438: l_api_version CONSTANT NUMBER := p_api_version;
8439: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8440: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8441: l_return_status VARCHAR2(1);
8442: l_msg_count NUMBER;
8443: l_msg_data VARCHAR2(250);

Line 8440: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8436: IS
8437: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WORKING_WP_PROGRESS';
8438: l_api_version CONSTANT NUMBER := p_api_version;
8439: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8440: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8441: l_return_status VARCHAR2(1);
8442: l_msg_count NUMBER;
8443: l_msg_data VARCHAR2(250);
8444: i NUMBER;

Line 8559: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8555: )
8556: IS
8557: l_api_name CONSTANT VARCHAR2(30) := 'PULL_SUMMARIZED_ACTUALS';
8558: l_api_version CONSTANT NUMBER := p_api_version;
8559: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8560: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8561: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8562: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8563: l_msg_code VARCHAR2(32);

Line 8560: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8556: IS
8557: l_api_name CONSTANT VARCHAR2(30) := 'PULL_SUMMARIZED_ACTUALS';
8558: l_api_version CONSTANT NUMBER := p_api_version;
8559: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8560: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8561: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8562: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8563: l_msg_code VARCHAR2(32);
8564:

Line 8834: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

8830: )
8831: IS
8832: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES' ;
8833: l_api_version CONSTANT NUMBER := p_api_version ;
8834: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8835: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8836: l_return_status VARCHAR2(1) ;
8837: l_msg_count NUMBER ;
8838: l_msg_data VARCHAR2(250) ;

Line 8835: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

8831: IS
8832: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES' ;
8833: l_api_version CONSTANT NUMBER := p_api_version ;
8834: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8835: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8836: l_return_status VARCHAR2(1) ;
8837: l_msg_count NUMBER ;
8838: l_msg_data VARCHAR2(250) ;
8839: l_object_type VARCHAR2(30) ;

Line 8951: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

8947: -- End for Bug # 4524977.
8948:
8949: BEGIN
8950:
8951: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
8952:
8953: IF g1_debug_mode = 'Y' THEN
8954: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_PROGRESS');
8955: END IF;

Line 9843: l_user_id NUMBER := FND_GLOBAL.USER_ID;

9839: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
9840: ) AS
9841: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
9842: l_api_version CONSTANT NUMBER := p_api_version;
9843: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9845: l_return_status VARCHAR2(1);
9846: l_msg_count NUMBER;
9847: l_msg_data VARCHAR2(250);

Line 9844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

9840: ) AS
9841: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
9842: l_api_version CONSTANT NUMBER := p_api_version;
9843: l_user_id NUMBER := FND_GLOBAL.USER_ID;
9844: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
9845: l_return_status VARCHAR2(1);
9846: l_msg_count NUMBER;
9847: l_msg_data VARCHAR2(250);
9848: l_baselined_str_ver_id NUMBER; -- FPM Dev CR 7

Line 10034: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10030: ) IS
10031: -- Bug 3621404 : Added parameters for raw cost fields. Existing fields will work as burdened cost
10032: l_api_name CONSTANT VARCHAR2(30) := 'push_workplan_actuals';
10033: l_api_version CONSTANT NUMBER := p_api_version;
10034: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10035: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10036: l_return_status VARCHAR2(1);
10037: l_msg_count NUMBER;
10038: l_msg_data VARCHAR2(250);

Line 10035: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10031: -- Bug 3621404 : Added parameters for raw cost fields. Existing fields will work as burdened cost
10032: l_api_name CONSTANT VARCHAR2(30) := 'push_workplan_actuals';
10033: l_api_version CONSTANT NUMBER := p_api_version;
10034: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10035: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10036: l_return_status VARCHAR2(1);
10037: l_msg_count NUMBER;
10038: l_msg_data VARCHAR2(250);
10039:

Line 10108: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

10104: -- Bug 4186007 End
10105:
10106: BEGIN
10107:
10108: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10109: IF g1_debug_mode = 'Y' THEN
10110: pa_debug.init_err_stack ('PA_PROGRESS_PUB.push_workplan_actuals');
10111: END IF;
10112:

Line 10568: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10564: )
10565: IS
10566: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
10567: l_api_version CONSTANT NUMBER := p_api_version;
10568: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10569: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10570: l_return_status VARCHAR2(1);
10571: l_msg_count NUMBER;
10572: l_msg_data VARCHAR2(250);

Line 10569: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10565: IS
10566: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
10567: l_api_version CONSTANT NUMBER := p_api_version;
10568: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10569: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10570: l_return_status VARCHAR2(1);
10571: l_msg_count NUMBER;
10572: l_msg_data VARCHAR2(250);
10573: g1_debug_mode VARCHAR2(1);

Line 10581: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

10577: --Open Question:
10578: --1. The parent Project progress record should go to the parent project cycle date.
10579: --As of now it is going with just passed as of date.
10580: --2.
10581: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10582:
10583: IF g1_debug_mode = 'Y' THEN
10584: pa_debug.init_err_stack ('PA_PROGRESS_PUB.PROGRAM_ROLLUP_PVT');
10585: END IF;

Line 10685: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10681: )
10682: IS
10683: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_WP_PERCENT_TO_FIN';
10684: l_api_version CONSTANT NUMBER := p_api_version;
10685: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10686: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10687: l_return_status VARCHAR2(1);
10688: l_msg_count NUMBER;
10689: l_msg_data VARCHAR2(250);

Line 10686: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10682: IS
10683: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_WP_PERCENT_TO_FIN';
10684: l_api_version CONSTANT NUMBER := p_api_version;
10685: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10686: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10687: l_return_status VARCHAR2(1);
10688: l_msg_count NUMBER;
10689: l_msg_data VARCHAR2(250);
10690:

Line 10778: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

10774: and structure_type IN('WORKPLAN', 'FINANCIAL')
10775: and current_flag = 'Y';
10776: -- Bug 4284353 End
10777: BEGIN
10778: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10779:
10780: IF g1_debug_mode = 'Y' THEN
10781: pa_debug.init_err_stack ('PA_PROGRESS_PUB.TRANSFER_WP_PERCENT_TO_FIN');
10782: END IF;

Line 11362: l_user_id NUMBER := fnd_global.user_id;

11358: l_last_ppc_rec c_get_last_ppc_rec%ROWTYPE;
11359: l_last_ppr_rec c_get_last_ppr_rec%ROWTYPE;
11360: l_as_of_date DATE := NULL;
11361: l_max_as_of_date DATE := NULL;
11362: l_user_id NUMBER := fnd_global.user_id;
11363: l_login_id NUMBER := fnd_global.login_id;
11364: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11365: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11366: L_PRE_PUB_STR_VER_ID NUMBER;

Line 11363: l_login_id NUMBER := fnd_global.login_id;

11359: l_last_ppr_rec c_get_last_ppr_rec%ROWTYPE;
11360: l_as_of_date DATE := NULL;
11361: l_max_as_of_date DATE := NULL;
11362: l_user_id NUMBER := fnd_global.user_id;
11363: l_login_id NUMBER := fnd_global.login_id;
11364: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11365: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11366: L_PRE_PUB_STR_VER_ID NUMBER;
11367: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;

Line 15291: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;

15287: OBJECT_TYPE(l_index2) := l_object_Type;
15288: as_of_Date(l_index2) := l_temp_as_of_date;
15289: object_version_id(l_index2) := l_object_version_id;
15290: LAST_UPDATE_DATE(l_index2) := sysdate;
15291: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15292: CREATION_DATE(l_index2) := sysdate;
15293: CREATED_BY(l_index2) := fnd_global.user_id;
15294: PROGRESS_STATUS_CODE(l_index2) := null;
15295: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

Line 15293: CREATED_BY(l_index2) := fnd_global.user_id;

15289: object_version_id(l_index2) := l_object_version_id;
15290: LAST_UPDATE_DATE(l_index2) := sysdate;
15291: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15292: CREATION_DATE(l_index2) := sysdate;
15293: CREATED_BY(l_index2) := fnd_global.user_id;
15294: PROGRESS_STATUS_CODE(l_index2) := null;
15295: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
15296: INCREMENTAL_WORK_QUANTITY(l_index2) := to_number(null);
15297: CUMULATIVE_WORK_QUANTITY(l_index2) := to_number(null);

Line 15295: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

15291: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15292: CREATION_DATE(l_index2) := sysdate;
15293: CREATED_BY(l_index2) := fnd_global.user_id;
15294: PROGRESS_STATUS_CODE(l_index2) := null;
15295: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
15296: INCREMENTAL_WORK_QUANTITY(l_index2) := to_number(null);
15297: CUMULATIVE_WORK_QUANTITY(l_index2) := to_number(null);
15298: base_percent_complete(l_index2) := to_number(null);
15299: ESTIMATED_START_DATE(l_index2) := to_date(null);

Line 16222: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;

16218: OBJECT_TYPE(l_index2) := l_rollup_rec_asofdate.object_Type;
16219: as_of_Date(l_index2) := l_temp_as_of_date;
16220: object_version_id(l_index2) := l_object_version_id;
16221: LAST_UPDATE_DATE(l_index2) := sysdate;
16222: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
16223: CREATION_DATE(l_index2) := sysdate;
16224: CREATED_BY(l_index2) := fnd_global.user_id;
16225: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
16226: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

Line 16224: CREATED_BY(l_index2) := fnd_global.user_id;

16220: object_version_id(l_index2) := l_object_version_id;
16221: LAST_UPDATE_DATE(l_index2) := sysdate;
16222: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
16223: CREATION_DATE(l_index2) := sysdate;
16224: CREATED_BY(l_index2) := fnd_global.user_id;
16225: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
16226: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
16227: INCREMENTAL_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.INCREMENTAL_WORK_QUANTITY;
16228: CUMULATIVE_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.CUMULATIVE_WORK_QUANTITY;

Line 16226: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

16222: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
16223: CREATION_DATE(l_index2) := sysdate;
16224: CREATED_BY(l_index2) := fnd_global.user_id;
16225: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
16226: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
16227: INCREMENTAL_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.INCREMENTAL_WORK_QUANTITY;
16228: CUMULATIVE_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.CUMULATIVE_WORK_QUANTITY;
16229: base_percent_complete(l_index2) := l_rollup_rec_asofdate.base_percent_complete;
16230: ESTIMATED_START_DATE(l_index2) := l_rollup_rec_asofdate.ESTIMATED_START_DATE;

Line 17074: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;

17070: OBJECT_TYPE(l_index2) := all_assign_prev_asofdate_rec.object_Type;
17071: as_of_Date(l_index2) := l_temp_as_of_date;
17072: object_version_id(l_index2) := all_assign_prev_asofdate_rec.object_version_id;
17073: LAST_UPDATE_DATE(l_index2) := sysdate;
17074: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17075: CREATION_DATE(l_index2) := sysdate;
17076: CREATED_BY(l_index2) := fnd_global.user_id;
17077: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
17078: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

Line 17076: CREATED_BY(l_index2) := fnd_global.user_id;

17072: object_version_id(l_index2) := all_assign_prev_asofdate_rec.object_version_id;
17073: LAST_UPDATE_DATE(l_index2) := sysdate;
17074: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17075: CREATION_DATE(l_index2) := sysdate;
17076: CREATED_BY(l_index2) := fnd_global.user_id;
17077: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
17078: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
17079: INCREMENTAL_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.INCREMENTAL_WORK_QUANTITY;
17080: CUMULATIVE_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.CUMULATIVE_WORK_QUANTITY;

Line 17078: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

17074: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17075: CREATION_DATE(l_index2) := sysdate;
17076: CREATED_BY(l_index2) := fnd_global.user_id;
17077: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
17078: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
17079: INCREMENTAL_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.INCREMENTAL_WORK_QUANTITY;
17080: CUMULATIVE_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.CUMULATIVE_WORK_QUANTITY;
17081: base_percent_complete(l_index2) := all_assign_prev_asofdate_rec.base_percent_complete;
17082: EFF_ROLLUP_PERCENT_COMP(l_index2) := all_assign_prev_asofdate_rec.EFF_ROLLUP_PERCENT_COMP;

Line 17869: ,LAST_UPDATED_BY = fnd_global.user_id

17865: forall l_index1 in 1..l_index3
17866: update pa_progress_rollup set
17867: OBJECT_VERSION_ID = u_object_version_id(l_index1)
17868: ,LAST_UPDATE_DATE = sysdate
17869: ,LAST_UPDATED_BY = fnd_global.user_id
17870: ,LAST_UPDATE_LOGIN = fnd_global.login_id
17871: ,record_version_number = record_version_number + 1
17872: ,completed_percentage = u_completed_percentage(l_index1)
17873: ,progress_status_code = u_progress_status_code(l_index1) -- Bug 6917961

Line 17870: ,LAST_UPDATE_LOGIN = fnd_global.login_id

17866: update pa_progress_rollup set
17867: OBJECT_VERSION_ID = u_object_version_id(l_index1)
17868: ,LAST_UPDATE_DATE = sysdate
17869: ,LAST_UPDATED_BY = fnd_global.user_id
17870: ,LAST_UPDATE_LOGIN = fnd_global.login_id
17871: ,record_version_number = record_version_number + 1
17872: ,completed_percentage = u_completed_percentage(l_index1)
17873: ,progress_status_code = u_progress_status_code(l_index1) -- Bug 6917961
17874: ,eff_rollup_percent_comp = u_eff_rollup_percent_comp(l_index1)

Line 18329: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;

18325: --End: Fix for Bug # 4018249.
18326: end if;
18327:
18328: if p_extraction_type <> 'PUBLISH' then
18329: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
18330: end if;
18331: /* Added for bug #5659575 If block executes only in PJI flow*/
18332: if NVL(l_act_out_report,'N') = 'Y' then
18333: For l_index in 1..proj_ids_tbl.COUNT loop --- FOR each PROJECT

Line 18469: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

18465: l_msg_data VARCHAR2(250) ;
18466: l_data VARCHAR2(250) ;
18467: l_msg_index_out NUMBER ;
18468: l_error_msg_code VARCHAR2(250) ;
18469: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
18470: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
18471: l_task_id NUMBER ;
18472: l_object_id NUMBER ;
18473: l_project_id NUMBER ;

Line 18470: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

18466: l_data VARCHAR2(250) ;
18467: l_msg_index_out NUMBER ;
18468: l_error_msg_code VARCHAR2(250) ;
18469: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
18470: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
18471: l_task_id NUMBER ;
18472: l_object_id NUMBER ;
18473: l_project_id NUMBER ;
18474: l_percent_complete_id NUMBER ;

Line 18544: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

18540:
18541: l_record_version_number NUMBER ; -- FPM Dev CR 6
18542: BEGIN
18543:
18544: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
18545: IF g1_debug_mode = 'Y' THEN
18546: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_FINANCIAL_TASK_PROGRESS', x_Msg => 'ENTERED', x_Log_Level=> 3);
18547: END IF;
18548:

Line 19429: l_user_id NUMBER := FND_GLOBAL.USER_ID;

19425:
19426: IS
19427: l_api_name CONSTANT VARCHAR2(30) := 'RE_ROLLUP_PROGRESS';
19428: l_api_version CONSTANT NUMBER := p_api_version;
19429: l_user_id NUMBER := FND_GLOBAL.USER_ID;
19430: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
19431: l_return_status VARCHAR2(1);
19432: l_msg_count NUMBER;
19433: l_msg_data VARCHAR2(250);

Line 19430: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

19426: IS
19427: l_api_name CONSTANT VARCHAR2(30) := 'RE_ROLLUP_PROGRESS';
19428: l_api_version CONSTANT NUMBER := p_api_version;
19429: l_user_id NUMBER := FND_GLOBAL.USER_ID;
19430: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
19431: l_return_status VARCHAR2(1);
19432: l_msg_count NUMBER;
19433: l_msg_data VARCHAR2(250);
19434: l_msg_code VARCHAR2(12000);

Line 19814: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

19810: l_msg_data VARCHAR2(250) ;
19811: l_data VARCHAR2(250) ;
19812: l_msg_index_out NUMBER ;
19813: l_error_msg_code VARCHAR2(250) ;
19814: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
19815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
19816: g1_debug_mode VARCHAR2(1) ;
19817:
19818: BEGIN

Line 19815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

19811: l_data VARCHAR2(250) ;
19812: l_msg_index_out NUMBER ;
19813: l_error_msg_code VARCHAR2(250) ;
19814: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
19815: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
19816: g1_debug_mode VARCHAR2(1) ;
19817:
19818: BEGIN
19819:

Line 19820: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

19816: g1_debug_mode VARCHAR2(1) ;
19817:
19818: BEGIN
19819:
19820: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
19821:
19822: IF g1_debug_mode = 'Y' THEN
19823: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ASGN_DLV_TO_TASK_ROLLUP_PVT');
19824: END IF;

Line 20139: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

20135: ETC_RATE_BASED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
20136:
20137: BEGIN
20138:
20139: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
20140:
20141: IF g1_debug_mode = 'Y' THEN
20142: pa_debug.init_err_stack ('PA_PROGRESS_PUB.COPY_PROGRESS_ACT_ETC');
20143: END IF;

Line 20935: l_user_id NUMBER := FND_GLOBAL.USER_ID;

20931: )
20932: IS
20933: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LINK_PROJ_ROLLUP_DATES';
20934: l_api_version CONSTANT NUMBER := p_api_version;
20935: l_user_id NUMBER := FND_GLOBAL.USER_ID;
20936: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
20937: l_return_status VARCHAR2(1);
20938: l_msg_count NUMBER;
20939: l_msg_data VARCHAR2(250);

Line 20936: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

20932: IS
20933: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LINK_PROJ_ROLLUP_DATES';
20934: l_api_version CONSTANT NUMBER := p_api_version;
20935: l_user_id NUMBER := FND_GLOBAL.USER_ID;
20936: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
20937: l_return_status VARCHAR2(1);
20938: l_msg_count NUMBER;
20939: l_msg_data VARCHAR2(250);
20940:

Line 21151: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

21147: IS
21148:
21149: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES_BULK' ;
21150: l_api_version CONSTANT NUMBER := p_api_version ;
21151: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
21152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
21153: l_return_status VARCHAR2(1) ;
21154: l_msg_count NUMBER ;
21155: l_msg_data VARCHAR2(250) ;

Line 21152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

21148:
21149: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES_BULK' ;
21150: l_api_version CONSTANT NUMBER := p_api_version ;
21151: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
21152: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
21153: l_return_status VARCHAR2(1) ;
21154: l_msg_count NUMBER ;
21155: l_msg_data VARCHAR2(250) ;
21156: l_object_type VARCHAR2(30) ;

Line 21268: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

21264: -- MOAC Changes Bug 4698162 End
21265: l_structure_id number;
21266:
21267: BEGIN
21268: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
21269:
21270: IF g1_debug_mode = 'Y' THEN
21271: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK');
21272: END IF;

Line 22336: l_user_id NUMBER := FND_GLOBAL.USER_ID;

22332: ) IS
22333:
22334: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV_WRP';
22335: l_api_version CONSTANT NUMBER := p_api_version;
22336: l_user_id NUMBER := FND_GLOBAL.USER_ID;
22337: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
22338: l_return_status VARCHAR2(1);
22339: l_msg_count NUMBER;
22340: l_msg_data VARCHAR2(250);

Line 22337: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

22333:
22334: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV_WRP';
22335: l_api_version CONSTANT NUMBER := p_api_version;
22336: l_user_id NUMBER := FND_GLOBAL.USER_ID;
22337: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
22338: l_return_status VARCHAR2(1);
22339: l_msg_count NUMBER;
22340: l_msg_data VARCHAR2(250);
22341: l_msg_code VARCHAR2(12000);

Line 22367: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

22363: END IF;
22364:
22365: x_return_status := FND_API.G_RET_STS_SUCCESS;
22366:
22367: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
22368:
22369: IF g1_debug_mode = 'Y' THEN
22370: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP Start : Passed Parameters :', x_Log_Level=> 3);
22371: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV_WRP', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);