20: EXCEPTION
21: WHEN FND_API.G_EXC_ERROR THEN
22: ROLLBACK TO ahl_prd_workorder_cuhk;
23: x_return_status := FND_API.G_RET_STS_ERROR;
24: FND_MSG_PUB.count_and_get(
25: p_encoded => FND_API.G_FALSE,
26: p_count => x_msg_count,
27: p_data => x_msg_data);
28:
28:
29: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
30: ROLLBACK TO ahl_prd_workorder_cuhk;
31: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
32: FND_MSG_PUB.count_and_get(
33: p_encoded => FND_API.G_FALSE,
34: p_count => x_msg_count,
35: p_data => x_msg_data);
36:
36:
37: WHEN OTHERS THEN
38: ROLLBACK TO ahl_prd_workorder_cuhk;
39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
40: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
41: FND_MSG_PUB.add_exc_msg(
42: p_pkg_name => G_PKG_NAME,
43: p_procedure_name => l_api_name,
44: p_error_text => SUBSTRB(SQLERRM,1,240));
37: WHEN OTHERS THEN
38: ROLLBACK TO ahl_prd_workorder_cuhk;
39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
40: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
41: FND_MSG_PUB.add_exc_msg(
42: p_pkg_name => G_PKG_NAME,
43: p_procedure_name => l_api_name,
44: p_error_text => SUBSTRB(SQLERRM,1,240));
45: END IF;
42: p_pkg_name => G_PKG_NAME,
43: p_procedure_name => l_api_name,
44: p_error_text => SUBSTRB(SQLERRM,1,240));
45: END IF;
46: FND_MSG_PUB.count_and_get(
47: p_encoded => FND_API.G_FALSE,
48: p_count => x_msg_count,
49: p_data => x_msg_data);
50:
73: EXCEPTION
74: WHEN FND_API.G_EXC_ERROR THEN
75: ROLLBACK TO ahl_prd_workorder_cuhk;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.G_FALSE,
79: p_count => x_msg_count,
80: p_data => x_msg_data);
81:
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: ROLLBACK TO ahl_prd_workorder_cuhk;
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.G_FALSE,
87: p_count => x_msg_count,
88: p_data => x_msg_data);
89:
89:
90: WHEN OTHERS THEN
91: ROLLBACK TO ahl_prd_workorder_cuhk;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
94: FND_MSG_PUB.add_exc_msg(
95: p_pkg_name => G_PKG_NAME,
96: p_procedure_name => l_api_name,
97: p_error_text => SUBSTRB(SQLERRM,1,240));
90: WHEN OTHERS THEN
91: ROLLBACK TO ahl_prd_workorder_cuhk;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
94: FND_MSG_PUB.add_exc_msg(
95: p_pkg_name => G_PKG_NAME,
96: p_procedure_name => l_api_name,
97: p_error_text => SUBSTRB(SQLERRM,1,240));
98: END IF;
95: p_pkg_name => G_PKG_NAME,
96: p_procedure_name => l_api_name,
97: p_error_text => SUBSTRB(SQLERRM,1,240));
98: END IF;
99: FND_MSG_PUB.count_and_get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO ahl_prd_workorder_cuhk;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.count_and_get(
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,
130: p_data => x_msg_data);
131:
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO ahl_prd_workorder_cuhk;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data);
139:
139:
140: WHEN OTHERS THEN
141: ROLLBACK TO ahl_prd_workorder_cuhk;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.add_exc_msg(
145: p_pkg_name => G_PKG_NAME,
146: p_procedure_name => l_api_name,
147: p_error_text => SUBSTRB(SQLERRM,1,240));
140: WHEN OTHERS THEN
141: ROLLBACK TO ahl_prd_workorder_cuhk;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.add_exc_msg(
145: p_pkg_name => G_PKG_NAME,
146: p_procedure_name => l_api_name,
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148: END IF;
145: p_pkg_name => G_PKG_NAME,
146: p_procedure_name => l_api_name,
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148: END IF;
149: FND_MSG_PUB.count_and_get(
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:
173: EXCEPTION
174: WHEN FND_API.G_EXC_ERROR THEN
175: ROLLBACK TO ahl_prd_workorder_cuhk;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: FND_MSG_PUB.count_and_get(
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data);
181:
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO ahl_prd_workorder_cuhk;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.count_and_get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,
188: p_data => x_msg_data);
189:
189:
190: WHEN OTHERS THEN
191: ROLLBACK TO ahl_prd_workorder_cuhk;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(
195: p_pkg_name => G_PKG_NAME,
196: p_procedure_name => l_api_name,
197: p_error_text => SUBSTRB(SQLERRM,1,240));
190: WHEN OTHERS THEN
191: ROLLBACK TO ahl_prd_workorder_cuhk;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(
195: p_pkg_name => G_PKG_NAME,
196: p_procedure_name => l_api_name,
197: p_error_text => SUBSTRB(SQLERRM,1,240));
198: END IF;
195: p_pkg_name => G_PKG_NAME,
196: p_procedure_name => l_api_name,
197: p_error_text => SUBSTRB(SQLERRM,1,240));
198: END IF;
199: FND_MSG_PUB.count_and_get(
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203: