DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on FND_MESSAGE

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

134: END IF;
135:
136: -- make sure that visit id is present in the input
137: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
138: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
139: FND_MSG_PUB.ADD;
140: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
141: fnd_log.string
142: (

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

156: l_cost_price_rec.Is_Cst_Struc_updated, l_cost_price_rec.service_request_id,
157: l_cost_price_rec.visit_start_date, l_cost_price_rec.visit_end_date;
158:
159: IF (visit_info_csr%NOTFOUND)THEN
160: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
161: FND_MSG_PUB.ADD;
162: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
163: fnd_log.string
164: (

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

179: -- find out the customer id
180: OPEN customer_id_csr(l_cost_price_rec.service_request_id);
181: FETCH customer_id_csr INTO l_cost_price_rec.customer_id;
182: IF(customer_id_csr%NOTFOUND)THEN
183: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');
184: FND_MSG_PUB.ADD;
185: IF(fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN
186: fnd_log.string
187: (

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

214: OPEN price_list_name_csr(l_cost_price_rec.price_list_id);
215: FETCH price_list_name_csr INTO l_cost_price_rec.price_list_name;
216:
217: IF(price_list_name_csr%NOTFOUND)THEN
218: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
219: FND_MSG_PUB.ADD;
220: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
221: fnd_log.string
222: (

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

493: END IF;
494:
495: -- Make sure that visit id is present in the input
496: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
497: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
498: FND_MSG_PUB.ADD;
499: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
500: fnd_log.string
501: (

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

508: END IF;
509:
510: --make sure outside party flag is valid
511: IF (NVL(p_x_cost_price_rec.outside_party_flag,'N') NOT IN ('Y','N'))THEN
512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_OSP_INV');
513: FND_MSG_PUB.ADD;
514: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
515: fnd_log.string
516: (

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

529: l_start_date_time,
530: l_close_date_time;
531:
532: IF (visit_info_csr%NOTFOUND)THEN
533: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
534: FND_MSG_PUB.ADD;
535: CLOSE visit_info_csr;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537:

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

544: );
545: END IF;
546:
547: ELSIF (l_visit_status_code = 'CLOSED')THEN
548: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_STS');
549: FND_MSG_PUB.ADD;
550: CLOSE visit_info_csr;
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552:

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

559: );
560: END IF;
561:
562: ELSIF (l_service_request_id IS NULL)THEN
563: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOSR');
564: FND_MSG_PUB.ADD;
565: CLOSE visit_info_csr;
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567:

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

580: OPEN visit_tasks_csr(p_x_cost_price_rec.visit_id);
581: FETCH visit_tasks_csr INTO l_exists;
582:
583: IF (visit_tasks_csr%FOUND)THEN
584: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_OSP_FLAG_MOD');
585: FND_MSG_PUB.ADD;
586: RAISE FND_API.G_EXC_ERROR;
587:
588: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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

605:
606: IF (l_cost_price_rec.outside_party_flag = 'Y' AND l_cost_price_rec.price_list_name IS NULL)
607: THEN
608:
609: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_MAND');
610: FND_MSG_PUB.ADD;
611: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
612: fnd_log.string
613: (

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

637: END IF;
638: RAISE FND_API.G_EXC_ERROR;
639: END IF;
640: ELSIF(l_cost_price_rec.outside_party_flag = 'N' AND l_cost_price_rec.price_list_name IS NOT NULL)THEN
641: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_OSP_VISIT_PR_LIST');
642: -- Please select check box 'Visit for outside party' or remove price list from LOV.
643: FND_MSG_PUB.ADD;
644: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
645: fnd_log.string

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

673:
674: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_start_date_time)) OR
675: (TRUNC(l_price_list_active_end_date) < TRUNC(l_start_date_time)) THEN
676:
677: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');
678: FND_MSG_PUB.ADD;
679: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
680: fnd_log.string
681: (

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

694:
695: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_close_date_time)) OR
696: (TRUNC(l_price_list_active_end_date) < TRUNC(l_close_date_time)) THEN
697:
698: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');
699: FND_MSG_PUB.ADD;
700: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
701: fnd_log.string
702: (

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

715: -- then validate with current sysdate
716: IF (TRUNC(l_price_list_active_start_date) > TRUNC(sysdate)) OR
717: (TRUNC(l_price_list_active_end_date) < TRUNC(sysdate)) THEN
718:
719: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');
720: -- CHANGE THIS MESSAGE TEST AND NAME TOO -- IMPORTANT
721: FND_MSG_PUB.ADD;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string

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

942:
943: -- make sure that visit id is present in the input
944:
945: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
946: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
947: FND_MSG_PUB.ADD;
948:
949: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
950: fnd_log.string

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

1462:
1463: -- make sure that visit id is present in the input
1464:
1465: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
1466: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1467: FND_MSG_PUB.ADD;
1468: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1469: fnd_log.string
1470: (

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

1481: FETCH visit_info_csr INTO l_visit_rec;
1482:
1483: IF(visit_info_csr%NOTFOUND)THEN
1484:
1485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
1486: FND_MSG_PUB.ADD;
1487:
1488: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
1489: fnd_log.string

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

1501: CLOSE visit_info_csr;
1502:
1503: -- price estimation valid or not
1504: IF(l_cost_price_rec.outside_party_flag <> 'Y')THEN
1505: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_PR_EST');
1506: FND_MSG_PUB.ADD;
1507:
1508: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1509: fnd_log.string

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

1578: OPEN customer_id_csr(l_visit_rec.service_request_id);
1579: FETCH customer_id_csr INTO l_cost_price_rec.customer_id;
1580:
1581: IF(customer_id_csr%NOTFOUND)THEN
1582: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
1583: FND_MSG_PUB.ADD;
1584:
1585: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1586: fnd_log.string

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

1603: x_currency_code => l_cost_price_rec.currency);
1604:
1605: -- Check if currency value is null
1606: IF l_cost_price_rec.currency IS NULL THEN
1607: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
1608: FND_MSG_PUB.ADD;
1609:
1610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1611: fnd_log.string

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

1622: -- Get the visit price list if not passed
1623: IF (l_visit_rec.price_list_id IS NULL OR
1624: l_visit_rec.price_list_id = FND_API.G_MISS_NUM ) THEN
1625:
1626: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1627: FND_MSG_PUB.add;
1628:
1629: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1630: fnd_log.string

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

2203: -- make sure that visit id is present in the input
2204:
2205: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
2206:
2207: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2208: FND_MSG_PUB.ADD;
2209:
2210: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2211: fnd_log.string

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

2225: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_visit_id) LOOP
2226:
2227: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2228:
2229: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2230: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2231: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2232: FND_MSG_PUB.ADD;
2233:

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

2226:
2227: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2228:
2229: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2230: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2231: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2232: FND_MSG_PUB.ADD;
2233:
2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

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

2227: IF(other_tasks_rec.actual_price IS NULL OR other_tasks_rec.estimated_price IS NULL)THEN
2228:
2229: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_SNAP_PRC_MISS');
2230: FND_MESSAGE.Set_Token('VISIT_TASK_NUMBER',other_tasks_rec.visit_task_number);
2231: FND_MESSAGE.Set_Token('VISIT_NUMBER',other_tasks_rec.visit_number);
2232: FND_MSG_PUB.ADD;
2233:
2234: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2235: fnd_log.string

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

2481: END IF;
2482:
2483: -- make sure that visit id is present in the input
2484: IF(p_x_cost_price_rec.visit_id IS NULL OR p_x_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2485: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2486: FND_MSG_PUB.ADD;
2487: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2488: fnd_log.string
2489: (

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

2536: x_return_status => x_return_status
2537: );
2538:
2539: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2540: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2541: FND_MSG_PUB.ADD;
2542: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2543: fnd_log.string
2544: (

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

2604: x_return_status => x_return_status
2605: );
2606:
2607: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2608: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_CALC_TCOST_ERR');
2609: FND_MSG_PUB.ADD;
2610: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2611: fnd_log.string
2612: (

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

2837:
2838: -- Check for Required Parameters
2839: IF(l_cost_price_rec.visit_id IS NULL OR
2840: l_cost_price_rec.visit_id = FND_API.G_MISS_NUM) THEN
2841: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_INPUT_MISS');
2842: FND_MSG_PUB.ADD;
2843:
2844: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2845: fnd_log.string

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

2858: Open c_visit_csr(l_cost_price_rec.visit_id);
2859: Fetch c_visit_csr into l_visit_rec;
2860: If c_visit_csr%notfound
2861: Then
2862: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
2863: Fnd_Msg_Pub.ADD;
2864: Close c_visit_csr;
2865: RAISE FND_API.G_EXC_ERROR;
2866: End if;

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

2920: -- Check outside party flag
2921:
2922: If l_visit_rec.outside_party_flag ='N'
2923: then
2924: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_OUTSDPRTY_FLAG');
2925: FND_MSG_PUB.ADD;
2926: RAISE FND_API.G_EXC_ERROR;
2927: --Display an error message `Visit number visit_number is not an outside party.'
2928: END if;

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

2934: if l_visit_rec.price_list_id is not Null and l_visit_rec.price_list_id <> FND_API.G_MISS_NUM
2935: then
2936: l_cost_price_rec.price_list_id :=l_visit_rec.price_list_id;
2937: Else
2938: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CST_PRICELISTIDNULL'); --AHL_VWP_PRICE_LIST_ID_NULL
2939: FND_MSG_PUB.ADD;
2940: RAISE FND_API.G_EXC_ERROR;
2941:
2942: END IF;

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

2987: );
2988:
2989: -- Error handling
2990: IF l_cost_price_rec.currency IS NULL THEN
2991: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
2992: FND_MSG_PUB.ADD;
2993: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2994: fnd_log.string
2995: (