DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_DELIVERABLE_UTILS

Line 5340: Pa_Deliverable_Utils.enable_deliverable(

5336:
5337: i := p_deliverables_in.first();
5338:
5339: IF ( G_DLVR_STRUCTURE_ENABLED = 'Y' ) THEN
5340: Pa_Deliverable_Utils.enable_deliverable(
5341: p_api_version => p_api_version_number
5342: , p_init_msg_list => FND_API.G_FALSE
5343: , p_commit => FND_API.G_FALSE--bug 3766967
5344: , p_debug_mode => l_debug_mode

Line 7542: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

7538:
7539: IF ( ( p_deliverable_id IS NOT NULL AND p_deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) OR
7540: ( p_deliverable IS NOT NULL AND p_deliverable <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
7541:
7542: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
7543: ( p_deliverable_reference => p_deliverable
7544: , p_deliverable_id => p_deliverable_id
7545: , p_project_id => l_project_id
7546: , p_out_deliverable_id => l_deliverable_id

Line 22067: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

22063: -- then call below api to validate reference and id
22064:
22065: IF p_deliverables_in(i).deliverable_id IS NOT NULL AND p_deliverables_in(i).deliverable_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
22066:
22067: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
22068: ( p_deliverable_reference => p_deliverables_in(i).pm_deliverable_reference
22069: , p_deliverable_id => p_deliverables_in(i).deliverable_id
22070: , p_project_id => l_project_id
22071: , p_out_deliverable_id => l_deliverable_id

Line 22097: pa_deliverable_utils.is_dlvr_reference_unique (

22093: l_dlvr_dml_action := G_UPDATE_MODE;
22094: ELSE
22095: -- Bug 3651538 Moved the call of api from outside IF condition to inside else part
22096: -- as need to check for reference uniqueness only if ID is not passed.
22097: pa_deliverable_utils.is_dlvr_reference_unique (
22098: p_deliverable_reference => p_deliverables_in(i).pm_deliverable_reference
22099: , p_project_id => l_project_id
22100: , x_unique_flag => l_unique_flag
22101: , x_return_status => x_return_status );

Line 30289: PA_Deliverable_Utils.is_dlvr_reference_unique(

30285:
30286: END IF;
30287:
30288: -- Validate Deliverable reference - not null, unique
30289: PA_Deliverable_Utils.is_dlvr_reference_unique(
30290: p_deliverable_reference => p_pm_deliverable_reference
30291: , p_project_id => l_project_id
30292: , x_unique_flag => l_unique_flag
30293: , x_return_status => x_return_status );

Line 30367: Pa_Deliverable_Utils.enable_deliverable(

30363: END IF;
30364:
30365: IF ( l_dlvr_enabled = 'N' ) THEN
30366:
30367: Pa_Deliverable_Utils.enable_deliverable(
30368: p_api_version => p_api_version
30369: , p_init_msg_list => FND_API.G_FALSE
30370: , p_commit => p_commit
30371: , p_debug_mode => p_debug_mode

Line 30380: pa_debug.write(g_pkg_name,'Pa_Deliverable_Utils.enable_deliverable Return Status ['||x_return_status||']',3) ;

30376: , x_msg_data => x_msg_data
30377: );
30378:
30379: IF p_debug_mode = 'Y' THEN
30380: pa_debug.write(g_pkg_name,'Pa_Deliverable_Utils.enable_deliverable Return Status ['||x_return_status||']',3) ;
30381: END IF;
30382:
30383: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
30384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 30401: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_OWNER

30397: -- here in defaulting , considered only project flow
30398: -- task flow is not considered and passing task ver id as NULL
30399:
30400: IF p_deliverable_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
30401: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_OWNER
30402: (
30403: p_project_id => p_project_id
30404: ,p_task_ver_id => NULL
30405: ,x_owner_id => l_dlvr_owner_id

Line 30413: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_DATE

30409: l_dlvr_owner_id := p_deliverable_owner_id;
30410: END IF;
30411:
30412: IF p_due_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
30413: PA_DELIVERABLE_UTILS.GET_DEFAULT_DLVR_DATE
30414: (
30415: p_project_id => p_project_id
30416: ,p_task_ver_id => NULL
30417: ,x_due_date => l_default_date

Line 30492: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO

30488: END IF;
30489: -- Will create actions only when deliverable type of deliverable
30490: -- has action creation enabled.
30491:
30492: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO
30493: (
30494: p_dlvr_type_id => p_deliverable_type_id
30495: ,x_dlvr_prg_enabled => l_dlvr_prg_enabled
30496: ,x_dlvr_action_enabled => l_dlvr_action_enabled

Line 30881: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(

30877: RAISE FND_API.G_EXC_ERROR;
30878: END IF;
30879:
30880: -- Validate Deliverable reference / ID
30881: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(
30882: p_deliverable_reference => p_deliverable_reference
30883: , p_deliverable_id => p_deliverable_id
30884: , p_project_id => l_project_id
30885: , p_out_deliverable_id => l_deliverable_id

Line 30922: pa_deliverable_utils.is_action_reference_unique (

30918:
30919: END IF;
30920:
30921: -- Validate Action reference - not null, unique
30922: pa_deliverable_utils.is_action_reference_unique (
30923: p_action_reference => p_pm_action_reference
30924: , p_deliverable_id => l_deliverable_id
30925: , p_project_id => l_project_id
30926: , x_unique_flag => l_unique_flag

Line 30952: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO

30948:
30949: -- Will create actions only when deliverable type of deliverable
30950: -- has action creation enabled.
30951:
30952: Pa_Deliverable_Utils.GET_DLVR_TYPE_INFO
30953: (
30954: p_dlvr_type_id => l_dlvr_type_id
30955: ,x_dlvr_prg_enabled => l_dlvr_prg_enabled
30956: ,x_dlvr_action_enabled => l_dlvr_action_enabled

Line 31427: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

31423: END IF;
31424: END IF;
31425:
31426: -- Validate Deliverable reference / id- not null, unique
31427: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
31428: ( p_deliverable_reference => p_pm_deliverable_reference
31429: , p_deliverable_id => px_deliverable_id
31430: , p_project_id => l_project_id
31431: , p_out_deliverable_id => l_deliverable_id

Line 31538: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

31534:
31535: -- deriving deliverable id from deliverable reference
31536:
31537: IF i IS NOT NULL THEN
31538: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
31539: ( p_deliverable_reference => p_action_in_tbl(i).pm_deliverable_reference
31540: , p_deliverable_id => p_action_in_tbl(i).deliverable_id
31541: , p_project_id => l_project_id
31542: , p_out_deliverable_id => l_dlvr_id

Line 31573: Pa_Deliverable_Utils.Convert_pm_actionref_to_id (

31569: -- if action id not null, then and only then , action reference to id validation should be done
31570: -- in case of new action below validon will fail and will not allow user to create new actions from update_deliverable
31571:
31572: IF l_action_id IS NOT NULL THEN
31573: Pa_Deliverable_Utils.Convert_pm_actionref_to_id (
31574: p_action_reference => p_action_in_tbl(i_actn).pm_action_reference
31575: ,p_action_id => l_action_id
31576: ,p_deliverable_id => l_deliverable_id
31577: ,p_project_id => l_Project_id

Line 31960: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(

31956: RAISE FND_API.G_EXC_ERROR;
31957: END IF;
31958:
31959: -- Validate Deliverable reference / ID
31960: PA_Deliverable_Utils.Convert_pm_dlvrref_to_id(
31961: p_deliverable_reference => p_deliverable_reference
31962: , p_deliverable_id => p_deliverable_id
31963: , p_project_id => l_project_id
31964: , p_out_deliverable_id => l_deliverable_id

Line 31979: PA_Deliverable_Utils.Convert_pm_actionref_to_id(

31975: END IF;
31976:
31977:
31978: -- 3729250 Validate Deliverable Action reference / ID
31979: PA_Deliverable_Utils.Convert_pm_actionref_to_id(
31980: p_action_reference => p_pm_action_reference
31981: , p_action_id => p_action_id
31982: , p_deliverable_id => l_deliverable_id
31983: , p_project_id => l_project_id

Line 32306: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32302: RAISE FND_API.G_EXC_ERROR;
32303: END IF;
32304:
32305: -- Validate Deliverable Reference / ID
32306: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32307: ( p_deliverable_reference => p_pm_dlv_source_reference
32308: -- for bug# 3729250
32309: , p_deliverable_id => p_deliverable_id
32310: , p_project_id => l_project_id

Line 32326: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32322: RAISE FND_API.G_EXC_ERROR;
32323: END IF;
32324:
32325: -- Derive deliverable version ID and call api Delete Deliverable. It
32326: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32327:
32328: IF l_debug_mode = 'Y' THEN
32329: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
32330: END IF;

Line 32579: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32575: RAISE FND_API.G_EXC_ERROR;
32576: END IF;
32577:
32578: -- Validate Deliverable Reference / ID
32579: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32580: ( p_deliverable_reference => p_pm_deliverable_reference
32581: , p_deliverable_id => p_deliverable_id
32582: , p_project_id => l_project_id
32583: , p_out_deliverable_id => l_deliverable_id

Line 32598: Pa_Deliverable_Utils.Convert_pm_actionref_to_id

32594: RAISE FND_API.G_EXC_ERROR;
32595: END IF;
32596:
32597: -- Validate Action Reference / ID
32598: Pa_Deliverable_Utils.Convert_pm_actionref_to_id
32599: (
32600: p_action_reference => p_action_source_reference
32601: ,p_action_id => p_action_id
32602: ,p_deliverable_id => l_deliverable_id -- 3749480 earlier p_deliverable_id was used

Line 32619: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32615: RAISE FND_API.G_EXC_ERROR;
32616: END IF;
32617:
32618: -- Derive Deliverable_version_id
32619: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32620:
32621: IF l_debug_mode = 'Y' THEN
32622: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
32623: END IF;

Line 32626: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;

32622: pa_debug.write(g_pkg_name,'Derived Dlvr Version ID ['||l_dlvr_version_id||'] for Dlvr ID['||l_deliverable_id||']',3) ;
32623: END IF;
32624:
32625: -- Derive Action_version_id and Function Code
32626: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;
32627: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;
32628:
32629: IF l_debug_mode = 'Y' THEN
32630: pa_debug.write(g_pkg_name,'Derived Action version ID ['||l_action_version_id||']and function code ['||l_function_code||']',3) ;

Line 32627: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;

32623: END IF;
32624:
32625: -- Derive Action_version_id and Function Code
32626: l_action_version_id := Pa_Deliverable_Utils.Get_Action_Version_Id (l_action_id, null, l_project_id) ;
32627: l_function_code := Pa_Deliverable_Utils.GET_FUNCTION_CODE(l_action_id) ;
32628:
32629: IF l_debug_mode = 'Y' THEN
32630: pa_debug.write(g_pkg_name,'Derived Action version ID ['||l_action_version_id||']and function code ['||l_function_code||']',3) ;
32631: END IF;

Line 32873: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

32869: RAISE FND_API.G_EXC_ERROR;
32870: END IF;
32871:
32872: -- Validate Deliverable Reference / ID
32873: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
32874: ( p_deliverable_reference => p_pm_deliverable_reference
32875: , p_deliverable_id => p_deliverable_id
32876: , p_project_id => l_project_id
32877: , p_out_deliverable_id => l_deliverable_id

Line 32918: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

32914: END IF;
32915:
32916:
32917: -- Derive Deliverable_version_id
32918: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32919:
32920: -- Derive Object Relationship ID
32921: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);
32922:

Line 32921: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);

32917: -- Derive Deliverable_version_id
32918: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
32919:
32920: -- Derive Object Relationship ID
32921: l_object_relationship_id := Pa_Deliverable_Utils.Get_Dlvr_Task_Asscn_ID(l_deliverable_id, l_task_id);
32922:
32923: -- Calling deliverable api to Delete Association
32924: pa_deliverable_pub.DELETE_DLV_TASK_ASSOCIATION
32925: (p_api_version => p_api_version

Line 33162: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

33158: RAISE FND_API.G_EXC_ERROR;
33159: END IF;
33160:
33161: -- Validate Deliverable Reference / ID
33162: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
33163: ( p_deliverable_reference => p_deliverable_reference -- 3729250, earlier null was passed
33164: , p_deliverable_id => p_deliverable_id
33165: , p_project_id => l_project_id
33166: , p_out_deliverable_id => l_deliverable_id

Line 33217: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

33213:
33214: -- 5462298 end
33215:
33216: -- Derive Deliverable_version_id
33217: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
33218:
33219: -- Calling deliverable api to Create Association
33220: pa_deliverable_pvt.CREATE_DLV_TASK_ASSOCIATION
33221: (p_api_version => p_api_version

Line 33449: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

33445: RAISE FND_API.G_EXC_ERROR;
33446: END IF;
33447:
33448: -- Validate Deliverable Reference / ID
33449: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
33450: ( p_deliverable_reference => p_deliverable_reference -- 3729250 , earlier passed was null
33451: , p_deliverable_id => p_deliverable_id
33452: , p_project_id => l_project_id
33453: , p_out_deliverable_id => l_deliverable_id

Line 33497: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;

33493: RAISE FND_API.G_EXC_ERROR;
33494: END IF;
33495:
33496: -- Derive Deliverable_version_id
33497: l_dlvr_version_id := Pa_Deliverable_Utils.Get_Deliverable_Version_Id (l_deliverable_id, null, l_project_id) ;
33498:
33499: -- Calling deliverable api to Create Association
33500: pa_deliverable_pvt.CREATE_DLV_TASK_ASSOCIATION
33501: (p_api_version => p_api_version

Line 33767: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id

33763: -- 3888280 start
33764: -- Added code to validate Deliverable Reference and Id
33765:
33766: -- Validate Deliverable Reference / ID
33767: Pa_Deliverable_Utils.Convert_pm_dlvrref_to_id
33768: ( p_deliverable_reference => p_pm_deliverable_reference
33769: , p_deliverable_id => p_deliverable_id
33770: , p_project_id => l_project_id
33771: , p_out_deliverable_id => l_deliverable_id