169: CLOSE l_flows_csr;
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
174: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
175: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Hiearchy');
176: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', '');
177: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
174: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
175: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Hiearchy');
176: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', '');
177: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
178: APP_EXCEPTION.RAISE_EXCEPTION;
171: EXCEPTION
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
174: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
175: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Hiearchy');
176: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', '');
177: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END GET_FLOW_HIEARCHY;
172: WHEN OTHERS THEN
173: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
174: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
175: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Hiearchy');
176: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', '');
177: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END GET_FLOW_HIEARCHY;
180:
173: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
174: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
175: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'Hiearchy');
176: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', '');
177: FND_MESSAGE.SET_TOKEN('PARAMETERS', '');
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END GET_FLOW_HIEARCHY;
180:
181: