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.PA_PROGRESS_PUB dependencies on FND_GLOBAL

Line 7: 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');

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROGRESS_PUB';
6:
7: 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');
8:
9: PROCEDURE UPDATE_TASK_PROGRESS(
10: p_api_version IN NUMBER :=1.0,
11: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

Line 66: l_user_id NUMBER := FND_GLOBAL.USER_ID;

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

Line 67: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

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

Line 4310: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

4306: l_msg_data VARCHAR2(250) ;
4307: l_data VARCHAR2(250) ;
4308: l_msg_index_out NUMBER ;
4309: l_error_msg_code VARCHAR2(250) ;
4310: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4311: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4312: g1_debug_mode VARCHAR2(1);
4313:
4314: -- Rollup Cases

Line 4311: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

4307: l_data VARCHAR2(250) ;
4308: l_msg_index_out NUMBER ;
4309: l_error_msg_code VARCHAR2(250) ;
4310: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4311: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4312: g1_debug_mode VARCHAR2(1);
4313:
4314: -- Rollup Cases
4315: -- 1. Workplan Publsihed Version Rollup.

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

4327: -- 4. Entire WBS using structure version id.
4328: -- 5. Program Rollup
4329:
4330:
4331: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4332:
4333: IF g1_debug_mode = 'Y' THEN
4334: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ROLLUP_PROGRESS_PVT');
4335: END IF;

Line 4516: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

4512: l_msg_data VARCHAR2(250) ;
4513: l_data VARCHAR2(250) ;
4514: l_msg_index_out NUMBER ;
4515: l_error_msg_code VARCHAR2(250) ;
4516: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4517: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4518: g1_debug_mode VARCHAR2(1);
4519:
4520: BEGIN

Line 4517: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

4513: l_data VARCHAR2(250) ;
4514: l_msg_index_out NUMBER ;
4515: l_error_msg_code VARCHAR2(250) ;
4516: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
4517: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
4518: g1_debug_mode VARCHAR2(1);
4519:
4520: BEGIN
4521:

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

4518: g1_debug_mode VARCHAR2(1);
4519:
4520: BEGIN
4521:
4522: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4523:
4524: IF g1_debug_mode = 'Y' THEN
4525: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_ROLLUP_PROGRESS_PVT');
4526: END IF;

Line 4773: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id

4769: ,x_project_id => p_project_id
4770: ,X_OBJECT_TYPE => P_OBJECT_TYPE
4771: ,X_OBJECT_ID => P_OBJECT_ID
4772: ,X_LAST_UPDATE_DATE => SYSDATE
4773: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4774: ,X_CREATION_DATE => SYSDATE
4775: ,X_CREATED_BY => FND_GLOBAL.user_id
4776: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4777: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID

Line 4775: ,X_CREATED_BY => FND_GLOBAL.user_id

4771: ,X_OBJECT_ID => P_OBJECT_ID
4772: ,X_LAST_UPDATE_DATE => SYSDATE
4773: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4774: ,X_CREATION_DATE => SYSDATE
4775: ,X_CREATED_BY => FND_GLOBAL.user_id
4776: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4777: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID
4778: ,X_WQ_ENABLE_FLAG => l_WQ_ENABLE_FLAG
4779: ,X_REMAIN_EFFORT_ENABLE_FLAG => l_REMAIN_EFFORT_ENABLE_FLAG

Line 4776: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

4772: ,X_LAST_UPDATE_DATE => SYSDATE
4773: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
4774: ,X_CREATION_DATE => SYSDATE
4775: ,X_CREATED_BY => FND_GLOBAL.user_id
4776: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
4777: ,X_PROGRESS_CYCLE_ID => l_PROGRESS_CYCLE_ID
4778: ,X_WQ_ENABLE_FLAG => l_WQ_ENABLE_FLAG
4779: ,X_REMAIN_EFFORT_ENABLE_FLAG => l_REMAIN_EFFORT_ENABLE_FLAG
4780: ,X_PERCENT_COMP_ENABLE_FLAG => l_PERCENT_COMP_ENABLE_FLAG

Line 5204: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id

5200: ,X_project_id => p_project_id
5201: ,X_OBJECT_TYPE => p_OBJECT_TYPE
5202: ,X_OBJECT_ID => p_OBJECT_ID
5203: ,X_LAST_UPDATE_DATE => SYSDATE
5204: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
5205: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5206: ,X_PROGRESS_CYCLE_ID => p_PROGRESS_CYCLE_ID
5207: ,X_WQ_ENABLE_FLAG => p_WQ_ENABLE_FLAG
5208: ,X_REMAIN_EFFORT_ENABLE_FLAG => p_REMAIN_EFFORT_ENABLE_FLAG

Line 5205: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id

5201: ,X_OBJECT_TYPE => p_OBJECT_TYPE
5202: ,X_OBJECT_ID => p_OBJECT_ID
5203: ,X_LAST_UPDATE_DATE => SYSDATE
5204: ,X_LAST_UPDATED_BY => FND_GLOBAL.user_id
5205: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id
5206: ,X_PROGRESS_CYCLE_ID => p_PROGRESS_CYCLE_ID
5207: ,X_WQ_ENABLE_FLAG => p_WQ_ENABLE_FLAG
5208: ,X_REMAIN_EFFORT_ENABLE_FLAG => p_REMAIN_EFFORT_ENABLE_FLAG
5209: ,X_PERCENT_COMP_ENABLE_FLAG => p_PERCENT_COMP_ENABLE_FLAG

Line 5699: l_user_id NUMBER:= fnd_global.user_id;

5695:
5696: L_PROGRESS_ROLLUP_ID NUMBER;
5697: L_PROG_PA_PERIOD_NAME pa_progress_rollup.prog_pa_period_name%TYPE;
5698: L_PROG_GL_PERIOD_NAME pa_progress_rollup.prog_gl_period_name%TYPE;
5699: l_user_id NUMBER:= fnd_global.user_id;
5700: l_login_id NUMBER:= fnd_global.login_id;
5701: -- Bug 3878024 End
5702:
5703: -- Bug 4282618 Begin

Line 5700: l_login_id NUMBER:= fnd_global.login_id;

5696: L_PROGRESS_ROLLUP_ID NUMBER;
5697: L_PROG_PA_PERIOD_NAME pa_progress_rollup.prog_pa_period_name%TYPE;
5698: L_PROG_GL_PERIOD_NAME pa_progress_rollup.prog_gl_period_name%TYPE;
5699: l_user_id NUMBER:= fnd_global.user_id;
5700: l_login_id NUMBER:= fnd_global.login_id;
5701: -- Bug 3878024 End
5702:
5703: -- Bug 4282618 Begin
5704: CURSOR cur_prog_enabled(c_proj_element_id NUMBER)

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

5717:
5718:
5719: BEGIN
5720:
5721: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
5722:
5723: IF g1_debug_mode = 'Y' THEN
5724: pa_debug.init_err_stack ('PA_PROGRESS_PUB.push_down_task_status');
5725: END IF;

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

7124: g1_debug_mode VARCHAR2(1);
7125:
7126: BEGIN
7127:
7128: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
7129:
7130: IF g1_debug_mode = 'Y' THEN
7131: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ROLLUP_FUTURE_PROGRESS_PVT');
7132: END IF;

Line 7247: l_user_id NUMBER := FND_GLOBAL.USER_ID;

7243: )
7244: IS
7245: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
7246: l_api_version CONSTANT NUMBER := p_api_version;
7247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7249: l_return_status VARCHAR2(1);
7250: l_msg_count NUMBER;
7251: l_msg_data VARCHAR2(250);

Line 7248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

7244: IS
7245: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
7246: l_api_version CONSTANT NUMBER := p_api_version;
7247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
7248: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
7249: l_return_status VARCHAR2(1);
7250: l_msg_count NUMBER;
7251: l_msg_data VARCHAR2(250);
7252: l_msg_code VARCHAR2(12000);

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

7572: END IF;
7573:
7574: x_return_status := FND_API.G_RET_STS_SUCCESS;
7575:
7576: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
7577:
7578: IF g1_debug_mode = 'Y' THEN
7579: 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);
7580: 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 8150: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;

8146: OBJECT_TYPE(l_index2) := l_c1rec.object_type;
8147: AS_OF_DATE(l_index2) := l_as_of_date;
8148: OBJECT_VERSION_ID(l_index2) := l_work_obj_ver_id;
8149: LAST_UPDATE_DATE(l_index2) := sysdate;
8150: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
8151: CREATION_DATE(l_index2) := sysdate;
8152: CREATED_BY(l_index2) := fnd_global.user_id;
8153: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
8154: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

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

8148: OBJECT_VERSION_ID(l_index2) := l_work_obj_ver_id;
8149: LAST_UPDATE_DATE(l_index2) := sysdate;
8150: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
8151: CREATION_DATE(l_index2) := sysdate;
8152: CREATED_BY(l_index2) := fnd_global.user_id;
8153: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
8154: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
8155: INCREMENTAL_WORK_QUANTITY(l_index2) := l_c1rec.INCREMENTAL_WORK_QUANTITY;
8156: CUMULATIVE_WORK_QUANTITY(l_index2) := l_c1rec.CUMULATIVE_WORK_QUANTITY;

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

