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

Line 134: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

130: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
131: return l_universe_ids;
132: end buildUniverse;
133:
134: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
135: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,
136: X_Dup_Status OUT NOCOPY VARCHAR2,
137: X_Return_Status OUT NOCOPY VARCHAR2,
138: X_Msg_Count OUT NOCOPY NUMBER,

Line 151: IF FND_API.to_Boolean( p_init_msg_list )

147: BEGIN
148: -- Initialize message list IF p_init_msg_list is set to TRUE.
149: L_API_NAME := 'Validate_Filter';
150: l_filter_rec := p_filter_rec;
151: IF FND_API.to_Boolean( p_init_msg_list )
152: THEN
153: FND_MSG_PUB.initialize;
154: END IF;
155:

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: FND_MSG_PUB.initialize;
154: END IF;
155:
156: -- Initialize API return status to SUCCESS
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter');
160:
161: -- api body

Line 170: p_init_msg_list => fnd_api.g_false);

166: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
167: X_Return_Status => x_return_status,
168: X_Msg_Count => x_msg_count,
169: X_Msg_Data => x_msg_data,
170: p_init_msg_list => fnd_api.g_false);
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;

Line 172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

168: X_Msg_Count => x_msg_count,
169: X_Msg_Data => x_msg_data,
170: p_init_msg_list => fnd_api.g_false);
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: */
176:

Line 173: RAISE FND_API.G_EXC_ERROR;

169: X_Msg_Data => x_msg_data,
170: p_init_msg_list => fnd_api.g_false);
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: */
176:
177: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');

Line 185: p_init_msg_list => fnd_api.g_false);

181: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
182: X_Return_Status => l_return_status,
183: X_Msg_Count => x_msg_count,
184: X_Msg_Data => x_msg_data,
185: p_init_msg_list => fnd_api.g_false);
186: --dbms_output.put_line('Validating Obj Filter Name ' || l_return_status);
187: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR:'||l_return_status);
188:
189: -- if found API will return 'S' therefore we have a duplicate Filter_Name

Line 190: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

186: --dbms_output.put_line('Validating Obj Filter Name ' || l_return_status);
187: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR:'||l_return_status);
188:
189: -- if found API will return 'S' therefore we have a duplicate Filter_Name
190: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
192: RAISE FND_API.G_EXC_ERROR;
193: --dbms_output.put_line('dup=' || x_dup_status);
194: END IF;

Line 192: RAISE FND_API.G_EXC_ERROR;

188:
189: -- if found API will return 'S' therefore we have a duplicate Filter_Name
190: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
192: RAISE FND_API.G_EXC_ERROR;
193: --dbms_output.put_line('dup=' || x_dup_status);
194: END IF;
195:
196: -- validate lookup_type/ code

Line 204: p_init_msg_list => fnd_api.g_false,

200: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
201: X_Return_Status => l_return_status,
202: X_Msg_Count => x_msg_count,
203: X_Msg_Data => x_msg_data,
204: p_init_msg_list => fnd_api.g_false,
205: p_lookup_view => 'IEX_LOOKUPS_V');
206:
207: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

204: p_init_msg_list => fnd_api.g_false,
205: p_lookup_view => 'IEX_LOOKUPS_V');
206:
207: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: --dbms_output.put_line('Validating Obj Filter Type ' || l_return_status);
212:

Line 209: RAISE FND_API.G_EXC_ERROR;

205: p_lookup_view => 'IEX_LOOKUPS_V');
206:
207: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
208: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: --dbms_output.put_line('Validating Obj Filter Type ' || l_return_status);
212:
213: -- validate object_id

Line 236: p_init_msg_list => fnd_api.g_false);

232: P_TABLE_NAME => l_table_name,
233: X_Return_Status => l_return_status,
234: X_Msg_Count => x_msg_count,
235: X_Msg_Data => x_msg_data,
236: p_init_msg_list => fnd_api.g_false);
237: --dbms_output.put_line('Validating Object ID ' || l_return_status );
238: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
239:
240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

236: p_init_msg_list => fnd_api.g_false);
237: --dbms_output.put_line('Validating Object ID ' || l_return_status );
238: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
239:
240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: /*******************************

Line 241: RAISE FND_API.G_EXC_ERROR;

237: --dbms_output.put_line('Validating Object ID ' || l_return_status );
238: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
239:
240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: /*******************************
245: * BUG 4113025

Line 259: p_init_msg_list => fnd_api.g_false);

255: P_TABLE_NAME => 'ALL_VIEWS',
256: X_Return_Status => l_return_status,
257: X_Msg_Count => x_msg_count,
258: X_Msg_Data => x_msg_data,
259: p_init_msg_list => fnd_api.g_false);
260: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
261:
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: RAISE FND_API.G_EXC_ERROR;

Line 262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

258: X_Msg_Data => x_msg_data,
259: p_init_msg_list => fnd_api.g_false);
260: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
261:
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: -- validate select_column

Line 263: RAISE FND_API.G_EXC_ERROR;

259: p_init_msg_list => fnd_api.g_false);
260: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
261:
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: -- validate select_column
267: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');

Line 274: p_init_msg_list => fnd_api.g_false);

270: P_TABLE_NAME => 'ALL_TAB_COLUMNS',
271: X_Return_Status => l_return_status,
272: X_Msg_Count => x_msg_count,
273: X_Msg_Data => x_msg_data,
274: p_init_msg_list => fnd_api.g_false);
275: --dbms_output.put_line('Validating Select Column ' || l_return_status);
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: RAISE FND_API.G_EXC_ERROR;

Line 277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

273: X_Msg_Data => x_msg_data,
274: p_init_msg_list => fnd_api.g_false);
275: --dbms_output.put_line('Validating Select Column ' || l_return_status);
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: ************************************************/
281:

Line 278: RAISE FND_API.G_EXC_ERROR;

274: p_init_msg_list => fnd_api.g_false);
275: --dbms_output.put_line('Validating Select Column ' || l_return_status);
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: ************************************************/
281:
282:

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: p_data => x_msg_data
288: );
289:
290: Exception
291: WHEN FND_API.G_EXC_ERROR THEN
292: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
295: FND_MSG_PUB.Count_And_Get

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289:
290: Exception
291: WHEN FND_API.G_EXC_ERROR THEN
292: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
295: FND_MSG_PUB.Count_And_Get
296: ( p_count => x_msg_count,
297: p_data => x_msg_data

Line 300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

296: ( p_count => x_msg_count,
297: p_data => x_msg_data
298: );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
303: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
304: FND_MSG_PUB.Count_And_Get

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: p_data => x_msg_data
298: );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
303: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
304: FND_MSG_PUB.Count_And_Get
305: ( p_count => x_msg_count,

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: p_data => x_msg_data
307: );
308:
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:OTHERS ERROR');
312: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
313: FND_MSG_PUB.Count_And_Get
314: ( p_count => x_msg_count,

Line 324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

320:
321:
322: Procedure Create_OBJECT_FILTER
323: (p_api_version IN NUMBER := 1.0,
324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
326: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
327: x_dup_status OUT NOCOPY VARCHAR2,
328: x_return_status OUT NOCOPY VARCHAR2,

Line 325: p_commit IN VARCHAR2 := FND_API.G_FALSE,

321:
322: Procedure Create_OBJECT_FILTER
323: (p_api_version IN NUMBER := 1.0,
324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
326: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
327: x_dup_status OUT NOCOPY VARCHAR2,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,

Line 350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

346: SAVEPOINT CREATE_OBJECT_FILTER_PVT;
347:
348: l_FILTER_REC := P_FILTER_REC;
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
351: p_api_version,
352: l_api_name,
353: G_PKG_NAME)
354: THEN

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: p_api_version,
352: l_api_name,
353: G_PKG_NAME)
354: THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358: -- Initialize message list IF p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )

Line 359: IF FND_API.to_Boolean( p_init_msg_list )

355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358: -- Initialize message list IF p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

365: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Start');
366:
367:
368: -- Initialize API return status to SUCCESS
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: --
372: -- API body
373: --

Line 383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

379: X_Return_Status => l_return_status,
380: X_Msg_Count => l_msg_count,
381: X_Msg_Data => l_msg_data);
382:
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');

Line 384: RAISE FND_API.G_EXC_ERROR;

380: X_Msg_Count => l_msg_count,
381: X_Msg_Data => l_msg_data);
382:
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');
388:

Line 417: IF FND_API.to_Boolean( p_commit )

413: -- End of API body
414: --
415:
416: -- Standard check for p_commit
417: IF FND_API.to_Boolean( p_commit )
418: THEN
419: COMMIT WORK;
420: END IF;
421:

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: );
430:
431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
437: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
437: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
438: FND_MSG_PUB.Count_And_Get
439: ( p_count => x_msg_count,

Line 443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

439: ( p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442:
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
447: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: );
442:
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
447: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
448: FND_MSG_PUB.Count_And_Get
449: ( p_count => x_msg_count,

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: );
452:
453: WHEN OTHERS THEN
454: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:OTHER ERROR');
457: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
458: FND_MSG_PUB.Count_And_Get
459: ( p_count => x_msg_count,

Line 468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

464:
465:
466: Procedure Update_OBJECT_FILTER
467: (p_api_version IN NUMBER := 1.0,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
471: x_dup_status OUT NOCOPY VARCHAR2,
472: x_return_status OUT NOCOPY VARCHAR2,

Line 469: p_commit IN VARCHAR2 := FND_API.G_FALSE,

465:
466: Procedure Update_OBJECT_FILTER
467: (p_api_version IN NUMBER := 1.0,
468: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
469: p_commit IN VARCHAR2 := FND_API.G_FALSE,
470: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
471: x_dup_status OUT NOCOPY VARCHAR2,
472: x_return_status OUT NOCOPY VARCHAR2,
473: x_msg_count OUT NOCOPY NUMBER,

Line 518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

514: SAVEPOINT UPDATE_OBJECT_FILTER_PVT;
515:
516: l_FILTER_REC := P_FILTER_REC;
517: -- Standard call to check for call compatibility.
518: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
519: p_api_version,
520: l_api_name,
521: G_PKG_NAME)
522: THEN

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: p_api_version,
520: l_api_name,
521: G_PKG_NAME)
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: -- Initialize message list IF p_init_msg_list is set to TRUE.
527: IF FND_API.to_Boolean( p_init_msg_list )

Line 527: IF FND_API.to_Boolean( p_init_msg_list )

523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: -- Initialize message list IF p_init_msg_list is set to TRUE.
527: IF FND_API.to_Boolean( p_init_msg_list )
528: THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: -- Debug Message
533: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:start');
534:
535: -- Initialize API return status to SUCCESS
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: -- added by clchang 02/25/2002
539: -- validate dup filter_Name
540: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:validation:chk_dup_filter_name');

Line 554: RAISE FND_API.G_EXC_ERROR;

550: FND_MSG_PUB.Add;
551: END IF;
552: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
553: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:dup object_filter_name');
554: RAISE FND_API.G_EXC_ERROR;
555: end if;
556: close C_chk_filter_name;
557:
558: --

Line 585: RAISE FND_API.G_EXC_ERROR;

581: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
582: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
583: FND_MSG_PUB.Add;
584: END IF;
585: RAISE FND_API.G_EXC_ERROR;
586: END IF;
587:
588: close C_get_filter_Rec;
589:

Line 592: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)

588: close C_get_filter_Rec;
589:
590:
591: IF (l_filter_ref_rec.last_update_date is NULL or
592: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)
593: THEN
594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
595: THEN
596: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

Line 600: RAISE FND_API.G_EXC_ERROR;

596: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
597: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
598: FND_MSG_PUB.ADD;
599: END IF;
600: RAISE FND_API.G_EXC_ERROR;
601: End IF;
602:
603: -- Transfer Data into target record
604: l_filter_rec.CREATION_DATE := l_filter_ref_rec.CREATION_DATE;

Line 607: IF ((l_filter_rec.OBJECT_FILTER_NAME = FND_API.G_MISS_CHAR) OR

603: -- Transfer Data into target record
604: l_filter_rec.CREATION_DATE := l_filter_ref_rec.CREATION_DATE;
605: l_filter_rec.CREATED_BY := l_filter_ref_rec.CREATED_BY;
606:
607: IF ((l_filter_rec.OBJECT_FILTER_NAME = FND_API.G_MISS_CHAR) OR
608: (l_filter_rec.OBJECT_FILTER_NAME = NULL)) THEN
609: l_filter_rec.OBJECT_FILTER_NAME := l_filter_ref_rec.OBJECT_FILTER_NAME;
610: END IF;
611: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR

Line 611: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR

607: IF ((l_filter_rec.OBJECT_FILTER_NAME = FND_API.G_MISS_CHAR) OR
608: (l_filter_rec.OBJECT_FILTER_NAME = NULL)) THEN
609: l_filter_rec.OBJECT_FILTER_NAME := l_filter_ref_rec.OBJECT_FILTER_NAME;
610: END IF;
611: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR
612: (l_filter_rec.OBJECT_FILTER_TYPE = NULL)) THEN
613: l_filter_rec.OBJECT_FILTER_TYPE := l_filter_ref_rec.OBJECT_FILTER_TYPE;
614: END IF;
615: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR

Line 615: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR

611: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR
612: (l_filter_rec.OBJECT_FILTER_TYPE = NULL)) THEN
613: l_filter_rec.OBJECT_FILTER_TYPE := l_filter_ref_rec.OBJECT_FILTER_TYPE;
614: END IF;
615: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR
616: (l_filter_rec.OBJECT_ID = NULL)) THEN
617: l_filter_rec.OBJECT_ID := l_filter_ref_rec.OBJECT_ID;
618: END IF;
619: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR

Line 619: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR

615: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR
616: (l_filter_rec.OBJECT_ID = NULL)) THEN
617: l_filter_rec.OBJECT_ID := l_filter_ref_rec.OBJECT_ID;
618: END IF;
619: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR
620: (l_filter_rec.SELECT_COLUMN = NULL)) THEN
621: l_filter_rec.SELECT_COLUMN := l_filter_ref_rec.SELECT_COLUMN;
622: END IF;
623: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR

Line 623: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR

619: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR
620: (l_filter_rec.SELECT_COLUMN = NULL)) THEN
621: l_filter_rec.SELECT_COLUMN := l_filter_ref_rec.SELECT_COLUMN;
622: END IF;
623: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR
624: (l_filter_rec.ENTITY_NAME = NULL)) THEN
625: l_filter_rec.ENTITY_NAME := l_filter_ref_rec.ENTITY_NAME;
626: END IF;
627: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR

Line 627: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR

623: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR
624: (l_filter_rec.ENTITY_NAME = NULL)) THEN
625: l_filter_rec.ENTITY_NAME := l_filter_ref_rec.ENTITY_NAME;
626: END IF;
627: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR
628: (l_filter_rec.ACTIVE_FLAG = NULL)) THEN
629: l_filter_rec.ACTIVE_FLAG := l_filter_ref_rec.ACTIVE_FLAG;
630: END IF;
631: IF ((l_filter_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) OR

Line 631: IF ((l_filter_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) OR

627: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR
628: (l_filter_rec.ACTIVE_FLAG = NULL)) THEN
629: l_filter_rec.ACTIVE_FLAG := l_filter_ref_rec.ACTIVE_FLAG;
630: END IF;
631: IF ((l_filter_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) OR
632: (l_filter_rec.OBJECT_VERSION_NUMBER = NULL)) THEN
633: l_filter_rec.OBJECT_VERSION_NUMBER := l_filter_ref_rec.OBJECT_VERSION_NUMBER;
634: END IF;
635:

Line 658: IF FND_API.to_Boolean( p_commit )

654: -- End of API body
655: --
656:
657: -- Standard check for p_commit
658: IF FND_API.to_Boolean( p_commit )
659: THEN
660: COMMIT WORK;
661: END IF;
662:

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: );
671:
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
678: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
678: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
679: FND_MSG_PUB.Count_And_Get
680: ( p_count => x_msg_count,

Line 684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

680: ( p_count => x_msg_count,
681: p_data => x_msg_data
682: );
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
688: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: );
683:
684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
685: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
688: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
689: FND_MSG_PUB.Count_And_Get
690: ( p_count => x_msg_count,

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

692: );
693:
694: WHEN OTHERS THEN
695: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:OTHER ERROR');
698: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,

Line 710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

706:
707:
708: Procedure Delete_OBJECT_FILTER
709: (p_api_version IN NUMBER := 1.0,
710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
711: p_commit IN VARCHAR2 := FND_API.G_FALSE,
712: P_OBJECT_FILTER_ID IN NUMBER,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,

Line 711: p_commit IN VARCHAR2 := FND_API.G_FALSE,

707:
708: Procedure Delete_OBJECT_FILTER
709: (p_api_version IN NUMBER := 1.0,
710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
711: p_commit IN VARCHAR2 := FND_API.G_FALSE,
712: P_OBJECT_FILTER_ID IN NUMBER,
713: x_return_status OUT NOCOPY VARCHAR2,
714: x_msg_count OUT NOCOPY NUMBER,
715: x_msg_data OUT NOCOPY VARCHAR2)

Line 734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

730: -- Standard Start of API savepoint
731: SAVEPOINT DELETE_OBJECT_FILTER_PVT;
732:
733: -- Standard call to check for call compatibility.
734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
735: p_api_version,
736: l_api_name,
737: G_PKG_NAME)
738: THEN

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: p_api_version,
736: l_api_name,
737: G_PKG_NAME)
738: THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:
742: -- Initialize message list IF p_init_msg_list is set to TRUE.
743: IF FND_API.to_Boolean( p_init_msg_list )

Line 743: IF FND_API.to_Boolean( p_init_msg_list )

739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:
742: -- Initialize message list IF p_init_msg_list is set to TRUE.
743: IF FND_API.to_Boolean( p_init_msg_list )
744: THEN
745: FND_MSG_PUB.initialize;
746: END IF;
747:

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Start');
750:
751:
752: -- Initialize API return status to SUCCESS
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754:
755: --
756: -- API body
757: --

Line 769: RAISE FND_API.G_EXC_ERROR;

765: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
766: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
767: FND_MSG_PUB.Add;
768: END IF;
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: Close C_GET_FILTER;
773:

Line 786: IF FND_API.to_Boolean( p_commit )

782: -- End of API body
783: --
784:
785: -- Standard check for p_commit
786: IF FND_API.to_Boolean( p_commit )
787: THEN
788: COMMIT WORK;
789: END IF;
790:

Line 802: WHEN FND_API.G_EXC_ERROR THEN

798: );
799:
800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
804: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
805: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
806: x_return_status := FND_API.G_RET_STS_ERROR;

Line 806: x_return_status := FND_API.G_RET_STS_ERROR;

802: WHEN FND_API.G_EXC_ERROR THEN
803: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
804: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
805: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );

Line 812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811:
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
816: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

810: );
811:
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
816: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,

Line 824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

820: );
821:
822: WHEN OTHERS THEN
823: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:OTHER ERROR');
826: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,