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

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

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

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

310: -- API body
311: --
312:
313: -- Debug Message
314: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
315:
316: -- Convert the values to ids
317: --
318: Convert_RQL_Values_To_Ids (

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

394: END IF;
395:
396:
397: -- Debug Message
398: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
399:
400:
401: -- Standard call to get message count and if count is 1, get message info.
402: FND_MSG_PUB.Count_And_Get

Line 409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

405: );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
410: P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
410: P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
414: ,X_MSG_COUNT => X_MSG_COUNT
415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:

Line 419: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
423: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 423: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

419: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
423: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:

Line 429: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:
428: WHEN OTHERS THEN
429: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
433: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 432: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

428: WHEN OTHERS THEN
429: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
433: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
434: ,X_MSG_COUNT => X_MSG_COUNT
435: ,X_MSG_DATA => X_MSG_DATA
436: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 433: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

429: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
433: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
434: ,X_MSG_COUNT => X_MSG_COUNT
435: ,X_MSG_DATA => X_MSG_DATA
436: ,X_RETURN_STATUS => X_RETURN_STATUS);
437: End Create_REQUIREMENT_LINES;

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

474: END IF;
475:
476:
477: -- Debug Message
478: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
479:
480:
481: -- Initialize API return status to SUCCESS
482: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

485: -- API body
486: --
487:
488: -- Debug Message
489: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
490:
491: -- Convert the values to ids
492: --
493: Convert_RQL_Values_To_Ids (

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

527: END IF;
528:
529:
530: -- Debug Message
531: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
532:
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get

Line 542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

538: );
539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
547: ,X_MSG_COUNT => X_MSG_COUNT
548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);
550:

Line 552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);
550:
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560:

Line 562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);
560:
561: WHEN OTHERS THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

561: WHEN OTHERS THEN
562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

562: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
563: P_API_NAME => L_API_NAME
564: ,P_PKG_NAME => G_PKG_NAME
565: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
566: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
567: ,X_MSG_COUNT => X_MSG_COUNT
568: ,X_MSG_DATA => X_MSG_DATA
569: ,X_RETURN_STATUS => X_RETURN_STATUS);
570: End Update_REQUIREMENT_LINES;

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

610: END IF;
611:
612:
613: -- Debug Message
614: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
615:
616:
617: -- Initialize API return status to SUCCESS
618: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

621: -- API body
622: --
623:
624: -- Debug Message
625: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
626:
627: -- Convert the values to ids
628: --
629: Convert_RQL_Values_To_Ids (

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

680: END IF;
681:
682:
683: -- Debug Message
684: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
685:
686:
687: -- Standard call to get message count and if count is 1, get message info.
688: FND_MSG_PUB.Count_And_Get

Line 695: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

691: );
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
696: P_API_NAME => L_API_NAME
697: ,P_PKG_NAME => G_PKG_NAME
698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
699: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 699: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

701: ,X_MSG_DATA => X_MSG_DATA
702: ,X_RETURN_STATUS => X_RETURN_STATUS);
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR 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 => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
709: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 709: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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

Line 715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

711: ,X_MSG_DATA => X_MSG_DATA
712: ,X_RETURN_STATUS => X_RETURN_STATUS);
713:
714: WHEN OTHERS THEN
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

Line 718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

714: WHEN OTHERS THEN
715: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
716: P_API_NAME => L_API_NAME
717: ,P_PKG_NAME => G_PKG_NAME
718: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
720: ,X_MSG_COUNT => X_MSG_COUNT
721: ,X_MSG_DATA => X_MSG_DATA
722: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 719: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB

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