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.EDR_ERES_EVENT_PVT dependencies on EDR_CONSTANTS_GRP

Line 25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function

21: select b.guid
22: from wf_events_vl a, wf_event_subscriptions b
23: where a.guid=b.EVENT_FILTER_GUID
24: and a.name = p_event_name
25: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
26: and b.status = 'ENABLED'
27: --Bug No 4912782- Start
28: and b.source_type = 'LOCAL'
29: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;

Line 37: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function

33: select b.guid
34: from wf_events_vl a, wf_event_subscriptions b
35: where a.guid=b.EVENT_FILTER_GUID
36: and a.name = p_event_name
37: and UPPER(b.rule_function) = EDR_CONSTANTS_GRP.g_rule_function
38: --Bug No 4912782- Start
39: and b.source_type = 'LOCAL'
40: and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID')) ;
41: --Bug No 4912782- End

Line 179: -- CHANGE_SOURCE_TYPE(x_event.payload, EDR_CONSTANTS_GRP.g_db_mode);

175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: -- API Body
178:
179: -- CHANGE_SOURCE_TYPE(x_event.payload, EDR_CONSTANTS_GRP.g_db_mode);
180: --Bug 3136403: Start
181: --Copy the individual parameters to a structure
182: --of type fnd_wf_event.param_table
183: --start with 4 because in event of the payload with valid

Line 232: if (l_parameter_list(i).PARAM_NAME = EDR_CONSTANTS_GRP.g_parent_erecord_id) then

228: i := 4;
229: while i is not null loop
230: --Bug 4122622: Start
231: --We need to obtain the parent e-record id.
232: if (l_parameter_list(i).PARAM_NAME = EDR_CONSTANTS_GRP.g_parent_erecord_id) then
233: l_parent_erecord_id := l_parameter_list(i).param_value;
234: x_is_child_event := TRUE;
235: exit;
236: end if;

Line 271: l_parameter_list(1).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemtype_attr;

267: --this would help in putting additional parameters at specific locations
268: --and also do some additional payload inspection to figure out if
269: --this is inter event mode
270:
271: l_parameter_list(1).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemtype_attr;
272: l_parameter_list(1).param_value := null;
273: l_parameter_list(2).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemkey_attr;
274: l_parameter_list(2).param_value := null;
275:

Line 273: l_parameter_list(2).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemkey_attr;

269: --this is inter event mode
270:
271: l_parameter_list(1).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemtype_attr;
272: l_parameter_list(1).param_value := null;
273: l_parameter_list(2).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemkey_attr;
274: l_parameter_list(2).param_value := null;
275:
276: --the third parameter would be the #ERECORD_ID that would contain the erecord id
277: l_parameter_list(3).param_name := EDR_CONSTANTS_GRP.g_erecord_id_attr;

Line 277: l_parameter_list(3).param_name := EDR_CONSTANTS_GRP.g_erecord_id_attr;

273: l_parameter_list(2).param_name := EDR_CONSTANTS_GRP.g_wf_pageflow_itemkey_attr;
274: l_parameter_list(2).param_value := null;
275:
276: --the third parameter would be the #ERECORD_ID that would contain the erecord id
277: l_parameter_list(3).param_name := EDR_CONSTANTS_GRP.g_erecord_id_attr;
278: l_parameter_list(3).param_value := null;
279:
280: --raise the event
281: begin

Line 328: x_event.event_status := EDR_CONSTANTS_GRP.g_no_action_status;

324: AND l_parameter_list(2).param_value is NULL
325: THEN
326: -- this means that no signature was required
327: -- No WF, mark as success
328: x_event.event_status := EDR_CONSTANTS_GRP.g_no_action_status;
329:
330: -- an eRecord may or may not have been required anyhow
331: -- get the erecord id
332: x_event.erecord_id := l_parameter_list(3).param_value;

Line 337: x_event.event_status := EDR_CONSTANTS_GRP.g_pending_status;

333:
334: ELSE
335: -- this means that signature was required and offline notification
336: -- has been sent out
337: x_event.event_status := EDR_CONSTANTS_GRP.g_pending_status;
338:
339: --get the erecord id
340: x_event.erecord_id := l_parameter_list(3).param_value;
341: END IF;

Line 353: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;

349:
350: EXCEPTION
351: WHEN PAYLOAD_VALIDATION_ERROR THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
354:
355: -- this would pass on the validation errors to the calling
356: -- routine
357:

Line 365: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;

361: );
362:
363: WHEN EVENT_RAISE_ERROR THEN
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
366: x_event.erecord_id := null;
367:
368: l_mesg_text := fnd_message.get_string('EDR','EDR_EVENT_RAISE_ERROR');
369:

Line 383: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;

379: );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
384: x_event.erecord_id := null;
385:
386: FND_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count ,

Line 415: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;

411: --Bug 4122622: End
412:
413: WHEN OTHERS THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: x_event.event_status := EDR_CONSTANTS_GRP.g_error_status;
416: x_event.erecord_id := null;
417:
418: IF FND_MSG_PUB.Check_Msg_Level
419: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1026: l_event_name := EDR_CONSTANTS_GRP.G_APPROVAL_COMPLETION_EVT;

1022: IF NOT l_wfitemtype_set or NOT l_wfitemkey_set then
1023:
1024: --Hence the approval is complete.
1025: --Raise the approval completetion event with same event key as a combination of the event name and event key.
1026: l_event_name := EDR_CONSTANTS_GRP.G_APPROVAL_COMPLETION_EVT;
1027:
1028: IF length(l_erecord_id) > 0 then
1029: l_event_key := l_erecord_id;
1030: else

Line 1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);

1030: else
1031: l_event_key := '-1';
1032: END IF;
1033:
1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);
1035:
1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN

Line 1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);

1032: END IF;
1033:
1034: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_NAME,p_orig_event_name,l_param_list);
1035:
1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);

Line 1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);

1036: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ORIGINAL_EVENT_KEY,p_orig_event_key,l_param_list);
1037:
1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);
1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE

Line 1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);

1038: if length(l_erecord_id) > 0 THEN
1039:
1040: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_ERECORD_ID,l_erecord_id,l_param_list);
1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE
1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);
1046: END IF;

Line 1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);

1041:
1042: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_COMPLETE_STATUS,l_param_list);
1043:
1044: ELSE
1045: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_EVENT_STATUS,EDR_CONSTANTS_GRP.G_NO_ERES_STATUS,l_param_list);
1046: END IF;
1047:
1048: --Raise the approval completion event.
1049: WF_EVENT.RAISE3(L_EVENT_NAME,