DBA Data[Home] [Help]

APPS.CSP_ORDERLINES_PUB dependencies on JTF_PLSQL_API

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

161: END IF;
162:
163:
164: -- Debug Message
165: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
166:
167:
168: -- Initialize API return status to SUCCESS
169: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

172: -- API body
173: --
174:
175: -- Debug Message
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
177:
178: -- Convert the values to ids
179: --
180: Convert_mol_Values_To_Ids (

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

216: END IF;
217:
218:
219: -- Debug Message
220: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
221:
222:
223: -- Standard call to get message count and if count is 1, get message info.
224: FND_MSG_PUB.Count_And_Get

Line 231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

227: );
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
232: P_API_NAME => L_API_NAME
233: ,P_PKG_NAME => G_PKG_NAME
234: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 235: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

237: ,X_MSG_DATA => X_MSG_DATA
238: ,X_RETURN_STATUS => X_RETURN_STATUS);
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
245: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
246: ,X_MSG_COUNT => X_MSG_COUNT
247: ,X_MSG_DATA => X_MSG_DATA
248: ,X_RETURN_STATUS => X_RETURN_STATUS);
249:

Line 251: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

247: ,X_MSG_DATA => X_MSG_DATA
248: ,X_RETURN_STATUS => X_RETURN_STATUS);
249:
250: WHEN OTHERS THEN
251: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
252: P_API_NAME => L_API_NAME
253: ,P_PKG_NAME => G_PKG_NAME
254: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
255: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 254: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

250: WHEN OTHERS THEN
251: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
252: P_API_NAME => L_API_NAME
253: ,P_PKG_NAME => G_PKG_NAME
254: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
255: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
256: ,X_MSG_COUNT => X_MSG_COUNT
257: ,X_MSG_DATA => X_MSG_DATA
258: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 255: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

251: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
252: P_API_NAME => L_API_NAME
253: ,P_PKG_NAME => G_PKG_NAME
254: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
255: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
256: ,X_MSG_COUNT => X_MSG_COUNT
257: ,X_MSG_DATA => X_MSG_DATA
258: ,X_RETURN_STATUS => X_RETURN_STATUS);
259: End Create_orderlines;

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

296: END IF;
297:
298:
299: -- Debug Message
300: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
301:
302:
303: -- Initialize API return status to SUCCESS
304: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

307: -- API body
308: --
309:
310: -- Debug Message
311: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
312:
313: -- Convert the values to ids
314: --
315: Convert_mol_Values_To_Ids (

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

348: END IF;
349:
350:
351: -- Debug Message
352: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
353:
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get

Line 363: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

359: );
360:
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
363: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
364: P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
367: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 367: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 373: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

369: ,X_MSG_DATA => X_MSG_DATA
370: ,X_RETURN_STATUS => X_RETURN_STATUS);
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
374: P_API_NAME => L_API_NAME
375: ,P_PKG_NAME => G_PKG_NAME
376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
377: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 377: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

373: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
374: P_API_NAME => L_API_NAME
375: ,P_PKG_NAME => G_PKG_NAME
376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
377: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
378: ,X_MSG_COUNT => X_MSG_COUNT
379: ,X_MSG_DATA => X_MSG_DATA
380: ,X_RETURN_STATUS => X_RETURN_STATUS);
381:

Line 383: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

379: ,X_MSG_DATA => X_MSG_DATA
380: ,X_RETURN_STATUS => X_RETURN_STATUS);
381:
382: WHEN OTHERS THEN
383: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
384: P_API_NAME => L_API_NAME
385: ,P_PKG_NAME => G_PKG_NAME
386: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
387: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 386: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

382: WHEN OTHERS THEN
383: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
384: P_API_NAME => L_API_NAME
385: ,P_PKG_NAME => G_PKG_NAME
386: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
387: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
388: ,X_MSG_COUNT => X_MSG_COUNT
389: ,X_MSG_DATA => X_MSG_DATA
390: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 387: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

383: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
384: P_API_NAME => L_API_NAME
385: ,P_PKG_NAME => G_PKG_NAME
386: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
387: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
388: ,X_MSG_COUNT => X_MSG_COUNT
389: ,X_MSG_DATA => X_MSG_DATA
390: ,X_RETURN_STATUS => X_RETURN_STATUS);
391: End Update_orderlines;

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

429: END IF;
430:
431:
432: -- Debug Message
433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
434:
435:
436: -- Initialize API return status to SUCCESS
437: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

440: -- API body
441: --
442:
443: -- Debug Message
444: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_mol_Values_To_Ids');
445:
446: -- Convert the values to ids
447: --
448: Convert_mol_Values_To_Ids (

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

481: END IF;
482:
483:
484: -- Debug Message
485: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
486:
487:
488: -- Standard call to get message count and if count is 1, get message info.
489: FND_MSG_PUB.Count_And_Get

Line 496: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

492: );
493:
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
500: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 500: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 506: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

502: ,X_MSG_DATA => X_MSG_DATA
503: ,X_RETURN_STATUS => X_RETURN_STATUS);
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
507: P_API_NAME => L_API_NAME
508: ,P_PKG_NAME => G_PKG_NAME
509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
510: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 510: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

506: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
507: P_API_NAME => L_API_NAME
508: ,P_PKG_NAME => G_PKG_NAME
509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
510: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
511: ,X_MSG_COUNT => X_MSG_COUNT
512: ,X_MSG_DATA => X_MSG_DATA
513: ,X_RETURN_STATUS => X_RETURN_STATUS);
514:

Line 516: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 519: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

515: WHEN OTHERS THEN
516: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
517: P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME
519: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
520: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
521: ,X_MSG_COUNT => X_MSG_COUNT
522: ,X_MSG_DATA => X_MSG_DATA
523: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 520: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

516: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
517: P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME
519: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
520: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
521: ,X_MSG_COUNT => X_MSG_COUNT
522: ,X_MSG_DATA => X_MSG_DATA
523: ,X_RETURN_STATUS => X_RETURN_STATUS);
524: End Delete_orderlines;

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

570: END IF;
571:
572:
573: -- Debug Message
574: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
575:
576:
577: -- Initialize API return status to SUCCESS
578: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

580: --
581: -- API body
582: --
583: -- Debug Message
584: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_ORDERLINES');
585: /*
586: CSP_orderlines_PVT.Get_orderlines(
587: P_Api_Version_Number => 2.0,
588: P_Init_Msg_List => FND_API.G_FALSE,

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

618: -- End of API body
619: --
620:
621: -- Debug Message
622: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get

Line 633: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

629: );
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
637: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 637: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 643: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
647: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 647: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

643: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
647: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
648: ,X_MSG_COUNT => X_MSG_COUNT
649: ,X_MSG_DATA => X_MSG_DATA
650: ,X_RETURN_STATUS => X_RETURN_STATUS);
651:

Line 653: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

649: ,X_MSG_DATA => X_MSG_DATA
650: ,X_RETURN_STATUS => X_RETURN_STATUS);
651:
652: WHEN OTHERS THEN
653: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 656: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

652: WHEN OTHERS THEN
653: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 657: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

653: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);
661: End Get_orderlines;