eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_REPAIR_HISTORY_PVT dependencies on JTF_PLSQL_API

Line 60: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');

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;

Line 118: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');

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

Line 129: p_validation_mode => JTF_PLSQL_API.G_CREATE,

125:
126: Validate_repair_history(
127: p_init_msg_list => FND_API.G_FALSE,
128: p_validation_level => p_validation_level,
129: p_validation_mode => JTF_PLSQL_API.G_CREATE,
130: P_REPH_Rec => P_REPH_Rec,
131: x_return_status => x_return_status,
132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data);

Line 149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');

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

Line 245: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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

Line 273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

269: END IF;
270: */
271: EXCEPTION
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

Line 277: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
281: -- RAISE;

Line 284: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

280: ,X_RETURN_STATUS => X_RETURN_STATUS);
281: -- RAISE;
282:
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

Line 288: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
292: -- RAISE;

Line 295: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

291: ,X_RETURN_STATUS => X_RETURN_STATUS);
292: -- RAISE;
293:
294: WHEN OTHERS THEN
295: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
296: P_API_NAME => L_API_NAME
297: ,P_PKG_NAME => G_PKG_NAME
298: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
299: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 298: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

294: WHEN OTHERS THEN
295: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
296: P_API_NAME => L_API_NAME
297: ,P_PKG_NAME => G_PKG_NAME
298: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
299: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
300: ,X_MSG_COUNT => X_MSG_COUNT
301: ,X_MSG_DATA => X_MSG_DATA
302: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 299: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

295: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
296: P_API_NAME => L_API_NAME
297: ,P_PKG_NAME => G_PKG_NAME
298: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
299: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
300: ,X_MSG_COUNT => X_MSG_COUNT
301: ,X_MSG_DATA => X_MSG_DATA
302: ,X_RETURN_STATUS => X_RETURN_STATUS);
303: -- RAISE;

Line 421: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');

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;

Line 462: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Open Cursor to Select');

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:

Line 541: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');

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:

Line 570: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repair_history');

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,

Line 576: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

572: -- Invoke validation procedures
573: Validate_repair_history(
574: p_init_msg_list => FND_API.G_FALSE,
575: p_validation_level => p_validation_level,
576: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
577: P_REPH_Rec => P_REPH_Rec,
578: x_return_status => x_return_status,
579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data);

Line 590: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');

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:

Line 672: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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

Line 701: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

697: END IF;
698: */
699: EXCEPTION
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

Line 705: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
709: -- RAISE;

Line 712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

708: ,X_RETURN_STATUS => X_RETURN_STATUS);
709: -- RAISE;
710:
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

Line 716: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
720: -- RAISE;

Line 723: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

719: ,X_RETURN_STATUS => X_RETURN_STATUS);
720: -- RAISE;
721:
722: WHEN OTHERS THEN
723: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
724: P_API_NAME => L_API_NAME
725: ,P_PKG_NAME => G_PKG_NAME
726: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
727: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 726: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

722: WHEN OTHERS THEN
723: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
724: P_API_NAME => L_API_NAME
725: ,P_PKG_NAME => G_PKG_NAME
726: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
727: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
728: ,X_MSG_COUNT => X_MSG_COUNT
729: ,X_MSG_DATA => X_MSG_DATA
730: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 727: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

723: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
724: P_API_NAME => L_API_NAME
725: ,P_PKG_NAME => G_PKG_NAME
726: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
727: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
728: ,X_MSG_COUNT => X_MSG_COUNT
729: ,X_MSG_DATA => X_MSG_DATA
730: ,X_RETURN_STATUS => X_RETURN_STATUS);
731: -- RAISE;

Line 774: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');

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;

Line 816: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');

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,

Line 834: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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

Line 863: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

859: END IF;
860: */
861: EXCEPTION
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

Line 867: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
871: -- RAISE;

Line 874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

870: ,X_RETURN_STATUS => X_RETURN_STATUS);
871: -- RAISE;
872:
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

Line 878: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
882: -- RAISE;

Line 885: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

881: ,X_RETURN_STATUS => X_RETURN_STATUS);
882: -- RAISE;
883:
884: WHEN OTHERS THEN
885: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
889: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 888: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

884: WHEN OTHERS THEN
885: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
889: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
890: ,X_MSG_COUNT => X_MSG_COUNT
891: ,X_MSG_DATA => X_MSG_DATA
892: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 889: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

885: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
889: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
890: ,X_MSG_COUNT => X_MSG_COUNT
891: ,X_MSG_DATA => X_MSG_DATA
892: ,X_RETURN_STATUS => X_RETURN_STATUS);
893: -- RAISE;

Line 905: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');

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

Line 964: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');

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(

Line 975: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');

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

Line 1034: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');

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,

Line 1046: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

1042: x_msg_data OUT NOCOPY VARCHAR2
1043: )
1044: IS
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:

Line 1049: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Begins');

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;

Line 1057: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');

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

Line 1059: JTF_PLSQL_API.Translate_OrderBy(

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
1062: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1063: ,p_order_by_tbl => l_util_order_by_tbl

Line 1076: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Ends');

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(

Line 1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');

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

Line 1100: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Ends');

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

Line 1109: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');

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,' ||

Line 1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');

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(

Line 1200: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Begins');

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.

Line 1286: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Ends');

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(

Line 1369: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');

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;

Line 1396: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generating Dsql');

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:

Line 1438: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Open and Parse Cursor');

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)

Line 1464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');

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

Line 1469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');

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

Line 1484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');

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 1482: THEN
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);

Line 1516: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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

Line 1527: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1523: );
1524:
1525: EXCEPTION
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

Line 1531: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
1535: -- RAISE;

Line 1538: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1534: ,X_RETURN_STATUS => X_RETURN_STATUS);
1535: -- RAISE;
1536:
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

Line 1542: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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);
1546: -- RAISE;

Line 1549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1545: ,X_RETURN_STATUS => X_RETURN_STATUS);
1546: -- RAISE;
1547:
1548: WHEN OTHERS THEN
1549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1550: P_API_NAME => L_API_NAME
1551: ,P_PKG_NAME => G_PKG_NAME
1552: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1552: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1548: WHEN OTHERS THEN
1549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1550: P_API_NAME => L_API_NAME
1551: ,P_PKG_NAME => G_PKG_NAME
1552: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1554: ,X_MSG_COUNT => X_MSG_COUNT
1555: ,X_MSG_DATA => X_MSG_DATA
1556: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1550: P_API_NAME => L_API_NAME
1551: ,P_PKG_NAME => G_PKG_NAME
1552: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1554: ,X_MSG_COUNT => X_MSG_COUNT
1555: ,X_MSG_DATA => X_MSG_DATA
1556: ,X_RETURN_STATUS => X_RETURN_STATUS);
1557: -- RAISE;

Line 1566: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1562: PROCEDURE Validate_REPAIR_HISTORY_ID (
1563: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1564: P_Validation_mode IN VARCHAR2,
1565: P_REPAIR_HISTORY_ID IN NUMBER,
1566: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1567: X_Return_Status OUT NOCOPY VARCHAR2,
1568: X_Msg_Count OUT NOCOPY NUMBER,
1569: X_Msg_Data OUT NOCOPY VARCHAR2
1570: )

Line 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)');

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)

Line 1591: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1592: THEN
1593: -- Hint: Validate data
1594: -- IF p_REPAIR_HISTORY_ID is not NULL and p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1595: -- verify if data is valid

Line 1598: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1594: -- IF p_REPAIR_HISTORY_ID is not NULL and p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1595: -- verify if data is valid
1596: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1597: NULL;
1598: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1599: THEN
1600: -- Hint: Validate data
1601: -- IF p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1602: -- verify if data is valid

Line 1620: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1616: PROCEDURE Validate_REQUEST_ID (
1617: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1618: P_Validation_mode IN VARCHAR2,
1619: P_REQUEST_ID IN NUMBER,
1620: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1621: X_Return_Status OUT NOCOPY VARCHAR2,
1622: X_Msg_Count OUT NOCOPY NUMBER,
1623: X_Msg_Data OUT NOCOPY VARCHAR2
1624: )

Line 1638: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1634:
1635: -- Initialize API return status to SUCCESS
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;
1637:
1638: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1639: THEN
1640: -- Hint: Validate data
1641: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1642: -- verify if data is valid

Line 1645: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1641: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
1642: -- verify if data is valid
1643: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1644: NULL;
1645: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1646: THEN
1647: -- Hint: Validate data
1648: -- IF p_REQUEST_ID <> G_MISS_CHAR
1649: -- verify if data is valid

Line 1667: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1663: PROCEDURE Validate_REPAIR_LINE_ID (
1664: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1665: P_Validation_mode IN VARCHAR2,
1666: P_REPAIR_LINE_ID IN NUMBER,
1667: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1668: X_Return_Status OUT NOCOPY VARCHAR2,
1669: X_Msg_Count OUT NOCOPY NUMBER,
1670: X_Msg_Data OUT NOCOPY VARCHAR2
1671: )

Line 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)');

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)

Line 1692: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1693: THEN
1694: -- Hint: Validate data
1695: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1696: -- verify if data is valid

Line 1699: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1695: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1696: -- verify if data is valid
1697: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1698: NULL;
1699: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1700: THEN
1701: -- Hint: Validate data
1702: -- IF p_REPAIR_LINE_ID <> G_MISS_CHAR
1703: -- verify if data is valid

Line 1721: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1717: PROCEDURE Validate_EVENT_CODE (
1718: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1719: P_Validation_mode IN VARCHAR2,
1720: P_EVENT_CODE IN VARCHAR2,
1721: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1722: X_Return_Status OUT NOCOPY VARCHAR2,
1723: X_Msg_Count OUT NOCOPY NUMBER,
1724: X_Msg_Data OUT NOCOPY VARCHAR2
1725: )

Line 1742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_CODE)');

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)

Line 1746: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1747: THEN
1748: -- Hint: Validate data
1749: -- IF p_EVENT_CODE is not NULL and p_EVENT_CODE <> G_MISS_CHAR
1750: -- verify if data is valid

Line 1753: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1749: -- IF p_EVENT_CODE is not NULL and p_EVENT_CODE <> G_MISS_CHAR
1750: -- verify if data is valid
1751: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1752: NULL;
1753: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1754: THEN
1755: -- Hint: Validate data
1756: -- IF p_EVENT_CODE <> G_MISS_CHAR
1757: -- verify if data is valid

Line 1777: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1773: PROCEDURE Validate_EVENT_meaning (
1774: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1775: P_Validation_mode IN VARCHAR2,
1776: P_EVENT_meaning IN VARCHAR2,
1777: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1778: X_Return_Status OUT NOCOPY VARCHAR2,
1779: X_Msg_Count OUT NOCOPY NUMBER,
1780: X_Msg_Data OUT NOCOPY VARCHAR2
1781: )

Line 1798: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_MEANING)');

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)

Line 1802: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1803: THEN
1804: -- Hint: Validate data
1805: -- IF p_EVENT_meaning is not NULL and p_EVENT_meaning <> G_MISS_CHAR
1806: -- verify if data is valid

Line 1809: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1805: -- IF p_EVENT_meaning is not NULL and p_EVENT_meaning <> G_MISS_CHAR
1806: -- verify if data is valid
1807: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1808: NULL;
1809: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1810: THEN
1811: -- Hint: Validate data
1812: -- IF p_EVENT_meaning <> G_MISS_CHAR
1813: -- verify if data is valid

Line 1831: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1827: PROCEDURE Validate_EVENT_DATE (
1828: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1829: P_Validation_mode IN VARCHAR2,
1830: P_EVENT_DATE IN DATE,
1831: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1832: X_Return_Status OUT NOCOPY VARCHAR2,
1833: X_Msg_Count OUT NOCOPY NUMBER,
1834: X_Msg_Data OUT NOCOPY VARCHAR2
1835: )

Line 1852: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repair_history API: -Violate NOT NULL constraint(EVENT_DATE)');

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)

Line 1856: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1857: THEN
1858: -- Hint: Validate data
1859: -- IF p_EVENT_DATE is not NULL and p_EVENT_DATE <> G_MISS_CHAR
1860: -- verify if data is valid

Line 1863: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1859: -- IF p_EVENT_DATE is not NULL and p_EVENT_DATE <> G_MISS_CHAR
1860: -- verify if data is valid
1861: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1862: NULL;
1863: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1864: THEN
1865: -- Hint: Validate data
1866: -- IF p_EVENT_DATE <> G_MISS_CHAR
1867: -- verify if data is valid

Line 1885: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1881: PROCEDURE Validate_QUANTITY (
1882: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_mode IN VARCHAR2,
1884: P_QUANTITY IN NUMBER,
1885: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1886: X_Return_Status OUT NOCOPY VARCHAR2,
1887: X_Msg_Count OUT NOCOPY NUMBER,
1888: X_Msg_Data OUT NOCOPY VARCHAR2
1889: )

Line 1903: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1899:
1900: -- Initialize API return status to SUCCESS
1901: x_return_status := FND_API.G_RET_STS_SUCCESS;
1902:
1903: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1904: THEN
1905: -- Hint: Validate data
1906: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
1907: -- verify if data is valid

Line 1910: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1906: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
1907: -- verify if data is valid
1908: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1909: NULL;
1910: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1911: THEN
1912: -- Hint: Validate data
1913: -- IF p_QUANTITY <> G_MISS_CHAR
1914: -- verify if data is valid

Line 1932: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1928: PROCEDURE Validate_PARAMN1 (
1929: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1930: P_Validation_mode IN VARCHAR2,
1931: P_PARAMN1 IN NUMBER,
1932: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1933: X_Return_Status OUT NOCOPY VARCHAR2,
1934: X_Msg_Count OUT NOCOPY NUMBER,
1935: X_Msg_Data OUT NOCOPY VARCHAR2
1936: )

Line 1950: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1946:
1947: -- Initialize API return status to SUCCESS
1948: x_return_status := FND_API.G_RET_STS_SUCCESS;
1949:
1950: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1951: THEN
1952: -- Hint: Validate data
1953: -- IF p_PARAMN1 is not NULL and p_PARAMN1 <> G_MISS_CHAR
1954: -- verify if data is valid

Line 1957: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1953: -- IF p_PARAMN1 is not NULL and p_PARAMN1 <> G_MISS_CHAR
1954: -- verify if data is valid
1955: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1956: NULL;
1957: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1958: THEN
1959: -- Hint: Validate data
1960: -- IF p_PARAMN1 <> G_MISS_CHAR
1961: -- verify if data is valid

Line 1979: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

1975: PROCEDURE Validate_PARAMN2 (
1976: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1977: P_Validation_mode IN VARCHAR2,
1978: P_PARAMN2 IN NUMBER,
1979: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1981: X_Msg_Count OUT NOCOPY NUMBER,
1982: X_Msg_Data OUT NOCOPY VARCHAR2
1983: )

Line 1997: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1993:
1994: -- Initialize API return status to SUCCESS
1995: x_return_status := FND_API.G_RET_STS_SUCCESS;
1996:
1997: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1998: THEN
1999: -- Hint: Validate data
2000: -- IF p_PARAMN2 is not NULL and p_PARAMN2 <> G_MISS_CHAR
2001: -- verify if data is valid

Line 2004: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2000: -- IF p_PARAMN2 is not NULL and p_PARAMN2 <> G_MISS_CHAR
2001: -- verify if data is valid
2002: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2003: NULL;
2004: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2005: THEN
2006: -- Hint: Validate data
2007: -- IF p_PARAMN2 <> G_MISS_CHAR
2008: -- verify if data is valid

Line 2026: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2022: PROCEDURE Validate_PARAMN3 (
2023: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2024: P_Validation_mode IN VARCHAR2,
2025: P_PARAMN3 IN NUMBER,
2026: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2027: X_Return_Status OUT NOCOPY VARCHAR2,
2028: X_Msg_Count OUT NOCOPY NUMBER,
2029: X_Msg_Data OUT NOCOPY VARCHAR2
2030: )

Line 2044: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2040:
2041: -- Initialize API return status to SUCCESS
2042: x_return_status := FND_API.G_RET_STS_SUCCESS;
2043:
2044: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2045: THEN
2046: -- Hint: Validate data
2047: -- IF p_PARAMN3 is not NULL and p_PARAMN3 <> G_MISS_CHAR
2048: -- verify if data is valid

Line 2051: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2047: -- IF p_PARAMN3 is not NULL and p_PARAMN3 <> G_MISS_CHAR
2048: -- verify if data is valid
2049: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2050: NULL;
2051: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2052: THEN
2053: -- Hint: Validate data
2054: -- IF p_PARAMN3 <> G_MISS_CHAR
2055: -- verify if data is valid

Line 2073: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2069: PROCEDURE Validate_PARAMN4 (
2070: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2071: P_Validation_mode IN VARCHAR2,
2072: P_PARAMN4 IN NUMBER,
2073: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2074: X_Return_Status OUT NOCOPY VARCHAR2,
2075: X_Msg_Count OUT NOCOPY NUMBER,
2076: X_Msg_Data OUT NOCOPY VARCHAR2
2077: )

Line 2091: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2087:
2088: -- Initialize API return status to SUCCESS
2089: x_return_status := FND_API.G_RET_STS_SUCCESS;
2090:
2091: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2092: THEN
2093: -- Hint: Validate data
2094: -- IF p_PARAMN4 is not NULL and p_PARAMN4 <> G_MISS_CHAR
2095: -- verify if data is valid

Line 2098: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2094: -- IF p_PARAMN4 is not NULL and p_PARAMN4 <> G_MISS_CHAR
2095: -- verify if data is valid
2096: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2097: NULL;
2098: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2099: THEN
2100: -- Hint: Validate data
2101: -- IF p_PARAMN4 <> G_MISS_CHAR
2102: -- verify if data is valid

Line 2120: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2116: PROCEDURE Validate_PARAMN5 (
2117: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2118: P_Validation_mode IN VARCHAR2,
2119: P_PARAMN5 IN NUMBER,
2120: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2121: X_Return_Status OUT NOCOPY VARCHAR2,
2122: X_Msg_Count OUT NOCOPY NUMBER,
2123: X_Msg_Data OUT NOCOPY VARCHAR2
2124: )

Line 2138: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2134:
2135: -- Initialize API return status to SUCCESS
2136: x_return_status := FND_API.G_RET_STS_SUCCESS;
2137:
2138: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2139: THEN
2140: -- Hint: Validate data
2141: -- IF p_PARAMN5 is not NULL and p_PARAMN5 <> G_MISS_CHAR
2142: -- verify if data is valid

Line 2145: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2141: -- IF p_PARAMN5 is not NULL and p_PARAMN5 <> G_MISS_CHAR
2142: -- verify if data is valid
2143: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2144: NULL;
2145: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2146: THEN
2147: -- Hint: Validate data
2148: -- IF p_PARAMN5 <> G_MISS_CHAR
2149: -- verify if data is valid

Line 2167: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2163: PROCEDURE Validate_PARAMN6 (
2164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2165: P_Validation_mode IN VARCHAR2,
2166: P_PARAMN6 IN NUMBER,
2167: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2168: X_Return_Status OUT NOCOPY VARCHAR2,
2169: X_Msg_Count OUT NOCOPY NUMBER,
2170: X_Msg_Data OUT NOCOPY VARCHAR2
2171: )

Line 2185: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2181:
2182: -- Initialize API return status to SUCCESS
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184:
2185: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2186: THEN
2187: -- Hint: Validate data
2188: -- IF p_PARAMN6 is not NULL and p_PARAMN6 <> G_MISS_CHAR
2189: -- verify if data is valid

Line 2192: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2188: -- IF p_PARAMN6 is not NULL and p_PARAMN6 <> G_MISS_CHAR
2189: -- verify if data is valid
2190: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2191: NULL;
2192: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2193: THEN
2194: -- Hint: Validate data
2195: -- IF p_PARAMN6 <> G_MISS_CHAR
2196: -- verify if data is valid

Line 2214: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2210: PROCEDURE Validate_PARAMN7 (
2211: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2212: P_Validation_mode IN VARCHAR2,
2213: P_PARAMN7 IN NUMBER,
2214: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2215: X_Return_Status OUT NOCOPY VARCHAR2,
2216: X_Msg_Count OUT NOCOPY NUMBER,
2217: X_Msg_Data OUT NOCOPY VARCHAR2
2218: )

Line 2232: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2228:
2229: -- Initialize API return status to SUCCESS
2230: x_return_status := FND_API.G_RET_STS_SUCCESS;
2231:
2232: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2233: THEN
2234: -- Hint: Validate data
2235: -- IF p_PARAMN7 is not NULL and p_PARAMN7 <> G_MISS_CHAR
2236: -- verify if data is valid

Line 2239: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2235: -- IF p_PARAMN7 is not NULL and p_PARAMN7 <> G_MISS_CHAR
2236: -- verify if data is valid
2237: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2238: NULL;
2239: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2240: THEN
2241: -- Hint: Validate data
2242: -- IF p_PARAMN7 <> G_MISS_CHAR
2243: -- verify if data is valid

Line 2261: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2257: PROCEDURE Validate_PARAMN8 (
2258: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2259: P_Validation_mode IN VARCHAR2,
2260: P_PARAMN8 IN NUMBER,
2261: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2262: X_Return_Status OUT NOCOPY VARCHAR2,
2263: X_Msg_Count OUT NOCOPY NUMBER,
2264: X_Msg_Data OUT NOCOPY VARCHAR2
2265: )

Line 2279: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2275:
2276: -- Initialize API return status to SUCCESS
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278:
2279: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2280: THEN
2281: -- Hint: Validate data
2282: -- IF p_PARAMN8 is not NULL and p_PARAMN8 <> G_MISS_CHAR
2283: -- verify if data is valid

Line 2286: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2282: -- IF p_PARAMN8 is not NULL and p_PARAMN8 <> G_MISS_CHAR
2283: -- verify if data is valid
2284: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2285: NULL;
2286: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2287: THEN
2288: -- Hint: Validate data
2289: -- IF p_PARAMN8 <> G_MISS_CHAR
2290: -- verify if data is valid

Line 2308: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2304: PROCEDURE Validate_PARAMN9 (
2305: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2306: P_Validation_mode IN VARCHAR2,
2307: P_PARAMN9 IN NUMBER,
2308: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2309: X_Return_Status OUT NOCOPY VARCHAR2,
2310: X_Msg_Count OUT NOCOPY NUMBER,
2311: X_Msg_Data OUT NOCOPY VARCHAR2
2312: )

Line 2326: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2322:
2323: -- Initialize API return status to SUCCESS
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2327: THEN
2328: -- Hint: Validate data
2329: -- IF p_PARAMN9 is not NULL and p_PARAMN9 <> G_MISS_CHAR
2330: -- verify if data is valid

Line 2333: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2329: -- IF p_PARAMN9 is not NULL and p_PARAMN9 <> G_MISS_CHAR
2330: -- verify if data is valid
2331: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2332: NULL;
2333: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2334: THEN
2335: -- Hint: Validate data
2336: -- IF p_PARAMN9 <> G_MISS_CHAR
2337: -- verify if data is valid

Line 2355: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2351: PROCEDURE Validate_PARAMN10 (
2352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2353: P_Validation_mode IN VARCHAR2,
2354: P_PARAMN10 IN NUMBER,
2355: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2356: X_Return_Status OUT NOCOPY VARCHAR2,
2357: X_Msg_Count OUT NOCOPY NUMBER,
2358: X_Msg_Data OUT NOCOPY VARCHAR2
2359: )

Line 2373: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2369:
2370: -- Initialize API return status to SUCCESS
2371: x_return_status := FND_API.G_RET_STS_SUCCESS;
2372:
2373: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2374: THEN
2375: -- Hint: Validate data
2376: -- IF p_PARAMN10 is not NULL and p_PARAMN10 <> G_MISS_CHAR
2377: -- verify if data is valid

Line 2380: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2376: -- IF p_PARAMN10 is not NULL and p_PARAMN10 <> G_MISS_CHAR
2377: -- verify if data is valid
2378: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2379: NULL;
2380: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2381: THEN
2382: -- Hint: Validate data
2383: -- IF p_PARAMN10 <> G_MISS_CHAR
2384: -- verify if data is valid

Line 2402: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2398: PROCEDURE Validate_PARAMC1 (
2399: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2400: P_Validation_mode IN VARCHAR2,
2401: P_PARAMC1 IN VARCHAR2,
2402: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2403: X_Return_Status OUT NOCOPY VARCHAR2,
2404: X_Msg_Count OUT NOCOPY NUMBER,
2405: X_Msg_Data OUT NOCOPY VARCHAR2
2406: )

Line 2420: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2416:
2417: -- Initialize API return status to SUCCESS
2418: x_return_status := FND_API.G_RET_STS_SUCCESS;
2419:
2420: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2421: THEN
2422: -- Hint: Validate data
2423: -- IF p_PARAMC1 is not NULL and p_PARAMC1 <> G_MISS_CHAR
2424: -- verify if data is valid

Line 2427: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2423: -- IF p_PARAMC1 is not NULL and p_PARAMC1 <> G_MISS_CHAR
2424: -- verify if data is valid
2425: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2426: NULL;
2427: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2428: THEN
2429: -- Hint: Validate data
2430: -- IF p_PARAMC1 <> G_MISS_CHAR
2431: -- verify if data is valid

Line 2449: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2445: PROCEDURE Validate_PARAMC2 (
2446: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2447: P_Validation_mode IN VARCHAR2,
2448: P_PARAMC2 IN VARCHAR2,
2449: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2450: X_Return_Status OUT NOCOPY VARCHAR2,
2451: X_Msg_Count OUT NOCOPY NUMBER,
2452: X_Msg_Data OUT NOCOPY VARCHAR2
2453: )

Line 2467: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2463:
2464: -- Initialize API return status to SUCCESS
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2468: THEN
2469: -- Hint: Validate data
2470: -- IF p_PARAMC2 is not NULL and p_PARAMC2 <> G_MISS_CHAR
2471: -- verify if data is valid

Line 2474: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2470: -- IF p_PARAMC2 is not NULL and p_PARAMC2 <> G_MISS_CHAR
2471: -- verify if data is valid
2472: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2473: NULL;
2474: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2475: THEN
2476: -- Hint: Validate data
2477: -- IF p_PARAMC2 <> G_MISS_CHAR
2478: -- verify if data is valid

Line 2496: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2492: PROCEDURE Validate_PARAMC3 (
2493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2494: P_Validation_mode IN VARCHAR2,
2495: P_PARAMC3 IN VARCHAR2,
2496: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2497: X_Return_Status OUT NOCOPY VARCHAR2,
2498: X_Msg_Count OUT NOCOPY NUMBER,
2499: X_Msg_Data OUT NOCOPY VARCHAR2
2500: )

Line 2514: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2510:
2511: -- Initialize API return status to SUCCESS
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;
2513:
2514: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2515: THEN
2516: -- Hint: Validate data
2517: -- IF p_PARAMC3 is not NULL and p_PARAMC3 <> G_MISS_CHAR
2518: -- verify if data is valid

Line 2521: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2517: -- IF p_PARAMC3 is not NULL and p_PARAMC3 <> G_MISS_CHAR
2518: -- verify if data is valid
2519: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2520: NULL;
2521: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2522: THEN
2523: -- Hint: Validate data
2524: -- IF p_PARAMC3 <> G_MISS_CHAR
2525: -- verify if data is valid

Line 2543: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2539: PROCEDURE Validate_PARAMC4 (
2540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2541: P_Validation_mode IN VARCHAR2,
2542: P_PARAMC4 IN VARCHAR2,
2543: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2544: X_Return_Status OUT NOCOPY VARCHAR2,
2545: X_Msg_Count OUT NOCOPY NUMBER,
2546: X_Msg_Data OUT NOCOPY VARCHAR2
2547: )

Line 2561: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2557:
2558: -- Initialize API return status to SUCCESS
2559: x_return_status := FND_API.G_RET_STS_SUCCESS;
2560:
2561: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2562: THEN
2563: -- Hint: Validate data
2564: -- IF p_PARAMC4 is not NULL and p_PARAMC4 <> G_MISS_CHAR
2565: -- verify if data is valid

Line 2568: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2564: -- IF p_PARAMC4 is not NULL and p_PARAMC4 <> G_MISS_CHAR
2565: -- verify if data is valid
2566: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2567: NULL;
2568: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2569: THEN
2570: -- Hint: Validate data
2571: -- IF p_PARAMC4 <> G_MISS_CHAR
2572: -- verify if data is valid

Line 2590: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2586: PROCEDURE Validate_PARAMC5 (
2587: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2588: P_Validation_mode IN VARCHAR2,
2589: P_PARAMC5 IN VARCHAR2,
2590: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2591: X_Return_Status OUT NOCOPY VARCHAR2,
2592: X_Msg_Count OUT NOCOPY NUMBER,
2593: X_Msg_Data OUT NOCOPY VARCHAR2
2594: )

Line 2608: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2604:
2605: -- Initialize API return status to SUCCESS
2606: x_return_status := FND_API.G_RET_STS_SUCCESS;
2607:
2608: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2609: THEN
2610: -- Hint: Validate data
2611: -- IF p_PARAMC5 is not NULL and p_PARAMC5 <> G_MISS_CHAR
2612: -- verify if data is valid

Line 2615: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2611: -- IF p_PARAMC5 is not NULL and p_PARAMC5 <> G_MISS_CHAR
2612: -- verify if data is valid
2613: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2614: NULL;
2615: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2616: THEN
2617: -- Hint: Validate data
2618: -- IF p_PARAMC5 <> G_MISS_CHAR
2619: -- verify if data is valid

Line 2637: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2633: PROCEDURE Validate_PARAMC6 (
2634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2635: P_Validation_mode IN VARCHAR2,
2636: P_PARAMC6 IN VARCHAR2,
2637: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2638: X_Return_Status OUT NOCOPY VARCHAR2,
2639: X_Msg_Count OUT NOCOPY NUMBER,
2640: X_Msg_Data OUT NOCOPY VARCHAR2
2641: )

