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

Line 2152: ' EGO_ITEM_PUB.Process_Item ' ||

2148: -- Now at last we're ready to call Process_Row on this pending row --
2149: ---------------------------------------------------------------------
2150: l_dynamic_sql :=
2151: ' BEGIN ' ||
2152: ' EGO_ITEM_PUB.Process_Item ' ||
2153: ' ( ' ||
2154: ' p_api_version => 1' ||
2155: ' ,p_init_msg_list => FND_API.G_FALSE ' ||
2156: ' ,p_commit => FND_API.G_FALSE ' ||

Line 2181: -- Assumption. EGO_ITEM_PUB.Process_Item's param for attribute data

2177: FOR j IN l_attr_name_value_pairs.FIRST .. l_attr_name_value_pairs.LAST
2178: LOOP
2179:
2180: ---------------------------------------------------------------------
2181: -- Assumption. EGO_ITEM_PUB.Process_Item's param for attribute data
2182: -- is P_ + DB Column Name
2183: ---------------------------------------------------------------------
2184:
2185: -----------------------------

Line 2199: l_num_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;

2195: IF l_num_value IS NOT NULL
2196: THEN
2197: IF l_num_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
2198: THEN
2199: l_num_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;
2200: END IF;
2201:
2202: l_dynamic_sql := l_dynamic_sql ||
2203: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || TO_CHAR(l_num_value) ;

Line 2209: l_char_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

2205: ELSIF l_char_value IS NOT NULL
2206: THEN
2207: IF l_char_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR
2208: THEN
2209: l_char_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
2210: END IF;
2211:
2212: l_dynamic_sql := l_dynamic_sql ||
2213: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || '''' || l_char_value || '''' ;

Line 2219: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;

2215: ELSIF l_date_value IS NOT NULL
2216: THEN
2217: IF l_date_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE
2218: THEN
2219: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
2220: END IF;
2221:
2222: l_dynamic_sql := l_dynamic_sql ||
2223: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || ' TO_DATE( ''' || l_date_value_char || ''', ''' || EGO_USER_ATTRS_COMMON_PVT.G_DATE_FORMAT || ''') ';

Line 2240: Write_Debug('EGO_ITEM_PUB.Process_Item call: ' || l_dynamic_sql);

2236: l_item_number := GetItemNumber(p_inventory_item_id => l_inventory_item_id
2237: , p_organization_id => l_organization_id) ;
2238: end if;
2239:
2240: Write_Debug('EGO_ITEM_PUB.Process_Item call: ' || l_dynamic_sql);
2241: Write_Debug('---------------------------------- ' );
2242: Write_Debug('l_mode_for_current_row: ' || l_mode_for_current_row);
2243: Write_Debug('l_inventory_item_id: ' || to_char(l_inventory_item_id));
2244: Write_Debug('l_organization_id: ' || to_char(l_organization_id));

Line 2272: Write_Debug('After calling EGO_ITEM_PUB.Process_Item' );

2268: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2269: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2270:
2271:
2272: Write_Debug('After calling EGO_ITEM_PUB.Process_Item' );
2273: Write_Debug('---------------------------------- ' );
2274: Write_Debug('l_return_status: ' || l_return_status);
2275: Write_Debug('l_msg_count: ' || to_char(l_msg_count));
2276: Write_Debug('l_msg_data: ' || l_msg_data);

Line 2393: ( p_pkg_name => 'EGO_ITEM_PUB' ,

2389:
2390: WHEN OTHERS THEN
2391:
2392: FND_MSG_PUB.Add_Exc_Msg
2393: ( p_pkg_name => 'EGO_ITEM_PUB' ,
2394: p_procedure_name => 'Process_Item',
2395: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2396: );
2397:

Line 2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');

2396: );
2397:
2398:
2399: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2401: FND_MSG_PUB.Add;
2402:
2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));

2399: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2401: FND_MSG_PUB.Add;
2402:
2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405:
2406: END ;
2407:

Line 2441: Write_Debug('EGO_ITEM_PUB.Process_Item failed . .. ' );

2437: x_return_status := l_return_status;
2438: x_msg_count := l_msg_count;
2439: x_msg_data := l_msg_data;
2440:
2441: Write_Debug('EGO_ITEM_PUB.Process_Item failed . .. ' );
2442: Write_Debug('Output - Return Stattus: ' || l_return_status);
2443: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2444: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2445:

Line 2447: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');

2443: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2444: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2445:
2446: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2447: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2448: FND_MSG_PUB.Add;
2449:
2450: RAISE FND_API.G_EXC_ERROR ;
2451:

Line 3049: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3045:
3046: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3047: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3048:
3049: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3050: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3051: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3052:
3053: l_installed_flag VARCHAR2(1) ;

Line 3050: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3046: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3047: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3048:
3049: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3050: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3051: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3052:
3053: l_installed_flag VARCHAR2(1) ;
3054: l_lang_code VARCHAR2(4);

Line 3051: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;

3047: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3048:
3049: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3050: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3051: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3052:
3053: l_installed_flag VARCHAR2(1) ;
3054: l_lang_code VARCHAR2(4);
3055: l_nls_lang VARCHAR2(64);

Line 3440: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3436: --
3437: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3438: -- using dynamic SQL
3439: -- So NO NEED TO Constuct this
3440: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3441: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3442: --
3443: -- ELSIF (l_attr_metadata_obj IS NOT NULL AND
3444: -- l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND

Line 3441: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3437: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3438: -- using dynamic SQL
3439: -- So NO NEED TO Constuct this
3440: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3441: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3442: --
3443: -- ELSIF (l_attr_metadata_obj IS NOT NULL AND
3444: -- l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND
3445: -- l_current_column_index IS NOT NULL )

Line 3920: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3916: --
3917: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3918: -- using dynamic SQL
3919: -- So NO NEED TO Constuct this
3920: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3921: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3922: --
3923: /************************************************************/
3924: IF (l_attr_metadata_obj IS NOT NULL AND

Line 3921: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3917: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3918: -- using dynamic SQL
3919: -- So NO NEED TO Constuct this
3920: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3921: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3922: --
3923: /************************************************************/
3924: IF (l_attr_metadata_obj IS NOT NULL AND
3925: l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND