[Home] [Help]
54: END IF;
55:
56:
57: -- Debug Message
58: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
59:
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: /* IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
114: THEN
115: -- Debug message
116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');
117:
118: -- Invoke validation procedures
119: Validate_material_transactions(
120: p_init_msg_list => FND_API.G_FALSE,
118: -- Invoke validation procedures
119: Validate_material_transactions(
120: p_init_msg_list => FND_API.G_FALSE,
121: p_validation_level => p_validation_level,
122: p_validation_mode => JTF_PLSQL_API.G_CREATE,
123: P_CSP_Rec => P_CSP_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);
132: */
133: -- Hint: Add corresponding Master-Detail business logic here if necessary.
134:
135: -- Debug Message
136: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137:
138: -- assign p_CSP_rec.transaction_temp_id to x_transaction_temp_id
139: x_TRANSACTION_TEMP_ID := p_CSP_rec.TRANSACTION_TEMP_ID;
140:
349: END IF;
350:
351:
352: -- Debug Message
353: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
354:
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get
377: END IF;
378: */
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
385: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
381: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
385: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
395: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
391: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
395: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
396: ,X_MSG_COUNT => X_MSG_COUNT
397: ,X_MSG_DATA => X_MSG_DATA
398: ,X_RETURN_STATUS => X_RETURN_STATUS);
399:
397: ,X_MSG_DATA => X_MSG_DATA
398: ,X_RETURN_STATUS => X_RETURN_STATUS);
399:
400: WHEN OTHERS THEN
401: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
400: WHEN OTHERS THEN
401: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);
401: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);
409: End Create_material_transactions;
643: END IF;
644:
645:
646: -- Debug Message
647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
648:
649:
650: -- Initialize API return status to SUCCESS
651: x_return_status := FND_API.G_RET_STS_SUCCESS;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686: */
687: -- Debug Message
688: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
689:
690: /*
691: Open C_Get_material_transactions( l_tar_CSP_rec.TRANSACTION_HEADER_ID);
692:
888: END IF;
889: raise FND_API.G_EXC_ERROR;
890: END IF;
891: -- Debug Message
892: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
893: Close C_Get_material_transactions;
894: */
895:
896:
918:
919: /* IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
920: THEN
921: -- Debug message
922: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_material_transactions');
923:
924: -- Invoke validation procedures
925: Validate_material_transactions(
926: p_init_msg_list => FND_API.G_FALSE,
924: -- Invoke validation procedures
925: Validate_material_transactions(
926: p_init_msg_list => FND_API.G_FALSE,
927: p_validation_level => p_validation_level,
928: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
929: P_CSP_Rec => P_CSP_Rec,
930: x_return_status => x_return_status,
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data);
938: */
939: -- Hint: Add corresponding Master-Detail business logic here if necessary.
940:
941: -- Debug Message
942: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
943:
944: -- Invoke table handler(MTL_MATERIAL_TRANSACTIONS_TEMP_PKG.Update_Row)
945: CSP_MTL_TRANSACTIONS_PKG.Update_Row(
946: p_TRANSACTION_HEADER_ID => p_CSP_rec.TRANSACTION_HEADER_ID,
1145: END IF;
1146:
1147:
1148: -- Debug Message
1149: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1150:
1151:
1152: -- Standard call to get message count and if count is 1, get message info.
1153: FND_MSG_PUB.Count_And_Get
1174: END IF;
1175: */
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1179: P_API_NAME => L_API_NAME
1180: ,P_PKG_NAME => G_PKG_NAME
1181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1182: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1178: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1179: P_API_NAME => L_API_NAME
1180: ,P_PKG_NAME => G_PKG_NAME
1181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1182: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1183: ,X_MSG_COUNT => X_MSG_COUNT
1184: ,X_MSG_DATA => X_MSG_DATA
1185: ,X_RETURN_STATUS => X_RETURN_STATUS);
1186:
1184: ,X_MSG_DATA => X_MSG_DATA
1185: ,X_RETURN_STATUS => X_RETURN_STATUS);
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME
1190: ,P_PKG_NAME => G_PKG_NAME
1191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1192: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1188: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1189: P_API_NAME => L_API_NAME
1190: ,P_PKG_NAME => G_PKG_NAME
1191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1192: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1193: ,X_MSG_COUNT => X_MSG_COUNT
1194: ,X_MSG_DATA => X_MSG_DATA
1195: ,X_RETURN_STATUS => X_RETURN_STATUS);
1196:
1194: ,X_MSG_DATA => X_MSG_DATA
1195: ,X_RETURN_STATUS => X_RETURN_STATUS);
1196:
1197: WHEN OTHERS THEN
1198: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1197: WHEN OTHERS THEN
1198: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1203: ,X_MSG_COUNT => X_MSG_COUNT
1204: ,X_MSG_DATA => X_MSG_DATA
1205: ,X_RETURN_STATUS => X_RETURN_STATUS);
1198: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1203: ,X_MSG_COUNT => X_MSG_COUNT
1204: ,X_MSG_DATA => X_MSG_DATA
1205: ,X_RETURN_STATUS => X_RETURN_STATUS);
1206: End Update_material_transactions;
1248:
1249: --dbms_output.put_line('in CSP MATERIAL');
1250:
1251: -- Debug Message
1252: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1253:
1254:
1255: -- Initialize API return status to SUCCESS
1256: x_return_status := FND_API.G_RET_STS_SUCCESS;
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291: */
1292: -- Debug Message
1293: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
1294:
1295: -- Invoke table handler(MTL_MATERIAL_TRANSACTIONS_TEMP_PKG.Delete_Row)
1296:
1297: CSP_MTL_TRANSACTIONS_PKG.Delete_Row(
1304: END IF;
1305:
1306:
1307: -- Debug Message
1308: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1309:
1310:
1311: -- Standard call to get message count and if count is 1, get message info.
1312: FND_MSG_PUB.Count_And_Get
1333: END IF;
1334: */
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1342: ,X_MSG_COUNT => X_MSG_COUNT
1343: ,X_MSG_DATA => X_MSG_DATA
1344: ,X_RETURN_STATUS => X_RETURN_STATUS);
1345:
1343: ,X_MSG_DATA => X_MSG_DATA
1344: ,X_RETURN_STATUS => X_RETURN_STATUS);
1345:
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1348: P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1348: P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1352: ,X_MSG_COUNT => X_MSG_COUNT
1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);
1355:
1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);
1355:
1356: WHEN OTHERS THEN
1357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1358: P_API_NAME => L_API_NAME
1359: ,P_PKG_NAME => G_PKG_NAME
1360: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1356: WHEN OTHERS THEN
1357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1358: P_API_NAME => L_API_NAME
1359: ,P_PKG_NAME => G_PKG_NAME
1360: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1362: ,X_MSG_COUNT => X_MSG_COUNT
1363: ,X_MSG_DATA => X_MSG_DATA
1364: ,X_RETURN_STATUS => X_RETURN_STATUS);
1357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1358: P_API_NAME => L_API_NAME
1359: ,P_PKG_NAME => G_PKG_NAME
1360: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1362: ,X_MSG_COUNT => X_MSG_COUNT
1363: ,X_MSG_DATA => X_MSG_DATA
1364: ,X_RETURN_STATUS => X_RETURN_STATUS);
1365: End Delete_material_transactions;
1372: )
1373: IS
1374: BEGIN
1375: -- Debug Message
1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
1377:
1378: -- define all columns for CSP_MATERIAL_TRANSACTIONS_V view
1379: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.TRANSACTION_HEADER_ID);
1380: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.TRANSACTION_TEMP_ID);
1555: dbms_sql.define_column(p_cur_get_CSP, 177, P_CSP_Rec.RESERVATION_ID);
1556: dbms_sql.define_column(p_cur_get_CSP, 178, P_CSP_Rec.TRANSACTION_STATUS);
1557:
1558: -- Debug Message
1559: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
1560: END Define_Columns;
1561:
1562: -- This procudure gets column values by the Dynamic SQL.
1563: PROCEDURE Get_Column_Values(
1566: )
1567: IS
1568: BEGIN
1569: -- Debug Message
1570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
1571:
1572: -- get all column values for CSP_MATERIAL_TRANSACTIONS_V table
1573: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.TRANSACTION_HEADER_ID);
1574: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.TRANSACTION_TEMP_ID);
1749: dbms_sql.column_value(p_cur_get_CSP, 177, X_CSP_Rec.RESERVATION_ID);
1750: dbms_sql.column_value(p_cur_get_CSP, 178, X_CSP_Rec.TRANSACTION_STATUS);
1751:
1752: -- Debug Message
1753: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
1754: END Get_Column_Values;
1755:
1756: PROCEDURE Gen_CSP_order_cl(
1757: p_order_by_rec IN CSP_MATERIAL_TRANSACTIONS_PUB.CSP_sort_rec_type,
1761: x_msg_data OUT NOCOPY VARCHAR2
1762: )
1763: IS
1764: l_order_by_cl VARCHAR2(1000) := NULL;
1765: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
1766: BEGIN
1767: -- Debug Message
1768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
1769:
1764: l_order_by_cl VARCHAR2(1000) := NULL;
1765: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
1766: BEGIN
1767: -- Debug Message
1768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
1769:
1770: -- Hint: Developer should add more statements according to CSP_sort_rec_type
1771: -- Ex:
1772: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1772: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1773: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
1774:
1775: -- Debug Message
1776: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1777:
1778: JTF_PLSQL_API.Translate_OrderBy(
1779: p_api_version_number => 1.0
1780: ,p_init_msg_list => FND_API.G_FALSE
1774:
1775: -- Debug Message
1776: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1777:
1778: JTF_PLSQL_API.Translate_OrderBy(
1779: p_api_version_number => 1.0
1780: ,p_init_msg_list => FND_API.G_FALSE
1781: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1782: ,p_order_by_tbl => l_util_order_by_tbl
1791: x_order_by_cl := NULL;
1792: END IF;
1793:
1794: -- Debug Message
1795: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');
1796: END Gen_CSP_order_cl;
1797:
1798: -- This procedure bind the variables for the Dynamic SQL
1799: PROCEDURE Bind(
1805: BEGIN
1806: -- Bind variables
1807: -- Only those that are not NULL
1808: -- Debug Message
1809: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
1810:
1811: -- The following example applies to all columns,
1812: -- developers can copy and paste them.
1813: IF( (P_CSP_Rec.TRANSACTION_HEADER_ID IS NOT NULL) AND (P_CSP_Rec.TRANSACTION_HEADER_ID <> FND_API.G_MISS_NUM) )
1815: DBMS_SQL.BIND_VARIABLE(p_cur_get_CSP, ':p_TRANSACTION_HEADER_ID', P_CSP_Rec.TRANSACTION_HEADER_ID);
1816: END IF;
1817:
1818: -- Debug Message
1819: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
1820: END Bind;
1821:
1822: PROCEDURE Gen_Select(
1823: x_select_cl OUT NOCOPY VARCHAR2
1824: )
1825: IS
1826: BEGIN
1827: -- Debug Message
1828: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
1829:
1830: x_select_cl := 'Select ' ||
1831: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_HEADER_ID,' ||
1832: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_TEMP_ID,' ||
2015: 'CSP_MATERIAL_TRANSACTIONS_V.RESERVATION_ID,' ||
2016: 'CSP_MATERIAL_TRANSACTIONS_V.TRANSACTION_STATUS,' ||
2017: 'from CSP_MATERIAL_TRANSACTIONS_V';
2018: -- Debug Message
2019: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
2020:
2021: END Gen_Select;
2022:
2023: PROCEDURE Gen_CSP_Where(
2039: str_csr2 NUMBER;
2040: l_operator VARCHAR2(10);
2041: BEGIN
2042: -- Debug Message
2043: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
2044:
2045: -- There are three examples for each kind of datatype:
2046: -- NUMBER, DATE, VARCHAR2.
2047: -- Developer can copy and paste the following codes for your own record.
2125:
2126: -- Add more IF statements for each column below
2127:
2128: -- Debug Message
2129: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
2130:
2131: END Gen_CSP_Where;
2132:
2133: -- Item-level validation procedures
2134: PROCEDURE Validate_TRANSACTION_HEADER_ID (
2135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2136: P_Validation_mode IN VARCHAR2,
2137: P_TRANSACTION_HEADER_ID IN NUMBER,
2138: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2139: X_Return_Status OUT NOCOPY VARCHAR2,
2140: X_Msg_Count OUT NOCOPY NUMBER,
2141: X_Msg_Data OUT NOCOPY VARCHAR2
2142: )
2152:
2153: -- Initialize API return status to SUCCESS
2154: x_return_status := FND_API.G_RET_STS_SUCCESS;
2155:
2156: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2157: THEN
2158: -- Hint: Validate data
2159: -- IF p_TRANSACTION_HEADER_ID is not NULL and p_TRANSACTION_HEADER_ID <> G_MISS_CHAR
2160: -- verify if data is valid
2159: -- IF p_TRANSACTION_HEADER_ID is not NULL and p_TRANSACTION_HEADER_ID <> G_MISS_CHAR
2160: -- verify if data is valid
2161: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2162: NULL;
2163: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2164: THEN
2165: -- Hint: Validate data
2166: -- IF p_TRANSACTION_HEADER_ID <> G_MISS_CHAR
2167: -- verify if data is valid
2181: PROCEDURE Validate_TRANSACTION_TEMP_ID (
2182: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2183: P_Validation_mode IN VARCHAR2,
2184: P_TRANSACTION_TEMP_ID IN NUMBER,
2185: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2186: X_Return_Status OUT NOCOPY VARCHAR2,
2187: X_Msg_Count OUT NOCOPY NUMBER,
2188: X_Msg_Data OUT NOCOPY VARCHAR2
2189: )
2199:
2200: -- Initialize API return status to SUCCESS
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2204: THEN
2205: -- Hint: Validate data
2206: -- IF p_TRANSACTION_TEMP_ID is not NULL and p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
2207: -- verify if data is valid
2206: -- IF p_TRANSACTION_TEMP_ID is not NULL and p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
2207: -- verify if data is valid
2208: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2209: NULL;
2210: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2211: THEN
2212: -- Hint: Validate data
2213: -- IF p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
2214: -- verify if data is valid
2228: PROCEDURE Validate_SOURCE_CODE (
2229: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2230: P_Validation_mode IN VARCHAR2,
2231: P_SOURCE_CODE IN VARCHAR2,
2232: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2233: X_Return_Status OUT NOCOPY VARCHAR2,
2234: X_Msg_Count OUT NOCOPY NUMBER,
2235: X_Msg_Data OUT NOCOPY VARCHAR2
2236: )
2246:
2247: -- Initialize API return status to SUCCESS
2248: x_return_status := FND_API.G_RET_STS_SUCCESS;
2249:
2250: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2251: THEN
2252: -- Hint: Validate data
2253: -- IF p_SOURCE_CODE is not NULL and p_SOURCE_CODE <> G_MISS_CHAR
2254: -- verify if data is valid
2253: -- IF p_SOURCE_CODE is not NULL and p_SOURCE_CODE <> G_MISS_CHAR
2254: -- verify if data is valid
2255: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2256: NULL;
2257: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2258: THEN
2259: -- Hint: Validate data
2260: -- IF p_SOURCE_CODE <> G_MISS_CHAR
2261: -- verify if data is valid
2275: PROCEDURE Validate_SOURCE_LINE_ID (
2276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2277: P_Validation_mode IN VARCHAR2,
2278: P_SOURCE_LINE_ID IN NUMBER,
2279: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2280: X_Return_Status OUT NOCOPY VARCHAR2,
2281: X_Msg_Count OUT NOCOPY NUMBER,
2282: X_Msg_Data OUT NOCOPY VARCHAR2
2283: )
2293:
2294: -- Initialize API return status to SUCCESS
2295: x_return_status := FND_API.G_RET_STS_SUCCESS;
2296:
2297: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2298: THEN
2299: -- Hint: Validate data
2300: -- IF p_SOURCE_LINE_ID is not NULL and p_SOURCE_LINE_ID <> G_MISS_CHAR
2301: -- verify if data is valid
2300: -- IF p_SOURCE_LINE_ID is not NULL and p_SOURCE_LINE_ID <> G_MISS_CHAR
2301: -- verify if data is valid
2302: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2303: NULL;
2304: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2305: THEN
2306: -- Hint: Validate data
2307: -- IF p_SOURCE_LINE_ID <> G_MISS_CHAR
2308: -- verify if data is valid
2322: PROCEDURE Validate_TRANSACTION_MODE (
2323: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2324: P_Validation_mode IN VARCHAR2,
2325: P_TRANSACTION_MODE IN NUMBER,
2326: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2327: X_Return_Status OUT NOCOPY VARCHAR2,
2328: X_Msg_Count OUT NOCOPY NUMBER,
2329: X_Msg_Data OUT NOCOPY VARCHAR2
2330: )
2340:
2341: -- Initialize API return status to SUCCESS
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;
2343:
2344: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2345: THEN
2346: -- Hint: Validate data
2347: -- IF p_TRANSACTION_MODE is not NULL and p_TRANSACTION_MODE <> G_MISS_CHAR
2348: -- verify if data is valid
2347: -- IF p_TRANSACTION_MODE is not NULL and p_TRANSACTION_MODE <> G_MISS_CHAR
2348: -- verify if data is valid
2349: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2350: NULL;
2351: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2352: THEN
2353: -- Hint: Validate data
2354: -- IF p_TRANSACTION_MODE <> G_MISS_CHAR
2355: -- verify if data is valid
2369: PROCEDURE Validate_LOCK_FLAG (
2370: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2371: P_Validation_mode IN VARCHAR2,
2372: P_LOCK_FLAG IN VARCHAR2,
2373: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2374: X_Return_Status OUT NOCOPY VARCHAR2,
2375: X_Msg_Count OUT NOCOPY NUMBER,
2376: X_Msg_Data OUT NOCOPY VARCHAR2
2377: )
2387:
2388: -- Initialize API return status to SUCCESS
2389: x_return_status := FND_API.G_RET_STS_SUCCESS;
2390:
2391: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2392: THEN
2393: -- Hint: Validate data
2394: -- IF p_LOCK_FLAG is not NULL and p_LOCK_FLAG <> G_MISS_CHAR
2395: -- verify if data is valid
2394: -- IF p_LOCK_FLAG is not NULL and p_LOCK_FLAG <> G_MISS_CHAR
2395: -- verify if data is valid
2396: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2397: NULL;
2398: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2399: THEN
2400: -- Hint: Validate data
2401: -- IF p_LOCK_FLAG <> G_MISS_CHAR
2402: -- verify if data is valid
2416: PROCEDURE Validate_REQUEST_ID (
2417: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2418: P_Validation_mode IN VARCHAR2,
2419: P_REQUEST_ID IN NUMBER,
2420: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2421: X_Return_Status OUT NOCOPY VARCHAR2,
2422: X_Msg_Count OUT NOCOPY NUMBER,
2423: X_Msg_Data OUT NOCOPY VARCHAR2
2424: )
2434:
2435: -- Initialize API return status to SUCCESS
2436: x_return_status := FND_API.G_RET_STS_SUCCESS;
2437:
2438: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2439: THEN
2440: -- Hint: Validate data
2441: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
2442: -- verify if data is valid
2441: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
2442: -- verify if data is valid
2443: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2444: NULL;
2445: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2446: THEN
2447: -- Hint: Validate data
2448: -- IF p_REQUEST_ID <> G_MISS_CHAR
2449: -- verify if data is valid
2463: PROCEDURE Validate_INVENTORY_ITEM_ID (
2464: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2465: P_Validation_mode IN VARCHAR2,
2466: P_INVENTORY_ITEM_ID IN NUMBER,
2467: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2468: X_Return_Status OUT NOCOPY VARCHAR2,
2469: X_Msg_Count OUT NOCOPY NUMBER,
2470: X_Msg_Data OUT NOCOPY VARCHAR2
2471: )
2484:
2485: -- validate NOT NULL column
2486: IF(p_INVENTORY_ITEM_ID is NULL)
2487: THEN
2488: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
2489: x_return_status := FND_API.G_RET_STS_ERROR;
2490: END IF;
2491:
2492: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2488: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
2489: x_return_status := FND_API.G_RET_STS_ERROR;
2490: END IF;
2491:
2492: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2493: THEN
2494: -- Hint: Validate data
2495: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
2496: -- verify if data is valid
2495: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
2496: -- verify if data is valid
2497: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2498: NULL;
2499: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2500: THEN
2501: -- Hint: Validate data
2502: -- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
2503: -- verify if data is valid
2517: PROCEDURE Validate_REVISION (
2518: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2519: P_Validation_mode IN VARCHAR2,
2520: P_REVISION IN VARCHAR2,
2521: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2522: X_Return_Status OUT NOCOPY VARCHAR2,
2523: X_Msg_Count OUT NOCOPY NUMBER,
2524: X_Msg_Data OUT NOCOPY VARCHAR2
2525: )
2535:
2536: -- Initialize API return status to SUCCESS
2537: x_return_status := FND_API.G_RET_STS_SUCCESS;
2538:
2539: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2540: THEN
2541: -- Hint: Validate data
2542: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
2543: -- verify if data is valid
2542: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
2543: -- verify if data is valid
2544: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2545: NULL;
2546: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2547: THEN
2548: -- Hint: Validate data
2549: -- IF p_REVISION <> G_MISS_CHAR
2550: -- verify if data is valid
2564: PROCEDURE Validate_ORGANIZATION_ID (
2565: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2566: P_Validation_mode IN VARCHAR2,
2567: P_ORGANIZATION_ID IN NUMBER,
2568: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2569: X_Return_Status OUT NOCOPY VARCHAR2,
2570: X_Msg_Count OUT NOCOPY NUMBER,
2571: X_Msg_Data OUT NOCOPY VARCHAR2
2572: )
2585:
2586: -- validate NOT NULL column
2587: IF(p_ORGANIZATION_ID is NULL)
2588: THEN
2589: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
2590: x_return_status := FND_API.G_RET_STS_ERROR;
2591: END IF;
2592:
2593: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2589: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
2590: x_return_status := FND_API.G_RET_STS_ERROR;
2591: END IF;
2592:
2593: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2594: THEN
2595: -- Hint: Validate data
2596: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
2597: -- verify if data is valid
2596: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
2597: -- verify if data is valid
2598: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2599: NULL;
2600: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2601: THEN
2602: -- Hint: Validate data
2603: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
2604: -- verify if data is valid
2618: PROCEDURE Validate_SUBINVENTORY_CODE (
2619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2620: P_Validation_mode IN VARCHAR2,
2621: P_SUBINVENTORY_CODE IN VARCHAR2,
2622: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2623: X_Return_Status OUT NOCOPY VARCHAR2,
2624: X_Msg_Count OUT NOCOPY NUMBER,
2625: X_Msg_Data OUT NOCOPY VARCHAR2
2626: )
2636:
2637: -- Initialize API return status to SUCCESS
2638: x_return_status := FND_API.G_RET_STS_SUCCESS;
2639:
2640: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2641: THEN
2642: -- Hint: Validate data
2643: -- IF p_SUBINVENTORY_CODE is not NULL and p_SUBINVENTORY_CODE <> G_MISS_CHAR
2644: -- verify if data is valid
2643: -- IF p_SUBINVENTORY_CODE is not NULL and p_SUBINVENTORY_CODE <> G_MISS_CHAR
2644: -- verify if data is valid
2645: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2646: NULL;
2647: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2648: THEN
2649: -- Hint: Validate data
2650: -- IF p_SUBINVENTORY_CODE <> G_MISS_CHAR
2651: -- verify if data is valid
2665: PROCEDURE Validate_LOCATOR_ID (
2666: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2667: P_Validation_mode IN VARCHAR2,
2668: P_LOCATOR_ID IN NUMBER,
2669: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2670: X_Return_Status OUT NOCOPY VARCHAR2,
2671: X_Msg_Count OUT NOCOPY NUMBER,
2672: X_Msg_Data OUT NOCOPY VARCHAR2
2673: )
2683:
2684: -- Initialize API return status to SUCCESS
2685: x_return_status := FND_API.G_RET_STS_SUCCESS;
2686:
2687: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2688: THEN
2689: -- Hint: Validate data
2690: -- IF p_LOCATOR_ID is not NULL and p_LOCATOR_ID <> G_MISS_CHAR
2691: -- verify if data is valid
2690: -- IF p_LOCATOR_ID is not NULL and p_LOCATOR_ID <> G_MISS_CHAR
2691: -- verify if data is valid
2692: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2693: NULL;
2694: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2695: THEN
2696: -- Hint: Validate data
2697: -- IF p_LOCATOR_ID <> G_MISS_CHAR
2698: -- verify if data is valid
2712: PROCEDURE Validate_TRANSACTION_QUANTITY (
2713: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2714: P_Validation_mode IN VARCHAR2,
2715: P_TRANSACTION_QUANTITY IN NUMBER,
2716: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2717: X_Return_Status OUT NOCOPY VARCHAR2,
2718: X_Msg_Count OUT NOCOPY NUMBER,
2719: X_Msg_Data OUT NOCOPY VARCHAR2
2720: )
2733:
2734: -- validate NOT NULL column
2735: IF(p_TRANSACTION_QUANTITY is NULL)
2736: THEN
2737: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_QUANTITY)');
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: END IF;
2740:
2741: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2737: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_QUANTITY)');
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: END IF;
2740:
2741: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2742: THEN
2743: -- Hint: Validate data
2744: -- IF p_TRANSACTION_QUANTITY is not NULL and p_TRANSACTION_QUANTITY <> G_MISS_CHAR
2745: -- verify if data is valid
2744: -- IF p_TRANSACTION_QUANTITY is not NULL and p_TRANSACTION_QUANTITY <> G_MISS_CHAR
2745: -- verify if data is valid
2746: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2747: NULL;
2748: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2749: THEN
2750: -- Hint: Validate data
2751: -- IF p_TRANSACTION_QUANTITY <> G_MISS_CHAR
2752: -- verify if data is valid
2766: PROCEDURE Validate_PRIMARY_QUANTITY (
2767: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2768: P_Validation_mode IN VARCHAR2,
2769: P_PRIMARY_QUANTITY IN NUMBER,
2770: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2771: X_Return_Status OUT NOCOPY VARCHAR2,
2772: X_Msg_Count OUT NOCOPY NUMBER,
2773: X_Msg_Data OUT NOCOPY VARCHAR2
2774: )
2787:
2788: -- validate NOT NULL column
2789: IF(p_PRIMARY_QUANTITY is NULL)
2790: THEN
2791: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(PRIMARY_QUANTITY)');
2792: x_return_status := FND_API.G_RET_STS_ERROR;
2793: END IF;
2794:
2795: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2791: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(PRIMARY_QUANTITY)');
2792: x_return_status := FND_API.G_RET_STS_ERROR;
2793: END IF;
2794:
2795: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2796: THEN
2797: -- Hint: Validate data
2798: -- IF p_PRIMARY_QUANTITY is not NULL and p_PRIMARY_QUANTITY <> G_MISS_CHAR
2799: -- verify if data is valid
2798: -- IF p_PRIMARY_QUANTITY is not NULL and p_PRIMARY_QUANTITY <> G_MISS_CHAR
2799: -- verify if data is valid
2800: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2801: NULL;
2802: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2803: THEN
2804: -- Hint: Validate data
2805: -- IF p_PRIMARY_QUANTITY <> G_MISS_CHAR
2806: -- verify if data is valid
2820: PROCEDURE Validate_TRANSACTION_UOM (
2821: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2822: P_Validation_mode IN VARCHAR2,
2823: P_TRANSACTION_UOM IN VARCHAR2,
2824: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2825: X_Return_Status OUT NOCOPY VARCHAR2,
2826: X_Msg_Count OUT NOCOPY NUMBER,
2827: X_Msg_Data OUT NOCOPY VARCHAR2
2828: )
2841:
2842: -- validate NOT NULL column
2843: IF(p_TRANSACTION_UOM is NULL)
2844: THEN
2845: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_UOM)');
2846: x_return_status := FND_API.G_RET_STS_ERROR;
2847: END IF;
2848:
2849: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2845: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_UOM)');
2846: x_return_status := FND_API.G_RET_STS_ERROR;
2847: END IF;
2848:
2849: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2850: THEN
2851: -- Hint: Validate data
2852: -- IF p_TRANSACTION_UOM is not NULL and p_TRANSACTION_UOM <> G_MISS_CHAR
2853: -- verify if data is valid
2852: -- IF p_TRANSACTION_UOM is not NULL and p_TRANSACTION_UOM <> G_MISS_CHAR
2853: -- verify if data is valid
2854: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2855: NULL;
2856: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2857: THEN
2858: -- Hint: Validate data
2859: -- IF p_TRANSACTION_UOM <> G_MISS_CHAR
2860: -- verify if data is valid
2874: PROCEDURE Validate_TRANSACTION_COST (
2875: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2876: P_Validation_mode IN VARCHAR2,
2877: P_TRANSACTION_COST IN NUMBER,
2878: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2879: X_Return_Status OUT NOCOPY VARCHAR2,
2880: X_Msg_Count OUT NOCOPY NUMBER,
2881: X_Msg_Data OUT NOCOPY VARCHAR2
2882: )
2892:
2893: -- Initialize API return status to SUCCESS
2894: x_return_status := FND_API.G_RET_STS_SUCCESS;
2895:
2896: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2897: THEN
2898: -- Hint: Validate data
2899: -- IF p_TRANSACTION_COST is not NULL and p_TRANSACTION_COST <> G_MISS_CHAR
2900: -- verify if data is valid
2899: -- IF p_TRANSACTION_COST is not NULL and p_TRANSACTION_COST <> G_MISS_CHAR
2900: -- verify if data is valid
2901: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2902: NULL;
2903: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2904: THEN
2905: -- Hint: Validate data
2906: -- IF p_TRANSACTION_COST <> G_MISS_CHAR
2907: -- verify if data is valid
2921: PROCEDURE Validate_TRANSACTION_TYPE_ID (
2922: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2923: P_Validation_mode IN VARCHAR2,
2924: P_TRANSACTION_TYPE_ID IN NUMBER,
2925: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2926: X_Return_Status OUT NOCOPY VARCHAR2,
2927: X_Msg_Count OUT NOCOPY NUMBER,
2928: X_Msg_Data OUT NOCOPY VARCHAR2
2929: )
2942:
2943: -- validate NOT NULL column
2944: IF(p_TRANSACTION_TYPE_ID is NULL)
2945: THEN
2946: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_TYPE_ID)');
2947: x_return_status := FND_API.G_RET_STS_ERROR;
2948: END IF;
2949:
2950: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2946: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_TYPE_ID)');
2947: x_return_status := FND_API.G_RET_STS_ERROR;
2948: END IF;
2949:
2950: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2951: THEN
2952: -- Hint: Validate data
2953: -- IF p_TRANSACTION_TYPE_ID is not NULL and p_TRANSACTION_TYPE_ID <> G_MISS_CHAR
2954: -- verify if data is valid
2953: -- IF p_TRANSACTION_TYPE_ID is not NULL and p_TRANSACTION_TYPE_ID <> G_MISS_CHAR
2954: -- verify if data is valid
2955: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2956: NULL;
2957: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2958: THEN
2959: -- Hint: Validate data
2960: -- IF p_TRANSACTION_TYPE_ID <> G_MISS_CHAR
2961: -- verify if data is valid
2975: PROCEDURE Validate_TRANSACTION_ACTION_ID (
2976: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2977: P_Validation_mode IN VARCHAR2,
2978: P_TRANSACTION_ACTION_ID IN NUMBER,
2979: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2980: X_Return_Status OUT NOCOPY VARCHAR2,
2981: X_Msg_Count OUT NOCOPY NUMBER,
2982: X_Msg_Data OUT NOCOPY VARCHAR2
2983: )
2996:
2997: -- validate NOT NULL column
2998: IF(p_TRANSACTION_ACTION_ID is NULL)
2999: THEN
3000: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_ACTION_ID)');
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: END IF;
3003:
3004: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3000: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_ACTION_ID)');
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3002: END IF;
3003:
3004: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3005: THEN
3006: -- Hint: Validate data
3007: -- IF p_TRANSACTION_ACTION_ID is not NULL and p_TRANSACTION_ACTION_ID <> G_MISS_CHAR
3008: -- verify if data is valid
3007: -- IF p_TRANSACTION_ACTION_ID is not NULL and p_TRANSACTION_ACTION_ID <> G_MISS_CHAR
3008: -- verify if data is valid
3009: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3010: NULL;
3011: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3012: THEN
3013: -- Hint: Validate data
3014: -- IF p_TRANSACTION_ACTION_ID <> G_MISS_CHAR
3015: -- verify if data is valid
3029: PROCEDURE Validate_TRANSACTION_SOURCE_TYPE_ID (
3030: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3031: P_Validation_mode IN VARCHAR2,
3032: P_TRANSACTION_SOURCE_TYPE_ID IN NUMBER,
3033: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3034: X_Return_Status OUT NOCOPY VARCHAR2,
3035: X_Msg_Count OUT NOCOPY NUMBER,
3036: X_Msg_Data OUT NOCOPY VARCHAR2
3037: )
3050:
3051: -- validate NOT NULL column
3052: IF(p_TRANSACTION_SOURCE_TYPE_ID is NULL)
3053: THEN
3054: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_SOURCE_TYPE_ID)');
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: END IF;
3057:
3058: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3054: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_SOURCE_TYPE_ID)');
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: END IF;
3057:
3058: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3059: THEN
3060: -- Hint: Validate data
3061: -- IF p_TRANSACTION_SOURCE_TYPE_ID is not NULL and p_TRANSACTION_SOURCE_TYPE_ID <> G_MISS_CHAR
3062: -- verify if data is valid
3061: -- IF p_TRANSACTION_SOURCE_TYPE_ID is not NULL and p_TRANSACTION_SOURCE_TYPE_ID <> G_MISS_CHAR
3062: -- verify if data is valid
3063: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3064: NULL;
3065: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3066: THEN
3067: -- Hint: Validate data
3068: -- IF p_TRANSACTION_SOURCE_TYPE_ID <> G_MISS_CHAR
3069: -- verify if data is valid
3083: PROCEDURE Validate_TRANSACTION_SOURCE_ID (
3084: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3085: P_Validation_mode IN VARCHAR2,
3086: P_TRANSACTION_SOURCE_ID IN NUMBER,
3087: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3088: X_Return_Status OUT NOCOPY VARCHAR2,
3089: X_Msg_Count OUT NOCOPY NUMBER,
3090: X_Msg_Data OUT NOCOPY VARCHAR2
3091: )
3101:
3102: -- Initialize API return status to SUCCESS
3103: x_return_status := FND_API.G_RET_STS_SUCCESS;
3104:
3105: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3106: THEN
3107: -- Hint: Validate data
3108: -- IF p_TRANSACTION_SOURCE_ID is not NULL and p_TRANSACTION_SOURCE_ID <> G_MISS_CHAR
3109: -- verify if data is valid
3108: -- IF p_TRANSACTION_SOURCE_ID is not NULL and p_TRANSACTION_SOURCE_ID <> G_MISS_CHAR
3109: -- verify if data is valid
3110: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3111: NULL;
3112: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3113: THEN
3114: -- Hint: Validate data
3115: -- IF p_TRANSACTION_SOURCE_ID <> G_MISS_CHAR
3116: -- verify if data is valid
3130: PROCEDURE Validate_TRANSACTION_SOURCE_NAME (
3131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3132: P_Validation_mode IN VARCHAR2,
3133: P_TRANSACTION_SOURCE_NAME IN VARCHAR2,
3134: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3135: X_Return_Status OUT NOCOPY VARCHAR2,
3136: X_Msg_Count OUT NOCOPY NUMBER,
3137: X_Msg_Data OUT NOCOPY VARCHAR2
3138: )
3148:
3149: -- Initialize API return status to SUCCESS
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151:
3152: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3153: THEN
3154: -- Hint: Validate data
3155: -- IF p_TRANSACTION_SOURCE_NAME is not NULL and p_TRANSACTION_SOURCE_NAME <> G_MISS_CHAR
3156: -- verify if data is valid
3155: -- IF p_TRANSACTION_SOURCE_NAME is not NULL and p_TRANSACTION_SOURCE_NAME <> G_MISS_CHAR
3156: -- verify if data is valid
3157: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3158: NULL;
3159: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3160: THEN
3161: -- Hint: Validate data
3162: -- IF p_TRANSACTION_SOURCE_NAME <> G_MISS_CHAR
3163: -- verify if data is valid
3177: PROCEDURE Validate_TRANSACTION_DATE (
3178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3179: P_Validation_mode IN VARCHAR2,
3180: P_TRANSACTION_DATE IN DATE,
3181: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3182: X_Return_Status OUT NOCOPY VARCHAR2,
3183: X_Msg_Count OUT NOCOPY NUMBER,
3184: X_Msg_Data OUT NOCOPY VARCHAR2
3185: )
3198:
3199: -- validate NOT NULL column
3200: IF(p_TRANSACTION_DATE is NULL)
3201: THEN
3202: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_DATE)');
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: END IF;
3205:
3206: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3202: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(TRANSACTION_DATE)');
3203: x_return_status := FND_API.G_RET_STS_ERROR;
3204: END IF;
3205:
3206: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3207: THEN
3208: -- Hint: Validate data
3209: -- IF p_TRANSACTION_DATE is not NULL and p_TRANSACTION_DATE <> G_MISS_CHAR
3210: -- verify if data is valid
3209: -- IF p_TRANSACTION_DATE is not NULL and p_TRANSACTION_DATE <> G_MISS_CHAR
3210: -- verify if data is valid
3211: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3212: NULL;
3213: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3214: THEN
3215: -- Hint: Validate data
3216: -- IF p_TRANSACTION_DATE <> G_MISS_CHAR
3217: -- verify if data is valid
3231: PROCEDURE Validate_ACCT_PERIOD_ID (
3232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3233: P_Validation_mode IN VARCHAR2,
3234: P_ACCT_PERIOD_ID IN NUMBER,
3235: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3236: X_Return_Status OUT NOCOPY VARCHAR2,
3237: X_Msg_Count OUT NOCOPY NUMBER,
3238: X_Msg_Data OUT NOCOPY VARCHAR2
3239: )
3252:
3253: -- validate NOT NULL column
3254: IF(p_ACCT_PERIOD_ID is NULL)
3255: THEN
3256: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(ACCT_PERIOD_ID)');
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: END IF;
3259:
3260: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3256: JTF_PLSQL_API.Debug_Message('ERROR', 'Private material_transactions API: -Violate NOT NULL constraint(ACCT_PERIOD_ID)');
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: END IF;
3259:
3260: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3261: THEN
3262: -- Hint: Validate data
3263: -- IF p_ACCT_PERIOD_ID is not NULL and p_ACCT_PERIOD_ID <> G_MISS_CHAR
3264: -- verify if data is valid
3263: -- IF p_ACCT_PERIOD_ID is not NULL and p_ACCT_PERIOD_ID <> G_MISS_CHAR
3264: -- verify if data is valid
3265: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3266: NULL;
3267: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3268: THEN
3269: -- Hint: Validate data
3270: -- IF p_ACCT_PERIOD_ID <> G_MISS_CHAR
3271: -- verify if data is valid
3285: PROCEDURE Validate_DISTRIBUTION_ACCOUNT_ID (
3286: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3287: P_Validation_mode IN VARCHAR2,
3288: P_DISTRIBUTION_ACCOUNT_ID IN NUMBER,
3289: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3290: X_Return_Status OUT NOCOPY VARCHAR2,
3291: X_Msg_Count OUT NOCOPY NUMBER,
3292: X_Msg_Data OUT NOCOPY VARCHAR2
3293: )
3303:
3304: -- Initialize API return status to SUCCESS
3305: x_return_status := FND_API.G_RET_STS_SUCCESS;
3306:
3307: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3308: THEN
3309: -- Hint: Validate data
3310: -- IF p_DISTRIBUTION_ACCOUNT_ID is not NULL and p_DISTRIBUTION_ACCOUNT_ID <> G_MISS_CHAR
3311: -- verify if data is valid
3310: -- IF p_DISTRIBUTION_ACCOUNT_ID is not NULL and p_DISTRIBUTION_ACCOUNT_ID <> G_MISS_CHAR
3311: -- verify if data is valid
3312: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3313: NULL;
3314: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3315: THEN
3316: -- Hint: Validate data
3317: -- IF p_DISTRIBUTION_ACCOUNT_ID <> G_MISS_CHAR
3318: -- verify if data is valid
3332: PROCEDURE Validate_TRANSACTION_REFERENCE (
3333: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3334: P_Validation_mode IN VARCHAR2,
3335: P_TRANSACTION_REFERENCE IN VARCHAR2,
3336: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3337: X_Return_Status OUT NOCOPY VARCHAR2,
3338: X_Msg_Count OUT NOCOPY NUMBER,
3339: X_Msg_Data OUT NOCOPY VARCHAR2
3340: )
3350:
3351: -- Initialize API return status to SUCCESS
3352: x_return_status := FND_API.G_RET_STS_SUCCESS;
3353:
3354: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3355: THEN
3356: -- Hint: Validate data
3357: -- IF p_TRANSACTION_REFERENCE is not NULL and p_TRANSACTION_REFERENCE <> G_MISS_CHAR
3358: -- verify if data is valid
3357: -- IF p_TRANSACTION_REFERENCE is not NULL and p_TRANSACTION_REFERENCE <> G_MISS_CHAR
3358: -- verify if data is valid
3359: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3360: NULL;
3361: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3362: THEN
3363: -- Hint: Validate data
3364: -- IF p_TRANSACTION_REFERENCE <> G_MISS_CHAR
3365: -- verify if data is valid
3379: PROCEDURE Validate_REQUISITION_LINE_ID (
3380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3381: P_Validation_mode IN VARCHAR2,
3382: P_REQUISITION_LINE_ID IN NUMBER,
3383: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3384: X_Return_Status OUT NOCOPY VARCHAR2,
3385: X_Msg_Count OUT NOCOPY NUMBER,
3386: X_Msg_Data OUT NOCOPY VARCHAR2
3387: )
3397:
3398: -- Initialize API return status to SUCCESS
3399: x_return_status := FND_API.G_RET_STS_SUCCESS;
3400:
3401: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3402: THEN
3403: -- Hint: Validate data
3404: -- IF p_REQUISITION_LINE_ID is not NULL and p_REQUISITION_LINE_ID <> G_MISS_CHAR
3405: -- verify if data is valid
3404: -- IF p_REQUISITION_LINE_ID is not NULL and p_REQUISITION_LINE_ID <> G_MISS_CHAR
3405: -- verify if data is valid
3406: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3407: NULL;
3408: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3409: THEN
3410: -- Hint: Validate data
3411: -- IF p_REQUISITION_LINE_ID <> G_MISS_CHAR
3412: -- verify if data is valid
3426: PROCEDURE Validate_REQUISITION_DISTRIBUTION_ID (
3427: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3428: P_Validation_mode IN VARCHAR2,
3429: P_REQUISITION_DISTRIBUTION_ID IN NUMBER,
3430: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3431: X_Return_Status OUT NOCOPY VARCHAR2,
3432: X_Msg_Count OUT NOCOPY NUMBER,
3433: X_Msg_Data OUT NOCOPY VARCHAR2
3434: )
3444:
3445: -- Initialize API return status to SUCCESS
3446: x_return_status := FND_API.G_RET_STS_SUCCESS;
3447:
3448: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3449: THEN
3450: -- Hint: Validate data
3451: -- IF p_REQUISITION_DISTRIBUTION_ID is not NULL and p_REQUISITION_DISTRIBUTION_ID <> G_MISS_CHAR
3452: -- verify if data is valid
3451: -- IF p_REQUISITION_DISTRIBUTION_ID is not NULL and p_REQUISITION_DISTRIBUTION_ID <> G_MISS_CHAR
3452: -- verify if data is valid
3453: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3454: NULL;
3455: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3456: THEN
3457: -- Hint: Validate data
3458: -- IF p_REQUISITION_DISTRIBUTION_ID <> G_MISS_CHAR
3459: -- verify if data is valid
3473: PROCEDURE Validate_REASON_ID (
3474: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3475: P_Validation_mode IN VARCHAR2,
3476: P_REASON_ID IN NUMBER,
3477: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3478: X_Return_Status OUT NOCOPY VARCHAR2,
3479: X_Msg_Count OUT NOCOPY NUMBER,
3480: X_Msg_Data OUT NOCOPY VARCHAR2
3481: )
3491:
3492: -- Initialize API return status to SUCCESS
3493: x_return_status := FND_API.G_RET_STS_SUCCESS;
3494:
3495: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3496: THEN
3497: -- Hint: Validate data
3498: -- IF p_REASON_ID is not NULL and p_REASON_ID <> G_MISS_CHAR
3499: -- verify if data is valid
3498: -- IF p_REASON_ID is not NULL and p_REASON_ID <> G_MISS_CHAR
3499: -- verify if data is valid
3500: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3501: NULL;
3502: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3503: THEN
3504: -- Hint: Validate data
3505: -- IF p_REASON_ID <> G_MISS_CHAR
3506: -- verify if data is valid
3520: PROCEDURE Validate_LOT_NUMBER (
3521: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3522: P_Validation_mode IN VARCHAR2,
3523: P_LOT_NUMBER IN VARCHAR2,
3524: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3525: X_Return_Status OUT NOCOPY VARCHAR2,
3526: X_Msg_Count OUT NOCOPY NUMBER,
3527: X_Msg_Data OUT NOCOPY VARCHAR2
3528: )
3538:
3539: -- Initialize API return status to SUCCESS
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541:
3542: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3543: THEN
3544: -- Hint: Validate data
3545: -- IF p_LOT_NUMBER is not NULL and p_LOT_NUMBER <> G_MISS_CHAR
3546: -- verify if data is valid
3545: -- IF p_LOT_NUMBER is not NULL and p_LOT_NUMBER <> G_MISS_CHAR
3546: -- verify if data is valid
3547: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3548: NULL;
3549: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3550: THEN
3551: -- Hint: Validate data
3552: -- IF p_LOT_NUMBER <> G_MISS_CHAR
3553: -- verify if data is valid
3567: PROCEDURE Validate_LOT_EXPIRATION_DATE (
3568: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3569: P_Validation_mode IN VARCHAR2,
3570: P_LOT_EXPIRATION_DATE IN DATE,
3571: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3572: X_Return_Status OUT NOCOPY VARCHAR2,
3573: X_Msg_Count OUT NOCOPY NUMBER,
3574: X_Msg_Data OUT NOCOPY VARCHAR2
3575: )
3585:
3586: -- Initialize API return status to SUCCESS
3587: x_return_status := FND_API.G_RET_STS_SUCCESS;
3588:
3589: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3590: THEN
3591: -- Hint: Validate data
3592: -- IF p_LOT_EXPIRATION_DATE is not NULL and p_LOT_EXPIRATION_DATE <> G_MISS_CHAR
3593: -- verify if data is valid
3592: -- IF p_LOT_EXPIRATION_DATE is not NULL and p_LOT_EXPIRATION_DATE <> G_MISS_CHAR
3593: -- verify if data is valid
3594: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3595: NULL;
3596: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3597: THEN
3598: -- Hint: Validate data
3599: -- IF p_LOT_EXPIRATION_DATE <> G_MISS_CHAR
3600: -- verify if data is valid
3614: PROCEDURE Validate_SERIAL_NUMBER (
3615: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3616: P_Validation_mode IN VARCHAR2,
3617: P_SERIAL_NUMBER IN VARCHAR2,
3618: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3619: X_Return_Status OUT NOCOPY VARCHAR2,
3620: X_Msg_Count OUT NOCOPY NUMBER,
3621: X_Msg_Data OUT NOCOPY VARCHAR2
3622: )
3632:
3633: -- Initialize API return status to SUCCESS
3634: x_return_status := FND_API.G_RET_STS_SUCCESS;
3635:
3636: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3637: THEN
3638: -- Hint: Validate data
3639: -- IF p_SERIAL_NUMBER is not NULL and p_SERIAL_NUMBER <> G_MISS_CHAR
3640: -- verify if data is valid
3639: -- IF p_SERIAL_NUMBER is not NULL and p_SERIAL_NUMBER <> G_MISS_CHAR
3640: -- verify if data is valid
3641: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3642: NULL;
3643: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3644: THEN
3645: -- Hint: Validate data
3646: -- IF p_SERIAL_NUMBER <> G_MISS_CHAR
3647: -- verify if data is valid
3661: PROCEDURE Validate_RECEIVING_DOCUMENT (
3662: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3663: P_Validation_mode IN VARCHAR2,
3664: P_RECEIVING_DOCUMENT IN VARCHAR2,
3665: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3666: X_Return_Status OUT NOCOPY VARCHAR2,
3667: X_Msg_Count OUT NOCOPY NUMBER,
3668: X_Msg_Data OUT NOCOPY VARCHAR2
3669: )
3679:
3680: -- Initialize API return status to SUCCESS
3681: x_return_status := FND_API.G_RET_STS_SUCCESS;
3682:
3683: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3684: THEN
3685: -- Hint: Validate data
3686: -- IF p_RECEIVING_DOCUMENT is not NULL and p_RECEIVING_DOCUMENT <> G_MISS_CHAR
3687: -- verify if data is valid
3686: -- IF p_RECEIVING_DOCUMENT is not NULL and p_RECEIVING_DOCUMENT <> G_MISS_CHAR
3687: -- verify if data is valid
3688: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3689: NULL;
3690: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3691: THEN
3692: -- Hint: Validate data
3693: -- IF p_RECEIVING_DOCUMENT <> G_MISS_CHAR
3694: -- verify if data is valid
3708: PROCEDURE Validate_DEMAND_ID (
3709: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3710: P_Validation_mode IN VARCHAR2,
3711: P_DEMAND_ID IN NUMBER,
3712: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3713: X_Return_Status OUT NOCOPY VARCHAR2,
3714: X_Msg_Count OUT NOCOPY NUMBER,
3715: X_Msg_Data OUT NOCOPY VARCHAR2
3716: )
3726:
3727: -- Initialize API return status to SUCCESS
3728: x_return_status := FND_API.G_RET_STS_SUCCESS;
3729:
3730: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3731: THEN
3732: -- Hint: Validate data
3733: -- IF p_DEMAND_ID is not NULL and p_DEMAND_ID <> G_MISS_CHAR
3734: -- verify if data is valid
3733: -- IF p_DEMAND_ID is not NULL and p_DEMAND_ID <> G_MISS_CHAR
3734: -- verify if data is valid
3735: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3736: NULL;
3737: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3738: THEN
3739: -- Hint: Validate data
3740: -- IF p_DEMAND_ID <> G_MISS_CHAR
3741: -- verify if data is valid
3755: PROCEDURE Validate_RCV_TRANSACTION_ID (
3756: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3757: P_Validation_mode IN VARCHAR2,
3758: P_RCV_TRANSACTION_ID IN NUMBER,
3759: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3760: X_Return_Status OUT NOCOPY VARCHAR2,
3761: X_Msg_Count OUT NOCOPY NUMBER,
3762: X_Msg_Data OUT NOCOPY VARCHAR2
3763: )
3773:
3774: -- Initialize API return status to SUCCESS
3775: x_return_status := FND_API.G_RET_STS_SUCCESS;
3776:
3777: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3778: THEN
3779: -- Hint: Validate data
3780: -- IF p_RCV_TRANSACTION_ID is not NULL and p_RCV_TRANSACTION_ID <> G_MISS_CHAR
3781: -- verify if data is valid
3780: -- IF p_RCV_TRANSACTION_ID is not NULL and p_RCV_TRANSACTION_ID <> G_MISS_CHAR
3781: -- verify if data is valid
3782: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3783: NULL;
3784: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3785: THEN
3786: -- Hint: Validate data
3787: -- IF p_RCV_TRANSACTION_ID <> G_MISS_CHAR
3788: -- verify if data is valid
3802: PROCEDURE Validate_MOVE_TRANSACTION_ID (
3803: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3804: P_Validation_mode IN VARCHAR2,
3805: P_MOVE_TRANSACTION_ID IN NUMBER,
3806: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3807: X_Return_Status OUT NOCOPY VARCHAR2,
3808: X_Msg_Count OUT NOCOPY NUMBER,
3809: X_Msg_Data OUT NOCOPY VARCHAR2
3810: )
3820:
3821: -- Initialize API return status to SUCCESS
3822: x_return_status := FND_API.G_RET_STS_SUCCESS;
3823:
3824: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3825: THEN
3826: -- Hint: Validate data
3827: -- IF p_MOVE_TRANSACTION_ID is not NULL and p_MOVE_TRANSACTION_ID <> G_MISS_CHAR
3828: -- verify if data is valid
3827: -- IF p_MOVE_TRANSACTION_ID is not NULL and p_MOVE_TRANSACTION_ID <> G_MISS_CHAR
3828: -- verify if data is valid
3829: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3830: NULL;
3831: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3832: THEN
3833: -- Hint: Validate data
3834: -- IF p_MOVE_TRANSACTION_ID <> G_MISS_CHAR
3835: -- verify if data is valid
3849: PROCEDURE Validate_COMPLETION_TRANSACTION_ID (
3850: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3851: P_Validation_mode IN VARCHAR2,
3852: P_COMPLETION_TRANSACTION_ID IN NUMBER,
3853: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3854: X_Return_Status OUT NOCOPY VARCHAR2,
3855: X_Msg_Count OUT NOCOPY NUMBER,
3856: X_Msg_Data OUT NOCOPY VARCHAR2
3857: )
3867:
3868: -- Initialize API return status to SUCCESS
3869: x_return_status := FND_API.G_RET_STS_SUCCESS;
3870:
3871: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3872: THEN
3873: -- Hint: Validate data
3874: -- IF p_COMPLETION_TRANSACTION_ID is not NULL and p_COMPLETION_TRANSACTION_ID <> G_MISS_CHAR
3875: -- verify if data is valid
3874: -- IF p_COMPLETION_TRANSACTION_ID is not NULL and p_COMPLETION_TRANSACTION_ID <> G_MISS_CHAR
3875: -- verify if data is valid
3876: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3877: NULL;
3878: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3879: THEN
3880: -- Hint: Validate data
3881: -- IF p_COMPLETION_TRANSACTION_ID <> G_MISS_CHAR
3882: -- verify if data is valid
3896: PROCEDURE Validate_WIP_ENTITY_TYPE (
3897: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3898: P_Validation_mode IN VARCHAR2,
3899: P_WIP_ENTITY_TYPE IN NUMBER,
3900: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3901: X_Return_Status OUT NOCOPY VARCHAR2,
3902: X_Msg_Count OUT NOCOPY NUMBER,
3903: X_Msg_Data OUT NOCOPY VARCHAR2
3904: )
3914:
3915: -- Initialize API return status to SUCCESS
3916: x_return_status := FND_API.G_RET_STS_SUCCESS;
3917:
3918: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3919: THEN
3920: -- Hint: Validate data
3921: -- IF p_WIP_ENTITY_TYPE is not NULL and p_WIP_ENTITY_TYPE <> G_MISS_CHAR
3922: -- verify if data is valid
3921: -- IF p_WIP_ENTITY_TYPE is not NULL and p_WIP_ENTITY_TYPE <> G_MISS_CHAR
3922: -- verify if data is valid
3923: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3924: NULL;
3925: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3926: THEN
3927: -- Hint: Validate data
3928: -- IF p_WIP_ENTITY_TYPE <> G_MISS_CHAR
3929: -- verify if data is valid
3943: PROCEDURE Validate_SCHEDULE_ID (
3944: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3945: P_Validation_mode IN VARCHAR2,
3946: P_SCHEDULE_ID IN NUMBER,
3947: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3948: X_Return_Status OUT NOCOPY VARCHAR2,
3949: X_Msg_Count OUT NOCOPY NUMBER,
3950: X_Msg_Data OUT NOCOPY VARCHAR2
3951: )
3961:
3962: -- Initialize API return status to SUCCESS
3963: x_return_status := FND_API.G_RET_STS_SUCCESS;
3964:
3965: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3966: THEN
3967: -- Hint: Validate data
3968: -- IF p_SCHEDULE_ID is not NULL and p_SCHEDULE_ID <> G_MISS_CHAR
3969: -- verify if data is valid
3968: -- IF p_SCHEDULE_ID is not NULL and p_SCHEDULE_ID <> G_MISS_CHAR
3969: -- verify if data is valid
3970: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3971: NULL;
3972: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3973: THEN
3974: -- Hint: Validate data
3975: -- IF p_SCHEDULE_ID <> G_MISS_CHAR
3976: -- verify if data is valid
3990: PROCEDURE Validate_REPETITIVE_LINE_ID (
3991: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3992: P_Validation_mode IN VARCHAR2,
3993: P_REPETITIVE_LINE_ID IN NUMBER,
3994: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3995: X_Return_Status OUT NOCOPY VARCHAR2,
3996: X_Msg_Count OUT NOCOPY NUMBER,
3997: X_Msg_Data OUT NOCOPY VARCHAR2
3998: )
4008:
4009: -- Initialize API return status to SUCCESS
4010: x_return_status := FND_API.G_RET_STS_SUCCESS;
4011:
4012: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4013: THEN
4014: -- Hint: Validate data
4015: -- IF p_REPETITIVE_LINE_ID is not NULL and p_REPETITIVE_LINE_ID <> G_MISS_CHAR
4016: -- verify if data is valid
4015: -- IF p_REPETITIVE_LINE_ID is not NULL and p_REPETITIVE_LINE_ID <> G_MISS_CHAR
4016: -- verify if data is valid
4017: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4018: NULL;
4019: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4020: THEN
4021: -- Hint: Validate data
4022: -- IF p_REPETITIVE_LINE_ID <> G_MISS_CHAR
4023: -- verify if data is valid
4037: PROCEDURE Validate_EMPLOYEE_CODE (
4038: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4039: P_Validation_mode IN VARCHAR2,
4040: P_EMPLOYEE_CODE IN VARCHAR2,
4041: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4042: X_Return_Status OUT NOCOPY VARCHAR2,
4043: X_Msg_Count OUT NOCOPY NUMBER,
4044: X_Msg_Data OUT NOCOPY VARCHAR2
4045: )
4055:
4056: -- Initialize API return status to SUCCESS
4057: x_return_status := FND_API.G_RET_STS_SUCCESS;
4058:
4059: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4060: THEN
4061: -- Hint: Validate data
4062: -- IF p_EMPLOYEE_CODE is not NULL and p_EMPLOYEE_CODE <> G_MISS_CHAR
4063: -- verify if data is valid
4062: -- IF p_EMPLOYEE_CODE is not NULL and p_EMPLOYEE_CODE <> G_MISS_CHAR
4063: -- verify if data is valid
4064: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4065: NULL;
4066: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4067: THEN
4068: -- Hint: Validate data
4069: -- IF p_EMPLOYEE_CODE <> G_MISS_CHAR
4070: -- verify if data is valid
4084: PROCEDURE Validate_PRIMARY_SWITCH (
4085: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4086: P_Validation_mode IN VARCHAR2,
4087: P_PRIMARY_SWITCH IN NUMBER,
4088: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4089: X_Return_Status OUT NOCOPY VARCHAR2,
4090: X_Msg_Count OUT NOCOPY NUMBER,
4091: X_Msg_Data OUT NOCOPY VARCHAR2
4092: )
4102:
4103: -- Initialize API return status to SUCCESS
4104: x_return_status := FND_API.G_RET_STS_SUCCESS;
4105:
4106: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4107: THEN
4108: -- Hint: Validate data
4109: -- IF p_PRIMARY_SWITCH is not NULL and p_PRIMARY_SWITCH <> G_MISS_CHAR
4110: -- verify if data is valid
4109: -- IF p_PRIMARY_SWITCH is not NULL and p_PRIMARY_SWITCH <> G_MISS_CHAR
4110: -- verify if data is valid
4111: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4112: NULL;
4113: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4114: THEN
4115: -- Hint: Validate data
4116: -- IF p_PRIMARY_SWITCH <> G_MISS_CHAR
4117: -- verify if data is valid
4131: PROCEDURE Validate_SCHEDULE_UPDATE_CODE (
4132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4133: P_Validation_mode IN VARCHAR2,
4134: P_SCHEDULE_UPDATE_CODE IN NUMBER,
4135: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4136: X_Return_Status OUT NOCOPY VARCHAR2,
4137: X_Msg_Count OUT NOCOPY NUMBER,
4138: X_Msg_Data OUT NOCOPY VARCHAR2
4139: )
4149:
4150: -- Initialize API return status to SUCCESS
4151: x_return_status := FND_API.G_RET_STS_SUCCESS;
4152:
4153: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4154: THEN
4155: -- Hint: Validate data
4156: -- IF p_SCHEDULE_UPDATE_CODE is not NULL and p_SCHEDULE_UPDATE_CODE <> G_MISS_CHAR
4157: -- verify if data is valid
4156: -- IF p_SCHEDULE_UPDATE_CODE is not NULL and p_SCHEDULE_UPDATE_CODE <> G_MISS_CHAR
4157: -- verify if data is valid
4158: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4159: NULL;
4160: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4161: THEN
4162: -- Hint: Validate data
4163: -- IF p_SCHEDULE_UPDATE_CODE <> G_MISS_CHAR
4164: -- verify if data is valid
4178: PROCEDURE Validate_SETUP_TEARDOWN_CODE (
4179: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4180: P_Validation_mode IN VARCHAR2,
4181: P_SETUP_TEARDOWN_CODE IN NUMBER,
4182: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4183: X_Return_Status OUT NOCOPY VARCHAR2,
4184: X_Msg_Count OUT NOCOPY NUMBER,
4185: X_Msg_Data OUT NOCOPY VARCHAR2
4186: )
4196:
4197: -- Initialize API return status to SUCCESS
4198: x_return_status := FND_API.G_RET_STS_SUCCESS;
4199:
4200: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4201: THEN
4202: -- Hint: Validate data
4203: -- IF p_SETUP_TEARDOWN_CODE is not NULL and p_SETUP_TEARDOWN_CODE <> G_MISS_CHAR
4204: -- verify if data is valid
4203: -- IF p_SETUP_TEARDOWN_CODE is not NULL and p_SETUP_TEARDOWN_CODE <> G_MISS_CHAR
4204: -- verify if data is valid
4205: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4206: NULL;
4207: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4208: THEN
4209: -- Hint: Validate data
4210: -- IF p_SETUP_TEARDOWN_CODE <> G_MISS_CHAR
4211: -- verify if data is valid
4225: PROCEDURE Validate_ITEM_ORDERING (
4226: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4227: P_Validation_mode IN VARCHAR2,
4228: P_ITEM_ORDERING IN NUMBER,
4229: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4230: X_Return_Status OUT NOCOPY VARCHAR2,
4231: X_Msg_Count OUT NOCOPY NUMBER,
4232: X_Msg_Data OUT NOCOPY VARCHAR2
4233: )
4243:
4244: -- Initialize API return status to SUCCESS
4245: x_return_status := FND_API.G_RET_STS_SUCCESS;
4246:
4247: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4248: THEN
4249: -- Hint: Validate data
4250: -- IF p_ITEM_ORDERING is not NULL and p_ITEM_ORDERING <> G_MISS_CHAR
4251: -- verify if data is valid
4250: -- IF p_ITEM_ORDERING is not NULL and p_ITEM_ORDERING <> G_MISS_CHAR
4251: -- verify if data is valid
4252: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4253: NULL;
4254: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4255: THEN
4256: -- Hint: Validate data
4257: -- IF p_ITEM_ORDERING <> G_MISS_CHAR
4258: -- verify if data is valid
4272: PROCEDURE Validate_NEGATIVE_REQ_FLAG (
4273: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4274: P_Validation_mode IN VARCHAR2,
4275: P_NEGATIVE_REQ_FLAG IN NUMBER,
4276: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4277: X_Return_Status OUT NOCOPY VARCHAR2,
4278: X_Msg_Count OUT NOCOPY NUMBER,
4279: X_Msg_Data OUT NOCOPY VARCHAR2
4280: )
4290:
4291: -- Initialize API return status to SUCCESS
4292: x_return_status := FND_API.G_RET_STS_SUCCESS;
4293:
4294: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4295: THEN
4296: -- Hint: Validate data
4297: -- IF p_NEGATIVE_REQ_FLAG is not NULL and p_NEGATIVE_REQ_FLAG <> G_MISS_CHAR
4298: -- verify if data is valid
4297: -- IF p_NEGATIVE_REQ_FLAG is not NULL and p_NEGATIVE_REQ_FLAG <> G_MISS_CHAR
4298: -- verify if data is valid
4299: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4300: NULL;
4301: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4302: THEN
4303: -- Hint: Validate data
4304: -- IF p_NEGATIVE_REQ_FLAG <> G_MISS_CHAR
4305: -- verify if data is valid
4319: PROCEDURE Validate_OPERATION_SEQ_NUM (
4320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4321: P_Validation_mode IN VARCHAR2,
4322: P_OPERATION_SEQ_NUM IN NUMBER,
4323: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4324: X_Return_Status OUT NOCOPY VARCHAR2,
4325: X_Msg_Count OUT NOCOPY NUMBER,
4326: X_Msg_Data OUT NOCOPY VARCHAR2
4327: )
4337:
4338: -- Initialize API return status to SUCCESS
4339: x_return_status := FND_API.G_RET_STS_SUCCESS;
4340:
4341: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4342: THEN
4343: -- Hint: Validate data
4344: -- IF p_OPERATION_SEQ_NUM is not NULL and p_OPERATION_SEQ_NUM <> G_MISS_CHAR
4345: -- verify if data is valid
4344: -- IF p_OPERATION_SEQ_NUM is not NULL and p_OPERATION_SEQ_NUM <> G_MISS_CHAR
4345: -- verify if data is valid
4346: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4347: NULL;
4348: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4349: THEN
4350: -- Hint: Validate data
4351: -- IF p_OPERATION_SEQ_NUM <> G_MISS_CHAR
4352: -- verify if data is valid
4366: PROCEDURE Validate_PICKING_LINE_ID (
4367: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4368: P_Validation_mode IN VARCHAR2,
4369: P_PICKING_LINE_ID IN NUMBER,
4370: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4371: X_Return_Status OUT NOCOPY VARCHAR2,
4372: X_Msg_Count OUT NOCOPY NUMBER,
4373: X_Msg_Data OUT NOCOPY VARCHAR2
4374: )
4384:
4385: -- Initialize API return status to SUCCESS
4386: x_return_status := FND_API.G_RET_STS_SUCCESS;
4387:
4388: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4389: THEN
4390: -- Hint: Validate data
4391: -- IF p_PICKING_LINE_ID is not NULL and p_PICKING_LINE_ID <> G_MISS_CHAR
4392: -- verify if data is valid
4391: -- IF p_PICKING_LINE_ID is not NULL and p_PICKING_LINE_ID <> G_MISS_CHAR
4392: -- verify if data is valid
4393: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4394: NULL;
4395: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4396: THEN
4397: -- Hint: Validate data
4398: -- IF p_PICKING_LINE_ID <> G_MISS_CHAR
4399: -- verify if data is valid
4413: PROCEDURE Validate_TRX_SOURCE_LINE_ID (
4414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4415: P_Validation_mode IN VARCHAR2,
4416: P_TRX_SOURCE_LINE_ID IN NUMBER,
4417: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4418: X_Return_Status OUT NOCOPY VARCHAR2,
4419: X_Msg_Count OUT NOCOPY NUMBER,
4420: X_Msg_Data OUT NOCOPY VARCHAR2
4421: )
4431:
4432: -- Initialize API return status to SUCCESS
4433: x_return_status := FND_API.G_RET_STS_SUCCESS;
4434:
4435: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4436: THEN
4437: -- Hint: Validate data
4438: -- IF p_TRX_SOURCE_LINE_ID is not NULL and p_TRX_SOURCE_LINE_ID <> G_MISS_CHAR
4439: -- verify if data is valid
4438: -- IF p_TRX_SOURCE_LINE_ID is not NULL and p_TRX_SOURCE_LINE_ID <> G_MISS_CHAR
4439: -- verify if data is valid
4440: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4441: NULL;
4442: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4443: THEN
4444: -- Hint: Validate data
4445: -- IF p_TRX_SOURCE_LINE_ID <> G_MISS_CHAR
4446: -- verify if data is valid
4460: PROCEDURE Validate_TRX_SOURCE_DELIVERY_ID (
4461: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4462: P_Validation_mode IN VARCHAR2,
4463: P_TRX_SOURCE_DELIVERY_ID IN NUMBER,
4464: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4465: X_Return_Status OUT NOCOPY VARCHAR2,
4466: X_Msg_Count OUT NOCOPY NUMBER,
4467: X_Msg_Data OUT NOCOPY VARCHAR2
4468: )
4478:
4479: -- Initialize API return status to SUCCESS
4480: x_return_status := FND_API.G_RET_STS_SUCCESS;
4481:
4482: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4483: THEN
4484: -- Hint: Validate data
4485: -- IF p_TRX_SOURCE_DELIVERY_ID is not NULL and p_TRX_SOURCE_DELIVERY_ID <> G_MISS_CHAR
4486: -- verify if data is valid
4485: -- IF p_TRX_SOURCE_DELIVERY_ID is not NULL and p_TRX_SOURCE_DELIVERY_ID <> G_MISS_CHAR
4486: -- verify if data is valid
4487: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4488: NULL;
4489: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4490: THEN
4491: -- Hint: Validate data
4492: -- IF p_TRX_SOURCE_DELIVERY_ID <> G_MISS_CHAR
4493: -- verify if data is valid
4507: PROCEDURE Validate_PHYSICAL_ADJUSTMENT_ID (
4508: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4509: P_Validation_mode IN VARCHAR2,
4510: P_PHYSICAL_ADJUSTMENT_ID IN NUMBER,
4511: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4512: X_Return_Status OUT NOCOPY VARCHAR2,
4513: X_Msg_Count OUT NOCOPY NUMBER,
4514: X_Msg_Data OUT NOCOPY VARCHAR2
4515: )
4525:
4526: -- Initialize API return status to SUCCESS
4527: x_return_status := FND_API.G_RET_STS_SUCCESS;
4528:
4529: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4530: THEN
4531: -- Hint: Validate data
4532: -- IF p_PHYSICAL_ADJUSTMENT_ID is not NULL and p_PHYSICAL_ADJUSTMENT_ID <> G_MISS_CHAR
4533: -- verify if data is valid
4532: -- IF p_PHYSICAL_ADJUSTMENT_ID is not NULL and p_PHYSICAL_ADJUSTMENT_ID <> G_MISS_CHAR
4533: -- verify if data is valid
4534: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4535: NULL;
4536: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4537: THEN
4538: -- Hint: Validate data
4539: -- IF p_PHYSICAL_ADJUSTMENT_ID <> G_MISS_CHAR
4540: -- verify if data is valid
4554: PROCEDURE Validate_CYCLE_COUNT_ID (
4555: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4556: P_Validation_mode IN VARCHAR2,
4557: P_CYCLE_COUNT_ID IN NUMBER,
4558: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4559: X_Return_Status OUT NOCOPY VARCHAR2,
4560: X_Msg_Count OUT NOCOPY NUMBER,
4561: X_Msg_Data OUT NOCOPY VARCHAR2
4562: )
4572:
4573: -- Initialize API return status to SUCCESS
4574: x_return_status := FND_API.G_RET_STS_SUCCESS;
4575:
4576: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4577: THEN
4578: -- Hint: Validate data
4579: -- IF p_CYCLE_COUNT_ID is not NULL and p_CYCLE_COUNT_ID <> G_MISS_CHAR
4580: -- verify if data is valid
4579: -- IF p_CYCLE_COUNT_ID is not NULL and p_CYCLE_COUNT_ID <> G_MISS_CHAR
4580: -- verify if data is valid
4581: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4582: NULL;
4583: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4584: THEN
4585: -- Hint: Validate data
4586: -- IF p_CYCLE_COUNT_ID <> G_MISS_CHAR
4587: -- verify if data is valid
4601: PROCEDURE Validate_RMA_LINE_ID (
4602: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4603: P_Validation_mode IN VARCHAR2,
4604: P_RMA_LINE_ID IN NUMBER,
4605: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4606: X_Return_Status OUT NOCOPY VARCHAR2,
4607: X_Msg_Count OUT NOCOPY NUMBER,
4608: X_Msg_Data OUT NOCOPY VARCHAR2
4609: )
4619:
4620: -- Initialize API return status to SUCCESS
4621: x_return_status := FND_API.G_RET_STS_SUCCESS;
4622:
4623: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4624: THEN
4625: -- Hint: Validate data
4626: -- IF p_RMA_LINE_ID is not NULL and p_RMA_LINE_ID <> G_MISS_CHAR
4627: -- verify if data is valid
4626: -- IF p_RMA_LINE_ID is not NULL and p_RMA_LINE_ID <> G_MISS_CHAR
4627: -- verify if data is valid
4628: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4629: NULL;
4630: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4631: THEN
4632: -- Hint: Validate data
4633: -- IF p_RMA_LINE_ID <> G_MISS_CHAR
4634: -- verify if data is valid
4648: PROCEDURE Validate_CUSTOMER_SHIP_ID (
4649: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4650: P_Validation_mode IN VARCHAR2,
4651: P_CUSTOMER_SHIP_ID IN NUMBER,
4652: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4653: X_Return_Status OUT NOCOPY VARCHAR2,
4654: X_Msg_Count OUT NOCOPY NUMBER,
4655: X_Msg_Data OUT NOCOPY VARCHAR2
4656: )
4666:
4667: -- Initialize API return status to SUCCESS
4668: x_return_status := FND_API.G_RET_STS_SUCCESS;
4669:
4670: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4671: THEN
4672: -- Hint: Validate data
4673: -- IF p_CUSTOMER_SHIP_ID is not NULL and p_CUSTOMER_SHIP_ID <> G_MISS_CHAR
4674: -- verify if data is valid
4673: -- IF p_CUSTOMER_SHIP_ID is not NULL and p_CUSTOMER_SHIP_ID <> G_MISS_CHAR
4674: -- verify if data is valid
4675: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4676: NULL;
4677: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4678: THEN
4679: -- Hint: Validate data
4680: -- IF p_CUSTOMER_SHIP_ID <> G_MISS_CHAR
4681: -- verify if data is valid
4695: PROCEDURE Validate_CURRENCY_CODE (
4696: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4697: P_Validation_mode IN VARCHAR2,
4698: P_CURRENCY_CODE IN VARCHAR2,
4699: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4700: X_Return_Status OUT NOCOPY VARCHAR2,
4701: X_Msg_Count OUT NOCOPY NUMBER,
4702: X_Msg_Data OUT NOCOPY VARCHAR2
4703: )
4713:
4714: -- Initialize API return status to SUCCESS
4715: x_return_status := FND_API.G_RET_STS_SUCCESS;
4716:
4717: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4718: THEN
4719: -- Hint: Validate data
4720: -- IF p_CURRENCY_CODE is not NULL and p_CURRENCY_CODE <> G_MISS_CHAR
4721: -- verify if data is valid
4720: -- IF p_CURRENCY_CODE is not NULL and p_CURRENCY_CODE <> G_MISS_CHAR
4721: -- verify if data is valid
4722: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4723: NULL;
4724: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4725: THEN
4726: -- Hint: Validate data
4727: -- IF p_CURRENCY_CODE <> G_MISS_CHAR
4728: -- verify if data is valid
4742: PROCEDURE Validate_CURRENCY_CONVERSION_RATE (
4743: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4744: P_Validation_mode IN VARCHAR2,
4745: P_CURRENCY_CONVERSION_RATE IN NUMBER,
4746: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4747: X_Return_Status OUT NOCOPY VARCHAR2,
4748: X_Msg_Count OUT NOCOPY NUMBER,
4749: X_Msg_Data OUT NOCOPY VARCHAR2
4750: )
4760:
4761: -- Initialize API return status to SUCCESS
4762: x_return_status := FND_API.G_RET_STS_SUCCESS;
4763:
4764: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4765: THEN
4766: -- Hint: Validate data
4767: -- IF p_CURRENCY_CONVERSION_RATE is not NULL and p_CURRENCY_CONVERSION_RATE <> G_MISS_CHAR
4768: -- verify if data is valid
4767: -- IF p_CURRENCY_CONVERSION_RATE is not NULL and p_CURRENCY_CONVERSION_RATE <> G_MISS_CHAR
4768: -- verify if data is valid
4769: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4770: NULL;
4771: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4772: THEN
4773: -- Hint: Validate data
4774: -- IF p_CURRENCY_CONVERSION_RATE <> G_MISS_CHAR
4775: -- verify if data is valid
4789: PROCEDURE Validate_CURRENCY_CONVERSION_TYPE (
4790: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4791: P_Validation_mode IN VARCHAR2,
4792: P_CURRENCY_CONVERSION_TYPE IN VARCHAR2,
4793: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4794: X_Return_Status OUT NOCOPY VARCHAR2,
4795: X_Msg_Count OUT NOCOPY NUMBER,
4796: X_Msg_Data OUT NOCOPY VARCHAR2
4797: )
4807:
4808: -- Initialize API return status to SUCCESS
4809: x_return_status := FND_API.G_RET_STS_SUCCESS;
4810:
4811: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4812: THEN
4813: -- Hint: Validate data
4814: -- IF p_CURRENCY_CONVERSION_TYPE is not NULL and p_CURRENCY_CONVERSION_TYPE <> G_MISS_CHAR
4815: -- verify if data is valid
4814: -- IF p_CURRENCY_CONVERSION_TYPE is not NULL and p_CURRENCY_CONVERSION_TYPE <> G_MISS_CHAR
4815: -- verify if data is valid
4816: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4817: NULL;
4818: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4819: THEN
4820: -- Hint: Validate data
4821: -- IF p_CURRENCY_CONVERSION_TYPE <> G_MISS_CHAR
4822: -- verify if data is valid
4836: PROCEDURE Validate_CURRENCY_CONVERSION_DATE (
4837: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4838: P_Validation_mode IN VARCHAR2,
4839: P_CURRENCY_CONVERSION_DATE IN DATE,
4840: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4841: X_Return_Status OUT NOCOPY VARCHAR2,
4842: X_Msg_Count OUT NOCOPY NUMBER,
4843: X_Msg_Data OUT NOCOPY VARCHAR2
4844: )
4854:
4855: -- Initialize API return status to SUCCESS
4856: x_return_status := FND_API.G_RET_STS_SUCCESS;
4857:
4858: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4859: THEN
4860: -- Hint: Validate data
4861: -- IF p_CURRENCY_CONVERSION_DATE is not NULL and p_CURRENCY_CONVERSION_DATE <> G_MISS_CHAR
4862: -- verify if data is valid
4861: -- IF p_CURRENCY_CONVERSION_DATE is not NULL and p_CURRENCY_CONVERSION_DATE <> G_MISS_CHAR
4862: -- verify if data is valid
4863: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4864: NULL;
4865: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4866: THEN
4867: -- Hint: Validate data
4868: -- IF p_CURRENCY_CONVERSION_DATE <> G_MISS_CHAR
4869: -- verify if data is valid
4883: PROCEDURE Validate_USSGL_TRANSACTION_CODE (
4884: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4885: P_Validation_mode IN VARCHAR2,
4886: P_USSGL_TRANSACTION_CODE IN VARCHAR2,
4887: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4888: X_Return_Status OUT NOCOPY VARCHAR2,
4889: X_Msg_Count OUT NOCOPY NUMBER,
4890: X_Msg_Data OUT NOCOPY VARCHAR2
4891: )
4901:
4902: -- Initialize API return status to SUCCESS
4903: x_return_status := FND_API.G_RET_STS_SUCCESS;
4904:
4905: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4906: THEN
4907: -- Hint: Validate data
4908: -- IF p_USSGL_TRANSACTION_CODE is not NULL and p_USSGL_TRANSACTION_CODE <> G_MISS_CHAR
4909: -- verify if data is valid
4908: -- IF p_USSGL_TRANSACTION_CODE is not NULL and p_USSGL_TRANSACTION_CODE <> G_MISS_CHAR
4909: -- verify if data is valid
4910: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4911: NULL;
4912: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4913: THEN
4914: -- Hint: Validate data
4915: -- IF p_USSGL_TRANSACTION_CODE <> G_MISS_CHAR
4916: -- verify if data is valid
4930: PROCEDURE Validate_VENDOR_LOT_NUMBER (
4931: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4932: P_Validation_mode IN VARCHAR2,
4933: P_VENDOR_LOT_NUMBER IN VARCHAR2,
4934: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4935: X_Return_Status OUT NOCOPY VARCHAR2,
4936: X_Msg_Count OUT NOCOPY NUMBER,
4937: X_Msg_Data OUT NOCOPY VARCHAR2
4938: )
4948:
4949: -- Initialize API return status to SUCCESS
4950: x_return_status := FND_API.G_RET_STS_SUCCESS;
4951:
4952: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
4953: THEN
4954: -- Hint: Validate data
4955: -- IF p_VENDOR_LOT_NUMBER is not NULL and p_VENDOR_LOT_NUMBER <> G_MISS_CHAR
4956: -- verify if data is valid
4955: -- IF p_VENDOR_LOT_NUMBER is not NULL and p_VENDOR_LOT_NUMBER <> G_MISS_CHAR
4956: -- verify if data is valid
4957: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4958: NULL;
4959: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
4960: THEN
4961: -- Hint: Validate data
4962: -- IF p_VENDOR_LOT_NUMBER <> G_MISS_CHAR
4963: -- verify if data is valid
4977: PROCEDURE Validate_ENCUMBRANCE_ACCOUNT (
4978: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4979: P_Validation_mode IN VARCHAR2,
4980: P_ENCUMBRANCE_ACCOUNT IN NUMBER,
4981: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
4982: X_Return_Status OUT NOCOPY VARCHAR2,
4983: X_Msg_Count OUT NOCOPY NUMBER,
4984: X_Msg_Data OUT NOCOPY VARCHAR2
4985: )
4995:
4996: -- Initialize API return status to SUCCESS
4997: x_return_status := FND_API.G_RET_STS_SUCCESS;
4998:
4999: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5000: THEN
5001: -- Hint: Validate data
5002: -- IF p_ENCUMBRANCE_ACCOUNT is not NULL and p_ENCUMBRANCE_ACCOUNT <> G_MISS_CHAR
5003: -- verify if data is valid
5002: -- IF p_ENCUMBRANCE_ACCOUNT is not NULL and p_ENCUMBRANCE_ACCOUNT <> G_MISS_CHAR
5003: -- verify if data is valid
5004: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5005: NULL;
5006: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5007: THEN
5008: -- Hint: Validate data
5009: -- IF p_ENCUMBRANCE_ACCOUNT <> G_MISS_CHAR
5010: -- verify if data is valid
5024: PROCEDURE Validate_ENCUMBRANCE_AMOUNT (
5025: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5026: P_Validation_mode IN VARCHAR2,
5027: P_ENCUMBRANCE_AMOUNT IN NUMBER,
5028: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5029: X_Return_Status OUT NOCOPY VARCHAR2,
5030: X_Msg_Count OUT NOCOPY NUMBER,
5031: X_Msg_Data OUT NOCOPY VARCHAR2
5032: )
5042:
5043: -- Initialize API return status to SUCCESS
5044: x_return_status := FND_API.G_RET_STS_SUCCESS;
5045:
5046: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5047: THEN
5048: -- Hint: Validate data
5049: -- IF p_ENCUMBRANCE_AMOUNT is not NULL and p_ENCUMBRANCE_AMOUNT <> G_MISS_CHAR
5050: -- verify if data is valid
5049: -- IF p_ENCUMBRANCE_AMOUNT is not NULL and p_ENCUMBRANCE_AMOUNT <> G_MISS_CHAR
5050: -- verify if data is valid
5051: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5052: NULL;
5053: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5054: THEN
5055: -- Hint: Validate data
5056: -- IF p_ENCUMBRANCE_AMOUNT <> G_MISS_CHAR
5057: -- verify if data is valid
5071: PROCEDURE Validate_SHIP_TO_LOCATION (
5072: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5073: P_Validation_mode IN VARCHAR2,
5074: P_SHIP_TO_LOCATION IN NUMBER,
5075: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5076: X_Return_Status OUT NOCOPY VARCHAR2,
5077: X_Msg_Count OUT NOCOPY NUMBER,
5078: X_Msg_Data OUT NOCOPY VARCHAR2
5079: )
5089:
5090: -- Initialize API return status to SUCCESS
5091: x_return_status := FND_API.G_RET_STS_SUCCESS;
5092:
5093: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5094: THEN
5095: -- Hint: Validate data
5096: -- IF p_SHIP_TO_LOCATION is not NULL and p_SHIP_TO_LOCATION <> G_MISS_CHAR
5097: -- verify if data is valid
5096: -- IF p_SHIP_TO_LOCATION is not NULL and p_SHIP_TO_LOCATION <> G_MISS_CHAR
5097: -- verify if data is valid
5098: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5099: NULL;
5100: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5101: THEN
5102: -- Hint: Validate data
5103: -- IF p_SHIP_TO_LOCATION <> G_MISS_CHAR
5104: -- verify if data is valid
5118: PROCEDURE Validate_SHIPMENT_NUMBER (
5119: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5120: P_Validation_mode IN VARCHAR2,
5121: P_SHIPMENT_NUMBER IN VARCHAR2,
5122: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5123: X_Return_Status OUT NOCOPY VARCHAR2,
5124: X_Msg_Count OUT NOCOPY NUMBER,
5125: X_Msg_Data OUT NOCOPY VARCHAR2
5126: )
5136:
5137: -- Initialize API return status to SUCCESS
5138: x_return_status := FND_API.G_RET_STS_SUCCESS;
5139:
5140: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5141: THEN
5142: -- Hint: Validate data
5143: -- IF p_SHIPMENT_NUMBER is not NULL and p_SHIPMENT_NUMBER <> G_MISS_CHAR
5144: -- verify if data is valid
5143: -- IF p_SHIPMENT_NUMBER is not NULL and p_SHIPMENT_NUMBER <> G_MISS_CHAR
5144: -- verify if data is valid
5145: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5146: NULL;
5147: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5148: THEN
5149: -- Hint: Validate data
5150: -- IF p_SHIPMENT_NUMBER <> G_MISS_CHAR
5151: -- verify if data is valid
5165: PROCEDURE Validate_TRANSFER_COST (
5166: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5167: P_Validation_mode IN VARCHAR2,
5168: P_TRANSFER_COST IN NUMBER,
5169: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5170: X_Return_Status OUT NOCOPY VARCHAR2,
5171: X_Msg_Count OUT NOCOPY NUMBER,
5172: X_Msg_Data OUT NOCOPY VARCHAR2
5173: )
5183:
5184: -- Initialize API return status to SUCCESS
5185: x_return_status := FND_API.G_RET_STS_SUCCESS;
5186:
5187: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5188: THEN
5189: -- Hint: Validate data
5190: -- IF p_TRANSFER_COST is not NULL and p_TRANSFER_COST <> G_MISS_CHAR
5191: -- verify if data is valid
5190: -- IF p_TRANSFER_COST is not NULL and p_TRANSFER_COST <> G_MISS_CHAR
5191: -- verify if data is valid
5192: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5193: NULL;
5194: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5195: THEN
5196: -- Hint: Validate data
5197: -- IF p_TRANSFER_COST <> G_MISS_CHAR
5198: -- verify if data is valid
5212: PROCEDURE Validate_TRANSPORTATION_COST (
5213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5214: P_Validation_mode IN VARCHAR2,
5215: P_TRANSPORTATION_COST IN NUMBER,
5216: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5217: X_Return_Status OUT NOCOPY VARCHAR2,
5218: X_Msg_Count OUT NOCOPY NUMBER,
5219: X_Msg_Data OUT NOCOPY VARCHAR2
5220: )
5230:
5231: -- Initialize API return status to SUCCESS
5232: x_return_status := FND_API.G_RET_STS_SUCCESS;
5233:
5234: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5235: THEN
5236: -- Hint: Validate data
5237: -- IF p_TRANSPORTATION_COST is not NULL and p_TRANSPORTATION_COST <> G_MISS_CHAR
5238: -- verify if data is valid
5237: -- IF p_TRANSPORTATION_COST is not NULL and p_TRANSPORTATION_COST <> G_MISS_CHAR
5238: -- verify if data is valid
5239: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5240: NULL;
5241: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5242: THEN
5243: -- Hint: Validate data
5244: -- IF p_TRANSPORTATION_COST <> G_MISS_CHAR
5245: -- verify if data is valid
5259: PROCEDURE Validate_TRANSPORTATION_ACCOUNT (
5260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5261: P_Validation_mode IN VARCHAR2,
5262: P_TRANSPORTATION_ACCOUNT IN NUMBER,
5263: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5264: X_Return_Status OUT NOCOPY VARCHAR2,
5265: X_Msg_Count OUT NOCOPY NUMBER,
5266: X_Msg_Data OUT NOCOPY VARCHAR2
5267: )
5277:
5278: -- Initialize API return status to SUCCESS
5279: x_return_status := FND_API.G_RET_STS_SUCCESS;
5280:
5281: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5282: THEN
5283: -- Hint: Validate data
5284: -- IF p_TRANSPORTATION_ACCOUNT is not NULL and p_TRANSPORTATION_ACCOUNT <> G_MISS_CHAR
5285: -- verify if data is valid
5284: -- IF p_TRANSPORTATION_ACCOUNT is not NULL and p_TRANSPORTATION_ACCOUNT <> G_MISS_CHAR
5285: -- verify if data is valid
5286: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5287: NULL;
5288: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5289: THEN
5290: -- Hint: Validate data
5291: -- IF p_TRANSPORTATION_ACCOUNT <> G_MISS_CHAR
5292: -- verify if data is valid
5306: PROCEDURE Validate_FREIGHT_CODE (
5307: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5308: P_Validation_mode IN VARCHAR2,
5309: P_FREIGHT_CODE IN VARCHAR2,
5310: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5311: X_Return_Status OUT NOCOPY VARCHAR2,
5312: X_Msg_Count OUT NOCOPY NUMBER,
5313: X_Msg_Data OUT NOCOPY VARCHAR2
5314: )
5324:
5325: -- Initialize API return status to SUCCESS
5326: x_return_status := FND_API.G_RET_STS_SUCCESS;
5327:
5328: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5329: THEN
5330: -- Hint: Validate data
5331: -- IF p_FREIGHT_CODE is not NULL and p_FREIGHT_CODE <> G_MISS_CHAR
5332: -- verify if data is valid
5331: -- IF p_FREIGHT_CODE is not NULL and p_FREIGHT_CODE <> G_MISS_CHAR
5332: -- verify if data is valid
5333: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5334: NULL;
5335: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5336: THEN
5337: -- Hint: Validate data
5338: -- IF p_FREIGHT_CODE <> G_MISS_CHAR
5339: -- verify if data is valid
5353: PROCEDURE Validate_CONTAINERS (
5354: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5355: P_Validation_mode IN VARCHAR2,
5356: P_CONTAINERS IN NUMBER,
5357: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5358: X_Return_Status OUT NOCOPY VARCHAR2,
5359: X_Msg_Count OUT NOCOPY NUMBER,
5360: X_Msg_Data OUT NOCOPY VARCHAR2
5361: )
5371:
5372: -- Initialize API return status to SUCCESS
5373: x_return_status := FND_API.G_RET_STS_SUCCESS;
5374:
5375: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5376: THEN
5377: -- Hint: Validate data
5378: -- IF p_CONTAINERS is not NULL and p_CONTAINERS <> G_MISS_CHAR
5379: -- verify if data is valid
5378: -- IF p_CONTAINERS is not NULL and p_CONTAINERS <> G_MISS_CHAR
5379: -- verify if data is valid
5380: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5381: NULL;
5382: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5383: THEN
5384: -- Hint: Validate data
5385: -- IF p_CONTAINERS <> G_MISS_CHAR
5386: -- verify if data is valid
5400: PROCEDURE Validate_WAYBILL_AIRBILL (
5401: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5402: P_Validation_mode IN VARCHAR2,
5403: P_WAYBILL_AIRBILL IN VARCHAR2,
5404: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5405: X_Return_Status OUT NOCOPY VARCHAR2,
5406: X_Msg_Count OUT NOCOPY NUMBER,
5407: X_Msg_Data OUT NOCOPY VARCHAR2
5408: )
5418:
5419: -- Initialize API return status to SUCCESS
5420: x_return_status := FND_API.G_RET_STS_SUCCESS;
5421:
5422: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5423: THEN
5424: -- Hint: Validate data
5425: -- IF p_WAYBILL_AIRBILL is not NULL and p_WAYBILL_AIRBILL <> G_MISS_CHAR
5426: -- verify if data is valid
5425: -- IF p_WAYBILL_AIRBILL is not NULL and p_WAYBILL_AIRBILL <> G_MISS_CHAR
5426: -- verify if data is valid
5427: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5428: NULL;
5429: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5430: THEN
5431: -- Hint: Validate data
5432: -- IF p_WAYBILL_AIRBILL <> G_MISS_CHAR
5433: -- verify if data is valid
5447: PROCEDURE Validate_EXPECTED_ARRIVAL_DATE (
5448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5449: P_Validation_mode IN VARCHAR2,
5450: P_EXPECTED_ARRIVAL_DATE IN DATE,
5451: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5452: X_Return_Status OUT NOCOPY VARCHAR2,
5453: X_Msg_Count OUT NOCOPY NUMBER,
5454: X_Msg_Data OUT NOCOPY VARCHAR2
5455: )
5465:
5466: -- Initialize API return status to SUCCESS
5467: x_return_status := FND_API.G_RET_STS_SUCCESS;
5468:
5469: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5470: THEN
5471: -- Hint: Validate data
5472: -- IF p_EXPECTED_ARRIVAL_DATE is not NULL and p_EXPECTED_ARRIVAL_DATE <> G_MISS_CHAR
5473: -- verify if data is valid
5472: -- IF p_EXPECTED_ARRIVAL_DATE is not NULL and p_EXPECTED_ARRIVAL_DATE <> G_MISS_CHAR
5473: -- verify if data is valid
5474: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5475: NULL;
5476: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5477: THEN
5478: -- Hint: Validate data
5479: -- IF p_EXPECTED_ARRIVAL_DATE <> G_MISS_CHAR
5480: -- verify if data is valid
5494: PROCEDURE Validate_TRANSFER_SUBINVENTORY (
5495: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5496: P_Validation_mode IN VARCHAR2,
5497: P_TRANSFER_SUBINVENTORY IN VARCHAR2,
5498: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5499: X_Return_Status OUT NOCOPY VARCHAR2,
5500: X_Msg_Count OUT NOCOPY NUMBER,
5501: X_Msg_Data OUT NOCOPY VARCHAR2
5502: )
5512:
5513: -- Initialize API return status to SUCCESS
5514: x_return_status := FND_API.G_RET_STS_SUCCESS;
5515:
5516: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5517: THEN
5518: -- Hint: Validate data
5519: -- IF p_TRANSFER_SUBINVENTORY is not NULL and p_TRANSFER_SUBINVENTORY <> G_MISS_CHAR
5520: -- verify if data is valid
5519: -- IF p_TRANSFER_SUBINVENTORY is not NULL and p_TRANSFER_SUBINVENTORY <> G_MISS_CHAR
5520: -- verify if data is valid
5521: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5522: NULL;
5523: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5524: THEN
5525: -- Hint: Validate data
5526: -- IF p_TRANSFER_SUBINVENTORY <> G_MISS_CHAR
5527: -- verify if data is valid
5541: PROCEDURE Validate_TRANSFER_ORGANIZATION (
5542: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5543: P_Validation_mode IN VARCHAR2,
5544: P_TRANSFER_ORGANIZATION IN NUMBER,
5545: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5546: X_Return_Status OUT NOCOPY VARCHAR2,
5547: X_Msg_Count OUT NOCOPY NUMBER,
5548: X_Msg_Data OUT NOCOPY VARCHAR2
5549: )
5559:
5560: -- Initialize API return status to SUCCESS
5561: x_return_status := FND_API.G_RET_STS_SUCCESS;
5562:
5563: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5564: THEN
5565: -- Hint: Validate data
5566: -- IF p_TRANSFER_ORGANIZATION is not NULL and p_TRANSFER_ORGANIZATION <> G_MISS_CHAR
5567: -- verify if data is valid
5566: -- IF p_TRANSFER_ORGANIZATION is not NULL and p_TRANSFER_ORGANIZATION <> G_MISS_CHAR
5567: -- verify if data is valid
5568: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5569: NULL;
5570: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5571: THEN
5572: -- Hint: Validate data
5573: -- IF p_TRANSFER_ORGANIZATION <> G_MISS_CHAR
5574: -- verify if data is valid
5588: PROCEDURE Validate_TRANSFER_TO_LOCATION (
5589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5590: P_Validation_mode IN VARCHAR2,
5591: P_TRANSFER_TO_LOCATION IN NUMBER,
5592: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5593: X_Return_Status OUT NOCOPY VARCHAR2,
5594: X_Msg_Count OUT NOCOPY NUMBER,
5595: X_Msg_Data OUT NOCOPY VARCHAR2
5596: )
5606:
5607: -- Initialize API return status to SUCCESS
5608: x_return_status := FND_API.G_RET_STS_SUCCESS;
5609:
5610: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5611: THEN
5612: -- Hint: Validate data
5613: -- IF p_TRANSFER_TO_LOCATION is not NULL and p_TRANSFER_TO_LOCATION <> G_MISS_CHAR
5614: -- verify if data is valid
5613: -- IF p_TRANSFER_TO_LOCATION is not NULL and p_TRANSFER_TO_LOCATION <> G_MISS_CHAR
5614: -- verify if data is valid
5615: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5616: NULL;
5617: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5618: THEN
5619: -- Hint: Validate data
5620: -- IF p_TRANSFER_TO_LOCATION <> G_MISS_CHAR
5621: -- verify if data is valid
5635: PROCEDURE Validate_NEW_AVERAGE_COST (
5636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5637: P_Validation_mode IN VARCHAR2,
5638: P_NEW_AVERAGE_COST IN NUMBER,
5639: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5640: X_Return_Status OUT NOCOPY VARCHAR2,
5641: X_Msg_Count OUT NOCOPY NUMBER,
5642: X_Msg_Data OUT NOCOPY VARCHAR2
5643: )
5653:
5654: -- Initialize API return status to SUCCESS
5655: x_return_status := FND_API.G_RET_STS_SUCCESS;
5656:
5657: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5658: THEN
5659: -- Hint: Validate data
5660: -- IF p_NEW_AVERAGE_COST is not NULL and p_NEW_AVERAGE_COST <> G_MISS_CHAR
5661: -- verify if data is valid
5660: -- IF p_NEW_AVERAGE_COST is not NULL and p_NEW_AVERAGE_COST <> G_MISS_CHAR
5661: -- verify if data is valid
5662: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5663: NULL;
5664: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5665: THEN
5666: -- Hint: Validate data
5667: -- IF p_NEW_AVERAGE_COST <> G_MISS_CHAR
5668: -- verify if data is valid
5682: PROCEDURE Validate_VALUE_CHANGE (
5683: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5684: P_Validation_mode IN VARCHAR2,
5685: P_VALUE_CHANGE IN NUMBER,
5686: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5687: X_Return_Status OUT NOCOPY VARCHAR2,
5688: X_Msg_Count OUT NOCOPY NUMBER,
5689: X_Msg_Data OUT NOCOPY VARCHAR2
5690: )
5700:
5701: -- Initialize API return status to SUCCESS
5702: x_return_status := FND_API.G_RET_STS_SUCCESS;
5703:
5704: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5705: THEN
5706: -- Hint: Validate data
5707: -- IF p_VALUE_CHANGE is not NULL and p_VALUE_CHANGE <> G_MISS_CHAR
5708: -- verify if data is valid
5707: -- IF p_VALUE_CHANGE is not NULL and p_VALUE_CHANGE <> G_MISS_CHAR
5708: -- verify if data is valid
5709: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5710: NULL;
5711: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5712: THEN
5713: -- Hint: Validate data
5714: -- IF p_VALUE_CHANGE <> G_MISS_CHAR
5715: -- verify if data is valid
5729: PROCEDURE Validate_PERCENTAGE_CHANGE (
5730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5731: P_Validation_mode IN VARCHAR2,
5732: P_PERCENTAGE_CHANGE IN NUMBER,
5733: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5734: X_Return_Status OUT NOCOPY VARCHAR2,
5735: X_Msg_Count OUT NOCOPY NUMBER,
5736: X_Msg_Data OUT NOCOPY VARCHAR2
5737: )
5747:
5748: -- Initialize API return status to SUCCESS
5749: x_return_status := FND_API.G_RET_STS_SUCCESS;
5750:
5751: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5752: THEN
5753: -- Hint: Validate data
5754: -- IF p_PERCENTAGE_CHANGE is not NULL and p_PERCENTAGE_CHANGE <> G_MISS_CHAR
5755: -- verify if data is valid
5754: -- IF p_PERCENTAGE_CHANGE is not NULL and p_PERCENTAGE_CHANGE <> G_MISS_CHAR
5755: -- verify if data is valid
5756: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5757: NULL;
5758: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5759: THEN
5760: -- Hint: Validate data
5761: -- IF p_PERCENTAGE_CHANGE <> G_MISS_CHAR
5762: -- verify if data is valid
5776: PROCEDURE Validate_MATERIAL_ALLOCATION_TEMP_ID (
5777: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5778: P_Validation_mode IN VARCHAR2,
5779: P_MATERIAL_ALLOCATION_TEMP_ID IN NUMBER,
5780: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5781: X_Return_Status OUT NOCOPY VARCHAR2,
5782: X_Msg_Count OUT NOCOPY NUMBER,
5783: X_Msg_Data OUT NOCOPY VARCHAR2
5784: )
5794:
5795: -- Initialize API return status to SUCCESS
5796: x_return_status := FND_API.G_RET_STS_SUCCESS;
5797:
5798: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5799: THEN
5800: -- Hint: Validate data
5801: -- IF p_MATERIAL_ALLOCATION_TEMP_ID is not NULL and p_MATERIAL_ALLOCATION_TEMP_ID <> G_MISS_CHAR
5802: -- verify if data is valid
5801: -- IF p_MATERIAL_ALLOCATION_TEMP_ID is not NULL and p_MATERIAL_ALLOCATION_TEMP_ID <> G_MISS_CHAR
5802: -- verify if data is valid
5803: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5804: NULL;
5805: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5806: THEN
5807: -- Hint: Validate data
5808: -- IF p_MATERIAL_ALLOCATION_TEMP_ID <> G_MISS_CHAR
5809: -- verify if data is valid
5823: PROCEDURE Validate_DEMAND_SOURCE_HEADER_ID (
5824: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5825: P_Validation_mode IN VARCHAR2,
5826: P_DEMAND_SOURCE_HEADER_ID IN NUMBER,
5827: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5828: X_Return_Status OUT NOCOPY VARCHAR2,
5829: X_Msg_Count OUT NOCOPY NUMBER,
5830: X_Msg_Data OUT NOCOPY VARCHAR2
5831: )
5841:
5842: -- Initialize API return status to SUCCESS
5843: x_return_status := FND_API.G_RET_STS_SUCCESS;
5844:
5845: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5846: THEN
5847: -- Hint: Validate data
5848: -- IF p_DEMAND_SOURCE_HEADER_ID is not NULL and p_DEMAND_SOURCE_HEADER_ID <> G_MISS_CHAR
5849: -- verify if data is valid
5848: -- IF p_DEMAND_SOURCE_HEADER_ID is not NULL and p_DEMAND_SOURCE_HEADER_ID <> G_MISS_CHAR
5849: -- verify if data is valid
5850: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5851: NULL;
5852: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5853: THEN
5854: -- Hint: Validate data
5855: -- IF p_DEMAND_SOURCE_HEADER_ID <> G_MISS_CHAR
5856: -- verify if data is valid
5870: PROCEDURE Validate_DEMAND_SOURCE_LINE (
5871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5872: P_Validation_mode IN VARCHAR2,
5873: P_DEMAND_SOURCE_LINE IN VARCHAR2,
5874: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5875: X_Return_Status OUT NOCOPY VARCHAR2,
5876: X_Msg_Count OUT NOCOPY NUMBER,
5877: X_Msg_Data OUT NOCOPY VARCHAR2
5878: )
5888:
5889: -- Initialize API return status to SUCCESS
5890: x_return_status := FND_API.G_RET_STS_SUCCESS;
5891:
5892: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5893: THEN
5894: -- Hint: Validate data
5895: -- IF p_DEMAND_SOURCE_LINE is not NULL and p_DEMAND_SOURCE_LINE <> G_MISS_CHAR
5896: -- verify if data is valid
5895: -- IF p_DEMAND_SOURCE_LINE is not NULL and p_DEMAND_SOURCE_LINE <> G_MISS_CHAR
5896: -- verify if data is valid
5897: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5898: NULL;
5899: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5900: THEN
5901: -- Hint: Validate data
5902: -- IF p_DEMAND_SOURCE_LINE <> G_MISS_CHAR
5903: -- verify if data is valid
5917: PROCEDURE Validate_DEMAND_SOURCE_DELIVERY (
5918: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5919: P_Validation_mode IN VARCHAR2,
5920: P_DEMAND_SOURCE_DELIVERY IN VARCHAR2,
5921: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5922: X_Return_Status OUT NOCOPY VARCHAR2,
5923: X_Msg_Count OUT NOCOPY NUMBER,
5924: X_Msg_Data OUT NOCOPY VARCHAR2
5925: )
5935:
5936: -- Initialize API return status to SUCCESS
5937: x_return_status := FND_API.G_RET_STS_SUCCESS;
5938:
5939: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5940: THEN
5941: -- Hint: Validate data
5942: -- IF p_DEMAND_SOURCE_DELIVERY is not NULL and p_DEMAND_SOURCE_DELIVERY <> G_MISS_CHAR
5943: -- verify if data is valid
5942: -- IF p_DEMAND_SOURCE_DELIVERY is not NULL and p_DEMAND_SOURCE_DELIVERY <> G_MISS_CHAR
5943: -- verify if data is valid
5944: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5945: NULL;
5946: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5947: THEN
5948: -- Hint: Validate data
5949: -- IF p_DEMAND_SOURCE_DELIVERY <> G_MISS_CHAR
5950: -- verify if data is valid
5964: PROCEDURE Validate_ITEM_SEGMENTS (
5965: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5966: P_Validation_mode IN VARCHAR2,
5967: P_ITEM_SEGMENTS IN VARCHAR2,
5968: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
5969: X_Return_Status OUT NOCOPY VARCHAR2,
5970: X_Msg_Count OUT NOCOPY NUMBER,
5971: X_Msg_Data OUT NOCOPY VARCHAR2
5972: )
5982:
5983: -- Initialize API return status to SUCCESS
5984: x_return_status := FND_API.G_RET_STS_SUCCESS;
5985:
5986: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
5987: THEN
5988: -- Hint: Validate data
5989: -- IF p_ITEM_SEGMENTS is not NULL and p_ITEM_SEGMENTS <> G_MISS_CHAR
5990: -- verify if data is valid
5989: -- IF p_ITEM_SEGMENTS is not NULL and p_ITEM_SEGMENTS <> G_MISS_CHAR
5990: -- verify if data is valid
5991: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5992: NULL;
5993: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
5994: THEN
5995: -- Hint: Validate data
5996: -- IF p_ITEM_SEGMENTS <> G_MISS_CHAR
5997: -- verify if data is valid
6011: PROCEDURE Validate_ITEM_DESCRIPTION (
6012: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6013: P_Validation_mode IN VARCHAR2,
6014: P_ITEM_DESCRIPTION IN VARCHAR2,
6015: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6016: X_Return_Status OUT NOCOPY VARCHAR2,
6017: X_Msg_Count OUT NOCOPY NUMBER,
6018: X_Msg_Data OUT NOCOPY VARCHAR2
6019: )
6029:
6030: -- Initialize API return status to SUCCESS
6031: x_return_status := FND_API.G_RET_STS_SUCCESS;
6032:
6033: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6034: THEN
6035: -- Hint: Validate data
6036: -- IF p_ITEM_DESCRIPTION is not NULL and p_ITEM_DESCRIPTION <> G_MISS_CHAR
6037: -- verify if data is valid
6036: -- IF p_ITEM_DESCRIPTION is not NULL and p_ITEM_DESCRIPTION <> G_MISS_CHAR
6037: -- verify if data is valid
6038: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6039: NULL;
6040: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6041: THEN
6042: -- Hint: Validate data
6043: -- IF p_ITEM_DESCRIPTION <> G_MISS_CHAR
6044: -- verify if data is valid
6058: PROCEDURE Validate_ITEM_TRX_ENABLED_FLAG (
6059: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6060: P_Validation_mode IN VARCHAR2,
6061: P_ITEM_TRX_ENABLED_FLAG IN VARCHAR2,
6062: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6063: X_Return_Status OUT NOCOPY VARCHAR2,
6064: X_Msg_Count OUT NOCOPY NUMBER,
6065: X_Msg_Data OUT NOCOPY VARCHAR2
6066: )
6076:
6077: -- Initialize API return status to SUCCESS
6078: x_return_status := FND_API.G_RET_STS_SUCCESS;
6079:
6080: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6081: THEN
6082: -- Hint: Validate data
6083: -- IF p_ITEM_TRX_ENABLED_FLAG is not NULL and p_ITEM_TRX_ENABLED_FLAG <> G_MISS_CHAR
6084: -- verify if data is valid
6083: -- IF p_ITEM_TRX_ENABLED_FLAG is not NULL and p_ITEM_TRX_ENABLED_FLAG <> G_MISS_CHAR
6084: -- verify if data is valid
6085: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6086: NULL;
6087: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6088: THEN
6089: -- Hint: Validate data
6090: -- IF p_ITEM_TRX_ENABLED_FLAG <> G_MISS_CHAR
6091: -- verify if data is valid
6105: PROCEDURE Validate_ITEM_LOCATION_CONTROL_CODE (
6106: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6107: P_Validation_mode IN VARCHAR2,
6108: P_ITEM_LOCATION_CONTROL_CODE IN NUMBER,
6109: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6110: X_Return_Status OUT NOCOPY VARCHAR2,
6111: X_Msg_Count OUT NOCOPY NUMBER,
6112: X_Msg_Data OUT NOCOPY VARCHAR2
6113: )
6123:
6124: -- Initialize API return status to SUCCESS
6125: x_return_status := FND_API.G_RET_STS_SUCCESS;
6126:
6127: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6128: THEN
6129: -- Hint: Validate data
6130: -- IF p_ITEM_LOCATION_CONTROL_CODE is not NULL and p_ITEM_LOCATION_CONTROL_CODE <> G_MISS_CHAR
6131: -- verify if data is valid
6130: -- IF p_ITEM_LOCATION_CONTROL_CODE is not NULL and p_ITEM_LOCATION_CONTROL_CODE <> G_MISS_CHAR
6131: -- verify if data is valid
6132: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6133: NULL;
6134: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6135: THEN
6136: -- Hint: Validate data
6137: -- IF p_ITEM_LOCATION_CONTROL_CODE <> G_MISS_CHAR
6138: -- verify if data is valid
6152: PROCEDURE Validate_ITEM_RESTRICT_SUBINV_CODE (
6153: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6154: P_Validation_mode IN VARCHAR2,
6155: P_ITEM_RESTRICT_SUBINV_CODE IN NUMBER,
6156: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6157: X_Return_Status OUT NOCOPY VARCHAR2,
6158: X_Msg_Count OUT NOCOPY NUMBER,
6159: X_Msg_Data OUT NOCOPY VARCHAR2
6160: )
6170:
6171: -- Initialize API return status to SUCCESS
6172: x_return_status := FND_API.G_RET_STS_SUCCESS;
6173:
6174: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6175: THEN
6176: -- Hint: Validate data
6177: -- IF p_ITEM_RESTRICT_SUBINV_CODE is not NULL and p_ITEM_RESTRICT_SUBINV_CODE <> G_MISS_CHAR
6178: -- verify if data is valid
6177: -- IF p_ITEM_RESTRICT_SUBINV_CODE is not NULL and p_ITEM_RESTRICT_SUBINV_CODE <> G_MISS_CHAR
6178: -- verify if data is valid
6179: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6180: NULL;
6181: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6182: THEN
6183: -- Hint: Validate data
6184: -- IF p_ITEM_RESTRICT_SUBINV_CODE <> G_MISS_CHAR
6185: -- verify if data is valid
6199: PROCEDURE Validate_ITEM_RESTRICT_LOCATORS_CODE (
6200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6201: P_Validation_mode IN VARCHAR2,
6202: P_ITEM_RESTRICT_LOCATORS_CODE IN NUMBER,
6203: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6204: X_Return_Status OUT NOCOPY VARCHAR2,
6205: X_Msg_Count OUT NOCOPY NUMBER,
6206: X_Msg_Data OUT NOCOPY VARCHAR2
6207: )
6217:
6218: -- Initialize API return status to SUCCESS
6219: x_return_status := FND_API.G_RET_STS_SUCCESS;
6220:
6221: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6222: THEN
6223: -- Hint: Validate data
6224: -- IF p_ITEM_RESTRICT_LOCATORS_CODE is not NULL and p_ITEM_RESTRICT_LOCATORS_CODE <> G_MISS_CHAR
6225: -- verify if data is valid
6224: -- IF p_ITEM_RESTRICT_LOCATORS_CODE is not NULL and p_ITEM_RESTRICT_LOCATORS_CODE <> G_MISS_CHAR
6225: -- verify if data is valid
6226: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6227: NULL;
6228: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6229: THEN
6230: -- Hint: Validate data
6231: -- IF p_ITEM_RESTRICT_LOCATORS_CODE <> G_MISS_CHAR
6232: -- verify if data is valid
6246: PROCEDURE Validate_ITEM_REVISION_QTY_CONTROL_CODE (
6247: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6248: P_Validation_mode IN VARCHAR2,
6249: P_ITEM_REVISION_QTY_CONTROL_CODE IN NUMBER,
6250: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6251: X_Return_Status OUT NOCOPY VARCHAR2,
6252: X_Msg_Count OUT NOCOPY NUMBER,
6253: X_Msg_Data OUT NOCOPY VARCHAR2
6254: )
6264:
6265: -- Initialize API return status to SUCCESS
6266: x_return_status := FND_API.G_RET_STS_SUCCESS;
6267:
6268: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6269: THEN
6270: -- Hint: Validate data
6271: -- IF p_ITEM_REVISION_QTY_CONTROL_CODE is not NULL and p_ITEM_REVISION_QTY_CONTROL_CODE <> G_MISS_CHAR
6272: -- verify if data is valid
6271: -- IF p_ITEM_REVISION_QTY_CONTROL_CODE is not NULL and p_ITEM_REVISION_QTY_CONTROL_CODE <> G_MISS_CHAR
6272: -- verify if data is valid
6273: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6274: NULL;
6275: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6276: THEN
6277: -- Hint: Validate data
6278: -- IF p_ITEM_REVISION_QTY_CONTROL_CODE <> G_MISS_CHAR
6279: -- verify if data is valid
6293: PROCEDURE Validate_ITEM_PRIMARY_UOM_CODE (
6294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6295: P_Validation_mode IN VARCHAR2,
6296: P_ITEM_PRIMARY_UOM_CODE IN VARCHAR2,
6297: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6298: X_Return_Status OUT NOCOPY VARCHAR2,
6299: X_Msg_Count OUT NOCOPY NUMBER,
6300: X_Msg_Data OUT NOCOPY VARCHAR2
6301: )
6311:
6312: -- Initialize API return status to SUCCESS
6313: x_return_status := FND_API.G_RET_STS_SUCCESS;
6314:
6315: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6316: THEN
6317: -- Hint: Validate data
6318: -- IF p_ITEM_PRIMARY_UOM_CODE is not NULL and p_ITEM_PRIMARY_UOM_CODE <> G_MISS_CHAR
6319: -- verify if data is valid
6318: -- IF p_ITEM_PRIMARY_UOM_CODE is not NULL and p_ITEM_PRIMARY_UOM_CODE <> G_MISS_CHAR
6319: -- verify if data is valid
6320: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6321: NULL;
6322: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6323: THEN
6324: -- Hint: Validate data
6325: -- IF p_ITEM_PRIMARY_UOM_CODE <> G_MISS_CHAR
6326: -- verify if data is valid
6340: PROCEDURE Validate_ITEM_UOM_CLASS (
6341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6342: P_Validation_mode IN VARCHAR2,
6343: P_ITEM_UOM_CLASS IN VARCHAR2,
6344: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6345: X_Return_Status OUT NOCOPY VARCHAR2,
6346: X_Msg_Count OUT NOCOPY NUMBER,
6347: X_Msg_Data OUT NOCOPY VARCHAR2
6348: )
6358:
6359: -- Initialize API return status to SUCCESS
6360: x_return_status := FND_API.G_RET_STS_SUCCESS;
6361:
6362: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6363: THEN
6364: -- Hint: Validate data
6365: -- IF p_ITEM_UOM_CLASS is not NULL and p_ITEM_UOM_CLASS <> G_MISS_CHAR
6366: -- verify if data is valid
6365: -- IF p_ITEM_UOM_CLASS is not NULL and p_ITEM_UOM_CLASS <> G_MISS_CHAR
6366: -- verify if data is valid
6367: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6368: NULL;
6369: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6370: THEN
6371: -- Hint: Validate data
6372: -- IF p_ITEM_UOM_CLASS <> G_MISS_CHAR
6373: -- verify if data is valid
6387: PROCEDURE Validate_ITEM_SHELF_LIFE_CODE (
6388: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6389: P_Validation_mode IN VARCHAR2,
6390: P_ITEM_SHELF_LIFE_CODE IN NUMBER,
6391: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6392: X_Return_Status OUT NOCOPY VARCHAR2,
6393: X_Msg_Count OUT NOCOPY NUMBER,
6394: X_Msg_Data OUT NOCOPY VARCHAR2
6395: )
6405:
6406: -- Initialize API return status to SUCCESS
6407: x_return_status := FND_API.G_RET_STS_SUCCESS;
6408:
6409: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6410: THEN
6411: -- Hint: Validate data
6412: -- IF p_ITEM_SHELF_LIFE_CODE is not NULL and p_ITEM_SHELF_LIFE_CODE <> G_MISS_CHAR
6413: -- verify if data is valid
6412: -- IF p_ITEM_SHELF_LIFE_CODE is not NULL and p_ITEM_SHELF_LIFE_CODE <> G_MISS_CHAR
6413: -- verify if data is valid
6414: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6415: NULL;
6416: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6417: THEN
6418: -- Hint: Validate data
6419: -- IF p_ITEM_SHELF_LIFE_CODE <> G_MISS_CHAR
6420: -- verify if data is valid
6434: PROCEDURE Validate_ITEM_SHELF_LIFE_DAYS (
6435: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6436: P_Validation_mode IN VARCHAR2,
6437: P_ITEM_SHELF_LIFE_DAYS IN NUMBER,
6438: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6439: X_Return_Status OUT NOCOPY VARCHAR2,
6440: X_Msg_Count OUT NOCOPY NUMBER,
6441: X_Msg_Data OUT NOCOPY VARCHAR2
6442: )
6452:
6453: -- Initialize API return status to SUCCESS
6454: x_return_status := FND_API.G_RET_STS_SUCCESS;
6455:
6456: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6457: THEN
6458: -- Hint: Validate data
6459: -- IF p_ITEM_SHELF_LIFE_DAYS is not NULL and p_ITEM_SHELF_LIFE_DAYS <> G_MISS_CHAR
6460: -- verify if data is valid
6459: -- IF p_ITEM_SHELF_LIFE_DAYS is not NULL and p_ITEM_SHELF_LIFE_DAYS <> G_MISS_CHAR
6460: -- verify if data is valid
6461: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6462: NULL;
6463: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6464: THEN
6465: -- Hint: Validate data
6466: -- IF p_ITEM_SHELF_LIFE_DAYS <> G_MISS_CHAR
6467: -- verify if data is valid
6481: PROCEDURE Validate_ITEM_LOT_CONTROL_CODE (
6482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6483: P_Validation_mode IN VARCHAR2,
6484: P_ITEM_LOT_CONTROL_CODE IN NUMBER,
6485: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6486: X_Return_Status OUT NOCOPY VARCHAR2,
6487: X_Msg_Count OUT NOCOPY NUMBER,
6488: X_Msg_Data OUT NOCOPY VARCHAR2
6489: )
6499:
6500: -- Initialize API return status to SUCCESS
6501: x_return_status := FND_API.G_RET_STS_SUCCESS;
6502:
6503: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6504: THEN
6505: -- Hint: Validate data
6506: -- IF p_ITEM_LOT_CONTROL_CODE is not NULL and p_ITEM_LOT_CONTROL_CODE <> G_MISS_CHAR
6507: -- verify if data is valid
6506: -- IF p_ITEM_LOT_CONTROL_CODE is not NULL and p_ITEM_LOT_CONTROL_CODE <> G_MISS_CHAR
6507: -- verify if data is valid
6508: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6509: NULL;
6510: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6511: THEN
6512: -- Hint: Validate data
6513: -- IF p_ITEM_LOT_CONTROL_CODE <> G_MISS_CHAR
6514: -- verify if data is valid
6528: PROCEDURE Validate_ITEM_SERIAL_CONTROL_CODE (
6529: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6530: P_Validation_mode IN VARCHAR2,
6531: P_ITEM_SERIAL_CONTROL_CODE IN NUMBER,
6532: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6533: X_Return_Status OUT NOCOPY VARCHAR2,
6534: X_Msg_Count OUT NOCOPY NUMBER,
6535: X_Msg_Data OUT NOCOPY VARCHAR2
6536: )
6546:
6547: -- Initialize API return status to SUCCESS
6548: x_return_status := FND_API.G_RET_STS_SUCCESS;
6549:
6550: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6551: THEN
6552: -- Hint: Validate data
6553: -- IF p_ITEM_SERIAL_CONTROL_CODE is not NULL and p_ITEM_SERIAL_CONTROL_CODE <> G_MISS_CHAR
6554: -- verify if data is valid
6553: -- IF p_ITEM_SERIAL_CONTROL_CODE is not NULL and p_ITEM_SERIAL_CONTROL_CODE <> G_MISS_CHAR
6554: -- verify if data is valid
6555: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6556: NULL;
6557: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6558: THEN
6559: -- Hint: Validate data
6560: -- IF p_ITEM_SERIAL_CONTROL_CODE <> G_MISS_CHAR
6561: -- verify if data is valid
6575: PROCEDURE Validate_ITEM_INVENTORY_ASSET_FLAG (
6576: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6577: P_Validation_mode IN VARCHAR2,
6578: P_ITEM_INVENTORY_ASSET_FLAG IN VARCHAR2,
6579: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6580: X_Return_Status OUT NOCOPY VARCHAR2,
6581: X_Msg_Count OUT NOCOPY NUMBER,
6582: X_Msg_Data OUT NOCOPY VARCHAR2
6583: )
6593:
6594: -- Initialize API return status to SUCCESS
6595: x_return_status := FND_API.G_RET_STS_SUCCESS;
6596:
6597: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6598: THEN
6599: -- Hint: Validate data
6600: -- IF p_ITEM_INVENTORY_ASSET_FLAG is not NULL and p_ITEM_INVENTORY_ASSET_FLAG <> G_MISS_CHAR
6601: -- verify if data is valid
6600: -- IF p_ITEM_INVENTORY_ASSET_FLAG is not NULL and p_ITEM_INVENTORY_ASSET_FLAG <> G_MISS_CHAR
6601: -- verify if data is valid
6602: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6603: NULL;
6604: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6605: THEN
6606: -- Hint: Validate data
6607: -- IF p_ITEM_INVENTORY_ASSET_FLAG <> G_MISS_CHAR
6608: -- verify if data is valid
6622: PROCEDURE Validate_ALLOWED_UNITS_LOOKUP_CODE (
6623: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6624: P_Validation_mode IN VARCHAR2,
6625: P_ALLOWED_UNITS_LOOKUP_CODE IN NUMBER,
6626: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6627: X_Return_Status OUT NOCOPY VARCHAR2,
6628: X_Msg_Count OUT NOCOPY NUMBER,
6629: X_Msg_Data OUT NOCOPY VARCHAR2
6630: )
6640:
6641: -- Initialize API return status to SUCCESS
6642: x_return_status := FND_API.G_RET_STS_SUCCESS;
6643:
6644: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6645: THEN
6646: -- Hint: Validate data
6647: -- IF p_ALLOWED_UNITS_LOOKUP_CODE is not NULL and p_ALLOWED_UNITS_LOOKUP_CODE <> G_MISS_CHAR
6648: -- verify if data is valid
6647: -- IF p_ALLOWED_UNITS_LOOKUP_CODE is not NULL and p_ALLOWED_UNITS_LOOKUP_CODE <> G_MISS_CHAR
6648: -- verify if data is valid
6649: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6650: NULL;
6651: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6652: THEN
6653: -- Hint: Validate data
6654: -- IF p_ALLOWED_UNITS_LOOKUP_CODE <> G_MISS_CHAR
6655: -- verify if data is valid
6669: PROCEDURE Validate_DEPARTMENT_ID (
6670: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6671: P_Validation_mode IN VARCHAR2,
6672: P_DEPARTMENT_ID IN NUMBER,
6673: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6674: X_Return_Status OUT NOCOPY VARCHAR2,
6675: X_Msg_Count OUT NOCOPY NUMBER,
6676: X_Msg_Data OUT NOCOPY VARCHAR2
6677: )
6687:
6688: -- Initialize API return status to SUCCESS
6689: x_return_status := FND_API.G_RET_STS_SUCCESS;
6690:
6691: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6692: THEN
6693: -- Hint: Validate data
6694: -- IF p_DEPARTMENT_ID is not NULL and p_DEPARTMENT_ID <> G_MISS_CHAR
6695: -- verify if data is valid
6694: -- IF p_DEPARTMENT_ID is not NULL and p_DEPARTMENT_ID <> G_MISS_CHAR
6695: -- verify if data is valid
6696: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6697: NULL;
6698: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6699: THEN
6700: -- Hint: Validate data
6701: -- IF p_DEPARTMENT_ID <> G_MISS_CHAR
6702: -- verify if data is valid
6716: PROCEDURE Validate_DEPARTMENT_CODE (
6717: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6718: P_Validation_mode IN VARCHAR2,
6719: P_DEPARTMENT_CODE IN VARCHAR2,
6720: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6721: X_Return_Status OUT NOCOPY VARCHAR2,
6722: X_Msg_Count OUT NOCOPY NUMBER,
6723: X_Msg_Data OUT NOCOPY VARCHAR2
6724: )
6734:
6735: -- Initialize API return status to SUCCESS
6736: x_return_status := FND_API.G_RET_STS_SUCCESS;
6737:
6738: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6739: THEN
6740: -- Hint: Validate data
6741: -- IF p_DEPARTMENT_CODE is not NULL and p_DEPARTMENT_CODE <> G_MISS_CHAR
6742: -- verify if data is valid
6741: -- IF p_DEPARTMENT_CODE is not NULL and p_DEPARTMENT_CODE <> G_MISS_CHAR
6742: -- verify if data is valid
6743: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6744: NULL;
6745: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6746: THEN
6747: -- Hint: Validate data
6748: -- IF p_DEPARTMENT_CODE <> G_MISS_CHAR
6749: -- verify if data is valid
6763: PROCEDURE Validate_WIP_SUPPLY_TYPE (
6764: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6765: P_Validation_mode IN VARCHAR2,
6766: P_WIP_SUPPLY_TYPE IN NUMBER,
6767: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6768: X_Return_Status OUT NOCOPY VARCHAR2,
6769: X_Msg_Count OUT NOCOPY NUMBER,
6770: X_Msg_Data OUT NOCOPY VARCHAR2
6771: )
6781:
6782: -- Initialize API return status to SUCCESS
6783: x_return_status := FND_API.G_RET_STS_SUCCESS;
6784:
6785: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6786: THEN
6787: -- Hint: Validate data
6788: -- IF p_WIP_SUPPLY_TYPE is not NULL and p_WIP_SUPPLY_TYPE <> G_MISS_CHAR
6789: -- verify if data is valid
6788: -- IF p_WIP_SUPPLY_TYPE is not NULL and p_WIP_SUPPLY_TYPE <> G_MISS_CHAR
6789: -- verify if data is valid
6790: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6791: NULL;
6792: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6793: THEN
6794: -- Hint: Validate data
6795: -- IF p_WIP_SUPPLY_TYPE <> G_MISS_CHAR
6796: -- verify if data is valid
6810: PROCEDURE Validate_SUPPLY_SUBINVENTORY (
6811: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6812: P_Validation_mode IN VARCHAR2,
6813: P_SUPPLY_SUBINVENTORY IN VARCHAR2,
6814: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6815: X_Return_Status OUT NOCOPY VARCHAR2,
6816: X_Msg_Count OUT NOCOPY NUMBER,
6817: X_Msg_Data OUT NOCOPY VARCHAR2
6818: )
6828:
6829: -- Initialize API return status to SUCCESS
6830: x_return_status := FND_API.G_RET_STS_SUCCESS;
6831:
6832: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6833: THEN
6834: -- Hint: Validate data
6835: -- IF p_SUPPLY_SUBINVENTORY is not NULL and p_SUPPLY_SUBINVENTORY <> G_MISS_CHAR
6836: -- verify if data is valid
6835: -- IF p_SUPPLY_SUBINVENTORY is not NULL and p_SUPPLY_SUBINVENTORY <> G_MISS_CHAR
6836: -- verify if data is valid
6837: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6838: NULL;
6839: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6840: THEN
6841: -- Hint: Validate data
6842: -- IF p_SUPPLY_SUBINVENTORY <> G_MISS_CHAR
6843: -- verify if data is valid
6857: PROCEDURE Validate_SUPPLY_LOCATOR_ID (
6858: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6859: P_Validation_mode IN VARCHAR2,
6860: P_SUPPLY_LOCATOR_ID IN NUMBER,
6861: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6862: X_Return_Status OUT NOCOPY VARCHAR2,
6863: X_Msg_Count OUT NOCOPY NUMBER,
6864: X_Msg_Data OUT NOCOPY VARCHAR2
6865: )
6875:
6876: -- Initialize API return status to SUCCESS
6877: x_return_status := FND_API.G_RET_STS_SUCCESS;
6878:
6879: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6880: THEN
6881: -- Hint: Validate data
6882: -- IF p_SUPPLY_LOCATOR_ID is not NULL and p_SUPPLY_LOCATOR_ID <> G_MISS_CHAR
6883: -- verify if data is valid
6882: -- IF p_SUPPLY_LOCATOR_ID is not NULL and p_SUPPLY_LOCATOR_ID <> G_MISS_CHAR
6883: -- verify if data is valid
6884: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6885: NULL;
6886: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6887: THEN
6888: -- Hint: Validate data
6889: -- IF p_SUPPLY_LOCATOR_ID <> G_MISS_CHAR
6890: -- verify if data is valid
6904: PROCEDURE Validate_VALID_SUBINVENTORY_FLAG (
6905: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6906: P_Validation_mode IN VARCHAR2,
6907: P_VALID_SUBINVENTORY_FLAG IN VARCHAR2,
6908: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6909: X_Return_Status OUT NOCOPY VARCHAR2,
6910: X_Msg_Count OUT NOCOPY NUMBER,
6911: X_Msg_Data OUT NOCOPY VARCHAR2
6912: )
6922:
6923: -- Initialize API return status to SUCCESS
6924: x_return_status := FND_API.G_RET_STS_SUCCESS;
6925:
6926: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6927: THEN
6928: -- Hint: Validate data
6929: -- IF p_VALID_SUBINVENTORY_FLAG is not NULL and p_VALID_SUBINVENTORY_FLAG <> G_MISS_CHAR
6930: -- verify if data is valid
6929: -- IF p_VALID_SUBINVENTORY_FLAG is not NULL and p_VALID_SUBINVENTORY_FLAG <> G_MISS_CHAR
6930: -- verify if data is valid
6931: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6932: NULL;
6933: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6934: THEN
6935: -- Hint: Validate data
6936: -- IF p_VALID_SUBINVENTORY_FLAG <> G_MISS_CHAR
6937: -- verify if data is valid
6951: PROCEDURE Validate_VALID_LOCATOR_FLAG (
6952: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
6953: P_Validation_mode IN VARCHAR2,
6954: P_VALID_LOCATOR_FLAG IN VARCHAR2,
6955: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
6956: X_Return_Status OUT NOCOPY VARCHAR2,
6957: X_Msg_Count OUT NOCOPY NUMBER,
6958: X_Msg_Data OUT NOCOPY VARCHAR2
6959: )
6969:
6970: -- Initialize API return status to SUCCESS
6971: x_return_status := FND_API.G_RET_STS_SUCCESS;
6972:
6973: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
6974: THEN
6975: -- Hint: Validate data
6976: -- IF p_VALID_LOCATOR_FLAG is not NULL and p_VALID_LOCATOR_FLAG <> G_MISS_CHAR
6977: -- verify if data is valid
6976: -- IF p_VALID_LOCATOR_FLAG is not NULL and p_VALID_LOCATOR_FLAG <> G_MISS_CHAR
6977: -- verify if data is valid
6978: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6979: NULL;
6980: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
6981: THEN
6982: -- Hint: Validate data
6983: -- IF p_VALID_LOCATOR_FLAG <> G_MISS_CHAR
6984: -- verify if data is valid
6998: PROCEDURE Validate_LOCATOR_SEGMENTS (
6999: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7000: P_Validation_mode IN VARCHAR2,
7001: P_LOCATOR_SEGMENTS IN VARCHAR2,
7002: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7003: X_Return_Status OUT NOCOPY VARCHAR2,
7004: X_Msg_Count OUT NOCOPY NUMBER,
7005: X_Msg_Data OUT NOCOPY VARCHAR2
7006: )
7016:
7017: -- Initialize API return status to SUCCESS
7018: x_return_status := FND_API.G_RET_STS_SUCCESS;
7019:
7020: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7021: THEN
7022: -- Hint: Validate data
7023: -- IF p_LOCATOR_SEGMENTS is not NULL and p_LOCATOR_SEGMENTS <> G_MISS_CHAR
7024: -- verify if data is valid
7023: -- IF p_LOCATOR_SEGMENTS is not NULL and p_LOCATOR_SEGMENTS <> G_MISS_CHAR
7024: -- verify if data is valid
7025: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7026: NULL;
7027: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7028: THEN
7029: -- Hint: Validate data
7030: -- IF p_LOCATOR_SEGMENTS <> G_MISS_CHAR
7031: -- verify if data is valid
7045: PROCEDURE Validate_CURRENT_LOCATOR_CONTROL_CODE (
7046: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7047: P_Validation_mode IN VARCHAR2,
7048: P_CURRENT_LOCATOR_CONTROL_CODE IN NUMBER,
7049: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7050: X_Return_Status OUT NOCOPY VARCHAR2,
7051: X_Msg_Count OUT NOCOPY NUMBER,
7052: X_Msg_Data OUT NOCOPY VARCHAR2
7053: )
7063:
7064: -- Initialize API return status to SUCCESS
7065: x_return_status := FND_API.G_RET_STS_SUCCESS;
7066:
7067: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7068: THEN
7069: -- Hint: Validate data
7070: -- IF p_CURRENT_LOCATOR_CONTROL_CODE is not NULL and p_CURRENT_LOCATOR_CONTROL_CODE <> G_MISS_CHAR
7071: -- verify if data is valid
7070: -- IF p_CURRENT_LOCATOR_CONTROL_CODE is not NULL and p_CURRENT_LOCATOR_CONTROL_CODE <> G_MISS_CHAR
7071: -- verify if data is valid
7072: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7073: NULL;
7074: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7075: THEN
7076: -- Hint: Validate data
7077: -- IF p_CURRENT_LOCATOR_CONTROL_CODE <> G_MISS_CHAR
7078: -- verify if data is valid
7092: PROCEDURE Validate_NUMBER_OF_LOTS_ENTERED (
7093: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7094: P_Validation_mode IN VARCHAR2,
7095: P_NUMBER_OF_LOTS_ENTERED IN NUMBER,
7096: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7097: X_Return_Status OUT NOCOPY VARCHAR2,
7098: X_Msg_Count OUT NOCOPY NUMBER,
7099: X_Msg_Data OUT NOCOPY VARCHAR2
7100: )
7110:
7111: -- Initialize API return status to SUCCESS
7112: x_return_status := FND_API.G_RET_STS_SUCCESS;
7113:
7114: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7115: THEN
7116: -- Hint: Validate data
7117: -- IF p_NUMBER_OF_LOTS_ENTERED is not NULL and p_NUMBER_OF_LOTS_ENTERED <> G_MISS_CHAR
7118: -- verify if data is valid
7117: -- IF p_NUMBER_OF_LOTS_ENTERED is not NULL and p_NUMBER_OF_LOTS_ENTERED <> G_MISS_CHAR
7118: -- verify if data is valid
7119: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7120: NULL;
7121: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7122: THEN
7123: -- Hint: Validate data
7124: -- IF p_NUMBER_OF_LOTS_ENTERED <> G_MISS_CHAR
7125: -- verify if data is valid
7139: PROCEDURE Validate_WIP_COMMIT_FLAG (
7140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7141: P_Validation_mode IN VARCHAR2,
7142: P_WIP_COMMIT_FLAG IN VARCHAR2,
7143: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7144: X_Return_Status OUT NOCOPY VARCHAR2,
7145: X_Msg_Count OUT NOCOPY NUMBER,
7146: X_Msg_Data OUT NOCOPY VARCHAR2
7147: )
7157:
7158: -- Initialize API return status to SUCCESS
7159: x_return_status := FND_API.G_RET_STS_SUCCESS;
7160:
7161: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7162: THEN
7163: -- Hint: Validate data
7164: -- IF p_WIP_COMMIT_FLAG is not NULL and p_WIP_COMMIT_FLAG <> G_MISS_CHAR
7165: -- verify if data is valid
7164: -- IF p_WIP_COMMIT_FLAG is not NULL and p_WIP_COMMIT_FLAG <> G_MISS_CHAR
7165: -- verify if data is valid
7166: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7167: NULL;
7168: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7169: THEN
7170: -- Hint: Validate data
7171: -- IF p_WIP_COMMIT_FLAG <> G_MISS_CHAR
7172: -- verify if data is valid
7186: PROCEDURE Validate_NEXT_LOT_NUMBER (
7187: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7188: P_Validation_mode IN VARCHAR2,
7189: P_NEXT_LOT_NUMBER IN VARCHAR2,
7190: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7191: X_Return_Status OUT NOCOPY VARCHAR2,
7192: X_Msg_Count OUT NOCOPY NUMBER,
7193: X_Msg_Data OUT NOCOPY VARCHAR2
7194: )
7204:
7205: -- Initialize API return status to SUCCESS
7206: x_return_status := FND_API.G_RET_STS_SUCCESS;
7207:
7208: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7209: THEN
7210: -- Hint: Validate data
7211: -- IF p_NEXT_LOT_NUMBER is not NULL and p_NEXT_LOT_NUMBER <> G_MISS_CHAR
7212: -- verify if data is valid
7211: -- IF p_NEXT_LOT_NUMBER is not NULL and p_NEXT_LOT_NUMBER <> G_MISS_CHAR
7212: -- verify if data is valid
7213: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7214: NULL;
7215: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7216: THEN
7217: -- Hint: Validate data
7218: -- IF p_NEXT_LOT_NUMBER <> G_MISS_CHAR
7219: -- verify if data is valid
7233: PROCEDURE Validate_LOT_ALPHA_PREFIX (
7234: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7235: P_Validation_mode IN VARCHAR2,
7236: P_LOT_ALPHA_PREFIX IN VARCHAR2,
7237: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7238: X_Return_Status OUT NOCOPY VARCHAR2,
7239: X_Msg_Count OUT NOCOPY NUMBER,
7240: X_Msg_Data OUT NOCOPY VARCHAR2
7241: )
7251:
7252: -- Initialize API return status to SUCCESS
7253: x_return_status := FND_API.G_RET_STS_SUCCESS;
7254:
7255: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7256: THEN
7257: -- Hint: Validate data
7258: -- IF p_LOT_ALPHA_PREFIX is not NULL and p_LOT_ALPHA_PREFIX <> G_MISS_CHAR
7259: -- verify if data is valid
7258: -- IF p_LOT_ALPHA_PREFIX is not NULL and p_LOT_ALPHA_PREFIX <> G_MISS_CHAR
7259: -- verify if data is valid
7260: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7261: NULL;
7262: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7263: THEN
7264: -- Hint: Validate data
7265: -- IF p_LOT_ALPHA_PREFIX <> G_MISS_CHAR
7266: -- verify if data is valid
7280: PROCEDURE Validate_NEXT_SERIAL_NUMBER (
7281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7282: P_Validation_mode IN VARCHAR2,
7283: P_NEXT_SERIAL_NUMBER IN VARCHAR2,
7284: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7285: X_Return_Status OUT NOCOPY VARCHAR2,
7286: X_Msg_Count OUT NOCOPY NUMBER,
7287: X_Msg_Data OUT NOCOPY VARCHAR2
7288: )
7298:
7299: -- Initialize API return status to SUCCESS
7300: x_return_status := FND_API.G_RET_STS_SUCCESS;
7301:
7302: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7303: THEN
7304: -- Hint: Validate data
7305: -- IF p_NEXT_SERIAL_NUMBER is not NULL and p_NEXT_SERIAL_NUMBER <> G_MISS_CHAR
7306: -- verify if data is valid
7305: -- IF p_NEXT_SERIAL_NUMBER is not NULL and p_NEXT_SERIAL_NUMBER <> G_MISS_CHAR
7306: -- verify if data is valid
7307: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7308: NULL;
7309: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7310: THEN
7311: -- Hint: Validate data
7312: -- IF p_NEXT_SERIAL_NUMBER <> G_MISS_CHAR
7313: -- verify if data is valid
7327: PROCEDURE Validate_SERIAL_ALPHA_PREFIX (
7328: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7329: P_Validation_mode IN VARCHAR2,
7330: P_SERIAL_ALPHA_PREFIX IN VARCHAR2,
7331: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7332: X_Return_Status OUT NOCOPY VARCHAR2,
7333: X_Msg_Count OUT NOCOPY NUMBER,
7334: X_Msg_Data OUT NOCOPY VARCHAR2
7335: )
7345:
7346: -- Initialize API return status to SUCCESS
7347: x_return_status := FND_API.G_RET_STS_SUCCESS;
7348:
7349: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7350: THEN
7351: -- Hint: Validate data
7352: -- IF p_SERIAL_ALPHA_PREFIX is not NULL and p_SERIAL_ALPHA_PREFIX <> G_MISS_CHAR
7353: -- verify if data is valid
7352: -- IF p_SERIAL_ALPHA_PREFIX is not NULL and p_SERIAL_ALPHA_PREFIX <> G_MISS_CHAR
7353: -- verify if data is valid
7354: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7355: NULL;
7356: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7357: THEN
7358: -- Hint: Validate data
7359: -- IF p_SERIAL_ALPHA_PREFIX <> G_MISS_CHAR
7360: -- verify if data is valid
7374: PROCEDURE Validate_SHIPPABLE_FLAG (
7375: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7376: P_Validation_mode IN VARCHAR2,
7377: P_SHIPPABLE_FLAG IN VARCHAR2,
7378: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7379: X_Return_Status OUT NOCOPY VARCHAR2,
7380: X_Msg_Count OUT NOCOPY NUMBER,
7381: X_Msg_Data OUT NOCOPY VARCHAR2
7382: )
7392:
7393: -- Initialize API return status to SUCCESS
7394: x_return_status := FND_API.G_RET_STS_SUCCESS;
7395:
7396: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7397: THEN
7398: -- Hint: Validate data
7399: -- IF p_SHIPPABLE_FLAG is not NULL and p_SHIPPABLE_FLAG <> G_MISS_CHAR
7400: -- verify if data is valid
7399: -- IF p_SHIPPABLE_FLAG is not NULL and p_SHIPPABLE_FLAG <> G_MISS_CHAR
7400: -- verify if data is valid
7401: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7402: NULL;
7403: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7404: THEN
7405: -- Hint: Validate data
7406: -- IF p_SHIPPABLE_FLAG <> G_MISS_CHAR
7407: -- verify if data is valid
7421: PROCEDURE Validate_POSTING_FLAG (
7422: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7423: P_Validation_mode IN VARCHAR2,
7424: P_POSTING_FLAG IN VARCHAR2,
7425: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7426: X_Return_Status OUT NOCOPY VARCHAR2,
7427: X_Msg_Count OUT NOCOPY NUMBER,
7428: X_Msg_Data OUT NOCOPY VARCHAR2
7429: )
7439:
7440: -- Initialize API return status to SUCCESS
7441: x_return_status := FND_API.G_RET_STS_SUCCESS;
7442:
7443: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7444: THEN
7445: -- Hint: Validate data
7446: -- IF p_POSTING_FLAG is not NULL and p_POSTING_FLAG <> G_MISS_CHAR
7447: -- verify if data is valid
7446: -- IF p_POSTING_FLAG is not NULL and p_POSTING_FLAG <> G_MISS_CHAR
7447: -- verify if data is valid
7448: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7449: NULL;
7450: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7451: THEN
7452: -- Hint: Validate data
7453: -- IF p_POSTING_FLAG <> G_MISS_CHAR
7454: -- verify if data is valid
7468: PROCEDURE Validate_REQUIRED_FLAG (
7469: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7470: P_Validation_mode IN VARCHAR2,
7471: P_REQUIRED_FLAG IN VARCHAR2,
7472: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7473: X_Return_Status OUT NOCOPY VARCHAR2,
7474: X_Msg_Count OUT NOCOPY NUMBER,
7475: X_Msg_Data OUT NOCOPY VARCHAR2
7476: )
7486:
7487: -- Initialize API return status to SUCCESS
7488: x_return_status := FND_API.G_RET_STS_SUCCESS;
7489:
7490: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7491: THEN
7492: -- Hint: Validate data
7493: -- IF p_REQUIRED_FLAG is not NULL and p_REQUIRED_FLAG <> G_MISS_CHAR
7494: -- verify if data is valid
7493: -- IF p_REQUIRED_FLAG is not NULL and p_REQUIRED_FLAG <> G_MISS_CHAR
7494: -- verify if data is valid
7495: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7496: NULL;
7497: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7498: THEN
7499: -- Hint: Validate data
7500: -- IF p_REQUIRED_FLAG <> G_MISS_CHAR
7501: -- verify if data is valid
7515: PROCEDURE Validate_PROCESS_FLAG (
7516: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7517: P_Validation_mode IN VARCHAR2,
7518: P_PROCESS_FLAG IN VARCHAR2,
7519: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7520: X_Return_Status OUT NOCOPY VARCHAR2,
7521: X_Msg_Count OUT NOCOPY NUMBER,
7522: X_Msg_Data OUT NOCOPY VARCHAR2
7523: )
7533:
7534: -- Initialize API return status to SUCCESS
7535: x_return_status := FND_API.G_RET_STS_SUCCESS;
7536:
7537: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7538: THEN
7539: -- Hint: Validate data
7540: -- IF p_PROCESS_FLAG is not NULL and p_PROCESS_FLAG <> G_MISS_CHAR
7541: -- verify if data is valid
7540: -- IF p_PROCESS_FLAG is not NULL and p_PROCESS_FLAG <> G_MISS_CHAR
7541: -- verify if data is valid
7542: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7543: NULL;
7544: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7545: THEN
7546: -- Hint: Validate data
7547: -- IF p_PROCESS_FLAG <> G_MISS_CHAR
7548: -- verify if data is valid
7562: PROCEDURE Validate_ERROR_CODE (
7563: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7564: P_Validation_mode IN VARCHAR2,
7565: P_ERROR_CODE IN VARCHAR2,
7566: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7567: X_Return_Status OUT NOCOPY VARCHAR2,
7568: X_Msg_Count OUT NOCOPY NUMBER,
7569: X_Msg_Data OUT NOCOPY VARCHAR2
7570: )
7580:
7581: -- Initialize API return status to SUCCESS
7582: x_return_status := FND_API.G_RET_STS_SUCCESS;
7583:
7584: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7585: THEN
7586: -- Hint: Validate data
7587: -- IF p_ERROR_CODE is not NULL and p_ERROR_CODE <> G_MISS_CHAR
7588: -- verify if data is valid
7587: -- IF p_ERROR_CODE is not NULL and p_ERROR_CODE <> G_MISS_CHAR
7588: -- verify if data is valid
7589: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7590: NULL;
7591: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7592: THEN
7593: -- Hint: Validate data
7594: -- IF p_ERROR_CODE <> G_MISS_CHAR
7595: -- verify if data is valid
7609: PROCEDURE Validate_ERROR_EXPLANATION (
7610: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7611: P_Validation_mode IN VARCHAR2,
7612: P_ERROR_EXPLANATION IN VARCHAR2,
7613: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7614: X_Return_Status OUT NOCOPY VARCHAR2,
7615: X_Msg_Count OUT NOCOPY NUMBER,
7616: X_Msg_Data OUT NOCOPY VARCHAR2
7617: )
7627:
7628: -- Initialize API return status to SUCCESS
7629: x_return_status := FND_API.G_RET_STS_SUCCESS;
7630:
7631: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7632: THEN
7633: -- Hint: Validate data
7634: -- IF p_ERROR_EXPLANATION is not NULL and p_ERROR_EXPLANATION <> G_MISS_CHAR
7635: -- verify if data is valid
7634: -- IF p_ERROR_EXPLANATION is not NULL and p_ERROR_EXPLANATION <> G_MISS_CHAR
7635: -- verify if data is valid
7636: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7637: NULL;
7638: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7639: THEN
7640: -- Hint: Validate data
7641: -- IF p_ERROR_EXPLANATION <> G_MISS_CHAR
7642: -- verify if data is valid
7656: PROCEDURE Validate_MOVEMENT_ID (
7657: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7658: P_Validation_mode IN VARCHAR2,
7659: P_MOVEMENT_ID IN NUMBER,
7660: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7661: X_Return_Status OUT NOCOPY VARCHAR2,
7662: X_Msg_Count OUT NOCOPY NUMBER,
7663: X_Msg_Data OUT NOCOPY VARCHAR2
7664: )
7674:
7675: -- Initialize API return status to SUCCESS
7676: x_return_status := FND_API.G_RET_STS_SUCCESS;
7677:
7678: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7679: THEN
7680: -- Hint: Validate data
7681: -- IF p_MOVEMENT_ID is not NULL and p_MOVEMENT_ID <> G_MISS_CHAR
7682: -- verify if data is valid
7681: -- IF p_MOVEMENT_ID is not NULL and p_MOVEMENT_ID <> G_MISS_CHAR
7682: -- verify if data is valid
7683: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7684: NULL;
7685: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7686: THEN
7687: -- Hint: Validate data
7688: -- IF p_MOVEMENT_ID <> G_MISS_CHAR
7689: -- verify if data is valid
7703: PROCEDURE Validate_RESERVATION_QUANTITY (
7704: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7705: P_Validation_mode IN VARCHAR2,
7706: P_RESERVATION_QUANTITY IN NUMBER,
7707: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7708: X_Return_Status OUT NOCOPY VARCHAR2,
7709: X_Msg_Count OUT NOCOPY NUMBER,
7710: X_Msg_Data OUT NOCOPY VARCHAR2
7711: )
7721:
7722: -- Initialize API return status to SUCCESS
7723: x_return_status := FND_API.G_RET_STS_SUCCESS;
7724:
7725: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7726: THEN
7727: -- Hint: Validate data
7728: -- IF p_RESERVATION_QUANTITY is not NULL and p_RESERVATION_QUANTITY <> G_MISS_CHAR
7729: -- verify if data is valid
7728: -- IF p_RESERVATION_QUANTITY is not NULL and p_RESERVATION_QUANTITY <> G_MISS_CHAR
7729: -- verify if data is valid
7730: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7731: NULL;
7732: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7733: THEN
7734: -- Hint: Validate data
7735: -- IF p_RESERVATION_QUANTITY <> G_MISS_CHAR
7736: -- verify if data is valid
7750: PROCEDURE Validate_SHIPPED_QUANTITY (
7751: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7752: P_Validation_mode IN VARCHAR2,
7753: P_SHIPPED_QUANTITY IN NUMBER,
7754: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7755: X_Return_Status OUT NOCOPY VARCHAR2,
7756: X_Msg_Count OUT NOCOPY NUMBER,
7757: X_Msg_Data OUT NOCOPY VARCHAR2
7758: )
7768:
7769: -- Initialize API return status to SUCCESS
7770: x_return_status := FND_API.G_RET_STS_SUCCESS;
7771:
7772: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7773: THEN
7774: -- Hint: Validate data
7775: -- IF p_SHIPPED_QUANTITY is not NULL and p_SHIPPED_QUANTITY <> G_MISS_CHAR
7776: -- verify if data is valid
7775: -- IF p_SHIPPED_QUANTITY is not NULL and p_SHIPPED_QUANTITY <> G_MISS_CHAR
7776: -- verify if data is valid
7777: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7778: NULL;
7779: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7780: THEN
7781: -- Hint: Validate data
7782: -- IF p_SHIPPED_QUANTITY <> G_MISS_CHAR
7783: -- verify if data is valid
7797: PROCEDURE Validate_TRANSACTION_LINE_NUMBER (
7798: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7799: P_Validation_mode IN VARCHAR2,
7800: P_TRANSACTION_LINE_NUMBER IN NUMBER,
7801: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7802: X_Return_Status OUT NOCOPY VARCHAR2,
7803: X_Msg_Count OUT NOCOPY NUMBER,
7804: X_Msg_Data OUT NOCOPY VARCHAR2
7805: )
7815:
7816: -- Initialize API return status to SUCCESS
7817: x_return_status := FND_API.G_RET_STS_SUCCESS;
7818:
7819: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7820: THEN
7821: -- Hint: Validate data
7822: -- IF p_TRANSACTION_LINE_NUMBER is not NULL and p_TRANSACTION_LINE_NUMBER <> G_MISS_CHAR
7823: -- verify if data is valid
7822: -- IF p_TRANSACTION_LINE_NUMBER is not NULL and p_TRANSACTION_LINE_NUMBER <> G_MISS_CHAR
7823: -- verify if data is valid
7824: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7825: NULL;
7826: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7827: THEN
7828: -- Hint: Validate data
7829: -- IF p_TRANSACTION_LINE_NUMBER <> G_MISS_CHAR
7830: -- verify if data is valid
7844: PROCEDURE Validate_TASK_ID (
7845: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7846: P_Validation_mode IN VARCHAR2,
7847: P_TASK_ID IN NUMBER,
7848: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7849: X_Return_Status OUT NOCOPY VARCHAR2,
7850: X_Msg_Count OUT NOCOPY NUMBER,
7851: X_Msg_Data OUT NOCOPY VARCHAR2
7852: )
7862:
7863: -- Initialize API return status to SUCCESS
7864: x_return_status := FND_API.G_RET_STS_SUCCESS;
7865:
7866: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7867: THEN
7868: -- Hint: Validate data
7869: -- IF p_TASK_ID is not NULL and p_TASK_ID <> G_MISS_CHAR
7870: -- verify if data is valid
7869: -- IF p_TASK_ID is not NULL and p_TASK_ID <> G_MISS_CHAR
7870: -- verify if data is valid
7871: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7872: NULL;
7873: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7874: THEN
7875: -- Hint: Validate data
7876: -- IF p_TASK_ID <> G_MISS_CHAR
7877: -- verify if data is valid
7891: PROCEDURE Validate_TO_TASK_ID (
7892: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7893: P_Validation_mode IN VARCHAR2,
7894: P_TO_TASK_ID IN NUMBER,
7895: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7896: X_Return_Status OUT NOCOPY VARCHAR2,
7897: X_Msg_Count OUT NOCOPY NUMBER,
7898: X_Msg_Data OUT NOCOPY VARCHAR2
7899: )
7909:
7910: -- Initialize API return status to SUCCESS
7911: x_return_status := FND_API.G_RET_STS_SUCCESS;
7912:
7913: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7914: THEN
7915: -- Hint: Validate data
7916: -- IF p_TO_TASK_ID is not NULL and p_TO_TASK_ID <> G_MISS_CHAR
7917: -- verify if data is valid
7916: -- IF p_TO_TASK_ID is not NULL and p_TO_TASK_ID <> G_MISS_CHAR
7917: -- verify if data is valid
7918: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7919: NULL;
7920: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7921: THEN
7922: -- Hint: Validate data
7923: -- IF p_TO_TASK_ID <> G_MISS_CHAR
7924: -- verify if data is valid
7938: PROCEDURE Validate_SOURCE_TASK_ID (
7939: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7940: P_Validation_mode IN VARCHAR2,
7941: P_SOURCE_TASK_ID IN NUMBER,
7942: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7943: X_Return_Status OUT NOCOPY VARCHAR2,
7944: X_Msg_Count OUT NOCOPY NUMBER,
7945: X_Msg_Data OUT NOCOPY VARCHAR2
7946: )
7956:
7957: -- Initialize API return status to SUCCESS
7958: x_return_status := FND_API.G_RET_STS_SUCCESS;
7959:
7960: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
7961: THEN
7962: -- Hint: Validate data
7963: -- IF p_SOURCE_TASK_ID is not NULL and p_SOURCE_TASK_ID <> G_MISS_CHAR
7964: -- verify if data is valid
7963: -- IF p_SOURCE_TASK_ID is not NULL and p_SOURCE_TASK_ID <> G_MISS_CHAR
7964: -- verify if data is valid
7965: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7966: NULL;
7967: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
7968: THEN
7969: -- Hint: Validate data
7970: -- IF p_SOURCE_TASK_ID <> G_MISS_CHAR
7971: -- verify if data is valid
7985: PROCEDURE Validate_PROJECT_ID (
7986: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
7987: P_Validation_mode IN VARCHAR2,
7988: P_PROJECT_ID IN NUMBER,
7989: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
7990: X_Return_Status OUT NOCOPY VARCHAR2,
7991: X_Msg_Count OUT NOCOPY NUMBER,
7992: X_Msg_Data OUT NOCOPY VARCHAR2
7993: )
8003:
8004: -- Initialize API return status to SUCCESS
8005: x_return_status := FND_API.G_RET_STS_SUCCESS;
8006:
8007: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8008: THEN
8009: -- Hint: Validate data
8010: -- IF p_PROJECT_ID is not NULL and p_PROJECT_ID <> G_MISS_CHAR
8011: -- verify if data is valid
8010: -- IF p_PROJECT_ID is not NULL and p_PROJECT_ID <> G_MISS_CHAR
8011: -- verify if data is valid
8012: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8013: NULL;
8014: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8015: THEN
8016: -- Hint: Validate data
8017: -- IF p_PROJECT_ID <> G_MISS_CHAR
8018: -- verify if data is valid
8032: PROCEDURE Validate_SOURCE_PROJECT_ID (
8033: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8034: P_Validation_mode IN VARCHAR2,
8035: P_SOURCE_PROJECT_ID IN NUMBER,
8036: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8037: X_Return_Status OUT NOCOPY VARCHAR2,
8038: X_Msg_Count OUT NOCOPY NUMBER,
8039: X_Msg_Data OUT NOCOPY VARCHAR2
8040: )
8050:
8051: -- Initialize API return status to SUCCESS
8052: x_return_status := FND_API.G_RET_STS_SUCCESS;
8053:
8054: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8055: THEN
8056: -- Hint: Validate data
8057: -- IF p_SOURCE_PROJECT_ID is not NULL and p_SOURCE_PROJECT_ID <> G_MISS_CHAR
8058: -- verify if data is valid
8057: -- IF p_SOURCE_PROJECT_ID is not NULL and p_SOURCE_PROJECT_ID <> G_MISS_CHAR
8058: -- verify if data is valid
8059: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8060: NULL;
8061: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8062: THEN
8063: -- Hint: Validate data
8064: -- IF p_SOURCE_PROJECT_ID <> G_MISS_CHAR
8065: -- verify if data is valid
8079: PROCEDURE Validate_PA_EXPENDITURE_ORG_ID (
8080: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8081: P_Validation_mode IN VARCHAR2,
8082: P_PA_EXPENDITURE_ORG_ID IN NUMBER,
8083: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8084: X_Return_Status OUT NOCOPY VARCHAR2,
8085: X_Msg_Count OUT NOCOPY NUMBER,
8086: X_Msg_Data OUT NOCOPY VARCHAR2
8087: )
8097:
8098: -- Initialize API return status to SUCCESS
8099: x_return_status := FND_API.G_RET_STS_SUCCESS;
8100:
8101: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8102: THEN
8103: -- Hint: Validate data
8104: -- IF p_PA_EXPENDITURE_ORG_ID is not NULL and p_PA_EXPENDITURE_ORG_ID <> G_MISS_CHAR
8105: -- verify if data is valid
8104: -- IF p_PA_EXPENDITURE_ORG_ID is not NULL and p_PA_EXPENDITURE_ORG_ID <> G_MISS_CHAR
8105: -- verify if data is valid
8106: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8107: NULL;
8108: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8109: THEN
8110: -- Hint: Validate data
8111: -- IF p_PA_EXPENDITURE_ORG_ID <> G_MISS_CHAR
8112: -- verify if data is valid
8126: PROCEDURE Validate_TO_PROJECT_ID (
8127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8128: P_Validation_mode IN VARCHAR2,
8129: P_TO_PROJECT_ID IN NUMBER,
8130: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8131: X_Return_Status OUT NOCOPY VARCHAR2,
8132: X_Msg_Count OUT NOCOPY NUMBER,
8133: X_Msg_Data OUT NOCOPY VARCHAR2
8134: )
8144:
8145: -- Initialize API return status to SUCCESS
8146: x_return_status := FND_API.G_RET_STS_SUCCESS;
8147:
8148: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8149: THEN
8150: -- Hint: Validate data
8151: -- IF p_TO_PROJECT_ID is not NULL and p_TO_PROJECT_ID <> G_MISS_CHAR
8152: -- verify if data is valid
8151: -- IF p_TO_PROJECT_ID is not NULL and p_TO_PROJECT_ID <> G_MISS_CHAR
8152: -- verify if data is valid
8153: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8154: NULL;
8155: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8156: THEN
8157: -- Hint: Validate data
8158: -- IF p_TO_PROJECT_ID <> G_MISS_CHAR
8159: -- verify if data is valid
8173: PROCEDURE Validate_EXPENDITURE_TYPE (
8174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8175: P_Validation_mode IN VARCHAR2,
8176: P_EXPENDITURE_TYPE IN VARCHAR2,
8177: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8178: X_Return_Status OUT NOCOPY VARCHAR2,
8179: X_Msg_Count OUT NOCOPY NUMBER,
8180: X_Msg_Data OUT NOCOPY VARCHAR2
8181: )
8191:
8192: -- Initialize API return status to SUCCESS
8193: x_return_status := FND_API.G_RET_STS_SUCCESS;
8194:
8195: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8196: THEN
8197: -- Hint: Validate data
8198: -- IF p_EXPENDITURE_TYPE is not NULL and p_EXPENDITURE_TYPE <> G_MISS_CHAR
8199: -- verify if data is valid
8198: -- IF p_EXPENDITURE_TYPE is not NULL and p_EXPENDITURE_TYPE <> G_MISS_CHAR
8199: -- verify if data is valid
8200: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8201: NULL;
8202: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8203: THEN
8204: -- Hint: Validate data
8205: -- IF p_EXPENDITURE_TYPE <> G_MISS_CHAR
8206: -- verify if data is valid
8220: PROCEDURE Validate_FINAL_COMPLETION_FLAG (
8221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8222: P_Validation_mode IN VARCHAR2,
8223: P_FINAL_COMPLETION_FLAG IN VARCHAR2,
8224: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8225: X_Return_Status OUT NOCOPY VARCHAR2,
8226: X_Msg_Count OUT NOCOPY NUMBER,
8227: X_Msg_Data OUT NOCOPY VARCHAR2
8228: )
8238:
8239: -- Initialize API return status to SUCCESS
8240: x_return_status := FND_API.G_RET_STS_SUCCESS;
8241:
8242: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8243: THEN
8244: -- Hint: Validate data
8245: -- IF p_FINAL_COMPLETION_FLAG is not NULL and p_FINAL_COMPLETION_FLAG <> G_MISS_CHAR
8246: -- verify if data is valid
8245: -- IF p_FINAL_COMPLETION_FLAG is not NULL and p_FINAL_COMPLETION_FLAG <> G_MISS_CHAR
8246: -- verify if data is valid
8247: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8248: NULL;
8249: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8250: THEN
8251: -- Hint: Validate data
8252: -- IF p_FINAL_COMPLETION_FLAG <> G_MISS_CHAR
8253: -- verify if data is valid
8267: PROCEDURE Validate_TRANSFER_PERCENTAGE (
8268: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8269: P_Validation_mode IN VARCHAR2,
8270: P_TRANSFER_PERCENTAGE IN NUMBER,
8271: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8272: X_Return_Status OUT NOCOPY VARCHAR2,
8273: X_Msg_Count OUT NOCOPY NUMBER,
8274: X_Msg_Data OUT NOCOPY VARCHAR2
8275: )
8285:
8286: -- Initialize API return status to SUCCESS
8287: x_return_status := FND_API.G_RET_STS_SUCCESS;
8288:
8289: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8290: THEN
8291: -- Hint: Validate data
8292: -- IF p_TRANSFER_PERCENTAGE is not NULL and p_TRANSFER_PERCENTAGE <> G_MISS_CHAR
8293: -- verify if data is valid
8292: -- IF p_TRANSFER_PERCENTAGE is not NULL and p_TRANSFER_PERCENTAGE <> G_MISS_CHAR
8293: -- verify if data is valid
8294: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8295: NULL;
8296: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8297: THEN
8298: -- Hint: Validate data
8299: -- IF p_TRANSFER_PERCENTAGE <> G_MISS_CHAR
8300: -- verify if data is valid
8314: PROCEDURE Validate_TRANSACTION_SEQUENCE_ID (
8315: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8316: P_Validation_mode IN VARCHAR2,
8317: P_TRANSACTION_SEQUENCE_ID IN NUMBER,
8318: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8319: X_Return_Status OUT NOCOPY VARCHAR2,
8320: X_Msg_Count OUT NOCOPY NUMBER,
8321: X_Msg_Data OUT NOCOPY VARCHAR2
8322: )
8332:
8333: -- Initialize API return status to SUCCESS
8334: x_return_status := FND_API.G_RET_STS_SUCCESS;
8335:
8336: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8337: THEN
8338: -- Hint: Validate data
8339: -- IF p_TRANSACTION_SEQUENCE_ID is not NULL and p_TRANSACTION_SEQUENCE_ID <> G_MISS_CHAR
8340: -- verify if data is valid
8339: -- IF p_TRANSACTION_SEQUENCE_ID is not NULL and p_TRANSACTION_SEQUENCE_ID <> G_MISS_CHAR
8340: -- verify if data is valid
8341: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8342: NULL;
8343: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8344: THEN
8345: -- Hint: Validate data
8346: -- IF p_TRANSACTION_SEQUENCE_ID <> G_MISS_CHAR
8347: -- verify if data is valid
8361: PROCEDURE Validate_MATERIAL_ACCOUNT (
8362: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8363: P_Validation_mode IN VARCHAR2,
8364: P_MATERIAL_ACCOUNT IN NUMBER,
8365: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8366: X_Return_Status OUT NOCOPY VARCHAR2,
8367: X_Msg_Count OUT NOCOPY NUMBER,
8368: X_Msg_Data OUT NOCOPY VARCHAR2
8369: )
8379:
8380: -- Initialize API return status to SUCCESS
8381: x_return_status := FND_API.G_RET_STS_SUCCESS;
8382:
8383: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8384: THEN
8385: -- Hint: Validate data
8386: -- IF p_MATERIAL_ACCOUNT is not NULL and p_MATERIAL_ACCOUNT <> G_MISS_CHAR
8387: -- verify if data is valid
8386: -- IF p_MATERIAL_ACCOUNT is not NULL and p_MATERIAL_ACCOUNT <> G_MISS_CHAR
8387: -- verify if data is valid
8388: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8389: NULL;
8390: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8391: THEN
8392: -- Hint: Validate data
8393: -- IF p_MATERIAL_ACCOUNT <> G_MISS_CHAR
8394: -- verify if data is valid
8408: PROCEDURE Validate_MATERIAL_OVERHEAD_ACCOUNT (
8409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8410: P_Validation_mode IN VARCHAR2,
8411: P_MATERIAL_OVERHEAD_ACCOUNT IN NUMBER,
8412: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8413: X_Return_Status OUT NOCOPY VARCHAR2,
8414: X_Msg_Count OUT NOCOPY NUMBER,
8415: X_Msg_Data OUT NOCOPY VARCHAR2
8416: )
8426:
8427: -- Initialize API return status to SUCCESS
8428: x_return_status := FND_API.G_RET_STS_SUCCESS;
8429:
8430: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8431: THEN
8432: -- Hint: Validate data
8433: -- IF p_MATERIAL_OVERHEAD_ACCOUNT is not NULL and p_MATERIAL_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8434: -- verify if data is valid
8433: -- IF p_MATERIAL_OVERHEAD_ACCOUNT is not NULL and p_MATERIAL_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8434: -- verify if data is valid
8435: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8436: NULL;
8437: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8438: THEN
8439: -- Hint: Validate data
8440: -- IF p_MATERIAL_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8441: -- verify if data is valid
8455: PROCEDURE Validate_RESOURCE_ACCOUNT (
8456: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8457: P_Validation_mode IN VARCHAR2,
8458: P_RESOURCE_ACCOUNT IN NUMBER,
8459: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8460: X_Return_Status OUT NOCOPY VARCHAR2,
8461: X_Msg_Count OUT NOCOPY NUMBER,
8462: X_Msg_Data OUT NOCOPY VARCHAR2
8463: )
8473:
8474: -- Initialize API return status to SUCCESS
8475: x_return_status := FND_API.G_RET_STS_SUCCESS;
8476:
8477: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8478: THEN
8479: -- Hint: Validate data
8480: -- IF p_RESOURCE_ACCOUNT is not NULL and p_RESOURCE_ACCOUNT <> G_MISS_CHAR
8481: -- verify if data is valid
8480: -- IF p_RESOURCE_ACCOUNT is not NULL and p_RESOURCE_ACCOUNT <> G_MISS_CHAR
8481: -- verify if data is valid
8482: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8483: NULL;
8484: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8485: THEN
8486: -- Hint: Validate data
8487: -- IF p_RESOURCE_ACCOUNT <> G_MISS_CHAR
8488: -- verify if data is valid
8502: PROCEDURE Validate_OUTSIDE_PROCESSING_ACCOUNT (
8503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8504: P_Validation_mode IN VARCHAR2,
8505: P_OUTSIDE_PROCESSING_ACCOUNT IN NUMBER,
8506: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8507: X_Return_Status OUT NOCOPY VARCHAR2,
8508: X_Msg_Count OUT NOCOPY NUMBER,
8509: X_Msg_Data OUT NOCOPY VARCHAR2
8510: )
8520:
8521: -- Initialize API return status to SUCCESS
8522: x_return_status := FND_API.G_RET_STS_SUCCESS;
8523:
8524: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8525: THEN
8526: -- Hint: Validate data
8527: -- IF p_OUTSIDE_PROCESSING_ACCOUNT is not NULL and p_OUTSIDE_PROCESSING_ACCOUNT <> G_MISS_CHAR
8528: -- verify if data is valid
8527: -- IF p_OUTSIDE_PROCESSING_ACCOUNT is not NULL and p_OUTSIDE_PROCESSING_ACCOUNT <> G_MISS_CHAR
8528: -- verify if data is valid
8529: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8530: NULL;
8531: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8532: THEN
8533: -- Hint: Validate data
8534: -- IF p_OUTSIDE_PROCESSING_ACCOUNT <> G_MISS_CHAR
8535: -- verify if data is valid
8549: PROCEDURE Validate_OVERHEAD_ACCOUNT (
8550: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8551: P_Validation_mode IN VARCHAR2,
8552: P_OVERHEAD_ACCOUNT IN NUMBER,
8553: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8554: X_Return_Status OUT NOCOPY VARCHAR2,
8555: X_Msg_Count OUT NOCOPY NUMBER,
8556: X_Msg_Data OUT NOCOPY VARCHAR2
8557: )
8567:
8568: -- Initialize API return status to SUCCESS
8569: x_return_status := FND_API.G_RET_STS_SUCCESS;
8570:
8571: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8572: THEN
8573: -- Hint: Validate data
8574: -- IF p_OVERHEAD_ACCOUNT is not NULL and p_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8575: -- verify if data is valid
8574: -- IF p_OVERHEAD_ACCOUNT is not NULL and p_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8575: -- verify if data is valid
8576: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8577: NULL;
8578: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8579: THEN
8580: -- Hint: Validate data
8581: -- IF p_OVERHEAD_ACCOUNT <> G_MISS_CHAR
8582: -- verify if data is valid
8596: PROCEDURE Validate_FLOW_SCHEDULE (
8597: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8598: P_Validation_mode IN VARCHAR2,
8599: P_FLOW_SCHEDULE IN VARCHAR2,
8600: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8601: X_Return_Status OUT NOCOPY VARCHAR2,
8602: X_Msg_Count OUT NOCOPY NUMBER,
8603: X_Msg_Data OUT NOCOPY VARCHAR2
8604: )
8614:
8615: -- Initialize API return status to SUCCESS
8616: x_return_status := FND_API.G_RET_STS_SUCCESS;
8617:
8618: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8619: THEN
8620: -- Hint: Validate data
8621: -- IF p_FLOW_SCHEDULE is not NULL and p_FLOW_SCHEDULE <> G_MISS_CHAR
8622: -- verify if data is valid
8621: -- IF p_FLOW_SCHEDULE is not NULL and p_FLOW_SCHEDULE <> G_MISS_CHAR
8622: -- verify if data is valid
8623: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8624: NULL;
8625: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8626: THEN
8627: -- Hint: Validate data
8628: -- IF p_FLOW_SCHEDULE <> G_MISS_CHAR
8629: -- verify if data is valid
8643: PROCEDURE Validate_COST_GROUP_ID (
8644: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8645: P_Validation_mode IN VARCHAR2,
8646: P_COST_GROUP_ID IN NUMBER,
8647: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8648: X_Return_Status OUT NOCOPY VARCHAR2,
8649: X_Msg_Count OUT NOCOPY NUMBER,
8650: X_Msg_Data OUT NOCOPY VARCHAR2
8651: )
8661:
8662: -- Initialize API return status to SUCCESS
8663: x_return_status := FND_API.G_RET_STS_SUCCESS;
8664:
8665: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8666: THEN
8667: -- Hint: Validate data
8668: -- IF p_COST_GROUP_ID is not NULL and p_COST_GROUP_ID <> G_MISS_CHAR
8669: -- verify if data is valid
8668: -- IF p_COST_GROUP_ID is not NULL and p_COST_GROUP_ID <> G_MISS_CHAR
8669: -- verify if data is valid
8670: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8671: NULL;
8672: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8673: THEN
8674: -- Hint: Validate data
8675: -- IF p_COST_GROUP_ID <> G_MISS_CHAR
8676: -- verify if data is valid
8690: PROCEDURE Validate_DEMAND_CLASS (
8691: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8692: P_Validation_mode IN VARCHAR2,
8693: P_DEMAND_CLASS IN VARCHAR2,
8694: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8695: X_Return_Status OUT NOCOPY VARCHAR2,
8696: X_Msg_Count OUT NOCOPY NUMBER,
8697: X_Msg_Data OUT NOCOPY VARCHAR2
8698: )
8708:
8709: -- Initialize API return status to SUCCESS
8710: x_return_status := FND_API.G_RET_STS_SUCCESS;
8711:
8712: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8713: THEN
8714: -- Hint: Validate data
8715: -- IF p_DEMAND_CLASS is not NULL and p_DEMAND_CLASS <> G_MISS_CHAR
8716: -- verify if data is valid
8715: -- IF p_DEMAND_CLASS is not NULL and p_DEMAND_CLASS <> G_MISS_CHAR
8716: -- verify if data is valid
8717: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8718: NULL;
8719: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8720: THEN
8721: -- Hint: Validate data
8722: -- IF p_DEMAND_CLASS <> G_MISS_CHAR
8723: -- verify if data is valid
8737: PROCEDURE Validate_QA_COLLECTION_ID (
8738: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8739: P_Validation_mode IN VARCHAR2,
8740: P_QA_COLLECTION_ID IN NUMBER,
8741: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8742: X_Return_Status OUT NOCOPY VARCHAR2,
8743: X_Msg_Count OUT NOCOPY NUMBER,
8744: X_Msg_Data OUT NOCOPY VARCHAR2
8745: )
8755:
8756: -- Initialize API return status to SUCCESS
8757: x_return_status := FND_API.G_RET_STS_SUCCESS;
8758:
8759: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8760: THEN
8761: -- Hint: Validate data
8762: -- IF p_QA_COLLECTION_ID is not NULL and p_QA_COLLECTION_ID <> G_MISS_CHAR
8763: -- verify if data is valid
8762: -- IF p_QA_COLLECTION_ID is not NULL and p_QA_COLLECTION_ID <> G_MISS_CHAR
8763: -- verify if data is valid
8764: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8765: NULL;
8766: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8767: THEN
8768: -- Hint: Validate data
8769: -- IF p_QA_COLLECTION_ID <> G_MISS_CHAR
8770: -- verify if data is valid
8784: PROCEDURE Validate_KANBAN_CARD_ID (
8785: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8786: P_Validation_mode IN VARCHAR2,
8787: P_KANBAN_CARD_ID IN NUMBER,
8788: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8789: X_Return_Status OUT NOCOPY VARCHAR2,
8790: X_Msg_Count OUT NOCOPY NUMBER,
8791: X_Msg_Data OUT NOCOPY VARCHAR2
8792: )
8802:
8803: -- Initialize API return status to SUCCESS
8804: x_return_status := FND_API.G_RET_STS_SUCCESS;
8805:
8806: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8807: THEN
8808: -- Hint: Validate data
8809: -- IF p_KANBAN_CARD_ID is not NULL and p_KANBAN_CARD_ID <> G_MISS_CHAR
8810: -- verify if data is valid
8809: -- IF p_KANBAN_CARD_ID is not NULL and p_KANBAN_CARD_ID <> G_MISS_CHAR
8810: -- verify if data is valid
8811: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8812: NULL;
8813: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8814: THEN
8815: -- Hint: Validate data
8816: -- IF p_KANBAN_CARD_ID <> G_MISS_CHAR
8817: -- verify if data is valid
8831: PROCEDURE Validate_OVERCOMPLETION_TRANSACTION_ID (
8832: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8833: P_Validation_mode IN VARCHAR2,
8834: P_OVERCOMPLETION_TRANSACTION_ID IN NUMBER,
8835: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8836: X_Return_Status OUT NOCOPY VARCHAR2,
8837: X_Msg_Count OUT NOCOPY NUMBER,
8838: X_Msg_Data OUT NOCOPY VARCHAR2
8839: )
8849:
8850: -- Initialize API return status to SUCCESS
8851: x_return_status := FND_API.G_RET_STS_SUCCESS;
8852:
8853: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8854: THEN
8855: -- Hint: Validate data
8856: -- IF p_OVERCOMPLETION_TRANSACTION_ID is not NULL and p_OVERCOMPLETION_TRANSACTION_ID <> G_MISS_CHAR
8857: -- verify if data is valid
8856: -- IF p_OVERCOMPLETION_TRANSACTION_ID is not NULL and p_OVERCOMPLETION_TRANSACTION_ID <> G_MISS_CHAR
8857: -- verify if data is valid
8858: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8859: NULL;
8860: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8861: THEN
8862: -- Hint: Validate data
8863: -- IF p_OVERCOMPLETION_TRANSACTION_ID <> G_MISS_CHAR
8864: -- verify if data is valid
8878: PROCEDURE Validate_OVERCOMPLETION_PRIMARY_QTY (
8879: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8880: P_Validation_mode IN VARCHAR2,
8881: P_OVERCOMPLETION_PRIMARY_QTY IN NUMBER,
8882: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8883: X_Return_Status OUT NOCOPY VARCHAR2,
8884: X_Msg_Count OUT NOCOPY NUMBER,
8885: X_Msg_Data OUT NOCOPY VARCHAR2
8886: )
8896:
8897: -- Initialize API return status to SUCCESS
8898: x_return_status := FND_API.G_RET_STS_SUCCESS;
8899:
8900: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8901: THEN
8902: -- Hint: Validate data
8903: -- IF p_OVERCOMPLETION_PRIMARY_QTY is not NULL and p_OVERCOMPLETION_PRIMARY_QTY <> G_MISS_CHAR
8904: -- verify if data is valid
8903: -- IF p_OVERCOMPLETION_PRIMARY_QTY is not NULL and p_OVERCOMPLETION_PRIMARY_QTY <> G_MISS_CHAR
8904: -- verify if data is valid
8905: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8906: NULL;
8907: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8908: THEN
8909: -- Hint: Validate data
8910: -- IF p_OVERCOMPLETION_PRIMARY_QTY <> G_MISS_CHAR
8911: -- verify if data is valid
8925: PROCEDURE Validate_OVERCOMPLETION_TRANSACTION_QTY (
8926: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8927: P_Validation_mode IN VARCHAR2,
8928: P_OVERCOMPLETION_TRANSACTION_QTY IN NUMBER,
8929: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8930: X_Return_Status OUT NOCOPY VARCHAR2,
8931: X_Msg_Count OUT NOCOPY NUMBER,
8932: X_Msg_Data OUT NOCOPY VARCHAR2
8933: )
8943:
8944: -- Initialize API return status to SUCCESS
8945: x_return_status := FND_API.G_RET_STS_SUCCESS;
8946:
8947: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8948: THEN
8949: -- Hint: Validate data
8950: -- IF p_OVERCOMPLETION_TRANSACTION_QTY is not NULL and p_OVERCOMPLETION_TRANSACTION_QTY <> G_MISS_CHAR
8951: -- verify if data is valid
8950: -- IF p_OVERCOMPLETION_TRANSACTION_QTY is not NULL and p_OVERCOMPLETION_TRANSACTION_QTY <> G_MISS_CHAR
8951: -- verify if data is valid
8952: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8953: NULL;
8954: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
8955: THEN
8956: -- Hint: Validate data
8957: -- IF p_OVERCOMPLETION_TRANSACTION_QTY <> G_MISS_CHAR
8958: -- verify if data is valid
8972: PROCEDURE Validate_PROCESS_TYPE (
8973: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8974: P_Validation_mode IN VARCHAR2,
8975: P_PROCESS_TYPE IN NUMBER,
8976: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
8977: X_Return_Status OUT NOCOPY VARCHAR2,
8978: X_Msg_Count OUT NOCOPY NUMBER,
8979: X_Msg_Data OUT NOCOPY VARCHAR2
8980: )
8990:
8991: -- Initialize API return status to SUCCESS
8992: x_return_status := FND_API.G_RET_STS_SUCCESS;
8993:
8994: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
8995: THEN
8996: -- Hint: Validate data
8997: -- IF p_PROCESS_TYPE is not NULL and p_PROCESS_TYPE <> G_MISS_CHAR
8998: -- verify if data is valid
8997: -- IF p_PROCESS_TYPE is not NULL and p_PROCESS_TYPE <> G_MISS_CHAR
8998: -- verify if data is valid
8999: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9000: NULL;
9001: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9002: THEN
9003: -- Hint: Validate data
9004: -- IF p_PROCESS_TYPE <> G_MISS_CHAR
9005: -- verify if data is valid
9019: PROCEDURE Validate_END_ITEM_UNIT_NUMBER (
9020: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9021: P_Validation_mode IN VARCHAR2,
9022: P_END_ITEM_UNIT_NUMBER IN VARCHAR2,
9023: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9024: X_Return_Status OUT NOCOPY VARCHAR2,
9025: X_Msg_Count OUT NOCOPY NUMBER,
9026: X_Msg_Data OUT NOCOPY VARCHAR2
9027: )
9037:
9038: -- Initialize API return status to SUCCESS
9039: x_return_status := FND_API.G_RET_STS_SUCCESS;
9040:
9041: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9042: THEN
9043: -- Hint: Validate data
9044: -- IF p_END_ITEM_UNIT_NUMBER is not NULL and p_END_ITEM_UNIT_NUMBER <> G_MISS_CHAR
9045: -- verify if data is valid
9044: -- IF p_END_ITEM_UNIT_NUMBER is not NULL and p_END_ITEM_UNIT_NUMBER <> G_MISS_CHAR
9045: -- verify if data is valid
9046: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9047: NULL;
9048: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9049: THEN
9050: -- Hint: Validate data
9051: -- IF p_END_ITEM_UNIT_NUMBER <> G_MISS_CHAR
9052: -- verify if data is valid
9066: PROCEDURE Validate_SCHEDULED_PAYBACK_DATE (
9067: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9068: P_Validation_mode IN VARCHAR2,
9069: P_SCHEDULED_PAYBACK_DATE IN DATE,
9070: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9071: X_Return_Status OUT NOCOPY VARCHAR2,
9072: X_Msg_Count OUT NOCOPY NUMBER,
9073: X_Msg_Data OUT NOCOPY VARCHAR2
9074: )
9084:
9085: -- Initialize API return status to SUCCESS
9086: x_return_status := FND_API.G_RET_STS_SUCCESS;
9087:
9088: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9089: THEN
9090: -- Hint: Validate data
9091: -- IF p_SCHEDULED_PAYBACK_DATE is not NULL and p_SCHEDULED_PAYBACK_DATE <> G_MISS_CHAR
9092: -- verify if data is valid
9091: -- IF p_SCHEDULED_PAYBACK_DATE is not NULL and p_SCHEDULED_PAYBACK_DATE <> G_MISS_CHAR
9092: -- verify if data is valid
9093: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9094: NULL;
9095: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9096: THEN
9097: -- Hint: Validate data
9098: -- IF p_SCHEDULED_PAYBACK_DATE <> G_MISS_CHAR
9099: -- verify if data is valid
9113: PROCEDURE Validate_LINE_TYPE_CODE (
9114: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9115: P_Validation_mode IN VARCHAR2,
9116: P_LINE_TYPE_CODE IN NUMBER,
9117: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9118: X_Return_Status OUT NOCOPY VARCHAR2,
9119: X_Msg_Count OUT NOCOPY NUMBER,
9120: X_Msg_Data OUT NOCOPY VARCHAR2
9121: )
9131:
9132: -- Initialize API return status to SUCCESS
9133: x_return_status := FND_API.G_RET_STS_SUCCESS;
9134:
9135: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9136: THEN
9137: -- Hint: Validate data
9138: -- IF p_LINE_TYPE_CODE is not NULL and p_LINE_TYPE_CODE <> G_MISS_CHAR
9139: -- verify if data is valid
9138: -- IF p_LINE_TYPE_CODE is not NULL and p_LINE_TYPE_CODE <> G_MISS_CHAR
9139: -- verify if data is valid
9140: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9141: NULL;
9142: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9143: THEN
9144: -- Hint: Validate data
9145: -- IF p_LINE_TYPE_CODE <> G_MISS_CHAR
9146: -- verify if data is valid
9160: PROCEDURE Validate_PARENT_TRANSACTION_TEMP_ID (
9161: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9162: P_Validation_mode IN VARCHAR2,
9163: P_PARENT_TRANSACTION_TEMP_ID IN NUMBER,
9164: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9165: X_Return_Status OUT NOCOPY VARCHAR2,
9166: X_Msg_Count OUT NOCOPY NUMBER,
9167: X_Msg_Data OUT NOCOPY VARCHAR2
9168: )
9178:
9179: -- Initialize API return status to SUCCESS
9180: x_return_status := FND_API.G_RET_STS_SUCCESS;
9181:
9182: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9183: THEN
9184: -- Hint: Validate data
9185: -- IF p_PARENT_TRANSACTION_TEMP_ID is not NULL and p_PARENT_TRANSACTION_TEMP_ID <> G_MISS_CHAR
9186: -- verify if data is valid
9185: -- IF p_PARENT_TRANSACTION_TEMP_ID is not NULL and p_PARENT_TRANSACTION_TEMP_ID <> G_MISS_CHAR
9186: -- verify if data is valid
9187: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9188: NULL;
9189: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9190: THEN
9191: -- Hint: Validate data
9192: -- IF p_PARENT_TRANSACTION_TEMP_ID <> G_MISS_CHAR
9193: -- verify if data is valid
9207: PROCEDURE Validate_PUT_AWAY_STRATEGY_ID (
9208: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9209: P_Validation_mode IN VARCHAR2,
9210: P_PUT_AWAY_STRATEGY_ID IN NUMBER,
9211: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9212: X_Return_Status OUT NOCOPY VARCHAR2,
9213: X_Msg_Count OUT NOCOPY NUMBER,
9214: X_Msg_Data OUT NOCOPY VARCHAR2
9215: )
9225:
9226: -- Initialize API return status to SUCCESS
9227: x_return_status := FND_API.G_RET_STS_SUCCESS;
9228:
9229: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9230: THEN
9231: -- Hint: Validate data
9232: -- IF p_PUT_AWAY_STRATEGY_ID is not NULL and p_PUT_AWAY_STRATEGY_ID <> G_MISS_CHAR
9233: -- verify if data is valid
9232: -- IF p_PUT_AWAY_STRATEGY_ID is not NULL and p_PUT_AWAY_STRATEGY_ID <> G_MISS_CHAR
9233: -- verify if data is valid
9234: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9235: NULL;
9236: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9237: THEN
9238: -- Hint: Validate data
9239: -- IF p_PUT_AWAY_STRATEGY_ID <> G_MISS_CHAR
9240: -- verify if data is valid
9254: PROCEDURE Validate_PUT_AWAY_RULE_ID (
9255: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9256: P_Validation_mode IN VARCHAR2,
9257: P_PUT_AWAY_RULE_ID IN NUMBER,
9258: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9259: X_Return_Status OUT NOCOPY VARCHAR2,
9260: X_Msg_Count OUT NOCOPY NUMBER,
9261: X_Msg_Data OUT NOCOPY VARCHAR2
9262: )
9272:
9273: -- Initialize API return status to SUCCESS
9274: x_return_status := FND_API.G_RET_STS_SUCCESS;
9275:
9276: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9277: THEN
9278: -- Hint: Validate data
9279: -- IF p_PUT_AWAY_RULE_ID is not NULL and p_PUT_AWAY_RULE_ID <> G_MISS_CHAR
9280: -- verify if data is valid
9279: -- IF p_PUT_AWAY_RULE_ID is not NULL and p_PUT_AWAY_RULE_ID <> G_MISS_CHAR
9280: -- verify if data is valid
9281: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9282: NULL;
9283: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9284: THEN
9285: -- Hint: Validate data
9286: -- IF p_PUT_AWAY_RULE_ID <> G_MISS_CHAR
9287: -- verify if data is valid
9301: PROCEDURE Validate_PICK_STRATEGY_ID (
9302: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9303: P_Validation_mode IN VARCHAR2,
9304: P_PICK_STRATEGY_ID IN NUMBER,
9305: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9306: X_Return_Status OUT NOCOPY VARCHAR2,
9307: X_Msg_Count OUT NOCOPY NUMBER,
9308: X_Msg_Data OUT NOCOPY VARCHAR2
9309: )
9319:
9320: -- Initialize API return status to SUCCESS
9321: x_return_status := FND_API.G_RET_STS_SUCCESS;
9322:
9323: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9324: THEN
9325: -- Hint: Validate data
9326: -- IF p_PICK_STRATEGY_ID is not NULL and p_PICK_STRATEGY_ID <> G_MISS_CHAR
9327: -- verify if data is valid
9326: -- IF p_PICK_STRATEGY_ID is not NULL and p_PICK_STRATEGY_ID <> G_MISS_CHAR
9327: -- verify if data is valid
9328: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9329: NULL;
9330: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9331: THEN
9332: -- Hint: Validate data
9333: -- IF p_PICK_STRATEGY_ID <> G_MISS_CHAR
9334: -- verify if data is valid
9348: PROCEDURE Validate_PICK_RULE_ID (
9349: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9350: P_Validation_mode IN VARCHAR2,
9351: P_PICK_RULE_ID IN NUMBER,
9352: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9353: X_Return_Status OUT NOCOPY VARCHAR2,
9354: X_Msg_Count OUT NOCOPY NUMBER,
9355: X_Msg_Data OUT NOCOPY VARCHAR2
9356: )
9366:
9367: -- Initialize API return status to SUCCESS
9368: x_return_status := FND_API.G_RET_STS_SUCCESS;
9369:
9370: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9371: THEN
9372: -- Hint: Validate data
9373: -- IF p_PICK_RULE_ID is not NULL and p_PICK_RULE_ID <> G_MISS_CHAR
9374: -- verify if data is valid
9373: -- IF p_PICK_RULE_ID is not NULL and p_PICK_RULE_ID <> G_MISS_CHAR
9374: -- verify if data is valid
9375: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9376: NULL;
9377: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9378: THEN
9379: -- Hint: Validate data
9380: -- IF p_PICK_RULE_ID <> G_MISS_CHAR
9381: -- verify if data is valid
9395: PROCEDURE Validate_COMMON_BOM_SEQ_ID (
9396: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9397: P_Validation_mode IN VARCHAR2,
9398: P_COMMON_BOM_SEQ_ID IN NUMBER,
9399: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9400: X_Return_Status OUT NOCOPY VARCHAR2,
9401: X_Msg_Count OUT NOCOPY NUMBER,
9402: X_Msg_Data OUT NOCOPY VARCHAR2
9403: )
9413:
9414: -- Initialize API return status to SUCCESS
9415: x_return_status := FND_API.G_RET_STS_SUCCESS;
9416:
9417: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9418: THEN
9419: -- Hint: Validate data
9420: -- IF p_COMMON_BOM_SEQ_ID is not NULL and p_COMMON_BOM_SEQ_ID <> G_MISS_CHAR
9421: -- verify if data is valid
9420: -- IF p_COMMON_BOM_SEQ_ID is not NULL and p_COMMON_BOM_SEQ_ID <> G_MISS_CHAR
9421: -- verify if data is valid
9422: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9423: NULL;
9424: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9425: THEN
9426: -- Hint: Validate data
9427: -- IF p_COMMON_BOM_SEQ_ID <> G_MISS_CHAR
9428: -- verify if data is valid
9442: PROCEDURE Validate_COMMON_ROUTING_SEQ_ID (
9443: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9444: P_Validation_mode IN VARCHAR2,
9445: P_COMMON_ROUTING_SEQ_ID IN NUMBER,
9446: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9447: X_Return_Status OUT NOCOPY VARCHAR2,
9448: X_Msg_Count OUT NOCOPY NUMBER,
9449: X_Msg_Data OUT NOCOPY VARCHAR2
9450: )
9460:
9461: -- Initialize API return status to SUCCESS
9462: x_return_status := FND_API.G_RET_STS_SUCCESS;
9463:
9464: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9465: THEN
9466: -- Hint: Validate data
9467: -- IF p_COMMON_ROUTING_SEQ_ID is not NULL and p_COMMON_ROUTING_SEQ_ID <> G_MISS_CHAR
9468: -- verify if data is valid
9467: -- IF p_COMMON_ROUTING_SEQ_ID is not NULL and p_COMMON_ROUTING_SEQ_ID <> G_MISS_CHAR
9468: -- verify if data is valid
9469: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9470: NULL;
9471: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9472: THEN
9473: -- Hint: Validate data
9474: -- IF p_COMMON_ROUTING_SEQ_ID <> G_MISS_CHAR
9475: -- verify if data is valid
9489: PROCEDURE Validate_COST_TYPE_ID (
9490: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9491: P_Validation_mode IN VARCHAR2,
9492: P_COST_TYPE_ID IN NUMBER,
9493: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9494: X_Return_Status OUT NOCOPY VARCHAR2,
9495: X_Msg_Count OUT NOCOPY NUMBER,
9496: X_Msg_Data OUT NOCOPY VARCHAR2
9497: )
9507:
9508: -- Initialize API return status to SUCCESS
9509: x_return_status := FND_API.G_RET_STS_SUCCESS;
9510:
9511: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9512: THEN
9513: -- Hint: Validate data
9514: -- IF p_COST_TYPE_ID is not NULL and p_COST_TYPE_ID <> G_MISS_CHAR
9515: -- verify if data is valid
9514: -- IF p_COST_TYPE_ID is not NULL and p_COST_TYPE_ID <> G_MISS_CHAR
9515: -- verify if data is valid
9516: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9517: NULL;
9518: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9519: THEN
9520: -- Hint: Validate data
9521: -- IF p_COST_TYPE_ID <> G_MISS_CHAR
9522: -- verify if data is valid
9536: PROCEDURE Validate_ORG_COST_GROUP_ID (
9537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9538: P_Validation_mode IN VARCHAR2,
9539: P_ORG_COST_GROUP_ID IN NUMBER,
9540: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9541: X_Return_Status OUT NOCOPY VARCHAR2,
9542: X_Msg_Count OUT NOCOPY NUMBER,
9543: X_Msg_Data OUT NOCOPY VARCHAR2
9544: )
9554:
9555: -- Initialize API return status to SUCCESS
9556: x_return_status := FND_API.G_RET_STS_SUCCESS;
9557:
9558: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9559: THEN
9560: -- Hint: Validate data
9561: -- IF p_ORG_COST_GROUP_ID is not NULL and p_ORG_COST_GROUP_ID <> G_MISS_CHAR
9562: -- verify if data is valid
9561: -- IF p_ORG_COST_GROUP_ID is not NULL and p_ORG_COST_GROUP_ID <> G_MISS_CHAR
9562: -- verify if data is valid
9563: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9564: NULL;
9565: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9566: THEN
9567: -- Hint: Validate data
9568: -- IF p_ORG_COST_GROUP_ID <> G_MISS_CHAR
9569: -- verify if data is valid
9583: PROCEDURE Validate_MOVE_ORDER_LINE_ID (
9584: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9585: P_Validation_mode IN VARCHAR2,
9586: P_MOVE_ORDER_LINE_ID IN NUMBER,
9587: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9588: X_Return_Status OUT NOCOPY VARCHAR2,
9589: X_Msg_Count OUT NOCOPY NUMBER,
9590: X_Msg_Data OUT NOCOPY VARCHAR2
9591: )
9601:
9602: -- Initialize API return status to SUCCESS
9603: x_return_status := FND_API.G_RET_STS_SUCCESS;
9604:
9605: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9606: THEN
9607: -- Hint: Validate data
9608: -- IF p_MOVE_ORDER_LINE_ID is not NULL and p_MOVE_ORDER_LINE_ID <> G_MISS_CHAR
9609: -- verify if data is valid
9608: -- IF p_MOVE_ORDER_LINE_ID is not NULL and p_MOVE_ORDER_LINE_ID <> G_MISS_CHAR
9609: -- verify if data is valid
9610: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9611: NULL;
9612: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9613: THEN
9614: -- Hint: Validate data
9615: -- IF p_MOVE_ORDER_LINE_ID <> G_MISS_CHAR
9616: -- verify if data is valid
9630: PROCEDURE Validate_TASK_GROUP_ID (
9631: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9632: P_Validation_mode IN VARCHAR2,
9633: P_TASK_GROUP_ID IN NUMBER,
9634: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9635: X_Return_Status OUT NOCOPY VARCHAR2,
9636: X_Msg_Count OUT NOCOPY NUMBER,
9637: X_Msg_Data OUT NOCOPY VARCHAR2
9638: )
9648:
9649: -- Initialize API return status to SUCCESS
9650: x_return_status := FND_API.G_RET_STS_SUCCESS;
9651:
9652: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9653: THEN
9654: -- Hint: Validate data
9655: -- IF p_TASK_GROUP_ID is not NULL and p_TASK_GROUP_ID <> G_MISS_CHAR
9656: -- verify if data is valid
9655: -- IF p_TASK_GROUP_ID is not NULL and p_TASK_GROUP_ID <> G_MISS_CHAR
9656: -- verify if data is valid
9657: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9658: NULL;
9659: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9660: THEN
9661: -- Hint: Validate data
9662: -- IF p_TASK_GROUP_ID <> G_MISS_CHAR
9663: -- verify if data is valid
9677: PROCEDURE Validate_PICK_SLIP_NUMBER (
9678: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9679: P_Validation_mode IN VARCHAR2,
9680: P_PICK_SLIP_NUMBER IN NUMBER,
9681: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9682: X_Return_Status OUT NOCOPY VARCHAR2,
9683: X_Msg_Count OUT NOCOPY NUMBER,
9684: X_Msg_Data OUT NOCOPY VARCHAR2
9685: )
9695:
9696: -- Initialize API return status to SUCCESS
9697: x_return_status := FND_API.G_RET_STS_SUCCESS;
9698:
9699: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9700: THEN
9701: -- Hint: Validate data
9702: -- IF p_PICK_SLIP_NUMBER is not NULL and p_PICK_SLIP_NUMBER <> G_MISS_CHAR
9703: -- verify if data is valid
9702: -- IF p_PICK_SLIP_NUMBER is not NULL and p_PICK_SLIP_NUMBER <> G_MISS_CHAR
9703: -- verify if data is valid
9704: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9705: NULL;
9706: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9707: THEN
9708: -- Hint: Validate data
9709: -- IF p_PICK_SLIP_NUMBER <> G_MISS_CHAR
9710: -- verify if data is valid
9724: PROCEDURE Validate_RESERVATION_ID (
9725: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9726: P_Validation_mode IN VARCHAR2,
9727: P_RESERVATION_ID IN NUMBER,
9728: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9729: X_Return_Status OUT NOCOPY VARCHAR2,
9730: X_Msg_Count OUT NOCOPY NUMBER,
9731: X_Msg_Data OUT NOCOPY VARCHAR2
9732: )
9742:
9743: -- Initialize API return status to SUCCESS
9744: x_return_status := FND_API.G_RET_STS_SUCCESS;
9745:
9746: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9747: THEN
9748: -- Hint: Validate data
9749: -- IF p_RESERVATION_ID is not NULL and p_RESERVATION_ID <> G_MISS_CHAR
9750: -- verify if data is valid
9749: -- IF p_RESERVATION_ID is not NULL and p_RESERVATION_ID <> G_MISS_CHAR
9750: -- verify if data is valid
9751: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9752: NULL;
9753: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9754: THEN
9755: -- Hint: Validate data
9756: -- IF p_RESERVATION_ID <> G_MISS_CHAR
9757: -- verify if data is valid
9771: PROCEDURE Validate_TRANSACTION_STATUS (
9772: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9773: P_Validation_mode IN VARCHAR2,
9774: P_TRANSACTION_STATUS IN NUMBER,
9775: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
9776: X_Return_Status OUT NOCOPY VARCHAR2,
9777: X_Msg_Count OUT NOCOPY NUMBER,
9778: X_Msg_Data OUT NOCOPY VARCHAR2
9779: )
9789:
9790: -- Initialize API return status to SUCCESS
9791: x_return_status := FND_API.G_RET_STS_SUCCESS;
9792:
9793: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
9794: THEN
9795: -- Hint: Validate data
9796: -- IF p_TRANSACTION_STATUS is not NULL and p_TRANSACTION_STATUS <> G_MISS_CHAR
9797: -- verify if data is valid
9796: -- IF p_TRANSACTION_STATUS is not NULL and p_TRANSACTION_STATUS <> G_MISS_CHAR
9797: -- verify if data is valid
9798: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9799: NULL;
9800: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
9801: THEN
9802: -- Hint: Validate data
9803: -- IF p_TRANSACTION_STATUS <> G_MISS_CHAR
9804: -- verify if data is valid
9815: END Validate_TRANSACTION_STATUS;
9816:
9817:
9818: -- Hint: inter-field level validation can be added here.
9819: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
9820: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
9821: -- stored in database table.
9822: PROCEDURE Validate_CSP_rec(
9823: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9845: -- THEN
9846: -- x_return_status := FND_API.G_RET_STS_ERROR;
9847:
9848: -- Debug Message
9849: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
9850:
9851: -- Standard call to get message count and if count is 1, get message info.
9852: FND_MSG_PUB.Count_And_Get
9853: ( p_count => x_msg_count,
9869: l_api_name CONSTANT VARCHAR2(30) := 'Validate_material_transactions';
9870: BEGIN
9871:
9872: -- Debug Message
9873: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
9874:
9875:
9876: -- Initialize API return status to SUCCESS
9877: x_return_status := FND_API.G_RET_STS_SUCCESS;
9875:
9876: -- Initialize API return status to SUCCESS
9877: x_return_status := FND_API.G_RET_STS_SUCCESS;
9878:
9879: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
9880: -- Hint: We provide validation procedure for every column. Developer should delete
9881: -- unnecessary validation procedures.
9882: Validate_TRANSACTION_HEADER_ID(
9883: p_init_msg_list => FND_API.G_FALSE,
11824: END IF;
11825:
11826: END IF;
11827:
11828: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
11829: -- Hint: Inter-field level validation can be added here
11830: -- invoke record level validation procedures
11831: Validate_CSP_Rec(
11832: p_init_msg_list => FND_API.G_FALSE,
11840: raise FND_API.G_EXC_ERROR;
11841: END IF;
11842: END IF;
11843:
11844: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
11845: -- invoke inter-record level validation procedures
11846: NULL;
11847: END IF;
11848:
11845: -- invoke inter-record level validation procedures
11846: NULL;
11847: END IF;
11848:
11849: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
11850: -- invoke inter-entity level validation procedures
11851: NULL;
11852: END IF;
11853:
11852: END IF;
11853:
11854:
11855: -- Debug Message
11856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
11857:
11858: END Validate_material_transactions;
11859: */
11860: