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_OFFER_PERFORMANCE_PVT dependencies on OZF_UTILITY_PVT

Line 58: ozf_utility_pvt.debug_message('inside create');

54: --dbms_output.put_line('First message');
55: -- Standard Start of API savepoint
56: SAVEPOINT CREATE_Offer_Performance_PVT;
57:
58: ozf_utility_pvt.debug_message('inside create');
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,

Line 75: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Debug Message
75: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');
76:
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: ozf_utility_pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

102: -- =========================================================================
103:
104: IF FND_GLOBAL.User_Id IS NULL
105: THEN
106: ozf_utility_pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
107: RAISE FND_API.G_EXC_ERROR;
108: END IF;
109:
110: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 113: ozf_utility_pvt.debug_message('Private API: Validate_Offer_Performance');

109:
110: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
111: THEN
112: -- Debug message
113: ozf_utility_pvt.debug_message('Private API: Validate_Offer_Performance');
114:
115: -- Invoke validation procedures
116: Validate_offer_performance(
117: p_api_version_number => 1.0,

Line 133: ozf_utility_pvt.debug_message( 'Private API: Calling create table handler');

129: END IF;
130:
131:
132: -- Debug Message
133: ozf_utility_pvt.debug_message( 'Private API: Calling create table handler');
134:
135: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Insert_Row)
136: OZF_OFFER_PERFORMANCES_PKG.Insert_Row(
137: px_offer_performance_id => l_offer_performance_id,

Line 190: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');

186: END IF;
187:
188:
189: -- Debug Message
190: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
191:
192: -- Standard call to get message count and if count is 1, get message info.
193: FND_MSG_PUB.Count_And_Get
194: (p_count => x_msg_count,

Line 199: WHEN ozf_utility_pvt.resource_locked THEN

195: p_data => x_msg_data
196: );
197: EXCEPTION
198:
199: WHEN ozf_utility_pvt.resource_locked THEN
200: x_return_status := FND_API.g_ret_sts_error;
201: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
202:
203: WHEN FND_API.G_EXC_ERROR THEN

Line 201: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

197: EXCEPTION
198:
199: WHEN ozf_utility_pvt.resource_locked THEN
200: x_return_status := FND_API.g_ret_sts_error;
201: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_Offer_Performance_PVT;
205: x_return_status := FND_API.G_RET_STS_ERROR;

Line 274: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');

270: BEGIN
271: --dbms_output.put_line('second message');
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Offer_Performance_PVT;
274: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
275: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
276: -- Standard call to check for call compatibility.
277: -- RAISE FND_API.G_EXC_ERROR;
278: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 275: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');

271: --dbms_output.put_line('second message');
272: -- Standard Start of API savepoint
273: SAVEPOINT UPDATE_Offer_Performance_PVT;
274: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
275: ozf_utility_pvt.debug_message('Inside update Private API: - Open Cursor to Select');
276: -- Standard call to check for call compatibility.
277: -- RAISE FND_API.G_EXC_ERROR;
278: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
279: p_api_version_number,

Line 293: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

289: FND_MSG_PUB.initialize;
290: END IF;
291:
292: -- Debug Message
293: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');
294:
295:
296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 300: ozf_utility_pvt.debug_message('Private API: - Open Cursor to Select');

296: -- Initialize API return status to SUCCESS
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: -- Debug Message
300: ozf_utility_pvt.debug_message('Private API: - Open Cursor to Select');
301:
302:
303: OPEN c_get_Offer_Performance( l_tar_offer_perf_rec.offer_performance_id);
304:

Line 308: ozf_utility_pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

304:
305: FETCH c_get_Offer_Performance INTO l_ref_offer_perf_rec ;
306:
307: If ( c_get_Offer_Performance%NOTFOUND) THEN
308: ozf_utility_pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
309: p_token_name => 'INFO',
310: p_token_value => 'Offer_Performance') ;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;

Line 314: ozf_utility_pvt.debug_message('Private API: - Close Cursor');

310: p_token_value => 'Offer_Performance') ;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: -- Debug Message
314: ozf_utility_pvt.debug_message('Private API: - Close Cursor');
315: CLOSE c_get_Offer_Performance;
316:
317:
318:

Line 321: ozf_utility_pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',

317:
318:
319: If (l_tar_offer_perf_rec.object_version_number is NULL or
320: l_tar_offer_perf_rec.object_version_number = FND_API.G_MISS_NUM ) Then
321: ozf_utility_pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
322: p_token_name => 'COLUMN',
323: p_token_value => 'Last_Update_Date') ;
324: raise FND_API.G_EXC_ERROR;
325: End if;

Line 328: ozf_utility_pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',

324: raise FND_API.G_EXC_ERROR;
325: End if;
326: -- Check Whether record has been changed by someone else
327: If (l_tar_offer_perf_rec.object_version_number <> l_ref_offer_perf_rec.object_version_number) Then
328: ozf_utility_pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
329: p_token_name => 'INFO',
330: p_token_value => 'Offer_Performance') ;
331: raise FND_API.G_EXC_ERROR;
332: End if;

Line 336: ozf_utility_pvt.debug_message('Private API: Validate_Offer_Performance');

332: End if;
333: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
334: THEN
335: -- Debug message
336: ozf_utility_pvt.debug_message('Private API: Validate_Offer_Performance');
337:
338: -- Invoke validation procedures
339: Validate_offer_performance(
340: p_api_version_number => 1.0,

Line 349: ozf_utility_pvt.debug_message('out of validate');

345: x_return_status => x_return_status,
346: x_msg_count => x_msg_count,
347: x_msg_data => x_msg_data);
348: END IF;
349: ozf_utility_pvt.debug_message('out of validate');
350:
351: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
352: RAISE FND_API.G_EXC_ERROR;
353: END IF;

Line 355: ozf_utility_pvt.debug_message('out OUT NOCOPY out of validate');

351: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
352: RAISE FND_API.G_EXC_ERROR;
353: END IF;
354:
355: ozf_utility_pvt.debug_message('out OUT NOCOPY out of validate');
356: -- Debug Message
357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
358: l_object_version_number := l_tar_offer_perf_rec.object_version_number + 1;
359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)

Line 357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');

353: END IF;
354:
355: ozf_utility_pvt.debug_message('out OUT NOCOPY out of validate');
356: -- Debug Message
357: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
358: l_object_version_number := l_tar_offer_perf_rec.object_version_number + 1;
359: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Update_Row)
360: OZF_OFFER_PERFORMANCES_PKG.Update_Row(
361: p_offer_performance_id => p_offer_perf_rec.offer_performance_id,

Line 412: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');

408: END IF;
409:
410:
411: -- Debug Message
412: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
413:
414: -- Standard call to get message count and if count is 1, get message info.
415: FND_MSG_PUB.Count_And_Get
416: (p_count => x_msg_count,

Line 421: WHEN ozf_utility_pvt.resource_locked THEN

417: p_data => x_msg_data
418: );
419: EXCEPTION
420:
421: WHEN ozf_utility_pvt.resource_locked THEN
422: x_return_status := FND_API.g_ret_sts_error;
423: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
424:
425: WHEN FND_API.G_EXC_ERROR THEN

Line 423: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

419: EXCEPTION
420:
421: WHEN ozf_utility_pvt.resource_locked THEN
422: x_return_status := FND_API.g_ret_sts_error;
423: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
424:
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO UPDATE_Offer_Performance_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR;

Line 499: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

495: FND_MSG_PUB.initialize;
496: END IF;
497:
498: -- Debug Message
499: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');
500:
501:
502: -- Initialize API return status to SUCCESS
503: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 509: ozf_utility_pvt.debug_message( 'Private API: Calling delete table handler');

505: --
506: -- Api body
507: --
508: -- Debug Message
509: ozf_utility_pvt.debug_message( 'Private API: Calling delete table handler');
510:
511: -- Invoke table handler(OZF_OFFER_PERFORMANCES_PKG.Delete_Row)
512: OZF_OFFER_PERFORMANCES_PKG.Delete_Row(
513: p_OFFER_PERFORMANCE_ID => p_OFFER_PERFORMANCE_ID);

Line 526: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');

522: END IF;
523:
524:
525: -- Debug Message
526: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,

Line 535: WHEN ozf_utility_pvt.resource_locked THEN

531: p_data => x_msg_data
532: );
533: EXCEPTION
534:
535: WHEN ozf_utility_pvt.resource_locked THEN
536: x_return_status := FND_API.g_ret_sts_error;
537: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
538:
539: WHEN FND_API.G_EXC_ERROR THEN

Line 537: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

533: EXCEPTION
534:
535: WHEN ozf_utility_pvt.resource_locked THEN
536: x_return_status := FND_API.g_ret_sts_error;
537: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: ROLLBACK TO DELETE_Offer_Performance_PVT;
541: x_return_status := FND_API.G_RET_STS_ERROR;

Line 605: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

601:
602: BEGIN
603: --dbms_output.put_line('Fourth message');
604: -- Debug Message
605: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');
606:
607: -- Initialize message list if p_init_msg_list is set to TRUE.
608: IF FND_API.to_Boolean( p_init_msg_list )
609: THEN

Line 629: ozf_utility_pvt.debug_message(l_full_name||': start');

