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.BIS_RESPONSIBILITY_PVT dependencies on FND_API

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52:
53: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
54:
55: BEGIN
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: FOR cr in rsp_cur LOOP
59: l_rec.Responsibility_ID := cr.RESPONSIBILITY_ID;
60: l_rec.Responsibility_Short_Name := cr.RESPONSIBILITY_KEY;

Line 67: when FND_API.G_EXC_ERROR then

63: END LOOP;
64:
65:
66: EXCEPTION
67: when FND_API.G_EXC_ERROR then
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 68: x_return_status := FND_API.G_RET_STS_ERROR ;

64:
65:
66: EXCEPTION
67: when FND_API.G_EXC_ERROR then
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 70: RAISE FND_API.G_EXC_ERROR;

66: EXCEPTION
67: when FND_API.G_EXC_ERROR then
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then

Line 71: when FND_API.G_EXC_UNEXPECTED_ERROR then

67: when FND_API.G_EXC_ERROR then
68: x_return_status := FND_API.G_RET_STS_ERROR ;
69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

68: x_return_status := FND_API.G_RET_STS_ERROR ;
69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: BIS_UTILITIES_PVT.Add_Error_Message

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

69:
70: RAISE FND_API.G_EXC_ERROR;
71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: BIS_UTILITIES_PVT.Add_Error_Message
77: ( p_error_msg_id => SQLCODE

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

71: when FND_API.G_EXC_UNEXPECTED_ERROR then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: BIS_UTILITIES_PVT.Add_Error_Message
77: ( p_error_msg_id => SQLCODE
78: , p_error_description => SQLERRM
79: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: , p_error_description => SQLERRM
79: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'
80: );
81:
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83:
84: END Retrieve_User_Responsibilities;
85: --
86: Procedure Retrieve_User_Responsibilities

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
111: l_version VARCHAR2(1);
112:
113: BEGIN
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: l_version := p_Responsibility_version;
117:
118: IF BIS_UTILITIES_PUB.Value_Missing(l_version) = FND_API.G_TRUE

Line 118: IF BIS_UTILITIES_PUB.Value_Missing(l_version) = FND_API.G_TRUE

114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: l_version := p_Responsibility_version;
117:
118: IF BIS_UTILITIES_PUB.Value_Missing(l_version) = FND_API.G_TRUE
119: OR BIS_UTILITIES_PUB.Value_Null(l_version) = FND_API.G_TRUE
120: THEN l_version := '%';
121: END IF;
122:

Line 119: OR BIS_UTILITIES_PUB.Value_Null(l_version) = FND_API.G_TRUE

115:
116: l_version := p_Responsibility_version;
117:
118: IF BIS_UTILITIES_PUB.Value_Missing(l_version) = FND_API.G_TRUE
119: OR BIS_UTILITIES_PUB.Value_Null(l_version) = FND_API.G_TRUE
120: THEN l_version := '%';
121: END IF;
122:
123: FOR cr in rsp_cur(l_version) LOOP

Line 131: when FND_API.G_EXC_ERROR then

127: x_Responsibility_Tbl(x_Responsibility_Tbl.COUNT+1) := l_rec;
128: END LOOP;
129:
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 132: x_return_status := FND_API.G_RET_STS_ERROR ;

128: END LOOP;
129:
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 133: RAISE FND_API.G_EXC_ERROR;

129:
130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then

Line 134: when FND_API.G_EXC_UNEXPECTED_ERROR then

130: EXCEPTION
131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

131: when FND_API.G_EXC_ERROR then
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_UTILITIES_PVT.Add_Error_Message

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: RAISE FND_API.G_EXC_ERROR;
134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_UTILITIES_PVT.Add_Error_Message
140: ( p_error_msg_id => SQLCODE

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

134: when FND_API.G_EXC_UNEXPECTED_ERROR then
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_UTILITIES_PVT.Add_Error_Message
140: ( p_error_msg_id => SQLCODE
141: , p_error_description => SQLERRM
142: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: , p_error_description => SQLERRM
142: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'
143: );
144:
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146:
147: END Retrieve_User_Responsibilities;
148: --
149: Procedure Retrieve_All_Responsibilities

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: order by RESPONSIBILITY_NAME;
165: l_rec BIS_RESPONSIBILITY_PVT.Responsibility_Rec_Type;
166: BEGIN
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: for cr in resp_cur LOOP
170: l_rec.Responsibility_ID := cr.RESPONSIBILITY_ID;
171: l_rec.Responsibility_Short_Name := cr.RESPONSIBILITY_KEY;
172: l_rec.Responsibility_Name := cr.RESPONSIBILITY_NAME;

Line 177: when FND_API.G_EXC_ERROR then

173: x_Responsibility_Tbl(x_Responsibility_Tbl.COUNT+1) := l_rec;
174: END LOOP;
175:
176: EXCEPTION
177: when FND_API.G_EXC_ERROR then
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 178: x_return_status := FND_API.G_RET_STS_ERROR ;

174: END LOOP;
175:
176: EXCEPTION
177: when FND_API.G_EXC_ERROR then
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 180: RAISE FND_API.G_EXC_ERROR;

176: EXCEPTION
177: when FND_API.G_EXC_ERROR then
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then

Line 181: when FND_API.G_EXC_UNEXPECTED_ERROR then

177: when FND_API.G_EXC_ERROR then
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

178: x_return_status := FND_API.G_RET_STS_ERROR ;
179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179:
180: RAISE FND_API.G_EXC_ERROR;
181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
187: ( p_error_msg_id => SQLCODE

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

181: when FND_API.G_EXC_UNEXPECTED_ERROR then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
187: ( p_error_msg_id => SQLCODE
188: , p_error_description => SQLERRM
189: , p_error_proc_name => G_PKG_NAME||'.Retrieve_All_Responsibilities'

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: , p_error_description => SQLERRM
189: , p_error_proc_name => G_PKG_NAME||'.Retrieve_All_Responsibilities'
190: );
191:
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193:
194: END Retrieve_All_Responsibilities;
195: --
196: Procedure Retrieve_Responsibility

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: )
203: IS
204: BEGIN
205:
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: BEGIN
209: select RESPONSIBILITY_ID
210: , RESPONSIBILITY_KEY

Line 222: x_return_status := FND_API.G_RET_STS_ERROR ;

218: and nvl(end_date, sysdate) >= sysdate
219: and RESPONSIBILITY_ID=p_Responsibility_Rec.RESPONSIBILITY_ID;
220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: --Added last two params
224: BIS_UTILITIES_PVT.Add_Error_Message
225: ( p_error_msg_id => SQLCODE
226: , p_error_description => SQLERRM

Line 236: when FND_API.G_EXC_ERROR then

232:
233: --commented RAISE
234: EXCEPTION
235:
236: when FND_API.G_EXC_ERROR then
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 237: x_return_status := FND_API.G_RET_STS_ERROR ;

233: --commented RAISE
234: EXCEPTION
235:
236: when FND_API.G_EXC_ERROR then
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 238: --RAISE FND_API.G_EXC_ERROR;

234: EXCEPTION
235:
236: when FND_API.G_EXC_ERROR then
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then

Line 239: when FND_API.G_EXC_UNEXPECTED_ERROR then

235:
236: when FND_API.G_EXC_ERROR then
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

236: when FND_API.G_EXC_ERROR then
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: --Added last two params

Line 241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: --RAISE FND_API.G_EXC_ERROR;
239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: --Added last two params
245: BIS_UTILITIES_PVT.Add_Error_Message

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

239: when FND_API.G_EXC_UNEXPECTED_ERROR then
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: --Added last two params
245: BIS_UTILITIES_PVT.Add_Error_Message
246: ( p_error_msg_id => SQLCODE
247: , p_error_description => SQLERRM

Line 253: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: , p_error_table => x_error_tbl
250: , x_error_table => x_error_tbl
251: );
252:
253: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254:
255: END Retrieve_Responsibility;
256:
257: PROCEDURE Validate_Def_Notify_Resp_Id

Line 259: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

255: END Retrieve_Responsibility;
256:
257: PROCEDURE Validate_Def_Notify_Resp_Id
258: ( p_api_version IN NUMBER
259: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
260: , p_Def_Notify_Resp_Id IN NUMBER
261: , x_return_status OUT NOCOPY VARCHAR2
262: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
263: )

Line 267: x_return_status := FND_API.G_RET_STS_SUCCESS;

263: )
264: IS
265: BEGIN
266:
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: NULL;
269: EXCEPTION
270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 270: when FND_API.G_EXC_ERROR then

266:
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: NULL;
269: EXCEPTION
270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 271: x_return_status := FND_API.G_RET_STS_ERROR ;

267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: NULL;
269: EXCEPTION
270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 272: RAISE FND_API.G_EXC_ERROR;

268: NULL;
269: EXCEPTION
270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then

Line 273: when FND_API.G_EXC_UNEXPECTED_ERROR then

269: EXCEPTION
270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

270: when FND_API.G_EXC_ERROR then
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: BIS_UTILITIES_PVT.Add_Error_Message

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: RAISE FND_API.G_EXC_ERROR;
273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: BIS_UTILITIES_PVT.Add_Error_Message
279: ( p_error_msg_id => SQLCODE

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: when FND_API.G_EXC_UNEXPECTED_ERROR then
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: BIS_UTILITIES_PVT.Add_Error_Message
279: ( p_error_msg_id => SQLCODE
280: , p_error_description => SQLERRM
281: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: ( p_error_msg_id => SQLCODE
280: , p_error_description => SQLERRM
281: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'
282: );
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284:
285: END Validate_Def_Notify_Resp_Id;
286: --
287: PROCEDURE Retrieve_Notify_Resp_Name

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: FROM wf_role_lov_vl
299: WHERE NAME = p_Notify_resp_short_name;
300:
301: BEGIN
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: OPEN cr_wf_role;
305: FETCH cr_wf_role INTO x_notify_resp_name;
306: CLOSE cr_wf_role;

Line 309: when FND_API.G_EXC_ERROR then

305: FETCH cr_wf_role INTO x_notify_resp_name;
306: CLOSE cr_wf_role;
307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 310: x_return_status := FND_API.G_RET_STS_ERROR ;

306: CLOSE cr_wf_role;
307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 311: RAISE FND_API.G_EXC_ERROR;

307:
308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then

Line 312: when FND_API.G_EXC_UNEXPECTED_ERROR then

308: EXCEPTION
309: when FND_API.G_EXC_ERROR then
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then
316:

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

309: when FND_API.G_EXC_ERROR then
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then
316:
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: RAISE FND_API.G_EXC_ERROR;
312: when FND_API.G_EXC_UNEXPECTED_ERROR then
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then
316:
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: BIS_UTILITIES_PVT.Add_Error_Message

Line 317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then
316:
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: BIS_UTILITIES_PVT.Add_Error_Message
319: ( p_error_msg_id => SQLCODE
320: , p_error_description => SQLERRM
321: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Notify_Resp_Name'

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: ( p_error_msg_id => SQLCODE
320: , p_error_description => SQLERRM
321: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Notify_Resp_Name'
322: );
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324:
325: END Retrieve_Notify_Resp_Name;
326: --
327: PROCEDURE Validate_Notify_Resp_ID

Line 330: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

326: --
327: PROCEDURE Validate_Notify_Resp_ID
328:
329: ( p_api_version IN NUMBER
330: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
331: , p_Notify_Resp_ID IN NUMBER
332: , x_return_status OUT NOCOPY VARCHAR2
333: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
334: )

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334: )
335: IS
336: BEGIN
337: --added the status
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339: NULL;
340: EXCEPTION
341: when FND_API.G_EXC_ERROR then
342: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 341: when FND_API.G_EXC_ERROR then

337: --added the status
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339: NULL;
340: EXCEPTION
341: when FND_API.G_EXC_ERROR then
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 342: x_return_status := FND_API.G_RET_STS_ERROR ;

338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339: NULL;
340: EXCEPTION
341: when FND_API.G_EXC_ERROR then
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 343: RAISE FND_API.G_EXC_ERROR;

339: NULL;
340: EXCEPTION
341: when FND_API.G_EXC_ERROR then
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 345: when FND_API.G_EXC_UNEXPECTED_ERROR then

341: when FND_API.G_EXC_ERROR then
342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

342: x_return_status := FND_API.G_RET_STS_ERROR ;
343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343: RAISE FND_API.G_EXC_ERROR;
344:
345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
351: ( p_error_msg_id => SQLCODE

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

345: when FND_API.G_EXC_UNEXPECTED_ERROR then
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
351: ( p_error_msg_id => SQLCODE
352: , p_error_description => SQLERRM
353: , p_error_proc_name => G_PKG_NAME||'.Validate_Notify_Resp_ID'

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: ( p_error_msg_id => SQLCODE
352: , p_error_description => SQLERRM
353: , p_error_proc_name => G_PKG_NAME||'.Validate_Notify_Resp_ID'
354: );
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356:
357:
358: END Validate_Notify_Resp_ID;
359: --

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: )
368: IS
369: BEGIN
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: NULL;
373: EXCEPTION
374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 374: when FND_API.G_EXC_ERROR then

370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: NULL;
373: EXCEPTION
374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 375: x_return_status := FND_API.G_RET_STS_ERROR ;

371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: NULL;
373: EXCEPTION
374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: NULL;
373: EXCEPTION
374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then

Line 377: when FND_API.G_EXC_UNEXPECTED_ERROR then

373: EXCEPTION
374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

374: when FND_API.G_EXC_ERROR then
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: BIS_UTILITIES_PVT.Add_Error_Message

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: RAISE FND_API.G_EXC_ERROR;
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: BIS_UTILITIES_PVT.Add_Error_Message
383: ( p_error_msg_id => SQLCODE

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: BIS_UTILITIES_PVT.Add_Error_Message
383: ( p_error_msg_id => SQLCODE
384: , p_error_description => SQLERRM
385: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: ( p_error_msg_id => SQLCODE
384: , p_error_description => SQLERRM
385: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
386: );
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388:
389: END Value_ID_Conversion;
390: --
391: PROCEDURE DFR_Value_ID_Conversion

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
399: )
400: IS
401: BEGIN
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403: NULL;
404: EXCEPTION
405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 405: when FND_API.G_EXC_ERROR then

401: BEGIN
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403: NULL;
404: EXCEPTION
405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 406: x_return_status := FND_API.G_RET_STS_ERROR ;

402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403: NULL;
404: EXCEPTION
405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 407: RAISE FND_API.G_EXC_ERROR;

403: NULL;
404: EXCEPTION
405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:

Line 408: when FND_API.G_EXC_UNEXPECTED_ERROR then

404: EXCEPTION
405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: when others then

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

405: when FND_API.G_EXC_ERROR then
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: when others then
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: RAISE FND_API.G_EXC_ERROR;
408: when FND_API.G_EXC_UNEXPECTED_ERROR then
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: when others then
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
414: BIS_UTILITIES_PVT.Add_Error_Message

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: when others then
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
414: BIS_UTILITIES_PVT.Add_Error_Message
415: ( p_error_msg_id => SQLCODE
416: , p_error_description => SQLERRM
417: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415: ( p_error_msg_id => SQLCODE
416: , p_error_description => SQLERRM
417: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'
418: );
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420:
421: END DFR_Value_ID_Conversion;
422: --
423: -- removes the responsibilities from p_all_security