2520: (l_total_docs_count <> l_iby_docs_count) THEN
2521:
2522: x_return_status := FND_API.G_RET_STS_ERROR;
2523:
2524: FND_MESSAGE.set_name('SQLAP', 'AP_IBY_PMT_MISMATCH');
2525: FND_MSG_PUB.ADD;
2526: FND_MSG_PUB.COUNT_AND_GET(
2527: p_count => x_msg_count,
2528: p_data => x_msg_data
2539: EXCEPTION
2540:
2541: WHEN SUBSCRIBE_EXCEPTION THEN
2542:
2543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2544: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2546: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2547: APP_EXCEPTION.RAISE_EXCEPTION;
2540:
2541: WHEN SUBSCRIBE_EXCEPTION THEN
2542:
2543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2544: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2546: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2547: APP_EXCEPTION.RAISE_EXCEPTION;
2548:
2541: WHEN SUBSCRIBE_EXCEPTION THEN
2542:
2543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2544: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2546: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2547: APP_EXCEPTION.RAISE_EXCEPTION;
2548:
2549: WHEN OTHERS THEN
2542:
2543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2544: FND_MESSAGE.SET_TOKEN('ERROR',l_msg_data);
2545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_current_calling_sequence);
2546: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2547: APP_EXCEPTION.RAISE_EXCEPTION;
2548:
2549: WHEN OTHERS THEN
2550: IF (SQLCODE <> -20001) THEN
2547: APP_EXCEPTION.RAISE_EXCEPTION;
2548:
2549: WHEN OTHERS THEN
2550: IF (SQLCODE <> -20001) THEN
2551: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2554: FND_MESSAGE.set_TOKEN('PARAMETERS',
2555: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2548:
2549: WHEN OTHERS THEN
2550: IF (SQLCODE <> -20001) THEN
2551: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2554: FND_MESSAGE.set_TOKEN('PARAMETERS',
2555: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2556: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2549: WHEN OTHERS THEN
2550: IF (SQLCODE <> -20001) THEN
2551: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2554: FND_MESSAGE.set_TOKEN('PARAMETERS',
2555: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2556: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2557: END IF;
2550: IF (SQLCODE <> -20001) THEN
2551: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
2552: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2554: FND_MESSAGE.set_TOKEN('PARAMETERS',
2555: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2556: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2557: END IF;
2558: APP_EXCEPTION.RAISE_EXCEPTION;
2552: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
2553: FND_MESSAGE.set_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence);
2554: FND_MESSAGE.set_TOKEN('PARAMETERS',
2555: 'Complted Payments Group id = ' || to_char(p_completed_pmts_group_id));
2556: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
2557: END IF;
2558: APP_EXCEPTION.RAISE_EXCEPTION;
2559:
2560: