DBA Data[Home] [Help]

APPS.CSI_CUSTOMER_PRODUCTS_PKG dependencies on CSI_GEN_UTILITY_PVT

Line 206: -- csi_gen_utility_pvt.put_line('call Update Item instance for owner ship transfer');

202: BEGIN
203:
204: If p_block = 'ADDRESS' and nvl(p_form_mode,'!@#') = 'TRANSFER' Then
205:
206: -- csi_gen_utility_pvt.put_line('call Update Item instance for owner ship transfer');
207:
208: -- Parameters for Instance Rec
209: x_Instance_Rec.Instance_Id := NVL(P_Customer_Product_Id,FND_API.G_MISS_NUM);
210: x_Instance_rec.System_Id := NVL(P_SYSTEM_ID,FND_API.G_MISS_NUM);

Line 241: -- csi_gen_utility_pvt.put_line('call only party update');

237: x_Party_Account_Tbl(1).Object_Version_Number:= Px_IPA_Object_Version_Number;
238:
239: Elsif p_block = 'ADDRESS' and NVL(p_form_mode,'!@#') <> 'TRANSFER' Then
240:
241: -- csi_gen_utility_pvt.put_line('call only party update');
242:
243: -- Parameters for Instance Rec if Installed At Location is Updated
244: x_Instance_Rec.Instance_Id := NVL(P_Customer_Product_Id,FND_API.G_MISS_NUM);
245: x_Instance_Rec.Install_Location_Id := NVL(P_INSTALL_SITE_USE_ID,FND_API.G_MISS_NUM);

Line 438: csi_gen_utility_pvt.put_line('MRK - party Account Id '||P_IP_ACCOUNT_ID);

434: x_Pricing_Attribs_Tbl(1).pricing_attribute98 := NVL(P_PRICING_ATTRIBUTE98,FND_API.G_MISS_CHAR);
435: x_Pricing_Attribs_Tbl(1).pricing_attribute99 := NVL(P_PRICING_ATTRIBUTE99,FND_API.G_MISS_CHAR);
436: x_Pricing_Attribs_Tbl(1).pricing_attribute100 := NVL(P_PRICING_ATTRIBUTE100,FND_API.G_MISS_CHAR);
437: END IF;
438: csi_gen_utility_pvt.put_line('MRK - party Account Id '||P_IP_ACCOUNT_ID);
439: IF NOT P_IP_ACCOUNT_ID IS NULL
440: THEN
441: x_Party_Account_Tbl(1).Instance_Party_Id := NVL(P_INSTANCE_PARTY_ID,FND_API.G_MISS_NUM);
442: x_Party_Account_Tbl(1).IP_Account_Id:= P_IP_Account_ID;

Line 447: csi_gen_utility_pvt.put_line('MRK - Instance Party Id'||x_Party_Account_Tbl(1).Instance_Party_Id);

443: x_Party_Account_Tbl(1).Object_Version_Number:= Px_IPA_Object_Version_Number;
444: x_Party_Account_Tbl(1).Party_Account_Id:= NVL(P_CUSTOMER_ID,FND_API.G_MISS_NUM);
445: x_Party_Account_Tbl(1).ShiP_To_Address := NVL(P_Ship_TO_SITE_USE_ID,FND_API.G_MISS_NUM);
446: x_Party_Account_Tbl(1).Bill_To_Address := NVL(P_BILL_TO_SITE_USE_ID,FND_API.G_MISS_NUM);
447: csi_gen_utility_pvt.put_line('MRK - Instance Party Id'||x_Party_Account_Tbl(1).Instance_Party_Id);
448:
449: END IF;
450: */
451: END Convert_Cp_Prod_Param_To_Rec;

Line 827: -- csi_gen_utility_pvt.put_line('MRK - Prty Found');

823: x_asset_assignment_tbl => l_asset_assignment_tbl,
824: x_ii_relationship_rec => l_ii_relationship_rec
825: );
826:
827: -- csi_gen_utility_pvt.put_line('MRK - Prty Found');
828: l_Txn_Rec.Source_Transaction_Date := SYSDATE;
829: l_Txn_Rec.Transaction_Date := SYSDATE;
830: l_Txn_Rec.Transaction_Type_Id := Get_Txn_Type;
831:

Line 832: -- csi_gen_utility_pvt.put_line('called from here');

828: l_Txn_Rec.Source_Transaction_Date := SYSDATE;
829: l_Txn_Rec.Transaction_Date := SYSDATE;
830: l_Txn_Rec.Transaction_Type_Id := Get_Txn_Type;
831:
832: -- csi_gen_utility_pvt.put_line('called from here');
833: If p_block = 'ADDRESS' and nvl(p_form_mode,'!@#') = 'TRANSFER' Then
834:
835: -- Call to Update Item Instance from Address Block For Transfer OwnerShip.
836: -- Suppressed call to this Update API from CSXCUMPI_TAB_PROD_NFO Block.

Line 857: csi_gen_utility_pvt.put_line('Transfer Succes');

853: ,x_msg_count => x_Msg_Count
854: ,x_msg_data => x_Msg_Data
855: );
856: IF x_Return_Status = FND_API.G_Ret_Sts_Success THEN
857: csi_gen_utility_pvt.put_line('Transfer Succes');
858: Begin
859: Select Object_Version_Number
860: Into px_Cp_Object_Version_Number
861: From CSI_ITEM_INSTANCES

Line 878: -- csi_gen_utility_pvt.put_line('call Update Item instance for owner ship transfer');

874: Null;
875: End;
876:
877: End If;
878: -- csi_gen_utility_pvt.put_line('call Update Item instance for owner ship transfer');
879:
880: Elsif p_block = 'ADDRESS' and NVL(p_form_mode,'!@#') <> 'TRANSFER' Then
881:
882: -- Call to Update Item Instance from Address Block to update Installed At Location and Shipp_To

Line 903: csi_gen_utility_pvt.put_line('Update Shipto, Installed Address success in non Transfer Mode');

899: ,x_msg_data => x_Msg_Data
900: );
901:
902: IF x_Return_Status = FND_API.G_Ret_Sts_Success THEN
903: csi_gen_utility_pvt.put_line('Update Shipto, Installed Address success in non Transfer Mode');
904:
905: Begin
906: Select Object_Version_Number
907: Into px_Cp_Object_Version_Number

Line 925: -- csi_gen_utility_pvt.put_line('address Ins Obj '||px_Cp_Object_Version_Number);

921: Null;
922: End;
923:
924: End If;
925: -- csi_gen_utility_pvt.put_line('address Ins Obj '||px_Cp_Object_Version_Number);
926:
927: Elsif p_block = 'PRODUCT' and nvl(p_form_mode,'!@#') <> 'TRANSFER' Then
928:
929: -- Call to Update Item Instance from Address Block to update Installed At Location

Line 950: csi_gen_utility_pvt.put_line('Update Instance related info success in non Transfer Mode');

946: ,x_msg_data => x_Msg_Data
947: );
948:
949: IF x_Return_Status = FND_API.G_Ret_Sts_Success THEN
950: csi_gen_utility_pvt.put_line('Update Instance related info success in non Transfer Mode');
951: Select Object_Version_Number
952: Into px_Cp_Object_Version_Number
953: From CSI_ITEM_INSTANCES
954: Where instance_id = l_Instance_Rec.Instance_Id;

Line 956: -- csi_gen_utility_pvt.put_line('Product Ins Obj '||px_Cp_Object_Version_Number);

952: Into px_Cp_Object_Version_Number
953: From CSI_ITEM_INSTANCES
954: Where instance_id = l_Instance_Rec.Instance_Id;
955: End If;
956: -- csi_gen_utility_pvt.put_line('Product Ins Obj '||px_Cp_Object_Version_Number);
957: End If;
958:
959: IF NOT x_Return_Status = FND_API.G_Ret_Sts_Success THEN
960: l_msg_index := 1;