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_RESALE_PUB 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_PUB';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfprssb.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: ---------------------------------------------------------------------
17: -- PROCEDURE

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_PUB';
11: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfprssb.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: ---------------------------------------------------------------------
17: -- PROCEDURE
18: -- Start_Process_Iface

Line 69: FND_MSG_PUB.initialize;

65: END IF;
66:
67: --Initialize message list if p_init_msg_list is TRUE.
68: IF FND_API.To_Boolean (p_init_msg_list) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Debug Message
73: IF OZF_DEBUG_LOW_ON THEN

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

82: FETCH csr_batch_org_id INTO l_resale_org_id;
83: CLOSE csr_batch_org_id;
84:
85: IF l_resale_org_id IS NULL THEN
86: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
87: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
88: FND_MSG_PUB.add;
89: END IF;
90: RAISE FND_API.g_exc_error;

Line 88: FND_MSG_PUB.add;

84:
85: IF l_resale_org_id IS NULL THEN
86: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
87: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
88: FND_MSG_PUB.add;
89: END IF;
90: RAISE FND_API.g_exc_error;
91: END IF;
92:

Line 116: FND_MSG_PUB.Count_And_Get (

112: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
113: END IF;
114:
115: --Standard call to get message count and if count=1, get the message
116: FND_MSG_PUB.Count_And_Get (
117: p_encoded => FND_API.G_FALSE,
118: p_count => x_msg_count,
119: p_data => x_msg_data
120: );

Line 126: FND_MSG_PUB.Count_And_Get (

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO PROCESS_IFACE_PUB;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get (
127: p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data
130: );

Line 134: FND_MSG_PUB.Count_And_Get (

130: );
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO PROCESS_IFACE_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );

Line 142: FND_MSG_PUB.Count_And_Get (

138: );
139: WHEN OTHERS THEN
140: ROLLBACK TO PROCESS_IFACE_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.Count_And_Get (
143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data
146: );

Line 205: FND_MSG_PUB.initialize;

201: END IF;
202:
203: --Initialize message list if p_init_msg_list is TRUE.
204: IF FND_API.To_Boolean (p_init_msg_list) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: -- Debug Message
209: IF OZF_DEBUG_LOW_ON THEN

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

218: FETCH csr_batch_org_id INTO l_resale_org_id;
219: CLOSE csr_batch_org_id;
220:
221: IF l_resale_org_id IS NULL THEN
222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
223: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
224: FND_MSG_PUB.add;
225: END IF;
226: RAISE FND_API.g_exc_error;

Line 224: FND_MSG_PUB.add;

220:
221: IF l_resale_org_id IS NULL THEN
222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
223: FND_MESSAGE.set_name('OZF', 'OZF_ORG_ID_NOTFOUND');
224: FND_MSG_PUB.add;
225: END IF;
226: RAISE FND_API.g_exc_error;
227: END IF;
228:

Line 253: FND_MSG_PUB.Count_And_Get (

249: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': end');
250: END IF;
251:
252: --Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,
256: p_data => x_msg_data
257: );

Line 263: FND_MSG_PUB.Count_And_Get (

259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO BATCH_PAYMENT_PUB;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get (
264: p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data
267: );

Line 271: FND_MSG_PUB.Count_And_Get (

267: );
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO BATCH_PAYMENT_PUB;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );

Line 279: FND_MSG_PUB.Count_And_Get (

275: );
276: WHEN OTHERS THEN
277: ROLLBACK TO BATCH_PAYMENT_PUB;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );

Line 334: FND_MSG_PUB.initialize;

330: END IF;
331:
332: --Initialize message list if p_init_msg_list is TRUE.
333: IF FND_API.To_Boolean (p_init_msg_list) THEN
334: FND_MSG_PUB.initialize;
335: END IF;
336:
337: -- Debug Message
338: IF OZF_DEBUG_LOW_ON THEN

Line 370: FND_MSG_PUB.Count_And_Get (

366: IF OZF_DEBUG_LOW_ON THEN
367: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
368: END IF;
369: --Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );

Line 380: FND_MSG_PUB.Count_And_Get (

376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO RESALE_PURGE_PUB ;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: FND_MSG_PUB.Count_And_Get (
381: p_encoded => FND_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data
384: );

Line 388: FND_MSG_PUB.Count_And_Get (

384: );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK TO RESALE_PURGE_PUB;
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );

Line 396: FND_MSG_PUB.Count_And_Get (

392: );
393: WHEN OTHERS THEN
394: ROLLBACK TO RESALE_PURGE_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data
400: );

Line 619: FND_MSG_PUB.initialize;

615: END IF;
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE.
618: IF FND_API.to_Boolean( p_init_msg_list ) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Debug Message
623: IF OZF_DEBUG_HIGH_ON THEN

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

635: END IF;
636:
637: --//1.resale_batch_id
638: IF l_resale_util_rec.resale_batch_id IS NULL OR l_resale_util_rec.resale_batch_id = FND_API.g_miss_num THEN
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('OZF', 'OZF_NO_RESALE_BATCH_ID');
641: --//Resale batch Identifier is mandatory.Please provide a valid Resale Batch Identifier.
642: FND_MSG_PUB.add;
643: END IF;

Line 642: FND_MSG_PUB.add;

638: IF l_resale_util_rec.resale_batch_id IS NULL OR l_resale_util_rec.resale_batch_id = FND_API.g_miss_num THEN
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
640: FND_MESSAGE.set_name('OZF', 'OZF_NO_RESALE_BATCH_ID');
641: --//Resale batch Identifier is mandatory.Please provide a valid Resale Batch Identifier.
642: FND_MSG_PUB.add;
643: END IF;
644: x_return_status := fnd_api.g_ret_sts_error;
645: RETURN;
646: ELSE

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

648: FETCH c_resale_batch_id INTO l_resale_batch_id,l_batch_currency_code,l_batch_org_id;
649: CLOSE c_resale_batch_id;
650:
651: IF l_resale_batch_id IS NULL THEN
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
653: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RESALE_BATCH_ID');
654: --//Resale batch Identifier provided is Invalid.Please provide a valid Resale Batch Identifier.
655: FND_MSG_PUB.add;
656: END IF;

Line 655: FND_MSG_PUB.add;

651: IF l_resale_batch_id IS NULL THEN
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
653: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RESALE_BATCH_ID');
654: --//Resale batch Identifier provided is Invalid.Please provide a valid Resale Batch Identifier.
655: FND_MSG_PUB.add;
656: END IF;
657: x_return_status := fnd_api.g_ret_sts_error;
658: RETURN;
659: END IF;

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

660: END IF;
661:
662: --//2.resale_line_id
663: IF l_resale_util_rec.resale_line_id IS NULL OR l_resale_util_rec.resale_line_id = FND_API.g_miss_num THEN
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_NO_RESALE_LINE_ID');
666: --//Resale Line Identifier is mandatory.Please provide a valid Resale Line Identifier.
667: FND_MSG_PUB.add;
668: END IF;

Line 667: FND_MSG_PUB.add;

663: IF l_resale_util_rec.resale_line_id IS NULL OR l_resale_util_rec.resale_line_id = FND_API.g_miss_num THEN
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('OZF', 'OZF_NO_RESALE_LINE_ID');
666: --//Resale Line Identifier is mandatory.Please provide a valid Resale Line Identifier.
667: FND_MSG_PUB.add;
668: END IF;
669: x_return_status := fnd_api.g_ret_sts_error;
670: RETURN;
671: ELSE

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

673: FETCH c_get_resale_lines INTO l_resale_line_rec;
674:
675: IF c_get_resale_lines%NOTFOUND THEN
676: --OZF_UTILITY_PVT.debug_message('INSIDE '||l_resale_line_rec.resale_line_id);
677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
678: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RESALE_LINE_ID');
679: --//Resale Line Identifier provided is invalid.Please provide a valid Resale Line Identifier.
680: FND_MSG_PUB.add;
681: END IF;

Line 680: FND_MSG_PUB.add;

676: --OZF_UTILITY_PVT.debug_message('INSIDE '||l_resale_line_rec.resale_line_id);
677: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
678: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_RESALE_LINE_ID');
679: --//Resale Line Identifier provided is invalid.Please provide a valid Resale Line Identifier.
680: FND_MSG_PUB.add;
681: END IF;
682: x_return_status := fnd_api.g_ret_sts_error;
683: RETURN;
684: END IF;

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

687: END IF;
688:
689: --//3.list_header_id
690: IF l_resale_util_rec.list_header_id IS NULL OR l_resale_util_rec.list_header_id = FND_API.g_miss_num THEN
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
692: FND_MESSAGE.set_name('OZF', 'OZF_NO_LIST_HEADER_ID');
693: --//List Header Identifier is mandatory.Please provide a valid List Header Identifier.
694: FND_MSG_PUB.add;
695: END IF;

Line 694: FND_MSG_PUB.add;

690: IF l_resale_util_rec.list_header_id IS NULL OR l_resale_util_rec.list_header_id = FND_API.g_miss_num THEN
691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
692: FND_MESSAGE.set_name('OZF', 'OZF_NO_LIST_HEADER_ID');
693: --//List Header Identifier is mandatory.Please provide a valid List Header Identifier.
694: FND_MSG_PUB.add;
695: END IF;
696: x_return_status := fnd_api.g_ret_sts_error;
697: RETURN;
698: ELSE

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

700: OPEN c_get_offer_details(l_resale_util_rec.list_header_id);
701: FETCH c_get_offer_details INTO l_offer_type, l_custom_setup_id,l_offer_currency_code,l_qp_org_id,l_offer_name,l_status_code;
702:
703: IF c_get_offer_details%NOTFOUND THEN
704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
705: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_LIST_HEADER_ID');
706: --//List Header Identifier provided is invalid.Please provide a valid List Header Identifier.
707: FND_MSG_PUB.add;
708: END IF;

Line 707: FND_MSG_PUB.add;

703: IF c_get_offer_details%NOTFOUND THEN
704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
705: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_LIST_HEADER_ID');
706: --//List Header Identifier provided is invalid.Please provide a valid List Header Identifier.
707: FND_MSG_PUB.add;
708: END IF;
709: x_return_status := fnd_api.g_ret_sts_error;
710: RETURN;
711: END IF;

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

713: END IF;
714:
715: --//Offer type Validation
716: IF l_offer_type NOT IN ('ACCRUAL','OFF_INVOICE','VOLUME_OFFER','OID','DEAL','ORDER') THEN
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
718: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_TYPE_UNSUPPORTED');
719: --//Offer type of the provided offer is not supported to create resale utilization.
720: FND_MSG_PUB.add;
721: END IF;

Line 720: FND_MSG_PUB.add;

716: IF l_offer_type NOT IN ('ACCRUAL','OFF_INVOICE','VOLUME_OFFER','OID','DEAL','ORDER') THEN
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
718: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_TYPE_UNSUPPORTED');
719: --//Offer type of the provided offer is not supported to create resale utilization.
720: FND_MSG_PUB.add;
721: END IF;
722: x_return_status := fnd_api.g_ret_sts_error;
723: RETURN;
724: END IF;

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

724: END IF;
725:
726: --//Status code validation - Only ACTIVE offers are eligible to create utilization
727: IF l_status_code <> 'ACTIVE' THEN
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_STATUS_UNSUPPORTED');
730: --//Offer should be in Active status to create resale utilization.
731: FND_MSG_PUB.add;
732: END IF;

Line 731: FND_MSG_PUB.add;

727: IF l_status_code <> 'ACTIVE' THEN
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_STATUS_UNSUPPORTED');
730: --//Offer should be in Active status to create resale utilization.
731: FND_MSG_PUB.add;
732: END IF;
733: x_return_status := fnd_api.g_ret_sts_error;
734: RETURN;
735: END IF;

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

737:
738: --//If Offer currency code is not null, it should match with resale header currency code
739: IF l_offer_currency_code IS NOT NULL THEN
740: IF l_offer_currency_code <> l_batch_currency_code THEN
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
742: FND_MESSAGE.set_name('OZF', 'OZF_BATCH_CURR_MISMATCH');
743: --//Offer Currecy Code should be same as Resale batch Currency Code.
744: FND_MSG_PUB.add;
745: END IF;

Line 744: FND_MSG_PUB.add;

740: IF l_offer_currency_code <> l_batch_currency_code THEN
741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
742: FND_MESSAGE.set_name('OZF', 'OZF_BATCH_CURR_MISMATCH');
743: --//Offer Currecy Code should be same as Resale batch Currency Code.
744: FND_MSG_PUB.add;
745: END IF;
746: x_return_status := fnd_api.g_ret_sts_error;
747: RETURN;
748: END IF;

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

750:
751: --//If Offer org_id is not null, it should match with resale header Org_id
752: IF l_qp_org_id IS NOT NULL THEN
753: IF l_qp_org_id <> l_batch_org_id THEN
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
755: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_ORG_MISMATCH');
756: --//Offer Organization Identifier should be same as Resale batch Organization Identifier.
757: FND_MSG_PUB.add;
758: END IF;

Line 757: FND_MSG_PUB.add;

753: IF l_qp_org_id <> l_batch_org_id THEN
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
755: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_ORG_MISMATCH');
756: --//Offer Organization Identifier should be same as Resale batch Organization Identifier.
757: FND_MSG_PUB.add;
758: END IF;
759: x_return_status := fnd_api.g_ret_sts_error;
760: RETURN;
761: END IF;

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

762: END IF;
763:
764: --//4.list_line_id
765: IF l_resale_util_rec.list_line_id IS NULL OR l_resale_util_rec.list_line_id = FND_API.g_miss_num THEN
766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
767: FND_MESSAGE.set_name('OZF', 'OZF_NO_LIST_LINE_ID');
768: --//List Line Identifier is mandatory.Please provide a valid List Line Identifier.
769: FND_MSG_PUB.add;
770: END IF;

Line 769: FND_MSG_PUB.add;

765: IF l_resale_util_rec.list_line_id IS NULL OR l_resale_util_rec.list_line_id = FND_API.g_miss_num THEN
766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
767: FND_MESSAGE.set_name('OZF', 'OZF_NO_LIST_LINE_ID');
768: --//List Line Identifier is mandatory.Please provide a valid List Line Identifier.
769: FND_MSG_PUB.add;
770: END IF;
771: x_return_status := fnd_api.g_ret_sts_error;
772: RETURN;
773: ELSE

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

775: FETCH c_list_line INTO l_list_line_id,l_arithmetic_operator;
776: CLOSE c_list_line;
777:
778: IF l_list_line_id IS NULL THEN
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
780: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_LIST_LINE_ID');
781: --//List Line Identifier provided is invalid.Please provide a valid List Line Identifier.
782: FND_MSG_PUB.add;
783: END IF;

Line 782: FND_MSG_PUB.add;

778: IF l_list_line_id IS NULL THEN
779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
780: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_LIST_LINE_ID');
781: --//List Line Identifier provided is invalid.Please provide a valid List Line Identifier.
782: FND_MSG_PUB.add;
783: END IF;
784: x_return_status := fnd_api.g_ret_sts_error;
785: RETURN;
786: END IF;

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

791: FETCH line_adjustment_csr INTO l_result;
792: CLOSE line_adjustment_csr;
793:
794: IF l_result IS NOT NULL THEN
795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
796: FND_MESSAGE.set_name('OZF', 'OZF_DUP_RESALE_ACCRUAL');
797: --//Utilization is already created for provided list header and line combination
798: FND_MSG_PUB.add;
799: END IF;

Line 798: FND_MSG_PUB.add;

794: IF l_result IS NOT NULL THEN
795: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
796: FND_MESSAGE.set_name('OZF', 'OZF_DUP_RESALE_ACCRUAL');
797: --//Utilization is already created for provided list header and line combination
798: FND_MSG_PUB.add;
799: END IF;
800: x_return_status := fnd_api.g_ret_sts_error;
801: RETURN;
802: END IF;

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

802: END IF;
803:
804: --//5.accepted_amount
805: IF l_resale_util_rec.accepted_amount IS NULL OR l_resale_util_rec.accepted_amount = FND_API.g_miss_num THEN
806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
807: FND_MESSAGE.set_name('OZF', 'OZF_NO_ACCEPTED_AMOUNT');
808: --//Accepted Amount is mandatory.Please provide a valid Accepted Amount.
809: FND_MSG_PUB.add;
810: END IF;

Line 809: FND_MSG_PUB.add;

805: IF l_resale_util_rec.accepted_amount IS NULL OR l_resale_util_rec.accepted_amount = FND_API.g_miss_num THEN
806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
807: FND_MESSAGE.set_name('OZF', 'OZF_NO_ACCEPTED_AMOUNT');
808: --//Accepted Amount is mandatory.Please provide a valid Accepted Amount.
809: FND_MSG_PUB.add;
810: END IF;
811: x_return_status := fnd_api.g_ret_sts_error;
812: RETURN;
813: END IF;

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

813: END IF;
814:
815: --//7.priced_quantity
816: IF l_resale_util_rec.quantity IS NULL OR l_resale_util_rec.quantity = FND_API.g_miss_num THEN
817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
818: FND_MESSAGE.set_name('OZF', 'OZF_NO_PRICED_QUANTITY');
819: --//Priced Quantity is mandatory.Please provide a valid Priced Quantity.
820: FND_MSG_PUB.add;
821: END IF;

Line 820: FND_MSG_PUB.add;

816: IF l_resale_util_rec.quantity IS NULL OR l_resale_util_rec.quantity = FND_API.g_miss_num THEN
817: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
818: FND_MESSAGE.set_name('OZF', 'OZF_NO_PRICED_QUANTITY');
819: --//Priced Quantity is mandatory.Please provide a valid Priced Quantity.
820: FND_MSG_PUB.add;
821: END IF;
822: x_return_status := fnd_api.g_ret_sts_error;
823: RETURN;
824: END IF;

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

824: END IF;
825:
826: --//8. operand
827: IF l_resale_util_rec.discount_value IS NULL OR l_resale_util_rec.discount_value = FND_API.g_miss_num THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('OZF', 'OZF_NO_DISCOUNT_VALUE');
830: --//Discount value is mandatory.Please provide a valid Discount value.
831: FND_MSG_PUB.add;
832: END IF;

Line 831: FND_MSG_PUB.add;

827: IF l_resale_util_rec.discount_value IS NULL OR l_resale_util_rec.discount_value = FND_API.g_miss_num THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('OZF', 'OZF_NO_DISCOUNT_VALUE');
830: --//Discount value is mandatory.Please provide a valid Discount value.
831: FND_MSG_PUB.add;
832: END IF;
833: x_return_status := fnd_api.g_ret_sts_error;
834: RETURN;
835: END IF;

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

835: END IF;
836:
837: --//9. operand_calculation_code
838: IF l_resale_util_rec.discount_type IS NULL OR l_resale_util_rec.discount_type = FND_API.g_miss_char THEN
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
840: FND_MESSAGE.set_name('OZF', 'OZF_NO_DISCOUNT_TYPE');
841: --//Discount type is mandatory.Please provide a valid Discount type.
842: FND_MSG_PUB.add;
843: END IF;

Line 842: FND_MSG_PUB.add;

838: IF l_resale_util_rec.discount_type IS NULL OR l_resale_util_rec.discount_type = FND_API.g_miss_char THEN
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
840: FND_MESSAGE.set_name('OZF', 'OZF_NO_DISCOUNT_TYPE');
841: --//Discount type is mandatory.Please provide a valid Discount type.
842: FND_MSG_PUB.add;
843: END IF;
844: x_return_status := fnd_api.g_ret_sts_error;
845: RETURN;
846: ELSE

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

844: x_return_status := fnd_api.g_ret_sts_error;
845: RETURN;
846: ELSE
847: IF l_resale_util_rec.discount_type <> l_arithmetic_operator THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
849: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_OPER_CALC_CODE');
850: --//Operend Calculation Code Should be the same as of offer.
851: FND_MSG_PUB.add;
852: END IF;

Line 851: FND_MSG_PUB.add;

847: IF l_resale_util_rec.discount_type <> l_arithmetic_operator THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
849: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_OPER_CALC_CODE');
850: --//Operend Calculation Code Should be the same as of offer.
851: FND_MSG_PUB.add;
852: END IF;
853: x_return_status := fnd_api.g_ret_sts_error;
854: RETURN;
855: END IF;

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

860: --//Profile - OZF: Third Party Accrual on Selling Price
861:
862: IF l_accrual_on_selling = 'Y' THEN
863: IF l_resale_line_rec.selling_price IS NULL OR l_resale_line_rec.selling_price = FND_API.g_miss_num THEN
864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
865: FND_MESSAGE.set_name('OZF', 'OZF_ACC_ON_SELLING_PRICE_ERR');
866: --//Selling price should be available in resale lines when Profile OZF: Third Party Accrual on Selling Price is set to Yes.
867: FND_MSG_PUB.add;
868: END IF;

Line 867: FND_MSG_PUB.add;

863: IF l_resale_line_rec.selling_price IS NULL OR l_resale_line_rec.selling_price = FND_API.g_miss_num THEN
864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
865: FND_MESSAGE.set_name('OZF', 'OZF_ACC_ON_SELLING_PRICE_ERR');
866: --//Selling price should be available in resale lines when Profile OZF: Third Party Accrual on Selling Price is set to Yes.
867: FND_MSG_PUB.add;
868: END IF;
869: x_return_status := fnd_api.g_ret_sts_error;
870: RETURN;
871: ELSE

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

872: l_resale_util_rec.unit_price := l_resale_line_rec.selling_price;
873: END IF;
874: ELSE -- l_accrual_on_selling IS N or NULL
875: IF l_resale_util_rec.unit_price IS NULL OR l_resale_util_rec.unit_price = FND_API.g_miss_num THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
877: FND_MESSAGE.set_name('OZF', 'OZF_NO_PRICED_UNIT_PRICE');
878: --//Unit Price is mandatory.Please provide a valid Unit Price.
879: FND_MSG_PUB.add;
880: END IF;

Line 879: FND_MSG_PUB.add;

875: IF l_resale_util_rec.unit_price IS NULL OR l_resale_util_rec.unit_price = FND_API.g_miss_num THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
877: FND_MESSAGE.set_name('OZF', 'OZF_NO_PRICED_UNIT_PRICE');
878: --//Unit Price is mandatory.Please provide a valid Unit Price.
879: FND_MSG_PUB.add;
880: END IF;
881: x_return_status := fnd_api.g_ret_sts_error;
882: RETURN;
883: END IF;

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

886: --//11.requester_id
887: IF l_resale_util_rec.requester_id IS NULL OR l_resale_util_rec.requester_id = FND_API.g_miss_num THEN
888: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_line_rec.last_updated_by);
889: IF l_requester_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
892: --//User is not a valid resource.
893: FND_MSG_PUB.add;
894: END IF;

Line 893: FND_MSG_PUB.add;

889: IF l_requester_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
892: --//User is not a valid resource.
893: FND_MSG_PUB.add;
894: END IF;
895: x_return_status := fnd_api.g_ret_sts_error;
896: RETURN;
897: END IF;

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

900: FETCH c_get_user_id INTO l_user_id;
901: CLOSE c_get_user_id;
902:
903: IF l_user_id IS NULL THEN
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER');
906: --//The User Id provided is invalid, please provide a valid User Id.
907: FND_MSG_PUB.add;
908: END IF;

Line 907: FND_MSG_PUB.add;

903: IF l_user_id IS NULL THEN
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_USER');
906: --//The User Id provided is invalid, please provide a valid User Id.
907: FND_MSG_PUB.add;
908: END IF;
909: x_return_status := fnd_api.g_ret_sts_error;
910: RETURN;
911: END IF;

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

911: END IF;
912:
913: l_requester_id := OZF_UTILITY_PVT.get_resource_id(l_resale_util_rec.requester_id);
914: IF l_requester_id IS NULL THEN
915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
917: --//User is not a valid resource.
918: FND_MSG_PUB.add;
919: END IF;

Line 918: FND_MSG_PUB.add;

914: IF l_requester_id IS NULL THEN
915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
916: FND_MESSAGE.set_name('OZF', 'OZF_SD_USER_IS_NOT_RESOURCE');
917: --//User is not a valid resource.
918: FND_MSG_PUB.add;
919: END IF;
920: x_return_status := fnd_api.g_ret_sts_error;
921: RETURN;
922: END IF;

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

926: IF l_resale_util_rec.currency_code IS NULL OR l_resale_util_rec.currency_code = FND_API.g_miss_char THEN
927: l_resale_util_rec.currency_code := l_resale_line_rec.currency_code;
928: ELSE
929: IF l_resale_util_rec.currency_code <> l_resale_line_rec.currency_code THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: FND_MESSAGE.set_name('OZF', 'OZF_CURRENCY_CODE_MISMATCH');
932: --//Provided currency code should be same as Resale batch Currency code.
933: FND_MSG_PUB.add;
934: END IF;

Line 933: FND_MSG_PUB.add;

929: IF l_resale_util_rec.currency_code <> l_resale_line_rec.currency_code THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
931: FND_MESSAGE.set_name('OZF', 'OZF_CURRENCY_CODE_MISMATCH');
932: --//Provided currency code should be same as Resale batch Currency code.
933: FND_MSG_PUB.add;
934: END IF;
935: x_return_status := fnd_api.g_ret_sts_error;
936: RETURN;
937: END IF;

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

941: IF l_resale_util_rec.uom_code IS NULL OR l_resale_util_rec.uom_code = FND_API.g_miss_char THEN
942: l_resale_util_rec.uom_code := l_resale_line_rec.uom_code;
943: ELSE
944: IF l_resale_util_rec.uom_code <> l_resale_line_rec.uom_code THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
946: FND_MESSAGE.set_name('OZF', 'OZF_UOM_CODE_MISMATCH');
947: --//Provided Unit of Measurement Code should be same as Resale batch Unit of Measurement Code.
948: FND_MSG_PUB.add;
949: END IF;

Line 948: FND_MSG_PUB.add;

944: IF l_resale_util_rec.uom_code <> l_resale_line_rec.uom_code THEN
945: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
946: FND_MESSAGE.set_name('OZF', 'OZF_UOM_CODE_MISMATCH');
947: --//Provided Unit of Measurement Code should be same as Resale batch Unit of Measurement Code.
948: FND_MSG_PUB.add;
949: END IF;
950: x_return_status := fnd_api.g_ret_sts_error;
951: RETURN;
952: END IF;

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

956: IF l_resale_util_rec.inventory_item_Id IS NULL OR l_resale_util_rec.inventory_item_Id = FND_API.g_miss_num THEN
957: l_resale_util_rec.inventory_item_Id := l_resale_line_rec.inventory_item_Id;
958: ELSE
959: IF l_resale_util_rec.inventory_item_Id <> l_resale_line_rec.inventory_item_Id THEN
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('OZF', 'OZF_PRODUCT_CODE_MISMATCH');
962: --//Provided product Code should be same as Resale lines Product code.
963: FND_MSG_PUB.add;
964: END IF;

Line 963: FND_MSG_PUB.add;

959: IF l_resale_util_rec.inventory_item_Id <> l_resale_line_rec.inventory_item_Id THEN
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('OZF', 'OZF_PRODUCT_CODE_MISMATCH');
962: --//Provided product Code should be same as Resale lines Product code.
963: FND_MSG_PUB.add;
964: END IF;
965: x_return_status := fnd_api.g_ret_sts_error;
966: RETURN;
967: END IF;

Line 1074: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1070: END IF;
1071:
1072: IF l_ssd_on_idsm = 'Y' THEN
1073: IF (l_resale_line_rec.supplier_item_cost = -1 AND (l_resale_util_rec.discount_type = '%' OR l_resale_util_rec.discount_type ='UNIT_PRICE')) THEN
1074: IF FND_MSG_PUB.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1075: FND_MESSAGE.Set_Token('OZF', 'OZF_COST_PRICE_NOT_FOUND');
1076: --//Program Error: No cost price was found to complete this SDR offer accrual.
1077: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
1078: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);

Line 1081: FND_MSG_PUB.add;

1077: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
1078: FND_MESSAGE.Set_Token('ORDER',l_act_util_rec.object_id);
1079: FND_MESSAGE.Set_Token('ITEM',l_act_util_rec.product_id);
1080: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1081: FND_MSG_PUB.add;
1082: END IF;
1083: RAISE fnd_api.g_exc_error;
1084: END IF;
1085:

Line 1225: FND_MSG_PUB.Count_And_Get (

1221: THEN
1222: COMMIT WORK;
1223: END IF;
1224:
1225: FND_MSG_PUB.Count_And_Get (
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );

Line 1236: FND_MSG_PUB.Count_And_Get (

1232: WHEN FND_API.G_EXC_ERROR THEN
1233: ROLLBACK TO Create_resale_utilization;
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data
1240: );

Line 1245: FND_MSG_PUB.Count_And_Get (

1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: ROLLBACK TO Create_resale_utilization;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: -- Standard call to get message count and if count=1, get the message
1245: FND_MSG_PUB.Count_And_Get (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data
1249: );

Line 1253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1249: );
1250: WHEN OTHERS THEN
1251: ROLLBACK TO Create_resale_utilization;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1255: END IF;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (

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

1250: WHEN OTHERS THEN
1251: ROLLBACK TO Create_resale_utilization;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1255: END IF;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (
1258: p_encoded => FND_API.G_FALSE,

Line 1257: FND_MSG_PUB.Count_And_Get (

1253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1255: END IF;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data
1261: );