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 2053: * program and when p_log_errors is passed as FND_API.G_TRUE).

2049: * @param p_init_error_handler Indicates whether to initialize
2050: * ERROR_HANDLER message stack (and open debug session, if applicable).
2051: * @param p_write_to_concurrent_log Indicates whether to log ERROR_HANDLER
2052: * messages to concurrent log (only applicable when called from concurrent
2053: * program and when p_log_errors is passed as FND_API.G_TRUE).
2054: * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
2055: * message stack. Refer to the package description of the parameter
2056: * 'p_init_msg_list' above for more information about this parameter
2057: * and a list of valid values.

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

2056: * 'p_init_msg_list' above for more information about this parameter
2057: * and a list of valid values.
2058: * @param p_log_errors Indicates whether to write ERROR_HANDLER message
2059: * stack to MTL_INTERFACE_ERRORS, concurrent log (if applicable), and
2060: * debug file (if applicable); if FND_API.G_FALSE is passed, messages
2061: * will still be added to ERROR_HANDLER, but the message stack will not
2062: * be written to any destination.
2063: * @param p_add_errors_to_fnd_stack Indicates whether messages written
2064: * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB

Line 2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2094: ,p_entity_id IN NUMBER DEFAULT NULL
2095: ,p_entity_index IN NUMBER DEFAULT NULL
2096: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2097: ,p_debug_level IN NUMBER DEFAULT 0
2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE

2095: ,p_entity_index IN NUMBER DEFAULT NULL
2096: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2097: ,p_debug_level IN NUMBER DEFAULT 0
2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2096: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2097: ,p_debug_level IN NUMBER DEFAULT 0
2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,x_failed_row_id_list OUT NOCOPY VARCHAR2

Line 2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

2097: ,p_debug_level IN NUMBER DEFAULT 0
2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2105: ,x_return_status OUT NOCOPY VARCHAR2

Line 2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2098: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2105: ,x_return_status OUT NOCOPY VARCHAR2
2106: ,x_errorcode OUT NOCOPY NUMBER

Line 2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2099: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2100: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2101: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2102: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2103: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2104: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2105: ,x_return_status OUT NOCOPY VARCHAR2
2106: ,x_errorcode OUT NOCOPY NUMBER
2107: ,x_msg_count OUT NOCOPY NUMBER

Line 2174: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2170: ,p_entity_id IN NUMBER DEFAULT NULL
2171: ,p_entity_index IN NUMBER DEFAULT NULL
2172: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2173: ,p_debug_level IN NUMBER DEFAULT 0
2174: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2175: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2176: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2177: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2178: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE

Line 2175: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2171: ,p_entity_index IN NUMBER DEFAULT NULL
2172: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2173: ,p_debug_level IN NUMBER DEFAULT 0
2174: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2175: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2176: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2177: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2178: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2179: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE

Line 2176: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

2172: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2173: ,p_debug_level IN NUMBER DEFAULT 0
2174: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2175: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2176: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2177: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2178: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2179: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2180: ,x_return_status OUT NOCOPY VARCHAR2

Line 2177: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2173: ,p_debug_level IN NUMBER DEFAULT 0
2174: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2175: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2176: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2177: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2178: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2179: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2180: ,x_return_status OUT NOCOPY VARCHAR2
2181: ,x_errorcode OUT NOCOPY NUMBER

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

2506: */
2507:
2508: PROCEDURE Process_Item_Revision(
2509: p_api_version IN NUMBER
2510: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2511: ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2512: ,p_transaction_type IN VARCHAR2
2513: ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
2514: ,p_item_number IN VARCHAR2 DEFAULT G_MISS_CHAR

Line 2609: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE

2605:
2606: PROCEDURE Process_item_descr_elements
2607: (
2608: p_api_version IN NUMBER
2609: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2610: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2611: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
2612: , p_inventory_item_id IN NUMBER DEFAULT -999
2613: , p_item_number IN VARCHAR2 DEFAULT NULL

Line 2610: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE

2606: PROCEDURE Process_item_descr_elements
2607: (
2608: p_api_version IN NUMBER
2609: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2610: , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2611: , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
2612: , p_inventory_item_id IN NUMBER DEFAULT -999
2613: , p_item_number IN VARCHAR2 DEFAULT NULL
2614: , p_item_desc_element_table IN INV_ITEM_CATALOG_ELEM_PUB.ITEM_DESC_ELEMENT_TABLE

Line 2662: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2658: */
2659: PROCEDURE Process_Item_Cat_Assignment
2660: (
2661: p_api_version IN NUMBER
2662: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2663: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2664: , p_category_id IN NUMBER
2665: , p_category_set_id IN NUMBER
2666: , p_old_category_id IN NUMBER DEFAULT NULL --- added bug bug 10091928

Line 2663: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2659: PROCEDURE Process_Item_Cat_Assignment
2660: (
2661: p_api_version IN NUMBER
2662: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2663: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2664: , p_category_id IN NUMBER
2665: , p_category_set_id IN NUMBER
2666: , p_old_category_id IN NUMBER DEFAULT NULL --- added bug bug 10091928
2667: , p_inventory_item_id IN NUMBER

Line 2729: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

2725: ,p_multi_row_attrs_table IN UCCnet_Attrs_Multi_Row_Tbl_Typ
2726: ,p_entity_id IN NUMBER DEFAULT NULL
2727: ,p_entity_index IN NUMBER DEFAULT NULL
2728: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2729: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2730: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2731: ,x_return_status OUT NOCOPY VARCHAR2
2732: ,x_errorcode OUT NOCOPY NUMBER
2733: ,x_msg_count OUT NOCOPY NUMBER

Line 2730: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2726: ,p_entity_id IN NUMBER DEFAULT NULL
2727: ,p_entity_index IN NUMBER DEFAULT NULL
2728: ,p_entity_code IN VARCHAR2 DEFAULT NULL
2729: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2730: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2731: ,x_return_status OUT NOCOPY VARCHAR2
2732: ,x_errorcode OUT NOCOPY NUMBER
2733: ,x_msg_count OUT NOCOPY NUMBER
2734: ,x_msg_data OUT NOCOPY VARCHAR2);