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.CSP_RESOURCE_PVT dependencies on JTF_PLSQL_API

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

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

Line 121: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_resource');

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

Line 127: p_validation_mode => JTF_PLSQL_API.G_CREATE,

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

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

137:
138: -- Hint: Add corresponding Master-Detail business logic here if necessary.
139:
140: -- Debug Message
141: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
142:
143: IF p_CSP_rec.created_by IS NULL THEN
144: l_created_by := G_USER_ID;
145: END IF;

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

201: END IF;
202:
203:
204: -- Debug Message
205: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
206:
207:
208: -- Standard call to get message count and if count is 1, get message info.
209: FND_MSG_PUB.Count_And_Get

Line 233: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

229: END IF;
230: */
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
237: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 237: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

233: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
237: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
238: ,X_MSG_COUNT => X_MSG_COUNT
239: ,X_MSG_DATA => X_MSG_DATA
240: ,X_RETURN_STATUS => X_RETURN_STATUS);
241:

Line 243: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 247: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

243: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
244: P_API_NAME => L_API_NAME
245: ,P_PKG_NAME => G_PKG_NAME
246: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
247: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
248: ,X_MSG_COUNT => X_MSG_COUNT
249: ,X_MSG_DATA => X_MSG_DATA
250: ,X_RETURN_STATUS => X_RETURN_STATUS);
251:

Line 253: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 256: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 257: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

253: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
257: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
258: ,X_MSG_COUNT => X_MSG_COUNT
259: ,X_MSG_DATA => X_MSG_DATA
260: ,X_RETURN_STATUS => X_RETURN_STATUS);
261: End Create_resource;

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

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

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

381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383: */
384: -- Debug Message
385: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
386:
387: /*
388: Open C_Get_resource( l_tar_CSP_rec.CSP_INV_LOC_ASSIGNMENT_ID);
389:

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

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

Line 464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_resource');

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, 'CSP', 'Private API: Validate_resource');
465:
466: -- Invoke validation procedures
467: Validate_resource(
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_resource(
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_CSP_Rec => P_CSP_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, 'CSP', '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, 'CSP', 'Private API: Calling update table handler');
485:
486: -- Invoke table handler(CSP_INV_LOC_ASSIGNMENTS_PKG.Update_Row)
487: CSP_INV_LOC_ASSIGNMENTS_PKG.Update_Row(
488: p_CSP_INV_LOC_ASSIGNMENT_ID => p_CSP_rec.CSP_INV_LOC_ASSIGNMENT_ID,

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

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

Line 560: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 564: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 570: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 574: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 581: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 584: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 585: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

669: RAISE FND_API.G_EXC_ERROR;
670: END IF;
671: */
672: -- Debug Message
673: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
674:
675: -- Invoke table handler(CSP_INV_LOC_ASSIGNMENTS_PKG.Delete_Row)
676: CSP_INV_LOC_ASSIGNMENTS_PKG.Delete_Row(
677: p_CSP_INV_LOC_ASSIGNMENT_ID => p_CSP_rec.CSP_INV_LOC_ASSIGNMENT_ID);

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

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

Line 719: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

715: END IF;
716: */
717: EXCEPTION
718: WHEN FND_API.G_EXC_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_ERROR
723: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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 => FND_MSG_PUB.G_MSG_LVL_ERROR
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:

Line 729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

725: ,X_MSG_DATA => X_MSG_DATA
726: ,X_RETURN_STATUS => X_RETURN_STATUS);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
730: P_API_NAME => L_API_NAME
731: ,P_PKG_NAME => G_PKG_NAME
732: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
730: P_API_NAME => L_API_NAME
731: ,P_PKG_NAME => G_PKG_NAME
732: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
734: ,X_MSG_COUNT => X_MSG_COUNT
735: ,X_MSG_DATA => X_MSG_DATA
736: ,X_RETURN_STATUS => X_RETURN_STATUS);
737:

Line 739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

735: ,X_MSG_DATA => X_MSG_DATA
736: ,X_RETURN_STATUS => X_RETURN_STATUS);
737:
738: WHEN OTHERS THEN
739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 742: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

738: WHEN OTHERS THEN
739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
740: P_API_NAME => L_API_NAME
741: ,P_PKG_NAME => G_PKG_NAME
742: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
744: ,X_MSG_COUNT => X_MSG_COUNT
745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);
747: End Delete_resource;

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

754: )
755: IS
756: BEGIN
757: -- Debug Message
758: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
759:
760: -- define all columns for CSP_INV_LOC_ASSIGNMENTS_V view
761: dbms_sql.define_column(p_cur_get_CSP, 1, P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
762: dbms_sql.define_column(p_cur_get_CSP, 2, P_CSP_Rec.RESOURCE_ID);

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

768: dbms_sql.define_column(p_cur_get_CSP, 8, P_CSP_Rec.EFFECTIVE_DATE_END);
769: dbms_sql.define_column(p_cur_get_CSP, 9, P_CSP_Rec.DEFAULT_CODE, 30);
770:
771: -- Debug Message
772: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
773: END Define_Columns;
774:
775: -- This procudure gets column values by the Dynamic SQL.
776: PROCEDURE Get_Column_Values(

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

779: )
780: IS
781: BEGIN
782: -- Debug Message
783: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
784:
785: -- get all column values for CSP_INV_LOC_ASSIGNMENTS_V table
786: dbms_sql.column_value(p_cur_get_CSP, 1, X_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
787: dbms_sql.column_value(p_cur_get_CSP, 2, X_CSP_Rec.RESOURCE_ID);

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

793: dbms_sql.column_value(p_cur_get_CSP, 8, X_CSP_Rec.EFFECTIVE_DATE_END);
794: dbms_sql.column_value(p_cur_get_CSP, 9, X_CSP_Rec.DEFAULT_CODE);
795:
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
798: END Get_Column_Values;
799:
800: PROCEDURE Gen_CSP_order_cl(
801: p_order_by_rec IN CSP_RESOURCE_PUB.CSP_sort_rec_type,

Line 809: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

805: x_msg_data OUT NOCOPY VARCHAR2
806: )
807: IS
808: l_order_by_cl VARCHAR2(1000) := NULL;
809: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
810: BEGIN
811: -- Debug Message
812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
813:

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

808: l_order_by_cl VARCHAR2(1000) := NULL;
809: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
810: BEGIN
811: -- Debug Message
812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
813:
814: -- Hint: Developer should add more statements according to CSP_sort_rec_type
815: -- Ex:
816: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

Line 820: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');

816: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
817: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
818:
819: -- Debug Message
820: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
821:
822: JTF_PLSQL_API.Translate_OrderBy(
823: p_api_version_number => 1.0
824: ,p_init_msg_list => FND_API.G_FALSE

Line 822: JTF_PLSQL_API.Translate_OrderBy(

818:
819: -- Debug Message
820: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
821:
822: JTF_PLSQL_API.Translate_OrderBy(
823: p_api_version_number => 1.0
824: ,p_init_msg_list => FND_API.G_FALSE
825: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
826: ,p_order_by_tbl => l_util_order_by_tbl

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

835: x_order_by_cl := NULL;
836: END IF;
837:
838: -- Debug Message
839: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
840: END Gen_CSP_order_cl;
841:
842: -- This procedure bind the variables for the Dynamic SQL
843: PROCEDURE Bind(

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

850:
851: -- Bind variables
852: -- Only those that are not NULL
853: -- Debug Message
854: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
855:
856: -- The following example applies to all columns,
857: -- developers can copy and paste them.
858: IF( (P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID IS NOT NULL) AND (P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID <> FND_API.G_MISS_NUM) )

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

860: DBMS_SQL.BIND_VARIABLE(p_cur_get_CSP, ':p_CSP_INV_LOC_ASSIGNMENT_ID', P_CSP_Rec.CSP_INV_LOC_ASSIGNMENT_ID);
861: END IF;
862:
863: -- Debug Message
864: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
865: END Bind;
866:
867: PROCEDURE Gen_Select(
868: x_select_cl OUT NOCOPY VARCHAR2

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

869: )
870: IS
871: BEGIN
872: -- Debug Message
873: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
874:
875: x_select_cl := 'Select ' ||
876: 'CSP_INV_LOC_ASSIGNMENTS_V.CSP_INV_LOC_ASSIGNMENT_ID,' ||
877: 'CSP_INV_LOC_ASSIGNMENTS_V.CREATED_BY,' ||

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

888: 'CSP_INV_LOC_ASSIGNMENTS_V.EFFECTIVE_DATE_END,' ||
889: 'CSP_INV_LOC_ASSIGNMENTS_V.DEFAULT_CODE,' ||
890: 'from CSP_INV_LOC_ASSIGNMENTS_V';
891: -- Debug Message
892: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
893:
894: END Gen_Select;
895:
896: PROCEDURE Gen_CSP_Where(

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

912: str_csr2 NUMBER;
913: l_operator VARCHAR2(10);
914: BEGIN
915: -- Debug Message
916: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
917:
918: -- There are three examples for each kind of datatype:
919: -- NUMBER, DATE, VARCHAR2.
920: -- Developer can copy and paste the following codes for your own record.

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

998:
999: -- Add more IF statements for each column below
1000:
1001: -- Debug Message
1002: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1003:
1004: END Gen_CSP_Where;
1005:
1006: -- Item-level validation procedures

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

1007: PROCEDURE Validate_CILA (
1008: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1009: P_Validation_mode IN VARCHAR2,
1010: P_CSP_INV_LOC_ASSIGNMENT_ID IN NUMBER,
1011: -- 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.
1012: X_Return_Status OUT NOCOPY VARCHAR2,
1013: X_Msg_Count OUT NOCOPY NUMBER,
1014: X_Msg_Data OUT NOCOPY VARCHAR2
1015: )

Line 1032: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(CSP_INV_LOC_ASSIGNMENT_ID)');

1028:
1029: -- validate NOT NULL column
1030: IF(p_CSP_INV_LOC_ASSIGNMENT_ID is NULL)
1031: THEN
1032: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(CSP_INV_LOC_ASSIGNMENT_ID)');
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: END IF;
1035:
1036: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1036: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1032: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(CSP_INV_LOC_ASSIGNMENT_ID)');
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: END IF;
1035:
1036: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1037: THEN
1038: -- Hint: Validate data
1039: -- IF p_CSP_INV_LOC_ASSIGNMENT_ID is not NULL and p_CSP_INV_LOC_ASSIGNMENT_ID <> G_MISS_CHAR
1040: -- verify if data is valid

Line 1043: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1039: -- IF p_CSP_INV_LOC_ASSIGNMENT_ID is not NULL and p_CSP_INV_LOC_ASSIGNMENT_ID <> G_MISS_CHAR
1040: -- verify if data is valid
1041: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1042: NULL;
1043: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1044: THEN
1045: -- Hint: Validate data
1046: -- IF p_CSP_INV_LOC_ASSIGNMENT_ID <> G_MISS_CHAR
1047: -- verify if data is valid

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

1061: PROCEDURE Validate_RESOURCE_ID (
1062: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1063: P_Validation_mode IN VARCHAR2,
1064: P_RESOURCE_ID IN NUMBER,
1065: -- 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.
1066: X_Return_Status OUT NOCOPY VARCHAR2,
1067: X_Msg_Count OUT NOCOPY NUMBER,
1068: X_Msg_Data OUT NOCOPY VARCHAR2
1069: )

Line 1086: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_ID)');

1082:
1083: -- validate NOT NULL column
1084: IF(p_RESOURCE_ID is NULL)
1085: THEN
1086: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_ID)');
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089:
1090: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1090: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1086: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_ID)');
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089:
1090: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1091: THEN
1092: -- Hint: Validate data
1093: -- IF p_RESOURCE_ID is not NULL and p_RESOURCE_ID <> G_MISS_CHAR
1094: -- verify if data is valid

Line 1097: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1093: -- IF p_RESOURCE_ID is not NULL and p_RESOURCE_ID <> G_MISS_CHAR
1094: -- verify if data is valid
1095: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1096: NULL;
1097: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1098: THEN
1099: -- Hint: Validate data
1100: -- IF p_RESOURCE_ID <> G_MISS_CHAR
1101: -- verify if data is valid

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

1115: PROCEDURE Validate_ORGANIZATION_ID (
1116: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1117: P_Validation_mode IN VARCHAR2,
1118: P_ORGANIZATION_ID IN NUMBER,
1119: -- 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.
1120: X_Return_Status OUT NOCOPY VARCHAR2,
1121: X_Msg_Count OUT NOCOPY NUMBER,
1122: X_Msg_Data OUT NOCOPY VARCHAR2
1123: )

Line 1140: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(ORGANIZATION_ID)');

1136:
1137: -- validate NOT NULL column
1138: IF(p_ORGANIZATION_ID is NULL)
1139: THEN
1140: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: END IF;
1143:
1144: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1144: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1140: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: END IF;
1143:
1144: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1145: THEN
1146: -- Hint: Validate data
1147: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1148: -- verify if data is valid

Line 1151: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1147: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1148: -- verify if data is valid
1149: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1150: NULL;
1151: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1152: THEN
1153: -- Hint: Validate data
1154: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
1155: -- verify if data is valid

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

1169: PROCEDURE Validate_SUBINVENTORY_CODE (
1170: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1171: P_Validation_mode IN VARCHAR2,
1172: P_SUBINVENTORY_CODE IN VARCHAR2,
1173: -- 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.
1174: X_Return_Status OUT NOCOPY VARCHAR2,
1175: X_Msg_Count OUT NOCOPY NUMBER,
1176: X_Msg_Data OUT NOCOPY VARCHAR2
1177: )

Line 1194: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(SUBINVENTORY_CODE)');

1190:
1191: -- validate NOT NULL column
1192: IF(p_SUBINVENTORY_CODE is NULL)
1193: THEN
1194: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(SUBINVENTORY_CODE)');
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: END IF;
1197:
1198: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1198: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1194: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(SUBINVENTORY_CODE)');
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: END IF;
1197:
1198: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1199: THEN
1200: -- Hint: Validate data
1201: -- IF p_SUBINVENTORY_CODE is not NULL and p_SUBINVENTORY_CODE <> G_MISS_CHAR
1202: -- verify if data is valid

Line 1205: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1201: -- IF p_SUBINVENTORY_CODE is not NULL and p_SUBINVENTORY_CODE <> G_MISS_CHAR
1202: -- verify if data is valid
1203: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1204: NULL;
1205: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1206: THEN
1207: -- Hint: Validate data
1208: -- IF p_SUBINVENTORY_CODE <> G_MISS_CHAR
1209: -- verify if data is valid

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

1223: PROCEDURE Validate_LOCATOR_ID (
1224: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1225: P_Validation_mode IN VARCHAR2,
1226: P_LOCATOR_ID IN NUMBER,
1227: -- 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.
1228: X_Return_Status OUT NOCOPY VARCHAR2,
1229: X_Msg_Count OUT NOCOPY NUMBER,
1230: X_Msg_Data OUT NOCOPY VARCHAR2
1231: )

Line 1245: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1241:
1242: -- Initialize API return status to SUCCESS
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1246: THEN
1247: -- Hint: Validate data
1248: -- IF p_LOCATOR_ID is not NULL and p_LOCATOR_ID <> G_MISS_CHAR
1249: -- verify if data is valid

Line 1252: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1248: -- IF p_LOCATOR_ID is not NULL and p_LOCATOR_ID <> G_MISS_CHAR
1249: -- verify if data is valid
1250: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1251: NULL;
1252: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1253: THEN
1254: -- Hint: Validate data
1255: -- IF p_LOCATOR_ID <> G_MISS_CHAR
1256: -- verify if data is valid

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

1270: PROCEDURE Validate_RESOURCE_TYPE (
1271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1272: P_Validation_mode IN VARCHAR2,
1273: P_RESOURCE_TYPE IN VARCHAR2,
1274: -- 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.
1275: X_Return_Status OUT NOCOPY VARCHAR2,
1276: X_Msg_Count OUT NOCOPY NUMBER,
1277: X_Msg_Data OUT NOCOPY VARCHAR2
1278: )

Line 1295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_TYPE)');

1291:
1292: -- validate NOT NULL column
1293: IF(p_RESOURCE_TYPE is NULL)
1294: THEN
1295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_TYPE)');
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: END IF;
1298:
1299: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1299: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(RESOURCE_TYPE)');
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297: END IF;
1298:
1299: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1300: THEN
1301: -- Hint: Validate data
1302: -- IF p_RESOURCE_TYPE is not NULL and p_RESOURCE_TYPE <> G_MISS_CHAR
1303: -- verify if data is valid

Line 1306: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1302: -- IF p_RESOURCE_TYPE is not NULL and p_RESOURCE_TYPE <> G_MISS_CHAR
1303: -- verify if data is valid
1304: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1305: NULL;
1306: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1307: THEN
1308: -- Hint: Validate data
1309: -- IF p_RESOURCE_TYPE <> G_MISS_CHAR
1310: -- verify if data is valid

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

1324: PROCEDURE Validate_EFFECTIVE_DATE_START (
1325: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1326: P_Validation_mode IN VARCHAR2,
1327: P_EFFECTIVE_DATE_START IN DATE,
1328: -- 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.
1329: X_Return_Status OUT NOCOPY VARCHAR2,
1330: X_Msg_Count OUT NOCOPY NUMBER,
1331: X_Msg_Data OUT NOCOPY VARCHAR2
1332: )

Line 1349: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_START)');

1345:
1346: -- validate NOT NULL column
1347: IF(p_EFFECTIVE_DATE_START is NULL)
1348: THEN
1349: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_START)');
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352:
1353: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1353: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1349: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_START)');
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;
1352:
1353: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1354: THEN
1355: -- Hint: Validate data
1356: -- IF p_EFFECTIVE_DATE_START is not NULL and p_EFFECTIVE_DATE_START <> G_MISS_CHAR
1357: -- verify if data is valid

Line 1360: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1356: -- IF p_EFFECTIVE_DATE_START is not NULL and p_EFFECTIVE_DATE_START <> G_MISS_CHAR
1357: -- verify if data is valid
1358: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1359: NULL;
1360: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1361: THEN
1362: -- Hint: Validate data
1363: -- IF p_EFFECTIVE_DATE_START <> G_MISS_CHAR
1364: -- verify if data is valid

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

1378: PROCEDURE Validate_EFFECTIVE_DATE_END (
1379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1380: P_Validation_mode IN VARCHAR2,
1381: P_EFFECTIVE_DATE_END IN DATE,
1382: -- 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.
1383: X_Return_Status OUT NOCOPY VARCHAR2,
1384: X_Msg_Count OUT NOCOPY NUMBER,
1385: X_Msg_Data OUT NOCOPY VARCHAR2
1386: )

Line 1403: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_END)');

1399:
1400: -- validate NOT NULL column
1401: IF(p_EFFECTIVE_DATE_END is NULL)
1402: THEN
1403: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_END)');
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: END IF;
1406:
1407: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1407: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1403: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private resource API: -Violate NOT NULL constraint(EFFECTIVE_DATE_END)');
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: END IF;
1406:
1407: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1408: THEN
1409: -- Hint: Validate data
1410: -- IF p_EFFECTIVE_DATE_END is not NULL and p_EFFECTIVE_DATE_END <> G_MISS_CHAR
1411: -- verify if data is valid

Line 1414: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1410: -- IF p_EFFECTIVE_DATE_END is not NULL and p_EFFECTIVE_DATE_END <> G_MISS_CHAR
1411: -- verify if data is valid
1412: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1413: NULL;
1414: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1415: THEN
1416: -- Hint: Validate data
1417: -- IF p_EFFECTIVE_DATE_END <> G_MISS_CHAR
1418: -- verify if data is valid

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

1432: PROCEDURE Validate_DEFAULT_CODE (
1433: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1434: P_Validation_mode IN VARCHAR2,
1435: P_DEFAULT_CODE IN VARCHAR2,
1436: -- 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.
1437: X_Return_Status OUT NOCOPY VARCHAR2,
1438: X_Msg_Count OUT NOCOPY NUMBER,
1439: X_Msg_Data OUT NOCOPY VARCHAR2
1440: )

Line 1454: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1450:
1451: -- Initialize API return status to SUCCESS
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1455: THEN
1456: -- Hint: Validate data
1457: -- IF p_DEFAULT_CODE is not NULL and p_DEFAULT_CODE <> G_MISS_CHAR
1458: -- verify if data is valid

Line 1461: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1457: -- IF p_DEFAULT_CODE is not NULL and p_DEFAULT_CODE <> G_MISS_CHAR
1458: -- verify if data is valid
1459: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1460: NULL;
1461: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1462: THEN
1463: -- Hint: Validate data
1464: -- IF p_DEFAULT_CODE <> G_MISS_CHAR
1465: -- verify if data is valid

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

1476: END Validate_DEFAULT_CODE;
1477:
1478:
1479: -- Hint: inter-field level validation can be added here.
1480: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1481: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1482: -- stored in database table.
1483: PROCEDURE Validate_CSP_rec(
1484: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1510: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');

1506: -- THEN
1507: -- x_return_status := FND_API.G_RET_STS_ERROR;
1508:
1509: -- Debug Message
1510: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1511:
1512: -- Standard call to get message count and if count is 1, get message info.
1513: FND_MSG_PUB.Count_And_Get
1514: ( p_count => x_msg_count,

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

1530: l_api_name CONSTANT VARCHAR2(30) := 'Validate_resource';
1531: BEGIN
1532:
1533: -- Debug Message
1534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1535:
1536:
1537: -- Initialize API return status to SUCCESS
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1536:
1537: -- Initialize API return status to SUCCESS
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1541: -- Hint: We provide validation procedure for every column. Developer should delete
1542: -- unnecessary validation procedures.
1543: Validate_CILA(
1544: p_init_msg_list => FND_API.G_FALSE,

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

1649: END IF;
1650:
1651: END IF;
1652:
1653: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1654: -- Hint: Inter-field level validation can be added here
1655: -- invoke record level validation procedures
1656: Validate_CSP_Rec(
1657: p_init_msg_list => FND_API.G_FALSE,

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

1665: raise FND_API.G_EXC_ERROR;
1666: END IF;
1667: END IF;
1668:
1669: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1670: -- invoke inter-record level validation procedures
1671: NULL;
1672: END IF;
1673:

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

1670: -- invoke inter-record level validation procedures
1671: NULL;
1672: END IF;
1673:
1674: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1675: -- invoke inter-entity level validation procedures
1676: NULL;
1677: END IF;
1678:

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

1677: END IF;
1678:
1679:
1680: -- Debug Message
1681: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1682:
1683: END Validate_resource;
1684:
1685: End CSP_RESOURCE_PVT;