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 110: iby_debug_pub.add('entered IBY_UTILITY_PVT.handle_exceptions()');

106: l_ora_err_msg VARCHAR2(2000);
107: l_error_reason VARCHAR2(80);
108: BEGIN
109:
110: iby_debug_pub.add('entered IBY_UTILITY_PVT.handle_exceptions()');
111:
112: l_api_name := UPPER(p_api_name);
113:
114: -- rollback to the savepoint

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

129:
130: l_ora_err_code := SQLCODE;
131: l_ora_err_msg := SQLERRM;
132:
133: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', code: '|| l_ora_err_code);
134: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
135: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
136: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
137:

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

130: l_ora_err_code := SQLCODE;
131: l_ora_err_msg := SQLERRM;
132:
133: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', code: '|| l_ora_err_code);
134: iby_debug_pub.add('Oracle error in ' || p_pkg_name || '.' || p_api_name || ', msg : '|| l_ora_err_msg);
135: --dbms_output.put_line('Oracle error, code: '|| l_ora_err_code);
136: --dbms_output.put_line('Oracle error, msg : '|| l_ora_err_msg);
137:
138: fnd_message.set_name('IBY', 'IBY_G_SQL_ERR');

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

146: FND_MSG_PUB.Count_And_Get(
147: p_count => x_msg_count,
148: p_data => x_msg_data);
149:
150: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
151: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
152: iby_debug_pub.add('x_return_status: ' || x_return_status);
153:
154: -- finally add the exception msg to debug log

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

147: p_count => x_msg_count,
148: p_data => x_msg_data);
149:
150: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
151: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
152: iby_debug_pub.add('x_return_status: ' || x_return_status);
153:
154: -- finally add the exception msg to debug log
155: /*

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

148: p_data => x_msg_data);
149:
150: iby_debug_pub.add('x_msg_count: ' || x_msg_count);
151: iby_debug_pub.add('x_msg_data: ' || x_msg_data);
152: iby_debug_pub.add('x_return_status: ' || x_return_status);
153:
154: -- finally add the exception msg to debug log
155: /*
156: iby_debug_pub.add_return_messages(

Line 156: iby_debug_pub.add_return_messages(

152: iby_debug_pub.add('x_return_status: ' || x_return_status);
153:
154: -- finally add the exception msg to debug log
155: /*
156: iby_debug_pub.add_return_messages(
157: p_count => x_msg_count,
158: p_data => x_msg_data,
159: p_reason => l_error_reason
160: );

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

819: l_count4 NUMBER;
820: BEGIN
821: IF(g_psr_snapshot_table.EXISTS(p_snapshot_code) AND g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count IS NOT NULL) THEN
822: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_snapshot_count :Getting from the cache',
824: debug_level => FND_LOG.LEVEL_STATEMENT,
825: module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');
826: END IF;
827: l_ret_val:= g_psr_snapshot_table(p_snapshot_code).psr_snapshot_count;

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

1034: IF ( p_psr_id IS NOT NULL ) THEN
1035:
1036: IF(g_psr_table.EXISTS(p_psr_id) AND g_psr_table(p_psr_id).payment_status_flag IS NOT NULL) THEN
1037: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_payment_status_flag :Getting from the cache',
1039: debug_level => FND_LOG.LEVEL_STATEMENT,
1040: module => 'IBY_UTILITY_PVT.get_payment_status_flag');
1041: END IF;
1042: l_payment_status_flag:= g_psr_table(p_psr_id).payment_status_flag;

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

1113:
1114: BEGIN
1115: IF(g_psr_table.EXISTS(p_psr_id) AND g_psr_table(p_psr_id).psr_status IS NOT NULL) THEN
1116: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1117: iby_debug_pub.add(debug_msg => 'IBY_UTILITY_PVT.get_psr_status :Getting from the cache',
1118: debug_level => FND_LOG.LEVEL_STATEMENT,
1119: module => 'IBY_UTILITY_PVT.get_psr_status');
1120: END IF;
1121: l_psr_status:= g_psr_table(p_psr_id).psr_status;

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

1216: PROCEDURE initialize
1217: IS
1218: BEGIN
1219: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1220: iby_debug_pub.add(debug_msg => 'ENTER: ' || 'IBY_UTILITY_PVT.initialize',
1221: debug_level => FND_LOG.LEVEL_STATEMENT,
1222: module => 'IBY_UTILITY_PVT.initialize');
1223: END IF;
1224: g_psr_table.DELETE;

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

1224: g_psr_table.DELETE;
1225: g_psr_snapshot_table.DELETE;
1226: g_instr_access_table.DELETE;
1227: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1228: iby_debug_pub.add(debug_msg => 'Exit: ' || 'IBY_UTILITY_PVT.initialize',
1229: debug_level => FND_LOG.LEVEL_STATEMENT,
1230: module => 'IBY_UTILITY_PVT.initialize');
1231: END IF;
1232: END initialize;