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.IBY_UTILITY_PVT dependencies on IBY_DEBUG_PUB

Line 121: iby_debug_pub.add('entered IBY_UTILITY_PVT.handle_exceptions()');

117: l_ora_err_msg VARCHAR2(2000);
118: l_error_reason VARCHAR2(80);
119: BEGIN
120:
121: iby_debug_pub.add('entered IBY_UTILITY_PVT.handle_exceptions()');
122:
123: l_api_name := UPPER(p_api_name);
124:
125: -- rollback to the savepoint

Line 144: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', code: '|| l_ora_err_code);

140:
141: l_ora_err_code := SQLCODE;
142: l_ora_err_msg := SQLERRM;
143:
144: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', code: '|| l_ora_err_code);
145: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
146: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
147: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
148:

Line 145: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);

141: l_ora_err_code := SQLCODE;
142: l_ora_err_msg := SQLERRM;
143:
144: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', code: '|| l_ora_err_code);
145: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
146: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
147: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
148:
149: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');

Line 161: iby_debug_pub.add('x_msg_count: ' || x_msg_count);

157: FND_MSG_PUB.Count_And_Get(
158: p_count => x_msg_count,
159: p_data => x_msg_data);
160:
161: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
162: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
163: iby_debug_pub.add('x_return_status: ' || x_return_status);
164:
165: -- finally add the exception msg to debug log

Line 162: iby_debug_pub.add('x_msg_data: ' || x_msg_data);

158: p_count => x_msg_count,
159: p_data => x_msg_data);
160:
161: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
162: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
163: iby_debug_pub.add('x_return_status: ' || x_return_status);
164:
165: -- finally add the exception msg to debug log
166: /*

Line 163: iby_debug_pub.add('x_return_status: ' || x_return_status);

159: p_data => x_msg_data);
160:
161: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
162: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
163: iby_debug_pub.add('x_return_status: ' || x_return_status);
164:
165: -- finally add the exception msg to debug log
166: /*
167: iby_debug_pub.add_return_messages(

Line 167: iby_debug_pub.add_return_messages(

163: iby_debug_pub.add('x_return_status: ' || x_return_status);
164:
165: -- finally add the exception msg to debug log
166: /*
167: iby_debug_pub.add_return_messages(
168: p_count => x_msg_count,
169: p_data => x_msg_data,
170: p_reason => l_error_reason
171: );

Line 848: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Getting from the cache',

844: l_count4 NUMBER;
845: BEGIN
846: IF(g_psr_snapshot_table.EXISTS(p_snapshot_code) AND g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count IS NOT NULL) THEN
847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Getting from the cache',
849: debug_level => FND_LOG.LEVEL_STATEMENT,
850: module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');
851: END IF;
852: l_ret_val:= g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count;

Line 1062: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_payment_status_flag :Getting from the cache',

1058:
1059: IF(g_psr_table.EXISTS(p_psr_id) AND g_psr_table(p_psr_id).payment_status_flag IS NOT NULL
1060: AND p_from_cache = 'TRUE') THEN
1061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_payment_status_flag :Getting from the cache',
1063: debug_level => FND_LOG.LEVEL_STATEMENT,
1064: module => 'IBY_UTILITY_PVT.get_payment_status_flag');
1065: END IF;
1066: l_payment_status_flag:= g_psr_table(p_psr_id).payment_status_flag;

Line 1146: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_status :Getting from the cache',

1142: BEGIN
1143: IF(g_psr_table.EXISTS(p_psr_id) AND g_psr_table(p_psr_id).psr_status IS NOT NULL
1144: AND p_from_cache = 'TRUE') THEN
1145: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_status :Getting from the cache',
1147: debug_level => FND_LOG.LEVEL_STATEMENT,
1148: module => 'IBY_UTILITY_PVT.get_psr_status');
1149: END IF;
1150: l_psr_status:= g_psr_table(p_psr_id).psr_status;

Line 1267: iby_debug_pub.add(debug_msg => 'ENTER: ' || 'IBY_UTILITY_PVT.initialize',

1263: PROCEDURE initialize
1264: IS
1265: BEGIN
1266: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1267: iby_debug_pub.add(debug_msg => 'ENTER: ' || 'IBY_UTILITY_PVT.initialize',
1268: debug_level => FND_LOG.LEVEL_STATEMENT,
1269: module => 'IBY_UTILITY_PVT.initialize');
1270: END IF;
1271: g_psr_table.DELETE;

Line 1275: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.initialize',

1271: g_psr_table.DELETE;
1272: g_psr_snapshot_table.DELETE;
1273: g_instr_access_table.DELETE;
1274: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1275: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.initialize',
1276: debug_level => FND_LOG.LEVEL_STATEMENT,
1277: module => 'IBY_UTILITY_PVT.initialize');
1278: END IF;
1279: END initialize;

Line 1427: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Getting from the cache', debug_level => FND_LOG.LEVEL_STATEMENT, module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');

1423: BEGIN
1424: IF(g_psr_snapshot_table.EXISTS(p_snapshot_code) AND g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count IS NOT NULL) THEN
1425:
1426: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1427: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Getting from the cache', debug_level => FND_LOG.LEVEL_STATEMENT, module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');
1428: END IF ;
1429: ELSE
1430: -- Initialize the variables.
1431: l_need_action :=0;

Line 1492: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Error in processing count', debug_level => FND_LOG.LEVEL_STATEMENT, module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');

1488: EXCEPTION
1489: WHEN NO_DATA_FOUND THEN
1490: NULL; -- Do Nothing.
1491: WHEN OTHERS THEN
1492: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Error in processing count', debug_level => FND_LOG.LEVEL_STATEMENT, module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');
1493: END;
1494: END IF;
1495: /* PAYMENTS_CREATED and it can be in either processing or need action group */
1496: /* IBY Terminated */

Line 1652: iby_debug_pub.add(debug_msg => 'Deleted all records from GT table',

1648:
1649: -- Deleting all records from GT table
1650: DELETE FROM IBY_PAY_DASHBOARD_GT;
1651: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1652: iby_debug_pub.add(debug_msg => 'Deleted all records from GT table',
1653: debug_level => FND_LOG.LEVEL_STATEMENT,
1654: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1655: END IF;
1656:

Line 1714: iby_debug_pub.add(debug_msg => 'Populated Need Action PPRs ',

1710: AND iby.call_app_pay_service_req_code =
1711: ap.checkrun_name);
1712:
1713: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1714: iby_debug_pub.add(debug_msg => 'Populated Need Action PPRs ',
1715: debug_level => FND_LOG.LEVEL_STATEMENT,
1716: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1717: END IF;
1718:

Line 1790: iby_debug_pub.add(debug_msg => 'Populated Processing PPRs ',

1786: AND iby.call_app_pay_service_req_code =
1787: ap.checkrun_name);
1788:
1789: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1790: iby_debug_pub.add(debug_msg => 'Populated Processing PPRs ',
1791: debug_level => FND_LOG.LEVEL_STATEMENT,
1792: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1793: END IF;
1794:

Line 1833: iby_debug_pub.add(debug_msg => 'Populated User Terminated PPRs ',

1829: ap.checkrun_name)
1830: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1831:
1832: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1833: iby_debug_pub.add(debug_msg => 'Populated User Terminated PPRs ',
1834: debug_level => FND_LOG.LEVEL_STATEMENT,
1835: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1836: END IF;
1837:

Line 1861: iby_debug_pub.add(debug_msg => 'Populated Program Errors PPRs ',

1857: 'PENDING_REVIEW_PMT_VAL_ERRORS'))
1858: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1859:
1860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1861: iby_debug_pub.add(debug_msg => 'Populated Program Errors PPRs ',
1862: debug_level => FND_LOG.LEVEL_STATEMENT,
1863: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1864: END IF;
1865:

Line 1888: iby_debug_pub.add(debug_msg => 'Populated Completed PPRs ',

1884: AND AP_PAYMENT_UTIL_PKG.get_payment_status_flag(iby.payment_service_request_id) = 'Y')
1885: AND ap.creation_date BETWEEN TRUNC(SYSDATE) AND (TRUNC(SYSDATE) + 0.99999);
1886:
1887: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: iby_debug_pub.add(debug_msg => 'Populated Completed PPRs ',
1889: debug_level => FND_LOG.LEVEL_STATEMENT,
1890: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1891: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.populate_psr_snapshot_count',
1892: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 1891: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.populate_psr_snapshot_count',

1887: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: iby_debug_pub.add(debug_msg => 'Populated Completed PPRs ',
1889: debug_level => FND_LOG.LEVEL_STATEMENT,
1890: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1891: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.populate_psr_snapshot_count',
1892: debug_level => FND_LOG.LEVEL_STATEMENT,
1893: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1894: END IF;
1895: