366:
367: Exception
368: WHEN Tax_Exception Then
369:
370: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
371: IF l_error_code IS NOT NULL THEN
372: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
373: ELSE
374: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
368: WHEN Tax_Exception Then
369:
370: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
371: IF l_error_code IS NOT NULL THEN
372: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
373: ELSE
374: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
375: END IF;
376: APP_EXCEPTION.RAISE_EXCEPTION;
370: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
371: IF l_error_code IS NOT NULL THEN
372: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
373: ELSE
374: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
375: END IF;
376: APP_EXCEPTION.RAISE_EXCEPTION;
377:
378: WHEN others then
376: APP_EXCEPTION.RAISE_EXCEPTION;
377:
378: WHEN others then
379: If (SQLCODE <> -20001) Then
380: fnd_message.set_name('SQLAP','AP_DEBUG');
381: fnd_message.set_token('ERROR',SQLERRM);
382: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
383: fnd_message.set_token('PARAMETERS',
384: 'X_invoice_id= '||to_char(x_invoice_id)
377:
378: WHEN others then
379: If (SQLCODE <> -20001) Then
380: fnd_message.set_name('SQLAP','AP_DEBUG');
381: fnd_message.set_token('ERROR',SQLERRM);
382: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
383: fnd_message.set_token('PARAMETERS',
384: 'X_invoice_id= '||to_char(x_invoice_id)
385: ||'X_total_amount= '||to_char(x_total_amount)
378: WHEN others then
379: If (SQLCODE <> -20001) Then
380: fnd_message.set_name('SQLAP','AP_DEBUG');
381: fnd_message.set_token('ERROR',SQLERRM);
382: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
383: fnd_message.set_token('PARAMETERS',
384: 'X_invoice_id= '||to_char(x_invoice_id)
385: ||'X_total_amount= '||to_char(x_total_amount)
386: ||'X_prorate_flag= '||x_prorate_flag
379: If (SQLCODE <> -20001) Then
380: fnd_message.set_name('SQLAP','AP_DEBUG');
381: fnd_message.set_token('ERROR',SQLERRM);
382: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
383: fnd_message.set_token('PARAMETERS',
384: 'X_invoice_id= '||to_char(x_invoice_id)
385: ||'X_total_amount= '||to_char(x_total_amount)
386: ||'X_prorate_flag= '||x_prorate_flag
387: ||'X_account_id= '||to_char(x_account_id)
387: ||'X_account_id= '||to_char(x_account_id)
388: ||'X_line_type= '||x_line_type
389: ||'X_row_count= '||to_char(x_row_count)
390: ||'X_description= '||x_description);
391: fnd_message.set_token('DEBUG_INFO',l_debug_info);
392: End if;
393: app_exception.raise_exception;
394:
395:
486:
487: g_accounting_date := l_accounting_date; --Bug16216470
488:
489: IF (g_accounting_date IS NULL) THEN
490: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
491: app_exception.raise_exception;
492: END IF;
493:
494: END IF;
701:
702:
703: EXCEPTION WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
709: ||', Invoice Line Type = '|| x_line_type
702:
703: EXCEPTION WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
709: ||', Invoice Line Type = '|| x_line_type
710: ||', Total Match Amount = '||to_char(x_total_amount)
703: EXCEPTION WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
709: ||', Invoice Line Type = '|| x_line_type
710: ||', Total Match Amount = '||to_char(x_total_amount)
711: ||', Row Count = '||to_char(x_row_count)
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
709: ||', Invoice Line Type = '|| x_line_type
710: ||', Total Match Amount = '||to_char(x_total_amount)
711: ||', Row Count = '||to_char(x_row_count)
712: ||', Description = '||x_Description);
709: ||', Invoice Line Type = '|| x_line_type
710: ||', Total Match Amount = '||to_char(x_total_amount)
711: ||', Row Count = '||to_char(x_row_count)
712: ||', Description = '||x_Description);
713: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
714: END IF;
715: --clean up the PL/SQL tables.
716: x_othr_chrg_tab.delete;
717:
1067: AND rsl.shipment_line_id = rcv.rcv_shipment_line_id;
1068:
1069: EXCEPTION WHEN OTHERS THEN
1070: IF (SQLCODE <> -20001) THEN
1071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1074: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1075: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1068:
1069: EXCEPTION WHEN OTHERS THEN
1070: IF (SQLCODE <> -20001) THEN
1071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1074: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1075: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1076: ||', Invoice Line Type = '|| x_line_type
1069: EXCEPTION WHEN OTHERS THEN
1070: IF (SQLCODE <> -20001) THEN
1071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1074: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1075: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1076: ||', Invoice Line Type = '|| x_line_type
1077: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1070: IF (SQLCODE <> -20001) THEN
1071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1074: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1075: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1076: ||', Invoice Line Type = '|| x_line_type
1077: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1078: ||', Amount = '||to_char(x_amount)
1076: ||', Invoice Line Type = '|| x_line_type
1077: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1078: ||', Amount = '||to_char(x_amount)
1079: ||', Base Amount = '||to_char(x_base_amount));
1080: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1081: END IF;
1082: APP_EXCEPTION.RAISE_EXCEPTION;
1083:
1084: END Insert_Invoice_Line;
1487:
1488: Exception
1489: WHEN others then
1490: If (SQLCODE <> -20001) Then
1491: fnd_message.set_name('SQLAP','AP_DEBUG');
1492: fnd_message.set_token('ERROR',SQLERRM);
1493: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1494: fnd_message.set_token('PARAMETERS',
1495: 'X_invoice_id= '||to_char(x_invoice_id)
1488: Exception
1489: WHEN others then
1490: If (SQLCODE <> -20001) Then
1491: fnd_message.set_name('SQLAP','AP_DEBUG');
1492: fnd_message.set_token('ERROR',SQLERRM);
1493: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1494: fnd_message.set_token('PARAMETERS',
1495: 'X_invoice_id= '||to_char(x_invoice_id)
1496: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1489: WHEN others then
1490: If (SQLCODE <> -20001) Then
1491: fnd_message.set_name('SQLAP','AP_DEBUG');
1492: fnd_message.set_token('ERROR',SQLERRM);
1493: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1494: fnd_message.set_token('PARAMETERS',
1495: 'X_invoice_id= '||to_char(x_invoice_id)
1496: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1497: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1490: If (SQLCODE <> -20001) Then
1491: fnd_message.set_name('SQLAP','AP_DEBUG');
1492: fnd_message.set_token('ERROR',SQLERRM);
1493: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1494: fnd_message.set_token('PARAMETERS',
1495: 'X_invoice_id= '||to_char(x_invoice_id)
1496: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1497: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1498: End if;
1493: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1494: fnd_message.set_token('PARAMETERS',
1495: 'X_invoice_id= '||to_char(x_invoice_id)
1496: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1497: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1498: End if;
1499: app_exception.raise_exception;
1500:
1501: