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.RCV_HXT_GRP dependencies on HXC_USER_TYPE_DEFINITION_GRP

Line 158: TYPE build_block_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.building_block_info INDEX BY BINARY_INTEGER;

154: , timecard_ovn RCV_TRANSACTIONS.timecard_ovn%TYPE
155: );
156:
157: -- cache results of expensive OTL APIs and SQLs
158: TYPE build_block_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.building_block_info INDEX BY BINARY_INTEGER;
159: TYPE build_attribute_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.attribute_info INDEX BY BINARY_INTEGER;
160: TYPE po_header_cache IS TABLE OF po_header_cr INDEX BY BINARY_INTEGER;
161: TYPE po_line_cache IS TABLE OF po_line_cr INDEX BY BINARY_INTEGER;
162: TYPE po_distribution_cache IS TABLE OF po_distribution_cr INDEX BY BINARY_INTEGER;

Line 159: TYPE build_attribute_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.attribute_info INDEX BY BINARY_INTEGER;

155: );
156:
157: -- cache results of expensive OTL APIs and SQLs
158: TYPE build_block_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.building_block_info INDEX BY BINARY_INTEGER;
159: TYPE build_attribute_cache IS TABLE OF HXC_USER_TYPE_DEFINITION_GRP.attribute_info INDEX BY BINARY_INTEGER;
160: TYPE po_header_cache IS TABLE OF po_header_cr INDEX BY BINARY_INTEGER;
161: TYPE po_line_cache IS TABLE OF po_line_cr INDEX BY BINARY_INTEGER;
162: TYPE po_distribution_cache IS TABLE OF po_distribution_cr INDEX BY BINARY_INTEGER;
163: TYPE price_type_lookup_cache IS TABLE OF fnd_lookups_cr INDEX BY BINARY_INTEGER;

Line 1049: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS

1045: -- cached wrapper for build_block
1046: FUNCTION build_block
1047: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1048: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1049: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1050: BEGIN
1051: g_build_block_calls := g_build_block_calls + 1;
1052:
1053: IF NOT g_build_block_cache.EXISTS(p_bb_id) OR

Line 1070: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS

1066: FUNCTION build_attribute
1067: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1068: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1069: , p_attribute_category IN HXC_TIME_ATTRIBUTES.attribute_category%TYPE
1070: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS
1071: BEGIN
1072: g_build_attribute_calls := g_build_attribute_calls + 1;
1073:
1074: IF NOT g_build_attribute_cache.EXISTS(p_bb_id) OR

Line 1088: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks

1084:
1085: -- Procedure to skip over related attributes and old blocks
1086: -- Used when skipping over detail blocks
1087: PROCEDURE skip_block
1088: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1089: , p_blk_idx IN OUT NOCOPY BINARY_INTEGER
1090: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1091: , p_old_blk_idx IN OUT NOCOPY BINARY_INTEGER
1092: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

Line 1090: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks

1086: -- Used when skipping over detail blocks
1087: PROCEDURE skip_block
1088: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1089: , p_blk_idx IN OUT NOCOPY BINARY_INTEGER
1090: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1091: , p_old_blk_idx IN OUT NOCOPY BINARY_INTEGER
1092: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
1093: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
1094: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

Line 1092: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

1088: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1089: , p_blk_idx IN OUT NOCOPY BINARY_INTEGER
1090: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1091: , p_old_blk_idx IN OUT NOCOPY BINARY_INTEGER
1092: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
1093: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
1094: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
1095: , p_old_att_idx IN OUT NOCOPY BINARY_INTEGER
1096: ) IS

Line 1094: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

1090: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
1091: , p_old_blk_idx IN OUT NOCOPY BINARY_INTEGER
1092: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
1093: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
1094: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
1095: , p_old_att_idx IN OUT NOCOPY BINARY_INTEGER
1096: ) IS
1097: BEGIN
1098: -- skip the attributes for this block

Line 1164: , p_raw_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info

1160: -- the attributes are in totally random order, so we use the timecard_id
1161: -- as an index into the attributes table.
1162: PROCEDURE Sort_Attributes
1163: ( p_all_attributes IN OUT NOCOPY TimecardAttributesTbl
1164: , p_raw_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1165: ) IS
1166: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
1167: l_api_name CONSTANT varchar2(30) := 'Sort_Attributes';
1168: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 1203: , p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table

1199: END Sort_Attributes;
1200:
1201: PROCEDURE Update_Attributes
1202: ( p_attributes IN OUT NOCOPY TimecardAttributesRec
1203: , p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table
1204: ) IS
1205: l_api_name CONSTANT varchar2(30) := 'Update_Attributes';
1206: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1207: po_update_flag VARCHAR2(1) :='N'; --bug 6998132

Line 1239: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1235: WHEN No_Data_Found THEN
1236: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1237: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1238: , p_message_token => 'ERR&' || 'Existing PO in uneditable state -- Finally Closed/On Hold '
1239: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1240: , p_message_field => 'PO Header Id'
1241: , p_application_short_name => 'HXC'
1242: , p_timecard_bb_id => NULL
1243: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1334: , p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table

1330: END Update_Attributes;
1331:
1332: PROCEDURE Validate_Attributes
1333: ( p_attributes IN OUT NOCOPY TimecardAttributesRec
1334: , p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table
1335: ) IS
1336: l_api_name CONSTANT varchar2(30) := 'Validate_Attributes';
1337: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1338: l_count NUMBER;

Line 1503: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1499: IF g_error_raised_flag = 0 THEN--Bug:5559915
1500: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1501: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1502: , p_message_token => 'INVALID_VALUE&' || 'PO'
1503: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1504: , p_message_field => 'PO Header Id'
1505: , p_application_short_name => 'PO'
1506: , p_timecard_bb_id => NULL
1507: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1518: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1514: IF g_error_raised_flag = 0 THEN--Bug:5559915
1515: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1516: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1517: , p_message_token => NULL
1518: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1519: , p_message_field => 'PO Header Id'
1520: , p_application_short_name => 'PO'
1521: , p_timecard_bb_id => NULL
1522: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1533: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1529: IF g_error_raised_flag = 0 THEN--Bug:5559915
1530: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1531: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1532: , p_message_token => NULL
1533: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1534: , p_message_field => 'PO Line Id'
1535: , p_application_short_name => 'PO'
1536: , p_timecard_bb_id => NULL
1537: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1548: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1544: IF g_error_raised_flag = 0 THEN--Bug:5559915
1545: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1546: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1547: , p_message_token => NULL
1548: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1549: , p_message_field => 'PO Line Id'
1550: , p_application_short_name => 'PO'
1551: , p_timecard_bb_id => NULL
1552: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1562: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1558: -- tried to record time outside of PO period
1559: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1560: , p_message_name => 'RCV_OTL_OUT_OF_PO_PER'
1561: , p_message_token => 'BB_DATE&' || p_attributes.day_start_time || '&' || 'PARAMS&' || 'PO Start Date=' || pol_start_date || ', PO Expiration Date=' || pol_end_date
1562: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1563: , p_message_field => 'PO Header Id'
1564: , p_application_short_name => 'PO'
1565: , p_timecard_bb_id => NULL
1566: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1573: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1569: -- exception while trying to validate PO information
1570: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1571: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1572: , p_message_token => 'ERR&' || 'validating PO information: ' || SQLERRM
1573: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1574: , p_message_field => 'PO Header Id'
1575: , p_application_short_name => 'HXC'
1576: , p_timecard_bb_id => NULL
1577: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1604: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1600: WHEN OTHERS THEN
1601: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1602: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1603: , p_message_token => 'ERR&' || 'validating PO Price Type information: ' || SQLERRM
1604: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1605: , p_message_field => 'PO Price Type'
1606: , p_application_short_name => 'HXC'
1607: , p_timecard_bb_id => NULL
1608: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1627: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1623: -- tried to record time outside of assignment period
1624: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1625: , p_message_name => 'RCV_OTL_OUT_OF_ASG_PER'
1626: , p_message_token => 'BB_DATE&' || p_attributes.day_start_time || '&' || 'PARAMS&' || ' '
1627: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1628: , p_message_field => 'PO Header Id'
1629: , p_application_short_name => 'PO'
1630: , p_timecard_bb_id => NULL
1631: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1638: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1634: -- exception while trying to validate assignment period
1635: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1636: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1637: , p_message_token => 'ERR&' || 'validating against assignment period: ' || SQLERRM
1638: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1639: , p_message_field => 'PO Header Id'
1640: , p_application_short_name => 'HXC'
1641: , p_timecard_bb_id => NULL
1642: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1673: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1669: -- exception while updating PO Line Amount
1670: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1671: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1672: , p_message_token => 'ERR&' || 'updating PO Line Amounts Table: ' || SQLERRM
1673: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1674: , p_message_field => NULL
1675: , p_application_short_name => 'HXC'
1676: , p_timecard_bb_id => p_attributes.detail_bb_id
1677: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1689: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1685: WHEN WRONG_BB_TYPE THEN
1686: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1687: , p_message_name => 'RCV_OTL_WRONG_BB_TYPE'
1688: , p_message_token => NULL
1689: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1690: , p_message_field => NULL
1691: , p_application_short_name => 'PO'
1692: , p_timecard_bb_id => p_attributes.detail_bb_id
1693: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1700: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1696: WHEN WRONG_BB_UOM THEN
1697: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1698: , p_message_name => 'RCV_OTL_WRONG_BB_UOM'
1699: , p_message_token => NULL
1700: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1701: , p_message_field => NULL
1702: , p_application_short_name => 'PO'
1703: , p_timecard_bb_id => p_attributes.detail_bb_id
1704: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1711: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1707: WHEN NEGATIVE_HOURS THEN
1708: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1709: , p_message_name => 'RCV_OTL_NEGATIVE_HOURS'
1710: , p_message_token => NULL
1711: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1712: , p_message_field => NULL
1713: , p_application_short_name => 'PO'
1714: , p_timecard_bb_id => p_attributes.detail_bb_id
1715: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1722: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1718: WHEN INCOMPLETE_PO_INFO THEN
1719: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1720: , p_message_name => 'RCV_OTL_INCOMPLETE_PO'
1721: , p_message_token => NULL
1722: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1723: , p_message_field => NULL
1724: , p_application_short_name => 'PO'
1725: , p_timecard_bb_id => p_attributes.detail_bb_id
1726: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1733: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1729: WHEN NO_PO_INFO THEN
1730: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1731: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1732: , p_message_token => 'INVALID_VALUE&' || 'PO'
1733: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1734: , p_message_field => 'PO Header Id'
1735: , p_application_short_name => 'PO'
1736: , p_timecard_bb_id => NULL
1737: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1743: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1739: WHEN NO_PO_LINE_INFO THEN
1740: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1741: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1742: , p_message_token => 'INVALID_VALUE&' || 'Line'
1743: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1744: , p_message_field => 'PO Line Id'
1745: , p_application_short_name => 'PO'
1746: , p_timecard_bb_id => NULL
1747: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1753: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1749: WHEN NO_RATE_INFO THEN
1750: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1751: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1752: , p_message_token => 'INVALID_VALUE&' || 'Type'
1753: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1754: , p_message_field => 'PO Price Type'
1755: , p_application_short_name => 'PO'
1756: , p_timecard_bb_id => NULL
1757: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1763: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1759: WHEN NO_AMT_INFO THEN
1760: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1761: , p_message_name => 'RCV_OTL_NO_AMT'
1762: , p_message_token => NULL
1763: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1764: , p_message_field => NULL
1765: , p_application_short_name => 'PO'
1766: , p_timecard_bb_id => p_attributes.detail_bb_id
1767: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn

Line 1774: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1770: WHEN INVALID_RATE_TYPE THEN
1771: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1772: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1773: , p_message_token => 'INVALID_VALUE&' || 'Type'
1774: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1775: , p_message_field => 'PO Price Type'
1776: , p_application_short_name => 'PO'
1777: , p_timecard_bb_id => NULL
1778: , p_time_attribute_id => p_attributes.time_attribute_id

Line 1783: ( p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table

1779: );
1780: END Validate_Attributes;
1781:
1782: PROCEDURE Validate_Amount_Tolerances
1783: ( p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table
1784: ) IS
1785: l_return_status VARCHAR2(1);
1786: l_po_line_id BINARY_INTEGER;
1787: l_timecard_amount_sum PO_LINES_ALL.amount%TYPE;

Line 1840: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_warning

1836: IF l_qty_rcv_exception_code = 'WARNING' THEN
1837: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1838: , p_message_name => 'RCV_OTL_WARN_TOLERANCE'
1839: , p_message_token => NULL
1840: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_warning
1841: , p_message_field => 'PO Header Id'
1842: , p_application_short_name => 'PO'
1843: , p_timecard_bb_id => NULL
1844: , p_time_attribute_id => get_po_line(l_po_line_id).time_attribute_id

Line 1850: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1846: ELSIF l_qty_rcv_exception_code = 'REJECT' THEN
1847: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1848: , p_message_name => 'RCV_OTL_EXCEED_TOLERANCE'
1849: , p_message_token => NULL
1850: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1851: , p_message_field => 'PO Header Id'
1852: , p_application_short_name => 'PO'
1853: , p_timecard_bb_id => NULL
1854: , p_time_attribute_id => get_po_line(l_po_line_id).time_attribute_id

Line 1871: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1867:
1868: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1869: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1870: , p_message_token => 'ERR&' || 'calling get_timecard_amount'
1871: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1872: , p_message_field => 'PO Header Id'
1873: , p_application_short_name => 'HXC'
1874: , p_timecard_bb_id => NULL
1875: , p_time_attribute_id => get_po_line(l_po_line_id).time_attribute_id

Line 1891: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

1887:
1888: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1889: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1890: , p_message_token => 'ERR&' || 'validating amount tolerances: ' || SQLERRM
1891: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1892: , p_message_field => NULL
1893: , p_application_short_name => 'HXC'
1894: , p_timecard_bb_id => NULL
1895: , p_time_attribute_id => NULL

Line 1896: , p_message_extent => HXC_USER_TYPE_DEFINITION_GRP.c_blk_children_extent

1892: , p_message_field => NULL
1893: , p_application_short_name => 'HXC'
1894: , p_timecard_bb_id => NULL
1895: , p_time_attribute_id => NULL
1896: , p_message_extent => HXC_USER_TYPE_DEFINITION_GRP.c_blk_children_extent
1897: );
1898: END Validate_Amount_Tolerances;
1899:
1900: PROCEDURE Derive_Common_RTI_Values( p_rti_row IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE%ROWTYPE

Line 3141: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks

3137: );
3138: END Insert_Interface_Values;
3139:
3140: PROCEDURE Capture_Timecard_Info
3141: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks
3142: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3143: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
3144: , p_dst_attributes IN OUT NOCOPY TimecardAttributesRec
3145: ) IS

Line 3142: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

3138: END Insert_Interface_Values;
3139:
3140: PROCEDURE Capture_Timecard_Info
3141: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks
3142: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3143: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
3144: , p_dst_attributes IN OUT NOCOPY TimecardAttributesRec
3145: ) IS
3146: l_api_name CONSTANT varchar2(30) := 'Capture_Timecard_Info';

Line 3183: l_timecard_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;

3179: );
3180:
3181: -- certain timecard information is not provided so we need to query them up
3182: DECLARE
3183: l_timecard_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3184: BEGIN
3185: l_timecard_block := RCV_HXT_GRP.build_block( p_dst_attributes.timecard_bb_id
3186: , p_dst_attributes.timecard_bb_ovn
3187: );

Line 3226: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks

3222: );
3223: END Capture_Timecard_Info;
3224:
3225: PROCEDURE Capture_Old_Timecard_Info
3226: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks
3227: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3228: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
3229: , p_dst_attributes IN OUT NOCOPY TimecardAttributesRec
3230: ) IS

Line 3227: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

3223: END Capture_Timecard_Info;
3224:
3225: PROCEDURE Capture_Old_Timecard_Info
3226: ( p_block IN HXC_USER_TYPE_DEFINITION_GRP.r_building_blocks
3227: , p_src_attributes IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3228: , p_att_idx IN OUT NOCOPY BINARY_INTEGER
3229: , p_dst_attributes IN OUT NOCOPY TimecardAttributesRec
3230: ) IS
3231: l_api_name CONSTANT varchar2(30) := 'Capture_Old_Timecard_Info';

Line 3265: l_detail_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;

3261: );
3262:
3263: -- derive day/timecard info for old block
3264: DECLARE
3265: l_detail_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3266: l_day_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3267: BEGIN
3268: l_detail_block := RCV_HXT_GRP.build_block( p_dst_attributes.detail_bb_id
3269: , p_dst_attributes.detail_bb_ovn

Line 3266: l_day_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;

3262:
3263: -- derive day/timecard info for old block
3264: DECLARE
3265: l_detail_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3266: l_day_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3267: BEGIN
3268: l_detail_block := RCV_HXT_GRP.build_block( p_dst_attributes.detail_bb_id
3269: , p_dst_attributes.detail_bb_ovn
3270: );

Line 3313: l_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;

3309: , p_attributes_rec IN OUT NOCOPY TimecardAttributesRec
3310: ) IS
3311: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';
3312: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
3313: l_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3314: l_attributes HXC_USER_TYPE_DEFINITION_GRP.attribute_info;
3315: BEGIN
3316: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3317: , module => l_log_head

Line 3314: l_attributes HXC_USER_TYPE_DEFINITION_GRP.attribute_info;

3310: ) IS
3311: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';
3312: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
3313: l_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3314: l_attributes HXC_USER_TYPE_DEFINITION_GRP.attribute_info;
3315: BEGIN
3316: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3317: , module => l_log_head
3318: , message => 'Querying bb_id=' || p_bb_id || ' bb_ovn=' || p_bb_ovn

Line 3378: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks

3374: END LOOP;
3375: END Fail_ROI_Rows;
3376:
3377: PROCEDURE Retrieve_Timecards_Body
3378: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3379: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3380: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3381: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3382: , p_receipt_date IN DATE

Line 3379: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks

3375: END Fail_ROI_Rows;
3376:
3377: PROCEDURE Retrieve_Timecards_Body
3378: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3379: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3380: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3381: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3382: , p_receipt_date IN DATE
3383: ) IS

Line 3380: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

3376:
3377: PROCEDURE Retrieve_Timecards_Body
3378: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3379: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3380: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3381: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3382: , p_receipt_date IN DATE
3383: ) IS
3384: l_processable_rows_exist varchar2(1); --Bug6000903

Line 3381: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute

3377: PROCEDURE Retrieve_Timecards_Body
3378: ( p_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3379: , p_old_blocks IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_building_blocks
3380: , p_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3381: , p_old_attributes IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute
3382: , p_receipt_date IN DATE
3383: ) IS
3384: l_processable_rows_exist varchar2(1); --Bug6000903
3385: l_rt_row new_rt_rows%ROWTYPE;

Line 3511: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERROR';

3507: excpetion DETAIL_NOT_PROCESSED unused as there will no records which will have t_tx_detail_status
3508: as NULL.
3509: This will insure that even if we encounter unexpected error then blocks will not remain as
3510: IN PROGRESS. */
3511: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERROR';
3512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO: Start Processing the Block';
3513:
3514:
3515: -- skip unapproved timecards

Line 3512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO: Start Processing the Block';

3508: as NULL.
3509: This will insure that even if we encounter unexpected error then blocks will not remain as
3510: IN PROGRESS. */
3511: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERROR';
3512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO: Start Processing the Block';
3513:
3514:
3515: -- skip unapproved timecards
3516: WHILE blk_idx <= last_blk_idx AND

Line 3519: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3515: -- skip unapproved timecards
3516: WHILE blk_idx <= last_blk_idx AND
3517: HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_blocks(blk_idx).bb_id ) <> 'APPROVED'
3518: LOOP
3519: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Timecard not approved';
3521:
3522: skip_block( p_blocks
3523: , blk_idx

Line 3520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Timecard not approved';

3516: WHILE blk_idx <= last_blk_idx AND
3517: HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_blocks(blk_idx).bb_id ) <> 'APPROVED'
3518: LOOP
3519: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Timecard not approved';
3521:
3522: skip_block( p_blocks
3523: , blk_idx
3524: , p_old_blocks

Line 3540: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-20- Capture_Timecard_Info - Start';

3536: -- clear the attribute map
3537: l_attributes := NULL;
3538: l_old_attributes := NULL;
3539: --Bug6357273
3540: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-20- Capture_Timecard_Info - Start';
3541:
3542: Capture_Timecard_Info( p_block => p_blocks(blk_idx)
3543: , p_src_attributes => p_attributes
3544: , p_att_idx => att_idx

Line 3548: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-30- Capture_Timecard_Info - End';

3544: , p_att_idx => att_idx
3545: , p_dst_attributes => l_attributes
3546: );
3547: --Bug6357273
3548: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-30- Capture_Timecard_Info - End';
3549:
3550: -- add old block info for changed blocks
3551: IF p_blocks(blk_idx).changed = 'Y' THEN
3552: --Bug6357273

Line 3553: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-40- Capture_Old_Timecard_Info - Start';

3549:
3550: -- add old block info for changed blocks
3551: IF p_blocks(blk_idx).changed = 'Y' THEN
3552: --Bug6357273
3553: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-40- Capture_Old_Timecard_Info - Start';
3554: Capture_Old_Timecard_Info( p_block => p_old_blocks(old_blk_idx)
3555: , p_src_attributes => p_old_attributes
3556: , p_att_idx => old_att_idx
3557: , p_dst_attributes => l_old_attributes

Line 3561: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-50- Capture_Old_Timecard_Info - End';

3557: , p_dst_attributes => l_old_attributes
3558: );
3559:
3560: --Bug6357273
3561: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-50- Capture_Old_Timecard_Info - End';
3562:
3563: -- maintain the old block index
3564: old_blk_idx := old_blk_idx + 1;
3565: END IF;

Line 3571: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-60- Get the PO Line - Start';

3567: , module => l_log_head
3568: , message => 'fill the po_distribution_id and line_location_id for NEW attributes'
3569: );
3570: --Bug6357273
3571: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-60- Get the PO Line - Start';
3572: -- add PO shipment and distribution information
3573: l_attributes.po_line_location_id := get_po_line(l_attributes.po_line_id).line_location_id;
3574: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-70- Get the PO Distribution for the line : '||
3575: l_attributes.po_line_id ||

Line 3574: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-70- Get the PO Distribution for the line : '||

3570: --Bug6357273
3571: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-60- Get the PO Line - Start';
3572: -- add PO shipment and distribution information
3573: l_attributes.po_line_location_id := get_po_line(l_attributes.po_line_id).line_location_id;
3574: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-70- Get the PO Distribution for the line : '||
3575: l_attributes.po_line_id ||
3576: ' Project : '||l_attributes.project_id||
3577: ' Task : '||l_attributes.task_id||
3578: ' - Start';

Line 3584: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-80- Get the PO Distribution End';

3580: l_attributes.po_distribution_id := get_po_distribution( l_attributes.po_line_id
3581: , l_attributes.project_id
3582: , l_attributes.task_id
3583: ).po_distribution_id;
3584: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-80- Get the PO Distribution End';
3585: -- bug 5976883
3586: -- need to add the shipment and distribution information to the old attributes block also
3587: -- This is required since in the derive_delete_values we build the rti based on the old_attributes
3588: -- only and the rti does not contain the dist, shipment_id values.

Line 3596: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-90- Get the PO line for Old block - Start';

3592: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3593: , module => l_log_head
3594: , message => 'fill the po_distribution_id and line_location_id for old attributes'
3595: );
3596: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-90- Get the PO line for Old block - Start';
3597: l_old_attributes.po_line_location_id := get_po_line(l_old_attributes.po_line_id).line_location_id;
3598: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-100- Get the PO Distribution for the Old line : '||
3599: l_old_attributes.po_line_id ||
3600: ' Project : '||l_old_attributes.project_id||

Line 3598: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-100- Get the PO Distribution for the Old line : '||

3594: , message => 'fill the po_distribution_id and line_location_id for old attributes'
3595: );
3596: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-90- Get the PO line for Old block - Start';
3597: l_old_attributes.po_line_location_id := get_po_line(l_old_attributes.po_line_id).line_location_id;
3598: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-100- Get the PO Distribution for the Old line : '||
3599: l_old_attributes.po_line_id ||
3600: ' Project : '||l_old_attributes.project_id||
3601: ' Task : '||l_old_attributes.task_id||
3602: ' - Start';

Line 3607: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-110- Get the Old PO Distribution End';

3603: l_old_attributes.po_distribution_id := get_po_distribution( l_old_attributes.po_line_id
3604: , l_old_attributes.project_id
3605: , l_old_attributes.task_id
3606: ).po_distribution_id;
3607: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-110- Get the Old PO Distribution End';
3608:
3609: END IF;
3610:
3611: -- set the receipt date

Line 3615: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-120- Calculate the RTI values - Start';

3611: -- set the receipt date
3612: l_attributes.po_receipt_date := p_receipt_date;
3613:
3614: -- derive roi field values from timecard attributes
3615: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-120- Calculate the RTI values - Start';
3616: Derive_Interface_Values(l_attributes, l_old_attributes, l_rhi_rows, l_rti_rows);
3617: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-130- Calculate the RTI values - End';
3618: -- add attributes to big table for use later
3619: l_all_attributes(l_attributes.detail_bb_id) := l_attributes;

Line 3617: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-130- Calculate the RTI values - End';

3613:
3614: -- derive roi field values from timecard attributes
3615: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-120- Calculate the RTI values - Start';
3616: Derive_Interface_Values(l_attributes, l_old_attributes, l_rhi_rows, l_rti_rows);
3617: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-130- Calculate the RTI values - End';
3618: -- add attributes to big table for use later
3619: l_all_attributes(l_attributes.detail_bb_id) := l_attributes;
3620:
3621: -- advance the block loop counter

Line 3628: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3624: WHEN OTHERS THEN
3625: --Bug6357273
3626: -- save the exception description before we lose it and upending the message with the
3627: -- Status message for that block.
3628: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3629: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3630: || 'Unexpected exception while processing results from Generic Retrieval: ' || SQLERRM;
3631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3632: , module => l_log_head

Line 3629: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

3625: --Bug6357273
3626: -- save the exception description before we lose it and upending the message with the
3627: -- Status message for that block.
3628: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3629: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3630: || 'Unexpected exception while processing results from Generic Retrieval: ' || SQLERRM;
3631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3632: , module => l_log_head
3633: , message =>HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

Line 3633: , message =>HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

3629: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3630: || 'Unexpected exception while processing results from Generic Retrieval: ' || SQLERRM;
3631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3632: , module => l_log_head
3633: , message =>HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3634: );
3635:
3636: -- When a detail fails, we need to fail the entire timecard.
3637: -- The detail blocks are ordered by day, and timecard, so we only need to search adjacent detail blocks

Line 3652: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_exp_idx) := 'ERRORS';

3648: --Bug6357273
3649: --Even the previous time card blocks which are processed so far need to be skipped and stamped with appropriate error message
3650: l_exp_idx := blk_idx - 1;
3651: WHILE l_exp_idx >= 1 AND p_blocks(l_exp_idx).timecard_bb_id = failed_timecard_id LOOP
3652: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_exp_idx) := 'ERRORS';
3653: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_exp_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';
3654: l_exp_idx := l_exp_idx -1;
3655: END LOOP;
3656:

Line 3653: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_exp_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';

3649: --Even the previous time card blocks which are processed so far need to be skipped and stamped with appropriate error message
3650: l_exp_idx := blk_idx - 1;
3651: WHILE l_exp_idx >= 1 AND p_blocks(l_exp_idx).timecard_bb_id = failed_timecard_id LOOP
3652: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_exp_idx) := 'ERRORS';
3653: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_exp_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';
3654: l_exp_idx := l_exp_idx -1;
3655: END LOOP;
3656:
3657: -- Those that will come after can be aborted by simply skipping over them

Line 3661: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3657: -- Those that will come after can be aborted by simply skipping over them
3658: blk_idx := blk_idx + 1;
3659: WHILE blk_idx <= last_blk_idx AND p_blocks(blk_idx).timecard_bb_id = failed_timecard_id LOOP
3660: -- set the error description while we still know what happened
3661: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3662: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';
3663:
3664: skip_block( p_blocks
3665: , blk_idx

Line 3662: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';

3658: blk_idx := blk_idx + 1;
3659: WHILE blk_idx <= last_blk_idx AND p_blocks(blk_idx).timecard_bb_id = failed_timecard_id LOOP
3660: -- set the error description while we still know what happened
3661: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3662: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Skipped because detail block '||failed_detail_block_id||' in the same timecard failed';
3663:
3664: skip_block( p_blocks
3665: , blk_idx
3666: , p_old_blocks

Line 3877: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'SUCCESS';

3873: AND l_rti_status.EXISTS(l_deliver_rti_id)
3874: AND l_rti_status.EXISTS(l_delete_receive_rti_id)
3875: AND l_rti_status.EXISTS(l_delete_deliver_rti_id)) THEN
3876:
3877: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'SUCCESS';
3878: g_successful_details := g_successful_details + 1;
3879:
3880: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3881: , module => l_log_head

Line 3886: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3882: , message => 'Detail success'
3883: );
3884:
3885: ELSE
3886: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3887: -- BUG6357273
3888: -- Propogating RTP errors back to the OTL.
3889: -- Logic : We are looping through all the records from rcv_transaction_interface
3890: -- for the Transaction Line id which is not there in the l_rti_status table which

Line 3911: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN

3907:
3908: l_message := l_message || rec.msg;
3909: END LOOP;
3910:
3911: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3912: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Receipt not created : '||l_message;
3913: ELSE
3914: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) || ' Receipt not created : '||l_message;
3915: END IF;

Line 3912: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Receipt not created : '||l_message;

3908: l_message := l_message || rec.msg;
3909: END LOOP;
3910:
3911: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3912: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Receipt not created : '||l_message;
3913: ELSE
3914: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) || ' Receipt not created : '||l_message;
3915: END IF;
3916: g_failed_details := g_failed_details + 1;

Line 3914: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) || ' Receipt not created : '||l_message;

3910:
3911: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3912: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Receipt not created : '||l_message;
3913: ELSE
3914: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) || ' Receipt not created : '||l_message;
3915: END IF;
3916: g_failed_details := g_failed_details + 1;
3917:
3918: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

Line 3920: , message => 'Detail error '||HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

3916: g_failed_details := g_failed_details + 1;
3917:
3918: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3919: , module => l_log_head
3920: , message => 'Detail error '||HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3921: );
3922: END IF;
3923: EXCEPTION
3924: WHEN DETAIL_NOT_PROCESSED THEN

Line 3926: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) IS NULL THEN

3922: END IF;
3923: EXCEPTION
3924: WHEN DETAIL_NOT_PROCESSED THEN
3925: -- only set generic message if not already set when ignoring block
3926: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) IS NULL THEN
3927: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3928: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Detail block not processed';
3929: ELSE
3930: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

Line 3927: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3923: EXCEPTION
3924: WHEN DETAIL_NOT_PROCESSED THEN
3925: -- only set generic message if not already set when ignoring block
3926: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) IS NULL THEN
3927: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3928: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Detail block not processed';
3929: ELSE
3930: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3931: || ' Detail block not processed';

Line 3928: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Detail block not processed';

3924: WHEN DETAIL_NOT_PROCESSED THEN
3925: -- only set generic message if not already set when ignoring block
3926: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) IS NULL THEN
3927: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3928: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Detail block not processed';
3929: ELSE
3930: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3931: || ' Detail block not processed';
3932: END IF;

Line 3930: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)

3926: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) IS NULL THEN
3927: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3928: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Detail block not processed';
3929: ELSE
3930: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3931: || ' Detail block not processed';
3932: END IF;
3933: g_failed_details := g_failed_details + 1;
3934:

Line 3941: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';

3937: , message => 'Detail block not processed'
3938: );
3939:
3940: WHEN OTHERS THEN
3941: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3942: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3943: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Unexpected exception while checking receipt
3944: for detail block: ' || SQLERRM;
3945: ELSE

Line 3942: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN

3938: );
3939:
3940: WHEN OTHERS THEN
3941: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3942: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3943: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Unexpected exception while checking receipt
3944: for detail block: ' || SQLERRM;
3945: ELSE
3946: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception

Line 3943: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Unexpected exception while checking receipt

3939:
3940: WHEN OTHERS THEN
3941: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3942: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3943: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Unexpected exception while checking receipt
3944: for detail block: ' || SQLERRM;
3945: ELSE
3946: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception
3947: (blk_idx) || 'Exception while checking receipt for detail block: ' || SQLERRM;

Line 3946: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception

3942: IF HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) IS NULL THEN
3943: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Unexpected exception while checking receipt
3944: for detail block: ' || SQLERRM;
3945: ELSE
3946: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception
3947: (blk_idx) || 'Exception while checking receipt for detail block: ' || SQLERRM;
3948: END IF;
3949: g_failed_details := g_failed_details + 1;
3950:

Line 4139: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

4135: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4136:
4137: l_all_attributes TimecardAttributesTbl;
4138:
4139: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4140: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4141: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4142: l_api_name CONSTANT varchar2(30) := 'Update_Timecard';
4143: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 4140: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

4136:
4137: l_all_attributes TimecardAttributesTbl;
4138:
4139: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4140: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4141: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4142: l_api_name CONSTANT varchar2(30) := 'Update_Timecard';
4143: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
4144: BEGIN

Line 4141: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;

4137: l_all_attributes TimecardAttributesTbl;
4138:
4139: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4140: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4141: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4142: l_api_name CONSTANT varchar2(30) := 'Update_Timecard';
4143: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
4144: BEGIN
4145: g_update_start := SYSDATE;

Line 4223: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

4219: l_attributes_rec TimecardAttributesRec;
4220: l_old_attributes_rec TimecardAttributesRec;
4221: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4222:
4223: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4224: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4225: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4226: l_api_name CONSTANT varchar2(30) := 'Validate_Timecard';
4227: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 4224: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

4220: l_old_attributes_rec TimecardAttributesRec;
4221: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4222:
4223: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4224: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4225: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4226: l_api_name CONSTANT varchar2(30) := 'Validate_Timecard';
4227: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
4228: BEGIN

Line 4225: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;

4221: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4222:
4223: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4224: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4225: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
4226: l_api_name CONSTANT varchar2(30) := 'Validate_Timecard';
4227: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
4228: BEGIN
4229: g_validate_start := SYSDATE;

Line 4430: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error

4426: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
4427:
4428:
4429: , p_message_token => 'ERR&' || 'validating timecard: ' || SQLERRM
4430: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
4431: , p_message_field => NULL
4432: , p_application_short_name => 'HXC'
4433: , p_timecard_bb_id => NULL
4434: , p_time_attribute_id => NULL

Line 4435: , p_message_extent => HXC_USER_TYPE_DEFINITION_GRP.c_blk_children_extent

4431: , p_message_field => NULL
4432: , p_application_short_name => 'HXC'
4433: , p_timecard_bb_id => NULL
4434: , p_time_attribute_id => NULL
4435: , p_message_extent => HXC_USER_TYPE_DEFINITION_GRP.c_blk_children_extent
4436: );
4437:
4438: END Validate_Timecard;
4439:

Line 4582: g_retrieved_details := g_retrieved_details + HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT;

4578:
4579: RAISE GENERIC_RETRIEVAL_FAILED;
4580: END;
4581:
4582: g_retrieved_details := g_retrieved_details + HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT;
4583:
4584: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4585: , module => l_log_head
4586: , message => 'Returned from Generic Retrieval with '

Line 4587: || HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT

4583:
4584: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4585: , module => l_log_head
4586: , message => 'Returned from Generic Retrieval with '
4587: || HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT
4588: || ' detail blocks'
4589: );
4590:
4591: -- are there any more timecard blocks to process?

Line 4592: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT > 0 THEN

4588: || ' detail blocks'
4589: );
4590:
4591: -- are there any more timecard blocks to process?
4592: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT > 0 THEN
4593: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4594: , module => l_log_head
4595: , message => 'Calling Retrieval Body...'
4596: );

Line 4604: Retrieve_Timecards_Body( p_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks

4600: -- We are calling Generic retrieval in the loop now, so there can be multiple batches in
4601: -- Retrieval program. SO now even if one batch get failed due to some error, other batches
4602: -- will executed and the summery report will be printed.
4603: BEGIN
4604: Retrieve_Timecards_Body( p_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks
4605: , p_old_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks
4606: , p_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes
4607: , p_old_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes
4608: , p_receipt_date => l_receipt_date

Line 4605: , p_old_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks

4601: -- Retrieval program. SO now even if one batch get failed due to some error, other batches
4602: -- will executed and the summery report will be printed.
4603: BEGIN
4604: Retrieve_Timecards_Body( p_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks
4605: , p_old_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks
4606: , p_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes
4607: , p_old_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes
4608: , p_receipt_date => l_receipt_date
4609: );

Line 4606: , p_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes

4602: -- will executed and the summery report will be printed.
4603: BEGIN
4604: Retrieve_Timecards_Body( p_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks
4605: , p_old_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks
4606: , p_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes
4607: , p_old_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes
4608: , p_receipt_date => l_receipt_date
4609: );
4610: EXCEPTION

Line 4607: , p_old_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes

4603: BEGIN
4604: Retrieve_Timecards_Body( p_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks
4605: , p_old_blocks => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks
4606: , p_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes
4607: , p_old_attributes => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes
4608: , p_receipt_date => l_receipt_date
4609: );
4610: EXCEPTION
4611: WHEN OTHERS THEN