625:
626:
627: ------------------------ lock -------------------------
628:
629: ozf_utility_pvt.debug_message(l_full_name||': start');
630: OPEN c_Offer_Performance;
631:
632: FETCH c_Offer_Performance INTO l_OFFER_PERFORMANCE_ID;
633:

Line 650: ozf_utility_pvt.debug_message(l_full_name ||': end');

646: FND_MSG_PUB.count_and_get(
647: p_encoded => FND_API.g_false,
648: p_count => x_msg_count,
649: p_data => x_msg_data);
650: ozf_utility_pvt.debug_message(l_full_name ||': end');
651: EXCEPTION
652:
653: WHEN ozf_utility_pvt.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;

Line 653: WHEN ozf_utility_pvt.resource_locked THEN

649: p_data => x_msg_data);
650: ozf_utility_pvt.debug_message(l_full_name ||': end');
651: EXCEPTION
652:
653: WHEN ozf_utility_pvt.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN

Line 655: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

651: EXCEPTION
652:
653: WHEN ozf_utility_pvt.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_Offer_Performance_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 704: ozf_utility_pvt.debug_message('inside uk='||p_validation_mode||''||p_offer_perf_rec.OFFER_PERFORMANCE_ID);

700:
701: BEGIN
702: x_return_status := FND_API.g_ret_sts_success;
703:
704: ozf_utility_pvt.debug_message('inside uk='||p_validation_mode||''||p_offer_perf_rec.OFFER_PERFORMANCE_ID);
705: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTRIBUTE);
706: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTR_VALUE);
707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);
708:

Line 705: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTRIBUTE);

701: BEGIN
702: x_return_status := FND_API.g_ret_sts_success;
703:
704: ozf_utility_pvt.debug_message('inside uk='||p_validation_mode||''||p_offer_perf_rec.OFFER_PERFORMANCE_ID);
705: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTRIBUTE);
706: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTR_VALUE);
707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);
708:
709:

Line 706: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTR_VALUE);

702: x_return_status := FND_API.g_ret_sts_success;
703:
704: ozf_utility_pvt.debug_message('inside uk='||p_validation_mode||''||p_offer_perf_rec.OFFER_PERFORMANCE_ID);
705: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTRIBUTE);
706: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTR_VALUE);
707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);
708:
709:
710:

Line 707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);

703:
704: ozf_utility_pvt.debug_message('inside uk='||p_validation_mode||''||p_offer_perf_rec.OFFER_PERFORMANCE_ID);
705: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTRIBUTE);
706: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.PRODUCT_ATTR_VALUE);
707: ozf_utility_pvt.debug_message('ins'||p_offer_perf_rec.CHANNEL_ID);
708:
709:
710:
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 712: l_valid_flag := ozf_utility_pvt.check_uniqueness(

708:
709:
710:
711: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
712: l_valid_flag := ozf_utility_pvt.check_uniqueness(
713: 'OZF_OFFER_PERFORMANCES',
714: ' PRODUCT_ATTRIBUTE ='||' '||p_offer_perf_rec.PRODUCT_ATTRIBUTE ||''||
715: ' AND PRODUCT_ATTR_VALUE ='||' '|| p_offer_perf_rec.PRODUCT_ATTR_VALUE||''||
716: ' AND CHANNEL_ID = '||' '|| p_offer_perf_rec.CHANNEL_ID||' '||

Line 721: -- l_valid_flag := ozf_utility_pvt.check_uniqueness('OZF_OFFER_PERFORMANCES','OFFER_PERFORMANCE_ID = '||' '||p_offer_perf_rec.offer_performance_id||' '||

717: ' AND LIST_HEADER_ID = '||' '|| p_offer_perf_rec.LIST_HEADER_ID
718: );
719:
720: ELSE
721: -- l_valid_flag := ozf_utility_pvt.check_uniqueness('OZF_OFFER_PERFORMANCES','OFFER_PERFORMANCE_ID = '||' '||p_offer_perf_rec.offer_performance_id||' '||
722: -- ' AND REQUIRED_FLAG = '||' '|| p_offer_perf_rec.REQUIRED_FLAG||''||
723: -- ' AND ESTIMATED_VALUE = '||' '|| p_offer_perf_rec.ESTIMATED_VALUE||' '||
724: -- ' AND START_DATE = '||' '|| p_offer_perf_rec.START_DATE||' '||
725: -- ' AND END_DATE = '||' '|| p_offer_perf_rec.END_DATE||' '

Line 729: ozf_utility_pvt.debug_message('inside uk middle');

725: -- ' AND END_DATE = '||' '|| p_offer_perf_rec.END_DATE||' '
726: -- );
727: l_valid_flag := FND_API.g_true;
728: END IF;
729: ozf_utility_pvt.debug_message('inside uk middle');
730: IF l_valid_flag = FND_API.g_false THEN
731: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_PERFORMANCE_ID_DUPLICATE');
732: x_return_status := FND_API.g_ret_sts_error;
733: RETURN;

Line 731: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_PERFORMANCE_ID_DUPLICATE');

727: l_valid_flag := FND_API.g_true;
728: END IF;
729: ozf_utility_pvt.debug_message('inside uk middle');
730: IF l_valid_flag = FND_API.g_false THEN
731: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_PERFORMANCE_ID_DUPLICATE');
732: x_return_status := FND_API.g_ret_sts_error;
733: RETURN;
734: END IF;
735: ozf_utility_pvt.debug_message('inside uk end');

Line 735: ozf_utility_pvt.debug_message('inside uk end');

731: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_PERFORMANCE_ID_DUPLICATE');
732: x_return_status := FND_API.g_ret_sts_error;
733: RETURN;
734: END IF;
735: ozf_utility_pvt.debug_message('inside uk end');
736: END check_offer_perf_uk_items;
737:
738: PROCEDURE check_offer_perf_req_items(
739: p_offer_perf_rec IN offer_perf_rec_type,

Line 752: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_REQ_TYPE');

748: -- ELSE
749: --END IF;
750: IF p_offer_perf_rec.channel_id = -1 THEN
751: IF p_offer_perf_rec.requirement_type IS NULL OR p_offer_perf_rec.requirement_type = fnd_api.g_miss_char THEN
752: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_REQ_TYPE');
753: x_return_status := FND_API.g_ret_sts_error;
754: END IF;
755:
756: IF p_offer_perf_rec.estimated_value IS NULL OR p_offer_perf_rec.estimated_value = fnd_api.g_miss_num THEN

Line 757: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_EST_VALUE');

753: x_return_status := FND_API.g_ret_sts_error;
754: END IF;
755:
756: IF p_offer_perf_rec.estimated_value IS NULL OR p_offer_perf_rec.estimated_value = fnd_api.g_miss_num THEN
757: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_EST_VALUE');
758: x_return_status := FND_API.g_ret_sts_error;
759: END IF;
760: END IF;
761:

Line 764: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_UOM');

760: END IF;
761:
762: IF p_offer_perf_rec.requirement_type = 'VOLUME' THEN
763: IF p_offer_perf_rec.uom_code IS NULL OR p_offer_perf_rec.uom_code = fnd_api.g_miss_char THEN
764: ozf_utility_pvt.Error_Message('OZF', 'OZF_PERF_NO_UOM');
765: x_return_status := FND_API.g_ret_sts_error;
766: END IF;
767: END IF;
768:

Line 804: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);

800: IS
801: BEGIN
802:
803: -- Check Items Uniqueness API calls
804: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);
805: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);
806:
807:
808: check_offer_perf_uk_items(

Line 805: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);

801: BEGIN
802:
803: -- Check Items Uniqueness API calls
804: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);
805: ozf_utility_pvt.debug_message('inside items validation mode='||p_validation_mode);
806:
807:
808: check_offer_perf_uk_items(
809: p_offer_perf_rec => p_offer_perf_rec,

Line 1103: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');

1099: END IF;
1100:
1101:
1102: -- Debug Message
1103: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'start');
1104:
1105:
1106: -- Initialize API return status to SUCCESS
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1111: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');

1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108:
1109:
1110: -- Debug Message
1111: ozf_utility_pvt.debug_message('Private API: ' || l_api_name || 'end');
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: FND_MSG_PUB.Count_And_Get
1115: (p_count => x_msg_count,

Line 1120: WHEN ozf_utility_pvt.resource_locked THEN

1116: p_data => x_msg_data
1117: );
1118: EXCEPTION
1119:
1120: WHEN ozf_utility_pvt.resource_locked THEN
1121: x_return_status := FND_API.g_ret_sts_error;
1122: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN

Line 1122: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1118: EXCEPTION
1119:
1120: WHEN ozf_utility_pvt.resource_locked THEN
1121: x_return_status := FND_API.g_ret_sts_error;
1122: ozf_utility_pvt.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1123:
1124: WHEN FND_API.G_EXC_ERROR THEN
1125: ROLLBACK TO VALIDATE_Offer_Performance_;
1126: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1185: ozf_utility_pvt.debug_message('Private API: Validate_dm_model_rec');

1181: -- THEN
1182: -- x_return_status := FND_API.G_RET_STS_ERROR;
1183:
1184: -- Debug Message
1185: ozf_utility_pvt.debug_message('Private API: Validate_dm_model_rec');
1186: -- Standard call to get message count and if count is 1, get message info.
1187: FND_MSG_PUB.Count_And_Get
1188: (p_count => x_msg_count,
1189: p_data => x_msg_data