179: END IF;
180: WHEN OTHERS THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:
183: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
184: fnd_message.set_token('ERROR' ,SQLERRM);
185: fnd_msg_pub.add;
186:
187: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
180: WHEN OTHERS THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:
183: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
184: fnd_message.set_token('ERROR' ,SQLERRM);
185: fnd_msg_pub.add;
186:
187: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
188: p_count => x_msg_count,
433: END IF;
434: WHEN OTHERS THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
438: fnd_message.set_token('ERROR' ,SQLERRM);
439: fnd_msg_pub.add;
440:
441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
434: WHEN OTHERS THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
438: fnd_message.set_token('ERROR' ,SQLERRM);
439: fnd_msg_pub.add;
440:
441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
442: p_count => x_msg_count,
628: END IF;
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
633: fnd_message.set_token('ERROR' ,SQLERRM);
634: fnd_msg_pub.add;
635:
636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
633: fnd_message.set_token('ERROR' ,SQLERRM);
634: fnd_msg_pub.add;
635:
636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
637: p_count => x_msg_count,
983:
984: WHEN OTHERS THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986:
987: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
988: fnd_message.set_token('ERROR' ,SQLERRM);
989: fnd_msg_pub.add;
990:
991: end set_person_cust_bo_action_type;
984: WHEN OTHERS THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986:
987: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
988: fnd_message.set_token('ERROR' ,SQLERRM);
989: fnd_msg_pub.add;
990:
991: end set_person_cust_bo_action_type;
992:
1151: END IF;
1152: WHEN OTHERS THEN
1153: x_return_status := fnd_api.g_ret_sts_unexp_error;
1154:
1155: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1156: fnd_message.set_token('ERROR' ,SQLERRM);
1157: fnd_msg_pub.add;
1158:
1159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1152: WHEN OTHERS THEN
1153: x_return_status := fnd_api.g_ret_sts_unexp_error;
1154:
1155: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1156: fnd_message.set_token('ERROR' ,SQLERRM);
1157: fnd_msg_pub.add;
1158:
1159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1160: p_count => x_msg_count,
1344: END IF;
1345: WHEN OTHERS THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1349: fnd_message.set_token('ERROR' ,SQLERRM);
1350: fnd_msg_pub.add;
1351:
1352: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1345: WHEN OTHERS THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1349: fnd_message.set_token('ERROR' ,SQLERRM);
1350: fnd_msg_pub.add;
1351:
1352: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1353: p_count => x_msg_count,
1579: END IF;
1580: WHEN OTHERS THEN
1581: x_return_status := fnd_api.g_ret_sts_unexp_error;
1582:
1583: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1584: fnd_message.set_token('ERROR' ,SQLERRM);
1585: fnd_msg_pub.add;
1586:
1587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1580: WHEN OTHERS THEN
1581: x_return_status := fnd_api.g_ret_sts_unexp_error;
1582:
1583: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1584: fnd_message.set_token('ERROR' ,SQLERRM);
1585: fnd_msg_pub.add;
1586:
1587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1588: p_count => x_msg_count,
1775: END IF;
1776: WHEN OTHERS THEN
1777: x_return_status := fnd_api.g_ret_sts_unexp_error;
1778:
1779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1780: fnd_message.set_token('ERROR' ,SQLERRM);
1781: fnd_msg_pub.add;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1776: WHEN OTHERS THEN
1777: x_return_status := fnd_api.g_ret_sts_unexp_error;
1778:
1779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1780: fnd_message.set_token('ERROR' ,SQLERRM);
1781: fnd_msg_pub.add;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1784: p_count => x_msg_count,
2135:
2136: WHEN OTHERS THEN
2137: x_return_status := fnd_api.g_ret_sts_unexp_error;
2138:
2139: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2140: fnd_message.set_token('ERROR' ,SQLERRM);
2141: fnd_msg_pub.add;
2142:
2143: end set_person_cust_bo_action_type;
2136: WHEN OTHERS THEN
2137: x_return_status := fnd_api.g_ret_sts_unexp_error;
2138:
2139: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2140: fnd_message.set_token('ERROR' ,SQLERRM);
2141: fnd_msg_pub.add;
2142:
2143: end set_person_cust_bo_action_type;
2144:
2303: END IF;
2304: WHEN OTHERS THEN
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306:
2307: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2308: fnd_message.set_token('ERROR' ,SQLERRM);
2309: fnd_msg_pub.add;
2310:
2311: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2304: WHEN OTHERS THEN
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306:
2307: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2308: fnd_message.set_token('ERROR' ,SQLERRM);
2309: fnd_msg_pub.add;
2310:
2311: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2312: p_count => x_msg_count,