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 IEX_DUNNING_PVT

Line 159: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter');

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
162: -- validate object_filter_id
163: /*

Line 177: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');

173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175: */
176:
177: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR');
178: -- validate object_filter_name
179: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.object_filter_name,
180: P_COL_NAME => 'OBJECT_FILTER_NAME',
181: P_TABLE_NAME => 'IEX_OBJECT_FILTERS',

Line 187: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_Any_VARCHAR:'||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
190: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: x_dup_status := IEX_SCORE_PVT.IEX_DUPLICATE_NAME;

Line 197: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:');

193: --dbms_output.put_line('dup=' || x_dup_status);
194: END IF;
195:
196: -- validate lookup_type/ code
197: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:');
198: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:lookup_code:'||p_filter_rec.object_filter_type);
199: IEX_UTILITIES.validate_lookup_code(P_LOOKUP_TYPE => 'IEX_OBJECT_FILTERS',
200: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
201: X_Return_Status => l_return_status,

Line 198: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:lookup_code:'||p_filter_rec.object_filter_type);

194: END IF;
195:
196: -- validate lookup_type/ code
197: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:');
198: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:lookup_code:'||p_filter_rec.object_filter_type);
199: IEX_UTILITIES.validate_lookup_code(P_LOOKUP_TYPE => 'IEX_OBJECT_FILTERS',
200: P_LOOKUP_CODE => p_filter_rec.OBJECT_FILTER_TYPE,
201: X_Return_Status => l_return_status,
202: X_Msg_Count => x_msg_count,

Line 207: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_lookup_Code:'||l_return_status);

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
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: --dbms_output.put_line('Validating Obj Filter Type ' || l_return_status);

Line 229: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:');

225: l_table_name := 'IEX_CUST_STATUS_RULES';
226: l_col_name := 'STATUS_RULE_ID';
227: end if;
228:
229: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:');
230: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => p_filter_rec.object_id,
231: P_COL_NAME => l_col_name,
232: P_TABLE_NAME => l_table_name,
233: X_Return_Status => l_return_status,

Line 238: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_id:'||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
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;

Line 252: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');

248: * and ADMIN UI will check ENTITY and COLUMN,
249: * we dont validate entity(view) and column here.
250: *
251: -- validate entity_name
252: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');
253: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.ENTITY_NAME,
254: P_COL_NAME => 'VIEW_NAME',
255: P_TABLE_NAME => 'ALL_VIEWS',
256: X_Return_Status => l_return_status,

Line 267: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:Validate_any_varchar');

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');
268: IEX_UTILITIES.VALIDATE_ANY_VARCHAR(P_COL_VALUE => p_filter_rec.SELECT_COLUMN,
269: P_COL_NAME => 'COLUMN_NAME',
270: P_TABLE_NAME => 'ALL_TAB_COLUMNS',
271: X_Return_Status => l_return_status,

Line 292: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:EXC ERROR');

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
296: ( p_count => x_msg_count,

Line 294: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);

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
298: );

Line 302: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:UNEXC ERROR');

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,
306: p_data => x_msg_data

Line 303: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);

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,
306: p_data => x_msg_data
307: );

Line 311: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:OTHERS ERROR');

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,
315: p_data => x_msg_data

Line 312: iex_dunning_pvt.WriteLog('iexpfilb:Validate_Filter:err='||SQLERRM);

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,
315: p_data => x_msg_data
316: );

Line 365: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Start');

361: FND_MSG_PUB.initialize;
362: END IF;
363:
364: -- Debug Message
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;

Line 376: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Calling Validate_Filter');

372: -- API body
373: --
374:
375: -- Validate Data
376: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:Calling Validate_Filter');
377: Validate_FILTER(P_FILTER_rec => l_filter_rec,
378: X_Dup_Status => x_dup_status,
379: X_Return_Status => l_return_status,
380: X_Msg_Count => l_msg_count,

Line 387: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');

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:
389: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id
390: From Dual;
391: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);

Line 391: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);

387: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:get object_filter_id from seq');
388:
389: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id
390: From Dual;
391: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);
392:
393: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');
394:
395: -- Create Filter

Line 393: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');

389: Select IEX_OBJECT_FILTERS_S.nextval into x_filter_id
390: From Dual;
391: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:object_filter_id='||x_filter_id);
392:
393: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:insert row');
394:
395: -- Create Filter
396: IEX_OBJECT_FILTERS_PKG.insert_row(
397: x_rowid => l_rowid

Line 423: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:end');

419: COMMIT WORK;
420: END IF;
421:
422: -- Debug Message
423: iex_dunning_pvt.WriteLog('iexpfilb:CreateFilter:end');
424:
425: -- Standard call to get message count and IF count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: ( p_count => x_msg_count,

Line 436: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:EXC ERROR');

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,
440: p_data => x_msg_data

Line 437: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

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,
440: p_data => x_msg_data
441: );

Line 446: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:UNEXC ERROR');

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,
450: p_data => x_msg_data

Line 447: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

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,
450: p_data => x_msg_data
451: );

Line 456: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:OTHER ERROR');

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,
460: p_data => x_msg_data

Line 457: iex_dunning_pvt.WriteLog('iexpfilb:CreatedFilter:err='||SQLERRM);

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,
460: p_data => x_msg_data
461: );

Line 533: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:start');

529: FND_MSG_PUB.initialize;
530: END IF;
531:
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:

Line 540: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:validation:chk_dup_filter_name');

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');
541: Open C_chk_filter_name(l_FILTER_REC.OBJECT_FILTER_ID,
542: l_FILTER_REC.OBJECT_FILTER_NAME);
543: Fetch C_chk_filter_name into l_NAME_CNT;
544: if (l_name_cnt > 0) then

Line 553: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:dup object_filter_name');

549: FND_MESSAGE.Set_Token ('VALUE', l_Filter_rec.object_filter_name, FALSE);
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:

Line 636: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:update row');

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:
636: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:update row');
637: IEX_OBJECT_FILTERS_PKG.update_row(
638: x_rowid => l_rowid
639: ,p_object_filter_id => l_filter_rec.object_filter_id
640: ,p_object_filter_type => l_FILTER_REC.object_filter_type

Line 664: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:end');

660: COMMIT WORK;
661: END IF;
662:
663: -- Debug Message
664: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:end');
665:
666: -- Standard call to get message count and IF count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: ( p_count => x_msg_count,

Line 677: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:EXC ERROR');

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,
681: p_data => x_msg_data

Line 678: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

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,
681: p_data => x_msg_data
682: );

Line 687: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:UNEXC ERROR');

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,
691: p_data => x_msg_data

Line 688: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

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,
691: p_data => x_msg_data
692: );

Line 697: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:OTHER ERROR');

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,
701: p_data => x_msg_data

Line 698: iex_dunning_pvt.WriteLog('iexpfilb:UpdateFilter:err='||SQLERRM);

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,
701: p_data => x_msg_data
702: );

Line 749: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Start');

745: FND_MSG_PUB.initialize;
746: END IF;
747:
748: -- Debug Message
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;

Line 774: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Delete Row');

770: END IF;
771:
772: Close C_GET_FILTER;
773:
774: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:Delete Row');
775:
776: -- Invoke table handler
777: IEX_object_filters_PKG.Delete_Row(
778: x_rowid => l_rowid);

Line 792: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:End');

788: COMMIT WORK;
789: END IF;
790:
791: -- Debug Message
792: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:End');
793:
794: -- Standard call to get message count and IF count is 1, get message info.
795: FND_MSG_PUB.Count_And_Get
796: ( p_count => x_msg_count,

Line 804: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:EXP ERROR');

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;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,

Line 805: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);

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;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data

Line 815: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:UNEXP ERROR');

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,
819: p_data => x_msg_data

Line 816: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);

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,
819: p_data => x_msg_data
820: );

Line 825: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:OTHER ERROR');

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,
829: p_data => x_msg_data

Line 826: iex_dunning_pvt.WriteLog('iexpfilb:DeleteFilter:err='||SQLERRM);

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,
829: p_data => x_msg_data
830: );