213: -- Clearing the quantity cache
214: inv_quantity_tree_pub.clear_quantity_cache;
215:
216: IF (g_debug IS NOT NULL) THEN
217: gme_debug.log_initialize ('MobileCreTxn');
218: END IF;
219:
220: gme_common_pvt.g_user_ident := p_user_id;
221: gme_common_pvt.g_login_id := p_login_id;
273: END IF;
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF g_debug <= gme_debug.g_log_unexpected THEN
278: gme_debug.put_line('When others exception in Create MAterial Txn');
279: END IF;
280: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF g_debug <= gme_debug.g_log_unexpected THEN
278: gme_debug.put_line('When others exception in Create MAterial Txn');
279: END IF;
280: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: x_error_msg := fnd_message.get;
352:
353: BEGIN
354:
355: IF (g_debug IS NOT NULL) THEN
356: gme_debug.log_initialize ('MobileProcessTxn');
357: END IF;
358:
359: gme_common_pvt.g_user_ident := p_user_id;
360: gme_common_pvt.g_login_id := p_login_id;
382: GME_COMMON_PVT.g_transaction_header_id := NULL;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF g_debug <= gme_debug.g_log_unexpected THEN
387: gme_debug.put_line('When others exception in Process_Transactions');
388: END IF;
389: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: IF g_debug <= gme_debug.g_log_unexpected THEN
387: gme_debug.put_line('When others exception in Process_Transactions');
388: END IF;
389: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: x_error_msg := fnd_message.get;
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: IF g_debug <= gme_debug.g_log_unexpected THEN
432: gme_debug.put_line('When others exception in get_prod_count ');
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435:
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: IF g_debug <= gme_debug.g_log_unexpected THEN
432: gme_debug.put_line('When others exception in get_prod_count ');
433: END IF;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435:
436: END get_prod_count;
479:
480: BEGIN
481:
482: IF (g_debug IS NOT NULL) THEN
483: gme_debug.log_initialize ('MobileGetSubLoc');
484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: x_msg_data := ' ';
499: END IF;
500:
501: EXCEPTION
502: WHEN NO_DEF_SUB_LOC THEN
503: IF g_debug <= gme_debug.g_log_unexpected THEN
504: gme_debug.put_line('When NO_DEF_SUB_LOC exception in get_subinv_loc ');
505: END IF;
506: FND_MESSAGE.SET_NAME('GME', 'GME_NO_DEF_SUB_LOC');
507: FND_MESSAGE.SET_TOKEN('BATCH_NO', l_batch_no);
500:
501: EXCEPTION
502: WHEN NO_DEF_SUB_LOC THEN
503: IF g_debug <= gme_debug.g_log_unexpected THEN
504: gme_debug.put_line('When NO_DEF_SUB_LOC exception in get_subinv_loc ');
505: END IF;
506: FND_MESSAGE.SET_NAME('GME', 'GME_NO_DEF_SUB_LOC');
507: FND_MESSAGE.SET_TOKEN('BATCH_NO', l_batch_no);
508: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item);
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: x_msg_data := FND_MESSAGE.GET;
511:
512: WHEN OTHERS THEN
513: IF g_debug <= gme_debug.g_log_unexpected THEN
514: gme_debug.put_line('When others exception in get_subinv_loc ');
515: END IF;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517:
510: x_msg_data := FND_MESSAGE.GET;
511:
512: WHEN OTHERS THEN
513: IF g_debug <= gme_debug.g_log_unexpected THEN
514: gme_debug.put_line('When others exception in get_subinv_loc ');
515: END IF;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517:
518: END get_subinv_loc;