DBA Data[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

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:
65: -- Debug Message
66: -- added by gnramasa for bug 5661324 14-Mar-07

Line 120: FND_MSG_PUB.Count_And_Get

116: -- added by gnramasa for bug 5661324 14-Mar-07
117: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CreateAgDn: End ');
118:
119: -- Standard call to get message count and if count is 1, get message info.
120: FND_MSG_PUB.Count_And_Get
121: ( p_count => x_msg_count,
122: p_data => x_msg_data
123: );
124:

Line 131: FND_MSG_PUB.Count_And_Get

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
132: ( p_count => x_msg_count,
133: p_data => x_msg_data );
134:
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 140: FND_MSG_PUB.Count_And_Get

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
141: ( p_count => x_msg_count,
142: p_data => x_msg_data );
143:
144: WHEN OTHERS THEN

Line 150: FND_MSG_PUB.Count_And_Get

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');
150: FND_MSG_PUB.Count_And_Get
151: ( p_count => x_msg_count,
152: p_data => x_msg_data );
153:
154: END CREATE_AG_DN_XREF;

Line 184: FND_MSG_PUB.initialize;

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:
187: -- Debug Message
188: -- added by gnramasa for bug 5661324 14-Mar-07

Line 237: FND_MSG_PUB.Count_And_Get

233: -- Changed by gnramasa for bug 5661324 14-Mar-07
234: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn: end ');
235:
236: -- Standard call to get message count and if count is 1, get message info.
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data );
240:
241: EXCEPTION

Line 249: FND_MSG_PUB.Count_And_Get

245: -- Changed by gnramasa for bug 5661324 14-Mar-07
246: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
247: errmsg := SQLERRM;
248: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:error='||errmsg);
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

Line 260: FND_MSG_PUB.Count_And_Get

256: -- Changed by gnramasa for bug 5661324 14-Mar-07
257: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
258: errmsg := SQLERRM;
259: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:error='||errmsg);
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data );
263:
264: WHEN OTHERS THEN

Line 272: FND_MSG_PUB.Count_And_Get

268: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
269: errmsg := SQLERRM;
270: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:error='||errmsg);
271: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UpdateAgDn:Exc Exception');
272: FND_MSG_PUB.Count_And_Get
273: ( p_count => x_msg_count,
274: p_data => x_msg_data );
275:
276: END Update_AG_DN_XREF;

Line 307: FND_MSG_PUB.initialize;

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:
310: -- Debug Message
311: -- Changed by gnramasa for bug 5661324 14-Mar-07

Line 351: FND_MSG_PUB.Count_And_Get

347: -- Debug Message
348: -- Changed by gnramasa for bug 5661324 14-Mar-07
349: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End ');
350:
351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data );
354:
355: EXCEPTION

Line 361: FND_MSG_PUB.Count_And_Get

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
362: ( p_count => x_msg_count,
363: p_data => x_msg_data );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 370: FND_MSG_PUB.Count_And_Get

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
371: ( p_count => x_msg_count,
372: p_data => x_msg_data );
373:
374: WHEN OTHERS THEN

Line 379: FND_MSG_PUB.Count_And_Get

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
380: ( p_count => x_msg_count,
381: p_data => x_msg_data );
382:
383: END Delete_AG_DN_XREF;

Line 563: FND_MSG_PUB.initialize;

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:
566: -- Debug Message
567:

Line 1231: FND_MSG_PUB.Count_And_Get

1227: -- Debug Message
1228: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - return status='||x_return_status);
1229: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - END');
1230:
1231: FND_MSG_PUB.Count_And_Get
1232: ( p_count => x_msg_count,
1233: p_data => x_msg_data );
1234:
1235: EXCEPTION

Line 1240: FND_MSG_PUB.Count_And_Get

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,
1242: p_data => x_msg_data );
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1248: FND_MSG_PUB.Count_And_Get

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,
1250: p_data => x_msg_data );
1251:
1252: WHEN OTHERS THEN

Line 1256: FND_MSG_PUB.Count_And_Get

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,
1258: p_data => x_msg_data );
1259:
1260: END Send_Dunning;

Line 1286: FND_MSG_PUB.initialize;

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:
1289: -- Debug Message
1290: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');

Line 1336: FND_MSG_PUB.Count_And_Get

1332:
1333: -- Debug Message
1334: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - end ');
1335:
1336: FND_MSG_PUB.Count_And_Get
1337: ( p_count => x_msg_count,
1338: p_data => x_msg_data );
1339:
1340: EXCEPTION

Line 1345: FND_MSG_PUB.Count_And_Get

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,
1347: p_data => x_msg_data );
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1353: FND_MSG_PUB.Count_And_Get

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,
1355: p_data => x_msg_data );
1356:
1357: WHEN OTHERS THEN

Line 1361: FND_MSG_PUB.Count_And_Get

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,
1363: p_data => x_msg_data );
1364:
1365: END Daily_Dunning;

Line 1412: FND_MSG_PUB.Add;

1408: if (l_default_rs_id = 0 or l_default_rs_id is null) then
1409: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - CALLBACK_CONCUR:no rs_id');
1410: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE');
1411: FND_MESSAGE.Set_Token ('PROFILE', 'IEX_STRY_DEFAULT_RESOURCE', FALSE);
1412: FND_MSG_PUB.Add;
1413:
1414: FND_MSG_PUB.Count_And_Get
1415: ( p_count => l_msg_count,
1416: p_data => l_msg_data

Line 1414: FND_MSG_PUB.Count_And_Get

1410: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE');
1411: FND_MESSAGE.Set_Token ('PROFILE', 'IEX_STRY_DEFAULT_RESOURCE', FALSE);
1412: FND_MSG_PUB.Add;
1413:
1414: FND_MSG_PUB.Count_And_Get
1415: ( p_count => l_msg_count,
1416: p_data => l_msg_data
1417: );
1418:

Line 1426: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

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,
1427: p_encoded => 'F');
1428: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
1429: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1430: end loop;

Line 1453: FND_MSG_PUB.Add;

1449: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - no running level');
1450: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Dunning Running Level');
1451: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1452: FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS DUNNING LEVEL', FALSE);
1453: FND_MSG_PUB.Add;
1454:
1455: FND_MSG_PUB.Count_And_Get
1456: ( p_count => l_msg_count,
1457: p_data => l_msg_data

Line 1455: FND_MSG_PUB.Count_And_Get

1451: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1452: FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS DUNNING LEVEL', FALSE);
1453: FND_MSG_PUB.Add;
1454:
1455: FND_MSG_PUB.Count_And_Get
1456: ( p_count => l_msg_count,
1457: p_data => l_msg_data
1458: );
1459:

Line 1465: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

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,
1466: p_encoded => 'F');
1467: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calback_Concur errmsg =' ||errmsg);
1469: end loop;

Line 1585: FND_MSG_PUB.Add;

1581: iex_debug_pub.LogMessage('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - no running level');
1582: END IF;
1583: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1584: FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS DUNNING LEVEL', FALSE);
1585: FND_MSG_PUB.Add;
1586:
1587: FND_MSG_PUB.Count_And_Get
1588: ( p_count => l_msg_count,
1589: p_data => l_msg_data

Line 1587: FND_MSG_PUB.Count_And_Get

1583: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1584: FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS DUNNING LEVEL', FALSE);
1585: FND_MSG_PUB.Add;
1586:
1587: FND_MSG_PUB.Count_And_Get
1588: ( p_count => l_msg_count,
1589: p_data => l_msg_data
1590: );
1591:

Line 1598: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

1594: retcode := '2';
1595: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1596:
1597: for i in 1..l_msg_count loop
1598: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
1599: p_encoded => 'F');
1600: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
1601: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1602: end loop;

Line 1624: FND_MSG_PUB.Add;

1620: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - no bucket');
1621: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1622: --FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS AGING BUCKET', FALSE);
1623: FND_MESSAGE.Set_Token('COLUMN', 'DUNNING PLAN AGING BUCKET', FALSE);
1624: FND_MSG_PUB.Add;
1625:
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_count => l_msg_count,
1628: p_data => l_msg_data

Line 1626: FND_MSG_PUB.Count_And_Get

1622: --FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS AGING BUCKET', FALSE);
1623: FND_MESSAGE.Set_Token('COLUMN', 'DUNNING PLAN AGING BUCKET', FALSE);
1624: FND_MSG_PUB.Add;
1625:
1626: FND_MSG_PUB.Count_And_Get
1627: ( p_count => l_msg_count,
1628: p_data => l_msg_data
1629: );
1630:

Line 1637: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

1633: retcode := '2';
1634: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1635:
1636: for i in 1..l_msg_count loop
1637: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
1638: p_encoded => 'F');
1639: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
1640: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1641: end loop;

Line 1675: FND_MSG_PUB.Count_And_Get

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

Line 1685: errmsg := FND_MSG_PUB.Get(p_msg_index => i,

1681: retcode := '2';
1682: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
1683:
1684: for i in 1..l_msg_count loop
1685: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
1686: p_encoded => 'F');
1687: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
1688: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1689: end loop;