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_API

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

40: -- Parameters :
41: --
42: -- Standard IN Parameters :
43: -- p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
46: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
47: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
48: -- Based on this flag, the API will set the default attributes.

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

41: --
42: -- Standard IN Parameters :
43: -- p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
46: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
47: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
48: -- Based on this flag, the API will set the default attributes.
49: -- p_module_type IN VARCHAR2 Default NULL

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

42: -- Standard IN Parameters :
43: -- p_api_version IN NUMBER Required
44: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
45: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
46: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
47: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
48: -- Based on this flag, the API will set the default attributes.
49: -- p_module_type IN VARCHAR2 Default NULL
50: -- This will be null.

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

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

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

75:
76: PROCEDURE Search_MR_Instances
77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_default IN VARCHAR2 := FND_API.G_TRUE,
83: p_module_type IN VARCHAR2 := NULL,

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

76: PROCEDURE Search_MR_Instances
77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_default IN VARCHAR2 := FND_API.G_TRUE,
83: p_module_type IN VARCHAR2 := NULL,
84: p_start_row IN NUMBER,

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

77: (
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_default IN VARCHAR2 := FND_API.G_TRUE,
83: p_module_type IN VARCHAR2 := NULL,
84: p_start_row IN NUMBER,
85: p_rows_per_page IN NUMBER,

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

78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
82: p_default IN VARCHAR2 := FND_API.G_TRUE,
83: p_module_type IN VARCHAR2 := NULL,
84: p_start_row IN NUMBER,
85: p_rows_per_page IN NUMBER,
86: p_search_mr_instance_rec IN AHL_UMP_SMRINSTANCE_PVT.Search_MRInstance_Rec_Type,

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

308: -- Standard start of API savepoint
309: SAVEPOINT Search_MR_Instances_Pvt;
310:
311: -- Standard call to check for call compatibility
312: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
313: G_PKG_NAME) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310:
311: -- Standard call to check for call compatibility
312: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
313: G_PKG_NAME) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: -- Initialize message list if p_init_msg_list is set to TRUE
318: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 318: IF FND_API.To_Boolean(p_init_msg_list) THEN

314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: -- Initialize message list if p_init_msg_list is set to TRUE
318: IF FND_API.To_Boolean(p_init_msg_list) THEN
319: FND_MSG_PUB.Initialize;
320: END IF;
321:
322: -- Initialize API return status to success

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: FND_MSG_PUB.Initialize;
320: END IF;
321:
322: -- Initialize API return status to success
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325:
326: -- other initilizations needed for API
327: l_early_exit_status := TRUE;

Line 460: RAISE FND_API.G_EXC_ERROR;

456: (p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL OR p_search_mr_instance_rec.SERVICE_REQ_NUM IS NOT NULL)
457: THEN
458: FND_MESSAGE.Set_Name('AHL','AHL_UMP_MR_SERQ_INPUT');
459: FND_MSG_PUB.ADD;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: --start fix for bug#7327283
464: --SELECT Clause

Line 982: RAISE FND_API.G_EXC_ERROR;

978: END IF;
979: --amsriniv ER 6116245
980: --Error check
981: IF FND_MSG_PUB.count_msg > 0 THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: -- Handling Scheduled and Unscheduled status.
985: IF ( p_search_mr_instance_rec.mr_status = 'SCHEDULED' AND
986: l_visit_number IS NULL ) OR

Line 1156: p_encoded => fnd_api.g_false

1152: FND_MSG_PUB.Count_And_Get
1153: (
1154: p_count => x_msg_count,
1155: p_data => x_msg_data,
1156: p_encoded => fnd_api.g_false
1157: );
1158:
1159: -- Logging input
1160: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN

Line 1178: WHEN FND_API.G_EXC_ERROR THEN

1174: );
1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ROLLBACK TO Search_MR_Instances_Pvt;
1181: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1182: p_data => x_msg_data,

Line 1179: x_return_status := FND_API.G_RET_STS_ERROR;

1175: END IF;
1176:
1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ROLLBACK TO Search_MR_Instances_Pvt;
1181: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1182: p_data => x_msg_data,
1183: p_encoded => fnd_api.g_false);

Line 1183: p_encoded => fnd_api.g_false);

1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ROLLBACK TO Search_MR_Instances_Pvt;
1181: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1182: p_data => x_msg_data,
1183: p_encoded => fnd_api.g_false);
1184:
1185:
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1182: p_data => x_msg_data,
1183: p_encoded => fnd_api.g_false);
1184:
1185:
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: ROLLBACK TO Search_MR_Instances_Pvt;
1189: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1190: p_data => x_msg_data,

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1183: p_encoded => fnd_api.g_false);
1184:
1185:
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: ROLLBACK TO Search_MR_Instances_Pvt;
1189: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1190: p_data => x_msg_data,
1191: p_encoded => fnd_api.g_false);

Line 1191: p_encoded => fnd_api.g_false);

1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: ROLLBACK TO Search_MR_Instances_Pvt;
1189: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1190: p_data => x_msg_data,
1191: p_encoded => fnd_api.g_false);
1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: ROLLBACK TO Search_MR_Instances_Pvt;

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190: p_data => x_msg_data,
1191: p_encoded => fnd_api.g_false);
1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: ROLLBACK TO Search_MR_Instances_Pvt;
1196: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1197: p_procedure_name => 'Search_MR_Instances',
1198: p_error_text => SQLERRM);

Line 1202: p_encoded => fnd_api.g_false);

1198: p_error_text => SQLERRM);
1199:
1200: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1201: p_data => x_msg_data,
1202: p_encoded => fnd_api.g_false);
1203:
1204: END Search_MR_Instances;
1205:
1206: