DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on FND_MSG_PUB

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

1898: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1899: IF (l_debug = 1) THEN
1900: print_debug('TXN_COMPLETE: Error while calling query_reservations');
1901: END IF;
1902: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1903: RAISE fnd_api.g_exc_error; --return;
1904: END IF;
1905:
1906: IF (l_debug = 1) THEN

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

1933: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1934: IF (l_debug = 1) THEN
1935: print_debug('TXN_COMPLETE: Error while deleting reservations');
1936: END IF;
1937: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count, p_data => x_msg_data);
1938: RAISE fnd_api.g_exc_error; --return;
1939: END IF;
1940: IF (l_debug = 1) THEN
1941: print_debug('TXN_COMPLETE: Deleted the reservation record successfully');

Line 2884: fnd_msg_pub.count_and_get

2880: print_debug('x_return_status =>' || x_return_status);
2881: END IF;
2882:
2883: -- Get message count and data
2884: fnd_msg_pub.count_and_get
2885: ( p_count => x_msg_count
2886: , p_data => x_msg_data
2887: );
2888:

Line 2905: fnd_msg_pub.count_and_get

2901: print_debug('x_return_status =>' || x_return_status);
2902: END IF;
2903:
2904: -- Get message count and data
2905: fnd_msg_pub.count_and_get
2906: ( p_count => x_msg_count
2907: , p_data => x_msg_data
2908: );
2909:

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

2921: IF (l_debug = 1) THEN
2922: print_debug('x_return_status =>' || x_return_status);
2923: END IF;
2924: --
2925: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2926: THEN
2927: fnd_msg_pub.add_exc_msg
2928: ( g_pkg_name
2929: , 'main_process'

Line 2927: fnd_msg_pub.add_exc_msg

2923: END IF;
2924: --
2925: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2926: THEN
2927: fnd_msg_pub.add_exc_msg
2928: ( g_pkg_name
2929: , 'main_process'
2930: );
2931: END IF;

Line 2934: fnd_msg_pub.count_and_get

2930: );
2931: END IF;
2932:
2933: -- Get message count and data
2934: fnd_msg_pub.count_and_get
2935: ( p_count => x_msg_count
2936: , p_data => x_msg_data
2937: );
2938:

Line 3085: fnd_msg_pub.count_and_get

3081: print_debug('x_return_status =>' || x_return_status);
3082: END IF;
3083:
3084: -- Get message count and data
3085: fnd_msg_pub.count_and_get
3086: ( p_count => x_msg_count
3087: , p_data => x_msg_data
3088: );
3089:

Line 3103: fnd_msg_pub.count_and_get

3099: print_debug('x_return_status =>' || x_return_status);
3100: END IF;
3101:
3102: -- Get message count and data
3103: fnd_msg_pub.count_and_get
3104: ( p_count => x_msg_count
3105: , p_data => x_msg_data
3106: );
3107:

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

3116: IF (l_debug = 1) THEN
3117: print_debug('x_return_status =>' || x_return_status);
3118: END IF;
3119: --
3120: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3121: THEN
3122: fnd_msg_pub.add_exc_msg
3123: ( g_pkg_name
3124: , 'main_process'

Line 3122: fnd_msg_pub.add_exc_msg

3118: END IF;
3119: --
3120: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3121: THEN
3122: fnd_msg_pub.add_exc_msg
3123: ( g_pkg_name
3124: , 'main_process'
3125: );
3126: END IF;

Line 3129: fnd_msg_pub.count_and_get

3125: );
3126: END IF;
3127:
3128: -- Get message count and data
3129: fnd_msg_pub.count_and_get
3130: ( p_count => x_msg_count
3131: , p_data => x_msg_data
3132: );
3133:

Line 3441: fnd_msg_pub.ADD;

3437: IF (l_primary_res_qty = -99999) THEN
3438: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3439: fnd_message.set_token('UOM', l_item_primary_uom);
3440: fnd_message.set_token('ROUTINE', 'Create Reservation');
3441: fnd_msg_pub.ADD;
3442: RAISE fnd_api.g_exc_error;
3443: END IF;
3444: ELSE --IF l_uom_code <> l_item_primary_uom THEN
3445: l_primary_res_qty := p_reservation_qty;

Line 3477: FND_MSG_PUB.ADD;

3473: IF (l_debug = 1) THEN
3474: print_debug('CREATE_RETURN_RESV:error in update_reservation');
3475: END IF;
3476: FND_MESSAGE.SET_NAME('INB', 'INV_UPD_RSV_FAILED');
3477: FND_MSG_PUB.ADD;
3478: RAISE fnd_api.g_exc_error;
3479: END IF;
3480: IF (l_debug = 1) THEN
3481: print_debug('CREATE_RETURN_RESV:successfully updated a reservation record: ' ||sql%rowcount);

Line 3514: fnd_msg_pub.add;

3510: IF (l_primary_res_qty = -99999) THEN
3511: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3512: fnd_message.set_token('UOM', l_item_primary_uom);
3513: fnd_message.set_token('ROUTINE', 'Create Reservation');
3514: fnd_msg_pub.add;
3515: RAISE fnd_api.g_exc_error;
3516: END IF;
3517: ELSE --IF l_uom_code <> l_item_primary_uom THEN
3518: l_primary_res_qty := p_reservation_qty;

Line 3630: fnd_msg_pub.count_and_get

3626:
3627: EXCEPTION
3628: WHEN fnd_api.g_exc_error THEN
3629: x_return_status := fnd_api.g_ret_sts_error;
3630: fnd_msg_pub.count_and_get
3631: ( p_count => x_msg_count,
3632: p_data => x_msg_data
3633: );
3634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3639: fnd_msg_pub.count_and_get

3635: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3636: IF (l_debug = 1) THEN
3637: print_debug('unxp:' || sqlerrm);
3638: END IF;
3639: fnd_msg_pub.count_and_get
3640: ( p_count => x_msg_count,
3641: p_data => x_msg_data
3642: );
3643: WHEN OTHERS THEN

Line 3645: fnd_msg_pub.count_and_get

3641: p_data => x_msg_data
3642: );
3643: WHEN OTHERS THEN
3644: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3645: fnd_msg_pub.count_and_get
3646: ( p_count => x_msg_count,
3647: p_data => x_msg_data
3648: );
3649: END CREATE_RETURN_RESV;