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

Line 58: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', '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, 'Error', '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,'Error','Private API: Validate_picklist_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,'Error','Private API: Validate_picklist_lines');
117:
118: -- Invoke validation procedures
119: Validate_picklist_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_picklist_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_picklist_line_Rec => P_picklist_line_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, 'Error','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, 'Error','Private API: Calling create table handler');
137:
138: -- assign p_picklist_line_rec.picklist_line_id to x_picklist_line_id (by klou)
139: x_picklist_line_id := p_picklist_line_rec.picklist_line_id;
140:

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

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

Line 220: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 224: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 230: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 234: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 240: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 243: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 244: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

327: END IF;
328:
329:
330: -- Debug Message
331: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'start');
332:
333:
334: -- Initialize API return status to SUCCESS
335: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370: */
371: -- Debug Message
372: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Error','Private API: - Open Cursor to Select');
373:
374: /*
375: Open C_Get_picklist_lines( l_tar_picklist_line_rec.picklist_line_id);
376:

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

416: END IF;
417: raise FND_API.G_EXC_ERROR;
418: END IF;
419: -- Debug Message
420: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
421: Close C_Get_picklist_lines;
422: */
423:
424:

Line 449: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Error','Private API: Validate_picklist_lines');

445: */
446: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
447: THEN
448: -- Debug message
449: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Error','Private API: Validate_picklist_lines');
450:
451: -- Invoke validation procedures
452: Validate_picklist_lines(
453: p_init_msg_list => FND_API.G_FALSE,

Line 455: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

451: -- Invoke validation procedures
452: Validate_picklist_lines(
453: p_init_msg_list => FND_API.G_FALSE,
454: p_validation_level => p_validation_level,
455: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
456: P_picklist_line_Rec => P_picklist_line_Rec,
457: x_return_status => x_return_status,
458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data);

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

465:
466: -- Hint: Add corresponding Master-Detail business logic here if necessary.
467:
468: -- Debug Message
469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: Calling update table handler');
470: -- Invoke table handler(CSP_PICKLIST_LINES_PKG.Update_Row)
471: CSP_PICKLIST_LINES_PKG.Update_Row(
472: p_picklist_line_id => p_picklist_line_rec.picklist_line_id,
473: p_CREATED_BY => p_picklist_line_rec.CREATED_BY,

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

509: END IF;
510:
511:
512: -- Debug Message
513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'end');
514:
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get

Line 542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

538: END IF;
539: */
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
547: ,X_MSG_COUNT => X_MSG_COUNT
548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);
550:

Line 552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560:

Line 562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560:
561: WHEN OTHERS THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

561: WHEN OTHERS THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);
570: End Update_picklist_lines;

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

609: END IF;
610:
611:
612: -- Debug Message
613: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'start');
614:
615:
616: -- Initialize API return status to SUCCESS
617: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: */
653: -- Debug Message
654: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: Calling delete table handler');
655:
656: -- Invoke table handler(CSP_PICKLIST_LINES_PKG.Delete_Row)
657: CSP_PICKLIST_LINES_PKG.Delete_Row(
658: p_picklist_line_id => p_picklist_line_rec.picklist_line_id);

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

667: END IF;
668:
669:
670: -- Debug Message
671: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'end');
672:
673:
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get

Line 700: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

696: END IF;
697: */
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
701: P_API_NAME => L_API_NAME
702: ,P_PKG_NAME => G_PKG_NAME
703: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
704: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 704: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

700: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
701: P_API_NAME => L_API_NAME
702: ,P_PKG_NAME => G_PKG_NAME
703: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
704: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
705: ,X_MSG_COUNT => X_MSG_COUNT
706: ,X_MSG_DATA => X_MSG_DATA
707: ,X_RETURN_STATUS => X_RETURN_STATUS);
708:

Line 710: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

706: ,X_MSG_DATA => X_MSG_DATA
707: ,X_RETURN_STATUS => X_RETURN_STATUS);
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
711: P_API_NAME => L_API_NAME
712: ,P_PKG_NAME => G_PKG_NAME
713: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
714: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 714: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

710: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
711: P_API_NAME => L_API_NAME
712: ,P_PKG_NAME => G_PKG_NAME
713: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
714: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
715: ,X_MSG_COUNT => X_MSG_COUNT
716: ,X_MSG_DATA => X_MSG_DATA
717: ,X_RETURN_STATUS => X_RETURN_STATUS);
718:

Line 720: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 723: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 724: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

735: )
736: IS
737: BEGIN
738: -- Debug Message
739: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
740:
741: -- define all columns for CSP_PICKLIST_LINES_V view
742: dbms_sql.define_column(p_cur_get_picklist_line, 1, P_picklist_line_Rec.picklist_line_id);
743: dbms_sql.define_column(p_cur_get_picklist_line, 2, P_picklist_line_Rec.PICKLIST_LINE_NUMBER);

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

765: dbms_sql.define_column(p_cur_get_picklist_line, 24, P_picklist_line_Rec.ATTRIBUTE14, 150);
766: dbms_sql.define_column(p_cur_get_picklist_line, 25, P_picklist_line_Rec.ATTRIBUTE15, 150);
767:
768: -- Debug Message
769: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
770: END Define_Columns;
771:
772: -- This procudure gets column values by the Dynamic SQL.
773: PROCEDURE Get_Column_Values(

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

776: )
777: IS
778: BEGIN
779: -- Debug Message
780: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
781:
782: -- get all column values for CSP_PICKLIST_LINES_V table
783: dbms_sql.column_value(p_cur_get_picklist_line, 1, X_picklist_line_Rec.picklist_line_id);
784: dbms_sql.column_value(p_cur_get_picklist_line, 2, X_picklist_line_Rec.PICKLIST_LINE_NUMBER);

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

806: dbms_sql.column_value(p_cur_get_picklist_line, 24, X_picklist_line_Rec.ATTRIBUTE14);
807: dbms_sql.column_value(p_cur_get_picklist_line, 25, X_picklist_line_Rec.ATTRIBUTE15);
808:
809: -- Debug Message
810: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
811: END Get_Column_Values;
812:
813: PROCEDURE Gen_picklist_line_order_cl(
814: p_order_by_rec IN CSP_picklist_lines_PUB.picklist_line_sort_rec_type,

Line 822: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

818: x_msg_data OUT NOCOPY VARCHAR2
819: )
820: IS
821: l_order_by_cl VARCHAR2(1000) := NULL;
822: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
823: BEGIN
824: -- Debug Message
825: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
826:

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

821: l_order_by_cl VARCHAR2(1000) := NULL;
822: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
823: BEGIN
824: -- Debug Message
825: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
826:
827: -- Hint: Developer should add more statements according to CSP_sort_rec_type
828: -- Ex:
829: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

829: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
830: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
831:
832: -- Debug Message
833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');
834:
835: JTF_PLSQL_API.Translate_OrderBy(
836: p_api_version_number => 1.0
837: ,p_init_msg_list => FND_API.G_FALSE

Line 835: JTF_PLSQL_API.Translate_OrderBy(

831:
832: -- Debug Message
833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke JTF_PLSQL_API.Translate_OrderBy');
834:
835: JTF_PLSQL_API.Translate_OrderBy(
836: p_api_version_number => 1.0
837: ,p_init_msg_list => FND_API.G_FALSE
838: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
839: ,p_order_by_tbl => l_util_order_by_tbl

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

848: x_order_by_cl := NULL;
849: END IF;
850:
851: -- Debug Message
852: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');
853: END Gen_picklist_line_order_cl;
854:
855: -- This procedure bind the variables for the Dynamic SQL
856: PROCEDURE Bind(

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

862: BEGIN
863: -- Bind variables
864: -- Only those that are not NULL
865: -- Debug Message
866: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
867:
868: -- The following example applies to all columns,
869: -- developers can copy and paste them.
870: IF( (P_picklist_line_Rec.picklist_line_id IS NOT NULL) AND (P_picklist_line_Rec.picklist_line_id <> FND_API.G_MISS_NUM) )

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

872: DBMS_SQL.BIND_VARIABLE(p_cur_get_picklist_line, ':p_picklist_line_id', P_picklist_line_Rec.picklist_line_id);
873: END IF;
874:
875: -- Debug Message
876: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
877: END Bind;
878:
879: PROCEDURE Gen_Select(
880: x_select_cl OUT NOCOPY VARCHAR2

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

881: )
882: IS
883: BEGIN
884: -- Debug Message
885: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
886:
887: x_select_cl := 'Select ' ||
888: 'CSP_PICKLIST_LINES_V.picklist_line_id,' ||
889: 'CSP_PICKLIST_LINES_V.CREATED_BY,' ||

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

916: 'CSP_PICKLIST_LINES_V.ATTRIBUTE14,' ||
917: 'CSP_PICKLIST_LINES_V.ATTRIBUTE15,' ||
918: 'from CSP_PICKLIST_LINES_V';
919: -- Debug Message
920: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
921:
922: END Gen_Select;
923:
924: PROCEDURE Gen_picklist_line_Where(

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

940: str_csr2 NUMBER;
941: l_operator VARCHAR2(10);
942: BEGIN
943: -- Debug Message
944: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
945:
946: -- There are three examples for each kind of datatype:
947: -- NUMBER, DATE, VARCHAR2.
948: -- Developer can copy and paste the following codes for your own record.

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

1026:
1027: -- Add more IF statements for each column below
1028:
1029: -- Debug Message
1030: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
1031:
1032: END Gen_picklist_line_Where;
1033:
1034: */

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

1037: PROCEDURE Validate_picklist_line_id (
1038: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1039: P_Validation_mode IN VARCHAR2,
1040: P_picklist_line_id IN NUMBER,
1041: -- 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.
1042: X_Return_Status OUT NOCOPY VARCHAR2,
1043: X_Msg_Count OUT NOCOPY NUMBER,
1044: X_Msg_Data OUT NOCOPY VARCHAR2
1045: )

Line 1062: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_line_id)');

1058:
1059: -- validate NOT NULL column
1060: IF(p_picklist_line_id is NULL)
1061: THEN
1062: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_line_id)');
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1065:
1066: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1066: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1062: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_line_id)');
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1065:
1066: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1067: THEN
1068: -- Hint: Validate data
1069: -- IF p_picklist_line_id is not NULL and p_picklist_line_id <> G_MISS_CHAR
1070: -- verify if data is valid

Line 1073: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1069: -- IF p_picklist_line_id is not NULL and p_picklist_line_id <> G_MISS_CHAR
1070: -- verify if data is valid
1071: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1072: NULL;
1073: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1074: THEN
1075: -- Hint: Validate data
1076: -- IF p_picklist_line_id <> G_MISS_CHAR
1077: -- verify if data is valid

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

1091: PROCEDURE Validate_PICKLIST_LINE_NUMBER (
1092: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1093: P_Validation_mode IN VARCHAR2,
1094: P_PICKLIST_LINE_NUMBER IN NUMBER,
1095: -- 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.
1096: X_Return_Status OUT NOCOPY VARCHAR2,
1097: X_Msg_Count OUT NOCOPY NUMBER,
1098: X_Msg_Data OUT NOCOPY VARCHAR2
1099: )

Line 1116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(PICKLIST_LINE_NUMBER)');

1112:
1113: -- validate NOT NULL column
1114: IF(p_PICKLIST_LINE_NUMBER is NULL)
1115: THEN
1116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(PICKLIST_LINE_NUMBER)');
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: END IF;
1119:
1120: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1120: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1116: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(PICKLIST_LINE_NUMBER)');
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: END IF;
1119:
1120: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1121: THEN
1122: -- Hint: Validate data
1123: -- IF p_PICKLIST_LINE_NUMBER is not NULL and p_PICKLIST_LINE_NUMBER <> G_MISS_CHAR
1124: -- verify if data is valid

Line 1127: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1123: -- IF p_PICKLIST_LINE_NUMBER is not NULL and p_PICKLIST_LINE_NUMBER <> G_MISS_CHAR
1124: -- verify if data is valid
1125: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1126: NULL;
1127: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1128: THEN
1129: -- Hint: Validate data
1130: -- IF p_PICKLIST_LINE_NUMBER <> G_MISS_CHAR
1131: -- verify if data is valid

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

1145: PROCEDURE Validate_picklist_header_id (
1146: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1147: P_Validation_mode IN VARCHAR2,
1148: P_picklist_header_id IN NUMBER,
1149: -- 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.
1150: X_Return_Status OUT NOCOPY VARCHAR2,
1151: X_Msg_Count OUT NOCOPY NUMBER,
1152: X_Msg_Data OUT NOCOPY VARCHAR2
1153: )

Line 1170: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_header_id)');

1166:
1167: -- validate NOT NULL column
1168: IF(p_picklist_header_id is NULL)
1169: THEN
1170: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_header_id)');
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: END IF;
1173:
1174: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1174: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1170: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(picklist_header_id)');
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: END IF;
1173:
1174: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1175: THEN
1176: -- Hint: Validate data
1177: -- IF p_picklist_header_id is not NULL and p_picklist_header_id <> G_MISS_CHAR
1178: -- verify if data is valid

Line 1181: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1177: -- IF p_picklist_header_id is not NULL and p_picklist_header_id <> G_MISS_CHAR
1178: -- verify if data is valid
1179: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1180: NULL;
1181: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1182: THEN
1183: -- Hint: Validate data
1184: -- IF p_picklist_header_id <> G_MISS_CHAR
1185: -- verify if data is valid

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

1199: PROCEDURE Validate_LINE_ID (
1200: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1201: P_Validation_mode IN VARCHAR2,
1202: P_LINE_ID IN NUMBER,
1203: -- 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.
1204: X_Return_Status OUT NOCOPY VARCHAR2,
1205: X_Msg_Count OUT NOCOPY NUMBER,
1206: X_Msg_Data OUT NOCOPY VARCHAR2
1207: )

Line 1224: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(LINE_ID)');

1220:
1221: -- validate NOT NULL column
1222: IF(p_LINE_ID is NULL)
1223: THEN
1224: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(LINE_ID)');
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: END IF;
1227:
1228: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1228: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1224: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(LINE_ID)');
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: END IF;
1227:
1228: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1229: THEN
1230: -- Hint: Validate data
1231: -- IF p_LINE_ID is not NULL and p_LINE_ID <> G_MISS_CHAR
1232: -- verify if data is valid

Line 1235: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1231: -- IF p_LINE_ID is not NULL and p_LINE_ID <> G_MISS_CHAR
1232: -- verify if data is valid
1233: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1234: NULL;
1235: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1236: THEN
1237: -- Hint: Validate data
1238: -- IF p_LINE_ID <> G_MISS_CHAR
1239: -- verify if data is valid

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

1253: PROCEDURE Validate_INVENTORY_ITEM_ID (
1254: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1255: P_Validation_mode IN VARCHAR2,
1256: P_INVENTORY_ITEM_ID IN NUMBER,
1257: -- 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.
1258: X_Return_Status OUT NOCOPY VARCHAR2,
1259: X_Msg_Count OUT NOCOPY NUMBER,
1260: X_Msg_Data OUT NOCOPY VARCHAR2
1261: )

Line 1278: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');

1274:
1275: -- validate NOT NULL column
1276: IF(p_INVENTORY_ITEM_ID is NULL)
1277: THEN
1278: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: END IF;
1281:
1282: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1282: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1278: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: END IF;
1281:
1282: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1283: THEN
1284: -- Hint: Validate data
1285: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1286: -- verify if data is valid

Line 1289: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1285: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1286: -- verify if data is valid
1287: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1288: NULL;
1289: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1290: THEN
1291: -- Hint: Validate data
1292: -- IF p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1293: -- verify if data is valid

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

1307: PROCEDURE Validate_UOM_CODE (
1308: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1309: P_Validation_mode IN VARCHAR2,
1310: P_UOM_CODE IN VARCHAR2,
1311: -- 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.
1312: X_Return_Status OUT NOCOPY VARCHAR2,
1313: X_Msg_Count OUT NOCOPY NUMBER,
1314: X_Msg_Data OUT NOCOPY VARCHAR2
1315: )

Line 1332: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(UOM_CODE)');

1328:
1329: -- validate NOT NULL column
1330: IF(p_UOM_CODE is NULL)
1331: THEN
1332: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(UOM_CODE)');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: END IF;
1335:
1336: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1336: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1332: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(UOM_CODE)');
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: END IF;
1335:
1336: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1337: THEN
1338: -- Hint: Validate data
1339: -- IF p_UOM_CODE is not NULL and p_UOM_CODE <> G_MISS_CHAR
1340: -- verify if data is valid

Line 1343: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1339: -- IF p_UOM_CODE is not NULL and p_UOM_CODE <> G_MISS_CHAR
1340: -- verify if data is valid
1341: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1342: NULL;
1343: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1344: THEN
1345: -- Hint: Validate data
1346: -- IF p_UOM_CODE <> G_MISS_CHAR
1347: -- verify if data is valid

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

1361: PROCEDURE Validate_REVISION (
1362: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1363: P_Validation_mode IN VARCHAR2,
1364: P_REVISION IN VARCHAR2,
1365: -- 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.
1366: X_Return_Status OUT NOCOPY VARCHAR2,
1367: X_Msg_Count OUT NOCOPY NUMBER,
1368: X_Msg_Data OUT NOCOPY VARCHAR2
1369: )

Line 1383: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1379:
1380: -- Initialize API return status to SUCCESS
1381: x_return_status := FND_API.G_RET_STS_SUCCESS;
1382:
1383: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1384: THEN
1385: -- Hint: Validate data
1386: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
1387: -- verify if data is valid

Line 1390: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1386: -- IF p_REVISION is not NULL and p_REVISION <> G_MISS_CHAR
1387: -- verify if data is valid
1388: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1389: NULL;
1390: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1391: THEN
1392: -- Hint: Validate data
1393: -- IF p_REVISION <> G_MISS_CHAR
1394: -- verify if data is valid

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

1408: PROCEDURE Validate_QUANTITY_PICKED (
1409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1410: P_Validation_mode IN VARCHAR2,
1411: P_QUANTITY_PICKED IN NUMBER,
1412: -- 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.
1413: X_Return_Status OUT NOCOPY VARCHAR2,
1414: X_Msg_Count OUT NOCOPY NUMBER,
1415: X_Msg_Data OUT NOCOPY VARCHAR2
1416: )

Line 1433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(QUANTITY_PICKED)');

1429:
1430: -- validate NOT NULL column
1431: IF(p_QUANTITY_PICKED is NULL)
1432: THEN
1433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(QUANTITY_PICKED)');
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: END IF;
1436:
1437: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1437: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(QUANTITY_PICKED)');
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: END IF;
1436:
1437: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1438: THEN
1439: -- Hint: Validate data
1440: -- IF p_QUANTITY_PICKED is not NULL and p_QUANTITY_PICKED <> G_MISS_CHAR
1441: -- verify if data is valid

