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.CZ_RULES_SEQ dependencies on CZ_RULES_SEQ

Line 1: PACKAGE BODY CZ_RULES_SEQ AS

1: PACKAGE BODY CZ_RULES_SEQ AS
2: /* $Header: czrseqb.pls 115.26 2004/06/07 16:02:13 rheramba ship $ */
3:
4: GLOBAL_RUN_ID INTEGER:=0;
5: EPOCH_BEGIN DATE:=CZ_UTILS.EPOCH_BEGIN_;

Line 40: LOG_REPORT('CZ_RULES_SEQ',l_message_text);

36: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);
37: ELSE
38: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token,p_value);
39: END IF;
40: LOG_REPORT('CZ_RULES_SEQ',l_message_text);
41: END FND_REPORT;
42:
43: PROCEDURE FND_REPORT
44: (p_message_name IN VARCHAR2,

Line 58: LOG_REPORT('CZ_RULES_SEQ',l_message_text);

54: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token1,p_value1);
55: ELSE
56: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token1,p_value1,p_token2,p_value2);
57: END IF;
58: LOG_REPORT('CZ_RULES_SEQ',l_message_text);
59: END FND_REPORT;
60:
61: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
62: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 351: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

347:
348: EXCEPTION
349: WHEN NO_DATA_FOUND THEN
350: p_out_err:=GLOBAL_RUN_ID;
351: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
352: WHEN OTHERS THEN
353: p_out_err:=GLOBAL_RUN_ID;
354: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
355: END;

Line 354: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

350: p_out_err:=GLOBAL_RUN_ID;
351: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
352: WHEN OTHERS THEN
353: p_out_err:=GLOBAL_RUN_ID;
354: LOG_REPORT('CZ_RULES_SEQ.RemoveFromSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
355: END;
356:
357: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
358: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 564: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

560:
561: EXCEPTION
562: WHEN NO_DATA_FOUND THEN
563: p_out_err:=GLOBAL_RUN_ID;
564: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
565: WHEN OTHERS THEN
566: p_out_err:=GLOBAL_RUN_ID;
567: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
568: END;

Line 567: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

563: p_out_err:=GLOBAL_RUN_ID;
564: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
565: WHEN OTHERS THEN
566: p_out_err:=GLOBAL_RUN_ID;
567: LOG_REPORT('CZ_RULES_SEQ.MoveInSequence','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
568: END;
569:
570: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
571: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 694: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

690: WHEN END_OPERATION THEN
691: NULL;
692: WHEN NO_DATA_FOUND THEN
693: p_out_err:=1;
694: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
695: WHEN OTHERS THEN
696: p_out_err:=2;
697: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
698: END;

Line 697: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);

693: p_out_err:=1;
694: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
695: WHEN OTHERS THEN
696: p_out_err:=2;
697: LOG_REPORT('CZ_RULES_SEQ.ChangeEffectivity','rule_id='||TO_CHAR(p_rule_id)||' : '||SQLERRM);
698: END;
699:
700: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
701: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 812: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);

808: FND_REPORT('CZ_EFF_SET_NEXT_OVERLAP','EFFNAME',var_eff_name,'RULENAME',var_name);
809: WHEN NO_DATA_FOUND THEN
810: p_out_err:=GLOBAL_RUN_ID;
811: SELECT name INTO var_name FROM CZ_RULES WHERE rule_id=var_right_rule_id;
812: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);
813: WHEN OTHERS THEN
814: p_out_err:=GLOBAL_RUN_ID;
815: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);
816: END;

Line 815: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);

811: SELECT name INTO var_name FROM CZ_RULES WHERE rule_id=var_right_rule_id;
812: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);
813: WHEN OTHERS THEN
814: p_out_err:=GLOBAL_RUN_ID;
815: LOG_REPORT('CZ_RULES_SEQ','effectivity "'||var_eff_name||'" : '||SQLERRM);
816: END;
817:
818: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
819: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/