DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_GTIN_ATTRS_PVT

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

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

Line 1969: EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows

1965:
1966:
1967: BEGIN
1968:
1969: EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows
1970: ( p_data_set_id => p_batch_id
1971: , p_target_proc_status => G_CM_TO_BE_PROCESSED
1972: , p_inventory_item_id => i.INVENTORY_ITEM_ID
1973: , p_organization_id => i.ORGANIZATION_ID

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

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

Line 1988: ( 'EGO_GTIN_ATTRS_PVT',

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

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

1994:
1995: END ;
1996:
1997:
1998: Write_Debug('After EGO_GTIN_ATTRS_PVT.Get_Gdsn_Intf_Rows: ' || l_return_status);
1999:
2000: IF l_return_status <> G_RET_STS_SUCCESS THEN
2001:
2002: x_return_status := G_RET_STS_WARNING ;

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

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

Line 2087: EGO_GTIN_ATTRS_PVT.Validate_Attributes(

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

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

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

Line 2105: ( 'EGO_GTIN_ATTRS_PVT',

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

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

2110:
2111:
2112: END ;
2113:
2114: Write_Debug('After calling Validation API EGO_GTIN_ATTRS_PVT.Validate_Attributes l_return_status, l_msg_count='||l_return_status||','||l_msg_count);
2115:
2116: IF l_return_status <> G_RET_STS_SUCCESS THEN
2117:
2118: x_return_status := G_RET_STS_WARNING ;