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 243: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');

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

Line 271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 275: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 282: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 286: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 293: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 296: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 297: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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;

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

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:

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

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:

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

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,

Line 574: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

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

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

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:

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

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

Line 697: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

693: END IF;
694: */
695: EXCEPTION
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

Line 701: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

704: ,X_RETURN_STATUS => X_RETURN_STATUS);
705: -- RAISE;
706:
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

Line 712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 719: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

715: ,X_RETURN_STATUS => X_RETURN_STATUS);
716: -- RAISE;
717:
718: WHEN OTHERS THEN
719: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
720: P_API_NAME => L_API_NAME
721: ,P_PKG_NAME => G_PKG_NAME
722: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
723: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 722: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 723: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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;

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

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,

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

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

Line 859: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

855: END IF;
856: */
857: EXCEPTION
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

Line 863: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 870: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

866: ,X_RETURN_STATUS => X_RETURN_STATUS);
867: -- RAISE;
868:
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

Line 874: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 881: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

877: ,X_RETURN_STATUS => X_RETURN_STATUS);
878: -- RAISE;
879:
880: WHEN OTHERS THEN
881: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
882: P_API_NAME => L_API_NAME
883: ,P_PKG_NAME => G_PKG_NAME
884: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
885: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 884: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 885: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

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(

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

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

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

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,

Line 1042: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

1038: x_msg_data OUT NOCOPY VARCHAR2
1039: )
1040: IS
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:

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

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;

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

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

Line 1055: JTF_PLSQL_API.Translate_OrderBy(

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

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

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(

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

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

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

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

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

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

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

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(

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

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.

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

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(

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

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;

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

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:

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

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)

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

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

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

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

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

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

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

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

Line 1523: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1519: );
1520:
1521: EXCEPTION
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

Line 1527: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1534: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1530: ,X_RETURN_STATUS => X_RETURN_STATUS);
1531: -- RAISE;
1532:
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

Line 1538: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1545: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1541: ,X_RETURN_STATUS => X_RETURN_STATUS);
1542: -- RAISE;
1543:
1544: WHEN OTHERS THEN
1545: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1546: P_API_NAME => L_API_NAME
1547: ,P_PKG_NAME => G_PKG_NAME
1548: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1549: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1548: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 1549: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 1562: -- 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.

1558: PROCEDURE Validate_REPAIR_HISTORY_ID (
1559: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1560: P_Validation_mode IN VARCHAR2,
1561: P_REPAIR_HISTORY_ID IN NUMBER,
1562: -- 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.
1563: X_Return_Status OUT NOCOPY VARCHAR2,
1564: X_Msg_Count OUT NOCOPY NUMBER,
1565: X_Msg_Data OUT NOCOPY VARCHAR2
1566: )

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

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)

Line 1587: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1588: THEN
1589: -- Hint: Validate data
1590: -- IF p_REPAIR_HISTORY_ID is not NULL and p_REPAIR_HISTORY_ID <> G_MISS_CHAR
1591: -- verify if data is valid

Line 1594: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1616: -- 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.

1612: PROCEDURE Validate_REQUEST_ID (
1613: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1614: P_Validation_mode IN VARCHAR2,
1615: P_REQUEST_ID IN NUMBER,
1616: -- 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.
1617: X_Return_Status OUT NOCOPY VARCHAR2,
1618: X_Msg_Count OUT NOCOPY NUMBER,
1619: X_Msg_Data OUT NOCOPY VARCHAR2
1620: )

Line 1634: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1641: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1663: -- 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.

1659: PROCEDURE Validate_REPAIR_LINE_ID (
1660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1661: P_Validation_mode IN VARCHAR2,
1662: P_REPAIR_LINE_ID IN NUMBER,
1663: -- 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.
1664: X_Return_Status OUT NOCOPY VARCHAR2,
1665: X_Msg_Count OUT NOCOPY NUMBER,
1666: X_Msg_Data OUT NOCOPY VARCHAR2
1667: )

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

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)

Line 1688: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1689: THEN
1690: -- Hint: Validate data
1691: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1692: -- verify if data is valid

Line 1695: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1717: -- 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.

1713: PROCEDURE Validate_EVENT_CODE (
1714: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1715: P_Validation_mode IN VARCHAR2,
1716: P_EVENT_CODE IN VARCHAR2,
1717: -- 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.
1718: X_Return_Status OUT NOCOPY VARCHAR2,
1719: X_Msg_Count OUT NOCOPY NUMBER,
1720: X_Msg_Data OUT NOCOPY VARCHAR2
1721: )

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

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)

Line 1742: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1743: THEN
1744: -- Hint: Validate data
1745: -- IF p_EVENT_CODE is not NULL and p_EVENT_CODE <> G_MISS_CHAR
1746: -- verify if data is valid

Line 1749: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1773: -- 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.

1769: PROCEDURE Validate_EVENT_meaning (
1770: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1771: P_Validation_mode IN VARCHAR2,
1772: P_EVENT_meaning IN VARCHAR2,
1773: -- 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.
1774: X_Return_Status OUT NOCOPY VARCHAR2,
1775: X_Msg_Count OUT NOCOPY NUMBER,
1776: X_Msg_Data OUT NOCOPY VARCHAR2
1777: )

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

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)

Line 1798: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1799: THEN
1800: -- Hint: Validate data
1801: -- IF p_EVENT_meaning is not NULL and p_EVENT_meaning <> G_MISS_CHAR
1802: -- verify if data is valid

Line 1805: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1827: -- 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.

1823: PROCEDURE Validate_EVENT_DATE (
1824: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1825: P_Validation_mode IN VARCHAR2,
1826: P_EVENT_DATE IN DATE,
1827: -- 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.
1828: X_Return_Status OUT NOCOPY VARCHAR2,
1829: X_Msg_Count OUT NOCOPY NUMBER,
1830: X_Msg_Data OUT NOCOPY VARCHAR2
1831: )

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

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)

Line 1852: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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)
1853: THEN
1854: -- Hint: Validate data
1855: -- IF p_EVENT_DATE is not NULL and p_EVENT_DATE <> G_MISS_CHAR
1856: -- verify if data is valid

Line 1859: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1881: -- 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.

1877: PROCEDURE Validate_QUANTITY (
1878: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1879: P_Validation_mode IN VARCHAR2,
1880: P_QUANTITY IN NUMBER,
1881: -- 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.
1882: X_Return_Status OUT NOCOPY VARCHAR2,
1883: X_Msg_Count OUT NOCOPY NUMBER,
1884: X_Msg_Data OUT NOCOPY VARCHAR2
1885: )

Line 1899: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1906: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1928: -- 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.

1924: PROCEDURE Validate_PARAMN1 (
1925: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1926: P_Validation_mode IN VARCHAR2,
1927: P_PARAMN1 IN NUMBER,
1928: -- 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.
1929: X_Return_Status OUT NOCOPY VARCHAR2,
1930: X_Msg_Count OUT NOCOPY NUMBER,
1931: X_Msg_Data OUT NOCOPY VARCHAR2
1932: )

Line 1946: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1953: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 1975: -- 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.

1971: PROCEDURE Validate_PARAMN2 (
1972: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1973: P_Validation_mode IN VARCHAR2,
1974: P_PARAMN2 IN NUMBER,
1975: -- 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.
1976: X_Return_Status OUT NOCOPY VARCHAR2,
1977: X_Msg_Count OUT NOCOPY NUMBER,
1978: X_Msg_Data OUT NOCOPY VARCHAR2
1979: )

Line 1993: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2000: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2022: -- 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.

2018: PROCEDURE Validate_PARAMN3 (
2019: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2020: P_Validation_mode IN VARCHAR2,
2021: P_PARAMN3 IN NUMBER,
2022: -- 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.
2023: X_Return_Status OUT NOCOPY VARCHAR2,
2024: X_Msg_Count OUT NOCOPY NUMBER,
2025: X_Msg_Data OUT NOCOPY VARCHAR2
2026: )

Line 2040: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2047: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2069: -- 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.

2065: PROCEDURE Validate_PARAMN4 (
2066: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2067: P_Validation_mode IN VARCHAR2,
2068: P_PARAMN4 IN NUMBER,
2069: -- 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.
2070: X_Return_Status OUT NOCOPY VARCHAR2,
2071: X_Msg_Count OUT NOCOPY NUMBER,
2072: X_Msg_Data OUT NOCOPY VARCHAR2
2073: )

Line 2087: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2094: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2116: -- 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.

2112: PROCEDURE Validate_PARAMN5 (
2113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2114: P_Validation_mode IN VARCHAR2,
2115: P_PARAMN5 IN NUMBER,
2116: -- 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.
2117: X_Return_Status OUT NOCOPY VARCHAR2,
2118: X_Msg_Count OUT NOCOPY NUMBER,
2119: X_Msg_Data OUT NOCOPY VARCHAR2
2120: )

Line 2134: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2141: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2163: -- 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.

2159: PROCEDURE Validate_PARAMN6 (
2160: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2161: P_Validation_mode IN VARCHAR2,
2162: P_PARAMN6 IN NUMBER,
2163: -- 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.
2164: X_Return_Status OUT NOCOPY VARCHAR2,
2165: X_Msg_Count OUT NOCOPY NUMBER,
2166: X_Msg_Data OUT NOCOPY VARCHAR2
2167: )

Line 2181: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2188: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2210: -- 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.

2206: PROCEDURE Validate_PARAMN7 (
2207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2208: P_Validation_mode IN VARCHAR2,
2209: P_PARAMN7 IN NUMBER,
2210: -- 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.
2211: X_Return_Status OUT NOCOPY VARCHAR2,
2212: X_Msg_Count OUT NOCOPY NUMBER,
2213: X_Msg_Data OUT NOCOPY VARCHAR2
2214: )

Line 2228: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2235: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2257: -- 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.

2253: PROCEDURE Validate_PARAMN8 (
2254: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2255: P_Validation_mode IN VARCHAR2,
2256: P_PARAMN8 IN NUMBER,
2257: -- 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.
2258: X_Return_Status OUT NOCOPY VARCHAR2,
2259: X_Msg_Count OUT NOCOPY NUMBER,
2260: X_Msg_Data OUT NOCOPY VARCHAR2
2261: )

Line 2275: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2282: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2304: -- 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.

2300: PROCEDURE Validate_PARAMN9 (
2301: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2302: P_Validation_mode IN VARCHAR2,
2303: P_PARAMN9 IN NUMBER,
2304: -- 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.
2305: X_Return_Status OUT NOCOPY VARCHAR2,
2306: X_Msg_Count OUT NOCOPY NUMBER,
2307: X_Msg_Data OUT NOCOPY VARCHAR2
2308: )

Line 2322: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2329: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2351: -- 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.

2347: PROCEDURE Validate_PARAMN10 (
2348: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2349: P_Validation_mode IN VARCHAR2,
2350: P_PARAMN10 IN NUMBER,
2351: -- 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.
2352: X_Return_Status OUT NOCOPY VARCHAR2,
2353: X_Msg_Count OUT NOCOPY NUMBER,
2354: X_Msg_Data OUT NOCOPY VARCHAR2
2355: )

Line 2369: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2376: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2398: -- 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.

2394: PROCEDURE Validate_PARAMC1 (
2395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2396: P_Validation_mode IN VARCHAR2,
2397: P_PARAMC1 IN VARCHAR2,
2398: -- 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.
2399: X_Return_Status OUT NOCOPY VARCHAR2,
2400: X_Msg_Count OUT NOCOPY NUMBER,
2401: X_Msg_Data OUT NOCOPY VARCHAR2
2402: )

Line 2416: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2423: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2445: -- 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.

2441: PROCEDURE Validate_PARAMC2 (
2442: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2443: P_Validation_mode IN VARCHAR2,
2444: P_PARAMC2 IN VARCHAR2,
2445: -- 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.
2446: X_Return_Status OUT NOCOPY VARCHAR2,
2447: X_Msg_Count OUT NOCOPY NUMBER,
2448: X_Msg_Data OUT NOCOPY VARCHAR2
2449: )

Line 2463: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2470: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2492: -- 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.

2488: PROCEDURE Validate_PARAMC3 (
2489: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2490: P_Validation_mode IN VARCHAR2,
2491: P_PARAMC3 IN VARCHAR2,
2492: -- 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.
2493: X_Return_Status OUT NOCOPY VARCHAR2,
2494: X_Msg_Count OUT NOCOPY NUMBER,
2495: X_Msg_Data OUT NOCOPY VARCHAR2
2496: )

Line 2510: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2517: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2539: -- 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.

2535: PROCEDURE Validate_PARAMC4 (
2536: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2537: P_Validation_mode IN VARCHAR2,
2538: P_PARAMC4 IN VARCHAR2,
2539: -- 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.
2540: X_Return_Status OUT NOCOPY VARCHAR2,
2541: X_Msg_Count OUT NOCOPY NUMBER,
2542: X_Msg_Data OUT NOCOPY VARCHAR2
2543: )

Line 2557: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2564: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2586: -- 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.

2582: PROCEDURE Validate_PARAMC5 (
2583: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2584: P_Validation_mode IN VARCHAR2,
2585: P_PARAMC5 IN VARCHAR2,
2586: -- 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.
2587: X_Return_Status OUT NOCOPY VARCHAR2,
2588: X_Msg_Count OUT NOCOPY NUMBER,
2589: X_Msg_Data OUT NOCOPY VARCHAR2
2590: )

Line 2604: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2611: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2633: -- 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.

2629: PROCEDURE Validate_PARAMC6 (
2630: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2631: P_Validation_mode IN VARCHAR2,
2632: P_PARAMC6 IN VARCHAR2,
2633: -- 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.
2634: X_Return_Status OUT NOCOPY VARCHAR2,
2635: X_Msg_Count OUT NOCOPY NUMBER,
2636: X_Msg_Data OUT NOCOPY VARCHAR2
2637: )

Line 2651: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2658: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2680: -- 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.

2676: PROCEDURE Validate_PARAMC7 (
2677: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2678: P_Validation_mode IN VARCHAR2,
2679: P_PARAMC7 IN VARCHAR2,
2680: -- 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.
2681: X_Return_Status OUT NOCOPY VARCHAR2,
2682: X_Msg_Count OUT NOCOPY NUMBER,
2683: X_Msg_Data OUT NOCOPY VARCHAR2
2684: )

Line 2698: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2705: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2727: -- 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.

2723: PROCEDURE Validate_PARAMC8 (
2724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2725: P_Validation_mode IN VARCHAR2,
2726: P_PARAMC8 IN VARCHAR2,
2727: -- 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.
2728: X_Return_Status OUT NOCOPY VARCHAR2,
2729: X_Msg_Count OUT NOCOPY NUMBER,
2730: X_Msg_Data OUT NOCOPY VARCHAR2
2731: )

Line 2745: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2752: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2774: -- 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.

2770: PROCEDURE Validate_PARAMC9 (
2771: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2772: P_Validation_mode IN VARCHAR2,
2773: P_PARAMC9 IN VARCHAR2,
2774: -- 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.
2775: X_Return_Status OUT NOCOPY VARCHAR2,
2776: X_Msg_Count OUT NOCOPY NUMBER,
2777: X_Msg_Data OUT NOCOPY VARCHAR2
2778: )

Line 2792: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2799: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2821: -- 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.

2817: PROCEDURE Validate_PARAMC10 (
2818: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2819: P_Validation_mode IN VARCHAR2,
2820: P_PARAMC10 IN VARCHAR2,
2821: -- 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.
2822: X_Return_Status OUT NOCOPY VARCHAR2,
2823: X_Msg_Count OUT NOCOPY NUMBER,
2824: X_Msg_Data OUT NOCOPY VARCHAR2
2825: )

Line 2839: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2846: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2868: -- 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.

2864: PROCEDURE Validate_PARAMD1 (
2865: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2866: P_Validation_mode IN VARCHAR2,
2867: P_PARAMD1 IN DATE,
2868: -- 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.
2869: X_Return_Status OUT NOCOPY VARCHAR2,
2870: X_Msg_Count OUT NOCOPY NUMBER,
2871: X_Msg_Data OUT NOCOPY VARCHAR2
2872: )

Line 2886: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2893: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2915: -- 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.

2911: PROCEDURE Validate_PARAMD2 (
2912: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2913: P_Validation_mode IN VARCHAR2,
2914: P_PARAMD2 IN DATE,
2915: -- 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.
2916: X_Return_Status OUT NOCOPY VARCHAR2,
2917: X_Msg_Count OUT NOCOPY NUMBER,
2918: X_Msg_Data OUT NOCOPY VARCHAR2
2919: )

Line 2933: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2940: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 2962: -- 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.

2958: PROCEDURE Validate_PARAMD3 (
2959: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2960: P_Validation_mode IN VARCHAR2,
2961: P_PARAMD3 IN DATE,
2962: -- 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.
2963: X_Return_Status OUT NOCOPY VARCHAR2,
2964: X_Msg_Count OUT NOCOPY NUMBER,
2965: X_Msg_Data OUT NOCOPY VARCHAR2
2966: )

Line 2980: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 2987: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3009: -- 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.

3005: PROCEDURE Validate_PARAMD4 (
3006: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3007: P_Validation_mode IN VARCHAR2,
3008: P_PARAMD4 IN DATE,
3009: -- 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.
3010: X_Return_Status OUT NOCOPY VARCHAR2,
3011: X_Msg_Count OUT NOCOPY NUMBER,
3012: X_Msg_Data OUT NOCOPY VARCHAR2
3013: )

Line 3027: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3034: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3056: -- 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.

3052: PROCEDURE Validate_PARAMD5 (
3053: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3054: P_Validation_mode IN VARCHAR2,
3055: P_PARAMD5 IN DATE,
3056: -- 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.
3057: X_Return_Status OUT NOCOPY VARCHAR2,
3058: X_Msg_Count OUT NOCOPY NUMBER,
3059: X_Msg_Data OUT NOCOPY VARCHAR2
3060: )

Line 3074: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3081: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3103: -- 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.

3099: PROCEDURE Validate_PARAMD6 (
3100: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3101: P_Validation_mode IN VARCHAR2,
3102: P_PARAMD6 IN DATE,
3103: -- 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.
3104: X_Return_Status OUT NOCOPY VARCHAR2,
3105: X_Msg_Count OUT NOCOPY NUMBER,
3106: X_Msg_Data OUT NOCOPY VARCHAR2
3107: )

Line 3121: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3128: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3150: -- 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.

3146: PROCEDURE Validate_PARAMD7 (
3147: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3148: P_Validation_mode IN VARCHAR2,
3149: P_PARAMD7 IN DATE,
3150: -- 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.
3151: X_Return_Status OUT NOCOPY VARCHAR2,
3152: X_Msg_Count OUT NOCOPY NUMBER,
3153: X_Msg_Data OUT NOCOPY VARCHAR2
3154: )

Line 3168: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3175: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3197: -- 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.

3193: PROCEDURE Validate_PARAMD8 (
3194: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3195: P_Validation_mode IN VARCHAR2,
3196: P_PARAMD8 IN DATE,
3197: -- 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.
3198: X_Return_Status OUT NOCOPY VARCHAR2,
3199: X_Msg_Count OUT NOCOPY NUMBER,
3200: X_Msg_Data OUT NOCOPY VARCHAR2
3201: )

Line 3215: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3222: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3244: -- 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.

3240: PROCEDURE Validate_PARAMD9 (
3241: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3242: P_Validation_mode IN VARCHAR2,
3243: P_PARAMD9 IN DATE,
3244: -- 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.
3245: X_Return_Status OUT NOCOPY VARCHAR2,
3246: X_Msg_Count OUT NOCOPY NUMBER,
3247: X_Msg_Data OUT NOCOPY VARCHAR2
3248: )

Line 3262: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3269: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3291: -- 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.

3287: PROCEDURE Validate_PARAMD10 (
3288: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3289: P_Validation_mode IN VARCHAR2,
3290: P_PARAMD10 IN DATE,
3291: -- 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.
3292: X_Return_Status OUT NOCOPY VARCHAR2,
3293: X_Msg_Count OUT NOCOPY NUMBER,
3294: X_Msg_Data OUT NOCOPY VARCHAR2
3295: )

Line 3309: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3316: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

Line 3359: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 3370: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

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

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,

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

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;

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

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

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

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

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

3942: raise FND_API.G_EXC_ERROR;
3943: END IF;
3944: END IF;
3945:
3946: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
3947: -- invoke inter-record level validation procedures
3948: NULL;
3949: END IF;
3950:

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

3947: -- invoke inter-record level validation procedures
3948: NULL;
3949: END IF;
3950:
3951: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
3952: -- invoke inter-entity level validation procedures
3953: NULL;
3954: END IF;
3955:

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

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;