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_PUB dependencies on FND_LOG

Line 73: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

69:
70: --
71:
72: BEGIN
73: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
74: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API.');
75: END IF;
76:
77: -- Standard start of API savepoint

Line 74: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API.');

70: --
71:
72: BEGIN
73: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
74: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API.');
75: END IF;
76:
77: -- Standard start of API savepoint
78: SAVEPOINT Create_Visit_Pub;

Line 98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

94: -- Validate the input and prepare for subsequent calls
95: -- If there are errors, an exception is raised.
96: Validate_And_Prepare_Params(p_x_visit_rec => p_x_visit_rec);
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');
100: END IF;
101: l_Visit_tbl(1) := p_x_visit_rec;
102:

Line 99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');

95: -- If there are errors, an exception is raised.
96: Validate_And_Prepare_Params(p_x_visit_rec => p_x_visit_rec);
97:
98: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'About to call AHL_VWP_VISITS_PVT.Create_Visit.');
100: END IF;
101: l_Visit_tbl(1) := p_x_visit_rec;
102:
103: AHL_VWP_VISITS_PVT.Process_Visit(p_api_version => 1.0,

Line 113: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

109: x_return_status => x_return_status,
110: x_msg_count => x_msg_count,
111: x_msg_data => x_msg_data);
112:
113: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Returned from AHL_VWP_VISITS_PVT.Create_Visit. x_return_status = ' || x_return_status);
115: END IF;
116:
117: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 114: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Returned from AHL_VWP_VISITS_PVT.Create_Visit. x_return_status = ' || x_return_status);

110: x_msg_count => x_msg_count,
111: x_msg_data => x_msg_data);
112:
113: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Returned from AHL_VWP_VISITS_PVT.Create_Visit. x_return_status = ' || x_return_status);
115: END IF;
116:
117: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
118: RAISE FND_API.G_EXC_ERROR;

Line 125: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

121: END IF;
122:
123: p_x_visit_rec.VISIT_ID := l_Visit_tbl(1).VISIT_ID;
124:
125: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
126: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Visit created successfully with name ' ||
127: p_x_visit_rec.VISIT_NAME || ' and id ' || p_x_visit_rec.VISIT_ID);
128: END IF;
129:

Line 126: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Visit created successfully with name ' ||

122:
123: p_x_visit_rec.VISIT_ID := l_Visit_tbl(1).VISIT_ID;
124:
125: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
126: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Visit created successfully with name ' ||
127: p_x_visit_rec.VISIT_NAME || ' and id ' || p_x_visit_rec.VISIT_ID);
128: END IF;
129:
130: -- Standard check of p_commit

Line 142: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

138: p_data => x_msg_data,
139: p_encoded => FND_API.G_FALSE
140: );
141:
142: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
143: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
144: END IF;
145:
146: EXCEPTION

Line 143: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');

139: p_encoded => FND_API.G_FALSE
140: );
141:
142: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
143: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'End of the API');
144: END IF;
145:
146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN

Line 205: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

201: WHERE project_id = c_proj_template_id
202: AND template_flag = 'Y';
203:
204: BEGIN
205: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
206: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
207: END IF;
208:
209: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 206: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');

202: AND template_flag = 'Y';
203:
204: BEGIN
205: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
206: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
207: END IF;
208:
209: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
210: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Values of important attributes in p_x_visit_rec: ' ||

Line 209: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

205: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
206: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
207: END IF;
208:
209: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
210: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Values of important attributes in p_x_visit_rec: ' ||
211: 'operation_flag = ' || p_x_visit_rec.operation_flag ||
212: ', organization_id = ' || p_x_visit_rec.organization_id ||
213: ', department_id = ' || p_x_visit_rec.department_id ||

Line 210: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Values of important attributes in p_x_visit_rec: ' ||

206: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.begin', 'At the start of the API');
207: END IF;
208:
209: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
210: FND_LOG.string(FND_LOG.level_statement, l_full_name, 'Values of important attributes in p_x_visit_rec: ' ||
211: 'operation_flag = ' || p_x_visit_rec.operation_flag ||
212: ', organization_id = ' || p_x_visit_rec.organization_id ||
213: ', department_id = ' || p_x_visit_rec.department_id ||
214: ', service_request_id = ' || p_x_visit_rec.service_request_id ||

Line 336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

332: OPEN get_unit_name_csr(c_uc_header_id => p_x_visit_rec.unit_header_id);
333: FETCH get_unit_name_csr INTO p_x_visit_rec.unit_name;
334: --SKPATHAK :: Bug 8216902 :: :: Validation for unit_header_id added
335: IF get_unit_name_csr%NOTFOUND THEN
336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
337: fnd_log.string(FND_LOG.level_statement, l_full_name, 'Unit does not exist..');
338: END IF;
339: Fnd_Message.Set_Name('AHL','AHL_UC_API_PARAMETER_INVALID');
340: Fnd_Message.Set_Token('NAME', 'UNIT_HEADER_ID');

Line 337: fnd_log.string(FND_LOG.level_statement, l_full_name, 'Unit does not exist..');

333: FETCH get_unit_name_csr INTO p_x_visit_rec.unit_name;
334: --SKPATHAK :: Bug 8216902 :: :: Validation for unit_header_id added
335: IF get_unit_name_csr%NOTFOUND THEN
336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
337: fnd_log.string(FND_LOG.level_statement, l_full_name, 'Unit does not exist..');
338: END IF;
339: Fnd_Message.Set_Name('AHL','AHL_UC_API_PARAMETER_INVALID');
340: Fnd_Message.Set_Token('NAME', 'UNIT_HEADER_ID');
341: Fnd_Message.Set_Token('VALUE', p_x_visit_rec.unit_header_id);

Line 384: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

380: END IF;
381: END IF;
382:
383: IF(NOT l_valid_flag) THEN
384: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
385: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Faced validation errors. Exiting with execution exception.');
386: END IF;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;

Line 385: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Faced validation errors. Exiting with execution exception.');

381: END IF;
382:
383: IF(NOT l_valid_flag) THEN
384: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
385: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Faced validation errors. Exiting with execution exception.');
386: END IF;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:

Line 390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

386: END IF;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
391: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Exiting API - Params validated.');
392: END IF;
393: END Validate_And_Prepare_Params;
394:

Line 391: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Exiting API - Params validated.');

387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
391: FND_LOG.string(FND_LOG.level_procedure, l_full_name || '.end', 'Exiting API - Params validated.');
392: END IF;
393: END Validate_And_Prepare_Params;
394:
395: End AHL_VWP_VISITS_PUB;