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 20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

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

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

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

Line 51: FND_MSG_PUB.add;

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

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

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

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

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

Line 484: FND_MSG_PUB.initialize;

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

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

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

Line 512: FND_MSG_PUB.add;

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

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

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

Line 532: FND_MSG_PUB.add;

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

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

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

Line 651: FND_MSG_PUB.add;

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

Line 672: FND_MSG_PUB.Count_And_Get

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

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

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

Line 682: FND_MSG_PUB.add;

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

Line 688: FND_MSG_PUB.Count_And_Get (

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

Line 697: FND_MSG_PUB.Count_And_Get (

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

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

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

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

703: ROLLBACK TO CREATE_Trade_Profile_PVT;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
708: END IF;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,

Line 710: FND_MSG_PUB.Count_And_Get (

706: THEN
707: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
708: END IF;
709: -- Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );

Line 787: FND_MSG_PUB.initialize;

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

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

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

Line 804: FND_MSG_PUB.add;

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

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

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

Line 818: FND_MSG_PUB.add;

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

Line 984: FND_MSG_PUB.Count_And_Get

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

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

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

Line 993: FND_MSG_PUB.add;

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

Line 999: FND_MSG_PUB.Count_And_Get (

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

Line 1008: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1021: FND_MSG_PUB.Count_And_Get (

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

Line 1059: FND_MSG_PUB.initialize;

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

Line 1087: FND_MSG_PUB.Count_And_Get

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

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

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

Line 1096: FND_MSG_PUB.add;

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

Line 1102: FND_MSG_PUB.Count_And_Get (

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

Line 1112: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1125: FND_MSG_PUB.Count_And_Get (

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

Line 1162: FND_MSG_PUB.initialize;

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

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

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

Line 1185: FND_MSG_PUB.add;

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

Line 1191: FND_MSG_PUB.count_and_get(

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

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

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

Line 1203: FND_MSG_PUB.add;

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

Line 1209: FND_MSG_PUB.Count_And_Get (

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

Line 1218: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1231: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 1324: FND_MSG_PUB.add;

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

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

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

Line 1360: FND_MSG_PUB.add;

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

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

1366: -- Fix for ER#9453443
1367: IF p_trade_profile_rec.payment_method IN ('CHECK','EFT','WIRE','AP_DEBIT','AP_DEFAULT') THEN
1368: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1369: p_trade_profile_rec.vendor_id IS NULL THEN
1370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1371: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_VENDOR_MISSING');
1372: FND_MSG_PUB.add;
1373: END IF;
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1372: FND_MSG_PUB.add;

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

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

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

Line 1381: FND_MSG_PUB.add;

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

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

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

Line 1391: FND_MSG_PUB.add;

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

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

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

Line 1402: FND_MSG_PUB.add;

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

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

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

Line 1411: FND_MSG_PUB.add;

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

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

1418: /* IF p_trade_profile_rec.payment_method = 'CREDIT_MEMO' THEN
1419: IF p_trade_profile_rec.site_use_id IS NULL OR
1420: p_trade_profile_rec.site_use_id = FND_API.G_MISS_NUM
1421: THEN
1422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1423: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');
1424: FND_MSG_PUB.add;
1425: END IF;
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1424: FND_MSG_PUB.add;

1420: p_trade_profile_rec.site_use_id = FND_API.G_MISS_NUM
1421: THEN
1422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1423: FND_MESSAGE.set_name('OZF', 'OZF_TRADE_SITE_MISSING');
1424: FND_MSG_PUB.add;
1425: END IF;
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: END IF;
1428: END IF;*/

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

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

Line 1439: FND_MSG_PUB.add;

1435: p_trade_profile_rec.claim_threshold IS NULL
1436: THEN
1437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1438: FND_MESSAGE.set_name('OZF', 'ERROR1');
1439: FND_MSG_PUB.add;
1440: END IF;
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443: ELSE

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

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

Line 1449: FND_MSG_PUB.add;

1445: p_trade_profile_rec.autopay_periodicity_type IS NULL
1446: THEN
1447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1448: FND_MESSAGE.set_name('OZF', 'ERROR1');
1449: FND_MSG_PUB.add;
1450: END IF;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;
1453: END IF;

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

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

Line 1463: FND_MSG_PUB.add;

1459: p_trade_profile_rec.autopay_periodicity_type IS NULL
1460: THEN
1461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1462: FND_MESSAGE.set_name('OZF', 'ERROR3');
1463: FND_MSG_PUB.add;
1464: END IF;
1465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1466: END IF;
1467: ELSE

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

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

Line 1473: FND_MSG_PUB.add;

1469: p_trade_profile_rec.claim_threshold IS NULL
1470: THEN
1471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1472: FND_MESSAGE.set_name('OZF', 'ERROR4');
1473: FND_MSG_PUB.add;
1474: END IF;
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477: END IF;

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

1514:
1515: IF (p_trade_profile_rec.header_tolerance_calc_code is null
1516: AND p_trade_profile_rec.header_tolerance_operand is not null)
1517: THEN
1518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1519: THEN
1520: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
1521: FND_MSG_PUB.add;
1522: END IF;

Line 1521: FND_MSG_PUB.add;

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

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

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

Line 1531: FND_MSG_PUB.add;

1527: THEN
1528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1529: THEN
1530: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
1531: FND_MSG_PUB.add;
1532: END IF;
1533: x_return_status := FND_API.g_ret_sts_error;
1534: RETURN;
1535: END IF;

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

1538:
1539: IF (p_trade_profile_rec.line_tolerance_calc_code is null
1540: AND p_trade_profile_rec.line_tolerance_operand is not null )
1541: THEN
1542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1543: THEN
1544: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
1545: FND_MSG_PUB.add;
1546: END IF;

Line 1545: FND_MSG_PUB.add;

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

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

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

Line 1555: FND_MSG_PUB.add;

1551: THEN
1552: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1553: THEN
1554: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
1555: FND_MSG_PUB.add;
1556: END IF;
1557: x_return_status := FND_API.g_ret_sts_error;
1558: RETURN;
1559: END IF;

Line 1645: FND_MSG_PUB.initialize;

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

Line 1678: FND_MSG_PUB.Count_And_Get

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

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

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

Line 1687: FND_MSG_PUB.add;

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

Line 1693: FND_MSG_PUB.Count_And_Get (

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

Line 1702: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1715: FND_MSG_PUB.Count_And_Get (

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

Line 1735: FND_MSG_PUB.initialize;

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

Line 1750: FND_MSG_PUB.Count_And_Get

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