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 4602: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4598:
4599: IF l_return_status = 'E' THEN -- This API returns 'E' if Structure Type is Enabled
4600:
4601: IF p_function = 'DEMAND' THEN
4602: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4603: P_PROJECT_ID => l_project_id_tbl(l_count)
4604: ,P_Task_ID => null
4605: ,P_Init_Msg_List => l_init_msg_list
4606: ,X_RETURN_STATUS => l_return_status

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

4607: ,X_MSG_COUNT => l_msg_count
4608: ,X_MSG_DATA => l_msg_data
4609: );
4610: IF l_debug_mode = 'Y' THEN
4611: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status ;
4612: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4613: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4614: END IF;
4615:

Line 4620: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4616: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4617: RAISE Invalid_Arg_Exc_Dlv ;
4618: END IF ;
4619: ELSIF p_function = 'PROCUREMENT' THEN
4620: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4621: P_PROJECT_ID => l_project_id_tbl(l_count)
4622: ,P_Task_ID => null
4623: ,P_Init_Msg_List => l_init_msg_list
4624: ,X_RETURN_STATUS => l_return_status

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

4625: ,X_MSG_COUNT => l_msg_count
4626: ,X_MSG_DATA => l_msg_data
4627: );
4628: IF l_debug_mode = 'Y' THEN
4629: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4630: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4631: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4632: END IF;
4633:

Line 4639: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4635: RAISE Invalid_Arg_Exc_Dlv ;
4636: END IF ;
4637:
4638: ELSIF p_function = 'BOTH' THEN
4639: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4640: P_PROJECT_ID => l_project_id_tbl(l_count)
4641: ,P_Task_ID => null
4642: ,P_Init_Msg_List => l_init_msg_list
4643: ,X_RETURN_STATUS => l_return_status

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

4644: ,X_MSG_COUNT => l_msg_count
4645: ,X_MSG_DATA => l_msg_data
4646: );
4647: IF l_debug_mode = 'Y' THEN
4648: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4649: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4650: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4651: END IF;
4652:

Line 4656: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4652:
4653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4654: RAISE Invalid_Arg_Exc_Dlv ;
4655: END IF ;
4656: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4657: P_PROJECT_ID => l_project_id_tbl(l_count)
4658: ,P_Task_ID => null
4659: ,P_Init_Msg_List => l_init_msg_list
4660: ,X_RETURN_STATUS => l_return_status

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

4661: ,X_MSG_COUNT => l_msg_count
4662: ,X_MSG_DATA => l_msg_data
4663: );
4664: IF l_debug_mode = 'Y' THEN
4665: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4666: pa_debug.g_err_stage := pa_debug.g_err_stage || ' for project id '||l_project_id_tbl(l_count) ;
4667: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4668: END IF;
4669:

Line 4698: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4694: pa_debug.g_err_stage := 'Selected Option is Initiate Demand(project_id is null)';
4695: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4696: END IF;
4697:
4698: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4699: P_PROJECT_ID => null
4700: ,P_Task_ID => null
4701: ,P_Init_Msg_List => l_init_msg_list
4702: ,X_RETURN_STATUS => l_return_status

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

4703: ,X_MSG_COUNT => l_msg_count
4704: ,X_MSG_DATA => l_msg_data
4705: );
4706: IF l_debug_mode = 'Y' THEN
4707: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4708: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4709: END IF;
4710:
4711: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4721: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4717: IF l_debug_mode = 'Y' THEN
4718: pa_debug.g_err_stage := 'Selected Option is Initiate Procurement(project_id is null)';
4719: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4720: END IF;
4721: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4722: P_PROJECT_ID => null
4723: ,P_Task_ID => null
4724: ,P_Init_Msg_List => l_init_msg_list
4725: ,X_RETURN_STATUS => l_return_status

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

4726: ,X_MSG_COUNT => l_msg_count
4727: ,X_MSG_DATA => l_msg_data
4728: );
4729: IF l_debug_mode = 'Y' THEN
4730: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4731: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4732: END IF;
4733:
4734:

Line 4745: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(

4741: pa_debug.g_err_stage := 'Selected Option is All(project_id is null)';
4742: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4743: END IF;
4744:
4745: OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS(
4746: P_PROJECT_ID => null
4747: ,P_Task_ID => null
4748: ,P_Init_Msg_List => l_init_msg_list
4749: ,X_RETURN_STATUS => l_return_status

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

4750: ,X_MSG_COUNT => l_msg_count
4751: ,X_MSG_DATA => l_msg_data
4752: );
4753: IF l_debug_mode = 'Y' THEN
4754: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_MDS returned status :' || l_return_status;
4755: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4756: END IF;
4757:
4758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4762: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(

4758: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4759: RAISE Invalid_Arg_Exc_Dlv ;
4760: END IF ;
4761:
4762: OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ(
4763: P_PROJECT_ID => null
4764: ,P_Task_ID => null
4765: ,P_Init_Msg_List => l_init_msg_list
4766: ,X_RETURN_STATUS => l_return_status

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

4768: ,X_MSG_DATA => l_msg_data
4769: );
4770:
4771: IF l_debug_mode = 'Y' THEN
4772: pa_debug.g_err_stage := 'OKE_DELIVERABLE_UTILS_PUB.BATCH_REQ returned status :' || l_return_status;
4773: pa_debug.write_file('RUN_ACTION_CONC_PROCESS :' || pa_debug.g_err_stage);
4774: END IF;
4775:
4776: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN