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.IBU_KNOWLEDGE_GRP dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

3:
4: -- ========================================================================================
5: PROCEDURE Specific_Search_Mes(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,

Line 8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4: -- ========================================================================================
5: PROCEDURE Specific_Search_Mes(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_search_string IN VARCHAR2 := NULL,

Line 14: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_search_string IN VARCHAR2 := NULL,
13: p_updated_in_days IN NUMBER := NULL,
14: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
15: p_application_id IN NUMBER,
16: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
17: := null, --amv_search_grp.Default_AreaArray,
18: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

19: := null, --amv_search_grp.Default_ContentArray,
20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
21: p_user_id IN NUMBER := NULL,
22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
25: p_rows_requested IN NUMBER,
26: p_start_row_pos IN NUMBER := 1,
27: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

Line 24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

20: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
21: p_user_id IN NUMBER := NULL,
22: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
25: p_rows_requested IN NUMBER,
26: p_start_row_pos IN NUMBER := 1,
27: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
28: x_rows_returned OUT NOCOPY NUMBER,

Line 27: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

23: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
24: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
25: p_rows_requested IN NUMBER,
26: p_start_row_pos IN NUMBER := 1,
27: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
28: x_rows_returned OUT NOCOPY NUMBER,
29: x_next_row_pos OUT NOCOPY NUMBER,
30: x_total_row_cnt OUT NOCOPY NUMBER,
31: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,

Line 45: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then

41: begin
42: -- x_result_array := cs_kb_result_varray_type();
43: null;
44: -- check for G_MISS* per standard
45: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
46: l_search_string := FND_API.G_MISS_CHAR;
47: end if;
48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;

Line 46: l_search_string := FND_API.G_MISS_CHAR;

42: -- x_result_array := cs_kb_result_varray_type();
43: null;
44: -- check for G_MISS* per standard
45: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
46: l_search_string := FND_API.G_MISS_CHAR;
47: end if;
48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;
50: end if;

Line 48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then

44: -- check for G_MISS* per standard
45: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
46: l_search_string := FND_API.G_MISS_CHAR;
47: end if;
48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;
50: end if;
51: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
52: l_user_id := FND_API.G_MISS_NUM;

Line 49: l_updated_in_days := FND_API.G_MISS_NUM;

45: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
46: l_search_string := FND_API.G_MISS_CHAR;
47: end if;
48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;
50: end if;
51: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
52: l_user_id := FND_API.G_MISS_NUM;
53: end if;

Line 51: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then

47: end if;
48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;
50: end if;
51: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
52: l_user_id := FND_API.G_MISS_NUM;
53: end if;
54:
55: l_amv_req_obj.records_requested := p_rows_requested;

Line 52: l_user_id := FND_API.G_MISS_NUM;

48: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
49: l_updated_in_days := FND_API.G_MISS_NUM;
50: end if;
51: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
52: l_user_id := FND_API.G_MISS_NUM;
53: end if;
54:
55: l_amv_req_obj.records_requested := p_rows_requested;
56: l_amv_req_obj.start_record_position :=p_start_row_pos;

Line 83: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then

79: x_searchres_array => l_amv_res_array);
80:
81: x_amv_result_array := l_amv_res_array;
82:
83: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
84:
85: x_rows_returned
86: := l_amv_ret_obj.returned_record_count;
87: x_next_row_pos

Line 118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

114: -- the record type api.
115: --
116: PROCEDURE Specific_Search(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,

Line 119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

115: --
116: PROCEDURE Specific_Search(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 126: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_repository_tbl IN cs_kb_varchar100_tbl_type,
124: p_search_string IN VARCHAR2 := NULL,
125: p_updated_in_days IN NUMBER := NULL,
126: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
127: p_application_id IN NUMBER,
128: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
129: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
130: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,

Line 134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

130: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
131: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
132: p_user_id IN NUMBER := NULL,
133: p_category_id IN JTF_NUMBER_TABLE,
134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

131: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
132: p_user_id IN NUMBER := NULL,
133: p_category_id IN JTF_NUMBER_TABLE,
134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

134: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
135: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
136: p_rows_requested_tbl IN cs_kb_number_tbl_type,
137: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
138: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
139: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
140: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
141: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
142: x_result_array OUT NOCOPY cs_kb_result_varray_type

Line 159: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then

155: l_updated_in_days NUMBER := p_updated_in_days;
156: l_user_id NUMBER := p_user_id;
157: begin
158: -- check for G_MISS* per standard
159: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
160: l_search_string := FND_API.G_MISS_CHAR;
161: end if;
162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;

Line 160: l_search_string := FND_API.G_MISS_CHAR;

156: l_user_id NUMBER := p_user_id;
157: begin
158: -- check for G_MISS* per standard
159: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
160: l_search_string := FND_API.G_MISS_CHAR;
161: end if;
162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;
164: end if;

Line 162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then

158: -- check for G_MISS* per standard
159: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
160: l_search_string := FND_API.G_MISS_CHAR;
161: end if;
162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;
164: end if;
165: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
166: l_user_id := FND_API.G_MISS_NUM;

Line 163: l_updated_in_days := FND_API.G_MISS_NUM;

159: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
160: l_search_string := FND_API.G_MISS_CHAR;
161: end if;
162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;
164: end if;
165: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
166: l_user_id := FND_API.G_MISS_NUM;
167: end if;

Line 165: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then

161: end if;
162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;
164: end if;
165: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
166: l_user_id := FND_API.G_MISS_NUM;
167: end if;
168:
169: -- convert to amv record types

Line 166: l_user_id := FND_API.G_MISS_NUM;

162: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
163: l_updated_in_days := FND_API.G_MISS_NUM;
164: end if;
165: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
166: l_user_id := FND_API.G_MISS_NUM;
167: end if;
168:
169: -- convert to amv record types
170:

Line 245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

241: -- Main Specific search
242: --
243: PROCEDURE Specific_Search(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,

Line 246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

242: --
243: PROCEDURE Specific_Search(
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 253: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_repository_tbl IN cs_kb_varchar100_tbl_type,
251: p_search_string IN VARCHAR2 := NULL,
252: p_updated_in_days IN NUMBER := NULL,
253: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
254: p_application_id IN NUMBER,
255: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
256: := AMV_SEARCH_PVT.amv_char_varray_type(),
257: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

260: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
261: p_user_id IN NUMBER := NULL,
262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
263: :=AMV_SEARCH_PVT.amv_number_varray_type(),
264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

261: p_user_id IN NUMBER := NULL,
262: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
263: :=AMV_SEARCH_PVT.amv_number_varray_type(),
264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

264: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
265: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
266: p_rows_requested_tbl IN cs_kb_number_tbl_type,
267: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
268: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
269: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
270: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
271: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
272: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 286: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then

282: begin
283: savepoint Specific_Search_GRP;
284:
285: -- check for G_MISS* per standard
286: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
287: l_search_string := FND_API.G_MISS_CHAR;
288: end if;
289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;

Line 287: l_search_string := FND_API.G_MISS_CHAR;

283: savepoint Specific_Search_GRP;
284:
285: -- check for G_MISS* per standard
286: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
287: l_search_string := FND_API.G_MISS_CHAR;
288: end if;
289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;
291: end if;

Line 289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then

285: -- check for G_MISS* per standard
286: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
287: l_search_string := FND_API.G_MISS_CHAR;
288: end if;
289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;
291: end if;
292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
293: l_user_id := FND_API.G_MISS_NUM;

Line 290: l_updated_in_days := FND_API.G_MISS_NUM;

286: if l_search_string is null or l_search_string = FND_API.G_MISS_CHAR then
287: l_search_string := FND_API.G_MISS_CHAR;
288: end if;
289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;
291: end if;
292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
293: l_user_id := FND_API.G_MISS_NUM;
294: end if;

Line 292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then

288: end if;
289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;
291: end if;
292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
293: l_user_id := FND_API.G_MISS_NUM;
294: end if;
295:
296: if not FND_API.Compatible_API_Call(

Line 293: l_user_id := FND_API.G_MISS_NUM;

289: if l_updated_in_days is null or l_updated_in_days = FND_API.G_MISS_NUM then
290: l_updated_in_days := FND_API.G_MISS_NUM;
291: end if;
292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
293: l_user_id := FND_API.G_MISS_NUM;
294: end if;
295:
296: if not FND_API.Compatible_API_Call(
297: l_api_version,

Line 296: if not FND_API.Compatible_API_Call(

292: if l_user_id is null or l_user_id = FND_API.G_MISS_NUM then
293: l_user_id := FND_API.G_MISS_NUM;
294: end if;
295:
296: if not FND_API.Compatible_API_Call(
297: l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) then

Line 301: raise FND_API.G_EXC_UNEXPECTED_ERROR;

297: l_api_version,
298: p_api_version,
299: l_api_name,
300: G_PKG_NAME) then
301: raise FND_API.G_EXC_UNEXPECTED_ERROR;
302: end if;
303:
304: if FND_API.to_Boolean(p_init_msg_list) then
305: FND_MSG_PUB.initialize;

Line 304: if FND_API.to_Boolean(p_init_msg_list) then

300: G_PKG_NAME) then
301: raise FND_API.G_EXC_UNEXPECTED_ERROR;
302: end if;
303:
304: if FND_API.to_Boolean(p_init_msg_list) then
305: FND_MSG_PUB.initialize;
306: end if;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304: if FND_API.to_Boolean(p_init_msg_list) then
305: FND_MSG_PUB.initialize;
306: end if;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: -- -- -- -- begin my code -- -- -- -- --
310: -- x_row_return_obj := cs_kb_rowret_obj_type(0, 0, 0);
311:
312: -- this same array can be wrtten by both sms and mes search in out.

Line 324: raise FND_API.G_EXC_ERROR;

320: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
321: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
322: fnd_msg_pub.Add;
323: end if;
324: raise FND_API.G_EXC_ERROR;
325: end if;
326:
327: ind := p_repository_tbl.FIRST;
328: while ind is not null loop

Line 373: WHEN FND_API.G_EXC_ERROR THEN

369: p_count => x_msg_count,
370: p_data => x_msg_data );
371:
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO Specific_Search_GRP;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(
377: p_count => x_msg_count,

Line 375: x_return_status := FND_API.G_RET_STS_ERROR ;

371:
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO Specific_Search_GRP;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(
377: p_count => x_msg_count,
378: p_data => x_msg_data );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(
377: p_count => x_msg_count,
378: p_data => x_msg_data );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Specific_Search_GRP;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get(
383: p_count => x_msg_count,

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: p_count => x_msg_count,
378: p_data => x_msg_data );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Specific_Search_GRP;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get(
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385:

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

384: p_data => x_msg_data);
385:
386: WHEN OTHERS THEN
387: ROLLBACK TO Specific_Search_GRP;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level
390: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg(
392: G_PKG_NAME,