DBA Data[Home] [Help]

APPS.PO_VAL_PRICE_ADJS dependencies on PO_LOG

Line 13: PO_LOG.get_package_base('PO_VAL_PRICE_ADJS');

9: c_CHANGE_REASON_TEXT CONSTANT VARCHAR2(30) := 'CHANGE_REASON_TEXT';
10:
11: -- The module base for this package.
12: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
13: PO_LOG.get_package_base('PO_VAL_PRICE_ADJS');
14:
15: -- The module base for the subprogram.
16: D_ovr_chng_reas_code_not_null CONSTANT VARCHAR2(100) :=
17: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_code_not_null');

Line 17: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_code_not_null');

13: PO_LOG.get_package_base('PO_VAL_PRICE_ADJS');
14:
15: -- The module base for the subprogram.
16: D_ovr_chng_reas_code_not_null CONSTANT VARCHAR2(100) :=
17: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_code_not_null');
18:
19: -- The module base for the subprogram.
20: D_ovr_chng_reas_text_not_null CONSTANT VARCHAR2(100) :=
21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_text_not_null');

Line 21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_text_not_null');

17: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_code_not_null');
18:
19: -- The module base for the subprogram.
20: D_ovr_chng_reas_text_not_null CONSTANT VARCHAR2(100) :=
21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'ovr_chng_reas_text_not_null');
22:
23: ----------------------------------------------------------------------------------------------
24: -- Ensures that the change reason code is not null if the updated flag is Y
25: ----------------------------------------------------------------------------------------------

Line 42: IF PO_LOG.d_proc THEN

38: IF (x_results IS NULL) THEN
39: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
40: END IF;
41:
42: IF PO_LOG.d_proc THEN
43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);
46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);

39: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
40: END IF;
41:
42: IF PO_LOG.d_proc THEN
43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);
46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
47: END IF;

Line 44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);

40: END IF;
41:
42: IF PO_LOG.d_proc THEN
43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);
46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
47: END IF;
48:

Line 45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);

41:
42: IF PO_LOG.d_proc THEN
43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);
46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
47: END IF;
48:
49: l_results_count := x_results.result_type.COUNT;

Line 46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

42: IF PO_LOG.d_proc THEN
43: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
44: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
45: PO_LOG.proc_begin(d_mod,'p_change_reason_code_tbl',p_change_reason_code_tbl);
46: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
47: END IF;
48:
49: l_results_count := x_results.result_type.COUNT;
50:

Line 69: IF PO_LOG.d_proc THEN

65: ELSE
66: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
67: END IF;
68:
69: IF PO_LOG.d_proc THEN
70: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
71: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
72: END IF;
73:

Line 70: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

66: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
67: END IF;
68:
69: IF PO_LOG.d_proc THEN
70: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
71: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
72: END IF;
73:
74: EXCEPTION

Line 71: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

67: END IF;
68:
69: IF PO_LOG.d_proc THEN
70: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
71: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
72: END IF;
73:
74: EXCEPTION
75: WHEN OTHERS THEN

Line 76: IF PO_LOG.d_exc THEN

72: END IF;
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: IF PO_LOG.d_exc THEN
77: PO_LOG.exc(d_mod,0,NULL);
78: END IF;
79: RAISE;
80: END ovr_chng_reas_code_not_null;

Line 77: PO_LOG.exc(d_mod,0,NULL);

73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: IF PO_LOG.d_exc THEN
77: PO_LOG.exc(d_mod,0,NULL);
78: END IF;
79: RAISE;
80: END ovr_chng_reas_code_not_null;
81:

Line 101: IF PO_LOG.d_proc THEN

97: IF (x_results IS NULL) THEN
98: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
99: END IF;
100:
101: IF PO_LOG.d_proc THEN
102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);
105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

Line 102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);

98: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
99: END IF;
100:
101: IF PO_LOG.d_proc THEN
102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);
105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
106: END IF;

Line 103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);

99: END IF;
100:
101: IF PO_LOG.d_proc THEN
102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);
105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
106: END IF;
107:

Line 104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);

100:
101: IF PO_LOG.d_proc THEN
102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);
105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
106: END IF;
107:
108: l_results_count := x_results.result_type.COUNT;

Line 105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);

101: IF PO_LOG.d_proc THEN
102: PO_LOG.proc_begin(d_mod,'p_price_adj_id_tbl',p_price_adj_id_tbl);
103: PO_LOG.proc_begin(d_mod,'p_updated_flag_tbl',p_updated_flag_tbl);
104: PO_LOG.proc_begin(d_mod,'p_change_reason_text_tbl',p_change_reason_text_tbl);
105: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
106: END IF;
107:
108: l_results_count := x_results.result_type.COUNT;
109:

Line 128: IF PO_LOG.d_proc THEN

124: ELSE
125: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
126: END IF;
127:
128: IF PO_LOG.d_proc THEN
129: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
130: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
131: END IF;
132:

Line 129: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

125: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
126: END IF;
127:
128: IF PO_LOG.d_proc THEN
129: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
130: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
131: END IF;
132:
133: EXCEPTION

Line 130: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);

126: END IF;
127:
128: IF PO_LOG.d_proc THEN
129: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
130: PO_LOG.log(PO_LOG.c_PROC_END,d_mod,NULL,'x_results',x_results);
131: END IF;
132:
133: EXCEPTION
134: WHEN OTHERS THEN

Line 135: IF PO_LOG.d_exc THEN

131: END IF;
132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF PO_LOG.d_exc THEN
136: PO_LOG.exc(d_mod,0,NULL);
137: END IF;
138: RAISE;
139: END ovr_chng_reas_text_not_null;

Line 136: PO_LOG.exc(d_mod,0,NULL);

132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: IF PO_LOG.d_exc THEN
136: PO_LOG.exc(d_mod,0,NULL);
137: END IF;
138: RAISE;
139: END ovr_chng_reas_text_not_null;
140: