eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_RULES_PVT dependencies on FND_MSG_PUB

Line 774: Fnd_Msg_Pub.ADD;

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;
778: IF (l_log_procedure >= l_log_current_level) THEN

Line 925: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

921: END IF;
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;

Line 927: Fnd_Msg_Pub.ADD;

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;
931: END IF;

Line 943: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

939: END IF;
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;

Line 945: Fnd_Msg_Pub.ADD;

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;
949:

Line 979: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

975: ELSE
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;

Line 981: Fnd_Msg_Pub.ADD;

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;
985: */

Line 1091: Fnd_Msg_Pub.ADD;

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;
1095:

Line 1203: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

1199: fnd_log.string(l_log_statement,
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;

Line 1205: Fnd_Msg_Pub.ADD;

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
1209:

Line 1270: l_msg_count := Fnd_Msg_Pub.count_msg;

1266: L_DEBUG_KEY,
1267: 'Task ID = ' || l_task_id || ', Task Number = ' || l_task_number);
1268: END IF;
1269:
1270: l_msg_count := Fnd_Msg_Pub.count_msg;
1271: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1272: x_msg_count := l_msg_count;
1273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1274: RAISE Fnd_Api.G_EXC_ERROR;

Line 1374: l_msg_count := Fnd_Msg_Pub.count_msg;

1370: 'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times. Return Status = ' ||
1371: l_return_status);
1372: END IF;
1373:
1374: l_msg_count := Fnd_Msg_Pub.count_msg;
1375: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1376: IF (l_log_statement >= l_log_current_level) THEN
1377: fnd_log.string(l_log_statement,
1378: L_DEBUG_KEY,

Line 2057: Fnd_Msg_Pub.ADD;

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
2061: --commented to allow duplicate MR's in a visit

Line 2074: Fnd_Msg_Pub.ADD;

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
2078:

Line 2110: Fnd_Msg_Pub.ADD;

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: */
2114: --Dup-MR ER#6338208 - sowsubra - end

Line 2120: l_msg_count := FND_MSG_PUB.count_msg;

2116: l_item_id := p_item_id;
2117: l_org_id := p_org_id;
2118: END IF;
2119:
2120: l_msg_count := FND_MSG_PUB.count_msg;
2121: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2122: x_return_status := FND_API.G_RET_STS_ERROR;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;

Line 2159: l_msg_count := FND_MSG_PUB.count_msg;

2155: 'After calling INSERT_TASKS for Summary Task. Task Id = ' || l_task_id ||
2156: '. Return Status = ' || l_return_status);
2157: END IF;
2158:
2159: l_msg_count := FND_MSG_PUB.count_msg;
2160: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2161: IF (l_log_statement >= l_log_current_level) THEN
2162: fnd_log.string(l_log_statement,
2163: L_DEBUG_KEY,

Line 2215: Fnd_Msg_Pub.ADD;

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;
2219: CLOSE c_stage;

Line 2261: l_msg_count := FND_MSG_PUB.count_msg;

2257: 'After calling INSERT_TASKS for Simple Task. Task Id = ' || l_task_id ||
2258: '. Visit ID = ' || l_visit_id);
2259: END IF;
2260:
2261: l_msg_count := FND_MSG_PUB.count_msg;
2262: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2263: IF (l_log_statement >= l_log_current_level) THEN
2264: fnd_log.string(l_log_statement,
2265: L_DEBUG_KEY,

Line 2304: l_msg_count := FND_MSG_PUB.count_msg;

2300: fnd_log.string(l_log_statement,
2301: L_DEBUG_KEY,
2302: 'PLANNED TASK - After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
2303: END IF;
2304: l_msg_count := FND_MSG_PUB.count_msg;
2305: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2306: X_return_status := FND_API.G_RET_STS_ERROR;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;

Line 2379: Fnd_Msg_Pub.ADD;

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:
2383: OPEN c_child (p_visit_task_id, p_visit_id);

Line 2394: Fnd_Msg_Pub.ADD;

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;
2398: EXIT WHEN c_child%NOTFOUND;

Line 2455: Fnd_Msg_Pub.ADD;

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:
2459: OPEN c_child (p_visit_task_id, p_visit_id);

Line 2471: Fnd_Msg_Pub.ADD;

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;
2475:

Line 2604: FND_MSG_PUB.ADD;

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,
2608: 'Visit id not found in AHL_VISITS_B table');

Line 2613: FND_MSG_PUB.ADD;

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,
2617: 'price list can not be associated because service request id is not associated to visit');

Line 2631: FND_MSG_PUB.ADD;

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,
2635: 'Associated Service Request ' || l_service_request_id ||

Line 2641: FND_MSG_PUB.ADD;

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,
2645: 'Customer id for corresponding service request ' || l_service_request_id || ' is null.');

Line 2661: FND_MSG_PUB.ADD;

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,
2665: 'Valid price list not found with price list name ' || p_price_list_name);

Line 2978: FND_MSG_PUB.ADD;

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,
2982: 'No curency is defined for the organization of the visit. l_org_id = ' || l_org_id);