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

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: from bis_Levels
38: where level_id = p_level_id;
39:
40: begin
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE
43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then
44: open chk_dimension;
45: fetch chk_dimension into l_dummy;

Line 42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE

38: where level_id = p_level_id;
39:
40: begin
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE
43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then
44: open chk_dimension;
45: fetch chk_dimension into l_dummy;
46: if (chk_dimension%NOTFOUND) then

Line 43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then

39:
40: begin
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_level_id)=FND_API.G_TRUE
43: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_level_id)=FND_API.G_TRUE ) then
44: open chk_dimension;
45: fetch chk_dimension into l_dummy;
46: if (chk_dimension%NOTFOUND) then
47: close chk_dimension;

Line 59: RAISE FND_API.G_EXC_ERROR;

55: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
56: , p_error_table => l_error_tbl
57: , x_error_table => x_error_tbl
58: );
59: RAISE FND_API.G_EXC_ERROR;
60: end if;
61: close chk_dimension;
62: end if;
63:

Line 66: when FND_API.G_EXC_ERROR then

62: end if;
63:
64: --commented RAISE
65: EXCEPTION
66: when FND_API.G_EXC_ERROR then
67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 67: x_return_status := FND_API.G_RET_STS_ERROR ;

63:
64: --commented RAISE
65: EXCEPTION
66: when FND_API.G_EXC_ERROR then
67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 68: --RAISE FND_API.G_EXC_ERROR;

64: --commented RAISE
65: EXCEPTION
66: when FND_API.G_EXC_ERROR then
67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: when others then

Line 69: when FND_API.G_EXC_UNEXPECTED_ERROR then

65: EXCEPTION
66: when FND_API.G_EXC_ERROR then
67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: when others then
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

66: when FND_API.G_EXC_ERROR then
67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: when others then
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
74: l_error_tbl := x_error_tbl;

Line 71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

67: x_return_status := FND_API.G_RET_STS_ERROR ;
68: --RAISE FND_API.G_EXC_ERROR;
69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: when others then
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
74: l_error_tbl := x_error_tbl;
75: --added last two parameters

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

69: when FND_API.G_EXC_UNEXPECTED_ERROR then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: when others then
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
74: l_error_tbl := x_error_tbl;
75: --added last two parameters
76: BIS_UTILITIES_PVT.Add_Error_Message
77: ( p_error_msg_id => SQLCODE

Line 83: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_Level_Id'
80: , p_error_table => l_error_tbl
81: , x_error_table => x_error_tbl
82: );
83: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84:
85: end Validate_Dimension_Level_Id;
86:
87: PROCEDURE Validate_org_Level_ID

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

85: end Validate_Dimension_Level_Id;
86:
87: PROCEDURE Validate_org_Level_ID
88: ( p_api_version IN NUMBER
89: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
90: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
93: )

Line 107: when FND_API.G_EXC_ERROR then

103: );
104:
105: --commented RAISE
106: EXCEPTION
107: when FND_API.G_EXC_ERROR then
108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 108: x_return_status := FND_API.G_RET_STS_ERROR ;

104:
105: --commented RAISE
106: EXCEPTION
107: when FND_API.G_EXC_ERROR then
108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 109: --RAISE FND_API.G_EXC_ERROR;

105: --commented RAISE
106: EXCEPTION
107: when FND_API.G_EXC_ERROR then
108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: when others then

Line 110: when FND_API.G_EXC_UNEXPECTED_ERROR then

106: EXCEPTION
107: when FND_API.G_EXC_ERROR then
108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: when others then
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

107: when FND_API.G_EXC_ERROR then
108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: when others then
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
115: --added last two parameters

Line 112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

108: x_return_status := FND_API.G_RET_STS_ERROR ;
109: --RAISE FND_API.G_EXC_ERROR;
110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: when others then
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
115: --added last two parameters
116: l_error_tbl := x_error_tbl;

Line 114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

110: when FND_API.G_EXC_UNEXPECTED_ERROR then
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: when others then
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
115: --added last two parameters
116: l_error_tbl := x_error_tbl;
117: BIS_UTILITIES_PVT.Add_Error_Message
118: ( p_error_msg_id => SQLCODE

Line 124: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: , p_error_proc_name => G_PKG_NAME||'.Validate_org_Level_ID'
121: , p_error_table => l_error_tbl
122: , x_error_table => x_error_tbl
123: );
124: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125:
126: END Validate_org_Level_ID;
127: --
128: PROCEDURE Validate_time_Level_ID

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

126: END Validate_org_Level_ID;
127: --
128: PROCEDURE Validate_time_Level_ID
129: ( p_api_version IN NUMBER
130: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
131: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
132: , x_return_status OUT NOCOPY VARCHAR2
133: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
134: )

Line 148: when FND_API.G_EXC_ERROR then

144: );
145:
146: --commented RAISE
147: EXCEPTION
148: when FND_API.G_EXC_ERROR then
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR ;

145:
146: --commented RAISE
147: EXCEPTION
148: when FND_API.G_EXC_ERROR then
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 150: --RAISE FND_API.G_EXC_ERROR;

146: --commented RAISE
147: EXCEPTION
148: when FND_API.G_EXC_ERROR then
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: when others then

Line 151: when FND_API.G_EXC_UNEXPECTED_ERROR then

147: EXCEPTION
148: when FND_API.G_EXC_ERROR then
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

148: when FND_API.G_EXC_ERROR then
149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156: --added last two parameters

Line 153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: x_return_status := FND_API.G_RET_STS_ERROR ;
150: --RAISE FND_API.G_EXC_ERROR;
151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156: --added last two parameters
157: l_error_tbl := x_error_tbl;

Line 155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

151: when FND_API.G_EXC_UNEXPECTED_ERROR then
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156: --added last two parameters
157: l_error_tbl := x_error_tbl;
158: BIS_UTILITIES_PVT.Add_Error_Message
159: ( p_error_msg_id => SQLCODE

Line 165: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: , p_error_proc_name => G_PKG_NAME||'.Validate_time_Level_ID'
162: , p_error_table => l_error_tbl
163: , x_error_table => x_error_tbl
164: );
165: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166:
167: END Validate_time_Level_ID;
168: --
169: --

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

168: --
169: --
170: PROCEDURE Validate_Dimension1_Level_ID
171: ( p_api_version IN NUMBER
172: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
173: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
174: , x_return_status OUT NOCOPY VARCHAR2
175: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
176: )

Line 190: when FND_API.G_EXC_ERROR then

186: );
187:
188: --commented RAISE
189: EXCEPTION
190: when FND_API.G_EXC_ERROR then
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 191: x_return_status := FND_API.G_RET_STS_ERROR ;

187:
188: --commented RAISE
189: EXCEPTION
190: when FND_API.G_EXC_ERROR then
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 192: --RAISE FND_API.G_EXC_ERROR;

188: --commented RAISE
189: EXCEPTION
190: when FND_API.G_EXC_ERROR then
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: when others then

Line 193: when FND_API.G_EXC_UNEXPECTED_ERROR then

189: EXCEPTION
190: when FND_API.G_EXC_ERROR then
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: when others then
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

190: when FND_API.G_EXC_ERROR then
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: when others then
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
198: l_error_tbl := x_error_tbl;

Line 195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: x_return_status := FND_API.G_RET_STS_ERROR ;
192: --RAISE FND_API.G_EXC_ERROR;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: when others then
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
198: l_error_tbl := x_error_tbl;
199: --added last two parameters

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: when others then
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
198: l_error_tbl := x_error_tbl;
199: --added last two parameters
200: BIS_UTILITIES_PVT.Add_Error_Message
201: ( p_error_msg_id => SQLCODE

Line 207: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension1_Level_ID'
204: , p_error_table => l_error_tbl
205: , x_error_table => x_error_tbl
206: );
207: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208:
209: END Validate_Dimension1_Level_ID;
210: --
211: PROCEDURE Validate_Dimension2_Level_ID

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

209: END Validate_Dimension1_Level_ID;
210: --
211: PROCEDURE Validate_Dimension2_Level_ID
212: ( p_api_version IN NUMBER
213: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
214: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
215: , x_return_status OUT NOCOPY VARCHAR2
216: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
217: )

Line 232: when FND_API.G_EXC_ERROR then

228:
229:
230: --commented RAISE
231: EXCEPTION
232: when FND_API.G_EXC_ERROR then
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 233: x_return_status := FND_API.G_RET_STS_ERROR ;

229:
230: --commented RAISE
231: EXCEPTION
232: when FND_API.G_EXC_ERROR then
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 234: --RAISE FND_API.G_EXC_ERROR;

230: --commented RAISE
231: EXCEPTION
232: when FND_API.G_EXC_ERROR then
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: when others then

Line 235: when FND_API.G_EXC_UNEXPECTED_ERROR then

231: EXCEPTION
232: when FND_API.G_EXC_ERROR then
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: when others then
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: when FND_API.G_EXC_ERROR then
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: when others then
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: --added last two parameters

Line 237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: --RAISE FND_API.G_EXC_ERROR;
235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: when others then
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: --added last two parameters
241: l_error_tbl := x_error_tbl;

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

235: when FND_API.G_EXC_UNEXPECTED_ERROR then
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: when others then
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: --added last two parameters
241: l_error_tbl := x_error_tbl;
242: BIS_UTILITIES_PVT.Add_Error_Message
243: ( p_error_msg_id => SQLCODE

Line 249: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension2_Level_ID'
246: , p_error_table => l_error_tbl
247: , x_error_table => x_error_tbl
248: );
249: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250:
251: END Validate_Dimension2_Level_ID;
252: --
253: PROCEDURE Validate_Dimension3_Level_ID

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

251: END Validate_Dimension2_Level_ID;
252: --
253: PROCEDURE Validate_Dimension3_Level_ID
254: ( p_api_version IN NUMBER
255: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
256: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )

Line 273: when FND_API.G_EXC_ERROR then

269: );
270:
271: --commented RAISE
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270:
271: --commented RAISE
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 275: --RAISE FND_API.G_EXC_ERROR;

271: --commented RAISE
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then

Line 276: when FND_API.G_EXC_UNEXPECTED_ERROR then

272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: --added last two parameters

Line 278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: --RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: --added last two parameters
282: l_error_tbl := x_error_tbl;

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: --added last two parameters
282: l_error_tbl := x_error_tbl;
283: BIS_UTILITIES_PVT.Add_Error_Message
284: ( p_error_msg_id => SQLCODE

Line 290: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension3_Level_ID'
287: , p_error_table => l_error_tbl
288: , x_error_table => x_error_tbl
289: );
290: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291:
292: END Validate_Dimension3_Level_ID;
293: --
294: PROCEDURE Validate_Dimension4_Level_ID

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

292: END Validate_Dimension3_Level_ID;
293: --
294: PROCEDURE Validate_Dimension4_Level_ID
295: ( p_api_version IN NUMBER
296: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
297: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )

Line 314: when FND_API.G_EXC_ERROR then

310: );
311:
312: --commented RAISE
313: EXCEPTION
314: when FND_API.G_EXC_ERROR then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 315: x_return_status := FND_API.G_RET_STS_ERROR ;

311:
312: --commented RAISE
313: EXCEPTION
314: when FND_API.G_EXC_ERROR then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 316: --RAISE FND_API.G_EXC_ERROR;

312: --commented RAISE
313: EXCEPTION
314: when FND_API.G_EXC_ERROR then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: when others then

Line 317: when FND_API.G_EXC_UNEXPECTED_ERROR then

313: EXCEPTION
314: when FND_API.G_EXC_ERROR then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: when others then
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

314: when FND_API.G_EXC_ERROR then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: when others then
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: l_error_tbl := x_error_tbl;

Line 319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: --RAISE FND_API.G_EXC_ERROR;
317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: when others then
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: l_error_tbl := x_error_tbl;
323: --added last two parameters

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

317: when FND_API.G_EXC_UNEXPECTED_ERROR then
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: when others then
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: l_error_tbl := x_error_tbl;
323: --added last two parameters
324: BIS_UTILITIES_PVT.Add_Error_Message
325: ( p_error_msg_id => SQLCODE

Line 331: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension4_Level_ID'
328: , p_error_table => l_error_tbl
329: , x_error_table => x_error_tbl
330: );
331: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332:
333: END Validate_Dimension4_Level_ID;
334: --
335: PROCEDURE Validate_Dimension5_Level_ID

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

333: END Validate_Dimension4_Level_ID;
334: --
335: PROCEDURE Validate_Dimension5_Level_ID
336: ( p_api_version IN NUMBER
337: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
338: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
339: , x_return_status OUT NOCOPY VARCHAR2
340: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
341: )

Line 355: when FND_API.G_EXC_ERROR then

351: );
352:
353: --commented RAISE
354: EXCEPTION
355: when FND_API.G_EXC_ERROR then
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 356: x_return_status := FND_API.G_RET_STS_ERROR ;

352:
353: --commented RAISE
354: EXCEPTION
355: when FND_API.G_EXC_ERROR then
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 357: --RAISE FND_API.G_EXC_ERROR;

353: --commented RAISE
354: EXCEPTION
355: when FND_API.G_EXC_ERROR then
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: when others then

Line 358: when FND_API.G_EXC_UNEXPECTED_ERROR then

354: EXCEPTION
355: when FND_API.G_EXC_ERROR then
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: when others then
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

355: when FND_API.G_EXC_ERROR then
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: when others then
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: l_error_tbl := x_error_tbl;

Line 360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

356: x_return_status := FND_API.G_RET_STS_ERROR ;
357: --RAISE FND_API.G_EXC_ERROR;
358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: when others then
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: l_error_tbl := x_error_tbl;
364: --added last two parameters

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

358: when FND_API.G_EXC_UNEXPECTED_ERROR then
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: when others then
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
363: l_error_tbl := x_error_tbl;
364: --added last two parameters
365: BIS_UTILITIES_PVT.Add_Error_Message
366: ( p_error_msg_id => SQLCODE

Line 372: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

375: --
376:
377: PROCEDURE Validate_Dimension6_Level_ID
378: ( p_api_version IN NUMBER
379: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
380: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
383: )

Line 397: when FND_API.G_EXC_ERROR then

393: );
394:
395: --commented RAISE
396: EXCEPTION
397: when FND_API.G_EXC_ERROR then
398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 398: x_return_status := FND_API.G_RET_STS_ERROR ;

394:
395: --commented RAISE
396: EXCEPTION
397: when FND_API.G_EXC_ERROR then
398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 399: -- RAISE FND_API.G_EXC_ERROR;

395: --commented RAISE
396: EXCEPTION
397: when FND_API.G_EXC_ERROR then
398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: when others then

Line 400: when FND_API.G_EXC_UNEXPECTED_ERROR then

396: EXCEPTION
397: when FND_API.G_EXC_ERROR then
398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: when others then
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

397: when FND_API.G_EXC_ERROR then
398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: when others then
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: l_error_tbl := x_error_tbl;

Line 402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: x_return_status := FND_API.G_RET_STS_ERROR ;
399: -- RAISE FND_API.G_EXC_ERROR;
400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: when others then
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: l_error_tbl := x_error_tbl;
406: --added last two parameters

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

400: when FND_API.G_EXC_UNEXPECTED_ERROR then
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: when others then
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: l_error_tbl := x_error_tbl;
406: --added last two parameters
407: BIS_UTILITIES_PVT.Add_Error_Message
408: ( p_error_msg_id => SQLCODE

Line 414: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension6_Level_ID'
411: , p_error_table => l_error_tbl
412: , x_error_table => x_error_tbl
413: );
414: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415:
416: END Validate_Dimension6_Level_ID;
417: --
418:

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

417: --
418:
419: PROCEDURE Validate_Dimension7_Level_ID
420: ( p_api_version IN NUMBER
421: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
422: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
423: , x_return_status OUT NOCOPY VARCHAR2
424: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
425: )

Line 439: when FND_API.G_EXC_ERROR then

435: );
436:
437: --commented RAISE
438: EXCEPTION
439: when FND_API.G_EXC_ERROR then
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 440: x_return_status := FND_API.G_RET_STS_ERROR ;

436:
437: --commented RAISE
438: EXCEPTION
439: when FND_API.G_EXC_ERROR then
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 441: --RAISE FND_API.G_EXC_ERROR;

437: --commented RAISE
438: EXCEPTION
439: when FND_API.G_EXC_ERROR then
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: when others then

Line 442: when FND_API.G_EXC_UNEXPECTED_ERROR then

438: EXCEPTION
439: when FND_API.G_EXC_ERROR then
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: when others then
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

439: when FND_API.G_EXC_ERROR then
440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: when others then
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: l_error_tbl := x_error_tbl;

Line 444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: x_return_status := FND_API.G_RET_STS_ERROR ;
441: --RAISE FND_API.G_EXC_ERROR;
442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: when others then
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: l_error_tbl := x_error_tbl;
448: --added last two parameters

Line 446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

442: when FND_API.G_EXC_UNEXPECTED_ERROR then
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: when others then
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: l_error_tbl := x_error_tbl;
448: --added last two parameters
449: BIS_UTILITIES_PVT.Add_Error_Message
450: ( p_error_msg_id => SQLCODE

Line 456: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension7_Level_ID'
453: , p_error_table => l_error_tbl
454: , x_error_table => x_error_tbl
455: );
456: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457:
458: END Validate_Dimension7_Level_ID;
459: --
460:

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

459: --
460:
461: PROCEDURE Validate_WF_Process_Short_Name
462: ( p_api_version IN NUMBER
463: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
464: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
465: , x_return_status OUT NOCOPY VARCHAR2
466: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
467: )

Line 482: when FND_API.G_EXC_ERROR then

478: );
479:
480: --commented RAISE
481: EXCEPTION
482: when FND_API.G_EXC_ERROR then
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 483: x_return_status := FND_API.G_RET_STS_ERROR ;

479:
480: --commented RAISE
481: EXCEPTION
482: when FND_API.G_EXC_ERROR then
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 484: --RAISE FND_API.G_EXC_ERROR;

480: --commented RAISE
481: EXCEPTION
482: when FND_API.G_EXC_ERROR then
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: when others then

Line 485: when FND_API.G_EXC_UNEXPECTED_ERROR then

481: EXCEPTION
482: when FND_API.G_EXC_ERROR then
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: when others then
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

482: when FND_API.G_EXC_ERROR then
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: when others then
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: l_error_tbl := x_error_tbl;

Line 487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: --RAISE FND_API.G_EXC_ERROR;
485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: when others then
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: l_error_tbl := x_error_tbl;
491: --added last two parameters

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

485: when FND_API.G_EXC_UNEXPECTED_ERROR then
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: when others then
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: l_error_tbl := x_error_tbl;
491: --added last two parameters
492: BIS_UTILITIES_PVT.Add_Error_Message
493: ( p_error_msg_id => SQLCODE

Line 499: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

495: , p_error_proc_name => G_PKG_NAME||'.Validate_WF_Process_Short_Name'
496: , p_error_table => l_error_tbl
497: , x_error_table => x_error_tbl
498: );
499: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500:
501: end Validate_WF_Process_Short_Name;
502: --
503: PROCEDURE Validate_Def_Notify_Resp_Id

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

