125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF (SQLCODE <> -20001) THEN
129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
133: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF (SQLCODE <> -20001) THEN
129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
133: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
134: ' tax_category_id = ' || X_tax_category_id ||
127: WHEN OTHERS THEN
128: IF (SQLCODE <> -20001) THEN
129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
133: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
134: ' tax_category_id = ' || X_tax_category_id ||
135: ' tax_attribute_name = ' || X_tax_attribute_name );
128: IF (SQLCODE <> -20001) THEN
129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
133: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
134: ' tax_category_id = ' || X_tax_category_id ||
135: ' tax_attribute_name = ' || X_tax_attribute_name );
136: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
133: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
134: ' tax_category_id = ' || X_tax_category_id ||
135: ' tax_attribute_name = ' || X_tax_attribute_name );
136: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
137: END IF;
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END Insert_Row;
140:
248:
249: IF (C%NOTFOUND) THEN
250: debug_info := 'Close cursor C - DATA NOTFOUND';
251: CLOSE C;
252: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
253: APP_EXCEPTION.Raise_Exception;
254: END IF;
255:
256: debug_info := 'Close cursor C';
276: ((Recinfo.created_by IS NULL) AND
277: (X_created_by IS NULL)))) THEN
278: return;
279: ELSE
280: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
281: APP_EXCEPTION.Raise_Exception;
282: END IF;
283: EXCEPTION
284: WHEN OTHERS THEN
283: EXCEPTION
284: WHEN OTHERS THEN
285: IF (SQLCODE <> -20001) THEN
286: IF (SQLCODE = -54) THEN
287: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
288: ELSE
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
285: IF (SQLCODE <> -20001) THEN
286: IF (SQLCODE = -54) THEN
287: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
288: ELSE
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
292: FND_MESSAGE.SET_TOKEN('PARAMETERS',
293: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
286: IF (SQLCODE = -54) THEN
287: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
288: ELSE
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
292: FND_MESSAGE.SET_TOKEN('PARAMETERS',
293: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
294: ' tax_category_id = ' || X_tax_category_id ||
287: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
288: ELSE
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
292: FND_MESSAGE.SET_TOKEN('PARAMETERS',
293: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
294: ' tax_category_id = ' || X_tax_category_id ||
295: ' tax_attribute_name = ' || X_tax_attribute_name );
288: ELSE
289: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
290: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
291: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
292: FND_MESSAGE.SET_TOKEN('PARAMETERS',
293: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
294: ' tax_category_id = ' || X_tax_category_id ||
295: ' tax_attribute_name = ' || X_tax_attribute_name );
296: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
292: FND_MESSAGE.SET_TOKEN('PARAMETERS',
293: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
294: ' tax_category_id = ' || X_tax_category_id ||
295: ' tax_attribute_name = ' || X_tax_attribute_name );
296: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
297: END IF;
298: END IF;
299: APP_EXCEPTION.RAISE_EXCEPTION;
300: END Lock_Row;
327: AND org_id = X_org_id
328: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
329:
330: IF (l_dummy >=1) THEN
331: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
333: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
334: FND_MESSAGE.SET_TOKEN('PARAMETERS',
335: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
328: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
329:
330: IF (l_dummy >=1) THEN
331: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
333: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
334: FND_MESSAGE.SET_TOKEN('PARAMETERS',
335: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
336: ' tax_category_id = ' || X_tax_category_id ||
329:
330: IF (l_dummy >=1) THEN
331: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
333: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
334: FND_MESSAGE.SET_TOKEN('PARAMETERS',
335: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
336: ' tax_category_id = ' || X_tax_category_id ||
337: ' tax_attribute_name = ' || X_tax_attribute_name );
330: IF (l_dummy >=1) THEN
331: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
333: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
334: FND_MESSAGE.SET_TOKEN('PARAMETERS',
335: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
336: ' tax_category_id = ' || X_tax_category_id ||
337: ' tax_attribute_name = ' || X_tax_attribute_name );
338: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
334: FND_MESSAGE.SET_TOKEN('PARAMETERS',
335: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
336: ' tax_category_id = ' || X_tax_category_id ||
337: ' tax_attribute_name = ' || X_tax_attribute_name );
338: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
339: APP_EXCEPTION.RAISE_EXCEPTION;
340: END IF;
341: END Check_Unique;
342: