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

Line 132: RAISE FND_API.g_exc_error;

128: -- FND_MESSAGE.set_name('AMS', 'AMS_INVALID_SOURCE_CODE');
129: FND_MESSAGE.set_name('BIM', 'BIM_INVALID_SOURCE_CODE');
130: FND_MSG_PUB.add;
131: END IF;
132: RAISE FND_API.g_exc_error;
133: END IF;
134: CLOSE c_source_code;
135:
136: -- dbms_output.put_line('source code validated');

Line 149: RAISE FND_API.g_exc_error;

145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
146: FND_MESSAGE.set_name('BIM', 'BIM_INVALID_COUNTRY_CODE');
147: FND_MSG_PUB.add;
148: END IF;
149: RAISE FND_API.g_exc_error;
150: END IF;
151: CLOSE c_country_code;
152:
153: --dbms_output.put_line('country code validated');

Line 165: RAISE FND_API.g_exc_error;

161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
162: FND_MESSAGE.set_name('BIM', 'BIM_RESP_DUPLICATE_RECORD');
163: FND_MSG_PUB.add;
164: END IF;
165: RAISE FND_API.g_exc_error;
166: END IF;
167: CLOSE c_duplicate;
168:
169: --Cursor to fetch the lookup codes defined in Grade look up into local table

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
187: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_GRADE');
188: FND_MSG_PUB.add;
189: END IF;
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192: --dbms_output.put_line('l_local_resp_grade_table.COUNT'|| l_local_resp_grade_table.COUNT);
193:
194: FOR j IN 1.. l_local_resp_grade_table.COUNT

Line 209: RAISE FND_API.g_exc_error;

205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
206: FND_MESSAGE.set_name('BIM', 'BIM_INVALID_GRADE');
207: FND_MSG_PUB.add;
208: END IF;
209: RAISE FND_API.g_exc_error;
210: END IF;
211:
212: --dbms_output.put_line('response Grade is '||l_response_grade_table(i).response_grade);
213:

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
240: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_REASON');
241: FND_MSG_PUB.add;
242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- dbms_output.put_line('l_local_resp_invalid_table.COUNT'|| l_local_resp_invalid_table.COUNT);
247:

Line 263: RAISE FND_API.g_exc_error;

259: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
260: FND_MESSAGE.set_name('BIM', 'BIM_INVALID_REJECT_REASON');
261: FND_MSG_PUB.add;
262: END IF;
263: RAISE FND_API.g_exc_error;
264: END IF;
265:
266: END LOOP;
267:

Line 271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

267:
268: -- dbms_output.put_line('reason validated');
269: END IF;
270: EXCEPTION
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO VALIDATE_RESPONSES;
273: --dbms_output.put_line('in un excepted exception block');
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: -- Standard call to get message count and if count=1, get the message

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: EXCEPTION
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO VALIDATE_RESPONSES;
273: --dbms_output.put_line('in un excepted exception block');
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,

Line 277: p_encoded => FND_API.G_FALSE,

273: --dbms_output.put_line('in un excepted exception block');
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281:

Line 282: WHEN FND_API.g_exc_error THEN

278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );
281:
282: WHEN FND_API.g_exc_error THEN
283: --dbms_output.put_line('in exception block');
284: --dbms_output.put_line('in exception block');
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(

Line 285: x_return_status := FND_API.g_ret_sts_error;

281:
282: WHEN FND_API.g_exc_error THEN
283: --dbms_output.put_line('in exception block');
284: --dbms_output.put_line('in exception block');
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data

Line 287: p_encoded => FND_API.g_false,

283: --dbms_output.put_line('in exception block');
284: --dbms_output.put_line('in exception block');
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );
291:

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291:
292: WHEN OTHERS THEN
293: ROLLBACK TO VALIDATE_RESPONSES;
294: -- dbms_output.put_line('in others exception block');
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
297: THEN
298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
299: END IF;

Line 302: p_encoded => FND_API.G_FALSE,

298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
299: END IF;
300: -- Standard call to get message count and if count=1, get the message
301: FND_MSG_PUB.Count_And_Get (
302: p_encoded => FND_API.G_FALSE,
303: p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306:

Line 322: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

318: -- Parameters
319: --
320: -- IN
321: -- p_api_version_number IN NUMBER Optional Default = 1.0
322: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_interface_header_id IN NUMBER
326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

Line 323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

319: --
320: -- IN
321: -- p_api_version_number IN NUMBER Optional Default = 1.0
322: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_interface_header_id IN NUMBER
326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
327: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

Line 324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

320: -- IN
321: -- p_api_version_number IN NUMBER Optional Default = 1.0
322: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_interface_header_id IN NUMBER
326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
327: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_interface_header_id IN NUMBER

Line 326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

322: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_interface_header_id IN NUMBER
326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
327: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_interface_header_id IN NUMBER
329: -- p_response_hdr_rec IN response_hdr_rec_type,
330: -- p_response_grade_table IN response_grade_table_type,

Line 327: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

323: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
324: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
325: -- p_interface_header_id IN NUMBER
326: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
327: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_interface_header_id IN NUMBER
329: -- p_response_hdr_rec IN response_hdr_rec_type,
330: -- p_response_grade_table IN response_grade_table_type,
331: -- p_response_invalid_table IN response_invalid_table_type,

Line 346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

342: --
343:
344: PROCEDURE IMPORT_RESPONSES(
345: p_api_version_number IN NUMBER := 1.0,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: p_response_hdr_rec IN response_hdr_rec_type,
350: p_response_grade_table IN response_grade_table_type,

Line 347: p_commit IN VARCHAR2 := FND_API.G_FALSE,

343:
344: PROCEDURE IMPORT_RESPONSES(
345: p_api_version_number IN NUMBER := 1.0,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: p_response_hdr_rec IN response_hdr_rec_type,
350: p_response_grade_table IN response_grade_table_type,
351: p_response_invalid_table IN response_invalid_table_type,

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

344: PROCEDURE IMPORT_RESPONSES(
345: p_api_version_number IN NUMBER := 1.0,
346: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
347: p_commit IN VARCHAR2 := FND_API.G_FALSE,
348: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349: p_response_hdr_rec IN response_hdr_rec_type,
350: p_response_grade_table IN response_grade_table_type,
351: p_response_invalid_table IN response_invalid_table_type,
352: x_return_status OUT NOCOPY VARCHAR2,

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
427: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_SOURCE_CODE');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: END IF;
432:
433: IF l_response_country IS NULL
434: THEN

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
436: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_COUNTRY_CODE');
437: FND_MSG_PUB.add;
438: END IF;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: IF l_response_creation_date IS NULL
443: THEN

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
445: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_CREATE_DATE');
446: FND_MSG_PUB.add;
447: END IF;
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: IF l_response_source IS NULL
452: THEN

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
454: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_RESPONSE_SOURCE');
455: FND_MSG_PUB.add;
456: END IF;
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: -- dbms_output.put_line('Before validate');
461: VALIDATE_RESPONSES(

Line 474: IF l_return_status = FND_API.g_ret_sts_error THEN

470: x_msg_data => x_msg_data
471: );
472:
473: -- dbms_output.put_line('after validate');
474: IF l_return_status = FND_API.g_ret_sts_error THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;
478: END IF;

Line 475: RAISE FND_API.G_EXC_ERROR;

471: );
472:
473: -- dbms_output.put_line('after validate');
474: IF l_return_status = FND_API.g_ret_sts_error THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;
478: END IF;
479: -- dbms_output.put_line('validation ends..back to import');

Line 476: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

472:
473: -- dbms_output.put_line('after validate');
474: IF l_return_status = FND_API.g_ret_sts_error THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;
478: END IF;
479: -- dbms_output.put_line('validation ends..back to import');
480:

Line 477: RAISE FND_API.g_exc_unexpected_error;

473: -- dbms_output.put_line('after validate');
474: IF l_return_status = FND_API.g_ret_sts_error THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;
478: END IF;
479: -- dbms_output.put_line('validation ends..back to import');
480:
481: -- Validation Ends

Line 519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
516: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_OBJECT_ID');
517: FND_MSG_PUB.add;
518: END IF;
519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
520: END IF;
521:
522: IF l_obj_type IS NULL
523: THEN

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
525: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_OBJECT_TYPE');
526: FND_MSG_PUB.add;
527: END IF;
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530:
531: IF l_region_code IS NULL
532: THEN

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
534: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_REGION_CODE');
535: FND_MSG_PUB.add;
536: END IF;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539:
540: IF l_source_code_id IS NULL
541: THEN

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
543: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_SOURCE_CODE_ID');
544: FND_MSG_PUB.add;
545: END IF;
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:
549: IF l_process_flag IS NULL
550: THEN

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
552: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_PROCESS_FLAG');
553: FND_MSG_PUB.add;
554: END IF;
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557:
558: IF l_interface_header_id IS NULL
559: THEN

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
561: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_HEADER_ID');
562: FND_MSG_PUB.add;
563: END IF;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567: INSERT INTO BIM_R_RESP_INT_HEADER
568: (

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_GRADE_COUNT');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END IF;
626:
627: IF l_interface_grade_id IS NULL
628: THEN

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
630: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_GRADE_ID');
631: FND_MSG_PUB.add;
632: END IF;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635:
636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
679: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_REASON_COUNT');
680: FND_MSG_PUB.add;
681: END IF;
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: OPEN c_reason_id;
686: FETCH c_reason_id INTO l_interface_reason_id;

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
692: FND_MESSAGE.set_name('BIM', 'BIM_RESP_NO_REASON_ID');
693: FND_MSG_PUB.add;
694: END IF;
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );

Line 735: IF FND_API.to_boolean(p_commit) THEN

731: --dbms_output.put_line('end inserting into bim_r_resp_int_reason');
732: END IF;
733:
734: -- Check for commit
735: IF FND_API.to_boolean(p_commit) THEN
736: COMMIT;
737: END IF;
738:
739: EXCEPTION

Line 741: WHEN FND_API.G_EXC_ERROR THEN

737: END IF;
738:
739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO IMPORT_RESPONSES;
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.count_and_get(
745: p_encoded => FND_API.g_false,

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: EXCEPTION
740:
741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO IMPORT_RESPONSES;
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.count_and_get(
745: p_encoded => FND_API.g_false,
746: p_count => x_msg_count,
747: p_data => x_msg_data

Line 745: p_encoded => FND_API.g_false,

741: WHEN FND_API.G_EXC_ERROR THEN
742: ROLLBACK TO IMPORT_RESPONSES;
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.count_and_get(
745: p_encoded => FND_API.g_false,
746: p_count => x_msg_count,
747: p_data => x_msg_data
748: );
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: p_encoded => FND_API.g_false,
746: p_count => x_msg_count,
747: p_data => x_msg_data
748: );
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO IMPORT_RESPONSES;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

747: p_data => x_msg_data
748: );
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO IMPORT_RESPONSES;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,

Line 754: p_encoded => FND_API.G_FALSE,

750: ROLLBACK TO IMPORT_RESPONSES;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data
757: );
758: WHEN OTHERS THEN

Line 760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

756: p_data => x_msg_data
757: );
758: WHEN OTHERS THEN
759: ROLLBACK TO IMPORT_RESPONSES;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
764: END IF;

Line 767: p_encoded => FND_API.G_FALSE,

763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
764: END IF;
765: -- Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771: