138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.to_Boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: IF(p_created_by_module IS NULL) THEN
146: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
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:
166: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
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:
173: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
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:
180: IF(p_orig_sys_refs(i).orig_system_ref_id IS NOT NULL) THEN
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:
186: assign_orig_sys_ref(
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);
225:
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);
225:
226: -- Debug info.
239: WHEN fnd_api.g_exc_unexpected_error THEN
240: ROLLBACK TO create_osr_bo_pub;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242:
243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:
247: -- Debug info.
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,
269: p_data => x_msg_data);
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,
269: p_data => x_msg_data);
270:
271: -- Debug info.
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE
354: IF FND_API.to_Boolean(p_init_msg_list) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug info.
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
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:
373: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
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:
380: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
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:
387: IF(p_orig_sys_refs(i).old_orig_system_reference IS NULL) THEN
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:
394: assign_orig_sys_ref(
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);
435:
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);
435:
436: -- Debug info.
449: WHEN fnd_api.g_exc_unexpected_error THEN
450: ROLLBACK TO update_osr_bo_pub;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452:
453: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
454: p_count => x_msg_count,
455: p_data => x_msg_data);
456:
457: -- Debug info.
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,
479: p_data => x_msg_data);
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,
479: p_data => x_msg_data);
480:
481: -- Debug info.
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE
559: IF FND_API.to_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Debug info.
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
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);
611:
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);
611:
612: -- Debug info.
625: WHEN fnd_api.g_exc_unexpected_error THEN
626: ROLLBACK TO remap_osr_bo_pub;
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
630: p_count => x_msg_count,
631: p_data => x_msg_data);
632:
633: -- Debug info.
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,
655: p_data => x_msg_data);
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,
655: p_data => x_msg_data);
656:
657: -- Debug info.