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_COPY_OFFER_PVT dependencies on FND_MSG_PUB

Line 80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

76: EXCEPTION
77: WHEN Fnd_Api.G_EXC_ERROR THEN
78: x_return_status := Fnd_Api.g_ret_sts_error;
79: ROLLBACK TO copy_vo_mkt_options;
80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
81: THEN
82: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
83: END IF;
84: Fnd_Msg_Pub.Count_AND_Get

Line 82: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

78: x_return_status := Fnd_Api.g_ret_sts_error;
79: ROLLBACK TO copy_vo_mkt_options;
80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
81: THEN
82: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
83: END IF;
84: Fnd_Msg_Pub.Count_AND_Get
85: ( p_count => x_msg_count,
86: p_data => x_msg_data,

Line 84: Fnd_Msg_Pub.Count_AND_Get

80: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
81: THEN
82: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
83: END IF;
84: Fnd_Msg_Pub.Count_AND_Get
85: ( p_count => x_msg_count,
86: p_data => x_msg_data,
87: p_encoded => Fnd_Api.G_FALSE
88: );

Line 93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

89:
90: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
92: ROLLBACK TO copy_vo_mkt_options;
93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
94: THEN
95: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: Fnd_Msg_Pub.Count_AND_Get

Line 95: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

91: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
92: ROLLBACK TO copy_vo_mkt_options;
93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
94: THEN
95: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: Fnd_Msg_Pub.Count_AND_Get
98: ( p_count => x_msg_count,
99: p_data => x_msg_data,

Line 97: Fnd_Msg_Pub.Count_AND_Get

93: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
94: THEN
95: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: Fnd_Msg_Pub.Count_AND_Get
98: ( p_count => x_msg_count,
99: p_data => x_msg_data,
100: p_encoded => Fnd_Api.G_FALSE
101: );

Line 106: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

102:
103: WHEN OTHERS THEN
104: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
105: ROLLBACK TO copy_vo_mkt_options;
106: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
107: THEN
108: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
109: END IF;
110: Fnd_Msg_Pub.Count_AND_Get

Line 108: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

104: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
105: ROLLBACK TO copy_vo_mkt_options;
106: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
107: THEN
108: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
109: END IF;
110: Fnd_Msg_Pub.Count_AND_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data,

Line 110: Fnd_Msg_Pub.Count_AND_Get

106: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
107: THEN
108: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
109: END IF;
110: Fnd_Msg_Pub.Count_AND_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data,
113: p_encoded => Fnd_Api.G_FALSE
114: );

Line 294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

290:
291: WHEN Fnd_Api.G_EXC_ERROR THEN
292: x_return_status := Fnd_Api.g_ret_sts_error;
293: ROLLBACK TO copy_vo_qualifiers;
294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
295: THEN
296: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
297: END IF;
298: Fnd_Msg_Pub.Count_AND_Get

Line 296: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

292: x_return_status := Fnd_Api.g_ret_sts_error;
293: ROLLBACK TO copy_vo_qualifiers;
294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
295: THEN
296: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
297: END IF;
298: Fnd_Msg_Pub.Count_AND_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data,

Line 298: Fnd_Msg_Pub.Count_AND_Get

294: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
295: THEN
296: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
297: END IF;
298: Fnd_Msg_Pub.Count_AND_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data,
301: p_encoded => Fnd_Api.G_FALSE
302: );

Line 307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

303:
304: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
306: ROLLBACK TO copy_vo_qualifiers;
307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
308: THEN
309: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
310: END IF;
311: Fnd_Msg_Pub.Count_AND_Get

Line 309: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

305: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
306: ROLLBACK TO copy_vo_qualifiers;
307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
308: THEN
309: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
310: END IF;
311: Fnd_Msg_Pub.Count_AND_Get
312: ( p_count => x_msg_count,
313: p_data => x_msg_data,

Line 311: Fnd_Msg_Pub.Count_AND_Get

307: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
308: THEN
309: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
310: END IF;
311: Fnd_Msg_Pub.Count_AND_Get
312: ( p_count => x_msg_count,
313: p_data => x_msg_data,
314: p_encoded => Fnd_Api.G_FALSE
315: );

Line 320: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

316:
317: WHEN OTHERS THEN
318: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
319: ROLLBACK TO copy_vo_qualifiers;
320: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
321: THEN
322: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
323: END IF;
324: Fnd_Msg_Pub.Count_AND_Get

Line 322: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

318: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
319: ROLLBACK TO copy_vo_qualifiers;
320: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
321: THEN
322: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
323: END IF;
324: Fnd_Msg_Pub.Count_AND_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data,

Line 324: Fnd_Msg_Pub.Count_AND_Get

320: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
321: THEN
322: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
323: END IF;
324: Fnd_Msg_Pub.Count_AND_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data,
327: p_encoded => Fnd_Api.G_FALSE
328: );

Line 549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

545:
546: WHEN Fnd_Api.G_EXC_ERROR THEN
547: x_return_status := Fnd_Api.g_ret_sts_error;
548: ROLLBACK TO copy_vo_discounts;
549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
550: THEN
551: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: Fnd_Msg_Pub.Count_AND_Get

Line 551: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

547: x_return_status := Fnd_Api.g_ret_sts_error;
548: ROLLBACK TO copy_vo_discounts;
549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
550: THEN
551: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: Fnd_Msg_Pub.Count_AND_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data,

Line 553: Fnd_Msg_Pub.Count_AND_Get

549: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
550: THEN
551: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: Fnd_Msg_Pub.Count_AND_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data,
556: p_encoded => Fnd_Api.G_FALSE
557: );

Line 562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

558:
559: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
561: ROLLBACK TO copy_vo_discounts;
562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
563: THEN
564: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: Fnd_Msg_Pub.Count_AND_Get

Line 564: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

560: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
561: ROLLBACK TO copy_vo_discounts;
562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
563: THEN
564: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: Fnd_Msg_Pub.Count_AND_Get
567: ( p_count => x_msg_count,
568: p_data => x_msg_data,

Line 566: Fnd_Msg_Pub.Count_AND_Get

562: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
563: THEN
564: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: Fnd_Msg_Pub.Count_AND_Get
567: ( p_count => x_msg_count,
568: p_data => x_msg_data,
569: p_encoded => Fnd_Api.G_FALSE
570: );

Line 575: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

571:
572: WHEN OTHERS THEN
573: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
574: ROLLBACK TO copy_vo_discounts;
575: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
576: THEN
577: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
578: END IF;
579: Fnd_Msg_Pub.Count_AND_Get

Line 577: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

573: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
574: ROLLBACK TO copy_vo_discounts;
575: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
576: THEN
577: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
578: END IF;
579: Fnd_Msg_Pub.Count_AND_Get
580: ( p_count => x_msg_count,
581: p_data => x_msg_data,

Line 579: Fnd_Msg_Pub.Count_AND_Get

575: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
576: THEN
577: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
578: END IF;
579: Fnd_Msg_Pub.Count_AND_Get
580: ( p_count => x_msg_count,
581: p_data => x_msg_data,
582: p_encoded => Fnd_Api.G_FALSE
583: );

Line 724: FND_MSG_PUB.initialize;

720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF FND_API.to_Boolean( p_init_msg_list ) THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726:
727: -- Initialize API return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

900:
901: WHEN Fnd_Api.G_EXC_ERROR THEN
902: x_return_status := Fnd_Api.g_ret_sts_error;
903: ROLLBACK TO copy_vo_header;
904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
905: THEN
906: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908: Fnd_Msg_Pub.Count_AND_Get

Line 906: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

902: x_return_status := Fnd_Api.g_ret_sts_error;
903: ROLLBACK TO copy_vo_header;
904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
905: THEN
906: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908: Fnd_Msg_Pub.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,

Line 908: Fnd_Msg_Pub.Count_AND_Get

904: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
905: THEN
906: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
907: END IF;
908: Fnd_Msg_Pub.Count_AND_Get
909: ( p_count => x_msg_count,
910: p_data => x_msg_data,
911: p_encoded => Fnd_Api.G_FALSE
912: );

Line 917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

913:
914: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
916: ROLLBACK TO copy_vo_header;
917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
918: THEN
919: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: Fnd_Msg_Pub.Count_AND_Get

Line 919: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

915: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
916: ROLLBACK TO copy_vo_header;
917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
918: THEN
919: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: Fnd_Msg_Pub.Count_AND_Get
922: ( p_count => x_msg_count,
923: p_data => x_msg_data,

Line 921: Fnd_Msg_Pub.Count_AND_Get

917: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
918: THEN
919: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
920: END IF;
921: Fnd_Msg_Pub.Count_AND_Get
922: ( p_count => x_msg_count,
923: p_data => x_msg_data,
924: p_encoded => Fnd_Api.G_FALSE
925: );

Line 930: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

926:
927: WHEN OTHERS THEN
928: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
929: ROLLBACK TO copy_vo_header;
930: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
933: END IF;
934: Fnd_Msg_Pub.Count_AND_Get

Line 932: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

928: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
929: ROLLBACK TO copy_vo_header;
930: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
933: END IF;
934: Fnd_Msg_Pub.Count_AND_Get
935: ( p_count => x_msg_count,
936: p_data => x_msg_data,

Line 934: Fnd_Msg_Pub.Count_AND_Get

930: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
931: THEN
932: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
933: END IF;
934: Fnd_Msg_Pub.Count_AND_Get
935: ( p_count => x_msg_count,
936: p_data => x_msg_data,
937: p_encoded => Fnd_Api.G_FALSE
938: );

Line 1730: FND_MSG_PUB.initialize;

1726: END IF;
1727:
1728: -- Initialize message list if p_init_msg_list is set to TRUE.
1729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1730: FND_MSG_PUB.initialize;
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS
1734: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1756: Fnd_Msg_Pub.ADD;

1752: IF l_modifier_list_rec.start_date_active IS NOT NULL
1753: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1754: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1755: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1756: Fnd_Msg_Pub.ADD;
1757: RAISE FND_API.G_EXC_ERROR;
1758: END IF;
1759: END IF; -- end validation start date if
1760:

Line 1765: Fnd_Msg_Pub.ADD;

1761: IF l_modifier_list_rec.end_date_active IS NOT NULL
1762: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1763: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1764: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1765: Fnd_Msg_Pub.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767: END IF;
1768: END IF; -- end end date validation if
1769:

Line 1784: Fnd_Msg_Pub.ADD;

1780: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1781: THEN
1782: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1783: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1784: Fnd_Msg_Pub.ADD;
1785: RAISE FND_API.G_EXC_ERROR;
1786: END IF;
1787: END IF; -- end start date before end date validation
1788:

Line 2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

2725:
2726: WHEN Fnd_Api.G_EXC_ERROR THEN
2727: x_return_status := Fnd_Api.g_ret_sts_error;
2728: ROLLBACK TO copy_offer_detail;
2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2730: THEN
2731: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: Fnd_Msg_Pub.Count_AND_Get

Line 2731: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2727: x_return_status := Fnd_Api.g_ret_sts_error;
2728: ROLLBACK TO copy_offer_detail;
2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2730: THEN
2731: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: Fnd_Msg_Pub.Count_AND_Get
2734: ( p_count => x_msg_count,
2735: p_data => x_msg_data,

Line 2733: Fnd_Msg_Pub.Count_AND_Get

2729: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2730: THEN
2731: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2732: END IF;
2733: Fnd_Msg_Pub.Count_AND_Get
2734: ( p_count => x_msg_count,
2735: p_data => x_msg_data,
2736: p_encoded => Fnd_Api.G_FALSE
2737: );

Line 2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

2738:
2739: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2741: ROLLBACK TO copy_offer_detail;
2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2743: THEN
2744: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2745: END IF;
2746: Fnd_Msg_Pub.Count_AND_Get

Line 2744: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2740: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2741: ROLLBACK TO copy_offer_detail;
2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2743: THEN
2744: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2745: END IF;
2746: Fnd_Msg_Pub.Count_AND_Get
2747: ( p_count => x_msg_count,
2748: p_data => x_msg_data,

Line 2746: Fnd_Msg_Pub.Count_AND_Get

2742: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2743: THEN
2744: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2745: END IF;
2746: Fnd_Msg_Pub.Count_AND_Get
2747: ( p_count => x_msg_count,
2748: p_data => x_msg_data,
2749: p_encoded => Fnd_Api.G_FALSE
2750: );

Line 2755: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

2751:
2752: WHEN OTHERS THEN
2753: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2754: ROLLBACK TO copy_offer_detail;
2755: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2756: THEN
2757: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2758: END IF;
2759: Fnd_Msg_Pub.Count_AND_Get

Line 2757: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2753: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2754: ROLLBACK TO copy_offer_detail;
2755: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2756: THEN
2757: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2758: END IF;
2759: Fnd_Msg_Pub.Count_AND_Get
2760: ( p_count => x_msg_count,
2761: p_data => x_msg_data,

Line 2759: Fnd_Msg_Pub.Count_AND_Get

2755: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2756: THEN
2757: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2758: END IF;
2759: Fnd_Msg_Pub.Count_AND_Get
2760: ( p_count => x_msg_count,
2761: p_data => x_msg_data,
2762: p_encoded => Fnd_Api.G_FALSE
2763: );

Line 2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )

2825: EXCEPTION
2826: WHEN Fnd_Api.G_EXC_ERROR THEN
2827: x_return_status := Fnd_Api.g_ret_sts_error;
2828: ROLLBACK TO copy_offer;
2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2830: THEN
2831: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2832: END IF;
2833: Fnd_Msg_Pub.Count_AND_Get

Line 2831: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2827: x_return_status := Fnd_Api.g_ret_sts_error;
2828: ROLLBACK TO copy_offer;
2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2830: THEN
2831: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2832: END IF;
2833: Fnd_Msg_Pub.Count_AND_Get
2834: ( p_count => x_msg_count,
2835: p_data => x_msg_data,

Line 2833: Fnd_Msg_Pub.Count_AND_Get

2829: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2830: THEN
2831: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2832: END IF;
2833: Fnd_Msg_Pub.Count_AND_Get
2834: ( p_count => x_msg_count,
2835: p_data => x_msg_data,
2836: p_encoded => Fnd_Api.G_FALSE
2837: );

Line 2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

2838:
2839: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2841: ROLLBACK TO copy_offer;
2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2843: THEN
2844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2845: END IF;
2846: Fnd_Msg_Pub.Count_AND_Get

Line 2844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2840: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2841: ROLLBACK TO copy_offer;
2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2843: THEN
2844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2845: END IF;
2846: Fnd_Msg_Pub.Count_AND_Get
2847: ( p_count => x_msg_count,
2848: p_data => x_msg_data,

Line 2846: Fnd_Msg_Pub.Count_AND_Get

2842: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2843: THEN
2844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2845: END IF;
2846: Fnd_Msg_Pub.Count_AND_Get
2847: ( p_count => x_msg_count,
2848: p_data => x_msg_data,
2849: p_encoded => Fnd_Api.G_FALSE
2850: );

Line 2855: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

2851:
2852: WHEN OTHERS THEN
2853: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2854: ROLLBACK TO copy_offer;
2855: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2856: THEN
2857: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2858: END IF;
2859: Fnd_Msg_Pub.Count_AND_Get

Line 2857: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2853: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2854: ROLLBACK TO copy_offer;
2855: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2856: THEN
2857: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2858: END IF;
2859: Fnd_Msg_Pub.Count_AND_Get
2860: ( p_count => x_msg_count,
2861: p_data => x_msg_data,

Line 2859: Fnd_Msg_Pub.Count_AND_Get

2855: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2856: THEN
2857: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2858: END IF;
2859: Fnd_Msg_Pub.Count_AND_Get
2860: ( p_count => x_msg_count,
2861: p_data => x_msg_data,
2862: p_encoded => Fnd_Api.G_FALSE
2863: );