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_LPN_TRX_PUB dependencies on FND_MSG_PUB

Line 123: fnd_msg_pub.ADD;

119: inv_log_util.TRACE('** Function TRANS_ERES_ENABLED - raised when Others', 'INV_LPN_TRX_PUB', 9);
120: END IF;
121:
122: fnd_message.set_name('INV', 'INV_ERES_ENABLED');
123: fnd_msg_pub.ADD;
124: RAISE fnd_api.g_exc_error;
125: RETURN FALSE;
126: END trans_eres_enabled;
127:

Line 162: fnd_msg_pub.ADD;

158: err_code => l_errCode,
159: err_msg => l_errMsg);
160: IF(l_cst_ret <> 1) THEN
161: fnd_message.set_name('BOM', 'CST_SNAPSHOT_FAILED');
162: fnd_msg_pub.ADD;
163: IF (l_debug = 1) THEN
164: inv_log_util.TRACE('INVTRXWB: Error from CSTACOSN.op_snapshot ','INVTRXWB',1);
165: END IF;
166: raise fnd_api.g_exc_unexpected_error;

Line 265: fnd_msg_pub.ADD;

261: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
262: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
263: fnd_message.set_token('uom2', l_temp_uom_code);
264: fnd_message.set_token('module', 'INSERT_LINE_TRX');
265: fnd_msg_pub.ADD;
266: RAISE fnd_api.g_exc_error;
267: END IF;*/
268: --16445970 --Commented the above
269: v_mmtt_rec.primary_quantity := curlpnrec.primary_quantity;

Line 674: fnd_msg_pub.ADD;

670: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
671: fnd_message.set_token('uom1', curlpnrec.uom);
672: fnd_message.set_token('uom2', l_primary_uom);
673: fnd_message.set_token('module', 'INSERT_LOT_TRX');
674: fnd_msg_pub.ADD;
675: RAISE fnd_api.g_exc_error;
676: END IF;*/
677: --16445970 Commented the above conversion of Primary quantity
678: l_primary_qty := curlpnrec.primary_quantity;

Line 707: fnd_msg_pub.ADD;

703: inv_log_util.TRACE('**Error from insertLot :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
704: END IF;
705:
706: fnd_message.set_name('INV', 'INV_FAILED');
707: fnd_msg_pub.ADD;
708: RAISE fnd_api.g_exc_error;
709: END IF;
710:
711: IF (l_debug = 1) THEN

Line 736: fnd_msg_pub.ADD;

732: inv_log_util.TRACE('**Error from insertSerial :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
733: END IF;
734:
735: fnd_message.set_name('INV', 'INV_FAILED');
736: fnd_msg_pub.ADD;
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF (l_debug = 1) THEN

Line 768: fnd_msg_pub.ADD;

764: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
765: fnd_message.set_token('uom1', p_uom1);
766: fnd_message.set_token('uom2', p_uom2);
767: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
768: fnd_msg_pub.ADD;
769: RAISE fnd_api.g_exc_error;
770: END IF;
771:
772: RETURN l_converted_qty;

Line 900: fnd_msg_pub.ADD;

896:
897: IF ( sql%rowcount = 0 ) THEN
898: fnd_message.set_name('INV', 'INV_NO_RECORDS');
899: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
900: fnd_msg_pub.ADD;
901: RAISE fnd_api.g_exc_error;
902: END IF;
903: END IF;
904: ELSIF(p_mmtt.inventory_item_id <> -1) THEN

Line 928: fnd_msg_pub.ADD;

924: inv_log_util.TRACE('No sub found when checking lpn_controlled_flag', 'INV_LPN_TRX_PUB', 5);
925: END IF;
926:
927: fnd_message.set_name('INV', 'INV_INT_XSUBCODE');
928: fnd_msg_pub.ADD;
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:
932: IF (l_debug = 1) THEN

Line 1128: fnd_msg_pub.ADD;

1124: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
1125:
1126: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1127: fnd_message.set_token('CG', l_cst_grp);
1128: fnd_msg_pub.ADD;
1129: RAISE fnd_api.g_exc_error;
1130: END IF;
1131: END IF;
1132:

Line 1246: fnd_msg_pub.ADD;

1242: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
1243:
1244: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1245: fnd_message.set_token('CG', l_cst_grp);
1246: fnd_msg_pub.ADD;
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249: END IF;
1250:

Line 1326: fnd_msg_pub.ADD;

1322: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1323: END IF;
1324:
1325: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1326: fnd_msg_pub.ADD;
1327: RAISE fnd_api.g_exc_error;
1328: END IF;
1329: -- If this is for an OrgXfr transaction, update the cost_group_id
1330: -- of the content item for this LPN as this could have been

Line 1501: fnd_msg_pub.ADD;

1497: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1498: END IF;
1499:
1500: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1501: fnd_msg_pub.ADD;
1502: RAISE fnd_api.g_exc_error;
1503: END IF;
1504: -- If this is for an OrgXfr transaction, update the cost_group_id
1505: -- of the content item for this LPN as this could have been

Line 1565: fnd_msg_pub.ADD;

1561: END IF;
1562:
1563: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1564: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1565: fnd_msg_pub.ADD;
1566: RAISE fnd_api.g_exc_error;
1567: END;
1568:
1569: UPDATE mtl_material_transactions_temp

Line 1622: fnd_msg_pub.ADD;

1618: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1619: END IF;
1620: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1621: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1622: fnd_msg_pub.ADD;
1623: RAISE fnd_api.g_exc_error;
1624: END;
1625: else
1626: BEGIN

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

1649: END IF; -- intransit Rcpt
1650: EXCEPTION
1651: WHEN fnd_api.g_exc_error THEN
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;
1656: END update_fob_point;
1657:

Line 1793: fnd_msg_pub.ADD;

1789: );
1790: END IF;
1791:
1792: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: END IF;
1796: ELSE
1797: -- We are packing/unpacking an Item. Check for Lot and Serials

Line 1924: fnd_msg_pub.ADD;

1920: );
1921: END IF;
1922:
1923: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1924: fnd_msg_pub.ADD;
1925: RAISE fnd_api.g_exc_error;
1926: END IF;
1927: END LOOP;
1928:

Line 1990: fnd_msg_pub.ADD;

1986: );
1987: END IF;
1988:
1989: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1990: fnd_msg_pub.ADD;
1991: RAISE fnd_api.g_exc_error;
1992: END IF;
1993: END IF;
1994: END LOOP;

Line 2103: fnd_msg_pub.ADD;

2099: );
2100: END IF;
2101:
2102: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
2103: fnd_msg_pub.ADD;
2104: RAISE fnd_api.g_exc_error;
2105: END IF;
2106: END LOOP;
2107:

Line 2169: fnd_msg_pub.ADD;

2165: );
2166: END IF;
2167:
2168: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_error;
2171: END IF;
2172: END IF;
2173: END IF;

Line 2212: fnd_msg_pub.ADD;

2208: inv_log_util.TRACE('Error msg :' || ret_msgdata || 'msgcnt=' || ret_msgcnt, 'INV_LPN_TRX_PUB', 1);
2209: END IF;
2210:
2211: fnd_message.set_name('INV', 'INV_LPN_UPDATE_FAILURE');
2212: fnd_msg_pub.ADD;
2213: RAISE fnd_api.g_exc_error;
2214: END IF;
2215: END;
2216:

Line 2693: fnd_msg_pub.ADD;

2689: inv_log_util.TRACE('Failed MTL_SERIAL_CHECK.Inv_Serial_Info', l_api_name, 1);
2690: END IF;
2691:
2692: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2693: fnd_msg_pub.ADD;
2694: RAISE fnd_api.g_exc_error;
2695: END IF;
2696:
2697: -- calculate the length of the serial number suffix

Line 2823: fnd_msg_pub.ADD;

2819: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2820: fnd_message.set_token('uom1', p_uom_code);
2821: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2822: fnd_message.set_token('module', l_api_name);
2823: fnd_msg_pub.ADD;
2824: RAISE fnd_api.g_exc_error;
2825: END IF;
2826: END IF;
2827: ELSE -- Not serial controlled

Line 2844: fnd_msg_pub.ADD;

