eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTIONS_PUB dependencies on OKE_DELIVERABLE_UTILS_PUB

Line 1589: l_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(p_object_version_id),'N') ;

1585: l_is_dlv_itembased := nvl(PA_DELIVERABLE_UTILS.IS_DLV_ITEM_BASED(p_element_version_id_tbl(1)),'N');
1586: END IF;
1587:
1588: l_dlv_type_class_code := nvl(PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_object_version_id),'N') ;
1589: l_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(p_object_version_id),'N') ;
1590: l_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(p_object_version_id),'N') ;
1591: l_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(p_object_version_id),'N') ;
1592: l_item_defined := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_object_version_id),'N') ;
1593: END IF ;

Line 1590: l_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(p_object_version_id),'N') ;

1586: END IF;
1587:
1588: l_dlv_type_class_code := nvl(PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_object_version_id),'N') ;
1589: l_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(p_object_version_id),'N') ;
1590: l_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(p_object_version_id),'N') ;
1591: l_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(p_object_version_id),'N') ;
1592: l_item_defined := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_object_version_id),'N') ;
1593: END IF ;
1594:

Line 1591: l_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(p_object_version_id),'N') ;

1587:
1588: l_dlv_type_class_code := nvl(PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_object_version_id),'N') ;
1589: l_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(p_object_version_id),'N') ;
1590: l_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(p_object_version_id),'N') ;
1591: l_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(p_object_version_id),'N') ;
1592: l_item_defined := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_object_version_id),'N') ;
1593: END IF ;
1594:
1595: -- Do the locking part here in update and delete mode

Line 1592: l_item_defined := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_object_version_id),'N') ;

1588: l_dlv_type_class_code := nvl(PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_object_version_id),'N') ;
1589: l_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(p_object_version_id),'N') ;
1590: l_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(p_object_version_id),'N') ;
1591: l_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(p_object_version_id),'N') ;
1592: l_item_defined := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_object_version_id),'N') ;
1593: END IF ;
1594:
1595: -- Do the locking part here in update and delete mode
1596:

Line 1880: l_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;

1876: --Initialize local var for each action
1877: l_shipping_initiated := 'N' ;
1878: l_ready_to_ship := 'N' ;
1879:
1880: l_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;
1881: l_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(p_element_version_id_tbl(i)),'N');
1882:
1883: -- Validation 3.1
1884: IF ( l_shipping_initiated = 'N'

Line 1881: l_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(p_element_version_id_tbl(i)),'N');

1877: l_shipping_initiated := 'N' ;
1878: l_ready_to_ship := 'N' ;
1879:
1880: l_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;
1881: l_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(p_element_version_id_tbl(i)),'N');
1882:
1883: -- Validation 3.1
1884: IF ( l_shipping_initiated = 'N'
1885: AND nvl(p_completed_flag_tbl(i),'N') = 'Y' )

Line 1955: l_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;

1951: l_proc_initiated := 'N' ;
1952: l_ready_to_proc := 'N' ;
1953:
1954: -- 3555460 WSH_Initiated_Yn function call was used instead of REQ_Initiated_Yn
1955: l_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;
1956: l_ready_to_proc := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(p_element_version_id_tbl(i)),'N') ;
1957:
1958: -- Validation 4.1
1959: IF (l_proc_initiated = 'N' AND

Line 1956: l_ready_to_proc := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(p_element_version_id_tbl(i)),'N') ;

1952: l_ready_to_proc := 'N' ;
1953:
1954: -- 3555460 WSH_Initiated_Yn function call was used instead of REQ_Initiated_Yn
1955: l_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(p_element_version_id_tbl(i)),'N') ;
1956: l_ready_to_proc := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(p_element_version_id_tbl(i)),'N') ;
1957:
1958: -- Validation 4.1
1959: IF (l_proc_initiated = 'N' AND
1960: nvl(p_completed_flag_tbl(i),'N') = 'Y' )

Line 4533: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4529:
4530: IF l_return_status = 'E' THEN -- This API returns 'E' if Structure Type is Enabled
4531:
4532: IF p_function = 'DEMAND' THEN
4533: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4534: P_PROJECT_ID => l_project_id_tbl(l_count)
4535: ,P_Task_ID => null
4536: ,P_Init_Msg_List => l_init_msg_list
4537: ,X_RETURN_STATUS => l_return_status

Line 4542: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status ;

4538: ,X_MSG_COUNT => l_msg_count
4539: ,X_MSG_DATA => l_msg_data
4540: );
4541: IF l_debug_mode = 'Y' THEN
4542: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status ;
4543: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4544: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4545: END IF;
4546:

Line 4551: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4548: RAISE Invalid_Arg_Exc_Dlv ;
4549: END IF ;
4550: ELSIF p_function = 'PROCUREMENT' THEN
4551: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4552: P_PROJECT_ID => l_project_id_tbl(l_count)
4553: ,P_Task_ID => null
4554: ,P_Init_Msg_List => l_init_msg_list
4555: ,X_RETURN_STATUS => l_return_status

Line 4560: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;

4556: ,X_MSG_COUNT => l_msg_count
4557: ,X_MSG_DATA => l_msg_data
4558: );
4559: IF l_debug_mode = 'Y' THEN
4560: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4561: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4562: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4563: END IF;
4564:

Line 4570: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4566: RAISE Invalid_Arg_Exc_Dlv ;
4567: END IF ;
4568:
4569: ELSIF p_function = 'BOTH' THEN
4570: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4571: P_PROJECT_ID => l_project_id_tbl(l_count)
4572: ,P_Task_ID => null
4573: ,P_Init_Msg_List => l_init_msg_list
4574: ,X_RETURN_STATUS => l_return_status

Line 4579: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;

4575: ,X_MSG_COUNT => l_msg_count
4576: ,X_MSG_DATA => l_msg_data
4577: );
4578: IF l_debug_mode = 'Y' THEN
4579: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4580: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4581: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4582: END IF;
4583:

Line 4587: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4583:
4584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4585: RAISE Invalid_Arg_Exc_Dlv ;
4586: END IF ;
4587: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4588: P_PROJECT_ID => l_project_id_tbl(l_count)
4589: ,P_Task_ID => null
4590: ,P_Init_Msg_List => l_init_msg_list
4591: ,X_RETURN_STATUS => l_return_status

Line 4596: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;

4592: ,X_MSG_COUNT => l_msg_count
4593: ,X_MSG_DATA => l_msg_data
4594: );
4595: IF l_debug_mode = 'Y' THEN
4596: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4597: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4598: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4599: END IF;
4600:

Line 4629: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4625: pa_debug.g_err_stage := 'Selected Option is Initiate Demand(project_id is null)';
4626: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4627: END IF;
4628:
4629: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4630: P_PROJECT_ID => null
4631: ,P_Task_ID => null
4632: ,P_Init_Msg_List => l_init_msg_list
4633: ,X_RETURN_STATUS => l_return_status

Line 4638: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;

4634: ,X_MSG_COUNT => l_msg_count
4635: ,X_MSG_DATA => l_msg_data
4636: );
4637: IF l_debug_mode = 'Y' THEN
4638: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4639: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4640: END IF;
4641:
4642: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4652: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4648: IF l_debug_mode = 'Y' THEN
4649: pa_debug.g_err_stage := 'Selected Option is Initiate Procurement(project_id is null)';
4650: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4651: END IF;
4652: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4653: P_PROJECT_ID => null
4654: ,P_Task_ID => null
4655: ,P_Init_Msg_List => l_init_msg_list
4656: ,X_RETURN_STATUS => l_return_status

Line 4661: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;

4657: ,X_MSG_COUNT => l_msg_count
4658: ,X_MSG_DATA => l_msg_data
4659: );
4660: IF l_debug_mode = 'Y' THEN
4661: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4662: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4663: END IF;
4664:
4665:

Line 4676: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4672: pa_debug.g_err_stage := 'Selected Option is All(project_id is null)';
4673: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4674: END IF;
4675:
4676: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4677: P_PROJECT_ID => null
4678: ,P_Task_ID => null
4679: ,P_Init_Msg_List => l_init_msg_list
4680: ,X_RETURN_STATUS => l_return_status

Line 4685: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;

4681: ,X_MSG_COUNT => l_msg_count
4682: ,X_MSG_DATA => l_msg_data
4683: );
4684: IF l_debug_mode = 'Y' THEN
4685: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4686: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4687: END IF;
4688:
4689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4693: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4689: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4690: RAISE Invalid_Arg_Exc_Dlv ;
4691: END IF ;
4692:
4693: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4694: P_PROJECT_ID => null
4695: ,P_Task_ID => null
4696: ,P_Init_Msg_List => l_init_msg_list
4697: ,X_RETURN_STATUS => l_return_status

Line 4703: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;

4699: ,X_MSG_DATA => l_msg_data
4700: );
4701:
4702: IF l_debug_mode = 'Y' THEN
4703: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4704: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4705: END IF;
4706:
4707: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN