DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on FND_MSG_PUB

Line 3134: fnd_msg_pub.Initialize;

3130: l_row_count NUMBER;
3131: l_current_status NUMBER := 1;
3132:
3133: BEGIN
3134: fnd_msg_pub.Initialize;
3135: IF l_debug = 1 THEN
3136: trace('In Create TXN :');
3137: trace(' p_source='||p_source||', p_pack_process='||p_pack_process);
3138: trace(' p_organization_id='||p_organization_id);

Line 3229: fnd_msg_pub.add;

3225: l_txn_action_id := 51;
3226: l_txn_type_id := 88; -- Container Unpack
3227: ELSE
3228: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
3229: fnd_msg_pub.add;
3230: raise fnd_api.g_exc_error;
3231: END IF;
3232:
3233: IF l_debug = 1 THEN

Line 3423: fnd_msg_pub.add;

3419: , l_mol_lot_number
3420: , l_mol_inspection_status;
3421: IF inb_cur%NOTFOUND THEN
3422: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3423: fnd_msg_pub.add;
3424: raise fnd_api.g_exc_error;
3425: END IF;
3426:
3427: LOOP

Line 3491: fnd_msg_pub.add;

3487: END LOOP;
3488: IF l_available_qty < p_primary_qty THEN
3489: l_mol_list := l_null_mol_list;
3490: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3491: fnd_msg_pub.add;
3492: raise fnd_api.g_exc_error;
3493: END IF;
3494: IF l_debug = 1 THEN
3495: trace('Found move order lines to fulfill transactions, number of records:'||l_mol_list.count);

Line 4216: fnd_msg_pub.add;

4212: l_txn_action_id := 51;
4213: l_txn_type_id := 88;
4214: ELSE
4215: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
4216: fnd_msg_pub.add;
4217: raise fnd_api.g_exc_error;
4218: END IF;
4219: ELSE
4220: -- There is move happens

Line 4570: fnd_msg_pub.add;

4566: IF l_debug = 1 THEN
4567: trace('Error when updating wms_packing_material_gtemp for item, only one record should be updated');
4568: END IF;
4569: fnd_message.set_name('INV','INV_FAILED');
4570: fnd_msg_pub.add;
4571: raise fnd_api.g_exc_error;
4572: ELSE
4573: IF l_debug = 1 THEN
4574: trace('wms_packing_material_gtemp updated, row_count='||l_row_count);

Line 4583: fnd_msg_pub.add;

4579: IF l_debug = 1 THEN
4580: trace('Error when updating wms_packing_material_gtemp for item '||p_inventory_item_id);
4581: END IF;
4582: fnd_message.set_name('INV','INV_FAILED');
4583: fnd_msg_pub.add;
4584: raise fnd_api.g_exc_error;
4585: END;
4586: */
4587: --End Commented out Bug 6028098

Line 4608: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');

4604: trace('ERROR Code ='||SQLCODE);
4605: trace('ERROR Message='||SQLERRM);
4606: END IF;
4607: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4608: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4609: IF (l_msg_count = 1) THEN
4610: x_proc_msg := x_proc_msg || l_msg_data;
4611: ELSIF (l_msg_count > 1) THEN
4612: FOR i IN 1 .. l_msg_count LOOP

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

4609: IF (l_msg_count = 1) THEN
4610: x_proc_msg := x_proc_msg || l_msg_data;
4611: ELSIF (l_msg_count > 1) THEN
4612: FOR i IN 1 .. l_msg_count LOOP
4613: l_msg_data := fnd_msg_pub.get(i, 'F');
4614: x_proc_msg := x_proc_msg || l_msg_data;
4615: END LOOP;
4616: END IF;
4617: END create_txn;

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

4852:
4853: EXCEPTION
4854: WHEN others THEN
4855: x_return_status := fnd_api.G_RET_STS_ERROR;
4856: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4857: IF l_debug = 1 THEN
4858: trace('Error in delete_txn(), progress='||l_progress);
4859: trace('ERROR Code ='||SQLCODE);
4860: trace('ERROR Message='||SQLERRM);

Line 4933: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');

4929:
4930: EXCEPTION
4931: WHEN others THEN
4932: x_return_status := fnd_api.G_RET_STS_ERROR;
4933: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4934: IF (l_msg_count = 1) THEN
4935: x_proc_msg := l_msg_data;
4936: ELSIF (l_msg_count > 1) THEN
4937: FOR i IN 1 .. l_msg_count LOOP

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

4934: IF (l_msg_count = 1) THEN
4935: x_proc_msg := l_msg_data;
4936: ELSIF (l_msg_count > 1) THEN
4937: FOR i IN 1 .. l_msg_count LOOP
4938: l_msg_data := fnd_msg_pub.get(i, 'F');
4939: x_proc_msg := x_proc_msg || l_msg_data;
4940: END LOOP;
4941: END IF;
4942: IF l_debug = 1 THEN

Line 4992: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');

4988: trace('l_msg_data='||l_msg_data);
4989: END IF;
4990: x_return_status := l_return_status;
4991: IF l_return_status <> 'S' THEN
4992: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4993: IF (l_msg_count = 1) THEN
4994: x_proc_msg := l_msg_data;
4995: ELSIF (l_msg_count > 1) THEN
4996: FOR i IN 1 .. l_msg_count LOOP

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

4993: IF (l_msg_count = 1) THEN
4994: x_proc_msg := l_msg_data;
4995: ELSIF (l_msg_count > 1) THEN
4996: FOR i IN 1 .. l_msg_count LOOP
4997: l_msg_data := fnd_msg_pub.get(i, 'F');
4998: x_proc_msg := x_proc_msg || l_msg_data;
4999: END LOOP;
5000: END IF;
5001: IF l_debug = 1 THEN