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_ADHOC_USER_PVT dependencies on EDR_PSIG

Line 5: -- defined a exception if there is from edr_psig

1: PACKAGE BODY EDR_ADHOC_USER_PVT AS
2: /* $Header: EDRVADHB.pls 120.1.12000000.1 2007/01/18 05:56:02 appldev ship $
3:
4: /* Exception declaration */
5: -- defined a exception if there is from edr_psig
6: EDR_PSIG_ERROR Exception;
7:
8: -- Bug 2674799 : start
9: -- Update approver list for the signer process

Line 6: EDR_PSIG_ERROR Exception;

2: /* $Header: EDRVADHB.pls 120.1.12000000.1 2007/01/18 05:56:02 appldev ship $
3:
4: /* Exception declaration */
5: -- defined a exception if there is from edr_psig
6: EDR_PSIG_ERROR Exception;
7:
8: -- Bug 2674799 : start
9: -- Update approver list for the signer process
10: procedure UPDATE_SIGNERLIST (

Line 70: -- get the signature id from edr_psig

66: l_actiondone := G_ACTION_REQD;
67: l_error := null;
68: l_error_msg := null;
69:
70: -- get the signature id from edr_psig
71: edr_psig.getSignatureId(
72: P_DOCUMENT_ID => P_DOCUMENT_ID,
73: P_ORIGINAL_RECIPIENT=> l_original_recipient,
74: P_USER_NAME => l_final_recipient,

Line 71: edr_psig.getSignatureId(

67: l_error := null;
68: l_error_msg := null;
69:
70: -- get the signature id from edr_psig
71: edr_psig.getSignatureId(
72: P_DOCUMENT_ID => P_DOCUMENT_ID,
73: P_ORIGINAL_RECIPIENT=> l_original_recipient,
74: P_USER_NAME => l_final_recipient,
75: P_SIGNATURE_STATUS => 'PENDING',

Line 80: RAISE EDR_PSIG_ERROR;

76: X_SIGNATURE_ID => l_psig_signature_id,
77: X_ERROR => l_error,
78: X_ERROR_MSG => l_error_msg);
79: IF (nvl(l_error,0) >0) then
80: RAISE EDR_PSIG_ERROR;
81: END IF;
82:
83: for i in 1 .. p_originalrecipient.count loop
84: if p_originalrecipient(i) is not null then

Line 102: edr_psig.update_signature_sequence (

98: WHERE EVENT_ID = p_event_id
99: AND USER_NAME =l_final_recipient
100: AND ORIGINAL_RECIPIENT = l_original_recipient;
101:
102: edr_psig.update_signature_sequence (
103: P_SIGNATURE_ID => l_psig_signature_id,
104: P_SIGNATURE_SEQUENCE =>
105: p_signaturesequence(i),
106: X_ERROR => l_error,

Line 111: RAISE EDR_PSIG_ERROR;

107: X_ERROR_MSG => l_error_msg);
108: --Bug 2674799 : end
109:
110: IF (nvl(l_error,0) >0) then
111: RAISE EDR_PSIG_ERROR;
112: end if;
113: --end if;
114: l_updatestatus(i) := G_NO_ACTION_REQD;
115: l_actiondone := G_NO_ACTION_REQD;

Line 132: edr_psig.get_adhoc_status (P_SIGNATURE_ID => l_psig_signature_id,

128: -- get the adhoc status for the signatureid
129: -- if the adhoc status is ADDED then delete
130: -- delete the user else cancel the signature
131:
132: edr_psig.get_adhoc_status (P_SIGNATURE_ID => l_psig_signature_id,
133: X_STATUS => l_adhoc_status,
134: X_ERROR => l_error,
135: X_ERROR_MSG => l_error_msg);
136:

Line 138: RAISE EDR_PSIG_ERROR;

134: X_ERROR => l_error,
135: X_ERROR_MSG => l_error_msg);
136:
137: IF (nvl(l_error,0) >0) then
138: RAISE EDR_PSIG_ERROR;
139: END IF;
140:
141: IF (l_adhoc_status = 'ADDED') then
142: edr_psig.delete_adhoc_user (P_SIGNATURE_ID => l_psig_signature_id,

Line 142: edr_psig.delete_adhoc_user (P_SIGNATURE_ID => l_psig_signature_id,

138: RAISE EDR_PSIG_ERROR;
139: END IF;
140:
141: IF (l_adhoc_status = 'ADDED') then
142: edr_psig.delete_adhoc_user (P_SIGNATURE_ID => l_psig_signature_id,
143: X_ERROR => l_error,
144: X_ERROR_MSG => l_error_msg);
145: IF (nvl(l_error,0) >0) then
146: RAISE EDR_PSIG_ERROR;

Line 146: RAISE EDR_PSIG_ERROR;

142: edr_psig.delete_adhoc_user (P_SIGNATURE_ID => l_psig_signature_id,
143: X_ERROR => l_error,
144: X_ERROR_MSG => l_error_msg);
145: IF (nvl(l_error,0) >0) then
146: RAISE EDR_PSIG_ERROR;
147: END IF;
148:
149: else
150: edr_psig.cancelSignature ( P_SIGNATURE_ID => l_psig_signature_id,

Line 150: edr_psig.cancelSignature ( P_SIGNATURE_ID => l_psig_signature_id,

146: RAISE EDR_PSIG_ERROR;
147: END IF;
148:
149: else
150: edr_psig.cancelSignature ( P_SIGNATURE_ID => l_psig_signature_id,
151: P_ERROR => l_error,
152: P_ERROR_MSG => l_error_msg);
153: IF (nvl(l_error,0) >0) then
154: RAISE EDR_PSIG_ERROR;

Line 154: RAISE EDR_PSIG_ERROR;

150: edr_psig.cancelSignature ( P_SIGNATURE_ID => l_psig_signature_id,
151: P_ERROR => l_error,
152: P_ERROR_MSG => l_error_msg);
153: IF (nvl(l_error,0) >0) then
154: RAISE EDR_PSIG_ERROR;
155: END IF;
156:
157: edr_psig.update_adhoc_status ( P_SIGNATURE_ID =>
158: l_psig_signature_id,

Line 157: edr_psig.update_adhoc_status ( P_SIGNATURE_ID =>

153: IF (nvl(l_error,0) >0) then
154: RAISE EDR_PSIG_ERROR;
155: END IF;
156:
157: edr_psig.update_adhoc_status ( P_SIGNATURE_ID =>
158: l_psig_signature_id,
159: P_ADHOC_STATUS => 'DELETED',
160: X_ERROR => l_error,
161: X_ERROR_MSG => l_error_msg);

Line 163: RAISE EDR_PSIG_ERROR;

159: P_ADHOC_STATUS => 'DELETED',
160: X_ERROR => l_error,
161: X_ERROR_MSG => l_error_msg);
162: IF (nvl(l_error,0) >0) then
163: RAISE EDR_PSIG_ERROR;
164: END IF;
165: end if;
166: end if;-- end l_action_done
167: end loop;

Line 212: EDR_PSIG.REQUESTSIGNATURE(P_DOCUMENT_ID => p_document_id ,

208: l_original_recipient,
209: l_overriding_comments
210: );
211:
212: EDR_PSIG.REQUESTSIGNATURE(P_DOCUMENT_ID => p_document_id ,
213: P_USER_NAME => l_overriding_approver,
214: P_ORIGINAL_RECIPIENT =>
215: l_original_recipient,
216: P_OVERRIDING_COMMENTS =>

Line 227: RAISE EDR_PSIG_ERROR;

223: P_ERROR_MSG=>l_error_msg);
224: --Bug 2674799 : end
225:
226: IF (nvl(l_error,0) >0) then
227: RAISE EDR_PSIG_ERROR;
228: END IF;
229: end if;
230: end if;
231: end loop;

Line 235: WHEN EDR_PSIG_ERROR THEN

231: end loop;
232: commit;
233: X_ERROR := 0;
234: EXCEPTION
235: WHEN EDR_PSIG_ERROR THEN
236: ROLLBACK;
237: X_ERROR := l_ERROR;
238: X_ERROR_MSG := l_error_msg;
239: