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_PROFILE_ENGINE_PKG dependencies on CSC_PROFILE_ENGINE_PKG

Line 1: PACKAGE BODY CSC_Profile_Engine_PKG AS

1: PACKAGE BODY CSC_Profile_Engine_PKG AS
2: /* $Header: csccpepb.pls 120.22.12010000.3 2008/09/11 03:09:28 mpathani ship $ */
3:
4: --
5: -- Constant values

Line 615: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||

611: END LOOP;
612: CLOSE rating_crs;
613: END IF;
614:
615: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||
616: '''' || curr_code || '''' || ',' ||
617: '''' || data_type || '''' || ','||
618: 'value, '||
619: ''''|| fmt_mask || '''' || ')' ;

Line 621: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||

617: '''' || data_type || '''' || ','||
618: 'value, '||
619: ''''|| fmt_mask || '''' || ')' ;
620:
621: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||
622: chk_id || ', ' ||
623: 'party_id, account_id, value, ' ||
624: '''' || data_type || '''' || ', ' ||
625: '''' || 'GRADE' || '''' ||', ' ||

Line 630: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||

626: '''' || v_count || '''' || ')' ;
627:
628: c_curr_code := '''' || curr_code || '''';
629:
630: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||
631: 'value, '||
632: '''' || Range_Low_Value || '''' || ', '||
633: '''' || Range_High_Value || '''' || ', '||
634: '''' || data_type || '''' || ', ' ||

Line 637: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||

633: '''' || Range_High_Value || '''' || ', '||
634: '''' || data_type || '''' || ', ' ||
635: '''' || chk_u_l_flag || '''' || ')' ;
636:
637: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||
638: chk_id || ', ' ||
639: 'party_id, account_id, value, ' ||
640: '''' || data_type || '''' || ', ' ||
641: '''' || 'RATING' || '''' ||', ' ||

Line 644: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||

640: '''' || data_type || '''' || ', ' ||
641: '''' || 'RATING' || '''' ||', ' ||
642: '''' || v_count || '''' || ')' ;
643:
644: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||
645: chk_id || ', ' ||
646: 'party_id, account_id, value, ' ||
647: '''' || data_type || '''' || ', ' ||
648: '''' || 'COLOR' || '''' ||', ' ||

Line 748: CSC_Profile_Engine_PKG.Handle_Exception;

744: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
745:
746: EXCEPTION
747: when Tablesegment_full then
748: CSC_Profile_Engine_PKG.Handle_Exception;
749: g_error := sqlcode || ' ' || sqlerrm;
750: fnd_file.put_line(fnd_file.log , g_error);
751: App_Exception.raise_exception;
752:

Line 754: CSC_Profile_Engine_PKG.Handle_Exception;

750: fnd_file.put_line(fnd_file.log , g_error);
751: App_Exception.raise_exception;
752:
753: when Indexsegment_full then
754: CSC_Profile_Engine_PKG.Handle_Exception;
755: g_error := sqlcode || ' ' || sqlerrm;
756: fnd_file.put_line(fnd_file.log , g_error);
757: App_Exception.raise_exception;
758:

Line 760: CSC_Profile_Engine_PKG.Handle_Exception;

756: fnd_file.put_line(fnd_file.log , g_error);
757: App_Exception.raise_exception;
758:
759: when SNAPSHOT_TOO_OLD THEN
760: CSC_Profile_Engine_PKG.Handle_Exception;
761: g_error := sqlcode || ' ' || sqlerrm;
762: fnd_file.put_line(fnd_file.log,g_error);
763: App_Exception.raise_exception;
764:

Line 766: CSC_Profile_Engine_PKG.Handle_Exception;

762: fnd_file.put_line(fnd_file.log,g_error);
763: App_Exception.raise_exception;
764:
765: WHEN INTERNAL_ERROR THEN
766: CSC_Profile_Engine_PKG.Handle_Exception;
767: g_error := sqlcode || ' ' || sqlerrm;
768: fnd_file.put_line(fnd_file.log,g_error);
769: App_Exception.raise_exception;
770:

Line 772: CSC_Profile_Engine_PKG.Handle_Exception;

768: fnd_file.put_line(fnd_file.log,g_error);
769: App_Exception.raise_exception;
770:
771: WHEN SUMMATION_ERROR THEN
772: CSC_Profile_Engine_PKG.Handle_Exception;
773: set_context('Evaluate_Checks1_Var',
774: 'Summation SQL failed for chk_id => '||to_char(chk_id));
775: RAISE;
776:

Line 778: CSC_Profile_Engine_PKG.Handle_Exception;

774: 'Summation SQL failed for chk_id => '||to_char(chk_id));
775: RAISE;
776:
777: WHEN OTHERS THEN
778: CSC_Profile_Engine_PKG.Handle_Exception;
779: g_error := sqlcode || ' ' || sqlerrm;
780: fnd_file.put_line(fnd_file.log , g_error);
781:
782: END Evaluate_Checks1_Var;

Line 2798: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||

2794: END LOOP;
2795: CLOSE rating_crs;
2796: END IF;
2797:
2798: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||
2799: '''' || curr_code || '''' || ',' ||
2800: '''' || data_type || '''' || ','||
2801: 'value, '||
2802: ''''|| fmt_mask || '''' || ')' ;

Line 2804: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||

2800: '''' || data_type || '''' || ','||
2801: 'value, '||
2802: ''''|| fmt_mask || '''' || ')' ;
2803:
2804: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||
2805: chk_id || ', ' ||
2806: 'party_id, account_id, value, ' ||
2807: '''' || data_type || '''' || ', ' ||
2808: '''' || 'GRADE' || '''' ||', ' ||

Line 2813: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||

2809: '''' || v_count || '''' || ')' ;
2810:
2811: c_curr_code := '''' || curr_code || '''';
2812:
2813: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||
2814: 'value, '||
2815: '''' || Range_Low_Value || '''' || ', '||
2816: '''' || Range_High_Value || '''' || ', '||
2817: '''' || data_type || '''' || ', ' ||

Line 2820: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||

2816: '''' || Range_High_Value || '''' || ', '||
2817: '''' || data_type || '''' || ', ' ||
2818: '''' || chk_u_l_flag || '''' || ')' ;
2819:
2820: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||
2821: chk_id || ', ' ||
2822: 'party_id, account_id, value, ' ||
2823: '''' || data_type || '''' || ', ' ||
2824: '''' || 'RATING' || '''' ||', ' ||

Line 2827: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||

2823: '''' || data_type || '''' || ', ' ||
2824: '''' || 'RATING' || '''' ||', ' ||
2825: '''' || v_count || '''' || ')' ;
2826:
2827: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||
2828: chk_id || ', ' ||
2829: 'party_id, account_id, value, ' ||
2830: '''' || data_type || '''' || ', ' ||
2831: '''' || 'COLOR' || '''' ||', ' ||

Line 2933: CSC_Profile_Engine_PKG.Handle_Exception;

2929: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
2930:
2931: EXCEPTION
2932: WHEN Tablesegment_full then
2933: CSC_Profile_Engine_PKG.Handle_Exception;
2934: g_error := sqlcode || ' ' || sqlerrm;
2935: set_context('Evaluate_Checks4_Var',
2936: 'check_id => ' || chk_id,
2937: 'Error => ' || g_error);

Line 2941: CSC_Profile_Engine_PKG.Handle_Exception;

2937: 'Error => ' || g_error);
2938: App_Exception.raise_exception;
2939:
2940: WHEN Indexsegment_full then
2941: CSC_Profile_Engine_PKG.Handle_Exception;
2942: g_error := sqlcode || ' ' || sqlerrm;
2943: set_context('Evaluate_Checks4_Var',
2944: 'check_id => ' || chk_id,
2945: 'Error => ' || g_error);

Line 2949: CSC_Profile_Engine_PKG.Handle_Exception;

2945: 'Error => ' || g_error);
2946: App_Exception.raise_exception;
2947:
2948: WHEN SNAPSHOT_TOO_OLD THEN
2949: CSC_Profile_Engine_PKG.Handle_Exception;
2950: g_error := sqlcode || ' ' || sqlerrm;
2951: set_context('Evaluate_Checks4_Var',
2952: 'check_id => ' || chk_id,
2953: 'Error => ' || g_error);

Line 2957: CSC_Profile_Engine_PKG.Handle_Exception;

2953: 'Error => ' || g_error);
2954: App_Exception.raise_exception;
2955:
2956: WHEN INTERNAL_ERROR THEN
2957: CSC_Profile_Engine_PKG.Handle_Exception;
2958: g_error := sqlcode || ' ' || sqlerrm;
2959: set_context('Evaluate_Checks4_Var',
2960: 'check_id => ' || chk_id,
2961: 'Error => ' || g_error);

Line 2965: CSC_Profile_Engine_PKG.Handle_Exception;

2961: 'Error => ' || g_error);
2962: App_Exception.raise_exception;
2963:
2964: WHEN SUMMATION_ERROR THEN
2965: CSC_Profile_Engine_PKG.Handle_Exception;
2966: set_context('Evaluate_Checks4_Var',
2967: 'Summation SQL failed for chk_id => '||to_char(chk_id));
2968: RAISE;
2969:

Line 2971: CSC_Profile_Engine_PKG.Handle_Exception;

2967: 'Summation SQL failed for chk_id => '||to_char(chk_id));
2968: RAISE;
2969:
2970: WHEN OTHERS THEN
2971: CSC_Profile_Engine_PKG.Handle_Exception;
2972: g_error := sqlcode || ' ' || sqlerrm;
2973: set_context('Evaluate_Checks4_Var',
2974: 'check_id => ' || chk_id,
2975: 'Error => ' || g_error);

Line 7097: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7093: p_media_item_id => l_media_item_id );
7094: RETURN;
7095: END IF;
7096:
7097: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7098: ( p_party_id => l_hidden_party_id,
7099: p_acct_id => l_acct_id,
7100: p_group_id => l_group_id,
7101: p_critical_flag => l_critical_flag,

Line 7137: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7133: p_media_item_id => l_media_item_id );
7134: RETURN;
7135: END IF;
7136:
7137: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7138: ( p_party_id => l_emp_id,
7139: p_acct_id => NULL,
7140: p_group_id => l_group_id,
7141: p_critical_flag => l_critical_flag,

Line 7243: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7239: p_media_item_id => l_media_item_id );
7240: RETURN;
7241: END IF;
7242:
7243: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7244: ( p_party_id => l_party_id,
7245: p_acct_id => l_acct_id,
7246: p_group_id => l_group_id,
7247: p_critical_flag => l_critical_flag,

Line 7283: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7279: p_media_item_id => l_media_item_id );
7280: RETURN;
7281: END IF;
7282:
7283: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7284: ( p_party_id => l_emp_id,
7285: p_acct_id => NULL,
7286: p_group_id => l_group_id,
7287: p_critical_flag => l_critical_flag,

Line 7328: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7324: p_media_item_id => l_media_item_id );
7325: RETURN;
7326: END IF;
7327:
7328: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7329: ( p_party_id => l_party_id,
7330: p_acct_id => NULL,
7331: p_group_id => l_group_id,
7332: p_critical_flag => l_critical_flag,

Line 7440: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7436: p_media_item_id => l_media_item_id );
7437: RETURN;
7438: END IF;
7439:
7440: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7441: ( p_party_id => l_party_id,
7442: p_acct_id => l_acct_id,
7443: p_group_id => l_group_id,
7444: p_critical_flag => l_critical_flag,

Line 7481: CSC_PROFILE_ENGINE_PKG.run_engine_jit

7477: p_media_item_id => l_media_item_id );
7478: RETURN;
7479: END IF;
7480:
7481: CSC_PROFILE_ENGINE_PKG.run_engine_jit
7482: ( p_party_id => l_party_id,
7483: p_acct_id => NULL,
7484: p_group_id => l_group_id,
7485: p_critical_flag => l_critical_flag,

Line 7974: END CSC_Profile_Engine_PKG;

7970: /******************************
7971: * End Utilities Definition *
7972: ******************************/
7973:
7974: END CSC_Profile_Engine_PKG;