[Home] [Help]
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);
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
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
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;
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:
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
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;
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';
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';
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:
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,
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
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
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);
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
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
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:
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
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
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,
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
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
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
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:
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
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.
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*/
2246: -- Bug 4197656 : End
2247: -- Bug 3567868 :END
2248:
2249: --ER # 2966866 start
2250: if (l_inter_event_mode = 'Y' and l_relationship = EDR_CONSTANTS_GRP.g_erecord_only) then
2251: l_trans_value_only := 'Y';
2252: -- SRPURI : Bug fix 3168963 Added following code
2253: -- Deletes data in Rule Id and rulename arrays as these are not used if relationship between
2254: -- events is 'ERECORD_ONLY' and initialize array with dummay values assumin -1 never be a valid
2325: -- Bug 3161859 : End
2326:
2327: --Bug 4160412: Start
2328: --Get the signature mode parameter if found.
2329: elsif l_rulevalues(i).input_name = EDR_CONSTANTS_GRP.G_SIGNATURE_MODE then
2330: l_temp_signature_mode := l_rulevalues(i).input_value;
2331: --Bug 4160412: End
2332: end if;
2333: end loop;
2364: end if;
2365: -- Bug 3161859 : End
2366:
2367: --ER # 2966866 start
2368: if (l_inter_event_mode = 'Y' and(l_relationship = EDR_CONSTANTS_GRP.g_erecord_only OR
2369: l_relationship = EDR_CONSTANTS_GRP.g_ignore_signature )) then
2370:
2371: l_esign_required := 'N';
2372: -- Bug : 3499326 - start
2365: -- Bug 3161859 : End
2366:
2367: --ER # 2966866 start
2368: if (l_inter_event_mode = 'Y' and(l_relationship = EDR_CONSTANTS_GRP.g_erecord_only OR
2369: l_relationship = EDR_CONSTANTS_GRP.g_ignore_signature )) then
2370:
2371: l_esign_required := 'N';
2372: -- Bug : 3499326 - start
2373: l_style_sheet := l_temp_style_sheet;
2425: --turn is added to the doc params which indicates that the e-record is being
2426: --created because FORCE_ERECORD is set to Y.
2427: --This parameter is named "FORCE_ERECORD_USED".
2428: if l_eres_profile_value = 'N' OR (upper(l_esign_required) = 'N' and upper(l_erecord_required) = 'N') then
2429: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_FORCE_ERECORD_USED,'Y',p_event.Parameter_List);
2430: end if;
2431: --Bug 4150616: End
2432:
2433: l_audit_group := NVL(wf_event.getValueForParameter('EDR_AUDIT_GROUP',p_event.Parameter_List),
2463: wf_event.AddParameterToList('EREC_TEMPLATE_TYPE', l_style_sheet_type,p_event.Parameter_List); /* Template Type */
2464: -- Bug 3170251 : End
2465:
2466: -- Bug 5158510 :start
2467: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2468: -- Bug 5158510 :end
2469: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','ECX Parameter set have been set' );
2470:
2471: /* Generate XML Document */
2692: --APPROVER_COUNT and APPROVING RESPONSIBILITY.
2693: --Bug 5891879 :Start
2694: --Defaults Signature mode to SHORT when the src application type is KIOSK
2695: IF l_source_application_type = EDR_CONSTANTS_PUB.g_kiosk_mode then
2696: l_signature_mode := EDR_CONSTANTS_GRP.G_ERES_LITE;
2697: end if;
2698: --Bug 5891879 :End
2699:
2700: --Bug 4543216: Start
2697: end if;
2698: --Bug 5891879 :End
2699:
2700: --Bug 4543216: Start
2701: if l_signature_mode = EDR_CONSTANTS_GRP.G_ERES_LITE then
2702: --Bug 4543216: Start
2703:
2704: --Diagnostics Start
2705: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2713: end if;
2714: --Diagnostics End
2715:
2716: l_einitials_defer_mode := 'Y';
2717: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2718: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2719: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2720:
2721: --If approver_count and approving users are set, then raise an exception.
2714: --Diagnostics End
2715:
2716: l_einitials_defer_mode := 'Y';
2717: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2718: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2719: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2720:
2721: --If approver_count and approving users are set, then raise an exception.
2722: if l_approver_count is not null and l_approver_list is not null then
2715:
2716: l_einitials_defer_mode := 'Y';
2717: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_SIGNATURE_MODE, l_signature_mode,p_event.Parameter_List);
2718: l_approver_count := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_COUNT,p_event.Parameter_List);
2719: l_approver_list := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_APPROVER_LIST,p_event.Parameter_List);
2720:
2721: --If approver_count and approving users are set, then raise an exception.
2722: if l_approver_count is not null and l_approver_list is not null then
2723: RAISE APPROVING_USERS_PARAMS_ERR;
2758: approverlist := L_CUSTOM_APPROVER_LIST;
2759:
2760: for l_list_count in 1..approverlist.count loop
2761: if instr(approverlist(l_list_count).name,'#') = 1 then
2762: wf_event.addParameterToList(EDR_CONSTANTS_GRP.G_DO_RESPS_EXIST,'Y',p_event.Parameter_List);
2763: l_einitials_defer_mode := 'N';
2764: exit;
2765: end if;
2766: end loop;
2814: end if;
2815:
2816: --Evaluate the einitials deferred mode variable.
2817: if l_einitials_defer_mode = 'Y' then
2818: l_eres_defer_mode := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_DEFERRED_PARAM,p_event.Parameter_List);
2819: if l_eres_defer_mode is null or l_eres_defer_mode <> 'Y' then
2820: l_einitials_defer_mode := 'N';
2821: end if;
2822: END IF;
2834: end if;
2835: --Diagnostics End
2836:
2837: --Add the e-initials deferred mode variable to the event.
2838: wf_event.AddParameterToList(EDR_CONSTANTS_GRP.G_EINITIALS_DEFER_MODE,l_einitials_defer_mode,p_event.Parameter_List);
2839: END IF;
2840: --Bug 4160412: End
2841:
2842:
2877: --Diagnostics End
2878:
2879: --Bug 4122622: Start
2880: --Obtain the value of the comma separated child e-record ID string.
2881: l_child_erecord_ids := wf_event.getValueForParameter(EDR_CONSTANTS_GRP.G_CHILD_ERECORD_IDS,p_event.Parameter_List);
2882:
2883: --Set the approriate flags based on this value.
2884: if l_child_erecord_ids is not null then
2885: if instr(l_child_erecord_ids,',') > 0 then
2889: end if;
2890: end if;
2891:
2892: --Set the approriate flags based on the parent e-record id.
2893: if(l_parent_erecord_id is not null and l_parent_erecord_id <> EDR_CONSTANTS_GRP.g_default_num_param_value) then
2894: l_parent_erecord_id_set := true;
2895: end if;
2896:
2897: --Set the related e-record IDs URLs based on the flags.
2957: when INVALID_FIRST_VOTER_WINS_SETUP then
2958: FND_MESSAGE.SET_NAME('EDR','EDR_BAD_FRST_VOTER_SETUP');
2959: fnd_message.set_token( 'EVENT', l_error_event);
2960: APP_EXCEPTION.RAISE_EXCEPTION;
2961: return EDR_CONSTANTS_GRP.g_error_status;
2962: --Bug 4577122: End
2963:
2964: when NO_ENABLED_ERES_SUBSCRIPTION THEN
2965: FND_MESSAGE.SET_NAME('EDR','EDR_ERES_SUBSCRIPTION_DISABLED');
2972: );
2973: end if;
2974: --Diagnostics End
2975: APP_EXCEPTION.RAISE_EXCEPTION;
2976: return EDR_CONSTANTS_GRP.g_error_status;
2977:
2978: when NO_ERES_SUBSCRIPTION THEN
2979: FND_MESSAGE.SET_NAME('EDR','EDR_NO_ERES_SUBSCRIPTION');
2980: fnd_message.set_token( 'EVENT', l_error_event);
2988: end if;
2989: --Diagnostics End
2990:
2991: APP_EXCEPTION.RAISE_EXCEPTION;
2992: return EDR_CONSTANTS_GRP.g_error_status;
2993:
2994: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2995: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRIPTIONS');
2996: fnd_message.set_token( 'EVENT',l_error_event);
3003: end if;
3004: --Diagnostics End
3005:
3006: APP_EXCEPTION.RAISE_EXCEPTION;
3007: return EDR_CONSTANTS_GRP.g_error_status;
3008:
3009: when PAGE_FLOW_FAILED then
3010: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3011: wf_event.setErrorInfo(p_event,SQLERRM || 'ERROR');
3021: );
3022: end if;
3023: --Diagnostics End
3024: APP_EXCEPTION.RAISE_EXCEPTION;
3025: return EDR_CONSTANTS_GRP.g_error_status;
3026:
3027: --Bug 3667036: Start
3028: --Catch the XML to XML transformation error.
3029: when ECX_XML_TO_XML_ERROR then
3038: );
3039: end if;
3040: --Diagnostics End
3041: APP_EXCEPTION.RAISE_EXCEPTION;
3042: return EDR_CONSTANTS_GRP.g_error_status;
3043: --Bug 3667036: End
3044:
3045: --Bug 3893101: Start
3046: WHEN TRANSFORM_XML_VAR_ERROR then
3055: );
3056: end if;
3057: --Diagnostics End
3058: APP_EXCEPTION.RAISE_EXCEPTION;
3059: return EDR_CONSTANTS_GRP.g_error_status;
3060: --Bug 3893101: End
3061:
3062: --Bug 4160412: Start
3063: WHEN APPROVING_USERS_PARAMS_ERR THEN
3072: );
3073: end if;
3074: --Diagnostics End
3075: APP_EXCEPTION.RAISE_EXCEPTION;
3076: return EDR_CONSTANTS_GRP.g_error_status;
3077:
3078: WHEN INVALID_APPROVING_USERS THEN
3079: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_USERS');
3080: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3088: );
3089: end if;
3090: --Diagnostics End
3091: APP_EXCEPTION.RAISE_EXCEPTION;
3092: return EDR_CONSTANTS_GRP.g_error_status;
3093:
3094: WHEN REPEATING_APPROVERS_ERR THEN
3095: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_REPEATING_APPRS');
3096: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3104: );
3105: end if;
3106: --Diagnostics End
3107: APP_EXCEPTION.RAISE_EXCEPTION;
3108: return EDR_CONSTANTS_GRP.g_error_status;
3109:
3110: WHEN INVALID_APPR_COUNT_ERR THEN
3111: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_INVALID_APPR_CNT');
3112: FND_MESSAGE.SET_TOKEN('APPROVER_COUNT',l_approver_count);
3121: );
3122: end if;
3123: --Diagnostics End
3124: APP_EXCEPTION.RAISE_EXCEPTION;
3125: return EDR_CONSTANTS_GRP.g_error_status;
3126:
3127: WHEN INVALID_APPR_COUNT_VALUE_ERR THEN
3128: FND_MESSAGE.SET_NAME('EDR','EDR_EINITIALS_APPR_CNT_ERR');
3129: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());
3137: );
3138: end if;
3139: --Diagnostics End
3140: APP_EXCEPTION.RAISE_EXCEPTION;
3141: return EDR_CONSTANTS_GRP.g_error_status;
3142: --Bug 4160412: End
3143:
3144: --Bug 3960236: Start
3145: WHEN API_EXECUTION_ERROR THEN
3155: );
3156: end if;
3157: --Diagnostics End
3158: APP_EXCEPTION.RAISE_EXCEPTION;
3159: return EDR_CONSTANTS_GRP.g_error_status;
3160: -- Bug 3960236 : end
3161:
3162:
3163: WHEN EMPTY_XML_DOCUMENT THEN
3173: );
3174: end if;
3175: --Diagnostics End
3176: APP_EXCEPTION.RAISE_EXCEPTION;
3177: return EDR_CONSTANTS_GRP.g_error_status;
3178: -- Bug 3960236 : end
3179:
3180: --Bug 5724159 :start
3181: --define a new exception to throw error message when there are no approvers, Signature mode is SHORT
3192: );
3193: end if;
3194: --Diagnostics End
3195: APP_EXCEPTION.RAISE_EXCEPTION;
3196: return EDR_CONSTANTS_GRP.g_error_status;
3197: --Bug 5724159 :End
3198:
3199: when others then
3200: Wf_Core.Context('EDR_PSIG_RULE', 'PSIG_RULE', p_event.getEventName(), p_subscription_guid);
3212: end if;
3213: --Diagnostics End
3214:
3215: APP_EXCEPTION.RAISE_EXCEPTION;
3216: return EDR_CONSTANTS_GRP.g_error_status;
3217:
3218: end PSIG_RULE;
3219:
3220: end EDR_PSIG_RULE;