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 IEX_DEBUG_PUB

Line 29: iex_debug_pub.LogMessage(p_msg);

25: fnd_file.put_line(FND_FILE.LOG, p_msg);
26: end if;
27: */
28: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
29: iex_debug_pub.LogMessage(p_msg);
30: END IF;
31: END;
32:
33: /**********************

Line 157: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: this procedure has been obsoleted - no actions have beed done.');

153: ORDER BY PRD.PROMISE_DETAIL_ID;
154:
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: /*

Line 359: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: this procedure has been obsoleted - no actions have beed done.');

355:
356: BEGIN
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: /*

Line 370: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: start');

366: We do not need to close or reopen promises if delinquency is closed or reopened - all this will be done by PROB.
367: We are obsoleting status CLOSED.
368:
369: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
370: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: start');
371: END IF;
372: -- Standard start of API savepoint
373: SAVEPOINT CLOSE_PROMISES_PVT;
374:

Line 376: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: Savepoint is established');

372: -- Standard start of API savepoint
373: SAVEPOINT CLOSE_PROMISES_PVT;
374:
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;

Line 393: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: Start of body');

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');
394: END IF;
395:
396: -- run thru table of payments and close promises
397: l_del_count := P_DELINQ_TBL.count;

Line 399: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: count of passed table of delinquencies = ' || l_del_count);

395:
396: -- run thru table of payments and close promises
397: l_del_count := P_DELINQ_TBL.count;
398: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
399: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: count of passed table of delinquencies = ' || l_del_count);
400: END IF;
401:
402: vSQL := 'SELECT ' ||
403: 'PROMISE_DETAIL_ID, status, ''Invoice'' ' ||

Line 428: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: processing promises...');

424: 'PRD.STATUS IN (''OPEN'', ''PENDING'', ''BROKEN'') ' ||
425: 'ORDER BY PROMISE_DETAIL_ID';
426:
427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
428: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: processing promises...');
429: END IF;
430: FOR i in 1..l_del_count LOOP
431: open del_cur for vSQL
432: using p_delinq_tbl(i), p_delinq_tbl(i);

Line 434: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: record #' || i);

430: FOR i in 1..l_del_count LOOP
431: open del_cur for vSQL
432: using p_delinq_tbl(i), p_delinq_tbl(i);
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: record #' || i);
435: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: delinquency: ' || p_delinq_tbl(i));
436: END IF;
437:
438: LOOP

Line 435: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: delinquency: ' || p_delinq_tbl(i));

431: open del_cur for vSQL
432: using p_delinq_tbl(i), p_delinq_tbl(i);
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: record #' || i);
435: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: delinquency: ' || p_delinq_tbl(i));
436: END IF;
437:
438: LOOP
439: fetch del_cur into l_promise_id, l_status, l_type;

Line 443: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: found promise with id: ' || l_promise_id);

439: fetch del_cur into l_promise_id, l_status, l_type;
440: exit when del_cur%NOTFOUND;
441:
442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
443: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: found promise with id: ' || l_promise_id);
444: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise status: ' || l_status);
445: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise type: ' || l_type);
446: END IF;
447:

Line 444: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise status: ' || l_status);

440: exit when del_cur%NOTFOUND;
441:
442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
443: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: found promise with id: ' || l_promise_id);
444: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise status: ' || l_status);
445: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise type: ' || l_type);
446: END IF;
447:
448: if l_status = 'BROKEN' then

Line 445: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise type: ' || l_type);

441:
442: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
443: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: found promise with id: ' || l_promise_id);
444: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise status: ' || l_status);
445: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: promise type: ' || l_type);
446: END IF;
447:
448: if l_status = 'BROKEN' then
449: k := k + 1;

Line 452: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: added to broken promise table');

448: if l_status = 'BROKEN' then
449: k := k + 1;
450: l_broken_promise_ids_tbl(k) := l_promise_id;
451: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
452: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: added to broken promise table');
453: END IF;
454: else
455: j := j + 1;
456: l_promise_ids_tbl(j) := l_promise_id;

Line 458: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: added to open/pending promise table');

454: else
455: j := j + 1;
456: l_promise_ids_tbl(j) := l_promise_id;
457: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
458: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: added to open/pending promise table');
459: END IF;
460: end if;
461: END LOOP;
462: END LOOP;

Line 467: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating open/pending promises...');

463:
464: l_cl_prd_count := l_promise_ids_tbl.count;
465: if l_cl_prd_count > 0 then
466: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
467: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating open/pending promises...');
468: END IF;
469: FORALL n in 1..l_cl_prd_count
470: UPDATE iex_promise_details
471: SET STATUS = 'CLOSED',

Line 480: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating broken promises...');

476:
477: l_cl_prd_count := l_broken_promise_ids_tbl.count;
478: if l_cl_prd_count > 0 then
479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
480: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: updating broken promises...');
481: END IF;
482: FORALL n in 1..l_cl_prd_count
483: UPDATE iex_promise_details
484: SET UWQ_STATUS = 'COMPLETE',

Line 492: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: End of body');

488: WHERE promise_detail_id = l_broken_promise_ids_tbl(n);
489: end if;
490:
491: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
492: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: End of body');
493: END IF;
494: -- END OF BODY OF API
495:
496: -- Standard check of p_commit.

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 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 537: iex_debug_pub.LogMessage(G_PKG_NAME || '.CLOSE_PROMISES: in OTHERS execption');

533: -- P_MESSAGE => 'Failed to close promises.' );
534: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
535: WHEN OTHERS THEN
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

Line 1416: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_PROMISES_PUB.update_del_stage_level');

1412:
1413: /*
1414: --start
1415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1416: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling IEX_PROMISES_PUB.update_del_stage_level');
1417: END IF;
1418: IEX_PROMISES_PUB.update_del_stage_level (
1419: p_promise_id => l_appl_tbl(i).promise_detail_id,
1420: X_RETURN_STATUS => l_return_status,

Line 1425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_PROMISES_PUB.update_del_stage_level');

1421: X_MSG_COUNT => l_msg_count,
1422: X_MSG_DATA => l_msg_data);
1423:
1424: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_PROMISES_PUB.update_del_stage_level');
1426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1427: END IF;
1428:
1429: -- check for errors

Line 1426: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);

1422: X_MSG_DATA => l_msg_data);
1423:
1424: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1425: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to IEX_PROMISES_PUB.update_del_stage_level');
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

Line 1432: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_PROMISES_PUB.update_del_stage_level failed');

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;
1435: END IF;
1436: --end