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_PLAN_ASSIGNMENT_PKG dependencies on FND_FILE

Line 327: fnd_file.put_line(fnd_file.log, g_mesg);

323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: g_mesg := sqlcode || ' ' || sqlerrm;
327: fnd_file.put_line(fnd_file.log, g_mesg);
328: G_ERRBUF := g_mesg;
329:
330: END RUN_PLAN_ENGINE;
331:

Line 390: fnd_file.put_line(fnd_file.log, g_mesg_line);

386: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
387: 'Please enter a valid set of parameters.';
388: G_ERRBUF := g_mesg;
389: g_mesg_line := 'Causes:';
390: fnd_file.put_line(fnd_file.log, g_mesg_line);
391: g_mesg := g_mesg || g_mesg_line;
392: g_mesg_line := '- Specified plan is either customized or has expired.';
393: fnd_file.put_line(fnd_file.log, g_mesg_line);
394: g_mesg := g_mesg || g_mesg_line;

Line 393: fnd_file.put_line(fnd_file.log, g_mesg_line);

389: g_mesg_line := 'Causes:';
390: fnd_file.put_line(fnd_file.log, g_mesg_line);
391: g_mesg := g_mesg || g_mesg_line;
392: g_mesg_line := '- Specified plan is either customized or has expired.';
393: fnd_file.put_line(fnd_file.log, g_mesg_line);
394: g_mesg := g_mesg || g_mesg_line;
395: g_mesg_line := '- Profile results for the check associated to the specified plan ' ||
396: 'have not been populated.';
397: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 397: fnd_file.put_line(fnd_file.log, g_mesg_line);

393: fnd_file.put_line(fnd_file.log, g_mesg_line);
394: g_mesg := g_mesg || g_mesg_line;
395: g_mesg_line := '- Profile results for the check associated to the specified plan ' ||
396: 'have not been populated.';
397: fnd_file.put_line(fnd_file.log, g_mesg_line);
398: g_mesg := g_mesg || g_mesg_line;
399: g_mesg_line := 'Action';
400: fnd_file.put_line(fnd_file.log, g_mesg_line);
401: g_mesg := g_mesg || g_mesg_line;

Line 400: fnd_file.put_line(fnd_file.log, g_mesg_line);

396: 'have not been populated.';
397: fnd_file.put_line(fnd_file.log, g_mesg_line);
398: g_mesg := g_mesg || g_mesg_line;
399: g_mesg_line := 'Action';
400: fnd_file.put_line(fnd_file.log, g_mesg_line);
401: g_mesg := g_mesg || g_mesg_line;
402: g_mesg_line := '- Specify plans that are not customized and have not expired.';
403: fnd_file.put_line(fnd_file.log, g_mesg_line);
404: g_mesg := g_mesg || g_mesg_line;

Line 403: fnd_file.put_line(fnd_file.log, g_mesg_line);

399: g_mesg_line := 'Action';
400: fnd_file.put_line(fnd_file.log, g_mesg_line);
401: g_mesg := g_mesg || g_mesg_line;
402: g_mesg_line := '- Specify plans that are not customized and have not expired.';
403: fnd_file.put_line(fnd_file.log, g_mesg_line);
404: g_mesg := g_mesg || g_mesg_line;
405: g_mesg_line := '- Run the Profile Engine to populate the results for the check ' ||
406: 'name associated to the specified plan.';
407: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 407: fnd_file.put_line(fnd_file.log, g_mesg_line);

