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_LINE_ATTRIBS_PVT dependencies on ASO_UTILITY_PVT

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

54: END IF;
55:
56:
57: -- Debug Message
58: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
59:
60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 116: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_attribs');

112:
113: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
114: THEN
115: -- Debug message
116: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_attribs');
117:
118: -- Invoke validation procedures
119: Validate_line_attribs(
120: p_init_msg_list => FND_API.G_FALSE,

Line 122: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,

118: -- Invoke validation procedures
119: Validate_line_attribs(
120: p_init_msg_list => FND_API.G_FALSE,
121: p_validation_level => p_validation_level,
122: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,
123: P_LINE_ATTRIBS_Rec => P_LINE_ATTRIBS_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);

Line 136: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

132:
133: -- Hint: Add corresponding Master-Detail business logic here if necessary.
134:
135: -- Debug Message
136: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
137:
138: -- Invoke table handler(ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row)
139: ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
140: px_LINE_ATTRIBUTE_ID => x_LINE_ATTRIB_ID,

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

178: END IF;
179:
180:
181: -- Debug Message
182: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
183:
184:
185: -- Standard call to get message count and if count is 1, get message info.
186: FND_MSG_PUB.Count_And_Get

Line 210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

206: END IF;
207: */
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
211: P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME
213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
211: P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME
213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
215: ,X_MSG_COUNT => X_MSG_COUNT
216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:

Line 220: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ASO_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_UNEXP_ERROR
224: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 224: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

220: ASO_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_UNEXP_ERROR
224: ,P_PACKAGE_TYPE => ASO_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: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

226: ,X_MSG_DATA => X_MSG_DATA
227: ,X_RETURN_STATUS => X_RETURN_STATUS);
228:
229: WHEN OTHERS THEN
230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
231: P_API_NAME => L_API_NAME
232: ,P_PKG_NAME => G_PKG_NAME
233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

229: WHEN OTHERS THEN
230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
231: P_API_NAME => L_API_NAME
232: ,P_PKG_NAME => G_PKG_NAME
233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
234: ,P_PACKAGE_TYPE => ASO_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);

Line 234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
231: P_API_NAME => L_API_NAME
232: ,P_PKG_NAME => G_PKG_NAME
233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
234: ,P_PACKAGE_TYPE => ASO_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: End Create_line_attribs;

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

309: END IF;
310:
311:
312: -- Debug Message
313: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
314:
315:
316: -- Initialize API return status to SUCCESS
317: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 354: ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

350: RAISE FND_API.G_EXC_ERROR;
351: END IF;
352:
353: -- Debug Message
354: ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
355:
356: */
357: Open C_Get_line_attribs( l_tar_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID);
358:

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

387: END IF;
388: raise FND_API.G_EXC_ERROR;
389: END IF;
390: -- Debug Message
391: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
392: Close C_Get_line_attribs;
393:
394:
395:

Line 420: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_attribs');

416:
417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
418: THEN
419: -- Debug message
420: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_attribs');
421:
422: -- Invoke validation procedures
423: Validate_line_attribs(
424: p_init_msg_list => FND_API.G_FALSE,

Line 426: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,

422: -- Invoke validation procedures
423: Validate_line_attribs(
424: p_init_msg_list => FND_API.G_FALSE,
425: p_validation_level => p_validation_level,
426: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,
427: P_LINE_ATTRIBS_Rec => P_LINE_ATTRIBS_Rec,
428: x_return_status => x_return_status,
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data);

Line 440: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

436:
437: -- Hint: Add corresponding Master-Detail business logic here if necessary.
438:
439: -- Debug Message
440: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
441:
442: -- Invoke table handler(ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Update_Row)
443: ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Update_Row(
444: p_LINE_ATTRIBUTE_ID => p_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID,

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

475: END IF;
476:
477:
478: -- Debug Message
479: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
480:
481:
482: -- Standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get

Line 508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

504: END IF;
505: */
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MSG_DATA
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516:

Line 518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

514: ,X_MSG_DATA => X_MSG_DATA
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
519: P_API_NAME => L_API_NAME
520: ,P_PKG_NAME => G_PKG_NAME
521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
519: P_API_NAME => L_API_NAME
520: ,P_PKG_NAME => G_PKG_NAME
521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
523: ,X_MSG_COUNT => X_MSG_COUNT
524: ,X_MSG_DATA => X_MSG_DATA
525: ,X_RETURN_STATUS => X_RETURN_STATUS);
526:

Line 528: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

524: ,X_MSG_DATA => X_MSG_DATA
525: ,X_RETURN_STATUS => X_RETURN_STATUS);
526:
527: WHEN OTHERS THEN
528: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
532: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 531: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