Line 1444: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1440: -- IF p_QUANTITY_PICKED is not NULL and p_QUANTITY_PICKED <> G_MISS_CHAR
1441: -- verify if data is valid
1442: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1443: NULL;
1444: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1445: THEN
1446: -- Hint: Validate data
1447: -- IF p_QUANTITY_PICKED <> G_MISS_CHAR
1448: -- verify if data is valid

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

1462: PROCEDURE Validate_TRANSACTION_TEMP_ID (
1463: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1464: P_Validation_mode IN VARCHAR2,
1465: P_TRANSACTION_TEMP_ID IN NUMBER,
1466: -- 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.
1467: X_Return_Status OUT NOCOPY VARCHAR2,
1468: X_Msg_Count OUT NOCOPY NUMBER,
1469: X_Msg_Data OUT NOCOPY VARCHAR2
1470: )

Line 1487: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(TRANSACTION_TEMP_ID)');

1483:
1484: -- validate NOT NULL column
1485: IF(p_TRANSACTION_TEMP_ID is NULL)
1486: THEN
1487: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(TRANSACTION_TEMP_ID)');
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: END IF;
1490:
1491: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1491: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1487: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_lines API: -Violate NOT NULL constraint(TRANSACTION_TEMP_ID)');
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: END IF;
1490:
1491: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1492: THEN
1493: -- Hint: Validate data
1494: -- IF p_TRANSACTION_TEMP_ID is not NULL and p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
1495: -- verify if data is valid

Line 1498: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1494: -- IF p_TRANSACTION_TEMP_ID is not NULL and p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
1495: -- verify if data is valid
1496: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1497: NULL;
1498: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1499: THEN
1500: -- Hint: Validate data
1501: -- IF p_TRANSACTION_TEMP_ID <> G_MISS_CHAR
1502: -- verify if data is valid

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

1513: END Validate_TRANSACTION_TEMP_ID;
1514:
1515:
1516: -- Hint: inter-field level validation can be added here.
1517: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1518: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1519: -- stored in database table.
1520: PROCEDURE Validate_picklist_line_rec(
1521: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1547: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'API_INVALID_RECORD');

1543: -- THEN
1544: -- x_return_status := FND_API.G_RET_STS_ERROR;
1545:
1546: -- Debug Message
1547: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'API_INVALID_RECORD');
1548:
1549: -- Standard call to get message count and if count is 1, get message info.
1550: FND_MSG_PUB.Count_And_Get
1551: ( p_count => x_msg_count,

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

1567: l_api_name CONSTANT VARCHAR2(30) := 'Validate_picklist_lines';
1568: BEGIN
1569:
1570: -- Debug Message
1571: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'Private API: ' || l_api_name || 'start');
1572:
1573:
1574: -- Initialize API return status to SUCCESS
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1573:
1574: -- Initialize API return status to SUCCESS
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1578: -- Hint: We provide validation procedure for every column. Developer should delete
1579: -- unnecessary validation procedures.
1580: Validate_picklist_line_id(
1581: p_init_msg_list => FND_API.G_FALSE,

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

1686: END IF;
1687:
1688: END IF;
1689:
1690: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1691: -- Hint: Inter-field level validation can be added here
1692: -- invoke record level validation procedures
1693: Validate_picklist_line_Rec(
1694: p_init_msg_list => FND_API.G_FALSE,

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

1702: raise FND_API.G_EXC_ERROR;
1703: END IF;
1704: END IF;
1705:
1706: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1707: -- invoke inter-record level validation procedures
1708: NULL;
1709: END IF;
1710:

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

1707: -- invoke inter-record level validation procedures
1708: NULL;
1709: END IF;
1710:
1711: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1712: -- invoke inter-entity level validation procedures
1713: NULL;
1714: END IF;
1715:

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

1714: END IF;
1715:
1716:
1717: -- Debug Message
1718: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR','Private API: ' || l_api_name || 'end');
1719:
1720: END Validate_picklist_lines;
1721:
1722: End CSP_picklist_lines_PVT;