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_DIMENSION_PVT dependencies on BIS_UTILITIES_PVT

Line 102: := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_rec.Dimension_ID);

98: IS
99: BEGIN
100:
101: x_Dimension_rec.Dimension_ID
102: := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_rec.Dimension_ID);
103: x_Dimension_rec.Dimension_Short_Name
104: := BIS_UTILITIES_PVT.CheckMissChar
105: (p_Dimension_rec.Dimension_Short_Name);
106: x_Dimension_rec.Dimension_Name

Line 104: := BIS_UTILITIES_PVT.CheckMissChar

100:
101: x_Dimension_rec.Dimension_ID
102: := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_rec.Dimension_ID);
103: x_Dimension_rec.Dimension_Short_Name
104: := BIS_UTILITIES_PVT.CheckMissChar
105: (p_Dimension_rec.Dimension_Short_Name);
106: x_Dimension_rec.Dimension_Name
107: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Dimension_Name);
108: x_Dimension_rec.Description

Line 107: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Dimension_Name);

103: x_Dimension_rec.Dimension_Short_Name
104: := BIS_UTILITIES_PVT.CheckMissChar
105: (p_Dimension_rec.Dimension_Short_Name);
106: x_Dimension_rec.Dimension_Name
107: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Dimension_Name);
108: x_Dimension_rec.Description
109: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Description);
110: x_Dimension_rec.Application_ID
111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);

Line 109: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Description);

105: (p_Dimension_rec.Dimension_Short_Name);
106: x_Dimension_rec.Dimension_Name
107: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Dimension_Name);
108: x_Dimension_rec.Description
109: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Description);
110: x_Dimension_rec.Application_ID
111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);
112: x_Dimension_rec.dim_grp_id
113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);

Line 111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);

107: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Dimension_Name);
108: x_Dimension_rec.Description
109: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Description);
110: x_Dimension_rec.Application_ID
111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);
112: x_Dimension_rec.dim_grp_id
113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);
114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);

Line 113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);

109: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Description);
110: x_Dimension_rec.Application_ID
111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);
112: x_Dimension_rec.dim_grp_id
113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);
114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);

Line 115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);

111: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.Application_ID);
112: x_Dimension_rec.dim_grp_id
113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);
114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);

Line 116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);

112: x_Dimension_rec.dim_grp_id
113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);
114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);

Line 117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);

113: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.dim_grp_id);
114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);
121:

Line 118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);

114: x_Dimension_rec.hide
115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);
121:
122: EXCEPTION

Line 119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);

115: := BIS_UTILITIES_PVT.CheckMissChar(p_Dimension_rec.hide);
116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN

Line 120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);

116: x_Dimension_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Created_By);
117: x_Dimension_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Creation_Date);
118: x_Dimension_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Updated_By);
119: x_Dimension_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_Dimension_Rec.Last_Update_Date);
120: x_Dimension_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_Dimension_Rec.Last_Update_Login);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: RAISE;

Line 220: BIS_UTILITIES_PVT.Add_Error_Message

216: --RAISE;
217: WHEN OTHERS THEN
218: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
219: l_error_tbl := x_error_tbl;
220: BIS_UTILITIES_PVT.Add_Error_Message
221: ( p_error_table => l_error_tbl
222: , p_error_msg_id => SQLCODE
223: , p_error_description => SQLERRM
224: , x_error_table => x_error_Tbl

Line 282: BIS_UTILITIES_PVT.Add_Error_Message

278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: l_error_tbl := x_error_tbl;
282: BIS_UTILITIES_PVT.Add_Error_Message
283: ( p_error_msg_id => SQLCODE
284: , p_error_description => SQLERRM
285: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimensions'
286: , p_error_table => l_error_tbl

Line 383: BIS_UTILITIES_PVT.Add_Error_Message

379:
380: ELSE
381: --added Add Error Message
382: l_error_tbl := x_error_tbl;
383: BIS_UTILITIES_PVT.Add_Error_Message
384: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
385: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
386: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension'
387: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 397: BIS_UTILITIES_PVT.Add_Error_Message

393:
394: --added this check
395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
396: l_error_tbl := x_error_tbl;
397: BIS_UTILITIES_PVT.Add_Error_Message
398: ( p_error_msg_name => 'BIS_INVALID_DIMENSION__VALUE'
399: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
400: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension'
401: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 424: BIS_UTILITIES_PVT.Add_Error_Message

420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
422: l_error_tbl := x_error_tbl;
423: -- added last two parameters
424: BIS_UTILITIES_PVT.Add_Error_Message
425: ( p_error_msg_id => SQLCODE
426: , p_error_description => SQLERRM
427: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension'
428: , p_error_table => l_error_tbl

Line 464: BIS_UTILITIES_PVT.Add_Error_Message (

460: EXCEPTION
461: WHEN OTHERS THEN
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: l_error_tbl := x_error_tbl;
464: BIS_UTILITIES_PVT.Add_Error_Message (
465: p_error_msg_id => SQLCODE
466: , p_error_description => SQLERRM
467: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
468: , p_error_table => l_error_tbl

Line 513: BIS_UTILITIES_PVT.Add_Error_Message

509: );
510:
511: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
512: l_error_tbl := x_error_tbl;
513: BIS_UTILITIES_PVT.Add_Error_Message
514: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
515: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
516: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
517: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 570: BIS_UTILITIES_PVT.Add_Error_Message

566: EXCEPTION
567: WHEN DUPLICATE_DIMENSION_VALUE THEN
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: l_error_tbl := x_error_tbl;
570: BIS_UTILITIES_PVT.Add_Error_Message
571: ( p_error_msg_name => 'BIS_DIMENSION_UNIQUENESS_ERROR'
572: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
573: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
574: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 591: BIS_UTILITIES_PVT.Add_Error_Message

587:
588: WHEN OTHERS THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: l_error_tbl := x_error_tbl;
591: BIS_UTILITIES_PVT.Add_Error_Message
592: ( p_error_msg_id => SQLCODE
593: , p_error_description => SQLERRM
594: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
595: , p_error_table => l_error_tbl

Line 741: BIS_UTILITIES_PVT.Add_Error_Message

737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: --added last two parameters
740: l_error_tbl := x_error_tbl;
741: BIS_UTILITIES_PVT.Add_Error_Message
742: ( p_error_msg_id => SQLCODE
743: , p_error_description => SQLERRM
744: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
745: , p_error_table => l_error_tbl

Line 793: BIS_UTILITIES_PVT.Add_Error_Message

789:
790: --added Add_Error_Message
791: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
792: l_error_tbl := x_error_tbl;
793: BIS_UTILITIES_PVT.Add_Error_Message
794: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_ID'
795: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
796: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
797: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 840: BIS_UTILITIES_PVT.Add_Error_Message

836: EXCEPTION
837: WHEN DUPLICATE_DIMENSION_VALUE THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839: l_error_tbl := x_error_tbl;
840: BIS_UTILITIES_PVT.Add_Error_Message
841: ( p_error_msg_name => 'BIS_DIMENSION_UNIQUENESS_ERROR'
842: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
843: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
844: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 860: BIS_UTILITIES_PVT.Add_Error_Message

856: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: l_error_tbl := x_error_tbl;
860: BIS_UTILITIES_PVT.Add_Error_Message
861: ( p_error_msg_id => SQLCODE
862: , p_error_description => SQLERRM
863: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension'
864: , p_error_table => l_error_tbl

Line 902: BIS_UTILITIES_PVT.Add_Error_Message

898: EXCEPTION
899: WHEN OTHERS THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
901: l_error_tbl := x_error_tbl;
902: BIS_UTILITIES_PVT.Add_Error_Message
903: ( p_error_msg_id => SQLCODE
904: , p_error_description => SQLERRM
905: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension'
906: , p_error_table => l_error_tbl

Line 987: BIS_UTILITIES_PVT.Add_Error_Message

983: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
986: l_error_tbl := x_error_tbl;
987: BIS_UTILITIES_PVT.Add_Error_Message
988: ( p_error_msg_id => SQLCODE
989: , p_error_description => SQLERRM
990: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension'
991: , p_error_table => l_error_tbl

Line 1024: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p

1020:
1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: l_error_tbl_p := x_error_tbl;
1024: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p
1025: , l_error_Tbl
1026: , x_error_tbl
1027: );
1028: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1049: BIS_UTILITIES_PVT.Add_Error_Message

1045: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: WHEN OTHERS THEN
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1048: l_error_tbl_p := x_error_tbl;
1049: BIS_UTILITIES_PVT.Add_Error_Message
1050: ( p_error_msg_id => SQLCODE
1051: , p_error_description => SQLERRM
1052: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension'
1053: , p_error_table => l_error_tbl_p

Line 1099: BIS_UTILITIES_PVT.Add_Error_Message

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

Line 1134: BIS_UTILITIES_PVT.Add_Error_Message

1130: FROM bis_dimensions_vl
1131: WHERE name = p_Dimension_Name;
1132: else
1133: l_error_tbl := x_error_tbl;
1134: BIS_UTILITIES_PVT.Add_Error_Message
1135: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
1136: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1137: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1138: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1157: BIS_UTILITIES_PVT.Add_Error_Message

1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: WHEN OTHERS THEN
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: l_error_tbl := x_error_tbl;
1157: BIS_UTILITIES_PVT.Add_Error_Message
1158: ( p_error_msg_id => SQLCODE
1159: , p_error_description => SQLERRM
1160: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1161: , p_error_table => l_error_tbl

Line 1268: BIS_UTILITIES_PVT.Add_Error_Message

1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: ROLLBACK TO DeleteFromBISDims;
1266: WHEN OTHERS THEN
1267: l_error_tbl := x_error_tbl;
1268: BIS_UTILITIES_PVT.Add_Error_Message
1269: ( p_error_msg_id => SQLCODE
1270: , p_error_description => SQLERRM
1271: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension'
1272: , p_error_table => l_error_tbl

Line 1333: BIS_UTILITIES_PVT.Add_Error_Message

1329: ROLLBACK TO TransDimByLangPvt;
1330: WHEN OTHERS THEN
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1332: l_error_tbl := x_error_tbl;
1333: BIS_UTILITIES_PVT.Add_Error_Message
1334: ( p_error_msg_id => SQLCODE
1335: , p_error_description => SQLERRM
1336: , p_error_proc_name => G_PKG_NAME||'.Translate_Dim_By_Given_Lang'
1337: , p_error_table => l_error_tbl