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.CSI_ORGANIZATION_UNIT_PVT dependencies on CSI_ORG_UNIT_VLD_PVT

Line 736: IF NOT(csi_org_unit_vld_pvt.Is_valid_instance_id

732: END IF;
733: --
734: -- Verify if instance id is ok
735: IF p_called_from_grp <> FND_API.G_TRUE THEN
736: IF NOT(csi_org_unit_vld_pvt.Is_valid_instance_id
737: (p_org_unit_rec.instance_id,
738: 'INSERT')) THEN
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;

Line 770: IF NOT(csi_org_unit_vld_pvt.Is_valid_operating_unit_id

766: --
767: IF l_exists_flag <> 'Y' THEN
768: p_ou_count_rec.ou_count := p_ou_count_rec.ou_count + 1;
769: p_ou_id_tbl(p_ou_count_rec.ou_count).ou_id := p_org_unit_rec.operating_unit_id;
770: IF NOT(csi_org_unit_vld_pvt.Is_valid_operating_unit_id
771: (p_org_unit_rec.operating_unit_id)) THEN
772: p_ou_id_tbl(p_ou_count_rec.ou_count).valid_flag := 'N';
773: RAISE fnd_api.g_exc_error;
774: ELSE

Line 787: IF NOT(csi_org_unit_vld_pvt.Is_StartDate_Valid

783: END IF;
784: --
785: -- Check start effective date
786: IF p_called_from_grp <> FND_API.G_TRUE THEN
787: IF NOT(csi_org_unit_vld_pvt.Is_StartDate_Valid
788: (p_org_unit_rec.ACTIVE_START_DATE,
789: p_org_unit_rec.ACTIVE_END_DATE ,
790: p_org_unit_rec.INSTANCE_ID )) THEN
791: RAISE FND_API.G_EXC_ERROR;

Line 798: IF NOT(csi_org_unit_vld_pvt.Is_EndDate_Valid

794:
795: -- Check end effective date
796: IF p_called_from_grp <> FND_API.G_TRUE THEN
797: IF p_org_unit_rec.ACTIVE_END_DATE is NOT NULL THEN
798: IF NOT(csi_org_unit_vld_pvt.Is_EndDate_Valid
799: (p_org_unit_rec.ACTIVE_START_DATE,
800: p_org_unit_rec.ACTIVE_END_DATE ,
801: p_org_unit_rec.INSTANCE_ID ,
802: p_org_unit_rec.INSTANCE_OU_ID,

Line 835: IF NOT(csi_org_unit_vld_pvt.Is_valid_rel_type_code

831: --
832: IF l_exists_flag <> 'Y' THEN
833: p_ou_count_rec.lookup_count := p_ou_count_rec.lookup_count + 1;
834: p_lookup_tbl(p_ou_count_rec.lookup_count).lookup_code := p_org_unit_rec.relationship_type_code;
835: IF NOT(csi_org_unit_vld_pvt.Is_valid_rel_type_code
836: (p_org_unit_rec.relationship_type_code)) THEN
837: p_lookup_tbl(p_ou_count_rec.lookup_count).valid_flag := 'N';
838: RAISE FND_API.G_EXC_ERROR;
839: ELSE

Line 911: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;

907: -- and check if the value exists . If exists then generate again from the sequence
908: -- till we get a value that does not exist
909: IF l_instance_ou_id IS NULL OR
910: l_instance_ou_id = FND_API.G_MISS_NUM THEN
911: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;
912: p_org_unit_rec.instance_ou_id := l_instance_ou_id;
913: WHILE NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id
914: (l_instance_ou_id))
915: LOOP

Line 913: WHILE NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id

909: IF l_instance_ou_id IS NULL OR
910: l_instance_ou_id = FND_API.G_MISS_NUM THEN
911: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;
912: p_org_unit_rec.instance_ou_id := l_instance_ou_id;
913: WHILE NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id
914: (l_instance_ou_id))
915: LOOP
916: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;
917: p_org_unit_rec.instance_ou_id := l_instance_ou_id;

Line 916: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;

912: p_org_unit_rec.instance_ou_id := l_instance_ou_id;
913: WHILE NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id
914: (l_instance_ou_id))
915: LOOP
916: l_instance_ou_id := csi_org_unit_vld_pvt.get_instance_ou_id;
917: p_org_unit_rec.instance_ou_id := l_instance_ou_id;
918: END LOOP;
919: ELSE
920: -- Validate instance_ou_id

Line 921: IF NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id

917: p_org_unit_rec.instance_ou_id := l_instance_ou_id;
918: END LOOP;
919: ELSE
920: -- Validate instance_ou_id
921: IF NOT(csi_org_unit_vld_pvt.Is_valid_instance_ou_id
922: (p_org_unit_rec.instance_ou_id)) THEN
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925: END IF;

Line 929: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists

925: END IF;
926: --
927: -- Validate alternate_pk_exists
928: IF p_called_from_grp <> FND_API.G_TRUE THEN
929: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists
930: (p_org_unit_rec.instance_id
931: ,p_org_unit_rec.operating_unit_id
932: ,p_org_unit_rec.relationship_type_code
933: )) THEN

Line 1005: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;

1001: END IF;
1002:
1003:
1004: -- Get a unique org_assignment history number from the sequence
1005: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;
1006: l_dump_frequency_flag := 'N';
1007: -- Create a row in csi_i_org_assignment history table
1008: CSI_I_ORG_ASSIGNMENTS_H_PKG.Insert_Row(
1009: l_csi_i_org_assign_h_id

Line 1268: IF NOT(csi_org_unit_vld_pvt.Val_and_get_inst_ou_id

1264: p_ou_count_rec.lookup_count := 0;
1265: END IF;
1266: --
1267: -- Validate instance_ou_id
1268: IF NOT(csi_org_unit_vld_pvt.Val_and_get_inst_ou_id
1269: (p_org_unit_rec.instance_ou_id,
1270: l_org_unit_rec)) THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;

Line 1275: IF NOT(csi_org_unit_vld_pvt.Is_valid_obj_ver_num

1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273:
1274: -- Validate object_version_number
1275: IF NOT(csi_org_unit_vld_pvt.Is_valid_obj_ver_num
1276: (p_org_unit_rec.object_version_number
1277: ,l_org_unit_rec.object_version_number
1278: )) THEN
1279: RAISE FND_API.G_EXC_ERROR;

Line 1283: IF NOT(csi_org_unit_vld_pvt.Is_Updatable(

1279: RAISE FND_API.G_EXC_ERROR;
1280: END IF;
1281:
1282: -- Validate if the instance is updatable
1283: IF NOT(csi_org_unit_vld_pvt.Is_Updatable(
1284: l_org_unit_rec.active_end_date,
1285: p_org_unit_rec.active_end_date)) THEN
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;

Line 1290: IF NOT(csi_org_unit_vld_pvt.Is_Valid_instance_id

1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;
1288:
1289: -- Validate instance id for which the update is related to
1290: IF NOT(csi_org_unit_vld_pvt.Is_Valid_instance_id
1291: (l_org_unit_rec.instance_id,
1292: 'UPDATE'
1293: )) THEN
1294: -- Check if it is an expire operation

Line 1295: IF NOT(csi_org_unit_vld_pvt.Is_Expire_Op

1291: (l_org_unit_rec.instance_id,
1292: 'UPDATE'
1293: )) THEN
1294: -- Check if it is an expire operation
1295: IF NOT(csi_org_unit_vld_pvt.Is_Expire_Op
1296: (p_org_unit_rec)) THEN
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299: END IF;

Line 1303: IF NOT(csi_org_unit_vld_pvt.Val_inst_id_for_update

1299: END IF;
1300:
1301: -- Validate instance id
1302: IF ( p_org_unit_rec.instance_id <> FND_API.G_MISS_NUM ) THEN
1303: IF NOT(csi_org_unit_vld_pvt.Val_inst_id_for_update
1304: (p_org_unit_rec.instance_id
1305: ,l_org_unit_rec.instance_id
1306: )) THEN
1307: RAISE FND_API.G_EXC_ERROR;

Line 1339: IF NOT(csi_org_unit_vld_pvt.Is_valid_operating_unit_id

1335: --
1336: IF l_exists_flag <> 'Y' THEN
1337: p_ou_count_rec.ou_count := p_ou_count_rec.ou_count + 1;
1338: p_ou_id_tbl(p_ou_count_rec.ou_count).ou_id := p_org_unit_rec.operating_unit_id;
1339: IF NOT(csi_org_unit_vld_pvt.Is_valid_operating_unit_id
1340: (p_org_unit_rec.operating_unit_id)) THEN
1341: p_ou_id_tbl(p_ou_count_rec.ou_count).valid_flag := 'N';
1342: RAISE fnd_api.g_exc_error;
1343: ELSE

Line 1377: IF NOT(csi_org_unit_vld_pvt.Is_valid_rel_type_code

1373: --
1374: IF l_exists_flag <> 'Y' THEN
1375: p_ou_count_rec.lookup_count := p_ou_count_rec.lookup_count + 1;
1376: p_lookup_tbl(p_ou_count_rec.lookup_count).lookup_code := p_org_unit_rec.relationship_type_code;
1377: IF NOT(csi_org_unit_vld_pvt.Is_valid_rel_type_code
1378: (p_org_unit_rec.relationship_type_code)) THEN
1379: p_lookup_tbl(p_ou_count_rec.lookup_count).valid_flag := 'N';
1380: RAISE FND_API.G_EXC_ERROR;
1381: ELSE

Line 1391: IF NOT(csi_org_unit_vld_pvt.Is_StartDate_Valid

1387: -- Verify start effective date
1388: IF ( p_org_unit_rec.active_start_date <> FND_API.G_MISS_DATE) THEN
1389: IF (p_org_unit_rec.active_start_date <> l_org_unit_rec.active_start_date) THEN
1390: l_start_date := p_org_unit_rec.ACTIVE_START_DATE;
1391: IF NOT(csi_org_unit_vld_pvt.Is_StartDate_Valid
1392: (l_start_date,
1393: p_org_unit_rec.ACTIVE_END_DATE ,
1394: p_org_unit_rec.INSTANCE_ID )) THEN
1395: RAISE FND_API.G_EXC_ERROR;

Line 1405: IF NOT(csi_org_unit_vld_pvt.Is_EndDate_Valid

1401: -- Verify end effective date
1402: IF ( p_org_unit_rec.active_end_date <> FND_API.G_MISS_DATE) THEN
1403: IF p_org_unit_rec.active_end_date is NOT NULL THEN
1404: IF g_expire_flag <> 'Y' THEN
1405: IF NOT(csi_org_unit_vld_pvt.Is_EndDate_Valid
1406: (p_org_unit_rec.ACTIVE_START_DATE,
1407: p_org_unit_rec.ACTIVE_END_DATE,
1408: p_org_unit_rec.INSTANCE_ID ,
1409: p_org_unit_rec.INSTANCE_OU_ID,

Line 1432: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists

1428: ELSE
1429: l_rel_type_code := p_org_unit_rec.relationship_type_code;
1430: END IF;
1431: --
1432: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists
1433: (p_instance_id => l_org_unit_rec.instance_id
1434: ,p_operating_unit_id => l_operating_unit_id
1435: ,p_relationship_type_code => l_rel_type_code
1436: ,p_instance_ou_id => p_org_unit_rec.INSTANCE_OU_ID

Line 1444: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists

1440: -- End of 3918188
1441: -- Validate alternate_pk_exists
1442: /**** IF (p_org_unit_rec.operating_unit_id IS NULL) AND
1443: (p_org_unit_rec.relationship_type_code IS NULL) THEN
1444: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists
1445: (l_org_unit_rec.instance_id
1446: ,l_org_unit_rec.operating_unit_id
1447: ,l_org_unit_rec.relationship_type_code
1448: )) THEN

Line 1453: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists

1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451: ELSIF (p_org_unit_rec.operating_unit_id IS NULL) AND
1452: (p_org_unit_rec.relationship_type_code IS NOT NULL) THEN
1453: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists
1454: (l_org_unit_rec.instance_id
1455: ,l_org_unit_rec.operating_unit_id
1456: ,p_org_unit_rec.relationship_type_code
1457: )) THEN

Line 1462: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists

1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460: ELSIF (p_org_unit_rec.operating_unit_id IS NOT NULL) AND
1461: (p_org_unit_rec.relationship_type_code IS NULL) THEN
1462: IF NOT (csi_org_unit_vld_pvt.Alternate_PK_exists
1463: (l_org_unit_rec.instance_id
1464: ,p_org_unit_rec.operating_unit_id
1465: ,l_org_unit_rec.relationship_type_code
1466: )) THEN

Line 1473: csi_org_unit_vld_pvt.get_object_version_number(l_org_unit_rec.object_version_number);

1469: END IF;
1470: *****/
1471: -- Get the new object version number
1472: l_org_unit_rec.object_version_number :=
1473: csi_org_unit_vld_pvt.get_object_version_number(l_org_unit_rec.object_version_number);
1474:
1475: CSI_I_ORG_ASSIGNMENTS_PKG.Update_Row(
1476: l_instance_ou_id
1477: ,p_org_unit_rec.instance_id

Line 1536: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;

1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;
1534:
1535: -- Get a unique org_assignment history number from the sequence
1536: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;
1537:
1538: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
1539: l_dump_frequency := csi_org_unit_vld_pvt.get_full_dump_frequency;
1540: IF l_dump_frequency IS NULL THEN

Line 1539: l_dump_frequency := csi_org_unit_vld_pvt.get_full_dump_frequency;

1535: -- Get a unique org_assignment history number from the sequence
1536: l_csi_i_org_assign_h_id := csi_org_unit_vld_pvt.get_cis_i_org_assign_h_id;
1537:
1538: -- Get full dump frequency from CSI_INSTALL_PARAMETERS
1539: l_dump_frequency := csi_org_unit_vld_pvt.get_full_dump_frequency;
1540: IF l_dump_frequency IS NULL THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543: -- Grab the input record in a temporary record

Line 2504: IF NOT(csi_org_unit_vld_pvt.Val_and_get_inst_ou_id

2500:
2501: -- Start API body
2502:
2503: -- Validate instance_ou_id
2504: IF NOT(csi_org_unit_vld_pvt.Val_and_get_inst_ou_id
2505: (p_org_unit_rec.instance_ou_id,
2506: l_org_unit_rec)) THEN
2507: RAISE FND_API.G_EXC_ERROR;
2508: END IF;