501: end Validate_WF_Process_Short_Name;
502: --
503: PROCEDURE Validate_Def_Notify_Resp_Id
504: ( p_api_version IN NUMBER
505: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
506: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
507: , x_return_status OUT NOCOPY VARCHAR2
508: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
509: )

Line 525: when FND_API.G_EXC_ERROR then

521:
522:
523: --commented RAISE
524: EXCEPTION
525: when FND_API.G_EXC_ERROR then
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 526: x_return_status := FND_API.G_RET_STS_ERROR ;

522:
523: --commented RAISE
524: EXCEPTION
525: when FND_API.G_EXC_ERROR then
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 527: --RAISE FND_API.G_EXC_ERROR;

523: --commented RAISE
524: EXCEPTION
525: when FND_API.G_EXC_ERROR then
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: when others then

Line 528: when FND_API.G_EXC_UNEXPECTED_ERROR then

524: EXCEPTION
525: when FND_API.G_EXC_ERROR then
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: when others then
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

525: when FND_API.G_EXC_ERROR then
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: when others then
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: l_error_tbl := x_error_tbl;

Line 530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: --RAISE FND_API.G_EXC_ERROR;
528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: when others then
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: l_error_tbl := x_error_tbl;
534: --added last two parameters

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

528: when FND_API.G_EXC_UNEXPECTED_ERROR then
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
531: when others then
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: l_error_tbl := x_error_tbl;
534: --added last two parameters
535: BIS_UTILITIES_PVT.Add_Error_Message
536: ( p_error_msg_id => SQLCODE

Line 542: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: , p_error_proc_name => G_PKG_NAME||'.Validate_Def_Notify_Resp_Id'
539: , p_error_table => l_error_tbl
540: , x_error_table => x_error_tbl
541: );
542: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543:
544: END Validate_Def_Notify_Resp_Id;
545: --
546: PROCEDURE Validate_Df_computed_target_Id

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

544: END Validate_Def_Notify_Resp_Id;
545: --
546: PROCEDURE Validate_Df_computed_target_Id
547: ( p_api_version IN NUMBER
548: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
549: , p_TARGET_LEVEL_Rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_Rec_Type
550: , x_return_status OUT NOCOPY VARCHAR2
551: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
552: )

Line 568: when FND_API.G_EXC_ERROR then

564:
565:
566: --commented RAISE
567: EXCEPTION
568: when FND_API.G_EXC_ERROR then
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 569: x_return_status := FND_API.G_RET_STS_ERROR ;

565:
566: --commented RAISE
567: EXCEPTION
568: when FND_API.G_EXC_ERROR then
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 570: --RAISE FND_API.G_EXC_ERROR;

566: --commented RAISE
567: EXCEPTION
568: when FND_API.G_EXC_ERROR then
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: when others then

Line 571: when FND_API.G_EXC_UNEXPECTED_ERROR then

567: EXCEPTION
568: when FND_API.G_EXC_ERROR then
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: when others then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

568: when FND_API.G_EXC_ERROR then
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: when others then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: l_error_tbl := x_error_tbl;

Line 573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: --RAISE FND_API.G_EXC_ERROR;
571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: when others then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: l_error_tbl := x_error_tbl;
577: --added last two parameters

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

571: when FND_API.G_EXC_UNEXPECTED_ERROR then
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: when others then
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: l_error_tbl := x_error_tbl;
577: --added last two parameters
578: BIS_UTILITIES_PVT.Add_Error_Message
579: ( p_error_msg_id => SQLCODE

Line 585: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: , p_error_proc_name => G_PKG_NAME||'.Validate_Df_computed_target_Id'
582: , p_error_table => l_error_tbl
583: , x_error_table => x_error_tbl
584: );
585: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586:
587: END Validate_Df_computed_target_Id;
588:
589: --