DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on FND_MESSAGE

Line 102: fnd_message.set_name('WMS', 'WMS_LPN_PROC_WARN');

98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;
100: ELSE
101: IF (l_partial_success = 'Y') THEN
102: fnd_message.set_name('WMS', 'WMS_LPN_PROC_WARN');
103: fnd_msg_pub.add;
104: print_message();
105: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
106: l_conc_status := fnd_concurrent.set_completion_status('WARNING',l_msg);

Line 179: fnd_message.set_name('WMS', 'WMS_NOT_INSTALLED');

175: p_organization_id => p_org_id
176: );
177:
178: IF (NOT l_wms_install) THEN
179: fnd_message.set_name('WMS', 'WMS_NOT_INSTALLED');
180: fnd_msg_pub.add;
181: RAISE fnd_api.g_exc_error;
182: END IF;
183: */

Line 186: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');

182: END IF;
183: */
184:
185: IF (p_org_id is null) THEN
186: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
187: fnd_msg_pub.add;
188: RAISE fnd_api.g_exc_error;
189: END IF;
190:

Line 454: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');

450:
451:
452:
453: IF (p_organization_id is null) THEN
454: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
455: fnd_msg_pub.add;
456: IF (l_debug = 1) THEN
457: print_debug('pre_generate: p_organization_ID is null');
458: END IF;

Line 486: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

482: FOR UPDATE nowait;
483:
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
487: fnd_msg_pub.add;
488:
489: IF (l_debug = 1) THEN
490: print_debug('pre_generate: p_lpn_id '||p_lpn_id||' does not exist. ' );

Line 496: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');

492:
493: RAISE fnd_api.g_exc_error;
494:
495: WHEN record_locked THEN
496: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
497: fnd_msg_pub.ADD;
498:
499: IF (l_debug = 1) THEN
500: print_debug('pre_generate: LPN not available. It is locked by someone else, either by different pre-generate process, or putaway load page');

Line 512: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');

508: print_debug('pre_generate: l_lpn_context = '||l_lpn_context);
509: END IF;
510:
511: IF l_lpn_context NOT IN (2, 3) THEN
512: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
513: fnd_msg_pub.add;
514:
515: IF (l_debug = 1) THEN
516: print_debug('pre_generate: l_lpn_context is not WIP or Receiving, do not pre-generate.' );

Line 541: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');

537:
538: END ;
539:
540: IF l_process_flag_count > 0 THEN
541: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
542: fnd_msg_pub.add;
543:
544: IF (l_debug = 1) THEN
545: print_debug('pre_generate: move order wms_process_flag indicates allocation is not yet allowed.');

Line 683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');

679: l_error := TRUE;
680: l_partial_success := 'Y';
681:
682: --Log Errored lpn_id and line_id with the error msg in msg file.
683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
684: fnd_message.set_token('lpn_no', l_lpn_no);
685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
687: fnd_message.set_token('line_id',to_char(l_mol_line_id));

Line 684: fnd_message.set_token('lpn_no', l_lpn_no);

680: l_partial_success := 'Y';
681:
682: --Log Errored lpn_id and line_id with the error msg in msg file.
683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
684: fnd_message.set_token('lpn_no', l_lpn_no);
685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
687: fnd_message.set_token('line_id',to_char(l_mol_line_id));
688: fnd_msg_pub.add;

Line 685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));

681:
682: --Log Errored lpn_id and line_id with the error msg in msg file.
683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
684: fnd_message.set_token('lpn_no', l_lpn_no);
685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
687: fnd_message.set_token('line_id',to_char(l_mol_line_id));
688: fnd_msg_pub.add;
689: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;

Line 686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));

682: --Log Errored lpn_id and line_id with the error msg in msg file.
683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
684: fnd_message.set_token('lpn_no', l_lpn_no);
685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
687: fnd_message.set_token('line_id',to_char(l_mol_line_id));
688: fnd_msg_pub.add;
689: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;
690: x_lpn_line_error_tbl(l_tbl_index).line_id := l_mol_line_id;

Line 687: fnd_message.set_token('line_id',to_char(l_mol_line_id));

683: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
684: fnd_message.set_token('lpn_no', l_lpn_no);
685: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
686: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
687: fnd_message.set_token('line_id',to_char(l_mol_line_id));
688: fnd_msg_pub.add;
689: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;
690: x_lpn_line_error_tbl(l_tbl_index).line_id := l_mol_line_id;
691: l_tbl_index := l_tbl_index+1;

Line 703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');

699: goto lpn_errored;
700: ELSE
701:
702: -- Log Success in msg file.
703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');
704: fnd_message.set_token('lpn_no', l_lpn_no);
705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
707: fnd_message.set_token('line_id',to_char(l_mol_line_id));

Line 704: fnd_message.set_token('lpn_no', l_lpn_no);

700: ELSE
701:
702: -- Log Success in msg file.
703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');
704: fnd_message.set_token('lpn_no', l_lpn_no);
705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
707: fnd_message.set_token('line_id',to_char(l_mol_line_id));
708: fnd_msg_pub.add;

Line 705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));

701:
702: -- Log Success in msg file.
703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');
704: fnd_message.set_token('lpn_no', l_lpn_no);
705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
707: fnd_message.set_token('line_id',to_char(l_mol_line_id));
708: fnd_msg_pub.add;
709:

Line 706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));

702: -- Log Success in msg file.
703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');
704: fnd_message.set_token('lpn_no', l_lpn_no);
705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
707: fnd_message.set_token('line_id',to_char(l_mol_line_id));
708: fnd_msg_pub.add;
709:
710: IF (l_from_conc_pgm = 'Y') THEN

Line 707: fnd_message.set_token('line_id',to_char(l_mol_line_id));

703: fnd_message.set_name('WMS', 'WMS_PUTAWAY_SUCCESS');
704: fnd_message.set_token('lpn_no', l_lpn_no);
705: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
706: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
707: fnd_message.set_token('line_id',to_char(l_mol_line_id));
708: fnd_msg_pub.add;
709:
710: IF (l_from_conc_pgm = 'Y') THEN
711: print_message();

Line 929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');

925:
926: --11685037
927: <>
928: --Log Errored lpn_id and line_id with the error msg in msg file.
929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
930: fnd_message.set_token('lpn_no', l_lpn_no);
931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
933: fnd_message.set_token('line_id',to_char(l_mol_line_id));

Line 930: fnd_message.set_token('lpn_no', l_lpn_no);

926: --11685037
927: <>
928: --Log Errored lpn_id and line_id with the error msg in msg file.
929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
930: fnd_message.set_token('lpn_no', l_lpn_no);
931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
933: fnd_message.set_token('line_id',to_char(l_mol_line_id));
934: fnd_msg_pub.add;

Line 931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));

927: <>
928: --Log Errored lpn_id and line_id with the error msg in msg file.
929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
930: fnd_message.set_token('lpn_no', l_lpn_no);
931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
933: fnd_message.set_token('line_id',to_char(l_mol_line_id));
934: fnd_msg_pub.add;
935: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;

Line 932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));

928: --Log Errored lpn_id and line_id with the error msg in msg file.
929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
930: fnd_message.set_token('lpn_no', l_lpn_no);
931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
933: fnd_message.set_token('line_id',to_char(l_mol_line_id));
934: fnd_msg_pub.add;
935: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;
936: x_lpn_line_error_tbl(l_tbl_index).line_id := l_mol_line_id;

Line 933: fnd_message.set_token('line_id',to_char(l_mol_line_id));

929: fnd_message.set_name('WMS', 'WMS_LPN_LINE_ERROR');
930: fnd_message.set_token('lpn_no', l_lpn_no);
931: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
932: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
933: fnd_message.set_token('line_id',to_char(l_mol_line_id));
934: fnd_msg_pub.add;
935: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;
936: x_lpn_line_error_tbl(l_tbl_index).line_id := l_mol_line_id;
937: l_tbl_index := l_tbl_index+1;

Line 1014: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_SUCCESS');

1010: -- End of fix for bug 7460112
1011:
1012:
1013:
1014: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_SUCCESS');
1015: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));
1016: fnd_msg_pub.add;
1017:
1018: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');

Line 1015: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));

1011:
1012:
1013:
1014: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_SUCCESS');
1015: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));
1016: fnd_msg_pub.add;
1017:
1018: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');
1019: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));

Line 1018: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');

1014: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_SUCCESS');
1015: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));
1016: fnd_msg_pub.add;
1017:
1018: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');
1019: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));
1020: fnd_msg_pub.add;
1021:
1022: --If all the lpns have failed then we raise ERROR.

Line 1019: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));

1015: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));
1016: fnd_msg_pub.add;
1017:
1018: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');
1019: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));
1020: fnd_msg_pub.add;
1021:
1022: --If all the lpns have failed then we raise ERROR.
1023: IF (l_cnt_success = 0) AND (l_cnt_failed > 0) THEN