403: fnd_file.put_line(fnd_file.log, g_mesg_line);
404: g_mesg := g_mesg || g_mesg_line;
405: g_mesg_line := '- Run the Profile Engine to populate the results for the check ' ||
406: 'name associated to the specified plan.';
407: fnd_file.put_line(fnd_file.log, g_mesg_line);
408: g_mesg := g_mesg || g_mesg_line;
409: else
410: -- call the procedure to make/break the customer - plan association
411: add_remove_plan_check (

Line 432: fnd_file.put_line(fnd_file.log, g_mesg);

428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: g_mesg := sqlcode || ' ' || sqlerrm;
432: fnd_file.put_line(fnd_file.log, g_mesg);
433: G_ERRBUF := g_mesg;
434:
435: END RUN_WITH_PLAN_ID; -- end for main begin of run_with_plan_id
436:

Line 496: fnd_file.put_line(fnd_file.log, g_mesg_line);

492: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
493: 'Please enter a valid set of parameters.';
494: G_ERRBUF := g_mesg;
495: g_mesg_line := 'Causes:';
496: fnd_file.put_line(fnd_file.log, g_mesg_line);
497: g_mesg := g_mesg || g_mesg_line;
498: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
499: fnd_file.put_line(fnd_file.log, g_mesg_line);
500: g_mesg := g_mesg || g_mesg_line;

Line 499: fnd_file.put_line(fnd_file.log, g_mesg_line);

495: g_mesg_line := 'Causes:';
496: fnd_file.put_line(fnd_file.log, g_mesg_line);
497: g_mesg := g_mesg || g_mesg_line;
498: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
499: fnd_file.put_line(fnd_file.log, g_mesg_line);
500: g_mesg := g_mesg || g_mesg_line;
501: g_mesg_line := '- Profile results for the specified check have not been populated.';
502: fnd_file.put_line(fnd_file.log, g_mesg_line);
503: g_mesg := g_mesg || g_mesg_line;

Line 502: fnd_file.put_line(fnd_file.log, g_mesg_line);

498: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
499: fnd_file.put_line(fnd_file.log, g_mesg_line);
500: g_mesg := g_mesg || g_mesg_line;
501: g_mesg_line := '- Profile results for the specified check have not been populated.';
502: fnd_file.put_line(fnd_file.log, g_mesg_line);
503: g_mesg := g_mesg || g_mesg_line;
504: g_mesg_line := 'Action';
505: fnd_file.put_line(fnd_file.log, g_mesg_line);
506: g_mesg := g_mesg || g_mesg_line;

Line 505: fnd_file.put_line(fnd_file.log, g_mesg_line);

501: g_mesg_line := '- Profile results for the specified check have not been populated.';
502: fnd_file.put_line(fnd_file.log, g_mesg_line);
503: g_mesg := g_mesg || g_mesg_line;
504: g_mesg_line := 'Action';
505: fnd_file.put_line(fnd_file.log, g_mesg_line);
506: g_mesg := g_mesg || g_mesg_line;
507: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
508: fnd_file.put_line(fnd_file.log, g_mesg_line);
509: g_mesg := g_mesg || g_mesg_line;

Line 508: fnd_file.put_line(fnd_file.log, g_mesg_line);

504: g_mesg_line := 'Action';
505: fnd_file.put_line(fnd_file.log, g_mesg_line);
506: g_mesg := g_mesg || g_mesg_line;
507: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
508: fnd_file.put_line(fnd_file.log, g_mesg_line);
509: g_mesg := g_mesg || g_mesg_line;
510: g_mesg_line := '- Run the Profile Engine to populate the results for the specified check.';
511: fnd_file.put_line(fnd_file.log, g_mesg_line);
512: g_mesg := g_mesg || g_mesg_line;

Line 511: fnd_file.put_line(fnd_file.log, g_mesg_line);

507: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
508: fnd_file.put_line(fnd_file.log, g_mesg_line);
509: g_mesg := g_mesg || g_mesg_line;
510: g_mesg_line := '- Run the Profile Engine to populate the results for the specified check.';
511: fnd_file.put_line(fnd_file.log, g_mesg_line);
512: g_mesg := g_mesg || g_mesg_line;
513: else
514: -- call the procedure to make/break the customer - plan association
515: add_remove_plan_check (

Line 536: fnd_file.put_line(fnd_file.log, g_mesg);

532:
533: EXCEPTION
534: WHEN OTHERS THEN
535: g_mesg := sqlcode || ' ' || sqlerrm;
536: fnd_file.put_line(fnd_file.log, g_mesg);
537: G_ERRBUF := g_mesg;
538:
539: END RUN_WITH_CHECK_ID; -- end for main begin of run_with_plan_id
540:

Line 595: fnd_file.put_line(fnd_file.log, g_mesg_line);

591: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
592: 'Please enter a valid set of parameters.';
593: G_ERRBUF := g_mesg;
594: g_mesg_line := 'Causes:';
595: fnd_file.put_line(fnd_file.log, g_mesg_line);
596: g_mesg := g_mesg || g_mesg_line;
597: g_mesg_line := '- All plans have expired.';
598: fnd_file.put_line(fnd_file.log, g_mesg_line);
599: g_mesg := g_mesg || g_mesg_line;

Line 598: fnd_file.put_line(fnd_file.log, g_mesg_line);

594: g_mesg_line := 'Causes:';
595: fnd_file.put_line(fnd_file.log, g_mesg_line);
596: g_mesg := g_mesg || g_mesg_line;
597: g_mesg_line := '- All plans have expired.';
598: fnd_file.put_line(fnd_file.log, g_mesg_line);
599: g_mesg := g_mesg || g_mesg_line;
600: g_mesg_line := '- Profile results for the specified party have not been populated.';
601: fnd_file.put_line(fnd_file.log, g_mesg_line);
602: g_mesg := g_mesg || g_mesg_line;

Line 601: fnd_file.put_line(fnd_file.log, g_mesg_line);

597: g_mesg_line := '- All plans have expired.';
598: fnd_file.put_line(fnd_file.log, g_mesg_line);
599: g_mesg := g_mesg || g_mesg_line;
600: g_mesg_line := '- Profile results for the specified party have not been populated.';
601: fnd_file.put_line(fnd_file.log, g_mesg_line);
602: g_mesg := g_mesg || g_mesg_line;
603: g_mesg_line := 'Action';
604: fnd_file.put_line(fnd_file.log, g_mesg_line);
605: g_mesg := g_mesg || g_mesg_line;

Line 604: fnd_file.put_line(fnd_file.log, g_mesg_line);

600: g_mesg_line := '- Profile results for the specified party have not been populated.';
601: fnd_file.put_line(fnd_file.log, g_mesg_line);
602: g_mesg := g_mesg || g_mesg_line;
603: g_mesg_line := 'Action';
604: fnd_file.put_line(fnd_file.log, g_mesg_line);
605: g_mesg := g_mesg || g_mesg_line;
606: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
607: fnd_file.put_line(fnd_file.log, g_mesg_line);
608: g_mesg := g_mesg || g_mesg_line;

Line 607: fnd_file.put_line(fnd_file.log, g_mesg_line);

603: g_mesg_line := 'Action';
604: fnd_file.put_line(fnd_file.log, g_mesg_line);
605: g_mesg := g_mesg || g_mesg_line;
606: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
607: fnd_file.put_line(fnd_file.log, g_mesg_line);
608: g_mesg := g_mesg || g_mesg_line;
609: g_mesg_line := '- Run the Profile Engine to populate the results for the specified party.';
610: fnd_file.put_line(fnd_file.log, g_mesg_line);
611: g_mesg := g_mesg || g_mesg_line;

Line 610: fnd_file.put_line(fnd_file.log, g_mesg_line);

606: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
607: fnd_file.put_line(fnd_file.log, g_mesg_line);
608: g_mesg := g_mesg || g_mesg_line;
609: g_mesg_line := '- Run the Profile Engine to populate the results for the specified party.';
610: fnd_file.put_line(fnd_file.log, g_mesg_line);
611: g_mesg := g_mesg || g_mesg_line;
612: else
613: -- call the procedure to make/break the customer - plan association
614: add_remove_plan_check (

Line 635: fnd_file.put_line(fnd_file.log, g_mesg);

631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: g_mesg := sqlcode || ' ' || sqlerrm;
635: fnd_file.put_line(fnd_file.log, g_mesg);
636: G_ERRBUF := g_mesg;
637:
638: END RUN_WITH_PARTY_ID;
639:

Line 693: fnd_file.put_line(fnd_file.log, g_mesg_line);

689: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
690: 'Please enter a valid set of parameters.';
691: G_ERRBUF := g_mesg;
692: g_mesg_line := 'Causes:';
693: fnd_file.put_line(fnd_file.log, g_mesg_line);
694: g_mesg := g_mesg || g_mesg_line;
695: g_mesg_line := '- All plans have expired.';
696: fnd_file.put_line(fnd_file.log, g_mesg_line);
697: g_mesg := g_mesg || g_mesg_line;

Line 696: fnd_file.put_line(fnd_file.log, g_mesg_line);

692: g_mesg_line := 'Causes:';
693: fnd_file.put_line(fnd_file.log, g_mesg_line);
694: g_mesg := g_mesg || g_mesg_line;
695: g_mesg_line := '- All plans have expired.';
696: fnd_file.put_line(fnd_file.log, g_mesg_line);
697: g_mesg := g_mesg || g_mesg_line;
698: g_mesg_line := '- Profile results for the specified account have not been populated.';
699: fnd_file.put_line(fnd_file.log, g_mesg_line);
700: g_mesg := g_mesg || g_mesg_line;

Line 699: fnd_file.put_line(fnd_file.log, g_mesg_line);

695: g_mesg_line := '- All plans have expired.';
696: fnd_file.put_line(fnd_file.log, g_mesg_line);
697: g_mesg := g_mesg || g_mesg_line;
698: g_mesg_line := '- Profile results for the specified account have not been populated.';
699: fnd_file.put_line(fnd_file.log, g_mesg_line);
700: g_mesg := g_mesg || g_mesg_line;
701: g_mesg_line := 'Action';
702: fnd_file.put_line(fnd_file.log, g_mesg_line);
703: g_mesg := g_mesg || g_mesg_line;

Line 702: fnd_file.put_line(fnd_file.log, g_mesg_line);

698: g_mesg_line := '- Profile results for the specified account have not been populated.';
699: fnd_file.put_line(fnd_file.log, g_mesg_line);
700: g_mesg := g_mesg || g_mesg_line;
701: g_mesg_line := 'Action';
702: fnd_file.put_line(fnd_file.log, g_mesg_line);
703: g_mesg := g_mesg || g_mesg_line;
704: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
705: fnd_file.put_line(fnd_file.log, g_mesg_line);
706: g_mesg := g_mesg || g_mesg_line;

Line 705: fnd_file.put_line(fnd_file.log, g_mesg_line);

701: g_mesg_line := 'Action';
702: fnd_file.put_line(fnd_file.log, g_mesg_line);
703: g_mesg := g_mesg || g_mesg_line;
704: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
705: fnd_file.put_line(fnd_file.log, g_mesg_line);
706: g_mesg := g_mesg || g_mesg_line;
707: g_mesg_line := '- Run the Profile Engine to populate the results for the specified account.';
708: fnd_file.put_line(fnd_file.log, g_mesg_line);
709: g_mesg := g_mesg || g_mesg_line;

Line 708: fnd_file.put_line(fnd_file.log, g_mesg_line);

704: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
705: fnd_file.put_line(fnd_file.log, g_mesg_line);
706: g_mesg := g_mesg || g_mesg_line;
707: g_mesg_line := '- Run the Profile Engine to populate the results for the specified account.';
708: fnd_file.put_line(fnd_file.log, g_mesg_line);
709: g_mesg := g_mesg || g_mesg_line;
710: else
711: -- call the procedure to make/break the customer - plan association
712: add_remove_plan_check (

Line 734: fnd_file.put_line(fnd_file.log, g_mesg);

730:
731: EXCEPTION
732: WHEN OTHERS THEN
733: g_mesg := sqlcode || ' ' || sqlerrm;
734: fnd_file.put_line(fnd_file.log, g_mesg);
735: G_ERRBUF := g_mesg;
736:
737: END RUN_WITH_ACCOUNT_ID;
738:

Line 798: fnd_file.put_line(fnd_file.log, g_mesg_line);

794: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
795: 'Please enter a valid set of parameters.';
796: G_ERRBUF := g_mesg;
797: g_mesg_line := 'Causes:';
798: fnd_file.put_line(fnd_file.log, g_mesg_line);
799: g_mesg := g_mesg || g_mesg_line;
800: g_mesg_line := '- Specified plan is either customized or has expired.';
801: fnd_file.put_line(fnd_file.log, g_mesg_line);
802: g_mesg := g_mesg || g_mesg_line;

Line 801: fnd_file.put_line(fnd_file.log, g_mesg_line);

797: g_mesg_line := 'Causes:';
798: fnd_file.put_line(fnd_file.log, g_mesg_line);
799: g_mesg := g_mesg || g_mesg_line;
800: g_mesg_line := '- Specified plan is either customized or has expired.';
801: fnd_file.put_line(fnd_file.log, g_mesg_line);
802: g_mesg := g_mesg || g_mesg_line;
803: g_mesg_line := '- Specified plan is an account level plan.';
804: fnd_file.put_line(fnd_file.log, g_mesg_line);
805: g_mesg := g_mesg || g_mesg_line;

Line 804: fnd_file.put_line(fnd_file.log, g_mesg_line);

800: g_mesg_line := '- Specified plan is either customized or has expired.';
801: fnd_file.put_line(fnd_file.log, g_mesg_line);
802: g_mesg := g_mesg || g_mesg_line;
803: g_mesg_line := '- Specified plan is an account level plan.';
804: fnd_file.put_line(fnd_file.log, g_mesg_line);
805: g_mesg := g_mesg || g_mesg_line;
806: g_mesg_line := '- Profile results for the specified party and/or check of the ' ||
807: 'specified plan have not been populated.';
808: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 808: fnd_file.put_line(fnd_file.log, g_mesg_line);

804: fnd_file.put_line(fnd_file.log, g_mesg_line);
805: g_mesg := g_mesg || g_mesg_line;
806: g_mesg_line := '- Profile results for the specified party and/or check of the ' ||
807: 'specified plan have not been populated.';
808: fnd_file.put_line(fnd_file.log, g_mesg_line);
809: g_mesg := g_mesg || g_mesg_line;
810: g_mesg_line := 'Action';
811: fnd_file.put_line(fnd_file.log, g_mesg_line);
812: g_mesg := g_mesg || g_mesg_line;

Line 811: fnd_file.put_line(fnd_file.log, g_mesg_line);

807: 'specified plan have not been populated.';
808: fnd_file.put_line(fnd_file.log, g_mesg_line);
809: g_mesg := g_mesg || g_mesg_line;
810: g_mesg_line := 'Action';
811: fnd_file.put_line(fnd_file.log, g_mesg_line);
812: g_mesg := g_mesg || g_mesg_line;
813: g_mesg_line := '- Specify plans that are not customized and have not expired.';
814: fnd_file.put_line(fnd_file.log, g_mesg_line);
815: g_mesg := g_mesg || g_mesg_line;

Line 814: fnd_file.put_line(fnd_file.log, g_mesg_line);

810: g_mesg_line := 'Action';
811: fnd_file.put_line(fnd_file.log, g_mesg_line);
812: g_mesg := g_mesg || g_mesg_line;
813: g_mesg_line := '- Specify plans that are not customized and have not expired.';
814: fnd_file.put_line(fnd_file.log, g_mesg_line);
815: g_mesg := g_mesg || g_mesg_line;
816: g_mesg_line := '- Specify plans that are not account level plans when specifing a party together.';
817: fnd_file.put_line(fnd_file.log, g_mesg_line);
818: g_mesg := g_mesg || g_mesg_line;

Line 817: fnd_file.put_line(fnd_file.log, g_mesg_line);

813: g_mesg_line := '- Specify plans that are not customized and have not expired.';
814: fnd_file.put_line(fnd_file.log, g_mesg_line);
815: g_mesg := g_mesg || g_mesg_line;
816: g_mesg_line := '- Specify plans that are not account level plans when specifing a party together.';
817: fnd_file.put_line(fnd_file.log, g_mesg_line);
818: g_mesg := g_mesg || g_mesg_line;
819: g_mesg_line := '- Run the Profile Engine to populate the results for the specified ' ||
820: 'party and/or check of the specified plan.';
821: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 821: fnd_file.put_line(fnd_file.log, g_mesg_line);

817: fnd_file.put_line(fnd_file.log, g_mesg_line);
818: g_mesg := g_mesg || g_mesg_line;
819: g_mesg_line := '- Run the Profile Engine to populate the results for the specified ' ||
820: 'party and/or check of the specified plan.';
821: fnd_file.put_line(fnd_file.log, g_mesg_line);
822: g_mesg := g_mesg || g_mesg_line;
823: else
824: -- call the procedure to make/break the customer - plan association
825: add_remove_plan_check (

Line 846: fnd_file.put_line(fnd_file.log, g_mesg);

842:
843: EXCEPTION
844: WHEN OTHERS THEN
845: g_mesg := sqlcode || ' ' || sqlerrm;
846: fnd_file.put_line(fnd_file.log, g_mesg);
847: G_ERRBUF := g_mesg;
848:
849: END RUN_WITH_PLAN_PARTY;
850:

Line 908: fnd_file.put_line(fnd_file.log, g_mesg_line);

904: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
905: 'Please enter a valid set of parameters.';
906: G_ERRBUF := g_mesg;
907: g_mesg_line := 'Causes:';
908: fnd_file.put_line(fnd_file.log, g_mesg_line);
909: g_mesg := g_mesg || g_mesg_line;
910: g_mesg_line := '- Specified plan is either customized or has expired.';
911: fnd_file.put_line(fnd_file.log, g_mesg_line);
912: g_mesg := g_mesg || g_mesg_line;

Line 911: fnd_file.put_line(fnd_file.log, g_mesg_line);

907: g_mesg_line := 'Causes:';
908: fnd_file.put_line(fnd_file.log, g_mesg_line);
909: g_mesg := g_mesg || g_mesg_line;
910: g_mesg_line := '- Specified plan is either customized or has expired.';
911: fnd_file.put_line(fnd_file.log, g_mesg_line);
912: g_mesg := g_mesg || g_mesg_line;
913: g_mesg_line := '- Specified plan is not an account level plan.';
914: fnd_file.put_line(fnd_file.log, g_mesg_line);
915: g_mesg := g_mesg || g_mesg_line;

Line 914: fnd_file.put_line(fnd_file.log, g_mesg_line);

910: g_mesg_line := '- Specified plan is either customized or has expired.';
911: fnd_file.put_line(fnd_file.log, g_mesg_line);
912: g_mesg := g_mesg || g_mesg_line;
913: g_mesg_line := '- Specified plan is not an account level plan.';
914: fnd_file.put_line(fnd_file.log, g_mesg_line);
915: g_mesg := g_mesg || g_mesg_line;
916: g_mesg_line := '- Profile results for the specified account and/or check of the ' ||
917: 'specified plan have not been populated.';
918: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 918: fnd_file.put_line(fnd_file.log, g_mesg_line);

914: fnd_file.put_line(fnd_file.log, g_mesg_line);
915: g_mesg := g_mesg || g_mesg_line;
916: g_mesg_line := '- Profile results for the specified account and/or check of the ' ||
917: 'specified plan have not been populated.';
918: fnd_file.put_line(fnd_file.log, g_mesg_line);
919: g_mesg := g_mesg || g_mesg_line;
920: g_mesg_line := 'Action';
921: fnd_file.put_line(fnd_file.log, g_mesg_line);
922: g_mesg := g_mesg || g_mesg_line;

Line 921: fnd_file.put_line(fnd_file.log, g_mesg_line);

917: 'specified plan have not been populated.';
918: fnd_file.put_line(fnd_file.log, g_mesg_line);
919: g_mesg := g_mesg || g_mesg_line;
920: g_mesg_line := 'Action';
921: fnd_file.put_line(fnd_file.log, g_mesg_line);
922: g_mesg := g_mesg || g_mesg_line;
923: g_mesg_line := '- Specify plans that are not customized and have not expired.';
924: fnd_file.put_line(fnd_file.log, g_mesg_line);
925: g_mesg := g_mesg || g_mesg_line;

Line 924: fnd_file.put_line(fnd_file.log, g_mesg_line);

920: g_mesg_line := 'Action';
921: fnd_file.put_line(fnd_file.log, g_mesg_line);
922: g_mesg := g_mesg || g_mesg_line;
923: g_mesg_line := '- Specify plans that are not customized and have not expired.';
924: fnd_file.put_line(fnd_file.log, g_mesg_line);
925: g_mesg := g_mesg || g_mesg_line;
926: g_mesg_line := '- Specify plans that are account level plans when specifing an account together.';
927: fnd_file.put_line(fnd_file.log, g_mesg_line);
928: g_mesg := g_mesg || g_mesg_line;

Line 927: fnd_file.put_line(fnd_file.log, g_mesg_line);

923: g_mesg_line := '- Specify plans that are not customized and have not expired.';
924: fnd_file.put_line(fnd_file.log, g_mesg_line);
925: g_mesg := g_mesg || g_mesg_line;
926: g_mesg_line := '- Specify plans that are account level plans when specifing an account together.';
927: fnd_file.put_line(fnd_file.log, g_mesg_line);
928: g_mesg := g_mesg || g_mesg_line;
929: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
930: 'specified account and/or check of the specified plan.';
931: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 931: fnd_file.put_line(fnd_file.log, g_mesg_line);

927: fnd_file.put_line(fnd_file.log, g_mesg_line);
928: g_mesg := g_mesg || g_mesg_line;
929: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
930: 'specified account and/or check of the specified plan.';
931: fnd_file.put_line(fnd_file.log, g_mesg_line);
932: g_mesg := g_mesg || g_mesg_line;
933: else
934: -- call the procedure to make/break the customer - plan association
935: add_remove_plan_check (

Line 956: fnd_file.put_line(fnd_file.log, g_mesg);

952:
953: EXCEPTION
954: WHEN OTHERS THEN
955: g_mesg := sqlcode || ' ' || sqlerrm;
956: fnd_file.put_line(fnd_file.log, g_mesg);
957: G_ERRBUF := g_mesg;
958:
959: END RUN_WITH_PLAN_ACCOUNT;
960:

Line 1016: fnd_file.put_line(fnd_file.log, g_mesg_line);

1012: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
1013: 'Please enter a valid set of parameters.';
1014: G_ERRBUF := g_mesg;
1015: g_mesg_line := 'Causes:';
1016: fnd_file.put_line(fnd_file.log, g_mesg_line);
1017: g_mesg := g_mesg || g_mesg_line;
1018: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1019: fnd_file.put_line(fnd_file.log, g_mesg_line);
1020: g_mesg := g_mesg || g_mesg_line;

Line 1019: fnd_file.put_line(fnd_file.log, g_mesg_line);

1015: g_mesg_line := 'Causes:';
1016: fnd_file.put_line(fnd_file.log, g_mesg_line);
1017: g_mesg := g_mesg || g_mesg_line;
1018: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1019: fnd_file.put_line(fnd_file.log, g_mesg_line);
1020: g_mesg := g_mesg || g_mesg_line;
1021: g_mesg_line := '- Plans for the specified check are account level plans.';
1022: fnd_file.put_line(fnd_file.log, g_mesg_line);
1023: g_mesg := g_mesg || g_mesg_line;

Line 1022: fnd_file.put_line(fnd_file.log, g_mesg_line);

1018: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1019: fnd_file.put_line(fnd_file.log, g_mesg_line);
1020: g_mesg := g_mesg || g_mesg_line;
1021: g_mesg_line := '- Plans for the specified check are account level plans.';
1022: fnd_file.put_line(fnd_file.log, g_mesg_line);
1023: g_mesg := g_mesg || g_mesg_line;
1024: g_mesg_line := '- Profile results for the specified check and/or party have not been populated.';
1025: fnd_file.put_line(fnd_file.log, g_mesg_line);
1026: g_mesg := g_mesg || g_mesg_line;

Line 1025: fnd_file.put_line(fnd_file.log, g_mesg_line);

1021: g_mesg_line := '- Plans for the specified check are account level plans.';
1022: fnd_file.put_line(fnd_file.log, g_mesg_line);
1023: g_mesg := g_mesg || g_mesg_line;
1024: g_mesg_line := '- Profile results for the specified check and/or party have not been populated.';
1025: fnd_file.put_line(fnd_file.log, g_mesg_line);
1026: g_mesg := g_mesg || g_mesg_line;
1027: g_mesg_line := 'Action';
1028: fnd_file.put_line(fnd_file.log, g_mesg_line);
1029: g_mesg := g_mesg || g_mesg_line;

Line 1028: fnd_file.put_line(fnd_file.log, g_mesg_line);

1024: g_mesg_line := '- Profile results for the specified check and/or party have not been populated.';
1025: fnd_file.put_line(fnd_file.log, g_mesg_line);
1026: g_mesg := g_mesg || g_mesg_line;
1027: g_mesg_line := 'Action';
1028: fnd_file.put_line(fnd_file.log, g_mesg_line);
1029: g_mesg := g_mesg || g_mesg_line;
1030: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1031: fnd_file.put_line(fnd_file.log, g_mesg_line);
1032: g_mesg := g_mesg || g_mesg_line;

Line 1031: fnd_file.put_line(fnd_file.log, g_mesg_line);

1027: g_mesg_line := 'Action';
1028: fnd_file.put_line(fnd_file.log, g_mesg_line);
1029: g_mesg := g_mesg || g_mesg_line;
1030: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1031: fnd_file.put_line(fnd_file.log, g_mesg_line);
1032: g_mesg := g_mesg || g_mesg_line;
1033: g_mesg_line := '- Specify checks associated to plans that are not at account level.';
1034: fnd_file.put_line(fnd_file.log, g_mesg_line);
1035: g_mesg := g_mesg || g_mesg_line;

Line 1034: fnd_file.put_line(fnd_file.log, g_mesg_line);

1030: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1031: fnd_file.put_line(fnd_file.log, g_mesg_line);
1032: g_mesg := g_mesg || g_mesg_line;
1033: g_mesg_line := '- Specify checks associated to plans that are not at account level.';
1034: fnd_file.put_line(fnd_file.log, g_mesg_line);
1035: g_mesg := g_mesg || g_mesg_line;
1036: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
1037: 'specified party and/or specified check.';
1038: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 1038: fnd_file.put_line(fnd_file.log, g_mesg_line);

1034: fnd_file.put_line(fnd_file.log, g_mesg_line);
1035: g_mesg := g_mesg || g_mesg_line;
1036: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
1037: 'specified party and/or specified check.';
1038: fnd_file.put_line(fnd_file.log, g_mesg_line);
1039: g_mesg := g_mesg || g_mesg_line;
1040: else
1041: -- call the procedure to make/break the customer - plan association
1042: add_remove_plan_check (

Line 1063: fnd_file.put_line(fnd_file.log, g_mesg);

1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: g_mesg := sqlcode || ' ' || sqlerrm;
1063: fnd_file.put_line(fnd_file.log, g_mesg);
1064: G_ERRBUF := g_mesg;
1065:
1066: END RUN_WITH_CHECK_PARTY;
1067:

Line 1124: fnd_file.put_line(fnd_file.log, g_mesg_line);

1120: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
1121: 'Please enter a valid set of parameters.';
1122: G_ERRBUF := g_mesg;
1123: g_mesg_line := 'Causes:';
1124: fnd_file.put_line(fnd_file.log, g_mesg_line);
1125: g_mesg := g_mesg || g_mesg_line;
1126: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1127: fnd_file.put_line(fnd_file.log, g_mesg_line);
1128: g_mesg := g_mesg || g_mesg_line;

Line 1127: fnd_file.put_line(fnd_file.log, g_mesg_line);

1123: g_mesg_line := 'Causes:';
1124: fnd_file.put_line(fnd_file.log, g_mesg_line);
1125: g_mesg := g_mesg || g_mesg_line;
1126: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1127: fnd_file.put_line(fnd_file.log, g_mesg_line);
1128: g_mesg := g_mesg || g_mesg_line;
1129: g_mesg_line := '- Plans for the specified check are not account level plans.';
1130: fnd_file.put_line(fnd_file.log, g_mesg_line);
1131: g_mesg := g_mesg || g_mesg_line;

Line 1130: fnd_file.put_line(fnd_file.log, g_mesg_line);

1126: g_mesg_line := '- Plans for the specified check are either customized or have expired.';
1127: fnd_file.put_line(fnd_file.log, g_mesg_line);
1128: g_mesg := g_mesg || g_mesg_line;
1129: g_mesg_line := '- Plans for the specified check are not account level plans.';
1130: fnd_file.put_line(fnd_file.log, g_mesg_line);
1131: g_mesg := g_mesg || g_mesg_line;
1132: g_mesg_line := '- Profile results for the specified check and/or account have not been populated.';
1133: fnd_file.put_line(fnd_file.log, g_mesg_line);
1134: g_mesg := g_mesg || g_mesg_line;

Line 1133: fnd_file.put_line(fnd_file.log, g_mesg_line);

1129: g_mesg_line := '- Plans for the specified check are not account level plans.';
1130: fnd_file.put_line(fnd_file.log, g_mesg_line);
1131: g_mesg := g_mesg || g_mesg_line;
1132: g_mesg_line := '- Profile results for the specified check and/or account have not been populated.';
1133: fnd_file.put_line(fnd_file.log, g_mesg_line);
1134: g_mesg := g_mesg || g_mesg_line;
1135: g_mesg_line := 'Action';
1136: fnd_file.put_line(fnd_file.log, g_mesg_line);
1137: g_mesg := g_mesg || g_mesg_line;

Line 1136: fnd_file.put_line(fnd_file.log, g_mesg_line);

1132: g_mesg_line := '- Profile results for the specified check and/or account have not been populated.';
1133: fnd_file.put_line(fnd_file.log, g_mesg_line);
1134: g_mesg := g_mesg || g_mesg_line;
1135: g_mesg_line := 'Action';
1136: fnd_file.put_line(fnd_file.log, g_mesg_line);
1137: g_mesg := g_mesg || g_mesg_line;
1138: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1139: fnd_file.put_line(fnd_file.log, g_mesg_line);
1140: g_mesg := g_mesg || g_mesg_line;

Line 1139: fnd_file.put_line(fnd_file.log, g_mesg_line);

1135: g_mesg_line := 'Action';
1136: fnd_file.put_line(fnd_file.log, g_mesg_line);
1137: g_mesg := g_mesg || g_mesg_line;
1138: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1139: fnd_file.put_line(fnd_file.log, g_mesg_line);
1140: g_mesg := g_mesg || g_mesg_line;
1141: g_mesg_line := '- Specify checks associated to plans that are at account level.';
1142: fnd_file.put_line(fnd_file.log, g_mesg_line);
1143: g_mesg := g_mesg || g_mesg_line;

Line 1142: fnd_file.put_line(fnd_file.log, g_mesg_line);

1138: g_mesg_line := '- Specify checks associated to plans that are not customized and have not expired.';
1139: fnd_file.put_line(fnd_file.log, g_mesg_line);
1140: g_mesg := g_mesg || g_mesg_line;
1141: g_mesg_line := '- Specify checks associated to plans that are at account level.';
1142: fnd_file.put_line(fnd_file.log, g_mesg_line);
1143: g_mesg := g_mesg || g_mesg_line;
1144: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
1145: 'specified account and/or specified check.';
1146: fnd_file.put_line(fnd_file.log, g_mesg_line);

Line 1146: fnd_file.put_line(fnd_file.log, g_mesg_line);

1142: fnd_file.put_line(fnd_file.log, g_mesg_line);
1143: g_mesg := g_mesg || g_mesg_line;
1144: g_mesg_line := '- Run the Profile Engine to populate the results for the ' ||
1145: 'specified account and/or specified check.';
1146: fnd_file.put_line(fnd_file.log, g_mesg_line);
1147: g_mesg := g_mesg || g_mesg_line;
1148: else
1149: -- call the procedure to make/break the customer - plan association
1150: add_remove_plan_check (

Line 1171: fnd_file.put_line(fnd_file.log, g_mesg);

1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: g_mesg := sqlcode || ' ' || sqlerrm;
1171: fnd_file.put_line(fnd_file.log, g_mesg);
1172: G_ERRBUF := g_mesg;
1173:
1174: END RUN_WITH_CHECK_ACCOUNT;
1175:

Line 1234: fnd_file.put_line(fnd_file.log, g_mesg_line);

1230: g_mesg := 'Given request parameters did not retrieve any records to be processed. ' ||
1231: 'Please enter a valid set of parameters.';
1232: G_ERRBUF := g_mesg;
1233: g_mesg_line := 'Causes:';
1234: fnd_file.put_line(fnd_file.log, g_mesg_line);
1235: g_mesg := g_mesg || g_mesg_line;
1236: g_mesg_line := '- All plans have expired.';
1237: fnd_file.put_line(fnd_file.log, g_mesg_line);
1238: g_mesg := g_mesg || g_mesg_line;

Line 1237: fnd_file.put_line(fnd_file.log, g_mesg_line);

1233: g_mesg_line := 'Causes:';
1234: fnd_file.put_line(fnd_file.log, g_mesg_line);
1235: g_mesg := g_mesg || g_mesg_line;
1236: g_mesg_line := '- All plans have expired.';
1237: fnd_file.put_line(fnd_file.log, g_mesg_line);
1238: g_mesg := g_mesg || g_mesg_line;
1239: g_mesg_line := '- Profile results have not been populated.';
1240: fnd_file.put_line(fnd_file.log, g_mesg_line);
1241: g_mesg := g_mesg || g_mesg_line;

Line 1240: fnd_file.put_line(fnd_file.log, g_mesg_line);

1236: g_mesg_line := '- All plans have expired.';
1237: fnd_file.put_line(fnd_file.log, g_mesg_line);
1238: g_mesg := g_mesg || g_mesg_line;
1239: g_mesg_line := '- Profile results have not been populated.';
1240: fnd_file.put_line(fnd_file.log, g_mesg_line);
1241: g_mesg := g_mesg || g_mesg_line;
1242: g_mesg_line := 'Action';
1243: fnd_file.put_line(fnd_file.log, g_mesg_line);
1244: g_mesg := g_mesg || g_mesg_line;

Line 1243: fnd_file.put_line(fnd_file.log, g_mesg_line);

1239: g_mesg_line := '- Profile results have not been populated.';
1240: fnd_file.put_line(fnd_file.log, g_mesg_line);
1241: g_mesg := g_mesg || g_mesg_line;
1242: g_mesg_line := 'Action';
1243: fnd_file.put_line(fnd_file.log, g_mesg_line);
1244: g_mesg := g_mesg || g_mesg_line;
1245: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
1246: fnd_file.put_line(fnd_file.log, g_mesg_line);
1247: g_mesg := g_mesg || g_mesg_line;

Line 1246: fnd_file.put_line(fnd_file.log, g_mesg_line);

1242: g_mesg_line := 'Action';
1243: fnd_file.put_line(fnd_file.log, g_mesg_line);
1244: g_mesg := g_mesg || g_mesg_line;
1245: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
1246: fnd_file.put_line(fnd_file.log, g_mesg_line);
1247: g_mesg := g_mesg || g_mesg_line;
1248: g_mesg_line := '- Run the Profile Engine to populate all results.';
1249: fnd_file.put_line(fnd_file.log, g_mesg_line);
1250: g_mesg := g_mesg || g_mesg_line;

Line 1249: fnd_file.put_line(fnd_file.log, g_mesg_line);

1245: g_mesg_line := '- Verify that there are active plans. (ie. end date of plans are a future date)';
1246: fnd_file.put_line(fnd_file.log, g_mesg_line);
1247: g_mesg := g_mesg || g_mesg_line;
1248: g_mesg_line := '- Run the Profile Engine to populate all results.';
1249: fnd_file.put_line(fnd_file.log, g_mesg_line);
1250: g_mesg := g_mesg || g_mesg_line;
1251: else
1252: -- call the procedure to make/break the customer - plan association
1253: add_remove_plan_check (

Line 1274: fnd_file.put_line(fnd_file.log, g_mesg);

1270:
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: g_mesg := sqlcode || ' ' || sqlerrm;
1274: fnd_file.put_line(fnd_file.log, g_mesg);
1275: G_ERRBUF := g_mesg;
1276:
1277: END RUN_WITH_ALL;
1278:

Line 1330: fnd_file.put_line(fnd_file.log, g_mesg);

1326: X_RETURN_STATUS => x_return_status );
1327:
1328: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1329: g_mesg := 'Plan criteria not defined correctly for plan_id = ' || p_plan_id_tbl(i);
1330: fnd_file.put_line(fnd_file.log, g_mesg);
1331: end if;
1332:
1333: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1334: if ( p_relational_operator_tbl(i) = '=' ) then

Line 1466: fnd_file.put_line(fnd_file.log, g_mesg);

1462: else
1463: -- set message that the relational operator is invalid and raise an error.
1464: l_assign_plan := 'F';
1465: g_mesg := 'Invalid relational operator for plan_id = ' || p_plan_id_tbl(i);
1466: fnd_file.put_line(fnd_file.log, g_mesg);
1467: END IF;
1468:
1469: if ( l_assign_plan = 'T' ) then
1470: L_ADD_IDX := L_ADD_IDX + 1;

Line 1494: fnd_file.put_line(fnd_file.log, g_mesg);

1490: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1491: -- generate message in stack.
1492: -- raise exception
1493: g_mesg := 'Delete of customer to plan association failed.';
1494: fnd_file.put_line(fnd_file.log, g_mesg);
1495: -- RAISE FND_API.G_EXC_ERROR;
1496: end if;
1497:
1498: L_DEL_IDX := 0;

Line 1517: fnd_file.put_line(fnd_file.log, g_mesg);

1513: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1514: -- generate message in stack.
1515: -- raise exception
1516: g_mesg := 'Insert of new customer to plan association failed.';
1517: fnd_file.put_line(fnd_file.log, g_mesg);
1518: -- RAISE FND_API.G_EXC_ERROR;
1519: end if;
1520:
1521: L_ADD_IDX := 0;

Line 1543: fnd_file.put_line(fnd_file.log, g_mesg);

1539: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1540: -- generate message in stack.
1541: -- raise exception
1542: g_mesg := 'Delete of customer to plan association failed.';
1543: fnd_file.put_line(fnd_file.log, g_mesg);
1544: -- RAISE FND_API.G_EXC_ERROR;
1545: end if;
1546: END IF; -- if g_del_id > 0
1547:

Line 1560: fnd_file.put_line(fnd_file.log, g_mesg);

1556: if ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1557: -- generate message in stack.
1558: -- raise exception
1559: g_mesg := 'Insert of new customer to plan association failed.';
1560: fnd_file.put_line(fnd_file.log, g_mesg);
1561: -- RAISE FND_API.G_EXC_ERROR;
1562: end if;
1563: END IF; -- if L_add_idx > 0
1564:

Line 1591: fnd_file.put_line(fnd_file.log, g_mesg);

1587: THEN
1588: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NOT NULL ) then
1589: g_mesg := 'Invalid arguments. Cannot perform comparison between check results and ' ||
1590: 'plan criteria. Check the relational operator, low value and high value.';
1591: fnd_file.put_line(fnd_file.log, g_mesg);
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: end if;
1594: ELSIF ( p_relational_operator = 'BETWEEN' OR
1595: p_relational_operator = 'NOT BETWEEN' )

Line 1600: fnd_file.put_line(fnd_file.log, g_mesg);

1596: THEN
1597: if ( p_criteria_value_low IS NULL OR p_criteria_value_high IS NULL ) then
1598: g_mesg := 'Invalid arguments. Cannot perform comparison between check results and ' ||
1599: 'plan criteria. Check the relational operator, low value and high value.';
1600: fnd_file.put_line(fnd_file.log, g_mesg);
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: end if;
1603: ELSIF ( p_relational_operator = 'IS NULL' OR
1604: p_relational_operator = 'IS NOT NULL' )

Line 1609: fnd_file.put_line(fnd_file.log, g_mesg);

1605: THEN
1606: if ( p_criteria_value_low IS NOT NULL OR p_criteria_value_high IS NOT NULL ) then
1607: g_mesg := 'Invalid arguments. Cannot perform comparison between check results and ' ||
1608: 'plan criteria. Check the relational operator, low value and high value.';
1609: fnd_file.put_line(fnd_file.log, g_mesg);
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611: end if;
1612: END IF;
1613: END VALIDATE_COMPARE_ARGUMENTS;

Line 1726: fnd_file.put_line(fnd_file.log, g_mesg);

1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: g_mesg := sqlcode || ' ' || sqlerrm;
1726: fnd_file.put_line(fnd_file.log, g_mesg);
1727: G_ERRBUF := g_mesg;
1728:
1729: END ADD_CUST_PLANS;
1730:

Line 1801: fnd_file.put_line(fnd_file.log, g_mesg);

1797:
1798: EXCEPTION
1799: WHEN OTHERS THEN
1800: g_mesg := sqlcode || ' ' || sqlerrm;
1801: fnd_file.put_line(fnd_file.log, g_mesg);
1802: G_ERRBUF := g_mesg;
1803:
1804: END DELETE_CUST_PLANS;
1805: