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.CSC_PROF_COLOR_CODE_PUB dependencies on FND_API

Line 47: raise FND_API.G_EXC_ERROR;

43:
44: -- If there is an error in conversion precessing, raise an error.
45: IF l_any_errors
46: THEN
47: raise FND_API.G_EXC_ERROR;
48: END IF;
49: END Convert_pub_to_pvt_Rec;
50:
51: PROCEDURE Convert_Columns_to_Rec (

Line 134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

130: -- Standard Start of API savepoint
131: SAVEPOINT CREATE_PROF_COLOR_CODE_PUB;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142:
143: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 144: IF FND_API.to_Boolean( p_init_msg_list )

140: END IF;
141:
142:
143: -- Initialize message list if p_init_msg_list is set to TRUE.
144: IF FND_API.to_Boolean( p_init_msg_list )
145: THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148:
149:
150:
151: -- Initialize API return status to SUCCESS
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: --
155: -- API body
156: --

Line 166: P_Init_Msg_List => FND_API.G_FALSE,

162:
163:
164: CSC_prof_color_code_PVT.Create_prof_color_code(
165: P_Api_Version_Number => 2.0,
166: P_Init_Msg_List => FND_API.G_FALSE,
167: P_Commit => FND_API.G_FALSE,
168: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
169: P_prof_color_rec => l_pvt_prof_color_rec ,
170: PX_COLOR_CODE => px_COLOR_CODE,

Line 167: P_Commit => FND_API.G_FALSE,

163:
164: CSC_prof_color_code_PVT.Create_prof_color_code(
165: P_Api_Version_Number => 2.0,
166: P_Init_Msg_List => FND_API.G_FALSE,
167: P_Commit => FND_API.G_FALSE,
168: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
169: P_prof_color_rec => l_pvt_prof_color_rec ,
170: PX_COLOR_CODE => px_COLOR_CODE,
171: X_Return_Status => x_return_status,

Line 168: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

164: CSC_prof_color_code_PVT.Create_prof_color_code(
165: P_Api_Version_Number => 2.0,
166: P_Init_Msg_List => FND_API.G_FALSE,
167: P_Commit => FND_API.G_FALSE,
168: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
169: P_prof_color_rec => l_pvt_prof_color_rec ,
170: PX_COLOR_CODE => px_COLOR_CODE,
171: X_Return_Status => x_return_status,
172: X_Msg_Count => x_msg_count,

Line 178: IF x_return_status = FND_API.G_RET_STS_ERROR then

174:
175:
176:
177: -- Check return status from the above procedure call
178: IF x_return_status = FND_API.G_RET_STS_ERROR then
179: raise FND_API.G_EXC_ERROR;
180: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;

Line 179: raise FND_API.G_EXC_ERROR;

175:
176:
177: -- Check return status from the above procedure call
178: IF x_return_status = FND_API.G_RET_STS_ERROR then
179: raise FND_API.G_EXC_ERROR;
180: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:

Line 180: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

176:
177: -- Check return status from the above procedure call
178: IF x_return_status = FND_API.G_RET_STS_ERROR then
179: raise FND_API.G_EXC_ERROR;
180: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: --

Line 181: raise FND_API.G_EXC_UNEXPECTED_ERROR;

177: -- Check return status from the above procedure call
178: IF x_return_status = FND_API.G_RET_STS_ERROR then
179: raise FND_API.G_EXC_ERROR;
180: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
181: raise FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: --
185: -- End of API body.

Line 189: IF FND_API.to_Boolean( p_commit )

185: -- End of API body.
186: --
187:
188: -- Standard check for p_commit
189: IF FND_API.to_Boolean( p_commit )
190: THEN
191: COMMIT WORK;
192: END IF;
193:

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: p_data => x_msg_data
200: );
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
207: p_data => x_msg_data) ;

Line 205: x_return_status := FND_API.G_RET_STS_ERROR ;

201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
207: p_data => x_msg_data) ;
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
207: p_data => x_msg_data) ;
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
212: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
213: p_data => x_msg_data) ;

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

207: p_data => x_msg_data) ;
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
212: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
213: p_data => x_msg_data) ;
214:
215: WHEN OTHERS THEN

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

213: p_data => x_msg_data) ;
214:
215: WHEN OTHERS THEN
216: ROLLBACK TO CREATE_PROF_COLOR_CODE_PUB;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
218: IF FND_MSG_PUB.Check_Msg_Level
219: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 290: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

286: -- Standard Start of API savepoint
287: SAVEPOINT UPDATE_PROF_COLOR_CODE_PUB;
288:
289: -- Standard call to check for call compatibility.
290: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
291: p_api_version_number,
292: l_api_name,
293: G_PKG_NAME)
294: THEN

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: p_api_version_number,
292: l_api_name,
293: G_PKG_NAME)
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 300: IF FND_API.to_Boolean( p_init_msg_list )

296: END IF;
297:
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304:
305:
306:
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: --
311: -- API body
312: --

Line 322: P_Init_Msg_List => FND_API.G_FALSE,

318:
319:
320: CSC_prof_color_code_PVT.Update_prof_color_code(
321: P_Api_Version_Number => 1.0,
322: P_Init_Msg_List => FND_API.G_FALSE,
323: P_Commit => p_commit,
324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
325: P_prof_color_rec => l_pvt_prof_color_rec ,
326: X_Return_Status => x_return_status,

Line 324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

320: CSC_prof_color_code_PVT.Update_prof_color_code(
321: P_Api_Version_Number => 1.0,
322: P_Init_Msg_List => FND_API.G_FALSE,
323: P_Commit => p_commit,
324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
325: P_prof_color_rec => l_pvt_prof_color_rec ,
326: X_Return_Status => x_return_status,
327: X_Msg_Count => x_msg_count,
328: X_Msg_Data => x_msg_data);

Line 333: IF x_return_status = FND_API.G_RET_STS_ERROR then

329:
330:
331:
332: -- Check return status from the above procedure call
333: IF x_return_status = FND_API.G_RET_STS_ERROR then
334: raise FND_API.G_EXC_ERROR;
335: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;

Line 334: raise FND_API.G_EXC_ERROR;

330:
331:
332: -- Check return status from the above procedure call
333: IF x_return_status = FND_API.G_RET_STS_ERROR then
334: raise FND_API.G_EXC_ERROR;
335: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338:

Line 335: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

331:
332: -- Check return status from the above procedure call
333: IF x_return_status = FND_API.G_RET_STS_ERROR then
334: raise FND_API.G_EXC_ERROR;
335: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338:
339: --

Line 336: raise FND_API.G_EXC_UNEXPECTED_ERROR;

332: -- Check return status from the above procedure call
333: IF x_return_status = FND_API.G_RET_STS_ERROR then
334: raise FND_API.G_EXC_ERROR;
335: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338:
339: --
340: -- End of API body

Line 344: IF FND_API.to_Boolean( p_commit )

340: -- End of API body
341: --
342:
343: -- Standard check for p_commit
344: IF FND_API.to_Boolean( p_commit )
345: THEN
346: COMMIT WORK;
347: END IF;
348:

Line 358: WHEN FND_API.G_EXC_ERROR THEN

354: p_data => x_msg_data
355: );
356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
360: x_return_status := FND_API.G_RET_STS_ERROR ;
361: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
362: p_data => x_msg_data) ;

Line 360: x_return_status := FND_API.G_RET_STS_ERROR ;

356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
360: x_return_status := FND_API.G_RET_STS_ERROR ;
361: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
362: p_data => x_msg_data) ;
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

360: x_return_status := FND_API.G_RET_STS_ERROR ;
361: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
362: p_data => x_msg_data) ;
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
368: p_data => x_msg_data) ;

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

362: p_data => x_msg_data) ;
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
368: p_data => x_msg_data) ;
369:
370: WHEN OTHERS THEN

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

368: p_data => x_msg_data) ;
369:
370: WHEN OTHERS THEN
371: ROLLBACK TO UPDATE_PROF_COLOR_CODE_PUB;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: IF FND_MSG_PUB.Check_Msg_Level
374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);