236:
237: exception
238: WHEN FND_API.G_EXC_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => l_msg_count,
242: p_data => l_msg_data);
243:
244: when others then
243:
244: when others then
245: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
246: fnd_message.set_token('ERROR',SQLERRM);
247: fnd_msg_pub.add;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: raise;
250:
251: END MERGE_PARTNER_PROFILES1;
374: -- --------------------------------------------------------
375: exception
376: WHEN FND_API.G_EXC_ERROR THEN
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
379: p_count => l_msg_count,
380: p_data => l_msg_data);
381:
382: when others then
381:
382: when others then
383: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
384: fnd_message.set_token('ERROR',SQLERRM);
385: fnd_msg_pub.add;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: raise;
388:
389: END MERGE_PARTNER_PROFILES2;
423: exception
424: when others then
425: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
426: fnd_message.set_token('ERROR',SQLERRM);
427: fnd_msg_pub.add;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: raise;
430:
431: END MERGE_PARTNER_ENTITY_ATTRS;
526: exception
527: when others then
528: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR',SQLERRM);
530: fnd_msg_pub.add;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: raise;
533:
534: END MERGE_LEAD_ASSIGNMENTS;
625: exception
626: when others then
627: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
628: fnd_message.set_token('ERROR',SQLERRM);
629: fnd_msg_pub.add;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: raise;
632:
633: END MERGE_ASSIGNMENT_LOGS;
666: exception
667: when others then
668: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
669: fnd_message.set_token('ERROR',SQLERRM);
670: fnd_msg_pub.add;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: raise;
673:
674: END MERGE_SEARCH_ATTR_VALUES;
766: exception
767: when others then
768: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
769: fnd_message.set_token('ERROR',SQLERRM);
770: fnd_msg_pub.add;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: raise;
773:
774: END MERGE_LEAD_PSS_LINES;
867: exception
868: when others then
869: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
870: fnd_message.set_token('ERROR',SQLERRM);
871: fnd_msg_pub.add;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: raise;
874:
875: END MERGE_GE_PARTY_NOTIFICATIONS;
923: exception
924: when others then
925: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR',SQLERRM);
927: fnd_msg_pub.add;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: raise;
930:
931: END MERGE_PG_ENRL_REQUESTS;
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1066: fnd_message.set_token('ERROR',SQLERRM);
1067: fnd_msg_pub.add;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: RAISE;
1070:
1071: END MERGE_PG_MEMBERSHIPS;
1257: RAISE FND_API.G_EXC_ERROR;
1258: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1260: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1261: FND_MSG_PUB.Add;
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264: END IF;
1265: END IF; --l_processed_flag <> 'P'
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1272: fnd_message.set_token('ERROR',SQLERRM);
1273: fnd_msg_pub.add;
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1275: raise;
1276: END;
1277: END IF; -- p_from_fk_id <> p_to_fk_id
1333: -- --------------------------------------------------------
1334: exception
1335: WHEN FND_API.G_EXC_ERROR THEN
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1338: p_count => l_msg_count,
1339: p_data => l_msg_data);
1340:
1341: when others then
1340:
1341: when others then
1342: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1343: fnd_message.set_token('ERROR',SQLERRM);
1344: fnd_msg_pub.add;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: raise;
1347: END MERGE_PV_GE_PTNR_RESPS;
1348:
1440: exception
1441: when others then
1442: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1446: raise;
1447:
1448: END MERGE_CONTRACT_BINDING_CONTACT;
1471:
1472: BEGIN
1473: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1474: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1475: FND_MSG_PUB.Add;
1476:
1477: l_count := FND_MSG_PUB.count_msg;
1478:
1479: FOR l_cnt IN 1 .. l_count LOOP
1473: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1474: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
1475: FND_MSG_PUB.Add;
1476:
1477: l_count := FND_MSG_PUB.count_msg;
1478:
1479: FOR l_cnt IN 1 .. l_count LOOP
1480: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1481: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1476:
1477: l_count := FND_MSG_PUB.count_msg;
1478:
1479: FOR l_cnt IN 1 .. l_count LOOP
1480: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1481: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1482: END LOOP;
1483: END Debug;
1484:
1523: IF (p_token3 IS NOT NULL) THEN
1524: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
1525: END IF;
1526:
1527: FND_MSG_PUB.Add;
1528:
1529: l_count := FND_MSG_PUB.count_msg;
1530:
1531: FOR l_cnt IN 1 .. l_count LOOP
1525: END IF;
1526:
1527: FND_MSG_PUB.Add;
1528:
1529: l_count := FND_MSG_PUB.count_msg;
1530:
1531: FOR l_cnt IN 1 .. l_count LOOP
1532: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1528:
1529: l_count := FND_MSG_PUB.count_msg;
1530:
1531: FOR l_cnt IN 1 .. l_count LOOP
1532: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1534: END LOOP;
1535: END Set_Message;
1536: -- ==============================End of Set_Message==============================