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

Line 22: * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

18: *

p_init_msg_list: A one-character flag indicating whether
19: * to initialize the FND_MSG_PUB package's message stack at the
20: * beginning of API processing (which removes any messages that
21: * may exist on the stack from prior processing in the same session).
22: * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

23: *

p_commit: A one-character flag indicating whether to commit
24: * work at the end of API processing. Valid values are
25: * FND_API.G_TRUE and FND_API.G_FALSE.

26: *

x_return_status: A one-character code indicating whether

Line 25: * FND_API.G_TRUE and FND_API.G_FALSE.

21: * may exist on the stack from prior processing in the same session).
22: * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
23: *

p_commit: A one-character flag indicating whether to commit
24: * work at the end of API processing. Valid values are
25: * FND_API.G_TRUE and FND_API.G_FALSE.

26: *

x_return_status: A one-character code indicating whether
27: * any errors occurred during processing (in which case error
28: * messages will be present on the FND_MSG_PUB package's message
29: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,

Line 29: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,

25: * FND_API.G_TRUE and FND_API.G_FALSE.

26: *

x_return_status: A one-character code indicating whether
27: * any errors occurred during processing (in which case error
28: * messages will be present on the FND_MSG_PUB package's message
29: * stack). Valid values are FND_API.G_RET_STS_SUCCESS,
30: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

31: *

x_msg_count: An integer indicating the number of messages
32: * on the FND_MSG_PUB package's message stack at the end of API
33: * processing. For information about how to retrieve messages

Line 30: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

26: *

31: *

x_msg_count: An integer indicating the number of messages
32: * on the FND_MSG_PUB package's message stack at the end of API
33: * processing. For information about how to retrieve messages
34: * from the message stack, refer to FND_MSG_PUB documentation.

Line 67: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'

63:
64: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOPITMS.pls';
65: G_BO_Identifier CONSTANT VARCHAR2(30) := 'ITM';
66:
67: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
68: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
70: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
71:

Line 68: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'

64: G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOPITMS.pls';
65: G_BO_Identifier CONSTANT VARCHAR2(30) := 'ITM';
66:
67: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
68: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
70: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
71:
72: G_MISS_NUM CONSTANT NUMBER := 9.99E125;

Line 69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'

65: G_BO_Identifier CONSTANT VARCHAR2(30) := 'ITM';
66:
67: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
68: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
69: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
70: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
71:
72: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
73: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);

Line 75: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'

71:
72: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
73: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
74: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
75: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
76: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
77:
78: G_TTYPE_CREATE CONSTANT VARCHAR2(20) := 'CREATE';
79: G_TTYPE_DELETE CONSTANT VARCHAR2(20) := 'DELETE';

Line 76: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'

72: G_MISS_NUM CONSTANT NUMBER := 9.99E125;
73: G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
74: G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
75: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
76: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
77:
78: G_TTYPE_CREATE CONSTANT VARCHAR2(20) := 'CREATE';
79: G_TTYPE_DELETE CONSTANT VARCHAR2(20) := 'DELETE';
80: G_TTYPE_UPDATE CONSTANT VARCHAR2(20) := 'UPDATE';

Line 2036: * program and when p_log_errors is passed as FND_API.G_TRUE).

2032: * @param p_init_error_handler Indicates whether to initialize
2033: * ERROR_HANDLER message stack (and open debug session, if applicable).
2034: * @param p_write_to_concurrent_log Indicates whether to log ERROR_HANDLER
2035: * messages to concurrent log (only applicable when called from concurrent
2036: * program and when p_log_errors is passed as FND_API.G_TRUE).
2037: * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
2038: * message stack. Refer to the package description of the parameter
2039: * 'p_init_msg_list' above for more information about this parameter
2040: * and a list of valid values.

Line 2043: * debug file (if applicable); if FND_API.G_FALSE is passed, messages

2039: * 'p_init_msg_list' above for more information about this parameter
2040: * and a list of valid values.
2041: * @param p_log_errors Indicates whether to write ERROR_HANDLER message
2042: * stack to MTL_INTERFACE_ERRORS, concurrent log (if applicable), and
2043: * debug file (if applicable); if FND_API.G_FALSE is passed, messages
2044: * will still be added to ERROR_HANDLER, but the message stack will not
2045: * be written to any destination.
2046: * @param p_add_errors_to_fnd_stack Indicates whether messages written
2047: * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB

Line 2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2077: ,p_entity_id IN NUMBER DEFAULT NULL
2078: ,p_entity_index IN NUMBER DEFAULT NULL
2079: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2080: ,p_debug_level IN NUMBER DEFAULT 0
2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

2078: ,p_entity_index IN NUMBER DEFAULT NULL
2079: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2080: ,p_debug_level IN NUMBER DEFAULT 0
2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2079: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2080: ,p_debug_level IN NUMBER DEFAULT 0
2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2087: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

2080: ,p_debug_level IN NUMBER DEFAULT 0
2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2087: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2

Line 2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2081: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2087: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2
2089: ,x_errorcode OUT NOCOPY NUMBER

Line 2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2082: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2087: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2
2089: ,x_errorcode OUT NOCOPY NUMBER
2090: ,x_msg_count OUT NOCOPY NUMBER

Line 2157: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2153: ,p_entity_id IN NUMBER DEFAULT NULL
2154: ,p_entity_index IN NUMBER DEFAULT NULL
2155: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2156: ,p_debug_level IN NUMBER DEFAULT 0
2157: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2158: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2159: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2161: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2158: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2154: ,p_entity_index IN NUMBER DEFAULT NULL
2155: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2156: ,p_debug_level IN NUMBER DEFAULT 0
2157: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2158: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2159: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2161: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2162: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 2159: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2155: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2156: ,p_debug_level IN NUMBER DEFAULT 0
2157: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2158: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2159: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2161: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2162: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2163: ,x_return_status OUT NOCOPY VARCHAR2

Line 2160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2156: ,p_debug_level IN NUMBER DEFAULT 0
2157: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2158: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2159: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2160: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2161: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2162: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2163: ,x_return_status OUT NOCOPY VARCHAR2
2164: ,x_errorcode OUT NOCOPY NUMBER

Line 2492: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

2488: */
2489:
2490: PROCEDURE Process_Item_Revision(
2491: p_api_version IN NUMBER
2492: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2493: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2494: ,p_transaction_type IN VARCHAR2
2495: ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
2496: ,p_item_number IN VARCHAR2 DEFAULT G_MISS_CHAR

Line 2591: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

2587:
2588: PROCEDURE Process_item_descr_elements
2589: (
2590: p_api_version IN NUMBER
2591: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2592: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2593: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
2594: , p_inventory_item_id IN NUMBER DEFAULT -999
2595: , p_item_number IN VARCHAR2 DEFAULT NULL

Line 2592: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE

2588: PROCEDURE Process_item_descr_elements
2589: (
2590: p_api_version IN NUMBER
2591: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2592: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2593: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
2594: , p_inventory_item_id IN NUMBER DEFAULT -999
2595: , p_item_number IN VARCHAR2 DEFAULT NULL
2596: , p_item_desc_element_table IN INV_ITEM_CATALOG_ELEM_PUB.ITEM_DESC_ELEMENT_TABLE

Line 2643: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2639: */
2640: PROCEDURE Process_Item_Cat_Assignment
2641: (
2642: p_api_version IN NUMBER
2643: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2644: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2645: , p_category_id IN NUMBER
2646: , p_category_set_id IN NUMBER
2647: , p_inventory_item_id IN NUMBER

Line 2644: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2640: PROCEDURE Process_Item_Cat_Assignment
2641: (
2642: p_api_version IN NUMBER
2643: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2644: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2645: , p_category_id IN NUMBER
2646: , p_category_set_id IN NUMBER
2647: , p_inventory_item_id IN NUMBER
2648: , p_organization_id IN NUMBER

Line 2709: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2705: ,p_multi_row_attrs_table IN UCCnet_Attrs_Multi_Row_Tbl_Typ
2706: ,p_entity_id IN NUMBER DEFAULT NULL
2707: ,p_entity_index IN NUMBER DEFAULT NULL
2708: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2709: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2710: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2711: ,x_return_status OUT NOCOPY VARCHAR2
2712: ,x_errorcode OUT NOCOPY NUMBER
2713: ,x_msg_count OUT NOCOPY NUMBER

Line 2710: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2706: ,p_entity_id IN NUMBER DEFAULT NULL
2707: ,p_entity_index IN NUMBER DEFAULT NULL
2708: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2709: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2710: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2711: ,x_return_status OUT NOCOPY VARCHAR2
2712: ,x_errorcode OUT NOCOPY NUMBER
2713: ,x_msg_count OUT NOCOPY NUMBER
2714: ,x_msg_data OUT NOCOPY VARCHAR2);