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

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

170: END IF;
171:
172:
173: -- Debug Message
174: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
175:
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
177:
178: -- Initialize API return status to SUCCESS

Line 176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

172:
173: -- Debug Message
174: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
175:
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
177:
178: -- Initialize API return status to SUCCESS
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:

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

182: -- API body
183: --
184:
185: -- Debug Message
186: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','AS: Public API: Convert_TASK_PART_Values_To_Ids');
187:
188: -- Convert the values to ids
189: --
190: -- Convert_TASK_PART_Values_To_Ids (

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

275: END IF;
276:
277:
278: -- Debug Message
279: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'end');
280:
281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
282:
283: -- Standard call to get message count and if count is 1, get message info.

Line 281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

277:
278: -- Debug Message
279: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'end');
280:
281: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
282:
283: -- Standard call to get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,

Line 340: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

336: END IF;
337: */
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
344: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 344: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

340: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
344: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:

Line 350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
354: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
355: ,X_MSG_COUNT => X_MSG_COUNT
356: ,X_MSG_DATA => X_MSG_DATA
357: ,X_RETURN_STATUS => X_RETURN_STATUS);
358:

Line 360: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

356: ,X_MSG_DATA => X_MSG_DATA
357: ,X_RETURN_STATUS => X_RETURN_STATUS);
358:
359: WHEN OTHERS THEN
360: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
361: P_API_NAME => L_API_NAME
362: ,P_PKG_NAME => G_PKG_NAME
363: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
364: ,P_SQLCODE => SQLCODE

Line 363: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

359: WHEN OTHERS THEN
360: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
361: P_API_NAME => L_API_NAME
362: ,P_PKG_NAME => G_PKG_NAME
363: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
364: ,P_SQLCODE => SQLCODE
365: ,P_SQLERRM => SQLERRM
366: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
367: ,X_MSG_COUNT => X_MSG_COUNT

Line 366: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

362: ,P_PKG_NAME => G_PKG_NAME
363: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
364: ,P_SQLCODE => SQLCODE
365: ,P_SQLERRM => SQLERRM
366: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
367: ,X_MSG_COUNT => X_MSG_COUNT
368: ,X_MSG_DATA => X_MSG_DATA
369: ,X_RETURN_STATUS => X_RETURN_STATUS);
370: End Create_task_part;

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

407: END IF;
408:
409:
410: -- Debug Message
411: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
412:
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
414:
415: -- Initialize API return status to SUCCESS

Line 413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

409:
410: -- Debug Message
411: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Public API: ' || l_api_name || 'start');
412:
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
414:
415: -- Initialize API return status to SUCCESS
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:

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

419: -- API body
420: --
421:
422: -- Debug Message
423: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','AS: Public API: Convert_TASK_PART_Values_To_Ids');
424:
425: -- Convert the values to ids
426: --
427: /* Convert_TASK_PART_Values_To_Ids (

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

508: END IF;
509:
510:
511: -- Debug Message
512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'end');
513:
514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
515:
516: -- Standard call to get message count and if count is 1, get message info.

Line 514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

510:
511: -- Debug Message
512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'end');
513:
514: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,

Line 573: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

569: END IF;
570: */
571: EXCEPTION
572: WHEN FND_API.G_EXC_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_ERROR
577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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_ERROR
577: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
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 FND_API.G_EXC_UNEXPECTED_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 587: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 593: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);
591:
592: WHEN OTHERS THEN
593: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
594: P_API_NAME => L_API_NAME
595: ,P_PKG_NAME => G_PKG_NAME
596: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
597: ,P_SQLCODE => SQLCODE

Line 596: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

592: WHEN OTHERS THEN
593: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
594: P_API_NAME => L_API_NAME
595: ,P_PKG_NAME => G_PKG_NAME
596: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
597: ,P_SQLCODE => SQLCODE
598: ,P_SQLERRM => SQLERRM
599: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
600: ,X_MSG_COUNT => X_MSG_COUNT

Line 599: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

595: ,P_PKG_NAME => G_PKG_NAME
596: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
597: ,P_SQLCODE => SQLCODE
598: ,P_SQLERRM => SQLERRM
599: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
600: ,X_MSG_COUNT => X_MSG_COUNT
601: ,X_MSG_DATA => X_MSG_DATA
602: ,X_RETURN_STATUS => X_RETURN_STATUS);
603: End Update_task_part;

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

641: END IF;
642:
643:
644: -- Debug Message
645: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'start');
646:
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648:
649: -- Initialize API return status to SUCCESS

Line 647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

643:
644: -- Debug Message
645: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Public API: ' || l_api_name || 'start');
646:
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648:
649: -- Initialize API return status to SUCCESS
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:

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

653: -- API body
654: --
655:
656: -- Debug Message
657: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','AS: Public API: Convert_TASK_PART_Values_To_Ids');
658:
659: -- Convert the values to ids
660: --
661: /* Convert_TASK_PART_Values_To_Ids (

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

742: END IF;
743:
744:
745: -- Debug Message
746: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
747:
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
749:
750: -- Standard call to get message count and if count is 1, get message info.

Line 748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

744:
745: -- Debug Message
746: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
747:
748: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
749:
750: -- Standard call to get message count and if count is 1, get message info.
751: FND_MSG_PUB.Count_And_Get
752: ( p_count => x_msg_count,

Line 807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

803: END IF;
804: */
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
811: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
812: ,X_MSG_COUNT => X_MSG_COUNT
813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);
815:

Line 817: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);
815:
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
818: P_API_NAME => L_API_NAME
819: ,P_PKG_NAME => G_PKG_NAME
820: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
821: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 821: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

817: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
818: P_API_NAME => L_API_NAME
819: ,P_PKG_NAME => G_PKG_NAME
820: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
821: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
822: ,X_MSG_COUNT => X_MSG_COUNT
823: ,X_MSG_DATA => X_MSG_DATA
824: ,X_RETURN_STATUS => X_RETURN_STATUS);
825:

Line 827: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

823: ,X_MSG_DATA => X_MSG_DATA
824: ,X_RETURN_STATUS => X_RETURN_STATUS);
825:
826: WHEN OTHERS THEN
827: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
828: P_API_NAME => L_API_NAME
829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
831: ,P_SQLCODE => SQLCODE

Line 830: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

826: WHEN OTHERS THEN
827: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
828: P_API_NAME => L_API_NAME
829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
831: ,P_SQLCODE => SQLCODE
832: ,P_SQLERRM => SQLERRM
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
834: ,X_MSG_COUNT => X_MSG_COUNT

Line 833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
831: ,P_SQLCODE => SQLCODE
832: ,P_SQLERRM => SQLERRM
833: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
834: ,X_MSG_COUNT => X_MSG_COUNT
835: ,X_MSG_DATA => X_MSG_DATA
836: ,X_RETURN_STATUS => X_RETURN_STATUS);
837: End Delete_task_part;

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

883: END IF;
884:
885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'start');
888:
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
890:
891: -- Initialize API return status to SUCCESS

Line 889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

885:
886: -- Debug Message
887: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'start');
888:
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
890:
891: -- Initialize API return status to SUCCESS
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:

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

894: --
895: -- API body
896: --
897: -- Debug Message
898: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: - Calling PVT.Get_TASK_PART');
899: /*
900: CSP_task_part_PVT.Get_task_part(
901: P_Api_Version_Number => 1.0,
902: P_Init_Msg_List => FND_API.G_FALSE,

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

931: -- End of API body
932: --
933:
934: -- Debug Message
935: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
936:
937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
938:
939: -- Standard call to get message count and if count is 1, get message info.

Line 937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

933:
934: -- Debug Message
935: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: ' || l_api_name || 'end');
936:
937: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
938:
939: -- Standard call to get message count and if count is 1, get message info.
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count,

Line 947: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

943: );
944:
945: EXCEPTION
946: WHEN FND_API.G_EXC_ERROR THEN
947: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
948: P_API_NAME => L_API_NAME
949: ,P_PKG_NAME => G_PKG_NAME
950: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
951: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 951: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

947: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
948: P_API_NAME => L_API_NAME
949: ,P_PKG_NAME => G_PKG_NAME
950: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
951: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
952: ,X_MSG_COUNT => X_MSG_COUNT
953: ,X_MSG_DATA => X_MSG_DATA
954: ,X_RETURN_STATUS => X_RETURN_STATUS);
955:

Line 957: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

953: ,X_MSG_DATA => X_MSG_DATA
954: ,X_RETURN_STATUS => X_RETURN_STATUS);
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
958: P_API_NAME => L_API_NAME
959: ,P_PKG_NAME => G_PKG_NAME
960: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
961: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 961: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

957: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
958: P_API_NAME => L_API_NAME
959: ,P_PKG_NAME => G_PKG_NAME
960: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
961: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
962: ,X_MSG_COUNT => X_MSG_COUNT
963: ,X_MSG_DATA => X_MSG_DATA
964: ,X_RETURN_STATUS => X_RETURN_STATUS);
965:

Line 967: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

963: ,X_MSG_DATA => X_MSG_DATA
964: ,X_RETURN_STATUS => X_RETURN_STATUS);
965:
966: WHEN OTHERS THEN
967: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
968: P_API_NAME => L_API_NAME
969: ,P_PKG_NAME => G_PKG_NAME
970: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
971: ,P_SQLCODE => SQLCODE

Line 970: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

966: WHEN OTHERS THEN
967: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
968: P_API_NAME => L_API_NAME
969: ,P_PKG_NAME => G_PKG_NAME
970: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
971: ,P_SQLCODE => SQLCODE
972: ,P_SQLERRM => SQLERRM
973: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
974: ,X_MSG_COUNT => X_MSG_COUNT

Line 973: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

969: ,P_PKG_NAME => G_PKG_NAME
970: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
971: ,P_SQLCODE => SQLCODE
972: ,P_SQLERRM => SQLERRM
973: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
974: ,X_MSG_COUNT => X_MSG_COUNT
975: ,X_MSG_DATA => X_MSG_DATA
976: ,X_RETURN_STATUS => X_RETURN_STATUS);
977: End Get_task_part;