129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
130: EXCEPTION
131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;
141:
142: END Insert_Row;
203: IF (C%NOTFOUND)
204: THEN
205: debug_info := 'Close cursor C - DATA NOTFOUND';
206: CLOSE C;
207: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
208: APP_EXCEPTION.Raise_Exception;
209: END IF;
210: debug_info := 'Close cursor C';
211: CLOSE C;
256: )
257: THEN
258: return;
259: ELSE
260: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
261: APP_EXCEPTION.Raise_Exception;
262: END IF;
263:
264: EXCEPTION
264: EXCEPTION
265: WHEN OTHERS THEN
266: IF (SQLCODE <> -20001) THEN
267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
266: IF (SQLCODE <> -20001) THEN
267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;
277: END IF;
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;
277: END IF;
278: APP_EXCEPTION.RAISE_EXCEPTION;
279: END Lock_Row;
392: AND end_date_active = X_end_date_active
393: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
393: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||
403: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||
403: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
404: ' end_date_active = ' || X_end_date_active );
405: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
406: APP_EXCEPTION.RAISE_EXCEPTION;
407: END IF;
408: END Check_Unique;
409:
444: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
445:
446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
445:
446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||
455: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||
455: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
456: ' end_date_active = ' || X_end_date_active );
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: END IF;
460: END Check_Overlapped_Dates;
461:
525: AND a.con_tax_attribute_value = X_con_tax_attribute_value
526: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
526: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
536: ' con_tax_attribute_name = '||X_con_tax_attribute_name ||
535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
536: ' con_tax_attribute_name = '||X_con_tax_attribute_name ||
537: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
538: ' end_date_active = ' || X_end_date_active );
539: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
540: APP_EXCEPTION.RAISE_EXCEPTION;
541: END IF;
542: END;
543: END IF;