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

Line 282: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_SUMMARY');

278: FETCH c_task_number into l_parent_task_number;
279: CLOSE c_task_number;
280: --End of change by amagrawa
281: CLOSE c_task_type_code;
282: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_SUMMARY');
283: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
284: FND_MSG_PUB.ADD;
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;

Line 283: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);

279: CLOSE c_task_number;
280: --End of change by amagrawa
281: CLOSE c_task_type_code;
282: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_SUMMARY');
283: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
284: FND_MSG_PUB.ADD;
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287: CLOSE c_task_type_code;

Line 298: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_PARENT_REL');

294: FETCH c_task_number into l_parent_task_number;
295: CLOSE c_task_number;
296: --End of change by amagrawa
297: CLOSE c_task_status;
298: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_PARENT_REL');
299: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
300: FND_MSG_PUB.ADD;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;

Line 299: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);

295: CLOSE c_task_number;
296: --End of change by amagrawa
297: CLOSE c_task_status;
298: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_PARENT_REL');
299: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
300: FND_MSG_PUB.ADD;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: CLOSE c_task_status;

Line 315: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_CHILD_REL');

311: FETCH c_task_number into l_child_task_number;
312: CLOSE c_task_number;
313: --End of change by amagrawa
314: CLOSE c_task_status;
315: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_CHILD_REL');
316: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_child_task_number);
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;

Line 316: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_child_task_number);

312: CLOSE c_task_number;
313: --End of change by amagrawa
314: CLOSE c_task_status;
315: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_CHILD_REL');
316: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_child_task_number);
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: CLOSE c_task_status;

Line 366: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');

362: IF p_task_link_rec.visit_Task_number IS NULL THEN
363: l_child_task_number := NULL;
364: l_parent_task_number := NULL;
365: END IF;
366: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');
367: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);
368: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;

Line 367: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);

363: l_child_task_number := NULL;
364: l_parent_task_number := NULL;
365: END IF;
366: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');
367: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);
368: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF; -- if c_validate_rules not found

Line 368: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);

364: l_parent_task_number := NULL;
365: END IF;
366: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');
367: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);
368: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF; -- if c_validate_rules not found
372: CLOSE c_validate_rules;

Line 383: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_LINK_ID_NULL');

379: THEN
380:
381: IF (p_task_link_rec.task_link_id IS NULL OR p_task_link_rec.task_link_id=FND_API.G_MISS_NUM) AND p_task_link_rec.dml_operation<>'C'
382: THEN
383: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_LINK_ID_NULL');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:

Line 390: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');

386: END IF;
387:
388: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'
389: THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394:

Line 426: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_LINK_DUP');

422: --VWP ER-12424063:: tchimira:: changed the condition l_counter2>0 to l_counter2>1
423: -- and added one more condition
424: IF ((l_counter2>1) AND (p_task_link_rec.visit_Task_number IS NOT NULL))
425: THEN
426: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_LINK_DUP');
427: FND_MESSAGE.SET_TOKEN('RECORD',p_task_link_rec.visit_Task_number,false);
428: FND_MSG_PUB.ADD;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;

Line 427: FND_MESSAGE.SET_TOKEN('RECORD',p_task_link_rec.visit_Task_number,false);

423: -- and added one more condition
424: IF ((l_counter2>1) AND (p_task_link_rec.visit_Task_number IS NOT NULL))
425: THEN
426: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_LINK_DUP');
427: FND_MESSAGE.SET_TOKEN('RECORD',p_task_link_rec.visit_Task_number,false);
428: FND_MSG_PUB.ADD;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431: CLOSE check_UNIQ;

Line 488: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');

484: x_return_status:=FND_API.G_RET_STS_SUCCESS;
485:
486: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR
487: THEN
488: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');
489: FND_MSG_PUB.ADD;
490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSE

Line 498: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');

494: FETCH get_task_info INTO l_task_det;
495:
496: IF get_task_info%NOTFOUND
497: THEN
498: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
499: FND_MESSAGE.SET_TOKEN('RECORD',p_x_task_link_rec.visit_Task_number,false);
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: ELSE

Line 499: FND_MESSAGE.SET_TOKEN('RECORD',p_x_task_link_rec.visit_Task_number,false);

495:
496: IF get_task_info%NOTFOUND
497: THEN
498: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
499: FND_MESSAGE.SET_TOKEN('RECORD',p_x_task_link_rec.visit_Task_number,false);
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: ELSE
503: p_x_task_link_rec.parent_task_id:=l_task_det.visit_task_id;

Line 559: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_TASK_ID_CYC');

555: CONNECT BY PRIOR VISIT_TASK_ID =PARENT_TASK_ID;
556: EXCEPTION
557: WHEN l_cyclic_loop THEN
558: IF P_VISIT_TASK_NUMBER IS NOT NULL THEN
559: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_TASK_ID_CYC');
560: FND_MESSAGE.SET_TOKEN('RECORD',P_VISIT_TASK_NUMBER ,false);
561: FND_MSG_PUB.ADD;
562: -- Added by tchimira for VWPE 12730539
563: ELSE

Line 560: FND_MESSAGE.SET_TOKEN('RECORD',P_VISIT_TASK_NUMBER ,false);

556: EXCEPTION
557: WHEN l_cyclic_loop THEN
558: IF P_VISIT_TASK_NUMBER IS NOT NULL THEN
559: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_TASK_ID_CYC');
560: FND_MESSAGE.SET_TOKEN('RECORD',P_VISIT_TASK_NUMBER ,false);
561: FND_MSG_PUB.ADD;
562: -- Added by tchimira for VWPE 12730539
563: ELSE
564: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WBS_INVALID'); --WBS rule and Route Dependency are in violation

Line 564: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WBS_INVALID'); --WBS rule and Route Dependency are in violation

560: FND_MESSAGE.SET_TOKEN('RECORD',P_VISIT_TASK_NUMBER ,false);
561: FND_MSG_PUB.ADD;
562: -- Added by tchimira for VWPE 12730539
563: ELSE
564: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WBS_INVALID'); --WBS rule and Route Dependency are in violation
565: FND_MSG_PUB.ADD;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 632: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');

628: THEN --Added by tchimira for VWPE 12730539
629: OPEN VALIDATE_TASK_ID(P_task_link_rec.visit_task_id);
630: FETCH VALIDATE_TASK_ID INTO l_visit_task_id;
631: IF (VALIDATE_TASK_ID%NOTFOUND) THEN
632: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
633: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);
634: FND_MSG_PUB.ADD;
635: END IF;
636: CLOSE VALIDATE_TASK_ID;

Line 633: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);

629: OPEN VALIDATE_TASK_ID(P_task_link_rec.visit_task_id);
630: FETCH VALIDATE_TASK_ID INTO l_visit_task_id;
631: IF (VALIDATE_TASK_ID%NOTFOUND) THEN
632: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
633: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);
634: FND_MSG_PUB.ADD;
635: END IF;
636: CLOSE VALIDATE_TASK_ID;
637: ELSE

Line 643: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');

639: FETCH CHECK_TASK_ID INTO l_visit_task_id;
640: IF (CHECK_TASK_ID%FOUND) THEN
641: P_task_link_rec.parent_task_id := l_visit_task_id;
642: ELSE
643: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
644: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);
645: FND_MSG_PUB.ADD;
646: END IF;
647: CLOSE Check_Task_ID;

Line 644: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);

640: IF (CHECK_TASK_ID%FOUND) THEN
641: P_task_link_rec.parent_task_id := l_visit_task_id;
642: ELSE
643: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
644: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);
645: FND_MSG_PUB.ADD;
646: END IF;
647: CLOSE Check_Task_ID;
648: END IF;

Line 823: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

819: WHERE TASK_LINK_ID=p_task_link_id
820: AND OBJECT_VERSION_NUMBER=p_object_version_number;
821: IF SQL%ROWCOUNT=0
822: THEN
823: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
824: FND_MSG_PUB.ADD;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:

Line 1052: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_TASK_STATUS');

1048: CLOSE task_status_csr;
1049:
1050: IF l_status_code <>'PLANNING' THEN
1051:
1052: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_TASK_STATUS');
1053: FND_MESSAGE.SET_TOKEN('RECORD',l_TASK_LINK_tbl(i).visit_task_number ,false);
1054: FND_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056:

Line 1053: FND_MESSAGE.SET_TOKEN('RECORD',l_TASK_LINK_tbl(i).visit_task_number ,false);

1049:
1050: IF l_status_code <>'PLANNING' THEN
1051:
1052: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_TASK_STATUS');
1053: FND_MESSAGE.SET_TOKEN('RECORD',l_TASK_LINK_tbl(i).visit_task_number ,false);
1054: FND_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056:
1057: ELSE

Line 1098: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1094: /* DELETE AHL_TASK_LINKS WHERE TASK_LINK_ID=l_task_link_tbl(i).task_link_id
1095: AND OBJECT_VERSION_NUMBER=l_task_link_tbl(i).OBJECT_VERSION_NUMBER;
1096: IF SQL%ROWCOUNT=0
1097: THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1099: FND_MSG_PUB.ADD;
1100: END IF;
1101: */
1102: