DBA Data[Home] [Help]

APPS.CSI_PRICING_ATTRIBS_PVT dependencies on CSI_PRICING_ATTRIB_VLD_PVT

Line 2024: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_instance_id

2020:
2021: -- Start API body
2022: -- Verify if instance id is ok
2023: IF p_called_from_grp <> FND_API.G_TRUE THEN
2024: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_instance_id
2025: (p_pricing_attribs_rec.instance_id,
2026: 'INSERT')) THEN
2027: RAISE FND_API.G_EXC_ERROR;
2028: END IF;

Line 2034: IF NOT(csi_pricing_attrib_vld_pvt.Is_StartDate_Valid

2030:
2031:
2032: -- Check start effective date
2033: IF p_called_from_grp <> FND_API.G_TRUE THEN
2034: IF NOT(csi_pricing_attrib_vld_pvt.Is_StartDate_Valid
2035: (p_pricing_attribs_rec.ACTIVE_START_DATE,
2036: p_pricing_attribs_rec.ACTIVE_END_DATE ,
2037: p_pricing_attribs_rec.INSTANCE_ID )) THEN
2038: RAISE FND_API.G_EXC_ERROR;

Line 2046: IF NOT(csi_pricing_attrib_vld_pvt.Is_EndDate_Valid

2042:
2043: -- Check end effective date
2044: IF p_called_from_grp <> FND_API.G_TRUE THEN
2045: IF p_pricing_attribs_rec.ACTIVE_END_DATE is NOT NULL THEN
2046: IF NOT(csi_pricing_attrib_vld_pvt.Is_EndDate_Valid
2047: (p_pricing_attribs_rec.ACTIVE_START_DATE,
2048: p_pricing_attribs_rec.ACTIVE_END_DATE ,
2049: p_pricing_attribs_rec.INSTANCE_ID ,
2050: p_pricing_attribs_rec.PRICING_ATTRIBUTE_ID ,

Line 2063: l_pricing_attrib_id:= csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;

2059: -- and check if the value exists . If exists then generate again from the sequence
2060: -- till we get a value that does not exist
2061: IF l_pricing_attrib_id IS NULL OR
2062: l_pricing_attrib_id = FND_API.G_MISS_NUM THEN
2063: l_pricing_attrib_id:= csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;
2064: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;
2065: WHILE NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id
2066: (l_pricing_attrib_id))
2067: LOOP

Line 2065: WHILE NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id

2061: IF l_pricing_attrib_id IS NULL OR
2062: l_pricing_attrib_id = FND_API.G_MISS_NUM THEN
2063: l_pricing_attrib_id:= csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;
2064: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;
2065: WHILE NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id
2066: (l_pricing_attrib_id))
2067: LOOP
2068: l_pricing_attrib_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;
2069: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;

Line 2068: l_pricing_attrib_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;

2064: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;
2065: WHILE NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id
2066: (l_pricing_attrib_id))
2067: LOOP
2068: l_pricing_attrib_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_id;
2069: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;
2070: END LOOP;
2071: ELSE
2072: -- Validate pricing_attribute_id

Line 2073: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id

2069: p_pricing_attribs_rec.pricing_attribute_id := l_pricing_attrib_id;
2070: END LOOP;
2071: ELSE
2072: -- Validate pricing_attribute_id
2073: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_pricing_attrib_id
2074: (p_pricing_attribs_rec.pricing_attribute_id)) THEN
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077: END IF;

Line 2236: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;

2232: END IF;
2233:
2234:
2235: -- Get a unique org_assignment number from the sequence
2236: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;
2237:
2238: -- Create a history
2239: CSI_I_PRICING_ATTRIBS_H_PKG.Insert_Row(
2240: px_PRICE_ATTRIB_HISTORY_ID => l_pricing_attrib_h_id,

Line 2639: IF NOT(csi_pricing_attrib_vld_pvt.Val_and_get_pri_att_id

2635:
2636: -- Start API body
2637:
2638: -- Validate pricing_attribute_id
2639: IF NOT(csi_pricing_attrib_vld_pvt.Val_and_get_pri_att_id
2640: (p_pricing_attribs_rec.pricing_attribute_id,
2641: l_pricing_attribs_rec)) THEN
2642:
2643: RAISE FND_API.G_EXC_ERROR;

Line 2647: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_obj_ver_num

2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;
2645:
2646: -- Validate object_version_number
2647: IF NOT(csi_pricing_attrib_vld_pvt.Is_valid_obj_ver_num
2648: (p_pricing_attribs_rec.object_version_number
2649: ,l_pricing_attribs_rec.object_version_number
2650: )) THEN
2651:

Line 2657: IF NOT(csi_pricing_attrib_vld_pvt.Is_Updatable

2653: END IF;
2654:
2655:
2656: -- Validate if the instance is updatable
2657: IF NOT(csi_pricing_attrib_vld_pvt.Is_Updatable
2658: (l_pricing_attribs_rec.active_end_date ,
2659: p_pricing_attribs_rec.active_end_date )) THEN
2660: RAISE FND_API.G_EXC_ERROR;
2661: END IF;

Line 2664: IF NOT(csi_pricing_attrib_vld_pvt.Is_Valid_instance_id

2660: RAISE FND_API.G_EXC_ERROR;
2661: END IF;
2662:
2663: -- Validate instance id for which the update is related to
2664: IF NOT(csi_pricing_attrib_vld_pvt.Is_Valid_instance_id
2665: (l_pricing_attribs_rec.instance_id,
2666: 'UPDATE'
2667: )) THEN
2668:

Line 2670: IF NOT(csi_pricing_attrib_vld_pvt.Is_Expire_Op

2666: 'UPDATE'
2667: )) THEN
2668:
2669: -- Check if it is an expire operation
2670: IF NOT(csi_pricing_attrib_vld_pvt.Is_Expire_Op
2671: (p_pricing_attribs_rec)) THEN
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: END IF;

Line 2679: IF NOT(csi_pricing_attrib_vld_pvt.Val_inst_id_for_update

2675:
2676:
2677: -- Validate instance id
2678: IF ( p_pricing_attribs_rec.instance_id <> FND_API.G_MISS_NUM ) THEN
2679: IF NOT(csi_pricing_attrib_vld_pvt.Val_inst_id_for_update
2680: ( p_pricing_attribs_rec.instance_id
2681: ,l_pricing_attribs_rec.instance_id
2682: )) THEN
2683: RAISE FND_API.G_EXC_ERROR;

Line 2702: IF NOT(csi_pricing_attrib_vld_pvt.Is_EndDate_Valid

2698: -- Verify end effective date
2699: IF ( p_pricing_attribs_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
2700: IF p_pricing_attribs_rec.active_end_date is NOT NULL THEN
2701: IF g_expire_pric_flag <> 'Y' THEN
2702: IF NOT(csi_pricing_attrib_vld_pvt.Is_EndDate_Valid
2703: (p_pricing_attribs_rec.ACTIVE_START_DATE,
2704: p_pricing_attribs_rec.ACTIVE_END_DATE,
2705: p_pricing_attribs_rec.INSTANCE_ID ,
2706: p_pricing_attribs_rec.PRICING_ATTRIBUTE_ID ,

Line 2717: csi_pricing_attrib_vld_pvt.get_object_version_number(l_pricing_attribs_rec.object_version_number);

2713:
2714:
2715: -- Get the new object version number
2716: l_pricing_attribs_rec.object_version_number :=
2717: csi_pricing_attrib_vld_pvt.get_object_version_number(l_pricing_attribs_rec.object_version_number);
2718:
2719: CSI_I_PRICING_ATTRIBS_PKG.Update_Row
2720: (
2721: l_pricing_attrib_id

Line 2885: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;

2881:
2882:
2883:
2884: -- Get a unique pricing attribute id number from the sequence
2885: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;
2886:
2887:
2888: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
2889: l_dump_frequency := csi_pricing_attrib_vld_pvt.get_full_dump_frequency;

Line 2889: l_dump_frequency := csi_pricing_attrib_vld_pvt.get_full_dump_frequency;

2885: l_pricing_attrib_h_id := csi_pricing_attrib_vld_pvt.get_pricing_attrib_h_id;
2886:
2887:
2888: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
2889: l_dump_frequency := csi_pricing_attrib_vld_pvt.get_full_dump_frequency;
2890: IF l_dump_frequency IS NULL THEN
2891: RAISE FND_API.G_EXC_ERROR;
2892: END IF;
2893:

Line 7416: IF NOT(csi_pricing_attrib_vld_pvt.Val_and_get_pri_att_id

7412:
7413: -- Start API body
7414:
7415: -- Validate pricing_attribute_id
7416: IF NOT(csi_pricing_attrib_vld_pvt.Val_and_get_pri_att_id
7417: (p_pricing_attribs_rec.pricing_attribute_id,
7418: l_pricing_attribs_rec)) THEN
7419: RAISE FND_API.G_EXC_ERROR;
7420: END IF;