DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on FND_MESSAGE

Line 233: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

229: FROM mtl_parameters
230: WHERE organization_id = l_trolin_tbl(1).organization_id;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
234: fnd_msg_pub.ADD;
235: RAISE fnd_api.g_exc_unexpected_error;
236: END;
237:

Line 253: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

249: END IF;
250:
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
254: fnd_msg_pub.ADD;
255: RAISE fnd_api.g_exc_unexpected_error;
256: END;
257: END IF;

Line 329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');

325: END IF;
326:
327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;

Line 330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);

326:
327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;

Line 331: fnd_message.set_token('MO_NUMBER', l_request_number);

327: --No rows allocated
328: IF (l_detail_rec_count <= 0 AND l_auto_pick_flag = 'Y') THEN
329: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
330: fnd_message.set_token('LINE_NUM', l_trolin_tbl(1).line_number);
331: fnd_message.set_token('MO_NUMBER', l_request_number);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:

Line 357: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');

353: l_mold_tbl_temp := l_mold_tbl;
354:
355: IF (l_mold_tbl.COUNT = 0) THEN
356: l_return_status := fnd_api.g_ret_sts_unexp_error;
357: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
358: fnd_msg_pub.ADD;
359: RAISE fnd_api.g_exc_unexpected_error;
360: ELSE
361: IF (l_debug = 1) THEN

Line 555: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

551: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
552: IF (l_debug = 1) THEN
553: print_debug('failed to print labels');
554: END IF;
555: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
556: fnd_msg_pub.ADD;
557: END IF;
558: END IF;
559: EXCEPTION

Line 564: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

560: WHEN OTHERS THEN
561: IF (l_debug = 1) THEN
562: print_debug('Exception occured while calling print_label');
563: END IF;
564: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
565: fnd_msg_pub.ADD;
566: END;
567: END IF;
568: --End Bug 6696594

Line 802: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');

798: FROM mtl_material_transactions_temp
799: WHERE transaction_temp_id = p_transaction_temp_id;
800:
801: IF (l_transaction_action_id = 1) THEN
802: --fnd_message.debug('copying project_id and task_id from tolines_blk to mtl_Trx_line');
803:
804: SELECT project_id
805: , task_id
806: INTO l_project_id

Line 1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');

1292: END IF;
1293: EXCEPTION
1294: WHEN fnd_api.g_exc_error THEN
1295: x_return_status := fnd_api.g_ret_sts_error;
1296: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');

1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1299: WHEN fnd_api.g_exc_unexpected_error THEN
1300: x_return_status := fnd_api.g_ret_sts_unexp_error;
1301: fnd_message.set_name('INV', 'SPLIT_LINE_DETAIL_ERROR');
1302: fnd_msg_pub.ADD;
1303: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1304: WHEN OTHERS THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');

1359: x_return_status := l_return_status;
1360: EXCEPTION
1361: WHEN fnd_api.g_exc_error THEN
1362: x_return_status := fnd_api.g_ret_sts_error;
1363: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');

1364: fnd_msg_pub.ADD;
1365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1366: WHEN fnd_api.g_exc_unexpected_error THEN
1367: x_return_status := fnd_api.g_ret_sts_unexp_error;
1368: fnd_message.set_name('INV', 'AUTO_PICK_CONFIRM_ERROR');
1369: fnd_msg_pub.ADD;
1370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1371: WHEN OTHERS THEN
1372: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1846: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');

1842: NULL;
1843: END LOOP;
1844: EXCEPTION
1845: WHEN record_locked THEN
1846: fnd_message.set_name('INV', 'INV_MO_LOCKED_SO');
1847: fnd_msg_pub.ADD;
1848: RAISE fnd_api.g_exc_error;
1849: END;
1850:

Line 2418: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

2414: print_debug('OVPK: pickedQty is not within overship tolerance level');
2415: print_debug('OVPK: Erroring out');
2416: END IF;
2417:
2418: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2419: x_ovpk_error_code := 3;
2420: fnd_msg_pub.ADD;
2421: RAISE fnd_api.g_exc_error;
2422: ELSE

Line 2451: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

2447: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
2448: print_debug('OVPK: Erroring out');
2449: END IF;
2450:
2451: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2452: x_ovpk_error_code := 2;
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;*/
2455: --END IF;

Line 2463: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

2459: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
2460: print_debug('OVPK: Erroring out');
2461: END IF;
2462:
2463: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2464: x_ovpk_error_code := 1;
2465: fnd_msg_pub.ADD;
2466: RAISE fnd_api.g_exc_error;
2467: END IF;

Line 2719: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

2715: print_debug('OVPK: pickedQty is not within overship tolerance level');
2716: print_debug('OVPK: Erroring out');
2717: END IF;
2718:
2719: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
2720: x_ovpk_error_code := 3;
2721: fnd_msg_pub.ADD;
2722: RAISE fnd_api.g_exc_error;
2723: ELSE

Line 2752: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

2748: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
2749: print_debug('OVPK: Erroring out');
2750: END IF;
2751:
2752: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
2753: x_ovpk_error_code := 2;
2754: fnd_msg_pub.ADD;
2755: RAISE fnd_api.g_exc_error;
2756: END IF;

Line 2764: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

2760: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
2761: print_debug('OVPK: Erroring out');
2762: END IF;
2763:
2764: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
2765: x_ovpk_error_code := 1;
2766: fnd_msg_pub.ADD;
2767: RAISE fnd_api.g_exc_error;
2768: END IF;

Line 3261: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');

3257: print_debug('OVPK: pickedQty is not within overship tolerance level');
3258: print_debug('OVPK: Erroring out');
3259: END IF;
3260:
3261: fnd_message.set_name('INV', 'INV_OVERSHIP_TOLERANCE');
3262: x_ovpk_error_code := 3;
3263: fnd_msg_pub.ADD;
3264: RAISE fnd_api.g_exc_error;
3265: ELSE

Line 3294: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');

3290: print_debug('OVPK: Not enough material to pick in Sub/Loc/Lot/LPN');
3291: print_debug('OVPK: Erroring out');
3292: END IF;
3293:
3294: fnd_message.set_name('INV', 'INV_LACK_MTRL_TO_OVERPICK');
3295: x_ovpk_error_code := 2;
3296: fnd_msg_pub.ADD;
3297: RAISE fnd_api.g_exc_error;
3298: END IF;*/

Line 3306: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');

3302: print_debug('OVPK: Overpicking is not allowed in this org and for this Move Order type');
3303: print_debug('OVPK: Erroring out');
3304: END IF;
3305:
3306: fnd_message.set_name('INV', 'INV_OVERPICK_NOT_ALLOWED');
3307: x_ovpk_error_code := 1;
3308: fnd_msg_pub.ADD;
3309: RAISE fnd_api.g_exc_error;
3310: END IF;