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.AK_CUSTOM_PVT dependencies on AK_ON_OBJECTS_PVT

Line 846: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD

842: p_start_date_active => l_custom_rec.start_date_active,
843: p_end_date_active => l_custom_rec.end_date_active,
844: p_name => l_custom_tl_rec.name,
845: p_description => l_custom_tl_rec.description,
846: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD
847: )
848: then
849: -- dbms_output.put_line('Custom ' || p_custom_code
850: -- || ' not downloaded due to validation error');

Line 868: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_custom_code) || '" "'||

864: l_index := 1;
865:
866: l_databuffer_tbl(l_index) := 'BEGIN CUSTOMIZATION "' ||
867: nvl(to_char(p_custom_application_id), '') || '" "' ||
868: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_custom_code) || '" "'||
869: nvl(to_char(p_region_application_id), '') || '" "' ||
870: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_region_code) || '"';
871: if ((l_custom_rec.verticalization_id IS NOT NULL) and
872: (l_custom_rec.verticalization_id <> FND_API.G_MISS_CHAR)) then

Line 870: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_region_code) || '"';

866: l_databuffer_tbl(l_index) := 'BEGIN CUSTOMIZATION "' ||
867: nvl(to_char(p_custom_application_id), '') || '" "' ||
868: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_custom_code) || '" "'||
869: nvl(to_char(p_region_application_id), '') || '" "' ||
870: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(p_region_code) || '"';
871: if ((l_custom_rec.verticalization_id IS NOT NULL) and
872: (l_custom_rec.verticalization_id <> FND_API.G_MISS_CHAR)) then
873: l_index := l_index + 1;
874: l_databuffer_tbl(l_index) := ' VERTICALIZATION_ID = "' ||

Line 875: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.verticalization_id) || '"';

871: if ((l_custom_rec.verticalization_id IS NOT NULL) and
872: (l_custom_rec.verticalization_id <> FND_API.G_MISS_CHAR)) then
873: l_index := l_index + 1;
874: l_databuffer_tbl(l_index) := ' VERTICALIZATION_ID = "' ||
875: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.verticalization_id) || '"';
876: end if;
877: if ((l_custom_rec.localization_code IS NOT NULL) and
878: (l_custom_rec.localization_code <> FND_API.G_MISS_CHAR)) then
879: l_index := l_index + 1;

Line 881: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.localization_code) || '"';

877: if ((l_custom_rec.localization_code IS NOT NULL) and
878: (l_custom_rec.localization_code <> FND_API.G_MISS_CHAR)) then
879: l_index := l_index + 1;
880: l_databuffer_tbl(l_index) := ' LOCALIZATION_CODE = "' ||
881: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.localization_code) || '"';
882: end if;
883: if ((l_custom_rec.org_id IS NOT NULL) and
884: (l_custom_rec.org_id <> FND_API.G_MISS_NUM)) then
885: l_index := l_index + 1;

Line 911: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.default_customization_flag) || '"';

907: if ((l_custom_rec.default_customization_flag IS NOT NULL) and
908: (l_custom_rec.default_customization_flag <> FND_API.G_MISS_CHAR)) then
909: l_index := l_index + 1;
910: l_databuffer_tbl(l_index) := ' CUSTOMIZATION_FLAG = "' ||
911: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.default_customization_flag) || '"';
912: end if;
913: if ((l_custom_rec.customization_level_id IS NOT NULL) and
914: (l_custom_rec.customization_level_id <> FND_API.G_MISS_NUM)) then
915: l_index := l_index + 1;

Line 923: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.developer_mode) || '"';

919: if ((l_custom_rec.developer_mode IS NOT NULL) and
920: (l_custom_rec.developer_mode <> FND_API.G_MISS_CHAR)) then
921: l_index := l_index + 1;
922: l_databuffer_tbl(l_index) := ' DEVELOPER_MODE = "' ||
923: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.developer_mode) || '"';
924: end if;
925: if ((l_custom_rec.reference_path IS NOT NULL) and
926: (l_custom_rec.reference_path <> FND_API.G_MISS_CHAR)) then
927: l_index := l_index + 1;

Line 929: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.reference_path) || '"';

925: if ((l_custom_rec.reference_path IS NOT NULL) and
926: (l_custom_rec.reference_path <> FND_API.G_MISS_CHAR)) then
927: l_index := l_index + 1;
928: l_databuffer_tbl(l_index) := ' REFERENCE_PATH = "' ||
929: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.reference_path) || '"';
930: end if;
931: if ((l_custom_rec.function_name IS NOT NULL) and
932: (l_custom_rec.function_name <> FND_API.G_MISS_CHAR)) then
933: l_index := l_index + 1;

Line 935: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.function_name) || '"';

931: if ((l_custom_rec.function_name IS NOT NULL) and
932: (l_custom_rec.function_name <> FND_API.G_MISS_CHAR)) then
933: l_index := l_index + 1;
934: l_databuffer_tbl(l_index) := ' FUNCTION_NAME = "' ||
935: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_rec.function_name) || '"';
936: end if;
937: if ((l_custom_rec.start_date_active IS NOT NULL) and
938: (l_custom_rec.start_date_active <> FND_API.G_MISS_DATE)) then
939: l_index := l_index + 1;

Line 979: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_tl_rec.name) || '"';

975: if ((l_custom_tl_rec.name IS NOT NULL) and
976: (l_custom_tl_rec.name <> FND_API.G_MISS_CHAR)) then
977: l_index := l_index + 1;
978: l_databuffer_tbl(l_index) := ' NAME = "' ||
979: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_tl_rec.name) || '"';
980: end if;
981: if ((l_custom_tl_rec.description IS NOT NULL) and
982: (l_custom_tl_rec.description <> FND_API.G_MISS_CHAR)) then
983: l_index := l_index + 1;

Line 985: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_tl_rec.description) || '"';

981: if ((l_custom_tl_rec.description IS NOT NULL) and
982: (l_custom_tl_rec.description <> FND_API.G_MISS_CHAR)) then
983: l_index := l_index + 1;
984: l_databuffer_tbl(l_index) := ' DESCRIPTION = "' ||
985: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_tl_rec.description) || '"';
986: end if;
987:
988: -- - Write the custom data to the specified file
989: AK_ON_OBJECTS_PVT.WRITE_FILE (

Line 989: AK_ON_OBJECTS_PVT.WRITE_FILE (

985: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_custom_tl_rec.description) || '"';
986: end if;
987:
988: -- - Write the custom data to the specified file
989: AK_ON_OBJECTS_PVT.WRITE_FILE (
990: p_return_status => l_return_status,
991: p_buffer_tbl => l_databuffer_tbl,
992: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
993: );

Line 1059: AK_ON_OBJECTS_PVT.WRITE_FILE (

1055: l_index := l_index + 1;
1056: l_databuffer_tbl(l_index) := ' ';
1057:
1058: -- - Write the 'END CUSTOMIZATION' to the specified file
1059: AK_ON_OBJECTS_PVT.WRITE_FILE (
1060: p_return_status => l_return_status,
1061: p_buffer_tbl => l_databuffer_tbl,
1062: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1063: );

Line 1193: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

1189: p_property_varchar2_value => l_cust_region_rec.property_varchar2_value,
1190: p_property_number_value => l_cust_region_rec.property_number_value,
1191: p_criteria_join_condition => l_cust_region_rec.criteria_join_condition,
1192: p_property_varchar2_value_tl => l_cust_region_tl_rec.property_varchar2_value,
1193: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1194: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1195: close l_get_cust_region_tl_csr;
1196: close l_get_cust_region_csr;
1197: FND_MESSAGE.SET_NAME('AK','AK_CUST_REGION_NOT_DOWNLOADED');

Line 1212: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.property_name) || '"';

1208: l_index := 1;
1209: l_databuffer_tbl(l_index) := ' ';
1210: l_index := l_index + 1;
1211: l_databuffer_tbl(l_index) := ' BEGIN CUSTOM_REGION '|| '"' ||
1212: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.property_name) || '"';
1213: if ((l_cust_region_rec.property_varchar2_value IS NOT NULL) and
1214: (l_cust_region_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1215: l_index := l_index + 1;
1216: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE = "' ||

Line 1217: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.property_varchar2_value) || '"';

1213: if ((l_cust_region_rec.property_varchar2_value IS NOT NULL) and
1214: (l_cust_region_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1215: l_index := l_index + 1;
1216: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE = "' ||
1217: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.property_varchar2_value) || '"';
1218: end if;
1219: if ((l_cust_region_rec.property_number_value IS NOT NULL) and
1220: (l_cust_region_rec.property_number_value <> FND_API.G_MISS_NUM)) then
1221: l_index := l_index + 1;

Line 1229: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.criteria_join_condition) || '"';

1225: if ((l_cust_region_rec.criteria_join_condition IS NOT NULL) and
1226: (l_cust_region_rec.criteria_join_condition <> FND_API.G_MISS_CHAR)) then
1227: l_index := l_index + 1;
1228: l_databuffer_tbl(l_index) := ' CRITERIA_JOIN_CONDITION = "' ||
1229: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_rec.criteria_join_condition) || '"';
1230: end if;
1231: -- - Write out who columns
1232: l_index := l_index + 1;
1233: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||

Line 1258: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_tl_rec.property_varchar2_value) || '"';

1254: if ((l_cust_region_tl_rec.property_varchar2_value IS NOT NULL) and
1255: (l_cust_region_tl_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1256: l_index := l_index + 1;
1257: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE_TL = "' ||
1258: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_tl_rec.property_varchar2_value) || '"';
1259: end if;
1260:
1261: -- finish up customized regions
1262: l_index := l_index + 1;

Line 1268: AK_ON_OBJECTS_PVT.WRITE_FILE (

1264: -- l_index := l_index + 1;
1265: -- l_databuffer_tbl(l_index) := ' ';
1266:
1267: -- - Write the custom region data to the specified file
1268: AK_ON_OBJECTS_PVT.WRITE_FILE (
1269: p_return_status => l_return_status,
1270: p_buffer_tbl => l_databuffer_tbl,
1271: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1272: );

Line 1413: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

1409: p_property_varchar2_value => l_cust_region_item_rec.property_varchar2_value,
1410: p_property_number_value => l_cust_region_item_rec.property_number_value,
1411: p_property_date_value => to_char(l_cust_region_item_rec.property_date_value),
1412: p_property_varchar2_value_tl => l_cust_region_item_rec.property_varchar2_value,
1413: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1414: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1415: close l_get_cust_region_item_tl_csr;
1416: close l_get_cust_region_item_csr;
1417: FND_MESSAGE.SET_NAME('AK','AK_CUSTOM_ITEM_NOT_DOWNLOADED');

Line 1432: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.attribute_code) || '" "' ||

1428: l_databuffer_tbl(l_index) := ' ';
1429: l_index := l_index + 1;
1430: l_databuffer_tbl(l_index) := ' BEGIN CUSTOM_REGION_ITEM "'||
1431: l_cust_region_item_rec.attribute_application_id || '" "' ||
1432: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.attribute_code) || '" "' ||
1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.property_name) || '"';
1434: if ((l_cust_region_item_rec.property_varchar2_value IS NOT NULL) and
1435: (l_cust_region_item_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1436: l_index := l_index + 1;

Line 1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.property_name) || '"';

1429: l_index := l_index + 1;
1430: l_databuffer_tbl(l_index) := ' BEGIN CUSTOM_REGION_ITEM "'||
1431: l_cust_region_item_rec.attribute_application_id || '" "' ||
1432: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.attribute_code) || '" "' ||
1433: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.property_name) || '"';
1434: if ((l_cust_region_item_rec.property_varchar2_value IS NOT NULL) and
1435: (l_cust_region_item_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1436: l_index := l_index + 1;
1437: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE = "' ||

Line 1438: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.property_varchar2_value) || '"';

1434: if ((l_cust_region_item_rec.property_varchar2_value IS NOT NULL) and
1435: (l_cust_region_item_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1436: l_index := l_index + 1;
1437: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE = "' ||
1438: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_rec.property_varchar2_value) || '"';
1439: end if;
1440: if ((l_cust_region_item_rec.property_number_value IS NOT NULL) and
1441: (l_cust_region_item_rec.property_number_value <> FND_API.G_MISS_NUM)) then
1442: l_index := l_index + 1;

Line 1481: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_tl_rec.property_varchar2_value) || '"';

1477: if ((l_cust_region_item_tl_rec.property_varchar2_value IS NOT NULL) and
1478: (l_cust_region_item_tl_rec.property_varchar2_value <> FND_API.G_MISS_CHAR)) then
1479: l_index := l_index + 1;
1480: l_databuffer_tbl(l_index) := ' PROPERTY_VARCHAR2_VALUE_TL = "' ||
1481: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_cust_region_item_tl_rec.property_varchar2_value) || '"';
1482: end if;
1483:
1484: -- finish up customized region items
1485: l_index := l_index + 1;

Line 1491: AK_ON_OBJECTS_PVT.WRITE_FILE (

1487: -- l_index := l_index + 1;
1488: -- l_databuffer_tbl(l_index) := ' ';
1489:
1490: -- - Write the custom region item data to the specified file
1491: AK_ON_OBJECTS_PVT.WRITE_FILE (
1492: p_return_status => l_return_status,
1493: p_buffer_tbl => l_databuffer_tbl,
1494: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1495: );

Line 1607: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then

1603: p_value_number => l_criteria_rec.value_number,
1604: p_value_date => to_char(l_criteria_rec.value_date),
1605: p_start_date_active => l_criteria_rec.start_date_active,
1606: p_end_date_active => l_criteria_rec.end_date_active,
1607: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
1608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1609: close l_get_criteria_csr;
1610: FND_MESSAGE.SET_NAME('AK','AK_CRITERIA_NOT_DOWNLOADED');
1611: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_region_application_id) ||' '||

Line 1625: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.attribute_code) || '" ' ||

1621: l_databuffer_tbl(l_index) := ' ';
1622: l_index := l_index + 1;
1623: l_databuffer_tbl(l_index) := ' BEGIN CRITERIA "'||
1624: l_criteria_rec.attribute_application_id || '" "' ||
1625: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.attribute_code) || '" ' ||
1626: l_criteria_rec.sequence_number;
1627: l_index := l_index + 1;
1628: l_databuffer_tbl(l_index) := ' OPERATION = "'||
1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.operation) || '"';

Line 1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.operation) || '"';

1625: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.attribute_code) || '" ' ||
1626: l_criteria_rec.sequence_number;
1627: l_index := l_index + 1;
1628: l_databuffer_tbl(l_index) := ' OPERATION = "'||
1629: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.operation) || '"';
1630: if ((l_criteria_rec.value_varchar2 IS NOT NULL) and
1631: (l_criteria_rec.value_varchar2 <> FND_API.G_MISS_CHAR)) then
1632: l_index := l_index + 1;
1633: l_databuffer_tbl(l_index) := ' VALUE_VARCHAR2 = "' ||

Line 1634: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.value_varchar2) || '"';

1630: if ((l_criteria_rec.value_varchar2 IS NOT NULL) and
1631: (l_criteria_rec.value_varchar2 <> FND_API.G_MISS_CHAR)) then
1632: l_index := l_index + 1;
1633: l_databuffer_tbl(l_index) := ' VALUE_VARCHAR2 = "' ||
1634: AK_ON_OBJECTS_PVT.REPLACE_SPECIAL_CHAR(l_criteria_rec.value_varchar2) || '"';
1635: end if;
1636: if ((l_criteria_rec.value_number IS NOT NULL) and
1637: (l_criteria_rec.value_number <> FND_API.G_MISS_NUM)) then
1638: l_index := l_index + 1;

Line 1694: AK_ON_OBJECTS_PVT.WRITE_FILE (

1690: -- l_index := l_index + 1;
1691: -- l_databuffer_tbl(l_index) := ' ';
1692:
1693: -- - Write the custom criteria to the specified file
1694: AK_ON_OBJECTS_PVT.WRITE_FILE (
1695: p_return_status => l_return_status,
1696: p_buffer_tbl => l_databuffer_tbl,
1697: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1698: );

Line 1752: -- in package AK_ON_OBJECTS_PVT:

1748: -- validation tests are passed, or FALSE otherwise.
1749: -- Parameters Customization columns
1750: -- p_caller : IN required
1751: -- Must be one of the following values defined
1752: -- in package AK_ON_OBJECTS_PVT:
1753: -- - G_CREATE (if calling from the Create API)
1754: -- - G_DOWNLOAD (if calling from the Download API)
1755: -- - G_UPDATE (if calling from the Update API)
1756: --

Line 1856: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

1852: --** check that required columns are not null and, unless calling **
1853: --** from UPDATE procedure, the columns are not missing **
1854: if ((p_customization_level_id is null) or
1855: (p_customization_level_id = FND_API.G_MISS_NUM and
1856: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1857: l_error := TRUE;
1858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1859: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1860: FND_MESSAGE.SET_TOKEN('COLUMN', 'CUSTOMIZATION_LEVEL_ID');

Line 1867: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

1863: end if;
1864:
1865: if ((p_start_date_active is null) or
1866: (p_start_date_active = FND_API.G_MISS_DATE and
1867: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1868: l_error := TRUE;
1869: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1870: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1871: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');

Line 1878: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

1874: end if;
1875:
1876: if ((p_name is null) or
1877: (p_name = FND_API.G_MISS_CHAR and
1878: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
1879: l_error := TRUE;
1880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1881: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
1882: FND_MESSAGE.SET_TOKEN('COLUMN', 'NAME');

Line 1940: -- in package AK_ON_OBJECTS_PVT:

1936: -- validation tests are passed, or FALSE otherwise.
1937: -- Parameters Region graph columns
1938: -- p_caller : IN required
1939: -- Must be one of the following values defined
1940: -- in package AK_ON_OBJECTS_PVT:
1941: -- - G_CREATE (if calling from the Create API)
1942: -- - G_DOWNLOAD (if calling from the Download API)
1943: -- - G_UPDATE (if calling from the Update API)
1944: --

Line 2102: -- in package AK_ON_OBJECTS_PVT:

2098: -- validation tests are passed, or FALSE otherwise.
2099: -- Parameters Custom region item columns
2100: -- p_caller : IN required
2101: -- Must be one of the following values defined
2102: -- in package AK_ON_OBJECTS_PVT:
2103: -- - G_CREATE (if calling from the Create API)
2104: -- - G_DOWNLOAD (if calling from the Download API)
2105: -- - G_UPDATE (if calling from the Update API)
2106: --

Line 2285: -- in package AK_ON_OBJECTS_PVT:

2281: -- validation tests are passed, or FALSE otherwise.
2282: -- Parameters Criteria columns
2283: -- p_caller : IN required
2284: -- Must be one of the following values defined
2285: -- in package AK_ON_OBJECTS_PVT:
2286: -- - G_CREATE (if calling from the Create API)
2287: -- - G_DOWNLOAD (if calling from the Download API)
2288: -- - G_UPDATE (if calling from the Update API)
2289: --

Line 2414: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

2410: --** from UPDATE procedure, the columns are not missing **
2411:
2412: if ((p_start_date_active is null) or
2413: (p_start_date_active = FND_API.G_MISS_DATE and
2414: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2415: l_error := TRUE;
2416: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2417: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2418: FND_MESSAGE.SET_TOKEN('COLUMN', 'START_DATE_ACTIVE');

Line 2443: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then

2439: --** from UPDATE procedure, the columns are not missing **
2440:
2441: if ((p_operation is null) or
2442: (p_operation = FND_API.G_MISS_CHAR and
2443: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
2444: l_error := TRUE;
2445: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
2446: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
2447: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION');

Line 2610: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

2606: p_start_date_active => p_start_date_active,
2607: p_end_date_active => p_end_date_active,
2608: p_name => p_name,
2609: p_description => p_description,
2610: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
2611: p_pass => p_pass
2612: ) then
2613: -- Do not raise an error if it's the first pass
2614: if (p_pass = 1) then

Line 2689: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

2685: -- old jlt files didn't have who columns and IS_UPDATEABLE
2686: -- calls SET_WHO which populates those columns, for later
2687: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
2688:
2689: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
2690: p_loader_timestamp => p_loader_timestamp,
2691: p_created_by => l_created_by,
2692: p_creation_date => l_creation_date,
2693: p_last_updated_by => l_last_updated_by,

Line 2978: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

2974: p_property_varchar2_value => p_property_varchar2_value,
2975: p_property_number_value => p_property_number_value,
2976: p_criteria_join_condition => p_criteria_join_condition,
2977: p_property_varchar2_value_tl => p_property_varchar2_value,
2978: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
2979: p_pass => p_pass
2980: ) then
2981: -- Do not raise an error if it's the first pass
2982: if (p_pass = 1) then

Line 3029: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3025: -- old jlt files didn't have who columns and IS_UPDATEABLE
3026: -- calls SET_WHO which populates those columns, for later
3027: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
3028:
3029: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3030: p_loader_timestamp => p_loader_timestamp,
3031: p_created_by => l_created_by,
3032: p_creation_date => l_creation_date,
3033: p_last_updated_by => l_last_updated_by,

Line 3310: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

3306: p_property_varchar2_value => p_property_varchar2_value,
3307: p_property_number_value => p_property_number_value,
3308: p_property_date_value => p_property_date_value,
3309: p_property_varchar2_value_tl => p_property_varchar2_value_tl,
3310: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3311: p_pass => p_pass
3312: ) then
3313: -- Do not raise an error if it's the first pass
3314: if (p_pass = 1) then

Line 3361: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3357: -- old jlt files didn't have who columns and IS_UPDATEABLE
3358: -- calls SET_WHO which populates those columns, for later
3359: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
3360:
3361: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3362: p_loader_timestamp => p_loader_timestamp,
3363: p_created_by => l_created_by,
3364: p_creation_date => l_creation_date,
3365: p_last_updated_by => l_last_updated_by,

Line 3663: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,

3659: p_value_number => p_value_number,
3660: p_value_date => p_value_date,
3661: p_start_date_active => p_start_date_active,
3662: p_end_date_active => p_end_date_active,
3663: p_caller => AK_ON_OBJECTS_PVT.G_CREATE,
3664: p_pass => p_pass
3665: ) then
3666: -- Do not raise an error if it's the first pass
3667: if (p_pass = 1) then

Line 3718: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

3714: -- old jlt files didn't have who columns and IS_UPDATEABLE
3715: -- calls SET_WHO which populates those columns, for later
3716: -- jlt files IS_UPDATEABLE will always return TRUE for CREATE
3717:
3718: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
3719: p_loader_timestamp => p_loader_timestamp,
3720: p_created_by => l_created_by,
3721: p_creation_date => l_creation_date,
3722: p_last_updated_by => l_last_updated_by,

Line 4311: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

4307: p_start_date_active => p_start_date_active,
4308: p_end_date_active => p_end_date_active,
4309: p_name => p_name,
4310: p_description => p_description,
4311: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
4312: p_pass => p_pass
4313: ) then
4314: --dbms_output.put_line(l_api_name || ' validation failed');
4315: -- Do not raise an error if it's the first pass

Line 4413: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4409: end if;
4410:
4411: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
4412: -- NECESSARY FOR PRE-12 CODE
4413: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4414: p_loader_timestamp => p_loader_timestamp,
4415: p_created_by => l_created_by,
4416: p_creation_date => l_creation_date,
4417: p_last_updated_by => l_last_updated_by,

Line 4697: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

4693: p_property_varchar2_value => p_property_varchar2_value,
4694: p_property_number_value => p_property_number_value,
4695: p_criteria_join_condition => p_criteria_join_condition,
4696: p_property_varchar2_value_tl => p_property_varchar2_value_tl,
4697: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
4698: p_pass => p_pass
4699: ) then
4700: --dbms_output.put_line(l_api_name || ' validation failed');
4701: -- Do not raise an error if it's the first pass

Line 4757: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

4753: --** - next, load non-null columns **
4754:
4755: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
4756: -- NECESSARY FOR PRE-12 CODE
4757: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
4758: p_loader_timestamp => p_loader_timestamp,
4759: p_created_by => l_created_by,
4760: p_creation_date => l_creation_date,
4761: p_last_updated_by => l_last_updated_by,

Line 5020: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5016: p_property_varchar2_value => p_property_varchar2_value,
5017: p_property_number_value => p_property_number_value,
5018: p_property_date_value => p_property_date_value,
5019: p_property_varchar2_value_tl => p_property_varchar2_value_tl,
5020: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5021: p_pass => p_pass
5022: ) then
5023: --dbms_output.put_line(l_api_name || ' validation failed');
5024: -- Do not raise an error if it's the first pass

Line 5080: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5076: --** - next, load non-null columns **
5077:
5078: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
5079: -- NECESSARY FOR PRE-12 CODE
5080: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5081: p_loader_timestamp => p_loader_timestamp,
5082: p_created_by => l_created_by,
5083: p_creation_date => l_creation_date,
5084: p_last_updated_by => l_last_updated_by,

Line 5320: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,

5316: p_value_number => p_value_number,
5317: p_value_date => p_value_date,
5318: p_start_date_Active => p_start_date_active,
5319: p_end_date_active => p_end_date_active,
5320: p_caller => AK_ON_OBJECTS_PVT.G_UPDATE,
5321: p_pass => p_pass
5322: ) then
5323: --dbms_output.put_line(l_api_name || ' validation failed');
5324: -- Do not raise an error if it's the first pass

Line 5388: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

5384: end if;
5385:
5386: -- THIS UPDATES NO MATTER WHAT - CALLING IS_UPDATEABLE BECAUSE STILL
5387: -- NECESSARY FOR PRE-12 CODE
5388: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
5389: p_loader_timestamp => p_loader_timestamp,
5390: p_created_by => l_created_by,
5391: p_creation_date => l_creation_date,
5392: p_last_updated_by => l_last_updated_by,