APPS.BIS_APPLICATION_MEASURE_PVT dependencies on FND_API

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

36: --
37: --
38: PROCEDURE Create_Application_Measure
39: ( p_api_version IN NUMBER
40: , p_commit IN VARCHAR2 := FND_API.G_FALSE
41: , p_Application_Measure_Rec IN
42: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
43: , x_return_status OUT NOCOPY VARCHAR2
44: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

58:
59: --commented RAISE
60: EXCEPTION
61: when others then
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
63: --added last two params
64: l_error_tbl := x_error_Tbl;
65: BIS_UTILITIES_PVT.Add_Error_Message
66: ( p_error_msg_id => SQLCODE

Line 72: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68: , p_error_proc_name => G_PKG_NAME||'.Create_Application_Measure'
69: , p_error_table => l_error_tbl
70: , x_error_table => x_error_tbl
71: );
72: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73:
74: END Create_Application_Measure;
75: --
76: --

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

75: --
76: --
77: PROCEDURE Create_Application_Measure
78: ( p_api_version IN NUMBER
79: , p_commit IN VARCHAR2 := FND_API.G_FALSE
80: , p_Application_Measure_Rec IN
81: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
82: , p_owner IN VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: SELECT count(1) FROM BIS_APPLICATION_MEASURES
96: WHERE indicator_id = cp_ind_id;
97: l_count NUMBER := 0;
98: BEGIN
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: l_rec := p_Application_Measure_Rec;
101:
102: l_rec_p := l_rec;
103: BIS_Application_Measure_PVT.Value_ID_Conversion

Line 128: RAISE FND_API.G_EXC_ERROR ;

124: FETCH c_app_meas INTO l_count;
125: CLOSE c_app_meas;
126:
127: IF (l_count > 0) THEN
128: RAISE FND_API.G_EXC_ERROR ;
129: END IF;
130:
131: IF ( l_Rec.APPLICATION_ID <> -1 ) THEN
132: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;

Line 132: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;

128: RAISE FND_API.G_EXC_ERROR ;
129: END IF;
130:
131: IF ( l_Rec.APPLICATION_ID <> -1 ) THEN
132: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;
133: ELSE
134: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;
135: END IF;
136:

Line 134: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;

130:
131: IF ( l_Rec.APPLICATION_ID <> -1 ) THEN
132: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;
133: ELSE
134: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;
135: END IF;
136:
137: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.
138: -- Last_Updated_By can be different from Created_By while creating measures

Line 179: if (p_commit = FND_API.G_TRUE) then

175: , l_Rec.Last_Updated_By
176: , l_Rec.Last_Update_Login
177: );
178:
179: if (p_commit = FND_API.G_TRUE) then
180: COMMIT;
181: end if;
182:
183: --commented RAISE

Line 186: x_return_status := FND_API.G_RET_STS_ERROR ;

182:
183: --commented RAISE
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: --RAISE FND_API.G_EXC_ERROR;
188: IF (c_app_meas%ISOPEN) THEN
189: CLOSE c_app_meas;
190: END IF;

Line 187: --RAISE FND_API.G_EXC_ERROR;

183: --commented RAISE
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: x_return_status := FND_API.G_RET_STS_ERROR ;
187: --RAISE FND_API.G_EXC_ERROR;
188: IF (c_app_meas%ISOPEN) THEN
189: CLOSE c_app_meas;
190: END IF;
191: when FND_API.G_EXC_ERROR then

Line 191: when FND_API.G_EXC_ERROR then

187: --RAISE FND_API.G_EXC_ERROR;
188: IF (c_app_meas%ISOPEN) THEN
189: CLOSE c_app_meas;
190: END IF;
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: --RAISE FND_API.G_EXC_ERROR;
194: IF (c_app_meas%ISOPEN) THEN
195: CLOSE c_app_meas;

Line 192: x_return_status := FND_API.G_RET_STS_ERROR ;

188: IF (c_app_meas%ISOPEN) THEN
189: CLOSE c_app_meas;
190: END IF;
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: --RAISE FND_API.G_EXC_ERROR;
194: IF (c_app_meas%ISOPEN) THEN
195: CLOSE c_app_meas;
196: END IF;

Line 193: --RAISE FND_API.G_EXC_ERROR;

189: CLOSE c_app_meas;
190: END IF;
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: --RAISE FND_API.G_EXC_ERROR;
194: IF (c_app_meas%ISOPEN) THEN
195: CLOSE c_app_meas;
196: END IF;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 197: when FND_API.G_EXC_UNEXPECTED_ERROR then

193: --RAISE FND_API.G_EXC_ERROR;
194: IF (c_app_meas%ISOPEN) THEN
195: CLOSE c_app_meas;
196: END IF;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: IF (c_app_meas%ISOPEN) THEN
201: CLOSE c_app_meas;

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

194: IF (c_app_meas%ISOPEN) THEN
195: CLOSE c_app_meas;
196: END IF;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: IF (c_app_meas%ISOPEN) THEN
201: CLOSE c_app_meas;
202: END IF;

Line 199: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: CLOSE c_app_meas;
196: END IF;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: IF (c_app_meas%ISOPEN) THEN
201: CLOSE c_app_meas;
202: END IF;
203: when others then

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: IF (c_app_meas%ISOPEN) THEN
201: CLOSE c_app_meas;
202: END IF;
203: when others then
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: l_error_tbl := x_error_Tbl;
206: IF (c_app_meas%ISOPEN) THEN
207: CLOSE c_app_meas;
208: END IF;

Line 216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: , p_error_proc_name => G_PKG_NAME||'.Create_Application_Measure'
213: , p_error_table => l_error_tbl
214: , x_error_table => x_error_tbl
215: );
216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217:
218: end Create_Application_Measure;
219: --
220: --

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255: l_flag number := 0;
256: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
257:
258: BEGIN
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: if (p_all_info = FND_API.G_FALSE) then
262: for cr in basic_info_cursor LOOP
263: l_flag := 1;

