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

Line 4093: FND_MSG_PUB.initialize;

4089: END IF;
4090: -- Standard call to check for call compatibility.
4091: IF FND_API.to_boolean(p_init_msg_list)
4092: THEN
4093: FND_MSG_PUB.initialize;
4094: END IF;
4095: -- Initialize API return status to success
4096: x_return_status := FND_API.G_RET_STS_SUCCESS;
4097: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4122: Fnd_Msg_Pub.ADD;

4118: FETCH l_org_id_cur INTO l_search_visits_Rec.ORG_ID,l_search_visits_Rec.ORG_NAME;
4119: IF l_org_id_cur%NOTFOUND THEN
4120: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_ORG');
4121: Fnd_Message.Set_Token('ORG',NVL(l_search_visits_Rec.ORG_NAME,l_search_visits_Rec.ORG_ID));
4122: Fnd_Msg_Pub.ADD;
4123: CLOSE l_org_id_cur;
4124: RAISE Fnd_Api.G_EXC_ERROR;
4125: --
4126: END IF;

Line 4145: Fnd_Msg_Pub.ADD;

4141:
4142: IF NVL(l_return_status, 'X') <> 'S'
4143: THEN
4144: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');
4145: Fnd_Msg_Pub.ADD;
4146: RAISE Fnd_Api.G_EXC_ERROR;
4147: END IF;
4148: ELSE
4149: -- Id presents

Line 4172: Fnd_Msg_Pub.ADD;

4168:
4169: IF NVL(l_return_status, 'X') <> 'S'
4170: THEN
4171: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_INVALID');
4172: Fnd_Msg_Pub.ADD;
4173: RAISE Fnd_Api.G_EXC_ERROR;
4174: END IF;
4175: ELSE
4176: -- Id presents

Line 4193: Fnd_Msg_Pub.ADD;

4189: FETCH l_item_name_cur INTO l_search_visits_rec.item_id;
4190: IF l_item_name_cur%NOTFOUND THEN
4191: Fnd_Message.set_name('AHL', 'AHL_LTP_ITEM_NOT_EXIST');
4192: Fnd_Message.Set_Token('ITEM',NVL(l_search_visits_Rec.ITEM_DESCRIPTION,l_search_visits_Rec.ITEM_ID));
4193: Fnd_Msg_Pub.ADD;
4194: CLOSE l_item_name_cur;
4195: RAISE Fnd_Api.G_EXC_ERROR;
4196: END IF;
4197: CLOSE l_item_name_cur;

Line 4207: Fnd_Msg_Pub.ADD;

4203: FETCH l_item_id_cur INTO l_search_visits_rec.item_id;
4204: IF l_item_id_cur%NOTFOUND THEN
4205: Fnd_Message.set_name('AHL', 'AHL_LTP_ITEM_NOT_EXIST');
4206: Fnd_Message.Set_Token('ITEM',NVL(l_search_visits_Rec.ITEM_DESCRIPTION,l_search_visits_Rec.ITEM_ID));
4207: Fnd_Msg_Pub.ADD;
4208: CLOSE l_item_id_cur;
4209: RAISE Fnd_Api.G_EXC_ERROR;
4210: END IF;
4211: CLOSE l_item_id_cur;

Line 4230: Fnd_Msg_Pub.ADD;

4226:
4227: IF NVL(l_return_status, 'X') <> 'S'
4228: THEN
4229: Fnd_Message.SET_NAME('AHL','AHL_LTP_DISPLAY_INVALID');
4230: Fnd_Msg_Pub.ADD;
4231: RAISE Fnd_Api.G_EXC_ERROR;
4232: END IF;
4233: ELSE
4234: -- Id presents

Line 4253: Fnd_Msg_Pub.ADD;

4249: OPEN get_plan_id_cur(l_search_visits_Rec.plan_id);
4250: FETCH get_plan_id_cur INTO l_simulation_plan_id,l_plan_flag;
4251: IF get_plan_id_cur%NOTFOUND THEN
4252: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_PLAN');
4253: Fnd_Msg_Pub.ADD;
4254: CLOSE get_plan_id_cur;
4255: RAISE Fnd_Api.G_EXC_ERROR;
4256: END IF;
4257: CLOSE get_plan_id_cur;

Line 4512: l_msg_count := Fnd_Msg_Pub.count_msg;

4508: END IF;
4509:
4510: ---------------------------End of Body---------------------------------------
4511: --Standard check to count messages
4512: l_msg_count := Fnd_Msg_Pub.count_msg;
4513:
4514: IF l_msg_count > 0 THEN
4515: X_msg_count := l_msg_count;
4516: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 4535: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4531: EXCEPTION
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: ROLLBACK TO Search_Scheduled_Visits;
4534: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4535: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4536: p_count => x_msg_count,
4537: p_data => x_msg_data);
4538:
4539: IF G_DEBUG='Y' THEN

Line 4549: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4545: END IF;
4546: WHEN FND_API.G_EXC_ERROR THEN
4547: ROLLBACK TO Search_Scheduled_Visits;
4548: X_return_status := FND_API.G_RET_STS_ERROR;
4549: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4550: p_count => x_msg_count,
4551: p_data => X_msg_data);
4552: IF G_DEBUG='Y' THEN
4553:

Line 4564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4560: END IF;
4561: WHEN OTHERS THEN
4562: ROLLBACK TO Search_Scheduled_Visits;
4563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4565: THEN
4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4567: p_procedure_name => 'SEARCH_SCHEDULED_VISITS',
4568: p_error_text => SUBSTR(SQLERRM,1,240));

Line 4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4562: ROLLBACK TO Search_Scheduled_Visits;
4563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4565: THEN
4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4567: p_procedure_name => 'SEARCH_SCHEDULED_VISITS',
4568: p_error_text => SUBSTR(SQLERRM,1,240));
4569: END IF;
4570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4566: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4567: p_procedure_name => 'SEARCH_SCHEDULED_VISITS',
4568: p_error_text => SUBSTR(SQLERRM,1,240));
4569: END IF;
4570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4571: p_count => x_msg_count,
4572: p_data => X_msg_data);
4573: IF G_DEBUG='Y' THEN
4574:

Line 4636: FND_MSG_PUB.initialize;

4632: END IF;
4633: -- Standard call to check for call compatibility.
4634: IF FND_API.to_boolean(l_init_msg_list)
4635: THEN
4636: FND_MSG_PUB.initialize;
4637: END IF;
4638: -- Initialize API return status to success
4639: x_return_status := FND_API.G_RET_STS_SUCCESS;
4640: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4715: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4711: EXCEPTION
4712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4713: ROLLBACK TO get_visit_duration;
4714: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4715: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4716: p_count => x_msg_count,
4717: p_data => x_msg_data);
4718: IF G_DEBUG='Y' THEN
4719:

Line 4730: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4726:
4727: WHEN FND_API.G_EXC_ERROR THEN
4728: ROLLBACK TO get_visit_duration;
4729: X_return_status := FND_API.G_RET_STS_ERROR;
4730: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4731: p_count => x_msg_count,
4732: p_data => X_msg_data);
4733: IF G_DEBUG='Y' THEN
4734:

Line 4746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4742:
4743: WHEN OTHERS THEN
4744: ROLLBACK TO get_visit_duration;
4745: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4747: THEN
4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4749: p_procedure_name => 'GET_VISIT_DURATION',
4750: p_error_text => SUBSTR(SQLERRM,1,240));

Line 4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4744: ROLLBACK TO get_visit_duration;
4745: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4747: THEN
4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4749: p_procedure_name => 'GET_VISIT_DURATION',
4750: p_error_text => SUBSTR(SQLERRM,1,240));
4751: END IF;
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4749: p_procedure_name => 'GET_VISIT_DURATION',
4750: p_error_text => SUBSTR(SQLERRM,1,240));
4751: END IF;
4752: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4753: p_count => x_msg_count,
4754: p_data => X_msg_data);
4755: IF G_DEBUG='Y' THEN
4756:

Line 4811: FND_MSG_PUB.initialize;

4807: END IF;
4808: -- Standard call to check for call compatibility.
4809: IF FND_API.to_boolean(l_init_msg_list)
4810: THEN
4811: FND_MSG_PUB.initialize;
4812: END IF;
4813: -- Initialize API return status to success
4814: x_return_status := FND_API.G_RET_STS_SUCCESS;
4815: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4865: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4861: EXCEPTION
4862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4863: ROLLBACK TO get_visit_end_date;
4864: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4865: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4866: p_count => x_msg_count,
4867: p_data => x_msg_data);
4868: IF G_DEBUG='Y' THEN
4869:

