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_GTIN_PVT dependencies on EGO_GTIN_PVT

Line 1: PACKAGE BODY EGO_GTIN_PVT AS

1: PACKAGE BODY EGO_GTIN_PVT AS
2: /* $Header: EGOUCCPB.pls 120.19 2007/03/27 16:59:46 dsakalle ship $ */
3:
4: g_pkg_name VARCHAR2(30) := 'EGO_UCCNET_PUBLICATION_PUB';
5: g_app_name VARCHAR2(3) := 'EGO';

Line 24: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_module => 'EGO_GTIN_PVT',

20: * Purpose : This method will write debug information to the standard debug
21: **************************************************************************/
22: PROCEDURE WRITE_DEBUG_LOG(p_message IN varchar2) IS
23: BEGIN
24: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_module => 'EGO_GTIN_PVT',
25: p_message => p_message);
26: END WRITE_DEBUG_LOG;
27:
28: -------------------------------------------

Line 1413: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1409: AND MCI.CUSTOMER_ID = ACCT_SITE.CUST_ACCOUNT_ID
1410: AND MCI.ADDRESS_ID = ACCT_SITE.CUST_ACCT_SITE_ID;
1411:
1412: BEGIN
1413: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1414: write_debug_log('Item ID , Org ID = '||p_inventory_item_id||','||p_organization_id);
1415: FOR i IN p_attribute_names.FIRST..p_attribute_names.LAST LOOP
1416: FOR j IN l_reg_attr_list.FIRST..l_reg_attr_list.LAST LOOP
1417: IF UPPER(p_attribute_names(i)) = UPPER(l_reg_attr_list(j)) THEN

Line 1561: write_debug_log('End - EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1557: x_return_status := 'S';
1558: x_msg_count := 0;
1559: x_msg_data := NULL;
1560:
1561: write_debug_log('End - EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1562: EXCEPTION WHEN OTHERS THEN
1563:
1564: x_return_status := 'U';
1565: x_msg_data := SQLERRM;

Line 1609: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1605: OR DISPOSITION_CODE IS NULL
1606: )
1607: GROUP BY PARTY_SITE_ID;
1608: BEGIN
1609: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1610: write_debug_log('Item ID , Org ID, Attr_Group_Name = '||p_inventory_item_id||','||p_organization_id||','||p_attr_group_name);
1611:
1612: BEGIN
1613: SELECT AGV_NAME, ATTR_GROUP_ID INTO l_view_name, l_attr_group_id

Line 1629: write_debug_log('Exiting EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1625: AND ORGANIZATION_ID = p_organization_id;
1626:
1627: EXIT;
1628: END LOOP;
1629: write_debug_log('Exiting EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1630: x_return_status := 'S';
1631: x_msg_count := 0;
1632: x_msg_data := NULL;
1633: RETURN;

Line 1733: write_debug_log('End - EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1729: x_return_status := 'S';
1730: x_msg_count := 0;
1731: x_msg_data := NULL;
1732:
1733: write_debug_log('End - EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1734: EXCEPTION WHEN OTHERS THEN
1735: x_return_status := 'U';
1736: x_msg_data := SQLERRM;
1737: x_msg_count := 1;

Line 1815: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_UCCNET_ATTRIBUTES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

1811: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
1812: l_error_message VARCHAR2(2000);
1813: l_item_catalog_group_id NUMBER;
1814: BEGIN
1815: write_debug_log('Entering EGO_GTIN_PVT.PROCESS_UCCNET_ATTRIBUTES ... Date and Time - '||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1816: FOR i IN c_upated_items LOOP
1817: write_debug_log('Item ID , Org ID = '||i.inventory_item_id||','||i.organization_id);
1818: l_error := FALSE;
1819: l_msib_upd_reqd := FALSE;

Line 2074: EGO_GTIN_PVT.Item_Propagate_Attributes

2070: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2071: (EGO_COL_NAME_VALUE_PAIR_OBJ('DATA_LEVEL', 'EGO_ITEM'));
2072:
2073: -- achampan: add call to item_propagate_attributes
2074: EGO_GTIN_PVT.Item_Propagate_Attributes
2075: ( p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
2076: , p_class_code_name_value_pairs => l_class_code_name_value_pairs
2077: , p_data_level_name_value_pairs => l_data_level_name_value_pairs
2078: , p_attr_diffs => l_attr_diffs

Line 2085: write_debug_log('Before calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ...');

2081: );
2082:
2083: END IF;
2084:
2085: write_debug_log('Before calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ...');
2086: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
2087: p_inventory_item_id => i.inventory_item_id,
2088: p_organization_id => i.organization_id,
2089: p_attribute_names => l_attribute_names,

Line 2086: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(

2082:
2083: END IF;
2084:
2085: write_debug_log('Before calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ...');
2086: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
2087: p_inventory_item_id => i.inventory_item_id,
2088: p_organization_id => i.organization_id,
2089: p_attribute_names => l_attribute_names,
2090: p_commit => FND_API.G_FALSE,

Line 2095: write_debug_log('After calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ... return_status, error = '||l_return_status||' , '||l_msg_text);

2091: x_return_status => l_return_status,
2092: x_msg_count => l_msg_count,
2093: x_msg_data => l_msg_text);
2094:
2095: write_debug_log('After calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES from IOI ... return_status, error = '||l_return_status||' , '||l_msg_text);
2096: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2097: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
2098: SET process_flag = 3
2099: WHERE rowid = i.rowid;

Line 2120: write_debug_log('End calling EGO_GTIN_PVT.PROCESS_UCCNET_ATTRIBUTES...');

2116: END IF; -- if k > 0 i.e. if new attribute values are not equal to old attribute values
2117: END IF; -- end if not l_error
2118: END IF; -- if l_gdsn_outbound_enabled_flag = Y
2119: END LOOP;
2120: write_debug_log('End calling EGO_GTIN_PVT.PROCESS_UCCNET_ATTRIBUTES...');
2121: END PROCESS_UCCNET_ATTRIBUTES;
2122:
2123: /*
2124: ** Added by Devendra - This method will update the REGISTRATION_UPDATE_DATE and TP_NEUTRAL_UPDATE_DATE

Line 5140: END EGO_GTIN_PVT;

5136: x_msg_data := SQLERRM;
5137: x_msg_count := 1;
5138: END PROCESS_GTID_UPDATE;
5139:
5140: END EGO_GTIN_PVT;