[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;
86: -- Validate Environment
87: -- ******************************************************************
88: IF FND_GLOBAL.User_Id IS NULL
89: THEN
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
91: THEN
92: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
93: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
94: FND_MSG_PUB.ADD;
95: END IF;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
112: */
113: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
114: THEN
115: -- Debug message
116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_headers');
117:
118: -- Invoke validation procedures
119: Validate_packlist_headers(
120: p_init_msg_list => FND_API.G_FALSE,
132:
133: -- Hint: Add corresponding Master-Detail business logic here if necessary.
134:
135: -- Debug Message
136: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
137:
138: -- Invoke table handler(CSP_PACKLIST_HEADERS_PKG.Insert_Row)
139: CSP_PACKLIST_HEADERS_PKG.Insert_Row(
140: px_PACKLIST_HEADER_ID => x_PACKLIST_HEADER_ID,
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);
329:
330: -- Initialize message list if p_init_msg_list is set to TRUE.
331: IF FND_API.to_Boolean( p_init_msg_list )
332: THEN
333: FND_MSG_PUB.initialize;
334: END IF;
335:
336:
337: -- Debug Message
334: END IF;
335:
336:
337: -- Debug Message
338: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
339:
340:
341: -- Initialize API return status to SUCCESS
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;*/
377:
378: -- Debug Message
379: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
380:
381: /*
382: Open C_Get_packlist_headers( l_tar_PLH_rec.PACKLIST_HEADER_ID);
383:
419: l_ref_PLH_rec.ATTRIBUTE14,
420: l_ref_PLH_rec.ATTRIBUTE15;
421:
422: If ( C_Get_packlist_headers%NOTFOUND) Then
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
426: FND_MESSAGE.Set_Token ('INFO', 'packlist_headers', FALSE);
427: FND_MSG_PUB.Add;
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
424: THEN
425: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
426: FND_MESSAGE.Set_Token ('INFO', 'packlist_headers', FALSE);
427: FND_MSG_PUB.Add;
428: END IF;
429: raise FND_API.G_EXC_ERROR;
430: END IF;
431: -- Debug Message
428: END IF;
429: raise FND_API.G_EXC_ERROR;
430: END IF;
431: -- Debug Message
432: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
433: Close C_Get_packlist_headers;
434:
435:
436:
435:
436:
437: If (l_tar_PLH_rec.last_update_date is NULL or
438: l_tar_PLH_rec.last_update_date = FND_API.G_MISS_Date ) Then
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
440: THEN
441: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
442: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
443: FND_MSG_PUB.ADD;
439: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
440: THEN
441: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
442: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
443: FND_MSG_PUB.ADD;
444: END IF;
445: raise FND_API.G_EXC_ERROR;
446: End if;
447:
446: End if;
447:
448: -- Check Whether record has been changed by someone else
449: If (l_tar_PLH_rec.last_update_date <> l_ref_PLH_rec.last_update_date) Then
450: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
451: THEN
452:
453: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
454: FND_MESSAGE.Set_Token('INFO', 'packlist_headers', FALSE);
451: THEN
452:
453: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
454: FND_MESSAGE.Set_Token('INFO', 'packlist_headers', FALSE);
455: FND_MSG_PUB.ADD;
456: END IF;
457: raise FND_API.G_EXC_ERROR;
458: End if;
459: */
459: */
460: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
461: THEN
462: -- Debug message
463: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_headers');
464:
465: -- Invoke validation procedures
466: Validate_packlist_headers(
467: p_init_msg_list => FND_API.G_FALSE,
479:
480: -- Hint: Add corresponding Master-Detail business logic here if necessary.
481:
482: -- Debug Message
483: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
484:
485: -- Invoke table handler(CSP_PACKLIST_HEADERS_PKG.Update_Row)
486: CSP_PACKLIST_HEADERS_PKG.Update_Row(
487: p_PACKLIST_HEADER_ID => p_PLH_rec.PACKLIST_HEADER_ID,
530: END IF;
531:
532:
533: -- Debug Message
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
535:
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
535:
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get
539: ( p_count => x_msg_count,
540: p_data => x_msg_data
541: );
542:
562: WHEN FND_API.G_EXC_ERROR THEN
563: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
564: P_API_NAME => L_API_NAME
565: ,P_PKG_NAME => G_PKG_NAME
566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
567: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
568: ,X_MSG_COUNT => X_MSG_COUNT
569: ,X_MSG_DATA => X_MSG_DATA
570: ,X_RETURN_STATUS => X_RETURN_STATUS);
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
574: P_API_NAME => L_API_NAME
575: ,P_PKG_NAME => G_PKG_NAME
576: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
578: ,X_MSG_COUNT => X_MSG_COUNT
579: ,X_MSG_DATA => X_MSG_DATA
580: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF FND_API.to_Boolean( p_init_msg_list )
628: THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632:
633: -- Debug Message
630: END IF;
631:
632:
633: -- Debug Message
634: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
635:
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673: */
674: -- Debug Message
675: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
676:
677: -- Invoke table handler(CSP_PACKLIST_HEADERS_PKG.Delete_Row)
678: CSP_PACKLIST_HEADERS_PKG.Delete_Row(
679: p_PACKLIST_HEADER_ID => p_PLH_rec.PACKLIST_HEADER_ID);
688: END IF;
689:
690:
691: -- Debug Message
692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
693:
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
693:
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count,
698: p_data => x_msg_data
699: );
700:
720: WHEN FND_API.G_EXC_ERROR THEN
721: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
722: P_API_NAME => L_API_NAME
723: ,P_PKG_NAME => G_PKG_NAME
724: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
725: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
726: ,X_MSG_COUNT => X_MSG_COUNT
727: ,X_MSG_DATA => X_MSG_DATA
728: ,X_RETURN_STATUS => X_RETURN_STATUS);
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
732: P_API_NAME => L_API_NAME
733: ,P_PKG_NAME => G_PKG_NAME
734: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
735: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
736: ,X_MSG_COUNT => X_MSG_COUNT
737: ,X_MSG_DATA => X_MSG_DATA
738: ,X_RETURN_STATUS => X_RETURN_STATUS);
756: )
757: IS
758: BEGIN
759: -- Debug Message
760: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
761:
762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:
795: -- Debug Message
796: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
797: END Define_Columns;
798:
799: -- This procudure gets column values by the Dynamic SQL.
800: PROCEDURE Get_Column_Values(
803: )
804: IS
805: BEGIN
806: -- Debug Message
807: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
808:
809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
845: END Get_Column_Values;
846:
847: PROCEDURE Gen_PLH_order_cl(
848: p_order_by_rec IN CSP_Packlist_Headers_PUB.PLH_sort_rec_type,
855: l_order_by_cl VARCHAR2(1000) := NULL;
856: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
857: BEGIN
858: -- Debug Message
859: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
860:
861: -- Hint: Developer should add more statements according to CSP_sort_rec_type
862: -- Ex:
863: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
863: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
864: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
865:
866: -- Debug Message
867: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
868:
869: JTF_PLSQL_API.Translate_OrderBy(
870: p_api_version_number => 1.0
871: ,p_init_msg_list => FND_API.G_FALSE
882: x_order_by_cl := NULL;
883: END IF;
884:
885: -- Debug Message
886: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
887: END Gen_PLH_order_cl;
888:
889: -- This procedure bind the variables for the Dynamic SQL
890: PROCEDURE Bind(
896: BEGIN
897: -- Bind variables
898: -- Only those that are not NULL
899: -- Debug Message
900: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
901:
902: -- The following example applies to all columns,
903: -- developers can copy and paste them.
904: IF( (P_PLH_Rec.PACKLIST_HEADER_ID IS NOT NULL) AND (P_PLH_Rec.PACKLIST_HEADER_ID <> FND_API.G_MISS_NUM) )
906: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLH, ':p_PACKLIST_HEADER_ID', P_PLH_Rec.PACKLIST_HEADER_ID);
907: END IF;
908:
909: -- Debug Message
910: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
911: END Bind;
912:
913: PROCEDURE Gen_Select(
914: x_select_cl OUT NOCOPY VARCHAR2
915: )
916: IS
917: BEGIN
918: -- Debug Message
919: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
920:
921: x_select_cl := 'Select ' ||
922: 'CSP_PACKLIST_HEADERS_V.ROW_ID,' ||
923: 'CSP_PACKLIST_HEADERS_V.PACKLIST_HEADER_ID,' ||
957: 'CSP_PACKLIST_HEADERS_V.ATTRIBUTE14,' ||
958: 'CSP_PACKLIST_HEADERS_V.ATTRIBUTE15,' ||
959: 'from CSP_PACKLIST_HEADERS_V';
960: -- Debug Message
961: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
962:
963: END Gen_Select;
964:
965: PROCEDURE Gen_PLH_Where(
981: str_csr2 NUMBER;
982: l_operator VARCHAR2(10);
983: BEGIN
984: -- Debug Message
985: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
986:
987: -- There are three examples for each kind of datatype:
988: -- NUMBER, DATE, VARCHAR2.
989: -- Developer can copy and paste the following codes for your own record.
1067:
1068: -- Add more IF statements for each column below
1069:
1070: -- Debug Message
1071: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1072:
1073: END Gen_PLH_Where;
1074:
1075: -- Item-level validation procedures
1087:
1088: -- Initialize message list if p_init_msg_list is set to TRUE.
1089: IF FND_API.to_Boolean( p_init_msg_list )
1090: THEN
1091: FND_MSG_PUB.initialize;
1092: END IF;
1093:
1094:
1095: -- Initialize API return status to SUCCESS
1097:
1098: -- validate NOT NULL column
1099: IF(p_PACKLIST_HEADER_ID is NULL)
1100: THEN
1101: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1102: constraint(PACKLIST_HEADER_ID)');
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;
1105:
1119: NULL;
1120: END IF;
1121:
1122: -- Standard call to get message count and if count is 1, get message info.
1123: FND_MSG_PUB.Count_And_Get
1124: ( p_count => x_msg_count,
1125: p_data => x_msg_data
1126: );
1127:
1142:
1143: -- Initialize message list if p_init_msg_list is set to TRUE.
1144: IF FND_API.to_Boolean( p_init_msg_list )
1145: THEN
1146: FND_MSG_PUB.initialize;
1147: END IF;
1148:
1149:
1150: -- Initialize API return status to SUCCESS
1152:
1153: -- validate NOT NULL column
1154: IF(p_ORGANIZATION_ID is NULL)
1155: THEN
1156: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1157: constraint(ORGANIZATION_ID)');
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;
1160:
1174: NULL;
1175: END IF;
1176:
1177: -- Standard call to get message count and if count is 1, get message info.
1178: FND_MSG_PUB.Count_And_Get
1179: ( p_count => x_msg_count,
1180: p_data => x_msg_data
1181: );
1182:
1197:
1198: -- Initialize message list if p_init_msg_list is set to TRUE.
1199: IF FND_API.to_Boolean( p_init_msg_list )
1200: THEN
1201: FND_MSG_PUB.initialize;
1202: END IF;
1203:
1204:
1205: -- Initialize API return status to SUCCESS
1207:
1208: -- validate NOT NULL column
1209: IF(p_PACKLIST_NUMBER is NULL)
1210: THEN
1211: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1212: constraint(PACKLIST_NUMBER)');
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: END IF;
1215:
1229: NULL;
1230: END IF;
1231:
1232: -- Standard call to get message count and if count is 1, get message info.
1233: FND_MSG_PUB.Count_And_Get
1234: ( p_count => x_msg_count,
1235: p_data => x_msg_data
1236: );
1237:
1252:
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list )
1255: THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:
1259:
1260: -- Initialize API return status to SUCCESS
1262:
1263: -- validate NOT NULL column
1264: IF(p_SUBINVENTORY_CODE is NULL)
1265: THEN
1266: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1267: constraint(SUBINVENTORY_CODE)');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: END IF;
1270:
1284: NULL;
1285: END IF;
1286:
1287: -- Standard call to get message count and if count is 1, get message info.
1288: FND_MSG_PUB.Count_And_Get
1289: ( p_count => x_msg_count,
1290: p_data => x_msg_data
1291: );
1292:
1307:
1308: -- Initialize message list if p_init_msg_list is set to TRUE.
1309: IF FND_API.to_Boolean( p_init_msg_list )
1310: THEN
1311: FND_MSG_PUB.initialize;
1312: END IF;
1313:
1314:
1315: -- Initialize API return status to SUCCESS
1317:
1318: -- validate NOT NULL column
1319: IF(p_PACKLIST_STATUS is NULL)
1320: THEN
1321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1322: constraint(PACKLIST_STATUS)');
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1339: NULL;
1340: END IF;
1341:
1342: -- Standard call to get message count and if count is 1, get message info.
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );
1347:
1362:
1363: -- Initialize message list if p_init_msg_list is set to TRUE.
1364: IF FND_API.to_Boolean( p_init_msg_list )
1365: THEN
1366: FND_MSG_PUB.initialize;
1367: END IF;
1368:
1369:
1370: -- Initialize API return status to SUCCESS
1372:
1373: -- validate NOT NULL column
1374: IF(p_DATE_CREATED is NULL)
1375: THEN
1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1377: constraint(DATE_CREATED)');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: END IF;
1380:
1394: NULL;
1395: END IF;
1396:
1397: -- Standard call to get message count and if count is 1, get message info.
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );
1402:
1417:
1418: -- Initialize message list if p_init_msg_list is set to TRUE.
1419: IF FND_API.to_Boolean( p_init_msg_list )
1420: THEN
1421: FND_MSG_PUB.initialize;
1422: END IF;
1423:
1424:
1425: -- Initialize API return status to SUCCESS
1441: NULL;
1442: END IF;
1443:
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.Count_And_Get
1446: ( p_count => x_msg_count,
1447: p_data => x_msg_data
1448: );
1449:
1464:
1465: -- Initialize message list if p_init_msg_list is set to TRUE.
1466: IF FND_API.to_Boolean( p_init_msg_list )
1467: THEN
1468: FND_MSG_PUB.initialize;
1469: END IF;
1470:
1471:
1472: -- Initialize API return status to SUCCESS
1488: NULL;
1489: END IF;
1490:
1491: -- Standard call to get message count and if count is 1, get message info.
1492: FND_MSG_PUB.Count_And_Get
1493: ( p_count => x_msg_count,
1494: p_data => x_msg_data
1495: );
1496:
1511:
1512: -- Initialize message list if p_init_msg_list is set to TRUE.
1513: IF FND_API.to_Boolean( p_init_msg_list )
1514: THEN
1515: FND_MSG_PUB.initialize;
1516: END IF;
1517:
1518:
1519: -- Initialize API return status to SUCCESS
1535: NULL;
1536: END IF;
1537:
1538: -- Standard call to get message count and if count is 1, get message info.
1539: FND_MSG_PUB.Count_And_Get
1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );
1543:
1558:
1559: -- Initialize message list if p_init_msg_list is set to TRUE.
1560: IF FND_API.to_Boolean( p_init_msg_list )
1561: THEN
1562: FND_MSG_PUB.initialize;
1563: END IF;
1564:
1565:
1566: -- Initialize API return status to SUCCESS
1582: NULL;
1583: END IF;
1584:
1585: -- Standard call to get message count and if count is 1, get message info.
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );
1590:
1605:
1606: -- Initialize message list if p_init_msg_list is set to TRUE.
1607: IF FND_API.to_Boolean( p_init_msg_list )
1608: THEN
1609: FND_MSG_PUB.initialize;
1610: END IF;
1611:
1612:
1613: -- Initialize API return status to SUCCESS
1629: NULL;
1630: END IF;
1631:
1632: -- Standard call to get message count and if count is 1, get message info.
1633: FND_MSG_PUB.Count_And_Get
1634: ( p_count => x_msg_count,
1635: p_data => x_msg_data
1636: );
1637:
1652:
1653: -- Initialize message list if p_init_msg_list is set to TRUE.
1654: IF FND_API.to_Boolean( p_init_msg_list )
1655: THEN
1656: FND_MSG_PUB.initialize;
1657: END IF;
1658:
1659:
1660: -- Initialize API return status to SUCCESS
1676: NULL;
1677: END IF;
1678:
1679: -- Standard call to get message count and if count is 1, get message info.
1680: FND_MSG_PUB.Count_And_Get
1681: ( p_count => x_msg_count,
1682: p_data => x_msg_data
1683: );
1684:
1699:
1700: -- Initialize message list if p_init_msg_list is set to TRUE.
1701: IF FND_API.to_Boolean( p_init_msg_list )
1702: THEN
1703: FND_MSG_PUB.initialize;
1704: END IF;
1705:
1706:
1707: -- Initialize API return status to SUCCESS
1723: NULL;
1724: END IF;
1725:
1726: -- Standard call to get message count and if count is 1, get message info.
1727: FND_MSG_PUB.Count_And_Get
1728: ( p_count => x_msg_count,
1729: p_data => x_msg_data
1730: );
1731:
1748:
1749: -- Initialize message list if p_init_msg_list is set to TRUE.
1750: IF FND_API.to_Boolean( p_init_msg_list )
1751: THEN
1752: FND_MSG_PUB.initialize;
1753: END IF;
1754:
1755:
1756: -- Initialize API return status to SUCCESS
1761: -- THEN
1762: -- x_return_status := FND_API.G_RET_STS_ERROR;
1763:
1764: -- Debug Message
1765: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1766:
1767: -- Standard call to get message count and if count is 1, get message info.
1768: FND_MSG_PUB.Count_And_Get
1769: ( p_count => x_msg_count,
1764: -- Debug Message
1765: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1766:
1767: -- Standard call to get message count and if count is 1, get message info.
1768: FND_MSG_PUB.Count_And_Get
1769: ( p_count => x_msg_count,
1770: p_data => x_msg_data
1771: );
1772:
1785: l_api_name CONSTANT VARCHAR2(30) := 'Validate_packlist_headers';
1786: BEGIN
1787:
1788: -- Debug Message
1789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1790:
1791:
1792: -- Initialize API return status to SUCCESS
1793: x_return_status := FND_API.G_RET_STS_SUCCESS;
1981: END IF;
1982:
1983:
1984: -- Debug Message
1985: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1986:
1987: END Validate_packlist_headers;
1988:
1989: End CSP_Packlist_Headers_PVT;