Line 261: if (p_all_info = FND_API.G_FALSE) then

257:
258: BEGIN
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: if (p_all_info = FND_API.G_FALSE) then
262: for cr in basic_info_cursor LOOP
263: l_flag := 1;
264: l_rec.Measure_id := cr.Measure_id;
265: l_rec.MEASURE_SHORT_NAME := cr.MEASURE_SHORT_NAME;

Line 303: RAISE FND_API.G_EXC_ERROR;

299: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
300: , p_error_table => l_error_tbl
301: , x_error_table => x_error_tbl
302: );
303: RAISE FND_API.G_EXC_ERROR;
304: end if;
305:
306: --commented RAISE
307: EXCEPTION

Line 309: x_return_status := FND_API.G_RET_STS_ERROR ;

305:
306: --commented RAISE
307: EXCEPTION
308: WHEN NO_DATA_FOUND THEN
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
311: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
312: --RAISE FND_API.G_EXC_ERROR;
313: when FND_API.G_EXC_ERROR then

Line 312: --RAISE FND_API.G_EXC_ERROR;

308: WHEN NO_DATA_FOUND THEN
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
311: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
312: --RAISE FND_API.G_EXC_ERROR;
313: when FND_API.G_EXC_ERROR then
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;

Line 313: when FND_API.G_EXC_ERROR then

309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
311: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
312: --RAISE FND_API.G_EXC_ERROR;
313: when FND_API.G_EXC_ERROR then
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
317: -- RAISE FND_API.G_EXC_ERROR;

Line 314: x_return_status := FND_API.G_RET_STS_ERROR ;

310: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
311: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
312: --RAISE FND_API.G_EXC_ERROR;
313: when FND_API.G_EXC_ERROR then
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
317: -- RAISE FND_API.G_EXC_ERROR;
318: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 317: -- RAISE FND_API.G_EXC_ERROR;

313: when FND_API.G_EXC_ERROR then
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
317: -- RAISE FND_API.G_EXC_ERROR;
318: when FND_API.G_EXC_UNEXPECTED_ERROR then
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
321: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;

Line 318: when FND_API.G_EXC_UNEXPECTED_ERROR then

314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
317: -- RAISE FND_API.G_EXC_ERROR;
318: when FND_API.G_EXC_UNEXPECTED_ERROR then
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
321: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
322: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

315: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
316: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
317: -- RAISE FND_API.G_EXC_ERROR;
318: when FND_API.G_EXC_UNEXPECTED_ERROR then
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
321: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
322: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: when others then

Line 322: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: when FND_API.G_EXC_UNEXPECTED_ERROR then
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
321: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
322: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: when others then
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
326: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;

Line 324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

320: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
321: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
322: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: when others then
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF basic_info_cursor%ISOPEN THEN CLOSE basic_info_cursor; END IF;
326: IF all_info_cursor%ISOPEN THEN CLOSE all_info_cursor; END IF;
327: l_error_tbl := x_error_Tbl;
328: BIS_UTILITIES_PVT.Add_Error_Message

Line 335: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Application_Measures'
332: , p_error_table => l_error_tbl
333: , x_error_table => x_error_tbl
334: );
335: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336:
337: end Retrieve_Application_Measures;
338: --
339: --

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

338: --
339: --
340: PROCEDURE Update_Application_Measure
341: ( p_api_version IN NUMBER
342: , p_commit IN VARCHAR2 := FND_API.G_FALSE
343: , p_Application_Measure_Rec IN
344: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
345: , x_return_status OUT NOCOPY VARCHAR2
346: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

360:
361: --commented RAISE
362: EXCEPTION
363: when others then
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: --added last two params
366: l_error_tbl := x_error_Tbl;
367: BIS_UTILITIES_PVT.Add_Error_Message
368: ( p_error_msg_id => SQLCODE

Line 374: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
371: , p_error_table => l_error_tbl
372: , x_error_table => x_error_tbl
373: );
374: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375:
376: END Update_Application_Measure;
377: --
378: --

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

377: --
378: --
379: PROCEDURE Update_Application_Measure
380: ( p_api_version IN NUMBER
381: , p_commit IN VARCHAR2 := FND_API.G_FALSE
382: , p_Application_Measure_Rec IN
383: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
384: , p_owner IN VARCHAR2
385: , x_return_status OUT NOCOPY VARCHAR2

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
394: l_count number;
395: BEGIN
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: l_rec := p_Application_Measure_Rec;
399:
400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE
401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE

Line 400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE

396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: l_rec := p_Application_Measure_Rec;
399:
400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE
401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE
402: ) then
403: --added last two params
404: l_error_tbl := x_error_Tbl;

Line 401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE

397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398: l_rec := p_Application_Measure_Rec;
399:
400: if ( BIS_UTILITIES_PUB.Value_Missing(l_Rec.Owning_Application)=FND_API.G_TRUE
401: OR BIS_UTILITIES_PUB.Value_NULL(l_Rec.Owning_Application)=FND_API.G_TRUE
402: ) then
403: --added last two params
404: l_error_tbl := x_error_Tbl;
405: BIS_UTILITIES_PVT.Add_Error_Message

Line 413: RAISE FND_API.G_EXC_ERROR;

409: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
410: , p_error_table => l_error_tbl
411: , x_error_table => x_error_tbl
412: );
413: RAISE FND_API.G_EXC_ERROR;
414: end if;
415: l_rec_p := l_rec;
416: BIS_Application_Measure_PVT.Value_ID_Conversion
417: ( p_api_version

Line 454: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;

450: );
451: else
452:
453: IF ( l_Rec.APPLICATION_ID <> -1 ) THEN
454: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;
455: ELSE
456: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;
457: END IF;
458:

Line 456: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;

452:
453: IF ( l_Rec.APPLICATION_ID <> -1 ) THEN
454: l_Rec.OWNING_APPLICATION := FND_API.G_TRUE;
455: ELSE
456: l_Rec.OWNING_APPLICATION := FND_API.G_FALSE;
457: END IF;
458:
459: Update bis_application_measures
460: set

Line 469: if (p_commit = FND_API.G_TRUE) then

465: , APPLICATION_ID = l_Rec.Application_Id --2465354
466: where INDICATOR_ID = l_rec.Measure_Id ;
467: --AND Application_ID = l_Rec.Application_Id; --2465354
468: end if;
469: if (p_commit = FND_API.G_TRUE) then
470: COMMIT;
471: end if;
472:
473: --commented RAISE

Line 476: x_return_status := FND_API.G_RET_STS_ERROR ;

472:
473: --commented RAISE
474: EXCEPTION
475: WHEN NO_DATA_FOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;

Line 477: --RAISE FND_API.G_EXC_ERROR;

473: --commented RAISE
474: EXCEPTION
475: WHEN NO_DATA_FOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 478: when FND_API.G_EXC_ERROR then

474: EXCEPTION
475: WHEN NO_DATA_FOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 479: x_return_status := FND_API.G_RET_STS_ERROR ;

475: WHEN NO_DATA_FOUND THEN
476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 480: --RAISE FND_API.G_EXC_ERROR;

476: x_return_status := FND_API.G_RET_STS_ERROR ;
477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then

Line 481: when FND_API.G_EXC_UNEXPECTED_ERROR then

477: --RAISE FND_API.G_EXC_ERROR;
478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

478: when FND_API.G_EXC_ERROR then
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: l_error_tbl := x_error_Tbl;

Line 483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: --RAISE FND_API.G_EXC_ERROR;
481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: l_error_tbl := x_error_Tbl;
487: BIS_UTILITIES_PVT.Add_Error_Message

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481: when FND_API.G_EXC_UNEXPECTED_ERROR then
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: when others then
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: l_error_tbl := x_error_Tbl;
487: BIS_UTILITIES_PVT.Add_Error_Message
488: ( p_error_msg_id => SQLCODE
489: , p_error_description => SQLERRM

Line 494: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
491: , p_error_table => l_error_tbl
492: , x_error_table => x_error_tbl
493: );
494: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495:
496: end Update_Application_Measure;
497: --
498: --

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

497: --
498: --
499: PROCEDURE Delete_Application_Measure
500: ( p_api_version IN NUMBER
501: , p_commit IN VARCHAR2 := FND_API.G_FALSE
502: , p_Application_Measure_Rec IN
503: BIS_Application_Measure_PVT.Application_Measure_Rec_Type
504: , x_return_status OUT NOCOPY VARCHAR2
505: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: l_rec_p BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
511:
512: BEGIN
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: l_rec := p_Application_Measure_Rec;
515: l_rec_p := l_rec;
516: BIS_Application_Measure_PVT.Value_ID_Conversion
517: ( p_api_version

Line 540: if (p_commit = FND_API.G_TRUE) then

536: if SQL%NOTFOUND then
537: RAISE NO_DATA_FOUND;
538: end if;
539:
540: if (p_commit = FND_API.G_TRUE) then
541: COMMIT;
542: end if;
543:
544: --commented RAISE

Line 547: x_return_status := FND_API.G_RET_STS_ERROR ;

543:
544: --commented RAISE
545: EXCEPTION
546: WHEN NO_DATA_FOUND THEN
547: x_return_status := FND_API.G_RET_STS_ERROR ;
548: --added more params
549: l_error_tbl := x_error_Tbl;
550: BIS_UTILITIES_PVT.Add_Error_Message
551: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'

Line 558: --RAISE FND_API.G_EXC_ERROR;

554: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
555: , p_error_table => l_error_tbl
556: , x_error_table => x_error_tbl
557: );
558: --RAISE FND_API.G_EXC_ERROR;
559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 559: when FND_API.G_EXC_ERROR then

555: , p_error_table => l_error_tbl
556: , x_error_table => x_error_tbl
557: );
558: --RAISE FND_API.G_EXC_ERROR;
559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 560: x_return_status := FND_API.G_RET_STS_ERROR ;

556: , x_error_table => x_error_tbl
557: );
558: --RAISE FND_API.G_EXC_ERROR;
559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 561: --RAISE FND_API.G_EXC_ERROR;

557: );
558: --RAISE FND_API.G_EXC_ERROR;
559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then

Line 562: when FND_API.G_EXC_UNEXPECTED_ERROR then

558: --RAISE FND_API.G_EXC_ERROR;
559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

559: when FND_API.G_EXC_ERROR then
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: l_error_tbl := x_error_Tbl;

Line 564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: --RAISE FND_API.G_EXC_ERROR;
562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: l_error_tbl := x_error_Tbl;
568: BIS_UTILITIES_PVT.Add_Error_Message

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

562: when FND_API.G_EXC_UNEXPECTED_ERROR then
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: when others then
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: l_error_tbl := x_error_Tbl;
568: BIS_UTILITIES_PVT.Add_Error_Message
569: ( p_error_msg_id => SQLCODE
570: , p_error_description => SQLERRM

Line 575: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

571: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
572: , p_error_table => l_error_tbl
573: , x_error_table => x_error_tbl
574: );
575: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576:
577: end Delete_Application_Measure;
578: --
579: -- Validates measure

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: l_app_rec BIS_APPLICATION_PVT.Application_Rec_Type;
590: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
591: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
592: BEGIN
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- if application id is -1 then we need to skip validating the application
596: if (p_Application_Measure_Rec.Application_id = -1) then
597: return;

Line 614: when FND_API.G_EXC_ERROR then

610: , x_error_Tbl => l_error_tbl
611: );
612:
613: EXCEPTION
614: when FND_API.G_EXC_ERROR then
615: l_error_tbl_p := x_error_Tbl;
616: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
617: , l_error_Tbl
618: , x_error_tbl

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
617: , l_error_Tbl
618: , x_error_tbl
619: );
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: END;
622:
623: BEGIN
624: l_app_rec.application_id := p_Application_Measure_Rec.Application_id;

Line 636: when FND_API.G_EXC_ERROR then

632: , x_return_status => x_return_status
633: , x_error_Tbl => l_error_tbl
634: );
635: EXCEPTION
636: when FND_API.G_EXC_ERROR then
637: l_error_tbl_p := x_error_Tbl;
638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
639: , l_error_Tbl
640: , x_error_tbl

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
639: , l_error_Tbl
640: , x_error_tbl
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: END;
644:
645: --commented RAISE
646: EXCEPTION

Line 648: x_return_status := FND_API.G_RET_STS_ERROR ;

644:
645: --commented RAISE
646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;

Line 649: --RAISE FND_API.G_EXC_ERROR;

645: --commented RAISE
646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 650: when FND_API.G_EXC_ERROR then

646: EXCEPTION
647: WHEN NO_DATA_FOUND THEN
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 651: x_return_status := FND_API.G_RET_STS_ERROR ;

647: WHEN NO_DATA_FOUND THEN
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 652: --RAISE FND_API.G_EXC_ERROR;

648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then

Line 653: when FND_API.G_EXC_UNEXPECTED_ERROR then

649: --RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650: when FND_API.G_EXC_ERROR then
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: l_error_tbl_p := x_error_Tbl;

Line 655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: --RAISE FND_API.G_EXC_ERROR;
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: l_error_tbl_p := x_error_Tbl;
659: BIS_UTILITIES_PVT.Add_Error_Message

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: when others then
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: l_error_tbl_p := x_error_Tbl;
659: BIS_UTILITIES_PVT.Add_Error_Message
660: ( p_error_msg_id => SQLCODE
661: , p_error_description => SQLERRM

Line 666: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: , p_error_proc_name => G_PKG_NAME||'.Validate_Application_Measure'
663: , p_error_table => l_error_tbl_p
664: , x_error_table => x_error_tbl
665: );
666: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667:
668: end Validate_Application_Measure;
669: --
670: --

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
686: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
687: l_app_rec_p BIS_APPLICATION_PVT.Application_Rec_Type;
688: BEGIN
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: -- Not done because redundant
692: l_measure_rec.measure_id := p_Application_Measure_Rec.Measure_id;
693: l_measure_rec.measure_short_name

Line 698: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE

694: := p_Application_Measure_Rec.Measure_Short_name;
695: l_measure_rec.measure_name := p_Application_Measure_Rec.Measure_name;
696:
697: if (BIS_UTILITIES_PUB.Value_Missing
698: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
699: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
700: = FND_API.G_TRUE)
701: then
702: BEGIN

Line 700: = FND_API.G_TRUE)

696:
697: if (BIS_UTILITIES_PUB.Value_Missing
698: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
699: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
700: = FND_API.G_TRUE)
701: then
702: BEGIN
703: l_measure_rec_p := l_measure_rec;
704: BIS_MEASURE_PVT.Value_Id_conversion

Line 712: WHEN FND_API.G_EXC_ERROR then

708: , x_return_status => x_return_status
709: , x_error_Tbl => l_error_tbl
710: );
711: EXCEPTION
712: WHEN FND_API.G_EXC_ERROR then
713: NULL;
714: END;
715: end if;
716:

Line 723: OR BIS_UTILITIES_PUB.Value_Missing(l_app_rec.application_id) = FND_API.G_TRUE) then

719: p_Application_Measure_Rec.Application_Short_name;
720: l_app_rec.Application_name := p_Application_Measure_Rec.Application_name;
721:
722: if ( l_app_rec.application_id is NULL
723: OR BIS_UTILITIES_PUB.Value_Missing(l_app_rec.application_id) = FND_API.G_TRUE) then
724: l_app_rec_p := l_app_rec;
725: BIS_APPLICATION_PVT.Value_Id_conversion
726: ( p_api_version => 1.0
727: , p_application_Rec => l_app_rec_p

Line 750: x_return_status := FND_API.G_RET_STS_ERROR ;

746:
747: --commented RAISE
748: EXCEPTION
749: WHEN NO_DATA_FOUND THEN
750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;

Line 751: --RAISE FND_API.G_EXC_ERROR;

747: --commented RAISE
748: EXCEPTION
749: WHEN NO_DATA_FOUND THEN
750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 752: when FND_API.G_EXC_ERROR then

748: EXCEPTION
749: WHEN NO_DATA_FOUND THEN
750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 753: x_return_status := FND_API.G_RET_STS_ERROR ;

749: WHEN NO_DATA_FOUND THEN
750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 754: -- RAISE FND_API.G_EXC_ERROR;

750: x_return_status := FND_API.G_RET_STS_ERROR ;
751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then

Line 755: when FND_API.G_EXC_UNEXPECTED_ERROR then

751: --RAISE FND_API.G_EXC_ERROR;
752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

752: when FND_API.G_EXC_ERROR then
753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: l_error_tbl := x_error_Tbl;

Line 757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: x_return_status := FND_API.G_RET_STS_ERROR ;
754: -- RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: l_error_tbl := x_error_Tbl;
761: BIS_UTILITIES_PVT.Add_Error_Message

Line 759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: when others then
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760: l_error_tbl := x_error_Tbl;
761: BIS_UTILITIES_PVT.Add_Error_Message
762: ( p_error_msg_id => SQLCODE
763: , p_error_description => SQLERRM

Line 768: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
765: , p_error_table => l_error_tbl
766: , x_error_table => x_error_tbl
767: );
768: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769:
770: end Value_ID_Conversion;
771: --
772: PROCEDURE Retrieve_Last_Update_Date

Line 783: x_return_status := FND_API.G_RET_STS_SUCCESS;

779: )
780: IS
781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: BEGIN
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE
786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)
787: = FND_API.G_FALSE

Line 785: = FND_API.G_FALSE

781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: BEGIN
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE
786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)
787: = FND_API.G_FALSE
788: ) THEN
789: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)

Line 787: = FND_API.G_FALSE

