26: SAVEPOINT create_ci_type_usage;
27: END IF;
28:
29: IF p_init_msg_list = FND_API.G_TRUE THEN
30: fnd_msg_pub.initialize;
31: END IF;
32:
33: x_return_status := 'S';
34: x_msg_count := 0;
54: ROLLBACK TO create_ci_type_usage;
55: END IF;
56: END IF;
57:
58: fnd_msg_pub.count_and_get(p_count => x_msg_count,
59: p_data => x_msg_data);
60:
61: pa_debug.reset_err_stack;
62:
66: ROLLBACK TO create_ci_type_usage;
67: END IF;
68:
69: x_return_status := 'U';
70: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
71: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
72: p_error_text => SUBSTRB(SQLERRM,1,240));
73:
74: fnd_msg_pub.count_and_get(p_count => x_msg_count,
70: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
71: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
72: p_error_text => SUBSTRB(SQLERRM,1,240));
73:
74: fnd_msg_pub.count_and_get(p_count => x_msg_count,
75: p_data => x_msg_data);
76: END create_ci_type_usage;
77:
78: PROCEDURE update_ci_type_usage (
99: SAVEPOINT update_ci_type_usage;
100: END IF;
101:
102: IF p_init_msg_list = FND_API.G_TRUE THEN
103: fnd_msg_pub.initialize;
104: END IF;
105:
106: x_return_status := 'S';
107: x_msg_count := 0;
124: ROLLBACK TO update_ci_type_usage;
125: END IF;
126: END IF;
127:
128: fnd_msg_pub.count_and_get(p_count => x_msg_count,
129: p_data => x_msg_data);
130:
131: pa_debug.reset_err_stack;
132:
136: ROLLBACK TO update_ci_type_usage;
137: END IF;
138:
139: x_return_status := 'U';
140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
141: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
142: p_error_text => SUBSTRB(SQLERRM,1,240));
143:
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,
140: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PVT',
141: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
142: p_error_text => SUBSTRB(SQLERRM,1,240));
143:
144: fnd_msg_pub.count_and_get(p_count => x_msg_count,
145: p_data => x_msg_data);
146: END update_ci_type_usage;
147:
148: PROCEDURE delete_ci_type_usage (
167: SAVEPOINT delete_ci_type_usage;
168: END IF;
169:
170: IF p_init_msg_list = FND_API.G_TRUE THEN
171: fnd_msg_pub.initialize;
172: END IF;
173:
174: x_return_status := 'S';
175: x_msg_count := 0;
193: ROLLBACK TO delete_ci_type_usage;
194: END IF;
195: END IF;
196:
197: fnd_msg_pub.count_and_get(p_count => x_msg_count,
198: p_data => x_msg_data);
199:
200: pa_debug.reset_err_stack;
201:
205: ROLLBACK TO delete_ci_type_usage;
206: END IF;
207:
208: x_return_status := 'U';
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
210: p_procedure_name => 'DELETE_CI_TYPE_USAGE',
211: p_error_text => SUBSTRB(SQLERRM,1,240));
212:
213: fnd_msg_pub.count_and_get(p_count => x_msg_count,
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PVT',
210: p_procedure_name => 'DELETE_CI_TYPE_USAGE',
211: p_error_text => SUBSTRB(SQLERRM,1,240));
212:
213: fnd_msg_pub.count_and_get(p_count => x_msg_count,
214: p_data => x_msg_data);
215: END delete_ci_type_usage;
216:
217: END pa_ci_type_usage_pvt;