[Home] [Help]
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE.
53: IF FND_API.to_Boolean( p_init_msg_list )
54: THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58:
59: -- Debug Message
56: END IF;
57:
58:
59: -- Debug Message
60: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
61:
62:
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: -- Validate Environment
89: -- ******************************************************************
90: IF FND_GLOBAL.User_Id IS NULL
91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
96: FND_MSG_PUB.ADD;
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
93: THEN
94: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
95: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
96: FND_MSG_PUB.ADD;
97: END IF;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
114:
115: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
116: THEN
117: -- Debug message
118: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
119:
120: -- Invoke validation procedures
121: IF (g_debug > 0 ) THEN
122: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before Validate_repair_history');
145:
146: -- Hint: Add corresponding Master-Detail business logic here if necessary.
147:
148: -- Debug Message
149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
150:
151: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Insert_Row)
152: IF (g_debug > 0 ) THEN
153: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Create_repair_history before CSD_REPAIR_HISTORY_PKG.Insert_Row');
241: END IF;
242:
243:
244: -- Debug Message
245: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
246:
247:
248: -- Standard call to get message count and if count is 1, get message info.
249: FND_MSG_PUB.Count_And_Get
245: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
246:
247:
248: -- Standard call to get message count and if count is 1, get message info.
249: FND_MSG_PUB.Count_And_Get
250: ( p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:
272: WHEN FND_API.G_EXC_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
277: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
278: ,X_MSG_COUNT => X_MSG_COUNT
279: ,X_MSG_DATA => X_MSG_DATA
280: ,X_RETURN_STATUS => X_RETURN_STATUS);
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
285: P_API_NAME => L_API_NAME
286: ,P_PKG_NAME => G_PKG_NAME
287: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
288: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
289: ,X_MSG_COUNT => X_MSG_COUNT
290: ,X_MSG_DATA => X_MSG_DATA
291: ,X_RETURN_STATUS => X_RETURN_STATUS);
412:
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list )
415: THEN
416: FND_MSG_PUB.initialize;
417: END IF;
418:
419:
420: -- Debug Message
417: END IF;
418:
419:
420: -- Debug Message
421: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
422:
423:
424: -- Initialize API return status to SUCCESS
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
458: RAISE FND_API.G_EXC_ERROR;
459: END IF;
460: */
461: -- Debug Message
462: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Open Cursor to Select');
463:
464: /*
465: Open C_Get_repair_history( l_tar_REPH_rec.REPAIR_HISTORY_ID);
466:
528: l_ref_REPH_rec.ATTRIBUTE15,
529: l_ref_REPH_rec.LAST_UPDATE_LOGIN;
530:
531: If ( C_Get_repair_history%NOTFOUND) Then
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN
534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
536: FND_MSG_PUB.Add;
532: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
533: THEN
534: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
535: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
536: FND_MSG_PUB.Add;
537: END IF;
538: raise FND_API.G_EXC_ERROR;
539: END IF;
540: -- Debug Message
537: END IF;
538: raise FND_API.G_EXC_ERROR;
539: END IF;
540: -- Debug Message
541: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');
542: Close C_Get_repair_history;
543: */
544:
545:
544:
545:
546: If (l_tar_REPH_rec.last_update_date is NULL or
547: l_tar_REPH_rec.last_update_date = FND_API.G_MISS_Date ) Then
548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
549: THEN
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
552: FND_MSG_PUB.ADD;
548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
549: THEN
550: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
551: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
552: FND_MSG_PUB.ADD;
553: END IF;
554: raise FND_API.G_EXC_ERROR;
555: End if;
556: -- Check Whether record has been changed by someone else
554: raise FND_API.G_EXC_ERROR;
555: End if;
556: -- Check Whether record has been changed by someone else
557: If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_rec.last_update_date) Then
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
559: THEN
560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
562: FND_MSG_PUB.ADD;
558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
559: THEN
560: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
561: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
562: FND_MSG_PUB.ADD;
563: END IF;
564: raise FND_API.G_EXC_ERROR;
565: End if;
566:
566:
567: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
568: THEN
569: -- Debug message
570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
571:
572: -- Invoke validation procedures
573: Validate_repair_history(
574: p_init_msg_list => FND_API.G_FALSE,
586:
587: -- Hint: Add corresponding Master-Detail business logic here if necessary.
588:
589: -- Debug Message
590: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');
591:
592: -- travi OBJECT_VERSION_NUMBER validation
593: l_OBJECT_VERSION_NUMBER := p_REPH_rec.OBJECT_VERSION_NUMBER + 1;
594:
668: END IF;
669:
670:
671: -- Debug Message
672: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
673:
674:
675: -- Standard call to get message count and if count is 1, get message info.
676: FND_MSG_PUB.Count_And_Get
672: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
673:
674:
675: -- Standard call to get message count and if count is 1, get message info.
676: FND_MSG_PUB.Count_And_Get
677: ( p_count => x_msg_count,
678: p_data => x_msg_data
679: );
680:
700: WHEN FND_API.G_EXC_ERROR THEN
701: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
702: P_API_NAME => L_API_NAME
703: ,P_PKG_NAME => G_PKG_NAME
704: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
705: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
706: ,X_MSG_COUNT => X_MSG_COUNT
707: ,X_MSG_DATA => X_MSG_DATA
708: ,X_RETURN_STATUS => X_RETURN_STATUS);
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
713: P_API_NAME => L_API_NAME
714: ,P_PKG_NAME => G_PKG_NAME
715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
716: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
717: ,X_MSG_COUNT => X_MSG_COUNT
718: ,X_MSG_DATA => X_MSG_DATA
719: ,X_RETURN_STATUS => X_RETURN_STATUS);
765:
766: -- Initialize message list if p_init_msg_list is set to TRUE.
767: IF FND_API.to_Boolean( p_init_msg_list )
768: THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
772:
773: -- Debug Message
770: END IF;
771:
772:
773: -- Debug Message
774: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
775:
776:
777: -- Initialize API return status to SUCCESS
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
812: END IF;
813: */
814:
815: -- Debug Message
816: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
817:
818: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Delete_Row)
819: CSD_REPAIR_HISTORY_PKG.Delete_Row(
820: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
830: END IF;
831:
832:
833: -- Debug Message
834: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
835:
836:
837: -- Standard call to get message count and if count is 1, get message info.
838: FND_MSG_PUB.Count_And_Get
834: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
835:
836:
837: -- Standard call to get message count and if count is 1, get message info.
838: FND_MSG_PUB.Count_And_Get
839: ( p_count => x_msg_count,
840: p_data => x_msg_data
841: );
842:
862: WHEN FND_API.G_EXC_ERROR THEN
863: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
864: P_API_NAME => L_API_NAME
865: ,P_PKG_NAME => G_PKG_NAME
866: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
867: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
868: ,X_MSG_COUNT => X_MSG_COUNT
869: ,X_MSG_DATA => X_MSG_DATA
870: ,X_RETURN_STATUS => X_RETURN_STATUS);
873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
875: P_API_NAME => L_API_NAME
876: ,P_PKG_NAME => G_PKG_NAME
877: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
878: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
879: ,X_MSG_COUNT => X_MSG_COUNT
880: ,X_MSG_DATA => X_MSG_DATA
881: ,X_RETURN_STATUS => X_RETURN_STATUS);
901: )
902: IS
903: BEGIN
904: -- Debug Message
905: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
906:
907: -- define all columns for CSD_REPAIR_HISTORY_V view
908: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
909: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
960: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
961: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
962:
963: -- Debug Message
964: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');
965: END Define_Columns;
966:
967: -- This procudure gets column values by the Dynamic SQL.
968: PROCEDURE Get_Column_Values(
971: )
972: IS
973: BEGIN
974: -- Debug Message
975: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
976:
977: -- get all column values for CSD_REPAIR_HISTORY_V table
978: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
979: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
1030: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1031: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1032:
1033: -- Debug Message
1034: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');
1035: END Get_Column_Values;
1036:
1037: PROCEDURE Gen_REPH_order_cl(
1038: p_order_by_rec IN CSD_REPAIR_HISTORY_PVT.REPH_sort_rec_type,
1045: l_order_by_cl VARCHAR2(1000) := NULL;
1046: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
1047: BEGIN
1048: -- Debug Message
1049: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Begins');
1050:
1051: -- Hint: Developer should add more statements according to CSD_sort_rec_type
1052: -- Ex:
1053: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1053: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1054: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
1055:
1056: -- Debug Message
1057: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1058:
1059: JTF_PLSQL_API.Translate_OrderBy(
1060: p_api_version_number => 1.0
1061: ,p_init_msg_list => FND_API.G_FALSE
1072: x_order_by_cl := NULL;
1073: END IF;
1074:
1075: -- Debug Message
1076: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Ends');
1077: END Gen_REPH_order_cl;
1078:
1079: -- This procedure bind the variables for the Dynamic SQL
1080: PROCEDURE Bind(
1086: BEGIN
1087: -- Bind variables
1088: -- Only those that are not NULL
1089: -- Debug Message
1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');
1091:
1092: -- The following example applies to all columns,
1093: -- developers can copy and paste them.
1094: IF( (P_REPH_Rec.REPAIR_HISTORY_ID IS NOT NULL) AND (P_REPH_Rec.REPAIR_HISTORY_ID <> FND_API.G_MISS_NUM) )
1096: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPH, ':p_REPAIR_HISTORY_ID', P_REPH_Rec.REPAIR_HISTORY_ID);
1097: END IF;
1098:
1099: -- Debug Message
1100: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Ends');
1101: END Bind;
1102:
1103: PROCEDURE Gen_Select(
1104: x_select_cl OUT NOCOPY VARCHAR2
1105: )
1106: IS
1107: BEGIN
1108: -- Debug Message
1109: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
1110:
1111: x_select_cl := 'Select ' ||
1112: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1113: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1172: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1173: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1174: 'from CSD_REPAIR_HISTORY_V';
1175: -- Debug Message
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
1177:
1178: END Gen_Select;
1179:
1180: PROCEDURE Gen_REPH_Where(
1196: str_csr2 NUMBER;
1197: l_operator VARCHAR2(10);
1198: BEGIN
1199: -- Debug Message
1200: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Begins');
1201:
1202: -- There are three examples for each kind of datatype:
1203: -- NUMBER, DATE, VARCHAR2.
1204: -- Developer can copy and paste the following codes for your own record.
1282:
1283: -- Add more IF statements for each column below
1284:
1285: -- Debug Message
1286: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Ends');
1287:
1288: END Gen_REPH_Where;
1289:
1290: PROCEDURE Get_repair_history(
1360:
1361: -- Initialize message list if p_init_msg_list is set to TRUE.
1362: IF FND_API.to_Boolean( p_init_msg_list )
1363: THEN
1364: FND_MSG_PUB.initialize;
1365: END IF;
1366:
1367:
1368: -- Debug Message
1365: END IF;
1366:
1367:
1368: -- Debug Message
1369: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1370:
1371:
1372: -- Initialize API return status to SUCCESS
1373: x_return_status := FND_API.G_RET_STS_SUCCESS;
1392: -- Generate Dynamic SQL based on criteria passed in.
1393: -- Doing this for performance. Indexes are disabled when using NVL within static SQL statement.
1394: -- Ignore condition when criteria is NULL
1395: -- Debug Message
1396: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generating Dsql');
1397: -- Generate Select clause and From clause
1398: -- Hint: Developer should modify Gen_Select procedure.
1399: Gen_Select(l_select_cl);
1400:
1434: -- Generate order by clause
1435: Gen_REPH_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
1436:
1437: -- Debug Message
1438: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Open and Parse Cursor');
1439:
1440: l_cur_get_REPH := dbms_sql.open_cursor;
1441:
1442: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1460: Define_Columns(l_crit_REPH_rec, l_cur_get_REPH);
1461:
1462: -- Execute
1463: -- Debug Message
1464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');
1465:
1466: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1467:
1468: -- Debug Message
1465:
1466: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1467:
1468: -- Debug Message
1469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');
1470:
1471: -- This loop is here to avoid calling a function in the main
1472: -- cursor. Basically, calling this function seems to disable
1473: -- index, but verification is needed. This is a good
1480: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1481: OR (l_returned_rec_count
1483: -- Debug Message
1484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1485:
1486: -- Hint: Developer need to implement this part
1487: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1488: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1512: -- End of API body
1513: --
1514:
1515: -- Debug Message
1516: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1517:
1518:
1519: -- Standard call to get message count and if count is 1, get message info.
1520: FND_MSG_PUB.Count_And_Get
1516: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1517:
1518:
1519: -- Standard call to get message count and if count is 1, get message info.
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_count => x_msg_count,
1522: p_data => x_msg_data
1523: );
1524:
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1528: P_API_NAME => L_API_NAME
1529: ,P_PKG_NAME => G_PKG_NAME
1530: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1531: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1532: ,X_MSG_COUNT => X_MSG_COUNT
1533: ,X_MSG_DATA => X_MSG_DATA
1534: ,X_RETURN_STATUS => X_RETURN_STATUS);
1537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1538: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1539: P_API_NAME => L_API_NAME
1540: ,P_PKG_NAME => G_PKG_NAME
1541: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1542: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1543: ,X_MSG_COUNT => X_MSG_COUNT
1544: ,X_MSG_DATA => X_MSG_DATA
1545: ,X_RETURN_STATUS => X_RETURN_STATUS);
1573:
1574: -- Initialize message list if p_init_msg_list is set to TRUE.
1575: IF FND_API.to_Boolean( p_init_msg_list )
1576: THEN
1577: FND_MSG_PUB.initialize;
1578: END IF;
1579:
1580:
1581: -- Initialize API return status to SUCCESS
1583:
1584: -- validate NOT NULL column
1585: IF(p_REPAIR_HISTORY_ID is NULL)
1586: THEN
1587: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_HISTORY_ID)');
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END IF;
1590:
1591: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1604: NULL;
1605: END IF;
1606:
1607: -- Standard call to get message count and if count is 1, get message info.
1608: FND_MSG_PUB.Count_And_Get
1609: ( p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );
1612:
1627:
1628: -- Initialize message list if p_init_msg_list is set to TRUE.
1629: IF FND_API.to_Boolean( p_init_msg_list )
1630: THEN
1631: FND_MSG_PUB.initialize;
1632: END IF;
1633:
1634:
1635: -- Initialize API return status to SUCCESS
1651: NULL;
1652: END IF;
1653:
1654: -- Standard call to get message count and if count is 1, get message info.
1655: FND_MSG_PUB.Count_And_Get
1656: ( p_count => x_msg_count,
1657: p_data => x_msg_data
1658: );
1659:
1674:
1675: -- Initialize message list if p_init_msg_list is set to TRUE.
1676: IF FND_API.to_Boolean( p_init_msg_list )
1677: THEN
1678: FND_MSG_PUB.initialize;
1679: END IF;
1680:
1681:
1682: -- Initialize API return status to SUCCESS
1684:
1685: -- validate NOT NULL column
1686: IF(p_REPAIR_LINE_ID is NULL)
1687: THEN
1688: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: END IF;
1691:
1692: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1705: NULL;
1706: END IF;
1707:
1708: -- Standard call to get message count and if count is 1, get message info.
1709: FND_MSG_PUB.Count_And_Get
1710: ( p_count => x_msg_count,
1711: p_data => x_msg_data
1712: );
1713:
1728:
1729: -- Initialize message list if p_init_msg_list is set to TRUE.
1730: IF FND_API.to_Boolean( p_init_msg_list )
1731: THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1735:
1736: -- Initialize API return status to SUCCESS
1738:
1739: -- validate NOT NULL column
1740: IF(p_EVENT_CODE is NULL)
1741: THEN
1742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_CODE)');
1743: x_return_status := FND_API.G_RET_STS_ERROR;
1744: END IF;
1745:
1746: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1759: NULL;
1760: END IF;
1761:
1762: -- Standard call to get message count and if count is 1, get message info.
1763: FND_MSG_PUB.Count_And_Get
1764: ( p_count => x_msg_count,
1765: p_data => x_msg_data
1766: );
1767:
1784:
1785: -- Initialize message list if p_init_msg_list is set to TRUE.
1786: IF FND_API.to_Boolean( p_init_msg_list )
1787: THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;
1790:
1791:
1792: -- Initialize API return status to SUCCESS
1794:
1795: -- validate NOT NULL column
1796: IF(p_EVENT_meaning is NULL)
1797: THEN
1798: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_MEANING)');
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: END IF;
1801:
1802: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1815: NULL;
1816: END IF;
1817:
1818: -- Standard call to get message count and if count is 1, get message info.
1819: FND_MSG_PUB.Count_And_Get
1820: ( p_count => x_msg_count,
1821: p_data => x_msg_data
1822: );
1823:
1838:
1839: -- Initialize message list if p_init_msg_list is set to TRUE.
1840: IF FND_API.to_Boolean( p_init_msg_list )
1841: THEN
1842: FND_MSG_PUB.initialize;
1843: END IF;
1844:
1845:
1846: -- Initialize API return status to SUCCESS
1848:
1849: -- validate NOT NULL column
1850: IF(p_EVENT_DATE is NULL)
1851: THEN
1852: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_DATE)');
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:
1856: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1869: NULL;
1870: END IF;
1871:
1872: -- Standard call to get message count and if count is 1, get message info.
1873: FND_MSG_PUB.Count_And_Get
1874: ( p_count => x_msg_count,
1875: p_data => x_msg_data
1876: );
1877:
1892:
1893: -- Initialize message list if p_init_msg_list is set to TRUE.
1894: IF FND_API.to_Boolean( p_init_msg_list )
1895: THEN
1896: FND_MSG_PUB.initialize;
1897: END IF;
1898:
1899:
1900: -- Initialize API return status to SUCCESS
1916: NULL;
1917: END IF;
1918:
1919: -- Standard call to get message count and if count is 1, get message info.
1920: FND_MSG_PUB.Count_And_Get
1921: ( p_count => x_msg_count,
1922: p_data => x_msg_data
1923: );
1924:
1939:
1940: -- Initialize message list if p_init_msg_list is set to TRUE.
1941: IF FND_API.to_Boolean( p_init_msg_list )
1942: THEN
1943: FND_MSG_PUB.initialize;
1944: END IF;
1945:
1946:
1947: -- Initialize API return status to SUCCESS
1963: NULL;
1964: END IF;
1965:
1966: -- Standard call to get message count and if count is 1, get message info.
1967: FND_MSG_PUB.Count_And_Get
1968: ( p_count => x_msg_count,
1969: p_data => x_msg_data
1970: );
1971:
1986:
1987: -- Initialize message list if p_init_msg_list is set to TRUE.
1988: IF FND_API.to_Boolean( p_init_msg_list )
1989: THEN
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993:
1994: -- Initialize API return status to SUCCESS
2010: NULL;
2011: END IF;
2012:
2013: -- Standard call to get message count and if count is 1, get message info.
2014: FND_MSG_PUB.Count_And_Get
2015: ( p_count => x_msg_count,
2016: p_data => x_msg_data
2017: );
2018:
2033:
2034: -- Initialize message list if p_init_msg_list is set to TRUE.
2035: IF FND_API.to_Boolean( p_init_msg_list )
2036: THEN
2037: FND_MSG_PUB.initialize;
2038: END IF;
2039:
2040:
2041: -- Initialize API return status to SUCCESS
2057: NULL;
2058: END IF;
2059:
2060: -- Standard call to get message count and if count is 1, get message info.
2061: FND_MSG_PUB.Count_And_Get
2062: ( p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );
2065:
2080:
2081: -- Initialize message list if p_init_msg_list is set to TRUE.
2082: IF FND_API.to_Boolean( p_init_msg_list )
2083: THEN
2084: FND_MSG_PUB.initialize;
2085: END IF;
2086:
2087:
2088: -- Initialize API return status to SUCCESS
2104: NULL;
2105: END IF;
2106:
2107: -- Standard call to get message count and if count is 1, get message info.
2108: FND_MSG_PUB.Count_And_Get
2109: ( p_count => x_msg_count,
2110: p_data => x_msg_data
2111: );
2112:
2127:
2128: -- Initialize message list if p_init_msg_list is set to TRUE.
2129: IF FND_API.to_Boolean( p_init_msg_list )
2130: THEN
2131: FND_MSG_PUB.initialize;
2132: END IF;
2133:
2134:
2135: -- Initialize API return status to SUCCESS
2151: NULL;
2152: END IF;
2153:
2154: -- Standard call to get message count and if count is 1, get message info.
2155: FND_MSG_PUB.Count_And_Get
2156: ( p_count => x_msg_count,
2157: p_data => x_msg_data
2158: );
2159:
2174:
2175: -- Initialize message list if p_init_msg_list is set to TRUE.
2176: IF FND_API.to_Boolean( p_init_msg_list )
2177: THEN
2178: FND_MSG_PUB.initialize;
2179: END IF;
2180:
2181:
2182: -- Initialize API return status to SUCCESS
2198: NULL;
2199: END IF;
2200:
2201: -- Standard call to get message count and if count is 1, get message info.
2202: FND_MSG_PUB.Count_And_Get
2203: ( p_count => x_msg_count,
2204: p_data => x_msg_data
2205: );
2206:
2221:
2222: -- Initialize message list if p_init_msg_list is set to TRUE.
2223: IF FND_API.to_Boolean( p_init_msg_list )
2224: THEN
2225: FND_MSG_PUB.initialize;
2226: END IF;
2227:
2228:
2229: -- Initialize API return status to SUCCESS
2245: NULL;
2246: END IF;
2247:
2248: -- Standard call to get message count and if count is 1, get message info.
2249: FND_MSG_PUB.Count_And_Get
2250: ( p_count => x_msg_count,
2251: p_data => x_msg_data
2252: );
2253:
2268:
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list )
2271: THEN
2272: FND_MSG_PUB.initialize;
2273: END IF;
2274:
2275:
2276: -- Initialize API return status to SUCCESS
2292: NULL;
2293: END IF;
2294:
2295: -- Standard call to get message count and if count is 1, get message info.
2296: FND_MSG_PUB.Count_And_Get
2297: ( p_count => x_msg_count,
2298: p_data => x_msg_data
2299: );
2300:
2315:
2316: -- Initialize message list if p_init_msg_list is set to TRUE.
2317: IF FND_API.to_Boolean( p_init_msg_list )
2318: THEN
2319: FND_MSG_PUB.initialize;
2320: END IF;
2321:
2322:
2323: -- Initialize API return status to SUCCESS
2339: NULL;
2340: END IF;
2341:
2342: -- Standard call to get message count and if count is 1, get message info.
2343: FND_MSG_PUB.Count_And_Get
2344: ( p_count => x_msg_count,
2345: p_data => x_msg_data
2346: );
2347:
2362:
2363: -- Initialize message list if p_init_msg_list is set to TRUE.
2364: IF FND_API.to_Boolean( p_init_msg_list )
2365: THEN
2366: FND_MSG_PUB.initialize;
2367: END IF;
2368:
2369:
2370: -- Initialize API return status to SUCCESS
2386: NULL;
2387: END IF;
2388:
2389: -- Standard call to get message count and if count is 1, get message info.
2390: FND_MSG_PUB.Count_And_Get
2391: ( p_count => x_msg_count,
2392: p_data => x_msg_data
2393: );
2394:
2409:
2410: -- Initialize message list if p_init_msg_list is set to TRUE.
2411: IF FND_API.to_Boolean( p_init_msg_list )
2412: THEN
2413: FND_MSG_PUB.initialize;
2414: END IF;
2415:
2416:
2417: -- Initialize API return status to SUCCESS
2433: NULL;
2434: END IF;
2435:
2436: -- Standard call to get message count and if count is 1, get message info.
2437: FND_MSG_PUB.Count_And_Get
2438: ( p_count => x_msg_count,
2439: p_data => x_msg_data
2440: );
2441:
2456:
2457: -- Initialize message list if p_init_msg_list is set to TRUE.
2458: IF FND_API.to_Boolean( p_init_msg_list )
2459: THEN
2460: FND_MSG_PUB.initialize;
2461: END IF;
2462:
2463:
2464: -- Initialize API return status to SUCCESS
2480: NULL;
2481: END IF;
2482:
2483: -- Standard call to get message count and if count is 1, get message info.
2484: FND_MSG_PUB.Count_And_Get
2485: ( p_count => x_msg_count,
2486: p_data => x_msg_data
2487: );
2488:
2503:
2504: -- Initialize message list if p_init_msg_list is set to TRUE.
2505: IF FND_API.to_Boolean( p_init_msg_list )
2506: THEN
2507: FND_MSG_PUB.initialize;
2508: END IF;
2509:
2510:
2511: -- Initialize API return status to SUCCESS
2527: NULL;
2528: END IF;
2529:
2530: -- Standard call to get message count and if count is 1, get message info.
2531: FND_MSG_PUB.Count_And_Get
2532: ( p_count => x_msg_count,
2533: p_data => x_msg_data
2534: );
2535:
2550:
2551: -- Initialize message list if p_init_msg_list is set to TRUE.
2552: IF FND_API.to_Boolean( p_init_msg_list )
2553: THEN
2554: FND_MSG_PUB.initialize;
2555: END IF;
2556:
2557:
2558: -- Initialize API return status to SUCCESS
2574: NULL;
2575: END IF;
2576:
2577: -- Standard call to get message count and if count is 1, get message info.
2578: FND_MSG_PUB.Count_And_Get
2579: ( p_count => x_msg_count,
2580: p_data => x_msg_data
2581: );
2582:
2597:
2598: -- Initialize message list if p_init_msg_list is set to TRUE.
2599: IF FND_API.to_Boolean( p_init_msg_list )
2600: THEN
2601: FND_MSG_PUB.initialize;
2602: END IF;
2603:
2604:
2605: -- Initialize API return status to SUCCESS
2621: NULL;
2622: END IF;
2623:
2624: -- Standard call to get message count and if count is 1, get message info.
2625: FND_MSG_PUB.Count_And_Get
2626: ( p_count => x_msg_count,
2627: p_data => x_msg_data
2628: );
2629:
2644:
2645: -- Initialize message list if p_init_msg_list is set to TRUE.
2646: IF FND_API.to_Boolean( p_init_msg_list )
2647: THEN
2648: FND_MSG_PUB.initialize;
2649: END IF;
2650:
2651:
2652: -- Initialize API return status to SUCCESS
2668: NULL;
2669: END IF;
2670:
2671: -- Standard call to get message count and if count is 1, get message info.
2672: FND_MSG_PUB.Count_And_Get
2673: ( p_count => x_msg_count,
2674: p_data => x_msg_data
2675: );
2676:
2691:
2692: -- Initialize message list if p_init_msg_list is set to TRUE.
2693: IF FND_API.to_Boolean( p_init_msg_list )
2694: THEN
2695: FND_MSG_PUB.initialize;
2696: END IF;
2697:
2698:
2699: -- Initialize API return status to SUCCESS
2715: NULL;
2716: END IF;
2717:
2718: -- Standard call to get message count and if count is 1, get message info.
2719: FND_MSG_PUB.Count_And_Get
2720: ( p_count => x_msg_count,
2721: p_data => x_msg_data
2722: );
2723:
2738:
2739: -- Initialize message list if p_init_msg_list is set to TRUE.
2740: IF FND_API.to_Boolean( p_init_msg_list )
2741: THEN
2742: FND_MSG_PUB.initialize;
2743: END IF;
2744:
2745:
2746: -- Initialize API return status to SUCCESS
2762: NULL;
2763: END IF;
2764:
2765: -- Standard call to get message count and if count is 1, get message info.
2766: FND_MSG_PUB.Count_And_Get
2767: ( p_count => x_msg_count,
2768: p_data => x_msg_data
2769: );
2770:
2785:
2786: -- Initialize message list if p_init_msg_list is set to TRUE.
2787: IF FND_API.to_Boolean( p_init_msg_list )
2788: THEN
2789: FND_MSG_PUB.initialize;
2790: END IF;
2791:
2792:
2793: -- Initialize API return status to SUCCESS
2809: NULL;
2810: END IF;
2811:
2812: -- Standard call to get message count and if count is 1, get message info.
2813: FND_MSG_PUB.Count_And_Get
2814: ( p_count => x_msg_count,
2815: p_data => x_msg_data
2816: );
2817:
2832:
2833: -- Initialize message list if p_init_msg_list is set to TRUE.
2834: IF FND_API.to_Boolean( p_init_msg_list )
2835: THEN
2836: FND_MSG_PUB.initialize;
2837: END IF;
2838:
2839:
2840: -- Initialize API return status to SUCCESS
2856: NULL;
2857: END IF;
2858:
2859: -- Standard call to get message count and if count is 1, get message info.
2860: FND_MSG_PUB.Count_And_Get
2861: ( p_count => x_msg_count,
2862: p_data => x_msg_data
2863: );
2864:
2879:
2880: -- Initialize message list if p_init_msg_list is set to TRUE.
2881: IF FND_API.to_Boolean( p_init_msg_list )
2882: THEN
2883: FND_MSG_PUB.initialize;
2884: END IF;
2885:
2886:
2887: -- Initialize API return status to SUCCESS
2903: NULL;
2904: END IF;
2905:
2906: -- Standard call to get message count and if count is 1, get message info.
2907: FND_MSG_PUB.Count_And_Get
2908: ( p_count => x_msg_count,
2909: p_data => x_msg_data
2910: );
2911:
2926:
2927: -- Initialize message list if p_init_msg_list is set to TRUE.
2928: IF FND_API.to_Boolean( p_init_msg_list )
2929: THEN
2930: FND_MSG_PUB.initialize;
2931: END IF;
2932:
2933:
2934: -- Initialize API return status to SUCCESS
2950: NULL;
2951: END IF;
2952:
2953: -- Standard call to get message count and if count is 1, get message info.
2954: FND_MSG_PUB.Count_And_Get
2955: ( p_count => x_msg_count,
2956: p_data => x_msg_data
2957: );
2958:
2973:
2974: -- Initialize message list if p_init_msg_list is set to TRUE.
2975: IF FND_API.to_Boolean( p_init_msg_list )
2976: THEN
2977: FND_MSG_PUB.initialize;
2978: END IF;
2979:
2980:
2981: -- Initialize API return status to SUCCESS
2997: NULL;
2998: END IF;
2999:
3000: -- Standard call to get message count and if count is 1, get message info.
3001: FND_MSG_PUB.Count_And_Get
3002: ( p_count => x_msg_count,
3003: p_data => x_msg_data
3004: );
3005:
3020:
3021: -- Initialize message list if p_init_msg_list is set to TRUE.
3022: IF FND_API.to_Boolean( p_init_msg_list )
3023: THEN
3024: FND_MSG_PUB.initialize;
3025: END IF;
3026:
3027:
3028: -- Initialize API return status to SUCCESS
3044: NULL;
3045: END IF;
3046:
3047: -- Standard call to get message count and if count is 1, get message info.
3048: FND_MSG_PUB.Count_And_Get
3049: ( p_count => x_msg_count,
3050: p_data => x_msg_data
3051: );
3052:
3067:
3068: -- Initialize message list if p_init_msg_list is set to TRUE.
3069: IF FND_API.to_Boolean( p_init_msg_list )
3070: THEN
3071: FND_MSG_PUB.initialize;
3072: END IF;
3073:
3074:
3075: -- Initialize API return status to SUCCESS
3091: NULL;
3092: END IF;
3093:
3094: -- Standard call to get message count and if count is 1, get message info.
3095: FND_MSG_PUB.Count_And_Get
3096: ( p_count => x_msg_count,
3097: p_data => x_msg_data
3098: );
3099:
3114:
3115: -- Initialize message list if p_init_msg_list is set to TRUE.
3116: IF FND_API.to_Boolean( p_init_msg_list )
3117: THEN
3118: FND_MSG_PUB.initialize;
3119: END IF;
3120:
3121:
3122: -- Initialize API return status to SUCCESS
3138: NULL;
3139: END IF;
3140:
3141: -- Standard call to get message count and if count is 1, get message info.
3142: FND_MSG_PUB.Count_And_Get
3143: ( p_count => x_msg_count,
3144: p_data => x_msg_data
3145: );
3146:
3161:
3162: -- Initialize message list if p_init_msg_list is set to TRUE.
3163: IF FND_API.to_Boolean( p_init_msg_list )
3164: THEN
3165: FND_MSG_PUB.initialize;
3166: END IF;
3167:
3168:
3169: -- Initialize API return status to SUCCESS
3185: NULL;
3186: END IF;
3187:
3188: -- Standard call to get message count and if count is 1, get message info.
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,
3191: p_data => x_msg_data
3192: );
3193:
3208:
3209: -- Initialize message list if p_init_msg_list is set to TRUE.
3210: IF FND_API.to_Boolean( p_init_msg_list )
3211: THEN
3212: FND_MSG_PUB.initialize;
3213: END IF;
3214:
3215:
3216: -- Initialize API return status to SUCCESS
3232: NULL;
3233: END IF;
3234:
3235: -- Standard call to get message count and if count is 1, get message info.
3236: FND_MSG_PUB.Count_And_Get
3237: ( p_count => x_msg_count,
3238: p_data => x_msg_data
3239: );
3240:
3255:
3256: -- Initialize message list if p_init_msg_list is set to TRUE.
3257: IF FND_API.to_Boolean( p_init_msg_list )
3258: THEN
3259: FND_MSG_PUB.initialize;
3260: END IF;
3261:
3262:
3263: -- Initialize API return status to SUCCESS
3279: NULL;
3280: END IF;
3281:
3282: -- Standard call to get message count and if count is 1, get message info.
3283: FND_MSG_PUB.Count_And_Get
3284: ( p_count => x_msg_count,
3285: p_data => x_msg_data
3286: );
3287:
3302:
3303: -- Initialize message list if p_init_msg_list is set to TRUE.
3304: IF FND_API.to_Boolean( p_init_msg_list )
3305: THEN
3306: FND_MSG_PUB.initialize;
3307: END IF;
3308:
3309:
3310: -- Initialize API return status to SUCCESS
3326: NULL;
3327: END IF;
3328:
3329: -- Standard call to get message count and if count is 1, get message info.
3330: FND_MSG_PUB.Count_And_Get
3331: ( p_count => x_msg_count,
3332: p_data => x_msg_data
3333: );
3334:
3352:
3353: -- Initialize message list if p_init_msg_list is set to TRUE.
3354: IF FND_API.to_Boolean( p_init_msg_list )
3355: THEN
3356: FND_MSG_PUB.initialize;
3357: END IF;
3358:
3359:
3360: -- Initialize API return status to SUCCESS
3407:
3408: END IF;
3409:
3410: -- Standard call to get message count and if count is 1, get message info.
3411: FND_MSG_PUB.Count_And_Get
3412: ( p_count => x_msg_count,
3413: p_data => x_msg_data
3414: );
3415:
3434:
3435: -- Initialize message list if p_init_msg_list is set to TRUE.
3436: IF FND_API.to_Boolean( p_init_msg_list )
3437: THEN
3438: FND_MSG_PUB.initialize;
3439: END IF;
3440:
3441:
3442: -- Initialize API return status to SUCCESS
3447: -- THEN
3448: -- x_return_status := FND_API.G_RET_STS_ERROR;
3449:
3450: -- Debug Message
3451: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3452:
3453: -- Standard call to get message count and if count is 1, get message info.
3454: FND_MSG_PUB.Count_And_Get
3455: ( p_count => x_msg_count,
3450: -- Debug Message
3451: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3452:
3453: -- Standard call to get message count and if count is 1, get message info.
3454: FND_MSG_PUB.Count_And_Get
3455: ( p_count => x_msg_count,
3456: p_data => x_msg_data
3457: );
3458:
3471: l_api_name CONSTANT VARCHAR2(30) := 'Validate_repair_history';
3472: BEGIN
3473:
3474: -- Debug Message
3475: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
3476:
3477:
3478: -- Initialize API return status to SUCCESS
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3958: END IF;
3959:
3960:
3961: -- Debug Message
3962: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
3963:
3964: END Validate_repair_history;
3965:
3966: /*