DBA Data[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on FND_MESSAGE

Line 755: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');

751:
752: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN
753: x_return_status := Fnd_Api.g_ret_sts_error;
754: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
755: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');
756: Fnd_Msg_Pub.ADD;
757: END IF;
758: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
759: x_return_status := Fnd_Api.g_ret_sts_error;

Line 761: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');

757: END IF;
758: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
759: x_return_status := Fnd_Api.g_ret_sts_error;
760: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
761: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');
762: Fnd_Msg_Pub.ADD;
763: END IF;
764: ELSE
765: x_return_status := Fnd_Api.g_ret_sts_error;

Line 767: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');

763: END IF;
764: ELSE
765: x_return_status := Fnd_Api.g_ret_sts_error;
766: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
767: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');
768: Fnd_Msg_Pub.ADD;
769: END IF;
770: END IF;
771: END IF;

Line 1158: Fnd_Message.set_name ('AHL', 'AHL_PROJECT_STATUS_NOT_SET');

1154:
1155: /*
1156: IF (l_project_status_code IS NULL) THEN
1157: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1158: Fnd_Message.set_name ('AHL', 'AHL_PROJECT_STATUS_NOT_SET');
1159: Fnd_Msg_Pub.ADD;
1160: END IF;
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;

Line 1182: Fnd_Message.SET_NAME('AHL','AHL_PRJ_NEW_TXN_DISABLED');

1178: 'Create New Transaction Flag = ' || l_new_txns_flag);
1179: END IF;
1180: IF (l_new_txns_flag = 'N') THEN
1181: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1182: Fnd_Message.SET_NAME('AHL','AHL_PRJ_NEW_TXN_DISABLED');
1183: Fnd_Message.SET_TOKEN('PRJ_STATUS', l_project_status_code);
1184: Fnd_Msg_Pub.ADD;
1185: END IF;
1186: RAISE Fnd_Api.G_EXC_ERROR;

Line 1183: Fnd_Message.SET_TOKEN('PRJ_STATUS', l_project_status_code);

1179: END IF;
1180: IF (l_new_txns_flag = 'N') THEN
1181: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1182: Fnd_Message.SET_NAME('AHL','AHL_PRJ_NEW_TXN_DISABLED');
1183: Fnd_Message.SET_TOKEN('PRJ_STATUS', l_project_status_code);
1184: Fnd_Msg_Pub.ADD;
1185: END IF;
1186: RAISE Fnd_Api.G_EXC_ERROR;
1187: END IF;

Line 1499: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJECT_NOT_UNIQUE');

1495: END IF; -- End of x_return_status = 'S'
1496: ELSE -- Else of l_project_flag = 'Y'
1497: x_return_status := Fnd_Api.g_ret_sts_error;
1498: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1499: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJECT_NOT_UNIQUE');
1500: Fnd_Msg_Pub.ADD;
1501: END IF;
1502: END IF; -- End of l_project_flag = 'Y'
1503: END IF; --- End of l_chk_project = 'Y'

Line 1507: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');

1503: END IF; --- End of l_chk_project = 'Y'
1504: ELSIF c_visit_rec.START_DATE_TIME IS NULL or c_visit_rec.START_DATE_TIME = Fnd_Api.G_MISS_DATE THEN
1505: x_return_status := Fnd_Api.g_ret_sts_error;
1506: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1507: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');
1508: Fnd_Msg_Pub.ADD;
1509: END IF;
1510: END IF; -- End of Start Time and Department null Check
1511:

Line 1945: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');

1941: END IF;
1942: ELSIF c_visit_rec.START_DATE_TIME IS NULL or c_visit_rec.START_DATE_TIME = Fnd_Api.G_MISS_DATE THEN
1943: x_return_status := Fnd_Api.g_ret_sts_error;
1944: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1945: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');
1946: Fnd_Msg_Pub.ADD;
1947: END IF;
1948: END IF; -- check for visit's start date time
1949: END IF; -- l_chk_project

Line 2090: Fnd_Message.SET_NAME('AHL','AHL_VWP_PROJ_PJM_PARA');

2086: FETCH c_Project INTO l_count;
2087: CLOSE c_Project;
2088:
2089: IF l_count > 0 THEN -- merge process for 11.5 10 bug# 3470801 fix on CMRDV10P
2090: Fnd_Message.SET_NAME('AHL','AHL_VWP_PROJ_PJM_PARA');
2091: Fnd_Message.SET_TOKEN('VISIT_NUMBER', c_visit_rec.Visit_Number);
2092: Fnd_Msg_Pub.ADD;
2093: RAISE Fnd_Api.G_EXC_ERROR;
2094: ELSE

Line 2091: Fnd_Message.SET_TOKEN('VISIT_NUMBER', c_visit_rec.Visit_Number);

2087: CLOSE c_Project;
2088:
2089: IF l_count > 0 THEN -- merge process for 11.5 10 bug# 3470801 fix on CMRDV10P
2090: Fnd_Message.SET_NAME('AHL','AHL_VWP_PROJ_PJM_PARA');
2091: Fnd_Message.SET_TOKEN('VISIT_NUMBER', c_visit_rec.Visit_Number);
2092: Fnd_Msg_Pub.ADD;
2093: RAISE Fnd_Api.G_EXC_ERROR;
2094: ELSE
2095: IF (l_log_statement >= l_log_current_level) THEN

Line 2286: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');

2282: END IF;
2283:
2284: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
2285:
2286: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
2287: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2288: Fnd_Msg_Pub.ADD;
2289:
2290: END IF;

Line 2287: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2283:
2284: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
2285:
2286: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
2287: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2288: Fnd_Msg_Pub.ADD;
2289:
2290: END IF;
2291:

Line 2295: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');

2291:
2292: IF TRUNC(c_route_rec.end_date_active) IS NOT NULL THEN
2293: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
2294:
2295: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
2296: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2297: Fnd_Msg_Pub.ADD;
2298:
2299: END IF;

Line 2296: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2292: IF TRUNC(c_route_rec.end_date_active) IS NOT NULL THEN
2293: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
2294:
2295: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
2296: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2297: Fnd_Msg_Pub.ADD;
2298:
2299: END IF;
2300: END IF;

Line 2306: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');

2302: ELSE -- Else of c_route%FOUND check
2303:
2304: CLOSE c_route;
2305:
2306: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
2307: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2308: Fnd_Msg_Pub.ADD;
2309:
2310: END IF; -- End of c_route%FOUND check

Line 2307: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2303:
2304: CLOSE c_route;
2305:
2306: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
2307: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2308: Fnd_Msg_Pub.ADD;
2309:
2310: END IF; -- End of c_route%FOUND check
2311:

Line 2327: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');

2323: 'Checking MR Start and End Dates');
2324: END IF;
2325:
2326: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
2327: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
2328: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2329: Fnd_Msg_Pub.ADD;
2330:
2331: END IF;

Line 2328: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2324: END IF;
2325:
2326: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
2327: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
2328: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2329: Fnd_Msg_Pub.ADD;
2330:
2331: END IF;
2332: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN

Line 2335: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');

2331: END IF;
2332: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN
2333: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
2334:
2335: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
2336: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2337: Fnd_Msg_Pub.ADD;
2338:
2339: END IF;

Line 2336: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2332: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN
2333: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
2334:
2335: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
2336: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2337: Fnd_Msg_Pub.ADD;
2338:
2339: END IF;
2340: END IF;

Line 2345: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');

2341:
2342: ELSE -- Else for c_mr_header%FOUND check
2343: CLOSE c_mr_header;
2344:
2345: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
2346: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2347: Fnd_Msg_Pub.ADD;
2348:
2349: END IF; -- End of c_mr_header%FOUND check

Line 2346: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);

2342: ELSE -- Else for c_mr_header%FOUND check
2343: CLOSE c_mr_header;
2344:
2345: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
2346: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
2347: Fnd_Msg_Pub.ADD;
2348:
2349: END IF; -- End of c_mr_header%FOUND check
2350: END IF; -- End of p_mr_route_id IS NOT NULL check

Line 2651: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ST_DATE');

2647: L_DEBUG_KEY,
2648: 'Visit Start Date is null.');
2649: END IF;
2650: -- By shbhanda 05/21/04 for TC changes
2651: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ST_DATE');
2652: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2653: Fnd_Msg_Pub.ADD;
2654: END IF;
2655:

Line 2652: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2648: 'Visit Start Date is null.');
2649: END IF;
2650: -- By shbhanda 05/21/04 for TC changes
2651: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ST_DATE');
2652: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2653: Fnd_Msg_Pub.ADD;
2654: END IF;
2655:
2656: -- To check visit's status is not null and it should be only planning or partially released

Line 2664: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NOT_PLANNING'); -- **** IMPortant uPDATE FOR PARTIALLY RELEASED

2660: fnd_log.string(l_log_statement,
2661: L_DEBUG_KEY,
2662: 'Visit Status Code is not Planning/Partially Released.');
2663: END IF;
2664: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NOT_PLANNING'); -- **** IMPortant uPDATE FOR PARTIALLY RELEASED
2665: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2666: Fnd_Msg_Pub.ADD;
2667: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code is not Planning or Partially Released' ;
2668: l_error_tbl(j).Msg_Index := j;

Line 2665: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2661: L_DEBUG_KEY,
2662: 'Visit Status Code is not Planning/Partially Released.');
2663: END IF;
2664: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NOT_PLANNING'); -- **** IMPortant uPDATE FOR PARTIALLY RELEASED
2665: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2666: Fnd_Msg_Pub.ADD;
2667: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code is not Planning or Partially Released' ;
2668: l_error_tbl(j).Msg_Index := j;
2669: l_error_tbl(j).Msg_Data := l_temp;

Line 2680: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');

2676: fnd_log.string(l_log_statement,
2677: L_DEBUG_KEY,
2678: 'Visit Status Code is Planning and Visit Start Date is less than sysdate. ');
2679: END IF;
2680: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
2681: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2682: Fnd_Msg_Pub.ADD;
2683: /* l_error_tbl(j).Msg_Index := j;
2684: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',

Line 2681: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2677: L_DEBUG_KEY,
2678: 'Visit Status Code is Planning and Visit Start Date is less than sysdate. ');
2679: END IF;
2680: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
2681: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2682: Fnd_Msg_Pub.ADD;
2683: /* l_error_tbl(j).Msg_Index := j;
2684: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',
2685: NAMEIN => 'AHL_VWP_START_DATE_LT_SYS')

Line 2684: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',

2680: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
2681: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2682: Fnd_Msg_Pub.ADD;
2683: /* l_error_tbl(j).Msg_Index := j;
2684: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',
2685: NAMEIN => 'AHL_VWP_START_DATE_LT_SYS')
2686: ,'VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
2687: j := j + 1; */
2688: END IF;

Line 2696: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_STATUS');

2692: fnd_log.string(l_log_statement,
2693: L_DEBUG_KEY,
2694: 'Visit Status Code is null.');
2695: END IF;
2696: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_STATUS');
2697: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2698: Fnd_Msg_Pub.ADD;
2699:
2700: /*l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code Missing' ;

Line 2697: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2693: L_DEBUG_KEY,
2694: 'Visit Status Code is null.');
2695: END IF;
2696: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_STATUS');
2697: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2698: Fnd_Msg_Pub.ADD;
2699:
2700: /*l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code Missing' ;
2701: l_error_tbl(j).Msg_Index := j;

Line 2714: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ORG');

2710: L_DEBUG_KEY,
2711: 'Visit Organization is null.');
2712: END IF;
2713:
2714: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ORG');
2715: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2716: Fnd_Msg_Pub.ADD;
2717:
2718: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Organization Missing' ;

Line 2715: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2711: 'Visit Organization is null.');
2712: END IF;
2713:
2714: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ORG');
2715: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2716: Fnd_Msg_Pub.ADD;
2717:
2718: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Organization Missing' ;
2719: l_error_tbl(j).Msg_Index := j;

Line 2732: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT');

2728: L_DEBUG_KEY,
2729: 'Visit Department is null.');
2730: END IF;
2731:
2732: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT');
2733: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2734: Fnd_Msg_Pub.ADD;
2735:
2736: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Department Missing';

Line 2733: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2729: 'Visit Department is null.');
2730: END IF;
2731:
2732: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT');
2733: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2734: Fnd_Msg_Pub.ADD;
2735:
2736: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Department Missing';
2737: l_error_tbl(j).Msg_Index := j;

Line 2751: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PLN_END_DT');

2747: L_DEBUG_KEY,
2748: 'Visit Plan End Date is null.');
2749: END IF;
2750:
2751: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PLN_END_DT');
2752: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2753: Fnd_Msg_Pub.ADD;
2754:
2755: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;

Line 2752: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2748: 'Visit Plan End Date is null.');
2749: END IF;
2750:
2751: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PLN_END_DT');
2752: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2753: Fnd_Msg_Pub.ADD;
2754:
2755: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;
2756: l_error_tbl(j).Msg_Index := j;

Line 2774: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PRIM_PLAN');

2770: L_DEBUG_KEY,
2771: 'Visit has 0 Simulations.');
2772: END IF;
2773:
2774: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PRIM_PLAN');
2775: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2776: Fnd_Msg_Pub.ADD;
2777: END IF;
2778: END IF;

Line 2775: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2771: 'Visit has 0 Simulations.');
2772: END IF;
2773:
2774: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PRIM_PLAN');
2775: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2776: Fnd_Msg_Pub.ADD;
2777: END IF;
2778: END IF;
2779:

Line 2805: Fnd_Message.SET_NAME('AHL','AHL_VWP_TYPE_CODE_NOT_EXISTS');

2801: 'After calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
2802: END IF;
2803:
2804: IF NVL(l_return_status, 'X') <> 'S' THEN
2805: Fnd_Message.SET_NAME('AHL','AHL_VWP_TYPE_CODE_NOT_EXISTS');
2806: Fnd_Msg_Pub.ADD;
2807: RAISE Fnd_Api.G_EXC_ERROR;
2808: END IF;
2809: END IF;

Line 2840: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_ACTIVE');

2836: FETCH c_instance INTO l_count;
2837: CLOSE c_instance;
2838: IF l_count = 0 THEN
2839:
2840: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_ACTIVE');
2841: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2842: Fnd_Msg_Pub.ADD;
2843: END IF;
2844: END IF;

Line 2841: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2837: CLOSE c_instance;
2838: IF l_count = 0 THEN
2839:
2840: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_ACTIVE');
2841: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2842: Fnd_Msg_Pub.ADD;
2843: END IF;
2844: END IF;
2845: /*sowsubra - part-chgER - 18 July, 2007 - start*/

Line 2852: FND_MESSAGE.Set_Name('AHL','AHL_VWP_VST_INST_ITM_CHNGD');

2848: fnd_log.string(l_log_statement,
2849: L_DEBUG_KEY,
2850: 'Instance is no longer associated with this item, please check..');
2851: END IF;
2852: FND_MESSAGE.Set_Name('AHL','AHL_VWP_VST_INST_ITM_CHNGD');
2853: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);
2854: Fnd_Msg_Pub.ADD;
2855: END IF;
2856: /*sowsubra - part-chgER - end*/

