46: AND ((p_ROWID is null) OR
47: (rowid <> p_ROWID));
48:
49: IF (dummy >= 1) THEN
50: fnd_message.set_name('SQLAP','AP_ALL_DUPLICATE_VALUE');
51: app_exception.raise_exception;
52: END IF;
53:
54: EXCEPTION
53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
55: WHEN OTHERS THEN
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);
56: IF (SQLCODE <> -20001) THEN
57: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
58: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
59: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);
64: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
60: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'Rowid = '||p_ROWID
61: ||', Invoice Id = '||p_INVOICE_ID
62: ||', Invoice line number = '||
63: p_line_number);
64: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
65: END IF;
66: APP_EXCEPTION.RAISE_EXCEPTION;
67: END CHECK_UNIQUE;
68:
627:
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;
629: WHEN OTHERS THEN
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637:
630: IF (SQLCODE <> -20001) THEN
631: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
632: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
633: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
635: END IF;
636: APP_EXCEPTION.RAISE_EXCEPTION;
637:
638: END Insert_Row;
995: FETCH C INTO Recinfo;
996: IF (C%NOTFOUND) THEN
997: debug_info := 'Close cursor C - ROW NOTFOUND';
998: CLOSE C;
999: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1000: APP_EXCEPTION.Raise_Exception;
1001: END IF;
1002: debug_info := 'Close cursor C';
1003: CLOSE C;
1069: OR ( (Recinfo.attribute13 IS NULL)
1070: AND (P_Attribute13 IS NULL)))) THEN
1071: NULL;
1072: ELSE
1073: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1074: APP_EXCEPTION.Raise_Exception;
1075: END IF;
1076: IF (
1077: ( (Recinfo.attribute14 = P_Attribute14)
1186: OR ( (Recinfo.country_of_supply IS NULL)
1187: AND (P_Country_Of_Supply IS NULL)))) THEN
1188: NULL;
1189: ELSE
1190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1191: APP_EXCEPTION.Raise_Exception;
1192: END IF;
1193: IF (
1194: ( (Recinfo.global_attribute_category =
1492: AND (P_TAX_CLASSIFICATION_CODE IS NULL)))
1493: ) THEN
1494: RETURN;
1495: ELSE
1496: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1497: APP_EXCEPTION.Raise_Exception;
1498: END IF;
1499:
1500: EXCEPTION
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: IF (SQLCODE <> -20001) THEN
1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1502: IF (SQLCODE <> -20001) THEN
1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1503: IF (SQLCODE = -54) THEN
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;
1504: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;
1512: APP_EXCEPTION.RAISE_EXCEPTION;
1505: ELSE
1506: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1507: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1508: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1509: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1510: END IF;
1511: END IF;
1512: APP_EXCEPTION.RAISE_EXCEPTION;
1513:
1880:
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1882: WHEN OTHERS THEN
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890:
1883: IF (SQLCODE <> -20001) THEN
1884: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1885: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1886: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1888: END IF;
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890:
1891: END Update_Row;
1943: P_error_code => l_error_code,
1944: P_calling_sequence => current_calling_sequence);
1945:
1946: IF(not l_success) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');
1948: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1949: APP_EXCEPTION.RAISE_EXCEPTION;
1950: END IF;
1951: END IF;
1944: P_calling_sequence => current_calling_sequence);
1945:
1946: IF(not l_success) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_ETX_TAX_LINE_DEL_FAIL');
1948: FND_MESSAGE.SET_TOKEN('REASON',l_error_code);
1949: APP_EXCEPTION.RAISE_EXCEPTION;
1950: END IF;
1951: END IF;
1952: --End of Bug9295867
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;
1963: WHEN OTHERS THEN
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;
1971:
1964: IF (SQLCODE <> -20001) THEN
1965: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1966: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1967: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1969: END IF;
1970: APP_EXCEPTION.RAISE_EXCEPTION;
1971:
1972: END Delete_Row;