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_ORDERHEADERS_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 122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderheaders');

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

Line 128: p_validation_mode => JTF_PLSQL_API.G_CREATE,

124: -- Invoke validation procedures
125: Validate_orderheaders(
126: p_init_msg_list => FND_API.G_FALSE,
127: p_validation_level => p_validation_level,
128: p_validation_mode => JTF_PLSQL_API.G_CREATE,
129: P_MOH_Rec => P_MOH_Rec,
130: x_return_status => x_return_status,
131: x_msg_count => x_msg_count,
132: x_msg_data => x_msg_data

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

139:
140: -- Hint: Add corresponding Master-Detail business logic here if necessary.
141:
142: -- Debug Message
143: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling create table handler');
144:
145:
146: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Insert_Row)
147: CSP_MOVEORDER_HEADERS_PKG.Insert_Row(

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

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

Line 223: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 227: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 233: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 237: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 243: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 246: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 247: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

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

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

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

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

433: END IF;
434: raise FND_API.G_EXC_ERROR;
435: END IF;
436: -- Debug Message
437: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
438: Close C_Get_orderheaders;
439: */
440:
441: /* uncommented out and will

Line 466: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderheaders');

462: */
463: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
464: THEN
465: -- Debug message
466: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_orderheaders');
467:
468: -- Invoke validation procedures
469: Validate_orderheaders(
470: p_init_msg_list => FND_API.G_FALSE,

Line 472: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

468: -- Invoke validation procedures
469: Validate_orderheaders(
470: p_init_msg_list => FND_API.G_FALSE,
471: p_validation_level => p_validation_level,
472: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
473: P_MOH_Rec => P_MOH_Rec,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data);

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

482:
483: -- Hint: Add corresponding Master-Detail business logic here if necessary.
484:
485: -- Debug Message
486: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
487:
488: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Update_Row)
489: CSP_MOVEORDER_HEADERS_PKG.Update_Row(
490: p_HEADER_ID => p_MOH_rec.HEADER_ID,

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

536: END IF;
537:
538:
539: -- Debug Message
540: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
541:
542:
543: -- Standard call to get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get

Line 569: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

565: END IF;
566: */
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME
571: ,P_PKG_NAME => G_PKG_NAME
572: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
573: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 573: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 579: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

575: ,X_MSG_DATA => X_MSG_DATA
576: ,X_RETURN_STATUS => X_RETURN_STATUS);
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
580: P_API_NAME => L_API_NAME
581: ,P_PKG_NAME => G_PKG_NAME
582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
583: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 583: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 589: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

585: ,X_MSG_DATA => X_MSG_DATA
586: ,X_RETURN_STATUS => X_RETURN_STATUS);
587:
588: WHEN OTHERS THEN
589: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
593: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 592: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

588: WHEN OTHERS THEN
589: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
593: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
594: ,X_MSG_COUNT => X_MSG_COUNT
595: ,X_MSG_DATA => X_MSG_DATA
596: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 593: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

589: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
593: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
594: ,X_MSG_COUNT => X_MSG_COUNT
595: ,X_MSG_DATA => X_MSG_DATA
596: ,X_RETURN_STATUS => X_RETURN_STATUS);
597: End Update_orderheaders;

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

636: END IF;
637:
638:
639: -- Debug Message
640: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
641:
642:
643: -- Initialize API return status to SUCCESS
644: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681: */
682: -- Debug Message
683: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
684:
685: -- Invoke table handler(CSP_MOVEORDER_HEADERS_PKG.Delete_Row)
686: CSP_MOVEORDER_HEADERS_PKG.Delete_Row(
687: p_HEADER_ID => p_MOH_rec.HEADER_ID);

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

696: END IF;
697:
698:
699: -- Debug Message
700: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
701:
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: FND_MSG_PUB.Count_And_Get

Line 729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

725: END IF;
726: */
727: EXCEPTION
728: WHEN FND_API.G_EXC_ERROR THEN
729: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
730: P_API_NAME => L_API_NAME
731: ,P_PKG_NAME => G_PKG_NAME
732: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 733: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 739: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 743: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

745: ,X_MSG_DATA => X_MSG_DATA
746: ,X_RETURN_STATUS => X_RETURN_STATUS);
747:
748: WHEN OTHERS THEN
749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
750: P_API_NAME => L_API_NAME
751: ,P_PKG_NAME => G_PKG_NAME
752: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 752: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

748: WHEN OTHERS THEN
749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
750: P_API_NAME => L_API_NAME
751: ,P_PKG_NAME => G_PKG_NAME
752: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
754: ,X_MSG_COUNT => X_MSG_COUNT
755: ,X_MSG_DATA => X_MSG_DATA
756: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

749: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
750: P_API_NAME => L_API_NAME
751: ,P_PKG_NAME => G_PKG_NAME
752: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
753: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
754: ,X_MSG_COUNT => X_MSG_COUNT
755: ,X_MSG_DATA => X_MSG_DATA
756: ,X_RETURN_STATUS => X_RETURN_STATUS);
757: End Delete_orderheaders;

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

764: )
765: IS
766: BEGIN
767: -- Debug Message
768: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
769:
770: -- define all columns for CSP_MOVEORDER_HEADERS_V view
771: dbms_sql.define_column(p_cur_get_MOH, 1, P_MOH_Rec.HEADER_ID);
772: dbms_sql.define_column(p_cur_get_MOH, 2, P_MOH_Rec.CARRIER, 50);

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

785: dbms_sql.define_column(p_cur_get_MOH, 14, P_MOH_Rec.PROVINCE, 60);
786: dbms_sql.define_column(p_cur_get_MOH, 15, P_MOH_Rec.COUNTRY, 60); */
787:
788: -- Debug Message
789: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
790: END Define_Columns;
791:
792: -- This procudure gets column values by the Dynamic SQL.
793: PROCEDURE Get_Column_Values(

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

796: )
797: IS
798: BEGIN
799: -- Debug Message
800: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
801:
802: -- get all column values for CSP_MOVEORDER_HEADERS_V table
803: dbms_sql.column_value(p_cur_get_MOH, 1, X_MOH_Rec.HEADER_ID);
804: dbms_sql.column_value(p_cur_get_MOH, 2, X_MOH_Rec.CARRIER);

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

817: dbms_sql.column_value(p_cur_get_MOH, 14, X_MOH_Rec.PROVINCE);
818: dbms_sql.column_value(p_cur_get_MOH, 15, X_MOH_Rec.COUNTRY); */
819:
820: -- Debug Message
821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
822: END Get_Column_Values;
823:
824: PROCEDURE Gen_MOH_order_cl(
825: p_order_by_rec IN CSP_ORDERHEADERS_PUB.MOH_sort_rec_type,

Line 833: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

829: x_msg_data OUT NOCOPY VARCHAR2
830: )
831: IS
832: l_order_by_cl VARCHAR2(1000) := NULL;
833: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
834: BEGIN
835: -- Debug Message
836: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
837:

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

832: l_order_by_cl VARCHAR2(1000) := NULL;
833: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
834: BEGIN
835: -- Debug Message
836: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
837:
838: -- Hint: Developer should add more statements according to CSP_sort_rec_type
839: -- Ex:
840: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

