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

173: );
174:
175: IF (NOT l_wms_install) THEN
176: fnd_message.set_name('WMS', 'WMS_NOT_INSTALLED');
177: fnd_msg_pub.add;
178: RAISE fnd_api.g_exc_error;
179: END IF;
180: */
181:

Line 184: fnd_msg_pub.add;

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

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

208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

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

216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
221:
222: END start_pregenerate_program;
223:
224:

Line 417: fnd_msg_pub.add;

413:
414:
415: IF (p_organization_id is null) THEN
416: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
417: fnd_msg_pub.add;
418: IF (l_debug = 1) THEN
419: print_debug('pre_generate: p_organization_ID is null');
420: END IF;
421:

Line 449: fnd_msg_pub.add;

445:
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
449: fnd_msg_pub.add;
450:
451: IF (l_debug = 1) THEN
452: print_debug('pre_generate: p_lpn_id '||p_lpn_id||' does not exist. ' );
453: END IF;

Line 459: fnd_msg_pub.ADD;

455: RAISE fnd_api.g_exc_error;
456:
457: WHEN record_locked THEN
458: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
459: fnd_msg_pub.ADD;
460:
461: IF (l_debug = 1) THEN
462: print_debug('pre_generate: LPN not available. It is locked by someone else, either by different pre-generate process, or putaway load page');
463: END IF;

Line 475: fnd_msg_pub.add;

471: END IF;
472:
473: IF l_lpn_context NOT IN (2, 3) THEN
474: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
475: fnd_msg_pub.add;
476:
477: IF (l_debug = 1) THEN
478: print_debug('pre_generate: l_lpn_context is not WIP or Receiving, do not pre-generate.' );
479: END IF;

Line 504: fnd_msg_pub.add;

500: END ;
501:
502: IF l_process_flag_count > 0 THEN
503: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
504: fnd_msg_pub.add;
505:
506: IF (l_debug = 1) THEN
507: print_debug('pre_generate: move order wms_process_flag indicates allocation is not yet allowed.');
508: END IF;

Line 649: fnd_msg_pub.add;

645: fnd_message.set_token('lpn_no', l_lpn_no);
646: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
647: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
648: fnd_message.set_token('line_id',to_char(l_mol_line_id));
649: fnd_msg_pub.add;
650: x_lpn_line_error_tbl(l_tbl_index).lpn_id := l_lpn_id;
651: x_lpn_line_error_tbl(l_tbl_index).line_id := l_mol_line_id;
652: l_tbl_index := l_tbl_index+1;
653:

Line 667: fnd_msg_pub.add;

663: fnd_message.set_token('lpn_no', l_lpn_no);
664: fnd_message.set_token('lpn_id', to_char(l_lpn_id));
665: --fnd_message.set_token('line_no',to_char(l_mol_line_no));
666: fnd_message.set_token('line_id',to_char(l_mol_line_id));
667: fnd_msg_pub.add;
668:
669: IF (l_from_conc_pgm = 'Y') THEN
670: print_message();
671: END IF;

Line 921: fnd_msg_pub.add;

917:
918:
919: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_SUCCESS');
920: fnd_message.set_token('CNT_SUCCESS', to_char(l_cnt_success));
921: fnd_msg_pub.add;
922:
923: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');
924: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));
925: fnd_msg_pub.add;

Line 925: fnd_msg_pub.add;

921: fnd_msg_pub.add;
922:
923: fnd_message.set_name('WMS', 'WMS_COUNT_LPN_FAILED');
924: fnd_message.set_token('CNT_FAILED', to_char(l_cnt_failed));
925: fnd_msg_pub.add;
926:
927: --If all the lpns have failed then we raise ERROR.
928: IF (l_cnt_success = 0) AND (l_cnt_failed > 0) THEN
929: RAISE fnd_api.g_exc_error;

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

991:
992: WHEN OTHERS THEN
993: x_return_status := fnd_api.g_ret_sts_unexp_error ;
994:
995: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');
997: END IF;
998:
999: IF (l_from_conc_pgm = 'Y') THEN

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

992: WHEN OTHERS THEN
993: x_return_status := fnd_api.g_ret_sts_unexp_error ;
994:
995: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');
997: END IF;
998:
999: IF (l_from_conc_pgm = 'Y') THEN
1000: print_message();

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

1218:
1219: EXCEPTION
1220: WHEN FND_API.G_EXC_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO sp_cleanup_suggs;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1223: ROLLBACK TO sp_cleanup_suggs;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1228: ROLLBACK TO sp_cleanup_suggs;
1229:
1230: WHEN OTHERS THEN
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1228: ROLLBACK TO sp_cleanup_suggs;
1229:
1230: WHEN OTHERS THEN
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1233: ROLLBACK TO sp_cleanup_suggs;
1234:
1235: END cleanup_suggestions;
1236:

Line 1266: fnd_msg_pub.count_and_get(

1262:
1263: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1264: BEGIN
1265:
1266: fnd_msg_pub.count_and_get(
1267: p_count => l_msg_count,
1268: p_data => l_msg_data,
1269: p_encoded => 'F'
1270: );

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

1269: p_encoded => 'F'
1270: );
1271:
1272: FOR i IN 1..l_msg_count LOOP
1273: l_msg_data := fnd_msg_pub.get(i, 'F');
1274: fnd_file.put_line(fnd_file.log, l_msg_data);
1275: END LOOP;
1276: fnd_file.put_line(fnd_file.log, ' ');
1277:

Line 1278: fnd_msg_pub.initialize;

1274: fnd_file.put_line(fnd_file.log, l_msg_data);
1275: END LOOP;
1276: fnd_file.put_line(fnd_file.log, ' ');
1277:
1278: fnd_msg_pub.initialize;
1279:
1280: EXCEPTION
1281: WHEN OTHERS THEN
1282: fnd_file.put_line(fnd_file.log, sqlerrm);