DBA Data[Home] [Help]

APPS.OZF_AUTO_WRITEOFF_PVT dependencies on FND_API

Line 41: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS ;

37: IS
38:
39: -- Local Variable Declaration
40: l_retcode NUMBER := 0;
41: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS ;
42: l_msg_count NUMBER;
43: l_msg_Data VARCHAR2(2000);
44: l_object_version NUMBER(9);
45: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

Line 228: ,p_init_msg_list => FND_API.g_false

224: -- ************************************************************************************
225: --Call OZF_CLAIM_PVT.Update_Claim to change the status to CLOSE.
226: OZF_CLAIM_PVT.Update_Claim (
227: p_api_version => 1.0
228: ,p_init_msg_list => FND_API.g_false
229: ,p_commit => FND_API.g_false
230: ,p_validation_level => FND_API.g_valid_level_full
231: ,x_return_status => l_return_status
232: ,x_msg_data => l_msg_data

Line 229: ,p_commit => FND_API.g_false

225: --Call OZF_CLAIM_PVT.Update_Claim to change the status to CLOSE.
226: OZF_CLAIM_PVT.Update_Claim (
227: p_api_version => 1.0
228: ,p_init_msg_list => FND_API.g_false
229: ,p_commit => FND_API.g_false
230: ,p_validation_level => FND_API.g_valid_level_full
231: ,x_return_status => l_return_status
232: ,x_msg_data => l_msg_data
233: ,x_msg_count => l_msg_count

Line 230: ,p_validation_level => FND_API.g_valid_level_full

226: OZF_CLAIM_PVT.Update_Claim (
227: p_api_version => 1.0
228: ,p_init_msg_list => FND_API.g_false
229: ,p_commit => FND_API.g_false
230: ,p_validation_level => FND_API.g_valid_level_full
231: ,x_return_status => l_return_status
232: ,x_msg_data => l_msg_data
233: ,x_msg_count => l_msg_count
234: ,p_claim => l_claim_rec

Line 239: IF l_return_status = FND_API.g_ret_sts_error THEN

235: ,p_event => 'UPDATE'
236: ,p_mode => 'AUTO'
237: ,x_object_version_number => l_object_version
238: );
239: IF l_return_status = FND_API.g_ret_sts_error THEN
240: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
241: ROLLBACK TO Populate_Auto_Writeoff_Data;
242: --RAISE FND_API.g_exc_error;
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

Line 242: --RAISE FND_API.g_exc_error;

238: );
239: IF l_return_status = FND_API.g_ret_sts_error THEN
240: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
241: ROLLBACK TO Populate_Auto_Writeoff_Data;
242: --RAISE FND_API.g_exc_error;
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
245: OZF_UTILITY_PVT.write_conc_log;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

242: --RAISE FND_API.g_exc_error;
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
245: OZF_UTILITY_PVT.write_conc_log;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
248: ROLLBACK TO Populate_Auto_Writeoff_Data;
249: --RAISE FND_API.g_exc_unexpected_error;
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

Line 249: --RAISE FND_API.g_exc_unexpected_error;

245: OZF_UTILITY_PVT.write_conc_log;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
248: ROLLBACK TO Populate_Auto_Writeoff_Data;
249: --RAISE FND_API.g_exc_unexpected_error;
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
252: OZF_UTILITY_PVT.write_conc_log;
253: ELSE

Line 287: WHEN FND_API.g_exc_error THEN

283: END LOOP;
284: END IF;
285:
286: EXCEPTION
287: WHEN FND_API.g_exc_error THEN
288: ROLLBACK TO Populate_Auto_Writeoff_Data;
289: OZF_UTILITY_PVT.write_conc_log;
290: ERRBUF := l_msg_data;
291: RETCODE := 2;

Line 292: WHEN FND_API.g_exc_unexpected_error THEN

288: ROLLBACK TO Populate_Auto_Writeoff_Data;
289: OZF_UTILITY_PVT.write_conc_log;
290: ERRBUF := l_msg_data;
291: RETCODE := 2;
292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO Populate_Auto_Writeoff_Data;
294: OZF_UTILITY_PVT.write_conc_log;
295: ERRBUF := l_msg_data;
296: RETCODE := 2;