DBA Data[Home] [Help]

APPS.OKE_VERSION_PVT dependencies on FND_MSG_PUB

Line 246: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

242: EXCEPTION
243: WHEN table_not_found THEN
244: NULL;
245: WHEN OTHERS THEN
246: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
247: FND_MESSAGE.set_name('OKE','OKE_VERS_SQL_ERROR');
248: FND_MESSAGE.set_token('NUM', (-1) * sqlcode);
249: FND_MESSAGE.set_token('TABLE', p_table_name);
250: FND_MSG_PUB.add;

Line 250: FND_MSG_PUB.add;

246: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
247: FND_MESSAGE.set_name('OKE','OKE_VERS_SQL_ERROR');
248: FND_MESSAGE.set_token('NUM', (-1) * sqlcode);
249: FND_MESSAGE.set_token('TABLE', p_table_name);
250: FND_MSG_PUB.add;
251: END IF;
252: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,statement);
254: END IF;

Line 425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

421: EXCEPTION
422: WHEN table_not_found THEN
423: NULL;
424: WHEN OTHERS THEN
425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
426: FND_MESSAGE.set_name('OKE','OKE_VERS_SQL_ERROR');
427: FND_MESSAGE.set_token('NUM', sqlcode);
428: FND_MESSAGE.set_token('TABLE', p_table_name);
429: FND_MSG_PUB.add;

Line 429: FND_MSG_PUB.add;

425: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
426: FND_MESSAGE.set_name('OKE','OKE_VERS_SQL_ERROR');
427: FND_MESSAGE.set_token('NUM', sqlcode);
428: FND_MESSAGE.set_token('TABLE', p_table_name);
429: FND_MSG_PUB.add;
430: END IF;
431: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,statement);
433: END IF;

Line 499: FND_MSG_PUB.initialize;

495: --
496: -- Initialize the message table if requested.
497: --
498: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: --
503: -- Get the current version number from OKC

Line 521: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

517:
518: IF cvmv%notfound THEN
519: CLOSE cvmv;
520: ROLLBACK TO version_contract_pvt;
521: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
522: FND_MESSAGE.set_name('OKE','OKE_VERS_INVALID_CONTRACT');
523: FND_MSG_PUB.add;
524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;

Line 523: FND_MSG_PUB.add;

519: CLOSE cvmv;
520: ROLLBACK TO version_contract_pvt;
521: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
522: FND_MESSAGE.set_name('OKE','OKE_VERS_INVALID_CONTRACT');
523: FND_MSG_PUB.add;
524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;

Line 640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

636: --
637: -- Standard call to get message count and if count is 1, get message
638: -- info
639: --
640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
641: , p_data => x_msg_data );
642:
643: TimeStamp('version_contract() >>');
644:

Line 649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO version_contract_pvt;
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
650: , p_data => x_msg_data );
651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: ROLLBACK TO version_contract_pvt;

Line 655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

651:
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: ROLLBACK TO version_contract_pvt;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
656: , p_data => x_msg_data );
657:
658: WHEN OTHERS THEN
659: ROLLBACK TO version_contract_pvt;

Line 661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

657:
658: WHEN OTHERS THEN
659: ROLLBACK TO version_contract_pvt;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
662: FND_MSG_PUB.add_exc_msg
663: ( p_pkg_name => G_PKG_NAME
664: , p_procedure_name => 'VERSION_CONTRACT(' || progress || ')');
665:

Line 662: FND_MSG_PUB.add_exc_msg

658: WHEN OTHERS THEN
659: ROLLBACK TO version_contract_pvt;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
662: FND_MSG_PUB.add_exc_msg
663: ( p_pkg_name => G_PKG_NAME
664: , p_procedure_name => 'VERSION_CONTRACT(' || progress || ')');
665:
666: END IF;

Line 667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

663: ( p_pkg_name => G_PKG_NAME
664: , p_procedure_name => 'VERSION_CONTRACT(' || progress || ')');
665:
666: END IF;
667: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
668: , p_data => x_msg_data );
669:
670:
671: END version_contract;

Line 732: FND_MSG_PUB.initialize;

728: --
729: -- Initialize the message table if requested.
730: --
731: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734: /* bug#4451971
735: --
736: -- First version the current state of the contract

Line 809: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

805: --
806: -- Standard call to get message count and if count is 1, get message
807: -- info
808: --
809: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
810: , p_data => x_msg_data );
811:
812: TimeStamp('restore_contract_version() >>');
813:

Line 818: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

814: EXCEPTION
815: WHEN FND_API.G_EXC_ERROR THEN
816: ROLLBACK TO rstr_contract_version_pvt;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
819: , p_data => x_msg_data );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO rstr_contract_version_pvt;

Line 824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO rstr_contract_version_pvt;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
825: , p_data => x_msg_data );
826:
827: WHEN OTHERS THEN
828: ROLLBACK TO rstr_contract_version_pvt;

Line 830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

826:
827: WHEN OTHERS THEN
828: ROLLBACK TO rstr_contract_version_pvt;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.add_exc_msg
832: ( p_pkg_name => G_PKG_NAME
833: , p_procedure_name => 'RESTORE_CONTRACT_VERSION' );
834:

Line 831: FND_MSG_PUB.add_exc_msg

827: WHEN OTHERS THEN
828: ROLLBACK TO rstr_contract_version_pvt;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
831: FND_MSG_PUB.add_exc_msg
832: ( p_pkg_name => G_PKG_NAME
833: , p_procedure_name => 'RESTORE_CONTRACT_VERSION' );
834:
835: END IF;

Line 836: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

832: ( p_pkg_name => G_PKG_NAME
833: , p_procedure_name => 'RESTORE_CONTRACT_VERSION' );
834:
835: END IF;
836: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
837: , p_data => x_msg_data );
838:
839:
840: END restore_contract_version;