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

Line 50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_AG_DN_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version,
52: l_api_name,
53: G_PKG_NAME)
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: p_api_version,
52: l_api_name,
53: G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CreateAgDn: start ');
68:
69:
70: -- Initialize API return status to SUCCESS
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: --
74: -- API body
75: --

Line 92: IF x_return_status = FND_API.G_RET_STS_ERROR then

88: , x_msg_count => x_msg_count
89: , x_msg_data => x_msg_data
90: );
91:
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;

Line 93: raise FND_API.G_EXC_ERROR;

89: , x_msg_data => x_msg_data
90: );
91:
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:

Line 94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

90: );
91:
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: l_ag_dn_xref_id_tbl(i) := x_ag_dn_xref_id;

Line 95: raise FND_API.G_EXC_UNEXPECTED_ERROR;

91:
92: IF x_return_status = FND_API.G_RET_STS_ERROR then
93: raise FND_API.G_EXC_ERROR;
94: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
95: raise FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97:
98: l_ag_dn_xref_id_tbl(i) := x_ag_dn_xref_id;
99:

Line 110: IF FND_API.to_Boolean( p_commit )

106: -- End of API body
107: --
108:
109: -- Standard check for p_commit
110: IF FND_API.to_Boolean( p_commit )
111: THEN
112: COMMIT WORK;
113: END IF;
114:

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122: p_data => x_msg_data
123: );
124:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: ROLLBACK TO Create_Ag_Dn_PUB;
129: -- added by gnramasa for bug 5661324 14-Mar-07
130: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: );
124:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: ROLLBACK TO Create_Ag_Dn_PUB;
129: -- added by gnramasa for bug 5661324 14-Mar-07
130: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
131: FND_MSG_PUB.Count_And_Get

Line 135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: ROLLBACK TO Create_Ag_Dn_PUB;
138: -- added by gnramasa for bug 5661324 14-Mar-07
139: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

132: ( p_count => x_msg_count,
133: p_data => x_msg_data );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: ROLLBACK TO Create_Ag_Dn_PUB;
138: -- added by gnramasa for bug 5661324 14-Mar-07
139: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
140: FND_MSG_PUB.Count_And_Get

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: ( p_count => x_msg_count,
142: p_data => x_msg_data );
143:
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: ROLLBACK TO Create_Ag_Dn_PUB;
147: -- added by gnramasa for bug 5661324 14-Mar-07
148: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
149: WriteLog('iexpdunb:CreateAgDn:Exc Exception');

Line 182: IF FND_API.to_Boolean( p_init_msg_list )

178: SAVEPOINT UPDATE_AG_DN_PUB;
179:
180:
181: -- Initialize message list if p_init_msg_list is set to TRUE.
182: IF FND_API.to_Boolean( p_init_msg_list )
183: THEN
184: FND_MSG_PUB.initialize;
185: END IF;
186:

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn: Start ');
190:
191:
192: -- Initialize API return status to SUCCESS
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: --
196: -- Api body
197: --

Line 215: IF x_return_status = FND_API.G_RET_STS_ERROR then

211: , x_msg_count => x_msg_count
212: , x_msg_data => x_msg_data
213: );
214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR then
216: raise FND_API.G_EXC_ERROR;
217: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
218: raise FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;

Line 216: raise FND_API.G_EXC_ERROR;

212: , x_msg_data => x_msg_data
213: );
214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR then
216: raise FND_API.G_EXC_ERROR;
217: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
218: raise FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: END LOOP;

Line 217: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

213: );
214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR then
216: raise FND_API.G_EXC_ERROR;
217: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
218: raise FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: END LOOP;
221:

Line 218: raise FND_API.G_EXC_UNEXPECTED_ERROR;

214:
215: IF x_return_status = FND_API.G_RET_STS_ERROR then
216: raise FND_API.G_EXC_ERROR;
217: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
218: raise FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: END LOOP;
221:
222: --

Line 227: IF FND_API.to_Boolean( p_commit )

223: -- End of API body.
224: --
225:
226: -- Standard check for p_commit
227: IF FND_API.to_Boolean( p_commit )
228: THEN
229: COMMIT WORK;
230: END IF;
231:

Line 242: WHEN FND_API.G_EXC_ERROR THEN

238: ( p_count => x_msg_count,
239: p_data => x_msg_data );
240:
241: EXCEPTION
242: WHEN FND_API.G_EXC_ERROR THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: ROLLBACK TO Update_Ag_Dn_PUB;
245: -- Changed by gnramasa for bug 5661324 14-Mar-07
246: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: p_data => x_msg_data );
240:
241: EXCEPTION
242: WHEN FND_API.G_EXC_ERROR THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: ROLLBACK TO Update_Ag_Dn_PUB;
245: -- Changed by gnramasa for bug 5661324 14-Mar-07
246: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
247: errmsg := SQLERRM;

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

249: FND_MSG_PUB.Count_And_Get
250: ( p_count => x_msg_count,
251: p_data => x_msg_data );
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: ROLLBACK TO Update_Ag_Dn_PUB;
256: -- Changed by gnramasa for bug 5661324 14-Mar-07
257: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: ( p_count => x_msg_count,
251: p_data => x_msg_data );
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: ROLLBACK TO Update_Ag_Dn_PUB;
256: -- Changed by gnramasa for bug 5661324 14-Mar-07
257: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
258: errmsg := SQLERRM;

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: ( p_count => x_msg_count,
262: p_data => x_msg_data );
263:
264: WHEN OTHERS THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: ROLLBACK TO Update_Ag_Dn_PUB;
267: -- Changed by gnramasa for bug 5661324 14-Mar-07
268: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
269: errmsg := SQLERRM;

Line 305: IF FND_API.to_Boolean( p_init_msg_list )

301: SAVEPOINT DELETE_AG_DN_PUB;
302:
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start ');
313:
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: --
319: -- Api body
320: --

Line 331: IF x_return_status = FND_API.G_RET_STS_ERROR then

327: , x_msg_count => x_msg_count
328: , x_msg_data => x_msg_data
329: );
330:
331: IF x_return_status = FND_API.G_RET_STS_ERROR then
332: raise FND_API.G_EXC_ERROR;
333: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;

Line 332: raise FND_API.G_EXC_ERROR;

328: , x_msg_data => x_msg_data
329: );
330:
331: IF x_return_status = FND_API.G_RET_STS_ERROR then
332: raise FND_API.G_EXC_ERROR;
333: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:

Line 333: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

329: );
330:
331: IF x_return_status = FND_API.G_RET_STS_ERROR then
332: raise FND_API.G_EXC_ERROR;
333: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: --

Line 334: raise FND_API.G_EXC_UNEXPECTED_ERROR;

330:
331: IF x_return_status = FND_API.G_RET_STS_ERROR then
332: raise FND_API.G_EXC_ERROR;
333: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: --
338: -- End of API body

Line 342: IF FND_API.to_Boolean( p_commit )

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

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352: ( p_count => x_msg_count,
353: p_data => x_msg_data );
354:
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: ROLLBACK TO Delete_Ag_Dn_PUB;
359: -- Changed by gnramasa for bug 5661324 14-Mar-07
360: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);

Line 357: x_return_status := FND_API.G_RET_STS_ERROR;

353: p_data => x_msg_data );
354:
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_ERROR;
358: ROLLBACK TO Delete_Ag_Dn_PUB;
359: -- Changed by gnramasa for bug 5661324 14-Mar-07
360: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
361: FND_MSG_PUB.Count_And_Get

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count,
363: p_data => x_msg_data );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: ROLLBACK TO Delete_Ag_Dn_PUB;
368: -- Changed by gnramasa for bug 5661324 14-Mar-07
369: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: ( p_count => x_msg_count,
363: p_data => x_msg_data );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: ROLLBACK TO Delete_Ag_Dn_PUB;
368: -- Changed by gnramasa for bug 5661324 14-Mar-07
369: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
370: FND_MSG_PUB.Count_And_Get

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: ( p_count => x_msg_count,
372: p_data => x_msg_data );
373:
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: ROLLBACK TO Delete_Ag_Dn_PUB;
377: -- Changed by gnramasa for bug 5661324 14-Mar-07
378: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
379: FND_MSG_PUB.Count_And_Get

Line 561: IF FND_API.to_Boolean( p_init_msg_list )

557: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_previous_request_id '||p_previous_request_id);
558: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - dunning_plan_id '||p_dunning_plan_id);
559:
560: -- Initialize message list if p_init_msg_list is set to TRUE.
561: IF FND_API.to_Boolean( p_init_msg_list )
562: THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: -- Debug Message
567:
568: if (p_dunning_plan_id is null)
569: THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: -- Initialize API return status to SUCCESS
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569: THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: -- Initialize API return status to SUCCESS
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574:
575: --
576: -- Api body
577: --

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581: If ( C_GET_Bucket%NOTFOUND ) Then
582: -- Changed by gnramasa for bug 5661324 14-Mar-07
583: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO Bucket');
584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bucket');
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: RAISE FND_API.G_EXC_ERROR;
587: end if;
588: CLOSE C_GET_Bucket;
589: -- Changed by gnramasa for bug 5661324 14-Mar-07

Line 586: RAISE FND_API.G_EXC_ERROR;

582: -- Changed by gnramasa for bug 5661324 14-Mar-07
583: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO Bucket');
584: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bucket');
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: RAISE FND_API.G_EXC_ERROR;
587: end if;
588: CLOSE C_GET_Bucket;
589: -- Changed by gnramasa for bug 5661324 14-Mar-07
590: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Bucket='||l_bucket);

Line 651: l_return_status := FND_API.G_RET_STS_SUCCESS;

647: END LOOP;
648: Close C_Get_CUSTOMER_DEL;
649:
650: -- init return msg for each customer
651: l_return_status := FND_API.G_RET_STS_SUCCESS;
652: l_msg_count := 0;
653: l_msg_data := '';
654:
655: WriteLog('***iexpdunb:SEND_DUNN:delCnt='||nDelIdx);

Line 673: l_return_status := FND_API.G_RET_STS_SUCCESS;

669: WriteLog('***iexpdunb:SEND_DUNN:PVT status='||l_return_status);
670:
671: IF l_return_status = 'SKIP' then
672: WriteLog('iexpdunb:SEND_DUNN:skip this party');
673: l_return_status := FND_API.G_RET_STS_SUCCESS;
674: elsif l_return_status = 'X' then
675:
676: if l_repeat then
677: WriteLog('get scoring engine');

Line 686: l_return_status := FND_API.G_RET_STS_SUCCESS;

682: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
683: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
684: l_repeat := false;
685: else
686: l_return_status := FND_API.G_RET_STS_SUCCESS;
687: end if;
688:
689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;

Line 689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then

685: else
686: l_return_status := FND_API.G_RET_STS_SUCCESS;
687: end if;
688:
689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;

Line 690: raise FND_API.G_EXC_ERROR;

686: l_return_status := FND_API.G_RET_STS_SUCCESS;
687: end if;
688:
689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:

Line 691: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

687: end if;
688:
689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: END IF;

Line 692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

688:
689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
690: raise FND_API.G_EXC_ERROR;
691: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695: END IF;
696:

Line 763: l_return_status := FND_API.G_RET_STS_SUCCESS;

759: END LOOP;
760: Close C_Get_ACCOUNT_DEL;
761:
762: -- init return msg for each account
763: l_return_status := FND_API.G_RET_STS_SUCCESS;
764: l_msg_count := 0;
765: l_msg_data := '';
766:
767: WriteLog('***iexpdunb:SEND_DUNN:delCnt='||nDelIdx);

Line 785: l_return_status := FND_API.G_RET_STS_SUCCESS;

781: WriteLog('***iexpdunb:SEND_DUNN:PVT status='||l_return_status);
782:
783: IF l_return_status = 'SKIP' then
784: WriteLog('iexpdunb:SEND_DUNN:skip this account');
785: l_return_status := FND_API.G_RET_STS_SUCCESS;
786: elsif l_return_status = 'X' then
787:
788: if l_repeat then
789: WriteLog('get scoring engine');

Line 798: l_return_status := FND_API.G_RET_STS_SUCCESS;

794: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
795: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
796: l_repeat := false;
797: else
798: l_return_status := FND_API.G_RET_STS_SUCCESS;
799: end if;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
801: raise FND_API.G_EXC_ERROR;
802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then

796: l_repeat := false;
797: else
798: l_return_status := FND_API.G_RET_STS_SUCCESS;
799: end if;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
801: raise FND_API.G_EXC_ERROR;
802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
803: raise FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;

Line 801: raise FND_API.G_EXC_ERROR;

797: else
798: l_return_status := FND_API.G_RET_STS_SUCCESS;
799: end if;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
801: raise FND_API.G_EXC_ERROR;
802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
803: raise FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805: END IF;

Line 802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

798: l_return_status := FND_API.G_RET_STS_SUCCESS;
799: end if;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
801: raise FND_API.G_EXC_ERROR;
802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
803: raise FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805: END IF;
806:

Line 803: raise FND_API.G_EXC_UNEXPECTED_ERROR;

799: end if;
800: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
801: raise FND_API.G_EXC_ERROR;
802: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
803: raise FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805: END IF;
806:
807: END LOOP;

Line 861: l_return_status := FND_API.G_RET_STS_SUCCESS;

857: END LOOP;
858: Close C_Get_SITE_DEL;
859:
860: -- init return msg for each account
861: l_return_status := FND_API.G_RET_STS_SUCCESS;
862: l_msg_count := 0;
863: l_msg_data := '';
864:
865: WriteLog('***iexpdunb:SEND_DUNN:delCnt='||nDelIdx);

Line 883: l_return_status := FND_API.G_RET_STS_SUCCESS;

879: WriteLog('***iexpdunb:SEND_DUNN:PVT status='||l_return_status);
880:
881: IF l_return_status = 'SKIP' then
882: WriteLog('iexpdunb:SEND_DUNN:skip this site');
883: l_return_status := FND_API.G_RET_STS_SUCCESS;
884: elsif l_return_status = 'X' then
885:
886: if l_repeat then
887: WriteLog('get scoring engine');

Line 896: l_return_status := FND_API.G_RET_STS_SUCCESS;

892: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
894: l_repeat := false;
895: else
896: l_return_status := FND_API.G_RET_STS_SUCCESS;
897: end if;
898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
899: raise FND_API.G_EXC_ERROR;
900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then

894: l_repeat := false;
895: else
896: l_return_status := FND_API.G_RET_STS_SUCCESS;
897: end if;
898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
899: raise FND_API.G_EXC_ERROR;
900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
901: raise FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;

Line 899: raise FND_API.G_EXC_ERROR;

895: else
896: l_return_status := FND_API.G_RET_STS_SUCCESS;
897: end if;
898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
899: raise FND_API.G_EXC_ERROR;
900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
901: raise FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: END IF;

Line 900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

896: l_return_status := FND_API.G_RET_STS_SUCCESS;
897: end if;
898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
899: raise FND_API.G_EXC_ERROR;
900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
901: raise FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: END IF;
904:

Line 901: raise FND_API.G_EXC_UNEXPECTED_ERROR;

897: end if;
898: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
899: raise FND_API.G_EXC_ERROR;
900: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
901: raise FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903: END IF;
904:
905: END LOOP;

