APPS.PV_ASSIGNMENT_PVT dependencies on PV_STATUS_NOTIFICATIONS

Line 3471: from pv_status_notifications b

3467: nvl(b.notify_cm_flag, 'N'),
3468: nvl(b.notify_am_flag, 'N'),
3469: nvl(b.notify_others_flag, 'N'),
3470: b.enabled_flag
3471: from pv_status_notifications b
3472: where
3473: b.status_type = 'ROUTING'
3474: and b.status_code = pc_route_stage;
3475:

Line 3622: fnd_message.SET_TOKEN('TEXT', 'Cannot find routing stage: ' || p_route_stage || ' in pv_status_notifications');

3618:
3619: if l_notify_enabled_flag is NULL then
3620:
3621: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
3622: fnd_message.SET_TOKEN('TEXT', 'Cannot find routing stage: ' || p_route_stage || ' in pv_status_notifications');
3623: fnd_msg_pub.ADD;
3624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3625:
3626: end if;