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 232: fnd_msg_pub.ADD;

228: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
230: fnd_message.set_token('uom2', l_temp_uom_code);
231: fnd_message.set_token('module', 'INSERT_LINE_TRX');
232: fnd_msg_pub.ADD;
233: RAISE fnd_api.g_exc_error;
234: END IF;
235:
236: v_mmtt_rec.primary_quantity := v_mmtt_rec.primary_quantity * l_sign; --Added bug3984746

Line 494: fnd_msg_pub.ADD;

490: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
491: fnd_message.set_token('uom1', curlpnrec.uom);
492: fnd_message.set_token('uom2', l_primary_uom);
493: fnd_message.set_token('module', 'INSERT_LOT_TRX');
494: fnd_msg_pub.ADD;
495: RAISE fnd_api.g_exc_error;
496: END IF;
497:
498: retval :=

Line 518: fnd_msg_pub.ADD;

514: inv_log_util.TRACE('**Error from insertLot :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
515: END IF;
516:
517: fnd_message.set_name('INV', 'INV_FAILED');
518: fnd_msg_pub.ADD;
519: RAISE fnd_api.g_exc_error;
520: END IF;
521:
522: IF (l_debug = 1) THEN

Line 547: fnd_msg_pub.ADD;

543: inv_log_util.TRACE('**Error from insertSerial :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
544: END IF;
545:
546: fnd_message.set_name('INV', 'INV_FAILED');
547: fnd_msg_pub.ADD;
548: RAISE fnd_api.g_exc_error;
549: END IF;
550:
551: IF (l_debug = 1) THEN

Line 575: fnd_msg_pub.ADD;

571: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
572: fnd_message.set_token('uom1', p_uom1);
573: fnd_message.set_token('uom2', p_uom2);
574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
575: fnd_msg_pub.ADD;
576: RAISE fnd_api.g_exc_error;
577: END IF;
578:
579: RETURN l_converted_qty;

Line 704: fnd_msg_pub.ADD;

700:
701: IF ( sql%rowcount = 0 ) THEN
702: fnd_message.set_name('INV', 'INV_NO_RECORDS');
703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
704: fnd_msg_pub.ADD;
705: RAISE fnd_api.g_exc_error;
706: END IF;
707: END IF;
708: ELSIF(p_mmtt.inventory_item_id <> -1) THEN

Line 732: fnd_msg_pub.ADD;

728: inv_log_util.TRACE('No sub found when checking lpn_controlled_flag', 'INV_LPN_TRX_PUB', 5);
729: END IF;
730:
731: fnd_message.set_name('INV', 'INV_INT_XSUBCODE');
732: fnd_msg_pub.ADD;
733: RAISE fnd_api.g_exc_error;
734: END IF;
735:
736: IF (l_debug = 1) THEN

Line 926: fnd_msg_pub.ADD;

922: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
923:
924: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
925: fnd_message.set_token('CG', l_cst_grp);
926: fnd_msg_pub.ADD;
927: RAISE fnd_api.g_exc_error;
928: END IF;
929: END IF;
930:

Line 1041: fnd_msg_pub.ADD;

1037: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
1038:
1039: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1040: fnd_message.set_token('CG', l_cst_grp);
1041: fnd_msg_pub.ADD;
1042: RAISE fnd_api.g_exc_error;
1043: END IF;
1044: END IF;
1045:

Line 1118: fnd_msg_pub.ADD;

1114: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1115: END IF;
1116:
1117: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1118: fnd_msg_pub.ADD;
1119: RAISE fnd_api.g_exc_error;
1120: END IF;
1121: -- If this is for an OrgXfr transaction, update the cost_group_id
1122: -- of the content item for this LPN as this could have been

Line 1284: fnd_msg_pub.ADD;

1280: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1281: END IF;
1282:
1283: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1284: fnd_msg_pub.ADD;
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287: -- If this is for an OrgXfr transaction, update the cost_group_id
1288: -- of the content item for this LPN as this could have been

Line 1348: fnd_msg_pub.ADD;

1344: END IF;
1345:
1346: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1347: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END;
1351:
1352: UPDATE mtl_material_transactions_temp

Line 1405: fnd_msg_pub.ADD;

1401: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1402: END IF;
1403: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1404: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1405: fnd_msg_pub.ADD;
1406: RAISE fnd_api.g_exc_error;
1407: END;
1408: else
1409: BEGIN

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

1432: END IF; -- intransit Rcpt
1433: EXCEPTION
1434: WHEN fnd_api.g_exc_error THEN
1435: x_return_status := fnd_api.g_ret_sts_error;
1436: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1437: WHEN OTHERS THEN
1438: x_return_status := fnd_api.g_ret_sts_unexp_error;
1439: END update_fob_point;
1440:

Line 1576: fnd_msg_pub.ADD;

1572: );
1573: END IF;
1574:
1575: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1576: fnd_msg_pub.ADD;
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579: ELSE
1580: -- We are packing/unpacking an Item. Check for Lot and Serials

Line 1707: fnd_msg_pub.ADD;

1703: );
1704: END IF;
1705:
1706: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1707: fnd_msg_pub.ADD;
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710: END LOOP;
1711:

Line 1773: fnd_msg_pub.ADD;

1769: );
1770: END IF;
1771:
1772: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1773: fnd_msg_pub.ADD;
1774: RAISE fnd_api.g_exc_error;
1775: END IF;
1776: END IF;
1777: END LOOP;

Line 1886: fnd_msg_pub.ADD;

1882: );
1883: END IF;
1884:
1885: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1886: fnd_msg_pub.ADD;
1887: RAISE fnd_api.g_exc_error;
1888: END IF;
1889: END LOOP;
1890:

Line 1952: fnd_msg_pub.ADD;

1948: );
1949: END IF;
1950:
1951: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1952: fnd_msg_pub.ADD;
1953: RAISE fnd_api.g_exc_error;
1954: END IF;
1955: END IF;
1956: END IF;

Line 1995: fnd_msg_pub.ADD;

1991: inv_log_util.TRACE('Error msg :' || ret_msgdata || 'msgcnt=' || ret_msgcnt, 'INV_LPN_TRX_PUB', 1);
1992: END IF;
1993:
1994: fnd_message.set_name('INV', 'INV_LPN_UPDATE_FAILURE');
1995: fnd_msg_pub.ADD;
1996: RAISE fnd_api.g_exc_error;
1997: END IF;
1998: END;
1999:

Line 2468: fnd_msg_pub.ADD;

2464: inv_log_util.TRACE('Failed MTL_SERIAL_CHECK.Inv_Serial_Info', l_api_name, 1);
2465: END IF;
2466:
2467: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2468: fnd_msg_pub.ADD;
2469: RAISE fnd_api.g_exc_error;
2470: END IF;
2471:
2472: -- calculate the length of the serial number suffix

Line 2594: fnd_msg_pub.ADD;

2590: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2591: fnd_message.set_token('uom1', p_uom_code);
2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2593: fnd_message.set_token('module', l_api_name);
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: END IF;
2597: END IF;
2598: ELSE -- Not serial controlled

Line 2614: fnd_msg_pub.ADD;

2610: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2611: fnd_message.set_token('uom1', l_remaining_qty_uom);
2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2613: fnd_message.set_token('module', l_api_name);
2614: fnd_msg_pub.ADD;
2615: RAISE fnd_api.g_exc_error;
2616: END IF;
2617:
2618: l_remaining_qty_uom := dd_rec.requested_quantity_uom;

Line 2637: fnd_msg_pub.ADD;

2633: -- Sanity check to make sure that we are transacting in the same UOM
2634: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2635: fnd_message.set_token('UOM1', p_secondary_uom_code);
2636: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2637: fnd_msg_pub.ADD;
2638: RAISE fnd_api.g_exc_unexpected_error;
2639: ELSE
2640: -- Everything checks out determine the amount of qty2 to split
2641: -- Calculate the theoretical proportionate quantity2 to be split

Line 2698: fnd_msg_pub.ADD;

2694: inv_log_util.TRACE('**Error Delivery_Detail_Action: ' || ret_msgdata, l_api_name, 1);
2695: END IF;
2696:
2697: fnd_message.set_name('INV', 'INV_SPLIT_LINE_FAILURE');
2698: fnd_msg_pub.ADD;
2699: RAISE fnd_api.g_exc_error;
2700: END IF;
2701:
2702: l_shipping_attr(1).delivery_detail_id := l_action_out_rec.result_id_tab(1);

Line 2743: fnd_msg_pub.ADD;

2739: inv_log_util.TRACE('Error WSH_WMS_LPN_GRP.Delivery_Detail_Action' || ret_status, l_api_name, 1);
2740: END IF;
2741:
2742: fnd_message.set_name('INV', 'INV_UNASSIGN_DEL_FAILURE');
2743: fnd_msg_pub.ADD;
2744: RAISE fnd_api.g_exc_error;
2745: ELSIF (l_debug = 1) THEN
2746: inv_log_util.TRACE('Done with call to WSH Create_Update_Containers', l_api_name, 4);
2747: END IF;

Line 2779: fnd_msg_pub.ADD;

2775: inv_log_util.TRACE('***Error in update shipping attribures for split trx', l_api_name, 9);
2776: END IF;
2777:
2778: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
2779: fnd_msg_pub.ADD;
2780: RAISE fnd_api.g_exc_error;
2781: END IF;
2782:
2783: -- Need to also to transfer the item reservation

Line 2815: fnd_msg_pub.ADD;

2811: IF (l_debug = 1) THEN
2812: inv_log_util.TRACE('upd_reservation_pup failed '||ret_msgdata, l_api_name, 1);
2813: END IF;
2814: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;
2817: END IF;
2818: l_progress := 'Done with call to Upd_Reservation_PUP_New';
2819:

Line 2838: fnd_msg_pub.ADD;

2834:
2835: IF (l_remaining_quantity > 0) THEN
2836: inv_log_util.TRACE('***Error while splittng delivery not enough quantity found in wdd', l_api_name, 1);
2837: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
2838: fnd_msg_pub.ADD;
2839: RAISE fnd_api.g_exc_error;
2840: END IF;
2841:
2842: IF (p_secondary_trx_quantity IS NOT NULL) THEN

Line 2896: fnd_msg_pub.ADD;

2892: -- Sanity check to make sure that we are transacting in the same UOM
2893: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2894: fnd_message.set_token('UOM1', p_secondary_uom_code);
2895: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
2896: fnd_msg_pub.ADD;
2897: RAISE fnd_api.g_exc_unexpected_error;
2898: ELSIF(l_dd_rec.picked_quantity2 > qty2_remainder) THEN
2899: -- This WDD record can consume the entire remaining qty. subtract that
2900: -- amount from the line and set remaining to zero

Line 2927: fnd_msg_pub.ADD;

2923:
2924: IF (qty2_remainder <> 0) THEN
2925: inv_log_util.TRACE('***Error while splittng delivery not enough quantity2 found in wdd', l_api_name, 9);
2926: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
2927: fnd_msg_pub.ADD;
2928: RAISE fnd_api.g_exc_error;
2929: END IF;
2930: ELSIF(l_debug = 1) THEN
2931: inv_log_util.TRACE('no WDD rows left in source lpn...ok', l_api_name, 9);

Line 2973: fnd_msg_pub.ADD;

2969: END IF;
2970:
2971: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');
2972: fnd_message.set_token('MSG1', ret_msgdata);
2973: fnd_msg_pub.ADD;
2974: RAISE fnd_api.g_exc_unexpected_error;
2975: END IF;
2976: END IF;
2977: END split_delivery_details;

Line 3031: fnd_msg_pub.ADD;

3027: );
3028:
3029: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3030: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3031: fnd_msg_pub.ADD;
3032: RAISE fnd_api.g_exc_unexpected_error;
3033: END IF;
3034:
3035: -- retrieve corresponding lot numbers

Line 3057: fnd_msg_pub.ADD;

3053: );
3054:
3055: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3056: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3057: fnd_msg_pub.ADD;
3058: RAISE fnd_api.g_exc_unexpected_error;
3059: END IF;
3060:
3061: IF (l_debug = 1) THEN

