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

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

145: END IF;
146:
147:
148: -- Debug Message
149: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
150:
151:
152: -- Initialize API return status to SUCCESS
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 160: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

156: -- API body
157: --
158:
159: -- Debug Message
160: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
161:
162: -- Convert the values to ids
163: --
164: Convert_plsl_Values_To_Ids (

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

200: END IF;
201:
202:
203: -- Debug Message
204: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
205:
206:
207: -- Standard call to get message count and if count is 1, get message info.
208: FND_MSG_PUB.Count_And_Get

Line 215: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

211: );
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
219: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 219: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 225: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 229: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 238: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

235: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
236: P_API_NAME => L_API_NAME
237: ,P_PKG_NAME => G_PKG_NAME
238: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
239: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
240: ,X_MSG_COUNT => X_MSG_COUNT
241: ,X_MSG_DATA => X_MSG_DATA
242: ,X_RETURN_STATUS => X_RETURN_STATUS);
243: End Create_pack_serial_lots;

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

280: END IF;
281:
282:
283: -- Debug Message
284: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
285:
286:
287: -- Initialize API return status to SUCCESS
288: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

291: -- API body
292: --
293:
294: -- Debug Message
295: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
296:
297: -- Convert the values to ids
298: --
299: Convert_plsl_Values_To_Ids (

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

332: END IF;
333:
334:
335: -- Debug Message
336: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
337:
338:
339: -- Standard call to get message count and if count is 1, get message info.
340: FND_MSG_PUB.Count_And_Get

Line 347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

343: );
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
348: P_API_NAME => L_API_NAME
349: ,P_PKG_NAME => G_PKG_NAME
350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

347: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
348: P_API_NAME => L_API_NAME
349: ,P_PKG_NAME => G_PKG_NAME
350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
351: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
352: ,X_MSG_COUNT => X_MSG_COUNT
353: ,X_MSG_DATA => X_MSG_DATA
354: ,X_RETURN_STATUS => X_RETURN_STATUS);
355:

Line 357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

353: ,X_MSG_DATA => X_MSG_DATA
354: ,X_RETURN_STATUS => X_RETURN_STATUS);
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
358: P_API_NAME => L_API_NAME
359: ,P_PKG_NAME => G_PKG_NAME
360: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

357: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
358: P_API_NAME => L_API_NAME
359: ,P_PKG_NAME => G_PKG_NAME
360: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
361: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
362: ,X_MSG_COUNT => X_MSG_COUNT
363: ,X_MSG_DATA => X_MSG_DATA
364: ,X_RETURN_STATUS => X_RETURN_STATUS);
365:

Line 367: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

363: ,X_MSG_DATA => X_MSG_DATA
364: ,X_RETURN_STATUS => X_RETURN_STATUS);
365:
366: WHEN OTHERS THEN
367: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
368: P_API_NAME => L_API_NAME
369: ,P_PKG_NAME => G_PKG_NAME
370: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
371: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 370: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

366: WHEN OTHERS THEN
367: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
368: P_API_NAME => L_API_NAME
369: ,P_PKG_NAME => G_PKG_NAME
370: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
371: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
372: ,X_MSG_COUNT => X_MSG_COUNT
373: ,X_MSG_DATA => X_MSG_DATA
374: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 371: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

367: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
368: P_API_NAME => L_API_NAME
369: ,P_PKG_NAME => G_PKG_NAME
370: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
371: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
372: ,X_MSG_COUNT => X_MSG_COUNT
373: ,X_MSG_DATA => X_MSG_DATA
374: ,X_RETURN_STATUS => X_RETURN_STATUS);
375: End Update_pack_serial_lots;

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

413: END IF;
414:
415:
416: -- Debug Message
417: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
418:
419:
420: -- Initialize API return status to SUCCESS
421: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 428: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');

424: -- API body
425: --
426:
427: -- Debug Message
428: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_plsl_Values_To_Ids');
429:
430: -- Convert the values to ids
431: --
432: Convert_plsl_Values_To_Ids (

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

465: END IF;
466:
467:
468: -- Debug Message
469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
470:
471:
472: -- Standard call to get message count and if count is 1, get message info.
473: FND_MSG_PUB.Count_And_Get

Line 480: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

476: );
477:
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
484: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 484: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

480: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
481: P_API_NAME => L_API_NAME
482: ,P_PKG_NAME => G_PKG_NAME
483: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
484: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
485: ,X_MSG_COUNT => X_MSG_COUNT
486: ,X_MSG_DATA => X_MSG_DATA
487: ,X_RETURN_STATUS => X_RETURN_STATUS);
488:

Line 490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

486: ,X_MSG_DATA => X_MSG_DATA
487: ,X_RETURN_STATUS => X_RETURN_STATUS);
488:
489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498:

Line 500: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498:
499: WHEN OTHERS THEN
500: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
501: P_API_NAME => L_API_NAME
502: ,P_PKG_NAME => G_PKG_NAME
503: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
504: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 503: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

499: WHEN OTHERS THEN
500: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
501: P_API_NAME => L_API_NAME
502: ,P_PKG_NAME => G_PKG_NAME
503: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
504: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
505: ,X_MSG_COUNT => X_MSG_COUNT
506: ,X_MSG_DATA => X_MSG_DATA
507: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 504: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

500: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
501: P_API_NAME => L_API_NAME
502: ,P_PKG_NAME => G_PKG_NAME
503: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
504: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
505: ,X_MSG_COUNT => X_MSG_COUNT
506: ,X_MSG_DATA => X_MSG_DATA
507: ,X_RETURN_STATUS => X_RETURN_STATUS);
508: End Delete_pack_serial_lots;

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

554: END IF;
555:
556:
557: -- Debug Message
558: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
559:
560:
561: -- Initialize API return status to SUCCESS
562: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Pack_Serial_Lots');

564: --
565: -- API body
566: --
567: -- Debug Message
568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Pack_Serial_Lots');
569: /*
570: CSP_pack_serial_lots_PVT.Get_pack_serial_lots(
571: P_Api_Version_Number => 2.0,
572: P_Init_Msg_List => FND_API.G_FALSE,

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

602: -- End of API body
603: --
604:
605: -- Debug Message
606: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
607:
608:
609: -- Standard call to get message count and if count is 1, get message info.
610: FND_MSG_PUB.Count_And_Get

Line 617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

613: );
614:
615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

617: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
618: P_API_NAME => L_API_NAME
619: ,P_PKG_NAME => G_PKG_NAME
620: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
621: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
622: ,X_MSG_COUNT => X_MSG_COUNT
623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:

Line 627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

623: ,X_MSG_DATA => X_MSG_DATA
624: ,X_RETURN_STATUS => X_RETURN_STATUS);
625:
626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

627: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
628: P_API_NAME => L_API_NAME
629: ,P_PKG_NAME => G_PKG_NAME
630: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
631: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
632: ,X_MSG_COUNT => X_MSG_COUNT
633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:

Line 637: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

633: ,X_MSG_DATA => X_MSG_DATA
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:
636: WHEN OTHERS THEN
637: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
638: P_API_NAME => L_API_NAME
639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
641: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 640: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

636: WHEN OTHERS THEN
637: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
638: P_API_NAME => L_API_NAME
639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
641: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
642: ,X_MSG_COUNT => X_MSG_COUNT
643: ,X_MSG_DATA => X_MSG_DATA
644: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 641: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

637: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
638: P_API_NAME => L_API_NAME
639: ,P_PKG_NAME => G_PKG_NAME
640: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
641: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
642: ,X_MSG_COUNT => X_MSG_COUNT
643: ,X_MSG_DATA => X_MSG_DATA
644: ,X_RETURN_STATUS => X_RETURN_STATUS);
645: End Get_pack_serial_lots;