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 212: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

208: IEX_DEBUG_PUB.logMessage('IEX_FILTER_PUB: buildUniverse: ' || sqlerrm ||' ' || sqlcode);
209: return l_universe_ids;
210: end buildUniverse;
211:
212: Procedure Validate_FILTER(P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213: P_FILTER_rec IN IEX_FILTER_PUB.FILTER_REC_TYPE,
214: X_Dup_Status OUT NOCOPY VARCHAR2,
215: X_Return_Status OUT NOCOPY VARCHAR2,
216: X_Msg_Count OUT NOCOPY NUMBER,

Line 229: IF FND_API.to_Boolean( p_init_msg_list )

225: BEGIN
226: -- Initialize message list IF p_init_msg_list is set to TRUE.
227: L_API_NAME := 'Validate_Filter';
228: l_filter_rec := p_filter_rec;
229: IF FND_API.to_Boolean( p_init_msg_list )
230: THEN
231: FND_MSG_PUB.initialize;
232: END IF;
233:

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: FND_MSG_PUB.initialize;
232: END IF;
233:
234: -- Initialize API return status to SUCCESS
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:
237: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter');
238:
239: -- api body

Line 248: p_init_msg_list => fnd_api.g_false);

244: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
245: X_Return_Status => x_return_status,
246: X_Msg_Count => x_msg_count,
247: X_Msg_Data => x_msg_data,
248: p_init_msg_list => fnd_api.g_false);
249:
250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;

Line 250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

246: X_Msg_Count => x_msg_count,
247: X_Msg_Data => x_msg_data,
248: p_init_msg_list => fnd_api.g_false);
249:
250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: */
254:

Line 251: RAISE FND_API.G_EXC_ERROR;

247: X_Msg_Data => x_msg_data,
248: p_init_msg_list => fnd_api.g_false);
249:
250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: */
254:
255: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');

Line 263: p_init_msg_list => fnd_api.g_false);

259: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',
260: X_Return_Status => l_return_status,
261: X_Msg_Count => x_msg_count,
262: X_Msg_Data => x_msg_data,
263: p_init_msg_list => fnd_api.g_false);
264: --dbms_output.put_line('Validating Obj Filter Name ' || l_return_status);
265: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR:'||l_return_status);
266:
267: -- if found API will return 'S' therefore we have a duplicate Filter_Name

Line 268: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

264: --dbms_output.put_line('Validating Obj Filter Name ' || l_return_status);
265: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR:'||l_return_status);
266:
267: -- if found API will return 'S' therefore we have a duplicate Filter_Name
268: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
269: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
270: RAISE FND_API.G_EXC_ERROR;
271: --dbms_output.put_line('dup=' || x_dup_status);
272: END IF;

Line 270: RAISE FND_API.G_EXC_ERROR;

266:
267: -- if found API will return 'S' therefore we have a duplicate Filter_Name
268: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
269: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
270: RAISE FND_API.G_EXC_ERROR;
271: --dbms_output.put_line('dup=' || x_dup_status);
272: END IF;
273:
274: -- validate lookup_type/ code

Line 282: p_init_msg_list => fnd_api.g_false,

278: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
279: X_Return_Status => l_return_status,
280: X_Msg_Count => x_msg_count,
281: X_Msg_Data => x_msg_data,
282: p_init_msg_list => fnd_api.g_false,
283: p_lookup_view => 'IEX_LOOKUPS_V');
284:
285: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

282: p_init_msg_list => fnd_api.g_false,
283: p_lookup_view => 'IEX_LOOKUPS_V');
284:
285: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: --dbms_output.put_line('Validating Obj Filter Type ' || l_return_status);
290:

Line 287: RAISE FND_API.G_EXC_ERROR;

283: p_lookup_view => 'IEX_LOOKUPS_V');
284:
285: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);
286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: --dbms_output.put_line('Validating Obj Filter Type ' || l_return_status);
290:
291: -- validate object_id

Line 314: p_init_msg_list => fnd_api.g_false);

310: P_TABLE_NAME => l_table_name,
311: X_Return_Status => l_return_status,
312: X_Msg_Count => x_msg_count,
313: X_Msg_Data => x_msg_data,
314: p_init_msg_list => fnd_api.g_false);
315: --dbms_output.put_line('Validating Object ID ' || l_return_status );
316: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
317:
318: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 318: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

314: p_init_msg_list => fnd_api.g_false);
315: --dbms_output.put_line('Validating Object ID ' || l_return_status );
316: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
317:
318: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
321:
322: /*******************************

Line 319: RAISE FND_API.G_EXC_ERROR;

315: --dbms_output.put_line('Validating Object ID ' || l_return_status );
316: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||l_return_status);
317:
318: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
319: RAISE FND_API.G_EXC_ERROR;
320: END IF;
321:
322: /*******************************
323: * BUG 4113025

Line 337: p_init_msg_list => fnd_api.g_false);

333: P_TABLE_NAME => 'ALL_VIEWS',
334: X_Return_Status => l_return_status,
335: X_Msg_Count => x_msg_count,
336: X_Msg_Data => x_msg_data,
337: p_init_msg_list => fnd_api.g_false);
338: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
339:
340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: RAISE FND_API.G_EXC_ERROR;

Line 340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

336: X_Msg_Data => x_msg_data,
337: p_init_msg_list => fnd_api.g_false);
338: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
339:
340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
344: -- validate select_column

Line 341: RAISE FND_API.G_EXC_ERROR;

337: p_init_msg_list => fnd_api.g_false);
338: --dbms_output.put_line('Validating Entity Name ' || l_return_status );
339:
340: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:
344: -- validate select_column
345: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');

Line 352: p_init_msg_list => fnd_api.g_false);

348: P_TABLE_NAME => 'ALL_TAB_COLUMNS',
349: X_Return_Status => l_return_status,
350: X_Msg_Count => x_msg_count,
351: X_Msg_Data => x_msg_data,
352: p_init_msg_list => fnd_api.g_false);
353: --dbms_output.put_line('Validating Select Column ' || l_return_status);
354:
355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: RAISE FND_API.G_EXC_ERROR;

Line 355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

351: X_Msg_Data => x_msg_data,
352: p_init_msg_list => fnd_api.g_false);
353: --dbms_output.put_line('Validating Select Column ' || l_return_status);
354:
355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358: ************************************************/
359:

Line 356: RAISE FND_API.G_EXC_ERROR;

352: p_init_msg_list => fnd_api.g_false);
353: --dbms_output.put_line('Validating Select Column ' || l_return_status);
354:
355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358: ************************************************/
359:
360:

Line 369: WHEN FND_API.G_EXC_ERROR THEN

365: p_data => x_msg_data
366: );
367:
368: Exception
369: WHEN FND_API.G_EXC_ERROR THEN
370: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
373: FND_MSG_PUB.Count_And_Get

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367:
368: Exception
369: WHEN FND_API.G_EXC_ERROR THEN
370: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,
375: p_data => x_msg_data

Line 378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

374: ( p_count => x_msg_count,
375: p_data => x_msg_data
376: );
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
381: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
382: FND_MSG_PUB.Count_And_Get

Line 379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

375: p_data => x_msg_data
376: );
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');
381: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
382: FND_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count,

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

384: p_data => x_msg_data
385: );
386:
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:OTHERS ERROR');
390: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);
391: FND_MSG_PUB.Count_And_Get
392: ( p_count => x_msg_count,

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

398:
399:
400: Procedure Create_OBJECT_FILTER
401: (p_api_version IN NUMBER := 1.0,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
405: x_dup_status OUT NOCOPY VARCHAR2,
406: x_return_status OUT NOCOPY VARCHAR2,

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

399:
400: Procedure Create_OBJECT_FILTER
401: (p_api_version IN NUMBER := 1.0,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
405: x_dup_status OUT NOCOPY VARCHAR2,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,

Line 428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

424: SAVEPOINT CREATE_OBJECT_FILTER_PVT;
425:
426: l_FILTER_REC := P_FILTER_REC;
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
429: p_api_version,
430: l_api_name,
431: G_PKG_NAME)
432: THEN

Line 433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

429: p_api_version,
430: l_api_name,
431: G_PKG_NAME)
432: THEN
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435:
436: -- Initialize message list IF p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )

Line 437: IF FND_API.to_Boolean( p_init_msg_list )

433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435:
436: -- Initialize message list IF p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )
438: THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441:

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Start');
444:
445:
446: -- Initialize API return status to SUCCESS
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: --
450: -- API body
451: --

Line 461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

457: X_Return_Status => l_return_status,
458: X_Msg_Count => l_msg_count,
459: X_Msg_Data => l_msg_data);
460:
461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');

Line 462: RAISE FND_API.G_EXC_ERROR;

458: X_Msg_Count => l_msg_count,
459: X_Msg_Data => l_msg_data);
460:
461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');
466:

Line 495: IF FND_API.to_Boolean( p_commit )

491: -- End of API body
492: --
493:
494: -- Standard check for p_commit
495: IF FND_API.to_Boolean( p_commit )
496: THEN
497: COMMIT WORK;
498: END IF;
499:

Line 511: WHEN FND_API.G_EXC_ERROR THEN

507: );
508:
509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
515: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');
515: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
516: FND_MSG_PUB.Count_And_Get
517: ( p_count => x_msg_count,

Line 521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

517: ( p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
525: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: );
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');
525: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,

Line 533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

529: );
530:
531: WHEN OTHERS THEN
532: ROLLBACK TO CREATE_OBJECT_FILTER_PVT;
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:OTHER ERROR');
535: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);
536: FND_MSG_PUB.Count_And_Get
537: ( p_count => x_msg_count,

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

542:
543:
544: Procedure Update_OBJECT_FILTER
545: (p_api_version IN NUMBER := 1.0,
546: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
547: p_commit IN VARCHAR2 := FND_API.G_FALSE,
548: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
549: x_dup_status OUT NOCOPY VARCHAR2,
550: x_return_status OUT NOCOPY VARCHAR2,

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

543:
544: Procedure Update_OBJECT_FILTER
545: (p_api_version IN NUMBER := 1.0,
546: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
547: p_commit IN VARCHAR2 := FND_API.G_FALSE,
548: P_FILTER_REC IN IEX_FILTER_PUB.FILTER_REC_TYPE := G_MISS_FILTER_REC,
549: x_dup_status OUT NOCOPY VARCHAR2,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,

Line 596: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

592: SAVEPOINT UPDATE_OBJECT_FILTER_PVT;
593:
594: l_FILTER_REC := P_FILTER_REC;
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)
600: THEN

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)
600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )

Line 605: IF FND_API.to_Boolean( p_init_msg_list )

601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: -- Initialize message list IF p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610: -- Debug Message
611: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:start');
612:
613: -- Initialize API return status to SUCCESS
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: -- added by clchang 02/25/2002
617: -- validate dup filter_Name
618: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:validation:chk_dup_filter_name');

Line 632: RAISE FND_API.G_EXC_ERROR;

628: FND_MSG_PUB.Add;
629: END IF;
630: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;
631: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:dup object_filter_name');
632: RAISE FND_API.G_EXC_ERROR;
633: end if;
634: close C_chk_filter_name;
635:
636: --

Line 663: RAISE FND_API.G_EXC_ERROR;

659: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
660: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
661: FND_MSG_PUB.Add;
662: END IF;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:
666: close C_get_filter_Rec;
667:

Line 670: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)

666: close C_get_filter_Rec;
667:
668:
669: IF (l_filter_ref_rec.last_update_date is NULL or
670: l_filter_ref_rec.last_update_date = FND_API.G_MISS_Date)
671: THEN
672: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
673: THEN
674: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

Line 678: RAISE FND_API.G_EXC_ERROR;

674: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
675: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
676: FND_MSG_PUB.ADD;
677: END IF;
678: RAISE FND_API.G_EXC_ERROR;
679: End IF;
680:
681: -- Transfer Data into target record
682: l_filter_rec.CREATION_DATE := l_filter_ref_rec.CREATION_DATE;

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

681: -- Transfer Data into target record
682: l_filter_rec.CREATION_DATE := l_filter_ref_rec.CREATION_DATE;
683: l_filter_rec.CREATED_BY := l_filter_ref_rec.CREATED_BY;
684:
685: IF ((l_filter_rec.OBJECT_FILTER_NAME = FND_API.G_MISS_CHAR) OR
686: (l_filter_rec.OBJECT_FILTER_NAME = NULL)) THEN
687: l_filter_rec.OBJECT_FILTER_NAME := l_filter_ref_rec.OBJECT_FILTER_NAME;
688: END IF;
689: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR

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

685: IF ((l_filter_rec.OBJECT_FILTER_NAME = FND_API.G_MISS_CHAR) OR
686: (l_filter_rec.OBJECT_FILTER_NAME = NULL)) THEN
687: l_filter_rec.OBJECT_FILTER_NAME := l_filter_ref_rec.OBJECT_FILTER_NAME;
688: END IF;
689: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR
690: (l_filter_rec.OBJECT_FILTER_TYPE = NULL)) THEN
691: l_filter_rec.OBJECT_FILTER_TYPE := l_filter_ref_rec.OBJECT_FILTER_TYPE;
692: END IF;
693: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR

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

689: IF ((l_filter_rec.OBJECT_FILTER_TYPE = FND_API.G_MISS_CHAR) OR
690: (l_filter_rec.OBJECT_FILTER_TYPE = NULL)) THEN
691: l_filter_rec.OBJECT_FILTER_TYPE := l_filter_ref_rec.OBJECT_FILTER_TYPE;
692: END IF;
693: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR
694: (l_filter_rec.OBJECT_ID = NULL)) THEN
695: l_filter_rec.OBJECT_ID := l_filter_ref_rec.OBJECT_ID;
696: END IF;
697: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR

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

693: IF ((l_filter_rec.OBJECT_ID = FND_API.G_MISS_NUM) OR
694: (l_filter_rec.OBJECT_ID = NULL)) THEN
695: l_filter_rec.OBJECT_ID := l_filter_ref_rec.OBJECT_ID;
696: END IF;
697: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR
698: (l_filter_rec.SELECT_COLUMN = NULL)) THEN
699: l_filter_rec.SELECT_COLUMN := l_filter_ref_rec.SELECT_COLUMN;
700: END IF;
701: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR

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

697: IF ((l_filter_rec.SELECT_COLUMN = FND_API.G_MISS_CHAR) OR
698: (l_filter_rec.SELECT_COLUMN = NULL)) THEN
699: l_filter_rec.SELECT_COLUMN := l_filter_ref_rec.SELECT_COLUMN;
700: END IF;
701: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR
702: (l_filter_rec.ENTITY_NAME = NULL)) THEN
703: l_filter_rec.ENTITY_NAME := l_filter_ref_rec.ENTITY_NAME;
704: END IF;
705: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR

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

701: IF ((l_filter_rec.ENTITY_NAME = FND_API.G_MISS_CHAR) OR
702: (l_filter_rec.ENTITY_NAME = NULL)) THEN
703: l_filter_rec.ENTITY_NAME := l_filter_ref_rec.ENTITY_NAME;
704: END IF;
705: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR
706: (l_filter_rec.ACTIVE_FLAG = NULL)) THEN
707: l_filter_rec.ACTIVE_FLAG := l_filter_ref_rec.ACTIVE_FLAG;
708: END IF;
709: IF ((l_filter_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) OR

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

705: IF ((l_filter_rec.ACTIVE_FLAG = FND_API.G_MISS_CHAR) OR
706: (l_filter_rec.ACTIVE_FLAG = NULL)) THEN
707: l_filter_rec.ACTIVE_FLAG := l_filter_ref_rec.ACTIVE_FLAG;
708: END IF;
709: IF ((l_filter_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) OR
710: (l_filter_rec.OBJECT_VERSION_NUMBER = NULL)) THEN
711: l_filter_rec.OBJECT_VERSION_NUMBER := l_filter_ref_rec.OBJECT_VERSION_NUMBER;
712: END IF;
713:

Line 736: IF FND_API.to_Boolean( p_commit )

732: -- End of API body
733: --
734:
735: -- Standard check for p_commit
736: IF FND_API.to_Boolean( p_commit )
737: THEN
738: COMMIT WORK;
739: END IF;
740:

Line 752: WHEN FND_API.G_EXC_ERROR THEN

748: );
749:
750:
751: EXCEPTION
752: WHEN FND_API.G_EXC_ERROR THEN
753: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
756: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750:
751: EXCEPTION
752: WHEN FND_API.G_EXC_ERROR THEN
753: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');
756: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count,

Line 762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

758: ( p_count => x_msg_count,
759: p_data => x_msg_data
760: );
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
766: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

760: );
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');
766: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
767: FND_MSG_PUB.Count_And_Get
768: ( p_count => x_msg_count,

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

770: );
771:
772: WHEN OTHERS THEN
773: ROLLBACK TO UPDATE_OBJECT_FILTER_PVT;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:OTHER ERROR');
776: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);
777: FND_MSG_PUB.Count_And_Get
778: ( p_count => x_msg_count,

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

784:
785:
786: Procedure Delete_OBJECT_FILTER
787: (p_api_version IN NUMBER := 1.0,
788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
789: p_commit IN VARCHAR2 := FND_API.G_FALSE,
790: P_OBJECT_FILTER_ID IN NUMBER,
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_msg_count OUT NOCOPY NUMBER,

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

785:
786: Procedure Delete_OBJECT_FILTER
787: (p_api_version IN NUMBER := 1.0,
788: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
789: p_commit IN VARCHAR2 := FND_API.G_FALSE,
790: P_OBJECT_FILTER_ID IN NUMBER,
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_msg_count OUT NOCOPY NUMBER,
793: x_msg_data OUT NOCOPY VARCHAR2)

Line 812: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

808: -- Standard Start of API savepoint
809: SAVEPOINT DELETE_OBJECT_FILTER_PVT;
810:
811: -- Standard call to check for call compatibility.
812: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
813: p_api_version,
814: l_api_name,
815: G_PKG_NAME)
816: THEN

Line 817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

813: p_api_version,
814: l_api_name,
815: G_PKG_NAME)
816: THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: -- Initialize message list IF p_init_msg_list is set to TRUE.
821: IF FND_API.to_Boolean( p_init_msg_list )

Line 821: IF FND_API.to_Boolean( p_init_msg_list )

817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: -- Initialize message list IF p_init_msg_list is set to TRUE.
821: IF FND_API.to_Boolean( p_init_msg_list )
822: THEN
823: FND_MSG_PUB.initialize;
824: END IF;
825:

Line 831: x_return_status := FND_API.G_RET_STS_SUCCESS;

827: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Start');
828:
829:
830: -- Initialize API return status to SUCCESS
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: --
834: -- API body
835: --

Line 847: RAISE FND_API.G_EXC_ERROR;

843: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
844: FND_MESSAGE.Set_Token ('INFO', 'iex_object_filters', FALSE);
845: FND_MSG_PUB.Add;
846: END IF;
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849:
850: Close C_GET_FILTER;
851:

Line 864: IF FND_API.to_Boolean( p_commit )

860: -- End of API body
861: --
862:
863: -- Standard check for p_commit
864: IF FND_API.to_Boolean( p_commit )
865: THEN
866: COMMIT WORK;
867: END IF;
868:

Line 880: WHEN FND_API.G_EXC_ERROR THEN

876: );
877:
878:
879: EXCEPTION
880: WHEN FND_API.G_EXC_ERROR THEN
881: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
882: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
883: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
884: x_return_status := FND_API.G_RET_STS_ERROR;

Line 884: x_return_status := FND_API.G_RET_STS_ERROR;

880: WHEN FND_API.G_EXC_ERROR THEN
881: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
882: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');
883: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: FND_MSG_PUB.Count_And_Get
886: ( p_count => x_msg_count,
887: p_data => x_msg_data
888: );

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

886: ( p_count => x_msg_count,
887: p_data => x_msg_data
888: );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
894: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

888: );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');
894: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count,

Line 902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

898: );
899:
900: WHEN OTHERS THEN
901: ROLLBACK TO DELETE_OBJECT_FILTER_PVT;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:OTHER ERROR');
904: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,