40: BEGIN
41:
42: x_msg_count := 0;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
45:
46: IF l_debug_mode = 'Y' THEN
47: pa_debug.set_curr_function( p_function => 'CREATE_GANTT_CONFIG',
48: p_debug_mode => l_debug_mode );
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
45:
46: IF l_debug_mode = 'Y' THEN
47: pa_debug.set_curr_function( p_function => 'CREATE_GANTT_CONFIG',
48: p_debug_mode => l_debug_mode );
49: END IF;
50:
51: -- Check for business rules violations
50:
51: -- Check for business rules violations
52:
53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(g_module_name,pa_debug.g_err_stage,
56: l_debug_level3);
57: END IF;
58:
51: -- Check for business rules violations
52:
53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(g_module_name,pa_debug.g_err_stage,
56: l_debug_level3);
57: END IF;
58:
59: IF l_debug_mode = 'Y' THEN
56: l_debug_level3);
57: END IF;
58:
59: IF l_debug_mode = 'Y' THEN
60: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
61: pa_debug.write(g_module_name,pa_debug.g_err_stage,
62: l_debug_level5);
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
57: END IF;
58:
59: IF l_debug_mode = 'Y' THEN
60: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
61: pa_debug.write(g_module_name,pa_debug.g_err_stage,
62: l_debug_level5);
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
65: l_debug_level5);
59: IF l_debug_mode = 'Y' THEN
60: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
61: pa_debug.write(g_module_name,pa_debug.g_err_stage,
62: l_debug_level5);
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
65: l_debug_level5);
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
60: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
61: pa_debug.write(g_module_name,pa_debug.g_err_stage,
62: l_debug_level5);
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
65: l_debug_level5);
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level5);
62: l_debug_level5);
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
65: l_debug_level5);
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level5);
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
63: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
64: pa_debug.write(g_module_name,pa_debug.g_err_stage,
65: l_debug_level5);
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level5);
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
71: l_debug_level5);
65: l_debug_level5);
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level5);
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
71: l_debug_level5);
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
66: pa_debug.g_err_stage:= 'p_name = '|| p_name;
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level5);
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
71: l_debug_level5);
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
74: l_debug_level5);
68: l_debug_level5);
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
71: l_debug_level5);
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
74: l_debug_level5);
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
69: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
70: pa_debug.write(g_module_name,pa_debug.g_err_stage,
71: l_debug_level5);
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
74: l_debug_level5);
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
77: l_debug_level5);
71: l_debug_level5);
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
74: l_debug_level5);
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
77: l_debug_level5);
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
72: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
73: pa_debug.write(g_module_name,pa_debug.g_err_stage,
74: l_debug_level5);
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
77: l_debug_level5);
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
80: l_debug_level5);
74: l_debug_level5);
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
77: l_debug_level5);
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
80: l_debug_level5);
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
75: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
76: pa_debug.write(g_module_name,pa_debug.g_err_stage,
77: l_debug_level5);
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
80: l_debug_level5);
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
83: l_debug_level5);
77: l_debug_level5);
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
80: l_debug_level5);
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
83: l_debug_level5);
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
78: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
79: pa_debug.write(g_module_name,pa_debug.g_err_stage,
80: l_debug_level5);
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
83: l_debug_level5);
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
86: l_debug_level5);
80: l_debug_level5);
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
83: l_debug_level5);
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
86: l_debug_level5);
87: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
88: pa_debug.write(g_module_name,pa_debug.g_err_stage,
81: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
82: pa_debug.write(g_module_name,pa_debug.g_err_stage,
83: l_debug_level5);
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
86: l_debug_level5);
87: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
88: pa_debug.write(g_module_name,pa_debug.g_err_stage,
89: l_debug_level5);
83: l_debug_level5);
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
86: l_debug_level5);
87: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
88: pa_debug.write(g_module_name,pa_debug.g_err_stage,
89: l_debug_level5);
90:
91: END IF;
84: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
85: pa_debug.write(g_module_name,pa_debug.g_err_stage,
86: l_debug_level5);
87: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
88: pa_debug.write(g_module_name,pa_debug.g_err_stage,
89: l_debug_level5);
90:
91: END IF;
92:
130: );
131:
132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
133: IF l_debug_mode = 'Y' THEN
134: pa_debug.g_err_stage := 'Error in creating gantt config ';
135: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
136: END IF;
137: Raise Invalid_Arg_Exc_GC;
138: END IF;
131:
132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
133: IF l_debug_mode = 'Y' THEN
134: pa_debug.g_err_stage := 'Error in creating gantt config ';
135: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
136: END IF;
137: Raise Invalid_Arg_Exc_GC;
138: END IF;
139:
137: Raise Invalid_Arg_Exc_GC;
138: END IF;
139:
140: IF l_debug_mode = 'Y' THEN
141: pa_debug.g_err_stage:= 'gantt config id : ' || px_gantt_config_id;
142: pa_debug.write(g_module_name,pa_debug.g_err_stage,
143: l_debug_level3);
144: END IF;
145:
138: END IF;
139:
140: IF l_debug_mode = 'Y' THEN
141: pa_debug.g_err_stage:= 'gantt config id : ' || px_gantt_config_id;
142: pa_debug.write(g_module_name,pa_debug.g_err_stage,
143: l_debug_level3);
144: END IF;
145:
146: IF l_debug_mode = 'Y' THEN
143: l_debug_level3);
144: END IF;
145:
146: IF l_debug_mode = 'Y' THEN
147: pa_debug.g_err_stage:= 'Exiting CREATE_GANTT_CONFIG';
148: pa_debug.write(g_module_name,pa_debug.g_err_stage,
149: l_debug_level3);
150: pa_debug.reset_curr_function;
151: END IF;
144: END IF;
145:
146: IF l_debug_mode = 'Y' THEN
147: pa_debug.g_err_stage:= 'Exiting CREATE_GANTT_CONFIG';
148: pa_debug.write(g_module_name,pa_debug.g_err_stage,
149: l_debug_level3);
150: pa_debug.reset_curr_function;
151: END IF;
152: EXCEPTION
146: IF l_debug_mode = 'Y' THEN
147: pa_debug.g_err_stage:= 'Exiting CREATE_GANTT_CONFIG';
148: pa_debug.write(g_module_name,pa_debug.g_err_stage,
149: l_debug_level3);
150: pa_debug.reset_curr_function;
151: END IF;
152: EXCEPTION
153:
154: WHEN Invalid_Arg_Exc_GC THEN
169: ELSE
170: x_msg_count := l_msg_count;
171: END IF;
172: IF l_debug_mode = 'Y' THEN
173: pa_debug.reset_curr_function;
174: END IF;
175:
176: RETURN;
177:
186: ,p_procedure_name => 'CREATE_GANTT_CONFIG'
187: ,p_error_text => x_msg_data);
188:
189: IF l_debug_mode = 'Y' THEN
190: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
191: pa_debug.write(g_module_name,pa_debug.g_err_stage,
192: l_debug_level5);
193: pa_debug.reset_curr_function;
194: END IF;
187: ,p_error_text => x_msg_data);
188:
189: IF l_debug_mode = 'Y' THEN
190: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
191: pa_debug.write(g_module_name,pa_debug.g_err_stage,
192: l_debug_level5);
193: pa_debug.reset_curr_function;
194: END IF;
195: RAISE;
189: IF l_debug_mode = 'Y' THEN
190: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
191: pa_debug.write(g_module_name,pa_debug.g_err_stage,
192: l_debug_level5);
193: pa_debug.reset_curr_function;
194: END IF;
195: RAISE;
196: END CREATE_GANTT_CONFIG;
197:
232: BEGIN
233:
234: x_msg_count := 0;
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
237:
238: IF l_debug_mode = 'Y' THEN
239: pa_debug.set_curr_function( p_function => 'UPDATE_GANTT_CONFIG',
240: p_debug_mode => l_debug_mode );
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
237:
238: IF l_debug_mode = 'Y' THEN
239: pa_debug.set_curr_function( p_function => 'UPDATE_GANTT_CONFIG',
240: p_debug_mode => l_debug_mode );
241: END IF;
242:
243: -- Check for business rules violations
241: END IF;
242:
243: -- Check for business rules violations
244: IF l_debug_mode = 'Y' THEN
245: pa_debug.g_err_stage:= 'Validating input parameters';
246: pa_debug.write(g_module_name,pa_debug.g_err_stage,
247: l_debug_level3);
248: END IF;
249:
242:
243: -- Check for business rules violations
244: IF l_debug_mode = 'Y' THEN
245: pa_debug.g_err_stage:= 'Validating input parameters';
246: pa_debug.write(g_module_name,pa_debug.g_err_stage,
247: l_debug_level3);
248: END IF;
249:
250: IF l_debug_mode = 'Y' THEN
247: l_debug_level3);
248: END IF;
249:
250: IF l_debug_mode = 'Y' THEN
251: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
252: pa_debug.write(g_module_name,pa_debug.g_err_stage,
253: l_debug_level5);
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
248: END IF;
249:
250: IF l_debug_mode = 'Y' THEN
251: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
252: pa_debug.write(g_module_name,pa_debug.g_err_stage,
253: l_debug_level5);
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
256: l_debug_level5);
250: IF l_debug_mode = 'Y' THEN
251: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
252: pa_debug.write(g_module_name,pa_debug.g_err_stage,
253: l_debug_level5);
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
256: l_debug_level5);
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
251: pa_debug.g_err_stage:= 'p_gantt_view_id = '|| p_gantt_view_id;
252: pa_debug.write(g_module_name,pa_debug.g_err_stage,
253: l_debug_level5);
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
256: l_debug_level5);
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
259: l_debug_level5);
253: l_debug_level5);
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
256: l_debug_level5);
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
259: l_debug_level5);
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
254: pa_debug.g_err_stage:= 'p_gantt_config_usage = '|| p_gantt_config_usage;
255: pa_debug.write(g_module_name,pa_debug.g_err_stage,
256: l_debug_level5);
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
259: l_debug_level5);
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
262: l_debug_level5);
256: l_debug_level5);
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
259: l_debug_level5);
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
262: l_debug_level5);
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
257: pa_debug.g_err_stage:= 'p_name = '|| p_name;
258: pa_debug.write(g_module_name,pa_debug.g_err_stage,
259: l_debug_level5);
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
262: l_debug_level5);
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
265: l_debug_level5);
259: l_debug_level5);
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
262: l_debug_level5);
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
265: l_debug_level5);
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
260: pa_debug.g_err_stage:= 'p_filter_code = '|| p_filter_code;
261: pa_debug.write(g_module_name,pa_debug.g_err_stage,
262: l_debug_level5);
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
265: l_debug_level5);
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
268: l_debug_level5);
262: l_debug_level5);
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
265: l_debug_level5);
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
268: l_debug_level5);
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
263: pa_debug.g_err_stage:= 'p_time_scale_code = '|| p_time_scale_code;
264: pa_debug.write(g_module_name,pa_debug.g_err_stage,
265: l_debug_level5);
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
268: l_debug_level5);
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level5);
265: l_debug_level5);
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
268: l_debug_level5);
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level5);
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
266: pa_debug.g_err_stage:= 'p_number_of_displayed_rows = '|| p_number_of_displayed_rows;
267: pa_debug.write(g_module_name,pa_debug.g_err_stage,
268: l_debug_level5);
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level5);
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
274: l_debug_level5);
268: l_debug_level5);
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level5);
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
274: l_debug_level5);
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
269: pa_debug.g_err_stage:= 'p_expand_collapse_flag = '|| p_expand_collapse_flag;
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level5);
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
274: l_debug_level5);
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
277: l_debug_level5);
271: l_debug_level5);
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
274: l_debug_level5);
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
277: l_debug_level5);
278: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
279: pa_debug.write(g_module_name,pa_debug.g_err_stage,
272: pa_debug.g_err_stage:= 'p_show_additional_col_flag = '|| p_show_additional_col_flag;
273: pa_debug.write(g_module_name,pa_debug.g_err_stage,
274: l_debug_level5);
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
277: l_debug_level5);
278: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
279: pa_debug.write(g_module_name,pa_debug.g_err_stage,
280: l_debug_level5);
274: l_debug_level5);
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
277: l_debug_level5);
278: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
279: pa_debug.write(g_module_name,pa_debug.g_err_stage,
280: l_debug_level5);
281: END IF;
282:
275: pa_debug.g_err_stage:= 'p_focus_enabled_flag = '|| p_focus_enabled_flag;
276: pa_debug.write(g_module_name,pa_debug.g_err_stage,
277: l_debug_level5);
278: pa_debug.g_err_stage:= 'p_show_header_ui_flag = '|| p_show_header_ui_flag;
279: pa_debug.write(g_module_name,pa_debug.g_err_stage,
280: l_debug_level5);
281: END IF;
282:
283: IF (p_gantt_view_id IS NULL) OR
320: ,X_MSG_DATA => X_MSG_DATA
321: );
322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
323: IF l_debug_mode = 'Y' THEN
324: pa_debug.g_err_stage := 'Error in updating gantt config ';
325: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
326: END IF;
327: Raise Invalid_Arg_Exc_GC;
328: END IF;
321: );
322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
323: IF l_debug_mode = 'Y' THEN
324: pa_debug.g_err_stage := 'Error in updating gantt config ';
325: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
326: END IF;
327: Raise Invalid_Arg_Exc_GC;
328: END IF;
329:
327: Raise Invalid_Arg_Exc_GC;
328: END IF;
329:
330: IF l_debug_mode = 'Y' THEN
331: pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';
332: pa_debug.write(g_module_name,pa_debug.g_err_stage,
333: l_debug_level3);
334: pa_debug.reset_curr_function;
335: END IF;
328: END IF;
329:
330: IF l_debug_mode = 'Y' THEN
331: pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';
332: pa_debug.write(g_module_name,pa_debug.g_err_stage,
333: l_debug_level3);
334: pa_debug.reset_curr_function;
335: END IF;
336: EXCEPTION
330: IF l_debug_mode = 'Y' THEN
331: pa_debug.g_err_stage:= 'Exiting UPDATE_GANTT_CONFIG';
332: pa_debug.write(g_module_name,pa_debug.g_err_stage,
333: l_debug_level3);
334: pa_debug.reset_curr_function;
335: END IF;
336: EXCEPTION
337:
338: WHEN Invalid_Arg_Exc_GC THEN
353: ELSE
354: x_msg_count := l_msg_count;
355: END IF;
356: IF l_debug_mode = 'Y' THEN
357: pa_debug.reset_curr_function;
358: END IF;
359:
360: RETURN;
361:
370: ,p_procedure_name => 'UPDATE_GANTT_CONFIG'
371: ,p_error_text => x_msg_data);
372:
373: IF l_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
375: pa_debug.write(g_module_name,pa_debug.g_err_stage,
376: l_debug_level5);
377: pa_debug.reset_curr_function;
378: END IF;
371: ,p_error_text => x_msg_data);
372:
373: IF l_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
375: pa_debug.write(g_module_name,pa_debug.g_err_stage,
376: l_debug_level5);
377: pa_debug.reset_curr_function;
378: END IF;
379: RAISE;
373: IF l_debug_mode = 'Y' THEN
374: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
375: pa_debug.write(g_module_name,pa_debug.g_err_stage,
376: l_debug_level5);
377: pa_debug.reset_curr_function;
378: END IF;
379: RAISE;
380: END UPDATE_GANTT_CONFIG;
381:
405: BEGIN
406:
407: x_msg_count := 0;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
410:
411: IF l_debug_mode = 'Y' THEN
412: pa_debug.set_curr_function( p_function => 'DELETE_GANTT_CONFIG',
413: p_debug_mode => l_debug_mode );
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
410:
411: IF l_debug_mode = 'Y' THEN
412: pa_debug.set_curr_function( p_function => 'DELETE_GANTT_CONFIG',
413: p_debug_mode => l_debug_mode );
414: END IF;
415:
416: -- Check for business rules violations
414: END IF;
415:
416: -- Check for business rules violations
417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:= 'P_GANTT_CONFIG_ID = '|| P_GANTT_CONFIG_ID;
419: pa_debug.write(g_module_name,pa_debug.g_err_stage,
420: l_debug_level5);
421: pa_debug.g_err_stage:= 'P_RECORD_VERSION_NUMBER = '|| P_RECORD_VERSION_NUMBER;
422: pa_debug.write(g_module_name,pa_debug.g_err_stage,
415:
416: -- Check for business rules violations
417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:= 'P_GANTT_CONFIG_ID = '|| P_GANTT_CONFIG_ID;
419: pa_debug.write(g_module_name,pa_debug.g_err_stage,
420: l_debug_level5);
421: pa_debug.g_err_stage:= 'P_RECORD_VERSION_NUMBER = '|| P_RECORD_VERSION_NUMBER;
422: pa_debug.write(g_module_name,pa_debug.g_err_stage,
423: l_debug_level5);
417: IF l_debug_mode = 'Y' THEN
418: pa_debug.g_err_stage:= 'P_GANTT_CONFIG_ID = '|| P_GANTT_CONFIG_ID;
419: pa_debug.write(g_module_name,pa_debug.g_err_stage,
420: l_debug_level5);
421: pa_debug.g_err_stage:= 'P_RECORD_VERSION_NUMBER = '|| P_RECORD_VERSION_NUMBER;
422: pa_debug.write(g_module_name,pa_debug.g_err_stage,
423: l_debug_level5);
424: END IF;
425:
418: pa_debug.g_err_stage:= 'P_GANTT_CONFIG_ID = '|| P_GANTT_CONFIG_ID;
419: pa_debug.write(g_module_name,pa_debug.g_err_stage,
420: l_debug_level5);
421: pa_debug.g_err_stage:= 'P_RECORD_VERSION_NUMBER = '|| P_RECORD_VERSION_NUMBER;
422: pa_debug.write(g_module_name,pa_debug.g_err_stage,
423: l_debug_level5);
424: END IF;
425:
426: IF (P_GANTT_CONFIG_ID IS NULL) OR
443: );
444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: IF l_debug_mode = 'Y' THEN
447: pa_debug.g_err_stage := 'Error in deleting gantt config ';
448: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
449: END IF;
450: Raise Invalid_Arg_Exc_GC;
451: END IF;
444:
445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
446: IF l_debug_mode = 'Y' THEN
447: pa_debug.g_err_stage := 'Error in deleting gantt config ';
448: pa_debug.write(g_module_name,pa_debug.g_err_stage,l_debug_level4);
449: END IF;
450: Raise Invalid_Arg_Exc_GC;
451: END IF;
452:
450: Raise Invalid_Arg_Exc_GC;
451: END IF;
452:
453: IF l_debug_mode = 'Y' THEN
454: pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';
455: pa_debug.write(g_module_name,pa_debug.g_err_stage,
456: l_debug_level3);
457: pa_debug.reset_curr_function;
458: END IF;
451: END IF;
452:
453: IF l_debug_mode = 'Y' THEN
454: pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';
455: pa_debug.write(g_module_name,pa_debug.g_err_stage,
456: l_debug_level3);
457: pa_debug.reset_curr_function;
458: END IF;
459: EXCEPTION
453: IF l_debug_mode = 'Y' THEN
454: pa_debug.g_err_stage:= 'Exiting DELETE_GANTT_CONFIG';
455: pa_debug.write(g_module_name,pa_debug.g_err_stage,
456: l_debug_level3);
457: pa_debug.reset_curr_function;
458: END IF;
459: EXCEPTION
460:
461: WHEN Invalid_Arg_Exc_GC THEN
476: ELSE
477: x_msg_count := l_msg_count;
478: END IF;
479: IF l_debug_mode = 'Y' THEN
480: pa_debug.reset_curr_function;
481: END IF;
482:
483: RETURN;
484:
493: ,p_procedure_name => 'DELETE_GANTT_CONFIG'
494: ,p_error_text => x_msg_data);
495:
496: IF l_debug_mode = 'Y' THEN
497: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
498: pa_debug.write(g_module_name,pa_debug.g_err_stage,
499: l_debug_level5);
500: pa_debug.reset_curr_function;
501: END IF;
494: ,p_error_text => x_msg_data);
495:
496: IF l_debug_mode = 'Y' THEN
497: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
498: pa_debug.write(g_module_name,pa_debug.g_err_stage,
499: l_debug_level5);
500: pa_debug.reset_curr_function;
501: END IF;
502: RAISE;
496: IF l_debug_mode = 'Y' THEN
497: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
498: pa_debug.write(g_module_name,pa_debug.g_err_stage,
499: l_debug_level5);
500: pa_debug.reset_curr_function;
501: END IF;
502: RAISE;
503: END DELETE_GANTT_CONFIG;
504: