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_COST_GROUP_UPDATE dependencies on FND_API

Line 72: x_return_status := fnd_api.g_ret_sts_success;

68: print_debug('in proc_update_mmtt .. p_cost_group_id : '|| p_cost_group_id );
69: print_debug('in proc_update_mmtt .. p_transaction_action_id : '|| p_transaction_action_id );
70: print_debug('in proc_update_mmtt .. p_transfer_organization : '|| p_transfer_organization );
71: END IF;
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: IF p_transaction_action_id IN (inv_globals.g_action_subxfr,
75: inv_globals.g_action_stgxfr,
76: inv_globals.g_action_ownxfr)

Line 122: x_return_status := FND_API.G_RET_STS_ERROR ;

118: primary_quantity = Nvl(p_primary_quantity, primary_quantity),
119: transaction_quantity = Nvl(p_transaction_quantity, transaction_quantity)
120: WHERE transaction_temp_id = p_transaction_temp_id;
121: IF (SQL%NOTFOUND )THEN
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
124: fnd_message.set_token('ENTITY1', 'mtl_material_transactions_temp');
125: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
126: fnd_msg_pub.add;

Line 133: WHEN FND_API.G_EXC_ERROR THEN

129: END IF;
130: END IF;
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: IF (l_debug = 1) THEN
136: print_debug('proc_update_mmtt .. EXCEP G_EXC_ERROR : ' );
137: END IF;

Line 134: x_return_status := FND_API.G_RET_STS_ERROR ;

130: END IF;
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: IF (l_debug = 1) THEN
136: print_debug('proc_update_mmtt .. EXCEP G_EXC_ERROR : ' );
137: END IF;
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: IF (l_debug = 1) THEN
136: print_debug('proc_update_mmtt .. EXCEP G_EXC_ERROR : ' );
137: END IF;
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140: IF (l_debug = 1) THEN
141: print_debug('proc_update_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
142: END IF;

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

135: IF (l_debug = 1) THEN
136: print_debug('proc_update_mmtt .. EXCEP G_EXC_ERROR : ' );
137: END IF;
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140: IF (l_debug = 1) THEN
141: print_debug('proc_update_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
142: END IF;
143: WHEN OTHERS THEN

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

140: IF (l_debug = 1) THEN
141: print_debug('proc_update_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
142: END IF;
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: IF (l_debug = 1) THEN
146: print_debug('proc_update_mmtt .. UNEXCEP OTHERS : ' );
147: END IF;
148: END proc_update_mmtt ;

Line 166: x_return_status := fnd_api.g_ret_sts_success;

162: print_debug('in proc_update_msnt .. p_from_serial_number: '|| p_from_serial_number);
163: print_debug('in proc_update_msnt .. p_to_serial_number: '|| p_to_serial_number);
164: END IF;
165:
166: x_return_status := fnd_api.g_ret_sts_success;
167:
168: UPDATE mtl_serial_numbers_temp
169: SET
170: transaction_temp_id = p_new_transaction_temp_id,

Line 176: x_return_status := FND_API.G_RET_STS_ERROR ;

172: to_serial_number = p_to_serial_number
173: WHERE ROWID = p_rowid;
174:
175: IF (SQL%NOTFOUND) THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');
179: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
180: fnd_msg_pub.add;

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

184: END IF;
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: IF (l_debug = 1) THEN
190: print_debug('proc_update_msnt .. UNEXCEP OTHERS : ');
191: END IF;
192: END proc_update_msnt;

Line 214: x_return_status := fnd_api.g_ret_sts_success;

210: print_debug('in proc_update_mtlt .. p_transaction_quantity: '|| p_transaction_quantity);
211: print_debug('in proc_update_mtlt .. p_new_serial_trx_temp_id: '|| p_new_serial_trx_temp_id);
212: END IF;
213:
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: UPDATE mtl_transaction_lots_temp
217: SET
218: transaction_temp_id = p_new_transaction_temp_id,

Line 226: x_return_status := FND_API.G_RET_STS_ERROR ;

222: serial_transaction_temp_id = p_new_serial_trx_temp_id
223: WHERE ROWID = p_rowid;
224:
225: IF (SQL%NOTFOUND) THEN
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
228: fnd_message.set_token('ENTITY1', 'MTL_LOT_NUMBERS_TEMP');
229: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
230: fnd_msg_pub.add;

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

234: END IF;
235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
239: IF (l_debug = 1) THEN
240: print_debug('proc_update_mtlt .. UNEXCEP OTHERS : ');
241: END IF;
242: END proc_update_mtlt;

Line 395: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

391: l_negative_balances_allowed NUMBER;
392: l_override_neg_for_backflush NUMBER := 0;
393: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
394:
395: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
396: l_msg_data VARCHAR2(255) := NULL;
397: l_msg_count NUMBER;
398: l_cost_group_id NUMBER;
399:

Line 401: x_return_status := fnd_api.g_ret_sts_success;

397: l_msg_count NUMBER;
398: l_cost_group_id NUMBER;
399:
400: BEGIN
401: x_return_status := fnd_api.g_ret_sts_success;
402:
403: SELECT primary_cost_method, negative_inv_receipt_code
404: INTO l_primary_cost_method, l_negative_balances_allowed
405: FROM mtl_parameters

Line 455: IF l_return_status <> fnd_api.g_ret_sts_success THEN

451: print_debug('get_cg_for_neg_onhand ret l_return_status '||l_return_status);
452: print_debug('get_cg_for_neg_onhand ret l_cost_group_id '||l_cost_group_id);
453: END IF;
454:
455: IF l_return_status <> fnd_api.g_ret_sts_success THEN
456: IF (l_debug = 1) THEN
457: print_debug('get_cg_for_neg_onhand ret l_msg_data '||l_msg_data);
458: END IF;
459: RAISE FND_API.G_EXC_ERROR;

Line 459: RAISE FND_API.G_EXC_ERROR;

455: IF l_return_status <> fnd_api.g_ret_sts_success THEN
456: IF (l_debug = 1) THEN
457: print_debug('get_cg_for_neg_onhand ret l_msg_data '||l_msg_data);
458: END IF;
459: RAISE FND_API.G_EXC_ERROR;
460:
461: ELSIF (l_return_status = fnd_api.g_ret_sts_success) AND
462: (l_cost_group_id IS NOT NULL) THEN
463:

Line 461: ELSIF (l_return_status = fnd_api.g_ret_sts_success) AND

457: print_debug('get_cg_for_neg_onhand ret l_msg_data '||l_msg_data);
458: END IF;
459: RAISE FND_API.G_EXC_ERROR;
460:
461: ELSIF (l_return_status = fnd_api.g_ret_sts_success) AND
462: (l_cost_group_id IS NOT NULL) THEN
463:
464: IF valid_cost_group(p_cost_group_id => l_cost_group_id,
465: p_organization_id => p_organization_id) THEN

Line 471: RAISE FND_API.G_EXC_ERROR;

467: ELSE
468: IF (l_debug = 1) THEN
469: print_debug('Invalid cost group returned from inv_user_cost_group.get_cg_for_neg_onhand');
470: END IF;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473: --2690948 Bug fix
474:
475: ELSE

Line 508: x_return_status := FND_API.G_RET_STS_ERROR ;

504: END IF;
505: END IF;
506: END IF;
507: ELSIF l_negative_balances_allowed = 2 THEN -- Negative balances are not allowed
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
510: fnd_msg_pub.add;
511: END IF;
512: EXCEPTION

Line 514: x_return_status := FND_API.G_RET_STS_ERROR ;

510: fnd_msg_pub.add;
511: END IF;
512: EXCEPTION
513: WHEN no_data_found THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
516: fnd_msg_pub.add;
517: IF (l_debug = 1) THEN
518: print_debug('proc_get_default_costgroup .. no_data_found' );

Line 542: x_return_status := fnd_api.g_ret_sts_success;

538: BEGIN
539: IF (l_debug = 1) THEN
540: print_debug('In proc_get_pending_costgroup... ');
541: END IF;
542: x_return_status := fnd_api.g_ret_sts_success;
543:
544: IF p_serial_number IS NULL THEN
545: IF (l_debug = 1) THEN
546: print_debug('In proc_get_pending_costgroup...No Control ');

Line 767: x_return_status := FND_API.G_RET_STS_ERROR ;

763: OR x_cost_group_id = 0 THEN
764: IF (l_debug = 1) THEN
765: print_debug('proc_get_pendingcostgroup...cg is null or cg is zero for pending txn :x_cost_group_id' || x_cost_group_id);
766: print_debug('returning error to call proc_get_default_costgroup() api..');
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: END IF;
769: ELSE
770: IF (l_debug = 1) THEN
771: print_debug('proc_get_pendingcostgroup... Returning success with CG:'|| x_cost_group_id);

Line 773: x_return_status := FND_API.g_ret_sts_success;

769: ELSE
770: IF (l_debug = 1) THEN
771: print_debug('proc_get_pendingcostgroup... Returning success with CG:'|| x_cost_group_id);
772: END IF;
773: x_return_status := FND_API.g_ret_sts_success;
774: END IF;
775:
776: EXCEPTION
777: WHEN no_data_found THEN

Line 778: x_return_status := FND_API.G_RET_STS_ERROR ;

774: END IF;
775:
776: EXCEPTION
777: WHEN no_data_found THEN
778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
780: fnd_msg_pub.add;
781: IF (l_debug = 1) THEN
782: print_debug('proc_get_pending_costgroup .. no_data_found' );

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

781: IF (l_debug = 1) THEN
782: print_debug('proc_get_pending_costgroup .. no_data_found' );
783: END IF;
784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
786: IF (l_debug = 1) THEN
787: print_debug('proc_get_pending_costgroup .. UNEXCEP OTHERS : ' );
788: END IF;
789: END proc_get_pending_costgroup;

Line 823: x_return_status := fnd_api.g_ret_sts_success;

819: print_debug('p_lpn_id'||p_lpn_id);
820: print_debug('p_transaction_action_id'||p_transaction_action_id);
821: END IF;
822:
823: x_return_status := fnd_api.g_ret_sts_success;
824: IF p_lpn_id IS NULL THEN
825: IF p_serial_number IS NULL THEN
826: SELECT moq.cost_group_id -- Loose material, no serial control
827: INTO x_cost_group_id

Line 937: x_return_status := FND_API.g_ret_sts_success;

933: ELSE
934: IF (l_debug = 1) THEN
935: print_debug('proc_get_costgroup... Returning success with CG:'|| x_cost_group_id);
936: END IF;
937: x_return_status := FND_API.g_ret_sts_success;
938: END IF;
939:
940: EXCEPTION
941: WHEN FND_API.G_EXC_ERROR THEN

Line 941: WHEN FND_API.G_EXC_ERROR THEN

937: x_return_status := FND_API.g_ret_sts_success;
938: END IF;
939:
940: EXCEPTION
941: WHEN FND_API.G_EXC_ERROR THEN
942: IF (l_debug = 1) THEN
943: print_debug('proc_get_costgroup .. EXCEP G_EXC_ERROR : ' );
944: END IF;
945: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 945: x_return_status := FND_API.G_RET_STS_ERROR ;

941: WHEN FND_API.G_EXC_ERROR THEN
942: IF (l_debug = 1) THEN
943: print_debug('proc_get_costgroup .. EXCEP G_EXC_ERROR : ' );
944: END IF;
945: x_return_status := FND_API.G_RET_STS_ERROR ;
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947: IF (l_debug = 1) THEN
948: print_debug('proc_get_costgroup .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
949: END IF;

Line 946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

942: IF (l_debug = 1) THEN
943: print_debug('proc_get_costgroup .. EXCEP G_EXC_ERROR : ' );
944: END IF;
945: x_return_status := FND_API.G_RET_STS_ERROR ;
946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947: IF (l_debug = 1) THEN
948: print_debug('proc_get_costgroup .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
949: END IF;
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
947: IF (l_debug = 1) THEN
948: print_debug('proc_get_costgroup .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
949: END IF;
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
951: WHEN no_data_found THEN
952: IF (l_debug = 1) THEN
953: print_debug('proc_get_costgroup .. No data found in MOQ, checking MMTT' );
954: END IF;

Line 968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

964: p_transaction_action_id => p_transaction_action_id,
965: x_cost_group_id => x_cost_group_id,
966: x_return_status => x_return_status);
967: WHEN OTHERS THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
969: IF (l_debug = 1) THEN
970: print_debug('proc_get_costgroup .. UNEXCEP OTHERS : ' );
971: END IF;
972:

Line 1014: x_return_status := fnd_api.g_ret_sts_error;

1010: print_debug('proc_get_costgroup returned ' || x_return_status);
1011: END IF;
1012:
1013: IF x_return_status = g_corrupt_cg_error THEN
1014: x_return_status := fnd_api.g_ret_sts_error;
1015: ELSIF x_return_status <> fnd_api.g_ret_sts_success THEN
1016: proc_get_default_costgroup(p_organization_id => p_organization_id,
1017: p_inventory_item_id => p_inventory_item_id,
1018: p_subinventory_code => p_subinventory_code,

Line 1015: ELSIF x_return_status <> fnd_api.g_ret_sts_success THEN

1011: END IF;
1012:
1013: IF x_return_status = g_corrupt_cg_error THEN
1014: x_return_status := fnd_api.g_ret_sts_error;
1015: ELSIF x_return_status <> fnd_api.g_ret_sts_success THEN
1016: proc_get_default_costgroup(p_organization_id => p_organization_id,
1017: p_inventory_item_id => p_inventory_item_id,
1018: p_subinventory_code => p_subinventory_code,
1019: p_locator_id => p_locator_id,

Line 1044: x_return_status := fnd_api.g_ret_sts_success;

1040: IS
1041: l_api_name CONSTANT VARCHAR2(100) := 'proc_insert_msnt';
1042: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1043: BEGIN
1044: x_return_status := fnd_api.g_ret_sts_success;
1045: SAVEPOINT sp_proc_insert_msnt;
1046: IF (l_debug = 1) THEN
1047: print_debug('proc_insert_msnt.. FSN: ' || p_from_serial_number);
1048: print_debug('proc_insert_msnt.. TSN: ' || p_to_serial_number);

Line 1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1221: IF (l_debug = 1) THEN
1222: print_debug( 'proc_insert_msnt .. EXCEP others : ' );
1223: END IF;
1224: ROLLBACK TO sp_proc_insert_msnt;
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: END proc_insert_msnt;
1227: --
1228: PROCEDURE proc_insert_mtlt (p_mtlt_rec IN cur_mtlt%ROWTYPE,
1229: p_new_txn_temp_id IN NUMBER,

Line 1237: x_return_status := fnd_api.g_ret_sts_success;

1233: x_return_status OUT NOCOPY VARCHAR2)
1234: IS
1235: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1236: BEGIN
1237: x_return_status := fnd_api.g_ret_sts_success;
1238: SAVEPOINT sp_proc_insert_mtlt;
1239:
1240: IF (l_debug = 1) THEN
1241: print_debug( 'proc_insert_mtlt ..p_new_txn_temp_id :'|| p_new_txn_temp_id );

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1439: IF (l_debug = 1) THEN
1440: print_debug( 'proc_insert_mtlt .. EXCEP others : ' );
1441: END IF;
1442: ROLLBACK TO sp_proc_insert_mtlt;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: END proc_insert_mtlt;
1445: --
1446: PROCEDURE proc_insert_mmtt(p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE,
1447: p_transfer_wms_org IN BOOLEAN,

Line 1468: x_return_status := fnd_api.g_ret_sts_success;

1464: l_msg_count NUMBER := NULL;
1465:
1466: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1467: BEGIN
1468: x_return_status := fnd_api.g_ret_sts_success;
1469: IF (l_debug = 1) THEN
1470: print_debug( 'Begin proc_insert_mmtt: action_id: ' || p_mmtt_rec.transaction_action_id );
1471: END IF;
1472: SAVEPOINT sp_proc_insert_mmtt;

Line 1991: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1987: , x_msg_data => L_msg_data
1988: , x_comingling_occurs => l_comingling_occurs
1989: , p_transaction_temp_id => p_mmtt_rec.transaction_temp_id);
1990:
1991: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1992: RAISE fnd_api.g_exc_unexpected_error;
1993: ELSIF l_comingling_occurs = 'Y' THEN
1994: IF (l_debug = 1) THEN
1995: print_debug('proc_insert_mmtt .. comigling occurs : ' );

Line 1992: RAISE fnd_api.g_exc_unexpected_error;

1988: , x_comingling_occurs => l_comingling_occurs
1989: , p_transaction_temp_id => p_mmtt_rec.transaction_temp_id);
1990:
1991: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1992: RAISE fnd_api.g_exc_unexpected_error;
1993: ELSIF l_comingling_occurs = 'Y' THEN
1994: IF (l_debug = 1) THEN
1995: print_debug('proc_insert_mmtt .. comigling occurs : ' );
1996: END IF;

Line 2005: WHEN FND_API.G_EXC_ERROR THEN

2001: x_return_status := inv_cost_group_pvt.g_comingle_error;
2002: END IF;
2003:
2004: EXCEPTION
2005: WHEN FND_API.G_EXC_ERROR THEN
2006: x_return_status := FND_API.G_RET_STS_ERROR ;
2007: IF (l_debug = 1) THEN
2008: print_debug('proc_insert_mmtt .. EXCEP G_EXC_ERROR : ' );
2009: END IF;

Line 2006: x_return_status := FND_API.G_RET_STS_ERROR ;

2002: END IF;
2003:
2004: EXCEPTION
2005: WHEN FND_API.G_EXC_ERROR THEN
2006: x_return_status := FND_API.G_RET_STS_ERROR ;
2007: IF (l_debug = 1) THEN
2008: print_debug('proc_insert_mmtt .. EXCEP G_EXC_ERROR : ' );
2009: END IF;
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2006: x_return_status := FND_API.G_RET_STS_ERROR ;
2007: IF (l_debug = 1) THEN
2008: print_debug('proc_insert_mmtt .. EXCEP G_EXC_ERROR : ' );
2009: END IF;
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2012: IF (l_debug = 1) THEN
2013: print_debug('proc_insert_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2014: END IF;

Line 2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2007: IF (l_debug = 1) THEN
2008: print_debug('proc_insert_mmtt .. EXCEP G_EXC_ERROR : ' );
2009: END IF;
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2012: IF (l_debug = 1) THEN
2013: print_debug('proc_insert_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2014: END IF;
2015: WHEN OTHERS THEN

Line 2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2012: IF (l_debug = 1) THEN
2013: print_debug('proc_insert_mmtt .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2014: END IF;
2015: WHEN OTHERS THEN
2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2017: IF (l_debug = 1) THEN
2018: print_debug('proc_insert_mmtt .. EXCEP others: ' || SQLERRM(SQLCODE) );
2019: END IF;
2020: END proc_insert_mmtt;

Line 2041: x_return_status := fnd_api.g_ret_sts_success;

2037: l_onhand_exists BOOLEAN := TRUE;
2038: l_is_backflush_txn BOOLEAN := FALSE;
2039: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2040: BEGIN
2041: x_return_status := fnd_api.g_ret_sts_success;
2042: IF (l_debug = 1) THEN
2043: print_debug( 'in proc_process_nocontrol p_mmtt_rec.transaction_temp_id:' || p_mmtt_rec.transaction_temp_id || ':');
2044: print_debug( '1: '||p_mmtt_rec.organization_id || ':');
2045: print_debug( '2: '||p_mmtt_rec.inventory_item_id || ':');

Line 2086: p_init_msg_list => FND_API.G_FALSE,

2082: print_debug('Getting transfer cost group id from rules engine...: ');
2083: END IF;
2084: wms_costgroupengine_pvt.assign_cost_group
2085: (p_api_version => 1.0,
2086: p_init_msg_list => FND_API.G_FALSE,
2087: p_commit => FND_API.G_FALSE,
2088: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2089: x_return_status => x_return_Status,
2090: x_msg_count => x_msg_count,

Line 2087: p_commit => FND_API.G_FALSE,

2083: END IF;
2084: wms_costgroupengine_pvt.assign_cost_group
2085: (p_api_version => 1.0,
2086: p_init_msg_list => FND_API.G_FALSE,
2087: p_commit => FND_API.G_FALSE,
2088: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2089: x_return_status => x_return_Status,
2090: x_msg_count => x_msg_count,
2091: x_msg_data => x_msg_data,

Line 2088: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2084: wms_costgroupengine_pvt.assign_cost_group
2085: (p_api_version => 1.0,
2086: p_init_msg_list => FND_API.G_FALSE,
2087: p_commit => FND_API.G_FALSE,
2088: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2089: x_return_status => x_return_Status,
2090: x_msg_count => x_msg_count,
2091: x_msg_data => x_msg_data,
2092: p_line_id => p_mmtt_rec.transaction_temp_id,

Line 2095: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2091: x_msg_data => x_msg_data,
2092: p_line_id => p_mmtt_rec.transaction_temp_id,
2093: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
2094:
2095: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2096: IF (l_debug = 1) THEN
2097: print_debug('return error from wms_costgroupengine_pvt');
2098: END IF;
2099: RAISE FND_API.G_EXC_ERROR;

Line 2099: RAISE FND_API.G_EXC_ERROR;

2095: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2096: IF (l_debug = 1) THEN
2097: print_debug('return error from wms_costgroupengine_pvt');
2098: END IF;
2099: RAISE FND_API.G_EXC_ERROR;
2100: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2101: IF (l_debug = 1) THEN
2102: print_debug('return unexpected error from wms_costgroupengine_pvt');
2103: END IF;

Line 2100: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2096: IF (l_debug = 1) THEN
2097: print_debug('return error from wms_costgroupengine_pvt');
2098: END IF;
2099: RAISE FND_API.G_EXC_ERROR;
2100: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2101: IF (l_debug = 1) THEN
2102: print_debug('return unexpected error from wms_costgroupengine_pvt');
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2100: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2101: IF (l_debug = 1) THEN
2102: print_debug('return unexpected error from wms_costgroupengine_pvt');
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: END IF;
2106:
2107: END IF;
2108: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 2161: IF (x_return_status = fnd_api.g_ret_sts_error)

2157: IF (l_debug = 1) THEN
2158: print_debug('proc_determine_costgroup return : ' || x_return_status);
2159: print_debug('proc_determine_costgroup cg : ' || l_cost_group_id);
2160: END IF;
2161: IF (x_return_status = fnd_api.g_ret_sts_error)
2162: THEN
2163: RAISE fnd_api.g_exc_error ;
2164: END IF;
2165:

Line 2163: RAISE fnd_api.g_exc_error ;

2159: print_debug('proc_determine_costgroup cg : ' || l_cost_group_id);
2160: END IF;
2161: IF (x_return_status = fnd_api.g_ret_sts_error)
2162: THEN
2163: RAISE fnd_api.g_exc_error ;
2164: END IF;
2165:
2166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2167: THEN

Line 2166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2162: THEN
2163: RAISE fnd_api.g_exc_error ;
2164: END IF;
2165:
2166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2167: THEN
2168: RAISE fnd_api.g_exc_unexpected_error ;
2169: END IF;
2170:

Line 2168: RAISE fnd_api.g_exc_unexpected_error ;

2164: END IF;
2165:
2166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2167: THEN
2168: RAISE fnd_api.g_exc_unexpected_error ;
2169: END IF;
2170:
2171: IF (l_debug = 1) THEN
2172: print_debug('call :proc_update_mmtt :p_transaction_temp_id: ' || p_mmtt_rec.transaction_temp_id);

Line 2195: IF (x_return_status = fnd_api.g_ret_sts_error)

2191:
2192: IF (l_debug = 1) THEN
2193: print_debug('proc_update_mmtt return : ' || x_return_status);
2194: END IF;
2195: IF (x_return_status = fnd_api.g_ret_sts_error)
2196: THEN
2197: RAISE fnd_api.g_exc_error ;
2198: END IF;
2199:

Line 2197: RAISE fnd_api.g_exc_error ;

2193: print_debug('proc_update_mmtt return : ' || x_return_status);
2194: END IF;
2195: IF (x_return_status = fnd_api.g_ret_sts_error)
2196: THEN
2197: RAISE fnd_api.g_exc_error ;
2198: END IF;
2199:
2200: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2201: THEN

Line 2200: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2196: THEN
2197: RAISE fnd_api.g_exc_error ;
2198: END IF;
2199:
2200: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2201: THEN
2202: RAISE fnd_api.g_exc_unexpected_error ;
2203: END IF;
2204: END IF; -- Onhand exists

Line 2202: RAISE fnd_api.g_exc_unexpected_error ;

2198: END IF;
2199:
2200: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2201: THEN
2202: RAISE fnd_api.g_exc_unexpected_error ;
2203: END IF;
2204: END IF; -- Onhand exists
2205:
2206: EXCEPTION

Line 2207: WHEN FND_API.G_EXC_ERROR THEN

2203: END IF;
2204: END IF; -- Onhand exists
2205:
2206: EXCEPTION
2207: WHEN FND_API.G_EXC_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_ERROR ;
2209: IF (l_debug = 1) THEN
2210: print_debug('no process control .. EXCEP G_EXC_ERROR : ' );
2211: END IF;

Line 2208: x_return_status := FND_API.G_RET_STS_ERROR ;

2204: END IF; -- Onhand exists
2205:
2206: EXCEPTION
2207: WHEN FND_API.G_EXC_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_ERROR ;
2209: IF (l_debug = 1) THEN
2210: print_debug('no process control .. EXCEP G_EXC_ERROR : ' );
2211: END IF;
2212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2208: x_return_status := FND_API.G_RET_STS_ERROR ;
2209: IF (l_debug = 1) THEN
2210: print_debug('no process control .. EXCEP G_EXC_ERROR : ' );
2211: END IF;
2212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2214: IF (l_debug = 1) THEN
2215: print_debug('no process control .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2216: END IF;

Line 2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2209: IF (l_debug = 1) THEN
2210: print_debug('no process control .. EXCEP G_EXC_ERROR : ' );
2211: END IF;
2212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2214: IF (l_debug = 1) THEN
2215: print_debug('no process control .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2216: END IF;
2217: WHEN OTHERS THEN

Line 2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2214: IF (l_debug = 1) THEN
2215: print_debug('no process control .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2216: END IF;
2217: WHEN OTHERS THEN
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219: IF (l_debug = 1) THEN
2220: print_debug('no process control .. EXCEP OTHERS : ' );
2221: END IF;
2222: END proc_process_nocontrol;

Line 2272: x_return_status := fnd_api.g_ret_sts_success;

2268: l_lpn_id NUMBER := p_mmtt_rec.lpn_id;
2269:
2270: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2271: BEGIN
2272: x_return_status := fnd_api.g_ret_sts_success;
2273: SAVEPOINT sp_proc_process_lots;
2274:
2275: IF (l_debug = 1) THEN
2276: print_debug('IN proc_process_lots.. ');

Line 2327: p_init_msg_list => FND_API.G_FALSE,

2323: END IF;
2324:
2325: wms_costgroupengine_pvt.assign_cost_group
2326: (p_api_version => 1.0,
2327: p_init_msg_list => FND_API.G_FALSE,
2328: p_commit => FND_API.G_FALSE,
2329: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2330: x_return_status => x_return_Status,
2331: x_msg_count => x_msg_count,

Line 2328: p_commit => FND_API.G_FALSE,

2324:
2325: wms_costgroupengine_pvt.assign_cost_group
2326: (p_api_version => 1.0,
2327: p_init_msg_list => FND_API.G_FALSE,
2328: p_commit => FND_API.G_FALSE,
2329: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2330: x_return_status => x_return_Status,
2331: x_msg_count => x_msg_count,
2332: x_msg_data => x_msg_data,

Line 2329: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2325: wms_costgroupengine_pvt.assign_cost_group
2326: (p_api_version => 1.0,
2327: p_init_msg_list => FND_API.G_FALSE,
2328: p_commit => FND_API.G_FALSE,
2329: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2330: x_return_status => x_return_Status,
2331: x_msg_count => x_msg_count,
2332: x_msg_data => x_msg_data,
2333: p_line_id => p_mmtt_rec.transaction_temp_id,

Line 2336: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2332: x_msg_data => x_msg_data,
2333: p_line_id => p_mmtt_rec.transaction_temp_id,
2334: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
2335:
2336: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2337: IF (l_debug = 1) THEN
2338: print_debug('return error from wms_costgroupengine_pvt');
2339: END IF;
2340: RAISE FND_API.G_EXC_ERROR;

Line 2340: RAISE FND_API.G_EXC_ERROR;

2336: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2337: IF (l_debug = 1) THEN
2338: print_debug('return error from wms_costgroupengine_pvt');
2339: END IF;
2340: RAISE FND_API.G_EXC_ERROR;
2341: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2342: IF (l_debug = 1) THEN
2343: print_debug('return unexpected error from wms_costgroupengine_pvt');
2344: END IF;

Line 2341: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2337: IF (l_debug = 1) THEN
2338: print_debug('return error from wms_costgroupengine_pvt');
2339: END IF;
2340: RAISE FND_API.G_EXC_ERROR;
2341: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2342: IF (l_debug = 1) THEN
2343: print_debug('return unexpected error from wms_costgroupengine_pvt');
2344: END IF;
2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2341: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2342: IF (l_debug = 1) THEN
2343: print_debug('return unexpected error from wms_costgroupengine_pvt');
2344: END IF;
2345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2346: END IF;
2347: END IF;
2348: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
2349: OR p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_intorder)

Line 2408: IF x_return_status = fnd_api.g_ret_sts_error THEN

2404:
2405:
2406: l_lots_table(l_lti).cost_group_id := l_cost_group_id;
2407:
2408: IF x_return_status = fnd_api.g_ret_sts_error THEN
2409: RAISE fnd_api.g_exc_error ;
2410: END IF;
2411:
2412: IF l_cg_quantity_table.exists(l_cost_group_id) THEN

Line 2409: RAISE fnd_api.g_exc_error ;

2405:
2406: l_lots_table(l_lti).cost_group_id := l_cost_group_id;
2407:
2408: IF x_return_status = fnd_api.g_ret_sts_error THEN
2409: RAISE fnd_api.g_exc_error ;
2410: END IF;
2411:
2412: IF l_cg_quantity_table.exists(l_cost_group_id) THEN
2413: l_cg_quantity_table(l_cost_group_id).primary_quantity :=

Line 2515: IF (x_return_status = fnd_api.g_ret_sts_error)

2511: print_debug('proc_update_mmtt return : ' || x_return_status);
2512: END IF;
2513: END IF;
2514:
2515: IF (x_return_status = fnd_api.g_ret_sts_error)
2516: THEN
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:

Line 2517: RAISE fnd_api.g_exc_error;

2513: END IF;
2514:
2515: IF (x_return_status = fnd_api.g_ret_sts_error)
2516: THEN
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2521: THEN

Line 2520: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2516: THEN
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2521: THEN
2522: RAISE fnd_api.g_exc_unexpected_error;
2523: END IF;
2524:

Line 2522: RAISE fnd_api.g_exc_unexpected_error;

2518: END IF;
2519:
2520: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2521: THEN
2522: RAISE fnd_api.g_exc_unexpected_error;
2523: END IF;
2524:
2525: EXIT WHEN i = l_cg_quantity_table.last;
2526: i := l_cg_quantity_table.next(i);

Line 2550: IF (x_return_status = fnd_api.g_ret_sts_error)

2546: IF (l_debug = 1) THEN
2547: print_debug('proc_update_mtlt return : ' || x_return_status);
2548: END IF;
2549:
2550: IF (x_return_status = fnd_api.g_ret_sts_error)
2551: THEN
2552: RAISE fnd_api.g_exc_error ;
2553: END IF;
2554:

Line 2552: RAISE fnd_api.g_exc_error ;

2548: END IF;
2549:
2550: IF (x_return_status = fnd_api.g_ret_sts_error)
2551: THEN
2552: RAISE fnd_api.g_exc_error ;
2553: END IF;
2554:
2555: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2556: THEN

Line 2555: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2551: THEN
2552: RAISE fnd_api.g_exc_error ;
2553: END IF;
2554:
2555: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2556: THEN
2557: RAISE fnd_api.g_exc_unexpected_error ;
2558: END IF;
2559: END LOOP;

Line 2557: RAISE fnd_api.g_exc_unexpected_error ;

2553: END IF;
2554:
2555: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2556: THEN
2557: RAISE fnd_api.g_exc_unexpected_error ;
2558: END IF;
2559: END LOOP;
2560:
2561: END IF;

Line 2563: WHEN FND_API.G_EXC_ERROR THEN

2559: END LOOP;
2560:
2561: END IF;
2562: EXCEPTION
2563: WHEN FND_API.G_EXC_ERROR THEN
2564: IF (l_debug = 1) THEN
2565: print_debug('proc_process_lots .. EXCEP G_EXC_ERROR : ' );
2566: END IF;
2567: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2567: x_return_status := FND_API.G_RET_STS_ERROR ;

2563: WHEN FND_API.G_EXC_ERROR THEN
2564: IF (l_debug = 1) THEN
2565: print_debug('proc_process_lots .. EXCEP G_EXC_ERROR : ' );
2566: END IF;
2567: x_return_status := FND_API.G_RET_STS_ERROR ;
2568: IF cur_mtlt%isopen THEN
2569: CLOSE cur_mtlt;
2570: END IF;
2571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2567: x_return_status := FND_API.G_RET_STS_ERROR ;
2568: IF cur_mtlt%isopen THEN
2569: CLOSE cur_mtlt;
2570: END IF;
2571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2572: IF (l_debug = 1) THEN
2573: print_debug('proc_process_lots .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2574: END IF;
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2572: IF (l_debug = 1) THEN
2573: print_debug('proc_process_lots .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
2574: END IF;
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2576: IF cur_mtlt%isopen THEN
2577: CLOSE cur_mtlt;
2578: END IF;
2579: WHEN OTHERS THEN

Line 2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2579: WHEN OTHERS THEN
2580: IF (l_debug = 1) THEN
2581: print_debug('proc_process_lots .. EXCEP OTHERS : ' || SQLERRM(SQLCODE));
2582: END IF;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2584: IF cur_mtlt%isopen THEN
2585: CLOSE cur_mtlt;
2586: END IF;
2587: END proc_process_lots;

Line 2649: x_return_status := fnd_api.g_ret_sts_success;

2645: l_to_ser_number NUMBER := NULL;
2646: --Bug 3686015 fix
2647: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2648: BEGIN
2649: x_return_status := fnd_api.g_ret_sts_success;
2650: SAVEPOINT sp_proc_process_serial;
2651:
2652: IF (l_debug = 1) THEN
2653: print_debug('IN proc_process_serial.. ');

Line 2688: RAISE FND_API.G_EXC_ERROR;

2684: END IF;
2685: fnd_message.set_name('INV', 'Cannot find the serial number
2686: for the transaction being processed');
2687: fnd_msg_pub.add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:
2691: WHILE cur_msnt%found LOOP
2692: IF (l_debug = 1) THEN

Line 2723: RAISE fnd_api.g_exc_error;

2719: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2720: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2721: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2722: fnd_msg_pub.add;
2723: RAISE fnd_api.g_exc_error;
2724: END IF;
2725:
2726: -- get the number part of the to serial
2727: inv_validate.number_from_sequence(rec_msnt.to_serial_number, l_to_temp_prefix, l_to_ser_number);

Line 2743: RAISE fnd_api.g_exc_error;

2739: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2740: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2741: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2742: fnd_msg_pub.add;
2743: RAISE fnd_api.g_exc_error;
2744: END IF;
2745:
2746: END IF;
2747: --Bug 3686015

Line 2799: p_init_msg_list => FND_API.G_FALSE,

2795: print_debug('Getting transfer cost group id from rules engine...: ');
2796: END IF;
2797: wms_costgroupengine_pvt.assign_cost_group
2798: (p_api_version => 1.0,
2799: p_init_msg_list => FND_API.G_FALSE,
2800: p_commit => FND_API.G_FALSE,
2801: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2802: x_return_status => x_return_Status,
2803: x_msg_count => x_msg_count,

Line 2800: p_commit => FND_API.G_FALSE,

2796: END IF;
2797: wms_costgroupengine_pvt.assign_cost_group
2798: (p_api_version => 1.0,
2799: p_init_msg_list => FND_API.G_FALSE,
2800: p_commit => FND_API.G_FALSE,
2801: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2802: x_return_status => x_return_Status,
2803: x_msg_count => x_msg_count,
2804: x_msg_data => x_msg_data,

Line 2801: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2797: wms_costgroupengine_pvt.assign_cost_group
2798: (p_api_version => 1.0,
2799: p_init_msg_list => FND_API.G_FALSE,
2800: p_commit => FND_API.G_FALSE,
2801: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2802: x_return_status => x_return_Status,
2803: x_msg_count => x_msg_count,
2804: x_msg_data => x_msg_data,
2805: p_line_id => p_mmtt_rec.transaction_temp_id,

Line 2808: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2804: x_msg_data => x_msg_data,
2805: p_line_id => p_mmtt_rec.transaction_temp_id,
2806: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
2807:
2808: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2809: IF (l_debug = 1) THEN
2810: print_debug('return error from wms_costgroupengine_pvt');
2811: END IF;
2812: RAISE FND_API.G_EXC_ERROR;

Line 2812: RAISE FND_API.G_EXC_ERROR;

2808: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2809: IF (l_debug = 1) THEN
2810: print_debug('return error from wms_costgroupengine_pvt');
2811: END IF;
2812: RAISE FND_API.G_EXC_ERROR;
2813: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2814: IF (l_debug = 1) THEN
2815: print_debug('return unexpected error from wms_costgroupengine_pvt');
2816: END IF;

Line 2813: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2809: IF (l_debug = 1) THEN
2810: print_debug('return error from wms_costgroupengine_pvt');
2811: END IF;
2812: RAISE FND_API.G_EXC_ERROR;
2813: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2814: IF (l_debug = 1) THEN
2815: print_debug('return unexpected error from wms_costgroupengine_pvt');
2816: END IF;
2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2813: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2814: IF (l_debug = 1) THEN
2815: print_debug('return unexpected error from wms_costgroupengine_pvt');
2816: END IF;
2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: END IF;
2819:
2820: END IF;
2821: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 2895: IF x_return_status = fnd_api.g_ret_sts_error THEN

2891: p_transaction_action_id => p_mmtt_rec.transaction_action_id,
2892: x_cost_group_id => l_cost_group_id,
2893: x_return_status => x_return_status);
2894: rec_msn.cost_group_id := l_cost_group_id;
2895: IF x_return_status = fnd_api.g_ret_sts_error THEN
2896: RAISE fnd_api.g_exc_error;
2897: END IF;
2898: END IF;
2899:

Line 2896: RAISE fnd_api.g_exc_error;

2892: x_cost_group_id => l_cost_group_id,
2893: x_return_status => x_return_status);
2894: rec_msn.cost_group_id := l_cost_group_id;
2895: IF x_return_status = fnd_api.g_ret_sts_error THEN
2896: RAISE fnd_api.g_exc_error;
2897: END IF;
2898: END IF;
2899:
2900: IF l_cg_quantity_table.exists(rec_msn.cost_group_id) THEN

Line 3002: IF (x_return_status = fnd_api.g_ret_sts_error)

2998: IF (l_debug = 1) THEN
2999: print_debug('proc_update_mmtt return : ' || x_return_status);
3000: END IF;
3001: END IF;
3002: IF (x_return_status = fnd_api.g_ret_sts_error)
3003: THEN
3004: RAISE fnd_api.g_exc_error ;
3005: END IF;
3006:

Line 3004: RAISE fnd_api.g_exc_error ;

3000: END IF;
3001: END IF;
3002: IF (x_return_status = fnd_api.g_ret_sts_error)
3003: THEN
3004: RAISE fnd_api.g_exc_error ;
3005: END IF;
3006:
3007: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3008: THEN

Line 3007: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3003: THEN
3004: RAISE fnd_api.g_exc_error ;
3005: END IF;
3006:
3007: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3008: THEN
3009: RAISE fnd_api.g_exc_unexpected_error ;
3010: END IF;
3011:

Line 3009: RAISE fnd_api.g_exc_unexpected_error ;

3005: END IF;
3006:
3007: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3008: THEN
3009: RAISE fnd_api.g_exc_unexpected_error ;
3010: END IF;
3011:
3012: EXIT WHEN i = l_cg_quantity_table.last;
3013: i := l_cg_quantity_table.next(i);

Line 3057: IF (x_return_status = fnd_api.g_ret_sts_error)

3053: print_debug('proc_insert_msnt return : ' || x_return_status);
3054: END IF;
3055: END IF;
3056:
3057: IF (x_return_status = fnd_api.g_ret_sts_error)
3058: THEN
3059: RAISE fnd_api.g_exc_error ;
3060: END IF;
3061:

Line 3059: RAISE fnd_api.g_exc_error ;

3055: END IF;
3056:
3057: IF (x_return_status = fnd_api.g_ret_sts_error)
3058: THEN
3059: RAISE fnd_api.g_exc_error ;
3060: END IF;
3061:
3062: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3063: THEN

Line 3062: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3058: THEN
3059: RAISE fnd_api.g_exc_error ;
3060: END IF;
3061:
3062: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3063: THEN
3064: RAISE fnd_api.g_exc_unexpected_error ;
3065: END IF;
3066:

Line 3064: RAISE fnd_api.g_exc_unexpected_error ;

3060: END IF;
3061:
3062: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3063: THEN
3064: RAISE fnd_api.g_exc_unexpected_error ;
3065: END IF;
3066:
3067: END LOOP;
3068: END IF;

Line 3071: WHEN FND_API.G_EXC_ERROR THEN

3067: END LOOP;
3068: END IF;
3069:
3070: EXCEPTION
3071: WHEN FND_API.G_EXC_ERROR THEN
3072: IF (l_debug = 1) THEN
3073: print_debug('proc_process_serial .. EXCEP G_EXC_ERROR : ' );
3074: END IF;
3075: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3075: x_return_status := FND_API.G_RET_STS_ERROR ;

3071: WHEN FND_API.G_EXC_ERROR THEN
3072: IF (l_debug = 1) THEN
3073: print_debug('proc_process_serial .. EXCEP G_EXC_ERROR : ' );
3074: END IF;
3075: x_return_status := FND_API.G_RET_STS_ERROR ;
3076: IF cur_msnt%isopen THEN
3077: CLOSE cur_msnt;
3078: END IF;
3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3075: x_return_status := FND_API.G_RET_STS_ERROR ;
3076: IF cur_msnt%isopen THEN
3077: CLOSE cur_msnt;
3078: END IF;
3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3080: IF (l_debug = 1) THEN
3081: print_debug('proc_process_serial .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
3082: END IF;
3083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3080: IF (l_debug = 1) THEN
3081: print_debug('proc_process_serial .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
3082: END IF;
3083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3084: IF cur_msnt%isopen THEN
3085: CLOSE cur_msnt;
3086: END IF;
3087: WHEN OTHERS THEN

Line 3091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3087: WHEN OTHERS THEN
3088: IF (l_debug = 1) THEN
3089: print_debug('proc_process_serial .. EXCEP OTHERS:' || SQLERRM(SQLCODE) );
3090: END IF;
3091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3092: IF cur_msnt%isopen THEN
3093: CLOSE cur_msnt;
3094: END IF;
3095: END proc_process_serials;

Line 3208: x_return_status := fnd_api.g_ret_sts_success;

3204: l_to_temp_prefix VARCHAR2(30) := NULL;
3205: l_to_ser_number NUMBER := NULL;
3206: --Bug 3686015 fix
3207: BEGIN
3208: x_return_status := fnd_api.g_ret_sts_success;
3209: SAVEPOINT sp_proc_process_lot_serial;
3210:
3211: IF (l_debug = 1) THEN
3212: print_debug('IN proc_process_lot_serial.. ');

Line 3275: RAISE fnd_api.g_exc_error;

3271: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3272: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3273: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3274: fnd_msg_pub.add;
3275: RAISE fnd_api.g_exc_error;
3276: END IF;
3277:
3278: -- get the number part of the to serial
3279: inv_validate.number_from_sequence(rec_msnt.to_serial_number, l_to_temp_prefix, l_to_ser_number);

Line 3295: RAISE fnd_api.g_exc_error;

3291: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3292: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3293: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3294: fnd_msg_pub.add;
3295: RAISE fnd_api.g_exc_error;
3296: END IF;
3297:
3298: END IF;
3299: --Bug 3686015

Line 3352: p_init_msg_list => FND_API.G_FALSE,

3348: print_debug('Getting transfer cost group id from rules engine...: ');
3349: END IF;
3350: wms_costgroupengine_pvt.assign_cost_group
3351: (p_api_version => 1.0,
3352: p_init_msg_list => FND_API.G_FALSE,
3353: p_commit => FND_API.G_FALSE,
3354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3355: x_return_status => x_return_Status,
3356: x_msg_count => x_msg_count,

Line 3353: p_commit => FND_API.G_FALSE,

3349: END IF;
3350: wms_costgroupengine_pvt.assign_cost_group
3351: (p_api_version => 1.0,
3352: p_init_msg_list => FND_API.G_FALSE,
3353: p_commit => FND_API.G_FALSE,
3354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3355: x_return_status => x_return_Status,
3356: x_msg_count => x_msg_count,
3357: x_msg_data => x_msg_data,

Line 3354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3350: wms_costgroupengine_pvt.assign_cost_group
3351: (p_api_version => 1.0,
3352: p_init_msg_list => FND_API.G_FALSE,
3353: p_commit => FND_API.G_FALSE,
3354: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3355: x_return_status => x_return_Status,
3356: x_msg_count => x_msg_count,
3357: x_msg_data => x_msg_data,
3358: p_line_id => p_mmtt_rec.transaction_temp_id,

Line 3361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3357: x_msg_data => x_msg_data,
3358: p_line_id => p_mmtt_rec.transaction_temp_id,
3359: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
3360:
3361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('return error from wms_costgroupengine_pvt');
3364: END IF;
3365: RAISE FND_API.G_EXC_ERROR;

Line 3365: RAISE FND_API.G_EXC_ERROR;

3361: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3362: IF (l_debug = 1) THEN
3363: print_debug('return error from wms_costgroupengine_pvt');
3364: END IF;
3365: RAISE FND_API.G_EXC_ERROR;
3366: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3367: IF (l_debug = 1) THEN
3368: print_debug('return unexpected error from wms_costgroupengine_pvt');
3369: END IF;

Line 3366: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3362: IF (l_debug = 1) THEN
3363: print_debug('return error from wms_costgroupengine_pvt');
3364: END IF;
3365: RAISE FND_API.G_EXC_ERROR;
3366: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3367: IF (l_debug = 1) THEN
3368: print_debug('return unexpected error from wms_costgroupengine_pvt');
3369: END IF;
3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3366: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3367: IF (l_debug = 1) THEN
3368: print_debug('return unexpected error from wms_costgroupengine_pvt');
3369: END IF;
3370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3371: END IF;
3372:
3373: END IF;
3374: ELSIF (p_mmtt_rec.transaction_source_type_id = inv_globals.g_sourcetype_salesorder

Line 3512: RAISE fnd_api.g_exc_error ;

3508: IF lot_cg_qty_table.exists(rec_msn.cost_group_id) then
3509: lot_cg_qty_table(rec_msn.cost_group_id).quantity :=
3510: lot_cg_qty_table(rec_msn.cost_group_id).quantity + 1 ;
3511: ELSE
3512: RAISE fnd_api.g_exc_error ;
3513: END IF;
3514: --Bug 3390284
3515: ELSE
3516: l_serial_table(l_sti).from_serial_number := rec_msn.serial_number;

Line 3562: IF x_return_status = fnd_api.g_ret_sts_error THEN

3558: p_transaction_action_id => p_mmtt_rec.transaction_action_id,
3559: x_cost_group_id => l_cost_group_id,
3560: x_return_status => x_return_status);
3561: rec_msn.cost_group_id := l_cost_group_id;
3562: IF x_return_status = fnd_api.g_ret_sts_error THEN
3563: RAISE fnd_api.g_exc_error ;
3564: END IF;
3565: END IF;
3566:

Line 3563: RAISE fnd_api.g_exc_error ;

3559: x_cost_group_id => l_cost_group_id,
3560: x_return_status => x_return_status);
3561: rec_msn.cost_group_id := l_cost_group_id;
3562: IF x_return_status = fnd_api.g_ret_sts_error THEN
3563: RAISE fnd_api.g_exc_error ;
3564: END IF;
3565: END IF;
3566:
3567: IF l_cg_quantity_table.exists(rec_msn.cost_group_id) THEN

Line 3722: IF (x_return_status = fnd_api.g_ret_sts_error)

3718: print_debug('proc_update_mmtt return : ' || x_return_status);
3719: END IF;
3720: END IF;
3721:
3722: IF (x_return_status = fnd_api.g_ret_sts_error)
3723: THEN
3724: RAISE fnd_api.g_exc_error;
3725: END IF;
3726:

Line 3724: RAISE fnd_api.g_exc_error;

3720: END IF;
3721:
3722: IF (x_return_status = fnd_api.g_ret_sts_error)
3723: THEN
3724: RAISE fnd_api.g_exc_error;
3725: END IF;
3726:
3727: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3728: THEN

Line 3727: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3723: THEN
3724: RAISE fnd_api.g_exc_error;
3725: END IF;
3726:
3727: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3728: THEN
3729: RAISE fnd_api.g_exc_unexpected_error;
3730: END IF;
3731:

Line 3729: RAISE fnd_api.g_exc_unexpected_error;

3725: END IF;
3726:
3727: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3728: THEN
3729: RAISE fnd_api.g_exc_unexpected_error;
3730: END IF;
3731:
3732: EXIT WHEN i = l_cg_quantity_table.last;
3733: i := l_cg_quantity_table.next(i);

Line 3771: IF (x_return_status = fnd_api.g_ret_sts_error)

3767: l_lot_table(lot_i).serial_transaction_temp_id,
3768: x_return_status);
3769: END IF;
3770:
3771: IF (x_return_status = fnd_api.g_ret_sts_error)
3772: THEN
3773: RAISE fnd_api.g_exc_error ;
3774: END IF;
3775:

Line 3773: RAISE fnd_api.g_exc_error ;

3769: END IF;
3770:
3771: IF (x_return_status = fnd_api.g_ret_sts_error)
3772: THEN
3773: RAISE fnd_api.g_exc_error ;
3774: END IF;
3775:
3776: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3777: THEN

Line 3776: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3772: THEN
3773: RAISE fnd_api.g_exc_error ;
3774: END IF;
3775:
3776: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3777: THEN
3778: RAISE fnd_api.g_exc_unexpected_error ;
3779: END IF;
3780:

Line 3778: RAISE fnd_api.g_exc_unexpected_error ;

3774: END IF;
3775:
3776: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3777: THEN
3778: RAISE fnd_api.g_exc_unexpected_error ;
3779: END IF;
3780:
3781: END LOOP;
3782:

Line 3821: IF (x_return_status = fnd_api.g_ret_sts_error)

3817: print_debug('proc_insert_msnt return : ' || x_return_status);
3818: END IF;
3819: END IF;
3820:
3821: IF (x_return_status = fnd_api.g_ret_sts_error)
3822: THEN
3823: RAISE fnd_api.g_exc_error ;
3824: END IF;
3825:

Line 3823: RAISE fnd_api.g_exc_error ;

3819: END IF;
3820:
3821: IF (x_return_status = fnd_api.g_ret_sts_error)
3822: THEN
3823: RAISE fnd_api.g_exc_error ;
3824: END IF;
3825:
3826: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3827: THEN

Line 3826: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3822: THEN
3823: RAISE fnd_api.g_exc_error ;
3824: END IF;
3825:
3826: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3827: THEN
3828: RAISE fnd_api.g_exc_unexpected_error ;
3829: END IF;
3830:

Line 3828: RAISE fnd_api.g_exc_unexpected_error ;

3824: END IF;
3825:
3826: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
3827: THEN
3828: RAISE fnd_api.g_exc_unexpected_error ;
3829: END IF;
3830:
3831: END LOOP;
3832: END IF;

Line 3834: WHEN FND_API.G_EXC_ERROR THEN

3830:
3831: END LOOP;
3832: END IF;
3833: EXCEPTION
3834: WHEN FND_API.G_EXC_ERROR THEN
3835: IF (l_debug = 1) THEN
3836: print_debug('proc_process_lot_serial .. EXCEP G_EXC_ERROR : ' );
3837: END IF;
3838: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3838: x_return_status := FND_API.G_RET_STS_ERROR ;

3834: WHEN FND_API.G_EXC_ERROR THEN
3835: IF (l_debug = 1) THEN
3836: print_debug('proc_process_lot_serial .. EXCEP G_EXC_ERROR : ' );
3837: END IF;
3838: x_return_status := FND_API.G_RET_STS_ERROR ;
3839: IF cur_msnt%isopen THEN
3840: CLOSE cur_msnt;
3841: END IF;
3842: IF cur_mtlt%isopen THEN

Line 3845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3841: END IF;
3842: IF cur_mtlt%isopen THEN
3843: CLOSE cur_mtlt;
3844: END IF;
3845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3846: IF (l_debug = 1) THEN
3847: print_debug('proc_process_lot_serial .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
3848: END IF;
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3846: IF (l_debug = 1) THEN
3847: print_debug('proc_process_lot_serial .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
3848: END IF;
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3850: IF cur_msnt%isopen THEN
3851: CLOSE cur_msnt;
3852: END IF;
3853: IF cur_mtlt%isopen THEN

Line 3860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3856: WHEN OTHERS THEN
3857: IF (l_debug = 1) THEN
3858: print_debug('proc_process_lot_serial .. EXCEP OTHERS : ' || SQLERRM(SQLCODE));
3859: END IF;
3860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3861: IF cur_msnt%isopen THEN
3862: CLOSE cur_msnt;
3863: END IF;
3864: IF cur_mtlt%isopen THEN

Line 3902: x_return_status := fnd_api.g_ret_sts_success;

3898: BEGIN
3899: -- Standard Start of API savepoint
3900:
3901: SAVEPOINT API_updatecostgroups;
3902: x_return_status := fnd_api.g_ret_sts_success;
3903:
3904: IF (l_debug = 1) THEN
3905: print_debug('Beginning get_cost_group.... with temp_id: ' ||
3906: l_mmtt_rec.transaction_temp_id);

Line 3929: p_init_msg_list => FND_API.G_FALSE,

3925: print_debug('Getting transfer cost group id from rules engine...: ');
3926: END IF;
3927: wms_costgroupengine_pvt.assign_cost_group
3928: (p_api_version => 1.0,
3929: p_init_msg_list => FND_API.G_FALSE,
3930: p_commit => FND_API.G_FALSE,
3931: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3932: x_return_status => x_return_Status,
3933: x_msg_count => x_msg_count,

Line 3930: p_commit => FND_API.G_FALSE,

3926: END IF;
3927: wms_costgroupengine_pvt.assign_cost_group
3928: (p_api_version => 1.0,
3929: p_init_msg_list => FND_API.G_FALSE,
3930: p_commit => FND_API.G_FALSE,
3931: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3932: x_return_status => x_return_Status,
3933: x_msg_count => x_msg_count,
3934: x_msg_data => x_msg_data,

Line 3931: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3927: wms_costgroupengine_pvt.assign_cost_group
3928: (p_api_version => 1.0,
3929: p_init_msg_list => FND_API.G_FALSE,
3930: p_commit => FND_API.G_FALSE,
3931: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3932: x_return_status => x_return_Status,
3933: x_msg_count => x_msg_count,
3934: x_msg_data => x_msg_data,
3935: p_line_id => l_mmtt_rec.transaction_temp_id,

Line 3938: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3934: x_msg_data => x_msg_data,
3935: p_line_id => l_mmtt_rec.transaction_temp_id,
3936: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
3937:
3938: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3939: IF (l_debug = 1) THEN
3940: print_debug('return error from wms_costgroupengine_pvt');
3941: END IF;
3942: RAISE FND_API.G_EXC_ERROR;

Line 3942: RAISE FND_API.G_EXC_ERROR;

3938: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3939: IF (l_debug = 1) THEN
3940: print_debug('return error from wms_costgroupengine_pvt');
3941: END IF;
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3944: IF (l_debug = 1) THEN
3945: print_debug('return unexpected error from wms_costgroupengine_pvt');
3946: END IF;

Line 3943: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3939: IF (l_debug = 1) THEN
3940: print_debug('return error from wms_costgroupengine_pvt');
3941: END IF;
3942: RAISE FND_API.G_EXC_ERROR;
3943: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3944: IF (l_debug = 1) THEN
3945: print_debug('return unexpected error from wms_costgroupengine_pvt');
3946: END IF;
3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3943: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3944: IF (l_debug = 1) THEN
3945: print_debug('return unexpected error from wms_costgroupengine_pvt');
3946: END IF;
3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3948: END IF;
3949:
3950: -- Requery MMTT to get the fresh records
3951: SELECT *

Line 3998: IF (x_return_status = fnd_api.g_ret_sts_error)

3994: x_return_status);
3995: IF (l_debug = 1) THEN
3996: print_debug('proc_update_mmtt : ' || x_return_status);
3997: END IF;
3998: IF (x_return_status = fnd_api.g_ret_sts_error)
3999: THEN
4000: RAISE fnd_api.g_exc_error ;
4001: END IF;
4002:

Line 4000: RAISE fnd_api.g_exc_error ;

3996: print_debug('proc_update_mmtt : ' || x_return_status);
3997: END IF;
3998: IF (x_return_status = fnd_api.g_ret_sts_error)
3999: THEN
4000: RAISE fnd_api.g_exc_error ;
4001: END IF;
4002:
4003: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4004: THEN

Line 4003: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

3999: THEN
4000: RAISE fnd_api.g_exc_error ;
4001: END IF;
4002:
4003: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4004: THEN
4005: RAISE fnd_api.g_exc_unexpected_error ;
4006: END IF;
4007: RETURN;

Line 4005: RAISE fnd_api.g_exc_unexpected_error ;

4001: END IF;
4002:
4003: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4004: THEN
4005: RAISE fnd_api.g_exc_unexpected_error ;
4006: END IF;
4007: RETURN;
4008: END IF;
4009:

Line 4074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4070: WHEN OTHERS THEN
4071: IF (l_debug = 1) THEN
4072: print_debug('Unexpected error:' || Sqlerrm);
4073: END IF;
4074: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4075: END;
4076: END IF;
4077:
4078: IF l_mmtt_rec.transaction_action_id IN (inv_globals.g_type_cycle_count_adj,

Line 4113: p_init_msg_list => FND_API.G_FALSE,

4109: print_debug('Getting transfer cost group id from rules engine...: ');
4110: END IF;
4111: wms_costgroupengine_pvt.assign_cost_group
4112: (p_api_version => 1.0,
4113: p_init_msg_list => FND_API.G_FALSE,
4114: p_commit => FND_API.G_FALSE,
4115: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4116: x_return_status => x_return_Status,
4117: x_msg_count => x_msg_count,

Line 4114: p_commit => FND_API.G_FALSE,

4110: END IF;
4111: wms_costgroupengine_pvt.assign_cost_group
4112: (p_api_version => 1.0,
4113: p_init_msg_list => FND_API.G_FALSE,
4114: p_commit => FND_API.G_FALSE,
4115: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4116: x_return_status => x_return_Status,
4117: x_msg_count => x_msg_count,
4118: x_msg_data => x_msg_data,

Line 4115: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4111: wms_costgroupengine_pvt.assign_cost_group
4112: (p_api_version => 1.0,
4113: p_init_msg_list => FND_API.G_FALSE,
4114: p_commit => FND_API.G_FALSE,
4115: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4116: x_return_status => x_return_Status,
4117: x_msg_count => x_msg_count,
4118: x_msg_data => x_msg_data,
4119: p_line_id => l_mmtt_rec.transaction_temp_id,

Line 4122: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

4118: x_msg_data => x_msg_data,
4119: p_line_id => l_mmtt_rec.transaction_temp_id,
4120: p_input_type => wms_costgroupengine_pvt.g_input_mmtt);
4121:
4122: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4123: IF (l_debug = 1) THEN
4124: print_debug('return error from wms_costgroupengine_pvt');
4125: END IF;
4126: RAISE FND_API.G_EXC_ERROR;

Line 4126: RAISE FND_API.G_EXC_ERROR;

4122: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4123: IF (l_debug = 1) THEN
4124: print_debug('return error from wms_costgroupengine_pvt');
4125: END IF;
4126: RAISE FND_API.G_EXC_ERROR;
4127: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4128: IF (l_debug = 1) THEN
4129: print_debug('return unexpected error from wms_costgroupengine_pvt');
4130: END IF;

Line 4127: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4123: IF (l_debug = 1) THEN
4124: print_debug('return error from wms_costgroupengine_pvt');
4125: END IF;
4126: RAISE FND_API.G_EXC_ERROR;
4127: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4128: IF (l_debug = 1) THEN
4129: print_debug('return unexpected error from wms_costgroupengine_pvt');
4130: END IF;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4127: ELSIF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4128: IF (l_debug = 1) THEN
4129: print_debug('return unexpected error from wms_costgroupengine_pvt');
4130: END IF;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END IF;
4133:
4134: END IF;
4135: END IF;

Line 4166: IF (x_return_status = fnd_api.g_ret_sts_error)

4162: print_debug('proc_determine_costgroup return : ' || x_return_status);
4163: print_debug('cost_group_id: ' || l_cost_group_id);
4164: END IF;
4165:
4166: IF (x_return_status = fnd_api.g_ret_sts_error)
4167: THEN
4168: RAISE fnd_api.g_exc_error ;
4169: END IF;
4170:

Line 4168: RAISE fnd_api.g_exc_error ;

4164: END IF;
4165:
4166: IF (x_return_status = fnd_api.g_ret_sts_error)
4167: THEN
4168: RAISE fnd_api.g_exc_error ;
4169: END IF;
4170:
4171: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4172: THEN

Line 4171: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4167: THEN
4168: RAISE fnd_api.g_exc_error ;
4169: END IF;
4170:
4171: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4172: THEN
4173: RAISE fnd_api.g_exc_unexpected_error ;
4174: END IF;
4175:

Line 4173: RAISE fnd_api.g_exc_unexpected_error ;

4169: END IF;
4170:
4171: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4172: THEN
4173: RAISE fnd_api.g_exc_unexpected_error ;
4174: END IF;
4175:
4176: proc_update_mmtt(l_mmtt_rec.transaction_temp_id,
4177: p_transfer_wms_org,

Line 4194: IF (x_return_status = fnd_api.g_ret_sts_error)

4190: x_return_status);
4191: IF (l_debug = 1) THEN
4192: print_debug('proc_update_mmtt : ' || x_return_status);
4193: END IF;
4194: IF (x_return_status = fnd_api.g_ret_sts_error)
4195: THEN
4196: RAISE fnd_api.g_exc_error ;
4197: END IF;
4198:

Line 4196: RAISE fnd_api.g_exc_error ;

4192: print_debug('proc_update_mmtt : ' || x_return_status);
4193: END IF;
4194: IF (x_return_status = fnd_api.g_ret_sts_error)
4195: THEN
4196: RAISE fnd_api.g_exc_error ;
4197: END IF;
4198:
4199: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4200: THEN

Line 4199: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4195: THEN
4196: RAISE fnd_api.g_exc_error ;
4197: END IF;
4198:
4199: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4200: THEN
4201: RAISE fnd_api.g_exc_unexpected_error ;
4202: END IF;
4203: END IF; -- If onhand exists

Line 4201: RAISE fnd_api.g_exc_unexpected_error ;

4197: END IF;
4198:
4199: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4200: THEN
4201: RAISE fnd_api.g_exc_unexpected_error ;
4202: END IF;
4203: END IF; -- If onhand exists
4204: ELSE
4205: IF l_is_lot_control THEN

Line 4225: IF (x_return_status = fnd_api.g_ret_sts_error)

4221: x_msg_data => x_msg_data);
4222: IF (l_debug = 1) THEN
4223: print_debug('proc_process_lot_serial: x_return_status: ' || x_return_status);
4224: END IF;
4225: IF (x_return_status = fnd_api.g_ret_sts_error)
4226: THEN
4227: RAISE fnd_api.g_exc_error ;
4228: END IF;
4229:

Line 4227: RAISE fnd_api.g_exc_error ;

4223: print_debug('proc_process_lot_serial: x_return_status: ' || x_return_status);
4224: END IF;
4225: IF (x_return_status = fnd_api.g_ret_sts_error)
4226: THEN
4227: RAISE fnd_api.g_exc_error ;
4228: END IF;
4229:
4230: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4231: THEN

Line 4230: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4226: THEN
4227: RAISE fnd_api.g_exc_error ;
4228: END IF;
4229:
4230: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4231: THEN
4232: RAISE fnd_api.g_exc_unexpected_error ;
4233: END IF;
4234: ELSE

Line 4232: RAISE fnd_api.g_exc_unexpected_error ;

4228: END IF;
4229:
4230: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4231: THEN
4232: RAISE fnd_api.g_exc_unexpected_error ;
4233: END IF;
4234: ELSE
4235: -- Lot controlled
4236: proc_process_lots

Line 4251: IF (x_return_status = fnd_api.g_ret_sts_error)

4247:
4248: IF (l_debug = 1) THEN
4249: print_debug('proc_process_lots return: ' || x_return_status);
4250: END IF;
4251: IF (x_return_status = fnd_api.g_ret_sts_error)
4252: THEN
4253: RAISE fnd_api.g_exc_error ;
4254: END IF;
4255:

Line 4253: RAISE fnd_api.g_exc_error ;

4249: print_debug('proc_process_lots return: ' || x_return_status);
4250: END IF;
4251: IF (x_return_status = fnd_api.g_ret_sts_error)
4252: THEN
4253: RAISE fnd_api.g_exc_error ;
4254: END IF;
4255:
4256: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4257: THEN

Line 4256: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4252: THEN
4253: RAISE fnd_api.g_exc_error ;
4254: END IF;
4255:
4256: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4257: THEN
4258: RAISE fnd_api.g_exc_unexpected_error ;
4259: END IF;
4260: END IF;

Line 4258: RAISE fnd_api.g_exc_unexpected_error ;

4254: END IF;
4255:
4256: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4257: THEN
4258: RAISE fnd_api.g_exc_unexpected_error ;
4259: END IF;
4260: END IF;
4261: ELSE
4262: IF l_is_serial_control THEN

Line 4283: IF (x_return_status = fnd_api.g_ret_sts_error)

4279:
4280: IF (l_debug = 1) THEN
4281: print_debug('proc_process_serials return: ' || x_return_status);
4282: END IF;
4283: IF (x_return_status = fnd_api.g_ret_sts_error)
4284: THEN
4285: RAISE fnd_api.g_exc_error ;
4286: END IF;
4287:

Line 4285: RAISE fnd_api.g_exc_error ;

4281: print_debug('proc_process_serials return: ' || x_return_status);
4282: END IF;
4283: IF (x_return_status = fnd_api.g_ret_sts_error)
4284: THEN
4285: RAISE fnd_api.g_exc_error ;
4286: END IF;
4287:
4288: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4289: THEN

Line 4288: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4284: THEN
4285: RAISE fnd_api.g_exc_error ;
4286: END IF;
4287:
4288: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4289: THEN
4290: RAISE fnd_api.g_exc_unexpected_error ;
4291: END IF;
4292: ELSE

Line 4290: RAISE fnd_api.g_exc_unexpected_error ;

4286: END IF;
4287:
4288: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4289: THEN
4290: RAISE fnd_api.g_exc_unexpected_error ;
4291: END IF;
4292: ELSE
4293: -- No control
4294: IF (l_debug = 1) THEN

Line 4313: IF (x_return_status = fnd_api.g_ret_sts_error)

4309: x_msg_data => x_msg_data);
4310: IF (l_debug = 1) THEN
4311: print_debug('proc_process_nocontrol return : ' || x_return_status);
4312: END IF;
4313: IF (x_return_status = fnd_api.g_ret_sts_error)
4314: THEN
4315: RAISE fnd_api.g_exc_error ;
4316: END IF;
4317:

Line 4315: RAISE fnd_api.g_exc_error ;

4311: print_debug('proc_process_nocontrol return : ' || x_return_status);
4312: END IF;
4313: IF (x_return_status = fnd_api.g_ret_sts_error)
4314: THEN
4315: RAISE fnd_api.g_exc_error ;
4316: END IF;
4317:
4318: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4319: THEN

Line 4318: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)

4314: THEN
4315: RAISE fnd_api.g_exc_error ;
4316: END IF;
4317:
4318: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4319: THEN
4320: RAISE fnd_api.g_exc_unexpected_error ;
4321: END IF;
4322: IF (l_debug = 1) THEN

Line 4320: RAISE fnd_api.g_exc_unexpected_error ;

4316: END IF;
4317:
4318: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4319: THEN
4320: RAISE fnd_api.g_exc_unexpected_error ;
4321: END IF;
4322: IF (l_debug = 1) THEN
4323: print_debug('after call to nocontrol');
4324: END IF;

Line 4333: WHEN FND_API.G_EXC_ERROR THEN

4329: print_debug('Processing Over... ' || x_return_status );
4330: END IF;
4331:
4332: EXCEPTION
4333: WHEN FND_API.G_EXC_ERROR THEN
4334: IF (l_debug = 1) THEN
4335: print_debug('inv_cost_group_update .. EXCEP G_EXC_ERROR : ' );
4336: END IF;
4337: ROLLBACK TO API_updatecostgroups;

Line 4338: x_return_status := FND_API.G_RET_STS_ERROR ;

4334: IF (l_debug = 1) THEN
4335: print_debug('inv_cost_group_update .. EXCEP G_EXC_ERROR : ' );
4336: END IF;
4337: ROLLBACK TO API_updatecostgroups;
4338: x_return_status := FND_API.G_RET_STS_ERROR ;
4339: FND_MSG_PUB.Count_And_Get
4340: (p_encoded => FND_API.G_FALSE,
4341: p_count => x_msg_count,
4342: p_data => x_msg_data);

Line 4340: (p_encoded => FND_API.G_FALSE,

4336: END IF;
4337: ROLLBACK TO API_updatecostgroups;
4338: x_return_status := FND_API.G_RET_STS_ERROR ;
4339: FND_MSG_PUB.Count_And_Get
4340: (p_encoded => FND_API.G_FALSE,
4341: p_count => x_msg_count,
4342: p_data => x_msg_data);
4343: IF (l_debug = 1) THEN
4344: print_debug(' over ');

Line 4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4342: p_data => x_msg_data);
4343: IF (l_debug = 1) THEN
4344: print_debug(' over ');
4345: END IF;
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: IF (l_debug = 1) THEN
4348: print_debug('inv_cost_group_update .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
4349: END IF;
4350: ROLLBACK TO API_updatecostgroups;

Line 4351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4347: IF (l_debug = 1) THEN
4348: print_debug('inv_cost_group_update .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
4349: END IF;
4350: ROLLBACK TO API_updatecostgroups;
4351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4352: FND_MSG_PUB.Count_And_Get
4353: (p_encoded => FND_API.G_FALSE,
4354: p_count => x_msg_count,
4355: p_data => x_msg_data);

Line 4353: (p_encoded => FND_API.G_FALSE,

4349: END IF;
4350: ROLLBACK TO API_updatecostgroups;
4351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4352: FND_MSG_PUB.Count_And_Get
4353: (p_encoded => FND_API.G_FALSE,
4354: p_count => x_msg_count,
4355: p_data => x_msg_data);
4356: IF (l_debug = 1) THEN
4357: print_debug(' over ' );

Line 4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4360: IF (l_debug = 1) THEN
4361: print_debug('inv_cost_group_update .. EXCEP G_EXC_UNEXPECTED_ERROR : ' );
4362: END IF;
4363: ROLLBACK TO API_updatecostgroups;
4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4365: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4366: THEN
4367: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name,
4368: l_api_name );

Line 4371: (p_encoded => FND_API.G_FALSE,

4367: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name,
4368: l_api_name );
4369: END IF;
4370: FND_MSG_PUB.Count_And_Get
4371: (p_encoded => FND_API.G_FALSE,
4372: p_count => x_msg_count,
4373: p_data => x_msg_data);
4374: IF (l_debug = 1) THEN
4375: print_debug(' over ');