eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_MEASURE_VALIDATE_PVT dependencies on BIS_UTILITIES_PUB

Line 34: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

30: ( p_api_version IN NUMBER
31: , p_dimension_id IN NUMBER
32: , p_dimension_short_name IN VARCHAR2
33: , x_return_status OUT NOCOPY VARCHAR2
34: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
35: )
36: IS
37:
38: l_dummy number;

Line 39: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

35: )
36: IS
37:
38: l_dummy number;
39: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
40:
41: CURSOR chk_dimension is
42: select 1
43: from bisbv_dimensions

Line 52: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_dimension_id)=FND_API.G_TRUE

48:
49: -- dbms_output.put_line('PVT. validate dim: '||p_Dimension_ID
50: -- ||' - '||p_Dimension_Short_Name);
51:
52: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_dimension_id)=FND_API.G_TRUE
53: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_dimension_id)=FND_API.G_TRUE) then
54: open chk_dimension;
55: fetch chk_dimension into l_dummy;
56: if (chk_dimension%NOTFOUND) then

Line 53: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_dimension_id)=FND_API.G_TRUE) then

49: -- dbms_output.put_line('PVT. validate dim: '||p_Dimension_ID
50: -- ||' - '||p_Dimension_Short_Name);
51:
52: if(BIS_UTILITIES_PUB.Value_Not_Missing(p_dimension_id)=FND_API.G_TRUE
53: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_dimension_id)=FND_API.G_TRUE) then
54: open chk_dimension;
55: fetch chk_dimension into l_dummy;
56: if (chk_dimension%NOTFOUND) then
57: close chk_dimension;

Line 64: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

60: BIS_UTILITIES_PVT.Add_Error_Message
61: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_ID'
62: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
63: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_ID'
64: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
65: , p_error_table => l_error_tbl
66: , x_error_table => x_error_tbl
67: );
68: RAISE FND_API.G_EXC_ERROR;

Line 105: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

101: PROCEDURE Val_Actual_Data_Sour_Type
102: ( p_api_version IN NUMBER
103: , p_actual_data_source_type IN VARCHAR2
104: , x_return_status OUT NOCOPY VARCHAR2
105: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
106: )
107: IS
108:
109: l_dummy number;

Line 110: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

106: )
107: IS
108:
109: l_dummy number;
110: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
111:
112: CURSOR chk_actual_data_source_type IS
113: SELECT 1
114: FROM fnd_lookups

Line 120: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source_type)= FND_API.G_TRUE

116: AND lookup_type = 'BIS_ACTUAL_DATA_SOURCE_TYPE';
117:
118: BEGIN
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source_type)= FND_API.G_TRUE
121: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source_type)= FND_API.G_TRUE)
122: THEN
123: OPEN chk_actual_data_source_type;
124: FETCH chk_actual_data_source_type INTO l_dummy;

Line 121: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source_type)= FND_API.G_TRUE)

117:
118: BEGIN
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source_type)= FND_API.G_TRUE
121: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source_type)= FND_API.G_TRUE)
122: THEN
123: OPEN chk_actual_data_source_type;
124: FETCH chk_actual_data_source_type INTO l_dummy;
125: IF chk_actual_data_source_type%NOTFOUND THEN

Line 132: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

128: BIS_UTILITIES_PVT.Add_Error_Message
129: ( p_error_msg_name => 'BIS_INVALID_ACTUAL_DATA_SOURCE_TYPE'
130: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
131: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour_Type'
132: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
133: , p_error_table => l_error_tbl
134: , x_error_table => x_error_tbl
135: );
136: RAISE FND_API.G_EXC_ERROR;

Line 169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

165: PROCEDURE Val_Actual_Data_Sour
166: ( p_api_version IN NUMBER
167: , p_actual_data_source IN VARCHAR2
168: , x_return_status OUT NOCOPY VARCHAR2
169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
170: )
171: IS
172:
173: l_dummy number;

Line 174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

170: )
171: IS
172:
173: l_dummy number;
174: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
175:
176: CURSOR chk_actual_data_source IS
177: SELECT 1
178: FROM ak_region_items

Line 188: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source)= FND_API.G_TRUE

184: (INSTR(p_actual_data_source, '.', 1)+1)
185: );
186: BEGIN
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source)= FND_API.G_TRUE
189: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source)= FND_API.G_TRUE)
190: THEN
191: OPEN chk_actual_data_source;
192: FETCH chk_actual_data_source INTO l_dummy;

Line 189: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source)= FND_API.G_TRUE)

185: );
186: BEGIN
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_actual_data_source)= FND_API.G_TRUE
189: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_actual_data_source)= FND_API.G_TRUE)
190: THEN
191: OPEN chk_actual_data_source;
192: FETCH chk_actual_data_source INTO l_dummy;
193: IF chk_actual_data_source%NOTFOUND THEN

Line 200: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

196: BIS_UTILITIES_PVT.Add_Error_Message
197: ( p_error_msg_name => 'BIS_INVALID_ACTUAL_DATA_SOURCE'
198: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
199: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour'
200: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
201: , p_error_table => l_error_tbl
202: , x_error_table => x_error_tbl
203: );
204: RAISE FND_API.G_EXC_ERROR;

Line 237: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

233: PROCEDURE Val_Func_Name
234: ( p_api_version IN NUMBER
235: , p_function_name IN VARCHAR2
236: , x_return_status OUT NOCOPY VARCHAR2
237: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
238: )
239: IS
240:
241: l_dummy number;

Line 242: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

238: )
239: IS
240:
241: l_dummy number;
242: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
243:
244: CURSOR chk_function_name IS
245: SELECT 1
246: FROM fnd_form_functions

Line 251: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_function_name)= FND_API.G_TRUE

247: WHERE function_name = p_function_name;
248:
249: BEGIN
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_function_name)= FND_API.G_TRUE
252: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_function_name)= FND_API.G_TRUE)
253: THEN
254: OPEN chk_function_name;
255: FETCH chk_function_name INTO l_dummy;

Line 252: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_function_name)= FND_API.G_TRUE)

248:
249: BEGIN
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_function_name)= FND_API.G_TRUE
252: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_function_name)= FND_API.G_TRUE)
253: THEN
254: OPEN chk_function_name;
255: FETCH chk_function_name INTO l_dummy;
256: IF chk_function_name%NOTFOUND THEN

Line 263: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

259: BIS_UTILITIES_PVT.Add_Error_Message
260: ( p_error_msg_name => 'BIS_INVALID_FUNCTION_NAME'
261: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
262: , p_error_proc_name => G_PKG_NAME||'.Val_Func_Name'
263: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
264: , p_error_table => l_error_tbl
265: , x_error_table => x_error_tbl
266: );
267: RAISE FND_API.G_EXC_ERROR;

Line 300: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

296: PROCEDURE Val_Comparison_Source
297: ( p_api_version IN NUMBER
298: , p_comparison_source IN VARCHAR2
299: , x_return_status OUT NOCOPY VARCHAR2
300: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
301: )
302: IS
303:
304: l_dummy number;

Line 305: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

301: )
302: IS
303:
304: l_dummy number;
305: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
306:
307: CURSOR chk_comparison_source IS
308: SELECT 1
309: FROM ak_region_items

Line 319: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_comparison_source)= FND_API.G_TRUE

315: (INSTR(p_comparison_source, '.', 1)+1)
316: );
317: BEGIN
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_comparison_source)= FND_API.G_TRUE
320: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_comparison_source)= FND_API.G_TRUE)
321: THEN
322: OPEN chk_comparison_source;
323: FETCH chk_comparison_source INTO l_dummy;

Line 320: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_comparison_source)= FND_API.G_TRUE)

316: );
317: BEGIN
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_comparison_source)= FND_API.G_TRUE
320: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_comparison_source)= FND_API.G_TRUE)
321: THEN
322: OPEN chk_comparison_source;
323: FETCH chk_comparison_source INTO l_dummy;
324: IF chk_comparison_source%NOTFOUND THEN

Line 331: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

327: BIS_UTILITIES_PVT.Add_Error_Message
328: ( p_error_msg_name => 'BIS_INVALID_COMPARISON_SOURCE'
329: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
330: , p_error_proc_name => G_PKG_NAME||'.Val_Comparison_Source'
331: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
332: , p_error_table => l_error_tbl
333: , x_error_table => x_error_tbl
334: );
335: RAISE FND_API.G_EXC_ERROR;

Line 368: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

364: PROCEDURE Val_Incr_In_Measure
365: ( p_api_version IN NUMBER
366: , p_increase_in_measure IN VARCHAR2
367: , x_return_status OUT NOCOPY VARCHAR2
368: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
369: )
370: IS
371:
372: l_dummy number;

Line 373: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

369: )
370: IS
371:
372: l_dummy number;
373: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
374:
375: CURSOR chk_increase_in_measure IS
376: SELECT 1
377: FROM fnd_lookups

Line 383: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_increase_in_measure)= FND_API.G_TRUE

379: AND lookup_type = 'BIS_INCREASE_IN_MEASURE';
380:
381: BEGIN
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_increase_in_measure)= FND_API.G_TRUE
384: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_increase_in_measure)= FND_API.G_TRUE)
385: THEN
386: OPEN chk_increase_in_measure;
387: FETCH chk_increase_in_measure INTO l_dummy;

Line 384: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_increase_in_measure)= FND_API.G_TRUE)

380:
381: BEGIN
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_increase_in_measure)= FND_API.G_TRUE
384: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_increase_in_measure)= FND_API.G_TRUE)
385: THEN
386: OPEN chk_increase_in_measure;
387: FETCH chk_increase_in_measure INTO l_dummy;
388: IF chk_increase_in_measure%NOTFOUND THEN

Line 395: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

391: BIS_UTILITIES_PVT.Add_Error_Message
392: ( p_error_msg_name => 'BIS_INVALID_INCREASE_IN_MEASURE'
393: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
394: , p_error_proc_name => G_PKG_NAME||'.Val_Incr_In_Measure'
395: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
396: , p_error_table => l_error_tbl
397: , x_error_table => x_error_tbl
398: );
399: RAISE FND_API.G_EXC_ERROR;

Line 433: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

429: PROCEDURE Val_Enable_Link
430: ( p_api_version IN NUMBER
431: , p_enable_link IN VARCHAR2
432: , x_return_status OUT NOCOPY VARCHAR2
433: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
434: )
435: IS
436:
437: l_dummy number;

Line 438: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

434: )
435: IS
436:
437: l_dummy number;
438: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
439:
440: CURSOR chk_Enable_Link IS
441: SELECT 1
442: FROM fnd_lookups

Line 448: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enable_link)= FND_API.G_TRUE

444: AND lookup_type = 'BIS_PMF_ENABLE_LINK';
445:
446: BEGIN
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enable_link)= FND_API.G_TRUE
449: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enable_link)= FND_API.G_TRUE)
450: THEN
451: IF ( chk_enable_link%ISOPEN ) THEN
452: CLOSE chk_enable_link;

Line 449: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enable_link)= FND_API.G_TRUE)

445:
446: BEGIN
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enable_link)= FND_API.G_TRUE
449: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enable_link)= FND_API.G_TRUE)
450: THEN
451: IF ( chk_enable_link%ISOPEN ) THEN
452: CLOSE chk_enable_link;
453: END IF;

Line 463: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

459: BIS_UTILITIES_PVT.Add_Error_Message
460: ( p_error_msg_name => 'BIS_INVALID_enable_link'
461: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
462: , p_error_proc_name => G_PKG_NAME||'.Val_enable_link'
463: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
464: , p_error_table => l_error_tbl
465: , x_error_table => x_error_tbl
466: );
467: RAISE FND_API.G_EXC_ERROR;

Line 515: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

511: PROCEDURE Val_Enabled
512: ( p_api_version IN NUMBER
513: , p_enabled IN VARCHAR2
514: , x_return_status OUT NOCOPY VARCHAR2
515: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
516: )
517: IS
518:
519: l_dummy number;

Line 520: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

516: )
517: IS
518:
519: l_dummy number;
520: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
521:
522: BEGIN
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enabled)= FND_API.G_TRUE

Line 524: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enabled)= FND_API.G_TRUE

520: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
521:
522: BEGIN
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enabled)= FND_API.G_TRUE
525: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enabled)= FND_API.G_TRUE)
526: THEN
527: IF ((p_enabled <> FND_API.G_TRUE) AND (p_enabled <> FND_API.G_FALSE)) THEN
528: l_error_tbl := x_error_tbl;

Line 525: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enabled)= FND_API.G_TRUE)

521:
522: BEGIN
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_enabled)= FND_API.G_TRUE
525: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enabled)= FND_API.G_TRUE)
526: THEN
527: IF ((p_enabled <> FND_API.G_TRUE) AND (p_enabled <> FND_API.G_FALSE)) THEN
528: l_error_tbl := x_error_tbl;
529: BIS_UTILITIES_PVT.Add_Error_Message

Line 533: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

529: BIS_UTILITIES_PVT.Add_Error_Message
530: ( p_error_msg_name => 'BIS_PMF_INVALID_ENABLED'
531: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
532: , p_error_proc_name => G_PKG_NAME||'.Val_enabled'
533: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
534: , p_error_table => l_error_tbl
535: , x_error_table => x_error_tbl
536: );
537: RAISE FND_API.G_EXC_ERROR;

Line 567: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

563: PROCEDURE Val_Obsolete --3865711
564: ( p_api_version IN NUMBER
565: , p_obsolete IN VARCHAR2
566: , x_return_status OUT NOCOPY VARCHAR2
567: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
568: )
569: IS
570:
571: l_dummy number;

Line 572: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

568: )
569: IS
570:
571: l_dummy number;
572: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
573:
574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: IF ((p_obsolete <> FND_API.G_TRUE) AND (p_obsolete <> FND_API.G_FALSE) AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_obsolete) <> FND_API.G_TRUE) ) THEN

Line 582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

578: BIS_UTILITIES_PVT.Add_Error_Message
579: ( p_error_msg_name => 'BIS_PMF_INVALID_OBSOLETE_FLAG'
580: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
581: , p_error_proc_name => G_PKG_NAME||'.Val_Obsolete'
582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
583: , p_error_table => l_error_tbl
584: , x_error_table => x_error_tbl
585: );
586: RAISE FND_API.G_EXC_ERROR;

Line 610: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

606: PROCEDURE Val_Measure_Type
607: ( p_api_version IN NUMBER
608: , p_Measure_Type IN VARCHAR2
609: , x_return_status OUT NOCOPY VARCHAR2
610: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
611: )
612: IS
613:
614: l_dummy number;

Line 615: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

611: )
612: IS
613:
614: l_dummy number;
615: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
616:
617: BEGIN
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: IF ((p_Measure_type <> 'CDS_SCORE') AND (p_Measure_Type <> 'CDS_PERF') AND (p_Measure_Type <> 'CDS_CALC')

Line 626: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

622: BIS_UTILITIES_PVT.Add_Error_Message
623: ( p_error_msg_name => 'BIS_PMF_INVALID_MEASURE_TYPE'
624: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
625: , p_error_proc_name => G_PKG_NAME||'.Val_Measure_Type'
626: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
627: , p_error_table => l_error_tbl
628: , x_error_table => x_error_tbl
629: );
630: RAISE FND_API.G_EXC_ERROR;

Line 656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

652: ( p_api_version IN NUMBER
653: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
654: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
655: , x_return_status OUT NOCOPY VARCHAR2
656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
657: )
658: IS
659: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
660: BEGIN

Line 659: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

655: , x_return_status OUT NOCOPY VARCHAR2
656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
657: )
658: IS
659: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
660: BEGIN
661: Val_Actual_Data_Sour_Type( p_api_version
662: , p_MEASURE_Rec.Actual_Data_Source_Type
663: , x_return_status

Line 698: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

694: ( p_api_version IN NUMBER
695: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
696: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
697: , x_return_status OUT NOCOPY VARCHAR2
698: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
699: )
700: IS
701: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
702: BEGIN

Line 701: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

697: , x_return_status OUT NOCOPY VARCHAR2
698: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
699: )
700: IS
701: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
702: BEGIN
703: Val_Actual_Data_Sour( p_api_version
704: , p_MEASURE_Rec.Actual_Data_Source
705: , x_return_status

Line 740: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

736: ( p_api_version IN NUMBER
737: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
738: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
739: , x_return_status OUT NOCOPY VARCHAR2
740: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
741: )
742: IS
743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
744: BEGIN

Line 743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

739: , x_return_status OUT NOCOPY VARCHAR2
740: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
741: )
742: IS
743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
744: BEGIN
745: Val_Func_Name( p_api_version
746: , p_MEASURE_Rec.Function_Name
747: , x_return_status

Line 782: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

778: ( p_api_version IN NUMBER
779: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
781: , x_return_status OUT NOCOPY VARCHAR2
782: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
783: )
784: IS
785: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
786: BEGIN

Line 785: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

781: , x_return_status OUT NOCOPY VARCHAR2
782: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
783: )
784: IS
785: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
786: BEGIN
787: Val_Comparison_Source( p_api_version
788: , p_MEASURE_Rec.Comparison_Source
789: , x_return_status

Line 824: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

820: ( p_api_version IN NUMBER
821: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
822: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
823: , x_return_status OUT NOCOPY VARCHAR2
824: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
825: )
826: IS
827: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
828: BEGIN

Line 827: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

823: , x_return_status OUT NOCOPY VARCHAR2
824: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
825: )
826: IS
827: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
828: BEGIN
829: Val_Incr_In_Measure( p_api_version
830: , p_MEASURE_Rec.Increase_In_Measure
831: , x_return_status

Line 868: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

864: ( p_api_version IN NUMBER
865: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
866: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
867: , x_return_status OUT NOCOPY VARCHAR2
868: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
869: )
870: IS
871: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
872: BEGIN

Line 871: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

867: , x_return_status OUT NOCOPY VARCHAR2
868: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
869: )
870: IS
871: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
872: BEGIN
873: Val_enable_link( p_api_version
874: , p_MEASURE_Rec.enable_link
875: , x_return_status

Line 913: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

909: ( p_api_version IN NUMBER
910: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
911: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
912: , x_return_status OUT NOCOPY VARCHAR2
913: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
914: )
915: IS
916: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
917: BEGIN

Line 916: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

912: , x_return_status OUT NOCOPY VARCHAR2
913: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
914: )
915: IS
916: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
917: BEGIN
918: Val_enabled ( p_api_version
919: , p_MEASURE_Rec.enabled
920: , x_return_status

Line 958: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

954: ( p_api_version IN NUMBER
955: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
956: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
957: , x_return_status OUT NOCOPY VARCHAR2
958: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
959: )
960: IS
961: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
962: BEGIN

Line 961: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

957: , x_return_status OUT NOCOPY VARCHAR2
958: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
959: )
960: IS
961: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
962: BEGIN
963: Val_Obsolete ( p_api_version
964: , p_MEASURE_Rec.Obsolete
965: , x_return_status

Line 995: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

991: ( p_api_version IN NUMBER
992: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
993: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
994: , x_return_status OUT NOCOPY VARCHAR2
995: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
996: )
997: IS
998: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
999: BEGIN

Line 998: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

994: , x_return_status OUT NOCOPY VARCHAR2
995: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
996: )
997: IS
998: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
999: BEGIN
1000: Val_Measure_Type ( p_api_version
1001: , p_MEASURE_Rec.Measure_Type
1002: , x_return_status

Line 1032: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1028: ( p_api_version IN NUMBER
1029: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1030: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1031: , x_return_status OUT NOCOPY VARCHAR2
1032: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1033: )
1034: IS
1035: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1036: BEGIN

Line 1035: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1031: , x_return_status OUT NOCOPY VARCHAR2
1032: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1033: )
1034: IS
1035: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1036: BEGIN
1037: Validate_Dimension_Id( p_api_version
1038: , p_MEASURE_Rec.Dimension1_ID
1039: , p_Measure_Rec.Dimension1_Short_Name

Line 1075: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1071: ( p_api_version IN NUMBER
1072: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1073: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1074: , x_return_status OUT NOCOPY VARCHAR2
1075: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1076: )
1077: IS
1078: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1079: BEGIN

Line 1078: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1074: , x_return_status OUT NOCOPY VARCHAR2
1075: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1076: )
1077: IS
1078: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1079: BEGIN
1080:
1081: Validate_Dimension_Id( p_api_version
1082: , p_MEASURE_Rec.Dimension2_ID

Line 1119: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1115: ( p_api_version IN NUMBER
1116: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1117: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1118: , x_return_status OUT NOCOPY VARCHAR2
1119: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1120: )
1121: IS
1122: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1123: BEGIN

Line 1122: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1118: , x_return_status OUT NOCOPY VARCHAR2
1119: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1120: )
1121: IS
1122: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1123: BEGIN
1124:
1125: Validate_Dimension_Id( p_api_version
1126: , p_MEASURE_Rec.Dimension3_ID

Line 1163: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1159: ( p_api_version IN NUMBER
1160: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1161: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1162: , x_return_status OUT NOCOPY VARCHAR2
1163: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1164: )
1165: IS
1166: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1167: BEGIN

Line 1166: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1162: , x_return_status OUT NOCOPY VARCHAR2
1163: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1164: )
1165: IS
1166: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1167: BEGIN
1168:
1169: Validate_Dimension_Id( p_api_version
1170: , p_MEASURE_Rec.Dimension4_ID

Line 1207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1203: ( p_api_version IN NUMBER
1204: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1205: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1206: , x_return_status OUT NOCOPY VARCHAR2
1207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1208: )
1209: IS
1210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1211: BEGIN

Line 1210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1206: , x_return_status OUT NOCOPY VARCHAR2
1207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1208: )
1209: IS
1210: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1211: BEGIN
1212:
1213: Validate_Dimension_Id( p_api_version
1214: , p_MEASURE_Rec.Dimension5_ID

Line 1251: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1247: ( p_api_version IN NUMBER
1248: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1249: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1250: , x_return_status OUT NOCOPY VARCHAR2
1251: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1252: )
1253: IS
1254: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1255: BEGIN

Line 1254: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1250: , x_return_status OUT NOCOPY VARCHAR2
1251: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1252: )
1253: IS
1254: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1255: BEGIN
1256:
1257: Validate_Dimension_Id( p_api_version
1258: , p_MEASURE_Rec.Dimension6_ID

Line 1295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1291: ( p_api_version IN NUMBER
1292: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1293: , p_MEASURE_Rec IN BIS_MEASURE_PUB.MEASURE_Rec_Type
1294: , x_return_status OUT NOCOPY VARCHAR2
1295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1296: )
1297: IS
1298: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1299: BEGIN

Line 1298: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1294: , x_return_status OUT NOCOPY VARCHAR2
1295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1296: )
1297: IS
1298: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1299: BEGIN
1300:
1301: Validate_Dimension_Id( p_api_version
1302: , p_MEASURE_Rec.Dimension7_ID