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_JOB_XREF_PVT dependencies on JTF_PLSQL_API

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

59: END IF;
60:
61:
62: -- Debug Message
63: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
64:
65:
66: -- Initialize API return status to SUCCESS
67: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');

118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
123:
124: -- Invoke validation procedures
125: Validate_repjobxref(
126: p_init_msg_list => FND_API.G_FALSE,

Line 128: p_validation_mode => JTF_PLSQL_API.G_CREATE,

124: -- Invoke validation procedures
125: Validate_repjobxref(
126: p_init_msg_list => FND_API.G_FALSE,
127: p_validation_level => p_validation_level,
128: p_validation_mode => JTF_PLSQL_API.G_CREATE,
129: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
130: x_return_status => x_return_status,
131: x_msg_count => x_msg_count,
132: x_msg_data => x_msg_data);

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

138:
139: -- Hint: Add corresponding Master-Detail business logic here if necessary.
140:
141: -- Debug Message
142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling create table handler');
143:
144: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Insert_Row)
145: CSD_REPAIR_JOB_XREF_PKG.Insert_Row(
146: px_REPAIR_JOB_XREF_ID => x_REPAIR_JOB_XREF_ID,

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

196: END IF;
197:
198:
199: -- Debug Message
200: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
201:
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get

Line 228: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

224: END IF;
225: */
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
229: P_API_NAME => L_API_NAME
230: ,P_PKG_NAME => G_PKG_NAME
231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
232: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 232: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

228: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
229: P_API_NAME => L_API_NAME
230: ,P_PKG_NAME => G_PKG_NAME
231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
232: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
233: ,X_MSG_COUNT => X_MSG_COUNT
234: ,X_MSG_DATA => X_MSG_DATA
235: ,X_RETURN_STATUS => X_RETURN_STATUS);
236: -- RAISE;

Line 239: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

235: ,X_RETURN_STATUS => X_RETURN_STATUS);
236: -- RAISE;
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
240: P_API_NAME => L_API_NAME
241: ,P_PKG_NAME => G_PKG_NAME
242: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
243: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 243: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

239: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
240: P_API_NAME => L_API_NAME
241: ,P_PKG_NAME => G_PKG_NAME
242: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
243: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
244: ,X_MSG_COUNT => X_MSG_COUNT
245: ,X_MSG_DATA => X_MSG_DATA
246: ,X_RETURN_STATUS => X_RETURN_STATUS);
247: -- RAISE;

Line 250: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

246: ,X_RETURN_STATUS => X_RETURN_STATUS);
247: -- RAISE;
248:
249: WHEN OTHERS THEN
250: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
251: P_API_NAME => L_API_NAME
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
254: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 253: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

249: WHEN OTHERS THEN
250: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
251: P_API_NAME => L_API_NAME
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
254: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
255: ,X_MSG_COUNT => X_MSG_COUNT
256: ,X_MSG_DATA => X_MSG_DATA
257: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 254: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

250: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
251: P_API_NAME => L_API_NAME
252: ,P_PKG_NAME => G_PKG_NAME
253: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
254: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
255: ,X_MSG_COUNT => X_MSG_COUNT
256: ,X_MSG_DATA => X_MSG_DATA
257: ,X_RETURN_STATUS => X_RETURN_STATUS);
258: -- RAISE;

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

339: END IF;
340:
341:
342: -- Debug Message
343: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
344:
345:
346: -- Initialize API return status to SUCCESS
347: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

381: END IF;
382: */
383:
384: -- Debug Message
385: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Open Cursor to Select');
386:
387: /*
388: Open C_Get_repjobxref( l_tar_REPJOBXREF_rec.REPAIR_JOB_XREF_ID);
389:

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

431: END IF;
432: raise FND_API.G_EXC_ERROR;
433: END IF;
434: -- Debug Message
435: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: - Close Cursor');
436: Close C_Get_repjobxref;
437: */
438:
439:

Line 464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');

460:
461: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
462: THEN
463: -- Debug message
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Validate_repjobxref');
465:
466: -- Invoke validation procedures
467: Validate_repjobxref(
468: p_init_msg_list => FND_API.G_FALSE,

Line 470: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

466: -- Invoke validation procedures
467: Validate_repjobxref(
468: p_init_msg_list => FND_API.G_FALSE,
469: p_validation_level => p_validation_level,
470: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
471: P_REPJOBXREF_Rec => P_REPJOBXREF_Rec,
472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);

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

480:
481: -- Hint: Add corresponding Master-Detail business logic here if necessary.
482:
483: -- Debug Message
484: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling update table handler');
485:
486: -- travi changes
487: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Update_Row)
488: CSD_REPAIR_JOB_XREF_PKG.Update_Row(

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

528: END IF;
529:
530:
531: -- Debug Message
532: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
533:
534:
535: -- Standard call to get message count and if count is 1, get message info.
536: FND_MSG_PUB.Count_And_Get

Line 561: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

557: END IF;
558: */
559: EXCEPTION
560: WHEN FND_API.G_EXC_ERROR THEN
561: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
562: P_API_NAME => L_API_NAME
563: ,P_PKG_NAME => G_PKG_NAME
564: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
565: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 565: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

561: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
562: P_API_NAME => L_API_NAME
563: ,P_PKG_NAME => G_PKG_NAME
564: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
565: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
566: ,X_MSG_COUNT => X_MSG_COUNT
567: ,X_MSG_DATA => X_MSG_DATA
568: ,X_RETURN_STATUS => X_RETURN_STATUS);
569: -- RAISE;

Line 572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

568: ,X_RETURN_STATUS => X_RETURN_STATUS);
569: -- RAISE;
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
573: P_API_NAME => L_API_NAME
574: ,P_PKG_NAME => G_PKG_NAME
575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

572: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
573: P_API_NAME => L_API_NAME
574: ,P_PKG_NAME => G_PKG_NAME
575: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
576: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
577: ,X_MSG_COUNT => X_MSG_COUNT
578: ,X_MSG_DATA => X_MSG_DATA
579: ,X_RETURN_STATUS => X_RETURN_STATUS);
580: -- RAISE;

Line 583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

579: ,X_RETURN_STATUS => X_RETURN_STATUS);
580: -- RAISE;
581:
582: WHEN OTHERS THEN
583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

582: WHEN OTHERS THEN
583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);
591: -- RAISE;

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

630: END IF;
631:
632:
633: -- Debug Message
634: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
635:
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674: */
675: -- Debug Message
676: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Calling delete table handler');
677:
678: -- Invoke table handler(CSD_REPAIR_JOB_XREF_PKG.Delete_Row)
679: CSD_REPAIR_JOB_XREF_PKG.Delete_Row(
680: p_REPAIR_JOB_XREF_ID => p_REPJOBXREF_rec.REPAIR_JOB_XREF_ID);

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

689: END IF;
690:
691:
692: -- Debug Message
693: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
694:
695:
696: -- Standard call to get message count and if count is 1, get message info.
697: FND_MSG_PUB.Count_And_Get

Line 722: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

718: END IF;
719: */
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
723: P_API_NAME => L_API_NAME
724: ,P_PKG_NAME => G_PKG_NAME
725: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
726: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 726: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 733: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

729: ,X_RETURN_STATUS => X_RETURN_STATUS);
730: -- RAISE;
731:
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
737: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 737: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

733: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
734: P_API_NAME => L_API_NAME
735: ,P_PKG_NAME => G_PKG_NAME
736: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
737: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
738: ,X_MSG_COUNT => X_MSG_COUNT
739: ,X_MSG_DATA => X_MSG_DATA
740: ,X_RETURN_STATUS => X_RETURN_STATUS);
741: -- RAISE;

Line 744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

740: ,X_RETURN_STATUS => X_RETURN_STATUS);
741: -- RAISE;
742:
743: WHEN OTHERS THEN
744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
745: P_API_NAME => L_API_NAME
746: ,P_PKG_NAME => G_PKG_NAME
747: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 747: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

743: WHEN OTHERS THEN
744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
745: P_API_NAME => L_API_NAME
746: ,P_PKG_NAME => G_PKG_NAME
747: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
749: ,X_MSG_COUNT => X_MSG_COUNT
750: ,X_MSG_DATA => X_MSG_DATA
751: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

744: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
745: P_API_NAME => L_API_NAME
746: ,P_PKG_NAME => G_PKG_NAME
747: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
748: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
749: ,X_MSG_COUNT => X_MSG_COUNT
750: ,X_MSG_DATA => X_MSG_DATA
751: ,X_RETURN_STATUS => X_RETURN_STATUS);
752: -- RAISE;

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

760: )
761: IS
762: BEGIN
763: -- Debug Message
764: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
765:
766: -- travi changes
767: -- define all columns for CSD_REPAIR_JOB_XREF_V view
768: dbms_sql.define_column(p_cur_get_REPJOBXREF, 1, P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);

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

793:
794: dbms_sql.define_column(p_cur_get_REPJOBXREF, 26, P_REPJOBXREF_Rec.QUANTITY_COMPLETED);
795:
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');
798: END Define_Columns;
799:
800: -- This procudure gets column values by the Dynamic SQL.
801: PROCEDURE Get_Column_Values(

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

804: )
805: IS
806: BEGIN
807: -- Debug Message
808: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
809:
810: -- travi changes
811: -- get all column values for CSD_REPAIR_JOB_XREF_V table
812: dbms_sql.column_value(p_cur_get_REPJOBXREF, 1, X_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);

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

837:
838: dbms_sql.column_value(p_cur_get_REPJOBXREF, 26, X_REPJOBXREF_Rec.QUANTITY_COMPLETED);
839:
840: -- Debug Message
841: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');
842: END Get_Column_Values;
843:
844: PROCEDURE Gen_REPJOBXREF_order_cl(
845: p_order_by_rec IN REPJOBXREF_sort_rec_type,

Line 853: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

849: x_msg_data OUT NOCOPY VARCHAR2
850: )
851: IS
852: l_order_by_cl VARCHAR2(1000) := NULL;
853: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
854: BEGIN
855: -- Debug Message
856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Begins');
857:

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

852: l_order_by_cl VARCHAR2(1000) := NULL;
853: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
854: BEGIN
855: -- Debug Message
856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Begins');
857:
858: -- Hint: Developer should add more statements according to CSD_sort_rec_type
859: -- Ex:
860: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

860: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
861: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
862:
863: -- Debug Message
864: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
865:
866: JTF_PLSQL_API.Translate_OrderBy(
867: p_api_version_number => 1.0
868: ,p_init_msg_list => FND_API.G_FALSE

Line 866: JTF_PLSQL_API.Translate_OrderBy(

862:
863: -- Debug Message
864: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
865:
866: JTF_PLSQL_API.Translate_OrderBy(
867: p_api_version_number => 1.0
868: ,p_init_msg_list => FND_API.G_FALSE
869: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
870: ,p_order_by_tbl => l_util_order_by_tbl

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

879: x_order_by_cl := NULL;
880: END IF;
881:
882: -- Debug Message
883: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Order by Ends');
884: END Gen_REPJOBXREF_order_cl;
885:
886: -- This procedure bind the variables for the Dynamic SQL
887: PROCEDURE Bind(

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

893: BEGIN
894: -- Bind variables
895: -- Only those that are not NULL
896: -- Debug Message
897: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Begins');
898:
899: -- The following example applies to all columns,
900: -- developers can copy and paste them.
901: IF( (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID IS NOT NULL) AND (P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID <> FND_API.G_MISS_NUM) )

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

903: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPJOBXREF, ':p_REPAIR_JOB_XREF_ID', P_REPJOBXREF_Rec.REPAIR_JOB_XREF_ID);
904: END IF;
905:
906: -- Debug Message
907: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Ends');
908: END Bind;
909:
910: PROCEDURE Gen_Select(
911: x_select_cl OUT NOCOPY VARCHAR2

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

912: )
913: IS
914: BEGIN
915: -- Debug Message
916: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Begins');
917:
918: -- travi changes
919: x_select_cl := 'Select ' ||
920: 'CSD_REPAIR_JOB_XREF_V.REPAIR_JOB_XREF_ID,' ||

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

949: 'CSD_REPAIR_JOB_XREF_V.ATTRIBUTE15,' ||
950: 'CSD_REPAIR_JOB_XREF_V.QUANTITY_COMPLETED,' ||
951: 'from CSD_REPAIR_JOB_XREF_V';
952: -- Debug Message
953: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Select Ends');
954:
955: END Gen_Select;
956:
957: PROCEDURE Gen_REPJOBXREF_Where(

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

973: str_csr2 NUMBER;
974: l_operator VARCHAR2(10);
975: BEGIN
976: -- Debug Message
977: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Begins');
978:
979: -- There are three examples for each kind of datatype:
980: -- NUMBER, DATE, VARCHAR2.
981: -- Developer can copy and paste the following codes for your own record.

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

1059:
1060: -- Add more IF statements for each column below
1061:
1062: -- Debug Message
1063: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generate Where Ends');
1064:
1065: END Gen_REPJOBXREF_Where;
1066:
1067: PROCEDURE Get_repjobxref(

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

1142: END IF;
1143:
1144:
1145: -- Debug Message
1146: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1147:
1148:
1149: -- Initialize API return status to SUCCESS
1150: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1169: -- Generate Dynamic SQL based on criteria passed in.
1170: -- Doing this for performance. Indexes are disabled when using NVL within static SQL statement.
1171: -- Ignore condition when criteria is NULL
1172: -- Debug Message
1173: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Generating Dsql');
1174: -- Generate Select clause and From clause
1175: -- Hint: Developer should modify Gen_Select procedure.
1176: Gen_Select(l_select_cl);
1177:

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

1212: -- Generate order by clause
1213: Gen_REPJOBXREF_order_cl(p_order_by_rec, l_order_by_cl, l_return_status, x_msg_count, x_msg_data);
1214:
1215: -- Debug Message
1216: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Open and Parse Cursor');
1217:
1218: l_cur_get_REPJOBXREF := dbms_sql.open_cursor;
1219:
1220: -- Hint: concatenate all where clause (include flex field/line level if any applies)

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

1238: Define_Columns(l_crit_REPJOBXREF_rec, l_cur_get_REPJOBXREF);
1239:
1240: -- Execute
1241: -- Debug Message
1242: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');
1243:
1244: l_ignore := dbms_sql.execute(l_cur_get_REPJOBXREF);
1245:
1246: -- Debug Message

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

1243:
1244: l_ignore := dbms_sql.execute(l_cur_get_REPJOBXREF);
1245:
1246: -- Debug Message
1247: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');
1248:
1249: -- This loop is here to avoid calling a function in the main
1250: -- cursor. Basically, calling this function seems to disable
1251: -- index, but verification is needed. This is a good

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

1258: IF((dbms_sql.fetch_rows(l_cur_get_REPJOBXREF)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1259: OR (l_returned_rec_count 1260: THEN
1261: -- Debug Message
1262: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1263:
1264: -- Hint: Developer need to implement this part
1265: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1266: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);

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

1290: -- End of API body
1291: --
1292:
1293: -- Debug Message
1294: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1295:
1296:
1297: -- Standard call to get message count and if count is 1, get message info.
1298: FND_MSG_PUB.Count_And_Get

Line 1305: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1301: );
1302:
1303: EXCEPTION
1304: WHEN FND_API.G_EXC_ERROR THEN
1305: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1306: P_API_NAME => L_API_NAME
1307: ,P_PKG_NAME => G_PKG_NAME
1308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1309: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1309: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1305: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1306: P_API_NAME => L_API_NAME
1307: ,P_PKG_NAME => G_PKG_NAME
1308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1309: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1310: ,X_MSG_COUNT => X_MSG_COUNT
1311: ,X_MSG_DATA => X_MSG_DATA
1312: ,X_RETURN_STATUS => X_RETURN_STATUS);
1313: -- RAISE;

Line 1316: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1312: ,X_RETURN_STATUS => X_RETURN_STATUS);
1313: -- RAISE;
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1317: P_API_NAME => L_API_NAME
1318: ,P_PKG_NAME => G_PKG_NAME
1319: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1320: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1320: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1316: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1317: P_API_NAME => L_API_NAME
1318: ,P_PKG_NAME => G_PKG_NAME
1319: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1320: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1321: ,X_MSG_COUNT => X_MSG_COUNT
1322: ,X_MSG_DATA => X_MSG_DATA
1323: ,X_RETURN_STATUS => X_RETURN_STATUS);
1324: -- RAISE;

Line 1327: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

1323: ,X_RETURN_STATUS => X_RETURN_STATUS);
1324: -- RAISE;
1325:
1326: WHEN OTHERS THEN
1327: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1328: P_API_NAME => L_API_NAME
1329: ,P_PKG_NAME => G_PKG_NAME
1330: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1331: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 1330: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

1326: WHEN OTHERS THEN
1327: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1328: P_API_NAME => L_API_NAME
1329: ,P_PKG_NAME => G_PKG_NAME
1330: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1331: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1332: ,X_MSG_COUNT => X_MSG_COUNT
1333: ,X_MSG_DATA => X_MSG_DATA
1334: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1331: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

1327: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1328: P_API_NAME => L_API_NAME
1329: ,P_PKG_NAME => G_PKG_NAME
1330: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
1331: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1332: ,X_MSG_COUNT => X_MSG_COUNT
1333: ,X_MSG_DATA => X_MSG_DATA
1334: ,X_RETURN_STATUS => X_RETURN_STATUS);
1335: -- RAISE;

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

1340: PROCEDURE Validate_REPAIR_JOB_XREF_ID (
1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342: P_Validation_mode IN VARCHAR2,
1343: P_REPAIR_JOB_XREF_ID IN NUMBER,
1344: -- 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.
1345: X_Return_Status OUT NOCOPY VARCHAR2,
1346: X_Msg_Count OUT NOCOPY NUMBER,
1347: X_Msg_Data OUT NOCOPY VARCHAR2
1348: )

Line 1365: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_JOB_XREF_ID)');

1361:
1362: -- validate NOT NULL column
1363: IF(p_REPAIR_JOB_XREF_ID is NULL)
1364: THEN
1365: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_JOB_XREF_ID)');
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:
1369: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1369: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1365: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_JOB_XREF_ID)');
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:
1369: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1370: THEN
1371: -- Hint: Validate data
1372: -- IF p_REPAIR_JOB_XREF_ID is not NULL and p_REPAIR_JOB_XREF_ID <> G_MISS_CHAR
1373: -- verify if data is valid

Line 1376: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1372: -- IF p_REPAIR_JOB_XREF_ID is not NULL and p_REPAIR_JOB_XREF_ID <> G_MISS_CHAR
1373: -- verify if data is valid
1374: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1375: NULL;
1376: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1377: THEN
1378: -- Hint: Validate data
1379: -- IF p_REPAIR_JOB_XREF_ID <> G_MISS_CHAR
1380: -- verify if data is valid

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

1394: PROCEDURE Validate_REPAIR_LINE_ID (
1395: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1396: P_Validation_mode IN VARCHAR2,
1397: P_REPAIR_LINE_ID IN NUMBER,
1398: -- 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.
1399: X_Return_Status OUT NOCOPY VARCHAR2,
1400: X_Msg_Count OUT NOCOPY NUMBER,
1401: X_Msg_Data OUT NOCOPY VARCHAR2
1402: )

Line 1419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');

1415:
1416: -- validate NOT NULL column
1417: IF(p_REPAIR_LINE_ID is NULL)
1418: THEN
1419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: END IF;
1422:
1423: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1423: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1419: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(REPAIR_LINE_ID)');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: END IF;
1422:
1423: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1424: THEN
1425: -- Hint: Validate data
1426: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1427: -- verify if data is valid

Line 1430: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1426: -- IF p_REPAIR_LINE_ID is not NULL and p_REPAIR_LINE_ID <> G_MISS_CHAR
1427: -- verify if data is valid
1428: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1429: NULL;
1430: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1431: THEN
1432: -- Hint: Validate data
1433: -- IF p_REPAIR_LINE_ID <> G_MISS_CHAR
1434: -- verify if data is valid

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

1448: PROCEDURE Validate_WIP_ENTITY_ID (
1449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1450: P_Validation_mode IN VARCHAR2,
1451: P_WIP_ENTITY_ID IN NUMBER,
1452: -- 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.
1453: X_Return_Status OUT NOCOPY VARCHAR2,
1454: X_Msg_Count OUT NOCOPY NUMBER,
1455: X_Msg_Data OUT NOCOPY VARCHAR2
1456: )

Line 1473: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(WIP_ENTITY_ID)');

1469:
1470: -- validate NOT NULL column
1471: IF(p_WIP_ENTITY_ID is NULL)
1472: THEN
1473: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(WIP_ENTITY_ID)');
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;
1476:
1477: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1477: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1473: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(WIP_ENTITY_ID)');
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END IF;
1476:
1477: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1478: THEN
1479: -- Hint: Validate data
1480: -- IF p_WIP_ENTITY_ID is not NULL and p_WIP_ENTITY_ID <> G_MISS_CHAR
1481: -- verify if data is valid

Line 1484: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1480: -- IF p_WIP_ENTITY_ID is not NULL and p_WIP_ENTITY_ID <> G_MISS_CHAR
1481: -- verify if data is valid
1482: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1483: NULL;
1484: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1485: THEN
1486: -- Hint: Validate data
1487: -- IF p_WIP_ENTITY_ID <> G_MISS_CHAR
1488: -- verify if data is valid

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

1502: PROCEDURE Validate_GROUP_ID (
1503: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1504: P_Validation_mode IN VARCHAR2,
1505: P_GROUP_ID IN NUMBER,
1506: -- 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.
1507: X_Return_Status OUT NOCOPY VARCHAR2,
1508: X_Msg_Count OUT NOCOPY NUMBER,
1509: X_Msg_Data OUT NOCOPY VARCHAR2
1510: )

Line 1527: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(GROUP_ID)');

1523:
1524: -- validate NOT NULL column
1525: IF(p_GROUP_ID is NULL)
1526: THEN
1527: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(GROUP_ID)');
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:
1531: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1531: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1527: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(GROUP_ID)');
1528: x_return_status := FND_API.G_RET_STS_ERROR;
1529: END IF;
1530:
1531: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1532: THEN
1533: -- Hint: Validate data
1534: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
1535: -- verify if data is valid

Line 1538: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1534: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
1535: -- verify if data is valid
1536: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1537: NULL;
1538: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1539: THEN
1540: -- Hint: Validate data
1541: -- IF p_GROUP_ID <> G_MISS_CHAR
1542: -- verify if data is valid

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

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

Line 1581: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(ORGANIZATION_ID)');

1577:
1578: -- validate NOT NULL column
1579: IF(p_ORGANIZATION_ID is NULL)
1580: THEN
1581: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: END IF;
1584:
1585: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1585: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1581: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: END IF;
1584:
1585: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1586: THEN
1587: -- Hint: Validate data
1588: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1589: -- verify if data is valid

Line 1592: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1635: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(QUANTITY)');

1631:
1632: -- validate NOT NULL column
1633: IF(p_QUANTITY is NULL)
1634: THEN
1635: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(QUANTITY)');
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: END IF;
1638:
1639: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1639: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1635: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSD', 'Private repjobxref API: -Violate NOT NULL constraint(QUANTITY)');
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: END IF;
1638:
1639: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1640: THEN
1641: -- Hint: Validate data
1642: -- IF p_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
1643: -- verify if data is valid

Line 1646: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

1665: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1666: P_Validation_mode IN VARCHAR2,
1667: P_OBJECT_VERSION_NUMBER IN NUMBER,
1668: P_REPAIR_JOB_XREF_ID IN NUMBER,
1669: -- 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.
1670: X_Return_Status OUT NOCOPY VARCHAR2,
1671: X_Msg_Count OUT NOCOPY NUMBER,
1672: X_Msg_Data OUT NOCOPY VARCHAR2
1673: )

Line 1695: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1691:
1692: -- Initialize API return status to SUCCESS
1693: x_return_status := FND_API.G_RET_STS_SUCCESS;
1694:
1695: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1696: THEN
1697:
1698: IF (g_debug > 0 ) THEN
1699: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in create');

Line 1713: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1709: -- set object_version_number to 1 for create
1710: -- p_OBJECT_VERSION_NUMBER := 1;
1711: --END IF;
1712: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1713: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1714: THEN
1715:
1716: IF (g_debug > 0 ) THEN
1717: csd_gen_utility_pvt.add('CSD_REPAIR_JOB_XREF_PVT.Validate_OBJECT_VERSION_NUMBER in update');

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

1754:
1755: END Validate_OBJECT_VERSION_NUMBER;
1756:
1757: -- Hint: inter-field level validation can be added here.
1758: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1759: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1760: -- stored in database table.
1761: PROCEDURE Validate_REPJOBXREF_rec(
1762: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1784: -- THEN
1785: -- x_return_status := FND_API.G_RET_STS_ERROR;
1786:
1787: -- Debug Message
1788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
1789:
1790: -- Standard call to get message count and if count is 1, get message info.
1791: FND_MSG_PUB.Count_And_Get
1792: ( p_count => x_msg_count,

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

1808: l_api_name CONSTANT VARCHAR2(30) := 'Validate_repjobxref';
1809: BEGIN
1810:
1811: -- Debug Message
1812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'start');
1813:
1814:
1815: -- Initialize API return status to SUCCESS
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1814:
1815: -- Initialize API return status to SUCCESS
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;
1817:
1818: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1819: -- Hint: We provide validation procedure for every column. Developer should delete
1820: -- unnecessary validation procedures.
1821: Validate_REPAIR_JOB_XREF_ID(
1822: p_init_msg_list => FND_API.G_FALSE,

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

1905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1906: raise FND_API.G_EXC_ERROR;
1907: END IF;
1908:
1909: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1910: -- Hint: Inter-field level validation can be added here
1911: -- invoke record level validation procedures
1912: Validate_REPJOBXREF_Rec(
1913: p_init_msg_list => FND_API.G_FALSE,

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

1921: raise FND_API.G_EXC_ERROR;
1922: END IF;
1923: END IF;
1924:
1925: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1926: -- invoke inter-record level validation procedures
1927: NULL;
1928: END IF;
1929:

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

1926: -- invoke inter-record level validation procedures
1927: NULL;
1928: END IF;
1929:
1930: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1931: -- invoke inter-entity level validation procedures
1932: NULL;
1933: END IF;
1934:

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

1933: END IF;
1934:
1935:
1936: -- Debug Message
1937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1938:
1939: END Validate_repjobxref;
1940:
1941: End CSD_REPair_JOB_XREF_PVT;