DBA Data[Home] [Help]

APPS.CZ_RULES_SEQ dependencies on CZ_UTILS

Line 5: EPOCH_BEGIN DATE:=CZ_UTILS.EPOCH_BEGIN_;

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_;
6: EPOCH_END DATE:=CZ_UTILS.EPOCH_END_;
7: NULL_VALUE CONSTANT INTEGER:=-1;
8:
9: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 6: EPOCH_END DATE:=CZ_UTILS.EPOCH_END_;

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_;
6: EPOCH_END DATE:=CZ_UTILS.EPOCH_END_;
7: NULL_VALUE CONSTANT INTEGER:=-1;
8:
9: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 19: l_return := cz_utils.log_report(Msg => p_error_message,

15:
16: l_return BOOLEAN;
17:
18: BEGIN
19: l_return := cz_utils.log_report(Msg => p_error_message,
20: Urgency => 1,
21: ByCaller => p_caller,
22: StatusCode => 11276,
23: RunId => GLOBAL_RUN_ID);

Line 36: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);

32: p_value IN VARCHAR2) IS
33: l_message_text VARCHAR2(32000);
34: BEGIN
35: IF p_token IS NULL THEN
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);

Line 38: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token,p_value);

34: BEGIN
35: IF p_token IS NULL THEN
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:

Line 52: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);

48: p_value2 IN VARCHAR2) IS
49: l_message_text VARCHAR2(32000);
50: BEGIN
51: IF p_token1 IS NULL THEN
52: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);
53: ELSIF p_token2 IS NULL THEN
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);

Line 54: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token1,p_value1);

50: BEGIN
51: IF p_token1 IS NULL THEN
52: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);
53: ELSIF p_token2 IS NULL THEN
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);

Line 56: l_message_text := CZ_UTILS.GET_TEXT(p_message_name,p_token1,p_value1,p_token2,p_value2);

52: l_message_text := CZ_UTILS.GET_TEXT(p_message_name);
53: ELSIF p_token2 IS NULL THEN
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:

Line 774: AND var_right_eff_to<>CZ_UTILS.EPOCH_BEGIN_ THEN

770: RAISE LEFT_OVERLAP;
771: END IF;
772:
773: IF p_new_end_date>var_right_eff_to
774: AND var_right_eff_to<>CZ_UTILS.EPOCH_BEGIN_ THEN
775: RAISE RIGHT_OVERLAP;
776: END IF;
777:
778: IF (var_left_set_id<>NULL_VALUE AND var_left_set_id IS NOT NULL) AND

Line 779: (var_left_eff_from=CZ_UTILS.EPOCH_END_ AND var_left_eff_to=CZ_UTILS.EPOCH_BEGIN_) THEN

775: RAISE RIGHT_OVERLAP;
776: END IF;
777:
778: IF (var_left_set_id<>NULL_VALUE AND var_left_set_id IS NOT NULL) AND
779: (var_left_eff_from=CZ_UTILS.EPOCH_END_ AND var_left_eff_to=CZ_UTILS.EPOCH_BEGIN_) THEN
780:
781: NULL;
782: ELSE
783: set_Dates(var_left_rule_id,var_left_eff_from,p_new_start_date,NULL_VALUE);

Line 788: (var_right_eff_from=CZ_UTILS.EPOCH_END_ AND var_right_eff_to=CZ_UTILS.EPOCH_BEGIN_) THEN

784: END IF;
785:
786:
787: IF (var_right_set_id<>NULL_VALUE AND var_right_set_id IS NOT NULL) AND
788: (var_right_eff_from=CZ_UTILS.EPOCH_END_ AND var_right_eff_to=CZ_UTILS.EPOCH_BEGIN_) THEN
789: NULL;
790: ELSE
791: set_Dates(var_right_rule_id,p_new_end_date,var_right_eff_to,NULL_VALUE);
792: END IF;