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_ACTUAL_VALIDATE_PVT dependencies on FND_API

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

22: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_ACTUAL_VALIDATE_PVT';
23: --
24: PROCEDURE Validate_Target_Level_ID
25: ( p_api_version IN NUMBER
26: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
30: )

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
37: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
38: --
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42: -- dbms_output.put_line( 'p_ACTUAL_Rec.TARGET_LEVEL_ID = '
43: -- || p_ACTUAL_Rec.TARGET_LEVEL_ID
44: -- );

Line 49: = FND_API.G_TRUE

45:
46: l_Actual_Rec := p_Actual_Rec;
47: --
48: IF( BIS_UTILITIES_PUB.Value_Missing(l_ACTUAL_Rec.TARGET_LEVEL_ID)
49: = FND_API.G_TRUE
50: ) THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSE
53: l_target_level_rec.Target_Level_ID := l_actual_rec.Target_Level_ID;

Line 51: RAISE FND_API.G_EXC_ERROR;

47: --
48: IF( BIS_UTILITIES_PUB.Value_Missing(l_ACTUAL_Rec.TARGET_LEVEL_ID)
49: = FND_API.G_TRUE
50: ) THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSE
53: l_target_level_rec.Target_Level_ID := l_actual_rec.Target_Level_ID;
54: l_Target_Level_rec_p := l_Target_Level_rec;
55: BIS_Target_Level_PVT.Retrieve_Target_Level

Line 58: , p_all_info => FND_API.G_FALSE

54: l_Target_Level_rec_p := l_Target_Level_rec;
55: BIS_Target_Level_PVT.Retrieve_Target_Level
56: ( p_api_version => p_api_version
57: , p_Target_Level_rec => l_Target_Level_rec_p
58: , p_all_info => FND_API.G_FALSE
59: , x_Target_Level_rec => l_Target_Level_rec
60: , x_return_status => x_return_status
61: , x_error_Tbl => x_error_Tbl
62: );

Line 76: x_return_status:= FND_API.G_RET_STS_ERROR;

72:
73: --commented out NOCOPY RAISE
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: x_return_status:= FND_API.G_RET_STS_ERROR;
77: --RAISE FND_API.G_EXC_ERROR;
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;

Line 77: --RAISE FND_API.G_EXC_ERROR;

73: --commented out NOCOPY RAISE
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: x_return_status:= FND_API.G_RET_STS_ERROR;
77: --RAISE FND_API.G_EXC_ERROR;
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 78: WHEN FND_API.G_EXC_ERROR THEN

74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN
76: x_return_status:= FND_API.G_RET_STS_ERROR;
77: --RAISE FND_API.G_EXC_ERROR;
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 79: x_return_status:= FND_API.G_RET_STS_ERROR;

75: WHEN NO_DATA_FOUND THEN
76: x_return_status:= FND_API.G_RET_STS_ERROR;
77: --RAISE FND_API.G_EXC_ERROR;
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
83: --RAISE;

Line 81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

77: --RAISE FND_API.G_EXC_ERROR;
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
83: --RAISE;
84: WHEN OTHERS THEN
85: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status:= FND_API.G_RET_STS_ERROR;
80: -- RAISE;
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
83: --RAISE;
84: WHEN OTHERS THEN
85: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
86: l_error_tbl := x_error_Tbl;

Line 85: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
83: --RAISE;
84: WHEN OTHERS THEN
85: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
86: l_error_tbl := x_error_Tbl;
87: BIS_UTILITIES_PVT.Add_Error_Message
88: ( p_error_table => l_error_Tbl
89: , p_error_msg_id => SQLCODE

Line 93: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: , p_error_msg_id => SQLCODE
90: , p_error_description => SQLERRM
91: , x_error_table => x_error_Tbl
92: );
93: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: END Validate_Target_Level_ID;
95: --
96: --
97: /*

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

96: --
97: /*
98: PROCEDURE Validate_Time_Level_Value_ID
99: ( p_api_version IN NUMBER
100: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
101: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104: )

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109: l_Org_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
110: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
111: --
112: BEGIN
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: --
115: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.Time_Level_Value_ID)
116: = FND_API.G_TRUE
117: ) THEN

Line 116: = FND_API.G_TRUE

112: BEGIN
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: --
115: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.Time_Level_Value_ID)
116: = FND_API.G_TRUE
117: ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE
120: -- do validation here

Line 118: RAISE FND_API.G_EXC_ERROR;

114: --
115: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.Time_Level_Value_ID)
116: = FND_API.G_TRUE
117: ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE
120: -- do validation here
121: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
122:

Line 126: , p_all_info => FND_API.G_FALSE

122:
123: BIS_Target_Level_PVT.Retrieve_Target_Level
124: ( p_api_version => p_api_version
125: , p_Target_Level_rec => l_bisbv_target_levels
126: , p_all_info => FND_API.G_FALSE
127: , x_Target_Level_rec => l_bisbv_target_levels
128: , x_return_status => x_return_status
129: , x_error_Tbl => x_error_Tbl
130: );

Line 159: x_return_status:= FND_API.G_RET_STS_ERROR;

155: --
156: --commented out NOCOPY RAISE
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: x_return_status:= FND_API.G_RET_STS_ERROR;
160: --RAISE FND_API.G_EXC_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;

Line 160: --RAISE FND_API.G_EXC_ERROR;

156: --commented out NOCOPY RAISE
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: x_return_status:= FND_API.G_RET_STS_ERROR;
160: --RAISE FND_API.G_EXC_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN
159: x_return_status:= FND_API.G_RET_STS_ERROR;
160: --RAISE FND_API.G_EXC_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 162: x_return_status:= FND_API.G_RET_STS_ERROR;

158: WHEN NO_DATA_FOUND THEN
159: x_return_status:= FND_API.G_RET_STS_ERROR;
160: --RAISE FND_API.G_EXC_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
166: --RAISE;

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: --RAISE FND_API.G_EXC_ERROR;
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
166: --RAISE;
167: WHEN OTHERS THEN
168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status:= FND_API.G_RET_STS_ERROR;
163: --RAISE;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
166: --RAISE;
167: WHEN OTHERS THEN
168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
169: BIS_UTILITIES_PVT.Add_Error_Message

Line 168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
166: --RAISE;
167: WHEN OTHERS THEN
168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
169: BIS_UTILITIES_PVT.Add_Error_Message
170: ( p_error_table => x_error_Tbl
171: , p_error_msg_id => SQLCODE
172: , p_error_description => SQLERRM

Line 175: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: , p_error_msg_id => SQLCODE
172: , p_error_description => SQLERRM
173: , x_error_table => x_error_Tbl
174: );
175: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END Validate_Time_Level_Value_ID;
177: --
178: --
179: PROCEDURE Validate_Org_Level_Value_ID

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

177: --
178: --
179: PROCEDURE Validate_Org_Level_Value_ID
180: ( p_api_version IN NUMBER
181: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
182: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
183: , x_return_status OUT NOCOPY VARCHAR2
184: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
185: )

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: l_bisbv_target_levels BIS_Target_Level_PUB.Target_Level_Rec_Type;
190: l_Dim_Level_Value_Rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
191: --
192: BEGIN
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: --
195: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ORG_LEVEL_VALUE_ID)
196: = FND_API.G_TRUE
197: ) THEN

Line 196: = FND_API.G_TRUE

192: BEGIN
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194: --
195: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ORG_LEVEL_VALUE_ID)
196: = FND_API.G_TRUE
197: ) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: ELSE
200: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;

Line 198: RAISE FND_API.G_EXC_ERROR;

194: --
195: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ORG_LEVEL_VALUE_ID)
196: = FND_API.G_TRUE
197: ) THEN
198: RAISE FND_API.G_EXC_ERROR;
199: ELSE
200: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
201:
202: BIS_Target_Level_PVT.Retrieve_Target_Level

Line 205: , p_all_info => FND_API.G_FALSE

201:
202: BIS_Target_Level_PVT.Retrieve_Target_Level
203: ( p_api_version => p_api_version
204: , p_Target_Level_rec => l_bisbv_target_levels
205: , p_all_info => FND_API.G_FALSE
206: , x_Target_Level_rec => l_bisbv_target_levels
207: , x_return_status => x_return_status
208: , x_error_Tbl => x_error_Tbl
209: );

Line 237: x_return_status:= FND_API.G_RET_STS_ERROR;

233:
234: --commented out NOCOPY RAISE
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: x_return_status:= FND_API.G_RET_STS_ERROR;
238: --RAISE FND_API.G_EXC_ERROR;
239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;

Line 238: --RAISE FND_API.G_EXC_ERROR;

234: --commented out NOCOPY RAISE
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: x_return_status:= FND_API.G_RET_STS_ERROR;
238: --RAISE FND_API.G_EXC_ERROR;
239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 239: WHEN FND_API.G_EXC_ERROR THEN

235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: x_return_status:= FND_API.G_RET_STS_ERROR;
238: --RAISE FND_API.G_EXC_ERROR;
239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 240: x_return_status:= FND_API.G_RET_STS_ERROR;

236: WHEN NO_DATA_FOUND THEN
237: x_return_status:= FND_API.G_RET_STS_ERROR;
238: --RAISE FND_API.G_EXC_ERROR;
239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
244: -- RAISE;

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238: --RAISE FND_API.G_EXC_ERROR;
239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
244: -- RAISE;
245: WHEN OTHERS THEN
246: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

239: WHEN FND_API.G_EXC_ERROR THEN
240: x_return_status:= FND_API.G_RET_STS_ERROR;
241: -- RAISE;
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
244: -- RAISE;
245: WHEN OTHERS THEN
246: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
247: BIS_UTILITIES_PVT.Add_Error_Message

Line 246: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
244: -- RAISE;
245: WHEN OTHERS THEN
246: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
247: BIS_UTILITIES_PVT.Add_Error_Message
248: ( p_error_table => x_error_Tbl
249: , p_error_msg_id => SQLCODE
250: , p_error_description => SQLERRM

Line 253: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: , p_error_msg_id => SQLCODE
250: , p_error_description => SQLERRM
251: , x_error_table => x_error_Tbl
252: );
253: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END Validate_Org_Level_Value_ID;
255: */
256: --
257: --

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

256: --
257: --
258: PROCEDURE Validate_Dim1_Level_Value_ID
259: ( p_api_version IN NUMBER
260: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
261: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
262: , x_return_status OUT NOCOPY VARCHAR2
263: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
264: )

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
272: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
273: --
274: BEGIN
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: --
277: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
278: l_bisbv_target_levels_p := l_bisbv_target_levels;
279: BIS_Target_Level_PVT.Retrieve_Target_Level

Line 282: , p_all_info => FND_API.G_FALSE

278: l_bisbv_target_levels_p := l_bisbv_target_levels;
279: BIS_Target_Level_PVT.Retrieve_Target_Level
280: ( p_api_version => p_api_version
281: , p_Target_Level_rec => l_bisbv_target_levels_p
282: , p_all_info => FND_API.G_FALSE
283: , x_Target_Level_rec => l_bisbv_target_levels
284: , x_return_status => x_return_status
285: , x_error_Tbl => x_error_Tbl
286: );

Line 314: x_return_status:= FND_API.G_RET_STS_ERROR;

310: --
311: --commented out NOCOPY RAISE
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: x_return_status:= FND_API.G_RET_STS_ERROR;
315: --RAISE FND_API.G_EXC_ERROR;
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;

Line 315: --RAISE FND_API.G_EXC_ERROR;

311: --commented out NOCOPY RAISE
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: x_return_status:= FND_API.G_RET_STS_ERROR;
315: --RAISE FND_API.G_EXC_ERROR;
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 316: WHEN FND_API.G_EXC_ERROR THEN

312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN
314: x_return_status:= FND_API.G_RET_STS_ERROR;
315: --RAISE FND_API.G_EXC_ERROR;
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 317: x_return_status:= FND_API.G_RET_STS_ERROR;

313: WHEN NO_DATA_FOUND THEN
314: x_return_status:= FND_API.G_RET_STS_ERROR;
315: --RAISE FND_API.G_EXC_ERROR;
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
321: --RAISE;

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: --RAISE FND_API.G_EXC_ERROR;
316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
321: --RAISE;
322: WHEN OTHERS THEN
323: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

316: WHEN FND_API.G_EXC_ERROR THEN
317: x_return_status:= FND_API.G_RET_STS_ERROR;
318: -- RAISE;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
321: --RAISE;
322: WHEN OTHERS THEN
323: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
324: l_error_tbl := x_error_Tbl;

Line 323: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
321: --RAISE;
322: WHEN OTHERS THEN
323: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
324: l_error_tbl := x_error_Tbl;
325: BIS_UTILITIES_PVT.Add_Error_Message
326: ( p_error_table => l_error_Tbl
327: , p_error_msg_id => SQLCODE

Line 331: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: , p_error_msg_id => SQLCODE
328: , p_error_description => SQLERRM
329: , x_error_table => x_error_Tbl
330: );
331: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END Validate_Dim1_Level_Value_ID;
333: --
334: --
335: PROCEDURE Validate_Dim2_Level_Value_ID

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

333: --
334: --
335: PROCEDURE Validate_Dim2_Level_Value_ID
336: ( p_api_version IN NUMBER
337: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
338: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
339: , x_return_status OUT NOCOPY VARCHAR2
340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
341: )

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
349: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
350: --
351: BEGIN
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: --
354: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
355:
356: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 360: , p_all_info => FND_API.G_FALSE

356: l_bisbv_target_levels_p := l_bisbv_target_levels;
357: BIS_Target_Level_PVT.Retrieve_Target_Level
358: ( p_api_version => p_api_version
359: , p_Target_Level_rec => l_bisbv_target_levels_p
360: , p_all_info => FND_API.G_FALSE
361: , x_Target_Level_rec => l_bisbv_target_levels
362: , x_return_status => x_return_status
363: , x_error_Tbl => x_error_Tbl
364: );

Line 394: x_return_status:= FND_API.G_RET_STS_ERROR;

390:
391: --commented out NOCOPY RAISE
392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: x_return_status:= FND_API.G_RET_STS_ERROR;
395: --RAISE FND_API.G_EXC_ERROR;
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;

Line 395: --RAISE FND_API.G_EXC_ERROR;

391: --commented out NOCOPY RAISE
392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: x_return_status:= FND_API.G_RET_STS_ERROR;
395: --RAISE FND_API.G_EXC_ERROR;
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: EXCEPTION
393: WHEN NO_DATA_FOUND THEN
394: x_return_status:= FND_API.G_RET_STS_ERROR;
395: --RAISE FND_API.G_EXC_ERROR;
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 397: x_return_status:= FND_API.G_RET_STS_ERROR;

393: WHEN NO_DATA_FOUND THEN
394: x_return_status:= FND_API.G_RET_STS_ERROR;
395: --RAISE FND_API.G_EXC_ERROR;
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
401: --RAISE;

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

395: --RAISE FND_API.G_EXC_ERROR;
396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
401: --RAISE;
402: WHEN OTHERS THEN
403: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

396: WHEN FND_API.G_EXC_ERROR THEN
397: x_return_status:= FND_API.G_RET_STS_ERROR;
398: -- RAISE;
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
401: --RAISE;
402: WHEN OTHERS THEN
403: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
404: l_error_tbl := x_error_Tbl;

Line 403: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
401: --RAISE;
402: WHEN OTHERS THEN
403: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
404: l_error_tbl := x_error_Tbl;
405: BIS_UTILITIES_PVT.Add_Error_Message
406: ( p_error_table => l_error_Tbl
407: , p_error_msg_id => SQLCODE

Line 411: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: , p_error_msg_id => SQLCODE
408: , p_error_description => SQLERRM
409: , x_error_table => x_error_Tbl
410: );
411: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END Validate_Dim2_Level_Value_ID;
413: --
414: --
415: PROCEDURE Validate_Dim3_Level_Value_ID

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

413: --
414: --
415: PROCEDURE Validate_Dim3_Level_Value_ID
416: ( p_api_version IN NUMBER
417: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
418: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
419: , x_return_status OUT NOCOPY VARCHAR2
420: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
421: )

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
429: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
430: --
431: BEGIN
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: --
434: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
435:
436: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 440: , p_all_info => FND_API.G_FALSE

436: l_bisbv_target_levels_p := l_bisbv_target_levels;
437: BIS_Target_Level_PVT.Retrieve_Target_Level
438: ( p_api_version => p_api_version
439: , p_Target_Level_rec => l_bisbv_target_levels_p
440: , p_all_info => FND_API.G_FALSE
441: , x_Target_Level_rec => l_bisbv_target_levels
442: , x_return_status => x_return_status
443: , x_error_Tbl => x_error_Tbl
444: );

Line 473: x_return_status:= FND_API.G_RET_STS_ERROR;

469:
470: --commented out NOCOPY RAISE
471: EXCEPTION
472: WHEN NO_DATA_FOUND THEN
473: x_return_status:= FND_API.G_RET_STS_ERROR;
474: --RAISE FND_API.G_EXC_ERROR;
475: WHEN FND_API.G_EXC_ERROR THEN
476: x_return_status:= FND_API.G_RET_STS_ERROR;
477: -- RAISE;

Line 474: --RAISE FND_API.G_EXC_ERROR;

470: --commented out NOCOPY RAISE
471: EXCEPTION
472: WHEN NO_DATA_FOUND THEN
473: x_return_status:= FND_API.G_RET_STS_ERROR;
474: --RAISE FND_API.G_EXC_ERROR;
475: WHEN FND_API.G_EXC_ERROR THEN
476: x_return_status:= FND_API.G_RET_STS_ERROR;
477: -- RAISE;
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 475: WHEN FND_API.G_EXC_ERROR THEN

471: EXCEPTION
472: WHEN NO_DATA_FOUND THEN
473: x_return_status:= FND_API.G_RET_STS_ERROR;
474: --RAISE FND_API.G_EXC_ERROR;
475: WHEN FND_API.G_EXC_ERROR THEN
476: x_return_status:= FND_API.G_RET_STS_ERROR;
477: -- RAISE;
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 476: x_return_status:= FND_API.G_RET_STS_ERROR;

472: WHEN NO_DATA_FOUND THEN
473: x_return_status:= FND_API.G_RET_STS_ERROR;
474: --RAISE FND_API.G_EXC_ERROR;
475: WHEN FND_API.G_EXC_ERROR THEN
476: x_return_status:= FND_API.G_RET_STS_ERROR;
477: -- RAISE;
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
480: --RAISE;

Line 478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 479: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

475: WHEN FND_API.G_EXC_ERROR THEN
476: x_return_status:= FND_API.G_RET_STS_ERROR;
477: -- RAISE;
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
480: --RAISE;
481: WHEN OTHERS THEN
482: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
483: l_error_tbl := x_error_Tbl;

Line 482: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
480: --RAISE;
481: WHEN OTHERS THEN
482: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
483: l_error_tbl := x_error_Tbl;
484: BIS_UTILITIES_PVT.Add_Error_Message
485: ( p_error_table => l_error_Tbl
486: , p_error_msg_id => SQLCODE

Line 490: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486: , p_error_msg_id => SQLCODE
487: , p_error_description => SQLERRM
488: , x_error_table => x_error_Tbl
489: );
490: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END Validate_Dim3_Level_Value_ID;
492: --
493: --
494: PROCEDURE Validate_Dim4_Level_Value_ID

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

492: --
493: --
494: PROCEDURE Validate_Dim4_Level_Value_ID
495: ( p_api_version IN NUMBER
496: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
497: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
498: , x_return_status OUT NOCOPY VARCHAR2
499: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
500: )

Line 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
508: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
509: --
510: BEGIN
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: --
513: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
514:
515: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 519: , p_all_info => FND_API.G_FALSE

515: l_bisbv_target_levels_p := l_bisbv_target_levels;
516: BIS_Target_Level_PVT.Retrieve_Target_Level
517: ( p_api_version => p_api_version
518: , p_Target_Level_rec => l_bisbv_target_levels_p
519: , p_all_info => FND_API.G_FALSE
520: , x_Target_Level_rec => l_bisbv_target_levels
521: , x_return_status => x_return_status
522: , x_error_Tbl => x_error_Tbl
523: );

Line 551: x_return_status:= FND_API.G_RET_STS_ERROR;

547: --
548: --commented out NOCOPY RAISE
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: --RAISE FND_API.G_EXC_ERROR;
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;

Line 552: --RAISE FND_API.G_EXC_ERROR;

548: --commented out NOCOPY RAISE
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: --RAISE FND_API.G_EXC_ERROR;
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: --RAISE FND_API.G_EXC_ERROR;
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 554: x_return_status:= FND_API.G_RET_STS_ERROR;

550: WHEN NO_DATA_FOUND THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: --RAISE FND_API.G_EXC_ERROR;
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
558: --RAISE;

Line 556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

552: --RAISE FND_API.G_EXC_ERROR;
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
558: --RAISE;
559: WHEN OTHERS THEN
560: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status:= FND_API.G_RET_STS_ERROR;
555: --RAISE;
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
558: --RAISE;
559: WHEN OTHERS THEN
560: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
561: l_error_tbl := x_error_Tbl;

Line 560: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
558: --RAISE;
559: WHEN OTHERS THEN
560: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
561: l_error_tbl := x_error_Tbl;
562: BIS_UTILITIES_PVT.Add_Error_Message
563: ( p_error_table => l_error_Tbl
564: , p_error_msg_id => SQLCODE

Line 568: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

564: , p_error_msg_id => SQLCODE
565: , p_error_description => SQLERRM
566: , x_error_table => x_error_Tbl
567: );
568: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
569: END Validate_Dim4_Level_Value_ID;
570: --
571: --
572: PROCEDURE Validate_Dim5_Level_Value_ID

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

570: --
571: --
572: PROCEDURE Validate_Dim5_Level_Value_ID
573: ( p_api_version IN NUMBER
574: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
575: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
576: , x_return_status OUT NOCOPY VARCHAR2
577: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
578: )

Line 589: x_return_status := FND_API.G_RET_STS_SUCCESS;

585: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
586: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
587: --
588: BEGIN
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590: --
591: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
592:
593: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 597: , p_all_info => FND_API.G_FALSE

593: l_bisbv_target_levels_p := l_bisbv_target_levels;
594: BIS_Target_Level_PVT.Retrieve_Target_Level
595: ( p_api_version => p_api_version
596: , p_Target_Level_rec => l_bisbv_target_levels_p
597: , p_all_info => FND_API.G_FALSE
598: , x_Target_Level_rec => l_bisbv_target_levels
599: , x_return_status => x_return_status
600: , x_error_Tbl => x_error_Tbl
601: );

Line 630: x_return_status:= FND_API.G_RET_STS_ERROR;

626:
627: --commented out NOCOPY RAISE
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: x_return_status:= FND_API.G_RET_STS_ERROR;
631: -- RAISE FND_API.G_EXC_ERROR;
632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;

Line 631: -- RAISE FND_API.G_EXC_ERROR;

627: --commented out NOCOPY RAISE
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: x_return_status:= FND_API.G_RET_STS_ERROR;
631: -- RAISE FND_API.G_EXC_ERROR;
632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: x_return_status:= FND_API.G_RET_STS_ERROR;
631: -- RAISE FND_API.G_EXC_ERROR;
632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 633: x_return_status:= FND_API.G_RET_STS_ERROR;

629: WHEN NO_DATA_FOUND THEN
630: x_return_status:= FND_API.G_RET_STS_ERROR;
631: -- RAISE FND_API.G_EXC_ERROR;
632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
637: -- RAISE;

Line 635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

631: -- RAISE FND_API.G_EXC_ERROR;
632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
637: -- RAISE;
638: WHEN OTHERS THEN
639: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

632: WHEN FND_API.G_EXC_ERROR THEN
633: x_return_status:= FND_API.G_RET_STS_ERROR;
634: -- RAISE;
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
637: -- RAISE;
638: WHEN OTHERS THEN
639: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
640: l_error_tbl := x_error_Tbl;

Line 639: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
637: -- RAISE;
638: WHEN OTHERS THEN
639: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
640: l_error_tbl := x_error_Tbl;
641: BIS_UTILITIES_PVT.Add_Error_Message
642: ( p_error_table => l_error_Tbl
643: , p_error_msg_id => SQLCODE

Line 647: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

643: , p_error_msg_id => SQLCODE
644: , p_error_description => SQLERRM
645: , x_error_table => x_error_Tbl
646: );
647: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END Validate_Dim5_Level_Value_ID;
649: --
650: --
651: PROCEDURE Validate_Dim6_Level_Value_ID

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

649: --
650: --
651: PROCEDURE Validate_Dim6_Level_Value_ID
652: ( p_api_version IN NUMBER
653: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
654: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
655: , x_return_status OUT NOCOPY VARCHAR2
656: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
657: )

Line 668: x_return_status := FND_API.G_RET_STS_SUCCESS;

664: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
665: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
666: --
667: BEGIN
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: --
670: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
671:
672: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 676: , p_all_info => FND_API.G_FALSE

672: l_bisbv_target_levels_p := l_bisbv_target_levels;
673: BIS_Target_Level_PVT.Retrieve_Target_Level
674: ( p_api_version => p_api_version
675: , p_Target_Level_rec => l_bisbv_target_levels_p
676: , p_all_info => FND_API.G_FALSE
677: , x_Target_Level_rec => l_bisbv_target_levels
678: , x_return_status => x_return_status
679: , x_error_Tbl => x_error_Tbl
680: );

Line 709: x_return_status:= FND_API.G_RET_STS_ERROR;

705:
706: --commented out NOCOPY RAISE
707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: --RAISE FND_API.G_EXC_ERROR;
711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;

Line 710: --RAISE FND_API.G_EXC_ERROR;

706: --commented out NOCOPY RAISE
707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: --RAISE FND_API.G_EXC_ERROR;
711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 711: WHEN FND_API.G_EXC_ERROR THEN

707: EXCEPTION
708: WHEN NO_DATA_FOUND THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: --RAISE FND_API.G_EXC_ERROR;
711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 712: x_return_status:= FND_API.G_RET_STS_ERROR;

708: WHEN NO_DATA_FOUND THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: --RAISE FND_API.G_EXC_ERROR;
711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: --RAISE;

Line 714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

710: --RAISE FND_API.G_EXC_ERROR;
711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: --RAISE;
717: WHEN OTHERS THEN
718: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_ERROR;
713: --RAISE;
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: --RAISE;
717: WHEN OTHERS THEN
718: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
719: l_error_tbl := x_error_Tbl;

Line 718: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: --RAISE;
717: WHEN OTHERS THEN
718: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
719: l_error_tbl := x_error_Tbl;
720: BIS_UTILITIES_PVT.Add_Error_Message
721: ( p_error_table => l_error_Tbl
722: , p_error_msg_id => SQLCODE

Line 726: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: , p_error_msg_id => SQLCODE
723: , p_error_description => SQLERRM
724: , x_error_table => x_error_Tbl
725: );
726: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END Validate_Dim6_Level_Value_ID;
728: --
729: --
730: PROCEDURE Validate_Dim7_Level_Value_ID

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

728: --
729: --
730: PROCEDURE Validate_Dim7_Level_Value_ID
731: ( p_api_version IN NUMBER
732: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
733: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
734: , x_return_status OUT NOCOPY VARCHAR2
735: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
736: )

Line 747: x_return_status := FND_API.G_RET_STS_SUCCESS;

743: l_Dim_Level_Value_Rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
744: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
745: --
746: BEGIN
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748: --
749: l_bisbv_target_levels.Target_Level_ID := p_actual_rec.Target_Level_ID;
750:
751: l_bisbv_target_levels_p := l_bisbv_target_levels;

Line 755: , p_all_info => FND_API.G_FALSE

751: l_bisbv_target_levels_p := l_bisbv_target_levels;
752: BIS_Target_Level_PVT.Retrieve_Target_Level
753: ( p_api_version => p_api_version
754: , p_Target_Level_rec => l_bisbv_target_levels_p
755: , p_all_info => FND_API.G_FALSE
756: , x_Target_Level_rec => l_bisbv_target_levels
757: , x_return_status => x_return_status
758: , x_error_Tbl => x_error_Tbl
759: );

Line 788: x_return_status:= FND_API.G_RET_STS_ERROR;

784:
785: --commented out NOCOPY RAISE
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: x_return_status:= FND_API.G_RET_STS_ERROR;
789: --RAISE FND_API.G_EXC_ERROR;
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;

Line 789: --RAISE FND_API.G_EXC_ERROR;

785: --commented out NOCOPY RAISE
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: x_return_status:= FND_API.G_RET_STS_ERROR;
789: --RAISE FND_API.G_EXC_ERROR;
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 790: WHEN FND_API.G_EXC_ERROR THEN

786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: x_return_status:= FND_API.G_RET_STS_ERROR;
789: --RAISE FND_API.G_EXC_ERROR;
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 791: x_return_status:= FND_API.G_RET_STS_ERROR;

787: WHEN NO_DATA_FOUND THEN
788: x_return_status:= FND_API.G_RET_STS_ERROR;
789: --RAISE FND_API.G_EXC_ERROR;
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
795: --RAISE;

Line 793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

789: --RAISE FND_API.G_EXC_ERROR;
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
795: --RAISE;
796: WHEN OTHERS THEN
797: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status:= FND_API.G_RET_STS_ERROR;
792: --RAISE;
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
795: --RAISE;
796: WHEN OTHERS THEN
797: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
798: l_error_tbl := x_error_Tbl;

Line 797: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
795: --RAISE;
796: WHEN OTHERS THEN
797: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
798: l_error_tbl := x_error_Tbl;
799: BIS_UTILITIES_PVT.Add_Error_Message
800: ( p_error_table => l_error_Tbl
801: , p_error_msg_id => SQLCODE

Line 805: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: , p_error_msg_id => SQLCODE
802: , p_error_description => SQLERRM
803: , x_error_table => x_error_Tbl
804: );
805: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END Validate_Dim7_Level_Value_ID;
807: --
808: --
809: PROCEDURE Validate_ACTUAL_Value

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

807: --
808: --
809: PROCEDURE Validate_ACTUAL_Value
810: ( p_api_version IN NUMBER
811: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
812: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
813: , x_return_status OUT NOCOPY VARCHAR2
814: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
815: )

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: )
816: IS
817: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
818: BEGIN
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: --
821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)
822: = FND_API.G_TRUE
823: ) THEN

Line 822: = FND_API.G_TRUE

818: BEGIN
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: --
821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)
822: = FND_API.G_TRUE
823: ) THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE
826: NULL;

Line 824: RAISE FND_API.G_EXC_ERROR;

820: --
821: IF( BIS_UTILITIES_PUB.Value_Missing(p_ACTUAL_Rec.ACTUAL)
822: = FND_API.G_TRUE
823: ) THEN
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE
826: NULL;
827: END IF;
828: --

Line 831: WHEN FND_API.G_EXC_ERROR THEN

827: END IF;
828: --
829: --commented out NOCOPY RAISE
830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: x_return_status:= FND_API.G_RET_STS_ERROR;
833: --RAISE;
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 832: x_return_status:= FND_API.G_RET_STS_ERROR;

828: --
829: --commented out NOCOPY RAISE
830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: x_return_status:= FND_API.G_RET_STS_ERROR;
833: --RAISE;
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
836: --RAISE;

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: EXCEPTION
831: WHEN FND_API.G_EXC_ERROR THEN
832: x_return_status:= FND_API.G_RET_STS_ERROR;
833: --RAISE;
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
836: --RAISE;
837: WHEN OTHERS THEN
838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

831: WHEN FND_API.G_EXC_ERROR THEN
832: x_return_status:= FND_API.G_RET_STS_ERROR;
833: --RAISE;
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
836: --RAISE;
837: WHEN OTHERS THEN
838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
839: l_error_tbl := x_error_Tbl;

Line 838: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
836: --RAISE;
837: WHEN OTHERS 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_table => l_error_Tbl
842: , p_error_msg_id => SQLCODE

Line 846: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: , p_error_msg_id => SQLCODE
843: , p_error_description => SQLERRM
844: , x_error_table => x_error_Tbl
845: );
846: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END Validate_ACTUAL_Value;
848: --
849: --
850: PROCEDURE Validate_Record

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

848: --
849: --
850: PROCEDURE Validate_Record
851: ( p_api_version IN NUMBER
852: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
853: , p_ACTUAL_Rec IN BIS_ACTUAL_PUB.ACTUAL_Rec_Type
854: , x_return_status OUT NOCOPY VARCHAR2
855: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
856: )

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: )
857: IS
858: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
859: BEGIN
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861: --
862: -- commented out NOCOPY as they are changed now with the ranges being %
863: -- dont know exact validations yet
864: /*

Line 866: = FND_API.G_TRUE

862: -- commented out NOCOPY as they are changed now with the ranges being %
863: -- dont know exact validations yet
864: /*
865: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_LOW)
866: = FND_API.G_TRUE
867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)
868: = FND_API.G_TRUE
869: AND p_ACTUAL_Rec.RANGE1_LOW > p_ACTUAL_Rec.RANGE1_HIGH
870: ) THEN

Line 868: = FND_API.G_TRUE

864: /*
865: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_LOW)
866: = FND_API.G_TRUE
867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)
868: = FND_API.G_TRUE
869: AND p_ACTUAL_Rec.RANGE1_LOW > p_ACTUAL_Rec.RANGE1_HIGH
870: ) THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;

Line 871: RAISE FND_API.G_EXC_ERROR;

867: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE1_HIGH)
868: = FND_API.G_TRUE
869: AND p_ACTUAL_Rec.RANGE1_LOW > p_ACTUAL_Rec.RANGE1_HIGH
870: ) THEN
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: --
874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)
875: = FND_API.G_TRUE

Line 875: = FND_API.G_TRUE

871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873: --
874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)
875: = FND_API.G_TRUE
876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)
877: = FND_API.G_TRUE
878: AND p_ACTUAL_Rec.RANGE2_LOW > p_ACTUAL_Rec.RANGE2_HIGH
879: ) THEN

Line 877: = FND_API.G_TRUE

873: --
874: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_LOW)
875: = FND_API.G_TRUE
876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)
877: = FND_API.G_TRUE
878: AND p_ACTUAL_Rec.RANGE2_LOW > p_ACTUAL_Rec.RANGE2_HIGH
879: ) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;

Line 880: RAISE FND_API.G_EXC_ERROR;

876: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE2_HIGH)
877: = FND_API.G_TRUE
878: AND p_ACTUAL_Rec.RANGE2_LOW > p_ACTUAL_Rec.RANGE2_HIGH
879: ) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: --
883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)
884: = FND_API.G_TRUE

Line 884: = FND_API.G_TRUE

880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: --
883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)
884: = FND_API.G_TRUE
885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)
886: = FND_API.G_TRUE
887: AND p_ACTUAL_Rec.RANGE3_LOW > p_ACTUAL_Rec.RANGE3_HIGH
888: ) THEN

Line 886: = FND_API.G_TRUE

882: --
883: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_LOW)
884: = FND_API.G_TRUE
885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)
886: = FND_API.G_TRUE
887: AND p_ACTUAL_Rec.RANGE3_LOW > p_ACTUAL_Rec.RANGE3_HIGH
888: ) THEN
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;

Line 889: RAISE FND_API.G_EXC_ERROR;

885: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_ACTUAL_Rec.RANGE3_HIGH)
886: = FND_API.G_TRUE
887: AND p_ACTUAL_Rec.RANGE3_LOW > p_ACTUAL_Rec.RANGE3_HIGH
888: ) THEN
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: */
892: --
893: --commented out NOCOPY RAISE

Line 895: WHEN FND_API.G_EXC_ERROR THEN

891: */
892: --
893: --commented out NOCOPY RAISE
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_return_status:= FND_API.G_RET_STS_ERROR;
897: --RAISE;
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 896: x_return_status:= FND_API.G_RET_STS_ERROR;

892: --
893: --commented out NOCOPY RAISE
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_return_status:= FND_API.G_RET_STS_ERROR;
897: --RAISE;
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
900: --RAISE;

Line 898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_return_status:= FND_API.G_RET_STS_ERROR;
897: --RAISE;
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
900: --RAISE;
901: WHEN OTHERS THEN
902: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

895: WHEN FND_API.G_EXC_ERROR THEN
896: x_return_status:= FND_API.G_RET_STS_ERROR;
897: --RAISE;
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
900: --RAISE;
901: WHEN OTHERS THEN
902: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
903: l_error_tbl := x_error_Tbl;

Line 902: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
900: --RAISE;
901: WHEN OTHERS THEN
902: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
903: l_error_tbl := x_error_Tbl;
904: BIS_UTILITIES_PVT.Add_Error_Message
905: ( p_error_table => l_error_Tbl
906: , p_error_msg_id => SQLCODE

Line 910: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906: , p_error_msg_id => SQLCODE
907: , p_error_description => SQLERRM
908: , x_error_table => x_error_Tbl
909: );
910: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END Validate_Record;
912: --
913: --
914: END BIS_ACTUAL_VALIDATE_PVT;