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

Line 184: FND_MSG_PUB.Initialize;

180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: END IF;
182:
183: -- Initialize message list by default
184: FND_MSG_PUB.Initialize;
185:
186: -- Initialize API return status to success
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:

Line 211: FND_MSG_PUB.ADD;

207: -- 5. If (p_unit_schedules_search is NULL or p_unit_schedules_search.start_date_time is null), then display error "Start date and time are mandatory parameters to perform a search on Unit Schedules"
208: IF (p_unit_schedules_search.start_date_time IS NULL OR p_unit_schedules_search.start_date_time = FND_API.G_MISS_DATE)
209: THEN
210: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UA_SUS_START_DATE_NULL');
211: FND_MSG_PUB.ADD;
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214:
215: -- 6. If (p_unit_schedules_search is NULL or p_unit_schedules_search.time_increment is null or p_unit_schedules_search.time_uom is null), then display error "Display increment is mandatory parameter to perform a search on Unit Schedules"

Line 222: FND_MSG_PUB.ADD;

218: p_unit_schedules_search.time_uom IS NULL OR p_unit_schedules_search.time_uom = FND_API.G_MISS_CHAR
219: )
220: THEN
221: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UA_SUS_TIME_UOM_NULL');
222: FND_MSG_PUB.ADD;
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: -- 7. If (p_unit_schedules_search.time_increment is not a positive integer), then display error "Display increment should be a positive integer"

Line 230: FND_MSG_PUB.ADD;

226: -- 7. If (p_unit_schedules_search.time_increment is not a positive integer), then display error "Display increment should be a positive integer"
227: IF (p_unit_schedules_search.time_increment <= 0 OR p_unit_schedules_search.time_increment <> TRUNC(p_unit_schedules_search.time_increment))
228: THEN
229: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UA_SUS_TIME_INTEGER');
230: FND_MSG_PUB.ADD;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: -- 8. Validate p_unit_schedules_search.time_uom using cursor check_time_uom_exists. If cursor does not return 1 record (and only 1), the display error "Invalid UOM for display increment"

Line 239: FND_MSG_PUB.ADD;

235: IF NOT (AHL_UTIL_MC_PKG.Validate_Lookup_Code('AHL_UA_TIME_UOM', p_unit_schedules_search.time_uom))
236: THEN
237: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UA_SUS_TIME_UOM_INVALID');
238: FND_MESSAGE.SET_TOKEN('UOM', p_unit_schedules_search.time_uom);
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:
243: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 350: x_msg_count := FND_MSG_PUB.count_msg;

346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: -- Check Error Message stack.
350: x_msg_count := FND_MSG_PUB.count_msg;
351: IF x_msg_count > 0
352: THEN
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;

Line 690: x_msg_count := FND_MSG_PUB.count_msg;

686: );
687: END IF;
688:
689: -- Check Error Message stack.
690: x_msg_count := FND_MSG_PUB.count_msg;
691: IF x_msg_count > 0
692: THEN
693: RAISE FND_API.G_EXC_ERROR;
694: END IF;

Line 700: FND_MSG_PUB.count_and_get

696: -- Commit by default
697: COMMIT WORK;
698:
699: -- Standard call to get message count and if count is 1, get message info
700: FND_MSG_PUB.count_and_get
701: (
702: p_count => x_msg_count,
703: p_data => x_msg_data,
704: p_encoded => FND_API.G_FALSE

Line 711: FND_MSG_PUB.count_and_get

707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: Rollback to Search_Unit_Schedules_SP;
711: FND_MSG_PUB.count_and_get
712: (
713: p_count => x_msg_count,
714: p_data => x_msg_data,
715: p_encoded => FND_API.G_FALSE

Line 721: FND_MSG_PUB.count_and_get

717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: Rollback to Search_Unit_Schedules_SP;
721: FND_MSG_PUB.count_and_get
722: (
723: p_count => x_msg_count,
724: p_data => x_msg_data,
725: p_encoded => FND_API.G_FALSE

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

727:
728: WHEN OTHERS THEN
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: Rollback to Search_Unit_Schedules_SP;
731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
732: THEN
733: FND_MSG_PUB.add_exc_msg
734: (
735: p_pkg_name => G_PKG_NAME,

Line 733: FND_MSG_PUB.add_exc_msg

729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: Rollback to Search_Unit_Schedules_SP;
731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
732: THEN
733: FND_MSG_PUB.add_exc_msg
734: (
735: p_pkg_name => G_PKG_NAME,
736: p_procedure_name => 'Search_Unit_Schedules',
737: p_error_text => SUBSTR(SQLERRM,1,240)

Line 740: FND_MSG_PUB.count_and_get

736: p_procedure_name => 'Search_Unit_Schedules',
737: p_error_text => SUBSTR(SQLERRM,1,240)
738: );
739: END IF;
740: FND_MSG_PUB.count_and_get
741: (
742: p_count => x_msg_count,
743: p_data => x_msg_data,
744: p_encoded => FND_API.G_FALSE

Line 864: FND_MSG_PUB.Initialize;

860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
861: END IF;
862:
863: -- Initialize message list by default
864: FND_MSG_PUB.Initialize;
865:
866: -- Initialize API return status to success
867: x_return_status := FND_API.G_RET_STS_SUCCESS;
868:

Line 1360: x_msg_count := FND_MSG_PUB.count_msg;

1356: );
1357: END IF;
1358:
1359: -- Check Error Message stack.
1360: x_msg_count := FND_MSG_PUB.count_msg;
1361: IF x_msg_count > 0
1362: THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;

Line 1367: FND_MSG_PUB.count_and_get

1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:
1366: -- Standard call to get message count and if count is 1, get message info
1367: FND_MSG_PUB.count_and_get
1368: (
1369: p_count => x_msg_count,
1370: p_data => x_msg_data,
1371: p_encoded => FND_API.G_FALSE

Line 1377: FND_MSG_PUB.count_and_get

1373:
1374: EXCEPTION
1375: WHEN FND_API.G_EXC_ERROR THEN
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: FND_MSG_PUB.count_and_get
1378: (
1379: p_count => x_msg_count,
1380: p_data => x_msg_data,
1381: p_encoded => FND_API.G_FALSE

Line 1386: FND_MSG_PUB.count_and_get

1382: );
1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: FND_MSG_PUB.count_and_get
1387: (
1388: p_count => x_msg_count,
1389: p_data => x_msg_data,
1390: p_encoded => FND_API.G_FALSE

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

1391: );
1392:
1393: WHEN OTHERS THEN
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: FND_MSG_PUB.add_exc_msg
1398: (
1399: p_pkg_name => G_PKG_NAME,

Line 1397: FND_MSG_PUB.add_exc_msg

1393: WHEN OTHERS THEN
1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: FND_MSG_PUB.add_exc_msg
1398: (
1399: p_pkg_name => G_PKG_NAME,
1400: p_procedure_name => 'Get_MEvent_Details',
1401: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1404: FND_MSG_PUB.count_and_get

1400: p_procedure_name => 'Get_MEvent_Details',
1401: p_error_text => SUBSTR(SQLERRM,1,240)
1402: );
1403: END IF;
1404: FND_MSG_PUB.count_and_get
1405: (
1406: p_count => x_msg_count,
1407: p_data => x_msg_data,
1408: p_encoded => FND_API.G_FALSE

Line 2070: FND_MSG_PUB.Initialize;

2066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2067: END IF;
2068:
2069: -- Initialize message list by default
2070: FND_MSG_PUB.Initialize;
2071:
2072: -- Initialize API return status to success
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074:

Line 2098: FND_MSG_PUB.ADD;

2094: )
2095: THEN
2096: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_COM_INVALID_PROCEDURE_CALL');
2097: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
2098: FND_MSG_PUB.ADD;
2099: RAISE FND_API.G_EXC_ERROR;
2100: END IF;
2101:
2102: -- 6. Validate unit configuration with unit_config_id = p_unit_config_id exists and is complete and active, using cursor check_unit_exists. If no record found, throw error "Unit Configuration does not exist or is not complete"

Line 2108: FND_MSG_PUB.ADD;

2104: FETCH check_unit_exists INTO l_dummy_varchar;
2105: IF (check_unit_exists%NOTFOUND)
2106: THEN
2107: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UA_UNIT_ID_NOT_FOUND');
2108: FND_MSG_PUB.ADD;
2109: CLOSE check_unit_exists;
2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;
2112: CLOSE check_unit_exists;

Line 2191: x_msg_count := FND_MSG_PUB.count_msg;

2187: );
2188: END IF;
2189:
2190: -- Check Error Message stack.
2191: x_msg_count := FND_MSG_PUB.count_msg;
2192: IF x_msg_count > 0
2193: THEN
2194: RAISE FND_API.G_EXC_ERROR;
2195: END IF;

Line 2198: FND_MSG_PUB.count_and_get

2194: RAISE FND_API.G_EXC_ERROR;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info
2198: FND_MSG_PUB.count_and_get
2199: (
2200: p_count => x_msg_count,
2201: p_data => x_msg_data,
2202: p_encoded => FND_API.G_FALSE

Line 2208: FND_MSG_PUB.count_and_get

2204:
2205: EXCEPTION
2206: WHEN FND_API.G_EXC_ERROR THEN
2207: x_return_status := FND_API.G_RET_STS_ERROR;
2208: FND_MSG_PUB.count_and_get
2209: (
2210: p_count => x_msg_count,
2211: p_data => x_msg_data,
2212: p_encoded => FND_API.G_FALSE

Line 2217: FND_MSG_PUB.count_and_get

2213: );
2214:
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217: FND_MSG_PUB.count_and_get
2218: (
2219: p_count => x_msg_count,
2220: p_data => x_msg_data,
2221: p_encoded => FND_API.G_FALSE

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

2222: );
2223:
2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2227: THEN
2228: FND_MSG_PUB.add_exc_msg
2229: (
2230: p_pkg_name => G_PKG_NAME,

Line 2228: FND_MSG_PUB.add_exc_msg

2224: WHEN OTHERS THEN
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2227: THEN
2228: FND_MSG_PUB.add_exc_msg
2229: (
2230: p_pkg_name => G_PKG_NAME,
2231: p_procedure_name => 'Get_Prec_Succ_Event_Info',
2232: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2235: FND_MSG_PUB.count_and_get

2231: p_procedure_name => 'Get_Prec_Succ_Event_Info',
2232: p_error_text => SUBSTR(SQLERRM,1,240)
2233: );
2234: END IF;
2235: FND_MSG_PUB.count_and_get
2236: (
2237: p_count => x_msg_count,
2238: p_data => x_msg_data,
2239: p_encoded => FND_API.G_FALSE