70: OPEN c_task_type_id;
71: FETCH c_task_type_id into l_task_type_id;
72: CLOSE c_task_type_id;
73: END IF;
74: PA_DEBUG.WRITE('Inside Table handler','Before Insert',3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
71: FETCH c_task_type_id into l_task_type_id;
72: CLOSE c_task_type_id;
73: END IF;
74: PA_DEBUG.WRITE('Inside Table handler','Before Insert',3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
72: CLOSE c_task_type_id;
73: END IF;
74: PA_DEBUG.WRITE('Inside Table handler','Before Insert',3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
73: END IF;
74: PA_DEBUG.WRITE('Inside Table handler','Before Insert',3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
74: PA_DEBUG.WRITE('Inside Table handler','Before Insert',3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
75: PA_DEBUG.WRITE('Inside Table handler','Task Type Id'||l_task_type_id,3);
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
83: ---end of insert by avaithia
76: PA_DEBUG.WRITE('Inside Table handler','pa_task_type '||p_task_type,3);
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
83: ---end of insert by avaithia
84: -------------------------------------------------------------------------------------------------------------
77: PA_DEBUG.WRITE('Inside Table handler','eff from '||p_start_date_active,3);
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
83: ---end of insert by avaithia
84: -------------------------------------------------------------------------------------------------------------
85:
78: PA_DEBUG.WRITE('Inside Table handler','eff to '||p_end_date_active,3);
79: PA_DEBUG.WRITE('Inside Table handler','p_task_type_class_code '||p_task_type_class_code,3);
80: PA_DEBUG.WRITE('Inside Table handler','p_initial_status_code '||p_initial_status_code,3);
81: PA_DEBUG.WRITE('Inside Table handler','p_prog_entry_enable_flag '||p_prog_entry_enable_flag,3);
82: PA_DEBUG.WRITE('Inside Table handler','p_record_version_number '||p_record_version_number,3);
83: ---end of insert by avaithia
84: -------------------------------------------------------------------------------------------------------------
85:
86: INSERT INTO pa_task_types
181: )
182: RETURNING l_task_type_id INTO x_task_type_id;
183:
184:
185: PA_DEBUG.WRITE('Inside Table handler','After Insert'||l_task_type_id,
186: 3);
187:
188:
189: EXCEPTION
189: EXCEPTION
190: WHEN OTHERS THEN
191: -- Set the excetption Message and the stack
192: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.insert_row'
193: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
194: --
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: RAISE;
197:
303: EXCEPTION
304: WHEN OTHERS THEN
305: -- Set the excetption Message and the stack
306: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.update_row'
307: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
308: --
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: RAISE;
311:
346: EXCEPTION
347: WHEN OTHERS THEN
348: -- Set the excetption Message and the stack
349: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_TYPE_PKG.delete_row'
350: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: RAISE;
353:
354: END delete_row;