eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PACKLIST_HEADERS_PVT dependencies on JTF_PLSQL_API

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

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

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

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

Line 122: p_validation_mode => JTF_PLSQL_API.G_CREATE,

118: -- Invoke validation procedures
119: Validate_packlist_headers(
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_PLH_Rec => P_PLH_Rec,
124: x_return_status => x_return_status,
125: x_msg_count => x_msg_count,
126: x_msg_data => x_msg_data);

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

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

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_packlist_headers;

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

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

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

375: RAISE FND_API.G_EXC_ERROR;
376: END IF;*/
377:
378: -- Debug Message
379: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Open Cursor to Select');
380:
381: /*
382: Open C_Get_packlist_headers( l_tar_PLH_rec.PACKLIST_HEADER_ID);
383:

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

428: END IF;
429: raise FND_API.G_EXC_ERROR;
430: END IF;
431: -- Debug Message
432: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: - Close Cursor');
433: Close C_Get_packlist_headers;
434:
435:
436:

Line 463: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Validate_packlist_headers');

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

Line 469: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

465: -- Invoke validation procedures
466: Validate_packlist_headers(
467: p_init_msg_list => FND_API.G_FALSE,
468: p_validation_level => p_validation_level,
469: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
470: P_PLH_Rec => P_PLH_Rec,
471: x_return_status => x_return_status,
472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data);

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

479:
480: -- Hint: Add corresponding Master-Detail business logic here if necessary.
481:
482: -- Debug Message
483: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling update table handler');
484:
485: -- Invoke table handler(CSP_PACKLIST_HEADERS_PKG.Update_Row)
486: CSP_PACKLIST_HEADERS_PKG.Update_Row(
487: p_PACKLIST_HEADER_ID => p_PLH_rec.PACKLIST_HEADER_ID,

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

530: END IF;
531:
532:
533: -- Debug Message
534: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
535:
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get

Line 563: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

559: END IF;
560: */
561: EXCEPTION
562: WHEN FND_API.G_EXC_ERROR THEN
563: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
564: P_API_NAME => L_API_NAME
565: ,P_PKG_NAME => G_PKG_NAME
566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
567: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 567: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 573: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);
591: End Update_packlist_headers;

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

630: END IF;
631:
632:
633: -- Debug Message
634: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'start');
635:
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673: */
674: -- Debug Message
675: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Calling delete table handler');
676:
677: -- Invoke table handler(CSP_PACKLIST_HEADERS_PKG.Delete_Row)
678: CSP_PACKLIST_HEADERS_PKG.Delete_Row(
679: p_PACKLIST_HEADER_ID => p_PLH_rec.PACKLIST_HEADER_ID);

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

688: END IF;
689:
690:
691: -- Debug Message
692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
693:
694:
695: -- Standard call to get message count and if count is 1, get message info.
696: FND_MSG_PUB.Count_And_Get

Line 721: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

717: END IF;
718: */
719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
722: P_API_NAME => L_API_NAME
723: ,P_PKG_NAME => G_PKG_NAME
724: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
725: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 725: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 731: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

727: ,X_MSG_DATA => X_MSG_DATA
728: ,X_RETURN_STATUS => X_RETURN_STATUS);
729:
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
732: P_API_NAME => L_API_NAME
733: ,P_PKG_NAME => G_PKG_NAME
734: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
735: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 735: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 744: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

740: WHEN OTHERS THEN
741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
742: P_API_NAME => L_API_NAME
743: ,P_PKG_NAME => G_PKG_NAME
744: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
746: ,X_MSG_COUNT => X_MSG_COUNT
747: ,X_MSG_DATA => X_MSG_DATA
748: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

741: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
742: P_API_NAME => L_API_NAME
743: ,P_PKG_NAME => G_PKG_NAME
744: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
745: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
746: ,X_MSG_COUNT => X_MSG_COUNT
747: ,X_MSG_DATA => X_MSG_DATA
748: ,X_RETURN_STATUS => X_RETURN_STATUS);
749: End Delete_packlist_headers;

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

756: )
757: IS
758: BEGIN
759: -- Debug Message
760: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
761:
762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);

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

