DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on FND_PROFILE

Line 712: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

708: -- Standard begin of API savepoint
709:
710: SAVEPOINT create_project_pub;
711:
712: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
713: -- Standard call to check for call compatibility.
714:
715:
716: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,

Line 10920: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

10916: END IF;
10917:
10918: p_return_status := FND_API.G_RET_STS_SUCCESS;
10919:
10920: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10921:
10922: --
10923: -- If structure_version_id has been provided
10924: -- check to see if this version is updatable

Line 13209: IF (nvl(fnd_profile.value('PA_EN_NEW_WORK_TYPE_PROCESS'),'N') = 'Y') OR (nvl(pa_install.is_prm_licensed(),'N') = 'Y' ) THEN

13205:
13206: --Added for bug 5745545
13207: IF nvl(p_project_in.work_type_id,-999) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
13208:
13209: IF (nvl(fnd_profile.value('PA_EN_NEW_WORK_TYPE_PROCESS'),'N') = 'Y') OR (nvl(pa_install.is_prm_licensed(),'N') = 'Y' ) THEN
13210:
13211: IF p_project_in.work_type_id IS NULL AND (NOT (PA_GMS_API.vert_install)) THEN
13212:
13213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 29074: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

29070: -- Standard begin of API savepoint.
29071:
29072: savepoint APPLY_LP_PROG_ON_CWV;
29073:
29074: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
29075:
29076: -- Standard call to check for call compatibility.
29077:
29078: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 32231: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

32227: l_project_id NUMBER;
32228: l_function_allowed VARCHAR2(1);
32229: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32230:
32231: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32232: l_msg_index_out NUMBER;
32233: l_msg_count NUMBER ;
32234: l_data VARCHAR2(2000);
32235: l_msg_data VARCHAR2(2000);

Line 32486: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

32482: )
32483:
32484: IS
32485: l_api_name VARCHAR2(30) := 'Delete_Deliverable_Actions';
32486: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32487:
32488: l_project_id NUMBER ;
32489: l_action_id NUMBER;
32490: l_action_version_id NUMBER;

Line 32792: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

32788: l_deliverable_id NUMBER;
32789: l_dlvr_version_id NUMBER;
32790: l_function_code Pa_Proj_Elements.function_code%TYPE;
32791: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32792: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32793:
32794: l_function_allowed VARCHAR2(1);
32795: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32796:

Line 33992: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

33988: -- IF (p_commit = FND_API.G_TRUE) THEN
33989: savepoint DELETE_MAPPING_PUB;
33990: -- END IF;
33991:
33992: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
33993: IF l_debug_mode = 'Y' THEN
33994: PA_DEBUG.set_curr_function( p_function => 'DELETE_MAPPING',
33995: p_debug_mode => l_debug_mode );
33996: END IF;

Line 34277: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

34273: IF (p_commit = FND_API.G_TRUE) THEN
34274: savepoint CREATE_MAPPING_PUB;
34275: END IF;
34276:
34277: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
34278: IF l_debug_mode = 'Y' THEN
34279: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',
34280: p_debug_mode => l_debug_mode );
34281: END IF;

Line 34639: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

34635: IF (p_commit = FND_API.G_TRUE) THEN
34636: savepoint UPDATE_MAPPING_PUB;
34637: END IF;
34638:
34639: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
34640: IF l_debug_mode = 'Y' THEN
34641: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',
34642: p_debug_mode => l_debug_mode );
34643: END IF;

Line 34976: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

34972: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
34973: FND_MSG_PUB.initialize;
34974: END IF;
34975:
34976: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
34977: IF l_debug_mode = 'Y' THEN
34978: PA_DEBUG.set_curr_function( p_function => 'PROCESS_TASK_TABLE',
34979: p_debug_mode => l_debug_mode );
34980: END IF;

Line 38806: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

38802: PA_PROJECT_PUB.G_IS_SUB_PROJ_ASSOCIATED := NULL;
38803: PA_PROJECT_PUB.G_BULK_UPDATE_MODE := p_bulk_update_mode;
38804:
38805: -- Set the G_ROLLUP_FLAG based on profile options
38806: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
38807: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
38808: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
38809: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'UPDATE',l_msg_data,l_return_status);
38810: IF l_return_status <> 'S'

Line 39125: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

39121: PA_PROJECT_PUB.G_STRUC_VERSION_ID := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_project_id);
39122: PA_PROJECT_PUB.G_FP_DFF_TBL.delete;
39123:
39124: -- Set the G_ROLLUP_FLAG based on profile options
39125: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
39126: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39127: IF l_incremental_add_tasks = 'Y' THEN
39128: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'ADD',l_msg_data,l_return_status);
39129: ELSE

Line 39692: --PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

39688:
39689:
39690: -- Set the G_ROLLUP_FLAG based on profile options
39691: --IF(p_calling_module = 'AMG') THEN
39692: --PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
39693: --END IF;
39694:
39695: OPEN cur_proj_id;
39696: FETCH cur_proj_id into l_project_id;

Line 39732: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

39728: p_msg_name => 'PA_CANT_USE_LITE_API');
39729: RAISE FND_API.G_EXC_ERROR;
39730: END IF;
39731: -- Set the G_ROLLUP_FLAG based on profile options
39732: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
39733: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
39734: PA_PROJECT_PVT.CONC_LOCK_PROJECT(l_project_id,'MOVE',l_msg_data,l_return_status);
39735: IF l_return_status <> 'S'
39736: THEN

Line 40244: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

40240: END IF;
40241:
40242: -- Set the G_ROLLUP_FLAG based on profile options
40243: --IF(p_calling_module = 'AMG') THEN
40244: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
40245: --END IF;
40246:
40247: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
40248: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'INDENT',l_msg_data,l_return_status);

Line 41700: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

41696: END IF;
41697:
41698: -- Set the G_ROLLUP_FLAG based on profile options
41699: --IF(p_calling_module = 'AMG') THEN
41700: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
41701: --END IF;
41702: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
41703: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'OUTDENT',l_msg_data,l_return_status);
41704: IF l_return_status <> 'S'

Line 42917: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');

42913: PA_PROJECT_PUB.G_PROJECT_ID:=p_pa_project_id;
42914: l_structure_version_id :=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(p_pa_project_id);
42915:
42916: -- Set the G_ROLLUP_FLAG based on profile options
42917: PA_PROJECT_PUB.G_ROLLUP_DEFER:=NVL(fnd_profile.value('G_ROLLUP_DEFER'),'N');
42918: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
42919: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_pa_project_id,'DELETE',p_msg_data,p_return_status);
42920: IF p_return_status <> 'S'
42921: THEN