DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on FND_MSG_PUB

Line 3300: fnd_msg_pub.Initialize;

3296: l_row_count NUMBER;
3297: l_current_status NUMBER := 1;
3298:
3299: BEGIN
3300: fnd_msg_pub.Initialize;
3301: IF l_debug = 1 THEN
3302: trace('In Create TXN :');
3303: trace(' p_source='||p_source||', p_pack_process='||p_pack_process);
3304: trace(' p_organization_id='||p_organization_id);

Line 3395: fnd_msg_pub.add;

3391: l_txn_action_id := 51;
3392: l_txn_type_id := 88; -- Container Unpack
3393: ELSE
3394: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
3395: fnd_msg_pub.add;
3396: raise fnd_api.g_exc_error;
3397: END IF;
3398:
3399: IF l_debug = 1 THEN

Line 3589: fnd_msg_pub.add;

3585: , l_mol_lot_number
3586: , l_mol_inspection_status;
3587: IF inb_cur%NOTFOUND THEN
3588: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3589: fnd_msg_pub.add;
3590: raise fnd_api.g_exc_error;
3591: END IF;
3592:
3593: LOOP

Line 3657: fnd_msg_pub.add;

3653: END LOOP;
3654: IF l_available_qty < p_primary_qty THEN
3655: l_mol_list := l_null_mol_list;
3656: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3657: fnd_msg_pub.add;
3658: raise fnd_api.g_exc_error;
3659: END IF;
3660: IF l_debug = 1 THEN
3661: trace('Found move order lines to fulfill transactions, number of records:'||l_mol_list.count);

Line 4382: fnd_msg_pub.add;

4378: l_txn_action_id := 51;
4379: l_txn_type_id := 88;
4380: ELSE
4381: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
4382: fnd_msg_pub.add;
4383: raise fnd_api.g_exc_error;
4384: END IF;
4385: ELSE
4386: -- There is move happens

Line 4736: fnd_msg_pub.add;

4732: IF l_debug = 1 THEN
4733: trace('Error when updating wms_packing_material_gtemp for item, only one record should be updated');
4734: END IF;
4735: fnd_message.set_name('INV','INV_FAILED');
4736: fnd_msg_pub.add;
4737: raise fnd_api.g_exc_error;
4738: ELSE
4739: IF l_debug = 1 THEN
4740: trace('wms_packing_material_gtemp updated, row_count='||l_row_count);

Line 4749: fnd_msg_pub.add;

4745: IF l_debug = 1 THEN
4746: trace('Error when updating wms_packing_material_gtemp for item '||p_inventory_item_id);
4747: END IF;
4748: fnd_message.set_name('INV','INV_FAILED');
4749: fnd_msg_pub.add;
4750: raise fnd_api.g_exc_error;
4751: END;
4752: */
4753: --End Commented out Bug 6028098

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

4770: trace('ERROR Code ='||SQLCODE);
4771: trace('ERROR Message='||SQLERRM);
4772: END IF;
4773: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4774: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4775: IF (l_msg_count = 1) THEN
4776: x_proc_msg := x_proc_msg || l_msg_data;
4777: ELSIF (l_msg_count > 1) THEN
4778: FOR i IN 1 .. l_msg_count LOOP

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

4775: IF (l_msg_count = 1) THEN
4776: x_proc_msg := x_proc_msg || l_msg_data;
4777: ELSIF (l_msg_count > 1) THEN
4778: FOR i IN 1 .. l_msg_count LOOP
4779: l_msg_data := fnd_msg_pub.get(i, 'F');
4780: x_proc_msg := x_proc_msg || l_msg_data;
4781: END LOOP;
4782: END IF;
4783: END create_txn;

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

5018:
5019: EXCEPTION
5020: WHEN others THEN
5021: x_return_status := fnd_api.G_RET_STS_ERROR;
5022: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5023: IF l_debug = 1 THEN
5024: trace('Error in delete_txn(), progress='||l_progress);
5025: trace('ERROR Code ='||SQLCODE);
5026: trace('ERROR Message='||SQLERRM);

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

5095:
5096: EXCEPTION
5097: WHEN others THEN
5098: x_return_status := fnd_api.G_RET_STS_ERROR;
5099: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
5100: IF (l_msg_count = 1) THEN
5101: x_proc_msg := l_msg_data;
5102: ELSIF (l_msg_count > 1) THEN
5103: FOR i IN 1 .. l_msg_count LOOP

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

5100: IF (l_msg_count = 1) THEN
5101: x_proc_msg := l_msg_data;
5102: ELSIF (l_msg_count > 1) THEN
5103: FOR i IN 1 .. l_msg_count LOOP
5104: l_msg_data := fnd_msg_pub.get(i, 'F');
5105: x_proc_msg := x_proc_msg || l_msg_data;
5106: END LOOP;
5107: END IF;
5108: IF l_debug = 1 THEN

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

5154: trace('l_msg_data='||l_msg_data);
5155: END IF;
5156: x_return_status := l_return_status;
5157: IF l_return_status <> 'S' THEN
5158: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
5159: IF (l_msg_count = 1) THEN
5160: x_proc_msg := l_msg_data;
5161: ELSIF (l_msg_count > 1) THEN
5162: FOR i IN 1 .. l_msg_count LOOP

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

5159: IF (l_msg_count = 1) THEN
5160: x_proc_msg := l_msg_data;
5161: ELSIF (l_msg_count > 1) THEN
5162: FOR i IN 1 .. l_msg_count LOOP
5163: l_msg_data := fnd_msg_pub.get(i, 'F');
5164: x_proc_msg := x_proc_msg || l_msg_data;
5165: END LOOP;
5166: END IF;
5167: IF l_debug = 1 THEN