[Home] [Help]
49:
50: -- Initialize message list if p_init_msg_list is set to TRUE.
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56:
57: -- Debug Message
54: END IF;
55:
56:
57: -- Debug Message
58: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', '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;
87: -- Validate Environment
88: -- ******************************************************************
89: IF FND_GLOBAL.User_Id IS NULL
90: THEN
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
93: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
94: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
95: FND_MSG_PUB.ADD;
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
93: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
94: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
95: FND_MSG_PUB.ADD;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99:
118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderheaders');
123:
124: -- Invoke validation procedures
125: Validate_orderheaders(
126: p_init_msg_list => FND_API.G_FALSE,
139:
140: -- Hint: Add corresponding Master-Detail business logic here if necessary.
141:
142: -- Debug Message
143: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
144:
145:
146: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Insert_Row)
147: CSP_MOVEORDER_HEADERS_PKG.Insert_Row(
191: END IF;
192:
193:
194: -- Debug Message
195: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
196:
197:
198: -- Standard call to get message count and if count is 1, get message info.
199: FND_MSG_PUB.Count_And_Get
195: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
196:
197:
198: -- Standard call to get message count and if count is 1, get message info.
199: FND_MSG_PUB.Count_And_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203:
222: WHEN FND_API.G_EXC_ERROR THEN
223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
224: P_API_NAME => L_API_NAME
225: ,P_PKG_NAME => G_PKG_NAME
226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
228: ,X_MSG_COUNT => X_MSG_COUNT
229: ,X_MSG_DATA => X_MSG_DATA
230: ,X_RETURN_STATUS => X_RETURN_STATUS);
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
237: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
238: ,X_MSG_COUNT => X_MSG_COUNT
239: ,X_MSG_DATA => X_MSG_DATA
240: ,X_RETURN_STATUS => X_RETURN_STATUS);
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:
338:
339: -- Debug Message
336: END IF;
337:
338:
339: -- Debug Message
340: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
341:
342:
343: -- Initialize API return status to SUCCESS
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: */
383: -- Debug Message
384: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
385:
386: /*
387: Open C_Get_orderheaders( l_tar_MOH_rec.HEADER_ID);
388:
424: l_ref_MOH_rec.PROVINCE,
425: l_ref_MOH_rec.COUNTRY;
426:
427: If ( C_Get_orderheaders%NOTFOUND) Then
428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
429: THEN
430: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
431: FND_MESSAGE.Set_Token ('INFO', 'orderheaders', FALSE);
432: FND_MSG_PUB.Add;
428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
429: THEN
430: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
431: FND_MESSAGE.Set_Token ('INFO', 'orderheaders', FALSE);
432: FND_MSG_PUB.Add;
433: END IF;
434: raise FND_API.G_EXC_ERROR;
435: END IF;
436: -- Debug Message
433: END IF;
434: raise FND_API.G_EXC_ERROR;
435: END IF;
436: -- Debug Message
437: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
438: Close C_Get_orderheaders;
439: */
440:
441: /* uncommented out and will
440:
441: /* uncommented out and will
442: If (l_tar_MOH_rec.last_update_date is NULL or
443: l_tar_MOH_rec.last_update_date = FND_API.G_MISS_Date ) Then
444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
445: THEN
446: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
447: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
448: FND_MSG_PUB.ADD;
444: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
445: THEN
446: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
447: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
448: FND_MSG_PUB.ADD;
449: END IF;
450: raise FND_API.G_EXC_ERROR;
451: End if;
452: -- Check Whether record has been changed by someone else
450: raise FND_API.G_EXC_ERROR;
451: End if;
452: -- Check Whether record has been changed by someone else
453: If (l_tar_MOH_rec.last_update_date <> l_ref_MOH_rec.last_update_date) Then
454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
455: THEN
456: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
457: FND_MESSAGE.Set_Token('INFO', 'orderheaders', FALSE);
458: FND_MSG_PUB.ADD;
454: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
455: THEN
456: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
457: FND_MESSAGE.Set_Token('INFO', 'orderheaders', FALSE);
458: FND_MSG_PUB.ADD;
459: END IF;
460: raise FND_API.G_EXC_ERROR;
461: End if;
462: */
462: */
463: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
464: THEN
465: -- Debug message
466: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderheaders');
467:
468: -- Invoke validation procedures
469: Validate_orderheaders(
470: p_init_msg_list => FND_API.G_FALSE,
482:
483: -- Hint: Add corresponding Master-Detail business logic here if necessary.
484:
485: -- Debug Message
486: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
487:
488: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Update_Row)
489: CSP_MOVEORDER_HEADERS_PKG.Update_Row(
490: p_HEADER_ID => p_MOH_rec.HEADER_ID,
536: END IF;
537:
538:
539: -- Debug Message
540: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
541:
542:
543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get
540: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
541:
542:
543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get
545: ( p_count => x_msg_count,
546: p_data => x_msg_data
547: );
548:
568: WHEN FND_API.G_EXC_ERROR THEN
569: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME
571: ,P_PKG_NAME => G_PKG_NAME
572: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
573: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
574: ,X_MSG_COUNT => X_MSG_COUNT
575: ,X_MSG_DATA => X_MSG_DATA
576: ,X_RETURN_STATUS => X_RETURN_STATUS);
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME
581: ,P_PKG_NAME => G_PKG_NAME
582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
583: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
584: ,X_MSG_COUNT => X_MSG_COUNT
585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
631:
632: -- Initialize message list if p_init_msg_list is set to TRUE.
633: IF FND_API.to_Boolean( p_init_msg_list )
634: THEN
635: FND_MSG_PUB.initialize;
636: END IF;
637:
638:
639: -- Debug Message
636: END IF;
637:
638:
639: -- Debug Message
640: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
641:
642:
643: -- Initialize API return status to SUCCESS
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681: */
682: -- Debug Message
683: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
684:
685: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Delete_Row)
686: CSP_MOVEORDER_HEADERS_PKG.Delete_Row(
687: p_HEADER_ID => p_MOH_rec.HEADER_ID);
696: END IF;
697:
698:
699: -- Debug Message
700: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
701:
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get
700: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
701:
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:
728: WHEN FND_API.G_EXC_ERROR THEN
729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
730: P_API_NAME => L_API_NAME
731: ,P_PKG_NAME => G_PKG_NAME
732: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
734: ,X_MSG_COUNT => X_MSG_COUNT
735: ,X_MSG_DATA => X_MSG_DATA
736: ,X_RETURN_STATUS => X_RETURN_STATUS);
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);
764: )
765: IS
766: BEGIN
767: -- Debug Message
768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
769:
770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);
785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:
788: -- Debug Message
789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
790: END Define_Columns;
791:
792: -- This procudure gets column values by the Dynamic SQL.
793: PROCEDURE Get_Column_Values(
796: )
797: IS
798: BEGIN
799: -- Debug Message
800: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
801:
802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);
817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
822: END Get_Column_Values;
823:
824: PROCEDURE Gen_MOH_order_cl(
825: p_order_by_rec IN CSP_ORDERHEADERS_PUB.MOH_sort_rec_type,
832: l_order_by_cl VARCHAR2(1000) := NULL;
833: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
834: BEGIN
835: -- Debug Message
836: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
837:
838: -- Hint: Developer should add more statements according to CSP_sort_rec_type
839: -- Ex:
840: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
840: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
841: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
845:
846: JTF_PLSQL_API.Translate_OrderBy(
847: p_api_version_number => 1.0
848: ,p_init_msg_list => FND_API.G_FALSE
859: x_order_by_cl := NULL;
860: END IF;
861:
862: -- Debug Message
863: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
864: END Gen_MOH_order_cl;
865:
866: -- This procedure bind the variables for the Dynamic SQL
867: PROCEDURE Bind(
873: BEGIN
874: -- Bind variables
875: -- Only those that are not NULL
876: -- Debug Message
877: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
878:
879: -- The following example applies to all columns,
880: -- developers can copy and paste them.
881: IF( (P_MOH_Rec.HEADER_ID IS NOT NULL) AND (P_MOH_Rec.HEADER_ID <> FND_API.G_MISS_NUM) )
883: DBMS_SQL.BIND_VARIABLE(p_cur_get_MOH, ':p_HEADER_ID', P_MOH_Rec.HEADER_ID);
884: END IF;
885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
888: END Bind;
889:
890: PROCEDURE Gen_Select(
891: x_select_cl OUT NOCOPY VARCHAR2
892: )
893: IS
894: BEGIN
895: -- Debug Message
896: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
897:
898: x_select_cl := 'Select ' ||
899: 'CSP_MOVEORDER_HEADERS_V.HEADER_ID,' ||
900: 'CSP_MOVEORDER_HEADERS_V.CREATED_BY,' ||
917: 'CSP_MOVEORDER_HEADERS_V.PROVINCE,' ||
918: 'CSP_MOVEORDER_HEADERS_V.COUNTRY,' || */
919: 'from CSP_MOVEORDER_HEADERS_V';
920: -- Debug Message
921: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
922:
923: END Gen_Select;
924:
925: PROCEDURE Gen_MOH_Where(
941: str_csr2 NUMBER;
942: l_operator VARCHAR2(10);
943: BEGIN
944: -- Debug Message
945: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
946:
947: -- There are three examples for each kind of datatype:
948: -- NUMBER, DATE, VARCHAR2.
949: -- Developer can copy and paste the following codes for your own record.
1027:
1028: -- Add more IF statements for each column below
1029:
1030: -- Debug Message
1031: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1032:
1033: END Gen_MOH_Where;
1034:
1035: -- Item-level validation procedures
1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF FND_API.to_Boolean( p_init_msg_list )
1051: THEN
1052: FND_MSG_PUB.initialize;
1053: END IF;
1054:
1055:
1056: -- Initialize API return status to SUCCESS
1058:
1059: -- validate NOT NULL column
1060: IF(p_HEADER_ID is NULL)
1061: THEN
1062: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(HEADER_ID)');
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1065:
1066: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1112: end;
1113: END IF;
1114:
1115: -- Standard call to get message count and if count is 1, get message info.
1116: FND_MSG_PUB.Count_And_Get
1117: ( p_count => x_msg_count,
1118: p_data => x_msg_data
1119: );
1120:
1135:
1136: -- Initialize message list if p_init_msg_list is set to TRUE.
1137: IF FND_API.to_Boolean( p_init_msg_list )
1138: THEN
1139: FND_MSG_PUB.initialize;
1140: END IF;
1141:
1142:
1143: -- Initialize API return status to SUCCESS
1145:
1146: -- validate NOT NULL column
1147: IF(p_LOCATION_ID is NULL)
1148: THEN
1149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(LOCATION_ID)');
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;
1152:
1153: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1166: NULL;
1167: END IF;
1168:
1169: -- Standard call to get message count and if count is 1, get message info.
1170: FND_MSG_PUB.Count_And_Get
1171: ( p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );
1174:
1189:
1190: -- Initialize message list if p_init_msg_list is set to TRUE.
1191: IF FND_API.to_Boolean( p_init_msg_list )
1192: THEN
1193: FND_MSG_PUB.initialize;
1194: END IF;
1195:
1196:
1197: -- Initialize API return status to SUCCESS
1213: NULL;
1214: END IF;
1215:
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: ( p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );
1221:
1236:
1237: -- Initialize message list if p_init_msg_list is set to TRUE.
1238: IF FND_API.to_Boolean( p_init_msg_list )
1239: THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242:
1243:
1244: -- Initialize API return status to SUCCESS
1260: NULL;
1261: END IF;
1262:
1263: -- Standard call to get message count and if count is 1, get message info.
1264: FND_MSG_PUB.Count_And_Get
1265: ( p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:
1283:
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list )
1286: THEN
1287: FND_MSG_PUB.initialize;
1288: END IF;
1289:
1290:
1291: -- Initialize API return status to SUCCESS
1307: NULL;
1308: END IF;
1309:
1310: -- Standard call to get message count and if count is 1, get message info.
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315:
1330:
1331: -- Initialize message list if p_init_msg_list is set to TRUE.
1332: IF FND_API.to_Boolean( p_init_msg_list )
1333: THEN
1334: FND_MSG_PUB.initialize;
1335: END IF;
1336:
1337:
1338: -- Initialize API return status to SUCCESS
1354: NULL;
1355: END IF;
1356:
1357: -- Standard call to get message count and if count is 1, get message info.
1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => x_msg_count,
1360: p_data => x_msg_data
1361: );
1362:
1377:
1378: -- Initialize message list if p_init_msg_list is set to TRUE.
1379: IF FND_API.to_Boolean( p_init_msg_list )
1380: THEN
1381: FND_MSG_PUB.initialize;
1382: END IF;
1383:
1384:
1385: -- Initialize API return status to SUCCESS
1401: NULL;
1402: END IF;
1403:
1404: -- Standard call to get message count and if count is 1, get message info.
1405: FND_MSG_PUB.Count_And_Get
1406: ( p_count => x_msg_count,
1407: p_data => x_msg_data
1408: );
1409:
1424:
1425: -- Initialize message list if p_init_msg_list is set to TRUE.
1426: IF FND_API.to_Boolean( p_init_msg_list )
1427: THEN
1428: FND_MSG_PUB.initialize;
1429: END IF;
1430:
1431:
1432: -- Initialize API return status to SUCCESS
1448: NULL;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456:
1471:
1472: -- Initialize message list if p_init_msg_list is set to TRUE.
1473: IF FND_API.to_Boolean( p_init_msg_list )
1474: THEN
1475: FND_MSG_PUB.initialize;
1476: END IF;
1477:
1478:
1479: -- Initialize API return status to SUCCESS
1495: NULL;
1496: END IF;
1497:
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get
1500: ( p_count => x_msg_count,
1501: p_data => x_msg_data
1502: );
1503:
1518:
1519: -- Initialize message list if p_init_msg_list is set to TRUE.
1520: IF FND_API.to_Boolean( p_init_msg_list )
1521: THEN
1522: FND_MSG_PUB.initialize;
1523: END IF;
1524:
1525:
1526: -- Initialize API return status to SUCCESS
1542: NULL;
1543: END IF;
1544:
1545: -- Standard call to get message count and if count is 1, get message info.
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );
1550:
1565:
1566: -- Initialize message list if p_init_msg_list is set to TRUE.
1567: IF FND_API.to_Boolean( p_init_msg_list )
1568: THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572:
1573: -- Initialize API return status to SUCCESS
1589: NULL;
1590: END IF;
1591:
1592: -- Standard call to get message count and if count is 1, get message info.
1593: FND_MSG_PUB.Count_And_Get
1594: ( p_count => x_msg_count,
1595: p_data => x_msg_data
1596: );
1597:
1612:
1613: -- Initialize message list if p_init_msg_list is set to TRUE.
1614: IF FND_API.to_Boolean( p_init_msg_list )
1615: THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619:
1620: -- Initialize API return status to SUCCESS
1636: NULL;
1637: END IF;
1638:
1639: -- Standard call to get message count and if count is 1, get message info.
1640: FND_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count,
1642: p_data => x_msg_data
1643: );
1644:
1659:
1660: -- Initialize message list if p_init_msg_list is set to TRUE.
1661: IF FND_API.to_Boolean( p_init_msg_list )
1662: THEN
1663: FND_MSG_PUB.initialize;
1664: END IF;
1665:
1666:
1667: -- Initialize API return status to SUCCESS
1683: NULL;
1684: END IF;
1685:
1686: -- Standard call to get message count and if count is 1, get message info.
1687: FND_MSG_PUB.Count_And_Get
1688: ( p_count => x_msg_count,
1689: p_data => x_msg_data
1690: );
1691:
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean( p_init_msg_list )
1709: THEN
1710: FND_MSG_PUB.initialize;
1711: END IF;
1712:
1713:
1714: -- Initialize API return status to SUCCESS
1730: NULL;
1731: END IF;
1732:
1733: -- Standard call to get message count and if count is 1, get message info.
1734: FND_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count,
1736: p_data => x_msg_data
1737: );
1738:
1756:
1757: -- Initialize message list if p_init_msg_list is set to TRUE.
1758: IF FND_API.to_Boolean( p_init_msg_list )
1759: THEN
1760: FND_MSG_PUB.initialize;
1761: END IF;
1762:
1763:
1764: -- Initialize API return status to SUCCESS
1769: -- THEN
1770: -- x_return_status := FND_API.G_RET_STS_ERROR;
1771:
1772: -- Debug Message
1773: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count,
1772: -- Debug Message
1773: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count,
1778: p_data => x_msg_data
1779: );
1780:
1793: l_api_name CONSTANT VARCHAR2(30) := 'Validate_orderheaders';
1794: BEGIN
1795:
1796: -- Debug Message
1797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1798:
1799:
1800: -- Initialize API return status to SUCCESS
1801: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988: END IF;
1989:
1990:
1991: -- Debug Message
1992: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1993:
1994: END Validate_orderheaders;
1995:
1996: End CSP_ORDERHEADERS_PVT;