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.BIL_BI_TREND_MGMT_RPTS_PKG dependencies on FND_MESSAGE

Line 495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

491: EXCEPTION
492: WHEN OTHERS THEN
493:
494: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
496: fnd_message.set_token('ERROR' ,SQLCODE);
497: fnd_message.set_token('REASON', SQLERRM);
498:
499: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 496: fnd_message.set_token('ERROR' ,SQLCODE);

492: WHEN OTHERS THEN
493:
494: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
496: fnd_message.set_token('ERROR' ,SQLCODE);
497: fnd_message.set_token('REASON', SQLERRM);
498:
499: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
500: MODULE => g_pkg || l_proc || 'proc_error',

Line 497: fnd_message.set_token('REASON', SQLERRM);

493:
494: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
495: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
496: fnd_message.set_token('ERROR' ,SQLCODE);
497: fnd_message.set_token('REASON', SQLERRM);
498:
499: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
500: MODULE => g_pkg || l_proc || 'proc_error',
501: MESSAGE => fnd_message.get );

Line 501: MESSAGE => fnd_message.get );

497: fnd_message.set_token('REASON', SQLERRM);
498:
499: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
500: MODULE => g_pkg || l_proc || 'proc_error',
501: MESSAGE => fnd_message.get );
502:
503: END IF;
504:
505:

Line 662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

658: WHEN OTHERS THEN
659:
660: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661:
662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
663: fnd_message.set_token('ERROR' ,SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665:
666: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 663: fnd_message.set_token('ERROR' ,SQLCODE);

659:
660: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661:
662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
663: fnd_message.set_token('ERROR' ,SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665:
666: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
667: MODULE => g_pkg || l_proc || 'proc_error',

Line 664: fnd_message.set_token('REASON', SQLERRM);

660: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
661:
662: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
663: fnd_message.set_token('ERROR' ,SQLCODE);
664: fnd_message.set_token('REASON', SQLERRM);
665:
666: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
667: MODULE => g_pkg || l_proc || 'proc_error',
668: MESSAGE => fnd_message.get );

Line 668: MESSAGE => fnd_message.get );

664: fnd_message.set_token('REASON', SQLERRM);
665:
666: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
667: MODULE => g_pkg || l_proc || 'proc_error',
668: MESSAGE => fnd_message.get );
669:
670: END IF;
671:
672:

Line 693: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

689: EXCEPTION
690: WHEN OTHERS THEN
691: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
692:
693: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
694: fnd_message.set_token('ERROR' ,SQLCODE);
695: fnd_message.set_token('REASON', SQLERRM);
696:
697:

Line 694: fnd_message.set_token('ERROR' ,SQLCODE);

690: WHEN OTHERS THEN
691: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
692:
693: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
694: fnd_message.set_token('ERROR' ,SQLCODE);
695: fnd_message.set_token('REASON', SQLERRM);
696:
697:
698: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 695: fnd_message.set_token('REASON', SQLERRM);

691: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
692:
693: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
694: fnd_message.set_token('ERROR' ,SQLCODE);
695: fnd_message.set_token('REASON', SQLERRM);
696:
697:
698: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
699: MODULE => g_pkg || l_proc || 'proc_error',

Line 700: MESSAGE => fnd_message.get );

696:
697:
698: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
699: MODULE => g_pkg || l_proc || 'proc_error',
700: MESSAGE => fnd_message.get );
701:
702: END IF;
703: END;
704:

Line 1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1051: EXCEPTION
1052: WHEN OTHERS THEN
1053:
1054: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);
1059:

Line 1056: fnd_message.set_token('ERROR',SQLCODE);

1052: WHEN OTHERS THEN
1053:
1054: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);
1059:
1060: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 1057: fnd_message.set_token('REASON',SQLERRM);

1053:
1054: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);
1059:
1060: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1061: MODULE => g_pkg || l_proc || 'proc_error',

Line 1058: fnd_message.set_token('ROUTINE',l_proc);

1054: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1055: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1056: fnd_message.set_token('ERROR',SQLCODE);
1057: fnd_message.set_token('REASON',SQLERRM);
1058: fnd_message.set_token('ROUTINE',l_proc);
1059:
1060: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1061: MODULE => g_pkg || l_proc || 'proc_error',
1062: MESSAGE => fnd_message.get );

Line 1062: MESSAGE => fnd_message.get );

1058: fnd_message.set_token('ROUTINE',l_proc);
1059:
1060: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1061: MODULE => g_pkg || l_proc || 'proc_error',
1062: MESSAGE => fnd_message.get );
1063:
1064: END IF;
1065:
1066:

Line 1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1557: EXCEPTION
1558: WHEN OTHERS THEN
1559:
1560: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1562: fnd_message.set_token('ERROR' ,SQLCODE);
1563: fnd_message.set_token('REASON', SQLERRM);
1564:
1565: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 1562: fnd_message.set_token('ERROR' ,SQLCODE);

1558: WHEN OTHERS THEN
1559:
1560: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1562: fnd_message.set_token('ERROR' ,SQLCODE);
1563: fnd_message.set_token('REASON', SQLERRM);
1564:
1565: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1566: MODULE => g_pkg || l_proc || 'proc_error',

Line 1563: fnd_message.set_token('REASON', SQLERRM);

1559:
1560: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1561: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1562: fnd_message.set_token('ERROR' ,SQLCODE);
1563: fnd_message.set_token('REASON', SQLERRM);
1564:
1565: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1566: MODULE => g_pkg || l_proc || 'proc_error',
1567: MESSAGE => fnd_message.get );

Line 1567: MESSAGE => fnd_message.get );

1563: fnd_message.set_token('REASON', SQLERRM);
1564:
1565: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1566: MODULE => g_pkg || l_proc || 'proc_error',
1567: MESSAGE => fnd_message.get );
1568:
1569: END IF;
1570:
1571: END;

Line 1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1705: EXCEPTION
1706: WHEN OTHERS THEN
1707:
1708: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);
1713:

Line 1710: fnd_message.set_token('ERROR',SQLCODE);

1706: WHEN OTHERS THEN
1707:
1708: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);
1713:
1714: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 1711: fnd_message.set_token('REASON',SQLERRM);

1707:
1708: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);
1713:
1714: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1715: MODULE => g_pkg || l_proc || 'proc_error',

Line 1712: fnd_message.set_token('ROUTINE',l_proc);

1708: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1710: fnd_message.set_token('ERROR',SQLCODE);
1711: fnd_message.set_token('REASON',SQLERRM);
1712: fnd_message.set_token('ROUTINE',l_proc);
1713:
1714: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1715: MODULE => g_pkg || l_proc || 'proc_error',
1716: MESSAGE => fnd_message.get );

Line 1716: MESSAGE => fnd_message.get );

1712: fnd_message.set_token('ROUTINE',l_proc);
1713:
1714: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1715: MODULE => g_pkg || l_proc || 'proc_error',
1716: MESSAGE => fnd_message.get );
1717:
1718: END IF;
1719:
1720: END;

Line 1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

1735: EXCEPTION
1736: WHEN OTHERS THEN
1737:
1738: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);
1743:

Line 1740: fnd_message.set_token('ERROR',SQLCODE);

1736: WHEN OTHERS THEN
1737:
1738: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);
1743:
1744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 1741: fnd_message.set_token('REASON',SQLERRM);

1737:
1738: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);
1743:
1744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1745: MODULE => g_pkg || l_proc || 'proc_error',

Line 1742: fnd_message.set_token('ROUTINE',l_proc);

1738: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1739: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1740: fnd_message.set_token('ERROR',SQLCODE);
1741: fnd_message.set_token('REASON',SQLERRM);
1742: fnd_message.set_token('ROUTINE',l_proc);
1743:
1744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1745: MODULE => g_pkg || l_proc || 'proc_error',
1746: MESSAGE => fnd_message.get );

Line 1746: MESSAGE => fnd_message.get );

1742: fnd_message.set_token('ROUTINE',l_proc);
1743:
1744: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
1745: MODULE => g_pkg || l_proc || 'proc_error',
1746: MESSAGE => fnd_message.get );
1747:
1748: END IF;
1749:
1750: END;

Line 2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');

2085: EXCEPTION
2086: WHEN OTHERS THEN
2087:
2088: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);
2093:

Line 2090: fnd_message.set_token('ERROR' ,SQLCODE);

2086: WHEN OTHERS THEN
2087:
2088: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);
2093:
2094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 2091: fnd_message.set_token('REASON', SQLERRM);

2087:
2088: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);
2093:
2094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2095: MODULE => g_pkg || l_proc || 'proc_error',

Line 2092: fnd_message.set_token('ROUTINE',l_proc);

2088: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2089: fnd_message.set_name('FND','SQL_PLSQL_ERROR');
2090: fnd_message.set_token('ERROR' ,SQLCODE);
2091: fnd_message.set_token('REASON', SQLERRM);
2092: fnd_message.set_token('ROUTINE',l_proc);
2093:
2094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2095: MODULE => g_pkg || l_proc || 'proc_error',
2096: MESSAGE => fnd_message.get );

Line 2096: MESSAGE => fnd_message.get );

2092: fnd_message.set_token('ROUTINE',l_proc);
2093:
2094: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2095: MODULE => g_pkg || l_proc || 'proc_error',
2096: MESSAGE => fnd_message.get );
2097:
2098: END IF;
2099:
2100: END BIL_BI_FRCST_PIPE_TREND;

Line 2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2342: EXCEPTION
2343: WHEN OTHERS THEN
2344:
2345: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2347: fnd_message.set_token('Error is : ' ,SQLCODE);
2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:
2350: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 2347: fnd_message.set_token('Error is : ' ,SQLCODE);

2343: WHEN OTHERS THEN
2344:
2345: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2347: fnd_message.set_token('Error is : ' ,SQLCODE);
2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:
2350: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2351: MODULE => g_pkg || l_proc || 'proc_error',

Line 2348: fnd_message.set_token('Reason is : ', SQLERRM);

2344:
2345: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2346: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2347: fnd_message.set_token('Error is : ' ,SQLCODE);
2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:
2350: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2351: MODULE => g_pkg || l_proc || 'proc_error',
2352: MESSAGE => fnd_message.get );

Line 2352: MESSAGE => fnd_message.get );

2348: fnd_message.set_token('Reason is : ', SQLERRM);
2349:
2350: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2351: MODULE => g_pkg || l_proc || 'proc_error',
2352: MESSAGE => fnd_message.get );
2353:
2354: END IF;
2355:
2356: COMMIT;

Line 2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);
2703:

Line 2700: fnd_message.set_token('ERROR' ,SQLCODE);

2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);
2703:
2704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 2701: fnd_message.set_token('REASON', SQLERRM);

2697: WHEN OTHERS THEN
2698: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);
2703:
2704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2705: MODULE => g_pkg || l_proc || 'proc_error',

Line 2702: fnd_message.set_token('ROUTINE', l_proc);

2698: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2699: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
2700: fnd_message.set_token('ERROR' ,SQLCODE);
2701: fnd_message.set_token('REASON', SQLERRM);
2702: fnd_message.set_token('ROUTINE', l_proc);
2703:
2704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2705: MODULE => g_pkg || l_proc || 'proc_error',
2706: MESSAGE => fnd_message.get );

Line 2706: MESSAGE => fnd_message.get );

2702: fnd_message.set_token('ROUTINE', l_proc);
2703:
2704: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
2705: MODULE => g_pkg || l_proc || 'proc_error',
2706: MESSAGE => fnd_message.get );
2707:
2708: END IF;
2709:
2710: COMMIT;

Line 3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3236:
3237: EXCEPTION
3238: WHEN OTHERS THEN
3239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3241: fnd_message.set_token('Error is : ' ,SQLCODE);
3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:
3244: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 3241: fnd_message.set_token('Error is : ' ,SQLCODE);

3237: EXCEPTION
3238: WHEN OTHERS THEN
3239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3241: fnd_message.set_token('Error is : ' ,SQLCODE);
3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:
3244: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3245: MODULE => g_pkg || l_proc || 'proc_error',

Line 3242: fnd_message.set_token('Reason is : ', SQLERRM);

3238: WHEN OTHERS THEN
3239: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3240: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3241: fnd_message.set_token('Error is : ' ,SQLCODE);
3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:
3244: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3245: MODULE => g_pkg || l_proc || 'proc_error',
3246: MESSAGE => fnd_message.get );

Line 3246: MESSAGE => fnd_message.get );

3242: fnd_message.set_token('Reason is : ', SQLERRM);
3243:
3244: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3245: MODULE => g_pkg || l_proc || 'proc_error',
3246: MESSAGE => fnd_message.get );
3247:
3248: END IF;
3249:
3250: RAISE;

Line 3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

3775: EXCEPTION
3776:
3777: WHEN OTHERS THEN
3778: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3780: fnd_message.set_token('Error is : ' ,SQLCODE);
3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:
3783: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,

Line 3780: fnd_message.set_token('Error is : ' ,SQLCODE);

3776:
3777: WHEN OTHERS THEN
3778: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3780: fnd_message.set_token('Error is : ' ,SQLCODE);
3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:
3783: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3784: MODULE => g_pkg || l_proc || 'proc_error',

Line 3781: fnd_message.set_token('Reason is : ', SQLERRM);

3777: WHEN OTHERS THEN
3778: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3779: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
3780: fnd_message.set_token('Error is : ' ,SQLCODE);
3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:
3783: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3784: MODULE => g_pkg || l_proc || 'proc_error',
3785: MESSAGE => fnd_message.get );

Line 3785: MESSAGE => fnd_message.get );

3781: fnd_message.set_token('Reason is : ', SQLERRM);
3782:
3783: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
3784: MODULE => g_pkg || l_proc || 'proc_error',
3785: MESSAGE => fnd_message.get );
3786: END IF;
3787: COMMIT;
3788: RAISE;
3789: END BIL_BI_WIN_LOSS_CONV_TREND;

Line 4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4072:
4073: EXCEPTION
4074: WHEN OTHERS THEN
4075: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4080: MODULE => g_pkg || l_proc || 'proc_error',

Line 4077: fnd_message.set_token('Error is : ' ,SQLCODE);

4073: EXCEPTION
4074: WHEN OTHERS THEN
4075: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4080: MODULE => g_pkg || l_proc || 'proc_error',
4081: MESSAGE => fnd_message.get );

Line 4078: fnd_message.set_token('Reason is : ', SQLERRM);

4074: WHEN OTHERS THEN
4075: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4076: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4080: MODULE => g_pkg || l_proc || 'proc_error',
4081: MESSAGE => fnd_message.get );
4082: END IF;

Line 4081: MESSAGE => fnd_message.get );

4077: fnd_message.set_token('Error is : ' ,SQLCODE);
4078: fnd_message.set_token('Reason is : ', SQLERRM);
4079: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4080: MODULE => g_pkg || l_proc || 'proc_error',
4081: MESSAGE => fnd_message.get );
4082: END IF;
4083: COMMIT;
4084: RAISE;
4085: END;

Line 4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

4418:
4419: EXCEPTION
4420: WHEN OTHERS THEN
4421: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4426: MODULE => g_pkg || l_proc || 'proc_error',

Line 4423: fnd_message.set_token('Error is : ' ,SQLCODE);

4419: EXCEPTION
4420: WHEN OTHERS THEN
4421: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4426: MODULE => g_pkg || l_proc || 'proc_error',
4427: MESSAGE => fnd_message.get );

Line 4424: fnd_message.set_token('Reason is : ', SQLERRM);

4420: WHEN OTHERS THEN
4421: IF FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4422: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4426: MODULE => g_pkg || l_proc || 'proc_error',
4427: MESSAGE => fnd_message.get );
4428:

Line 4427: MESSAGE => fnd_message.get );

4423: fnd_message.set_token('Error is : ' ,SQLCODE);
4424: fnd_message.set_token('Reason is : ', SQLERRM);
4425: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_UNEXPECTED,
4426: MODULE => g_pkg || l_proc || 'proc_error',
4427: MESSAGE => fnd_message.get );
4428:
4429: END IF;
4430:
4431: COMMIT;