79: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: HZ_PHONE_AREA_CODES_PKG.insert_row(
84: p_rowid => l_rowid,
85: p_TERRITORY_CODE =>p_TERRITORY_CODE,
86: p_AREA_CODE =>p_AREA_CODE,
87: p_PHONE_COUNTRY_CODE =>p_PHONE_COUNTRY_CODE,
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: end if;
201:
202: HZ_PHONE_AREA_CODES_PKG.update_row(
203: p_rowid => l_rowid,
204: p_TERRITORY_CODE =>p_TERRITORY_CODE,
205: p_AREA_CODE =>p_AREA_CODE,
206: p_PHONE_COUNTRY_CODE =>fnd_api.g_miss_char,