DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_GTIN_ATTRS_PVT

Line 1960: Write_Debug('EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows. . . : ' || to_char(p_batch_id));

1956: -- Logic Here
1957: FOR i IN c_intf_rows LOOP
1958:
1959: Write_Debug('Populating local array for Item, Org='||i.INVENTORY_ITEM_ID||','||i.ORGANIZATION_ID);
1960: Write_Debug('EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows. . . : ' || to_char(p_batch_id));
1961:
1962:
1963: l_return_status := NULL;
1964: l_msg_count := NULL;

Line 1973: EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows

1969:
1970:
1971: BEGIN
1972:
1973: EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows
1974: ( p_data_set_id => p_batch_id
1975: , p_target_proc_status => G_CM_TO_BE_PROCESSED
1976: , p_inventory_item_id => i.INVENTORY_ITEM_ID
1977: , p_organization_id => i.ORGANIZATION_ID

Line 1988: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));

1984:
1985: EXCEPTION
1986:
1987: WHEN OTHERS THEN
1988: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
1989: Write_Debug('Error:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)) ;
1990:
1991: FND_MSG_PUB.Add_Exc_Msg
1992: ( 'EGO_GTIN_ATTRS_PVT',

Line 1992: ( 'EGO_GTIN_ATTRS_PVT',

1988: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
1989: Write_Debug('Error:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)) ;
1990:
1991: FND_MSG_PUB.Add_Exc_Msg
1992: ( 'EGO_GTIN_ATTRS_PVT',
1993: 'Get_Gdsn_Intf_Rows' ,
1994: SQLERRM ) ;
1995:
1996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2002: Write_Debug('After EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows: ' || l_return_status);

1998:
1999: END ;
2000:
2001:
2002: Write_Debug('After EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows: ' || l_return_status);
2003:
2004: IF l_return_status <> G_RET_STS_SUCCESS THEN
2005:
2006: x_return_status := G_RET_STS_WARNING ;

Line 2090: Write_Debug('Calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));

2086: Write_Debug('After Merging existing pending change data') ;
2087:
2088: BEGIN
2089:
2090: Write_Debug('Calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
2091: EGO_GTIN_ATTRS_PVT.Validate_Attributes(
2092: p_inventory_item_id => i.INVENTORY_ITEM_ID
2093: ,p_organization_id => i.ORGANIZATION_ID
2094: ,p_singe_row_attrs_rec => l_single_row_attrs

Line 2091: EGO_GTIN_ATTRS_PVT.Validate_Attributes(

2087:
2088: BEGIN
2089:
2090: Write_Debug('Calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
2091: EGO_GTIN_ATTRS_PVT.Validate_Attributes(
2092: p_inventory_item_id => i.INVENTORY_ITEM_ID
2093: ,p_organization_id => i.ORGANIZATION_ID
2094: ,p_singe_row_attrs_rec => l_single_row_attrs
2095: ,p_multi_row_attrs_tbl => l_multi_row_attrs

Line 2105: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));

2101:
2102: EXCEPTION
2103:
2104: WHEN OTHERS THEN
2105: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
2106: Write_Debug('Error:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)) ;
2107:
2108: FND_MSG_PUB.Add_Exc_Msg
2109: ( 'EGO_GTIN_ATTRS_PVT',

Line 2109: ( 'EGO_GTIN_ATTRS_PVT',

2105: Write_Debug('While calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes: ' || to_char(p_batch_id));
2106: Write_Debug('Error:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)) ;
2107:
2108: FND_MSG_PUB.Add_Exc_Msg
2109: ( 'EGO_GTIN_ATTRS_PVT',
2110: 'Validate_Attributes' ,
2111: SQLERRM ) ;
2112:
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2118: Write_Debug('After calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes l_return_status, l_msg_count='||l_return_status||','||l_msg_count);

2114:
2115:
2116: END ;
2117:
2118: Write_Debug('After calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes l_return_status, l_msg_count='||l_return_status||','||l_msg_count);
2119:
2120: IF l_return_status <> G_RET_STS_SUCCESS THEN
2121:
2122: x_return_status := G_RET_STS_WARNING ;