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 FND_GLOBAL

Line 1230: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)

1226: FROM dual
1227: WHERE EXISTS (SELECT segment1
1228: FROM po_headers_all
1229: WHERE segment1=p_attributes.po_number
1230: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1231: AND Nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
1232: AND Nvl(user_hold_flag,'N') <> 'Y'
1233: );
1234: EXCEPTION

Line 1432: , message => 'hr_organization_api.get_operating_unit = ' || hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)

1428: );
1429:
1430: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1431: , module => l_log_head
1432: , message => 'hr_organization_api.get_operating_unit = ' || hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1433: );
1434:
1435:
1436: IF get_po_header(p_attributes.po_header_id).user_hold_flag <> 'N' OR

Line 1437: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)

1433: );
1434:
1435:
1436: IF get_po_header(p_attributes.po_header_id).user_hold_flag <> 'N' OR
1437: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1438: -- Condition removed as not required. After R12 MOAC. User can use Purchase
1439: -- Order Created in other Operating Unit.
1440: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id
1441: THEN

Line 1440: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id

1436: IF get_po_header(p_attributes.po_header_id).user_hold_flag <> 'N' OR
1437: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1438: -- Condition removed as not required. After R12 MOAC. User can use Purchase
1439: -- Order Created in other Operating Unit.
1440: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id
1441: THEN
1442: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1443: , module => l_log_head
1444: , message => 'PO is invalid: ' || '*'

Line 1821: , p_resource_id => FND_GLOBAL.employee_id

1817: , p_field_name1 => 'PO Billable Amount'
1818: , p_field_name2 => 'PO Line Id'
1819: , p_field_value2 => l_po_line_id
1820: , p_status => 'SUBMITTED'
1821: , p_resource_id => FND_GLOBAL.employee_id
1822: );
1823:
1824: -- get_mappingvalue_sum returns null when no timecard matches the conditions
1825: IF l_timecard_amount_sum IS NULL THEN

Line 1925: p_rti_row.last_updated_by := FND_GLOBAL.USER_ID;

1921: END;
1922:
1923: -- WHO columns
1924: p_rti_row.last_update_date := SYSDATE;
1925: p_rti_row.last_updated_by := FND_GLOBAL.USER_ID;
1926: p_rti_row.creation_date := p_rti_row.last_update_date;
1927: p_rti_row.created_by := p_rti_row.last_updated_by;
1928:
1929: -- hardcoded values

Line 2002: l_rhi_row.last_updated_by := FND_GLOBAL.USER_ID;

1998: l_rhi_row.employee_id := p_attributes.resource_id;
1999:
2000: -- WHO columns
2001: l_rhi_row.last_update_date := SYSDATE;
2002: l_rhi_row.last_updated_by := FND_GLOBAL.USER_ID;
2003: l_rhi_row.creation_date := l_rhi_row.last_update_date;
2004: l_rhi_row.created_by := l_rhi_row.last_updated_by;
2005:
2006: -- hardcoded values

Line 3774: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

3770: END IF;
3771: EXCEPTION
3772: WHEN RVCTP_FAILED THEN
3773: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_RCVTP_FAIL')
3774: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
3775:
3776: ROLLBACK;
3777:
3778: --

Line 4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)

4404: g_validate_stop := SYSDATE;
4405:
4406: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4407: , module => l_log_head
4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

Line 4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)

4405:
4406: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4407: , module => l_log_head
4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

Line 4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)

4406: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4407: , module => l_log_head
4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

Line 4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)

4407: , module => l_log_head
4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

Line 4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

Line 4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

Line 4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)

Line 4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

4411: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)

Line 4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

4412: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

4413: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4421: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4418: || FND_GLOBAL.local_chr(10)

4414: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4421: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4422: );

Line 4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)

4415: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4421: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4422: );
4423: EXCEPTION

Line 4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

4416: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
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

Line 4421: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

4417: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4418: || FND_GLOBAL.local_chr(10)
4419: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4420: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
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

Line 4572: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

4568: );
4569: IF SQLERRM like 'ORA-20001: HXC_0013_GNRET_NO_BLD_BLKS%' OR
4570: SQLERRM like 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS%' THEN
4571: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_NO_TIMECARDS')
4572: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4573: RAISE SUCCESS_SHORT_CIRCUIT;
4574: ELSIF SQLERRM like 'ORA-20001: HXC_0017_GNRET_PROCESS_RUNNING%' THEN
4575: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_PROCESS_RUNNING')
4576: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

Line 4576: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

4572: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4573: RAISE SUCCESS_SHORT_CIRCUIT;
4574: ELSIF SQLERRM like 'ORA-20001: HXC_0017_GNRET_PROCESS_RUNNING%' THEN
4575: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_PROCESS_RUNNING')
4576: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4577: END IF;
4578:
4579: RAISE GENERIC_RETRIEVAL_FAILED;
4580: END;

Line 4640: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

4636: );
4637:
4638: IF g_failed_details > 0 THEN
4639: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_RCVTP_ERROR')
4640: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4641: END IF;
4642:
4643: -- generate summary report
4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)

Line 4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)

4640: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4641: END IF;
4642:
4643: -- generate summary report
4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)

Line 4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)

4641: END IF;
4642:
4643: -- generate summary report
4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)

Line 4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)

4642:
4643: -- generate summary report
4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)

Line 4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)

4643: -- generate summary report
4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)

Line 4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)

4644: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)

Line 4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)

4645: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)

Line 4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)

4646: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)

Line 4651: || FND_GLOBAL.local_chr(10)

4647: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)

Line 4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)

4648: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

Line 4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)

4649: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

Line 4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)

4650: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

Line 4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)

4651: || FND_GLOBAL.local_chr(10)
4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

Line 4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

4652: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

Line 4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

4653: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

Line 4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

4654: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)

Line 4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

4655: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)

Line 4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

4656: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

4657: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4662: || FND_GLOBAL.local_chr(10)

4658: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4666: || ' Retrieval: '

Line 4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)

4659: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4666: || ' Retrieval: '
4667: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')

Line 4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

4660: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4666: || ' Retrieval: '
4667: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4668: || ' ms' || FND_GLOBAL.local_chr(10);

Line 4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

4661: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4662: || FND_GLOBAL.local_chr(10)
4663: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4666: || ' Retrieval: '
4667: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4668: || ' ms' || FND_GLOBAL.local_chr(10);
4669:

Line 4668: || ' ms' || FND_GLOBAL.local_chr(10);

4664: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4665: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4666: || ' Retrieval: '
4667: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4668: || ' ms' || FND_GLOBAL.local_chr(10);
4669:
4670: -- send output to concurrent log
4671: errbuf := G_CONC_LOG;
4672: IF g_failed_details > 0 THEN