[Home] [Help]
670: -- Standard begin of API savepoint
671:
672: SAVEPOINT create_project_pub;
673:
674: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
675: -- Standard call to check for call compatibility.
676:
677:
678: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
10626: END IF;
10627:
10628: p_return_status := FND_API.G_RET_STS_SUCCESS;
10629:
10630: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10631:
10632: --
10633: -- If structure_version_id has been provided
10634: -- check to see if this version is updatable
12885:
12886: --Added for bug 5745545
12887: IF nvl(p_project_in.work_type_id,-999) <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
12888:
12889: IF (nvl(fnd_profile.value('PA_EN_NEW_WORK_TYPE_PROCESS'),'N') = 'Y') OR (nvl(pa_install.is_prm_licensed(),'N') = 'Y' ) THEN
12890:
12891: IF p_project_in.work_type_id IS NULL AND (NOT (PA_GMS_API.vert_install)) THEN
12892:
12893: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
28445: -- Standard begin of API savepoint.
28446:
28447: savepoint APPLY_LP_PROG_ON_CWV;
28448:
28449: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
28450:
28451: -- Standard call to check for call compatibility.
28452:
28453: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
31602: l_project_id NUMBER;
31603: l_function_allowed VARCHAR2(1);
31604: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
31605:
31606: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
31607: l_msg_index_out NUMBER;
31608: l_msg_count NUMBER ;
31609: l_data VARCHAR2(2000);
31610: l_msg_data VARCHAR2(2000);
31857: )
31858:
31859: IS
31860: l_api_name VARCHAR2(30) := 'Delete_Deliverable_Actions';
31861: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
31862:
31863: l_project_id NUMBER ;
31864: l_action_id NUMBER;
31865: l_action_version_id NUMBER;
32163: l_deliverable_id NUMBER;
32164: l_dlvr_version_id NUMBER;
32165: l_function_code Pa_Proj_Elements.function_code%TYPE;
32166: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32167: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32168:
32169: l_function_allowed VARCHAR2(1);
32170: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32171:
33363: -- IF (p_commit = FND_API.G_TRUE) THEN
33364: savepoint DELETE_MAPPING_PUB;
33365: -- END IF;
33366:
33367: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
33368: IF l_debug_mode = 'Y' THEN
33369: PA_DEBUG.set_curr_function( p_function => 'DELETE_MAPPING',
33370: p_debug_mode => l_debug_mode );
33371: END IF;
33648: IF (p_commit = FND_API.G_TRUE) THEN
33649: savepoint CREATE_MAPPING_PUB;
33650: END IF;
33651:
33652: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
33653: IF l_debug_mode = 'Y' THEN
33654: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',
33655: p_debug_mode => l_debug_mode );
33656: END IF;
34010: IF (p_commit = FND_API.G_TRUE) THEN
34011: savepoint UPDATE_MAPPING_PUB;
34012: END IF;
34013:
34014: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
34015: IF l_debug_mode = 'Y' THEN
34016: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',
34017: p_debug_mode => l_debug_mode );
34018: END IF;
34326: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
34327: FND_MSG_PUB.initialize;
34328: END IF;
34329:
34330: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
34331: IF l_debug_mode = 'Y' THEN
34332: PA_DEBUG.set_curr_function( p_function => 'PROCESS_TASK_TABLE',
34333: p_debug_mode => l_debug_mode );
34334: END IF;