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.

[Home] [Help]

APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_API

Line 49: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

45: -- Parameters :
46: --
47: -- Standard IN Parameters :
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
52: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
53: -- Based on this flag, the API will set the default attributes.

Line 50: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

46: --
47: -- Standard IN Parameters :
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
52: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
53: -- Based on this flag, the API will set the default attributes.
54: -- p_module_type IN VARCHAR2 Default NULL

Line 51: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

47: -- Standard IN Parameters :
48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
52: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
53: -- Based on this flag, the API will set the default attributes.
54: -- p_module_type IN VARCHAR2 Default NULL
55: -- This will be null.

Line 52: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

48: -- p_api_version IN NUMBER Required
49: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
50: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
52: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
53: -- Based on this flag, the API will set the default attributes.
54: -- p_module_type IN VARCHAR2 Default NULL
55: -- This will be null.
56: -- Standard OUT Parameters :

Line 84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

80:
81: PROCEDURE Search_MR_Instances
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_default IN VARCHAR2 := FND_API.G_TRUE,
88: p_module_type IN VARCHAR2 := NULL,

Line 85: p_commit IN VARCHAR2 := FND_API.G_FALSE,

81: PROCEDURE Search_MR_Instances
82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_default IN VARCHAR2 := FND_API.G_TRUE,
88: p_module_type IN VARCHAR2 := NULL,
89: p_start_row IN NUMBER,

Line 86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

82: (
83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_default IN VARCHAR2 := FND_API.G_TRUE,
88: p_module_type IN VARCHAR2 := NULL,
89: p_start_row IN NUMBER,
90: p_rows_per_page IN NUMBER,

Line 87: p_default IN VARCHAR2 := FND_API.G_TRUE,

83: p_api_version IN NUMBER,
84: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85: p_commit IN VARCHAR2 := FND_API.G_FALSE,
86: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87: p_default IN VARCHAR2 := FND_API.G_TRUE,
88: p_module_type IN VARCHAR2 := NULL,
89: p_start_row IN NUMBER,
90: p_rows_per_page IN NUMBER,
91: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,

Line 340: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

336: -- Standard start of API savepoint
337: SAVEPOINT Search_MR_Instances_Pvt;
338:
339: -- Standard call to check for call compatibility
340: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
341: G_PKG_NAME) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338:
339: -- Standard call to check for call compatibility
340: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
341: G_PKG_NAME) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 346: IF FND_API.To_Boolean(p_init_msg_list) THEN

342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
352:
353:
354: -- other initilizations needed for API
355: l_early_exit_status := TRUE;

Line 526: RAISE FND_API.G_EXC_ERROR;

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
530: --SELECT Clause

Line 972: RAISE FND_API.G_EXC_ERROR;

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 )';
976:

Line 1115: RAISE FND_API.G_EXC_ERROR;

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
1119: l_visit_number IS NULL ) OR

Line 1347: p_encoded => fnd_api.g_false

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
1348: );
1349:
1350: -- Logging input
1351: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN

Line 1369: WHEN FND_API.G_EXC_ERROR THEN

1365: );
1366: END IF;
1367:
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,

Line 1370: x_return_status := FND_API.G_RET_STS_ERROR;

1366: END IF;
1367:
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);

Line 1374: p_encoded => fnd_api.g_false);

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:
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1373: p_data => x_msg_data,
1374: p_encoded => fnd_api.g_false);
1375:
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,

Line 1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1374: p_encoded => fnd_api.g_false);
1375:
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);

Line 1382: p_encoded => fnd_api.g_false);

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
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: ROLLBACK TO Search_MR_Instances_Pvt;

Line 1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1381: p_data => x_msg_data,
1382: p_encoded => fnd_api.g_false);
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);

Line 1393: p_encoded => fnd_api.g_false);

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;
1396:
1397:

Line 1779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1775: -- Parameters :
1776: --
1777: -- Standard IN Parameters :
1778: -- p_api_version IN NUMBER Required
1779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1782: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1783: -- Based on this flag, the API will set the default attributes.

Line 1780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1776: --
1777: -- Standard IN Parameters :
1778: -- p_api_version IN NUMBER Required
1779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1782: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1783: -- Based on this flag, the API will set the default attributes.
1784: -- p_module_type IN VARCHAR2 Default NULL

Line 1781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1777: -- Standard IN Parameters :
1778: -- p_api_version IN NUMBER Required
1779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1782: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1783: -- Based on this flag, the API will set the default attributes.
1784: -- p_module_type IN VARCHAR2 Default NULL
1785: -- This will be null.

Line 1782: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

1778: -- p_api_version IN NUMBER Required
1779: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1780: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1781: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1782: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
1783: -- Based on this flag, the API will set the default attributes.
1784: -- p_module_type IN VARCHAR2 Default NULL
1785: -- This will be null.
1786: -- Standard OUT Parameters :

Line 1807: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

1803:
1804: PROCEDURE BUILD_UMP_SEARCH_QUERY
1805: (
1806: P_API_VERSION IN NUMBER,
1807: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,

Line 1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

1804: PROCEDURE BUILD_UMP_SEARCH_QUERY
1805: (
1806: P_API_VERSION IN NUMBER,
1807: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,

Line 1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1805: (
1806: P_API_VERSION IN NUMBER,
1807: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,

Line 1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,

1806: P_API_VERSION IN NUMBER,
1807: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
1808: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
1809: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1810: P_DEFAULT IN VARCHAR2 := FND_API.G_TRUE,
1811: P_MODULE_TYPE IN VARCHAR2 := NULL,
1812: P_SEARCH_UMP_REC IN AHL_UMP_SMRINSTANCE_PVT.SEARCH_UMP_REC_TYPE,
1813: X_UMP_SEARCH_QUERY OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_SEARCH_QUERY_TYPE,
1814: X_UMP_BIND_PARAMS OUT NOCOPY AHL_UMP_SMRINSTANCE_PVT.UMP_BIND_PARAM_TBL_TYPE,

Line 1844: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME,

1840: 'At the start of PLSQL procedure'
1841: );
1842: END IF;
1843: -- Standard call to check for call compatibility
1844: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME,
1845: G_PKG_NAME) THEN
1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1847: END IF;
1848:

Line 1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1842: END IF;
1843: -- Standard call to check for call compatibility
1844: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION, P_API_VERSION, L_API_NAME,
1845: G_PKG_NAME) THEN
1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1850: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN

1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1855: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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;
1856: --Build query here
1857: L_DUMMY_SEARCH_QUERY := 'select ''N'' select_flag,
1858: ''Show'' details, null unit_name,null prog_type,null mr_header_id, null title,
1859: null concatenated_segments,null serial_number,null name,null uom_code,

Line 2065: RAISE FND_API.G_EXC_ERROR;

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');
2069: FND_MSG_PUB.ADD;

Line 2070: 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;
2074: END IF;

Line 2155: RAISE FND_API.G_EXC_ERROR;

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
2159: L_DURATION := P_SEARCH_UMP_REC.MAX_DURATION/24;

Line 2181: RAISE FND_API.G_EXC_ERROR;

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 ||')';
2185: L_BIND_INDEX := L_BIND_INDEX+1;

Line 2337: RAISE FND_API.G_EXC_ERROR;

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');
2341: FND_MSG_PUB.ADD;

Line 2342: 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;
2346: END IF;

Line 2478: P_ENCODED => FND_API.G_FALSE );

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:
2480: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );
2482: END IF;

Line 2485: WHEN FND_API.G_EXC_ERROR THEN

2481: FND_LOG.STRING ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_SMRINSTANCE_PVT.Build_Ump_Search_query.end', 'At the end of PLSQL procedure' );
2482: END IF;
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);

Line 2486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

2482: END IF;
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:

Line 2489: P_ENCODED => FND_API.G_FALSE);

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:
2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2488: P_DATA => X_MSG_DATA,
2489: P_ENCODED => FND_API.G_FALSE);
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);

Line 2493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2489: P_ENCODED => FND_API.G_FALSE);
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:

Line 2496: P_ENCODED => FND_API.G_FALSE);

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
2499: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
2500: FND_MSG_PUB.ADD_EXC_MSG( P_PKG_NAME => G_PKG_NAME,

Line 2499: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

2495: P_DATA => X_MSG_DATA,
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:

Line 2506: P_ENCODED => FND_API.G_FALSE);

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:
2509: END BUILD_UMP_SEARCH_QUERY;
2510: