45: return l_out;
46: EXCEPTION
47: WHEN OTHERS THEN
48: BEGIN
49: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
50: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
51: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNext');
52: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
53: END;
46: EXCEPTION
47: WHEN OTHERS THEN
48: BEGIN
49: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
50: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
51: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNext');
52: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
53: END;
54:
47: WHEN OTHERS THEN
48: BEGIN
49: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
50: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
51: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNext');
52: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
53: END;
54:
55: end getNext;
48: BEGIN
49: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
50: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
51: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNext');
52: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
53: END;
54:
55: end getNext;
56:
67:
68: EXCEPTION
69: WHEN OTHERS THEN
70: BEGIN
71: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
72: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
73: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNextLong');
74: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
75: END;
68: EXCEPTION
69: WHEN OTHERS THEN
70: BEGIN
71: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
72: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
73: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNextLong');
74: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
75: END;
76:
69: WHEN OTHERS THEN
70: BEGIN
71: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
72: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
73: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNextLong');
74: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
75: END;
76:
77: end getNextLong;
70: BEGIN
71: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
72: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
73: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'getNextLong');
74: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
75: END;
76:
77: end getNextLong;
78:
227: end if;
228: exception
229: when others then
230: BEGIN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
234: current_calling_sequence);
235: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
228: exception
229: when others then
230: BEGIN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
234: current_calling_sequence);
235: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
236: APP_EXCEPTION.RAISE_EXCEPTION;
229: when others then
230: BEGIN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
234: current_calling_sequence);
235: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END;
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
234: current_calling_sequence);
235: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END;
238: end;
239:
610:
611: EXCEPTION
612: WHEN OTHERS THEN
613: BEGIN
614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
617: current_calling_sequence);
618: FND_MESSAGE.SET_TOKEN('PARAMETERS',
611: EXCEPTION
612: WHEN OTHERS THEN
613: BEGIN
614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
617: current_calling_sequence);
618: FND_MESSAGE.SET_TOKEN('PARAMETERS',
619: 'V_line=' || V_line
612: WHEN OTHERS THEN
613: BEGIN
614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
617: current_calling_sequence);
618: FND_MESSAGE.SET_TOKEN('PARAMETERS',
619: 'V_line=' || V_line
620: );
614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
617: current_calling_sequence);
618: FND_MESSAGE.SET_TOKEN('PARAMETERS',
619: 'V_line=' || V_line
620: );
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: APP_EXCEPTION.RAISE_EXCEPTION;
617: current_calling_sequence);
618: FND_MESSAGE.SET_TOKEN('PARAMETERS',
619: 'V_line=' || V_line
620: );
621: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
622: APP_EXCEPTION.RAISE_EXCEPTION;
623: END;
624:
625: END String2PLSQL_Receipts;
694: EXCEPTION
695: WHEN OTHERS THEN
696: BEGIN
697: IF (SQLCODE <> -20001) THEN
698: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
699: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
700: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
701: current_calling_sequence);
702: FND_MESSAGE.SET_TOKEN('PARAMETERS',
695: WHEN OTHERS THEN
696: BEGIN
697: IF (SQLCODE <> -20001) THEN
698: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
699: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
700: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
701: current_calling_sequence);
702: FND_MESSAGE.SET_TOKEN('PARAMETERS',
703: 'V_line=' || V_line
696: BEGIN
697: IF (SQLCODE <> -20001) THEN
698: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
699: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
700: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
701: current_calling_sequence);
702: FND_MESSAGE.SET_TOKEN('PARAMETERS',
703: 'V_line=' || V_line
704: );
698: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
699: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
700: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
701: current_calling_sequence);
702: FND_MESSAGE.SET_TOKEN('PARAMETERS',
703: 'V_line=' || V_line
704: );
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
706: END IF;
701: current_calling_sequence);
702: FND_MESSAGE.SET_TOKEN('PARAMETERS',
703: 'V_line=' || V_line
704: );
705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
706: END IF;
707: APP_EXCEPTION.RAISE_EXCEPTION;
708: END;
709:
937: END IF;
938: EXCEPTION
939: WHEN OTHERS THEN
940: BEGIN
941: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
944: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
945: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
938: EXCEPTION
939: WHEN OTHERS THEN
940: BEGIN
941: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
944: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
945: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
946: APP_EXCEPTION.Raise_Exception;
939: WHEN OTHERS THEN
940: BEGIN
941: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
944: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
945: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
946: APP_EXCEPTION.Raise_Exception;
947: END;
940: BEGIN
941: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
944: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
945: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
946: APP_EXCEPTION.Raise_Exception;
947: END;
948:
941: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
942: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
943: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', V_CurrentCallingSequence);
944: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
945: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',V_DebugInfo);
946: APP_EXCEPTION.Raise_Exception;
947: END;
948:
949: END MapCustomArrayToColumn;