eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SUPPLIER_PARTY dependencies on FND_API

Line 193: raise fnd_api.g_exc_error;

189: IF (P_party_id IS NULL) THEN
190: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
191: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
192: wsh_util_core.add_message(x_return_status,l_module_name);
193: raise fnd_api.g_exc_error;
194: END IF;
195:
196: IF (P_location_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 200: raise fnd_api.g_exc_error;

196: IF (P_location_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_id');
199: wsh_util_core.add_message(x_return_status,l_module_name);
200: raise fnd_api.g_exc_error;
201: END IF;
202:
203: IF (P_location_code IS NULL ) THEN
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 207: raise fnd_api.g_exc_error;

203: IF (P_location_code IS NULL ) THEN
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_code');
206: wsh_util_core.add_message(x_return_status,l_module_name);
207: raise fnd_api.g_exc_error;
208: END IF;
209:
210: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
211:

Line 233: p_init_msg_list => FND_API.g_false,

229: l_hz_profile_set := true;
230: END IF;
231:
232: HZ_PARTY_SITE_V2PUB.Create_Party_Site (
233: p_init_msg_list => FND_API.g_false,
234: p_party_site_rec => l_site_rec,
235: x_party_site_id => x_party_site_id,
236: x_party_site_number => l_party_site_number,
237: x_return_status => l_return_status,

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: IF l_debug_on THEN
266: WSH_DEBUG_SV.pop(l_module_name);
267: END IF;
268: EXCEPTION
269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
271:
272: IF l_debug_on THEN
273: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 273: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

269: WHEN FND_API.G_EXC_ERROR THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
271:
272: IF l_debug_on THEN
273: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
274: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
275: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
277: END IF;

Line 276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

272: IF l_debug_on THEN
273: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
274: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
275: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
277: END IF;
278:
279: WHEN OTHERS THEN
280: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

364: fnd_msg_pub.add;
365: -- } IB-Phase-2
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
368: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
369: END IF;
370:
371: RETURN 'N';
372:

Line 476: raise FND_API.G_EXC_ERROR;

472: FETCH get_vendor_name INTO l_vendor_name;
473:
474: IF (get_vendor_name%NOTFOUND ) THEN
475: CLOSE get_vendor_name;
476: raise FND_API.G_EXC_ERROR;
477: END IF;
478: CLOSE get_vendor_name;
479:
480: l_org_rec.organization_name := l_vendor_name;

Line 494: p_init_msg_list => FND_API.g_false,

490:
491: --Party is created as Organization in TCA.
492: HZ_PARTY_V2PUB.Create_Organization
493: (
494: p_init_msg_list => FND_API.g_false,
495: p_organization_rec => l_org_rec,
496: x_return_status => l_return_status,
497: x_msg_count => l_msg_count,
498: x_msg_data => l_msg_data,

Line 541: --p_init_msg_list => FND_API.g_false,

537: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_CONTACT_V2PUB.create_org_contact');
538: END IF;
539:
540: HZ_RELATIONSHIP_V2PUB.create_relationship(
541: --p_init_msg_list => FND_API.g_false,
542: p_relationship_rec => l_party_rel_rec,
543: x_relationship_id => l_party_relationship_id,
544: x_party_id => l_rel_party_id,
545: x_party_number => l_party_number,

Line 588: FND_API.G_FALSE,

584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling HZ_CLASSIFICATION_V2PUB.create_code_assignment');
585: END IF;
586:
587: HZ_CLASSIFICATION_V2PUB.create_code_assignment(
588: FND_API.G_FALSE,
589: l_code_assignment_rec,
590: l_return_status,
591: l_msg_count,
592: exception_message,

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618:
619: RETURN l_party_id;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
624:
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
624:
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
628: END IF;
629:
630: RETURN null;

Line 627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

623: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
624:
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
628: END IF;
629:
630: RETURN null;
631:

Line 751: p_init_msg_list => FND_API.G_FALSE,

747: CLOSE Get_Location_Object_Number;
748:
749: HZ_LOCATION_V2PUB.Update_Location
750: (
751: p_init_msg_list => FND_API.G_FALSE,
752: p_location_rec => l_loc_rec,
753: p_object_version_number => l_location_object_number,
754: x_return_status => l_return_status,
755: x_msg_count => l_msg_count,

Line 778: WHEN FND_API.G_EXC_ERROR THEN

774: IF l_debug_on THEN
775: WSH_DEBUG_SV.pop(l_module_name);
776: END IF;
777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR THEN
779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
780:
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

778: WHEN FND_API.G_EXC_ERROR THEN
779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
780:
781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
784: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
786: END IF;

Line 785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

781: IF l_debug_on THEN
782: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
784: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
786: END IF;
787:
788: WHEN OTHERS THEN
789: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 881: raise fnd_api.g_exc_error;

877: IF (P_party_id IS NULL) THEN
878: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
879: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
880: wsh_util_core.add_message(x_return_status,l_module_name);
881: raise fnd_api.g_exc_error;
882: END IF;
883:
884: IF (P_address1 IS NULL) THEN
885: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 888: raise fnd_api.g_exc_error;

884: IF (P_address1 IS NULL) THEN
885: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
886: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_address1');
887: wsh_util_core.add_message(x_return_status,l_module_name);
888: raise fnd_api.g_exc_error;
889: END IF;
890:
891: IF (p_country IS NULL ) THEN
892: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 895: raise fnd_api.g_exc_error;

891: IF (p_country IS NULL ) THEN
892: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
893: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_country');
894: wsh_util_core.add_message(x_return_status,l_module_name);
895: raise fnd_api.g_exc_error;
896: END IF;
897:
898: IF (p_location_code IS NULL ) THEN
899: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 902: raise fnd_api.g_exc_error;

898: IF (p_location_code IS NULL ) THEN
899: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
900: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');
901: wsh_util_core.add_message(x_return_status,l_module_name);
902: raise fnd_api.g_exc_error;
903: END IF;
904:
905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
906:

Line 939: p_init_msg_list => FND_API.G_FALSE,

935: l_loc_rec.county := p_county;
936: l_loc_rec.created_by_module := C_CREATED_BY_MODULE;
937:
938: HZ_LOCATION_V2PUB.Create_Location (
939: p_init_msg_list => FND_API.G_FALSE,
940: p_location_rec => l_loc_rec,
941: x_location_id => x_location_id,
942: x_return_status => l_return_status,
943: x_msg_count => l_msg_count,

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980: IF l_debug_on THEN
981: WSH_DEBUG_SV.pop(l_module_name);
982: END IF;
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
986:
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 988: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

984: WHEN FND_API.G_EXC_ERROR THEN
985: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
986:
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
989: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
990: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
992: END IF;

Line 991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

987: IF l_debug_on THEN
988: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
989: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
990: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
991: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
992: END IF;
993:
994: WHEN OTHERS THEN
995: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1171: raise fnd_api.g_exc_error;

1167: IF (p_in_param.caller= 'ISP' ) THEN
1168: IF ( NOT Is_Valid_ISP_User(p_in_param.user_id,P_supplier_name)) THEN
1169: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_ISP_USER');
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1172: END IF;
1173: END IF;
1174:
1175: --Validate Vendor

Line 1190: raise fnd_api.g_exc_error;

1186: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_SUPPLIER');
1187: FND_MESSAGE.SET_TOKEN('SUP_NAME',P_supplier_name);
1188: fnd_msg_pub.add;
1189:
1190: raise fnd_api.g_exc_error;
1191: END IF;
1192: CLOSE validate_vendor_csr;
1193:
1194: IF ( WSH_SUPPLIER_PARTY.VENDOR_PARTY_EXISTS(x_vendor_id,x_party_id) = 'N' ) THEN

Line 1200: raise fnd_api.g_exc_error;

1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.log(l_module_name,'Party does not Exist for the Vendor ');
1198: END IF;
1199: --
1200: raise fnd_api.g_exc_error;
1201: -- } IB-Phase-2
1202: END IF;
1203:
1204:

Line 1210: WHEN FND_API.G_EXC_ERROR THEN

1206: IF l_debug_on THEN
1207: WSH_DEBUG_SV.pop(l_module_name);
1208: END IF;
1209: EXCEPTION
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1212:
1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1210: WHEN FND_API.G_EXC_ERROR THEN
1211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1212:
1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1216: END IF;
1217:
1218: WHEN OTHERS THEN

Line 1215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1212:
1213: IF l_debug_on THEN
1214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1216: END IF;
1217:
1218: WHEN OTHERS THEN
1219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1359: raise fnd_api.g_exc_error;

1355: IF (P_party_site_id IS NULL) THEN
1356: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1357: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_site_id');
1358: wsh_util_core.add_message(x_return_status,l_module_name);
1359: raise fnd_api.g_exc_error;
1360: END IF;
1361:
1362: IF (P_site_use_type IS NULL ) THEN
1363: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 1366: raise fnd_api.g_exc_error;

1362: IF (P_site_use_type IS NULL ) THEN
1363: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1364: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_site_use_type');
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366: raise fnd_api.g_exc_error;
1367: END IF;
1368:
1369: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1370:

Line 1383: p_init_msg_list => FND_API.G_FALSE,

1379: l_site_use_rec.party_site_id := p_party_site_id;
1380: l_site_use_rec.created_by_module := C_CREATED_BY_MODULE;
1381:
1382: HZ_PARTY_SITE_V2PUB.Create_Party_Site_Use (
1383: p_init_msg_list => FND_API.G_FALSE,
1384: p_party_site_use_rec => l_site_use_rec,
1385: x_party_site_use_id => x_party_site_use_id,
1386: x_return_status => l_return_status,
1387: x_msg_count => l_msg_count,

Line 1411: WHEN FND_API.G_EXC_ERROR THEN

1407: IF l_debug_on THEN
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1413:
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1415: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1411: WHEN FND_API.G_EXC_ERROR THEN
1412: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1413:
1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1416: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1419: END IF;

Line 1418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1414: IF l_debug_on THEN
1415: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1416: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1417: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1419: END IF;
1420:
1421: WHEN OTHERS THEN
1422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1500: p_init_msg_list => FND_API.G_FALSE,

1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for PHONE'
1497: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1498: END IF;
1499: HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point (
1500: p_init_msg_list => FND_API.G_FALSE,
1501: p_contact_point_rec => l_contact_points_rec_type,
1502: p_phone_rec => l_phone_rec_type,
1503: x_contact_point_id => l_contact_point_id,
1504: x_return_status => l_return_status,

Line 1529: WHEN FND_API.G_EXC_ERROR THEN

1525: IF l_debug_on THEN
1526: WSH_DEBUG_SV.pop(l_module_name);
1527: END IF;
1528: EXCEPTION
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1531:
1532: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
1533: fnd_msg_pub.add;

Line 1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1532: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
1533: fnd_msg_pub.add;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1537: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1538: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1540: END IF;

Line 1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1537: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1538: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1540: END IF;
1541:
1542: WHEN OTHERS THEN
1543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1649: raise fnd_api.g_exc_error;

1645: --Person record should exist for update, version number are not changed.
1646: OPEN Get_Object_Version_Number(P_person_id);
1647: FETCH Get_Object_Version_Number INTO l_object_version_number;
1648: IF (Get_Object_Version_Number%NOTFOUND) THEN
1649: raise fnd_api.g_exc_error;
1650: END IF;
1651: CLOSE Get_Object_Version_Number ;
1652:
1653: IF l_debug_on THEN

Line 1658: p_init_msg_list => FND_API.G_FALSE,

1654: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.Update_Person',WSH_DEBUG_SV.C_PROC_LEVEL);
1655: END IF;
1656:
1657: HZ_PARTY_V2PUB.Update_Person (
1658: p_init_msg_list => FND_API.G_FALSE,
1659: p_person_rec => l_person_rec,
1660: p_party_object_version_number => l_object_version_number,
1661: x_profile_id => l_profile_id,
1662: x_return_status => l_return_status,

Line 1709: raise fnd_api.g_exc_error;

1705: --Phone record should exist for update, version number are not changed.
1706: OPEN Get_Cont_Point_Version(p_phone_contact_point_id);
1707: FETCH Get_Cont_Point_Version INTO l_cont_point_version;
1708: IF (Get_Cont_Point_Version%NOTFOUND) THEN
1709: raise fnd_api.g_exc_error;
1710: END IF;
1711: CLOSE Get_Cont_Point_Version ;
1712:
1713:

Line 1719: p_init_msg_list => FND_API.G_FALSE,

1715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point for Phone',WSH_DEBUG_SV.C_PROC_LEVEL);
1716: END IF;
1717:
1718: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(
1719: p_init_msg_list => FND_API.G_FALSE,
1720: p_contact_point_rec => l_contact_points_rec_type,
1721: p_phone_rec => l_phone_rec_type,
1722: p_object_version_number => l_cont_point_version,
1723: x_return_status => l_return_status,

Line 1749: raise fnd_api.g_exc_error;

1745: --Email record should exist for update, version number are not changed.
1746: OPEN Get_Cont_Point_Version(p_email_contact_point_id);
1747: FETCH Get_Cont_Point_Version INTO l_cont_point_version;
1748: IF (Get_Cont_Point_Version%NOTFOUND) THEN
1749: raise fnd_api.g_exc_error;
1750: END IF;
1751: CLOSE Get_Cont_Point_Version ;
1752:
1753:

Line 1760: p_init_msg_list => FND_API.G_FALSE,

1756: C_PROC_LEVEL);
1757: END IF;
1758:
1759: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(
1760: p_init_msg_list => FND_API.G_FALSE,
1761: p_contact_point_rec => l_contact_points_rec_type,
1762: p_email_rec => l_email_rec_type,
1763: p_object_version_number => l_cont_point_version,
1764: x_return_status => l_return_status,

Line 1792: WHEN FND_API.G_EXC_ERROR THEN

1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.pop(l_module_name);
1790: END IF;
1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1794:
1795: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_CONTACT');
1796: fnd_msg_pub.add;

Line 1799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1795: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_CONTACT');
1796: fnd_msg_pub.add;
1797:
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1800: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1803: END IF;

Line 1802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1800: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1803: END IF;
1804:
1805: IF (Get_Object_Version_Number%ISOPEN) THEN
1806: CLOSE Get_Object_Version_Number;

Line 1919: p_init_msg_list => FND_API.G_FALSE,

1915: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_PARTY_V2PUB.Create_Person',WSH_DEBUG_SV.C_PROC_LEVEL);
1916: END IF;
1917:
1918: HZ_PARTY_V2PUB.Create_Person (
1919: p_init_msg_list => FND_API.G_FALSE,
1920: p_person_rec => l_per_rec,
1921: x_party_id => l_person_party_id,
1922: x_party_number => l_party_number,
1923: x_profile_id => l_profile_id,

Line 1996: p_init_msg_list => FND_API.G_FALSE,

1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for EMAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1994: END IF;
1995: HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point (
1996: p_init_msg_list => FND_API.G_FALSE,
1997: p_contact_point_rec => l_contact_points_rec_type,
1998: p_email_rec => l_email_rec_type,
1999: x_contact_point_id => l_contact_point_id,
2000: x_return_status => l_return_status,

Line 2040: WHEN FND_API.G_EXC_ERROR THEN

2036: IF l_debug_on THEN
2037: WSH_DEBUG_SV.pop(l_module_name);
2038: END IF;
2039: EXCEPTION
2040: WHEN FND_API.G_EXC_ERROR THEN
2041: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2042:
2043: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
2044: fnd_msg_pub.add;

Line 2047: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2043: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
2044: fnd_msg_pub.add;
2045:
2046: IF l_debug_on THEN
2047: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2048: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2049: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2051: END IF;

Line 2050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2046: IF l_debug_on THEN
2047: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2048: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2049: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2050: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2051: END IF;
2052:
2053: WHEN OTHERS THEN
2054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2231: l_relationship_rec.end_date := FND_API.G_MISS_DATE;

2227: --Make this relation ship active, if it is not.
2228: IF l_relation_end_date < SYSDATE
2229: THEN
2230: l_relationship_rec.relationship_id := l_relationship_id;
2231: l_relationship_rec.end_date := FND_API.G_MISS_DATE;
2232:
2233: HZ_RELATIONSHIP_V2PUB.update_relationship(
2234: p_init_msg_list => FND_API.g_false,
2235: p_relationship_rec => l_relationship_rec,

Line 2234: p_init_msg_list => FND_API.g_false,

2230: l_relationship_rec.relationship_id := l_relationship_id;
2231: l_relationship_rec.end_date := FND_API.G_MISS_DATE;
2232:
2233: HZ_RELATIONSHIP_V2PUB.update_relationship(
2234: p_init_msg_list => FND_API.g_false,
2235: p_relationship_rec => l_relationship_rec,
2236: p_object_version_number => l_object_version_number,
2237: p_party_object_version_number => l_party_object_version_number,
2238: x_return_status => l_return_status,

Line 2289: WHEN FND_API.G_EXC_ERROR THEN

2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.pop(l_module_name);
2287: END IF;
2288: EXCEPTION
2289: WHEN FND_API.G_EXC_ERROR THEN
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2291:
2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2293: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2289: WHEN FND_API.G_EXC_ERROR THEN
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2291:
2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2294: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2295: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2297: END IF;

Line 2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2294: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: '||l_msg_count,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2295: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: '||l_msg_data,WSH_DEBUG_SV.C_EXCEP_LEVEL);
2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2297: END IF;
2298:
2299: IF (Get_Contact_info%ISOPEN) THEN
2300: CLOSE Get_Contact_info;

Line 2468: WHEN FND_API.G_EXC_ERROR THEN

2464: IF l_debug_on THEN
2465: WSH_DEBUG_SV.pop(l_module_name);
2466: END IF;
2467: EXCEPTION
2468: WHEN FND_API.G_EXC_ERROR THEN
2469: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2470:
2471: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_LOC');
2472: fnd_msg_pub.add;

Line 2475: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2471: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_LOC');
2472: fnd_msg_pub.add;
2473:
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2477: END IF;
2478:
2479: WHEN OTHERS THEN

Line 2476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2472: fnd_msg_pub.add;
2473:
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2477: END IF;
2478:
2479: WHEN OTHERS THEN
2480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2668: WHEN FND_API.G_EXC_ERROR THEN

2664: IF l_debug_on THEN
2665: WSH_DEBUG_SV.pop(l_module_name);
2666: END IF;
2667: EXCEPTION
2668: WHEN FND_API.G_EXC_ERROR THEN
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2670:
2671: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_LOC');
2672: fnd_msg_pub.add;

Line 2675: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2671: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_LOC');
2672: fnd_msg_pub.add;
2673:
2674: IF l_debug_on THEN
2675: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2677: END IF;
2678:
2679: WHEN OTHERS THEN

Line 2676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2672: fnd_msg_pub.add;
2673:
2674: IF l_debug_on THEN
2675: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2676: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2677: END IF;
2678:
2679: WHEN OTHERS THEN
2680: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2733: l_msg := FND_MSG_PUB.get(i, FND_API.G_FALSE);

2729: END IF;
2730:
2731:
2732: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2733: l_msg := FND_MSG_PUB.get(i, FND_API.G_FALSE);
2734: IF l_debug_on THEN
2735: WSH_DEBUG_SV.log(l_module_name,'Stack Message :',l_msg);
2736: END IF;
2737:

Line 2915: raise FND_API.G_EXC_ERROR;

2911: FND_MESSAGE.SET_NAME('WSH','WSH_INACTIVE_PARTY_SITE');
2912: FND_MESSAGE.SET_TOKEN('PARTY_SITE',l_party_site_msg);
2913: fnd_msg_pub.add;
2914: l_num_errors := l_num_errors + 1;
2915: raise FND_API.G_EXC_ERROR;
2916: END IF;
2917: -- } IB-Phase-2
2918:
2919: Update_address(

Line 3004: WHEN FND_API.G_EXC_ERROR THEN

3000: x_success_tbl.extend;
3001: x_success_tbl(l_msg_count):=FND_MESSAGE.Get;
3002:
3003: EXCEPTION
3004: WHEN FND_API.G_EXC_ERROR THEN
3005: IF l_debug_on THEN
3006: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR in the loop');
3007: END IF;
3008: get_message;

Line 3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3010: IF (check_location_csr%ISOPEN) THEN
3011: CLOSE check_location_csr;
3012: END IF;
3013:
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: IF l_debug_on THEN
3016: wsh_debug_sv.log (l_module_name, 'G_EXC_UNEXPECTED_ERROR in the loop');
3017: END IF;
3018: get_message;