840: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
841: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
845:
846: JTF_PLSQL_API.Translate_OrderBy(
847: p_api_version_number => 1.0
848: ,p_init_msg_list => FND_API.G_FALSE

Line 846: JTF_PLSQL_API.Translate_OrderBy(

842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
845:
846: JTF_PLSQL_API.Translate_OrderBy(
847: p_api_version_number => 1.0
848: ,p_init_msg_list => FND_API.G_FALSE
849: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
850: ,p_order_by_tbl => l_util_order_by_tbl

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

859: x_order_by_cl := NULL;
860: END IF;
861:
862: -- Debug Message
863: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
864: END Gen_MOH_order_cl;
865:
866: -- This procedure bind the variables for the Dynamic SQL
867: PROCEDURE Bind(

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

873: BEGIN
874: -- Bind variables
875: -- Only those that are not NULL
876: -- Debug Message
877: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
878:
879: -- The following example applies to all columns,
880: -- developers can copy and paste them.
881: IF( (P_MOH_Rec.HEADER_ID IS NOT NULL) AND (P_MOH_Rec.HEADER_ID <> FND_API.G_MISS_NUM) )

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

883: DBMS_SQL.BIND_VARIABLE(p_cur_get_MOH, ':p_HEADER_ID', P_MOH_Rec.HEADER_ID);
884: END IF;
885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
888: END Bind;
889:
890: PROCEDURE Gen_Select(
891: x_select_cl OUT NOCOPY VARCHAR2

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

892: )
893: IS
894: BEGIN
895: -- Debug Message
896: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
897:
898: x_select_cl := 'Select ' ||
899: 'CSP_MOVEORDER_HEADERS_V.HEADER_ID,' ||
900: 'CSP_MOVEORDER_HEADERS_V.CREATED_BY,' ||

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

917: 'CSP_MOVEORDER_HEADERS_V.PROVINCE,' ||
918: 'CSP_MOVEORDER_HEADERS_V.COUNTRY,' || */
919: 'from CSP_MOVEORDER_HEADERS_V';
920: -- Debug Message
921: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
922:
923: END Gen_Select;
924:
925: PROCEDURE Gen_MOH_Where(

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

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

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

1027:
1028: -- Add more IF statements for each column below
1029:
1030: -- Debug Message
1031: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1032:
1033: END Gen_MOH_Where;
1034:
1035: -- Item-level validation procedures

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

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

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

1058:
1059: -- validate NOT NULL column
1060: IF(p_HEADER_ID is NULL)
1061: THEN
1062: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(HEADER_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_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(HEADER_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: NULL;
1069: -- Hint: Validate data
1070: -- IF p_HEADER_ID is not NULL and p_HEADER_ID <> G_MISS_CHAR

Line 1092: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1088: x_msg_data := x_msg_data || 'Unexpected errors found while validating the Header ID. Please check the Header ID.';
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: end;
1091: */
1092: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1093: THEN
1094: -- Hint: Validate data
1095: -- IF p_HEADER_ID <> G_MISS_CHAR
1096: -- verify if data is valid

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

1124: PROCEDURE Validate_LOCATION_ID (
1125: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1126: P_Validation_mode IN VARCHAR2,
1127: P_LOCATION_ID IN NUMBER,
1128: -- 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.
1129: X_Return_Status OUT NOCOPY VARCHAR2,
1130: X_Msg_Count OUT NOCOPY NUMBER,
1131: X_Msg_Data OUT NOCOPY VARCHAR2
1132: )

Line 1149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(LOCATION_ID)');

1145:
1146: -- validate NOT NULL column
1147: IF(p_LOCATION_ID is NULL)
1148: THEN
1149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(LOCATION_ID)');
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;
1152:
1153: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1153: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private orderheaders API: -Violate NOT NULL constraint(LOCATION_ID)');
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;
1152:
1153: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1154: THEN
1155: -- Hint: Validate data
1156: -- IF p_LOCATION_ID is not NULL and p_LOCATION_ID <> G_MISS_CHAR
1157: -- verify if data is valid

Line 1160: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1200: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1196:
1197: -- Initialize API return status to SUCCESS
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199:
1200: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1201: THEN
1202: -- Hint: Validate data
1203: -- IF p_CARRIER is not NULL and p_CARRIER <> G_MISS_CHAR
1204: -- verify if data is valid

Line 1207: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1247: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1254: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1294: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1290:
1291: -- Initialize API return status to SUCCESS
1292: x_return_status := FND_API.G_RET_STS_SUCCESS;
1293:
1294: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1295: THEN
1296: -- Hint: Validate data
1297: -- IF p_AUTORECEIPT_FLAG is not NULL and p_AUTORECEIPT_FLAG <> G_MISS_CHAR
1298: -- verify if data is valid

Line 1301: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1297: -- IF p_AUTORECEIPT_FLAG is not NULL and p_AUTORECEIPT_FLAG <> G_MISS_CHAR
1298: -- verify if data is valid
1299: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1300: NULL;
1301: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1302: THEN
1303: -- Hint: Validate data
1304: -- IF p_AUTORECEIPT_FLAG <> G_MISS_CHAR
1305: -- verify if data is valid

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

1319: /* PROCEDURE Validate_ADDRESS1 (
1320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1321: P_Validation_mode IN VARCHAR2,
1322: P_ADDRESS1 IN VARCHAR2,
1323: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1324: X_Return_Status OUT NOCOPY VARCHAR2,
1325: X_Msg_Count OUT NOCOPY NUMBER,
1326: X_Msg_Data OUT NOCOPY VARCHAR2
1327: )

Line 1341: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1337:
1338: -- Initialize API return status to SUCCESS
1339: x_return_status := FND_API.G_RET_STS_SUCCESS;
1340:
1341: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1342: THEN
1343: -- Hint: Validate data
1344: -- IF p_ADDRESS1 is not NULL and p_ADDRESS1 <> G_MISS_CHAR
1345: -- verify if data is valid

Line 1348: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1344: -- IF p_ADDRESS1 is not NULL and p_ADDRESS1 <> G_MISS_CHAR
1345: -- verify if data is valid
1346: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1347: NULL;
1348: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1349: THEN
1350: -- Hint: Validate data
1351: -- IF p_ADDRESS1 <> G_MISS_CHAR
1352: -- verify if data is valid

Line 1370: -- 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: PROCEDURE Validate_ADDRESS2 (
1367: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1368: P_Validation_mode IN VARCHAR2,
1369: P_ADDRESS2 IN VARCHAR2,
1370: -- 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.
1371: X_Return_Status OUT NOCOPY VARCHAR2,
1372: X_Msg_Count OUT NOCOPY NUMBER,
1373: X_Msg_Data OUT NOCOPY VARCHAR2
1374: )

Line 1388: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1384:
1385: -- Initialize API return status to SUCCESS
1386: x_return_status := FND_API.G_RET_STS_SUCCESS;
1387:
1388: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1389: THEN
1390: -- Hint: Validate data
1391: -- IF p_ADDRESS2 is not NULL and p_ADDRESS2 <> G_MISS_CHAR
1392: -- verify if data is valid

Line 1395: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1391: -- IF p_ADDRESS2 is not NULL and p_ADDRESS2 <> G_MISS_CHAR
1392: -- verify if data is valid
1393: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1394: NULL;
1395: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1396: THEN
1397: -- Hint: Validate data
1398: -- IF p_ADDRESS2 <> G_MISS_CHAR
1399: -- verify if data is valid

Line 1417: -- 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: PROCEDURE Validate_ADDRESS3 (
1414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1415: P_Validation_mode IN VARCHAR2,
1416: P_ADDRESS3 IN VARCHAR2,
1417: -- 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.
1418: X_Return_Status OUT NOCOPY VARCHAR2,
1419: X_Msg_Count OUT NOCOPY NUMBER,
1420: X_Msg_Data OUT NOCOPY VARCHAR2
1421: )

Line 1435: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1431:
1432: -- Initialize API return status to SUCCESS
1433: x_return_status := FND_API.G_RET_STS_SUCCESS;
1434:
1435: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1436: THEN
1437: -- Hint: Validate data
1438: -- IF p_ADDRESS3 is not NULL and p_ADDRESS3 <> G_MISS_CHAR
1439: -- verify if data is valid

Line 1442: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1482: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1478:
1479: -- Initialize API return status to SUCCESS
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1483: THEN
1484: -- Hint: Validate data
1485: -- IF p_ADDRESS4 is not NULL and p_ADDRESS4 <> G_MISS_CHAR
1486: -- verify if data is valid

Line 1489: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1485: -- IF p_ADDRESS4 is not NULL and p_ADDRESS4 <> G_MISS_CHAR
1486: -- verify if data is valid
1487: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1488: NULL;
1489: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1490: THEN
1491: -- Hint: Validate data
1492: -- IF p_ADDRESS4 <> G_MISS_CHAR
1493: -- verify if data is valid

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

1507: PROCEDURE Validate_CITY (
1508: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1509: P_Validation_mode IN VARCHAR2,
1510: P_CITY IN VARCHAR2,
1511: -- 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.
1512: X_Return_Status OUT NOCOPY VARCHAR2,
1513: X_Msg_Count OUT NOCOPY NUMBER,
1514: X_Msg_Data OUT NOCOPY VARCHAR2
1515: )

Line 1529: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1525:
1526: -- Initialize API return status to SUCCESS
1527: x_return_status := FND_API.G_RET_STS_SUCCESS;
1528:
1529: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1530: THEN
1531: -- Hint: Validate data
1532: -- IF p_CITY is not NULL and p_CITY <> G_MISS_CHAR
1533: -- verify if data is valid

Line 1536: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1532: -- IF p_CITY is not NULL and p_CITY <> G_MISS_CHAR
1533: -- verify if data is valid
1534: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1535: NULL;
1536: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1537: THEN
1538: -- Hint: Validate data
1539: -- IF p_CITY <> G_MISS_CHAR
1540: -- verify if data is valid

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

1554: PROCEDURE Validate_POSTAL_CODE (
1555: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1556: P_Validation_mode IN VARCHAR2,
1557: P_POSTAL_CODE IN VARCHAR2,
1558: -- 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.
1559: X_Return_Status OUT NOCOPY VARCHAR2,
1560: X_Msg_Count OUT NOCOPY NUMBER,
1561: X_Msg_Data OUT NOCOPY VARCHAR2
1562: )

Line 1576: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1572:
1573: -- Initialize API return status to SUCCESS
1574: x_return_status := FND_API.G_RET_STS_SUCCESS;
1575:
1576: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1577: THEN
1578: -- Hint: Validate data
1579: -- IF p_POSTAL_CODE is not NULL and p_POSTAL_CODE <> G_MISS_CHAR
1580: -- verify if data is valid

Line 1583: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1579: -- IF p_POSTAL_CODE is not NULL and p_POSTAL_CODE <> G_MISS_CHAR
1580: -- verify if data is valid
1581: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1582: NULL;
1583: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1584: THEN
1585: -- Hint: Validate data
1586: -- IF p_POSTAL_CODE <> G_MISS_CHAR
1587: -- verify if data is valid

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

1601: PROCEDURE Validate_STATE (
1602: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1603: P_Validation_mode IN VARCHAR2,
1604: P_STATE IN VARCHAR2,
1605: -- 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.
1606: X_Return_Status OUT NOCOPY VARCHAR2,
1607: X_Msg_Count OUT NOCOPY NUMBER,
1608: X_Msg_Data OUT NOCOPY VARCHAR2
1609: )

Line 1623: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1619:
1620: -- Initialize API return status to SUCCESS
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;
1622:
1623: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1624: THEN
1625: -- Hint: Validate data
1626: -- IF p_STATE is not NULL and p_STATE <> G_MISS_CHAR
1627: -- verify if data is valid

Line 1630: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1626: -- IF p_STATE is not NULL and p_STATE <> G_MISS_CHAR
1627: -- verify if data is valid
1628: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1629: NULL;
1630: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1631: THEN
1632: -- Hint: Validate data
1633: -- IF p_STATE <> G_MISS_CHAR
1634: -- verify if data is valid

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

1648: PROCEDURE Validate_PROVINCE (
1649: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1650: P_Validation_mode IN VARCHAR2,
1651: P_PROVINCE IN VARCHAR2,
1652: -- 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.
1653: X_Return_Status OUT NOCOPY VARCHAR2,
1654: X_Msg_Count OUT NOCOPY NUMBER,
1655: X_Msg_Data OUT NOCOPY VARCHAR2
1656: )

Line 1670: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1666:
1667: -- Initialize API return status to SUCCESS
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1671: THEN
1672: -- Hint: Validate data
1673: -- IF p_PROVINCE is not NULL and p_PROVINCE <> G_MISS_CHAR
1674: -- verify if data is valid

Line 1677: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1673: -- IF p_PROVINCE is not NULL and p_PROVINCE <> G_MISS_CHAR
1674: -- verify if data is valid
1675: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1676: NULL;
1677: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1678: THEN
1679: -- Hint: Validate data
1680: -- IF p_PROVINCE <> G_MISS_CHAR
1681: -- verify if data is valid

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

1695: PROCEDURE Validate_COUNTRY (
1696: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1697: P_Validation_mode IN VARCHAR2,
1698: P_COUNTRY IN VARCHAR2,
1699: -- 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.
1700: X_Return_Status OUT NOCOPY VARCHAR2,
1701: X_Msg_Count OUT NOCOPY NUMBER,
1702: X_Msg_Data OUT NOCOPY VARCHAR2
1703: )

Line 1717: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1713:
1714: -- Initialize API return status to SUCCESS
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716:
1717: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1718: THEN
1719: -- Hint: Validate data
1720: -- IF p_COUNTRY is not NULL and p_COUNTRY <> G_MISS_CHAR
1721: -- verify if data is valid

Line 1724: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1720: -- IF p_COUNTRY is not NULL and p_COUNTRY <> G_MISS_CHAR
1721: -- verify if data is valid
1722: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1723: NULL;
1724: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1725: THEN
1726: -- Hint: Validate data
1727: -- IF p_COUNTRY <> G_MISS_CHAR
1728: -- verify if data is valid

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

1739: END Validate_COUNTRY;
1740: */
1741:
1742: -- Hint: inter-field level validation can be added here.
1743: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1744: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1745: -- stored in database table.
1746: PROCEDURE Validate_MOH_rec(
1747: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

1769: -- THEN
1770: -- x_return_status := FND_API.G_RET_STS_ERROR;
1771:
1772: -- Debug Message
1773: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count,

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

1793: l_api_name CONSTANT VARCHAR2(30) := 'Validate_orderheaders';
1794: BEGIN
1795:
1796: -- Debug Message
1797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
1798:
1799:
1800: -- Initialize API return status to SUCCESS
1801: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1799:
1800: -- Initialize API return status to SUCCESS
1801: x_return_status := FND_API.G_RET_STS_SUCCESS;
1802:
1803: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1804: -- Hint: We provide validation procedure for every column. Developer should delete
1805: -- unnecessary validation procedures.
1806: Validate_HEADER_ID(
1807: p_init_msg_list => FND_API.G_FALSE,

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

1960: END IF;
1961: */
1962: END IF;
1963:
1964: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1965: -- Hint: Inter-field level validation can be added here
1966: -- invoke record level validation procedures
1967: Validate_MOH_Rec(
1968: p_init_msg_list => FND_API.G_FALSE,

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

1976: raise FND_API.G_EXC_ERROR;
1977: END IF;
1978: END IF;
1979:
1980: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1981: -- invoke inter-record level validation procedures
1982: NULL;
1983: END IF;
1984:

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

1981: -- invoke inter-record level validation procedures
1982: NULL;
1983: END IF;
1984:
1985: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1986: -- invoke inter-entity level validation procedures
1987: NULL;
1988: END IF;
1989:

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

1988: END IF;
1989:
1990:
1991: -- Debug Message
1992: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
1993:
1994: END Validate_orderheaders;
1995:
1996: End CSP_ORDERHEADERS_PVT;