DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_MESSAGE

Line 727: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');

723: DBMS_LOCK.SLEEP(30);
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:

Line 1406: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INSTID_NOTFOUND');

1402: OPEN csi_item_instances_csr (p_csi_item_instance_id);
1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
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');

Line 1407: FND_MESSAGE.Set_Token('INST_ID', p_csi_item_instance_id);

1403: FETCH csi_item_instances_csr INTO l_instance_number, l_active_end_date,
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;

Line 1413: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_INST_EXPIRED');

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
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;

Line 1414: FND_MESSAGE.Set_Token('NUMBER', l_instance_number);

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
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:

Line 1475: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');

1471: IF (ahl_unit_config_header_csr%FOUND) THEN
1472: --IF (l_config_status_code <> 'COMPLETE' AND l_config_status_code <> 'INCOMPLETE') THEN
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

Line 1476: FND_MESSAGE.Set_Token('NAME',l_name);

1472: --IF (l_config_status_code <> 'COMPLETE' AND l_config_status_code <> 'INCOMPLETE') THEN
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;

Line 2052: --FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_ALREADY_RUNNING');

2048: EXCEPTION
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

Line 6234: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');

6230: l_ue_details_tbl(i).csi_item_instance_id,
6231: l_ue_details_tbl(i).related_mr_header_id,
6232: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

Line 6235: FND_MESSAGE.Set_Token('UE_ID',l_ue_relns_rec.ue_id);

6231: l_ue_details_tbl(i).related_mr_header_id,
6232: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

Line 6236: FND_MESSAGE.Set_Token('RELATED_UE_ID', l_ue_relns_rec.related_ue_id);

6232: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

Line 7286: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_PMPROGRAM_NOTFOUND');

7282: /*
7283: OPEN ahl_cont_scheduled_csr(sch_activity_rec.mr_header_id);
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;

Line 7287: FND_MESSAGE.Set_Token('PMPROGRAM',sch_activity_rec.mr_header_id);

7283: OPEN ahl_cont_scheduled_csr(sch_activity_rec.mr_header_id);
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;

Line 8192: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_NULL');

8188: END IF;
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);

Line 8199: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_UE_INVALID');

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;
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;

Line 8200: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);

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;
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;

Line 8211: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_MR_INVALID');

8207: -- get MR details from ahl_mr_headers.
8208: OPEN ahl_mr_headers_csr(l_mr_header_id);
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;

Line 8212: FND_MESSAGE.Set_Token('UE_ID', p_unit_effectivity_id);

8208: OPEN ahl_mr_headers_csr(l_mr_header_id);
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;

Line 8712: FND_MESSAGE.Set_Name('AHL','AHL_UMP_DEF_NOTFOUND');

8708: FETCH ahl_unit_deferral_csr INTO l_affect_due_date_calc, l_set_due_date, l_unit_deferral_id,
8709: l_deferral_effective_on;
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;

Line 8713: FND_MESSAGE.Set_Token('UE_ID',unit_effectivity_rec.defer_from_ue_id);

8709: l_deferral_effective_on;
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:

Line 8871: FND_MESSAGE.Set_Name('AHL','AHL_PUE_INCIDENT_ID_MISSING');

8867: OPEN get_repair_category_csr(unit_effectivity_rec.cs_incident_id);
8868: FETCH get_repair_category_csr INTO l_repair_time, l_expected_resolutn_date;
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

Line 8872: FND_MESSAGE.Set_Token('CS_INC_ID',unit_effectivity_rec.cs_incident_id);

8868: FETCH get_repair_category_csr INTO l_repair_time, l_expected_resolutn_date;
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:

Line 9382: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_RELN_NOTFOUND');

9378: l_ue_details_tbl(i).csi_item_instance_id,
9379: l_ue_details_tbl(i).related_mr_header_id,
9380: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

Line 9383: FND_MESSAGE.Set_Token('UE_ID',ahl_ue_relns_rec.ue_id);

9379: l_ue_details_tbl(i).related_mr_header_id,
9380: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

Line 9384: FND_MESSAGE.Set_Token('RELATED_UE_ID', ahl_ue_relns_rec.related_ue_id);

9380: l_ue_details_tbl(i).related_csi_item_instance_id;
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:

Line 9630: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

9626:
9627: OPEN ahl_unit_effectivity_csr(ahl_unplanned_ue_rec.unit_effectivity_id);
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;

Line 9631: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

9627: OPEN ahl_unit_effectivity_csr(ahl_unplanned_ue_rec.unit_effectivity_id);
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;

Line 9780: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

9776: X_LAST_UPDATE_DATE => sysdate,
9777: X_LAST_UPDATED_BY => fnd_global.user_id,
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;

Line 9781: FND_MESSAGE.Set_Token('UE_ID',l_ue_rec.unit_effectivity_id);

9777: X_LAST_UPDATED_BY => fnd_global.user_id,
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;

Line 10247: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');

10243: OPEN check_mr_exists(p_mr_header_id);
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;

Line 10291: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_MASORG_NOTFOUND');

10287: -- get master organization id.
10288: OPEN get_master_org_id_csr(l_mr_effect.inventory_item_id);
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;

Line 10292: FND_MESSAGE.Set_Token('INV_ID',l_mr_effect.inventory_item_id);

10288: OPEN get_master_org_id_csr(l_mr_effect.inventory_item_id);
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;

Line 11459: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');

11455: sqlerrm(-sql%bulk_exceptions(j).error_code) );
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;

Line 12084: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');

12080: sqlerrm(-sql%bulk_exceptions(j).error_code) );
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;

Line 12147: FND_MESSAGE.set_name('AHL', 'AHL_UMP_BUE_WORKER_ERR');

12143: sqlerrm(-sql%bulk_exceptions(j).error_code) );
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;