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

Line 689: FND_MSG_PUB.Initialize;

685: SAVEPOINT Process_Unit_PVT;
686:
687: -- Initialize message list if p_init_msg_list is set to TRUE
688: IF FND_API.To_Boolean(p_init_msg_list) THEN
689: FND_MSG_PUB.Initialize;
690: END IF;
691:
692: -- Initialize Procedure return status to success
693: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 737: IF FND_MSG_PUB.Count_msg > 0 THEN

733: -- validate item instance.
734: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,
735: l_inv_master_organization_id);
736:
737: IF FND_MSG_PUB.Count_msg > 0 THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740:
741: -- Log success message if called by concurrent program.

Line 762: IF FND_MSG_PUB.Count_msg > 0 THEN

758: -- validate item instance.
759: Validate_item_instance(l_csi_item_instance_id, l_inventory_item_id,
760: l_inv_master_organization_id, l_expired_flag);
761:
762: IF FND_MSG_PUB.Count_msg > 0 THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: -- Log success message if called by concurrent program.

Line 779: IF FND_MSG_PUB.Count_msg > 0 THEN

775: -- JKJain, NR Analysis and Forecasting
776: G_UC_HEADER_ID := l_uc_header_id;
777:
778: -- Check for errors.
779: IF FND_MSG_PUB.Count_msg > 0 THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782:
783: -- Build the Configuration tree structure.(G_config_node_tbl).

Line 793: IF FND_MSG_PUB.Count_msg > 0 THEN

789: -- validate item instance.
790: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,
791: l_inv_master_organization_id, l_expired_flag);
792:
793: IF FND_MSG_PUB.Count_msg > 0 THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797: -- Log success message if called by concurrent program.

Line 889: FND_MSG_PUB.ADD;

885: END LOOP;
886:
887: IF (l_ret_code = -54) THEN
888: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892:
893: /*

Line 923: IF FND_MSG_PUB.Count_msg > 0 THEN

919: AHL_UMP_PROCESSUNIT_EXTN_PVT.Flush_To_Sim_Ue_Table(G_config_node_tbl,p_simulation_plan_id,G_UC_HEADER_ID);
920: END IF;
921:
922: -- Check for errors.
923: IF FND_MSG_PUB.Count_msg > 0 THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: /* -- commented for performance fix - bug# 6893404

Line 963: FND_MSG_PUB.Count_And_Get

959: fnd_file.put_line (FND_FILE.LOG, 'Message-Successfully processed:'||p_csi_item_instance_id);
960: END IF;
961:
962: -- Standard call to get message count and if count is 1, get message info
963: FND_MSG_PUB.Count_And_Get
964: ( p_count => x_msg_count,
965: p_data => x_msg_data,
966: p_encoded => fnd_api.g_false
967: );

Line 974: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: Rollback to Process_Unit_PVT;
974: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
975: p_data => x_msg_data,
976: p_encoded => fnd_api.g_false);
977:
978: IF (p_concurrent_flag = 'Y') THEN

Line 990: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

986:
987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: Rollback to Process_Unit_PVT;
990: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
991: p_data => x_msg_data,
992: p_encoded => fnd_api.g_false);
993:
994: IF (p_concurrent_flag = 'Y') THEN

Line 1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1002: WHEN OTHERS THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: Rollback to Process_Unit_PVT;
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1007: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1008: p_procedure_name => 'Process_Unit_PVT',
1009: p_error_text => SUBSTR(SQLERRM,1,240));
1010: END IF;

Line 1007: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: Rollback to Process_Unit_PVT;
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1007: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1008: p_procedure_name => 'Process_Unit_PVT',
1009: p_error_text => SUBSTR(SQLERRM,1,240));
1010: END IF;
1011: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1011: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1007: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1008: p_procedure_name => 'Process_Unit_PVT',
1009: p_error_text => SUBSTR(SQLERRM,1,240));
1010: END IF;
1011: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1012: p_data => x_msg_data,
1013: p_encoded => fnd_api.g_false);
1014:
1015:

Line 1297: FND_MSG_PUB.Initialize;

1293: SAVEPOINT Process_PM_Contracts_PVT;
1294:
1295: -- Initialize message list if p_init_msg_list is set to TRUE
1296: IF FND_API.To_Boolean(p_init_msg_list) THEN
1297: FND_MSG_PUB.Initialize;
1298: END IF;
1299:
1300: -- Initialize Procedure return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1363: l_msg_count := FND_MSG_PUB.count_msg;

1359: x_ent_contracts => l_ent_cont_tbl
1360: );
1361:
1362: -- Check Error Message stack.
1363: l_msg_count := FND_MSG_PUB.count_msg;
1364: IF (l_msg_count > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1366: END IF;
1367:

Line 1386: IF (p_concurrent_flag = 'Y' and (FND_MSG_PUB.count_msg > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

1382: x_return_status => x_return_status,
1383: p_csi_item_instance_id => l_ent_cont_tbl(i).coverage_level_id,
1384: p_concurrent_flag => p_concurrent_flag
1385: );
1386: IF (p_concurrent_flag = 'Y' and (FND_MSG_PUB.count_msg > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1387: fnd_file.put_line(fnd_file.log, 'Process_Unit failed for instance: ' || l_ent_cont_tbl(i).coverage_level_id);
1388: END IF;
1389: END IF;
1390: END LOOP;

Line 1394: l_msg_count := FND_MSG_PUB.count_msg;

1390: END LOOP;
1391: END IF;
1392:
1393: -- Check Error Message stack.
1394: l_msg_count := FND_MSG_PUB.count_msg;
1395: IF (l_msg_count > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398:

Line 1410: FND_MSG_PUB.Count_And_Get

1406: fnd_file.put_line(fnd_file.log, 'Message-Successfully processed: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1407: END IF;
1408:
1409: -- Standard call to get message count and if count is 1, get message info
1410: FND_MSG_PUB.Count_And_Get
1411: (
1412: p_count => x_msg_count,
1413: p_data => x_msg_data,
1414: p_encoded => fnd_api.g_false

Line 1421: FND_MSG_PUB.count_and_get

1417: EXCEPTION
1418: WHEN FND_API.G_EXC_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: Rollback to Process_PM_Contracts_PVT;
1421: FND_MSG_PUB.count_and_get
1422: (
1423: p_count => x_msg_count,
1424: p_data => x_msg_data,
1425: p_encoded => fnd_api.g_false

Line 1436: FND_MSG_PUB.count_and_get

1432:
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: Rollback to Process_PM_Contracts_PVT;
1436: FND_MSG_PUB.count_and_get
1437: (
1438: p_count => x_msg_count,
1439: p_data => x_msg_data,
1440: p_encoded => fnd_api.g_false

Line 1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1447:
1448: WHEN OTHERS THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: Rollback to Process_PM_Contracts_PVT;
1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: fnd_msg_pub.add_exc_msg
1453: (
1454: p_pkg_name => G_PKG_NAME,
1455: p_procedure_name => 'Process_PM_Contracts',

Line 1452: fnd_msg_pub.add_exc_msg

1448: WHEN OTHERS THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450: Rollback to Process_PM_Contracts_PVT;
1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: fnd_msg_pub.add_exc_msg
1453: (
1454: p_pkg_name => G_PKG_NAME,
1455: p_procedure_name => 'Process_PM_Contracts',
1456: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1459: FND_MSG_PUB.count_and_get

1455: p_procedure_name => 'Process_PM_Contracts',
1456: p_error_text => SUBSTR(SQLERRM,1,240)
1457: );
1458: END IF;
1459: FND_MSG_PUB.count_and_get
1460: (
1461: p_count => x_msg_count,
1462: p_data => x_msg_data,
1463: p_encoded => fnd_api.g_false

Line 1624: FND_MSG_PUB.ADD;

1620: l_inventory_item_id, l_inv_master_organization_id;
1621: IF (csi_item_instances_csr%NOTFOUND) THEN
1622: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1623: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1624: FND_MSG_PUB.ADD;
1625: CLOSE csi_item_instances_csr;
1626: --dbms_output.put_line('Instance not found');
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_active_end_date <= sysdate THEN

Line 1633: FND_MSG_PUB.ADD;

1629: /* Bypass error to fix bug# 8567880. For expired
1630: instances we will delete open UMPs.
1631: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
1632: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
1633: FND_MSG_PUB.ADD;
1634: --dbms_output.put_line('Instance has expired');
1635: */
1636: l_expired_flag := 'Y';
1637: END IF;

Line 1698: FND_MSG_PUB.ADD;

1694: --modified for quaratine statuses.
1695: IF (l_config_status_code = 'DRAFT') THEN
1696: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
1697: FND_MESSAGE.Set_Token('NAME',l_name);
1698: FND_MSG_PUB.ADD;
1699: --dbms_output.put_line('UC is in draft status');
1700: ELSE
1701: x_uc_header_id := l_unit_config_header_id;
1702: x_master_config_id := l_master_config_id;

Line 2637: --FND_MSG_PUB.ADD;

2633:
2634: WHEN OTHERS THEN
2635: IF (SQLCODE = -54) THEN
2636: --FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
2637: --FND_MSG_PUB.ADD;
2638: --RAISE FND_API.G_EXC_ERROR;
2639: x_ret_code := '-54';
2640: ELSE
2641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2637: --FND_MSG_PUB.ADD;
2638: --RAISE FND_API.G_EXC_ERROR;
2639: x_ret_code := '-54';
2640: ELSE
2641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2642: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2643: p_procedure_name => 'Lock_UnitEffectivity_Records',
2644: p_error_text => SUBSTR(SQLERRM,1,240));
2645: END IF;

Line 2642: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

2638: --RAISE FND_API.G_EXC_ERROR;
2639: x_ret_code := '-54';
2640: ELSE
2641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2642: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2643: p_procedure_name => 'Lock_UnitEffectivity_Records',
2644: p_error_text => SUBSTR(SQLERRM,1,240));
2645: END IF;
2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7523: FND_MSG_PUB.ADD;

7519: IF (ahl_ue_csr%NOTFOUND) THEN
7520: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
7521: FND_MESSAGE.Set_Token('UE_ID',l_ue_relns_rec.ue_id);
7522: FND_MESSAGE.Set_Token('RELATED_UE_ID', l_ue_relns_rec.related_ue_id);
7523: FND_MSG_PUB.ADD;
7524: CLOSE ahl_ue_csr;
7525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7526: END IF;
7527: --dbms_output.put_line ('found ue relns');

Line 8137: l_msg_count := FND_MSG_PUB.Count_Msg;

8133: AHL_DEBUG_PUB.Debug('Start log error messages');
8134: END IF;
8135:
8136: -- Standard call to get message count.
8137: l_msg_count := FND_MSG_PUB.Count_Msg;
8138:
8139: FOR i IN 1..l_msg_count LOOP
8140: FND_MSG_PUB.get (
8141: p_msg_index => i,

Line 8140: FND_MSG_PUB.get (

8136: -- Standard call to get message count.
8137: l_msg_count := FND_MSG_PUB.Count_Msg;
8138:
8139: FOR i IN 1..l_msg_count LOOP
8140: FND_MSG_PUB.get (
8141: p_msg_index => i,
8142: p_encoded => FND_API.G_FALSE,
8143: p_data => l_msg_data,
8144: p_msg_index_out => l_msg_index_out );

Line 8761: FND_MSG_PUB.ADD;

8757: FETCH ahl_cont_scheduled_csr INTO l_cont_scheduled_rec;
8758: IF (ahl_cont_scheduled_csr%NOTFOUND) THEN
8759: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PMPROGRAM_NOTFOUND');
8760: FND_MESSAGE.Set_Token('PMPROGRAM',sch_activity_rec.mr_header_id);
8761: FND_MSG_PUB.ADD;
8762: CLOSE ahl_cont_scheduled_csr;
8763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8764: END IF;
8765:

Line 9675: FND_MSG_PUB.ADD;

9671:
9672: -- Validate input parameters.
9673: IF (p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM) THEN
9674: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_NULL');
9675: FND_MSG_PUB.ADD;
9676: RAISE FND_API.G_EXC_ERROR;
9677: ELSE
9678: OPEN ahl_unit_effectivity_csr (p_unit_effectivity_id);
9679: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id,

Line 9684: FND_MSG_PUB.ADD;

9680: l_inventory_item_id, l_inv_master_organization_id;
9681: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
9682: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_INVALID');
9683: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);
9684: FND_MSG_PUB.ADD;
9685: RAISE FND_API.G_EXC_ERROR;
9686: END IF;
9687: END IF;
9688:

Line 9696: FND_MSG_PUB.ADD;

9692: FETCH ahl_mr_headers_csr INTO l_whichever_first_code;
9693: IF (ahl_mr_headers_csr%NOTFOUND) THEN
9694: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_MR_INVALID');
9695: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);
9696: FND_MSG_PUB.ADD;
9697: RAISE FND_API.G_EXC_ERROR;
9698: END IF;
9699: CLOSE ahl_mr_headers_csr;
9700: ELSE

Line 9726: IF FND_MSG_PUB.Count_msg > 0 THEN

9722: AHL_DEBUG_PUB.debug('Step 2');
9723: END IF;
9724:
9725: -- Check for errors.
9726: IF FND_MSG_PUB.Count_msg > 0 THEN
9727: RAISE FND_API.G_EXC_ERROR;
9728: END IF;
9729:
9730: IF G_DEBUG = 'Y' THEN

Line 9824: FND_MSG_PUB.Count_And_Get

9820: END IF;
9821: x_due_date := l_calc_due_date;
9822:
9823: -- Standard call to get message count and if count is 1, get message info
9824: FND_MSG_PUB.Count_And_Get
9825: ( p_count => x_msg_count,
9826: p_data => x_msg_data,
9827: p_encoded => fnd_api.g_false
9828: );

Line 9834: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

9830: --
9831: EXCEPTION
9832: WHEN FND_API.G_EXC_ERROR THEN
9833: x_return_status := FND_API.G_RET_STS_ERROR;
9834: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9835: p_data => x_msg_data,
9836: p_encoded => fnd_api.g_false);
9837:
9838: -- Disable debug

Line 9843: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

9839: AHL_DEBUG_PUB.disable_debug;
9840:
9841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9843: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9844: p_data => x_msg_data,
9845: p_encoded => fnd_api.g_false);
9846:
9847: -- Disable debug

Line 9853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9849:
9850: WHEN OTHERS THEN
9851:
9852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9854: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9855: p_procedure_name => 'Get_Deferred_Due_Date',
9856: p_error_text => SUBSTR(SQLERRM,1,240));
9857: END IF;

Line 9854: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

9850: WHEN OTHERS THEN
9851:
9852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9854: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9855: p_procedure_name => 'Get_Deferred_Due_Date',
9856: p_error_text => SUBSTR(SQLERRM,1,240));
9857: END IF;
9858: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 9858: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

9854: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9855: p_procedure_name => 'Get_Deferred_Due_Date',
9856: p_error_text => SUBSTR(SQLERRM,1,240));
9857: END IF;
9858: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9859: p_data => x_msg_data,
9860: p_encoded => fnd_api.g_false);
9861:
9862:

Line 10221: FND_MSG_PUB.ADD;

10217: IF (ahl_unit_deferral_csr%NOTFOUND) THEN
10218: CLOSE ahl_unit_deferral_csr;
10219: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_NOTFOUND');
10220: FND_MESSAGE.Set_Token('UE_ID',unit_effectivity_rec.defer_from_ue_id);
10221: FND_MSG_PUB.ADD;
10222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10223: END IF;
10224:
10225: CLOSE ahl_unit_deferral_csr;

Line 10380: FND_MSG_PUB.ADD;

10376: IF (get_repair_category_csr%NOTFOUND) THEN
10377: --l_calc_due_date := NULL;
10378: FND_MESSAGE.Set_Name('AHL','AHL_PUE_INCIDENT_ID_MISSING');
10379: FND_MESSAGE.Set_Token('CS_INC_ID',unit_effectivity_rec.cs_incident_id);
10380: FND_MSG_PUB.ADD;
10381: RAISE FND_API.G_EXC_ERROR;
10382: ELSE
10383:
10384: IF l_repair_time <> 0 AND

Line 10916: FND_MSG_PUB.ADD;

10912: IF (ahl_ue_csr%NOTFOUND) THEN
10913: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
10914: FND_MESSAGE.Set_Token('UE_ID',ahl_ue_relns_rec.ue_id);
10915: FND_MESSAGE.Set_Token('RELATED_UE_ID', ahl_ue_relns_rec.related_ue_id);
10916: FND_MSG_PUB.ADD;
10917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10918: END IF;
10919:
10920: l_ue_details_tbl(i).level := ahl_ue_relns_rec.level;

Line 11198: FND_MSG_PUB.ADD;

11194: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
11195: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
11196: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
11197: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
11198: FND_MSG_PUB.ADD;
11199: -- dbms_output.put_line('unit effectivity not found for ue id' ||l_ue_rec.unit_effectivity_id );
11200: ClOSE ahl_unit_effectivity_csr;
11201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11202: ELSE

Line 11348: FND_MSG_PUB.ADD;

11344: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
11345: ELSE
11346: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
11347: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
11348: FND_MSG_PUB.ADD;
11349: -- dbms_output.put_line('descendent mr not found for ue id');
11350: ClOSE ahl_unit_effectivity_csr;
11351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11352: END IF;

Line 11442: FND_MSG_PUB.Initialize;

11438: END IF;
11439:
11440: -- Initialize message list if p_init_msg_list is set to TRUE
11441: IF FND_API.To_Boolean(p_init_msg_list) THEN
11442: FND_MSG_PUB.Initialize;
11443: END IF;
11444:
11445: -- Initialize Procedure return status to success
11446: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11471: FND_MSG_PUB.ADD;

11467:
11468: IF (l_expired_flag = 'Y') THEN
11469: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
11470: FND_MESSAGE.Set_Token('NUMBER', p_csi_item_instance_id);
11471: FND_MSG_PUB.ADD;
11472: --dbms_output.put_line('Instance has expired');
11473: END IF;
11474:
11475: IF FND_MSG_PUB.Count_msg > 0 THEN

Line 11475: IF FND_MSG_PUB.Count_msg > 0 THEN

11471: FND_MSG_PUB.ADD;
11472: --dbms_output.put_line('Instance has expired');
11473: END IF;
11474:
11475: IF FND_MSG_PUB.Count_msg > 0 THEN
11476: RAISE FND_API.G_EXC_ERROR;
11477: END IF;
11478:
11479: -- set instance variable.

Line 11492: IF FND_MSG_PUB.Count_msg > 0 THEN

11488: Get_Unit_Master_ConfigIDs (l_csi_item_instance_id,
11489: l_uc_header_id, G_master_config_id);
11490:
11491: -- Check for errors.
11492: IF FND_MSG_PUB.Count_msg > 0 THEN
11493: RAISE FND_API.G_EXC_ERROR;
11494: END IF;
11495:
11496: -- Build the Configuration tree structure.(G_config_node_tbl).

Line 11560: FND_MSG_PUB.Count_And_Get

11556: x_counter_values_tbl := l_due_at_counter_val_tbl;
11557: END IF;
11558:
11559: -- Standard call to get message count and if count is 1, get message info
11560: FND_MSG_PUB.Count_And_Get
11561: ( p_count => x_msg_count,
11562: p_data => x_msg_data,
11563: p_encoded => fnd_api.g_false
11564: );

Line 11574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

11570: --
11571: EXCEPTION
11572: WHEN FND_API.G_EXC_ERROR THEN
11573: x_return_status := FND_API.G_RET_STS_ERROR;
11574: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
11575: p_data => x_msg_data,
11576: p_encoded => fnd_api.g_false);
11577:
11578: -- Disable debug

Line 11583: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

11579: AHL_DEBUG_PUB.disable_debug;
11580:
11581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11583: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
11584: p_data => x_msg_data,
11585: p_encoded => fnd_api.g_false);
11586:
11587: -- Disable debug

Line 11592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

11588: AHL_DEBUG_PUB.disable_debug;
11589:
11590: WHEN OTHERS THEN
11591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11593: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
11594: p_procedure_name => 'Get_Forecasted_Counter_Values',
11595: p_error_text => SUBSTR(SQLERRM,1,240));
11596: END IF;

Line 11593: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

11589:
11590: WHEN OTHERS THEN
11591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11592: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11593: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
11594: p_procedure_name => 'Get_Forecasted_Counter_Values',
11595: p_error_text => SUBSTR(SQLERRM,1,240));
11596: END IF;
11597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 11597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

11593: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
11594: p_procedure_name => 'Get_Forecasted_Counter_Values',
11595: p_error_text => SUBSTR(SQLERRM,1,240));
11596: END IF;
11597: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
11598: p_data => x_msg_data,
11599: p_encoded => fnd_api.g_false);
11600:
11601: -- Disable debug

Line 11857: FND_MSG_PUB.ADD;

11853: FETCH check_mr_exists INTO l_mr_header_id;
11854: IF check_mr_exists%NOTFOUND THEN
11855: CLOSE check_mr_exists;
11856: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
11857: FND_MSG_PUB.ADD;
11858: RAISE FND_API.G_EXC_ERROR;
11859: END IF;
11860: CLOSE check_mr_exists;
11861:

Line 11902: FND_MSG_PUB.ADD;

11898: FETCH get_master_org_id_csr INTO l_master_org_id;
11899: IF (get_master_org_id_csr%NOTFOUND) THEN
11900: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_MASORG_NOTFOUND');
11901: FND_MESSAGE.Set_Token('INV_ID',l_mr_effect.inventory_item_id);
11902: FND_MSG_PUB.ADD;
11903: --DBMS_OUTPUT.put_line('Master org not found for inventory item:' || l_mr_effect.inventory_item_id);
11904: ClOSE get_master_org_id_csr;
11905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11906: END IF;

Line 12365: l_msg_count := FND_MSG_PUB.Count_Msg;

12361: p_csi_item_instance_id => l_csi_inst_tbl(i),
12362: --inst_rec.instance_id,
12363: p_concurrent_flag => 'Y');
12364:
12365: l_msg_count := FND_MSG_PUB.Count_Msg;
12366: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
12367: THEN
12368: retcode := 2; -- error based only on return status
12369: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

Line 12650: l_msg_count := FND_MSG_PUB.Count_Msg;

12646: p_simulation_plan_id => l_simulation_plan_id);
12647:
12648: fnd_file.put_line(FND_FILE.LOG,'End time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
12649:
12650: l_msg_count := FND_MSG_PUB.Count_Msg;
12651: IF (retcode <> 2 AND l_return_status <> FND_API.G_RET_STS_SUCCESS)
12652: THEN
12653: retcode := 2; -- error based only on return status
12654: ELSIF (retcode = 0 AND l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

Line 12741: l_msg_count := FND_MSG_PUB.Count_Msg;

12737: p_mr_header_id => p_new_mr_header_id,
12738: p_concurrent_flag => 'Y',
12739: p_num_of_workers => 5);
12740:
12741: l_msg_count := FND_MSG_PUB.Count_Msg;
12742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
12743: THEN
12744: retcode := 2; -- error based only on return status
12745: log_error_messages;

Line 13194: FND_MSG_PUB.add;

13190: END LOOP;
13191: END IF;
13192:
13193: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
13194: FND_MSG_PUB.add;
13195: errbuf := FND_MSG_PUB.Get;
13196:
13197: RETURN;
13198: END;

Line 13195: errbuf := FND_MSG_PUB.Get;

13191: END IF;
13192:
13193: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
13194: FND_MSG_PUB.add;
13195: errbuf := FND_MSG_PUB.Get;
13196:
13197: RETURN;
13198: END;
13199:

Line 13261: FND_MSG_PUB.add;

13257: END LOOP;
13258: END IF;
13259:
13260: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
13261: FND_MSG_PUB.add;
13262: errbuf := FND_MSG_PUB.Get;
13263:
13264: RETURN;
13265: END;

Line 13262: errbuf := FND_MSG_PUB.Get;

13258: END IF;
13259:
13260: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
13261: FND_MSG_PUB.add;
13262: errbuf := FND_MSG_PUB.Get;
13263:
13264: RETURN;
13265: END;
13266:

Line 13949: FND_MSG_PUB.add;

13945: END LOOP;
13946: END IF;
13947:
13948: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
13949: FND_MSG_PUB.add;
13950:
13951: RETURN;
13952: END;
13953:

Line 14012: FND_MSG_PUB.add;

14008: END LOOP;
14009: END IF;
14010:
14011: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
14012: FND_MSG_PUB.add;
14013:
14014: RETURN;
14015: END;
14016:

Line 14325: FND_MSG_PUB.ADD;

14321: IF (ahl_ue_csr%NOTFOUND) THEN
14322: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
14323: FND_MESSAGE.Set_Token('UE_ID',l_ue_relns_rec.ue_id);
14324: FND_MESSAGE.Set_Token('RELATED_UE_ID', l_ue_relns_rec.related_ue_id);
14325: FND_MSG_PUB.ADD;
14326: CLOSE ahl_ue_csr;
14327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14328: END IF;
14329: CLOSE ahl_ue_csr;

Line 14582: FND_MSG_PUB.ADD;

14578:
14579: -- Validate input parameters.
14580: IF (p_item_instance_id IS NULL OR p_item_instance_id = FND_API.G_MISS_NUM) THEN
14581: FND_MESSAGE.Set_Name('AHL','AHL_UMP_CONT_ITEM_ID_NULL');
14582: FND_MSG_PUB.ADD;
14583: RAISE FND_API.G_EXC_ERROR;
14584: ELSE
14585: OPEN ahl_item_instance_csr (p_item_instance_id);
14586: FETCH ahl_item_instance_csr INTO l_inventory_item_id, l_inv_master_organization_id;

Line 14590: FND_MSG_PUB.ADD;

14586: FETCH ahl_item_instance_csr INTO l_inventory_item_id, l_inv_master_organization_id;
14587: IF (ahl_item_instance_csr%NOTFOUND) THEN
14588: FND_MESSAGE.Set_Name('AHL','AHL_UMP_CONT_ITEM_ID_INVALID');
14589: FND_MESSAGE.Set_Token('Item_Instance_ID', p_item_instance_id);
14590: FND_MSG_PUB.ADD;
14591: CLOSE ahl_item_instance_csr;
14592: RAISE FND_API.G_EXC_ERROR;
14593: END IF;
14594: CLOSE ahl_item_instance_csr;

Line 14614: IF FND_MSG_PUB.Count_msg > 0 THEN

14610: l_uc_header_id, G_master_config_id);
14611:
14612:
14613: -- Check for errors.
14614: IF FND_MSG_PUB.Count_msg > 0 THEN
14615: RAISE FND_API.G_EXC_ERROR;
14616: END IF;
14617:
14618: -- Get utilization forecast for the unit/part.

Line 14702: FND_MSG_PUB.Count_And_Get

14698: END IF;
14699: x_expiration_date := l_calc_due_date;
14700:
14701: -- Standard call to get message count and if count is 1, get message info
14702: FND_MSG_PUB.Count_And_Get
14703: ( p_count => x_msg_count,
14704: p_data => x_msg_data,
14705: p_encoded => fnd_api.g_false
14706: );

Line 14712: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

14708: --
14709: EXCEPTION
14710: WHEN FND_API.G_EXC_ERROR THEN
14711: x_return_status := FND_API.G_RET_STS_ERROR;
14712: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
14713: p_data => x_msg_data,
14714: p_encoded => fnd_api.g_false);
14715:
14716: -- Disable debug

Line 14721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

14717: AHL_DEBUG_PUB.disable_debug;
14718:
14719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
14722: p_data => x_msg_data,
14723: p_encoded => fnd_api.g_false);
14724:
14725: -- Disable debug

Line 14731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

14727:
14728: WHEN OTHERS THEN
14729:
14730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
14732: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
14733: p_procedure_name => 'Get_Cont_Ctr_Expiration_Date',
14734: p_error_text => SUBSTR(SQLERRM,1,240));
14735: END IF;

Line 14732: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

14728: WHEN OTHERS THEN
14729:
14730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14731: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
14732: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
14733: p_procedure_name => 'Get_Cont_Ctr_Expiration_Date',
14734: p_error_text => SUBSTR(SQLERRM,1,240));
14735: END IF;
14736: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 14736: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

14732: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
14733: p_procedure_name => 'Get_Cont_Ctr_Expiration_Date',
14734: p_error_text => SUBSTR(SQLERRM,1,240));
14735: END IF;
14736: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
14737: p_data => x_msg_data,
14738: p_encoded => fnd_api.g_false);
14739:
14740:

Line 15091: FND_MSG_PUB.ADD;

15087: FETCH ahl_ue_csr INTO l_loop_chain_seq_num, l_start_lc_ue_id;
15088: IF (ahl_ue_csr%NOTFOUND) THEN
15089: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');
15090: FND_MESSAGE.Set_Token('UE_ID',l_last_acc_ue_id );
15091: FND_MSG_PUB.ADD;
15092: CLOSE ahl_ue_csr;
15093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15094: END IF;
15095: CLOSE ahl_ue_csr;

Line 15435: FND_MSG_PUB.ADD;

15431: -- error
15432: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');
15433: FND_MESSAGE.Set_Token('START_LC_UE_ID',l_chain_start_lc_ue_tbl(h));
15434: FND_MESSAGE.Set_Token('CHAIN_SEQ', l_chain_seq_num_tbl(h)+1);
15435: FND_MSG_PUB.ADD;
15436: CLOSE get_chain_ue_csr;
15437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15438: END IF;
15439: CLOSE get_chain_ue_csr;

Line 15488: FND_MSG_PUB.ADD;

15484: -- error
15485: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');
15486: FND_MESSAGE.Set_Token('START_LC_UE_ID',l_chain_start_lc_ue_tbl(h));
15487: FND_MESSAGE.Set_Token('CHAIN_SEQ', l_chain_seq_num_tbl(h));
15488: FND_MSG_PUB.ADD;
15489: CLOSE get_acc_chain_seq;
15490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15491: END IF;
15492: END IF;

Line 16150: FND_MSG_PUB.ADD;

16146:
16147: -- Validate input parameters.
16148: IF (p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM) THEN
16149: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_NULL');
16150: FND_MSG_PUB.ADD;
16151: RAISE FND_API.G_EXC_ERROR;
16152: END IF;
16153:
16154: IF G_DEBUG = 'Y' THEN

Line 16202: FND_MSG_PUB.ADD;

16198:
16199: WHEN OTHERS THEN
16200: IF (SQLCODE = -54) THEN
16201: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
16202: FND_MSG_PUB.ADD;
16203: RAISE FND_API.G_EXC_ERROR;
16204: ELSE
16205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
16206: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

Line 16205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

16201: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
16202: FND_MSG_PUB.ADD;
16203: RAISE FND_API.G_EXC_ERROR;
16204: ELSE
16205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
16206: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
16207: p_procedure_name => 'Calculate_Init_DueDate',
16208: p_error_text => SUBSTR(SQLERRM,1,240));
16209: END IF;

Line 16206: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

16202: FND_MSG_PUB.ADD;
16203: RAISE FND_API.G_EXC_ERROR;
16204: ELSE
16205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
16206: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
16207: p_procedure_name => 'Calculate_Init_DueDate',
16208: p_error_text => SUBSTR(SQLERRM,1,240));
16209: END IF;
16210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 16304: FND_MSG_PUB.ADD;

16300: l_inventory_item_id, l_inv_master_organization_id;
16301: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
16302: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_INVALID');
16303: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);
16304: FND_MSG_PUB.ADD;
16305: RAISE FND_API.G_EXC_ERROR;
16306: END IF;
16307:
16308: IF G_DEBUG = 'Y' THEN

Line 16328: IF FND_MSG_PUB.Count_msg > 0 THEN

16324: AHL_DEBUG_PUB.debug('Step 2: ROOT CSI: UCH: MCH:' || l_root_csi_instance_id || ':' || l_uc_header_id || ':' || G_master_config_id);
16325: END IF;
16326:
16327: -- Check for errors.
16328: IF FND_MSG_PUB.Count_msg > 0 THEN
16329: RAISE FND_API.G_EXC_ERROR;
16330: END IF;
16331:
16332: IF G_DEBUG = 'Y' THEN