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_IMP_ADDRESS_VAL_PKG dependencies on WF_EVENT

Line 36: wf_event.AddParameterToList(

32: begin
33: --
34: ---Set parameter mapcode in parameter list
35: --
36: wf_event.AddParameterToList(
37: p_name => 'ECX_MAP_CODE',
38: p_value => 'TCA_IMP_OAG_OUTBOUND',
39: p_parameterlist => l_parameter_list);
40:

Line 44: wf_event.AddParameterToList(

40:
41: --
42: ---Set parameter where-clause of mapcode in parameter list
43: --
44: wf_event.AddParameterToList(
45: p_name => 'P_BATCH_ID',
46: p_value => p_batch_id,
47: p_parameterlist => l_parameter_list);
48: --

Line 51: wf_event.AddParameterToList(

47: p_parameterlist => l_parameter_list);
48: --
49: ---Set parameter where-clause of mapcode in parameter list
50: --
51: wf_event.AddParameterToList(
52: p_name => 'P_ORIG_SYSTEM_REFERENCE',
53: p_value => P_ORIG_SYSTEM,
54: p_parameterlist => l_parameter_list);
55: --

Line 58: wf_event.AddParameterToList(

54: p_parameterlist => l_parameter_list);
55: --
56: ---Set parameter where-clause of mapcode in parameter list
57: --
58: wf_event.AddParameterToList(
59: p_name => 'P_VAL_SUBSET_ID',
60: p_value => P_VAL_SUBSET_ID,
61: p_parameterlist => l_parameter_list);
62:

Line 66: wf_event.AddParameterToList(

62:
63: --
64: ---Set parameter where-clause of mapcode in parameter list
65: --
66: wf_event.AddParameterToList(
67: p_name => 'P_OVERWRITE_THRESHOLD',
68: p_value => P_OVERWRITE_THRESHOLD,
69: p_parameterlist => l_parameter_list);
70:

Line 74: wf_event.AddParameterToList(

70:
71: --
72: ---Set parameter where-clause of mapcode in parameter list
73: --
74: wf_event.AddParameterToList(
75: p_name => 'P_ADAPTER_ID',
76: p_value => P_ADAPTER_ID,
77: p_parameterlist => l_parameter_list);
78:

Line 83: wf_event.raise(

79: --
80: -- Raise event for outbound XML
81: --
82: l_event_key := 'HZ_IMP_ADDROUT-'||to_char(P_ADAPTER_ID)||'-'||to_char(p_batch_id)||'-'||to_char(p_subset_id);
83: wf_event.raise(
84: p_event_name => 'oracle.apps.ar.hz.import.outboundxml',
85: p_event_key => l_event_key,
86: p_event_data => NULL,
87: p_parameters => l_parameter_list,

Line 696: p_event IN OUT NOCOPY wf_event_t )

692: -- the hz_imp_addresses_int table with validated address components.
693: ------------------------------------------------------------------------
694: FUNCTION inboundxml_rule (
695: p_subscription_guid IN RAW,
696: p_event IN OUT NOCOPY wf_event_t )
697: RETURN VARCHAR2 IS
698: l_event_data CLOB := NULL;
699: l_ecx_map_code VARCHAR2(30);
700: l_adapter_id NUMBER;

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

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting processing inboundxml for this batch');
721: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
722: WF_EVENT.setErrorInfo(p_event, 'ERROR');
723: --return 'ERROR';
724: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting processing inboundxml for this batch');
728: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
729: WF_EVENT.setErrorInfo(p_event, 'ERROR');
730: --return 'ERROR';
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
732: WHEN OTHERS THEN
733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');

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

732: WHEN OTHERS THEN
733: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting processing inboundxml for this batch');
734: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
735: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
736: wf_event.setErrorInfo(p_event, 'ERROR');
737: --return 'ERROR';
738: RAISE; --Bug No: 3778263
739: END inboundxml_rule;
740:

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

745: --
746: -- This function rule will do the following
747: -- 1) Get the generated xml doc by ecx_standard.generate
748: -- 2) Pass the xml doc to HZ_LOCATION_SERVICES_PUB.submit_addrval_doc
749: -- 3) Get returned validated xml doc, raise another wf event to parse
750: -- the validated addresses.
751: ------------------------------------------------------------------------
752: function outboundxml_rule(
753: p_subscription_guid in raw,

Line 754: p_event in out nocopy wf_event_t

750: -- the validated addresses.
751: ------------------------------------------------------------------------
752: function outboundxml_rule(
753: p_subscription_guid in raw,
754: p_event in out nocopy wf_event_t
755: ) return varchar2
756: is
757: transaction_type varchar2(240);
758: transaction_subtype varchar2(240);

Line 817: wf_event.AddParameterToList(

813: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817: wf_event.AddParameterToList(
818: p_name => 'ECX_MAP_CODE',
819: p_value => 'TCA_IMP_OAG_INBOUND',
820: p_parameterlist => l_parameter_list);
821:

Line 827: wf_event.raise(

823: --
824: --- Raise the event for inboundxml
825: --
826: FND_FILE.put_line(fnd_file.log,'outboundxml_rule: raising inboundxml event');
827: wf_event.raise(
828: p_event_name => 'oracle.apps.ar.hz.import.inboundxml',
829: p_event_key => l_event_key,
830: p_event_data => to_clob(l_event_data),
831: --p_event_data => l_event_data1,

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

838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: FND_FILE.put_line(fnd_file.log,'Expected Error: Aborting outboundxml process for this batch');
841: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
842: WF_EVENT.setErrorInfo(p_event, 'ERROR');
843: --return 'ERROR';
844: RAISE FND_API.G_EXC_ERROR; --Bug No: 3778263
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: FND_FILE.put_line(fnd_file.log,'Unexpected Error: Aborting outboundxml process for this batch');
848: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
849: WF_EVENT.setErrorInfo(p_event, 'ERROR');
850: --return 'ERROR';
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; --Bug No: 3778263
852: WHEN OTHERS THEN
853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');

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

852: WHEN OTHERS THEN
853: FND_FILE.put_line(fnd_file.log,'Others Error: Aborting outboundxml process for this batch');
854: FND_FILE.put_line(fnd_file.log,'SQL Error: '||SQLERRM);
855: Wf_Core.Context('ECX_RULE', 'OUTBOUNDXML', p_event.getEventName(), p_subscription_guid);
856: wf_event.setErrorInfo(p_event, 'ERROR');
857: --return 'ERROR';
858: RAISE; --Bug No: 3778263
859: END outboundxml_rule;
860: