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.CSI_MASS_EDIT_PUB dependencies on CSI_T_GEN_UTILITY_PVT

Line 21: csi_t_gen_utility_pvt.add(p_message);

17: p_message IN varchar2)
18: IS
19: BEGIN
20: FND_FILE.PUT_LINE (FND_FILE.LOG, p_message );
21: csi_t_gen_utility_pvt.add(p_message);
22: END debug;
23:
24: PROCEDURE debug_out(
25: p_message IN varchar2)

Line 879: csi_t_gen_utility_pvt.dump_txn_tables(

875: debug(' ext_attrib_tbl.count :'||d_ext_attrib_tbl.count);
876:
877: debug('Dump Txn Details Information .....');
878:
879: csi_t_gen_utility_pvt.dump_txn_tables(
880: p_ids_or_index_based => 'I',
881: p_line_detail_tbl => d_line_dtl_tbl,
882: p_party_detail_tbl => d_pty_dtl_tbl,
883: p_pty_acct_tbl => d_pty_acct_tbl,

Line 1200: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);

1196: debug(' Extendedattr_tbl '||n_ext_attrib_values_tbl.count);
1197: IF n_instance_tbl.count > 0
1198: THEN
1199:
1200: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1201: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1202: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1203: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1204: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);

Line 1201: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);

1197: IF n_instance_tbl.count > 0
1198: THEN
1199:
1200: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1201: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1202: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1203: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1204: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);
1205:

Line 1202: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);

1198: THEN
1199:
1200: csi_t_gen_utility_pvt.dump_csi_instance_tbl(n_instance_tbl);
1201: csi_t_gen_utility_pvt.dump_csi_party_tbl(n_party_tbl);
1202: csi_t_gen_utility_pvt.dump_csi_account_tbl(n_party_account_tbl);
1203: debug('Source Transaction Date in Transaction: '||n_txn_rec.source_transaction_date);
1204: debug('Transaction Date in Transaction: '||n_txn_rec.transaction_date);
1205:
1206: csi_item_instance_grp.update_item_instance (

Line 1640: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');

1636: Begin
1637: -- Standard Start of API savepoint
1638: SAVEPOINT create_mass_edit_pub;
1639:
1640: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1641: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1642:
1643: -- Initialize message list if p_init_msg_list is set to TRUE.
1644: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1641: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1637: -- Standard Start of API savepoint
1638: SAVEPOINT create_mass_edit_pub;
1639:
1640: csi_t_gen_utility_pvt.add('API Being Executed : CREATE_MASS_EDIT_BATCH_PUB');
1641: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1642:
1643: -- Initialize message list if p_init_msg_list is set to TRUE.
1644: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1645: FND_MSG_PUB.Initialize;

Line 1709: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1705: (p_count => x_msg_count,
1706: p_data => x_msg_data
1707: );
1708:
1709: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1710: EXCEPTION
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: ROLLBACK TO create_mass_edit_pub;
1713: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1805: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');

1801:
1802: -- Standard Start of API savepoint
1803: SAVEPOINT update_mass_edit_pub;
1804:
1805: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1806: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1807:
1808: -- Initialize message list if p_init_msg_list is set to TRUE.
1809: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1806: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1802: -- Standard Start of API savepoint
1803: SAVEPOINT update_mass_edit_pub;
1804:
1805: csi_t_gen_utility_pvt.add('API Being Executed : UPDATE_MASS_EDIT_BATCH_PUB');
1806: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1807:
1808: -- Initialize message list if p_init_msg_list is set to TRUE.
1809: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1810: FND_MSG_PUB.Initialize;

Line 1843: csi_t_gen_utility_pvt.add('px_txn_line_detail_tbl.count: '||px_mass_edit_inst_tbl.count);

1839: RAISE FND_API.g_exc_error;
1840: END IF;
1841:
1842: -- call API to run
1843: csi_t_gen_utility_pvt.add('px_txn_line_detail_tbl.count: '||px_mass_edit_inst_tbl.count);
1844:
1845:
1846: csi_mass_edit_pvt.update_mass_edit_batch
1847: (

Line 1875: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1871: IF FND_API.To_Boolean( p_commit ) THEN
1872: COMMIT WORK;
1873: END IF;
1874:
1875: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1876: EXCEPTION
1877: WHEN FND_API.G_EXC_ERROR THEN
1878: ROLLBACK TO update_mass_edit_pub;
1879: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1933: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');

1929:
1930: -- Standard Start of API savepoint
1931: SAVEPOINT delete_mass_edit_batch;
1932:
1933: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1934: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1935:
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 1934: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1930: -- Standard Start of API savepoint
1931: SAVEPOINT delete_mass_edit_batch;
1932:
1933: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCH');
1934: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1935:
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1938: FND_MSG_PUB.Initialize;

Line 1998: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');

1994: (p_count => x_msg_count,
1995: p_data => x_msg_data
1996: );
1997:
1998: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1999: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2000:
2001: csi_t_gen_utility_pvt.set_debug_off;
2002:

Line 1999: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1995: p_data => x_msg_data
1996: );
1997:
1998: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1999: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2000:
2001: csi_t_gen_utility_pvt.set_debug_off;
2002:
2003: EXCEPTION

Line 2001: csi_t_gen_utility_pvt.set_debug_off;

1997:
1998: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batch');
1999: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2000:
2001: csi_t_gen_utility_pvt.set_debug_off;
2002:
2003: EXCEPTION
2004: WHEN FND_API.G_EXC_ERROR THEN
2005:

Line 2012: csi_t_gen_utility_pvt.set_debug_off;

2008: FND_MSG_PUB.Count_And_Get (
2009: p_count => x_msg_count,
2010: p_data => x_msg_data);
2011:
2012: csi_t_gen_utility_pvt.set_debug_off;
2013:
2014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2015:
2016: ROLLBACK TO Delete_Mass_Edit_Batch;

Line 2023: csi_t_gen_utility_pvt.set_debug_off;

2019: FND_MSG_PUB.Count_And_Get(
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:
2023: csi_t_gen_utility_pvt.set_debug_off;
2024:
2025: WHEN OTHERS THEN
2026:
2027: ROLLBACK TO Delete_Mass_Edit_Batch;

Line 2043: csi_t_gen_utility_pvt.set_debug_off;

2039: FND_MSG_PUB.Count_And_Get(
2040: p_count => x_msg_count,
2041: p_data => x_msg_data);
2042:
2043: csi_t_gen_utility_pvt.set_debug_off;
2044:
2045: END Delete_Mass_Edit_Batch;
2046:
2047: /* This is the wrapper API to handle multiple batch deletes. Calls the DELETE_MASS_EDIT_BATCH */

Line 2073: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');

2069:
2070: -- Standard Start of API savepoint
2071: SAVEPOINT delete_mass_edit_batches;
2072:
2073: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
2074: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2075:
2076: -- Initialize message list if p_init_msg_list is set to TRUE.
2077: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 2074: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2070: -- Standard Start of API savepoint
2071: SAVEPOINT delete_mass_edit_batches;
2072:
2073: csi_t_gen_utility_pvt.add('API Being Executed : DELETE_MASS_EDIT_BATCHES');
2074: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2075:
2076: -- Initialize message list if p_init_msg_list is set to TRUE.
2077: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2078: FND_MSG_PUB.Initialize;

Line 2142: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');

2138: (p_count => x_msg_count,
2139: p_data => x_msg_data
2140: );
2141:
2142: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2143: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2144:
2145: csi_t_gen_utility_pvt.set_debug_off;
2146:

Line 2143: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2139: p_data => x_msg_data
2140: );
2141:
2142: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2143: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2144:
2145: csi_t_gen_utility_pvt.set_debug_off;
2146:
2147: EXCEPTION

Line 2145: csi_t_gen_utility_pvt.set_debug_off;

2141:
2142: csi_t_gen_utility_pvt.add('API Executed : Delete Mass Edit Batches');
2143: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2144:
2145: csi_t_gen_utility_pvt.set_debug_off;
2146:
2147: EXCEPTION
2148: WHEN FND_API.G_EXC_ERROR THEN
2149:

Line 2156: csi_t_gen_utility_pvt.set_debug_off;

2152: FND_MSG_PUB.Count_And_Get (
2153: p_count => x_msg_count,
2154: p_data => x_msg_data);
2155:
2156: csi_t_gen_utility_pvt.set_debug_off;
2157:
2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2159:
2160: ROLLBACK TO Delete_Mass_Edit_Batches;

Line 2167: csi_t_gen_utility_pvt.set_debug_off;

2163: FND_MSG_PUB.Count_And_Get(
2164: p_count => x_msg_count,
2165: p_data => x_msg_data);
2166:
2167: csi_t_gen_utility_pvt.set_debug_off;
2168:
2169: WHEN OTHERS THEN
2170:
2171: ROLLBACK TO Delete_Mass_Edit_Batches;

Line 2186: csi_t_gen_utility_pvt.set_debug_off;

2182: FND_MSG_PUB.Count_And_Get(
2183: p_count => x_msg_count,
2184: p_data => x_msg_data);
2185:
2186: csi_t_gen_utility_pvt.set_debug_off;
2187:
2188: END Delete_Mass_Edit_Batches;
2189:
2190: /*

Line 2221: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');

2217:
2218: -- Standard Start of API savepoint
2219: SAVEPOINT get_mass_edit_details;
2220:
2221: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2222: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2223:
2224: -- Initialize message list if p_init_msg_list is set to TRUE.
2225: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 2222: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2218: -- Standard Start of API savepoint
2219: SAVEPOINT get_mass_edit_details;
2220:
2221: csi_t_gen_utility_pvt.add('API Being Executed : GET_MASS_EDIT_DETAILS');
2222: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2223:
2224: -- Initialize message list if p_init_msg_list is set to TRUE.
2225: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2226: FND_MSG_PUB.Initialize;

Line 2293: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');

2289: (p_count => x_msg_count,
2290: p_data => x_msg_data
2291: );
2292:
2293: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2294: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2295:
2296: csi_t_gen_utility_pvt.set_debug_off;
2297:

Line 2294: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

2290: p_data => x_msg_data
2291: );
2292:
2293: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2294: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2295:
2296: csi_t_gen_utility_pvt.set_debug_off;
2297:
2298: EXCEPTION

Line 2296: csi_t_gen_utility_pvt.set_debug_off;

2292:
2293: csi_t_gen_utility_pvt.add('API Executed : Get Mass Edit Details');
2294: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
2295:
2296: csi_t_gen_utility_pvt.set_debug_off;
2297:
2298: EXCEPTION
2299: WHEN FND_API.G_EXC_ERROR THEN
2300:

Line 2307: csi_t_gen_utility_pvt.set_debug_off;

2303: FND_MSG_PUB.Count_And_Get (
2304: p_count => x_msg_count,
2305: p_data => x_msg_data);
2306:
2307: csi_t_gen_utility_pvt.set_debug_off;
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310:
2311: ROLLBACK TO Get_mass_edit_details;

Line 2318: csi_t_gen_utility_pvt.set_debug_off;

2314: FND_MSG_PUB.Count_And_Get(
2315: p_count => x_msg_count,
2316: p_data => x_msg_data);
2317:
2318: csi_t_gen_utility_pvt.set_debug_off;
2319:
2320: WHEN OTHERS THEN
2321:
2322: ROLLBACK TO Get_mass_edit_details;

Line 2338: csi_t_gen_utility_pvt.set_debug_off;

2334: FND_MSG_PUB.Count_And_Get(
2335: p_count => x_msg_count,
2336: p_data => x_msg_data);
2337:
2338: csi_t_gen_utility_pvt.set_debug_off;
2339:
2340: END Get_mass_edit_details;
2341:
2342: /*----------------------------------------------------*/