DBA Data[Home] [Help]

APPS.AP_AWT_TAX_RATES_PKG dependencies on FND_MESSAGE

Line 213: FND_MESSAGE.SET_NAME('SQLAP','AP_AWT_DATE_OVRLP');

209: CLOSE c_rate_type;
210:
211: EXCEPTION
212: WHEN DATE_OVERLAP THEN
213: FND_MESSAGE.SET_NAME('SQLAP','AP_AWT_DATE_OVRLP');
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: WHEN AMOUNT_OVERLAP THEN
216: FND_MESSAGE.SET_NAME('SQLAP','AP_OVERLAP1');
217: APP_EXCEPTION.RAISE_EXCEPTION;

Line 216: FND_MESSAGE.SET_NAME('SQLAP','AP_OVERLAP1');

212: WHEN DATE_OVERLAP THEN
213: FND_MESSAGE.SET_NAME('SQLAP','AP_AWT_DATE_OVRLP');
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: WHEN AMOUNT_OVERLAP THEN
216: FND_MESSAGE.SET_NAME('SQLAP','AP_OVERLAP1');
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: WHEN OTHERS THEN
219: IF (SQLCODE <> -20001) THEN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

216: FND_MESSAGE.SET_NAME('SQLAP','AP_OVERLAP1');
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: WHEN OTHERS THEN
219: IF (SQLCODE <> -20001) THEN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

217: APP_EXCEPTION.RAISE_EXCEPTION;
218: WHEN OTHERS THEN
219: IF (SQLCODE <> -20001) THEN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

218: WHEN OTHERS THEN
219: IF (SQLCODE <> -20001) THEN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;

Line 223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);

219: IF (SQLCODE <> -20001) THEN
220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
227: END CHECK_AMOUNT_OVERLAP;

Line 224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

220: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
221: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
222: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
223: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
227: END CHECK_AMOUNT_OVERLAP;
228:

Line 311: FND_MESSAGE.SET_NAME('SQLAP','AP_GAPS');

307: CLOSE c_rate_type;
308:
309: EXCEPTION
310: WHEN AMOUNT_GAP THEN
311: FND_MESSAGE.SET_NAME('SQLAP','AP_GAPS');
312: APP_EXCEPTION.RAISE_EXCEPTION;
313: WHEN OTHERS THEN
314: IF (SQLCODE <> -20001) THEN
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

311: FND_MESSAGE.SET_NAME('SQLAP','AP_GAPS');
312: APP_EXCEPTION.RAISE_EXCEPTION;
313: WHEN OTHERS THEN
314: IF (SQLCODE <> -20001) THEN
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

312: APP_EXCEPTION.RAISE_EXCEPTION;
313: WHEN OTHERS THEN
314: IF (SQLCODE <> -20001) THEN
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
320: END IF;

Line 317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

313: WHEN OTHERS THEN
314: IF (SQLCODE <> -20001) THEN
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
320: END IF;
321: APP_EXCEPTION.RAISE_EXCEPTION;

Line 318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);

314: IF (SQLCODE <> -20001) THEN
315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
320: END IF;
321: APP_EXCEPTION.RAISE_EXCEPTION;
322: END CHECK_AMOUNT_GAPS;

Line 319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
318: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
319: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
320: END IF;
321: APP_EXCEPTION.RAISE_EXCEPTION;
322: END CHECK_AMOUNT_GAPS;
323:

Line 394: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST1');

390: CLOSE c_rate_type;
391:
392: EXCEPTION
393: WHEN LAST_AMOUNT_ERROR THEN
394: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST1');
395: APP_EXCEPTION.RAISE_EXCEPTION;
396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST2');
398: APP_EXCEPTION.RAISE_EXCEPTION;

Line 397: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST2');

393: WHEN LAST_AMOUNT_ERROR THEN
394: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST1');
395: APP_EXCEPTION.RAISE_EXCEPTION;
396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST2');
398: APP_EXCEPTION.RAISE_EXCEPTION;
399: WHEN TOO_MANY_ROWS THEN
400: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST3');
401: APP_EXCEPTION.RAISE_EXCEPTION;

Line 400: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST3');

396: WHEN NO_DATA_FOUND THEN
397: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST2');
398: APP_EXCEPTION.RAISE_EXCEPTION;
399: WHEN TOO_MANY_ROWS THEN
400: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST3');
401: APP_EXCEPTION.RAISE_EXCEPTION;
402: WHEN OTHERS THEN
403: IF (SQLCODE <> -20001) THEN
404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

400: FND_MESSAGE.SET_NAME('SQLAP','AP_LAST3');
401: APP_EXCEPTION.RAISE_EXCEPTION;
402: WHEN OTHERS THEN
403: IF (SQLCODE <> -20001) THEN
404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

401: APP_EXCEPTION.RAISE_EXCEPTION;
402: WHEN OTHERS THEN
403: IF (SQLCODE <> -20001) THEN
404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
409: END IF;

Line 406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

402: WHEN OTHERS THEN
403: IF (SQLCODE <> -20001) THEN
404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
409: END IF;
410: APP_EXCEPTION.RAISE_EXCEPTION;

Line 407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);

403: IF (SQLCODE <> -20001) THEN
404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
409: END IF;
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END CHECK_LAST_AMOUNT;

Line 408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
407: FND_MESSAGE.SET_TOKEN('PARAMETERS','tax_name = '||X_tax_name);
408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
409: END IF;
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END CHECK_LAST_AMOUNT;
412: