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 573: FND_MSG_PUB.Initialize;

569: SAVEPOINT Process_Unit_PVT;
570:
571: -- Initialize message list if p_init_msg_list is set to TRUE
572: IF FND_API.To_Boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.Initialize;
574: END IF;
575:
576: -- Initialize Procedure return status to success
577: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 611: IF FND_MSG_PUB.Count_msg > 0 THEN

607: -- validate item instance.
608: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,
609: l_inv_master_organization_id);
610:
611: IF FND_MSG_PUB.Count_msg > 0 THEN
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614:
615: -- Log success message if called by concurrent program.

Line 636: IF FND_MSG_PUB.Count_msg > 0 THEN

632: Get_Unit_Master_ConfigIDs (l_csi_item_instance_id,
633: l_uc_header_id, G_master_config_id);
634:
635: -- Check for errors.
636: IF FND_MSG_PUB.Count_msg > 0 THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: -- Build the Configuration tree structure.(G_config_node_tbl).

Line 728: FND_MSG_PUB.ADD;

724: END LOOP;
725:
726: IF (l_ret_code = -54) THEN
727: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
728: FND_MSG_PUB.ADD;
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731:
732: /*

Line 755: IF FND_MSG_PUB.Count_msg > 0 THEN

751: -- Flush from temporary table to ahl_unit_effectivities.
752: AHL_UMP_PROCESSUNIT_EXTN_PVT.Flush_From_Temp_Table(G_config_node_tbl);
753:
754: -- Check for errors.
755: IF FND_MSG_PUB.Count_msg > 0 THEN
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: END IF;
758:
759: /* -- commented for performance fix - bug# 6893404

Line 795: FND_MSG_PUB.Count_And_Get

791: fnd_file.put_line (FND_FILE.LOG, 'Message-Successfully processed:'||p_csi_item_instance_id);
792: END IF;
793:
794: -- Standard call to get message count and if count is 1, get message info
795: FND_MSG_PUB.Count_And_Get
796: ( p_count => x_msg_count,
797: p_data => x_msg_data,
798: p_encoded => fnd_api.g_false
799: );

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

802: EXCEPTION
803: WHEN FND_API.G_EXC_ERROR THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: Rollback to Process_Unit_PVT;
806: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
807: p_data => x_msg_data,
808: p_encoded => fnd_api.g_false);
809:
810: IF (p_concurrent_flag = 'Y') THEN

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

818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: Rollback to Process_Unit_PVT;
822: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => fnd_api.g_false);
825:
826: IF (p_concurrent_flag = 'Y') THEN

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

834: WHEN OTHERS THEN
835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: Rollback to Process_Unit_PVT;
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
839: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
840: p_procedure_name => 'Process_Unit_PVT',
841: p_error_text => SUBSTR(SQLERRM,1,240));
842: END IF;

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

835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: Rollback to Process_Unit_PVT;
838: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
839: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
840: p_procedure_name => 'Process_Unit_PVT',
841: p_error_text => SUBSTR(SQLERRM,1,240));
842: END IF;
843: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

839: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
840: p_procedure_name => 'Process_Unit_PVT',
841: p_error_text => SUBSTR(SQLERRM,1,240));
842: END IF;
843: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
844: p_data => x_msg_data,
845: p_encoded => fnd_api.g_false);
846:
847:

Line 1110: FND_MSG_PUB.Initialize;

1106: SAVEPOINT Process_PM_Contracts_PVT;
1107:
1108: -- Initialize message list if p_init_msg_list is set to TRUE
1109: IF FND_API.To_Boolean(p_init_msg_list) THEN
1110: FND_MSG_PUB.Initialize;
1111: END IF;
1112:
1113: -- Initialize Procedure return status to success
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1176: l_msg_count := FND_MSG_PUB.count_msg;

1172: x_ent_contracts => l_ent_cont_tbl
1173: );
1174:
1175: -- Check Error Message stack.
1176: l_msg_count := FND_MSG_PUB.count_msg;
1177: IF (l_msg_count > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180:

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

1195: x_return_status => x_return_status,
1196: p_csi_item_instance_id => l_ent_cont_tbl(i).coverage_level_id,
1197: p_concurrent_flag => p_concurrent_flag
1198: );
1199: IF (p_concurrent_flag = 'Y' and (FND_MSG_PUB.count_msg > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1200: fnd_file.put_line(fnd_file.log, 'Process_Unit failed for instance: ' || l_ent_cont_tbl(i).coverage_level_id);
1201: END IF;
1202: END IF;
1203: END LOOP;

Line 1207: l_msg_count := FND_MSG_PUB.count_msg;

1203: END LOOP;
1204: END IF;
1205:
1206: -- Check Error Message stack.
1207: l_msg_count := FND_MSG_PUB.count_msg;
1208: IF (l_msg_count > 0 or x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END IF;
1211:

Line 1223: FND_MSG_PUB.Count_And_Get

1219: fnd_file.put_line(fnd_file.log, 'Message-Successfully processed: contract Number '|| p_contract_number || ' and contract modifier' || p_contract_modifier);
1220: END IF;
1221:
1222: -- Standard call to get message count and if count is 1, get message info
1223: FND_MSG_PUB.Count_And_Get
1224: (
1225: p_count => x_msg_count,
1226: p_data => x_msg_data,
1227: p_encoded => fnd_api.g_false

Line 1234: FND_MSG_PUB.count_and_get

1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: Rollback to Process_PM_Contracts_PVT;
1234: FND_MSG_PUB.count_and_get
1235: (
1236: p_count => x_msg_count,
1237: p_data => x_msg_data,
1238: p_encoded => fnd_api.g_false

Line 1249: FND_MSG_PUB.count_and_get

1245:
1246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: Rollback to Process_PM_Contracts_PVT;
1249: FND_MSG_PUB.count_and_get
1250: (
1251: p_count => x_msg_count,
1252: p_data => x_msg_data,
1253: p_encoded => fnd_api.g_false

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

1260:
1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: Rollback to Process_PM_Contracts_PVT;
1264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1265: fnd_msg_pub.add_exc_msg
1266: (
1267: p_pkg_name => G_PKG_NAME,
1268: p_procedure_name => 'Process_PM_Contracts',

Line 1265: fnd_msg_pub.add_exc_msg

1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: Rollback to Process_PM_Contracts_PVT;
1264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1265: fnd_msg_pub.add_exc_msg
1266: (
1267: p_pkg_name => G_PKG_NAME,
1268: p_procedure_name => 'Process_PM_Contracts',
1269: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1272: FND_MSG_PUB.count_and_get

1268: p_procedure_name => 'Process_PM_Contracts',
1269: p_error_text => SUBSTR(SQLERRM,1,240)
1270: );
1271: END IF;
1272: FND_MSG_PUB.count_and_get
1273: (
1274: p_count => x_msg_count,
1275: p_data => x_msg_data,
1276: p_encoded => fnd_api.g_false

Line 1408: FND_MSG_PUB.ADD;

1404: l_inventory_item_id, l_inv_master_organization_id;
1405: IF (csi_item_instances_csr%NOTFOUND) THEN
1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');
1407: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);
1408: FND_MSG_PUB.ADD;
1409: CLOSE csi_item_instances_csr;
1410: --dbms_output.put_line('Instance not found');
1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN

Line 1415: FND_MSG_PUB.ADD;

1411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: ELSIF (trunc(l_active_end_date) < trunc(sysdate)) THEN
1413: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');
1414: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);
1415: FND_MSG_PUB.ADD;
1416: --dbms_output.put_line('Instance has expired');
1417: END IF;
1418:
1419: CLOSE csi_item_instances_csr;

Line 1477: FND_MSG_PUB.ADD;

1473: --modified for quaratine statuses.
1474: IF (l_config_status_code = 'DRAFT') THEN
1475: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
1476: FND_MESSAGE.Set_Token('NAME',l_name);
1477: FND_MSG_PUB.ADD;
1478: --dbms_output.put_line('UC is in draft status');
1479: ELSE
1480: x_uc_header_id := l_unit_config_header_id;
1481: x_master_config_id := l_master_config_id;

Line 2053: --FND_MSG_PUB.ADD;

2049:
2050: WHEN OTHERS THEN
2051: IF (SQLCODE = -54) THEN
2052: --FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');
2053: --FND_MSG_PUB.ADD;
2054: --RAISE FND_API.G_EXC_ERROR;
2055: x_ret_code := '-54';
2056: ELSE
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

2053: --FND_MSG_PUB.ADD;
2054: --RAISE FND_API.G_EXC_ERROR;
2055: x_ret_code := '-54';
2056: ELSE
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2058: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2059: p_procedure_name => 'Lock_UnitEffectivity_Records',
2060: p_error_text => SUBSTR(SQLERRM,1,240));
2061: END IF;

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

2054: --RAISE FND_API.G_EXC_ERROR;
2055: x_ret_code := '-54';
2056: ELSE
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2058: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2059: p_procedure_name => 'Lock_UnitEffectivity_Records',
2060: p_error_text => SUBSTR(SQLERRM,1,240));
2061: END IF;
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6237: FND_MSG_PUB.ADD;

6233: IF (ahl_ue_csr%NOTFOUND) THEN
6234: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
6235: FND_MESSAGE.Set_Token('UE_ID',l_ue_relns_rec.ue_id);
6236: FND_MESSAGE.Set_Token('RELATED_UE_ID', l_ue_relns_rec.related_ue_id);
6237: FND_MSG_PUB.ADD;
6238: CLOSE ahl_ue_csr;
6239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6240: END IF;
6241: --dbms_output.put_line ('found ue relns');

Line 6667: l_msg_count := FND_MSG_PUB.Count_Msg;

6663: AHL_DEBUG_PUB.Debug('Start log error messages');
6664: END IF;
6665:
6666: -- Standard call to get message count.
6667: l_msg_count := FND_MSG_PUB.Count_Msg;
6668:
6669: FOR i IN 1..l_msg_count LOOP
6670: FND_MSG_PUB.get (
6671: p_msg_index => i,

Line 6670: FND_MSG_PUB.get (

6666: -- Standard call to get message count.
6667: l_msg_count := FND_MSG_PUB.Count_Msg;
6668:
6669: FOR i IN 1..l_msg_count LOOP
6670: FND_MSG_PUB.get (
6671: p_msg_index => i,
6672: p_encoded => FND_API.G_FALSE,
6673: p_data => l_msg_data,
6674: p_msg_index_out => l_msg_index_out );

Line 7288: FND_MSG_PUB.ADD;

7284: FETCH ahl_cont_scheduled_csr INTO l_cont_scheduled_rec;
7285: IF (ahl_cont_scheduled_csr%NOTFOUND) THEN
7286: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PMPROGRAM_NOTFOUND');
7287: FND_MESSAGE.Set_Token('PMPROGRAM',sch_activity_rec.mr_header_id);
7288: FND_MSG_PUB.ADD;
7289: CLOSE ahl_cont_scheduled_csr;
7290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7291: END IF;
7292:

Line 8193: FND_MSG_PUB.ADD;

8189:
8190: -- Validate input parameters.
8191: IF (p_unit_effectivity_id IS NULL OR p_unit_effectivity_id = FND_API.G_MISS_NUM) THEN
8192: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_NULL');
8193: FND_MSG_PUB.ADD;
8194: RAISE FND_API.G_EXC_ERROR;
8195: ELSE
8196: OPEN ahl_unit_effectivity_csr (p_unit_effectivity_id);
8197: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id;

Line 8201: FND_MSG_PUB.ADD;

8197: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id;
8198: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
8199: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_INVALID');
8200: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);
8201: FND_MSG_PUB.ADD;
8202: RAISE FND_API.G_EXC_ERROR;
8203: END IF;
8204: END IF;
8205:

Line 8213: FND_MSG_PUB.ADD;

8209: FETCH ahl_mr_headers_csr INTO l_whichever_first_code;
8210: IF (ahl_mr_headers_csr%NOTFOUND) THEN
8211: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_MR_INVALID');
8212: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);
8213: FND_MSG_PUB.ADD;
8214: RAISE FND_API.G_EXC_ERROR;
8215: END IF;
8216: CLOSE ahl_mr_headers_csr;
8217: ELSE

Line 8241: IF FND_MSG_PUB.Count_msg > 0 THEN

8237: AHL_DEBUG_PUB.debug('Step 2');
8238: END IF;
8239:
8240: -- Check for errors.
8241: IF FND_MSG_PUB.Count_msg > 0 THEN
8242: RAISE FND_API.G_EXC_ERROR;
8243: END IF;
8244:
8245: IF G_DEBUG = 'Y' THEN

Line 8338: FND_MSG_PUB.Count_And_Get

8334: END IF;
8335: x_due_date := l_calc_due_date;
8336:
8337: -- Standard call to get message count and if count is 1, get message info
8338: FND_MSG_PUB.Count_And_Get
8339: ( p_count => x_msg_count,
8340: p_data => x_msg_data,
8341: p_encoded => fnd_api.g_false
8342: );

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

8344: --
8345: EXCEPTION
8346: WHEN FND_API.G_EXC_ERROR THEN
8347: x_return_status := FND_API.G_RET_STS_ERROR;
8348: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
8349: p_data => x_msg_data,
8350: p_encoded => fnd_api.g_false);
8351:
8352: -- Disable debug

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

8353: AHL_DEBUG_PUB.disable_debug;
8354:
8355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8357: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
8358: p_data => x_msg_data,
8359: p_encoded => fnd_api.g_false);
8360:
8361: -- Disable debug

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

8363:
8364: WHEN OTHERS THEN
8365:
8366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
8369: p_procedure_name => 'Get_Deferred_Due_Date',
8370: p_error_text => SUBSTR(SQLERRM,1,240));
8371: END IF;

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

8364: WHEN OTHERS THEN
8365:
8366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
8369: p_procedure_name => 'Get_Deferred_Due_Date',
8370: p_error_text => SUBSTR(SQLERRM,1,240));
8371: END IF;
8372: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

8368: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
8369: p_procedure_name => 'Get_Deferred_Due_Date',
8370: p_error_text => SUBSTR(SQLERRM,1,240));
8371: END IF;
8372: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
8373: p_data => x_msg_data,
8374: p_encoded => fnd_api.g_false);
8375:
8376:

Line 8714: FND_MSG_PUB.ADD;

8710: IF (ahl_unit_deferral_csr%NOTFOUND) THEN
8711: CLOSE ahl_unit_deferral_csr;
8712: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_NOTFOUND');
8713: FND_MESSAGE.Set_Token('UE_ID',unit_effectivity_rec.defer_from_ue_id);
8714: FND_MSG_PUB.ADD;
8715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8716: END IF;
8717:
8718: CLOSE ahl_unit_deferral_csr;

Line 8873: FND_MSG_PUB.ADD;

8869: IF (get_repair_category_csr%NOTFOUND) THEN
8870: --l_calc_due_date := NULL;
8871: FND_MESSAGE.Set_Name('AHL','AHL_PUE_INCIDENT_ID_MISSING');
8872: FND_MESSAGE.Set_Token('CS_INC_ID',unit_effectivity_rec.cs_incident_id);
8873: FND_MSG_PUB.ADD;
8874: RAISE FND_API.G_EXC_ERROR;
8875: ELSE
8876:
8877: IF l_repair_time <> 0 AND

Line 9385: FND_MSG_PUB.ADD;

9381: IF (ahl_ue_csr%NOTFOUND) THEN
9382: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');
9383: FND_MESSAGE.Set_Token('UE_ID',ahl_ue_relns_rec.ue_id);
9384: FND_MESSAGE.Set_Token('RELATED_UE_ID', ahl_ue_relns_rec.related_ue_id);
9385: FND_MSG_PUB.ADD;
9386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9387: END IF;
9388:
9389: l_ue_details_tbl(i).level := ahl_ue_relns_rec.level;

Line 9632: FND_MSG_PUB.ADD;

9628: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
9629: IF (ahl_unit_effectivity_csr%NOTFOUND) THEN
9630: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
9631: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
9632: FND_MSG_PUB.ADD;
9633: -- dbms_output.put_line('unit effectivity not found for ue id' ||l_ue_rec.unit_effectivity_id );
9634: ClOSE ahl_unit_effectivity_csr;
9635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9636: ELSE

Line 9782: FND_MSG_PUB.ADD;

9778: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
9779: ELSE
9780: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');
9781: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);
9782: FND_MSG_PUB.ADD;
9783: -- dbms_output.put_line('descendent mr not found for ue id');
9784: ClOSE ahl_unit_effectivity_csr;
9785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9786: END IF;

Line 9841: FND_MSG_PUB.Initialize;

9837: END IF;
9838:
9839: -- Initialize message list if p_init_msg_list is set to TRUE
9840: IF FND_API.To_Boolean(p_init_msg_list) THEN
9841: FND_MSG_PUB.Initialize;
9842: END IF;
9843:
9844: -- Initialize Procedure return status to success
9845: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9866: IF FND_MSG_PUB.Count_msg > 0 THEN

9862: -- validate item instance.
9863: Validate_item_instance(p_csi_item_instance_id, l_inventory_item_id,
9864: l_inv_master_organization_id);
9865:
9866: IF FND_MSG_PUB.Count_msg > 0 THEN
9867: RAISE FND_API.G_EXC_ERROR;
9868: END IF;
9869:
9870: -- set instance variable.

Line 9883: IF FND_MSG_PUB.Count_msg > 0 THEN

9879: Get_Unit_Master_ConfigIDs (l_csi_item_instance_id,
9880: l_uc_header_id, G_master_config_id);
9881:
9882: -- Check for errors.
9883: IF FND_MSG_PUB.Count_msg > 0 THEN
9884: RAISE FND_API.G_EXC_ERROR;
9885: END IF;
9886:
9887: -- Build the Configuration tree structure.(G_config_node_tbl).

Line 9951: FND_MSG_PUB.Count_And_Get

9947: x_counter_values_tbl := l_due_at_counter_val_tbl;
9948: END IF;
9949:
9950: -- Standard call to get message count and if count is 1, get message info
9951: FND_MSG_PUB.Count_And_Get
9952: ( p_count => x_msg_count,
9953: p_data => x_msg_data,
9954: p_encoded => fnd_api.g_false
9955: );

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

9961: --
9962: EXCEPTION
9963: WHEN FND_API.G_EXC_ERROR THEN
9964: x_return_status := FND_API.G_RET_STS_ERROR;
9965: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9966: p_data => x_msg_data,
9967: p_encoded => fnd_api.g_false);
9968:
9969: -- Disable debug

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

9970: AHL_DEBUG_PUB.disable_debug;
9971:
9972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9974: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9975: p_data => x_msg_data,
9976: p_encoded => fnd_api.g_false);
9977:
9978: -- Disable debug

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

9979: AHL_DEBUG_PUB.disable_debug;
9980:
9981: WHEN OTHERS THEN
9982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9984: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9985: p_procedure_name => 'Get_Forecasted_Counter_Values',
9986: p_error_text => SUBSTR(SQLERRM,1,240));
9987: END IF;

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

9980:
9981: WHEN OTHERS THEN
9982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9983: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9984: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9985: p_procedure_name => 'Get_Forecasted_Counter_Values',
9986: p_error_text => SUBSTR(SQLERRM,1,240));
9987: END IF;
9988: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

9984: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
9985: p_procedure_name => 'Get_Forecasted_Counter_Values',
9986: p_error_text => SUBSTR(SQLERRM,1,240));
9987: END IF;
9988: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
9989: p_data => x_msg_data,
9990: p_encoded => fnd_api.g_false);
9991:
9992: -- Disable debug

Line 10248: FND_MSG_PUB.ADD;

10244: FETCH check_mr_exists INTO l_mr_header_id;
10245: IF check_mr_exists%NOTFOUND THEN
10246: CLOSE check_mr_exists;
10247: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
10248: FND_MSG_PUB.ADD;
10249: RAISE FND_API.G_EXC_ERROR;
10250: END IF;
10251: CLOSE check_mr_exists;
10252:

Line 10293: FND_MSG_PUB.ADD;

10289: FETCH get_master_org_id_csr INTO l_master_org_id;
10290: IF (get_master_org_id_csr%NOTFOUND) THEN
10291: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_MASORG_NOTFOUND');
10292: FND_MESSAGE.Set_Token('INV_ID',l_mr_effect.inventory_item_id);
10293: FND_MSG_PUB.ADD;
10294: --DBMS_OUTPUT.put_line('Master org not found for inventory item:' || l_mr_effect.inventory_item_id);
10295: ClOSE get_master_org_id_csr;
10296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10297: END IF;

Line 10756: l_msg_count := FND_MSG_PUB.Count_Msg;

10752: p_csi_item_instance_id => l_csi_inst_tbl(i),
10753: --inst_rec.instance_id,
10754: p_concurrent_flag => 'Y');
10755:
10756: l_msg_count := FND_MSG_PUB.Count_Msg;
10757: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
10758: THEN
10759: retcode := 2; -- error based only on return status
10760: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

Line 10997: l_msg_count := FND_MSG_PUB.Count_Msg;

10993: p_concurrent_flag => 'Y');
10994:
10995: fnd_file.put_line(FND_FILE.LOG,'End time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
10996:
10997: l_msg_count := FND_MSG_PUB.Count_Msg;
10998: IF (retcode <> 2 AND l_return_status <> FND_API.G_RET_STS_SUCCESS)
10999: THEN
11000: retcode := 2; -- error based only on return status
11001: ELSIF (retcode = 0 AND l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

Line 11080: l_msg_count := FND_MSG_PUB.Count_Msg;

11076: p_mr_header_id => p_new_mr_header_id,
11077: p_concurrent_flag => 'Y',
11078: p_num_of_workers => 5);
11079:
11080: l_msg_count := FND_MSG_PUB.Count_Msg;
11081: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
11082: THEN
11083: retcode := 2; -- error based only on return status
11084: log_error_messages;

Line 11460: FND_MSG_PUB.add;

11456: END LOOP;
11457: END IF;
11458:
11459: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
11460: FND_MSG_PUB.add;
11461: errbuf := FND_MSG_PUB.Get;
11462:
11463: RETURN;
11464: END;

Line 11461: errbuf := FND_MSG_PUB.Get;

11457: END IF;
11458:
11459: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
11460: FND_MSG_PUB.add;
11461: errbuf := FND_MSG_PUB.Get;
11462:
11463: RETURN;
11464: END;
11465:

Line 12085: FND_MSG_PUB.add;

12081: END LOOP;
12082: END IF;
12083:
12084: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
12085: FND_MSG_PUB.add;
12086:
12087: RETURN;
12088: END;
12089:

Line 12148: FND_MSG_PUB.add;

12144: END LOOP;
12145: END IF;
12146:
12147: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');
12148: FND_MSG_PUB.add;
12149:
12150: RETURN;
12151: END;
12152: