APPS.WMS_CONTROL_BOARD dependencies on APP_EXCEPTION

Line 471: app_exception.raise_exception;

467: FETCH C_mcce INTO recinfo_mcce;
468: IF (c_mcce%notfound) THEN
469: CLOSE C_mcce;
470: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
471: app_exception.raise_exception;
472: END IF;
473: CLOSE C_mcce;
474: EXCEPTION
475: WHEN OTHERS THEN

Line 478: app_exception.raise_exception;

474: EXCEPTION
475: WHEN OTHERS THEN
476: IF SQLCODE = -54 THEN --record locked by other session
477: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
478: app_exception.raise_exception;
479: END IF;
480: END;
481: ELSE
482: BEGIN

Line 488: app_exception.raise_exception;

484: FETCH C_mmtt INTO recinfo_mmtt;
485: IF (c_mmtt%notfound) THEN
486: CLOSE C_mmtt;
487: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
488: app_exception.raise_exception;
489: END IF;
490: CLOSE C_mmtt;
491: EXCEPTION
492: WHEN OTHERS THEN

Line 495: app_exception.raise_exception;

491: EXCEPTION
492: WHEN OTHERS THEN
493: IF SQLCODE = -54 THEN --record locked by other session
494: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
495: app_exception.raise_exception;
496: END IF;
497: END;
498: END IF;
499:

Line 506: app_exception.raise_exception;

502: ) THEN -- kkoothan
503: NULL;
504: ELSE
505: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
506: app_exception.raise_exception;
507: END IF;
508:
509: IF p_status =1 THEN
510: -- Pending task, no need to lock wdt

Line 519: app_exception.raise_exception;

515: FETCH C_wdt INTO recinfo_wdt;
516: IF (c_wdt%notfound) THEN
517: CLOSE C_wdt;
518: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
519: app_exception.raise_exception;
520: END IF;
521: CLOSE C_wdt;
522: EXCEPTION
523: WHEN OTHERS THEN

Line 526: app_exception.raise_exception;

522: EXCEPTION
523: WHEN OTHERS THEN
524: IF SQLCODE = -54 THEN --record locked by other session
525: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
526: app_exception.raise_exception;
527: END IF;
528: END;
529:
530: IF( (recinfo_wdt.transaction_temp_id = p_transaction_temp_id)

Line 536: app_exception.raise_exception;

532: ) THEN
533: NULL;
534: ELSE
535: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
536: app_exception.raise_exception;
537: END IF;
538:
539: END;
540: */

Line 584: app_exception.raise_exception;

580: FETCH C_mcce INTO recinfo_mcce;
581: IF (c_mcce%notfound) THEN
582: CLOSE C_mcce;
583: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
584: app_exception.raise_exception;
585: END IF;
586: CLOSE C_mcce;
587: EXCEPTION
588: WHEN OTHERS THEN

Line 591: app_exception.raise_exception;

587: EXCEPTION
588: WHEN OTHERS THEN
589: IF SQLCODE = -54 THEN --record locked by other session
590: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
591: app_exception.raise_exception;
592: END IF;
593: END;
594: ELSE
595: IF (l_debug = 1) THEN

Line 615: app_exception.raise_exception;

611: END IF;
612:
613: IF l_return_value IN (1,2) THEN
614: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
615: app_exception.raise_exception;
616: END IF;
617:
618: EXCEPTION
619: WHEN OTHERS THEN

Line 625: app_exception.raise_exception;

621: IF (l_debug = 1) THEN
622: mydebug('INSIDE EXCEPTION');
623: END IF;
624: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');
625: app_exception.raise_exception;
626:
627: END IF;
628: END;
629: