DBA Data[Home] [Help]

APPS.OZF_RESALE_PVT dependencies on FND_MSG_PUB

Line 13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvssb.pls';
12:
13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: CURSOR g_org_id_csr(p_id number) IS
17: SELECT org_id

Line 14: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_RESALE_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvssb.pls';
12:
13: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
14: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
15:
16: CURSOR g_org_id_csr(p_id number) IS
17: SELECT org_id
18: FROM ozf_resale_batches_all

Line 75: FND_MSG_PUB.initialize;

71: END IF;
72:
73: --Initialize message list if p_init_msg_list is TRUE.
74: IF FND_API.To_Boolean (p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Initialize API return status to sucess
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 168: FND_MSG_PUB.Count_And_Get (

164: IF OZF_DEBUG_HIGH_ON THEN
165: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
166: END IF;
167: --Standard call to get message count and if count=1, get the message
168: FND_MSG_PUB.Count_And_Get (
169: p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );

Line 180: FND_MSG_PUB.Count_And_Get (

176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO INITIATE_PAYMENT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );

Line 189: FND_MSG_PUB.Count_And_Get (

185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO INITIATE_PAYMENT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: -- Standard call to get message count and if count=1, get the message
189: FND_MSG_PUB.Count_And_Get (
190: p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );

Line 198: FND_MSG_PUB.Count_And_Get (

194: WHEN OTHERS THEN
195: ROLLBACK TO INITIATE_PAYMENT;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: -- Standard call to get message count and if count=1, get the message
198: FND_MSG_PUB.Count_And_Get (
199: p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );

Line 273: FND_MSG_PUB.count_and_get (

269: END IF;
270: resultout := l_resultout;
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: FND_MSG_PUB.count_and_get (
274: p_encoded => FND_API.g_false
275: ,p_count => l_msg_count
276: ,p_data => l_msg_data
277: );

Line 291: fnd_msg_pub.Count_And_Get(

287: resultout := 'COMPLETE:N';
288: RETURN;
289:
290: WHEN OTHERS THEN
291: fnd_msg_pub.Count_And_Get(
292: p_encoded => FND_API.G_TRUE
293: ,p_count => l_msg_count
294: ,p_data => l_msg_data);
295: wf_core.context(G_PKG_NAME, l_api_name,l_msg_data);

Line 384: FND_MSG_PUB.initialize;

380: END IF;
381:
382: --Initialize message list if p_init_msg_list is TRUE.
383: IF FND_API.To_Boolean (p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386:
387: -- Debug Message
388: IF OZF_DEBUG_HIGH_ON THEN

Line 664: FND_MSG_PUB.Count_And_Get (

660: IF OZF_DEBUG_HIGH_ON THEN
661: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
662: END IF;
663: --Standard call to get message count and if count=1, get the message
664: FND_MSG_PUB.Count_And_Get (
665: p_encoded => FND_API.G_FALSE,
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );

Line 674: FND_MSG_PUB.Count_And_Get (

670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE,
676: p_count => x_msg_count,
677: p_data => x_msg_data
678: );

Line 682: FND_MSG_PUB.Count_And_Get (

678: );
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );

Line 691: FND_MSG_PUB.Count_And_Get (

687: WHEN OTHERS THEN
688: ROLLBACK TO PROCESS_IFACE;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

Line 763: FND_MSG_PUB.count_and_get (

759: END IF;
760: resultout := l_resultout;
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: FND_MSG_PUB.count_and_get (
764: p_encoded => FND_API.g_false
765: ,p_count => l_msg_count
766: ,p_data => l_msg_data
767: );

Line 780: fnd_msg_pub.Count_And_Get(

776: resultout := 'COMPLETE:N';
777: RETURN;
778:
779: WHEN OTHERS THEN
780: fnd_msg_pub.Count_And_Get(
781: p_encoded => FND_API.G_TRUE
782: ,p_count => l_msg_count
783: ,p_data => l_msg_data);
784:

Line 846: FND_MSG_PUB.initialize;

842: END IF;
843:
844: --Initialize message list if p_init_msg_list is TRUE.
845: IF FND_API.To_Boolean (p_init_msg_list) THEN
846: FND_MSG_PUB.initialize;
847: END IF;
848:
849: -- Initialize API return status to sucess
850: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 916: FND_MSG_PUB.Count_And_Get (

912: IF OZF_DEBUG_HIGH_ON THEN
913: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
914: END IF;
915: --Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data
920: );

Line 925: FND_MSG_PUB.Count_And_Get (

921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );

Line 933: FND_MSG_PUB.Count_And_Get (

929: );
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );

Line 942: FND_MSG_PUB.Count_And_Get (

938: WHEN OTHERS THEN
939: ROLLBACK TO PROCESS_RESALE;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: -- Standard call to get message count and if count=1, get the message
942: FND_MSG_PUB.Count_And_Get (
943: p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );

Line 1026: FND_MSG_PUB.initialize;

1022: END IF;
1023:
1024: --Initialize message list if p_init_msg_list is TRUE.
1025: IF FND_API.To_Boolean (p_init_msg_list) THEN
1026: FND_MSG_PUB.initialize;
1027: END IF;
1028:
1029: -- Initialize API return status to sucess
1030: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1130: FND_MSG_PUB.Count_And_Get (

1126: IF OZF_DEBUG_HIGH_ON THEN
1127: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1128: END IF;
1129: --Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );

Line 1139: FND_MSG_PUB.Count_And_Get (

1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );

Line 1147: FND_MSG_PUB.Count_And_Get (

1143: );
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data
1151: );

Line 1156: FND_MSG_PUB.Count_And_Get (

1152: WHEN OTHERS THEN
1153: ROLLBACK TO PROCESS_RESALE_ALL;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: -- Standard call to get message count and if count=1, get the message
1156: FND_MSG_PUB.Count_And_Get (
1157: p_encoded => FND_API.G_FALSE,
1158: p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );

Line 1327: FND_MSG_PUB.initialize;

1323: END IF;
1324:
1325: --Initialize message list if p_init_msg_list is TRUE.
1326: IF FND_API.To_Boolean (p_init_msg_list) THEN
1327: FND_MSG_PUB.initialize;
1328: END IF;
1329:
1330: -- Initialize API return status to sucess
1331: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1431: FND_MSG_PUB.Count_And_Get (

1427: IF OZF_DEBUG_HIGH_ON THEN
1428: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1429: END IF;
1430: --Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );

Line 1443: FND_MSG_PUB.Count_And_Get (

1439: ROLLBACK TO Resale_Purge ;
1440:
1441: x_return_status := FND_API.G_RET_STS_ERROR;
1442: -- Standard call to get message count and if count=1, get the message
1443: FND_MSG_PUB.Count_And_Get (
1444: p_encoded => FND_API.G_FALSE,
1445: p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );

Line 1453: FND_MSG_PUB.Count_And_Get (

1449: ROLLBACK TO Resale_Purge;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451:
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );

Line 1463: FND_MSG_PUB.Count_And_Get (

1459: ROLLBACK TO Resale_Purge;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461:
1462: -- Standard call to get message count and if count=1, get the message
1463: FND_MSG_PUB.Count_And_Get (
1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );