eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_TRADE_PROFILE_PVT dependencies on FND_MSG_PUB

Line 18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

14: -- ===============================================================
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Trade_Profile_PVT';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvctpb.pls';
17:
18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19:
20: CURSOR g_functional_currency_code_csr IS
21: SELECT gs.currency_code
22: FROM gl_sets_of_books gs,

Line 47: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

43: OPEN c_trade;
44: FETCH c_trade INTO l_trade_profile_rec;
45: IF c_trade%NOTFOUND THEN
46: CLOSE c_trade;
47: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
48: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PROFILE_MISSING');
49: FND_MSG_PUB.add;
50: END IF;
51: RAISE FND_API.g_exc_error;

Line 49: FND_MSG_PUB.add;

45: IF c_trade%NOTFOUND THEN
46: CLOSE c_trade;
47: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
48: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PROFILE_MISSING');
49: FND_MSG_PUB.add;
50: END IF;
51: RAISE FND_API.g_exc_error;
52: END IF;
53: CLOSE c_trade;

Line 407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: END populate_defaults;

Line 409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

405: WHEN OTHERS THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: END populate_defaults;
412: --------------------------------------------------------------------------------
413: PROCEDURE Create_Trade_Profile(

Line 482: FND_MSG_PUB.initialize;

478:
479: -- Initialize message list if p_init_msg_list is set to TRUE.
480: IF FND_API.to_Boolean( p_init_msg_list )
481: THEN
482: FND_MSG_PUB.initialize;
483: END IF;
484: -- Initialize API return status to SUCCESS
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486: -- Local variable initialization

Line 508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

504: -- Validate Environment
505: -- =========================================================================
506: IF FND_GLOBAL.User_Id IS NULL
507: THEN
508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
509: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
510: FND_MSG_PUB.add;
511: END IF;
512: RAISE FND_API.G_EXC_ERROR;

Line 510: FND_MSG_PUB.add;

506: IF FND_GLOBAL.User_Id IS NULL
507: THEN
508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
509: FND_MESSAGE.set_name('OZF', 'OZF_USER_PROFILE_MISSING');
510: FND_MSG_PUB.add;
511: END IF;
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:

Line 528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

524: END IF;
525: IF l_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR
526: l_trade_profile_rec.cust_account_id IS NULL
527: THEN
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
529: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_MISSING');
530: FND_MSG_PUB.add;
531: END IF;
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 530: FND_MSG_PUB.add;

526: l_trade_profile_rec.cust_account_id IS NULL
527: THEN
528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
529: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_MISSING');
530: FND_MSG_PUB.add;
531: END IF;
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: ELSE
534: OPEN c_party_id(l_trade_profile_rec.cust_account_id);

Line 647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

643: );
644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
648: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
649: FND_MSG_PUB.add;
650: END IF;
651:

Line 649: FND_MSG_PUB.add;

645: EXCEPTION
646: WHEN OTHERS THEN
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
648: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');
649: FND_MSG_PUB.add;
650: END IF;
651:
652: RAISE FND_API.G_EXC_ERROR;
653: END;

Line 670: FND_MSG_PUB.Count_And_Get

666: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
667: END IF;
668:
669: -- Standard call to get message count and if count is 1, get message info.
670: FND_MSG_PUB.Count_And_Get
671: (p_count => x_msg_count,
672: p_data => x_msg_data
673: );
674:

Line 678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

674:
675: EXCEPTION
676: WHEN OZF_Utility_PVT.resource_locked THEN
677: x_return_status := FND_API.g_ret_sts_error;
678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
679: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
680: FND_MSG_PUB.add;
681: END IF;
682: WHEN FND_API.G_EXC_ERROR THEN

Line 680: FND_MSG_PUB.add;

676: WHEN OZF_Utility_PVT.resource_locked THEN
677: x_return_status := FND_API.g_ret_sts_error;
678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
679: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
680: FND_MSG_PUB.add;
681: END IF;
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO CREATE_Trade_Profile_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 686: FND_MSG_PUB.Count_And_Get (

682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO CREATE_Trade_Profile_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: -- Standard call to get message count and if count=1, get the message
686: FND_MSG_PUB.Count_And_Get (
687: p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data
690: );

Line 695: FND_MSG_PUB.Count_And_Get (

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

Line 703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

699: );
700: WHEN OTHERS THEN
701: ROLLBACK TO CREATE_Trade_Profile_PVT;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
707: -- Standard call to get message count and if count=1, get the message

Line 705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

701: ROLLBACK TO CREATE_Trade_Profile_PVT;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
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,

Line 708: FND_MSG_PUB.Count_And_Get (

704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
706: END IF;
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: );

Line 785: FND_MSG_PUB.initialize;

781: END IF;
782: -- Initialize message list if p_init_msg_list is set to TRUE.
783: IF FND_API.to_Boolean( p_init_msg_list )
784: THEN
785: FND_MSG_PUB.initialize;
786: END IF;
787: -- Debug Message
788: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
789: -- Initialize API return status to SUCCESS

Line 800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

796: END IF;
797: OPEN c_trade;
798: FETCH c_trade INTO l_ref_trade_profile_rec;
799: IF ( c_trade%NOTFOUND) THEN
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
801: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
802: FND_MSG_PUB.add;
803: END IF;
804: RAISE FND_API.G_EXC_ERROR;

Line 802: FND_MSG_PUB.add;

798: FETCH c_trade INTO l_ref_trade_profile_rec;
799: IF ( c_trade%NOTFOUND) THEN
800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
801: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
802: FND_MSG_PUB.add;
803: END IF;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: CLOSE c_trade;

Line 814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

810: END IF;
811:
812: IF (l_tar_trade_profile_rec.object_version_number is NULL or
813: l_tar_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
815: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
816: FND_MSG_PUB.add;
817: END IF;
818: raise FND_API.G_EXC_ERROR;

Line 816: FND_MSG_PUB.add;

812: IF (l_tar_trade_profile_rec.object_version_number is NULL or
813: l_tar_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
814: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
815: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
816: FND_MSG_PUB.add;
817: END IF;
818: raise FND_API.G_EXC_ERROR;
819: End if;
820:

Line 982: FND_MSG_PUB.Count_And_Get

978: IF g_debug THEN
979: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
980: END IF;
981: -- Standard call to get message count and if count is 1, get message info.
982: FND_MSG_PUB.Count_And_Get
983: (p_count => x_msg_count,
984: p_data => x_msg_data
985: );
986: EXCEPTION

Line 989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

985: );
986: EXCEPTION
987: WHEN OZF_Utility_PVT.resource_locked THEN
988: x_return_status := FND_API.g_ret_sts_error;
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
991: FND_MSG_PUB.add;
992: END IF;
993: WHEN FND_API.G_EXC_ERROR THEN

Line 991: FND_MSG_PUB.add;

987: WHEN OZF_Utility_PVT.resource_locked THEN
988: x_return_status := FND_API.g_ret_sts_error;
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
991: FND_MSG_PUB.add;
992: END IF;
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO UPDATE_Trade_Profile_PVT;
995: x_return_status := FND_API.G_RET_STS_ERROR;

Line 997: FND_MSG_PUB.Count_And_Get (

993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO UPDATE_Trade_Profile_PVT;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: -- Standard call to get message count and if count=1, get the message
997: FND_MSG_PUB.Count_And_Get (
998: p_encoded => FND_API.G_FALSE,
999: p_count => x_msg_count,
1000: p_data => x_msg_data
1001: );

Line 1006: FND_MSG_PUB.Count_And_Get (

1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO UPDATE_Trade_Profile_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: -- Standard call to get message count and if count=1, get the message
1006: FND_MSG_PUB.Count_And_Get (
1007: p_encoded => FND_API.G_FALSE,
1008: p_count => x_msg_count,
1009: p_data => x_msg_data
1010: );

Line 1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1010: );
1011: WHEN OTHERS THEN
1012: ROLLBACK TO UPDATE_Trade_Profile_PVT;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1017: END IF;
1018: -- Standard call to get message count and if count=1, get the message

Line 1016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1012: ROLLBACK TO UPDATE_Trade_Profile_PVT;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1017: END IF;
1018: -- Standard call to get message count and if count=1, get the message
1019: FND_MSG_PUB.Count_And_Get (
1020: p_encoded => FND_API.G_FALSE,

Line 1019: FND_MSG_PUB.Count_And_Get (

1015: THEN
1016: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1017: END IF;
1018: -- Standard call to get message count and if count=1, get the message
1019: FND_MSG_PUB.Count_And_Get (
1020: p_encoded => FND_API.G_FALSE,
1021: p_count => x_msg_count,
1022: p_data => x_msg_data
1023: );

Line 1057: FND_MSG_PUB.initialize;

1053: END IF;
1054: -- Initialize message list if p_init_msg_list is set to TRUE.
1055: IF FND_API.to_Boolean( p_init_msg_list )
1056: THEN
1057: FND_MSG_PUB.initialize;
1058: END IF;
1059: -- Debug Message
1060: IF g_debug THEN
1061: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1085: FND_MSG_PUB.Count_And_Get

1081: IF g_debug THEN
1082: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1083: END IF;
1084: -- Standard call to get message count and if count is 1, get message info.
1085: FND_MSG_PUB.Count_And_Get
1086: (p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );
1089: EXCEPTION

Line 1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1088: );
1089: EXCEPTION
1090: WHEN OZF_Utility_PVT.resource_locked THEN
1091: x_return_status := FND_API.g_ret_sts_error;
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1094: FND_MSG_PUB.add;
1095: END IF;
1096: WHEN FND_API.G_EXC_ERROR THEN

Line 1094: FND_MSG_PUB.add;

1090: WHEN OZF_Utility_PVT.resource_locked THEN
1091: x_return_status := FND_API.g_ret_sts_error;
1092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1093: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1094: FND_MSG_PUB.add;
1095: END IF;
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO DELETE_Trade_Profile_PVT;
1098: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1100: FND_MSG_PUB.Count_And_Get (

1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO DELETE_Trade_Profile_PVT;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: -- Standard call to get message count and if count=1, get the message
1100: FND_MSG_PUB.Count_And_Get (
1101: p_encoded => FND_API.G_FALSE,
1102: p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );

Line 1110: FND_MSG_PUB.Count_And_Get (

1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: ROLLBACK TO DELETE_Trade_Profile_PVT;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: -- Standard call to get message count and if count=1, get the message
1110: FND_MSG_PUB.Count_And_Get (
1111: p_encoded => FND_API.G_FALSE,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

Line 1118: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1114: );
1115: WHEN OTHERS THEN
1116: ROLLBACK TO DELETE_Trade_Profile_PVT;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1121: END IF;
1122: -- Standard call to get message count and if count=1, get the message

Line 1120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1116: ROLLBACK TO DELETE_Trade_Profile_PVT;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1119: THEN
1120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1121: END IF;
1122: -- Standard call to get message count and if count=1, get the message
1123: FND_MSG_PUB.Count_And_Get (
1124: p_encoded => FND_API.G_FALSE,

Line 1123: FND_MSG_PUB.Count_And_Get (

1119: THEN
1120: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1121: END IF;
1122: -- Standard call to get message count and if count=1, get the message
1123: FND_MSG_PUB.Count_And_Get (
1124: p_encoded => FND_API.G_FALSE,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data
1127: );

Line 1160: FND_MSG_PUB.initialize;

1156:
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list )
1159: THEN
1160: FND_MSG_PUB.initialize;
1161: END IF;
1162:
1163: -- Standard call to check for call compatibility.
1164: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1177: OPEN c_Trade_Profile;
1178: FETCH c_Trade_Profile INTO l_TRADE_PROFILE_ID;
1179: IF (c_Trade_Profile%NOTFOUND) THEN
1180: CLOSE c_Trade_Profile;
1181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1182: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1183: FND_MSG_PUB.add;
1184: END IF;
1185: RAISE FND_API.g_exc_error;

Line 1183: FND_MSG_PUB.add;

1179: IF (c_Trade_Profile%NOTFOUND) THEN
1180: CLOSE c_Trade_Profile;
1181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1182: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1183: FND_MSG_PUB.add;
1184: END IF;
1185: RAISE FND_API.g_exc_error;
1186: END IF;
1187: CLOSE c_Trade_Profile;

Line 1189: FND_MSG_PUB.count_and_get(

1185: RAISE FND_API.g_exc_error;
1186: END IF;
1187: CLOSE c_Trade_Profile;
1188: -------------------- finish --------------------------
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data);
1193: IF g_debug THEN

Line 1199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1195: END IF;
1196: EXCEPTION
1197: WHEN OZF_Utility_PVT.resource_locked THEN
1198: x_return_status := FND_API.g_ret_sts_error;
1199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: WHEN FND_API.G_EXC_ERROR THEN

Line 1201: FND_MSG_PUB.add;

1197: WHEN OZF_Utility_PVT.resource_locked THEN
1198: x_return_status := FND_API.g_ret_sts_error;
1199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1200: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1201: FND_MSG_PUB.add;
1202: END IF;
1203: WHEN FND_API.G_EXC_ERROR THEN
1204: ROLLBACK TO LOCK_Trade_Profile_PVT;
1205: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1207: FND_MSG_PUB.Count_And_Get (

1203: WHEN FND_API.G_EXC_ERROR THEN
1204: ROLLBACK TO LOCK_Trade_Profile_PVT;
1205: x_return_status := FND_API.G_RET_STS_ERROR;
1206: -- Standard call to get message count and if count=1, get the message
1207: FND_MSG_PUB.Count_And_Get (
1208: p_encoded => FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => x_msg_data
1211: );

Line 1216: FND_MSG_PUB.Count_And_Get (

1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: ROLLBACK TO LOCK_Trade_Profile_PVT;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: -- Standard call to get message count and if count=1, get the message
1216: FND_MSG_PUB.Count_And_Get (
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );

Line 1224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1220: );
1221: WHEN OTHERS THEN
1222: ROLLBACK TO LOCK_Trade_Profile_PVT;
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225: THEN
1226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1227: END IF;
1228: -- Standard call to get message count and if count=1, get the message

Line 1226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1222: ROLLBACK TO LOCK_Trade_Profile_PVT;
1223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1225: THEN
1226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1227: END IF;
1228: -- Standard call to get message count and if count=1, get the message
1229: FND_MSG_PUB.Count_And_Get (
1230: p_encoded => FND_API.G_FALSE,

Line 1229: FND_MSG_PUB.Count_And_Get (

1225: THEN
1226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1227: END IF;
1228: -- Standard call to get message count and if count=1, get the message
1229: FND_MSG_PUB.Count_And_Get (
1230: p_encoded => FND_API.G_FALSE,
1231: p_count => x_msg_count,
1232: p_data => x_msg_data
1233: );

Line 1320: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1316: l_valid_flag := FND_API.g_true;
1317: END IF;
1318:
1319: IF l_valid_flag = FND_API.g_false THEN
1320: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1321: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_DUPLICATE');
1322: FND_MSG_PUB.add;
1323: END IF;
1324: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1322: FND_MSG_PUB.add;

1318:
1319: IF l_valid_flag = FND_API.g_false THEN
1320: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1321: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_CUST_DUPLICATE');
1322: FND_MSG_PUB.add;
1323: END IF;
1324: x_return_status := FND_API.G_RET_STS_ERROR;
1325: END IF;
1326: END check_trade_profile_uk_items;

Line 1356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1352: p_trade_profile_rec.party_id IS NULL THEN
1353: IF p_trade_profile_rec.site_use_id = FND_API.g_miss_num OR --For R12.1 Enhancements
1354: p_trade_profile_rec.site_use_id IS NULL
1355: THEN
1356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1357: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PARTY_MISSING');
1358: FND_MSG_PUB.add;
1359: END IF;
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1358: FND_MSG_PUB.add;

1354: p_trade_profile_rec.site_use_id IS NULL
1355: THEN
1356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1357: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PARTY_MISSING');
1358: FND_MSG_PUB.add;
1359: END IF;
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362: END IF;

Line 1367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1363: OZF_UTILITY_PVT.debug_message('p_trade_profile_rec.payment_method : ' || p_trade_profile_rec.payment_method);
1364: IF p_trade_profile_rec.payment_method = 'CHECK' THEN
1365: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1366: p_trade_profile_rec.vendor_id IS NULL THEN
1367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1368: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');
1369: FND_MSG_PUB.add;
1370: END IF;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1369: FND_MSG_PUB.add;

1365: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1366: p_trade_profile_rec.vendor_id IS NULL THEN
1367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1368: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');
1369: FND_MSG_PUB.add;
1370: END IF;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END IF;
1373: IF p_trade_profile_rec.vendor_site_id = FND_API.g_miss_num OR

Line 1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1372: END IF;
1373: IF p_trade_profile_rec.vendor_site_id = FND_API.g_miss_num OR
1374: p_trade_profile_rec.vendor_site_id IS NULL
1375: THEN
1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1377: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENSITE_MISSING');
1378: FND_MSG_PUB.add;
1379: END IF;
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1378: FND_MSG_PUB.add;

1374: p_trade_profile_rec.vendor_site_id IS NULL
1375: THEN
1376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1377: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENSITE_MISSING');
1378: FND_MSG_PUB.add;
1379: END IF;
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END IF;
1382: END IF;

Line 1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1382: END IF;
1383: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1384: p_trade_profile_rec.autopay_flag IS NULL
1385: THEN
1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1387: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_AUTO_MISSING ');
1388: FND_MSG_PUB.add;
1389: END IF;
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1388: FND_MSG_PUB.add;

1384: p_trade_profile_rec.autopay_flag IS NULL
1385: THEN
1386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1387: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_AUTO_MISSING ');
1388: FND_MSG_PUB.add;
1389: END IF;
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392:

Line 1397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1393: -- defaulted to F in the create api
1394: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1395: p_trade_profile_rec.internet_deal_view_flag IS NULL
1396: THEN
1397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1398: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_INTERNET_MISSING');
1399: FND_MSG_PUB.add;
1400: END IF;
1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1399: FND_MSG_PUB.add;

1395: p_trade_profile_rec.internet_deal_view_flag IS NULL
1396: THEN
1397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1398: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_INTERNET_MISSING');
1399: FND_MSG_PUB.add;
1400: END IF;
1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1402: END IF;
1403: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR

Line 1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1402: END IF;
1403: IF p_trade_profile_rec.autopay_flag = FND_API.g_miss_char OR
1404: p_trade_profile_rec.print_flag IS NULL
1405: THEN
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PRINT_MISSING');
1408: FND_MSG_PUB.add;
1409: END IF;
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1408: FND_MSG_PUB.add;

1404: p_trade_profile_rec.print_flag IS NULL
1405: THEN
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_PRINT_MISSING');
1408: FND_MSG_PUB.add;
1409: END IF;
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:

Line 1418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1414: IF p_trade_profile_rec.payment_method = 'CREDIT_MEMO' THEN
1415: IF p_trade_profile_rec.site_use_id IS NULL OR
1416: p_trade_profile_rec.site_use_id = FND_API.G_MISS_NUM
1417: THEN
1418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1419: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');
1420: FND_MSG_PUB.add;
1421: END IF;
1422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1420: FND_MSG_PUB.add;

1416: p_trade_profile_rec.site_use_id = FND_API.G_MISS_NUM
1417: THEN
1418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1419: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');
1420: FND_MSG_PUB.add;
1421: END IF;
1422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1423: END IF;
1424: END IF;

Line 1433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1429: THEN
1430: IF p_trade_profile_rec.claim_currency IS NULL AND
1431: p_trade_profile_rec.claim_threshold IS NULL
1432: THEN
1433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1434: FND_MESSAGE.set_name('OZF', 'ERROR1');
1435: FND_MSG_PUB.add;
1436: END IF;
1437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1435: FND_MSG_PUB.add;

1431: p_trade_profile_rec.claim_threshold IS NULL
1432: THEN
1433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1434: FND_MESSAGE.set_name('OZF', 'ERROR1');
1435: FND_MSG_PUB.add;
1436: END IF;
1437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: END IF;
1439: ELSE

Line 1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1439: ELSE
1440: IF p_trade_profile_rec.autopay_periodicity IS NULL OR
1441: p_trade_profile_rec.autopay_periodicity_type IS NULL
1442: THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'ERROR1');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1445: FND_MSG_PUB.add;

1441: p_trade_profile_rec.autopay_periodicity_type IS NULL
1442: THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'ERROR1');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449: END IF;

Line 1457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1453: THEN
1454: IF p_trade_profile_rec.autopay_periodicity IS NULL AND
1455: p_trade_profile_rec.autopay_periodicity_type IS NULL
1456: THEN
1457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1458: FND_MESSAGE.set_name('OZF', 'ERROR3');
1459: FND_MSG_PUB.add;
1460: END IF;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1459: FND_MSG_PUB.add;

1455: p_trade_profile_rec.autopay_periodicity_type IS NULL
1456: THEN
1457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1458: FND_MESSAGE.set_name('OZF', 'ERROR3');
1459: FND_MSG_PUB.add;
1460: END IF;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463: ELSE

Line 1467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1463: ELSE
1464: IF p_trade_profile_rec.claim_currency IS NULL OR
1465: p_trade_profile_rec.claim_threshold IS NULL
1466: THEN
1467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1468: FND_MESSAGE.set_name('OZF', 'ERROR4');
1469: FND_MSG_PUB.add;
1470: END IF;
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1469: FND_MSG_PUB.add;

1465: p_trade_profile_rec.claim_threshold IS NULL
1466: THEN
1467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1468: FND_MESSAGE.set_name('OZF', 'ERROR4');
1469: FND_MSG_PUB.add;
1470: END IF;
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1472: END IF;
1473: END IF;

Line 1514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1510:
1511: IF (p_trade_profile_rec.header_tolerance_calc_code is null
1512: AND p_trade_profile_rec.header_tolerance_operand is not null)
1513: THEN
1514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1515: THEN
1516: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
1517: FND_MSG_PUB.add;
1518: END IF;

Line 1517: FND_MSG_PUB.add;

1513: THEN
1514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1515: THEN
1516: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
1517: FND_MSG_PUB.add;
1518: END IF;
1519: x_return_status := FND_API.g_ret_sts_error;
1520: RETURN;
1521: ELSIF (p_trade_profile_rec.header_tolerance_calc_code is not null

Line 1524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1520: RETURN;
1521: ELSIF (p_trade_profile_rec.header_tolerance_calc_code is not null
1522: AND p_trade_profile_rec.header_tolerance_operand is null)
1523: THEN
1524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1525: THEN
1526: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
1527: FND_MSG_PUB.add;
1528: END IF;

Line 1527: FND_MSG_PUB.add;

1523: THEN
1524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1525: THEN
1526: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
1527: FND_MSG_PUB.add;
1528: END IF;
1529: x_return_status := FND_API.g_ret_sts_error;
1530: RETURN;
1531: END IF;

Line 1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1534:
1535: IF (p_trade_profile_rec.line_tolerance_calc_code is null
1536: AND p_trade_profile_rec.line_tolerance_operand is not null )
1537: THEN
1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1539: THEN
1540: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
1541: FND_MSG_PUB.add;
1542: END IF;

Line 1541: FND_MSG_PUB.add;

1537: THEN
1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1539: THEN
1540: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
1541: FND_MSG_PUB.add;
1542: END IF;
1543: x_return_status := FND_API.g_ret_sts_error;
1544: RETURN;
1545: ELSIF (p_trade_profile_rec.line_tolerance_calc_code is not null

Line 1548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1544: RETURN;
1545: ELSIF (p_trade_profile_rec.line_tolerance_calc_code is not null
1546: AND p_trade_profile_rec.line_tolerance_operand is null)
1547: THEN
1548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1549: THEN
1550: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
1551: FND_MSG_PUB.add;
1552: END IF;

Line 1551: FND_MSG_PUB.add;

1547: THEN
1548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1549: THEN
1550: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
1551: FND_MSG_PUB.add;
1552: END IF;
1553: x_return_status := FND_API.g_ret_sts_error;
1554: RETURN;
1555: END IF;

Line 1641: FND_MSG_PUB.initialize;

1637: END IF;
1638: -- Initialize message list if p_init_msg_list is set to TRUE.
1639: IF FND_API.to_Boolean( p_init_msg_list )
1640: THEN
1641: FND_MSG_PUB.initialize;
1642: END IF;
1643: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1644: Check_trade_profile_Items(
1645: p_trade_profile_rec => p_trade_profile_rec,

Line 1674: FND_MSG_PUB.Count_And_Get

1670:
1671: -- Initialize API return status to SUCCESS
1672: x_return_status := FND_API.G_RET_STS_SUCCESS;
1673: -- Standard call to get message count and if count is 1, get message info.
1674: FND_MSG_PUB.Count_And_Get
1675: (p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );
1678: EXCEPTION

Line 1681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1677: );
1678: EXCEPTION
1679: WHEN OZF_Utility_PVT.resource_locked THEN
1680: x_return_status := FND_API.g_ret_sts_error;
1681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1682: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1683: FND_MSG_PUB.add;
1684: END IF;
1685: WHEN FND_API.G_EXC_ERROR THEN

Line 1683: FND_MSG_PUB.add;

1679: WHEN OZF_Utility_PVT.resource_locked THEN
1680: x_return_status := FND_API.g_ret_sts_error;
1681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1682: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1683: FND_MSG_PUB.add;
1684: END IF;
1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO VALIDATE_Trade_Profile_PVT;
1687: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1689: FND_MSG_PUB.Count_And_Get (

1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO VALIDATE_Trade_Profile_PVT;
1687: x_return_status := FND_API.G_RET_STS_ERROR;
1688: -- Standard call to get message count and if count=1, get the message
1689: FND_MSG_PUB.Count_And_Get (
1690: p_encoded => FND_API.G_FALSE,
1691: p_count => x_msg_count,
1692: p_data => x_msg_data
1693: );

Line 1698: FND_MSG_PUB.Count_And_Get (

1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: ROLLBACK TO VALIDATE_Trade_Profile_PVT;
1696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data
1702: );

Line 1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1702: );
1703: WHEN OTHERS THEN
1704: ROLLBACK TO VALIDATE_Trade_Profile_PVT;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1707: THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;
1710: -- Standard call to get message count and if count=1, get the message

Line 1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1704: ROLLBACK TO VALIDATE_Trade_Profile_PVT;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1707: THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;
1710: -- Standard call to get message count and if count=1, get the message
1711: FND_MSG_PUB.Count_And_Get (
1712: p_encoded => FND_API.G_FALSE,

Line 1711: FND_MSG_PUB.Count_And_Get (

1707: THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1709: END IF;
1710: -- Standard call to get message count and if count=1, get the message
1711: FND_MSG_PUB.Count_And_Get (
1712: p_encoded => FND_API.G_FALSE,
1713: p_count => x_msg_count,
1714: p_data => x_msg_data
1715: );

Line 1731: FND_MSG_PUB.initialize;

1727: BEGIN
1728: -- Initialize message list if p_init_msg_list is set to TRUE.
1729: IF FND_API.to_Boolean( p_init_msg_list )
1730: THEN
1731: FND_MSG_PUB.initialize;
1732: END IF;
1733:
1734: -- Initialize API return status to SUCCESS
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1746: FND_MSG_PUB.Count_And_Get

1742: IF g_debug THEN
1743: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1744: END IF;
1745: -- Standard call to get message count and if count is 1, get message info.
1746: FND_MSG_PUB.Count_And_Get
1747: (p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );
1750: END Validate_trade_profile_Rec;