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.BSC_MULTI_USER_PVT dependencies on FND_MSG_PUB

Line 23: FND_MSG_PUB.Initialize;

19: l_time_stamp date;
20:
21: begin
22:
23: FND_MSG_PUB.Initialize;
24:
25: l_time_stamp := to_date(p_time_stamp, 'DD-MM-YYYY-HH24-MI-SS');
26:
27: x_return_status := null;

Line 129: FND_MSG_PUB.Initialize;

125:
126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: rollback;
129: FND_MSG_PUB.Initialize;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

127: WHEN FND_API.G_EXC_ERROR THEN
128: rollback;
129: FND_MSG_PUB.Initialize;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: rollback;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: rollback;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
137: ,p_data => x_msg_data);
138: WHEN NO_DATA_FOUND THEN
139: rollback;
140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

137: ,p_data => x_msg_data);
138: WHEN NO_DATA_FOUND THEN
139: rollback;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
142: ,p_data => x_msg_data);
143: WHEN OTHERS THEN
144: rollback;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 146: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

142: ,p_data => x_msg_data);
143: WHEN OTHERS THEN
144: rollback;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
147: ,p_data => x_msg_data);
148:
149: end Apply_Multi_User_Env;
150:

Line 185: FND_MSG_PUB.Initialize;

181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: rollback;
185: FND_MSG_PUB.Initialize;
186: --x_return_status := FND_API.G_RET_STS_ERROR;
187: x_return_status := 'C';
188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
189: ,p_data => x_msg_data);

Line 188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

184: rollback;
185: FND_MSG_PUB.Initialize;
186: --x_return_status := FND_API.G_RET_STS_ERROR;
187: x_return_status := 'C';
188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: rollback;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

189: ,p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: rollback;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
194: ,p_data => x_msg_data);
195: WHEN NO_DATA_FOUND THEN
196: rollback;
197: x_return_status := FND_API.G_RET_STS_ERROR;

Line 198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

194: ,p_data => x_msg_data);
195: WHEN NO_DATA_FOUND THEN
196: rollback;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: rollback;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: rollback;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: ,p_data => x_msg_data);
205:
206: end Have_Time_Stamps_Changed;
207:

Line 236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: rollback;
235: x_return_status := 'C';
236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
237: ,p_data => x_msg_data);
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: rollback;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

237: ,p_data => x_msg_data);
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: rollback;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
242: ,p_data => x_msg_data);
243: WHEN NO_DATA_FOUND THEN
244: rollback;
245: x_return_status := 'D';

Line 246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

242: ,p_data => x_msg_data);
243: WHEN NO_DATA_FOUND THEN
244: rollback;
245: x_return_status := 'D';
246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
247: ,p_data => x_msg_data);
248: WHEN OTHERS THEN
249: rollback;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

247: ,p_data => x_msg_data);
248: WHEN OTHERS THEN
249: rollback;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
252: ,p_data => x_msg_data);
253:
254: end Check_Tab_Time_Stamp;
255:

Line 290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: rollback;
289: x_return_status := 'C';
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: ,p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: rollback;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 295: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

291: ,p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: rollback;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
296: ,p_data => x_msg_data);
297: WHEN NO_DATA_FOUND THEN
298: rollback;
299: x_return_status := 'D';

Line 300: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

296: ,p_data => x_msg_data);
297: WHEN NO_DATA_FOUND THEN
298: rollback;
299: x_return_status := 'D';
300: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
301: ,p_data => x_msg_data);
302: WHEN OTHERS THEN
303: rollback;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

301: ,p_data => x_msg_data);
302: WHEN OTHERS THEN
303: rollback;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
306: ,p_data => x_msg_data);
307:
308: end Check_Kpi_Time_Stamp;
309:

Line 339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

335: EXCEPTION
336: WHEN FND_API.G_EXC_ERROR THEN
337: rollback;
338: x_return_status := 'C';
339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: rollback;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: rollback;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN NO_DATA_FOUND THEN
347: rollback;
348: x_return_status := FND_API.G_RET_STS_ERROR;

Line 349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

345: ,p_data => x_msg_data);
346: WHEN NO_DATA_FOUND THEN
347: rollback;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN OTHERS THEN
352: rollback;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 354: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

350: ,p_data => x_msg_data);
351: WHEN OTHERS THEN
352: rollback;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
355: ,p_data => x_msg_data);
356:
357: end Check_System_Change;
358:

Line 387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN
385: -- rollback;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: -- rollback;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: -- rollback;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
393: ,p_data => x_msg_data);
394: WHEN NO_DATA_FOUND THEN
395: -- rollback;
396: x_return_status := 'D';

Line 398: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

394: WHEN NO_DATA_FOUND THEN
395: -- rollback;
396: x_return_status := 'D';
397: -- x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
399: ,p_data => x_msg_data);
400: WHEN OTHERS THEN
401: -- rollback;
402: if SQLCODE = -00054 then

Line 404: FND_MSG_PUB.ADD;

400: WHEN OTHERS THEN
401: -- rollback;
402: if SQLCODE = -00054 then
403: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');
404: FND_MSG_PUB.ADD;
405: x_return_status := 'L';
406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
407: ,p_data => x_msg_data);
408: else

Line 406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

402: if SQLCODE = -00054 then
403: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');
404: FND_MSG_PUB.ADD;
405: x_return_status := 'L';
406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
407: ,p_data => x_msg_data);
408: else
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
407: ,p_data => x_msg_data);
408: else
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
411: ,p_data => x_msg_data);
412: IF (x_msg_data IS NULL) THEN
413: x_msg_data := SQLERRM||' at BSC_MULTI_USER_PVT.Tab_Details_Lock ';
414: END IF;

Line 457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: rollback;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
458: ,p_data => x_msg_data);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: rollback;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

458: ,p_data => x_msg_data);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: rollback;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN NO_DATA_FOUND THEN
465: rollback;
466: x_return_status := 'D';

Line 468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

464: WHEN NO_DATA_FOUND THEN
465: rollback;
466: x_return_status := 'D';
467: -- x_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
469: ,p_data => x_msg_data);
470: WHEN OTHERS THEN
471: rollback;
472: if SQLCODE = -00054 then

Line 474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

470: WHEN OTHERS THEN
471: rollback;
472: if SQLCODE = -00054 then
473: x_return_status := 'L';
474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
475: ,p_data => x_msg_data);
476: else
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
475: ,p_data => x_msg_data);
476: else
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
479: ,p_data => x_msg_data);
480: end if;
481:
482: end Tab_Delete_Lock;

Line 512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: rollback;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
513: ,p_data => x_msg_data);
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: rollback;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 517: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

513: ,p_data => x_msg_data);
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: rollback;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
518: ,p_data => x_msg_data);
519: WHEN NO_DATA_FOUND THEN
520: rollback;
521: x_return_status := 'D';

Line 523: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

519: WHEN NO_DATA_FOUND THEN
520: rollback;
521: x_return_status := 'D';
522: -- x_return_status := FND_API.G_RET_STS_ERROR;
523: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
524: ,p_data => x_msg_data);
525: WHEN OTHERS THEN
526: rollback;
527: if SQLCODE = -00054 then

Line 529: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

525: WHEN OTHERS THEN
526: rollback;
527: if SQLCODE = -00054 then
528: x_return_status := 'L';
529: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
530: ,p_data => x_msg_data);
531: else
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 533: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

529: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
530: ,p_data => x_msg_data);
531: else
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
534: ,p_data => x_msg_data);
535: end if;
536:
537: end Tab_Select_Items_Lock;

Line 571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: rollback;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
572: ,p_data => x_msg_data);
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: rollback;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

572: ,p_data => x_msg_data);
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: rollback;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN NO_DATA_FOUND THEN
579: rollback;
580: x_return_status := 'D';

Line 582: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

578: WHEN NO_DATA_FOUND THEN
579: rollback;
580: x_return_status := 'D';
581: -- x_return_status := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
583: ,p_data => x_msg_data);
584: WHEN OTHERS THEN
585: rollback;
586: if SQLCODE = -00054 then

Line 588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

584: WHEN OTHERS THEN
585: rollback;
586: if SQLCODE = -00054 then
587: x_return_status := 'L';
588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
589: ,p_data => x_msg_data);
590: else
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
589: ,p_data => x_msg_data);
590: else
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
593: ,p_data => x_msg_data);
594: end if;
595:
596: end Kpi_Lock;

Line 636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);
643: WHEN NO_DATA_FOUND THEN
644: rollback;
645: x_return_status := 'D';

Line 647: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

643: WHEN NO_DATA_FOUND THEN
644: rollback;
645: x_return_status := 'D';
646: -- x_return_status := FND_API.G_RET_STS_ERROR;
647: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
648: ,p_data => x_msg_data);
649: WHEN OTHERS THEN
650: rollback;
651: if SQLCODE = -00054 then

Line 653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

649: WHEN OTHERS THEN
650: rollback;
651: if SQLCODE = -00054 then
652: x_return_status := 'L';
653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
654: ,p_data => x_msg_data);
655: else
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 657: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
654: ,p_data => x_msg_data);
655: else
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
658: ,p_data => x_msg_data);
659: end if;
660:
661: end Option_Lock;

Line 697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: rollback;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: rollback;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

698: ,p_data => x_msg_data);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: rollback;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
703: ,p_data => x_msg_data);
704: WHEN NO_DATA_FOUND THEN
705: rollback;
706: x_return_status := 'D';

Line 708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

704: WHEN NO_DATA_FOUND THEN
705: rollback;
706: x_return_status := 'D';
707: -- x_return_status := FND_API.G_RET_STS_ERROR;
708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
709: ,p_data => x_msg_data);
710: WHEN OTHERS THEN
711: rollback;
712: if SQLCODE = -00054 then

Line 714: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

710: WHEN OTHERS THEN
711: rollback;
712: if SQLCODE = -00054 then
713: x_return_status := 'L';
714: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
715: ,p_data => x_msg_data);
716: else
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 718: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

714: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
715: ,p_data => x_msg_data);
716: else
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
719: ,p_data => x_msg_data);
720: end if;
721:
722: end Dim_Level_Lock;