DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on FND_MSG_PUB

Line 103: fnd_msg_pub.add;

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);
107: x_retcode := RETCODE_WARNING;

Line 105: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

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);
107: x_retcode := RETCODE_WARNING;
108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
109: ELSE

Line 108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

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);
107: x_retcode := RETCODE_WARNING;
108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
109: ELSE
110: print_message();
111: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
112: x_retcode := RETCODE_SUCCESS;

Line 124: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

120:
121: print_message();
122: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
123: x_retcode := RETCODE_ERROR;
124: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
125:
126: WHEN fnd_api.g_exc_unexpected_error THEN
127:
128: print_message();

Line 131: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

127:
128: print_message();
129: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
130: x_retcode := RETCODE_ERROR;
131: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
132:
133: WHEN OTHERS THEN
134:
135: print_message();

Line 138: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

134:
135: print_message();
136: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
137: x_retcode := RETCODE_ERROR;
138: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
139:
140: END conc_pre_generate;
141:
142:

Line 180: fnd_msg_pub.add;

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: */
184:

Line 187: fnd_msg_pub.add;

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:
191: --Added for Bug 13789232

Line 248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
249:
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 252: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

Line 256: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

252: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
253:
254: WHEN OTHERS THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
257:
258: END start_pregenerate_program;
259:
260:

Line 455: fnd_msg_pub.add;

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;
459:

Line 487: fnd_msg_pub.add;

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. ' );
491: END IF;

Line 497: fnd_msg_pub.ADD;

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');
501: END IF;

Line 513: fnd_msg_pub.add;

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.' );
517: END IF;

Line 542: fnd_msg_pub.add;

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.');
546: END IF;

Line 688: fnd_msg_pub.add;

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;
692:

Line 708: fnd_msg_pub.add;

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();
712: END IF;

Line 934: fnd_msg_pub.add;

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;
938:

Line 1016: fnd_msg_pub.add;

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));
1020: fnd_msg_pub.add;

Line 1020: fnd_msg_pub.add;

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
1024: RAISE fnd_api.g_exc_error;

Line 1090: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN

1086:
1087: WHEN OTHERS THEN
1088: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1089:
1090: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1091: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');
1092: END IF;
1093:
1094: IF (l_from_conc_pgm = 'Y') THEN

Line 1091: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');

1087: WHEN OTHERS THEN
1088: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1089:
1090: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1091: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');
1092: END IF;
1093:
1094: IF (l_from_conc_pgm = 'Y') THEN
1095: print_message();

Line 1317: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1313:
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: x_return_status := FND_API.G_RET_STS_ERROR;
1317: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1318: ROLLBACK TO sp_cleanup_suggs;
1319:
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1318: ROLLBACK TO sp_cleanup_suggs;
1319:
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1322: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1323: ROLLBACK TO sp_cleanup_suggs;
1324:
1325: WHEN OTHERS THEN
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1323: ROLLBACK TO sp_cleanup_suggs;
1324:
1325: WHEN OTHERS THEN
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1328: ROLLBACK TO sp_cleanup_suggs;
1329:
1330: END cleanup_suggestions;
1331:

Line 1361: fnd_msg_pub.count_and_get(

1357:
1358: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1359: BEGIN
1360:
1361: fnd_msg_pub.count_and_get(
1362: p_count => l_msg_count,
1363: p_data => l_msg_data,
1364: p_encoded => 'F'
1365: );

Line 1368: l_msg_data := fnd_msg_pub.get(i, 'F');

1364: p_encoded => 'F'
1365: );
1366:
1367: FOR i IN 1..l_msg_count LOOP
1368: l_msg_data := fnd_msg_pub.get(i, 'F');
1369: fnd_file.put_line(fnd_file.log, l_msg_data);
1370: END LOOP;
1371: fnd_file.put_line(fnd_file.log, ' ');
1372:

Line 1373: fnd_msg_pub.initialize;

1369: fnd_file.put_line(fnd_file.log, l_msg_data);
1370: END LOOP;
1371: fnd_file.put_line(fnd_file.log, ' ');
1372:
1373: fnd_msg_pub.initialize;
1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: fnd_file.put_line(fnd_file.log, sqlerrm);