1389: );
1390: END IF;
1391:
1392: -- initialize the message stack
1393: FND_MSG_PUB.Initialize;
1394:
1395: -- get the max batch size from the profile option;
1396: -- default it to 1000 if the profile option is not defined.
1397: l_max_batch_size := NVL( TO_NUMBER
2039: x_errbuff := l_err_text;
2040: x_retcode := l_return_code;
2041:
2042: WHEN OTHERS THEN
2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2044: THEN
2045: FND_MSG_PUB.Add_Exc_Msg
2046: ( G_PKG_NAME
2047: , 'Item_Org_Assignment'
2041:
2042: WHEN OTHERS THEN
2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2044: THEN
2045: FND_MSG_PUB.Add_Exc_Msg
2046: ( G_PKG_NAME
2047: , 'Item_Org_Assignment'
2048: );
2049: END IF;
2047: , 'Item_Org_Assignment'
2048: );
2049: END IF;
2050: x_retcode := RETCODE_ERROR;
2051: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
2052:
2053: END Item_Org_Assignment;
2054:
2055: