eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_3PL_SEEDED_SOURCES dependencies on FND_API

Line 66: x_return_status := fnd_api.g_ret_sts_success;

62: l_in_loop NUMBER := 0;
63:
64: BEGIN
65:
66: x_return_status := fnd_api.g_ret_sts_success;
67: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
68: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
69: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
70: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

Line 111: x_return_status := fnd_api.g_ret_sts_error;

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:
115: END IF;

Line 113: RAISE fnd_api.g_exc_unexpected_error;

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:
115: END IF;
116:
117: debug('Effective Counter reading => '||rt_counter);

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: debug('Exception raised in seeded source '||sqlerrm);
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: x_counter_value := 0;
124:
125: END number_receive_transactions;
126:

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: l_in_loop NUMBER := 0;
149:
150: BEGIN
151:
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
154: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
155: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
156: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

Line 197: x_return_status := fnd_api.g_ret_sts_error;

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;
201:

Line 198: RAISE fnd_api.g_exc_unexpected_error;

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;
201:
202: debug('Effective Counter reading => '||mmt_counter);

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: debug('Exception raised in seeded source '||sqlerrm);
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: x_counter_value := 0;
209: END number_shipment_lines;
210:
211:

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234: l_in_loop NUMBER := 0;
235:
236: BEGIN
237:
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
240: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
241: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
242: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

Line 283: x_return_status := fnd_api.g_ret_sts_error;

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:
287: END IF;

Line 284: RAISE fnd_api.g_exc_unexpected_error;

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:
287: END IF;
288:

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: debug('Exception raised in seeded source '||sqlerrm);
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: x_counter_value := 0;
296: END number_picking_transactions;
297:
298: -- Bug 9475436 --

Line 352: x_return_status := fnd_api.g_ret_sts_success;

348: BEGIN
349:
350: debug('Starting of INV 3PL qty received ');
351:
352: x_return_status := fnd_api.g_ret_sts_success;
353: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code;
354: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
355: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;
356: l_last_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_invoice_date;

Line 403: x_return_status := fnd_api.g_ret_sts_error;

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;
406: END IF;
407: l_temp_quantity := items.quantity * l_conversion;

Line 405: RAISE fnd_api.G_EXC_ERROR;

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;
406: END IF;
407: l_temp_quantity := items.quantity * l_conversion;
408: l_quantity := l_quantity + l_temp_quantity;
409: END LOOP;

Line 422: x_return_status := fnd_api.g_ret_sts_error;

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:
426: END IF;

Line 423: RAISE fnd_api.g_exc_unexpected_error;

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:
426: END IF;
427:

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: END IF;
427:
428: EXCEPTION
429: WHEN NO_DATA_FOUND THEN
430: x_return_status := fnd_api.g_ret_sts_success;
431: x_counter_value := 0;
432: WHEN OTHERS THEN
433: debug('Exception raised in seeded source '||sqlerrm);
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: x_return_status := fnd_api.g_ret_sts_success;
431: x_counter_value := 0;
432: WHEN OTHERS THEN
433: debug('Exception raised in seeded source '||sqlerrm);
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: x_counter_value := 0;
436: END qty_receiving_transactions;
437:
438: PROCEDURE number_putaway_transactions

Line 464: x_return_status := FND_API.G_RET_STS_SUCCESS;

460: l_in_loop NUMBER := 0;
461:
462: BEGIN
463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
466: l_operating_unit := INV_3PL_BILLING_PUB.g_billing_source_rec.operating_unit; --'Business1';
467: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
468: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date; --to_date('23-NOV-2009', 'DD-MON-YYYY'); --

Line 509: x_return_status := fnd_api.g_ret_sts_error;

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:
513: END IF;

Line 510: RAISE fnd_api.g_exc_unexpected_error;

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:
513: END IF;
514:

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: debug('Exception raised in seeded source '||sqlerrm);
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: x_counter_value := 0;
523:
524: END number_putaway_transactions;
525:

Line 564: x_return_status := fnd_api.g_ret_sts_success;

560: l_applid NUMBER;
561:
562: BEGIN
563:
564: x_return_status := fnd_api.g_ret_sts_success;
565: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
566: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
567: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
568: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

Line 645: x_return_status := fnd_api.g_ret_sts_error;

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;
649: x_counter_value := 0;

