eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_ADJ_LINE_PVT dependencies on OZF_UTILITY_PVT

Line 61: OZF_UTILITY_PVT.debug_message(p_message_text);

57: )
58: IS
59: BEGIN
60: --IF OZF_DEBUG_HIGH_ON THEN
61: OZF_UTILITY_PVT.debug_message(p_message_text);
62: --END IF;
63:
64: END debug_message;
65:

Line 420: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

416: -- =========================================================================
417:
418: IF FND_GLOBAL.USER_ID IS NULL
419: THEN
420: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:
424:

Line 505: WHEN OZF_Utility_PVT.resource_locked THEN

501: );
502:
503: EXCEPTION
504:
505: WHEN OZF_Utility_PVT.resource_locked THEN
506: x_return_status := FND_API.g_ret_sts_error;
507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
508:
509: WHEN FND_API.G_EXC_ERROR THEN

Line 507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

503: EXCEPTION
504:
505: WHEN OZF_Utility_PVT.resource_locked THEN
506: x_return_status := FND_API.g_ret_sts_error;
507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 758: WHEN OZF_UTILITY_PVT.resource_locked THEN

754: p_data => x_msg_data
755: );
756:
757: EXCEPTION
758: WHEN OZF_UTILITY_PVT.resource_locked THEN
759: x_return_status := FND_API.g_ret_sts_error;
760: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
761:
762: WHEN FND_API.G_EXC_ERROR THEN

Line 760: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

756:
757: EXCEPTION
758: WHEN OZF_UTILITY_PVT.resource_locked THEN
759: x_return_status := FND_API.g_ret_sts_error;
760: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
764: x_return_status := FND_API.G_RET_STS_ERROR;

Line 902: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

898:
899: FETCH c_get_Offer_Adj_Line INTO l_ref_offadj_line_rec ;
900:
901: If ( c_get_Offer_Adj_Line%NOTFOUND) THEN
902: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
903: p_token_name => 'INFO',
904: p_token_value => 'Offer_Adj_Line') ;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;

Line 914: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

910:
911:
912: If (l_tar_offadj_line_rec.object_version_number is NULL or
913: l_tar_offadj_line_rec.object_version_number = FND_API.G_MISS_NUM ) Then
914: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
915: p_token_name => 'COLUMN',
916: p_token_value => 'Last_Update_Date') ;
917: raise FND_API.G_EXC_ERROR;
918: End if;

Line 921: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

917: raise FND_API.G_EXC_ERROR;
918: End if;
919: -- Check Whether record has been changed by someone else
920: If (l_tar_offadj_line_rec.object_version_number <> l_ref_offadj_line_rec.object_version_number) Then
921: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
922: p_token_name => 'INFO',
923: p_token_value => 'Offer_Adj_Line') ;
924: raise FND_API.G_EXC_ERROR;
925: End if;

Line 1007: WHEN OZF_Utility_PVT.resource_locked THEN

1003: p_data => x_msg_data
1004: );
1005: EXCEPTION
1006:
1007: WHEN OZF_Utility_PVT.resource_locked THEN
1008: x_return_status := FND_API.g_ret_sts_error;
1009: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1010:
1011: WHEN FND_API.G_EXC_ERROR THEN

Line 1009: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1005: EXCEPTION
1006:
1007: WHEN OZF_Utility_PVT.resource_locked THEN
1008: x_return_status := FND_API.g_ret_sts_error;
1009: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1010:
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1013: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1274: WHEN OZF_UTILITY_PVT.resource_locked THEN

1270: p_data => x_msg_data
1271: );
1272:
1273: EXCEPTION
1274: WHEN OZF_UTILITY_PVT.resource_locked THEN
1275: x_return_status := FND_API.g_ret_sts_error;
1276: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1277:
1278: WHEN FND_API.G_EXC_ERROR THEN

Line 1276: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1272:
1273: EXCEPTION
1274: WHEN OZF_UTILITY_PVT.resource_locked THEN
1275: x_return_status := FND_API.g_ret_sts_error;
1276: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1277:
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1280: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1428: WHEN OZF_Utility_PVT.resource_locked THEN

1424: p_data => x_msg_data
1425: );
1426: EXCEPTION
1427:
1428: WHEN OZF_Utility_PVT.resource_locked THEN
1429: x_return_status := FND_API.g_ret_sts_error;
1430: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1431:
1432: WHEN FND_API.G_EXC_ERROR THEN

Line 1430: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1426: EXCEPTION
1427:
1428: WHEN OZF_Utility_PVT.resource_locked THEN
1429: x_return_status := FND_API.g_ret_sts_error;
1430: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1431:
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1434: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1562: WHEN OZF_Utility_PVT.resource_locked THEN

1558: p_data => x_msg_data);
1559: debug_message(l_full_name ||': end');
1560: EXCEPTION
1561:
1562: WHEN OZF_Utility_PVT.resource_locked THEN
1563: x_return_status := FND_API.g_ret_sts_error;
1564: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1565:
1566: WHEN FND_API.G_EXC_ERROR THEN

Line 1564: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

1560: EXCEPTION
1561:
1562: WHEN OZF_Utility_PVT.resource_locked THEN
1563: x_return_status := FND_API.g_ret_sts_error;
1564: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1565:
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1568: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1615: -- l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1611: BEGIN
1612: x_return_status := FND_API.g_ret_sts_success;
1613:
1614: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1615: -- l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1616: -- 'ozf_offer_adjustment_lines',
1617: -- 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||''''
1618: -- );
1619: l_valid_flag := FND_API.g_true;

Line 1621: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

1617: -- 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||''''
1618: -- );
1619: l_valid_flag := FND_API.g_true;
1620: ELSE
1621: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1622: 'ozf_offer_adjustment_lines',
1623: 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||
1624: ''' AND offer_adjustment_line_id <> ' || p_offadj_line_rec.offer_adjustment_line_id
1625: );

Line 1629: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_LINE_ID_DUP');

1625: );
1626: END IF;
1627:
1628: IF l_valid_flag = FND_API.g_false THEN
1629: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_LINE_ID_DUP');
1630: x_return_status := FND_API.g_ret_sts_error;
1631: END IF;
1632:
1633: END check_Offadj_Line_Uk_Items;

Line 1657: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');

1653: (p_offadj_line_rec.original_discount < 0 AND p_offadj_line_rec.modified_discount > 0)
1654: OR
1655: (p_offadj_line_rec.original_discount > 0 AND p_offadj_line_rec.modified_discount < 0)
1656: THEN
1657: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
1658: x_return_status := FND_API.g_ret_sts_error;
1659: return;
1660: END IF;
1661: END IF;

Line 1675: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');

1671: (p_offadj_line_rec.original_discount_td < 0 AND p_offadj_line_rec.modified_discount_td > 0)
1672: OR
1673: (p_offadj_line_rec.original_discount_td > 0 AND p_offadj_line_rec.modified_discount_td < 0)
1674: THEN
1675: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
1676: x_return_status := FND_API.g_ret_sts_error;
1677: return;
1678: END IF;
1679: END IF;

Line 1716: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

1712:
1713: OZF_Offer_Adj_Line_PVT.debug_message('ValidationMOde is '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
1714: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1715: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.offer_adjustment_id IS NULL THEN
1716: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1717: x_return_status := FND_API.g_ret_sts_error;
1718: return;
1719: END IF;
1720: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_line_id IS NULL THEN

Line 1721: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );

1717: x_return_status := FND_API.g_ret_sts_error;
1718: return;
1719: END IF;
1720: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_line_id IS NULL THEN
1721: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1722: x_return_status := FND_API.g_ret_sts_error;
1723: return;
1724: END IF;
1725: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_header_id IS NULL THEN

Line 1726: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );

1722: x_return_status := FND_API.g_ret_sts_error;
1723: return;
1724: END IF;
1725: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_header_id IS NULL THEN
1726: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1727: x_return_status := FND_API.g_ret_sts_error;
1728: return;
1729: END IF;
1730: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);

Line 1739: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );

1735: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL)
1736: AND
1737: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL)
1738: THEN
1739: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1740: x_return_status := FND_API.g_ret_sts_error;
1741: return;
1742: END IF;
1743: IF (p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )

Line 1748: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');

1744: AND
1745: (p_offadj_line_rec.original_discount_td IS NULL OR p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1746:
1747: THEN
1748: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1749: x_return_status := FND_API.g_ret_sts_error;
1750: return;
1751: END IF;
1752: ELSE

Line 1754: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'Quantity' );

1750: return;
1751: END IF;
1752: ELSE
1753: /* IF p_offadj_line_rec.quantity = FND_API.G_MISS_NUM OR p_offadj_line_rec.quantity IS NULL THEN
1754: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'Quantity' );
1755: -- x_return_status := FND_API.g_ret_sts_error;
1756: END IF;
1757: */
1758: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);

Line 1760: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );

1756: END IF;
1757: */
1758: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1759: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1760: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
1761: x_return_status := FND_API.g_ret_sts_error;
1762: return;
1763: END IF;
1764: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN

Line 1765: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT');

1761: x_return_status := FND_API.g_ret_sts_error;
1762: return;
1763: END IF;
1764: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1765: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT');
1766: x_return_status := FND_API.g_ret_sts_error;
1767: return;
1768: END IF;
1769: END IF;

Line 1773: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_LINE_ID' );

1769: END IF;
1770:
1771: ELSE
1772: IF p_offadj_line_rec.offer_adjustment_line_id = FND_API.G_MISS_NUM THEN
1773: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_LINE_ID' );
1774: x_return_status := FND_API.g_ret_sts_error;
1775: return;
1776: END IF;
1777:

Line 1779: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );

1775: return;
1776: END IF;
1777:
1778: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1779: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1780: x_return_status := FND_API.g_ret_sts_error;
1781: return;
1782: END IF;
1783:

Line 1786: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );

1782: END IF;
1783:
1784:
1785: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM THEN
1786: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1787: x_return_status := FND_API.g_ret_sts_error;
1788: return;
1789: END IF;
1790:

Line 1792: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );

1788: return;
1789: END IF;
1790:
1791: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM THEN
1792: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1793: x_return_status := FND_API.g_ret_sts_error;
1794: return;
1795: END IF;
1796:

Line 1804: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );

1800: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM )
1801: AND
1802: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM )
1803: THEN
1804: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1805: x_return_status := FND_API.g_ret_sts_error;
1806: return;
1807: END IF;
1808: IF ( p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )

Line 1812: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');

1808: IF ( p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1809: AND
1810: (p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1811: THEN
1812: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1813: x_return_status := FND_API.g_ret_sts_error;
1814: return;
1815: END IF;
1816: ELSE

Line 1820: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');

1816: ELSE
1817: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1818: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1819: IF p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL THEN
1820: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');
1821: x_return_status := FND_API.g_ret_sts_error;
1822: END IF;
1823: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1824: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN

Line 1825: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','original_discount');

1821: x_return_status := FND_API.g_ret_sts_error;
1822: END IF;
1823: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1824: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1825: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','original_discount');
1826: x_return_status := FND_API.g_ret_sts_error;
1827: return;
1828: END IF;
1829:

Line 2187: WHEN OZF_Utility_PVT.resource_locked THEN

2183: p_data => x_msg_data
2184: );
2185: EXCEPTION
2186:
2187: WHEN OZF_Utility_PVT.resource_locked THEN
2188: x_return_status := FND_API.g_ret_sts_error;
2189: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2190:
2191: WHEN FND_API.G_EXC_ERROR THEN

Line 2189: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

2185: EXCEPTION
2186:
2187: WHEN OZF_Utility_PVT.resource_locked THEN
2188: x_return_status := FND_API.g_ret_sts_error;
2189: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2190:
2191: WHEN FND_API.G_EXC_ERROR THEN
2192: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2193: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2281: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');

2277:
2278: IF l_endDate IS NOT NULL AND l_endDate <> FND_API.G_MISS_DATE THEN
2279: CASE
2280: WHEN l_endDate < sysdate THEN
2281: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');
2282: x_return_status := FND_API.g_ret_sts_error;
2283: RETURN;
2284: WHEN l_endDate < l_adjEffDate THEN
2285: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');

Line 2285: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');

2281: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');
2282: x_return_status := FND_API.g_ret_sts_error;
2283: RETURN;
2284: WHEN l_endDate < l_adjEffDate THEN
2285: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');
2286: x_return_status := FND_API.g_ret_sts_error;
2287: RETURN;
2288: WHEN l_offEndDate IS NOT NULL AND l_offEndDate <> FND_API.G_MISS_DATE
2289: AND l_endDate > l_offEndDate THEN

Line 2290: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_MT_OFFDATE');

2286: x_return_status := FND_API.g_ret_sts_error;
2287: RETURN;
2288: WHEN l_offEndDate IS NOT NULL AND l_offEndDate <> FND_API.G_MISS_DATE
2289: AND l_endDate > l_offEndDate THEN
2290: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_MT_OFFDATE');
2291: x_return_status := FND_API.g_ret_sts_error;
2292: RETURN;
2293: ELSE
2294: RETURN;