[Home] [Help]
40: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Default_ActMetricFact(
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_act_metric_fact_rec IN act_metric_fact_rec_type,
46: p_validation_mode IN VARCHAR2 ,
47: x_complete_rec OUT NOCOPY act_metric_fact_rec_type,
48: x_return_status OUT NOCOPY VARCHAR2,
54: BEGIN
55: --
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: --
58: IF FND_API.To_Boolean (p_init_msg_list) THEN
59: FND_MSG_PUB.Initialize;
60: END IF;
61:
62: --
61:
62: --
63: -- Initialize API return status to success.
64: --
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: x_complete_rec := p_act_metric_fact_rec;
68:
69: -- Insert Mode
116: x_fact_rec OUT NOCOPY act_metric_fact_rec_type
117: )
118: IS
119: BEGIN
120: x_fact_rec.activity_metric_fact_id := fnd_api.g_miss_num;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
117: )
118: IS
119: BEGIN
120: x_fact_rec.activity_metric_fact_id := fnd_api.g_miss_num;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
118: IS
119: BEGIN
120: x_fact_rec.activity_metric_fact_id := fnd_api.g_miss_num;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
119: BEGIN
120: x_fact_rec.activity_metric_fact_id := fnd_api.g_miss_num;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
120: x_fact_rec.activity_metric_fact_id := fnd_api.g_miss_num;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
121: x_fact_rec.last_update_date := fnd_api.g_miss_date;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
122: x_fact_rec.last_updated_by := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
123: x_fact_rec.creation_date := fnd_api.g_miss_date;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
124: x_fact_rec.created_by := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
125: x_fact_rec.last_update_login := fnd_api.g_miss_num;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
126: x_fact_rec.object_version_number := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
127: x_fact_rec.act_metric_used_by_id := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
128: x_fact_rec.arc_act_metric_used_by := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
129: x_fact_rec.value_type := fnd_api.g_miss_char;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
130: x_fact_rec.activity_metric_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
131: x_fact_rec.activity_geo_area_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
132: x_fact_rec.activity_product_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
133: x_fact_rec.transaction_currency_code := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
134: x_fact_rec.trans_forecasted_value := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
135: x_fact_rec.base_quantity := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
136: x_fact_rec.functional_currency_code := fnd_api.g_miss_char;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
137: x_fact_rec.func_forecasted_value := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
138: x_fact_rec.org_id := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
139: x_fact_rec.de_metric_id := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
140: x_fact_rec.de_geographic_area_id := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
141: x_fact_rec.de_geographic_area_type := fnd_api.g_miss_char;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
142: x_fact_rec.de_inventory_item_id := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
143: x_fact_rec.de_inventory_item_org_id := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
144: x_fact_rec.time_id1 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
145: x_fact_rec.time_id2 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
146: x_fact_rec.time_id3 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
147: x_fact_rec.time_id4 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
148: x_fact_rec.time_id5 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
149: x_fact_rec.time_id6 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
150: x_fact_rec.time_id7 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
151: x_fact_rec.time_id8 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
152: x_fact_rec.time_id9 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
153: x_fact_rec.time_id10 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
154: x_fact_rec.time_id11 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
155: x_fact_rec.time_id12 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
156: x_fact_rec.time_id13 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
157: x_fact_rec.time_id14 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
158: x_fact_rec.time_id15 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
159: x_fact_rec.time_id16 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
160: x_fact_rec.time_id17 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
161: x_fact_rec.time_id18 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
162: x_fact_rec.time_id19 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
163: x_fact_rec.time_id20 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
164: x_fact_rec.time_id21 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
165: x_fact_rec.time_id22 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
166: x_fact_rec.time_id23 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
167: x_fact_rec.time_id24 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
168: x_fact_rec.time_id25 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
169: x_fact_rec.time_id26 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
170: x_fact_rec.time_id27 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
171: x_fact_rec.time_id28 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
172: x_fact_rec.time_id29 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
173: x_fact_rec.time_id30 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
174: x_fact_rec.time_id31 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
175: x_fact_rec.time_id32 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
176: x_fact_rec.time_id33 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
177: x_fact_rec.time_id34 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
178: x_fact_rec.time_id35 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
179: x_fact_rec.time_id36 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
180: x_fact_rec.time_id37 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
181: x_fact_rec.time_id38 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
182: x_fact_rec.time_id39 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
183: x_fact_rec.time_id40 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
184: x_fact_rec.time_id41 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
185: x_fact_rec.time_id42 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
186: x_fact_rec.time_id43 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
187: x_fact_rec.time_id44 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
188: x_fact_rec.time_id45 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
189: x_fact_rec.time_id46 := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
190: x_fact_rec.time_id47 := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
191: x_fact_rec.time_id48 := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
192: x_fact_rec.time_id49 := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
193: x_fact_rec.time_id50 := fnd_api.g_miss_num;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
194: x_fact_rec.time_id51 := fnd_api.g_miss_num;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
195: x_fact_rec.time_id52 := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
196: x_fact_rec.time_id53 := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
197: x_fact_rec.hierarchy_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
198: x_fact_rec.node_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
199: x_fact_rec.level_depth := fnd_api.g_miss_num;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
200: x_fact_rec.formula_id := fnd_api.g_miss_num;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
201: x_fact_rec.from_date := fnd_api.g_miss_date;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
202: x_fact_rec.to_date := fnd_api.g_miss_date;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
203: x_fact_rec.fact_value := fnd_api.g_miss_num;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
204: x_fact_rec.fact_percent := fnd_api.g_miss_num;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
205: x_fact_rec.root_fact_id := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
206: x_fact_rec.previous_fact_id := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
207: x_fact_rec.fact_type := fnd_api.g_miss_char;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
208: x_fact_rec.fact_reference := fnd_api.g_miss_char;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
209: x_fact_rec.forward_buy_quantity := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
210: x_fact_rec.status_code := fnd_api.g_miss_char;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
211: x_fact_rec.hierarchy_type := fnd_api.g_miss_char;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
212: x_fact_rec.approval_date := fnd_api.g_miss_date;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
220: x_fact_rec.base_hb_pct := fnd_api.g_miss_num;
213: x_fact_rec.recommend_total_amount := fnd_api.g_miss_num;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
220: x_fact_rec.base_hb_pct := fnd_api.g_miss_num;
221: END Init_ActMetricFact_Rec;
214: x_fact_rec.recommend_hb_amount := fnd_api.g_miss_num;
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
220: x_fact_rec.base_hb_pct := fnd_api.g_miss_num;
221: END Init_ActMetricFact_Rec;
222:
215: x_fact_rec.request_total_amount := fnd_api.g_miss_num;
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
220: x_fact_rec.base_hb_pct := fnd_api.g_miss_num;
221: END Init_ActMetricFact_Rec;
222:
223:
216: x_fact_rec.request_hb_amount := fnd_api.g_miss_num;
217: x_fact_rec.actual_total_amount := fnd_api.g_miss_num;
218: x_fact_rec.actual_hb_amount := fnd_api.g_miss_num;
219: x_fact_rec.base_total_pct := fnd_api.g_miss_num;
220: x_fact_rec.base_hb_pct := fnd_api.g_miss_num;
221: END Init_ActMetricFact_Rec;
222:
223:
224: -- Start of comments
241: --
242: -- End of comments--
243: PROCEDURE Validate_FUND_Facts(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
247: p_act_metric_id IN NUMBER,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
242: -- End of comments--
243: PROCEDURE Validate_FUND_Facts(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
247: p_act_metric_id IN NUMBER,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2
308:
309: AMS_Utility_PVT.debug_message('Validate_FundFact_Fund: start');
310: END IF;
311:
312: IF FND_API.To_Boolean (p_init_msg_list) THEN
313: FND_MSG_PUB.Initialize;
314: END IF;
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: IF FND_API.To_Boolean (p_init_msg_list) THEN
313: FND_MSG_PUB.Initialize;
314: END IF;
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: l_top_level := true;
318:
319: FOR factrec IN c_fundfact_getfacts LOOP
320: IF factrec.formula_type = 'ALLOCATION' THEN
337: FND_MESSAGE.Set_Token('NODEVALUE', 'FUND');
338: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
339: FND_MSG_PUB.Add;
340: END IF;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: l_top_level := false;
345: END IF; -- IF l_top_level = true
338: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
339: FND_MSG_PUB.Add;
340: END IF;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: l_top_level := false;
345: END IF; -- IF l_top_level = true
346: ELSE -- formula is 'HOLDBACK'
362: FND_MESSAGE.Set_Token('NODEVALUE', l_node_value);
363: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
364: FND_MSG_PUB.Add;
365: END IF;
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369: END IF;
370: END LOOP;
363: FND_MESSAGE.Set_Token('PAMT', l_avail_amount);
364: FND_MSG_PUB.Add;
365: END IF;
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369: END IF;
370: END LOOP;
371:
377:
378: END IF;
379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Validate_FUND_Facts: ' || substr(sqlerrm, 1, 100)); END IF;
383: ROLLBACK TO Validate_FUND_Facts;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MSG_PUB.Count_And_Get (
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Validate_FUND_Facts: ' || substr(sqlerrm, 1, 100)); END IF;
383: ROLLBACK TO Validate_FUND_Facts;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => fnd_api.g_false,
387: p_count => x_msg_count,
388: p_data => x_msg_data
382: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Validate_FUND_Facts: ' || substr(sqlerrm, 1, 100)); END IF;
383: ROLLBACK TO Validate_FUND_Facts;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => fnd_api.g_false,
387: p_count => x_msg_count,
388: p_data => x_msg_data
389: );
390: WHEN OTHERS THEN
389: );
390: WHEN OTHERS THEN
391: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Validate_FUND_Facts: ' || substr(sqlerrm, 1, 100)); END IF;
392: ROLLBACK TO Validate_FUND_Facts;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => fnd_api.g_false,
396: p_count => x_msg_count,
397: p_data => x_msg_data
391: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Validate_FUND_Facts: ' || substr(sqlerrm, 1, 100)); END IF;
392: ROLLBACK TO Validate_FUND_Facts;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => fnd_api.g_false,
396: p_count => x_msg_count,
397: p_data => x_msg_data
398: );
399: END Validate_FUND_Facts;
416: -- End of comments
417:
418: PROCEDURE Create_ActMetricFact (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
423:
424: x_return_status OUT NOCOPY VARCHAR2,
417:
418: PROCEDURE Create_ActMetricFact (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
423:
424: x_return_status OUT NOCOPY VARCHAR2,
425: x_msg_count OUT NOCOPY NUMBER,
418: PROCEDURE Create_ActMetricFact (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
423:
424: x_return_status OUT NOCOPY VARCHAR2,
425: x_msg_count OUT NOCOPY NUMBER,
426: x_msg_data OUT NOCOPY VARCHAR2,
469:
470: --
471: -- Initialize message list if p_init_msg_list is set to TRUE.
472: --
473: IF FND_API.To_Boolean (p_init_msg_list) THEN
474: FND_MSG_PUB.Initialize;
475: END IF;
476:
477: --
476:
477: --
478: -- Standard check for API version compatibility.
479: --
480: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
481: p_api_version,
482: L_API_NAME,
483: G_PKG_NAME)
484: THEN
481: p_api_version,
482: L_API_NAME,
483: G_PKG_NAME)
484: THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488: --
489: -- Initialize API return status to success.
487:
488: --
489: -- Initialize API return status to success.
490: --
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: --
494: -- Begin API Body.
495: --
505: x_msg_count => x_msg_count,
506: x_msg_data => x_msg_data ) ;
507:
508: -- If any errors happen abort API.
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
506: x_msg_data => x_msg_data ) ;
507:
508: -- If any errors happen abort API.
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514:
507:
508: -- If any errors happen abort API.
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514:
515:
508: -- If any errors happen abort API.
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514:
515:
516:
549: p_act_metric_fact_rec => l_act_metric_fact_rec
550: );
551:
552: -- If any errors happen abort API.
553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
550: );
551:
552: -- If any errors happen abort API.
553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
551:
552: -- If any errors happen abort API.
553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559:
552: -- If any errors happen abort API.
553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558:
559:
560:
783: /* 05/21/2002 yzhao: add ends */
784: );
785:
786: -- If any errors happen abort API.
787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
784: );
785:
786: -- If any errors happen abort API.
787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792:
785:
786: -- If any errors happen abort API.
787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792:
793:
786: -- If any errors happen abort API.
787: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792:
793:
794:
806:
807: --
808: -- Standard check for commit request.
809: --
810: IF FND_API.To_Boolean (p_commit) THEN
811: COMMIT WORK;
812: END IF;
813:
814: --
817: --
818: FND_MSG_PUB.Count_And_Get (
819: p_count => x_msg_count,
820: p_data => x_msg_data,
821: p_encoded => FND_API.G_FALSE
822: );
823:
824: --
825: -- Add success message to message list.
832:
833:
834:
835: EXCEPTION
836: WHEN FND_API.G_EXC_ERROR THEN
837:
838:
839: ROLLBACK TO Create_ActMetricFact_Pvt;
840: x_return_status := FND_API.G_RET_STS_ERROR;
836: WHEN FND_API.G_EXC_ERROR THEN
837:
838:
839: ROLLBACK TO Create_ActMetricFact_Pvt;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: FND_MSG_PUB.Count_And_Get (
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
841: FND_MSG_PUB.Count_And_Get (
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846:
847:
848:
849: ROLLBACK TO Create_ActMetricFact_Pvt;
846:
847:
848:
849: ROLLBACK TO Create_ActMetricFact_Pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: FND_MSG_PUB.Count_And_Get (
852: p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: WHEN OTHERS THEN
856:
857:
858: ROLLBACK TO Create_ActMetricFact_Pvt;
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
860: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
861: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
862: END IF;
863: FND_MSG_PUB.Count_And_Get (
883: -- End of comments
884:
885: PROCEDURE Update_ActMetricFact (
886: p_api_version IN NUMBER,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE,
889: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
890:
891: x_return_status OUT NOCOPY VARCHAR2,
884:
885: PROCEDURE Update_ActMetricFact (
886: p_api_version IN NUMBER,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE,
889: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
890:
891: x_return_status OUT NOCOPY VARCHAR2,
892: x_msg_count OUT NOCOPY NUMBER,
885: PROCEDURE Update_ActMetricFact (
886: p_api_version IN NUMBER,
887: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
888: p_commit IN VARCHAR2 := FND_API.G_FALSE,
889: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
890:
891: x_return_status OUT NOCOPY VARCHAR2,
892: x_msg_count OUT NOCOPY NUMBER,
893: x_msg_data OUT NOCOPY VARCHAR2,
920:
921: --
922: -- Initialize message list if p_init_msg_list is set to TRUE.
923: --
924: IF FND_API.To_Boolean (p_init_msg_list) THEN
925: FND_MSG_PUB.Initialize;
926: END IF;
927:
928: --
927:
928: --
929: -- Standard check for API version compatibility.
930: --
931: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
932: p_api_version,
933: L_API_NAME,
934: G_PKG_NAME)
935: THEN
932: p_api_version,
933: L_API_NAME,
934: G_PKG_NAME)
935: THEN
936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: END IF;
938:
939: --
940: -- Initialize API return status to success.
938:
939: --
940: -- Initialize API return status to success.
941: --
942: x_return_status := FND_API.G_RET_STS_SUCCESS;
943:
944: --
945: -- Begin API Body
946: --
956: x_msg_count => x_msg_count,
957: x_msg_data => x_msg_data ) ;
958: -- dbms_output.put_line(l_full_name || ' default_actmetricfact returns ' || l_return_status);
959: -- If any errors happen abort API.
960: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END IF;
957: x_msg_data => x_msg_data ) ;
958: -- dbms_output.put_line(l_full_name || ' default_actmetricfact returns ' || l_return_status);
959: -- If any errors happen abort API.
960: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END IF;
965:
958: -- dbms_output.put_line(l_full_name || ' default_actmetricfact returns ' || l_return_status);
959: -- If any errors happen abort API.
960: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END IF;
965:
966:
959: -- If any errors happen abort API.
960: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END IF;
965:
966:
967: IF (AMS_DEBUG_HIGH_ON) THEN
993: p_validation_mode => JTF_PLSQL_API.g_update,
994: x_return_status => l_return_status
995: );
996: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
997: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
998: RAISE FND_API.g_exc_unexpected_error;
999: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1000: RAISE FND_API.g_exc_error;
1001: END IF;
994: x_return_status => l_return_status
995: );
996: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
997: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
998: RAISE FND_API.g_exc_unexpected_error;
999: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1000: RAISE FND_API.g_exc_error;
1001: END IF;
1002: END IF;
995: );
996: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
997: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
998: RAISE FND_API.g_exc_unexpected_error;
999: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1000: RAISE FND_API.g_exc_error;
1001: END IF;
1002: END IF;
1003:
996: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
997: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
998: RAISE FND_API.g_exc_unexpected_error;
999: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1000: RAISE FND_API.g_exc_error;
1001: END IF;
1002: END IF;
1003:
1004:
1007: p_act_metric_fact_rec => p_act_metric_fact_rec,
1008: p_complete_fact_rec => l_act_metric_fact_rec,
1009: x_return_status => l_return_status
1010: );
1011: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1012: RAISE FND_API.g_exc_unexpected_error;
1013: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1014: RAISE FND_API.g_exc_error;
1015: END IF;
1008: p_complete_fact_rec => l_act_metric_fact_rec,
1009: x_return_status => l_return_status
1010: );
1011: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1012: RAISE FND_API.g_exc_unexpected_error;
1013: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1014: RAISE FND_API.g_exc_error;
1015: END IF;
1016:
1009: x_return_status => l_return_status
1010: );
1011: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1012: RAISE FND_API.g_exc_unexpected_error;
1013: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1014: RAISE FND_API.g_exc_error;
1015: END IF;
1016:
1017: END IF;
1010: );
1011: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1012: RAISE FND_API.g_exc_unexpected_error;
1013: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1014: RAISE FND_API.g_exc_error;
1015: END IF;
1016:
1017: END IF;
1018:
1141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1143: FND_MSG_PUB.add;
1144: END IF;
1145: RAISE FND_API.g_exc_error;
1146: END IF;
1147:
1148:
1149: --
1149: --
1150: -- End API Body
1151: --
1152:
1153: IF FND_API.to_boolean(p_commit) THEN
1154: COMMIT;
1155: END IF;
1156:
1157: --
1160: --
1161: FND_MSG_PUB.Count_And_Get (
1162: p_count => x_msg_count,
1163: p_data => x_msg_data,
1164: p_encoded => FND_API.G_FALSE
1165: );
1166:
1167: --
1168: -- Debug message.
1173: END IF;
1174:
1175:
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179:
1180:
1181: ROLLBACK TO Update_ActMetricFact_pvt;
1178:
1179:
1180:
1181: ROLLBACK TO Update_ActMetricFact_pvt;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: FND_MSG_PUB.Count_And_Get (
1184: p_count => x_msg_count,
1185: p_data => x_msg_data
1186: );
1183: FND_MSG_PUB.Count_And_Get (
1184: p_count => x_msg_count,
1185: p_data => x_msg_data
1186: );
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188:
1189:
1190:
1191: ROLLBACK TO Update_ActMetricFact_pvt;
1188:
1189:
1190:
1191: ROLLBACK TO Update_ActMetricFact_pvt;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: FND_MSG_PUB.Count_And_Get (
1194: p_count => x_msg_count,
1195: p_data => x_msg_data
1196: );
1198:
1199:
1200:
1201: ROLLBACK TO Update_ActMetricFact_pvt;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1204: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1205: END IF;
1206: FND_MSG_PUB.Count_And_Get (
1225: -- End of comments
1226:
1227: PROCEDURE Lock_ActMetricFact (
1228: p_api_version IN NUMBER,
1229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1230:
1231: x_return_status OUT NOCOPY VARCHAR2,
1232: x_msg_count OUT NOCOPY NUMBER,
1233: x_msg_data OUT NOCOPY VARCHAR2,
1260:
1261: --
1262: -- Initialize message list if p_init_msg_list is set to TRUE.
1263: --
1264: IF FND_API.To_Boolean (p_init_msg_list) THEN
1265: FND_MSG_PUB.Initialize;
1266: END IF;
1267:
1268: --
1267:
1268: --
1269: -- Standard check for API version compatibility.
1270: --
1271: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1272: p_api_version,
1273: L_API_NAME,
1274: G_PKG_NAME)
1275: THEN
1272: p_api_version,
1273: L_API_NAME,
1274: G_PKG_NAME)
1275: THEN
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END IF;
1278:
1279: --
1280: -- Initialize API return status to success.
1278:
1279: --
1280: -- Initialize API return status to success.
1281: --
1282: x_return_status := FND_API.G_RET_STS_SUCCESS;
1283:
1284: --
1285: -- Begin API Body
1286: --
1299: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1300: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1301: FND_MSG_PUB.add;
1302: END IF;
1303: RAISE FND_API.g_exc_error;
1304: END IF;
1305: CLOSE c_act_metric_fact_info;
1306:
1307:
1311: --
1312: FND_MSG_PUB.Count_And_Get (
1313: p_count => x_msg_count,
1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE
1316: );
1317:
1318: --
1319: -- Debug message.
1324: END IF;
1325:
1326:
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: FND_MSG_PUB.Count_And_Get (
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1325:
1326:
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: FND_MSG_PUB.Count_And_Get (
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1330: FND_MSG_PUB.Count_And_Get (
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1340: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
1341: x_return_status := FND_API.G_RET_STS_ERROR ;
1342:
1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1344: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1345: FND_MSG_PUB.add;
1347:
1348: FND_MSG_PUB.Count_And_Get (
1349: p_count => x_msg_count,
1350: p_data => x_msg_data,
1351: p_encoded => FND_API.G_FALSE
1352: );
1353: WHEN OTHERS THEN
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1350: p_data => x_msg_data,
1351: p_encoded => FND_API.G_FALSE
1352: );
1353: WHEN OTHERS THEN
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1356: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1357: END IF;
1358: FND_MSG_PUB.Count_And_Get (
1357: END IF;
1358: FND_MSG_PUB.Count_And_Get (
1359: p_count => x_msg_count,
1360: p_data => x_msg_data,
1361: p_encoded => FND_API.G_FALSE
1362: );
1363: END Lock_ActMetricFact;
1364:
1365:
1397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1398: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1399: FND_MSG_PUB.add;
1400: END IF;
1401: RAISE FND_API.g_exc_error;
1402: END IF;
1403: CLOSE c_act_metric_fact;
1404:
1405:
1402: END IF;
1403: CLOSE c_act_metric_fact;
1404:
1405:
1406: IF p_act_metric_fact_rec.activity_metric_fact_id = FND_API.G_MISS_NUM THEN
1407: x_complete_fact_rec.activity_metric_fact_id := l_act_metric_fact_rec.activity_metric_fact_id;
1408: END IF;
1409:
1410: IF p_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
1406: IF p_act_metric_fact_rec.activity_metric_fact_id = FND_API.G_MISS_NUM THEN
1407: x_complete_fact_rec.activity_metric_fact_id := l_act_metric_fact_rec.activity_metric_fact_id;
1408: END IF;
1409:
1410: IF p_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
1411: x_complete_fact_rec.act_metric_used_by_id := l_act_metric_fact_rec.act_metric_used_by_id;
1412: END IF;
1413:
1414: IF p_act_metric_fact_rec.arc_act_metric_used_by = FND_API.G_MISS_CHAR THEN
1410: IF p_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
1411: x_complete_fact_rec.act_metric_used_by_id := l_act_metric_fact_rec.act_metric_used_by_id;
1412: END IF;
1413:
1414: IF p_act_metric_fact_rec.arc_act_metric_used_by = FND_API.G_MISS_CHAR THEN
1415: x_complete_fact_rec.arc_act_metric_used_by := l_act_metric_fact_rec.arc_act_metric_used_by;
1416: END IF;
1417:
1418: IF p_act_metric_fact_rec.value_type = FND_API.G_MISS_CHAR THEN
1414: IF p_act_metric_fact_rec.arc_act_metric_used_by = FND_API.G_MISS_CHAR THEN
1415: x_complete_fact_rec.arc_act_metric_used_by := l_act_metric_fact_rec.arc_act_metric_used_by;
1416: END IF;
1417:
1418: IF p_act_metric_fact_rec.value_type = FND_API.G_MISS_CHAR THEN
1419: x_complete_fact_rec.value_type := l_act_metric_fact_rec.value_type;
1420: END IF;
1421:
1422: IF p_act_metric_fact_rec.activity_metric_id = FND_API.G_MISS_NUM THEN
1418: IF p_act_metric_fact_rec.value_type = FND_API.G_MISS_CHAR THEN
1419: x_complete_fact_rec.value_type := l_act_metric_fact_rec.value_type;
1420: END IF;
1421:
1422: IF p_act_metric_fact_rec.activity_metric_id = FND_API.G_MISS_NUM THEN
1423: x_complete_fact_rec.activity_metric_id := l_act_metric_fact_rec.activity_metric_id;
1424: END IF;
1425:
1426: IF p_act_metric_fact_rec.activity_geo_area_id = FND_API.G_MISS_NUM THEN
1422: IF p_act_metric_fact_rec.activity_metric_id = FND_API.G_MISS_NUM THEN
1423: x_complete_fact_rec.activity_metric_id := l_act_metric_fact_rec.activity_metric_id;
1424: END IF;
1425:
1426: IF p_act_metric_fact_rec.activity_geo_area_id = FND_API.G_MISS_NUM THEN
1427: x_complete_fact_rec.activity_geo_area_id := l_act_metric_fact_rec.activity_geo_area_id;
1428: END IF;
1429:
1430: IF p_act_metric_fact_rec.activity_product_id = FND_API.G_MISS_NUM THEN
1426: IF p_act_metric_fact_rec.activity_geo_area_id = FND_API.G_MISS_NUM THEN
1427: x_complete_fact_rec.activity_geo_area_id := l_act_metric_fact_rec.activity_geo_area_id;
1428: END IF;
1429:
1430: IF p_act_metric_fact_rec.activity_product_id = FND_API.G_MISS_NUM THEN
1431: x_complete_fact_rec.activity_product_id := l_act_metric_fact_rec.activity_product_id;
1432: END IF;
1433:
1434: IF p_act_metric_fact_rec.transaction_currency_code = FND_API.G_MISS_CHAR THEN
1430: IF p_act_metric_fact_rec.activity_product_id = FND_API.G_MISS_NUM THEN
1431: x_complete_fact_rec.activity_product_id := l_act_metric_fact_rec.activity_product_id;
1432: END IF;
1433:
1434: IF p_act_metric_fact_rec.transaction_currency_code = FND_API.G_MISS_CHAR THEN
1435: x_complete_fact_rec.transaction_currency_code := l_act_metric_fact_rec.transaction_currency_code;
1436: END IF;
1437:
1438: IF p_act_metric_fact_rec.trans_forecasted_value = FND_API.G_MISS_NUM THEN
1434: IF p_act_metric_fact_rec.transaction_currency_code = FND_API.G_MISS_CHAR THEN
1435: x_complete_fact_rec.transaction_currency_code := l_act_metric_fact_rec.transaction_currency_code;
1436: END IF;
1437:
1438: IF p_act_metric_fact_rec.trans_forecasted_value = FND_API.G_MISS_NUM THEN
1439: x_complete_fact_rec.trans_forecasted_value := l_act_metric_fact_rec.trans_forecasted_value;
1440: END IF;
1441:
1442: IF p_act_metric_fact_rec.base_quantity = FND_API.G_MISS_NUM THEN
1438: IF p_act_metric_fact_rec.trans_forecasted_value = FND_API.G_MISS_NUM THEN
1439: x_complete_fact_rec.trans_forecasted_value := l_act_metric_fact_rec.trans_forecasted_value;
1440: END IF;
1441:
1442: IF p_act_metric_fact_rec.base_quantity = FND_API.G_MISS_NUM THEN
1443: x_complete_fact_rec.base_quantity := l_act_metric_fact_rec.base_quantity;
1444: END IF;
1445:
1446: IF p_act_metric_fact_rec.functional_currency_code = FND_API.G_MISS_CHAR THEN
1442: IF p_act_metric_fact_rec.base_quantity = FND_API.G_MISS_NUM THEN
1443: x_complete_fact_rec.base_quantity := l_act_metric_fact_rec.base_quantity;
1444: END IF;
1445:
1446: IF p_act_metric_fact_rec.functional_currency_code = FND_API.G_MISS_CHAR THEN
1447: x_complete_fact_rec.functional_currency_code := l_act_metric_fact_rec.functional_currency_code;
1448: END IF;
1449:
1450: IF p_act_metric_fact_rec.func_forecasted_value = FND_API.G_MISS_NUM THEN
1446: IF p_act_metric_fact_rec.functional_currency_code = FND_API.G_MISS_CHAR THEN
1447: x_complete_fact_rec.functional_currency_code := l_act_metric_fact_rec.functional_currency_code;
1448: END IF;
1449:
1450: IF p_act_metric_fact_rec.func_forecasted_value = FND_API.G_MISS_NUM THEN
1451: x_complete_fact_rec.func_forecasted_value := l_act_metric_fact_rec.func_forecasted_value;
1452: END IF;
1453:
1454: IF p_act_metric_fact_rec.org_id = FND_API.G_MISS_NUM THEN
1450: IF p_act_metric_fact_rec.func_forecasted_value = FND_API.G_MISS_NUM THEN
1451: x_complete_fact_rec.func_forecasted_value := l_act_metric_fact_rec.func_forecasted_value;
1452: END IF;
1453:
1454: IF p_act_metric_fact_rec.org_id = FND_API.G_MISS_NUM THEN
1455: x_complete_fact_rec.org_id := l_act_metric_fact_rec.org_id;
1456: END IF;
1457:
1458: IF p_act_metric_fact_rec.de_metric_id = FND_API.G_MISS_NUM THEN
1454: IF p_act_metric_fact_rec.org_id = FND_API.G_MISS_NUM THEN
1455: x_complete_fact_rec.org_id := l_act_metric_fact_rec.org_id;
1456: END IF;
1457:
1458: IF p_act_metric_fact_rec.de_metric_id = FND_API.G_MISS_NUM THEN
1459: x_complete_fact_rec.de_metric_id := l_act_metric_fact_rec.de_metric_id;
1460: END IF;
1461:
1462: IF p_act_metric_fact_rec.de_geographic_area_id = FND_API.G_MISS_NUM THEN
1458: IF p_act_metric_fact_rec.de_metric_id = FND_API.G_MISS_NUM THEN
1459: x_complete_fact_rec.de_metric_id := l_act_metric_fact_rec.de_metric_id;
1460: END IF;
1461:
1462: IF p_act_metric_fact_rec.de_geographic_area_id = FND_API.G_MISS_NUM THEN
1463: x_complete_fact_rec.de_geographic_area_id := l_act_metric_fact_rec.de_geographic_area_id;
1464: END IF;
1465:
1466: IF p_act_metric_fact_rec.de_geographic_area_type = FND_API.G_MISS_CHAR THEN
1462: IF p_act_metric_fact_rec.de_geographic_area_id = FND_API.G_MISS_NUM THEN
1463: x_complete_fact_rec.de_geographic_area_id := l_act_metric_fact_rec.de_geographic_area_id;
1464: END IF;
1465:
1466: IF p_act_metric_fact_rec.de_geographic_area_type = FND_API.G_MISS_CHAR THEN
1467: x_complete_fact_rec.de_geographic_area_type := l_act_metric_fact_rec.de_geographic_area_type;
1468: END IF;
1469:
1470: IF p_act_metric_fact_rec.de_inventory_item_id = FND_API.G_MISS_NUM THEN
1466: IF p_act_metric_fact_rec.de_geographic_area_type = FND_API.G_MISS_CHAR THEN
1467: x_complete_fact_rec.de_geographic_area_type := l_act_metric_fact_rec.de_geographic_area_type;
1468: END IF;
1469:
1470: IF p_act_metric_fact_rec.de_inventory_item_id = FND_API.G_MISS_NUM THEN
1471: x_complete_fact_rec.de_inventory_item_id := l_act_metric_fact_rec.de_inventory_item_id;
1472: END IF;
1473:
1474: IF p_act_metric_fact_rec.de_inventory_item_org_id = FND_API.G_MISS_NUM THEN
1470: IF p_act_metric_fact_rec.de_inventory_item_id = FND_API.G_MISS_NUM THEN
1471: x_complete_fact_rec.de_inventory_item_id := l_act_metric_fact_rec.de_inventory_item_id;
1472: END IF;
1473:
1474: IF p_act_metric_fact_rec.de_inventory_item_org_id = FND_API.G_MISS_NUM THEN
1475: x_complete_fact_rec.de_inventory_item_org_id := l_act_metric_fact_rec.de_inventory_item_org_id;
1476: END IF;
1477:
1478: IF p_act_metric_fact_rec.time_id1 = FND_API.G_MISS_NUM THEN
1474: IF p_act_metric_fact_rec.de_inventory_item_org_id = FND_API.G_MISS_NUM THEN
1475: x_complete_fact_rec.de_inventory_item_org_id := l_act_metric_fact_rec.de_inventory_item_org_id;
1476: END IF;
1477:
1478: IF p_act_metric_fact_rec.time_id1 = FND_API.G_MISS_NUM THEN
1479: x_complete_fact_rec.time_id1 := l_act_metric_fact_rec.time_id1;
1480: END IF;
1481:
1482: IF p_act_metric_fact_rec.time_id2 = FND_API.G_MISS_NUM THEN
1478: IF p_act_metric_fact_rec.time_id1 = FND_API.G_MISS_NUM THEN
1479: x_complete_fact_rec.time_id1 := l_act_metric_fact_rec.time_id1;
1480: END IF;
1481:
1482: IF p_act_metric_fact_rec.time_id2 = FND_API.G_MISS_NUM THEN
1483: x_complete_fact_rec.time_id2 := l_act_metric_fact_rec.time_id2;
1484: END IF;
1485:
1486: IF p_act_metric_fact_rec.time_id3 = FND_API.G_MISS_NUM THEN
1482: IF p_act_metric_fact_rec.time_id2 = FND_API.G_MISS_NUM THEN
1483: x_complete_fact_rec.time_id2 := l_act_metric_fact_rec.time_id2;
1484: END IF;
1485:
1486: IF p_act_metric_fact_rec.time_id3 = FND_API.G_MISS_NUM THEN
1487: x_complete_fact_rec.time_id3 := l_act_metric_fact_rec.time_id3;
1488: END IF;
1489:
1490:
1487: x_complete_fact_rec.time_id3 := l_act_metric_fact_rec.time_id3;
1488: END IF;
1489:
1490:
1491: IF p_act_metric_fact_rec.time_id4 = FND_API.G_MISS_NUM THEN
1492: x_complete_fact_rec.time_id4 := l_act_metric_fact_rec.time_id4;
1493: END IF;
1494:
1495: IF p_act_metric_fact_rec.time_id5 = FND_API.G_MISS_NUM THEN
1491: IF p_act_metric_fact_rec.time_id4 = FND_API.G_MISS_NUM THEN
1492: x_complete_fact_rec.time_id4 := l_act_metric_fact_rec.time_id4;
1493: END IF;
1494:
1495: IF p_act_metric_fact_rec.time_id5 = FND_API.G_MISS_NUM THEN
1496: x_complete_fact_rec.time_id5 := l_act_metric_fact_rec.time_id5;
1497: END IF;
1498:
1499: IF p_act_metric_fact_rec.time_id6 = FND_API.G_MISS_NUM THEN
1495: IF p_act_metric_fact_rec.time_id5 = FND_API.G_MISS_NUM THEN
1496: x_complete_fact_rec.time_id5 := l_act_metric_fact_rec.time_id5;
1497: END IF;
1498:
1499: IF p_act_metric_fact_rec.time_id6 = FND_API.G_MISS_NUM THEN
1500: x_complete_fact_rec.time_id6 := l_act_metric_fact_rec.time_id6;
1501: END IF;
1502:
1503: IF p_act_metric_fact_rec.time_id7 = FND_API.G_MISS_NUM THEN
1499: IF p_act_metric_fact_rec.time_id6 = FND_API.G_MISS_NUM THEN
1500: x_complete_fact_rec.time_id6 := l_act_metric_fact_rec.time_id6;
1501: END IF;
1502:
1503: IF p_act_metric_fact_rec.time_id7 = FND_API.G_MISS_NUM THEN
1504: x_complete_fact_rec.time_id7 := l_act_metric_fact_rec.time_id7;
1505: END IF;
1506:
1507: IF p_act_metric_fact_rec.time_id8 = FND_API.G_MISS_NUM THEN
1503: IF p_act_metric_fact_rec.time_id7 = FND_API.G_MISS_NUM THEN
1504: x_complete_fact_rec.time_id7 := l_act_metric_fact_rec.time_id7;
1505: END IF;
1506:
1507: IF p_act_metric_fact_rec.time_id8 = FND_API.G_MISS_NUM THEN
1508: x_complete_fact_rec.time_id8 := l_act_metric_fact_rec.time_id8;
1509: END IF;
1510:
1511: IF p_act_metric_fact_rec.time_id9 = FND_API.G_MISS_NUM THEN
1507: IF p_act_metric_fact_rec.time_id8 = FND_API.G_MISS_NUM THEN
1508: x_complete_fact_rec.time_id8 := l_act_metric_fact_rec.time_id8;
1509: END IF;
1510:
1511: IF p_act_metric_fact_rec.time_id9 = FND_API.G_MISS_NUM THEN
1512: x_complete_fact_rec.time_id9 := l_act_metric_fact_rec.time_id9;
1513: END IF;
1514:
1515: IF p_act_metric_fact_rec.time_id10 = FND_API.G_MISS_NUM THEN
1511: IF p_act_metric_fact_rec.time_id9 = FND_API.G_MISS_NUM THEN
1512: x_complete_fact_rec.time_id9 := l_act_metric_fact_rec.time_id9;
1513: END IF;
1514:
1515: IF p_act_metric_fact_rec.time_id10 = FND_API.G_MISS_NUM THEN
1516: x_complete_fact_rec.time_id10 := l_act_metric_fact_rec.time_id10;
1517: END IF;
1518:
1519: IF p_act_metric_fact_rec.time_id11 = FND_API.G_MISS_NUM THEN
1515: IF p_act_metric_fact_rec.time_id10 = FND_API.G_MISS_NUM THEN
1516: x_complete_fact_rec.time_id10 := l_act_metric_fact_rec.time_id10;
1517: END IF;
1518:
1519: IF p_act_metric_fact_rec.time_id11 = FND_API.G_MISS_NUM THEN
1520: x_complete_fact_rec.time_id11 := l_act_metric_fact_rec.time_id11;
1521: END IF;
1522:
1523: IF p_act_metric_fact_rec.time_id12 = FND_API.G_MISS_NUM THEN
1519: IF p_act_metric_fact_rec.time_id11 = FND_API.G_MISS_NUM THEN
1520: x_complete_fact_rec.time_id11 := l_act_metric_fact_rec.time_id11;
1521: END IF;
1522:
1523: IF p_act_metric_fact_rec.time_id12 = FND_API.G_MISS_NUM THEN
1524: x_complete_fact_rec.time_id12 := l_act_metric_fact_rec.time_id12;
1525: END IF;
1526:
1527: IF p_act_metric_fact_rec.time_id13 = FND_API.G_MISS_NUM THEN
1523: IF p_act_metric_fact_rec.time_id12 = FND_API.G_MISS_NUM THEN
1524: x_complete_fact_rec.time_id12 := l_act_metric_fact_rec.time_id12;
1525: END IF;
1526:
1527: IF p_act_metric_fact_rec.time_id13 = FND_API.G_MISS_NUM THEN
1528: x_complete_fact_rec.time_id13 := l_act_metric_fact_rec.time_id13;
1529: END IF;
1530:
1531: IF p_act_metric_fact_rec.time_id14 = FND_API.G_MISS_NUM THEN
1527: IF p_act_metric_fact_rec.time_id13 = FND_API.G_MISS_NUM THEN
1528: x_complete_fact_rec.time_id13 := l_act_metric_fact_rec.time_id13;
1529: END IF;
1530:
1531: IF p_act_metric_fact_rec.time_id14 = FND_API.G_MISS_NUM THEN
1532: x_complete_fact_rec.time_id14 := l_act_metric_fact_rec.time_id14;
1533: END IF;
1534:
1535: IF p_act_metric_fact_rec.time_id15 = FND_API.G_MISS_NUM THEN
1531: IF p_act_metric_fact_rec.time_id14 = FND_API.G_MISS_NUM THEN
1532: x_complete_fact_rec.time_id14 := l_act_metric_fact_rec.time_id14;
1533: END IF;
1534:
1535: IF p_act_metric_fact_rec.time_id15 = FND_API.G_MISS_NUM THEN
1536: x_complete_fact_rec.time_id15 := l_act_metric_fact_rec.time_id15;
1537: END IF;
1538:
1539: IF p_act_metric_fact_rec.time_id16 = FND_API.G_MISS_NUM THEN
1535: IF p_act_metric_fact_rec.time_id15 = FND_API.G_MISS_NUM THEN
1536: x_complete_fact_rec.time_id15 := l_act_metric_fact_rec.time_id15;
1537: END IF;
1538:
1539: IF p_act_metric_fact_rec.time_id16 = FND_API.G_MISS_NUM THEN
1540: x_complete_fact_rec.time_id16 := l_act_metric_fact_rec.time_id16;
1541: END IF;
1542:
1543: IF p_act_metric_fact_rec.time_id17 = FND_API.G_MISS_NUM THEN
1539: IF p_act_metric_fact_rec.time_id16 = FND_API.G_MISS_NUM THEN
1540: x_complete_fact_rec.time_id16 := l_act_metric_fact_rec.time_id16;
1541: END IF;
1542:
1543: IF p_act_metric_fact_rec.time_id17 = FND_API.G_MISS_NUM THEN
1544: x_complete_fact_rec.time_id17 := l_act_metric_fact_rec.time_id17;
1545: END IF;
1546:
1547: IF p_act_metric_fact_rec.time_id18 = FND_API.G_MISS_NUM THEN
1543: IF p_act_metric_fact_rec.time_id17 = FND_API.G_MISS_NUM THEN
1544: x_complete_fact_rec.time_id17 := l_act_metric_fact_rec.time_id17;
1545: END IF;
1546:
1547: IF p_act_metric_fact_rec.time_id18 = FND_API.G_MISS_NUM THEN
1548: x_complete_fact_rec.time_id18 := l_act_metric_fact_rec.time_id18;
1549: END IF;
1550:
1551: IF p_act_metric_fact_rec.time_id19 = FND_API.G_MISS_NUM THEN
1547: IF p_act_metric_fact_rec.time_id18 = FND_API.G_MISS_NUM THEN
1548: x_complete_fact_rec.time_id18 := l_act_metric_fact_rec.time_id18;
1549: END IF;
1550:
1551: IF p_act_metric_fact_rec.time_id19 = FND_API.G_MISS_NUM THEN
1552: x_complete_fact_rec.time_id19 := l_act_metric_fact_rec.time_id19;
1553: END IF;
1554:
1555: IF p_act_metric_fact_rec.time_id20 = FND_API.G_MISS_NUM THEN
1551: IF p_act_metric_fact_rec.time_id19 = FND_API.G_MISS_NUM THEN
1552: x_complete_fact_rec.time_id19 := l_act_metric_fact_rec.time_id19;
1553: END IF;
1554:
1555: IF p_act_metric_fact_rec.time_id20 = FND_API.G_MISS_NUM THEN
1556: x_complete_fact_rec.time_id20 := l_act_metric_fact_rec.time_id20;
1557: END IF;
1558:
1559: IF p_act_metric_fact_rec.time_id21 = FND_API.G_MISS_NUM THEN
1555: IF p_act_metric_fact_rec.time_id20 = FND_API.G_MISS_NUM THEN
1556: x_complete_fact_rec.time_id20 := l_act_metric_fact_rec.time_id20;
1557: END IF;
1558:
1559: IF p_act_metric_fact_rec.time_id21 = FND_API.G_MISS_NUM THEN
1560: x_complete_fact_rec.time_id21 := l_act_metric_fact_rec.time_id21;
1561: END IF;
1562:
1563: IF p_act_metric_fact_rec.time_id22 = FND_API.G_MISS_NUM THEN
1559: IF p_act_metric_fact_rec.time_id21 = FND_API.G_MISS_NUM THEN
1560: x_complete_fact_rec.time_id21 := l_act_metric_fact_rec.time_id21;
1561: END IF;
1562:
1563: IF p_act_metric_fact_rec.time_id22 = FND_API.G_MISS_NUM THEN
1564: x_complete_fact_rec.time_id22 := l_act_metric_fact_rec.time_id22;
1565: END IF;
1566:
1567: IF p_act_metric_fact_rec.time_id23 = FND_API.G_MISS_NUM THEN
1563: IF p_act_metric_fact_rec.time_id22 = FND_API.G_MISS_NUM THEN
1564: x_complete_fact_rec.time_id22 := l_act_metric_fact_rec.time_id22;
1565: END IF;
1566:
1567: IF p_act_metric_fact_rec.time_id23 = FND_API.G_MISS_NUM THEN
1568: x_complete_fact_rec.time_id23 := l_act_metric_fact_rec.time_id23;
1569: END IF;
1570:
1571: IF p_act_metric_fact_rec.time_id24 = FND_API.G_MISS_NUM THEN
1567: IF p_act_metric_fact_rec.time_id23 = FND_API.G_MISS_NUM THEN
1568: x_complete_fact_rec.time_id23 := l_act_metric_fact_rec.time_id23;
1569: END IF;
1570:
1571: IF p_act_metric_fact_rec.time_id24 = FND_API.G_MISS_NUM THEN
1572: x_complete_fact_rec.time_id24 := l_act_metric_fact_rec.time_id24;
1573: END IF;
1574:
1575: IF p_act_metric_fact_rec.time_id25 = FND_API.G_MISS_NUM THEN
1571: IF p_act_metric_fact_rec.time_id24 = FND_API.G_MISS_NUM THEN
1572: x_complete_fact_rec.time_id24 := l_act_metric_fact_rec.time_id24;
1573: END IF;
1574:
1575: IF p_act_metric_fact_rec.time_id25 = FND_API.G_MISS_NUM THEN
1576: x_complete_fact_rec.time_id25 := l_act_metric_fact_rec.time_id25;
1577: END IF;
1578:
1579: IF p_act_metric_fact_rec.time_id26 = FND_API.G_MISS_NUM THEN
1575: IF p_act_metric_fact_rec.time_id25 = FND_API.G_MISS_NUM THEN
1576: x_complete_fact_rec.time_id25 := l_act_metric_fact_rec.time_id25;
1577: END IF;
1578:
1579: IF p_act_metric_fact_rec.time_id26 = FND_API.G_MISS_NUM THEN
1580: x_complete_fact_rec.time_id26 := l_act_metric_fact_rec.time_id26;
1581: END IF;
1582:
1583: IF p_act_metric_fact_rec.time_id27 = FND_API.G_MISS_NUM THEN
1579: IF p_act_metric_fact_rec.time_id26 = FND_API.G_MISS_NUM THEN
1580: x_complete_fact_rec.time_id26 := l_act_metric_fact_rec.time_id26;
1581: END IF;
1582:
1583: IF p_act_metric_fact_rec.time_id27 = FND_API.G_MISS_NUM THEN
1584: x_complete_fact_rec.time_id27 := l_act_metric_fact_rec.time_id27;
1585: END IF;
1586:
1587: IF p_act_metric_fact_rec.time_id28 = FND_API.G_MISS_NUM THEN
1583: IF p_act_metric_fact_rec.time_id27 = FND_API.G_MISS_NUM THEN
1584: x_complete_fact_rec.time_id27 := l_act_metric_fact_rec.time_id27;
1585: END IF;
1586:
1587: IF p_act_metric_fact_rec.time_id28 = FND_API.G_MISS_NUM THEN
1588: x_complete_fact_rec.time_id28 := l_act_metric_fact_rec.time_id28;
1589: END IF;
1590:
1591: IF p_act_metric_fact_rec.time_id29 = FND_API.G_MISS_NUM THEN
1587: IF p_act_metric_fact_rec.time_id28 = FND_API.G_MISS_NUM THEN
1588: x_complete_fact_rec.time_id28 := l_act_metric_fact_rec.time_id28;
1589: END IF;
1590:
1591: IF p_act_metric_fact_rec.time_id29 = FND_API.G_MISS_NUM THEN
1592: x_complete_fact_rec.time_id29 := l_act_metric_fact_rec.time_id29;
1593: END IF;
1594:
1595: IF p_act_metric_fact_rec.time_id30 = FND_API.G_MISS_NUM THEN
1591: IF p_act_metric_fact_rec.time_id29 = FND_API.G_MISS_NUM THEN
1592: x_complete_fact_rec.time_id29 := l_act_metric_fact_rec.time_id29;
1593: END IF;
1594:
1595: IF p_act_metric_fact_rec.time_id30 = FND_API.G_MISS_NUM THEN
1596: x_complete_fact_rec.time_id30 := l_act_metric_fact_rec.time_id30;
1597: END IF;
1598:
1599: IF p_act_metric_fact_rec.time_id31 = FND_API.G_MISS_NUM THEN
1595: IF p_act_metric_fact_rec.time_id30 = FND_API.G_MISS_NUM THEN
1596: x_complete_fact_rec.time_id30 := l_act_metric_fact_rec.time_id30;
1597: END IF;
1598:
1599: IF p_act_metric_fact_rec.time_id31 = FND_API.G_MISS_NUM THEN
1600: x_complete_fact_rec.time_id31 := l_act_metric_fact_rec.time_id31;
1601: END IF;
1602:
1603: IF p_act_metric_fact_rec.time_id32 = FND_API.G_MISS_NUM THEN
1599: IF p_act_metric_fact_rec.time_id31 = FND_API.G_MISS_NUM THEN
1600: x_complete_fact_rec.time_id31 := l_act_metric_fact_rec.time_id31;
1601: END IF;
1602:
1603: IF p_act_metric_fact_rec.time_id32 = FND_API.G_MISS_NUM THEN
1604: x_complete_fact_rec.time_id32 := l_act_metric_fact_rec.time_id32;
1605: END IF;
1606:
1607: IF p_act_metric_fact_rec.time_id33 = FND_API.G_MISS_NUM THEN
1603: IF p_act_metric_fact_rec.time_id32 = FND_API.G_MISS_NUM THEN
1604: x_complete_fact_rec.time_id32 := l_act_metric_fact_rec.time_id32;
1605: END IF;
1606:
1607: IF p_act_metric_fact_rec.time_id33 = FND_API.G_MISS_NUM THEN
1608: x_complete_fact_rec.time_id33 := l_act_metric_fact_rec.time_id33;
1609: END IF;
1610:
1611: IF p_act_metric_fact_rec.time_id34 = FND_API.G_MISS_NUM THEN
1607: IF p_act_metric_fact_rec.time_id33 = FND_API.G_MISS_NUM THEN
1608: x_complete_fact_rec.time_id33 := l_act_metric_fact_rec.time_id33;
1609: END IF;
1610:
1611: IF p_act_metric_fact_rec.time_id34 = FND_API.G_MISS_NUM THEN
1612: x_complete_fact_rec.time_id34 := l_act_metric_fact_rec.time_id34;
1613: END IF;
1614:
1615: IF p_act_metric_fact_rec.time_id35 = FND_API.G_MISS_NUM THEN
1611: IF p_act_metric_fact_rec.time_id34 = FND_API.G_MISS_NUM THEN
1612: x_complete_fact_rec.time_id34 := l_act_metric_fact_rec.time_id34;
1613: END IF;
1614:
1615: IF p_act_metric_fact_rec.time_id35 = FND_API.G_MISS_NUM THEN
1616: x_complete_fact_rec.time_id35 := l_act_metric_fact_rec.time_id35;
1617: END IF;
1618:
1619: IF p_act_metric_fact_rec.time_id36 = FND_API.G_MISS_NUM THEN
1615: IF p_act_metric_fact_rec.time_id35 = FND_API.G_MISS_NUM THEN
1616: x_complete_fact_rec.time_id35 := l_act_metric_fact_rec.time_id35;
1617: END IF;
1618:
1619: IF p_act_metric_fact_rec.time_id36 = FND_API.G_MISS_NUM THEN
1620: x_complete_fact_rec.time_id36 := l_act_metric_fact_rec.time_id36;
1621: END IF;
1622:
1623: IF p_act_metric_fact_rec.time_id37 = FND_API.G_MISS_NUM THEN
1619: IF p_act_metric_fact_rec.time_id36 = FND_API.G_MISS_NUM THEN
1620: x_complete_fact_rec.time_id36 := l_act_metric_fact_rec.time_id36;
1621: END IF;
1622:
1623: IF p_act_metric_fact_rec.time_id37 = FND_API.G_MISS_NUM THEN
1624: x_complete_fact_rec.time_id37 := l_act_metric_fact_rec.time_id37;
1625: END IF;
1626:
1627: IF p_act_metric_fact_rec.time_id38 = FND_API.G_MISS_NUM THEN
1623: IF p_act_metric_fact_rec.time_id37 = FND_API.G_MISS_NUM THEN
1624: x_complete_fact_rec.time_id37 := l_act_metric_fact_rec.time_id37;
1625: END IF;
1626:
1627: IF p_act_metric_fact_rec.time_id38 = FND_API.G_MISS_NUM THEN
1628: x_complete_fact_rec.time_id38 := l_act_metric_fact_rec.time_id38;
1629: END IF;
1630:
1631: IF p_act_metric_fact_rec.time_id39 = FND_API.G_MISS_NUM THEN
1627: IF p_act_metric_fact_rec.time_id38 = FND_API.G_MISS_NUM THEN
1628: x_complete_fact_rec.time_id38 := l_act_metric_fact_rec.time_id38;
1629: END IF;
1630:
1631: IF p_act_metric_fact_rec.time_id39 = FND_API.G_MISS_NUM THEN
1632: x_complete_fact_rec.time_id39 := l_act_metric_fact_rec.time_id39;
1633: END IF;
1634:
1635: IF p_act_metric_fact_rec.time_id40 = FND_API.G_MISS_NUM THEN
1631: IF p_act_metric_fact_rec.time_id39 = FND_API.G_MISS_NUM THEN
1632: x_complete_fact_rec.time_id39 := l_act_metric_fact_rec.time_id39;
1633: END IF;
1634:
1635: IF p_act_metric_fact_rec.time_id40 = FND_API.G_MISS_NUM THEN
1636: x_complete_fact_rec.time_id40 := l_act_metric_fact_rec.time_id40;
1637: END IF;
1638:
1639: IF p_act_metric_fact_rec.time_id41 = FND_API.G_MISS_NUM THEN
1635: IF p_act_metric_fact_rec.time_id40 = FND_API.G_MISS_NUM THEN
1636: x_complete_fact_rec.time_id40 := l_act_metric_fact_rec.time_id40;
1637: END IF;
1638:
1639: IF p_act_metric_fact_rec.time_id41 = FND_API.G_MISS_NUM THEN
1640: x_complete_fact_rec.time_id41 := l_act_metric_fact_rec.time_id41;
1641: END IF;
1642:
1643: IF p_act_metric_fact_rec.time_id42 = FND_API.G_MISS_NUM THEN
1639: IF p_act_metric_fact_rec.time_id41 = FND_API.G_MISS_NUM THEN
1640: x_complete_fact_rec.time_id41 := l_act_metric_fact_rec.time_id41;
1641: END IF;
1642:
1643: IF p_act_metric_fact_rec.time_id42 = FND_API.G_MISS_NUM THEN
1644: x_complete_fact_rec.time_id42 := l_act_metric_fact_rec.time_id42;
1645: END IF;
1646:
1647: IF p_act_metric_fact_rec.time_id43 = FND_API.G_MISS_NUM THEN
1643: IF p_act_metric_fact_rec.time_id42 = FND_API.G_MISS_NUM THEN
1644: x_complete_fact_rec.time_id42 := l_act_metric_fact_rec.time_id42;
1645: END IF;
1646:
1647: IF p_act_metric_fact_rec.time_id43 = FND_API.G_MISS_NUM THEN
1648: x_complete_fact_rec.time_id43 := l_act_metric_fact_rec.time_id43;
1649: END IF;
1650:
1651: IF p_act_metric_fact_rec.time_id44 = FND_API.G_MISS_NUM THEN
1647: IF p_act_metric_fact_rec.time_id43 = FND_API.G_MISS_NUM THEN
1648: x_complete_fact_rec.time_id43 := l_act_metric_fact_rec.time_id43;
1649: END IF;
1650:
1651: IF p_act_metric_fact_rec.time_id44 = FND_API.G_MISS_NUM THEN
1652: x_complete_fact_rec.time_id44 := l_act_metric_fact_rec.time_id44;
1653: END IF;
1654:
1655: IF p_act_metric_fact_rec.time_id45 = FND_API.G_MISS_NUM THEN
1651: IF p_act_metric_fact_rec.time_id44 = FND_API.G_MISS_NUM THEN
1652: x_complete_fact_rec.time_id44 := l_act_metric_fact_rec.time_id44;
1653: END IF;
1654:
1655: IF p_act_metric_fact_rec.time_id45 = FND_API.G_MISS_NUM THEN
1656: x_complete_fact_rec.time_id45 := l_act_metric_fact_rec.time_id45;
1657: END IF;
1658:
1659: IF p_act_metric_fact_rec.time_id46 = FND_API.G_MISS_NUM THEN
1655: IF p_act_metric_fact_rec.time_id45 = FND_API.G_MISS_NUM THEN
1656: x_complete_fact_rec.time_id45 := l_act_metric_fact_rec.time_id45;
1657: END IF;
1658:
1659: IF p_act_metric_fact_rec.time_id46 = FND_API.G_MISS_NUM THEN
1660: x_complete_fact_rec.time_id46 := l_act_metric_fact_rec.time_id46;
1661: END IF;
1662:
1663: IF p_act_metric_fact_rec.time_id47 = FND_API.G_MISS_NUM THEN
1659: IF p_act_metric_fact_rec.time_id46 = FND_API.G_MISS_NUM THEN
1660: x_complete_fact_rec.time_id46 := l_act_metric_fact_rec.time_id46;
1661: END IF;
1662:
1663: IF p_act_metric_fact_rec.time_id47 = FND_API.G_MISS_NUM THEN
1664: x_complete_fact_rec.time_id47 := l_act_metric_fact_rec.time_id47;
1665: END IF;
1666:
1667: IF p_act_metric_fact_rec.time_id48 = FND_API.G_MISS_NUM THEN
1663: IF p_act_metric_fact_rec.time_id47 = FND_API.G_MISS_NUM THEN
1664: x_complete_fact_rec.time_id47 := l_act_metric_fact_rec.time_id47;
1665: END IF;
1666:
1667: IF p_act_metric_fact_rec.time_id48 = FND_API.G_MISS_NUM THEN
1668: x_complete_fact_rec.time_id48 := l_act_metric_fact_rec.time_id48;
1669: END IF;
1670:
1671: IF p_act_metric_fact_rec.time_id49 = FND_API.G_MISS_NUM THEN
1667: IF p_act_metric_fact_rec.time_id48 = FND_API.G_MISS_NUM THEN
1668: x_complete_fact_rec.time_id48 := l_act_metric_fact_rec.time_id48;
1669: END IF;
1670:
1671: IF p_act_metric_fact_rec.time_id49 = FND_API.G_MISS_NUM THEN
1672: x_complete_fact_rec.time_id49 := l_act_metric_fact_rec.time_id49;
1673: END IF;
1674:
1675: IF p_act_metric_fact_rec.time_id50 = FND_API.G_MISS_NUM THEN
1671: IF p_act_metric_fact_rec.time_id49 = FND_API.G_MISS_NUM THEN
1672: x_complete_fact_rec.time_id49 := l_act_metric_fact_rec.time_id49;
1673: END IF;
1674:
1675: IF p_act_metric_fact_rec.time_id50 = FND_API.G_MISS_NUM THEN
1676: x_complete_fact_rec.time_id50 := l_act_metric_fact_rec.time_id50;
1677: END IF;
1678:
1679: IF p_act_metric_fact_rec.time_id51 = FND_API.G_MISS_NUM THEN
1675: IF p_act_metric_fact_rec.time_id50 = FND_API.G_MISS_NUM THEN
1676: x_complete_fact_rec.time_id50 := l_act_metric_fact_rec.time_id50;
1677: END IF;
1678:
1679: IF p_act_metric_fact_rec.time_id51 = FND_API.G_MISS_NUM THEN
1680: x_complete_fact_rec.time_id51 := l_act_metric_fact_rec.time_id51;
1681: END IF;
1682:
1683: IF p_act_metric_fact_rec.time_id52 = FND_API.G_MISS_NUM THEN
1679: IF p_act_metric_fact_rec.time_id51 = FND_API.G_MISS_NUM THEN
1680: x_complete_fact_rec.time_id51 := l_act_metric_fact_rec.time_id51;
1681: END IF;
1682:
1683: IF p_act_metric_fact_rec.time_id52 = FND_API.G_MISS_NUM THEN
1684: x_complete_fact_rec.time_id52 := l_act_metric_fact_rec.time_id52;
1685: END IF;
1686:
1687: IF p_act_metric_fact_rec.time_id53 = FND_API.G_MISS_NUM THEN
1683: IF p_act_metric_fact_rec.time_id52 = FND_API.G_MISS_NUM THEN
1684: x_complete_fact_rec.time_id52 := l_act_metric_fact_rec.time_id52;
1685: END IF;
1686:
1687: IF p_act_metric_fact_rec.time_id53 = FND_API.G_MISS_NUM THEN
1688: x_complete_fact_rec.time_id53 := l_act_metric_fact_rec.time_id53;
1689: END IF;
1690:
1691: IF p_act_metric_fact_rec.hierarchy_id = FND_API.G_MISS_NUM THEN
1687: IF p_act_metric_fact_rec.time_id53 = FND_API.G_MISS_NUM THEN
1688: x_complete_fact_rec.time_id53 := l_act_metric_fact_rec.time_id53;
1689: END IF;
1690:
1691: IF p_act_metric_fact_rec.hierarchy_id = FND_API.G_MISS_NUM THEN
1692: x_complete_fact_rec.hierarchy_id := l_act_metric_fact_rec.hierarchy_id;
1693: END IF;
1694:
1695: IF p_act_metric_fact_rec.node_id = FND_API.G_MISS_NUM THEN
1691: IF p_act_metric_fact_rec.hierarchy_id = FND_API.G_MISS_NUM THEN
1692: x_complete_fact_rec.hierarchy_id := l_act_metric_fact_rec.hierarchy_id;
1693: END IF;
1694:
1695: IF p_act_metric_fact_rec.node_id = FND_API.G_MISS_NUM THEN
1696: x_complete_fact_rec.node_id := l_act_metric_fact_rec.node_id;
1697: END IF;
1698:
1699: IF p_act_metric_fact_rec.level_depth = FND_API.G_MISS_NUM THEN
1695: IF p_act_metric_fact_rec.node_id = FND_API.G_MISS_NUM THEN
1696: x_complete_fact_rec.node_id := l_act_metric_fact_rec.node_id;
1697: END IF;
1698:
1699: IF p_act_metric_fact_rec.level_depth = FND_API.G_MISS_NUM THEN
1700: x_complete_fact_rec.level_depth := l_act_metric_fact_rec.level_depth;
1701: END IF;
1702:
1703: IF p_act_metric_fact_rec.formula_id = FND_API.G_MISS_NUM THEN
1699: IF p_act_metric_fact_rec.level_depth = FND_API.G_MISS_NUM THEN
1700: x_complete_fact_rec.level_depth := l_act_metric_fact_rec.level_depth;
1701: END IF;
1702:
1703: IF p_act_metric_fact_rec.formula_id = FND_API.G_MISS_NUM THEN
1704: x_complete_fact_rec.formula_id := l_act_metric_fact_rec.formula_id;
1705: END IF;
1706:
1707: IF p_act_metric_fact_rec.from_date = FND_API.G_MISS_DATE THEN
1703: IF p_act_metric_fact_rec.formula_id = FND_API.G_MISS_NUM THEN
1704: x_complete_fact_rec.formula_id := l_act_metric_fact_rec.formula_id;
1705: END IF;
1706:
1707: IF p_act_metric_fact_rec.from_date = FND_API.G_MISS_DATE THEN
1708: x_complete_fact_rec.from_date := l_act_metric_fact_rec.from_date;
1709: END IF;
1710:
1711: IF p_act_metric_fact_rec.to_date = FND_API.G_MISS_DATE THEN
1707: IF p_act_metric_fact_rec.from_date = FND_API.G_MISS_DATE THEN
1708: x_complete_fact_rec.from_date := l_act_metric_fact_rec.from_date;
1709: END IF;
1710:
1711: IF p_act_metric_fact_rec.to_date = FND_API.G_MISS_DATE THEN
1712: x_complete_fact_rec.to_date := l_act_metric_fact_rec.to_date;
1713: END IF;
1714:
1715: IF p_act_metric_fact_rec.fact_value = FND_API.G_MISS_NUM THEN
1711: IF p_act_metric_fact_rec.to_date = FND_API.G_MISS_DATE THEN
1712: x_complete_fact_rec.to_date := l_act_metric_fact_rec.to_date;
1713: END IF;
1714:
1715: IF p_act_metric_fact_rec.fact_value = FND_API.G_MISS_NUM THEN
1716: x_complete_fact_rec.fact_value := l_act_metric_fact_rec.fact_value;
1717: END IF;
1718:
1719: IF p_act_metric_fact_rec.fact_percent = FND_API.G_MISS_NUM THEN
1715: IF p_act_metric_fact_rec.fact_value = FND_API.G_MISS_NUM THEN
1716: x_complete_fact_rec.fact_value := l_act_metric_fact_rec.fact_value;
1717: END IF;
1718:
1719: IF p_act_metric_fact_rec.fact_percent = FND_API.G_MISS_NUM THEN
1720: x_complete_fact_rec.fact_percent := l_act_metric_fact_rec.fact_percent;
1721: END IF;
1722:
1723: IF p_act_metric_fact_rec.root_fact_id = FND_API.G_MISS_NUM THEN
1719: IF p_act_metric_fact_rec.fact_percent = FND_API.G_MISS_NUM THEN
1720: x_complete_fact_rec.fact_percent := l_act_metric_fact_rec.fact_percent;
1721: END IF;
1722:
1723: IF p_act_metric_fact_rec.root_fact_id = FND_API.G_MISS_NUM THEN
1724: x_complete_fact_rec.root_fact_id := l_act_metric_fact_rec.root_fact_id;
1725: END IF;
1726:
1727: IF p_act_metric_fact_rec.previous_fact_id = FND_API.G_MISS_NUM THEN
1723: IF p_act_metric_fact_rec.root_fact_id = FND_API.G_MISS_NUM THEN
1724: x_complete_fact_rec.root_fact_id := l_act_metric_fact_rec.root_fact_id;
1725: END IF;
1726:
1727: IF p_act_metric_fact_rec.previous_fact_id = FND_API.G_MISS_NUM THEN
1728: x_complete_fact_rec.previous_fact_id := l_act_metric_fact_rec.previous_fact_id;
1729: END IF;
1730:
1731: IF p_act_metric_fact_rec.fact_type = FND_API.G_MISS_CHAR THEN
1727: IF p_act_metric_fact_rec.previous_fact_id = FND_API.G_MISS_NUM THEN
1728: x_complete_fact_rec.previous_fact_id := l_act_metric_fact_rec.previous_fact_id;
1729: END IF;
1730:
1731: IF p_act_metric_fact_rec.fact_type = FND_API.G_MISS_CHAR THEN
1732: x_complete_fact_rec.fact_type := l_act_metric_fact_rec.fact_type;
1733: END IF;
1734:
1735: IF p_act_metric_fact_rec.fact_reference = FND_API.G_MISS_CHAR THEN
1731: IF p_act_metric_fact_rec.fact_type = FND_API.G_MISS_CHAR THEN
1732: x_complete_fact_rec.fact_type := l_act_metric_fact_rec.fact_type;
1733: END IF;
1734:
1735: IF p_act_metric_fact_rec.fact_reference = FND_API.G_MISS_CHAR THEN
1736: x_complete_fact_rec.fact_reference := l_act_metric_fact_rec.fact_reference;
1737: END IF;
1738:
1739: IF p_act_metric_fact_rec.forward_buy_quantity = FND_API.G_MISS_NUM THEN
1735: IF p_act_metric_fact_rec.fact_reference = FND_API.G_MISS_CHAR THEN
1736: x_complete_fact_rec.fact_reference := l_act_metric_fact_rec.fact_reference;
1737: END IF;
1738:
1739: IF p_act_metric_fact_rec.forward_buy_quantity = FND_API.G_MISS_NUM THEN
1740: x_complete_fact_rec.forward_buy_quantity := l_act_metric_fact_rec.forward_buy_quantity;
1741: END IF;
1742:
1743: /* 05/21/2002 yzhao: add 11 new columns for top-down bottom-up budgeting */
1740: x_complete_fact_rec.forward_buy_quantity := l_act_metric_fact_rec.forward_buy_quantity;
1741: END IF;
1742:
1743: /* 05/21/2002 yzhao: add 11 new columns for top-down bottom-up budgeting */
1744: IF p_act_metric_fact_rec.status_code = FND_API.G_MISS_CHAR THEN
1745: x_complete_fact_rec.status_code := l_act_metric_fact_rec.status_code;
1746: END IF;
1747:
1748: IF p_act_metric_fact_rec.hierarchy_type = FND_API.G_MISS_CHAR THEN
1744: IF p_act_metric_fact_rec.status_code = FND_API.G_MISS_CHAR THEN
1745: x_complete_fact_rec.status_code := l_act_metric_fact_rec.status_code;
1746: END IF;
1747:
1748: IF p_act_metric_fact_rec.hierarchy_type = FND_API.G_MISS_CHAR THEN
1749: x_complete_fact_rec.hierarchy_type := l_act_metric_fact_rec.hierarchy_type;
1750: END IF;
1751:
1752: IF p_act_metric_fact_rec.approval_date = FND_API.G_MISS_DATE THEN
1748: IF p_act_metric_fact_rec.hierarchy_type = FND_API.G_MISS_CHAR THEN
1749: x_complete_fact_rec.hierarchy_type := l_act_metric_fact_rec.hierarchy_type;
1750: END IF;
1751:
1752: IF p_act_metric_fact_rec.approval_date = FND_API.G_MISS_DATE THEN
1753: x_complete_fact_rec.approval_date := l_act_metric_fact_rec.approval_date;
1754: END IF;
1755:
1756: IF p_act_metric_fact_rec.recommend_total_amount = FND_API.G_MISS_NUM THEN
1752: IF p_act_metric_fact_rec.approval_date = FND_API.G_MISS_DATE THEN
1753: x_complete_fact_rec.approval_date := l_act_metric_fact_rec.approval_date;
1754: END IF;
1755:
1756: IF p_act_metric_fact_rec.recommend_total_amount = FND_API.G_MISS_NUM THEN
1757: x_complete_fact_rec.recommend_total_amount := l_act_metric_fact_rec.recommend_total_amount;
1758: END IF;
1759:
1760: IF p_act_metric_fact_rec.recommend_hb_amount = FND_API.G_MISS_NUM THEN
1756: IF p_act_metric_fact_rec.recommend_total_amount = FND_API.G_MISS_NUM THEN
1757: x_complete_fact_rec.recommend_total_amount := l_act_metric_fact_rec.recommend_total_amount;
1758: END IF;
1759:
1760: IF p_act_metric_fact_rec.recommend_hb_amount = FND_API.G_MISS_NUM THEN
1761: x_complete_fact_rec.recommend_hb_amount := l_act_metric_fact_rec.recommend_hb_amount;
1762: END IF;
1763:
1764: IF p_act_metric_fact_rec.request_total_amount = FND_API.G_MISS_NUM THEN
1760: IF p_act_metric_fact_rec.recommend_hb_amount = FND_API.G_MISS_NUM THEN
1761: x_complete_fact_rec.recommend_hb_amount := l_act_metric_fact_rec.recommend_hb_amount;
1762: END IF;
1763:
1764: IF p_act_metric_fact_rec.request_total_amount = FND_API.G_MISS_NUM THEN
1765: x_complete_fact_rec.request_total_amount := l_act_metric_fact_rec.request_total_amount;
1766: END IF;
1767:
1768: IF p_act_metric_fact_rec.request_hb_amount = FND_API.G_MISS_NUM THEN
1764: IF p_act_metric_fact_rec.request_total_amount = FND_API.G_MISS_NUM THEN
1765: x_complete_fact_rec.request_total_amount := l_act_metric_fact_rec.request_total_amount;
1766: END IF;
1767:
1768: IF p_act_metric_fact_rec.request_hb_amount = FND_API.G_MISS_NUM THEN
1769: x_complete_fact_rec.request_hb_amount := l_act_metric_fact_rec.request_hb_amount;
1770: END IF;
1771:
1772: IF p_act_metric_fact_rec.actual_total_amount = FND_API.G_MISS_NUM THEN
1768: IF p_act_metric_fact_rec.request_hb_amount = FND_API.G_MISS_NUM THEN
1769: x_complete_fact_rec.request_hb_amount := l_act_metric_fact_rec.request_hb_amount;
1770: END IF;
1771:
1772: IF p_act_metric_fact_rec.actual_total_amount = FND_API.G_MISS_NUM THEN
1773: x_complete_fact_rec.actual_total_amount := l_act_metric_fact_rec.actual_total_amount;
1774: END IF;
1775:
1776: IF p_act_metric_fact_rec.actual_hb_amount = FND_API.G_MISS_NUM THEN
1772: IF p_act_metric_fact_rec.actual_total_amount = FND_API.G_MISS_NUM THEN
1773: x_complete_fact_rec.actual_total_amount := l_act_metric_fact_rec.actual_total_amount;
1774: END IF;
1775:
1776: IF p_act_metric_fact_rec.actual_hb_amount = FND_API.G_MISS_NUM THEN
1777: x_complete_fact_rec.actual_hb_amount := l_act_metric_fact_rec.actual_hb_amount;
1778: END IF;
1779:
1780: IF p_act_metric_fact_rec.base_total_pct = FND_API.G_MISS_NUM THEN
1776: IF p_act_metric_fact_rec.actual_hb_amount = FND_API.G_MISS_NUM THEN
1777: x_complete_fact_rec.actual_hb_amount := l_act_metric_fact_rec.actual_hb_amount;
1778: END IF;
1779:
1780: IF p_act_metric_fact_rec.base_total_pct = FND_API.G_MISS_NUM THEN
1781: x_complete_fact_rec.base_total_pct := l_act_metric_fact_rec.base_total_pct;
1782: END IF;
1783:
1784: IF p_act_metric_fact_rec.base_hb_pct = FND_API.G_MISS_NUM THEN
1780: IF p_act_metric_fact_rec.base_total_pct = FND_API.G_MISS_NUM THEN
1781: x_complete_fact_rec.base_total_pct := l_act_metric_fact_rec.base_total_pct;
1782: END IF;
1783:
1784: IF p_act_metric_fact_rec.base_hb_pct = FND_API.G_MISS_NUM THEN
1785: x_complete_fact_rec.base_hb_pct := l_act_metric_fact_rec.base_hb_pct;
1786: END IF;
1787: /* 05/21/2002 yzhao: add ends */
1788:
1806: -- End of comments
1807:
1808: PROCEDURE Delete_ActMetricFact (
1809: p_api_version IN NUMBER,
1810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1812:
1813: x_return_status OUT NOCOPY VARCHAR2,
1814: x_msg_count OUT NOCOPY NUMBER,
1807:
1808: PROCEDURE Delete_ActMetricFact (
1809: p_api_version IN NUMBER,
1810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1812:
1813: x_return_status OUT NOCOPY VARCHAR2,
1814: x_msg_count OUT NOCOPY NUMBER,
1815: x_msg_data OUT NOCOPY VARCHAR2,
1841:
1842: --
1843: -- Initialize message list if p_init_msg_list is set to TRUE.
1844: --
1845: IF FND_API.To_Boolean (p_init_msg_list) THEN
1846: FND_MSG_PUB.Initialize;
1847: END IF;
1848:
1849: --
1848:
1849: --
1850: -- Standard check for API version compatibility.
1851: --
1852: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1853: p_api_version,
1854: L_API_NAME,
1855: G_PKG_NAME)
1856: THEN
1853: p_api_version,
1854: L_API_NAME,
1855: G_PKG_NAME)
1856: THEN
1857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1858: END IF;
1859:
1860: --
1861: -- Initialize API return status to success.
1859:
1860: --
1861: -- Initialize API return status to success.
1862: --
1863: x_return_status := FND_API.G_RET_STS_SUCCESS;
1864:
1865: --
1866: -- Begin API Body.
1867: --
1891: THEN
1892: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1893: FND_MSG_PUB.add;
1894: END IF;
1895: RAISE FND_API.g_exc_error;
1896: END IF;
1897:
1898:
1899: --
1899: --
1900: -- End API Body.
1901: --
1902:
1903: IF FND_API.To_Boolean (p_commit) THEN
1904: COMMIT WORK;
1905: END IF;
1906:
1907: --
1919: --
1920: FND_MSG_PUB.Count_And_Get (
1921: p_count => x_msg_count,
1922: p_data => x_msg_data,
1923: p_encoded => FND_API.G_FALSE
1924: );
1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1923: p_encoded => FND_API.G_FALSE
1924: );
1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO Delete_ActMetricFact_pvt;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930: FND_MSG_PUB.Count_And_Get (
1931: p_count => x_msg_count,
1925:
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO Delete_ActMetricFact_pvt;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930: FND_MSG_PUB.Count_And_Get (
1931: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1930: FND_MSG_PUB.Count_And_Get (
1931: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1935: ROLLBACK TO Delete_ActMetricFact_pvt;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: FND_MSG_PUB.Count_And_Get (
1938: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );
1934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1935: ROLLBACK TO Delete_ActMetricFact_pvt;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: FND_MSG_PUB.Count_And_Get (
1938: p_count => x_msg_count,
1939: p_data => x_msg_data
1940: );
1939: p_data => x_msg_data
1940: );
1941: WHEN OTHERS THEN
1942: ROLLBACK TO Delete_ActMetricFact_pvt;
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1945: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1946: END IF;
1947: FND_MSG_PUB.Count_And_Get (
1967: -- End of comments
1968:
1969: PROCEDURE Validate_ActMetFact (
1970: p_api_version IN NUMBER,
1971: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1972: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
1973:
1974: x_return_status OUT NOCOPY VARCHAR2,
1975: x_msg_count OUT NOCOPY NUMBER,
1968:
1969: PROCEDURE Validate_ActMetFact (
1970: p_api_version IN NUMBER,
1971: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1972: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
1973:
1974: x_return_status OUT NOCOPY VARCHAR2,
1975: x_msg_count OUT NOCOPY NUMBER,
1976: x_msg_data OUT NOCOPY VARCHAR2,
1996:
1997: --
1998: -- Initialize message list if p_init_msg_list is set to TRUE.
1999: --
2000: IF FND_API.To_Boolean (p_init_msg_list) THEN
2001: FND_MSG_PUB.Initialize;
2002: END IF;
2003:
2004: --
2003:
2004: --
2005: -- Standard check for API version compatibility.
2006: --
2007: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
2008: p_api_version,
2009: L_API_NAME,
2010: G_PKG_NAME)
2011: THEN
2008: p_api_version,
2009: L_API_NAME,
2010: G_PKG_NAME)
2011: THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: --
2016: -- Initialize API return status to success.
2014:
2015: --
2016: -- Initialize API return status to success.
2017: --
2018: x_return_status := FND_API.G_RET_STS_SUCCESS;
2019:
2020: --
2021: -- Begin API Body.
2022: --
2040: x_return_status => l_return_status
2041: );
2042:
2043: -- If any errors happen abort API.
2044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2041: );
2042:
2043: -- If any errors happen abort API.
2044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2049: END IF;
2042:
2043: -- If any errors happen abort API.
2044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2049: END IF;
2050:
2043: -- If any errors happen abort API.
2044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2049: END IF;
2050:
2051: IF (AMS_DEBUG_HIGH_ON) THEN
2065: p_complete_fact_rec => NULL,
2066: x_return_status => l_return_status
2067: );
2068:
2069: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2072: RAISE FND_API.g_exc_error;
2073: END IF;
2066: x_return_status => l_return_status
2067: );
2068:
2069: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2072: RAISE FND_API.g_exc_error;
2073: END IF;
2074: END IF;
2067: );
2068:
2069: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2072: RAISE FND_API.g_exc_error;
2073: END IF;
2074: END IF;
2075:
2068:
2069: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2070: RAISE FND_API.g_exc_unexpected_error;
2071: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2072: RAISE FND_API.g_exc_error;
2073: END IF;
2074: END IF;
2075:
2076:
2085: --
2086: FND_MSG_PUB.Count_And_Get (
2087: p_count => x_msg_count,
2088: p_data => x_msg_data,
2089: p_encoded => FND_API.G_FALSE
2090: );
2091:
2092:
2093:
2107:
2108:
2109:
2110: EXCEPTION
2111: WHEN FND_API.G_EXC_ERROR THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: FND_MSG_PUB.Count_And_Get (
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2108:
2109:
2110: EXCEPTION
2111: WHEN FND_API.G_EXC_ERROR THEN
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: FND_MSG_PUB.Count_And_Get (
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2113: FND_MSG_PUB.Count_And_Get (
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: FND_MSG_PUB.Count_And_Get (
2120: p_count => x_msg_count,
2121: p_data => x_msg_data
2114: p_count => x_msg_count,
2115: p_data => x_msg_data
2116: );
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2119: FND_MSG_PUB.Count_And_Get (
2120: p_count => x_msg_count,
2121: p_data => x_msg_data
2122: );
2120: p_count => x_msg_count,
2121: p_data => x_msg_data
2122: );
2123: WHEN OTHERS THEN
2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2125: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2126: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2127: END IF;
2128: FND_MSG_PUB.Count_And_Get (
2153: )
2154: IS
2155: BEGIN
2156: -- Initialize return status to success.
2157: x_return_status := FND_API.G_RET_STS_SUCCESS;
2158:
2159: --ACT_METRIC_USED_BY_ID
2160:
2161:
2169: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
2170: FND_MSG_PUB.Add;
2171: END IF;
2172:
2173: x_return_status := FND_API.G_RET_STS_ERROR;
2174:
2175: -- If any error happens abort API.
2176: RETURN;
2177: END IF;
2188: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
2189: FND_MSG_PUB.Add;
2190: END IF;
2191:
2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193:
2194: -- If any error happens abort API.
2195: RETURN;
2196: END IF;
2207: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_VAL_TYPE');
2208: FND_MSG_PUB.Add;
2209: END IF;
2210:
2211: x_return_status := FND_API.G_RET_STS_ERROR;
2212:
2213: -- If any error happens abort API.
2214: RETURN;
2215: END IF;
2227: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_ACT_METRIC_ID');
2228: FND_MSG_PUB.Add;
2229: END IF;
2230:
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232:
2233: -- If any error happens abort API.
2234: RETURN;
2235: END IF;
2246: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_TRAN_FCST_VAL');
2247: FND_MSG_PUB.Add;
2248: END IF;
2249:
2250: x_return_status := FND_API.G_RET_STS_ERROR;
2251:
2252: -- If any error happens abort API.
2253: RETURN;
2254: END IF;
2265: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_FUNC_CUR_CODE');
2266: FND_MSG_PUB.Add;
2267: END IF;
2268:
2269: x_return_status := FND_API.G_RET_STS_ERROR;
2270:
2271: -- If any error happens abort API.
2272: RETURN;
2273: END IF;
2284: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_FUNC_FCST_VAL');
2285: FND_MSG_PUB.Add;
2286: END IF;
2287:
2288: x_return_status := FND_API.G_RET_STS_ERROR;
2289:
2290: -- If any error happens abort API.
2291: RETURN;
2292: END IF;
2304: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
2305: FND_MSG_PUB.Add;
2306: END IF;
2307:
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309:
2310: -- If any error happens abort API.
2311: RETURN;
2312: END IF;
2324: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_TIME_ID1');
2325: FND_MSG_PUB.Add;
2326: END IF;
2327:
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329:
2330: -- If any error happens abort API.
2331: RETURN;
2332: END IF;
2335:
2336: -------------------------------------------------------------------------------------
2337: --When a Hierarchy Id is present then the node_id and fact_value fields are mandatory
2338: -------------------------------------------------------------------------------------
2339: IF p_act_metric_fact_rec.hierarchy_id IS NOT NULL AND p_act_metric_fact_rec.hierarchy_id <> FND_API.G_MISS_NUM
2340: THEN
2341:
2342:
2343:
2355: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_NODE_ID');
2356: FND_MSG_PUB.Add;
2357: END IF;
2358:
2359: x_return_status := FND_API.G_RET_STS_ERROR;
2360:
2361: -- If any error happens abort API.
2362: RETURN;
2363: END IF;
2373: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_FACT_VAL');
2374: FND_MSG_PUB.Add;
2375: END IF;
2376:
2377: x_return_status := FND_API.G_RET_STS_ERROR;
2378:
2379: -- If any error happens abort API.
2380: RETURN;
2381: END IF;
2412: IS
2413: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness
2414: BEGIN
2415:
2416: x_return_status := FND_API.g_ret_sts_success;
2417:
2418: -- For Create_ActMetricFact, when activity_metric_fact_id is passed in, we need to
2419: -- check if this activity_metric_id is unique.
2420: IF p_validation_mode = JTF_PLSQL_API.g_create
2425:
2426: IF AMS_Utility_PVT.Check_Uniqueness(
2427: p_table_name => 'ams_act_metric_facts_all',
2428: p_where_clause => l_where_clause
2429: ) = FND_API.g_false
2430: THEN
2431: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2432: THEN
2433: FND_MESSAGE.set_name('AMS', 'AMS_METR_FACT_DUP_ID');
2432: THEN
2433: FND_MESSAGE.set_name('AMS', 'AMS_METR_FACT_DUP_ID');
2434: FND_MSG_PUB.add;
2435: END IF;
2436: x_return_status := FND_API.g_ret_sts_error;
2437: RETURN;
2438: END IF;
2439: END IF;
2440:
2488:
2489:
2490: BEGIN
2491: -- Initialize return status to success.
2492: x_return_status := FND_API.G_RET_STS_SUCCESS;
2493:
2494:
2495:
2496: -- ACTIVITY_METRIC_ID
2495:
2496: -- ACTIVITY_METRIC_ID
2497: -- Do not validate FK if NULL
2498:
2499: IF l_act_metric_fact_rec.activity_metric_id <> FND_API.G_MISS_NUM THEN
2500: l_table_name := 'AMS_ACT_METRICS_ALL';
2501: l_pk_name := 'ACTIVITY_METRIC_ID';
2502: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2503: l_pk_data_type := AMS_Utility_PVT.G_NUMBER;
2508: ,p_pk_name => l_pk_name
2509: ,p_pk_value => l_pk_value
2510: ,p_pk_data_type => l_pk_data_type
2511: ,p_additional_where_clause => l_additional_where_clause
2512: ) = FND_API.G_FALSE
2513: THEN
2514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2515: THEN
2516: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
2516: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
2517: FND_MSG_PUB.Add;
2518: END IF;
2519:
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: RETURN;
2522: END IF; -- Check_FK_Exists
2523:
2524: END IF;
2525:
2526:
2527:
2528: -- ARC_ACT_METRIC_USED_BY
2529: IF l_act_metric_fact_rec.arc_act_metric_used_by <> FND_API.G_MISS_CHAR THEN
2530: IF l_act_metric_fact_rec.arc_act_metric_used_by NOT IN
2531: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST')
2532: THEN
2533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2534: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
2535: FND_MSG_PUB.Add;
2536: END IF;
2537:
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RETURN;
2540: END IF;
2541: END IF;
2542:
2543: -----------------------------------------------------------------------
2544: --07-31-2000 tdonohoe , commented out to fix bug 1362107 --
2545: -----------------------------------------------------------------------
2546: /*
2547: IF l_act_metric_fact_rec.hierarchy_id <> FND_API.G_MISS_NUM THEN
2548:
2549: l_table_name := 'AMS_HIERARCHIES_ALL_B';
2550: l_pk_name := 'HIERARCHY_ID';
2551: l_pk_value := l_act_metric_fact_rec.hierarchy_id;
2557: ,p_pk_name => l_pk_name
2558: ,p_pk_value => l_pk_value
2559: ,p_pk_data_type => l_pk_data_type
2560: ,p_additional_where_clause => l_additional_where_clause
2561: ) = FND_API.G_FALSE
2562: THEN
2563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2564: THEN
2565: FND_MESSAGE.Set_Name('AMS', 'AMS_HIER_INVALID');
2565: FND_MESSAGE.Set_Name('AMS', 'AMS_HIER_INVALID');
2566: FND_MSG_PUB.Add;
2567: END IF;
2568:
2569: x_return_status := FND_API.G_RET_STS_ERROR;
2570: RETURN;
2571: END IF; -- Check_FK_Exists
2572:
2573: END IF;
2579: ----------------------------------------------------------------------------------
2580: --When a Hierarchy and Node are specified then a check must be done to verify
2581: --that the node is unique in the set of result entries for this activity metric.
2582: ----------------------------------------------------------------------------------
2583: IF l_act_metric_fact_rec.hierarchy_id <> FND_API.G_MISS_NUM THEN
2584:
2585: OPEN c_hierarchy_node_check(l_act_metric_fact_rec.hierarchy_id,
2586: l_act_metric_fact_rec.node_id,
2587: l_act_metric_fact_rec.activity_metric_fact_id,
2598: CLOSE c_hierarchy_node_check;
2599: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2600: FND_MESSAGE.set_name('AMS', 'AMS_METR_FACT_DUP_NODE_ID');
2601: FND_MSG_PUB.add;
2602: RAISE FND_API.g_exc_error;
2603: END IF;
2604: ELSE
2605: CLOSE c_hierarchy_node_check;
2606: END IF;
2607: END IF;
2608:
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END Check_ActMetricFact_Items;
2613:
2614:
2615: --
2647:
2648:
2649: BEGIN
2650:
2651: x_return_status := FND_API.g_ret_sts_success;
2652:
2653: IF l_act_metric_fact_rec.arc_act_metric_used_by <> FND_API.G_MISS_CHAR THEN
2654:
2655: IF l_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
2649: BEGIN
2650:
2651: x_return_status := FND_API.g_ret_sts_success;
2652:
2653: IF l_act_metric_fact_rec.arc_act_metric_used_by <> FND_API.G_MISS_CHAR THEN
2654:
2655: IF l_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
2656: l_act_metric_fact_rec.act_metric_used_by_id := p_complete_fact_rec.act_metric_used_by_id ;
2657: END IF;
2651: x_return_status := FND_API.g_ret_sts_success;
2652:
2653: IF l_act_metric_fact_rec.arc_act_metric_used_by <> FND_API.G_MISS_CHAR THEN
2654:
2655: IF l_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
2656: l_act_metric_fact_rec.act_metric_used_by_id := p_complete_fact_rec.act_metric_used_by_id ;
2657: END IF;
2658:
2659: IF l_act_metric_fact_rec.activity_metric_id = FND_API.G_MISS_NUM THEN
2655: IF l_act_metric_fact_rec.act_metric_used_by_id = FND_API.G_MISS_NUM THEN
2656: l_act_metric_fact_rec.act_metric_used_by_id := p_complete_fact_rec.act_metric_used_by_id ;
2657: END IF;
2658:
2659: IF l_act_metric_fact_rec.activity_metric_id = FND_API.G_MISS_NUM THEN
2660: l_act_metric_fact_rec.activity_metric_id := p_complete_fact_rec.activity_metric_id ;
2661: END IF;
2662:
2663: -- first Check whether the Metric is attached to same usage or not
2675: ,p_pk_name => l_pk_name
2676: ,p_pk_value => l_pk_value
2677: ,p_pk_data_type => l_pk_data_type
2678: ,p_additional_where_clause => l_additional_where_clause
2679: ) = FND_API.G_FALSE
2680: THEN
2681:
2682: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2683: THEN
2684: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
2685: FND_MSG_PUB.Add;
2686: END IF;
2687:
2688: x_return_status := FND_API.G_RET_STS_ERROR;
2689:
2690: RETURN;
2691:
2692: END IF; -- Check_FK_Exists
2713: ,p_pk_name => l_pk_name
2714: ,p_pk_value => l_pk_value
2715: ,p_pk_data_type => l_pk_data_type
2716: ,p_additional_where_clause => NULL
2717: ) = FND_API.G_FALSE
2718: THEN
2719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2720: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
2721: FND_MSG_PUB.Add;
2720: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
2721: FND_MSG_PUB.Add;
2722: END IF;
2723:
2724: x_return_status := FND_API.G_RET_STS_ERROR;
2725: RETURN;
2726: END IF;
2727: */
2728:
2729: END IF;
2730:
2731: EXCEPTION
2732: WHEN OTHERS THEN
2733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2734:
2735:
2736: END Validate_ActMetFact_Rec;
2737:
2765: Check_Req_ActMetricFact_Items(
2766: p_act_metric_fact_rec => p_act_metric_fact_rec,
2767: x_return_status => x_return_status
2768: );
2769: IF x_return_status <> FND_API.g_ret_sts_success THEN
2770: RETURN;
2771: END IF;
2772:
2773:
2777: p_validation_mode => p_validation_mode,
2778: x_return_status => x_return_status
2779: );
2780:
2781: IF x_return_status <> FND_API.g_ret_sts_success THEN
2782: RETURN;
2783: END IF;
2784:
2785:
2788: p_act_metric_fact_rec => p_act_metric_fact_rec,
2789: x_return_status => x_return_status
2790: );
2791:
2792: IF x_return_status <> FND_API.g_ret_sts_success THEN
2793: RETURN;
2794: END IF;
2795:
2796: