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_PSIG_RULE dependencies on EDR_CONSTANTS_GRP

Line 254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);

250: -- Change status
251: -- Now this part will be handeled in PSIG_RULE for Both eRecord Only
252: -- and eSignature Required scenarios
253: --
254: l_document_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_erecord_id_attr,p_eventP.Parameter_List);
255: --Diagnostics Start
256: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
257: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_PAGEFLOW_EREC_EVT');
258: FND_MESSAGE.SET_TOKEN('EVENT_NAME',l_event_name);

Line 421: if l_return_status = EDR_CONSTANTS_GRP.g_error_status THEN

417:
418: l_return_status:=WF_RULE.DEFAULT_RULE(p_subscription_guid=>p_subscription_guid,p_event=>p_eventP);
419:
420:
421: if l_return_status = EDR_CONSTANTS_GRP.g_error_status THEN
422: ROLLBACK;
423: -- Bug Fix :3154362
424: -- Added following two lines first one retrieves error message populated by
425: -- Rule function

Line 616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);

612: BEGIN
613:
614: --Bug 4150616: Start
615: --Fetch the value of FORCE_ERECORD from the event payload.
616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);
617:
618: --Fetch the value of FORCE_ERECORD_USED from the event payload.
619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);
620: --Bug 4150616: End

Line 619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);

615: --Fetch the value of FORCE_ERECORD from the event payload.
616: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,x_event.Parameter_List);
617:
618: --Fetch the value of FORCE_ERECORD_USED from the event payload.
619: l_force_erecord_used := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,x_event.Parameter_List);
620: --Bug 4150616: End
621:
622: --Bug 4074173 : start
623: l_approved := false;

Line 1036: where entity_name = EDR_CONSTANTS_GRP.g_erecord_entity_name

1032: /*
1033: -- Commented and added Copy Attachments and delete attachments
1034: update fnd_attached_documents
1035: set pk1_value = l_document_id
1036: where entity_name = EDR_CONSTANTS_GRP.g_erecord_entity_name
1037: and pk1_value = p_edr_event_id; */
1038: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord','Before Moving attachments from Temp entity to eRecord '
1039: ||'from '||p_edr_event_id||' to '||l_document_id);
1040:

Line 1143: l_params(5).param_name := EDR_CONSTANTS_GRP.G_FORCE_ERECORD;

1139: --Bug 4150616: Start
1140: --Set the value of FORCE_ERECORD if it exists in the
1141: --doc params.
1142: if upper(l_force_erecord) in('Y','N') then
1143: l_params(5).param_name := EDR_CONSTANTS_GRP.G_FORCE_ERECORD;
1144: l_params(5).param_value := l_force_erecord;
1145: l_params(5).param_displayname := 'Force E-record';
1146:
1147: --If FORCE_ERECORD_USED is set then set that parameter and its value

Line 1150: l_params(6).param_name := EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED;

1146:
1147: --If FORCE_ERECORD_USED is set then set that parameter and its value
1148: --in the doc params.
1149: if l_force_erecord_used = 'Y' then
1150: l_params(6).param_name := EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED;
1151: l_params(6).param_value := l_force_erecord_used;
1152: l_params(6).param_displayname := 'E-record Creation Forced';
1153: end if;
1154: end if;

Line 1683: l_parent_event := EDR_CONSTANTS_GRP.g_default_char_param_value;

1679:
1680: l_STYLE_SHEET_repository := 'ISIGN';
1681: user_data_placeholder := 'EDR_USER_DATA_xxYG%7#@(765';
1682:
1683: l_parent_event := EDR_CONSTANTS_GRP.g_default_char_param_value;
1684: l_parent_key := EDR_CONSTANTS_GRP.g_default_char_param_value;
1685: l_parent_erecord_id := EDR_CONSTANTS_GRP.g_default_num_param_value;
1686:
1687: l_change_signer :='ALL';

Line 1684: l_parent_key := EDR_CONSTANTS_GRP.g_default_char_param_value;

1680: l_STYLE_SHEET_repository := 'ISIGN';
1681: user_data_placeholder := 'EDR_USER_DATA_xxYG%7#@(765';
1682:
1683: l_parent_event := EDR_CONSTANTS_GRP.g_default_char_param_value;
1684: l_parent_key := EDR_CONSTANTS_GRP.g_default_char_param_value;
1685: l_parent_erecord_id := EDR_CONSTANTS_GRP.g_default_num_param_value;
1686:
1687: l_change_signer :='ALL';
1688: l_change_signer_defined :='N';

Line 1685: l_parent_erecord_id := EDR_CONSTANTS_GRP.g_default_num_param_value;

1681: user_data_placeholder := 'EDR_USER_DATA_xxYG%7#@(765';
1682:
1683: l_parent_event := EDR_CONSTANTS_GRP.g_default_char_param_value;
1684: l_parent_key := EDR_CONSTANTS_GRP.g_default_char_param_value;
1685: l_parent_erecord_id := EDR_CONSTANTS_GRP.g_default_num_param_value;
1686:
1687: l_change_signer :='ALL';
1688: l_change_signer_defined :='N';
1689:

Line 1720: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_subscription_guid);

1716: wf_event.AddParameterToList('EDR_XML_MAP_CODE',
1717: l_temp_value,
1718: p_event.Parameter_List);
1719: end if;
1720: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_subscription_guid);
1721:
1722: if(l_temp_value is not null) then
1723: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,
1724: l_temp_value,

Line 1723: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,

1719: end if;
1720: l_temp_value := EDR_INDEXED_XML_UTIL.GET_WF_PARAMS(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_subscription_guid);
1721:
1722: if(l_temp_value is not null) then
1723: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,
1724: l_temp_value,
1725: p_event.Parameter_List);
1726: end if;
1727: -- Bug 5639849: Ends

Line 1733: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_event.Parameter_List);

1729: --Fetch the value of the ERES profile option.
1730: l_eres_profile_value := fnd_profile.value('EDR_ERES_ENABLED');
1731:
1732: --Fetch the value of FORCE_ERECORD.
1733: l_force_erecord := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_FORCE_ERECORD,p_event.Parameter_List);
1734:
1735: --Convert it to upper case for ease in verification later in the code.
1736: l_force_erecord := upper(l_force_erecord);
1737: --Bug 4150616: End

Line 1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);

1772:
1773: --ER # 2966866 start
1774:
1775: --get the PARENT_EVENT_NAME parameter
1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);
1777: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Name:'||l_parent_event);
1778:
1779: --get the PARENT_EVENT_KEY parameter
1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);

Line 1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);

1776: l_parent_event := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_name ,p_event.Parameter_List);
1777: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Name:'||l_parent_event);
1778:
1779: --get the PARENT_EVENT_KEY parameter
1780: l_parent_key := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_event_key,p_event.Parameter_List);
1781:
1782: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Key:'||l_parent_key);
1783:
1784: --get the PARENT_ERECORD_ID parameter

Line 1785: l_parent_erecord_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_erecord_id,p_event.Parameter_List);

1781:
1782: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent Event Key:'||l_parent_key);
1783:
1784: --get the PARENT_ERECORD_ID parameter
1785: l_parent_erecord_id := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.g_parent_erecord_id,p_event.Parameter_List);
1786:
1787: wf_log_pkg.string(1, 'EDR_PSIG_rule.psig_rule','Parent eRecord ID:'||l_parent_erecord_id);
1788:
1789: --find out if the requisite parameters are passed in the payload so as

Line 1794: IF (l_parent_event <> EDR_CONSTANTS_GRP.g_default_char_param_value

1790: --to make it an inter event. either the parent event name AND parent event
1791: --key have to be passed in the payload OR all three, to make this an inter
1792: --event context
1793:
1794: IF (l_parent_event <> EDR_CONSTANTS_GRP.g_default_char_param_value
1795: AND l_parent_key <> EDR_CONSTANTS_GRP.g_default_char_param_value )THEN
1796:
1797: l_inter_event_mode := 'Y';
1798:

Line 1795: AND l_parent_key <> EDR_CONSTANTS_GRP.g_default_char_param_value )THEN

1791: --key have to be passed in the payload OR all three, to make this an inter
1792: --event context
1793:
1794: IF (l_parent_event <> EDR_CONSTANTS_GRP.g_default_char_param_value
1795: AND l_parent_key <> EDR_CONSTANTS_GRP.g_default_char_param_value )THEN
1796:
1797: l_inter_event_mode := 'Y';
1798:
1799: ELSIF (l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) THEN

Line 1799: ELSIF (l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) THEN

1795: AND l_parent_key <> EDR_CONSTANTS_GRP.g_default_char_param_value )THEN
1796:
1797: l_inter_event_mode := 'Y';
1798:
1799: ELSIF (l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) THEN
1800:
1801: l_inter_event_mode := 'Y';
1802:
1803: ELSE

Line 2103: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only) then

2099: -- Bug 4126932 : Start
2100: -- No need to call AME API in case of Inter Event and relationship is E-Record
2101:
2102: -- Bug 2674799 : start
2103: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only) then
2104: l_trans_value_only := 'Y';
2105: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','no need to find out approvers form ame as interevent relationship forces erecord_only');
2106: else
2107: EDR_UTILITIES.GET_APPROVERS(P_APPLICATION_ID => l_application_id,

Line 2140: and (nvl(l_relationship,'EDR') <> EDR_CONSTANTS_GRP.g_erecord_only) and l_ruleids.count >0 )then

2136: -- Bug 3567868 :Start
2137: --Bug 5724159 :Start
2138: --Added an extra 'AND' condtion to ensure that no processing takes place if no rules are defined.
2139: IF ((approverlist.count = 0)
2140: and (nvl(l_relationship,'EDR') <> EDR_CONSTANTS_GRP.g_erecord_only) and l_ruleids.count >0 )then
2141:
2142: --Bug 5724159 :End
2143: --Diagnostics Start
2144: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2198: elsif l_rulevalues(i).input_name = EDR_CONSTANTS_GRP.G_SIGNATURE_MODE then

2194: --Bug 3761813: End
2195:
2196: --Bug 4160412: Start
2197: --Set the signature mode parameter if it is set.
2198: elsif l_rulevalues(i).input_name = EDR_CONSTANTS_GRP.G_SIGNATURE_MODE then
2199:
2200: l_signature_mode := upper(l_rulevalues(i).input_value);
2201:
2202: --Bug 4160412: End

Line 2217: AND (l_change_signer = 'ALL' OR l_change_signer = EDR_CONSTANTS_GRP.g_change_signer_adhoc)

2213: --This "IF" condition needs to modified to check if the profile option is switched on.
2214: --If the profile option has been switched off, then the force e-record option has been used.
2215: --Hence in that scenario, the if condition should fail.
2216: IF (l_esign_required ='Y' AND l_change_signer_evaluate = 'Y'
2217: AND (l_change_signer = 'ALL' OR l_change_signer = EDR_CONSTANTS_GRP.g_change_signer_adhoc)
2218: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode , EDR_CONSTANTS_GRP.g_msca_mode)
2219: AND l_eres_profile_value = 'Y') THEN
2220: l_change_signer_defined := 'Y';
2221: --Bug 4150616: End

Line 2218: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode , EDR_CONSTANTS_GRP.g_msca_mode)

2214: --If the profile option has been switched off, then the force e-record option has been used.
2215: --Hence in that scenario, the if condition should fail.
2216: IF (l_esign_required ='Y' AND l_change_signer_evaluate = 'Y'
2217: AND (l_change_signer = 'ALL' OR l_change_signer = EDR_CONSTANTS_GRP.g_change_signer_adhoc)
2218: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode , EDR_CONSTANTS_GRP.g_msca_mode)
2219: AND l_eres_profile_value = 'Y') THEN
2220: l_change_signer_defined := 'Y';
2221: --Bug 4150616: End
2222:

Line 2228: ELSIF (l_esign_required = 'Y' and l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE

2224: --If force_erecord is set to 'Y', then add the "FORCE_ERECORD_USED" parameter into the event list.
2225: --Otherwise exit the rule function with a return status of "SUCCESS". (as before).
2226:
2227: --Bug 4543216: Start
2228: ELSIF (l_esign_required = 'Y' and l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE
2229: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode,EDR_CONSTANTS_GRP.g_msca_mode) AND l_eres_profile_value = 'Y') then
2230: --Bug 4543216: End
2231: l_lite_mode := true;
2232: ELSIF l_force_erecord = 'Y' then

Line 2229: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode,EDR_CONSTANTS_GRP.g_msca_mode) AND l_eres_profile_value = 'Y') then

2225: --Otherwise exit the rule function with a return status of "SUCCESS". (as before).
2226:
2227: --Bug 4543216: Start
2228: ELSIF (l_esign_required = 'Y' and l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE
2229: AND l_source_application_type not in (EDR_CONSTANTS_GRP.g_db_mode,EDR_CONSTANTS_GRP.g_msca_mode) AND l_eres_profile_value = 'Y') then
2230: --Bug 4543216: End
2231: l_lite_mode := true;
2232: ELSIF l_force_erecord = 'Y' then
2233: --Add the parameter into the event list.

Line 2234: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED, 'Y',p_event.Parameter_List);

2230: --Bug 4543216: End
2231: l_lite_mode := true;
2232: ELSIF l_force_erecord = 'Y' then
2233: --Add the parameter into the event list.
2234: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED, 'Y',p_event.Parameter_List);
2235: --Bug 4150616: End
2236: --Bug 5724159 : Start
2237: --The Control should not return back without generating E-Record
2238: /* ELSE*/

Line 2252: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only)

2248: -- bug 7154935
2249: -- Added OR condition to fix eRecord Generation issue when Force ERecord
2250: -- is used but no rule is defined.
2251: --ER # 2966866 start
2252: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only)
2253: OR (l_force_erecord = 'Y' and l_ruleids.count = 0)
2254: then
2255: l_trans_value_only := 'Y';
2256: -- SRPURI : Bug fix 3168963 Added following code

Line 2333: elsif l_rulevalues(i).input_name = EDR_CONSTANTS_GRP.G_SIGNATURE_MODE then

2329: -- Bug 3161859 : End
2330:
2331: --Bug 4160412: Start
2332: --Get the signature mode parameter if found.
2333: elsif l_rulevalues(i).input_name = EDR_CONSTANTS_GRP.G_SIGNATURE_MODE then
2334: l_temp_signature_mode := l_rulevalues(i).input_value;
2335: --Bug 4160412: End
2336: end if;
2337: end loop;

Line 2372: if (l_inter_event_mode = 'Y' and(l_relationship = EDR_CONSTANTS_GRP.g_erecord_only OR

2368: end if;
2369: -- Bug 3161859 : End
2370:
2371: --ER # 2966866 start
2372: if (l_inter_event_mode = 'Y' and(l_relationship = EDR_CONSTANTS_GRP.g_erecord_only OR
2373: l_relationship = EDR_CONSTANTS_GRP.g_ignore_signature )) then
2374:
2375: l_esign_required := 'N';
2376: -- Bug : 3499326 - start

Line 2373: l_relationship = EDR_CONSTANTS_GRP.g_ignore_signature )) then

2369: -- Bug 3161859 : End
2370:
2371: --ER # 2966866 start
2372: if (l_inter_event_mode = 'Y' and(l_relationship = EDR_CONSTANTS_GRP.g_erecord_only OR
2373: l_relationship = EDR_CONSTANTS_GRP.g_ignore_signature )) then
2374:
2375: l_esign_required := 'N';
2376: -- Bug : 3499326 - start
2377: l_style_sheet := l_temp_style_sheet;

Line 2433: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);

2429: --turn is added to the doc params which indicates that the e-record is being
2430: --created because FORCE_ERECORD is set to Y.
2431: --This parameter is named "FORCE_ERECORD_USED".
2432: if l_eres_profile_value = 'N' OR (upper(l_esign_required) = 'N' and upper(l_erecord_required) = 'N') then
2433: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);
2434: end if;
2435: --Bug 4150616: End
2436:
2437: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),

Line 2471: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);

2467: wf_event.AddParameterToList('EREC_TEMPLATE_TYPE', l_style_sheet_type,p_event.Parameter_List); /* Template Type */
2468: -- Bug 3170251 : End
2469:
2470: -- Bug 5158510 :start
2471: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2472: -- Bug 5158510 :end
2473: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );
2474:
2475: /* Generate XML Document */

Line 2700: l_signature_mode := EDR_CONSTANTS_GRP.G_ERES_LITE;

2696: --APPROVER_COUNT and APPROVING RESPONSIBILITY.
2697: --Bug 5891879 :Start
2698: --Defaults Signature mode to SHORT when the src application type is KIOSK
2699: IF l_source_application_type = EDR_CONSTANTS_PUB.g_kiosk_mode then
2700: l_signature_mode := EDR_CONSTANTS_GRP.G_ERES_LITE;
2701: end if;
2702: --Bug 5891879 :End
2703:
2704: --Bug 4543216: Start

Line 2705: if l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE then

2701: end if;
2702: --Bug 5891879 :End
2703:
2704: --Bug 4543216: Start
2705: if l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE then
2706: --Bug 4543216: Start
2707:
2708: --Diagnostics Start
2709: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);

2717: end if;
2718: --Diagnostics End
2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.

Line 2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);

2718: --Diagnostics End
2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.
2726: if l_approver_count is not null and l_approver_list is not null then

Line 2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);

2719:
2720: l_einitials_defer_mode := 'Y';
2721: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2722: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2723: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2724:
2725: --If approver_count and approving users are set, then raise an exception.
2726: if l_approver_count is not null and l_approver_list is not null then
2727: RAISE APPROVING_USERS_PARAMS_ERR;

Line 2766: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_DO_RESPS_EXIST,'Y',p_event.Parameter_List);

2762: approverlist := L_CUSTOM_APPROVER_LIST;
2763:
2764: for l_list_count in 1..approverlist.count loop
2765: if instr(approverlist(l_list_count).name,'#') = 1 then
2766: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_DO_RESPS_EXIST,'Y',p_event.Parameter_List);
2767: l_einitials_defer_mode := 'N';
2768: exit;
2769: end if;
2770: end loop;

Line 2822: l_eres_defer_mode := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_DEFERRED_PARAM,p_event.Parameter_List);

2818: end if;
2819:
2820: --Evaluate the einitials deferred mode variable.
2821: if l_einitials_defer_mode = 'Y' then
2822: l_eres_defer_mode := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_DEFERRED_PARAM,p_event.Parameter_List);
2823: if l_eres_defer_mode is null or l_eres_defer_mode <> 'Y' then
2824: l_einitials_defer_mode := 'N';
2825: end if;
2826: END IF;

Line 2842: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_EINITIALS_DEFER_MODE,l_einitials_defer_mode,p_event.Parameter_List);

2838: end if;
2839: --Diagnostics End
2840:
2841: --Add the e-initials deferred mode variable to the event.
2842: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_EINITIALS_DEFER_MODE,l_einitials_defer_mode,p_event.Parameter_List);
2843: END IF;
2844: --Bug 4160412: End
2845:
2846:

Line 2885: l_child_erecord_ids := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_CHILD_ERECORD_IDS,p_event.Parameter_List);

2881: --Diagnostics End
2882:
2883: --Bug 4122622: Start
2884: --Obtain the value of the comma separated child e-record ID string.
2885: l_child_erecord_ids := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_CHILD_ERECORD_IDS,p_event.Parameter_List);
2886:
2887: --Set the approriate flags based on this value.
2888: if l_child_erecord_ids is not null then
2889: if instr(l_child_erecord_ids,',') > 0 then

Line 2897: if(l_parent_erecord_id is not null and l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) then

2893: end if;
2894: end if;
2895:
2896: --Set the approriate flags based on the parent e-record id.
2897: if(l_parent_erecord_id is not null and l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) then
2898: l_parent_erecord_id_set := true;
2899: end if;
2900:
2901: --Set the related e-record IDs URLs based on the flags.

Line 2965: return EDR_CONSTANTS_GRP.g_error_status;

2961: when INVALID_FIRST_VOTER_WINS_SETUP then
2962: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');
2963: fnd_message.set_token( 'EVENT', l_error_event);
2964: APP_EXCEPTION.RAISE_EXCEPTION;
2965: return EDR_CONSTANTS_GRP.g_error_status;
2966: --Bug 4577122: End
2967:
2968: when NO_ENABLED_ERES_SUBSCRIPTION THEN
2969: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');

Line 2980: return EDR_CONSTANTS_GRP.g_error_status;

2976: );
2977: end if;
2978: --Diagnostics End
2979: APP_EXCEPTION.RAISE_EXCEPTION;
2980: return EDR_CONSTANTS_GRP.g_error_status;
2981:
2982: when NO_ERES_SUBSCRIPTION THEN
2983: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');
2984: fnd_message.set_token( 'EVENT', l_error_event);

Line 2996: return EDR_CONSTANTS_GRP.g_error_status;

2992: end if;
2993: --Diagnostics End
2994:
2995: APP_EXCEPTION.RAISE_EXCEPTION;
2996: return EDR_CONSTANTS_GRP.g_error_status;
2997:
2998: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2999: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
3000: fnd_message.set_token( 'EVENT',l_error_event);

Line 3011: return EDR_CONSTANTS_GRP.g_error_status;

3007: end if;
3008: --Diagnostics End
3009:
3010: APP_EXCEPTION.RAISE_EXCEPTION;
3011: return EDR_CONSTANTS_GRP.g_error_status;
3012:
3013: when PAGE_FLOW_FAILED then
3014: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3015: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');

Line 3029: return EDR_CONSTANTS_GRP.g_error_status;

3025: );
3026: end if;
3027: --Diagnostics End
3028: APP_EXCEPTION.RAISE_EXCEPTION;
3029: return EDR_CONSTANTS_GRP.g_error_status;
3030:
3031: --Bug 3667036: Start
3032: --Catch the XML to XML transformation error.
3033: when ECX_XML_TO_XML_ERROR then

Line 3046: return EDR_CONSTANTS_GRP.g_error_status;

3042: );
3043: end if;
3044: --Diagnostics End
3045: APP_EXCEPTION.RAISE_EXCEPTION;
3046: return EDR_CONSTANTS_GRP.g_error_status;
3047: --Bug 3667036: End
3048:
3049: --Bug 3893101: Start
3050: WHEN TRANSFORM_XML_VAR_ERROR then

Line 3063: return EDR_CONSTANTS_GRP.g_error_status;

3059: );
3060: end if;
3061: --Diagnostics End
3062: APP_EXCEPTION.RAISE_EXCEPTION;
3063: return EDR_CONSTANTS_GRP.g_error_status;
3064: --Bug 3893101: End
3065:
3066: --Bug 4160412: Start
3067: WHEN APPROVING_USERS_PARAMS_ERR THEN

Line 3080: return EDR_CONSTANTS_GRP.g_error_status;

3076: );
3077: end if;
3078: --Diagnostics End
3079: APP_EXCEPTION.RAISE_EXCEPTION;
3080: return EDR_CONSTANTS_GRP.g_error_status;
3081:
3082: WHEN INVALID_APPROVING_USERS THEN
3083: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3084: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

Line 3096: return EDR_CONSTANTS_GRP.g_error_status;

3092: );
3093: end if;
3094: --Diagnostics End
3095: APP_EXCEPTION.RAISE_EXCEPTION;
3096: return EDR_CONSTANTS_GRP.g_error_status;
3097:
3098: WHEN REPEATING_APPROVERS_ERR THEN
3099: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3100: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

Line 3112: return EDR_CONSTANTS_GRP.g_error_status;

3108: );
3109: end if;
3110: --Diagnostics End
3111: APP_EXCEPTION.RAISE_EXCEPTION;
3112: return EDR_CONSTANTS_GRP.g_error_status;
3113:
3114: WHEN INVALID_APPR_COUNT_ERR THEN
3115: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3116: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);

Line 3129: return EDR_CONSTANTS_GRP.g_error_status;

3125: );
3126: end if;
3127: --Diagnostics End
3128: APP_EXCEPTION.RAISE_EXCEPTION;
3129: return EDR_CONSTANTS_GRP.g_error_status;
3130:
3131: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3132: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');
3133: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

Line 3145: return EDR_CONSTANTS_GRP.g_error_status;

3141: );
3142: end if;
3143: --Diagnostics End
3144: APP_EXCEPTION.RAISE_EXCEPTION;
3145: return EDR_CONSTANTS_GRP.g_error_status;
3146: --Bug 4160412: End
3147:
3148: --Bug 3960236: Start
3149: WHEN API_EXECUTION_ERROR THEN

Line 3163: return EDR_CONSTANTS_GRP.g_error_status;

3159: );
3160: end if;
3161: --Diagnostics End
3162: APP_EXCEPTION.RAISE_EXCEPTION;
3163: return EDR_CONSTANTS_GRP.g_error_status;
3164: -- Bug 3960236 : end
3165:
3166:
3167: WHEN EMPTY_XML_DOCUMENT THEN

Line 3181: return EDR_CONSTANTS_GRP.g_error_status;

3177: );
3178: end if;
3179: --Diagnostics End
3180: APP_EXCEPTION.RAISE_EXCEPTION;
3181: return EDR_CONSTANTS_GRP.g_error_status;
3182: -- Bug 3960236 : end
3183:
3184: --Bug 5724159 :start
3185: --define a new exception to throw error message when there are no approvers, Signature mode is SHORT

Line 3200: return EDR_CONSTANTS_GRP.g_error_status;

3196: );
3197: end if;
3198: --Diagnostics End
3199: APP_EXCEPTION.RAISE_EXCEPTION;
3200: return EDR_CONSTANTS_GRP.g_error_status;
3201: --Bug 5724159 :End
3202:
3203: when others then
3204: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);

Line 3220: return EDR_CONSTANTS_GRP.g_error_status;

3216: end if;
3217: --Diagnostics End
3218:
3219: APP_EXCEPTION.RAISE_EXCEPTION;
3220: return EDR_CONSTANTS_GRP.g_error_status;
3221:
3222: end PSIG_RULE;
3223:
3224: end EDR_PSIG_RULE;