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_MSG_PUB

Line 284: FND_MSG_PUB.ADD;

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

Line 300: FND_MSG_PUB.ADD;

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

Line 317: FND_MSG_PUB.ADD;

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

Line 369: FND_MSG_PUB.ADD;

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;
373: END IF; -- if either parent or child stage id is null

Line 384: FND_MSG_PUB.ADD;

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

Line 391: FND_MSG_PUB.ADD;

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

Line 428: FND_MSG_PUB.ADD;

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

Line 438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

434: END IF;
435: EXCEPTION
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN

Line 444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN
443: X_return_status := FND_API.G_RET_STS_ERROR;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: WHEN OTHERS THEN
448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: WHEN OTHERS THEN
448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
452: p_procedure_name => L_API_NAME,
453: p_error_text => SUBSTR(SQLERRM,1,240));

Line 451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

447: WHEN OTHERS THEN
448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
452: p_procedure_name => L_API_NAME,
453: p_error_text => SUBSTR(SQLERRM,1,240));
454: END IF;
455: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 455: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
452: p_procedure_name => L_API_NAME,
453: p_error_text => SUBSTR(SQLERRM,1,240));
454: END IF;
455: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => X_msg_data);
458: END;
459:

Line 489: FND_MSG_PUB.ADD;

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
493: OPEN get_task_info(p_x_task_link_rec.VISIT_TASK_ID,p_x_task_link_rec.visit_task_number);

Line 500: FND_MSG_PUB.ADD;

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;
504: -- Commented by amagrawa based on review comments.

Line 514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN

Line 520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: X_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
521: p_count => x_msg_count,
522: p_data => X_msg_data);
523: WHEN OTHERS THEN
524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 525: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

521: p_count => x_msg_count,
522: p_data => X_msg_data);
523: WHEN OTHERS THEN
524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
528: p_procedure_name => 'TRANS_VALUE_ID',
529: p_error_text => SUBSTR(SQLERRM,1,240));

Line 527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

523: WHEN OTHERS THEN
524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
528: p_procedure_name => 'TRANS_VALUE_ID',
529: p_error_text => SUBSTR(SQLERRM,1,240));
530: END IF;
531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
528: p_procedure_name => 'TRANS_VALUE_ID',
529: p_error_text => SUBSTR(SQLERRM,1,240));
530: END IF;
531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => X_msg_data);
534: END;
535:

Line 561: FND_MSG_PUB.ADD;

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
565: FND_MSG_PUB.ADD;

Line 565: FND_MSG_PUB.ADD;

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
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN

Line 576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: X_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => X_msg_data);
579: WHEN OTHERS THEN
580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

577: p_count => x_msg_count,
578: p_data => X_msg_data);
579: WHEN OTHERS THEN
580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
584: p_procedure_name => 'NON_CYCLIC_ENF',
585: p_error_text => SUBSTR(SQLERRM,1,240));

Line 583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

579: WHEN OTHERS THEN
580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
584: p_procedure_name => 'NON_CYCLIC_ENF',
585: p_error_text => SUBSTR(SQLERRM,1,240));
586: END IF;
587: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 587: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
584: p_procedure_name => 'NON_CYCLIC_ENF',
585: p_error_text => SUBSTR(SQLERRM,1,240));
586: END IF;
587: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => X_msg_data);
590: END;
591:

Line 634: FND_MSG_PUB.ADD;

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
638: OPEN CHECK_TASK_ID(P_task_link_rec.visit_task_number,P_task_link_rec.visit_task_id);

Line 645: FND_MSG_PUB.ADD;

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

Line 650: l_msg_count := FND_MSG_PUB.count_msg;

646: END IF;
647: CLOSE Check_Task_ID;
648: END IF;
649:
650: l_msg_count := FND_MSG_PUB.count_msg;
651: IF l_msg_count > 0
652: THEN
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;

Line 787: l_msg_count := FND_MSG_PUB.count_msg;

783: END IF;
784:
785: END IF;
786:
787: l_msg_count := FND_MSG_PUB.count_msg;
788: IF l_msg_count > 0
789: THEN
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;

Line 824: FND_MSG_PUB.ADD;

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

Line 853: l_msg_count := FND_MSG_PUB.count_msg;

849: END IF;
850:
851: END IF;
852:
853: l_msg_count := FND_MSG_PUB.count_msg;
854: IF l_msg_count > 0
855: THEN
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;

Line 932: FND_MSG_PUB.initialize;

928: END IF;
929:
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_boolean(l_init_msg_list) THEN
932: FND_MSG_PUB.initialize;
933: END IF;
934:
935:
936: IF G_DEBUG='Y' THEN

Line 1005: /* l_msg_count := FND_MSG_PUB.count_msg;

1001: END LOOP;
1002: end if;
1003:
1004: -- Commented by amagrawa based on review comments.
1005: /* l_msg_count := FND_MSG_PUB.count_msg;
1006: IF l_msg_count > 0 THEN
1007: X_msg_count := l_msg_count;
1008: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: RAISE FND_API.G_EXC_ERROR;

Line 1054: FND_MSG_PUB.ADD;

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
1058: l_TASK_LINK_rec.object_version_number :=l_TASK_LINK_tbl(i).object_version_number;

Line 1099: FND_MSG_PUB.ADD;

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:
1103: -- End of Post 11.5.10 Changes by Senthil

Line 1164: l_msg_count := FND_MSG_PUB.count_msg;

1160: END IF;
1161: CLOSE C_VISIT;
1162:
1163: END IF;
1164: l_msg_count := FND_MSG_PUB.count_msg;
1165: IF l_msg_count > 0 THEN
1166: X_msg_count := l_msg_count;
1167: X_return_status := FND_API.G_RET_STS_ERROR;
1168: RAISE FND_API.G_EXC_ERROR;

Line 1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1187: EXCEPTION
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO PROCESS_TASK_LINKS;
1190: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN

Line 1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO PROCESS_TASK_LINKS;
1197: X_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => X_msg_data);
1201: WHEN OTHERS THEN
1202: ROLLBACK TO PROCESS_TASK_LINKS;

Line 1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1200: p_data => X_msg_data);
1201: WHEN OTHERS THEN
1202: ROLLBACK TO PROCESS_TASK_LINKS;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205: THEN
1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1207: p_procedure_name => 'PROCESS_TASK_LINKS',
1208: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',

1202: ROLLBACK TO PROCESS_TASK_LINKS;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205: THEN
1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1207: p_procedure_name => 'PROCESS_TASK_LINKS',
1208: p_error_text => SUBSTR(SQLERRM,1,240));
1209: END IF;
1210: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1210: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1207: p_procedure_name => 'PROCESS_TASK_LINKS',
1208: p_error_text => SUBSTR(SQLERRM,1,240));
1209: END IF;
1210: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1211: p_count => x_msg_count,
1212: p_data => X_msg_data);
1213: END;
1214: