160:
161: WHEN OTHERS THEN
162:
163: IF (SQLCODE <> -20001) THEN
164: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
165: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
167: FND_MESSAGE.SET_TOKEN('PARAMETERS',
168: ' P_invoice_type = ' || P_invoice_type
161: WHEN OTHERS THEN
162:
163: IF (SQLCODE <> -20001) THEN
164: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
165: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
167: FND_MESSAGE.SET_TOKEN('PARAMETERS',
168: ' P_invoice_type = ' || P_invoice_type
169: ||' P_po_header_id = ' || P_po_header_id
162:
163: IF (SQLCODE <> -20001) THEN
164: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
165: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
167: FND_MESSAGE.SET_TOKEN('PARAMETERS',
168: ' P_invoice_type = ' || P_invoice_type
169: ||' P_po_header_id = ' || P_po_header_id
170: ||' P_po_line_id = ' || P_po_line_id
163: IF (SQLCODE <> -20001) THEN
164: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
165: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
167: FND_MESSAGE.SET_TOKEN('PARAMETERS',
168: ' P_invoice_type = ' || P_invoice_type
169: ||' P_po_header_id = ' || P_po_header_id
170: ||' P_po_line_id = ' || P_po_line_id
171: ||' P_line_location_id = ' || P_line_location_id
170: ||' P_po_line_id = ' || P_po_line_id
171: ||' P_line_location_id = ' || P_line_location_id
172: ||' P_po_distribution_id = ' || P_po_distribution_id);
173:
174: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
175: END IF;
176: APP_EXCEPTION.RAISE_EXCEPTION;
177:
178: END Check_Unvalidated_Invoices;