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_PROJ_PROD_PVT dependencies on FND_MESSAGE

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

501: END IF;
502:
503: -- Check for Required Parameters
504: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
505: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
506: FND_MSG_PUB.ADD;
507: IF (l_log_unexpected >= l_log_current_level)THEN
508: fnd_log.string
509: (

Line 522: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');

518: --salogan::Modified the cursor fetch to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
519: OPEN c_conc_req_phase(p_visit_id);
520: FETCH c_conc_req_phase INTO l_dummy_val;
521: IF(c_conc_req_phase%FOUND) THEN
522: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526: CLOSE c_conc_req_phase;

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

530: -- If the concurrent program has been launched for plan visit, pass 'CST' as the module type so that WOs are created in DRAFT status
531: OPEN get_visit_status (p_visit_id);
532: FETCH get_visit_status INTO l_visit_status;
533: IF get_visit_status%NOTFOUND THEN
534: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
535: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
536: FND_MSG_PUB.ADD;
537: CLOSE get_visit_status;
538: RAISE FND_API.G_EXC_ERROR;

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

531: OPEN get_visit_status (p_visit_id);
532: FETCH get_visit_status INTO l_visit_status;
533: IF get_visit_status%NOTFOUND THEN
534: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
535: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
536: FND_MSG_PUB.ADD;
537: CLOSE get_visit_status;
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 561: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');

557: L_DEBUG_KEY,
558: 'Stage does not have an associated stage type ' ||
559: stage_details_rec.stage_name);
560: END IF;
561: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
562: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
563: FND_MSG_PUB.ADD;
564:
565: END LOOP;

Line 562: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);

558: 'Stage does not have an associated stage type ' ||
559: stage_details_rec.stage_name);
560: END IF;
561: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
562: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
563: FND_MSG_PUB.ADD;
564:
565: END LOOP;
566: END IF;

Line 609: --FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');

605: RAISE Fnd_Api.g_exc_error;
606: ELSE
607: --salogan::Commented the repeated code CP ER 9299910::01-JUN-2009::BEGIN
608: --IF(l_phase_code IN('R' , 'P')) THEN
609: --FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');
610: --FND_MSG_PUB.ADD;
611: --RAISE FND_API.G_EXC_ERROR;
612: --END IF;
613: --salogan::Commented the repeated code CP ER 9299910::01-JUN-2009::END

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

1317:
1318: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN
1319: x_return_status := Fnd_Api.g_ret_sts_error;
1320: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1321: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');
1322: Fnd_Msg_Pub.ADD;
1323: END IF;
1324: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
1325: x_return_status := Fnd_Api.g_ret_sts_error;

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

1323: END IF;
1324: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
1325: x_return_status := Fnd_Api.g_ret_sts_error;
1326: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1327: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');
1328: Fnd_Msg_Pub.ADD;
1329: END IF;
1330: ELSE
1331: x_return_status := Fnd_Api.g_ret_sts_error;

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

1329: END IF;
1330: ELSE
1331: x_return_status := Fnd_Api.g_ret_sts_error;
1332: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1333: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');
1334: Fnd_Msg_Pub.ADD;
1335: END IF;
1336: END IF;
1337: END IF;

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

1852:
1853: /*
1854: IF (l_project_status_code IS NULL) THEN
1855: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1856: Fnd_Message.set_name ('AHL', 'AHL_PROJECT_STATUS_NOT_SET');
1857: Fnd_Msg_Pub.ADD;
1858: END IF;
1859: RAISE FND_API.G_EXC_ERROR;
1860: END IF;

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

1876: 'Create New Transaction Flag = ' || l_new_txns_flag);
1877: END IF;
1878: IF (l_new_txns_flag = 'N') THEN
1879: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1880: Fnd_Message.SET_NAME('AHL','AHL_PRJ_NEW_TXN_DISABLED');
1881: Fnd_Message.SET_TOKEN('PRJ_STATUS', l_project_status_code);
1882: Fnd_Msg_Pub.ADD;
1883: END IF;
1884: RAISE Fnd_Api.G_EXC_ERROR;

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

1877: END IF;
1878: IF (l_new_txns_flag = 'N') THEN
1879: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1880: Fnd_Message.SET_NAME('AHL','AHL_PRJ_NEW_TXN_DISABLED');
1881: Fnd_Message.SET_TOKEN('PRJ_STATUS', l_project_status_code);
1882: Fnd_Msg_Pub.ADD;
1883: END IF;
1884: RAISE Fnd_Api.G_EXC_ERROR;
1885: END IF;

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

2302: END IF; -- End of x_return_status = 'S'
2303: ELSE -- Else of l_project_flag = 'Y'
2304: x_return_status := Fnd_Api.g_ret_sts_error;
2305: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2306: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJECT_NOT_UNIQUE');
2307: Fnd_Msg_Pub.ADD;
2308: END IF;
2309: END IF; -- End of l_project_flag = 'Y'
2310: END IF; --- End of l_chk_project = 'Y'

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

2310: END IF; --- End of l_chk_project = 'Y'
2311: ELSIF c_visit_rec.START_DATE_TIME IS NULL or c_visit_rec.START_DATE_TIME = Fnd_Api.G_MISS_DATE THEN
2312: x_return_status := Fnd_Api.g_ret_sts_error;
2313: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2314: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');
2315: Fnd_Msg_Pub.ADD;
2316: END IF;
2317: END IF; -- End of Start Time and Department null Check
2318:

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

3786: -- PRAKKUM :: PIE Changes :: 13-OCT-2010 :: END
3787: ELSIF c_visit_rec.START_DATE_TIME IS NULL or c_visit_rec.START_DATE_TIME = Fnd_Api.G_MISS_DATE THEN
3788: x_return_status := Fnd_Api.g_ret_sts_error;
3789: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
3790: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_ST_DT_MISSING');
3791: Fnd_Msg_Pub.ADD;
3792: END IF;
3793: END IF; -- check for visit's start date time
3794: END IF; -- l_chk_project

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

3931: FETCH c_Project INTO l_count;
3932: CLOSE c_Project;
3933:
3934: IF l_count > 0 THEN -- merge process for 11.5 10 bug# 3470801 fix on CMRDV10P
3935: Fnd_Message.SET_NAME('AHL','AHL_VWP_PROJ_PJM_PARA');
3936: Fnd_Message.SET_TOKEN('VISIT_NUMBER', c_visit_rec.Visit_Number);
3937: Fnd_Msg_Pub.ADD;
3938: RAISE Fnd_Api.G_EXC_ERROR;
3939: ELSE

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

3932: CLOSE c_Project;
3933:
3934: IF l_count > 0 THEN -- merge process for 11.5 10 bug# 3470801 fix on CMRDV10P
3935: Fnd_Message.SET_NAME('AHL','AHL_VWP_PROJ_PJM_PARA');
3936: Fnd_Message.SET_TOKEN('VISIT_NUMBER', c_visit_rec.Visit_Number);
3937: Fnd_Msg_Pub.ADD;
3938: RAISE Fnd_Api.G_EXC_ERROR;
3939: ELSE
3940: IF (l_log_statement >= l_log_current_level) THEN

Line 4139: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');

4135:
4136: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
4137:
4138: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4139: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
4140: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4141: Fnd_Msg_Pub.ADD;*/
4142: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4143: --bitor value of x and y=(x+y)-bitand(x,y);

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

4136: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
4137:
4138: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4139: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
4140: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4141: Fnd_Msg_Pub.ADD;*/
4142: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4143: --bitor value of x and y=(x+y)-bitand(x,y);
4144: x_valid_flag := (x_valid_flag+POWER(2,0))-bitand(x_valid_flag,POWER(2,0));

Line 4152: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');

4148: IF TRUNC(c_route_rec.end_date_active) IS NOT NULL THEN
4149: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
4150:
4151: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4152: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
4153: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4154: Fnd_Msg_Pub.ADD;*/
4155: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4156: --bitor value of x and y=(x+y)-bitand(x,y);

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

4149: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
4150:
4151: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4152: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
4153: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4154: Fnd_Msg_Pub.ADD;*/
4155: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4156: --bitor value of x and y=(x+y)-bitand(x,y);
4157: x_valid_flag := (x_valid_flag+POWER(2,1))-bitand(x_valid_flag,POWER(2,1));

Line 4167: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');

4163:
4164: CLOSE c_route;
4165:
4166: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4167: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
4168: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4169: Fnd_Msg_Pub.ADD;*/
4170: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4171: --bitor value of x and y=(x+y)-bitand(x,y);

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

4164: CLOSE c_route;
4165:
4166: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4167: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
4168: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4169: Fnd_Msg_Pub.ADD;*/
4170: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4171: --bitor value of x and y=(x+y)-bitand(x,y);
4172: x_valid_flag := (x_valid_flag+POWER(2,2))-bitand(x_valid_flag,POWER(2,2));

Line 4192: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');

4188: END IF;
4189:
4190: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
4191: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4192: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
4193: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4194: Fnd_Msg_Pub.ADD;*/
4195: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4196: --bitor value of x and y=(x+y)-bitand(x,y);

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

4189:
4190: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
4191: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4192: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
4193: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4194: Fnd_Msg_Pub.ADD;*/
4195: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4196: --bitor value of x and y=(x+y)-bitand(x,y);
4197: x_valid_flag := (x_valid_flag+POWER(2,3))-bitand(x_valid_flag,POWER(2,3));

Line 4203: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');

4199: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN
4200: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
4201:
4202: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4203: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
4204: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4205: Fnd_Msg_Pub.ADD;*/
4206: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4207: --bitor value of x and y=(x+y)-bitand(x,y);

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

4200: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
4201:
4202: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4203: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
4204: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4205: Fnd_Msg_Pub.ADD;*/
4206: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4207: --bitor value of x and y=(x+y)-bitand(x,y);
4208: x_valid_flag := (x_valid_flag+POWER(2,4))-bitand(x_valid_flag,POWER(2,4));

Line 4216: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');

4212: ELSE -- Else for c_mr_header%FOUND check
4213: CLOSE c_mr_header;
4214:
4215: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4216: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
4217: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4218: Fnd_Msg_Pub.ADD;*/
4219: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4220: --bitor value of x and y=(x+y)-bitand(x,y);

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

4213: CLOSE c_mr_header;
4214:
4215: -- SATRAJEN :: Bug 12990261 :: Commented to Sum up all the error Messages :: Jun 2012
4216: /*Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
4217: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4218: Fnd_Msg_Pub.ADD;*/
4219: -- PRAKKUM :: FPBug 16481732 for BaseBug 15884730 :: 16/11/2012
4220: --bitor value of x and y=(x+y)-bitand(x,y);
4221: x_valid_flag := (x_valid_flag+POWER(2,5))-bitand(x_valid_flag,POWER(2,5));

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

4331: END IF;
4332:
4333: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
4334:
4335: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
4336: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4337: Fnd_Msg_Pub.ADD;
4338:
4339: END IF;

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

4332:
4333: IF TRUNC(c_route_rec.start_date_active) > p_start_date_time THEN
4334:
4335: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
4336: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4337: Fnd_Msg_Pub.ADD;
4338:
4339: END IF;
4340:

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

4340:
4341: IF TRUNC(c_route_rec.end_date_active) IS NOT NULL THEN
4342: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
4343:
4344: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
4345: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4346: Fnd_Msg_Pub.ADD;
4347:
4348: END IF;

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

4341: IF TRUNC(c_route_rec.end_date_active) IS NOT NULL THEN
4342: IF TRUNC(c_route_rec.end_date_active) < p_end_date_time THEN
4343:
4344: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
4345: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4346: Fnd_Msg_Pub.ADD;
4347:
4348: END IF;
4349: END IF;

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

4351: ELSE -- Else of c_route%FOUND check
4352:
4353: CLOSE c_route;
4354:
4355: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
4356: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4357: Fnd_Msg_Pub.ADD;
4358:
4359: END IF; -- End of c_route%FOUND check

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

4352:
4353: CLOSE c_route;
4354:
4355: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
4356: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4357: Fnd_Msg_Pub.ADD;
4358:
4359: END IF; -- End of c_route%FOUND check
4360:

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

4372: 'Checking MR Start and End Dates');
4373: END IF;
4374:
4375: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
4376: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
4377: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4378: Fnd_Msg_Pub.ADD;
4379:
4380: END IF;

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

4373: END IF;
4374:
4375: IF TRUNC(c_mr_header_rec.effective_from) > p_start_date_time THEN
4376: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
4377: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4378: Fnd_Msg_Pub.ADD;
4379:
4380: END IF;
4381: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN

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

4380: END IF;
4381: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN
4382: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
4383:
4384: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
4385: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4386: Fnd_Msg_Pub.ADD;
4387:
4388: END IF;

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

4381: IF TRUNC(c_mr_header_rec.effective_to) IS NOT NULL THEN
4382: IF TRUNC(c_mr_header_rec.effective_to) < p_end_date_time THEN
4383:
4384: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
4385: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4386: Fnd_Msg_Pub.ADD;
4387:
4388: END IF;
4389: END IF;

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

4390:
4391: ELSE -- Else for c_mr_header%FOUND check
4392: CLOSE c_mr_header;
4393:
4394: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
4395: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4396: Fnd_Msg_Pub.ADD;
4397:
4398: END IF; -- End of c_mr_header%FOUND check

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

4391: ELSE -- Else for c_mr_header%FOUND check
4392: CLOSE c_mr_header;
4393:
4394: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
4395: Fnd_Message.Set_Token('TASK_NUMBER', p_visit_task_number);
4396: Fnd_Msg_Pub.ADD;
4397:
4398: END IF; -- End of c_mr_header%FOUND check
4399: END IF; -- End of p_mr_route_id IS NOT NULL check

Line 4702: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TYPE_MAND');

4698: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
4699: -- If the visit does not have visit type associated to it, an error should be thrown
4700: -- Errored only if visit is not an old visit -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes
4701: IF c_visit_rec.visit_type_code IS NULL AND c_visit_rec.IS_OLD_VISIT <> 'Y' THEN
4702: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TYPE_MAND');
4703: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4704: Fnd_Msg_Pub.ADD;
4705: END IF;
4706:

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

4699: -- If the visit does not have visit type associated to it, an error should be thrown
4700: -- Errored only if visit is not an old visit -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes
4701: IF c_visit_rec.visit_type_code IS NULL AND c_visit_rec.IS_OLD_VISIT <> 'Y' THEN
4702: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_TYPE_MAND');
4703: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4704: Fnd_Msg_Pub.ADD;
4705: END IF;
4706:
4707: -- To check if the unit is quarantined

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

4716: L_DEBUG_KEY,
4717: 'Visit Start Date is null.');
4718: END IF;
4719: -- By shbhanda 05/21/04 for TC changes
4720: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ST_DATE');
4721: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4722: Fnd_Msg_Pub.ADD;
4723: END IF;
4724:

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

4717: 'Visit Start Date is null.');
4718: END IF;
4719: -- By shbhanda 05/21/04 for TC changes
4720: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ST_DATE');
4721: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4722: Fnd_Msg_Pub.ADD;
4723: END IF;
4724:
4725: -- To check visit's status is not null and it should be only planning or partially released

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

4731: fnd_log.string(l_log_statement,
4732: L_DEBUG_KEY,
4733: 'Visit Status Code is not Planning/Partially Released.');
4734: END IF;
4735: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NOT_PLANNING'); -- **** IMPortant uPDATE FOR PARTIALLY RELEASED
4736: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4737: Fnd_Msg_Pub.ADD;
4738: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code is not Planning or Partially Released' ;
4739: l_error_tbl(j).Msg_Index := j;

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

4732: L_DEBUG_KEY,
4733: 'Visit Status Code is not Planning/Partially Released.');
4734: END IF;
4735: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NOT_PLANNING'); -- **** IMPortant uPDATE FOR PARTIALLY RELEASED
4736: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4737: Fnd_Msg_Pub.ADD;
4738: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code is not Planning or Partially Released' ;
4739: l_error_tbl(j).Msg_Index := j;
4740: l_error_tbl(j).Msg_Data := l_temp;

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

4748: fnd_log.string(l_log_statement,
4749: L_DEBUG_KEY,
4750: 'Visit Status Code is Planning and Visit Start Date is less than sysdate. ');
4751: END IF;
4752: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
4753: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4754: Fnd_Msg_Pub.ADD;
4755: /* l_error_tbl(j).Msg_Index := j;
4756: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',

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

4749: L_DEBUG_KEY,
4750: 'Visit Status Code is Planning and Visit Start Date is less than sysdate. ');
4751: END IF;
4752: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
4753: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4754: Fnd_Msg_Pub.ADD;
4755: /* l_error_tbl(j).Msg_Index := j;
4756: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',
4757: NAMEIN => 'AHL_VWP_START_DATE_LT_SYS')

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

4752: Fnd_Message.SET_NAME('AHL','AHL_VWP_START_DATE_LT_SYS');
4753: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4754: Fnd_Msg_Pub.ADD;
4755: /* l_error_tbl(j).Msg_Index := j;
4756: l_error_tbl(j).Msg_Data := REPLACE(FND_MESSAGE.GET_STRING(APPIN => 'AHL',
4757: NAMEIN => 'AHL_VWP_START_DATE_LT_SYS')
4758: ,'VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
4759: j := j + 1; */
4760: --VWPE :: tchimira :: 15-FEB -2011 :: end

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

4765: fnd_log.string(l_log_statement,
4766: L_DEBUG_KEY,
4767: 'Visit Status Code is null.');
4768: END IF;
4769: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_STATUS');
4770: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4771: Fnd_Msg_Pub.ADD;
4772:
4773: /*l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code Missing' ;

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

4766: L_DEBUG_KEY,
4767: 'Visit Status Code is null.');
4768: END IF;
4769: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_STATUS');
4770: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4771: Fnd_Msg_Pub.ADD;
4772:
4773: /*l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Status Code Missing' ;
4774: l_error_tbl(j).Msg_Index := j;

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

4783: L_DEBUG_KEY,
4784: 'Visit Organization is null.');
4785: END IF;
4786:
4787: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ORG');
4788: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4789: Fnd_Msg_Pub.ADD;
4790:
4791: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Organization Missing' ;

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

4784: 'Visit Organization is null.');
4785: END IF;
4786:
4787: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_ORG');
4788: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4789: Fnd_Msg_Pub.ADD;
4790:
4791: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Organization Missing' ;
4792: l_error_tbl(j).Msg_Index := j;

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

4801: L_DEBUG_KEY,
4802: 'Visit Department is null.');
4803: END IF;
4804:
4805: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT');
4806: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4807: Fnd_Msg_Pub.ADD;
4808:
4809: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Department Missing';

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

4802: 'Visit Department is null.');
4803: END IF;
4804:
4805: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT');
4806: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4807: Fnd_Msg_Pub.ADD;
4808:
4809: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Department Missing';
4810: l_error_tbl(j).Msg_Index := j;

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

4820: L_DEBUG_KEY,
4821: 'Visit Plan End Date is null.');
4822: END IF;
4823:
4824: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PLN_END_DT');
4825: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4826: Fnd_Msg_Pub.ADD;
4827:
4828: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;

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

4821: 'Visit Plan End Date is null.');
4822: END IF;
4823:
4824: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PLN_END_DT');
4825: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4826: Fnd_Msg_Pub.ADD;
4827:
4828: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;
4829: l_error_tbl(j).Msg_Index := j;

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

4841: L_DEBUG_KEY,
4842: 'Visit Plan End Date is needed for p2p.');
4843: END IF;
4844:
4845: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
4846: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4847: Fnd_Msg_Pub.ADD;
4848:
4849: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;

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

4842: 'Visit Plan End Date is needed for p2p.');
4843: END IF;
4844:
4845: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
4846: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4847: Fnd_Msg_Pub.ADD;
4848:
4849: /* l_temp := 'ERROR: Visit Number ' || c_visit_rec.VISIT_NUMBER || ' : Planned end date missing' ;
4850: l_error_tbl(j).Msg_Index := j;

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

4866: L_DEBUG_KEY,
4867: 'Visit has 0 Simulations.');
4868: END IF;
4869:
4870: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PRIM_PLAN');
4871: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4872: Fnd_Msg_Pub.ADD;
4873: END IF;
4874: END IF;

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

4867: 'Visit has 0 Simulations.');
4868: END IF;
4869:
4870: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_PRIM_PLAN');
4871: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4872: Fnd_Msg_Pub.ADD;
4873: END IF;
4874: END IF;
4875:

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

4897: 'After calling AHL_VWP_RULES_PVT.CHECK_LOOKUP_NAME_OR_ID.');
4898: END IF;
4899:
4900: IF NVL(l_return_status, 'X') <> 'S' THEN
4901: Fnd_Message.SET_NAME('AHL','AHL_VWP_TYPE_CODE_NOT_EXISTS');
4902: Fnd_Msg_Pub.ADD;
4903: RAISE Fnd_Api.G_EXC_ERROR;
4904: END IF;
4905: END IF;

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

4932: FETCH c_instance INTO l_count;
4933: CLOSE c_instance;
4934: IF l_count = 0 THEN
4935:
4936: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_ACTIVE');
4937: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4938: Fnd_Msg_Pub.ADD;
4939: END IF;
4940: END IF;

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

4933: CLOSE c_instance;
4934: IF l_count = 0 THEN
4935:
4936: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_ACTIVE');
4937: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4938: Fnd_Msg_Pub.ADD;
4939: END IF;
4940: END IF;
4941: ELSE

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

4965: L_DEBUG_KEY,
4966: c_uc_status_rec.name || ' UC status is invalid: '|| c_uc_status_rec.uc_status);
4967: END IF;
4968:
4969: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
4970: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4971: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
4972: Fnd_Msg_Pub.ADD;
4973: END IF;

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

4966: c_uc_status_rec.name || ' UC status is invalid: '|| c_uc_status_rec.uc_status);
4967: END IF;
4968:
4969: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
4970: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4971: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
4972: Fnd_Msg_Pub.ADD;
4973: END IF;
4974: END IF;

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

4967: END IF;
4968:
4969: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INVALID_UC');
4970: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
4971: Fnd_Message.Set_Token('UNIT_NAME', c_uc_status_rec.name);
4972: Fnd_Msg_Pub.ADD;
4973: END IF;
4974: END IF;
4975:

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

5006: FETCH c_instance INTO l_count;
5007: CLOSE c_instance;
5008:
5009: IF l_count = 0 THEN
5010: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_INST_NO_ACTIVE');
5011: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5012: Fnd_Msg_Pub.ADD;
5013: END IF;
5014: END IF;

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

5007: CLOSE c_instance;
5008:
5009: IF l_count = 0 THEN
5010: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_INST_NO_ACTIVE');
5011: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5012: Fnd_Msg_Pub.ADD;
5013: END IF;
5014: END IF;
5015: ELSE

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

5039:
5040: --BEGIN: jeli added for bug 3777720
5041: 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
5042: --END: jeli added for bug 3777720
5043: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5044: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
5045: Fnd_Msg_Pub.ADD;
5046: END IF;
5047: END IF;

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

5040: --BEGIN: jeli added for bug 3777720
5041: 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
5042: --END: jeli added for bug 3777720
5043: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5044: Fnd_Message.Set_Token('VISIT_NUMBER',c_visit_rec.VISIT_NUMBER);
5045: Fnd_Msg_Pub.ADD;
5046: END IF;
5047: END IF;
5048:

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

5056: -- IF l_check_flag = 'N' THEN
5057: --BEGIN: jeli added for bug 3777720
5058: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
5059: --END: jeli added for bug 3777720
5060: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5061: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5062: Fnd_Msg_Pub.ADD;
5063: END IF;
5064: END IF;

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

5057: --BEGIN: jeli added for bug 3777720
5058: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(p_visit_id, c_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
5059: --END: jeli added for bug 3777720
5060: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_INST_NO_FOUND');
5061: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5062: Fnd_Msg_Pub.ADD;
5063: END IF;
5064: END IF;
5065: END LOOP;

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

5194: --The visit end date
5195: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
5196: -- Validation comparing visit's calculated and planned end is no more needed, planned end date should not be null is still valid
5197: IF c_visit_rec.close_date_time IS NULL AND l_plan_date_flag = 'N' THEN -- SOSAHNI :: BUG 16061401 :: FP base bug 12929344 :: 10/01/2013 :: Added a l_plan_date_flag condition to check if plan date error was not previously found
5198: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
5199: Fnd_Message.Set_Token('VISIT_NUMBER',
5200: c_visit_rec.VISIT_NUMBER);
5201: Fnd_Msg_Pub.ADD;
5202: END IF;

Line 5199: Fnd_Message.Set_Token('VISIT_NUMBER',

5195: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
5196: -- Validation comparing visit's calculated and planned end is no more needed, planned end date should not be null is still valid
5197: IF c_visit_rec.close_date_time IS NULL AND l_plan_date_flag = 'N' THEN -- SOSAHNI :: BUG 16061401 :: FP base bug 12929344 :: 10/01/2013 :: Added a l_plan_date_flag condition to check if plan date error was not previously found
5198: Fnd_Message.SET_NAME('AHL','AHL_VWP_PLN_END_DATE_NULL');
5199: Fnd_Message.Set_Token('VISIT_NUMBER',
5200: c_visit_rec.VISIT_NUMBER);
5201: Fnd_Msg_Pub.ADD;
5202: END IF;
5203:

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

5212: IF UPPER(c_task_rec.task_type_code) = 'PLANNED' THEN
5213: --- Changes made by VSUNDARA for Production - SR Integration
5214: IF c_task_rec.mr_route_id is null THEN
5215: IF c_task_rec.SERVICE_REQUEST_ID is null OR c_task_rec.UNIT_EFFECTIVITY_ID is null THEN
5216: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_SR_UE'); --***** change this
5217: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5218: Fnd_Msg_Pub.ADD;
5219: END IF; --Added by jeli on 07/26/04 when merging code otherwise it couldn't pass compilation
5220: END IF; --- End Changes made by VSUNDARA for Production - SR Integration

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

5213: --- Changes made by VSUNDARA for Production - SR Integration
5214: IF c_task_rec.mr_route_id is null THEN
5215: IF c_task_rec.SERVICE_REQUEST_ID is null OR c_task_rec.UNIT_EFFECTIVITY_ID is null THEN
5216: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_SR_UE'); --***** change this
5217: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5218: Fnd_Msg_Pub.ADD;
5219: END IF; --Added by jeli on 07/26/04 when merging code otherwise it couldn't pass compilation
5220: END IF; --- End Changes made by VSUNDARA for Production - SR Integration
5221: END IF;

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

5227: fnd_log.string(l_log_statement,
5228: L_DEBUG_KEY,
5229: 'Unassociated Task. Task Duration is null');
5230: END IF;
5231: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_DURATION');
5232: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5233: Fnd_Msg_Pub.ADD;
5234: END IF; -- End for c_task_rec.task_type_code check
5235:

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

5228: L_DEBUG_KEY,
5229: 'Unassociated Task. Task Duration is null');
5230: END IF;
5231: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_DURATION');
5232: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5233: Fnd_Msg_Pub.ADD;
5234: END IF; -- End for c_task_rec.task_type_code check
5235:
5236: -- To find all visit tasks must be associated to an item and item instance.

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

5239: fnd_log.string(l_log_statement,
5240: L_DEBUG_KEY,
5241: 'Check Task Serial');
5242: END IF;
5243: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_SERIAL');
5244: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5245: Fnd_Msg_Pub.ADD;
5246: END IF;
5247:

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

5240: L_DEBUG_KEY,
5241: 'Check Task Serial');
5242: END IF;
5243: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_SERIAL');
5244: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5245: Fnd_Msg_Pub.ADD;
5246: END IF;
5247:
5248: IF c_task_rec.inventory_item_id IS NULL THEN

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

5250: fnd_log.string(l_log_statement,
5251: L_DEBUG_KEY,
5252: 'Task Inventory Item is null.');
5253: END IF;
5254: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ITEM');
5255: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5256: Fnd_Msg_Pub.ADD;
5257: END IF;
5258:

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

5251: L_DEBUG_KEY,
5252: 'Task Inventory Item is null.');
5253: END IF;
5254: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ITEM');
5255: Fnd_Message.Set_Token('TASK_NUMBER', c_task_rec.VISIT_TASK_NUMBER);
5256: Fnd_Msg_Pub.ADD;
5257: END IF;
5258:
5259: -- Begin changes by rnahata for Bug 6448678

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

5290:
5291: ELSE
5292:
5293: IF c_visit_rec.DEPARTMENT_ID IS NOT NULL AND l_count = 0 THEN -- SOSAHNI :: BUG 16061392 :: FP base bug :: 12990824 :: 10/01/2013 :: Added check for Department ID not null
5294: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
5295: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5296: Fnd_Msg_Pub.ADD;
5297: END IF;
5298:

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

5291: ELSE
5292:
5293: IF c_visit_rec.DEPARTMENT_ID IS NOT NULL AND l_count = 0 THEN -- SOSAHNI :: BUG 16061392 :: FP base bug :: 12990824 :: 10/01/2013 :: Added check for Department ID not null
5294: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
5295: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5296: Fnd_Msg_Pub.ADD;
5297: END IF;
5298:
5299: IF l_chk_flag = 'Y' THEN

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

5296: Fnd_Msg_Pub.ADD;
5297: END IF;
5298:
5299: IF l_chk_flag = 'Y' THEN
5300: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_RT_EXISTS');
5301: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5302: Fnd_Msg_Pub.ADD;
5303: END IF;
5304:

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

5297: END IF;
5298:
5299: IF l_chk_flag = 'Y' THEN
5300: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_RT_EXISTS');
5301: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5302: Fnd_Msg_Pub.ADD;
5303: END IF;
5304:
5305: IF l_dept_flag = 'Y' THEN

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

5320: fnd_log.string(l_log_statement,
5321: L_DEBUG_KEY,
5322: 'Task Dept Count ' || l_dept);
5323: END IF;
5324: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
5325: Fnd_Message.Set_Token('TASK_NUMBER', c_dept_tsk_rec.VISIT_TASK_NUMBER);
5326: Fnd_Msg_Pub.ADD;
5327: END IF;
5328: CLOSE c_dept;

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

5321: L_DEBUG_KEY,
5322: 'Task Dept Count ' || l_dept);
5323: END IF;
5324: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_DEPT_SHIFT');
5325: Fnd_Message.Set_Token('TASK_NUMBER', c_dept_tsk_rec.VISIT_TASK_NUMBER);
5326: Fnd_Msg_Pub.ADD;
5327: END IF;
5328: CLOSE c_dept;
5329: END IF;

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

5344: L_DEBUG_KEY,
5345: 'No Task Found for the Visit');
5346: END IF;
5347:
5348: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TASK_NULL');
5349: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5350: Fnd_Msg_Pub.ADD;
5351:
5352: END IF;

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

5345: 'No Task Found for the Visit');
5346: END IF;
5347:
5348: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TASK_NULL');
5349: Fnd_Message.Set_Token('VISIT_NUMBER', c_visit_rec.VISIT_NUMBER);
5350: Fnd_Msg_Pub.ADD;
5351:
5352: END IF;
5353: END IF;

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

6447: L_DEBUG_KEY,
6448: 'l_visit_end_time --@>'||l_visit_end_time);
6449: END IF;
6450: IF l_visit_end_time > get_vst_status_and_date_rec.close_date_time THEN
6451: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
6452: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
6453: Fnd_Msg_Pub.ADD;
6454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6455: END IF;

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

6448: 'l_visit_end_time --@>'||l_visit_end_time);
6449: END IF;
6450: IF l_visit_end_time > get_vst_status_and_date_rec.close_date_time THEN
6451: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
6452: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
6453: Fnd_Msg_Pub.ADD;
6454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6455: END IF;
6456: END IF;

Line 6568: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_MR_ASSOC_FAIL');

6564: -- On plan visit : p_module_type = 'CST'
6565: -- And if it is operational visit running from concurrent procedure create/update operational visits.
6566: IF (l_auto_visit_flag IS NOT NULL AND l_unit_sch_id IS NOT NULL AND p_module_type = 'CST' ) THEN
6567: IF (l_invalid_mr = 'Y') THEN
6568: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_MR_ASSOC_FAIL');
6569: Fnd_Msg_Pub.ADD;
6570: END IF;
6571: ELSE
6572: -- SATRAJEN :: Bug 12990261 :: Jun 2012

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

6571: ELSE
6572: -- SATRAJEN :: Bug 12990261 :: Jun 2012
6573: IF (LENGTH(l_task_nos_1) > 0) THEN
6574: l_task_nos_1 := SUBSTR (l_task_nos_1,0,(LENGTH(l_task_nos_1)-1));
6575: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
6576: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_1);
6577: Fnd_Msg_Pub.ADD;
6578: END IF;
6579:

Line 6576: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_1);

6572: -- SATRAJEN :: Bug 12990261 :: Jun 2012
6573: IF (LENGTH(l_task_nos_1) > 0) THEN
6574: l_task_nos_1 := SUBSTR (l_task_nos_1,0,(LENGTH(l_task_nos_1)-1));
6575: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_STDT_ROUT_STDT');
6576: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_1);
6577: Fnd_Msg_Pub.ADD;
6578: END IF;
6579:
6580: IF (LENGTH(l_task_nos_2) > 0) THEN

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

6578: END IF;
6579:
6580: IF (LENGTH(l_task_nos_2) > 0) THEN
6581: l_task_nos_2 := SUBSTR (l_task_nos_2,0,(LENGTH(l_task_nos_2)-1));
6582: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
6583: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_2);
6584: Fnd_Msg_Pub.ADD;
6585: END IF;
6586:

Line 6583: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_2);

6579:
6580: IF (LENGTH(l_task_nos_2) > 0) THEN
6581: l_task_nos_2 := SUBSTR (l_task_nos_2,0,(LENGTH(l_task_nos_2)-1));
6582: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_ENDT_ROUT_ENDT');
6583: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_2);
6584: Fnd_Msg_Pub.ADD;
6585: END IF;
6586:
6587: IF (LENGTH(l_task_nos_3) > 0) THEN

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

6585: END IF;
6586:
6587: IF (LENGTH(l_task_nos_3) > 0) THEN
6588: l_task_nos_3 := SUBSTR (l_task_nos_3,0,(LENGTH(l_task_nos_3)-1));
6589: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
6590: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_3);
6591: Fnd_Msg_Pub.ADD;
6592: END IF;
6593:

Line 6590: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_3);

6586:
6587: IF (LENGTH(l_task_nos_3) > 0) THEN
6588: l_task_nos_3 := SUBSTR (l_task_nos_3,0,(LENGTH(l_task_nos_3)-1));
6589: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_TSK_NO_ROUTE');
6590: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_3);
6591: Fnd_Msg_Pub.ADD;
6592: END IF;
6593:
6594: IF (LENGTH(l_task_nos_4) > 0) THEN

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

6592: END IF;
6593:
6594: IF (LENGTH(l_task_nos_4) > 0) THEN
6595: l_task_nos_4 := SUBSTR (l_task_nos_4,0,(LENGTH(l_task_nos_4)-1));
6596: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
6597: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_4);
6598: Fnd_Msg_Pub.ADD;
6599: END IF;
6600:

Line 6597: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_4);

6593:
6594: IF (LENGTH(l_task_nos_4) > 0) THEN
6595: l_task_nos_4 := SUBSTR (l_task_nos_4,0,(LENGTH(l_task_nos_4)-1));
6596: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_SD_LT_MR');
6597: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_4);
6598: Fnd_Msg_Pub.ADD;
6599: END IF;
6600:
6601: IF (LENGTH(l_task_nos_5) > 0) THEN

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

6599: END IF;
6600:
6601: IF (LENGTH(l_task_nos_5) > 0) THEN
6602: l_task_nos_5 := SUBSTR (l_task_nos_5,0,(LENGTH(l_task_nos_5)-1));
6603: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
6604: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_5);
6605: Fnd_Msg_Pub.ADD;
6606: END IF;
6607:

Line 6604: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_5);

6600:
6601: IF (LENGTH(l_task_nos_5) > 0) THEN
6602: l_task_nos_5 := SUBSTR (l_task_nos_5,0,(LENGTH(l_task_nos_5)-1));
6603: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_TS_ED_GT_MR');
6604: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_5);
6605: Fnd_Msg_Pub.ADD;
6606: END IF;
6607:
6608: IF (LENGTH(l_task_nos_6) > 0) THEN

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

6606: END IF;
6607:
6608: IF (LENGTH(l_task_nos_6) > 0) THEN
6609: l_task_nos_6 := SUBSTR (l_task_nos_6,0,(LENGTH(l_task_nos_6)-1));
6610: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
6611: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_6);
6612: Fnd_Msg_Pub.ADD;
6613: END IF;
6614:

Line 6611: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_6);

6607:
6608: IF (LENGTH(l_task_nos_6) > 0) THEN
6609: l_task_nos_6 := SUBSTR (l_task_nos_6,0,(LENGTH(l_task_nos_6)-1));
6610: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_NO_MR_ID');
6611: Fnd_Message.Set_Token('TASK_NUMBER', l_task_nos_6);
6612: Fnd_Msg_Pub.ADD;
6613: END IF;
6614:
6615: -- END of Bug 12990261 :: Jun 2012

Line 7243: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');

7239: || TO_CHAR(l_max_schedule_start_date,'DD-MON-YYYY HH24:MI:SS'));
7240: END IF;
7241:
7242: IF l_max_schedule_start_date > c_visit_rec.close_date_time THEN -- Validation Error
7243: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');
7244: Fnd_Msg_Pub.ADD;
7245: RAISE Fnd_Api.G_EXC_ERROR;
7246: END IF;
7247:

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

7843: END IF;
7844:
7845: -- Check for Required Parameters
7846: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
7847: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
7848: FND_MSG_PUB.ADD;
7849: IF (l_log_unexpected >= l_log_current_level)THEN
7850: fnd_log.string
7851: (

Line 7867: Fnd_Message.SET_NAME('AHL','AHL_VWP_UE_EXP_STATUS');

7863: OPEN c_validate_ue_status (p_visit_id);
7864: FETCH c_validate_ue_status INTO l_mr_title;
7865: IF c_validate_ue_status%FOUND THEN
7866: CLOSE c_validate_ue_status;
7867: Fnd_Message.SET_NAME('AHL','AHL_VWP_UE_EXP_STATUS');
7868: Fnd_Message.Set_Token('MR_TITLE',l_mr_title);
7869: Fnd_Msg_Pub.ADD;
7870: RAISE Fnd_Api.G_EXC_ERROR;
7871: END IF;

Line 7868: Fnd_Message.Set_Token('MR_TITLE',l_mr_title);

7864: FETCH c_validate_ue_status INTO l_mr_title;
7865: IF c_validate_ue_status%FOUND THEN
7866: CLOSE c_validate_ue_status;
7867: Fnd_Message.SET_NAME('AHL','AHL_VWP_UE_EXP_STATUS');
7868: Fnd_Message.Set_Token('MR_TITLE',l_mr_title);
7869: Fnd_Msg_Pub.ADD;
7870: RAISE Fnd_Api.G_EXC_ERROR;
7871: END IF;
7872: CLOSE c_validate_ue_status;

Line 7881: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');

7877: --salogan::Modified the cursor fetch to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::BEGIN
7878: OPEN c_conc_req_phase(p_visit_id);
7879: FETCH c_conc_req_phase INTO l_dummy_val;
7880: IF(c_conc_req_phase%FOUND) THEN
7881: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CP_P2P_IN_PROGS');
7882: FND_MSG_PUB.ADD;
7883: RAISE FND_API.G_EXC_ERROR;
7884: END IF;
7885: CLOSE c_conc_req_phase;

Line 7912: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');

7908: L_DEBUG_KEY,
7909: 'Stage does not have an associated stage type ' ||
7910: stage_details_rec.stage_name);
7911: END IF;
7912: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
7913: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
7914: FND_MSG_PUB.ADD;
7915:
7916: END LOOP;

Line 7913: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);

7909: 'Stage does not have an associated stage type ' ||
7910: stage_details_rec.stage_name);
7911: END IF;
7912: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
7913: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
7914: FND_MSG_PUB.ADD;
7915:
7916: END LOOP;
7917:

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

8248:
8249: --Validate visit
8250: IF (nvl(l_validate_visit,0) = 0) THEN
8251: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8252: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
8253: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
8254: FND_MSG_PUB.ADD;
8255: END IF;
8256: RAISE FND_API.G_EXC_ERROR;

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

8249: --Validate visit
8250: IF (nvl(l_validate_visit,0) = 0) THEN
8251: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8252: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_VST');
8253: FND_MESSAGE.SET_TOKEN('VISIT_ID', p_visit_id);
8254: FND_MSG_PUB.ADD;
8255: END IF;
8256: RAISE FND_API.G_EXC_ERROR;
8257: END IF;

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

8260: OPEN c_visit_info(p_visit_id);
8261: FETCH c_visit_info INTO c_visit_info_rec;
8262: IF c_visit_info%NOTFOUND THEN
8263: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8264: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VST_STATUS_INVALID');
8265: FND_MSG_PUB.ADD;
8266: END IF;
8267: CLOSE c_visit_info;
8268: RAISE FND_API.G_EXC_ERROR;

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

8270: CLOSE c_visit_info;
8271: --If visit_id is null
8272: ELSE
8273: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8274: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_VISIT_NULL');
8275: FND_MSG_PUB.ADD;
8276: END IF;
8277: RAISE FND_API.G_EXC_ERROR;
8278: END IF;

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

8279:
8280: --No tasks selected
8281: IF (p_tasks_tbl.COUNT = 0) THEN
8282: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
8283: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_NO_TASK_SEL');
8284: FND_MSG_PUB.ADD;
8285: END IF;
8286: RAISE FND_API.G_EXC_ERROR;
8287: END IF;

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

8862: 'Task is either not in planning status or Invalid - ' ||
8863: p_tasks_tbl(i).visit_task_id);
8864: END IF;
8865: CLOSE c_task_dtls;
8866: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_TSK_ID');
8867: Fnd_Message.SET_TOKEN('TASK_ID', p_tasks_tbl(i).visit_task_id);
8868: FND_MSG_PUB.ADD;
8869: RAISE FND_API.G_EXC_ERROR;
8870: END IF;

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

8863: p_tasks_tbl(i).visit_task_id);
8864: END IF;
8865: CLOSE c_task_dtls;
8866: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_INVALID_TSK_ID');
8867: Fnd_Message.SET_TOKEN('TASK_ID', p_tasks_tbl(i).visit_task_id);
8868: FND_MSG_PUB.ADD;
8869: RAISE FND_API.G_EXC_ERROR;
8870: END IF;
8871: CLOSE c_task_dtls;

Line 8887: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');

8883: L_DEBUG_KEY,
8884: 'Task has an associated stage that does not have a stage_type ' ||
8885: c_tsk_dtls_rec.visit_task_id);
8886: END IF;
8887: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
8888: FND_MESSAGE.SET_TOKEN('STAGE_NAME',l_task_stage_details.stage_name);
8889: FND_MSG_PUB.ADD;
8890: RAISE FND_API.G_EXC_ERROR;
8891: END IF;

Line 8888: FND_MESSAGE.SET_TOKEN('STAGE_NAME',l_task_stage_details.stage_name);

8884: 'Task has an associated stage that does not have a stage_type ' ||
8885: c_tsk_dtls_rec.visit_task_id);
8886: END IF;
8887: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
8888: FND_MESSAGE.SET_TOKEN('STAGE_NAME',l_task_stage_details.stage_name);
8889: FND_MSG_PUB.ADD;
8890: RAISE FND_API.G_EXC_ERROR;
8891: END IF;
8892: --CHANGES by jrotich bug #13028686 begin end;

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

8903: L_DEBUG_KEY,
8904: 'Planned end time of the task is exceeding the scheduled completion time of the master WO: ' ||
8905: c_tsk_dtls_rec.visit_task_number);
8906: END IF;
8907: FND_MESSAGE.SET_NAME(G_PM_PRODUCT_CODE,'AHL_VWP_PET_EXCD_SCT');
8908: FND_MSG_PUB.ADD;
8909: RAISE FND_API.G_EXC_ERROR;
8910: END IF;
8911:

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

8979: L_DEBUG_KEY,
8980: 'Select the summary task for the task: ' ||
8981: c_tsk_dtls_rec.visit_task_number);
8982: END IF;
8983: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_SUM_TSK');
8984: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_tsk_dtls_rec.visit_task_number);
8985: FND_MSG_PUB.ADD;
8986: RAISE FND_API.G_EXC_ERROR;
8987: END IF;

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

8980: 'Select the summary task for the task: ' ||
8981: c_tsk_dtls_rec.visit_task_number);
8982: END IF;
8983: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_SUM_TSK');
8984: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_tsk_dtls_rec.visit_task_number);
8985: FND_MSG_PUB.ADD;
8986: RAISE FND_API.G_EXC_ERROR;
8987: END IF;
8988:

Line 9041: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CHILD_TASK_SEL');

9037: EXIT;
9038: END IF;
9039: END LOOP;
9040: IF l_is_all_tasks_rel = 'N' AND p_tasks_tbl(i).unit_effectivity_id IS NOT NULL THEN
9041: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CHILD_TASK_SEL');
9042: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_par_rel_sum_tsk_rec.visit_task_number);
9043: FND_MSG_PUB.ADD;
9044: RAISE FND_API.G_EXC_ERROR;
9045: ELSE

Line 9042: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_par_rel_sum_tsk_rec.visit_task_number);

9038: END IF;
9039: END LOOP;
9040: IF l_is_all_tasks_rel = 'N' AND p_tasks_tbl(i).unit_effectivity_id IS NOT NULL THEN
9041: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CHILD_TASK_SEL');
9042: Fnd_Message.SET_TOKEN('TASK_NUMBER', c_par_rel_sum_tsk_rec.visit_task_number);
9043: FND_MSG_PUB.ADD;
9044: RAISE FND_API.G_EXC_ERROR;
9045: ELSE
9046: l_is_all_tasks_rel := 'N';

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

9110: ' is technically dependent has not been selected.'||
9111: 'Please select the technically dependent tasks too');
9112: END IF;
9113: CLOSE get_parent_task_dependencies;
9114: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
9115: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
9116: FND_MSG_PUB.ADD;
9117: RAISE FND_API.G_EXC_ERROR;
9118: END IF; --parent task not selected

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

9111: 'Please select the technically dependent tasks too');
9112: END IF;
9113: CLOSE get_parent_task_dependencies;
9114: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
9115: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
9116: FND_MSG_PUB.ADD;
9117: RAISE FND_API.G_EXC_ERROR;
9118: END IF; --parent task not selected
9119: END IF;

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

9148: 'Child tasks on which the task ' || x_tasks_tbl(i).visit_task_number || ' is technically dependent has not been selected.'||
9149: 'Please select the technically dependent tasks too');
9150: END IF;
9151: CLOSE get_child_task_dependencies;
9152: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
9153: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
9154: FND_MSG_PUB.ADD;
9155: RAISE FND_API.G_EXC_ERROR;
9156: END IF; --curr task not selected

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

9149: 'Please select the technically dependent tasks too');
9150: END IF;
9151: CLOSE get_child_task_dependencies;
9152: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_SEL_TECH_DEP');
9153: Fnd_Message.SET_TOKEN('TASK_NUMBER', x_tasks_tbl(i).visit_task_number);
9154: FND_MSG_PUB.ADD;
9155: RAISE FND_API.G_EXC_ERROR;
9156: END IF; --curr task not selected
9157: END IF;

Line 9977: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');

9973: || TO_CHAR(l_max_schedule_start_date,'DD-MON-YYYY HH24:MI:SS'));
9974: END IF;
9975:
9976: IF l_max_schedule_start_date > c_visit_dtl_rec.close_date_time THEN -- Validation Error
9977: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');
9978: Fnd_Msg_Pub.ADD;
9979: RAISE Fnd_Api.G_EXC_ERROR;
9980: END IF;
9981:

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

10306: -- If the Visit header has an instance id, check for the corresponding Unit
10307: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
10308: IF l_quarantined = FND_API.G_TRUE THEN
10309: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
10310: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_HDR_UNIT_QRNT');
10311: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
10312: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
10313: Fnd_Msg_Pub.ADD;
10314:

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

10308: IF l_quarantined = FND_API.G_TRUE THEN
10309: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
10310: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_HDR_UNIT_QRNT');
10311: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
10312: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
10313: Fnd_Msg_Pub.ADD;
10314:
10315: IF (l_log_statement >= l_log_current_level)THEN
10316: fnd_log.string (l_log_statement,L_DEBUG_KEY,'Unit : '||l_unit_name || ' is quarantined, Error message added');

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

10323: FETCH c_get_tasknumbers INTO l_task_number,l_instance_id;
10324: EXIT WHEN c_get_tasknumbers%NOTFOUND;
10325: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
10326: IF l_quarantined = FND_API.G_TRUE THEN
10327: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_TSK_UNIT_QRNT');
10328: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
10329: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);
10330: Fnd_Msg_Pub.ADD;
10331: IF (l_log_statement >= l_log_current_level)THEN

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

10325: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
10326: IF l_quarantined = FND_API.G_TRUE THEN
10327: Fnd_Message.SET_NAME('AHL','AHL_VWP_VLD_TSK_UNIT_QRNT');
10328: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
10329: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);
10330: Fnd_Msg_Pub.ADD;
10331: IF (l_log_statement >= l_log_current_level)THEN
10332: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Unit for this task: '||l_task_number||' is quarantined');
10333: END IF;

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

10530: END IF;
10531:
10532: -- Check for Required Parameters
10533: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
10534: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
10535: FND_MSG_PUB.ADD;
10536: IF (l_log_unexpected >= l_log_current_level)THEN
10537: fnd_log.string(l_log_unexpected,L_DEBUG_KEY,'Visit id is mandatory but found null in input');
10538: END IF;

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

10539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10540: END IF;
10541:
10542: IF(p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM) THEN
10543: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_UE_INPUT_MISS');
10544: FND_MSG_PUB.ADD;
10545: IF (l_log_unexpected >= l_log_current_level)THEN
10546: fnd_log.string(l_log_unexpected,L_DEBUG_KEY,'Unit Effectivity id is mandatory but found null in input ');
10547: END IF;

Line 10566: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');

10562: L_DEBUG_KEY,
10563: 'Stage does not have an associated stage type ' ||
10564: stage_details_rec.stage_name);
10565: END IF;
10566: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
10567: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
10568: FND_MSG_PUB.ADD;
10569:
10570: END LOOP;

Line 10567: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);

10563: 'Stage does not have an associated stage type ' ||
10564: stage_details_rec.stage_name);
10565: END IF;
10566: FND_MESSAGE.SET_NAME('AHL', 'AHL_VWP_NO_STAGE_TYPE');
10567: FND_MESSAGE.SET_TOKEN('STAGE_NAME',stage_details_rec.stage_name);
10568: FND_MSG_PUB.ADD;
10569:
10570: END LOOP;
10571:

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

10638: END IF;
10639: -- SKPATHAK :: Bug 8343599 :: 14-APR-2009 :: End
10640: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
10641: IF l_visit_end_time > c_visit_rec.close_date_time THEN
10642: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
10643: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
10644: Fnd_Msg_Pub.ADD;
10645: x_return_status := l_validate_error;
10646: END IF;

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

10639: -- SKPATHAK :: Bug 8343599 :: 14-APR-2009 :: End
10640: l_visit_end_time := AHL_VWP_TIMES_PVT.get_visit_end_time(c_visit_rec.visit_id);
10641: IF l_visit_end_time > c_visit_rec.close_date_time THEN
10642: Fnd_Message.SET_NAME('AHL','AHL_VWP_PRD_VST_TSK_STDT_ADJU');
10643: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
10644: Fnd_Msg_Pub.ADD;
10645: x_return_status := l_validate_error;
10646: END IF;
10647: END IF;

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

10663: -- status with end date exceeding visit master WO end date, then MR tasks cannot be created
10664: IF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
10665: x_return_status := l_validate_error;
10666: -- Error Message
10667: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
10668: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
10669: FND_MSG_PUB.ADD;
10670: END IF;
10671: END IF;

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

10664: IF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
10665: x_return_status := l_validate_error;
10666: -- Error Message
10667: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
10668: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
10669: FND_MSG_PUB.ADD;
10670: END IF;
10671: END IF;
10672:

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

13247: IF (p_x_task_Tbl.COUNT > 0) THEN
13248: i := p_x_task_Tbl.FIRST;
13249: END IF;
13250: -- Error Message
13251: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
13252: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
13253: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
13254: -- yazhou Sep-15-2005 ends
13255: FND_MSG_PUB.ADD;

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

13248: i := p_x_task_Tbl.FIRST;
13249: END IF;
13250: -- Error Message
13251: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
13252: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
13253: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
13254: -- yazhou Sep-15-2005 ends
13255: FND_MSG_PUB.ADD;
13256: -- yazhou 06Oct2005 starts

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

13249: END IF;
13250: -- Error Message
13251: FND_MESSAGE.Set_Name('AHL','AHL_VWP_CRT_JOB_ERR');
13252: Fnd_Message.Set_Token('TASK_NUMBER', p_x_task_tbl(i).visit_task_number);
13253: Fnd_Message.Set_Token('END_DATE', TRUNC(l_visit_end_time));
13254: -- yazhou Sep-15-2005 ends
13255: FND_MSG_PUB.ADD;
13256: -- yazhou 06Oct2005 starts
13257: -- bug fix #4658861

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

13259: -- status with end date exceeding visit master WO end date, then non-routine cannot be created
13260:
13261: ELSIF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
13262: -- Error Message
13263: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
13264: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
13265: FND_MSG_PUB.ADD;
13266: -- yazhou 06Oct2005 ends
13267: ELSE

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

13260:
13261: ELSIF TRUNC(l_visit_end_time) > TRUNC(c_get_wo_details_rec.scheduled_completion_date) THEN
13262: -- Error Message
13263: Fnd_Message.SET_NAME('AHL','AHL_VWP_DATE_EXCD_WO_DATE');
13264: Fnd_Message.Set_Token('VISIT_END_DATE', l_visit_end_time);
13265: FND_MSG_PUB.ADD;
13266: -- yazhou 06Oct2005 ends
13267: ELSE
13268: -- Start for 11.5.10 release

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

13663: END IF;
13664: ELSIF l_project_tsk_flag = 'N' AND l_proj_ref_flag = 'Y' THEN
13665: x_return_status := Fnd_Api.g_ret_sts_error;
13666: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
13667: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_NUM_NOT_UNIQ');
13668: Fnd_Msg_Pub.ADD;
13669: END IF;
13670: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
13671: x_return_status := Fnd_Api.g_ret_sts_error;

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

13669: END IF;
13670: ELSIF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'N' THEN
13671: x_return_status := Fnd_Api.g_ret_sts_error;
13672: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
13673: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TSK_REF_NOT_UNIQ');
13674: Fnd_Msg_Pub.ADD;
13675: END IF;
13676: ELSE
13677: x_return_status := Fnd_Api.g_ret_sts_error;

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

13675: END IF;
13676: ELSE
13677: x_return_status := Fnd_Api.g_ret_sts_error;
13678: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
13679: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_TASK_NOT_UNIQUE');
13680: Fnd_Msg_Pub.ADD;
13681: END IF;
13682: END IF;
13683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 13774: Fnd_Message.SET_NAME('AHL', 'AHL_VWP_TASK_ID_INVALID');

13770:
13771: OPEN validate_vst_tsk_id_csr(p_task_id);
13772: FETCH validate_vst_tsk_id_csr INTO l_dummy;
13773: IF validate_vst_tsk_id_csr%NOTFOUND THEN
13774: Fnd_Message.SET_NAME('AHL', 'AHL_VWP_TASK_ID_INVALID');
13775: Fnd_Message.SET_TOKEN('VISIT_TASK_ID', p_task_id);
13776: Fnd_Msg_Pub.ADD;
13777: CLOSE validate_vst_tsk_id_csr;
13778: RAISE Fnd_Api.G_EXC_ERROR;

Line 13775: Fnd_Message.SET_TOKEN('VISIT_TASK_ID', p_task_id);

13771: OPEN validate_vst_tsk_id_csr(p_task_id);
13772: FETCH validate_vst_tsk_id_csr INTO l_dummy;
13773: IF validate_vst_tsk_id_csr%NOTFOUND THEN
13774: Fnd_Message.SET_NAME('AHL', 'AHL_VWP_TASK_ID_INVALID');
13775: Fnd_Message.SET_TOKEN('VISIT_TASK_ID', p_task_id);
13776: Fnd_Msg_Pub.ADD;
13777: CLOSE validate_vst_tsk_id_csr;
13778: RAISE Fnd_Api.G_EXC_ERROR;
13779: END IF;

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

14277: END IF;
14278:
14279: -- make sure that visit id is present in the input
14280: IF(p_visit_id IS NULL OR p_visit_id = FND_API.G_MISS_NUM) THEN
14281: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VWP_CST_INPUT_MISS');
14282: FND_MSG_PUB.ADD;
14283:
14284: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
14285: fnd_log.string

Line 14300: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VISIT_ID_INVALID');

14296: FETCH get_visit_status INTO l_status_code, l_visit_number;
14297: CLOSE get_visit_status;
14298:
14299: IF(l_status_code IS NULL ) THEN
14300: FND_MESSAGE.Set_Name(G_PM_PRODUCT_CODE,'AHL_VISIT_ID_INVALID');
14301: FND_MSG_PUB.ADD;
14302:
14303: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)THEN
14304: fnd_log.string

Line 14720: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_SP2P_INV');

14716: FETCH c_is_old_visit INTO l_is_old_visit_dets;
14717: CLOSE c_is_old_visit;
14718:
14719: IF l_is_old_visit_dets.IS_OLD_VISIT = 'Y' THEN
14720: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_SP2P_INV');
14721: Fnd_Msg_Pub.ADD;
14722: RAISE Fnd_Api.G_EXC_ERROR;
14723: END IF;
14724:

Line 14939: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_WO_CANOT_P2P');

14935: fnd_log.string(l_log_statement,
14936: L_DEBUG_KEY,
14937: 'Error: a stage can only be P2Ped if the Visit Mater WO already exists');
14938: END IF;
14939: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_WO_CANOT_P2P');
14940: Fnd_Msg_Pub.ADD;
14941: RAISE Fnd_Api.G_EXC_ERROR;
14942: END IF; --visit master workorder exists or not
14943: /**Visit Master Workorder Ends**/

Line 15028: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_WO_CANOT_P2P');

15024: fnd_log.string(l_log_statement,
15025: L_DEBUG_KEY,
15026: 'Error: Stage cannot be P2Ped since WO does not exist for the task_id: '||l_task_rec.visit_task_id);
15027: END IF;
15028: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_WO_CANOT_P2P');
15029: Fnd_Msg_Pub.ADD;
15030: RAISE Fnd_Api.G_EXC_ERROR;
15031: END IF; --work order exists or not for this task
15032:

Line 15112: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');

15108: || TO_CHAR(l_max_schedule_start_date,'DD-MON-YYYY HH24:MI:SS'));
15109: END IF;
15110:
15111: IF l_max_schedule_start_date > l_visit_dtl_rec.close_date_time THEN -- Validation Error
15112: Fnd_Message.SET_NAME('AHL','AHL_VWP_NON_PS_PLAN_ED_DATE');
15113: Fnd_Msg_Pub.ADD;
15114: RAISE Fnd_Api.G_EXC_ERROR;
15115: END IF;
15116: END IF;