783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: IF( BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Measure_id)
785: = FND_API.G_FALSE
786: AND BIS_UTILITIES_PUB.Value_Missing(p_Application_Measure_Rec.Application_id)
787: = FND_API.G_FALSE
788: ) THEN
789: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
790: INTO x_last_update_date
791: FROM bis_application_measures

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

796: --
797: --commented RAISE
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: --added this message
802: l_error_tbl := x_error_Tbl;
803: BIS_UTILITIES_PVT.Add_Error_Message
804: ( p_error_msg_name => 'BIS_INVALID_APPORMEASURE_ID'

Line 811: --RAISE FND_API.G_EXC_ERROR;

807: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
808: , p_error_table => l_error_tbl
809: , x_error_table => x_error_tbl
810: );
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status:= FND_API.G_RET_STS_ERROR;
814: -- RAISE;
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 812: WHEN FND_API.G_EXC_ERROR THEN

808: , p_error_table => l_error_tbl
809: , x_error_table => x_error_tbl
810: );
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status:= FND_API.G_RET_STS_ERROR;
814: -- RAISE;
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 813: x_return_status:= FND_API.G_RET_STS_ERROR;

809: , x_error_table => x_error_tbl
810: );
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status:= FND_API.G_RET_STS_ERROR;
814: -- RAISE;
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
817: -- RAISE;

Line 815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status:= FND_API.G_RET_STS_ERROR;
814: -- RAISE;
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
817: -- RAISE;
818: WHEN OTHERS THEN
819: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

812: WHEN FND_API.G_EXC_ERROR THEN
813: x_return_status:= FND_API.G_RET_STS_ERROR;
814: -- RAISE;
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
817: -- RAISE;
818: WHEN OTHERS THEN
819: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
820: l_error_tbl := x_error_Tbl;

Line 819: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
817: -- RAISE;
818: WHEN OTHERS THEN
819: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
820: l_error_tbl := x_error_Tbl;
821: BIS_UTILITIES_PVT.Add_Error_Message
822: ( p_error_table => l_error_Tbl
823: , p_error_msg_id => SQLCODE

Line 827: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

823: , p_error_msg_id => SQLCODE
824: , p_error_description => SQLERRM
825: , x_error_table => x_error_Tbl
826: );
827: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
828: --
829: END Retrieve_Last_Update_Date;
830: --
831: PROCEDURE Lock_Record

Line 847: x_return_status := FND_API.G_RET_STS_SUCCESS;

843: l_Rec BIS_Application_Measure_PVT.Application_Measure_Rec_Type;
844: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
845: --
846: BEGIN
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848: --
849: l_rec := p_Application_Measure_Rec;
850: Retrieve_Last_Update_Date
851: ( p_api_version => 1.0

Line 861: x_return_status := FND_API.G_TRUE;

857:
858: IF(p_timestamp IS NOT NULL) THEN
859: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
860: IF(l_form_date = l_last_update_date) THEN
861: x_return_status := FND_API.G_TRUE;
862: ELSE
863: x_return_status := FND_API.G_FALSE;
864: END IF;
865: ELSE

Line 863: x_return_status := FND_API.G_FALSE;

859: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
860: IF(l_form_date = l_last_update_date) THEN
861: x_return_status := FND_API.G_TRUE;
862: ELSE
863: x_return_status := FND_API.G_FALSE;
864: END IF;
865: ELSE
866: x_return_status := FND_API.G_FALSE;
867: END IF;

Line 866: x_return_status := FND_API.G_FALSE;

862: ELSE
863: x_return_status := FND_API.G_FALSE;
864: END IF;
865: ELSE
866: x_return_status := FND_API.G_FALSE;
867: END IF;
868: --
869:
870: --commented RAISE

Line 872: WHEN FND_API.G_EXC_ERROR THEN

868: --
869:
870: --commented RAISE
871: EXCEPTION
872: WHEN FND_API.G_EXC_ERROR THEN
873: x_return_status:= FND_API.G_RET_STS_ERROR;
874: --RAISE;
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 873: x_return_status:= FND_API.G_RET_STS_ERROR;

869:
870: --commented RAISE
871: EXCEPTION
872: WHEN FND_API.G_EXC_ERROR THEN
873: x_return_status:= FND_API.G_RET_STS_ERROR;
874: --RAISE;
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
877: --RAISE;

Line 875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

871: EXCEPTION
872: WHEN FND_API.G_EXC_ERROR THEN
873: x_return_status:= FND_API.G_RET_STS_ERROR;
874: --RAISE;
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
877: --RAISE;
878: WHEN OTHERS THEN
879: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

872: WHEN FND_API.G_EXC_ERROR THEN
873: x_return_status:= FND_API.G_RET_STS_ERROR;
874: --RAISE;
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
877: --RAISE;
878: WHEN OTHERS THEN
879: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
880: l_error_tbl := x_error_Tbl;

Line 879: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
877: --RAISE;
878: WHEN OTHERS THEN
879: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
880: l_error_tbl := x_error_Tbl;
881: BIS_UTILITIES_PVT.Add_Error_Message
882: ( p_error_table => l_error_Tbl
883: , p_error_msg_id => SQLCODE

Line 887: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

883: , p_error_msg_id => SQLCODE
884: , p_error_description => SQLERRM
885: , x_error_table => x_error_Tbl
886: );
887: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888:
889: END Lock_Record;
890:
891: PROCEDURE Update_Application_Measure

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

889: END Lock_Record;
890:
891: PROCEDURE Update_Application_Measure
892: ( p_api_version IN NUMBER
893: , p_commit IN VARCHAR2 := FND_API.G_FALSE
894: , p_Measure_Short_Name IN BIS_INDICATORS.SHORT_NAME%TYPE
895: , p_Application_Id IN BIS_APPLICATION_MEASURES.APPLICATION_ID%TYPE
896: , x_return_status OUT NOCOPY VARCHAR2
897: , x_msg_count OUT NOCOPY NUMBER

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: l_rec BIS_APPLICATION_MEASURE_PVT.Application_Measure_Rec_type;
902: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
903: l_measure_id BIS_INDICATORS.INDICATOR_ID%TYPE;
904: BEGIN
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: SELECT indicator_id
907: INTO l_measure_id
908: FROM BIS_INDICATORS
909: WHERE SHORT_NAME = p_Measure_Short_Name;

Line 913: l_rec.owning_application := FND_API.G_FALSE;

909: WHERE SHORT_NAME = p_Measure_Short_Name;
910:
911: l_rec.Measure_id := l_measure_id;
912: l_rec.Application_id := p_Application_Id;
913: l_rec.owning_application := FND_API.G_FALSE;
914:
915: BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure( p_api_version
916: , p_commit
917: , l_rec

Line 920: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

916: , p_commit
917: , l_rec
918: , x_return_status
919: , l_error_tbl);
920: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
921: IF (l_error_tbl.COUNT > 0) THEN
922: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
923: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
924: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

924: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
925: FND_MSG_PUB.ADD;
926: x_msg_data := NULL;
927: END IF;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: x_msg_data := NULL;
927: END IF;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: IF(p_Commit = FND_API.G_TRUE) THEN
934: COMMIT;

Line 933: IF(p_Commit = FND_API.G_TRUE) THEN

929: END IF;
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: IF(p_Commit = FND_API.G_TRUE) THEN
934: COMMIT;
935: END IF;
936:
937: EXCEPTION

Line 938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

934: COMMIT;
935: END IF;
936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
940: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);

Line 939: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

935: END IF;
936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
940: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN OTHERS THEN

Line 940: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
940: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN OTHERS THEN
944: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 944: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

940: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN OTHERS THEN
944: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
945: IF (x_msg_data IS NOT NULL) THEN
946: x_msg_data := x_msg_data||' -> BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';
947: ELSE
948: x_msg_data := SQLERRM||' at BIS_APPLICATION_MEASURE_PVT.Update_Application_Measure ';