APPS.BIS_DIMENSION_PVT dependencies on FND_API

Line 85: p_hide IN VARCHAR2 := FND_API.G_FALSE,

81: ( p_dimension_id IN NUMBER, -- l_id
82: p_dimension_short_name IN VARCHAR2, -- l_Dimension_Rec.Dimension_Short_Name
83: p_application_id IN NUMBER := NULL,
84: p_dim_grp_id IN NUMBER,
85: p_hide IN VARCHAR2 := FND_API.G_FALSE,
86: p_created_by IN NUMBER, -- created_by
87: p_last_updated_by IN NUMBER, -- last_updated_by
88: p_login_id IN NUMBER, -- l_login_id
89: p_dimension_name IN VARCHAR2, -- l_Dimension_Rec.Dimension_Name

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: RAISE;
127: WHEN OTHERS THEN

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: RAISE;
127: WHEN OTHERS THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129:

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: RAISE;
127: WHEN OTHERS THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129:
130: END SetNULL;
131: --
132: PROCEDURE UpdateRecord

Line 145: x_return_status:= FND_API.G_RET_STS_SUCCESS;

141: l_return_status VARCHAR2(10);
142: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
143: --
144: BEGIN
145: x_return_status:= FND_API.G_RET_STS_SUCCESS;
146:
147: -- retrieve record from db
148: BIS_Dimension_PVT.Retrieve_Dimension
149: ( p_api_version => 1.0

Line 156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

152: , x_return_status => x_return_status
153: , x_error_Tbl => x_error_Tbl
154: );
155:
156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- apply changes

Line 157: RAISE FND_API.G_EXC_ERROR;

153: , x_error_Tbl => x_error_Tbl
154: );
155:
156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: -- apply changes
161: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.Dimension_ID)

Line 162: = FND_API.G_TRUE

158: END IF;
159:
160: -- apply changes
161: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.Dimension_ID)
162: = FND_API.G_TRUE
163: ) THEN
164: l_Dimension_Rec.Dimension_ID := p_Dimension_Rec.Dimension_ID;
165: END IF;
166: --

Line 169: = FND_API.G_TRUE

165: END IF;
166: --
167: IF( BIS_UTILITIES_PUB.Value_Not_Missing
168: (p_Dimension_Rec.Dimension_Short_Name)
169: = FND_API.G_TRUE
170: ) THEN
171: l_Dimension_Rec.Dimension_Short_Name
172: := p_Dimension_Rec.Dimension_Short_Name ;
173: END IF;

Line 176: = FND_API.G_TRUE

172: := p_Dimension_Rec.Dimension_Short_Name ;
173: END IF;
174: --
175: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.Dimension_Name)
176: = FND_API.G_TRUE
177: ) THEN
178: l_Dimension_Rec.Dimension_Name := p_Dimension_Rec.Dimension_Name;
179: END IF;
180: --

Line 182: = FND_API.G_TRUE

178: l_Dimension_Rec.Dimension_Name := p_Dimension_Rec.Dimension_Name;
179: END IF;
180: --
181: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.Description)
182: = FND_API.G_TRUE
183: ) THEN
184: l_Dimension_Rec.Description := p_Dimension_Rec.Description;
185: END IF;
186: --

Line 188: = FND_API.G_TRUE

184: l_Dimension_Rec.Description := p_Dimension_Rec.Description;
185: END IF;
186: --
187: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.Application_ID)
188: = FND_API.G_TRUE
189: ) THEN
190: l_Dimension_Rec.Application_ID := p_Dimension_Rec.Application_ID;
191: END IF;
192: --

Line 194: = FND_API.G_TRUE

190: l_Dimension_Rec.Application_ID := p_Dimension_Rec.Application_ID;
191: END IF;
192: --
193: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.dim_grp_id)
194: = FND_API.G_TRUE
195: ) THEN
196: l_Dimension_Rec.dim_grp_id := p_Dimension_Rec.dim_grp_id;
197: END IF;
198:

Line 200: = FND_API.G_TRUE

196: l_Dimension_Rec.dim_grp_id := p_Dimension_Rec.dim_grp_id;
197: END IF;
198:
199: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.hide)
200: = FND_API.G_TRUE
201: ) THEN
202: l_Dimension_Rec.hide := p_Dimension_Rec.hide;
203: END IF;
204:

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207:
208: --
209: --commented out NOCOPY RAISE
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status:= FND_API.G_RET_STS_ERROR;
213: --RAISE;
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 212: x_return_status:= FND_API.G_RET_STS_ERROR;

208: --
209: --commented out NOCOPY RAISE
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status:= FND_API.G_RET_STS_ERROR;
213: --RAISE;
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
216: --RAISE;

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status:= FND_API.G_RET_STS_ERROR;
213: --RAISE;
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
216: --RAISE;
217: WHEN OTHERS THEN
218: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

211: WHEN FND_API.G_EXC_ERROR THEN
212: x_return_status:= FND_API.G_RET_STS_ERROR;
213: --RAISE;
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
216: --RAISE;
217: WHEN OTHERS THEN
218: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
219: l_error_tbl := x_error_tbl;

Line 218: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
216: --RAISE;
217: WHEN OTHERS THEN
218: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
219: l_error_tbl := x_error_tbl;
220: BIS_UTILITIES_PVT.Add_Error_Message
221: ( p_error_table => l_error_tbl
222: , p_error_msg_id => SQLCODE

Line 226: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: , p_error_msg_id => SQLCODE
223: , p_error_description => SQLERRM
224: , x_error_table => x_error_Tbl
225: );
226: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227:
228: END UpdateRecord;
229: --
230: --

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: from bisbv_dimensions;
251:
252: BEGIN
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: for cr in cr_all_dimensions loop
257: l_Dimension_Rec.dimension_id := cr.dimension_id;
258: l_Dimension_Rec.dimension_short_name := cr.dimension_short_name;

Line 271: x_return_status := FND_API.G_RET_STS_ERROR ;

267:
268: --commented out NOCOPY RAISE
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;

Line 272: --RAISE FND_API.G_EXC_ERROR;

268: --commented out NOCOPY RAISE
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 273: WHEN FND_API.G_EXC_ERROR THEN

269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270: WHEN NO_DATA_FOUND THEN
271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 275: --RAISE FND_API.G_EXC_ERROR;

271: x_return_status := FND_API.G_RET_STS_ERROR ;
272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: --RAISE FND_API.G_EXC_ERROR;
273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: WHEN FND_API.G_EXC_ERROR THEN
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: l_error_tbl := x_error_tbl;

Line 278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: l_error_tbl := x_error_tbl;
282: BIS_UTILITIES_PVT.Add_Error_Message

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: l_error_tbl := x_error_tbl;
282: BIS_UTILITIES_PVT.Add_Error_Message
283: ( p_error_msg_id => SQLCODE
284: , p_error_description => SQLERRM

Line 289: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimensions'
286: , p_error_table => l_error_tbl
287: , x_error_table => x_error_tbl
288: );
289: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290:
291: END Retrieve_Dimensions;
292: --
293:

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: WHERE name=p_Dimension_Rec.dimension_name;
320:
321: begin
322:
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324: x_Dimension_Rec := p_Dimension_Rec;
325:
326: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.dimension_id)
327: = FND_API.G_TRUE

Line 327: = FND_API.G_TRUE

323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324: x_Dimension_Rec := p_Dimension_Rec;
325:
326: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.dimension_id)
327: = FND_API.G_TRUE
328: THEN
329: OPEN cr_dim_id;
330: FETCH cr_dim_id
331: INTO x_Dimension_Rec.dimension_id

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: , x_Dimension_Rec.Application_ID
336: , x_Dimension_Rec.dim_grp_id
337: , x_Dimension_Rec.hide;
338: IF cr_dim_id%ROWCOUNT = 0 THEN
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: END IF;
341: CLOSE cr_dim_id;
342:
343: ELSIF

Line 345: = FND_API.G_TRUE

341: CLOSE cr_dim_id;
342:
343: ELSIF
344: BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.dimension_short_name)
345: = FND_API.G_TRUE
346: THEN
347:
348: OPEN cr_dim_short_name;
349: FETCH cr_dim_short_name

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: , x_Dimension_Rec.Application_ID
355: , x_Dimension_Rec.dim_grp_id
356: , x_Dimension_Rec.hide;
357: IF cr_dim_short_name%ROWCOUNT = 0 THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: END IF;
360: CLOSE cr_dim_short_name;
361:
362: ELSIF

Line 364: = FND_API.G_TRUE

360: CLOSE cr_dim_short_name;
361:
362: ELSIF
363: BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Rec.dimension_name)
364: = FND_API.G_TRUE
365: THEN
366: OPEN cr_dim_name;
367: FETCH cr_dim_short_name
368: INTO x_Dimension_Rec.dimension_id

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372: , x_Dimension_Rec.Application_ID
373: , x_Dimension_Rec.dim_grp_id
374: , x_Dimension_Rec.hide;
375: IF cr_dim_name%ROWCOUNT = 0 THEN
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: END IF;
378: CLOSE cr_dim_name;
379:
380: ELSE

Line 391: RAISE FND_API.G_EXC_ERROR;

387: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
388: , p_error_table => l_error_tbl
389: , x_error_table => x_error_tbl
390: );
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: --added this check
395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: --added this check
395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
396: l_error_tbl := x_error_tbl;
397: BIS_UTILITIES_PVT.Add_Error_Message
398: ( p_error_msg_name => 'BIS_INVALID_DIMENSION__VALUE'
399: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 405: RAISE FND_API.G_EXC_ERROR;

401: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
402: , p_error_table => l_error_tbl
403: , x_error_table => x_error_tbl
404: );
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408:
409: -- commented the RAISE

Line 412: x_return_status := FND_API.G_RET_STS_ERROR ;

408:
409: -- commented the RAISE
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_ERROR ;
413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;

Line 413: --RAISE FND_API.G_EXC_ERROR;

409: -- commented the RAISE
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_ERROR ;
413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 414: WHEN FND_API.G_EXC_ERROR THEN

410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_ERROR ;
413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 415: x_return_status := FND_API.G_RET_STS_ERROR ;

411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_ERROR ;
413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 416: --RAISE FND_API.G_EXC_ERROR;

412: x_return_status := FND_API.G_RET_STS_ERROR ;
413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN OTHERS THEN

Line 417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

413: --RAISE FND_API.G_EXC_ERROR;
414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

414: WHEN FND_API.G_EXC_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: l_error_tbl := x_error_tbl;

Line 419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: --RAISE FND_API.G_EXC_ERROR;
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: l_error_tbl := x_error_tbl;
423: -- added last two parameters

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: l_error_tbl := x_error_tbl;
423: -- added last two parameters
424: BIS_UTILITIES_PVT.Add_Error_Message
425: ( p_error_msg_id => SQLCODE

Line 431: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

427: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension'
428: , p_error_table => l_error_tbl
429: , x_error_table => x_error_tbl
430: );
431: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432:
433: END Retrieve_Dimension;
434: --
435: PROCEDURE Create_Dimension

Line 437: , p_commit IN VARCHAR2 := FND_API.G_FALSE

433: END Retrieve_Dimension;
434: --
435: PROCEDURE Create_Dimension
436: ( p_api_version IN NUMBER
437: , p_commit IN VARCHAR2 := FND_API.G_FALSE
438: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
439: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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

434: --
435: PROCEDURE Create_Dimension
436: ( p_api_version IN NUMBER
437: , p_commit IN VARCHAR2 := FND_API.G_FALSE
438: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
439: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
442: )

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

458:
459: --commented out NOCOPY RAISE
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: l_error_tbl := x_error_tbl;
464: BIS_UTILITIES_PVT.Add_Error_Message (
465: p_error_msg_id => SQLCODE
466: , p_error_description => SQLERRM

Line 471: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

467: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
468: , p_error_table => l_error_tbl
469: , x_error_table => x_error_tbl
470: );
471: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472:
473: END Create_Dimension;
474: --
475: PROCEDURE Create_Dimension

Line 477: , p_commit IN VARCHAR2 := FND_API.G_FALSE

473: END Create_Dimension;
474: --
475: PROCEDURE Create_Dimension
476: ( p_api_version IN NUMBER
477: , p_commit IN VARCHAR2 := FND_API.G_FALSE
478: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
479: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
480: , p_owner IN VARCHAR2
481: , x_return_status OUT NOCOPY VARCHAR2

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

474: --
475: PROCEDURE Create_Dimension
476: ( p_api_version IN NUMBER
477: , p_commit IN VARCHAR2 := FND_API.G_FALSE
478: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
479: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
480: , p_owner IN VARCHAR2
481: , x_return_status OUT NOCOPY VARCHAR2
482: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);
493:
494: BEGIN
495:
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: l_Dimension_Rec := p_dimension_Rec;
498:
499: SetNULL
500: ( p_dimension_Rec => p_dimension_Rec

Line 511: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

507: , x_return_status
508: , x_error_Tbl
509: );
510:
511: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
512: l_error_tbl := x_error_tbl;
513: BIS_UTILITIES_PVT.Add_Error_Message
514: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
515: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 521: RAISE FND_API.G_EXC_ERROR;

517: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
518: , p_error_table => l_error_tbl
519: , x_error_table => x_error_tbl
520: );
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: --
525: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.

Line 562: IF (p_commit = FND_API.G_TRUE) THEN

558: , p_description => l_Dimension_Rec.Description
559: , p_last_update_date => l_Dimension_Rec.Last_Update_Date
560: );
561:
562: IF (p_commit = FND_API.G_TRUE) THEN
563: COMMIT;
564: END if;
565:
566: EXCEPTION

Line 568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

564: END if;
565:
566: EXCEPTION
567: WHEN DUPLICATE_DIMENSION_VALUE THEN
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: l_error_tbl := x_error_tbl;
570: BIS_UTILITIES_PVT.Add_Error_Message
571: ( p_error_msg_name => 'BIS_DIMENSION_UNIQUENESS_ERROR'
572: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 580: x_return_status := FND_API.G_RET_STS_ERROR ;

576: , x_error_table => x_error_tbl
577: );
578:
579: WHEN NO_DATA_FOUND THEN
580: x_return_status := FND_API.G_RET_STS_ERROR ;
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:

Line 582: WHEN FND_API.G_EXC_ERROR THEN

578:
579: WHEN NO_DATA_FOUND THEN
580: x_return_status := FND_API.G_RET_STS_ERROR ;
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 583: x_return_status := FND_API.G_RET_STS_ERROR ;

579: WHEN NO_DATA_FOUND THEN
580: x_return_status := FND_API.G_RET_STS_ERROR ;
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587:

Line 585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587:
588: WHEN OTHERS THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

