APPS.WSH_PARTY_MERGE dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.ADD;

79:
80: IF ( l_from_carrier_num > 0 ) THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NO_MERGE');
83: FND_MSG_PUB.ADD;
84: RETURN;
85: END IF;
86: END IF;
87: END IF;

Line 134: FND_MSG_PUB.ADD;

130: --
131: EXCEPTION WHEN OTHERS THEN
132: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
133: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
134: FND_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136:
137: END merge_carriers;
138:

Line 189: FND_MSG_PUB.ADD;

185:
186: IF ( l_from_carrier_site_num > 0 ) THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_SITE_NO_MERGE');
189: FND_MSG_PUB.ADD;
190: RETURN;
191: END IF;
192:
193: END IF;

Line 199: FND_MSG_PUB.ADD;

195:
196: EXCEPTION WHEN OTHERS THEN
197: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
199: FND_MSG_PUB.ADD;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201:
202: END merge_carrier_sites;
203:

Line 350: FND_MSG_PUB.ADD;

346:
347: IF (l_owner_type_from=3) THEN
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_SITE_NO_MERGE');
350: FND_MSG_PUB.ADD;
351: RETURN;
352: END IF;
353:
354: l_owner_type_to := 2;

Line 376: FND_MSG_PUB.ADD;

372: CLOSE C_Owner_Type;
373: IF (l_owner_type_to=3) THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_SITE_NO_MERGE');
376: FND_MSG_PUB.ADD;
377: RETURN;
378: END IF;
379:
380: check_duplicate_rec( p_from_pk => p_from_id,

Line 424: FND_MSG_PUB.ADD;

420:
421: EXCEPTION
422: WHEN RESOURCE_BUSY THEN
423: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
424: FND_MSG_PUB.ADD;
425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 429: FND_MSG_PUB.ADD;

425: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
428: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
429: FND_MSG_PUB.ADD;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: WHEN others THEN
432: IF C_Owner_Type%ISOPEN THEN
433: CLOSE C_Owner_Type;

Line 443: FND_MSG_PUB.ADD;

439: CLOSE get_loc_owners_for_update;
440: END IF;
441: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
443: FND_MSG_PUB.ADD;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: END merge_party_locations;
446:
447: --========================================================================

Line 667: FND_MSG_PUB.ADD;

663: EXCEPTION
664: WHEN OTHERS THEN
665: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
666: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
667: FND_MSG_PUB.ADD;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: --
670: IF l_debug_on THEN
671: WSH_DEBUG_SV.log(l_module_name, 'In When Others, Error Msg is', SUBSTRB(SQLERRM, 1, 200));

Line 2828: FND_MSG_PUB.ADD;

2824:
2825: WHEN OTHERS THEN
2826: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
2827: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2828: FND_MSG_PUB.ADD;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830:
2831: -- Close the Cursors if it is OPEN
2832: IF ( Get_Location_Id %ISOPEN ) THEN