792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:
795: -- Debug Message
796: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
797: END Define_Columns;
798:
799: -- This procudure gets column values by the Dynamic SQL.
800: PROCEDURE Get_Column_Values(

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

803: )
804: IS
805: BEGIN
806: -- Debug Message
807: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
808:
809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);

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

840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
845: END Get_Column_Values;
846:
847: PROCEDURE Gen_PLH_order_cl(
848: p_order_by_rec IN CSP_Packlist_Headers_PUB.PLH_sort_rec_type,

Line 856: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

852: x_msg_data OUT NOCOPY VARCHAR2
853: )
854: IS
855: l_order_by_cl VARCHAR2(1000) := NULL;
856: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
857: BEGIN
858: -- Debug Message
859: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
860:

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

855: l_order_by_cl VARCHAR2(1000) := NULL;
856: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
857: BEGIN
858: -- Debug Message
859: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Begins');
860:
861: -- Hint: Developer should add more statements according to CSP_sort_rec_type
862: -- Ex:
863: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

863: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
864: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
865:
866: -- Debug Message
867: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
868:
869: JTF_PLSQL_API.Translate_OrderBy(
870: p_api_version_number => 1.0
871: ,p_init_msg_list => FND_API.G_FALSE

Line 869: JTF_PLSQL_API.Translate_OrderBy(

865:
866: -- Debug Message
867: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
868:
869: JTF_PLSQL_API.Translate_OrderBy(
870: p_api_version_number => 1.0
871: ,p_init_msg_list => FND_API.G_FALSE
872: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
873: ,p_order_by_tbl => l_util_order_by_tbl

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

882: x_order_by_cl := NULL;
883: END IF;
884:
885: -- Debug Message
886: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Order by Ends');
887: END Gen_PLH_order_cl;
888:
889: -- This procedure bind the variables for the Dynamic SQL
890: PROCEDURE Bind(

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

896: BEGIN
897: -- Bind variables
898: -- Only those that are not NULL
899: -- Debug Message
900: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Begins');
901:
902: -- The following example applies to all columns,
903: -- developers can copy and paste them.
904: IF( (P_PLH_Rec.PACKLIST_HEADER_ID IS NOT NULL) AND (P_PLH_Rec.PACKLIST_HEADER_ID <> FND_API.G_MISS_NUM) )

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

906: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLH, ':p_PACKLIST_HEADER_ID', P_PLH_Rec.PACKLIST_HEADER_ID);
907: END IF;
908:
909: -- Debug Message
910: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');
911: END Bind;
912:
913: PROCEDURE Gen_Select(
914: x_select_cl OUT NOCOPY VARCHAR2

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

915: )
916: IS
917: BEGIN
918: -- Debug Message
919: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Begins');
920:
921: x_select_cl := 'Select ' ||
922: 'CSP_PACKLIST_HEADERS_V.ROW_ID,' ||
923: 'CSP_PACKLIST_HEADERS_V.PACKLIST_HEADER_ID,' ||

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

957: 'CSP_PACKLIST_HEADERS_V.ATTRIBUTE14,' ||
958: 'CSP_PACKLIST_HEADERS_V.ATTRIBUTE15,' ||
959: 'from CSP_PACKLIST_HEADERS_V';
960: -- Debug Message
961: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Select Ends');
962:
963: END Gen_Select;
964:
965: PROCEDURE Gen_PLH_Where(

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

981: str_csr2 NUMBER;
982: l_operator VARCHAR2(10);
983: BEGIN
984: -- Debug Message
985: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Begins');
986:
987: -- There are three examples for each kind of datatype:
988: -- NUMBER, DATE, VARCHAR2.
989: -- Developer can copy and paste the following codes for your own record.

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

1067:
1068: -- Add more IF statements for each column below
1069:
1070: -- Debug Message
1071: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Generate Where Ends');
1072:
1073: END Gen_PLH_Where;
1074:
1075: -- Item-level validation procedures

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_PACKLIST_HEADER_ID (
1077: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1078: P_Validation_mode IN VARCHAR2,
1079: P_PACKLIST_HEADER_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_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1097:
1098: -- validate NOT NULL column
1099: IF(p_PACKLIST_HEADER_ID is NULL)
1100: THEN
1101: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1102: constraint(PACKLIST_HEADER_ID)');
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;
1105:

Line 1106: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1102: constraint(PACKLIST_HEADER_ID)');
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: END IF;
1105:
1106: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1107: THEN
1108: -- Hint: Validate data
1109: -- IF p_PACKLIST_HEADER_ID is not NULL and p_PACKLIST_HEADER_ID <> G_MISS_CHAR
1110: -- verify if data is valid

Line 1113: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1156: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1152:
1153: -- validate NOT NULL column
1154: IF(p_ORGANIZATION_ID is NULL)
1155: THEN
1156: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1157: constraint(ORGANIZATION_ID)');
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;
1160:

Line 1161: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1157: constraint(ORGANIZATION_ID)');
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;
1160:
1161: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1162: THEN
1163: -- Hint: Validate data
1164: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1165: -- verify if data is valid

Line 1168: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1164: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1165: -- verify if data is valid
1166: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1167: NULL;
1168: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1169: THEN
1170: -- Hint: Validate data
1171: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
1172: -- verify if data is valid

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

1186: PROCEDURE Validate_PACKLIST_NUMBER (
1187: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1188: P_Validation_mode IN VARCHAR2,
1189: P_PACKLIST_NUMBER IN VARCHAR2,
1190: -- 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.
1191: X_Return_Status OUT NOCOPY VARCHAR2,
1192: X_Msg_Count OUT NOCOPY NUMBER,
1193: X_Msg_Data OUT NOCOPY VARCHAR2
1194: )

Line 1211: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1207:
1208: -- validate NOT NULL column
1209: IF(p_PACKLIST_NUMBER is NULL)
1210: THEN
1211: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1212: constraint(PACKLIST_NUMBER)');
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: END IF;
1215:

Line 1216: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1212: constraint(PACKLIST_NUMBER)');
1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214: END IF;
1215:
1216: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1217: THEN
1218: -- Hint: Validate data
1219: -- IF p_PACKLIST_NUMBER is not NULL and p_PACKLIST_NUMBER <> G_MISS_CHAR
1220: -- verify if data is valid

Line 1223: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1219: -- IF p_PACKLIST_NUMBER is not NULL and p_PACKLIST_NUMBER <> G_MISS_CHAR
1220: -- verify if data is valid
1221: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1222: NULL;
1223: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1224: THEN
1225: -- Hint: Validate data
1226: -- IF p_PACKLIST_NUMBER <> G_MISS_CHAR
1227: -- verify if data is valid

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

1241: PROCEDURE Validate_SUBINVENTORY_CODE (
1242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1243: P_Validation_mode IN VARCHAR2,
1244: P_SUBINVENTORY_CODE IN VARCHAR2,
1245: -- 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.
1246: X_Return_Status OUT NOCOPY VARCHAR2,
1247: X_Msg_Count OUT NOCOPY NUMBER,
1248: X_Msg_Data OUT NOCOPY VARCHAR2
1249: )

Line 1266: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1262:
1263: -- validate NOT NULL column
1264: IF(p_SUBINVENTORY_CODE is NULL)
1265: THEN
1266: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1267: constraint(SUBINVENTORY_CODE)');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: END IF;
1270:

Line 1271: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1267: constraint(SUBINVENTORY_CODE)');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: END IF;
1270:
1271: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1272: THEN
1273: -- Hint: Validate data
1274: -- IF p_SUBINVENTORY_CODE is not NULL and p_SUBINVENTORY_CODE <> G_MISS_CHAR
1275: -- verify if data is valid

Line 1278: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

1296: PROCEDURE Validate_PACKLIST_STATUS (
1297: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1298: P_Validation_mode IN VARCHAR2,
1299: P_PACKLIST_STATUS IN VARCHAR2,
1300: -- 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.
1301: X_Return_Status OUT NOCOPY VARCHAR2,
1302: X_Msg_Count OUT NOCOPY NUMBER,
1303: X_Msg_Data OUT NOCOPY VARCHAR2
1304: )

Line 1321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1317:
1318: -- validate NOT NULL column
1319: IF(p_PACKLIST_STATUS is NULL)
1320: THEN
1321: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1322: constraint(PACKLIST_STATUS)');
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:

Line 1326: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1322: constraint(PACKLIST_STATUS)');
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: END IF;
1325:
1326: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1327: THEN
1328: -- Hint: Validate data
1329: -- IF p_PACKLIST_STATUS is not NULL and p_PACKLIST_STATUS <> G_MISS_CHAR
1330: -- verify if data is valid

Line 1333: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1329: -- IF p_PACKLIST_STATUS is not NULL and p_PACKLIST_STATUS <> G_MISS_CHAR
1330: -- verify if data is valid
1331: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1332: NULL;
1333: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1334: THEN
1335: -- Hint: Validate data
1336: -- IF p_PACKLIST_STATUS <> G_MISS_CHAR
1337: -- verify if data is valid

Line 1355: -- 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: PROCEDURE Validate_DATE_CREATED (
1352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1353: P_Validation_mode IN VARCHAR2,
1354: P_DATE_CREATED IN DATE,
1355: -- 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.
1356: X_Return_Status OUT NOCOPY VARCHAR2,
1357: X_Msg_Count OUT NOCOPY NUMBER,
1358: X_Msg_Data OUT NOCOPY VARCHAR2
1359: )

Line 1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL

1372:
1373: -- validate NOT NULL column
1374: IF(p_DATE_CREATED is NULL)
1375: THEN
1376: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'CSP', 'Private packlist_headers API: -Violate NOT NULL
1377: constraint(DATE_CREATED)');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: END IF;
1380:

Line 1381: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1377: constraint(DATE_CREATED)');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: END IF;
1380:
1381: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1382: THEN
1383: -- Hint: Validate data
1384: -- IF p_DATE_CREATED is not NULL and p_DATE_CREATED <> G_MISS_CHAR
1385: -- verify if data is valid

Line 1388: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

1406: PROCEDURE Validate_DATE_PACKED (
1407: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1408: P_Validation_mode IN VARCHAR2,
1409: P_DATE_PACKED IN DATE,
1410: -- 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.
1411: X_Return_Status OUT NOCOPY VARCHAR2,
1412: X_Msg_Count OUT NOCOPY NUMBER,
1413: X_Msg_Data OUT NOCOPY VARCHAR2
1414: )

Line 1428: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1424:
1425: -- Initialize API return status to SUCCESS
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427:
1428: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1429: THEN
1430: -- Hint: Validate data
1431: -- IF p_DATE_PACKED is not NULL and p_DATE_PACKED <> G_MISS_CHAR
1432: -- verify if data is valid

Line 1435: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1431: -- IF p_DATE_PACKED is not NULL and p_DATE_PACKED <> G_MISS_CHAR
1432: -- verify if data is valid
1433: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1434: NULL;
1435: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1436: THEN
1437: -- Hint: Validate data
1438: -- IF p_DATE_PACKED <> G_MISS_CHAR
1439: -- verify if data is valid

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

1453: PROCEDURE Validate_DATE_SHIPPED (
1454: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1455: P_Validation_mode IN VARCHAR2,
1456: P_DATE_SHIPPED IN DATE,
1457: -- 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.
1458: X_Return_Status OUT NOCOPY VARCHAR2,
1459: X_Msg_Count OUT NOCOPY NUMBER,
1460: X_Msg_Data OUT NOCOPY VARCHAR2
1461: )

Line 1475: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1471:
1472: -- Initialize API return status to SUCCESS
1473: x_return_status := FND_API.G_RET_STS_SUCCESS;
1474:
1475: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1476: THEN
1477: -- Hint: Validate data
1478: -- IF p_DATE_SHIPPED is not NULL and p_DATE_SHIPPED <> G_MISS_CHAR
1479: -- verify if data is valid

Line 1482: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1478: -- IF p_DATE_SHIPPED is not NULL and p_DATE_SHIPPED <> G_MISS_CHAR
1479: -- verify if data is valid
1480: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1481: NULL;
1482: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1483: THEN
1484: -- Hint: Validate data
1485: -- IF p_DATE_SHIPPED <> G_MISS_CHAR
1486: -- verify if data is valid

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

1500: PROCEDURE Validate_DATE_RECEIVED (
1501: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1502: P_Validation_mode IN VARCHAR2,
1503: P_DATE_RECEIVED IN DATE,
1504: -- 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.
1505: X_Return_Status OUT NOCOPY VARCHAR2,
1506: X_Msg_Count OUT NOCOPY NUMBER,
1507: X_Msg_Data OUT NOCOPY VARCHAR2
1508: )

Line 1522: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1518:
1519: -- Initialize API return status to SUCCESS
1520: x_return_status := FND_API.G_RET_STS_SUCCESS;
1521:
1522: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1523: THEN
1524: -- Hint: Validate data
1525: -- IF p_DATE_RECEIVED is not NULL and p_DATE_RECEIVED <> G_MISS_CHAR
1526: -- verify if data is valid

Line 1529: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1525: -- IF p_DATE_RECEIVED is not NULL and p_DATE_RECEIVED <> G_MISS_CHAR
1526: -- verify if data is valid
1527: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1528: NULL;
1529: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1530: THEN
1531: -- Hint: Validate data
1532: -- IF p_DATE_RECEIVED <> G_MISS_CHAR
1533: -- verify if data is valid

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

1547: PROCEDURE Validate_CARRIER (
1548: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1549: P_Validation_mode IN VARCHAR2,
1550: P_CARRIER IN VARCHAR2,
1551: -- 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.
1552: X_Return_Status OUT NOCOPY VARCHAR2,
1553: X_Msg_Count OUT NOCOPY NUMBER,
1554: X_Msg_Data OUT NOCOPY VARCHAR2
1555: )

Line 1569: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1565:
1566: -- Initialize API return status to SUCCESS
1567: x_return_status := FND_API.G_RET_STS_SUCCESS;
1568:
1569: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1570: THEN
1571: -- Hint: Validate data
1572: -- IF p_CARRIER is not NULL and p_CARRIER <> G_MISS_CHAR
1573: -- verify if data is valid

Line 1576: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1572: -- IF p_CARRIER is not NULL and p_CARRIER <> G_MISS_CHAR
1573: -- verify if data is valid
1574: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1575: NULL;
1576: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1577: THEN
1578: -- Hint: Validate data
1579: -- IF p_CARRIER <> G_MISS_CHAR
1580: -- verify if data is valid

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

1594: PROCEDURE Validate_SHIPMENT_METHOD (
1595: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1596: P_Validation_mode IN VARCHAR2,
1597: P_SHIPMENT_METHOD IN VARCHAR2,
1598: -- 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.
1599: X_Return_Status OUT NOCOPY VARCHAR2,
1600: X_Msg_Count OUT NOCOPY NUMBER,
1601: X_Msg_Data OUT NOCOPY VARCHAR2
1602: )

Line 1616: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1612:
1613: -- Initialize API return status to SUCCESS
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1617: THEN
1618: -- Hint: Validate data
1619: -- IF p_SHIPMENT_METHOD is not NULL and p_SHIPMENT_METHOD <> G_MISS_CHAR
1620: -- verify if data is valid

Line 1623: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1619: -- IF p_SHIPMENT_METHOD is not NULL and p_SHIPMENT_METHOD <> G_MISS_CHAR
1620: -- verify if data is valid
1621: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1622: NULL;
1623: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1624: THEN
1625: -- Hint: Validate data
1626: -- IF p_SHIPMENT_METHOD <> G_MISS_CHAR
1627: -- verify if data is valid

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

1641: PROCEDURE Validate_WAYBILL (
1642: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1643: P_Validation_mode IN VARCHAR2,
1644: P_WAYBILL IN VARCHAR2,
1645: -- 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.
1646: X_Return_Status OUT NOCOPY VARCHAR2,
1647: X_Msg_Count OUT NOCOPY NUMBER,
1648: X_Msg_Data OUT NOCOPY VARCHAR2
1649: )

Line 1663: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1659:
1660: -- Initialize API return status to SUCCESS
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1664: THEN
1665: -- Hint: Validate data
1666: -- IF p_WAYBILL is not NULL and p_WAYBILL <> G_MISS_CHAR
1667: -- verify if data is valid

Line 1670: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

Line 1710: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

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

Line 1717: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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