Line 4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4876:
4877: WHEN FND_API.G_EXC_ERROR THEN
4878: ROLLBACK TO get_visit_end_date;
4879: X_return_status := FND_API.G_RET_STS_ERROR;
4880: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4881: p_count => x_msg_count,
4882: p_data => X_msg_data);
4883: IF G_DEBUG='Y' THEN
4884: -- Debug info.

Line 4895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4891:
4892: WHEN OTHERS THEN
4893: ROLLBACK TO get_visit_end_date;
4894: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4896: THEN
4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4898: p_procedure_name => 'GET_VISIT_END_DATE',
4899: p_error_text => SUBSTR(SQLERRM,1,240));

Line 4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

4893: ROLLBACK TO get_visit_end_date;
4894: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4896: THEN
4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4898: p_procedure_name => 'GET_VISIT_END_DATE',
4899: p_error_text => SUBSTR(SQLERRM,1,240));
4900: END IF;
4901: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4901: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
4898: p_procedure_name => 'GET_VISIT_END_DATE',
4899: p_error_text => SUBSTR(SQLERRM,1,240));
4900: END IF;
4901: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4902: p_count => x_msg_count,
4903: p_data => X_msg_data);
4904: IF G_DEBUG='Y' THEN
4905:

Line 4968: FND_MSG_PUB.initialize;

4964: END IF;
4965: -- Standard call to check for call compatibility.
4966: IF FND_API.to_boolean(l_init_msg_list)
4967: THEN
4968: FND_MSG_PUB.initialize;
4969: END IF;
4970: -- Initialize API return status to success
4971: x_return_status := FND_API.G_RET_STS_SUCCESS;
4972: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5008: l_msg_count := Fnd_Msg_Pub.count_msg;

5004: AHL_DEBUG_PUB.debug( 'inside visit due by date :'||x_due_by_date);
5005: END IF;
5006:
5007: --Standard check to count messages
5008: l_msg_count := Fnd_Msg_Pub.count_msg;
5009:
5010: IF l_msg_count > 0 THEN
5011: X_msg_count := l_msg_count;
5012: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 5025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5021: EXCEPTION
5022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5023: ROLLBACK TO get_visit_due_by_date;
5024: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5026: p_count => x_msg_count,
5027: p_data => x_msg_data);
5028: IF G_DEBUG='Y' THEN
5029: AHL_DEBUG_PUB.log_app_messages (

Line 5038: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5034: END IF;
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: ROLLBACK TO get_visit_due_by_date;
5037: X_return_status := FND_API.G_RET_STS_ERROR;
5038: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5039: p_count => x_msg_count,
5040: p_data => X_msg_data);
5041: IF G_DEBUG='Y' THEN
5042:

Line 5053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5049: END IF;
5050: WHEN OTHERS THEN
5051: ROLLBACK TO get_visit_due_by_date;
5052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5054: THEN
5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5056: p_procedure_name => 'GET_VISIT_DUE_BY_DATE',
5057: p_error_text => SUBSTR(SQLERRM,1,240));

Line 5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

5051: ROLLBACK TO get_visit_due_by_date;
5052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5054: THEN
5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5056: p_procedure_name => 'GET_VISIT_DUE_BY_DATE',
5057: p_error_text => SUBSTR(SQLERRM,1,240));
5058: END IF;
5059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5056: p_procedure_name => 'GET_VISIT_DUE_BY_DATE',
5057: p_error_text => SUBSTR(SQLERRM,1,240));
5058: END IF;
5059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5060: p_count => x_msg_count,
5061: p_data => X_msg_data);
5062: IF G_DEBUG='Y' THEN
5063:

Line 5107: FND_MSG_PUB.initialize;

5103: END IF;
5104: -- Standard call to check for call compatibility.
5105: IF FND_API.to_boolean(l_init_msg_list)
5106: THEN
5107: FND_MSG_PUB.initialize;
5108: END IF;
5109: -- Initialize API return status to success
5110: x_return_status := FND_API.G_RET_STS_SUCCESS;
5111: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5134: l_msg_count := FND_MSG_PUB.count_msg;

5130: x_msg_count => l_msg_count,
5131: x_msg_data => l_msg_data);
5132:
5133: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5134: l_msg_count := FND_MSG_PUB.count_msg;
5135: IF l_msg_count > 0 THEN
5136: RAISE FND_API.G_EXC_ERROR;
5137: END IF;
5138: END IF;

Line 5158: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5154: EXCEPTION
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK TO Derive_visit_end_date;
5157: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count,
5160: p_data => x_msg_data);
5161: IF G_DEBUG='Y' THEN
5162:

Line 5173: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5169:
5170: WHEN FND_API.G_EXC_ERROR THEN
5171: ROLLBACK TO Derive_visit_end_date;
5172: X_return_status := FND_API.G_RET_STS_ERROR;
5173: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5174: p_count => x_msg_count,
5175: p_data => X_msg_data);
5176: IF G_DEBUG='Y' THEN
5177:

Line 5189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5185:
5186: WHEN OTHERS THEN
5187: ROLLBACK TO Derive_visit_end_date;
5188: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: THEN
5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5192: p_procedure_name => 'DERIEVE_VISIT_END_DATE',
5193: p_error_text => SUBSTR(SQLERRM,1,240));

Line 5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

5187: ROLLBACK TO Derive_visit_end_date;
5188: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5190: THEN
5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5192: p_procedure_name => 'DERIEVE_VISIT_END_DATE',
5193: p_error_text => SUBSTR(SQLERRM,1,240));
5194: END IF;
5195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5191: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
5192: p_procedure_name => 'DERIEVE_VISIT_END_DATE',
5193: p_error_text => SUBSTR(SQLERRM,1,240));
5194: END IF;
5195: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5196: p_count => x_msg_count,
5197: p_data => X_msg_data);
5198: IF G_DEBUG='Y' THEN
5199:

Line 5498: FND_MSG_PUB.initialize;

5494: END IF;
5495: -- Standard call to check for call compatibility.
5496: IF FND_API.to_boolean(p_init_msg_list)
5497: THEN
5498: FND_MSG_PUB.initialize;
5499: END IF;
5500: -- Initialize API return status to success
5501: x_return_status := FND_API.G_RET_STS_SUCCESS;
5502: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5531: Fnd_Msg_Pub.ADD;

5527: FETCH l_org_id_cur INTO l_search_visits_Rec.ORG_ID,l_search_visits_Rec.ORG_NAME;
5528: IF l_org_id_cur%NOTFOUND THEN
5529: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_ORG');
5530: Fnd_Message.Set_Token('ORG',NVL(l_search_visits_Rec.ORG_NAME,l_search_visits_Rec.ORG_ID));
5531: Fnd_Msg_Pub.ADD;
5532: CLOSE l_org_id_cur;
5533: RAISE Fnd_Api.G_EXC_ERROR;
5534: --
5535: END IF;

Line 5561: Fnd_Msg_Pub.ADD;

5557: l_search_visits_Rec.department_name;
5558: IF l_dept_id_cur%NOTFOUND THEN
5559: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_DEPT');
5560: Fnd_Message.Set_Token('DEPT',NVL(l_search_visits_Rec.DEPARTMENT_NAME,l_search_visits_Rec.DEPARTMENT_ID));
5561: Fnd_Msg_Pub.ADD;
5562: CLOSE l_dept_id_cur;
5563: RAISE Fnd_Api.G_EXC_ERROR;
5564: --
5565: END IF;

Line 5585: Fnd_Msg_Pub.ADD;

5581:
5582: IF NVL(l_return_status, 'X') <> 'S'
5583: THEN
5584: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');
5585: Fnd_Msg_Pub.ADD;
5586: RAISE Fnd_Api.G_EXC_ERROR;
5587: END IF;
5588: ELSE
5589: -- Id presents

Line 5612: Fnd_Msg_Pub.ADD;

5608:
5609: IF NVL(l_return_status, 'X') <> 'S'
5610: THEN
5611: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_INVALID');
5612: Fnd_Msg_Pub.ADD;
5613: RAISE Fnd_Api.G_EXC_ERROR;
5614: END IF;
5615: ELSE
5616: -- Id presents

Line 5639: Fnd_Msg_Pub.ADD;

5635:
5636: IF NVL(l_return_status, 'X') <> 'S'
5637: THEN
5638: Fnd_Message.SET_NAME('AHL','AHL_LTP_DISPLAY_INVALID');
5639: Fnd_Msg_Pub.ADD;
5640: RAISE Fnd_Api.G_EXC_ERROR;
5641: END IF;
5642: ELSE
5643: -- Id presents

Line 5664: Fnd_Msg_Pub.ADD;

5660: FETCH l_space_id_cur INTO l_search_visits_Rec.SPACE_ID,l_search_visits_Rec.SPACE_NAME;
5661: IF l_space_id_cur%NOTFOUND THEN
5662: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_SPACE');
5663: Fnd_Message.Set_Token('SPACE',NVL(l_search_visits_Rec.SPACE_NAME,l_search_visits_Rec.SPACE_ID));
5664: Fnd_Msg_Pub.ADD;
5665: CLOSE l_space_id_cur;
5666: RAISE Fnd_Api.G_EXC_ERROR;
5667: --
5668: END IF;

Line 5681: Fnd_Msg_Pub.ADD;

5677: FETCH l_item_name_cur INTO l_search_visits_rec.item_id,l_search_visits_rec.item_description;
5678: IF l_item_name_cur%NOTFOUND THEN
5679: Fnd_Message.set_name('AHL', 'AHL_LTP_ITEM_NOT_EXIST');
5680: Fnd_Message.Set_Token('ITEM',NVL(l_search_visits_Rec.ITEM_DESCRIPTION,l_search_visits_Rec.ITEM_ID));
5681: Fnd_Msg_Pub.ADD;
5682: CLOSE l_item_name_cur;
5683: RAISE Fnd_Api.G_EXC_ERROR;
5684: END IF;
5685: CLOSE l_item_name_cur;

Line 5695: Fnd_Msg_Pub.ADD;

5691: FETCH l_item_id_cur INTO l_search_visits_rec.item_id,l_search_visits_rec.item_description;
5692: IF l_item_id_cur%NOTFOUND THEN
5693: Fnd_Message.set_name('AHL', 'AHL_LTP_ITEM_NOT_EXIST');
5694: Fnd_Message.Set_Token('ITEM',NVL(l_search_visits_Rec.ITEM_DESCRIPTION,l_search_visits_Rec.ITEM_ID));
5695: Fnd_Msg_Pub.ADD;
5696: CLOSE l_item_id_cur;
5697: RAISE Fnd_Api.G_EXC_ERROR;
5698: END IF;
5699: CLOSE l_item_id_cur;

Line 5708: Fnd_Msg_Pub.ADD;

5704: OPEN get_plan_id_cur(l_search_visits_Rec.plan_id);
5705: FETCH get_plan_id_cur INTO l_search_visits_Rec.plan_id,l_plan_flag;
5706: IF get_plan_id_cur%NOTFOUND THEN
5707: Fnd_Message.set_name('AHL', 'AHL_LTP_INVALID_PLAN');
5708: Fnd_Msg_Pub.ADD;
5709: CLOSE get_plan_id_cur;
5710: RAISE Fnd_Api.G_EXC_ERROR;
5711: END IF;
5712: CLOSE get_plan_id_cur;

Line 6060: l_msg_count := Fnd_Msg_Pub.count_msg;

6056: AHL_DEBUG_PUB.debug( 'total records:'||x_visit_details_tbl.count);
6057: END IF;
6058:
6059: --Standard check to count messages
6060: l_msg_count := Fnd_Msg_Pub.count_msg;
6061:
6062: IF l_msg_count > 0 THEN
6063: X_msg_count := l_msg_count;
6064: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 6079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6075: EXCEPTION
6076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6077: ROLLBACK TO Get_visit_details;
6078: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6080: p_count => x_msg_count,
6081: p_data => x_msg_data);
6082: IF G_DEBUG='Y' THEN
6083:

Line 6094: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6090:
6091: WHEN FND_API.G_EXC_ERROR THEN
6092: ROLLBACK TO Get_visit_details;
6093: X_return_status := FND_API.G_RET_STS_ERROR;
6094: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6095: p_count => x_msg_count,
6096: p_data => X_msg_data);
6097: IF G_DEBUG='Y' THEN
6098:

Line 6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6105: END IF;
6106: WHEN OTHERS THEN
6107: ROLLBACK TO Get_visit_details;
6108: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6110: THEN
6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
6112: p_procedure_name => 'GET_VISIT_DETAILS',
6113: p_error_text => SUBSTR(SQLERRM,1,240));

Line 6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',

6107: ROLLBACK TO Get_visit_details;
6108: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6109: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6110: THEN
6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
6112: p_procedure_name => 'GET_VISIT_DETAILS',
6113: p_error_text => SUBSTR(SQLERRM,1,240));
6114: END IF;
6115: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6115: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_SCHEDULE_PVT',
6112: p_procedure_name => 'GET_VISIT_DETAILS',
6113: p_error_text => SUBSTR(SQLERRM,1,240));
6114: END IF;
6115: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6116: p_count => x_msg_count,
6117: p_data => X_msg_data);
6118: IF G_DEBUG='Y' THEN
6119: