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

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

308: END IF;
309:
310:
311: -- Debug Message
312: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
313:
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 323: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');

319: -- API body
320: --
321:
322: -- Debug Message
323: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');
324:
325: -- Convert the values to ids
326: --
327: Convert_RQH_Values_To_Ids (

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

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

Line 378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 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:

Line 388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 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:

Line 398: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 401: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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);

Line 402: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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 Create_requirement_headers;

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

487: END IF;
488:
489:
490: -- Debug Message
491: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get

Line 502: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

498: );
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
503: P_API_NAME => L_API_NAME
504: ,P_PKG_NAME => G_PKG_NAME
505: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
506: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 506: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 512: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

508: ,X_MSG_DATA => X_MSG_DATA
509: ,X_RETURN_STATUS => X_RETURN_STATUS);
510:
511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
512: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 516: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

521: WHEN OTHERS THEN
522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
523: P_API_NAME => L_API_NAME
524: ,P_PKG_NAME => G_PKG_NAME
525: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
526: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
527: ,X_MSG_COUNT => X_MSG_COUNT
528: ,X_MSG_DATA => X_MSG_DATA
529: ,X_RETURN_STATUS => X_RETURN_STATUS);
530: End Update_requirement_headers;

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

615: END IF;
616:
617:
618: -- Debug Message
619: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
620:
621:
622: -- Initialize API return status to SUCCESS
623: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 630: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');

626: -- API body
627: --
628:
629: -- Debug Message
630: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');
631:
632: -- Convert the values to ids
633: --
634: Convert_RQH_Values_To_Ids (

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

692: COMMIT WORK;
693: END IF;
694:
695: -- Debug Message
696: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,

Line 706: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

702: );
703:
704: EXCEPTION
705: WHEN FND_API.G_EXC_ERROR THEN
706: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
707: P_API_NAME => L_API_NAME
708: ,P_PKG_NAME => G_PKG_NAME
709: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
710: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 710: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

706: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
707: P_API_NAME => L_API_NAME
708: ,P_PKG_NAME => G_PKG_NAME
709: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
710: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
711: ,X_MSG_COUNT => X_MSG_COUNT
712: ,X_MSG_DATA => X_MSG_DATA
713: ,X_RETURN_STATUS => X_RETURN_STATUS);
714:

Line 716: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

712: ,X_MSG_DATA => X_MSG_DATA
713: ,X_RETURN_STATUS => X_RETURN_STATUS);
714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
717: P_API_NAME => L_API_NAME
718: ,P_PKG_NAME => G_PKG_NAME
719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
720: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 720: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

716: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
717: P_API_NAME => L_API_NAME
718: ,P_PKG_NAME => G_PKG_NAME
719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
720: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
721: ,X_MSG_COUNT => X_MSG_COUNT
722: ,X_MSG_DATA => X_MSG_DATA
723: ,X_RETURN_STATUS => X_RETURN_STATUS);
724:

Line 726: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

722: ,X_MSG_DATA => X_MSG_DATA
723: ,X_RETURN_STATUS => X_RETURN_STATUS);
724:
725: WHEN OTHERS THEN
726: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
727: P_API_NAME => L_API_NAME
728: ,P_PKG_NAME => G_PKG_NAME
729: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
730: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 729: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

725: WHEN OTHERS THEN
726: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
727: P_API_NAME => L_API_NAME
728: ,P_PKG_NAME => G_PKG_NAME
729: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
730: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
731: ,X_MSG_COUNT => X_MSG_COUNT
732: ,X_MSG_DATA => X_MSG_DATA
733: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 730: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

726: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
727: P_API_NAME => L_API_NAME
728: ,P_PKG_NAME => G_PKG_NAME
729: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
730: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
731: ,X_MSG_COUNT => X_MSG_COUNT
732: ,X_MSG_DATA => X_MSG_DATA
733: ,X_RETURN_STATUS => X_RETURN_STATUS);
734: End Delete_requirement_headers;