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_INTEGRATION_LAYER_V1_GRP

Line 1075: g_build_block_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_block(p_bb_id, p_bb_ovn);

1071: IF NOT g_build_block_cache.EXISTS(p_bb_id) OR
1072: g_build_block_cache(p_bb_id).object_version_number <> p_bb_ovn
1073: THEN
1074: g_build_block_misses := g_build_block_misses + 1;
1075: g_build_block_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_block(p_bb_id, p_bb_ovn);
1076: END IF;
1077:
1078: RETURN g_build_block_cache(p_bb_id);
1079: END build_block;

Line 1096: g_build_attribute_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_attribute( p_bb_id, p_bb_ovn, p_attribute_category )(1);

1092: IF NOT g_build_attribute_cache.EXISTS(p_bb_id) OR
1093: g_build_attribute_cache(p_bb_id).object_version_number <> p_bb_ovn OR
1094: g_build_attribute_cache(p_bb_id).attribute_category <> p_attribute_category THEN
1095: g_build_attribute_misses := g_build_attribute_misses + 1;
1096: g_build_attribute_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_attribute( p_bb_id, p_bb_ovn, p_attribute_category )(1);
1097: END IF;
1098:
1099: RETURN g_build_attribute_cache(p_bb_id);
1100: END build_attribute;

Line 1276: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1272: AND Nvl(user_hold_flag,'N') <> 'Y'
1273: );
1274: EXCEPTION
1275: WHEN No_Data_Found THEN
1276: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1277: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1278: , p_message_token => 'ERR&' || 'Existing PO in uneditable state -- Finally Closed/On Hold '
1279: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1280: , p_message_field => 'PO Header Id'

Line 1534: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1530: * So, before logging the PO and PO line related error message
1531: * checking whether error message is already logged or not.
1532: */
1533: IF g_error_raised_flag = 0 THEN--Bug:5559915
1534: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1535: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1536: , p_message_token => 'INVALID_VALUE&' || 'PO'
1537: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1538: , p_message_field => 'PO Header Id'

Line 1549: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1545: RETURN;
1546: WHEN INVALID_PO_EDIT THEN
1547: -- invalid PO information on edit timecard
1548: IF g_error_raised_flag = 0 THEN--Bug:5559915
1549: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1550: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1551: , p_message_token => NULL
1552: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1553: , p_message_field => 'PO Header Id'

Line 1564: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1560: RETURN;
1561: WHEN INVALID_PO_LINE THEN
1562: -- invalid PO information
1563: IF g_error_raised_flag = 0 THEN--Bug:5559915
1564: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1565: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1566: , p_message_token => NULL
1567: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1568: , p_message_field => 'PO Line Id'

Line 1579: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1575: RETURN;
1576: WHEN INVALID_PO_LINE_EDIT THEN
1577: -- invalid PO information on edit timecard
1578: IF g_error_raised_flag = 0 THEN--Bug:5559915
1579: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1580: , p_message_name => 'RCV_OTL_UPDATE_INVALID_PO'
1581: , p_message_token => NULL
1582: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1583: , p_message_field => 'PO Line Id'

Line 1593: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1589: END IF;
1590: RETURN;
1591: WHEN BB_DATE_OUT_OF_PO_PERIOD THEN
1592: -- tried to record time outside of PO period
1593: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1594: , p_message_name => 'RCV_OTL_OUT_OF_PO_PER'
1595: , p_message_token => 'BB_DATE&' || p_attributes.day_start_time || '&' || 'PARAMS&' || 'PO Start Date=' || pol_start_date || ', PO Expiration Date=' || pol_end_date
1596: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1597: , p_message_field => 'PO Header Id'

Line 1604: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1600: , p_time_attribute_id => p_attributes.time_attribute_id
1601: );
1602: WHEN OTHERS THEN
1603: -- exception while trying to validate PO information
1604: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1605: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1606: , p_message_token => 'ERR&' || 'validating PO information: ' || SQLERRM
1607: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1608: , p_message_field => 'PO Header Id'

Line 1634: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1630: WHEN INVALID_RATE_TYPE THEN
1631: -- the price differential exists but is not enabled
1632: RAISE;
1633: WHEN OTHERS THEN
1634: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1635: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1636: , p_message_token => 'ERR&' || 'validating PO Price Type information: ' || SQLERRM
1637: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1638: , p_message_field => 'PO Price Type'

Line 1657: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1653: );
1654: EXCEPTION
1655: WHEN NO_DATA_FOUND THEN
1656: -- tried to record time outside of assignment period
1657: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1658: , p_message_name => 'RCV_OTL_OUT_OF_ASG_PER'
1659: , p_message_token => 'BB_DATE&' || p_attributes.day_start_time || '&' || 'PARAMS&' || ' '
1660: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1661: , p_message_field => 'PO Header Id'

Line 1668: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1664: , p_time_attribute_id => p_attributes.time_attribute_id
1665: );
1666: WHEN OTHERS THEN
1667: -- exception while trying to validate assignment period
1668: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1669: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1670: , p_message_token => 'ERR&' || 'validating against assignment period: ' || SQLERRM
1671: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1672: , p_message_field => 'PO Header Id'

Line 1702: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1698: END IF;
1699: EXCEPTION
1700: WHEN OTHERS THEN
1701: -- exception while updating PO Line Amount
1702: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1703: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1704: , p_message_token => 'ERR&' || 'updating PO Line Amounts Table: ' || SQLERRM
1705: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1706: , p_message_field => NULL

Line 1718: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1714: -- everything went through fine so set the status to success
1715: p_attributes.validation_status := 'SUCCESS';
1716: EXCEPTION
1717: WHEN WRONG_BB_TYPE THEN
1718: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1719: , p_message_name => 'RCV_OTL_WRONG_BB_TYPE'
1720: , p_message_token => NULL
1721: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1722: , p_message_field => NULL

Line 1729: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1725: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1726: , p_time_attribute_id => NULL
1727: );
1728: WHEN WRONG_BB_UOM THEN
1729: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1730: , p_message_name => 'RCV_OTL_WRONG_BB_UOM'
1731: , p_message_token => NULL
1732: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1733: , p_message_field => NULL

Line 1740: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1736: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1737: , p_time_attribute_id => NULL
1738: );
1739: WHEN NEGATIVE_HOURS THEN
1740: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1741: , p_message_name => 'RCV_OTL_NEGATIVE_HOURS'
1742: , p_message_token => NULL
1743: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1744: , p_message_field => NULL

Line 1751: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1747: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1748: , p_time_attribute_id => NULL
1749: );
1750: WHEN INCOMPLETE_PO_INFO THEN
1751: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1752: , p_message_name => 'RCV_OTL_INCOMPLETE_PO'
1753: , p_message_token => NULL
1754: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1755: , p_message_field => NULL

Line 1762: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1758: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1759: , p_time_attribute_id => NULL
1760: );
1761: WHEN NO_PO_INFO THEN
1762: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1763: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1764: , p_message_token => 'INVALID_VALUE&' || 'PO'
1765: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1766: , p_message_field => 'PO Header Id'

Line 1772: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1768: , p_timecard_bb_id => NULL
1769: , p_time_attribute_id => p_attributes.time_attribute_id
1770: );
1771: WHEN NO_PO_LINE_INFO THEN
1772: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1773: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1774: , p_message_token => 'INVALID_VALUE&' || 'Line'
1775: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1776: , p_message_field => 'PO Line Id'

Line 1782: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1778: , p_timecard_bb_id => NULL
1779: , p_time_attribute_id => p_attributes.time_attribute_id
1780: );
1781: WHEN NO_RATE_INFO THEN
1782: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1783: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1784: , p_message_token => 'INVALID_VALUE&' || 'Type'
1785: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1786: , p_message_field => 'PO Price Type'

Line 1792: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1788: , p_timecard_bb_id => NULL
1789: , p_time_attribute_id => p_attributes.time_attribute_id
1790: );
1791: WHEN NO_AMT_INFO THEN
1792: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1793: , p_message_name => 'RCV_OTL_NO_AMT'
1794: , p_message_token => NULL
1795: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1796: , p_message_field => NULL

Line 1803: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1799: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1800: , p_time_attribute_id => NULL
1801: );
1802: WHEN INVALID_RATE_TYPE THEN
1803: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1804: , p_message_name => 'RCV_OTL_INVALID_VALUE'
1805: , p_message_token => 'INVALID_VALUE&' || 'Type'
1806: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1807: , p_message_field => 'PO Price Type'

Line 1847: l_timecard_amount_sum := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum

1843: );
1844:
1845: IF l_qty_rcv_exception_code IN ('WARNING', 'REJECT') THEN
1846: -- consider the amounts already accounted for in submitted timecards
1847: l_timecard_amount_sum := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum
1848: ( p_bld_blk_info_type => 'PURCHASING'
1849: , p_field_name1 => 'PO Billable Amount'
1850: , p_field_name2 => 'PO Line Id'
1851: , p_field_value2 => l_po_line_id

Line 1869: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1865:
1866: -- finally check if the tolerance will be broken
1867: IF get_po_line(l_po_line_id).timecard_amount + l_timecard_amount_sum > l_tolerable_amount THEN
1868: IF l_qty_rcv_exception_code = 'WARNING' THEN
1869: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1870: , p_message_name => 'RCV_OTL_WARN_TOLERANCE'
1871: , p_message_token => NULL
1872: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_warning
1873: , p_message_field => 'PO Header Id'

Line 1879: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1875: , p_timecard_bb_id => NULL
1876: , p_time_attribute_id => get_po_line(l_po_line_id).time_attribute_id
1877: );
1878: ELSIF l_qty_rcv_exception_code = 'REJECT' THEN
1879: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1880: , p_message_name => 'RCV_OTL_EXCEED_TOLERANCE'
1881: , p_message_token => NULL
1882: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1883: , p_message_field => 'PO Header Id'

Line 1900: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1896: , module => l_log_head
1897: , message => 'PO_HXC_INTERFACE_PVT.get_timecard_amount returned error'
1898: );
1899:
1900: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1901: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1902: , p_message_token => 'ERR&' || 'calling get_timecard_amount'
1903: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1904: , p_message_field => 'PO Header Id'

Line 1920: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1916: , module => l_log_head
1917: , message => 'Unexpected exception validating amount tolerances: ' || SQLERRM
1918: );
1919:
1920: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages
1921: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
1922: , p_message_token => 'ERR&' || 'validating amount tolerances: ' || SQLERRM
1923: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
1924: , p_message_field => NULL

Line 3253: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );

3249: p_dst_attributes.timecard_start_time := l_timecard_block.start_time;
3250: p_dst_attributes.timecard_stop_time := l_timecard_block.stop_time;
3251:
3252: -- these functions are cached so we do not have to cache the results
3253: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3254: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3255: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3256: IF g_debug_stmt THEN
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date', p_dst_attributes.timecard_approval_date);

Line 3254: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );

3250: p_dst_attributes.timecard_stop_time := l_timecard_block.stop_time;
3251:
3252: -- these functions are cached so we do not have to cache the results
3253: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3254: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3255: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3256: IF g_debug_stmt THEN
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date', p_dst_attributes.timecard_approval_date);
3258: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_submission_date', p_dst_attributes.timecard_submission_date);

Line 3255: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );

3251:
3252: -- these functions are cached so we do not have to cache the results
3253: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3254: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3255: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3256: IF g_debug_stmt THEN
3257: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date', p_dst_attributes.timecard_approval_date);
3258: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_submission_date', p_dst_attributes.timecard_submission_date);
3259: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_status', p_dst_attributes.timecard_approval_status);

