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