78: debug ( 'Review Type =' || p_review_type);
79: debug ( 'Data Point Category =' ||p_data_point_category);
80: debug ( 'Data Point Sub Category =' ||p_data_point_sub_category);
81: END IF;
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: IF FND_API.to_Boolean( p_init_msg_list )
85: THEN
86: FND_MSG_PUB.initialize;
80: debug ( 'Data Point Sub Category =' ||p_data_point_sub_category);
81: END IF;
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: IF FND_API.to_Boolean( p_init_msg_list )
85: THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: IF p_data_point_sub_category IS NOT NULL
91: IF pg_debug = 'Y'
92: THEN
93: debug ( 'Data Point category IS NULL and data Point Sub Category IS not null');
94: END IF;
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: x_msg_data := 'Data Point category IS NULL and data Point Sub Category IS not null';
97: return;
98: END IF;
99:
111:
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: x_msg_data := 'Invalid Data Point Sub Category';
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: return;
117: WHEN OTHERS THEN
118: x_msg_data := Sqlerrm;
119: x_return_status := FND_API.G_RET_STS_ERROR;
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: return;
117: WHEN OTHERS THEN
118: x_msg_data := Sqlerrm;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: return;
121: END;
122: END IF;
123: IF pg_debug = 'Y'
137:
138: EXCEPTION
139: WHEN NO_DATA_FOUND THEN
140: x_msg_data := 'Invalid Data Point Category';
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: return;
143: WHEN OTHERS THEN
144: x_msg_data := Sqlerrm;
145: x_return_status := FND_API.G_RET_STS_ERROR;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: return;
143: WHEN OTHERS THEN
144: x_msg_data := Sqlerrm;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: return;
147: END;
148: END IF;
149: