229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF (SQLCODE <> -20001) THEN
233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getHeaderLevelApprover');
236: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
237: APP_EXCEPTION.RAISE_EXCEPTION;
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF (SQLCODE <> -20001) THEN
233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getHeaderLevelApprover');
236: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
237: APP_EXCEPTION.RAISE_EXCEPTION;
238: ELSE
231: WHEN OTHERS THEN
232: IF (SQLCODE <> -20001) THEN
233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getHeaderLevelApprover');
236: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
237: APP_EXCEPTION.RAISE_EXCEPTION;
238: ELSE
239: -- Do not need to set the token since it has been done in the
232: IF (SQLCODE <> -20001) THEN
233: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
234: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
235: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getHeaderLevelApprover');
236: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
237: APP_EXCEPTION.RAISE_EXCEPTION;
238: ELSE
239: -- Do not need to set the token since it has been done in the
240: -- child process
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF (SQLCODE <> -20001) THEN
282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getLineLevelApprover');
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
279: EXCEPTION
280: WHEN OTHERS THEN
281: IF (SQLCODE <> -20001) THEN
282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getLineLevelApprover');
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287: ELSE
280: WHEN OTHERS THEN
281: IF (SQLCODE <> -20001) THEN
282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getLineLevelApprover');
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287: ELSE
288: -- Do not need to set the token since it has been done in the
281: IF (SQLCODE <> -20001) THEN
282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
283: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
284: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getLineLevelApprover');
285: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
286: APP_EXCEPTION.RAISE_EXCEPTION;
287: ELSE
288: -- Do not need to set the token since it has been done in the
289: -- child process
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: IF (SQLCODE <> -20001) THEN
342: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
343: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
344: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCustomCostCenterOwner');
345: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
346: APP_EXCEPTION.RAISE_EXCEPTION;
339: EXCEPTION
340: WHEN OTHERS THEN
341: IF (SQLCODE <> -20001) THEN
342: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
343: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
344: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCustomCostCenterOwner');
345: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: ELSE
340: WHEN OTHERS THEN
341: IF (SQLCODE <> -20001) THEN
342: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
343: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
344: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCustomCostCenterOwner');
345: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: ELSE
348: -- Do not need to set the token since it has been done in the
341: IF (SQLCODE <> -20001) THEN
342: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
343: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
344: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCustomCostCenterOwner');
345: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: ELSE
348: -- Do not need to set the token since it has been done in the
349: -- child process
471: WHEN NO_DATA_FOUND THEN
472: RETURN NULL;
473: WHEN OTHERS THEN
474: IF (SQLCODE <> -20001) THEN
475: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCCBusinessManager');
478: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
479: APP_EXCEPTION.RAISE_EXCEPTION;
472: RETURN NULL;
473: WHEN OTHERS THEN
474: IF (SQLCODE <> -20001) THEN
475: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCCBusinessManager');
478: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: ELSE
473: WHEN OTHERS THEN
474: IF (SQLCODE <> -20001) THEN
475: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCCBusinessManager');
478: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: ELSE
481: -- Do not need to set the token since it has been done in the
474: IF (SQLCODE <> -20001) THEN
475: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCCBusinessManager');
478: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: ELSE
481: -- Do not need to set the token since it has been done in the
482: -- child process
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: IF (SQLCODE <> -20001) THEN
616: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
617: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
618: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterApprover');
619: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
620: APP_EXCEPTION.RAISE_EXCEPTION;
613: EXCEPTION
614: WHEN OTHERS THEN
615: IF (SQLCODE <> -20001) THEN
616: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
617: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
618: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterApprover');
619: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
620: APP_EXCEPTION.RAISE_EXCEPTION;
621: ELSE
614: WHEN OTHERS THEN
615: IF (SQLCODE <> -20001) THEN
616: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
617: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
618: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterApprover');
619: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
620: APP_EXCEPTION.RAISE_EXCEPTION;
621: ELSE
622: -- Do not need to set the token since it has been done in the
615: IF (SQLCODE <> -20001) THEN
616: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
617: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
618: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getCostCenterApprover');
619: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
620: APP_EXCEPTION.RAISE_EXCEPTION;
621: ELSE
622: -- Do not need to set the token since it has been done in the
623: -- child process