DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on INV_MOBILE_HELPER_FUNCTIONS

Line 8: inv_mobile_helper_functions.tracelog

4: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER default 4) IS
5: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6: BEGIN
7:
8: inv_mobile_helper_functions.tracelog
9: (p_err_msg => p_err_msg,
10: p_module => 'WMS_RETURN_SV',
11: p_level => p_level);
12:

Line 976: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

972: print_debug('maintain_move_orders : execution error');
973: END IF;
974:
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
977: WHEN OTHERS THEN
978: IF (l_debug = 1) THEN
979: print_debug('Maintain MO - exception when others at:'||l_progress||': ' || sqlerrm || ':' || sqlcode);
980: END IF;

Line 982: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

978: IF (l_debug = 1) THEN
979: print_debug('Maintain MO - exception when others at:'||l_progress||': ' || sqlerrm || ':' || sqlcode);
980: END IF;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
983: x_msg_data := x_msg_data||sqlerrm;
984: END maintain_move_orders;
985:
986: PROCEDURE PackUnpack_Container

Line 1107: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

1103: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1104: x_return_status := 'E';
1105: IF (l_debug = 1) THEN
1106: print_debug('Errored out...');
1107: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
1108: print_debug(x_msg_data);
1109: END IF;
1110: END IF;
1111:

Line 2216: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

2212: print_debug('txn_complete : execution error');
2213: END IF;
2214:
2215: x_return_status := FND_API.G_RET_STS_ERROR;
2216: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2217: WHEN OTHERS THEN
2218: IF (l_debug = 1) THEN
2219: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);
2220: END IF;

Line 2222: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

2218: IF (l_debug = 1) THEN
2219: print_debug('In exception when others: ' || sqlerrm || ':' || sqlcode);
2220: END IF;
2221: x_return_status := FND_API.G_RET_STS_ERROR;
2222: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2223: x_msg_data := x_msg_data||sqlerrm;
2224: END txn_complete;
2225:
2226: /* This function is called from LOV Cursor procedure 'GET_RETURN_LPN' of

Line 2680: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

2676: print_debug('mark_returns : execution error');
2677: END IF;
2678:
2679: x_return_status := FND_API.G_RET_STS_ERROR;
2680: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2681: when others then
2682: IF (l_debug = 1) THEN
2683: print_debug('Error(' || l_position || '):' || sqlerrm);
2684: END IF;

Line 2686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

2682: IF (l_debug = 1) THEN
2683: print_debug('Error(' || l_position || '):' || sqlerrm);
2684: END IF;
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2687: x_msg_data := x_msg_data||sqlerrm;
2688: END MARK_RETURNS;
2689:
2690: /*

Line 2782: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

2778: l_position := '0040';
2779: print_debug('Error(' || l_position || '):' || sqlerrm);
2780: END IF;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
2783: x_msg_data := x_msg_data||sqlerrm;
2784:
2785: END unmark_returns;
2786:

Line 3042: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3038: l_position := '0040';
3039: print_debug('Error(' || l_position || '):' || sqlerrm);
3040: END IF;
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3043: x_msg_data := x_msg_data||sqlerrm;
3044:
3045: END Create_Update_Containers_RTV;
3046:

Line 3134: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3130: l_position := '0013';
3131: print_debug('Error(' || l_position || '):' || sqlerrm);
3132: END IF;
3133: x_return_status := FND_API.G_RET_STS_ERROR;
3134: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3135: x_msg_data := x_msg_data||sqlerrm;
3136:
3137:
3138:

Line 3294: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3290:
3291: IF (l_return_status = -1) THEN
3292: l_position := '0040';
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3295: END IF;
3296:
3297: IF (l_debug = 1) THEN
3298: print_debug('MMTT insertion done' || p_lpn_id);

Line 3326: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3322: print_debug('Error While inserting lot transaction ' || l_unpack_rec.lot_number);
3323: END IF;
3324: l_position := '0040';
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3327: END IF;
3328:
3329: --Review Comments
3330:

Line 3357: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3353: print_debug('Error occured while inserting Serial transaction ' || l_unpack_rec.lpn_id);
3354: END IF;
3355: l_position := '0040';
3356: x_return_status := FND_API.G_RET_STS_ERROR;
3357: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3358: END IF;
3359: --fnd_message.debug('Created MSNT Successfully.');
3360: IF (l_debug = 1) THEN
3361: print_debug('After inserting MSNT for Serial ' || l_msnt_rec.serial_number);

Line 3373: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3369: l_position := '0040';
3370: print_debug('Error(' || l_position || '):' || sqlerrm);
3371: END IF;
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3374: x_msg_data := x_msg_data||sqlerrm;
3375: END callUnpack;
3376:
3377:

Line 3479: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3475: print_debug('Error occured while processing LPN ' || l_lpn_id);
3476: END IF;
3477: l_position := '0040';
3478: x_return_status := FND_API.G_RET_STS_ERROR;
3479: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3480: END IF;
3481: IF (l_debug = 1) THEN
3482: print_debug('LPN Processed for LPN' || l_lpn_id);
3483: END IF;

Line 3497: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3493: l_position := '0040';
3494: print_debug('Error(' || l_position || '):' || sqlerrm);
3495: END IF;
3496: x_return_status := FND_API.G_RET_STS_ERROR;
3497: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3498: x_msg_data := x_msg_data||sqlerrm;
3499:
3500: END cancel_return_order_RTV;
3501:

Line 3686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3682: print_debug('maintain_move_orders : execution error');
3683: END IF;
3684:
3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3687: when others then
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3690: x_msg_data := x_msg_data||sqlerrm;

Line 3689: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);

3685: x_return_status := FND_API.G_RET_STS_ERROR;
3686: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3687: when others then
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: inv_mobile_helper_functions.get_stacked_messages(x_message => x_msg_data);
3690: x_msg_data := x_msg_data||sqlerrm;
3691: IF (l_debug = 1) THEN
3692: print_debug('Error(' || l_position || '):' || sqlerrm);
3693: END IF;