DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on FND_MSG_PUB

Line 91: l_msg_count := fnd_msg_pub.count_msg;

87: l_msg_name VARCHAR2(50);
88: BEGIN
89: debug('Entered procedure','process_mobile_msg');
90:
91: l_msg_count := fnd_msg_pub.count_msg;
92: debug('Msg Count: ' || l_msg_count,'process_mobile_msg');
93:
94: FOR i IN 1..l_msg_count LOOP
95: fnd_msg_pub.get(p_msg_index => i,

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

91: l_msg_count := fnd_msg_pub.count_msg;
92: debug('Msg Count: ' || l_msg_count,'process_mobile_msg');
93:
94: FOR i IN 1..l_msg_count LOOP
95: fnd_msg_pub.get(p_msg_index => i,
96: p_data => l_msg_data,
97: p_msg_index_out => l_dummy_number);
98:
99: debug('i: ' || i || ' index_out: ' || l_dummy_number || ' encoded_data: ' || l_msg_data,'process_mobile_msg');

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

104:
105: debug('App_short_name: ' || l_app_short_name || ' Msg_name: ' || l_msg_name,'process_mobile_msg');
106:
107: IF (l_msg_name <> 'WSH_DET_INV_INT_SUBMITTED') THEN
108: fnd_msg_pub.delete_msg(p_msg_index=>i);
109: debug('Deleted message at position: ' || i,'process_mobile_msg');
110: END IF;
111: END LOOP;
112: EXCEPTION

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

2071: EXCEPTION
2072: WHEN fnd_api.g_exc_unexpected_error THEN
2073: --if keep current structure of returning error_code
2074: --no need to get message from stack as java side does it
2075: fnd_msg_pub.count_and_get(p_count => l_msg_count,
2076: p_data => l_msg_data);
2077: IF l_debug = 1 THEN
2078: debug('LPN_SUBMIT raised unexpected error','LPN_SUBMIT');
2079: debug('msg_stack: ' || l_msg_data,'LPN_SUBMIT');

Line 3870: FND_MSG_PUB.ADD;

3866: print_label(l_del_rows, l_return_status);
3867: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3868: debug('print_label failed','ship_confirm_all');
3869: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
3870: FND_MSG_PUB.ADD;
3871: x_return_status := 'W';
3872: END IF;
3873: end if;
3874:

Line 3876: x_msg_count := fnd_msg_pub.count_msg;

3872: END IF;
3873: end if;
3874:
3875: process_mobile_msg;
3876: x_msg_count := fnd_msg_pub.count_msg;
3877: x_msg_data := '';
3878: FOR i IN 1..x_msg_count LOOP
3879: fnd_msg_pub.get(p_encoded=>'F'
3880: ,p_msg_index => i

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

3875: process_mobile_msg;
3876: x_msg_count := fnd_msg_pub.count_msg;
3877: x_msg_data := '';
3878: FOR i IN 1..x_msg_count LOOP
3879: fnd_msg_pub.get(p_encoded=>'F'
3880: ,p_msg_index => i
3881: ,p_data => l_msg_data
3882: ,p_msg_index_out => l_dummy_number);
3883: x_msg_data := x_msg_data || l_msg_data;

Line 3894: x_msg_count := FND_MSG_PUB.Count_msg;

3890: ROLLBACK;
3891: x_return_status := l_return_status;
3892:
3893: --DHERRING Bug#5651219. Fix starts
3894: x_msg_count := FND_MSG_PUB.Count_msg;
3895: FOR i in 1..x_msg_count LOOP
3896: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
3897: p_msg_index_out => l_tmp_out);
3898: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;

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

3892:
3893: --DHERRING Bug#5651219. Fix starts
3894: x_msg_count := FND_MSG_PUB.Count_msg;
3895: FOR i in 1..x_msg_count LOOP
3896: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
3897: p_msg_index_out => l_tmp_out);
3898: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;
3899: END LOOP;
3900:

Line 4393: FND_MSG_PUB.ADD;

4389: print_label(l_del_rows, l_return_status);
4390: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4391: debug('print_label failed','ship_confirm_lpn_deliveries');
4392: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4393: FND_MSG_PUB.ADD;
4394: l_num_warnings := l_num_warnings + 1;
4395: END IF;
4396: ELSE --corresponding if - p_verify_only = 'Y'
4397: if p_trip_stop_id =0 then

Line 4499: FND_MSG_PUB.ADD;

4495: print_label(l_del_rows, l_return_status);
4496: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4497: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4498: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4499: FND_MSG_PUB.ADD;
4500:
4501: l_num_warnings := l_num_warnings + 1;
4502: END IF;
4503:

Line 4741: FND_MSG_PUB.ADD;

4737: print_label(l_del_rows, l_return_status);
4738: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4739: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4740: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4741: FND_MSG_PUB.ADD;
4742:
4743: l_num_warnings := l_num_warnings + 1;
4744: END IF;
4745:

Line 4965: FND_MSG_PUB.ADD;

4961: print_label(l_del_rows, l_return_status);
4962: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4963: debug('print_label failed','SHIP_CONFIRM_LPN_DELIVERIES');
4964: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
4965: FND_MSG_PUB.ADD;
4966:
4967: l_num_warnings := l_num_warnings + 1;
4968: END IF;
4969: end if; -- p_trip_id <> 0

Line 4979: x_msg_count := fnd_msg_pub.count_msg;

4975: x_return_status := 'W';
4976: END IF;
4977:
4978: process_mobile_msg;
4979: x_msg_count := fnd_msg_pub.count_msg;
4980: x_msg_data := '';
4981: FOR i IN 1..x_msg_count LOOP
4982: fnd_msg_pub.get(p_encoded=>'F'
4983: ,p_msg_index => i

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

4978: process_mobile_msg;
4979: x_msg_count := fnd_msg_pub.count_msg;
4980: x_msg_data := '';
4981: FOR i IN 1..x_msg_count LOOP
4982: fnd_msg_pub.get(p_encoded=>'F'
4983: ,p_msg_index => i
4984: ,p_data => l_msg_data
4985: ,p_msg_index_out => l_dummy_number);
4986: IF (l_debug = 1) THEN

Line 5002: x_msg_count := FND_MSG_PUB.Count_msg;

4998: debug('Unexpected error raised: ' || SQLERRM, 'SHIP_CONFIRM_LPN_DELIVERIES');
4999: x_return_status := l_return_status;
5000:
5001: --DHERRING Bug#5651219. Fix starts
5002: x_msg_count := FND_MSG_PUB.Count_msg;
5003: FOR i in 1..x_msg_count LOOP
5004: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
5005: p_msg_index_out => l_tmp_out);
5006: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;

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

5000:
5001: --DHERRING Bug#5651219. Fix starts
5002: x_msg_count := FND_MSG_PUB.Count_msg;
5003: FOR i in 1..x_msg_count LOOP
5004: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE, p_msg_index => i, p_data=> l_tmp_buffer,
5005: p_msg_index_out => l_tmp_out);
5006: x_msg_data:=x_msg_data ||'|'|| l_tmp_buffer;
5007: END LOOP;
5008:

Line 5438: FND_MSG_PUB.ADD;

5434: IF (l_debug = 1) THEN
5435: debug('Error Unassign_Detail_from_Cont'|| l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5436: END IF;
5437: FND_MESSAGE.SET_NAME('INV', 'INV_UNASSIGN_DEL_FAILURE');
5438: FND_MSG_PUB.ADD;
5439: RAISE FND_API.G_EXC_ERROR;
5440: end if;
5441:
5442: l_wdd_counter := l_wdd_counter + 1;

Line 5500: FND_MSG_PUB.ADD;

5496: CLOSE cur_delivery_details;
5497: END IF;
5498:
5499: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5500: FND_MSG_PUB.ADD;
5501:
5502: IF (l_debug = 1) THEN
5503: debug('update_wdd_loc_by_lpn 60 - expected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5504: END IF;

Line 5515: FND_MSG_PUB.ADD;

5511: CLOSE cur_delivery_details;
5512: END IF;
5513:
5514: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5515: FND_MSG_PUB.ADD;
5516:
5517: IF (l_debug = 1) THEN
5518: debug('update_wdd_loc_by_lpn 65 - unexpected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5519: END IF;

Line 5533: FND_MSG_PUB.ADD;

5529: debug('update_wdd_loc_by_lpn 70 - other error', 'WMS_SHIPPING_TRANSACTION_PUB');
5530: END IF;
5531:
5532: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5533: FND_MSG_PUB.ADD;
5534:
5535: IF SQLCODE IS NOT NULL THEN
5536: inv_mobile_helper_functions.sql_error('WMS_SHIPPING_TRANSACTION_PUB.update_wdd_loc_by_lpn',
5537: l_progress, SQLCODE);