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_UTILITIES dependencies on EDR_UTILITIES

Line 1: PACKAGE BODY EDR_UTILITIES AS

1: PACKAGE BODY EDR_UTILITIES AS
2: /* $Header: EDRUTILB.pls 120.18.12000000.2 2007/02/12 09:33:47 pbhattip ship $ */
3: /* Print Procedure */
4:
5: --Bug 3164491 : start

Line 37: l_ruleids edr_utilities.id_List;

33: l_xml_map_code varchar2(240);
34: l_xml_document clob;
35: l_transaction_name varchar2(240);
36:
37: l_ruleids edr_utilities.id_List;
38: l_rulenames edr_utilities.string_List;
39:
40: l_rulevalues EDR_STANDARD.ameruleinputvalues;
41:

Line 38: l_rulenames edr_utilities.string_List;

34: l_xml_document clob;
35: l_transaction_name varchar2(240);
36:
37: l_ruleids edr_utilities.id_List;
38: l_rulenames edr_utilities.string_List;
39:
40: l_rulevalues EDR_STANDARD.ameruleinputvalues;
41:
42: -- Bug 2674799 : start

Line 43: approverList EDR_UTILITIES.approvers_Table;

39:
40: l_rulevalues EDR_STANDARD.ameruleinputvalues;
41:
42: -- Bug 2674799 : start
43: approverList EDR_UTILITIES.approvers_Table;
44:
45: -- ame approver api call variables
46: approvalProcessCompleteYN ame_util.charType;
47: itemClasses ame_util.stringList;

Line 216: EDR_UTILITIES.GET_APPROVERS

212:
213:
214: --Bug 2674799: start
215:
216: EDR_UTILITIES.GET_APPROVERS
217: (P_APPLICATION_ID => l_application_Id,
218: P_TRANSACTION_ID => evt.getEventKey( ),
219: P_TRANSACTION_TYPE => NVL(l_ame_transaction_type,evt.getEventName( )),
220: X_APPROVERS => approverList,

Line 1245: x_user_display_name:=nvl(l_displayname,edr_utilities.getuserdisplayname(p_user_name));

1241: BEGIN
1242:
1243: select user_display_name into l_displayname from edr_psig_details where
1244: signature_id=p_signature_id;
1245: x_user_display_name:=nvl(l_displayname,edr_utilities.getuserdisplayname(p_user_name));
1246:
1247: --Bug 3101047 : END
1248: END FETCH_USER_DISPLAY_NAME;
1249:

Line 1258: X_USER_DISPLAY_NAME := EDR_UTILITIES.getUserDisplayName(fnd_user_ap_pkg.get_user_name(P_USER_ID));

1254: PROCEDURE FETCH_USER_DISPLAY_NAME(P_USER_ID IN NUMBER,
1255: X_USER_DISPLAY_NAME OUT NOCOPY VARCHAR2)
1256: AS
1257: BEGIN
1258: X_USER_DISPLAY_NAME := EDR_UTILITIES.getUserDisplayName(fnd_user_ap_pkg.get_user_name(P_USER_ID));
1259: END FETCH_USER_DISPLAY_NAME;
1260: -- Bug 3630380 : End
1261:
1262:

Line 1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');

1496:
1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503:
1504:

Line 1533: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(P_PAYLOAD,'<','<');

1529: --Payload is of type XMLPAYLOAD.
1530: --Therefore all occurrences of '<' should be replaced by '<' and
1531: --all occurrences of '>' should be replaced by '>'
1532: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);
1533: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(P_PAYLOAD,'<','<');
1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');
1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);
1536: else
1537: --Otherwise, just append the contents of L_TEMP_CLOB into X_RETURN_CLOB

Line 1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');

1530: --Therefore all occurrences of '<' should be replaced by '<' and
1531: --all occurrences of '>' should be replaced by '>'
1532: DBMS_LOB.CREATETEMPORARY(l_temp_clob, TRUE, DBMS_LOB.SESSION);
1533: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(P_PAYLOAD,'<','<');
1534: L_TEMP_CLOB := EDR_UTILITIES.CLOB_REPLACE(l_TEMP_CLOB,'>','>');
1535: DBMS_LOB.COPY(X_RETURN_CLOB,L_TEMP_CLOB,DBMS_LOB.GETLENGTH(L_TEMP_CLOB),6,1);
1536: else
1537: --Otherwise, just append the contents of L_TEMP_CLOB into X_RETURN_CLOB
1538: DBMS_LOB.COPY(X_RETURN_CLOB,P_PAYLOAD,DBMS_LOB.GETLENGTH(P_PAYLOAD),6,1);

Line 1860: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Rule_id: '||l_rule_id||' Rule '||l_rulenames(i));

1856: --Initialize variable count to zero
1857: l_variable_count := 1;
1858:
1859: l_rule_id := l_ruleids(i);
1860: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Rule_id: '||l_rule_id||' Rule '||l_rulenames(i));
1861:
1862: --Obtain the rule variable name and value for the specified rule name.
1863:
1864: -- Bug 3214495 : Start

Line 1875: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Total Input Values '||l_rulevalues.count );

1871: );
1872:
1873: -- Bug 3214495 : End
1874:
1875: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Total Input Values '||l_rulevalues.count );
1876: --If rule variables where found then compute the rules based on
1877: --the most restrictive rule.
1878: if l_rulevalues.count > 0 then
1879: for i in 1..l_rulevalues.count loop

Line 2025: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Signature Required :'||l_esign_required);

2021: end loop;
2022: end if;
2023: end if;
2024:
2025: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Signature Required :'||l_esign_required);
2026: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','eRecord Required :'||l_erecord_required);
2027: END IF;
2028:
2029: --Bug 4704598: start

Line 2026: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','eRecord Required :'||l_erecord_required);

2022: end if;
2023: end if;
2024:
2025: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','Signature Required :'||l_esign_required);
2026: wf_log_pkg.string(6, 'EDR_UTILITIES.GET_RULES_AND_VARIABLES','eRecord Required :'||l_erecord_required);
2027: END IF;
2028:
2029: --Bug 4704598: start
2030: -- END IF;

Line 2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');

2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');
2055: APP_EXCEPTION.RAISE_EXCEPTION;
2056:
2057: END GET_RULES_AND_VARIABLES;

Line 2367: X_APPROVER_LIST OUT NOCOPY EDR_UTILITIES.APPROVERS_TABLE,

2363:
2364: --Bug 4160412: Start
2365: --This method is used to obtain the a table of approvers from the comma separated string.
2366: PROCEDURE GET_APPROVER_LIST(P_APPROVING_USERS IN VARCHAR2,
2367: X_APPROVER_LIST OUT NOCOPY EDR_UTILITIES.APPROVERS_TABLE,
2368: X_ARE_APPROVERS_VALID OUT NOCOPY VARCHAR2,
2369: X_INVALID_APPROVERS OUT NOCOPY VARCHAR2)
2370: IS
2371:

Line 2484: FUNCTION ARE_APPROVERS_REPEATING(P_APPROVER_LIST IN EDR_UTILITIES.APPROVERS_TABLE)

2480:
2481:
2482: --This functions would return true if the approver list contains repeating approvers.
2483: --Otherwise it returns false.
2484: FUNCTION ARE_APPROVERS_REPEATING(P_APPROVER_LIST IN EDR_UTILITIES.APPROVERS_TABLE)
2485:
2486: RETURN BOOLEAN
2487:
2488: IS

Line 2524: END EDR_UTILITIES;

2520: return l_repeating;
2521:
2522: END ARE_APPROVERS_REPEATING;
2523: --Bug 4160412: End
2524: END EDR_UTILITIES;