DBA Data[Home] [Help]

APPS.OZF_AP_INTERFACE_PVT dependencies on FND_API

Line 147: x_return_status := FND_API.g_ret_sts_success;

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

Line 154: x_return_status := FND_API.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

Line 353: IF NOT FND_API.Compatible_API_Call (

349: SAVEPOINT Create_ap_invoice_PVT;
350:
351:
352: -- Standard call to check for call compatibility.
353: IF NOT FND_API.Compatible_API_Call (
354: l_api_version,
355: p_api_version,
356: l_api_name,
357: G_PKG_NAME)

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: p_api_version,
356: l_api_name,
357: G_PKG_NAME)
358: THEN
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361:
362:
363: -- Debug Message

Line 372: IF FND_API.To_Boolean (p_init_msg_list) THEN

368: END IF;
369:
370:
371: --Initialize message list if p_init_msg_list is TRUE.
372: IF FND_API.To_Boolean (p_init_msg_list) THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:
376:

Line 378: x_return_status := FND_API.G_RET_STS_SUCCESS;

374: END IF;
375:
376:
377: -- Initialize API return status to sucess
378: x_return_status := FND_API.G_RET_STS_SUCCESS;
379:
380: -- Query the claim
381: Query_Claim(
382: p_claim_id => p_claim_id

Line 385: IF x_return_status = FND_API.g_ret_sts_error THEN

381: Query_Claim(
382: p_claim_id => p_claim_id
383: ,x_claim_rec => l_claim_rec
384: ,x_return_status => x_return_status);
385: IF x_return_status = FND_API.g_ret_sts_error THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;

Line 386: RAISE FND_API.g_exc_error;

382: p_claim_id => p_claim_id
383: ,x_claim_rec => l_claim_rec
384: ,x_return_status => x_return_status);
385: IF x_return_status = FND_API.g_ret_sts_error THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:

Line 387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

383: ,x_claim_rec => l_claim_rec
384: ,x_return_status => x_return_status);
385: IF x_return_status = FND_API.g_ret_sts_error THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:
391:

Line 388: RAISE FND_API.g_exc_unexpected_error;

384: ,x_return_status => x_return_status);
385: IF x_return_status = FND_API.g_ret_sts_error THEN
386: RAISE FND_API.g_exc_error;
387: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
388: RAISE FND_API.g_exc_unexpected_error;
389: END IF;
390:
391:
392: l_user_id := NVL(FND_GLOBAL.user_id,-1);

Line 541: ,p_init_msg_list => FND_API.G_FALSE

537:
538: -- get the vendor clearing account from gl api
539: OZF_Gl_Interface_PVT.Get_GL_Account(
540: p_api_version => p_api_version
541: ,p_init_msg_list => FND_API.G_FALSE
542: ,p_commit => FND_API.G_FALSE
543: ,p_validation_level => p_validation_level
544: ,x_return_status => x_return_status
545: ,x_msg_data => x_msg_data

Line 542: ,p_commit => FND_API.G_FALSE

538: -- get the vendor clearing account from gl api
539: OZF_Gl_Interface_PVT.Get_GL_Account(
540: p_api_version => p_api_version
541: ,p_init_msg_list => FND_API.G_FALSE
542: ,p_commit => FND_API.G_FALSE
543: ,p_validation_level => p_validation_level
544: ,x_return_status => x_return_status
545: ,x_msg_data => x_msg_data
546: ,x_msg_count => x_msg_count

Line 551: IF x_return_status = FND_API.g_ret_sts_error THEN

547: ,p_source_id => l_claim_line_rec.claim_line_id
548: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
549: ,p_account_type => 'VEN_CLEARING'
550: ,x_cc_id_tbl => l_cc_id_tbl);
551: IF x_return_status = FND_API.g_ret_sts_error THEN
552: RAISE FND_API.g_exc_error;
553: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
554: RAISE FND_API.g_exc_unexpected_error;
555: END IF;

Line 552: RAISE FND_API.g_exc_error;

548: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
549: ,p_account_type => 'VEN_CLEARING'
550: ,x_cc_id_tbl => l_cc_id_tbl);
551: IF x_return_status = FND_API.g_ret_sts_error THEN
552: RAISE FND_API.g_exc_error;
553: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
554: RAISE FND_API.g_exc_unexpected_error;
555: END IF;
556:

Line 553: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

549: ,p_account_type => 'VEN_CLEARING'
550: ,x_cc_id_tbl => l_cc_id_tbl);
551: IF x_return_status = FND_API.g_ret_sts_error THEN
552: RAISE FND_API.g_exc_error;
553: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
554: RAISE FND_API.g_exc_unexpected_error;
555: END IF;
556:
557: FOR i in 1..l_cc_id_tbl.count LOOP

Line 554: RAISE FND_API.g_exc_unexpected_error;

550: ,x_cc_id_tbl => l_cc_id_tbl);
551: IF x_return_status = FND_API.g_ret_sts_error THEN
552: RAISE FND_API.g_exc_error;
553: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
554: RAISE FND_API.g_exc_unexpected_error;
555: END IF;
556:
557: FOR i in 1..l_cc_id_tbl.count LOOP
558: l_vendor_clearing_account := l_cc_id_tbl(i).code_combination_id;

Line 759: IF FND_API.To_Boolean ( p_commit ) THEN

755: WHERE claim_id = p_claim_id;
756: END IF; -- BUG 4754076 END.
757:
758: --Standard check of commit
759: IF FND_API.To_Boolean ( p_commit ) THEN
760: COMMIT WORK;
761: END IF;
762:
763:

Line 773: p_encoded => FND_API.G_FALSE,

769: END IF;
770:
771: --Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: EXCEPTION

Line 778: WHEN FND_API.G_EXC_ERROR THEN

774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR THEN
779: ROLLBACK TO Create_ap_invoice_PVT;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: );
777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR THEN
779: ROLLBACK TO Create_ap_invoice_PVT;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,

Line 783: p_encoded => FND_API.G_FALSE,

779: ROLLBACK TO Create_ap_invoice_PVT;
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO Create_ap_invoice_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

785: p_data => x_msg_data
786: );
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO Create_ap_invoice_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,

Line 792: p_encoded => FND_API.G_FALSE,

788: ROLLBACK TO Create_ap_invoice_PVT;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796: WHEN OTHERS THEN

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: p_data => x_msg_data
795: );
796: WHEN OTHERS THEN
797: ROLLBACK TO Create_ap_invoice_PVT;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
800: THEN
801: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
802: END IF;

Line 805: p_encoded => FND_API.G_FALSE,

801: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
802: END IF;
803: -- Standard call to get message count and if count=1, get the message
804: FND_MSG_PUB.Count_And_Get (
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );
809: END Create_ap_invoice;