247: CLOSE C;
248: EXCEPTION
249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
248: EXCEPTION
249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
257: ' tax_category_id = ' || X_tax_category_id ||
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
257: ' tax_category_id = ' || X_tax_category_id ||
258: ' tax_attribute_type = ' || X_tax_attribute_type ||
257: ' tax_category_id = ' || X_tax_category_id ||
258: ' tax_attribute_type = ' || X_tax_attribute_type ||
259: ' tax_attribute_name = ' || X_tax_attribute_name ||
260: ' org_id = ' || X_org_id );
261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
262: END IF;
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: END Insert_Row;
265:
444: FETCH C INTO Recinfo;
445: IF (C%NOTFOUND) THEN
446: debug_info := 'Close cursor C - DATA NOTFOUND';
447: CLOSE C;
448: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
449: APP_EXCEPTION.Raise_Exception;
450: END IF;
451: debug_info := 'Close cursor C';
452: CLOSE C;
520: ((Recinfo.attribute15 IS NULL) AND
521: (X_attribute15 IS NULL)))) THEN
522: return;
523: ELSE
524: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
525: APP_EXCEPTION.Raise_Exception;
526: END IF;
527: EXCEPTION
528: WHEN OTHERS THEN
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (SQLCODE <> -20001) THEN
530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
529: IF (SQLCODE <> -20001) THEN
530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
539: ' tax_category_id = ' || X_tax_category_id ||
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
539: ' tax_category_id = ' || X_tax_category_id ||
540: ' tax_attribute_type = ' || X_tax_attribute_type ||
540: ' tax_attribute_type = ' || X_tax_attribute_type ||
541: ' tax_attribute_name = ' || X_tax_attribute_name ||
542: ' org_id = ' || X_org_id );
543:
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
545: END IF;
546: END IF;
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: END Lock_Row;
578: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))
579: AND org_id = X_org_id;
580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
579: AND org_id = X_org_id;
580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
588: ' tax_category_id = ' || X_tax_category_id ||
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
588: ' tax_category_id = ' || X_tax_category_id ||
589: ' tax_attribute_type = ' || X_tax_attribute_type ||
589: ' tax_attribute_type = ' || X_tax_attribute_type ||
590: ' tax_attribute_name = ' || X_tax_attribute_name||
591: ' org_id = ' || X_org_id);
592:
593: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: END IF;
596: END Check_Unique;
597: