DBA Data[Home] [Help]

APPS.ASO_LINE_RLTSHIP_PVT dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.initialize;

48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55:
56: -- Debug Message

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 89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

85: -- Validate Environment
86: -- ******************************************************************
87: IF FND_GLOBAL.User_Id IS NULL
88: THEN
89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
92: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
93: FND_MSG_PUB.ADD;

Line 93: FND_MSG_PUB.ADD;

89: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
90: THEN
91: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
92: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
93: FND_MSG_PUB.ADD;
94: END IF;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:

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 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 182: FND_MSG_PUB.Count_And_Get

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
183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:

Line 209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
211: ,X_MSG_COUNT => X_MSG_COUNT
212: ,X_MSG_DATA => X_MSG_DATA
213: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
221: ,X_MSG_COUNT => X_MSG_COUNT
222: ,X_MSG_DATA => X_MSG_DATA
223: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 301: FND_MSG_PUB.initialize;

297:
298: -- Initialize message list if p_init_msg_list is set to TRUE.
299: IF FND_API.to_Boolean( p_init_msg_list )
300: THEN
301: FND_MSG_PUB.initialize;
302: END IF;
303:
304:
305: -- Debug Message

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 356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

352: l_ref_LINE_RLTSHIP_rec.RECIPROCAL_FLAG;
353:
354:
355: If ( C_Get_line_rltship%NOTFOUND) Then
356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
357: THEN
358: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
359: FND_MESSAGE.Set_Token ('INFO', 'line_rltship', FALSE);
360: FND_MSG_PUB.Add;

Line 360: FND_MSG_PUB.Add;

356: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
357: THEN
358: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
359: FND_MESSAGE.Set_Token ('INFO', 'line_rltship', FALSE);
360: FND_MSG_PUB.Add;
361: END IF;
362: raise FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message

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 372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

368:
369:
370: If (l_tar_LINE_RLTSHIP_rec.last_update_date is NULL or
371: l_tar_LINE_RLTSHIP_rec.last_update_date = FND_API.G_MISS_Date ) Then
372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
373: THEN
374: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
375: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
376: FND_MSG_PUB.ADD;

Line 376: FND_MSG_PUB.ADD;

372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
373: THEN
374: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
375: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
376: FND_MSG_PUB.ADD;
377: END IF;
378: raise FND_API.G_EXC_ERROR;
379: End if;
380: -- Check Whether record has been changed by someone else

Line 382: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

378: raise FND_API.G_EXC_ERROR;
379: End if;
380: -- Check Whether record has been changed by someone else
381: If (l_tar_LINE_RLTSHIP_rec.last_update_date <> l_ref_LINE_RLTSHIP_rec.last_update_date) Then
382: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
383: THEN
384: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
385: FND_MESSAGE.Set_Token('INFO', 'line_rltship', FALSE);
386: FND_MSG_PUB.ADD;

Line 386: FND_MSG_PUB.ADD;

382: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
383: THEN
384: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
385: FND_MESSAGE.Set_Token('INFO', 'line_rltship', FALSE);
386: FND_MSG_PUB.ADD;
387: END IF;
388: raise FND_API.G_EXC_ERROR;
389: End if;
390:

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 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 450: FND_MSG_PUB.Count_And_Get

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
451: ( p_count => x_msg_count,
452: p_data => x_msg_data
453: );
454:

Line 478: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
480: ,X_MSG_COUNT => X_MSG_COUNT
481: ,X_MSG_DATA => X_MSG_DATA
482: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
490: ,X_MSG_COUNT => X_MSG_COUNT
491: ,X_MSG_DATA => X_MSG_DATA
492: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 580: FND_MSG_PUB.initialize;

576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:
583:
584: -- Debug Message

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 744: FND_MSG_PUB.Count_And_Get

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
745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:

Line 773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
775: ,X_MSG_COUNT => X_MSG_COUNT
776: ,X_MSG_DATA => X_MSG_DATA
777: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 783: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
785: ,X_MSG_COUNT => X_MSG_COUNT
786: ,X_MSG_DATA => X_MSG_DATA
787: ,X_RETURN_STATUS => X_RETURN_STATUS);

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 1044: FND_MSG_PUB.initialize;

1040:
1041: -- Initialize message list if p_init_msg_list is set to TRUE.
1042: IF FND_API.to_Boolean( p_init_msg_list )
1043: THEN
1044: FND_MSG_PUB.initialize;
1045: END IF;
1046:
1047:
1048: -- Initialize API return status to SUCCESS

Line 1085: FND_MSG_PUB.Count_And_Get

1081: END IF;
1082: END IF;
1083:
1084: -- Standard call to get message count and if count is 1, get message info.
1085: FND_MSG_PUB.Count_And_Get
1086: ( p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );
1089:

Line 1108: FND_MSG_PUB.initialize;

1104:
1105: -- Initialize message list if p_init_msg_list is set to TRUE.
1106: IF FND_API.to_Boolean( p_init_msg_list )
1107: THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110:
1111:
1112: -- Initialize API return status to SUCCESS

Line 1132: FND_MSG_PUB.Count_And_Get

1128: NULL;
1129: END IF;
1130:
1131: -- Standard call to get message count and if count is 1, get message info.
1132: FND_MSG_PUB.Count_And_Get
1133: ( p_count => x_msg_count,
1134: p_data => x_msg_data
1135: );
1136:

Line 1155: FND_MSG_PUB.initialize;

1151:
1152: -- Initialize message list if p_init_msg_list is set to TRUE.
1153: IF FND_API.to_Boolean( p_init_msg_list )
1154: THEN
1155: FND_MSG_PUB.initialize;
1156: END IF;
1157:
1158:
1159: -- Initialize API return status to SUCCESS

Line 1179: FND_MSG_PUB.Count_And_Get

1175: NULL;
1176: END IF;
1177:
1178: -- Standard call to get message count and if count is 1, get message info.
1179: FND_MSG_PUB.Count_And_Get
1180: ( p_count => x_msg_count,
1181: p_data => x_msg_data
1182: );
1183:

Line 1202: FND_MSG_PUB.initialize;

1198:
1199: -- Initialize message list if p_init_msg_list is set to TRUE.
1200: IF FND_API.to_Boolean( p_init_msg_list )
1201: THEN
1202: FND_MSG_PUB.initialize;
1203: END IF;
1204:
1205:
1206: -- Initialize API return status to SUCCESS

Line 1226: FND_MSG_PUB.Count_And_Get

1222: NULL;
1223: END IF;
1224:
1225: -- Standard call to get message count and if count is 1, get message info.
1226: FND_MSG_PUB.Count_And_Get
1227: ( p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );
1230:

Line 1249: FND_MSG_PUB.initialize;

1245:
1246: -- Initialize message list if p_init_msg_list is set to TRUE.
1247: IF FND_API.to_Boolean( p_init_msg_list )
1248: THEN
1249: FND_MSG_PUB.initialize;
1250: END IF;
1251:
1252:
1253: -- Initialize API return status to SUCCESS

Line 1273: FND_MSG_PUB.Count_And_Get

1269: NULL;
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get
1274: ( p_count => x_msg_count,
1275: p_data => x_msg_data
1276: );
1277:

Line 1297: FND_MSG_PUB.initialize;

1293:
1294: -- Initialize message list if p_init_msg_list is set to TRUE.
1295: IF FND_API.to_Boolean( p_init_msg_list )
1296: THEN
1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300:
1301: -- Initialize API return status to SUCCESS

Line 1322: FND_MSG_PUB.Count_And_Get

1318: end if;
1319: END IF;
1320:
1321: -- Standard call to get message count and if count is 1, get message info.
1322: FND_MSG_PUB.Count_And_Get
1323: ( p_count => x_msg_count,
1324: p_data => x_msg_data
1325: );
1326:

Line 1346: FND_MSG_PUB.initialize;

1342:
1343: -- Initialize message list if p_init_msg_list is set to TRUE.
1344: IF FND_API.to_Boolean( p_init_msg_list )
1345: THEN
1346: FND_MSG_PUB.initialize;
1347: END IF;
1348:
1349:
1350: -- Initialize API return status to SUCCESS

Line 1373: FND_MSG_PUB.Count_And_Get

1369: END IF;
1370:
1371:
1372: -- Standard call to get message count and if count is 1, get message info.
1373: FND_MSG_PUB.Count_And_Get
1374: ( p_count => x_msg_count,
1375: p_data => x_msg_data
1376: );
1377:

Line 1397: FND_MSG_PUB.initialize;

1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400:
1401: -- Initialize API return status to SUCCESS

Line 1432: FND_MSG_PUB.Count_And_Get

1428: end if;
1429: END IF;
1430:
1431: -- Standard call to get message count and if count is 1, get message info.
1432: FND_MSG_PUB.Count_And_Get
1433: ( p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );
1436:

Line 1456: FND_MSG_PUB.initialize;

1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list )
1455: THEN
1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:
1459:
1460: -- Initialize API return status to SUCCESS

Line 1486: FND_MSG_PUB.Count_And_Get

1482: END IF;
1483: END IF;
1484:
1485: -- Standard call to get message count and if count is 1, get message info.
1486: FND_MSG_PUB.Count_And_Get
1487: ( p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );
1490:

Line 1510: FND_MSG_PUB.initialize;

1506:
1507: -- Initialize message list if p_init_msg_list is set to TRUE.
1508: IF FND_API.to_Boolean( p_init_msg_list )
1509: THEN
1510: FND_MSG_PUB.initialize;
1511: END IF;
1512:
1513:
1514: -- Initialize API return status to SUCCESS

Line 1534: FND_MSG_PUB.Count_And_Get

1530: NULL;
1531: END IF;
1532:
1533: -- Standard call to get message count and if count is 1, get message info.
1534: FND_MSG_PUB.Count_And_Get
1535: ( p_count => x_msg_count,
1536: p_data => x_msg_data
1537: );
1538:

Line 1560: FND_MSG_PUB.initialize;

1556:
1557: -- Initialize message list if p_init_msg_list is set to TRUE.
1558: IF FND_API.to_Boolean( p_init_msg_list )
1559: THEN
1560: FND_MSG_PUB.initialize;
1561: END IF;
1562:
1563:
1564: -- Initialize API return status to SUCCESS

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 1576: FND_MSG_PUB.Count_And_Get

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,
1578: p_data => x_msg_data
1579: );
1580:

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 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;