DBA Data[Home] [Help]

APPS.INV_3PL_SEEDED_SOURCES dependencies on FND_MESSAGE

Line 110: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');

106: debug('rt_counter in loop => '||rt_counter);
107: END LOOP;
108:
109: IF l_in_loop = 0 THEN
110: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');
111: x_return_status := fnd_api.g_ret_sts_error;
112: x_counter_value := 0;
113: RAISE fnd_api.g_exc_unexpected_error;
114:

Line 196: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');

192: -- debug('rt_counter in loop => '||mmt_counter);
193: END LOOP;
194:
195: IF l_in_loop = 0 THEN
196: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');
197: x_return_status := fnd_api.g_ret_sts_error;
198: RAISE fnd_api.g_exc_unexpected_error;
199: x_counter_value := 0;
200: END IF;

Line 282: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');

278: -- debug('rt_counter in loop => '||mmt_counter);
279: END LOOP;
280:
281: IF l_in_loop = 0 THEN
282: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');
283: x_return_status := fnd_api.g_ret_sts_error;
284: RAISE fnd_api.g_exc_unexpected_error;
285: x_counter_value := 0;
286:

Line 399: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

395:
396: debug('Conversion rate between the UOMs '|| l_conversion);
397: IF(l_conversion <= -999)
398: THEN
399: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
400: fnd_message.set_token('VALUE1', items.from_uom_code);
401: fnd_message.set_token('VALUE2', l_billing_uom);
402: debug('No conversion rate defined between the two UOM'|| l_conversion);
403: x_return_status := fnd_api.g_ret_sts_error;

Line 400: fnd_message.set_token('VALUE1', items.from_uom_code);

396: debug('Conversion rate between the UOMs '|| l_conversion);
397: IF(l_conversion <= -999)
398: THEN
399: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
400: fnd_message.set_token('VALUE1', items.from_uom_code);
401: fnd_message.set_token('VALUE2', l_billing_uom);
402: debug('No conversion rate defined between the two UOM'|| l_conversion);
403: x_return_status := fnd_api.g_ret_sts_error;
404: x_counter_value := 0;

Line 401: fnd_message.set_token('VALUE2', l_billing_uom);

397: IF(l_conversion <= -999)
398: THEN
399: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
400: fnd_message.set_token('VALUE1', items.from_uom_code);
401: fnd_message.set_token('VALUE2', l_billing_uom);
402: debug('No conversion rate defined between the two UOM'|| l_conversion);
403: x_return_status := fnd_api.g_ret_sts_error;
404: x_counter_value := 0;
405: RAISE fnd_api.G_EXC_ERROR;

Line 421: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');

417: x_counter_value := rt_counter;
418: debug('final x_counter_value => '|| rt_counter);
419:
420: IF l_in_loop = 0 THEN
421: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');
422: x_return_status := fnd_api.g_ret_sts_error;
423: RAISE fnd_api.g_exc_unexpected_error;
424: x_counter_value := 0;
425:

Line 508: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');

504: END LOOP;
505:
506:
507: IF l_in_loop = 0 THEN
508: FND_MESSAGE.SET_NAME('INV','INV_NO_CLIENT_ITM_OU');
509: x_return_status := fnd_api.g_ret_sts_error;
510: RAISE fnd_api.g_exc_unexpected_error;
511: x_counter_value := 0;
512:

Line 644: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');

640: WHEN OTHERS THEN
641: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
642: IF SQLCODE = -54 THEN
643: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
644: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
645: x_return_status := fnd_api.g_ret_sts_error;
646: x_counter_value := 0;
647: ELSE
648: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 761: FND_MESSAGE.SET_NAME('INV','INV_LOC_VOL_NOT_DEF');

757: debug(' Client_code => '||locator_occupancy_rec.client_code );
758: debug(' Locator_id => '||locator_occupancy_rec.locator_id );
759: rollback to process_locator;
760:
761: FND_MESSAGE.SET_NAME('INV','INV_LOC_VOL_NOT_DEF');
762: RAISE fnd_api.G_EXC_ERROR;
763: x_return_status := fnd_api.g_ret_sts_error;
764: x_counter_value := 0;
765: RETURN;

Line 836: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');

832: WHEN OTHERS THEN
833: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
834: IF SQLCODE = -54 THEN
835: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
836: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
837: x_return_status := fnd_api.g_ret_sts_error;
838: x_counter_value := 0;
839: ELSE
840: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 938: FND_MESSAGE.SET_NAME('INV','INV_LOC_AREA_NOT_DEF');

934: debug(' Client_code => '||locator_occupancy_rec.client_code );
935: debug(' Locator_id => '||locator_occupancy_rec.locator_id );
936: rollback to process_locator;
937:
938: FND_MESSAGE.SET_NAME('INV','INV_LOC_AREA_NOT_DEF');
939: RAISE fnd_api.G_EXC_ERROR;
940: x_return_status := fnd_api.g_ret_sts_error;
941: x_counter_value := 0;
942: RETURN;

Line 1014: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');

1010: WHEN OTHERS THEN
1011: debug(' : Error While resetting Number of days in mtl_3pl_locator_occupancy ' ||sqlerrm);
1012: IF SQLCODE = -54 THEN
1013: debug(' : Could not lock the record in mtl_3pl_locator_occupancy ');
1014: FND_MESSAGE.SET_NAME('INV','INV_TRX_ROW_LOCKED');
1015: x_return_status := fnd_api.g_ret_sts_error;
1016: x_counter_value := 0;
1017: ELSE
1018: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1085: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

1081: debug('Conversion rate between the UOMs '|| l_conversion);
1082:
1083: IF(l_conversion <= -999)
1084: THEN
1085: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1086: fnd_message.set_token('VALUE1', x_volume_uom_code);
1087: fnd_message.set_token('VALUE2', p_billing_uom);
1088: RETURN(-9999);
1089: ELSE

Line 1086: fnd_message.set_token('VALUE1', x_volume_uom_code);

1082:
1083: IF(l_conversion <= -999)
1084: THEN
1085: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1086: fnd_message.set_token('VALUE1', x_volume_uom_code);
1087: fnd_message.set_token('VALUE2', p_billing_uom);
1088: RETURN(-9999);
1089: ELSE
1090: l_quantity := l_conversion * x_max_cubic_area;

Line 1087: fnd_message.set_token('VALUE2', p_billing_uom);

1083: IF(l_conversion <= -999)
1084: THEN
1085: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1086: fnd_message.set_token('VALUE1', x_volume_uom_code);
1087: fnd_message.set_token('VALUE2', p_billing_uom);
1088: RETURN(-9999);
1089: ELSE
1090: l_quantity := l_conversion * x_max_cubic_area;
1091: RETURN(l_quantity);