DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on FND_MSG_PUB

Line 1921: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

1917: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1918: IF (l_debug = 1) THEN
1919: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1920: END IF;
1921: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1922: RAISE fnd_api.g_exc_error; --return;
1923: END IF;
1924:
1925: IF (l_debug = 1) THEN

Line 1956: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);

1952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1953: IF (l_debug = 1) THEN
1954: print_debug('TXN_COMPLETE: Error while deleting reservations');
1955: END IF;
1956: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1957: RAISE fnd_api.g_exc_error; --return;
1958: END IF;
1959: IF (l_debug = 1) THEN
1960: print_debug('TXN_COMPLETE: Deleted the reservation record successfully');

Line 2936: fnd_msg_pub.ADD;

2932: WHERE lpn_id = l_lpn_id;
2933: EXCEPTION
2934: WHEN NO_DATA_FOUND THEN
2935: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
2936: fnd_msg_pub.ADD;
2937: RAISE fnd_api.g_exc_error;
2938: END;
2939:
2940:

Line 3796: fnd_msg_pub.count_and_get

3792: print_debug('x_return_status =>' || x_return_status);
3793: END IF;
3794:
3795: -- Get message count and data
3796: fnd_msg_pub.count_and_get
3797: ( p_count => x_msg_count
3798: , p_data => x_msg_data
3799: );
3800:

Line 3817: fnd_msg_pub.count_and_get

3813: print_debug('x_return_status =>' || x_return_status);
3814: END IF;
3815:
3816: -- Get message count and data
3817: fnd_msg_pub.count_and_get
3818: ( p_count => x_msg_count
3819: , p_data => x_msg_data
3820: );
3821:

Line 3837: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

3833: IF (l_debug = 1) THEN
3834: print_debug('x_return_status =>' || x_return_status);
3835: END IF;
3836: --
3837: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3838: THEN
3839: fnd_msg_pub.add_exc_msg
3840: ( g_pkg_name
3841: , 'main_process'

Line 3839: fnd_msg_pub.add_exc_msg

3835: END IF;
3836: --
3837: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3838: THEN
3839: fnd_msg_pub.add_exc_msg
3840: ( g_pkg_name
3841: , 'main_process'
3842: );
3843: END IF;

Line 3846: fnd_msg_pub.count_and_get

3842: );
3843: END IF;
3844:
3845: -- Get message count and data
3846: fnd_msg_pub.count_and_get
3847: ( p_count => x_msg_count
3848: , p_data => x_msg_data
3849: );
3850:

Line 3997: fnd_msg_pub.count_and_get

3993: print_debug('x_return_status =>' || x_return_status);
3994: END IF;
3995:
3996: -- Get message count and data
3997: fnd_msg_pub.count_and_get
3998: ( p_count => x_msg_count
3999: , p_data => x_msg_data
4000: );
4001:

Line 4015: fnd_msg_pub.count_and_get

4011: print_debug('x_return_status =>' || x_return_status);
4012: END IF;
4013:
4014: -- Get message count and data
4015: fnd_msg_pub.count_and_get
4016: ( p_count => x_msg_count
4017: , p_data => x_msg_data
4018: );
4019:

Line 4032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

4028: IF (l_debug = 1) THEN
4029: print_debug('x_return_status =>' || x_return_status);
4030: END IF;
4031: --
4032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4033: THEN
4034: fnd_msg_pub.add_exc_msg
4035: ( g_pkg_name
4036: , 'main_process'

Line 4034: fnd_msg_pub.add_exc_msg

4030: END IF;
4031: --
4032: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4033: THEN
4034: fnd_msg_pub.add_exc_msg
4035: ( g_pkg_name
4036: , 'main_process'
4037: );
4038: END IF;

Line 4041: fnd_msg_pub.count_and_get

4037: );
4038: END IF;
4039:
4040: -- Get message count and data
4041: fnd_msg_pub.count_and_get
4042: ( p_count => x_msg_count
4043: , p_data => x_msg_data
4044: );
4045:

Line 4353: fnd_msg_pub.ADD;

4349: IF (l_primary_res_qty = -99999) THEN
4350: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
4351: fnd_message.set_token('UOM', l_item_primary_uom);
4352: fnd_message.set_token('ROUTINE', 'Create Reservation');
4353: fnd_msg_pub.ADD;
4354: RAISE fnd_api.g_exc_error;
4355: END IF;
4356: ELSE --IF l_uom_code <> l_item_primary_uom THEN
4357: l_primary_res_qty := p_reservation_qty;

Line 4389: FND_MSG_PUB.ADD;

4385: IF (l_debug = 1) THEN
4386: print_debug('CREATE_RETURN_RESV:error in update_reservation');
4387: END IF;
4388: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');
4389: FND_MSG_PUB.ADD;
4390: RAISE fnd_api.g_exc_error;
4391: END IF;
4392: IF (l_debug = 1) THEN
4393: print_debug('CREATE_RETURN_RESV:successfully updated a reservation record: ' ||sql%rowcount);

Line 4426: fnd_msg_pub.add;

4422: IF (l_primary_res_qty = -99999) THEN
4423: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
4424: fnd_message.set_token('UOM', l_item_primary_uom);
4425: fnd_message.set_token('ROUTINE', 'Create Reservation');
4426: fnd_msg_pub.add;
4427: RAISE fnd_api.g_exc_error;
4428: END IF;
4429: ELSE --IF l_uom_code <> l_item_primary_uom THEN
4430: l_primary_res_qty := p_reservation_qty;

Line 4542: fnd_msg_pub.count_and_get

4538:
4539: EXCEPTION
4540: WHEN fnd_api.g_exc_error THEN
4541: x_return_status := fnd_api.g_ret_sts_error;
4542: fnd_msg_pub.count_and_get
4543: ( p_count => x_msg_count,
4544: p_data => x_msg_data
4545: );
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4551: fnd_msg_pub.count_and_get

4547: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4548: IF (l_debug = 1) THEN
4549: print_debug('unxp:' || sqlerrm);
4550: END IF;
4551: fnd_msg_pub.count_and_get
4552: ( p_count => x_msg_count,
4553: p_data => x_msg_data
4554: );
4555: WHEN OTHERS THEN

Line 4557: fnd_msg_pub.count_and_get

4553: p_data => x_msg_data
4554: );
4555: WHEN OTHERS THEN
4556: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4557: fnd_msg_pub.count_and_get
4558: ( p_count => x_msg_count,
4559: p_data => x_msg_data
4560: );
4561: END CREATE_RETURN_RESV;