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

Line 347: FND_MSG_PUB.Initialize;

343: END IF;
344:
345: -- Initialize message list if p_init_msg_list is set to TRUE
346: IF FND_API.To_Boolean(p_init_msg_list) THEN
347: FND_MSG_PUB.Initialize;
348: END IF;
349:
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 525: FND_MSG_PUB.ADD;

521: IF (p_search_mr_instance_rec.mr_title is NOT NULL) AND
522: (p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL OR p_search_mr_instance_rec.SERVICE_REQ_NUM IS NOT NULL)
523: THEN
524: FND_MESSAGE.Set_Name('AHL','AHL_UMP_MR_SERQ_INPUT');
525: FND_MSG_PUB.ADD;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528:
529: --start fix for bug#7327283

Line 971: FND_MSG_PUB.ADD;

967: END IF;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_ERROR;
973: END;
974: l_sql_string := l_sql_string || ' and exists (select ''x'' from AHL_MR_HEADERS_B MRB ';
975: l_sql_string := l_sql_string || ' WHERE UMP.mr_header_id = MRB.mr_header_id AND MRB.SERVICE_CATEGORY_RANK >= :SERVICE_CATEGORY_RANK )';

Line 1114: IF FND_MSG_PUB.count_msg > 0 THEN

1110: l_pick_record_flag := FALSE;
1111: END IF;
1112: --amsriniv ER 6116245
1113: --Error check
1114: IF FND_MSG_PUB.count_msg > 0 THEN
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117: -- Handling Scheduled and Unscheduled status.
1118: IF ( p_search_mr_instance_rec.mr_status = 'SCHEDULED' AND

Line 1343: FND_MSG_PUB.Count_And_Get

1339: --Close the dynamic cursor and free up resources
1340: CLOSE l_cur;
1341:
1342: -- Standard call to get message count and if count is 1, get message info
1343: FND_MSG_PUB.Count_And_Get
1344: (
1345: p_count => x_msg_count,
1346: p_data => x_msg_data,
1347: p_encoded => fnd_api.g_false

Line 1372: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1368: EXCEPTION
1369: WHEN FND_API.G_EXC_ERROR THEN
1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: ROLLBACK TO Search_MR_Instances_Pvt;
1372: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1373: p_data => x_msg_data,
1374: p_encoded => fnd_api.g_false);
1375:
1376:

Line 1380: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1376:
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: ROLLBACK TO Search_MR_Instances_Pvt;
1380: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1381: p_data => x_msg_data,
1382: p_encoded => fnd_api.g_false);
1383:
1384: WHEN OTHERS THEN

Line 1387: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

1383:
1384: WHEN OTHERS THEN
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: ROLLBACK TO Search_MR_Instances_Pvt;
1387: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1388: p_procedure_name => 'Search_MR_Instances',
1389: p_error_text => SQLERRM);
1390:
1391: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1391: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1387: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1388: p_procedure_name => 'Search_MR_Instances',
1389: p_error_text => SQLERRM);
1390:
1391: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1392: p_data => x_msg_data,
1393: p_encoded => fnd_api.g_false);
1394:
1395: END Search_MR_Instances;

Line 1851: FND_MSG_PUB.INITIALIZE;

1847: END IF;
1848:
1849: -- Initialize message list if p_init_msg_list is set to TRUE
1850: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
1851: FND_MSG_PUB.INITIALIZE;
1852: END IF;
1853:
1854: -- Initialize API return status to success
1855: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 2064: FND_MSG_PUB.ADD;

2060: END IF;
2061: /* *********************************** BEGIN: SHOW TOLERANCE ****************************************** */
2062: IF ((P_SEARCH_UMP_REC.DUE_FROM IS NOT NULL AND P_SEARCH_UMP_REC.DUE_TO IS NOT NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL))THEN
2063: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');
2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2067: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2068: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');

Line 2069: FND_MSG_PUB.ADD;

2065: RAISE FND_API.G_EXC_ERROR;
2066: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2067: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2068: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');
2069: FND_MSG_PUB.ADD;
2070: RAISE FND_API.G_EXC_ERROR;
2071: ELSIF (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NOT NULL)THEN
2072: IF(L_DUE_FROM IS NULL AND L_DUE_TO IS NULL)THEN
2073: L_DUE_FROM := SYSDATE;

Line 2154: FND_MSG_PUB.ADD;

2150: -- Max Duration
2151: IF (P_SEARCH_UMP_REC.MAX_DURATION IS NOT NULL AND (P_SEARCH_UMP_REC.MAX_DURATION_UOM IS NULL
2152: OR P_SEARCH_UMP_REC.MAX_DURATION_UOM NOT IN ('HOUR','DAY')) )THEN
2153: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_MXDUR_UOM_NLL');
2154: FND_MSG_PUB.ADD;
2155: RAISE FND_API.G_EXC_ERROR;
2156: ELSIF (P_SEARCH_UMP_REC.MAX_DURATION IS NOT NULL AND P_SEARCH_UMP_REC.MAX_DURATION_UOM IS NOT NULL)THEN
2157: L_DURATION := 0;
2158: IF(P_SEARCH_UMP_REC.MAX_DURATION_UOM = 'HOUR')THEN

Line 2180: FND_MSG_PUB.ADD;

2176: END IF;
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_SCAT_NON_NUM');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: END;
2183: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.SERVICE_CATEGORY;
2184: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and MRB.SERVICE_CATEGORY_RANK >= (:' ||L_BIND_INDEX ||')';

Line 2336: FND_MSG_PUB.ADD;

2332: END IF;
2333: /* *********************************** BEGIN: SHOW TOLERANCE ****************************************** */
2334: IF ((P_SEARCH_UMP_REC.DUE_FROM IS NOT NULL AND P_SEARCH_UMP_REC.DUE_TO IS NOT NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL))THEN
2335: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DFROM_DWITHIN_CFLT');
2336: FND_MSG_PUB.ADD;
2337: RAISE FND_API.G_EXC_ERROR;
2338: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2339: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2340: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');

Line 2341: FND_MSG_PUB.ADD;

2337: RAISE FND_API.G_EXC_ERROR;
2338: ELSIF ((P_SEARCH_UMP_REC.DUE_FROM IS NULL OR P_SEARCH_UMP_REC.DUE_TO IS NULL) AND (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND (P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NULL
2339: OR P_SEARCH_UMP_REC.DUE_WITHIN_UOM NOT IN ('HOUR','DAY')) ))THEN
2340: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_MR_DWITHIN_UOM_NLL');
2341: FND_MSG_PUB.ADD;
2342: RAISE FND_API.G_EXC_ERROR;
2343: ELSIF (P_SEARCH_UMP_REC.DUE_WITHIN IS NOT NULL AND P_SEARCH_UMP_REC.DUE_WITHIN_UOM IS NOT NULL)THEN
2344: IF(L_DUE_FROM IS NULL AND L_DUE_TO IS NULL)THEN
2345: L_DUE_FROM := SYSDATE;

Line 2475: FND_MSG_PUB.COUNT_AND_GET (

2471: );
2472: END IF;
2473: END IF;
2474: -- Standard call to get message count and if count is 1, get message info
2475: FND_MSG_PUB.COUNT_AND_GET (
2476: P_COUNT => X_MSG_COUNT,
2477: P_DATA => X_MSG_DATA,
2478: P_ENCODED => FND_API.G_FALSE );
2479:

Line 2487: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,

2483:
2484: EXCEPTION
2485: WHEN FND_API.G_EXC_ERROR THEN
2486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2487: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2488: P_DATA => X_MSG_DATA,
2489: P_ENCODED => FND_API.G_FALSE);
2490:
2491:

Line 2494: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,

2490:
2491:
2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2494: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2495: P_DATA => X_MSG_DATA,
2496: P_ENCODED => FND_API.G_FALSE);
2497:
2498: WHEN OTHERS THEN

Line 2500: FND_MSG_PUB.ADD_EXC_MSG( P_PKG_NAME => G_PKG_NAME,

2496: P_ENCODED => FND_API.G_FALSE);
2497:
2498: WHEN OTHERS THEN
2499: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2500: FND_MSG_PUB.ADD_EXC_MSG( P_PKG_NAME => G_PKG_NAME,
2501: P_PROCEDURE_NAME => 'Build_Ump_Search_query',
2502: P_ERROR_TEXT => SQLERRM);
2503:
2504: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,

Line 2504: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,

2500: FND_MSG_PUB.ADD_EXC_MSG( P_PKG_NAME => G_PKG_NAME,
2501: P_PROCEDURE_NAME => 'Build_Ump_Search_query',
2502: P_ERROR_TEXT => SQLERRM);
2503:
2504: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT,
2505: P_DATA => X_MSG_DATA,
2506: P_ENCODED => FND_API.G_FALSE);
2507:
2508: