DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on FND_MESSAGE

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

235:
236: -- Check for Required Parameters
237: IF(l_cost_price_rec.visit_task_id IS NULL OR
238: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
239: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
240: FND_MSG_PUB.ADD;
241: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
242: fnd_log.string
243: (

Line 261: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );

257: OPEN c_task_number(p_x_cost_price_rec.visit_task_id);
258: FETCH c_task_number into l_task_number;
259: close c_task_number;
260: --End of changes by amagrawa
261: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );
262: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_task_number);
263: FND_MSG_PUB.add;
264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
265: fnd_log.string

Line 262: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_task_number);

258: FETCH c_task_number into l_task_number;
259: close c_task_number;
260: --End of changes by amagrawa
261: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );
262: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_task_number);
263: FND_MSG_PUB.add;
264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
265: fnd_log.string
266: (

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

338: --
339: OPEN Get_price_list_name_cur(l_task_cost_price_rec.price_list_id);
340: FETCH Get_price_list_name_cur INTO l_cost_price_rec.price_list_name;
341: IF Get_price_list_name_cur%NOTFOUND THEN
342: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
343: FND_MSG_PUB.add;
344: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
345: fnd_log.string
346: (

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

406: OPEN visit_info_csr(l_cost_price_rec.visit_id);
407: FETCH visit_info_csr INTO l_visit_status;
408:
409: IF (visit_info_csr%NOTFOUND)THEN
410: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
411: FND_MSG_PUB.ADD;
412: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
413: fnd_log.string
414: (

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

951:
952: -- Check for Required Parameters
953: IF(l_cost_price_rec.visit_task_id IS NULL OR
954: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
955: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
956: FND_MSG_PUB.ADD;
957: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
958: fnd_log.string
959: (

Line 972: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );

968: -- Retrieve task related information
969: OPEN Get_visit_task_dtls_cur(l_cost_price_rec.visit_task_id);
970: FETCH Get_visit_task_dtls_cur INTO l_visit_task_dtls_rec;
971: IF Get_visit_task_dtls_cur%NOTFOUND THEN
972: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );
973: FND_MESSAGE.Set_Token('TASK_NUM', l_cost_price_rec.visit_task_number);
974: FND_MSG_PUB.add;
975: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
976: fnd_log.string

Line 973: FND_MESSAGE.Set_Token('TASK_NUM', l_cost_price_rec.visit_task_number);

969: OPEN Get_visit_task_dtls_cur(l_cost_price_rec.visit_task_id);
970: FETCH Get_visit_task_dtls_cur INTO l_visit_task_dtls_rec;
971: IF Get_visit_task_dtls_cur%NOTFOUND THEN
972: FND_MESSAGE.set_name( 'AHL','AHL_VWP_TASK_INVALID' );
973: FND_MESSAGE.Set_Token('TASK_NUM', l_cost_price_rec.visit_task_number);
974: FND_MSG_PUB.add;
975: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
976: fnd_log.string
977: (

Line 997: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_INVALID' );

993: -- Retrieve visit related information
994: OPEN Get_visit_dtls_cur(l_cost_price_rec.visit_id);
995: FETCH Get_visit_dtls_cur INTO l_visit_dtls_rec;
996: IF Get_visit_dtls_cur%NOTFOUND THEN
997: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_INVALID' );
998: FND_MSG_PUB.add;
999: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1000: fnd_log.string
1001: (

Line 1048: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PLIST_NFOUND');

1044: -- Find out the price list id
1045: OPEN price_list_id_csr(p_price_list_name,l_visit_dtls_rec.customer_id);
1046: FETCH price_list_id_csr INTO l_cost_price_rec.price_list_id;
1047: IF (price_list_id_csr%NOTFOUND)THEN
1048: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PLIST_NFOUND');
1049: FND_MESSAGE.Set_Token('PRICE_LIST',p_price_list_name);
1050: FND_MSG_PUB.ADD;
1051:
1052: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN

Line 1049: FND_MESSAGE.Set_Token('PRICE_LIST',p_price_list_name);

1045: OPEN price_list_id_csr(p_price_list_name,l_visit_dtls_rec.customer_id);
1046: FETCH price_list_id_csr INTO l_cost_price_rec.price_list_id;
1047: IF (price_list_id_csr%NOTFOUND)THEN
1048: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PLIST_NFOUND');
1049: FND_MESSAGE.Set_Token('PRICE_LIST',p_price_list_name);
1050: FND_MSG_PUB.ADD;
1051:
1052: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1053: fnd_log.string

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

1080: IF l_cost_price_rec.price_list_id IS NOT NULL THEN
1081: OPEN Get_price_list_cur(l_cost_price_rec.price_list_id);
1082: FETCH Get_price_list_cur INTO l_price_list_rec;
1083: IF Get_price_list_cur%NOTFOUND THEN
1084: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1085: FND_MSG_PUB.add;
1086: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1087: fnd_log.string
1088: (

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

1111:
1112: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_start_date_time)) OR
1113: (TRUNC(l_price_list_active_end_date) < TRUNC(l_start_date_time)) THEN
1114:
1115: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_STR');
1116: FND_MSG_PUB.ADD;
1117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1118: fnd_log.string
1119: (

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

1132:
1133: IF (TRUNC(l_price_list_active_start_date) > TRUNC(l_close_date_time)) OR
1134: (TRUNC(l_price_list_active_end_date) < TRUNC(l_close_date_time)) THEN
1135:
1136: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_END');
1137: FND_MSG_PUB.ADD;
1138: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1139: fnd_log.string
1140: (

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

1156: OR
1157: (l_price_list_active_end_date IS NOT NULL AND TRUNC(l_price_list_active_end_date) < TRUNC(sysdate))
1158: THEN
1159:
1160: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICE_LIST_INV_SYS');
1161: -- CHANGE THIS MESSAGE TEST AND NAME TOO -- IMPORTANT
1162: FND_MSG_PUB.ADD;
1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string

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

1385: END IF;
1386: -- Check for Required Parameters
1387: IF(l_cost_price_rec.visit_task_id IS NULL OR
1388: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1389: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1390: FND_MSG_PUB.ADD;
1391: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1392: fnd_log.string
1393: (

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

1729:
1730: -- Check for Required Parameters
1731: IF(l_cost_price_rec.visit_task_id IS NULL OR
1732: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
1733: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
1734: FND_MSG_PUB.ADD;
1735: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1736: fnd_log.string
1737: (

Line 1750: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );

1746: -- Retrieve visit info
1747: OPEN Get_visit_task_dtls_cur(l_cost_price_rec.visit_task_id) ;
1748: FETCH Get_visit_task_dtls_cur INTO l_visit_task_dtls_rec;
1749: IF Get_visit_task_dtls_cur%NOTFOUND THEN
1750: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
1751: FND_MSG_PUB.add;
1752: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1753: fnd_log.string
1754: (

Line 1805: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_NO_CURRENCY');

1801: p_visit_id => l_cost_price_rec.visit_id,
1802: x_currency_code => l_cost_price_rec.currency);
1803: -- error handling
1804: IF l_cost_price_rec.currency IS NULL THEN
1805: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_NO_CURRENCY');
1806: FND_MSG_PUB.ADD;
1807: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1808: fnd_log.string
1809: (

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

1829: -- Validation for Price list, Task has price list associated consider it else use
1830: -- visit price list. If both not exists then raise an error message
1831: IF (l_cost_price_rec.price_list_id IS NULL OR
1832: l_cost_price_rec.price_list_id = FND_API.G_MISS_NUM ) THEN
1833: FND_MESSAGE.set_name( 'AHL','AHL_VWP_PRICE_LIST_INVALID' );
1834: FND_MSG_PUB.add;
1835: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1836: fnd_log.string
1837: (

Line 2137: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VALIDATE_ERROR' );

2133: -- Task Date can not be null
2134: IF (l_cost_price_rec.task_start_date IS NULL OR
2135: l_cost_price_rec.task_start_date = FND_API.G_MISS_DATE ) THEN
2136:
2137: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VALIDATE_ERROR' );
2138: FND_MSG_PUB.add;
2139:
2140: IF G_DEBUG='Y' THEN
2141: Ahl_Debug_Pub.debug( l_full_name ||'Task Start Date is null');

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

2712: OPEN visit_info_csr(l_cost_price_rec.visit_id);
2713: FETCH visit_info_csr INTO l_visit_status;
2714:
2715: IF (visit_info_csr%NOTFOUND)THEN
2716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
2717: FND_MSG_PUB.ADD;
2718: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
2719: fnd_log.string
2720: (

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

2798: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details',
2799: 'Error : visit task id is null'
2800: );
2801:
2802: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
2803: FND_MSG_PUB.ADD;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2806:

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

3049:
3050: -- Check for Required Parameters
3051: IF(l_cost_price_rec.visit_task_id IS NULL OR
3052: l_cost_price_rec.visit_task_id = FND_API.G_MISS_NUM) THEN
3053: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');
3054: FND_MSG_PUB.ADD;
3055: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3056: fnd_log.string
3057: (

Line 3073: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );

3069: fetch c_task_csr into l_task_rec;
3070:
3071:
3072: IF c_task_csr%NOTFOUND THEN
3073: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VISIT_TASK_INVALID' );
3074: FND_MSG_PUB.add;
3075: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3076: fnd_log.string
3077: (

Line 3159: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_OUTSDPRTY_FLAG');

3155: -- Populate pricing attributes
3156:
3157: If l_visit_rec.outside_party_flag ='N'
3158: then
3159: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_OUTSDPRTY_FLAG');
3160: FND_MSG_PUB.ADD;
3161: RAISE FND_API.G_EXC_ERROR;
3162: --Display an error message `Visit number visit_number is not an outside party.'
3163: Else

Line 3171: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICELISTIDNULL');

3167: Elsif l_visit_rec.price_list_id is not Null
3168: then
3169: l_cost_price_rec.price_list_id :=l_visit_rec.price_list_id;
3170: Else
3171: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PRICELISTIDNULL');
3172: FND_MSG_PUB.ADD;
3173: RAISE FND_API.G_EXC_ERROR;
3174:
3175: END IF;

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

3226: );
3227:
3228: -- Check for value is null
3229: IF l_cost_price_rec.currency IS NULL THEN
3230: FND_MESSAGE.Set_Name(G_PKG_NAME,'AHL_VWP_CST_NO_CURRENCY');
3231: FND_MSG_PUB.ADD;
3232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3233: fnd_log.string
3234: (

Line 3729: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VALIDATE_ERROR' );

3725: -- Task Date can not be null
3726: IF (p_task_start_time IS NULL OR
3727: p_task_start_time = FND_API.G_MISS_DATE ) THEN
3728:
3729: FND_MESSAGE.set_name( 'AHL','AHL_VWP_VALIDATE_ERROR' );
3730: FND_MSG_PUB.add;
3731:
3732: IF G_DEBUG='Y' THEN
3733: Ahl_Debug_Pub.debug( l_full_name ||'Task Start Date is null');