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

Line 74: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

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

Line 102: OZF_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

98: -- =========================================================================
99:
100: IF FND_GLOBAL.User_Id IS NULL
101: THEN
102: OZF_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105:
106: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 109: OZF_UTILITY_PVT.debug_message('Private API: Validate_Adj_New_Prod');

105:
106: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
107: THEN
108: -- Debug message
109: OZF_UTILITY_PVT.debug_message('Private API: Validate_Adj_New_Prod');
110:
111: -- Invoke validation procedures
112: Validate_adj_new_prod(
113: p_api_version_number => 1.0,

Line 129: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

125: END IF;
126:
127:
128: -- Debug Message
129: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
130:
131: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row)
132: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Insert_Row(
133: px_offer_adj_new_product_id => l_offer_adj_new_product_id,

Line 163: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

159: END IF;
160:
161:
162: -- Debug Message
163: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: (p_count => x_msg_count,

Line 172: WHEN OZF_UTILITY_PVT.resource_locked THEN

168: p_data => x_msg_data
169: );
170: EXCEPTION
171:
172: WHEN OZF_UTILITY_PVT.resource_locked THEN
173: x_return_status := FND_API.g_ret_sts_error;
174: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
175:
176: WHEN FND_API.G_EXC_ERROR THEN

Line 174: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

170: EXCEPTION
171:
172: WHEN OZF_UTILITY_PVT.resource_locked THEN
173: x_return_status := FND_API.g_ret_sts_error;
174: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO CREATE_Adj_New_Prod_PVT;
178: x_return_status := FND_API.G_RET_STS_ERROR;

Line 262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: -- Debug Message
262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265: -- Debug Message
266: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line 266: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265: -- Debug Message
266: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
267: OPEN c_get_Adj_New_Prod( l_tar_adj_new_prod_rec.offer_adj_new_product_id , l_tar_adj_new_prod_rec.object_version_number);
268: FETCH c_get_Adj_New_Prod INTO l_ref_adj_new_prod_rec ;
269: If ( c_get_Adj_New_Prod%NOTFOUND) THEN
270: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

Line 270: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

266: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
267: OPEN c_get_Adj_New_Prod( l_tar_adj_new_prod_rec.offer_adj_new_product_id , l_tar_adj_new_prod_rec.object_version_number);
268: FETCH c_get_Adj_New_Prod INTO l_ref_adj_new_prod_rec ;
269: If ( c_get_Adj_New_Prod%NOTFOUND) THEN
270: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
271: p_token_name => 'INFO',
272: p_token_value => 'Adj_New_Prod') ;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;

Line 276: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

272: p_token_value => 'Adj_New_Prod') ;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: -- Debug Message
276: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
277: CLOSE c_get_Adj_New_Prod;
278:
279: If (l_tar_adj_new_prod_rec.object_version_number is NULL or
280: l_tar_adj_new_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then

Line 281: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

277: CLOSE c_get_Adj_New_Prod;
278:
279: If (l_tar_adj_new_prod_rec.object_version_number is NULL or
280: l_tar_adj_new_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then
281: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
282: p_token_name => 'COLUMN',
283: p_token_value => 'Last_Update_Date') ;
284: raise FND_API.G_EXC_ERROR;
285: End if;

Line 288: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

284: raise FND_API.G_EXC_ERROR;
285: End if;
286: -- Check Whether record has been changed by someone else
287: If (l_tar_adj_new_prod_rec.object_version_number <> l_ref_adj_new_prod_rec.object_version_number) Then
288: OZF_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
289: p_token_name => 'INFO',
290: p_token_value => 'Adj_New_Prod') ;
291: raise FND_API.G_EXC_ERROR;
292: End if;

Line 296: OZF_UTILITY_PVT.debug_message('Private API: Validate_Adj_New_Prod');

292: End if;
293: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
294: THEN
295: -- Debug message
296: OZF_UTILITY_PVT.debug_message('Private API: Validate_Adj_New_Prod');
297: -- Invoke validation procedures
298: Validate_adj_new_prod(
299: p_api_version_number => 1.0,
300: p_init_msg_list => FND_API.G_FALSE,

Line 338: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

334: THEN
335: COMMIT WORK;
336: END IF;
337: -- Debug Message
338: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
339:
340: -- Standard call to get message count and if count is 1, get message info.
341: FND_MSG_PUB.Count_And_Get
342: (p_count => x_msg_count,

Line 347: WHEN OZF_UTILITY_PVT.resource_locked THEN

343: p_data => x_msg_data
344: );
345: EXCEPTION
346:
347: WHEN OZF_UTILITY_PVT.resource_locked THEN
348: x_return_status := FND_API.g_ret_sts_error;
349: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
350:
351: WHEN FND_API.G_EXC_ERROR THEN

Line 349: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

345: EXCEPTION
346:
347: WHEN OZF_UTILITY_PVT.resource_locked THEN
348: x_return_status := FND_API.g_ret_sts_error;
349: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
350:
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO UPDATE_Adj_New_Prod_PVT;
353: x_return_status := FND_API.G_RET_STS_ERROR;

Line 423: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

419: THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422: -- Debug Message
423: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
424: -- Initialize API return status to SUCCESS
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426: --
427: -- Api body

Line 430: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

426: --
427: -- Api body
428: --
429: -- Debug Message
430: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
431: -- Invoke table handler(OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row)
432: OZF_OFFER_ADJ_NEW_PRODUCTS_PKG.Delete_Row(
433: p_OFFER_ADJ_NEW_PRODUCT_ID => p_OFFER_ADJ_NEW_PRODUCT_ID);
434: --

Line 443: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

439: THEN
440: COMMIT WORK;
441: END IF;
442: -- Debug Message
443: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count,
447: p_data => x_msg_data

Line 451: WHEN OZF_UTILITY_PVT.resource_locked THEN

447: p_data => x_msg_data
448: );
449: EXCEPTION
450:
451: WHEN OZF_UTILITY_PVT.resource_locked THEN
452: x_return_status := FND_API.g_ret_sts_error;
453: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
454:
455: WHEN FND_API.G_EXC_ERROR THEN

Line 453: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

449: EXCEPTION
450:
451: WHEN OZF_UTILITY_PVT.resource_locked THEN
452: x_return_status := FND_API.g_ret_sts_error;
453: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO DELETE_Adj_New_Prod_PVT;
457: x_return_status := FND_API.G_RET_STS_ERROR;

Line 518: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

514:
515: BEGIN
516:
517: -- Debug Message
518: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
519:
520: -- Initialize message list if p_init_msg_list is set to TRUE.
521: IF FND_API.to_Boolean( p_init_msg_list )
522: THEN

Line 540: OZF_UTILITY_PVT.debug_message(l_full_name||': start');

536: -- Initialize API return status to SUCCESS
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538: ------------------------ lock -------------------------
539:
540: OZF_UTILITY_PVT.debug_message(l_full_name||': start');
541: OPEN c_Adj_New_Prod;
542:
543: FETCH c_Adj_New_Prod INTO l_OFFER_ADJ_NEW_PRODUCT_ID;
544:

Line 560: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');

556: FND_MSG_PUB.count_and_get(
557: p_encoded => FND_API.g_false,
558: p_count => x_msg_count,
559: p_data => x_msg_data);
560: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
561: EXCEPTION
562:
563: WHEN OZF_UTILITY_PVT.resource_locked THEN
564: x_return_status := FND_API.g_ret_sts_error;

Line 563: WHEN OZF_UTILITY_PVT.resource_locked THEN

559: p_data => x_msg_data);
560: OZF_UTILITY_PVT.debug_message(l_full_name ||': end');
561: EXCEPTION
562:
563: WHEN OZF_UTILITY_PVT.resource_locked THEN
564: x_return_status := FND_API.g_ret_sts_error;
565: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
566:
567: WHEN FND_API.G_EXC_ERROR THEN

Line 565: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

561: EXCEPTION
562:
563: WHEN OZF_UTILITY_PVT.resource_locked THEN
564: x_return_status := FND_API.g_ret_sts_error;
565: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
566:
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO LOCK_Adj_New_Prod_PVT;
569: x_return_status := FND_API.G_RET_STS_ERROR;

Line 613: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(

609:
610: BEGIN
611: x_return_status := FND_API.g_ret_sts_success;
612: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
613: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
614: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
615: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||''''
616: );
617: ELSE

Line 618: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(

614: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
615: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||''''
616: );
617: ELSE
618: l_valid_flag := OZF_UTILITY_PVT.check_uniqueness(
619: 'OZF_OFFER_ADJ_NEW_PRODUCTS',
620: 'OFFER_ADJ_NEW_PRODUCT_ID = ''' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID ||
621: ''' AND OFFER_ADJ_NEW_PRODUCT_ID <> ' || p_adj_new_prod_rec.OFFER_ADJ_NEW_PRODUCT_ID
622: );

Line 626: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_OFFER_ADJ_NEW_PRODUCT_ID_DUPLICATE');

622: );
623: END IF;
624:
625: IF l_valid_flag = FND_API.g_false THEN
626: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_OFFER_ADJ_NEW_PRODUCT_ID_DUPLICATE');
627: x_return_status := FND_API.g_ret_sts_error;
628: RETURN;
629: END IF;
630:

Line 641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);

637: )
638: IS
639: BEGIN
640: x_return_status := FND_API.g_ret_sts_success;
641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);
642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);
643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
644: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.g_miss_num OR p_adj_new_prod_rec.offer_adj_new_line_id IS NULL THEN
645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );

Line 642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);

638: IS
639: BEGIN
640: x_return_status := FND_API.g_ret_sts_success;
641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);
642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);
643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
644: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.g_miss_num OR p_adj_new_prod_rec.offer_adj_new_line_id IS NULL THEN
645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );
646: x_return_status := FND_API.g_ret_sts_error;

Line 645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );

641: ozf_utility_pvt.debug_message('Validation Mode is:'||p_validation_mode||' : '||JTF_PLSQL_API.g_create);
642: ozf_utility_pvt.debug_message('Product Ctx is :'||p_adj_new_prod_rec.product_context);
643: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
644: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.g_miss_num OR p_adj_new_prod_rec.offer_adj_new_line_id IS NULL THEN
645: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );
646: x_return_status := FND_API.g_ret_sts_error;
647: RETURN;
648: END IF;
649: IF p_adj_new_prod_rec.excluder_flag = FND_API.g_miss_char OR p_adj_new_prod_rec.excluder_flag IS NULL THEN

Line 650: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'excluder_flag' );

646: x_return_status := FND_API.g_ret_sts_error;
647: RETURN;
648: END IF;
649: IF p_adj_new_prod_rec.excluder_flag = FND_API.g_miss_char OR p_adj_new_prod_rec.excluder_flag IS NULL THEN
650: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'excluder_flag' );
651: x_return_status := FND_API.g_ret_sts_error;
652: RETURN;
653: END IF;
654: IF p_adj_new_prod_rec.product_context = FND_API.g_miss_char OR p_adj_new_prod_rec.product_context IS NULL THEN

Line 655: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_context' );

651: x_return_status := FND_API.g_ret_sts_error;
652: RETURN;
653: END IF;
654: IF p_adj_new_prod_rec.product_context = FND_API.g_miss_char OR p_adj_new_prod_rec.product_context IS NULL THEN
655: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_context' );
656: x_return_status := FND_API.g_ret_sts_error;
657: RETURN;
658: END IF;
659: IF p_adj_new_prod_rec.product_attribute = FND_API.g_miss_char OR p_adj_new_prod_rec.product_attribute IS NULL THEN

Line 660: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attribute' );

656: x_return_status := FND_API.g_ret_sts_error;
657: RETURN;
658: END IF;
659: IF p_adj_new_prod_rec.product_attribute = FND_API.g_miss_char OR p_adj_new_prod_rec.product_attribute IS NULL THEN
660: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attribute' );
661: x_return_status := FND_API.g_ret_sts_error;
662: RETURN;
663: END IF;
664: IF p_adj_new_prod_rec.product_attr_value = FND_API.g_miss_char OR p_adj_new_prod_rec.product_attr_value IS NULL THEN

Line 665: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attr_value' );

661: x_return_status := FND_API.g_ret_sts_error;
662: RETURN;
663: END IF;
664: IF p_adj_new_prod_rec.product_attr_value = FND_API.g_miss_char OR p_adj_new_prod_rec.product_attr_value IS NULL THEN
665: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attr_value' );
666: x_return_status := FND_API.g_ret_sts_error;
667: RETURN;
668: END IF;
669:

Line 672: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adjustment_id' );

668: END IF;
669:
670: -- IF p_adj_new_prod_rec.offer_type = 'VOLUME_OFFER' THEN
671: IF p_adj_new_prod_rec.offer_adjustment_id IS NULL OR p_adj_new_prod_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
672: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adjustment_id' );
673: x_return_status := FND_API.g_ret_sts_error;
674: RETURN;
675: END IF;
676: -- END IF;

Line 680: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_product_id' );

676: -- END IF;
677:
678: ELSE
679: IF p_adj_new_prod_rec.offer_adj_new_product_id = FND_API.G_MISS_NUM THEN
680: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_product_id' );
681: x_return_status := FND_API.g_ret_sts_error;
682: RETURN;
683: END IF;
684: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.G_MISS_NUM THEN

Line 685: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );

681: x_return_status := FND_API.g_ret_sts_error;
682: RETURN;
683: END IF;
684: IF p_adj_new_prod_rec.offer_adj_new_line_id = FND_API.G_MISS_NUM THEN
685: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adj_new_line_id' );
686: x_return_status := FND_API.g_ret_sts_error;
687: RETURN;
688: END IF;
689: IF p_adj_new_prod_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 690: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'excluder_flag' );

686: x_return_status := FND_API.g_ret_sts_error;
687: RETURN;
688: END IF;
689: IF p_adj_new_prod_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
690: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'excluder_flag' );
691: x_return_status := FND_API.g_ret_sts_error;
692: RETURN;
693: END IF;
694: IF p_adj_new_prod_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 695: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'object_version_number' );

691: x_return_status := FND_API.g_ret_sts_error;
692: RETURN;
693: END IF;
694: IF p_adj_new_prod_rec.object_version_number = FND_API.G_MISS_NUM THEN
695: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'object_version_number' );
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698: END IF;
699:

Line 701: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_context' );

697: RETURN;
698: END IF;
699:
700: IF p_adj_new_prod_rec.product_context = FND_API.g_miss_char THEN
701: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_context' );
702: x_return_status := FND_API.g_ret_sts_error;
703: RETURN;
704: END IF;
705: IF p_adj_new_prod_rec.product_attribute = FND_API.g_miss_char THEN

Line 706: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attribute' );

702: x_return_status := FND_API.g_ret_sts_error;
703: RETURN;
704: END IF;
705: IF p_adj_new_prod_rec.product_attribute = FND_API.g_miss_char THEN
706: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attribute' );
707: x_return_status := FND_API.g_ret_sts_error;
708: RETURN;
709: END IF;
710: IF p_adj_new_prod_rec.product_attr_value = FND_API.g_miss_char THEN

Line 711: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attr_value' );

707: x_return_status := FND_API.g_ret_sts_error;
708: RETURN;
709: END IF;
710: IF p_adj_new_prod_rec.product_attr_value = FND_API.g_miss_char THEN
711: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'product_attr_value' );
712: x_return_status := FND_API.g_ret_sts_error;
713: RETURN;
714: END IF;
715:

Line 718: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adjustment_id' );

714: END IF;
715:
716: -- IF p_adj_new_prod_rec.offer_type = 'VOLUME_OFFER' THEN
717: IF p_adj_new_prod_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
718: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'offer_adjustment_id' );
719: x_return_status := FND_API.g_ret_sts_error;
720: RETURN;
721: END IF;
722: -- END IF;

Line 733: ozf_utility_pvt.debug_message('Offer Type is :'||p_adj_new_prod_rec.offer_type);

729: )
730: IS
731: BEGIN
732: x_return_status := FND_API.g_ret_sts_success;
733: ozf_utility_pvt.debug_message('Offer Type is :'||p_adj_new_prod_rec.offer_type);
734: IF p_adj_new_prod_rec.offer_type <> 'VOLUME_OFFER' THEN
735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN
736: OZF_Utility_PVT.Error_Message('OZF_INVALID_ADJ_LINE_ID' );
737: x_return_status := FND_API.g_ret_sts_error;

Line 735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN

731: BEGIN
732: x_return_status := FND_API.g_ret_sts_success;
733: ozf_utility_pvt.debug_message('Offer Type is :'||p_adj_new_prod_rec.offer_type);
734: IF p_adj_new_prod_rec.offer_type <> 'VOLUME_OFFER' THEN
735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN
736: OZF_Utility_PVT.Error_Message('OZF_INVALID_ADJ_LINE_ID' );
737: x_return_status := FND_API.g_ret_sts_error;
738: return;
739: END IF;

Line 736: OZF_Utility_PVT.Error_Message('OZF_INVALID_ADJ_LINE_ID' );

732: x_return_status := FND_API.g_ret_sts_success;
733: ozf_utility_pvt.debug_message('Offer Type is :'||p_adj_new_prod_rec.offer_type);
734: IF p_adj_new_prod_rec.offer_type <> 'VOLUME_OFFER' THEN
735: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJ_NEW_LINES','OFFER_ADJ_NEW_LINE_ID',to_char(p_adj_new_prod_rec.OFFER_ADJ_NEW_LINE_ID)) = FND_API.g_false THEN
736: OZF_Utility_PVT.Error_Message('OZF_INVALID_ADJ_LINE_ID' );
737: x_return_status := FND_API.g_ret_sts_error;
738: return;
739: END IF;
740: END IF;

Line 742: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_prod_rec.offer_adjustment_id)) = FND_API.g_false THEN

738: return;
739: END IF;
740: END IF;
741: IF p_adj_new_prod_rec.offer_adjustment_id IS NOT NULL AND p_adj_new_prod_rec.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
742: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_prod_rec.offer_adjustment_id)) = FND_API.g_false THEN
743: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ADJ_ID' );
744: x_return_status := FND_API.g_ret_sts_error;
745: return;
746: END IF;

Line 743: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ADJ_ID' );

739: END IF;
740: END IF;
741: IF p_adj_new_prod_rec.offer_adjustment_id IS NOT NULL AND p_adj_new_prod_rec.offer_adjustment_id <> FND_API.G_MISS_NUM THEN
742: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_ADJUSTMENTS_B','OFFER_ADJUSTMENT_ID',to_char(p_adj_new_prod_rec.offer_adjustment_id)) = FND_API.g_false THEN
743: OZF_Utility_PVT.Error_Message('OZF_INVALID_OFFER_ADJ_ID' );
744: x_return_status := FND_API.g_ret_sts_error;
745: return;
746: END IF;
747: END IF;

Line 864: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );

860: IF l_volumeType.parent_adj_line_id IS NULL AND l_volumeType.volume_type = 'PRICING_ATTRIBUTE10' THEN
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR OR p_adj_new_prod_rec.uom_code IS NULL
863: THEN
864: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );
865: x_return_status := FND_API.g_ret_sts_error;
866: return;
867: END IF;
868: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 870: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );

866: return;
867: END IF;
868: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
869: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR THEN
870: OZF_Utility_PVT.Error_Message('OZF_UOM_QTY_REQD' );
871: x_return_status := FND_API.g_ret_sts_error;
872: return;
873: END IF;
874: END IF;

Line 887: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );

883:
884: IF l_listLineType = 'PBH' THEN
885: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
886: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR OR p_adj_new_prod_rec.uom_code IS NULL THEN
887: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );
888: x_return_status := FND_API.g_ret_sts_error;
889: return;
890: END IF;
891: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 893: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );

889: return;
890: END IF;
891: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
892: IF p_adj_new_prod_rec.uom_code = FND_API.G_MISS_CHAR THEN
893: OZF_Utility_PVT.Error_Message('OZF_PBH_UOM_REQD' );
894: x_return_status := FND_API.g_ret_sts_error;
895: return;
896: END IF;
897: END IF;

Line 1176: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1172: END IF;
1173:
1174:
1175: -- Debug Message
1176: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1177:
1178:
1179: -- Initialize API return status to SUCCESS
1180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1184: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1180: x_return_status := FND_API.G_RET_STS_SUCCESS;
1181:
1182:
1183: -- Debug Message
1184: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1185:
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,

Line 1193: WHEN OZF_UTILITY_PVT.resource_locked THEN

1189: p_data => x_msg_data
1190: );
1191: EXCEPTION
1192:
1193: WHEN OZF_UTILITY_PVT.resource_locked THEN
1194: x_return_status := FND_API.g_ret_sts_error;
1195: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN

Line 1195: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1191: EXCEPTION
1192:
1193: WHEN OZF_UTILITY_PVT.resource_locked THEN
1194: x_return_status := FND_API.g_ret_sts_error;
1195: OZF_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: ROLLBACK TO VALIDATE_Adj_New_Prod_;
1199: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1258: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1254: -- THEN
1255: -- x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: -- Debug Message
1258: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1259: -- Standard call to get message count and if count is 1, get message info.
1260: FND_MSG_PUB.Count_And_Get
1261: (p_count => x_msg_count,
1262: p_data => x_msg_data