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

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

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

Line 116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_lines');

112: */
113: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
114: THEN
115: -- Debug message
116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_lines');
117:
118: -- Invoke validation procedures
119: Validate_packlist_lines(
120: p_init_msg_list => FND_API.G_FALSE,

Line 122: p_validation_mode => JTF_PLSQL_API.G_CREATE,

118: -- Invoke validation procedures
119: Validate_packlist_lines(
120: p_init_msg_list => FND_API.G_FALSE,
121: p_validation_level => p_validation_level,
122: p_validation_mode => JTF_PLSQL_API.G_CREATE,
123: P_PLL_Rec => P_PLL_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);

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

132:
133: -- Hint: Add corresponding Master-Detail business logic here if necessary.
134:
135: -- Debug Message
136: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
137:
138: -- Invoke table handler(CSP_PACKLIST_LINES_PKG.Insert_Row)
139: CSP_PACKLIST_LINES_PKG.Insert_Row(
140: px_PACKLIST_LINE_ID => x_PACKLIST_LINE_ID,

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

189: END IF;
190:
191:
192: -- Debug Message
193: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
194:
195:
196: -- Standard call to get message count and if count is 1, get message info.
197: FND_MSG_PUB.Count_And_Get

Line 221: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

217: END IF;
218: */
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
222: P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME
224: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
225: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 225: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

221: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
222: P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME
224: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
225: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
226: ,X_MSG_COUNT => X_MSG_COUNT
227: ,X_MSG_DATA => X_MSG_DATA
228: ,X_RETURN_STATUS => X_RETURN_STATUS);
229:

Line 231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

227: ,X_MSG_DATA => X_MSG_DATA
228: ,X_RETURN_STATUS => X_RETURN_STATUS);
229:
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
232: P_API_NAME => L_API_NAME
233: ,P_PKG_NAME => G_PKG_NAME
234: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

237: ,X_MSG_DATA => X_MSG_DATA
238: ,X_RETURN_STATUS => X_RETURN_STATUS);
239:
240: WHEN OTHERS THEN
241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 244: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

240: WHEN OTHERS THEN
241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
246: ,X_MSG_COUNT => X_MSG_COUNT
247: ,X_MSG_DATA => X_MSG_DATA
248: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
246: ,X_MSG_COUNT => X_MSG_COUNT
247: ,X_MSG_DATA => X_MSG_DATA
248: ,X_RETURN_STATUS => X_RETURN_STATUS);
249: End Create_packlist_lines;

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

332: END IF;
333:
334:
335: -- Debug Message
336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
337:
338:
339: -- Initialize API return status to SUCCESS
340: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375: */
376: -- Debug Message
377: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
378:
379: /*
380: Open C_Get_packlist_lines( l_tar_PLL_rec.PACKLIST_LINE_ID);
381:

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

425: END IF;
426: raise FND_API.G_EXC_ERROR;
427: END IF;
428: -- Debug Message
429: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
430: Close C_Get_packlist_lines;
431:
432:
433:

Line 458: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_lines');

454: */
455: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
456: THEN
457: -- Debug message
458: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_lines');
459:
460: -- Invoke validation procedures
461: Validate_packlist_lines(
462: p_init_msg_list => FND_API.G_FALSE,

Line 464: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

460: -- Invoke validation procedures
461: Validate_packlist_lines(
462: p_init_msg_list => FND_API.G_FALSE,
463: p_validation_level => p_validation_level,
464: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
465: P_PLL_Rec => P_PLL_Rec,
466: x_return_status => x_return_status,
467: x_msg_count => x_msg_count,
468: x_msg_data => x_msg_data);

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

474:
475: -- Hint: Add corresponding Master-Detail business logic here if necessary.
476:
477: -- Debug Message
478: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
479:
480: -- Invoke table handler(CSP_PACKLIST_LINES_PKG.Update_Row)
481: CSP_PACKLIST_LINES_PKG.Update_Row(
482: p_PACKLIST_LINE_ID => p_PLL_rec.PACKLIST_LINE_ID,

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

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

Line 557: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 561: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 567: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 571: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 577: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

573: ,X_MSG_DATA => X_MSG_DATA
574: ,X_RETURN_STATUS => X_RETURN_STATUS);
575:
576: WHEN OTHERS THEN
577: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
578: P_API_NAME => L_API_NAME
579: ,P_PKG_NAME => G_PKG_NAME
580: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
581: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 580: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 581: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667: */
668: -- Debug Message
669: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
670:
671: -- Invoke table handler(CSP_PACKLIST_LINES_PKG.Delete_Row)
672: CSP_PACKLIST_LINES_PKG.Delete_Row(
673: p_PACKLIST_LINE_ID => p_PLL_rec.PACKLIST_LINE_ID);

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

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

Line 715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

711: END IF;
712: */
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
720: ,X_MSG_COUNT => X_MSG_COUNT
721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);
723:

Line 725: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);
723:
724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
726: P_API_NAME => L_API_NAME
727: ,P_PKG_NAME => G_PKG_NAME
728: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
729: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 729: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

731: ,X_MSG_DATA => X_MSG_DATA
732: ,X_RETURN_STATUS => X_RETURN_STATUS);
733:
734: WHEN OTHERS THEN
735: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
736: P_API_NAME => L_API_NAME
737: ,P_PKG_NAME => G_PKG_NAME
738: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 738: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 739: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

750: )
751: IS
752: BEGIN
753: -- Debug Message
754: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
755:
756: -- define all columns for CSP_PACKLIST_LINES_V view
757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);

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

784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);
786:
787: -- Debug Message
788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
789: END Define_Columns;
790:
791: -- This procudure gets column values by the Dynamic SQL.
792: PROCEDURE Get_Column_Values(

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

795: )
796: IS
797: BEGIN
798: -- Debug Message
799: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
800:
801: -- get all column values for CSP_PACKLIST_LINES_V table
802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);

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

829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);
831:
832: -- Debug Message
833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
834: END Get_Column_Values;
835:
836: PROCEDURE Gen_PLL_order_cl(
837: p_order_by_rec IN CSP_PACKLIST_LINES_PUB.PLL_sort_rec_type,

Line 845: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

841: x_msg_data OUT NOCOPY VARCHAR2
842: )
843: IS
844: l_order_by_cl VARCHAR2(1000) := NULL;
845: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
846: BEGIN
847: -- Debug Message
848: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
849:

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

844: l_order_by_cl VARCHAR2(1000) := NULL;
845: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
846: BEGIN
847: -- Debug Message
848: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
849:
850: -- Hint: Developer should add more statements according to CSP_sort_rec_type
851: -- Ex:
852: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

852: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
853: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
854:
855: -- Debug Message
856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
857:
858: JTF_PLSQL_API.Translate_OrderBy(
859: p_api_version_number => 1.0
860: ,p_init_msg_list => FND_API.G_FALSE

Line 858: JTF_PLSQL_API.Translate_OrderBy(

854:
855: -- Debug Message
856: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
857:
858: JTF_PLSQL_API.Translate_OrderBy(
859: p_api_version_number => 1.0
860: ,p_init_msg_list => FND_API.G_FALSE
861: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
862: ,p_order_by_tbl => l_util_order_by_tbl

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

871: x_order_by_cl := NULL;
872: END IF;
873:
874: -- Debug Message
875: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
876: END Gen_PLL_order_cl;
877:
878: -- This procedure bind the variables for the Dynamic SQL
879: PROCEDURE Bind(

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

885: BEGIN
886: -- Bind variables
887: -- Only those that are not NULL
888: -- Debug Message
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
890:
891: -- The following example applies to all columns,
892: -- developers can copy and paste them.
893: IF( (P_PLL_Rec.PACKLIST_LINE_ID IS NOT NULL) AND (P_PLL_Rec.PACKLIST_LINE_ID <> FND_API.G_MISS_NUM) )

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

895: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLL, ':p_PACKLIST_LINE_ID', P_PLL_Rec.PACKLIST_LINE_ID);
896: END IF;
897:
898: -- Debug Message
899: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
900: END Bind;
901:
902: PROCEDURE Gen_Select(
903: x_select_cl OUT NOCOPY VARCHAR2

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

904: )
905: IS
906: BEGIN
907: -- Debug Message
908: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
909:
910: x_select_cl := 'Select ' ||
911: 'CSP_PACKLIST_LINES_V.PACKLIST_LINE_ID,' ||
912: 'CSP_PACKLIST_LINES_V.CREATED_BY,' ||

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

943: 'CSP_PACKLIST_LINES_V.UOM_CODE,' ||
944: 'CSP_PACKLIST_LINES_V.LINE_ID,' ||
945: 'from CSP_PACKLIST_LINES_V';
946: -- Debug Message
947: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
948:
949: END Gen_Select;
950:
951: PROCEDURE Gen_PLL_Where(

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

967: str_csr2 NUMBER;
968: l_operator VARCHAR2(10);
969: BEGIN
970: -- Debug Message
971: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
972:
973: -- There are three examples for each kind of datatype:
974: -- NUMBER, DATE, VARCHAR2.
975: -- Developer can copy and paste the following codes for your own record.

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

1053:
1054: -- Add more IF statements for each column below
1055:
1056: -- Debug Message
1057: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1058:
1059: END Gen_PLL_Where;
1060:
1061: -- Item-level validation procedures

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

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

Line 1087: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_LINE_ID)');

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

Line 1091: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1098: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

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

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

Line 1145: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1152: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1195: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_LINE_NUMBER)');

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

Line 1199: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1206: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_HEADER_ID)');

1245:
1246: -- validate NOT NULL column
1247: IF(p_PACKLIST_HEADER_ID is NULL)
1248: THEN
1249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_HEADER_ID)');
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: END IF;
1252:
1253: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1253: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_HEADER_ID)');
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: END IF;
1252:
1253: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1254: THEN
1255: -- Hint: Validate data
1256: -- IF p_PACKLIST_HEADER_ID is not NULL and p_PACKLIST_HEADER_ID <> G_MISS_CHAR
1257: -- verify if data is valid

Line 1260: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1256: -- IF p_PACKLIST_HEADER_ID is not NULL and p_PACKLIST_HEADER_ID <> G_MISS_CHAR
1257: -- verify if data is valid
1258: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1259: NULL;
1260: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1261: THEN
1262: -- Hint: Validate data
1263: -- IF p_PACKLIST_HEADER_ID <> G_MISS_CHAR
1264: -- verify if data is valid

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

1278: PROCEDURE Validate_BOX_ID (
1279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1280: P_Validation_mode IN VARCHAR2,
1281: P_BOX_ID IN NUMBER,
1282: -- 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.
1283: X_Return_Status OUT NOCOPY VARCHAR2,
1284: X_Msg_Count OUT NOCOPY NUMBER,
1285: X_Msg_Data OUT NOCOPY VARCHAR2
1286: )

Line 1303: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(BOX_ID)');

1299:
1300: -- validate NOT NULL column
1301: IF(p_BOX_ID is NULL)
1302: THEN
1303: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(BOX_ID)');
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: END IF;
1306:
1307: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1307: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1303: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(BOX_ID)');
1304: x_return_status := FND_API.G_RET_STS_ERROR;
1305: END IF;
1306:
1307: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1308: THEN
1309: -- Hint: Validate data
1310: -- IF p_BOX_ID is not NULL and p_BOX_ID <> G_MISS_CHAR
1311: -- verify if data is valid

Line 1314: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1310: -- IF p_BOX_ID is not NULL and p_BOX_ID <> G_MISS_CHAR
1311: -- verify if data is valid
1312: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1313: NULL;
1314: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1315: THEN
1316: -- Hint: Validate data
1317: -- IF p_BOX_ID <> G_MISS_CHAR
1318: -- verify if data is valid

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

1332: PROCEDURE Validate_PICKLIST_LINE_ID (
1333: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1334: P_Validation_mode IN VARCHAR2,
1335: P_PICKLIST_LINE_ID IN NUMBER,
1336: -- 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.
1337: X_Return_Status OUT NOCOPY VARCHAR2,
1338: X_Msg_Count OUT NOCOPY NUMBER,
1339: X_Msg_Data OUT NOCOPY VARCHAR2
1340: )

Line 1354: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1350:
1351: -- Initialize API return status to SUCCESS
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353:
1354: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1355: THEN
1356: -- Hint: Validate data
1357: -- IF p_PICKLIST_LINE_ID is not NULL and p_PICKLIST_LINE_ID <> G_MISS_CHAR
1358: -- verify if data is valid

Line 1361: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1404: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(PACKLIST_LINE_STATUS)');

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

Line 1408: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1415: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1458: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');

1454:
1455: -- validate NOT NULL column
1456: IF(p_INVENTORY_ITEM_ID is NULL)
1457: THEN
1458: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: END IF;
1461:
1462: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1462: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1458: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: END IF;
1461:
1462: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1463: THEN
1464: -- Hint: Validate data
1465: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1466: -- verify if data is valid

Line 1469: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1465: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1466: -- verify if data is valid
1467: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1468: NULL;
1469: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1470: THEN
1471: -- Hint: Validate data
1472: -- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1473: -- verify if data is valid

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

1487: PROCEDURE Validate_QUANTITY_PACKED (
1488: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1489: P_Validation_mode IN VARCHAR2,
1490: P_QUANTITY_PACKED IN NUMBER,
1491: -- 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.
1492: X_Return_Status OUT NOCOPY VARCHAR2,
1493: X_Msg_Count OUT NOCOPY NUMBER,
1494: X_Msg_Data OUT NOCOPY VARCHAR2
1495: )

Line 1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(QUANTITY_PACKED)');

1508:
1509: -- validate NOT NULL column
1510: IF(p_QUANTITY_PACKED is NULL)
1511: THEN
1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(QUANTITY_PACKED)');
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: END IF;
1515:
1516: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1516: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(QUANTITY_PACKED)');
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: END IF;
1515:
1516: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1517: THEN
1518: -- Hint: Validate data
1519: -- IF p_QUANTITY_PACKED is not NULL and p_QUANTITY_PACKED <> G_MISS_CHAR
1520: -- verify if data is valid

Line 1523: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1519: -- IF p_QUANTITY_PACKED is not NULL and p_QUANTITY_PACKED <> G_MISS_CHAR
1520: -- verify if data is valid
1521: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1522: NULL;
1523: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1524: THEN
1525: -- Hint: Validate data
1526: -- IF p_QUANTITY_PACKED <> G_MISS_CHAR
1527: -- verify if data is valid

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

1541: PROCEDURE Validate_QUANTITY_SHIPPED (
1542: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1543: P_Validation_mode IN VARCHAR2,
1544: P_QUANTITY_SHIPPED IN NUMBER,
1545: -- 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.
1546: X_Return_Status OUT NOCOPY VARCHAR2,
1547: X_Msg_Count OUT NOCOPY NUMBER,
1548: X_Msg_Data OUT NOCOPY VARCHAR2
1549: )

Line 1563: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1559:
1560: -- Initialize API return status to SUCCESS
1561: x_return_status := FND_API.G_RET_STS_SUCCESS;
1562:
1563: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1564: THEN
1565: -- Hint: Validate data
1566: -- IF p_QUANTITY_SHIPPED is not NULL and p_QUANTITY_SHIPPED <> G_MISS_CHAR
1567: -- verify if data is valid

Line 1570: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1566: -- IF p_QUANTITY_SHIPPED is not NULL and p_QUANTITY_SHIPPED <> G_MISS_CHAR
1567: -- verify if data is valid
1568: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1569: NULL;
1570: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1571: THEN
1572: -- Hint: Validate data
1573: -- IF p_QUANTITY_SHIPPED <> G_MISS_CHAR
1574: -- verify if data is valid

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

1588: PROCEDURE Validate_QUANTITY_RECEIVED (
1589: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1590: P_Validation_mode IN VARCHAR2,
1591: P_QUANTITY_RECEIVED IN NUMBER,
1592: -- 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.
1593: X_Return_Status OUT NOCOPY VARCHAR2,
1594: X_Msg_Count OUT NOCOPY NUMBER,
1595: X_Msg_Data OUT NOCOPY VARCHAR2
1596: )

Line 1610: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1606:
1607: -- Initialize API return status to SUCCESS
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1611: THEN
1612: -- Hint: Validate data
1613: -- IF p_QUANTITY_RECEIVED is not NULL and p_QUANTITY_RECEIVED <> G_MISS_CHAR
1614: -- verify if data is valid

Line 1617: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1613: -- IF p_QUANTITY_RECEIVED is not NULL and p_QUANTITY_RECEIVED <> G_MISS_CHAR
1614: -- verify if data is valid
1615: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1616: NULL;
1617: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1618: THEN
1619: -- Hint: Validate data
1620: -- IF p_QUANTITY_RECEIVED <> G_MISS_CHAR
1621: -- verify if data is valid

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

1635: PROCEDURE Validate_UOM_CODE (
1636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1637: P_Validation_mode IN VARCHAR2,
1638: P_UOM_CODE IN VARCHAR2,
1639: -- 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.
1640: X_Return_Status OUT NOCOPY VARCHAR2,
1641: X_Msg_Count OUT NOCOPY NUMBER,
1642: X_Msg_Data OUT NOCOPY VARCHAR2
1643: )

Line 1660: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(UOM_CODE)');

1656:
1657: -- validate NOT NULL column
1658: IF(p_UOM_CODE is NULL)
1659: THEN
1660: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(UOM_CODE)');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: END IF;
1663:
1664: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1664: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1660: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_lines API: -Violate NOT NULL constraint(UOM_CODE)');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: END IF;
1663:
1664: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1665: THEN
1666: -- Hint: Validate data
1667: -- IF p_UOM_CODE is not NULL and p_UOM_CODE <> G_MISS_CHAR
1668: -- verify if data is valid

Line 1671: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1667: -- IF p_UOM_CODE is not NULL and p_UOM_CODE <> G_MISS_CHAR
1668: -- verify if data is valid
1669: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1670: NULL;
1671: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1672: THEN
1673: -- Hint: Validate data
1674: -- IF p_UOM_CODE <> G_MISS_CHAR
1675: -- verify if data is valid

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

1689: PROCEDURE Validate_LINE_ID (
1690: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1691: P_Validation_mode IN VARCHAR2,
1692: P_LINE_ID IN NUMBER,
1693: -- 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.
1694: X_Return_Status OUT NOCOPY VARCHAR2,
1695: X_Msg_Count OUT NOCOPY NUMBER,
1696: X_Msg_Data OUT NOCOPY VARCHAR2
1697: )

Line 1711: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1707:
1708: -- Initialize API return status to SUCCESS
1709: x_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1712: THEN
1713: -- Hint: Validate data
1714: -- IF p_LINE_ID is not NULL and p_LINE_ID <> G_MISS_CHAR
1715: -- verify if data is valid

Line 1718: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1714: -- IF p_LINE_ID is not NULL and p_LINE_ID <> G_MISS_CHAR
1715: -- verify if data is valid
1716: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1717: NULL;
1718: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1719: THEN
1720: -- Hint: Validate data
1721: -- IF p_LINE_ID <> G_MISS_CHAR
1722: -- verify if data is valid

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

1733: END Validate_LINE_ID;
1734:
1735:
1736: -- Hint: inter-field level validation can be added here.
1737: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1738: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1739: -- stored in database table.
1740: PROCEDURE Validate_PLL_rec(
1741: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1763: -- THEN
1764: -- x_return_status := FND_API.G_RET_STS_ERROR;
1765:
1766: -- Debug Message
1767: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1768:
1769: -- Standard call to get message count and if count is 1, get message info.
1770: FND_MSG_PUB.Count_And_Get
1771: ( p_count => x_msg_count,

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

1787: l_api_name CONSTANT VARCHAR2(30) := 'Validate_packlist_lines';
1788: BEGIN
1789:
1790: -- Debug Message
1791: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1792:
1793:
1794: -- Initialize API return status to SUCCESS
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1793:
1794: -- Initialize API return status to SUCCESS
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1798: -- Hint: We provide validation procedure for every column. Developer should delete
1799: -- unnecessary validation procedures.
1800: Validate_PACKLIST_LINE_ID(
1801: p_init_msg_list => FND_API.G_FALSE,

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

1954: END IF;
1955:
1956: END IF;
1957:
1958: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1959: -- Hint: Inter-field level validation can be added here
1960: -- invoke record level validation procedures
1961: Validate_PLL_Rec(
1962: p_init_msg_list => FND_API.G_FALSE,

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

1970: raise FND_API.G_EXC_ERROR;
1971: END IF;
1972: END IF;
1973:
1974: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1975: -- invoke inter-record level validation procedures
1976: NULL;
1977: END IF;
1978:

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

1975: -- invoke inter-record level validation procedures
1976: NULL;
1977: END IF;
1978:
1979: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1980: -- invoke inter-entity level validation procedures
1981: NULL;
1982: END IF;
1983:

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

1982: END IF;
1983:
1984:
1985: -- Debug Message
1986: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1987:
1988: END Validate_packlist_lines;
1989:
1990: End CSP_PACKLIST_LINES_PVT;