[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');
239: END IF;
240:
241:
242: -- Debug Message
243: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
244:
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
243: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
244:
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251:
270: WHEN FND_API.G_EXC_ERROR THEN
271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
275: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
276: ,X_MSG_COUNT => X_MSG_COUNT
277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
286: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
287: ,X_MSG_COUNT => X_MSG_COUNT
288: ,X_MSG_DATA => X_MSG_DATA
289: ,X_RETURN_STATUS => X_RETURN_STATUS);
410:
411: -- Initialize message list if p_init_msg_list is set to TRUE.
412: IF FND_API.to_Boolean( p_init_msg_list )
413: THEN
414: FND_MSG_PUB.initialize;
415: END IF;
416:
417:
418: -- Debug Message
415: END IF;
416:
417:
418: -- Debug Message
419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
420:
421:
422: -- Initialize API return status to SUCCESS
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458: */
459: -- Debug Message
460: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Open Cursor to Select');
461:
462: /*
463: Open C_Get_repair_history( l_tar_REPH_rec.REPAIR_HISTORY_ID);
464:
526: l_ref_REPH_rec.ATTRIBUTE15,
527: l_ref_REPH_rec.LAST_UPDATE_LOGIN;
528:
529: If ( C_Get_repair_history%NOTFOUND) Then
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
531: THEN
532: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
533: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
534: FND_MSG_PUB.Add;
530: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
531: THEN
532: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_UPDATE_TARGET');
533: FND_MESSAGE.Set_Token ('INFO', 'repair_history', FALSE);
534: FND_MSG_PUB.Add;
535: END IF;
536: raise FND_API.G_EXC_ERROR;
537: END IF;
538: -- Debug Message
535: END IF;
536: raise FND_API.G_EXC_ERROR;
537: END IF;
538: -- Debug Message
539: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');
540: Close C_Get_repair_history;
541: */
542:
543:
542:
543:
544: If (l_tar_REPH_rec.last_update_date is NULL or
545: l_tar_REPH_rec.last_update_date = FND_API.G_MISS_Date ) Then
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
549: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
550: FND_MSG_PUB.ADD;
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: FND_MESSAGE.Set_Name('CSD', 'API_MISSING_ID');
549: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
550: FND_MSG_PUB.ADD;
551: END IF;
552: raise FND_API.G_EXC_ERROR;
553: End if;
554: -- Check Whether record has been changed by someone else
552: raise FND_API.G_EXC_ERROR;
553: End if;
554: -- Check Whether record has been changed by someone else
555: If (l_tar_REPH_rec.last_update_date <> l_ref_REPH_rec.last_update_date) Then
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
559: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
560: FND_MSG_PUB.ADD;
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
557: THEN
558: FND_MESSAGE.Set_Name('CSD', 'API_RECORD_CHANGED');
559: FND_MESSAGE.Set_Token('INFO', 'repair_history', FALSE);
560: FND_MSG_PUB.ADD;
561: END IF;
562: raise FND_API.G_EXC_ERROR;
563: End if;
564:
564:
565: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
566: THEN
567: -- Debug message
568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');
569:
570: -- Invoke validation procedures
571: Validate_repair_history(
572: p_init_msg_list => FND_API.G_FALSE,
584:
585: -- Hint: Add corresponding Master-Detail business logic here if necessary.
586:
587: -- Debug Message
588: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');
589:
590: -- travi OBJECT_VERSION_NUMBER validation
591: l_OBJECT_VERSION_NUMBER := p_REPH_rec.OBJECT_VERSION_NUMBER + 1;
592:
664: END IF;
665:
666:
667: -- Debug Message
668: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
669:
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get
668: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
669:
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count,
674: p_data => x_msg_data
675: );
676:
696: WHEN FND_API.G_EXC_ERROR THEN
697: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
698: P_API_NAME => L_API_NAME
699: ,P_PKG_NAME => G_PKG_NAME
700: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
701: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
702: ,X_MSG_COUNT => X_MSG_COUNT
703: ,X_MSG_DATA => X_MSG_DATA
704: ,X_RETURN_STATUS => X_RETURN_STATUS);
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
709: P_API_NAME => L_API_NAME
710: ,P_PKG_NAME => G_PKG_NAME
711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
713: ,X_MSG_COUNT => X_MSG_COUNT
714: ,X_MSG_DATA => X_MSG_DATA
715: ,X_RETURN_STATUS => X_RETURN_STATUS);
761:
762: -- Initialize message list if p_init_msg_list is set to TRUE.
763: IF FND_API.to_Boolean( p_init_msg_list )
764: THEN
765: FND_MSG_PUB.initialize;
766: END IF;
767:
768:
769: -- Debug Message
766: END IF;
767:
768:
769: -- Debug Message
770: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
771:
772:
773: -- Initialize API return status to SUCCESS
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
808: END IF;
809: */
810:
811: -- Debug Message
812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
813:
814: -- Invoke table handler(CSD_REPAIR_HISTORY_PKG.Delete_Row)
815: CSD_REPAIR_HISTORY_PKG.Delete_Row(
816: p_REPAIR_HISTORY_ID => p_REPH_rec.REPAIR_HISTORY_ID,
826: END IF;
827:
828:
829: -- Debug Message
830: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
831:
832:
833: -- Standard call to get message count and if count is 1, get message info.
834: FND_MSG_PUB.Count_And_Get
830: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
831:
832:
833: -- Standard call to get message count and if count is 1, get message info.
834: FND_MSG_PUB.Count_And_Get
835: ( p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838:
858: WHEN FND_API.G_EXC_ERROR THEN
859: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
860: P_API_NAME => L_API_NAME
861: ,P_PKG_NAME => G_PKG_NAME
862: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
863: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
864: ,X_MSG_COUNT => X_MSG_COUNT
865: ,X_MSG_DATA => X_MSG_DATA
866: ,X_RETURN_STATUS => X_RETURN_STATUS);
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
871: P_API_NAME => L_API_NAME
872: ,P_PKG_NAME => G_PKG_NAME
873: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
874: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
875: ,X_MSG_COUNT => X_MSG_COUNT
876: ,X_MSG_DATA => X_MSG_DATA
877: ,X_RETURN_STATUS => X_RETURN_STATUS);
897: )
898: IS
899: BEGIN
900: -- Debug Message
901: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
902:
903: -- define all columns for CSD_REPAIR_HISTORY_V view
904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
958:
959: -- Debug Message
960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');
961: END Define_Columns;
962:
963: -- This procudure gets column values by the Dynamic SQL.
964: PROCEDURE Get_Column_Values(
967: )
968: IS
969: BEGIN
970: -- Debug Message
971: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
972:
973: -- get all column values for CSD_REPAIR_HISTORY_V table
974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1028:
1029: -- Debug Message
1030: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');
1031: END Get_Column_Values;
1032:
1033: PROCEDURE Gen_REPH_order_cl(
1034: p_order_by_rec IN CSD_REPAIR_HISTORY_PVT.REPH_sort_rec_type,
1041: l_order_by_cl VARCHAR2(1000) := NULL;
1042: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
1043: BEGIN
1044: -- Debug Message
1045: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Begins');
1046:
1047: -- Hint: Developer should add more statements according to CSD_sort_rec_type
1048: -- Ex:
1049: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1049: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
1050: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
1051:
1052: -- Debug Message
1053: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
1054:
1055: JTF_PLSQL_API.Translate_OrderBy(
1056: p_api_version_number => 1.0
1057: ,p_init_msg_list => FND_API.G_FALSE
1068: x_order_by_cl := NULL;
1069: END IF;
1070:
1071: -- Debug Message
1072: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Ends');
1073: END Gen_REPH_order_cl;
1074:
1075: -- This procedure bind the variables for the Dynamic SQL
1076: PROCEDURE Bind(
1082: BEGIN
1083: -- Bind variables
1084: -- Only those that are not NULL
1085: -- Debug Message
1086: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');
1087:
1088: -- The following example applies to all columns,
1089: -- developers can copy and paste them.
1090: IF( (P_REPH_Rec.REPAIR_HISTORY_ID IS NOT NULL) AND (P_REPH_Rec.REPAIR_HISTORY_ID <> FND_API.G_MISS_NUM) )
1092: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPH, ':p_REPAIR_HISTORY_ID', P_REPH_Rec.REPAIR_HISTORY_ID);
1093: END IF;
1094:
1095: -- Debug Message
1096: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Ends');
1097: END Bind;
1098:
1099: PROCEDURE Gen_Select(
1100: x_select_cl OUT NOCOPY VARCHAR2
1101: )
1102: IS
1103: BEGIN
1104: -- Debug Message
1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
1106:
1107: x_select_cl := 'Select ' ||
1108: 'CSD_REPAIR_HISTORY_V.REPAIR_HISTORY_ID,' ||
1109: 'CSD_REPAIR_HISTORY_V.REQUEST_ID,' ||
1168: 'CSD_REPAIR_HISTORY_V.ATTRIBUTE15,' ||
1169: 'CSD_REPAIR_HISTORY_V.OBJECT_VERSION_NUMBER' ||
1170: 'from CSD_REPAIR_HISTORY_V';
1171: -- Debug Message
1172: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
1173:
1174: END Gen_Select;
1175:
1176: PROCEDURE Gen_REPH_Where(
1192: str_csr2 NUMBER;
1193: l_operator VARCHAR2(10);
1194: BEGIN
1195: -- Debug Message
1196: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Begins');
1197:
1198: -- There are three examples for each kind of datatype:
1199: -- NUMBER, DATE, VARCHAR2.
1200: -- Developer can copy and paste the following codes for your own record.
1278:
1279: -- Add more IF statements for each column below
1280:
1281: -- Debug Message
1282: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Ends');
1283:
1284: END Gen_REPH_Where;
1285:
1286: PROCEDURE Get_repair_history(
1356:
1357: -- Initialize message list if p_init_msg_list is set to TRUE.
1358: IF FND_API.to_Boolean( p_init_msg_list )
1359: THEN
1360: FND_MSG_PUB.initialize;
1361: END IF;
1362:
1363:
1364: -- Debug Message
1361: END IF;
1362:
1363:
1364: -- Debug Message
1365: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1366:
1367:
1368: -- Initialize API return status to SUCCESS
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1388: -- Generate Dynamic SQL based on criteria passed in.
1389: -- Doing this for performance. Indexes are disabled when using NVL within static SQL statement.
1390: -- Ignore condition when criteria is NULL
1391: -- Debug Message
1392: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generating Dsql');
1393: -- Generate Select clause and From clause
1394: -- Hint: Developer should modify Gen_Select procedure.
1395: Gen_Select(l_select_cl);
1396:
1430: -- Generate order by clause
1431: Gen_REPH_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
1432:
1433: -- Debug Message
1434: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Open and Parse Cursor');
1435:
1436: l_cur_get_REPH := dbms_sql.open_cursor;
1437:
1438: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1456: Define_Columns(l_crit_REPH_rec, l_cur_get_REPH);
1457:
1458: -- Execute
1459: -- Debug Message
1460: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');
1461:
1462: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1463:
1464: -- Debug Message
1461:
1462: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1463:
1464: -- Debug Message
1465: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');
1466:
1467: -- This loop is here to avoid calling a function in the main
1468: -- cursor. Basically, calling this function seems to disable
1469: -- index, but verification is needed. This is a good
1476: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1477: OR (l_returned_rec_count
1479: -- Debug Message
1480: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1481:
1482: -- Hint: Developer need to implement this part
1483: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1484: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1508: -- End of API body
1509: --
1510:
1511: -- Debug Message
1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info.
1516: FND_MSG_PUB.Count_And_Get
1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info.
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data
1519: );
1520:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1528: ,X_MSG_COUNT => X_MSG_COUNT
1529: ,X_MSG_DATA => X_MSG_DATA
1530: ,X_RETURN_STATUS => X_RETURN_STATUS);
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1535: P_API_NAME => L_API_NAME
1536: ,P_PKG_NAME => G_PKG_NAME
1537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1539: ,X_MSG_COUNT => X_MSG_COUNT
1540: ,X_MSG_DATA => X_MSG_DATA
1541: ,X_RETURN_STATUS => X_RETURN_STATUS);
1569:
1570: -- Initialize message list if p_init_msg_list is set to TRUE.
1571: IF FND_API.to_Boolean( p_init_msg_list )
1572: THEN
1573: FND_MSG_PUB.initialize;
1574: END IF;
1575:
1576:
1577: -- Initialize API return status to SUCCESS
1579:
1580: -- validate NOT NULL column
1581: IF(p_REPAIR_HISTORY_ID is NULL)
1582: THEN
1583: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_HISTORY_ID)');
1584: x_return_status := FND_API.G_RET_STS_ERROR;
1585: END IF;
1586:
1587: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1600: NULL;
1601: END IF;
1602:
1603: -- Standard call to get message count and if count is 1, get message info.
1604: FND_MSG_PUB.Count_And_Get
1605: ( p_count => x_msg_count,
1606: p_data => x_msg_data
1607: );
1608:
1623:
1624: -- Initialize message list if p_init_msg_list is set to TRUE.
1625: IF FND_API.to_Boolean( p_init_msg_list )
1626: THEN
1627: FND_MSG_PUB.initialize;
1628: END IF;
1629:
1630:
1631: -- Initialize API return status to SUCCESS
1647: NULL;
1648: END IF;
1649:
1650: -- Standard call to get message count and if count is 1, get message info.
1651: FND_MSG_PUB.Count_And_Get
1652: ( p_count => x_msg_count,
1653: p_data => x_msg_data
1654: );
1655:
1670:
1671: -- Initialize message list if p_init_msg_list is set to TRUE.
1672: IF FND_API.to_Boolean( p_init_msg_list )
1673: THEN
1674: FND_MSG_PUB.initialize;
1675: END IF;
1676:
1677:
1678: -- Initialize API return status to SUCCESS
1680:
1681: -- validate NOT NULL column
1682: IF(p_REPAIR_LINE_ID is NULL)
1683: THEN
1684: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1685: x_return_status := FND_API.G_RET_STS_ERROR;
1686: END IF;
1687:
1688: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1701: NULL;
1702: END IF;
1703:
1704: -- Standard call to get message count and if count is 1, get message info.
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,
1707: p_data => x_msg_data
1708: );
1709:
1724:
1725: -- Initialize message list if p_init_msg_list is set to TRUE.
1726: IF FND_API.to_Boolean( p_init_msg_list )
1727: THEN
1728: FND_MSG_PUB.initialize;
1729: END IF;
1730:
1731:
1732: -- Initialize API return status to SUCCESS
1734:
1735: -- validate NOT NULL column
1736: IF(p_EVENT_CODE is NULL)
1737: THEN
1738: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_CODE)');
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: END IF;
1741:
1742: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1755: NULL;
1756: END IF;
1757:
1758: -- Standard call to get message count and if count is 1, get message info.
1759: FND_MSG_PUB.Count_And_Get
1760: ( p_count => x_msg_count,
1761: p_data => x_msg_data
1762: );
1763:
1780:
1781: -- Initialize message list if p_init_msg_list is set to TRUE.
1782: IF FND_API.to_Boolean( p_init_msg_list )
1783: THEN
1784: FND_MSG_PUB.initialize;
1785: END IF;
1786:
1787:
1788: -- Initialize API return status to SUCCESS
1790:
1791: -- validate NOT NULL column
1792: IF(p_EVENT_meaning is NULL)
1793: THEN
1794: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_MEANING)');
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: END IF;
1797:
1798: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1811: NULL;
1812: END IF;
1813:
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count,
1817: p_data => x_msg_data
1818: );
1819:
1834:
1835: -- Initialize message list if p_init_msg_list is set to TRUE.
1836: IF FND_API.to_Boolean( p_init_msg_list )
1837: THEN
1838: FND_MSG_PUB.initialize;
1839: END IF;
1840:
1841:
1842: -- Initialize API return status to SUCCESS
1844:
1845: -- validate NOT NULL column
1846: IF(p_EVENT_DATE is NULL)
1847: THEN
1848: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_DATE)');
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: END IF;
1851:
1852: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1865: NULL;
1866: END IF;
1867:
1868: -- Standard call to get message count and if count is 1, get message info.
1869: FND_MSG_PUB.Count_And_Get
1870: ( p_count => x_msg_count,
1871: p_data => x_msg_data
1872: );
1873:
1888:
1889: -- Initialize message list if p_init_msg_list is set to TRUE.
1890: IF FND_API.to_Boolean( p_init_msg_list )
1891: THEN
1892: FND_MSG_PUB.initialize;
1893: END IF;
1894:
1895:
1896: -- Initialize API return status to SUCCESS
1912: NULL;
1913: END IF;
1914:
1915: -- Standard call to get message count and if count is 1, get message info.
1916: FND_MSG_PUB.Count_And_Get
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data
1919: );
1920:
1935:
1936: -- Initialize message list if p_init_msg_list is set to TRUE.
1937: IF FND_API.to_Boolean( p_init_msg_list )
1938: THEN
1939: FND_MSG_PUB.initialize;
1940: END IF;
1941:
1942:
1943: -- Initialize API return status to SUCCESS
1959: NULL;
1960: END IF;
1961:
1962: -- Standard call to get message count and if count is 1, get message info.
1963: FND_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count,
1965: p_data => x_msg_data
1966: );
1967:
1982:
1983: -- Initialize message list if p_init_msg_list is set to TRUE.
1984: IF FND_API.to_Boolean( p_init_msg_list )
1985: THEN
1986: FND_MSG_PUB.initialize;
1987: END IF;
1988:
1989:
1990: -- Initialize API return status to SUCCESS
2006: NULL;
2007: END IF;
2008:
2009: -- Standard call to get message count and if count is 1, get message info.
2010: FND_MSG_PUB.Count_And_Get
2011: ( p_count => x_msg_count,
2012: p_data => x_msg_data
2013: );
2014:
2029:
2030: -- Initialize message list if p_init_msg_list is set to TRUE.
2031: IF FND_API.to_Boolean( p_init_msg_list )
2032: THEN
2033: FND_MSG_PUB.initialize;
2034: END IF;
2035:
2036:
2037: -- Initialize API return status to SUCCESS
2053: NULL;
2054: END IF;
2055:
2056: -- Standard call to get message count and if count is 1, get message info.
2057: FND_MSG_PUB.Count_And_Get
2058: ( p_count => x_msg_count,
2059: p_data => x_msg_data
2060: );
2061:
2076:
2077: -- Initialize message list if p_init_msg_list is set to TRUE.
2078: IF FND_API.to_Boolean( p_init_msg_list )
2079: THEN
2080: FND_MSG_PUB.initialize;
2081: END IF;
2082:
2083:
2084: -- Initialize API return status to SUCCESS
2100: NULL;
2101: END IF;
2102:
2103: -- Standard call to get message count and if count is 1, get message info.
2104: FND_MSG_PUB.Count_And_Get
2105: ( p_count => x_msg_count,
2106: p_data => x_msg_data
2107: );
2108:
2123:
2124: -- Initialize message list if p_init_msg_list is set to TRUE.
2125: IF FND_API.to_Boolean( p_init_msg_list )
2126: THEN
2127: FND_MSG_PUB.initialize;
2128: END IF;
2129:
2130:
2131: -- Initialize API return status to SUCCESS
2147: NULL;
2148: END IF;
2149:
2150: -- Standard call to get message count and if count is 1, get message info.
2151: FND_MSG_PUB.Count_And_Get
2152: ( p_count => x_msg_count,
2153: p_data => x_msg_data
2154: );
2155:
2170:
2171: -- Initialize message list if p_init_msg_list is set to TRUE.
2172: IF FND_API.to_Boolean( p_init_msg_list )
2173: THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177:
2178: -- Initialize API return status to SUCCESS
2194: NULL;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info.
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data
2201: );
2202:
2217:
2218: -- Initialize message list if p_init_msg_list is set to TRUE.
2219: IF FND_API.to_Boolean( p_init_msg_list )
2220: THEN
2221: FND_MSG_PUB.initialize;
2222: END IF;
2223:
2224:
2225: -- Initialize API return status to SUCCESS
2241: NULL;
2242: END IF;
2243:
2244: -- Standard call to get message count and if count is 1, get message info.
2245: FND_MSG_PUB.Count_And_Get
2246: ( p_count => x_msg_count,
2247: p_data => x_msg_data
2248: );
2249:
2264:
2265: -- Initialize message list if p_init_msg_list is set to TRUE.
2266: IF FND_API.to_Boolean( p_init_msg_list )
2267: THEN
2268: FND_MSG_PUB.initialize;
2269: END IF;
2270:
2271:
2272: -- Initialize API return status to SUCCESS
2288: NULL;
2289: END IF;
2290:
2291: -- Standard call to get message count and if count is 1, get message info.
2292: FND_MSG_PUB.Count_And_Get
2293: ( p_count => x_msg_count,
2294: p_data => x_msg_data
2295: );
2296:
2311:
2312: -- Initialize message list if p_init_msg_list is set to TRUE.
2313: IF FND_API.to_Boolean( p_init_msg_list )
2314: THEN
2315: FND_MSG_PUB.initialize;
2316: END IF;
2317:
2318:
2319: -- Initialize API return status to SUCCESS
2335: NULL;
2336: END IF;
2337:
2338: -- Standard call to get message count and if count is 1, get message info.
2339: FND_MSG_PUB.Count_And_Get
2340: ( p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );
2343:
2358:
2359: -- Initialize message list if p_init_msg_list is set to TRUE.
2360: IF FND_API.to_Boolean( p_init_msg_list )
2361: THEN
2362: FND_MSG_PUB.initialize;
2363: END IF;
2364:
2365:
2366: -- Initialize API return status to SUCCESS
2382: NULL;
2383: END IF;
2384:
2385: -- Standard call to get message count and if count is 1, get message info.
2386: FND_MSG_PUB.Count_And_Get
2387: ( p_count => x_msg_count,
2388: p_data => x_msg_data
2389: );
2390:
2405:
2406: -- Initialize message list if p_init_msg_list is set to TRUE.
2407: IF FND_API.to_Boolean( p_init_msg_list )
2408: THEN
2409: FND_MSG_PUB.initialize;
2410: END IF;
2411:
2412:
2413: -- Initialize API return status to SUCCESS
2429: NULL;
2430: END IF;
2431:
2432: -- Standard call to get message count and if count is 1, get message info.
2433: FND_MSG_PUB.Count_And_Get
2434: ( p_count => x_msg_count,
2435: p_data => x_msg_data
2436: );
2437:
2452:
2453: -- Initialize message list if p_init_msg_list is set to TRUE.
2454: IF FND_API.to_Boolean( p_init_msg_list )
2455: THEN
2456: FND_MSG_PUB.initialize;
2457: END IF;
2458:
2459:
2460: -- Initialize API return status to SUCCESS
2476: NULL;
2477: END IF;
2478:
2479: -- Standard call to get message count and if count is 1, get message info.
2480: FND_MSG_PUB.Count_And_Get
2481: ( p_count => x_msg_count,
2482: p_data => x_msg_data
2483: );
2484:
2499:
2500: -- Initialize message list if p_init_msg_list is set to TRUE.
2501: IF FND_API.to_Boolean( p_init_msg_list )
2502: THEN
2503: FND_MSG_PUB.initialize;
2504: END IF;
2505:
2506:
2507: -- Initialize API return status to SUCCESS
2523: NULL;
2524: END IF;
2525:
2526: -- Standard call to get message count and if count is 1, get message info.
2527: FND_MSG_PUB.Count_And_Get
2528: ( p_count => x_msg_count,
2529: p_data => x_msg_data
2530: );
2531:
2546:
2547: -- Initialize message list if p_init_msg_list is set to TRUE.
2548: IF FND_API.to_Boolean( p_init_msg_list )
2549: THEN
2550: FND_MSG_PUB.initialize;
2551: END IF;
2552:
2553:
2554: -- Initialize API return status to SUCCESS
2570: NULL;
2571: END IF;
2572:
2573: -- Standard call to get message count and if count is 1, get message info.
2574: FND_MSG_PUB.Count_And_Get
2575: ( p_count => x_msg_count,
2576: p_data => x_msg_data
2577: );
2578:
2593:
2594: -- Initialize message list if p_init_msg_list is set to TRUE.
2595: IF FND_API.to_Boolean( p_init_msg_list )
2596: THEN
2597: FND_MSG_PUB.initialize;
2598: END IF;
2599:
2600:
2601: -- Initialize API return status to SUCCESS
2617: NULL;
2618: END IF;
2619:
2620: -- Standard call to get message count and if count is 1, get message info.
2621: FND_MSG_PUB.Count_And_Get
2622: ( p_count => x_msg_count,
2623: p_data => x_msg_data
2624: );
2625:
2640:
2641: -- Initialize message list if p_init_msg_list is set to TRUE.
2642: IF FND_API.to_Boolean( p_init_msg_list )
2643: THEN
2644: FND_MSG_PUB.initialize;
2645: END IF;
2646:
2647:
2648: -- Initialize API return status to SUCCESS
2664: NULL;
2665: END IF;
2666:
2667: -- Standard call to get message count and if count is 1, get message info.
2668: FND_MSG_PUB.Count_And_Get
2669: ( p_count => x_msg_count,
2670: p_data => x_msg_data
2671: );
2672:
2687:
2688: -- Initialize message list if p_init_msg_list is set to TRUE.
2689: IF FND_API.to_Boolean( p_init_msg_list )
2690: THEN
2691: FND_MSG_PUB.initialize;
2692: END IF;
2693:
2694:
2695: -- Initialize API return status to SUCCESS
2711: NULL;
2712: END IF;
2713:
2714: -- Standard call to get message count and if count is 1, get message info.
2715: FND_MSG_PUB.Count_And_Get
2716: ( p_count => x_msg_count,
2717: p_data => x_msg_data
2718: );
2719:
2734:
2735: -- Initialize message list if p_init_msg_list is set to TRUE.
2736: IF FND_API.to_Boolean( p_init_msg_list )
2737: THEN
2738: FND_MSG_PUB.initialize;
2739: END IF;
2740:
2741:
2742: -- Initialize API return status to SUCCESS
2758: NULL;
2759: END IF;
2760:
2761: -- Standard call to get message count and if count is 1, get message info.
2762: FND_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );
2766:
2781:
2782: -- Initialize message list if p_init_msg_list is set to TRUE.
2783: IF FND_API.to_Boolean( p_init_msg_list )
2784: THEN
2785: FND_MSG_PUB.initialize;
2786: END IF;
2787:
2788:
2789: -- Initialize API return status to SUCCESS
2805: NULL;
2806: END IF;
2807:
2808: -- Standard call to get message count and if count is 1, get message info.
2809: FND_MSG_PUB.Count_And_Get
2810: ( p_count => x_msg_count,
2811: p_data => x_msg_data
2812: );
2813:
2828:
2829: -- Initialize message list if p_init_msg_list is set to TRUE.
2830: IF FND_API.to_Boolean( p_init_msg_list )
2831: THEN
2832: FND_MSG_PUB.initialize;
2833: END IF;
2834:
2835:
2836: -- Initialize API return status to SUCCESS
2852: NULL;
2853: END IF;
2854:
2855: -- Standard call to get message count and if count is 1, get message info.
2856: FND_MSG_PUB.Count_And_Get
2857: ( p_count => x_msg_count,
2858: p_data => x_msg_data
2859: );
2860:
2875:
2876: -- Initialize message list if p_init_msg_list is set to TRUE.
2877: IF FND_API.to_Boolean( p_init_msg_list )
2878: THEN
2879: FND_MSG_PUB.initialize;
2880: END IF;
2881:
2882:
2883: -- Initialize API return status to SUCCESS
2899: NULL;
2900: END IF;
2901:
2902: -- Standard call to get message count and if count is 1, get message info.
2903: FND_MSG_PUB.Count_And_Get
2904: ( p_count => x_msg_count,
2905: p_data => x_msg_data
2906: );
2907:
2922:
2923: -- Initialize message list if p_init_msg_list is set to TRUE.
2924: IF FND_API.to_Boolean( p_init_msg_list )
2925: THEN
2926: FND_MSG_PUB.initialize;
2927: END IF;
2928:
2929:
2930: -- Initialize API return status to SUCCESS
2946: NULL;
2947: END IF;
2948:
2949: -- Standard call to get message count and if count is 1, get message info.
2950: FND_MSG_PUB.Count_And_Get
2951: ( p_count => x_msg_count,
2952: p_data => x_msg_data
2953: );
2954:
2969:
2970: -- Initialize message list if p_init_msg_list is set to TRUE.
2971: IF FND_API.to_Boolean( p_init_msg_list )
2972: THEN
2973: FND_MSG_PUB.initialize;
2974: END IF;
2975:
2976:
2977: -- Initialize API return status to SUCCESS
2993: NULL;
2994: END IF;
2995:
2996: -- Standard call to get message count and if count is 1, get message info.
2997: FND_MSG_PUB.Count_And_Get
2998: ( p_count => x_msg_count,
2999: p_data => x_msg_data
3000: );
3001:
3016:
3017: -- Initialize message list if p_init_msg_list is set to TRUE.
3018: IF FND_API.to_Boolean( p_init_msg_list )
3019: THEN
3020: FND_MSG_PUB.initialize;
3021: END IF;
3022:
3023:
3024: -- Initialize API return status to SUCCESS
3040: NULL;
3041: END IF;
3042:
3043: -- Standard call to get message count and if count is 1, get message info.
3044: FND_MSG_PUB.Count_And_Get
3045: ( p_count => x_msg_count,
3046: p_data => x_msg_data
3047: );
3048:
3063:
3064: -- Initialize message list if p_init_msg_list is set to TRUE.
3065: IF FND_API.to_Boolean( p_init_msg_list )
3066: THEN
3067: FND_MSG_PUB.initialize;
3068: END IF;
3069:
3070:
3071: -- Initialize API return status to SUCCESS
3087: NULL;
3088: END IF;
3089:
3090: -- Standard call to get message count and if count is 1, get message info.
3091: FND_MSG_PUB.Count_And_Get
3092: ( p_count => x_msg_count,
3093: p_data => x_msg_data
3094: );
3095:
3110:
3111: -- Initialize message list if p_init_msg_list is set to TRUE.
3112: IF FND_API.to_Boolean( p_init_msg_list )
3113: THEN
3114: FND_MSG_PUB.initialize;
3115: END IF;
3116:
3117:
3118: -- Initialize API return status to SUCCESS
3134: NULL;
3135: END IF;
3136:
3137: -- Standard call to get message count and if count is 1, get message info.
3138: FND_MSG_PUB.Count_And_Get
3139: ( p_count => x_msg_count,
3140: p_data => x_msg_data
3141: );
3142:
3157:
3158: -- Initialize message list if p_init_msg_list is set to TRUE.
3159: IF FND_API.to_Boolean( p_init_msg_list )
3160: THEN
3161: FND_MSG_PUB.initialize;
3162: END IF;
3163:
3164:
3165: -- Initialize API return status to SUCCESS
3181: NULL;
3182: END IF;
3183:
3184: -- Standard call to get message count and if count is 1, get message info.
3185: FND_MSG_PUB.Count_And_Get
3186: ( p_count => x_msg_count,
3187: p_data => x_msg_data
3188: );
3189:
3204:
3205: -- Initialize message list if p_init_msg_list is set to TRUE.
3206: IF FND_API.to_Boolean( p_init_msg_list )
3207: THEN
3208: FND_MSG_PUB.initialize;
3209: END IF;
3210:
3211:
3212: -- Initialize API return status to SUCCESS
3228: NULL;
3229: END IF;
3230:
3231: -- Standard call to get message count and if count is 1, get message info.
3232: FND_MSG_PUB.Count_And_Get
3233: ( p_count => x_msg_count,
3234: p_data => x_msg_data
3235: );
3236:
3251:
3252: -- Initialize message list if p_init_msg_list is set to TRUE.
3253: IF FND_API.to_Boolean( p_init_msg_list )
3254: THEN
3255: FND_MSG_PUB.initialize;
3256: END IF;
3257:
3258:
3259: -- Initialize API return status to SUCCESS
3275: NULL;
3276: END IF;
3277:
3278: -- Standard call to get message count and if count is 1, get message info.
3279: FND_MSG_PUB.Count_And_Get
3280: ( p_count => x_msg_count,
3281: p_data => x_msg_data
3282: );
3283:
3298:
3299: -- Initialize message list if p_init_msg_list is set to TRUE.
3300: IF FND_API.to_Boolean( p_init_msg_list )
3301: THEN
3302: FND_MSG_PUB.initialize;
3303: END IF;
3304:
3305:
3306: -- Initialize API return status to SUCCESS
3322: NULL;
3323: END IF;
3324:
3325: -- Standard call to get message count and if count is 1, get message info.
3326: FND_MSG_PUB.Count_And_Get
3327: ( p_count => x_msg_count,
3328: p_data => x_msg_data
3329: );
3330:
3348:
3349: -- Initialize message list if p_init_msg_list is set to TRUE.
3350: IF FND_API.to_Boolean( p_init_msg_list )
3351: THEN
3352: FND_MSG_PUB.initialize;
3353: END IF;
3354:
3355:
3356: -- Initialize API return status to SUCCESS
3403:
3404: END IF;
3405:
3406: -- Standard call to get message count and if count is 1, get message info.
3407: FND_MSG_PUB.Count_And_Get
3408: ( p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );
3411:
3430:
3431: -- Initialize message list if p_init_msg_list is set to TRUE.
3432: IF FND_API.to_Boolean( p_init_msg_list )
3433: THEN
3434: FND_MSG_PUB.initialize;
3435: END IF;
3436:
3437:
3438: -- Initialize API return status to SUCCESS
3443: -- THEN
3444: -- x_return_status := FND_API.G_RET_STS_ERROR;
3445:
3446: -- Debug Message
3447: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3448:
3449: -- Standard call to get message count and if count is 1, get message info.
3450: FND_MSG_PUB.Count_And_Get
3451: ( p_count => x_msg_count,
3446: -- Debug Message
3447: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3448:
3449: -- Standard call to get message count and if count is 1, get message info.
3450: FND_MSG_PUB.Count_And_Get
3451: ( p_count => x_msg_count,
3452: p_data => x_msg_data
3453: );
3454:
3467: l_api_name CONSTANT VARCHAR2(30) := 'Validate_repair_history';
3468: BEGIN
3469:
3470: -- Debug Message
3471: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
3472:
3473:
3474: -- Initialize API return status to SUCCESS
3475: x_return_status := FND_API.G_RET_STS_SUCCESS;
3954: END IF;
3955:
3956:
3957: -- Debug Message
3958: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
3959:
3960: END Validate_repair_history;
3961:
3962: End CSD_REPAIR_HISTORY_PVT;