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 782: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

778: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
779: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
780: END IF;
781: -- Standard call to check for call compatibility
782: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786: -- Initialize message list if p_init_msg_list is set to TRUE

Line 783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

779: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
780: END IF;
781: -- Standard call to check for call compatibility
782: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786: -- Initialize message list if p_init_msg_list is set to TRUE
787: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 787: IF FND_API.To_Boolean(p_init_msg_list) THEN

783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: END IF;
785:
786: -- Initialize message list if p_init_msg_list is set to TRUE
787: IF FND_API.To_Boolean(p_init_msg_list) THEN
788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: -- Initialize API return status to success

Line 792: l_return_status := FND_API.G_RET_STS_SUCCESS;

788: FND_MSG_PUB.initialize;
789: END IF;
790:
791: -- Initialize API return status to success
792: l_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: -- START OF BODY OF API
795: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
796: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 805: P_INIT_MSG_LIST => FND_API.G_TRUE,

801: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling PROCESS_REVERSALS for AR ');
802: END IF;
803: PROCESS_REVERSALS(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_TRUE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: X_RETURN_STATUS => l_return_status,
809: X_MSG_COUNT => l_msg_count,

Line 806: P_COMMIT => FND_API.G_TRUE,

802: END IF;
803: PROCESS_REVERSALS(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_TRUE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: X_RETURN_STATUS => l_return_status,
809: X_MSG_COUNT => l_msg_count,
810: X_MSG_DATA => l_msg_data,

Line 807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

803: PROCESS_REVERSALS(
804: P_API_VERSION => 1.0,
805: P_INIT_MSG_LIST => FND_API.G_TRUE,
806: P_COMMIT => FND_API.G_TRUE,
807: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
808: X_RETURN_STATUS => l_return_status,
809: X_MSG_COUNT => l_msg_count,
810: X_MSG_DATA => l_msg_data,
811: P_TYPE => 'AR');

Line 819: P_INIT_MSG_LIST => FND_API.G_TRUE,

815: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Calling PROCESS_REVERSALS for OKL ');
816: END IF;
817: PROCESS_REVERSALS(
818: P_API_VERSION => 1.0,
819: P_INIT_MSG_LIST => FND_API.G_TRUE,
820: P_COMMIT => FND_API.G_TRUE,
821: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
822: X_RETURN_STATUS => l_return_status,
823: X_MSG_COUNT => l_msg_count,

Line 820: P_COMMIT => FND_API.G_TRUE,

816: END IF;
817: PROCESS_REVERSALS(
818: P_API_VERSION => 1.0,
819: P_INIT_MSG_LIST => FND_API.G_TRUE,
820: P_COMMIT => FND_API.G_TRUE,
821: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
822: X_RETURN_STATUS => l_return_status,
823: X_MSG_COUNT => l_msg_count,
824: X_MSG_DATA => l_msg_data,

Line 821: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

817: PROCESS_REVERSALS(
818: P_API_VERSION => 1.0,
819: P_INIT_MSG_LIST => FND_API.G_TRUE,
820: P_COMMIT => FND_API.G_TRUE,
821: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
822: X_RETURN_STATUS => l_return_status,
823: X_MSG_COUNT => l_msg_count,
824: X_MSG_DATA => l_msg_data,
825: P_TYPE => 'OKL');

Line 833: P_INIT_MSG_LIST => FND_API.G_TRUE,

829: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on AR invoices...');
830: END IF;
831: PROCESS_PROMISES(
832: P_API_VERSION => 1.0,
833: P_INIT_MSG_LIST => FND_API.G_TRUE,
834: P_COMMIT => FND_API.G_TRUE,
835: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
836: X_RETURN_STATUS => l_return_status,
837: X_MSG_COUNT => l_msg_count,

Line 834: P_COMMIT => FND_API.G_TRUE,

830: END IF;
831: PROCESS_PROMISES(
832: P_API_VERSION => 1.0,
833: P_INIT_MSG_LIST => FND_API.G_TRUE,
834: P_COMMIT => FND_API.G_TRUE,
835: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
836: X_RETURN_STATUS => l_return_status,
837: X_MSG_COUNT => l_msg_count,
838: X_MSG_DATA => l_msg_data,

Line 835: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

831: PROCESS_PROMISES(
832: P_API_VERSION => 1.0,
833: P_INIT_MSG_LIST => FND_API.G_TRUE,
834: P_COMMIT => FND_API.G_TRUE,
835: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
836: X_RETURN_STATUS => l_return_status,
837: X_MSG_COUNT => l_msg_count,
838: X_MSG_DATA => l_msg_data,
839: P_TYPE => 'INV');

Line 847: P_INIT_MSG_LIST => FND_API.G_TRUE,

843: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on AR account...');
844: END IF;
845: PROCESS_PROMISES(
846: P_API_VERSION => 1.0,
847: P_INIT_MSG_LIST => FND_API.G_TRUE,
848: P_COMMIT => FND_API.G_TRUE,
849: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
850: X_RETURN_STATUS => l_return_status,
851: X_MSG_COUNT => l_msg_count,

Line 848: P_COMMIT => FND_API.G_TRUE,

844: END IF;
845: PROCESS_PROMISES(
846: P_API_VERSION => 1.0,
847: P_INIT_MSG_LIST => FND_API.G_TRUE,
848: P_COMMIT => FND_API.G_TRUE,
849: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
850: X_RETURN_STATUS => l_return_status,
851: X_MSG_COUNT => l_msg_count,
852: X_MSG_DATA => l_msg_data,

Line 849: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

845: PROCESS_PROMISES(
846: P_API_VERSION => 1.0,
847: P_INIT_MSG_LIST => FND_API.G_TRUE,
848: P_COMMIT => FND_API.G_TRUE,
849: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
850: X_RETURN_STATUS => l_return_status,
851: X_MSG_COUNT => l_msg_count,
852: X_MSG_DATA => l_msg_data,
853: P_TYPE => 'ACC');

Line 861: P_INIT_MSG_LIST => FND_API.G_TRUE,

857: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Processing promises on OKL contracts...');
858: END IF;
859: PROCESS_PROMISES(
860: P_API_VERSION => 1.0,
861: P_INIT_MSG_LIST => FND_API.G_TRUE,
862: P_COMMIT => FND_API.G_TRUE,
863: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
864: X_RETURN_STATUS => l_return_status,
865: X_MSG_COUNT => l_msg_count,

Line 862: P_COMMIT => FND_API.G_TRUE,

858: END IF;
859: PROCESS_PROMISES(
860: P_API_VERSION => 1.0,
861: P_INIT_MSG_LIST => FND_API.G_TRUE,
862: P_COMMIT => FND_API.G_TRUE,
863: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
864: X_RETURN_STATUS => l_return_status,
865: X_MSG_COUNT => l_msg_count,
866: X_MSG_DATA => l_msg_data,

Line 863: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

859: PROCESS_PROMISES(
860: P_API_VERSION => 1.0,
861: P_INIT_MSG_LIST => FND_API.G_TRUE,
862: P_COMMIT => FND_API.G_TRUE,
863: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
864: X_RETURN_STATUS => l_return_status,
865: X_MSG_COUNT => l_msg_count,
866: X_MSG_DATA => l_msg_data,
867: P_TYPE => 'CNTR');

Line 875: IF FND_API.To_Boolean( p_commit ) THEN

871: END IF;
872: -- END OF BODY OF API
873:
874: -- Standard check of p_commit.
875: IF FND_API.To_Boolean( p_commit ) THEN
876: COMMIT WORK;
877: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
878: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
879: END IF;

Line 885: p_encoded => FND_API.G_FALSE,

881:
882: x_return_status := l_return_status;
883: -- Standard call to get message count and if count is 1, get message info
884: FND_MSG_PUB.Count_And_Get(
885: p_encoded => FND_API.G_FALSE,
886: p_count => x_msg_count,
887: p_data => x_msg_data);
888:
889: -- Start bug#5874874 gnramasa 25-Apr-07

Line 1053: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1049: LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || l_return_status);
1050: END IF;
1051:
1052: -- check for errors
1053: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1054: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1055: LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_PROMISES_PUB.update_del_stage_level failed');
1056: END IF;
1057: RAISE FND_API.G_EXC_ERROR;

Line 1057: RAISE FND_API.G_EXC_ERROR;

1053: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1054: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1055: LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_PROMISES_PUB.update_del_stage_level failed');
1056: END IF;
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059:
1060: END LOOP;
1061:

Line 1076: WHEN FND_API.G_EXC_ERROR THEN

1072: END;
1073: --end
1074:
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1080: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074:
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1080: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1081: /*
1082: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1087: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1088: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1089: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process all promises');
1090: END IF;
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1095: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1089: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process all promises');
1090: END IF;
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1095: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1096: /*
1097: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1104: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to process all promises');
1105: END IF;
1106: WHEN OTHERS THEN
1107: ROLLBACK TO PROCESS_ALL_PROMISES_PVT;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1110: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1111: END IF;
1112: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1172: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1173: END IF;
1174: -- Standard call to check for call compatibility
1175: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1173: END IF;
1174: -- Standard call to check for call compatibility
1175: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE
1180: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1180: IF FND_API.To_Boolean(p_init_msg_list) THEN

1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE
1180: IF FND_API.To_Boolean(p_init_msg_list) THEN
1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Initialize API return status to success

Line 1185: l_return_status := FND_API.G_RET_STS_SUCCESS;

1181: FND_MSG_PUB.initialize;
1182: END IF;
1183:
1184: -- Initialize API return status to success
1185: l_return_status := FND_API.G_RET_STS_SUCCESS;
1186:
1187: -- START OF BODY OF API
1188: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1189: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 1430: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1427: END IF;
1428:
1429: -- check for errors
1430: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1432: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_PROMISES_PUB.update_del_stage_level failed');
1433: END IF;
1434: RAISE FND_API.G_EXC_ERROR;

Line 1434: RAISE FND_API.G_EXC_ERROR;

1430: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1432: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_PROMISES_PUB.update_del_stage_level failed');
1433: END IF;
1434: RAISE FND_API.G_EXC_ERROR;
1435: END IF;
1436: --end
1437: */
1438: end if;

Line 1453: IF FND_API.To_Boolean( p_commit ) THEN

1449: END IF;
1450: -- END OF BODY OF API
1451:
1452: -- Standard check of p_commit.
1453: IF FND_API.To_Boolean( p_commit ) THEN
1454: COMMIT WORK;
1455: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1456: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
1457: END IF;

Line 1463: p_encoded => FND_API.G_FALSE,

1459:
1460: x_return_status := l_return_status;
1461: -- Standard call to get message count and if count is 1, get message info
1462: FND_MSG_PUB.Count_And_Get(
1463: p_encoded => FND_API.G_FALSE,
1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:
1467: EXCEPTION

Line 1469: WHEN FND_API.G_EXC_ERROR THEN

1465: p_data => x_msg_data);
1466:
1467: EXCEPTION
1468:
1469: WHEN FND_API.G_EXC_ERROR THEN
1470: ROLLBACK TO PROCESS_REVERSALS_PVT;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1473: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: EXCEPTION
1468:
1469: WHEN FND_API.G_EXC_ERROR THEN
1470: ROLLBACK TO PROCESS_REVERSALS_PVT;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1473: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1474: /*
1475: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1480: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1481: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1482: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to reverse promise applications');
1483: END IF;
1484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1485: ROLLBACK TO PROCESS_REVERSALS_PVT;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1488: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1482: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to reverse promise applications');
1483: END IF;
1484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1485: ROLLBACK TO PROCESS_REVERSALS_PVT;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1488: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1489: /*
1490: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1497: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to reverse promise applications');
1498: END IF;
1499: WHEN OTHERS THEN
1500: ROLLBACK TO PROCESS_REVERSALS_PVT;
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1503: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1504: END IF;
1505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1564: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1565: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1566: END IF;
1567: -- Standard call to check for call compatibility
1568: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: END IF;
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1566: END IF;
1567: -- Standard call to check for call compatibility
1568: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: END IF;
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE
1573: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1573: IF FND_API.To_Boolean(p_init_msg_list) THEN

1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: END IF;
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE
1573: IF FND_API.To_Boolean(p_init_msg_list) THEN
1574: FND_MSG_PUB.initialize;
1575: END IF;
1576:
1577: -- Initialize API return status to success

Line 1578: l_return_status := FND_API.G_RET_STS_SUCCESS;

1574: FND_MSG_PUB.initialize;
1575: END IF;
1576:
1577: -- Initialize API return status to success
1578: l_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: -- START OF BODY OF API
1581: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1582: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 1656: P_INIT_MSG_LIST => FND_API.G_TRUE,

1652: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1653: END IF;
1654: APPLY_PROMISES_FIFO(
1655: P_API_VERSION => 1.0,
1656: P_INIT_MSG_LIST => FND_API.G_TRUE,
1657: P_COMMIT => FND_API.G_TRUE,
1658: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1659: X_RETURN_STATUS => l_return_status,
1660: X_MSG_COUNT => l_msg_count,

Line 1657: P_COMMIT => FND_API.G_TRUE,

1653: END IF;
1654: APPLY_PROMISES_FIFO(
1655: P_API_VERSION => 1.0,
1656: P_INIT_MSG_LIST => FND_API.G_TRUE,
1657: P_COMMIT => FND_API.G_TRUE,
1658: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1659: X_RETURN_STATUS => l_return_status,
1660: X_MSG_COUNT => l_msg_count,
1661: X_MSG_DATA => l_msg_data,

Line 1658: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1654: APPLY_PROMISES_FIFO(
1655: P_API_VERSION => 1.0,
1656: P_INIT_MSG_LIST => FND_API.G_TRUE,
1657: P_COMMIT => FND_API.G_TRUE,
1658: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1659: X_RETURN_STATUS => l_return_status,
1660: X_MSG_COUNT => l_msg_count,
1661: X_MSG_DATA => l_msg_data,
1662: P_PROMISES_TBL => l_pro_tbl,

Line 1760: P_INIT_MSG_LIST => FND_API.G_TRUE,

1756: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1757: END IF;
1758: APPLY_PROMISES_FIFO(
1759: P_API_VERSION => 1.0,
1760: P_INIT_MSG_LIST => FND_API.G_TRUE,
1761: P_COMMIT => FND_API.G_TRUE,
1762: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1763: X_RETURN_STATUS => l_return_status,
1764: X_MSG_COUNT => l_msg_count,

Line 1761: P_COMMIT => FND_API.G_TRUE,

1757: END IF;
1758: APPLY_PROMISES_FIFO(
1759: P_API_VERSION => 1.0,
1760: P_INIT_MSG_LIST => FND_API.G_TRUE,
1761: P_COMMIT => FND_API.G_TRUE,
1762: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1763: X_RETURN_STATUS => l_return_status,
1764: X_MSG_COUNT => l_msg_count,
1765: X_MSG_DATA => l_msg_data,

Line 1762: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1758: APPLY_PROMISES_FIFO(
1759: P_API_VERSION => 1.0,
1760: P_INIT_MSG_LIST => FND_API.G_TRUE,
1761: P_COMMIT => FND_API.G_TRUE,
1762: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1763: X_RETURN_STATUS => l_return_status,
1764: X_MSG_COUNT => l_msg_count,
1765: X_MSG_DATA => l_msg_data,
1766: P_PROMISES_TBL => l_pro_tbl,

Line 1838: P_INIT_MSG_LIST => FND_API.G_TRUE,

1834: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Doing FIFO promise applications...');
1835: END IF;
1836: APPLY_PROMISES_FIFO(
1837: P_API_VERSION => 1.0,
1838: P_INIT_MSG_LIST => FND_API.G_TRUE,
1839: P_COMMIT => FND_API.G_TRUE,
1840: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1841: X_RETURN_STATUS => l_return_status,
1842: X_MSG_COUNT => l_msg_count,

Line 1839: P_COMMIT => FND_API.G_TRUE,

1835: END IF;
1836: APPLY_PROMISES_FIFO(
1837: P_API_VERSION => 1.0,
1838: P_INIT_MSG_LIST => FND_API.G_TRUE,
1839: P_COMMIT => FND_API.G_TRUE,
1840: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1841: X_RETURN_STATUS => l_return_status,
1842: X_MSG_COUNT => l_msg_count,
1843: X_MSG_DATA => l_msg_data,

Line 1840: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1836: APPLY_PROMISES_FIFO(
1837: P_API_VERSION => 1.0,
1838: P_INIT_MSG_LIST => FND_API.G_TRUE,
1839: P_COMMIT => FND_API.G_TRUE,
1840: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1841: X_RETURN_STATUS => l_return_status,
1842: X_MSG_COUNT => l_msg_count,
1843: X_MSG_DATA => l_msg_data,
1844: P_PROMISES_TBL => l_pro_tbl,

Line 1860: IF FND_API.To_Boolean( p_commit ) THEN

1856: END IF;
1857: -- END OF BODY OF API
1858:
1859: -- Standard check of p_commit.
1860: IF FND_API.To_Boolean( p_commit ) THEN
1861: COMMIT WORK;
1862: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1863: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
1864: END IF;

Line 1870: p_encoded => FND_API.G_FALSE,

1866:
1867: x_return_status := l_return_status;
1868: -- Standard call to get message count and if count is 1, get message info
1869: FND_MSG_PUB.Count_And_Get(
1870: p_encoded => FND_API.G_FALSE,
1871: p_count => x_msg_count,
1872: p_data => x_msg_data);
1873:
1874: EXCEPTION

Line 1875: WHEN FND_API.G_EXC_ERROR THEN

1871: p_count => x_msg_count,
1872: p_data => x_msg_data);
1873:
1874: EXCEPTION
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: ROLLBACK TO PROCESS_PROMISES_PVT;
1877: x_return_status := FND_API.G_RET_STS_ERROR;
1878: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1879: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1877: x_return_status := FND_API.G_RET_STS_ERROR;

1873:
1874: EXCEPTION
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: ROLLBACK TO PROCESS_PROMISES_PVT;
1877: x_return_status := FND_API.G_RET_STS_ERROR;
1878: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1879: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1880: /*
1881: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1886: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1887: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1888: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process promises');
1889: END IF;
1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1891: ROLLBACK TO PROCESS_PROMISES_PVT;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1894: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1888: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to process promises');
1889: END IF;
1890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1891: ROLLBACK TO PROCESS_PROMISES_PVT;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1894: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
1895: /*
1896: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1903: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to process promises');
1904: END IF;
1905: WHEN OTHERS THEN
1906: ROLLBACK TO PROCESS_PROMISES_PVT;
1907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1908: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1909: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1910: END IF;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

1980: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1981: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1982: END IF;
1983: -- Standard call to check for call compatibility
1984: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: END IF;
1987:
1988: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1981: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Savepoint is established');
1982: END IF;
1983: -- Standard call to check for call compatibility
1984: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: END IF;
1987:
1988: -- Initialize message list if p_init_msg_list is set to TRUE
1989: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1989: IF FND_API.To_Boolean(p_init_msg_list) THEN

1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: END IF;
1987:
1988: -- Initialize message list if p_init_msg_list is set to TRUE
1989: IF FND_API.To_Boolean(p_init_msg_list) THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993: -- Initialize API return status to success

Line 1994: l_return_status := FND_API.G_RET_STS_SUCCESS;

1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993: -- Initialize API return status to success
1994: l_return_status := FND_API.G_RET_STS_SUCCESS;
1995:
1996: -- START OF BODY OF API
1997: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1998: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Start of body');

Line 2612: IF FND_API.To_Boolean( p_commit ) THEN

2608: END IF;
2609: -- END OF BODY OF API
2610:
2611: -- Standard check of p_commit.
2612: IF FND_API.To_Boolean( p_commit ) THEN
2613: COMMIT WORK;
2614: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2615: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Commited work');
2616: END IF;

Line 2622: p_encoded => FND_API.G_FALSE,

2618:
2619: x_return_status := l_return_status;
2620: -- Standard call to get message count and if count is 1, get message info
2621: FND_MSG_PUB.Count_And_Get(
2622: p_encoded => FND_API.G_FALSE,
2623: p_count => x_msg_count,
2624: p_data => x_msg_data);
2625:
2626: EXCEPTION

Line 2628: WHEN FND_API.G_EXC_ERROR THEN

2624: p_data => x_msg_data);
2625:
2626: EXCEPTION
2627:
2628: WHEN FND_API.G_EXC_ERROR THEN
2629: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2632: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2630: x_return_status := FND_API.G_RET_STS_ERROR;

2626: EXCEPTION
2627:
2628: WHEN FND_API.G_EXC_ERROR THEN
2629: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2632: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2633: /*
2634: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2639: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
2640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2641: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to do FIFO promise applications');
2642: END IF;
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2647: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2641: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_ERROR exception. Failed to do FIFO promise applications');
2642: END IF;
2643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2644: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2647: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
2648: /*
2649: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 2660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2656: LogMessage(G_PKG_NAME || '.' || l_api_name || ': In G_EXC_UNEXPECTED_ERROR exception. Failed to do FIFO promise applications');
2657: END IF;
2658: WHEN OTHERS THEN
2659: ROLLBACK TO APPLY_PROMISES_FIFO_PVT;
2660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2662: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2663: END IF;
2664: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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

2870: -- Standard Start of API savepoint
2871: SAVEPOINT PROCESS_PROMISE_CALLBACKS_PUB;
2872:
2873: -- Standard call to check for call compatibility.
2874: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2876: END IF;
2877:
2878: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2871: SAVEPOINT PROCESS_PROMISE_CALLBACKS_PUB;
2872:
2873: -- Standard call to check for call compatibility.
2874: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2876: END IF;
2877:
2878: -- Initialize message list if p_init_msg_list is set to TRUE.
2879: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2879: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2876: END IF;
2877:
2878: -- Initialize message list if p_init_msg_list is set to TRUE.
2879: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2880: FND_MSG_PUB.initialize;
2881: END IF;
2882:
2883: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2888: x_return_status := FND_API.G_RET_STS_SUCCESS;

2884: LogMessage( 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2885: END IF;
2886:
2887: -- Initialize API return status to SUCCESS
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889:
2890: -- START OF BODY OF API
2891: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2892: LogMessage( 'Start of ' || l_api_name || ' body');

Line 3016: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

3012: x_msg_data => l_msg_data,
3013: x_task_id => l_task_id );
3014:
3015: -- check for errors
3016: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
3017: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3018: LogMessage( 'Call JTF_TASKS_PUB.CREATE_TASK failed');
3019: LogMessage(' JTF_TASKS_PUB,CREATE_TASK failed l_msg_count '|| l_msg_count);
3020: LogMessage(' JTF_TASKS_PUB.CREATE_TASK failed reason l_msg_data '|| l_msg_data);

Line 3083: IF FND_API.To_Boolean( p_commit ) THEN

3079: LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3080: END IF;
3081:
3082: -- Standard check of p_commit.
3083: IF FND_API.To_Boolean( p_commit ) THEN
3084: COMMIT WORK;
3085: END IF;
3086:
3087: --Begin bug 7317666 21-Nov-2008 barathsr

Line 3113: IF FND_API.To_Boolean( p_commit ) THEN

3109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3110: LogMessage( 'Completed Cancelling the callback tasks correpsonding to fulfilled promises...');
3111: END IF;
3112:
3113: IF FND_API.To_Boolean( p_commit ) THEN
3114:
3115: COMMIT WORK;
3116: END IF;
3117: --End bug 7317666 21-Nov-2008 barathsr

Line 3122: p_encoded => FND_API.G_FALSE,

3118:
3119: x_return_status := l_return_status;
3120: -- Standard call to get message count and if count is 1, get message info
3121: FND_MSG_PUB.Count_And_Get(
3122: p_encoded => FND_API.G_FALSE,
3123: p_count => x_msg_count,
3124: p_data => x_msg_data);
3125:
3126: EXCEPTION

Line 3127: WHEN FND_API.G_EXC_ERROR THEN

3123: p_count => x_msg_count,
3124: p_data => x_msg_data);
3125:
3126: EXCEPTION
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3131: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3129: x_return_status := FND_API.G_RET_STS_ERROR;

3125:
3126: EXCEPTION
3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3131: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3132: /*
3133: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 3139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3135: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
3136: P_MESSAGE => 'Failed to process promise callbacks');
3137: */
3138: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3140: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
3141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3143: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3137: */
3138: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3140: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
3141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3143: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3144: /*
3145: IEX_CONC_REQUEST_MSG_PKG.Log_Error(

Line 3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3149: */
3150: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3151: WHEN OTHERS THEN
3152: ROLLBACK TO PROCESS_PROMISE_CALLBACKS_PUB;
3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3155: THEN
3156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3157: END IF;

Line 3198: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

3194: Type refCur is Ref Cursor;
3195: promises_cur refCur;
3196: l_callback_date DATE;
3197: BEGIN
3198: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
3199:
3200: /*
3201: Commented out whole procedure because PROB now can apply payments to promises or
3202: reverse payments from promises automatically.

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

3209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3210: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Savepoint is established');
3211: END IF;
3212: -- Standard call to check for call compatibility
3213: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: END IF;
3216:
3217: -- Initialize message list if p_init_msg_list is set to TRUE

Line 3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3210: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Savepoint is established');
3211: END IF;
3212: -- Standard call to check for call compatibility
3213: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: END IF;
3216:
3217: -- Initialize message list if p_init_msg_list is set to TRUE
3218: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 3218: IF FND_API.To_Boolean(p_init_msg_list) THEN

3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: END IF;
3216:
3217: -- Initialize message list if p_init_msg_list is set to TRUE
3218: IF FND_API.To_Boolean(p_init_msg_list) THEN
3219: FND_MSG_PUB.initialize;
3220: END IF;
3221:
3222: -- Initialize API return status to success

Line 3223: l_return_status := FND_API.G_RET_STS_SUCCESS;

3219: FND_MSG_PUB.initialize;
3220: END IF;
3221:
3222: -- Initialize API return status to success
3223: l_return_status := FND_API.G_RET_STS_SUCCESS;
3224:
3225: -- START OF BODY OF API
3226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3227: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Start of ' || l_api_name || ' body');

Line 3315: IF FND_API.To_Boolean( p_commit ) THEN

3311: END IF;
3312: -- END OF BODY OF API
3313:
3314: -- Standard check of p_commit.
3315: IF FND_API.To_Boolean( p_commit ) THEN
3316: COMMIT WORK;
3317: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3318: LogMessage(G_PKG_NAME || '.REOPEN_PROMISES: Commited');
3319: END IF;

Line 3325: p_encoded => FND_API.G_FALSE,

3321:
3322: x_return_status := l_return_status;
3323: -- Standard call to get message count and if count is 1, get message info
3324: FND_MSG_PUB.Count_And_Get(
3325: p_encoded => FND_API.G_FALSE,
3326: p_count => x_msg_count,
3327: p_data => x_msg_data);
3328:
3329: EXCEPTION

Line 3330: WHEN FND_API.G_EXC_ERROR THEN

3326: p_count => x_msg_count,
3327: p_data => x_msg_data);
3328:
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_ERROR THEN
3331: ROLLBACK TO REOPEN_PROMISES_PVT;
3332: x_return_status := FND_API.G_RET_STS_ERROR;
3333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3334: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3332: x_return_status := FND_API.G_RET_STS_ERROR;

3328:
3329: EXCEPTION
3330: WHEN FND_API.G_EXC_ERROR THEN
3331: ROLLBACK TO REOPEN_PROMISES_PVT;
3332: x_return_status := FND_API.G_RET_STS_ERROR;
3333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3334: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3335: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3336: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 3340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3336: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
3337: -- P_Procedure_name => 'IEX_PROMISES_BATCH_PUB.REOPEN_PROMISES',
3338: -- P_MESSAGE => 'Failed to reopen promises.' );
3339: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3341: ROLLBACK TO REOPEN_PROMISES_PVT;
3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3344: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging

Line 3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3338: -- P_MESSAGE => 'Failed to reopen promises.' );
3339: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3341: ROLLBACK TO REOPEN_PROMISES_PVT;
3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3344: -- Begin - Andre Araujo - 09/30/2004- Remove obsolete logging
3345: --IEX_CONC_REQUEST_MSG_PKG.Log_Error(
3346: -- P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,

Line 3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3348: -- P_MESSAGE => 'Failed to reopen promises.' );
3349: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
3350: WHEN OTHERS THEN
3351: ROLLBACK TO REOPEN_PROMISES_PVT;
3352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3354: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3355: END IF;
3356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);