123: CLOSE C;
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
135: END IF;
136: APP_EXCEPTION.RAISE_EXCEPTION;
137:
138: END Insert_Row;
223: FETCH C INTO Recinfo;
224: IF (C%NOTFOUND) THEN
225: debug_info := 'Close cursor C - DATA NOTFOUND';
226: CLOSE C;
227: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
228: APP_EXCEPTION.Raise_Exception;
229: END IF;
230: debug_info := 'Close cursor C';
231: CLOSE C;
308: ((Recinfo.attribute15 IS NULL) AND
309: (X_attribute15 IS NULL)))) THEN
310: return;
311: ELSE
312: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
313: APP_EXCEPTION.Raise_Exception;
314: END IF;
315:
316: EXCEPTION
316: EXCEPTION
317: WHEN OTHERS THEN
318: IF (SQLCODE <> -20001) THEN
319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: IF (SQLCODE <> -20001) THEN
319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
329: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
329: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
330: END IF;
331: END IF;
332: APP_EXCEPTION.RAISE_EXCEPTION;
333:
454: AND end_date_active = X_end_date_active
455: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
455: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
465: APP_EXCEPTION.RAISE_EXCEPTION;
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
465: APP_EXCEPTION.RAISE_EXCEPTION;
466: END IF;
467:
468: END Check_Unique;
498: a.end_date_active >= X_end_date_active))
499: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
499: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
509: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
509: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
510: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
511: APP_EXCEPTION.RAISE_EXCEPTION;
512: END IF;
513: END Check_Overlapped_Dates;
514:
569: AND a.tax_categ_slab_id = X_tax_categ_slab_id
570: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
570: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
580: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
580: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
581: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
582: APP_EXCEPTION.RAISE_EXCEPTION;
583: END IF;
584: END;
585: END IF;