2840: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2841: fnd_message.set_token('uom1', l_remaining_qty_uom);
2842: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2843: fnd_message.set_token('module', l_api_name);
2844: fnd_msg_pub.ADD;
2845: RAISE fnd_api.g_exc_error;
2846: END IF;
2847:
2848: l_remaining_qty_uom := dd_rec.requested_quantity_uom;

Line 2880: fnd_msg_pub.ADD;

2876: -- Sanity check to make sure that we are transacting in the same UOM
2877: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2878: fnd_message.set_token('UOM1', p_secondary_uom_code);
2879: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSE
2883: -- Everything checks out determine the amount of qty2 to split
2884: -- Calculate the theoretical proportionate quantity2 to be split

Line 2941: fnd_msg_pub.ADD;

2937: inv_log_util.TRACE('**Error Delivery_Detail_Action: ' || ret_msgdata, l_api_name, 1);
2938: END IF;
2939:
2940: fnd_message.set_name('INV', 'INV_SPLIT_LINE_FAILURE');
2941: fnd_msg_pub.ADD;
2942: RAISE fnd_api.g_exc_error;
2943: END IF;
2944:
2945: l_shipping_attr(1).delivery_detail_id := l_action_out_rec.result_id_tab(1);

Line 2986: fnd_msg_pub.ADD;

2982: inv_log_util.TRACE('Error WSH_WMS_LPN_GRP.Delivery_Detail_Action' || ret_status, l_api_name, 1);
2983: END IF;
2984:
2985: fnd_message.set_name('INV', 'INV_UNASSIGN_DEL_FAILURE');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_error;
2988: ELSIF (l_debug = 1) THEN
2989: inv_log_util.TRACE('Done with call to WSH Create_Update_Containers', l_api_name, 4);
2990: END IF;

Line 3022: fnd_msg_pub.ADD;

3018: inv_log_util.TRACE('***Error in update shipping attribures for split trx', l_api_name, 9);
3019: END IF;
3020:
3021: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
3022: fnd_msg_pub.ADD;
3023: RAISE fnd_api.g_exc_error;
3024: END IF;
3025:
3026: -- Need to also to transfer the item reservation

Line 3077: fnd_msg_pub.ADD;

3073: IF (l_debug = 1) THEN
3074: inv_log_util.TRACE('upd_reservation_pup failed '||ret_msgdata, l_api_name, 1);
3075: END IF;
3076: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');
3077: fnd_msg_pub.ADD;
3078: RAISE fnd_api.g_exc_error;
3079: END IF;
3080: l_progress := 'Done with call to Upd_Reservation_PUP_New';
3081:

Line 3100: fnd_msg_pub.ADD;

3096:
3097: IF (l_remaining_quantity > 0) THEN
3098: inv_log_util.TRACE('***Error while splittng delivery not enough quantity found in wdd', l_api_name, 1);
3099: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
3100: fnd_msg_pub.ADD;
3101: RAISE fnd_api.g_exc_error;
3102: END IF;
3103:
3104: IF (p_secondary_trx_quantity IS NOT NULL) THEN

Line 3158: fnd_msg_pub.ADD;

3154: -- Sanity check to make sure that we are transacting in the same UOM
3155: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
3156: fnd_message.set_token('UOM1', p_secondary_uom_code);
3157: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
3158: fnd_msg_pub.ADD;
3159: RAISE fnd_api.g_exc_unexpected_error;
3160: ELSIF(l_dd_rec.picked_quantity2 > qty2_remainder) THEN
3161: -- This WDD record can consume the entire remaining qty. subtract that
3162: -- amount from the line and set remaining to zero

Line 3189: fnd_msg_pub.ADD;

3185:
3186: IF (qty2_remainder <> 0) THEN
3187: inv_log_util.TRACE('***Error while splittng delivery not enough quantity2 found in wdd', l_api_name, 9);
3188: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
3189: fnd_msg_pub.ADD;
3190: RAISE fnd_api.g_exc_error;
3191: END IF;
3192: ELSIF(l_debug = 1) THEN
3193: inv_log_util.TRACE('no WDD rows left in source lpn...ok', l_api_name, 9);

Line 3235: fnd_msg_pub.ADD;

3231: END IF;
3232:
3233: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');
3234: fnd_message.set_token('MSG1', ret_msgdata);
3235: fnd_msg_pub.ADD;
3236: RAISE fnd_api.g_exc_unexpected_error;
3237: END IF;
3238: END IF;
3239: END split_delivery_details;

Line 3294: fnd_msg_pub.ADD;

3290: );
3291:
3292: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3293: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3294: fnd_msg_pub.ADD;
3295: RAISE fnd_api.g_exc_unexpected_error;
3296: END IF;
3297:
3298: -- 16493898 start

Line 3329: fnd_msg_pub.ADD;

3325: );
3326:
3327: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3328: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: END IF;
3332:
3333: IF (l_debug = 1) THEN

Line 3447: fnd_msg_pub.ADD;

3443: );
3444:
3445: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3446: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3447: fnd_msg_pub.ADD;
3448: RAISE fnd_api.g_exc_unexpected_error;
3449: END IF;
3450:
3451: IF (l_debug = 1) THEN

Line 3820: fnd_msg_pub.initialize;

3816: IF (p_init_msg_list = TRUE) THEN
3817: IF (l_debug = 1) THEN
3818: inv_log_util.TRACE('Initializing the message list', 'INV_LPN_TRX_PUB', 9);
3819: END IF;
3820: fnd_msg_pub.initialize;
3821: END IF;
3822:
3823:
3824:

Line 4119: fnd_msg_pub.ADD;

4115: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
4116: )
4117: ) THEN
4118: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
4119: fnd_msg_pub.ADD;
4120: RAISE fnd_api.g_exc_error;
4121: END IF;
4122:
4123: -- For new or null transaction groups that are non atomic, create a new savepoint

Line 4253: fnd_msg_pub.ADD;

4249: END IF;
4250:
4251: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
4252: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
4253: fnd_msg_pub.ADD;
4254: RAISE fnd_api.g_exc_error;
4255: END IF;
4256: END IF;
4257: END IF; --(PO pathset J installed)

Line 4323: --fnd_msg_pub.ADD;

4319: END IF;
4320: --Bug 3804314: The message from the cost group API is
4321: --overwritten by INV_COST_GROUP_FAILURE. Commenting the message.
4322: --fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
4323: --fnd_msg_pub.ADD;
4324: RAISE fnd_api.g_exc_error;
4325: END IF;
4326: END IF;
4327:

Line 4342: fnd_msg_pub.ADD;

4338: IF (l_req_id = 0) THEN
4339: -- display error message
4340: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4341: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4342: fnd_msg_pub.ADD;
4343: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4344: RETURN -1;
4345: ELSE
4346: -- display request ID

Line 4343: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4339: -- display error message
4340: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4341: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4342: fnd_msg_pub.ADD;
4343: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4344: RETURN -1;
4345: ELSE
4346: -- display request ID
4347: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');

Line 4349: fnd_msg_pub.ADD;

4345: ELSE
4346: -- display request ID
4347: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4348: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4349: fnd_msg_pub.ADD;
4350: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4351:
4352: IF (l_debug = 1) THEN
4353: inv_log_util.TRACE('Concurrent Req. submitted: ' || l_req_id, 'INV_LPN_TRX_PUB', 9);

Line 4350: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4346: -- display request ID
4347: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4348: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4349: fnd_msg_pub.ADD;
4350: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4351:
4352: IF (l_debug = 1) THEN
4353: inv_log_util.TRACE('Concurrent Req. submitted: ' || l_req_id, 'INV_LPN_TRX_PUB', 9);
4354: END IF;

Line 4370: fnd_msg_pub.ADD;

4366: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4367: WHERE transaction_header_id = p_trx_hdr_id;
4368:
4369: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4370: fnd_msg_pub.ADD;
4371: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4372:
4373: IF fnd_api.to_boolean(p_commit) THEN
4374: COMMIT WORK;

Line 4371: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4367: WHERE transaction_header_id = p_trx_hdr_id;
4368:
4369: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4370: fnd_msg_pub.ADD;
4371: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4372:
4373: IF fnd_api.to_boolean(p_commit) THEN
4374: COMMIT WORK;
4375: END IF;

Line 4487: fnd_msg_pub.ADD;

4483: inv_log_util.TRACE(' Failed in EXPLODE_AND_INSERT!!', 'INV_LPN_TRX_PUB', 1);
4484: END IF;
4485:
4486: fnd_message.set_name('INV', 'INV_FAILED');
4487: fnd_msg_pub.ADD;
4488: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4489: RETURN -1;
4490: END IF;
4491:

Line 4488: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4484: END IF;
4485:
4486: fnd_message.set_name('INV', 'INV_FAILED');
4487: fnd_msg_pub.ADD;
4488: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4489: RETURN -1;
4490: END IF;
4491:
4492: insrowcnt := insrowcnt + expldrowcnt;

Line 4549: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4545: );
4546: END IF;
4547:
4548: l_current_group_status := fnd_api.g_ret_sts_error;
4549: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4550: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
4551: failedrowcnt := failedrowcnt + 1;
4552:
4553: IF (l_debug = 1) THEN

Line 4550: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');

4546: END IF;
4547:
4548: l_current_group_status := fnd_api.g_ret_sts_error;
4549: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4550: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
4551: failedrowcnt := failedrowcnt + 1;
4552:
4553: IF (l_debug = 1) THEN
4554: inv_log_util.TRACE('failedrowcnt=' || failedrowcnt || ' msg=' || x_proc_msg, 'INV_LPN_TRX_PUB', 1);

Line 4763: fnd_msg_pub.ADD;

4759: IF (l_debug = 1) THEN
4760: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for locator_id'||v_mmtt.locator_id, 'INV_LPN_TRX_PUB', 9);
4761: END IF;
4762: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4763: fnd_msg_pub.ADD;
4764: RAISE fnd_api.g_exc_error;
4765: END IF;
4766: END IF;
4767: --for move order/direct org xfer/sub xfer,we need also check the transfer location

Line 4779: fnd_msg_pub.ADD;

4775: IF (l_debug = 1) THEN
4776: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4777: END IF;
4778: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4779: fnd_msg_pub.ADD;
4780: RAISE fnd_api.g_exc_error;
4781: END IF;
4782: END IF;
4783: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=2) THEN --sub xfer

Line 4794: fnd_msg_pub.ADD;

4790: IF (l_debug = 1) THEN
4791: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4792: END IF;
4793: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4794: fnd_msg_pub.ADD;
4795: RAISE fnd_api.g_exc_error;
4796: END IF;
4797: END IF;
4798: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=3)THEN --org direct xfer

Line 4818: fnd_msg_pub.ADD;

4814: IF (l_debug = 1) THEN
4815: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4816: END IF;
4817: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4818: fnd_msg_pub.ADD;
4819: RAISE fnd_api.g_exc_error;
4820: END IF;
4821: END IF;
4822: END IF;

Line 4925: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

4921: END IF;
4922:
4923: -- If any of the rows in MMTT fail return number of failed rows.
4924: IF (failedrowcnt > 0) THEN
4925: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4926: RETURN -1 * failedrowcnt;
4927: END IF;
4928:
4929: IF fnd_api.to_boolean(p_commit) THEN

Line 4984: fnd_msg_pub.ADD;

4980: inv_log_util.TRACE(' ERROR generated from getErecordIdAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4981: END IF;
4982:
4983: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4984: fnd_msg_pub.ADD;
4985: RAISE fnd_api.g_exc_error;
4986: END IF;
4987:
4988: /* If an eRecord exists, then acknowledge it

Line 5012: fnd_msg_pub.ADD;

5008: inv_log_util.TRACE(' Error from Send ERES ACKNOWLEDGE API:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
5009: END IF;
5010:
5011: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
5012: fnd_msg_pub.ADD;
5013: RAISE fnd_api.g_exc_error;
5014: END IF;
5015: END IF; /* IF ERECORD ID not NULL */
5016: END IF; /* IF TRANS NOT ERES SUPPORTED */

Line 5120: fnd_msg_pub.ADD;

5116: -- HVERDDIN END OF ERES CHANGES
5117: --
5118:
5119: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');
5120: fnd_msg_pub.ADD;
5121: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
5122: RETURN 0;
5123: EXCEPTION
5124: WHEN OTHERS THEN

Line 5121: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

5117: --
5118:
5119: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');
5120: fnd_msg_pub.ADD;
5121: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
5122: RETURN 0;
5123: EXCEPTION
5124: WHEN OTHERS THEN
5125: -- rollback to the savepoint

Line 5133: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => ret_msgcnt, p_data => x_proc_msg);

5129:
5130: ROLLBACK TO process_lpn_trx;
5131: --bug 2894323 fix made changes to return all the messages in the
5132: --stack in x_proc_msg out variable
5133: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => ret_msgcnt, p_data => x_proc_msg);
5134:
5135: IF ret_msgcnt IS NULL THEN
5136: ret_msgcnt := 0;
5137: END IF;

Line 5140: ret_msgdata := SUBSTR(fnd_msg_pub.get(ret_msgcnt - x + 1, 'F'), 0, 200);

5136: ret_msgcnt := 0;
5137: END IF;
5138:
5139: FOR x IN 1 .. ret_msgcnt LOOP
5140: ret_msgdata := SUBSTR(fnd_msg_pub.get(ret_msgcnt - x + 1, 'F'), 0, 200);
5141:
5142: IF (l_debug = 1) THEN
5143: inv_log_util.TRACE(x || ':' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
5144: END IF;

Line 5156: fnd_msg_pub.ADD;

5152:
5153: x_proc_msg := SUBSTR(l_err_msg, 1, 170);
5154: -- Update MMTT with error_code
5155: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
5156: fnd_msg_pub.ADD;
5157: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
5158:
5159: BEGIN
5160: SELECT 1

Line 5157: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');

5153: x_proc_msg := SUBSTR(l_err_msg, 1, 170);
5154: -- Update MMTT with error_code
5155: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
5156: fnd_msg_pub.ADD;
5157: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
5158:
5159: BEGIN
5160: SELECT 1
5161: INTO l_is_from_mti

Line 5815: fnd_msg_pub.ADD;

5811: inv_log_util.TRACE('**Error Full unpack for wip issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5812: END IF;
5813:
5814: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5815: fnd_msg_pub.ADD;
5816: RAISE fnd_api.g_exc_error;
5817: END IF;
5818: --13884722
5819: ELSIF(p_transaction_action_id = inv_globals.g_action_issue

Line 5852: fnd_msg_pub.ADD;

5848: inv_log_util.TRACE('**Error During unpacking Content LPN for MO issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5849: END IF;
5850:
5851: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5852: fnd_msg_pub.ADD;
5853: RAISE fnd_api.g_exc_error;
5854: END IF;
5855: --13884722
5856: ELSE

Line 6562: fnd_msg_pub.ADD;

6558: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6559: END IF;
6560:
6561: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6562: fnd_msg_pub.ADD;
6563: RAISE fnd_api.g_exc_error;
6564: END IF;
6565: END IF;
6566: END IF;

Line 6591: fnd_msg_pub.ADD;

6587: , 'INV_LPN_TRX_PUB', 1);
6588: END IF;
6589:
6590: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
6591: fnd_msg_pub.ADD;
6592: RAISE fnd_api.g_exc_error;
6593: END IF;
6594: END IF;
6595:

Line 6671: fnd_msg_pub.ADD;

6667: inv_log_util.TRACE('Error. Invalid LPN context for Transfer Trx:' || v_lpn_ctx, 'INV_LPN_TRX_PUB', 1);
6668: END IF;
6669:
6670: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6671: fnd_msg_pub.ADD;
6672: RAISE fnd_api.g_exc_error;
6673: END IF;
6674:
6675: -- An item or LPN is being unpacked from this LPN.

Line 6958: fnd_msg_pub.ADD;

6954: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6955: END IF;
6956:
6957: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6958: fnd_msg_pub.ADD;
6959: RAISE fnd_api.g_exc_error;
6960: END IF;
6961: ELSE
6962: IF ( l_system_task_type = 7 AND

Line 7066: fnd_msg_pub.ADD;

7062: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
7063: END IF;
7064:
7065: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
7066: fnd_msg_pub.ADD;
7067: RAISE fnd_api.g_exc_error;
7068: END IF;
7069:
7070: IF (l_debug = 1) THEN

Line 7230: fnd_msg_pub.ADD;

7226: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
7227: END IF;
7228:
7229: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
7230: fnd_msg_pub.ADD;
7231: RAISE fnd_api.g_exc_error;
7232: END IF;
7233: END IF;
7234:

Line 7268: fnd_msg_pub.ADD;

7264: inv_log_util.TRACE('****Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7265: END IF;
7266:
7267: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
7268: fnd_msg_pub.ADD;
7269: RAISE fnd_api.g_exc_error;
7270: END IF;
7271: ELSE
7272: IF (l_debug = 1) THEN

Line 7322: fnd_msg_pub.ADD;

7318: inv_log_util.TRACE('**Error from transfer_lpn_trx_reservation :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7319: END IF;
7320:
7321: fnd_message.set_name('INV', 'INV_XFR_RSV_FAILURE');
7322: fnd_msg_pub.ADD;
7323: RAISE fnd_api.g_exc_error;
7324: END IF;
7325: END IF;
7326: END IF;

Line 7455: fnd_msg_pub.ADD;

7451: RAISE fnd_api.g_exc_error;
7452: END IF;
7453: ELSE
7454: fnd_message.set_name('WMS','WMS_INVALID_PACK_DELIVERY');
7455: fnd_msg_pub.ADD;
7456: RAISE fnd_api.g_exc_error;
7457: END IF;
7458: END;
7459:

Line 7691: fnd_msg_pub.ADD;

7687: IF (l_debug = 1) THEN
7688: inv_log_util.TRACE(l_api_name||' : '||p_organization_id||' is an invalid organization id', 'INV_LPN_TRX_PUB', 1);
7689: END IF;
7690: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
7691: fnd_msg_pub.ADD;
7692: RAISE fnd_api.g_exc_error;
7693: END IF;
7694:
7695: IF NVL(inv_cache.org_rec.PROCESS_ENABLED_FLAG,'N') = 'Y' then

Line 7811: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');

7807: END IF;
7808: EXCEPTION
7809: WHEN fnd_api.g_exc_error THEN
7810: x_return_status := fnd_api.g_ret_sts_error;
7811: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7812:
7813: IF (l_debug = 1) THEN
7814: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
7815: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);

Line 7815: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);

7811: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7812:
7813: IF (l_debug = 1) THEN
7814: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
7815: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);
7816:
7817: FOR i IN 1 .. ret_msgcnt LOOP
7818: l_msgdata := SUBSTR(l_msgdata || ' | ' || SUBSTR(fnd_msg_pub.get(ret_msgcnt - i + 1, 'F'), 0, 200), 1, 2000);
7819: END LOOP;

Line 7818: l_msgdata := SUBSTR(l_msgdata || ' | ' || SUBSTR(fnd_msg_pub.get(ret_msgcnt - i + 1, 'F'), 0, 200), 1, 2000);

7814: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
7815: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);
7816:
7817: FOR i IN 1 .. ret_msgcnt LOOP
7818: l_msgdata := SUBSTR(l_msgdata || ' | ' || SUBSTR(fnd_msg_pub.get(ret_msgcnt - i + 1, 'F'), 0, 200), 1, 2000);
7819: END LOOP;
7820:
7821: inv_log_util.TRACE('msg: ' || l_msgdata, l_api_name, 1);
7822: END IF;

Line 7825: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');

7821: inv_log_util.TRACE('msg: ' || l_msgdata, l_api_name, 1);
7822: END IF;
7823: WHEN OTHERS THEN
7824: x_return_status := fnd_api.g_ret_sts_unexp_error;
7825: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7826:
7827: IF (l_debug = 1) THEN
7828: inv_log_util.TRACE(l_api_name || ' Unexp err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
7829: inv_log_util.TRACE('msg=' || x_proc_msg, l_api_name, 1);