[Home] [Help]
36: )
37: IS
38: BEGIN
39:
40: x_actforecast_rec.forecast_id := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
37: IS
38: BEGIN
39:
40: x_actforecast_rec.forecast_id := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
38: BEGIN
39:
40: x_actforecast_rec.forecast_id := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
39:
40: x_actforecast_rec.forecast_id := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
40: x_actforecast_rec.forecast_id := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
41: x_actforecast_rec.arc_act_fcast_used_by := FND_API.g_miss_char;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
42: x_actforecast_rec.act_fcast_used_by_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
43: x_actforecast_rec.creation_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
44: x_actforecast_rec.created_from := FND_API.g_miss_char;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
45: x_actforecast_rec.created_by := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
46: x_actforecast_rec.last_update_date := FND_API.g_miss_date;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
47: x_actforecast_rec.last_updated_by := FND_API.g_miss_num;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
48: x_actforecast_rec.last_update_login := FND_API.g_miss_num;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
49: x_actforecast_rec.program_application_id := FND_API.g_miss_num;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
50: x_actforecast_rec.program_id := FND_API.g_miss_num;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
51: x_actforecast_rec.program_update_date := FND_API.g_miss_date;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
52: x_actforecast_rec.request_id := FND_API.g_miss_num;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
53: x_actforecast_rec.object_version_number := FND_API.g_miss_num;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
54: x_actforecast_rec.hierarchy := FND_API.g_miss_char;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
55: x_actforecast_rec.hierarchy_level := FND_API.g_miss_char;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
56: x_actforecast_rec.level_value := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
57: x_actforecast_rec.forecast_calendar := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
58: x_actforecast_rec.period_level := FND_API.g_miss_char;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
59: x_actforecast_rec.forecast_period_id := FND_API.g_miss_num;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
60: x_actforecast_rec.forecast_date := FND_API.g_miss_date;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
61: x_actforecast_rec.forecast_uom_code := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
62: x_actforecast_rec.forecast_quantity := FND_API.g_miss_num;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
63: x_actforecast_rec.forward_buy_quantity := FND_API.g_miss_num;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
64: x_actforecast_rec.forward_buy_period := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
65: x_actforecast_rec.cumulation_period_choice := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
66: x_actforecast_rec.base_quantity := FND_API.g_miss_num;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
67: x_actforecast_rec.context := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
68: x_actforecast_rec.attribute_category := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
69: x_actforecast_rec.attribute1 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
70: x_actforecast_rec.attribute2 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
71: x_actforecast_rec.attribute3 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
72: x_actforecast_rec.attribute4 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
73: x_actforecast_rec.attribute5 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
74: x_actforecast_rec.attribute6 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
75: x_actforecast_rec.attribute7 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
76: x_actforecast_rec.attribute8 := FND_API.g_miss_char;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
77: x_actforecast_rec.attribute9 := FND_API.g_miss_char;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
78: x_actforecast_rec.attribute10 := FND_API.g_miss_char;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
79: x_actforecast_rec.attribute11 := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
80: x_actforecast_rec.attribute12 := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
81: x_actforecast_rec.attribute13 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
82: x_actforecast_rec.attribute14 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
83: x_actforecast_rec.attribute15 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
84: x_actforecast_rec.org_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
85: x_actforecast_rec.forecast_remaining_quantity := FND_API.g_miss_num;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
86: x_actforecast_rec.forecast_remaining_percent := FND_API.g_miss_num;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
87: x_actforecast_rec.base_quantity_type := FND_API.g_miss_char;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
88: x_actforecast_rec.forecast_spread_type := FND_API.g_miss_char;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
89: x_actforecast_rec.dimention1 := FND_API.g_miss_char;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
90: x_actforecast_rec.dimention2 := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
91: x_actforecast_rec.dimention3 := FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
99: x_actforecast_rec.offer_code:= FND_API.g_miss_char;
92: x_actforecast_rec.last_scenario_id := FND_API.g_miss_num;
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
99: x_actforecast_rec.offer_code:= FND_API.g_miss_char;
100:
93: x_actforecast_rec.freeze_flag := FND_API.g_miss_char;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
99: x_actforecast_rec.offer_code:= FND_API.g_miss_char;
100:
101: END;
94: x_actforecast_rec.comments := FND_API.g_miss_char;
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
99: x_actforecast_rec.offer_code:= FND_API.g_miss_char;
100:
101: END;
102:
95: x_actforecast_rec.price_list_id := FND_API.g_miss_num;
96: x_actforecast_rec.base_quantity_start_date := FND_API.g_miss_date;
97: x_actforecast_rec.base_quantity_end_date := FND_API.g_miss_date;
98: x_actforecast_rec.base_quantity_ref := FND_API.g_miss_char;
99: x_actforecast_rec.offer_code:= FND_API.g_miss_char;
100:
101: END;
102:
103:
117: -- End of comments
118:
119:
120: PROCEDURE Default_ActForecast(
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_act_forecast_rec IN act_forecast_rec_type,
123: p_validation_mode IN VARCHAR2 ,
124: x_complete_rec OUT NOCOPY act_forecast_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2,
131: BEGIN
132: --
133: -- Initialize message list if p_init_msg_list is set to TRUE.
134: --
135: IF FND_API.To_Boolean (p_init_msg_list) THEN
136: FND_MSG_PUB.Initialize;
137: END IF;
138:
139: --
138:
139: --
140: -- Initialize API return status to success.
141: --
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: x_complete_rec := p_act_forecast_rec;
145:
146: -- Insert Mode
188: -- End of comments
189:
190: PROCEDURE Create_ActForecast (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
189:
190: PROCEDURE Create_ActForecast (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
190: PROCEDURE Create_ActForecast (
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_commit IN VARCHAR2 := FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
195:
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
241:
242: --
243: -- Initialize message list if p_init_msg_list is set to TRUE.
244: --
245: IF FND_API.To_Boolean (p_init_msg_list) THEN
246: FND_MSG_PUB.Initialize;
247: END IF;
248:
249: --
248:
249: --
250: -- Standard check for API version compatibility.
251: --
252: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
253: p_api_version,
254: L_API_NAME,
255: G_PKG_NAME)
256: THEN
253: p_api_version,
254: L_API_NAME,
255: G_PKG_NAME)
256: THEN
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258: END IF;
259:
260: --
261: -- Initialize API return status to success.
259:
260: --
261: -- Initialize API return status to success.
262: --
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: --
266: -- Begin API Body.
267: --
277:
278:
279:
280: -- If any errors happen abort API.
281: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
278:
279:
280: -- If any errors happen abort API.
281: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
279:
280: -- If any errors happen abort API.
281: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287:
280: -- If any errors happen abort API.
281: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
282: RAISE FND_API.G_EXC_ERROR;
283: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287:
288:
319: p_act_forecast_rec => l_act_forecast_rec
320: );
321:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
320: );
321:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
321:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329:
322: -- If any errors happen abort API.
323: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329:
330: --
466: ,l_act_forecast_rec.offer_code);
467:
468:
469: -- If any errors happen abort API.
470: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
467:
468:
469: -- If any errors happen abort API.
470: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
468:
469: -- If any errors happen abort API.
470: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476:
469: -- If any errors happen abort API.
470: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE FND_API.G_EXC_ERROR;
472: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476:
477: -- finish
487:
488: --
489: -- Standard check for commit request.
490: --
491: IF FND_API.To_Boolean (p_commit) THEN
492: COMMIT WORK;
493: END IF;
494:
495: --
498: --
499: FND_MSG_PUB.Count_And_Get (
500: p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => FND_API.G_FALSE
503: );
504:
505: --
506: -- Add success message to message list.
517:
518:
519:
520: EXCEPTION
521: WHEN FND_API.G_EXC_ERROR THEN
522:
523:
524: ROLLBACK TO Create_ActForecast_Pvt;
525: x_return_status := FND_API.G_RET_STS_ERROR;
521: WHEN FND_API.G_EXC_ERROR THEN
522:
523:
524: ROLLBACK TO Create_ActForecast_Pvt;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531:
532:
533:
534: ROLLBACK TO Create_ActForecast_Pvt;
531:
532:
533:
534: ROLLBACK TO Create_ActForecast_Pvt;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MSG_PUB.Count_And_Get (
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540: WHEN OTHERS THEN
541:
542:
543: ROLLBACK TO Create_ActForecast_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
546: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
547: END IF;
548: FND_MSG_PUB.Count_And_Get (
568: -- End of comments
569:
570: PROCEDURE Update_ActForecast (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: x_return_status OUT NOCOPY VARCHAR2,
569:
570: PROCEDURE Update_ActForecast (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
570: PROCEDURE Update_ActForecast (
571: p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
575:
576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2,
606:
607: --
608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: --
610: IF FND_API.To_Boolean (p_init_msg_list) THEN
611: FND_MSG_PUB.Initialize;
612: END IF;
613:
614: --
613:
614: --
615: -- Standard check for API version compatibility.
616: --
617: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
618: p_api_version,
619: L_API_NAME,
620: G_PKG_NAME)
621: THEN
618: p_api_version,
619: L_API_NAME,
620: G_PKG_NAME)
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: --
626: -- Initialize API return status to success.
624:
625: --
626: -- Initialize API return status to success.
627: --
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: --
631: -- Begin API Body
632: --
642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data ) ;
644:
645: -- If any errors happen abort API.
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
643: x_msg_data => x_msg_data ) ;
644:
645: -- If any errors happen abort API.
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
644:
645: -- If any errors happen abort API.
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652:
645: -- If any errors happen abort API.
646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
647: RAISE FND_API.G_EXC_ERROR;
648: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652:
653: IF (OZF_DEBUG_HIGH_ON) THEN
672: p_act_forecast_rec => l_act_forecast_rec,
673: p_validation_mode => JTF_PLSQL_API.g_update,
674: x_return_status => l_return_status
675: );
676: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
677: RAISE FND_API.g_exc_unexpected_error;
678: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
679: IF (OZF_DEBUG_HIGH_ON) THEN
680:
673: p_validation_mode => JTF_PLSQL_API.g_update,
674: x_return_status => l_return_status
675: );
676: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
677: RAISE FND_API.g_exc_unexpected_error;
678: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
679: IF (OZF_DEBUG_HIGH_ON) THEN
680:
681: OZF_Utility_PVT.debug_message(l_full_name ||' 2 ' || p_act_forecast_rec.forecast_id);
674: x_return_status => l_return_status
675: );
676: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
677: RAISE FND_API.g_exc_unexpected_error;
678: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
679: IF (OZF_DEBUG_HIGH_ON) THEN
680:
681: OZF_Utility_PVT.debug_message(l_full_name ||' 2 ' || p_act_forecast_rec.forecast_id);
682: END IF;
679: IF (OZF_DEBUG_HIGH_ON) THEN
680:
681: OZF_Utility_PVT.debug_message(l_full_name ||' 2 ' || p_act_forecast_rec.forecast_id);
682: END IF;
683: RAISE FND_API.g_exc_error;
684: END IF;
685: END IF;
686:
687: -- replace g_miss_char/num/date with current column values
698: p_act_forecast_rec => p_act_forecast_rec,
699: p_complete_fcst_rec => l_act_forecast_rec,
700: x_return_status => l_return_status );
701:
702: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
705: RAISE FND_API.g_exc_error;
706: END IF;
699: p_complete_fcst_rec => l_act_forecast_rec,
700: x_return_status => l_return_status );
701:
702: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
705: RAISE FND_API.g_exc_error;
706: END IF;
707:
700: x_return_status => l_return_status );
701:
702: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
705: RAISE FND_API.g_exc_error;
706: END IF;
707:
708: END IF;
701:
702: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
705: RAISE FND_API.g_exc_error;
706: END IF;
707:
708: END IF;
709:
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
781: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
782: FND_MSG_PUB.add;
783: END IF;
784: RAISE FND_API.g_exc_error;
785: END IF;
786:
787:
788: --
788: --
789: -- End API Body
790: --
791:
792: IF FND_API.to_boolean(p_commit) THEN
793: COMMIT;
794: END IF;
795:
796: --
799: --
800: FND_MSG_PUB.Count_And_Get (
801: p_count => x_msg_count,
802: p_data => x_msg_data,
803: p_encoded => FND_API.G_FALSE
804: );
805:
806: --
807: -- Debug message.
812: END IF;
813:
814:
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817:
818: ROLLBACK TO Update_ActForecast_pvt;
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
816: WHEN FND_API.G_EXC_ERROR THEN
817:
818: ROLLBACK TO Update_ActForecast_pvt;
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826:
827: ROLLBACK TO Update_ActForecast_pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get (
824: );
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826:
827: ROLLBACK TO Update_ActForecast_pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get (
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
832: );
833: WHEN OTHERS THEN
834:
835: ROLLBACK TO Update_ActForecast_pvt;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
838: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
839: END IF;
840: FND_MSG_PUB.Count_And_Get (
858: -- End of comments
859:
860: PROCEDURE Delete_ActForecast (
861: p_api_version IN NUMBER,
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864:
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
859:
860: PROCEDURE Delete_ActForecast (
861: p_api_version IN NUMBER,
862: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
863: p_commit IN VARCHAR2 := FND_API.G_FALSE,
864:
865: x_return_status OUT NOCOPY VARCHAR2,
866: x_msg_count OUT NOCOPY NUMBER,
867: x_msg_data OUT NOCOPY VARCHAR2,
892:
893: --
894: -- Initialize message list if p_init_msg_list is set to TRUE.
895: --
896: IF FND_API.To_Boolean (p_init_msg_list) THEN
897: FND_MSG_PUB.Initialize;
898: END IF;
899:
900: --
899:
900: --
901: -- Standard check for API version compatibility.
902: --
903: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
904: p_api_version,
905: L_API_NAME,
906: G_PKG_NAME)
907: THEN
904: p_api_version,
905: L_API_NAME,
906: G_PKG_NAME)
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: --
912: -- Initialize API return status to success.
910:
911: --
912: -- Initialize API return status to success.
913: --
914: x_return_status := FND_API.G_RET_STS_SUCCESS;
915:
916: --
917: -- Begin API Body.
918: --
955: THEN
956:
957: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
958: FND_MSG_PUB.add;
959: RAISE FND_API.g_exc_error;
960: END IF;
961: END IF;
962:
963:
965: --
966: -- End API Body.
967: --
968:
969: IF FND_API.To_Boolean (p_commit) THEN
970: COMMIT WORK;
971: END IF;
972:
973: --
985: --
986: FND_MSG_PUB.Count_And_Get (
987: p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => FND_API.G_FALSE
990: );
991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
989: p_encoded => FND_API.G_FALSE
990: );
991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO Delete_ActForecast_pvt;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: FND_MSG_PUB.Count_And_Get (
997: p_count => x_msg_count,
991:
992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO Delete_ActForecast_pvt;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: FND_MSG_PUB.Count_And_Get (
997: p_count => x_msg_count,
998: p_data => x_msg_data
999: );
996: FND_MSG_PUB.Count_And_Get (
997: p_count => x_msg_count,
998: p_data => x_msg_data
999: );
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1001: ROLLBACK TO Delete_ActForecast_pvt;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => x_msg_count,
998: p_data => x_msg_data
999: );
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1001: ROLLBACK TO Delete_ActForecast_pvt;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1005: p_data => x_msg_data
1006: );
1007: WHEN OTHERS THEN
1008: ROLLBACK TO Delete_ActForecast_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get (
1032: -- End of comments
1033:
1034: PROCEDURE Lock_ActForecast (
1035: p_api_version IN NUMBER,
1036: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1037:
1038: x_return_status OUT NOCOPY VARCHAR2,
1039: x_msg_count OUT NOCOPY NUMBER,
1040: x_msg_data OUT NOCOPY VARCHAR2,
1067:
1068: --
1069: -- Initialize message list if p_init_msg_list is set to TRUE.
1070: --
1071: IF FND_API.To_Boolean (p_init_msg_list) THEN
1072: FND_MSG_PUB.Initialize;
1073: END IF;
1074:
1075: --
1074:
1075: --
1076: -- Standard check for API version compatibility.
1077: --
1078: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1079: p_api_version,
1080: L_API_NAME,
1081: G_PKG_NAME)
1082: THEN
1079: p_api_version,
1080: L_API_NAME,
1081: G_PKG_NAME)
1082: THEN
1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: END IF;
1085:
1086: --
1087: -- Initialize API return status to success.
1085:
1086: --
1087: -- Initialize API return status to success.
1088: --
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: --
1092: -- Begin API Body
1093: --
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1108: FND_MSG_PUB.add;
1109: END IF;
1110: RAISE FND_API.g_exc_error;
1111: END IF;
1112: CLOSE c_act_forecast_info;
1113:
1114:
1118: --
1119: FND_MSG_PUB.Count_And_Get (
1120: p_count => x_msg_count,
1121: p_data => x_msg_data,
1122: p_encoded => FND_API.G_FALSE
1123: );
1124:
1125: --
1126: -- Debug message.
1131: END IF;
1132:
1133:
1134: EXCEPTION
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: FND_MSG_PUB.Count_And_Get (
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1132:
1133:
1134: EXCEPTION
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: FND_MSG_PUB.Count_And_Get (
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1137: FND_MSG_PUB.Count_And_Get (
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143: FND_MSG_PUB.Count_And_Get (
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143: FND_MSG_PUB.Count_And_Get (
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147: WHEN OZF_Utility_PVT.RESOURCE_LOCKED THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1152: FND_MSG_PUB.add;
1154:
1155: FND_MSG_PUB.Count_And_Get (
1156: p_count => x_msg_count,
1157: p_data => x_msg_data,
1158: p_encoded => FND_API.G_FALSE
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1157: p_data => x_msg_data,
1158: p_encoded => FND_API.G_FALSE
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1163: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get (
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get (
1166: p_count => x_msg_count,
1167: p_data => x_msg_data,
1168: p_encoded => FND_API.G_FALSE
1169: );
1170: END Lock_ActForecast;
1171:
1172:
1189: -- End of comments
1190:
1191: PROCEDURE Validate_ActForecast (
1192: p_api_version IN NUMBER,
1193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1194: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
1195:
1196: x_return_status OUT NOCOPY VARCHAR2,
1197: x_msg_count OUT NOCOPY NUMBER,
1190:
1191: PROCEDURE Validate_ActForecast (
1192: p_api_version IN NUMBER,
1193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1194: p_validation_level IN NUMBER := FND_API.G_Valid_Level_Full,
1195:
1196: x_return_status OUT NOCOPY VARCHAR2,
1197: x_msg_count OUT NOCOPY NUMBER,
1198: x_msg_data OUT NOCOPY VARCHAR2,
1218:
1219: --
1220: -- Initialize message list if p_init_msg_list is set to TRUE.
1221: --
1222: IF FND_API.To_Boolean (p_init_msg_list) THEN
1223: FND_MSG_PUB.Initialize;
1224: END IF;
1225:
1226: --
1225:
1226: --
1227: -- Standard check for API version compatibility.
1228: --
1229: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1230: p_api_version,
1231: L_API_NAME,
1232: G_PKG_NAME)
1233: THEN
1230: p_api_version,
1231: L_API_NAME,
1232: G_PKG_NAME)
1233: THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: END IF;
1236:
1237: --
1238: -- Initialize API return status to success.
1236:
1237: --
1238: -- Initialize API return status to success.
1239: --
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241:
1242: --
1243: -- Begin API Body.
1244: --
1260: x_return_status => l_return_status
1261: );
1262:
1263: -- If any errors happen abort API.
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1261: );
1262:
1263: -- If any errors happen abort API.
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269: END IF;
1262:
1263: -- If any errors happen abort API.
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269: END IF;
1270:
1263: -- If any errors happen abort API.
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269: END IF;
1270:
1271: IF (OZF_DEBUG_HIGH_ON) THEN
1282: p_complete_fcst_rec => NULL,
1283: x_return_status => l_return_status
1284: );
1285:
1286: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1287: IF (OZF_DEBUG_HIGH_ON) THEN
1288:
1289: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1290: END IF;
1287: IF (OZF_DEBUG_HIGH_ON) THEN
1288:
1289: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1290: END IF;
1291: RAISE FND_API.g_exc_unexpected_error;
1292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1293: IF (OZF_DEBUG_HIGH_ON) THEN
1294:
1295: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1288:
1289: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1290: END IF;
1291: RAISE FND_API.g_exc_unexpected_error;
1292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1293: IF (OZF_DEBUG_HIGH_ON) THEN
1294:
1295: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1296: END IF;
1293: IF (OZF_DEBUG_HIGH_ON) THEN
1294:
1295: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1296: END IF;
1297: RAISE FND_API.g_exc_error;
1298: END IF;
1299: END IF;
1300:
1301: IF (OZF_DEBUG_HIGH_ON) THEN
1317: --
1318: FND_MSG_PUB.Count_And_Get (
1319: p_count => x_msg_count,
1320: p_data => x_msg_data,
1321: p_encoded => FND_API.G_FALSE
1322: );
1323:
1324: IF (OZF_DEBUG_HIGH_ON) THEN
1325:
1330: END IF;
1331:
1332:
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1331:
1332:
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: FND_MSG_PUB.Count_And_Get (
1343: p_count => x_msg_count,
1344: p_data => x_msg_data
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: FND_MSG_PUB.Count_And_Get (
1343: p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );
1343: p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1349: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get (
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1408: FND_MSG_PUB.add;
1409: END IF;
1410: RAISE FND_API.g_exc_error;
1411: END IF;
1412: CLOSE c_act_forecast;
1413:
1414: IF (OZF_DEBUG_HIGH_ON) THEN
1419:
1420: END IF;
1421:
1422:
1423: IF p_act_forecast_rec.forecast_id = FND_API.G_MISS_NUM THEN
1424: x_complete_fcst_rec.forecast_id := l_act_forecast_rec.forecast_id;
1425: END IF;
1426:
1427: IF p_act_forecast_rec.forecast_type = FND_API.G_MISS_CHAR THEN
1423: IF p_act_forecast_rec.forecast_id = FND_API.G_MISS_NUM THEN
1424: x_complete_fcst_rec.forecast_id := l_act_forecast_rec.forecast_id;
1425: END IF;
1426:
1427: IF p_act_forecast_rec.forecast_type = FND_API.G_MISS_CHAR THEN
1428: x_complete_fcst_rec.forecast_type := l_act_forecast_rec.forecast_type;
1429: END IF;
1430:
1431: IF p_act_forecast_rec.arc_act_fcast_used_by = FND_API.G_MISS_CHAR THEN
1427: IF p_act_forecast_rec.forecast_type = FND_API.G_MISS_CHAR THEN
1428: x_complete_fcst_rec.forecast_type := l_act_forecast_rec.forecast_type;
1429: END IF;
1430:
1431: IF p_act_forecast_rec.arc_act_fcast_used_by = FND_API.G_MISS_CHAR THEN
1432: x_complete_fcst_rec.arc_act_fcast_used_by := l_act_forecast_rec.arc_act_fcast_used_by;
1433: END IF;
1434:
1435: IF p_act_forecast_rec.act_fcast_used_by_id = FND_API.G_MISS_NUM THEN
1431: IF p_act_forecast_rec.arc_act_fcast_used_by = FND_API.G_MISS_CHAR THEN
1432: x_complete_fcst_rec.arc_act_fcast_used_by := l_act_forecast_rec.arc_act_fcast_used_by;
1433: END IF;
1434:
1435: IF p_act_forecast_rec.act_fcast_used_by_id = FND_API.G_MISS_NUM THEN
1436: x_complete_fcst_rec.act_fcast_used_by_id := l_act_forecast_rec.act_fcast_used_by_id ;
1437: END IF;
1438:
1439: IF p_act_forecast_rec.creation_date = FND_API.G_MISS_DATE THEN
1435: IF p_act_forecast_rec.act_fcast_used_by_id = FND_API.G_MISS_NUM THEN
1436: x_complete_fcst_rec.act_fcast_used_by_id := l_act_forecast_rec.act_fcast_used_by_id ;
1437: END IF;
1438:
1439: IF p_act_forecast_rec.creation_date = FND_API.G_MISS_DATE THEN
1440: x_complete_fcst_rec.creation_date := l_act_forecast_rec.creation_date;
1441: END IF;
1442:
1443: IF p_act_forecast_rec.created_from = FND_API.G_MISS_CHAR THEN
1439: IF p_act_forecast_rec.creation_date = FND_API.G_MISS_DATE THEN
1440: x_complete_fcst_rec.creation_date := l_act_forecast_rec.creation_date;
1441: END IF;
1442:
1443: IF p_act_forecast_rec.created_from = FND_API.G_MISS_CHAR THEN
1444: x_complete_fcst_rec.created_from := l_act_forecast_rec.created_from;
1445: END IF;
1446:
1447: IF p_act_forecast_rec.created_by = FND_API.G_MISS_NUM THEN
1443: IF p_act_forecast_rec.created_from = FND_API.G_MISS_CHAR THEN
1444: x_complete_fcst_rec.created_from := l_act_forecast_rec.created_from;
1445: END IF;
1446:
1447: IF p_act_forecast_rec.created_by = FND_API.G_MISS_NUM THEN
1448: x_complete_fcst_rec.created_by := l_act_forecast_rec.created_by;
1449: END IF;
1450:
1451: IF p_act_forecast_rec.last_update_date = FND_API.G_MISS_DATE THEN
1447: IF p_act_forecast_rec.created_by = FND_API.G_MISS_NUM THEN
1448: x_complete_fcst_rec.created_by := l_act_forecast_rec.created_by;
1449: END IF;
1450:
1451: IF p_act_forecast_rec.last_update_date = FND_API.G_MISS_DATE THEN
1452: x_complete_fcst_rec.last_update_date := l_act_forecast_rec.last_update_date;
1453: END IF;
1454:
1455: IF p_act_forecast_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1451: IF p_act_forecast_rec.last_update_date = FND_API.G_MISS_DATE THEN
1452: x_complete_fcst_rec.last_update_date := l_act_forecast_rec.last_update_date;
1453: END IF;
1454:
1455: IF p_act_forecast_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1456: x_complete_fcst_rec.last_updated_by := l_act_forecast_rec.last_updated_by ;
1457: END IF;
1458:
1459: IF p_act_forecast_rec.last_update_login = FND_API.G_MISS_NUM THEN
1455: IF p_act_forecast_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1456: x_complete_fcst_rec.last_updated_by := l_act_forecast_rec.last_updated_by ;
1457: END IF;
1458:
1459: IF p_act_forecast_rec.last_update_login = FND_API.G_MISS_NUM THEN
1460: x_complete_fcst_rec.last_update_login := l_act_forecast_rec.last_update_login;
1461: END IF;
1462:
1463: IF p_act_forecast_rec.program_application_id = FND_API.G_MISS_NUM THEN
1459: IF p_act_forecast_rec.last_update_login = FND_API.G_MISS_NUM THEN
1460: x_complete_fcst_rec.last_update_login := l_act_forecast_rec.last_update_login;
1461: END IF;
1462:
1463: IF p_act_forecast_rec.program_application_id = FND_API.G_MISS_NUM THEN
1464: x_complete_fcst_rec.program_application_id := l_act_forecast_rec.program_application_id;
1465: END IF;
1466:
1467: IF p_act_forecast_rec.program_id = FND_API.G_MISS_NUM THEN
1463: IF p_act_forecast_rec.program_application_id = FND_API.G_MISS_NUM THEN
1464: x_complete_fcst_rec.program_application_id := l_act_forecast_rec.program_application_id;
1465: END IF;
1466:
1467: IF p_act_forecast_rec.program_id = FND_API.G_MISS_NUM THEN
1468: x_complete_fcst_rec.program_id := l_act_forecast_rec.program_id;
1469: END IF;
1470:
1471: IF p_act_forecast_rec.program_update_date = FND_API.G_MISS_DATE THEN
1467: IF p_act_forecast_rec.program_id = FND_API.G_MISS_NUM THEN
1468: x_complete_fcst_rec.program_id := l_act_forecast_rec.program_id;
1469: END IF;
1470:
1471: IF p_act_forecast_rec.program_update_date = FND_API.G_MISS_DATE THEN
1472: x_complete_fcst_rec.program_update_date := l_act_forecast_rec.program_update_date;
1473: END IF;
1474:
1475: IF p_act_forecast_rec.request_id = FND_API.G_MISS_NUM THEN
1471: IF p_act_forecast_rec.program_update_date = FND_API.G_MISS_DATE THEN
1472: x_complete_fcst_rec.program_update_date := l_act_forecast_rec.program_update_date;
1473: END IF;
1474:
1475: IF p_act_forecast_rec.request_id = FND_API.G_MISS_NUM THEN
1476: x_complete_fcst_rec.request_id := l_act_forecast_rec.request_id ;
1477: END IF;
1478:
1479: IF p_act_forecast_rec.hierarchy = FND_API.G_MISS_CHAR THEN
1475: IF p_act_forecast_rec.request_id = FND_API.G_MISS_NUM THEN
1476: x_complete_fcst_rec.request_id := l_act_forecast_rec.request_id ;
1477: END IF;
1478:
1479: IF p_act_forecast_rec.hierarchy = FND_API.G_MISS_CHAR THEN
1480: x_complete_fcst_rec.hierarchy := l_act_forecast_rec.hierarchy;
1481: END IF;
1482:
1483: IF p_act_forecast_rec.hierarchy_level = FND_API.G_MISS_CHAR THEN
1479: IF p_act_forecast_rec.hierarchy = FND_API.G_MISS_CHAR THEN
1480: x_complete_fcst_rec.hierarchy := l_act_forecast_rec.hierarchy;
1481: END IF;
1482:
1483: IF p_act_forecast_rec.hierarchy_level = FND_API.G_MISS_CHAR THEN
1484: x_complete_fcst_rec.hierarchy_level := l_act_forecast_rec.hierarchy_level;
1485: END IF;
1486:
1487: IF p_act_forecast_rec.level_value = FND_API.G_MISS_CHAR THEN
1483: IF p_act_forecast_rec.hierarchy_level = FND_API.G_MISS_CHAR THEN
1484: x_complete_fcst_rec.hierarchy_level := l_act_forecast_rec.hierarchy_level;
1485: END IF;
1486:
1487: IF p_act_forecast_rec.level_value = FND_API.G_MISS_CHAR THEN
1488: x_complete_fcst_rec.level_value := l_act_forecast_rec.level_value;
1489: END IF;
1490:
1491: IF p_act_forecast_rec.forecast_calendar = FND_API.G_MISS_CHAR THEN
1487: IF p_act_forecast_rec.level_value = FND_API.G_MISS_CHAR THEN
1488: x_complete_fcst_rec.level_value := l_act_forecast_rec.level_value;
1489: END IF;
1490:
1491: IF p_act_forecast_rec.forecast_calendar = FND_API.G_MISS_CHAR THEN
1492: x_complete_fcst_rec.forecast_calendar := l_act_forecast_rec.forecast_calendar;
1493: END IF;
1494:
1495: IF p_act_forecast_rec.period_level = FND_API.G_MISS_CHAR THEN
1491: IF p_act_forecast_rec.forecast_calendar = FND_API.G_MISS_CHAR THEN
1492: x_complete_fcst_rec.forecast_calendar := l_act_forecast_rec.forecast_calendar;
1493: END IF;
1494:
1495: IF p_act_forecast_rec.period_level = FND_API.G_MISS_CHAR THEN
1496: x_complete_fcst_rec.period_level := l_act_forecast_rec.period_level;
1497: END IF;
1498:
1499: IF p_act_forecast_rec.forecast_period_id = FND_API.G_MISS_NUM THEN
1495: IF p_act_forecast_rec.period_level = FND_API.G_MISS_CHAR THEN
1496: x_complete_fcst_rec.period_level := l_act_forecast_rec.period_level;
1497: END IF;
1498:
1499: IF p_act_forecast_rec.forecast_period_id = FND_API.G_MISS_NUM THEN
1500: x_complete_fcst_rec.forecast_period_id := l_act_forecast_rec.forecast_period_id;
1501: END IF;
1502:
1503: IF p_act_forecast_rec.forecast_date = FND_API.G_MISS_DATE THEN
1499: IF p_act_forecast_rec.forecast_period_id = FND_API.G_MISS_NUM THEN
1500: x_complete_fcst_rec.forecast_period_id := l_act_forecast_rec.forecast_period_id;
1501: END IF;
1502:
1503: IF p_act_forecast_rec.forecast_date = FND_API.G_MISS_DATE THEN
1504: x_complete_fcst_rec.forecast_date := l_act_forecast_rec.forecast_date;
1505: END IF;
1506:
1507: IF p_act_forecast_rec.forecast_uom_code = FND_API.G_MISS_CHAR THEN
1503: IF p_act_forecast_rec.forecast_date = FND_API.G_MISS_DATE THEN
1504: x_complete_fcst_rec.forecast_date := l_act_forecast_rec.forecast_date;
1505: END IF;
1506:
1507: IF p_act_forecast_rec.forecast_uom_code = FND_API.G_MISS_CHAR THEN
1508: x_complete_fcst_rec.forecast_uom_code := l_act_forecast_rec.forecast_uom_code;
1509: END IF;
1510:
1511: IF p_act_forecast_rec.forecast_quantity = FND_API.G_MISS_NUM THEN
1507: IF p_act_forecast_rec.forecast_uom_code = FND_API.G_MISS_CHAR THEN
1508: x_complete_fcst_rec.forecast_uom_code := l_act_forecast_rec.forecast_uom_code;
1509: END IF;
1510:
1511: IF p_act_forecast_rec.forecast_quantity = FND_API.G_MISS_NUM THEN
1512: x_complete_fcst_rec.forecast_quantity := l_act_forecast_rec.forecast_quantity;
1513: END IF;
1514:
1515: IF p_act_forecast_rec.forward_buy_quantity = FND_API.G_MISS_NUM THEN
1511: IF p_act_forecast_rec.forecast_quantity = FND_API.G_MISS_NUM THEN
1512: x_complete_fcst_rec.forecast_quantity := l_act_forecast_rec.forecast_quantity;
1513: END IF;
1514:
1515: IF p_act_forecast_rec.forward_buy_quantity = FND_API.G_MISS_NUM THEN
1516: x_complete_fcst_rec.forward_buy_quantity := l_act_forecast_rec.forward_buy_quantity;
1517: END IF;
1518:
1519: IF p_act_forecast_rec.forward_buy_period = FND_API.G_MISS_CHAR THEN
1515: IF p_act_forecast_rec.forward_buy_quantity = FND_API.G_MISS_NUM THEN
1516: x_complete_fcst_rec.forward_buy_quantity := l_act_forecast_rec.forward_buy_quantity;
1517: END IF;
1518:
1519: IF p_act_forecast_rec.forward_buy_period = FND_API.G_MISS_CHAR THEN
1520: x_complete_fcst_rec.forward_buy_period := l_act_forecast_rec.forward_buy_period;
1521: END IF;
1522:
1523: IF p_act_forecast_rec.cumulation_period_choice = FND_API.G_MISS_CHAR THEN
1519: IF p_act_forecast_rec.forward_buy_period = FND_API.G_MISS_CHAR THEN
1520: x_complete_fcst_rec.forward_buy_period := l_act_forecast_rec.forward_buy_period;
1521: END IF;
1522:
1523: IF p_act_forecast_rec.cumulation_period_choice = FND_API.G_MISS_CHAR THEN
1524: x_complete_fcst_rec.cumulation_period_choice := l_act_forecast_rec.cumulation_period_choice;
1525: END IF;
1526:
1527: IF p_act_forecast_rec.base_quantity = FND_API.G_MISS_NUM THEN
1523: IF p_act_forecast_rec.cumulation_period_choice = FND_API.G_MISS_CHAR THEN
1524: x_complete_fcst_rec.cumulation_period_choice := l_act_forecast_rec.cumulation_period_choice;
1525: END IF;
1526:
1527: IF p_act_forecast_rec.base_quantity = FND_API.G_MISS_NUM THEN
1528: x_complete_fcst_rec.base_quantity := l_act_forecast_rec.base_quantity ;
1529: END IF;
1530:
1531: IF p_act_forecast_rec.context = FND_API.G_MISS_CHAR THEN
1527: IF p_act_forecast_rec.base_quantity = FND_API.G_MISS_NUM THEN
1528: x_complete_fcst_rec.base_quantity := l_act_forecast_rec.base_quantity ;
1529: END IF;
1530:
1531: IF p_act_forecast_rec.context = FND_API.G_MISS_CHAR THEN
1532: x_complete_fcst_rec.context := l_act_forecast_rec.context;
1533: END IF;
1534:
1535: IF p_act_forecast_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1531: IF p_act_forecast_rec.context = FND_API.G_MISS_CHAR THEN
1532: x_complete_fcst_rec.context := l_act_forecast_rec.context;
1533: END IF;
1534:
1535: IF p_act_forecast_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1536: x_complete_fcst_rec.attribute_category := l_act_forecast_rec.attribute_category;
1537: END IF;
1538:
1539: IF p_act_forecast_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1535: IF p_act_forecast_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1536: x_complete_fcst_rec.attribute_category := l_act_forecast_rec.attribute_category;
1537: END IF;
1538:
1539: IF p_act_forecast_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1540: x_complete_fcst_rec.attribute1 := l_act_forecast_rec.attribute1;
1541: END IF;
1542:
1543: IF p_act_forecast_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1539: IF p_act_forecast_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1540: x_complete_fcst_rec.attribute1 := l_act_forecast_rec.attribute1;
1541: END IF;
1542:
1543: IF p_act_forecast_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1544: x_complete_fcst_rec.attribute2 := l_act_forecast_rec.attribute2;
1545: END IF;
1546:
1547: IF p_act_forecast_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1543: IF p_act_forecast_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1544: x_complete_fcst_rec.attribute2 := l_act_forecast_rec.attribute2;
1545: END IF;
1546:
1547: IF p_act_forecast_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1548: x_complete_fcst_rec.attribute3 := l_act_forecast_rec.attribute3;
1549: END IF;
1550:
1551: IF p_act_forecast_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1547: IF p_act_forecast_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1548: x_complete_fcst_rec.attribute3 := l_act_forecast_rec.attribute3;
1549: END IF;
1550:
1551: IF p_act_forecast_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1552: x_complete_fcst_rec.attribute4 := l_act_forecast_rec.attribute4;
1553: END IF;
1554:
1555: IF p_act_forecast_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1551: IF p_act_forecast_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1552: x_complete_fcst_rec.attribute4 := l_act_forecast_rec.attribute4;
1553: END IF;
1554:
1555: IF p_act_forecast_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1556: x_complete_fcst_rec.attribute5 := l_act_forecast_rec.attribute5;
1557: END IF;
1558:
1559: IF p_act_forecast_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1555: IF p_act_forecast_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1556: x_complete_fcst_rec.attribute5 := l_act_forecast_rec.attribute5;
1557: END IF;
1558:
1559: IF p_act_forecast_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1560: x_complete_fcst_rec.attribute6 := l_act_forecast_rec.attribute6;
1561: END IF;
1562:
1563: IF p_act_forecast_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1559: IF p_act_forecast_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1560: x_complete_fcst_rec.attribute6 := l_act_forecast_rec.attribute6;
1561: END IF;
1562:
1563: IF p_act_forecast_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1564: x_complete_fcst_rec.attribute7 := l_act_forecast_rec.attribute7;
1565: END IF;
1566:
1567: IF p_act_forecast_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1563: IF p_act_forecast_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1564: x_complete_fcst_rec.attribute7 := l_act_forecast_rec.attribute7;
1565: END IF;
1566:
1567: IF p_act_forecast_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1568: x_complete_fcst_rec.attribute8 := l_act_forecast_rec.attribute8;
1569: END IF;
1570:
1571: IF p_act_forecast_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1567: IF p_act_forecast_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1568: x_complete_fcst_rec.attribute8 := l_act_forecast_rec.attribute8;
1569: END IF;
1570:
1571: IF p_act_forecast_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1572: x_complete_fcst_rec.attribute9 := l_act_forecast_rec.attribute9;
1573: END IF;
1574:
1575: IF p_act_forecast_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1571: IF p_act_forecast_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1572: x_complete_fcst_rec.attribute9 := l_act_forecast_rec.attribute9;
1573: END IF;
1574:
1575: IF p_act_forecast_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1576: x_complete_fcst_rec.attribute10 := l_act_forecast_rec.attribute10;
1577: END IF;
1578:
1579: IF p_act_forecast_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1575: IF p_act_forecast_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1576: x_complete_fcst_rec.attribute10 := l_act_forecast_rec.attribute10;
1577: END IF;
1578:
1579: IF p_act_forecast_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1580: x_complete_fcst_rec.attribute11 := l_act_forecast_rec.attribute11;
1581: END IF;
1582:
1583: IF p_act_forecast_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1579: IF p_act_forecast_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1580: x_complete_fcst_rec.attribute11 := l_act_forecast_rec.attribute11;
1581: END IF;
1582:
1583: IF p_act_forecast_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1584: x_complete_fcst_rec.attribute12 := l_act_forecast_rec.attribute12;
1585: END IF;
1586:
1587: IF p_act_forecast_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1583: IF p_act_forecast_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1584: x_complete_fcst_rec.attribute12 := l_act_forecast_rec.attribute12;
1585: END IF;
1586:
1587: IF p_act_forecast_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1588: x_complete_fcst_rec.attribute13 := l_act_forecast_rec.attribute13;
1589: END IF;
1590:
1591: IF p_act_forecast_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1587: IF p_act_forecast_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1588: x_complete_fcst_rec.attribute13 := l_act_forecast_rec.attribute13;
1589: END IF;
1590:
1591: IF p_act_forecast_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1592: x_complete_fcst_rec.attribute14 := l_act_forecast_rec.attribute14;
1593: END IF;
1594:
1595: IF p_act_forecast_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1591: IF p_act_forecast_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1592: x_complete_fcst_rec.attribute14 := l_act_forecast_rec.attribute14;
1593: END IF;
1594:
1595: IF p_act_forecast_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1596: x_complete_fcst_rec.attribute15 := l_act_forecast_rec.attribute15;
1597: END IF;
1598:
1599: IF p_act_forecast_rec.org_id = FND_API.G_MISS_NUM THEN
1595: IF p_act_forecast_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1596: x_complete_fcst_rec.attribute15 := l_act_forecast_rec.attribute15;
1597: END IF;
1598:
1599: IF p_act_forecast_rec.org_id = FND_API.G_MISS_NUM THEN
1600: x_complete_fcst_rec.org_id := l_act_forecast_rec.org_id;
1601: END IF;
1602:
1603: IF p_act_forecast_rec.forecast_remaining_quantity = FND_API.G_MISS_NUM THEN
1599: IF p_act_forecast_rec.org_id = FND_API.G_MISS_NUM THEN
1600: x_complete_fcst_rec.org_id := l_act_forecast_rec.org_id;
1601: END IF;
1602:
1603: IF p_act_forecast_rec.forecast_remaining_quantity = FND_API.G_MISS_NUM THEN
1604: x_complete_fcst_rec.forecast_remaining_quantity := l_act_forecast_rec.forecast_remaining_quantity;
1605: END IF;
1606:
1607: IF p_act_forecast_rec.forecast_remaining_percent = FND_API.G_MISS_NUM THEN
1603: IF p_act_forecast_rec.forecast_remaining_quantity = FND_API.G_MISS_NUM THEN
1604: x_complete_fcst_rec.forecast_remaining_quantity := l_act_forecast_rec.forecast_remaining_quantity;
1605: END IF;
1606:
1607: IF p_act_forecast_rec.forecast_remaining_percent = FND_API.G_MISS_NUM THEN
1608: x_complete_fcst_rec.forecast_remaining_percent := l_act_forecast_rec.forecast_remaining_percent;
1609: END IF;
1610:
1611: IF p_act_forecast_rec.base_quantity_type = FND_API.G_MISS_CHAR THEN
1607: IF p_act_forecast_rec.forecast_remaining_percent = FND_API.G_MISS_NUM THEN
1608: x_complete_fcst_rec.forecast_remaining_percent := l_act_forecast_rec.forecast_remaining_percent;
1609: END IF;
1610:
1611: IF p_act_forecast_rec.base_quantity_type = FND_API.G_MISS_CHAR THEN
1612: x_complete_fcst_rec.base_quantity_type := l_act_forecast_rec.base_quantity_type;
1613: END IF;
1614:
1615: IF p_act_forecast_rec.forecast_spread_type = FND_API.G_MISS_CHAR THEN
1611: IF p_act_forecast_rec.base_quantity_type = FND_API.G_MISS_CHAR THEN
1612: x_complete_fcst_rec.base_quantity_type := l_act_forecast_rec.base_quantity_type;
1613: END IF;
1614:
1615: IF p_act_forecast_rec.forecast_spread_type = FND_API.G_MISS_CHAR THEN
1616: x_complete_fcst_rec.forecast_spread_type := l_act_forecast_rec.forecast_spread_type;
1617: END IF;
1618:
1619: IF p_act_forecast_rec.dimention1 = FND_API.G_MISS_CHAR THEN
1615: IF p_act_forecast_rec.forecast_spread_type = FND_API.G_MISS_CHAR THEN
1616: x_complete_fcst_rec.forecast_spread_type := l_act_forecast_rec.forecast_spread_type;
1617: END IF;
1618:
1619: IF p_act_forecast_rec.dimention1 = FND_API.G_MISS_CHAR THEN
1620: x_complete_fcst_rec.dimention1 := l_act_forecast_rec.dimention1;
1621: END IF;
1622:
1623: IF p_act_forecast_rec.dimention2 = FND_API.G_MISS_CHAR THEN
1619: IF p_act_forecast_rec.dimention1 = FND_API.G_MISS_CHAR THEN
1620: x_complete_fcst_rec.dimention1 := l_act_forecast_rec.dimention1;
1621: END IF;
1622:
1623: IF p_act_forecast_rec.dimention2 = FND_API.G_MISS_CHAR THEN
1624: x_complete_fcst_rec.dimention2 := l_act_forecast_rec.dimention2;
1625: END IF;
1626:
1627: IF p_act_forecast_rec.dimention3 = FND_API.G_MISS_CHAR THEN
1623: IF p_act_forecast_rec.dimention2 = FND_API.G_MISS_CHAR THEN
1624: x_complete_fcst_rec.dimention2 := l_act_forecast_rec.dimention2;
1625: END IF;
1626:
1627: IF p_act_forecast_rec.dimention3 = FND_API.G_MISS_CHAR THEN
1628: x_complete_fcst_rec.dimention3 := l_act_forecast_rec.dimention3;
1629: END IF;
1630:
1631: IF p_act_forecast_rec.last_scenario_id = FND_API.G_MISS_NUM THEN
1627: IF p_act_forecast_rec.dimention3 = FND_API.G_MISS_CHAR THEN
1628: x_complete_fcst_rec.dimention3 := l_act_forecast_rec.dimention3;
1629: END IF;
1630:
1631: IF p_act_forecast_rec.last_scenario_id = FND_API.G_MISS_NUM THEN
1632: x_complete_fcst_rec.last_scenario_id := l_act_forecast_rec.last_scenario_id;
1633: END IF;
1634:
1635: IF p_act_forecast_rec.freeze_flag = FND_API.G_MISS_CHAR THEN
1631: IF p_act_forecast_rec.last_scenario_id = FND_API.G_MISS_NUM THEN
1632: x_complete_fcst_rec.last_scenario_id := l_act_forecast_rec.last_scenario_id;
1633: END IF;
1634:
1635: IF p_act_forecast_rec.freeze_flag = FND_API.G_MISS_CHAR THEN
1636: x_complete_fcst_rec.freeze_flag := l_act_forecast_rec.freeze_flag;
1637: END IF;
1638:
1639: IF p_act_forecast_rec.comments = FND_API.G_MISS_CHAR THEN
1635: IF p_act_forecast_rec.freeze_flag = FND_API.G_MISS_CHAR THEN
1636: x_complete_fcst_rec.freeze_flag := l_act_forecast_rec.freeze_flag;
1637: END IF;
1638:
1639: IF p_act_forecast_rec.comments = FND_API.G_MISS_CHAR THEN
1640: x_complete_fcst_rec.comments := l_act_forecast_rec.comments;
1641: END IF;
1642:
1643: IF p_act_forecast_rec.price_list_id = FND_API.G_MISS_NUM THEN
1639: IF p_act_forecast_rec.comments = FND_API.G_MISS_CHAR THEN
1640: x_complete_fcst_rec.comments := l_act_forecast_rec.comments;
1641: END IF;
1642:
1643: IF p_act_forecast_rec.price_list_id = FND_API.G_MISS_NUM THEN
1644: x_complete_fcst_rec.price_list_id := l_act_forecast_rec.price_list_id ;
1645: END IF;
1646:
1647: IF p_act_forecast_rec.base_quantity_start_date = FND_API.G_MISS_DATE THEN
1643: IF p_act_forecast_rec.price_list_id = FND_API.G_MISS_NUM THEN
1644: x_complete_fcst_rec.price_list_id := l_act_forecast_rec.price_list_id ;
1645: END IF;
1646:
1647: IF p_act_forecast_rec.base_quantity_start_date = FND_API.G_MISS_DATE THEN
1648: x_complete_fcst_rec.base_quantity_start_date := l_act_forecast_rec.base_quantity_start_date;
1649: END IF;
1650: IF p_act_forecast_rec.base_quantity_end_date = FND_API.G_MISS_DATE THEN
1651: x_complete_fcst_rec.base_quantity_end_date := l_act_forecast_rec.base_quantity_end_date;
1646:
1647: IF p_act_forecast_rec.base_quantity_start_date = FND_API.G_MISS_DATE THEN
1648: x_complete_fcst_rec.base_quantity_start_date := l_act_forecast_rec.base_quantity_start_date;
1649: END IF;
1650: IF p_act_forecast_rec.base_quantity_end_date = FND_API.G_MISS_DATE THEN
1651: x_complete_fcst_rec.base_quantity_end_date := l_act_forecast_rec.base_quantity_end_date;
1652: END IF;
1653: IF p_act_forecast_rec.base_quantity_ref = FND_API.G_MISS_CHAR THEN
1654: x_complete_fcst_rec.base_quantity_ref := l_act_forecast_rec.base_quantity_ref;
1649: END IF;
1650: IF p_act_forecast_rec.base_quantity_end_date = FND_API.G_MISS_DATE THEN
1651: x_complete_fcst_rec.base_quantity_end_date := l_act_forecast_rec.base_quantity_end_date;
1652: END IF;
1653: IF p_act_forecast_rec.base_quantity_ref = FND_API.G_MISS_CHAR THEN
1654: x_complete_fcst_rec.base_quantity_ref := l_act_forecast_rec.base_quantity_ref;
1655: END IF;
1656: IF p_act_forecast_rec.offer_code= FND_API.G_MISS_CHAR THEN
1657: x_complete_fcst_rec.offer_code := l_act_forecast_rec.offer_code;
1652: END IF;
1653: IF p_act_forecast_rec.base_quantity_ref = FND_API.G_MISS_CHAR THEN
1654: x_complete_fcst_rec.base_quantity_ref := l_act_forecast_rec.base_quantity_ref;
1655: END IF;
1656: IF p_act_forecast_rec.offer_code= FND_API.G_MISS_CHAR THEN
1657: x_complete_fcst_rec.offer_code := l_act_forecast_rec.offer_code;
1658: END IF;
1659:
1660: END Complete_ActFcst_Rec ;
1682: )
1683: IS
1684: BEGIN
1685: -- Initialize return status to success.
1686: x_return_status := FND_API.G_RET_STS_SUCCESS;
1687:
1688: --FORECAST_TYPE
1689:
1690: IF p_act_forecast_rec.forecast_type IS NULL
1695: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_TYPE');
1696: FND_MSG_PUB.Add;
1697: END IF;
1698:
1699: x_return_status := FND_API.G_RET_STS_ERROR;
1700:
1701: -- If any error happens abort API.
1702: RETURN;
1703: END IF;
1712: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1713: FND_MSG_PUB.Add;
1714: END IF;
1715:
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:
1718: -- If any error happens abort API.
1719: RETURN;
1720: END IF;
1729: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1730: FND_MSG_PUB.Add;
1731: END IF;
1732:
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734:
1735: -- If any error happens abort API.
1736: RETURN;
1737: END IF;
1746: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_CALENDAR');
1747: FND_MSG_PUB.Add;
1748: END IF;
1749:
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751:
1752: -- If any error happens abort API.
1753: RETURN;
1754: END IF;
1763: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_UOM_CODE');
1764: FND_MSG_PUB.Add;
1765: END IF;
1766:
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768:
1769: -- If any error happens abort API.
1770: RETURN;
1771: END IF;
1804: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness
1805:
1806: BEGIN
1807:
1808: x_return_status := FND_API.g_ret_sts_success;
1809:
1810: -- For Create_ActForecast, check if a Forecast already exists
1811: -- For the given object
1812:
1821:
1822: IF OZF_Utility_PVT.Check_Uniqueness(
1823: p_table_name => 'ozf_act_forecasts_all',
1824: p_where_clause => l_where_clause
1825: ) = FND_API.g_false
1826: THEN
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1828: THEN
1829: FND_MESSAGE.set_name('OZF', 'OZF_FCST_DUP_ID');
1828: THEN
1829: FND_MESSAGE.set_name('OZF', 'OZF_FCST_DUP_ID');
1830: FND_MSG_PUB.add;
1831: END IF;
1832: x_return_status := FND_API.g_ret_sts_error;
1833: RETURN;
1834: END IF;
1835: END IF;
1836:
1873:
1874:
1875: BEGIN
1876: -- Initialize return status to success.
1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878:
1879: --FORECAST_TYPE
1880: IF l_act_forecast_rec.forecast_type <> FND_API.G_MISS_CHAR THEN
1881:
1876: -- Initialize return status to success.
1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878:
1879: --FORECAST_TYPE
1880: IF l_act_forecast_rec.forecast_type <> FND_API.G_MISS_CHAR THEN
1881:
1882: IF OZF_Utility_PVT.check_lookup_exists(
1883: p_lookup_type => 'OZF_FCAST_TYPE',
1884: p_lookup_code => l_act_forecast_rec.forecast_type
1881:
1882: IF OZF_Utility_PVT.check_lookup_exists(
1883: p_lookup_type => 'OZF_FCAST_TYPE',
1884: p_lookup_code => l_act_forecast_rec.forecast_type
1885: ) = FND_API.g_false
1886: THEN
1887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1888: THEN
1889: FND_MESSAGE.set_name('OZF', 'OZF_FCST_INVALID_TYPE');
1889: FND_MESSAGE.set_name('OZF', 'OZF_FCST_INVALID_TYPE');
1890: FND_MSG_PUB.add;
1891: END IF;
1892:
1893: x_return_status := FND_API.g_ret_sts_error;
1894: RETURN;
1895: END IF;
1896:
1897: END IF;
1897: END IF;
1898:
1899: -- ARC_ACT_FCAST_USED_BY
1900:
1901: IF l_act_forecast_rec.arc_act_fcast_used_by <> FND_API.G_MISS_CHAR THEN
1902: IF l_act_forecast_rec.arc_act_fcast_used_by not in ( 'CAMP','OFFR')
1903:
1904: THEN
1905: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909:
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: RETURN;
1912: END IF;
1913: END IF;
1914:
1912: END IF;
1913: END IF;
1914:
1915: --BASE_QUANTITY_TYPE
1916: IF l_act_forecast_rec.base_quantity_type <> FND_API.G_MISS_CHAR AND l_act_forecast_rec.base_quantity_type IS NOT NULL THEN
1917:
1918: IF OZF_Utility_PVT.check_lookup_exists(
1919: p_lookup_type => 'OZF_FCAST_BASE_VOL_SOURCE',
1920: p_lookup_code => l_act_forecast_rec.base_quantity_type
1917:
1918: IF OZF_Utility_PVT.check_lookup_exists(
1919: p_lookup_type => 'OZF_FCAST_BASE_VOL_SOURCE',
1920: p_lookup_code => l_act_forecast_rec.base_quantity_type
1921: ) = FND_API.g_false
1922: THEN
1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1924: THEN
1925: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_BASE_QTY');
1925: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_BASE_QTY');
1926: FND_MSG_PUB.add;
1927: END IF;
1928:
1929: x_return_status := FND_API.g_ret_sts_error;
1930: RETURN;
1931: END IF;
1932:
1933: END IF;
1933: END IF;
1934:
1935:
1936: --FORECAST_SPREAD_TYPE
1937: IF l_act_forecast_rec.forecast_spread_type <> FND_API.G_MISS_CHAR AND l_act_forecast_rec.forecast_spread_type IS NOT NULL THEN
1938:
1939: IF OZF_Utility_PVT.check_lookup_exists(
1940: p_lookup_type => 'OZF_FCAST_SPREAD',
1941: p_lookup_code => l_act_forecast_rec.forecast_spread_type
1938:
1939: IF OZF_Utility_PVT.check_lookup_exists(
1940: p_lookup_type => 'OZF_FCAST_SPREAD',
1941: p_lookup_code => l_act_forecast_rec.forecast_spread_type
1942: ) = FND_API.g_false
1943: THEN
1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1945: THEN
1946: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_SPREAD_TYPE');
1946: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_SPREAD_TYPE');
1947: FND_MSG_PUB.add;
1948: END IF;
1949:
1950: x_return_status := FND_API.g_ret_sts_error;
1951: RETURN;
1952: END IF;
1953:
1954:
1956:
1957:
1958: --FORECAST_UOM_CODE
1959: /* -- This value is being validated in the jsp page thru a LOV
1960: IF l_act_forecast_rec.forecast_uom_code <> FND_API.G_MISS_CHAR THEN
1961:
1962: IF OZF_Utility_PVT.check_lookup_exists(
1963: p_lookup_type => 'OZF_FCAST_UOM',
1964: p_lookup_code => l_act_forecast_rec.forecast_uom_code
1961:
1962: IF OZF_Utility_PVT.check_lookup_exists(
1963: p_lookup_type => 'OZF_FCAST_UOM',
1964: p_lookup_code => l_act_forecast_rec.forecast_uom_code
1965: ) = FND_API.g_false
1966: THEN
1967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1968: THEN
1969: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_UOM_CODE');
1969: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_UOM_CODE');
1970: FND_MSG_PUB.add;
1971: END IF;
1972:
1973: x_return_status := FND_API.g_ret_sts_error;
1974: RETURN;
1975: END IF;
1976:
1977: END IF;
1979: */
1980:
1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: END Check_ActFcst_Items;
1985:
1986: --
1987: -- Start of comments.
2018:
2019:
2020: BEGIN
2021:
2022: x_return_status := FND_API.g_ret_sts_success;
2023:
2024: IF l_act_forecast_rec.arc_act_fcast_used_by <> FND_API.G_MISS_CHAR THEN
2025:
2026: -- Get table_name and pk_name for the ARC qualifier.
2020: BEGIN
2021:
2022: x_return_status := FND_API.g_ret_sts_success;
2023:
2024: IF l_act_forecast_rec.arc_act_fcast_used_by <> FND_API.G_MISS_CHAR THEN
2025:
2026: -- Get table_name and pk_name for the ARC qualifier.
2027: OZF_Utility_PVT.Get_Qual_Table_Name_And_PK (
2028: p_sys_qual => l_act_forecast_rec.arc_act_fcast_used_by,
2041: ,p_pk_name => l_pk_name
2042: ,p_pk_value => l_pk_value
2043: ,p_pk_data_type => l_pk_data_type
2044: ,p_additional_where_clause => NULL
2045: ) = FND_API.G_FALSE
2046: THEN
2047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2048: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
2049: FND_MSG_PUB.Add;
2048: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
2049: FND_MSG_PUB.Add;
2050: END IF;
2051:
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: RETURN;
2054: END IF;
2055: END IF;
2056:
2055: END IF;
2056:
2057: EXCEPTION
2058: WHEN OTHERS THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060:
2061: END Validate_ActFcst_Rec;
2062:
2063:
2095: Check_Req_ActFcst_Items(
2096: p_act_forecast_rec => p_act_forecast_rec,
2097: x_return_status => x_return_status
2098: );
2099: IF x_return_status <> FND_API.g_ret_sts_success THEN
2100: RETURN;
2101: END IF;
2102: ****
2103: */
2108: p_validation_mode => p_validation_mode,
2109: x_return_status => x_return_status
2110: );
2111:
2112: IF x_return_status <> FND_API.g_ret_sts_success THEN
2113: RETURN;
2114: END IF;
2115:
2116:
2122: p_act_forecast_rec => p_act_forecast_rec,
2123: x_return_status => x_return_status
2124: );
2125:
2126: IF x_return_status <> FND_API.g_ret_sts_success THEN
2127: RETURN;
2128: END IF;
2129: ****
2130: */