DBA Data[Home] [Help]

APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on EGO_ITEM_PUB

Line 2244: ' EGO_ITEM_PUB.Process_Item ' ||

2240: -- Now at last we're ready to call Process_Row on this pending row --
2241: ---------------------------------------------------------------------
2242: l_dynamic_sql :=
2243: ' BEGIN ' ||
2244: ' EGO_ITEM_PUB.Process_Item ' ||
2245: ' ( ' ||
2246: ' p_api_version => 1' ||
2247: ' ,p_init_msg_list => FND_API.G_FALSE ' ||
2248: ' ,p_commit => FND_API.G_FALSE ' ||

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

2267: FOR j IN l_attr_name_value_pairs.FIRST .. l_attr_name_value_pairs.LAST
2268: LOOP
2269:
2270: ---------------------------------------------------------------------
2271: -- Assumption. EGO_ITEM_PUB.Process_Item's param for attribute data
2272: -- is P_ + DB Column Name
2273: ---------------------------------------------------------------------
2274:
2275: -----------------------------

Line 2289: l_num_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;

2285: IF l_num_value IS NOT NULL
2286: THEN
2287: IF l_num_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_NUM
2288: THEN
2289: l_num_value := EGO_ITEM_PUB.G_INTF_NULL_NUM;
2290: END IF;
2291:
2292: l_dynamic_sql := l_dynamic_sql ||
2293: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || TO_CHAR(l_num_value) ;

Line 2299: l_char_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;

2295: ELSIF l_char_value IS NOT NULL
2296: THEN
2297: IF l_char_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_CHAR
2298: THEN
2299: l_char_value := EGO_ITEM_PUB.G_INTF_NULL_CHAR;
2300: END IF;
2301:
2302: l_dynamic_sql := l_dynamic_sql ||
2303: ' , ' || Get_Process_Item_Param(l_attr_name_value_pairs(j).ATTR_NAME) || ' => ' || '''' || l_char_value || '''' ;

Line 2309: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;

2305: ELSIF l_date_value IS NOT NULL
2306: THEN
2307: IF l_date_value = ENG_CHANGE_ATTR_UTIL.G_ATTR_NULL_DATE
2308: THEN
2309: l_date_value := EGO_ITEM_PUB.G_INTF_NULL_DATE;
2310: END IF;
2311:
2312: l_dynamic_sql := l_dynamic_sql ||
2313: ' , ' || 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 2329: Write_Debug('EGO_ITEM_PUB.Process_Item call: ' || l_dynamic_sql);

2325: l_item_number := GetItemNumber(p_inventory_item_id => l_inventory_item_id
2326: , p_organization_id => l_organization_id) ;
2327: end if;
2328:
2329: Write_Debug('EGO_ITEM_PUB.Process_Item call: ' || l_dynamic_sql);
2330: Write_Debug('---------------------------------- ' );
2331: Write_Debug('l_mode_for_current_row: ' || l_mode_for_current_row);
2332: Write_Debug('l_inventory_item_id: ' || to_char(l_inventory_item_id));
2333: Write_Debug('l_organization_id: ' || to_char(l_organization_id));

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

2355: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_count', l_msg_count);
2356: DBMS_SQL.VARIABLE_VALUE(l_dummy_c, 'l_msg_data', l_msg_data);
2357:
2358:
2359: Write_Debug('After calling EGO_ITEM_PUB.Process_Item' );
2360: Write_Debug('---------------------------------- ' );
2361: Write_Debug('l_return_status: ' || l_return_status);
2362: Write_Debug('l_msg_count: ' || to_char(l_msg_count));
2363: Write_Debug('l_msg_data: ' || l_msg_data);

Line 2377: ( p_pkg_name => 'EGO_ITEM_PUB' ,

2373:
2374: WHEN OTHERS THEN
2375:
2376: FND_MSG_PUB.Add_Exc_Msg
2377: ( p_pkg_name => 'EGO_ITEM_PUB' ,
2378: p_procedure_name => 'Process_Item',
2379: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2380: );
2381:

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

2380: );
2381:
2382:
2383: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2384: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2385: FND_MSG_PUB.Add;
2386:
2387: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2383: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2384: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2385: FND_MSG_PUB.Add;
2386:
2387: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389:
2390: END ;
2391:

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

2421: x_return_status := l_return_status;
2422: x_msg_count := l_msg_count;
2423: x_msg_data := l_msg_data;
2424:
2425: Write_Debug('EGO_ITEM_PUB.Process_Item failed . .. ' );
2426: Write_Debug('Output - Return Stattus: ' || l_return_status);
2427: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2428: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2429:

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

2427: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2428: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2429:
2430: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2431: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2432: FND_MSG_PUB.Add;
2433:
2434: RAISE FND_API.G_EXC_ERROR ;
2435:

Line 3033: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3029:
3030: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3031: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3032:
3033: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3034: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3035: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3036:
3037: l_installed_flag VARCHAR2(1) ;

Line 3034: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3030: l_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3031: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3032:
3033: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3034: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3035: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3036:
3037: l_installed_flag VARCHAR2(1) ;
3038: l_lang_code VARCHAR2(4);

Line 3035: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;

3031: l_mul_dynamic_sql VARCHAR2(32767); --the largest a VARCHAR2 can be
3032:
3033: l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3034: l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3035: l_extra_attrs_rec EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP;
3036:
3037: l_installed_flag VARCHAR2(1) ;
3038: l_lang_code VARCHAR2(4);
3039: l_nls_lang VARCHAR2(64);

Line 3424: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3420: --
3421: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3422: -- using dynamic SQL
3423: -- So NO NEED TO Constuct this
3424: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3425: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3426: --
3427: -- ELSIF (l_attr_metadata_obj IS NOT NULL AND
3428: -- l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND

Line 3425: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3421: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3422: -- using dynamic SQL
3423: -- So NO NEED TO Constuct this
3424: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3425: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3426: --
3427: -- ELSIF (l_attr_metadata_obj IS NOT NULL AND
3428: -- l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND
3429: -- l_current_column_index IS NOT NULL )

Line 3904: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;

3900: --
3901: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3902: -- using dynamic SQL
3903: -- So NO NEED TO Constuct this
3904: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3905: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3906: --
3907: /************************************************************/
3908: IF (l_attr_metadata_obj IS NOT NULL AND

Line 3905: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;

3901: -- WE CAN NOT CONSTRUCT following PL/SQL Object dynamically
3902: -- using dynamic SQL
3903: -- So NO NEED TO Constuct this
3904: -- l_single_row_attrs_rec EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP ;
3905: -- l_multi_row_attrs_tbl EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP;
3906: --
3907: /************************************************************/
3908: IF (l_attr_metadata_obj IS NOT NULL AND
3909: l_attr_metadata_obj.ATTR_NAME IS NOT NULL AND