DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_active_end_date <= sysdate THEN
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: */

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

1628: ELSIF l_active_end_date <= sysdate THEN
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';

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

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

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

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

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

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

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

7516: l_ue_details_tbl(i).csi_item_instance_id,
7517: l_ue_details_tbl(i).related_mr_header_id,
7518: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

9679: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id,
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

10909: l_ue_details_tbl(i).csi_item_instance_id,
10910: l_ue_details_tbl(i).related_mr_header_id,
10911: l_ue_details_tbl(i).related_csi_item_instance_id;
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

11465: l_inv_master_organization_id, l_expired_flag);
11466:
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;

Line 11470: FND_MESSAGE.Set_Token('NUMBER', p_csi_item_instance_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

14318: l_csi_item_instance_id,
14319: l_related_mr_header_id,
14320: l_related_csi_item_instance_id;
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;

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

14319: l_related_mr_header_id,
14320: l_related_csi_item_instance_id;
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;

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

14320: l_related_csi_item_instance_id;
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;

Line 14581: FND_MESSAGE.Set_Name('AHL','AHL_UMP_CONT_ITEM_ID_NULL');

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

Line 14588: FND_MESSAGE.Set_Name('AHL','AHL_UMP_CONT_ITEM_ID_INVALID');

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

Line 14589: FND_MESSAGE.Set_Token('Item_Instance_ID', p_item_instance_id);

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

Line 15089: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');

15085: -- get ue details
15086: OPEN ahl_ue_csr(l_last_acc_ue_id);
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;

Line 15090: FND_MESSAGE.Set_Token('UE_ID',l_last_acc_ue_id );

15086: OPEN ahl_ue_csr(l_last_acc_ue_id);
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;

Line 15432: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');

15428: OPEN get_chain_ue_csr(l_chain_start_lc_ue_tbl(h), l_chain_seq_num_tbl(h)+1);
15429: FETCH get_chain_ue_csr INTO l_chain_ue_id, l_visit_status, l_defer_from_ue_id, l_mr_header_id, l_mr_title;
15430: IF (get_chain_ue_csr%NOTFOUND) THEN
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;

Line 15433: FND_MESSAGE.Set_Token('START_LC_UE_ID',l_chain_start_lc_ue_tbl(h));

15429: FETCH get_chain_ue_csr INTO l_chain_ue_id, l_visit_status, l_defer_from_ue_id, l_mr_header_id, l_mr_title;
15430: IF (get_chain_ue_csr%NOTFOUND) THEN
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;

Line 15434: FND_MESSAGE.Set_Token('CHAIN_SEQ', l_chain_seq_num_tbl(h)+1);

15430: IF (get_chain_ue_csr%NOTFOUND) THEN
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;

Line 15485: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UE_INVALID');

15481: l_c_accomplishment_date := l_c_deferral_effective_on;
15482: END IF;
15483: ELSE
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;

Line 15486: FND_MESSAGE.Set_Token('START_LC_UE_ID',l_chain_start_lc_ue_tbl(h));

15482: END IF;
15483: ELSE
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;

Line 15487: FND_MESSAGE.Set_Token('CHAIN_SEQ', l_chain_seq_num_tbl(h));

15483: ELSE
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;

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

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

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

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

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

16298: OPEN ahl_unit_effectivity_csr (p_unit_effectivity_id);
16299: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id,
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;

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

16299: FETCH ahl_unit_effectivity_csr INTO l_csi_item_instance_id, l_mr_header_id,
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: