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

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

53: END IF;
54:
55:
56: -- Debug Message
57: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
58:
59:
60: -- Initialize API return status to SUCCESS
61: 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_rltship');

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_rltship');
117:
118: -- Invoke validation procedures
119: Validate_line_rltship(
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_rltship(
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_RLTSHIP_Rec => P_LINE_RLTSHIP_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);

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

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

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

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

Line 206: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 210: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

206: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
207: P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
210: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
211: ,X_MSG_COUNT => X_MSG_COUNT
212: ,X_MSG_DATA => X_MSG_DATA
213: ,X_RETURN_STATUS => X_RETURN_STATUS);
214:

Line 216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

212: ,X_MSG_DATA => X_MSG_DATA
213: ,X_RETURN_STATUS => X_RETURN_STATUS);
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
217: P_API_NAME => L_API_NAME
218: ,P_PKG_NAME => G_PKG_NAME
219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
217: P_API_NAME => L_API_NAME
218: ,P_PKG_NAME => G_PKG_NAME
219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
221: ,X_MSG_COUNT => X_MSG_COUNT
222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);
224:

Line 226: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);
224:
225: WHEN OTHERS THEN
226: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
227: P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
230: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 229: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 230: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

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

302: END IF;
303:
304:
305: -- Debug Message
306: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
307:
308:
309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

361: END IF;
362: raise FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message
365: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
366: Close C_Get_line_rltship;
367:
368:
369:

Line 394: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_rltship');

390:
391: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
392: THEN
393: -- Debug message
394: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_line_rltship');
395:
396: -- Invoke validation procedures
397: Validate_line_rltship(
398: p_init_msg_list => FND_API.G_FALSE,

Line 400: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,

396: -- Invoke validation procedures
397: Validate_line_rltship(
398: p_init_msg_list => FND_API.G_FALSE,
399: p_validation_level => p_validation_level,
400: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,
401: P_LINE_RLTSHIP_Rec => P_LINE_RLTSHIP_Rec,
402: x_return_status => x_return_status,
403: x_msg_count => x_msg_count,
404: x_msg_data => x_msg_data);

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

410:
411: -- Hint: Add corresponding Master-Detail business logic here if necessary.
412:
413: -- Debug Message
414: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
415:
416: -- Invoke table handler(ASO_LINE_RELATIONSHIPS_PKG.Update_Row)
417: ASO_LINE_RELATIONSHIPS_PKG.Update_Row(
418: p_LINE_RELATIONSHIP_ID => p_LINE_RLTSHIP_rec.LINE_RELATIONSHIP_ID,

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

442: END IF;
443:
444:
445: -- Debug Message
446: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
447:
448:
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get

Line 475: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

471: END IF;
472: */
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
476: P_API_NAME => L_API_NAME
477: ,P_PKG_NAME => G_PKG_NAME
478: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
479: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 479: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

475: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
476: P_API_NAME => L_API_NAME
477: ,P_PKG_NAME => G_PKG_NAME
478: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
479: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
480: ,X_MSG_COUNT => X_MSG_COUNT
481: ,X_MSG_DATA => X_MSG_DATA
482: ,X_RETURN_STATUS => X_RETURN_STATUS);
483:

Line 485: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

481: ,X_MSG_DATA => X_MSG_DATA
482: ,X_RETURN_STATUS => X_RETURN_STATUS);
483:
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
486: P_API_NAME => L_API_NAME
487: ,P_PKG_NAME => G_PKG_NAME
488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
489: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 489: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

485: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
486: P_API_NAME => L_API_NAME
487: ,P_PKG_NAME => G_PKG_NAME
488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
489: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
490: ,X_MSG_COUNT => X_MSG_COUNT
491: ,X_MSG_DATA => X_MSG_DATA
492: ,X_RETURN_STATUS => X_RETURN_STATUS);
493:

Line 495: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

491: ,X_MSG_DATA => X_MSG_DATA
492: ,X_RETURN_STATUS => X_RETURN_STATUS);
493:
494: WHEN OTHERS THEN
495: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
496: P_API_NAME => L_API_NAME
497: ,P_PKG_NAME => G_PKG_NAME
498: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
499: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 498: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

494: WHEN OTHERS THEN
495: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
496: P_API_NAME => L_API_NAME
497: ,P_PKG_NAME => G_PKG_NAME
498: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
499: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
500: ,X_MSG_COUNT => X_MSG_COUNT
501: ,X_MSG_DATA => X_MSG_DATA
502: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 499: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

495: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
496: P_API_NAME => L_API_NAME
497: ,P_PKG_NAME => G_PKG_NAME
498: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
499: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
500: ,X_MSG_COUNT => X_MSG_COUNT
501: ,X_MSG_DATA => X_MSG_DATA
502: ,X_RETURN_STATUS => X_RETURN_STATUS);
503: End Update_line_rltship;

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

581: END IF;
582:
583:
584: -- Debug Message
585: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
586:
587:
588: -- Initialize API return status to SUCCESS
589: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624: -- Debug Message
625: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
626: */
627:
628:
629: IF (p_LINE_RLTSHIP_rec.quote_line_id <> FND_API.G_MISS_NUM and

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

736: END IF;
737:
738:
739: -- Debug Message
740: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
741:
742:
743: -- Standard call to get message count and if count is 1, get message info.
744: FND_MSG_PUB.Count_And_Get

Line 770: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

766: */
767: EXCEPTION
768:
769: WHEN FND_API.G_EXC_ERROR THEN
770: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
771: P_API_NAME => L_API_NAME
772: ,P_PKG_NAME => G_PKG_NAME
773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
774: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 774: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

770: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
771: P_API_NAME => L_API_NAME
772: ,P_PKG_NAME => G_PKG_NAME
773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
774: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
775: ,X_MSG_COUNT => X_MSG_COUNT
776: ,X_MSG_DATA => X_MSG_DATA
777: ,X_RETURN_STATUS => X_RETURN_STATUS);
778:

Line 780: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

776: ,X_MSG_DATA => X_MSG_DATA
777: ,X_RETURN_STATUS => X_RETURN_STATUS);
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
781: P_API_NAME => L_API_NAME
782: ,P_PKG_NAME => G_PKG_NAME
783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
784: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 784: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

780: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
781: P_API_NAME => L_API_NAME
782: ,P_PKG_NAME => G_PKG_NAME
783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
784: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
785: ,X_MSG_COUNT => X_MSG_COUNT
786: ,X_MSG_DATA => X_MSG_DATA
787: ,X_RETURN_STATUS => X_RETURN_STATUS);
788:

Line 790: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

786: ,X_MSG_DATA => X_MSG_DATA
787: ,X_RETURN_STATUS => X_RETURN_STATUS);
788:
789: WHEN OTHERS THEN
790: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
791: P_API_NAME => L_API_NAME
792: ,P_PKG_NAME => G_PKG_NAME
793: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
794: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 793: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

789: WHEN OTHERS THEN
790: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
791: P_API_NAME => L_API_NAME
792: ,P_PKG_NAME => G_PKG_NAME
793: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
794: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
795: ,X_MSG_COUNT => X_MSG_COUNT
796: ,X_MSG_DATA => X_MSG_DATA
797: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 794: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

790: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
791: P_API_NAME => L_API_NAME
792: ,P_PKG_NAME => G_PKG_NAME
793: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
794: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
795: ,X_MSG_COUNT => X_MSG_COUNT
796: ,X_MSG_DATA => X_MSG_DATA
797: ,X_RETURN_STATUS => X_RETURN_STATUS);
798:

Line 810: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');

806: )
807: IS
808: BEGIN
809: -- Debug Message
810: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
811: /*
812: -- define all columns for ASO_QUOTE_LINES_V view
813: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 1, P_LINE_RLTSHIP_Rec.QUOTE_LINE_ID);
814: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 2, P_LINE_RLTSHIP_Rec.QUOTE_HEADER_ID);

Line 871: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');

867: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 55, P_LINE_RLTSHIP_Rec.ATTRIBUTE14, 150);
868: dbms_sql.define_column(p_cur_get_LINE_RLTSHIP, 56, P_LINE_RLTSHIP_Rec.ATTRIBUTE15, 150);
869:
870: -- Debug Message
871: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
872: */
873: null;
874: END Define_Columns;
875:

Line 897: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');

893: BEGIN
894: -- Bind variables
895: -- Only those that are not NULL
896: -- Debug Message
897: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
898:
899: -- The following example applies to all columns,
900: -- developers can copy and paste them.
901: IF( (P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID IS NOT NULL) AND (P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID <> FND_API.G_MISS_NUM) )

Line 907: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');

903: DBMS_SQL.BIND_VARIABLE(p_cur_get_LINE_RLTSHIP, ':p_LINE_RELATIONSHIP_ID', P_LINE_RLTSHIP_Rec.LINE_RELATIONSHIP_ID);
904: END IF;
905:
906: -- Debug Message
907: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
908: END Bind;
909:
910: PROCEDURE Gen_Select(
911: x_select_cl OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 931: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');

927: str_csr2 NUMBER;
928: l_operator VARCHAR2(10);
929: BEGIN
930: -- Debug Message
931: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
932:
933: -- There are three example for each kind of datatype:
934: -- NUMBER, DATE, VARCHAR2.
935: -- Developer can copy and paste the following codes for your own record.

Line 1023: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');

1019:
1020: -- Add more IF statements for each column below
1021:
1022: -- Debug Message
1023: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
1024:
1025: END Gen_LINE_RLTSHIP_Where;
1026:
1027: -- Item-level validation procedures

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

1028: PROCEDURE Validate_LINE_RELATIONSHIP_ID (
1029: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1030: P_Validation_mode IN VARCHAR2,
1031: P_LINE_RELATIONSHIP_ID IN NUMBER,
1032: -- 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.
1033: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1034: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1035: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1036: )

Line 1054: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(LINE_RELATIONSHIP_ID)');

1050:
1051: -- validate NOT NULL column
1052: IF(p_LINE_RELATIONSHIP_ID is NULL)
1053: THEN
1054: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(LINE_RELATIONSHIP_ID)');
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:
1058: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1058: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1054: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(LINE_RELATIONSHIP_ID)');
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:
1058: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1059: THEN
1060: -- Hint: Validate data
1061: -- IF p_LINE_RELATIONSHIP_ID is not NULL and p_LINE_RELATIONSHIP_ID <> G_MISS_CHAR
1062: -- verify if data is valid

Line 1065: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1061: -- IF p_LINE_RELATIONSHIP_ID is not NULL and p_LINE_RELATIONSHIP_ID <> G_MISS_CHAR
1062: -- verify if data is valid
1063: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1064: NULL;
1065: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1066: THEN
1067: -- Hint: Validate data
1068: -- IF p_LINE_RELATIONSHIP_ID <> G_MISS_CHAR
1069: -- verify if data is valid

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

1093: PROCEDURE Validate_REQUEST_ID (
1094: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1095: P_Validation_mode IN VARCHAR2,
1096: P_REQUEST_ID IN NUMBER,
1097: -- 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.
1098: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1099: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1100: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1101: )

Line 1115: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

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

Line 1122: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

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

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

1140: PROCEDURE Validate_PROG_APPL_ID (
1141: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1142: P_Validation_mode IN VARCHAR2,
1143: P_PROGRAM_APPLICATION_ID IN NUMBER,
1144: -- 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.
1145: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1146: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1147: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1148: )

Line 1162: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1158:
1159: -- Initialize API return status to SUCCESS
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161:
1162: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1163: THEN
1164: -- Hint: Validate data
1165: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
1166: -- verify if data is valid

Line 1169: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1165: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
1166: -- verify if data is valid
1167: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1168: NULL;
1169: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1170: THEN
1171: -- Hint: Validate data
1172: -- IF p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
1173: -- verify if data is valid

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

1187: PROCEDURE Validate_PROGRAM_ID (
1188: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1189: P_Validation_mode IN VARCHAR2,
1190: P_PROGRAM_ID IN NUMBER,
1191: -- 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.
1192: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1193: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1194: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1195: )

Line 1209: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1205:
1206: -- Initialize API return status to SUCCESS
1207: x_return_status := FND_API.G_RET_STS_SUCCESS;
1208:
1209: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1210: THEN
1211: -- Hint: Validate data
1212: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
1213: -- verify if data is valid

Line 1216: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1212: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
1213: -- verify if data is valid
1214: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1215: NULL;
1216: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1217: THEN
1218: -- Hint: Validate data
1219: -- IF p_PROGRAM_ID <> G_MISS_CHAR
1220: -- verify if data is valid

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

1234: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
1235: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1236: P_Validation_mode IN VARCHAR2,
1237: P_PROGRAM_UPDATE_DATE IN DATE,
1238: -- 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.
1239: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1240: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1241: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1242: )

Line 1256: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1252:
1253: -- Initialize API return status to SUCCESS
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255:
1256: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1257: THEN
1258: -- Hint: Validate data
1259: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
1260: -- verify if data is valid

Line 1263: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1259: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
1260: -- verify if data is valid
1261: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1262: NULL;
1263: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1264: THEN
1265: -- Hint: Validate data
1266: -- IF p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
1267: -- verify if data is valid

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

1281: PROCEDURE Validate_QUOTE_LINE_ID (
1282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1283: P_Validation_mode IN VARCHAR2,
1284: P_QUOTE_LINE_ID IN NUMBER,
1285: -- 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.
1286: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1287: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1288: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1289: )

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

1303:
1304: -- validate NOT NULL column
1305: IF(p_QUOTE_LINE_ID is NULL)
1306: THEN
1307: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: END IF;
1310:
1311: IF p_QUOTE_LINE_ID is not NULL AND p_QUOTE_LINE_ID <> FND_API.G_MISS_NUM THEN

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

1330: PROCEDURE Validate_RELATED_QUOTE_LINE_ID (
1331: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1332: P_Validation_mode IN VARCHAR2,
1333: P_RELATED_QUOTE_LINE_ID IN NUMBER,
1334: -- 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.
1335: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1336: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1337: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1338: )

Line 1356: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(RELATED_QUOTE_LINE_ID)');

1352:
1353: -- validate NOT NULL column
1354: IF(p_RELATED_QUOTE_LINE_ID is NULL)
1355: THEN
1356: --ASO_UTILITY_PVT.Print('ERROR', 'Private line_rltship API: -Violate NOT NULL constraint(RELATED_QUOTE_LINE_ID)');
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: END IF;
1359:
1360:

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

1381: PROCEDURE Validate_RELATIONAL_TYPE_CODE (
1382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1383: P_Validation_mode IN VARCHAR2,
1384: P_RELATIONAL_TYPE_CODE IN VARCHAR2,
1385: -- 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.
1386: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1387: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1388: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1389: )

Line 1404: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1400:
1401: -- Initialize API return status to SUCCESS
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1405: THEN
1406: -- Hint: Validate data
1407: -- IF p_RELATIONAL_TYPE_CODE is not NULL and p_RELATIONAL_TYPE_CODE <> G_MISS_CHAR
1408: -- verify if data is valid

Line 1411: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1407: -- IF p_RELATIONAL_TYPE_CODE is not NULL and p_RELATIONAL_TYPE_CODE <> G_MISS_CHAR
1408: -- verify if data is valid
1409: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1410: NULL;
1411: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1412: THEN
1413: -- Hint: Validate data
1414: -- IF p_RELATIONAL_TYPE_CODE <> G_MISS_CHAR
1415: -- verify if data is valid

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

1440: PROCEDURE Validate_RECIPROCAL_FLAG (
1441: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1442: P_Validation_mode IN VARCHAR2,
1443: P_RECIPROCAL_FLAG IN VARCHAR2,
1444: -- 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.
1445: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1446: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1447: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1448: )

Line 1463: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1459:
1460: -- Initialize API return status to SUCCESS
1461: x_return_status := FND_API.G_RET_STS_SUCCESS;
1462:
1463: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1464: THEN
1465: -- Hint: Validate data
1466: -- IF p_RECIPROCAL_FLAG is not NULL and p_RECIPROCAL_FLAG <> G_MISS_CHAR
1467: -- verify if data is valid

Line 1470: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1466: -- IF p_RECIPROCAL_FLAG is not NULL and p_RECIPROCAL_FLAG <> G_MISS_CHAR
1467: -- verify if data is valid
1468: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1469: NULL;
1470: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1471: THEN
1472: -- Hint: Validate data
1473: -- IF p_RECIPROCAL_FLAG <> G_MISS_CHAR
1474: -- verify if data is valid

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

1494: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
1495: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1496: P_Validation_mode IN VARCHAR2,
1497: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
1498: -- 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.
1499: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1500: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1501: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1502: )

Line 1517: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

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

Line 1524: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

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

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

1539: END Validate_RLTSHIP_TYPE_CODE;
1540:
1541:
1542: -- Hint: inter-field level validation can be added here.
1543: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1544: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1545: -- stored in database table.
1546: PROCEDURE Validate_LINE_RLTSHIP_rec(
1547: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1569: -- THEN
1570: -- x_return_status := FND_API.G_RET_STS_ERROR;
1571:
1572: -- Debug Message
1573: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1574:
1575: -- Standard call to get message count and if count is 1, get message info.
1576: FND_MSG_PUB.Count_And_Get
1577: ( p_count => x_msg_count,

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

1593: l_api_name CONSTANT VARCHAR2(30) := 'Validate_line_rltship';
1594: BEGIN
1595:
1596: -- Debug Message
1597: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1598:
1599:
1600: -- Initialize API return status to SUCCESS
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1599:
1600: -- Initialize API return status to SUCCESS
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:
1603: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
1604: -- Hint: We provide validation procedure for every column. Developer should delete
1605: -- unnecessary validation procedures.
1606: Validate_LINE_RELATIONSHIP_ID(
1607: p_init_msg_list => FND_API.G_FALSE,

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

1712: END IF;
1713:
1714: END IF;
1715:
1716: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD) THEN
1717: -- Hint: Inter-field level validation can be added here
1718: -- invoke record level validation procedures
1719: Validate_LINE_RLTSHIP_Rec(
1720: p_init_msg_list => FND_API.G_FALSE,

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

1728: raise FND_API.G_EXC_ERROR;
1729: END IF;
1730: END IF;
1731:
1732: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD) THEN
1733: -- invoke inter-record level validation procedures
1734: NULL;
1735: END IF;
1736:

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

1733: -- invoke inter-record level validation procedures
1734: NULL;
1735: END IF;
1736:
1737: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY) THEN
1738: -- invoke inter-entity level validation procedures
1739: NULL;
1740: END IF;
1741:

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

1740: END IF;
1741:
1742:
1743: -- Debug Message
1744: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1745:
1746: END Validate_line_rltship;
1747:
1748: End ASO_LINE_RLTSHIP_PVT;