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

Line 195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

191: END IF;
192: */
193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 204: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
205: P_API_NAME => L_API_NAME
206: ,P_PKG_NAME => G_PKG_NAME
207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
208: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 208: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

204: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
205: P_API_NAME => L_API_NAME
206: ,P_PKG_NAME => G_PKG_NAME
207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
208: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
209: ,X_MSG_COUNT => X_MSG_COUNT
210: ,X_MSG_DATA => X_MSG_DATA
211: ,X_RETURN_STATUS => X_RETURN_STATUS);
212: WHEN OTHERS THEN

Line 213: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

209: ,X_MSG_COUNT => X_MSG_COUNT
210: ,X_MSG_DATA => X_MSG_DATA
211: ,X_RETURN_STATUS => X_RETURN_STATUS);
212: WHEN OTHERS THEN
213: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE

Line 216: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

212: WHEN OTHERS THEN
213: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE
218: ,P_SQLERRM => SQLERRM
219: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT

Line 219: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
217: ,P_SQLCODE => SQLCODE
218: ,P_SQLERRM => SQLERRM
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: End Create_product_task;

Line 387: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

383: END IF;
384: */
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME
389: ,P_PKG_NAME => G_PKG_NAME
390: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
391: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 391: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

387: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME
389: ,P_PKG_NAME => G_PKG_NAME
390: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
391: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
392: ,X_MSG_COUNT => X_MSG_COUNT
393: ,X_MSG_DATA => X_MSG_DATA
394: ,X_RETURN_STATUS => X_RETURN_STATUS);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 396: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

392: ,X_MSG_COUNT => X_MSG_COUNT
393: ,X_MSG_DATA => X_MSG_DATA
394: ,X_RETURN_STATUS => X_RETURN_STATUS);
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
397: P_API_NAME => L_API_NAME
398: ,P_PKG_NAME => G_PKG_NAME
399: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
400: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 400: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

396: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
397: P_API_NAME => L_API_NAME
398: ,P_PKG_NAME => G_PKG_NAME
399: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
400: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
401: ,X_MSG_COUNT => X_MSG_COUNT
402: ,X_MSG_DATA => X_MSG_DATA
403: ,X_RETURN_STATUS => X_RETURN_STATUS);
404: WHEN OTHERS THEN

Line 405: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

401: ,X_MSG_COUNT => X_MSG_COUNT
402: ,X_MSG_DATA => X_MSG_DATA
403: ,X_RETURN_STATUS => X_RETURN_STATUS);
404: WHEN OTHERS THEN
405: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
406: P_API_NAME => L_API_NAME
407: ,P_PKG_NAME => G_PKG_NAME
408: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
409: ,P_SQLCODE => SQLCODE

Line 408: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

404: WHEN OTHERS THEN
405: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
406: P_API_NAME => L_API_NAME
407: ,P_PKG_NAME => G_PKG_NAME
408: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
409: ,P_SQLCODE => SQLCODE
410: ,P_SQLERRM => SQLERRM
411: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
412: ,X_MSG_COUNT => X_MSG_COUNT

Line 411: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

407: ,P_PKG_NAME => G_PKG_NAME
408: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
409: ,P_SQLCODE => SQLCODE
410: ,P_SQLERRM => SQLERRM
411: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
412: ,X_MSG_COUNT => X_MSG_COUNT
413: ,X_MSG_DATA => X_MSG_DATA
414: ,X_RETURN_STATUS => X_RETURN_STATUS);
415: End Update_product_task;

Line 576: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

572: END IF;
573: */
574: EXCEPTION
575: WHEN FND_API.G_EXC_ERROR THEN
576: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
577: P_API_NAME => L_API_NAME
578: ,P_PKG_NAME => G_PKG_NAME
579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
580: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 580: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

576: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
577: P_API_NAME => L_API_NAME
578: ,P_PKG_NAME => G_PKG_NAME
579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
580: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
581: ,X_MSG_COUNT => X_MSG_COUNT
582: ,X_MSG_DATA => X_MSG_DATA
583: ,X_RETURN_STATUS => X_RETURN_STATUS);
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 585: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

581: ,X_MSG_COUNT => X_MSG_COUNT
582: ,X_MSG_DATA => X_MSG_DATA
583: ,X_RETURN_STATUS => X_RETURN_STATUS);
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
586: P_API_NAME => L_API_NAME
587: ,P_PKG_NAME => G_PKG_NAME
588: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
589: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 589: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 594: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 597: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 600: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 687: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

683: p_data => x_msg_data
684: );
685: EXCEPTION
686: WHEN FND_API.G_EXC_ERROR THEN
687: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
691: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 691: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

687: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
691: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
692: ,X_MSG_COUNT => X_MSG_COUNT
693: ,X_MSG_DATA => X_MSG_DATA
694: ,X_RETURN_STATUS => X_RETURN_STATUS);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 696: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

692: ,X_MSG_COUNT => X_MSG_COUNT
693: ,X_MSG_DATA => X_MSG_DATA
694: ,X_RETURN_STATUS => X_RETURN_STATUS);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
697: P_API_NAME => L_API_NAME
698: ,P_PKG_NAME => G_PKG_NAME
699: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
700: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 700: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

696: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
697: P_API_NAME => L_API_NAME
698: ,P_PKG_NAME => G_PKG_NAME
699: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
700: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
701: ,X_MSG_COUNT => X_MSG_COUNT
702: ,X_MSG_DATA => X_MSG_DATA
703: ,X_RETURN_STATUS => X_RETURN_STATUS);
704: WHEN OTHERS THEN

Line 705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

701: ,X_MSG_COUNT => X_MSG_COUNT
702: ,X_MSG_DATA => X_MSG_DATA
703: ,X_RETURN_STATUS => X_RETURN_STATUS);
704: WHEN OTHERS THEN
705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
706: P_API_NAME => L_API_NAME
707: ,P_PKG_NAME => G_PKG_NAME
708: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
709: ,P_SQLCODE => SQLCODE

Line 708: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

704: WHEN OTHERS THEN
705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
706: P_API_NAME => L_API_NAME
707: ,P_PKG_NAME => G_PKG_NAME
708: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
709: ,P_SQLCODE => SQLCODE
710: ,P_SQLERRM => SQLERRM
711: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
712: ,X_MSG_COUNT => X_MSG_COUNT

Line 711: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

707: ,P_PKG_NAME => G_PKG_NAME
708: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
709: ,P_SQLCODE => SQLCODE
710: ,P_SQLERRM => SQLERRM
711: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
712: ,X_MSG_COUNT => X_MSG_COUNT
713: ,X_MSG_DATA => X_MSG_DATA
714: ,X_RETURN_STATUS => X_RETURN_STATUS);
715: End Get_product_task;