582: WHEN FND_API.G_EXC_ERROR THEN
583: x_return_status := FND_API.G_RET_STS_ERROR ;
584:
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587:
588: WHEN OTHERS THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: l_error_tbl := x_error_tbl;

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587:
588: WHEN OTHERS THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: l_error_tbl := x_error_tbl;
591: BIS_UTILITIES_PVT.Add_Error_Message
592: ( p_error_msg_id => SQLCODE
593: , p_error_description => SQLERRM

Line 609: p_hide IN VARCHAR2 := FND_API.G_FALSE,

605: ( p_dimension_id IN NUMBER, -- l_id
606: p_dimension_short_name IN VARCHAR2, -- l_Dimension_Rec.Dimension_Short_Name
607: p_application_id IN NUMBER := NULL,
608: p_dim_grp_id IN NUMBER,
609: p_hide IN VARCHAR2 := FND_API.G_FALSE,
610: p_created_by IN NUMBER, -- created_by
611: p_last_updated_by IN NUMBER, -- last_updated_by
612: p_login_id IN NUMBER, -- l_login_id
613: p_dimension_name IN VARCHAR2, -- l_Dimension_Rec.Dimension_Name

Line 712: , p_commit IN VARCHAR2 := FND_API.G_FALSE

708: --
709:
710: PROCEDURE Update_Dimension
711: ( p_api_version IN NUMBER
712: , p_commit IN VARCHAR2 := FND_API.G_FALSE
713: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
714: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
715: , x_return_status OUT NOCOPY VARCHAR2
716: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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

709:
710: PROCEDURE Update_Dimension
711: ( p_api_version IN NUMBER
712: , p_commit IN VARCHAR2 := FND_API.G_FALSE
713: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
714: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
715: , x_return_status OUT NOCOPY VARCHAR2
716: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
717: )

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

734:
735: --commented out NOCOPY RAISE
736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: --added last two parameters
740: l_error_tbl := x_error_tbl;
741: BIS_UTILITIES_PVT.Add_Error_Message
742: ( p_error_msg_id => SQLCODE

Line 748: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
745: , p_error_table => l_error_tbl
746: , x_error_table => x_error_tbl
747: );
748: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749:
750: END Update_Dimension;
751: --
752: PROCEDURE Update_Dimension

Line 754: , p_commit IN VARCHAR2 := FND_API.G_FALSE

750: END Update_Dimension;
751: --
752: PROCEDURE Update_Dimension
753: ( p_api_version IN NUMBER
754: , p_commit IN VARCHAR2 := FND_API.G_FALSE
755: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
756: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
757: , p_owner IN VARCHAR2
758: , x_return_status OUT NOCOPY VARCHAR2

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

751: --
752: PROCEDURE Update_Dimension
753: ( p_api_version IN NUMBER
754: , p_commit IN VARCHAR2 := FND_API.G_FALSE
755: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
756: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
757: , p_owner IN VARCHAR2
758: , x_return_status OUT NOCOPY VARCHAR2
759: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 791: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

787: , x_error_Tbl
788: );
789:
790: --added Add_Error_Message
791: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
792: l_error_tbl := x_error_tbl;
793: BIS_UTILITIES_PVT.Add_Error_Message
794: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_ID'
795: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 801: RAISE FND_API.G_EXC_ERROR;

797: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
798: , p_error_table => l_error_tbl
799: , x_error_table => x_error_tbl
800: );
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: --
804: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
805: l_login_id := fnd_global.LOGIN_ID;

Line 821: IF (p_commit = FND_API.G_TRUE) THEN

817: , LAST_UPDATED_BY = l_user_id
818: , LAST_UPDATE_LOGIN = l_login_id
819: where dimension_ID = l_Dimension_Rec.Dimension_Id;
820:
821: IF (p_commit = FND_API.G_TRUE) THEN
822: COMMIT;
823: END if;
824:
825: Translate_dimension

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

834:
835: --commented out NOCOPY RAISE
836: EXCEPTION
837: WHEN DUPLICATE_DIMENSION_VALUE THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839: l_error_tbl := x_error_tbl;
840: BIS_UTILITIES_PVT.Add_Error_Message
841: ( p_error_msg_name => 'BIS_DIMENSION_UNIQUENESS_ERROR'
842: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 849: x_return_status := FND_API.G_RET_STS_ERROR ;

845: , p_error_table => l_error_tbl
846: , x_error_table => x_error_tbl
847: );
848: WHEN NO_DATA_FOUND THEN
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;

Line 850: --RAISE FND_API.G_EXC_ERROR;

846: , x_error_table => x_error_tbl
847: );
848: WHEN NO_DATA_FOUND THEN
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 851: WHEN FND_API.G_EXC_ERROR THEN

847: );
848: WHEN NO_DATA_FOUND THEN
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 852: x_return_status := FND_API.G_RET_STS_ERROR ;

848: WHEN NO_DATA_FOUND THEN
849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 853: --RAISE FND_API.G_EXC_ERROR;

849: x_return_status := FND_API.G_RET_STS_ERROR ;
850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN

Line 854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

850: --RAISE FND_API.G_EXC_ERROR;
851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

851: WHEN FND_API.G_EXC_ERROR THEN
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: l_error_tbl := x_error_tbl;

Line 856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: --RAISE FND_API.G_EXC_ERROR;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: l_error_tbl := x_error_tbl;
860: BIS_UTILITIES_PVT.Add_Error_Message

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: l_error_tbl := x_error_tbl;
860: BIS_UTILITIES_PVT.Add_Error_Message
861: ( p_error_msg_id => SQLCODE
862: , p_error_description => SQLERRM

Line 867: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

863: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
864: , p_error_table => l_error_tbl
865: , x_error_table => x_error_tbl
866: );
867: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
868:
869: END Update_Dimension;
870: --
871: --

Line 874: , p_commit IN VARCHAR2 := FND_API.G_FALSE

870: --
871: --
872: PROCEDURE Translate_Dimension
873: ( p_api_version IN NUMBER
874: , p_commit IN VARCHAR2 := FND_API.G_FALSE
875: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
876: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
877: , x_return_status OUT NOCOPY VARCHAR2
878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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

871: --
872: PROCEDURE Translate_Dimension
873: ( p_api_version IN NUMBER
874: , p_commit IN VARCHAR2 := FND_API.G_FALSE
875: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
876: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
877: , x_return_status OUT NOCOPY VARCHAR2
878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
879: )

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

896:
897: --commented out NOCOPY RAISE
898: EXCEPTION
899: WHEN OTHERS THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: l_error_tbl := x_error_tbl;
902: BIS_UTILITIES_PVT.Add_Error_Message
903: ( p_error_msg_id => SQLCODE
904: , p_error_description => SQLERRM

Line 910: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906: , p_error_table => l_error_tbl
907: , x_error_table => x_error_tbl
908: );
909:
910: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911:
912: END Translate_Dimension;
913: --
914: PROCEDURE Translate_Dimension

Line 916: , p_commit IN VARCHAR2 := FND_API.G_FALSE

912: END Translate_Dimension;
913: --
914: PROCEDURE Translate_Dimension
915: ( p_api_version IN NUMBER
916: , p_commit IN VARCHAR2 := FND_API.G_FALSE
917: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
918: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
919: , p_owner IN VARCHAR2
920: , x_return_status OUT NOCOPY VARCHAR2

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

913: --
914: PROCEDURE Translate_Dimension
915: ( p_api_version IN NUMBER
916: , p_commit IN VARCHAR2 := FND_API.G_FALSE
917: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
918: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
919: , p_owner IN VARCHAR2
920: , x_return_status OUT NOCOPY VARCHAR2
921: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 948: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

944: , x_return_status
945: , x_error_Tbl
946: );
947:
948: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951: --
952: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

Line 949: RAISE FND_API.G_EXC_ERROR;

945: , x_error_Tbl
946: );
947:
948: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951: --
952: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
953: l_login_id := fnd_global.LOGIN_ID;

Line 969: IF (p_commit = FND_API.G_TRUE) THEN

965: , SOURCE_LANG = userenv('LANG')
966: where DIMENSION_ID = l_Dimension_Rec.Dimension_Id
967: and userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
968:
969: IF (p_commit = FND_API.G_TRUE) THEN
970: COMMIT;
971: END if;
972:
973: --commented out NOCOPY RAISE

Line 976: x_return_status := FND_API.G_RET_STS_ERROR ;

972:
973: --commented out NOCOPY RAISE
974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: x_return_status := FND_API.G_RET_STS_ERROR ;
977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;

Line 977: --RAISE FND_API.G_EXC_ERROR;

973: --commented out NOCOPY RAISE
974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: x_return_status := FND_API.G_RET_STS_ERROR ;
977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 978: WHEN FND_API.G_EXC_ERROR THEN

974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: x_return_status := FND_API.G_RET_STS_ERROR ;
977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 979: x_return_status := FND_API.G_RET_STS_ERROR ;

975: WHEN NO_DATA_FOUND THEN
976: x_return_status := FND_API.G_RET_STS_ERROR ;
977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 980: --RAISE FND_API.G_EXC_ERROR;

976: x_return_status := FND_API.G_RET_STS_ERROR ;
977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN

Line 981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

977: --RAISE FND_API.G_EXC_ERROR;
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986: l_error_tbl := x_error_tbl;

Line 983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

979: x_return_status := FND_API.G_RET_STS_ERROR ;
980: --RAISE FND_API.G_EXC_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986: l_error_tbl := x_error_tbl;
987: BIS_UTILITIES_PVT.Add_Error_Message

Line 985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986: l_error_tbl := x_error_tbl;
987: BIS_UTILITIES_PVT.Add_Error_Message
988: ( p_error_msg_id => SQLCODE
989: , p_error_description => SQLERRM

Line 994: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension'
991: , p_error_table => l_error_tbl
992: , x_error_table => x_error_tbl
993: );
994: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995:
996: END Translate_Dimension;
997: --
998: --

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

997: --
998: --
999: PROCEDURE Validate_Dimension
1000: ( p_api_version IN NUMBER
1001: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1002: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1003: , x_return_status OUT NOCOPY VARCHAR2
1004: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1005: )

Line 1022: WHEN FND_API.G_EXC_ERROR THEN

1018: , x_error_tbl => l_error_Tbl
1019: );
1020:
1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: l_error_tbl_p := x_error_tbl;
1024: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p
1025: , l_error_Tbl
1026: , x_error_tbl

Line 1028: x_return_status := FND_API.G_RET_STS_ERROR;

1024: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p
1025: , l_error_Tbl
1026: , x_error_tbl
1027: );
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: END;
1030:
1031: IF (x_error_tbl.count > 0) THEN
1032: RAISE FND_API.G_EXC_ERROR;

Line 1032: RAISE FND_API.G_EXC_ERROR;

1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: END;
1030:
1031: IF (x_error_tbl.count > 0) THEN
1032: RAISE FND_API.G_EXC_ERROR;
1033: END if;
1034:
1035: --commented out NOCOPY RAISE
1036: EXCEPTION

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR ;

1034:
1035: --commented out NOCOPY RAISE
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR ;
1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;

Line 1039: --RAISE FND_API.G_EXC_ERROR;

1035: --commented out NOCOPY RAISE
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR ;
1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1040: WHEN FND_API.G_EXC_ERROR THEN

1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR ;
1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR ;

1037: WHEN NO_DATA_FOUND THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR ;
1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1042: --RAISE FND_API.G_EXC_ERROR;

1038: x_return_status := FND_API.G_RET_STS_ERROR ;
1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN

Line 1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1039: --RAISE FND_API.G_EXC_ERROR;
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1040: WHEN FND_API.G_EXC_ERROR THEN
1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: l_error_tbl_p := x_error_tbl;

Line 1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1041: x_return_status := FND_API.G_RET_STS_ERROR ;
1042: --RAISE FND_API.G_EXC_ERROR;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: l_error_tbl_p := x_error_tbl;
1049: BIS_UTILITIES_PVT.Add_Error_Message

Line 1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: l_error_tbl_p := x_error_tbl;
1049: BIS_UTILITIES_PVT.Add_Error_Message
1050: ( p_error_msg_id => SQLCODE
1051: , p_error_description => SQLERRM

Line 1056: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1052: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension'
1053: , p_error_table => l_error_tbl_p
1054: , x_error_table => x_error_tbl
1055: );
1056: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057:
1058: END Validate_Dimension;
1059: --
1060: -- Value - ID conversion

Line 1071: x_return_status := FND_API.G_RET_STS_SUCCESS;

1067: )
1068: IS
1069: BEGIN
1070:
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072: x_Dimension_Rec := p_Dimension_Rec;
1073:
1074: IF (BIS_UTILITIES_PUB.Value_Missing(x_Dimension_Rec.Dimension_id)
1075: = FND_API.G_TRUE) THEN

Line 1075: = FND_API.G_TRUE) THEN

1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072: x_Dimension_Rec := p_Dimension_Rec;
1073:
1074: IF (BIS_UTILITIES_PUB.Value_Missing(x_Dimension_Rec.Dimension_id)
1075: = FND_API.G_TRUE) THEN
1076: BIS_DIMENSION_PVT.Value_ID_Conversion
1077: ( p_api_version
1078: , x_Dimension_Rec.Dimension_Short_Name
1079: , x_Dimension_Rec.Dimension_Name

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR ;

1085:
1086: --comment out NOCOPY RAISE
1087: EXCEPTION
1088: WHEN NO_DATA_FOUND THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR ;
1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;

Line 1090: --RAISE FND_API.G_EXC_ERROR;

1086: --comment out NOCOPY RAISE
1087: EXCEPTION
1088: WHEN NO_DATA_FOUND THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR ;
1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1091: WHEN FND_API.G_EXC_ERROR THEN

1087: EXCEPTION
1088: WHEN NO_DATA_FOUND THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR ;
1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1092: x_return_status := FND_API.G_RET_STS_ERROR ;

1088: WHEN NO_DATA_FOUND THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR ;
1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1093: --RAISE FND_API.G_EXC_ERROR;

1089: x_return_status := FND_API.G_RET_STS_ERROR ;
1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: WHEN OTHERS THEN

Line 1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1090: --RAISE FND_API.G_EXC_ERROR;
1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: WHEN OTHERS THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1091: WHEN FND_API.G_EXC_ERROR THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: WHEN OTHERS THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: BIS_UTILITIES_PVT.Add_Error_Message

Line 1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: x_return_status := FND_API.G_RET_STS_ERROR ;
1093: --RAISE FND_API.G_EXC_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: WHEN OTHERS THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: BIS_UTILITIES_PVT.Add_Error_Message
1100: ( p_error_msg_id => SQLCODE

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: WHEN OTHERS THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1099: BIS_UTILITIES_PVT.Add_Error_Message
1100: ( p_error_msg_id => SQLCODE
1101: , p_error_description => SQLERRM
1102: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'

Line 1104: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100: ( p_error_msg_id => SQLCODE
1101: , p_error_description => SQLERRM
1102: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1103: );
1104: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105:
1106: END Value_ID_Conversion;
1107: --
1108: PROCEDURE Value_ID_Conversion

Line 1120: x_return_status := FND_API.G_RET_STS_SUCCESS;

1116: is
1117: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1118: begin
1119:
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121:
1122: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Short_Name)
1123: = FND_API.G_TRUE) THEN
1124: SELECT dimension_id INTO x_Dimension_ID

Line 1123: = FND_API.G_TRUE) THEN

1119:
1120: x_return_status := FND_API.G_RET_STS_SUCCESS;
1121:
1122: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Short_Name)
1123: = FND_API.G_TRUE) THEN
1124: SELECT dimension_id INTO x_Dimension_ID
1125: FROM bis_dimensions_vl
1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)

Line 1128: = FND_API.G_TRUE) THEN

1124: SELECT dimension_id INTO x_Dimension_ID
1125: FROM bis_dimensions_vl
1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)
1128: = FND_API.G_TRUE) THEN
1129: SELECT dimension_id INTO x_Dimension_ID
1130: FROM bis_dimensions_vl
1131: WHERE name = p_Dimension_Name;
1132: else

Line 1143: RAISE FND_API.G_EXC_ERROR;

1139: , p_error_table => l_error_tbl
1140: , x_error_table => x_error_tbl
1141: );
1142:
1143: RAISE FND_API.G_EXC_ERROR;
1144: END if;
1145:
1146:
1147: EXCEPTION

Line 1149: x_return_status := FND_API.G_RET_STS_ERROR ;

1145:
1146:
1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1150: WHEN FND_API.G_EXC_ERROR THEN

1146:
1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR ;

1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1148: WHEN NO_DATA_FOUND THEN
1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: l_error_tbl := x_error_tbl;

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1149: x_return_status := FND_API.G_RET_STS_ERROR ;
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: l_error_tbl := x_error_tbl;
1157: BIS_UTILITIES_PVT.Add_Error_Message

Line 1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1151: x_return_status := FND_API.G_RET_STS_ERROR ;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: l_error_tbl := x_error_tbl;
1157: BIS_UTILITIES_PVT.Add_Error_Message
1158: ( p_error_msg_id => SQLCODE
1159: , p_error_description => SQLERRM

Line 1183: RAISE FND_API.G_EXC_ERROR;

1179: return FALSE;
1180:
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1184: WHEN FND_API.G_EXC_ERROR THEN

1180:
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: WHEN OTHERS THEN

Line 1185: RAISE FND_API.G_EXC_ERROR;

1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: WHEN OTHERS THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1182: WHEN NO_DATA_FOUND THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: WHEN OTHERS THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190:

Line 1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1183: RAISE FND_API.G_EXC_ERROR;
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: WHEN OTHERS THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190:
1191: END DuplicateDimension;

Line 1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1185: RAISE FND_API.G_EXC_ERROR;
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1188: WHEN OTHERS THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190:
1191: END DuplicateDimension;
1192: --
1193: PROCEDURE RemoveDuplicates

Line 1225: p_commit IN VARCHAR2 := FND_API.G_FALSE

1221: --
1222:
1223: PROCEDURE Delete_Dimension
1224: (
1225: p_commit IN VARCHAR2 := FND_API.G_FALSE
1226: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1227: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1228: , x_return_status OUT NOCOPY VARCHAR2
1229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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

1222:
1223: PROCEDURE Delete_Dimension
1224: (
1225: p_commit IN VARCHAR2 := FND_API.G_FALSE
1226: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1227: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1228: , x_return_status OUT NOCOPY VARCHAR2
1229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1230: ) IS

Line 1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1239: , x_Dimension_Rec => l_Dimension_Rec
1240: , x_return_status => x_return_status
1241: , x_error_Tbl => x_error_Tbl
1242: );
1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: DELETE FROM bis_dimensions WHERE

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: , x_return_status => x_return_status
1241: , x_error_Tbl => x_error_Tbl
1242: );
1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: DELETE FROM bis_dimensions WHERE
1248: DIMENSION_ID = l_Dimension_Rec.dimension_id;

Line 1252: IF (p_commit = FND_API.G_TRUE) THEN

1248: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1249:
1250: DELETE FROM bis_dimensions_tl WHERE
1251: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1252: IF (p_commit = FND_API.G_TRUE) THEN
1253: COMMIT;
1254: END if;
1255: x_return_status := FND_API.G_RET_STS_SUCCESS;
1256: EXCEPTION

Line 1255: x_return_status := FND_API.G_RET_STS_SUCCESS;

1251: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1252: IF (p_commit = FND_API.G_TRUE) THEN
1253: COMMIT;
1254: END if;
1255: x_return_status := FND_API.G_RET_STS_SUCCESS;
1256: EXCEPTION
1257: WHEN NO_DATA_FOUND THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR ;
1259: ROLLBACK TO DeleteFromBISDims;

Line 1258: x_return_status := FND_API.G_RET_STS_ERROR ;

1254: END if;
1255: x_return_status := FND_API.G_RET_STS_SUCCESS;
1256: EXCEPTION
1257: WHEN NO_DATA_FOUND THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR ;
1259: ROLLBACK TO DeleteFromBISDims;
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: ROLLBACK TO DeleteFromBISDims;

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256: EXCEPTION
1257: WHEN NO_DATA_FOUND THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR ;
1259: ROLLBACK TO DeleteFromBISDims;
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: ROLLBACK TO DeleteFromBISDims;
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1261: x_return_status := FND_API.G_RET_STS_ERROR ;

1257: WHEN NO_DATA_FOUND THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR ;
1259: ROLLBACK TO DeleteFromBISDims;
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: ROLLBACK TO DeleteFromBISDims;
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: ROLLBACK TO DeleteFromBISDims;

Line 1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1259: ROLLBACK TO DeleteFromBISDims;
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: ROLLBACK TO DeleteFromBISDims;
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: ROLLBACK TO DeleteFromBISDims;
1266: WHEN OTHERS THEN
1267: l_error_tbl := x_error_tbl;

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1260: WHEN FND_API.G_EXC_ERROR THEN
1261: x_return_status := FND_API.G_RET_STS_ERROR ;
1262: ROLLBACK TO DeleteFromBISDims;
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: ROLLBACK TO DeleteFromBISDims;
1266: WHEN OTHERS THEN
1267: l_error_tbl := x_error_tbl;
1268: BIS_UTILITIES_PVT.Add_Error_Message

Line 1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1271: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension'
1272: , p_error_table => l_error_tbl
1273: , x_error_table => x_error_tbl
1274: );
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1276: ROLLBACK TO DeleteFromBISDims;
1277: END Delete_Dimension;
1278: --
1279:

Line 1282: p_commit IN VARCHAR2 := FND_API.G_FALSE

1278: --
1279:
1280: PROCEDURE Translate_Dim_By_Given_Lang
1281: (
1282: p_commit IN VARCHAR2 := FND_API.G_FALSE
1283: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1284: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1285: , x_return_status OUT NOCOPY VARCHAR2
1286: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

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

1279:
1280: PROCEDURE Translate_Dim_By_Given_Lang
1281: (
1282: p_commit IN VARCHAR2 := FND_API.G_FALSE
1283: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1284: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1285: , x_return_status OUT NOCOPY VARCHAR2
1286: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1287: ) IS

Line 1315: IF (p_commit = FND_API.G_TRUE) THEN

1311: ,SOURCE_LANG = p_Dimension_Rec.Source_Lang
1312: WHERE DIMENSION_ID = l_dim_id
1313: AND LANGUAGE = p_Dimension_Rec.Language;
1314:
1315: IF (p_commit = FND_API.G_TRUE) THEN
1316: COMMIT;
1317: END if;
1318: x_return_status := FND_API.G_RET_STS_SUCCESS;
1319:

Line 1318: x_return_status := FND_API.G_RET_STS_SUCCESS;

1314:
1315: IF (p_commit = FND_API.G_TRUE) THEN
1316: COMMIT;
1317: END if;
1318: x_return_status := FND_API.G_RET_STS_SUCCESS;
1319:
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1322: x_return_status := FND_API.G_RET_STS_ERROR ;

1318: x_return_status := FND_API.G_RET_STS_SUCCESS;
1319:
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: ROLLBACK TO TransDimByLangPvt;
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: ROLLBACK TO TransDimByLangPvt;

Line 1324: WHEN FND_API.G_EXC_ERROR THEN

1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: ROLLBACK TO TransDimByLangPvt;
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: ROLLBACK TO TransDimByLangPvt;
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1325: x_return_status := FND_API.G_RET_STS_ERROR ;

1321: WHEN NO_DATA_FOUND THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: ROLLBACK TO TransDimByLangPvt;
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: ROLLBACK TO TransDimByLangPvt;
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: ROLLBACK TO TransDimByLangPvt;

Line 1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1323: ROLLBACK TO TransDimByLangPvt;
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: ROLLBACK TO TransDimByLangPvt;
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: ROLLBACK TO TransDimByLangPvt;
1330: WHEN OTHERS THEN
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: ROLLBACK TO TransDimByLangPvt;
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: ROLLBACK TO TransDimByLangPvt;
1330: WHEN OTHERS THEN
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1332: l_error_tbl := x_error_tbl;

Line 1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: ROLLBACK TO TransDimByLangPvt;
1330: WHEN OTHERS THEN
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1332: l_error_tbl := x_error_tbl;
1333: BIS_UTILITIES_PVT.Add_Error_Message
1334: ( p_error_msg_id => SQLCODE
1335: , p_error_description => SQLERRM

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR;

1368:
1369: IF (l_count <> 0) THEN
1370: FOR l_unique_name_rec IN c_unique_name LOOP
1371: IF (l_unique_name_rec.type = 'PMF') THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: ELSE
1374: Rename_BSC_Dimension(l_unique_name_rec.Short_Name, l_unique_name_rec.Name);
1375: END IF;
1376: END LOOP;