DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_MESSAGE

Line 156: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

152: END IF;
153:
154: -- make sure that visit id is present in the input
155: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
156: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
157: FND_MSG_PUB.ADD;
158: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
159: fnd_log.string
160: (

Line 179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');

175: l_cost_price_rec.visit_start_date, l_cost_price_rec.visit_end_date,
176: l_cost_price_rec.Cp_Request_Id; --salogan::Fetched and stored request id in cost record CP ER 9299910::01-JUN-2009
177:
178: IF (visit_info_csr%NOTFOUND)THEN
179: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
180: FND_MSG_PUB.ADD;
181: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
182: fnd_log.string
183: (

Line 202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');

198: -- find out the customer id
199: OPEN customer_id_csr(l_cost_price_rec.service_request_id);
200: FETCH customer_id_csr INTO l_cost_price_rec.customer_id;
201: IF(customer_id_csr%NOTFOUND)THEN
202: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');
203: FND_MSG_PUB.ADD;
204: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
205: fnd_log.string
206: (

Line 237: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');

233: OPEN price_list_name_csr(l_cost_price_rec.price_list_id);
234: FETCH price_list_name_csr INTO l_cost_price_rec.price_list_name;
235:
236: IF(price_list_name_csr%NOTFOUND)THEN
237: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
238: FND_MSG_PUB.ADD;
239: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
240: fnd_log.string
241: (

Line 544: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

540: END IF;
541:
542: -- Make sure that visit id is present in the input
543: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
544: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
545: FND_MSG_PUB.ADD;
546: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
547: fnd_log.string
548: (

Line 559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_OSP_INV');

555: END IF;
556:
557: --make sure outside party flag is valid
558: IF (NVL(p_x_cost_price_rec.outside_party_flag,'N') NOT IN ('Y','N'))THEN
559: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_OSP_INV');
560: FND_MSG_PUB.ADD;
561: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
562: fnd_log.string
563: (

Line 580: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');

576: l_start_date_time,
577: l_close_date_time;
578:
579: IF (visit_info_csr%NOTFOUND)THEN
580: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
581: FND_MSG_PUB.ADD;
582: CLOSE visit_info_csr;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584:

Line 595: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_STS');

591: );
592: END IF;
593:
594: ELSIF (l_visit_status_code = 'CLOSED')THEN
595: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_STS');
596: FND_MSG_PUB.ADD;
597: CLOSE visit_info_csr;
598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
599:

Line 610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOSR');

606: );
607: END IF;
608:
609: ELSIF (l_service_request_id IS NULL)THEN
610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOSR');
611: FND_MSG_PUB.ADD;
612: CLOSE visit_info_csr;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614:

Line 631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_OSP_FLAG_MOD');

627: OPEN visit_tasks_csr(p_x_cost_price_rec.visit_id);
628: FETCH visit_tasks_csr INTO l_exists;
629:
630: IF (visit_tasks_csr%FOUND)THEN
631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_OSP_FLAG_MOD');
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_ERROR;
634:
635: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 656: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_MAND');

652:
653: IF (l_cost_price_rec.outside_party_flag = 'Y' AND l_cost_price_rec.price_list_name IS NULL)
654: THEN
655:
656: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_MAND');
657: FND_MSG_PUB.ADD;
658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
659: fnd_log.string
660: (

Line 688: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_OSP_VISIT_PR_LIST');

684: END IF;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687: ELSIF(l_cost_price_rec.outside_party_flag = 'N' AND l_cost_price_rec.price_list_name IS NOT NULL)THEN
688: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_OSP_VISIT_PR_LIST');
689: -- Please select check box 'Visit for outside party' or remove price list from LOV.
690: FND_MSG_PUB.ADD;
691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
692: fnd_log.string

Line 724: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');

720:
721: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_start_date_time)) OR
722: (TRUNC(l_price_list_active_end_date) < TRUNC(l_start_date_time)) THEN
723:
724: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');
725: FND_MSG_PUB.ADD;
726: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
727: fnd_log.string
728: (

Line 745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');

741:
742: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_close_date_time)) OR
743: (TRUNC(l_price_list_active_end_date) < TRUNC(l_close_date_time)) THEN
744:
745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');
746: FND_MSG_PUB.ADD;
747: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
748: fnd_log.string
749: (

Line 766: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');

762: -- then validate with current sysdate
763: IF (TRUNC(l_price_list_active_start_date) > TRUNC(sysdate)) OR
764: (TRUNC(l_price_list_active_end_date) < TRUNC(sysdate)) THEN
765:
766: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');
767: -- CHANGE THIS MESSAGE TEST AND NAME TOO -- IMPORTANT
768: FND_MSG_PUB.ADD;
769: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
770: fnd_log.string

Line 1007: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

1003:
1004: -- make sure that visit id is present in the input
1005:
1006: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
1007: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1008: FND_MSG_PUB.ADD;
1009:
1010: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1011: fnd_log.string

Line 1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

1531:
1532: -- make sure that visit id is present in the input
1533:
1534: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1536: FND_MSG_PUB.ADD;
1537: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1538: fnd_log.string
1539: (

Line 1554: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');

1550: FETCH visit_info_csr INTO l_visit_rec;
1551:
1552: IF(visit_info_csr%NOTFOUND)THEN
1553:
1554: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
1555: FND_MSG_PUB.ADD;
1556:
1557: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1558: fnd_log.string

Line 1574: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_PR_EST');

1570: CLOSE visit_info_csr;
1571:
1572: -- price estimation valid or not
1573: IF(l_cost_price_rec.outside_party_flag <> 'Y')THEN
1574: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_PR_EST');
1575: FND_MSG_PUB.ADD;
1576:
1577: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1578: fnd_log.string

Line 1651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');

1647: OPEN customer_id_csr(l_visit_rec.service_request_id);
1648: FETCH customer_id_csr INTO l_cost_price_rec.customer_id;
1649:
1650: IF(customer_id_csr%NOTFOUND)THEN
1651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
1652: FND_MSG_PUB.ADD;
1653:
1654: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1655: fnd_log.string

Line 1676: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');

1672: x_currency_code => l_cost_price_rec.currency);
1673:
1674: -- Check if currency value is null
1675: IF l_cost_price_rec.currency IS NULL THEN
1676: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1677: FND_MSG_PUB.ADD;
1678:
1679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1680: fnd_log.string

Line 1695: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );

1691: -- Get the visit price list if not passed
1692: IF (l_visit_rec.price_list_id IS NULL OR
1693: l_visit_rec.price_list_id = FND_API.G_MISS_NUM ) THEN
1694:
1695: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1696: FND_MSG_PUB.add;
1697:
1698: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1699: fnd_log.string

Line 2288: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

2284: -- make sure that visit id is present in the input
2285:
2286: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
2287:
2288: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2289: FND_MSG_PUB.ADD;
2290:
2291: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2292: fnd_log.string

Line 2310: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');

2306: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_visit_id) LOOP
2307:
2308: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2309:
2310: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2311: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2312: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2313: FND_MSG_PUB.ADD;
2314:

Line 2311: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);

2307:
2308: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2309:
2310: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2311: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2312: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2313: FND_MSG_PUB.ADD;
2314:
2315: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 2312: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);

2308: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2309:
2310: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2311: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2312: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2313: FND_MSG_PUB.ADD;
2314:
2315: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2316: fnd_log.string

Line 2566: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

2562: END IF;
2563:
2564: -- make sure that visit id is present in the input
2565: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2566: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2567: FND_MSG_PUB.ADD;
2568: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2569: fnd_log.string
2570: (

Line 2621: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');

2617: x_return_status => x_return_status
2618: );
2619:
2620: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2621: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2622: FND_MSG_PUB.ADD;
2623: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2624: fnd_log.string
2625: (

Line 2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');

2685: x_return_status => x_return_status
2686: );
2687:
2688: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2689: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2690: FND_MSG_PUB.ADD;
2691: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2692: fnd_log.string
2693: (

Line 2922: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');

2918:
2919: -- Check for Required Parameters
2920: IF(l_cost_price_rec.visit_id IS NULL OR
2921: l_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2922: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
2923: FND_MSG_PUB.ADD;
2924:
2925: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2926: fnd_log.string

Line 2943: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');

2939: Open c_visit_csr(l_cost_price_rec.visit_id);
2940: Fetch c_visit_csr into l_visit_rec;
2941: If c_visit_csr%notfound
2942: Then
2943: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
2944: Fnd_Msg_Pub.ADD;
2945: Close c_visit_csr;
2946: RAISE FND_API.G_EXC_ERROR;
2947: End if;

Line 3005: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_OUTSDPRTY_FLAG');

3001: -- Check outside party flag
3002:
3003: If l_visit_rec.outside_party_flag ='N'
3004: then
3005: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_OUTSDPRTY_FLAG');
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_ERROR;
3008: --Display an error message `Visit number visit_number is not an outside party.'
3009: END if;

Line 3019: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_PRICELISTIDNULL'); --AHL_VWP_PRICE_LIST_ID_NULL

3015: if l_visit_rec.price_list_id is not Null and l_visit_rec.price_list_id <> FND_API.G_MISS_NUM
3016: then
3017: l_cost_price_rec.price_list_id :=l_visit_rec.price_list_id;
3018: Else
3019: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_PRICELISTIDNULL'); --AHL_VWP_PRICE_LIST_ID_NULL
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022:
3023: END IF;

Line 3072: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');

3068: );
3069:
3070: -- Error handling
3071: IF l_cost_price_rec.currency IS NULL THEN
3072: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
3073: FND_MSG_PUB.ADD;
3074: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3075: fnd_log.string
3076: (

Line 3656: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

3652: END IF;
3653:
3654: -- Check for Required Parameters
3655: IF(p_x_cost_price_rec.Visit_id IS NULL OR p_x_cost_price_rec.Visit_id = FND_API.G_MISS_NUM) THEN
3656: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
3657: FND_MSG_PUB.ADD;
3658: IF (l_log_unexpected >= l_log_current_level)THEN
3659: fnd_log.string
3660: (

Line 3672: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CP_P2P_IN_PROGS');

3668:
3669: OPEN c_conc_req_phase(p_x_cost_price_rec.Visit_id);
3670: FETCH c_conc_req_phase INTO l_dummy;
3671: IF(c_conc_req_phase%FOUND) THEN
3672: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CP_P2P_IN_PROGS');
3673: FND_MSG_PUB.ADD;
3674: RAISE FND_API.G_EXC_ERROR;
3675: END IF;
3676: CLOSE c_conc_req_phase;