DBA Data[Home] [Help]

APPS.INV_MATERIAL_ALLOCATIONS_GRP dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.add;

54: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
55: 'Transaction Temp Id '|| p_transaction_temp_id || ' not found');
56: end if;
57: fnd_message.set_name('INV', 'INV_ALLOCATION_NOT_FOUND');
58: fnd_msg_pub.add;
59: return false;
60: WHEN OTHERS THEN
61: if (l_slog) then
62: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 138: FND_MSG_PUB.initialize;

134: l_dummy_n number;
135: BEGIN
136: SAVEPOINT DELETE_ALLOCATION;
137: IF FND_API.to_Boolean( p_init_msg_list ) THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141: x_msg_count := 0;
142:

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

150: --Later on can reduce dependance on this by optional parameters which give this
151: --information(saves a db hit). If these are not provided, then we cn query up MMTT
152: if (not get_mmtt_info(p_transaction_temp_id,l_primary_mmtt_qty,
153: l_tx_qty, l_move_order_line_id, l_dummy_v, l_dummy_v, l_dummy_n)) then
154: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
155: x_return_status := fnd_api.g_ret_sts_error;
156: return;
157: end if;
158: --Reduce the allocation quantities in Move order headers, lines and in WRO

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

183: IF FND_API.To_Boolean( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
188: if (l_plog) then
189: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
190: end if;
191:

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

191:
192: EXCEPTION
193: WHEN fnd_api.g_exc_error THEN
194: x_return_status := fnd_api.g_ret_sts_error;
195: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
196: ROLLBACK to delete_allocation;
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: FND_MSG_PUB.Count_And_Get(

Line 199: FND_MSG_PUB.Count_And_Get(

195: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
196: ROLLBACK to delete_allocation;
197: WHEN OTHERS THEN
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: FND_MSG_PUB.Count_And_Get(
200: p_count => x_msg_count,
201: p_data => x_msg_data);
202: ROLLBACK to delete_allocation;
203: end delete_allocation;

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

252: --get primary qty and other information from MMTT
253: if (not get_mmtt_info(p_transaction_temp_id,l_primary_mmtt_qty,
254: l_tx_qty, l_move_order_line_id, l_item_primary_uom_code, l_transaction_uom,
255: l_inventory_item_id)) then
256: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
257: return;
258: end if;
259: --Qty can be entered as either reduction amount (delta) or final reduced amount
260: --Assume that the quantity specified is in terms of primary UOM

Line 279: fnd_msg_pub.add;

275: if (l_elog) then
276: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Cannot reduce qty to below 0');
277: end if;
278: fnd_message.set_name('INV', 'INV_NON_POSITIVE_ISSUE_QTY');
279: fnd_msg_pub.add;
280: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
281: return;
282: --Following elsif (3 lines): not sure whether we should allow delete here
283: --also or only in delete_allocation

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

276: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Cannot reduce qty to below 0');
277: end if;
278: fnd_message.set_name('INV', 'INV_NON_POSITIVE_ISSUE_QTY');
279: fnd_msg_pub.add;
280: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
281: return;
282: --Following elsif (3 lines): not sure whether we should allow delete here
283: --also or only in delete_allocation
284: --elsif (l_final_qty = 0) then

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

337: IF FND_API.To_Boolean( p_commit ) THEN
338: COMMIT WORK;
339: END IF;
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
342: if (l_plog) then
343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
344: end if;
345:

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

345:
346: EXCEPTION
347: WHEN fnd_api.g_exc_error THEN
348: x_return_status := fnd_api.g_ret_sts_error;
349: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
350: ROLLBACK to reduce_allocation_header;
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: FND_MSG_PUB.Count_And_Get(

Line 353: FND_MSG_PUB.Count_And_Get(

349: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
350: ROLLBACK to reduce_allocation_header;
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
353: FND_MSG_PUB.Count_And_Get(
354: p_count => x_msg_count,
355: p_data => x_msg_data);
356: ROLLBACK to reduce_allocation_header;
357: end reduce_allocation_header;

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

426: IF FND_API.To_Boolean( p_commit ) THEN
427: COMMIT WORK;
428: END IF;
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
431: if (l_plog) then
432: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
433: end if;
434:

Line 438: FND_MSG_PUB.Count_And_Get(

434:
435: EXCEPTION
436: WHEN OTHERS THEN
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: FND_MSG_PUB.Count_And_Get(
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441: ROLLBACK to remove_serial;
442: end remove_serial;

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

506: COMMIT WORK;
507: END IF;
508: if (l_insert_err_code = 0) then -- 0 = success
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
511: else
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: end if;
514: if (l_plog) then

Line 521: FND_MSG_PUB.Count_And_Get(

517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: FND_MSG_PUB.Count_And_Get(
522: p_count => x_msg_count,
523: p_data => x_msg_data);
524: ROLLBACK to add_serial;
525: end add_serial;

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

637: IF FND_API.To_Boolean( p_commit ) THEN
638: COMMIT WORK;
639: END IF;
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
642: if (l_plog) then
643: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
644: end if;
645:

Line 649: FND_MSG_PUB.Count_And_Get(

645:
646: EXCEPTION
647: WHEN OTHERS THEN
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
649: FND_MSG_PUB.Count_And_Get(
650: p_count => x_msg_count,
651: p_data => x_msg_data);
652: ROLLBACK to reduce_lot;
653: end update_lot;

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

706:
707: IF FND_API.To_Boolean( p_commit ) THEN
708: COMMIT WORK;
709: END IF;
710: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
711: if (l_plog) then
712: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End of ' || l_module);
713: end if;
714:

Line 718: FND_MSG_PUB.Count_And_Get(

714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
718: FND_MSG_PUB.Count_And_Get(
719: p_count => x_msg_count,
720: p_data => x_msg_data);
721: ROLLBACK to mark_lot_with_ser_temp_id;
722: end mark_lot_with_ser_temp_id;