87: RETURN x_concat_value;
88:
89: EXCEPTION
90: WHEN too_many_rows THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92:
93: WHEN no_data_found THEN
94: RETURN NULL;
95:
93: WHEN no_data_found THEN
94: RETURN NULL;
95:
96: WHEN others THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98:
99: END GET_CONCAT_LINE_NUMBER;
100:
101: FUNCTION GET_CONCAT_HIST_LINE_NUMBER
185: RETURN x_concat_value;
186:
187: EXCEPTION
188: WHEN too_many_rows THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190:
191: WHEN no_data_found THEN
192: RETURN NULL;
193:
191: WHEN no_data_found THEN
192: RETURN NULL;
193:
194: WHEN others THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196:
197: END GET_CONCAT_HIST_LINE_NUMBER;
198:
199: FUNCTION GET_CONCAT_HIST_LINE_NUMBER
281: RETURN x_concat_value;
282:
283: EXCEPTION
284: WHEN too_many_rows THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286:
287: WHEN no_data_found THEN
288: RETURN NULL;
289:
287: WHEN no_data_found THEN
288: RETURN NULL;
289:
290: WHEN others THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292:
293: END GET_CONCAT_HIST_LINE_NUMBER;
294: END OE_ORDER_MISC_PUB;