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_UNPLAN_TASKS_PVT dependencies on FND_MSG_PUB

Line 351: Fnd_Msg_Pub.ADD;

347: END IF;
348: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
349: THEN
350: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_NOT_EXISTS');
351: Fnd_Msg_Pub.ADD;
352: RAISE Fnd_Api.G_EXC_ERROR;
353: END IF;
354:
355: -- Changes made by skpathak on 20-OCT-2008 while fixing bug 7016519

Line 367: Fnd_Msg_Pub.ADD;

363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement, l_full_name, 'Item name missing');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_ITEM_MISSING');
367: Fnd_Msg_Pub.ADD;
368: RAISE Fnd_Api.G_EXC_ERROR;
369: ELSE
370: -- Item name is not null, but at least one of item id and org id is null
371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 375: Fnd_Msg_Pub.ADD;

371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
372: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check item else condition.');
373: END IF;
374: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_USE_LOV');
375: Fnd_Msg_Pub.ADD;
376: RAISE Fnd_Api.G_EXC_ERROR;
377: END IF;
378: END IF; -- End of itemid and itemorg id check
379:

Line 397: Fnd_Msg_Pub.ADD;

393:
394: IF l_count = 0 OR l_count IS NULL THEN
395: x_return_status := Fnd_Api.g_ret_sts_error;
396: Fnd_Message.SET_NAME('AHL','AHL_VWP_ITEM_MR_NOT_MATCH');
397: Fnd_Msg_Pub.ADD;
398: END IF;
399: END IF;
400: ******/
401: /* End fix for Bug 4081044 on Dec 22, 2004 by JR */

Line 424: Fnd_Msg_Pub.ADD;

420: x_error_msg_code => l_msg_data);
421:
422: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
423: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
424: Fnd_Msg_Pub.ADD;
425: RAISE Fnd_Api.G_EXC_ERROR;
426: ELSE
427: --Assign the returned value
428: p_x_task_Rec.instance_id := l_instance_id;

Line 436: Fnd_Msg_Pub.ADD;

432: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
433: fnd_log.string(fnd_log.level_statement, l_full_name, 'Check serial not found else');
434: END IF;
435: Fnd_Message.SET_NAME('AHL','AHL_VWP_TSK_SERIAL_MISSING');
436: Fnd_Msg_Pub.ADD;
437: RAISE Fnd_Api.G_EXC_ERROR;
438: END IF; --Serial number not null
439: ELSE --non serial controlled item
440: p_x_task_Rec.instance_id := l_inst_id;

Line 460: Fnd_Msg_Pub.ADD;

456:
457: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
458: THEN
459: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
460: Fnd_Msg_Pub.ADD;
461: RAISE Fnd_Api.G_EXC_ERROR;
462: END IF;
463:
464: -- Changes for Post 11.5.10 by amagrawa

Line 471: Fnd_Msg_Pub.ADD;

467: X_RETURN_STATUS => l_return_status);
468:
469: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN
470: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_DEPT_SHIFT');
471: Fnd_Msg_Pub.ADD;
472: RAISE Fnd_Api.G_EXC_ERROR;
473: END IF;
474: ELSE
475: p_x_task_Rec.dept_name := NULL;

Line 488: Fnd_Msg_Pub.ADD;

484: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
485: fnd_log.string(fnd_log.level_statement, l_full_name, 'NO ORGANIZATION FOR VISIT');
486: END IF;
487: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
488: Fnd_Msg_Pub.ADD;
489: RAISE Fnd_Api.G_EXC_ERROR;
490: END IF;
491: END IF; -- End of if visit org exists
492:

Line 609: Fnd_Msg_Pub.initialize;

605: fnd_log.string(fnd_log.level_procedure, l_full_name || '.begin', 'Entering Procedure');
606: END IF;
607:
608: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
609: Fnd_Msg_Pub.initialize;
610: END IF;
611:
612: IF NOT Fnd_Api.compatible_api_call (
613: L_API_VERSION,

Line 665: Fnd_Msg_Pub.ADD;

661: -- ERROR MESSAGE
662: x_return_status := Fnd_Api.g_ret_sts_error;
663: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
664: Fnd_Message.SET_TOKEN('MR_TITLE', c_MR_Visit_rec.Title);
665: Fnd_Msg_Pub.ADD;
666: CLOSE c_MR_Visit;
667: ***/
668: --End Comment out
669:

Line 678: Fnd_Msg_Pub.ADD;

674: IF l_count > 0 THEN
675: -- ERROR MESSAGE
676: x_return_status := Fnd_Api.g_ret_sts_error;
677: Fnd_Message.SET_NAME('AHL','AHL_VWP_MR_FOUND');
678: Fnd_Msg_Pub.ADD;
679: */
680: --B6452310 - sowsubra
681: -- ELSE
682: -- CLOSE c_MR_Visit;

Line 804: Fnd_Msg_Pub.count_and_get(

800: COMMIT WORK;
801: END IF;
802:
803: -- Standard call to get message count and if count is 1, get message info
804: Fnd_Msg_Pub.count_and_get(
805: p_encoded => Fnd_Api.g_false,
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );

Line 818: Fnd_Msg_Pub.count_and_get(

814: EXCEPTION
815: WHEN Fnd_Api.g_exc_error THEN
816: ROLLBACK TO Create_Unplanned_Task;
817: x_return_status := Fnd_Api.g_ret_sts_error;
818: Fnd_Msg_Pub.count_and_get(
819: p_encoded => Fnd_Api.g_false,
820: p_count => x_msg_count,
821: p_data => x_msg_data
822: );

Line 826: Fnd_Msg_Pub.count_and_get (

822: );
823: WHEN Fnd_Api.g_exc_unexpected_error THEN
824: ROLLBACK TO Create_Unplanned_Task;
825: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
826: Fnd_Msg_Pub.count_and_get (
827: p_encoded => Fnd_Api.g_false,
828: p_count => x_msg_count,
829: p_data => x_msg_data
830: );

Line 834: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

830: );
831: WHEN OTHERS THEN
832: ROLLBACK TO Create_Unplanned_Task;
833: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
834: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
835: THEN
836: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
837: END IF;
838: Fnd_Msg_Pub.count_and_get (

Line 836: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

832: ROLLBACK TO Create_Unplanned_Task;
833: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
834: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
835: THEN
836: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
837: END IF;
838: Fnd_Msg_Pub.count_and_get (
839: p_encoded => Fnd_Api.g_false,
840: p_count => x_msg_count,

Line 838: Fnd_Msg_Pub.count_and_get (

834: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
835: THEN
836: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
837: END IF;
838: Fnd_Msg_Pub.count_and_get (
839: p_encoded => Fnd_Api.g_false,
840: p_count => x_msg_count,
841: p_data => x_msg_data
842: );

Line 903: Fnd_Msg_Pub.initialize;

899: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************Start*************************');
900: END IF;
901:
902: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
903: Fnd_Msg_Pub.initialize;
904: END IF;
905:
906: -- Initialize API return status to success
907: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 957: Fnd_Msg_Pub.ADD;

953:
954: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
955: THEN
956: Fnd_Message.SET_NAME('AHL','AHL_VWP_DEPT_NOT_EXISTS');
957: Fnd_Msg_Pub.ADD;
958: RAISE Fnd_Api.G_EXC_ERROR;
959: END IF;
960:
961: --Assign the returned value

Line 987: Fnd_Msg_Pub.ADD;

983:
984: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS
985: THEN
986: Fnd_Message.SET_NAME('AHL','AHL_VWP_PARENT_NOT_EXISTS');
987: Fnd_Msg_Pub.ADD;
988: RAISE Fnd_Api.g_exc_error;
989: END IF;
990:
991: --Assign the returned value

Line 1048: Fnd_Msg_Pub.ADD;

1044:
1045: -- Check Object version number.
1046: IF (c_task_rec.object_version_number <> l_task_rec.object_version_number) THEN
1047: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1048: Fnd_Msg_Pub.ADD;
1049: RAISE Fnd_Api.G_EXC_ERROR;
1050: END IF;
1051:
1052: -- Post 11.5.10 Changes by Senthil.

Line 1067: l_msg_count := Fnd_Msg_Pub.count_msg;

1063:
1064: END IF;
1065:
1066: --Standard check to count messages
1067: l_msg_count := Fnd_Msg_Pub.count_msg;
1068:
1069: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1070: X_msg_count := l_msg_count;
1071: X_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1157: l_msg_count := Fnd_Msg_Pub.count_msg;

1153: x_msg_data => l_msg_data,
1154: p_task_id => l_task_rec.visit_task_id);
1155:
1156: --Standard check to count messages
1157: l_msg_count := Fnd_Msg_Pub.count_msg;
1158:
1159: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1160: x_msg_count := l_msg_count;
1161: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1215: l_msg_count := Fnd_Msg_Pub.count_msg;

1211:
1212: END IF;
1213:
1214: --Standard check to count messages
1215: l_msg_count := Fnd_Msg_Pub.count_msg;
1216:
1217: IF l_msg_count > 0 THEN
1218: X_msg_count := l_msg_count;
1219: X_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1237: Fnd_Msg_Pub.count_and_get (

1233: EXCEPTION
1234: WHEN Fnd_Api.g_exc_error THEN
1235: ROLLBACK TO Update_Unplanned_Task;
1236: x_return_status := Fnd_Api.g_ret_sts_error;
1237: Fnd_Msg_Pub.count_and_get (
1238: p_encoded => Fnd_Api.g_false,
1239: p_count => x_msg_count,
1240: p_data => x_msg_data
1241: );

Line 1245: Fnd_Msg_Pub.count_and_get (

1241: );
1242: WHEN Fnd_Api.g_exc_unexpected_error THEN
1243: ROLLBACK TO Update_Unplanned_Task;
1244: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1245: Fnd_Msg_Pub.count_and_get (
1246: p_encoded => Fnd_Api.g_false,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data
1249: );

Line 1253: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1249: );
1250: WHEN OTHERS THEN
1251: ROLLBACK TO Update_Unplanned_Task;
1252: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1253: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1254: THEN
1255: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1256: END IF;
1257: Fnd_Msg_Pub.count_and_get (

Line 1255: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1251: ROLLBACK TO Update_Unplanned_Task;
1252: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1253: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1254: THEN
1255: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1256: END IF;
1257: Fnd_Msg_Pub.count_and_get (
1258: p_encoded => Fnd_Api.g_false,
1259: p_count => x_msg_count,

Line 1257: Fnd_Msg_Pub.count_and_get (

1253: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1254: THEN
1255: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1256: END IF;
1257: Fnd_Msg_Pub.count_and_get (
1258: p_encoded => Fnd_Api.g_false,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data
1261: );

Line 1309: Fnd_Msg_Pub.initialize;

1305: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||':*************************START*************************');
1306: END IF;
1307:
1308: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1309: Fnd_Msg_Pub.initialize;
1310: END IF;
1311:
1312: -- Initialize API return status to success
1313: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1339: Fnd_Msg_Pub.ADD;

1335: IF c_Task%NOTFOUND THEN
1336: CLOSE c_Task;
1337: Fnd_Message.set_name('AHL', 'AHL_VWP_TASK_ID_INVALID');
1338: FND_MESSAGE.SET_TOKEN('TASK_ID',p_visit_task_id,false);
1339: Fnd_Msg_Pub.ADD;
1340: RAISE Fnd_Api.g_exc_error;
1341: ELSE
1342: CLOSE c_Task;
1343:

Line 1370: Fnd_Msg_Pub.ADD;

1366: END IF;
1367:
1368: Else
1369: Fnd_Message.SET_NAME('AHL','AHL_VWP_UNPLANNEDTASKMR');
1370: Fnd_Msg_Pub.ADD;
1371: RAISE Fnd_Api.G_EXC_ERROR;
1372: --Displays 'Unplanned Task association to Maintenance Requirement is missing.'
1373: End IF;
1374:

Line 1388: l_msg_count := Fnd_Msg_Pub.count_msg;

1384: P_UNIT_EFFECTIVITY_ID => c_task_rec.unit_effectivity_id
1385: );
1386: */
1387:
1388: l_msg_count := Fnd_Msg_Pub.count_msg;
1389:
1390: IF l_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1391: X_msg_count := l_msg_count;
1392: X_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1414: Fnd_Msg_Pub.count_and_get (

1410: EXCEPTION
1411: WHEN Fnd_Api.g_exc_error THEN
1412: ROLLBACK TO Delete_Unplanned_Task;
1413: x_return_status := Fnd_Api.g_ret_sts_error;
1414: Fnd_Msg_Pub.count_and_get (
1415: p_encoded => Fnd_Api.g_false,
1416: p_count => x_msg_count,
1417: p_data => x_msg_data
1418: );

Line 1423: Fnd_Msg_Pub.count_and_get (

1419:
1420: WHEN Fnd_Api.g_exc_unexpected_error THEN
1421: ROLLBACK TO Delete_Unplanned_Task;
1422: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1423: Fnd_Msg_Pub.count_and_get (
1424: p_encoded => Fnd_Api.g_false,
1425: p_count => x_msg_count,
1426: p_data => x_msg_data
1427: );

Line 1432: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

1428:
1429: WHEN OTHERS THEN
1430: ROLLBACK TO Delete_Unplanned_Task;
1431: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1432: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1433: THEN
1434: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1435: END IF;
1436: Fnd_Msg_Pub.count_and_get (

Line 1434: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

1430: ROLLBACK TO Delete_Unplanned_Task;
1431: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1432: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1433: THEN
1434: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1435: END IF;
1436: Fnd_Msg_Pub.count_and_get (
1437: p_encoded => Fnd_Api.g_false,
1438: p_count => x_msg_count,

Line 1436: Fnd_Msg_Pub.count_and_get (

1432: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1433: THEN
1434: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1435: END IF;
1436: Fnd_Msg_Pub.count_and_get (
1437: p_encoded => Fnd_Api.g_false,
1438: p_count => x_msg_count,
1439: p_data => x_msg_data
1440: );

Line 1526: Fnd_Msg_Pub.ADD;

1522: FETCH c_Visit_Task INTO l_task_rec;
1523: IF c_Visit_Task%NOTFOUND THEN
1524: CLOSE c_Visit_Task;
1525: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1526: Fnd_Msg_Pub.ADD;
1527: RAISE Fnd_Api.g_exc_error;
1528: END IF;
1529: CLOSE c_Visit_Task;
1530:

Line 1556: Fnd_Msg_Pub.ADD;

1552: END IF;
1553: -- TASK NAME ==== NAME
1554: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN
1555: Fnd_Message.set_name ('AHL', 'AHL_VWP_NAME_MISSING');
1556: Fnd_Msg_Pub.ADD;
1557: x_return_status := Fnd_Api.g_ret_sts_error;
1558: RETURN;
1559: END IF;
1560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1566: Fnd_Msg_Pub.ADD;

1562: END IF;
1563: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
1564: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN
1565: Fnd_Message.set_name ('AHL', 'AHL_VWP_ONLY_POSITIVE_VALUE');
1566: Fnd_Msg_Pub.ADD;
1567: x_return_status := Fnd_Api.g_ret_sts_error;
1568: RETURN;
1569: END IF;
1570: END IF;

Line 1608: Fnd_Msg_Pub.ADD;

1604: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
1605: ) = Fnd_Api.g_false
1606: THEN
1607: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');
1608: Fnd_Msg_Pub.ADD;
1609: x_return_status := Fnd_Api.g_ret_sts_error;
1610: RETURN;
1611: END IF;
1612: END IF;