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.HZ_LOCATION_SERVICES_PUB dependencies on WF_EVENT

Line 140: -- 2) Raise wf event to enerate xml document base on the rows retrieved.

136: -----------------------------------------------------------------------
137: -- It will do the following
138: -- 1) Accept parameters from conc program and retrieve rows from
139: -- HZ_LOCATIONS which meet the parameters passed in
140: -- 2) Raise wf event to enerate xml document base on the rows retrieved.
141: -- It may split up all rows into different batch due to the maximum batch
142: -- size defined for each adapter.
143: ------------------------------------------------------------------------
144: PROCEDURE address_validation (

Line 512: -- 2) Raise wf event to enerate xml document base on the rows retrieved.

508: -----------------------------------------------------------------------
509: -- It will do the following
510: -- 1) Accept parameters from conc program and retrieve rows from
511: -- HZ_LOCATIONS which meet the parameters passed in
512: -- 2) Raise wf event to enerate xml document base on the rows retrieved.
513: -- It may split up all rows into different batch due to the maximum batch
514: -- size defined for each adapter.
515: ------------------------------------------------------------------------
516: PROCEDURE address_validation_worker (

Line 584: -- raise wf event, this will call procedure outdoc_rule

580: p_parameter_list => l_parameter_list );
581:
582: l_event_key := 'HZ_LOCSERVICE_OUTBOUND-'||hz_utility_v2pub.request_id||'-'||p_adapter_id||'-'||p_batch_sequence;
583:
584: -- raise wf event, this will call procedure outdoc_rule
585: log('Raise Workflow Event, event key is: '||l_event_key);
586:
587: wf_event.raise(
588: p_event_name => 'oracle.apps.ar.hz.locservice.generatexml',

Line 587: wf_event.raise(

583:
584: -- raise wf event, this will call procedure outdoc_rule
585: log('Raise Workflow Event, event key is: '||l_event_key);
586:
587: wf_event.raise(
588: p_event_name => 'oracle.apps.ar.hz.locservice.generatexml',
589: p_event_key => l_event_key,
590: p_event_data => NULL,
591: p_parameters => l_parameter_list,

Line 620: -- As outdoc_rule raise wf event to parse xml, this function

616:
617: -----------------------------------------------------------------------
618: -- Called from function rule outdoc_rule
619: -----------------------------------------------------------------------
620: -- As outdoc_rule raise wf event to parse xml, this function
621: -- rule which is defined for a wf event will be called. The wf event
622: -- is called oracle.apps.ar.hz.locservice.parsexml
623: -- This function rule will do the following
624: -- 1) Get the parsed xml doc

Line 621: -- rule which is defined for a wf event will be called. The wf event

617: -----------------------------------------------------------------------
618: -- Called from function rule outdoc_rule
619: -----------------------------------------------------------------------
620: -- As outdoc_rule raise wf event to parse xml, this function
621: -- rule which is defined for a wf event will be called. The wf event
622: -- is called oracle.apps.ar.hz.locservice.parsexml
623: -- This function rule will do the following
624: -- 1) Get the parsed xml doc
625: -- 2) Check for tax validation

Line 1784: wf_event.AddParameterToList(

1780: p_parameter_list OUT NOCOPY wf_parameter_list_t ) IS
1781:
1782: BEGIN
1783: -- map code
1784: wf_event.AddParameterToList(
1785: p_name => 'ECX_MAP_CODE',
1786: p_value => 'LOCSERV_OUT',
1787: p_parameterlist => p_parameter_list);
1788:

Line 1790: wf_event.AddParameterToList(

1786: p_value => 'LOCSERV_OUT',
1787: p_parameterlist => p_parameter_list);
1788:
1789: -- adapter_id
1790: wf_event.AddParameterToList(
1791: p_name => 'ADAPTER_ID',
1792: p_value => p_adapter_id,
1793: p_parameterlist => p_parameter_list);
1794:

Line 1796: wf_event.AddParameterToList(

1792: p_value => p_adapter_id,
1793: p_parameterlist => p_parameter_list);
1794:
1795: -- overwrite_threshold
1796: wf_event.AddParameterToList(
1797: p_name => 'OVERWRITE_THRESHOLD',
1798: p_value => p_overwrite_threshold,
1799: p_parameterlist => p_parameter_list);
1800:

Line 1802: wf_event.AddParameterToList(

1798: p_value => p_overwrite_threshold,
1799: p_parameterlist => p_parameter_list);
1800:
1801: -- country
1802: wf_event.AddParameterToList(
1803: p_name => 'COUNTRY',
1804: p_value => p_country,
1805: p_parameterlist => p_parameter_list);
1806:

Line 1808: wf_event.AddParameterToList(

1804: p_value => p_country,
1805: p_parameterlist => p_parameter_list);
1806:
1807: -- last_update_date
1808: wf_event.AddParameterToList(
1809: p_name => 'FROM_LUD',
1810: p_value => p_from_lud,
1811: p_parameterlist => p_parameter_list);
1812:

Line 1813: wf_event.AddParameterToList(

1809: p_name => 'FROM_LUD',
1810: p_value => p_from_lud,
1811: p_parameterlist => p_parameter_list);
1812:
1813: wf_event.AddParameterToList(
1814: p_name => 'TO_LUD',
1815: p_value => p_to_lud,
1816: p_parameterlist => p_parameter_list);
1817:

Line 1819: wf_event.AddParameterToList(

1815: p_value => p_to_lud,
1816: p_parameterlist => p_parameter_list);
1817:
1818: -- date_validated
1819: wf_event.AddParameterToList(
1820: p_name => 'NVL_DV',
1821: p_value => p_nvl_dv,
1822: p_parameterlist => p_parameter_list);
1823:

Line 1824: wf_event.AddParameterToList(

1820: p_name => 'NVL_DV',
1821: p_value => p_nvl_dv,
1822: p_parameterlist => p_parameter_list);
1823:
1824: wf_event.AddParameterToList(
1825: p_name => 'FROM_DV',
1826: p_value => p_from_dv,
1827: p_parameterlist => p_parameter_list);
1828:

Line 1829: wf_event.AddParameterToList(

1825: p_name => 'FROM_DV',
1826: p_value => p_from_dv,
1827: p_parameterlist => p_parameter_list);
1828:
1829: wf_event.AddParameterToList(
1830: p_name => 'TO_DV',
1831: p_value => p_to_dv,
1832: p_parameterlist => p_parameter_list);
1833:

Line 1835: wf_event.AddParameterToList(

1831: p_value => p_to_dv,
1832: p_parameterlist => p_parameter_list);
1833:
1834: -- validation_status_code
1835: wf_event.AddParameterToList(
1836: p_name => 'NVL_VSC',
1837: p_value => p_nvl_vsc,
1838: p_parameterlist => p_parameter_list);
1839:

Line 1840: wf_event.AddParameterToList(

1836: p_name => 'NVL_VSC',
1837: p_value => p_nvl_vsc,
1838: p_parameterlist => p_parameter_list);
1839:
1840: wf_event.AddParameterToList(
1841: p_name => 'FROM_VSC',
1842: p_value => p_from_vsc,
1843: p_parameterlist => p_parameter_list);
1844:

Line 1845: wf_event.AddParameterToList(

1841: p_name => 'FROM_VSC',
1842: p_value => p_from_vsc,
1843: p_parameterlist => p_parameter_list);
1844:
1845: wf_event.AddParameterToList(
1846: p_name => 'TO_VSC',
1847: p_value => p_to_vsc,
1848: p_parameterlist => p_parameter_list);
1849:

Line 1851: wf_event.AddParameterToList(

1847: p_value => p_to_vsc,
1848: p_parameterlist => p_parameter_list);
1849:
1850: -- Total number of batch required
1851: wf_event.AddParameterToList(
1852: p_name => 'NUM_BATCH',
1853: p_value => p_num_batch,
1854: p_parameterlist => p_parameter_list);
1855:

Line 1857: wf_event.AddParameterToList(

1853: p_value => p_num_batch,
1854: p_parameterlist => p_parameter_list);
1855:
1856: -- The batch number
1857: wf_event.AddParameterToList(
1858: p_name => 'BATCH_SEQUENCE',
1859: p_value => p_batch_seq,
1860: p_parameterlist => p_parameter_list);
1861:

Line 1961: p_event IN OUT NOCOPY wf_event_t )

1957: END get_adapter_link;
1958:
1959: FUNCTION indoc_rule (
1960: p_subscription_guid IN RAW,
1961: p_event IN OUT NOCOPY wf_event_t )
1962: RETURN VARCHAR2 IS
1963: l_event_data CLOB := NULL;
1964: l_ecx_map_code VARCHAR2(30);
1965: l_adapter_id NUMBER;

Line 2029: -- As address_validation raise wf event to generate xml, this function

2025:
2026: -----------------------------------------------------------------------
2027: -- Called from address_validation
2028: -----------------------------------------------------------------------
2029: -- As address_validation raise wf event to generate xml, this function
2030: -- rule which is defined for a wf event will be called. The wf event
2031: -- is called oracle.apps.ar.hz.locservice.generatexml
2032: -- This function rule will do the following
2033: -- 1) Get the generated xml doc

Line 2030: -- rule which is defined for a wf event will be called. The wf event

2026: -----------------------------------------------------------------------
2027: -- Called from address_validation
2028: -----------------------------------------------------------------------
2029: -- As address_validation raise wf event to generate xml, this function
2030: -- rule which is defined for a wf event will be called. The wf event
2031: -- is called oracle.apps.ar.hz.locservice.generatexml
2032: -- This function rule will do the following
2033: -- 1) Get the generated xml doc
2034: -- 2) Pass the xml doc to submit_addrval_doc

Line 2035: -- 3) Get returned validated xml doc, raise another wf event to parse

2031: -- is called oracle.apps.ar.hz.locservice.generatexml
2032: -- This function rule will do the following
2033: -- 1) Get the generated xml doc
2034: -- 2) Pass the xml doc to submit_addrval_doc
2035: -- 3) Get returned validated xml doc, raise another wf event to parse
2036: -- the validated addresses.
2037: ------------------------------------------------------------------------
2038: FUNCTION outdoc_rule (
2039: p_subscription_guid IN RAW,

Line 2040: p_event IN OUT NOCOPY wf_event_t )

2036: -- the validated addresses.
2037: ------------------------------------------------------------------------
2038: FUNCTION outdoc_rule (
2039: p_subscription_guid IN RAW,
2040: p_event IN OUT NOCOPY wf_event_t )
2041: RETURN VARCHAR2 IS
2042: l_event_data CLOB := NULL;
2043: l_event_nclob_data NCLOB := NULL;
2044: l_adapter_id NUMBER;

Line 2089: wf_event.AddParameterToList(

2085: END IF;
2086:
2087: l_parameter_list := wf_parameter_list_t();
2088:
2089: wf_event.AddParameterToList(
2090: p_name => 'ECX_MAP_CODE',
2091: p_value => 'LOCSERV_IN',
2092: p_parameterlist => l_parameter_list);
2093:

Line 2094: wf_event.AddParameterToList(

2090: p_name => 'ECX_MAP_CODE',
2091: p_value => 'LOCSERV_IN',
2092: p_parameterlist => l_parameter_list);
2093:
2094: wf_event.AddParameterToList(
2095: p_name => 'ADAPTER_ID',
2096: p_value => l_adapter_id,
2097: p_parameterlist => l_parameter_list);
2098:

Line 2099: wf_event.AddParameterToList(

2095: p_name => 'ADAPTER_ID',
2096: p_value => l_adapter_id,
2097: p_parameterlist => l_parameter_list);
2098:
2099: wf_event.AddParameterToList(
2100: p_name => 'OVERWRITE_THRESHOLD',
2101: p_value => l_overwrite_threshold,
2102: p_parameterlist => l_parameter_list);
2103:

Line 2104: wf_event.AddParameterToList(

2100: p_name => 'OVERWRITE_THRESHOLD',
2101: p_value => l_overwrite_threshold,
2102: p_parameterlist => l_parameter_list);
2103:
2104: wf_event.AddParameterToList(
2105: p_name => 'BATCH_SEQUENCE',
2106: p_value => l_batch_sequence,
2107: p_parameterlist => l_parameter_list);
2108:

Line 2112: wf_event.raise(

2108:
2109: -- raise event to retrieve inbound xml doc, which is indoc_rule
2110: l_event_key := 'HZ_LOCSERVICE_INBOUND-'||hz_utility_v2pub.request_id||'-'||l_adapter_id||'-'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;
2111:
2112: wf_event.raise(
2113: p_event_name => 'oracle.apps.ar.hz.locservice.parsexml',
2114: p_event_key => l_event_key,
2115: p_event_data => l_event_data,
2116: p_parameters => l_parameter_list,

Line 2126: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2122: EXCEPTION
2123: WHEN FND_API.G_EXC_ERROR THEN
2124: log('Expected Error: Aborting Location Service for this batch');
2125: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2126: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2127: --return 'ERROR';
2128: RAISE FND_API.G_EXC_ERROR;
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2130: log('Unexpected Error: Aborting Location Service for this batch');

Line 2132: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2128: RAISE FND_API.G_EXC_ERROR;
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2130: log('Unexpected Error: Aborting Location Service for this batch');
2131: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2133: --return 'ERROR';
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: WHEN OTHERS THEN
2136: log('Others Error: Aborting Location Service for this batch');

Line 2139: wf_event.setErrorInfo(p_event, 'ERROR');

2135: WHEN OTHERS THEN
2136: log('Others Error: Aborting Location Service for this batch');
2137: log('SQL Error: '||SQLERRM);
2138: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2139: wf_event.setErrorInfo(p_event, 'ERROR');
2140: --return 'ERROR';
2141: RAISE;
2142: END outdoc_rule;
2143: