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

Line 159: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

155: BEGIN
156: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
157: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: this procedure has been obsoleted - no actions have beed done.');
158: END IF;
159: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
160:
161: /*
162: Commented out whole procedure because PROB now can apply payments to promises or
163: reverse payments from promises automatically.

Line 180: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

176: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
177: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
178: END IF;
179: -- Standard call to check for call compatibility
180: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
178: END IF;
179: -- Standard call to check for call compatibility
180: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE
185: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 185: IF FND_API.To_Boolean(p_init_msg_list) THEN

181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE
185: IF FND_API.To_Boolean(p_init_msg_list) THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: -- Initialize API return status to success

Line 190: l_return_status := FND_API.G_RET_STS_SUCCESS;

186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: -- Initialize API return status to success
190: l_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: -- START OF BODY OF API
193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
194: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 261: IF FND_API.To_Boolean( p_commit ) THEN

257: END IF;
258: -- END OF BODY OF API
259:
260: -- Standard check of p_commit.
261: IF FND_API.To_Boolean( p_commit ) THEN
262: COMMIT WORK;
263: END IF;
264:
265: x_return_status := l_return_status;

Line 268: p_encoded => FND_API.G_FALSE,

264:
265: x_return_status := l_return_status;
266: -- Standard call to get message count and if count is 1, get message info
267: FND_MSG_PUB.Count_And_Get(
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: EXCEPTION

Line 273: WHEN FND_API.G_EXC_ERROR THEN

269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO CLOSE_PROMISES_PVT;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271:
272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO CLOSE_PROMISES_PVT;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
278: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
279: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

283:
284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
285: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to close promises');
286: END IF;
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO CLOSE_PROMISES_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
291: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to close promises');
286: END IF;
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO CLOSE_PROMISES_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
291: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
292: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
293: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to close promises');
299: END IF;
300: WHEN OTHERS THEN
301: ROLLBACK TO CLOSE_PROMISES_PVT;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
305: END IF;
306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 361: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

357:
358: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
359: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: this procedure has been obsoleted - no actions have beed done.');
360: END IF;
361: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
362:
363: /*
364: Commented out whole procedure because PROB now can apply payments to promises or
365: reverse payments from promises automatically.

Line 379: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
376: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: Savepoint is established');
377: END IF;
378: -- Standard call to check for call compatibility
379: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: -- Initialize message list if p_init_msg_list is set to TRUE

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: Savepoint is established');
377: END IF;
378: -- Standard call to check for call compatibility
379: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: -- Initialize message list if p_init_msg_list is set to TRUE
384: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 384: IF FND_API.To_Boolean(p_init_msg_list) THEN

380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: -- Initialize message list if p_init_msg_list is set to TRUE
384: IF FND_API.To_Boolean(p_init_msg_list) THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: -- Initialize API return status to success

Line 389: l_return_status := FND_API.G_RET_STS_SUCCESS;

385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: -- Initialize API return status to success
389: l_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: -- START OF BODY OF API
392: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
393: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: Start of body');

Line 497: IF FND_API.To_Boolean( p_commit ) THEN

493: END IF;
494: -- END OF BODY OF API
495:
496: -- Standard check of p_commit.
497: IF FND_API.To_Boolean( p_commit ) THEN
498: COMMIT WORK;
499: END IF;
500:
501: x_return_status := l_return_status;

Line 504: p_encoded => FND_API.G_FALSE,

500:
501: x_return_status := l_return_status;
502: -- Standard call to get message count and if count is 1, get message info
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: EXCEPTION

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
511: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_ERROR execption');
512: END IF;
513: ROLLBACK TO CLOSE_PROMISES_PVT;

Line 511: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_ERROR execption');

507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
511: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_ERROR execption');
512: END IF;
513: ROLLBACK TO CLOSE_PROMISES_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
511: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_ERROR execption');
512: END IF;
513: ROLLBACK TO CLOSE_PROMISES_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
516: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
517: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
518: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
519: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.CLOSE_PROMISES',
520: -- P_MESSAGE => 'Failed to close promises.' );
521: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
524: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_UNEXPECTED_ERROR execption');
525: END IF;
526: ROLLBACK TO CLOSE_PROMISES_PVT;

Line 524: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_UNEXPECTED_ERROR execption');

520: -- P_MESSAGE => 'Failed to close promises.' );
521: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
524: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_UNEXPECTED_ERROR execption');
525: END IF;
526: ROLLBACK TO CLOSE_PROMISES_PVT;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
524: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in FND_API.G_EXC_UNEXPECTED_ERROR execption');
525: END IF;
526: ROLLBACK TO CLOSE_PROMISES_PVT;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
529: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
530: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
531: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

536: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
537: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in OTHERS execption');
538: END IF;
539: ROLLBACK TO CLOSE_PROMISES_PVT;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
542: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
543: END IF;
544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 578: P_INIT_MSG_LIST => FND_API.G_TRUE,

574: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit: '|| nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
575:
576: PROCESS_ALL_PROMISES(
577: P_API_VERSION => 1.0,
578: P_INIT_MSG_LIST => FND_API.G_TRUE,
579: P_COMMIT => FND_API.G_TRUE,
580: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
581: X_RETURN_STATUS => RETCODE,
582: X_MSG_COUNT => l_msg_count,

Line 579: P_COMMIT => FND_API.G_TRUE,

575:
576: PROCESS_ALL_PROMISES(
577: P_API_VERSION => 1.0,
578: P_INIT_MSG_LIST => FND_API.G_TRUE,
579: P_COMMIT => FND_API.G_TRUE,
580: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
581: X_RETURN_STATUS => RETCODE,
582: X_MSG_COUNT => l_msg_count,
583: X_MSG_DATA => ERRBUF);

Line 580: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

576: PROCESS_ALL_PROMISES(
577: P_API_VERSION => 1.0,
578: P_INIT_MSG_LIST => FND_API.G_TRUE,
579: P_COMMIT => FND_API.G_TRUE,
580: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
581: X_RETURN_STATUS => RETCODE,
582: X_MSG_COUNT => l_msg_count,
583: X_MSG_DATA => ERRBUF);
584: END;

Line 744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
742: END IF;
743: -- Standard call to check for call compatibility
744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

741: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
742: END IF;
743: -- Standard call to check for call compatibility
744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE
749: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 749: IF FND_API.To_Boolean(p_init_msg_list) THEN

745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE
749: IF FND_API.To_Boolean(p_init_msg_list) THEN
750: FND_MSG_PUB.initialize;
751: END IF;
752:
753: -- Initialize API return status to success

Line 754: l_return_status := FND_API.G_RET_STS_SUCCESS;

750: FND_MSG_PUB.initialize;
751: END IF;
752:
753: -- Initialize API return status to success
754: l_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756: -- START OF BODY OF API
757: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
758: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 767: P_INIT_MSG_LIST => FND_API.G_TRUE,

763: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling PROCESS_REVERSALS for AR ');
764: END IF;
765: PROCESS_REVERSALS(
766: P_API_VERSION => 1.0,
767: P_INIT_MSG_LIST => FND_API.G_TRUE,
768: P_COMMIT => FND_API.G_TRUE,
769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
770: X_RETURN_STATUS => l_return_status,
771: X_MSG_COUNT => l_msg_count,

Line 768: P_COMMIT => FND_API.G_TRUE,

764: END IF;
765: PROCESS_REVERSALS(
766: P_API_VERSION => 1.0,
767: P_INIT_MSG_LIST => FND_API.G_TRUE,
768: P_COMMIT => FND_API.G_TRUE,
769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
770: X_RETURN_STATUS => l_return_status,
771: X_MSG_COUNT => l_msg_count,
772: X_MSG_DATA => l_msg_data,

Line 769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

765: PROCESS_REVERSALS(
766: P_API_VERSION => 1.0,
767: P_INIT_MSG_LIST => FND_API.G_TRUE,
768: P_COMMIT => FND_API.G_TRUE,
769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
770: X_RETURN_STATUS => l_return_status,
771: X_MSG_COUNT => l_msg_count,
772: X_MSG_DATA => l_msg_data,
773: P_TYPE => 'AR');

Line 781: P_INIT_MSG_LIST => FND_API.G_TRUE,

777: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling PROCESS_REVERSALS for OKL ');
778: END IF;
779: PROCESS_REVERSALS(
780: P_API_VERSION => 1.0,
781: P_INIT_MSG_LIST => FND_API.G_TRUE,
782: P_COMMIT => FND_API.G_TRUE,
783: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
784: X_RETURN_STATUS => l_return_status,
785: X_MSG_COUNT => l_msg_count,

Line 782: P_COMMIT => FND_API.G_TRUE,

778: END IF;
779: PROCESS_REVERSALS(
780: P_API_VERSION => 1.0,
781: P_INIT_MSG_LIST => FND_API.G_TRUE,
782: P_COMMIT => FND_API.G_TRUE,
783: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
784: X_RETURN_STATUS => l_return_status,
785: X_MSG_COUNT => l_msg_count,
786: X_MSG_DATA => l_msg_data,

Line 783: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

779: PROCESS_REVERSALS(
780: P_API_VERSION => 1.0,
781: P_INIT_MSG_LIST => FND_API.G_TRUE,
782: P_COMMIT => FND_API.G_TRUE,
783: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
784: X_RETURN_STATUS => l_return_status,
785: X_MSG_COUNT => l_msg_count,
786: X_MSG_DATA => l_msg_data,
787: P_TYPE => 'OKL');

Line 795: P_INIT_MSG_LIST => FND_API.G_TRUE,

791: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on AR invoices...');
792: END IF;
793: PROCESS_PROMISES(
794: P_API_VERSION => 1.0,
795: P_INIT_MSG_LIST => FND_API.G_TRUE,
796: P_COMMIT => FND_API.G_TRUE,
797: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
798: X_RETURN_STATUS => l_return_status,
799: X_MSG_COUNT => l_msg_count,

Line 796: P_COMMIT => FND_API.G_TRUE,

792: END IF;
793: PROCESS_PROMISES(
794: P_API_VERSION => 1.0,
795: P_INIT_MSG_LIST => FND_API.G_TRUE,
796: P_COMMIT => FND_API.G_TRUE,
797: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
798: X_RETURN_STATUS => l_return_status,
799: X_MSG_COUNT => l_msg_count,
800: X_MSG_DATA => l_msg_data,

Line 797: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

793: PROCESS_PROMISES(
794: P_API_VERSION => 1.0,
795: P_INIT_MSG_LIST => FND_API.G_TRUE,
796: P_COMMIT => FND_API.G_TRUE,
797: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
798: X_RETURN_STATUS => l_return_status,
799: X_MSG_COUNT => l_msg_count,
800: X_MSG_DATA => l_msg_data,
801: P_TYPE => 'INV');

Line 809: P_INIT_MSG_LIST => FND_API.G_TRUE,

805: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on AR account...');
806: END IF;
807: PROCESS_PROMISES(
808: P_API_VERSION => 1.0,
809: P_INIT_MSG_LIST => FND_API.G_TRUE,
810: P_COMMIT => FND_API.G_TRUE,
811: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
812: X_RETURN_STATUS => l_return_status,
813: X_MSG_COUNT => l_msg_count,

Line 810: P_COMMIT => FND_API.G_TRUE,

806: END IF;
807: PROCESS_PROMISES(
808: P_API_VERSION => 1.0,
809: P_INIT_MSG_LIST => FND_API.G_TRUE,
810: P_COMMIT => FND_API.G_TRUE,
811: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
812: X_RETURN_STATUS => l_return_status,
813: X_MSG_COUNT => l_msg_count,
814: X_MSG_DATA => l_msg_data,

Line 811: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

807: PROCESS_PROMISES(
808: P_API_VERSION => 1.0,
809: P_INIT_MSG_LIST => FND_API.G_TRUE,
810: P_COMMIT => FND_API.G_TRUE,
811: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
812: X_RETURN_STATUS => l_return_status,
813: X_MSG_COUNT => l_msg_count,
814: X_MSG_DATA => l_msg_data,
815: P_TYPE => 'ACC');

Line 823: P_INIT_MSG_LIST => FND_API.G_TRUE,

819: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on OKL contracts...');
820: END IF;
821: PROCESS_PROMISES(
822: P_API_VERSION => 1.0,
823: P_INIT_MSG_LIST => FND_API.G_TRUE,
824: P_COMMIT => FND_API.G_TRUE,
825: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
826: X_RETURN_STATUS => l_return_status,
827: X_MSG_COUNT => l_msg_count,

Line 824: P_COMMIT => FND_API.G_TRUE,

820: END IF;
821: PROCESS_PROMISES(
822: P_API_VERSION => 1.0,
823: P_INIT_MSG_LIST => FND_API.G_TRUE,
824: P_COMMIT => FND_API.G_TRUE,
825: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
826: X_RETURN_STATUS => l_return_status,
827: X_MSG_COUNT => l_msg_count,
828: X_MSG_DATA => l_msg_data,

Line 825: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

821: PROCESS_PROMISES(
822: P_API_VERSION => 1.0,
823: P_INIT_MSG_LIST => FND_API.G_TRUE,
824: P_COMMIT => FND_API.G_TRUE,
825: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
826: X_RETURN_STATUS => l_return_status,
827: X_MSG_COUNT => l_msg_count,
828: X_MSG_DATA => l_msg_data,
829: P_TYPE => 'CNTR');

Line 837: IF FND_API.To_Boolean( p_commit ) THEN

833: END IF;
834: -- END OF BODY OF API
835:
836: -- Standard check of p_commit.
837: IF FND_API.To_Boolean( p_commit ) THEN
838: COMMIT WORK;
839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
840: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
841: END IF;

Line 847: p_encoded => FND_API.G_FALSE,

843:
844: x_return_status := l_return_status;
845: -- Standard call to get message count and if count is 1, get message info
846: FND_MSG_PUB.Count_And_Get(
847: p_encoded => FND_API.G_FALSE,
848: p_count => x_msg_count,
849: p_data => x_msg_data);
850:
851: -- Start bug#5874874 gnramasa 25-Apr-07

Line 962: WHEN FND_API.G_EXC_ERROR THEN

958: END;
959:
960: -- End bug#5874874 gnramasa 25-Apr-07
961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960: -- End bug#5874874 gnramasa 25-Apr-07
961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
967: /*
968: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

973: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
974: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
975: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process all promises');
976: END IF;
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
981: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

975: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process all promises');
976: END IF;
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
981: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
982: /*
983: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to process all promises');
991: END IF;
992: WHEN OTHERS THEN
993: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
996: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
997: END IF;
998: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1061: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1057: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1058: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1059: END IF;
1060: -- Standard call to check for call compatibility
1061: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;
1064:
1065: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1058: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1059: END IF;
1060: -- Standard call to check for call compatibility
1061: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;
1064:
1065: -- Initialize message list if p_init_msg_list is set to TRUE
1066: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1066: IF FND_API.To_Boolean(p_init_msg_list) THEN

1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;
1064:
1065: -- Initialize message list if p_init_msg_list is set to TRUE
1066: IF FND_API.To_Boolean(p_init_msg_list) THEN
1067: FND_MSG_PUB.initialize;
1068: END IF;
1069:
1070: -- Initialize API return status to success

Line 1071: l_return_status := FND_API.G_RET_STS_SUCCESS;

1067: FND_MSG_PUB.initialize;
1068: END IF;
1069:
1070: -- Initialize API return status to success
1071: l_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: -- START OF BODY OF API
1074: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1075: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 1313: IF FND_API.To_Boolean( p_commit ) THEN

1309: END IF;
1310: -- END OF BODY OF API
1311:
1312: -- Standard check of p_commit.
1313: IF FND_API.To_Boolean( p_commit ) THEN
1314: COMMIT WORK;
1315: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1316: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
1317: END IF;

Line 1323: p_encoded => FND_API.G_FALSE,

1319:
1320: x_return_status := l_return_status;
1321: -- Standard call to get message count and if count is 1, get message info
1322: FND_MSG_PUB.Count_And_Get(
1323: p_encoded => FND_API.G_FALSE,
1324: p_count => x_msg_count,
1325: p_data => x_msg_data);
1326:
1327: EXCEPTION

Line 1329: WHEN FND_API.G_EXC_ERROR THEN

1325: p_data => x_msg_data);
1326:
1327: EXCEPTION
1328:
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: ROLLBACK TO PROCESS_REVERSALS_PVT;
1331: x_return_status := FND_API.G_RET_STS_ERROR;
1332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1333: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1331: x_return_status := FND_API.G_RET_STS_ERROR;

1327: EXCEPTION
1328:
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: ROLLBACK TO PROCESS_REVERSALS_PVT;
1331: x_return_status := FND_API.G_RET_STS_ERROR;
1332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1333: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1334: /*
1335: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1340: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1341: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1342: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to reverse promise applications');
1343: END IF;
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1345: ROLLBACK TO PROCESS_REVERSALS_PVT;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1348: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1342: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to reverse promise applications');
1343: END IF;
1344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1345: ROLLBACK TO PROCESS_REVERSALS_PVT;
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1348: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1349: /*
1350: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1357: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to reverse promise applications');
1358: END IF;
1359: WHEN OTHERS THEN
1360: ROLLBACK TO PROCESS_REVERSALS_PVT;
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1363: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1364: END IF;
1365: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1428: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1424: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1425: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1426: END IF;
1427: -- Standard call to check for call compatibility
1428: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1425: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1426: END IF;
1427: -- Standard call to check for call compatibility
1428: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: -- Initialize message list if p_init_msg_list is set to TRUE
1433: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1433: IF FND_API.To_Boolean(p_init_msg_list) THEN

1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431:
1432: -- Initialize message list if p_init_msg_list is set to TRUE
1433: IF FND_API.To_Boolean(p_init_msg_list) THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437: -- Initialize API return status to success

Line 1438: l_return_status := FND_API.G_RET_STS_SUCCESS;

1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437: -- Initialize API return status to success
1438: l_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440: -- START OF BODY OF API
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1442: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 1516: P_INIT_MSG_LIST => FND_API.G_TRUE,

1512: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1513: END IF;
1514: APPLY_PROMISES_FIFO(
1515: P_API_VERSION => 1.0,
1516: P_INIT_MSG_LIST => FND_API.G_TRUE,
1517: P_COMMIT => FND_API.G_TRUE,
1518: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1519: X_RETURN_STATUS => l_return_status,
1520: X_MSG_COUNT => l_msg_count,

Line 1517: P_COMMIT => FND_API.G_TRUE,

1513: END IF;
1514: APPLY_PROMISES_FIFO(
1515: P_API_VERSION => 1.0,
1516: P_INIT_MSG_LIST => FND_API.G_TRUE,
1517: P_COMMIT => FND_API.G_TRUE,
1518: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1519: X_RETURN_STATUS => l_return_status,
1520: X_MSG_COUNT => l_msg_count,
1521: X_MSG_DATA => l_msg_data,

Line 1518: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1514: APPLY_PROMISES_FIFO(
1515: P_API_VERSION => 1.0,
1516: P_INIT_MSG_LIST => FND_API.G_TRUE,
1517: P_COMMIT => FND_API.G_TRUE,
1518: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1519: X_RETURN_STATUS => l_return_status,
1520: X_MSG_COUNT => l_msg_count,
1521: X_MSG_DATA => l_msg_data,
1522: P_PROMISES_TBL => l_pro_tbl,

Line 1620: P_INIT_MSG_LIST => FND_API.G_TRUE,

1616: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1617: END IF;
1618: APPLY_PROMISES_FIFO(
1619: P_API_VERSION => 1.0,
1620: P_INIT_MSG_LIST => FND_API.G_TRUE,
1621: P_COMMIT => FND_API.G_TRUE,
1622: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1623: X_RETURN_STATUS => l_return_status,
1624: X_MSG_COUNT => l_msg_count,

Line 1621: P_COMMIT => FND_API.G_TRUE,

1617: END IF;
1618: APPLY_PROMISES_FIFO(
1619: P_API_VERSION => 1.0,
1620: P_INIT_MSG_LIST => FND_API.G_TRUE,
1621: P_COMMIT => FND_API.G_TRUE,
1622: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1623: X_RETURN_STATUS => l_return_status,
1624: X_MSG_COUNT => l_msg_count,
1625: X_MSG_DATA => l_msg_data,

Line 1622: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1618: APPLY_PROMISES_FIFO(
1619: P_API_VERSION => 1.0,
1620: P_INIT_MSG_LIST => FND_API.G_TRUE,
1621: P_COMMIT => FND_API.G_TRUE,
1622: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1623: X_RETURN_STATUS => l_return_status,
1624: X_MSG_COUNT => l_msg_count,
1625: X_MSG_DATA => l_msg_data,
1626: P_PROMISES_TBL => l_pro_tbl,

Line 1698: P_INIT_MSG_LIST => FND_API.G_TRUE,

1694: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1695: END IF;
1696: APPLY_PROMISES_FIFO(
1697: P_API_VERSION => 1.0,
1698: P_INIT_MSG_LIST => FND_API.G_TRUE,
1699: P_COMMIT => FND_API.G_TRUE,
1700: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1701: X_RETURN_STATUS => l_return_status,
1702: X_MSG_COUNT => l_msg_count,

Line 1699: P_COMMIT => FND_API.G_TRUE,

1695: END IF;
1696: APPLY_PROMISES_FIFO(
1697: P_API_VERSION => 1.0,
1698: P_INIT_MSG_LIST => FND_API.G_TRUE,
1699: P_COMMIT => FND_API.G_TRUE,
1700: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1701: X_RETURN_STATUS => l_return_status,
1702: X_MSG_COUNT => l_msg_count,
1703: X_MSG_DATA => l_msg_data,

Line 1700: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1696: APPLY_PROMISES_FIFO(
1697: P_API_VERSION => 1.0,
1698: P_INIT_MSG_LIST => FND_API.G_TRUE,
1699: P_COMMIT => FND_API.G_TRUE,
1700: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1701: X_RETURN_STATUS => l_return_status,
1702: X_MSG_COUNT => l_msg_count,
1703: X_MSG_DATA => l_msg_data,
1704: P_PROMISES_TBL => l_pro_tbl,

Line 1720: IF FND_API.To_Boolean( p_commit ) THEN

1716: END IF;
1717: -- END OF BODY OF API
1718:
1719: -- Standard check of p_commit.
1720: IF FND_API.To_Boolean( p_commit ) THEN
1721: COMMIT WORK;
1722: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1723: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
1724: END IF;

Line 1730: p_encoded => FND_API.G_FALSE,

1726:
1727: x_return_status := l_return_status;
1728: -- Standard call to get message count and if count is 1, get message info
1729: FND_MSG_PUB.Count_And_Get(
1730: p_encoded => FND_API.G_FALSE,
1731: p_count => x_msg_count,
1732: p_data => x_msg_data);
1733:
1734: EXCEPTION

Line 1735: WHEN FND_API.G_EXC_ERROR THEN

1731: p_count => x_msg_count,
1732: p_data => x_msg_data);
1733:
1734: EXCEPTION
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO PROCESS_PROMISES_PVT;
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1739: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1737: x_return_status := FND_API.G_RET_STS_ERROR;

1733:
1734: EXCEPTION
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO PROCESS_PROMISES_PVT;
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1739: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1740: /*
1741: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1746: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1747: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1748: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process promises');
1749: END IF;
1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1751: ROLLBACK TO PROCESS_PROMISES_PVT;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1754: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1748: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process promises');
1749: END IF;
1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1751: ROLLBACK TO PROCESS_PROMISES_PVT;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1754: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1755: /*
1756: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1763: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to process promises');
1764: END IF;
1765: WHEN OTHERS THEN
1766: ROLLBACK TO PROCESS_PROMISES_PVT;
1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1768: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1769: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1770: END IF;
1771: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1840: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1841: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1842: END IF;
1843: -- Standard call to check for call compatibility
1844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1846: END IF;
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1841: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1842: END IF;
1843: -- Standard call to check for call compatibility
1844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1846: END IF;
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE
1849: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1849: IF FND_API.To_Boolean(p_init_msg_list) THEN

1845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1846: END IF;
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE
1849: IF FND_API.To_Boolean(p_init_msg_list) THEN
1850: FND_MSG_PUB.initialize;
1851: END IF;
1852:
1853: -- Initialize API return status to success

Line 1854: l_return_status := FND_API.G_RET_STS_SUCCESS;

1850: FND_MSG_PUB.initialize;
1851: END IF;
1852:
1853: -- Initialize API return status to success
1854: l_return_status := FND_API.G_RET_STS_SUCCESS;
1855:
1856: -- START OF BODY OF API
1857: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1858: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 2472: IF FND_API.To_Boolean( p_commit ) THEN

2468: END IF;
2469: -- END OF BODY OF API
2470:
2471: -- Standard check of p_commit.
2472: IF FND_API.To_Boolean( p_commit ) THEN
2473: COMMIT WORK;
2474: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2475: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
2476: END IF;

Line 2482: p_encoded => FND_API.G_FALSE,

2478:
2479: x_return_status := l_return_status;
2480: -- Standard call to get message count and if count is 1, get message info
2481: FND_MSG_PUB.Count_And_Get(
2482: p_encoded => FND_API.G_FALSE,
2483: p_count => x_msg_count,
2484: p_data => x_msg_data);
2485:
2486: EXCEPTION

Line 2488: WHEN FND_API.G_EXC_ERROR THEN

2484: p_data => x_msg_data);
2485:
2486: EXCEPTION
2487:
2488: WHEN FND_API.G_EXC_ERROR THEN
2489: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2490: x_return_status := FND_API.G_RET_STS_ERROR;
2491: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2492: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2490: x_return_status := FND_API.G_RET_STS_ERROR;

2486: EXCEPTION
2487:
2488: WHEN FND_API.G_EXC_ERROR THEN
2489: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2490: x_return_status := FND_API.G_RET_STS_ERROR;
2491: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2492: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2493: /*
2494: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2499: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2500: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2501: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to do FIFO promise applications');
2502: END IF;
2503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2504: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2507: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2501: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to do FIFO promise applications');
2502: END IF;
2503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2504: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2507: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2508: /*
2509: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2516: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to do FIFO promise applications');
2517: END IF;
2518: WHEN OTHERS THEN
2519: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2522: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2523: END IF;
2524: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2724: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2720: -- Standard Start of API savepoint
2721: SAVEPOINT PROCESS_PROMISE_CALLBACKS_PUB;
2722:
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2721: SAVEPOINT PROCESS_PROMISE_CALLBACKS_PUB;
2722:
2723: -- Standard call to check for call compatibility.
2724: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.
2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END IF;
2727:
2728: -- Initialize message list if p_init_msg_list is set to TRUE.
2729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2730: FND_MSG_PUB.initialize;
2731: END IF;
2732:
2733: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2738: x_return_status := FND_API.G_RET_STS_SUCCESS;

2734: LogMessage( 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2735: END IF;
2736:
2737: -- Initialize API return status to SUCCESS
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739:
2740: -- START OF BODY OF API
2741: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2742: LogMessage( 'Start of ' || l_api_name || ' body');

Line 2842: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2838: x_msg_data => l_msg_data,
2839: x_task_id => l_task_id );
2840:
2841: -- check for errors
2842: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2843: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2844: LogMessage( 'Call JTF_TASKS_PUB.CREATE_TASK failed');
2845: END IF;
2846: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2906: IF FND_API.To_Boolean( p_commit ) THEN

2902: LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2903: END IF;
2904:
2905: -- Standard check of p_commit.
2906: IF FND_API.To_Boolean( p_commit ) THEN
2907: COMMIT WORK;
2908: END IF;
2909:
2910: --Begin bug 7317666 21-Nov-2008 barathsr

Line 2936: IF FND_API.To_Boolean( p_commit ) THEN

2932: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2933: LogMessage( 'Completed Cancelling the callback tasks correpsonding to fulfilled promises...');
2934: END IF;
2935:
2936: IF FND_API.To_Boolean( p_commit ) THEN
2937:
2938: COMMIT WORK;
2939: END IF;
2940: --End bug 7317666 21-Nov-2008 barathsr

Line 2945: p_encoded => FND_API.G_FALSE,

2941:
2942: x_return_status := l_return_status;
2943: -- Standard call to get message count and if count is 1, get message info
2944: FND_MSG_PUB.Count_And_Get(
2945: p_encoded => FND_API.G_FALSE,
2946: p_count => x_msg_count,
2947: p_data => x_msg_data);
2948:
2949: EXCEPTION

Line 2950: WHEN FND_API.G_EXC_ERROR THEN

2946: p_count => x_msg_count,
2947: p_data => x_msg_data);
2948:
2949: EXCEPTION
2950: WHEN FND_API.G_EXC_ERROR THEN
2951: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
2952: x_return_status := FND_API.G_RET_STS_ERROR;
2953: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2954: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2952: x_return_status := FND_API.G_RET_STS_ERROR;

2948:
2949: EXCEPTION
2950: WHEN FND_API.G_EXC_ERROR THEN
2951: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
2952: x_return_status := FND_API.G_RET_STS_ERROR;
2953: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2954: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2955: /*
2956: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2958: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
2959: P_MESSAGE => 'Failed to process promise callbacks');
2960: */
2961: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2966: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2960: */
2961: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
2964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2966: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2967: /*
2968: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2972: */
2973: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2974: WHEN OTHERS THEN
2975: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
2976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2977: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2978: THEN
2979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2980: END IF;

Line 3021: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3017: Type refCur is Ref Cursor;
3018: promises_cur refCur;
3019: l_callback_date DATE;
3020: BEGIN
3021: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3022:
3023: /*
3024: Commented out whole procedure because PROB now can apply payments to promises or
3025: reverse payments from promises automatically.

Line 3036: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3033: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Savepoint is established');
3034: END IF;
3035: -- Standard call to check for call compatibility
3036: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3038: END IF;
3039:
3040: -- Initialize message list if p_init_msg_list is set to TRUE

Line 3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3033: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Savepoint is established');
3034: END IF;
3035: -- Standard call to check for call compatibility
3036: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3038: END IF;
3039:
3040: -- Initialize message list if p_init_msg_list is set to TRUE
3041: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 3041: IF FND_API.To_Boolean(p_init_msg_list) THEN

3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3038: END IF;
3039:
3040: -- Initialize message list if p_init_msg_list is set to TRUE
3041: IF FND_API.To_Boolean(p_init_msg_list) THEN
3042: FND_MSG_PUB.initialize;
3043: END IF;
3044:
3045: -- Initialize API return status to success

Line 3046: l_return_status := FND_API.G_RET_STS_SUCCESS;

3042: FND_MSG_PUB.initialize;
3043: END IF;
3044:
3045: -- Initialize API return status to success
3046: l_return_status := FND_API.G_RET_STS_SUCCESS;
3047:
3048: -- START OF BODY OF API
3049: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3050: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Start of ' || l_api_name || ' body');

Line 3138: IF FND_API.To_Boolean( p_commit ) THEN

3134: END IF;
3135: -- END OF BODY OF API
3136:
3137: -- Standard check of p_commit.
3138: IF FND_API.To_Boolean( p_commit ) THEN
3139: COMMIT WORK;
3140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3141: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Commited');
3142: END IF;

Line 3148: p_encoded => FND_API.G_FALSE,

3144:
3145: x_return_status := l_return_status;
3146: -- Standard call to get message count and if count is 1, get message info
3147: FND_MSG_PUB.Count_And_Get(
3148: p_encoded => FND_API.G_FALSE,
3149: p_count => x_msg_count,
3150: p_data => x_msg_data);
3151:
3152: EXCEPTION

Line 3153: WHEN FND_API.G_EXC_ERROR THEN

3149: p_count => x_msg_count,
3150: p_data => x_msg_data);
3151:
3152: EXCEPTION
3153: WHEN FND_API.G_EXC_ERROR THEN
3154: ROLLBACK TO REOPEN_PROMISES_PVT;
3155: x_return_status := FND_API.G_RET_STS_ERROR;
3156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3157: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3155: x_return_status := FND_API.G_RET_STS_ERROR;

3151:
3152: EXCEPTION
3153: WHEN FND_API.G_EXC_ERROR THEN
3154: ROLLBACK TO REOPEN_PROMISES_PVT;
3155: x_return_status := FND_API.G_RET_STS_ERROR;
3156: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3157: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3158: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3159: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3159: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3160: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',
3161: -- P_MESSAGE => 'Failed to reopen promises.' );
3162: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3164: ROLLBACK TO REOPEN_PROMISES_PVT;
3165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3167: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3161: -- P_MESSAGE => 'Failed to reopen promises.' );
3162: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3164: ROLLBACK TO REOPEN_PROMISES_PVT;
3165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3167: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3168: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3169: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3171: -- P_MESSAGE => 'Failed to reopen promises.' );
3172: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3173: WHEN OTHERS THEN
3174: ROLLBACK TO REOPEN_PROMISES_PVT;
3175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3177: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3178: END IF;
3179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);