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

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

60: END IF;
61:
62:
63: -- Debug Message
64: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
65:
66:
67: -- Initialize API return status to SUCCESS
68: 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_pick_serial_lots');

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_pick_serial_lots');
123:
124: -- Invoke validation procedures
125: Validate_pick_serial_lots(
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_pick_serial_lots(
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_psl_Rec => P_psl_Rec,
130: x_return_status => x_return_status,
131: x_msg_count => x_msg_count,
132: x_msg_data => x_msg_data);

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

138:
139: -- Hint: Add corresponding Master-Detail business logic here if necessary.
140:
141: -- Debug Message
142: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Calling create table handler');
143:
144: IF l_created_by IS NULL THEN
145: l_created_by := G_USER_ID;
146: END IF;

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

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

Line 222: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 226: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 232: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 236: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

Line 242: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 245: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 246: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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

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

311: END IF;
312:
313:
314: -- Debug Message
315: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
316:
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355: */
356: -- Debug Message
357: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: - Open Cursor to Select');
358:
359: /*
360: Open C_Get_pick_serial_lots( l_tar_psl_rec.PICKLIST_SERIAL_LOT_ID);
361:

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

383: END IF;
384: raise FND_API.G_EXC_ERROR;
385: END IF;
386: -- Debug Message
387: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: - Close Cursor');
388: Close C_Get_pick_serial_lots;
389: */
390:
391:

Line 416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');

412:
413: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
414: THEN
415: -- Debug message
416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Validate_pick_serial_lots');
417:
418: -- Invoke validation procedures
419: Validate_pick_serial_lots(
420: p_init_msg_list => FND_API.G_FALSE,

Line 422: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

418: -- Invoke validation procedures
419: Validate_pick_serial_lots(
420: p_init_msg_list => FND_API.G_FALSE,
421: p_validation_level => p_validation_level,
422: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
423: P_psl_Rec => P_psl_Rec,
424: x_return_status => x_return_status,
425: x_msg_count => x_msg_count,
426: x_msg_data => x_msg_data);

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

432:
433: -- Hint: Add corresponding Master-Detail business logic here if necessary.
434:
435: -- Debug Message
436: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Calling update table handler');
437:
438: -- Invoke table handler(CSP_PICKLIST_SERIAL_LOTS_PKG.Update_Row)
439: CSP_PICKLIST_SERIAL_LOTS_PKG.Update_Row(
440: p_PICKLIST_SERIAL_LOT_ID => p_psl_rec.PICKLIST_SERIAL_LOT_ID,

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

460: END IF;
461:
462:
463: -- Debug Message
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
465:
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get

Line 493: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

489: END IF;
490: */
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
494: P_API_NAME => L_API_NAME
495: ,P_PKG_NAME => G_PKG_NAME
496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
497: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 497: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

493: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
494: P_API_NAME => L_API_NAME
495: ,P_PKG_NAME => G_PKG_NAME
496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
497: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
498: ,X_MSG_COUNT => X_MSG_COUNT
499: ,X_MSG_DATA => X_MSG_DATA
500: ,X_RETURN_STATUS => X_RETURN_STATUS);
501:

Line 503: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

499: ,X_MSG_DATA => X_MSG_DATA
500: ,X_RETURN_STATUS => X_RETURN_STATUS);
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
504: P_API_NAME => L_API_NAME
505: ,P_PKG_NAME => G_PKG_NAME
506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
507: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 507: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

503: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
504: P_API_NAME => L_API_NAME
505: ,P_PKG_NAME => G_PKG_NAME
506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
507: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
508: ,X_MSG_COUNT => X_MSG_COUNT
509: ,X_MSG_DATA => X_MSG_DATA
510: ,X_RETURN_STATUS => X_RETURN_STATUS);
511:

Line 513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

509: ,X_MSG_DATA => X_MSG_DATA
510: ,X_RETURN_STATUS => X_RETURN_STATUS);
511:
512: WHEN OTHERS THEN
513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 516: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

512: WHEN OTHERS THEN
513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521: End Update_pick_serial_lots;

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

560: END IF;
561:
562:
563: -- Debug Message
564: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
565:
566:
567: -- Initialize API return status to SUCCESS
568: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604: */
605: -- Debug Message
606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Calling delete table handler');
607:
608: -- Invoke table handler(CSP_PICKLIST_SERIAL_LOTS_PKG.Delete_Row)
609: CSP_PICKLIST_SERIAL_LOTS_PKG.Delete_Row(
610: p_PICKLIST_SERIAL_LOT_ID => p_psl_rec.PICKLIST_SERIAL_LOT_ID);

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

619: END IF;
620:
621:
622: -- Debug Message
623: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get

Line 652: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

648: END IF;
649: */
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN
652: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
653: P_API_NAME => L_API_NAME
654: ,P_PKG_NAME => G_PKG_NAME
655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
656: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 656: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

652: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
653: P_API_NAME => L_API_NAME
654: ,P_PKG_NAME => G_PKG_NAME
655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
656: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
657: ,X_MSG_COUNT => X_MSG_COUNT
658: ,X_MSG_DATA => X_MSG_DATA
659: ,X_RETURN_STATUS => X_RETURN_STATUS);
660:

Line 662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

658: ,X_MSG_DATA => X_MSG_DATA
659: ,X_RETURN_STATUS => X_RETURN_STATUS);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

662: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
666: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
667: ,X_MSG_COUNT => X_MSG_COUNT
668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);
670:

Line 672: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);
670:
671: WHEN OTHERS THEN
672: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
676: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 675: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

671: WHEN OTHERS THEN
672: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
676: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
677: ,X_MSG_COUNT => X_MSG_COUNT
678: ,X_MSG_DATA => X_MSG_DATA
679: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 676: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

672: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
676: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
677: ,X_MSG_COUNT => X_MSG_COUNT
678: ,X_MSG_DATA => X_MSG_DATA
679: ,X_RETURN_STATUS => X_RETURN_STATUS);
680: End Delete_pick_serial_lots;

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

687: )
688: IS
689: BEGIN
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Begins');
692:
693: -- define all columns for CSP_PICKLIST_SERIAL_LOTS_V view
694: dbms_sql.define_column(p_cur_get_psl, 1, P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
695: dbms_sql.define_column(p_cur_get_psl, 2, P_psl_Rec.PICKLIST_LINE_ID);

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

699: dbms_sql.define_column(p_cur_get_psl, 6, P_psl_Rec.LOT_NUMBER, 80);
700: dbms_sql.define_column(p_cur_get_psl, 7, P_psl_Rec.SERIAL_NUMBER, 30);
701:
702: -- Debug Message
703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Define Columns Ends');
704: END Define_Columns;
705:
706: -- This procudure gets column values by the Dynamic SQL.
707: PROCEDURE Get_Column_Values(

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

710: )
711: IS
712: BEGIN
713: -- Debug Message
714: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Begins');
715:
716: -- get all column values for CSP_PICKLIST_SERIAL_LOTS_V table
717: dbms_sql.column_value(p_cur_get_psl, 1, X_psl_Rec.ROW_ID);
718: dbms_sql.column_value(p_cur_get_psl, 2, X_psl_Rec.PICKLIST_SERIAL_LOT_ID);

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

723: dbms_sql.column_value(p_cur_get_psl, 7, X_psl_Rec.LOT_NUMBER);
724: dbms_sql.column_value(p_cur_get_psl, 8, X_psl_Rec.SERIAL_NUMBER);
725:
726: -- Debug Message
727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Ends');
728: END Get_Column_Values;
729:
730: PROCEDURE Gen_psl_order_cl(
731: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,

Line 739: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;

735: x_msg_data OUT NOCOPY VARCHAR2
736: )
737: IS
738: l_order_by_cl VARCHAR2(1000) := NULL;
739: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
740: BEGIN
741: -- Debug Message
742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Order by Begins');
743:

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

738: l_order_by_cl VARCHAR2(1000) := NULL;
739: l_util_order_by_tbl JTF_PLSQL_API.Util_order_by_tbl_type;
740: BEGIN
741: -- Debug Message
742: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Order by Begins');
743:
744: -- Hint: Developer should add more statements according to csp_sort_rec_type
745: -- Ex:
746: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

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

746: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
747: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
748:
749: -- Debug Message
750: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
751:
752: JTF_PLSQL_API.Translate_OrderBy(
753: p_api_version_number => 1.0
754: ,p_init_msg_list => FND_API.G_FALSE

Line 752: JTF_PLSQL_API.Translate_OrderBy(

748:
749: -- Debug Message
750: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Invoke JTF_PLSQL_API.Translate_OrderBy');
751:
752: JTF_PLSQL_API.Translate_OrderBy(
753: p_api_version_number => 1.0
754: ,p_init_msg_list => FND_API.G_FALSE
755: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
756: ,p_order_by_tbl => l_util_order_by_tbl

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

765: x_order_by_cl := NULL;
766: END IF;
767:
768: -- Debug Message
769: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Order by Ends');
770: END Gen_psl_order_cl;
771:
772: -- This procedure bind the variables for the Dynamic SQL
773: PROCEDURE Bind(

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

779: BEGIN
780: -- Bind variables
781: -- Only those that are not NULL
782: -- Debug Message
783: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Bind Variables Begins');
784:
785: -- The following example applies to all columns,
786: -- developers can copy and paste them.
787: IF( (P_psl_Rec.PICKLIST_SERIAL_LOT_ID IS NOT NULL) AND (P_psl_Rec.PICKLIST_SERIAL_LOT_ID <> FND_API.G_MISS_NUM) )

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

789: DBMS_SQL.BIND_VARIABLE(p_cur_get_psl, ':p_PICKLIST_SERIAL_LOT_ID', P_psl_Rec.PICKLIST_SERIAL_LOT_ID);
790: END IF;
791:
792: -- Debug Message
793: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Bind Variables Ends');
794: END Bind;
795:
796: PROCEDURE Gen_Select(
797: x_select_cl OUT NOCOPY VARCHAR2

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

798: )
799: IS
800: BEGIN
801: -- Debug Message
802: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Select Begins');
803:
804: x_select_cl := 'Select ' ||
805: 'CSP_PICKLIST_SERIAL_LOTS_V.ROW_ID,' ||
806: 'CSP_PICKLIST_SERIAL_LOTS_V.PICKLIST_SERIAL_LOT_ID,' ||

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

816: 'CSP_PICKLIST_SERIAL_LOTS_V.LOT_NUMBER,' ||
817: 'CSP_PICKLIST_SERIAL_LOTS_V.SERIAL_NUMBER,' ||
818: 'from CSP_PICKLIST_SERIAL_LOTS_V';
819: -- Debug Message
820: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Select Ends');
821:
822: END Gen_Select;
823:
824: PROCEDURE Gen_psl_Where(

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

840: str_csr2 NUMBER;
841: l_operator VARCHAR2(10);
842: BEGIN
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Where Begins');
845:
846: -- There are three examples for each kind of datatype:
847: -- NUMBER, DATE, VARCHAR2.
848: -- Developer can copy and paste the following codes for your own record.

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

926:
927: -- Add more IF statements for each column below
928:
929: -- Debug Message
930: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Generate Where Ends');
931:
932: END Gen_psl_Where;
933:
934: -- Item-level validation procedures

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

935: PROCEDURE Validate_PL_SERIAL_LOT_ID (
936: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
937: P_Validation_mode IN VARCHAR2,
938: P_PICKLIST_SERIAL_LOT_ID IN NUMBER,
939: -- 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.
940: X_Return_Status OUT NOCOPY VARCHAR2,
941: X_Msg_Count OUT NOCOPY NUMBER,
942: X_Msg_Data OUT NOCOPY VARCHAR2
943: )

Line 960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_SERIAL_LOT_ID)');

956:
957: -- validate NOT NULL column
958: IF(p_PICKLIST_SERIAL_LOT_ID is NULL)
959: THEN
960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_SERIAL_LOT_ID)');
961: x_return_status := FND_API.G_RET_STS_ERROR;
962: END IF;
963:
964: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 964: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_SERIAL_LOT_ID)');
961: x_return_status := FND_API.G_RET_STS_ERROR;
962: END IF;
963:
964: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
965: THEN
966: -- Hint: Validate data
967: -- IF p_PICKLIST_SERIAL_LOT_ID is not NULL and p_PICKLIST_SERIAL_LOT_ID <> G_MISS_CHAR
968: -- verify if data is valid

Line 971: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

967: -- IF p_PICKLIST_SERIAL_LOT_ID is not NULL and p_PICKLIST_SERIAL_LOT_ID <> G_MISS_CHAR
968: -- verify if data is valid
969: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
970: NULL;
971: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
972: THEN
973: -- Hint: Validate data
974: -- IF p_PICKLIST_SERIAL_LOT_ID <> G_MISS_CHAR
975: -- verify if data is valid

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

989: PROCEDURE Validate_PICKLIST_LINE_ID (
990: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
991: P_Validation_mode IN VARCHAR2,
992: P_PICKLIST_LINE_ID IN NUMBER,
993: -- 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.
994: X_Return_Status OUT NOCOPY VARCHAR2,
995: X_Msg_Count OUT NOCOPY NUMBER,
996: X_Msg_Data OUT NOCOPY VARCHAR2
997: )

Line 1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_LINE_ID)');

1010:
1011: -- validate NOT NULL column
1012: IF(p_PICKLIST_LINE_ID is NULL)
1013: THEN
1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_LINE_ID)');
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: END IF;
1017:
1018: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1018: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1014: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(PICKLIST_LINE_ID)');
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: END IF;
1017:
1018: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1019: THEN
1020: -- Hint: Validate data
1021: -- IF p_PICKLIST_LINE_ID is not NULL and p_PICKLIST_LINE_ID <> G_MISS_CHAR
1022: -- verify if data is valid

Line 1025: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1021: -- IF p_PICKLIST_LINE_ID is not NULL and p_PICKLIST_LINE_ID <> G_MISS_CHAR
1022: -- verify if data is valid
1023: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1024: NULL;
1025: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1026: THEN
1027: -- Hint: Validate data
1028: -- IF p_PICKLIST_LINE_ID <> G_MISS_CHAR
1029: -- verify if data is valid

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

1043: PROCEDURE Validate_ORGANIZATION_ID (
1044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1045: P_Validation_mode IN VARCHAR2,
1046: P_ORGANIZATION_ID IN NUMBER,
1047: -- 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.
1048: X_Return_Status OUT NOCOPY VARCHAR2,
1049: X_Msg_Count OUT NOCOPY NUMBER,
1050: X_Msg_Data OUT NOCOPY VARCHAR2
1051: )

Line 1068: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(ORGANIZATION_ID)');

1064:
1065: -- validate NOT NULL column
1066: IF(p_ORGANIZATION_ID is NULL)
1067: THEN
1068: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END IF;
1071:
1072: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1072: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1068: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(ORGANIZATION_ID)');
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END IF;
1071:
1072: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1073: THEN
1074: -- Hint: Validate data
1075: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1076: -- verify if data is valid

Line 1079: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1075: -- IF p_ORGANIZATION_ID is not NULL and p_ORGANIZATION_ID <> G_MISS_CHAR
1076: -- verify if data is valid
1077: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1078: NULL;
1079: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)
1080: THEN
1081: -- Hint: Validate data
1082: -- IF p_ORGANIZATION_ID <> G_MISS_CHAR
1083: -- verify if data is valid

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

1097: PROCEDURE Validate_INVENTORY_ITEM_ID (
1098: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1099: P_Validation_mode IN VARCHAR2,
1100: P_INVENTORY_ITEM_ID IN NUMBER,
1101: -- 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.
1102: X_Return_Status OUT NOCOPY VARCHAR2,
1103: X_Msg_Count OUT NOCOPY NUMBER,
1104: X_Msg_Data OUT NOCOPY VARCHAR2
1105: )

Line 1122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');

1118:
1119: -- validate NOT NULL column
1120: IF(p_INVENTORY_ITEM_ID is NULL)
1121: THEN
1122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: END IF;
1125:
1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

Line 1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)

1122: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(INVENTORY_ITEM_ID)');
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: END IF;
1125:
1126: IF(p_validation_mode = JTF_PLSQL_API.G_CREATE)
1127: THEN
1128: -- Hint: Validate data
1129: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> G_MISS_CHAR
1130: -- verify if data is valid

Line 1133: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1129: -- IF p_INVENTORY_ITEM_ID is not NULL and p_INVENTORY_ITEM_ID <> 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_INVENTORY_ITEM_ID <> 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_QUANTITY (
1152: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1153: P_Validation_mode IN VARCHAR2,
1154: P_QUANTITY 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 pick_serial_lots API: -Violate NOT NULL constraint(QUANTITY)');

1172:
1173: -- validate NOT NULL column
1174: IF(p_QUANTITY is NULL)
1175: THEN
1176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'csp', 'Private pick_serial_lots API: -Violate NOT NULL constraint(QUANTITY)');
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 pick_serial_lots API: -Violate NOT NULL constraint(QUANTITY)');
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_QUANTITY is not NULL and p_QUANTITY <> G_MISS_CHAR
1184: -- verify if data is valid

Line 1187: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1183: -- IF p_QUANTITY is not NULL and p_QUANTITY <> 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_QUANTITY <> 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_LOT_NUMBER (
1206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1207: P_Validation_mode IN VARCHAR2,
1208: P_LOT_NUMBER 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_LOT_NUMBER is not NULL and p_LOT_NUMBER <> G_MISS_CHAR
1231: -- verify if data is valid

Line 1234: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1230: -- IF p_LOT_NUMBER is not NULL and p_LOT_NUMBER <> 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_LOT_NUMBER <> 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_SERIAL_NUMBER (
1253: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1254: P_Validation_mode IN VARCHAR2,
1255: P_SERIAL_NUMBER IN VARCHAR2,
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_SERIAL_NUMBER is not NULL and p_SERIAL_NUMBER <> G_MISS_CHAR
1278: -- verify if data is valid

Line 1281: ELSIF(p_validation_mode = JTF_PLSQL_API.G_UPDATE)

1277: -- IF p_SERIAL_NUMBER is not NULL and p_SERIAL_NUMBER <> 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_SERIAL_NUMBER <> G_MISS_CHAR
1285: -- verify if data is valid

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

1296: END Validate_SERIAL_NUMBER;
1297:
1298:
1299: -- Hint: inter-field level validation can be added here.
1300: -- Hint: If p_validation_mode = JTF_PLSQL_API.G_VALIDATE_UPDATE, we should use cursor
1301: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1302: -- stored in database table.
1303: PROCEDURE Validate_psl_rec(
1304: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');

1326: -- THEN
1327: -- x_return_status := FND_API.G_RET_STS_ERROR;
1328:
1329: -- Debug Message
1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');
1331:
1332: -- Standard call to get message count and if count is 1, get message info.
1333: FND_MSG_PUB.Count_And_Get
1334: ( p_count => x_msg_count,

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

1350: l_api_name CONSTANT VARCHAR2(30) := 'Validate_pick_serial_lots';
1351: BEGIN
1352:
1353: -- Debug Message
1354: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'start');
1355:
1356:
1357: -- Initialize API return status to SUCCESS
1358: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1356:
1357: -- Initialize API return status to SUCCESS
1358: x_return_status := FND_API.G_RET_STS_SUCCESS;
1359:
1360: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM) THEN
1361: -- Hint: We provide validation procedure for every column. Developer should delete
1362: -- unnecessary validation procedures.
1363: Validate_PL_SERIAL_LOT_ID(
1364: p_init_msg_list => FND_API.G_FALSE,

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

1445: END IF;
1446:
1447: END IF;
1448:
1449: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_RECORD) THEN
1450: -- Hint: Inter-field level validation can be added here
1451: -- invoke record level validation procedures
1452: Validate_psl_Rec(
1453: p_init_msg_list => FND_API.G_FALSE,

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

1461: raise FND_API.G_EXC_ERROR;
1462: END IF;
1463: END IF;
1464:
1465: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_RECORD) THEN
1466: -- invoke inter-record level validation procedures
1467: NULL;
1468: END IF;
1469:

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

1466: -- invoke inter-record level validation procedures
1467: NULL;
1468: END IF;
1469:
1470: IF (p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_INTER_ENTITY) THEN
1471: -- invoke inter-entity level validation procedures
1472: NULL;
1473: END IF;
1474:

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

1473: END IF;
1474:
1475:
1476: -- Debug Message
1477: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
1478:
1479: END Validate_pick_serial_lots;
1480:
1481: End csp_pick_serial_lots_PVT;