DBA Data[Home] [Help]

APPS.EAM_MATERIAL_ALLOCATIONS_PVT dependencies on FND_MSG_PUB

Line 47: fnd_msg_pub.add;

43: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
44: 'Transaction Temp Id '|| p_transaction_temp_id || ' not found');
45: end if;
46: fnd_message.set_name('EAM', 'EAM_ALLOCATION_NOT_FOUND');
47: fnd_msg_pub.add;
48: return false;
49: WHEN OTHERS THEN
50: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
51: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 116: FND_MSG_PUB.initialize;

112: l_move_order_line_id number;
113: BEGIN
114: SAVEPOINT DELETE_ALLOCATION;
115: IF FND_API.to_Boolean( p_init_msg_list ) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119: x_msg_count := 0;
120:

Line 132: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

128: --Later on can reduce dependance on this by optional parameters which give this
129: --information(saves a db hit). If these are not provided, then we cn query up MMTT
130: if (not get_mmtt_info(p_transaction_temp_id,l_primary_mmtt_qty,
131: l_tx_qty, l_move_order_line_id)) then
132: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
133: return;
134: end if;
135: --Reduce the allocation quantities in Move order headers, lines and in WRO
136: reduce_move_order(l_move_order_line_id, l_primary_mmtt_qty, 'Y');

Line 162: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

158: IF FND_API.To_Boolean( p_commit ) THEN
159: COMMIT WORK;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
163: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
165: end if;
166:

Line 170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_error THEN
169: x_return_status := fnd_api.g_ret_sts_error;
170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
171: ROLLBACK to delete_allocation;
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(

Line 174: FND_MSG_PUB.Count_And_Get(

170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
171: ROLLBACK to delete_allocation;
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177: ROLLBACK to delete_allocation;
178: end delete_allocation;

Line 224: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

220: --API start
221: --get primary qty and other information from MMTT
222: if (not get_mmtt_info(p_transaction_temp_id,l_primary_mmtt_qty,
223: l_tx_qty, l_move_order_line_id)) then
224: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
225: return;
226: end if;
227: --Qty can be entered as either reduction amount (delta) or final reduced amount
228: --Assume that the quantity specified is in terms of primary UOM

Line 247: fnd_msg_pub.add;

243: if (l_log and (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
244: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Cannot reduce qty to below 0');
245: end if;
246: fnd_message.set_name('EAM', 'EAM_NON_POSITIVE_ISSUE_QTY');
247: fnd_msg_pub.add;
248: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
249: return;
250: --Following elsif (3 lines): not sure whether we should allow delete here
251: --also or only in delete_allocation

Line 248: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

244: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Cannot reduce qty to below 0');
245: end if;
246: fnd_message.set_name('EAM', 'EAM_NON_POSITIVE_ISSUE_QTY');
247: fnd_msg_pub.add;
248: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
249: return;
250: --Following elsif (3 lines): not sure whether we should allow delete here
251: --also or only in delete_allocation
252: --elsif (l_final_qty = 0) then

Line 299: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

295: IF FND_API.To_Boolean( p_commit ) THEN
296: COMMIT WORK;
297: END IF;
298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
300: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
301: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
302: end if;
303:

Line 307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

303:
304: EXCEPTION
305: WHEN fnd_api.g_exc_error THEN
306: x_return_status := fnd_api.g_ret_sts_error;
307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
308: ROLLBACK to reduce_allocation_header;
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get(

Line 311: FND_MSG_PUB.Count_And_Get(

307: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
308: ROLLBACK to reduce_allocation_header;
309: WHEN OTHERS THEN
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get(
312: p_count => x_msg_count,
313: p_data => x_msg_data);
314: ROLLBACK to reduce_allocation_header;
315: end reduce_allocation_header;

Line 385: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

381: IF FND_API.To_Boolean( p_commit ) THEN
382: COMMIT WORK;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
386: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
387: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
388: end if;
389:

Line 393: FND_MSG_PUB.Count_And_Get(

389:
390: EXCEPTION
391: WHEN OTHERS THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396: ROLLBACK to remove_serial;
397: end remove_serial;

Line 462: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
463: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
464: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
465: end if;
466:

Line 470: FND_MSG_PUB.Count_And_Get(

466:
467: EXCEPTION
468: WHEN OTHERS THEN
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
470: FND_MSG_PUB.Count_And_Get(
471: p_count => x_msg_count,
472: p_data => x_msg_data);
473: ROLLBACK to add_serial;
474: end add_serial;

Line 588: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

584: IF FND_API.To_Boolean( p_commit ) THEN
585: COMMIT WORK;
586: END IF;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
589: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
591: end if;
592:

Line 596: FND_MSG_PUB.Count_And_Get(

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
596: FND_MSG_PUB.Count_And_Get(
597: p_count => x_msg_count,
598: p_data => x_msg_data);
599: ROLLBACK to reduce_lot;
600: end update_lot;

Line 655: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);

651:
652: IF FND_API.To_Boolean( p_commit ) THEN
653: COMMIT WORK;
654: END IF;
655: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
656: if (l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
658: end if;
659:

Line 663: FND_MSG_PUB.Count_And_Get(

659:
660: EXCEPTION
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666: ROLLBACK to mark_lot_with_ser_temp_id;
667: end mark_lot_with_ser_temp_id;