DBA Data[Home] [Help]

APPS.WMS_CONTROL_BOARD dependencies on FND_MESSAGE

Line 470: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

466: OPEN C_mcce;
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

Line 477: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

473: CLOSE C_mcce;
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

Line 487: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

483: OPEN C_mmtt;
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

Line 494: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

490: CLOSE C_mmtt;
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;

Line 505: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

501: (recinfo_mmtt.transaction_temp_id,recinfo_mcce.cycle_count_entry_id)
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

Line 518: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

514: OPEN C_wdt;
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

Line 525: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

521: CLOSE C_wdt;
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:

Line 535: fnd_message.set_name('FND','FORM_RECORD_CHANGED');

531: AND (recinfo_wdt.task_id = p_task_id)
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;

Line 583: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

579: OPEN C_mcce;
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

Line 590: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

586: CLOSE C_mcce;
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

Line 614: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

610: mydebug('dbms_lock:l_return_value:'||l_return_value);
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

Line 624: fnd_message.set_name('WMS', 'WMS_RECORD_BEING_UPDATED');

620: IF ((SQLCODE = -54) OR l_return_value IN (1,2)) THEN --record locked by other session
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;

Line 893: fnd_message.set_name('WMS', 'WMS_TASK_STATUS_CHG_NOTALLOWED');

889: -- Check whether the change of status is valid
890: --dbms_output.put_line('in validate' || from_status || ':' || to_status || ':' || is_status_valid(from_status, to_status));
891:
892: IF is_status_valid(from_status, to_status) <> 'Y' THEN
893: fnd_message.set_name('WMS', 'WMS_TASK_STATUS_CHG_NOTALLOWED');
894: fnd_message.set_token('FROM_STATUS', from_status_code);
895: fnd_message.set_token('TO_STATUS', to_status_code);
896: fnd_msg_pub.add;
897: RAISE fnd_api.g_exc_error;

Line 894: fnd_message.set_token('FROM_STATUS', from_status_code);

890: --dbms_output.put_line('in validate' || from_status || ':' || to_status || ':' || is_status_valid(from_status, to_status));
891:
892: IF is_status_valid(from_status, to_status) <> 'Y' THEN
893: fnd_message.set_name('WMS', 'WMS_TASK_STATUS_CHG_NOTALLOWED');
894: fnd_message.set_token('FROM_STATUS', from_status_code);
895: fnd_message.set_token('TO_STATUS', to_status_code);
896: fnd_msg_pub.add;
897: RAISE fnd_api.g_exc_error;
898: END IF;

Line 895: fnd_message.set_token('TO_STATUS', to_status_code);

891:
892: IF is_status_valid(from_status, to_status) <> 'Y' THEN
893: fnd_message.set_name('WMS', 'WMS_TASK_STATUS_CHG_NOTALLOWED');
894: fnd_message.set_token('FROM_STATUS', from_status_code);
895: fnd_message.set_token('TO_STATUS', to_status_code);
896: fnd_msg_pub.add;
897: RAISE fnd_api.g_exc_error;
898: END IF;
899: