DBA Data[Home] [Help]

APPS.OZF_AP_INTERFACE_PVT dependencies on FND_API

Line 145: x_return_status := FND_API.g_ret_sts_success;

141: ,x_claim_rec.legal_entity_id
142: FROM ozf_claims_all
143: WHERE claim_id = p_claim_id ;
144:
145: x_return_status := FND_API.g_ret_sts_success;
146: EXCEPTION
147: WHEN OTHERS THEN
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
149: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');

Line 152: x_return_status := FND_API.g_ret_sts_unexp_error;

148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
149: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
150: FND_MSG_PUB.add;
151: END IF;
152: x_return_status := FND_API.g_ret_sts_unexp_error;
153: END Query_Claim;
154:
155: PROCEDURE Create_ap_invoice (
156: p_api_version IN NUMBER

Line 157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

153: END Query_Claim;
154:
155: PROCEDURE Create_ap_invoice (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2

Line 158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

154:
155: PROCEDURE Create_ap_invoice (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_data OUT NOCOPY VARCHAR2

Line 159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

155: PROCEDURE Create_ap_invoice (
156: p_api_version IN NUMBER
157: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
158: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
159: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160:
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_data OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER

Line 329: IF NOT FND_API.Compatible_API_Call (

325: SAVEPOINT Create_ap_invoice_PVT;
326:
327:
328: -- Standard call to check for call compatibility.
329: IF NOT FND_API.Compatible_API_Call (
330: l_api_version,
331: p_api_version,
332: l_api_name,
333: G_PKG_NAME)

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: p_api_version,
332: l_api_name,
333: G_PKG_NAME)
334: THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:
338:
339: -- Debug Message

Line 348: IF FND_API.To_Boolean (p_init_msg_list) THEN

344: END IF;
345:
346:
347: --Initialize message list if p_init_msg_list is TRUE.
348: IF FND_API.To_Boolean (p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352:

Line 354: x_return_status := FND_API.G_RET_STS_SUCCESS;

350: END IF;
351:
352:
353: -- Initialize API return status to sucess
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355:
356: -- Query the claim
357: Query_Claim(
358: p_claim_id => p_claim_id

Line 361: IF x_return_status = FND_API.g_ret_sts_error THEN

357: Query_Claim(
358: p_claim_id => p_claim_id
359: ,x_claim_rec => l_claim_rec
360: ,x_return_status => x_return_status);
361: IF x_return_status = FND_API.g_ret_sts_error THEN
362: RAISE FND_API.g_exc_error;
363: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
364: RAISE FND_API.g_exc_unexpected_error;
365: END IF;

Line 362: RAISE FND_API.g_exc_error;

358: p_claim_id => p_claim_id
359: ,x_claim_rec => l_claim_rec
360: ,x_return_status => x_return_status);
361: IF x_return_status = FND_API.g_ret_sts_error THEN
362: RAISE FND_API.g_exc_error;
363: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
364: RAISE FND_API.g_exc_unexpected_error;
365: END IF;
366:

Line 363: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

359: ,x_claim_rec => l_claim_rec
360: ,x_return_status => x_return_status);
361: IF x_return_status = FND_API.g_ret_sts_error THEN
362: RAISE FND_API.g_exc_error;
363: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
364: RAISE FND_API.g_exc_unexpected_error;
365: END IF;
366:
367:

Line 364: RAISE FND_API.g_exc_unexpected_error;

360: ,x_return_status => x_return_status);
361: IF x_return_status = FND_API.g_ret_sts_error THEN
362: RAISE FND_API.g_exc_error;
363: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
364: RAISE FND_API.g_exc_unexpected_error;
365: END IF;
366:
367:
368: l_user_id := NVL(FND_GLOBAL.user_id,-1);

Line 491: ,p_init_msg_list => FND_API.G_FALSE

487:
488: -- get the vendor clearing account from gl api
489: OZF_Gl_Interface_PVT.Get_GL_Account(
490: p_api_version => p_api_version
491: ,p_init_msg_list => FND_API.G_FALSE
492: ,p_commit => FND_API.G_FALSE
493: ,p_validation_level => p_validation_level
494: ,x_return_status => x_return_status
495: ,x_msg_data => x_msg_data

Line 492: ,p_commit => FND_API.G_FALSE

488: -- get the vendor clearing account from gl api
489: OZF_Gl_Interface_PVT.Get_GL_Account(
490: p_api_version => p_api_version
491: ,p_init_msg_list => FND_API.G_FALSE
492: ,p_commit => FND_API.G_FALSE
493: ,p_validation_level => p_validation_level
494: ,x_return_status => x_return_status
495: ,x_msg_data => x_msg_data
496: ,x_msg_count => x_msg_count

Line 501: IF x_return_status = FND_API.g_ret_sts_error THEN

497: ,p_source_id => l_claim_line_rec.claim_line_id
498: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
499: ,p_account_type => 'VEN_CLEARING'
500: ,x_cc_id_tbl => l_cc_id_tbl);
501: IF x_return_status = FND_API.g_ret_sts_error THEN
502: RAISE FND_API.g_exc_error;
503: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
504: RAISE FND_API.g_exc_unexpected_error;
505: END IF;

Line 502: RAISE FND_API.g_exc_error;

498: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
499: ,p_account_type => 'VEN_CLEARING'
500: ,x_cc_id_tbl => l_cc_id_tbl);
501: IF x_return_status = FND_API.g_ret_sts_error THEN
502: RAISE FND_API.g_exc_error;
503: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
504: RAISE FND_API.g_exc_unexpected_error;
505: END IF;
506:

Line 503: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

499: ,p_account_type => 'VEN_CLEARING'
500: ,x_cc_id_tbl => l_cc_id_tbl);
501: IF x_return_status = FND_API.g_ret_sts_error THEN
502: RAISE FND_API.g_exc_error;
503: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
504: RAISE FND_API.g_exc_unexpected_error;
505: END IF;
506:
507: FOR i in 1..l_cc_id_tbl.count LOOP

Line 504: RAISE FND_API.g_exc_unexpected_error;

500: ,x_cc_id_tbl => l_cc_id_tbl);
501: IF x_return_status = FND_API.g_ret_sts_error THEN
502: RAISE FND_API.g_exc_error;
503: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
504: RAISE FND_API.g_exc_unexpected_error;
505: END IF;
506:
507: FOR i in 1..l_cc_id_tbl.count LOOP
508: l_vendor_clearing_account := l_cc_id_tbl(i).code_combination_id;

Line 676: IF FND_API.To_Boolean ( p_commit ) THEN

672: WHERE claim_id = p_claim_id;
673: END IF; -- BUG 4754076 END.
674:
675: --Standard check of commit
676: IF FND_API.To_Boolean ( p_commit ) THEN
677: COMMIT WORK;
678: END IF;
679:
680:

Line 690: p_encoded => FND_API.G_FALSE,

686: END IF;
687:
688: --Standard call to get message count and if count=1, get the message
689: FND_MSG_PUB.Count_And_Get (
690: p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count,
692: p_data => x_msg_data
693: );
694: EXCEPTION

Line 695: WHEN FND_API.G_EXC_ERROR THEN

691: p_count => x_msg_count,
692: p_data => x_msg_data
693: );
694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO Create_ap_invoice_PVT;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: );
694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN
696: ROLLBACK TO Create_ap_invoice_PVT;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,

Line 700: p_encoded => FND_API.G_FALSE,

696: ROLLBACK TO Create_ap_invoice_PVT;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO Create_ap_invoice_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (

Line 706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

702: p_data => x_msg_data
703: );
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: ROLLBACK TO Create_ap_invoice_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,

Line 709: p_encoded => FND_API.G_FALSE,

705: ROLLBACK TO Create_ap_invoice_PVT;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: -- Standard call to get message count and if count=1, get the message
708: FND_MSG_PUB.Count_And_Get (
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,
711: p_data => x_msg_data
712: );
713: WHEN OTHERS THEN

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: p_data => x_msg_data
712: );
713: WHEN OTHERS THEN
714: ROLLBACK TO Create_ap_invoice_PVT;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
717: THEN
718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
719: END IF;

Line 722: p_encoded => FND_API.G_FALSE,

718: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
719: END IF;
720: -- Standard call to get message count and if count=1, get the message
721: FND_MSG_PUB.Count_And_Get (
722: p_encoded => FND_API.G_FALSE,
723: p_count => x_msg_count,
724: p_data => x_msg_data
725: );
726: END Create_ap_invoice;