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.IBE_DSPMGRVALIDATION_GRP dependencies on FND_API

Line 7: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM

3:
4: -----------------------------------------------------------------
5: -- NOTES
6: -- 1. Returns true if the attachment id exists
7: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM
8: -- 3. Return false, if the attachment id does not exist,
9: -- IBE_DSP_ATH_NOT_EXISTS is pushed on the stack
10: ---------------------------------------------------------------------
11: FUNCTION check_attachment_exists(

Line 13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

9: -- IBE_DSP_ATH_NOT_EXISTS is pushed on the stack
10: ---------------------------------------------------------------------
11: FUNCTION check_attachment_exists(
12: p_attachment_id IN NUMBER,
13: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
14: RETURN BOOLEAN
15: IS
16:
17: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';

Line 42: ELSIF p_object_version_number = FND_API.G_MISS_NUM THEN

38:
39: IF (p_attachment_id IS NULL) OR (p_object_version_number IS NULL) THEN
40: RAISE l_ath_not_exists_exception;
41:
42: ELSIF p_object_version_number = FND_API.G_MISS_NUM THEN
43: OPEN attachment_cur(p_attachment_id );
44: FETCH attachment_cur INTO l_exists;
45: IF attachment_cur%NOTFOUND THEN
46: CLOSE attachment_cur;

Line 188: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM

184:
185: -----------------------------------------------------------------
186: -- NOTES
187: -- 1. Returns true if the context id with the context type exists
188: -- 2. Object version number is used if it is not FND_API.G_MISS_NUM
189: -- 3. If the context_id is passed does not exist, an exception is
190: -- raised , and IBE_DSP_CONTEXT_NOT_EXISTS is pushed on the
191: -- message stack
192: ---------------------------------------------------------------------

Line 195: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

191: -- message stack
192: ---------------------------------------------------------------------
193: FUNCTION check_context_exists(p_context_id IN NUMBER,
194: p_context_type IN VARCHAR2,
195: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
196: RETURN boolean
197: IS
198: l_api_name CONSTANT VARCHAR2(40) := 'check_context_exists';
199:

Line 221: if p_object_version_number = FND_API.G_MISS_NUM then

217: BEGIN
218:
219: l_context_type := trim(p_context_type);
220:
221: if p_object_version_number = FND_API.G_MISS_NUM then
222: OPEN context_cur(p_context_id ,l_context_type);
223: FETCH context_cur INTO l_exists;
224: IF context_cur%NOTFOUND
225: THEN

Line 382: p_context_id IN NUMBER := FND_API.G_MISS_NUM)

378: -- message stack
379: ---------------------------------------------------------------------
380: FUNCTION check_context_accessname(p_context_accessname IN VARCHAR2,
381: p_context_type IN VARCHAR2,
382: p_context_id IN NUMBER := FND_API.G_MISS_NUM)
383: RETURN boolean
384: IS
385: l_api_name CONSTANT VARCHAR2(40) := 'check_context_accessname';
386: l_context_accessname VARCHAR2(40);

Line 413: if p_context_id = FND_API.G_MISS_NUM or p_context_id is null then

409:
410: l_context_accessname := trim(p_context_accessname);
411: l_context_type := trim(p_context_type);
412:
413: if p_context_id = FND_API.G_MISS_NUM or p_context_id is null then
414: OPEN context_accessname_cur(l_context_accessname ,l_context_type);
415: FETCH context_accessname_cur INTO l_exists;
416: IF context_accessname_cur%FOUND
417: THEN

Line 739: p_applicable_to IN VARCHAR2 := FND_API.g_miss_char)

735: ---------------------------------------------------------------------
736: FUNCTION check_deliverable_type_exists(
737: p_deliverable_id IN NUMBER,
738: p_item_type IN VARCHAR2,
739: p_applicable_to IN VARCHAR2 := FND_API.g_miss_char)
740: RETURN BOOLEAN
741: IS
742: l_api_name CONSTANT VARCHAR2(40) := 'check_deliverable_type_exists';
743: l_exists NUMBER;

Line 770: if p_applicable_to is null or p_applicable_to = FND_API.g_miss_char or p_item_type = 'MEDIA'

766:
767: l_item_type := trim(p_item_type);
768:
769: --Modified by YAXU on 12/19/2002, do not check the applicable_to for 'MEDIA'
770: if p_applicable_to is null or p_applicable_to = FND_API.g_miss_char or p_item_type = 'MEDIA'
771: then
772: OPEN deliverable_type_cur(p_deliverable_id,l_item_type);
773: FETCH deliverable_type_cur INTO l_exists;
774: IF deliverable_type_cur%FOUND THEN

Line 819: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

815: ---------------------------------------------------------------------
816:
817: FUNCTION check_deliverable_exists(
818: p_deliverable_id IN NUMBER,
819: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
820: RETURN boolean
821: IS
822: l_api_name CONSTANT VARCHAR2(40) := 'check_deliverable_exists';
823:

Line 847: ELSIF p_object_version_number = FND_API.G_MISS_NUM then

843:
844: IF (p_deliverable_id IS NULL) OR (p_object_version_number IS NULL) THEN
845: RAISE l_dlv_not_exists_exception;
846:
847: ELSIF p_object_version_number = FND_API.G_MISS_NUM then
848: OPEN deliverable_cur(p_deliverable_id );
849: FETCH deliverable_cur INTO l_exists;
850: IF deliverable_cur%NOTFOUND THEN
851: CLOSE deliverable_cur;

Line 901: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

897: -- message IBE_DSP_LGL_CTNT_ID_NOT_EXISTS is pushed on the stack
898: ---------------------------------------------------------------------
899:
900: FUNCTION check_lgl_ctnt_id_exists(p_lgl_ctnt_id IN NUMBER,
901: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
902: RETURN boolean
903: IS
904: l_api_name CONSTANT VARCHAR2(40) := 'check_lgl_ctnt_id_exists';
905:

Line 924: if p_object_version_number = FND_API.G_MISS_NUM then

920: l_exists NUMBER;
921: l_return_status boolean := false;
922:
923: BEGIN
924: if p_object_version_number = FND_API.G_MISS_NUM then
925: OPEN lgl_ctnt_cur(p_lgl_ctnt_id );
926: FETCH lgl_ctnt_cur INTO l_exists;
927: IF lgl_ctnt_cur%NOTFOUND
928: THEN

Line 1056: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)

1052: ---------------------------------------------------------------------
1053:
1054: FUNCTION check_msite_exists(
1055: p_msite_id IN NUMBER,
1056: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
1057: RETURN boolean
1058: IS
1059: l_api_name CONSTANT VARCHAR2(40) := 'check_msite_exists';
1060: l_return_status boolean := false;

Line 1090: elsif p_object_version_number = FND_API.G_MISS_NUM then

1086:
1087: if (p_msite_id IS NULL) OR (p_object_version_number IS NULL) THEN
1088: RAISE l_msite_not_exists_exception;
1089:
1090: elsif p_object_version_number = FND_API.G_MISS_NUM then
1091: OPEN msite_cur(p_msite_id );
1092: FETCH msite_cur INTO l_exists;
1093: IF msite_cur%NOTFOUND THEN
1094: CLOSE msite_cur;

Line 1615: AND (p_attachment_id <> FND_API.G_MISS_NUM)

1611:
1612: BEGIN
1613:
1614: IF (p_attachment_id IS NOT NULL)
1615: AND (p_attachment_id <> FND_API.G_MISS_NUM)
1616: AND (p_deliverable_id IS NOT NULL)
1617: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN
1618: OPEN attachment_cur(p_attachment_id, p_deliverable_id);
1619:

Line 1617: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN

1613:
1614: IF (p_attachment_id IS NOT NULL)
1615: AND (p_attachment_id <> FND_API.G_MISS_NUM)
1616: AND (p_deliverable_id IS NOT NULL)
1617: AND (p_deliverable_id <> FND_API.G_MISS_NUM) THEN
1618: OPEN attachment_cur(p_attachment_id, p_deliverable_id);
1619:
1620: FETCH attachment_cur INTO l_exists;
1621: IF attachment_cur%FOUND THEN

Line 1737: RETURN FND_API.g_false;

1733: fetch c_check_lookup into l_count;
1734: CLOSE c_check_lookup;
1735:
1736: IF l_count = 0 THEN
1737: RETURN FND_API.g_false;
1738: ELSE
1739: RETURN FND_API.g_true;
1740: END IF;
1741: END check_lookup_exists;

Line 1739: RETURN FND_API.g_true;

1735:
1736: IF l_count = 0 THEN
1737: RETURN FND_API.g_false;
1738: ELSE
1739: RETURN FND_API.g_true;
1740: END IF;
1741: END check_lookup_exists;
1742:
1743: FUNCTION Check_Media_Object(p_operation IN VARCHAR2,

Line 1752: OR (p_access_name = FND_API.G_MISS_CHAR) THEN

1748: IS
1749: BEGIN
1750: IF (p_operation = 'CREATE') THEN
1751: IF (p_access_name is NULL)
1752: OR (p_access_name = FND_API.G_MISS_CHAR) THEN
1753: -- Access name cannot be null
1754: RETURN -1;
1755: END IF;
1756: IF (p_deliverable_type_code is NULL)

Line 1757: OR (p_deliverable_type_code = FND_API.G_MISS_CHAR) THEN

1753: -- Access name cannot be null
1754: RETURN -1;
1755: END IF;
1756: IF (p_deliverable_type_code is NULL)
1757: OR (p_deliverable_type_code = FND_API.G_MISS_CHAR) THEN
1758: -- Deliverable type code cannot be null
1759: RETURN -2;
1760: ELSE
1761: -- Check content type code for OCM integration

Line 1765: OR (p_applicable_to_code = FND_API.G_MISS_CHAR) THEN

1761: -- Check content type code for OCM integration
1762: NULL;
1763: END IF;
1764: IF (p_applicable_to_code is NULL)
1765: OR (p_applicable_to_code = FND_API.G_MISS_CHAR) THEN
1766: -- Applicable to code cannot be null
1767: RETURN -3;
1768: ELSE
1769: -- Check the lookup code

Line 1772: = FND_API.G_FALSE THEN

1768: ELSE
1769: -- Check the lookup code
1770: IF check_lookup_exists(p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
1771: p_lookup_code => p_applicable_to_code)
1772: = FND_API.G_FALSE THEN
1773: IF p_deliverable_type_code = 'TEMPLATE' THEN
1774: IF check_lookup_exists(p_lookup_type => 'IBE_M_TEMPLATE_APPLI_TO',
1775: p_lookup_code => p_applicable_to_code)
1776: = FND_API.G_FALSE THEN

Line 1776: = FND_API.G_FALSE THEN

1772: = FND_API.G_FALSE THEN
1773: IF p_deliverable_type_code = 'TEMPLATE' THEN
1774: IF check_lookup_exists(p_lookup_type => 'IBE_M_TEMPLATE_APPLI_TO',
1775: p_lookup_code => p_applicable_to_code)
1776: = FND_API.G_FALSE THEN
1777: RETURN -5;
1778: END IF;
1779: ELSIF p_deliverable_type_code = 'MEDIA' THEN
1780: IF check_lookup_exists(p_lookup_type => 'IBE_M_MEDIA_OBJECT_APPLI_TO',

Line 1782: = FND_API.G_FALSE THEN

1778: END IF;
1779: ELSIF p_deliverable_type_code = 'MEDIA' THEN
1780: IF check_lookup_exists(p_lookup_type => 'IBE_M_MEDIA_OBJECT_APPLI_TO',
1781: p_lookup_code => p_applicable_to_code)
1782: = FND_API.G_FALSE THEN
1783: RETURN -6;
1784: END IF;
1785: END IF;
1786: END IF;

Line 1804: IF (p_applicable_to_code <> FND_API.G_MISS_CHAR) THEN

1800: IF (p_applicable_to_code is NULL) THEN
1801: -- Applicable to code cannot be null
1802: RETURN -3;
1803: ELSE
1804: IF (p_applicable_to_code <> FND_API.G_MISS_CHAR) THEN
1805: -- Check the lookup code
1806: IF check_lookup_exists(p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
1807: p_lookup_code => p_applicable_to_code)
1808: = FND_API.G_FALSE THEN

Line 1808: = FND_API.G_FALSE THEN

1804: IF (p_applicable_to_code <> FND_API.G_MISS_CHAR) THEN
1805: -- Check the lookup code
1806: IF check_lookup_exists(p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
1807: p_lookup_code => p_applicable_to_code)
1808: = FND_API.G_FALSE THEN
1809: IF p_deliverable_type_code = 'TEMPLATE' THEN
1810: IF check_lookup_exists(p_lookup_type => 'IBE_M_TEMPLATE_APPLI_TO',
1811: p_lookup_code => p_applicable_to_code)
1812: = FND_API.G_FALSE THEN

Line 1812: = FND_API.G_FALSE THEN

1808: = FND_API.G_FALSE THEN
1809: IF p_deliverable_type_code = 'TEMPLATE' THEN
1810: IF check_lookup_exists(p_lookup_type => 'IBE_M_TEMPLATE_APPLI_TO',
1811: p_lookup_code => p_applicable_to_code)
1812: = FND_API.G_FALSE THEN
1813: RETURN -5;
1814: END IF;
1815: ELSIF p_deliverable_type_code = 'MEDIA' THEN
1816: IF check_lookup_exists(p_lookup_type => 'IBE_M_MEDIA_OBJECT_APPLI_TO',

Line 1818: = FND_API.G_FALSE THEN

1814: END IF;
1815: ELSIF p_deliverable_type_code = 'MEDIA' THEN
1816: IF check_lookup_exists(p_lookup_type => 'IBE_M_MEDIA_OBJECT_APPLI_TO',
1817: p_lookup_code => p_applicable_to_code)
1818: = FND_API.G_FALSE THEN
1819: RETURN -6;
1820: END IF;
1821: END IF;
1822: END IF;

Line 1823: END IF; -- FND_API.G_MISS_CHAR checking

1819: RETURN -6;
1820: END IF;
1821: END IF;
1822: END IF;
1823: END IF; -- FND_API.G_MISS_CHAR checking
1824: END IF;
1825: END IF;
1826: RETURN 0;
1827: END Check_Media_Object;