Line 3172: fnd_msg_pub.ADD;

3168: );
3169:
3170: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3171: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3172: fnd_msg_pub.ADD;
3173: RAISE fnd_api.g_exc_unexpected_error;
3174: END IF;
3175:
3176: IF (l_debug = 1) THEN

Line 3533: fnd_msg_pub.initialize;

3529: IF (p_init_msg_list = TRUE) THEN
3530: IF (l_debug = 1) THEN
3531: inv_log_util.TRACE('Initializing the message list', 'INV_LPN_TRX_PUB', 9);
3532: END IF;
3533: fnd_msg_pub.initialize;
3534: END IF;
3535:
3536:
3537:

Line 3832: fnd_msg_pub.ADD;

3828: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
3829: )
3830: ) THEN
3831: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
3832: fnd_msg_pub.ADD;
3833: RAISE fnd_api.g_exc_error;
3834: END IF;
3835:
3836: -- For new or null transaction groups that are non atomic, create a new savepoint

Line 3966: fnd_msg_pub.ADD;

3962: END IF;
3963:
3964: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
3965: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
3966: fnd_msg_pub.ADD;
3967: RAISE fnd_api.g_exc_error;
3968: END IF;
3969: END IF;
3970: END IF; --(PO pathset J installed)

Line 4026: --fnd_msg_pub.ADD;

4022: END IF;
4023: --Bug 3804314: The message from the cost group API is
4024: --overwritten by INV_COST_GROUP_FAILURE. Commenting the message.
4025: --fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
4026: --fnd_msg_pub.ADD;
4027: RAISE fnd_api.g_exc_error;
4028: END IF;
4029: END IF;
4030:

Line 4045: fnd_msg_pub.ADD;

4041: IF (l_req_id = 0) THEN
4042: -- display error message
4043: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4044: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4045: fnd_msg_pub.ADD;
4046: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4047: RETURN -1;
4048: ELSE
4049: -- display request ID

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

4042: -- display error message
4043: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4044: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4045: fnd_msg_pub.ADD;
4046: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4047: RETURN -1;
4048: ELSE
4049: -- display request ID
4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');

Line 4052: fnd_msg_pub.ADD;

4048: ELSE
4049: -- display request ID
4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4051: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4052: fnd_msg_pub.ADD;
4053: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4054:
4055: IF (l_debug = 1) THEN
4056: inv_log_util.TRACE('Concurrent Req. submitted: ' || l_req_id, 'INV_LPN_TRX_PUB', 9);

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

4049: -- display request ID
4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4051: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4052: fnd_msg_pub.ADD;
4053: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4054:
4055: IF (l_debug = 1) THEN
4056: inv_log_util.TRACE('Concurrent Req. submitted: ' || l_req_id, 'INV_LPN_TRX_PUB', 9);
4057: END IF;

Line 4073: fnd_msg_pub.ADD;

4069: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4070: WHERE transaction_header_id = p_trx_hdr_id;
4071:
4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4073: fnd_msg_pub.ADD;
4074: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4075:
4076: IF fnd_api.to_boolean(p_commit) THEN
4077: COMMIT WORK;

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

4070: WHERE transaction_header_id = p_trx_hdr_id;
4071:
4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4073: fnd_msg_pub.ADD;
4074: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4075:
4076: IF fnd_api.to_boolean(p_commit) THEN
4077: COMMIT WORK;
4078: END IF;

Line 4166: fnd_msg_pub.ADD;

4162: inv_log_util.TRACE(' Failed in EXPLODE_AND_INSERT!!', 'INV_LPN_TRX_PUB', 1);
4163: END IF;
4164:
4165: fnd_message.set_name('INV', 'INV_FAILED');
4166: fnd_msg_pub.ADD;
4167: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4168: RETURN -1;
4169: END IF;
4170:

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

4163: END IF;
4164:
4165: fnd_message.set_name('INV', 'INV_FAILED');
4166: fnd_msg_pub.ADD;
4167: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4168: RETURN -1;
4169: END IF;
4170:
4171: insrowcnt := insrowcnt + expldrowcnt;

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

4222: );
4223: END IF;
4224:
4225: l_current_group_status := fnd_api.g_ret_sts_error;
4226: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4227: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
4228: failedrowcnt := failedrowcnt + 1;
4229:
4230: IF (l_debug = 1) THEN

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

4223: END IF;
4224:
4225: l_current_group_status := fnd_api.g_ret_sts_error;
4226: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4227: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
4228: failedrowcnt := failedrowcnt + 1;
4229:
4230: IF (l_debug = 1) THEN
4231: inv_log_util.TRACE('failedrowcnt=' || failedrowcnt || ' msg=' || x_proc_msg, 'INV_LPN_TRX_PUB', 1);

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

4496: END IF;
4497:
4498: -- If any of the rows in MMTT fail return number of failed rows.
4499: IF (failedrowcnt > 0) THEN
4500: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4501: RETURN -1 * failedrowcnt;
4502: END IF;
4503:
4504: IF fnd_api.to_boolean(p_commit) THEN

Line 4559: fnd_msg_pub.ADD;

4555: inv_log_util.TRACE(' ERROR generated from getErecordIdAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4556: END IF;
4557:
4558: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4559: fnd_msg_pub.ADD;
4560: RAISE fnd_api.g_exc_error;
4561: END IF;
4562:
4563: /* If an eRecord exists, then acknowledge it

Line 4587: fnd_msg_pub.ADD;

4583: inv_log_util.TRACE(' Error from Send ERES ACKNOWLEDGE API:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4584: END IF;
4585:
4586: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4587: fnd_msg_pub.ADD;
4588: RAISE fnd_api.g_exc_error;
4589: END IF;
4590: END IF; /* IF ERECORD ID not NULL */
4591: END IF; /* IF TRANS NOT ERES SUPPORTED */

Line 4620: fnd_msg_pub.ADD;

4616: -- HVERDDIN END OF ERES CHANGES
4617: --
4618:
4619: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');
4620: fnd_msg_pub.ADD;
4621: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4622: RETURN 0;
4623: EXCEPTION
4624: WHEN OTHERS THEN

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

4617: --
4618:
4619: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');
4620: fnd_msg_pub.ADD;
4621: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4622: RETURN 0;
4623: EXCEPTION
4624: WHEN OTHERS THEN
4625: -- rollback to the savepoint

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

4629:
4630: ROLLBACK TO process_lpn_trx;
4631: --bug 2894323 fix made changes to return all the messages in the
4632: --stack in x_proc_msg out variable
4633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => ret_msgcnt, p_data => x_proc_msg);
4634:
4635: IF ret_msgcnt IS NULL THEN
4636: ret_msgcnt := 0;
4637: END IF;

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

4636: ret_msgcnt := 0;
4637: END IF;
4638:
4639: FOR x IN 1 .. ret_msgcnt LOOP
4640: ret_msgdata := SUBSTR(fnd_msg_pub.get(ret_msgcnt - x + 1, 'F'), 0, 200);
4641:
4642: IF (l_debug = 1) THEN
4643: inv_log_util.TRACE(x || ':' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4644: END IF;

Line 4656: fnd_msg_pub.ADD;

4652:
4653: x_proc_msg := SUBSTR(l_err_msg, 1, 170);
4654: -- Update MMTT with error_code
4655: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
4656: fnd_msg_pub.ADD;
4657: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4658:
4659: BEGIN
4660: SELECT 1

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

4653: x_proc_msg := SUBSTR(l_err_msg, 1, 170);
4654: -- Update MMTT with error_code
4655: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
4656: fnd_msg_pub.ADD;
4657: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4658:
4659: BEGIN
4660: SELECT 1
4661: INTO l_is_from_mti

Line 5220: fnd_msg_pub.ADD;

5216: inv_log_util.TRACE('**Error Full unpack for wip issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5217: END IF;
5218:
5219: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5220: fnd_msg_pub.ADD;
5221: RAISE fnd_api.g_exc_error;
5222: END IF;
5223: ELSE
5224: v_lpn.lpn_context := wms_container_pub.lpn_context_stores; --ISSUED OUT

Line 5814: fnd_msg_pub.ADD;

5810: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
5811: END IF;
5812:
5813: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5814: fnd_msg_pub.ADD;
5815: RAISE fnd_api.g_exc_error;
5816: END IF;
5817: END IF;
5818: END IF;

Line 5843: fnd_msg_pub.ADD;

5839: , 'INV_LPN_TRX_PUB', 1);
5840: END IF;
5841:
5842: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
5843: fnd_msg_pub.ADD;
5844: RAISE fnd_api.g_exc_error;
5845: END IF;
5846: END IF;
5847:

Line 5907: fnd_msg_pub.ADD;

5903: inv_log_util.TRACE('Error. Invalid LPN context for Transfer Trx:' || v_lpn_ctx, 'INV_LPN_TRX_PUB', 1);
5904: END IF;
5905:
5906: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
5907: fnd_msg_pub.ADD;
5908: RAISE fnd_api.g_exc_error;
5909: END IF;
5910:
5911: -- An item or LPN is being unpacked from this LPN.

Line 6137: fnd_msg_pub.ADD;

6133: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6134: END IF;
6135:
6136: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6137: fnd_msg_pub.ADD;
6138: RAISE fnd_api.g_exc_error;
6139: END IF;
6140: ELSE
6141: IF ( l_system_task_type = 7 AND

Line 6243: fnd_msg_pub.ADD;

6239: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
6240: END IF;
6241:
6242: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6243: fnd_msg_pub.ADD;
6244: RAISE fnd_api.g_exc_error;
6245: END IF;
6246:
6247: -- For CostGroupTransfer transactions, use the xfr_cost_group_id

Line 6373: fnd_msg_pub.ADD;

6369: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
6370: END IF;
6371:
6372: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6373: fnd_msg_pub.ADD;
6374: RAISE fnd_api.g_exc_error;
6375: END IF;
6376: END IF;
6377:

Line 6427: fnd_msg_pub.ADD;

6423: inv_log_util.TRACE('**Error from transfer_lpn_trx_reservation :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6424: END IF;
6425:
6426: fnd_message.set_name('INV', 'INV_XFR_RSV_FAILURE');
6427: fnd_msg_pub.ADD;
6428: RAISE fnd_api.g_exc_error;
6429: END IF;
6430: END IF;
6431: END IF;

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

6725: END IF;
6726: EXCEPTION
6727: WHEN fnd_api.g_exc_error THEN
6728: x_return_status := fnd_api.g_ret_sts_error;
6729: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
6730:
6731: IF (l_debug = 1) THEN
6732: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
6733: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);

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

6729: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
6730:
6731: IF (l_debug = 1) THEN
6732: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
6733: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);
6734:
6735: FOR i IN 1 .. ret_msgcnt LOOP
6736: l_msgdata := SUBSTR(l_msgdata || ' | ' || SUBSTR(fnd_msg_pub.get(ret_msgcnt - i + 1, 'F'), 0, 200), 1, 2000);
6737: END LOOP;

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

6732: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
6733: fnd_msg_pub.count_and_get(p_count => ret_msgcnt, p_data => ret_msgdata);
6734:
6735: FOR i IN 1 .. ret_msgcnt LOOP
6736: l_msgdata := SUBSTR(l_msgdata || ' | ' || SUBSTR(fnd_msg_pub.get(ret_msgcnt - i + 1, 'F'), 0, 200), 1, 2000);
6737: END LOOP;
6738:
6739: inv_log_util.TRACE('msg: ' || l_msgdata, l_api_name, 1);
6740: END IF;

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

6739: inv_log_util.TRACE('msg: ' || l_msgdata, l_api_name, 1);
6740: END IF;
6741: WHEN OTHERS THEN
6742: x_return_status := fnd_api.g_ret_sts_unexp_error;
6743: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
6744:
6745: IF (l_debug = 1) THEN
6746: inv_log_util.TRACE(l_api_name || ' Unexp err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);
6747: inv_log_util.TRACE('msg=' || x_proc_msg, l_api_name, 1);