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_PUB dependencies on BIS_UTILITIES_PUB

Line 41: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

37: Procedure Create_Measure
38: ( p_api_version IN NUMBER
39: , p_commit IN VARCHAR2 := FND_API.G_FALSE
40: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
41: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS

Line 43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

39: , p_commit IN VARCHAR2 := FND_API.G_FALSE
40: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
41: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
42: , x_return_status OUT NOCOPY VARCHAR2
43: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
44: )
45: IS
46: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

44: )
45: IS
46: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
49: BEGIN
50:
51: if (BIS_UTILITIES_PUB.Value_Missing
52: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE

Line 51: if (BIS_UTILITIES_PUB.Value_Missing

47: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
48: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
49: BEGIN
50:
51: if (BIS_UTILITIES_PUB.Value_Missing
52: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
53: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
54: = FND_API.G_TRUE) then
55: --changed to call Measure_Value_ID_Conversion

Line 53: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

49: BEGIN
50:
51: if (BIS_UTILITIES_PUB.Value_Missing
52: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
53: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
54: = FND_API.G_TRUE) then
55: --changed to call Measure_Value_ID_Conversion
56: BIS_Measure_PVT.Measure_Value_ID_Conversion
57: ( p_api_version => p_api_version

Line 70: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

66: BIS_UTILITIES_PVT.Add_Error_Message
67: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
68: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
69: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
70: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
71: , p_error_table => l_error_tbl
72: , x_error_table => x_error_tbl
73: );
74: RAISE FND_API.G_EXC_ERROR;

Line 132: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

128: ( p_api_version IN NUMBER
129: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
130: , x_Measure_tbl OUT NOCOPY BIS_MEASURE_PUB.Measure_Tbl_Type
131: , x_return_status OUT NOCOPY VARCHAR2
132: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
133: )
134: IS
135: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

132: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
133: )
134: IS
135: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
136: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
137: BEGIN
138:
139: BIS_Measure_PVT.Retrieve_Measures
140: ( p_api_version => p_api_version

Line 175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

171: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
172: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
173: , x_Measure_Rec IN OUT NOCOPY BIS_MEASURE_PUB.Measure_Rec_Type
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )
177: IS
178:
179: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;

Line 180: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

176: )
177: IS
178:
179: l_Measure_Rec BIS_Measure_PUB.Measure_Rec_Type;
180: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
181:
182: BEGIN
183: l_measure_rec := p_measure_rec;
184:

Line 185: if (BIS_UTILITIES_PUB.Value_Missing

181:
182: BEGIN
183: l_measure_rec := p_measure_rec;
184:
185: if (BIS_UTILITIES_PUB.Value_Missing
186: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
187: OR
188: BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id) = FND_API.G_TRUE)
189: THEN

Line 188: BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id) = FND_API.G_TRUE)

184:
185: if (BIS_UTILITIES_PUB.Value_Missing
186: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
187: OR
188: BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id) = FND_API.G_TRUE)
189: THEN
190: --changed to call Measure_Value_ID_Conversion
191: BIS_Measure_PVT.Measure_Value_ID_Conversion
192: ( p_api_version => p_api_version

Line 242: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

238: Procedure Update_Measure
239: ( p_api_version IN NUMBER
240: , p_commit IN VARCHAR2 := FND_API.G_FALSE
241: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
242: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
243: , x_return_status OUT NOCOPY VARCHAR2
244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS

Line 244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

240: , p_commit IN VARCHAR2 := FND_API.G_FALSE
241: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
242: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
243: , x_return_status OUT NOCOPY VARCHAR2
244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS
247: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
248: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 249: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

245: )
246: IS
247: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
248: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
249: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
250: BEGIN
251:
252: l_measure_rec := p_measure_rec;
253:

Line 254: if (BIS_UTILITIES_PUB.Value_Missing

250: BEGIN
251:
252: l_measure_rec := p_measure_rec;
253:
254: if (BIS_UTILITIES_PUB.Value_Missing
255: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
256: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
257: = FND_API.G_TRUE) then
258: --changed to call Measure_Value_ID_Conversion

Line 256: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

252: l_measure_rec := p_measure_rec;
253:
254: if (BIS_UTILITIES_PUB.Value_Missing
255: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
256: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
257: = FND_API.G_TRUE) then
258: --changed to call Measure_Value_ID_Conversion
259: BIS_Measure_PVT.Measure_Value_ID_Conversion
260: ( p_api_version => p_api_version

Line 325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

321: ( p_api_version IN NUMBER
322: , p_commit IN VARCHAR2 := FND_API.G_FALSE
323: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
324: , x_return_status OUT NOCOPY VARCHAR2
325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
326: )
327: IS
328: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
329: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 329: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

325: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
326: )
327: IS
328: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
329: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
330: BEGIN
331:
332: l_Measure_Rec := p_Measure_rec;
333: if (BIS_UTILITIES_PUB.Value_Missing

Line 333: if (BIS_UTILITIES_PUB.Value_Missing

329: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
330: BEGIN
331:
332: l_Measure_Rec := p_Measure_rec;
333: if (BIS_UTILITIES_PUB.Value_Missing
334: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
335: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
336: = FND_API.G_TRUE) then
337: --changed to call Measure_Value_ID_Conversion

Line 335: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

331:
332: l_Measure_Rec := p_Measure_rec;
333: if (BIS_UTILITIES_PUB.Value_Missing
334: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
335: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
336: = FND_API.G_TRUE) then
337: --changed to call Measure_Value_ID_Conversion
338: --used to call Value_ID_Conv with shortname
339: BIS_Measure_PVT.Measure_Value_ID_Conversion

Line 385: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

381: PROCEDURE Validate_Measure
382: ( p_api_version IN NUMBER
383: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
384: , x_return_status OUT NOCOPY VARCHAR2
385: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
386: )
387: IS
388: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
389: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

386: )
387: IS
388: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
389: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
390: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
391: BEGIN
392: l_Measure_Rec := p_Measure_Rec;
393: --changed to call Measure_Value_ID_Conversion
394: BIS_Measure_PVT.Measure_Value_ID_Conversion

Line 451: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

447: ( p_api_version IN NUMBER
448: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
449: , x_dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
450: , x_return_status OUT NOCOPY VARCHAR2
451: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
452: )
453: IS
454: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

451: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
452: )
453: IS
454: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
456: BEGIN
457:
458: l_measure_rec := p_measure_rec;
459:

Line 460: if (BIS_UTILITIES_PUB.Value_Missing

456: BEGIN
457:
458: l_measure_rec := p_measure_rec;
459:
460: if (BIS_UTILITIES_PUB.Value_Missing
461: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
462: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
463: = FND_API.G_TRUE) then
464: --changed to call Measure_Value_ID_Conversion

Line 462: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)

458: l_measure_rec := p_measure_rec;
459:
460: if (BIS_UTILITIES_PUB.Value_Missing
461: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
462: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
463: = FND_API.G_TRUE) then
464: --changed to call Measure_Value_ID_Conversion
465: --used to call Value_ID_Conversion with short name
466: BIS_MEASURE_PVT.Measure_Value_ID_Conversion

Line 512: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

508: ( p_api_version IN NUMBER
509: , p_commit IN VARCHAR2 := FND_API.G_FALSE
510: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
511: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
512: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
513: , x_return_status OUT NOCOPY VARCHAR2
514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
515: )
516: IS

Line 514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

510: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
511: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
512: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
513: , x_return_status OUT NOCOPY VARCHAR2
514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
515: )
516: IS
517: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
518: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 521: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

517: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
518: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
519: l_return_status VARCHAR2(10);
520: l_return_msg VARCHAR2(32000);
521: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
522: BEGIN
523:
524: bis_utilities_pvt.init_debug_flag -- 2694978
525: ( x_return_status => l_return_status

Line 595: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

591: ( p_api_version IN NUMBER
592: , p_commit IN VARCHAR2 := FND_API.G_FALSE
593: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
594: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
595: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
596: , x_return_status OUT NOCOPY VARCHAR2
597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
598: )
599: IS

Line 597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

593: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
594: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
595: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
596: , x_return_status OUT NOCOPY VARCHAR2
597: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
598: )
599: IS
600: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
601: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 602: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

598: )
599: IS
600: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
601: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
602: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
603: BEGIN
604:
605: l_measure_rec := p_measure_rec;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 609: if (BIS_UTILITIES_PUB.Value_Missing

605: l_measure_rec := p_measure_rec;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: BEGIN
608: --added check
609: if (BIS_UTILITIES_PUB.Value_Missing
610: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
611: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
612: = FND_API.G_TRUE) then
613: --changed to call Measure_Value_ID_Conversion

Line 611: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

607: BEGIN
608: --added check
609: if (BIS_UTILITIES_PUB.Value_Missing
610: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
611: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
612: = FND_API.G_TRUE) then
613: --changed to call Measure_Value_ID_Conversion
614: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
615: ( p_api_version => p_api_version

Line 706: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

702: ( p_api_version IN NUMBER
703: , p_commit IN VARCHAR2 := FND_API.G_FALSE
704: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
705: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
706: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
707: , p_Org_Dimension_Short_Name IN VARCHAR2
708: , p_Time_Dimension_Short_Name IN VARCHAR2
709: , x_return_status OUT NOCOPY VARCHAR2
710: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 710: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

706: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
707: , p_Org_Dimension_Short_Name IN VARCHAR2
708: , p_Time_Dimension_Short_Name IN VARCHAR2
709: , x_return_status OUT NOCOPY VARCHAR2
710: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
711: )
712: IS
713: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
714: l_measure_rec_p BIS_MEASURE_PUB.Measure_Rec_Type;

Line 720: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

716: l_Time_Dimension_ID NUMBER;
717: l_msg VARCHAR2(3000);
718: l_return_status VARCHAR2(10);
719: l_return_msg VARCHAR2(32000);
720: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
721:
722: BEGIN
723:
724: bis_utilities_pvt.init_debug_flag -- 2694978

Line 729: -- BIS_UTILITIES_PUB.put_line(p_text =>'XXXXXXXXX');

725: ( x_return_status => l_return_status
726: , x_return_msg => l_return_msg
727: );
728:
729: -- BIS_UTILITIES_PUB.put_line(p_text =>'XXXXXXXXX');
730:
731: /*
732: fnd_message.set_name('BIS', 'BIS_KPI_NOT_CREATED');
733: fnd_message.set_token('NAME', p_measure_rec.measure_name);

Line 745: IF (BIS_UTILITIES_PUB.Value_Missing

741: l_measure_rec := p_measure_rec;
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744:
745: IF (BIS_UTILITIES_PUB.Value_Missing
746: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
747: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
748: = FND_API.G_TRUE) then
749: BIS_MEASURE_PVT.Measure_Value_ID_Conversion

Line 747: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)

743:
744:
745: IF (BIS_UTILITIES_PUB.Value_Missing
746: (p_Measure_Rec.Measure_id) = FND_API.G_TRUE
747: OR BIS_UTILITIES_PUB.Value_NULL(p_Measure_Rec.Measure_id)
748: = FND_API.G_TRUE) then
749: BIS_MEASURE_PVT.Measure_Value_ID_Conversion
750: ( p_api_version => p_api_version
751: , p_Measure_Rec => p_Measure_Rec

Line 774: IF (BIS_UTILITIES_PUB.Value_Not_Missing

770: RAISE FND_API.G_EXC_ERROR;
771: END IF;
772:
773:
774: IF (BIS_UTILITIES_PUB.Value_Not_Missing
775: (p_Org_Dimension_Short_Name) = FND_API.G_TRUE
776: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
777: = FND_API.G_TRUE) then
778: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 776: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)

772:
773:
774: IF (BIS_UTILITIES_PUB.Value_Not_Missing
775: (p_Org_Dimension_Short_Name) = FND_API.G_TRUE
776: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
777: = FND_API.G_TRUE) then
778: BIS_DIMENSION_PVT.Value_ID_Conversion
779: ( p_api_version => p_api_version
780: , p_Dimension_Short_Name => p_Org_Dimension_Short_Name

Line 794: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE

790:
791: END IF;
792:
793: -- added this call for getting Time Dimension Id
794: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
795: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
796: = FND_API.G_TRUE) THEN
797: BIS_DIMENSION_PVT.Value_ID_Conversion
798: ( p_api_version => p_api_version

Line 795: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)

791: END IF;
792:
793: -- added this call for getting Time Dimension Id
794: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
795: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
796: = FND_API.G_TRUE) THEN
797: BIS_DIMENSION_PVT.Value_ID_Conversion
798: ( p_api_version => p_api_version
799: , p_Dimension_Short_Name => p_Time_Dimension_Short_Name

Line 840: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Org_Dimension_Short_Name) = FND_API.G_TRUE

836: RAISE FND_API.G_EXC_ERROR;
837: END IF;
838:
839: -- added this call for getting Org Dimension Id
840: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Org_Dimension_Short_Name) = FND_API.G_TRUE
841: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
842: = FND_API.G_TRUE) THEN
843: BIS_DIMENSION_PVT.Value_ID_Conversion
844: ( p_api_version => p_api_version

Line 841: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)

837: END IF;
838:
839: -- added this call for getting Org Dimension Id
840: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Org_Dimension_Short_Name) = FND_API.G_TRUE
841: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Org_Dimension_Short_Name)
842: = FND_API.G_TRUE) THEN
843: BIS_DIMENSION_PVT.Value_ID_Conversion
844: ( p_api_version => p_api_version
845: , p_Dimension_Short_Name => p_Org_Dimension_Short_Name

Line 859: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE

855:
856: END IF;
857:
858: -- added this call for getting Time Dimension Id
859: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
860: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
861: = FND_API.G_TRUE) THEN
862:
863: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 860: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)

856: END IF;
857:
858: -- added this call for getting Time Dimension Id
859: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Time_Dimension_Short_Name) = FND_API.G_TRUE
860: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_Time_Dimension_Short_Name)
861: = FND_API.G_TRUE) THEN
862:
863: BIS_DIMENSION_PVT.Value_ID_Conversion
864: ( p_api_version => p_api_version

Line 895: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

891: END IF;
892:
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897: when FND_API.G_EXC_ERROR then
898: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
899: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 898: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

894: WHEN NO_DATA_FOUND THEN
895: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897: when FND_API.G_EXC_ERROR then
898: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
899: x_return_status := FND_API.G_RET_STS_ERROR ;
900: when FND_API.G_EXC_UNEXPECTED_ERROR then
901: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 901: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

897: when FND_API.G_EXC_ERROR then
898: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
899: x_return_status := FND_API.G_RET_STS_ERROR ;
900: when FND_API.G_EXC_UNEXPECTED_ERROR then
901: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: when others then
904: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 904: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

900: when FND_API.G_EXC_UNEXPECTED_ERROR then
901: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: when others then
904: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
906: l_error_tbl := x_error_tbl;
907: BIS_UTILITIES_PVT.Add_Error_Message
908: ( p_error_msg_id => SQLCODE

Line 935: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

931: Procedure Translate_Measure_By_lang
932: ( p_api_version IN NUMBER
933: , p_commit IN VARCHAR2 := FND_API.G_FALSE
934: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
935: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
936: , p_lang IN VARCHAR2
937: , p_source_lang IN VARCHAR2
938: , x_return_status OUT NOCOPY VARCHAR2
939: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 939: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

935: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
936: , p_lang IN VARCHAR2
937: , p_source_lang IN VARCHAR2
938: , x_return_status OUT NOCOPY VARCHAR2
939: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
940: )
941: IS
942:
943: BEGIN