26: | API to calculate tax from the import program
27: | P_All_Error_Messages - Determine if the calling point wants the returning
28: | of all or only 1 error message. Calling point will
29: | pass Y in the case they want to handle the return of
30: | more than one message from the FND message pile. N
31: | if they just want 1 message to be returned.
32: | P_error_code - Error code to be returned
33: | P_calling_sequence - Calling sequence
34: |
297:
298: EXCEPTION
299: WHEN OTHERS THEN
300: IF (SQLCODE <> -20001) THEN
301: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
305: ' P_Invoice_Id = '||P_Invoice_Id||
298: EXCEPTION
299: WHEN OTHERS THEN
300: IF (SQLCODE <> -20001) THEN
301: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
305: ' P_Invoice_Id = '||P_Invoice_Id||
306: ' P_Calling_Mode = '||P_Calling_Mode||
299: WHEN OTHERS THEN
300: IF (SQLCODE <> -20001) THEN
301: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
305: ' P_Invoice_Id = '||P_Invoice_Id||
306: ' P_Calling_Mode = '||P_Calling_Mode||
307: ' P_Override_Status = '||P_Override_Status||
300: IF (SQLCODE <> -20001) THEN
301: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
302: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
303: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
304: FND_MESSAGE.SET_TOKEN('PARAMETERS',
305: ' P_Invoice_Id = '||P_Invoice_Id||
306: ' P_Calling_Mode = '||P_Calling_Mode||
307: ' P_Override_Status = '||P_Override_Status||
308: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
308: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
309: ' P_All_Error_Messages = '||P_All_Error_Messages||
310: ' P_Error_Code = '||P_Error_Code||
311: ' P_Calling_Sequence = '||P_Calling_Sequence);
312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
313:
314: END IF;
315: APP_EXCEPTION.RAISE_EXCEPTION;
316:
378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE <> -20001) THEN
382: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
383: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
384: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
385:
386: END IF;
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE <> -20001) THEN
382: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
383: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
384: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
385:
386: END IF;
387: APP_EXCEPTION.RAISE_EXCEPTION;
380: WHEN OTHERS THEN
381: IF (SQLCODE <> -20001) THEN
382: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
383: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
384: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
385:
386: END IF;
387: APP_EXCEPTION.RAISE_EXCEPTION;
388:
417: | API to calculate tax from the import program
418: | x_All_Error_Messages - Determine if the calling point wants the returning
419: | of all or only 1 error message. Calling point will
420: | pass Y in the case they want to handle the return of
421: | more than one message from the FND message pile. N
422: | if they just want 1 message to be returned.
423: | x_event_id - used by OVERRIDE TAX
424: | x_error_code - Error code to be returned
425: | x_calling_sequence - Calling sequence
472: EXCEPTION
473: WHEN OTHERS THEN
474: /*
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('PARAMETERS',
480: ' x_Invoice_Id = '||x_Invoice_Id||
473: WHEN OTHERS THEN
474: /*
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('PARAMETERS',
480: ' x_Invoice_Id = '||x_Invoice_Id||
481: ' x_Calling_Mode = '||x_Calling_Mode||
474: /*
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('PARAMETERS',
480: ' x_Invoice_Id = '||x_Invoice_Id||
481: ' x_Calling_Mode = '||x_Calling_Mode||
482: ' x_Override_Status = '||x_Override_Status||
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('PARAMETERS',
480: ' x_Invoice_Id = '||x_Invoice_Id||
481: ' x_Calling_Mode = '||x_Calling_Mode||
482: ' x_Override_Status = '||x_Override_Status||
483: ' x_Line_Number_To_Delete = '||x_Line_Number_To_Delete||
483: ' x_Line_Number_To_Delete = '||x_Line_Number_To_Delete||
484: ' x_All_Error_Messages = '||x_All_Error_Messages||
485: ' x_Error_Code = '||x_Error_Code||
486: ' x_Calling_Sequence = '||x_Calling_Sequence);
487: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
488:
489: END IF;
490: APP_EXCEPTION.RAISE_EXCEPTION;
491: */