339:
340: Exception
341: WHEN Tax_Exception Then
342:
343: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
344: IF l_error_code IS NOT NULL THEN
345: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
346: ELSE
347: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
341: WHEN Tax_Exception Then
342:
343: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
344: IF l_error_code IS NOT NULL THEN
345: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
346: ELSE
347: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
348: END IF;
349: APP_EXCEPTION.RAISE_EXCEPTION;
343: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
344: IF l_error_code IS NOT NULL THEN
345: FND_MESSAGE.SET_TOKEN('ERROR', l_error_code);
346: ELSE
347: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
348: END IF;
349: APP_EXCEPTION.RAISE_EXCEPTION;
350:
351: WHEN others then
349: APP_EXCEPTION.RAISE_EXCEPTION;
350:
351: WHEN others then
352: If (SQLCODE <> -20001) Then
353: fnd_message.set_name('SQLAP','AP_DEBUG');
354: fnd_message.set_token('ERROR',SQLERRM);
355: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
356: fnd_message.set_token('PARAMETERS',
357: 'X_invoice_id= '||to_char(x_invoice_id)
350:
351: WHEN others then
352: If (SQLCODE <> -20001) Then
353: fnd_message.set_name('SQLAP','AP_DEBUG');
354: fnd_message.set_token('ERROR',SQLERRM);
355: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
356: fnd_message.set_token('PARAMETERS',
357: 'X_invoice_id= '||to_char(x_invoice_id)
358: ||'X_total_amount= '||to_char(x_total_amount)
351: WHEN others then
352: If (SQLCODE <> -20001) Then
353: fnd_message.set_name('SQLAP','AP_DEBUG');
354: fnd_message.set_token('ERROR',SQLERRM);
355: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
356: fnd_message.set_token('PARAMETERS',
357: 'X_invoice_id= '||to_char(x_invoice_id)
358: ||'X_total_amount= '||to_char(x_total_amount)
359: ||'X_prorate_flag= '||x_prorate_flag
352: If (SQLCODE <> -20001) Then
353: fnd_message.set_name('SQLAP','AP_DEBUG');
354: fnd_message.set_token('ERROR',SQLERRM);
355: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
356: fnd_message.set_token('PARAMETERS',
357: 'X_invoice_id= '||to_char(x_invoice_id)
358: ||'X_total_amount= '||to_char(x_total_amount)
359: ||'X_prorate_flag= '||x_prorate_flag
360: ||'X_account_id= '||to_char(x_account_id)
360: ||'X_account_id= '||to_char(x_account_id)
361: ||'X_line_type= '||x_line_type
362: ||'X_row_count= '||to_char(x_row_count)
363: ||'X_description= '||x_description);
364: fnd_message.set_token('DEBUG_INFO',l_debug_info);
365: End if;
366: app_exception.raise_exception;
367:
368:
452: p_period_name => g_period_name,
453: p_gl_date => g_accounting_date);
454:
455: IF (g_accounting_date IS NULL) THEN
456: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
457: app_exception.raise_exception;
458: END IF;
459:
460: END IF;
637:
638:
639: EXCEPTION WHEN OTHERS THEN
640: IF (SQLCODE <> -20001) THEN
641: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
642: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
643: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
644: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
645: ||', Invoice Line Type = '|| x_line_type
638:
639: EXCEPTION WHEN OTHERS THEN
640: IF (SQLCODE <> -20001) THEN
641: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
642: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
643: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
644: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
645: ||', Invoice Line Type = '|| x_line_type
646: ||', Total Match Amount = '||to_char(x_total_amount)
639: EXCEPTION WHEN OTHERS THEN
640: IF (SQLCODE <> -20001) THEN
641: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
642: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
643: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
644: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
645: ||', Invoice Line Type = '|| x_line_type
646: ||', Total Match Amount = '||to_char(x_total_amount)
647: ||', Row Count = '||to_char(x_row_count)
640: IF (SQLCODE <> -20001) THEN
641: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
642: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
643: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
644: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
645: ||', Invoice Line Type = '|| x_line_type
646: ||', Total Match Amount = '||to_char(x_total_amount)
647: ||', Row Count = '||to_char(x_row_count)
648: ||', Description = '||x_Description);
645: ||', Invoice Line Type = '|| x_line_type
646: ||', Total Match Amount = '||to_char(x_total_amount)
647: ||', Row Count = '||to_char(x_row_count)
648: ||', Description = '||x_Description);
649: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
650: END IF;
651: --clean up the PL/SQL tables.
652: x_othr_chrg_tab.delete;
653:
1001: AND rsl.shipment_line_id = rcv.rcv_shipment_line_id;
1002:
1003: EXCEPTION WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1008: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1009: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1002:
1003: EXCEPTION WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1008: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1009: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1010: ||', Invoice Line Type = '|| x_line_type
1003: EXCEPTION WHEN OTHERS THEN
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1008: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1009: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1010: ||', Invoice Line Type = '|| x_line_type
1011: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1004: IF (SQLCODE <> -20001) THEN
1005: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1006: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1007: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1008: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
1009: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
1010: ||', Invoice Line Type = '|| x_line_type
1011: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1012: ||', Amount = '||to_char(x_amount)
1010: ||', Invoice Line Type = '|| x_line_type
1011: ||', Rcv Transaction id ='||to_char(x_rcv_transaction_id)
1012: ||', Amount = '||to_char(x_amount)
1013: ||', Base Amount = '||to_char(x_base_amount));
1014: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1015: END IF;
1016: APP_EXCEPTION.RAISE_EXCEPTION;
1017:
1018: END Insert_Invoice_Line;
1398:
1399: Exception
1400: WHEN others then
1401: If (SQLCODE <> -20001) Then
1402: fnd_message.set_name('SQLAP','AP_DEBUG');
1403: fnd_message.set_token('ERROR',SQLERRM);
1404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1405: fnd_message.set_token('PARAMETERS',
1406: 'X_invoice_id= '||to_char(x_invoice_id)
1399: Exception
1400: WHEN others then
1401: If (SQLCODE <> -20001) Then
1402: fnd_message.set_name('SQLAP','AP_DEBUG');
1403: fnd_message.set_token('ERROR',SQLERRM);
1404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1405: fnd_message.set_token('PARAMETERS',
1406: 'X_invoice_id= '||to_char(x_invoice_id)
1407: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1400: WHEN others then
1401: If (SQLCODE <> -20001) Then
1402: fnd_message.set_name('SQLAP','AP_DEBUG');
1403: fnd_message.set_token('ERROR',SQLERRM);
1404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1405: fnd_message.set_token('PARAMETERS',
1406: 'X_invoice_id= '||to_char(x_invoice_id)
1407: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1408: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1401: If (SQLCODE <> -20001) Then
1402: fnd_message.set_name('SQLAP','AP_DEBUG');
1403: fnd_message.set_token('ERROR',SQLERRM);
1404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1405: fnd_message.set_token('PARAMETERS',
1406: 'X_invoice_id= '||to_char(x_invoice_id)
1407: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1408: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1409: End if;
1404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
1405: fnd_message.set_token('PARAMETERS',
1406: 'X_invoice_id= '||to_char(x_invoice_id)
1407: ||'X_invoice_line_number =' ||to_char(x_invoice_line_number));
1408: fnd_message.set_token('DEBUG_INFO',l_debug_info);
1409: End if;
1410: app_exception.raise_exception;
1411:
1412: