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_LITIGATION_PVT dependencies on AS_UTILITY_PVT

Line 109: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

105: -- Invoke validation procedures
106: Validate_litigation(
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_LTG_Rec => P_LTG_Rec,
111: x_return_status => x_return_status,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data);

Line 220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

216: );
217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
221: P_API_NAME => L_API_NAME
222: ,P_PKG_NAME => G_PKG_NAME
223: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
224: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 224: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
221: P_API_NAME => L_API_NAME
222: ,P_PKG_NAME => G_PKG_NAME
223: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
224: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
225: ,X_MSG_COUNT => X_MSG_COUNT
226: ,X_MSG_DATA => X_MSG_DATA
227: ,X_RETURN_STATUS => X_RETURN_STATUS);
228:

Line 230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 234: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

236: ,X_MSG_DATA => X_MSG_DATA
237: ,X_RETURN_STATUS => X_RETURN_STATUS);
238:
239: WHEN OTHERS THEN
240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
241: P_API_NAME => L_API_NAME
242: ,P_PKG_NAME => G_PKG_NAME
243: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
244: ,P_SQLCODE => SQLCODE

Line 243: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

239: WHEN OTHERS THEN
240: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
241: P_API_NAME => L_API_NAME
242: ,P_PKG_NAME => G_PKG_NAME
243: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
244: ,P_SQLCODE => SQLCODE
245: ,P_SQLERRM => SQLERRM
246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
247: ,X_MSG_COUNT => X_MSG_COUNT

Line 246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

242: ,P_PKG_NAME => G_PKG_NAME
243: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
244: ,P_SQLCODE => SQLCODE
245: ,P_SQLERRM => SQLERRM
246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
247: ,X_MSG_COUNT => X_MSG_COUNT
248: ,X_MSG_DATA => X_MSG_DATA
249: ,X_RETURN_STATUS => X_RETURN_STATUS);
250: End Create_litigation;

Line 452: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

448: -- Invoke validation procedures
449: Validate_litigation(
450: p_init_msg_list => FND_API.G_FALSE,
451: p_validation_level => p_validation_level,
452: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
453: P_LTG_Rec => P_LTG_Rec,
454: x_return_status => x_return_status,
455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data);

Line 558: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

554: );
555:
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
562: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 562: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

558: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
562: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
563: ,X_MSG_COUNT => X_MSG_COUNT
564: ,X_MSG_DATA => X_MSG_DATA
565: ,X_RETURN_STATUS => X_RETURN_STATUS);
566:

Line 568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

564: ,X_MSG_DATA => X_MSG_DATA
565: ,X_RETURN_STATUS => X_RETURN_STATUS);
566:
567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
569: P_API_NAME => L_API_NAME
570: ,P_PKG_NAME => G_PKG_NAME
571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
572: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 572: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

568: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
569: P_API_NAME => L_API_NAME
570: ,P_PKG_NAME => G_PKG_NAME
571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
572: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
573: ,X_MSG_COUNT => X_MSG_COUNT
574: ,X_MSG_DATA => X_MSG_DATA
575: ,X_RETURN_STATUS => X_RETURN_STATUS);
576:

Line 578: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

574: ,X_MSG_DATA => X_MSG_DATA
575: ,X_RETURN_STATUS => X_RETURN_STATUS);
576:
577: WHEN OTHERS THEN
578: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
579: P_API_NAME => L_API_NAME
580: ,P_PKG_NAME => G_PKG_NAME
581: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
582: ,P_SQLCODE => SQLCODE

Line 581: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

577: WHEN OTHERS THEN
578: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
579: P_API_NAME => L_API_NAME
580: ,P_PKG_NAME => G_PKG_NAME
581: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
582: ,P_SQLCODE => SQLCODE
583: ,P_SQLERRM => SQLERRM
584: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
585: ,X_MSG_COUNT => X_MSG_COUNT

Line 584: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

580: ,P_PKG_NAME => G_PKG_NAME
581: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
582: ,P_SQLCODE => SQLCODE
583: ,P_SQLERRM => SQLERRM
584: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
585: ,X_MSG_COUNT => X_MSG_COUNT
586: ,X_MSG_DATA => X_MSG_DATA
587: ,X_RETURN_STATUS => X_RETURN_STATUS);
588: End Update_litigation;

Line 712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

708: );
709:
710: EXCEPTION
711: WHEN FND_API.G_EXC_ERROR THEN
712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
713: P_API_NAME => L_API_NAME
714: ,P_PKG_NAME => G_PKG_NAME
715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
716: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 716: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

712: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
713: P_API_NAME => L_API_NAME
714: ,P_PKG_NAME => G_PKG_NAME
715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
716: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
717: ,X_MSG_COUNT => X_MSG_COUNT
718: ,X_MSG_DATA => X_MSG_DATA
719: ,X_RETURN_STATUS => X_RETURN_STATUS);
720:

Line 722: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

718: ,X_MSG_DATA => X_MSG_DATA
719: ,X_RETURN_STATUS => X_RETURN_STATUS);
720:
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
723: P_API_NAME => L_API_NAME
724: ,P_PKG_NAME => G_PKG_NAME
725: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
726: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 726: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

722: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
723: P_API_NAME => L_API_NAME
724: ,P_PKG_NAME => G_PKG_NAME
725: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
726: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
727: ,X_MSG_COUNT => X_MSG_COUNT
728: ,X_MSG_DATA => X_MSG_DATA
729: ,X_RETURN_STATUS => X_RETURN_STATUS);
730:

Line 732: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

728: ,X_MSG_DATA => X_MSG_DATA
729: ,X_RETURN_STATUS => X_RETURN_STATUS);
730:
731: WHEN OTHERS THEN
732: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
733: P_API_NAME => L_API_NAME
734: ,P_PKG_NAME => G_PKG_NAME
735: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
736: ,P_SQLCODE => SQLCODE

Line 735: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

731: WHEN OTHERS THEN
732: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
733: P_API_NAME => L_API_NAME
734: ,P_PKG_NAME => G_PKG_NAME
735: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
736: ,P_SQLCODE => SQLCODE
737: ,P_SQLERRM => SQLERRM
738: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
739: ,X_MSG_COUNT => X_MSG_COUNT

Line 738: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

734: ,P_PKG_NAME => G_PKG_NAME
735: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
736: ,P_SQLCODE => SQLCODE
737: ,P_SQLERRM => SQLERRM
738: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
739: ,X_MSG_COUNT => X_MSG_COUNT
740: ,X_MSG_DATA => X_MSG_DATA
741: ,X_RETURN_STATUS => X_RETURN_STATUS);
742: End Delete_litigation;

Line 834: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;

830: x_msg_data OUT NOCOPY VARCHAR2
831: )
832: IS
833: l_order_by_cl VARCHAR2(1000) := NULL;
834: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;
835: BEGIN
836:
837: -- Hint: Developer should add more statements according to IEX_sort_rec_type
838: -- Ex:

Line 843: AS_UTILITY_PVT.Translate_OrderBy(

839: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
840: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
841:
842:
843: AS_UTILITY_PVT.Translate_OrderBy(
844: p_api_version_number => 1.0
845: ,p_init_msg_list => FND_API.G_FALSE
846: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
847: ,p_order_by_tbl => l_util_order_by_tbl

Line 1263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1259: );
1260:
1261: EXCEPTION
1262: WHEN FND_API.G_EXC_ERROR THEN
1263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1264: P_API_NAME => L_API_NAME
1265: ,P_PKG_NAME => G_PKG_NAME
1266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1263: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1264: P_API_NAME => L_API_NAME
1265: ,P_PKG_NAME => G_PKG_NAME
1266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1267: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1268: ,X_MSG_COUNT => X_MSG_COUNT
1269: ,X_MSG_DATA => X_MSG_DATA
1270: ,X_RETURN_STATUS => X_RETURN_STATUS);
1271:

Line 1273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1269: ,X_MSG_DATA => X_MSG_DATA
1270: ,X_RETURN_STATUS => X_RETURN_STATUS);
1271:
1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1274: P_API_NAME => L_API_NAME
1275: ,P_PKG_NAME => G_PKG_NAME
1276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1277: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1277: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1273: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1274: P_API_NAME => L_API_NAME
1275: ,P_PKG_NAME => G_PKG_NAME
1276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1277: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1278: ,X_MSG_COUNT => X_MSG_COUNT
1279: ,X_MSG_DATA => X_MSG_DATA
1280: ,X_RETURN_STATUS => X_RETURN_STATUS);
1281:

Line 1283: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1279: ,X_MSG_DATA => X_MSG_DATA
1280: ,X_RETURN_STATUS => X_RETURN_STATUS);
1281:
1282: WHEN OTHERS THEN
1283: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1287: ,P_SQLCODE => SQLCODE

Line 1286: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1282: WHEN OTHERS THEN
1283: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1287: ,P_SQLCODE => SQLCODE
1288: ,P_SQLERRM => SQLERRM
1289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1290: ,X_MSG_COUNT => X_MSG_COUNT

Line 1289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1287: ,P_SQLCODE => SQLCODE
1288: ,P_SQLERRM => SQLERRM
1289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1290: ,X_MSG_COUNT => X_MSG_COUNT
1291: ,X_MSG_DATA => X_MSG_DATA
1292: ,X_RETURN_STATUS => X_RETURN_STATUS);
1293: End Get_litigation;

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

1297: PROCEDURE Validate_LITIGATION_ID (
1298: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1299: P_Validation_mode IN VARCHAR2,
1300: P_LITIGATION_ID IN NUMBER,
1301: -- 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.
1302: X_Return_Status OUT NOCOPY VARCHAR2,
1303: X_Msg_Count OUT NOCOPY NUMBER,
1304: X_Msg_Data OUT NOCOPY VARCHAR2
1305: )

Line 1325: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1321: THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: END IF;
1324:
1325: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1326: THEN
1327: -- Hint: Validate data
1328: -- IF p_LITIGATION_ID is not NULL and p_LITIGATION_ID <> G_MISS_CHAR
1329: -- verify if data is valid

Line 1332: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

1328: -- IF p_LITIGATION_ID is not NULL and p_LITIGATION_ID <> G_MISS_CHAR
1329: -- verify if data is valid
1330: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1331: NULL;
1332: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
1333: THEN
1334: -- Hint: Validate data
1335: -- IF p_LITIGATION_ID <> G_MISS_CHAR
1336: -- verify if data is valid

Line 1354: -- 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: PROCEDURE Validate_DELINQUENCY_ID (
1351: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1352: P_Validation_mode IN VARCHAR2,
1353: P_DELINQUENCY_ID IN NUMBER,
1354: -- 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.
1355: X_Return_Status OUT NOCOPY VARCHAR2,
1356: X_Msg_Count OUT NOCOPY NUMBER,
1357: X_Msg_Data OUT NOCOPY VARCHAR2
1358: )

Line 1372: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1368:
1369: -- Initialize API return status to SUCCESS
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1373: THEN
1374: -- Hint: Validate data
1375: -- IF p_DELINQUENCY_ID is not NULL and p_DELINQUENCY_ID <> G_MISS_CHAR
1376: -- verify if data is valid

Line 1379: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1419: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1426: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1466: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1473: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1513: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1520: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1560: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1567: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1607: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1614: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1654: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1661: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1701: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1708: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1748: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1755: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1795: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

1791:
1792: -- Initialize API return status to SUCCESS
1793: x_return_status := FND_API.G_RET_STS_SUCCESS;
1794:
1795: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
1796: THEN
1797: -- Hint: Validate data
1798: -- IF p_SUGGESTION_APPROVED_FLAG is not NULL and p_SUGGESTION_APPROVED_FLAG <> G_MISS_CHAR
1799: -- verify if data is valid

Line 1802: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

1817: END v_SUGGESTION_APPROVED_FLAG;
1818:
1819:
1820: -- Hint: inter-field level validation can be added here.
1821: -- Hint: If p_validation_mode = AS_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1822: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1823: -- stored in database table.
1824: PROCEDURE Validate_LTG_rec(
1825: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,