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.

[Home] [Help]

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 736: FND_MSG_PUB.initialize;

732: END IF;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- Initialize API return status to SUCCESS
740: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

927:
928: WHEN Fnd_Api.G_EXC_ERROR THEN
929: x_return_status := Fnd_Api.g_ret_sts_error;
930: ROLLBACK TO copy_vo_header;
931: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
932: THEN
933: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
934: END IF;
935: Fnd_Msg_Pub.Count_AND_Get

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

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

Line 935: Fnd_Msg_Pub.Count_AND_Get

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

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

940:
941: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
943: ROLLBACK TO copy_vo_header;
944: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
945: THEN
946: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
947: END IF;
948: Fnd_Msg_Pub.Count_AND_Get

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

942: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
943: ROLLBACK TO copy_vo_header;
944: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
945: THEN
946: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
947: END IF;
948: Fnd_Msg_Pub.Count_AND_Get
949: ( p_count => x_msg_count,
950: p_data => x_msg_data,

Line 948: Fnd_Msg_Pub.Count_AND_Get

944: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
945: THEN
946: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
947: END IF;
948: Fnd_Msg_Pub.Count_AND_Get
949: ( p_count => x_msg_count,
950: p_data => x_msg_data,
951: p_encoded => Fnd_Api.G_FALSE
952: );

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

953:
954: WHEN OTHERS THEN
955: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
956: ROLLBACK TO copy_vo_header;
957: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
960: END IF;
961: Fnd_Msg_Pub.Count_AND_Get

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

955: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
956: ROLLBACK TO copy_vo_header;
957: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
960: END IF;
961: Fnd_Msg_Pub.Count_AND_Get
962: ( p_count => x_msg_count,
963: p_data => x_msg_data,

Line 961: Fnd_Msg_Pub.Count_AND_Get

957: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
958: THEN
959: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
960: END IF;
961: Fnd_Msg_Pub.Count_AND_Get
962: ( p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => Fnd_Api.G_FALSE
965: );

Line 1777: FND_MSG_PUB.initialize;

1773: END IF;
1774:
1775: -- Initialize message list if p_init_msg_list is set to TRUE.
1776: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1777: FND_MSG_PUB.initialize;
1778: END IF;
1779:
1780: -- Initialize API return status to SUCCESS
1781: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1804: Fnd_Msg_Pub.ADD;

1800: IF l_modifier_list_rec.start_date_active IS NOT NULL
1801: AND l_modifier_list_rec.start_date_active <> FND_API.G_MISS_DATE THEN
1802: IF l_modifier_list_rec.start_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1803: Fnd_Message.SET_NAME('OZF','OZF_OFFR_STARTDATE_LT_SYSDATE');
1804: Fnd_Msg_Pub.ADD;
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: END IF; -- end validation start date if
1808: */

Line 1814: Fnd_Msg_Pub.ADD;

1810: IF l_modifier_list_rec.end_date_active IS NOT NULL
1811: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE THEN
1812: IF l_modifier_list_rec.end_date_active < TRUNC(SYSDATE) AND l_offer_rec.offer_type <> 'NET_ACCRUAL' THEN
1813: Fnd_Message.SET_NAME('OZF','OZF_OFFR_ENDDATE_LT_SYSDATE');
1814: Fnd_Msg_Pub.ADD;
1815: RAISE FND_API.G_EXC_ERROR;
1816: END IF;
1817: END IF; -- end end date validation if
1818:

Line 1833: Fnd_Msg_Pub.ADD;

1829: AND l_modifier_list_rec.end_date_active <> FND_API.G_MISS_DATE
1830: THEN
1831: IF l_modifier_list_rec.start_date_active > l_modifier_list_rec.end_date_active THEN
1832: Fnd_Message.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
1833: Fnd_Msg_Pub.ADD;
1834: RAISE FND_API.G_EXC_ERROR;
1835: END IF;
1836: END IF; -- end start date before end date validation
1837:

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

2794:
2795: WHEN Fnd_Api.G_EXC_ERROR THEN
2796: x_return_status := Fnd_Api.g_ret_sts_error;
2797: ROLLBACK TO copy_offer_detail;
2798: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2799: THEN
2800: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: Fnd_Msg_Pub.Count_AND_Get

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

2796: x_return_status := Fnd_Api.g_ret_sts_error;
2797: ROLLBACK TO copy_offer_detail;
2798: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2799: THEN
2800: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: Fnd_Msg_Pub.Count_AND_Get
2803: ( p_count => x_msg_count,
2804: p_data => x_msg_data,

Line 2802: Fnd_Msg_Pub.Count_AND_Get

2798: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2799: THEN
2800: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2801: END IF;
2802: Fnd_Msg_Pub.Count_AND_Get
2803: ( p_count => x_msg_count,
2804: p_data => x_msg_data,
2805: p_encoded => Fnd_Api.G_FALSE
2806: );

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

2807:
2808: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2810: ROLLBACK TO copy_offer_detail;
2811: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2812: THEN
2813: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2814: END IF;
2815: Fnd_Msg_Pub.Count_AND_Get

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

2809: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2810: ROLLBACK TO copy_offer_detail;
2811: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2812: THEN
2813: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2814: END IF;
2815: Fnd_Msg_Pub.Count_AND_Get
2816: ( p_count => x_msg_count,
2817: p_data => x_msg_data,

Line 2815: Fnd_Msg_Pub.Count_AND_Get

2811: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2812: THEN
2813: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2814: END IF;
2815: Fnd_Msg_Pub.Count_AND_Get
2816: ( p_count => x_msg_count,
2817: p_data => x_msg_data,
2818: p_encoded => Fnd_Api.G_FALSE
2819: );

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

2820:
2821: WHEN OTHERS THEN
2822: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2823: ROLLBACK TO copy_offer_detail;
2824: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2825: THEN
2826: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2827: END IF;
2828: Fnd_Msg_Pub.Count_AND_Get

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

2822: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2823: ROLLBACK TO copy_offer_detail;
2824: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2825: THEN
2826: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2827: END IF;
2828: Fnd_Msg_Pub.Count_AND_Get
2829: ( p_count => x_msg_count,
2830: p_data => x_msg_data,

Line 2828: Fnd_Msg_Pub.Count_AND_Get

2824: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2825: THEN
2826: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2827: END IF;
2828: Fnd_Msg_Pub.Count_AND_Get
2829: ( p_count => x_msg_count,
2830: p_data => x_msg_data,
2831: p_encoded => Fnd_Api.G_FALSE
2832: );

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

2894: EXCEPTION
2895: WHEN Fnd_Api.G_EXC_ERROR THEN
2896: x_return_status := Fnd_Api.g_ret_sts_error;
2897: ROLLBACK TO copy_offer;
2898: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2899: THEN
2900: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2901: END IF;
2902: Fnd_Msg_Pub.Count_AND_Get

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

2896: x_return_status := Fnd_Api.g_ret_sts_error;
2897: ROLLBACK TO copy_offer;
2898: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2899: THEN
2900: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2901: END IF;
2902: Fnd_Msg_Pub.Count_AND_Get
2903: ( p_count => x_msg_count,
2904: p_data => x_msg_data,

Line 2902: Fnd_Msg_Pub.Count_AND_Get

2898: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_ERROR )
2899: THEN
2900: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2901: END IF;
2902: Fnd_Msg_Pub.Count_AND_Get
2903: ( p_count => x_msg_count,
2904: p_data => x_msg_data,
2905: p_encoded => Fnd_Api.G_FALSE
2906: );

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

2907:
2908: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2910: ROLLBACK TO copy_offer;
2911: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2912: THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2914: END IF;
2915: Fnd_Msg_Pub.Count_AND_Get

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

2909: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2910: ROLLBACK TO copy_offer;
2911: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2912: THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2914: END IF;
2915: Fnd_Msg_Pub.Count_AND_Get
2916: ( p_count => x_msg_count,
2917: p_data => x_msg_data,

Line 2915: Fnd_Msg_Pub.Count_AND_Get

2911: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2912: THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2914: END IF;
2915: Fnd_Msg_Pub.Count_AND_Get
2916: ( p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => Fnd_Api.G_FALSE
2919: );

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

2920:
2921: WHEN OTHERS THEN
2922: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2923: ROLLBACK TO copy_offer;
2924: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2925: THEN
2926: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2927: END IF;
2928: Fnd_Msg_Pub.Count_AND_Get

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

2922: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2923: ROLLBACK TO copy_offer;
2924: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2925: THEN
2926: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2927: END IF;
2928: Fnd_Msg_Pub.Count_AND_Get
2929: ( p_count => x_msg_count,
2930: p_data => x_msg_data,

Line 2928: Fnd_Msg_Pub.Count_AND_Get

2924: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2925: THEN
2926: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2927: END IF;
2928: Fnd_Msg_Pub.Count_AND_Get
2929: ( p_count => x_msg_count,
2930: p_data => x_msg_data,
2931: p_encoded => Fnd_Api.G_FALSE
2932: );