176: END IF;
177:
178:
179: -- Debug Message
180: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
181:
182:
183: -- Initialize API return status to SUCCESS
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: -- API body
188: --
189:
190: -- Debug Message
191: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
192:
193: -- Convert the values to ids
194: --
195: Convert_PLH_Values_To_Ids (
231: END IF;
232:
233:
234: -- Debug Message
235: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
236:
237:
238: -- Standard call to get message count and if count is 1, get message info.
239: FND_MSG_PUB.Count_And_Get
242: );
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
250: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
251: ,X_MSG_COUNT => X_MSG_COUNT
252: ,X_MSG_DATA => X_MSG_DATA
253: ,X_RETURN_STATUS => X_RETURN_STATUS);
254:
252: ,X_MSG_DATA => X_MSG_DATA
253: ,X_RETURN_STATUS => X_RETURN_STATUS);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
257: P_API_NAME => L_API_NAME
258: ,P_PKG_NAME => G_PKG_NAME
259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
260: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
257: P_API_NAME => L_API_NAME
258: ,P_PKG_NAME => G_PKG_NAME
259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
260: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
261: ,X_MSG_COUNT => X_MSG_COUNT
262: ,X_MSG_DATA => X_MSG_DATA
263: ,X_RETURN_STATUS => X_RETURN_STATUS);
264:
262: ,X_MSG_DATA => X_MSG_DATA
263: ,X_RETURN_STATUS => X_RETURN_STATUS);
264:
265: WHEN OTHERS THEN
266: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
267: P_API_NAME => L_API_NAME
268: ,P_PKG_NAME => G_PKG_NAME
269: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
265: WHEN OTHERS THEN
266: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
267: P_API_NAME => L_API_NAME
268: ,P_PKG_NAME => G_PKG_NAME
269: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
271: ,X_MSG_COUNT => X_MSG_COUNT
272: ,X_MSG_DATA => X_MSG_DATA
273: ,X_RETURN_STATUS => X_RETURN_STATUS);
266: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
267: P_API_NAME => L_API_NAME
268: ,P_PKG_NAME => G_PKG_NAME
269: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
271: ,X_MSG_COUNT => X_MSG_COUNT
272: ,X_MSG_DATA => X_MSG_DATA
273: ,X_RETURN_STATUS => X_RETURN_STATUS);
274: End Create_packlist_headers;
311: END IF;
312:
313:
314: -- Debug Message
315: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
316:
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: -- API body
323: --
324:
325: -- Debug Message
326: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
327:
328: -- Convert the values to ids
329: --
330: Convert_PLH_Values_To_Ids (
363: END IF;
364:
365:
366: -- Debug Message
367: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
368:
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
374: );
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
382: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
382: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
393: ,X_MSG_COUNT => X_MSG_COUNT
394: ,X_MSG_DATA => X_MSG_DATA
395: ,X_RETURN_STATUS => X_RETURN_STATUS);
396:
394: ,X_MSG_DATA => X_MSG_DATA
395: ,X_RETURN_STATUS => X_RETURN_STATUS);
396:
397: WHEN OTHERS THEN
398: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
399: P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
402: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
397: WHEN OTHERS THEN
398: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
399: P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
402: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
398: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
399: P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME
401: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
402: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406: End Update_packlist_headers;
444: END IF;
445:
446:
447: -- Debug Message
448: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
449:
450:
451: -- Initialize API return status to SUCCESS
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
455: -- API body
456: --
457:
458: -- Debug Message
459: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_PLH_Values_To_Ids');
460:
461: -- Convert the values to ids
462: --
463: Convert_PLH_Values_To_Ids (
496: END IF;
497:
498:
499: -- Debug Message
500: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
501:
502:
503: -- Standard call to get message count and if count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get
507: );
508:
509: EXCEPTION
510: WHEN FND_API.G_EXC_ERROR THEN
511: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
511: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
522: P_API_NAME => L_API_NAME
523: ,P_PKG_NAME => G_PKG_NAME
524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
525: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
521: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
522: P_API_NAME => L_API_NAME
523: ,P_PKG_NAME => G_PKG_NAME
524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
525: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
526: ,X_MSG_COUNT => X_MSG_COUNT
527: ,X_MSG_DATA => X_MSG_DATA
528: ,X_RETURN_STATUS => X_RETURN_STATUS);
529:
527: ,X_MSG_DATA => X_MSG_DATA
528: ,X_RETURN_STATUS => X_RETURN_STATUS);
529:
530: WHEN OTHERS THEN
531: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
532: P_API_NAME => L_API_NAME
533: ,P_PKG_NAME => G_PKG_NAME
534: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
535: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
530: WHEN OTHERS THEN
531: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
532: P_API_NAME => L_API_NAME
533: ,P_PKG_NAME => G_PKG_NAME
534: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
535: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
536: ,X_MSG_COUNT => X_MSG_COUNT
537: ,X_MSG_DATA => X_MSG_DATA
538: ,X_RETURN_STATUS => X_RETURN_STATUS);
531: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
532: P_API_NAME => L_API_NAME
533: ,P_PKG_NAME => G_PKG_NAME
534: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
535: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
536: ,X_MSG_COUNT => X_MSG_COUNT
537: ,X_MSG_DATA => X_MSG_DATA
538: ,X_RETURN_STATUS => X_RETURN_STATUS);
539: End Delete_packlist_headers;
585: END IF;
586:
587:
588: -- Debug Message
589: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
590:
591:
592: -- Initialize API return status to SUCCESS
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
595: --
596: -- API body
597: --
598: -- Debug Message
599: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Packlist_Headers');
600: /*
601: CSP_packlist_headers_PVT.Get_packlist_headers(
602: P_Api_Version_Number => 2.0,
603: P_Init_Msg_List => FND_API.G_FALSE,
633: -- End of API body
634: --
635:
636: -- Debug Message
637: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.
641: FND_MSG_PUB.Count_And_Get
644: );
645:
646: EXCEPTION
647: WHEN FND_API.G_EXC_ERROR THEN
648: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
652: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
648: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
652: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
662: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
663: ,X_MSG_COUNT => X_MSG_COUNT
664: ,X_MSG_DATA => X_MSG_DATA
665: ,X_RETURN_STATUS => X_RETURN_STATUS);
666:
664: ,X_MSG_DATA => X_MSG_DATA
665: ,X_RETURN_STATUS => X_RETURN_STATUS);
666:
667: WHEN OTHERS THEN
668: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME
670: ,P_PKG_NAME => G_PKG_NAME
671: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
672: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
667: WHEN OTHERS THEN
668: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME
670: ,P_PKG_NAME => G_PKG_NAME
671: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
672: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
673: ,X_MSG_COUNT => X_MSG_COUNT
674: ,X_MSG_DATA => X_MSG_DATA
675: ,X_RETURN_STATUS => X_RETURN_STATUS);
668: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
669: P_API_NAME => L_API_NAME
670: ,P_PKG_NAME => G_PKG_NAME
671: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
672: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
673: ,X_MSG_COUNT => X_MSG_COUNT
674: ,X_MSG_DATA => X_MSG_DATA
675: ,X_RETURN_STATUS => X_RETURN_STATUS);
676: End Get_packlist_headers;