APPS.BIM_RESPONSE_IMPORT_PUB dependencies on FND_MSG_PUB

Line 127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

123: OPEN c_source_code(l_source_code);
124: FETCH c_source_code INTO l_dummy;
125: IF c_source_code%NOTFOUND THEN
126: CLOSE c_source_code;
127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 130: FND_MSG_PUB.add;

126: CLOSE c_source_code;
127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
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;

Line 145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

141: OPEN c_country_code(l_response_country);
142: FETCH c_country_code INTO l_dummy;
143: IF c_country_code%NOTFOUND THEN
144: CLOSE c_country_code;
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;

Line 147: FND_MSG_PUB.add;

143: IF c_country_code%NOTFOUND THEN
144: CLOSE c_country_code;
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;

Line 161: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

157: OPEN c_duplicate(l_source_code,l_response_country,l_response_creation_date,l_response_source);
158: FETCH c_duplicate INTO l_dummy;
159: IF c_duplicate%FOUND THEN
160: CLOSE c_duplicate;
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;

Line 163: FND_MSG_PUB.add;

159: IF c_duplicate%FOUND THEN
160: CLOSE c_duplicate;
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;

Line 186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

182: LOOP
183:
184: IF l_response_grade_table(i).response_grade IS NULL
185: THEN
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;

Line 188: FND_MSG_PUB.add;

184: IF l_response_grade_table(i).response_grade IS NULL
185: THEN
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);

Line 205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

201: end if;
202: end loop;
203: --dbms_output.put_line('grade passed'|| l_grade_flag);
204: IF (l_grade_flag<>'T') THEN
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;

Line 207: FND_MSG_PUB.add;

203: --dbms_output.put_line('grade passed'|| l_grade_flag);
204: IF (l_grade_flag<>'T') THEN
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:

Line 239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

235: --dbms_output.put_line('response reason is '||l_response_invalid_table(j).invalid_reason);
236:
237: IF l_response_invalid_table(j).invalid_reason IS NULL
238: THEN
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;

Line 241: FND_MSG_PUB.add;

237: IF l_response_invalid_table(j).invalid_reason IS NULL
238: THEN
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:

Line 259: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

255: end if;
256: end loop;
257: --dbms_output.put_line('reason passed'|| l_reason_flag);
258: IF (l_reason_flag<>'T') THEN
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;

Line 261: FND_MSG_PUB.add;

257: --dbms_output.put_line('reason passed'|| l_reason_flag);
258: IF (l_reason_flag<>'T') THEN
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:

Line 276: FND_MSG_PUB.Count_And_Get (

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,
279: p_data => x_msg_data
280: );

Line 286: FND_MSG_PUB.count_and_get(

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
290: );

Line 296: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
300: -- Standard call to get message count and if count=1, get the message

Line 298: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 301: FND_MSG_PUB.Count_And_Get (

297: THEN
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: );

Line 426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

422: l_response_creation_date := l_local_resp_hdr_rec.response_create_date;
423:
424: IF l_source_code IS NULL
425: THEN
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;

Line 428: FND_MSG_PUB.add;

424: IF l_source_code IS NULL
425: THEN
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:

Line 435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

431: END IF;
432:
433: IF l_response_country IS NULL
434: THEN
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;

Line 437: FND_MSG_PUB.add;

433: IF l_response_country IS NULL
434: THEN
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:

Line 444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

440: END IF;
441:
442: IF l_response_creation_date IS NULL
443: THEN
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;

Line 446: FND_MSG_PUB.add;

442: IF l_response_creation_date IS NULL
443: THEN
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:

Line 453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

449: END IF;
450:
451: IF l_response_source IS NULL
452: THEN
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;

Line 455: FND_MSG_PUB.add;

451: IF l_response_source IS NULL
452: THEN
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:

Line 515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

511: --dbms_output.put_line('before inserting into BIM_R_RESP_INT_HEADER object_type '||l_obj_type );
512:
513: IF l_object_id IS NULL
514: THEN
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;

Line 517: FND_MSG_PUB.add;

513: IF l_object_id IS NULL
514: THEN
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:

Line 524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

520: END IF;
521:
522: IF l_obj_type IS NULL
523: THEN
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;

Line 526: FND_MSG_PUB.add;

522: IF l_obj_type IS NULL
523: THEN
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:

Line 533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

529: END IF;
530:
531: IF l_region_code IS NULL
532: THEN
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;

Line 535: FND_MSG_PUB.add;

531: IF l_region_code IS NULL
532: THEN
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:

Line 542: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

538: END IF;
539:
540: IF l_source_code_id IS NULL
541: THEN
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;

Line 544: FND_MSG_PUB.add;

540: IF l_source_code_id IS NULL
541: THEN
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:

Line 551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

547: END IF;
548:
549: IF l_process_flag IS NULL
550: THEN
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;

Line 553: FND_MSG_PUB.add;

549: IF l_process_flag IS NULL
550: THEN
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:

Line 560: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

556: END IF;
557:
558: IF l_interface_header_id IS NULL
559: THEN
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;

Line 562: FND_MSG_PUB.add;

558: IF l_interface_header_id IS NULL
559: THEN
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:

Line 620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

616: FETCH c_grade_id INTO l_interface_grade_id;
617: CLOSE c_grade_id;
618: IF l_response_grade_table (i).response_grade_count IS NULL
619: THEN
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;

Line 622: FND_MSG_PUB.add;

618: IF l_response_grade_table (i).response_grade_count IS NULL
619: THEN
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:

Line 629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

625: END IF;
626:
627: IF l_interface_grade_id IS NULL
628: THEN
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;

Line 631: FND_MSG_PUB.add;

627: IF l_interface_grade_id IS NULL
628: THEN
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:

Line 678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

674: FOR j IN 1..l_response_invalid_table.COUNT LOOP
675:
676: IF l_response_invalid_table (j).invalid_responses IS NULL
677: THEN
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;

Line 680: FND_MSG_PUB.add;

676: IF l_response_invalid_table (j).invalid_responses IS NULL
677: THEN
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:

Line 691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

687: CLOSE c_reason_id;
688:
689: IF l_interface_reason_id IS NULL
690: THEN
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;

Line 693: FND_MSG_PUB.add;

689: IF l_interface_reason_id IS NULL
690: THEN
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:

Line 744: FND_MSG_PUB.count_and_get(

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
748: );

Line 753: FND_MSG_PUB.Count_And_Get (

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,
756: p_data => x_msg_data
757: );

Line 761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
765: -- Standard call to get message count and if count=1, get the message

Line 763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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;
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,

Line 766: FND_MSG_PUB.Count_And_Get (

762: THEN
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: );