119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Initialize message list if p_init_msg_list is set to TRUE
122: IF FND_API.to_Boolean(p_init_msg_list) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126:
127: -- Debug info.
156:
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159:
160: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
161: p_count => x_msg_count,
162: p_data => x_msg_data);
163:
164: -- Debug info.
175: END IF;
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178:
179: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: -- Debug info.
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197:
198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
199: fnd_message.set_token('ERROR' ,SQLERRM);
200: fnd_msg_pub.add;
201:
202: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
203: p_count => x_msg_count,
204: p_data => x_msg_data);
198: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
199: fnd_message.set_token('ERROR' ,SQLERRM);
200: fnd_msg_pub.add;
201:
202: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
203: p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: -- Debug info.
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE
663: IF FND_API.to_Boolean(p_init_msg_list) THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667:
668: -- Debug info.
909:
910: WHEN fnd_api.g_exc_error THEN
911: x_return_status := fnd_api.g_ret_sts_error;
912:
913: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data);
916:
917: -- Debug info.
928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:
932: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935:
936: -- Debug info.
949: x_return_status := fnd_api.g_ret_sts_unexp_error;
950:
951: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
952: fnd_message.set_token('ERROR' ,SQLERRM);
953: fnd_msg_pub.add;
954:
955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
956: p_count => x_msg_count,
957: p_data => x_msg_data);
951: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
952: fnd_message.set_token('ERROR' ,SQLERRM);
953: fnd_msg_pub.add;
954:
955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
956: p_count => x_msg_count,
957: p_data => x_msg_data);
958:
959: -- Debug info.
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE
1043: IF FND_API.to_Boolean(p_init_msg_list) THEN
1044: FND_MSG_PUB.initialize;
1045: END IF;
1046:
1047:
1048: -- Debug info.
1100:
1101: WHEN fnd_api.g_exc_error THEN
1102: x_return_status := fnd_api.g_ret_sts_error;
1103:
1104: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:
1108: -- Debug info.
1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1123: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
1127: -- Debug info.
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:
1142: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1143: fnd_message.set_token('ERROR' ,SQLERRM);
1144: fnd_msg_pub.add;
1145:
1146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1142: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1143: fnd_message.set_token('ERROR' ,SQLERRM);
1144: fnd_msg_pub.add;
1145:
1146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: -- Debug info.
1229: x_return_status := FND_API.G_RET_STS_SUCCESS;
1230:
1231: -- Initialize message list if p_init_msg_list is set to TRUE
1232: IF FND_API.to_Boolean(p_init_msg_list) THEN
1233: FND_MSG_PUB.initialize;
1234: END IF;
1235:
1236:
1237: -- Debug info.
1296:
1297: WHEN fnd_api.g_exc_error THEN
1298: x_return_status := fnd_api.g_ret_sts_error;
1299:
1300: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data);
1303:
1304: -- Debug info.
1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:
1319: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1320: p_count => x_msg_count,
1321: p_data => x_msg_data);
1322:
1323: -- Debug info.
1336: x_return_status := fnd_api.g_ret_sts_unexp_error;
1337:
1338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1339: fnd_message.set_token('ERROR' ,SQLERRM);
1340: fnd_msg_pub.add;
1341:
1342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1343: p_count => x_msg_count,
1344: p_data => x_msg_data);
1338: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1339: fnd_message.set_token('ERROR' ,SQLERRM);
1340: fnd_msg_pub.add;
1341:
1342: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1343: p_count => x_msg_count,
1344: p_data => x_msg_data);
1345:
1346: -- Debug info.
2011: x_return_status := fnd_api.g_ret_sts_unexp_error;
2012:
2013: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2014: fnd_message.set_token('ERROR' ,SQLERRM);
2015: fnd_msg_pub.add;
2016:
2017: end set_org_bo_action_type;
2018:
2019:
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071: -- Initialize message list if p_init_msg_list is set to TRUE
2072: IF FND_API.to_Boolean(p_init_msg_list) THEN
2073: FND_MSG_PUB.initialize;
2074: END IF;
2075:
2076:
2077: -- Debug info.
2142:
2143: WHEN fnd_api.g_exc_error THEN
2144: x_return_status := fnd_api.g_ret_sts_error;
2145:
2146: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: -- Debug info.
2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2184: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2185: fnd_message.set_token('ERROR' ,SQLERRM);
2186: fnd_msg_pub.add;
2187:
2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2184: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2185: fnd_message.set_token('ERROR' ,SQLERRM);
2186: fnd_msg_pub.add;
2187:
2188: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: -- Debug info.