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

Line 295: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

291: );
292:
293: d_progress := 110;
294:
295: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
296: d_progress := 120;
297: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
298: (
299: p_template_id => p_template_id

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

312: d_progress := 140;
313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
317: END UDA_DEFAULT_ATTRIBUTES;
318:
319: --------------------------------------------------------------------------------------------------------------------
320: --Start of Comments

Line 390: ,p_validate_only => FND_API.G_TRUE

386: ,p_attributes_row_table => x_attributes_row_table
387: ,p_attributes_data_table => x_attr_name_value_pairs
388: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
389: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
390: ,p_validate_only => FND_API.G_TRUE
391: ,x_failed_row_id_list => l_failed_row_id_list
392: ,x_return_status => x_return_status
393: ,x_errorcode => x_errorcode
394: ,x_msg_count => x_msg_count

Line 400: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

396: );
397: d_progress := 30;
398:
399:
400: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
401: d_progress := 40;
402: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
403: (
404: p_template_id => p_template_id

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

417: d_progress := 60;
418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: END UDA_VALIDATE_ATTRIBUTES;
423:
424: PROCEDURE CREATE_ASSOCIATION_ID
425: (

Line 501: ,p_init_msg_list => fnd_api.g_FALSE

497: ,p_attr_group_id => p_attribute_grp_id
498: ,p_enabled_flag => 'Y'
499: ,p_view_privilege_id => NULL
500: ,p_edit_privilege_id => NULL
501: ,p_init_msg_list => fnd_api.g_FALSE
502: ,p_commit => fnd_api.g_FALSE
503: ,x_association_id => p_association_id
504: ,x_return_status => x_return_status
505: ,x_errorcode => x_errorcode

Line 502: ,p_commit => fnd_api.g_FALSE

498: ,p_enabled_flag => 'Y'
499: ,p_view_privilege_id => NULL
500: ,p_edit_privilege_id => NULL
501: ,p_init_msg_list => fnd_api.g_FALSE
502: ,p_commit => fnd_api.g_FALSE
503: ,x_association_id => p_association_id
504: ,x_return_status => x_return_status
505: ,x_errorcode => x_errorcode
506: ,x_msg_count => x_msg_count

Line 873: -- 1. FND_API.G_FALSE [Default]

869: -- 3. EXCLUSIVE - All the Attribute group mentioned in attribute_group_table will be ignored.
870: -- 6. attribute_group_table - PL SQL table of Varchar30 to store Attribute Group Internal Names.
871: -- 7. p_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
872: -- Possible Values are :
873: -- 1. FND_API.G_FALSE [Default]
874: -- 2. FND_API.G_TRUE
875: --OUT:
876: -- 1. x_return_status - Generic Out parameter having return status
877: -- 2. x_msg_count - Generic Out parameter having return msg Count

Line 874: -- 2. FND_API.G_TRUE

870: -- 6. attribute_group_table - PL SQL table of Varchar30 to store Attribute Group Internal Names.
871: -- 7. p_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
872: -- Possible Values are :
873: -- 1. FND_API.G_FALSE [Default]
874: -- 2. FND_API.G_TRUE
875: --OUT:
876: -- 1. x_return_status - Generic Out parameter having return status
877: -- 2. x_msg_count - Generic Out parameter having return msg Count
878: -- 3. x_msg_data - Generic Out parameter having return msg. --Testing:

Line 892: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

888: ,from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
889: ,to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
890: ,copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
891: ,attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
892: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_msg_count OUT NOCOPY NUMBER
895: ,x_msg_data OUT NOCOPY VARCHAR2
896: )IS

Line 964: IF FND_API.To_Boolean(p_commit) THEN

960: PO_LOG.proc_begin(d_module, 'attribute_group_table', attribute_group_table);
961: PO_LOG.proc_begin(d_module, 'p_commit', p_commit);
962: END IF;
963:
964: IF FND_API.To_Boolean(p_commit) THEN
965: SAVEPOINT Copy_Attrs_Data_SP;
966: END IF;
967:
968: SELECT ENTITY_CODE

Line 1021: RAISE FND_API.G_EXC_ERROR;

1017: END IF;
1018: ELSE
1019: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1020: FND_MSG_PUB.add;
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: l_index := from_pk_col_value_pairs.NEXT(l_index);
1024: END LOOP;
1025:

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: END IF;
1060: ELSE
1061: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1062: FND_MSG_PUB.add;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: l_index := to_pk_col_value_pairs.NEXT(l_index);
1066: END LOOP;
1067:

Line 1202: RAISE FND_API.G_EXC_ERROR;

1198: EXCEPTION
1199: WHEN No_Data_Found THEN
1200: FND_MESSAGE.set_name('PO', 'PO_WRONG_ATTR_GROUP');
1201: FND_MSG_PUB.add;
1202: RAISE FND_API.G_EXC_ERROR;
1203: END ;
1204:
1205: l_where_ag_sql := l_where_ag_sql || l_attr_group_id || ',' ;
1206: END LOOP;

Line 1419: IF FND_API.To_Boolean(p_commit) THEN

1415: END LOOP;
1416: CLOSE l_dynamic_cursor;
1417:
1418: d_progress := 090;
1419: IF FND_API.To_Boolean(p_commit) THEN
1420: COMMIT WORK;
1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1423: x_return_status := FND_API.G_RET_STS_SUCCESS;

1419: IF FND_API.To_Boolean(p_commit) THEN
1420: COMMIT WORK;
1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1425:
1426: IF (PO_LOG.d_proc) THEN
1427: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 1434: WHEN FND_API.G_EXC_ERROR THEN

1430: PO_LOG.proc_end(d_module);
1431: END IF;
1432:
1433: EXCEPTION
1434: WHEN FND_API.G_EXC_ERROR THEN
1435: d_progress := 100;
1436: IF FND_API.To_Boolean(p_commit) THEN
1437: ROLLBACK TO Copy_Attrs_Data_SP;
1438: END IF;

Line 1436: IF FND_API.To_Boolean(p_commit) THEN

1432:
1433: EXCEPTION
1434: WHEN FND_API.G_EXC_ERROR THEN
1435: d_progress := 100;
1436: IF FND_API.To_Boolean(p_commit) THEN
1437: ROLLBACK TO Copy_Attrs_Data_SP;
1438: END IF;
1439: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1440: IF (PO_LOG.d_exc) THEN

Line 1444: x_return_status := FND_API.G_RET_STS_ERROR;

1440: IF (PO_LOG.d_exc) THEN
1441: PO_LOG.exc(d_module, d_progress, x_msg_data );
1442: PO_LOG.proc_end(d_module);
1443: END IF;
1444: x_return_status := FND_API.G_RET_STS_ERROR;
1445: WHEN OTHERS THEN
1446: PO_MESSAGE_S.add_exc_msg
1447: ( p_pkg_name => d_pkg_name,
1448: p_procedure_name => d_api_name || '.' || d_progress

Line 1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1447: ( p_pkg_name => d_pkg_name,
1448: p_procedure_name => d_api_name || '.' || d_progress
1449: );
1450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: END AutoCreate_User_Attrs;
1453:
1454:
1455:

Line 1600: -- 1. FND_API.G_FALSE [Default]

1596: -- 3. x_revision_id
1597: -- Is the Revision Id which needs to be created.
1598: -- 4. p_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
1599: -- Possible Values are :
1600: -- 1. FND_API.G_FALSE [Default]
1601: -- 2. FND_API.G_TRUE
1602: --OUT:
1603: -- 1. x_return_status - Generic Out parameter having return status
1604: -- 2. x_msg_count - Generic Out parameter having return msg Count

Line 1601: -- 2. FND_API.G_TRUE

1597: -- Is the Revision Id which needs to be created.
1598: -- 4. p_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
1599: -- Possible Values are :
1600: -- 1. FND_API.G_FALSE [Default]
1601: -- 2. FND_API.G_TRUE
1602: --OUT:
1603: -- 1. x_return_status - Generic Out parameter having return status
1604: -- 2. x_msg_count - Generic Out parameter having return msg Count
1605: -- 3. x_msg_data - Generic Out parameter having return msg.

Line 1616: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1612: (
1613: x_template_id IN NUMBER
1614: ,x_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1615: ,x_revision_id IN NUMBER
1616: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1617: ,x_return_status OUT NOCOPY VARCHAR2
1618: ,x_msg_count OUT NOCOPY NUMBER
1619: ,x_msg_data OUT NOCOPY VARCHAR2
1620: )IS

Line 1725: RAISE FND_API.G_EXC_ERROR;

1721: IF (l_count > 0) THEN
1722: d_progress := 040;
1723: FND_MESSAGE.set_name('PO', 'PO_UDA_REV_ALLREADY_EXISTS');
1724: FND_MSG_PUB.add;
1725: RAISE FND_API.G_EXC_ERROR;
1726: END IF;
1727:
1728: d_progress := 050;
1729: l_new_dtlevel_col_value_pairs :=

Line 1773: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1769: IF PO_LOG.d_stmt THEN
1770: PO_LOG.stmt(d_module,d_progress,'ego_user_attrs_data_pvt.copy_user_attrs_data : Return_status : ', l_return_status);
1771: END IF;
1772:
1773: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776: ELSE
1777: RAISE FND_API.G_EXC_ERROR;

Line 1775: x_return_status := FND_API.G_RET_STS_SUCCESS;

1771: END IF;
1772:
1773: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776: ELSE
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779:

Line 1777: RAISE FND_API.G_EXC_ERROR;

1773: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776: ELSE
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1779:
1780: IF (PO_LOG.d_proc) THEN
1781: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 1787: WHEN FND_API.G_EXC_ERROR THEN

1783: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
1784: PO_LOG.proc_end(d_module);
1785: END IF;
1786: EXCEPTION
1787: WHEN FND_API.G_EXC_ERROR THEN
1788: d_progress := 070;
1789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1790: IF (PO_LOG.d_exc) THEN
1791: PO_LOG.exc(d_module, d_progress, x_msg_data );

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790: IF (PO_LOG.d_exc) THEN
1791: PO_LOG.exc(d_module, d_progress, x_msg_data );
1792: PO_LOG.proc_end(d_module);
1793: END IF;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: WHEN OTHERS THEN
1796: d_progress := 080;
1797: PO_MESSAGE_S.add_exc_msg
1798: ( p_pkg_name => d_pkg_name,

Line 1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1798: ( p_pkg_name => d_pkg_name,
1799: p_procedure_name => d_api_name || '.' || d_progress
1800: );
1801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803: END Archive_Attrs_Data;
1804:
1805: -------------------------------------------------------------------------------
1806: --Start of Comments

Line 1831: -- 1. FND_API.G_FALSE [Default]

1827: --
1828: -- 5. x_attribute_group_table - PL SQL table of Varchar30 to store Attribute Group Internal Names.
1829: -- 6. x_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
1830: -- Possible Values are :
1831: -- 1. FND_API.G_FALSE [Default]
1832: -- 2. FND_API.G_TRUE3.
1833: --OUT:
1834: -- 1. x_return_status - Generic Out parameter having return status--Testing:
1835: -- 2. x_msg_count - Generic Out parameter having return msg Count

Line 1832: -- 2. FND_API.G_TRUE3.

1828: -- 5. x_attribute_group_table - PL SQL table of Varchar30 to store Attribute Group Internal Names.
1829: -- 6. x_commit - Flag to indentify whether the commit has to be done by the API or calling program will perform a commit.
1830: -- Possible Values are :
1831: -- 1. FND_API.G_FALSE [Default]
1832: -- 2. FND_API.G_TRUE3.
1833: --OUT:
1834: -- 1. x_return_status - Generic Out parameter having return status--Testing:
1835: -- 2. x_msg_count - Generic Out parameter having return msg Count
1836: -- 3. x_msg_data - Generic Out parameter having return msg.--End of Comments

Line 1846: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1842: ,x_from_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1843: ,x_to_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
1844: ,x_copy_attribute_groups IN VARCHAR2 DEFAULT 'ALL' -- SPECIFIC / EXCLUSIVE
1845: ,x_attribute_group_table IN PO_TBL_VARCHAR30 DEFAULT NULL
1846: ,x_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1847: ,x_return_status OUT NOCOPY VARCHAR2
1848: ,x_msg_count OUT NOCOPY NUMBER
1849: ,x_msg_data OUT NOCOPY VARCHAR2
1850: ) IS

Line 1932: RAISE FND_API.G_EXC_ERROR;

1928: END IF;
1929: ELSE
1930: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1931: FND_MSG_PUB.add;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: l_index := x_from_pk_col_value_pairs.NEXT(l_index);
1935: END LOOP;
1936:

Line 1981: RAISE FND_API.G_EXC_ERROR;

1977: EXCEPTION
1978: WHEN No_Data_Found THEN
1979: FND_MESSAGE.set_name('PO', 'PO_UDA_WRONG_ATTRIBUTE_GROUP');
1980: FND_MSG_PUB.add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END ;
1983:
1984: l_where_ag_sql := l_where_ag_sql || l_attr_group_id || ',' ;
1985:

Line 2024: RAISE FND_API.G_EXC_ERROR;

2020: IF (l_count > 0) THEN
2021: d_progress := 060;
2022: FND_MESSAGE.set_name('PO', 'PO_UDA_RECORD_ALLREADY_EXISTS');
2023: FND_MSG_PUB.add;
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF; */
2026:
2027: l_get_attr_list_sql := 'SELECT UNIQUE ATTR_GROUP_ID
2028: FROM ' || l_object_dff_cr.l_object_ext_b_table || ' SRC

Line 2045: x_return_status := FND_API.G_RET_STS_SUCCESS;

2041:
2042: IF (LENGTH(l_attr_grp_ids_list) > 0) THEN
2043: l_attr_grp_ids_list := RTRIM(l_attr_grp_ids_list, ',');
2044: ELSE -- bug16361247: No UDA data to copy
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: d_progress := 060;
2048: IF PO_LOG.d_stmt THEN
2049: PO_LOG.stmt(d_module,d_progress,'No UDA Data to copy. Returning with Return_status : ', x_return_status);

Line 2085: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2081: IF PO_LOG.d_stmt THEN
2082: PO_LOG.stmt(d_module,d_progress,'ego_user_attrs_data_pvt.copy_user_attrs_data : Return_status : ', l_return_status);
2083: END IF;
2084: d_progress := 080;
2085: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: ELSE
2089: RAISE FND_API.G_EXC_ERROR;

Line 2087: x_return_status := FND_API.G_RET_STS_SUCCESS;

2083: END IF;
2084: d_progress := 080;
2085: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: ELSE
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:

Line 2089: RAISE FND_API.G_EXC_ERROR;

2085: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: ELSE
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:
2092: IF (PO_LOG.d_proc) THEN
2093: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 2100: WHEN FND_API.G_EXC_ERROR THEN

2096: PO_LOG.proc_end(d_module);
2097: END IF;
2098:
2099: EXCEPTION
2100: WHEN FND_API.G_EXC_ERROR THEN
2101: d_progress := 090;
2102: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2103: IF (PO_LOG.d_exc) THEN
2104: PO_LOG.exc(d_module, d_progress, x_msg_data );

Line 2107: x_return_status := FND_API.G_RET_STS_ERROR;

2103: IF (PO_LOG.d_exc) THEN
2104: PO_LOG.exc(d_module, d_progress, x_msg_data );
2105: PO_LOG.proc_end(d_module);
2106: END IF;
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: WHEN OTHERS THEN
2109: d_progress := 100;
2110: PO_MESSAGE_S.add_exc_msg
2111: ( p_pkg_name => d_pkg_name,

Line 2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2111: ( p_pkg_name => d_pkg_name,
2112: p_procedure_name => d_api_name || '.' || d_progress
2113: );
2114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2116: END Copy_User_Attrs;
2117:
2118: PROCEDURE Merge_Amendment_Address_AG
2119: (

Line 2197: x_return_status := FND_API.G_RET_STS_SUCCESS;

2193: AND requisition_header_id = x_requisition_header_id;
2194:
2195: END LOOP;
2196:
2197: x_return_status := FND_API.G_RET_STS_SUCCESS;
2198: IF (PO_LOG.d_proc) THEN
2199: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2200: PO_LOG.proc_end(d_module);
2201: END IF;

Line 2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2201: END IF;
2202: EXCEPTION
2203: WHEN OTHERS THEN
2204: d_progress := 100;
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: IF (PO_LOG.d_exc) THEN
2207: PO_LOG.exc(d_module, d_progress, 'Unexpected Error in Merge_Amendment_Address_AG'||SQLERRM);
2208: PO_LOG.proc_end(d_module);
2209: END IF;

Line 2293: x_return_status := FND_API.G_RET_STS_SUCCESS;

2289: AND draft_id = -1 ;
2290:
2291: END LOOP;
2292:
2293: x_return_status := FND_API.G_RET_STS_SUCCESS;
2294: IF (PO_LOG.d_proc) THEN
2295: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2296: PO_LOG.proc_end(d_module);
2297: END IF;

Line 2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2297: END IF;
2298: EXCEPTION
2299: WHEN OTHERS THEN
2300: d_progress := 100;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: IF (PO_LOG.d_exc) THEN
2303: PO_LOG.exc(d_module, d_progress, 'Unexpected Error in Merge_Amendment_Address_AG'||SQLERRM);
2304: PO_LOG.proc_end(d_module);
2305: END IF;

Line 2381: x_return_status := FND_API.G_RET_STS_ERROR;

2377: IF (PO_LOG.d_proc) THEN
2378: PO_LOG.proc_end(d_module);
2379: END IF;
2380:
2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: x_err_msg := 'PO_UDA_TEMPLATE_NOT_FOUND';
2383: RETURN NULL;
2384: END IF;
2385:

Line 2404: x_return_status := FND_API.G_RET_STS_SUCCESS;

2400: IF (PO_LOG.d_proc) THEN
2401: PO_LOG.proc_end(d_module);
2402: END IF;
2403:
2404: x_return_status := FND_API.G_RET_STS_SUCCESS;
2405: RETURN l_template_id;
2406:
2407:
2408: EXCEPTION

Line 2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2407:
2408: EXCEPTION
2409: WHEN OTHERS THEN
2410: x_err_msg := 'PO_UDA_TEMPLATE_NOT_FOUND';
2411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412:
2413: IF PO_LOG.d_stmt THEN
2414: PO_LOG.stmt(d_module, d_progress,'exception '|| SQLERRM );
2415: END IF;

Line 2505: x_return_status := FND_API.G_RET_STS_SUCCESS;

2501: x_errorcode := l_errorcode;
2502: x_msg_count := l_msg_count;
2503: x_msg_data := l_msg_data;
2504: ELSE
2505: x_return_status := FND_API.G_RET_STS_SUCCESS;
2506: IF PO_LOG.d_stmt THEN
2507: PO_LOG.stmt(d_module,d_progress,'No Validation Action found for the Attribute Group : '|| p_attribute_group_id );
2508: END IF;
2509: END IF;

Line 2514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2510:
2511: EXCEPTION
2512: WHEN OTHERS THEN
2513:
2514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2515:
2516: IF PO_LOG.d_stmt THEN
2517: PO_LOG.stmt(d_module, d_progress,'exception '|| SQLERRM );
2518: END IF;

Line 2564: x_return_status := FND_API.G_RET_STS_SUCCESS;

2560: l_application_id number;
2561:
2562:
2563: BEGIN
2564: x_return_status := FND_API.G_RET_STS_SUCCESS;
2565: d_progress := 010;
2566: IF (PO_LOG.d_proc) THEN
2567: PO_LOG.proc_begin(d_module);
2568: PO_LOG.proc_begin(d_module, 'p_template_id',p_template_id);

Line 2725: x_return_status := FND_API.G_RET_STS_ERROR;

2721:
2722: EXCEPTION
2723: WHEN ATTR_GRP_REQD then
2724: PO_LOG.exc(d_module,d_progress,'Either attribute group id or attribute group internal name must be specified');
2725: x_return_status := FND_API.G_RET_STS_ERROR;
2726: x_msg_data := 'Either attribute group id or attribute group internal name must be specified' ;
2727: return null;
2728: WHEN ATTR_REQD then
2729: PO_LOG.exc(d_module,d_progress,'Either attribute id or attribute internal name must be specified');

Line 2730: x_return_status := FND_API.G_RET_STS_ERROR;

2726: x_msg_data := 'Either attribute group id or attribute group internal name must be specified' ;
2727: return null;
2728: WHEN ATTR_REQD then
2729: PO_LOG.exc(d_module,d_progress,'Either attribute id or attribute internal name must be specified');
2730: x_return_status := FND_API.G_RET_STS_ERROR;
2731: x_msg_data := 'Either attribute id or attribute internal name must be specified' ;
2732: return null;
2733: when others then
2734: PO_LOG.exc(d_module,d_progress,'Unexpected error: '|| SQLERRM || 'at '||d_progress);

Line 2735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2731: x_msg_data := 'Either attribute id or attribute internal name must be specified' ;
2732: return null;
2733: when others then
2734: PO_LOG.exc(d_module,d_progress,'Unexpected error: '|| SQLERRM || 'at '||d_progress);
2735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2736: x_msg_data := 'Unexpected error: '|| SQLERRM || 'at '||d_progress ;
2737: return null;
2738: END GET_SINGLE_ATTR_VALUE;
2739:

Line 2804: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')

2800: WHERE po_header_id = p_po_header_id;
2801: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_NAME', l_clm_standard_form));
2802: END IF; */
2803:
2804: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
2805: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING') ) THEN
2806: IF PO_LOG.d_stmt THEN
2807: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain and Doc Numbering AGs');
2808: END IF;

Line 2895: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

2891: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
2892: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE' , l_clm_idc_type ));
2893: END IF;
2894:
2895: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
2896: IF PO_LOG.d_stmt THEN
2897: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
2898: END IF;
2899:

Line 2961: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

2957:
2958: l_attr_grp_ids := PO_TBL_NUMBER();
2959:
2960: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
2961: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
2962: IF PO_LOG.d_stmt THEN
2963: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
2964: END IF;
2965:

Line 4724: x_return_status := FND_API.G_RET_STS_SUCCESS;

4720: AND attribute1 = p_idc_type
4721: AND template_id = p_template_id
4722: AND attribute_category = p_attr_category;
4723:
4724: x_return_status := FND_API.G_RET_STS_SUCCESS;
4725: x_attr_group_id := l_attr_group_id;
4726:
4727: IF (PO_LOG.d_proc)
4728: THEN

Line 4736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4732: END IF;
4733:
4734: EXCEPTION
4735: WHEN OTHERS THEN
4736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4737:
4738: IF PO_LOG.d_stmt THEN
4739: PO_LOG.stmt(d_module, d_progress,'exception '|| SQLERRM );
4740: END IF;