8150: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
8151: CREATION_DATE(l_index2) := sysdate;
8152: CREATED_BY(l_index2) := fnd_global.user_id;
8153: PROGRESS_STATUS_CODE(l_index2) := l_c1rec.progress_status_code;
8154: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
8155: INCREMENTAL_WORK_QUANTITY(l_index2) := l_c1rec.INCREMENTAL_WORK_QUANTITY;
8156: CUMULATIVE_WORK_QUANTITY(l_index2) := l_c1rec.CUMULATIVE_WORK_QUANTITY;
8157: BASE_PERCENT_COMPLETE(l_index2) := l_c1rec.BASE_PERCENT_COMPLETE;
8158: EFF_ROLLUP_PERCENT_COMP(l_index2) := l_EFF_ROLLUP_PERCENT_COMP;

Line 8857: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8853: )
8854: IS
8855: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WORKING_WP_PROGRESS';
8856: l_api_version CONSTANT NUMBER := p_api_version;
8857: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8858: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8859: l_return_status VARCHAR2(1);
8860: l_msg_count NUMBER;
8861: l_msg_data VARCHAR2(250);

Line 8858: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8854: IS
8855: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_WORKING_WP_PROGRESS';
8856: l_api_version CONSTANT NUMBER := p_api_version;
8857: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8858: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8859: l_return_status VARCHAR2(1);
8860: l_msg_count NUMBER;
8861: l_msg_data VARCHAR2(250);
8862: i NUMBER;

Line 8977: l_user_id NUMBER := FND_GLOBAL.USER_ID;

8973: )
8974: IS
8975: l_api_name CONSTANT VARCHAR2(30) := 'PULL_SUMMARIZED_ACTUALS';
8976: l_api_version CONSTANT NUMBER := p_api_version;
8977: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8978: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8979: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8980: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8981: l_msg_code VARCHAR2(32);

Line 8978: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

8974: IS
8975: l_api_name CONSTANT VARCHAR2(30) := 'PULL_SUMMARIZED_ACTUALS';
8976: l_api_version CONSTANT NUMBER := p_api_version;
8977: l_user_id NUMBER := FND_GLOBAL.USER_ID;
8978: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
8979: l_project_id_list SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8980: l_proj_pgm_level SYSTEM.pa_num_tbl_type:= SYSTEM.pa_num_tbl_type();
8981: l_msg_code VARCHAR2(32);
8982:

Line 9252: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

9248: )
9249: IS
9250: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES' ;
9251: l_api_version CONSTANT NUMBER := p_api_version ;
9252: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9253: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9254: l_return_status VARCHAR2(1) ;
9255: l_msg_count NUMBER ;
9256: l_msg_data VARCHAR2(250) ;

Line 9253: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

9249: IS
9250: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES' ;
9251: l_api_version CONSTANT NUMBER := p_api_version ;
9252: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9253: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9254: l_return_status VARCHAR2(1) ;
9255: l_msg_count NUMBER ;
9256: l_msg_data VARCHAR2(250) ;
9257: l_object_type VARCHAR2(30) ;

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

9367: -- End for Bug # 4524977.
9368:
9369: BEGIN
9370:
9371: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
9372:
9373: IF g1_debug_mode = 'Y' THEN
9374: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_PROGRESS');
9375: END IF;

Line 10276: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10272: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10273: ) AS
10274: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
10275: l_api_version CONSTANT NUMBER := p_api_version;
10276: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10277: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10278: l_return_status VARCHAR2(1);
10279: l_msg_count NUMBER;
10280: l_msg_data VARCHAR2(250);

Line 10277: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10273: ) AS
10274: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
10275: l_api_version CONSTANT NUMBER := p_api_version;
10276: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10277: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10278: l_return_status VARCHAR2(1);
10279: l_msg_count NUMBER;
10280: l_msg_data VARCHAR2(250);
10281: l_baselined_str_ver_id NUMBER; -- FPM Dev CR 7

Line 10468: l_user_id NUMBER := FND_GLOBAL.USER_ID;

10464: ) IS
10465: -- Bug 3621404 : Added parameters for raw cost fields. Existing fields will work as burdened cost
10466: l_api_name CONSTANT VARCHAR2(30) := 'push_workplan_actuals';
10467: l_api_version CONSTANT NUMBER := p_api_version;
10468: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10469: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10470: l_return_status VARCHAR2(1);
10471: l_msg_count NUMBER;
10472: l_msg_data VARCHAR2(250);

Line 10469: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

10465: -- Bug 3621404 : Added parameters for raw cost fields. Existing fields will work as burdened cost
10466: l_api_name CONSTANT VARCHAR2(30) := 'push_workplan_actuals';
10467: l_api_version CONSTANT NUMBER := p_api_version;
10468: l_user_id NUMBER := FND_GLOBAL.USER_ID;
10469: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
10470: l_return_status VARCHAR2(1);
10471: l_msg_count NUMBER;
10472: l_msg_data VARCHAR2(250);
10473:

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

10539: -- Bug 4186007 End
10540:
10541: BEGIN
10542:
10543: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10544: IF g1_debug_mode = 'Y' THEN
10545: pa_debug.init_err_stack ('PA_PROGRESS_PUB.push_workplan_actuals');
10546: END IF;
10547:

Line 11010: l_user_id NUMBER := FND_GLOBAL.USER_ID;

11006: )
11007: IS
11008: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
11009: l_api_version CONSTANT NUMBER := p_api_version;
11010: l_user_id NUMBER := FND_GLOBAL.USER_ID;
11011: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
11012: l_return_status VARCHAR2(1);
11013: l_msg_count NUMBER;
11014: l_msg_data VARCHAR2(250);

Line 11011: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

11007: IS
11008: l_api_name CONSTANT VARCHAR2(30) := 'PROGRAM_ROLLUP_PVT';
11009: l_api_version CONSTANT NUMBER := p_api_version;
11010: l_user_id NUMBER := FND_GLOBAL.USER_ID;
11011: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
11012: l_return_status VARCHAR2(1);
11013: l_msg_count NUMBER;
11014: l_msg_data VARCHAR2(250);
11015: g1_debug_mode VARCHAR2(1);

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

11019: --Open Question:
11020: --1. The parent Project progress record should go to the parent project cycle date.
11021: --As of now it is going with just passed as of date.
11022: --2.
11023: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
11024:
11025: IF g1_debug_mode = 'Y' THEN
11026: pa_debug.init_err_stack ('PA_PROGRESS_PUB.PROGRAM_ROLLUP_PVT');
11027: END IF;

Line 11127: l_user_id NUMBER := FND_GLOBAL.USER_ID;

11123: )
11124: IS
11125: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_WP_PERCENT_TO_FIN';
11126: l_api_version CONSTANT NUMBER := p_api_version;
11127: l_user_id NUMBER := FND_GLOBAL.USER_ID;
11128: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
11129: l_return_status VARCHAR2(1);
11130: l_msg_count NUMBER;
11131: l_msg_data VARCHAR2(250);

Line 11128: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

11124: IS
11125: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER_WP_PERCENT_TO_FIN';
11126: l_api_version CONSTANT NUMBER := p_api_version;
11127: l_user_id NUMBER := FND_GLOBAL.USER_ID;
11128: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
11129: l_return_status VARCHAR2(1);
11130: l_msg_count NUMBER;
11131: l_msg_data VARCHAR2(250);
11132:

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

11216: and structure_type IN('WORKPLAN', 'FINANCIAL')
11217: and current_flag = 'Y';
11218: -- Bug 4284353 End
11219: BEGIN
11220: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
11221:
11222: IF g1_debug_mode = 'Y' THEN
11223: pa_debug.init_err_stack ('PA_PROGRESS_PUB.TRANSFER_WP_PERCENT_TO_FIN');
11224: END IF;

Line 11812: l_user_id NUMBER := fnd_global.user_id;

11808: l_last_ppc_rec c_get_last_ppc_rec%ROWTYPE;
11809: l_last_ppr_rec c_get_last_ppr_rec%ROWTYPE;
11810: l_as_of_date DATE := NULL;
11811: l_max_as_of_date DATE := NULL;
11812: l_user_id NUMBER := fnd_global.user_id;
11813: l_login_id NUMBER := fnd_global.login_id;
11814: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11815: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11816: L_PRE_PUB_STR_VER_ID NUMBER;

Line 11813: l_login_id NUMBER := fnd_global.login_id;

11809: l_last_ppr_rec c_get_last_ppr_rec%ROWTYPE;
11810: l_as_of_date DATE := NULL;
11811: l_max_as_of_date DATE := NULL;
11812: l_user_id NUMBER := fnd_global.user_id;
11813: l_login_id NUMBER := fnd_global.login_id;
11814: l_published_by_party_id NUMBER := PA_UTILS.get_party_id(l_user_id);
11815: L_LATEST_PUB_WP_VERSION_ID NUMBER;
11816: L_PRE_PUB_STR_VER_ID NUMBER;
11817: L_TASK_WEIGHT_BASIS_CODE pa_proj_progress_attr.task_weight_basis_code%TYPE;

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

15986: OBJECT_TYPE(l_index2) := l_object_Type;
15987: as_of_Date(l_index2) := l_temp_as_of_date;
15988: object_version_id(l_index2) := l_object_version_id;
15989: LAST_UPDATE_DATE(l_index2) := sysdate;
15990: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15991: CREATION_DATE(l_index2) := sysdate;
15992: CREATED_BY(l_index2) := fnd_global.user_id;
15993: PROGRESS_STATUS_CODE(l_index2) := null;
15994: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

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

15988: object_version_id(l_index2) := l_object_version_id;
15989: LAST_UPDATE_DATE(l_index2) := sysdate;
15990: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15991: CREATION_DATE(l_index2) := sysdate;
15992: CREATED_BY(l_index2) := fnd_global.user_id;
15993: PROGRESS_STATUS_CODE(l_index2) := null;
15994: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
15995: INCREMENTAL_WORK_QUANTITY(l_index2) := to_number(null);
15996: CUMULATIVE_WORK_QUANTITY(l_index2) := to_number(null);

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

15990: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
15991: CREATION_DATE(l_index2) := sysdate;
15992: CREATED_BY(l_index2) := fnd_global.user_id;
15993: PROGRESS_STATUS_CODE(l_index2) := null;
15994: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
15995: INCREMENTAL_WORK_QUANTITY(l_index2) := to_number(null);
15996: CUMULATIVE_WORK_QUANTITY(l_index2) := to_number(null);
15997: base_percent_complete(l_index2) := to_number(null);
15998: ESTIMATED_START_DATE(l_index2) := to_date(null);

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

