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

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

Line 225: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 231: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 235: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 241: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 244: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 247: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 453: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

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

Line 560: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 564: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 570: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 574: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 580: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 583: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 586: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 714: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 718: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 724: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 728: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 734: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 737: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 740: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 836: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;

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

Line 845: AS_UTILITY_PVT.Translate_OrderBy(

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

Line 1265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1269: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 1275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1279: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

Line 1285: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1288: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

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

Line 1291: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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

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

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

Line 1327: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1334: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

Line 1374: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1381: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1421: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1428: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1468: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1475: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1515: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1522: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1562: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1569: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1609: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1616: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1656: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1663: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1703: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1710: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1750: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1757: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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

Line 1797: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

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

Line 1804: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

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

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

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