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_PARTY_MERGE_PKG dependencies on CSI_T_GEN_UTILITY_PVT

Line 58: csi_t_gen_utility_pvt.g_debug_level := 10;

54: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
55: BEGIN
56: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
57:
58: csi_t_gen_utility_pvt.g_debug_level := 10;
59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');

Line 59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',

55: BEGIN
56: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
57:
58: csi_t_gen_utility_pvt.g_debug_level := 10;
59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);

Line 62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');

58: csi_t_gen_utility_pvt.g_debug_level := 10;
59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);

Line 63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);

59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);

Line 64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);

60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);

Line 65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);

61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);
69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);

Line 66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);

62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);
69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);
70:

Line 67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);

63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);
69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);
70:
71:

Line 68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);

64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);
69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);
70:
71:
72:

Line 69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);

65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);
67: csi_t_gen_utility_pvt.ADD('Parent Entity Name '||p_parent_entity_name);
68: csi_t_gen_utility_pvt.ADD ('Batch ID '||p_batch_id);
69: csi_t_gen_utility_pvt.ADD('Batch Party ID '|| p_batch_party_id);
70:
71:
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 96: csi_t_gen_utility_pvt.ADD('Before find merge_reason ');

92: v_internal_party_message := 'Cannot merge party id '||to_char(p_from_fk_id)||' '||'to party id '||to_char(p_to_fk_id)||'. One of the party ids is defined as internal party in CSI-Installed Base';
93: raise internal_party_error;
94: end if;
95:
96: csi_t_gen_utility_pvt.ADD('Before find merge_reason ');
97:
98: select merge_reason_code
99: into l_merge_reason_code
100: from hz_merge_batch

Line 103: csi_t_gen_utility_pvt.ADD('merge_reason '||l_merge_reason_code);

99: into l_merge_reason_code
100: from hz_merge_batch
101: where batch_id = p_batch_id;
102:
103: csi_t_gen_utility_pvt.ADD('merge_reason '||l_merge_reason_code);
104:
105:
106: if l_merge_reason_code = 'DUPLICATE' then
107: -- if reason code is duplicate then allow the party merge to

Line 124: csi_t_gen_utility_pvt.ADD('Party Merge ');

120: IF p_from_fk_id <> p_to_fk_id then
121: BEGIN
122: If p_parent_entity_name = 'HZ_PARTIES' Then
123:
124: csi_t_gen_utility_pvt.ADD('Party Merge ');
125:
126:
127: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
128: arp_message.set_token('TABLE_NAME', 'CSI_ITEM_INSTANCES', FALSE);

Line 150: csi_t_gen_utility_pvt.ADD('Party site merge');

146: arp_message.set_token('NUM_ROWS', to_char(l_count) );
147:
148: Elsif p_parent_entity_name = 'HZ_PARTY_SITES' Then
149:
150: csi_t_gen_utility_pvt.ADD('Party site merge');
151:
152: /* insert record into transaction table */
153: v_no_of_rows := 0;
154:

Line 165: csi_t_gen_utility_pvt.ADD('Invalid Transaction Type.');

161: WHERE source_transaction_type = v_source_transaction_type;
162: Exception
163: when no_data_found then
164: v_txn_type_not_found_msg := 'Invalid Transaction Type.';
165: csi_t_gen_utility_pvt.ADD('Invalid Transaction Type.');
166: raise txn_type_not_found_error;
167: End;
168:
169: SELECT transaction_id

Line 178: csi_t_gen_utility_pvt.ADD('The merge has not interfaced to IB yet.');

174:
175: Exception
176:
177: When no_data_found Then
178: csi_t_gen_utility_pvt.ADD('The merge has not interfaced to IB yet.');
179: Begin
180:
181: Begin
182:

Line 189: csi_t_gen_utility_pvt.ADD('Insert record to csi_transactions');

185: FROM dual;
186:
187: End;
188:
189: csi_t_gen_utility_pvt.ADD('Insert record to csi_transactions');
190:
191: INSERT INTO csi_transactions(
192: transaction_id
193: ,transaction_date

Line 224: csi_t_gen_utility_pvt.ADD('Insert record to history.');

220: End;
221:
222: /* insert record into history table */
223:
224: csi_t_gen_utility_pvt.ADD('Insert record to history.');
225:
226: BEGIN
227: INSERT INTO CSI_ITEM_INSTANCES_H
228: (

Line 273: csi_t_gen_utility_pvt.ADD('Done with the insert of item instance history ');

269: arp_message.set_token('NUM_ROWS',to_char(v_no_of_rows));
270: v_error_message := 'Done with the insert of item instance history';
271: arp_message.set_line(v_error_message);
272:
273: csi_t_gen_utility_pvt.ADD('Done with the insert of item instance history ');
274: csi_t_gen_utility_pvt.ADD('Num of history row updated: '||v_no_of_rows);
275:
276: EXCEPTION
277: WHEN DUP_VAL_ON_INDEX THEN

Line 274: csi_t_gen_utility_pvt.ADD('Num of history row updated: '||v_no_of_rows);

270: v_error_message := 'Done with the insert of item instance history';
271: arp_message.set_line(v_error_message);
272:
273: csi_t_gen_utility_pvt.ADD('Done with the insert of item instance history ');
274: csi_t_gen_utility_pvt.ADD('Num of history row updated: '||v_no_of_rows);
275:
276: EXCEPTION
277: WHEN DUP_VAL_ON_INDEX THEN
278: BEGIN

Line 334: csi_t_gen_utility_pvt.ADD('Num of instance row updated: '||v_no_of_rows);

330:
331: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
332: arp_message.set_token('NUM_ROWS', to_char(l_count) );
333:
334: csi_t_gen_utility_pvt.ADD('Num of instance row updated: '||v_no_of_rows);
335:
336:
337: End If;
338:

Line 403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');

399: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
400: BEGIN
401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: begin

Line 471: csi_t_gen_utility_pvt.ADD('Party merge is not interfaced to IB yet');

467: AND transaction_type_id = v_transaction_type_id;
468: Exception
469: When no_data_found Then
470:
471: csi_t_gen_utility_pvt.ADD('Party merge is not interfaced to IB yet');
472:
473: Begin
474: Begin
475: SELECT CSI_TRANSACTIONS_S.nextval

Line 554: csi_t_gen_utility_pvt.ADD('Party history row updated'|| v_no_of_rows);

550: arp_message.set_token('NUM_ROWS',to_char(v_no_of_rows));
551: v_error_message := 'Done with the insert of party history';
552: arp_message.set_line(v_error_message);
553:
554: csi_t_gen_utility_pvt.ADD('Party history row updated'|| v_no_of_rows);
555:
556: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
557: arp_message.set_token('TABLE_NAME', 'CSI_I_PARTIES', FALSE);
558:

Line 574: csi_t_gen_utility_pvt.ADD('Party row updated'||l_count);

570: and party_source_table = v_party_source_table;
571:
572: l_count := sql%rowcount;
573:
574: csi_t_gen_utility_pvt.ADD('Party row updated'||l_count);
575:
576: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
577: arp_message.set_token('NUM_ROWS', to_char(l_count) );
578: