DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on FND_GLOBAL

Line 579: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

575:
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577: x_requirement_id_tbl:= SYSTEM.pa_num_tbl_type();
578:
579: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
580:
581: IF l_debug_mode = 'Y' THEN
582: PA_DEBUG.set_curr_function(p_function => 'CREATE_REQUIREMENTS', p_debug_mode => l_debug_mode);
583: END IF;

Line 2812: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

2808: --1. Requirement_id should be passed.
2809:
2810: x_return_status := FND_API.G_RET_STS_SUCCESS;
2811:
2812: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
2813:
2814: IF l_debug_mode = 'Y' THEN
2815: PA_DEBUG.set_curr_function(p_function => 'UPDATE_REQUIREMENTS', p_debug_mode => l_debug_mode);
2816: END IF;

Line 4752: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

4748:
4749: --------------------------------------------------
4750: -- Initialize Current Function and Msg Stack
4751: --------------------------------------------------
4752: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
4753:
4754: IF l_debug_mode = 'Y' THEN
4755: PA_DEBUG.set_curr_function(p_function => 'DELETE_REQUIREMENTS', p_debug_mode => l_debug_mode);
4756: END IF;

Line 5198: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

5194: X_ASSIGNMENT_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();
5195: --------------------------------------------------
5196: -- Initialize Current Function and Msg Stack
5197: --------------------------------------------------
5198: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
5199:
5200: IF l_debug_mode = 'Y' THEN
5201: PA_DEBUG.set_curr_function(p_function => 'STAFF_REQUIREMENTS', p_debug_mode => l_debug_mode);
5202: END IF;

Line 5836: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

5832: X_REQ_ASGN_ID_TBL := SYSTEM.PA_NUM_TBL_TYPE();
5833: --------------------------------------------------
5834: -- Initialize Current Function and Msg Stack
5835: --------------------------------------------------
5836: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
5837:
5838: IF l_debug_mode = 'Y' THEN
5839: PA_DEBUG.set_curr_function(p_function => 'COPY_TEAM_ROLES', p_debug_mode => l_debug_mode);
5840: END IF;

Line 6389: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

6385:
6386: x_return_status := FND_API.G_RET_STS_SUCCESS;
6387: x_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
6388:
6389: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
6390:
6391: IF l_debug_mode = 'Y' THEN
6392: PA_DEBUG.set_curr_function(p_function => 'CREATE_ASSIGNMENTS', p_debug_mode => l_debug_mode);
6393: END IF;

Line 7580: -- p_user_id => fnd_global.user_id

7576: --l_my_person_id := null;
7577: --l_my_resource_id := null;
7578: --l_my_resource_name := null;
7579: --PA_COMP_PROFILE_PUB.GET_USER_INFO(
7580: -- p_user_id => fnd_global.user_id
7581: -- , x_Person_id => l_my_person_id
7582: -- , x_Resource_id => l_my_resource_id
7583: -- , x_resource_name => l_my_resource_name);
7584: --IF l_debug_mode = 'Y' THEN

Line 8096: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

8092: x_msg_data := NULL ;
8093: --------------------------------------------------
8094: -- Initialize Current Function and Msg Stack
8095: --------------------------------------------------
8096: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
8097:
8098: IF l_debug_mode = 'Y' THEN
8099: PA_DEBUG.set_curr_function(p_function => 'UPDATE_ASSIGNMENTS', p_debug_mode => l_debug_mode);
8100: END IF;

Line 9733: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

9729: BEGIN
9730:
9731: x_return_status := FND_API.G_RET_STS_SUCCESS;
9732:
9733: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
9734:
9735: IF l_debug_mode = 'Y' THEN
9736: PA_DEBUG.set_curr_function(p_function => 'DELETE_ASSIGNMENTS', p_debug_mode => l_debug_mode);
9737: END IF;

Line 10265: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

10261:
10262: --------------------------------------------------
10263: -- Initialize Current Function and Msg Stack
10264: --------------------------------------------------
10265: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10266:
10267: IF l_debug_mode = 'Y' THEN
10268: PA_DEBUG.set_curr_function(p_function => 'SUBMIT_ASSIGNMENTS', p_debug_mode => l_debug_mode);
10269: END IF;

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

10925: x_return_status := FND_API.G_RET_STS_SUCCESS;
10926:
10927: x_competence_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10928:
10929: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
10930:
10931:
10932: IF l_debug_mode = 'Y' THEN
10933: PA_DEBUG.set_curr_function(p_function => 'CREATE_REQUIREMENT_COMPETENCE', p_debug_mode => l_debug_mode);

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

11508:
11509:
11510: x_return_status := FND_API.G_RET_STS_SUCCESS;
11511:
11512: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
11513:
11514: IF l_debug_mode = 'Y' THEN
11515: PA_DEBUG.set_curr_function(p_function => 'UPDATE_REQUIREMENT_COMPETENCE', p_debug_mode => l_debug_mode);
11516: END IF;

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

12080: -- competence Name.
12081:
12082: x_return_status := FND_API.G_RET_STS_SUCCESS;
12083:
12084: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
12085:
12086: IF l_debug_mode = 'Y' THEN
12087: PA_DEBUG.set_curr_function(p_function => 'DELETE_REQUIREMENT_COMPETENCE', p_debug_mode => l_debug_mode);
12088: END IF;

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

12594:
12595: x_return_status := FND_API.G_RET_STS_SUCCESS;
12596: x_candidate_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
12597:
12598: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
12599:
12600: IF l_debug_mode = 'Y' THEN
12601: PA_DEBUG.set_curr_function(p_function => 'CREATE_CANDIDATES', p_debug_mode => l_debug_mode);
12602: END IF;

Line 12657: l_project_super_user := FND_PROFILE.value_specific('PA_SUPER_PROJECT',fnd_global.user_id,fnd_global.login_id,275,null,null);

12653: --IF l_prm_license_flag <> 'Y' THEN
12654: -- null;
12655: --END IF;
12656:
12657: l_project_super_user := FND_PROFILE.value_specific('PA_SUPER_PROJECT',fnd_global.user_id,fnd_global.login_id,275,null,null);
12658:
12659: i := p_candidate_in_tbl.first;
12660:
12661: WHILE i is not NULL LOOP

Line 12851: OPEN c_get_person_id(FND_GLOBAL.USER_ID);

12847: IF l_debug_mode = 'Y' THEN
12848: pa_debug.write(l_module, 'If not project super user then check for confirmed assignment', l_log_level);
12849: END IF;
12850:
12851: OPEN c_get_person_id(FND_GLOBAL.USER_ID);
12852: FETCH c_get_person_id INTO l_logged_person_id;
12853: CLOSE c_get_person_id;
12854:
12855: IF l_logged_person_id <> l_person_id THEN

Line 13192: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

13188: --1. Validations like new status_code acceptable or not are done by underlying called apis.
13189:
13190: x_return_status := FND_API.G_RET_STS_SUCCESS;
13191:
13192: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
13193:
13194: IF l_debug_mode = 'Y' THEN
13195: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CANDIDATES', p_debug_mode => l_debug_mode);
13196: END IF;

Line 13685: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

13681: --2. Either all or none of the candidates would be deleted for the specified requirement_id.
13682:
13683: x_return_status := FND_API.G_RET_STS_SUCCESS;
13684:
13685: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
13686:
13687: IF l_debug_mode = 'Y' THEN
13688: PA_DEBUG.set_curr_function(p_function => 'DELETE_CANDIDATES', p_debug_mode => l_debug_mode);
13689: END IF;

Line 14146: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');

14142:
14143: x_return_status := FND_API.G_RET_STS_SUCCESS;
14144: x_candidate_review_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
14145:
14146: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
14147:
14148: IF l_debug_mode = 'Y' THEN
14149: PA_DEBUG.set_curr_function(p_function => 'CREATE_CANDIDATE_LOG', p_debug_mode => l_debug_mode);
14150: END IF;