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.CSC_PARTY_MERGE_PKG dependencies on CSC_CORE_UTILS_PVT

Line 38: G_MERGE_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.MERGE_PLAN;

34: -- End of Comments
35: -- GLOBAL VARIABLE TO STORE REQUEST_ID and MERGE_REASON_CODE OF CURRENT MERGE BATCH
36: G_REQUEST_ID NUMBER(15) := TO_NUMBER(NULL);
37: G_MERGE_REASON_CODE VARCHAR2(30) := NULL;
38: G_MERGE_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.MERGE_PLAN;
39: G_TRANSFER_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.TRANSFER_PLAN;
40:
41: PROCEDURE get_hz_merge_batch (
42: p_batch_id IN NUMBER )

Line 39: G_TRANSFER_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.TRANSFER_PLAN;

35: -- GLOBAL VARIABLE TO STORE REQUEST_ID and MERGE_REASON_CODE OF CURRENT MERGE BATCH
36: G_REQUEST_ID NUMBER(15) := TO_NUMBER(NULL);
37: G_MERGE_REASON_CODE VARCHAR2(30) := NULL;
38: G_MERGE_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.MERGE_PLAN;
39: G_TRANSFER_PLAN VARCHAR2(10) := CSC_CORE_UTILS_PVT.TRANSFER_PLAN;
40:
41: PROCEDURE get_hz_merge_batch (
42: p_batch_id IN NUMBER )
43: IS

Line 115: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;

111:
112: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMERS_MERGE';
113: fnd_file.put_line(fnd_file.log, g_mesg);
114:
115: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
116:
117: if (g_merge_reason_code is null) then
118: get_hz_merge_batch(
119: p_batch_id => p_batch_id);

Line 277: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;

273: p_program_update_date => SYSDATE );
274:
275: exception
276: when resource_busy then
277: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
278: g_mesg := 'Could not obtain lock for records in table CSC_CUSTOMERS. Please '
279: || 'retry the Merge operation later.';
280: fnd_file.put_line(fnd_file.log, g_mesg);
281: --arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 287: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;

283: --'CSC_CUSTOMERS for party_id = ' || p_from_fk_id );
284: raise;
285:
286: when others then
287: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
288: g_mesg := substr(g_proc_name || '.' || l_api_name || ' : ' || sqlerrm,1,1000);
289: fnd_file.put_line(fnd_file.log, g_mesg);
290: --arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
291: raise;

Line 296: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;

292: end;
293: end if;
294: /***
295: ELSE
296: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
297: g_mesg := 'Merge not allowed. Please check criticality of merging parties';
298: fnd_file.put_line(fnd_file.log, g_mesg);
299: --arp_message.set_line(g_proc_name || '.' || l_api_name ||
300: --'; Merge not allowed. Please check criticality of merging parties');

Line 350: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;

346: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE()+');
347: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE';
348: fnd_file.put_line(fnd_file.log, g_mesg);
349:
350: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
351:
352: if (g_merge_reason_code is null) then
353: get_hz_merge_batch(
354: p_batch_id => p_batch_id);

Line 598: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;

594: end if;
595:
596: EXCEPTION
597: when RESOURCE_BUSY then
598: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
599: g_mesg := substr(g_proc_name || '.' || l_api_name || '; Could not obtain lock for '
600: || 'records in table CSC_CUST_PLANS for party_id = ' || p_from_fk_id
601: || sqlerrm, 1, 1000);
602: fnd_file.put_line(fnd_file.log, g_mesg);

Line 610: --x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_UNEXP_ERROR;

606: --'CSC_CUST_PLANS for party_id = ' || p_from_fk_id );
607: raise;
608:
609: when OTHERS then
610: --x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_UNEXP_ERROR;
611: g_mesg := substr(g_proc_name || '.' || l_api_name || ': ' || sqlerrm,1,1000);
612: fnd_file.put_line(fnd_file.log, g_mesg);
613:
614: --arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 656: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;

652: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE()+');
653: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE';
654: fnd_file.put_line(fnd_file.log, g_mesg);
655:
656: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
657:
658: if (g_merge_reason_code is null) then
659: get_hz_merge_batch(
660: p_batch_id => p_batch_id);

Line 742: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;

738: end if;
739:
740: EXCEPTION
741: when RESOURCE_BUSY then
742: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
743: g_mesg := g_proc_name || '.' || l_api_name || '; Could not obtain lock for '
744: || 'records in table CSC_CUSTOMIZED_PLANS for party_id = '
745: || p_from_fk_id;
746: fnd_file.put_line(fnd_file.log, g_mesg);

Line 754: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_UNEXP_ERROR;

750: --'CSC_CUSTOMIZED_PLANS for party_id = ' || p_from_fk_id );
751: raise;
752:
753: when OTHERS then
754: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_UNEXP_ERROR;
755: g_mesg := substr( g_proc_name || '.' || l_api_name || ': ' || sqlerrm, 1, 1000 );
756: fnd_file.put_line(fnd_file.log, g_mesg);
757: -- arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
758: raise;