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_CUST_PLANS

Line 9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,

5: -- Purpose : Merges duplicate parties in Customer Care tables. The
6: -- Customer Care table that need to be considered for
7: -- Party Merge are:
8: -- CSC_CUSTOMERS, CSC_CUSTOMERS_AUDIT_HIST,
9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,
10: -- CSC_CUST_PLANS_AUDIT
11: --
12: -- History
13: -- MM-DD-YYYY NAME MODIFICATIONS

Line 10: -- CSC_CUST_PLANS_AUDIT

6: -- Customer Care table that need to be considered for
7: -- Party Merge are:
8: -- CSC_CUSTOMERS, CSC_CUSTOMERS_AUDIT_HIST,
9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,
10: -- CSC_CUST_PLANS_AUDIT
11: --
12: -- History
13: -- MM-DD-YYYY NAME MODIFICATIONS
14: -- 10-10-2000 dejoseph Created.

Line 313: PROCEDURE CSC_CUST_PLANS_MERGE (

309:
310: END CSC_CUSTOMERS_MERGE;
311:
312:
313: PROCEDURE CSC_CUST_PLANS_MERGE (
314: p_entity_name IN VARCHAR2,
315: p_from_id IN NUMBER,
316: x_to_id OUT NOCOPY NUMBER,
317: p_from_fk_id IN NUMBER,

Line 327: from csc_cust_plans

323: IS
324:
325: cursor c1 is
326: select 1
327: from csc_cust_plans
328: where party_id = p_from_fk_id
329: for update nowait;
330:
331: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';

Line 336: l_api_name VARCHAR2(30) := 'CSC_CUST_PLANS_MERGE';

332: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvmpts.pls';
333: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
334: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.CONC_LOGIN_ID;
335:
336: l_api_name VARCHAR2(30) := 'CSC_CUST_PLANS_MERGE';
337: l_count NUMBER(10) := 0;
338: audit_count NUMBER(10) := 0;
339:
340: RESOURCE_BUSY EXCEPTION;

Line 346: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE()+');

342:
343: g_mesg VARCHAR2(1000) := '';
344:
345: BEGIN
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;

Line 347: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE';

343: g_mesg VARCHAR2(1000) := '';
344:
345: BEGIN
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:

Line 392: insert into csc_cust_plans_audit (

388: -- parties
389: -- Bug# 2919377, if plan is transfered then one record will be inserted for
390: -- p_to_fk_id with status transferred, one record will be inserted for
391: -- p_from_fk_id with status merged.Update the Audit table first in case of plan transfer.
392: insert into csc_cust_plans_audit (
393: plan_audit_id, plan_id, party_id, cust_account_id,
394: plan_status_code, request_id, creation_date,
395: created_by, last_update_date, last_updated_by,
396: last_update_login, program_application_id,

Line 399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,

395: created_by, last_update_date, last_updated_by,
396: last_update_login, program_application_id,
397: program_id, program_update_date, object_version_number )
398: select
399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
400: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
401: G_USER_ID, SYSDATE, G_USER_ID,
402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 404: from csc_cust_plans

400: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
401: G_USER_ID, SYSDATE, G_USER_ID,
402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
404: from csc_cust_plans
405: where party_id = p_from_fk_id
406: and cust_account_id is not null;
407: audit_count := sql%rowcount;
408:

Line 409: insert into csc_cust_plans_audit (

405: where party_id = p_from_fk_id
406: and cust_account_id is not null;
407: audit_count := sql%rowcount;
408:
409: insert into csc_cust_plans_audit (
410: plan_audit_id, plan_id, party_id, cust_account_id,
411: plan_status_code, request_id, creation_date,
412: created_by, last_update_date, last_updated_by,
413: last_update_login, program_application_id,

Line 416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,

412: created_by, last_update_date, last_updated_by,
413: last_update_login, program_application_id,
414: program_id, program_update_date, object_version_number )
415: select
416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
417: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
418: G_USER_ID, SYSDATE, G_USER_ID,
419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 421: from csc_cust_plans

417: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
418: G_USER_ID, SYSDATE, G_USER_ID,
419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
421: from csc_cust_plans
422: where party_id = p_from_fk_id and cust_account_id is null
423: and plan_id not in ( select plan_id
424: from csc_cust_plans
425: where party_id = p_to_fk_id );

Line 424: from csc_cust_plans

420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
421: from csc_cust_plans
422: where party_id = p_from_fk_id and cust_account_id is null
423: and plan_id not in ( select plan_id
424: from csc_cust_plans
425: where party_id = p_to_fk_id );
426: audit_count := audit_count+sql%rowcount;
427:
428: insert into csc_cust_plans_audit (

Line 428: insert into csc_cust_plans_audit (

424: from csc_cust_plans
425: where party_id = p_to_fk_id );
426: audit_count := audit_count+sql%rowcount;
427:
428: insert into csc_cust_plans_audit (
429: plan_audit_id, plan_id, party_id, cust_account_id,
430: plan_status_code, request_id, creation_date,
431: created_by, last_update_date, last_updated_by,
432: last_update_login, program_application_id,

Line 435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,

431: created_by, last_update_date, last_updated_by,
432: last_update_login, program_application_id,
433: program_id, program_update_date, object_version_number )
434: select
435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
436: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
437: G_USER_ID, SYSDATE, G_USER_ID,
438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 440: from csc_cust_plans

436: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
437: G_USER_ID, SYSDATE, G_USER_ID,
438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
440: from csc_cust_plans
441: where party_id = p_from_fk_id
442: and cust_account_id is not null;
443: audit_count := audit_count+sql%rowcount;
444:

Line 445: insert into csc_cust_plans_audit (

441: where party_id = p_from_fk_id
442: and cust_account_id is not null;
443: audit_count := audit_count+sql%rowcount;
444:
445: insert into csc_cust_plans_audit (
446: plan_audit_id, plan_id, party_id, cust_account_id,
447: plan_status_code, request_id, creation_date,
448: created_by, last_update_date, last_updated_by,
449: last_update_login, program_application_id,

Line 452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,

448: created_by, last_update_date, last_updated_by,
449: last_update_login, program_application_id,
450: program_id, program_update_date, object_version_number )
451: select
452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
453: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
454: G_USER_ID, SYSDATE, G_USER_ID,
455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 457: from csc_cust_plans

453: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
454: G_USER_ID, SYSDATE, G_USER_ID,
455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
457: from csc_cust_plans
458: where party_id = p_from_fk_id and cust_account_id is null
459: and plan_id not in ( select plan_id
460: from csc_cust_plans
461: where party_id = p_to_fk_id );

Line 460: from csc_cust_plans

456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
457: from csc_cust_plans
458: where party_id = p_from_fk_id and cust_account_id is null
459: and plan_id not in ( select plan_id
460: from csc_cust_plans
461: where party_id = p_to_fk_id );
462: audit_count := audit_count+sql%rowcount;
463:
464: update csc_cust_plans

Line 464: update csc_cust_plans

460: from csc_cust_plans
461: where party_id = p_to_fk_id );
462: audit_count := audit_count+sql%rowcount;
463:
464: update csc_cust_plans
465: set party_id = p_to_fk_id,
466: plan_status_code = G_TRANSFER_PLAN,
467: request_id = G_REQUEST_ID,
468: -- end_date_active = SYSDATE,

Line 480: update csc_cust_plans

476: where party_id = p_from_fk_id
477: and cust_account_id is not null;
478: l_count := sql%rowcount;
479:
480: update csc_cust_plans
481: set party_id = p_to_fk_id,
482: plan_status_code = G_TRANSFER_PLAN,
483: request_id = G_REQUEST_ID,
484: -- end_date_active = SYSDATE,

Line 494: from csc_cust_plans

490: program_update_date = SYSDATE,
491: object_version_number = object_version_number + 1
492: where party_id = p_from_fk_id and cust_account_id is null
493: and plan_id not in ( select plan_id
494: from csc_cust_plans
495: where party_id = p_to_fk_id );
496:
497: l_count := l_count+sql%rowcount;
498:

Line 499: g_mesg := 'Number of CSC_CUST_PLANS records transferred = ' || to_char(l_count) ;

495: where party_id = p_to_fk_id );
496:
497: l_count := l_count+sql%rowcount;
498:
499: g_mesg := 'Number of CSC_CUST_PLANS records transferred = ' || to_char(l_count) ;
500: fnd_file.put_line(fnd_file.log, g_mesg);
501:
502: --arp_message.set_line('Number of CSC_CUST_PLANS records transferred = ' ||
503: --to_char(sql%rowcount) );

Line 502: --arp_message.set_line('Number of CSC_CUST_PLANS records transferred = ' ||

498:
499: g_mesg := 'Number of CSC_CUST_PLANS records transferred = ' || to_char(l_count) ;
500: fnd_file.put_line(fnd_file.log, g_mesg);
501:
502: --arp_message.set_line('Number of CSC_CUST_PLANS records transferred = ' ||
503: --to_char(sql%rowcount) );
504:
505:
506: if ( ( l_count > 0 ) AND (audit_count > 0) ) then

Line 507: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

503: --to_char(sql%rowcount) );
504:
505:
506: if ( ( l_count > 0 ) AND (audit_count > 0) ) then
507: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
508: || 'CSC_CUST_PLANS records transferred = ' || to_char(audit_count) ;
509: fnd_file.put_line(fnd_file.log, g_mesg);
510: end if;
511:

Line 508: || 'CSC_CUST_PLANS records transferred = ' || to_char(audit_count) ;

504:
505:
506: if ( ( l_count > 0 ) AND (audit_count > 0) ) then
507: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
508: || 'CSC_CUST_PLANS records transferred = ' || to_char(audit_count) ;
509: fnd_file.put_line(fnd_file.log, g_mesg);
510: end if;
511:
512: -- if ( l_count > 0 ) then

Line 513: -- insert into csc_cust_plans_audit (

509: fnd_file.put_line(fnd_file.log, g_mesg);
510: end if;
511:
512: -- if ( l_count > 0 ) then
513: -- insert into csc_cust_plans_audit (
514: -- plan_audit_id, plan_id, party_id,
515: -- plan_status_code, request_id, creation_date,
516: -- created_by, last_update_date, last_updated_by,
517: -- last_update_login, program_application_id,

Line 520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,

516: -- created_by, last_update_date, last_updated_by,
517: -- last_update_login, program_application_id,
518: -- program_id, program_update_date, object_version_number )
519: -- select
520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,
521: -- G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
522: -- G_USER_ID, SYSDATE, G_USER_ID,
523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 525: -- from csc_cust_plans

521: -- G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
522: -- G_USER_ID, SYSDATE, G_USER_ID,
523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
525: -- from csc_cust_plans
526: -- where party_id = p_from_fk_id
527: -- and plan_id not in ( select plan_id
528: -- from csc_cust_plans
529: -- where party_id = p_to_fk_id );

Line 528: -- from csc_cust_plans

524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
525: -- from csc_cust_plans
526: -- where party_id = p_from_fk_id
527: -- and plan_id not in ( select plan_id
528: -- from csc_cust_plans
529: -- where party_id = p_to_fk_id );
530:
531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;

Line 531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

527: -- and plan_id not in ( select plan_id
528: -- from csc_cust_plans
529: -- where party_id = p_to_fk_id );
530:
531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

Line 532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;

528: -- from csc_cust_plans
529: -- where party_id = p_to_fk_id );
530:
531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
536: --'coresponding to the CSC_CUST_PLANS records ' ||

Line 535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
536: --'coresponding to the CSC_CUST_PLANS records ' ||
537: --'transferred = ' || to_char(sql%rowcount) );
538:
539: -- end if;

Line 536: --'coresponding to the CSC_CUST_PLANS records ' ||

532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
536: --'coresponding to the CSC_CUST_PLANS records ' ||
537: --'transferred = ' || to_char(sql%rowcount) );
538:
539: -- end if;
540:

Line 543: update csc_cust_plans

539: -- end if;
540:
541: -- Perform merge if duplicate plans exist between the TO and FROM
542: -- parties
543: update csc_cust_plans
544: set plan_status_code = G_MERGE_PLAN,
545: end_date_active = SYSDATE,
546: request_id = G_REQUEST_ID,
547: last_update_date = SYSDATE,

Line 556: from csc_cust_plans

552: program_update_date = SYSDATE,
553: object_version_number = object_version_number + 1
554: where party_id = p_from_fk_id
555: and plan_id in ( select plan_id
556: from csc_cust_plans
557: where party_id = p_to_fk_id );
558:
559: l_count := sql%rowcount;
560:

Line 561: g_mesg := 'Number of CSC_CUST_PLANS records merged = ' || to_char(l_count) ;

557: where party_id = p_to_fk_id );
558:
559: l_count := sql%rowcount;
560:
561: g_mesg := 'Number of CSC_CUST_PLANS records merged = ' || to_char(l_count) ;
562: fnd_file.put_line(fnd_file.log, g_mesg);
563:
564: --arp_message.set_line('Number of CSC_CUST_PLANS records merged = ' ||
565: --to_char(sql%rowcount) );

Line 564: --arp_message.set_line('Number of CSC_CUST_PLANS records merged = ' ||

560:
561: g_mesg := 'Number of CSC_CUST_PLANS records merged = ' || to_char(l_count) ;
562: fnd_file.put_line(fnd_file.log, g_mesg);
563:
564: --arp_message.set_line('Number of CSC_CUST_PLANS records merged = ' ||
565: --to_char(sql%rowcount) );
566:
567: -- Bug# 2919377, insert a record for FROM party with MERGE flag
568: if ( sql%rowcount > 0 ) then

Line 569: insert into csc_cust_plans_audit (

565: --to_char(sql%rowcount) );
566:
567: -- Bug# 2919377, insert a record for FROM party with MERGE flag
568: if ( sql%rowcount > 0 ) then
569: insert into csc_cust_plans_audit (
570: plan_audit_id, plan_id, party_id,
571: plan_status_code, request_id, creation_date,
572: created_by, last_update_date, last_updated_by,
573: last_update_login, program_application_id,

Line 576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,

572: created_by, last_update_date, last_updated_by,
573: last_update_login, program_application_id,
574: program_id, program_update_date, object_version_number )
575: select
576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,
577: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
578: G_USER_ID, SYSDATE, G_USER_ID,
579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 581: from csc_cust_plans

577: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
578: G_USER_ID, SYSDATE, G_USER_ID,
579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
581: from csc_cust_plans
582: where party_id = p_from_fk_id
583: and plan_id in ( select plan_id
584: from csc_cust_plans
585: where party_id = p_to_fk_id );

Line 584: from csc_cust_plans

580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1
581: from csc_cust_plans
582: where party_id = p_from_fk_id
583: and plan_id in ( select plan_id
584: from csc_cust_plans
585: where party_id = p_to_fk_id );
586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;

Line 587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

583: and plan_id in ( select plan_id
584: from csc_cust_plans
585: where party_id = p_to_fk_id );
586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||

Line 588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;

584: from csc_cust_plans
585: where party_id = p_to_fk_id );
586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||
592: --'merged = ' || to_char(sql%rowcount) );

Line 590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||
592: --'merged = ' || to_char(sql%rowcount) );
593: end if;
594: end if;

Line 591: --'coresponding to the CSC_CUST_PLANS records ' ||

587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||
592: --'merged = ' || to_char(sql%rowcount) );
593: end if;
594: end if;
595:

Line 600: || 'records in table CSC_CUST_PLANS for party_id = ' || p_from_fk_id

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);
603:
604: --arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 606: --'CSC_CUST_PLANS for party_id = ' || p_from_fk_id );

602: fnd_file.put_line(fnd_file.log, g_mesg);
603:
604: --arp_message.set_line(g_proc_name || '.' || l_api_name ||
605: --'; Could not obtain lock for records in table ' ||
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;

Line 617: END CSC_CUST_PLANS_MERGE;

613:
614: --arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
615: raise;
616:
617: END CSC_CUST_PLANS_MERGE;
618:
619:
620: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
621: p_entity_name IN VARCHAR2,