29: distribution_line_number = p_DISTRIBUTION_LINE_NUMBER)
30: AND ((p_ROWID is null) or (rowid <> p_ROWID));
31:
32: IF (dummy >= 1) THEN
33: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
34: app_exception.raise_exception;
35: END IF;
36:
37: EXCEPTION
36:
37: EXCEPTION
38: WHEN OTHERS THEN
39: IF (SQLCODE <> -20001) THEN
40: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
41: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
42: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
43: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
44: ||', Invoice Id = '||p_INVOICE_ID
37: EXCEPTION
38: WHEN OTHERS THEN
39: IF (SQLCODE <> -20001) THEN
40: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
41: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
42: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
43: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
44: ||', Invoice Id = '||p_INVOICE_ID
45: ||', Distribution line number = '||
38: WHEN OTHERS THEN
39: IF (SQLCODE <> -20001) THEN
40: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
41: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
42: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
43: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
44: ||', Invoice Id = '||p_INVOICE_ID
45: ||', Distribution line number = '||
46: p_DISTRIBUTION_LINE_NUMBER);
39: IF (SQLCODE <> -20001) THEN
40: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
41: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
42: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
43: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
44: ||', Invoice Id = '||p_INVOICE_ID
45: ||', Distribution line number = '||
46: p_DISTRIBUTION_LINE_NUMBER);
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
43: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
44: ||', Invoice Id = '||p_INVOICE_ID
45: ||', Distribution line number = '||
46: p_DISTRIBUTION_LINE_NUMBER);
47: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
48: END IF;
49: APP_EXCEPTION.RAISE_EXCEPTION;
50: END CHECK_UNIQUE;
51:
559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF (SQLCODE <> -20001) THEN
563: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
564: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
566: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
567: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF (SQLCODE <> -20001) THEN
563: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
564: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
566: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
567: END IF;
568: APP_EXCEPTION.RAISE_EXCEPTION;
561: WHEN OTHERS THEN
562: IF (SQLCODE <> -20001) THEN
563: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
564: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
566: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
567: END IF;
568: APP_EXCEPTION.RAISE_EXCEPTION;
569:
562: IF (SQLCODE <> -20001) THEN
563: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
564: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
565: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
566: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
567: END IF;
568: APP_EXCEPTION.RAISE_EXCEPTION;
569:
570: END Insert_Row;
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: IF (SQLCODE <> -20001) THEN
856: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
857: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
860: END IF;
853: EXCEPTION
854: WHEN OTHERS THEN
855: IF (SQLCODE <> -20001) THEN
856: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
857: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
860: END IF;
861: APP_EXCEPTION.RAISE_EXCEPTION;
854: WHEN OTHERS THEN
855: IF (SQLCODE <> -20001) THEN
856: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
857: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
860: END IF;
861: APP_EXCEPTION.RAISE_EXCEPTION;
862:
855: IF (SQLCODE <> -20001) THEN
856: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
857: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
858: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
860: END IF;
861: APP_EXCEPTION.RAISE_EXCEPTION;
862:
863: END Update_Row;
900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
907: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
908: END IF;
901: EXCEPTION
902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
907: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
907: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
907: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
908: END IF;
909: APP_EXCEPTION.RAISE_EXCEPTION;
910:
911: END Delete_Row;