345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- initialize Global variable
353: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
415:
416: IF(p_org_contact_obj.person_profile_obj IS NULL) THEN
417: fnd_message.set_name('AR', 'HZ_API_MISSING_MANDATORY_ENT');
418: fnd_message.set_token('ENTITY' ,'PERSON_CONTACT');
419: fnd_msg_pub.add;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423: l_per_party_id := p_org_contact_obj.person_profile_obj.person_id;
433: FETCH validate_per_id INTO l_valid_per;
434: CLOSE validate_per_id;
435: IF(l_valid_per IS NULL) THEN
436: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
437: FND_MSG_PUB.ADD;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:
645: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
646:
647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
648: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
649: FND_MSG_PUB.ADD;
650:
651: x_return_status := fnd_api.g_ret_sts_error;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
649: FND_MSG_PUB.ADD;
650:
651: x_return_status := fnd_api.g_ret_sts_error;
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.
675: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
676:
677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
678: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
679: FND_MSG_PUB.ADD;
680:
681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
679: FND_MSG_PUB.ADD;
680:
681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686:
687: -- Debug info.
705: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
706:
707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
708: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
709: FND_MSG_PUB.ADD;
710:
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712:
713: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712:
713: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
714: fnd_message.set_token('ERROR' ,SQLERRM);
715: fnd_msg_pub.add;
716:
717: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
718: p_count => x_msg_count,
719: p_data => x_msg_data);
713: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
714: fnd_message.set_token('ERROR' ,SQLERRM);
715: fnd_msg_pub.add;
716:
717: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
718: p_count => x_msg_count,
719: p_data => x_msg_data);
720:
721: -- Debug info.
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: -- Initialize message list if p_init_msg_list is set to TRUE.
954: IF FND_API.to_Boolean(p_init_msg_list) THEN
955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: -- initialize Global variable
959: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1226: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1227:
1228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1229: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1230: FND_MSG_PUB.ADD;
1231:
1232: x_return_status := fnd_api.g_ret_sts_error;
1233:
1234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1230: FND_MSG_PUB.ADD;
1231:
1232: x_return_status := fnd_api.g_ret_sts_error;
1233:
1234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data);
1237:
1238: -- Debug info.
1256: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1257:
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1259: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1260: FND_MSG_PUB.ADD;
1261:
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263:
1264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1260: FND_MSG_PUB.ADD;
1261:
1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263:
1264: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);
1267:
1268: -- Debug info.
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1287:
1288: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1289: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1290: FND_MSG_PUB.ADD;
1291:
1292: x_return_status := fnd_api.g_ret_sts_unexp_error;
1293:
1294: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1292: x_return_status := fnd_api.g_ret_sts_unexp_error;
1293:
1294: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1295: fnd_message.set_token('ERROR' ,SQLERRM);
1296: fnd_msg_pub.add;
1297:
1298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data);
1294: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1295: fnd_message.set_token('ERROR' ,SQLERRM);
1296: fnd_msg_pub.add;
1297:
1298: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data);
1301:
1302: -- Debug info.
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Initialize message list if p_init_msg_list is set to TRUE.
1346: IF FND_API.to_Boolean(p_init_msg_list) THEN
1347: FND_MSG_PUB.initialize;
1348: END IF;
1349:
1350: -- Debug info.
1351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1371:
1372: IF(l_create_update_flag = 'E') THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1374: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: IF(l_create_update_flag = 'C') THEN
1426: EXCEPTION
1427: WHEN fnd_api.g_exc_error THEN
1428: x_return_status := fnd_api.g_ret_sts_error;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: -- Debug info.
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448:
1449: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1450: p_count => x_msg_count,
1451: p_data => x_msg_data);
1452:
1453: -- Debug info.
1466: x_return_status := fnd_api.g_ret_sts_unexp_error;
1467:
1468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1469: fnd_message.set_token('ERROR' ,SQLERRM);
1470: fnd_msg_pub.add;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1468: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1469: fnd_message.set_token('ERROR' ,SQLERRM);
1470: fnd_msg_pub.add;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.
1625: x_return_status := FND_API.G_RET_STS_SUCCESS;
1626:
1627: -- Initialize message list if p_init_msg_list is set to TRUE
1628: IF FND_API.to_Boolean(p_init_msg_list) THEN
1629: FND_MSG_PUB.initialize;
1630: END IF;
1631:
1632:
1633: -- Debug info.
1693:
1694: WHEN fnd_api.g_exc_error THEN
1695: x_return_status := fnd_api.g_ret_sts_error;
1696:
1697: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data);
1700:
1701: -- Debug info.
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN
1714: x_return_status := fnd_api.g_ret_sts_unexp_error;
1715:
1716: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: -- Debug info.
1733: x_return_status := fnd_api.g_ret_sts_unexp_error;
1734:
1735: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1736: fnd_message.set_token('ERROR' ,SQLERRM);
1737: fnd_msg_pub.add;
1738:
1739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data);
1735: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1736: fnd_message.set_token('ERROR' ,SQLERRM);
1737: fnd_msg_pub.add;
1738:
1739: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data);
1742:
1743: -- Debug info.