Line 2655: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2651:
2652: -- Initialize API return status to SUCCESS
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;
2654:
2655: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2656: THEN
2657: -- Hint: Validate data
2658: -- IF p_PARAMC6 is not NULL and p_PARAMC6 <> G_MISS_CHAR
2659: -- verify if data is valid

Line 2662: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2658: -- IF p_PARAMC6 is not NULL and p_PARAMC6 <> G_MISS_CHAR
2659: -- verify if data is valid
2660: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2661: NULL;
2662: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2663: THEN
2664: -- Hint: Validate data
2665: -- IF p_PARAMC6 <> G_MISS_CHAR
2666: -- verify if data is valid

Line 2684: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2680: PROCEDURE Validate_PARAMC7 (
2681: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2682: P_Validation_mode IN VARCHAR2,
2683: P_PARAMC7 IN VARCHAR2,
2684: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2685: X_Return_Status OUT NOCOPY VARCHAR2,
2686: X_Msg_Count OUT NOCOPY NUMBER,
2687: X_Msg_Data OUT NOCOPY VARCHAR2
2688: )

Line 2702: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2698:
2699: -- Initialize API return status to SUCCESS
2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701:
2702: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2703: THEN
2704: -- Hint: Validate data
2705: -- IF p_PARAMC7 is not NULL and p_PARAMC7 <> G_MISS_CHAR
2706: -- verify if data is valid

Line 2709: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2705: -- IF p_PARAMC7 is not NULL and p_PARAMC7 <> G_MISS_CHAR
2706: -- verify if data is valid
2707: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2708: NULL;
2709: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2710: THEN
2711: -- Hint: Validate data
2712: -- IF p_PARAMC7 <> G_MISS_CHAR
2713: -- verify if data is valid

Line 2731: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2727: PROCEDURE Validate_PARAMC8 (
2728: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2729: P_Validation_mode IN VARCHAR2,
2730: P_PARAMC8 IN VARCHAR2,
2731: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2732: X_Return_Status OUT NOCOPY VARCHAR2,
2733: X_Msg_Count OUT NOCOPY NUMBER,
2734: X_Msg_Data OUT NOCOPY VARCHAR2
2735: )

Line 2749: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2745:
2746: -- Initialize API return status to SUCCESS
2747: x_return_status := FND_API.G_RET_STS_SUCCESS;
2748:
2749: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2750: THEN
2751: -- Hint: Validate data
2752: -- IF p_PARAMC8 is not NULL and p_PARAMC8 <> G_MISS_CHAR
2753: -- verify if data is valid

Line 2756: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2752: -- IF p_PARAMC8 is not NULL and p_PARAMC8 <> G_MISS_CHAR
2753: -- verify if data is valid
2754: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2755: NULL;
2756: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2757: THEN
2758: -- Hint: Validate data
2759: -- IF p_PARAMC8 <> G_MISS_CHAR
2760: -- verify if data is valid

Line 2778: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2774: PROCEDURE Validate_PARAMC9 (
2775: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2776: P_Validation_mode IN VARCHAR2,
2777: P_PARAMC9 IN VARCHAR2,
2778: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2779: X_Return_Status OUT NOCOPY VARCHAR2,
2780: X_Msg_Count OUT NOCOPY NUMBER,
2781: X_Msg_Data OUT NOCOPY VARCHAR2
2782: )

Line 2796: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2792:
2793: -- Initialize API return status to SUCCESS
2794: x_return_status := FND_API.G_RET_STS_SUCCESS;
2795:
2796: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2797: THEN
2798: -- Hint: Validate data
2799: -- IF p_PARAMC9 is not NULL and p_PARAMC9 <> G_MISS_CHAR
2800: -- verify if data is valid

Line 2803: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2799: -- IF p_PARAMC9 is not NULL and p_PARAMC9 <> G_MISS_CHAR
2800: -- verify if data is valid
2801: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2802: NULL;
2803: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2804: THEN
2805: -- Hint: Validate data
2806: -- IF p_PARAMC9 <> G_MISS_CHAR
2807: -- verify if data is valid

Line 2825: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2821: PROCEDURE Validate_PARAMC10 (
2822: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2823: P_Validation_mode IN VARCHAR2,
2824: P_PARAMC10 IN VARCHAR2,
2825: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2826: X_Return_Status OUT NOCOPY VARCHAR2,
2827: X_Msg_Count OUT NOCOPY NUMBER,
2828: X_Msg_Data OUT NOCOPY VARCHAR2
2829: )

Line 2843: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2839:
2840: -- Initialize API return status to SUCCESS
2841: x_return_status := FND_API.G_RET_STS_SUCCESS;
2842:
2843: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2844: THEN
2845: -- Hint: Validate data
2846: -- IF p_PARAMC10 is not NULL and p_PARAMC10 <> G_MISS_CHAR
2847: -- verify if data is valid

Line 2850: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2846: -- IF p_PARAMC10 is not NULL and p_PARAMC10 <> G_MISS_CHAR
2847: -- verify if data is valid
2848: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2849: NULL;
2850: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2851: THEN
2852: -- Hint: Validate data
2853: -- IF p_PARAMC10 <> G_MISS_CHAR
2854: -- verify if data is valid

Line 2872: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2868: PROCEDURE Validate_PARAMD1 (
2869: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2870: P_Validation_mode IN VARCHAR2,
2871: P_PARAMD1 IN DATE,
2872: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2873: X_Return_Status OUT NOCOPY VARCHAR2,
2874: X_Msg_Count OUT NOCOPY NUMBER,
2875: X_Msg_Data OUT NOCOPY VARCHAR2
2876: )

Line 2890: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2886:
2887: -- Initialize API return status to SUCCESS
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889:
2890: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2891: THEN
2892: -- Hint: Validate data
2893: -- IF p_PARAMD1 is not NULL and p_PARAMD1 <> G_MISS_CHAR
2894: -- verify if data is valid

Line 2897: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2893: -- IF p_PARAMD1 is not NULL and p_PARAMD1 <> G_MISS_CHAR
2894: -- verify if data is valid
2895: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2896: NULL;
2897: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2898: THEN
2899: -- Hint: Validate data
2900: -- IF p_PARAMD1 <> G_MISS_CHAR
2901: -- verify if data is valid

Line 2919: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2915: PROCEDURE Validate_PARAMD2 (
2916: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2917: P_Validation_mode IN VARCHAR2,
2918: P_PARAMD2 IN DATE,
2919: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2920: X_Return_Status OUT NOCOPY VARCHAR2,
2921: X_Msg_Count OUT NOCOPY NUMBER,
2922: X_Msg_Data OUT NOCOPY VARCHAR2
2923: )

Line 2937: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2933:
2934: -- Initialize API return status to SUCCESS
2935: x_return_status := FND_API.G_RET_STS_SUCCESS;
2936:
2937: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2938: THEN
2939: -- Hint: Validate data
2940: -- IF p_PARAMD2 is not NULL and p_PARAMD2 <> G_MISS_CHAR
2941: -- verify if data is valid

Line 2944: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2940: -- IF p_PARAMD2 is not NULL and p_PARAMD2 <> G_MISS_CHAR
2941: -- verify if data is valid
2942: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2943: NULL;
2944: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2945: THEN
2946: -- Hint: Validate data
2947: -- IF p_PARAMD2 <> G_MISS_CHAR
2948: -- verify if data is valid

Line 2966: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

2962: PROCEDURE Validate_PARAMD3 (
2963: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2964: P_Validation_mode IN VARCHAR2,
2965: P_PARAMD3 IN DATE,
2966: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
2967: X_Return_Status OUT NOCOPY VARCHAR2,
2968: X_Msg_Count OUT NOCOPY NUMBER,
2969: X_Msg_Data OUT NOCOPY VARCHAR2
2970: )

Line 2984: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

2980:
2981: -- Initialize API return status to SUCCESS
2982: x_return_status := FND_API.G_RET_STS_SUCCESS;
2983:
2984: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
2985: THEN
2986: -- Hint: Validate data
2987: -- IF p_PARAMD3 is not NULL and p_PARAMD3 <> G_MISS_CHAR
2988: -- verify if data is valid

Line 2991: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

2987: -- IF p_PARAMD3 is not NULL and p_PARAMD3 <> G_MISS_CHAR
2988: -- verify if data is valid
2989: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2990: NULL;
2991: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
2992: THEN
2993: -- Hint: Validate data
2994: -- IF p_PARAMD3 <> G_MISS_CHAR
2995: -- verify if data is valid

Line 3013: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3009: PROCEDURE Validate_PARAMD4 (
3010: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3011: P_Validation_mode IN VARCHAR2,
3012: P_PARAMD4 IN DATE,
3013: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3014: X_Return_Status OUT NOCOPY VARCHAR2,
3015: X_Msg_Count OUT NOCOPY NUMBER,
3016: X_Msg_Data OUT NOCOPY VARCHAR2
3017: )

Line 3031: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3027:
3028: -- Initialize API return status to SUCCESS
3029: x_return_status := FND_API.G_RET_STS_SUCCESS;
3030:
3031: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3032: THEN
3033: -- Hint: Validate data
3034: -- IF p_PARAMD4 is not NULL and p_PARAMD4 <> G_MISS_CHAR
3035: -- verify if data is valid

Line 3038: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3034: -- IF p_PARAMD4 is not NULL and p_PARAMD4 <> G_MISS_CHAR
3035: -- verify if data is valid
3036: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3037: NULL;
3038: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3039: THEN
3040: -- Hint: Validate data
3041: -- IF p_PARAMD4 <> G_MISS_CHAR
3042: -- verify if data is valid

Line 3060: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3056: PROCEDURE Validate_PARAMD5 (
3057: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3058: P_Validation_mode IN VARCHAR2,
3059: P_PARAMD5 IN DATE,
3060: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3061: X_Return_Status OUT NOCOPY VARCHAR2,
3062: X_Msg_Count OUT NOCOPY NUMBER,
3063: X_Msg_Data OUT NOCOPY VARCHAR2
3064: )

Line 3078: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3074:
3075: -- Initialize API return status to SUCCESS
3076: x_return_status := FND_API.G_RET_STS_SUCCESS;
3077:
3078: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3079: THEN
3080: -- Hint: Validate data
3081: -- IF p_PARAMD5 is not NULL and p_PARAMD5 <> G_MISS_CHAR
3082: -- verify if data is valid

Line 3085: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3081: -- IF p_PARAMD5 is not NULL and p_PARAMD5 <> G_MISS_CHAR
3082: -- verify if data is valid
3083: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3084: NULL;
3085: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3086: THEN
3087: -- Hint: Validate data
3088: -- IF p_PARAMD5 <> G_MISS_CHAR
3089: -- verify if data is valid

Line 3107: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3103: PROCEDURE Validate_PARAMD6 (
3104: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3105: P_Validation_mode IN VARCHAR2,
3106: P_PARAMD6 IN DATE,
3107: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3108: X_Return_Status OUT NOCOPY VARCHAR2,
3109: X_Msg_Count OUT NOCOPY NUMBER,
3110: X_Msg_Data OUT NOCOPY VARCHAR2
3111: )

Line 3125: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3121:
3122: -- Initialize API return status to SUCCESS
3123: x_return_status := FND_API.G_RET_STS_SUCCESS;
3124:
3125: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3126: THEN
3127: -- Hint: Validate data
3128: -- IF p_PARAMD6 is not NULL and p_PARAMD6 <> G_MISS_CHAR
3129: -- verify if data is valid

Line 3132: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3128: -- IF p_PARAMD6 is not NULL and p_PARAMD6 <> G_MISS_CHAR
3129: -- verify if data is valid
3130: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3131: NULL;
3132: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3133: THEN
3134: -- Hint: Validate data
3135: -- IF p_PARAMD6 <> G_MISS_CHAR
3136: -- verify if data is valid

Line 3154: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3150: PROCEDURE Validate_PARAMD7 (
3151: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3152: P_Validation_mode IN VARCHAR2,
3153: P_PARAMD7 IN DATE,
3154: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3155: X_Return_Status OUT NOCOPY VARCHAR2,
3156: X_Msg_Count OUT NOCOPY NUMBER,
3157: X_Msg_Data OUT NOCOPY VARCHAR2
3158: )

Line 3172: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3168:
3169: -- Initialize API return status to SUCCESS
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3173: THEN
3174: -- Hint: Validate data
3175: -- IF p_PARAMD7 is not NULL and p_PARAMD7 <> G_MISS_CHAR
3176: -- verify if data is valid

Line 3179: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3175: -- IF p_PARAMD7 is not NULL and p_PARAMD7 <> G_MISS_CHAR
3176: -- verify if data is valid
3177: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3178: NULL;
3179: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3180: THEN
3181: -- Hint: Validate data
3182: -- IF p_PARAMD7 <> G_MISS_CHAR
3183: -- verify if data is valid

Line 3201: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3197: PROCEDURE Validate_PARAMD8 (
3198: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3199: P_Validation_mode IN VARCHAR2,
3200: P_PARAMD8 IN DATE,
3201: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3202: X_Return_Status OUT NOCOPY VARCHAR2,
3203: X_Msg_Count OUT NOCOPY NUMBER,
3204: X_Msg_Data OUT NOCOPY VARCHAR2
3205: )

Line 3219: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3215:
3216: -- Initialize API return status to SUCCESS
3217: x_return_status := FND_API.G_RET_STS_SUCCESS;
3218:
3219: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3220: THEN
3221: -- Hint: Validate data
3222: -- IF p_PARAMD8 is not NULL and p_PARAMD8 <> G_MISS_CHAR
3223: -- verify if data is valid

Line 3226: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3222: -- IF p_PARAMD8 is not NULL and p_PARAMD8 <> G_MISS_CHAR
3223: -- verify if data is valid
3224: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3225: NULL;
3226: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3227: THEN
3228: -- Hint: Validate data
3229: -- IF p_PARAMD8 <> G_MISS_CHAR
3230: -- verify if data is valid

Line 3248: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3244: PROCEDURE Validate_PARAMD9 (
3245: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3246: P_Validation_mode IN VARCHAR2,
3247: P_PARAMD9 IN DATE,
3248: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3249: X_Return_Status OUT NOCOPY VARCHAR2,
3250: X_Msg_Count OUT NOCOPY NUMBER,
3251: X_Msg_Data OUT NOCOPY VARCHAR2
3252: )

Line 3266: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3262:
3263: -- Initialize API return status to SUCCESS
3264: x_return_status := FND_API.G_RET_STS_SUCCESS;
3265:
3266: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3267: THEN
3268: -- Hint: Validate data
3269: -- IF p_PARAMD9 is not NULL and p_PARAMD9 <> G_MISS_CHAR
3270: -- verify if data is valid

Line 3273: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3269: -- IF p_PARAMD9 is not NULL and p_PARAMD9 <> G_MISS_CHAR
3270: -- verify if data is valid
3271: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3272: NULL;
3273: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3274: THEN
3275: -- Hint: Validate data
3276: -- IF p_PARAMD9 <> G_MISS_CHAR
3277: -- verify if data is valid

Line 3295: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.

3291: PROCEDURE Validate_PARAMD10 (
3292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3293: P_Validation_mode IN VARCHAR2,
3294: P_PARAMD10 IN DATE,
3295: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
3296: X_Return_Status OUT NOCOPY VARCHAR2,
3297: X_Msg_Count OUT NOCOPY NUMBER,
3298: X_Msg_Data OUT NOCOPY VARCHAR2
3299: )

Line 3313: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3309:
3310: -- Initialize API return status to SUCCESS
3311: x_return_status := FND_API.G_RET_STS_SUCCESS;
3312:
3313: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3314: THEN
3315: -- Hint: Validate data
3316: -- IF p_PARAMD10 is not NULL and p_PARAMD10 <> G_MISS_CHAR
3317: -- verify if data is valid

Line 3320: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3316: -- IF p_PARAMD10 is not NULL and p_PARAMD10 <> G_MISS_CHAR
3317: -- verify if data is valid
3318: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3319: NULL;
3320: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3321: THEN
3322: -- Hint: Validate data
3323: -- IF p_PARAMD10 <> G_MISS_CHAR
3324: -- verify if data is valid

Line 3363: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

3359:
3360: -- Initialize API return status to SUCCESS
3361: x_return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
3364: THEN
3365: IF (g_debug > 0 ) THEN
3366: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in create we get null ovn');
3367: END IF;

Line 3374: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

3370: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER ovn '||to_char(p_OBJECT_VERSION_NUMBER));
3371: END IF;
3372:
3373:
3374: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
3375: THEN
3376:
3377: IF (g_debug > 0 ) THEN
3378: csd_gen_utility_pvt.add('CSD_REPAIR_HISTORY_PVT.Validate_OBJECT_VERSION_NUMBER in update');

Line 3421: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor

3417:
3418:
3419:
3420: -- Hint: inter-field level validation can be added here.
3421: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
3422: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
3423: -- stored in database table.
3424: PROCEDURE Validate_REPH_rec(
3425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 3451: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');

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,

Line 3475: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');

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;

Line 3481: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN

3477:
3478: -- Initialize API return status to SUCCESS
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3480:
3481: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
3482: -- Hint: We provide validation procedure for every column. Developer should delete
3483: -- unnecessary validation procedures.
3484: Validate_REPAIR_HISTORY_ID(
3485: p_init_msg_list => FND_API.G_FALSE,

Line 3934: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN

3930: END IF;
3931:
3932: END IF;
3933:
3934: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
3935: -- Hint: Inter-field level validation can be added here
3936: -- invoke record level validation procedures
3937: Validate_REPH_Rec(
3938: p_init_msg_list => FND_API.G_FALSE,

Line 3950: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN

3946: raise FND_API.G_EXC_ERROR;
3947: END IF;
3948: END IF;
3949:
3950: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
3951: -- invoke inter-record level validation procedures
3952: NULL;
3953: END IF;
3954:

Line 3955: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN

3951: -- invoke inter-record level validation procedures
3952: NULL;
3953: END IF;
3954:
3955: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
3956: -- invoke inter-entity level validation procedures
3957: NULL;
3958: END IF;
3959:

Line 3962: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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: /*