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 225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 229: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 235: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 239: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 245: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 248: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 251: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 467: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

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

Line 577: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 581: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 587: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 591: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 597: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 600: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 603: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 731: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 735: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 741: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 745: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 751: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 754: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 757: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 871: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;

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

Line 880: AS_UTILITY_PVT.Translate_OrderBy(

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

Line 1311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 1321: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 1331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1334: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 1337: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 1349: -- 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.

1345: PROCEDURE Validate_REPOSSESSION_ID (
1346: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1347: P_Validation_mode IN VARCHAR2,
1348: P_REPOSSESSION_ID IN NUMBER,
1349: -- 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.
1350: X_Return_Status OUT NOCOPY VARCHAR2,
1351: X_Msg_Count OUT NOCOPY NUMBER,
1352: X_Msg_Data OUT NOCOPY VARCHAR2
1353: )

Line 1373: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1380: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1402: -- 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.

1398: PROCEDURE Validate_DELINQUENCY_ID (
1399: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1400: P_Validation_mode IN VARCHAR2,
1401: P_DELINQUENCY_ID IN NUMBER,
1402: -- 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.
1403: X_Return_Status OUT NOCOPY VARCHAR2,
1404: X_Msg_Count OUT NOCOPY NUMBER,
1405: X_Msg_Data OUT NOCOPY VARCHAR2
1406: )

Line 1420: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1427: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1449: -- 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.

1445: PROCEDURE Validate_PARTY_ID (
1446: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1447: P_Validation_mode IN VARCHAR2,
1448: P_PARTY_ID IN NUMBER,
1449: -- 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.
1450: X_Return_Status OUT NOCOPY VARCHAR2,
1451: X_Msg_Count OUT NOCOPY NUMBER,
1452: X_Msg_Data OUT NOCOPY VARCHAR2
1453: )

Line 1467: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1474: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1496: -- 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.

1492: PROCEDURE Validate_CUST_ACCOUNT_ID (
1493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1494: P_Validation_mode IN VARCHAR2,
1495: P_CUST_ACCOUNT_ID IN NUMBER,
1496: -- 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.
1497: X_Return_Status OUT NOCOPY VARCHAR2,
1498: X_Msg_Count OUT NOCOPY NUMBER,
1499: X_Msg_Data OUT NOCOPY VARCHAR2
1500: )

Line 1514: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1521: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1543: -- 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.

1539: PROCEDURE Validate_UNPAID_REASON_CODE (
1540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1541: P_Validation_mode IN VARCHAR2,
1542: P_UNPAID_REASON_CODE IN VARCHAR2,
1543: -- 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.
1544: X_Return_Status OUT NOCOPY VARCHAR2,
1545: X_Msg_Count OUT NOCOPY NUMBER,
1546: X_Msg_Data OUT NOCOPY VARCHAR2
1547: )

Line 1561: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1568: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1590: -- 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.

1586: PROCEDURE Validate_REMARKET_FLAG (
1587: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1588: P_Validation_mode IN VARCHAR2,
1589: P_REMARKET_FLAG IN VARCHAR2,
1590: -- 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.
1591: X_Return_Status OUT NOCOPY VARCHAR2,
1592: X_Msg_Count OUT NOCOPY NUMBER,
1593: X_Msg_Data OUT NOCOPY VARCHAR2
1594: )

Line 1608: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1615: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1637: -- 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.

1633: PROCEDURE Validate_REPOSSESSION_DATE (
1634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: P_Validation_mode IN VARCHAR2,
1636: P_REPOSSESSION_DATE IN DATE,
1637: -- 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.
1638: X_Return_Status OUT NOCOPY VARCHAR2,
1639: X_Msg_Count OUT NOCOPY NUMBER,
1640: X_Msg_Data OUT NOCOPY VARCHAR2
1641: )

Line 1655: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1662: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1684: -- 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.

1680: PROCEDURE Validate_ASSET_ID (
1681: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1682: P_Validation_mode IN VARCHAR2,
1683: P_ASSET_ID IN NUMBER,
1684: -- 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.
1685: X_Return_Status OUT NOCOPY VARCHAR2,
1686: X_Msg_Count OUT NOCOPY NUMBER,
1687: X_Msg_Data OUT NOCOPY VARCHAR2
1688: )

Line 1702: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1709: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1731: -- 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.

1727: PROCEDURE Validate_ASSET_VALUE (
1728: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1729: P_Validation_mode IN VARCHAR2,
1730: P_ASSET_VALUE IN NUMBER,
1731: -- 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.
1732: X_Return_Status OUT NOCOPY VARCHAR2,
1733: X_Msg_Count OUT NOCOPY NUMBER,
1734: X_Msg_Data OUT NOCOPY VARCHAR2
1735: )

Line 1749: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1756: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1778: -- 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.

1774: PROCEDURE Validate_ASSET_NUMBER (
1775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1776: P_Validation_mode IN VARCHAR2,
1777: P_ASSET_NUMBER IN NUMBER,
1778: -- 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.
1779: X_Return_Status OUT NOCOPY VARCHAR2,
1780: X_Msg_Count OUT NOCOPY NUMBER,
1781: X_Msg_Data OUT NOCOPY VARCHAR2
1782: )

Line 1802: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1809: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1831: -- 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.

1827: PROCEDURE v_CREDIT_HOLD_REQUEST_FLAG (
1828: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1829: P_Validation_mode IN VARCHAR2,
1830: P_CREDIT_HOLD_REQUEST_FLAG IN VARCHAR2,
1831: -- 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.
1832: X_Return_Status OUT NOCOPY VARCHAR2,
1833: X_Msg_Count OUT NOCOPY NUMBER,
1834: X_Msg_Data OUT NOCOPY VARCHAR2
1835: )

Line 1849: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1856: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1878: -- 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.

1874: PROCEDURE v_CREDIT_HOLD_APPROVED_FLAG (
1875: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1876: P_Validation_mode IN VARCHAR2,
1877: P_CREDIT_HOLD_APPROVED_FLAG IN VARCHAR2,
1878: -- 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.
1879: X_Return_Status OUT NOCOPY VARCHAR2,
1880: X_Msg_Count OUT NOCOPY NUMBER,
1881: X_Msg_Data OUT NOCOPY VARCHAR2
1882: )

Line 1896: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1903: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1925: -- 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.

1921: PROCEDURE v_SERVICE_HOLD_REQUEST_FLAG (
1922: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1923: P_Validation_mode IN VARCHAR2,
1924: P_SERVICE_HOLD_REQUEST_FLAG IN VARCHAR2,
1925: -- 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.
1926: X_Return_Status OUT NOCOPY VARCHAR2,
1927: X_Msg_Count OUT NOCOPY NUMBER,
1928: X_Msg_Data OUT NOCOPY VARCHAR2
1929: )

Line 1943: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1950: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 1972: -- 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.

1968: PROCEDURE v_SERVICE_HOLD_APPROVED_FLAG (
1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Validation_mode IN VARCHAR2,
1971: P_SERVICE_HOLD_APPROVED_FLAG IN VARCHAR2,
1972: -- 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.
1973: X_Return_Status OUT NOCOPY VARCHAR2,
1974: X_Msg_Count OUT NOCOPY NUMBER,
1975: X_Msg_Data OUT NOCOPY VARCHAR2
1976: )

Line 1990: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1997: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

Line 2019: -- 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.

2015: PROCEDURE v_SUGGESTION_APPROVED_FLAG (
2016: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2017: P_Validation_mode IN VARCHAR2,
2018: P_SUGGESTION_APPROVED_FLAG IN VARCHAR2,
2019: -- 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.
2020: X_Return_Status OUT NOCOPY VARCHAR2,
2021: X_Msg_Count OUT NOCOPY NUMBER,
2022: X_Msg_Data OUT NOCOPY VARCHAR2
2023: )

Line 2037: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 2044: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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