Line 922: x_return_status := FND_API.G_RET_STS_ERROR;

918: If ( C_GET_DEL%NOTFOUND ) Then
919: if (nIdx = 0) then
920: WriteLog('iexpdunb:SEND_DUNN: NO Del');
921: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Delinquency');
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: end if;
924: exit;
925: else
926: nIdx := nIdx + 1;

Line 958: IF l_return_status = FND_API.G_RET_STS_ERROR then

954: );
955:
956: WriteLog('iexpdunb:SEND_DUNN:Afer Call Pvt: Status='||l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR then
959: raise FND_API.G_EXC_ERROR;
960: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
961: raise FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;

Line 959: raise FND_API.G_EXC_ERROR;

955:
956: WriteLog('iexpdunb:SEND_DUNN:Afer Call Pvt: Status='||l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR then
959: raise FND_API.G_EXC_ERROR;
960: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
961: raise FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;
963:

Line 960: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

956: WriteLog('iexpdunb:SEND_DUNN:Afer Call Pvt: Status='||l_return_status);
957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR then
959: raise FND_API.G_EXC_ERROR;
960: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
961: raise FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;
963:
964: end if; -- end of if (p_running_level);

Line 961: raise FND_API.G_EXC_UNEXPECTED_ERROR;

957:
958: IF l_return_status = FND_API.G_RET_STS_ERROR then
959: raise FND_API.G_EXC_ERROR;
960: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
961: raise FND_API.G_EXC_UNEXPECTED_ERROR;
962: END IF;
963:
964: end if; -- end of if (p_running_level);
965:

Line 976: x_return_status := FND_API.G_RET_STS_ERROR;

972: Fetch c_filter_object into l_select_column,l_entity_name;
973: If ( c_filter_object%NOTFOUND ) Then
974: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO filter object');
975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No filter object');
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: RAISE FND_API.G_EXC_ERROR;
978: end if;
979: CLOSE c_filter_object;
980: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_select_column: '|| l_select_column);

Line 977: RAISE FND_API.G_EXC_ERROR;

973: If ( c_filter_object%NOTFOUND ) Then
974: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO filter object');
975: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No filter object');
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: RAISE FND_API.G_EXC_ERROR;
978: end if;
979: CLOSE c_filter_object;
980: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_select_column: '|| l_select_column);
981: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_entity_name: '||l_entity_name);

Line 1133: l_return_status := FND_API.G_RET_STS_SUCCESS;

1129: ,x_msg_count => l_msg_count
1130: ,x_msg_data => l_msg_data);
1131: IF l_return_status = 'SKIP' then
1132: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this account');
1133: l_return_status := FND_API.G_RET_STS_SUCCESS;
1134:
1135: elsif l_return_status = 'X' then
1136: if l_repeat then
1137: WriteLog('get scoring engine');

Line 1146: l_return_status := FND_API.G_RET_STS_SUCCESS;

1142: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
1144: l_repeat := false;
1145: else
1146: l_return_status := FND_API.G_RET_STS_SUCCESS;
1147: end if;
1148:
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
1150: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - send_level_Failed - CONTINUE');

Line 1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then

1145: else
1146: l_return_status := FND_API.G_RET_STS_SUCCESS;
1147: end if;
1148:
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
1150: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - send_level_Failed - CONTINUE');
1151: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1152: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - send_level_Failed - CONTINUE');
1153: END IF;

Line 1151: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1147: end if;
1148:
1149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR then
1150: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - send_level_Failed - CONTINUE');
1151: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1152: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - send_level_Failed - CONTINUE');
1153: END IF;
1154: else
1155: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_object_id: '||l_object_id || ' does not exist in filter object :' ||l_entity_name || ' so skipping');

Line 1171: -- x_return_status := FND_API.G_RET_STS_ERROR;

1167: Fetch C_Get_DEL into l_del_id, l_party_id, l_account_id, l_customer_site_use_id, l_score;
1168:
1169: --If ( C_GET_DEL%NOTFOUND ) Then
1170: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Delinquency');
1171: -- x_return_status := FND_API.G_RET_STS_ERROR;
1172: --end if;
1173:
1174: exit when C_GET_DEL%NOTFOUND;
1175: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_del_id' || l_del_id);

Line 1209: IF l_return_status = FND_API.G_RET_STS_ERROR then

1205:
1206: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' status='||l_return_status);
1207: -- Start bug 5924158 05/06/07 by gnramasa
1208: /* x_return_status := l_return_status;
1209: IF l_return_status = FND_API.G_RET_STS_ERROR then
1210: raise FND_API.G_EXC_ERROR;
1211: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;

Line 1210: raise FND_API.G_EXC_ERROR;

1206: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' status='||l_return_status);
1207: -- Start bug 5924158 05/06/07 by gnramasa
1208: /* x_return_status := l_return_status;
1209: IF l_return_status = FND_API.G_RET_STS_ERROR then
1210: raise FND_API.G_EXC_ERROR;
1211: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;
1214: */

Line 1211: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1207: -- Start bug 5924158 05/06/07 by gnramasa
1208: /* x_return_status := l_return_status;
1209: IF l_return_status = FND_API.G_RET_STS_ERROR then
1210: raise FND_API.G_EXC_ERROR;
1211: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;
1214: */
1215: -- End bug 5924158 05/06/07 by gnramasa

Line 1212: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1208: /* x_return_status := l_return_status;
1209: IF l_return_status = FND_API.G_RET_STS_ERROR then
1210: raise FND_API.G_EXC_ERROR;
1211: elsif l_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;
1214: */
1215: -- End bug 5924158 05/06/07 by gnramasa
1216: --

Line 1222: IF FND_API.to_Boolean( p_commit )

1218: --
1219:
1220: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - commit');
1221: -- Standard check for p_commit
1222: IF FND_API.to_Boolean( p_commit )
1223: THEN
1224: COMMIT WORK;
1225: END IF;
1226:

Line 1236: WHEN FND_API.G_EXC_ERROR THEN

1232: ( p_count => x_msg_count,
1233: p_data => x_msg_data );
1234:
1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: ROLLBACK TO Send_DUNNING_PUB;
1239: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1240: FND_MSG_PUB.Count_And_Get

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR;

1233: p_data => x_msg_data );
1234:
1235: EXCEPTION
1236: WHEN FND_API.G_EXC_ERROR THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: ROLLBACK TO Send_DUNNING_PUB;
1239: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_count => x_msg_count,

Line 1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1240: FND_MSG_PUB.Count_And_Get
1241: ( p_count => x_msg_count,
1242: p_data => x_msg_data );
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: ROLLBACK TO Send_DUNNING_PUB;
1247: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1248: FND_MSG_PUB.Count_And_Get

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1241: ( p_count => x_msg_count,
1242: p_data => x_msg_data );
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: ROLLBACK TO Send_DUNNING_PUB;
1247: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1248: FND_MSG_PUB.Count_And_Get
1249: ( p_count => x_msg_count,

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1249: ( p_count => x_msg_count,
1250: p_data => x_msg_data );
1251:
1252: WHEN OTHERS THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: ROLLBACK TO Send_DUNNING_PUB;
1255: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1256: FND_MSG_PUB.Count_And_Get
1257: ( p_count => x_msg_count,

Line 1284: IF FND_API.to_Boolean( p_init_msg_list )

1280: -- Standard Start of API savepoint
1281: SAVEPOINT DAILY_DUNNING_PUB;
1282:
1283: -- Initialize message list if p_init_msg_list is set to TRUE.
1284: IF FND_API.to_Boolean( p_init_msg_list )
1285: THEN
1286: FND_MSG_PUB.initialize;
1287: END IF;
1288:

Line 1294: x_return_status := FND_API.G_RET_STS_SUCCESS;

1290: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
1291: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - running_level='||p_running_level);
1292:
1293: -- Initialize API return status to SUCCESS
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295:
1296: --
1297: -- Api body
1298: --

Line 1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1311: );
1312:
1313: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - return status='||x_return_status);
1314:
1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: IF x_return_status = FND_API.G_RET_STS_ERROR then
1317: raise FND_API.G_EXC_ERROR;
1318: else
1319: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1316: IF x_return_status = FND_API.G_RET_STS_ERROR then

1312:
1313: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - return status='||x_return_status);
1314:
1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: IF x_return_status = FND_API.G_RET_STS_ERROR then
1317: raise FND_API.G_EXC_ERROR;
1318: else
1319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;

Line 1317: raise FND_API.G_EXC_ERROR;

1313: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - return status='||x_return_status);
1314:
1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: IF x_return_status = FND_API.G_RET_STS_ERROR then
1317: raise FND_API.G_EXC_ERROR;
1318: else
1319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: END IF;

Line 1319: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1316: IF x_return_status = FND_API.G_RET_STS_ERROR then
1317: raise FND_API.G_EXC_ERROR;
1318: else
1319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: END IF;
1322:
1323: --

Line 1328: IF FND_API.to_Boolean( p_commit )

1324: -- End of API body
1325: --
1326:
1327: -- Standard check for p_commit
1328: IF FND_API.to_Boolean( p_commit )
1329: THEN
1330: COMMIT WORK;
1331: END IF;
1332:

Line 1341: WHEN FND_API.G_EXC_ERROR THEN

1337: ( p_count => x_msg_count,
1338: p_data => x_msg_data );
1339:
1340: EXCEPTION
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: ROLLBACK TO DAILY_DUNNING_PUB;
1344: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1345: FND_MSG_PUB.Count_And_Get

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338: p_data => x_msg_data );
1339:
1340: EXCEPTION
1341: WHEN FND_API.G_EXC_ERROR THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343: ROLLBACK TO DAILY_DUNNING_PUB;
1344: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1345: FND_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count,

Line 1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1345: FND_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data );
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351: ROLLBACK TO DAILY_DUNNING_PUB;
1352: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1353: FND_MSG_PUB.Count_And_Get

Line 1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data );
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351: ROLLBACK TO DAILY_DUNNING_PUB;
1352: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354: ( p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:
1357: WHEN OTHERS THEN
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: ROLLBACK TO DAILY_DUNNING_PUB;
1360: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
1361: FND_MSG_PUB.Count_And_Get
1362: ( p_count => x_msg_count,

Line 1421: retcode := '2'; --FND_API.G_RET_STS_ERROR;

1417: );
1418:
1419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no default resource_id');
1420: errbuf := l_msg_data;
1421: retcode := '2'; --FND_API.G_RET_STS_ERROR;
1422: --retcode := FND_API.G_RET_STS_ERROR;
1423: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1424:
1425: for i in 1..l_msg_count loop

Line 1422: --retcode := FND_API.G_RET_STS_ERROR;

1418:
1419: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no default resource_id');
1420: errbuf := l_msg_data;
1421: retcode := '2'; --FND_API.G_RET_STS_ERROR;
1422: --retcode := FND_API.G_RET_STS_ERROR;
1423: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1424:
1425: for i in 1..l_msg_count loop
1426: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

Line 1461: retcode := '2'; --FND_API.G_RET_STS_ERROR;

1457: p_data => l_msg_data
1458: );
1459:
1460: errbuf := l_msg_data;
1461: retcode := '2'; --FND_API.G_RET_STS_ERROR;
1462: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1463:
1464: for i in 1..l_msg_count loop
1465: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

Line 1476: , p_init_msg_list => FND_API.G_TRUE

1472: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Dunning Callbacks');
1473: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - starting Daily_Dunning');
1474: IEX_DUNNING_PUB.Daily_Dunning(
1475: p_api_version => l_api_version
1476: , p_init_msg_list => FND_API.G_TRUE
1477: , p_commit => FND_API.G_TRUE
1478: , p_running_level => l_running_level
1479: , x_return_status => RETCODE
1480: , x_msg_count => l_msg_count

Line 1477: , p_commit => FND_API.G_TRUE

1473: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - starting Daily_Dunning');
1474: IEX_DUNNING_PUB.Daily_Dunning(
1475: p_api_version => l_api_version
1476: , p_init_msg_list => FND_API.G_TRUE
1477: , p_commit => FND_API.G_TRUE
1478: , p_running_level => l_running_level
1479: , x_return_status => RETCODE
1480: , x_msg_count => l_msg_count
1481: , x_msg_data => ERRBUF

Line 1493: , p_init_msg_list => FND_API.G_TRUE

1489: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Promise Callbacks');
1490:
1491: IEX_PROMISES_BATCH_PUB.PROCESS_PROMISE_CALLBACKS(
1492: p_api_version => l_api_version
1493: , p_init_msg_list => FND_API.G_TRUE
1494: , p_commit => FND_API.G_TRUE
1495: , x_return_status => RETCODE
1496: , x_msg_count => ERRBUF
1497: , x_msg_data => l_msg_data);

Line 1494: , p_commit => FND_API.G_TRUE

1490:
1491: IEX_PROMISES_BATCH_PUB.PROCESS_PROMISE_CALLBACKS(
1492: p_api_version => l_api_version
1493: , p_init_msg_list => FND_API.G_TRUE
1494: , p_commit => FND_API.G_TRUE
1495: , x_return_status => RETCODE
1496: , x_msg_count => ERRBUF
1497: , x_msg_data => l_msg_data);
1498:

Line 1563: retcode := FND_API.G_RET_STS_SUCCESS;

1559: --Start MOAC
1560: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org Id:'|| mo_global.get_current_org_id);
1561: --End MOAC
1562:
1563: retcode := FND_API.G_RET_STS_SUCCESS;
1564: --
1565: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');
1566: OPEN C_Get_Level (dunning_plan_id);
1567: FETCH C_Get_Level INTO l_running_level;

Line 1658: , p_init_msg_list => FND_API.G_TRUE

1654: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - starting Send_Dunning');
1655: END IF;
1656: IEX_DUNNING_PUB.SEND_DUNNING(
1657: p_api_version => l_api_version
1658: , p_init_msg_list => FND_API.G_TRUE
1659: , p_commit => FND_API.G_TRUE
1660: , p_running_level => l_running_level
1661: , p_previous_request_id => p_previous_request_id
1662: , p_dunning_plan_id => dunning_plan_id

Line 1659: , p_commit => FND_API.G_TRUE

1655: END IF;
1656: IEX_DUNNING_PUB.SEND_DUNNING(
1657: p_api_version => l_api_version
1658: , p_init_msg_list => FND_API.G_TRUE
1659: , p_commit => FND_API.G_TRUE
1660: , p_running_level => l_running_level
1661: , p_previous_request_id => p_previous_request_id
1662: , p_dunning_plan_id => dunning_plan_id
1663: , x_return_status => RETCODE

Line 1674: IF (retcode <> FND_API.G_RET_STS_SUCCESS) THEN

1670: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1671: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - status='||retcode);
1672: END IF;
1673:
1674: IF (retcode <> FND_API.G_RET_STS_SUCCESS) THEN
1675: FND_MSG_PUB.Count_And_Get
1676: ( p_count => l_msg_count,
1677: p_data => l_msg_data
1678: );

Line 1698: retcode := '2'; --FND_API.G_RET_STS_UNEXP_ERROR;

1694: End if; -- END of Chk RunningLevel
1695:
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: retcode := '2'; --FND_API.G_RET_STS_UNEXP_ERROR;
1699: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
1701:
1702: END SEND_DUNNING_CONCUR;