DBA Data[Home] [Help]

APPS.AP_WEB_UTIL_PKG dependencies on FND_API

Line 132: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

128: SAVEPOINT NotifyEmployeeOnPayment;
129: LogStatement('NotifyEmployeeOnPayment', 'Savepoint is established');
130:
131: -- Initialize API return status to success
132: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
133:
134: -- START OF BODY OF API
135: LogStatement('NotifyEmployeeOnPayment', 'Processing to send Employee Notifications...');
136: LogStatement('NotifyEmployeeOnPayment', 'Input Data: ');

Line 339: WHEN FND_API.G_EXC_ERROR THEN

335: END LOOP;
336: close get_invoice_cur;
337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO NotifyEmployeeOnPayment;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );

Line 341: p_return_status := FND_API.G_RET_STS_ERROR;

337:
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO NotifyEmployeeOnPayment;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO NotifyEmployeeOnPayment;

Line 343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );

339: WHEN FND_API.G_EXC_ERROR THEN
340: ROLLBACK TO NotifyEmployeeOnPayment;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO NotifyEmployeeOnPayment;
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

340: ROLLBACK TO NotifyEmployeeOnPayment;
341: p_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO NotifyEmployeeOnPayment;
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
348: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_UNEXPECTED_ERROR');

Line 346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
343: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_ERROR' );
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO NotifyEmployeeOnPayment;
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
348: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_UNEXPECTED_ERROR');
349: WHEN OTHERS THEN
350: ROLLBACK TO NotifyEmployeeOnPayment;

Line 348: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_UNEXPECTED_ERROR');

344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO NotifyEmployeeOnPayment;
346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
348: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_UNEXPECTED_ERROR');
349: WHEN OTHERS THEN
350: ROLLBACK TO NotifyEmployeeOnPayment;
351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);

Line 351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
348: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due FND_API.G_EXC_UNEXPECTED_ERROR');
349: WHEN OTHERS THEN
350: ROLLBACK TO NotifyEmployeeOnPayment;
351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count, p_data => p_msg_data);
353: LogStatement('FND_LOG.LEVEL_UNEXPECTED', 'Rollbacked due others Exception');
354:
355: END NotifyEmployeeOnPayment;