Line 3586: HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_blocks(blk_idx).bb_id ) <> 'APPROVED'

3582: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO: Start Processing the Block';
3583:
3584: -- skip unapproved timecards
3585: WHILE blk_idx <= last_blk_idx AND
3586: HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_blocks(blk_idx).bb_id ) <> 'APPROVED'
3587: LOOP
3588: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3589: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'Timecard not approved';
3590:

Line 4071: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4067: , message => 'Setting Day/Timecard Statuses'
4068: );
4069:
4070: -- update status for day and timecard building blocks
4071: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4072:
4073: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4074: , module => l_log_head
4075: , message => 'Setting Transaction Status'

Line 4093: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4089: g_txn_status := 'SUCCESS';
4090: g_txn_msg := 'Receiving Transactions created';
4091: END IF;
4092:
4093: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4094: p_process => 'Purchasing Retrieval Process'
4095: , p_status => g_txn_status
4096: , p_exception_description => g_txn_msg
4097: );

Line 4121: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4117: -- Bug6357273.
4118: -- In the case also we need to propogate message back to OTL
4119: -- Which will help OTL to debug by the records got failed
4120: ROLLBACK;
4121: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4122: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4123: p_process => 'Purchasing Retrieval Process'
4124: , p_status => 'ERRORS'
4125: , p_exception_description => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'

Line 4122: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4118: -- In the case also we need to propogate message back to OTL
4119: -- Which will help OTL to debug by the records got failed
4120: ROLLBACK;
4121: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4122: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4123: p_process => 'Purchasing Retrieval Process'
4124: , p_status => 'ERRORS'
4125: , p_exception_description => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'
4126: );

Line 4138: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4134: -- Bug6357273.
4135: -- In the case also we need to propogate message back to OTL
4136: -- Which will help OTL to debug by the records got failed
4137: ROLLBACK;
4138: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4139: -- this is only raised in the first call to reconcile actions. the later one is not fatal.
4140: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4141: p_process => 'Purchasing Retrieval Process'
4142: , p_status => 'ERRORS'

Line 4140: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4136: -- Which will help OTL to debug by the records got failed
4137: ROLLBACK;
4138: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4139: -- this is only raised in the first call to reconcile actions. the later one is not fatal.
4140: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4141: p_process => 'Purchasing Retrieval Process'
4142: , p_status => 'ERRORS'
4143: , p_exception_description => g_txn_msg || 'Error calling Reconcile_Actions, please see FND_LOG_MESSAGES for details'
4144: );

Line 4152: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4148: -- Bug6357273.
4149: -- In the case also we need to propogate message back to OTL
4150: -- Which will help OTL to debug by the records got failed
4151: ROLLBACK;
4152: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4153: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4154: p_process => 'Purchasing Retrieval Process'
4155: , p_status => 'ERRORS'
4156: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

Line 4153: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4149: -- In the case also we need to propogate message back to OTL
4150: -- Which will help OTL to debug by the records got failed
4151: ROLLBACK;
4152: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4153: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4154: p_process => 'Purchasing Retrieval Process'
4155: , p_status => 'ERRORS'
4156: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4157: );

Line 4165: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4161: -- Bug6357273.
4162: -- In the case also we need to propogate message back to OTL
4163: -- Which will help OTL to debug by the records got failed
4164: ROLLBACK;
4165: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4166: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4167: p_process => 'Purchasing Retrieval Process'
4168: , p_status => 'ERRORS'
4169: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

Line 4166: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4162: -- In the case also we need to propogate message back to OTL
4163: -- Which will help OTL to debug by the records got failed
4164: ROLLBACK;
4165: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4166: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4167: p_process => 'Purchasing Retrieval Process'
4168: , p_status => 'ERRORS'
4169: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4170: );

Line 4178: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4174: -- Bug6357273.
4175: -- In the case also we need to propogate message back to OTL
4176: -- Which will help OTL to debug by the records got failed
4177: ROLLBACK;
4178: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4179:
4180:
4181: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4182: p_process => 'Purchasing Retrieval Process'

Line 4181: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4177: ROLLBACK;
4178: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4179:
4180:
4181: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4182: p_process => 'Purchasing Retrieval Process'
4183: , p_status => 'ERRORS'
4184: , p_exception_description => SUBSTR(g_txn_msg || 'Unexpected exception in Retrieve_Timecards_Body: ' || SQLERRM, 1, 2000)
4185: );

Line 4225: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(

4221: , message => 'Begin Update_Timecard'
4222: );
4223:
4224: -- get time information
4225: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(
4226: p_building_blocks => l_blocks,
4227: p_app_attributes => l_attributes,
4228: p_messages => l_messages);
4229:

Line 4272: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(

4268: END IF;
4269: END LOOP;
4270:
4271: -- set time information
4272: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(
4273: p_building_blocks => l_blocks,
4274: p_app_attributes => l_attributes,
4275: p_messages => l_messages);
4276:

Line 4312: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(

4308: , message => 'Begin Validate_Timecard'
4309: );
4310:
4311: -- get time information
4312: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(
4313: p_building_blocks => l_blocks,
4314: p_app_attributes => l_attributes,
4315: p_messages => l_messages);
4316:

Line 4564: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(

4560: -- validate the amount tolerances
4561: Validate_Amount_Tolerances(l_messages);
4562:
4563: -- set time information
4564: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(
4565: p_building_blocks => l_blocks,
4566: p_app_attributes => l_attributes,
4567: p_messages => l_messages);
4568:

Line 4595: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => l_messages

4591: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4592: );
4593: EXCEPTION
4594: WHEN OTHERS THEN
4595: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => l_messages
4596: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
4597: , p_message_token => 'ERR&' || 'validating timecard: ' || SQLERRM
4598: , p_message_level => HXC_USER_TYPE_DEFINITION_GRP.c_error
4599: , p_message_field => NULL

Line 4718: HXC_INTEGRATION_LAYER_V1_GRP.Execute_Retrieval_Process(

4714: -- call the generic retrieval package to populate global tables
4715: BEGIN
4716: g_generic_start := SYSDATE;
4717:
4718: HXC_INTEGRATION_LAYER_V1_GRP.Execute_Retrieval_Process(
4719: P_Process => 'Purchasing Retrieval Process',
4720: P_Transaction_code => NULL,
4721: P_Start_Date => l_start_date,
4722: P_End_Date => l_end_date,

Line 4790: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4786: );
4787: ELSE
4788: l_more_timecards := FALSE;
4789:
4790: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4791: p_process => 'Purchasing Retrieval Process'
4792: , p_status => 'SUCCESS'
4793: , p_exception_description => 'No more rows to process'
4794: );

Line 4851: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4847: WHEN SUCCESS_SHORT_CIRCUIT THEN
4848: errbuf := G_CONC_LOG;
4849: retcode := 0;
4850: -- 13612527: Updating Transaction status to ERRORS which allows other request to run.
4851: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4852: p_process => 'Purchasing Retrieval Process'
4853: , p_status => 'ERRORS'
4854: , p_exception_description => G_CONC_LOG
4855: );

Line 4860: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4856: WHEN GENERIC_RETRIEVAL_FAILED THEN
4857: errbuf := G_CONC_LOG;
4858: retcode := 2;
4859: -- 13612527: Updating Transaction status to ERRORS which allows other request to run.
4860: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4861: p_process => 'Purchasing Retrieval Process'
4862: , p_status => 'ERRORS'
4863: , p_exception_description => G_CONC_LOG
4864: );

Line 4873: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4869: );
4870: errbuf := G_CONC_LOG;
4871: retcode := 2;
4872: -- 13612527: Updating Transaction status to ERRORS which allows other request to run.
4873: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4874: p_process => 'Purchasing Retrieval Process'
4875: , p_status => 'ERRORS'
4876: , p_exception_description => G_CONC_LOG
4877: );