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

Line 269: csi_t_gen_utility_pvt.g_debug_level := 10;

265: l_is_vetoed VARCHAR2(1);
266:
267: BEGIN -- {1
268:
269: csi_t_gen_utility_pvt.g_debug_level := 10;
270: csi_t_gen_utility_pvt.build_file_name(
271: p_file_segment1 => 'csictmgr',
272: p_file_segment2 => to_char(sysdate, 'mmddyy'));
273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');

Line 270: csi_t_gen_utility_pvt.build_file_name(

266:
267: BEGIN -- {1
268:
269: csi_t_gen_utility_pvt.g_debug_level := 10;
270: csi_t_gen_utility_pvt.build_file_name(
271: p_file_segment1 => 'csictmgr',
272: p_file_segment2 => to_char(sysdate, 'mmddyy'));
273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');
274: error_str := '001';

Line 273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');

269: csi_t_gen_utility_pvt.g_debug_level := 10;
270: csi_t_gen_utility_pvt.build_file_name(
271: p_file_segment1 => 'csictmgr',
272: p_file_segment2 => to_char(sysdate, 'mmddyy'));
273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');
274: error_str := '001';
275: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');
276:
277: IF (process_mode = 'LOCK') THEN -- {2

Line 279: csi_t_gen_utility_pvt.add('Locking the csi_ip_accounts table');

275: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');
276:
277: IF (process_mode = 'LOCK') THEN -- {2
278:
279: csi_t_gen_utility_pvt.add('Locking the csi_ip_accounts table');
280: error_str := '002';
281: write_to_cr_log( 'Locking the csi_ip_accounts table' );
282:
283: arp_message.set_name('AR','AR_LOCKING_TABLE');

Line 293: csi_t_gen_utility_pvt.add('CSI: Processing');

289: write_to_cr_log( 'Done Locking the csi_ip_accounts table' );
290:
291: ELSE -- } 2 {
292:
293: csi_t_gen_utility_pvt.add('CSI: Processing');
294: l_msg_string := 'CSI:Processing';
295: write_to_cr_log( l_msg_string );
296:
297: error_str := '003';

Line 316: csi_t_gen_utility_pvt.add('Inside merge records cursor');

312: -- Process merge records
313: OPEN merged_records;
314: LOOP -- { 3
315:
316: csi_t_gen_utility_pvt.add('Inside merge records cursor');
317: l_msg_string := 'CSI:merged_records cursor...';
318: write_to_cr_log( l_msg_string );
319: -- Fetch all the eligible merge records
320: FETCH merged_records BULK COLLECT INTO

Line 359: csi_t_gen_utility_pvt.add('MERGE_HEADER_ID_LIST : '||MERGE_HEADER_ID_LIST(I));

355: NUM_COL6_ORIG_LIST(I):= NULL;
356: NUM_COL6_NEW_LIST(I):= NULL;
357:
358: BEGIN
359: csi_t_gen_utility_pvt.add('MERGE_HEADER_ID_LIST : '||MERGE_HEADER_ID_LIST(I));
360: SELECT CUSTOMER_SITE_ID INTO l_install_customer_site_id
361: FROM RA_CUSTOMER_MERGES
362: WHERE CUSTOMER_MERGE_HEADER_ID=MERGE_HEADER_ID_LIST(I)
363: AND CUSTOMER_SITE_CODE='INSTALL_AT'

Line 365: csi_t_gen_utility_pvt.add('l_install_customer_site_id : '||l_install_customer_site_id);

361: FROM RA_CUSTOMER_MERGES
362: WHERE CUSTOMER_MERGE_HEADER_ID=MERGE_HEADER_ID_LIST(I)
363: AND CUSTOMER_SITE_CODE='INSTALL_AT'
364: AND NVL(org_id,-9999)=ORG_ID_LIST(I);
365: csi_t_gen_utility_pvt.add('l_install_customer_site_id : '||l_install_customer_site_id);
366:
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: l_install_customer_site_id:= null;

Line 370: csi_t_gen_utility_pvt.add('l_install_customer_site_id is null ');

366:
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: l_install_customer_site_id:= null;
370: csi_t_gen_utility_pvt.add('l_install_customer_site_id is null ');
371: END;
372:
373: IF l_install_customer_site_id IS NOT NULL THEN
374:

Line 378: csi_t_gen_utility_pvt.add('INSTANCE_ID_LIST : '||INSTANCE_ID_LIST(I));

374:
375: INSTALL_CUSTOMER_SITE_ID_LIST(I):= HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(l_install_customer_site_id);
376:
377: --Added for Bug 6978155(FP for bug 6839035)
378: csi_t_gen_utility_pvt.add('INSTANCE_ID_LIST : '||INSTANCE_ID_LIST(I));
379: SELECT INSTALL_LOCATION_TYPE_CODE,INSTALL_LOCATION_ID,LOCATION_TYPE_CODE,LOCATION_ID
380: INTO l_install_location_type_code,NUM_COL5_ORIG_LIST(I),l_location_type_code,NUM_COL4_ORIG_LIST(I)
381: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);
382:

Line 387: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST - ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));

383: IF NUM_COL5_ORIG_LIST(I) IS NOT NULL THEN
384:
385: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN
386:
387: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST - ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));
388:
389: SELECT CUST_ACCT_SITE_ID
390: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
391: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);

Line 392: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST - ' || NUM_COL6_NEW_LIST(I));

388:
389: SELECT CUST_ACCT_SITE_ID
390: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
391: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
392: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST - ' || NUM_COL6_NEW_LIST(I));
393: SELECT PARTY_SITE_ID INTO NUM_COL5_NEW_LIST(I)
394: FROM HZ_CUST_ACCT_SITES_ALL
395: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
396:

Line 402: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST - ' || NUM_COL5_NEW_LIST(I));

398:
399: NUM_COL4_NEW_LIST(I):= NUM_COL5_NEW_LIST(I);
400:
401: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
402: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST - ' || NUM_COL5_NEW_LIST(I));
403: SELECT LOCATION_ID INTO NUM_COL4_NEW_LIST(I)
404: FROM HZ_PARTY_SITES
405: WHERE PARTY_SITE_ID = NUM_COL5_NEW_LIST(I);
406:

Line 411: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST 2- ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));

407: END IF;
408:
409: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN
410:
411: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST 2- ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));
412: SELECT CUST_ACCT_SITE_ID
413: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
414: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
415:

Line 416: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST(I) : ' || NUM_COL6_NEW_LIST(I));

412: SELECT CUST_ACCT_SITE_ID
413: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
414: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
415:
416: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST(I) : ' || NUM_COL6_NEW_LIST(I));
417: SELECT PARTY_SITE_ID INTO l_party_site_id
418: FROM HZ_CUST_ACCT_SITES_ALL
419: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
420:

Line 421: csi_t_gen_utility_pvt.add('Party Site Id : ' || l_party_site_id);

417: SELECT PARTY_SITE_ID INTO l_party_site_id
418: FROM HZ_CUST_ACCT_SITES_ALL
419: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
420:
421: csi_t_gen_utility_pvt.add('Party Site Id : ' || l_party_site_id);
422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);
423: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
424:
425: NUM_COL4_NEW_LIST(I):= l_party_site_id;

Line 422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);

418: FROM HZ_CUST_ACCT_SITES_ALL
419: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
420:
421: csi_t_gen_utility_pvt.add('Party Site Id : ' || l_party_site_id);
422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);
423: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
424:
425: NUM_COL4_NEW_LIST(I):= l_party_site_id;
426: csi_t_gen_utility_pvt.add('l_party_site_id 2 : ' || l_party_site_id);

Line 426: csi_t_gen_utility_pvt.add('l_party_site_id 2 : ' || l_party_site_id);

422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);
423: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
424:
425: NUM_COL4_NEW_LIST(I):= l_party_site_id;
426: csi_t_gen_utility_pvt.add('l_party_site_id 2 : ' || l_party_site_id);
427: SELECT LOCATION_ID INTO NUM_COL5_NEW_LIST(I)
428: FROM HZ_PARTY_SITES
429: WHERE PARTY_SITE_ID = l_party_site_id;
430:

Line 432: csi_t_gen_utility_pvt.add('l_party_site_id 3 : ' || l_party_site_id);

428: FROM HZ_PARTY_SITES
429: WHERE PARTY_SITE_ID = l_party_site_id;
430:
431: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
432: csi_t_gen_utility_pvt.add('l_party_site_id 3 : ' || l_party_site_id);
433: SELECT LOCATION_ID,LOCATION_ID
434: INTO NUM_COL5_NEW_LIST(I), NUM_COL4_NEW_LIST(I)
435: FROM HZ_PARTY_SITES
436: WHERE PARTY_SITE_ID = l_party_site_id;

Line 439: csi_t_gen_utility_pvt.add('NUM_COL4_NEW_LIST : ' || NUM_COL4_NEW_LIST(I));

435: FROM HZ_PARTY_SITES
436: WHERE PARTY_SITE_ID = l_party_site_id;
437:
438: END IF;
439: csi_t_gen_utility_pvt.add('NUM_COL4_NEW_LIST : ' || NUM_COL4_NEW_LIST(I));
440: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST : ' || NUM_COL5_NEW_LIST(I));
441:
442: END IF;
443: END IF;

Line 440: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST : ' || NUM_COL5_NEW_LIST(I));

436: WHERE PARTY_SITE_ID = l_party_site_id;
437:
438: END IF;
439: csi_t_gen_utility_pvt.add('NUM_COL4_NEW_LIST : ' || NUM_COL4_NEW_LIST(I));
440: csi_t_gen_utility_pvt.add('NUM_COL5_NEW_LIST : ' || NUM_COL5_NEW_LIST(I));
441:
442: END IF;
443: END IF;
444:

Line 453: csi_t_gen_utility_pvt.add(i || '.new1 new2 new3 : '||

449: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||
450: to_char(NUM_COL2_NEW_LIST(I)) || '<>' ||
451: to_char(NUM_COL3_NEW_LIST(I)) );
452:
453: csi_t_gen_utility_pvt.add(i || '.new1 new2 new3 : '||
454: to_char(NUM_COL1_NEW_LIST(I)) || '<>' ||
455: to_char(NUM_COL2_NEW_LIST(I)) || '<>' ||
456: to_char(NUM_COL3_NEW_LIST(I)) );
457: END LOOP; -- } 6

Line 509: csi_t_gen_utility_pvt.add('build the transaction record, if this is the first time');

505: hz_utility_pub.LAST_UPDATED_BY
506: );
507: END IF; -- } 7
508:
509: csi_t_gen_utility_pvt.add('build the transaction record, if this is the first time');
510: -- build the transaction record, if this is the first time
511: IF nvl(p_txn_rec.transaction_id, fnd_api.g_miss_num) = fnd_api.g_miss_num Then -- { 8
512: --
513: -- Check if there is a transaction record created by any other csi routine

Line 517: csi_t_gen_utility_pvt.add('set_num-'||set_num);

513: -- Check if there is a transaction record created by any other csi routine
514: -- If so use that id otherwise initialize the txn_rec attributes
515: --
516: BEGIN
517: csi_t_gen_utility_pvt.add('set_num-'||set_num);
518: csi_t_gen_utility_pvt.add('req_id-'||req_id);
519: SELECT transaction_id
520: INTO v_transaction_id
521: FROM csi_transactions

Line 518: csi_t_gen_utility_pvt.add('req_id-'||req_id);

514: -- If so use that id otherwise initialize the txn_rec attributes
515: --
516: BEGIN
517: csi_t_gen_utility_pvt.add('set_num-'||set_num);
518: csi_t_gen_utility_pvt.add('req_id-'||req_id);
519: SELECT transaction_id
520: INTO v_transaction_id
521: FROM csi_transactions
522: WHERE source_line_ref_id = req_id

Line 529: csi_t_gen_utility_pvt.add('v_source_transaction_type2-'||v_source_transaction_type);

525: p_txn_rec.transaction_id := v_transaction_id;
526:
527: EXCEPTION
528: WHEN no_data_found THEN
529: csi_t_gen_utility_pvt.add('v_source_transaction_type2-'||v_source_transaction_type);
530: error_str := '006';
531: SELECT transaction_type_id
532: INTO v_transaction_type_id
533: FROM csi_txn_types

Line 547: csi_t_gen_utility_pvt.add('processing next record from the cursor');

543:
544: END IF; -- } 8
545:
546: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP -- {
547: csi_t_gen_utility_pvt.add('processing next record from the cursor');
548: l_msg_string := 'CSI:------->processing next record from the cursor...';
549: write_to_cr_log( l_msg_string );
550: -- Get the account_id from csi_ip_accounts
551: error_str := '008';

Line 627: csi_t_gen_utility_pvt.add('Party and Account - ' || l_msg_string);

623: to_char( l_g_ph_tbl.count ) || ' : ' ||
624: to_char( l_g_pah_tbl.count ) ;
625: write_to_cr_log( l_msg_string );
626:
627: csi_t_gen_utility_pvt.add('Party and Account - ' || l_msg_string);
628: -- Get the to_party_id
629: error_str := '010';
630: SELECT party_id
631: INTO l_to_party_id

Line 635: csi_t_gen_utility_pvt.add('l_to_party_id : ' || l_to_party_id);

631: INTO l_to_party_id
632: FROM hz_cust_accounts
633: WHERE cust_account_id = NUM_COL1_NEW_LIST(I);
634:
635: csi_t_gen_utility_pvt.add('l_to_party_id : ' || l_to_party_id);
636: -- process the instance party account records
637: error_str := '011';
638:
639: l_pty_idx := 0;

Line 710: csi_t_gen_utility_pvt.add(l_msg_string);

706: l_pty_with_diff_accts || ' : '||
707: l_address_only_upd || ' : '||
708: l_owner_update ;
709: write_to_cr_log( l_msg_string );
710: csi_t_gen_utility_pvt.add(l_msg_string);
711:
712: error_str := '014';
713: IF l_address_only_upd = 'Y' THEN -- { if address_only_upd is true
714: -- Same Party record

Line 1364: csi_t_gen_utility_pvt.add(l_msg_string);

1360: l_msg_string := 'CSI:Party and Account Records for update call : ' ||
1361: to_char(p_u_party_tbl.count) || ' : ' ||
1362: to_char(p_u_party_account_tbl.count);
1363: write_to_cr_log(l_msg_string);
1364: csi_t_gen_utility_pvt.add(l_msg_string);
1365:
1366: -- Now update the instance with all new data
1367: error_str := '022';
1368: csi_t_gen_utility_pvt.add('Calling csi_item_instance_pub.update_item_instance');

Line 1368: csi_t_gen_utility_pvt.add('Calling csi_item_instance_pub.update_item_instance');

1364: csi_t_gen_utility_pvt.add(l_msg_string);
1365:
1366: -- Now update the instance with all new data
1367: error_str := '022';
1368: csi_t_gen_utility_pvt.add('Calling csi_item_instance_pub.update_item_instance');
1369: csi_item_instance_pub.update_item_instance(
1370: p_api_version => 1.0,
1371: p_commit => fnd_api.g_false,
1372: p_init_msg_list => fnd_api.g_true,

Line 1387: csi_t_gen_utility_pvt.add('return status :'||l_return_status);

1383: x_return_status => l_return_status,
1384: x_msg_count => l_msg_count,
1385: x_msg_data => l_msg_data);
1386: write_to_cr_log( 'return status :'||l_return_status);
1387: csi_t_gen_utility_pvt.add('return status :'||l_return_status);
1388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);
1390: IF l_return_status <> 'S' Then
1391: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));

Line 1443: csi_t_gen_utility_pvt.add('In others :'||l_msg_data||'-'||SQLERRM );

1439: WHEN OTHERS THEN
1440: CLOSE merged_records;
1441: l_msg_data := error_str || '-' || l_msg_data;
1442: arp_message.set_error('CRM_MERGE.CUSTOMER_PRODUCTS_MERGE', l_msg_data);
1443: csi_t_gen_utility_pvt.add('In others :'||l_msg_data||'-'||SQLERRM );
1444: RAISE;
1445: END csi_ip_accounts_merge; -- } 1
1446:
1447: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,