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.37 2010/10/22 05:18:48 mpathani ship $ */
3:
4: --
5: -- Constant values

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

713: END LOOP;
714: CLOSE rating_crs;
715: END IF;
716:
717: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||
718: '''' || curr_code || '''' || ',' ||
719: '''' || data_type || '''' || ','||
720: 'value, '||
721: ''''|| fmt_mask || '''' || ')' ;

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

719: '''' || data_type || '''' || ','||
720: 'value, '||
721: ''''|| fmt_mask || '''' || ')' ;
722:
723: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||
724: chk_id || ', ' ||
725: 'party_id, account_id,party_site_id, value, ' || -- included 'party_site_id' by spamujul for ER#8473903
726: '''' || data_type || '''' || ', ' ||
727: '''' || 'GRADE' || '''' ||', ' ||

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

728: '''' || v_count || '''' || ')' ;
729:
730: c_curr_code := '''' || curr_code || '''';
731:
732: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||
733: 'value, '||
734: '''' || Range_Low_Value || '''' || ', '||
735: '''' || Range_High_Value || '''' || ', '||
736: '''' || data_type || '''' || ', ' ||

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

735: '''' || Range_High_Value || '''' || ', '||
736: '''' || data_type || '''' || ', ' ||
737: '''' || chk_u_l_flag || '''' || ')' ;
738:
739: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||
740: chk_id || ', ' ||
741: 'party_id, account_id,party_site_id, value, ' || -- included 'party_site_id' by spamujul for ER#8473903
742: '''' || data_type || '''' || ', ' ||
743: '''' || 'RATING' || '''' ||', ' ||

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

742: '''' || data_type || '''' || ', ' ||
743: '''' || 'RATING' || '''' ||', ' ||
744: '''' || v_count || '''' || ')' ;
745:
746: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||
747: chk_id || ', ' ||
748: 'party_id, account_id,party_site_id, value, ' || -- included 'party_site_id' by spamujul for ER#8473903
749: '''' || data_type || '''' || ', ' ||
750: '''' || 'COLOR' || '''' ||', ' ||

Line 916: CSC_Profile_Engine_PKG.Handle_Exception;

912: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
913:
914: EXCEPTION
915: when Tablesegment_full then
916: CSC_Profile_Engine_PKG.Handle_Exception;
917: g_error := sqlcode || ' ' || sqlerrm;
918: fnd_file.put_line(fnd_file.log , g_error);
919: App_Exception.raise_exception;
920:

Line 922: CSC_Profile_Engine_PKG.Handle_Exception;

918: fnd_file.put_line(fnd_file.log , g_error);
919: App_Exception.raise_exception;
920:
921: when Indexsegment_full then
922: CSC_Profile_Engine_PKG.Handle_Exception;
923: g_error := sqlcode || ' ' || sqlerrm;
924: fnd_file.put_line(fnd_file.log , g_error);
925: App_Exception.raise_exception;
926:

Line 928: CSC_Profile_Engine_PKG.Handle_Exception;

924: fnd_file.put_line(fnd_file.log , g_error);
925: App_Exception.raise_exception;
926:
927: when SNAPSHOT_TOO_OLD THEN
928: CSC_Profile_Engine_PKG.Handle_Exception;
929: g_error := sqlcode || ' ' || sqlerrm;
930: fnd_file.put_line(fnd_file.log,g_error);
931: App_Exception.raise_exception;
932:

Line 934: CSC_Profile_Engine_PKG.Handle_Exception;

930: fnd_file.put_line(fnd_file.log,g_error);
931: App_Exception.raise_exception;
932:
933: WHEN INTERNAL_ERROR THEN
934: CSC_Profile_Engine_PKG.Handle_Exception;
935: g_error := sqlcode || ' ' || sqlerrm;
936: fnd_file.put_line(fnd_file.log,g_error);
937: App_Exception.raise_exception;
938:

Line 940: CSC_Profile_Engine_PKG.Handle_Exception;

936: fnd_file.put_line(fnd_file.log,g_error);
937: App_Exception.raise_exception;
938:
939: WHEN SUMMATION_ERROR THEN
940: CSC_Profile_Engine_PKG.Handle_Exception;
941: set_context('Evaluate_Checks1_Var',
942: 'Summation SQL failed for chk_id => '||to_char(chk_id));
943: RAISE;
944:

Line 946: CSC_Profile_Engine_PKG.Handle_Exception;

942: 'Summation SQL failed for chk_id => '||to_char(chk_id));
943: RAISE;
944:
945: WHEN OTHERS THEN
946: CSC_Profile_Engine_PKG.Handle_Exception;
947: g_error := sqlcode || ' ' || sqlerrm;
948: fnd_file.put_line(fnd_file.log , g_error);
949:
950: END Evaluate_Checks1_Var;

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

3919: FETCH rating_crs INTO rating_tbl(a);
3920: END LOOP;
3921: CLOSE rating_crs;
3922: END IF;
3923: c_fmt_mask := 'CSC_Profile_Engine_PKG.format_mask(' ||
3924: '''' || curr_code || '''' || ',' ||
3925: '''' || data_type || '''' || ','||
3926: 'value, '||
3927: ''''|| fmt_mask || '''' || ')' ;

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

3925: '''' || data_type || '''' || ','||
3926: 'value, '||
3927: ''''|| fmt_mask || '''' || ')' ;
3928:
3929: c_grade := 'CSC_Profile_Engine_PKG.rating_color(' ||
3930: chk_id || ', ' ||
3931: 'party_id, account_id,party_site_id, value, ' || -- included by spamujul for ER#8473903
3932: '''' || data_type || '''' || ', ' ||
3933: '''' || 'GRADE' || '''' ||', ' ||

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

3932: '''' || data_type || '''' || ', ' ||
3933: '''' || 'GRADE' || '''' ||', ' ||
3934: '''' || v_count || '''' || ')' ;
3935: c_curr_code := '''' || curr_code || '''';
3936: c_threshold := 'CSC_Profile_Engine_PKG.calc_threshold(' ||
3937: 'value, '||
3938: '''' || Range_Low_Value || '''' || ', '||
3939: '''' || Range_High_Value || '''' || ', '||
3940: '''' || data_type || '''' || ', ' ||

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

3939: '''' || Range_High_Value || '''' || ', '||
3940: '''' || data_type || '''' || ', ' ||
3941: '''' || chk_u_l_flag || '''' || ')' ;
3942:
3943: c_rating := 'CSC_Profile_Engine_PKG.rating_color(' ||
3944: chk_id || ', ' ||
3945: 'party_id, account_id,party_site_id, value, ' || -- included by spamujul for ER#8473903
3946: '''' || data_type || '''' || ', ' ||
3947: '''' || 'RATING' || '''' ||', ' ||

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

3946: '''' || data_type || '''' || ', ' ||
3947: '''' || 'RATING' || '''' ||', ' ||
3948: '''' || v_count || '''' || ')' ;
3949:
3950: c_color := 'CSC_Profile_Engine_PKG.rating_color(' ||
3951: chk_id || ', ' ||
3952: 'party_id, account_id,party_site_id, value, ' || -- included by spamujul for ER#8473903
3953: '''' || data_type || '''' || ', ' ||
3954: '''' || 'COLOR' || '''' ||', ' ||

Line 4128: CSC_Profile_Engine_PKG.Handle_Exception;

4124: EXECUTE IMMEDIATE 'ALTER TABLE ' || v_schema_name || '.CSC_PROF_CHECK_RESULTS LOGGING';
4125:
4126: EXCEPTION
4127: WHEN Tablesegment_full then
4128: CSC_Profile_Engine_PKG.Handle_Exception;
4129: g_error := sqlcode || ' ' || sqlerrm;
4130: set_context('Evaluate_Checks4_Var',
4131: 'check_id => ' || chk_id,
4132: 'Error => ' || g_error);

Line 4136: CSC_Profile_Engine_PKG.Handle_Exception;

4132: 'Error => ' || g_error);
4133: App_Exception.raise_exception;
4134:
4135: WHEN Indexsegment_full then
4136: CSC_Profile_Engine_PKG.Handle_Exception;
4137: g_error := sqlcode || ' ' || sqlerrm;
4138: set_context('Evaluate_Checks4_Var',
4139: 'check_id => ' || chk_id,
4140: 'Error => ' || g_error);

Line 4144: CSC_Profile_Engine_PKG.Handle_Exception;

4140: 'Error => ' || g_error);
4141: App_Exception.raise_exception;
4142:
4143: WHEN SNAPSHOT_TOO_OLD THEN
4144: CSC_Profile_Engine_PKG.Handle_Exception;
4145: g_error := sqlcode || ' ' || sqlerrm;
4146: set_context('Evaluate_Checks4_Var',
4147: 'check_id => ' || chk_id,
4148: 'Error => ' || g_error);

Line 4152: CSC_Profile_Engine_PKG.Handle_Exception;

4148: 'Error => ' || g_error);
4149: App_Exception.raise_exception;
4150:
4151: WHEN INTERNAL_ERROR THEN
4152: CSC_Profile_Engine_PKG.Handle_Exception;
4153: g_error := sqlcode || ' ' || sqlerrm;
4154: set_context('Evaluate_Checks4_Var',
4155: 'check_id => ' || chk_id,
4156: 'Error => ' || g_error);

Line 4160: CSC_Profile_Engine_PKG.Handle_Exception;

4156: 'Error => ' || g_error);
4157: App_Exception.raise_exception;
4158:
4159: WHEN SUMMATION_ERROR THEN
4160: CSC_Profile_Engine_PKG.Handle_Exception;
4161: set_context('Evaluate_Checks4_Var',
4162: 'Summation SQL failed for chk_id => '||to_char(chk_id));
4163: RAISE;
4164:

Line 4166: CSC_Profile_Engine_PKG.Handle_Exception;

4162: 'Summation SQL failed for chk_id => '||to_char(chk_id));
4163: RAISE;
4164:
4165: WHEN OTHERS THEN
4166: CSC_Profile_Engine_PKG.Handle_Exception;
4167: g_error := sqlcode || ' ' || sqlerrm;
4168: set_context('Evaluate_Checks4_Var',
4169: 'check_id => ' || chk_id,
4170: 'Error => ' || g_error);

Line 9803: CSC_PROFILE_ENGINE_PKG.run_engine_jit

9799: p_media_item_id => l_media_item_id );
9800: RETURN;
9801: END IF;
9802:
9803: CSC_PROFILE_ENGINE_PKG.run_engine_jit
9804: ( p_party_id => l_hidden_party_id,
9805: p_acct_id => l_acct_id,
9806: p_psite_id => l_psite_id, -- added by spamujul for ER#8473903
9807: p_group_id => l_group_id,

Line 9844: CSC_PROFILE_ENGINE_PKG.run_engine_jit

9840: p_media_item_id => l_media_item_id );
9841: RETURN;
9842: END IF;
9843:
9844: CSC_PROFILE_ENGINE_PKG.run_engine_jit
9845: ( p_party_id => l_emp_id,
9846: p_acct_id => NULL,
9847: p_psite_id => NULL, -- added by spamujul for ER#8473903
9848: p_group_id => l_group_id,

Line 9951: CSC_PROFILE_ENGINE_PKG.run_engine_jit

9947: p_media_item_id => l_media_item_id );
9948: RETURN;
9949: END IF;
9950:
9951: CSC_PROFILE_ENGINE_PKG.run_engine_jit
9952: ( p_party_id => l_party_id,
9953: p_acct_id => l_acct_id,
9954: p_psite_id => l_psite_id, -- added by spamujul for ER#8473903
9955: p_group_id => l_group_id,

Line 9992: CSC_PROFILE_ENGINE_PKG.run_engine_jit

9988: p_media_item_id => l_media_item_id );
9989: RETURN;
9990: END IF;
9991:
9992: CSC_PROFILE_ENGINE_PKG.run_engine_jit
9993: ( p_party_id => l_emp_id,
9994: p_acct_id => NULL,
9995: p_psite_id => NULL, -- added by spamujul for ER#8473903
9996: p_group_id => l_group_id,

Line 10038: CSC_PROFILE_ENGINE_PKG.run_engine_jit

10034: p_media_item_id => l_media_item_id );
10035: RETURN;
10036: END IF;
10037:
10038: CSC_PROFILE_ENGINE_PKG.run_engine_jit
10039: ( p_party_id => l_party_id,
10040: p_acct_id => NULL,
10041: p_psite_id => NULL, -- added by spamujul for ER#8473903
10042: p_group_id => l_group_id,

Line 10151: CSC_PROFILE_ENGINE_PKG.run_engine_jit

10147: p_media_item_id => l_media_item_id );
10148: RETURN;
10149: END IF;
10150:
10151: CSC_PROFILE_ENGINE_PKG.run_engine_jit
10152: ( p_party_id => l_party_id,
10153: p_acct_id => l_acct_id,
10154: p_psite_id => l_psite_id, -- added by spamujul for ER#8473903
10155: p_group_id => l_group_id,

Line 10193: CSC_PROFILE_ENGINE_PKG.run_engine_jit

10189: p_media_item_id => l_media_item_id );
10190: RETURN;
10191: END IF;
10192:
10193: CSC_PROFILE_ENGINE_PKG.run_engine_jit
10194: ( p_party_id => l_party_id,
10195: p_acct_id => NULL,
10196: p_psite_id => NULL, -- added by spamujul for ER#8473903
10197: p_group_id => l_group_id,

Line 10720: END CSC_Profile_Engine_PKG;

10716: /******************************
10717: * End Utilities Definition *
10718: ******************************/
10719:
10720: END CSC_Profile_Engine_PKG;