Line 2853: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);

2849: L_DEBUG_KEY,
2850: 'Instance is no longer associated with this item, please check..');
2851: END IF;
2852: FND_MESSAGE.Set_Name('AHL','AHL_VWP_VST_INST_ITM_CHNGD');
2853: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);
2854: Fnd_Msg_Pub.ADD;
2855: END IF;
2856: /*sowsubra - part-chgER - end*/
2857: END IF; --c_visit_rec.item_instance_id IS NOT NULL

Line 2875: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');

2871: L_DEBUG_KEY,
2872: c_uc_status_rec.name || ' UC status is invalid: '|| c_uc_status_rec.uc_status);
2873: END IF;
2874:
2875: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
2876: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2877: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
2878: Fnd_Msg_Pub.ADD;
2879: END IF;

Line 2876: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2872: c_uc_status_rec.name || ' UC status is invalid: '|| c_uc_status_rec.uc_status);
2873: END IF;
2874:
2875: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
2876: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2877: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
2878: Fnd_Msg_Pub.ADD;
2879: END IF;
2880: END IF;

Line 2877: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);

2873: END IF;
2874:
2875: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
2876: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2877: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
2878: Fnd_Msg_Pub.ADD;
2879: END IF;
2880: END IF;
2881:

Line 2916: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_INST_NO_ACTIVE');

2912: FETCH c_instance INTO l_count;
2913: CLOSE c_instance;
2914:
2915: IF l_count = 0 THEN
2916: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_INST_NO_ACTIVE');
2917: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
2918: Fnd_Msg_Pub.ADD;
2919: END IF;
2920: END IF;

Line 2917: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);

2913: CLOSE c_instance;
2914:
2915: IF l_count = 0 THEN
2916: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_INST_NO_ACTIVE');
2917: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
2918: Fnd_Msg_Pub.ADD;
2919: END IF;
2920: END IF;
2921: ELSE

Line 2927: FND_MESSAGE.Set_Name('AHL','AHL_VWP_TSK_INST_ITM_CHNGD');

2923: fnd_log.string(l_log_statement,
2924: L_DEBUG_KEY,
2925: 'Instance is no longer associated with this item, please check..');
2926: END IF;
2927: FND_MESSAGE.Set_Name('AHL','AHL_VWP_TSK_INST_ITM_CHNGD');
2928: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);
2929: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
2930: FND_MSG_PUB.ADD;
2931: END IF;

Line 2928: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);

2924: L_DEBUG_KEY,
2925: 'Instance is no longer associated with this item, please check..');
2926: END IF;
2927: FND_MESSAGE.Set_Name('AHL','AHL_VWP_TSK_INST_ITM_CHNGD');
2928: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);
2929: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
2930: FND_MSG_PUB.ADD;
2931: END IF;
2932: END IF; -- c_task_rec.instance_id is not null

Line 2929: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);

2925: 'Instance is no longer associated with this item, please check..');
2926: END IF;
2927: FND_MESSAGE.Set_Name('AHL','AHL_VWP_TSK_INST_ITM_CHNGD');
2928: Fnd_Message.Set_Token('INST_NUM', c_inst_item_rec.instance_number);
2929: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
2930: FND_MSG_PUB.ADD;
2931: END IF;
2932: END IF; -- c_task_rec.instance_id is not null
2933: /*sowsubra - part-chgER - end*/

Line 2950: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');

2946:
2947: --BEGIN: jeli added for bug 3777720
2948: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_visit_rec.item_instance_id)= FND_API.G_RET_STS_ERROR) THEN
2949: --END: jeli added for bug 3777720
2950: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2951: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
2952: Fnd_Msg_Pub.ADD;
2953: END IF;
2954: END IF;

Line 2951: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);

2947: --BEGIN: jeli added for bug 3777720
2948: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_visit_rec.item_instance_id)= FND_API.G_RET_STS_ERROR) THEN
2949: --END: jeli added for bug 3777720
2950: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2951: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
2952: Fnd_Msg_Pub.ADD;
2953: END IF;
2954: END IF;
2955:

Line 2967: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');

2963: -- IF l_check_flag = 'N' THEN
2964: --BEGIN: jeli added for bug 3777720
2965: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
2966: --END: jeli added for bug 3777720
2967: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2968: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2969: Fnd_Msg_Pub.ADD;
2970: END IF;
2971: END IF;

Line 2968: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

2964: --BEGIN: jeli added for bug 3777720
2965: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
2966: --END: jeli added for bug 3777720
2967: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
2968: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
2969: Fnd_Msg_Pub.ADD;
2970: END IF;
2971: END IF;
2972: END LOOP;

Line 3116: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTDT_GT_PLNDT');

3112: fnd_log.string(l_log_statement,
3113: L_DEBUG_KEY,
3114: 'Check visit end time and plan end time');
3115: END IF;
3116: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTDT_GT_PLNDT');
3117: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3118: Fnd_Msg_Pub.ADD;
3119: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Actual end date exceeds planned end date.' ;
3120: l_error_tbl(j).Msg_Index := j;

Line 3117: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3113: L_DEBUG_KEY,
3114: 'Check visit end time and plan end time');
3115: END IF;
3116: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTDT_GT_PLNDT');
3117: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3118: Fnd_Msg_Pub.ADD;
3119: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Actual end date exceeds planned end date.' ;
3120: l_error_tbl(j).Msg_Index := j;
3121: l_error_tbl(j).Msg_Data := l_temp;

Line 3136: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTHR_GT_PLNHR');

3132: L_DEBUG_KEY,
3133: 'Check visit end hour and plan end hour');
3134: END IF;
3135: -- By shbhanda 08/04/04 for TC changes
3136: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTHR_GT_PLNHR');
3137: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3138: Fnd_Msg_Pub.ADD;
3139: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Actual end date hour exceeds planned end date hour.' ;
3140: l_error_tbl(j).Msg_Index := j;

Line 3137: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3133: 'Check visit end hour and plan end hour');
3134: END IF;
3135: -- By shbhanda 08/04/04 for TC changes
3136: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_ACTHR_GT_PLNHR');
3137: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3138: Fnd_Msg_Pub.ADD;
3139: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Actual end date hour exceeds planned end date hour.' ;
3140: l_error_tbl(j).Msg_Index := j;
3141: l_error_tbl(j).Msg_Data := l_temp;

Line 3147: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');

3143: END IF;
3144: END IF;
3145: -- Post 11.5.10 Changes by Senthil.
3146: ELSE
3147: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
3148: Fnd_Message.Set_Token('VISIT_NUMBER',
3149: c_visit_rec.VISIT_NUMBER);
3150: Fnd_Msg_Pub.ADD;
3151:

Line 3148: Fnd_Message.Set_Token('VISIT_NUMBER',

3144: END IF;
3145: -- Post 11.5.10 Changes by Senthil.
3146: ELSE
3147: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
3148: Fnd_Message.Set_Token('VISIT_NUMBER',
3149: c_visit_rec.VISIT_NUMBER);
3150: Fnd_Msg_Pub.ADD;
3151:
3152: END IF;

Line 3172: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ITEM_MR_RT'); --***** change this

3168: OPEN c_check (c_task_rec.inventory_item_id, c_task_rec.mr_route_id);
3169: FETCH c_check INTO l_count;
3170: CLOSE c_check;
3171: IF l_count = 0 THEN
3172: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ITEM_MR_RT'); --***** change this
3173: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3174: Fnd_Msg_Pub.ADD;
3175: END IF;
3176: ELSE */

Line 3173: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3169: FETCH c_check INTO l_count;
3170: CLOSE c_check;
3171: IF l_count = 0 THEN
3172: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ITEM_MR_RT'); --***** change this
3173: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3174: Fnd_Msg_Pub.ADD;
3175: END IF;
3176: ELSE */
3177: IF c_task_rec.SERVICE_REQUEST_ID is null OR c_task_rec.UNIT_EFFECTIVITY_ID is null THEN

Line 3178: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_SR_UE'); --***** change this

3174: Fnd_Msg_Pub.ADD;
3175: END IF;
3176: ELSE */
3177: IF c_task_rec.SERVICE_REQUEST_ID is null OR c_task_rec.UNIT_EFFECTIVITY_ID is null THEN
3178: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_SR_UE'); --***** change this
3179: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3180: Fnd_Msg_Pub.ADD;
3181: END IF; --Added by jeli on 07/26/04 when merging code otherwise it couldn't pass compilation
3182: END IF; --- End Changes made by VSUNDARA for Production - SR Integration

Line 3179: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3175: END IF;
3176: ELSE */
3177: IF c_task_rec.SERVICE_REQUEST_ID is null OR c_task_rec.UNIT_EFFECTIVITY_ID is null THEN
3178: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_SR_UE'); --***** change this
3179: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3180: Fnd_Msg_Pub.ADD;
3181: END IF; --Added by jeli on 07/26/04 when merging code otherwise it couldn't pass compilation
3182: END IF; --- End Changes made by VSUNDARA for Production - SR Integration
3183: END IF;

Line 3193: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_DURATION');

3189: fnd_log.string(l_log_statement,
3190: L_DEBUG_KEY,
3191: 'Unassociated Task. Task Duration is null');
3192: END IF;
3193: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_DURATION');
3194: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3195: Fnd_Msg_Pub.ADD;
3196: END IF; -- End for c_task_rec.task_type_code check
3197:

Line 3194: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);

3190: L_DEBUG_KEY,
3191: 'Unassociated Task. Task Duration is null');
3192: END IF;
3193: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_DURATION');
3194: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3195: Fnd_Msg_Pub.ADD;
3196: END IF; -- End for c_task_rec.task_type_code check
3197:
3198: -- To find all visit tasks must be associated to an item and item instance.

Line 3205: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_SERIAL');

3201: fnd_log.string(l_log_statement,
3202: L_DEBUG_KEY,
3203: 'Check Task Serial');
3204: END IF;
3205: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_SERIAL');
3206: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3207: Fnd_Msg_Pub.ADD;
3208: END IF;
3209:

Line 3206: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);

3202: L_DEBUG_KEY,
3203: 'Check Task Serial');
3204: END IF;
3205: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_SERIAL');
3206: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3207: Fnd_Msg_Pub.ADD;
3208: END IF;
3209:
3210: IF c_task_rec.inventory_item_id IS NULL THEN

Line 3216: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ITEM');

3212: fnd_log.string(l_log_statement,
3213: L_DEBUG_KEY,
3214: 'Task Inventory Item is null.');
3215: END IF;
3216: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ITEM');
3217: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3218: Fnd_Msg_Pub.ADD;
3219: END IF;
3220:

Line 3217: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);

3213: L_DEBUG_KEY,
3214: 'Task Inventory Item is null.');
3215: END IF;
3216: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ITEM');
3217: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
3218: Fnd_Msg_Pub.ADD;
3219: END IF;
3220:
3221: -- Begin changes by rnahata for Bug 6448678

Line 3248: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');

3244:
3245: ELSE
3246:
3247: IF l_count = 0 THEN
3248: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
3249: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3250: Fnd_Msg_Pub.ADD;
3251: END IF;
3252:

Line 3249: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3245: ELSE
3246:
3247: IF l_count = 0 THEN
3248: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
3249: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3250: Fnd_Msg_Pub.ADD;
3251: END IF;
3252:
3253: IF l_chk_flag = 'Y' THEN

Line 3254: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_RT_EXISTS');

3250: Fnd_Msg_Pub.ADD;
3251: END IF;
3252:
3253: IF l_chk_flag = 'Y' THEN
3254: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_RT_EXISTS');
3255: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3256: Fnd_Msg_Pub.ADD;
3257: END IF;
3258:

Line 3255: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3251: END IF;
3252:
3253: IF l_chk_flag = 'Y' THEN
3254: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_RT_EXISTS');
3255: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3256: Fnd_Msg_Pub.ADD;
3257: END IF;
3258:
3259: IF l_dept_flag = 'Y' THEN

Line 3278: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');

3274: fnd_log.string(l_log_statement,
3275: L_DEBUG_KEY,
3276: 'Task Dept Count ' || l_dept);
3277: END IF;
3278: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
3279: Fnd_Message.Set_Token('TASK_NUMBER', c_dept_tsk_rec.VISIT_TASK_NUMBER);
3280: Fnd_Msg_Pub.ADD;
3281: END IF;
3282: CLOSE c_dept;

Line 3279: Fnd_Message.Set_Token('TASK_NUMBER', c_dept_tsk_rec.VISIT_TASK_NUMBER);

3275: L_DEBUG_KEY,
3276: 'Task Dept Count ' || l_dept);
3277: END IF;
3278: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
3279: Fnd_Message.Set_Token('TASK_NUMBER', c_dept_tsk_rec.VISIT_TASK_NUMBER);
3280: Fnd_Msg_Pub.ADD;
3281: END IF;
3282: CLOSE c_dept;
3283: END IF;

Line 3297: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TASK_NULL');

3293: L_DEBUG_KEY,
3294: 'No Task Found for the Visit');
3295: END IF;
3296:
3297: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TASK_NULL');
3298: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3299: Fnd_Msg_Pub.ADD;
3300:
3301: END IF;

Line 3298: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);

3294: 'No Task Found for the Visit');
3295: END IF;
3296:
3297: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TASK_NULL');
3298: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
3299: Fnd_Msg_Pub.ADD;
3300:
3301: END IF;
3302: END IF;

Line 4237: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');

4233: END IF;
4234:
4235: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
4236: IF l_visit_end_time > get_vst_status_and_date_rec.close_date_time THEN
4237: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
4238: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
4239: Fnd_Msg_Pub.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END IF;

Line 4238: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);

4234:
4235: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
4236: IF l_visit_end_time > get_vst_status_and_date_rec.close_date_time THEN
4237: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
4238: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
4239: Fnd_Msg_Pub.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END IF;
4242: END IF;

Line 5134: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');

5130: END IF;
5131:
5132: -- Check for Required Parameters
5133: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
5134: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
5135: FND_MSG_PUB.ADD;
5136: IF (l_log_unexpected >= l_log_current_level)THEN
5137: fnd_log.string
5138: (

Line 5414: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');

5410:
5411: --Validate visit
5412: IF (nvl(l_validate_visit,0) = 0) THEN
5413: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
5414: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
5415: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
5416: FND_MSG_PUB.ADD;
5417: END IF;
5418: RAISE FND_API.G_EXC_ERROR;

Line 5415: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);

5411: --Validate visit
5412: IF (nvl(l_validate_visit,0) = 0) THEN
5413: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
5414: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
5415: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
5416: FND_MSG_PUB.ADD;
5417: END IF;
5418: RAISE FND_API.G_EXC_ERROR;
5419: END IF;

Line 5426: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VST_STATUS_INVALID');

5422: OPEN c_visit_info(p_visit_id);
5423: FETCH c_visit_info INTO c_visit_info_rec;
5424: IF c_visit_info%NOTFOUND THEN
5425: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
5426: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VST_STATUS_INVALID');
5427: FND_MSG_PUB.ADD;
5428: END IF;
5429: CLOSE c_visit_info;
5430: RAISE FND_API.G_EXC_ERROR;

Line 5436: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VISIT_NULL');

5432: CLOSE c_visit_info;
5433: --If visit_id is null
5434: ELSE
5435: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
5436: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VISIT_NULL');
5437: FND_MSG_PUB.ADD;
5438: END IF;
5439: RAISE FND_API.G_EXC_ERROR;
5440: END IF;

Line 5445: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_NO_TASK_SEL');

5441:
5442: --No tasks selected
5443: IF (p_tasks_tbl.COUNT = 0) THEN
5444: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
5445: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_NO_TASK_SEL');
5446: FND_MSG_PUB.ADD;
5447: END IF;
5448: RAISE FND_API.G_EXC_ERROR;
5449: END IF;

Line 5926: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_TSK_ID');

5922: 'Task is either not in planning status or Invalid - ' ||
5923: p_tasks_tbl(i).visit_task_id);
5924: END IF;
5925: CLOSE c_task_dtls;
5926: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_TSK_ID');
5927: Fnd_Message.SET_TOKEN('TASK_ID', p_tasks_tbl(i).visit_task_id);
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_ERROR;
5930: END IF;

Line 5927: Fnd_Message.SET_TOKEN('TASK_ID', p_tasks_tbl(i).visit_task_id);

5923: p_tasks_tbl(i).visit_task_id);
5924: END IF;
5925: CLOSE c_task_dtls;
5926: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_TSK_ID');
5927: Fnd_Message.SET_TOKEN('TASK_ID', p_tasks_tbl(i).visit_task_id);
5928: FND_MSG_PUB.ADD;
5929: RAISE FND_API.G_EXC_ERROR;
5930: END IF;
5931: CLOSE c_task_dtls;

Line 5944: FND_MESSAGE.SET_NAME(G_PM_PRODUCT_CODE,'AHL_VWP_PET_EXCD_SCT');

5940: L_DEBUG_KEY,
5941: 'Planned end time of the task is exceeding the scheduled completion time of the master WO: ' ||
5942: c_tsk_dtls_rec.visit_task_number);
5943: END IF;
5944: FND_MESSAGE.SET_NAME(G_PM_PRODUCT_CODE,'AHL_VWP_PET_EXCD_SCT');
5945: FND_MSG_PUB.ADD;
5946: RAISE FND_API.G_EXC_ERROR;
5947: END IF;
5948:

Line 6021: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_SUM_TSK');

6017: L_DEBUG_KEY,
6018: 'Select the summary task for the task: ' ||
6019: c_tsk_dtls_rec.visit_task_number);
6020: END IF;
6021: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_SUM_TSK');
6022: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_tsk_dtls_rec.visit_task_number);
6023: FND_MSG_PUB.ADD;
6024: RAISE FND_API.G_EXC_ERROR;
6025: END IF;

Line 6022: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_tsk_dtls_rec.visit_task_number);

6018: 'Select the summary task for the task: ' ||
6019: c_tsk_dtls_rec.visit_task_number);
6020: END IF;
6021: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_SUM_TSK');
6022: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_tsk_dtls_rec.visit_task_number);
6023: FND_MSG_PUB.ADD;
6024: RAISE FND_API.G_EXC_ERROR;
6025: END IF;
6026:

Line 6087: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');

6083: ' is technically dependent has not been selected.'||
6084: 'Please select the technically dependent tasks too');
6085: END IF;
6086: CLOSE get_parent_task_dependencies;
6087: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
6088: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_ERROR;
6091: END IF; --parent task not selected

Line 6088: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);

6084: 'Please select the technically dependent tasks too');
6085: END IF;
6086: CLOSE get_parent_task_dependencies;
6087: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
6088: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_ERROR;
6091: END IF; --parent task not selected
6092: END IF;

Line 6125: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');

6121: 'Child tasks on which the task ' || x_tasks_tbl(i).visit_task_number || ' is technically dependent has not been selected.'||
6122: 'Please select the technically dependent tasks too');
6123: END IF;
6124: CLOSE get_child_task_dependencies;
6125: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
6126: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_ERROR;
6129: END IF; --curr task not selected

Line 6126: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);

6122: 'Please select the technically dependent tasks too');
6123: END IF;
6124: CLOSE get_child_task_dependencies;
6125: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
6126: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_ERROR;
6129: END IF; --curr task not selected
6130: END IF;

Line 6994: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_HDR_UNIT_QRNT');

6990: -- If the Visit header has an instance id, check for the corresponding Unit
6991: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
6992: IF l_quarantined = FND_API.G_TRUE THEN
6993: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
6994: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_HDR_UNIT_QRNT');
6995: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
6996: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
6997: Fnd_Msg_Pub.ADD;
6998:

Line 6996: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);

6992: IF l_quarantined = FND_API.G_TRUE THEN
6993: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
6994: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_HDR_UNIT_QRNT');
6995: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
6996: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
6997: Fnd_Msg_Pub.ADD;
6998:
6999: IF (l_log_statement >= l_log_current_level)THEN
7000: fnd_log.string (l_log_statement,L_DEBUG_KEY,'Unit : '||l_unit_name || ' is quarantined, Error message added');

Line 7011: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_TSK_UNIT_QRNT');

7007: FETCH c_get_tasknumbers INTO l_task_number,l_instance_id;
7008: EXIT WHEN c_get_tasknumbers%NOTFOUND;
7009: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
7010: IF l_quarantined = FND_API.G_TRUE THEN
7011: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_TSK_UNIT_QRNT');
7012: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
7013: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);
7014: Fnd_Msg_Pub.ADD;
7015: IF (l_log_statement >= l_log_current_level)THEN

Line 7013: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);

7009: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
7010: IF l_quarantined = FND_API.G_TRUE THEN
7011: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_TSK_UNIT_QRNT');
7012: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
7013: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);
7014: Fnd_Msg_Pub.ADD;
7015: IF (l_log_statement >= l_log_current_level)THEN
7016: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Unit for this task: '||l_task_number||' is quarantined');
7017: END IF;

Line 7190: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');

7186: END IF;
7187:
7188: -- Check for Required Parameters
7189: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
7190: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
7191: FND_MSG_PUB.ADD;
7192: IF (l_log_unexpected >= l_log_current_level)THEN
7193: fnd_log.string(l_log_unexpected,L_DEBUG_KEY,'Visit id is mandatory but found null in input');
7194: END IF;

Line 7199: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_UE_INPUT_MISS');

7195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7196: END IF;
7197:
7198: IF(p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM) THEN
7199: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_UE_INPUT_MISS');
7200: FND_MSG_PUB.ADD;
7201: IF (l_log_unexpected >= l_log_current_level)THEN
7202: fnd_log.string(l_log_unexpected,L_DEBUG_KEY,'Unit Effectivity id is mandatory but found null in input ');
7203: END IF;

Line 7262: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');

7258: p_reset_sysdate_flag => FND_API.G_TRUE);
7259: END LOOP;
7260: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
7261: IF l_visit_end_time > c_visit_rec.close_date_time THEN
7262: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
7263: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
7264: Fnd_Msg_Pub.ADD;
7265: x_return_status := l_validate_error;
7266: END IF;

Line 7263: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);

7259: END LOOP;
7260: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
7261: IF l_visit_end_time > c_visit_rec.close_date_time THEN
7262: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
7263: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
7264: Fnd_Msg_Pub.ADD;
7265: x_return_status := l_validate_error;
7266: END IF;
7267: END IF;

Line 7287: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');

7283: -- status with end date exceeding visit master WO end date, then MR tasks cannot be created
7284: IF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
7285: x_return_status := l_validate_error;
7286: -- Error Message
7287: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
7288: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
7289: FND_MSG_PUB.ADD;
7290: END IF;
7291: END IF;

Line 7288: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);

7284: IF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
7285: x_return_status := l_validate_error;
7286: -- Error Message
7287: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
7288: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
7289: FND_MSG_PUB.ADD;
7290: END IF;
7291: END IF;
7292:

Line 8424: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');

8420: END IF;
8421: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN
8422: x_return_status := Fnd_Api.g_ret_sts_error;
8423: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8424: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');
8425: Fnd_Msg_Pub.ADD;
8426: END IF;
8427: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
8428: x_return_status := Fnd_Api.g_ret_sts_error;

Line 8430: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');

8426: END IF;
8427: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
8428: x_return_status := Fnd_Api.g_ret_sts_error;
8429: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8430: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');
8431: Fnd_Msg_Pub.ADD;
8432: END IF;
8433: ELSE
8434: x_return_status := Fnd_Api.g_ret_sts_error;

Line 8436: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');

8432: END IF;
8433: ELSE
8434: x_return_status := Fnd_Api.g_ret_sts_error;
8435: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8436: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');
8437: Fnd_Msg_Pub.ADD;
8438: END IF;
8439: END IF;
8440: END IF; -- project_task_id is null

Line 9280: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');

9276: IF (p_x_task_Tbl.COUNT > 0) THEN
9277: i := p_x_task_Tbl.FIRST;
9278: END IF;
9279: -- Error Message
9280: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
9281: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
9282: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
9283: -- yazhou Sep-15-2005 ends
9284: FND_MSG_PUB.ADD;

Line 9281: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);

9277: i := p_x_task_Tbl.FIRST;
9278: END IF;
9279: -- Error Message
9280: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
9281: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
9282: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
9283: -- yazhou Sep-15-2005 ends
9284: FND_MSG_PUB.ADD;
9285: -- yazhou 06Oct2005 starts

Line 9282: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));

9278: END IF;
9279: -- Error Message
9280: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
9281: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
9282: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
9283: -- yazhou Sep-15-2005 ends
9284: FND_MSG_PUB.ADD;
9285: -- yazhou 06Oct2005 starts
9286: -- bug fix #4658861

Line 9292: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');

9288: -- status with end date exceeding visit master WO end date, then non-routine cannot be created
9289:
9290: ELSIF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
9291: -- Error Message
9292: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
9293: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
9294: FND_MSG_PUB.ADD;
9295: -- yazhou 06Oct2005 ends
9296: ELSE

Line 9293: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);

9289:
9290: ELSIF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
9291: -- Error Message
9292: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
9293: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
9294: FND_MSG_PUB.ADD;
9295: -- yazhou 06Oct2005 ends
9296: ELSE
9297: -- Start for 11.5.10 release