DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on FND_MSG_PUB

Line 39: l_msg_count := fnd_msg_pub.count_msg;

35: l_msg_name VARCHAR2(50);
36: BEGIN
37: debug('Entered procedure','process_mobile_msg');
38:
39: l_msg_count := fnd_msg_pub.count_msg;
40: debug('Msg Count: ' || l_msg_count,'process_mobile_msg');
41:
42: FOR i IN 1..l_msg_count LOOP
43: fnd_msg_pub.get(p_msg_index => i,

Line 43: fnd_msg_pub.get(p_msg_index => i,

39: l_msg_count := fnd_msg_pub.count_msg;
40: debug('Msg Count: ' || l_msg_count,'process_mobile_msg');
41:
42: FOR i IN 1..l_msg_count LOOP
43: fnd_msg_pub.get(p_msg_index => i,
44: p_data => l_msg_data,
45: p_msg_index_out => l_dummy_number);
46:
47: debug('i: ' || i || ' index_out: ' || l_dummy_number || ' encoded_data: ' || l_msg_data,'process_mobile_msg');

Line 56: fnd_msg_pub.delete_msg(p_msg_index=>i);

52:
53: debug('App_short_name: ' || l_app_short_name || ' Msg_name: ' || l_msg_name,'process_mobile_msg');
54:
55: IF (l_msg_name <> 'WSH_DET_INV_INT_SUBMITTED') THEN
56: fnd_msg_pub.delete_msg(p_msg_index=>i);
57: debug('Deleted message at position: ' || i,'process_mobile_msg');
58: END IF;
59: END LOOP;
60: EXCEPTION

Line 2014: fnd_msg_pub.count_and_get(p_count => l_msg_count,

2010: EXCEPTION
2011: WHEN fnd_api.g_exc_unexpected_error THEN
2012: --if keep current structure of returning error_code
2013: --no need to get message from stack as java side does it
2014: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2015: p_data => l_msg_data);
2016: IF l_debug = 1 THEN
2017: debug('LPN_SUBMIT raised unexpected error','LPN_SUBMIT');
2018: debug('msg_stack: ' || l_msg_data,'LPN_SUBMIT');

Line 3740: FND_MSG_PUB.ADD;

3736: print_label(l_del_rows, l_return_status);
3737: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3738: debug('print_label failed','ship_confirm_all');
3739: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
3740: FND_MSG_PUB.ADD;
3741: x_return_status := 'W';
3742: END IF;
3743: end if;
3744:

Line 3746: x_msg_count := fnd_msg_pub.count_msg;

3742: END IF;
3743: end if;
3744:
3745: process_mobile_msg;
3746: x_msg_count := fnd_msg_pub.count_msg;
3747: x_msg_data := '';
3748: FOR i IN 1..x_msg_count LOOP
3749: fnd_msg_pub.get(p_encoded=>'F'
3750: ,p_msg_index => i

Line 3749: fnd_msg_pub.get(p_encoded=>'F'

3745: process_mobile_msg;
3746: x_msg_count := fnd_msg_pub.count_msg;
3747: x_msg_data := '';
3748: FOR i IN 1..x_msg_count LOOP
3749: fnd_msg_pub.get(p_encoded=>'F'
3750: ,p_msg_index => i
3751: ,p_data => l_msg_data
3752: ,p_msg_index_out => l_dummy_number);
3753: x_msg_data := x_msg_data || l_msg_data;

Line 3764: x_msg_count := FND_MSG_PUB.Count_msg;

3760: ROLLBACK;
3761: x_return_status := l_return_status;
3762:
3763: --DHERRING Bug#5651219. Fix starts
3764: x_msg_count := FND_MSG_PUB.Count_msg;
3765: FOR i in 1..x_msg_count LOOP
3766: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
3767: p_msg_index_out => l_tmp_out);
3768: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;

Line 3766: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,

3762:
3763: --DHERRING Bug#5651219. Fix starts
3764: x_msg_count := FND_MSG_PUB.Count_msg;
3765: FOR i in 1..x_msg_count LOOP
3766: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
3767: p_msg_index_out => l_tmp_out);
3768: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;
3769: END LOOP;
3770:

Line 4233: FND_MSG_PUB.ADD;

4229: print_label(l_del_rows, l_return_status);
4230: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4231: debug('print_label failed','ship_confirm_lpn_deliveries');
4232: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4233: FND_MSG_PUB.ADD;
4234: l_num_warnings := l_num_warnings + 1;
4235: END IF;
4236: ELSE --corresponding if - p_verify_only = 'Y'
4237: if p_trip_stop_id =0 then

Line 4339: FND_MSG_PUB.ADD;

4335: print_label(l_del_rows, l_return_status);
4336: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4337: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4338: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4339: FND_MSG_PUB.ADD;
4340:
4341: l_num_warnings := l_num_warnings + 1;
4342: END IF;
4343:

Line 4581: FND_MSG_PUB.ADD;

4577: print_label(l_del_rows, l_return_status);
4578: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4579: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4580: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4581: FND_MSG_PUB.ADD;
4582:
4583: l_num_warnings := l_num_warnings + 1;
4584: END IF;
4585:

Line 4805: FND_MSG_PUB.ADD;

4801: print_label(l_del_rows, l_return_status);
4802: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4803: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4804: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4805: FND_MSG_PUB.ADD;
4806:
4807: l_num_warnings := l_num_warnings + 1;
4808: END IF;
4809: end if; -- p_trip_id <> 0

Line 4819: x_msg_count := fnd_msg_pub.count_msg;

4815: x_return_status := 'W';
4816: END IF;
4817:
4818: process_mobile_msg;
4819: x_msg_count := fnd_msg_pub.count_msg;
4820: x_msg_data := '';
4821: FOR i IN 1..x_msg_count LOOP
4822: fnd_msg_pub.get(p_encoded=>'F'
4823: ,p_msg_index => i

Line 4822: fnd_msg_pub.get(p_encoded=>'F'

4818: process_mobile_msg;
4819: x_msg_count := fnd_msg_pub.count_msg;
4820: x_msg_data := '';
4821: FOR i IN 1..x_msg_count LOOP
4822: fnd_msg_pub.get(p_encoded=>'F'
4823: ,p_msg_index => i
4824: ,p_data => l_msg_data
4825: ,p_msg_index_out => l_dummy_number);
4826: IF (l_debug = 1) THEN

Line 4842: x_msg_count := FND_MSG_PUB.Count_msg;

4838: debug('Unexpected error raised: ' || SQLERRM, 'SHIP_CONFIRM_LPN_DELIVERIES');
4839: x_return_status := l_return_status;
4840:
4841: --DHERRING Bug#5651219. Fix starts
4842: x_msg_count := FND_MSG_PUB.Count_msg;
4843: FOR i in 1..x_msg_count LOOP
4844: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
4845: p_msg_index_out => l_tmp_out);
4846: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;

Line 4844: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,

4840:
4841: --DHERRING Bug#5651219. Fix starts
4842: x_msg_count := FND_MSG_PUB.Count_msg;
4843: FOR i in 1..x_msg_count LOOP
4844: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
4845: p_msg_index_out => l_tmp_out);
4846: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;
4847: END LOOP;
4848:

Line 5278: FND_MSG_PUB.ADD;

5274: IF (l_debug = 1) THEN
5275: debug('Error Unassign_Detail_from_Cont'|| l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5276: END IF;
5277: FND_MESSAGE.SET_NAME('INV', 'INV_UNASSIGN_DEL_FAILURE');
5278: FND_MSG_PUB.ADD;
5279: RAISE FND_API.G_EXC_ERROR;
5280: end if;
5281:
5282: l_wdd_counter := l_wdd_counter + 1;

Line 5340: FND_MSG_PUB.ADD;

5336: CLOSE cur_delivery_details;
5337: END IF;
5338:
5339: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5340: FND_MSG_PUB.ADD;
5341:
5342: IF (l_debug = 1) THEN
5343: debug('update_wdd_loc_by_lpn 60 - expected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5344: END IF;

Line 5355: FND_MSG_PUB.ADD;

5351: CLOSE cur_delivery_details;
5352: END IF;
5353:
5354: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5355: FND_MSG_PUB.ADD;
5356:
5357: IF (l_debug = 1) THEN
5358: debug('update_wdd_loc_by_lpn 65 - unexpected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5359: END IF;

Line 5373: FND_MSG_PUB.ADD;

5369: debug('update_wdd_loc_by_lpn 70 - other error', 'WMS_SHIPPING_TRANSACTION_PUB');
5370: END IF;
5371:
5372: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5373: FND_MSG_PUB.ADD;
5374:
5375: IF SQLCODE IS NOT NULL THEN
5376: inv_mobile_helper_functions.sql_error('WMS_SHIPPING_TRANSACTION_PUB.update_wdd_loc_by_lpn',
5377: l_progress, SQLCODE);