156: END IF;
157:
158: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
159: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
160: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
161: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
162: FND_MSG_PUB.ADD();
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
157:
158: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
159: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
160: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
161: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
162: FND_MSG_PUB.ADD();
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
167: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
169: FND_MSG_PUB.ADD();
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
164: END IF;
165:
166: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
167: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
169: FND_MSG_PUB.ADD();
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
174: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
176: FND_MSG_PUB.ADD();
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
171: END IF;
172:
173: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
174: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
176: FND_MSG_PUB.ADD();
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: IF(p_orig_sys_refs(i).orig_system_ref_id IS NOT NULL) THEN
181: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
182: FND_MSG_PUB.ADD();
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
215: WHEN fnd_api.g_exc_error THEN
216: ROLLBACK TO create_osr_bo_pub;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
220: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
221: FND_MSG_PUB.ADD;
222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
223: p_count => x_msg_count,
216: ROLLBACK TO create_osr_bo_pub;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
220: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
221: FND_MSG_PUB.ADD;
222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
223: p_count => x_msg_count,
224: p_data => x_msg_data);
259: WHEN OTHERS THEN
260: ROLLBACK TO create_osr_bo_pub;
261: x_return_status := fnd_api.g_ret_sts_unexp_error;
262:
263: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
264: fnd_message.set_token('ERROR' ,SQLERRM);
265: fnd_msg_pub.add;
266:
267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
260: ROLLBACK TO create_osr_bo_pub;
261: x_return_status := fnd_api.g_ret_sts_unexp_error;
262:
263: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
264: fnd_message.set_token('ERROR' ,SQLERRM);
265: fnd_msg_pub.add;
266:
267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
268: p_count => x_msg_count,
363: END IF;
364:
365: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
366: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
367: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
368: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
369: FND_MSG_PUB.ADD();
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
364:
365: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
366: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
367: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
368: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
369: FND_MSG_PUB.ADD();
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
374: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
375: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system');
376: FND_MSG_PUB.ADD();
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
371: END IF;
372:
373: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
374: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
375: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system');
376: FND_MSG_PUB.ADD();
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
380: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
381: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
382: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system_reference');
383: FND_MSG_PUB.ADD();
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
378: END IF;
379:
380: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
381: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
382: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system_reference');
383: FND_MSG_PUB.ADD();
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: IF(p_orig_sys_refs(i).old_orig_system_reference IS NULL) THEN
388: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
389: FND_MESSAGE.SET_TOKEN('PARAMETER', 'old_orig_system_reference');
390: FND_MSG_PUB.ADD();
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
385: END IF;
386:
387: IF(p_orig_sys_refs(i).old_orig_system_reference IS NULL) THEN
388: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
389: FND_MESSAGE.SET_TOKEN('PARAMETER', 'old_orig_system_reference');
390: FND_MSG_PUB.ADD();
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
425: WHEN fnd_api.g_exc_error THEN
426: ROLLBACK TO update_osr_bo_pub;
427: x_return_status := fnd_api.g_ret_sts_error;
428:
429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
430: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
431: FND_MSG_PUB.ADD;
432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
433: p_count => x_msg_count,
426: ROLLBACK TO update_osr_bo_pub;
427: x_return_status := fnd_api.g_ret_sts_error;
428:
429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
430: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
431: FND_MSG_PUB.ADD;
432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
469: WHEN OTHERS THEN
470: ROLLBACK TO update_osr_bo_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
474: fnd_message.set_token('ERROR' ,SQLERRM);
475: fnd_msg_pub.add;
476:
477: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
470: ROLLBACK TO update_osr_bo_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
474: fnd_message.set_token('ERROR' ,SQLERRM);
475: fnd_msg_pub.add;
476:
477: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
478: p_count => x_msg_count,
601: WHEN fnd_api.g_exc_error THEN
602: ROLLBACK TO remap_osr_bo_pub;
603: x_return_status := fnd_api.g_ret_sts_error;
604:
605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
606: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
607: FND_MSG_PUB.ADD;
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,
602: ROLLBACK TO remap_osr_bo_pub;
603: x_return_status := fnd_api.g_ret_sts_error;
604:
605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
606: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
607: FND_MSG_PUB.ADD;
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
645: WHEN OTHERS THEN
646: ROLLBACK TO remap_osr_bo_pub;
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648:
649: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
650: fnd_message.set_token('ERROR' ,SQLERRM);
651: fnd_msg_pub.add;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
646: ROLLBACK TO remap_osr_bo_pub;
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648:
649: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
650: fnd_message.set_token('ERROR' ,SQLERRM);
651: fnd_msg_pub.add;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
654: p_count => x_msg_count,