30: AND ((p_ROWID is null) OR
31: (rowid <> p_ROWID));
32:
33: IF (dummy_a >= 1) THEN
34: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
35: app_exception.raise_exception;
36: END IF;
37:
38: debug_info := 'Count for same vendor_id, invoice_num amount purged invoices';
43: AND vendor_id = p_VENDOR_ID
44: AND org_id = p_ORG_ID; -- Bug 5407785
45:
46: IF (dummy_b >= 1) THEN
47: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
48: app_exception.raise_exception;
49: END IF;
50:
51: EXCEPTION
50:
51: EXCEPTION
52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
51: EXCEPTION
52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid
52: WHEN OTHERS THEN
53: IF (SQLCODE <> -20001) THEN
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
54: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
55: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
56: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
57: current_calling_sequence);
58: FND_MESSAGE.SET_TOKEN('PARAMETERS',
59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
61: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
62: );
59: 'p_Rowid = ' ||p_Rowid
60: ||', p_INVOICE_NUM = '||p_INVOICE_NUM
61: ||', p_VENDOR_ID = ' ||p_VENDOR_ID
62: );
63: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
64: END IF;
65: APP_EXCEPTION.RAISE_EXCEPTION;
66:
67: END CHECK_UNIQUE;
628:
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
630: WHEN OTHERS THEN
631: IF (SQLCODE <> -20001) THEN
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id
632: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
633: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
634: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
635: current_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id
639: );
640: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: 'p_Rowid = '||p_Rowid
638: ||', p_invoice_id = '||p_invoice_id
639: );
640: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
641: END IF;
642: APP_EXCEPTION.RAISE_EXCEPTION;
643:
644: END Insert_Row;
1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1003: WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1008: current_calling_sequence);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id
1012: );
1013: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1009: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1010: 'p_Rowid = '||p_Rowid
1011: ||', p_invoice_id = '||p_invoice_id
1012: );
1013: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1014: END IF;
1015: APP_EXCEPTION.RAISE_EXCEPTION;
1016:
1017:
1153:
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1155: WHEN OTHERS THEN
1156: IF (SQLCODE <> -20001) THEN
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );
1157: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );
1164: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1165: END IF;
1160: current_calling_sequence);
1161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1162: 'p_Rowid = '||p_Rowid
1163: );
1164: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1165: END IF;
1166: APP_EXCEPTION.RAISE_EXCEPTION;
1167:
1168: