[Home] [Help]
160: ||', P_calling_sequence = ' || l_curr_calling_sequence);
161: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
162: END IF;
163:
164: APP_EXCEPTION.RAISE_EXCEPTION;
165:
166: END recreate_pay_scheds;
167:
168: PROCEDURE get_approver(itemtype IN VARCHAR2,
234: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
236: l_api_name,l_debug_info);
237: END IF;
238: APP_EXCEPTION.RAISE_EXCEPTION;
239: END IF;
240: IF l_next_approver.person_id is null THEN /*no approver on the list*/
241: -- added for bug 8671976
242: update ap_holds_all
6083: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6084: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6085: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6086: END IF;
6087: APP_EXCEPTION.RAISE_EXCEPTION;
6088: END create_invapp_process;
6089:
6090: FUNCTION Stop_Approval(
6091: p_invoice_id IN NUMBER,
6253: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6254: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6256: END IF;
6257: APP_EXCEPTION.RAISE_EXCEPTION;
6258:
6259: END Stop_Approval;
6260: PROCEDURE process_single_line_response(p_invoice_id IN NUMBER,
6261: p_line_number IN NUMBER,
7043: END IF;
7044: RETURN(FALSE);
7045: EXCEPTION
7046: WHEN OTHERS THEN
7047: APP_EXCEPTION.RAISE_EXCEPTION;
7048: END IS_INV_NEGOTIATED;
7049:
7050: /* Bug 5590138. Bring to from old apiawleb.pls */
7051:
7117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7121: APP_EXCEPTION.RAISE_EXCEPTION;
7122: END;
7123:
7124: END IF;
7125:
7334: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7335: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7336: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7337: END IF;
7338: APP_EXCEPTION.RAISE_EXCEPTION;
7339:
7340: END Get_All_Approvers;
7341:
7342: /*This function terminates any invoice approval workflow processes
7483: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7484: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7485: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7486: END IF;
7487: APP_EXCEPTION.RAISE_EXCEPTION;
7488:
7489: END Terminate_Approval;
7490: PROCEDURE wakeup_lineapproval_process( p_invoice_id IN NUMBER,
7491: p_itemkey IN VARCHAR2) IS
7672: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7673: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7674: l_api_name,l_debug_info);
7675: END IF ;
7676: APP_EXCEPTION.RAISE_EXCEPTION;
7677: END approve_button;
7678:
7679: --Bug 8689391. Added parameter processInstanceLabel to procedure rejectButton.
7680: PROCEDURE reject_button( p_itemkey IN VARCHAR2,
8210: WHEN OTHERS THEN
8211: l_debug_info := 'Invoice is in lock. Please try later';
8212: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
8213: l_error_message := FND_MESSAGE.Get;
8214: APP_EXCEPTION.RAISE_EXCEPTION;
8215: END;
8216: -- Bug 5037108 Ends
8217:
8218: UPDATE AP_INVOICES
8588: WHEN OTHERS THEN
8589: l_debug_info := 'Invoice is in lock. Please try later';
8590: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
8591: l_error_message := FND_MESSAGE.Get;
8592: APP_EXCEPTION.RAISE_EXCEPTION;
8593: END;
8594: -- Bug 5037108 Ends
8595:
8596: UPDATE AP_INVOICES
8792:
8793: EXCEPTION
8794: WHEN OTHERS THEN
8795: fnd_file.put_line(FND_FILE.LOG,'Error Occurred in dynamic sql execution '||SQLERRM);
8796: APP_EXCEPTION.RAISE_EXCEPTION;
8797: END;
8798: END Dynamic_sql_execute;
8799:
8800: