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

Line 397: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');

393: -- Check for the ID.
394: --
395: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
396: THEN
397: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_INVALID');
398: Fnd_Msg_Pub.ADD;
399: END IF;
400:
401: --

Line 408: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_DEF');

404: l_stage_count := FND_PROFILE.value('AHL_NUMBER_OF_STAGES');
405: -- Modified by amagrawa as per review comments.
406: If l_stage_count is null
407: then
408: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_DEF');
409: Fnd_Msg_Pub.ADD;
410: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: ELSIF l_stage_count <= 0

Line 414: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_GT_ZERO');

410: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
411: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
412: ELSIF l_stage_count <= 0
413: then
414: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_GT_ZERO');
415: Fnd_Msg_Pub.ADD;
416: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: ELSIF l_stage_count <> floor(l_stage_count)

Line 420: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_INT');

416: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: ELSIF l_stage_count <> floor(l_stage_count)
419: then
420: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_PROFILE_NOT_INT');
421: Fnd_Msg_Pub.ADD;
422: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
423: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
424: END IF;

Line 642: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NOT_FOUND');

638: -- Check for the ID.
639: --
640: IF (P_VISIT_ID = Fnd_Api.g_miss_num OR P_VISIT_ID IS Null)
641: THEN
642: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NOT_FOUND');
643: Fnd_Msg_Pub.ADD;
644: -- Added by amagrawa based on review commenst
645: RAISE Fnd_Api.G_EXC_ERROR;
646: END IF;

Line 654: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_STATUS_INV');

650: open c_check_visit_status(p_visit_id);
651: fetch c_check_visit_status into l_visit_status;
652: if c_check_visit_status%notfound
653: then
654: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_STATUS_INV');
655: Fnd_Msg_Pub.ADD;
656: -- Added by amagrawa based on review commenst
657: close c_check_visit_status;
658: RAISE Fnd_Api.G_EXC_ERROR;

Line 716: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');

712: OPEN C_JOB(P_VISIT_ID, p_x_stages_tbl(i).STAGE_NUM );
713: FETCH C_JOB INTO L_DUMMY;
714: IF C_JOB%FOUND
715: THEN
716: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');
717: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);
718: Fnd_Msg_Pub.ADD;
719: l_validate_status := Fnd_Api.G_RET_STS_ERROR;
720: END IF;

Line 717: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);

713: FETCH C_JOB INTO L_DUMMY;
714: IF C_JOB%FOUND
715: THEN
716: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_JOB_FIRM_REL');
717: Fnd_Message.SET_TOKEN('STAGE_NAME', p_x_stages_tbl(i).stage_name);
718: Fnd_Msg_Pub.ADD;
719: l_validate_status := Fnd_Api.G_RET_STS_ERROR;
720: END IF;
721: CLOSE C_JOB;

Line 1084: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_stages_rec.stage_id);

1080: open c_stage_data(p_stages_rec.stage_id);
1081: fetch c_stage_data into l_stage_rec;
1082: if c_stage_data%notfound
1083: then
1084: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND_NEW'||p_stages_rec.stage_id);
1085: Fnd_Msg_Pub.ADD;
1086: x_return_status := Fnd_Api.g_ret_sts_error;
1087: return;
1088: end if;

Line 1094: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');

1090:
1091: -- obj version number validation
1092: IF l_stage_rec.OBJECT_VERSION_NUMBER <> p_stages_rec.OBJECT_VERSION_NUMBER
1093: THEN
1094: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_MOD');
1095: Fnd_Msg_Pub.ADD;
1096: x_return_status := Fnd_Api.g_ret_sts_error;
1097: return;
1098: end if;

Line 1102: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_NULL');

1098: end if;
1099:
1100: IF p_stages_rec.STAGE_NUM IS NULL
1101: THEN
1102: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NUM_NULL');
1103: Fnd_Msg_Pub.ADD;
1104: x_return_status := Fnd_Api.g_ret_sts_error;
1105: return;
1106: end if;

Line 1114: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');

1110: THEN
1111: -- stage name is mandatory
1112: if p_stages_rec.stage_name is null or p_stages_rec.stage_name = ''
1113: then
1114: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');
1115: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);
1116: Fnd_Msg_Pub.ADD;
1117: x_return_status := Fnd_Api.g_ret_sts_error;
1118: return;

Line 1115: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);

1111: -- stage name is mandatory
1112: if p_stages_rec.stage_name is null or p_stages_rec.stage_name = ''
1113: then
1114: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_NULL');
1115: FND_MESSAGE.SET_TOKEN('STAGE_NUM',p_stages_rec.STAGE_NUM);
1116: Fnd_Msg_Pub.ADD;
1117: x_return_status := Fnd_Api.g_ret_sts_error;
1118: return;
1119: else

Line 1125: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');

1121: open c_stage_name(p_visit_id, p_stages_rec.stage_name, p_stages_rec.stage_id);
1122: fetch c_stage_name into l_dummy;
1123: if c_stage_name%found
1124: then
1125: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');
1126: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1127: Fnd_Msg_Pub.ADD;
1128: x_return_status := Fnd_Api.g_ret_sts_error;
1129: close c_stage_name;

Line 1126: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1122: fetch c_stage_name into l_dummy;
1123: if c_stage_name%found
1124: then
1125: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NAME_UNIQUE');
1126: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1127: Fnd_Msg_Pub.ADD;
1128: x_return_status := Fnd_Api.g_ret_sts_error;
1129: close c_stage_name;
1130: return;

Line 1142: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');

1138: THEN
1139: -- STAGE DURATION is mandatory
1140: IF p_stages_rec.DURATION IS NULL
1141: then
1142: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');
1143: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1144: Fnd_Msg_Pub.ADD;
1145: x_return_status := Fnd_Api.g_ret_sts_error;
1146: -- duration must be positive number

Line 1143: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1139: -- STAGE DURATION is mandatory
1140: IF p_stages_rec.DURATION IS NULL
1141: then
1142: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NULL');
1143: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1144: Fnd_Msg_Pub.ADD;
1145: x_return_status := Fnd_Api.g_ret_sts_error;
1146: -- duration must be positive number
1147: elsif p_stages_rec.duration < 0

Line 1149: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');

1145: x_return_status := Fnd_Api.g_ret_sts_error;
1146: -- duration must be positive number
1147: elsif p_stages_rec.duration < 0
1148: then
1149: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
1150: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := Fnd_Api.g_ret_sts_error;
1153: elsif p_stages_rec.duration = 0

Line 1150: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1146: -- duration must be positive number
1147: elsif p_stages_rec.duration < 0
1148: then
1149: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DURN_INV');
1150: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := Fnd_Api.g_ret_sts_error;
1153: elsif p_stages_rec.duration = 0
1154: then

Line 1159: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');

1155: open c_stage_task( p_stages_rec.stage_id);
1156: fetch c_stage_task into l_dummy;
1157: if c_stage_task%found
1158: THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');
1160: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1161: Fnd_Msg_Pub.ADD;
1162: x_return_status := Fnd_Api.g_ret_sts_error;
1163: end if;

Line 1160: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);

1156: fetch c_stage_task into l_dummy;
1157: if c_stage_task%found
1158: THEN
1159: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_HAS_TASKS');
1160: Fnd_Message.SET_TOKEN('STAGE_NAME', p_stages_rec.stage_name);
1161: Fnd_Msg_Pub.ADD;
1162: x_return_status := Fnd_Api.g_ret_sts_error;
1163: end if;
1164: close c_stage_task;

Line 1167: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NON_INT');

1163: end if;
1164: close c_stage_task;
1165: elsif p_stages_rec.DURATION > trunc(l_stage_duration,0)
1166: THEN
1167: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_DUR_NON_INT');
1168: Fnd_Msg_Pub.ADD;
1169: x_return_status := Fnd_Api.g_ret_sts_error;
1170:
1171: end if;

Line 1334: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND');

1330:
1331: OPEN C_STAGE_NUM(p_visit_id, p_stage_name);
1332: FETCH C_STAGE_NUM INTO L_STAGE_NUM, L_STAGE_ID;
1333: IF C_STAGE_NUM%NOTFOUND THEN
1334: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NOT_FOUND');
1335: Fnd_Msg_Pub.ADD;
1336: x_return_status := Fnd_Api.g_ret_sts_error;
1337: ELSE
1338: -- Stage number should be between Parent Stage Number - L_MAX_PARENT, and Child Stage Number - L_MIN_CHILD

Line 1342: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');

1338: -- Stage number should be between Parent Stage Number - L_MAX_PARENT, and Child Stage Number - L_MIN_CHILD
1339: IF ( L_MAX_PARENT IS NOT NULL AND L_STAGE_NUM < L_MAX_PARENT)
1340: OR ( L_MIN_CHILD IS NOT NULL AND L_STAGE_NUM > L_MIN_CHILD)
1341: THEN
1342: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
1343: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
1344: Fnd_Msg_Pub.ADD;
1345: x_return_status := Fnd_Api.g_ret_sts_error;
1346: END IF;

Line 1343: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);

1339: IF ( L_MAX_PARENT IS NOT NULL AND L_STAGE_NUM < L_MAX_PARENT)
1340: OR ( L_MIN_CHILD IS NOT NULL AND L_STAGE_NUM > L_MIN_CHILD)
1341: THEN
1342: Fnd_Message.SET_NAME('AHL','AHL_VWP_ST_NUM_INV');
1343: Fnd_Message.SET_TOKEN('STAGE_NUM', l_stage_NUM);
1344: Fnd_Msg_Pub.ADD;
1345: x_return_status := Fnd_Api.g_ret_sts_error;
1346: END IF;
1347: -- SET OUT PARAM

Line 1511: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_ST_DATE');

1507: CLOSE c_Visit;
1508:
1509: IF(c_visit_rec.START_DATE_TIME IS NULL OR c_visit_rec.START_DATE_TIME = Fnd_Api.g_miss_date)
1510: THEN
1511: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_ST_DATE');
1512: Fnd_Msg_Pub.ADD;
1513: x_valid_flag := 'N';
1514: END IF;
1515:

Line 1518: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');

1514: END IF;
1515:
1516: IF(c_visit_rec.DEPARTMENT_ID IS NULL OR c_visit_rec.DEPARTMENT_ID = Fnd_Api.g_miss_num)
1517: THEN
1518: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_NO_DEP');
1519: Fnd_Msg_Pub.ADD;
1520: x_valid_flag := 'N';
1521: ELSE
1522: -- Modified by amagrawa based on review comments

Line 1529: Fnd_Message.SET_NAME('AHL','AHL_VWP_VNO_DEP_SFT');

1525: FETCH c_dept INTO l_count;
1526: CLOSE c_dept;
1527: IF l_count=0
1528: THEN
1529: Fnd_Message.SET_NAME('AHL','AHL_VWP_VNO_DEP_SFT');
1530: Fnd_Msg_Pub.ADD;
1531: x_valid_flag := 'N';
1532: END IF;
1533: END IF;

Line 1540: Fnd_Message.SET_NAME('AHL','AHL_VWP_TNO_DEP_SFT');

1536: open c_task_dep_exist(p_visit_id);
1537: FETCH c_task_dep_exist into l_dummy;
1538: IF(c_task_dep_exist%FOUND)
1539: THEN
1540: Fnd_Message.SET_NAME('AHL','AHL_VWP_TNO_DEP_SFT');
1541: Fnd_Msg_Pub.ADD;
1542: x_valid_flag := 'N';
1543: END IF;
1544: CLOSE c_task_dep_exist;

Line 1551: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_MR_NOT_VAL');

1547: -- Modified by amagrawa based on review comments
1548: OPEN c_route_chk (p_visit_id);
1549: FETCH c_route_chk INTO c_route_chk_rec;
1550: IF c_route_chk%FOUND THEN
1551: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_MR_NOT_VAL');
1552: Fnd_Msg_Pub.ADD;
1553: x_valid_flag := 'N';
1554: END IF;
1555: CLOSE c_route_chk;