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.ASO_RELATED_OBJ_PVT dependencies on ASO_UTILITY_PVT

Line 81: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

77: END IF;
78:
79:
80:
81: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
82:
83:
84:
85: -- Invoke validation procedures

Line 187: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

183: );
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
191: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 191: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

187: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
191: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
192: ,P_SQLCODE => SQLCODE
193: ,P_SQLERRM => SQLERRM
194: ,X_MSG_COUNT => X_MSG_COUNT
195: ,X_MSG_DATA => X_MSG_DATA

Line 199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
200: P_API_NAME => L_API_NAME
201: ,P_PKG_NAME => G_PKG_NAME
202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
200: P_API_NAME => L_API_NAME
201: ,P_PKG_NAME => G_PKG_NAME
202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
204: ,P_SQLCODE => SQLCODE
205: ,P_SQLERRM => SQLERRM
206: ,X_MSG_COUNT => X_MSG_COUNT
207: ,X_MSG_DATA => X_MSG_DATA

Line 211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

207: ,X_MSG_DATA => X_MSG_DATA
208: ,X_RETURN_STATUS => X_RETURN_STATUS);
209:
210: WHEN OTHERS THEN
211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
212: P_API_NAME => L_API_NAME
213: ,P_PKG_NAME => G_PKG_NAME
214: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 214: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

210: WHEN OTHERS THEN
211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
212: P_API_NAME => L_API_NAME
213: ,P_PKG_NAME => G_PKG_NAME
214: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
216: ,P_SQLCODE => SQLCODE
217: ,P_SQLERRM => SQLERRM
218: ,X_MSG_COUNT => X_MSG_COUNT

Line 215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
212: P_API_NAME => L_API_NAME
213: ,P_PKG_NAME => G_PKG_NAME
214: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
216: ,P_SQLCODE => SQLCODE
217: ,P_SQLERRM => SQLERRM
218: ,X_MSG_COUNT => X_MSG_COUNT
219: ,X_MSG_DATA => X_MSG_DATA

Line 333: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

329: END IF;
330: raise FND_API.G_EXC_ERROR;
331: END IF;
332: -- Debug Message
333: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
334: Close C_Get_related_obj;
335:
336:
337:

Line 359: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

355: END IF;
356: raise FND_API.G_EXC_ERROR;
357: End if;
358:
359: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
360:
361: ASO_VALIDATE_PVT.Validate_QTE_OBJ_TYPE_CODE (
362: P_Init_Msg_List => P_Init_Msg_List ,
363: P_QUOTE_OBJECT_TYPE_CODE => P_RELATED_OBJ_Rec.QUOTE_OBJECT_TYPE_CODE,

Line 460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

456: );
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
461: P_API_NAME => L_API_NAME
462: ,P_PKG_NAME => G_PKG_NAME
463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
461: P_API_NAME => L_API_NAME
462: ,P_PKG_NAME => G_PKG_NAME
463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
465: ,P_SQLCODE => SQLCODE
466: ,P_SQLERRM => SQLERRM
467: ,X_MSG_COUNT => X_MSG_COUNT
468: ,X_MSG_DATA => X_MSG_DATA

Line 472: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

468: ,X_MSG_DATA => X_MSG_DATA
469: ,X_RETURN_STATUS => X_RETURN_STATUS);
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
473: P_API_NAME => L_API_NAME
474: ,P_PKG_NAME => G_PKG_NAME
475: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
476: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 476: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

472: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
473: P_API_NAME => L_API_NAME
474: ,P_PKG_NAME => G_PKG_NAME
475: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
476: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
477: ,P_SQLCODE => SQLCODE
478: ,P_SQLERRM => SQLERRM
479: ,X_MSG_COUNT => X_MSG_COUNT
480: ,X_MSG_DATA => X_MSG_DATA

Line 484: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

480: ,X_MSG_DATA => X_MSG_DATA
481: ,X_RETURN_STATUS => X_RETURN_STATUS);
482:
483: WHEN OTHERS THEN
484: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
488: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 487: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

483: WHEN OTHERS THEN
484: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
488: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
489: ,P_SQLCODE => SQLCODE
490: ,P_SQLERRM => SQLERRM
491: ,X_MSG_COUNT => X_MSG_COUNT

Line 488: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

484: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
485: P_API_NAME => L_API_NAME
486: ,P_PKG_NAME => G_PKG_NAME
487: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
488: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
489: ,P_SQLCODE => SQLCODE
490: ,P_SQLERRM => SQLERRM
491: ,X_MSG_COUNT => X_MSG_COUNT
492: ,X_MSG_DATA => X_MSG_DATA

Line 608: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

604: p_data => x_msg_data);
605:
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
609: P_API_NAME => L_API_NAME
610: ,P_PKG_NAME => G_PKG_NAME
611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
612: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 612: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

608: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
609: P_API_NAME => L_API_NAME
610: ,P_PKG_NAME => G_PKG_NAME
611: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
612: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
613: ,P_SQLCODE => SQLCODE
614: ,P_SQLERRM => SQLERRM
615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA

Line 620: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_API_NAME => L_API_NAME
622: ,P_PKG_NAME => G_PKG_NAME
623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
624: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 624: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

620: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_API_NAME => L_API_NAME
622: ,P_PKG_NAME => G_PKG_NAME
623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
624: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
625: ,P_SQLCODE => SQLCODE
626: ,P_SQLERRM => SQLERRM
627: ,X_MSG_COUNT => X_MSG_COUNT
628: ,X_MSG_DATA => X_MSG_DATA

Line 632: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

628: ,X_MSG_DATA => X_MSG_DATA
629: ,X_RETURN_STATUS => X_RETURN_STATUS);
630:
631: WHEN OTHERS THEN
632: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_API_NAME => L_API_NAME
634: ,P_PKG_NAME => G_PKG_NAME
635: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
636: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 635: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

631: WHEN OTHERS THEN
632: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_API_NAME => L_API_NAME
634: ,P_PKG_NAME => G_PKG_NAME
635: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
636: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
637: ,P_SQLCODE => SQLCODE
638: ,P_SQLERRM => SQLERRM
639: ,X_MSG_COUNT => X_MSG_COUNT

Line 636: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

632: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
633: P_API_NAME => L_API_NAME
634: ,P_PKG_NAME => G_PKG_NAME
635: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
636: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
637: ,P_SQLCODE => SQLCODE
638: ,P_SQLERRM => SQLERRM
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA

Line 653: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

649: PROCEDURE Validate_RELATED_OBJECT_ID (
650: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
651: P_Validation_mode IN VARCHAR2,
652: P_RELATED_OBJECT_ID IN NUMBER,
653: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
654: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
655: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
656: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
657: )

Line 674: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATED_OBJECT_ID)');

670:
671: -- validate NOT NULL column
672: IF(p_RELATED_OBJECT_ID is NULL)
673: THEN
674: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATED_OBJECT_ID)');
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677:
678: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 678: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

674: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATED_OBJECT_ID)');
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677:
678: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
679: THEN
680: -- Hint: Validate data
681: -- IF p_RELATED_OBJECT_ID is not NULL and p_RELATED_OBJECT_ID <> G_MISS_CHAR
682: -- verify if data is valid

Line 685: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

681: -- IF p_RELATED_OBJECT_ID is not NULL and p_RELATED_OBJECT_ID <> G_MISS_CHAR
682: -- verify if data is valid
683: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
684: NULL;
685: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
686: THEN
687: -- Hint: Validate data
688: -- IF p_RELATED_OBJECT_ID <> G_MISS_CHAR
689: -- verify if data is valid

Line 707: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

703: PROCEDURE Validate_REQUEST_ID (
704: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
705: P_Validation_mode IN VARCHAR2,
706: P_REQUEST_ID IN NUMBER,
707: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
708: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
709: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
710: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
711: )

Line 725: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

721:
722: -- Initialize API return status to SUCCESS
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724:
725: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
726: THEN
727: -- Hint: Validate data
728: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
729: -- verify if data is valid

Line 732: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

728: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
729: -- verify if data is valid
730: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
731: NULL;
732: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
733: THEN
734: -- Hint: Validate data
735: -- IF p_REQUEST_ID <> G_MISS_CHAR
736: -- verify if data is valid

Line 754: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

750: PROCEDURE Validate_PROGRAM_APPL_ID (
751: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
752: P_Validation_mode IN VARCHAR2,
753: P_PROGRAM_APPLICATION_ID IN NUMBER,
754: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
755: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
756: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
757: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
758: )

Line 772: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

768:
769: -- Initialize API return status to SUCCESS
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
773: THEN
774: -- Hint: Validate data
775: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
776: -- verify if data is valid

Line 779: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

775: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
776: -- verify if data is valid
777: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
778: NULL;
779: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
780: THEN
781: -- Hint: Validate data
782: -- IF p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
783: -- verify if data is valid

Line 801: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

797: PROCEDURE Validate_PROGRAM_ID (
798: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
799: P_Validation_mode IN VARCHAR2,
800: P_PROGRAM_ID IN NUMBER,
801: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
802: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
803: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
804: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
805: )

Line 819: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

815:
816: -- Initialize API return status to SUCCESS
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
820: THEN
821: -- Hint: Validate data
822: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
823: -- verify if data is valid

Line 826: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

822: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
823: -- verify if data is valid
824: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
825: NULL;
826: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
827: THEN
828: -- Hint: Validate data
829: -- IF p_PROGRAM_ID <> G_MISS_CHAR
830: -- verify if data is valid

Line 848: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

844: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
845: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
846: P_Validation_mode IN VARCHAR2,
847: P_PROGRAM_UPDATE_DATE IN DATE,
848: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
849: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
850: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
851: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
852: )

Line 866: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

862:
863: -- Initialize API return status to SUCCESS
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
867: THEN
868: -- Hint: Validate data
869: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
870: -- verify if data is valid

Line 873: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

869: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
870: -- verify if data is valid
871: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
872: NULL;
873: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
874: THEN
875: -- Hint: Validate data
876: -- IF p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
877: -- verify if data is valid

Line 895: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

891: PROCEDURE Validate_QTE_OBJ_TYPE_CODE (
892: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
893: P_Validation_mode IN VARCHAR2,
894: P_QUOTE_OBJECT_TYPE_CODE IN VARCHAR2,
895: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
896: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
897: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
898: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
899: )

Line 914: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

910:
911: -- Initialize API return status to SUCCESS
912: x_return_status := FND_API.G_RET_STS_SUCCESS;
913:
914: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
915: THEN
916: -- Hint: Validate data
917: -- IF p_QUOTE_OBJECT_TYPE_CODE is not NULL and p_QUOTE_OBJECT_TYPE_CODE <> G_MISS_CHAR
918: -- verify if data is valid

Line 931: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

927: IF l_count < 1 THEN
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: END IF;
930:
931: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
932: THEN
933: -- Hint: Validate data
934: -- IF p_QUOTE_OBJECT_TYPE_CODE <> G_MISS_CHAR
935: -- verify if data is valid

Line 964: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

960: PROCEDURE Validate_QUOTE_OBJECT_ID (
961: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
962: P_Validation_mode IN VARCHAR2,
963: P_QUOTE_OBJECT_ID IN NUMBER,
964: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
965: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
966: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
967: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
968: )

Line 985: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_ID)');

981:
982: -- validate NOT NULL column
983: IF(p_QUOTE_OBJECT_ID is NULL)
984: THEN
985: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_ID)');
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: END IF;
988: /*
989: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 989: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

985: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_ID)');
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: END IF;
988: /*
989: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
990: THEN
991: -- Hint: Validate data
992: -- IF p_QUOTE_OBJECT_ID is not NULL and p_QUOTE_OBJECT_ID <> G_MISS_CHAR
993: -- verify if data is valid

Line 998: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

994: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
995: NULL;
996:
997:
998: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
999: THEN
1000: -- Hint: Validate data
1001: -- IF p_QUOTE_OBJECT_ID <> G_MISS_CHAR
1002: -- verify if data is valid

Line 1023: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1019: PROCEDURE Validate_OBJECT_TYPE_CODE (
1020: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1021: P_Validation_mode IN VARCHAR2,
1022: P_OBJECT_TYPE_CODE IN VARCHAR2,
1023: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1024: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1025: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1026: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1027: )

Line 1045: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');

1041:
1042: -- validate NOT NULL column
1043: IF(p_OBJECT_TYPE_CODE is NULL)
1044: THEN
1045: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: END IF;
1048:
1049: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1049: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1045: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: END IF;
1048:
1049: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1050: THEN
1051: -- Hint: Validate data
1052: -- IF p_OBJECT_TYPE_CODE is not NULL and p_OBJECT_TYPE_CODE <> G_MISS_CHAR
1053: -- verify if data is valid

Line 1066: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1062: IF l_count < 1 THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1065:
1066: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1067: THEN
1068: -- Hint: Validate data
1069: -- IF p_OBJECT_TYPE_CODE <> G_MISS_CHAR
1070: -- verify if data is valid

Line 1099: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1095: PROCEDURE Validate_OBJECT_ID (
1096: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1097: P_Validation_mode IN VARCHAR2,
1098: P_OBJECT_ID IN NUMBER,
1099: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1100: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1101: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1102: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1103: )

Line 1117: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1113:
1114: -- Initialize API return status to SUCCESS
1115: x_return_status := FND_API.G_RET_STS_SUCCESS;
1116:
1117: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1118: THEN
1119: -- Hint: Validate data
1120: -- IF p_OBJECT_ID is not NULL and p_OBJECT_ID <> G_MISS_CHAR
1121: -- verify if data is valid

Line 1124: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1120: -- IF p_OBJECT_ID is not NULL and p_OBJECT_ID <> G_MISS_CHAR
1121: -- verify if data is valid
1122: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1123: NULL;
1124: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1125: THEN
1126: -- Hint: Validate data
1127: -- IF p_OBJECT_ID <> G_MISS_CHAR
1128: -- verify if data is valid

Line 1146: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1142: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
1143: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1144: P_Validation_mode IN VARCHAR2,
1145: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
1146: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1147: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1148: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1149: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1150: )

Line 1168: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');

1164:
1165: -- validate NOT NULL column
1166: IF(p_RELATIONSHIP_TYPE_CODE is NULL)
1167: THEN
1168: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: END IF;
1171:
1172: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1172: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1168: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: END IF;
1171:
1172: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1173: THEN
1174: -- Hint: Validate data
1175: -- IF p_RELATIONSHIP_TYPE_CODE is not NULL and p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
1176: -- verify if data is valid

Line 1189: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1185: IF l_count < 1 THEN
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: END IF;
1188:
1189: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1190: THEN
1191: -- Hint: Validate data
1192: -- IF p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
1193: -- verify if data is valid

Line 1222: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1218: PROCEDURE Validate_RECIPROCAL_FLAG (
1219: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1220: P_Validation_mode IN VARCHAR2,
1221: P_RECIPROCAL_FLAG IN VARCHAR2,
1222: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1223: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1224: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1225: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1226: )

Line 1240: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1236:
1237: -- Initialize API return status to SUCCESS
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;
1239:
1240: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1241: THEN
1242: -- Hint: Validate data
1243: -- IF p_RECIPROCAL_FLAG is not NULL and p_RECIPROCAL_FLAG <> G_MISS_CHAR
1244: -- verify if data is valid

Line 1251: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1247: IF (p_RECIPROCAL_FLAG <> FND_API.G_TRUE or p_RECIPROCAL_FLAG <> FND_API.G_FALSE) THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: END IF;
1250:
1251: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1252: THEN
1253: -- Hint: Validate data
1254: -- IF p_RECIPROCAL_FLAG <> G_MISS_CHAR
1255: -- verify if data is valid

Line 1278: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1274: PROCEDURE Validate_QUOTE_OBJECT_CODE (
1275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1276: P_Validation_mode IN VARCHAR2,
1277: P_QUOTE_OBJECT_CODE IN NUMBER,
1278: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ ASO_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1279: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1280: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1281: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1282: )

Line 1299: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_CODE)');

1295:
1296: -- validate NOT NULL column
1297: IF(p_QUOTE_OBJECT_CODE is NULL)
1298: THEN
1299: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_CODE)');
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: END IF;
1302:
1303: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1303: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1299: --ASO_UTILITY_PVT.Print('ERROR', 'Private related_obj API: -Violate NOT NULL constraint(QUOTE_OBJECT_CODE)');
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: END IF;
1302:
1303: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1304: THEN
1305: -- Hint: Validate data
1306: -- IF p_QUOTE_OBJECT_CODE is not NULL and p_QUOTE_OBJECT_CODE <> G_MISS_CHAR
1307: -- verify if data is valid

Line 1310: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1306: -- IF p_QUOTE_OBJECT_CODE is not NULL and p_QUOTE_OBJECT_CODE <> G_MISS_CHAR
1307: -- verify if data is valid
1308: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1309: NULL;
1310: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1311: THEN
1312: -- Hint: Validate data
1313: -- IF p_QUOTE_OBJECT_CODE <> G_MISS_CHAR
1314: -- verify if data is valid

Line 1329: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor

1325: END Validate_QUOTE_OBJECT_CODE;
1326:
1327:
1328: -- Hint: inter-field level validation can be added here.
1329: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1330: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1331: -- stored in database table.
1332: PROCEDURE Validate_RELATED_OBJ_rec(
1333: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1388: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1384: END IF;
1385: END IF;
1386:
1387: -- Debug Message
1388: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1389:
1390: -- Standard call to get message count and if count is 1, get message info.
1391: FND_MSG_PUB.Count_And_Get
1392: ( p_count => x_msg_count,

Line 1412: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1408: l_api_name CONSTANT VARCHAR2(30) := 'Validate_related_obj';
1409: BEGIN
1410:
1411: -- Debug Message
1412: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1413:
1414:
1415: -- Initialize API return status to SUCCESS
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1418: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

1414:
1415: -- Initialize API return status to SUCCESS
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417:
1418: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
1419: -- Hint: We provide validation procedure for every column. Developer should delete
1420: -- unnecessary validation procedures.
1421: Validate_RELATED_OBJECT_ID(
1422: p_init_msg_list => FND_API.G_FALSE,

Line 1567: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD) THEN

1563: END IF;
1564:
1565: END IF;
1566:
1567: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD) THEN
1568: -- Hint: Inter-field level validation can be added here
1569: -- invoke record level validation procedures
1570: Validate_RELATED_OBJ_Rec(
1571: p_init_msg_list => FND_API.G_FALSE,

Line 1583: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD) THEN

1579: raise FND_API.G_EXC_ERROR;
1580: END IF;
1581: END IF;
1582:
1583: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD) THEN
1584: -- invoke inter-record level validation procedures
1585: NULL;
1586: END IF;
1587:

Line 1588: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY) THEN

1584: -- invoke inter-record level validation procedures
1585: NULL;
1586: END IF;
1587:
1588: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY) THEN
1589: -- invoke inter-entity level validation procedures
1590: NULL;
1591: END IF;
1592:

Line 1595: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1591: END IF;
1592:
1593:
1594: -- Debug Message
1595: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1596:
1597: END Validate_related_obj;
1598:
1599: End aso_RELATED_OBJ_PVT;