eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_REPOSSESSION_PVT dependencies on AS_UTILITY_PVT

Line 109: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

105: -- Invoke validation procedures
106: Validate_repossession(
107: p_init_msg_list => FND_API.G_FALSE,
108: p_validation_level => p_validation_level,
109: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
110: P_RPS_Rec => P_RPS_Rec,
111: x_return_status => x_return_status,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data);

Line 226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

222: );
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_ERROR THEN
226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

226: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:

Line 236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
237: P_API_NAME => L_API_NAME
238: ,P_PKG_NAME => G_PKG_NAME
239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
240: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
241: ,X_MSG_COUNT => X_MSG_COUNT
242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
244:

Line 246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

242: ,X_MSG_DATA => X_MSG_DATA
243: ,X_RETURN_STATUS => X_RETURN_STATUS);
244:
245: WHEN OTHERS THEN
246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
250: ,P_SQLCODE => SQLCODE

Line 249: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

245: WHEN OTHERS THEN
246: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
250: ,P_SQLCODE => SQLCODE
251: ,P_SQLERRM => SQLERRM
252: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
253: ,X_MSG_COUNT => X_MSG_COUNT

Line 252: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
250: ,P_SQLCODE => SQLCODE
251: ,P_SQLERRM => SQLERRM
252: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
253: ,X_MSG_COUNT => X_MSG_COUNT
254: ,X_MSG_DATA => X_MSG_DATA
255: ,X_RETURN_STATUS => X_RETURN_STATUS);
256: End Create_repossession;

Line 468: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

464: -- Invoke validation procedures
465: Validate_repossession(
466: p_init_msg_list => FND_API.G_FALSE,
467: p_validation_level => p_validation_level,
468: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
469: P_RPS_Rec => P_RPS_Rec,
470: x_return_status => x_return_status,
471: x_msg_count => x_msg_count,
472: x_msg_data => x_msg_data);

Line 579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

575: );
576:
577: EXCEPTION
578: WHEN FND_API.G_EXC_ERROR THEN
579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME
581: ,P_PKG_NAME => G_PKG_NAME
582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

579: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME
581: ,P_PKG_NAME => G_PKG_NAME
582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
583: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
584: ,X_MSG_COUNT => X_MSG_COUNT
585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
587:

Line 589: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
587:
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
593: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 593: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

589: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
593: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
594: ,X_MSG_COUNT => X_MSG_COUNT
595: ,X_MSG_DATA => X_MSG_DATA
596: ,X_RETURN_STATUS => X_RETURN_STATUS);
597:

Line 599: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

595: ,X_MSG_DATA => X_MSG_DATA
596: ,X_RETURN_STATUS => X_RETURN_STATUS);
597:
598: WHEN OTHERS THEN
599: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
600: P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
603: ,P_SQLCODE => SQLCODE

Line 602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

598: WHEN OTHERS THEN
599: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
600: P_API_NAME => L_API_NAME
601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
603: ,P_SQLCODE => SQLCODE
604: ,P_SQLERRM => SQLERRM
605: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
606: ,X_MSG_COUNT => X_MSG_COUNT

Line 605: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

601: ,P_PKG_NAME => G_PKG_NAME
602: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
603: ,P_SQLCODE => SQLCODE
604: ,P_SQLERRM => SQLERRM
605: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
606: ,X_MSG_COUNT => X_MSG_COUNT
607: ,X_MSG_DATA => X_MSG_DATA
608: ,X_RETURN_STATUS => X_RETURN_STATUS);
609: End Update_repossession;

Line 733: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

729: );
730:
731: EXCEPTION
732: WHEN FND_API.G_EXC_ERROR THEN
733: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
737: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 737: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

733: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
737: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
738: ,X_MSG_COUNT => X_MSG_COUNT
739: ,X_MSG_DATA => X_MSG_DATA
740: ,X_RETURN_STATUS => X_RETURN_STATUS);
741:

Line 743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

739: ,X_MSG_DATA => X_MSG_DATA
740: ,X_RETURN_STATUS => X_RETURN_STATUS);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
744: P_API_NAME => L_API_NAME
745: ,P_PKG_NAME => G_PKG_NAME
746: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
747: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 747: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

743: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
744: P_API_NAME => L_API_NAME
745: ,P_PKG_NAME => G_PKG_NAME
746: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
747: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
748: ,X_MSG_COUNT => X_MSG_COUNT
749: ,X_MSG_DATA => X_MSG_DATA
750: ,X_RETURN_STATUS => X_RETURN_STATUS);
751:

Line 753: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

749: ,X_MSG_DATA => X_MSG_DATA
750: ,X_RETURN_STATUS => X_RETURN_STATUS);
751:
752: WHEN OTHERS THEN
753: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
754: P_API_NAME => L_API_NAME
755: ,P_PKG_NAME => G_PKG_NAME
756: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
757: ,P_SQLCODE => SQLCODE

Line 756: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

752: WHEN OTHERS THEN
753: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
754: P_API_NAME => L_API_NAME
755: ,P_PKG_NAME => G_PKG_NAME
756: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
757: ,P_SQLCODE => SQLCODE
758: ,P_SQLERRM => SQLERRM
759: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
760: ,X_MSG_COUNT => X_MSG_COUNT

Line 759: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

755: ,P_PKG_NAME => G_PKG_NAME
756: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
757: ,P_SQLCODE => SQLCODE
758: ,P_SQLERRM => SQLERRM
759: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
760: ,X_MSG_COUNT => X_MSG_COUNT
761: ,X_MSG_DATA => X_MSG_DATA
762: ,X_RETURN_STATUS => X_RETURN_STATUS);
763: End Delete_repossession;

Line 873: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;

869: x_msg_data OUT NOCOPY VARCHAR2
870: )
871: IS
872: l_order_by_cl VARCHAR2(1000) := NULL;
873: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;
874: BEGIN
875:
876: -- Hint: Developer should add more statements according to IEX_sort_rec_type
877: -- Ex:

Line 882: AS_UTILITY_PVT.Translate_OrderBy(

878: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
879: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
880:
881:
882: AS_UTILITY_PVT.Translate_OrderBy(
883: p_api_version_number => 1.0
884: ,p_init_msg_list => FND_API.G_FALSE
885: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
886: ,p_order_by_tbl => l_util_order_by_tbl

Line 1313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1309: );
1310:
1311: EXCEPTION
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1317: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1317: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1314: P_API_NAME => L_API_NAME
1315: ,P_PKG_NAME => G_PKG_NAME
1316: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1317: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1318: ,X_MSG_COUNT => X_MSG_COUNT
1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321:

Line 1323: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1319: ,X_MSG_DATA => X_MSG_DATA
1320: ,X_RETURN_STATUS => X_RETURN_STATUS);
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1324: P_API_NAME => L_API_NAME
1325: ,P_PKG_NAME => G_PKG_NAME
1326: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1323: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1324: P_API_NAME => L_API_NAME
1325: ,P_PKG_NAME => G_PKG_NAME
1326: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1327: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1328: ,X_MSG_COUNT => X_MSG_COUNT
1329: ,X_MSG_DATA => X_MSG_DATA
1330: ,X_RETURN_STATUS => X_RETURN_STATUS);
1331:

Line 1333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1329: ,X_MSG_DATA => X_MSG_DATA
1330: ,X_RETURN_STATUS => X_RETURN_STATUS);
1331:
1332: WHEN OTHERS THEN
1333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1334: P_API_NAME => L_API_NAME
1335: ,P_PKG_NAME => G_PKG_NAME
1336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1337: ,P_SQLCODE => SQLCODE

Line 1336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1332: WHEN OTHERS THEN
1333: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1334: P_API_NAME => L_API_NAME
1335: ,P_PKG_NAME => G_PKG_NAME
1336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1337: ,P_SQLCODE => SQLCODE
1338: ,P_SQLERRM => SQLERRM
1339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1340: ,X_MSG_COUNT => X_MSG_COUNT

Line 1339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1335: ,P_PKG_NAME => G_PKG_NAME
1336: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1337: ,P_SQLCODE => SQLCODE
1338: ,P_SQLERRM => SQLERRM
1339: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1340: ,X_MSG_COUNT => X_MSG_COUNT
1341: ,X_MSG_DATA => X_MSG_DATA
1342: ,X_RETURN_STATUS => X_RETURN_STATUS);
1343: End Get_repossession;

Line 1351: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1347: PROCEDURE Validate_REPOSSESSION_ID (
1348: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1349: P_Validation_mode IN VARCHAR2,
1350: P_REPOSSESSION_ID IN NUMBER,
1351: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1352: X_Return_Status OUT NOCOPY VARCHAR2,
1353: X_Msg_Count OUT NOCOPY NUMBER,
1354: X_Msg_Data OUT NOCOPY VARCHAR2
1355: )

Line 1375: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1371: THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374:
1375: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1376: THEN
1377: -- Hint: Validate data
1378: -- IF p_REPOSSESSION_ID is not NULL and p_REPOSSESSION_ID <> G_MISS_CHAR
1379: -- verify if data is valid

Line 1382: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1378: -- IF p_REPOSSESSION_ID is not NULL and p_REPOSSESSION_ID <> G_MISS_CHAR
1379: -- verify if data is valid
1380: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1381: NULL;
1382: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1383: THEN
1384: -- Hint: Validate data
1385: -- IF p_REPOSSESSION_ID <> G_MISS_CHAR
1386: -- verify if data is valid

Line 1404: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1400: PROCEDURE Validate_DELINQUENCY_ID (
1401: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1402: P_Validation_mode IN VARCHAR2,
1403: P_DELINQUENCY_ID IN NUMBER,
1404: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1405: X_Return_Status OUT NOCOPY VARCHAR2,
1406: X_Msg_Count OUT NOCOPY NUMBER,
1407: X_Msg_Data OUT NOCOPY VARCHAR2
1408: )

Line 1422: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1418:
1419: -- Initialize API return status to SUCCESS
1420: x_return_status := FND_API.G_RET_STS_SUCCESS;
1421:
1422: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1423: THEN
1424: -- Hint: Validate data
1425: -- IF p_DELINQUENCY_ID is not NULL and p_DELINQUENCY_ID <> G_MISS_CHAR
1426: -- verify if data is valid

Line 1429: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1425: -- IF p_DELINQUENCY_ID is not NULL and p_DELINQUENCY_ID <> G_MISS_CHAR
1426: -- verify if data is valid
1427: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1428: NULL;
1429: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1430: THEN
1431: -- Hint: Validate data
1432: -- IF p_DELINQUENCY_ID <> G_MISS_CHAR
1433: -- verify if data is valid

Line 1451: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1447: PROCEDURE Validate_PARTY_ID (
1448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1449: P_Validation_mode IN VARCHAR2,
1450: P_PARTY_ID IN NUMBER,
1451: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1452: X_Return_Status OUT NOCOPY VARCHAR2,
1453: X_Msg_Count OUT NOCOPY NUMBER,
1454: X_Msg_Data OUT NOCOPY VARCHAR2
1455: )

Line 1469: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1465:
1466: -- Initialize API return status to SUCCESS
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1470: THEN
1471: -- Hint: Validate data
1472: -- IF p_PARTY_ID is not NULL and p_PARTY_ID <> G_MISS_CHAR
1473: -- verify if data is valid

Line 1476: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1472: -- IF p_PARTY_ID is not NULL and p_PARTY_ID <> G_MISS_CHAR
1473: -- verify if data is valid
1474: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1475: NULL;
1476: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1477: THEN
1478: -- Hint: Validate data
1479: -- IF p_PARTY_ID <> G_MISS_CHAR
1480: -- verify if data is valid

Line 1498: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1494: PROCEDURE Validate_CUST_ACCOUNT_ID (
1495: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1496: P_Validation_mode IN VARCHAR2,
1497: P_CUST_ACCOUNT_ID IN NUMBER,
1498: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1499: X_Return_Status OUT NOCOPY VARCHAR2,
1500: X_Msg_Count OUT NOCOPY NUMBER,
1501: X_Msg_Data OUT NOCOPY VARCHAR2
1502: )

Line 1516: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1512:
1513: -- Initialize API return status to SUCCESS
1514: x_return_status := FND_API.G_RET_STS_SUCCESS;
1515:
1516: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1517: THEN
1518: -- Hint: Validate data
1519: -- IF p_CUST_ACCOUNT_ID is not NULL and p_CUST_ACCOUNT_ID <> G_MISS_CHAR
1520: -- verify if data is valid

Line 1523: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1519: -- IF p_CUST_ACCOUNT_ID is not NULL and p_CUST_ACCOUNT_ID <> G_MISS_CHAR
1520: -- verify if data is valid
1521: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1522: NULL;
1523: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1524: THEN
1525: -- Hint: Validate data
1526: -- IF p_CUST_ACCOUNT_ID <> G_MISS_CHAR
1527: -- verify if data is valid

Line 1545: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1541: PROCEDURE Validate_UNPAID_REASON_CODE (
1542: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1543: P_Validation_mode IN VARCHAR2,
1544: P_UNPAID_REASON_CODE IN VARCHAR2,
1545: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1546: X_Return_Status OUT NOCOPY VARCHAR2,
1547: X_Msg_Count OUT NOCOPY NUMBER,
1548: X_Msg_Data OUT NOCOPY VARCHAR2
1549: )

Line 1563: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1559:
1560: -- Initialize API return status to SUCCESS
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1564: THEN
1565: -- Hint: Validate data
1566: -- IF p_UNPAID_REASON_CODE is not NULL and p_UNPAID_REASON_CODE <> G_MISS_CHAR
1567: -- verify if data is valid

Line 1570: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1566: -- IF p_UNPAID_REASON_CODE is not NULL and p_UNPAID_REASON_CODE <> G_MISS_CHAR
1567: -- verify if data is valid
1568: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1569: NULL;
1570: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1571: THEN
1572: -- Hint: Validate data
1573: -- IF p_UNPAID_REASON_CODE <> G_MISS_CHAR
1574: -- verify if data is valid

Line 1592: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1588: PROCEDURE Validate_REMARKET_FLAG (
1589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1590: P_Validation_mode IN VARCHAR2,
1591: P_REMARKET_FLAG IN VARCHAR2,
1592: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1593: X_Return_Status OUT NOCOPY VARCHAR2,
1594: X_Msg_Count OUT NOCOPY NUMBER,
1595: X_Msg_Data OUT NOCOPY VARCHAR2
1596: )

Line 1610: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1606:
1607: -- Initialize API return status to SUCCESS
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1611: THEN
1612: -- Hint: Validate data
1613: -- IF p_REMARKET_FLAG is not NULL and p_REMARKET_FLAG <> G_MISS_CHAR
1614: -- verify if data is valid

Line 1617: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1613: -- IF p_REMARKET_FLAG is not NULL and p_REMARKET_FLAG <> G_MISS_CHAR
1614: -- verify if data is valid
1615: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1616: NULL;
1617: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1618: THEN
1619: -- Hint: Validate data
1620: -- IF p_REMARKET_FLAG <> G_MISS_CHAR
1621: -- verify if data is valid

Line 1639: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1635: PROCEDURE Validate_REPOSSESSION_DATE (
1636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1637: P_Validation_mode IN VARCHAR2,
1638: P_REPOSSESSION_DATE IN DATE,
1639: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1640: X_Return_Status OUT NOCOPY VARCHAR2,
1641: X_Msg_Count OUT NOCOPY NUMBER,
1642: X_Msg_Data OUT NOCOPY VARCHAR2
1643: )

Line 1657: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1653:
1654: -- Initialize API return status to SUCCESS
1655: x_return_status := FND_API.G_RET_STS_SUCCESS;
1656:
1657: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1658: THEN
1659: -- Hint: Validate data
1660: -- IF p_REPOSSESSION_DATE is not NULL and p_REPOSSESSION_DATE <> G_MISS_CHAR
1661: -- verify if data is valid

Line 1664: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1660: -- IF p_REPOSSESSION_DATE is not NULL and p_REPOSSESSION_DATE <> G_MISS_CHAR
1661: -- verify if data is valid
1662: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1663: NULL;
1664: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1665: THEN
1666: -- Hint: Validate data
1667: -- IF p_REPOSSESSION_DATE <> G_MISS_CHAR
1668: -- verify if data is valid

Line 1686: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1682: PROCEDURE Validate_ASSET_ID (
1683: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1684: P_Validation_mode IN VARCHAR2,
1685: P_ASSET_ID IN NUMBER,
1686: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1687: X_Return_Status OUT NOCOPY VARCHAR2,
1688: X_Msg_Count OUT NOCOPY NUMBER,
1689: X_Msg_Data OUT NOCOPY VARCHAR2
1690: )

Line 1704: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1700:
1701: -- Initialize API return status to SUCCESS
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703:
1704: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1705: THEN
1706: -- Hint: Validate data
1707: -- IF p_ASSET_ID is not NULL and p_ASSET_ID <> G_MISS_CHAR
1708: -- verify if data is valid

Line 1711: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1707: -- IF p_ASSET_ID is not NULL and p_ASSET_ID <> G_MISS_CHAR
1708: -- verify if data is valid
1709: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1710: NULL;
1711: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1712: THEN
1713: -- Hint: Validate data
1714: -- IF p_ASSET_ID <> G_MISS_CHAR
1715: -- verify if data is valid

Line 1733: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1729: PROCEDURE Validate_ASSET_VALUE (
1730: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1731: P_Validation_mode IN VARCHAR2,
1732: P_ASSET_VALUE IN NUMBER,
1733: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1734: X_Return_Status OUT NOCOPY VARCHAR2,
1735: X_Msg_Count OUT NOCOPY NUMBER,
1736: X_Msg_Data OUT NOCOPY VARCHAR2
1737: )

Line 1751: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1747:
1748: -- Initialize API return status to SUCCESS
1749: x_return_status := FND_API.G_RET_STS_SUCCESS;
1750:
1751: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1752: THEN
1753: -- Hint: Validate data
1754: -- IF p_ASSET_VALUE is not NULL and p_ASSET_VALUE <> G_MISS_CHAR
1755: -- verify if data is valid

Line 1758: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1754: -- IF p_ASSET_VALUE is not NULL and p_ASSET_VALUE <> G_MISS_CHAR
1755: -- verify if data is valid
1756: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1757: NULL;
1758: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1759: THEN
1760: -- Hint: Validate data
1761: -- IF p_ASSET_VALUE <> G_MISS_CHAR
1762: -- verify if data is valid

Line 1780: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1776: PROCEDURE Validate_ASSET_NUMBER (
1777: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1778: P_Validation_mode IN VARCHAR2,
1779: P_ASSET_NUMBER IN NUMBER,
1780: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1781: X_Return_Status OUT NOCOPY VARCHAR2,
1782: X_Msg_Count OUT NOCOPY NUMBER,
1783: X_Msg_Data OUT NOCOPY VARCHAR2
1784: )

Line 1804: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1800: THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: END IF;
1803:
1804: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1805: THEN
1806: -- Hint: Validate data
1807: -- IF p_ASSET_NUMBER is not NULL and p_ASSET_NUMBER <> G_MISS_CHAR
1808: -- verify if data is valid

Line 1811: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1807: -- IF p_ASSET_NUMBER is not NULL and p_ASSET_NUMBER <> G_MISS_CHAR
1808: -- verify if data is valid
1809: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1810: NULL;
1811: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1812: THEN
1813: -- Hint: Validate data
1814: -- IF p_ASSET_NUMBER <> G_MISS_CHAR
1815: -- verify if data is valid

Line 1833: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1829: PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
1830: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1831: P_Validation_mode IN VARCHAR2,
1832: P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
1833: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1834: X_Return_Status OUT NOCOPY VARCHAR2,
1835: X_Msg_Count OUT NOCOPY NUMBER,
1836: X_Msg_Data OUT NOCOPY VARCHAR2
1837: )

Line 1851: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1847:
1848: -- Initialize API return status to SUCCESS
1849: x_return_status := FND_API.G_RET_STS_SUCCESS;
1850:
1851: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1852: THEN
1853: -- Hint: Validate data
1854: -- IF p_CREDIT_HOLD_REQUEST_FLAG is not NULL and p_CREDIT_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1855: -- verify if data is valid

Line 1858: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1854: -- IF p_CREDIT_HOLD_REQUEST_FLAG is not NULL and p_CREDIT_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1855: -- verify if data is valid
1856: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1857: NULL;
1858: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1859: THEN
1860: -- Hint: Validate data
1861: -- IF p_CREDIT_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1862: -- verify if data is valid

Line 1880: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1876: PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
1877: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1878: P_Validation_mode IN VARCHAR2,
1879: P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
1880: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1881: X_Return_Status OUT NOCOPY VARCHAR2,
1882: X_Msg_Count OUT NOCOPY NUMBER,
1883: X_Msg_Data OUT NOCOPY VARCHAR2
1884: )

Line 1898: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1894:
1895: -- Initialize API return status to SUCCESS
1896: x_return_status := FND_API.G_RET_STS_SUCCESS;
1897:
1898: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1899: THEN
1900: -- Hint: Validate data
1901: -- IF p_CREDIT_HOLD_APPROVED_FLAG is not NULL and p_CREDIT_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1902: -- verify if data is valid

Line 1905: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1901: -- IF p_CREDIT_HOLD_APPROVED_FLAG is not NULL and p_CREDIT_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1902: -- verify if data is valid
1903: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1904: NULL;
1905: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1906: THEN
1907: -- Hint: Validate data
1908: -- IF p_CREDIT_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1909: -- verify if data is valid

Line 1927: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1923: PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
1924: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1925: P_Validation_mode IN VARCHAR2,
1926: P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
1927: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1928: X_Return_Status OUT NOCOPY VARCHAR2,
1929: X_Msg_Count OUT NOCOPY NUMBER,
1930: X_Msg_Data OUT NOCOPY VARCHAR2
1931: )

Line 1945: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1941:
1942: -- Initialize API return status to SUCCESS
1943: x_return_status := FND_API.G_RET_STS_SUCCESS;
1944:
1945: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1946: THEN
1947: -- Hint: Validate data
1948: -- IF p_SERVICE_HOLD_REQUEST_FLAG is not NULL and p_SERVICE_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1949: -- verify if data is valid

Line 1952: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1948: -- IF p_SERVICE_HOLD_REQUEST_FLAG is not NULL and p_SERVICE_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1949: -- verify if data is valid
1950: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1951: NULL;
1952: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1953: THEN
1954: -- Hint: Validate data
1955: -- IF p_SERVICE_HOLD_REQUEST_FLAG <> G_MISS_CHAR
1956: -- verify if data is valid

Line 1974: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1970: PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
1971: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1972: P_Validation_mode IN VARCHAR2,
1973: P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
1974: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1975: X_Return_Status OUT NOCOPY VARCHAR2,
1976: X_Msg_Count OUT NOCOPY NUMBER,
1977: X_Msg_Data OUT NOCOPY VARCHAR2
1978: )

Line 1992: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1988:
1989: -- Initialize API return status to SUCCESS
1990: x_return_status := FND_API.G_RET_STS_SUCCESS;
1991:
1992: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1993: THEN
1994: -- Hint: Validate data
1995: -- IF p_SERVICE_HOLD_APPROVED_FLAG is not NULL and p_SERVICE_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1996: -- verify if data is valid

Line 1999: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1995: -- IF p_SERVICE_HOLD_APPROVED_FLAG is not NULL and p_SERVICE_HOLD_APPROVED_FLAG <> G_MISS_CHAR
1996: -- verify if data is valid
1997: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1998: NULL;
1999: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2000: THEN
2001: -- Hint: Validate data
2002: -- IF p_SERVICE_HOLD_APPROVED_FLAG <> G_MISS_CHAR
2003: -- verify if data is valid

Line 2021: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2017: PROCEDURE v_SUGGESTION_APPROVED_FLAG (
2018: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2019: P_Validation_mode IN VARCHAR2,
2020: P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
2021: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2022: X_Return_Status OUT NOCOPY VARCHAR2,
2023: X_Msg_Count OUT NOCOPY NUMBER,
2024: X_Msg_Data OUT NOCOPY VARCHAR2
2025: )

Line 2039: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

2035:
2036: -- Initialize API return status to SUCCESS
2037: x_return_status := FND_API.G_RET_STS_SUCCESS;
2038:
2039: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
2040: THEN
2041: -- Hint: Validate data
2042: -- IF p_SUGGESTION_APPROVED_FLAG is not NULL and p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
2043: -- verify if data is valid

Line 2046: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

2042: -- IF p_SUGGESTION_APPROVED_FLAG is not NULL and p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
2043: -- verify if data is valid
2044: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2045: NULL;
2046: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
2047: THEN
2048: -- Hint: Validate data
2049: -- IF p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
2050: -- verify if data is valid

Line 2065: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor

2061: END v_SUGGESTION_APPROVED_FLAG;
2062:
2063:
2064: -- Hint: inter-field level validation can be added here.
2065: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
2066: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
2067: -- stored in database table.
2068: PROCEDURE Validate_RPS_rec(
2069: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,