DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on FND_MESSAGE

Line 773: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_TASKS_NOT_EXISTS');

769: WHERE Visit_Task_Number = p_visit_task_number AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: ELSE
772: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
773: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_TASKS_NOT_EXISTS');
774: Fnd_Msg_Pub.ADD;
775: END IF;
776:
777: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 926: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_SUPERUSER');

922:
923: IF c_fnd_response%NOTFOUND THEN
924: x_return_status := Fnd_Api.g_ret_sts_error;
925: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
926: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_SUPERUSER');
927: Fnd_Msg_Pub.ADD;
928: CLOSE c_fnd_response;
929: RAISE G_EXC_ERROR;
930: END IF;

Line 944: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_USER_GROUPS');

940:
941: IF c_fnd_user_resp%NOTFOUND THEN
942: x_return_status := Fnd_Api.g_ret_sts_error;
943: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
944: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_USER_GROUPS');
945: Fnd_Msg_Pub.ADD;
946: END IF;
947: END IF;
948: CLOSE c_fnd_user_resp;

Line 980: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_RESPONSIBILITY');

976: x_check_project := 'N';
977: x_return_status := Fnd_Api.g_ret_sts_error;
978:
979: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
980: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_RESPONSIBILITY');
981: Fnd_Msg_Pub.ADD;
982: END IF;
983: END IF;
984: END IF;

Line 1090: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');

1086: INTO x_Item_Id, x_Item_Org_Id
1087: FROM CSI_ITEM_INSTANCES
1088: WHERE Instance_Id = x_instance_id;
1089: ELSE
1090: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
1091: Fnd_Msg_Pub.ADD;
1092: RAISE Fnd_Api.G_EXC_ERROR;
1093: END IF;
1094: END IF;

Line 1204: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_MISSING');

1200: L_DEBUG_KEY,
1201: 'Error in Insert_Tasks. Serial Id missing.');
1202: END IF;
1203: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1204: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_MISSING');
1205: Fnd_Msg_Pub.ADD;
1206: END IF;
1207: END IF;
1208: END IF; -- End of p_unit_id check

Line 2055: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TASK_FOUND');

2051: CLOSE c_task;
2052: OPEN c_mr_title(l_MR_id);
2053: FETCH c_mr_title into l_mr_title;
2054: CLOSE c_mr_title;
2055: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TASK_FOUND');
2056: FND_MESSAGE.SET_TOKEN('MR',l_mr_title);
2057: Fnd_Msg_Pub.ADD;
2058:
2059: ELSE -- else of c_task cursor found or not

Line 2056: FND_MESSAGE.SET_TOKEN('MR',l_mr_title);

2052: OPEN c_mr_title(l_MR_id);
2053: FETCH c_mr_title into l_mr_title;
2054: CLOSE c_mr_title;
2055: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TASK_FOUND');
2056: FND_MESSAGE.SET_TOKEN('MR',l_mr_title);
2057: Fnd_Msg_Pub.ADD;
2058:
2059: ELSE -- else of c_task cursor found or not
2060: --Dup-MR ER#6338208 - sowsubra - start

Line 2072: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');

2068: fnd_log.string(l_log_statement,
2069: L_DEBUG_KEY,
2070: ' Inner c_task2 found');
2071: END IF;
2072: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
2073: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);
2074: Fnd_Msg_Pub.ADD;
2075: ELSE
2076: */

Line 2073: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);

2069: L_DEBUG_KEY,
2070: ' Inner c_task2 found');
2071: END IF;
2072: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
2073: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);
2074: Fnd_Msg_Pub.ADD;
2075: ELSE
2076: */
2077: --Dup-MR ER#6338208 - sowsubra - end

Line 2108: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');

2104: fnd_log.string(l_log_statement,
2105: L_DEBUG_KEY,
2106: ' Inner c_task2 found');
2107: END IF;
2108: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
2109: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);
2110: Fnd_Msg_Pub.ADD;
2111: END IF;
2112: CLOSE c_task_chk;

Line 2109: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);

2105: L_DEBUG_KEY,
2106: ' Inner c_task2 found');
2107: END IF;
2108: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
2109: Fnd_Message.SET_TOKEN('MR_TITLE',c_task_chk_rec.title);
2110: Fnd_Msg_Pub.ADD;
2111: END IF;
2112: CLOSE c_task_chk;
2113: */

Line 2214: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NO_EXIST');

2210: IF l_Stage_num_Tbl(i) IS NOT NULL THEN
2211: OPEN c_stage(l_Stage_num_Tbl(i),l_visit_id);
2212: FETCH c_stage INTO l_stage_id, l_stage_name ;
2213: IF c_stage%NOTFOUND THEN
2214: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NO_EXIST');
2215: Fnd_Msg_Pub.ADD;
2216: CLOSE c_stage;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;

Line 2378: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');

2374: fnd_log.string(l_log_statement,
2375: L_DEBUG_KEY,
2376: 'p_cost_parent_id = p_visit_task_id');
2377: END IF;
2378: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');
2379: Fnd_Msg_Pub.ADD;
2380: RAISE Fnd_Api.G_EXC_ERROR;
2381: END IF;
2382:

Line 2393: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');

2389: fnd_log.string(l_log_statement,
2390: L_DEBUG_KEY,
2391: 'TASK LOOP');
2392: END IF;
2393: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');
2394: Fnd_Msg_Pub.ADD;
2395: CLOSE c_child;
2396: RAISE Fnd_Api.G_EXC_ERROR;
2397: END IF;

Line 2454: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');

2450: fnd_log.string(l_log_statement,
2451: L_DEBUG_KEY,
2452: 'TASK LOOP1');
2453: END IF;
2454: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');
2455: Fnd_Msg_Pub.ADD;
2456: RAISE Fnd_Api.G_EXC_ERROR;
2457: END IF;
2458:

Line 2470: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');

2466: L_DEBUG_KEY,
2467: 'TASK LOOP2');
2468: END IF;
2469:
2470: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');
2471: Fnd_Msg_Pub.ADD;
2472: CLOSE c_child;
2473: RAISE Fnd_Api.G_EXC_ERROR;
2474: END IF;

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

2599:
2600: OPEN visit_info_csr(p_visit_id);
2601: FETCH visit_info_csr INTO l_service_request_id;
2602: IF (visit_info_csr%NOTFOUND) THEN
2603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT');
2604: FND_MSG_PUB.ADD;
2605: IF (l_log_unexpected >= l_log_current_level)THEN
2606: fnd_log.string(l_log_unexpected,
2607: L_DEBUG_KEY,

Line 2612: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOS');

2608: 'Visit id not found in AHL_VISITS_B table');
2609: END IF;
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2611: ELSIF(l_service_request_id IS NULL)THEN
2612: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOS');
2613: FND_MSG_PUB.ADD;
2614: IF (fnd_log.level_error >= l_log_current_level)THEN
2615: fnd_log.string(fnd_log.level_error,
2616: L_DEBUG_KEY,

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

2626:
2627: OPEN customer_id_csr(l_service_request_id);
2628: FETCH customer_id_csr INTO l_customer_id;
2629: IF(customer_id_csr%NOTFOUND)THEN
2630: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SR_ID');
2631: FND_MSG_PUB.ADD;
2632: IF (l_log_unexpected >= l_log_current_level)THEN
2633: fnd_log.string(l_log_unexpected,
2634: L_DEBUG_KEY,

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

2636: ' is invalid as record not found.');
2637: END IF;
2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2639: ELSIF(l_customer_id IS NULL)THEN
2640: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
2641: FND_MSG_PUB.ADD;
2642: IF (fnd_log.level_error >= l_log_current_level)THEN
2643: fnd_log.string(fnd_log.level_error,
2644: L_DEBUG_KEY,

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

2655: -- find out the price list id
2656: OPEN price_list_id_csr(p_price_list_name,l_customer_id);
2657: FETCH price_list_id_csr INTO x_price_list_id;
2658: IF(price_list_id_csr%NOTFOUND)THEN
2659: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PLIST_NFOUND');
2660: FND_MESSAGE.Set_Token('PRICE_LIST',p_price_list_name);
2661: FND_MSG_PUB.ADD;
2662: IF (fnd_log.level_error >= l_log_current_level)THEN
2663: fnd_log.string(fnd_log.level_error,

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

2656: OPEN price_list_id_csr(p_price_list_name,l_customer_id);
2657: FETCH price_list_id_csr INTO x_price_list_id;
2658: IF(price_list_id_csr%NOTFOUND)THEN
2659: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_PLIST_NFOUND');
2660: FND_MESSAGE.Set_Token('PRICE_LIST',p_price_list_name);
2661: FND_MSG_PUB.ADD;
2662: IF (fnd_log.level_error >= l_log_current_level)THEN
2663: fnd_log.string(fnd_log.level_error,
2664: L_DEBUG_KEY,

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

2973: IF (l_org_id IS NOT NULL)THEN
2974: OPEN currency_code_csr(l_org_id);
2975: FETCH currency_code_csr INTO x_currency_code;
2976: IF (currency_code_csr%NOTFOUND)THEN
2977: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_NO_CURRENCY');
2978: FND_MSG_PUB.ADD;
2979: IF (fnd_log.level_error >= l_log_current_level)THEN
2980: fnd_log.string(fnd_log.level_error,
2981: L_DEBUG_KEY,