Line 648: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
649: x_counter_value := 0;
650: -- raise fnd_api.g_exc_unexpected_error;
651: END IF;
652: rollback to process_locator;

Line 650: -- raise fnd_api.g_exc_unexpected_error;

646: x_counter_value := 0;
647: ELSE
648: x_return_status := fnd_api.g_ret_sts_unexp_error;
649: x_counter_value := 0;
650: -- raise fnd_api.g_exc_unexpected_error;
651: END IF;
652: rollback to process_locator;
653:
654: debug(' : Could not get locator occupancy details for following combination ');

Line 715: x_return_status := fnd_api.g_ret_sts_success;

711: BEGIN
712:
713: debug('Entered INV_3PL_SEEDED_SOURCES.volume_utilized initial');
714:
715: x_return_status := fnd_api.g_ret_sts_success;
716: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
717: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
718: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
719: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

Line 747: RAISE fnd_api.G_EXC_ERROR;

743: debug(' ----------------------------------------------------------------------');
744: debug(' Client_code => '||locator_occupancy_rec.client_code );
745: debug(' Locator_id => '||locator_occupancy_rec.locator_id );
746: rollback to process_locator;
747: RAISE fnd_api.G_EXC_ERROR;
748: x_counter_value := 0;
749: x_return_status := fnd_api.g_ret_sts_error;
750: RETURN;
751: END IF;

Line 749: x_return_status := fnd_api.g_ret_sts_error;

745: debug(' Locator_id => '||locator_occupancy_rec.locator_id );
746: rollback to process_locator;
747: RAISE fnd_api.G_EXC_ERROR;
748: x_counter_value := 0;
749: x_return_status := fnd_api.g_ret_sts_error;
750: RETURN;
751: END IF;
752:
753: IF ( l_volume_locator = -1234)

Line 762: RAISE fnd_api.G_EXC_ERROR;

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;
766: END IF;

Line 763: x_return_status := fnd_api.g_ret_sts_error;

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;
766: END IF;
767:

Line 837: x_return_status := fnd_api.g_ret_sts_error;

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;
841: x_counter_value := 0;

Line 840: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
841: x_counter_value := 0;
842: -- raise fnd_api.g_exc_unexpected_error;
843: END IF;
844: rollback to process_locator;

Line 842: -- raise fnd_api.g_exc_unexpected_error;

838: x_counter_value := 0;
839: ELSE
840: x_return_status := fnd_api.g_ret_sts_unexp_error;
841: x_counter_value := 0;
842: -- raise fnd_api.g_exc_unexpected_error;
843: END IF;
844: rollback to process_locator;
845: debug(' : Could not get locator occupancy details for following combination ');
846: debug(' ----------------------------------------------------------------------');

Line 906: x_return_status := fnd_api.g_ret_sts_success;

902: BEGIN
903:
904: debug('Entered INV_3PL_SEEDED_SOURCES.area_utlized initial');
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: l_client_code := INV_3PL_BILLING_PUB.g_billing_source_rec.client_code; --'Business1';
908: l_invoice_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
909: l_source_to_date := INV_3PL_BILLING_PUB.g_billing_source_rec.source_to_date;
910: l_last_computation_date := INV_3PL_BILLING_PUB.g_billing_source_rec.last_computation_Date;

Line 939: RAISE fnd_api.G_EXC_ERROR;

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;
943: END IF;

Line 940: x_return_status := fnd_api.g_ret_sts_error;

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;
943: END IF;
944:

Line 1015: x_return_status := fnd_api.g_ret_sts_error;

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;
1019: x_counter_value := 0;

Line 1018: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
1019: x_counter_value := 0;
1020: -- raise fnd_api.g_exc_unexpected_error;
1021: END IF;
1022: rollback to process_locator;

Line 1020: -- raise fnd_api.g_exc_unexpected_error;

1016: x_counter_value := 0;
1017: ELSE
1018: x_return_status := fnd_api.g_ret_sts_unexp_error;
1019: x_counter_value := 0;
1020: -- raise fnd_api.g_exc_unexpected_error;
1021: END IF;
1022: rollback to process_locator;
1023: debug(' : Could not get locator occupancy details for following combination ');
1024: debug(' ----------------------------------------------------------------------');