17195: OBJECT_TYPE(l_index2) := l_rollup_rec_asofdate.object_Type;
17196: as_of_Date(l_index2) := l_temp_as_of_date;
17197: object_version_id(l_index2) := l_object_version_id;
17198: LAST_UPDATE_DATE(l_index2) := sysdate;
17199: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17200: CREATION_DATE(l_index2) := sysdate;
17201: CREATED_BY(l_index2) := fnd_global.user_id;
17202: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
17203: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

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

17197: object_version_id(l_index2) := l_object_version_id;
17198: LAST_UPDATE_DATE(l_index2) := sysdate;
17199: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17200: CREATION_DATE(l_index2) := sysdate;
17201: CREATED_BY(l_index2) := fnd_global.user_id;
17202: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
17203: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
17204: INCREMENTAL_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.INCREMENTAL_WORK_QUANTITY;
17205: CUMULATIVE_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.CUMULATIVE_WORK_QUANTITY;

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

17199: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
17200: CREATION_DATE(l_index2) := sysdate;
17201: CREATED_BY(l_index2) := fnd_global.user_id;
17202: PROGRESS_STATUS_CODE(l_index2) := l_rollup_rec_asofdate.progress_status_code;
17203: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
17204: INCREMENTAL_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.INCREMENTAL_WORK_QUANTITY;
17205: CUMULATIVE_WORK_QUANTITY(l_index2) := l_rollup_rec_asofdate.CUMULATIVE_WORK_QUANTITY;
17206: base_percent_complete(l_index2) := l_rollup_rec_asofdate.base_percent_complete;
17207: ESTIMATED_START_DATE(l_index2) := l_rollup_rec_asofdate.ESTIMATED_START_DATE;

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

18238: OBJECT_TYPE(l_index2) := all_assign_prev_asofdate_rec.object_Type;
18239: as_of_Date(l_index2) := l_temp_as_of_date;
18240: object_version_id(l_index2) := all_assign_prev_asofdate_rec.object_version_id;
18241: LAST_UPDATE_DATE(l_index2) := sysdate;
18242: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
18243: CREATION_DATE(l_index2) := sysdate;
18244: CREATED_BY(l_index2) := fnd_global.user_id;
18245: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
18246: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;

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

18240: object_version_id(l_index2) := all_assign_prev_asofdate_rec.object_version_id;
18241: LAST_UPDATE_DATE(l_index2) := sysdate;
18242: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
18243: CREATION_DATE(l_index2) := sysdate;
18244: CREATED_BY(l_index2) := fnd_global.user_id;
18245: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
18246: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
18247: INCREMENTAL_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.INCREMENTAL_WORK_QUANTITY;
18248: CUMULATIVE_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.CUMULATIVE_WORK_QUANTITY;

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

18242: LAST_UPDATED_BY(l_index2) := fnd_global.user_id;
18243: CREATION_DATE(l_index2) := sysdate;
18244: CREATED_BY(l_index2) := fnd_global.user_id;
18245: PROGRESS_STATUS_CODE(l_index2) := all_assign_prev_asofdate_rec.progress_status_code;
18246: LAST_UPDATE_LOGIN(l_index2) := fnd_global.login_id ;
18247: INCREMENTAL_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.INCREMENTAL_WORK_QUANTITY;
18248: CUMULATIVE_WORK_QUANTITY(l_index2) := all_assign_prev_asofdate_rec.CUMULATIVE_WORK_QUANTITY;
18249: base_percent_complete(l_index2) := all_assign_prev_asofdate_rec.base_percent_complete;
18250: EFF_ROLLUP_PERCENT_COMP(l_index2) := all_assign_prev_asofdate_rec.EFF_ROLLUP_PERCENT_COMP;

Line 19305: ,LAST_UPDATED_BY = fnd_global.user_id

19301: forall l_index1 in 1..l_index3
19302: update pa_progress_rollup set
19303: OBJECT_VERSION_ID = u_object_version_id(l_index1)
19304: ,LAST_UPDATE_DATE = sysdate
19305: ,LAST_UPDATED_BY = fnd_global.user_id
19306: ,LAST_UPDATE_LOGIN = fnd_global.login_id
19307: ,record_version_number = record_version_number + 1
19308: ,completed_percentage = u_completed_percentage(l_index1)
19309: ,progress_status_code = u_progress_status_code(l_index1) -- Bug 6917961

Line 19306: ,LAST_UPDATE_LOGIN = fnd_global.login_id

19302: update pa_progress_rollup set
19303: OBJECT_VERSION_ID = u_object_version_id(l_index1)
19304: ,LAST_UPDATE_DATE = sysdate
19305: ,LAST_UPDATED_BY = fnd_global.user_id
19306: ,LAST_UPDATE_LOGIN = fnd_global.login_id
19307: ,record_version_number = record_version_number + 1
19308: ,completed_percentage = u_completed_percentage(l_index1)
19309: ,progress_status_code = u_progress_status_code(l_index1) -- Bug 6917961
19310: ,eff_rollup_percent_comp = u_eff_rollup_percent_comp(l_index1)

Line 19774: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;

19770: --End: Fix for Bug # 4018249.
19771: end if;
19772:
19773: if p_extraction_type <> 'PUBLISH' then
19774: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
19775: end if;
19776: /* Added for bug #5659575 If block executes only in PJI flow*/
19777: if NVL(l_act_out_report,'N') = 'Y' then
19778: For l_index in 1..proj_ids_tbl.COUNT loop --- FOR each PROJECT

Line 19914: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

19910: l_msg_data VARCHAR2(250) ;
19911: l_data VARCHAR2(250) ;
19912: l_msg_index_out NUMBER ;
19913: l_error_msg_code VARCHAR2(250) ;
19914: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
19915: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
19916: l_task_id NUMBER ;
19917: l_object_id NUMBER ;
19918: l_project_id NUMBER ;

Line 19915: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

19911: l_data VARCHAR2(250) ;
19912: l_msg_index_out NUMBER ;
19913: l_error_msg_code VARCHAR2(250) ;
19914: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
19915: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
19916: l_task_id NUMBER ;
19917: l_object_id NUMBER ;
19918: l_project_id NUMBER ;
19919: l_percent_complete_id NUMBER ;

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

19985:
19986: l_record_version_number NUMBER ; -- FPM Dev CR 6
19987: BEGIN
19988:
19989: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
19990: IF g1_debug_mode = 'Y' THEN
19991: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_FINANCIAL_TASK_PROGRESS', x_Msg => 'ENTERED', x_Log_Level=> 3);
19992: END IF;
19993:

Line 20892: l_user_id NUMBER := FND_GLOBAL.USER_ID;

20888:
20889: IS
20890: l_api_name CONSTANT VARCHAR2(30) := 'RE_ROLLUP_PROGRESS';
20891: l_api_version CONSTANT NUMBER := p_api_version;
20892: l_user_id NUMBER := FND_GLOBAL.USER_ID;
20893: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
20894: l_return_status VARCHAR2(1);
20895: l_msg_count NUMBER;
20896: l_msg_data VARCHAR2(250);

Line 20893: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

20889: IS
20890: l_api_name CONSTANT VARCHAR2(30) := 'RE_ROLLUP_PROGRESS';
20891: l_api_version CONSTANT NUMBER := p_api_version;
20892: l_user_id NUMBER := FND_GLOBAL.USER_ID;
20893: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
20894: l_return_status VARCHAR2(1);
20895: l_msg_count NUMBER;
20896: l_msg_data VARCHAR2(250);
20897: l_msg_code VARCHAR2(12000);

Line 21277: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

21273: l_msg_data VARCHAR2(250) ;
21274: l_data VARCHAR2(250) ;
21275: l_msg_index_out NUMBER ;
21276: l_error_msg_code VARCHAR2(250) ;
21277: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
21278: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
21279: g1_debug_mode VARCHAR2(1) ;
21280:
21281: BEGIN

Line 21278: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

21274: l_data VARCHAR2(250) ;
21275: l_msg_index_out NUMBER ;
21276: l_error_msg_code VARCHAR2(250) ;
21277: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
21278: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
21279: g1_debug_mode VARCHAR2(1) ;
21280:
21281: BEGIN
21282:

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

21279: g1_debug_mode VARCHAR2(1) ;
21280:
21281: BEGIN
21282:
21283: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
21284:
21285: IF g1_debug_mode = 'Y' THEN
21286: pa_debug.init_err_stack ('PA_PROGRESS_PUB.ASGN_DLV_TO_TASK_ROLLUP_PVT');
21287: END IF;

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

21598: ETC_RATE_BASED_FLAG PA_PLSQL_DATATYPES.Char1TabTyp;
21599:
21600: BEGIN
21601:
21602: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
21603:
21604: IF g1_debug_mode = 'Y' THEN
21605: pa_debug.init_err_stack ('PA_PROGRESS_PUB.COPY_PROGRESS_ACT_ETC');
21606: END IF;

Line 22398: l_user_id NUMBER := FND_GLOBAL.USER_ID;

22394: )
22395: IS
22396: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LINK_PROJ_ROLLUP_DATES';
22397: l_api_version CONSTANT NUMBER := p_api_version;
22398: l_user_id NUMBER := FND_GLOBAL.USER_ID;
22399: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
22400: l_return_status VARCHAR2(1);
22401: l_msg_count NUMBER;
22402: l_msg_data VARCHAR2(250);

Line 22399: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

22395: IS
22396: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_LINK_PROJ_ROLLUP_DATES';
22397: l_api_version CONSTANT NUMBER := p_api_version;
22398: l_user_id NUMBER := FND_GLOBAL.USER_ID;
22399: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
22400: l_return_status VARCHAR2(1);
22401: l_msg_count NUMBER;
22402: l_msg_data VARCHAR2(250);
22403:

Line 22614: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

22610: IS
22611:
22612: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES_BULK' ;
22613: l_api_version CONSTANT NUMBER := p_api_version ;
22614: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
22615: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
22616: l_return_status VARCHAR2(1) ;
22617: l_msg_count NUMBER ;
22618: l_msg_data VARCHAR2(250) ;

Line 22615: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

22611:
22612: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PROGRESSES_BULK' ;
22613: l_api_version CONSTANT NUMBER := p_api_version ;
22614: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
22615: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
22616: l_return_status VARCHAR2(1) ;
22617: l_msg_count NUMBER ;
22618: l_msg_data VARCHAR2(250) ;
22619: l_object_type VARCHAR2(30) ;

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

22729: -- MOAC Changes Bug 4698162 End
22730: l_structure_id number;
22731:
22732: BEGIN
22733: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
22734:
22735: IF g1_debug_mode = 'Y' THEN
22736: pa_debug.init_err_stack ('PA_PROGRESS_PUB.UPDATE_PROGRESS_BULK');
22737: END IF;

Line 23858: l_user_id NUMBER := FND_GLOBAL.USER_ID;

23854: ) IS
23855:
23856: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV_WRP';
23857: l_api_version CONSTANT NUMBER := p_api_version;
23858: l_user_id NUMBER := FND_GLOBAL.USER_ID;
23859: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
23860: l_return_status VARCHAR2(1);
23861: l_msg_count NUMBER;
23862: l_msg_data VARCHAR2(250);

Line 23859: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

23855:
23856: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV_WRP';
23857: l_api_version CONSTANT NUMBER := p_api_version;
23858: l_user_id NUMBER := FND_GLOBAL.USER_ID;
23859: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
23860: l_return_status VARCHAR2(1);
23861: l_msg_count NUMBER;
23862: l_msg_data VARCHAR2(250);
23863: l_msg_code VARCHAR2(12000);

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

23885: END IF;
23886:
23887: x_return_status := FND_API.G_RET_STS_SUCCESS;
23888:
23889: g1_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
23890:
23891: IF g1_debug_mode = 'Y' THEN
23892: 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);
23893: 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);