[Home] [Help]
32: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Create_ActMetric2 (
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
37: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
38: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
39:
40: x_return_status OUT NOCOPY VARCHAR2,
33:
34: PROCEDURE Create_ActMetric2 (
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
37: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
38: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
39:
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
34: PROCEDURE Create_ActMetric2 (
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
37: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
38: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
39:
40: x_return_status OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: x_msg_data OUT NOCOPY VARCHAR2,
56:
57:
58: PROCEDURE Create_ActMetric (
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
61: --p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
62: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
64:
57:
58: PROCEDURE Create_ActMetric (
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
61: --p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
62: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
58: PROCEDURE Create_ActMetric (
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
61: --p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
62: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
61: --p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
62: p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
63: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
74: BEGIN
75:
76: SAVEPOINT sp_create_actmetric;
77:
78: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
79: x_activity_metric_id := NULL;
80:
81: LOCK TABLE OZF_ACT_METRICS_ALL IN EXCLUSIVE MODE;
82:
91: p_act_metric_rec => p_act_metric_rec,
92: x_activity_metric_id => x_activity_metric_id);
93:
94: -- If any errors happen abort API.
95: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
96: RAISE Fnd_Api.G_EXC_ERROR;
97: END IF;
98:
99: --COMMIT WORK;
92: x_activity_metric_id => x_activity_metric_id);
93:
94: -- If any errors happen abort API.
95: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
96: RAISE Fnd_Api.G_EXC_ERROR;
97: END IF;
98:
99: --COMMIT WORK;
100:
97: END IF;
98:
99: --COMMIT WORK;
100:
101: IF Fnd_Api.to_boolean(p_commit) THEN
102: COMMIT;
103: END IF;
104:
105: --
108: --
109: Fnd_Msg_Pub.Count_And_Get (
110: p_count => x_msg_count,
111: p_data => x_msg_data,
112: p_encoded => Fnd_Api.G_FALSE
113: );
114:
115: EXCEPTION
116: WHEN Fnd_Api.G_EXC_ERROR THEN
112: p_encoded => Fnd_Api.G_FALSE
113: );
114:
115: EXCEPTION
116: WHEN Fnd_Api.G_EXC_ERROR THEN
117: ROLLBACK TO sp_create_actmetric;
118: x_return_status := Fnd_Api.G_RET_STS_ERROR;
119: Fnd_Msg_Pub.Count_And_Get (
120: p_count => x_msg_count,
114:
115: EXCEPTION
116: WHEN Fnd_Api.G_EXC_ERROR THEN
117: ROLLBACK TO sp_create_actmetric;
118: x_return_status := Fnd_Api.G_RET_STS_ERROR;
119: Fnd_Msg_Pub.Count_And_Get (
120: p_count => x_msg_count,
121: p_data => x_msg_data,
122: p_encoded => FND_API.G_FALSE
118: x_return_status := Fnd_Api.G_RET_STS_ERROR;
119: Fnd_Msg_Pub.Count_And_Get (
120: p_count => x_msg_count,
121: p_data => x_msg_data,
122: p_encoded => FND_API.G_FALSE
123: );
124: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
125: ROLLBACK TO sp_create_actmetric;
126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
120: p_count => x_msg_count,
121: p_data => x_msg_data,
122: p_encoded => FND_API.G_FALSE
123: );
124: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
125: ROLLBACK TO sp_create_actmetric;
126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
127: Fnd_Msg_Pub.Count_And_Get (
128: p_count => x_msg_count,
122: p_encoded => FND_API.G_FALSE
123: );
124: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
125: ROLLBACK TO sp_create_actmetric;
126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
127: Fnd_Msg_Pub.Count_And_Get (
128: p_count => x_msg_count,
129: p_data => x_msg_data,
130: p_encoded => FND_API.G_FALSE
126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
127: Fnd_Msg_Pub.Count_And_Get (
128: p_count => x_msg_count,
129: p_data => x_msg_data,
130: p_encoded => FND_API.G_FALSE
131: );
132: WHEN OTHERS THEN
133: ROLLBACK TO sp_create_actmetric;
134: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
130: p_encoded => FND_API.G_FALSE
131: );
132: WHEN OTHERS THEN
133: ROLLBACK TO sp_create_actmetric;
134: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
135: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
136: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
137: END IF;
138: Fnd_Msg_Pub.Count_And_Get (
137: END IF;
138: Fnd_Msg_Pub.Count_And_Get (
139: p_count => x_msg_count,
140: p_data => x_msg_data,
141: p_encoded => FND_API.G_FALSE
142: );
143: END Create_ActMetric;
144:
145: -- Start of comments
184: -- HISTORY
185: -- End of comments
186:
187: PROCEDURE Default_ActMetric(
188: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
189: --p_act_metric_rec IN act_metric_rec_type,
190: p_validation_mode IN VARCHAR2 ,
191: x_complete_rec IN OUT NOCOPY act_metric_rec_type,
192: x_return_status OUT NOCOPY VARCHAR2,
195: )
196: IS
197: l_obj_trans_curr VARCHAR2(15);
198: l_return_status VARCHAR2(1);
199: l_curr_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
200: l_current_date DATE := SYSDATE;
201: l_trans_actual_value number;
202: l_trans_forecasted_value number;
203:
204: BEGIN
205: --
206: -- Initialize message list if p_init_msg_list is set to TRUE.
207: --
208: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
209: Fnd_Msg_Pub.Initialize;
210: END IF;
211:
212: --
211:
212: --
213: -- Initialize API return status to success.
214: --
215: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
216:
217: -- 05/22/2002 yzhao: 11.5.9 default setting for budget allocation
218: IF (x_complete_rec.arc_act_metric_used_by='FUND') THEN
219: IF (x_complete_rec.hierarchy_type IN ('BUDGET_HIER', 'BUDGET_CATEGORY', 'HR_ORG') ) THEN
218: IF (x_complete_rec.arc_act_metric_used_by='FUND') THEN
219: IF (x_complete_rec.hierarchy_type IN ('BUDGET_HIER', 'BUDGET_CATEGORY', 'HR_ORG') ) THEN
220: -- set start_level, end_level for budget allocation
221: IF (x_complete_rec.from_level IS NULL OR
222: x_complete_rec.from_level = Fnd_Api.G_MISS_NUM) THEN
223: x_complete_rec.from_level := 1;
224: END IF;
225: IF (x_complete_rec.to_level IS NULL OR
226: x_complete_rec.to_level = Fnd_Api.G_MISS_NUM) THEN
222: x_complete_rec.from_level = Fnd_Api.G_MISS_NUM) THEN
223: x_complete_rec.from_level := 1;
224: END IF;
225: IF (x_complete_rec.to_level IS NULL OR
226: x_complete_rec.to_level = Fnd_Api.G_MISS_NUM) THEN
227: x_complete_rec.to_level := OZF_Fund_allocations_Pvt.g_max_end_level;
228: END IF;
229:
230: -- set 'Ex-Start-Node' if 'ADD ONTO EXISTING BUDGET' and start node is the same as the budget
246: -- transaction currency and functional currency
247: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');
248: FND_MSG_PUB.Add;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251:
252: -- If any error happens abort API.
253: RETURN;
254: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
256: -- Atleast One of the two Currencies specified is invalid
257: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');
258: FND_MSG_PUB.Add;
259: END IF;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: -- If any error happens abort API.
263: RETURN;
264: */
287: -- End of comments
288:
289: PROCEDURE Create_ActMetric2 (
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
293: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
288:
289: PROCEDURE Create_ActMetric2 (
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
293: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
289: PROCEDURE Create_ActMetric2 (
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
293: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
337:
338: --
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: --
341: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
342: Fnd_Msg_Pub.Initialize;
343: END IF;
344:
345: --
344:
345: --
346: -- Standard check for API version compatibility.
347: --
348: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
349: p_api_version,
350: L_API_NAME,
351: G_PKG_NAME)
352: THEN
349: p_api_version,
350: L_API_NAME,
351: G_PKG_NAME)
352: THEN
353: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355:
356: --
357: -- Initialize API return status to success.
355:
356: --
357: -- Initialize API return status to success.
358: --
359: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
360: x_activity_metric_id := NULL;
361: --
362: -- Begin API Body.
363: --
361: --
362: -- Begin API Body.
363: --
364:
365: IF l_act_metrics_rec.hierarchy_type = FND_API.G_MISS_CHAR then
366: l_act_metrics_rec.hierarchy_type := NULL;
367: END IF;
368: IF l_act_metrics_rec.status_code = FND_API.G_MISS_CHAR then
369: l_act_metrics_rec.status_code := NULL;
364:
365: IF l_act_metrics_rec.hierarchy_type = FND_API.G_MISS_CHAR then
366: l_act_metrics_rec.hierarchy_type := NULL;
367: END IF;
368: IF l_act_metrics_rec.status_code = FND_API.G_MISS_CHAR then
369: l_act_metrics_rec.status_code := NULL;
370: END IF;
371: IF l_act_metrics_rec.method_code = FND_API.G_MISS_CHAR then
372: l_act_metrics_rec.method_code := NULL;
367: END IF;
368: IF l_act_metrics_rec.status_code = FND_API.G_MISS_CHAR then
369: l_act_metrics_rec.status_code := NULL;
370: END IF;
371: IF l_act_metrics_rec.method_code = FND_API.G_MISS_CHAR then
372: l_act_metrics_rec.method_code := NULL;
373: END IF;
374: IF l_act_metrics_rec.action_code = FND_API.G_MISS_CHAR then
375: l_act_metrics_rec.action_code := NULL;
370: END IF;
371: IF l_act_metrics_rec.method_code = FND_API.G_MISS_CHAR then
372: l_act_metrics_rec.method_code := NULL;
373: END IF;
374: IF l_act_metrics_rec.action_code = FND_API.G_MISS_CHAR then
375: l_act_metrics_rec.action_code := NULL;
376: END IF;
377: IF l_act_metrics_rec.basis_year = FND_API.G_MISS_NUM then
378: l_act_metrics_rec.basis_year := NULL;
373: END IF;
374: IF l_act_metrics_rec.action_code = FND_API.G_MISS_CHAR then
375: l_act_metrics_rec.action_code := NULL;
376: END IF;
377: IF l_act_metrics_rec.basis_year = FND_API.G_MISS_NUM then
378: l_act_metrics_rec.basis_year := NULL;
379: END IF;
380: IF l_act_metrics_rec.ex_start_node = FND_API.G_MISS_CHAR then
381: l_act_metrics_rec.ex_start_node := NULL;
376: END IF;
377: IF l_act_metrics_rec.basis_year = FND_API.G_MISS_NUM then
378: l_act_metrics_rec.basis_year := NULL;
379: END IF;
380: IF l_act_metrics_rec.ex_start_node = FND_API.G_MISS_CHAR then
381: l_act_metrics_rec.ex_start_node := NULL;
382: END IF;
383:
384:
394: x_msg_data => x_msg_data
395: );
396:
397: -- If any errors happen abort API.
398: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
399: RAISE Fnd_Api.G_EXC_ERROR;
400: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
401: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
402: END IF;
395: );
396:
397: -- If any errors happen abort API.
398: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
399: RAISE Fnd_Api.G_EXC_ERROR;
400: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
401: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
396:
397: -- If any errors happen abort API.
398: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
399: RAISE Fnd_Api.G_EXC_ERROR;
400: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
401: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: --
397: -- If any errors happen abort API.
398: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
399: RAISE Fnd_Api.G_EXC_ERROR;
400: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
401: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: --
405: -- Validate the record before inserting.
414: p_act_metric_rec => l_act_metrics_rec
415: );
416:
417: -- If any errors happen abort API.
418: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;
415: );
416:
417: -- If any errors happen abort API.
418: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
416:
417: -- If any errors happen abort API.
418: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: --
417: -- If any errors happen abort API.
418: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
419: RAISE Fnd_Api.G_EXC_ERROR;
420: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
421: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: --
425: -- Debug message.
631:
632: --
633: -- Standard check for commit request.
634: --
635: --IF Fnd_Api.To_Boolean (p_commit) THEN
636: -- COMMIT WORK;
637: --END IF;
638:
639: --
642: --
643: --Fnd_Msg_Pub.Count_And_Get (
644: -- p_count => x_msg_count,
645: -- p_data => x_msg_data,
646: -- p_encoded => Fnd_Api.G_FALSE
647: --);
648:
649: --
650: -- Add success message to message list.
654: END IF;
655:
656: /*
657: EXCEPTION
658: WHEN Fnd_Api.G_EXC_ERROR THEN
659: ROLLBACK TO Create_ActMetric2_pvt;
660: --ROLLBACK;
661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
662: Fnd_Msg_Pub.Count_And_Get (
657: EXCEPTION
658: WHEN Fnd_Api.G_EXC_ERROR THEN
659: ROLLBACK TO Create_ActMetric2_pvt;
660: --ROLLBACK;
661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
662: Fnd_Msg_Pub.Count_And_Get (
663: p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => FND_API.G_FALSE
661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
662: Fnd_Msg_Pub.Count_And_Get (
663: p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => FND_API.G_FALSE
666: );
667: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO Create_ActMetric2_pvt;
669: --ROLLBACK;
663: p_count => x_msg_count,
664: p_data => x_msg_data,
665: p_encoded => FND_API.G_FALSE
666: );
667: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO Create_ActMetric2_pvt;
669: --ROLLBACK;
670: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
671: Fnd_Msg_Pub.Count_And_Get (
666: );
667: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO Create_ActMetric2_pvt;
669: --ROLLBACK;
670: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
671: Fnd_Msg_Pub.Count_And_Get (
672: p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => FND_API.G_FALSE
670: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
671: Fnd_Msg_Pub.Count_And_Get (
672: p_count => x_msg_count,
673: p_data => x_msg_data,
674: p_encoded => FND_API.G_FALSE
675: );
676: WHEN OTHERS THEN
677: ROLLBACK TO Create_ActMetric2_pvt;
678: --ROLLBACK;
675: );
676: WHEN OTHERS THEN
677: ROLLBACK TO Create_ActMetric2_pvt;
678: --ROLLBACK;
679: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
680: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
681: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
682: END IF;
683: Fnd_Msg_Pub.Count_And_Get (
682: END IF;
683: Fnd_Msg_Pub.Count_And_Get (
684: p_count => x_msg_count,
685: p_data => x_msg_data,
686: p_encoded => FND_API.G_FALSE
687: );
688: */
689: END Create_ActMetric2;
690:
710:
711:
712: PROCEDURE Update_ActMetric (
713: p_api_version IN NUMBER,
714: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
715: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
716: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
717:
718: x_return_status OUT NOCOPY VARCHAR2,
711:
712: PROCEDURE Update_ActMetric (
713: p_api_version IN NUMBER,
714: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
715: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
716: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
717:
718: x_return_status OUT NOCOPY VARCHAR2,
719: x_msg_count OUT NOCOPY NUMBER,
712: PROCEDURE Update_ActMetric (
713: p_api_version IN NUMBER,
714: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
715: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
716: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
717:
718: x_return_status OUT NOCOPY VARCHAR2,
719: x_msg_count OUT NOCOPY NUMBER,
720: x_msg_data OUT NOCOPY VARCHAR2,
724: L_API_VERSION CONSTANT NUMBER := 1.0;
725: L_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_ACTMETRIC';
726: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
727:
728: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
729: l_actmet_rec act_metric_rec_type := p_act_metric_rec;
730:
731: BEGIN
732:
749: END IF;
750: --
751: -- Initialize message list if p_init_msg_list is set to TRUE.
752: --
753: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
754: Fnd_Msg_Pub.Initialize;
755: END IF;
756:
757: --
756:
757: --
758: -- Standard check for API version compatibility.
759: --
760: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
761: p_api_version,
762: L_API_NAME,
763: G_PKG_NAME)
764: THEN
761: p_api_version,
762: L_API_NAME,
763: G_PKG_NAME)
764: THEN
765: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: --
769: -- Initialize API return status to success.
767:
768: --
769: -- Initialize API return status to success.
770: --
771: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
772:
773: --
774: -- Begin API Body
775: --
792: x_return_status => l_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data ) ;
795: -- If any errors happen abort API.
796: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
797: RAISE Fnd_Api.G_EXC_ERROR;
798: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
799: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
800: END IF;
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data ) ;
795: -- If any errors happen abort API.
796: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
797: RAISE Fnd_Api.G_EXC_ERROR;
798: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
799: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
794: x_msg_data => x_msg_data ) ;
795: -- If any errors happen abort API.
796: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
797: RAISE Fnd_Api.G_EXC_ERROR;
798: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
799: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
795: -- If any errors happen abort API.
796: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
797: RAISE Fnd_Api.G_EXC_ERROR;
798: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
799: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
803: Validate_ActMetric_items(
804: p_act_metric_rec => l_actmet_rec,
805: p_validation_mode => Jtf_Plsql_Api.g_update,
806: x_return_status => l_return_status
807: );
808: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
809: RAISE Fnd_Api.g_exc_unexpected_error;
810: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
811: RAISE Fnd_Api.g_exc_error;
812: END IF;
805: p_validation_mode => Jtf_Plsql_Api.g_update,
806: x_return_status => l_return_status
807: );
808: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
809: RAISE Fnd_Api.g_exc_unexpected_error;
810: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
811: RAISE Fnd_Api.g_exc_error;
812: END IF;
813: END IF;
806: x_return_status => l_return_status
807: );
808: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
809: RAISE Fnd_Api.g_exc_unexpected_error;
810: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
811: RAISE Fnd_Api.g_exc_error;
812: END IF;
813: END IF;
814:
807: );
808: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
809: RAISE Fnd_Api.g_exc_unexpected_error;
810: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
811: RAISE Fnd_Api.g_exc_error;
812: END IF;
813: END IF;
814:
815:
823: p_complete_rec => l_actmet_rec,
824: p_operation_mode => G_UPDATE,
825: x_return_status => l_return_status
826: );
827: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
828: RAISE Fnd_Api.g_exc_unexpected_error;
829: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
830: RAISE Fnd_Api.g_exc_error;
831: END IF;
824: p_operation_mode => G_UPDATE,
825: x_return_status => l_return_status
826: );
827: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
828: RAISE Fnd_Api.g_exc_unexpected_error;
829: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
830: RAISE Fnd_Api.g_exc_error;
831: END IF;
832: END IF;
825: x_return_status => l_return_status
826: );
827: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
828: RAISE Fnd_Api.g_exc_unexpected_error;
829: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
830: RAISE Fnd_Api.g_exc_error;
831: END IF;
832: END IF;
833:
826: );
827: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
828: RAISE Fnd_Api.g_exc_unexpected_error;
829: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
830: RAISE Fnd_Api.g_exc_error;
831: END IF;
832: END IF;
833:
834:
925: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
926: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
927: Fnd_Msg_Pub.ADD;
928: END IF;
929: RAISE Fnd_Api.g_exc_error;
930: END IF;
931:
932: IF Fnd_Api.to_boolean(p_commit) THEN
933: COMMIT;
928: END IF;
929: RAISE Fnd_Api.g_exc_error;
930: END IF;
931:
932: IF Fnd_Api.to_boolean(p_commit) THEN
933: COMMIT;
934: END IF;
935:
936: --
939: --
940: Fnd_Msg_Pub.Count_And_Get (
941: p_count => x_msg_count,
942: p_data => x_msg_data,
943: p_encoded => Fnd_Api.G_FALSE
944: );
945:
946: --
947: -- Debug message.
951: END IF;
952:
953:
954: EXCEPTION
955: WHEN Fnd_Api.G_EXC_ERROR THEN
956: ROLLBACK TO Update_ActMetric_pvt;
957: x_return_status := Fnd_Api.G_RET_STS_ERROR;
958: Fnd_Msg_Pub.Count_And_Get (
959: p_count => x_msg_count,
953:
954: EXCEPTION
955: WHEN Fnd_Api.G_EXC_ERROR THEN
956: ROLLBACK TO Update_ActMetric_pvt;
957: x_return_status := Fnd_Api.G_RET_STS_ERROR;
958: Fnd_Msg_Pub.Count_And_Get (
959: p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => FND_API.G_FALSE
957: x_return_status := Fnd_Api.G_RET_STS_ERROR;
958: Fnd_Msg_Pub.Count_And_Get (
959: p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => FND_API.G_FALSE
962: );
963: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK TO Update_ActMetric_pvt;
965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
959: p_count => x_msg_count,
960: p_data => x_msg_data,
961: p_encoded => FND_API.G_FALSE
962: );
963: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK TO Update_ActMetric_pvt;
965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
966: Fnd_Msg_Pub.Count_And_Get (
967: p_count => x_msg_count,
961: p_encoded => FND_API.G_FALSE
962: );
963: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK TO Update_ActMetric_pvt;
965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
966: Fnd_Msg_Pub.Count_And_Get (
967: p_count => x_msg_count,
968: p_data => x_msg_data,
969: p_encoded => FND_API.G_FALSE
965: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
966: Fnd_Msg_Pub.Count_And_Get (
967: p_count => x_msg_count,
968: p_data => x_msg_data,
969: p_encoded => FND_API.G_FALSE
970: );
971: WHEN OTHERS THEN
972: ROLLBACK TO Update_ActMetric_pvt;
973: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
969: p_encoded => FND_API.G_FALSE
970: );
971: WHEN OTHERS THEN
972: ROLLBACK TO Update_ActMetric_pvt;
973: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
974: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
975: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
976: END IF;
977: Fnd_Msg_Pub.Count_And_Get (
976: END IF;
977: Fnd_Msg_Pub.Count_And_Get (
978: p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => FND_API.G_FALSE
981: );
982: END Update_ActMetric;
983:
984:
999: -- End of comments
1000:
1001: PROCEDURE Validate_ActMetric (
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1004: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
1005:
1006: x_return_status OUT NOCOPY VARCHAR2,
1007: x_msg_count OUT NOCOPY NUMBER,
1000:
1001: PROCEDURE Validate_ActMetric (
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1004: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
1005:
1006: x_return_status OUT NOCOPY VARCHAR2,
1007: x_msg_count OUT NOCOPY NUMBER,
1008: x_msg_data OUT NOCOPY VARCHAR2,
1026:
1027: --
1028: -- Initialize message list if p_init_msg_list is set to TRUE.
1029: --
1030: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1031: Fnd_Msg_Pub.Initialize;
1032: END IF;
1033:
1034: --
1033:
1034: --
1035: -- Standard check for API version compatibility.
1036: --
1037: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1038: p_api_version,
1039: L_API_NAME,
1040: G_PKG_NAME)
1041: THEN
1038: p_api_version,
1039: L_API_NAME,
1040: G_PKG_NAME)
1041: THEN
1042: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044:
1045: --
1046: -- Initialize API return status to success.
1044:
1045: --
1046: -- Initialize API return status to success.
1047: --
1048: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1049:
1050: --
1051: -- Begin API Body.
1052: --
1064: x_return_status => l_return_status
1065: );
1066:
1067: -- If any errors happen abort API.
1068: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1071: RAISE Fnd_Api.G_EXC_ERROR;
1072: END IF;
1065: );
1066:
1067: -- If any errors happen abort API.
1068: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1071: RAISE Fnd_Api.G_EXC_ERROR;
1072: END IF;
1073: END IF;
1066:
1067: -- If any errors happen abort API.
1068: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1071: RAISE Fnd_Api.G_EXC_ERROR;
1072: END IF;
1073: END IF;
1074:
1067: -- If any errors happen abort API.
1068: IF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1069: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1071: RAISE Fnd_Api.G_EXC_ERROR;
1072: END IF;
1073: END IF;
1074:
1075: IF (OZF_DEBUG_HIGH_ON) THEN
1082: p_complete_rec => NULL,
1083: x_return_status => l_return_status
1084: );
1085:
1086: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1087: RAISE Fnd_Api.g_exc_unexpected_error;
1088: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
1089: RAISE Fnd_Api.g_exc_error;
1090: END IF;
1083: x_return_status => l_return_status
1084: );
1085:
1086: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1087: RAISE Fnd_Api.g_exc_unexpected_error;
1088: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
1089: RAISE Fnd_Api.g_exc_error;
1090: END IF;
1091: END IF;
1084: );
1085:
1086: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1087: RAISE Fnd_Api.g_exc_unexpected_error;
1088: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
1089: RAISE Fnd_Api.g_exc_error;
1090: END IF;
1091: END IF;
1092:
1085:
1086: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1087: RAISE Fnd_Api.g_exc_unexpected_error;
1088: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
1089: RAISE Fnd_Api.g_exc_error;
1090: END IF;
1091: END IF;
1092:
1093: --
1100: --
1101: Fnd_Msg_Pub.Count_And_Get (
1102: p_count => x_msg_count,
1103: p_data => x_msg_data,
1104: p_encoded => Fnd_Api.G_FALSE
1105: );
1106:
1107: IF (OZF_DEBUG_HIGH_ON) THEN
1108: ozf_utility_pvt.debug_message(l_full_name ||': end');
1108: ozf_utility_pvt.debug_message(l_full_name ||': end');
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN
1113: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1114: Fnd_Msg_Pub.Count_And_Get (
1115: p_count => x_msg_count,
1116: p_data => x_msg_data,
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN
1113: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1114: Fnd_Msg_Pub.Count_And_Get (
1115: p_count => x_msg_count,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE
1113: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1114: Fnd_Msg_Pub.Count_And_Get (
1115: p_count => x_msg_count,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE
1118: );
1119: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1120: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1121: Fnd_Msg_Pub.Count_And_Get (
1115: p_count => x_msg_count,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE
1118: );
1119: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1120: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1121: Fnd_Msg_Pub.Count_And_Get (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,
1116: p_data => x_msg_data,
1117: p_encoded => FND_API.G_FALSE
1118: );
1119: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1120: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1121: Fnd_Msg_Pub.Count_And_Get (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1120: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1121: Fnd_Msg_Pub.Count_And_Get (
1122: p_count => x_msg_count,
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1125: );
1126: WHEN OTHERS THEN
1127: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1128: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1123: p_data => x_msg_data,
1124: p_encoded => FND_API.G_FALSE
1125: );
1126: WHEN OTHERS THEN
1127: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1128: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1129: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1130: END IF;
1131: Fnd_Msg_Pub.Count_And_Get (
1130: END IF;
1131: Fnd_Msg_Pub.Count_And_Get (
1132: p_count => x_msg_count,
1133: p_data => x_msg_data,
1134: p_encoded => FND_API.G_FALSE
1135: );
1136: END Validate_ActMetric;
1137:
1138:
1159: )
1160: IS
1161: BEGIN
1162: -- Initialize return status to success.
1163: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1164:
1165: -- APPLICATION_ID
1166:
1167: IF p_act_metric_rec.application_id IS NULL
1172: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_APP_ID');
1173: Fnd_Msg_Pub.ADD;
1174: END IF;
1175:
1176: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1177:
1178: -- If any error happens abort API.
1179: RETURN;
1180: END IF;
1189: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1190: Fnd_Msg_Pub.ADD;
1191: END IF;
1192:
1193: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1194:
1195: -- If any error happens abort API.
1196: RETURN;
1197: END IF;
1207: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1208: Fnd_Msg_Pub.ADD;
1209: END IF;
1210:
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1212:
1213: -- If any error happens abort API.
1214: RETURN;
1215: END IF;
1224: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_METRIC_ID');
1225: Fnd_Msg_Pub.ADD;
1226: END IF;
1227:
1228: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1229:
1230: -- If any error happens abort API.
1231: RETURN;
1232: END IF;
1243: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_UOM');
1244: FND_MSG_PUB.Add;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248:
1249: -- If any error happens abort API.
1250: RETURN;
1251: END IF;
1263: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_SENSITIVE');
1264: Fnd_Msg_Pub.ADD;
1265: END IF;
1266:
1267: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1268:
1269: -- If any error happens abort API.
1270: RETURN;
1271: END IF;
1321: OR metric_calculation_type <> 'FUNCTION');
1322:
1323: BEGIN
1324:
1325: x_return_status := Fnd_Api.g_ret_sts_success;
1326:
1327: -- For Create_ActMetric2, when activity_metric_id is passed in, we need to
1328: -- check if this activity_metric_id is unique.
1329: IF p_validation_mode = Jtf_Plsql_Api.g_create
1333:
1334: IF ozf_utility_pvt.Check_Uniqueness(
1335: p_table_name => 'ozf_act_metrics_all',
1336: p_where_clause => l_where_clause
1337: ) = Fnd_Api.g_false
1338: THEN
1339: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
1340: THEN
1341: Fnd_Message.set_name('OZF', 'OZF_METR_ACT_DUP_ID');
1340: THEN
1341: Fnd_Message.set_name('OZF', 'OZF_METR_ACT_DUP_ID');
1342: Fnd_Msg_Pub.ADD;
1343: END IF;
1344: x_return_status := Fnd_Api.g_ret_sts_error;
1345: RETURN;
1346: END IF;
1347: END IF;
1348:
1363: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1364: Fnd_Message.set_name('OZF', 'OZF_ACT_MET_DUP_FUNCTION');
1365: Fnd_Msg_Pub.ADD;
1366: END IF;
1367: x_return_status := Fnd_Api.g_ret_sts_error;
1368: END IF;
1369:
1370: END IF;
1371:
1409: l_lookup_type VARCHAR2(30);
1410:
1411: BEGIN
1412: -- Initialize return status to success.
1413: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1414:
1415: --
1416:
1417: --
1422: -- Do not validate FK if NULL
1423: -- Do not validate if Activity Metric is associated with a Forecast.
1424:
1425:
1426: IF l_act_metrics_rec.arc_act_metric_used_by <> Fnd_Api.G_MISS_CHAR AND
1427: ( l_act_metrics_rec.arc_act_metric_used_by NOT IN ('FCST', 'FUND') )
1428: THEN --added 05-08-2000 tdonohoe
1429: --added 06-28-2000 rchahal
1430:
1427: ( l_act_metrics_rec.arc_act_metric_used_by NOT IN ('FCST', 'FUND') )
1428: THEN --added 05-08-2000 tdonohoe
1429: --added 06-28-2000 rchahal
1430:
1431: IF l_act_metrics_rec.metric_id <> Fnd_Api.G_MISS_NUM THEN
1432: l_table_name := 'AMS_METRICS_VL';
1433: l_pk_name := 'METRIC_ID';
1434: l_pk_value := l_act_metrics_rec.metric_id;
1435: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1440: ,p_pk_name => l_pk_name
1441: ,p_pk_value => l_pk_value
1442: ,p_pk_data_type => l_pk_data_type
1443: ,p_additional_where_clause => l_additional_where_clause
1444: ) = Fnd_Api.G_FALSE
1445: THEN
1446: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1447: THEN
1448: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_MET');
1448: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_MET');
1449: Fnd_Msg_Pub.ADD;
1450: END IF;
1451:
1452: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1453: RETURN;
1454: END IF; -- Check_FK_Exists
1455:
1456: END IF;
1457: END IF;--added 05-08-2000 tdonohoe
1458:
1459: -- TRANSACTION_CURRENCY_CODE
1460: -- Do not validate FK if NULL
1461: IF l_act_metrics_rec.transaction_currency_code <> Fnd_Api.G_MISS_CHAR THEN
1462: l_table_name := 'FND_CURRENCIES';
1463: l_pk_name := 'CURRENCY_CODE';
1464: l_pk_value := l_act_metrics_rec.transaction_currency_code;
1465: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1469: ,p_pk_name => l_pk_name
1470: ,p_pk_value => l_pk_value
1471: ,p_pk_data_type => l_pk_data_type
1472: ,p_additional_where_clause => l_additional_where_clause
1473: ) = Fnd_Api.G_FALSE
1474: THEN
1475: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1476: THEN
1477: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_TRANS_CUR');
1477: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_TRANS_CUR');
1478: Fnd_Msg_Pub.ADD;
1479: END IF;
1480:
1481: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1482: RETURN;
1483: END IF; -- Check_FK_Exists
1484: END IF;
1485:
1484: END IF;
1485:
1486: -- FUNCTIONAL_CURRENCY_CODE
1487: -- Do not validate FK if NULL
1488: IF l_act_metrics_rec.functional_currency_code <> Fnd_Api.G_MISS_CHAR THEN
1489: l_table_name := 'FND_CURRENCIES';
1490: l_pk_name := 'CURRENCY_CODE';
1491: l_pk_value := l_act_metrics_rec.functional_currency_code;
1492: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1497: ,p_pk_name => l_pk_name
1498: ,p_pk_value => l_pk_value
1499: ,p_pk_data_type => l_pk_data_type
1500: ,p_additional_where_clause => l_additional_where_clause
1501: ) = Fnd_Api.G_FALSE
1502: THEN
1503: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1504: THEN
1505: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_FUNC_CUR');
1505: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_FUNC_CUR');
1506: Fnd_Msg_Pub.ADD;
1507: END IF;
1508:
1509: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1510: RETURN;
1511: END IF; -- Check_FK_Exists
1512:
1513: END IF;
1520: -- Begin Validate Flags
1521: --
1522:
1523: -- SENSITIVE_DATA_FLAG
1524: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
1525: IF ozf_utility_pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
1526: = Fnd_Api.G_FALSE
1527: THEN
1528: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1522:
1523: -- SENSITIVE_DATA_FLAG
1524: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
1525: IF ozf_utility_pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
1526: = Fnd_Api.G_FALSE
1527: THEN
1528: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1529: THEN
1530: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_SENS_FLAG');
1530: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_SENS_FLAG');
1531: Fnd_Msg_Pub.ADD;
1532: END IF;
1533:
1534: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1535: RETURN;
1536: END IF; -- Check_FK_Exists
1537: END IF;
1538:
1551:
1552: -- ARC_METRIC_USED_FOR_OBJECT
1553: -- DMVINCEN 03/11/2002: Added Dialog Components.
1554: -- DMVINCEN 03/11/2003: Removed Dialogue Components.
1555: IF l_act_metrics_rec.arc_act_metric_used_by <> Fnd_Api.G_MISS_CHAR THEN
1556: IF l_act_metrics_rec.arc_act_metric_used_by NOT IN
1557: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST','RCAM','EONE')
1558: --'DILG','AMS_COMP_START','AMS_COMP_SHOW_WEB_PAGE','AMS_COMP_END')
1559: THEN
1561: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
1562: Fnd_Msg_Pub.ADD;
1563: END IF;
1564:
1565: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1566: RETURN;
1567: END IF;
1568: END IF;
1569:
1569:
1570: -- ARC_ACTIVITY_METRIC_ORIGIN
1571: -- DMVINCEN 03/11/2002: Added Dialog Components.
1572: -- DMVINCEN 03/11/2003: Removed Dialogue Components.
1573: IF l_act_metrics_rec.arc_activity_metric_origin <> Fnd_Api.G_MISS_CHAR THEN
1574: IF l_act_metrics_rec.arc_activity_metric_origin NOT IN
1575: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST','RCAM','EONE')
1576: --'DILG','AMS_COMP_START','AMS_COMP_SHOW_WEB_PAGE','AMS_COMP_END')
1577: THEN
1579: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');
1580: Fnd_Msg_Pub.ADD;
1581: END IF;
1582:
1583: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1584: RETURN;
1585: END IF;
1586: END IF;
1587:
1590: --
1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1595: END Check_ActMetric_Items;
1596:
1597:
1598: -- Start of comments
1649: AND node_id = p_act_metric_rec.start_node;
1650:
1651: BEGIN
1652:
1653: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1654: IF NOT (Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)) THEN
1655: RETURN;
1656: END IF;
1657:
1665: CLOSE c_get_budget_info;
1666:
1667: /* Can not allocate if available budget amount is 0 */
1668: IF (l_available_budget = 0) THEN
1669: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1670: IF l_fund_type = 'QUOTA' THEN
1671: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCNOAVAIL_ERROR');
1672: ELSE
1673: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCNOAVAIL_ERROR');
1676: END IF;
1677:
1678: /* allocation amount can not exceed available amount */
1679: IF (p_act_metric_rec.func_actual_value > l_available_budget) THEN
1680: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1681: IF l_fund_type = 'QUOTA' THEN
1682: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCAMOUNT_ERROR');
1683: ELSE
1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');
1688: Fnd_Msg_Pub.ADD;
1689: END IF;
1690:
1691: /* check start level <= end level */
1692: IF (p_act_metric_rec.from_level <> Fnd_Api.g_miss_num AND
1693: p_act_metric_rec.to_level <> Fnd_Api.g_miss_num) THEN
1694: IF (NVL(p_act_metric_rec.from_level, 0) > NVL(p_act_metric_rec.to_level, 1000)) THEN
1695: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1696: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCLEVEL_ERROR');
1689: END IF;
1690:
1691: /* check start level <= end level */
1692: IF (p_act_metric_rec.from_level <> Fnd_Api.g_miss_num AND
1693: p_act_metric_rec.to_level <> Fnd_Api.g_miss_num) THEN
1694: IF (NVL(p_act_metric_rec.from_level, 0) > NVL(p_act_metric_rec.to_level, 1000)) THEN
1695: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1696: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCLEVEL_ERROR');
1697: Fnd_Msg_Pub.ADD;
1691: /* check start level <= end level */
1692: IF (p_act_metric_rec.from_level <> Fnd_Api.g_miss_num AND
1693: p_act_metric_rec.to_level <> Fnd_Api.g_miss_num) THEN
1694: IF (NVL(p_act_metric_rec.from_level, 0) > NVL(p_act_metric_rec.to_level, 1000)) THEN
1695: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1696: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCLEVEL_ERROR');
1697: Fnd_Msg_Pub.ADD;
1698: END IF;
1699:
1699:
1700: /* 11.5.9: can not set 'ex-start-node' if start level = end level */
1701: IF (p_act_metric_rec.ex_start_node = 'Y' AND
1702: p_act_metric_rec.from_level = p_act_metric_rec.to_level) THEN
1703: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1704: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCEXSTNODE_ERROR');
1705: Fnd_Msg_Pub.ADD;
1706: END IF;
1707: END IF;
1705: Fnd_Msg_Pub.ADD;
1706: END IF;
1707: END IF;
1708:
1709: IF (p_act_metric_rec.from_date <> Fnd_Api.g_miss_date) THEN
1710: l_alloc_start_date := NVL(p_act_metric_rec.from_date, l_default_start_date);
1711: END IF;
1712:
1713: IF (p_act_metric_rec.TO_DATE <> Fnd_Api.g_miss_date) THEN
1709: IF (p_act_metric_rec.from_date <> Fnd_Api.g_miss_date) THEN
1710: l_alloc_start_date := NVL(p_act_metric_rec.from_date, l_default_start_date);
1711: END IF;
1712:
1713: IF (p_act_metric_rec.TO_DATE <> Fnd_Api.g_miss_date) THEN
1714: l_alloc_end_date := NVL(p_act_metric_rec.TO_DATE, l_default_end_date);
1715: END IF;
1716:
1717: /* check start date >= budget start date */
1715: END IF;
1716:
1717: /* check start date >= budget start date */
1718: IF (l_alloc_start_date < l_budget_start_date) THEN
1719: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1720: IF l_fund_type = 'QUOTA' THEN
1721: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCSTARTDATE_ERROR');
1722: ELSE
1723: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTDATE_ERROR');
1726: END IF;
1727:
1728: /* check end date <= budget end date */
1729: IF (l_alloc_end_date > l_budget_end_date) THEN
1730: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1731: IF l_fund_type = 'QUOTA' THEN
1732: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCENDDATE_ERROR');
1733: ELSE
1734: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCENDDATE_ERROR');
1737: END IF;
1738:
1739: /* check start date <= end date */
1740: IF (l_alloc_start_date > l_alloc_end_date) THEN
1741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1742: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCDATE_ERROR');
1743: Fnd_Msg_Pub.ADD;
1744: END IF;
1745:
1747: IF (p_act_metric_rec.HIERARCHY_TYPE = 'TERRITORY') THEN
1748: OPEN c_check_start_node_terr;
1749: FETCH c_check_start_node_terr INTO l_start_node;
1750: IF c_check_start_node_terr%NOTFOUND THEN
1751: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1752: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTNODE_ERROR');
1753: Fnd_Msg_Pub.ADD;
1754: END IF;
1755: CLOSE c_check_start_node_terr;
1760:
1761: /* 11.5.9: method 'PRIOR_YEARS_SALE' can only be used by 'TERRITORY' hierarchy and must have year set */
1762: IF (p_act_metric_rec.method_code = 'PRIOR_SALES_TOTAL') THEN
1763: IF (p_act_metric_rec.hierarchy_type <> 'TERRITORY') THEN
1764: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1765: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCPRISALE_ERROR');
1766: Fnd_Msg_Pub.ADD;
1767: END IF;
1768: IF (p_act_metric_rec.basis_year is null) THEN
1765: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCPRISALE_ERROR');
1766: Fnd_Msg_Pub.ADD;
1767: END IF;
1768: IF (p_act_metric_rec.basis_year is null) THEN
1769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1770: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCBASISYEAR_ERROR');
1771: Fnd_Msg_Pub.ADD;
1772: END IF;
1773: END IF;
1773: END IF;
1774:
1775: EXCEPTION
1776: WHEN OTHERS THEN
1777: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1778:
1779: END Validate_Alloc_Record;
1780:
1781:
1861: WHERE activity_metric_id = p_act_metric_id;
1862: l_ref_metric_rec c_ref_metric%ROWTYPE;
1863: BEGIN
1864:
1865: x_return_status := Fnd_Api.g_ret_sts_success;
1866:
1867: OPEN c_ref_metric (l_act_metrics_rec.activity_metric_id);
1868: FETCH c_ref_metric INTO l_ref_metric_rec;
1869: CLOSE c_ref_metric;
1869: CLOSE c_ref_metric;
1870:
1871:
1872: -- Validate All Modes --
1873: IF l_act_metrics_rec.arc_act_metric_used_by <> Fnd_Api.G_MISS_CHAR THEN
1874:
1875: IF l_act_metrics_rec.act_metric_used_by_id = Fnd_Api.G_MISS_NUM THEN
1876: l_act_metrics_rec.act_metric_used_by_id :=
1877: p_complete_rec.act_metric_used_by_id;
1871:
1872: -- Validate All Modes --
1873: IF l_act_metrics_rec.arc_act_metric_used_by <> Fnd_Api.G_MISS_CHAR THEN
1874:
1875: IF l_act_metrics_rec.act_metric_used_by_id = Fnd_Api.G_MISS_NUM THEN
1876: l_act_metrics_rec.act_metric_used_by_id :=
1877: p_complete_rec.act_metric_used_by_id;
1878: END IF;
1879:
1876: l_act_metrics_rec.act_metric_used_by_id :=
1877: p_complete_rec.act_metric_used_by_id;
1878: END IF;
1879:
1880: IF l_act_metrics_rec.metric_id = Fnd_Api.G_MISS_NUM THEN
1881: l_act_metrics_rec.metric_id := p_complete_rec.metric_id;
1882: END IF;
1883:
1884:
1899: ,p_pk_name => l_pk_name
1900: ,p_pk_value => l_pk_value
1901: ,p_pk_data_type => l_pk_data_type
1902: ,p_additional_where_clause => l_additional_where_clause
1903: ) = Fnd_Api.G_FALSE
1904: THEN
1905: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(
1907: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
1910: Fnd_Message.Set_Token('OBJID',l_pk_value);
1911: Fnd_Msg_Pub.ADD;
1912: END IF;
1913:
1914: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1915: END IF;
1916:
1917: -- 08/06/2001 yzhao: validation for budget allocation
1918: IF l_act_metrics_rec.arc_act_metric_used_by = 'FUND' THEN
1919: Validate_Alloc_Record (
1920: p_act_metric_rec => l_act_metrics_rec,
1921: x_return_status => l_return_status
1922: );
1923: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1924: x_return_status := l_return_status;
1925: END IF;
1926: END IF;
1927:
1927:
1928: END IF;
1929:
1930: -- METRIC_UOM_CODE
1931: IF l_act_metrics_rec.metric_uom_code <> Fnd_Api.G_MISS_CHAR THEN
1932: IF l_act_metrics_rec.metric_id = Fnd_Api.G_MISS_NUM THEN
1933: l_act_metrics_rec.metric_id := p_complete_rec.metric_id ;
1934: END IF;
1935:
1928: END IF;
1929:
1930: -- METRIC_UOM_CODE
1931: IF l_act_metrics_rec.metric_uom_code <> Fnd_Api.G_MISS_CHAR THEN
1932: IF l_act_metrics_rec.metric_id = Fnd_Api.G_MISS_NUM THEN
1933: l_act_metrics_rec.metric_id := p_complete_rec.metric_id ;
1934: END IF;
1935:
1936: /* yzhao: is METRIC_UOM_CODE used in our code? should it be removed? */
1945: ,p_pk_name => l_pk_name
1946: ,p_pk_value => l_pk_value
1947: ,p_pk_data_type => l_pk_data_type
1948: ,p_additional_where_clause => l_additional_where_clause
1949: ) = Fnd_Api.G_FALSE
1950: THEN
1951: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1952: THEN
1953: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_UOM');
1953: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_UOM');
1954: Fnd_Msg_Pub.ADD;
1955: END IF;
1956:
1957: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1958: END IF; -- Check_FK_Exists
1959: END IF;
1960:
1961:
1958: END IF; -- Check_FK_Exists
1959: END IF;
1960:
1961:
1962: IF l_act_metrics_rec.arc_activity_metric_origin <> Fnd_Api.G_MISS_CHAR THEN
1963: IF l_act_metrics_rec.activity_metric_origin_id = Fnd_Api.G_MISS_NUM THEN
1964: l_act_metrics_rec.activity_metric_origin_id :=
1965: p_complete_rec.activity_metric_origin_id;
1966: END IF;
1959: END IF;
1960:
1961:
1962: IF l_act_metrics_rec.arc_activity_metric_origin <> Fnd_Api.G_MISS_CHAR THEN
1963: IF l_act_metrics_rec.activity_metric_origin_id = Fnd_Api.G_MISS_NUM THEN
1964: l_act_metrics_rec.activity_metric_origin_id :=
1965: p_complete_rec.activity_metric_origin_id;
1966: END IF;
1967:
1982: ,p_pk_name => l_pk_name
1983: ,p_pk_value => l_pk_value
1984: ,p_pk_data_type => l_pk_data_type
1985: ,p_additional_where_clause => l_additional_where_clause
1986: ) = Fnd_Api.G_FALSE
1987: THEN
1988: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1989: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');
1990: Fnd_Msg_Pub.ADD;
1989: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');
1990: Fnd_Msg_Pub.ADD;
1991: END IF;
1992:
1993: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1994: END IF;
1995: END IF;
1996:
1997: --
1999: --
2000: /*
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2004: */
2005: END Validate_ActMetric_record;
2006:
2007:
2033: Check_Req_ActMetrics_Items(
2034: p_act_metric_rec => p_act_metric_rec,
2035: x_return_status => x_return_status
2036: );
2037: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
2038: RETURN;
2039: END IF;
2040:
2041: Check_ActMetric_Uk_Items(
2043: p_validation_mode => p_validation_mode,
2044: x_return_status => x_return_status
2045: );
2046:
2047: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
2048: RETURN;
2049: END IF;
2050:
2051: Check_ActMetric_Items(
2052: p_act_metric_rec => p_act_metric_rec,
2053: x_return_status => x_return_status
2054: );
2055:
2056: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
2057: RETURN;
2058: END IF;
2059:
2060:
2097: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2098: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2099: Fnd_Msg_Pub.ADD;
2100: END IF;
2101: RAISE Fnd_Api.g_exc_error;
2102: END IF;
2103: CLOSE c_act_metric;
2104:
2105:
2102: END IF;
2103: CLOSE c_act_metric;
2104:
2105:
2106: IF p_act_metric_rec.act_metric_used_by_id = Fnd_Api.G_MISS_NUM THEN
2107: x_complete_rec.act_metric_used_by_id := NULL;
2108: END IF;
2109: IF p_act_metric_rec.act_metric_used_by_id IS NULL THEN
2110: x_complete_rec.act_metric_used_by_id := l_act_metric_rec.act_metric_used_by_id;
2109: IF p_act_metric_rec.act_metric_used_by_id IS NULL THEN
2110: x_complete_rec.act_metric_used_by_id := l_act_metric_rec.act_metric_used_by_id;
2111: END IF;
2112:
2113: IF p_act_metric_rec.arc_act_metric_used_by = Fnd_Api.G_MISS_CHAR THEN
2114: x_complete_rec.arc_act_metric_used_by := NULL;
2115: END IF;
2116: IF p_act_metric_rec.arc_act_metric_used_by IS NULL THEN
2117: x_complete_rec.arc_act_metric_used_by := l_act_metric_rec.arc_act_metric_used_by;
2116: IF p_act_metric_rec.arc_act_metric_used_by IS NULL THEN
2117: x_complete_rec.arc_act_metric_used_by := l_act_metric_rec.arc_act_metric_used_by;
2118: END IF;
2119:
2120: IF p_act_metric_rec.purchase_req_raised_flag = Fnd_Api.G_MISS_CHAR THEN
2121: x_complete_rec.purchase_req_raised_flag := NULL;
2122: END IF;
2123: IF p_act_metric_rec.purchase_req_raised_flag IS NULL THEN
2124: x_complete_rec.purchase_req_raised_flag := l_act_metric_rec.purchase_req_raised_flag;
2123: IF p_act_metric_rec.purchase_req_raised_flag IS NULL THEN
2124: x_complete_rec.purchase_req_raised_flag := l_act_metric_rec.purchase_req_raised_flag;
2125: END IF;
2126:
2127: IF p_act_metric_rec.application_id = Fnd_Api.G_MISS_NUM THEN
2128: x_complete_rec.application_id := NULL;
2129: END IF;
2130: IF p_act_metric_rec.application_id IS NULL THEN
2131: x_complete_rec.application_id := l_act_metric_rec.application_id;
2130: IF p_act_metric_rec.application_id IS NULL THEN
2131: x_complete_rec.application_id := l_act_metric_rec.application_id;
2132: END IF;
2133:
2134: IF p_act_metric_rec.sensitive_data_flag = Fnd_Api.G_MISS_CHAR THEN
2135: x_complete_rec.sensitive_data_flag := NULL;
2136: END IF;
2137: IF p_act_metric_rec.sensitive_data_flag IS NULL THEN
2138: x_complete_rec.sensitive_data_flag := l_act_metric_rec.sensitive_data_flag;
2137: IF p_act_metric_rec.sensitive_data_flag IS NULL THEN
2138: x_complete_rec.sensitive_data_flag := l_act_metric_rec.sensitive_data_flag;
2139: END IF;
2140:
2141: IF p_act_metric_rec.budget_id = Fnd_Api.G_MISS_NUM THEN
2142: x_complete_rec.budget_id := NULL;
2143: END IF;
2144: IF p_act_metric_rec.budget_id IS NULL THEN
2145: x_complete_rec.budget_id := l_act_metric_rec.budget_id;
2144: IF p_act_metric_rec.budget_id IS NULL THEN
2145: x_complete_rec.budget_id := l_act_metric_rec.budget_id;
2146: END IF;
2147:
2148: IF p_act_metric_rec.metric_id = Fnd_Api.G_MISS_NUM THEN
2149: x_complete_rec.metric_id := NULL;
2150: END IF;
2151: IF p_act_metric_rec.metric_id IS NULL THEN
2152: x_complete_rec.metric_id := l_act_metric_rec.metric_id;
2151: IF p_act_metric_rec.metric_id IS NULL THEN
2152: x_complete_rec.metric_id := l_act_metric_rec.metric_id;
2153: END IF;
2154:
2155: IF p_act_metric_rec.transaction_currency_code = Fnd_Api.G_MISS_CHAR THEN
2156: x_complete_rec.transaction_currency_code := NULL;
2157: END IF;
2158: IF p_act_metric_rec.transaction_currency_code IS NULL THEN
2159: x_complete_rec.transaction_currency_code := l_act_metric_rec.transaction_currency_code;
2158: IF p_act_metric_rec.transaction_currency_code IS NULL THEN
2159: x_complete_rec.transaction_currency_code := l_act_metric_rec.transaction_currency_code;
2160: END IF;
2161:
2162: IF NVL(p_act_metric_rec.trans_forecasted_value,-1) = Fnd_Api.G_MISS_NUM THEN
2163: x_complete_rec.trans_forecasted_value := NULL;
2164: END IF;
2165: IF NVL(p_act_metric_rec.trans_forecasted_value,-1) IS NULL THEN
2166: x_complete_rec.trans_forecasted_value := l_act_metric_rec.trans_forecasted_value;
2165: IF NVL(p_act_metric_rec.trans_forecasted_value,-1) IS NULL THEN
2166: x_complete_rec.trans_forecasted_value := l_act_metric_rec.trans_forecasted_value;
2167: END IF;
2168:
2169: IF p_act_metric_rec.trans_committed_value = Fnd_Api.G_MISS_NUM THEN
2170: x_complete_rec.trans_committed_value := NULL;
2171: END IF;
2172: IF p_act_metric_rec.trans_committed_value IS NULL THEN
2173: x_complete_rec.trans_committed_value := l_act_metric_rec.trans_committed_value;
2172: IF p_act_metric_rec.trans_committed_value IS NULL THEN
2173: x_complete_rec.trans_committed_value := l_act_metric_rec.trans_committed_value;
2174: END IF;
2175:
2176: IF p_act_metric_rec.trans_actual_value = Fnd_Api.G_MISS_NUM THEN
2177: x_complete_rec.trans_actual_value := NULL;
2178: END IF;
2179: IF p_act_metric_rec.trans_actual_value IS NULL THEN
2180: x_complete_rec.trans_actual_value := l_act_metric_rec.trans_actual_value;
2179: IF p_act_metric_rec.trans_actual_value IS NULL THEN
2180: x_complete_rec.trans_actual_value := l_act_metric_rec.trans_actual_value;
2181: END IF;
2182:
2183: IF p_act_metric_rec.functional_currency_code = Fnd_Api.G_MISS_CHAR THEN
2184: x_complete_rec.functional_currency_code := NULL;
2185: END IF;
2186: IF p_act_metric_rec.functional_currency_code IS NULL THEN
2187: x_complete_rec.functional_currency_code := l_act_metric_rec.functional_currency_code;
2186: IF p_act_metric_rec.functional_currency_code IS NULL THEN
2187: x_complete_rec.functional_currency_code := l_act_metric_rec.functional_currency_code;
2188: END IF;
2189:
2190: IF p_act_metric_rec.func_forecasted_value = Fnd_Api.G_MISS_NUM THEN
2191: x_complete_rec.func_forecasted_value := NULL;
2192: END IF;
2193: IF p_act_metric_rec.func_forecasted_value IS NULL THEN
2194: x_complete_rec.func_forecasted_value := l_act_metric_rec.func_forecasted_value;
2193: IF p_act_metric_rec.func_forecasted_value IS NULL THEN
2194: x_complete_rec.func_forecasted_value := l_act_metric_rec.func_forecasted_value;
2195: END IF;
2196:
2197: IF p_act_metric_rec.func_committed_value = Fnd_Api.G_MISS_NUM THEN
2198: x_complete_rec.func_committed_value := NULL;
2199: END IF;
2200: IF p_act_metric_rec.func_committed_value IS NULL THEN
2201: x_complete_rec.func_committed_value := l_act_metric_rec.func_committed_value;
2200: IF p_act_metric_rec.func_committed_value IS NULL THEN
2201: x_complete_rec.func_committed_value := l_act_metric_rec.func_committed_value;
2202: END IF;
2203:
2204: IF p_act_metric_rec.func_actual_value = Fnd_Api.G_MISS_NUM THEN
2205: x_complete_rec.func_actual_value := NULL;
2206: END IF;
2207: IF p_act_metric_rec.func_actual_value IS NULL THEN
2208: x_complete_rec.func_actual_value := l_act_metric_rec.func_actual_value;
2207: IF p_act_metric_rec.func_actual_value IS NULL THEN
2208: x_complete_rec.func_actual_value := l_act_metric_rec.func_actual_value;
2209: END IF;
2210:
2211: IF p_act_metric_rec.dirty_flag = Fnd_Api.G_MISS_CHAR THEN
2212: x_complete_rec.dirty_flag := NULL;
2213: END IF;
2214: IF p_act_metric_rec.dirty_flag IS NULL THEN
2215: IF (l_act_metric_rec.trans_actual_value <>
2227: x_complete_rec.dirty_flag := NVL(l_act_metric_rec.dirty_flag,'Y');
2228: END IF;
2229: END IF;
2230:
2231: IF p_act_metric_rec.last_calculated_date = Fnd_Api.G_MISS_DATE THEN
2232: x_complete_rec.last_calculated_date := NULL;
2233: END IF;
2234: IF p_act_metric_rec.last_calculated_date IS NULL THEN
2235: x_complete_rec.last_calculated_date := l_act_metric_rec.last_calculated_date;
2234: IF p_act_metric_rec.last_calculated_date IS NULL THEN
2235: x_complete_rec.last_calculated_date := l_act_metric_rec.last_calculated_date;
2236: END IF;
2237:
2238: IF p_act_metric_rec.variable_value = Fnd_Api.G_MISS_NUM THEN
2239: x_complete_rec.variable_value := NULL;
2240: END IF;
2241: IF p_act_metric_rec.variable_value IS NULL THEN
2242: x_complete_rec.variable_value := l_act_metric_rec.variable_value;
2241: IF p_act_metric_rec.variable_value IS NULL THEN
2242: x_complete_rec.variable_value := l_act_metric_rec.variable_value;
2243: END IF;
2244:
2245: IF p_act_metric_rec.computed_using_function_value = Fnd_Api.G_MISS_NUM THEN
2246: x_complete_rec.computed_using_function_value := NULL;
2247: END IF;
2248: IF p_act_metric_rec.computed_using_function_value IS NULL THEN
2249: x_complete_rec.computed_using_function_value := l_act_metric_rec.computed_using_function_value;
2248: IF p_act_metric_rec.computed_using_function_value IS NULL THEN
2249: x_complete_rec.computed_using_function_value := l_act_metric_rec.computed_using_function_value;
2250: END IF;
2251:
2252: IF p_act_metric_rec.metric_uom_code = Fnd_Api.G_MISS_CHAR THEN
2253: x_complete_rec.metric_uom_code := NULL;
2254: END IF;
2255: IF p_act_metric_rec.metric_uom_code IS NULL THEN
2256: x_complete_rec.metric_uom_code := l_act_metric_rec.metric_uom_code;
2255: IF p_act_metric_rec.metric_uom_code IS NULL THEN
2256: x_complete_rec.metric_uom_code := l_act_metric_rec.metric_uom_code;
2257: END IF;
2258:
2259: IF p_act_metric_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
2260: x_complete_rec.attribute_category := NULL;
2261: END IF;
2262: IF p_act_metric_rec.attribute_category IS NULL THEN
2263: x_complete_rec.attribute_category := l_act_metric_rec.attribute_category;
2262: IF p_act_metric_rec.attribute_category IS NULL THEN
2263: x_complete_rec.attribute_category := l_act_metric_rec.attribute_category;
2264: END IF;
2265:
2266: IF p_act_metric_rec.difference_since_last_calc = Fnd_Api.G_MISS_NUM THEN
2267: x_complete_rec.difference_since_last_calc := NULL;
2268: END IF;
2269: IF p_act_metric_rec.difference_since_last_calc IS NULL THEN
2270: x_complete_rec.difference_since_last_calc := l_act_metric_rec.difference_since_last_calc;
2269: IF p_act_metric_rec.difference_since_last_calc IS NULL THEN
2270: x_complete_rec.difference_since_last_calc := l_act_metric_rec.difference_since_last_calc;
2271: END IF;
2272:
2273: IF p_act_metric_rec.activity_metric_origin_id = Fnd_Api.G_MISS_NUM THEN
2274: x_complete_rec.activity_metric_origin_id := NULL;
2275: END IF;
2276: IF p_act_metric_rec.activity_metric_origin_id IS NULL THEN
2277: x_complete_rec.activity_metric_origin_id := l_act_metric_rec.activity_metric_origin_id;
2276: IF p_act_metric_rec.activity_metric_origin_id IS NULL THEN
2277: x_complete_rec.activity_metric_origin_id := l_act_metric_rec.activity_metric_origin_id;
2278: END IF;
2279:
2280: IF p_act_metric_rec.arc_activity_metric_origin = Fnd_Api.G_MISS_CHAR THEN
2281: x_complete_rec.arc_activity_metric_origin := NULL;
2282: END IF;
2283: IF p_act_metric_rec.arc_activity_metric_origin IS NULL THEN
2284: x_complete_rec.arc_activity_metric_origin := l_act_metric_rec.arc_activity_metric_origin;
2283: IF p_act_metric_rec.arc_activity_metric_origin IS NULL THEN
2284: x_complete_rec.arc_activity_metric_origin := l_act_metric_rec.arc_activity_metric_origin;
2285: END IF;
2286:
2287: IF p_act_metric_rec.days_since_last_refresh = Fnd_Api.G_MISS_NUM THEN
2288: x_complete_rec.days_since_last_refresh := NULL;
2289: END IF;
2290: IF p_act_metric_rec.days_since_last_refresh IS NULL THEN
2291: x_complete_rec.days_since_last_refresh := l_act_metric_rec.days_since_last_refresh;
2290: IF p_act_metric_rec.days_since_last_refresh IS NULL THEN
2291: x_complete_rec.days_since_last_refresh := l_act_metric_rec.days_since_last_refresh;
2292: END IF;
2293:
2294: IF p_act_metric_rec.scenario_id = Fnd_Api.G_MISS_NUM THEN
2295: x_complete_rec.scenario_id := NULL;
2296: END IF;
2297: IF p_act_metric_rec.scenario_id IS NULL THEN
2298: x_complete_rec.scenario_id := l_act_metric_rec.scenario_id;
2301: /***************************************************************/
2302: /*added 17-Apr-2000 tdonohoe@us support 11.5.2 columns */
2303: /***************************************************************/
2304:
2305: IF p_act_metric_rec.hierarchy_id = Fnd_Api.G_MISS_NUM THEN
2306: x_complete_rec.hierarchy_id := NULL;
2307: END IF;
2308: IF p_act_metric_rec.hierarchy_id IS NULL THEN
2309: x_complete_rec.hierarchy_id := l_act_metric_rec.hierarchy_id;
2308: IF p_act_metric_rec.hierarchy_id IS NULL THEN
2309: x_complete_rec.hierarchy_id := l_act_metric_rec.hierarchy_id;
2310: END IF;
2311:
2312: IF p_act_metric_rec.start_node = Fnd_Api.G_MISS_NUM THEN
2313: x_complete_rec.start_node := NULL;
2314: END IF;
2315: IF p_act_metric_rec.start_node IS NULL THEN
2316: x_complete_rec.start_node := l_act_metric_rec.start_node;
2315: IF p_act_metric_rec.start_node IS NULL THEN
2316: x_complete_rec.start_node := l_act_metric_rec.start_node;
2317: END IF;
2318:
2319: IF p_act_metric_rec.from_level = Fnd_Api.G_MISS_NUM THEN
2320: x_complete_rec.from_level := NULL;
2321: END IF;
2322: IF p_act_metric_rec.from_level IS NULL THEN
2323: x_complete_rec.from_level := l_act_metric_rec.from_level;
2322: IF p_act_metric_rec.from_level IS NULL THEN
2323: x_complete_rec.from_level := l_act_metric_rec.from_level;
2324: END IF;
2325:
2326: IF p_act_metric_rec.to_level = Fnd_Api.G_MISS_NUM THEN
2327: x_complete_rec.to_level := NULL;
2328: END IF;
2329: IF p_act_metric_rec.to_level IS NULL THEN
2330: x_complete_rec.to_level := l_act_metric_rec.to_level;
2329: IF p_act_metric_rec.to_level IS NULL THEN
2330: x_complete_rec.to_level := l_act_metric_rec.to_level;
2331: END IF;
2332:
2333: IF p_act_metric_rec.from_date = Fnd_Api.G_MISS_DATE THEN
2334: x_complete_rec.from_date := NULL;
2335: END IF;
2336: IF p_act_metric_rec.from_date IS NULL THEN
2337: x_complete_rec.from_date := l_act_metric_rec.from_date;
2336: IF p_act_metric_rec.from_date IS NULL THEN
2337: x_complete_rec.from_date := l_act_metric_rec.from_date;
2338: END IF;
2339:
2340: IF p_act_metric_rec.TO_DATE = Fnd_Api.G_MISS_DATE THEN
2341: x_complete_rec.TO_DATE := NULL;
2342: END IF;
2343: IF p_act_metric_rec.TO_DATE IS NULL THEN
2344: x_complete_rec.TO_DATE := l_act_metric_rec.TO_DATE;
2343: IF p_act_metric_rec.TO_DATE IS NULL THEN
2344: x_complete_rec.TO_DATE := l_act_metric_rec.TO_DATE;
2345: END IF;
2346:
2347: IF p_act_metric_rec.amount1 = Fnd_Api.G_MISS_NUM THEN
2348: x_complete_rec.amount1 := NULL;
2349: END IF;
2350: IF p_act_metric_rec.amount1 IS NULL THEN
2351: x_complete_rec.amount1 := l_act_metric_rec.amount1;
2350: IF p_act_metric_rec.amount1 IS NULL THEN
2351: x_complete_rec.amount1 := l_act_metric_rec.amount1;
2352: END IF;
2353:
2354: IF p_act_metric_rec.amount2 = Fnd_Api.G_MISS_NUM THEN
2355: x_complete_rec.amount2 := NULL;
2356: END IF;
2357: IF p_act_metric_rec.amount2 IS NULL THEN
2358: x_complete_rec.amount2 := l_act_metric_rec.amount2;
2357: IF p_act_metric_rec.amount2 IS NULL THEN
2358: x_complete_rec.amount2 := l_act_metric_rec.amount2;
2359: END IF;
2360:
2361: IF p_act_metric_rec.amount3 = Fnd_Api.G_MISS_NUM THEN
2362: x_complete_rec.amount3 := NULL;
2363: END IF;
2364: IF p_act_metric_rec.amount3 IS NULL THEN
2365: x_complete_rec.amount3 := l_act_metric_rec.amount3;
2364: IF p_act_metric_rec.amount3 IS NULL THEN
2365: x_complete_rec.amount3 := l_act_metric_rec.amount3;
2366: END IF;
2367:
2368: IF p_act_metric_rec.percent1 = Fnd_Api.G_MISS_NUM THEN
2369: x_complete_rec.percent1 := NULL;
2370: END IF;
2371: IF p_act_metric_rec.percent1 IS NULL THEN
2372: x_complete_rec.percent1 := l_act_metric_rec.percent1;
2371: IF p_act_metric_rec.percent1 IS NULL THEN
2372: x_complete_rec.percent1 := l_act_metric_rec.percent1;
2373: END IF;
2374:
2375: IF p_act_metric_rec.percent2 = Fnd_Api.G_MISS_NUM THEN
2376: x_complete_rec.percent2 := NULL;
2377: END IF;
2378: IF p_act_metric_rec.percent2 IS NULL THEN
2379: x_complete_rec.percent2 := l_act_metric_rec.percent2;
2378: IF p_act_metric_rec.percent2 IS NULL THEN
2379: x_complete_rec.percent2 := l_act_metric_rec.percent2;
2380: END IF;
2381:
2382: IF p_act_metric_rec.percent3 = Fnd_Api.G_MISS_NUM THEN
2383: x_complete_rec.percent3 := NULL;
2384: END IF;
2385: IF p_act_metric_rec.percent3 IS NULL THEN
2386: x_complete_rec.percent3 := l_act_metric_rec.percent3;
2385: IF p_act_metric_rec.percent3 IS NULL THEN
2386: x_complete_rec.percent3 := l_act_metric_rec.percent3;
2387: END IF;
2388:
2389: IF p_act_metric_rec.published_flag = Fnd_Api.G_MISS_CHAR THEN
2390: x_complete_rec.published_flag := NULL;
2391: END IF;
2392: IF p_act_metric_rec.published_flag IS NULL THEN
2393: x_complete_rec.published_flag := l_act_metric_rec.published_flag;
2392: IF p_act_metric_rec.published_flag IS NULL THEN
2393: x_complete_rec.published_flag := l_act_metric_rec.published_flag;
2394: END IF;
2395:
2396: IF p_act_metric_rec.pre_function_name = Fnd_Api.G_MISS_CHAR THEN
2397: x_complete_rec.pre_function_name := NULL;
2398: END IF;
2399: IF p_act_metric_rec.pre_function_name IS NULL THEN
2400: x_complete_rec.pre_function_name := l_act_metric_rec.pre_function_name;
2399: IF p_act_metric_rec.pre_function_name IS NULL THEN
2400: x_complete_rec.pre_function_name := l_act_metric_rec.pre_function_name;
2401: END IF;
2402:
2403: IF p_act_metric_rec.post_function_name = Fnd_Api.G_MISS_CHAR THEN
2404: x_complete_rec.post_function_name := NULL;
2405: END IF;
2406: IF p_act_metric_rec.post_function_name IS NULL THEN
2407: x_complete_rec.post_function_name := l_act_metric_rec.post_function_name;
2406: IF p_act_metric_rec.post_function_name IS NULL THEN
2407: x_complete_rec.post_function_name := l_act_metric_rec.post_function_name;
2408: END IF;
2409:
2410: IF p_act_metric_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN
2411: x_complete_rec.attribute1 := NULL;
2412: END IF;
2413: IF p_act_metric_rec.attribute1 IS NULL THEN
2414: x_complete_rec.attribute1 := l_act_metric_rec.attribute1;
2413: IF p_act_metric_rec.attribute1 IS NULL THEN
2414: x_complete_rec.attribute1 := l_act_metric_rec.attribute1;
2415: END IF;
2416:
2417: IF p_act_metric_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN
2418: x_complete_rec.attribute2 := NULL;
2419: END IF;
2420: IF p_act_metric_rec.attribute2 IS NULL THEN
2421: x_complete_rec.attribute2 := l_act_metric_rec.attribute2;
2420: IF p_act_metric_rec.attribute2 IS NULL THEN
2421: x_complete_rec.attribute2 := l_act_metric_rec.attribute2;
2422: END IF;
2423:
2424: IF p_act_metric_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN
2425: x_complete_rec.attribute3 := NULL;
2426: END IF;
2427: IF p_act_metric_rec.attribute3 IS NULL THEN
2428: x_complete_rec.attribute3 := l_act_metric_rec.attribute3;
2427: IF p_act_metric_rec.attribute3 IS NULL THEN
2428: x_complete_rec.attribute3 := l_act_metric_rec.attribute3;
2429: END IF;
2430:
2431: IF p_act_metric_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN
2432: x_complete_rec.attribute4 := NULL;
2433: END IF;
2434: IF p_act_metric_rec.attribute4 IS NULL THEN
2435: x_complete_rec.attribute4 := l_act_metric_rec.attribute4;
2434: IF p_act_metric_rec.attribute4 IS NULL THEN
2435: x_complete_rec.attribute4 := l_act_metric_rec.attribute4;
2436: END IF;
2437:
2438: IF p_act_metric_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN
2439: x_complete_rec.attribute5 := NULL;
2440: END IF;
2441: IF p_act_metric_rec.attribute5 IS NULL THEN
2442: x_complete_rec.attribute5 := l_act_metric_rec.attribute5;
2441: IF p_act_metric_rec.attribute5 IS NULL THEN
2442: x_complete_rec.attribute5 := l_act_metric_rec.attribute5;
2443: END IF;
2444:
2445: IF p_act_metric_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN
2446: x_complete_rec.attribute6 := NULL;
2447: END IF;
2448: IF p_act_metric_rec.attribute6 IS NULL THEN
2449: x_complete_rec.attribute6 := l_act_metric_rec.attribute6;
2448: IF p_act_metric_rec.attribute6 IS NULL THEN
2449: x_complete_rec.attribute6 := l_act_metric_rec.attribute6;
2450: END IF;
2451:
2452: IF p_act_metric_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN
2453: x_complete_rec.attribute7 := NULL;
2454: END IF;
2455: IF p_act_metric_rec.attribute7 IS NULL THEN
2456: x_complete_rec.attribute7 := l_act_metric_rec.attribute7;
2455: IF p_act_metric_rec.attribute7 IS NULL THEN
2456: x_complete_rec.attribute7 := l_act_metric_rec.attribute7;
2457: END IF;
2458:
2459: IF p_act_metric_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN
2460: x_complete_rec.attribute8 := NULL;
2461: END IF;
2462: IF p_act_metric_rec.attribute8 IS NULL THEN
2463: x_complete_rec.attribute8 := l_act_metric_rec.attribute8;
2462: IF p_act_metric_rec.attribute8 IS NULL THEN
2463: x_complete_rec.attribute8 := l_act_metric_rec.attribute8;
2464: END IF;
2465:
2466: IF p_act_metric_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN
2467: x_complete_rec.attribute9 := NULL;
2468: END IF;
2469: IF p_act_metric_rec.attribute9 IS NULL THEN
2470: x_complete_rec.attribute9 := l_act_metric_rec.attribute9;
2469: IF p_act_metric_rec.attribute9 IS NULL THEN
2470: x_complete_rec.attribute9 := l_act_metric_rec.attribute9;
2471: END IF;
2472:
2473: IF p_act_metric_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN
2474: x_complete_rec.attribute10 := NULL;
2475: END IF;
2476: IF p_act_metric_rec.attribute10 IS NULL THEN
2477: x_complete_rec.attribute10 := l_act_metric_rec.attribute10;
2476: IF p_act_metric_rec.attribute10 IS NULL THEN
2477: x_complete_rec.attribute10 := l_act_metric_rec.attribute10;
2478: END IF;
2479:
2480: IF p_act_metric_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN
2481: x_complete_rec.attribute11 := NULL;
2482: END IF;
2483: IF p_act_metric_rec.attribute11 IS NULL THEN
2484: x_complete_rec.attribute11 := l_act_metric_rec.attribute11;
2483: IF p_act_metric_rec.attribute11 IS NULL THEN
2484: x_complete_rec.attribute11 := l_act_metric_rec.attribute11;
2485: END IF;
2486:
2487: IF p_act_metric_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN
2488: x_complete_rec.attribute12 := NULL;
2489: END IF;
2490: IF p_act_metric_rec.attribute12 IS NULL THEN
2491: x_complete_rec.attribute12 := l_act_metric_rec.attribute12;
2490: IF p_act_metric_rec.attribute12 IS NULL THEN
2491: x_complete_rec.attribute12 := l_act_metric_rec.attribute12;
2492: END IF;
2493:
2494: IF p_act_metric_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN
2495: x_complete_rec.attribute13 := NULL;
2496: END IF;
2497: IF p_act_metric_rec.attribute13 IS NULL THEN
2498: x_complete_rec.attribute13 := l_act_metric_rec.attribute13;
2497: IF p_act_metric_rec.attribute13 IS NULL THEN
2498: x_complete_rec.attribute13 := l_act_metric_rec.attribute13;
2499: END IF;
2500:
2501: IF p_act_metric_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN
2502: x_complete_rec.attribute14 := NULL;
2503: END IF;
2504: IF p_act_metric_rec.attribute14 IS NULL THEN
2505: x_complete_rec.attribute14 := l_act_metric_rec.attribute14;
2504: IF p_act_metric_rec.attribute14 IS NULL THEN
2505: x_complete_rec.attribute14 := l_act_metric_rec.attribute14;
2506: END IF;
2507:
2508: IF p_act_metric_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN
2509: x_complete_rec.attribute15 := NULL;
2510: END IF;
2511: IF p_act_metric_rec.attribute15 IS NULL THEN
2512: x_complete_rec.attribute15 := l_act_metric_rec.attribute15;
2512: x_complete_rec.attribute15 := l_act_metric_rec.attribute15;
2513: END IF;
2514:
2515: -- DMVINCEN 05/01/2001: New columns.
2516: IF p_act_metric_rec.act_metric_date = Fnd_Api.G_MISS_DATE THEN
2517: x_complete_rec.act_metric_date := NULL;
2518: END IF;
2519: IF p_act_metric_rec.act_metric_date IS NULL THEN
2520: x_complete_rec.act_metric_date := l_act_metric_rec.act_metric_date;
2519: IF p_act_metric_rec.act_metric_date IS NULL THEN
2520: x_complete_rec.act_metric_date := l_act_metric_rec.act_metric_date;
2521: END IF;
2522:
2523: IF p_act_metric_rec.description = Fnd_Api.G_MISS_CHAR THEN
2524: x_complete_rec.description := NULL;
2525: END IF;
2526: IF p_act_metric_rec.description IS NULL THEN
2527: x_complete_rec.description := l_act_metric_rec.description;
2528: END IF;
2529:
2530: -- DMVINCEN 05/01/2001: End new columns.
2531:
2532: IF p_act_metric_rec.depend_act_metric = Fnd_Api.G_MISS_NUM THEN
2533: x_complete_rec.depend_act_metric := NULL;
2534: END IF;
2535: IF p_act_metric_rec.depend_act_metric IS NULL THEN
2536: x_complete_rec.depend_act_metric := l_act_metric_rec.depend_act_metric;
2537: END IF;
2538:
2539: -- DMVINCEN 03/08/2002:
2540:
2541: IF p_act_metric_rec.function_used_by_id = Fnd_Api.G_MISS_NUM THEN
2542: x_complete_rec.function_used_by_id := NULL;
2543: END IF;
2544: IF p_act_metric_rec.function_used_by_id IS NULL THEN
2545: x_complete_rec.function_used_by_id := l_act_metric_rec.function_used_by_id;
2544: IF p_act_metric_rec.function_used_by_id IS NULL THEN
2545: x_complete_rec.function_used_by_id := l_act_metric_rec.function_used_by_id;
2546: END IF;
2547:
2548: IF p_act_metric_rec.arc_function_used_by = Fnd_Api.G_MISS_CHAR THEN
2549: x_complete_rec.arc_function_used_by := NULL;
2550: END IF;
2551: IF p_act_metric_rec.arc_function_used_by IS NULL THEN
2552: x_complete_rec.arc_function_used_by := l_act_metric_rec.arc_function_used_by;
2552: x_complete_rec.arc_function_used_by := l_act_metric_rec.arc_function_used_by;
2553: END IF;
2554:
2555: /* 05/15/2002 yzhao: add 6 new columns for top-down bottom-up budgeting */
2556: IF p_act_metric_rec.hierarchy_type = Fnd_Api.G_MISS_CHAR THEN
2557: x_complete_rec.hierarchy_type := NULL;
2558: END IF;
2559: IF p_act_metric_rec.hierarchy_type IS NULL THEN
2560: x_complete_rec.hierarchy_type := l_act_metric_rec.hierarchy_type;
2559: IF p_act_metric_rec.hierarchy_type IS NULL THEN
2560: x_complete_rec.hierarchy_type := l_act_metric_rec.hierarchy_type;
2561: END IF;
2562:
2563: IF p_act_metric_rec.status_code = Fnd_Api.G_MISS_CHAR THEN
2564: x_complete_rec.status_code := NULL;
2565: END IF;
2566: IF p_act_metric_rec.status_code IS NULL THEN
2567: x_complete_rec.status_code := l_act_metric_rec.status_code;
2566: IF p_act_metric_rec.status_code IS NULL THEN
2567: x_complete_rec.status_code := l_act_metric_rec.status_code;
2568: END IF;
2569:
2570: IF p_act_metric_rec.method_code = Fnd_Api.G_MISS_CHAR THEN
2571: x_complete_rec.method_code := NULL;
2572: END IF;
2573: IF p_act_metric_rec.method_code IS NULL THEN
2574: x_complete_rec.method_code := l_act_metric_rec.method_code;
2573: IF p_act_metric_rec.method_code IS NULL THEN
2574: x_complete_rec.method_code := l_act_metric_rec.method_code;
2575: END IF;
2576:
2577: IF p_act_metric_rec.action_code = Fnd_Api.G_MISS_CHAR THEN
2578: x_complete_rec.action_code := NULL;
2579: END IF;
2580: IF p_act_metric_rec.action_code IS NULL THEN
2581: x_complete_rec.action_code := l_act_metric_rec.action_code;
2580: IF p_act_metric_rec.action_code IS NULL THEN
2581: x_complete_rec.action_code := l_act_metric_rec.action_code;
2582: END IF;
2583:
2584: IF p_act_metric_rec.basis_year = Fnd_Api.G_MISS_NUM THEN
2585: x_complete_rec.basis_year := NULL;
2586: END IF;
2587: IF p_act_metric_rec.basis_year IS NULL THEN
2588: x_complete_rec.basis_year := l_act_metric_rec.basis_year;
2587: IF p_act_metric_rec.basis_year IS NULL THEN
2588: x_complete_rec.basis_year := l_act_metric_rec.basis_year;
2589: END IF;
2590:
2591: IF p_act_metric_rec.ex_start_node = Fnd_Api.G_MISS_CHAR THEN
2592: x_complete_rec.ex_start_node := NULL;
2593: END IF;
2594: IF p_act_metric_rec.ex_start_node IS NULL THEN
2595: x_complete_rec.ex_start_node := l_act_metric_rec.ex_start_node;
2595: x_complete_rec.ex_start_node := l_act_metric_rec.ex_start_node;
2596: END IF;
2597: /* 05/15/2002 yzhao: add ends */
2598:
2599: IF p_act_metric_rec.product_spread_time_id = Fnd_Api.G_MISS_NUM THEN
2600: x_complete_rec.product_spread_time_id := NULL;
2601: END IF;
2602: IF p_act_metric_rec.product_spread_time_id IS NULL THEN
2603: x_complete_rec.product_spread_time_id := l_act_metric_rec.product_spread_time_id;
2602: IF p_act_metric_rec.product_spread_time_id IS NULL THEN
2603: x_complete_rec.product_spread_time_id := l_act_metric_rec.product_spread_time_id;
2604: END IF;
2605:
2606: IF p_act_metric_rec.start_period_name = Fnd_Api.G_MISS_CHAR THEN
2607: x_complete_rec.start_period_name := NULL;
2608: END IF;
2609: IF p_act_metric_rec.start_period_name IS NULL THEN
2610: x_complete_rec.start_period_name := l_act_metric_rec.start_period_name;
2609: IF p_act_metric_rec.start_period_name IS NULL THEN
2610: x_complete_rec.start_period_name := l_act_metric_rec.start_period_name;
2611: END IF;
2612:
2613: IF p_act_metric_rec.end_period_name = Fnd_Api.G_MISS_CHAR THEN
2614: x_complete_rec.end_period_name := NULL;
2615: END IF;
2616: IF p_act_metric_rec.end_period_name IS NULL THEN
2617: x_complete_rec.end_period_name := l_act_metric_rec.end_period_name;