177: BEGIN
178: --
179: JTF_TERRITORY_GET_PUB.Get_Territory_Details(
180: p_Api_Version => l_api_version,
181: p_Init_Msg_List => FND_API.G_FALSE,
182: x_return_status => l_return_status,
183: x_msg_count => l_msg_count,
184: x_msg_data => l_msg_data,
185: p_terr_id => p_terr_id,
192: x_terr_values_tbl => l_terr_values_table,
193: x_terr_rsc_tbl => l_terr_rsc_table);
194: --
195: -- dbms_output.put_line('get_territory_details(terr_id=' || p_terr_id || ') returns ' || l_return_status);
196: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
197: RAISE FND_API.g_exc_error;
198: END IF;
199: J := l_terr_values_table.FIRST;
200: l_index := p_bindvar_index;
193: x_terr_rsc_tbl => l_terr_rsc_table);
194: --
195: -- dbms_output.put_line('get_territory_details(terr_id=' || p_terr_id || ') returns ' || l_return_status);
196: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
197: RAISE FND_API.g_exc_error;
198: END IF;
199: J := l_terr_values_table.FIRST;
200: l_index := p_bindvar_index;
201: --