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 2811: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

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

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

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

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

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

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

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

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

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

Line 7578: -- p_user_id => fnd_global.user_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 12849: OPEN c_get_person_id(FND_GLOBAL.USER_ID);

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

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

13167: --1. Validations like new status_code acceptable or not are done by underlying called apis.
13168:
13169: x_return_status := FND_API.G_RET_STS_SUCCESS;
13170:
13171: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
13172:
13173: IF l_debug_mode = 'Y' THEN
13174: PA_DEBUG.set_curr_function(p_function => 'UPDATE_CANDIDATES', p_debug_mode => l_debug_mode);
13175: END IF;

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

13643: --2. Either all or none of the candidates would be deleted for the specified requirement_id.
13644:
13645: x_return_status := FND_API.G_RET_STS_SUCCESS;
13646:
13647: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
13648:
13649: IF l_debug_mode = 'Y' THEN
13650: PA_DEBUG.set_curr_function(p_function => 'DELETE_CANDIDATES', p_debug_mode => l_debug_mode);
13651: END IF;

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

14104:
14105: x_return_status := FND_API.G_RET_STS_SUCCESS;
14106: x_candidate_review_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
14107:
14108: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.login_id, 275, null, null), 'N');
14109:
14110: IF l_debug_mode = 'Y' THEN
14111: PA_DEBUG.set_curr_function(p_function => 'CREATE_CANDIDATE_LOG', p_debug_mode => l_debug_mode);
14112: END IF;