527: WHEN OTHERS THEN
528: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
532: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
533: ,X_MSG_COUNT => X_MSG_COUNT
534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 532: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

528: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
529: P_API_NAME => L_API_NAME
530: ,P_PKG_NAME => G_PKG_NAME
531: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
532: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
533: ,X_MSG_COUNT => X_MSG_COUNT
534: ,X_MSG_DATA => X_MSG_DATA
535: ,X_RETURN_STATUS => X_RETURN_STATUS);
536: End Update_line_attribs;

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

575: END IF;
576:
577:
578: -- Debug Message
579: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
580:
581:
582: -- Initialize API return status to SUCCESS
583: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 620: ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618:
619: -- Debug Message
620: ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
621: */
622: -- Invoke table handler(ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Delete_Row)
623: ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Delete_Row(
624: p_LINE_ATTRIB_ID => p_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID);

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

633: END IF;
634:
635:
636: -- Debug Message
637: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get

Line 666: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

662: END IF;
663: */
664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_API_NAME => L_API_NAME
668: ,P_PKG_NAME => G_PKG_NAME
669: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
670: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 670: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

666: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_API_NAME => L_API_NAME
668: ,P_PKG_NAME => G_PKG_NAME
669: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
670: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
671: ,X_MSG_COUNT => X_MSG_COUNT
672: ,X_MSG_DATA => X_MSG_DATA
673: ,X_RETURN_STATUS => X_RETURN_STATUS);
674:

Line 676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

672: ,X_MSG_DATA => X_MSG_DATA
673: ,X_RETURN_STATUS => X_RETURN_STATUS);
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
677: P_API_NAME => L_API_NAME
678: ,P_PKG_NAME => G_PKG_NAME
679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
677: P_API_NAME => L_API_NAME
678: ,P_PKG_NAME => G_PKG_NAME
679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
681: ,X_MSG_COUNT => X_MSG_COUNT
682: ,X_MSG_DATA => X_MSG_DATA
683: ,X_RETURN_STATUS => X_RETURN_STATUS);
684:

Line 686: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

682: ,X_MSG_DATA => X_MSG_DATA
683: ,X_RETURN_STATUS => X_RETURN_STATUS);
684:
685: WHEN OTHERS THEN
686: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
690: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 689: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

685: WHEN OTHERS THEN
686: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
690: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
691: ,X_MSG_COUNT => X_MSG_COUNT
692: ,X_MSG_DATA => X_MSG_DATA
693: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 690: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

686: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
690: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
691: ,X_MSG_COUNT => X_MSG_COUNT
692: ,X_MSG_DATA => X_MSG_DATA
693: ,X_RETURN_STATUS => X_RETURN_STATUS);
694: End Delete_line_attribs;

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

701: PROCEDURE Validate_LINE_ATTRIBUTE_ID (
702: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
703: P_Validation_mode IN VARCHAR2,
704: P_LINE_ATTRIBUTE_ID IN NUMBER,
705: -- 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.
706: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
707: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
708: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
709: )

Line 726: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(LINE_ATTRIBUTE_ID)');

722:
723: -- validate NOT NULL column
724: IF(p_LINE_ATTRIBUTE_ID is NULL)
725: THEN
726: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(LINE_ATTRIBUTE_ID)');
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729:
730: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 730: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

726: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(LINE_ATTRIBUTE_ID)');
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729:
730: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
731: THEN
732: -- Hint: Validate data
733: -- IF p_LINE_ATTRIBUTE_ID is not NULL and p_LINE_ATTRIBUTE_ID <> G_MISS_CHAR
734: -- verify if data is valid

Line 737: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

733: -- IF p_LINE_ATTRIBUTE_ID is not NULL and p_LINE_ATTRIBUTE_ID <> G_MISS_CHAR
734: -- verify if data is valid
735: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
736: NULL;
737: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
738: THEN
739: -- Hint: Validate data
740: -- IF p_LINE_ATTRIBUTE_ID <> G_MISS_CHAR
741: -- verify if data is valid

Line 759: -- 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: PROCEDURE Validate_REQUEST_ID (
756: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
757: P_Validation_mode IN VARCHAR2,
758: P_REQUEST_ID IN NUMBER,
759: -- 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.
760: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
761: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
762: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
763: )

Line 777: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

773:
774: -- Initialize API return status to SUCCESS
775: x_return_status := FND_API.G_RET_STS_SUCCESS;
776:
777: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
778: THEN
779: -- Hint: Validate data
780: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
781: -- verify if data is valid

Line 784: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

780: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
781: -- verify if data is valid
782: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
783: NULL;
784: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
785: THEN
786: -- Hint: Validate data
787: -- IF p_REQUEST_ID <> G_MISS_CHAR
788: -- verify if data is valid

Line 806: -- 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: PROCEDURE Validate_PROG_APPL_ID (
803: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
804: P_Validation_mode IN VARCHAR2,
805: P_PROGRAM_APPLICATION_ID IN NUMBER,
806: -- 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.
807: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
808: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
809: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
810: )

Line 824: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

820:
821: -- Initialize API return status to SUCCESS
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823:
824: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
825: THEN
826: -- Hint: Validate data
827: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
828: -- verify if data is valid

Line 831: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

827: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
828: -- verify if data is valid
829: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
830: NULL;
831: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
832: THEN
833: -- Hint: Validate data
834: -- IF p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
835: -- verify if data is valid

Line 853: -- 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: PROCEDURE Validate_PROGRAM_ID (
850: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
851: P_Validation_mode IN VARCHAR2,
852: P_PROGRAM_ID IN NUMBER,
853: -- 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.
854: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
855: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
856: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
857: )

Line 871: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

867:
868: -- Initialize API return status to SUCCESS
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870:
871: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
872: THEN
873: -- Hint: Validate data
874: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
875: -- verify if data is valid

Line 878: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

874: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
875: -- verify if data is valid
876: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
877: NULL;
878: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
879: THEN
880: -- Hint: Validate data
881: -- IF p_PROGRAM_ID <> G_MISS_CHAR
882: -- verify if data is valid

Line 900: -- 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: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
897: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
898: P_Validation_mode IN VARCHAR2,
899: P_PROGRAM_UPDATE_DATE IN DATE,
900: -- 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.
901: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
902: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
903: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
904: )

Line 918: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

914:
915: -- Initialize API return status to SUCCESS
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:
918: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
919: THEN
920: -- Hint: Validate data
921: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
922: -- verify if data is valid

Line 925: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

921: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
922: -- verify if data is valid
923: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
924: NULL;
925: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
926: THEN
927: -- Hint: Validate data
928: -- IF p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
929: -- verify if data is valid

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

943: PROCEDURE Validate_QUOTE_LINE_ID (
944: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
945: P_Validation_mode IN VARCHAR2,
946: P_QUOTE_LINE_ID IN NUMBER,
947: -- 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.
948: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
949: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
950: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
951: )

Line 969: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');

965:
966: -- validate NOT NULL column
967: IF(p_QUOTE_LINE_ID is NULL)
968: THEN
969: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: END IF;
972:
973: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 973: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

969: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_attribs API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: END IF;
972:
973: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
974: THEN
975: -- Hint: Validate data
976: -- IF p_QUOTE_LINE_ID is not NULL and p_QUOTE_LINE_ID <> G_MISS_CHAR
977: -- verify if data is valid

Line 989: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

985: if l_count <> 1 then
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: end if;
988:
989: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
990: THEN
991: -- Hint: Validate data
992: -- IF p_QUOTE_LINE_ID <> G_MISS_CHAR
993: -- verify if data is valid

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

1018: PROCEDURE Validate_NAME (
1019: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1020: P_Validation_mode IN VARCHAR2,
1021: P_NAME IN VARCHAR2,
1022: -- 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.
1023: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1024: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1025: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1026: )

Line 1040: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1036:
1037: -- Initialize API return status to SUCCESS
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1041: THEN
1042: -- Hint: Validate data
1043: -- IF p_NAME is not NULL and p_NAME <> G_MISS_CHAR
1044: -- verify if data is valid

Line 1047: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1043: -- IF p_NAME is not NULL and p_NAME <> G_MISS_CHAR
1044: -- verify if data is valid
1045: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1046: NULL;
1047: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1048: THEN
1049: -- Hint: Validate data
1050: -- IF p_NAME <> G_MISS_CHAR
1051: -- verify if data is valid

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

1064: PROCEDURE Validate_ATTRIBUTE_TYPE_CODE(
1065: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1066: P_Validation_mode IN VARCHAR2,
1067: P_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
1068: -- 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.
1069: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1070: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1071: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1072:

Line 1087: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1083:
1084: -- Initialize API return status to SUCCESS
1085: x_return_status := FND_API.G_RET_STS_SUCCESS;
1086:
1087: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1088: THEN
1089: -- Hint: Validate data
1090: -- IF p_NAME is not NULL and p_NAME <> G_MISS_CHAR
1091: -- verify if data is valid

Line 1104: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: END IF;
1102:
1103:
1104: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1105: THEN
1106: -- Hint: Validate data
1107: -- IF p_NAME <> G_MISS_CHAR
1108: -- verify if data is valid

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

1132: PROCEDURE Validate_STATUS(
1133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1134: P_Validation_mode IN VARCHAR2,
1135: P_STATUS IN VARCHAR2,
1136: -- 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.
1137: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1138: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1139: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1140: IS

Line 1154: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1150:
1151: -- Initialize API return status to SUCCESS
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:
1154: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1155: THEN
1156: -- Hint: Validate data
1157: -- IF p_NAME is not NULL and p_NAME <> G_MISS_CHAR
1158: -- verify if data is valid

Line 1171: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1167: if l_count < 1 then
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: end if;
1170:
1171: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1172: THEN
1173: -- Hint: Validate data
1174: -- IF p_NAME <> G_MISS_CHAR
1175: -- verify if data is valid

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

1199: PROCEDURE Validate_VALUE (
1200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1201: P_Validation_mode IN VARCHAR2,
1202: P_VALUE IN VARCHAR2,
1203: -- 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.
1204: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1205: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1206: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1207: )

Line 1221: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1217:
1218: -- Initialize API return status to SUCCESS
1219: x_return_status := FND_API.G_RET_STS_SUCCESS;
1220:
1221: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1222: THEN
1223: -- Hint: Validate data
1224: -- IF p_VALUE is not NULL and p_VALUE <> G_MISS_CHAR
1225: -- verify if data is valid

Line 1228: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1224: -- IF p_VALUE is not NULL and p_VALUE <> G_MISS_CHAR
1225: -- verify if data is valid
1226: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1227: NULL;
1228: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1229: THEN
1230: -- Hint: Validate data
1231: -- IF p_VALUE <> G_MISS_CHAR
1232: -- verify if data is valid

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

1246: PROCEDURE Validate_START_DATE_ACTIVE (
1247: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1248: P_Validation_mode IN VARCHAR2,
1249: P_START_DATE_ACTIVE IN DATE,
1250: -- 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.
1251: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1252: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1253: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1254: )

Line 1268: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1264:
1265: -- Initialize API return status to SUCCESS
1266: x_return_status := FND_API.G_RET_STS_SUCCESS;
1267:
1268: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1269: THEN
1270: -- Hint: Validate data
1271: -- IF p_START_DATE_ACTIVE is not NULL and p_START_DATE_ACTIVE <> G_MISS_CHAR
1272: -- verify if data is valid

Line 1275: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1271: -- IF p_START_DATE_ACTIVE is not NULL and p_START_DATE_ACTIVE <> G_MISS_CHAR
1272: -- verify if data is valid
1273: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1274: NULL;
1275: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1276: THEN
1277: -- Hint: Validate data
1278: -- IF p_START_DATE_ACTIVE <> G_MISS_CHAR
1279: -- verify if data is valid

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

1293: PROCEDURE Validate_END_DATE_ACTIVE (
1294: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1295: P_Validation_mode IN VARCHAR2,
1296: P_END_DATE_ACTIVE IN DATE,
1297: -- 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.
1298: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1299: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1300: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1301: )

Line 1315: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1311:
1312: -- Initialize API return status to SUCCESS
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1316: THEN
1317: -- Hint: Validate data
1318: -- IF p_END_DATE_ACTIVE is not NULL and p_END_DATE_ACTIVE <> G_MISS_CHAR
1319: -- verify if data is valid

Line 1322: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1318: -- IF p_END_DATE_ACTIVE is not NULL and p_END_DATE_ACTIVE <> G_MISS_CHAR
1319: -- verify if data is valid
1320: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1321: NULL;
1322: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1323: THEN
1324: -- Hint: Validate data
1325: -- IF p_END_DATE_ACTIVE <> G_MISS_CHAR
1326: -- verify if data is valid

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

1337: END Validate_END_DATE_ACTIVE;
1338:
1339:
1340: -- Hint: inter-field level validation can be added here.
1341: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1342: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1343: -- stored in database table.
1344: PROCEDURE Validate_LINE_ATTRIBS_rec(
1345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1367: -- THEN
1368: -- x_return_status := FND_API.G_RET_STS_ERROR;
1369:
1370: -- Debug Message
1371: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1372:
1373: -- Standard call to get message count and if count is 1, get message info.
1374: FND_MSG_PUB.Count_And_Get
1375: ( p_count => x_msg_count,

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

1395:
1396: -- Initialize API return status to SUCCESS
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
1400: -- Hint: We provide validation procedure for every column. Developer should delete
1401: -- unnecessary validation procedures.
1402: Validate_QUOTE_LINE_ID(
1403: p_init_msg_list => FND_API.G_FALSE,