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 1057: g_build_block_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_block(p_bb_id, p_bb_ovn);

1053: IF NOT g_build_block_cache.EXISTS(p_bb_id) OR
1054: g_build_block_cache(p_bb_id).object_version_number <> p_bb_ovn
1055: THEN
1056: g_build_block_misses := g_build_block_misses + 1;
1057: g_build_block_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_block(p_bb_id, p_bb_ovn);
1058: END IF;
1059:
1060: RETURN g_build_block_cache(p_bb_id);
1061: END build_block;

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

1075: g_build_attribute_cache(p_bb_id).object_version_number <> p_bb_ovn OR
1076: g_build_attribute_cache(p_bb_id).attribute_category <> p_attribute_category
1077: THEN
1078: g_build_attribute_misses := g_build_attribute_misses + 1;
1079: g_build_attribute_cache(p_bb_id) := HXC_INTEGRATION_LAYER_V1_GRP.build_attribute( p_bb_id, p_bb_ovn, p_attribute_category )(1);
1080: END IF;
1081:
1082: RETURN g_build_attribute_cache(p_bb_id);
1083: END build_attribute;

Line 1236: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1232: AND Nvl(user_hold_flag,'N') <> 'Y'
1233: );
1234: EXCEPTION
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'

Line 1500: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1496: * So, before logging the PO and PO line related error message
1497: * checking whether error message is already logged or not.
1498: */
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'

Line 1515: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1511: RETURN;
1512: WHEN INVALID_PO_EDIT THEN
1513: -- invalid PO information on edit timecard
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'

Line 1530: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1526: RETURN;
1527: WHEN INVALID_PO_LINE THEN
1528: -- invalid PO information
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'

Line 1545: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1541: RETURN;
1542: WHEN INVALID_PO_LINE_EDIT THEN
1543: -- invalid PO information on edit timecard
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'

Line 1559: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1555: END IF;
1556: RETURN;
1557: WHEN BB_DATE_OUT_OF_PO_PERIOD THEN
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'

Line 1570: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1566: , p_time_attribute_id => p_attributes.time_attribute_id
1567: );
1568: WHEN OTHERS THEN
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'

Line 1601: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1597: WHEN INVALID_RATE_TYPE THEN
1598: -- the price differential exists but is not enabled
1599: RAISE;
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'

Line 1624: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1620: );
1621: EXCEPTION
1622: WHEN NO_DATA_FOUND THEN
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'

Line 1635: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1631: , p_time_attribute_id => p_attributes.time_attribute_id
1632: );
1633: WHEN OTHERS THEN
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'

Line 1670: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1666: END IF;
1667: EXCEPTION
1668: WHEN OTHERS THEN
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

Line 1686: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1682: -- everything went through fine so set the status to success
1683: p_attributes.validation_status := 'SUCCESS';
1684: EXCEPTION
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

Line 1697: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1693: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1694: , p_time_attribute_id => NULL
1695: );
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

Line 1708: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1704: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1705: , p_time_attribute_id => NULL
1706: );
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

Line 1719: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1715: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1716: , p_time_attribute_id => NULL
1717: );
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

Line 1730: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1726: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1727: , p_time_attribute_id => NULL
1728: );
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'

Line 1740: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1736: , p_timecard_bb_id => NULL
1737: , p_time_attribute_id => p_attributes.time_attribute_id
1738: );
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'

Line 1750: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1746: , p_timecard_bb_id => NULL
1747: , p_time_attribute_id => p_attributes.time_attribute_id
1748: );
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'

Line 1760: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1756: , p_timecard_bb_id => NULL
1757: , p_time_attribute_id => p_attributes.time_attribute_id
1758: );
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

Line 1771: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1767: , p_timecard_bb_ovn => p_attributes.detail_bb_ovn
1768: , p_time_attribute_id => NULL
1769: );
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'

Line 1815: l_timecard_amount_sum := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum

1811: );
1812:
1813: IF l_qty_rcv_exception_code IN ('WARNING', 'REJECT') THEN
1814: -- consider the amounts already accounted for in submitted timecards
1815: l_timecard_amount_sum := HXC_INTEGRATION_LAYER_V1_GRP.get_mappingvalue_sum
1816: ( p_bld_blk_info_type => 'PURCHASING'
1817: , p_field_name1 => 'PO Billable Amount'
1818: , p_field_name2 => 'PO Line Id'
1819: , p_field_value2 => l_po_line_id

Line 1837: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1833:
1834: -- finally check if the tolerance will be broken
1835: IF get_po_line(l_po_line_id).timecard_amount + l_timecard_amount_sum > l_tolerable_amount THEN
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'

Line 1847: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1843: , p_timecard_bb_id => NULL
1844: , p_time_attribute_id => get_po_line(l_po_line_id).time_attribute_id
1845: );
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'

Line 1868: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1864: , module => l_log_head
1865: , message => 'PO_HXC_INTERFACE_PVT.get_timecard_amount returned error'
1866: );
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'

Line 1888: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => p_messages

1884: , module => l_log_head
1885: , message => 'Unexpected exception validating amount tolerances: ' || SQLERRM
1886: );
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

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

3188: p_dst_attributes.timecard_start_time := l_timecard_block.start_time;
3189: p_dst_attributes.timecard_stop_time := l_timecard_block.stop_time;
3190:
3191: -- these functions are cached so we do not have to cache the results
3192: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3193: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3194: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3195: IF g_debug_stmt THEN
3196: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date',

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

3189: p_dst_attributes.timecard_stop_time := l_timecard_block.stop_time;
3190:
3191: -- these functions are cached so we do not have to cache the results
3192: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3193: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3194: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3195: IF g_debug_stmt THEN
3196: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date',
3197: p_dst_attributes.timecard_approval_date);

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

3190:
3191: -- these functions are cached so we do not have to cache the results
3192: p_dst_attributes.timecard_approval_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3193: p_dst_attributes.timecard_submission_date := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_submission_date( p_timecard_id => p_dst_attributes.timecard_bb_id );
3194: p_dst_attributes.timecard_approval_status := HXC_INTEGRATION_LAYER_V1_GRP.get_timecard_approval_status( p_timecard_id => p_dst_attributes.timecard_bb_id );
3195: IF g_debug_stmt THEN
3196: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_approval_date',
3197: p_dst_attributes.timecard_approval_date);
3198: PO_DEBUG.debug_var(l_log_head,l_progress,'timecard_submission_date',

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

3513:
3514:
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:

Line 4001: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

3997: , message => 'Setting Day/Timecard Statuses'
3998: );
3999:
4000: -- update status for day and timecard building blocks
4001: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4002:
4003: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4004: , module => l_log_head
4005: , message => 'Setting Transaction Status'

Line 4023: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4019: g_txn_status := 'SUCCESS';
4020: g_txn_msg := 'Receiving Transactions created';
4021: END IF;
4022:
4023: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4024: p_process => 'Purchasing Retrieval Process'
4025: , p_status => g_txn_status
4026: , p_exception_description => g_txn_msg
4027: );

Line 4051: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4047: -- Bug6357273.
4048: -- In the case also we need to propogate message back to OTL
4049: -- Which will help OTL to debug by the records got failed
4050: ROLLBACK;
4051: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4052: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4053: p_process => 'Purchasing Retrieval Process'
4054: , p_status => 'ERRORS'
4055: , p_exception_description => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'

Line 4052: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4048: -- In the case also we need to propogate message back to OTL
4049: -- Which will help OTL to debug by the records got failed
4050: ROLLBACK;
4051: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4052: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4053: p_process => 'Purchasing Retrieval Process'
4054: , p_status => 'ERRORS'
4055: , p_exception_description => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'
4056: );

Line 4068: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4064: -- Bug6357273.
4065: -- In the case also we need to propogate message back to OTL
4066: -- Which will help OTL to debug by the records got failed
4067: ROLLBACK;
4068: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4069: -- this is only raised in the first call to reconcile actions. the later one is not fatal.
4070: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4071: p_process => 'Purchasing Retrieval Process'
4072: , p_status => 'ERRORS'

Line 4070: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4066: -- Which will help OTL to debug by the records got failed
4067: ROLLBACK;
4068: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4069: -- this is only raised in the first call to reconcile actions. the later one is not fatal.
4070: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4071: p_process => 'Purchasing Retrieval Process'
4072: , p_status => 'ERRORS'
4073: , p_exception_description => g_txn_msg || 'Error calling Reconcile_Actions, please see FND_LOG_MESSAGES for details'
4074: );

Line 4082: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4078: -- Bug6357273.
4079: -- In the case also we need to propogate message back to OTL
4080: -- Which will help OTL to debug by the records got failed
4081: ROLLBACK;
4082: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4083: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4084: p_process => 'Purchasing Retrieval Process'
4085: , p_status => 'ERRORS'
4086: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

Line 4083: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4079: -- In the case also we need to propogate message back to OTL
4080: -- Which will help OTL to debug by the records got failed
4081: ROLLBACK;
4082: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4083: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4084: p_process => 'Purchasing Retrieval Process'
4085: , p_status => 'ERRORS'
4086: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4087: );

Line 4095: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4091: -- Bug6357273.
4092: -- In the case also we need to propogate message back to OTL
4093: -- Which will help OTL to debug by the records got failed
4094: ROLLBACK;
4095: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4096: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4097: p_process => 'Purchasing Retrieval Process'
4098: , p_status => 'ERRORS'
4099: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

Line 4096: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4092: -- In the case also we need to propogate message back to OTL
4093: -- Which will help OTL to debug by the records got failed
4094: ROLLBACK;
4095: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4096: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4097: p_process => 'Purchasing Retrieval Process'
4098: , p_status => 'ERRORS'
4099: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4100: );

Line 4108: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;

4104: -- Bug6357273.
4105: -- In the case also we need to propogate message back to OTL
4106: -- Which will help OTL to debug by the records got failed
4107: ROLLBACK;
4108: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4109:
4110:
4111: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4112: p_process => 'Purchasing Retrieval Process'

Line 4111: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4107: ROLLBACK;
4108: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4109:
4110:
4111: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4112: p_process => 'Purchasing Retrieval Process'
4113: , p_status => 'ERRORS'
4114: , p_exception_description => SUBSTR(g_txn_msg || 'Unexpected exception in Retrieve_Timecards_Body: ' || SQLERRM, 1, 2000)
4115: );

Line 4155: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(

4151: , message => 'Begin Update_Timecard'
4152: );
4153:
4154: -- get time information
4155: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(
4156: p_building_blocks => l_blocks,
4157: p_app_attributes => l_attributes,
4158: p_messages => l_messages);
4159:

Line 4202: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(

4198: END IF;
4199: END LOOP;
4200:
4201: -- set time information
4202: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(
4203: p_building_blocks => l_blocks,
4204: p_app_attributes => l_attributes,
4205: p_messages => l_messages);
4206:

Line 4242: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(

4238: , message => 'Begin Validate_Timecard'
4239: );
4240:
4241: -- get time information
4242: HXC_INTEGRATION_LAYER_V1_GRP.get_app_hook_params(
4243: p_building_blocks => l_blocks,
4244: p_app_attributes => l_attributes,
4245: p_messages => l_messages);
4246:

Line 4394: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(

4390: -- validate the amount tolerances
4391: Validate_Amount_Tolerances(l_messages);
4392:
4393: -- set time information
4394: HXC_INTEGRATION_LAYER_V1_GRP.set_app_hook_params(
4395: p_building_blocks => l_blocks,
4396: p_app_attributes => l_attributes,
4397: p_messages => l_messages);
4398:

Line 4425: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => l_messages

4421: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4422: );
4423: EXCEPTION
4424: WHEN OTHERS THEN
4425: HXC_INTEGRATION_LAYER_V1_GRP.add_error_to_table( p_message_table => l_messages
4426: , p_message_name => 'HXC_RET_UNEXPECTED_ERROR'
4427:
4428:
4429: , p_message_token => 'ERR&' || 'validating timecard: ' || SQLERRM

Line 4550: HXC_INTEGRATION_LAYER_V1_GRP.Execute_Retrieval_Process(

4546: -- call the generic retrieval package to populate global tables
4547: BEGIN
4548: g_generic_start := SYSDATE;
4549:
4550: HXC_INTEGRATION_LAYER_V1_GRP.Execute_Retrieval_Process(
4551: P_Process => 'Purchasing Retrieval Process',
4552: P_Transaction_code => NULL,
4553: P_Start_Date => l_start_date,
4554: P_End_Date => l_end_date,

Line 4622: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (

4618: );
4619: ELSE
4620: l_more_timecards := FALSE;
4621:
4622: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4623: p_process => 'Purchasing Retrieval Process'
4624: , p_status => 'SUCCESS'
4625: , p_exception_description => 'No more rows to process'
4626: );