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 1270: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)

1266: FROM dual
1267: WHERE EXISTS (SELECT segment1
1268: FROM po_headers_all
1269: WHERE segment1=p_attributes.po_number
1270: AND org_id=hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1271: AND Nvl(closed_code,'OPEN') <> 'FINALLY CLOSED'
1272: AND Nvl(user_hold_flag,'N') <> 'Y'
1273: );
1274: EXCEPTION

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

1466: );
1467:
1468: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1469: , module => l_log_head
1470: , message => 'hr_organization_api.get_operating_unit = ' || hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1471: );
1472:
1473: IF get_po_header(p_attributes.po_header_id).user_hold_flag <> 'N' OR
1474: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(p_attributes.resource_id) THEN

Line 1475: -- Modified the If condition for bug 9255870, passing p_attributes.resource_id instead of fnd_global.employee_id

1471: );
1472:
1473: IF get_po_header(p_attributes.po_header_id).user_hold_flag <> 'N' OR
1474: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(p_attributes.resource_id) THEN
1475: -- Modified the If condition for bug 9255870, passing p_attributes.resource_id instead of fnd_global.employee_id
1476: -- Condition removed as not required. After R12 MOAC. User can use Purchase
1477: -- Order Created in other Operating Unit.
1478: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id
1479: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

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

1474: get_po_header(p_attributes.po_header_id).org_id <> hxc_timecard_properties.setup_mo_global_params(p_attributes.resource_id) THEN
1475: -- Modified the If condition for bug 9255870, passing p_attributes.resource_id instead of fnd_global.employee_id
1476: -- Condition removed as not required. After R12 MOAC. User can use Purchase
1477: -- Order Created in other Operating Unit.
1478: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id
1479: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1480: , module => l_log_head
1481: , message => 'PO is invalid: ' || '*'
1482: || get_po_header(p_attributes.po_header_id).user_hold_flag || '*'

Line 1853: , p_resource_id => FND_GLOBAL.employee_id

1849: , p_field_name1 => 'PO Billable Amount'
1850: , p_field_name2 => 'PO Line Id'
1851: , p_field_value2 => l_po_line_id
1852: , p_status => 'SUBMITTED'
1853: , p_resource_id => FND_GLOBAL.employee_id
1854: );
1855:
1856: -- get_mappingvalue_sum returns null when no timecard matches the conditions
1857: IF l_timecard_amount_sum IS NULL THEN

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

1953: END;
1954:
1955: -- WHO columns
1956: p_rti_row.last_update_date := SYSDATE;
1957: p_rti_row.last_updated_by := FND_GLOBAL.USER_ID;
1958: p_rti_row.creation_date := p_rti_row.last_update_date;
1959: p_rti_row.created_by := p_rti_row.last_updated_by;
1960:
1961: -- hardcoded values

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

2030: l_rhi_row.employee_id := p_attributes.resource_id;
2031:
2032: -- WHO columns
2033: l_rhi_row.last_update_date := SYSDATE;
2034: l_rhi_row.last_updated_by := FND_GLOBAL.USER_ID;
2035: l_rhi_row.creation_date := l_rhi_row.last_update_date;
2036: l_rhi_row.created_by := l_rhi_row.last_updated_by;
2037:
2038: -- hardcoded values

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

3842: END IF;
3843: EXCEPTION
3844: WHEN RVCTP_FAILED THEN
3845: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_RCVTP_FAIL')
3846: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
3847:
3848: ROLLBACK;
3849:
3850: --

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

4574: g_validate_stop := SYSDATE;
4575:
4576: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4577: , module => l_log_head
4578: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

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

4575:
4576: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4577: , module => l_log_head
4578: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

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

4576: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4577: , module => l_log_head
4578: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

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

4577: , module => l_log_head
4578: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

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

4578: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

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

4579: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

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

4580: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)

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

4581: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)

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

4582: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

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

4583: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4591: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4588: || FND_GLOBAL.local_chr(10)

4584: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4591: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4592: );

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

4585: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4591: || ' Validate: ' || TO_CHAR((g_validate_stop - g_validate_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4592: );
4593: EXCEPTION

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

4586: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4587: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4588: || FND_GLOBAL.local_chr(10)
4589: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4590: || ' Update: ' || TO_CHAR((g_update_stop - g_update_start) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
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

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

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

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

4736: );
4737: IF SQLERRM like 'ORA-20001: HXC_0013_GNRET_NO_BLD_BLKS%' OR
4738: SQLERRM like 'ORA-20001: HXC_0012_GNRET_NO_TIMECARDS%' THEN
4739: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_NO_TIMECARDS')
4740: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4741: RAISE SUCCESS_SHORT_CIRCUIT;
4742: ELSIF SQLERRM like 'ORA-20001: HXC_0017_GNRET_PROCESS_RUNNING%' THEN
4743: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_PROCESS_RUNNING')
4744: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);

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

4740: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4741: RAISE SUCCESS_SHORT_CIRCUIT;
4742: ELSIF SQLERRM like 'ORA-20001: HXC_0017_GNRET_PROCESS_RUNNING%' THEN
4743: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_GNRET_PROCESS_RUNNING')
4744: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4745: END IF;
4746:
4747: RAISE GENERIC_RETRIEVAL_FAILED;
4748: END;

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

4804: );
4805:
4806: IF g_failed_details > 0 THEN
4807: G_CONC_LOG := G_CONC_LOG || FND_MESSAGE.get_string('PO', 'RCV_OTL_RCVTP_ERROR')
4808: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4809: END IF;
4810:
4811: -- generate summary report
4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)

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

4808: || FND_GLOBAL.local_chr(10) || FND_GLOBAL.local_chr(10);
4809: END IF;
4810:
4811: -- generate summary report
4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)

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

4809: END IF;
4810:
4811: -- generate summary report
4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)

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

4810:
4811: -- generate summary report
4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)

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

4811: -- generate summary report
4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)

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

4812: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' || FND_GLOBAL.local_chr(10)
4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)

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

4813: || ' Detail blocks retrieved: ' || g_retrieved_details || FND_GLOBAL.local_chr(10)
4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)

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

4814: || ' Detail blocks successful: ' || g_successful_details || FND_GLOBAL.local_chr(10)
4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)

Line 4819: || FND_GLOBAL.local_chr(10)

4815: || ' Detail blocks failed: ' || g_failed_details || FND_GLOBAL.local_chr(10)
4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)

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

4816: || ' Receiving Transaction Processor request id: ' || g_req_id || FND_GLOBAL.local_chr(10)
4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)

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

4817: || ' Receiving Transaction Processor group id: ' || g_group_id || FND_GLOBAL.local_chr(10)
4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)

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

4818: || ' Retrieval status: ' || g_overall_status || FND_GLOBAL.local_chr(10)
4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)

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

4819: || FND_GLOBAL.local_chr(10)
4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)

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

4820: || 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)

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

4821: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)

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

4822: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)
4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)

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

4823: || ' po_header: ' || (g_po_header_calls - g_po_header_misses || '/' || g_po_header_calls) || FND_GLOBAL.local_chr(10)
4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)

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

4824: || ' po_line: ' || (g_po_line_calls - g_po_line_misses || '/' || g_po_line_calls) || FND_GLOBAL.local_chr(10)
4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

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

4825: || ' po_distribution: ' || (g_po_distribution_calls - g_po_distribution_misses || '/' || g_po_distribution_calls) || FND_GLOBAL.local_chr(10)
4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)

Line 4830: || FND_GLOBAL.local_chr(10)

4826: || ' price_type_lookup: ' || (g_price_type_lookup_calls - g_price_type_lookup_misses) || '/' || g_price_type_lookup_calls || FND_GLOBAL.local_chr(10)
4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4834: || ' Retrieval: '

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

4827: || ' price_differentials: ' || (g_price_differentials_calls - g_price_differentials_misses) || '/' || g_price_differentials_calls || FND_GLOBAL.local_chr(10)
4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4834: || ' Retrieval: '
4835: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')

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

4828: || ' assignments: ' || (g_assignments_calls - g_assignments_misses) || '/' || g_assignments_calls || FND_GLOBAL.local_chr(10)
4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4834: || ' Retrieval: '
4835: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4836: || ' ms' || FND_GLOBAL.local_chr(10);

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

4829: || ' rcv_transactions: ' || (g_rcv_transactions_calls - g_rcv_transactions_misses) || '/' || g_rcv_transactions_calls || FND_GLOBAL.local_chr(10)
4830: || FND_GLOBAL.local_chr(10)
4831: || 'Running times: ' || FND_GLOBAL.local_chr(10)
4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4834: || ' Retrieval: '
4835: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4836: || ' ms' || FND_GLOBAL.local_chr(10);
4837:

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

4832: || ' Generic Retrieval: ' || TO_CHAR((g_generic_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4833: || ' Receiving Transaction Processor: ' || TO_CHAR((g_receiving_time) * 8640000, '99,999.90') || ' ms' || FND_GLOBAL.local_chr(10)
4834: || ' Retrieval: '
4835: || TO_CHAR(((g_retrieval_time) - (g_generic_time) - (g_receiving_time)) * 8640000, '99,999.90')
4836: || ' ms' || FND_GLOBAL.local_chr(10);
4837:
4838: -- send output to concurrent log
4839: errbuf := G_CONC_LOG;
4840: IF g_failed_details > 0 THEN