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

Line 58: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '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, '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,'Private API: Validate_picklist_header');

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,'Private API: Validate_picklist_header');
117:
118: -- Invoke validation procedures
119: Validate_picklist_header(
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_header(
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_PICK_HEADER_Rec => P_PICK_HEADER_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);

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

133:
134: -- Hint: Add corresponding Master-Detail business logic here if necessary.
135:
136: -- Debug Message
137: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
138:
139:
140: -- assign p_pick_header_rec.picklist_header_id to x_picklist_header_id
141: x_picklist_header_id := p_pick_header_rec.picklist_header_id;

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

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

Line 219: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 223: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 229: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 233: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 239: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 242: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 243: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

323: END IF;
324:
325:
326: -- Debug Message
327: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
328:
329:
330: -- Initialize API return status to SUCCESS
331: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: -- Debug Message
368: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
369:
370: /*
371: Open C_Get_picklist_header( l_tar_PICK_HEADER_rec.picklist_header_id);
372:

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

409: END IF;
410: raise FND_API.G_EXC_ERROR;
411: END IF;
412: -- Debug Message
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
414: Close C_Get_picklist_header;
415: */
416:
417:

Line 443: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_picklist_header');

439:
440: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
441: THEN
442: -- Debug message
443: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_picklist_header');
444:
445: -- Invoke validation procedures
446: Validate_picklist_header(
447: p_init_msg_list => FND_API.G_FALSE,

Line 449: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

445: -- Invoke validation procedures
446: Validate_picklist_header(
447: p_init_msg_list => FND_API.G_FALSE,
448: p_validation_level => p_validation_level,
449: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
450: P_PICK_HEADER_Rec => P_PICK_HEADER_Rec,
451: x_return_status => x_return_status,
452: x_msg_count => x_msg_count,
453: x_msg_data => x_msg_data);

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

459:
460: -- Hint: Add corresponding Master-Detail business logic here if necessary.
461:
462: -- Debug Message
463: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
464:
465: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Update_Row)
466: CSP_PICKLIST_HEADERS_PKG.Update_Row(
467: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id,

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

502: END IF;
503:
504:
505: -- Debug Message
506: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
507:
508:
509: -- Standard call to get message count and if count is 1, get message info.
510: FND_MSG_PUB.Count_And_Get

Line 535: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

531: END IF;
532: */
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
536: P_API_NAME => L_API_NAME
537: ,P_PKG_NAME => G_PKG_NAME
538: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
539: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 539: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

535: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
536: P_API_NAME => L_API_NAME
537: ,P_PKG_NAME => G_PKG_NAME
538: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
539: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
540: ,X_MSG_COUNT => X_MSG_COUNT
541: ,X_MSG_DATA => X_MSG_DATA
542: ,X_RETURN_STATUS => X_RETURN_STATUS);
543:

Line 545: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

541: ,X_MSG_DATA => X_MSG_DATA
542: ,X_RETURN_STATUS => X_RETURN_STATUS);
543:
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
546: P_API_NAME => L_API_NAME
547: ,P_PKG_NAME => G_PKG_NAME
548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
549: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 549: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

545: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
546: P_API_NAME => L_API_NAME
547: ,P_PKG_NAME => G_PKG_NAME
548: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
549: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
550: ,X_MSG_COUNT => X_MSG_COUNT
551: ,X_MSG_DATA => X_MSG_DATA
552: ,X_RETURN_STATUS => X_RETURN_STATUS);
553:

Line 555: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

551: ,X_MSG_DATA => X_MSG_DATA
552: ,X_RETURN_STATUS => X_RETURN_STATUS);
553:
554: WHEN OTHERS THEN
555: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
556: P_API_NAME => L_API_NAME
557: ,P_PKG_NAME => G_PKG_NAME
558: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
559: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 558: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

554: WHEN OTHERS THEN
555: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
556: P_API_NAME => L_API_NAME
557: ,P_PKG_NAME => G_PKG_NAME
558: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
559: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
560: ,X_MSG_COUNT => X_MSG_COUNT
561: ,X_MSG_DATA => X_MSG_DATA
562: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 559: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

555: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
556: P_API_NAME => L_API_NAME
557: ,P_PKG_NAME => G_PKG_NAME
558: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
559: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
560: ,X_MSG_COUNT => X_MSG_COUNT
561: ,X_MSG_DATA => X_MSG_DATA
562: ,X_RETURN_STATUS => X_RETURN_STATUS);
563: End Update_picklist_header;

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

602: END IF;
603:
604:
605: -- Debug Message
606: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
607:
608:
609: -- Initialize API return status to SUCCESS
610: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

643: RAISE FND_API.G_EXC_ERROR;
644: END IF;
645: */
646: -- Debug Message
647: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
648:
649: -- Invoke table handler(CSP_PICKLIST_HEADERS_PKG.Delete_Row)
650: CSP_PICKLIST_HEADERS_PKG.Delete_Row(
651: p_picklist_header_id => p_PICK_HEADER_rec.picklist_header_id);

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

660: END IF;
661:
662:
663: -- Debug Message
664: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
665:
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get

Line 693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

689: END IF;
690: */
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

693: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
694: P_API_NAME => L_API_NAME
695: ,P_PKG_NAME => G_PKG_NAME
696: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
697: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
698: ,X_MSG_COUNT => X_MSG_COUNT
699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);
701:

Line 703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

699: ,X_MSG_DATA => X_MSG_DATA
700: ,X_RETURN_STATUS => X_RETURN_STATUS);
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
704: P_API_NAME => L_API_NAME
705: ,P_PKG_NAME => G_PKG_NAME
706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
704: P_API_NAME => L_API_NAME
705: ,P_PKG_NAME => G_PKG_NAME
706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
708: ,X_MSG_COUNT => X_MSG_COUNT
709: ,X_MSG_DATA => X_MSG_DATA
710: ,X_RETURN_STATUS => X_RETURN_STATUS);
711:

Line 713: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

709: ,X_MSG_DATA => X_MSG_DATA
710: ,X_RETURN_STATUS => X_RETURN_STATUS);
711:
712: WHEN OTHERS THEN
713: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
714: P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
717: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 716: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

712: WHEN OTHERS THEN
713: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
714: P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
717: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
718: ,X_MSG_COUNT => X_MSG_COUNT
719: ,X_MSG_DATA => X_MSG_DATA
720: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 717: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

713: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
714: P_API_NAME => L_API_NAME
715: ,P_PKG_NAME => G_PKG_NAME
716: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
717: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
718: ,X_MSG_COUNT => X_MSG_COUNT
719: ,X_MSG_DATA => X_MSG_DATA
720: ,X_RETURN_STATUS => X_RETURN_STATUS);
721: End Delete_picklist_header;

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

728: )
729: IS
730: BEGIN
731: -- Debug Message
732: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
733:
734: -- define all columns for CSP_PICKLIST_HEADERS_V view
735: dbms_sql.define_column(p_cur_get_PICK_HEADER, 1, P_PICK_HEADER_Rec.picklist_header_id);
736: dbms_sql.define_column(p_cur_get_PICK_HEADER, 2, P_PICK_HEADER_Rec.ORGANIZATION_ID);

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

755: dbms_sql.define_column(p_cur_get_PICK_HEADER, 21, P_PICK_HEADER_Rec.ATTRIBUTE14, 240);
756: dbms_sql.define_column(p_cur_get_PICK_HEADER, 22, P_PICK_HEADER_Rec.ATTRIBUTE15, 240);
757:
758: -- Debug Message
759: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
760: END Define_Columns;
761:
762: -- This procudure gets column values by the Dynamic SQL.
763: PROCEDURE Get_Column_Values(

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

766: )
767: IS
768: BEGIN
769: -- Debug Message
770: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
771:
772: -- get all column values for CSP_PICKLIST_HEADERS_V table
773: dbms_sql.column_value(p_cur_get_PICK_HEADER, 1, X_PICK_HEADER_Rec.picklist_header_id);
774: dbms_sql.column_value(p_cur_get_PICK_HEADER, 2, X_PICK_HEADER_Rec.ORGANIZATION_ID);

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

793: dbms_sql.column_value(p_cur_get_PICK_HEADER, 21, X_PICK_HEADER_Rec.ATTRIBUTE14);
794: dbms_sql.column_value(p_cur_get_PICK_HEADER, 22, X_PICK_HEADER_Rec.ATTRIBUTE15);
795:
796: -- Debug Message
797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
798: END Get_Column_Values;
799:
800: PROCEDURE Gen_PICK_HEADER_order_cl(
801: p_order_by_rec IN CSP_picklist_header_PUB.PICK_HEADER_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, 'Private API: Generate Order by Begins');
813:

Line 812: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, '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, '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, '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, '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, '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, '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, 'Private API: Generate Order by Ends');
840: END Gen_PICK_HEADER_order_cl;
841:
842: -- This procedure bind the variables for the Dynamic SQL
843: PROCEDURE Bind(

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

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

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

859: DBMS_SQL.BIND_VARIABLE(p_cur_get_PICK_HEADER, ':p_picklist_header_id', P_PICK_HEADER_Rec.picklist_header_id);
860: END IF;
861:
862: -- Debug Message
863: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
864: END Bind;
865:
866: PROCEDURE Gen_Select(
867: x_select_cl OUT NOCOPY VARCHAR2

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

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

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

900: 'CSP_PICKLIST_HEADERS_V.ATTRIBUTE14,' ||
901: 'CSP_PICKLIST_HEADERS_V.ATTRIBUTE15,' ||
902: 'from CSP_PICKLIST_HEADERS_V';
903: -- Debug Message
904: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
905:
906: END Gen_Select;
907:
908: PROCEDURE Gen_PICK_HEADER_Where(

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

924: str_csr2 NUMBER;
925: l_operator VARCHAR2(10);
926: BEGIN
927: -- Debug Message
928: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
929:
930: -- There are three examples for each kind of datatype:
931: -- NUMBER, DATE, VARCHAR2.
932: -- Developer can copy and paste the following codes for your own record.

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

1010:
1011: -- Add more IF statements for each column below
1012:
1013: -- Debug Message
1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
1015:
1016: END Gen_PICK_HEADER_Where;
1017:
1018: */

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

1020: PROCEDURE Validate_picklist_header_id (
1021: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1022: P_Validation_mode IN VARCHAR2,
1023: P_picklist_header_id IN NUMBER,
1024: -- 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.
1025: X_Return_Status OUT NOCOPY VARCHAR2,
1026: X_Msg_Count OUT NOCOPY NUMBER,
1027: X_Msg_Data OUT NOCOPY VARCHAR2
1028: )

Line 1045: --JTF_PLSQL_API.Debug_Message('ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');

1041:
1042: -- validate NOT NULL column
1043: IF(p_picklist_header_id is NULL)
1044: THEN
1045: --JTF_PLSQL_API.Debug_Message('ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');
1046:
1047: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: END IF;

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

1043: IF(p_picklist_header_id is NULL)
1044: THEN
1045: --JTF_PLSQL_API.Debug_Message('ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');
1046:
1047: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: END IF;
1050:
1051: IF(p_validation_mode =JTF_PLSQL_API.G_CREATE)

Line 1051: IF(p_validation_mode =JTF_PLSQL_API.G_CREATE)

1047: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(picklist_header_id)');
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: END IF;
1050:
1051: IF(p_validation_mode =JTF_PLSQL_API.G_CREATE)
1052: THEN
1053: -- Hint: Validate data
1054: -- IF p_picklist_header_id is not NULL and p_picklist_header_id <> G_MISS_CHAR
1055: -- verify if data is valid

Line 1058: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1054: -- IF p_picklist_header_id is not NULL and p_picklist_header_id <> G_MISS_CHAR
1055: -- verify if data is valid
1056: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1057: NULL;
1058: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1059: THEN
1060: -- Hint: Validate data
1061: -- IF p_picklist_header_id <> G_MISS_CHAR
1062: -- verify if data is valid

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

1076: PROCEDURE Validate_ORGANIZATION_ID (
1077: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1078: P_Validation_mode IN VARCHAR2,
1079: P_ORGANIZATION_ID IN NUMBER,
1080: -- 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.
1081: X_Return_Status OUT NOCOPY VARCHAR2,
1082: X_Msg_Count OUT NOCOPY NUMBER,
1083: X_Msg_Data OUT NOCOPY VARCHAR2
1084: )

Line 1101: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(ORGANIZATION_ID)');

1097:
1098: -- validate NOT NULL column
1099: IF(p_ORGANIZATION_ID is NULL)
1100: THEN
1101: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: END IF;
1104:
1105: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1105: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1101: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: END IF;
1104:
1105: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1106: THEN
1107: -- Hint: Validate data
1108: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1109: -- verify if data is valid

Line 1112: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1108: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1109: -- verify if data is valid
1110: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1111: NULL;
1112: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1113: THEN
1114: -- Hint: Validate data
1115: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
1116: -- verify if data is valid

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

1130: PROCEDURE Validate_PICKLIST_NUMBER (
1131: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1132: P_Validation_mode IN VARCHAR2,
1133: P_PICKLIST_NUMBER IN VARCHAR2,
1134: -- 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.
1135: X_Return_Status OUT NOCOPY VARCHAR2,
1136: X_Msg_Count OUT NOCOPY NUMBER,
1137: X_Msg_Data OUT NOCOPY VARCHAR2
1138: )

Line 1152: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1148:
1149: -- Initialize API return status to SUCCESS
1150: x_return_status := FND_API.G_RET_STS_SUCCESS;
1151:
1152: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1153: THEN
1154: -- Hint: Validate data
1155: -- IF p_PICKLIST_NUMBER is not NULL and p_PICKLIST_NUMBER <> G_MISS_CHAR
1156: -- verify if data is valid

Line 1159: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1155: -- IF p_PICKLIST_NUMBER is not NULL and p_PICKLIST_NUMBER <> G_MISS_CHAR
1156: -- verify if data is valid
1157: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1158: NULL;
1159: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1160: THEN
1161: -- Hint: Validate data
1162: -- IF p_PICKLIST_NUMBER <> G_MISS_CHAR
1163: -- verify if data is valid

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

1177: PROCEDURE Validate_PICKLIST_STATUS (
1178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1179: P_Validation_mode IN VARCHAR2,
1180: P_PICKLIST_STATUS IN VARCHAR2,
1181: -- 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.
1182: X_Return_Status OUT NOCOPY VARCHAR2,
1183: X_Msg_Count OUT NOCOPY NUMBER,
1184: X_Msg_Data OUT NOCOPY VARCHAR2
1185: )

Line 1202: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(PICKLIST_STATUS)');

1198:
1199: -- validate NOT NULL column
1200: IF(p_PICKLIST_STATUS is NULL)
1201: THEN
1202: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(PICKLIST_STATUS)');
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END IF;
1205:
1206: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1206: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1202: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'ERROR', 'Private picklist_header API: -Violate NOT NULL constraint(PICKLIST_STATUS)');
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END IF;
1205:
1206: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1207: THEN
1208: -- Hint: Validate data
1209: -- IF p_PICKLIST_STATUS is not NULL and p_PICKLIST_STATUS <> G_MISS_CHAR
1210: -- verify if data is valid

Line 1213: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1209: -- IF p_PICKLIST_STATUS is not NULL and p_PICKLIST_STATUS <> G_MISS_CHAR
1210: -- verify if data is valid
1211: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1212: NULL;
1213: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1214: THEN
1215: -- Hint: Validate data
1216: -- IF p_PICKLIST_STATUS <> G_MISS_CHAR
1217: -- verify if data is valid

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

1231: PROCEDURE Validate_DATE_CREATED (
1232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1233: P_Validation_mode IN VARCHAR2,
1234: P_DATE_CREATED IN DATE,
1235: -- 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.
1236: X_Return_Status OUT NOCOPY VARCHAR2,
1237: X_Msg_Count OUT NOCOPY NUMBER,
1238: X_Msg_Data OUT NOCOPY VARCHAR2
1239: )

Line 1253: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1249:
1250: -- Initialize API return status to SUCCESS
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252:
1253: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1254: THEN
1255: -- Hint: Validate data
1256: -- IF p_DATE_CREATED is not NULL and p_DATE_CREATED <> G_MISS_CHAR
1257: -- verify if data is valid

Line 1260: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1256: -- IF p_DATE_CREATED is not NULL and p_DATE_CREATED <> 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_DATE_CREATED <> 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_DATE_CONFIRMED (
1279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1280: P_Validation_mode IN VARCHAR2,
1281: P_DATE_CONFIRMED IN DATE,
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 1300: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1296:
1297: -- Initialize API return status to SUCCESS
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;
1299:
1300: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1301: THEN
1302: -- Hint: Validate data
1303: -- IF p_DATE_CONFIRMED is not NULL and p_DATE_CONFIRMED <> G_MISS_CHAR
1304: -- verify if data is valid

Line 1307: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

1322: END Validate_DATE_CONFIRMED;
1323:
1324:
1325: -- Hint: inter-field level validation can be added here.
1326: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1327: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1328: -- stored in database table.
1329: PROCEDURE Validate_PICK_HEADER_rec(
1330: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1356: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', 'API_INVALID_RECORD');

1352: -- THEN
1353: -- x_return_status := FND_API.G_RET_STS_ERROR;
1354:
1355: -- Debug Message
1356: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', 'API_INVALID_RECORD');
1357:
1358: -- Standard call to get message count and if count is 1, get message info.
1359: FND_MSG_PUB.Count_And_Get
1360: ( p_count => x_msg_count,

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

1376: l_api_name CONSTANT VARCHAR2(30) := 'Validate_picklist_header';
1377: BEGIN
1378:
1379: -- Debug Message
1380: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', 'Private API: ' || l_api_name || 'start');
1381:
1382:
1383: -- Initialize API return status to SUCCESS
1384: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1382:
1383: -- Initialize API return status to SUCCESS
1384: x_return_status := FND_API.G_RET_STS_SUCCESS;
1385:
1386: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1387: -- Hint: We provide validation procedure for every column. Developer should delete
1388: -- unnecessary validation procedures.
1389: Validate_picklist_header_id(
1390: p_init_msg_list => FND_API.G_FALSE,

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

1459: END IF;
1460:
1461: END IF;
1462:
1463: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1464: -- Hint: Inter-field level validation can be added here
1465: -- invoke record level validation procedures
1466: Validate_PICK_HEADER_Rec(
1467: p_init_msg_list => FND_API.G_FALSE,

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

1475: raise FND_API.G_EXC_ERROR;
1476: END IF;
1477: END IF;
1478:
1479: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1480: -- invoke inter-record level validation procedures
1481: NULL;
1482: END IF;
1483:

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

1480: -- invoke inter-record level validation procedures
1481: NULL;
1482: END IF;
1483:
1484: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1485: -- invoke inter-entity level validation procedures
1486: NULL;
1487: END IF;
1488:

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

1487: END IF;
1488:
1489:
1490: -- Debug Message
1491: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', 'Private API: ' || l_api_name || 'end');
1492:
1493: END Validate_picklist_header;
1494:
1495: End CSP_picklist_header_PVT;