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:
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
569: END IF;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
569: END IF;
570: APP_EXCEPTION.RAISE_EXCEPTION;
563: WHEN OTHERS THEN
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
569: END IF;
570: APP_EXCEPTION.RAISE_EXCEPTION;
571:
564: IF (SQLCODE <> -20001) THEN
565: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
566: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
567: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
568: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
569: END IF;
570: APP_EXCEPTION.RAISE_EXCEPTION;
571:
572: END Insert_Row;
854:
855: EXCEPTION
856: WHEN OTHERS THEN
857: IF (SQLCODE <> -20001) THEN
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
862: END IF;
855: EXCEPTION
856: WHEN OTHERS THEN
857: IF (SQLCODE <> -20001) THEN
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
862: END IF;
863: APP_EXCEPTION.RAISE_EXCEPTION;
856: WHEN OTHERS THEN
857: IF (SQLCODE <> -20001) THEN
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
862: END IF;
863: APP_EXCEPTION.RAISE_EXCEPTION;
864:
857: IF (SQLCODE <> -20001) THEN
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
862: END IF;
863: APP_EXCEPTION.RAISE_EXCEPTION;
864:
865: END Update_Row;
902:
903: EXCEPTION
904: WHEN OTHERS THEN
905: IF (SQLCODE <> -20001) THEN
906: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
907: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
908: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
910: END IF;
903: EXCEPTION
904: WHEN OTHERS THEN
905: IF (SQLCODE <> -20001) THEN
906: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
907: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
908: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
910: END IF;
911: APP_EXCEPTION.RAISE_EXCEPTION;
904: WHEN OTHERS THEN
905: IF (SQLCODE <> -20001) THEN
906: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
907: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
908: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
910: END IF;
911: APP_EXCEPTION.RAISE_EXCEPTION;
912:
905: IF (SQLCODE <> -20001) THEN
906: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
907: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
908: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
910: END IF;
911: APP_EXCEPTION.RAISE_EXCEPTION;
912:
913: END Delete_Row;