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_UTILITY_PVT

Line 1: Package Body IBY_UTILITY_PVT AS

1: Package Body IBY_UTILITY_PVT AS
2: /* $Header: ibyvutlb.pls 120.44.12020000.3 2012/11/16 08:53:19 gmamidip ship $ */
3:
4:
5: -- Added for encoding/decoding in Base64.

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 128: IF p_exception_type = iby_utility_pvt.g_expt_err

124:
125: -- rollback to the savepoint
126: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(p_rollback_point);
127:
128: IF p_exception_type = iby_utility_pvt.g_expt_err
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err

Line 132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err

128: IF p_exception_type = iby_utility_pvt.g_expt_err
129: THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: l_error_reason := 'FND_API.G_RET_STS_ERROR';
132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err

Line 136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err

132: ELSIF p_exception_type = iby_utility_pvt.g_expt_unexp_err
133: THEN
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: l_error_reason := 'FND_API.G_RET_STS_UNEXP_ERROR';
136: ELSIF p_exception_type = iby_utility_pvt.g_expt_otr_err
137: THEN
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: l_error_reason := 'G_EXC_OTHERS';
140:

Line 198: l_ibycode_start := INSTR(p_err_msg,iby_utility_pvt.C_ERRCODE_PREFIX);

194: --
195: -- check if 'IBY_' is present in the error message; if so
196: -- then the exception was internally generated
197: --
198: l_ibycode_start := INSTR(p_err_msg,iby_utility_pvt.C_ERRCODE_PREFIX);
199:
200: IF (l_ibycode_start > 0) THEN
201:
202: l_ibycode_end:=INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR)-1;

Line 202: l_ibycode_end:=INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR)-1;

198: l_ibycode_start := INSTR(p_err_msg,iby_utility_pvt.C_ERRCODE_PREFIX);
199:
200: IF (l_ibycode_start > 0) THEN
201:
202: l_ibycode_end:=INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR)-1;
203: IF (l_ibycode_end < 1) THEN
204: l_ibycode_end := l_msg_len;
205: END IF;
206: l_err_code := SUBSTR(p_err_msg,l_ibycode_start,l_ibycode_end-l_ibycode_start+1);

Line 214: l_val_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_VAL_CONCATENATOR,l_index);

210: -- to go past it to the beginning of the token name
211: --
212: l_index:= l_ibycode_end+1+1;
213: WHILE l_index < l_msg_len LOOP
214: l_val_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_VAL_CONCATENATOR,l_index);
215: IF (l_val_concat < 1) THEN
216: EXIT;
217: END IF;
218: l_tok_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR,l_index);

Line 218: l_tok_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR,l_index);

214: l_val_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_VAL_CONCATENATOR,l_index);
215: IF (l_val_concat < 1) THEN
216: EXIT;
217: END IF;
218: l_tok_concat := INSTR(p_err_msg,iby_utility_pvt.C_TOKEN_CONCATENATOR,l_index);
219: IF (l_tok_concat < 1) THEN
220: -- the error message is usually of the form:
221: --
222: -- ORA-2000: IBY_XXXX#TOKENNAME=TOKENVAL#...

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 850: module => 'IBY_UTILITY_PVT.get_psr_snapshot_count');

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;
853: ELSE
854: IF (p_snapshot_code = 'NEED_ACTION_BY_ME') THEN

Line 882: AND iby_utility_pvt.check_user_access(instr.payment_instruction_id) = 'Y'

878: AND instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED',
879: 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING',
880: 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'TRANSMITTED')
881: AND instr.payments_complete_code = 'NO'
882: AND iby_utility_pvt.check_user_access(instr.payment_instruction_id) = 'Y'
883: )
884: )
885: );
886:

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 1064: module => 'IBY_UTILITY_PVT.get_payment_status_flag');

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;
1067: ELSE
1068:

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 1148: module => 'IBY_UTILITY_PVT.get_psr_status');

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;
1151: ELSE
1152:

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 1269: module => 'IBY_UTILITY_PVT.initialize');

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;
1272: g_psr_snapshot_table.DELETE;
1273: g_instr_access_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 1277: module => 'IBY_UTILITY_PVT.initialize');

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;
1280:
1281:

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 1654: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1657:
1658: -- Inserting PPR's which need Action - 'NEED_ACTION_BY_ME'

Line 1693: AND iby_utility_pvt.check_user_access(instr.payment_instruction_id) = 'Y'

1689: AND instr.payment_instruction_status IN ('CREATION_ERROR', 'FORMATTED_READY_TO_TRANSMIT', 'TRANSMISSION_FAILED',
1690: 'FORMATTED_READY_FOR_PRINTING', 'SUBMITTED_FOR_PRINTING', 'CREATED_READY_FOR_PRINTING',
1691: 'CREATED_READY_FOR_FORMATTING', 'FORMATTED', 'CREATED', 'TRANSMITTED')
1692: AND instr.payments_complete_code = 'NO'
1693: AND iby_utility_pvt.check_user_access(instr.payment_instruction_id) = 'Y'
1694: )
1695: );
1696:
1697: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

Line 1716: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1719: -- Inserting PPRs which are in Processing Status - 'PROCESSING'
1720: /*Modified the query for the Bug 7560766

Line 1792: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1795: -- Inserting PPRs which are terminated by User --'USER_TERMINATED'
1796: INSERT INTO IBY_PAY_DASHBOARD_GT(PAYMENT_SERVICE_REQUEST_ID,

Line 1835: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1838:
1839: -- Inserting PPRs which are halted with Program Errors -'PROGRAM_ERRORS'

Line 1863: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1866: -- Insert PPRs which are completed - 'COMPLETED'
1867:

Line 1890: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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,
1893: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');
1894: END IF;

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:

Line 1893: module => 'IBY_UTILITY_PVT.populate_psr_snapshot_count');

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:
1896: END populate_psr_snapshot_count;
1897:

Line 1898: END IBY_UTILITY_PVT;

1894: END IF;
1895:
1896: END populate_psr_snapshot_count;
1897:
1898: END IBY_UTILITY_PVT;