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_ORDERLINES_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 117: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');

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

Line 123: p_validation_mode => JTF_PLSQL_API.G_CREATE,

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

Line 137: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', '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, 'CSP', 'Private API: Calling create table handler');
138:
139: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Insert_Row)
140: CSP_MOVEORDER_LINES_PKG.Insert_Row(
141: p_LINE_ID => p_mol_rec.LINE_ID,

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

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

Line 217: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 221: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 227: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 231: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 237: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 240: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 241: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

366:
367: */
368:
369: -- Debug Message
370: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
371:
372: /*
373: Open C_Get_orderlines( l_tar_mol_rec.LINE_ID);
374:

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

412: END IF;
413: raise FND_API.G_EXC_ERROR;
414: END IF;
415: -- Debug Message
416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
417: Close C_Get_orderlines;
418: */
419:
420: /* commented out by klou, 01/07/00

Line 446: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');

442: */
443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
444: THEN
445: -- Debug message
446: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderlines');
447:
448: -- Invoke validation procedures
449: Validate_orderlines(
450: p_init_msg_list => FND_API.G_FALSE,

Line 452: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

448: -- Invoke validation procedures
449: Validate_orderlines(
450: p_init_msg_list => FND_API.G_FALSE,
451: p_validation_level => p_validation_level,
452: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
453: P_mol_Rec => P_mol_Rec,
454: x_return_status => x_return_status,
455: x_msg_count => x_msg_count,
456: x_msg_data => x_msg_data);

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

462:
463: -- Hint: Add corresponding Master-Detail business logic here if necessary.
464:
465: -- Debug Message
466: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
467:
468: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Update_Row)
469: CSP_MOVEORDER_LINES_PKG.Update_Row(
470: p_LINE_ID => p_mol_rec.LINE_ID,

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

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

Line 539: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 543: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 549: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 553: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 559: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 562: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 563: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

648: RAISE FND_API.G_EXC_ERROR;
649: END IF;
650: */
651: -- Debug Message
652: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
653:
654: -- Invoke table handler(CSP_MOVEORDER_LINES_PKG.Delete_Row)
655: CSP_MOVEORDER_LINES_PKG.Delete_Row(
656: p_LINE_ID => p_mol_rec.LINE_ID);

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

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

Line 698: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 702: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 708: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 712: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 721: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

733: )
734: IS
735: BEGIN
736: -- Debug Message
737: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
738:
739: -- define all columns for CSP_MOVEORDER_LINES_V view
740: dbms_sql.define_column(p_cur_get_mol, 1, P_mol_Rec.LINE_ID);
741: dbms_sql.define_column(p_cur_get_mol, 2, P_mol_Rec.LAST_UPDATED_LOGIN);

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

762: dbms_sql.define_column(p_cur_get_mol, 23, P_mol_Rec.ATTRIBUTE14, 150);
763: dbms_sql.define_column(p_cur_get_mol, 24, P_mol_Rec.ATTRIBUTE15, 150);
764:
765: -- Debug Message
766: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
767: END Define_Columns;
768:
769: -- This procudure gets column values by the Dynamic SQL.
770: PROCEDURE Get_Column_Values(

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

773: )
774: IS
775: BEGIN
776: -- Debug Message
777: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
778:
779: -- get all column values for CSP_MOVEORDER_LINES_V table
780: dbms_sql.column_value(p_cur_get_mol, 1, X_mol_Rec.LINE_ID);
781: dbms_sql.column_value(p_cur_get_mol, 2, X_mol_Rec.LAST_UPDATED_LOGIN);

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

802: dbms_sql.column_value(p_cur_get_mol, 23, X_mol_Rec.ATTRIBUTE14);
803: dbms_sql.column_value(p_cur_get_mol, 24, X_mol_Rec.ATTRIBUTE15);
804:
805: -- Debug Message
806: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
807: END Get_Column_Values;
808:
809: PROCEDURE Gen_mol_order_cl(
810: p_order_by_rec IN CSP_ORDERLINES_PUB.mol_sort_rec_type,

Line 818: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

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

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

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

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

825: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
826: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
827:
828: -- Debug Message
829: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
830:
831: JTF_PLSQL_API.Translate_OrderBy(
832: p_api_version_number => 1.0
833: ,p_init_msg_list => FND_API.G_FALSE

Line 831: JTF_PLSQL_API.Translate_OrderBy(

827:
828: -- Debug Message
829: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
830:
831: JTF_PLSQL_API.Translate_OrderBy(
832: p_api_version_number => 1.0
833: ,p_init_msg_list => FND_API.G_FALSE
834: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
835: ,p_order_by_tbl => l_util_order_by_tbl

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

844: x_order_by_cl := NULL;
845: END IF;
846:
847: -- Debug Message
848: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
849: END Gen_mol_order_cl;
850:
851: -- This procedure bind the variables for the Dynamic SQL
852: PROCEDURE Bind(

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

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

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

868: DBMS_SQL.BIND_VARIABLE(p_cur_get_mol, ':p_LINE_ID', P_mol_Rec.LINE_ID);
869: END IF;
870:
871: -- Debug Message
872: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
873: END Bind;
874:
875: PROCEDURE Gen_Select(
876: x_select_cl OUT NOCOPY VARCHAR2

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

877: )
878: IS
879: BEGIN
880: -- Debug Message
881: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
882:
883: x_select_cl := 'Select ' ||
884: 'CSP_MOVEORDER_LINES_V.LINE_ID,' ||
885: 'CSP_MOVEORDER_LINES_V.CREATED_BY,' ||

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

910: 'CSP_MOVEORDER_LINES_V.ATTRIBUTE14,' ||
911: 'CSP_MOVEORDER_LINES_V.ATTRIBUTE15,' ||
912: 'from CSP_MOVEORDER_LINES_V';
913: -- Debug Message
914: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
915:
916: END Gen_Select;
917:
918: PROCEDURE Gen_mol_Where(

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

934: str_csr2 NUMBER;
935: l_operator VARCHAR2(10);
936: BEGIN
937: -- Debug Message
938: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
939:
940: -- There are three examples for each kind of datatype:
941: -- NUMBER, DATE, VARCHAR2.
942: -- Developer can copy and paste the following codes for your own record.

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

1020:
1021: -- Add more IF statements for each column below
1022:
1023: -- Debug Message
1024: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1025:
1026: END Gen_mol_Where;
1027:
1028: -- Item-level validation procedures

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

1030: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1031: P_Validation_mode IN VARCHAR2,
1032: P_LINE_ID IN NUMBER,
1033: P_HEADER_ID IN NUMBER, -- added for valiation of line_id 06-DEC-99, VL.
1034: -- 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.
1035: X_Return_Status OUT NOCOPY VARCHAR2,
1036: X_Msg_Count OUT NOCOPY NUMBER,
1037: X_Msg_Data OUT NOCOPY VARCHAR2
1038: )

Line 1056: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(LINE_ID)');

1052:
1053: -- validate NOT NULL column
1054: IF(p_LINE_ID is NULL)
1055: THEN
1056: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(LINE_ID)');
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059:
1060: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1060: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1056: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(LINE_ID)');
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059:
1060: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1061: THEN
1062: NULL;
1063: -- Hint: Validate data
1064: -- IF p_LINE_ID is not NULL and p_LINE_ID <> G_MISS_CHAR

Line 1086: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1082: x_msg_count := x_msg_count + 1;
1083: x_msg_data := 'Unexpected errors found. Please check the Line ID and Header ID.';
1084: END;
1085: */
1086: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1087: THEN
1088: -- Hint: Validate data
1089: -- IF p_LINE_ID <> G_MISS_CHAR
1090: -- verify if data is valid

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

1104: PROCEDURE Validate_LAST_UPDATED_LOGIN (
1105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1106: P_Validation_mode IN VARCHAR2,
1107: P_LAST_UPDATED_LOGIN IN NUMBER,
1108: -- 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.
1109: X_Return_Status OUT NOCOPY VARCHAR2,
1110: X_Msg_Count OUT NOCOPY NUMBER,
1111: X_Msg_Data OUT NOCOPY VARCHAR2
1112: )

Line 1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1122:
1123: -- Initialize API return status to SUCCESS
1124: x_return_status := FND_API.G_RET_STS_SUCCESS;
1125:
1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1127: THEN
1128: -- Hint: Validate data
1129: -- IF p_LAST_UPDATED_LOGIN is not NULL and p_LAST_UPDATED_LOGIN <> G_MISS_CHAR
1130: -- verify if data is valid

Line 1133: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1129: -- IF p_LAST_UPDATED_LOGIN is not NULL and p_LAST_UPDATED_LOGIN <> G_MISS_CHAR
1130: -- verify if data is valid
1131: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1132: NULL;
1133: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1134: THEN
1135: -- Hint: Validate data
1136: -- IF p_LAST_UPDATED_LOGIN <> G_MISS_CHAR
1137: -- verify if data is valid

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

1151: PROCEDURE Validate_HEADER_ID (
1152: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1153: P_Validation_mode IN VARCHAR2,
1154: P_HEADER_ID IN NUMBER,
1155: -- 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.
1156: X_Return_Status OUT NOCOPY VARCHAR2,
1157: X_Msg_Count OUT NOCOPY NUMBER,
1158: X_Msg_Data OUT NOCOPY VARCHAR2
1159: )

Line 1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(HEADER_ID)');

1172:
1173: -- validate NOT NULL column
1174: IF(p_HEADER_ID is NULL)
1175: THEN
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(HEADER_ID)');
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: END IF;
1179:
1180: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1180: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderlines API: -Violate NOT NULL constraint(HEADER_ID)');
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: END IF;
1179:
1180: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1181: THEN
1182: -- Hint: Validate data
1183: -- IF p_HEADER_ID is not NULL and p_HEADER_ID <> G_MISS_CHAR
1184: -- verify if data is valid

Line 1187: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1183: -- IF p_HEADER_ID is not NULL and p_HEADER_ID <> G_MISS_CHAR
1184: -- verify if data is valid
1185: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1186: NULL;
1187: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1188: THEN
1189: -- Hint: Validate data
1190: -- IF p_HEADER_ID <> G_MISS_CHAR
1191: -- verify if data is valid

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

1205: PROCEDURE Validate_CUSTOMER_PO (
1206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1207: P_Validation_mode IN VARCHAR2,
1208: P_CUSTOMER_PO IN VARCHAR2,
1209: -- 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.
1210: X_Return_Status OUT NOCOPY VARCHAR2,
1211: X_Msg_Count OUT NOCOPY NUMBER,
1212: X_Msg_Data OUT NOCOPY VARCHAR2
1213: )

Line 1227: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1223:
1224: -- Initialize API return status to SUCCESS
1225: x_return_status := FND_API.G_RET_STS_SUCCESS;
1226:
1227: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1228: THEN
1229: -- Hint: Validate data
1230: -- IF p_CUSTOMER_PO is not NULL and p_CUSTOMER_PO <> G_MISS_CHAR
1231: -- verify if data is valid

Line 1234: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1274: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1270:
1271: -- Initialize API return status to SUCCESS
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273:
1274: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1275: THEN
1276: -- Hint: Validate data
1277: -- IF p_INCIDENT_ID is not NULL and p_INCIDENT_ID <> G_MISS_CHAR
1278: -- verify if data is valid

Line 1281: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1277: -- IF p_INCIDENT_ID is not NULL and p_INCIDENT_ID <> G_MISS_CHAR
1278: -- verify if data is valid
1279: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1280: NULL;
1281: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1282: THEN
1283: -- Hint: Validate data
1284: -- IF p_INCIDENT_ID <> G_MISS_CHAR
1285: -- verify if data is valid

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

1299: PROCEDURE Validate_TASK_ID (
1300: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1301: P_Validation_mode IN VARCHAR2,
1302: P_TASK_ID IN NUMBER,
1303: -- 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.
1304: X_Return_Status OUT NOCOPY VARCHAR2,
1305: X_Msg_Count OUT NOCOPY NUMBER,
1306: X_Msg_Data OUT NOCOPY VARCHAR2
1307: )

Line 1321: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1317:
1318: -- Initialize API return status to SUCCESS
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320:
1321: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1322: THEN
1323: -- Hint: Validate data
1324: -- IF p_TASK_ID is not NULL and p_TASK_ID <> G_MISS_CHAR
1325: -- verify if data is valid

Line 1328: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1324: -- IF p_TASK_ID is not NULL and p_TASK_ID <> G_MISS_CHAR
1325: -- verify if data is valid
1326: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1327: NULL;
1328: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1329: THEN
1330: -- Hint: Validate data
1331: -- IF p_TASK_ID <> G_MISS_CHAR
1332: -- verify if data is valid

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

1346: PROCEDURE Validate_TASK_ASSIGNMENT_ID (
1347: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1348: P_Validation_mode IN VARCHAR2,
1349: P_TASK_ASSIGNMENT_ID IN NUMBER,
1350: -- 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.
1351: X_Return_Status OUT NOCOPY VARCHAR2,
1352: X_Msg_Count OUT NOCOPY NUMBER,
1353: X_Msg_Data OUT NOCOPY VARCHAR2
1354: )

Line 1368: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1364:
1365: -- Initialize API return status to SUCCESS
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367:
1368: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1369: THEN
1370: -- Hint: Validate data
1371: -- IF p_TASK_ASSIGNMENT_ID is not NULL and p_TASK_ASSIGNMENT_ID <> G_MISS_CHAR
1372: -- verify if data is valid

Line 1375: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1415: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1411:
1412: -- Initialize API return status to SUCCESS
1413: x_return_status := FND_API.G_RET_STS_SUCCESS;
1414:
1415: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1416: THEN
1417: -- Hint: Validate data
1418: -- IF p_COMMENTS is not NULL and p_COMMENTS <> G_MISS_CHAR
1419: -- verify if data is valid

Line 1422: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1418: -- IF p_COMMENTS is not NULL and p_COMMENTS <> G_MISS_CHAR
1419: -- verify if data is valid
1420: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1421: NULL;
1422: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1423: THEN
1424: -- Hint: Validate data
1425: -- IF p_COMMENTS <> G_MISS_CHAR
1426: -- verify if data is valid

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

1437: END Validate_COMMENTS;
1438:
1439:
1440: -- Hint: inter-field level validation can be added here.
1441: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1442: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1443: -- stored in database table.
1444: PROCEDURE Validate_mol_rec(
1445: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1467: -- THEN
1468: -- x_return_status := FND_API.G_RET_STS_ERROR;
1469:
1470: -- Debug Message
1471: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1472:
1473: -- Standard call to get message count and if count is 1, get message info.
1474: FND_MSG_PUB.Count_And_Get
1475: ( p_count => x_msg_count,

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

1491: l_api_name CONSTANT VARCHAR2(30) := 'Validate_orderlines';
1492: BEGIN
1493:
1494: -- Debug Message
1495: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1496:
1497:
1498: -- Initialize API return status to SUCCESS
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1497:
1498: -- Initialize API return status to SUCCESS
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;
1500:
1501: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1502: -- Hint: We provide validation procedure for every column. Developer should delete
1503: -- unnecessary validation procedures.
1504: Validate_LINE_ID(
1505: p_init_msg_list => FND_API.G_FALSE,

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

1599: END IF;
1600:
1601: END IF;
1602:
1603: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1604: -- Hint: Inter-field level validation can be added here
1605: -- invoke record level validation procedures
1606: Validate_mol_Rec(
1607: p_init_msg_list => FND_API.G_FALSE,

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

1615: raise FND_API.G_EXC_ERROR;
1616: END IF;
1617: END IF;
1618:
1619: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1620: -- invoke inter-record level validation procedures
1621: NULL;
1622: END IF;
1623:

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

1620: -- invoke inter-record level validation procedures
1621: NULL;
1622: END IF;
1623:
1624: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1625: -- invoke inter-entity level validation procedures
1626: NULL;
1627: END IF;
1628:

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

1627: END IF;
1628:
1629:
1630: -- Debug Message
1631: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1632:
1633: END Validate_orderlines;
1634:
1635: End CSP_ORDERLINES_PVT;